{"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:",0]
[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","Historical 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","Historical 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,990008,993468,997506,1001917,1006254,1010589,1014918,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.6130647351191626E-3,3.4949212531615904E-3,4.0645496382369639E-3,4.4220285391767065E-3,4.3287018784989176E-3,4.3080574089643369E-3,4.2836405304233468E-3]
["General Service < 50 kW",83247,84093,84306,85094,85764,87002,87707,88209,88728,89611,90383,91095,91792,92472,93137,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,5.8837533585008334E-3,9.9517626904697502E-3,8.6150137817901824E-3,7.8775875994379473E-3,7.6513529831494596E-3,7.4080529893672652E-3,7.191366035124146E-3]
["General Service > 50 kW, Regular",12980,13205,13270,13099,13059,12376,12086,11982,12112,11887,11698,11530,11383,11253,11142,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.084960774495076E-2,-1.857661822985469E-2,-1.5899722385799613E-2,-1.4361429304154556E-2,-1.2749349522983521E-2,-1.1420539400860933E-2,-9.8640362569981342E-3]
["General Service > 50 kW, Intermediate",619,626,633,655,647,563,508,487,483,460,437,417,399,385,372,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,-8.2135523613963042E-3,-4.7619047619047616E-2,-0.05,-4.5766590389016017E-2,-4.3165467625899283E-2,-3.5087719298245612E-2,-3.3766233766233764E-2]
["Large Use",26,25,26,27,24,25,27,30,31,31,32,32,34,35,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":0},{"$f":"IFERROR((N20-M20)/M20,)","v":6.25E-2},{"$f":"IFERROR((O20-N20)/N20,)","v":2.9411764705882353E-2},{"$f":"IFERROR((P20-O20)/O20,)","v":2.8571428571428571E-2}]
["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,242262,242780,274065,274963,275861,276758,277655,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,4.2530965527533202E-3,2.1381809776192715E-3,0.12886152071834583,3.2765949683469251E-3,3.265893956641439E-3,3.2516376000957005E-3,3.2410987216268364E-3]
["Sentinel Lighting",557,552,505,489,470,462,442,422,424,412,400,390,379,369,358,null,"Sentinel Lighting",-8.9766606822262122E-3,-8.5144927536231887E-2,-3.1683168316831684E-2,-3.8854805725971372E-2,-1.7021276595744681E-2,-4.3290043290043288E-2,-4.5248868778280542E-2,4.7393364928909956E-3,-2.8301886792452831E-2,-2.9126213592233011E-2,-2.5000000000000001E-2,-2.8205128205128206E-2,-2.6385224274406333E-2,-2.9810298102981029E-2]
["Unmetered Scattered Load",11156,11315,11276,11160,11251,11255,11352,11265,11527,11600,11647,11688,11726,11765,11803,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,2.3257878384376388E-2,6.3329574043549924E-3,4.0517241379310343E-3,3.5202197990898943E-3,3.2511978097193705E-3,3.3259423503325942E-3,3.2299192520186997E-3]
["Embedded Distributor",1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,null,"Embedded Distributor",0,0,0,0,0,0,0,0,0,-1,0,0,0,0]
[]
[]
[]
["Consumption (Actual) (kWh)",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","Historical 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","Historical 2025","Bridge Year 2026","Test Year 2027","Test Year 2028","Test Year 2029","Test Year 2030","Test Year 2031"]
[{"$f":"A16","v":"Residential"},7100277540.000001,7702402979.999999,7371237520.000001,8340436650,8161386970.000001,8175488820,8002561710,8358536729.999999,8739403250,8490540593.8858576,8726286423.8162537,9039740601.1710358,9367473815.9792862,9787463478.6343575,10180627801.494804,null,{"$f":"A31","v":"Residential"},{"$f":"IF(ISERROR((C31-B31)/B31), \"\", (C31-B31)/B31)","v":8.4803085035461592E-2},{"$f":"IF(ISERROR((D31-C31)/C31), \"\", (D31-C31)/C31)","v":-4.299508359402901E-2},{"$f":"IF(ISERROR((E31-D31)/D31), \"\", (E31-D31)/D31)","v":0.13148390990933623},{"$f":"IF(ISERROR((F31-E31)/E31), \"\", (F31-E31)/E31)","v":-2.1467662607328724E-2},{"$f":"IF(ISERROR((G31-F31)/F31), \"\", (G31-F31)/F31)","v":1.7278742022447007E-3},{"$f":"IF(ISERROR((H31-G31)/G31), \"\", (H31-G31)/G31)","v":-2.115189853565233E-2},{"$f":"IF(ISERROR((I31-H31)/H31), \"\", (I31-H31)/H31)","v":4.4482633549101244E-2},{"$f":"IF(ISERROR((J31-I31)/I31), \"\", (J31-I31)/I31)","v":4.5566171723935345E-2},{"$f":"IF(ISERROR((K31-J31)/J31), \"\", (K31-J31)/J31)","v":-2.8475932394370566E-2},{"$f":"IF(ISERROR((L31-K31)/K31), \"\", (L31-K31)/K31)","v":2.7765703175621062E-2},{"$f":"IF(ISERROR((M31-L31)/L31), \"\", (M31-L31)/L31)","v":3.5920684026516249E-2},{"$f":"IF(ISERROR((N31-M31)/M31), \"\", (N31-M31)/M31)","v":3.6254714517559815E-2},{"$f":"IF(ISERROR((O31-N31)/N31), \"\", (O31-N31)/N31)","v":4.4834890484416592E-2},{"$f":"IF(ISERROR((P31-O31)/O31), \"\", (P31-O31)/O31)","v":4.0170195650661579E-2}]
[{"$f":"A17","v":"General Service < 50 kW"},2647033000,2803802989.9999995,2711839170,2566342960,2587014000,2774846190.0000005,2744666719.9999995,2812814220,2870975080,2822588164.8764629,2875761313.7426443,2959530313.7858577,3048644735.3870969,3156460492.6276774,3259485792.2176251,null,"General Service < 50 kW",5.9224796215234007E-2,-3.2799672561872668E-2,-5.3652226728475201E-2,8.0546677985704612E-3,7.2605787985685608E-2,-1.0876087513881607E-2,2.4829061941626374E-2,2.0677106787379652E-2,-1.6853826235070302E-2,1.8838436838875011E-2,2.9129329907492441E-2,3.011100146064841E-2,3.5365143071316517E-2,3.2639502325651354E-2]
[{"$f":"A18","v":"General Service > 50 kW, Regular"},9817657669.9999981,10099472480,9946724760.0000019,9425433500,9538245129.9999981,9869980100.0000019,9944399000,10156193300,10326790940.000002,10091660677.287973,10130581240.387606,10232471451.942961,10286233747.676479,10348927250.230368,10422427933.519247,null,"General Service > 50 kW, Regular",2.8704892701764163E-2,-1.5124326572747699E-2,-5.2408332649992999E-2,1.1968853209775242E-2,3.4779455285398379E-2,7.539924016665249E-3,2.129784816558547E-2,1.6797399868315022E-2,-2.2768957372930845E-2,3.8567054862660871E-3,1.0057686635900929E-2,5.2540870488634603E-3,6.0948938252594091E-3,7.1022514229427272E-3]
[{"$f":"A19","v":"General Service > 50 kW, Intermediate"},3385829370,3452031310,3374225810,3072345210,3207504470,3263164620,3137685630,3039667079.9999995,2955085780,3056574956.7255116,3051784958.6951323,3063205153.9282489,3074474086.5613785,3089228664.7349625,3104224853.5356126,null,"General Service > 50 kW, Intermediate",1.9552650994931857E-2,-2.2539048175666751E-2,-8.9466626420002401E-2,4.3992211409081862E-2,1.7353101303706056E-2,-3.8453159620246188E-2,-3.1239123850658194E-2,-2.7825843348607618E-2,3.4343902100030257E-2,-1.567112895379732E-3,3.742136286692893E-3,3.6788044113461801E-3,4.7990575812873826E-3,4.8543472912312572E-3]
[{"$f":"A20","v":"Large Use"},1604810280,1621609080,1681693190,1684706959.9999998,1724380440.0000002,1784435770,1883046470.0000002,1941695600,2028497380,2136750981.7943931,2142187817.057292,2146170521.1353326,2176685488.2629623,2243062871.8184814,2253652065.2922769,null,"Large Use",1.0467779406298418E-2,3.7052154394695419E-2,1.7921045395918869E-3,2.3549187450380381E-2,3.482719277423476E-2,5.5261557551046087E-2,3.1145875013907517E-2,4.470411325029526E-2,5.336639961269906E-2,2.544440278358125E-3,1.8591759538207121E-3,1.4218332992239228E-2,3.0494705787049443E-2,4.7208634260040207E-3]
["Large Use with Dedicated Assets",1047870890.0000001,1094743849.9999998,1091050020,989927429.99999988,979943860,987578660,905170530,864720100,842988700.00000012,852839570,853349618.61599994,853349618.61599994,853349618.61599994,853349618.61599994,853349618.61599994,null,"Large Use with Dedicated Assets",4.473161765186514E-2,-3.3741500351883798E-3,-9.2683734151803712E-2,-1.008515341372032E-2,7.7910585612526824E-3,-8.344462404645317E-2,-4.4688187097739474E-2,-2.5131137809795194E-2,1.1685648929813507E-2,5.9805927625982108E-4,0,0,0,0]
[{"$f":"A22","v":"Street Lighting"},143163560,127391760,114454760.00000001,110866300,96997120,96188530,93312940,93691390,92001630,93601889.999999985,94572090,94836750,94932110,94967069.999999985,94979910,null,"Street Lighting",-0.11016630209530973,-0.10155287908731291,-3.1352649728154727E-2,-0.12509824897195992,-8.3362268900354988E-3,-2.9895352387649544E-2,4.055707600682178E-3,-1.8035381906491087E-2,1.7393822261627161E-2,1.0365175318575458E-2,2.7985000648711473E-3,1.0055173759117642E-3,3.6826317249226946E-4,1.3520476097677757E-4]
["Sentinel Lighting",755189.99999999988,782920.00000000012,688840.00000000012,698510,664290,661370,631670,587439.99999999988,653850,600510,585590,570690,555740,540860,525940,null,"Sentinel Lighting",3.6719236218700241E-2,-0.12016553415419198,1.4038093025956509E-2,-4.8989992985068218E-2,-4.395670565566244E-3,-4.4906784402074483E-2,-7.0020738676840943E-2,0.11304984338826114,-8.1578343656802013E-2,-2.4845547950908396E-2,-2.5444423572806914E-2,-2.6196358793740909E-2,-2.6775110663259799E-2,-2.7585696853159782E-2]
["Unmetered Scattered Load",44362640.000000007,44364140,44561120,45198680,44875750.000000007,45177050,44925230,47635880,46674990,47081540.000000007,47436520.000000007,47800570,48165810,48531370,48896950,null,"Unmetered Scattered Load",3.3812234799203769E-5,4.4400725450780745E-3,1.4307539846395243E-2,-7.144677676427554E-3,6.7140939148647655E-3,-5.5740691346601867E-3,6.0336919810983713E-2,-2.0171559757057075E-2,8.7102321821602418E-3,7.5396854053626948E-3,7.674466845375514E-3,7.6409130686098514E-3,7.5896159537231908E-3,7.5328596740623643E-3]
["Embedded Distributor",17012000,17012000,17012000,17012000,17012000,17012000,17012000,17012000,17012000,17012000,0,0,0,0,0,null,"Embedded Distributor",0,0,0,0,0,0,0,0,0,-1,"","","",""]
[]
[]
[]
["Demand (Actual)(kW)",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","Historical 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","Historical 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"},26709320,26907500,27022330,26172520,25981720,26678680,26846380,26735420,27432710,27179644.057836615,27663679.850542746,27888450.298148569,28122695.809249096,28246439.706982378,28431767.96169344,null,"General Service > 50 kW, Regular",{"$f":"IF(ISERROR((C48-B48)/B48), \"\", (C48-B48)/B48)","v":7.4198818989027054E-3},{"$f":"IF(ISERROR((D48-C48)/C48), \"\", (D48-C48)/C48)","v":4.2675833875313578E-3},{"$f":"IF(ISERROR((E48-D48)/D48), \"\", (E48-D48)/D48)","v":-3.1448435423592269E-2},{"$f":"IF(ISERROR((F48-E48)/E48), \"\", (F48-E48)/E48)","v":-7.2900889941052678E-3},{"$f":"IF(ISERROR((G48-F48)/F48), \"\", (G48-F48)/F48)","v":2.6825013894384204E-2},6.2859181938536689E-3,-4.1331456978557259E-3,2.6081131323166046E-2,-9.2249705611799002E-3,1.7808761280174733E-2,8.1251102102171107E-3,8.3993735254654055E-3,4.4001435201167644E-3,6.5611190873464138E-3]
[{"$f":"A34","v":"General Service > 50 kW, Intermediate"},7607940,7640690,7502990,7231750,7203580,7403090.0000000009,7019020,6805000,6674280,6827955.485763099,6724799.8338097967,6674716.0029432168,6618094.7122786753,6604913.8299734984,6549403.8977867747,null,"General Service > 50 kW, Intermediate",4.3047132338057343E-3,-1.8021932574152334E-2,-3.6150921166095119E-2,-3.8953227088878903E-3,2.7695951179830158E-2,-5.1879688076195328E-2,-3.0491436126410809E-2,-1.9209404849375458E-2,2.3025028282166623E-2,-1.5107838967080428E-2,-7.4476314692337739E-3,-8.4829512805600065E-3,-1.991643045047722E-3,-8.4043385902805058E-3]
[{"$f":"A35","v":"Large Use"},3029020,3090220,3129880,3089540.0000000005,3206450,3328930,3492280,3625450,3806360,3938883.818271786,4047427.3781634243,4062419.7406213358,4234072.3643019665,4611469.4404429914,4855310.4262892585,null,"Large Use",2.0204554608421205E-2,1.283403770605329E-2,{"$f":"IF(ISERROR((E50-D50)/D50), \"\", (E50-D50)/D50)","v":-1.2888673048167832E-2},3.7840584682509212E-2,3.8198007141854701E-2,4.9069821233849918E-2,3.8132681228309297E-2,4.9900012412252275E-2,3.4816417330937162E-2,2.755693361355924E-2,3.7041708367141781E-3,4.2253788293766241E-2,8.913335523570888E-2,5.2877068577698957E-2]
["Large Use with Dedicated Assets",1882850.0000000002,1934250.0000000002,1934970.0000000002,1792700,1890300,1798129.9999999998,1646350,1601549.9999999998,1620140.0000000002,1584260,1605512.0256666667,1601912.0256666667,1605512.0256666667,1605512.0256666667,1605512.0256666667,null,"Large Use with Dedicated Assets",2.7299041346894332E-2,3.7223730127956567E-4,-7.3525687736760895E-2,5.4443018910023989E-2,-4.8759456170978273E-2,-8.440991474476249E-2,-2.7211710754092528E-2,1.1607505229309398E-2,-2.2146234276050357E-2,1.3414480998489315E-2,-2.242275325533703E-3,2.2473144232135907E-3,0,0]
[{"$f":"A37","v":"Street Lighting"},401890,341200,334960,301450,272710,268360,262290,258820,259450.00000000006,261269.99999999997,264100,264120,265150,265240,265260,null,"Street Lighting",-0.15101147080046778,{"$f":"IF(ISERROR((D52-C52)/C52), \"\", (D52-C52)/C52)","v":-1.8288393903868699E-2},-0.1000417960353475,-9.5339193896168517E-2,-1.595101023064794E-2,-2.2618870174392607E-2,-1.3229631324106905E-2,2.4341241016925209E-3,7.0148390826745514E-3,1.0831706663604813E-2,7.572889057175312E-5,3.8997425412691201E-3,3.3943051103149159E-4,7.5403408234052177E-5]
["Sentinel Lighting",1829.2000000000005,2179.2000000000003,1929.2000000000003,1750.4000000000003,1785.6,1708.7999999999997,1738.7999999999997,1698.6999999999998,1658.8000000000002,1628.9,1608.8999999999999,1558.7999999999997,1488.8999999999996,1448.8999999999996,1418.8999999999996,null,"Sentinel Lighting",0.19134047671113036,{"$f":"IF(ISERROR((D53-C53)/C53), \"\", (D53-C53)/C53)","v":-0.11472099853157121},-9.2680904001658682E-2,2.0109689213893729E-2,-4.3010752688172151E-2,1.75561797752809E-2,-2.3061881757533882E-2,-2.3488550067698618E-2,-1.8025078369906009E-2,-1.2278224568727502E-2,-3.1139287712101522E-2,-4.4842186297151719E-2,-2.6865471153200357E-2,-2.0705362688936441E-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"]
[]
[]
[]
["Consumption (Weather Normalized)(kWh)",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","Historical 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","Historical 2025","Bridge Year 2026","Test Year 2027","Test Year 2028","Test Year 2029","Test Year 2030","Test Year 2031"]
[{"$f":"A46","v":"Residential"},7333178530,7424347850,7519724610,8194552850,8139250279.999999,8153332510.0000019,8328234420,8550216690.000001,8653310320,8490540593.8858576,8726286423.8162537,9039740601.1710358,9367473815.9792862,9787463478.6343575,10180627801.494804,null,{"$f":"A61","v":"Residential"},{"$f":"IF(ISERROR((C61-B61)/B61), \"\", (C61-B61)/B61)","v":1.2432442443208866E-2},{"$f":"IF(ISERROR((D61-C61)/C61), \"\", (D61-C61)/C61)","v":1.2846483209969749E-2},{"$f":"IF(ISERROR((E61-D61)/D61), \"\", (E61-D61)/D61)","v":8.9741084281542594E-2},{"$f":"IF(ISERROR((F61-E61)/E61), \"\", (F61-E61)/E61)","v":-6.7486989238224214E-3},{"$f":"IF(ISERROR((G61-F61)/F61), \"\", (G61-F61)/F61)","v":1.7301630390462526E-3},{"$f":"IF(ISERROR((H61-G61)/G61), \"\", (H61-G61)/G61)","v":2.1451585567678271E-2},2.6654181283240218E-2,1.2057428921137557E-2,-1.8810110824055416E-2,2.7765703175621062E-2,3.5920684026516249E-2,3.6254714517559815E-2,4.4834890484416592E-2,4.0170195650661579E-2]
[{"$f":"A47","v":"General Service < 50 kW"},2547564929.9999995,2608497330,2720212810,2549746260.0000005,2589611130.0000005,2763936719.9999995,2808418480,2862304370,2849677579.9999995,2822588164.8764629,2875761313.7426443,2959530313.7858577,3048644735.3870969,3156460492.6276774,3259485792.2176251,null,"General Service < 50 kW",2.3917898728493051E-2,4.2827523231545726E-2,-6.26666227632387E-2,1.5634838111302885E-2,6.7317284815654549E-2,1.6093624603677789E-2,1.9187272261504275E-2,-4.4114071628240138E-3,-9.5061333652828855E-3,1.8838436838875011E-2,2.9129329907492441E-2,3.011100146064841E-2,3.5365143071316517E-2,3.2639502325651354E-2]
[{"$f":"A48","v":"General Service > 50 kW, Regular"},9904142670,9985136469.9999981,9986308290,9383549490,9536239160,9853158260.0000019,10080423440,10250777790,10286366620.000002,10091660677.287973,10130581240.387606,10232471451.942961,10286233747.676479,10348927250.230368,10422427933.519247,null,"General Service > 50 kW, Regular",8.17776991897857E-3,1.173564330865783E-4,-6.0358521136743316E-2,1.6272058900815792E-2,3.3233132546562717E-2,2.3065211580190131E-2,1.6899523220822159E-2,3.471817527321691E-3,-1.8928543955788781E-2,3.8567054862660871E-3,1.0057686635900929E-2,5.2540870488634603E-3,6.0948938252594091E-3,7.1022514229427272E-3]
[{"$f":"A49","v":"General Service > 50 kW, Intermediate"},3385829370,3452031310,3374225810,3072345210,3207504470,3263164620,3137685630,3039667079.9999995,2955085780,3056574956.7255116,3051784958.6951323,3063205153.9282489,3074474086.5613785,3089228664.7349625,3104224853.5356126,null,"General Service > 50 kW, Intermediate",1.9552650994931857E-2,-2.2539048175666751E-2,-8.9466626420002401E-2,4.3992211409081862E-2,1.7353101303706056E-2,-3.8453159620246188E-2,-3.1239123850658194E-2,-2.7825843348607618E-2,3.4343902100030257E-2,-1.567112895379732E-3,3.742136286692893E-3,3.6788044113461801E-3,4.7990575812873826E-3,4.8543472912312572E-3]
[{"$f":"A50","v":"Large Use"},1604810280,1621609080,1681693190,1684706959.9999998,1724380440.0000002,1784435770,1883046470.0000002,1941695600,2028497380,2136750981.7943931,2142187817.057292,2146170521.1353326,2176685488.2629623,2243062871.8184814,2253652065.2922769,null,"Large Use",1.0467779406298418E-2,3.7052154394695419E-2,1.7921045395918869E-3,2.3549187450380381E-2,3.482719277423476E-2,5.5261557551046087E-2,3.1145875013907517E-2,4.470411325029526E-2,5.336639961269906E-2,2.544440278358125E-3,1.8591759538207121E-3,1.4218332992239228E-2,3.0494705787049443E-2,4.7208634260040207E-3]
["Large Use with Dedicated Assets",1047870890.0000001,1094743849.9999998,1091050020,989927429.99999988,979943860,987578660,905170530,864720100,842988700.00000012,852839570,853349618.61599994,853349618.61599994,853349618.61599994,853349618.61599994,853349618.61599994,null,"Large Use with Dedicated Assets",4.473161765186514E-2,-3.3741500351883798E-3,-9.2683734151803712E-2,-1.008515341372032E-2,7.7910585612526824E-3,-8.344462404645317E-2,-4.4688187097739474E-2,-2.5131137809795194E-2,1.1685648929813507E-2,5.9805927625982108E-4,0,0,0,0]
[{"$f":"A52","v":"Street Lighting"},143163560,127391760,114454760.00000001,110866300,96997120,96188530,93312940,93691390,92001630,93601889.999999985,94572090,94836750,94932110,94967069.999999985,94979910,null,"Street Lighting",-0.11016630209530973,-0.10155287908731291,-3.1352649728154727E-2,-0.12509824897195992,-8.3362268900354988E-3,-2.9895352387649544E-2,4.055707600682178E-3,-1.8035381906491087E-2,1.7393822261627161E-2,1.0365175318575458E-2,2.7985000648711473E-3,1.0055173759117642E-3,3.6826317249226946E-4,1.3520476097677757E-4]
["Sentinel Lighting",755189.99999999988,782920.00000000012,688840.00000000012,698510,664290,661370,631670,587439.99999999988,653850,600510,585590,570690,555740,540860,525940,null,"Sentinel Lighting",3.6719236218700241E-2,-0.12016553415419198,1.4038093025956509E-2,-4.8989992985068218E-2,-4.395670565566244E-3,-4.4906784402074483E-2,-7.0020738676840943E-2,0.11304984338826114,-8.1578343656802013E-2,-2.4845547950908396E-2,-2.5444423572806914E-2,-2.6196358793740909E-2,-2.6775110663259799E-2,-2.7585696853159782E-2]
["Unmetered Scattered Load",44362640.000000007,44364140,44561120,45198680,44875750.000000007,45177050,44925230,47635880,46674990,47081540.000000007,47436520.000000007,47800570,48165810,48531370,48896950,null,"Unmetered Scattered Load",3.3812234799203769E-5,4.4400725450780745E-3,1.4307539846395243E-2,-7.144677676427554E-3,6.7140939148647655E-3,-5.5740691346601867E-3,6.0336919810983713E-2,-2.0171559757057075E-2,8.7102321821602418E-3,7.5396854053626948E-3,7.674466845375514E-3,7.6409130686098514E-3,7.5896159537231908E-3,7.5328596740623643E-3]
["Embedded Distributor",17012000,17012000,17012000,17012000,17012000,17012000,17012000,17012000,17012000,17012000,0,0,0,0,0,null,"Embedded Distributor",0,0,0,0,0,0,0,0,0,-1,"","","",""]
[]
[]
[]
["Demand (Weather Normalized)(kW)",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","Historical 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","Historical 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"},26684850,26900980,26909310,25171480,25652580,26509780,27127670,27507200,27715040,27179644.057836615,27663679.850542746,27888450.298148569,28122695.809249096,28246439.706982378,28431767.96169344,null,"General Service > 50 kW, Regular",{"$f":"IF(ISERROR((C78-B78)/B78), \"\", (C78-B78)/B78)","v":8.0993522541816798E-3},{"$f":"IF(ISERROR((D78-C78)/C78), \"\", (D78-C78)/C78)","v":3.0965414642886618E-4},{"$f":"IF(ISERROR((E78-D78)/D78), \"\", (E78-D78)/D78)","v":-6.4580994458795116E-2},{"$f":"IF(ISERROR((F78-E78)/E78), \"\", (F78-E78)/E78)","v":1.9112900790895091E-2},{"$f":"IF(ISERROR((G78-F78)/F78), \"\", (G78-F78)/F78)","v":3.3415742198250623E-2},2.3308001801599258E-2,1.3990512270312932E-2,7.5558399255467659E-3,-1.9317884519141428E-2,1.7808761280174733E-2,8.1251102102171107E-3,8.3993735254654055E-3,4.4001435201167644E-3,6.5611190873464138E-3]
[{"$f":"A64","v":"General Service > 50 kW, Intermediate"},7597249.9999999991,7747520,7574460.0000000009,6882660.0000000009,7199460,7314520,7026010,6793690,6619690,6827955.485763099,6724799.8338097967,6674716.0029432168,6618094.7122786753,6604913.8299734984,6549403.8977867747,null,"General Service > 50 kW, Intermediate",1.9779525486195788E-2,-2.2337470571227834E-2,-9.1333243557956592E-2,4.6028715641917371E-2,1.5981754187119588E-2,-3.9443463139071329E-2,-3.3065708702378731E-2,-2.5612001725130232E-2,3.1461516440059741E-2,-1.5107838967080428E-2,-7.4476314692337739E-3,-8.4829512805600065E-3,-1.991643045047722E-3,-8.4043385902805058E-3]
[{"$f":"A65","v":"Large Use"},3232010,3261520,3340190,3331250,3498589.9999999995,3686830,3842170,3857250.0000000005,3909030.0000000005,3938883.818271786,4047427.3781634243,4062419.7406213358,4234072.3643019665,4611469.4404429914,4855310.4262892585,null,"Large Use",9.1305410564942562E-3,2.4120655399936228E-2,-2.6764944509144691E-3,5.0233395872420122E-2,5.3804532683166789E-2,4.2133757184356212E-2,3.9248653755561223E-3,1.3424071553567955E-2,7.6371422761619904E-3,2.755693361355924E-2,3.7041708367141781E-3,4.2253788293766241E-2,8.913335523570888E-2,5.2877068577698957E-2]
["Large Use with Dedicated Assets",2020870,2098070,2079710,1880159.9999999998,1801790,1833730,1676080,1589880,1575580,1584260,1605512.0256666667,1601912.0256666667,1605512.0256666667,1605512.0256666667,1605512.0256666667,null,"Large Use with Dedicated Assets",3.8201368717433577E-2,-8.7508996363324393E-3,-9.5950877766611806E-2,-4.1682622755510053E-2,1.7726816110645523E-2,-8.5972307809764795E-2,-5.1429526036943347E-2,-8.9943895136739872E-3,5.5090823696670429E-3,1.3414480998489315E-2,-2.242275325533703E-3,2.2473144232135907E-3,0,0]
[{"$f":"A67","v":"Street Lighting"},398780,355900,322000,308820,270920,268540,260450,260579.99999999997,256740,261269.99999999997,264100,264120,265150,265240,265260,null,"Street Lighting",-0.10752796027885049,-9.525147513346445E-2,-4.0931677018633539E-2,-0.12272521209766207,-8.7848811457256759E-3,{"$f":"IF(ISERROR((H82-G82)/G82), \"\", (H82-G82)/G82)","v":-3.0125865792805542E-2},{"$f":"IF(ISERROR((I82-H82)/H82), \"\", (I82-H82)/H82)","v":4.9913611057773432E-4},{"$f":"IF(ISERROR((J82-I82)/I82), \"\", (J82-I82)/I82)","v":-1.4736357356665789E-2},{"$f":"IF(ISERROR((K82-J82)/J82), \"\", (K82-J82)/J82)","v":1.7644309418088224E-2},{"$f":"IF(ISERROR((L82-K82)/K82), \"\", (L82-K82)/K82)","v":1.0831706663604813E-2},{"$f":"IF(ISERROR((M82-L82)/L82), \"\", (M82-L82)/L82)","v":7.572889057175312E-5},{"$f":"IF(ISERROR((N82-M82)/M82), \"\", (N82-M82)/M82)","v":3.8997425412691201E-3},{"$f":"IF(ISERROR((O82-N82)/N82), \"\", (O82-N82)/N82)","v":3.3943051103149159E-4},{"$f":"IF(ISERROR((P82-O82)/O82), \"\", (P82-O82)/O82)","v":7.5403408234052177E-5}]
["Sentinel Lighting",2030.4,2130.4000000000005,1860.4,1900.3000000000002,1804.5999999999997,1798.9,1698.9,1578.8000000000002,1838.9,1628.9,1608.8999999999999,1558.7999999999997,1488.8999999999996,1448.8999999999996,1418.8999999999996,null,"Sentinel Lighting",4.9251379038613305E-2,-0.12673676304919282,2.1447000645022623E-2,-5.0360469399568744E-2,-3.1585947024269042E-3,-5.5589526933125799E-2,-7.0692801224321561E-2,0.1647453762351152,-0.11419870574800152,-1.2278224568727502E-2,-3.1139287712101522E-2,-4.4842186297151719E-2,-2.6865471153200357E-2,-2.0705362688936441E-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"]