Interval meter readings can be imported in much the same way as invoices. These spreadsheets are much simpler in structure, but contain many more records. At present, reading intervals are assumed to be 1 hour. ManagingEnergy will accept *.xls files which follow these rules:
1. | The top row contains the headers for at least three columns containing either of these two sets of names |
Set 1 |
Date |
Hour |
Gross Energy kWh |
---|---|---|---|
Set 2 |
Date |
Time |
KWH |
2. | No additional rows at the bottom (e.g. summaries, text, notes) |
|
Select the meter node in the navigation tree. If you've picked an interval meter, the Interval Readings Import button will appear.
Note that any overlap in the dates in existing entries and entries that are currently being imported will result in the existing data being overwritten. Make sure that dates are unique and current, and that there is no data in the same range in order to avoid accidental changes to data.
The import process proceeds as a series of steps. Always wait for feedback before moving to the next step.
If you click around or try to move on before a step is complete, you can cause and error and force yourself to start over. |