{"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":1,"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":[[22,2,22,3],[16,2,16,3],[17,2,17,3],[118,7,118,9],[157,3,157,4],[171,1,171,3],[8,0,8,14],[9,0,9,14],[13,2,13,3],[14,2,14,3],[15,2,15,3],[12,2,12,3],[19,2,19,3],[70,7,70,9],[102,4,102,6],[102,7,102,9],[86,4,86,6],[86,7,86,9],[38,7,38,9],[54,4,54,6],[54,7,54,9],[70,4,70,6],[38,4,38,6],[152,3,152,4],[153,3,153,4],[154,3,154,4],[156,3,156,4],[18,2,18,3],[23,2,23,3],[24,2,24,3],[118,4,118,6],[20,2,20,3],[21,2,21,3],[146,1,146,6],[147,3,147,4],[148,3,148,4],[149,3,149,4],[150,3,150,4],[151,3,151,4],[166,1,166,3],[167,1,167,3],[168,1,168,3],[169,1,169,3],[162,1,162,7],[163,1,163,3],[164,1,164,3],[13,5,13,7],[128,4,128,6],[128,7,128,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]]}
[null,null,null,null,null,null,null,null,null,null,null,"File Number:","EB-2018-0087"]
[null,null,null,null,null,null,null,null,null,null,null,"Exhibit:"]
[null,null,null,null,null,null,null,null,null,null,null,"Tab:"]
[null,null,null,null,null,null,null,null,null,null,null,"Schedule:"]
[null,null,null,null,null,null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[" "]
["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,{"$f":"'[1]3.11 LoadForecast'!H28","v":12775802},null,null,null,null,{"$f":"SUM(F15:G15)","v":0},null,{"$f":"C15-(F15+G15)","v":12775802},{"$f":"+H15/C15","v":0},{"$f":"+J15/C15","v":1}]
["General Service < 50 kW",null,{"$f":"'[1]3.11 LoadForecast'!H29","v":4702580},null,null,null,null,{"$f":"SUM(F16:G16)","v":0},null,{"$f":"C16-(F16+G16)","v":4702580},{"$f":"+H16/C16","v":0},{"$f":"+J16/C16","v":1}]
["General Service > 50 to 4999 kW",null,{"$f":"'[1]3.11 LoadForecast'!H30","v":6797046},null,null,null,{"$f":"C17","v":6797046},{"$f":"SUM(F17:G17)","v":6797046},null,{"$f":"C17-(F17+G17)","v":0},{"$f":"+H17/C17","v":1},{"$f":"+J17/C17","v":0}]
["Unmetered Scattered Load",null,{"$f":"'[1]3.11 LoadForecast'!H31","v":2892},null,null,null,null,{"$f":"SUM(F18:G18)","v":0},null,{"$f":"C18-(F18+G18)","v":2892},{"$f":"+H18/C18","v":0},{"$f":"+J18/C18","v":1}]
["Sentinel Lighting",null,{"$f":"'[1]3.11 LoadForecast'!H32","v":20629},null,null,null,null,{"$f":"SUM(F19:G19)","v":0},null,{"$f":"C19-(F19+G19)","v":20629},{"$f":"+H19/C19","v":0},{"$f":"+J19/C19","v":1}]
["Street Lighting ",null,{"$f":"'[1]3.11 LoadForecast'!H33","v":274259},null,null,null,null,{"$f":"SUM(F20:G20)","v":0},null,{"$f":"C20-(F20+G20)","v":274259},{"$f":"+H20/C20","v":0},{"$f":"+J20/C20","v":1}]
["other",null,0,null,null,null,null,{"$f":"SUM(F21:G21)","v":0},null,{"$f":"C21-(F21+G21)","v":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":6797046},{"$f":"SUM(H15:H23)","v":6797046},null,{"$f":"SUM(J15:J23)","v":17776162}]
["%"," ",{"$f":"$C$24/$C$24","v":1},null,null,{"$f":"$F$24/$C$24","v":0},{"$f":"$G$24/$C$24","v":0.27660393384534898},null,null,{"$f":"$J$24/$C$24","v":0.72339606615465102}]
[" "]
["Forecast Price",null,null,null,null,"GA modifiler ",44.38]
[]
["HOEP ($/MWh)",null,null,null,null,21.57,21.57]
["Global Adjustment ($/MWh)",null,null,null,null,103.8,{"$f":"F30-G27","v":59.419999999999995}]
["Adjustments",null,null,null,null,1,1]
["TOTAL ($/MWh)",null,null,null,null,{"$f":"SUM(F29:F31)","v":126.37},{"$f":"SUM(G29:G31)","v":81.99},null,null,82,null,null,null,null,null,null,null,null," "]
["$/kWh",null,null,null,null,{"$f":"F32/1000","v":0.12637000000000001},{"$f":"G32/1000","v":8.1989999999999993E-2},null,null,{"$f":"J32/1000","v":8.2000000000000003E-2}]
["%",null,null,null,null,{"$f":"F25","v":0},{"$f":"G25","v":0.27660393384534898},null,null,{"$f":"J25","v":0.72339606615465102}]
["WEIGHTED AVERAGE PRICE",null,{"$f":"SUM(F35:J35)","v":8.1997233960661553E-2},null,null,{"$f":"F33*F34","v":0},{"$f":"G33*G34","v":2.2678756535980161E-2},null,null,{"$f":"J33*J34","v":5.9318477424681389E-2}]
[]
["Electricity Projections"]
["(volumes for the bridge and test year are automatically loss adjusted)"]
[null,null,null,null,{"$f":"'[1]0.1 LDC Info'!$E$23","v":2018},null,null,{"$f":"'[1]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,'[1]3.11 LoadForecast'!$I43*'[1]3.11 LoadForecast'!B87,'[1]3.11 LoadForecast'!$I$3)","v":14859993.185582258},{"$f":"$C$35","v":8.1997233960661553E-2},{"$f":"E42*F42","v":1218478.3378920248},{"$f":"CHOOSE(MATCH(B42,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J43*'[1]3.11 LoadForecast'!C87,'[1]3.11 LoadForecast'!$J73)","v":14878532.350619528},{"$f":"$C$35","v":8.1997233960661553E-2},{"$f":"H42*I42","v":1219998.4981450213}]
[{"$f":"A16","v":"General Service < 50 kW"},"kWh",4010,4705,{"$f":"CHOOSE(MATCH(B43,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I44*'[1]3.11 LoadForecast'!B88,'[1]3.11 LoadForecast'!$I$3)","v":5151369.7220699713},{"$f":"$C$35","v":8.1997233960661553E-2},{"$f":"E43*F43","v":422398.06831843953},{"$f":"CHOOSE(MATCH(B43,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J44*'[1]3.11 LoadForecast'!C88,'[1]3.11 LoadForecast'!$J74)","v":5249882.9172130264},{"$f":"$C$35","v":8.1997233960661553E-2},{"$f":"H43*I43","v":430475.87782879692}]
[{"$f":"A17","v":"General Service > 50 to 4999 kW"},"kWh",4035,4705,{"$f":"CHOOSE(MATCH(B44,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I45*'[1]3.11 LoadForecast'!B89,'[1]3.11 LoadForecast'!$I$3)","v":7543841.7215384105},{"$f":"$C$35","v":8.1997233960661553E-2},{"$f":"E44*F44","v":618574.1546031849},{"$f":"CHOOSE(MATCH(B44,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J45*'[1]3.11 LoadForecast'!C89,'[1]3.11 LoadForecast'!$J75)","v":7688107.808373197},{"$f":"$C$35","v":8.1997233960661553E-2},{"$f":"H44*I44","v":630403.57467796595}]
[{"$f":"A18","v":"Unmetered Scattered Load"},"kWh",4010,4705,{"$f":"CHOOSE(MATCH(B45,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I46*'[1]3.11 LoadForecast'!B90,'[1]3.11 LoadForecast'!$I$3)","v":5522.27045},{"$f":"$C$35","v":8.1997233960661553E-2},{"$f":"E45*F45","v":452.81090208269774},{"$f":"CHOOSE(MATCH(B45,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J46*'[1]3.11 LoadForecast'!C90,'[1]3.11 LoadForecast'!$J76)","v":5627.8766355049647},{"$f":"$C$35","v":8.1997233960661553E-2},{"$f":"H45*I45","v":461.47031718324138}]
[{"$f":"A19","v":"Sentinel Lighting"},"kWh",4025,4705,{"$f":"CHOOSE(MATCH(B46,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I47*'[1]3.11 LoadForecast'!B91,'[1]3.11 LoadForecast'!$I$3)","v":26134.496650000001},{"$f":"$C$35","v":8.1997233960661553E-2},{"$f":"E46*F46","v":2142.9564362541755},{"$f":"CHOOSE(MATCH(B46,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J47*'[1]3.11 LoadForecast'!C91,'[1]3.11 LoadForecast'!$J77)","v":26634.284649571586},{"$f":"$C$35","v":8.1997233960661553E-2},{"$f":"H46*I46","v":2183.9376697857779}]
[{"$f":"A20","v":"Street Lighting "},"kWh",4025,4705,{"$f":"CHOOSE(MATCH(B47,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I48*'[1]3.11 LoadForecast'!B92,'[1]3.11 LoadForecast'!$I$3)","v":299727.37960000004},{"$f":"$C$35","v":8.1997233960661553E-2},{"$f":"E47*F47","v":24576.81606947722},{"$f":"CHOOSE(MATCH(B47,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J48*'[1]3.11 LoadForecast'!C92,'[1]3.11 LoadForecast'!$J78)","v":305459.27294668584},{"$f":"$C$35","v":8.1997233960661553E-2},{"$f":"H47*I47","v":25046.815469262976}]
[{"$f":"A21","v":"other"},"kWh",4025,4705,{"$f":"CHOOSE(MATCH(B48,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I49*'[1]3.11 LoadForecast'!B93,'[1]3.11 LoadForecast'!$I$3)","v":0},{"$f":"$C$35","v":8.1997233960661553E-2},{"$f":"E48*F48","v":0},{"$f":"CHOOSE(MATCH(B48,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J49*'[1]3.11 LoadForecast'!C93,'[1]3.11 LoadForecast'!$J79)","v":0},{"$f":"$C$35","v":8.1997233960661553E-2},{"$f":"H48*I48","v":0}]
[{"$f":"A22","v":0},"kWh",4025,4705,{"$f":"CHOOSE(MATCH(B49,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I50*'[1]3.11 LoadForecast'!B94,'[1]3.11 LoadForecast'!$I$3)","v":0},{"$f":"$C$35","v":8.1997233960661553E-2},{"$f":"E49*F49","v":0},{"$f":"CHOOSE(MATCH(B49,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J50*'[1]3.11 LoadForecast'!C94,'[1]3.11 LoadForecast'!$J80)","v":0},{"$f":"$C$35","v":8.1997233960661553E-2},{"$f":"H49*I49","v":0}]
[{"$f":"A23","v":0},"kWh",4025,4705,{"$f":"CHOOSE(MATCH(B50,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I51*'[1]3.11 LoadForecast'!B95,'[1]3.11 LoadForecast'!$I$3)","v":0},{"$f":"$C$35","v":8.1997233960661553E-2},{"$f":"E50*F50","v":0},{"$f":"CHOOSE(MATCH(B50,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J51*'[1]3.11 LoadForecast'!C95,'[1]3.11 LoadForecast'!$J81)","v":0},{"$f":"$C$35","v":8.1997233960661553E-2},{"$f":"H50*I50","v":0}]
["TOTAL"," ",null,null,{"$f":"SUM(E42:E50)","v":27886588.775890637},null,{"$f":"SUM(G42:G46)","v":2262046.3281519865},{"$f":"SUM(H42:H50)","v":28154244.510437518},null,{"$f":"SUM(J42:J50)","v":2308570.1741080158}]
[]
["Transmission - Network"]
["(volumes for the bridge and test year are automatically loss adjusted)"]
[null,null,null,null,{"$f":"'[1]0.1 LDC Info'!$E$23","v":2018},null,null,{"$f":"'[1]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":"'[1]0.2 Customer Classes'!$D$13","v":"kWh"},4066,4714,{"$f":"CHOOSE(MATCH(B58,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I43*'[1]3.11 LoadForecast'!B87,'[1]3.11 LoadForecast'!$I73)","v":14859993.185582258},{"$f":"'[2]9. RTSR Rates to Forecast'!D17","v":6.7999999999999996E-3},{"$f":"E58*F58","v":101047.95366195934},{"$f":"CHOOSE(MATCH(B58,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J43*'[1]3.11 LoadForecast'!C87,'[1]3.11 LoadForecast'!$J73)","v":14878532.350619528},{"$f":"'[2]9. RTSR Rates to Forecast'!J37","v":6.6952430887484704E-3},{"$f":"H58*I58","v":99615.390891205927}]
[{"$f":"A16","v":"General Service < 50 kW"},{"$f":"'[1]0.2 Customer Classes'!$D$14","v":"kWh"},4066,4714,{"$f":"CHOOSE(MATCH(B59,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I44*'[1]3.11 LoadForecast'!B88,'[1]3.11 LoadForecast'!$I74)","v":5151369.7220699713},{"$f":"'[2]9. RTSR Rates to Forecast'!D18","v":6.0000000000000001E-3},{"$f":"E59*F59","v":30908.218332419827},{"$f":"CHOOSE(MATCH(B59,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J44*'[1]3.11 LoadForecast'!C88,'[1]3.11 LoadForecast'!$J74)","v":5249882.9172130264},{"$f":"'[2]9. RTSR Rates to Forecast'!J38","v":5.9075673062744284E-3},{"$f":"H59*I59","v":31014.036683496295}]
[{"$f":"A17","v":"General Service > 50 to 4999 kW"},{"$f":"'[1]0.2 Customer Classes'!$D$15","v":"kW"},4066,4714,{"$f":"CHOOSE(MATCH(B60,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I45*'[1]3.11 LoadForecast'!B89,'[1]3.11 LoadForecast'!$I75)","v":19002.189647847106},{"$f":"'[2]9. RTSR Rates to Forecast'!D19","v":2.5062000000000002},{"$f":"E60*F60","v":47623.287695434425},{"$f":"CHOOSE(MATCH(B60,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J45*'[1]3.11 LoadForecast'!C89,'[1]3.11 LoadForecast'!$J75)","v":18883.313345201033},{"$f":"'[2]9. RTSR Rates to Forecast'!J39","v":2.4675905894666483},{"$f":"H60*I60","v":46596.286308568044}]
[{"$f":"A18","v":"Unmetered Scattered Load"},{"$f":"'[1]0.2 Customer Classes'!$D$16","v":"kWh"},4066,4714,{"$f":"CHOOSE(MATCH(B61,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I46*'[1]3.11 LoadForecast'!B90,'[1]3.11 LoadForecast'!$I76)","v":5522.27045},{"$f":"'[2]9. RTSR Rates to Forecast'!D20","v":6.0000000000000001E-3},{"$f":"E61*F61","v":33.133622700000004},{"$f":"CHOOSE(MATCH(B61,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J46*'[1]3.11 LoadForecast'!C90,'[1]3.11 LoadForecast'!$J76)","v":5627.8766355049647},{"$f":"'[2]9. RTSR Rates to Forecast'!J40","v":5.9079233424661082E-3},{"$f":"H61*I61","v":33.249063743419406}]
[{"$f":"A19","v":"Sentinel Lighting"},{"$f":"'[1]0.2 Customer Classes'!$D$17","v":"kW"},4066,4714,{"$f":"CHOOSE(MATCH(B62,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I47*'[1]3.11 LoadForecast'!B91,'[1]3.11 LoadForecast'!$I77)","v":65},{"$f":"'[2]9. RTSR Rates to Forecast'!D21","v":1.8997999999999999},{"$f":"E62*F62","v":123.48699999999999},{"$f":"CHOOSE(MATCH(B62,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J47*'[1]3.11 LoadForecast'!C91,'[1]3.11 LoadForecast'!$J77)","v":65},{"$f":"'[2]9. RTSR Rates to Forecast'!J41","v":1.8705263180554361},{"$f":"H62*I62","v":121.58421067360335}]
[{"$f":"A20","v":"Street Lighting "},{"$f":"'[1]0.2 Customer Classes'!$D$18","v":"kW"},4066,4714,{"$f":"CHOOSE(MATCH(B63,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I48*'[1]3.11 LoadForecast'!B92,'[1]3.11 LoadForecast'!$I78)","v":774},{"$f":"'[2]9. RTSR Rates to Forecast'!D22","v":1.8902000000000001},{"$f":"E63*F63","v":1463.0148000000002},{"$f":"CHOOSE(MATCH(B63,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J48*'[1]3.11 LoadForecast'!C92,'[1]3.11 LoadForecast'!$J78)","v":773.69999999999982},{"$f":"'[2]9. RTSR Rates to Forecast'!J42","v":1.8610807314211864},{"$f":"H63*I63","v":1439.9181619005715}]
[{"$f":"A21","v":"other"},{"$f":"'[1]0.2 Customer Classes'!$D$19","v":0},4066,4714,{"$f":"CHOOSE(MATCH(B64,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I49*'[1]3.11 LoadForecast'!B93,'[1]3.11 LoadForecast'!$I79)","v":1},0,{"$f":"E64*F64","v":0},{"$f":"CHOOSE(MATCH(B64,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J49*'[1]3.11 LoadForecast'!C93,'[1]3.11 LoadForecast'!$J79)","v":1},0,{"$f":"H64*I64","v":0}]
[{"$f":"A22","v":0},{"$f":"'[1]0.2 Customer Classes'!$D$20","v":0},4066,4714,{"$f":"CHOOSE(MATCH(B65,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I50*'[1]3.11 LoadForecast'!B94,'[1]3.11 LoadForecast'!$I80)","v":1},0,{"$f":"E65*F65","v":0},{"$f":"CHOOSE(MATCH(B65,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J50*'[1]3.11 LoadForecast'!C94,'[1]3.11 LoadForecast'!$J80)","v":1},0,{"$f":"H65*I65","v":0}]
[{"$f":"A23","v":0},{"$f":"'[1]0.2 Customer Classes'!$D$21","v":0},4066,4714,{"$f":"CHOOSE(MATCH(B66,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I51*'[1]3.11 LoadForecast'!B95,'[1]3.11 LoadForecast'!$I81)","v":1},0,{"$f":"E66*F66","v":0},{"$f":"CHOOSE(MATCH(B66,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J51*'[1]3.11 LoadForecast'!C95,'[1]3.11 LoadForecast'!$J81)","v":1},0,{"$f":"H66*I66","v":0}]
["TOTAL"," ",null,null,{"$f":"SUM(E58:E66)","v":20036729.367750075},null,{"$f":"SUM(G58:G66)","v":181199.09511251361},{"$f":"SUM(H58:H66)","v":20153768.157813262},null,{"$f":"SUM(J58:J66)","v":178820.46531958788}]
[]
["Transmission - Connection"]
["(volumes for the bridge and test year are automatically loss adjusted)"]
[null,null,null,null,{"$f":"'[1]0.1 LDC Info'!$E$23","v":2018},null,null,{"$f":"'[1]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":"'[1]0.2 Customer Classes'!$D$13","v":"kWh"},4068,4716,{"$f":"CHOOSE(MATCH(B74,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I43*'[1]3.11 LoadForecast'!B87,'[1]3.11 LoadForecast'!$I73)","v":14859993.185582258},{"$f":"'[2]9. RTSR Rates to Forecast'!D27","v":1.6000000000000001E-3},{"$f":"E74*F74","v":23775.989096931615},{"$f":"CHOOSE(MATCH(B74,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J43*'[1]3.11 LoadForecast'!C87,'[1]3.11 LoadForecast'!$J73)","v":14878532.350619528},{"$f":"'[2]9. RTSR Rates to Forecast'!J47","v":1.8441881424219467E-3},{"$f":"H74*I74","v":27438.812937653867}]
[{"$f":"A16","v":"General Service < 50 kW"},{"$f":"'[1]0.2 Customer Classes'!$D$14","v":"kWh"},4068,4716,{"$f":"CHOOSE(MATCH(B75,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I44*'[1]3.11 LoadForecast'!B88,'[1]3.11 LoadForecast'!$I74)","v":5151369.7220699713},{"$f":"'[2]9. RTSR Rates to Forecast'!D28","v":1.6000000000000001E-3},{"$f":"E75*F75","v":8242.1915553119543},{"$f":"CHOOSE(MATCH(B75,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J44*'[1]3.11 LoadForecast'!C88,'[1]3.11 LoadForecast'!$J74)","v":5249882.9172130264},{"$f":"'[2]9. RTSR Rates to Forecast'!J48","v":1.8441886848932279E-3},{"$f":"H75*I75","v":9681.7746729385144}]
[{"$f":"A17","v":"General Service > 50 to 4999 kW"},{"$f":"'[1]0.2 Customer Classes'!$D$15","v":"kW"},4068,4716,{"$f":"CHOOSE(MATCH(B76,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I45*'[1]3.11 LoadForecast'!B89,'[1]3.11 LoadForecast'!$I75)","v":19002.189647847106},{"$f":"'[2]9. RTSR Rates to Forecast'!D29","v":0.57630000000000003},{"$f":"E76*F76","v":10950.961894054288},{"$f":"CHOOSE(MATCH(B76,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J45*'[1]3.11 LoadForecast'!C89,'[1]3.11 LoadForecast'!$J75)","v":18883.313345201033},{"$f":"'[2]9. RTSR Rates to Forecast'!J49","v":0.66425379605818846},{"$f":"H76*I76","v":12543.312571706036}]
[{"$f":"A18","v":"Unmetered Scattered Load"},{"$f":"'[1]0.2 Customer Classes'!$D$16","v":"kWh"},4068,4716,{"$f":"CHOOSE(MATCH(B77,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I46*'[1]3.11 LoadForecast'!B90,'[1]3.11 LoadForecast'!$I76)","v":5522.27045},{"$f":"'[2]9. RTSR Rates to Forecast'!D30","v":1.6000000000000001E-3},{"$f":"E77*F77","v":8.8356327199999996},{"$f":"CHOOSE(MATCH(B77,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J46*'[1]3.11 LoadForecast'!C90,'[1]3.11 LoadForecast'!$J76)","v":5627.8766355049647},{"$f":"'[2]9. RTSR Rates to Forecast'!J50","v":1.8441680984475173E-3},{"$f":"H77*I77","v":10.378750553196403}]
[{"$f":"A19","v":"Sentinel Lighting"},{"$f":"'[1]0.2 Customer Classes'!$D$17","v":"kW"},4068,4716,{"$f":"CHOOSE(MATCH(B78,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I47*'[1]3.11 LoadForecast'!B91,'[1]3.11 LoadForecast'!$I77)","v":65},{"$f":"'[2]9. RTSR Rates to Forecast'!D31","v":0.45490000000000003},{"$f":"E78*F78","v":29.5685},{"$f":"CHOOSE(MATCH(B78,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J47*'[1]3.11 LoadForecast'!C91,'[1]3.11 LoadForecast'!$J77)","v":65},{"$f":"'[2]9. RTSR Rates to Forecast'!J51","v":0.52438604429548841},{"$f":"H78*I78","v":34.085092879206748}]
[{"$f":"A20","v":"Street Lighting "},{"$f":"'[1]0.2 Customer Classes'!$D$18","v":"kW"},4068,4716,{"$f":"CHOOSE(MATCH(B79,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I48*'[1]3.11 LoadForecast'!B92,'[1]3.11 LoadForecast'!$I78)","v":774},{"$f":"'[2]9. RTSR Rates to Forecast'!D32","v":0.4456},{"$f":"E79*F79","v":344.89440000000002},{"$f":"CHOOSE(MATCH(B79,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J48*'[1]3.11 LoadForecast'!B92,'[1]3.11 LoadForecast'!$J78)","v":773.69999999999982},{"$f":"'[2]9. RTSR Rates to Forecast'!J52","v":0.51360684858475258},{"$f":"H79*I79","v":397.37761875002298}]
[{"$f":"A21","v":"other"},{"$f":"'[1]0.2 Customer Classes'!$D$19","v":0},4068,4716,{"$f":"CHOOSE(MATCH(B80,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I49*'[1]3.11 LoadForecast'!B93,'[1]3.11 LoadForecast'!$I79)","v":1},0,{"$f":"E80*F80","v":0},{"$f":"CHOOSE(MATCH(B80,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J49*'[1]3.11 LoadForecast'!B93,'[1]3.11 LoadForecast'!$J79)","v":1},0,{"$f":"H80*I80","v":0}]
[{"$f":"A22","v":0},{"$f":"'[1]0.2 Customer Classes'!$D$20","v":0},4068,4716,{"$f":"CHOOSE(MATCH(B81,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I50*'[1]3.11 LoadForecast'!B94,'[1]3.11 LoadForecast'!$I80)","v":1},0,{"$f":"E81*F81","v":0},{"$f":"CHOOSE(MATCH(B81,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J50*'[1]3.11 LoadForecast'!B94,'[1]3.11 LoadForecast'!$J80)","v":1},0,{"$f":"H81*I81","v":0}]
[{"$f":"A23","v":0},{"$f":"'[1]0.2 Customer Classes'!$D$21","v":0},4068,4716,{"$f":"CHOOSE(MATCH(B82,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I51*'[1]3.11 LoadForecast'!B95,'[1]3.11 LoadForecast'!$I81)","v":1},0,{"$f":"E82*F82","v":0},{"$f":"CHOOSE(MATCH(B82,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J51*'[1]3.11 LoadForecast'!B95,'[1]3.11 LoadForecast'!$J81)","v":1},0,{"$f":"H82*I82","v":0}]
["TOTAL"," "," "," ",{"$f":"SUM(E74:E82)","v":20036729.367750075},null,{"$f":"SUM(G74:G82)","v":43352.441079017859},{"$f":"SUM(H74:H82)","v":20153768.157813262},null,{"$f":"SUM(J74:J82)","v":50105.74164448084}]
[]
["Wholesale Market Service"]
["(volumes for the bridge and test year are automatically loss adjusted)"]
[null,null,null,null,{"$f":"'[1]0.1 LDC Info'!$E$23","v":2018},null,null,{"$f":"'[1]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":"'[1]0.2 Customer Classes'!$D$13","v":"kWh"},4062,4708,{"$f":"CHOOSE(MATCH(B90,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I43*'[1]3.11 LoadForecast'!B87,'[1]3.11 LoadForecast'!$I73)","v":14859993.185582258},3.5999999999999999E-3,{"$f":"E90*F90","v":53495.975468096127},{"$f":"CHOOSE(MATCH(B90,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J43*'[1]3.11 LoadForecast'!C87,'[1]3.11 LoadForecast'!$J73)","v":14878532.350619528},3.5999999999999999E-3,{"$f":"H90*I90","v":53562.716462230303}]
[{"$f":"A16","v":"General Service < 50 kW"},{"$f":"'[1]0.2 Customer Classes'!$D$14","v":"kWh"},4062,4708,{"$f":"CHOOSE(MATCH(B91,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I44*'[1]3.11 LoadForecast'!B88,'[1]3.11 LoadForecast'!$I74)","v":5151369.7220699713},3.5999999999999999E-3,{"$f":"E91*F91","v":18544.930999451895},{"$f":"CHOOSE(MATCH(B91,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J44*'[1]3.11 LoadForecast'!C88,'[1]3.11 LoadForecast'!$J74)","v":5249882.9172130264},3.5999999999999999E-3,{"$f":"H91*I91","v":18899.578501966895}]
[{"$f":"A17","v":"General Service > 50 to 4999 kW"},{"$f":"'[1]0.2 Customer Classes'!$D$15","v":"kW"},4062,4708,{"$f":"CHOOSE(MATCH(B92,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I45*'[1]3.11 LoadForecast'!B89,'[1]3.11 LoadForecast'!$I75)","v":19002.189647847106},3.5999999999999999E-3,{"$f":"E92*F92","v":68.407882732249575},{"$f":"CHOOSE(MATCH(B92,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J45*'[1]3.11 LoadForecast'!C89,'[1]3.11 LoadForecast'!$J75)","v":18883.313345201033},3.5999999999999999E-3,{"$f":"H92*I92","v":67.979928042723714}]
[{"$f":"A18","v":"Unmetered Scattered Load"},{"$f":"'[1]0.2 Customer Classes'!$D$16","v":"kWh"},4062,4708,{"$f":"CHOOSE(MATCH(B93,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I46*'[1]3.11 LoadForecast'!B90,'[1]3.11 LoadForecast'!$I76)","v":5522.27045},3.5999999999999999E-3,{"$f":"E93*F93","v":19.880173620000001},{"$f":"CHOOSE(MATCH(B93,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J46*'[1]3.11 LoadForecast'!C90,'[1]3.11 LoadForecast'!$J76)","v":5627.8766355049647},3.5999999999999999E-3,{"$f":"H93*I93","v":20.260355887817873}]
[{"$f":"A19","v":"Sentinel Lighting"},{"$f":"'[1]0.2 Customer Classes'!$D$17","v":"kW"},4062,4708,{"$f":"CHOOSE(MATCH(B94,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I47*'[1]3.11 LoadForecast'!B91,'[1]3.11 LoadForecast'!$I77)","v":65},3.5999999999999999E-3,{"$f":"E94*F94","v":0.23399999999999999},{"$f":"CHOOSE(MATCH(B94,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J47*'[1]3.11 LoadForecast'!C91,'[1]3.11 LoadForecast'!$J77)","v":65},3.5999999999999999E-3,{"$f":"H94*I94","v":0.23399999999999999}]
[{"$f":"A20","v":"Street Lighting "},{"$f":"'[1]0.2 Customer Classes'!$D$18","v":"kW"},4062,4708,{"$f":"CHOOSE(MATCH(B95,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I48*'[1]3.11 LoadForecast'!B92,'[1]3.11 LoadForecast'!$I78)","v":774},3.5999999999999999E-3,{"$f":"E95*F95","v":2.7864},{"$f":"CHOOSE(MATCH(B95,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J48*'[1]3.11 LoadForecast'!C92,'[1]3.11 LoadForecast'!$J78)","v":773.69999999999982},3.5999999999999999E-3,{"$f":"H95*I95","v":2.7853199999999991}]
[{"$f":"A21","v":"other"},{"$f":"'[1]0.2 Customer Classes'!$D$19","v":0},4062,4708,{"$f":"CHOOSE(MATCH(B96,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I49*'[1]3.11 LoadForecast'!B93,'[1]3.11 LoadForecast'!$I79)","v":1},3.5999999999999999E-3,{"$f":"E96*F96","v":3.5999999999999999E-3},{"$f":"CHOOSE(MATCH(B96,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J49*'[1]3.11 LoadForecast'!C93,'[1]3.11 LoadForecast'!$J79)","v":1},3.5999999999999999E-3,{"$f":"H96*I96","v":3.5999999999999999E-3}]
[{"$f":"A22","v":0},{"$f":"'[1]0.2 Customer Classes'!$D$20","v":0},4062,4708,{"$f":"CHOOSE(MATCH(B97,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I50*'[1]3.11 LoadForecast'!B94,'[1]3.11 LoadForecast'!$I80)","v":1},3.5999999999999999E-3,{"$f":"E97*F97","v":3.5999999999999999E-3},{"$f":"CHOOSE(MATCH(B97,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J50*'[1]3.11 LoadForecast'!C94,'[1]3.11 LoadForecast'!$J80)","v":1},3.5999999999999999E-3,{"$f":"H97*I97","v":3.5999999999999999E-3}]
[{"$f":"A23","v":0},{"$f":"'[1]0.2 Customer Classes'!$D$21","v":0},4062,4708,{"$f":"CHOOSE(MATCH(B98,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I51*'[1]3.11 LoadForecast'!B95,'[1]3.11 LoadForecast'!$I81)","v":1},3.5999999999999999E-3,{"$f":"E98*F98","v":3.5999999999999999E-3},{"$f":"CHOOSE(MATCH(B98,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J51*'[1]3.11 LoadForecast'!C95,'[1]3.11 LoadForecast'!$J81)","v":1},3.5999999999999999E-3,{"$f":"H98*I98","v":3.5999999999999999E-3}]
["TOTAL"," "," "," ",{"$f":"SUM(E90:E98)","v":20036729.367750075},null,{"$f":"SUM(G90:G98)","v":72132.22572390025},{"$f":"SUM(H90:H98)","v":20153768.157813262},null,{"$f":"SUM(J90:J98)","v":72553.565368127718}]
[]
["Rural Rate Protection"]
["(volumes for the bridge and test year are automatically loss adjusted)"]
[null,null,null,null,{"$f":"'[1]0.1 LDC Info'!$E$23","v":2018},null,null,{"$f":"'[1]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":"'[1]0.2 Customer Classes'!$D$13","v":"kWh"},4062,4730,{"$f":"CHOOSE(MATCH(B106,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I43*'[1]3.11 LoadForecast'!B87,'[1]3.11 LoadForecast'!$I73)","v":14859993.185582258},1.2999999999999999E-3,{"$f":"E106*F106","v":19317.991141256934},{"$f":"CHOOSE(MATCH(B106,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J43*'[1]3.11 LoadForecast'!C87,'[1]3.11 LoadForecast'!$J73)","v":14878532.350619528},2.9999999999999997E-4,{"$f":"H106*I106","v":4463.5597051858585}]
[{"$f":"A16","v":"General Service < 50 kW"},{"$f":"'[1]0.2 Customer Classes'!$D$14","v":"kWh"},4062,4730,{"$f":"CHOOSE(MATCH(B107,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I44*'[1]3.11 LoadForecast'!B88,'[1]3.11 LoadForecast'!$I74)","v":5151369.7220699713},1.2999999999999999E-3,{"$f":"E107*F107","v":6696.7806386909624},{"$f":"CHOOSE(MATCH(B107,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J44*'[1]3.11 LoadForecast'!C88,'[1]3.11 LoadForecast'!$J74)","v":5249882.9172130264},2.9999999999999997E-4,{"$f":"H107*I107","v":1574.9648751639079}]
[{"$f":"A17","v":"General Service > 50 to 4999 kW"},{"$f":"'[1]0.2 Customer Classes'!$D$15","v":"kW"},4062,4730,{"$f":"CHOOSE(MATCH(B108,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I45*'[1]3.11 LoadForecast'!B89,'[1]3.11 LoadForecast'!$I75)","v":19002.189647847106},1.2999999999999999E-3,{"$f":"E108*F108","v":24.702846542201236},{"$f":"CHOOSE(MATCH(B108,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J45*'[1]3.11 LoadForecast'!C89,'[1]3.11 LoadForecast'!$J75)","v":18883.313345201033},2.9999999999999997E-4,{"$f":"H108*I108","v":5.6649940035603095}]
[{"$f":"A18","v":"Unmetered Scattered Load"},{"$f":"'[1]0.2 Customer Classes'!$D$16","v":"kWh"},4062,4730,{"$f":"CHOOSE(MATCH(B109,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I46*'[1]3.11 LoadForecast'!B90,'[1]3.11 LoadForecast'!$I76)","v":5522.27045},1.2999999999999999E-3,{"$f":"E109*F109","v":7.1789515850000001},{"$f":"CHOOSE(MATCH(B109,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J46*'[1]3.11 LoadForecast'!C90,'[1]3.11 LoadForecast'!$J76)","v":5627.8766355049647},2.9999999999999997E-4,{"$f":"H109*I109","v":1.6883629906514892}]
[{"$f":"A19","v":"Sentinel Lighting"},{"$f":"'[1]0.2 Customer Classes'!$D$17","v":"kW"},4062,4730,{"$f":"CHOOSE(MATCH(B110,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I47*'[1]3.11 LoadForecast'!B91,'[1]3.11 LoadForecast'!$I77)","v":65},1.2999999999999999E-3,{"$f":"E110*F110","v":8.4499999999999992E-2},{"$f":"CHOOSE(MATCH(B110,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J47*'[1]3.11 LoadForecast'!C91,'[1]3.11 LoadForecast'!$J77)","v":65},2.9999999999999997E-4,{"$f":"H110*I110","v":1.95E-2}]
[{"$f":"A20","v":"Street Lighting "},{"$f":"'[1]0.2 Customer Classes'!$D$18","v":"kW"},4062,4730,{"$f":"CHOOSE(MATCH(B111,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I48*'[1]3.11 LoadForecast'!B92,'[1]3.11 LoadForecast'!$I78)","v":774},1.2999999999999999E-3,{"$f":"E111*F111","v":1.0062},{"$f":"CHOOSE(MATCH(B111,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J48*'[1]3.11 LoadForecast'!C92,'[1]3.11 LoadForecast'!$J78)","v":773.69999999999982},2.9999999999999997E-4,{"$f":"H111*I111","v":0.23210999999999993}]
[{"$f":"A21","v":"other"},{"$f":"'[1]0.2 Customer Classes'!$D$19","v":0},4062,4730,{"$f":"CHOOSE(MATCH(B112,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I49*'[1]3.11 LoadForecast'!B93,'[1]3.11 LoadForecast'!$I79)","v":1},1.2999999999999999E-3,{"$f":"E112*F112","v":1.2999999999999999E-3},{"$f":"CHOOSE(MATCH(B112,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J49*'[1]3.11 LoadForecast'!B93,'[1]3.11 LoadForecast'!$J79)","v":1},2.9999999999999997E-4,{"$f":"H112*I112","v":2.9999999999999997E-4}]
[{"$f":"A22","v":0},{"$f":"'[1]0.2 Customer Classes'!$D$20","v":0},4062,4730,{"$f":"CHOOSE(MATCH(B113,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I50*'[1]3.11 LoadForecast'!B94,'[1]3.11 LoadForecast'!$I80)","v":1},1.2999999999999999E-3,{"$f":"E113*F113","v":1.2999999999999999E-3},{"$f":"CHOOSE(MATCH(B113,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J50*'[1]3.11 LoadForecast'!B94,'[1]3.11 LoadForecast'!$J80)","v":1},2.9999999999999997E-4,{"$f":"H113*I113","v":2.9999999999999997E-4}]
[{"$f":"A23","v":0},{"$f":"'[1]0.2 Customer Classes'!$D$21","v":0},4062,4730,{"$f":"CHOOSE(MATCH(B114,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I51*'[1]3.11 LoadForecast'!B95,'[1]3.11 LoadForecast'!$I81)","v":1},1.2999999999999999E-3,{"$f":"E114*F114","v":1.2999999999999999E-3},{"$f":"CHOOSE(MATCH(B114,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J51*'[1]3.11 LoadForecast'!B95,'[1]3.11 LoadForecast'!$J81)","v":1},2.9999999999999997E-4,{"$f":"H114*I114","v":2.9999999999999997E-4}]
["TOTAL"," "," "," ",{"$f":"SUM(E106:E114)","v":20036729.367750075},null,{"$f":"SUM(G106:G114)","v":26047.748178075097},{"$f":"SUM(H106:H114)","v":20153768.157813262},null,{"$f":"SUM(J106:J114)","v":6046.1304473439777}]
[]
["Smart Meter Entity Charge"]
["(per customer)"]
[null,null,null,null,{"$f":"'[1]0.1 LDC Info'!$E$23","v":2018},null,null,{"$f":"'[1]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":"'[1]3.11 LoadForecast'!I14","v":1043.4883679087588},0,{"$f":"E122*F122","v":0},{"$f":"'[1]3.11 LoadForecast'!J14","v":1033.0815692228512},0.56999999999999995,{"$f":"H122*I122*12","v":7066.2779334843008}]
[{"$f":"A16","v":"General Service < 50 kW"},"Cust",null,null,{"$f":"'[1]3.11 LoadForecast'!I15","v":150.21997525073792},0,{"$f":"E123*F123","v":0},{"$f":"'[1]3.11 LoadForecast'!J15","v":148.46079581797576},0.56999999999999995,{"$f":"H123*I123*12","v":1015.4718433949542}]
[{"$f":"A17","v":"General Service > 50 to 4999 kW"},"Cust",null,null,{"$f":"'[1]3.11 LoadForecast'!I16","v":15.115429989783037},0,{"$f":"E124*F124","v":0},{"$f":"'[1]3.11 LoadForecast'!J16","v":15.231748251735494},0.56999999999999995,{"$f":"H124*I124*12","v":104.18515804187076}]
["TOTAL"," "," "," ",{"$f":"SUM(E122:E124)","v":1208.8237731492798},null,{"$f":"SUM(G122:G124)","v":0},{"$f":"SUM(H122:H124)","v":1196.7741132925626},null,{"$f":"SUM(J122:J124)","v":8185.9349349211252}]
[]
["OESP"]
["(volumes for the bridge and test year are automatically loss adjusted)"]
[null,null,null,null,{"$f":"'[1]0.1 LDC Info'!$E$23","v":2018},null,null,{"$f":"'[1]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":"'[1]0.2 Customer Classes'!$D$13","v":"kWh"},4062,4730,{"$f":"CHOOSE(MATCH(B132,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I43*'[1]3.11 LoadForecast'!B87,'[1]3.11 LoadForecast'!$I73)","v":14859993.185582258},0,{"$f":"E132*F132","v":0},{"$f":"CHOOSE(MATCH(B106,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J43*'[1]3.11 LoadForecast'!C87,'[1]3.11 LoadForecast'!$J73)","v":14878532.350619528},0,{"$f":"H132*I132","v":0}]
[{"$f":"A43","v":"General Service < 50 kW"},{"$f":"'[1]0.2 Customer Classes'!$D$14","v":"kWh"},4062,4730,{"$f":"CHOOSE(MATCH(B133,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I44*'[1]3.11 LoadForecast'!B88,'[1]3.11 LoadForecast'!$I74)","v":5151369.7220699713},0,{"$f":"E133*F133","v":0},{"$f":"CHOOSE(MATCH(B107,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J44*'[1]3.11 LoadForecast'!C88,'[1]3.11 LoadForecast'!$J74)","v":5249882.9172130264},0,{"$f":"H133*I133","v":0}]
["TOTAL"," "," "," ",{"$f":"SUM(E132:E133)","v":20011362.907652229},null,{"$f":"SUM(G132:G133)","v":0},{"$f":"SUM(H132:H133)","v":20128415.267832555},null,{"$f":"SUM(J132:J133)","v":0}]
[]
[]
["Low Voltage Charges - Historical and Proposed LV Charges"]
[" "]
[null,null,null,null,{"$f":"'[1]0.1 LDC Info'!$E$27","v":2012},{"$f":"'[1]0.1 LDC Info'!$E$27+1","v":2013},{"$f":"'[1]0.1 LDC Info'!$E$27+2","v":2014},{"$f":"'[1]0.1 LDC Info'!$E$27+3","v":2015},{"$f":"'[1]0.1 LDC Info'!$E$27+4","v":2016},2017,"AVG"]
[]
[{"$f":"'[1]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":"'[1]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,{"$f":"AVERAGE(G142:J142)","v":68999.240000000005}]
["1551 LV Charges",null,null,null,{"$f":"'[1]1.2 TB Historical Balances'!J84","v":-31254.43},{"$f":"'[1]1.2 TB Historical Balances'!M84","v":7220.02},{"$f":"'[1]1.2 TB Historical Balances'!P84","v":39576.28},{"$f":"'[1]1.2 TB Historical Balances'!S84","v":110948.96},{"$f":"'[1]1.2 TB Historical Balances'!V84","v":153699.85},{"$f":"'[1]1.2 TB Historical Balances'!Y84","v":200139.14}]
["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":"'[1]0.2 Customer Classes'!$D$13","v":"kWh"},{"$f":"I74","v":1.8441881424219467E-3},{"$f":"H58","v":14878532.350619528},null,{"$f":"C149*D149","v":27438.812937653867},{"$f":"F149/$F$158","v":0.54761813790408709}]
[{"$f":"A16","v":"General Service < 50 kW"},{"$f":"'[1]0.2 Customer Classes'!$D$14","v":"kWh"},{"$f":"I75","v":1.8441886848932279E-3},{"$f":"H59","v":5249882.9172130264},null,{"$f":"C150*D150","v":9681.7746729385144},{"$f":"F150/$F$158","v":0.19322685095920467}]
[{"$f":"A17","v":"General Service > 50 to 4999 kW"},{"$f":"'[1]0.2 Customer Classes'!$D$15","v":"kW"},{"$f":"I76","v":0.66425379605818846},{"$f":"H60","v":18883.313345201033},null,{"$f":"C151*D151","v":12543.312571706036},{"$f":"F151/$F$158","v":0.2503368308707129}]
[{"$f":"A18","v":"Unmetered Scattered Load"},{"$f":"'[1]0.2 Customer Classes'!$D$16","v":"kWh"},{"$f":"I77","v":1.8441680984475173E-3},{"$f":"H61","v":5627.8766355049647},null,{"$f":"C152*D152","v":10.378750553196403},{"$f":"F152/$F$158","v":2.071369510272407E-4}]
[{"$f":"A19","v":"Sentinel Lighting"},{"$f":"'[1]0.2 Customer Classes'!$D$17","v":"kW"},{"$f":"I78","v":0.52438604429548841},{"$f":"H62","v":65},null,{"$f":"C153*D153","v":34.085092879206748},{"$f":"F153/$F$158","v":6.8026321456437773E-4}]
[{"$f":"A20","v":"Street Lighting "},{"$f":"'[1]0.2 Customer Classes'!$D$18","v":"kW"},{"$f":"I79","v":0.51360684858475258},{"$f":"H63","v":773.69999999999982},null,{"$f":"C154*D154","v":397.37761875002298},{"$f":"F154/$F$158","v":7.9307801004038069E-3}]
[{"$f":"A21","v":"other"},{"$f":"'[1]0.2 Customer Classes'!$D$19","v":0},{"$f":"I80","v":0},{"$f":"H64","v":1},null,{"$f":"C155*D155","v":0},{"$f":"F155/$F$158","v":0}]
[{"$f":"A22","v":0},{"$f":"'[1]0.2 Customer Classes'!$D$19","v":0},{"$f":"I81","v":0},{"$f":"H65","v":1},null,{"$f":"C156*D156","v":0},{"$f":"F156/$F$158","v":0}]
[{"$f":"A22","v":0},{"$f":"'[1]0.2 Customer Classes'!$D$19","v":0},{"$f":"I82","v":0},{"$f":"H66","v":1},null,{"$f":"C157*D157","v":0},{"$f":"F157/$F$158","v":0}]
["TOTAL",null,null,{"$f":"SUM(D149:E157)","v":20153768.157813262},null,{"$f":"SUM(F149:F157)","v":50105.74164448084},{"$f":"SUM(G149:G157)","v":1}]
[]
["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.54761813790408709},null,null,{"$f":"$E$174*B165","v":37785.235325597205},{"$f":"CHOOSE(MATCH(B106,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J43,'[1]3.11 LoadForecast'!$J73)","v":13831680.835737046},{"$f":"ROUND(E165/F165,4)","v":2.7000000000000001E-3},{"$f":"'[1]0.2 Customer Classes'!$D13","v":"kWh"}]
[{"$f":"A16","v":"General Service < 50 kW"},{"$f":"G150","v":0.19322685095920467},null,null,{"$f":"$E$174*B166","v":13332.505863778393},{"$f":"CHOOSE(MATCH(B107,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J44,'[1]3.11 LoadForecast'!$J74)","v":4880501.8683751496},{"$f":"ROUND(E166/F166,4)","v":2.7000000000000001E-3},{"$f":"'[1]0.2 Customer Classes'!$D14","v":"kWh"}]
[{"$f":"A17","v":"General Service > 50 to 4999 kW"},{"$f":"G151","v":0.2503368308707129},null,null,{"$f":"$E$174*B167","v":17273.051074087729},{"$f":"CHOOSE(MATCH(B108,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J45,'[1]3.11 LoadForecast'!$J75)","v":18883.313345201033},{"$f":"ROUND(E167/F167,4)","v":0.91469999999999996},{"$f":"'[1]0.2 Customer Classes'!$D15","v":"kW"}]
[{"$f":"A18","v":"Unmetered Scattered Load"},{"$f":"G152","v":2.071369510272407E-4},null,null,{"$f":"$E$174*B168","v":14.292292196796829},{"$f":"CHOOSE(MATCH(B109,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J46,'[1]3.11 LoadForecast'!$J76)","v":5231.8999999999996},{"$f":"ROUND(E168/F168,4)","v":2.7000000000000001E-3},{"$f":"'[1]0.2 Customer Classes'!$D16","v":"kWh"}]
[{"$f":"A19","v":"Sentinel Lighting"},{"$f":"G153","v":6.8026321456437773E-4},null,null,{"$f":"$E$174*B169","v":46.937644804899001},{"$f":"CHOOSE(MATCH(B110,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J47,'[1]3.11 LoadForecast'!$J77)","v":65},{"$f":"ROUND(E169/F169,4)","v":0.72209999999999996},{"$f":"'[1]0.2 Customer Classes'!$D17","v":"kW"}]
[{"$f":"A20","v":"Street Lighting "},{"$f":"G154","v":7.9307801004038069E-3},null,null,{"$f":"$E$174*B170","v":547.2177995349864},{"$f":"CHOOSE(MATCH(B111,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J48,'[1]3.11 LoadForecast'!$J78)","v":773.69999999999982},{"$f":"ROUND(E170/F170,4)","v":0.70730000000000004},{"$f":"'[1]0.2 Customer Classes'!$D18","v":"kW"}]
[{"$f":"A21","v":"other"},{"$f":"G155","v":0},null,null,{"$f":"$E$174*B171","v":0},{"$f":"CHOOSE(MATCH(B112,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J49,'[1]3.11 LoadForecast'!$J79)","v":1},{"$f":"ROUND(E171/F171,4)","v":0},{"$f":"'[1]0.2 Customer Classes'!$D19","v":0}]
[{"$f":"A22","v":0},{"$f":"G156","v":0},null,null,{"$f":"$E$174*B172","v":0},{"$f":"CHOOSE(MATCH(B113,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J50,'[1]3.11 LoadForecast'!$J80)","v":1},{"$f":"ROUND(E172/F172,4)","v":0},{"$f":"'[1]0.2 Customer Classes'!$D20","v":0}]
[{"$f":"A23","v":0},{"$f":"G157","v":0},null,null,{"$f":"$E$174*B173","v":0},{"$f":"CHOOSE(MATCH(B114,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$J51,'[1]3.11 LoadForecast'!$J81)","v":1},{"$f":"ROUND(E173/F173,4)","v":0},{"$f":"'[1]0.2 Customer Classes'!$D21","v":0}]
["TOTAL",{"$f":"SUM(B165:D173)","v":1},null,null,{"$f":"K142","v":68999.240000000005},{"$f":"SUM(F165:F173)","v":18737139.617457394}]
[]
["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":"'[1]0.2 Customer Classes'!$D$13","v":"kWh"},4075,4750,{"$f":"CHOOSE(MATCH(B149,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I43,'[1]3.11 LoadForecast'!$I73)","v":14078629.261565378},5.9999999999999995E-4,{"$f":"E181*F181","v":8447.1775569392266},{"$f":"F165","v":13831680.835737046},{"$f":"G165","v":2.7000000000000001E-3},{"$f":"H181*I181","v":37345.538256490028}]
[{"$f":"A16","v":"General Service < 50 kW"},{"$f":"'[1]0.2 Customer Classes'!$D$14","v":"kWh"},4075,4750,{"$f":"CHOOSE(MATCH(B150,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I44,'[1]3.11 LoadForecast'!$I74)","v":4880501.8683751496},5.9999999999999995E-4,{"$f":"E182*F182","v":2928.3011210250893},{"$f":"F166","v":4880501.8683751496},{"$f":"G166","v":2.7000000000000001E-3},{"$f":"H182*I182","v":13177.355044612905}]
[{"$f":"A17","v":"General Service > 50 to 4999 kW"},{"$f":"'[1]0.2 Customer Classes'!$D$15","v":"kW"},4075,4750,{"$f":"CHOOSE(MATCH(B151,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I45,'[1]3.11 LoadForecast'!$I75)","v":19002.189647847106},0.22559999999999999,{"$f":"E183*F183","v":4286.8939845543073},{"$f":"F167","v":18883.313345201033},{"$f":"G167","v":0.91469999999999996},{"$f":"H183*I183","v":17272.566716855385}]
[{"$f":"A18","v":"Unmetered Scattered Load"},{"$f":"'[1]0.2 Customer Classes'!$D$16","v":"kWh"},4075,4750,{"$f":"CHOOSE(MATCH(B152,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I46,'[1]3.11 LoadForecast'!$I76)","v":5231.8999999999996},5.9999999999999995E-4,{"$f":"E184*F184","v":3.1391399999999994},{"$f":"F168","v":5231.8999999999996},{"$f":"G168","v":2.7000000000000001E-3},{"$f":"H184*I184","v":14.12613}]
[{"$f":"A19","v":"Sentinel Lighting"},{"$f":"'[1]0.2 Customer Classes'!$D$17","v":"kW"},4075,4750,{"$f":"CHOOSE(MATCH(B153,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I47,'[1]3.11 LoadForecast'!$I77)","v":65},0.2261,{"$f":"E185*F185","v":14.6965},{"$f":"F169","v":65},{"$f":"G169","v":0.72209999999999996},{"$f":"H185*I185","v":46.936499999999995}]
[{"$f":"A20","v":"Street Lighting "},{"$f":"'[1]0.2 Customer Classes'!$D$18","v":"kW"},4075,4750,{"$f":"CHOOSE(MATCH(B154,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I48,'[1]3.11 LoadForecast'!$I78)","v":774},0.21729999999999999,{"$f":"E186*F186","v":168.1902},{"$f":"F170","v":773.69999999999982},{"$f":"G170","v":0.70730000000000004},{"$f":"H186*I186","v":547.23800999999992}]
[{"$f":"A21","v":"other"},{"$f":"'[1]0.2 Customer Classes'!$D$19","v":0},4075,4750,{"$f":"CHOOSE(MATCH(B155,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I49,'[1]3.11 LoadForecast'!$I79)","v":1},0,{"$f":"E187*F187","v":0},{"$f":"F171","v":1},{"$f":"G171","v":0},{"$f":"H187*I187","v":0}]
[{"$f":"A22","v":0},{"$f":"'[1]0.2 Customer Classes'!$D$20","v":0},4075,4750,{"$f":"CHOOSE(MATCH(B156,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I50,'[1]3.11 LoadForecast'!$I80)","v":1},0,{"$f":"E188*F188","v":0},{"$f":"F172","v":1},{"$f":"G172","v":0},{"$f":"H188*I188","v":0}]
[{"$f":"A23","v":0},{"$f":"'[1]0.2 Customer Classes'!$D$21","v":0},4075,4750,{"$f":"CHOOSE(MATCH(B157,{0,\"kWh\",\"kW\"},0),1,'[1]3.11 LoadForecast'!$I51,'[1]3.11 LoadForecast'!$I81)","v":1},0,{"$f":"E189*F189","v":0},{"$f":"F173","v":1},{"$f":"G173","v":0},{"$f":"H189*I189","v":0}]
["TOTAL"," ",0,0,{"$f":"SUM(E181:E189)","v":18984207.219588373},null,{"$f":"SUM(G181:G189)","v":15848.398502518623},{"$f":"SUM(H181:H189)","v":18737139.617457394},null,{"$f":"SUM(J181:J189)","v":68403.760657958308}]
[]
[]
["Projected Power Supply Expense",null,null,null,null,null,{"$f":"G51+G67+G83+G99+G115+G125+G190","v":2600626.2367480118},null,null,{"$f":"J51+J67+J83+J99+J115+J125+J134+J190","v":2692685.7724804352}]