
Manual WS.502 v1.5
2-Wire Energy Monitor
27
15. EXPORT SUBTOTALS
It can be useful if you want to calculate consumption
over a certain period of time, and even attach an
(approximate) cost to it.
For this, in the menu on the left, click
'SUBTOTALS'.
The image below now appears.
Click on the field next to START
DATE
and you'll see a
calendar now. Select the start date for the desired
period. You do the same for the end date (END
DATE)
(standard it is at the current time)
Afterwards, click on the
'CALCULATE'
key.
1.
The screen will now show all the intermediate
totals of the log channels.
2.
(LOG channels of CO2 or temperature are not
included in this table, only 'consumers')
3.
The waiting time for the calculation can vary
depending on the period and the number of
channels. (e.g. Period 9 months, with 20
channels can last about 8 sec)
An example:
The table first states the name, that the meter
position of the start time (STARTVALUE), meter
position of the end time (ENDVALUE), the difference
between the two (DIFF), the unit (UNITS) and the
(approximate) cost (COST). This price was calculated
according to the entered values in the 'SETTINGS'.
In the
'Search'
field, you can type in part of a name and
then only the consumers areshown the keyword in
their name.
At the top of the table there are now some 'buttons':
allows us to
export
the table shown with the file name
= 'SUBTOTALS ENERGY jaar_maand-day-hour-minute',
and the extension:
1.
EXCEL
: ‘.xlsx’
2.
JSON
: ‘.json’
3.
CSV
: ‘.csv’
4.
: ‘.pdf’
With the
'PRINT'
key we can print out this table
immediately.
Na. The export choices 'EXCEL', 'JSON' are not
supported on many tablets (certainly not
IPAD), full support under Microsoft windows
Operation:
The counter positions
of each meter ( Modbus and
pulse) are logged every minute and stored on the
internal SD card as a value for up to 3 years. The
counter positions shown in SUBTOTALS is the counter
position at 00.00 hr start day and this at 23.59 hours
end day.
However, if for a given day the final counter > starting
counter was replacedby, forexample, the Modbus
meter that day, or because the voltage on a pulse
counter was interrupted so that it starts at zero, or
because you create a new meter on an existing
modbus address without first erasing it, then the
starting counter for that day is assumed as zero in the
calculation of the DIFF and COST for that day.
DIFF and COST
are calculated every day and the result
is stored and stored for up to 3years. For example, if
you set a 12-day period, the 12 DIFF's and the 12
COST's are added together and the sum of the 12
values is shown as a result.