{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet3","2023 Rates","2024 Rates"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Sheet3","index":0,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Applying 2023 Rates"]
[null,null,2021,"2022 BA",2022,2023]
[null,"Revenues from Rates",{"$f":"'2023 Rates'!N52","v":5059824.7328250008},{"$f":"'2023 Rates'!N26","v":5429578.2671000008},{"$f":"'2023 Rates'!N39","v":5104617.440924},{"$f":"'2023 Rates'!N13","v":5177396.7061790014}]
[null,null,"A","B","C","D"]
[]
[null,"Change in Revenue",null,{"$f":"D4-C4","v":369753.53427499998},{"$f":"E4-C4","v":44792.708098999225},{"$f":"F4-E4","v":72779.265255001374}]
[null,null,null,"B - A","C - A","D - C"]
[]
[null,"Growth",null,{"$f":"D4/C4-1","v":7.307635220569364E-2},{"$f":"E4/C4-1","v":8.8526204886925086E-3},{"$f":"F4/E4-1","v":1.4257535671826416E-2}]

{"sheet":"2023 Rates","index":1,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":false,"merged":[[41,2,41,4],[41,6,41,8],[28,2,28,4],[28,6,28,8],[2,2,2,4],[2,6,2,8],[15,2,15,4],[15,6,15,8]]}
[]
[]
[null,null,"2023 Actual Distribution Demand",null,null,null,"Current Approved Distribution Rates"]
["Rate Class",null,"Billed Customers or Connections","Billed kWh","Billed kW\n(if applicable)",null,"Monthly Service Charge","Distribution Volumetric Rate kWh","Distribution Volumetric Rate kW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","Revenues from Rates",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW","Total % Revenue"]
[null,null,"A","B","C",null,"D","E","F",null,"G","H","I","J",null,"K = G / J","L = H / J","M = I / J","N"]
["RESIDENTIAL",null,9825,77546268.560000002,0,null,25.57,0,0,null,{"$f":"G6*C6*12","v":3014703},{"$f":"H6*D6","v":0},0,{"$f":"SUM(K6,L6,M6)","v":3014703},null,{"$f":"IF(ISERROR(K6/N6),0,ROUND(K6/N6,3))","v":1},{"$f":"IF(ISERROR(L6/N6),0,ROUND(L6/N6,3))","v":0},{"$f":"IF(ISERROR(M6/N6),0,ROUND(M6/N6,3))","v":0},{"$f":"N6/N13","v":0.58228163130750266}]
["GENERAL SERVICE LESS THAN 50 kW",null,1156,34628972.100000001,0,null,26.44,9.7000000000000003E-3,0,null,366775.68000000005,335901.02937,0,702676.70937000006,null,0.52200000000000002,0.47799999999999998,0,{"$f":"N7/N13","v":0.13572008274571379}]
["GENERAL SERVICE 50 TO 2,999 KW",null,99,107355067.00999999,284403.5,null,96.21,0,3.8407,null,114297.47999999998,0,1092308.52245,1206606.00245,null,9.5000000000000001E-2,0,0.90500000000000003,{"$f":"N8/N13","v":0.23305264613197738}]
["GENERAL SERVICE 3,000 TO 4,999 KW - INTERMEDIATE USE",null,1,14360959.710000001,33280.35,null,5761.32,0,2.1326000000000001,null,69135.839999999997,0,70973.674409999992,140109.51441,null,0.49299999999999999,0,0.50700000000000001,{"$f":"N9/N13","v":2.7061769140229355E-2}]
["STREET LIGHTING",null,3082,1081156.25,2932,null,1.95,0,5.1059999999999999,null,72118.799999999988,0,14970.791999999999,87089.59199999999,null,0.82799999999999996,0,0.17199999999999999,{"$f":"N10/N13","v":1.6821116275687796E-2}]
["SENTINEL LIGHTING",null,51,43337.420000000006,120,null,6.19,0,14.104799999999999,null,3788.2799999999997,0,1692.5759999999998,5480.8559999999998,null,0.69099999999999995,0,0.309,{"$f":"N11/N13","v":1.0586123318421462E-3}]
["UNMETERED SCATTERED LOAD",null,91,621973.32999999996,0,null,10.27,1.5299999999999999E-2,0,null,11214.84,9516.1919489999982,0,20731.031948999997,null,0.54100000000000004,0.45900000000000002,0,{"$f":"N12/N13","v":4.0041420670466291E-3}]
["Total",null,{"$f":"SUM(C6:C12)","v":14305},{"$f":"SUM(D6:D12)","v":235637734.38},320735.84999999998,null,null,null,null,null,{"$f":"SUM(K6:K12)","v":3652033.9199999995},{"$f":"SUM(L6:L12)","v":345417.221319},{"$f":"SUM(M6:M12)","v":1179945.5648599998},{"$f":"SUM(N6:N12)","v":5177396.7061790014},null,null,null,null,{"$f":"SUM(S6:S12)","v":0.99999999999999978}]
[]
[]
[null,null,"2022 Board-Approved Distribution Demand",null,null,null,"Current Approved Distribution Rates"]
["Rate Class",null,"Billed Customers or Connections","Billed kWh","Billed kW\n(if applicable)",null,"Monthly Service Charge","Distribution Volumetric Rate kWh","Distribution Volumetric Rate kW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","Revenues from Rates",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW","Total % Revenue"]
[null,null,"A","B","C",null,"D","E","F",null,"G","H","I","J",null,"K = G / J","L = H / J","M = I / J","N"]
["RESIDENTIAL",null,9611,75290019,0,null,25.57,0,0,null,{"$f":"G19*C19*12","v":2949039.2399999998},{"$f":"H19*D19","v":0},{"$f":"I19*E19","v":0},{"$f":"SUM(K19,L19,M19)","v":2949039.2399999998},null,{"$f":"IF(ISERROR(K19/N19),0,ROUND(K19/N19,3))","v":1},{"$f":"IF(ISERROR(L19/N19),0,ROUND(L19/N19,3))","v":0},{"$f":"IF(ISERROR(M19/N19),0,ROUND(M19/N19,3))","v":0},{"$f":"N19/N26","v":0.54314333359358957}]
["GENERAL SERVICE LESS THAN 50 kW",null,1148,64580902,0,null,26.44,9.7000000000000003E-3,0,null,364237.44000000006,626434.74939999997,0,990672.18940000003,null,0.36799999999999999,0.63200000000000001,0,{"$f":"N20/N26","v":0.18245840480887465}]
["GENERAL SERVICE 50 TO 2,999 KW",null,105,107176718,282610,null,96.21,0,3.8407,null,121224.59999999999,0,1085420.227,1206644.827,null,0.1,0,0.9,{"$f":"N21/N26","v":0.22223546059029051}]
["GENERAL SERVICE 3,000 TO 4,999 KW - INTERMEDIATE USE",null,1,19493265,47088,null,5761.32,0,2.1326000000000001,null,69135.839999999997,0,100419.8688,169555.70879999999,null,0.40799999999999997,0,0.59199999999999997,{"$f":"N22/N26","v":3.1228154464114876E-2}]
["STREET LIGHTING",null,3159,1091871,2919,null,1.95,0,5.1059999999999999,null,73920.600000000006,0,14904.413999999999,88825.01400000001,null,0.83199999999999996,0,0.16800000000000001,{"$f":"N23/N26","v":1.6359468384170187E-2}]
["SENTINEL LIGHTING",null,49,44683,134,null,6.19,0,14.104799999999999,null,3639.7200000000003,0,1890.0431999999998,5529.7632000000003,null,0.65800000000000003,0,0.34200000000000003,{"$f":"N24/N26","v":1.0184516969774726E-3}]
["UNMETERED SCATTERED LOAD",null,80,617799,0,null,10.27,1.5299999999999999E-2,0,null,9859.1999999999989,9452.3246999999992,0,19311.524699999998,null,0.51100000000000001,0.48899999999999999,0,{"$f":"N25/N26","v":3.5567264619825625E-3}]
["Total",null,{"$f":"SUM(C19:C25)","v":14153},{"$f":"SUM(D19:D25)","v":268295257},332751,null,null,null,null,null,{"$f":"SUM(K19:K25)","v":3591056.64},{"$f":"SUM(L19:L25)","v":635887.07409999997},{"$f":"SUM(M19:M25)","v":1202634.5530000001},{"$f":"SUM(N19:N25)","v":5429578.2671000008},null,null,null,null,{"$f":"SUM(S19:S25)","v":0.99999999999999989}]
[]
[]
[null,null,"2022 Actual Distribution Demand",null,null,null,"Current Approved Distribution Rates"]
["Rate Class",null,"Billed Customers or Connections","Billed kWh","Billed kW\n(if applicable)",null,"Monthly Service Charge","Distribution Volumetric Rate kWh","Distribution Volumetric Rate kW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","Revenues from Rates",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW","Total % Revenue"]
[null,null,"A","B","C",null,"D","E","F",null,"G","H","I","J",null,"K = G / J","L = H / J","M = I / J","N"]
["RESIDENTIAL",null,9601,78678458.450000003,0,null,25.57,0,0,null,{"$f":"G32*C32*12","v":2945970.84},{"$f":"H32*D32","v":0},{"$f":"I32*E32","v":0},{"$f":"SUM(K32,L32,M32)","v":2945970.84},null,{"$f":"IF(ISERROR(K32/N32),0,ROUND(K32/N32,3))","v":1},{"$f":"IF(ISERROR(L32/N32),0,ROUND(L32/N32,3))","v":0},{"$f":"IF(ISERROR(M32/N32),0,ROUND(M32/N32,3))","v":0},{"$f":"N32/N39","v":0.57711882900018896}]
["GENERAL SERVICE LESS THAN 50 kW",null,1134,34760662.890000001,0,null,26.44,9.7000000000000003E-3,0,null,359795.52,337178.43003300001,0,696973.95003299997,null,0.51600000000000001,0.48399999999999999,0,{"$f":"N33/N39","v":0.13653794003157246}]
["GENERAL SERVICE 50 TO 2,999 KW",null,99,110503499.95,281729.33,null,96.21,0,3.8407,null,114297.47999999998,0,1082037.837731,1196335.317731,null,9.6000000000000002E-2,0,0.90400000000000003,{"$f":"N34/N39","v":0.23436336445899231}]
["GENERAL SERVICE 3,000 TO 4,999 KW - INTERMEDIATE USE",null,1,20808630.27,39157.199999999997,null,5761.32,0,2.1326000000000001,null,69135.839999999997,0,83506.644719999997,152642.48472000001,null,0.45300000000000001,0,0.54700000000000004,{"$f":"N35/N39","v":2.9902825527385612E-2}]
["STREET LIGHTING",null,3082,1081156.25,2932.44,null,1.95,0,5.1059999999999999,null,72118.799999999988,0,14973.038640000001,87091.838639999987,null,0.82799999999999996,0,0.17199999999999999,{"$f":"N36/N39","v":1.7061384060200066E-2}]
["SENTINEL LIGHTING",null,51,43746.95,121.51,null,6.19,0,14.104799999999999,null,3788.2799999999997,0,1713.8742479999999,5502.1542479999998,null,0.68899999999999995,0,0.311,{"$f":"N37/N39","v":1.077877884420667E-3}]
["UNMETERED SCATTERED LOAD",null,86,621059.83999999997,0,null,10.27,1.5299999999999999E-2,0,null,10598.64,9502.2155519999997,0,20100.855552000001,null,0.52700000000000002,0.47299999999999998,0,{"$f":"N38/N39","v":3.9377790372399565E-3}]
["Total",null,{"$f":"SUM(C32:C38)","v":14054},{"$f":"SUM(D32:D38)","v":246497214.60000002},323940.48000000004,null,null,null,null,null,{"$f":"SUM(K32:K38)","v":3575705.3999999994},{"$f":"SUM(L32:L38)","v":346680.64558499999},{"$f":"SUM(M32:M38)","v":1182231.395339},{"$f":"SUM(N32:N38)","v":5104617.440924},null,null,null,null,{"$f":"SUM(S32:S38)","v":1.0000000000000002}]
[]
[]
[null,null,"2021 Actual Distribution Demand",null,null,null,"Current Approved Distribution Rates"]
["Rate Class",null,"Billed Customers or Connections","Billed kWh","Billed kW",null,"Monthly Service Charge","Distribution Volumetric Rate kWh","Distribution Volumetric Rate kW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","Total Revenue By Rate Class",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW","Total % Revenue"]
[null,null,"A","B","C",null,"D","E","F",null,"G","H","I","J",null,"K = G / Jtotal","L = H / Jtotal","M = I / Jtotal","N"]
["RESIDENTIAL",null,9524,78651597.459999993,null,null,25.57,0,0,null,{"$f":"G45*C45*12","v":2922344.16},{"$f":"H45*D45","v":0},{"$f":"I45*E45","v":0},{"$f":"SUM(K45,L45,M45)","v":2922344.16},null,{"$f":"IF(ISERROR(K45/N45),0,ROUND(K45/N45,3))","v":1},{"$f":"IF(ISERROR(L45/N45),0,ROUND(L45/N45,3))","v":0},{"$f":"IF(ISERROR(M45/N45),0,ROUND(M45/N45,3))","v":0},{"$f":"N45/N52","v":0.5775583768824335}]
["GENERAL SERVICE LESS THAN 50 kW",null,1128,33171006.100000001,null,null,26.44,9.7000000000000003E-3,0,null,357891.83999999997,321758.75917000003,0,679650.59917000006,null,0.52700000000000002,0.47299999999999998,0,{"$f":"N46/N52","v":0.13432295288033377}]
["GENERAL SERVICE 50 TO 2,999 KW",null,103,107887244.95999998,279167.21000000002,null,96.21,0,3.8407,null,118915.56,0,1072197.5034470002,1191113.0634470002,null,0.1,0,0.9,{"$f":"N47/N52","v":0.23540599256725206}]
["GENERAL SERVICE 3,000 TO 4,999 KW - INTERMEDIATE USE",null,1,20432047.500000011,40068,null,5761.32,0,2.1326000000000001,null,69135.839999999997,0,85449.016799999998,154584.85680000001,null,0.44700000000000001,0,0.55300000000000005,{"$f":"N48/N52","v":3.0551425190115666E-2}]
["STREET LIGHTING",null,3082,1077951.96,2923.53,null,1.95,0,5.1059999999999999,null,72118.799999999988,0,14927.544180000001,87046.344179999985,null,0.82899999999999996,0,0.17100000000000001,{"$f":"N49/N52","v":1.7203430706857762E-2}]
["SENTINEL LIGHTING",null,51,43703.35,121.4,null,6.19,0,14.104799999999999,null,3788.2799999999997,0,1712.3227199999999,5500.6027199999999,null,0.68899999999999995,0,0.311,{"$f":"N50/N52","v":1.0871132915564259E-3}]
["UNMETERED SCATTERED LOAD",null,82,619570.36,null,null,10.27,1.5299999999999999E-2,0,null,10105.68,9479.4265079999986,0,19585.106507999997,null,0.51600000000000001,0.48399999999999999,0,{"$f":"N51/N52","v":3.8707084814507482E-3}]
["Total",null,{"$f":"SUM(C45:C51)","v":13971},{"$f":"SUM(D45:D51)","v":241883121.69},322280.14000000007,null,null,null,null,null,{"$f":"SUM(K45:K51)","v":3554300.1599999997},{"$f":"SUM(L45:L51)","v":331238.18567800004},{"$f":"SUM(M45:M51)","v":1174286.3871470003},{"$f":"SUM(N45:N51)","v":5059824.7328250008},null,null,null,null,{"$f":"SUM(S45:S51)","v":1}]

{"sheet":"2024 Rates","index":2,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":false,"merged":[[41,2,41,4],[41,6,41,8],[2,2,2,4],[2,6,2,8],[15,2,15,4],[15,6,15,8],[28,2,28,4],[28,6,28,8]]}
[]
[]
[null,null,"2023 Actual Distribution Demand",null,null,null,"Current Approved Distribution Rates"]
["Rate Class",null,"Billed Customers or Connections","Billed kWh","Billed kW\n(if applicable)",null,"Monthly Service Charge","Distribution Volumetric Rate kWh","Distribution Volumetric Rate kW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","Revenues from Rates",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW","Total % Revenue"]
[null,null,"A","B","C",null,"D","E","F",null,"G","H","I","J",null,"K = G / J","L = H / J","M = I / J","N"]
["RESIDENTIAL",null,9825,77546268.560000002,0,null,26.8,null,null,null,{"$f":"G6*C6*12","v":3159720},{"$f":"H6*D6","v":0},0,{"$f":"SUM(K6,L6,M6)","v":3159720},null,{"$f":"IF(ISERROR(K6/N6),0,ROUND(K6/N6,3))","v":1},{"$f":"IF(ISERROR(L6/N6),0,ROUND(L6/N6,3))","v":0},{"$f":"IF(ISERROR(M6/N6),0,ROUND(M6/N6,3))","v":0},{"$f":"N6/N13","v":0.58217971141034852}]
["GENERAL SERVICE LESS THAN 50 kW",null,1156,34628972.100000001,0,null,27.71,1.0200000000000001E-2,null,null,384393.12,353215.51542000007,0,737608.63542000006,null,0.52100000000000002,0.47899999999999998,0,{"$f":"N7/N13","v":0.13590469487884896}]
["GENERAL SERVICE 50 TO 2,999 KW",null,99,107355067.00999999,284403.5,null,100.83,null,4.0251000000000001,null,119786.04000000001,0,1144752.52785,1264538.56785,null,9.5000000000000001E-2,0,0.90500000000000003,{"$f":"N8/N13","v":0.2329917519584547}]
["GENERAL SERVICE 3,000 TO 4,999 KW - INTERMEDIATE USE",null,1,14360959.710000001,33280.35,null,6037.86,null,2.2349999999999999,null,72454.319999999992,0,74381.582249999992,146835.90224999998,null,0.49299999999999999,0,0.50700000000000001,{"$f":"N9/N13","v":2.7054575467631039E-2}]
["STREET LIGHTING",null,3082,1081156.25,2932,null,2.04,null,5.3510999999999997,null,75447.360000000001,0,15689.4252,91136.785199999998,null,0.82799999999999996,0,0.17199999999999999,{"$f":"N10/N13","v":1.6791990210082833E-2}]
["SENTINEL LIGHTING",null,51,43337.420000000006,120,null,6.49,null,14.7818,null,3971.88,0,1773.816,5745.6959999999999,null,0.69099999999999995,0,0.309,{"$f":"N11/N13","v":1.0586468545097647E-3}]
["UNMETERED SCATTERED LOAD",null,91,621973.32999999996,0,null,10.86,1.6E-2,null,null,11859.119999999999,9951.5732799999987,0,21810.69328,null,0.54400000000000004,0.45600000000000002,0,{"$f":"N12/N13","v":4.0186292201239444E-3}]
["Total",null,{"$f":"SUM(C6:C12)","v":14305},{"$f":"SUM(D6:D12)","v":235637734.38},320735.84999999998,null,null,null,null,null,{"$f":"SUM(K6:K12)","v":3827631.84},{"$f":"SUM(L6:L12)","v":363167.08870000008},{"$f":"SUM(M6:M12)","v":1236597.3513},{"$f":"SUM(N6:N12)","v":5427396.2800000012},null,null,null,null,{"$f":"SUM(S6:S12)","v":0.99999999999999967}]
[]
[]
[null,null,"2022 Board-Approved Distribution Demand",null,null,null,"Current Approved Distribution Rates"]
["Rate Class",null,"Billed Customers or Connections","Billed kWh","Billed kW\n(if applicable)",null,"Monthly Service Charge","Distribution Volumetric Rate kWh","Distribution Volumetric Rate kW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","Revenues from Rates",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW","Total % Revenue"]
[null,null,"A","B","C",null,"D","E","F",null,"G","H","I","J",null,"K = G / J","L = H / J","M = I / J","N"]
["RESIDENTIAL",null,9611,75290019,0,null,26.8,null,null,null,{"$f":"G19*C19*12","v":3090897.6},{"$f":"H19*D19","v":0},0,{"$f":"SUM(K19,L19,M19)","v":3090897.6},null,{"$f":"IF(ISERROR(K19/N19),0,ROUND(K19/N19,3))","v":1},{"$f":"IF(ISERROR(L19/N19),0,ROUND(L19/N19,3))","v":0},{"$f":"IF(ISERROR(M19/N19),0,ROUND(M19/N19,3))","v":0},{"$f":"N19/N26","v":0.54295900866175983}]
["GENERAL SERVICE LESS THAN 50 kW",null,1148,64580902,0,null,27.71,1.0200000000000001E-2,null,null,381732.96,658725.20040000009,0,1040458.1604000002,null,0.36699999999999999,0.63300000000000001,0,{"$f":"N20/N26","v":0.18277089843572378}]
["GENERAL SERVICE 50 TO 2,999 KW",null,105,107176718,282610,null,100.83,null,4.0251000000000001,null,127045.79999999999,0,1137533.5109999999,1264579.311,null,0.1,0,0.9,{"$f":"N21/N26","v":0.22214088524793937}]
["GENERAL SERVICE 3,000 TO 4,999 KW - INTERMEDIATE USE",null,1,19493265,47088,null,6037.86,null,2.2349999999999999,null,72454.319999999992,0,105241.68,177696,null,0.40799999999999997,0,0.59199999999999997,{"$f":"N22/N26","v":3.1214765575915578E-2}]
["STREET LIGHTING",null,3159,1091871,2919,null,2.04,null,5.3510999999999997,null,77332.319999999992,0,15619.8609,92952.180899999992,null,0.83199999999999996,0,0.16800000000000001,{"$f":"N23/N26","v":1.6328339054135135E-2}]
["SENTINEL LIGHTING",null,49,44683,134,null,6.49,null,14.7818,null,3816.12,0,1980.7612000000001,5796.8811999999998,null,0.65800000000000003,0,0.34200000000000003,{"$f":"N24/N26","v":1.0183025376453729E-3}]
["UNMETERED SCATTERED LOAD",null,80,617799,0,null,10.86,1.6E-2,null,null,10425.599999999999,9884.7839999999997,0,20310.383999999998,null,0.51300000000000001,0.48699999999999999,0,{"$f":"N25/N26","v":3.5678004868811139E-3}]
["Total",null,{"$f":"SUM(C19:C25)","v":14153},{"$f":"SUM(D19:D25)","v":268295257},332751,null,null,null,null,null,{"$f":"SUM(K19:K25)","v":3763704.7199999997},{"$f":"SUM(L19:L25)","v":668609.98440000007},{"$f":"SUM(M19:M25)","v":1260375.8130999999},{"$f":"SUM(N19:N25)","v":5692690.5174999991},null,null,null,null,{"$f":"SUM(S19:S25)","v":1.0000000000000002}]
[]
[]
[null,null,"2022 Actual Distribution Demand",null,null,null,"Current Approved Distribution Rates"]
["Rate Class",null,"Billed Customers or Connections","Billed kWh","Billed kW\n(if applicable)",null,"Monthly Service Charge","Distribution Volumetric Rate kWh","Distribution Volumetric Rate kW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","Revenues from Rates",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW","Total % Revenue"]
[null,null,"A","B","C",null,"D","E","F",null,"G","H","I","J",null,"K = G / J","L = H / J","M = I / J","N"]
["RESIDENTIAL",null,9601,78678458.450000003,0,null,26.8,null,null,null,{"$f":"G32*C32*12","v":3087681.6},{"$f":"H32*D32","v":0},0,{"$f":"SUM(K32,L32,M32)","v":3087681.6},null,{"$f":"IF(ISERROR(K32/N32),0,ROUND(K32/N32,3))","v":1},{"$f":"IF(ISERROR(L32/N32),0,ROUND(L32/N32,3))","v":0},{"$f":"IF(ISERROR(M32/N32),0,ROUND(M32/N32,3))","v":0},{"$f":"N32/N39","v":0.57701647981634985}]
["GENERAL SERVICE LESS THAN 50 kW",null,1134,34760662.890000001,0,null,27.71,1.0200000000000001E-2,null,null,377077.68,354558.76147800003,0,731636.44147800002,null,0.51500000000000001,0.48499999999999999,0,{"$f":"N33/N39","v":0.13672597717555995}]
["GENERAL SERVICE 50 TO 2,999 KW",null,99,110503499.95,281729.33,null,100.83,null,4.0251000000000001,null,119786.04000000001,0,1133988.726183,1253774.7661830001,null,9.6000000000000002E-2,0,0.90400000000000003,{"$f":"N34/N39","v":0.23430158798286774}]
["GENERAL SERVICE 3,000 TO 4,999 KW - INTERMEDIATE USE",null,1,20808630.27,39157.199999999997,null,6037.86,null,2.2349999999999999,null,72454.319999999992,0,87516.34199999999,159970.66199999998,null,0.45300000000000001,0,0.54700000000000004,{"$f":"N35/N39","v":2.9894827323235371E-2}]
["STREET LIGHTING",null,3082,1081156.25,2932.44,null,2.04,null,5.3510999999999997,null,75447.360000000001,0,15691.779683999999,91139.139683999994,null,0.82799999999999996,0,0.17199999999999999,{"$f":"N36/N39","v":1.7031803264284853E-2}]
["SENTINEL LIGHTING",null,51,43746.95,121.51,null,6.49,null,14.7818,null,3971.88,0,1796.136518,5768.0165180000004,null,0.68899999999999995,0,0.311,{"$f":"N37/N39","v":1.0779092594064492E-3}]
["UNMETERED SCATTERED LOAD",null,86,621059.83999999997,0,null,10.86,1.6E-2,null,null,11207.519999999999,9936.9574400000001,0,21144.477439999999,null,0.53,0.47,0,{"$f":"N38/N39","v":3.9514151782959177E-3}]
["Total",null,{"$f":"SUM(C32:C38)","v":14054},{"$f":"SUM(D32:D38)","v":246497214.60000002},323940.48000000004,null,null,null,null,null,{"$f":"SUM(K32:K38)","v":3747626.4},{"$f":"SUM(L32:L38)","v":364495.71891800006},{"$f":"SUM(M32:M38)","v":1238992.9843849998},{"$f":"SUM(N32:N38)","v":5351115.1033029994},null,null,null,null,{"$f":"SUM(S32:S38)","v":1}]
[]
[]
[null,null,"2021 Actual Distribution Demand",null,null,null,"Current Approved Distribution Rates"]
["Rate Class",null,"Billed Customers or Connections","Billed kWh","Billed kW",null,"Monthly Service Charge","Distribution Volumetric Rate kWh","Distribution Volumetric Rate kW",null,"Service Charge Revenue","Distribution Volumetric Rate Revenue \nkWh","Distribution Volumetric Rate Revenue \nkW","Total Revenue By Rate Class",null,"Service Charge % Revenue","Distribution Volumetric Rate % Revenue \nkWh","Distribution Volumetric Rate % Revenue \nkW","Total % Revenue"]
[null,null,"A","B","C",null,"D","E","F",null,"G","H","I","J",null,"K = G / Jtotal","L = H / Jtotal","M = I / Jtotal","N"]
["RESIDENTIAL",null,9524,78651597.459999993,null,null,26.8,null,null,null,{"$f":"G45*C45*12","v":3062918.4000000004},{"$f":"H45*D45","v":0},0,{"$f":"SUM(K45,L45,M45)","v":3062918.4000000004},null,{"$f":"IF(ISERROR(K45/N45),0,ROUND(K45/N45,3))","v":1},{"$f":"IF(ISERROR(L45/N45),0,ROUND(L45/N45,3))","v":0},{"$f":"IF(ISERROR(M45/N45),0,ROUND(M45/N45,3))","v":0},{"$f":"N45/N52","v":0.57746126653451457}]
["GENERAL SERVICE LESS THAN 50 kW",null,1128,33171006.100000001,null,null,27.71,1.0200000000000001E-2,null,null,375082.56,338344.26222000003,0,713426.82221999997,null,0.52600000000000002,0.47399999999999998,0,{"$f":"N46/N52","v":0.13450451580389966}]
["GENERAL SERVICE 50 TO 2,999 KW",null,103,107887244.95999998,279167.21000000002,null,100.83,null,4.0251000000000001,null,124625.88,0,1123675.9369710002,1248301.8169710003,null,0.1,0,0.9,{"$f":"N47/N52","v":0.23534611573243661}]
["GENERAL SERVICE 3,000 TO 4,999 KW - INTERMEDIATE USE",null,1,20432047.500000011,40068,null,6037.86,null,2.2349999999999999,null,72454.319999999992,0,89551.98,162006.29999999999,null,0.44700000000000001,0,0.55300000000000005,{"$f":"N48/N52","v":3.0543537557047067E-2}]
["STREET LIGHTING",null,3082,1077951.96,2923.53,null,2.04,null,5.3510999999999997,null,75447.360000000001,0,15644.101383000001,91091.461383000002,null,0.82799999999999996,0,0.17199999999999999,{"$f":"N49/N52","v":1.7173748625071761E-2}]
["SENTINEL LIGHTING",null,51,43703.35,121.4,null,6.49,null,14.7818,null,3971.88,0,1794.51052,5766.3905199999999,null,0.68899999999999995,0,0.311,{"$f":"N50/N52","v":1.0871550391325533E-3}]
["UNMETERED SCATTERED LOAD",null,82,619570.36,null,null,10.86,1.6E-2,null,null,10686.24,9913.1257600000008,0,20599.365760000001,null,0.51900000000000002,0.48099999999999998,0,{"$f":"N51/N52","v":3.8836607078978377E-3}]
["Total",null,{"$f":"SUM(C45:C51)","v":13971},{"$f":"SUM(D45:D51)","v":241883121.69},322280.14000000007,null,null,null,null,null,{"$f":"SUM(K45:K51)","v":3725186.64},{"$f":"SUM(L45:L51)","v":348257.38798000006},{"$f":"SUM(M45:M51)","v":1230666.5288740001},{"$f":"SUM(N45:N51)","v":5304110.5568540003},null,null,null,null,{"$f":"SUM(S45:S51)","v":1.0000000000000002}]