Time Series Data

Time Series (Monthly) Data

The calendar month is the basic time step for reporting data in Ellserve. All interval source data is aggregated to monthly values for reporting purposes.

Monthly data is either

• Account-independent:
  • Climate data
• Account-specific:
  • Invoice count
• Account-specific & consumption-based:
  • Consumption
  • Cost (excluding GST)
  • Cost (including GST)
  • Emissions

Monthly Value Types

Value Type	Applies to	Definition
Normalised	Account-specific & consumption-based data	Values allocated to the month in which related consumption actually took place. E.g. That portion of June consumption in a July invoice would be aggregated to June's normalised consumption values.
Invoiced	Account-specific & consumption-based data	Values allocated to the month in which related consumption was invoiced (by invoice date). E.g. That portion of June consumption in a July invoice would be aggregated to July's invoiced consumption values.
Forecast	Account-specific & consumption-based data	Values allocated to the month in which actual consumption is expected to take place. Note: Forecast values are updated as new invoice data is received.
Projected	Account-specific & consumption-based data	A specialised data form that integrates normalised and forecast data to allow for single 'expected' values for any month where, for whatever reason, the invoice record is incomplete.
Budgeted	Account-specific & consumption-based data	A set of user-agreed 'expected' values for future months. Note: Unlike forecast and projected data, budgeted values, are permanently fixed i.e. they are not updated as new invoice data is received.
Invoice Count	Account-specific	A count of the invoices received for an account in single calendar month Note: This value is useful when investigating unexpected invoiced cost spikes without accompanying normalised cost spikes.
Climate Data	Account-independent	Meteorological data for selected weather stations.

---

4Main Page 4Guide to Ellserve 4Ellserve Data