General data spreading
- Last UpdatedSep 24, 2024
- 3 minute read
General Data Spreading spreads data to a granularity finer than the granularity of data that enters the system.
If data from the field is set to be collected daily, but if you would like to view hourly data, you can configure General Data Spreading to create hourly data from the daily data.
Spreading occurs after the data has been processed and validated.
In General Data Spreading, the Spreading Algorithm property defines which spreading algorithm is used. For data with a primary history granularity that is not equal to Irregular (refer to Irregular data spreading for an explanation of Irregular Data Spreading), the Spreading Granularity property defines the granularity that will come into the system and will be spread to the Primary History Granularity (PHG).
For example, when Spreading Granularity is set to Daily and the PHG is set to 15-minute intervals, when a daily row comes into the system for the meter, it will be spread to rows accounting for 15-minute time slots. The Run Time and Run Time Integer algorithms cannot be used in this instance.
For data with a PHG that is equal to Irregular, the spreading granularity property defines the granularity that the irregular row will be spread to. The Run Time and Run Time Integer algorithms are the only algorithms that can be used in this instance.
For example, if the Spreading Granularity is set to Hourly, with the PHG set to Irregular, when the irregular row comes into the system from the meter, it will be spread to hourly rows.
The options for General Data Spreading are outlined in the following table.
General Data Spreading Options
|
Option |
Description |
|---|---|
|
None |
No spreading will be performed. |
|
Equal |
Spreads all metering values equally. For example, if you have an hourly meter with the spreading granularity set at daily, daily data will come into the system for that meter. After the daily data is processed, it will be spread to 24 hourly rows, each with an equal value in the spread columns. This function cannot be used when the PHG is Irregular. |
|
1.3 Factor |
The metering data is spread equally and then multiplied by 1.3. This function cannot be used when the primary history granularity is Irregular. |
|
Workday even |
Spread to an integer number with remainder on last row. For example, if you have a 15-minute meter with spreading granularity set to hourly and hourly data comes into the system for that meter, after the hourly data is processed it will be spread to four rows accounting for 15 minutes each. This function cannot be used when the PHG is Irregular. |
|
Alternate meter profile |
Uses the profile from the other meter / station in the Lagged / Alternate estimation. The data is spread using another meter or station's data distribution, using the configuration defined in the Lagged / Alt Estimation configuration. |
|
Run Time |
The data is spread by prorating the volume proportional to the runtime. This function can only be used when the PHG is irregular. |
|
Run Time Integer |
The RunTime Integer spreading algorithm functions in the same way as RunTime spreading. The spread data is prorated based on the RunTime but with volume/energy as integer values. When the meter data is spread, the prorated volume and energy values are set to the largest integer less than or equal to the calculated prorated value. Then any remainder is rounded and one unit of the remainder is added to each spread row starting with the first row in the spreading time period. This process ends when the remainder is gone. |