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

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