ams data transparency reporting don tucker ams data workshop iii september 19, 2014
DESCRIPTION
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 - PowerPoint PPT PresentationTRANSCRIPT
AMS Data Transparency Reporting
Don Tucker
AMS Data Workshop IIISeptember 19, 2014
AMS Data Workshop III04/20/23 2
• Contents– Process and Assumptions
– Transaction Type Logic, Disconnect Type Logic
– Bins
– Reports…….
AMS Data Transparency Reporting
AMS Data Workshop III04/20/23 3
• 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 Reporting
Count of Reads % of Starting Reads % Reported Data Data Description
7,107,712 100.00% Starting Reads- 5,542 0.1% Removed due to zero kWh 867 and non-zero AMS total
7,102,170 99.9% 100.00% All analyzed reads- 6,977,845 98.2% 98.2% Removed due to AMS read being within (inclusive) 2kWh or 2% of 867
124,325 1.7% 1.8% Analyzed reads (subset with deltas greater than 2kWh and 2%)
AMS Data Workshop III04/20/23 4
• 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 Reporting
AMS Data Workshop III04/20/23 5
• Bins
AMS Data Transparency Reporting
% Bin Delta % as x
<(50%) x < -50%
(20)-(50%) -50% =< x < -20%
(10)-(20%) -20% <= x < -10%
(5)-(10%) -10% <= x <-5%
(3)-(5%) -5% <= x < -3%
(2)-(3%) -3% <= x < -2%
0-(2%) -2% <= x < 0%
0% x = 0%
0-2% 0% < x <= 2%
2-3% 2% < x <= 3%
3-5% 3% < x <= 5%
5-10% 5% < x <= 10%
10-20% 10% < x <= 20%
20-50% 20% < x <= 50%
>50% 50% < x
kWh Bin Delta kWh as x
<(50) x < -50
(20)-(50) -50 <= x < -20
(10)-(20) -20 <= x < -10
(5)-(10) -10 <= x <-5
(3)-(5) -5 <= x < -3
(2)-(3) -3 <= x < -2
0-(2) -2 <= x < 0
0 x = 0
0-2 0 < x <= 2
2-3 2 < x <= 3
3-5 3 < x <= 5
5-10 5 < x <= 10
10-20 10 < x <= 20
20-50 20 < x <= 50
>50 50 < x
6
Deltas for all analyzed AMSR readsgrouped by transaction type
7
8
9
Number of 867 Reads 6,575,089Min delta % (867 < AMS) -233627%Max delta % (867 > AMS) 100%Avg abs delta % 1%
10
Number of 867 Reads 6,575,089Min delta kWh (867 < AMS) -96,454Max delta kWh (867 > AMS) 18,840Avg abs delta kWh 3
11
Number of 867 Reads 5,946,549Min delta % (867 < AMS) -233627%Max delta % (867 > AMS) 100%Avg abs delta % 1%
12
Number of 867 Reads 5,946,549Min delta kWh (867 < AMS) -96,454Max delta kWh (867 > AMS) 11,183Avg abs delta kWh 3
13
Number of 867 Reads 466,771Min delta % (867 < AMS) -31300%Max delta % (867 > AMS) 100%Avg abs delta % 2%
14
Number of 867 Reads 466,771Min delta kWh (867 < AMS) -50,519Max delta kWh (867 > AMS) 18,840Avg abs delta kWh 3
15
Number of 867 Reads 161,769Min delta % (867 < AMS) -9294%Max delta % (867 > AMS) 100%Avg abs delta % 1%
16
Number of 867 Reads 161,769Min delta kWh (867 < AMS) -18,030Max delta kWh (867 > AMS) 3,683Avg abs delta kWh 4
17
Deltas for all analyzed AMSM readsgrouped by transaction type
18
19
20
Number of 867 Reads 514,799Min delta % (867 < AMS) -450817%Max delta % (867 > AMS) 100%Avg abs delta % 4%
21
Number of 867 Reads 514,799Min delta kWh (867 < AMS) -934,307Max delta kWh (867 > AMS) 265,681Avg abs delta kWh 43
22
Number of 867 Reads 487,868Min delta % (867 < AMS) -450817%Max delta % (867 > AMS) 100%Avg abs delta % 4%
23
Number of 867 Reads 487,868Min delta kWh (867 < AMS) -934,307Max delta kWh (867 > AMS) 265,681Avg abs delta kWh 42
24
Number of 867 Reads 9,785Min delta % (867 < AMS) -5900%Max delta % (867 > AMS) 100%Avg abs delta % 6%
25
Number of 867 Reads 9,785Min delta kWh (867 < AMS) -72,563Max delta kWh (867 > AMS) 17,601Avg abs delta kWh 90
26
Number of 867 Reads 17,146Min delta % (867 < AMS) -923%Max delta % (867 > AMS) 100%Avg abs delta % 2%
27
Number of 867 Reads 17,146Min delta kWh (867 < AMS) -31,112Max delta kWh (867 > AMS) 109,600Avg abs delta kWh 60
28
Deltas for all analyzed unknown disconnect type readsgrouped by transaction type
29
30
31
Deltas for AMSR readswith delta > 2% and > 2 kWhgrouped by transaction type
32
33
34
Number of 867 Reads 99,702Min delta % (867 < AMS) -233627%Max delta % (867 > AMS) 100%Avg abs delta % 30%
35
Number of 867 Reads 99,702Min delta kWh (867 < AMS) -96,454Max delta kWh (867 > AMS) 18,840Avg abs delta kWh 159
36
Number of 867 Reads 62,066Min delta % (867 < AMS) -233627%Max delta % (867 > AMS) 100%Avg abs delta % 37%
37
Number of 867 Reads 62,066Min delta kWh (867 < AMS) -96,454Max delta kWh (867 > AMS) 11,183Avg abs delta kWh 228
38
Number of 867 Reads 29,311Min delta % (867 < AMS) -31300%Max delta % (867 > AMS) 100%Avg abs delta % 18%
39
Number of 867 Reads 29,311Min delta kWh (867 < AMS) -50,519Max delta kWh (867 > AMS) 18,840Avg abs delta kWh 40
40
Number of 867 Reads 8,325Min delta % (867 < AMS) -9294%Max delta % (867 > AMS) 100%Avg abs delta % 14%
41
Number of 867 Reads 8,325Min delta kWh (867 < AMS) -18,030Max delta kWh (867 > AMS) 3,683Avg abs delta kWh 61
42
Deltas for AMSM readswith delta > 2% and > 2 kWhgrouped by transaction type
43
44
45
Number of 867 Reads 23,535Min delta % (867 < AMS) -450817%Max delta % (867 > AMS) 100%Avg abs delta % 71%
46
Number of 867 Reads 23,535Min delta kWh (867 < AMS) -934,307Max delta kWh (867 > AMS) 265,681Avg abs delta kWh 641
47
Number of 867 Reads 19,281Min delta % (867 < AMS) -450817%Max delta % (867 > AMS) 100%Avg abs delta % 82%
48
Number of 867 Reads 19,281Min delta kWh (867 < AMS) -934,307Max delta kWh (867 > AMS) 265,681Avg abs delta kWh 706
49
Number of 867 Reads 2,798Min delta % (867 < AMS) -5900%Max delta % (867 > AMS) 100%Avg abs delta % 20%
50
Number of 867 Reads 2,798Min delta kWh (867 < AMS) -72,563Max delta kWh (867 > AMS) 17,601Avg abs delta kWh 280
51
Number of 867 Reads 1,456Min delta % (867 < AMS) -923%Max delta % (867 > AMS) 100%Avg abs delta % 16%
52
Number of 867 Reads 1,456Min delta kWh (867 < AMS) -31,112Max delta kWh (867 > AMS) 109,600Avg abs delta kWh 470
53
Deltas for unknown disconnect type readsWith delta > 2% and > 2kWhgrouped by transaction type
54
55
56
kWh deltas for reads removed from analysisgrouped by transaction type
57
58