1 / 58

# AMS Data Transparency Reporting Don Tucker AMS Data Workshop III September 19, 2014 - PowerPoint PPT Presentation

AMS Data Transparency Reporting Don Tucker AMS Data Workshop III September 19, 2014. AMS Data Transparency Reporting. Contents Process and Assumptions Transaction Type Logic, Disconnect Type Logic Bins Reports……. AMS Data Transparency Reporting. Process & Assumptions

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about ' AMS Data Transparency Reporting Don Tucker AMS Data Workshop III September 19, 2014' - shanae

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Don Tucker

AMS Data Workshop III

September 19, 2014

• Contents

• Process and Assumptions

• Transaction Type Logic, Disconnect Type Logic

• Bins

• Reports…….

• 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)

• 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.

Deltas for all analyzed AMSR reads

grouped by transaction type

Deltas for all analyzed AMSM reads

grouped by transaction type

Deltas for all analyzed unknown disconnect type reads

grouped by transaction type

with delta > 2% and > 2 kWh

grouped by transaction type

with delta > 2% and > 2 kWh

grouped by transaction type

Deltas for unknown disconnect type reads

With delta > 2% and > 2kWh

grouped by transaction type

kWh deltas for