Spreadsheet: 70c1d427-37e3-46bc-8b8e-6874bb5c304f
Sheet: Sheet1

Missed x 60 multiplier
Original reporting
RECORD TYPE | ICP | START DATE | END DATE | NETWORK TARIFF DESC | UNIT TYPE | UNITS | STATUS | BUS NAME | DISTRIBUTOR | SPARE1 | NETWORK TARIFF CODE | NETWORK TARIFF RATE | FIXED VARIABLE | DAYS | NETWORK CHARGE | REPORT MONTH | CUSTOMER NO | CONSUMER NO | INVOICE DATE | INVOICE NO |  | Missed x10 Multiplier
DET | 00000009997B3 | 2008-02-01 00:00:00 | 2008-02-29 00:00:00 |  |  |  |  | GFD0331 | UNET |  | G100 | 0.15 | F | 29 |  | 200802 | 402408386 | 2701721110 |  |  |  | Total reported
DET | 00000009997B3 | 2008-02-01 00:00:00 | 2008-02-29 00:00:00 |  | kWh | 242 | RD | GFD0331 | UNET |  | [NAME] | 0.0804 | V |  |  | 200802 | 402408386 | 2701721110 |  |  |  | FIXED |  | 152 | Days
DET | 00000009997B3 | 2008-01-01 00:00:00 | 2008-01-31 00:00:00 |  |  |  |  | GFD0331 | UNET |  | G100 | 0.15 | F | 31 |  | 200801 | 402408386 | 2701721110 |  |  |  | VARIABLE |  |  | kWh
DET | 00000009997B3 | 2008-01-01 00:00:00 | 2008-01-31 00:00:00 |  | kWh | 498 | ES | GFD0331 | UNET |  | [NAME] | 0.0804 | V |  |  | 200801 | 402408386 | 2701721110 |  |  |  | TOTAL
DET | 00000009997B3 | 2007-12-01 00:00:00 | 2007-12-31 00:00:00 |  |  |  |  | GFD0331 | UNET |  | G100 | 0.15 | F | 31 |  | 200712 | 402408386 | 2701721110
DET | 00000009997B3 | 2007-12-01 00:00:00 | 2007-12-31 00:00:00 |  | kWh | 299 | RD | GFD0331 | UNET |  | [NAME] | 0.0804 | V |  |  | 200712 | 402408386 | 2701721110 |  |  |  | Example shows reversal and re-reporting of prior period fixed and variable charges
DET | 00000009997B3 | 2007-11-01 00:00:00 | 2007-11-30 00:00:00 |  |  |  |  | GFD0331 | UNET |  | G100 | 0.125 | F | 30 |  | 200711 | 402408386 | 2701721110 |  |  |  | With rate change taken into account (fixed and variable rate change as of 1st December)
DET | 00000009997B3 | 2007-11-01 00:00:00 | 2007-11-30 00:00:00 |  | kWh | 540 | ES | GFD0331 | UNET |  | [NAME] | 0.0736 | V |  |  | 200711 | 402408386 | 2701721110
DET | 00000009997B3 | 2007-10-01 00:00:00 | 2007-10-31 00:00:00 |  |  |  |  | GFD0331 | UNET |  | G100 | 0.125 | F | 31 |  | 200710 | 402408386 | 2701721110
DET | 00000009997B3 | 2007-10-01 00:00:00 | 2007-10-31 00:00:00 |  | kWh | 689 | RD | GFD0331 | UNET |  | [NAME] | 0.0736 | V |  |  | 200710 | 402408386 | 2701721110
Reversal of events and revised reporting (DATES and RV event)
RECORD TYPE | ICP | START DATE | END DATE | NETWORK TARIFF DESC | UNIT TYPE | UNITS | STATUS | BUS NAME | DISTRIBUTOR | SPARE1 | NETWORK TARIFF CODE | NETWORK TARIFF RATE | FIXED VARIABLE | DAYS | NETWORK CHARGE | REPORT MONTH | CUSTOMER NO | CONSUMER NO | INVOICE DATE | INVOICE NO
DET | 00000009997B3 | 2007-12-01 00:00:00 | 2008-03-31 00:00:00 |  |  |  |  | GFD0331 | UNET |  | G100 | 0.15 | F | 122 |  | 200803 | 402408386 | 2701721110 |  |  |  | Total reported with multiplier
DET | 00000009997B3 | 2007-12-01 00:00:00 | 2008-03-31 00:00:00 |  | kWh | 88680 | RD | GFD0331 | UNET |  | [NAME] | 0.0804 | V |  |  | 200803 | 402408386 | 2701721110 |  |  |  | FIXED |  |  | Days
DET | 00000009997B3 | 2007-10-01 00:00:00 | 2007-11-30 00:00:00 |  |  |  |  | GFD0331 | UNET |  | G100 | 0.15 | F | 61 |  | 200803 | 402408386 | 2701721110 |  |  |  | VARIABLE |  |  | kWh
DET | 00000009997B3 | 2007-10-01 00:00:00 | 2007-11-30 00:00:00 |  | kWh | 73740 | RD | GFD0331 | UNET |  | [NAME] | 0.0736 | V |  |  | 200803 | 402408386 | 2701721110 |  |  |  | TOTAL
DET | 00000009997B3 | 2007-12-01 00:00:00 | 2008-02-29 00:00:00 |  |  |  |  | GFD0331 | UNET |  | G100 | 0.15 | F | -91 |  | 200803 | 402408386 | 2701721110
DET | 00000009997B3 | 2007-12-01 00:00:00 | 2008-02-29 00:00:00 |  | kWh | -1039 | RV | GFD0331 | UNET |  | [NAME] | 0.0804 | V |  |  | 200803 | 402408386 | 2701721110 |  |  |  | Reversal of prior period events
DET | 00000009997B3 | 2007-10-01 00:00:00 | 2007-11-30 00:00:00 |  |  |  |  | GFD0331 | UNET |  | G100 | 0.125 | F | -61 |  | 200803 | 402408386 | 2701721110 |  |  |  | FIXED |  |  | Days
DET | 00000009997B3 | 2007-10-01 00:00:00 | 2007-11-30 00:00:00 |  | kWh | -1229 | RV | GFD0331 | UNET |  | [NAME] | 0.0736 | V |  |  | 200803 | 402408386 | 2701721110 |  |  |  | VARIABLE |  |  | kWh
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Reversal of events and revised reporting - DELTA
RECORD TYPE | ICP | START DATE | END DATE | NETWORK TARIFF DESC | UNIT TYPE | UNITS | STATUS | BUS NAME | DISTRIBUTOR | SPARE1 | NETWORK TARIFF CODE | NETWORK TARIFF RATE | FIXED VARIABLE | DAYS | NETWORK CHARGE | REPORT MONTH | CUSTOMER NO | CONSUMER NO | INVOICE DATE | INVOICE NO |  | "Delta" Version shows difference in variable volume only
DET | 00000009997B3 | 2008-03-01 00:00:00 | 2008-03-31 00:00:00 |  |  |  |  | GFD0331 | UNET |  | G100 | 0.15 | F | 31 |  | 200803 | 402408386 | 2701721110 |  |  |  | Would not take  rate changes into account (ie all volume reported at latest rate)
DET | 00000009997B3 | 2008-03-01 00:00:00 | 2008-03-31 00:00:00 |  | kWh | 160152 | RD | GFD0331 | UNET |  | [NAME] | 0.0804 | V |  |  | 200803 | 402408386 | 2701721110 |  |  |  | Volume (ie "delta")  reported against current month
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total reported with multiplier |  | Days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIXED |  | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VARIABLE |  | 160152
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Taking previously reported days and volume into account
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIXED |  |  | Days
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 181.36 | 2268 | kWh
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL