This is DTE Smart Meter page
Partial Table of Contents
Beta MAIN DTE Smart Meter Energy Book TED MTU Data Format

Notes for sale on
Reading, Collecting, and Using DTE Smart Meter Data
Help Reduce Energy Use


This 40+ page set of notes is available in the DTE service area for $ 10.00 plus shipping, and handling from:

                PO Box 1288
                Ann Arbor, Michigan 48106-1288


                The Betatronics e-mail address is .
                        To view e-mail address enable JavaScript.
                Otherwise use .

Reduce your DTE electric bill by a quantitative analysis of your energy use by using the DTE website and "Smart Meter" data to find where you are unnecessarily using energy.

If you reduced your daily energy consumption by 2.4 kWh, the equivalent of one 100 W bulb on continuously for 24 hours, then this could produce a yearly reduction in you bill of approximately 2.4*365.25*0.16 = $140. A lot of small continuous loads could easily add to 100 W. W is watts, kW is kilowatts, Wh is watt-hours, and kWh is kilowatt-hours, these are electrical units of energy measurement.

The purpose of these notes is to help you make use of your DTE "Smart Meter" data that is available on the DTE website, and directly from the "Smart Meter" face to help reduce your energy use. DTE refers to Smart Meters as AMI meters (Advanced Metering Infrastructure). Detailed quantitative information (data) about your energy use can greatly increase your ability to intelligently find ways to reduce your electrical energy consumption, and thus your electric costs. These notes are a "how to use" discussion.

What you buy from DTE is energy, kWh, plus fees and taxes. You do not buy volts, amperes, volt-amperes, power factor, or other electrical units.

The finest detail (resolution, some use the word granularity) from the DTE website is energy quantized to 0.01 kWh per hour. Nothing finer is presently available. This degree of resolution can help you find excessive power or energy loads, and see changes by season, equipment, and life-style. There is 0.001 kWh resolution at the meter face by means of a dot sequence, but difficult to use.

The DTE meter and data (information, values) from it are discussed in detail. Procedures for reading the meter and getting data from the DTE website are presented. Data that DTE collects from your meter can be viewed (displayed) or downloaded.

Often times the electric power lines leading to the meter are referred to as mains.

The DTE meter directly measures energy used from one point in time to another later time point. Energy is what does real work and is numerically measured in kWh (kilo-watt-hours), and is quantized to 1 kWh at the meter face digital display. At the website resolution is 0.01 kWh.

One Wh (0.001 kWh) resolution at the meter can be obtained by counting step changes in a dot sequence.

Short time average power (watts (W), or kilowatts (kW) ) can be determined from energy change measured over a time period. This informtion can help determine what loads are significant.

Quantitative data (information) from the DTE Smart Meter is an important component of an energy conservation effort. Unless everyone works on conserving energy the cost of electricity is going to increase more rapidly than what it is already increasing. There are various levels to saturation in generation and distribution. Saturation is a type of maximum capability. Where a system operates relative to saturation or maximum load determines long term electrical energy cost, and what capital equipment must be purchased by the power company. Government policies have a great affect on these costs.

Your electric bill is primarily based upon the energy used, kWh, plus some other factors. Do not let a salesman sell or lease to you a box that attaches to your main panel that is claimed to reduce energy consumption. These generally are primarily a capacitor for power factor correction (PFC), and for a home the claims made are a fraud or scam. In demonstrations an ammeter is used showing a big change in a displayed number (amperes), but you do not buy amperes.

A wattmeter in the same experiment will show virtually no change. And watts (power) or kWh (energy) is what you buy. A normal residential homeowner or small business customer is not penalized for poor power factor. Thus, improving your power factor saves you nothing, and does not change your power or energy use as read at your meter.

Stories exist of installations where the customer has paid $1600 for the equipment and installation. Just the power factor correction box alone is many times priced in the $200 to $300 range. You, as a residential customer, can make real savings with conservation, but not with power factor correction capacitors.

A curve simulating a previously available DTE plot is shown below. Another plot below is our creation from exported DTE data. The graphical information can be very informative.

Some of your big energy loads are lights, refrigerators, air conditioners, furnaces, heaters, fans, and entertainment centers.

                        Table of Contents

1.      Introduction

2.      Hourly Power and Energy Data --- DTE "Hourly Use bar chart)"
            2.1 How to find the "Hourly Use (bar chart)"
            2.2 The "Hourly Use (bar chart)" defaults
            2.3 Exporting Data
            2.4 Working with the "Hourly Use (bar chart)" information
            2.5 Analysis of sleep time base load
            2.6 Estimating Average Power of a Load
            2.7 Using the DTE smart meter to estimate loads
            2.8 Studying non-sleep time loads

