AMS Data Transparency Reporting Don Tucker AMS Data Workshop III September 19, 2014

1. AMS Data Transparency Reporting Don Tucker AMS Data Workshop III September 19, 2014

2. AMS Data Transparency Reporting • Contents • Process and Assumptions • Transaction Type Logic, Disconnect Type Logic • Bins • Reports…….

3. AMS Data Transparency Reporting • Process & Assumptions • Data with 867 reads ending in July 2014 selected. • Data selected from database for analysis on August 13, 2014. • Selected all AMS reads with start times within 60 days of the first of the reporting month to the last day of the reporting month. • Both estimated and actual 867 and AMS reads were selected. • Select 867 records that have AMS reads. • If a record has an 867 but no AMS reads then the record is dropped. • Sum up AMS totals for the period of the coinciding 867 read. • Calculate the delta between 867 and AMS kWh. • (Delta kWh) = [(867 kWh) – round(AMS kWh)] / (867 kWh) • If both the 867 kWh and AMS kWh are zero then Delta kWh = 0. • If 867 kWh is zero and AMS kWh is non-zero then the comparison cannot be performed and the record is removed from further reporting analysis. (.1% of reads for the July run)

4. AMS Data Transparency Reporting • Transaction Type Logic • Separated reads into the following categories based on service order transactions. • Move In/ Out category contains 867 reads that coincide with Move In, Move Out or Move Out to CSA service orders. • Switch category contains 867 reads that coincide with Switch or Drop to POLR service orders. • Cycle Read category contains 867 reads that do not coincide with any of the above mentioned service orders. • If one of the above mentioned service orders was present with an effective date between the start date of the 867 minus one day and the stop date of the 867 plus one day then that service order was used to classify that read per the definitions above. • If a service order from both the Move In/Out category and the Switch category are present for a meter read the read is classified as Move In/Out. • Disconnect Type Breakout • Data broken into three groups based on disconnect type. • AMSR – Remote disconnect type, thought to have a meter multiplier of 1. • AMSM–Manual disconnect type, may not have a meter multiplier of 1. • Unknown– Remote designation type not designated.

5. AMS Data Transparency Reporting • Bins

6. Deltas for all analyzed AMSR reads grouped by transaction type

17. Deltas for all analyzed AMSM reads grouped by transaction type

28. Deltas for all analyzed unknown disconnect type reads grouped by transaction type

31. Deltas for AMSR reads with delta > 2% and > 2 kWh grouped by transaction type

42. Deltas for AMSM reads with delta > 2% and > 2 kWh grouped by transaction type