{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["SMDR","SMIRR","Weighted Average Calculations"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SMDR","index":0,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[24,1,24,7],[14,1,14,8],[15,9,15,11],[16,1,16,8],[17,1,17,8]]}
["SMDR - Allocation Model"]
[]
[null,null,2006,2007,2008,2009,2010,2011,null,"Total 2009 to 2011","Explanation Allocator","ID and Factors","Total",{"$f":"IF('[1]I2 LDC class'!$D$20=\"\",'[1]I2 LDC class'!$C$20,'[1]I2 LDC class'!$D$20)","v":"Residential"},{"$f":"IF('[1]I2 LDC class'!$D$21=\"\",'[1]I2 LDC class'!$C$21,'[1]I2 LDC class'!$D$21)","v":"General Service Less than 50 kW"}]
[null,"Revenue Requirement for the Historical Years",{"$f":"'[2]5. SM_Rev_Reqt'!$G$70","v":14505.52938507352},{"$f":"'[2]5. SM_Rev_Reqt'!$I$70","v":11916.198066370353},{"$f":"'[2]5. SM_Rev_Reqt'!$K$70","v":15123.486762305598},{"$f":"'[2]5. SM_Rev_Reqt'!$M$70","v":43438.042686259214},{"$f":"'[2]5. SM_Rev_Reqt'!$O$70","v":119872.55843202201},{"$f":"'[2]5. SM_Rev_Reqt'!$Q$70","v":354986.31612675951},null,{"$f":"SUM(C4:H4)","v":559842.13145879027}]
[]
[null,"Total Return on Capital",{"$f":"'[2]5. SM_Rev_Reqt'!$G$47","v":163.57912499999998},{"$f":"'[2]5. SM_Rev_Reqt'!$I$47","v":134.3791875},{"$f":"'[2]5. SM_Rev_Reqt'!$K$47","v":168.57130950000001},{"$f":"'[2]5. SM_Rev_Reqt'!$M$47","v":790.7495846249999},{"$f":"'[2]5. SM_Rev_Reqt'!$O$47","v":44572.434724999999},{"$f":"'[2]5. SM_Rev_Reqt'!$Q$47","v":92965.455035999999},null,{"$f":"SUM(C6:H6)","v":138795.16896762501},"Weighted Meter Capital",{"$f":"'[1]E2 Allocators'!B93","v":"CWMC"},{"$f":"SUM(N6:O6)","v":1},0.65,0.35]
[null,null,null,null,null,null,null,null,null,"Allocated per Class",null,null,138795.16896762501,{"$f":"N6*$J$6","v":90216.859828956265},{"$f":"O6*$J$6","v":48578.309138668752}]
[null,"Amortization and interest Expense",{"$f":"'[2]5. SM_Rev_Reqt'!$G$58","v":0},{"$f":"'[2]5. SM_Rev_Reqt'!$I$58","v":0},{"$f":"'[2]5. SM_Rev_Reqt'!$K$58","v":0},{"$f":"'[2]5. SM_Rev_Reqt'!$M$58","v":294.23333333333335},{"$f":"'[2]5. SM_Rev_Reqt'!$O$58","v":47349.366666666669},{"$f":"'[2]5. SM_Rev_Reqt'!$Q$58","v":112542.7},null,{"$f":"SUM(C8:H8)","v":160186.29999999999},"Weighted Meter Capital",{"$f":"L6","v":"CWMC"},1,{"$f":"N6","v":0.65},{"$f":"O6","v":0.35}]
[null,null,null,null,null,null,null,null,null,"Allocated per Class",null,null,160186.29999999999,{"$f":"$J$8*N8","v":104121.095},{"$f":"$J$8*O8","v":56065.204999999994}]
[null,"Operating Expenses",{"$f":"'[2]5. SM_Rev_Reqt'!$G$50","v":14302},{"$f":"'[2]5. SM_Rev_Reqt'!$I$50","v":11749},{"$f":"'[2]5. SM_Rev_Reqt'!$K$50","v":14916},{"$f":"'[2]5. SM_Rev_Reqt'!$M$50","v":42406},{"$f":"'[2]5. SM_Rev_Reqt'!$O$50","v":34514},{"$f":"'[2]5. SM_Rev_Reqt'!$Q$50","v":156773},null,{"$f":"SUM(C10:H10)","v":274660},"Number of Smart Meters Installed for each Class",null,9612,7986,1626]
[null,null,null,null,null,null,null,null,null,"Allocated per Class",null,null,274660,{"$f":"$J$10/$M$10*N10","v":228197.54057428215},{"$f":"$J$10/$M$10*O10","v":46462.459425717854}]
[null,"Grossed-up Taxes/PILs",{"$f":"'[2]5. SM_Rev_Reqt'!$G$68","v":39.950260073519246},{"$f":"'[2]5. SM_Rev_Reqt'!$I$68","v":32.818878870352606},{"$f":"'[2]5. SM_Rev_Reqt'!$K$68","v":38.915452805598562},{"$f":"'[2]5. SM_Rev_Reqt'!$M$68","v":-52.94023169911452},{"$f":"'[2]5. SM_Rev_Reqt'!$O$68","v":-6563.2429596446536},{"$f":"'[2]5. SM_Rev_Reqt'!$Q$68","v":-7294.8389092405141},null,{"$f":"SUM(C12:H12)","v":-13799.337508834811},"Revenue Requirement allocated to each Class before PILs",null,573641.46896762506,{"$f":"N7+N9+N11","v":422535.49540323846},{"$f":"O7+O9+O11","v":151105.9735643866}]
[null,null,null,null,null,null,null,null,null,"Allocated per Class",null,null,-13799.337508834811,{"$f":"$J$12/$M$12*N12","v":-10164.38006308271},{"$f":"$J$12/$M$12*O12","v":-3634.9574457521007}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"IF('[1]I2 LDC class'!$D$20=\"\",'[1]I2 LDC class'!$C$20,'[1]I2 LDC class'!$D$20)","v":"Residential"},{"$f":"IF('[1]I2 LDC class'!$D$21=\"\",'[1]I2 LDC class'!$C$21,'[1]I2 LDC class'!$D$21)","v":"General Service Less than 50 kW"}]
[null,"TOTAL REVENUE REQUIREMENT",null,null,null,null,null,null,null,{"$f":"J6+J8+J10+J12","v":559842.13145879016},null,null,{"$f":"+M7+M9+M11+M13","v":559842.13145879016},{"$f":"+N7+N9+N11+N13","v":412371.11534015572},{"$f":"+O7+O9+O11+O13","v":147471.01611863449}]
[null,null,null,null,null,null,null,null,null,"Percentage of costs allocated to customer classes",null,null,{"$f":"SUM(N16:O16)","v":1},{"$f":"N15/M15","v":0.7365846408622968},{"$f":"O15/M15","v":0.26341535913770325}]
[null,"Revenue Generated from Smart Meter Funding Adder",null,null,null,null,null,null,null,393371]
[null,"Net Deferred Revenue Requirement",null,null,null,null,null,null,null,{"$f":"J15-J17","v":166471.13145879016}]
[null,null,null,null,null,null,null,null,"SMIRR Revenue Shortfall",147112.56]
[null,null,null,null,null,null,null,null,"Total Revenue Requirement",{"$f":"J18+J19","v":313583.69145879016}]
[null,null,null,null,null,null,null,null,null,"Allocated per Class",null,null,null,{"$f":"$J$20*N16","v":230980.93075344624},{"$f":"$J$20*O16","v":82602.760705343942}]
[null,null,null,null,null,null,null,null,null,"Number of Metered Customers",null,null,null,7986,1626]
[null,null,null,null,null,null,null,null,"Smart Meter Disposition Rate Rider",null,null,null,null,{"$f":"N21/N22/12","v":2.4102693333484249},{"$f":"O21/O22/12","v":4.2334338204870816}]

{"sheet":"SMIRR","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[14,1,14,3],[15,4,15,6],[20,1,20,2]]}
["SMIRR - Allocation Model"]
[]
[null,null,2012,null,"Total 2012","Explanation Allocator","ID and Factors","Total",{"$f":"IF('[1]I2 LDC class'!$D$20=\"\",'[1]I2 LDC class'!$C$20,'[1]I2 LDC class'!$D$20)","v":"Residential"},{"$f":"IF('[1]I2 LDC class'!$D$21=\"\",'[1]I2 LDC class'!$C$21,'[1]I2 LDC class'!$D$21)","v":"General Service Less than 50 kW"}]
[null,"Revenue Requirement for the Forecast Year",{"$f":"'[2]5. SM_Rev_Reqt'!$S$70","v":252288.50747324675},null,{"$f":"SUM(C4:C4)","v":252288.50747324675}]
[]
[null,"Total Return on Capital",{"$f":"'[2]5. SM_Rev_Reqt'!$S$47","v":97838.114168800006},null,{"$f":"SUM(C6:C6)","v":97838.114168800006},"Weighted Meter Capital",{"$f":"'[1]E2 Allocators'!B93","v":"CWMC"},{"$f":"SUM(I6:J6)","v":1},0.65,0.35]
[null,null,null,null,"Allocated per Class",null,null,97838.114168800006,{"$f":"I6*$E$6","v":63594.774209720003},{"$f":"J6*$E$6","v":34243.339959080004}]
[null,"Amortization and interest Expense",{"$f":"'[2]5. SM_Rev_Reqt'!$S$58","v":132934.63333333333},null,{"$f":"SUM(C8:C8)","v":132934.63333333333},"Weighted Meter Capital",{"$f":"G6","v":"CWMC"},1,{"$f":"I6","v":0.65},{"$f":"J6","v":0.35}]
[null,null,null,null,"Allocated per Class",null,null,132934.63333333333,{"$f":"$E$8*I8","v":86407.511666666673},{"$f":"$E$8*J8","v":46527.121666666666}]
[null,"Operating Expenses",{"$f":"'[2]5. SM_Rev_Reqt'!$S$50","v":20945},null,{"$f":"SUM(C10:C10)","v":20945},"Number of Smart Meters Installed for each Class",null,{"$f":"I10+J10","v":9612},7986,1626]
[null,null,null,null,"Allocated per Class",null,null,20944.999999999996,{"$f":"$E$10/$H$10*I10","v":17401.869538077401},{"$f":"$E$10/$H$10*J10","v":3543.1304619225966}]
[null,"Grossed-up Taxes/PILs",{"$f":"'[2]5. SM_Rev_Reqt'!$S$68","v":570.7599711134161},null,{"$f":"SUM(C12:C12)","v":570.7599711134161},"Revenue Requirement allocated to each Class before PILs",null,251717.74750213334,{"$f":"I7+I9+I11","v":167404.15541446407},{"$f":"J7+J9+J11","v":84313.592087669269}]
[null,null,null,null,"Allocated per Class",null,null,570.7599711134161,{"$f":"$E$12/$H$12*I12","v":379.58225773419315},{"$f":"$E$12/$H$12*J12","v":191.17771337922295}]
[null,null,null,null,null,null,null,"Total",{"$f":"IF('[1]I2 LDC class'!$D$20=\"\",'[1]I2 LDC class'!$C$20,'[1]I2 LDC class'!$D$20)","v":"Residential"},{"$f":"IF('[1]I2 LDC class'!$D$21=\"\",'[1]I2 LDC class'!$C$21,'[1]I2 LDC class'!$D$21)","v":"General Service Less than 50 kW"}]
[null,"TOTAL FORECAST REVENUE REQUIREMENT",null,null,{"$f":"E6+E8+E10+E12","v":252288.50747324675},null,null,{"$f":"+H7+H9+H11+H13","v":252288.50747324675},{"$f":"+I7+I9+I11+I13","v":167783.73767219827},{"$f":"+J7+J9+J11+J13","v":84504.769801048489}]
[null,null,null,null,"Percentage of costs allocated to customer classes",null,null,{"$f":"SUM(I16:J16)","v":1},{"$f":"I15/H15","v":0.66504708974898685},{"$f":"J15/H15","v":0.3349529102510132}]
[null,null,null,null,"Allocated per Class",null,null,null,{"$f":"+I15","v":167783.73767219827},{"$f":"+J15","v":84504.769801048489}]
[null,null,null,null,"Number of Metered Customers",null,null,null,{"$f":"SMDR!N22","v":7986},{"$f":"SMDR!O22","v":1626}]
[null,null,null,"Smart Meter Disposition Rate Rider",null,null,null,null,{"$f":"I17/I18/12","v":1.7508111869959748},{"$f":"J17/J18/12","v":4.3309127614313496}]

{"sheet":"Weighted Average Calculations","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Weighted Average Calculations"]
[]
["Residential Meters"]
[null,null,"Avg. Meter Cost","Avg. Install Cost","Number of Meters","Total Cost","Allocation"]
[null,"Sensus",70,10,7986,{"$f":"E5*(C5+D5)","v":638880},{"$f":"F5/F14","v":0.6487210990729364}]
[]
[]
["GS < 50 kW"]
[null,"Sensus",70,50,1276,{"$f":"E9*(C9+D9)","v":153120}]
[null,"Elster",480,50,331,{"$f":"E10*(C10+D10)","v":175430}]
[null,"GE",550,50,29,{"$f":"E11*(C11+D11)","v":17400}]
[null,"Sub Total",null,null,null,{"$f":"F9+F10+F11","v":345950},{"$f":"F12/F14","v":0.35127890092706354}]
[]
[null,"Grand Total",null,null,null,{"$f":"F12+F5","v":984830}]