Irregular data spreading

In Irregular Data Spreading, data is manually entered in the Irregular Meter Entry screen for a specified time range.

Spreading occurs immediately after the data is entered. Spreading only occurs when Primary History Granularity (PHG) is not equal to Irregular. When the PHG is equal to Irregular, the row is written to the irregular Raw (raw) table and the row is processed normally. No spreading is done on the input, but general spreading could occur after the data is processed if general spreading is configured.

When the PHG is not equal to Irregular, the row is spread to the PHG of the meter and the spread rows are written to the Raw (raw) table for the primary granularity. They are processed to ensure that they conform to the limits and ranges that have been set.

You can choose to spread your irregular data in one of three ways:

• Equal Spread — the data is spread evenly (arithmetically) across the irregular period. This means that if there are 4 periods in the date range, the values in the input will be divided equally among the 4 periods.

• Integer + Remainder Data — is spread across the period (truncated to integer values). The remaining data (truncated from the other rows) is put into the last row. This means that if there are 4 periods in the date range, the values will be divided equally among the 4 periods, it will be truncated to an integer value in the first 3 periods and the remaining data is put into the last period.

• None — There is no spreading of the data to the PHG and the irregular meter data is stored in the irregular meter reading table.

Here is an example of how Equal Spread and Integer + Remainder algorithms function. The date range is set to begin at 4/1/2013 at 09:00 A.M. and ends on 4/1/2013 at 12:29:59:

Output