3.      The other DTE graphs
            3.1 Graph types in the 2 November 2013 program
            3.2 "Compare hourly use" discussion
            3.3 Suggested Graph for you to create
            3.4 A Similar Useful Type Plot

4.      Electric hot water & Engine block heaters, Car chargers, and Air conditioning

Appendix A      Navigating to Your Smart Meter Data on the DTE website

Appendix B      When DTE quantizes energy measurement

Appendix C      The Smart Meter on the Side of Your Home

Appendix D      Smart Meter Short Time Average Power Measurement

Appendix E      Comparison of light sources

Appendix F      Selecting Time Periods for Averaging

Appendix Z      Constants, Conversion Factors, and Formulas


PE1 --- Plot 130508-DTE-DATA-WEEK-M2Yx.

This bar graph plot is derived from data exported from the DTE website, and is an approximation of how the data is displayed on the DTE website for hourly use, and a week period. We have used hours in the week instead of dates for the X-axis. DTE does not provide this chart anymore. However, you can create this type plot from downloaded data.

The finest time resolution on the DTE site is energy averaged over a one hour period.

Sleep time is obvious and much more consistent than other times in the day. Also similar from day to day.


PE2 --- Plot 130508-DTE-DATA-WEEK-M2Yx.

This is a dot and step plot derived from exported DTE website data.

Each blue dot represents the energy for one hour of one day in the included date range. The distribution of dots for a particular hour provides information on the variance in energy use over the time range for that time of day. The four dots above 3 kW are an abnormal one day condition when 3 kW of electric heat was being used in the garage on a cold day.

The step plot, in red, is the average of all of the blue dots for the associated hour.

The step plot during the sleep time period provides a good estimate of base load. Base load is an average load that is relatively constant throughout a day.


This web page section has Excel equations for use with exported data from the DTE website. In Windows you can copy each equation and paste it into the specified cell in the DTE Excel spreadsheet. These equations provide a means to average the hourly energy use over many days or weeks. As provided below these equations are 7 day weeks, and for 12 weeks.


Put 7 in cell J15. Copy J15 to K15..U15 and paste. Manually adjust 7 to the number of non-zero days in the column's week in cells J15 thru U15.

Copy each of the following equations into their specified cell, and paste for 12 week average.

=($E16+$E40+$E64+$E88+$E112+$E136+$E160)/J$15 ........................ in cell J16.
=($E184+$E208+$E232+$E256+$E280+$E304+$E328)/J$15 ................ in cell K16.
=($E352+$E376+$E400+$E424+$E448+$E472+$E496)/J$15 ................ in cell L16.
=($E520+$E544+$E568+$E592+$E616+$E640+$E664)/J$15 ................ in cell M16.
=($E688+$E712+$E736+$E760+$E784+$E808+$E832)/J$15 ................ in cell N16.
=($E856+$E880+$E904+$E928+$E952+$E976+$E1000)/J$15 .............. in cell O16.
=($E1024+$E1048+$E1072+$E1096+$E1120+$E1144+$E1168)/J$15 ... in cell P16.
=($E1192+$E1216+$E1240+$E1264+$E1288+$E1312+$E1336)/J$15 ... in cell Q16.
=($E1360+$E1384+$E1408+$E1432+$E1456+$E1480+$E1504)/J$15 ... in cell R16.
=($E1528+$E1552+$E1576+$E1600+$E1624+$E1648+$E1672)/J$15 ... in cell S16.
=($E1696+$E1720+$E1744+$E1768+$E1792+$E1816+$E1840)/J$15 ... in cell T16.
=($E1864+$E1888+$E1912+$E1936+$E1960+$E1984+$E2008)/J$15 ... in cell U16.

Copy J16..U16 to J17..J40, and paste.
Format J16..U40 as Number 3 places.

To create the 12 week averages put the equation

=(J16+K16+L16+M16+N16+O16+P16+Q16+R16+S16+T16+U16)/12 ... in cell W16.

Copy W16 to cells W17..W40, and paste.
Format W16..W40 as Number 3 places.

Betatronics Main Page at
INFORMATION on Henry Ford Museum, Greenfield Village, & Ford Rouge Factory Tours at

Copyright©   2014   Gordon A. Roberts    All rights reserved.     141130-1139


PO Box 1288, Ann Arbor, MIchigan 48106-1288
voice 734-930-6136
This web site is
This page is
Our e-mail address is . To view e-mail address enable JavaScript.
Otherwise use .