{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["DSM Balance","Expense Summary","Revenue By Month","Billing Determinants","WA Electric - Sched 91","Rev Conv Factor","Base Revenue"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":3,"defined_names":7,"comments":5,"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":"DSM Balance","index":0,"n_rows":36,"n_cols":18,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[null,null,null,2023,2023,2023,2023,2023,2023,2023,2023,2024,2024,2024,2024,2024,2024,2024]
[null,null,"End April","End May","End June","End July","End August","End September","End October ","End November","End December","End January","End February","End March","End April","End May","End June","End July"]
["Expected elec tariff rider revenue",null,{"$f":"-'Revenue By Month'!D39","v":-1045909.0816533121},{"$f":"-'Revenue By Month'!E39","v":-1019355.3848406757},{"$f":"-'Revenue By Month'!F39","v":-1052744.0869451666},{"$f":"-'Revenue By Month'!G39","v":-1200819.759857737},{"$f":"-'Revenue By Month'!H39","v":-1241039.5878658411},{"$f":"-'Revenue By Month'!I39","v":-1043314.8271610722},{"$f":"-'Revenue By Month'!J39","v":-1081260.7646999198},{"$f":"-'Revenue By Month'!K39","v":-1230960.3993016169},{"$f":"-'Revenue By Month'!L39","v":-1396437.503681055},{"$f":"-'Revenue By Month'!M39","v":-1405408.8785123397},{"$f":"-'Revenue By Month'!N39","v":-1252164.3085182968},{"$f":"-'Revenue By Month'!O39","v":-1172794.1106796367},{"$f":"-'Revenue By Month'!P39","v":-1041174.1190906866},{"$f":"-'Revenue By Month'!Q39","v":-1015475.2564155861},{"$f":"-'Revenue By Month'!R39","v":-1046315.5138116415},{"$f":"-'Revenue By Month'!S39","v":-1176720.8656790371}]
["Expected DSM expenditures",null,{"$f":"'Expense Summary'!C49","v":1155600.8016148068},{"$f":"'Expense Summary'!D49","v":1374385.5916148066},{"$f":"'Expense Summary'!E49","v":1665325.7816148067},{"$f":"'Expense Summary'!F49","v":1183833.8916148068},{"$f":"'Expense Summary'!G49","v":1136862.0016148067},{"$f":"'Expense Summary'!H49","v":1330945.4416148071},{"$f":"'Expense Summary'!I49","v":1454842.8316148072},{"$f":"'Expense Summary'!J49","v":1318468.261614807},{"$f":"'Expense Summary'!K49","v":2433007.2216148069},{"$f":"'Expense Summary'!L49","v":1355287.8582814734},{"$f":"'Expense Summary'!M49","v":1691796.0782814731},{"$f":"'Expense Summary'!N49","v":1375068.1872814733},{"$f":"'Expense Summary'!C65","v":1166017.4682814735},{"$f":"'Expense Summary'!D65","v":1384802.2582814733},{"$f":"'Expense Summary'!E65","v":1675742.4482814735},{"$f":"'Expense Summary'!F65","v":1194250.5582814733}]
["Net change in balance",null,{"$f":"C3+C4","v":109691.71996149467},{"$f":"D3+D4","v":355030.20677413081},{"$f":"E3+E4","v":612581.69466964016},-16985.868242930155,-104177.5862510344,287630.61445373495,373582.0669148874,87507.862313190009,1036569.7179337519,-50121.02023086627,439631.76976317633,202274.0766018366,124843.34919078695,369327.0018658872,629426.93446983199,17529.692602436291]
["Accounting Adjustment"]
["Elec Tariff rider balance",-3714997.44,{"$f":"C5+C6+B7","v":-3605305.7200385053},{"$f":"D5+D6+C7","v":-3250275.5132643743},{"$f":"E5+E6+D7","v":-2637693.8185947342},{"$f":"F5+F6+E7","v":-2654679.6868376643},{"$f":"G5+G6+F7","v":-2758857.2730886987},-2471226.6586349639,-2097644.5917200763,-2010136.7294068863,-973567.01147313439,-1023688.0317040007,-584056.26194082433,-381782.18533898774,-256938.83614820079,112388.16571768641,741815.1001875184,{"$f":"Q7+R5+R6","v":759344.79278995469}]
[]
[]
[]
[]
[]
["Tariff rider balance annual interest rate",0,"applied to E  \"shareholder owes customer\" balances."]
["2015 Washington electric DSM budget ",null,"CY 2016 expected expenditures"]
["2016 Washington electric DSM budget ",{"$f":"B14*1.02","v":0},"CY 2017 expected expenditures + 2% increase"]
[]
[]
[]
["End of July Balance",{"$f":"F7","v":-2654679.6868376643},"Overfunded \"Rebate\""]
["Aug 2021 - July 2023 Expenditure Budget",{"$f":"SUM(G4:R4)","v":17517090.615044348}]
["Aug 2021 - July 2023 Forecasted Revenue",{"$f":"SUM(G3:R3)","v":-14103066.135416733}]
[null,{"$f":"SUM(C6:R6)","v":0}]
["Total Projected DSM Balance July 2023",{"$f":"B19+B20+B22+B21","v":759344.79278995097},"Overfunded"]
[]
[null,"Present","Proposed"]
["Gross Annual Revenue Recovered",{"$f":"'WA Electric - Sched 91'!C11","v":14757857.515522966},{"$f":"'WA Electric - Sched 91'!C19","v":14509924.565760206},{"$f":"C26-B26","v":-247932.94976275973}]
["Revenue Conversion Factor",{"$f":"'Rev Conv Factor'!E22","v":0.95563100000000001},{"$f":"'Rev Conv Factor'!E22","v":0.95563100000000001}]
[]
["Net Annual Revenue to be Recovered",{"$f":"B26*B27","v":14103066.135416728},{"$f":"C26*C27","v":13866133.722701993},{"$f":"C29-B29","v":-236932.41271473467}]
[]
[]
[]
["August 2021 - July 2022"]
["Annual DSM Expense",{"$f":"SUM(G4:R4)","v":17517090.615044348}]
["Annual DSM Revenue",{"$f":"SUM(G3:R3)","v":-14103066.135416733}]
[null,{"$f":"B34+B35","v":3414024.4796276148}]

{"sheet":"Expense Summary","index":1,"n_rows":65,"n_cols":15,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[]
["AVA Jet","(All)"]
["Project Number","02803400"]
[]
["Sum of Transaction Amount",null,"Accounting Period"]
["Task Number","Task Name","202204","202205","202206","202207","202208","202209","202210","202211","202212","202301","202302","202303","Grand Total"]
["242609","DSM Residential",33824.28,157505.63,135716.54999999999,99943.95,45885.369999999995,130712.85,26496.770000000004,54155.609999999993,162930.67000000004,14960.149999999994,25479.129999999997,52802.560000000005,940413.52000000014]
["242610","DSM Limited Inc Eff",5550.95,2965.99,4013.48,4416.26,21183.41,4611.3100000000004,6546.1500000000005,2730.77,-154.69,8007.83,10808.93,13232.97,83913.359999999986]
["242612","DSM Regional",18688.580000000002,-23321.22,365873.8,4884.1899999999996,26808.82,328557.21999999997,158071.76999999999,12052.31,250450.91,5920.95,16451.830000000002,317676.77,1482115.93]
["242614","DSM General",60378.04,132730.43,52760.94,46763.54,54446.61,54263.729999999996,58274.809999999983,58984.619999999995,193971.97999999995,170285.61000000002,121461.65000000001,129935.86,1134257.82]
["242615","DSM Non Residentrial",87932.38,102885.02,151518.19999999998,80803.540000000008,116723.85,120561.04000000001,88699.630000000092,119086.72000000003,185136.75000000017,125540.85000000005,80648.400000000023,199354.04999999996,1458890.4300000004]
["242617","CEIP Implementation",null,null,null,null,null,965.56,664.25,1398.79,-497.34000000000003,null,10925.869999999999,12147.560000000001,25604.690000000002]
["242623","DSM Compliance",-129.34999999999994,427.97,373.23000000000019,-199.97000000000003,3450.9800000000014,2073.42,132.11999999999998,null,null,null,7548.41,null,13676.810000000001]
["242624","CEEP Implemntn",1116.8599999999992,864.16000000000008,2591.6999999999994,-192.10999999999996,657.34,488.49999999999983,153.57999999999998,743.05,34.209999999999994,null,null,null,6457.2899999999991]
["242633","DSM Residential",39591.910000000003,40674.01,37265.880000000005,38831.96,30211.489999999998,44795.79,41955.22,45678.540000000008,50881.58,25846.21,82644.009999999995,99669.469999999987,578046.07000000007]
["242634","DSM Limited Inc Eff",124894.93,55002.51,79575.540000000023,198593.36000000004,102022.89000000001,43738.64,134150.34,154213.46000000005,200477.34999999992,28939.16,null,89389.23000000001,1210997.4099999999]
["242638","DSM General",null,null,1500,2851.1000000000004,null,3153.02,null,null,115.79999999999998,null,null,null,7619.920000000001]
["242639","DSM Non Residentrial",330352.37,510059.47,355663.56000000006,307340.15999999997,228812.5,206187.68,424880.32,358882.24999999994,802691.44000000018,408180.98,834232.2,1424222.71,6191505.6399999997]
["242643","Always On Pilot",null,60,85,null,51140,41510,68285,40410,56995,5530,-5,10,264020]
["242646","CEEP Rebates",39238.29,-54773.279999999999,26807.29,null,null,-99909.87,-4766,null,3846.11,1256,5770.9600000000009,162.38,-82368.119999999981]
["242651","On-Bill Repayment",271.38,927.97,697.81000000000029,378.92000000000013,326.46999999999997,258.07000000000005,2551.9999999999986,552.61,859.70999999999992,883.22,1628.6500000000005,998.15000000000009,10334.959999999999]
["242663","DSM General",22153.360000000001,30929.870000000003,38778.509999999995,1102.5,11769.98,18928.71,16710.080000000002,17386.18,70013.67,49192.37,5885.17,38580.759999999995,321431.15999999997]
["242667","Res MF Install Pilot",327.97,722.06,790.95,583.26,823.38,611.13,569.05999999999995,757,238.87,784.87,272.49,1066.3900000000001,7547.4299999999994]
["242669","General Plt-Inv Only",4411.4600000000009,6825.5800000000036,4034.21,7883.74,4112.3399999999992,3102.8,5006.68,7962.7899999999991,2299.7200000000003,1638.4,-1550.72,3893.4900000000002,49620.490000000005]
["242670","Res Direct Benefit",null,24762.32,17812.900000000001,null,43638.22,33069.18,27106,40288.370000000003,59943,110292,86672.4,52770.2,496354.59]
["242672","NonRes Dir Benefit",1600,775,1424.5,3087.73,3235,3505,4101.2700000000004,1332.5,2502.5,null,3330,251142.44,276035.94]
["242673","DSM NEEA Committees",864.93,null,689.08,1092.2,null,1959.71,-466.49,null,2615.98,-1002.64,null,2073.08,7825.8499999999995]
["242683","DSM Residential",null,null,null,null,null,null,178.12,null,9.5,null,null,null,187.62]
["242684","DSM Limited Inc Eff",null,76.61,2665.07,null,124.5,null,7774.1900000000005,14758.03,null,null,null,null,25398.400000000001]
["242686","DSM Regional",null,null,null,null,null,null,null,null,null,null,null,44.8,44.8]
["242688","DSM General",null,null,null,235.84,null,null,147.44,null,null,null,null,null,383.28]
["242689","DSM Non Residentrial",675.46,273.85000000000002,237.93,270.72000000000003,5354.0999999999995,683.43000000000006,-183.39000000000001,535.87,839.29,3821.57,2135.29,359.85,15003.97]
["242691","Res Wx Audit Pilot",294.68,449.32,887.33,1600.68,2572.4300000000003,3556.2,4241.59,2996.47,3242.89,1231.3399999999999,3477.4200000000005,4515.95,29066.300000000003]
["Grand Total",null,772038.48,990823.26999999979,1281763.46,800271.57,753299.67999999993,947383.12000000023,1071280.5100000005,934905.94000000018,2049444.9000000001,961308.86999999988,1297817.0899999996,2694048.67,14554385.560000002]
[]
[null,null,202304,202305,202306,202307,202308,202309,202310,202311,202312,202401,202402,202403]
[null,"Additions"]
[null,"MFDI Adjustment",16668.521666666664,16668.521666666664,16668.521666666664,16668.521666666664,16668.521666666664,16668.521666666664,16668.521666666664,16668.521666666664,16668.521666666664,16668.521666666664,16668.521666666664,16668.521666666664,{"$f":"SUM(C38:N38)","v":200022.25999999998}]
[null,"Low Income Funding Adj",25000,25000,25000,25000,25000,25000,25000,25000,25000,35416.666666666664,35416.666666666664,35416.666666666664,331250]
[null,"Labor",34658.472895000006,34658.472895000006,34658.472895000006,34658.472895000006,34658.472895000006,34658.472895000006,34658.472895000006,34658.472895000006,34658.472895000006,34658.472895000006,34658.472895000006,34658.472895000006,415901.6747400001]
[null,"Midstream",37920.833333333336,37920.833333333336,37920.833333333336,37920.833333333336,37920.833333333336,37920.833333333336,37920.833333333336,37920.833333333336,37920.833333333336,37920.833333333336,37920.833333333336,37920.833333333336,455049.99999999994]
[null,"Named Communities",116666.66666666667,116666.66666666667,116666.66666666667,116666.66666666667,116666.66666666667,116666.66666666667,116666.66666666667,116666.66666666667,116666.66666666667,116666.66666666667,116666.66666666667,116666.66666666667,1400000.0000000002]
[null,"LESS: Downstream",-16133.333333333334,-16133.333333333334,-16133.333333333334,-16133.333333333334,-16133.333333333334,-16133.333333333334,-16133.333333333334,-16133.333333333334,-16133.333333333334,-16133.333333333334,-16133.333333333334,-16133.333333333334,-193600.00000000003]
[null,"ADD: Incent Revisions",65656.160386473421,65656.160386473421,65656.160386473421,65656.160386473421,65656.160386473421,65656.160386473421,65656.160386473421,65656.160386473421,65656.160386473421,65656.160386473421,65656.160386473421,65656.160386473421,787873.92463768099]
[null,"ADD: DI Lighting",103125,103125,103125,103125,103125,103125,103125,103125,103125,103125,103125,103125,1237500]
[]
[null,"Historic Expense",772038.48,990823.26999999979,1281763.46,800271.57,753299.67999999993,947383.12000000023,1071280.5100000005,934905.94000000018,2049444.9000000001,961308.86999999988,1297817.0899999996,{"$f":"AVERAGE(L47:M47,C47:J47)","v":981089.19899999979},{"$f":"SUM(C47:N47)","v":12841426.089}]
[]
[null,"Revised Expense",{"$f":"SUM(C38:C47)","v":1155600.8016148068},1374385.5916148066,1665325.7816148067,1183833.8916148068,1136862.0016148067,1330945.4416148071,1454842.8316148072,1318468.261614807,2433007.2216148069,1355287.8582814734,1691796.0782814731,{"$f":"SUM(N38:N47)","v":1375068.1872814733},{"$f":"SUM(C49:N49)","v":17475423.94837768}]
[]
[]
[null,null,202404,202405,202406,202407,202408,202409,202410,202411,202412,202501,202502,202503]
[null,"Additions"]
[null,"MFDI Adjustment",16668.521666666664,16668.521666666664,16668.521666666664,16668.521666666664,16668.521666666664,16668.521666666664,16668.521666666664,16668.521666666664,16668.521666666664,16668.521666666664,16668.521666666664,16668.521666666664,{"$f":"SUM(C54:N54)","v":200022.25999999998}]
[null,"Low Income Funding Adj",35416.666666666664,35416.666666666664,35416.666666666664,35416.666666666664,35416.666666666664,35416.666666666664,35416.666666666664,35416.666666666664,35416.666666666664,35416.666666666664,35416.666666666664,35416.666666666664,425000.00000000006]
[null,"Labor",34658.472895000006,34658.472895000006,34658.472895000006,34658.472895000006,34658.472895000006,34658.472895000006,34658.472895000006,34658.472895000006,34658.472895000006,34658.472895000006,34658.472895000006,34658.472895000006,415901.6747400001]
[null,"Midstream",37920.833333333336,37920.833333333336,37920.833333333336,37920.833333333336,37920.833333333336,37920.833333333336,37920.833333333336,37920.833333333336,37920.833333333336,37920.833333333336,37920.833333333336,37920.833333333336,455049.99999999994]
[null,"Named Communities",116666.66666666667,116666.66666666667,116666.66666666667,116666.66666666667,116666.66666666667,116666.66666666667,116666.66666666667,116666.66666666667,116666.66666666667,116666.66666666667,116666.66666666667,116666.66666666667,1400000.0000000002]
[null,"LESS: Downstream",-16133.333333333334,-16133.333333333334,-16133.333333333334,-16133.333333333334,-16133.333333333334,-16133.333333333334,-16133.333333333334,-16133.333333333334,-16133.333333333334,-16133.333333333334,-16133.333333333334,-16133.333333333334,-193600.00000000003]
[null,"ADD: Incent Revisions",65656.160386473421,65656.160386473421,65656.160386473421,65656.160386473421,65656.160386473421,65656.160386473421,65656.160386473421,65656.160386473421,65656.160386473421,65656.160386473421,65656.160386473421,65656.160386473421,787873.92463768099]
[null,"ADD: DI Lighting",103125,103125,103125,103125,103125,103125,103125,103125,103125,103125,103125,103125,1237500]
[]
[null,"Historic Expense",772038.48,990823.26999999979,1281763.46,800271.57,753299.67999999993,947383.12000000023,1071280.5100000005,934905.94000000018,2049444.9000000001,961308.86999999988,1297817.0899999996,{"$f":"AVERAGE(L63:M63,C63:J63)","v":981089.19899999979},{"$f":"SUM(C63:N63)","v":12841426.089}]
[]
[null,"Revised Expense",{"$f":"SUM(C54:C63)","v":1166017.4682814735},1384802.2582814733,1675742.4482814735,1194250.5582814733,1147278.6682814735,1341362.1082814736,1465259.498281474,1328884.9282814737,2443423.8882814734,1355287.8582814734,1691796.0782814731,{"$f":"SUM(N54:N63)","v":1375068.1872814733},{"$f":"SUM(C65:N65)","v":17569173.94837768}]

{"sheet":"Revenue By Month","index":2,"n_rows":39,"n_cols":33,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Forecasted Usage",null,null,"2023-04-30","2023-05-31",{"$f":"EOMONTH(E4,1)","v":"2023-06-30"},{"$f":"EOMONTH(F4,1)","v":"2023-07-31"},"2023-08-31","2023-09-30","2023-10-31","2023-11-30","2023-12-31","2024-01-31","2024-02-29","2024-03-31","2024-04-30","2024-05-31","2024-06-30","2024-07-31","2024-08-31","2024-09-30","2024-10-31","2024-11-30","2024-12-31","2025-01-31","2025-02-28","2025-03-31","2025-04-30","2025-05-31","2025-06-30","2025-07-31"]
[null,"Residential Schedule 001",null,{"$f":"'Billing Determinants'!C19","v":181583684.5377253},{"$f":"'Billing Determinants'!D19","v":162022515.32896534},{"$f":"'Billing Determinants'!E19","v":159931912.39447597},{"$f":"'Billing Determinants'!F19","v":198158176.60755882},{"$f":"'Billing Determinants'!G19","v":216731951.23623958},{"$f":"'Billing Determinants'!H19","v":164017440.80219781},{"$f":"'Billing Determinants'!I19","v":174053253.52054298},{"$f":"'Billing Determinants'!J19","v":236773377.24326912},{"$f":"'Billing Determinants'!K19","v":298266778.8709479},{"$f":"'Billing Determinants'!L19","v":302171651.63186604},{"$f":"'Billing Determinants'!M19","v":255730233.69181731},{"$f":"'Billing Determinants'!N19","v":225395651.36142737},{"$f":"'Billing Determinants'!O19","v":181906626.94919324},{"$f":"'Billing Determinants'!P19","v":163109108.5320513},{"$f":"'Billing Determinants'!Q19","v":160836285.89153969},{"$f":"'Billing Determinants'!R19","v":192846665.11564612},{"$f":"'Billing Determinants'!S19","v":210550430.58599028},{"$f":"'Billing Determinants'!T19","v":163969095.68927413},{"$f":"'Billing Determinants'!U19","v":175095773.297465},{"$f":"'Billing Determinants'!V19","v":231549337.06281796},{"$f":"'Billing Determinants'!W19","v":299152933.54704177},{"$f":"'Billing Determinants'!X19","v":302328007.51787877},{"$f":"'Billing Determinants'!Y19","v":258494889.70794377},{"$f":"'Billing Determinants'!Z19","v":229713558.67287052},{"$f":"'Billing Determinants'!AA19","v":186545860.40999639},{"$f":"'Billing Determinants'!AB19","v":167672812.35691783},{"$f":"'Billing Determinants'!AC19","v":163238286.12627891},{"$f":"'Billing Determinants'!AD19","v":192721178.34528553}]
[null,"General Svc Schedule 011/012",null,{"$f":"'Billing Determinants'!C20","v":50808435.730159394},{"$f":"'Billing Determinants'!D20","v":49109075.812856637},{"$f":"'Billing Determinants'!E20","v":49953954.79644493},{"$f":"'Billing Determinants'!F20","v":57741452.322056554},{"$f":"'Billing Determinants'!G20","v":57339320.126637816},{"$f":"'Billing Determinants'!H20","v":51272987.222308233},{"$f":"'Billing Determinants'!I20","v":52608254.540086895},{"$f":"'Billing Determinants'!J20","v":59878691.449857399},{"$f":"'Billing Determinants'!K20","v":67435321.272054702},{"$f":"'Billing Determinants'!L20","v":66133910.670872316},{"$f":"'Billing Determinants'!M20","v":60885910.686236769},{"$f":"'Billing Determinants'!N20","v":57688794.160564564},{"$f":"'Billing Determinants'!O20","v":50347560.911027625},{"$f":"'Billing Determinants'!P20","v":48824704.065570995},{"$f":"'Billing Determinants'!Q20","v":50227686.126204953},{"$f":"'Billing Determinants'!R20","v":57931610.441819154},{"$f":"'Billing Determinants'!S20","v":57481870.091528334},{"$f":"'Billing Determinants'!T20","v":51262488.164858654},{"$f":"'Billing Determinants'!U20","v":53015017.317423165},{"$f":"'Billing Determinants'!V20","v":60234079.674004182},{"$f":"'Billing Determinants'!W20","v":67569214.433902174},{"$f":"'Billing Determinants'!X20","v":67326490.033845857},{"$f":"'Billing Determinants'!Y20","v":61658514.085823506},{"$f":"'Billing Determinants'!Z20","v":58693530.294853821},{"$f":"'Billing Determinants'!AA20","v":50945046.30359377},{"$f":"'Billing Determinants'!AB20","v":49614516.313268423},{"$f":"'Billing Determinants'!AC20","v":51011184.536461003},{"$f":"'Billing Determinants'!AD20","v":58913531.596389219}]
[null,"Large Gen Svc Schedule 021/022",null,{"$f":"'Billing Determinants'!C21","v":104269710.20322296},{"$f":"'Billing Determinants'!D21","v":108413207.35369599},{"$f":"'Billing Determinants'!E21","v":111040385.00889461},{"$f":"'Billing Determinants'!F21","v":120789739.19127303},{"$f":"'Billing Determinants'!G21","v":111952114.90990794},{"$f":"'Billing Determinants'!H21","v":105129211.82162112},{"$f":"'Billing Determinants'!I21","v":116328470.75931405},{"$f":"'Billing Determinants'!J21","v":116509335.80866526},{"$f":"'Billing Determinants'!K21","v":112361609.26844884},{"$f":"'Billing Determinants'!L21","v":108840193.28556219},{"$f":"'Billing Determinants'!M21","v":107061683.44391383},{"$f":"'Billing Determinants'!N21","v":104587213.64796768},{"$f":"'Billing Determinants'!O21","v":101691844.59995094},{"$f":"'Billing Determinants'!P21","v":106046619.74609959},{"$f":"'Billing Determinants'!Q21","v":109214001.77959111},{"$f":"'Billing Determinants'!R21","v":118198030.78811762},{"$f":"'Billing Determinants'!S21","v":109436841.50923821},{"$f":"'Billing Determinants'!T21","v":102737660.44081947},{"$f":"'Billing Determinants'!U21","v":114507148.48046592},{"$f":"'Billing Determinants'!V21","v":114544779.95811552},{"$f":"'Billing Determinants'!W21","v":110492786.41836353},{"$f":"'Billing Determinants'!X21","v":108454046.54390475},{"$f":"'Billing Determinants'!Y21","v":105652219.992305},{"$f":"'Billing Determinants'!Z21","v":103521714.57265073},{"$f":"'Billing Determinants'!AA21","v":99952564.98722966},{"$f":"'Billing Determinants'!AB21","v":104634031.59443773},{"$f":"'Billing Determinants'!AC21","v":108212062.03462645},{"$f":"'Billing Determinants'!AD21","v":117589390.5773868}]
[null,"Extra Large Gen Schedule 25",null,{"$f":"'Billing Determinants'!C22","v":84867685},{"$f":"'Billing Determinants'!D22","v":84074970},{"$f":"'Billing Determinants'!E22","v":90024038},{"$f":"'Billing Determinants'!F22","v":88297285},{"$f":"'Billing Determinants'!G22","v":95443061},{"$f":"'Billing Determinants'!H22","v":83739469},{"$f":"'Billing Determinants'!I22","v":87408384},{"$f":"'Billing Determinants'!J22","v":84996016},{"$f":"'Billing Determinants'!K22","v":84617796},{"$f":"'Billing Determinants'!L22","v":91017408},{"$f":"'Billing Determinants'!M22","v":79822758},{"$f":"'Billing Determinants'!N22","v":85787474},{"$f":"'Billing Determinants'!O22","v":86045432},{"$f":"'Billing Determinants'!P22","v":84031959},{"$f":"'Billing Determinants'!Q22","v":86651976},{"$f":"'Billing Determinants'!R22","v":85922359},{"$f":"'Billing Determinants'!S22","v":94769422},{"$f":"'Billing Determinants'!T22","v":83521188},{"$f":"'Billing Determinants'!U22","v":85812002},{"$f":"'Billing Determinants'!V22","v":84557239},{"$f":"'Billing Determinants'!W22","v":83813238},{"$f":"'Billing Determinants'!X22","v":90098560},{"$f":"'Billing Determinants'!Y22","v":79110724},{"$f":"'Billing Determinants'!Z22","v":84101558},{"$f":"'Billing Determinants'!AA22","v":85999648},{"$f":"'Billing Determinants'!AB22","v":83163103},{"$f":"'Billing Determinants'!AC22","v":85928262},{"$f":"'Billing Determinants'!AD22","v":85530841}]
[null,"Pumping Schedule 31/32",null,{"$f":"'Billing Determinants'!C23","v":6023493.2336146021},{"$f":"'Billing Determinants'!D23","v":13502436.753305124},{"$f":"'Billing Determinants'!E23","v":21744100.306249153},{"$f":"'Billing Determinants'!F23","v":25491747.595475763},{"$f":"'Billing Determinants'!G23","v":28414339.756238058},{"$f":"'Billing Determinants'!H23","v":22894573.204752006},{"$f":"'Billing Determinants'!I23","v":11407152.223987106},{"$f":"'Billing Determinants'!J23","v":1659747.4462104633},{"$f":"'Billing Determinants'!K23","v":3324665.2279788703},{"$f":"'Billing Determinants'!L23","v":3996028.926227618},{"$f":"'Billing Determinants'!M23","v":4398901.7123823194},{"$f":"'Billing Determinants'!N23","v":4240882.9001918444},{"$f":"'Billing Determinants'!O23","v":6327667.9602181073},{"$f":"'Billing Determinants'!P23","v":13808147.840110611},{"$f":"'Billing Determinants'!Q23","v":22265301.684893828},{"$f":"'Billing Determinants'!R23","v":25147825.080746349},{"$f":"'Billing Determinants'!S23","v":28438389.20170968},{"$f":"'Billing Determinants'!T23","v":22445550.067114357},{"$f":"'Billing Determinants'!U23","v":11475151.829113407},{"$f":"'Billing Determinants'!V23","v":1983651.976261552},{"$f":"'Billing Determinants'!W23","v":3363787.3729673554},{"$f":"'Billing Determinants'!X23","v":4126410.8903535679},{"$f":"'Billing Determinants'!Y23","v":4367103.1230658833},{"$f":"'Billing Determinants'!Z23","v":4193323.6928262231},{"$f":"'Billing Determinants'!AA23","v":6242712.6726810597},{"$f":"'Billing Determinants'!AB23","v":13309356.526024992},{"$f":"'Billing Determinants'!AC23","v":21503664.393777825},{"$f":"'Billing Determinants'!AD23","v":25365529.823583011}]
[null,"Street and Area Lights",null,{"$f":"'Billing Determinants'!C24","v":1302576.1267940914},{"$f":"'Billing Determinants'!D24","v":1305319.0584098492},{"$f":"'Billing Determinants'!E24","v":1315164.5230185864},{"$f":"'Billing Determinants'!F24","v":1319522.9235993021},{"$f":"'Billing Determinants'!G24","v":1343017.048684244},{"$f":"'Billing Determinants'!H24","v":1345900.7959291809},{"$f":"'Billing Determinants'!I24","v":1314322.6735311958},{"$f":"'Billing Determinants'!J24","v":1330329.7010500454},{"$f":"'Billing Determinants'!K24","v":1338864.1154058825},{"$f":"'Billing Determinants'!L24","v":1340188.064714706},{"$f":"'Billing Determinants'!M24","v":1272098.5856400984},{"$f":"'Billing Determinants'!N24","v":1353925.3824872593},{"$f":"'Billing Determinants'!O24","v":1292839.6562630786},{"$f":"'Billing Determinants'!P24","v":1297017.5794819526},{"$f":"'Billing Determinants'!Q24","v":1313152.508189003},{"$f":"'Billing Determinants'!R24","v":1314340.3992536208},{"$f":"'Billing Determinants'!S24","v":1313371.6555335638},{"$f":"'Billing Determinants'!T24","v":1318741.2360407989},{"$f":"'Billing Determinants'!U24","v":1283836.7137207252},{"$f":"'Billing Determinants'!V24","v":1303362.0311496446},{"$f":"'Billing Determinants'!W24","v":1306376.539913778},{"$f":"'Billing Determinants'!X24","v":1324673.3176681858},{"$f":"'Billing Determinants'!Y24","v":1249320.6327347257},{"$f":"'Billing Determinants'!Z24","v":1328407.0762940696},{"$f":"'Billing Determinants'!AA24","v":1270504.384507658},{"$f":"'Billing Determinants'!AB24","v":1273798.0869214772},{"$f":"'Billing Determinants'!AC24","v":1287598.2319709167},{"$f":"'Billing Determinants'!AD24","v":1291310.3797258679}]
["Total Forecasted Usage",null,null,{"$f":"SUM(D5:D10)","v":428855584.83151639},{"$f":"SUM(E5:E10)","v":418427524.30723298},434009555.02908325,491797923.63996345,511223804.07770759,428399582.84680837,443119837.71746218,501147497.64905226,567345034.7548362,573499380.57924283,509171586.11999029,479053941.45263869,{"$f":"SUM(P5:P10)","v":427611972.076653},417117556.76331443,430508403.99041861,481360830.82558286,{"$f":"SUM(T5:T10)","v":501990325.04400009},425254723.5981074,441188929.63818824,494172449.70234883,565698336.31218863,573658188.30365109,510532771.54187286,481552092.30949533,430956336.75800848,419667617.87757045,431181057.32311511,481411781.72237045]
[null,null,null,{"$f":"D11-'Billing Determinants'!C25","v":0},{"$f":"E11-'Billing Determinants'!D25","v":0},{"$f":"F11-'Billing Determinants'!E25","v":0},{"$f":"G11-'Billing Determinants'!F25","v":0},{"$f":"H11-'Billing Determinants'!G25","v":0},{"$f":"I11-'Billing Determinants'!H25","v":0},{"$f":"J11-'Billing Determinants'!I25","v":0},{"$f":"K11-'Billing Determinants'!J25","v":0},{"$f":"L11-'Billing Determinants'!K25","v":0},{"$f":"M11-'Billing Determinants'!L25","v":0},{"$f":"N11-'Billing Determinants'!M25","v":0},{"$f":"O11-'Billing Determinants'!N25","v":0},{"$f":"P11-'Billing Determinants'!O25","v":0},{"$f":"Q11-'Billing Determinants'!P25","v":0},{"$f":"R11-'Billing Determinants'!Q25","v":0},{"$f":"S11-'Billing Determinants'!R25","v":0},{"$f":"T11-'Billing Determinants'!S25","v":0},{"$f":"U11-'Billing Determinants'!T25","v":0},{"$f":"V11-'Billing Determinants'!U25","v":0},{"$f":"W11-'Billing Determinants'!V25","v":0},{"$f":"X11-'Billing Determinants'!W25","v":0},{"$f":"Y11-'Billing Determinants'!X25","v":0},{"$f":"Z11-'Billing Determinants'!Y25","v":0},{"$f":"AA11-'Billing Determinants'!Z25","v":0},{"$f":"AB11-'Billing Determinants'!AA25","v":0},{"$f":"AC11-'Billing Determinants'!AB25","v":0},{"$f":"AD11-'Billing Determinants'!AC25","v":0},{"$f":"AE11-'Billing Determinants'!AD25","v":0}]
[]
["DSM Rates"]
[null,"Residential Schedule 001",null,2.5519921155876982E-3,2.5519921155876982E-3,2.5519921155876982E-3,2.5519921155876982E-3,{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":2.5519921155876982E-3}]
[null,"General Svc Schedule 011/012",null,3.2068451271835556E-3,3.2068451271835556E-3,3.2068451271835556E-3,3.2068451271835556E-3,{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":3.2068451271835556E-3}]
[null,"Large Gen Svc Schedule 021/022",null,2.7348446453900189E-3,2.7348446453900189E-3,2.7348446453900189E-3,2.7348446453900189E-3,{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":2.7348446453900189E-3}]
[null,"Extra Large Gen Schedule 25",null,1.8167505621790386E-3,1.8167505621790386E-3,1.8167505621790386E-3,1.8167505621790386E-3,{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":1.8167505621790386E-3}]
[null,"Pumping Schedule 31/32",null,2.3613825413033489E-3,2.3613825413033489E-3,2.3613825413033489E-3,2.3613825413033489E-3,{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3613825413033489E-3}]
[null,"Street and Area Lights",null,1.1182488739420801E-2,1.1182488739420801E-2,1.1182488739420801E-2,1.1182488739420801E-2,{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2},{"$f":"'WA Electric - Sched 91'!$I$23","v":1.1182488739420801E-2}]
[]
[]
["Gross DSM Revenue",null,null,{"$f":"D4","v":"2023-04-30"},{"$f":"E4","v":"2023-05-31"},"2023-06-30","2023-07-31","2023-08-31","2023-09-30","2023-10-31","2023-11-30","2023-12-31","2024-01-31","2024-02-29","2024-03-31","2024-04-30","2024-05-31","2024-06-30","2024-07-31",{"$f":"T4","v":"2024-08-31"},"2024-09-30","2024-10-31","2024-11-30","2024-12-31","2025-01-31","2025-02-28","2025-03-31","2025-04-30","2025-05-31","2025-06-30","2025-07-31"]
[null,"Residential Schedule 001",null,{"$f":"D5*D15","v":463400.13125963876},{"$f":"E5*E15","v":413480.18166720652},{"$f":"F5*F15","v":408144.97946156515},{"$f":"G5*G15","v":505698.10434172477},553098.23075082083,418571.21574608085,444182.53067681246,604243.79190589453,761174.46802039852,771139.6725186347,652621.54009891732,575207.9251621163,{"$f":"P5*P15","v":464224.27774749382},416253.15895433305,410452.93349561823,{"$f":"S5*S15","v":492143.16889251012},{"$f":"T5*T15","v":537323.03878904216},418447.8393990724,446843.03292786167,590912.08255386981,763435.92776698119,771538.69150696497,659676.92045438406,586227.19057675765,476063.56496183411,427899.69513326988,416582.8191563125,491822.92764393933]
[null,"General Svc Schedule 011/012",null,{"$f":"D6*D16","v":162934.7845410805},{"$f":"E6*E16","v":157485.20047094711},160194.59652252702,185167.89501548867,183878.31934412644,164424.52923000386,168706.52472150984,192021.68989810284,216254.63142134619,212081.20917647943,195251.68599829156,184999.02844690162,{"$f":"P6*P16","v":161456.8303731062},156573.26431885548,161072.41050352543,185777.70265524375,{"$f":"T6*T16","v":184335.45500441579},164390.86037878165,170010.94995193029,193161.36489296638,216684.00605497995,215905.6264954108,197729.30544550173,188221.06162325238,163372.8734928203,159106.06987677386,163584.96856261112,188926.5717250552]
[null,"Large Gen Svc Schedule 021/022",null,{"$f":"D7*D17","v":285161.45862565335},{"$f":"E7*E17","v":296493.27962081332},303678.20236362156,330341.17144531,306171.64200144983,287512.06202443357,318140.29536251939,318634.93317427579,307291.54545522283,297661.01981023443,292797.07169302896,286029.7812214063,{"$f":"P7*P17","v":278111.39668400976},290021.03017433191,298683.32796853076,323253.25159652805,{"$f":"T7*T17","v":299292.76000993629},280971.5405364731,313159.26188068208,313262.17812583019,302180.6052904845,296604.96846147778,288942.40811952361,283115.80678060773,273354.73714832292,286157.82103161811,295943.17842201074,321588.71517524181]
[null,"Extra Large Gen Schedule 25",null,{"$f":"D8*D18","v":154183.41443458357},{"$f":"E8*E18","v":152743.24901268579},163551.22164612715,160414.14216263278,173396.23472783828,152133.72738232417,158799.23077116127,154416.55985097855,153729.4284533512,165355.92715207892,145018.04047118136,155854.44161741965,{"$f":"P8*P18","v":156323.08695893825},152665.10875425593,157425.02611192456,156099.49401699918,{"$f":"T8*T18","v":172172.40069588253},151737.16525286116,155899.0028752088,153619.41148955733,152267.74725454557,163686.60953152183,143724.45230139076,152791.55277663301,156239.90885119943,151086.6141278033,156110.21829556773,155388.20347039597]
[null,"Pumping Schedule 31/32",null,{"$f":"D9*D19","v":14223.771759516376},{"$f":"E9*E19","v":31884.418414307394},51346.138839525549,60195.767719268093,67097.12582304221,54062.845456292845,26936.65010771282,3919.2986424542073,7850.8064250276229,9436.1529409370651,10387.489704529014,10014.346840224935,{"$f":"P9*P19","v":14942.044648423613},32606.319237372743,52576.894675560325,59383.635097424907,{"$f":"T9*T19","v":67153.915763706915},53002.530058434051,27097.223188073589,4684.1611447659143,7943.1887751817694,9744.0346347249233,10312.401070879107,9902.0413582735309,14741.432715642222,31428.482136537204,50778.377673513416,59897.719276318334]
[null,"Street and Area Lights",null,{"$f":"D10*D20","v":14566.04287011329},{"$f":"E10*E20","v":14596.715672019502},14706.812469141072,14755.550234556809,15018.273023761718,15050.52049485556,{"$f":"J10*J20","v":14697.398496728039},14876.396901709175,14971.832894140873,14986.637942378356,14225.228109353529,{"$f":"O10*O20","v":15140.255343679779},{"$f":"P10*P20","v":14457.164898038536},14503.884477387759,14684.313135965707,14697.596714419455,{"$f":"T10*T20","v":14686.763748678533},14746.809022236104,14356.489594437016,14574.831236719525,14608.540947029331,14813.144458235682,13970.513907482142,14854.897172025343,14207.400973141641,14244.232763295178,14398.55272991291,14440.063780381717]
[null,"Total",null,{"$f":"SUM(D24:D29)","v":1094469.6034905859},{"$f":"SUM(E24:E29)","v":1066683.0448579795},1101621.9513025077,1256572.6309189813,1298659.8256710393,1091754.9003339908,1131462.6301364435,1288112.6703734153,1461272.7126694871,{"$f":"SUM(M24:M29)","v":1470660.6195407428},1310301.0560753017,1227245.7786317486,{"$f":"SUM(P24:P29)","v":1089514.8013100103},1062622.7659165368,1094894.9058911251,1231354.8489731257,{"$f":"SUM(T24:T29)","v":1274964.3340116623},1083296.7446478584,1127365.9604181934,1270214.0294437092,1457120.0160892024,1472293.0750883359,1314356.0012991612,1235112.5502875496,1097979.9181429609,1069922.9150692974,1097398.1148399285,1232064.2010713324,null,{"$f":"SUM(H30:S30)-'WA Electric - Sched 91'!D39","v":247932.94976276159}]
[]
["Net DSM Revenue",null,{"$f":"'Rev Conv Factor'!E22","v":0.95563100000000001},{"$f":"D4","v":"2023-04-30"},{"$f":"E4","v":"2023-05-31"},"2023-06-30","2023-07-31","2023-08-31","2023-09-30","2023-10-31","2023-11-30","2023-12-31","2024-01-31","2024-02-29","2024-03-31","2024-04-30","2024-05-31","2024-06-30","2024-07-31",{"$f":"T4","v":"2024-08-31"},"2024-09-30","2024-10-31","2024-11-30","2024-12-31","2025-01-31","2025-02-28","2025-03-31","2025-04-30","2025-05-31","2025-06-30","2025-07-31"]
[null,"Residential Schedule 001",null,{"$f":"D24*$C$32","v":442839.53083577985},{"$f":"E24*$C$32","v":395134.47948681423},{"$f":"F24*$C$32","v":390035.99486783496},{"$f":"G24*$C$32","v":483260.7851501868},528557.81535063765,399999.62947464298,424474.59597321297,577434.0991028219,727401.91804880148,736924.97638865537,623665.37498626846,549686.52473059832,{"$f":"P24*$C$32","v":443627.11076811526},397784.42254468828,392241.54728935112,{"$f":"S24*$C$32","v":470307.26863191836},{"$f":"T24*$C$32","v":513482.55288101116},399881.72721277497,427017.05439988535,564693.9043630372,729563.03908788797,737306.2913034925,630407.71517074353,560216.87635805749,454941.10064804251,408914.21355990181,398099.45605316607,470001.23616730538]
[null,"General Svc Schedule 011/012",null,{"$f":"D25*$C$32","v":155705.5310857773},{"$f":"E25*$C$32","v":150497.73961125166},153086.92246941902,176952.18068154645,175719.82219314689,157129.17729259783,161221.18492614117,183501.8795390139,206659.62967981247,202671.37800652822,186588.56394223336,176790.80655374104,{"$f":"P25*$C$32","v":154293.15226628186},149626.2651542922,153925.78872189453,177534.93176613323,{"$f":"T25*$C$32","v":176156.67520132486},157097.00229463549,162467.73411351308,184590.98829403037,207069.95339032655,206326.10975343591,188956.25389219026,179869.8813400903,156124.18246881737,152046.69266241128,156326.86709245664,180544.08866418622]
[null,"Large Gen Svc Schedule 021/022",null,{"$f":"D26*$C$32","v":272509.12986789172},{"$f":"E26*$C$32","v":283338.16929731745},290204.30420295004,315684.26400945307,292587.11241748749,274755.4393444715,304024.72859757976,304497.41982426634,293657.32687492005,284454.09802227415,279805.95841908094,273338.92585839372,{"$f":"P26*$C$32","v":265771.87212453695},277153.08708652697,285431.04738989501,308910.82807644171,{"$f":"T26*$C$32","v":286013.43954105541},268505.11425441032,299264.69859029813,299363.04854456522,288773.15401435102,283444.90261581045,276122.32241366844,270554.24154955894,261226.26081578899,273461.28467026626,282812.47553860454,307320.14547163149]
[null,"Extra Large Gen Schedule 25",null,{"$f":"D27*$C$32","v":147342.45051953552},{"$f":"E27*$C$32","v":145966.18379724195},156294.61749291013,153296.72708901894,165702.81718919883,145383.70603209783,151753.46770107563,147565.25150695047,146908.60744230446,158019.25002026834,138583.73503351552,148939.33589729635,{"$f":"P27*$C$32","v":149387.18791365711},145891.51054393835,150440.23512836458,149173.51556695893,{"$f":"T27*$C$32","v":164533.28344940691},145004.73896775697,148981.92001663867,146803.47182117717,145511.77957660865,156423.99835321773,137347.54207723035,146012.34437148657,149307.70033538056,144383.05214556679,149183.76402001167,148493.78427061797]
[null,"Pumping Schedule 31/32",null,{"$f":"D28*$C$32","v":13592.677230318393},{"$f":"E28*$C$32","v":30469.738653682991},49067.962005354639,57524.941701331889,64120.093447399653,51664.131066242589,25741.497879083709,3745.4032809871564,7502.4739947555727,9017.4802711006287,9926.6071738287665,9570.0202852709954,{"$f":"P28*$C$32","v":14279.081069417705},31159.609459129751,50244.110435700386,56748.842591787259,{"$f":"T28*$C$32","v":64174.363675187},50650.860802271389,25894.946492441952,4476.3295989337958,7590.7574324157295,9311.7015620168131,9854.8501477652717,9462.6976852482931,14087.370087481893,30034.031812621186,48525.391834517301,57240.117369747364]
[null,"Street and Area Lights",null,{"$f":"D29*$C$32","v":13919.762114009232},{"$f":"E29*$C$32","v":13949.073994367669},{"$f":"F29*$C$32","v":14054.285906697753},14100.861226199759,14351.927267970434,14382.743951019314,14045.289622826713,14216.346047577241,14307.547640460736,14321.695803512972,13594.068963369622,14468.49735433605,{"$f":"P29*$C$32","v":13815.714948677465},13860.361627010541,14032.784846436045,14045.479045797378,{"$f":"T29*$C$32","v":14035.126727913415},14092.507852728511,13719.506507621441,13928.160549577517,13960.374593750586,14155.900051768223,13350.656175921067,14195.80023939975,13577.032799364319,13612.230399820535,13759.703343839405,13799.37259050996]
[null,"Total",null,{"$f":"SUM(D33:D38)","v":1045909.0816533121},{"$f":"SUM(E33:E38)","v":1019355.3848406757},1052744.0869451666,1200819.759857737,1241039.5878658411,1043314.8271610722,1081260.7646999198,1230960.3993016169,1396437.503681055,1405408.8785123397,1252164.3085182968,1172794.1106796367,{"$f":"SUM(P33:P38)","v":1041174.1190906866},1015475.2564155861,1046315.5138116415,1176720.8656790371,{"$f":"SUM(T33:T38)","v":1218395.441475899},1035231.9513845777,1077345.8601203987,1213855.9031713214,1392469.0580953404,1406968.9036397415,1256039.3398775188,1180311.8415438414,1049263.6471548758,1022451.5052505877,1048707.6578825957,1177398.7445339982,null,{"$f":"SUM(H39:S39)-'WA Electric - Sched 91'!D42","v":236932.41271474026}]

{"sheet":"Billing Determinants","index":3,"n_rows":44,"n_cols":33,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Forecasted Loads"]
[]
[]
[null,null,"2023-04-30","2023-05-31",{"$f":"EOMONTH(D7,1)","v":"2023-06-30"},{"$f":"EOMONTH(E7,1)","v":"2023-07-31"},"2023-08-31","2023-09-30","2023-10-31","2023-11-30","2023-12-31","2024-01-31","2024-02-29","2024-03-31","2024-04-30","2024-05-31","2024-06-30","2024-07-31","2024-08-31","2024-09-30","2024-10-31","2024-11-30","2024-12-31","2025-01-31","2025-02-28","2025-03-31","2025-04-30","2025-05-31","2025-06-30","2025-07-31"]
["WA001/002",null,{"$f":"C32+C33","v":181583684.5377253},{"$f":"D32+D33","v":162022515.32896534},{"$f":"E32+E33","v":159931912.39447597},198158176.60755882,216731951.23623958,164017440.80219781,174053253.52054298,236773377.24326912,298266778.8709479,302171651.63186604,255730233.69181731,225395651.36142737,181906626.94919324,163109108.5320513,160836285.89153969,192846665.11564612,210550430.58599028,163969095.68927413,175095773.297465,231549337.06281796,299152933.54704177,302328007.51787877,258494889.70794377,229713558.67287052,186545860.40999639,167672812.35691783,163238286.12627891,192721178.34528553]
["WA011/013",null,{"$f":"C34+C36","v":45744058.817071795},{"$f":"D34+D36","v":44698709.295613706},{"$f":"E34+E36","v":45773712.591267534},53125016.664973252,52706150.179297067,47055606.379040964,47666034.954919152,53256342.645935602,58790656.21664235,57503111.881636553,53485921.931139447,51010515.921767674,45314465.912237607,44433026.287277289,45974671.999628462,53279591.410267293,52805808.016930513,47013340.035860725,48055574.369914785,53441032.851468794,58952982.175605774,58537190.533821926,54124921.344111301,51771477.726652704,45754040.612441279,45116362.200740583,46634201.491943523,54068754.24772805]
["WA012",null,{"$f":"C35","v":5064376.913087599},{"$f":"D35","v":4410366.5172429327},{"$f":"E35","v":4180242.2051773993},4616435.6570833009,4633169.9473407511,4217380.8432672685,4942219.585167747,6622348.8039218001,8644665.0554123595,8630798.789235767,7399988.7550973222,6678278.2387968879,5033094.9987900192,4391677.7782937083,4253014.1265764944,4652019.0315518631,4676062.0745978225,4249148.1289979313,4959442.947508378,6793046.8225353844,8616232.2582964078,8789299.5000239294,7533592.741712207,6922052.5682011209,5191005.6911524944,4498154.1125278389,4376983.044517478,4844777.3486611713]
["WA021/023",null,{"$f":"C37+C39","v":102035935.70566924},{"$f":"D37+D39","v":106359688.06071614},{"$f":"E37+E39","v":109019411.4295356},118366321.52455275,109552067.64966507,102998331.05504413,113994119.81501397,113839795.7785355,108805971.69920152,105372875.81551027,104193316.90445961,101910431.92482372,99523644.364083499,104041248.34597991,107230126.78375171,115796156.42865363,107057643.35121097,100633533.74618924,112157816.04808588,111856599.22063106,107049815.88650532,104979199.62128271,102777206.46835916,100845351.22217777,97769368.05528526,102613202.21556351,106188299.33237047,115150771.06510961]
["WA022",null,{"$f":"C38","v":2233774.4975537243},{"$f":"D38","v":2053519.2929798481},{"$f":"E38","v":2020973.5793590075},2423417.6667202874,2400047.260242857,2130880.7665769961,2334350.9443000741,2669540.0301297675,3555637.569247325,3467317.4700519154,2868366.5394542208,2676781.7231439715,2168200.2358674454,2005371.4001196711,1983874.9958394058,2401874.3594639832,2379198.1580272391,2104126.6946302424,2349332.4323800378,2688180.7374844542,3442970.5318582002,3474846.9226220381,2875013.523945835,2676363.3504729504,2183196.9319444038,2020829.3788742274,2023762.7022559731,2438619.5122771808]
["WA025/025P",null,{"$f":"C40+C44","v":84867685},{"$f":"D40+D44","v":84074970},{"$f":"E40+E44","v":90024038},88297285,95443061,83739469,87408384,84996016,84617796,91017408,79822758,85787474,86045432,84031959,86651976,85922359,94769422,83521188,85812002,84557239,83813238,90098560,79110724,84101558,85999648,83163103,85928262,85530841]
["WA031",null,{"$f":"C41","v":5669280.3190070223},12685652.335243315,{"$f":"E41","v":20513636.605746172},23243125.848242655,26681374.849876352,21732769.521663133,10999451.058034116,1476234.9872278925,3064442.5273882858,3662899.8908313029,4056846.0333502125,3908471.7938298704,5916364.9560479326,13081620.328505801,21216531.300471239,23397790.192905441,26538200.29671324,21310954.699322864,10998961.340246022,1698030.0474820244,3018969.8403604217,3727782.5560367303,4051859.3441769956,3894478.3527767463,5864287.8556745742,12547469.3318724,20373921.959774412,23385688.858040035]
["WA032",null,354212.91460757988,816784.41806181031,{"$f":"E42","v":1230463.7005029814},2248621.7472331091,1732964.9063617077,1161803.6830888728,407701.16595299018,183512.45898257082,260222.70059058437,333129.03539631527,342055.67903210729,332411.10636197421,411303.00417017506,726527.51160481083,1048770.3844225882,1750034.8878409066,1900188.9049964389,1134595.3677914918,476190.48886738578,285621.92877952754,344817.53260693391,398628.33431683772,315243.77888888761,298845.34004947677,378424.81700648554,761887.19415259198,1129742.4340034137,1979840.965542977]
["WA04X",null,1302576.1267940914,1305319.0584098492,{"$f":"E43","v":1315164.5230185864},1319522.9235993021,1343017.048684244,1345900.7959291809,1314322.6735311958,1330329.7010500454,1338864.1154058825,1340188.064714706,1272098.5856400984,1353925.3824872593,1292839.6562630786,1297017.5794819526,1313152.508189003,1314340.3992536208,1313371.6555335638,1318741.2360407989,1283836.7137207252,1303362.0311496446,1306376.539913778,1324673.3176681858,1249320.6327347257,1328407.0762940696,1270504.384507658,1273798.0869214772,1287598.2319709167,1291310.3797258679]
[null,null,{"$f":"SUM(C8:C16)","v":428855584.83151639},{"$f":"SUM(D8:D16)","v":418427524.30723298},{"$f":"SUM(E8:E16)","v":434009555.02908319},491797923.63996345,511223804.07770759,428399582.84680837,443119837.71746218,501147497.64905238,567345034.7548362,573499380.57924294,509171586.11999029,479053941.45263869,427611972.076653,417117556.76331443,430508403.99041861,481360830.82558286,501990325.04400009,425254723.5981074,441188929.63818824,494172449.70234883,565698336.31218863,573658188.30365109,510532771.54187286,481552092.30949533,430956336.75800854,419667617.87757045,431181057.32311511,481411781.72237045]
[]
["WA001",null,{"$f":"C8","v":181583684.5377253},{"$f":"D8","v":162022515.32896534},159931912.39447597,198158176.60755882,216731951.23623958,164017440.80219781,174053253.52054298,236773377.24326912,298266778.8709479,302171651.63186604,255730233.69181731,225395651.36142737,181906626.94919324,163109108.5320513,160836285.89153969,192846665.11564612,{"$f":"S8","v":210550430.58599028},163969095.68927413,175095773.297465,231549337.06281796,299152933.54704177,302328007.51787877,258494889.70794377,229713558.67287052,186545860.40999639,167672812.35691783,163238286.12627891,192721178.34528553,null,{"$f":"SUM(B19:K19)","v":1791539090.5419228},{"$f":"SUM(B19:R19)","v":3273535313.7154636}]
["WA011/12",null,{"$f":"C9+C10","v":50808435.730159394},{"$f":"D9+D10","v":49109075.812856637},49953954.79644493,57741452.322056554,57339320.126637816,51272987.222308233,52608254.540086895,59878691.449857399,67435321.272054702,66133910.670872316,60885910.686236769,57688794.160564564,50347560.911027625,48824704.065570995,50227686.126204953,57931610.441819154,{"$f":"S9+S10","v":57481870.091528334},51262488.164858654,53015017.317423165,60234079.674004182,67569214.433902174,67326490.033845857,61658514.085823506,58693530.294853821,50945046.30359377,49614516.313268423,51011184.536461003,58913531.596389219,null,496147493.27246261,888187670.334759]
["WA021/22",null,{"$f":"C11+C12","v":104269710.20322296},{"$f":"D11+D12","v":108413207.35369599},111040385.00889461,120789739.19127303,111952114.90990794,105129211.82162112,116328470.75931405,116509335.80866526,112361609.26844884,108840193.28556219,107061683.44391383,104587213.64796768,101691844.59995094,106046619.74609959,109214001.77959111,118198030.78811762,{"$f":"S11+S12","v":109436841.50923821},102737660.44081947,114507148.48046592,114544779.95811552,110492786.41836353,108454046.54390475,105652219.992305,103521714.57265073,99952564.98722966,104634031.59443773,108212062.03462645,117589390.5773868,null,1006793784.3250439,1762433371.6162469]
["WA025",null,{"$f":"C13","v":84867685},{"$f":"D13","v":84074970},90024038,88297285,95443061,83739469,87408384,84996016,84617796,91017408,79822758,85787474,86045432,84031959,86651976,85922359,{"$f":"S13","v":94769422},83521188,85812002,84557239,83813238,90098560,79110724,84101558,85999648,83163103,85928262,85530841,null,783468704,1382748070]
["WA031/32",null,{"$f":"C14+C15","v":6023493.2336146021},{"$f":"D14+D15","v":13502436.753305124},21744100.306249153,25491747.595475763,28414339.756238058,22894573.204752006,11407152.223987106,1659747.4462104633,3324665.2279788703,3996028.926227618,4398901.7123823194,4240882.9001918444,6327667.9602181073,13808147.840110611,22265301.684893828,25147825.080746349,{"$f":"S14+S15","v":28438389.20170968},22445550.067114357,11475151.829113407,1983651.976261552,3363787.3729673554,4126410.8903535679,4367103.1230658833,4193323.6928262231,6242712.6726810597,13309356.526024992,21503664.393777825,25365529.823583011,null,134462255.74781114,214647011.8525818]
["WA04X",null,{"$f":"C16","v":1302576.1267940914},{"$f":"D16","v":1305319.0584098492},1315164.5230185864,1319522.9235993021,1343017.048684244,1345900.7959291809,1314322.6735311958,1330329.7010500454,1338864.1154058825,1340188.064714706,1272098.5856400984,1353925.3824872593,1292839.6562630786,1297017.5794819526,1313152.508189003,1314340.3992536208,{"$f":"S16","v":1313371.6555335638},1318741.2360407989,1283836.7137207252,1303362.0311496446,1306376.539913778,1324673.3176681858,1249320.6327347257,1328407.0762940696,1270504.384507658,1273798.0869214772,1287598.2319709167,1291310.3797258679,null,11915016.966422375,21098579.142452095]
["Total",null,{"$f":"SUM(C19:C24)","v":428855584.83151639},{"$f":"SUM(D19:D24)","v":418427524.30723298},{"$f":"SUM(E19:E24)","v":434009555.02908325},491797923.63996345,511223804.07770759,428399582.84680837,443119837.71746218,501147497.64905226,567345034.7548362,573499380.57924283,509171586.11999029,479053941.45263869,427611972.076653,417117556.76331443,430508403.99041861,481360830.82558286,501990325.04400009,425254723.5981074,441188929.63818824,494172449.70234883,565698336.31218863,573658188.30365109,510532771.54187286,481552092.30949533,430956336.75800848,419667617.87757045,431181057.32311511,481411781.72237045,null,4224326344.8536625,7542650016.6615028]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C32:C44)-C17","v":0},{"$f":"SUM(D32:D44)-D17","v":0},{"$f":"SUM(E32:E44)-E17","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["WA_1",null,180715613.01082048,161321283.90873438,159319735.32611519,197442822.07256678,215964347.43382889,163391526.49107701,173248744.32296532,235502311.9539113,296641772.79846901,300497880.48562527,254319298.08319306,224138226.68638775,180941546.84277141,162327132.18002027,160154659.35601419,192076001.7725718,209723941.98490033,163276388.28570613,174203489.99225754,230177966.61938715,297354902.13615584,300481615.63123482,256923101.76132482,228302756.26494545,185453542.06451172,166783498.90247539,162471694.91910702,191871355.5321821]
["WA_2",null,868071.5269048122,701231.42023094965,612177.06836078654,715354.53499203478,767603.80241069314,625914.31112080265,804509.19757766975,1271065.2893578052,1625006.0724788732,1673771.1462407915,1410935.6086242364,1257424.6750396215,965080.10642182571,781976.35203102161,681626.53552548971,770663.34307433187,826488.60108994122,692707.40356801008,892283.30520746368,1371370.4434308116,1798031.4108859051,1846391.8866439541,1571787.9466189337,1410802.4079250772,1092318.3454846658,889313.45444245136,766591.20717189473,849822.81310343137]
["WA_11",null,45729902.624365315,44683753.748157345,45758736.455357552,53109995.09978269,52690979.026777737,47040434.802319512,47650785.261439428,53241542.30516015,58775783.453839511,57488164.673747778,53470920.199419357,50995486.676600583,45299434.44646962,44417998.907250829,45959655.885884635,53264593.980985068,52790839.255851857,46998351.691999637,48040573.559022807,53426026.12620078,58937974.741478227,58522185.612148918,54109919.363892496,51756478.544229575,45739043.330160446,45101364.930339366,46619201.050529264,54053752.465834603]
["WA_12",null,5064376.913087599,4410366.5172429327,4180242.2051773993,4616435.6570833009,4633169.9473407511,4217380.8432672685,4942219.585167747,6622348.8039218001,8644665.0554123595,8630798.789235767,7399988.7550973222,6678278.2387968879,5033094.9987900192,4391677.7782937083,4253014.1265764944,4652019.0315518631,4676062.0745978225,4249148.1289979313,4959442.947508378,6793046.8225353844,8616232.2582964078,8789299.5000239294,7533592.741712207,6922052.5682011209,5191005.6911524944,4498154.1125278389,4376983.044517478,4844777.3486611713]
["WA_13",null,14156.192706481061,14955.547456357652,14976.135909979357,15021.565190560295,15171.152519330233,15171.576721452222,15249.693479725467,14800.340775449076,14872.76280284112,14947.207888777773,15001.731720092279,15029.245167094754,15031.465767987291,15027.380026457709,15016.113743829746,14997.429282225816,14968.761078658319,14988.343861088579,15000.810891982092,15006.725268012968,15007.434127543795,15004.921673008335,15001.980218805953,14999.182423130334,14997.282280830279,14997.270401219697,15000.441414261097,15001.781893447898]
["WA_21",null,102004250.1949463,106325839.4657533,108987481.8309983,118334568.4293232,109520059.87731317,102966272.41617309,113962274.07070746,113806679.99331298,108773700.17452888,105340641.69095209,104161136.78194897,101878153.70752978,99491399.95267044,104009059.30394998,107197902.98717341,115763892.11629774,107025347.01337987,100601208.2266814,112125568.08917053,111824349.59443142,107017564.44766031,104946943.61542274,102744951.89487113,100813095.00560072,97737105.343455806,102580935.95575225,106156032.6654425,115118507.29689884]
["WA_22",null,2233774.4975537243,2053519.2929798481,2020973.5793590075,2423417.6667202874,2400047.260242857,2130880.7665769961,2334350.9443000741,2669540.0301297675,3555637.569247325,3467317.4700519154,2868366.5394542208,2676781.7231439715,2168200.2358674454,2005371.4001196711,1983874.9958394058,2401874.3594639832,2379198.1580272391,2104126.6946302424,2349332.4323800378,2688180.7374844542,3442970.5318582002,3474846.9226220381,2875013.523945835,2676363.3504729504,2183196.9319444038,2020829.3788742274,2023762.7022559731,2438619.5122771808]
["WA_23",null,31685.510722929688,33848.594962835617,31929.598537300139,31753.095229550323,32007.772351903888,32058.638871043197,31845.744306512996,33115.785222522187,32271.524672647713,32234.124558181371,32180.122510648922,32278.217293927126,32244.411413059857,32189.04202992783,32223.796578307669,32264.312355892445,32296.337831088167,32325.51950784291,32247.95891534823,32249.626199643895,32251.438845003402,32256.005859970639,32254.573488031259,32256.216577048945,32262.711829452863,32266.259811256212,32266.666927972023,32263.768210768718]
["WA_25",null,47749334,49004982,54326500,51917113,58885543,49947496,50764195,49541955,49979591,55440542,48854215,52560911,49147173,49713670,52029033,51512338,58011555,50365851,50452671,49586033,49714103,54926927,49057508,51207377,49361216,49414639,51618075,51429669]
["WA_31",null,5669280.3190070223,12685652.335243315,20513636.605746172,23243125.848242655,26681374.849876352,21732769.521663133,10999451.058034116,1476234.9872278925,3064442.5273882858,3662899.8908313029,4056846.0333502125,3908471.7938298704,5916364.9560479326,13081620.328505801,21216531.300471239,23397790.192905441,26538200.29671324,21310954.699322864,10998961.340246022,1698030.0474820244,3018969.8403604217,3727782.5560367303,4051859.3441769956,3894478.3527767463,5864287.8556745742,12547469.3318724,20373921.959774412,23385688.858040035]
["WA_32",null,354212.91460757988,816784.41806181031,1230463.7005029814,2248621.7472331091,1732964.9063617077,1161803.6830888728,407701.16595299018,183512.45898257082,260222.70059058437,333129.03539631527,342055.67903210729,332411.10636197421,411303.00417017506,726527.51160481083,1048770.3844225882,1750034.8878409066,1900188.9049964389,1134595.3677914918,476190.48886738578,285621.92877952754,344817.53260693391,398628.33431683772,315243.77888888761,298845.34004947677,378424.81700648554,761887.19415259198,1129742.4340034137,1979840.965542977]
["WA_4X",null,1302576.1267940914,1305319.0584098492,1315164.5230185864,1319522.9235993021,1343017.048684244,1345900.7959291809,1314322.6735311958,1330329.7010500454,1338864.1154058825,1340188.064714706,1272098.5856400984,1353925.3824872593,1292839.6562630786,1297017.5794819526,1313152.508189003,1314340.3992536208,1313371.6555335638,1318741.2360407989,1283836.7137207252,1303362.0311496446,1306376.539913778,1324673.3176681858,1249320.6327347257,1328407.0762940696,1270504.384507658,1273798.0869214772,1287598.2319709167,1291310.3797258679]
["WA_25P",null,37118351,35069988,35697538,36380172,36557518,33791973,36644189,35454061,34638205,35576866,30968543,33226563,36898259,34318289,34622943,34410021,36757867,33155337,35359331,34971206,34099135,35171633,30053216,32894181,36638432,33748464,34310187,34101172]

{"sheet":"WA Electric - Sched 91","index":4,"n_rows":55,"n_cols":12,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[null,""]
[]
[null,null," ","RESIDENTIAL","GENERAL SVC. ","LG. GEN. SVC.","EX LG GEN SVC","PUMPING","ST & AREA LTG"]
["Source",null,"TOTAL","SCHEDULE 1,2","SCH. 11,12,13","SCH. 21,22,23","SCHEDULE 25","SCH. 30, 31, 32","SCH. 41-48"]
[]
["Forecast","Total Annual Forecasted kWh's",{"$f":"SUM(D7:I7)","v":5769559428.8537073},{"$f":"SUM('Billing Determinants'!$G19:$R19)","v":2571839024.8467379},{"$f":"SUM('Billing Determinants'!G20:R20)","v":680574751.6732415},{"$f":"SUM('Billing Determinants'!G21:R21)","v":1317920329.8591602},{"$f":"SUM('Billing Determinants'!G22:R22)","v":1035484092},{"$f":"SUM('Billing Determinants'!G23:R23)","v":147885233.96393716},{"$f":"SUM('Billing Determinants'!G24:R24)","v":15855996.510630269},null,null,"August 2021 - July 2022"]
[]
[null,"Present DSM Rates",null,2.5519921155876982E-3,3.2068451271835556E-3,2.7348446453900189E-3,1.8167505621790386E-3,2.3613825413033489E-3,1.1182488739420801E-2]
[]
[null,"Present Annual DSM Revenue",{"$f":"SUM(D11:I11)","v":14757857.515522966},{"$f":"D7*D9","v":6563312.9139696294},{"$f":"E7*E9","v":2182497.826087493},3604307.3571659718,1881216.3062684513,349213.60959900229,{"$f":"I7*I9","v":177309.50243241849}]
[]
["UE-190334","Base Revenue",{"$f":"SUM(D13:I13)","v":530520000},{"$f":"ROUND('Base Revenue'!F14*1000,-3)","v":230654000},{"$f":"ROUND('Base Revenue'!F16*1000,-3)","v":77192000},{"$f":"ROUND('Base Revenue'!F18*1000,-3)","v":132812000},{"$f":"ROUND('Base Revenue'!F20*1000,-3)","v":70533000},{"$f":"ROUND('Base Revenue'!F22*1000,-3)","v":12723000},{"$f":"ROUND('Base Revenue'!F24*1000,-3)","v":6606000}]
[]
[null,"Percentage of Current Base Volumetric Revenue",{"$f":"SUM(D15:I15)","v":1},{"$f":"D13/$C$13","v":0.43476965995626932},{"$f":"E13/$C$13","v":0.14550252582372011},{"$f":"F13/$C$13","v":0.25034305963959891},{"$f":"G13/$C$13","v":0.13295068988916534},2.3982130739651664E-2,{"$f":"I13/$C$13","v":1.2451933951594663E-2}]
[]
[null,"Revenue Requirement ",14509924.565760205]
[]
[null,"Revenue Spread Based on Current Allocation",{"$f":"SUM(D19:I19)","v":14509924.565760206},{"$f":"$C$17*D15","v":6308474.9694466833},{"$f":"$C$17*E15","v":2111230.6738297548},{"$f":"$C$17*F15","v":3632458.9109321884},{"$f":"$C$17*G15","v":1929104.4812575669},347978.90795854462,{"$f":"$C$17*I15","v":180676.62233546693}]
[]
[null,"DSM Revenue Increase <Decrease> ",{"$f":"C19-C11","v":-247932.94976275973},{"$f":"D19-D11","v":-254837.94452294614},{"$f":"E19-E11","v":-71267.152257738169},{"$f":"F19-F11","v":28151.553766216617},{"$f":"G19-G11","v":47888.17498911568},{"$f":"H19-H11","v":-1234.7016404576716},3367.1199030484422]
[]
[null,"Proposed DSM Rates",null,2.5519921155876982E-3,3.2068451271835556E-3,2.7348446453900189E-3,1.8167505621790386E-3,2.3613825413033489E-3,1.1182488739420801E-2]
[]
[null,"Percentage Increase <Decrease>",{"$f":"C19/C11-1","v":-1.6800063932178033E-2},{"$f":"D19/D11-1","v":-3.8827639008424897E-2},{"$f":"E19/E11-1","v":-3.2653939630948869E-2},{"$f":"F19/F11-1","v":7.8105308389548878E-3},{"$f":"G19/G11-1","v":2.5455964223543237E-2},-3.5356630054466098E-3,{"$f":"I19/I11-1","v":1.8990070226674982E-2}]
[]
[null,"Present Billed Revenue",{"$f":"SUM(D27:I27)","v":540240000},231769000,{"$f":"81602000+1000","v":81603000},139808000,{"$f":"43524000+23860000","v":67384000},12812000,6864000]
[]
[null,"Proposed Billed Revenue",{"$f":"SUM(D29:I29)","v":539992067.0502373},{"$f":"D21+D27","v":231514162.05547705},{"$f":"E21+E27","v":81531732.84774226},139836151.55376622,{"$f":"G21+G27","v":67431888.174989119},{"$f":"H21+H27","v":12810765.298359543},{"$f":"I21+I27","v":6867367.1199030485}]
[]
[null,"Overall Billed Percentage Increase <Decrease>",{"$f":"C29/C27-1","v":-4.5893112276529369E-4},{"$f":"D29/D27-1","v":-1.0995342108864881E-3},{"$f":"E29/E27-1","v":-8.7333985585991147E-4},{"$f":"F29/F27-1","v":2.0135867594284207E-4},{"$f":"G29/G27-1","v":7.1067575372674163E-4},-9.6370718112415155E-5,4.9054777142321093E-4]
[]
[null,null,null,{"$f":"D23-D9","v":0},0,0,0,0,0]
[null,"Present DSM Revenue as a Percentage of Billed Revenue",{"$f":"C11/C27","v":2.7317224780695554E-2}]
[]
[null,"Percentage DSM Decrease",{"$f":"C21/C11","v":-1.6800063932178023E-2}]
[]
[null,null,"Present","Proposed","Change"]
[null,"Gross DSM Revenue",{"$f":"C11","v":14757857.515522966},{"$f":"C19","v":14509924.565760206},{"$f":"D39-C39","v":-247932.94976275973}]
[null,"Revenue Conversion Factor",{"$f":"'Rev Conv Factor'!E22","v":0.95563100000000001},{"$f":"'Rev Conv Factor'!E22","v":0.95563100000000001}]
[]
[null,"Net DSM Revenue ",{"$f":"C39*C40","v":14103066.135416728},{"$f":"D39*D40","v":13866133.722701993},{"$f":"D42-C42","v":-236932.41271473467}]
[]
[null,null,"Present","Proposed","$ Change","% Change"]
[null,"Average Monthly Bill @ 914 kWh's - Increase <Decrease>",{"$f":"9+(800*0.08076)+(114*0.094)","v":84.323999999999998},{"$f":"9+(800*(0.08076+(D23-D9))+(114*(0.094+(ROUND(D23,5)-D9))))","v":84.323772898823009},{"$f":"D45-C45","v":-2.271011769892084E-4},{"$f":"E45/C45","v":-2.6931973932594327E-6}]
[]
[null,null,"Present","Change","Proposed"]
[null,"Basic Charge",9,0,{"$f":"C48+D48","v":9}]
[null,"First 800 kWh's",8.0759999999999998E-2,{"$f":"ROUND($D$23,5)-ROUND($D$9,5)","v":0},{"$f":"C49+D49","v":8.0759999999999998E-2}]
[null,"801 - 1500 kWh's",9.4E-2,{"$f":"ROUND($D$23,5)-ROUND($D$9,5)","v":0},{"$f":"C50+D50","v":9.4E-2}]
[null,"Over 1500 kWh's",0.11026,{"$f":"ROUND($D$23,5)-ROUND($D$9,5)","v":0},0.11026]
[]
[null,null,{"$f":"C48+(800*C49)+(114*C50)","v":84.323999999999998},{"$f":"914*D49","v":0},{"$f":"E48+(800*E49)+(114*E50)","v":84.323999999999998}]
[]
[null,null,null,null,{"$f":"D53/C53","v":0}]

{"sheet":"Rev Conv Factor","index":5,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[31,0,31,4],[32,0,32,4],[33,0,33,4]]}
["AVISTA UTILITIES"]
["Revenue Conversion Factor"]
["Washington - Electric System"]
["TWELVE MONTHS ENDED DECEMBER 31, 2018"]
[]
["Line "]
["No.",null,"Description",null,"Factor"]
[]
[1,null,"Revenues",null,1]
[]
[null,null,"Expense:"]
[2,null,"  Uncollectibles",null,3.7820000000000002E-3]
[]
[3,null,"  Commission Fees",null,2E-3]
[]
[4,null,"  Washington Excise Tax",null,3.8587000000000003E-2]
[]
[5,null,"  Franchise Fees",null,0]
[]
[6,null,"    Total Expense",null,{"$f":"E12+E14+E16+E18","v":4.4369000000000006E-2}]
[]
[7,null,"Net Operating Income Before FIT",null,{"$f":"E9-E20","v":0.95563100000000001}]
[]
[8,null,"  Federal Income Tax @ 21%",null,0.200683]
[]
[9,null,"REVENUE CONVERSION FACTOR",null,{"$f":"E22-E24","v":0.75494799999999995}]
[]
[]
["Source:  UE-190334"]

{"sheet":"Base Revenue","index":6,"n_rows":54,"n_cols":16,"rows_kept":54,"cut":false,"hidden":false,"merged":[[4,0,4,13],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13]]}
["AVISTA UTILITIES"]
["WASHINGTON ELECTRIC"]
["PROPOSED INCREASE BY SERVICE SCHEDULE"]
["12 MONTHS ENDED DECEMBER 31, 2018"]
["(000s of Dollars)"]
["Source:  UE-190334 Compliance Filing, Attachment 1, Page 1"]
[]
[null,null,null,"Base Tariff",null,"Base Tariff","Base","Total Billed",null,"Adjusted Billed","Base ","Sch 94","Sch 93","Sch 92",null,"Percent"]
[null,null,null,"Revenue","Settlement","Revenue","Tariff","Revenue","Misc","Revenue","Rate","Remand","ERM","LIRAP","Total","Increase"]
[null,"Type of","Schedule","Under Present","General","Under Proposed","Percent","at Present","Rate Adjustment","at Present","General","Rate ","Rate ","Rate ","Net ","on Billed"]
["No.","Service","Number","Rates(1)","Increase","Rates(1)","Increase","Rates (2)","Change","Rates (2)","Increase","Adjustment","Adjustment","Adjustment","Impact","Revenue"]
[null,"(a)","(b)","(c)","(d)","(e)","(f)","(g)","(h)","(h)","(h)","(i)","(j)","(k)","(l)","(m)"]
[null,null,null,""]
[1,"Residential","1/2",216074.59747000004,14579.226899999976,230654.32437000002,6.7473118407748819E-2,222667.75594,0,222667.75594,14579.226899999976,-2117.1905532156261,-10071.607,186.61596243145408,2577.0453092158032,1.1573500160976217E-2]
[]
[2,"General Service","11/12",75060.953438333352,2130.6787616666556,77191.632200000007,2.8385980514051477E-2,80649.815498333293,0,80649.815498333293,2130.6787616666556,-735.47905860179446,-2657.6509999999998,70.739078580032555,-1191.712218355106,-1.4776378730584124E-2]
[]
[3,"Large General Service","21/22",125677.26809166667,7134.5849183333366,132811.85301000002,5.6769096167252002E-2,136457.84604166701,0,136457.84604166701,7134.5849183333366,-1231.4391782891898,-5999.64,112.42674172875867,15.932481772905149,1.1675753527606035E-4]
[]
[4,"Extra Large General Service",25,66743.707566132012,3789.0483572379949,70532.955923369998,5.6770121040753879E-2,69318.742446132004,0,69318.742446132004,3789.0483572379949,-653.98315581830707,-4606.2539999999999,36.144305132901806,-1435.0444934474106,-2.0702113783477707E-2]
[]
[5,"Pumping Service","30/31/32",12038.755110000002,683.68078999999909,12722.635900000001,5.6789990638824367E-2,13072.634169999999,0,13072.634169999999,683.68078999999909,-117.96082875918428,-569.25400000000002,10.420922422142896,6.8868836629576453,5.2681682768742591E-4]
[]
[6,"Street & Area Lights","41-48",6424.0192802760002,181.62788032399865,6605.6471605999986,2.827324645205536E-2,6754.2403540559199,0,6754.2403540559199,181.62788032399865,-62.945265631068672,-98.593999999999994,6.091969332329648,26.180584025259627,3.8761700284382374E-3]
[]
[7,"Total",null,502019.50095640816,28499.647607561961,530519.54856397014,5.677000107220271E-2,528921.03445018816,0,528921.03445018816,28499.647607561961,-4918.9980403151703,-24003.000000000004,422.43897962761963,8.8546874405949438E-2,1.6741038574499812E-7]
[null,null,null,0]
[]
[]
[]
["(1) Excludes all present rate adjustments:  Schedule 59 (BPA Residential Exchange), Schedule 75 (Decoupling),"]
["      Schedule 91 (DSM), Schedule 92 (LIRAP), Schedule 93 (ERM), and Schedule 98 (REC Revenue)."]
[]
["(2) Includes all present rate adjustments:  Schedule 59 (BPA Residential Exchange), Schedule 75 (Decoupling),  "]
["     Schedule 91 (DSM), Schedule 92 (LIRAP), Schedule 93 (ERM), and Schedule 98 (REC Revenue)."]
[]
[]
[null,"reduce billed revenue for BPA ResEx (already accounted for in Schs 1 & 48)"]
[null,null,null,null,null,"Billing",null,null,"Billed Revenue"]
[null,null,null,null,null,"Determinants",null,"Sch 59 Rate","Impact"]
[null,"Schedule 12 only",null,null,null,{"$f":"'[3]Rev Runs 12MESEPT2014'!P49+'[3]Rev Runs 12MESEPT2014'!P81+'[3]Rev Runs 12MESEPT2014'!P90","v":57963673},null,-2.7E-4,{"$f":"F41*H41","v":-15650.191710000001}]
[null,"Schedule 22 only",null,null,null,{"$f":"'[3]Rev Runs 12MESEPT2014'!P51+'[3]Rev Runs 12MESEPT2014'!P83+'[3]Rev Runs 12MESEPT2014'!P92","v":36956089},null,-2.7E-4,{"$f":"F42*H42","v":-9978.1440299999995}]
[null,"Schedule 32 only",null,null,null,{"$f":"'[3]Rev Runs 12MESEPT2014'!P55+'[3]Rev Runs 12MESEPT2014'!P86+'[3]Rev Runs 12MESEPT2014'!P95","v":8649684},null,-2.7E-4,{"$f":"F43*H43","v":-2335.4146799999999}]
[]
[null,"Total",null,null,null,{"$f":"SUM(F41:F44)","v":103569446},null,null,{"$f":"SUM(I41:I44)","v":-27963.750420000004},"Manually deducted in Column H"]
[]
[]
[null,null,null,null,null,null,null,null,null,"ERM Reduction Calc",null,0,1,{"$f":"-D14*$L$49","v":0},null,{"$f":"0/'[3]Pres & Prop Rev'!D23","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L48/D26","v":0},11,{"$f":"-D16*L49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,21,{"$f":"-D18*L49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,25,{"$f":"-D20*L49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,31,{"$f":"-D22*L49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"41-48",{"$f":"-D24*L49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N48:N53)","v":0}]