{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["WA Electric - Sched 91","DSM Balance","Expense Budget","Revenue By Month","Billing Determinants","Rev Conv Factor","Base Revenue"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":3,"defined_names":7,"comments":3,"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":"WA Electric - Sched 91","index":0,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[null,""]
[]
[null,null," ","RESIDENTIAL","GENERAL SVC. ","LG. GEN. SVC.","EX LG GEN SVC","EX LG GEN SVC","PUMPING","ST & AREA LTG"]
["Source",null,"TOTAL","SCHEDULE 1,7,8","SCH. 11,12,13,17,18","SCH. 21,22,23","SCHEDULE 25","SCHEDULE 25I","SCH. 30, 31, 32","SCH. 41-48"]
[]
["Forecast","Total Annual Forecasted kWh's",{"$f":"SUM(D7:J7)","v":5835774811.5728216},{"$f":"SUM('Billing Determinants'!$G20:$R20)","v":2655150579.1460719},{"$f":"SUM('Billing Determinants'!G21:R21)","v":684568236.31373823},{"$f":"SUM('Billing Determinants'!G22:R22)","v":1277870455.3854325},{"$f":"SUM('Billing Determinants'!G23:R23)","v":620814991},{"$f":"SUM('Billing Determinants'!G24:R24)","v":433183452},{"$f":"SUM('Billing Determinants'!G25:R25)","v":148427613.11264831},{"$f":"SUM('Billing Determinants'!G26:R26)","v":15759484.614931053}]
[]
[null,"Present DSM Rates",null,2.5519921155876982E-3,3.2068451271835556E-3,2.7348446453900189E-3,1.8167505621790386E-3,1.8167505621790386E-3,2.3613825413033489E-3,1.1182488739420801E-2]
[]
[null,"Present Annual DSM Revenue",{"$f":"SUM(D11:J11)","v":14907581.726292349},{"$f":"D7*D9","v":6775923.3436788861},{"$f":"E7*E9","v":2195304.3128473521},3494777.1724129552,1127865.9839084249,{"$f":"H7*H9","v":786986.27994765656},350494.37425153574,{"$f":"J7*J9","v":176230.25924554185}]
[]
["UE-220053","Base Revenue",{"$f":"SUM(D13:J13)","v":600708000},{"$f":"ROUND('Base Revenue'!D14*1000,-3)","v":285802000},{"$f":"ROUND('Base Revenue'!D16*1000,-3)","v":86753000},{"$f":"ROUND('Base Revenue'!D18*1000,-3)","v":139487000},{"$f":"ROUND('Base Revenue'!D20*1000,-3)","v":42461000},{"$f":"ROUND('Base Revenue'!D22*1000,-3)","v":22430000},{"$f":"ROUND('Base Revenue'!D24*1000,-3)","v":16438000},{"$f":"ROUND('Base Revenue'!D26*1000,-3)","v":7337000}]
[]
[null,"Percentage of Current Base Volumetric Revenue",{"$f":"SUM(D15:J15)","v":1},{"$f":"D13/$C$13","v":0.47577525186946068},{"$f":"E13/$C$13","v":0.14441792018751207},{"$f":"F13/$C$13","v":0.23220433222131218},{"$f":"G13/$C$13","v":7.0684925121689737E-2},{"$f":"H13/$C$13","v":3.7339272991203716E-2},2.7364376702158119E-2,{"$f":"J13/$C$13","v":1.221392090666347E-2}]
[]
[null,"Revenue Requirement ",27768930.428209543]
[]
[null,"Revenue Spread Based on Current Allocation",{"$f":"SUM(D19:J19)","v":27768930.42820954},{"$f":"$C$17*D15","v":13211769.868626926},{"$f":"$C$17*E15","v":4010331.1782737412},{"$f":"$C$17*F15","v":6448065.9465824738},{"$f":"$C$17*G15","v":1962844.7680274034},{"$f":"$C$17*H15","v":1036871.6739326597},759879.47285354696,{"$f":"$C$17*J15","v":339167.5199127919}]
[]
[null,"DSM Revenue Increase <Decrease> ",{"$f":"C19-C11","v":12861348.70191719},{"$f":"D19-D11","v":6435846.52494804},{"$f":"E19-E11","v":1815026.865426389},{"$f":"F19-F11","v":2953288.7741695186},{"$f":"G19-G11","v":834978.78411897854},{"$f":"H19-H11","v":249885.39398500312},{"$f":"I19-I11","v":409385.09860201122},162937.26066725006]
[]
[null,"Proposed DSM Rates",null,{"$f":"D19/D7","v":4.975902298119751E-3},{"$f":"E19/E7","v":5.8581905579910701E-3},5.0459464959126876E-3,3.1617225686926161E-3,{"$f":"H19/H7","v":2.3936086873712335E-3},5.1195290210376198E-3,2.1521485518089436E-2]
[]
[null,"Percentage Increase <Decrease>",{"$f":"C19/C11-1","v":0.86273876863836074},{"$f":"D19/D11-1","v":0.94981099969967975},{"$f":"E19/E11-1","v":0.82677688683272521},{"$f":"F19/F11-1","v":0.84505781870219554},{"$f":"G19/G11-1","v":0.74031737460997249},{"$f":"H19/H11-1","v":0.31752191918977712},{"$f":"I19/I11-1","v":1.1680218818810824},{"$f":"J19/J11-1","v":0.92457028301949751}]
[]
[null,"Present Billed Revenue",{"$f":"SUM(D27:J27)","v":619206000},275353000,99093000,146773000,52386000,22792000,15300000,7509000]
[]
[null,"Proposed Billed Revenue",{"$f":"SUM(D29:J29)","v":632067348.70191717},{"$f":"D21+D27","v":281788846.52494806},{"$f":"E21+E27","v":100908026.86542639},149726288.7741695,{"$f":"G21+G27","v":53220978.78411898},{"$f":"H21+H27","v":23041885.393985003},{"$f":"I21+I27","v":15709385.098602012},{"$f":"J21+J27","v":7671937.2606672505}]
[]
[null,"Overall Billed Percentage Increase <Decrease>",{"$f":"C29/C27-1","v":2.0770710719723695E-2},{"$f":"D29/D27-1","v":2.3373075742585181E-2},{"$f":"E29/E27-1","v":1.8316398387639765E-2},{"$f":"F29/F27-1","v":2.0121471756859188E-2},{"$f":"G29/G27-1","v":1.593896812352491E-2},{"$f":"H29/H27-1","v":1.096373262482464E-2},2.6757195987059612E-2,2.1698929373718201E-2]
[]
[null,null,null,{"$f":"D23-D9","v":2.4239101825320529E-3},{"$f":"E23-E9","v":2.6513454308075145E-3},2.3111018505226687E-3,1.3449720065135775E-3,{"$f":"H23-H9","v":5.7685812519219491E-4},2.7581464797342709E-3,1.0338996778668634E-2]
[null,"Present DSM Revenue as a Percentage of Billed Revenue",{"$f":"C11/C27","v":2.4075318595576187E-2}]
[]
[null,"Percentage DSM Decrease",{"$f":"C21/C11","v":0.86273876863836074}]
[]
[null,null,"Present","Proposed","Change"]
[null,"Gross DSM Revenue",{"$f":"C11","v":14907581.726292349},{"$f":"C19","v":27768930.42820954},{"$f":"D39-C39","v":12861348.70191719}]
[null,"Revenue Conversion Factor",{"$f":"'Rev Conv Factor'!E22","v":0.95606900000000006},{"$f":"'Rev Conv Factor'!E22","v":0.95606900000000006}]
[]
[null,"Net DSM Revenue ",{"$f":"C39*C40","v":14252676.753474601},{"$f":"D39*D40","v":26549013.545567866},{"$f":"D42-C42","v":12296336.792093266}]
[]
[]
[null,"Average Monthly Bill @ 945 kWh's - Increase <Decrease>"]
[]
[null,null,"Present","Change","Proposed"]
[null,"Basic Charge",9,0,{"$f":"C48+D48","v":9}]
[null,"First 800 kWh's",9.0959999999999999E-2,{"$f":"ROUND($D$23,5)-ROUND($D$9,5)","v":2.4299999999999999E-3},{"$f":"C49+D49","v":9.3390000000000001E-2}]
[null,"801 - 1500 kWh's",0.10682,{"$f":"ROUND($D$23,5)-ROUND($D$9,5)","v":2.4299999999999999E-3},{"$f":"C50+D50","v":0.10925}]
[null,"Over 1500 kWh's",0.12634999999999999,{"$f":"ROUND($D$23,5)-ROUND($D$9,5)","v":2.4299999999999999E-3},0.12877999999999998]
[]
[null,null,{"$f":"C48+ROUND((800*C49),2)+ROUND((145*C50),2)","v":97.259999999999991},{"$f":"D48+ROUND((800*D49),2)+ROUND((145*D50),2)","v":2.29},{"$f":"E48+ROUND((800*E49),2)+ROUND((145*E50),2)","v":99.55}]
[]
[null,null,null,null,{"$f":"D53/C53","v":2.3545136746864079E-2}]

{"sheet":"DSM Balance","index":1,"n_rows":34,"n_cols":30,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,null,2024,2024,2024,2024,2024,2024,2024,2024,2024,2025,2025,2025,2025,2025,2025,2025,2025,2025,2025,2025,2025,2026,2026,2026,2026,2026,2026,2026]
[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","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'!D43","v":-1032993.9660098555},{"$f":"-'Revenue By Month'!E43","v":-1048699.9530858207},{"$f":"-'Revenue By Month'!F43","v":-1089742.1903370565},{"$f":"-'Revenue By Month'!G43","v":-1214358.868045903},{"$f":"-'Revenue By Month'!H43","v":-2271875.4645198579},{"$f":"-'Revenue By Month'!I43","v":-1892066.9548922968},{"$f":"-'Revenue By Month'!J43","v":-2003292.8429196},{"$f":"-'Revenue By Month'!K43","v":-2319050.8189272122},{"$f":"-'Revenue By Month'!L43","v":-2654831.0867051962},{"$f":"-'Revenue By Month'!M43","v":-2753597.2512121131},{"$f":"-'Revenue By Month'!N43","v":-2247616.1510958401},{"$f":"-'Revenue By Month'!O43","v":-2220932.0901900497},{"$f":"-'Revenue By Month'!P43","v":-1997141.8497797216},{"$f":"-'Revenue By Month'!Q43","v":-1940526.8290982877},{"$f":"-'Revenue By Month'!R43","v":-1999698.071325449},{"$f":"-'Revenue By Month'!S43","v":-2248384.1349022477},{"$f":"-'Revenue By Month'!T43","v":-2278195.4387134979},{"$f":"-'Revenue By Month'!U43","v":-1903078.2424014155},{"$f":"-'Revenue By Month'!V43","v":-2012693.1554579367},{"$f":"-'Revenue By Month'!W43","v":-2305803.1726092715},{"$f":"-'Revenue By Month'!X43","v":-2660347.7498422647},{"$f":"-'Revenue By Month'!Y43","v":-2767664.1955377404},{"$f":"-'Revenue By Month'!Z43","v":-2263507.3075683983},{"$f":"-'Revenue By Month'!AA43","v":-2236310.0313828508},{"$f":"-'Revenue By Month'!AB43","v":-2007388.2902151842},{"$f":"-'Revenue By Month'!AC43","v":-1947455.5314050049},{"$f":"-'Revenue By Month'!AD43","v":-2006051.6329357538},{"$f":"-'Revenue By Month'!AE43","v":-2255143.4480015901}]
["Expected DSM expenditures (from \"Expense Budget\" tab)",null,{"$f":"'Expense Budget'!H61","v":1204925.3607035931},{"$f":"'Expense Budget'!I61","v":1877314.6092249621},{"$f":"'Expense Budget'!J61","v":1274653.3542297105},{"$f":"'Expense Budget'!K61","v":1284619.415044565},{"$f":"'Expense Budget'!L61","v":1536876.7375657132},{"$f":"'Expense Budget'!M61","v":1465404.2603659618},{"$f":"'Expense Budget'!N61","v":1923700.9835994025},{"$f":"'Expense Budget'!O61","v":1844333.0897880599},{"$f":"'Expense Budget'!P61","v":3652115.0380379274},{"$f":"'Expense Budget'!E62","v":2270474.043127039},{"$f":"'Expense Budget'!F62","v":1736065.1285394144},{"$f":"'Expense Budget'!G62","v":1247437.2356861094},{"$f":"'Expense Budget'!H62","v":1187985.3965608894},{"$f":"'Expense Budget'!I62","v":1850921.5701189756},{"$f":"'Expense Budget'!J62","v":1256733.0889425564},{"$f":"'Expense Budget'!K62","v":1266559.0375825381},{"$f":"'Expense Budget'!L62","v":1515269.8914695233},{"$f":"'Expense Budget'!M62","v":1444802.2409921899},{"$f":"'Expense Budget'!N62","v":1896655.8015937477},{"$f":"'Expense Budget'!O62","v":1818403.7356329046},{"$f":"'Expense Budget'!P62","v":3600770.1997541138},{"$f":"L4","v":2270474.043127039},{"$f":"M4","v":1736065.1285394144},1247437.2356861094,1187985.3965608894,1850921.5701189756,1256733.0889425564,1266559.0375825381]
["Net change in balance",null,{"$f":"C3+C4","v":171931.39469373762},{"$f":"D3+D4","v":828614.65613914141},{"$f":"E3+E4","v":184911.163892654},70260.546998661943,-734998.72695414466,-426662.69452633499,-79591.859320197487,-474717.72913915222,997283.95133273117,-483123.20808507409,-511551.02255642577,-973494.85450394033,-809156.45321883215,-89605.258979312144,-742964.98238289263,-981825.0973197096,{"$f":"S3+S4","v":-762925.54724397464},-458276.00140922563,-116037.353864189,-487399.43697636691,940422.44991184911,-497190.15241070138,{"$f":"Y3+Y4","v":-527442.17902898393},-988872.79569674144,-819402.89365429478,-96533.961286029313,-749318.54399319738,-988584.410419052]
["Accounting Adjustment"]
["Elec Tariff rider balance",9606251,{"$f":"C5+C6+B7","v":9778182.3946937378},{"$f":"D5+D6+C7","v":10606797.050832879},{"$f":"E5+E6+D7","v":10791708.214725534},{"$f":"F5+F6+E7","v":10861968.761724196},{"$f":"G5+G6+F7","v":10126970.034770051},9700307.3402437158,9620715.4809235185,9145997.7517843656,10143281.703117097,9660158.4950320236,9148607.4724755976,8175112.6179716568,7365956.1647528242,7276350.9057735121,6533385.9233906195,{"$f":"Q7+R5+R6","v":5551560.8260709103},4788635.2788269352,4330359.2774177101,4214321.9235535208,3726922.4865771541,4667344.9364890028,4170154.7840783014,{"$f":"X7+Y5+Y6","v":3642712.6050493177},{"$f":"Y7+Z5+Z6","v":2653839.8093525763},1834436.9156982815,1737902.9544122522,988584.4104190548,2.7939677238464355E-9]
[]
[]
[]
[]
[]
["End of July Balance",{"$f":"F7","v":10861968.761724196},"Overfunded \"Rebate\""]
["Aug 2024 - July 2025 Expenditure Budget",{"$f":"SUM(G4:R4)","v":21238605.60991459}]
["Aug 2024 - July 2025 Forecasted Revenue",{"$f":"SUM(G3:R3)","v":-26549013.54556787}]
[null,{"$f":"SUM(C6:R6)","v":0}]
["Total Projected DSM Balance July 2025",{"$f":"B13+B14+B16+B15","v":5551560.8260709159},"Overfunded"]
["Aug 2025 - July 2026 Expenditure Budget",{"$f":"SUM(S4:AD4)","v":21092077.370000005}]
["Aug 2025 - July 2026 Forecasted Revenue",{"$f":"SUM(S3:AD3)","v":-26643638.19607091}]
[null,{"$f":"SUM(C10:R10)","v":0}]
["Total Projected DSM Balance July 2026",{"$f":"B17+B18+B20+B19","v":0},"Overfunded"]
[]
[null,"Present","Proposed"]
["Gross Annual Revenue Recovered",{"$f":"'WA Electric - Sched 91'!C11","v":14907581.726292349},{"$f":"'WA Electric - Sched 91'!C19","v":27768930.42820954},{"$f":"C24-B24","v":12861348.70191719}]
["Revenue Conversion Factor",{"$f":"'Rev Conv Factor'!E22","v":0.95606900000000006},{"$f":"'Rev Conv Factor'!E22","v":0.95606900000000006}]
[]
["Net Annual Revenue to be Recovered",{"$f":"B24*B25","v":14252676.753474601},{"$f":"C24*C25","v":26549013.545567866},{"$f":"C27-B27","v":12296336.792093266}]
[]
[]
[]
["August 2024 - July 2025"]
["Annual DSM Expense",{"$f":"SUM(G4:R4)","v":21238605.60991459}]
["Annual DSM Revenue",{"$f":"SUM(G3:R3)","v":-26549013.54556787}]
[null,{"$f":"B32+B33","v":-5310407.9356532805}]

{"sheet":"Expense Budget","index":2,"n_rows":63,"n_cols":17,"rows_kept":63,"cut":false,"hidden":false,"merged":[[2,0,2,2],[7,0,7,2],[15,0,15,2],[32,0,32,2],[36,0,36,2]]}
["2024 - 2025 BCP"]
["Programs","MWh Savings","Estimated Electric Budget"]
["Low-Income Programs"]
["Low-Income Program",1706,5068644]
["Deferred Maintenance","-",700000]
["Named Communities Investment Fund",1149,4000000]
["Low-Income Programs Total",2855,9768644]
["Residential Programs "]
["Prescriptive",2321,911176]
["MultiFamily (New Offerings)",507,405391]
["Midstream",528,211247]
["On-Bill Repayment",515,412000]
["Always-On",3752,0]
["Home Energy Audit",1234,987571]
["Residential Total",8857,2927385]
["Commercial/Industrial Programs "]
["Interior Prescriptive Lighting",13147,3301095]
["Exterior Prescriptive Lighting",5275,1400420]
["Direct Install Lighting",12456,6228000]
["Pay for Performance",11,8490]
["Site-Specific",15173,4076800]
["Contractor Incentive Program",0,151733]
["Clean Buildings Accelerator",1000,800000]
["Prescriptive Shell",397,368213]
["Green Motors",17,3063]
["Variable Frequency Drives",24,8640]
["Compressed Air",107,25728]
["Grocer",1,4000]
["Appliances",116,30629]
["Midstream",1079,844987]
["Active Energy Management",2859,0]
["Commercial/Industrial Total",51662,17251797]
["Regional Efficiency Programs"]
["NEEA Electric (WA Portion)",15739,3306993]
["NEEA Natural Gas (WA Portion)",0,0]
["Regional Efficiency Programs Total",15739,3306993]
["Portfolio Support"]
["Third-Party Non-Incentive Payments"," -   ",3731990]
["Labor"," -   ",4591419]
["EM&V"," -   ",548088]
["Memberships"," -   ",102180]
["Outreach"," -   ",272482]
["Marketing"," -   ",1170490]
["Training/Travel"," -   ",13624]
["Regulatory"," -   ",6812]
["Studies and Research"," -   ",136242]
["Software"," -   ",313354]
["Conservation Potential Assessment"," -   ",54496]
["General Implementation"," -   ",490724]
["Pilot Programs"," -   ",2000000]
["Portfolio Support Total"," -   ",13431901]
["Totals Included in Cost Effectiveness",63374,38481214]
["Portfolio Totals",79113,46686720]
["Estimated EM&V Percentages",null,1.4200000000000001E-2]
[null,null,null,null,"Historical annual spend by month (%)"]
[null,null,null,null,0.10764582375164305,8.2308873520854822E-2,5.9142454951373498E-2,5.6323773885383267E-2,8.77543514396361E-2,5.9583182201391492E-2,6.0049041892099697E-2,7.1840713690190836E-2,6.8499760153885203E-2,8.9922664720139309E-2,8.6212642962294639E-2,0.17071671683110812,{"$f":"SUM(E56:P56)-1","v":0}]
[]
["Budgeted Spend by Month (2024 - 2025)"]
[null,null,null,null,"January","February","March","April","May","June","July","August","September","October","November","December"]
["Anticipated Spend (91% of Budget)",null,{"$f":"C53*0.91","v":42484915.200000003}]
["2024 Total",null,21392837.829999998,null,{"$f":"$C$61*E56","v":2302849.6505956617},1760820.3832016282,1265224.9476428137,1204925.3607035931,1877314.6092249621,1274653.3542297105,1284619.415044565,1536876.7375657132,1465404.2603659618,1923700.9835994025,1844333.0897880599,3652115.0380379274,{"$f":"SUM(E61:P61)-C61","v":0}]
["2025 Total",null,21092077.370000001,null,{"$f":"$C$62*E56","v":2270474.043127039},{"$f":"$C$62*F56","v":1736065.1285394144},1247437.2356861094,1187985.3965608894,1850921.5701189756,1256733.0889425564,1266559.0375825381,1515269.8914695233,1444802.2409921899,1896655.8015937477,1818403.7356329046,3600770.1997541138,{"$f":"SUM(E62:P62)-C62","v":0}]
["Check",null,{"$f":"C60-C61-C62","v":0}]

{"sheet":"Revenue By Month","index":3,"n_rows":43,"n_cols":33,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Forecasted Usage",null,null,"2024-04-30",{"$f":"EOMONTH(D4,1)","v":"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",{"$f":"EOMONTH(O4,1)","v":"2025-04-30"},"2025-05-31","2025-06-30","2025-07-31","2025-08-31","2025-09-30","2025-10-31","2025-11-30","2025-12-31","2026-01-31","2026-02-28","2026-03-31","2026-04-30","2026-05-31","2026-06-30","2026-07-31"]
[null,"Residential Schedule 001",null,{"$f":"'Billing Determinants'!C20","v":190974480.04255751},{"$f":"'Billing Determinants'!D20","v":176113563.99794334},{"$f":"'Billing Determinants'!E20","v":176459747.14482352},{"$f":"'Billing Determinants'!F20","v":204494293.77636918},{"$f":"'Billing Determinants'!G20","v":206259283.56051493},{"$f":"'Billing Determinants'!H20","v":159643326.96820152},{"$f":"'Billing Determinants'!I20","v":178363982.37041521},{"$f":"'Billing Determinants'!J20","v":242351481.9950045},{"$f":"'Billing Determinants'!K20","v":307050289.00418437},{"$f":"'Billing Determinants'!L20","v":317280238.33108574},{"$f":"'Billing Determinants'!M20","v":250037504.83744782},{"$f":"'Billing Determinants'!N20","v":235738741.94394654},{"$f":"'Billing Determinants'!O20","v":203081802.9519473},{"$f":"'Billing Determinants'!P20","v":179305893.01266021},{"$f":"'Billing Determinants'!Q20","v":174831177.44667855},{"$f":"'Billing Determinants'!R20","v":201206856.72398505},{"$f":"'Billing Determinants'!S20","v":210594571.25405914},{"$f":"'Billing Determinants'!T20","v":166271024.42692161},{"$f":"'Billing Determinants'!U20","v":182564364.39761642},{"$f":"'Billing Determinants'!V20","v":239376768.07710078},{"$f":"'Billing Determinants'!W20","v":308701003.05608219},{"$f":"'Billing Determinants'!X20","v":322620935.17708409},{"$f":"'Billing Determinants'!Y20","v":253550219.47452879},{"$f":"'Billing Determinants'!Z20","v":240183342.11028618},{"$f":"'Billing Determinants'!AA20","v":206814403.0390749},{"$f":"'Billing Determinants'!AB20","v":182580160.98159546},{"$f":"'Billing Determinants'!AC20","v":177592148.47885174},{"$f":"'Billing Determinants'!AD20","v":204190821.41307005}]
[null,"General Svc Schedule 011/012",null,{"$f":"'Billing Determinants'!C21","v":49752395.362736404},{"$f":"'Billing Determinants'!D21","v":50121076.665105976},{"$f":"'Billing Determinants'!E21","v":50821852.557946332},{"$f":"'Billing Determinants'!F21","v":59192814.413999453},{"$f":"'Billing Determinants'!G21","v":57839530.326941721},{"$f":"'Billing Determinants'!H21","v":50817696.386793911},{"$f":"'Billing Determinants'!I21","v":52829851.052405991},{"$f":"'Billing Determinants'!J21","v":60164500.728740469},{"$f":"'Billing Determinants'!K21","v":67365329.131425843},{"$f":"'Billing Determinants'!L21","v":69264093.654448509},{"$f":"'Billing Determinants'!M21","v":57606327.715122201},{"$f":"'Billing Determinants'!N21","v":57240439.920735866},{"$f":"'Billing Determinants'!O21","v":51756317.269628853},{"$f":"'Billing Determinants'!P21","v":49751343.822851121},{"$f":"'Billing Determinants'!Q21","v":50968687.61726632},{"$f":"'Billing Determinants'!R21","v":58964118.687377483},{"$f":"'Billing Determinants'!S21","v":58060911.501950197},{"$f":"'Billing Determinants'!T21","v":50816205.6185221},{"$f":"'Billing Determinants'!U21","v":53238993.173994668},{"$f":"'Billing Determinants'!V21","v":61119629.821588434},{"$f":"'Billing Determinants'!W21","v":68215626.820154011},{"$f":"'Billing Determinants'!X21","v":70111304.390175611},{"$f":"'Billing Determinants'!Y21","v":57958442.440825172},{"$f":"'Billing Determinants'!Z21","v":57925206.503449172},{"$f":"'Billing Determinants'!AA21","v":52165555.534418054},{"$f":"'Billing Determinants'!AB21","v":50133378.492059372},{"$f":"'Billing Determinants'!AC21","v":51541057.803223841},{"$f":"'Billing Determinants'!AD21","v":59651209.085487969}]
[null,"Large Gen Svc Schedule 021/022",null,{"$f":"'Billing Determinants'!C22","v":91843610.469783872},{"$f":"'Billing Determinants'!D22","v":101455145.64846832},{"$f":"'Billing Determinants'!E22","v":108657764.4533896},{"$f":"'Billing Determinants'!F22","v":119754266.13550463},{"$f":"'Billing Determinants'!G22","v":111278453.61038806},{"$f":"'Billing Determinants'!H22","v":98739094.601925939},{"$f":"'Billing Determinants'!I22","v":111508701.34510924},{"$f":"'Billing Determinants'!J22","v":115516427.03776574},{"$f":"'Billing Determinants'!K22","v":111510703.76299129},{"$f":"'Billing Determinants'!L22","v":114306368.89030105},{"$f":"'Billing Determinants'!M22","v":96799842.40561457},{"$f":"'Billing Determinants'!N22","v":100289871.06851721},{"$f":"'Billing Determinants'!O22","v":94296727.364874288},{"$f":"'Billing Determinants'!P22","v":100016788.33564591},{"$f":"'Billing Determinants'!Q22","v":106639413.62919942},{"$f":"'Billing Determinants'!R22","v":116968063.3330999},{"$f":"'Billing Determinants'!S22","v":109025418.63326614},{"$f":"'Billing Determinants'!T22","v":96493822.204127386},{"$f":"'Billing Determinants'!U22","v":109252445.70751451},{"$f":"'Billing Determinants'!V22","v":114364922.28825298},{"$f":"'Billing Determinants'!W22","v":110202623.10455997},{"$f":"'Billing Determinants'!X22","v":113159189.22379866},{"$f":"'Billing Determinants'!Y22","v":95161227.30444032},{"$f":"'Billing Determinants'!Z22","v":98643696.48651199},{"$f":"'Billing Determinants'!AA22","v":92773165.115223542},{"$f":"'Billing Determinants'!AB22","v":97859899.590733752},{"$f":"'Billing Determinants'!AC22","v":104734604.57135956},{"$f":"'Billing Determinants'!AD22","v":115313013.97907208}]
[null,"Extra Large Gen Schedule 25",null,{"$f":"'Billing Determinants'!C23","v":47825712},{"$f":"'Billing Determinants'!D23","v":51462423},{"$f":"'Billing Determinants'!E23","v":52844203},{"$f":"'Billing Determinants'!F23","v":52609038},{"$f":"'Billing Determinants'!G23","v":59236945},{"$f":"'Billing Determinants'!H23","v":49822212},{"$f":"'Billing Determinants'!I23","v":51363419},{"$f":"'Billing Determinants'!J23","v":49248530},{"$f":"'Billing Determinants'!K23","v":49427123},{"$f":"'Billing Determinants'!L23","v":55614734},{"$f":"'Billing Determinants'!M23","v":47598641},{"$f":"'Billing Determinants'!N23","v":53469196},{"$f":"'Billing Determinants'!O23","v":48593642},{"$f":"'Billing Determinants'!P23","v":51505608},{"$f":"'Billing Determinants'!Q23","v":52323263},{"$f":"'Billing Determinants'!R23","v":52611678},{"$f":"'Billing Determinants'!S23","v":57808452},{"$f":"'Billing Determinants'!T23","v":50092151},{"$f":"'Billing Determinants'!U23","v":50742389},{"$f":"'Billing Determinants'!V23","v":48860881},{"$f":"'Billing Determinants'!W23","v":50249792},{"$f":"'Billing Determinants'!X23","v":54082816},{"$f":"'Billing Determinants'!Y23","v":48080079},{"$f":"'Billing Determinants'!Z23","v":52706000},{"$f":"'Billing Determinants'!AA23","v":48652401},{"$f":"'Billing Determinants'!AB23","v":51329654},{"$f":"'Billing Determinants'!AC23","v":51829582},{"$f":"'Billing Determinants'!AD23","v":52681491}]
[null,"Extra Large Gen Schedule 25I",null,{"$f":"'Billing Determinants'!C24","v":36822962},{"$f":"'Billing Determinants'!D24","v":38444830},{"$f":"'Billing Determinants'!E24","v":38253213},{"$f":"'Billing Determinants'!F24","v":33280210},{"$f":"'Billing Determinants'!G24","v":36585435},{"$f":"'Billing Determinants'!H24","v":37109668},{"$f":"'Billing Determinants'!I24","v":34770564},{"$f":"'Billing Determinants'!J24","v":35823113},{"$f":"'Billing Determinants'!K24","v":36584911},{"$f":"'Billing Determinants'!L24","v":37391600},{"$f":"'Billing Determinants'!M24","v":35111801},{"$f":"'Billing Determinants'!N24","v":36043336},{"$f":"'Billing Determinants'!O24","v":36841235},{"$f":"'Billing Determinants'!P24","v":35372228},{"$f":"'Billing Determinants'!Q24","v":35675190},{"$f":"'Billing Determinants'!R24","v":35874371},{"$f":"'Billing Determinants'!S24","v":36467467},{"$f":"'Billing Determinants'!T24","v":35575817},{"$f":"'Billing Determinants'!U24","v":35681264},{"$f":"'Billing Determinants'!V24","v":36370128},{"$f":"'Billing Determinants'!W24","v":35624529},{"$f":"'Billing Determinants'!X24","v":35686729},{"$f":"'Billing Determinants'!Y24","v":35713922},{"$f":"'Billing Determinants'!Z24","v":35996684},{"$f":"'Billing Determinants'!AA24","v":35704864},{"$f":"'Billing Determinants'!AB24","v":35572111},{"$f":"'Billing Determinants'!AC24","v":36025965},{"$f":"'Billing Determinants'!AD24","v":35721817}]
[null,"Pumping Schedule 31/32",null,{"$f":"'Billing Determinants'!C25","v":5935825.356991414},{"$f":"'Billing Determinants'!D25","v":13111416.405416997},{"$f":"'Billing Determinants'!E25","v":20733956.509573527},{"$f":"'Billing Determinants'!F25","v":25410501.282079004},{"$f":"'Billing Determinants'!G25","v":28523535.656824239},{"$f":"'Billing Determinants'!H25","v":22331575.297284823},{"$f":"'Billing Determinants'!I25","v":12097274.584637048},{"$f":"'Billing Determinants'!J25","v":2827877.1280326489},{"$f":"'Billing Determinants'!K25","v":3789741.9540799949},{"$f":"'Billing Determinants'!L25","v":4931291.7146152025},{"$f":"'Billing Determinants'!M25","v":3646896.8294098517},{"$f":"'Billing Determinants'!N25","v":4740668.6377395401},{"$f":"'Billing Determinants'!O25","v":5851133.9732547225},{"$f":"'Billing Determinants'!P25","v":12768759.707577553},{"$f":"'Billing Determinants'!Q25","v":20688145.23298661},{"$f":"'Billing Determinants'!R25","v":26230712.396206092},{"$f":"'Billing Determinants'!S25","v":28575600.96416897},{"$f":"'Billing Determinants'!T25","v":21043593.052168407},{"$f":"'Billing Determinants'!U25","v":11694673.393642556},{"$f":"'Billing Determinants'!V25","v":3098492.533733455},{"$f":"'Billing Determinants'!W25","v":3635586.4702552389},{"$f":"'Billing Determinants'!X25","v":4691168.9335967461},{"$f":"'Billing Determinants'!Y25","v":4117271.9675771226},{"$f":"'Billing Determinants'!Z25","v":4965164.3851606306},{"$f":"'Billing Determinants'!AA25","v":5915233.0535734408},{"$f":"'Billing Determinants'!AB25","v":12802467.596100824},{"$f":"'Billing Determinants'!AC25","v":20740880.777882572},{"$f":"'Billing Determinants'!AD25","v":25669603.033647154}]
[null,"Street and Area Lights",null,{"$f":"'Billing Determinants'!C26","v":1302550.6210047223},{"$f":"'Billing Determinants'!D26","v":1337105.588589699},{"$f":"'Billing Determinants'!E26","v":1331504.852722174},{"$f":"'Billing Determinants'!F26","v":1333836.0243040216},{"$f":"'Billing Determinants'!G26","v":1334110.298731857},{"$f":"'Billing Determinants'!H26","v":1302325.5008865951},{"$f":"'Billing Determinants'!I26","v":1306182.7894858946},{"$f":"'Billing Determinants'!J26","v":1320266.0382451359},{"$f":"'Billing Determinants'!K26","v":1319835.5894288972},{"$f":"'Billing Determinants'!L26","v":1312052.5670342222},{"$f":"'Billing Determinants'!M26","v":1282781.9397454073},{"$f":"'Billing Determinants'!N26","v":1346978.8782308577},{"$f":"'Billing Determinants'!O26","v":1282521.0688841238},{"$f":"'Billing Determinants'!P26","v":1322804.2761951154},{"$f":"'Billing Determinants'!Q26","v":1311334.1459539002},{"$f":"'Billing Determinants'!R26","v":1318291.5221090443},{"$f":"'Billing Determinants'!S26","v":1317500.1690632126},{"$f":"'Billing Determinants'!T26","v":1269268.4803722838},{"$f":"'Billing Determinants'!U26","v":1295238.796120883},{"$f":"'Billing Determinants'!V26","v":1305931.2342727571},{"$f":"'Billing Determinants'!W26","v":1304157.7672317254},{"$f":"'Billing Determinants'!X26","v":1271052.7874755026},{"$f":"'Billing Determinants'!Y26","v":1281690.8657831096},{"$f":"'Billing Determinants'!Z26","v":1330206.771087918},{"$f":"'Billing Determinants'!AA26","v":1265826.8516803812},{"$f":"'Billing Determinants'!AB26","v":1299825.2317412151},{"$f":"'Billing Determinants'!AC26","v":1293536.9214742235},{"$f":"'Billing Determinants'!AD26","v":1298088.8774713338}]
["Total Forecasted Usage",null,null,{"$f":"SUM(D5:D11)","v":424457535.85307389},{"$f":"SUM(E5:E11)","v":432045561.30552435},449102241.51845515,496074959.63225627,501057293.45340079,419765898.7550928,442239975.14205337,507252195.9277885,577047933.44211042,600100379.15748477,492083795.72733986,488869232.44917005,{"$f":"SUM(P5:P11)","v":441703379.62858933},430043425.15492988,442437211.07208484,493174091.66277754,{"$f":"SUM(T5:T11)","v":501849921.52250767},421561881.78211182,444469368.468889,504496752.95494843,577933318.21828306,601623195.5121305,495862853.05315447,491750300.25649589,443291448.5939703,431577496.89223057,443757775.55279195,494526044.38874859]
[null,null,null,{"$f":"D12-'Billing Determinants'!C27","v":0},{"$f":"E12-'Billing Determinants'!D27","v":0},{"$f":"F12-'Billing Determinants'!E27","v":0},{"$f":"G12-'Billing Determinants'!F27","v":0},{"$f":"H12-'Billing Determinants'!G27","v":0},{"$f":"I12-'Billing Determinants'!H27","v":0},{"$f":"J12-'Billing Determinants'!I27","v":0},{"$f":"K12-'Billing Determinants'!J27","v":0},{"$f":"L12-'Billing Determinants'!K27","v":0},{"$f":"M12-'Billing Determinants'!L27","v":0},{"$f":"N12-'Billing Determinants'!M27","v":0},{"$f":"O12-'Billing Determinants'!N27","v":0},{"$f":"P12-'Billing Determinants'!O27","v":0},{"$f":"Q12-'Billing Determinants'!P27","v":0},{"$f":"R12-'Billing Determinants'!Q27","v":0},{"$f":"S12-'Billing Determinants'!R27","v":0},{"$f":"T12-'Billing Determinants'!S27","v":0},{"$f":"U12-'Billing Determinants'!T27","v":0},{"$f":"V12-'Billing Determinants'!U27","v":0},{"$f":"W12-'Billing Determinants'!V27","v":0},{"$f":"X12-'Billing Determinants'!W27","v":0},{"$f":"Y12-'Billing Determinants'!X27","v":0},{"$f":"Z12-'Billing Determinants'!Y27","v":0},{"$f":"AA12-'Billing Determinants'!Z27","v":0},{"$f":"AB12-'Billing Determinants'!AA27","v":0},{"$f":"AC12-'Billing Determinants'!AB27","v":0},{"$f":"AD12-'Billing Determinants'!AC27","v":0},{"$f":"AE12-'Billing Determinants'!AD27","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":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-3},{"$f":"'WA Electric - Sched 91'!$D$23","v":4.975902298119751E-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":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-3},{"$f":"'WA Electric - Sched 91'!$E$23","v":5.8581905579910701E-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":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-3},{"$f":"'WA Electric - Sched 91'!$F$23","v":5.0459464959126876E-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":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3},{"$f":"'WA Electric - Sched 91'!$G$23","v":3.1617225686926161E-3}]
[null,"Extra Large Gen Schedule 25I",null,1.8167505621790386E-3,1.8167505621790386E-3,1.8167505621790386E-3,1.8167505621790386E-3,{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3},{"$f":"'WA Electric - Sched 91'!$H$23","v":2.3936086873712335E-3}]
[null,"Pumping Schedule 31/32",null,2.3613825413033489E-3,2.3613825413033489E-3,2.3613825413033489E-3,2.3613825413033489E-3,{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3},{"$f":"'WA Electric - Sched 91'!$I$23","v":5.1195290210376198E-3}]
[null,"Street and Area Lights",null,1.1182488739420801E-2,1.1182488739420801E-2,1.1182488739420801E-2,1.1182488739420801E-2,{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2},{"$f":"'WA Electric - Sched 91'!$J$23","v":2.1521485518089436E-2}]
[]
[]
["Gross DSM Revenue",null,null,{"$f":"D4","v":"2024-04-30"},{"$f":"E4","v":"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",{"$f":"T4","v":"2025-08-31"},"2025-09-30","2025-10-31","2025-11-30","2025-12-31","2026-01-31","2026-02-28","2026-03-31","2026-04-30","2026-05-31","2026-06-30","2026-07-31"]
[null,"Residential Schedule 001",null,{"$f":"D5*D16","v":487365.36734706699},{"$f":"E5*E16","v":449440.4267708009},{"$f":"F5*F16","v":450323.88343218848},{"$f":"G5*G16","v":521867.82539996866},1026326.0430772996,794369.5975405568,887521.74977873976,1205917.2962116704,1527852.2386942548,1578755.4670596318,1244162.1949367849,1173012.9477947426,{"$f":"P5*P16","v":1010515.210014897},892208.60510811012,869942.85763990972,{"$f":"S5*S16","v":1001185.6607703287},{"$f":"T5*T16","v":1047898.0110746165},827348.37255664449,908422.44036087114,1191115.4103913244,1536066.0305386316,1605330.2527691959,1261641.119772075,1195128.8439766553,1029088.2633663972,908501.04261939495,883681.17974394246,1016033.5775242549]
[null,"General Svc Schedule 011/012",null,{"$f":"D6*D17","v":159548.22663470096},{"$f":"E6*E17","v":160730.53047268852},162977.81022989133,189822.18846781467,338834.99043992814,297699.749151973,309487.3346152794,352455.11009535426,394638.93505367963,405762.25945429946,337468.84510126815,335325.40467890998,{"$f":"P6*P17","v":303198.36914532993},291452.85263039381,298584.28455266595,345423.04335465957,{"$f":"T6*T17","v":340131.88354907976},297691.01594735892,311884.16712884657,358050.43832873879,399620.14094526862,410725.38138696464,339531.60026271094,339336.89780818886,305595.76488408668,293690.88452237484,301937.33817171789,349448.14983735676]
[null,"Large Gen Svc Schedule 021/022",null,{"$f":"D7*D18","v":251178.00630657512},{"$f":"E7*E18","v":277464.06182397803},297162.10529540246,327509.31350329611,561505.1230659202,498232.18841617956,562666.94081612839,582889.71023156773,562677.04490962368,576783.82156251767,488446.82559151121,506057.32349371962,{"$f":"P7*P18","v":475816.24102282146},504679.36263469345,538096.77552844246,590214.58930934872,{"$f":"T7*T18","v":550136.42911794304},486902.66402813845,551281.99558772403,577079.27887573699,556076.53989484103,570995.21434414759,480178.46146359137,497750.81462998985,468128.42742789141,493795.81743023044,528485.21093765274,581863.29882082948]
[null,"Extra Large Gen Schedule 25",null,{"$f":"D8*D19","v":86887.389162612788},{"$f":"E8*E19","v":93494.385916345491},96004.73550815323,95577.499362198403,187290.78590690321,157524.01210258808,162396.88105751513,155710.18877593536,156274.85029464588,175838.35963963656,150493.69748879768,169054.76372304896,{"$f":"P8*P19","v":153639.6146063694},162846.44322783494,165431.64149473931,166343.52970938879,{"$f":"T8*T19","v":182774.28734958378},158377.4843310584,160433.35649067996,154484.55018390424,158875.90143850967,170994.85992565012,152015.87087882392,166641.74970551301,153825.3942627832,162290.12549498322,163870.75913530457,166564.25904707692]
[null,"Extra Large Gen Schedule 25I",null,{"$f":"D9*D20","v":66898.136914597373},69844.666515377568,69496.546222904508,60461.84022693646,87571.21504725558,88826.023710262263,83227.124055197462,85746.51448548137,87569.960796303407,89500.858594710211,84043.91190284997,86273.642171440326,88183.500149485146,84667.272232475996,85392.444707619361,85869.206079578638,87288.845817623776,85154.584631529215,85406.983486786441,87055.854341603743,85271.182097908444,85420.064558262937,85485.153959298623,86161.975538957078,85463.472651808406,85145.71391773381,86232.062794932004,85504.05149988542]
[null,"Pumping Schedule 31/32",null,{"$f":"D10*D21","v":14016.754366225243},{"$f":"E10*E21","v":30961.06979151001},48960.802913849846,60003.914093267726,146027.06857771304,114327.14781993646,61932.348311510184,14477.399024891663,19401.693916156353,25245.891044174892,18670.394154893816,24269.990670030453,{"$f":"P10*P21","v":29955.050182056708},65370.035885599114,105913.55991171605,134288.89335486834,{"$f":"T10*T21","v":146293.61842965364},107733.28533748178,59871.219830309572,15862.822447916809,18612.490442963419,24016.575498138645,21078.493325515741,25419.30316405226,30283.207283970209,65542.604399131902,106183.54106425116,131416.27768927193]
[null,"Street and Area Lights",null,{"$f":"D11*D22","v":14565.757651910879},{"$f":"E11*E22","v":14952.168187820933},14889.538022049865,14915.606322013533,28712.035473691631,28027.979407169427,{"$f":"J11*J22","v":28110.993987898342},28414.086422118005,28404.822524153045,28237.320320399082,27607.372939097459,{"$f":"O11*O22","v":28988.986421017758},{"$f":"P11*P22","v":27601.758610634253},28468.713073399955,28221.858831523041,28371.591901689877,{"$f":"T11*T22","v":28354.560808574312},27316.543218899493,27875.462993183177,28105.580146021803,28067.412500781433,27354.944158381237,27583.891406618703,28628.025760033135,27242.474256848069,27974.169900965804,27838.836122621491,27936.800977692285]
[null,"Total",null,{"$f":"SUM(D26:D32)","v":1080459.6383836896},{"$f":"SUM(E26:E32)","v":1096887.3094785213},1139815.4216244398,1270158.1873754954,2376267.2615887118,1979006.6981486655,2095343.3726222685,2425610.3052470186,2776819.5461888169,{"$f":"SUM(M26:M32)","v":2880123.9776753695},2350893.2421152028,2322983.0589529099,{"$f":"SUM(P26:P32)","v":2088909.7437315939},2029693.2847925073,2091583.4226666158,2351696.5144798625,{"$f":"SUM(T26:T32)","v":2382877.6361470749},1990523.9500511107,2105175.6258784011,2411753.9347152468,2782589.697858904,2894837.292640741,2367514.5910686338,2339067.6105833896,2099627.0041337851,2036940.358284815,2098228.927970422,2358766.4153963681,null,{"$f":"SUM(H33:S33)-'WA Electric - Sched 91'!D39","v":0}]
[]
["Net DSM Revenue",null,{"$f":"'Rev Conv Factor'!E22","v":0.95606900000000006},{"$f":"D4","v":"2024-04-30"},{"$f":"E4","v":"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",{"$f":"T4","v":"2025-08-31"},"2025-09-30","2025-10-31","2025-11-30","2025-12-31","2026-01-31","2026-02-28","2026-03-31","2026-04-30","2026-05-31","2026-06-30","2026-07-31"]
[null,"Residential Schedule 001",null,{"$f":"D26*$C$35","v":465954.91939414304},{"$f":"E26*$C$35","v":429696.0593823329},{"$f":"F26*$C$35","v":430540.70490912901},{"$f":"G26*$C$35","v":498941.64996232267},{"$f":"H26*$C$35","v":981238.51367887086},759472.14675100264,848532.03178921004,1152940.1434717956,1460732.1619961776,1509399.1606362353,1189504.905551017,1121481.3159851718,{"$f":"P26*$C$35","v":966122.26632373268},853012.98887710576,831725.39796093095,{"$f":"S26*$C$35","v":957202.57350702747},{"$f":"T26*$C$35","v":1001862.8035500975},791002.13120185863,868514.53413337772,1138788.5192974233,1468585.1137510391,1534806.4894347924,1206215.9637393681,1142625.6387319169,983879.38686844811,868589.68331608234,844860.18183661136,971398.20643003692]
[null,"General Svc Schedule 011/012",null,{"$f":"D27*$C$35","v":152539.11349041192},{"$f":"E27*$C$35","v":153669.47753849285},155818.03204868198,181483.10990623513,323949.63047491165,284621.50147197768,295891.24651829555,336971.40465375525,377302.05199783645,387936.71763421263,322643.50126712437,320594.22432596079,{"$f":"P27*$C$35","v":289878.56159040646},278649.03736148798,285467.17834798282,330248.26363704604,{"$f":"T27*$C$35","v":325189.54977288516},284613.15192577551,298182.78378270922,342320.924522519,382064.42853340204,392681.8046572539,324615.63753156981,324429.48855057731,292170.6373369639,280788.7502744224,288672.92896849615,334096.54316685186]
[null,"Large Gen Svc Schedule 021/022",null,{"$f":"D28*$C$35","v":240143.50531152097},{"$f":"E28*$C$35","v":265274.7881239889},284107.47684767016,313121.50185178284,536837.64150451124,476344.35014686838,537948.41943913512,557282.78237138479,537958.07964969904,551445.13149745471,466988.86809645058,483825.71921531705,{"$f":"P28*$C$35","v":454913.15773844789},482508.29355478875,514457.6460827025,564285.87218639976,{"$f":"T28*$C$35","v":525968.3856503627},465512.5430947183,527063.62623955973,551727.60907544696,531647.54142072075,545910.82358279487,459083.74147303437,475884.12359247979,447563.07748255675,472102.87337470299,505268.32713595073,556301.46224033169]
[null,"Extra Large Gen Schedule 25",null,{"$f":"D29*$C$35","v":83070.339269310047},{"$f":"E29*$C$35","v":89387.08404865452},91787.15147254456,91378.684237717665,179062.91439122707,150603.82472690928,155262.62367577743,148869.68447281976,149409.53984635181,168113.60466230768,143882.35886441733,161628.0188979317,{"$f":"P29*$C$35","v":146890.072697097},155692.43613039295,158164.06405223391,159035.89210572565,{"$f":"T29*$C$35","v":174744.83013202922},151419.80306691068,153385.3587066879,147697.88940977515,151896.3242124145,163482.8847342564,145337.66165524631,159321.01099920014,147067.69086742488,155160.55799186311,156671.75281573151,159246.92458287979]
[null,"Extra Large Gen Schedule 25I",null,63959.234861802201,66776.320470690524,66443.493450786089,57805.691123926917,83724.123999014599,84923.807662646737,79570.873268328593,81979.584357619693,83722.924848561001,85568.996375785995,80351.778809045878,82483.554797206787,84309.510804418125,80947.754296031097,81641.069219168945,82096.885987296671,83454.159532009755,81413.658574081506,81654.969295228424,83231.403604522755,81525.133797165239,81667.475702153897,81729.705660712687,82376.793791555159,81708.976834741814,81405.177559613847,82443.802044287848,81747.773013443963]
[null,"Pumping Schedule 31/32",null,{"$f":"D31*$C$35","v":13400.984330162602},{"$f":"E31*$C$35","v":29600.919034499184},46809.905881041508,57367.882143236384,139611.95342802553,109304.64188905884,59211.598317837233,13841.392408329149,18549.358100725691,24136.813804713245,17850.185069275176,23203.785709905347,{"$f":"P31*$C$35","v":28639.094872508776},62498.264839108866,101260.67131123446,128389.44798089562,{"$f":"T31*$C$35","v":139866.79347842053},103000.45437932087,57241.017271944249,15165.952794957377,17794.825125313593,22961.503319929918,20152.49403523251,24302.607756752281,28952.835704778114,62663.252245273645,101518.79192175754,125643.02919410453]
[null,"Street and Area Lights",null,{"$f":"D32*$C$35","v":13925.869352504782},{"$f":"E32*$C$35","v":14295.304487161773},{"$f":"F32*$C$35","v":14235.425727203194},14260.348820681158,27450.687043296886,26796.682243833067,26876.049911015984,27165.827191507942,27156.97026584448,26996.826601403631,26394.553438509971,27715.47125855603,{"$f":"P32*$C$35","v":26389.18575311048},27218.054039372422,26982.044351195404,27125.199497856742,{"$f":"T32*$C$35","v":27108.916597692834},26116.500158750019,26650.866028429649,26870.873904626922,26834.383002209604,26153.214106559393,26372.10347323454,27370.36796036912,26045.685120270478,26745.236643046475,26615.848212918609,26709.509373941288]
[null,"Total",null,{"$f":"SUM(D36:D42)","v":1032993.9660098555},{"$f":"SUM(E36:E42)","v":1048699.9530858207},1089742.1903370565,1214358.868045903,2271875.4645198579,1892066.9548922968,2003292.8429196,2319050.8189272122,2654831.0867051962,2753597.2512121131,2247616.1510958401,2220932.0901900497,{"$f":"SUM(P36:P42)","v":1997141.8497797216},1940526.8290982877,1999698.071325449,2248384.1349022477,{"$f":"SUM(T36:T42)","v":2278195.4387134979},1903078.2424014155,2012693.1554579367,2305803.1726092715,2660347.7498422647,2767664.1955377404,2263507.3075683983,2236310.0313828508,2007388.2902151842,1947455.5314050049,2006051.6329357538,2255143.4480015901,null,{"$f":"SUM(H43:S43)-'WA Electric - Sched 91'!D42","v":0}]

{"sheet":"Billing Determinants","index":4,"n_rows":46,"n_cols":33,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Forecasted Loads"]
[]
[]
[null,null,"2024-04-30",{"$f":"EOMONTH(C7,1)","v":"2024-05-31"},{"$f":"EOMONTH(D7,1)","v":"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","2025-08-31","2025-09-30","2025-10-31","2025-11-30","2025-12-31","2026-01-31","2026-02-28","2026-03-31","2026-04-30","2026-05-31","2026-06-30","2026-07-31"]
["WA001/002",null,{"$f":"C34+C35","v":190974480.04255751},{"$f":"D34+D35","v":176113563.99794334},{"$f":"E34+E35","v":176459747.14482352},204494293.77636918,206259283.56051493,159643326.96820152,178363982.37041521,242351481.9950045,307050289.00418437,317280238.33108574,250037504.83744782,235738741.94394654,203081802.9519473,179305893.01266021,174831177.44667855,201206856.72398505,210594571.25405914,166271024.42692161,182564364.39761642,239376768.07710078,308701003.05608219,322620935.17708409,253550219.47452879,240183342.11028618,206814403.0390749,182580160.98159546,177592148.47885174,204190821.41307005]
["WA011/013",null,{"$f":"C36+C38","v":44553492.262623586},{"$f":"D36+D38","v":45367362.010243319},{"$f":"E36+E38","v":46657261.481289558},54309748.199253514,53185830.600740753,46594626.380731389,47939247.872749157,53383522.311439708,58546350.509158008,60254274.373448618,50640676.596187495,50311897.697084479,46259442.073709004,44991997.025062241,46677213.057557799,54037538.464990705,53357005.959444016,46545655.039832681,48299347.741267748,54140688.870054349,59328027.830838539,60957554.627864487,50863962.416720912,50816246.476804189,46518330.486162491,45316676.942473441,47056954.815439694,54533957.137890816]
["WA012",null,{"$f":"C37","v":5198903.1001128182},{"$f":"D37","v":4753714.6548626544},{"$f":"E37","v":4164591.0766567746},4883066.2147459351,4653699.7262009671,4223070.0060625216,4890603.1796568315,6780978.4173007645,8818978.6222678348,9009819.280999897,6965651.118934704,6928542.2236513831,5496875.195919849,4759346.7977888845,4291474.5597085208,4926580.2223867774,4703905.5425061807,4270550.5786894159,4939645.4327269178,6978940.9515340878,8887598.9893154651,9153749.7623111252,7094480.0241042599,7108960.0266449852,5647225.04825556,4816701.5495859291,4484102.9877841482,5117251.9475971535]
["WA021/023",null,{"$f":"C39+C41","v":89608566.88224265},{"$f":"D39+D41","v":99299272.049277663},{"$f":"E39+E41","v":106538977.55530444},117273819.22511864,108948158.48586424,96680255.871974736,109279898.76521121,112804464.34606609,108037154.97588123,110761555.28135361,93997176.041964546,97581315.194365546,92010286.83532089,97927246.290566176,104558730.95004332,114514607.42259732,106679887.17025828,94447442.968081757,106981049.35424161,111618304.10888426,106781077.14999478,109624633.44497283,92377840.476076558,95956273.489278689,90478877.05042471,95764619.258111104,102631957.82565205,112837258.15655641]
["WA022",null,{"$f":"C40","v":2235043.5875412175},{"$f":"D40","v":2155873.5991906486},{"$f":"E40","v":2118786.8980851681},2480446.9103859947,2330295.1245238213,2058838.7299511994,2228802.5798980366,2711962.6916996525,3473548.7871100623,3544813.6089474373,2802666.3636500253,2708555.8741516685,2286440.5295534027,2089542.0450797365,2080682.6791560946,2453455.9105025874,2345531.4630078557,2046379.2360456313,2271396.3532728944,2746618.1793687236,3421545.9545651916,3534555.7788258377,2783386.8283637594,2687422.9972332953,2294288.0647988268,2095280.3326226494,2102646.7457075058,2475755.8225156609]
["WA025",null,{"$f":"C42","v":47825712},{"$f":"D42","v":51462423},52844203,52609038,59236945,49822212,51363419,49248530,49427123,55614734,47598641,53469196,48593642,51505608,52323263,52611678,57808452,50092151,50742389,48860881,50249792,54082816,48080079,52706000,48652401,51329654,51829582,52681491]
["WA025I",null,{"$f":"C46","v":36822962},{"$f":"D46","v":38444830},38253213,33280210,36585435,37109668,34770564,35823113,36584911,37391600,35111801,36043336,36841235,35372228,35675190,35874371,36467467,35575817,35681264,36370128,35624529,35686729,35713922,35996684,35704864,35572111,36025965,35721817]
["WA031",null,{"$f":"C43","v":5502618.6885915119},12395651.244028438,{"$f":"E43","v":19701055.938252218},23673980.601589113,26583414.787156716,21256596.556735978,11530327.64336041,2476142.828225363,3386382.4626985262,4447959.0894974768,3261283.3623971911,4359897.3973822482,5428370.6720306799,12126309.068046305,19713389.648264095,24561593.9447411,26669643.838447478,20047432.615732528,11162597.2832499,2759565.957522322,3247143.2793029789,4250113.4100802066,3741364.8017945364,4594475.3108308576,5487156.9682067037,12114704.123934943,19716146.083762489,23902470.498115566]
["WA032",null,433206.66839990241,715765.16138855903,{"$f":"E44","v":1032900.5713213077},1736520.6804898917,1940120.8696675238,1074978.7405488463,566946.94127663749,351734.29980728577,403359.49138146872,483332.62511772581,385613.46701266052,380771.24035729188,422763.30122404272,642450.63953124778,974755.5847225138,1669118.4514649927,1905957.1257214933,996160.43643587991,532076.11039265699,338926.57621113304,388443.19095226011,441055.52351653931,375907.16578258615,370689.07432977285,428076.08536673721,687763.47216588142,1024734.6941200818,1767132.5355315863]
["WA04X",null,1302550.6210047223,1337105.588589699,{"$f":"E45","v":1331504.852722174},1333836.0243040216,1334110.298731857,1302325.5008865951,1306182.7894858946,1320266.0382451359,1319835.5894288972,1312052.5670342222,1282781.9397454073,1346978.8782308577,1282521.0688841238,1322804.2761951154,1311334.1459539002,1318291.5221090443,1317500.1690632126,1269268.4803722838,1295238.796120883,1305931.2342727571,1304157.7672317254,1271052.7874755026,1281690.8657831096,1330206.771087918,1265826.8516803812,1299825.2317412151,1293536.9214742235,1298088.8774713338]
[null,null,{"$f":"SUM(C8:C17)","v":424457535.85307395},432045561.30552441,449102241.51845515,496074959.63225627,501057293.45340079,419765898.75509286,442239975.14205337,507252195.92778856,577047933.44211054,600100379.15748477,492083795.7273398,488869232.44917005,441703379.62858933,430043425.15492994,442437211.07208478,493174091.66277754,501849921.52250767,421561881.78211188,444469368.468889,504496752.95494848,577933318.21828306,601623195.5121305,495862853.05315447,491750300.25649589,443291448.5939703,431577496.89223057,443757775.55279195,494526044.38874853]
[]
["WA001",null,{"$f":"C8","v":190974480.04255751},176113563.99794334,176459747.14482352,204494293.77636918,206259283.56051493,159643326.96820152,178363982.37041521,242351481.9950045,307050289.00418437,317280238.33108574,250037504.83744782,235738741.94394654,203081802.9519473,179305893.01266021,174831177.44667855,201206856.72398505,210594571.25405914,166271024.42692161,182564364.39761642,239376768.07710078,308701003.05608219,322620935.17708409,253550219.47452879,240183342.11028618,206814403.0390749,182580160.98159546,177592148.47885174,204190821.41307005,null,{"$f":"SUM(B20:K20)","v":1841710448.860014},{"$f":"SUM(B20:R20)","v":3403192664.1077647}]
["WA011/12",null,{"$f":"C9+C10","v":49752395.362736404},50121076.665105976,50821852.557946332,59192814.413999453,57839530.326941721,50817696.386793911,52829851.052405991,60164500.728740469,67365329.131425843,69264093.654448509,57606327.715122201,57240439.920735866,51756317.269628853,49751343.822851121,50968687.61726632,58964118.687377483,58060911.501950197,50816205.6185221,53238993.173994668,61119629.821588434,68215626.820154011,70111304.390175611,57958442.440825172,57925206.503449172,52165555.534418054,50133378.492059372,51541057.803223841,59651209.085487969,null,498905046.62609613,894456375.31352651]
["WA021/22",null,{"$f":"C11+C12","v":91843610.469783872},101455145.64846832,108657764.4533896,119754266.13550463,111278453.61038806,98739094.601925939,111508701.34510924,115516427.03776574,111510703.76299129,114306368.89030105,96799842.40561457,100289871.06851721,94296727.364874288,100016788.33564591,106639413.62919942,116968063.3330999,109025418.63326614,96493822.204127386,109252445.70751451,114364922.28825298,110202623.10455997,113159189.22379866,95161227.30444032,98643696.48651199,92773165.115223542,97859899.590733752,104734604.57135956,115313013.97907208,null,970264167.06532669,1699581242.0925791]
["WA025",null,{"$f":"C13","v":47825712},51462423,52844203,52609038,59236945,49822212,51363419,49248530,49427123,55614734,47598641,53469196,48593642,51505608,52323263,52611678,57808452,50092151,50742389,48860881,50249792,54082816,48080079,52706000,48652401,51329654,51829582,52681491,null,463839605,825556367]
["WA025I",null,{"$f":"C14","v":36822962},{"$f":"D14","v":38444830},38253213,33280210,36585435,37109668,34770564,35823113,36584911,37391600,35111801,36043336,36841235,35372228,35675190,35874371,36467467,35575817,35681264,36370128,35624529,35686729,35713922,35996684,35704864,35572111,36025965,35721817,null,{"$f":"SUM(B24:K24)","v":327674906},{"$f":"SUM(B24:R24)","v":579984667}]
["WA031/32",null,{"$f":"C15+C16","v":5935825.356991414},{"$f":"D15+D16","v":13111416.405416997},20733956.509573527,25410501.282079004,28523535.656824239,22331575.297284823,12097274.584637048,2827877.1280326489,3789741.9540799949,4931291.7146152025,3646896.8294098517,4740668.6377395401,5851133.9732547225,12768759.707577553,20688145.23298661,26230712.396206092,{"$f":"S15+S16","v":28575600.96416897},21043593.052168407,11694673.393642556,3098492.533733455,3635586.4702552389,4691168.9335967461,4117271.9675771226,4965164.3851606306,5915233.0535734408,12802467.596100824,20740880.777882572,25669603.033647154,null,134761704.17491969,213619312.66670921]
["WA04X",null,{"$f":"C17","v":1302550.6210047223},{"$f":"D17","v":1337105.588589699},1331504.852722174,1333836.0243040216,1334110.298731857,1302325.5008865951,1306182.7894858946,1320266.0382451359,1319835.5894288972,1312052.5670342222,1282781.9397454073,1346978.8782308577,1282521.0688841238,1322804.2761951154,1311334.1459539002,1318291.5221090443,{"$f":"S17","v":1317500.1690632126},1269268.4803722838,1295238.796120883,1305931.2342727571,1304157.7672317254,1271052.7874755026,1281690.8657831096,1330206.771087918,1265826.8516803812,1299825.2317412151,1293536.9214742235,1298088.8774713338,null,11887717.303398997,21064481.701551668]
["Total",null,{"$f":"SUM(C20:C26)","v":424457535.85307389},{"$f":"SUM(D20:D26)","v":432045561.30552435},{"$f":"SUM(E20:E26)","v":449102241.51845515},496074959.63225627,501057293.45340079,419765898.7550928,442239975.14205337,507252195.9277885,577047933.44211042,600100379.15748477,492083795.72733986,488869232.44917005,441703379.62858933,430043425.15492988,442437211.07208484,493174091.66277754,501849921.52250767,421561881.78211182,444469368.468889,504496752.95494843,577933318.21828306,601623195.5121305,495862853.05315447,491750300.25649589,443291448.5939703,431577496.89223057,443757775.55279195,494526044.38874859,null,4249043595.0297561,7637455109.8821325]
[]
[]
[]
[]
[]
[null,null,{"$f":"SUM(C34:C46)-C18","v":0},{"$f":"SUM(D34:D46)-D18","v":0},{"$f":"SUM(E34:E46)-E18","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,190974480.04255751,176113563.99794334,176459747.14482352,204494293.77636918,206259283.56051493,159643326.96820152,178363982.37041521,242351481.9950045,307050289.00418437,317280238.33108574,250037504.83744782,235738741.94394654,203081802.9519473,179305893.01266021,174831177.44667855,201206856.72398505,210594571.25405914,166271024.42692161,182564364.39761642,239376768.07710078,308701003.05608219,322620935.17708409,253550219.47452879,240183342.11028618,206814403.0390749,182580160.98159546,177592148.47885174,204190821.41307005]
["WA_2",null,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,0,0]
["WA_11",null,44505030.740235828,45319752.312614642,46610336.537707575,54261410.599342637,53136040.025286131,46541171.155685663,47886683.041062959,53332265.977024563,58497747.134299822,60205061.836916625,50590770.642111346,50261447.613757968,46208921.193996951,44941470.828402027,46626698.818491243,53987155.322187297,53306781.724556103,46495560.206150219,48249152.911720045,54090408.013270758,59277692.966561735,60907202.64861007,50813625.984745651,50765941.03569372,46468057.374580719,45266415.540814802,47006684.777793415,54483664.444240987]
["WA_12",null,5198903.1001128182,4753714.6548626544,4164591.0766567746,4883066.2147459351,4653699.7262009671,4223070.0060625216,4890603.1796568315,6780978.4173007645,8818978.6222678348,9009819.280999897,6965651.118934704,6928542.2236513831,5496875.195919849,4759346.7977888845,4291474.5597085208,4926580.2223867774,4703905.5425061807,4270550.5786894159,4939645.4327269178,6978940.9515340878,8887598.9893154651,9153749.7623111252,7094480.0241042599,7108960.0266449852,5647225.04825556,4816701.5495859291,4484102.9877841482,5117251.9475971535]
["WA_13",null,48461.522387760371,47609.697628676557,46924.943581981388,48337.599910880206,49790.57545462437,53455.225045724161,52564.831686201615,51256.334415148762,48603.374858187948,49212.536531993901,49905.954076148548,50450.083326513843,50520.879712055008,50526.196660210269,50514.239066556489,50383.142803406125,50224.234887912869,50094.833682465149,50194.829547705282,50280.856783593656,50334.864276807006,50351.979254418424,50336.431975261599,50305.441110467618,50273.111581769866,50261.401658639617,50270.037646278615,50292.693649831141]
["WA_21",null,89428573.588562652,99113820.379948333,106352506.09328224,117071370.08318955,108747891.86583877,96497166.434410408,109097265.18839911,112608199.61196499,107840814.19530877,110565483.50506565,93803579.448655635,97389724.527919933,91818317.228006646,97734975.771400809,104366294.88677663,114322032.83067955,106487171.36519435,94254122.592321366,106787954.54105848,111425414.1302195,106588324.9113749,109431954.32369708,92185194.992214426,95763589.95675756,90286117.656892255,95571799.003861457,102439099.49123089,112644399.6052018]
["WA_22",null,2235043.5875412175,2155873.5991906486,2118786.8980851681,2480446.9103859947,2330295.1245238213,2058838.7299511994,2228802.5798980366,2711962.6916996525,3473548.7871100623,3544813.6089474373,2802666.3636500253,2708555.8741516685,2286440.5295534027,2089542.0450797365,2080682.6791560946,2453455.9105025874,2345531.4630078557,2046379.2360456313,2271396.3532728944,2746618.1793687236,3421545.9545651916,3534555.7788258377,2783386.8283637594,2687422.9972332953,2294288.0647988268,2095280.3326226494,2102646.7457075058,2475755.8225156609]
["WA_23",null,179993.29368,185451.66932933332,186471.46202219996,202449.14192908257,200266.62002546733,183089.43756432566,182633.57681210921,196264.7341010996,196340.78057245479,196071.77628796455,193596.59330891623,191590.66644561035,191969.60731424994,192270.51916535987,192436.0632666958,192574.59191777013,192715.80506393936,193320.37576039587,193094.81318312828,192889.97866476115,192752.23861987508,192679.12127575383,192645.48386213806,192683.5325211281,192759.39353245281,192820.25424964691,192858.33442116514,192858.55135462174]
["WA_25",null,47825712,51462423,52844203,52609038,59236945,49822212,51363419,49248530,49427123,55614734,47598641,53469196,48593642,51505608,52323263,52611678,57808452,50092151,50742389,48860881,50249792,54082816,48080079,52706000,48652401,51329654,51829582,52681491]
["WA_31",null,5502618.6885915119,12395651.244028438,19701055.938252218,23673980.601589113,26583414.787156716,21256596.556735978,11530327.64336041,2476142.828225363,3386382.4626985262,4447959.0894974768,3261283.3623971911,4359897.3973822482,5428370.6720306799,12126309.068046305,19713389.648264095,24561593.9447411,26669643.838447478,20047432.615732528,11162597.2832499,2759565.957522322,3247143.2793029789,4250113.4100802066,3741364.8017945364,4594475.3108308576,5487156.9682067037,12114704.123934943,19716146.083762489,23902470.498115566]
["WA_32",null,433206.66839990241,715765.16138855903,1032900.5713213077,1736520.6804898917,1940120.8696675238,1074978.7405488463,566946.94127663749,351734.29980728577,403359.49138146872,483332.62511772581,385613.46701266052,380771.24035729188,422763.30122404272,642450.63953124778,974755.5847225138,1669118.4514649927,1905957.1257214933,996160.43643587991,532076.11039265699,338926.57621113304,388443.19095226011,441055.52351653931,375907.16578258615,370689.07432977285,428076.08536673721,687763.47216588142,1024734.6941200818,1767132.5355315863]
["WA_4X",null,1302550.6210047223,1337105.588589699,1331504.852722174,1333836.0243040216,1334110.298731857,1302325.5008865951,1306182.7894858946,1320266.0382451359,1319835.5894288972,1312052.5670342222,1282781.9397454073,1346978.8782308577,1282521.0688841238,1322804.2761951154,1311334.1459539002,1318291.5221090443,1317500.1690632126,1269268.4803722838,1295238.796120883,1305931.2342727571,1304157.7672317254,1271052.7874755026,1281690.8657831096,1330206.771087918,1265826.8516803812,1299825.2317412151,1293536.9214742235,1298088.8774713338]
["WA_25I",null,36822962,38444830,38253213,33280210,36585435,37109668,34770564,35823113,36584911,37391600,35111801,36043336,36841235,35372228,35675190,35874371,36467467,35575817,35681264,36370128,35624529,35686729,35713922,35996684,35704864,35572111,36025965,35721817]

{"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 SEPTEMBER 30, 2021"]
[]
["Line "]
["No.",null,"Description",null,"Factor"]
[]
[1,null,"Revenues",null,1]
[]
[null,null,"Expense:"]
[2,null,"  Uncollectibles",null,3.326E-3]
[]
[3,null,"  Commission Fees",null,2E-3]
[]
[4,null,"  Washington Excise Tax",null,3.8605E-2]
[]
[5,null,"  Franchise Fees",null,0]
[]
[6,null,"    Total Expense",null,{"$f":"E12+E14+E16+E18","v":4.3930999999999998E-2}]
[]
[7,null,"Net Operating Income Before FIT",null,{"$f":"E9-E20","v":0.95606900000000006}]
[]
[8,null,"  Federal Income Tax @ 21%",null,0.20077400000000001]
[]
[9,null,"REVENUE CONVERSION FACTOR",null,{"$f":"E22-E24","v":0.75529500000000005}]
[]
[]
["Source:  UE-220053"]

{"sheet":"Base Revenue","index":6,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":false,"merged":[[4,0,4,3],[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3]]}
["AVISTA UTILITIES"]
["WASHINGTON ELECTRIC"]
["PROPOSED INCREASE BY SERVICE SCHEDULE"]
["12 MONTHS ENDED SEPTEMBER, 2021"]
["(000s of Dollars)"]
["Source:  UE-220053 Compliance Filing, Attachment A, Page 1, Rate Year 2 effective 12/21/2023"]
[]
[null,null,null,"Base Tariff"]
[null,null,null,"Revenue"]
[null,"Type of","Schedule","Under Proposed"]
["No.","Service","Number","Rates"]
[null,"(a)","(b)","(e)"]
[]
[1,"Residential","1/2",285802]
[]
[2,"General Service","11/12",86753]
[]
[3,"Large General Service","21/22",139487]
[]
[4,"Extra Large General Service",25,42461]
[]
[5,"Extra Large General Service",25,22430]
[]
[6,"Pumping Service","30/31/32",16438]
[]
[7,"Street & Area Lights","41-48",7337]
[]
[8,"Total",null,{"$f":"SUM(D14:D26)","v":600708}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"reduce billed revenue for BPA ResEx (already accounted for in Schs 1 & 48)"]
[null,null,null,"Billing"]
[null,null,null,"Determinants"]
[null,"Schedule 12 only",null,{"$f":"'[3]Rev Runs 12MESEPT2014'!P49+'[3]Rev Runs 12MESEPT2014'!P81+'[3]Rev Runs 12MESEPT2014'!P90","v":57963673}]
[null,"Schedule 22 only",null,{"$f":"'[3]Rev Runs 12MESEPT2014'!P51+'[3]Rev Runs 12MESEPT2014'!P83+'[3]Rev Runs 12MESEPT2014'!P92","v":36956089}]
[null,"Schedule 32 only",null,{"$f":"'[3]Rev Runs 12MESEPT2014'!P55+'[3]Rev Runs 12MESEPT2014'!P86+'[3]Rev Runs 12MESEPT2014'!P95","v":8649684}]
[]
[null,"Total",null,{"$f":"SUM(D43:D46)","v":103569446}]