AMS Data Transparency Reporting
This presentation is the property of its rightful owner.
Sponsored Links
1 / 58

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


  • 54 Views
  • Uploaded on
  • Presentation posted in: General

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

Download Presentation

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

An Image/Link below is provided (as is) to download presentation

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


Ams data transparency reporting don tucker ams data workshop iii september 19 2014

AMS Data Transparency Reporting

Don Tucker

AMS Data Workshop III

September 19, 2014


Ams data transparency reporting

AMS Data Transparency Reporting

  • Contents

    • Process and Assumptions

    • Transaction Type Logic, Disconnect Type Logic

    • Bins

    • Reports…….


Ams data transparency reporting1

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)


Ams data transparency reporting2

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.


Ams data transparency reporting3

AMS Data Transparency Reporting

  • Bins


Ams data transparency reporting don tucker ams data workshop iii september 19 2014

Deltas for all analyzed AMSR reads

grouped by transaction type


Ams data transparency reporting don tucker ams data workshop iii september 19 2014

Deltas for all analyzed AMSM reads

grouped by transaction type


Ams data transparency reporting don tucker ams data workshop iii september 19 2014

Deltas for all analyzed unknown disconnect type reads

grouped by transaction type


Ams data transparency reporting don tucker ams data workshop iii september 19 2014

Deltas for AMSR reads

with delta > 2% and > 2 kWh

grouped by transaction type


Ams data transparency reporting don tucker ams data workshop iii september 19 2014

Deltas for AMSM reads

with delta > 2% and > 2 kWh

grouped by transaction type


Ams data transparency reporting don tucker ams data workshop iii september 19 2014

Deltas for unknown disconnect type reads

With delta > 2% and > 2kWh

grouped by transaction type


Ams data transparency reporting don tucker ams data workshop iii september 19 2014

kWh deltas for

reads removed from analysis

grouped by transaction type


  • Login