{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["App 2-IB Load Forecast Analysis"],"not_rendered":{"charts":4,"images":0,"macros":0,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"App 2-IB Load Forecast Analysis","index":0,"n_rows":85,"n_cols":32,"rows_kept":85,"cut":false,"hidden":false,"merged":[[2,0,2,15],[3,0,3,16],[11,0,11,18]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"File Number:","EB-2025-0252"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exhibit:"]
["Appendix 2-IB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tab:"]
["Customer, Connections, Load Forecast and Revenues Data and Analysis",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule:"]
["Customer Numbers","Year End",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[]
[]
[]
["This sheet is to be filled in accordance with the instructions documented in section 2.3.2 of Chapter 2 of the Filing Requirements for Distribution Rate Applications, in terms of one set of tables per customer class."]
[]
["Costumers/Connections",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Costumers/Connections Variance Analysis"]
["Rate Class","Historical 2017","Historical 2018","Historical 2019","Historical 2020","Historical 2021","Historical 2022","Historical 2023","Historical 2024","Bridge Year 2025","Bridge Year 2026","Test Year 2027","Test Year 2028","Test Year 2029","Test Year 2030","Test Year 2031",null,"Rate Class",{"$f":"C15","v":"Historical 2018"},{"$f":"D15","v":"Historical 2019"},{"$f":"E15","v":"Historical 2020"},{"$f":"F15","v":"Historical 2021"},{"$f":"G15","v":"Historical 2022"},"Historical 2023","Historical 2024","Bridge Year 2025","Bridge Year 2026",{"$f":"L15","v":"Test Year 2027"},"Test Year 2028","Test Year 2029","Test Year 2030","Test Year 2031"]
["Residential",940384,948720,955435,962014,969260,975694,981275,985462,989905,993943,998052,1002542,1006917,1011259,1015576,null,{"$f":"A16","v":"Residential"},{"$f":"IFERROR((C16-B16)/B16,)","v":8.8644638785857696E-3},{"$f":"IFERROR((D16-C16)/C16,)","v":7.0779576692807152E-3},{"$f":"IFERROR((E16-D16)/D16,)","v":6.8858687404166688E-3},{"$f":"IFERROR((F16-E16)/E16,)","v":7.5321149172465265E-3},6.6380537729814493E-3,5.7200310753166466E-3,4.2668976586583782E-3,4.5085452305619091E-3,4.0791793151868112E-3,4.1340398795504368E-3,4.4987635914761955E-3,4.3639069485368193E-3,4.3121727014242481E-3,4.2689360490240384E-3]
["General Service < 50 kW",83247,84093,84306,85094,85764,87002,87707,88209,89263,89880,90652,91361,92050,92716,93367,null,"General Service < 50 kW",{"$f":"IFERROR((C17-B17)/B17,)","v":1.016252837940106E-2},2.5329099925082946E-3,9.3469029487818194E-3,7.8736456154370454E-3,1.4434961055920899E-2,8.1032619939771493E-3,5.7236024490633589E-3,1.1948894103776258E-2,6.9121584531104717E-3,8.5892300845571874E-3,7.8211181220491557E-3,7.54151114808288E-3,7.2351982618142317E-3,7.0214418223391861E-3]
["General Service > 50 kW, Regular",12980,13205,13270,13099,13059,12376,12086,11982,11797,11585,11397,11229,11082,10953,10842,null,"General Service > 50 kW, Regular",1.7334360554699536E-2,{"$f":"IFERROR((D18-C18)/C18,)","v":4.9223778871639529E-3},-1.2886209495101733E-2,-3.0536682189480115E-3,-5.2301095030247338E-2,-2.3432449903038138E-2,-8.6049975177891775E-3,-1.5439826406276081E-2,-1.7970670509451555E-2,-1.6227880880448856E-2,-1.4740721242432218E-2,-1.3091103393000268E-2,-1.1640498105035191E-2,-1.0134209805532731E-2]
["General Service > 50 kW, Intermediate",619,626,633,655,647,563,508,487,469,445,421,401,384,370,358,null,"General Service > 50 kW, Intermediate",1.1308562197092083E-2,1.1182108626198083E-2,3.4755134281200632E-2,-1.2213740458015267E-2,-0.12982998454404945,-9.7690941385435173E-2,-4.1338582677165357E-2,-3.6960985626283367E-2,-5.1172707889125799E-2,-5.3932584269662923E-2,-4.7505938242280284E-2,-4.2394014962593519E-2,-3.6458333333333336E-2,-3.2432432432432434E-2]
["Large Use",26,25,26,27,24,25,27,30,31,31,32,34,35,36,36,null,"Large Use",-3.8461538461538464E-2,0.04,3.8461538461538464E-2,{"$f":"IFERROR((F20-E20)/E20,)","v":-0.1111111111111111},4.1666666666666664E-2,{"$f":"IFERROR((H20-G20)/G20,)","v":0.08},{"$f":"IFERROR((I20-H20)/H20,)","v":0.1111111111111111},{"$f":"IFERROR((J20-I20)/I20,)","v":3.3333333333333333E-2},{"$f":"IFERROR((K20-J20)/J20,)","v":0},{"$f":"IFERROR((L20-K20)/K20,)","v":3.2258064516129031E-2},{"$f":"IFERROR((M20-L20)/L20,)","v":6.25E-2},{"$f":"IFERROR((N20-M20)/M20,)","v":2.9411764705882353E-2},{"$f":"IFERROR((O20-N20)/N20,)","v":2.8571428571428571E-2},{"$f":"IFERROR((P20-O20)/O20,)","v":0}]
["Large Use with Dedicated Assets",7,7,7,5,5,5,5,6,6,6,6,6,6,6,6,null,"Large Use with Dedicated Assets",0,0,-0.2857142857142857,0,0,0,0.2,0,0,0,0,0,0,0]
["Street Lighting",227625,229961,230685,231795,234891,235451,236505,241236,241932,242666,273870,274744,275618,276492,277367,null,"Street Lighting",1.0262493135639759E-2,3.1483599392940543E-3,4.8117562910462318E-3,1.3356629780625122E-2,2.384084532825864E-3,{"$f":"IFERROR((H22-G22)/G22,)","v":4.4765152834347699E-3},2.0003805416375975E-2,2.8851415211659953E-3,3.0339103549757783E-3,0.12858826535237733,3.191295140029941E-3,3.181143173281309E-3,3.1710555914345219E-3,3.1646485250929504E-3]
["Sentinel Lighting",557,552,505,489,470,462,442,422,422,411,400,389,378,367,357,null,"Sentinel Lighting",-8.9766606822262122E-3,-8.5144927536231887E-2,-3.1683168316831684E-2,-3.8854805725971372E-2,-1.7021276595744681E-2,-4.3290043290043288E-2,-4.5248868778280542E-2,0,-2.6066350710900472E-2,-2.6763990267639901E-2,-2.75E-2,-2.8277634961439587E-2,-2.9100529100529099E-2,-2.7247956403269755E-2]
["Unmetered Scattered Load",11156,11315,11276,11160,11251,11255,11352,11265,11439,11489,11531,11571,11611,11650,11689,null,"Unmetered Scattered Load",1.4252420222301901E-2,-3.4467520989836498E-3,-1.0287335934728628E-2,8.1541218637992824E-3,3.5552395342636212E-4,8.6183918258551755E-3,-7.6638477801268499E-3,1.544607190412783E-2,4.3710114520500044E-3,3.655670641483158E-3,3.4689098950654758E-3,3.4569181574626222E-3,3.3588838170700197E-3,3.3476394849785407E-3]
["Embedded Distributor",1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,null,"Embedded Distributor",0,0,{"$f":"IFERROR((E25-D25)/D25,)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
["Consumption (Actual)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consumption (Actual) Variance Analysis"]
["Rate Class",{"$f":"B15","v":"Historical 2017"},"Historical 2018","Historical 2019",{"$f":"E15","v":"Historical 2020"},"Historical 2021","Historical 2022","Historical 2023","Historical 2024","Bridge Year 2025","Bridge Year 2026","Test Year 2027","Test Year 2028","Test Year 2029","Test Year 2030","Test Year 2031",null,"Rate Class",{"$f":"C15","v":"Historical 2018"},{"$f":"D15","v":"Historical 2019"},{"$f":"E15","v":"Historical 2020"},{"$f":"F15","v":"Historical 2021"},{"$f":"G15","v":"Historical 2022"},"Historical 2023","Historical 2024","Bridge Year 2025","Bridge Year 2026","Test Year 2027","Test Year 2028","Test Year 2029","Test Year 2030","Test Year 2031"]
[{"$f":"A16","v":"Residential"},7100277.540000001,7702402.9799999995,7371237.5200000005,8340436.6500000004,8161386.9700000007,8175488.8200000003,8002561.71,8358536.7299999995,8437547.4766825046,8556581.533095425,8833994.4778626598,9184005.5599140264,9550659.4271785431,10000906.389657669,10421039.641682692,null,{"$f":"A31","v":"Residential"},{"$f":"IF(ISERROR((C31-B31)/B31), \"\", (C31-B31)/B31)","v":8.4803085035461648E-2},{"$f":"IF(ISERROR((D31-C31)/C31), \"\", (D31-C31)/C31)","v":-4.2995083594029128E-2},{"$f":"IF(ISERROR((E31-D31)/D31), \"\", (E31-D31)/D31)","v":0.13148390990933634},{"$f":"IF(ISERROR((F31-E31)/E31), \"\", (F31-E31)/E31)","v":-2.14676626073288E-2},{"$f":"IF(ISERROR((G31-F31)/F31), \"\", (G31-F31)/F31)","v":1.7278742022447718E-3},{"$f":"IF(ISERROR((H31-G31)/G31), \"\", (H31-G31)/G31)","v":-2.1151898535652372E-2},{"$f":"IF(ISERROR((I31-H31)/H31), \"\", (I31-H31)/H31)","v":4.4482633549101314E-2},{"$f":"IF(ISERROR((J31-I31)/I31), \"\", (J31-I31)/I31)","v":9.4527007818155668E-3},{"$f":"IF(ISERROR((K31-J31)/J31), \"\", (K31-J31)/J31)","v":1.4107660637392046E-2},{"$f":"IF(ISERROR((L31-K31)/K31), \"\", (L31-K31)/K31)","v":3.2421001739333405E-2},{"$f":"IF(ISERROR((M31-L31)/L31), \"\", (M31-L31)/L31)","v":3.9620930591304823E-2},{"$f":"IF(ISERROR((N31-M31)/M31), \"\", (N31-M31)/M31)","v":3.9923088555703028E-2},{"$f":"IF(ISERROR((O31-N31)/N31), \"\", (O31-N31)/N31)","v":4.7143023569435109E-2},{"$f":"IF(ISERROR((P31-O31)/O31), \"\", (P31-O31)/O31)","v":4.2009517503283446E-2}]
[{"$f":"A17","v":"General Service < 50 kW"},2647033,2803802.9899999998,2711839.17,2566342.96,2587014,2774846.1900000004,2744666.7199999997,2812814.22,2800921.0050021349,2830937.5982667375,2873274.1474946309,2956718.7181202201,3045930.7933495017,3154197.3881818019,3257989.5916210362,null,"General Service < 50 kW",5.9224796215234098E-2,-3.2799672561872772E-2,-5.3652226728475187E-2,8.0546677985704751E-3,7.260578798568558E-2,-1.0876087513881505E-2,2.4829061941626367E-2,-4.2282262771926897E-3,1.0716686836578495E-2,1.4954956708976636E-2,2.9041632069236847E-2,3.0172662242960845E-2,3.5544666697184965E-2,3.2906058393214262E-2]
[{"$f":"A18","v":"General Service > 50 kW, Regular"},9817657.6699999981,10099472.48,9946724.7600000016,9425433.5,9538245.129999999,9869980.1000000015,9944399,10156193.300000001,10198427.952666137,10184084.011198506,10175775.460810328,10276207.574919488,10336637.541436829,10406726.670487542,10488920.87668892,null,"General Service > 50 kW, Regular",2.8704892701764212E-2,-1.5124326572747768E-2,-5.2408332649992978E-2,1.1968853209775334E-2,3.4779455285398247E-2,7.5399240166652915E-3,2.1297848165585546E-2,4.1585120939098925E-3,-1.406485542105705E-3,-8.1583678797638587E-4,9.8697258499808385E-3,5.8805708308995348E-3,6.7806507454425454E-3,7.8981805522454034E-3]
[{"$f":"A19","v":"General Service > 50 kW, Intermediate"},3385829.37,3452031.31,3374225.81,3072345.21,3207504.47,3263164.62,3137685.63,3039667.0799999996,3050989.8227851931,3100028.4569001189,3080270.247253858,3091114.6286340123,3103800.7931496217,3119048.1877666982,3135977.2775625093,null,"General Service > 50 kW, Intermediate",1.955265099493184E-2,-2.2539048175666751E-2,-8.9466626420002429E-2,4.3992211409081938E-2,1.7353101303706025E-2,-3.8453159620246258E-2,-3.1239123850658131E-2,3.7249943783953777E-3,1.6073024481661258E-2,-6.3735575079262663E-3,3.5205941393688872E-3,4.1040744325989307E-3,4.9124913721038162E-3,5.4276461204444144E-3]
[{"$f":"A20","v":"Large Use"},1604810.28,1621609.08,1681693.19,1684706.9599999997,1724380.4400000002,1784435.77,1883046.4700000002,1941695.6,2030408.0966584524,2124065.3422528855,2129485.2862269897,2135913.9940633317,2164531.867391767,2227766.551758491,2232717.7444427889,null,"Large Use",1.0467779406298448E-2,3.7052154394695343E-2,1.7921045395919014E-3,2.3549187450380364E-2,3.4827192774234808E-2,5.5261557551046059E-2,3.1145875013907587E-2,4.5688158668357862E-2,4.6127301082264996E-2,2.5516842002400886E-3,3.01890220980695E-3,1.3398420258482884E-2,2.9214023281126818E-2,2.2224917060495787E-3]
["Large Use with Dedicated Assets",1047870.8900000001,1094743.8499999999,1091050.02,989927.42999999993,979943.86,987578.66,905170.53,864720.1,852476.16,855327.71,855837.75861599995,855837.75861599995,855837.75861599995,855837.75861599995,855837.75861599995,null,"Large Use with Dedicated Assets",4.4731617651865223E-2,-3.3741500351884527E-3,-9.2683734151803671E-2,-1.0085153413720387E-2,7.7910585612527301E-3,-8.344462404645317E-2,-4.4688187097739529E-2,-1.4159425691619687E-2,3.3450202290700188E-3,5.9631952763460159E-4,0,0,0,0]
[{"$f":"A22","v":"Street Lighting"},143163.56,127391.76,114454.76000000001,110866.3,96997.119999999995,96188.53,93312.94,93691.39,93207.9,94717,95129.680000000008,95261.87,95307.819999999992,95324.03,95329.79,null,"Street Lighting",-0.11016630209530975,-0.10155287908731292,-3.1352649728154651E-2,-0.12509824897195998,-8.3362268900354624E-3,-2.989535238764951E-2,4.0557076006821459E-3,-5.1604528441728239E-3,1.6190687699218692E-2,4.3569792117572094E-3,1.3895768386899628E-3,4.8235458741254075E-4,1.7008048237811339E-4,6.0425477185498362E-5]
["Sentinel Lighting",755.18999999999994,782.92000000000007,688.84000000000015,698.51,664.29,661.37,631.66999999999996,587.43999999999994,629.3599999999999,590.18000000000006,573.65,557.11000000000013,540.55999999999995,524.03,507.50999999999993,null,"Sentinel Lighting",3.6719236218700109E-2,-0.1201655341541919,1.4038093025956454E-2,-4.8989992985068259E-2,-4.3956705655661824E-3,-4.4906784402074552E-2,-7.0020738676840791E-2,7.136047936810562E-2,-6.22537180627937E-2,-2.8008404215663162E-2,-2.8832912054388305E-2,-2.970688014934246E-2,-3.0579399141630853E-2,-3.1524912695838098E-2]
["Unmetered Scattered Load",44362.640000000007,44364.14,44561.120000000003,45198.68,44875.750000000007,45177.05,44925.23,47635.88,46271.01999999999,47095.249999999993,47482.16,47869.91,48257.86,48645.869999999995,49033.86,null,"Unmetered Scattered Load",3.3812234799207706E-5,4.4400725450781465E-3,1.4307539846395189E-2,-7.1446776764275645E-3,6.714093914864834E-3,-5.5740691346601798E-3,6.0336919810983582E-2,-2.8651932115036145E-2,1.7813093378966E-2,8.2154782064010872E-3,8.1662249569101307E-3,8.1042558885111148E-3,8.0403482458607737E-3,7.9758055514271876E-3]
["Embedded Distributor",17012,17012,17012,17012,17012,17012,17012,17012,17012,17012,17012,17012,17012,17012,17012,null,"Embedded Distributor",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
["Demand (Actual)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Demand (Actual) Variance Analysis"]
["Rate Class",{"$f":"B15","v":"Historical 2017"},"Historical 2018","Historical 2019",{"$f":"E15","v":"Historical 2020"},"Historical 2021","Historical 2022","Historical 2023","Historical 2024","Bridge Year 2025","Bridge Year 2026","Test Year 2027","Test Year 2028","Test Year 2029","Test Year 2030","Test Year 2031",null,"Rate Class",{"$f":"C15","v":"Historical 2018"},{"$f":"D15","v":"Historical 2019"},{"$f":"E15","v":"Historical 2020"},{"$f":"F15","v":"Historical 2021"},{"$f":"G15","v":"Historical 2022"},"Historical 2023","Historical 2024","Bridge Year 2025","Bridge Year 2026","Test Year 2027","Test Year 2028","Test Year 2029","Test Year 2030","Test Year 2031"]
[{"$f":"A31","v":"Residential"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A46","v":"Residential"},null,null,null,null,{"$f":"IF(ISERROR((G46-#REF!)/#REF!), \"\", (G46-#REF!)/#REF!)","v":""},{"$f":"IF(ISERROR((H46-G46)/G46), \"\", (H46-G46)/G46)","v":""},"","","","","","","",""]
[{"$f":"A32","v":"General Service < 50 kW"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service < 50 kW",null,null,null,null,{"$f":"IF(ISERROR((G47-#REF!)/#REF!), \"\", (G47-#REF!)/#REF!)","v":""},"","","","","","","","",""]
[{"$f":"A33","v":"General Service > 50 kW, Regular"},26709.32,26907.5,27022.33,26172.52,25981.72,26678.68,26846.38,26735.42,27180.930080593509,27405.931235106076,27755.019689708533,27942.22101632207,28173.422815192589,28293.740484751255,28499.608230593116,null,"General Service > 50 kW, Regular",{"$f":"IF(ISERROR((C48-B48)/B48), \"\", (C48-B48)/B48)","v":7.4198818989027158E-3},{"$f":"IF(ISERROR((D48-C48)/C48), \"\", (D48-C48)/C48)","v":4.267583387531422E-3},{"$f":"IF(ISERROR((E48-D48)/D48), \"\", (E48-D48)/D48)","v":-3.1448435423592311E-2},{"$f":"IF(ISERROR((F48-E48)/E48), \"\", (F48-E48)/E48)","v":-7.2900889941052401E-3},{"$f":"IF(ISERROR((G48-F48)/F48), \"\", (G48-F48)/F48)","v":2.6825013894384169E-2},6.2859181938536958E-3,-4.1331456978558282E-3,1.6663664928155637E-2,8.2779049077946094E-3,1.2737697238154296E-2,6.7447736916198256E-3,8.2742813728180695E-3,4.2706088765964434E-3,7.2760880079751847E-3]
[{"$f":"A34","v":"General Service > 50 kW, Intermediate"},7607.94,7640.69,7502.99,7231.75,7203.58,7403.0900000000011,7019.02,6805,6810.5075413103477,6797.3625513314855,6604.0749432295106,6525.7787651235221,6499.4420643078829,6474.9927515017043,6466.318449525902,null,"General Service > 50 kW, Intermediate",4.3047132338057351E-3,-1.802193257415231E-2,-3.6150921166095092E-2,-3.8953227088879003E-3,2.7695951179830185E-2,-5.1879688076195286E-2,-3.0491436126410868E-2,8.0933744457718337E-4,-1.9301043129500896E-3,-2.8435677314889319E-2,-1.1855737371099585E-2,-4.0357943110780163E-3,-3.7617556344480075E-3,-1.3396620365004363E-3]
[{"$f":"A35","v":"Large Use"},3029.02,3090.22,3129.88,3089.5400000000004,3206.45,3328.93,3492.28,3625.45,3784.787794320589,3926.1760968328963,4034.1483840393448,4151.3556143823471,4245.0935948953365,4491.6714093496321,4500.7203258741629,null,"Large Use",2.0204554608421146E-2,1.2834037706053392E-2,{"$f":"IF(ISERROR((E50-D50)/D50), \"\", (E50-D50)/D50)","v":-1.2888673048167881E-2},3.7840584682509171E-2,3.8198007141854708E-2,4.9069821233850029E-2,3.8132681228309186E-2,4.3949797768715382E-2,3.7356996005026497E-2,2.7500622627076216E-2,2.905377273843459E-2,2.258008930582453E-2,5.8085365832876289E-2,2.0145989543435962E-3]
["Large Use with Dedicated Assets",1882.8500000000001,1934.2500000000002,1934.9700000000003,1792.7,1890.3,1798.1299999999997,1646.35,1601.5499999999997,1623.0900000000001,1598.85,1620.1020256666666,1616.4220256666667,1620.1020256666666,1620.1020256666666,1620.1020256666666,null,"Large Use with Dedicated Assets",2.7299041346894381E-2,3.7223730127957977E-4,-7.3525687736760881E-2,5.4443018910023934E-2,-4.8759456170978314E-2,-8.440991474476249E-2,-2.7211710754092497E-2,1.3449470825138411E-2,-1.4934476831229466E-2,1.3292069716775601E-2,-2.2714618843128281E-3,2.2766331697825514E-3,0,0]
[{"$f":"A37","v":"Street Lighting"},401.89,341.2,334.96,301.45,272.70999999999998,268.36,262.29000000000002,258.82,261.49,264.52,265.73,265.38,266.24,266.31,266.31,null,"Street Lighting",-0.15101147080046778,{"$f":"IF(ISERROR((D52-C52)/C52), \"\", (D52-C52)/C52)","v":-1.8288393903868726E-2},-0.10004179603534748,-9.5339193896168559E-2,-1.5951010230647818E-2,-2.2618870174392579E-2,-1.3229631324107007E-2,1.031604976431503E-2,1.1587441202340329E-2,4.5743233025859536E-3,-1.3171264065029266E-3,3.2406360690331363E-3,2.6292067307689742E-4,0]
["Sentinel Lighting",1.8292000000000006,2.1792000000000002,1.9292000000000002,1.7504000000000004,1.7855999999999999,1.7087999999999997,1.7387999999999997,1.6986999999999999,1.6188,1.6088999999999998,1.5689,1.4887999999999997,1.4388999999999996,1.3888999999999998,1.3688999999999998,null,"Sentinel Lighting",0.1913404767111303,{"$f":"IF(ISERROR((D53-C53)/C53), \"\", (D53-C53)/C53)","v":-0.11472099853157121},-9.2680904001658626E-2,2.0109689213893649E-2,-4.3010752688172157E-2,1.7556179775280917E-2,-2.3061881757533823E-2,-4.7035968681933167E-2,-6.1156412157154939E-3,-2.4861706756168698E-2,-5.1054879214736622E-2,-3.3516926383664741E-2,-3.4748766418792015E-2,-1.4399884800921607E-2]
["Unmetered Scattered Load",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unmetered Scattered Load",null,null,null,null,{"$f":"IF(ISERROR((G54-#REF!)/#REF!), \"\", (G54-#REF!)/#REF!)","v":""},"","","","","","","","",""]
["Embedded Distributor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Embedded Distributor",null,null,null,null,{"$f":"IF(ISERROR((G55-#REF!)/#REF!), \"\", (G55-#REF!)/#REF!)","v":""},{"$f":"IF(ISERROR((H55-G55)/G55), \"\", (H55-G55)/G55)","v":""},"","","","","","","",""]
[]
[]
[]
["Consumption (Weather Normalized)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consumption (Weather Normalized) Variance Analysis"]
["Rate Class",{"$f":"B15","v":"Historical 2017"},"Historical 2018","Historical 2019",{"$f":"E15","v":"Historical 2020"},"Historical 2021","Historical 2022","Historical 2023","Historical 2024","Bridge Year 2025","Bridge Year 2026","Test Year 2027","Test Year 2028","Test Year 2029","Test Year 2030","Test Year 2031",null,"Rate Class",{"$f":"C15","v":"Historical 2018"},{"$f":"D15","v":"Historical 2019"},{"$f":"E15","v":"Historical 2020"},{"$f":"F15","v":"Historical 2021"},{"$f":"G15","v":"Historical 2022"},"Historical 2023","Historical 2024","Bridge Year 2025","Bridge Year 2026","Test Year 2027","Test Year 2028","Test Year 2029","Test Year 2030","Test Year 2031"]
[{"$f":"A46","v":"Residential"},7295018.0600000005,7406593.2000000002,7485787.2400000002,8169172.3100000005,8108383.8100000005,8124261.620000001,8284487.5299999993,8511337.3500000015,8420147.9366825074,8556581.533095425,8833994.4778626598,9184005.5599140264,9550659.4271785431,10000906.389657669,10421039.641682692,null,{"$f":"A61","v":"Residential"},{"$f":"IF(ISERROR((C61-B61)/B61), \"\", (C61-B61)/B61)","v":1.5294703739225514E-2},{"$f":"IF(ISERROR((D61-C61)/C61), \"\", (D61-C61)/C61)","v":1.0692370684000849E-2},{"$f":"IF(ISERROR((E61-D61)/D61), \"\", (E61-D61)/D61)","v":9.1291008960067671E-2},{"$f":"IF(ISERROR((F61-E61)/E61), \"\", (F61-E61)/E61)","v":-7.4412067334640409E-3},{"$f":"IF(ISERROR((G61-F61)/F61), \"\", (G61-F61)/F61)","v":1.9581966483158521E-3},{"$f":"IF(ISERROR((H61-G61)/G61), \"\", (H61-G61)/G61)","v":1.9721904278114356E-2},2.7382480712117407E-2,-1.0713876041759064E-2,1.6203230327883254E-2,3.2421001739333405E-2,3.9620930591304823E-2,3.9923088555703028E-2,4.7143023569435109E-2,4.2009517503283446E-2]
[{"$f":"A47","v":"General Service < 50 kW"},2541190.1,2603499.37,2713678.3100000005,2544016.2800000003,2583255.09,2757495.5800000005,2800928.33,2854839.6399999997,2794905.795002135,2830937.5982667375,2873274.1474946309,2956718.7181202201,3045930.7933495017,3154197.3881818019,3257989.5916210362,null,"General Service < 50 kW",2.4519720110667838E-2,4.2319557004540549E-2,-6.2521054678732438E-2,1.5423961830935919E-2,6.744997452032532E-2,1.5750795872535733E-2,1.9247657793514335E-2,-2.0993769372581884E-2,1.2891956261651041E-2,1.4954956708976636E-2,2.9041632069236847E-2,3.0172662242960845E-2,3.5544666697184965E-2,3.2906058393214262E-2]
[{"$f":"A48","v":"General Service > 50 kW, Regular"},9893480.8699999992,9969073.8900000006,9975559.2400000002,9369055.5800000001,9521979.1600000001,9839231.5700000003,10069504.550000001,10237327.43,10188309.802666137,10184084.011198506,10175775.460810328,10276207.574919488,10336637.541436829,10406726.670487542,10488920.87668892,null,"General Service > 50 kW, Regular",7.6406899647647897E-3,6.5054688846323994E-4,-6.0798963286994641E-2,1.6322197973341522E-2,3.3317906358450812E-2,2.3403553251262733E-2,1.6666448599002712E-2,-4.7881273378263638E-3,-4.1476864656445821E-4,-8.1583678797638587E-4,9.8697258499808385E-3,5.8805708308995348E-3,6.7806507454425454E-3,7.8981805522454034E-3]
[{"$f":"A49","v":"General Service > 50 kW, Intermediate"},3385829.37,3452031.31,3374225.81,3072345.21,3207504.47,3263164.62,3137685.63,3039667.0799999996,3050989.8227851931,3100028.4569001189,3080270.247253858,3091114.6286340123,3103800.7931496217,3119048.1877666982,3135977.2775625093,null,"General Service > 50 kW, Intermediate",1.955265099493184E-2,-2.2539048175666751E-2,-8.9466626420002429E-2,4.3992211409081938E-2,1.7353101303706025E-2,-3.8453159620246258E-2,-3.1239123850658131E-2,3.7249943783953777E-3,1.6073024481661258E-2,-6.3735575079262663E-3,3.5205941393688872E-3,4.1040744325989307E-3,4.9124913721038162E-3,5.4276461204444144E-3]
[{"$f":"A50","v":"Large Use"},1604810.28,1621609.08,1681693.19,1684706.9599999997,1724380.4400000002,1784435.77,1883046.4700000002,1941695.6,2030408.0966584524,2124065.3422528855,2129485.2862269897,2135913.9940633317,2164531.867391767,2227766.551758491,2232717.7444427889,null,"Large Use",1.0467779406298448E-2,3.7052154394695343E-2,1.7921045395919014E-3,2.3549187450380364E-2,3.4827192774234808E-2,5.5261557551046059E-2,3.1145875013907587E-2,4.5688158668357862E-2,4.6127301082264996E-2,2.5516842002400886E-3,3.01890220980695E-3,1.3398420258482884E-2,2.9214023281126818E-2,2.2224917060495787E-3]
["Large Use with Dedicated Assets",1047870.8900000001,1094743.8499999999,1091050.02,989927.42999999993,979943.86,987578.66,905170.53,864720.1,852476.16,855327.71,855837.75861599995,855837.75861599995,855837.75861599995,855837.75861599995,855837.75861599995,null,"Large Use with Dedicated Assets",4.4731617651865223E-2,-3.3741500351884527E-3,-9.2683734151803671E-2,-1.0085153413720387E-2,7.7910585612527301E-3,-8.344462404645317E-2,-4.4688187097739529E-2,-1.4159425691619687E-2,3.3450202290700188E-3,5.9631952763460159E-4,0,0,0,0]
[{"$f":"A52","v":"Street Lighting"},143163.56,127391.76,114454.76000000001,110866.3,96997.119999999995,96188.53,93312.94,93691.39,93207.9,94717,95129.680000000008,95261.87,95307.819999999992,95324.03,95329.79,null,"Street Lighting",-0.11016630209530975,-0.10155287908731292,-3.1352649728154651E-2,-0.12509824897195998,-8.3362268900354624E-3,-2.989535238764951E-2,4.0557076006821459E-3,-5.1604528441728239E-3,1.6190687699218692E-2,4.3569792117572094E-3,1.3895768386899628E-3,4.8235458741254075E-4,1.7008048237811339E-4,6.0425477185498362E-5]
["Sentinel Lighting",755.18999999999994,782.92000000000007,688.84000000000015,698.51,664.29,661.37,631.66999999999996,587.43999999999994,629.3599999999999,590.18000000000006,573.65,557.11000000000013,540.55999999999995,524.03,507.50999999999993,null,"Sentinel Lighting",3.6719236218700109E-2,-0.1201655341541919,1.4038093025956454E-2,-4.8989992985068259E-2,-4.3956705655661824E-3,-4.4906784402074552E-2,-7.0020738676840791E-2,7.136047936810562E-2,-6.22537180627937E-2,-2.8008404215663162E-2,-2.8832912054388305E-2,-2.970688014934246E-2,-3.0579399141630853E-2,-3.1524912695838098E-2]
["Unmetered Scattered Load",44362.640000000007,44364.14,44561.120000000003,45198.68,44875.750000000007,45177.05,44925.23,47635.88,46271.01999999999,47095.249999999993,47482.16,47869.91,48257.86,48645.869999999995,49033.86,null,"Unmetered Scattered Load",3.3812234799207706E-5,4.4400725450781465E-3,1.4307539846395189E-2,-7.1446776764275645E-3,6.714093914864834E-3,-5.5740691346601798E-3,6.0336919810983582E-2,-2.8651932115036145E-2,1.7813093378966E-2,8.2154782064010872E-3,8.1662249569101307E-3,8.1042558885111148E-3,8.0403482458607737E-3,7.9758055514271876E-3]
["Embedded Distributor",17012,17012,17012,17012,17012,17012,17012,17012,17012,17012,17012,17012,17012,17012,17012,null,"Embedded Distributor",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
["Demand (Weather Normalized)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Demand (Weather Normalized) Variance Analysis"]
["Rate Class",{"$f":"B15","v":"Historical 2017"},"Historical 2018","Historical 2019",{"$f":"E15","v":"Historical 2020"},"Historical 2021","Historical 2022","Historical 2023","Historical 2024","Bridge Year 2025","Bridge Year 2026","Test Year 2027","Test Year 2028","Test Year 2029","Test Year 2030","Test Year 2031",null,"Rate Class",{"$f":"C15","v":"Historical 2018"},{"$f":"D15","v":"Historical 2019"},{"$f":"E15","v":"Historical 2020"},{"$f":"F15","v":"Historical 2021"},{"$f":"G15","v":"Historical 2022"},"Historical 2023","Historical 2024","Bridge Year 2025","Bridge Year 2026","Test Year 2027","Test Year 2028","Test Year 2029","Test Year 2030","Test Year 2031"]
[{"$f":"A61","v":"Residential"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A76","v":"Residential"},null,null,null,null,{"$f":"IF(ISERROR((G76-#REF!)/#REF!), \"\", (G76-#REF!)/#REF!)","v":""},{"$f":"IF(ISERROR((H76-G76)/G76), \"\", (H76-G76)/G76)","v":""},"","","","","","","",""]
[{"$f":"A62","v":"General Service < 50 kW"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service < 50 kW",null,null,null,null,{"$f":"IF(ISERROR((G77-#REF!)/#REF!), \"\", (G77-#REF!)/#REF!)","v":""},"","","","","","","","",""]
[{"$f":"A63","v":"General Service > 50 kW, Regular"},26655.119999999999,26857.31,26879.53,25131.69,25613.47,26471.61,27096.940000000002,27469.87,27435.140080593508,27405.931235106076,27755.019689708533,27942.22101632207,28173.422815192589,28293.740484751255,28499.608230593116,null,"General Service > 50 kW, Regular",{"$f":"IF(ISERROR((C78-B78)/B78), \"\", (C78-B78)/B78)","v":7.5854094823059257E-3},{"$f":"IF(ISERROR((D78-C78)/C78), \"\", (D78-C78)/C78)","v":8.2733527668994126E-4},{"$f":"IF(ISERROR((E78-D78)/D78), \"\", (E78-D78)/D78)","v":-6.5024946492740029E-2},{"$f":"IF(ISERROR((F78-E78)/E78), \"\", (F78-E78)/E78)","v":1.9170218954634666E-2},{"$f":"IF(ISERROR((G78-F78)/F78), \"\", (G78-F78)/F78)","v":3.3503465168913053E-2},2.3622665942872448E-2,1.3762808641861281E-2,-1.2642913638284713E-3,-1.0646508602335553E-3,1.2737697238154296E-2,6.7447736916198256E-3,8.2742813728180695E-3,4.2706088765964434E-3,7.2760880079751847E-3]
[{"$f":"A64","v":"General Service > 50 kW, Intermediate"},7597.2499999999991,7747.52,7574.4600000000009,6882.6600000000008,7199.46,7314.52,7026.01,6793.69,6804.3775413103476,6797.3625513314855,6604.0749432295106,6525.7787651235221,6499.4420643078829,6474.9927515017043,6466.318449525902,null,"General Service > 50 kW, Intermediate",1.9779525486195843E-2,-2.2337470571227886E-2,-9.133324355795662E-2,4.6028715641917406E-2,1.5981754187119643E-2,-3.9443463139071357E-2,-3.3065708702378821E-2,1.5731570487243346E-3,-1.0309524914326254E-3,-2.8435677314889319E-2,-1.1855737371099585E-2,-4.0357943110780163E-3,-3.7617556344480075E-3,-1.3396620365004363E-3]
[{"$f":"A65","v":"Large Use"},3231.8,3261.49,3340.59,3331.22,3497.58,3686.04,3841.27,3856.8700000000003,3798.9377943205891,3926.1760968328963,4034.1483840393448,4151.3556143823471,4245.0935948953365,4491.6714093496321,4500.7203258741629,null,"Large Use",9.1868308682466725E-3,2.4252718849360373E-2,-2.8048937463143772E-3,4.9939661745546718E-2,5.3882970511039074E-2,4.211294505756856E-2,4.0611568569770837E-3,-1.5020523294643389E-2,3.3493126079223626E-2,2.7500622627076216E-2,2.905377273843459E-2,2.258008930582453E-2,5.8085365832876289E-2,2.0145989543435962E-3]
["Large Use with Dedicated Assets",2020.87,2098.0700000000002,2079.6999999999998,1880.1599999999999,1801.79,1833.73,1676.08,1589.88,1593.37,1598.85,1620.1020256666666,1616.4220256666667,1620.1020256666666,1620.1020256666666,1620.1020256666666,null,"Large Use with Dedicated Assets",3.8201368717433716E-2,-8.7556659215375764E-3,-9.5946530749627335E-2,-4.1682622755510115E-2,1.7726816110645555E-2,-8.597230780976485E-2,-5.1429526036943236E-2,2.1951342239664513E-3,3.4392513979803929E-3,1.3292069716775601E-2,-2.2714618843128281E-3,2.2766331697825514E-3,0,0]
[{"$f":"A67","v":"Street Lighting"},399.9,360.03,331.48,308.10000000000002,271.95,268.95,260.8,260.33,260.36,264.52,265.73,265.38,266.24,266.31,266.31,null,"Street Lighting",-9.969992498124533E-2,-7.9298947309946272E-2,-7.0532158802944347E-2,-0.11733203505355415,-1.1031439602868174E-2,{"$f":"IF(ISERROR((H82-G82)/G82), \"\", (H82-G82)/G82)","v":-3.0303030303030221E-2},{"$f":"IF(ISERROR((I82-H82)/H82), \"\", (I82-H82)/H82)","v":-1.8021472392639082E-3},{"$f":"IF(ISERROR((J82-I82)/I82), \"\", (J82-I82)/I82)","v":1.1523835132343395E-4},{"$f":"IF(ISERROR((K82-J82)/J82), \"\", (K82-J82)/J82)","v":1.5977876785988509E-2},{"$f":"IF(ISERROR((L82-K82)/K82), \"\", (L82-K82)/K82)","v":4.5743233025859536E-3},{"$f":"IF(ISERROR((M82-L82)/L82), \"\", (M82-L82)/L82)","v":-1.3171264065029266E-3},{"$f":"IF(ISERROR((N82-M82)/M82), \"\", (N82-M82)/M82)","v":3.2406360690331363E-3},{"$f":"IF(ISERROR((O82-N82)/N82), \"\", (O82-N82)/N82)","v":2.6292067307689742E-4},{"$f":"IF(ISERROR((P82-O82)/O82), \"\", (P82-O82)/O82)","v":0}]
["Sentinel Lighting",2.0291999999999999,2.1292000000000004,1.8592,1.9004000000000003,1.8055999999999996,1.7987999999999997,1.6988000000000001,1.5787000000000002,1.7188000000000001,1.6088999999999998,1.5689,1.4887999999999997,1.4388999999999996,1.3888999999999998,1.3688999999999998,null,"Sentinel Lighting",4.9280504632367703E-2,-0.12680819086981046,2.2160068846816022E-2,-4.9884234897916567E-2,-3.7660611431102782E-3,-5.5592617300422316E-2,-7.0696962561808255E-2,8.874390321150305E-2,-6.3939958110309711E-2,-2.4861706756168698E-2,-5.1054879214736622E-2,-3.3516926383664741E-2,-3.4748766418792015E-2,-1.4399884800921607E-2]
["Unmetered Scattered Load",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unmetered Scattered Load"]
["Embedded Distributor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Embedded Distributor"]