{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["4.12 PowerSupplExp"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":11,"defined_names":201,"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":"4.12 PowerSupplExp","index":0,"n_rows":193,"n_cols":19,"rows_kept":193,"cut":false,"hidden":false,"merged":[[128,7,128,9],[150,3,150,4],[151,3,151,4],[152,3,152,4],[153,3,153,4],[154,3,154,4],[156,3,156,4],[118,4,118,6],[128,4,128,6],[16,2,16,3],[17,2,17,3],[18,2,18,3],[23,2,23,3],[118,7,118,9],[70,4,70,6],[38,4,38,6],[38,7,38,9],[54,4,54,6],[54,7,54,9],[8,0,8,14],[9,0,9,14],[13,2,13,3],[14,2,14,3],[15,2,15,3],[12,2,12,3],[13,5,13,7],[146,1,146,6],[147,3,147,4],[148,3,148,4],[149,3,149,4],[19,2,19,3],[24,2,24,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[70,7,70,9],[102,4,102,6],[102,7,102,9],[86,4,86,6],[86,7,86,9],[178,7,178,9],[155,3,155,4],[170,1,170,3],[172,1,172,3],[173,1,173,3],[178,4,178,6],[165,1,165,3],[169,1,169,3],[162,1,162,7],[163,1,163,3],[164,1,164,3],[166,1,166,3],[167,1,167,3],[168,1,168,3],[171,1,171,3],[157,3,157,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
["Power Supply Expense"]
["Determination of Commodity"]
[]
[" "," ","Last Actual kWh's",null,null,"non GA mod","GA mod","Total ",null,"RPP","non-RPP","RPP"]
["Customer Class Name",null,"Last Actual kWh's",null,null,"non-RPP",null,null,null,null,"%","%"]
["Residential",null,12775802,null,null,null,52082,{"$f":"SUM(F15:G15)","v":52082},null,{"$f":"C15-(F15+G15)","v":12723720},{"$f":"+H15/C15","v":4.0766129594056013E-3},{"$f":"+J15/C15","v":0.99592338704059435},{"$f":"H15+J15","v":12775802}]
["General Service < 50 kW",null,4702580,null,null,null,194708,{"$f":"SUM(F16:G16)","v":194708},null,4507872,4.1404505611813087E-2,0.95859549438818692,{"$f":"H16+J16","v":4702580}]
["General Service > 50 to 4999 kW",null,6797046,null,null,null,6797046,{"$f":"SUM(F17:G17)","v":6797046},null,{"$f":"C17-(F17+G17)","v":0},1,0,6797046]
["Unmetered Scattered Load",null,2892,null,null,null,null,0,null,2892,0,1,2892]
["Sentinel Lighting",null,20629,null,null,null,null,{"$f":"SUM(F19:G19)","v":0},null,{"$f":"C19-(F19+G19)","v":20629},0,1,20629]
["Street Lighting ",null,274259,null,null,null,null,0,null,274259,0,1,274259]
["other",null,0,null,null,null,null,0,null,0]
[null,null,0,null,null,null,null,null,null,{"$f":"C22-F22","v":0}]
[null,null,0,null,null,null,null,null,null,{"$f":"C23-F23","v":0}]
["TOTAL"," ",{"$f":"SUM(C15:D23)","v":24573208},null,null,{"$f":"SUM(F15:F23)","v":0},{"$f":"SUM(G15:G23)","v":7043836},{"$f":"SUM(H15:H23)","v":7043836},null,{"$f":"SUM(J15:J23)","v":17529372},null,null,{"$f":"SUM(M15:M23)","v":24573208}]
["%"," ",{"$f":"$C$24/$C$24","v":1},null,null,{"$f":"$F$24/$C$24","v":0},{"$f":"$G$24/$C$24","v":0.28664698561132107},null,null,{"$f":"$J$24/$C$24","v":0.71335301438867893}]
[" "]
["Forecast Price",null,null,null,null,"GA modifiler ",41.49]
[]
["HOEP ($/MWh)",null,null,null,null,20.68,20.68]
["Global Adjustment ($/MWh)",null,null,null,null,102.22,{"$f":"F30-G27","v":60.73}]
["Adjustments",null,null,null,null,1,1]
["TOTAL ($/MWh)",null,null,null,null,{"$f":"SUM(F29:F31)","v":123.9},{"$f":"SUM(G29:G31)","v":82.41},null,null,82,null,null,null,null,null,null,null,null," "]
["$/kWh",null,null,null,null,{"$f":"F32/1000","v":0.12390000000000001},{"$f":"G32/1000","v":8.2409999999999997E-2},null,null,{"$f":"J32/1000","v":8.2000000000000003E-2}]
["%",null,null,null,null,{"$f":"F25","v":0},{"$f":"G25","v":0.28664698561132107},null,null,{"$f":"J25","v":0.71335301438867893}]
["WEIGHTED AVERAGE PRICE",null,{"$f":"SUM(F35:J35)","v":8.2117525264100641E-2},null,null,{"$f":"F33*F34","v":0},{"$f":"G33*G34","v":2.3622578084228969E-2},null,null,{"$f":"J33*J34","v":5.8494947179871672E-2}]
[]
["Electricity Projections"]
["(volumes for the bridge and test year are automatically loss adjusted)"]
[null,null,null,null,{"$f":"'[3]0.1 LDC Info'!$E$23","v":2018},null,null,{"$f":"'[3]0.1 LDC Info'!$E$25","v":2019}]
["Customer",null,"Revenue","Expense"," "]
["Class Name",null,"USA #","USA #","Volume","rate ($/kWh):","Amount","Volume","rate ($/kWh):","Amount"]
[{"$f":"A15","v":"Residential"},"kWh",4006,4705,{"$f":"CHOOSE(MATCH(B42,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I43*'[3]3.11 LoadForecast'!B87,'[3]3.11 LoadForecast'!$I$3)","v":14171745.740261581},{"$f":"$C$35","v":8.2117525264100641E-2},{"$f":"E42*F42","v":1163748.688862341},{"$f":"CHOOSE(MATCH(B42,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J43*'[3]3.11 LoadForecast'!C87,'[3]3.11 LoadForecast'!$J73)","v":14147726.037523417},{"$f":"$C$35","v":8.2117525264100641E-2},{"$f":"H42*I42","v":1161776.2503159037}]
["General Service < 50 kW","kWh",4010,4705,{"$f":"CHOOSE(MATCH(B43,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I44*'[3]3.11 LoadForecast'!B88,'[3]3.11 LoadForecast'!$I$3)","v":4921868.0477872528},8.2117525264100641E-2,404171.62376073946,{"$f":"CHOOSE(MATCH(B43,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J44*'[3]3.11 LoadForecast'!C88,'[3]3.11 LoadForecast'!$J74)","v":4991913.0654130662},8.2117525264100641E-2,409923.54726525152]
["General Service > 50 to 4999 kW","kWh",4035,4705,{"$f":"CHOOSE(MATCH(B44,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I45*'[3]3.11 LoadForecast'!B89,'[3]3.11 LoadForecast'!$I$3)","v":7221084.6917733587},8.2117525264100641E-2,592977.60461090913,{"$f":"CHOOSE(MATCH(B44,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J45*'[3]3.11 LoadForecast'!C89,'[3]3.11 LoadForecast'!$J75)","v":7323850.7553089615},8.2117525264100641E-2,601416.49942958623]
["Unmetered Scattered Load","kWh",4010,4705,{"$f":"CHOOSE(MATCH(B45,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I46*'[3]3.11 LoadForecast'!B90,'[3]3.11 LoadForecast'!$I$3)","v":3052.5060000000003},8.2117525264100641E-2,250.66423857381881,{"$f":"CHOOSE(MATCH(B45,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J46*'[3]3.11 LoadForecast'!C90,'[3]3.11 LoadForecast'!$J76)","v":3095.9473995858807},8.2117525264100641E-2,254.23153880182025]
["Sentinel Lighting","kWh",4025,4705,{"$f":"CHOOSE(MATCH(B46,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I47*'[3]3.11 LoadForecast'!B91,'[3]3.11 LoadForecast'!$I$3)","v":21438.2605},8.2117525264100641E-2,1760.456898227121,{"$f":"CHOOSE(MATCH(B46,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J47*'[3]3.11 LoadForecast'!C91,'[3]3.11 LoadForecast'!$J77)","v":21743.356719567364},8.2117525264100641E-2,1785.5106447454255]
["Street Lighting ","kWh",4025,4705,{"$f":"CHOOSE(MATCH(B47,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I48*'[3]3.11 LoadForecast'!B92,'[3]3.11 LoadForecast'!$I$3)","v":299727.37960000004},8.2117525264100641E-2,24612.870666645686,{"$f":"CHOOSE(MATCH(B47,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J48*'[3]3.11 LoadForecast'!C92,'[3]3.11 LoadForecast'!$J78)","v":303992.91646185465},8.2117525264100641E-2,24963.145997663985]
["other","kWh",4025,4705,{"$f":"CHOOSE(MATCH(B48,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I49*'[3]3.11 LoadForecast'!B93,'[3]3.11 LoadForecast'!$I$3)","v":0},8.2117525264100641E-2,0,{"$f":"CHOOSE(MATCH(B48,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J49*'[3]3.11 LoadForecast'!C93,'[3]3.11 LoadForecast'!$J79)","v":0},8.2117525264100641E-2,0]
[0,"kWh",4025,4705,{"$f":"CHOOSE(MATCH(B49,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I50*'[3]3.11 LoadForecast'!B94,'[3]3.11 LoadForecast'!$I$3)","v":0},8.2117525264100641E-2,0,{"$f":"CHOOSE(MATCH(B49,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J50*'[3]3.11 LoadForecast'!C94,'[3]3.11 LoadForecast'!$J80)","v":0},8.2117525264100641E-2,0]
[0,"kWh",4025,4705,{"$f":"CHOOSE(MATCH(B50,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I51*'[3]3.11 LoadForecast'!B95,'[3]3.11 LoadForecast'!$I$3)","v":0},8.2117525264100641E-2,0,{"$f":"CHOOSE(MATCH(B50,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J51*'[3]3.11 LoadForecast'!C95,'[3]3.11 LoadForecast'!$J81)","v":0},8.2117525264100641E-2,0]
["TOTAL"," ",null,null,{"$f":"SUM(E42:E50)","v":26638916.625922192},null,{"$f":"SUM(G42:G46)","v":2162909.0383707909},{"$f":"SUM(H42:H50)","v":26792322.078826457},null,{"$f":"SUM(J42:J50)","v":2200119.1851919531}]
[]
["Transmission - Network"]
["(volumes for the bridge and test year are automatically loss adjusted)"]
[null,null,null,null,{"$f":"'[3]0.1 LDC Info'!$E$23","v":2018},null,null,{"$f":"'[3]0.1 LDC Info'!$E$25","v":2019}]
["Customer",null,"Revenue","Expense",null," ",null,null," "]
["Class Name",null,"USA #","USA #","Volume","Rate","Amount","Volume","Rate","Amount"]
[{"$f":"A15","v":"Residential"},{"$f":"'[3]0.2 Customer Classes'!$D$13","v":"kWh"},4066,4714,{"$f":"CHOOSE(MATCH(B58,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I43*'[3]3.11 LoadForecast'!B87,'[3]3.11 LoadForecast'!$I73)","v":14171745.740261581},{"$f":"'[11]9. RTSR Rates to Forecast'!D17","v":6.7999999999999996E-3},{"$f":"E58*F58","v":96367.871033778749},{"$f":"CHOOSE(MATCH(B58,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J43*'[3]3.11 LoadForecast'!C87,'[3]3.11 LoadForecast'!$J73)","v":14147726.037523417},6.8069651913648934E-3,{"$f":"H58*I58","v":96303.078674388671}]
["General Service < 50 kW",{"$f":"'[3]0.2 Customer Classes'!$D$14","v":"kWh"},4066,4714,{"$f":"CHOOSE(MATCH(B59,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I44*'[3]3.11 LoadForecast'!B88,'[3]3.11 LoadForecast'!$I74)","v":4921868.0477872528},{"$f":"'[11]9. RTSR Rates to Forecast'!D18","v":6.0000000000000001E-3},29531.208286723519,{"$f":"CHOOSE(MATCH(B59,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J44*'[3]3.11 LoadForecast'!C88,'[3]3.11 LoadForecast'!$J74)","v":4991913.0654130662},6.006144809870057E-3,29982.152749153214]
["General Service > 50 to 4999 kW",{"$f":"'[3]0.2 Customer Classes'!$D$15","v":"kW"},4066,4714,{"$f":"CHOOSE(MATCH(B60,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I45*'[3]3.11 LoadForecast'!B89,'[3]3.11 LoadForecast'!$I75)","v":18152.243442001676},{"$f":"'[11]9. RTSR Rates to Forecast'!D19","v":2.5062000000000002},45493.152514344605,{"$f":"CHOOSE(MATCH(B60,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J45*'[3]3.11 LoadForecast'!C89,'[3]3.11 LoadForecast'!$J75)","v":17969.705891017529},2.5087666753162603,45081.79930461906]
["Unmetered Scattered Load",{"$f":"'[3]0.2 Customer Classes'!$D$16","v":"kWh"},4066,4714,{"$f":"CHOOSE(MATCH(B61,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I46*'[3]3.11 LoadForecast'!B90,'[3]3.11 LoadForecast'!$I76)","v":3052.5060000000003},{"$f":"'[11]9. RTSR Rates to Forecast'!D20","v":6.0000000000000001E-3},18.315036000000003,{"$f":"CHOOSE(MATCH(B61,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J46*'[3]3.11 LoadForecast'!C90,'[3]3.11 LoadForecast'!$J76)","v":3095.9473995858807},6.0070202163371115E-3,18.597418618028694]
["Sentinel Lighting",{"$f":"'[3]0.2 Customer Classes'!$D$17","v":"kW"},4066,4714,{"$f":"CHOOSE(MATCH(B62,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I47*'[3]3.11 LoadForecast'!B91,'[3]3.11 LoadForecast'!$I77)","v":61},{"$f":"'[11]9. RTSR Rates to Forecast'!D21","v":1.8997999999999999},115.8878,{"$f":"CHOOSE(MATCH(B62,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J47*'[3]3.11 LoadForecast'!C91,'[3]3.11 LoadForecast'!$J77)","v":61},1.9017130645496756,116.00449693753021]
["Street Lighting ",{"$f":"'[3]0.2 Customer Classes'!$D$18","v":"kW"},4066,4714,{"$f":"CHOOSE(MATCH(B63,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I48*'[3]3.11 LoadForecast'!B92,'[3]3.11 LoadForecast'!$I78)","v":774},{"$f":"'[11]9. RTSR Rates to Forecast'!D22","v":1.8902000000000001},1463.0148000000002,{"$f":"CHOOSE(MATCH(B63,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J48*'[3]3.11 LoadForecast'!C92,'[3]3.11 LoadForecast'!$J78)","v":773.69999999999982},1.8921343618448685,1463.9443557593745]
["other",{"$f":"'[3]0.2 Customer Classes'!$D$19","v":0},4066,4714,{"$f":"CHOOSE(MATCH(B64,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I49*'[3]3.11 LoadForecast'!B93,'[3]3.11 LoadForecast'!$I79)","v":1},0,0,{"$f":"CHOOSE(MATCH(B64,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J49*'[3]3.11 LoadForecast'!C93,'[3]3.11 LoadForecast'!$J79)","v":1},0,0]
[0,{"$f":"'[3]0.2 Customer Classes'!$D$20","v":0},4066,4714,{"$f":"CHOOSE(MATCH(B65,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I50*'[3]3.11 LoadForecast'!B94,'[3]3.11 LoadForecast'!$I80)","v":1},0,0,{"$f":"CHOOSE(MATCH(B65,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J50*'[3]3.11 LoadForecast'!C94,'[3]3.11 LoadForecast'!$J80)","v":1},0,0]
[0,{"$f":"'[3]0.2 Customer Classes'!$D$21","v":0},4066,4714,{"$f":"CHOOSE(MATCH(B66,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I51*'[3]3.11 LoadForecast'!B95,'[3]3.11 LoadForecast'!$I81)","v":1},0,0,{"$f":"CHOOSE(MATCH(B66,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J51*'[3]3.11 LoadForecast'!C95,'[3]3.11 LoadForecast'!$J81)","v":1},0,0]
["TOTAL"," ",null,null,{"$f":"SUM(E58:E66)","v":19115656.537490837},null,{"$f":"SUM(G58:G66)","v":172989.44947084688},{"$f":"SUM(H58:H66)","v":19161542.456227086},null,{"$f":"SUM(J58:J66)","v":172965.57699947589}]
[]
["Transmission - Connection"]
["(volumes for the bridge and test year are automatically loss adjusted)"]
[null,null,null,null,{"$f":"'[3]0.1 LDC Info'!$E$23","v":2018},null,null,{"$f":"'[3]0.1 LDC Info'!$E$25","v":2019}]
["Customer",null,"Revenue","Expense",null," ",null,null," "]
["Class Name",null,"USA #","USA #","Volume","Rate","Amount","Volume","Rate","Amount"]
[{"$f":"A15","v":"Residential"},{"$f":"'[3]0.2 Customer Classes'!$D$13","v":"kWh"},4068,4716,{"$f":"CHOOSE(MATCH(B74,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I43*'[3]3.11 LoadForecast'!B87,'[3]3.11 LoadForecast'!$I73)","v":14171745.740261581},{"$f":"'[11]9. RTSR Rates to Forecast'!D27","v":1.6000000000000001E-3},{"$f":"E74*F74","v":22674.79318441853},{"$f":"CHOOSE(MATCH(B74,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J43*'[3]3.11 LoadForecast'!C87,'[3]3.11 LoadForecast'!$J73)","v":14147726.037523417},1.8310456010833668E-3,{"$f":"H74*I74","v":25905.131526339865}]
["General Service < 50 kW",{"$f":"'[3]0.2 Customer Classes'!$D$14","v":"kWh"},4068,4716,{"$f":"CHOOSE(MATCH(B75,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I44*'[3]3.11 LoadForecast'!B88,'[3]3.11 LoadForecast'!$I74)","v":4921868.0477872528},{"$f":"'[11]9. RTSR Rates to Forecast'!D28","v":1.6000000000000001E-3},7874.9888764596053,{"$f":"CHOOSE(MATCH(B75,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J44*'[3]3.11 LoadForecast'!C88,'[3]3.11 LoadForecast'!$J74)","v":4991913.0654130662},1.8310440593838834E-3,9140.4127633853859]
["General Service > 50 to 4999 kW",{"$f":"'[3]0.2 Customer Classes'!$D$15","v":"kW"},4068,4716,{"$f":"CHOOSE(MATCH(B76,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I45*'[3]3.11 LoadForecast'!B89,'[3]3.11 LoadForecast'!$I75)","v":18152.243442001676},{"$f":"'[11]9. RTSR Rates to Forecast'!D29","v":0.57630000000000003},10461.137895625567,{"$f":"CHOOSE(MATCH(B76,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J45*'[3]3.11 LoadForecast'!C89,'[3]3.11 LoadForecast'!$J75)","v":17969.705891017529},0.65952002630294126,11851.3809019]
["Unmetered Scattered Load",{"$f":"'[3]0.2 Customer Classes'!$D$16","v":"kWh"},4068,4716,{"$f":"CHOOSE(MATCH(B77,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I46*'[3]3.11 LoadForecast'!B90,'[3]3.11 LoadForecast'!$I76)","v":3052.5060000000003},{"$f":"'[11]9. RTSR Rates to Forecast'!D30","v":1.6000000000000001E-3},4.8840096000000006,{"$f":"CHOOSE(MATCH(B77,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J46*'[3]3.11 LoadForecast'!C90,'[3]3.11 LoadForecast'!$J76)","v":3095.9473995858807},1.8311963838962123E-3,5.6692876828545469]
["Sentinel Lighting",{"$f":"'[3]0.2 Customer Classes'!$D$17","v":"kW"},4068,4716,{"$f":"CHOOSE(MATCH(B78,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I47*'[3]3.11 LoadForecast'!B91,'[3]3.11 LoadForecast'!$I77)","v":61},{"$f":"'[11]9. RTSR Rates to Forecast'!D31","v":0.45490000000000003},27.748900000000003,{"$f":"CHOOSE(MATCH(B78,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J47*'[3]3.11 LoadForecast'!C91,'[3]3.11 LoadForecast'!$J77)","v":61},0.52052335484792112,31.751924645723189]
["Street Lighting ",{"$f":"'[3]0.2 Customer Classes'!$D$18","v":"kW"},4068,4716,{"$f":"CHOOSE(MATCH(B79,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I48*'[3]3.11 LoadForecast'!B92,'[3]3.11 LoadForecast'!$I78)","v":774},{"$f":"'[11]9. RTSR Rates to Forecast'!D32","v":0.4456},344.89440000000002,{"$f":"CHOOSE(MATCH(B79,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J48*'[3]3.11 LoadForecast'!C92,'[3]3.11 LoadForecast'!$J78)","v":773.69999999999982},0.50994246665382936,394.54248645006771]
["other",{"$f":"'[3]0.2 Customer Classes'!$D$19","v":0},4068,4716,{"$f":"CHOOSE(MATCH(B80,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I49*'[3]3.11 LoadForecast'!B93,'[3]3.11 LoadForecast'!$I79)","v":1},0,0,{"$f":"CHOOSE(MATCH(B80,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J49*'[3]3.11 LoadForecast'!C93,'[3]3.11 LoadForecast'!$J79)","v":1},0,0]
[0,{"$f":"'[3]0.2 Customer Classes'!$D$20","v":0},4068,4716,{"$f":"CHOOSE(MATCH(B81,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I50*'[3]3.11 LoadForecast'!B94,'[3]3.11 LoadForecast'!$I80)","v":1},0,0,{"$f":"CHOOSE(MATCH(B81,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J50*'[3]3.11 LoadForecast'!C94,'[3]3.11 LoadForecast'!$J80)","v":1},0,0]
[0,{"$f":"'[3]0.2 Customer Classes'!$D$21","v":0},4068,4716,{"$f":"CHOOSE(MATCH(B82,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I51*'[3]3.11 LoadForecast'!B95,'[3]3.11 LoadForecast'!$I81)","v":1},0,0,{"$f":"CHOOSE(MATCH(B82,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J51*'[3]3.11 LoadForecast'!C95,'[3]3.11 LoadForecast'!$J81)","v":1},0,0]
["TOTAL"," "," "," ",{"$f":"SUM(E74:E82)","v":19115656.537490837},null,{"$f":"SUM(G74:G82)","v":41388.447266103693},{"$f":"SUM(H74:H82)","v":19161542.456227086},null,{"$f":"SUM(J74:J82)","v":47328.888890403898}]
[]
["Wholesale Market Service"]
["(volumes for the bridge and test year are automatically loss adjusted)"]
[null,null,null,null,{"$f":"'[3]0.1 LDC Info'!$E$23","v":2018},null,null,{"$f":"'[3]0.1 LDC Info'!$E$25","v":2019}]
["Customer",null,"Revenue","Expense"," ","rate ($/kWh):",5.2000000000000006E-3," ","rate ($/kWh):",5.2000000000000006E-3]
["Class Name",null,"USA #","USA #","Volume",null,"Amount","Volume",null,"Amount"]
[{"$f":"A15","v":"Residential"},{"$f":"'[3]0.2 Customer Classes'!$D$13","v":"kWh"},4062,4708,{"$f":"CHOOSE(MATCH(B90,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I43*'[3]3.11 LoadForecast'!B87,'[3]3.11 LoadForecast'!$I73)","v":14171745.740261581},3.5999999999999999E-3,{"$f":"E90*F90","v":51018.28466494169},{"$f":"CHOOSE(MATCH(B90,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J43*'[3]3.11 LoadForecast'!C87,'[3]3.11 LoadForecast'!$J73)","v":14147726.037523417},3.3999999999999998E-3,{"$f":"H90*I90","v":48102.268527579618}]
["General Service < 50 kW",{"$f":"'[3]0.2 Customer Classes'!$D$13","v":"kWh"},4062,4708,{"$f":"CHOOSE(MATCH(B91,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I44*'[3]3.11 LoadForecast'!B88,'[3]3.11 LoadForecast'!$I74)","v":4921868.0477872528},3.5999999999999999E-3,17718.72497203411,{"$f":"CHOOSE(MATCH(B91,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J44*'[3]3.11 LoadForecast'!C88,'[3]3.11 LoadForecast'!$J74)","v":4991913.0654130662},3.3999999999999998E-3,16972.504422404425]
["General Service > 50 to 4999 kW",{"$f":"'[3]0.2 Customer Classes'!$D$13","v":"kWh"},4062,4708,{"$f":"CHOOSE(MATCH(B92,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I45*'[3]3.11 LoadForecast'!B89,'[3]3.11 LoadForecast'!$I75)","v":7221084.6917733587},3.5999999999999999E-3,25995.904890384092,{"$f":"CHOOSE(MATCH(B92,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J45*'[3]3.11 LoadForecast'!C89,'[3]3.11 LoadForecast'!$J75)","v":7323850.7553089615},3.3999999999999998E-3,24901.092568050466]
["Unmetered Scattered Load",{"$f":"'[3]0.2 Customer Classes'!$D$13","v":"kWh"},4062,4708,{"$f":"CHOOSE(MATCH(B93,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I46*'[3]3.11 LoadForecast'!B90,'[3]3.11 LoadForecast'!$I76)","v":3052.5060000000003},3.5999999999999999E-3,10.989021600000001,{"$f":"CHOOSE(MATCH(B93,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J46*'[3]3.11 LoadForecast'!C90,'[3]3.11 LoadForecast'!$J76)","v":3095.9473995858807},3.3999999999999998E-3,10.526221158591994]
["Sentinel Lighting",{"$f":"'[3]0.2 Customer Classes'!$D$13","v":"kWh"},4062,4708,{"$f":"CHOOSE(MATCH(B94,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I47*'[3]3.11 LoadForecast'!B91,'[3]3.11 LoadForecast'!$I77)","v":21438.2605},3.5999999999999999E-3,77.177737800000003,{"$f":"CHOOSE(MATCH(B94,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J47*'[3]3.11 LoadForecast'!C91,'[3]3.11 LoadForecast'!$J77)","v":21743.356719567364},3.3999999999999998E-3,73.927412846529037]
["Street Lighting ",{"$f":"'[3]0.2 Customer Classes'!$D$13","v":"kWh"},4062,4708,{"$f":"CHOOSE(MATCH(B95,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I48*'[3]3.11 LoadForecast'!B92,'[3]3.11 LoadForecast'!$I78)","v":299727.37960000004},3.5999999999999999E-3,1079.0185665600002,{"$f":"CHOOSE(MATCH(B95,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J48*'[3]3.11 LoadForecast'!C92,'[3]3.11 LoadForecast'!$J78)","v":303992.91646185465},3.3999999999999998E-3,1033.5759159703057]
["other",{"$f":"'[3]0.2 Customer Classes'!$D$19","v":0},4062,4708,{"$f":"CHOOSE(MATCH(B96,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I49*'[3]3.11 LoadForecast'!B93,'[3]3.11 LoadForecast'!$I79)","v":1},3.5999999999999999E-3,3.5999999999999999E-3,{"$f":"CHOOSE(MATCH(B96,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J49*'[3]3.11 LoadForecast'!C93,'[3]3.11 LoadForecast'!$J79)","v":1},3.3999999999999998E-3,3.3999999999999998E-3]
[0,{"$f":"'[3]0.2 Customer Classes'!$D$20","v":0},4062,4708,{"$f":"CHOOSE(MATCH(B97,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I50*'[3]3.11 LoadForecast'!B94,'[3]3.11 LoadForecast'!$I80)","v":1},3.5999999999999999E-3,3.5999999999999999E-3,{"$f":"CHOOSE(MATCH(B97,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J50*'[3]3.11 LoadForecast'!C94,'[3]3.11 LoadForecast'!$J80)","v":1},3.3999999999999998E-3,3.3999999999999998E-3]
[0,{"$f":"'[3]0.2 Customer Classes'!$D$21","v":0},4062,4708,{"$f":"CHOOSE(MATCH(B98,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I51*'[3]3.11 LoadForecast'!B95,'[3]3.11 LoadForecast'!$I81)","v":1},3.5999999999999999E-3,3.5999999999999999E-3,{"$f":"CHOOSE(MATCH(B98,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J51*'[3]3.11 LoadForecast'!C95,'[3]3.11 LoadForecast'!$J81)","v":1},3.3999999999999998E-3,3.3999999999999998E-3]
["TOTAL"," "," "," ",{"$f":"SUM(E90:E98)","v":26638919.625922192},null,{"$f":"SUM(G90:G98)","v":95900.110653319876},{"$f":"SUM(H90:H98)","v":26792325.078826457},null,{"$f":"SUM(J90:J98)","v":91093.905268009941}]
[]
["Rural Rate Protection"]
["(volumes for the bridge and test year are automatically loss adjusted)"]
[null,null,null,null,{"$f":"'[3]0.1 LDC Info'!$E$23","v":2018},null,null,{"$f":"'[3]0.1 LDC Info'!$E$25","v":2019}]
["Customer",null,"Revenue","Expense"," ","rate ($/kWh):"," "," ","rate ($/kWh):"," "]
["Class Name",null,"USA #","USA #","Volume",null,"Amount","Volume",null,"Amount"]
[{"$f":"A15","v":"Residential"},{"$f":"'[3]0.2 Customer Classes'!$D$13","v":"kWh"},4062,4730,{"$f":"CHOOSE(MATCH(B106,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I43*'[3]3.11 LoadForecast'!B87,'[3]3.11 LoadForecast'!$I73)","v":14171745.740261581},1.2999999999999999E-3,{"$f":"E106*F106","v":18423.269462340053},{"$f":"CHOOSE(MATCH(B106,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J43*'[3]3.11 LoadForecast'!C87,'[3]3.11 LoadForecast'!$J73)","v":14147726.037523417},5.0000000000000001E-4,{"$f":"H106*I106","v":7073.8630187617082}]
["General Service < 50 kW",{"$f":"'[3]0.2 Customer Classes'!$D$14","v":"kWh"},4062,4730,{"$f":"CHOOSE(MATCH(B107,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I44*'[3]3.11 LoadForecast'!B88,'[3]3.11 LoadForecast'!$I74)","v":4921868.0477872528},1.2999999999999999E-3,6398.4284621234283,{"$f":"CHOOSE(MATCH(B107,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J44*'[3]3.11 LoadForecast'!C88,'[3]3.11 LoadForecast'!$J74)","v":4991913.0654130662},5.0000000000000001E-4,2495.9565327065329]
["General Service > 50 to 4999 kW",{"$f":"'[3]0.2 Customer Classes'!$D$14","v":"kWh"},4062,4730,{"$f":"CHOOSE(MATCH(B108,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I45*'[3]3.11 LoadForecast'!B89,'[3]3.11 LoadForecast'!$I75)","v":7221084.6917733587},1.2999999999999999E-3,9387.4100993053653,{"$f":"CHOOSE(MATCH(B108,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J45*'[3]3.11 LoadForecast'!C89,'[3]3.11 LoadForecast'!$J75)","v":7323850.7553089615},5.0000000000000001E-4,3661.9253776544806]
["Unmetered Scattered Load",{"$f":"'[3]0.2 Customer Classes'!$D$14","v":"kWh"},4062,4730,{"$f":"CHOOSE(MATCH(B109,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I46*'[3]3.11 LoadForecast'!B90,'[3]3.11 LoadForecast'!$I76)","v":3052.5060000000003},1.2999999999999999E-3,3.9682578000000004,{"$f":"CHOOSE(MATCH(B109,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J46*'[3]3.11 LoadForecast'!C90,'[3]3.11 LoadForecast'!$J76)","v":3095.9473995858807},5.0000000000000001E-4,1.5479736997929403]
["Sentinel Lighting",{"$f":"'[3]0.2 Customer Classes'!$D$14","v":"kWh"},4062,4730,{"$f":"CHOOSE(MATCH(B110,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I47*'[3]3.11 LoadForecast'!B91,'[3]3.11 LoadForecast'!$I77)","v":21438.2605},1.2999999999999999E-3,27.869738649999999,{"$f":"CHOOSE(MATCH(B110,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J47*'[3]3.11 LoadForecast'!C91,'[3]3.11 LoadForecast'!$J77)","v":21743.356719567364},5.0000000000000001E-4,10.871678359783683]
["Street Lighting ",{"$f":"'[3]0.2 Customer Classes'!$D$14","v":"kWh"},4062,4730,{"$f":"CHOOSE(MATCH(B111,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I48*'[3]3.11 LoadForecast'!B92,'[3]3.11 LoadForecast'!$I78)","v":299727.37960000004},1.2999999999999999E-3,389.64559348000006,{"$f":"CHOOSE(MATCH(B111,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J48*'[3]3.11 LoadForecast'!C92,'[3]3.11 LoadForecast'!$J78)","v":303992.91646185465},5.0000000000000001E-4,151.99645823092732]
["other",{"$f":"'[3]0.2 Customer Classes'!$D$19","v":0},4062,4730,{"$f":"CHOOSE(MATCH(B112,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I49*'[3]3.11 LoadForecast'!B93,'[3]3.11 LoadForecast'!$I79)","v":1},1.2999999999999999E-3,1.2999999999999999E-3,{"$f":"CHOOSE(MATCH(B112,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J49*'[3]3.11 LoadForecast'!C93,'[3]3.11 LoadForecast'!$J79)","v":1},5.0000000000000001E-4,5.0000000000000001E-4]
[0,{"$f":"'[3]0.2 Customer Classes'!$D$20","v":0},4062,4730,{"$f":"CHOOSE(MATCH(B113,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I50*'[3]3.11 LoadForecast'!B94,'[3]3.11 LoadForecast'!$I80)","v":1},1.2999999999999999E-3,1.2999999999999999E-3,{"$f":"CHOOSE(MATCH(B113,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J50*'[3]3.11 LoadForecast'!C94,'[3]3.11 LoadForecast'!$J80)","v":1},5.0000000000000001E-4,5.0000000000000001E-4]
[0,{"$f":"'[3]0.2 Customer Classes'!$D$21","v":0},4062,4730,{"$f":"CHOOSE(MATCH(B114,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I51*'[3]3.11 LoadForecast'!B95,'[3]3.11 LoadForecast'!$I81)","v":1},1.2999999999999999E-3,1.2999999999999999E-3,{"$f":"CHOOSE(MATCH(B114,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J51*'[3]3.11 LoadForecast'!C95,'[3]3.11 LoadForecast'!$J81)","v":1},5.0000000000000001E-4,5.0000000000000001E-4]
["TOTAL"," "," "," ",{"$f":"SUM(E106:E114)","v":26638919.625922192},null,{"$f":"SUM(G106:G114)","v":34630.595513698856},{"$f":"SUM(H106:H114)","v":26792325.078826457},null,{"$f":"SUM(J106:J114)","v":13396.162539413226}]
[]
["Smart Meter Entity Charge"]
["(per customer)"]
[null,null,null,null,{"$f":"'[3]0.1 LDC Info'!$E$23","v":2018},null,null,{"$f":"'[3]0.1 LDC Info'!$E$25","v":2019}]
["Customer",null,"Revenue","Expense"," ","rate ($/kWh):"," "," ","rate ($/kWh):"," "]
["Class Name",null,"USA #","USA #","Volume",null,"Amount","Volume",null,"Amount"]
[{"$f":"A15","v":"Residential"},"Cust",null,null,{"$f":"'[3]3.11 LoadForecast'!I14","v":1043.4883679087588},0,{"$f":"E122*F122","v":0},{"$f":"'[3]3.11 LoadForecast'!J14","v":1047},0.56999999999999995,{"$f":"H122*I122*12","v":7161.48}]
[{"$f":"A16","v":"General Service < 50 kW"},"Cust",null,null,{"$f":"'[3]3.11 LoadForecast'!I15","v":150.21997525073792},0,{"$f":"E123*F123","v":0},{"$f":"'[3]3.11 LoadForecast'!J15","v":149},0.56999999999999995,{"$f":"H123*I123*12","v":1019.1599999999999}]
[{"$f":"A17","v":"General Service > 50 to 4999 kW"},"Cust",null,null,0,0,{"$f":"E124*F124","v":0},0,0.56999999999999995,{"$f":"H124*I124*12","v":0}]
["TOTAL"," "," "," ",{"$f":"SUM(E122:E124)","v":1193.7083431594967},null,{"$f":"SUM(G122:G124)","v":0},{"$f":"SUM(H122:H124)","v":1196},null,{"$f":"SUM(J122:J124)","v":8180.6399999999994}]
[]
["OESP"]
["(volumes for the bridge and test year are automatically loss adjusted)"]
[null,null,null,null,{"$f":"'[3]0.1 LDC Info'!$E$23","v":2018},null,null,{"$f":"'[3]0.1 LDC Info'!$E$25","v":2019}]
["Customer",null,"Revenue","Expense"," ","rate ($/kWh):"," "," ","rate ($/kWh):"," "]
["Class Name",null,"USA #","USA #","Volume",null,"Amount","Volume",null,"Amount"]
[{"$f":"A42","v":"Residential"},{"$f":"'[3]0.2 Customer Classes'!$D$13","v":"kWh"},4062,4730,{"$f":"CHOOSE(MATCH(B132,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I43*'[3]3.11 LoadForecast'!B87,'[3]3.11 LoadForecast'!$I73)","v":14171745.740261581},0,{"$f":"E132*F132","v":0},{"$f":"CHOOSE(MATCH(B132,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J43*'[3]3.11 LoadForecast'!C87,'[3]3.11 LoadForecast'!$J73)","v":14147726.037523417},0,{"$f":"H132*I132","v":0}]
[{"$f":"A43","v":"General Service < 50 kW"},{"$f":"'[3]0.2 Customer Classes'!$D$14","v":"kWh"},4062,4730,{"$f":"CHOOSE(MATCH(B133,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I44*'[3]3.11 LoadForecast'!B88,'[3]3.11 LoadForecast'!$I74)","v":4921868.0477872528},0,{"$f":"E133*F133","v":0},{"$f":"CHOOSE(MATCH(B133,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J44*'[3]3.11 LoadForecast'!C88,'[3]3.11 LoadForecast'!$J74)","v":4991913.0654130662},0,{"$f":"H133*I133","v":0}]
["TOTAL"," "," "," ",{"$f":"SUM(E132:E133)","v":19093613.788048834},null,{"$f":"SUM(G132:G133)","v":0},{"$f":"SUM(H132:H133)","v":19139639.102936484},null,{"$f":"SUM(J132:J133)","v":0}]
[]
[]
["Low Voltage Charges - Historical and Proposed LV Charges"]
[" "]
[null,null,null,null,{"$f":"'[3]0.1 LDC Info'!$E$27","v":2012},{"$f":"'[3]0.1 LDC Info'!$E$27+1","v":2013},{"$f":"'[3]0.1 LDC Info'!$E$27+2","v":2014},{"$f":"'[3]0.1 LDC Info'!$E$27+3","v":2015},{"$f":"'[3]0.1 LDC Info'!$E$27+4","v":2016},2017,2018,"AVG"]
[]
[{"$f":"'[3]1.2 TB Historical Balances'!B313","v":"4075-Billed - LV\n"},null,null,null,-30387.55,-17153.5,-19856.55,-17265.37,-14687.88,-14621.87," ",{"$f":"AVERAGE(G141:J141)","v":-16607.9175}]
[{"$f":"'[3]1.2 TB Historical Balances'!B404","v":"4750-Charges - LV\n"},null,null,null,15490.89,39969.43,71247.38,74594.78,70967.399999999994,59187.4,38844,{"$f":"AVERAGE(K142)","v":38844}]
["1551 LV Charges",null,null,null,{"$f":"'[3]1.2 TB Historical Balances'!J84","v":-31254.43},{"$f":"'[3]1.2 TB Historical Balances'!M84","v":7220.02},{"$f":"'[3]1.2 TB Historical Balances'!P84","v":39576.28},{"$f":"'[3]1.2 TB Historical Balances'!S84","v":110948.96},{"$f":"'[3]1.2 TB Historical Balances'!V84","v":153699.85},{"$f":"'[3]1.2 TB Historical Balances'!Y84","v":200139.14},{"$f":"'[3]1.2 TB Historical Balances'!Z84","v":0}]
["Low Voltage Charges - Allocation of LV Charges based on Transmission Connection Revenues"]
["(volumes are not loss adjusted)"]
[]
[null,"ALLOCATON BASED ON TRANSMISSION-CONNECTION REVENUE"]
["Customer Class Name",null,"RTSR Rate","Uplifted Volumes",null,"Revenue","% Alloc"]
[{"$f":"A15","v":"Residential"},{"$f":"'[3]0.2 Customer Classes'!$D$13","v":"kWh"},{"$f":"I74","v":1.8310456010833668E-3},{"$f":"H58","v":14147726.037523417},null,{"$f":"C149*D149","v":25905.131526339865},{"$f":"F149/$F$158","v":0.54734290480231884}]
["General Service < 50 kW",{"$f":"'[3]0.2 Customer Classes'!$D$14","v":"kWh"},1.8310440593838834E-3,4991913.0654130662,null,9140.4127633853859,0.19312544574099727]
["General Service > 50 to 4999 kW",{"$f":"'[3]0.2 Customer Classes'!$D$15","v":"kW"},0.65952002630294126,17969.705891017529,null,11851.3809019,0.25040479883952887]
["Unmetered Scattered Load",{"$f":"'[3]0.2 Customer Classes'!$D$16","v":"kWh"},1.8311963838962123E-3,{"$f":"H61","v":3095.9473995858807},null,5.6692876828545469,1.1978493084810227E-4]
["Sentinel Lighting",{"$f":"'[3]0.2 Customer Classes'!$D$17","v":"kW"},0.52052335484792112,61,null,31.751924645723189,6.7087830266306981E-4]
["Street Lighting ",{"$f":"'[3]0.2 Customer Classes'!$D$18","v":"kW"},0.50994246665382936,773.69999999999982,null,394.54248645006771,8.3361873836438755E-3]
["other",{"$f":"'[3]0.2 Customer Classes'!$D$19","v":0},0,1,null,0,0]
[0,{"$f":"'[3]0.2 Customer Classes'!$D$19","v":0},0,1,null,0,0]
[{"$f":"A22","v":0},{"$f":"'[3]0.2 Customer Classes'!$D$19","v":0},0,1,null,0,0]
["TOTAL",null,null,{"$f":"SUM(D149:E157)","v":19161542.456227086},null,{"$f":"SUM(F149:F157)","v":47328.888890403898},{"$f":"SUM(G149:G157)","v":0.99999999999999989}]
[]
["Low Voltage Charges Rate Rider Calculations"]
["(volumes are not loss adjusted)"]
[]
[null,"PROPOSED LOW VOLTAGE CHARGES & RATES"]
["Customer Class Name","% Allocation",null,null,"Charges","Not Uplifted Volumes","Rate","per"]
[{"$f":"A15","v":"Residential"},{"$f":"G149","v":0.54734290480231884},null,null,{"$f":"$E$174*B165","v":21260.987794141274},{"$f":"CHOOSE(MATCH(B106,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J43,'[3]3.11 LoadForecast'!$J73)","v":13215736.063859034},{"$f":"ROUND(E165/F165,4)","v":1.6000000000000001E-3},{"$f":"'[3]0.2 Customer Classes'!$D13","v":"kWh"}]
["General Service < 50 kW",0.19312544574099727,null,null,7501.7648143632978,{"$f":"CHOOSE(MATCH(B107,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J44,'[3]3.11 LoadForecast'!$J74)","v":4663067.7856819062},1.6000000000000001E-3,{"$f":"'[3]0.2 Customer Classes'!$D14","v":"kWh"}]
["General Service > 50 to 4999 kW",0.25040479883952887,null,null,9726.7240061226603,{"$f":"CHOOSE(MATCH(H167,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J45,'[3]3.11 LoadForecast'!$J75)","v":17969.705891017529},{"$f":"ROUND(E167/F167,4)","v":0.5413},{"$f":"'[3]0.2 Customer Classes'!$D15","v":"kW"}]
["Unmetered Scattered Load",1.1978493084810227E-4,null,null,{"$f":"$E$174*B168","v":4.6529258538636844},{"$f":"CHOOSE(MATCH(H168,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J46,'[3]3.11 LoadForecast'!$J76)","v":2892},1.6000000000000001E-3,{"$f":"'[3]0.2 Customer Classes'!$D16","v":"kWh"}]
["Sentinel Lighting",6.7087830266306981E-4,null,null,26.059596788644285,{"$f":"CHOOSE(MATCH(H169,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J47,'[3]3.11 LoadForecast'!$J77)","v":61},0.42720000000000002,{"$f":"'[3]0.2 Customer Classes'!$D17","v":"kW"}]
["Street Lighting ",8.3361873836438755E-3,null,null,323.81086273026267,{"$f":"CHOOSE(MATCH(H170,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J48,'[3]3.11 LoadForecast'!$J78)","v":773.69999999999982},0.41849999999999998,{"$f":"'[3]0.2 Customer Classes'!$D18","v":"kW"}]
["other",0,null,null,0,{"$f":"CHOOSE(MATCH(B112,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J49,'[3]3.11 LoadForecast'!$J79)","v":1},0,{"$f":"'[3]0.2 Customer Classes'!$D19","v":0}]
[0,0,null,null,0,{"$f":"CHOOSE(MATCH(B113,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J50,'[3]3.11 LoadForecast'!$J80)","v":1},0,{"$f":"'[3]0.2 Customer Classes'!$D20","v":0}]
[0,0,null,null,0,{"$f":"CHOOSE(MATCH(B114,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$J51,'[3]3.11 LoadForecast'!$J81)","v":1},0,{"$f":"'[3]0.2 Customer Classes'!$D21","v":0}]
["TOTAL",{"$f":"SUM(B165:D173)","v":0.99999999999999989},null,null,{"$f":"L142","v":38844},{"$f":"SUM(F165:F173)","v":17900503.255431958}]
[]
["Low Voltage Charges to be added to power supply expense for bridge and test year."]
["(volumes are not loss adjusted)"]
[]
["Customer",null,"Revenue","Expense",2018,null,null,2019]
["Class Name",null,"USA #","USA #","Volume","Rate","Amount","Volume","Rate","Amount"]
[{"$f":"A15","v":"Residential"},{"$f":"'[3]0.2 Customer Classes'!$D$13","v":"kWh"},4075,4750,{"$f":"CHOOSE(MATCH(B149,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I43,'[3]3.11 LoadForecast'!$I73)","v":13426571.04714503},5.9999999999999995E-4,{"$f":"E181*F181","v":8055.9426282870172},{"$f":"F165","v":13215736.063859034},1.6000000000000001E-3,{"$f":"H181*I181","v":21145.177702174456}]
["General Service < 50 kW",{"$f":"'[3]0.2 Customer Classes'!$D$14","v":"kWh"},4075,4750,{"$f":"CHOOSE(MATCH(B150,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I44,'[3]3.11 LoadForecast'!$I74)","v":4663067.7856819062},5.9999999999999995E-4,2797.8406714091434,4663067.7856819062,1.6000000000000001E-3,7460.90845709105]
["General Service > 50 to 4999 kW",{"$f":"'[3]0.2 Customer Classes'!$D$15","v":"kW"},4075,4750,{"$f":"CHOOSE(MATCH(B151,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I45,'[3]3.11 LoadForecast'!$I75)","v":18152.243442001676},0.22559999999999999,4095.1461205155779,17969.705891017529,0.5413,9727.0017988077889]
["Unmetered Scattered Load",{"$f":"'[3]0.2 Customer Classes'!$D$16","v":"kWh"},4075,4750,{"$f":"CHOOSE(MATCH(B152,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I46,'[3]3.11 LoadForecast'!$I76)","v":2892},5.9999999999999995E-4,1.7351999999999999,2892,1.6000000000000001E-3,4.6272000000000002]
["Sentinel Lighting",{"$f":"'[3]0.2 Customer Classes'!$D$17","v":"kW"},4075,4750,{"$f":"CHOOSE(MATCH(B153,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I47,'[3]3.11 LoadForecast'!$I77)","v":61},0.2261,13.7921,61,0.42720000000000002,26.059200000000001]
["Street Lighting ",{"$f":"'[3]0.2 Customer Classes'!$D$18","v":"kW"},4075,4750,{"$f":"CHOOSE(MATCH(B154,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I48,'[3]3.11 LoadForecast'!$I78)","v":774},0.21729999999999999,168.1902,773.69999999999982,0.41849999999999998,323.79344999999989]
["other",{"$f":"'[3]0.2 Customer Classes'!$D$19","v":0},4075,4750,{"$f":"CHOOSE(MATCH(B155,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I49,'[3]3.11 LoadForecast'!$I79)","v":1},0,0,1,0,0]
[0,{"$f":"'[3]0.2 Customer Classes'!$D$20","v":0},4075,4750,{"$f":"CHOOSE(MATCH(B156,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I50,'[3]3.11 LoadForecast'!$I80)","v":1},0,0,1,0,0]
[0,{"$f":"'[3]0.2 Customer Classes'!$D$21","v":0},4075,4750,{"$f":"CHOOSE(MATCH(B157,{0,\"kWh\",\"kW\"},0),1,'[3]3.11 LoadForecast'!$I51,'[3]3.11 LoadForecast'!$I81)","v":1},0,0,1,0,0]
["TOTAL"," ",0,0,{"$f":"SUM(E181:E189)","v":18111521.076268937},null,{"$f":"SUM(G181:G189)","v":15132.646920211737},{"$f":"SUM(H181:H189)","v":17900503.255431958},null,{"$f":"SUM(J181:J189)","v":38687.567808073298}]
[]
[]
["Projected Power Supply Expense",null,null,null,null,null,{"$f":"G51+G67+G83+G99+G115+G125+G190","v":2522950.2881949716},null,null,{"$f":"J51+J67+J83+J99+J115+J125+J134+J190","v":2571771.9266973292}]