View meter averages based on the selections made here:
If Show in Report is ticked, columns will appear in the report for 3, 6, 12 months and lifetime.
There are preset values to these parameters for each period. These values can be adjusted according to how you wish to expand the calculation of the averages.
If you tick Show Calculation Parameters, the report will generate a spreadsheet with the first sheet explaining how these paramaters are being used in the calculation, as well as an additional 5 columns each period in the Meter Averages sheet.
These 5 columns are the values used to calculate the Avg Meter.
|
The additional 5 columns will only be used to calculate for child or standalone machines. The Master's Avg Meter will be calculated based on the sum of all the averages of its children of the same meter name (i.e. Black, Black Finance, Colour, etc).
In this screenshot, columns Y-AC are the 5 added columns for the 3-month period. The same concept will be for 6-month, 12-month, and Life.
Column Y, or the Daily Avg for that period, will be needed to calculate the averages using this formula:
Column Y = (AB-Z) / (AC-AA) (as illustrated in Column X).
Once you have the Daily Avg for the period, you can now calculate for the monthly average (Column W), as per this formula:
Column W = Column Y * 365 / 12 (as illustrated in Column V below).
The averages in Masters are calculated based on the total of all the averages of the children of the same meter name (i.e. Black, Black Finance, Colour, etc) as per this formula:
Column W for Masters = the SUM of all children of the same Meter (as illustrated in Column V)
 |
This can also report the averages based on asset reads. By default, it uses the contract reads or the reads used in billing (as per in the billing history).
You can validate Asset Reads via the Preview Pane;
