Consolidated Dashboard
06/03/20 16:40 Filed in: Reconciliation | Energy Retailer
By Malcolm Souness - Director 221b Limited
In my first role as an energy supply analyst, a whole series of reports for the Board were produced using separate spreadsheets and datasets. One thing that was missing was the ability to cross check and validate data for board reporting. Read More…
In my first role as an energy supply analyst, a whole series of reports for the Board were produced using separate spreadsheets and datasets. One thing that was missing was the ability to cross check and validate data for board reporting. Read More…
2020 Meter Register Review (2)
03/02/20 19:13 Filed in: Reconciliation | Energy Billing | Metering | Generation | Electricity Registry
Generation Register Errors
By Malcolm Souness - Director 221b Limited
During January 2020, we undertook an investigation into electricity meter register configurations on New Zealand electricity networks.
One of the data quality issues identified is the configuration of NHH generation meter registers. Read More…
2020 Meter Register Review (1)
Controlled load availability
By Malcolm Souness - Director 221b Limited
During January 2020, we undertook an investigation into electricity meter register configurations on New Zealand electricity networks.
The number of infrequently used register configurations indicates that legacy ripple control schedule durations remain in the Electricity Registry. For example, Vector has over 0.2M controlled meter registers with 1-23 hours availability, however just one has an availability of 5 hours, and one other has six hours available. The balance of probabilities suggests these may not be legitimate hours available. Read More…
Meter Register Content Codes
23/01/20 21:17 Filed in: Metering | Energy Retailer | Electricity Network | Energy | R | Reconciliation | Electricity Authority
Author: Malcolm Souness, Director, 221b Ltd
Originally published 29 October, 2019, updated January 2020
The source data used for this analysis are taken from the Electricity Authority of New Zealand EMI website. The R statistical analysis package is used to transform and present the data in a more useable form, source code available from the 221b Data Refinery Github Repository. The key constraint on this dataset is the exclusion of de-energised sites (ICP Status 001). Read More…
Originally published 29 October, 2019, updated January 2020
The source data used for this analysis are taken from the Electricity Authority of New Zealand EMI website. The R statistical analysis package is used to transform and present the data in a more useable form, source code available from the 221b Data Refinery Github Repository. The key constraint on this dataset is the exclusion of de-energised sites (ICP Status 001). Read More…
Supplied and Submitted Volumes
23/01/20 16:56 Filed in: Electricity | Reconciliation | Energy Retailer | Energy Billing | Electricity Authority
Author: Malcolm Souness, Director, 221b Limited
Originally published 5 June 2019
Electricity industry participants (traders) in New Zealand are required to submit calendar normalised "submitted" energy volume (AV-080 for non half hour data, and AV-090 for half hour data), as well as the "supplied" (billed/invoiced) volume (AV-120). Refer: Reconciliation Manager Functional Specification v9.27. The normalised volumes are used for market settlement and clearance.
Read More…
Originally published 5 June 2019
Electricity industry participants (traders) in New Zealand are required to submit calendar normalised "submitted" energy volume (AV-080 for non half hour data, and AV-090 for half hour data), as well as the "supplied" (billed/invoiced) volume (AV-120). Refer: Reconciliation Manager Functional Specification v9.27. The normalised volumes are used for market settlement and clearance.
Read More…