Paul Chapman: /* Time Series (Monthly) Data */

2013-10-01T23:42:44Z

Time Series (Monthly) Data

Paul Chapman: Created page with "===Time Series (Monthly) Data=== The calendar month is the basic time step for reporting data in Ellserve. All interval source data is aggregated to [[Ell..."

2013-10-01T23:42:23Z

Created page with "===Time Series (Monthly) Data=== The calendar month is the basic time step for reporting data in Ellserve. All interval source data is aggregated to [[Ell..."

New page

===Time Series (Monthly) Data===
The calendar month is the basic time step for reporting data in Ellserve. All interval [[Ellserve:Source|source data]] is aggregated to [[Ellserve:Glossary#Monthly Data|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
[[Ellserve:Ellserve Data|Back]] - [[Ellserve:Ellserve|Home]]

{|class="wikitable" style="text-align: left; color: black;"
! Width="100"|'''Value Type'''
! Width="175"|'''Applies to'''
! Width="750"|'''Definition'''
|-
|+'''Monthly Value Types'''
| align="center" | '''[[Ellserve:Glossary#Normalisation|Normalised]]'''
| align="center" | 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.
|-
| align="center" | '''Invoiced'''
| align="center" | 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.
|-
| align="center" | '''Forecast'''
| align="center" | 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.
|-
| align="center" | '''Projected'''
| align="center" | 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.
|-
| align="center" | '''Budgeted'''
| align="center" | 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.
|-
| align="center" | '''Invoice Count'''
| align="center" | 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.
|-
| align="center" | '''Climate Data'''
| align="center" | Account-independent
|
: [[Ellserve:Source#Meteorology|Meteorological]] data for selected weather stations.
|}

[[Ellserve Data|Parent]] - [[Ellserve:Ellserve|Home]]

@@ Line 12: / Line 12: @@
 ** Cost (including GST)
 ** Emissions
-[[Ellserve:Ellserve Data|Back]] - [[Ellserve:Ellserve|Home]]
+[[Ellserve Data|Parent]] - [[Ellserve:Ellserve|Home]]

Time Series Data - Revision history

Paul Chapman: /* Time Series (Monthly) Data */

Paul Chapman: Created page with "===Time Series (Monthly) Data=== The calendar month is the basic time step for reporting data in Ellserve. All interval source data is aggregated to [[Ell..."