The demand functions built into the EZCube meters are instantaneous demand rather that the fifteen minute demand period usually used in the United States and Canada. Anyone familiar with Microsoft Excel or another spreadsheet program should have no problem getting the peak demand period for any month or other period. The EZCube meters are capable of storing kwh readings on any schedule the user desires. The meter should be set to record the readings somewhere between 4 and 60 times an hour. Use four if the periods are defined as on the hour, 15, 30 and 45 minutes past the hour. Use once a minute if you want the highest usage during any fifteen minute period.

Download the meter readings to a CSV (comma separated variables) file and open it with Excel. Add a formula in a column to the right of the kwh readings and at the end of the first period similar to “=SUM([first reading]:[last reading]) where [first reading] is the cell reference to the first reading of the period and [last reading] is the reference to the cell in the same row with the kwh reading. Now drag that formula down, copying it into every cell in the column all the way to the bottom row. Use the MAX() function to find the greatest value, then search for all instances of the max value. That will let you know when max demand occurred.

For an EZCube IP, open the meter’s web server in a browser. Click ‘Setup’, then “Fast Data Log’. This will let you pick the parameters you want to report. The two you need are ‘7680 kWh High Word’ and ‘7681 kWh Low Word’. You can include others, but it will slow the download and fill up your spreadsheet with unneeded data. Scroll to the bottom of the page and set the logging period and click the ‘Update’ button. When ready to download the data, return to the Setup screen, click ‘System Info’ and choose ‘Fast Data Log’ under the Tools heading. Set the date range you want (times are UTC, not local time. Subtract 7 hours or whatever is appropriate for your time zone) and click the ‘Download CSV File’. Open the file in Excel when it completes and follow the instructions above.