{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["WA Electric - Sched 88","Revenue By Month","Rev Conv Factor","Billing Determinants"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":3,"comments":1,"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 88","index":0,"n_rows":32,"n_cols":9,"rows_kept":32,"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","SCH. 1,2","SCH. 11,12","SCH. 21,22","SCHEDULE 25","SCH. 30, 31, 32","SCH. 41-48"]
[]
["Forecast","Total Forecasted kWh's",{"$f":"SUM(D7:I7)","v":5755749640.5242996},{"$f":"SUM('Revenue By Month'!D5:O5)","v":2457576113.5959029},{"$f":"SUM('Revenue By Month'!D6:O6)","v":626701861.81597829},{"$f":"SUM('Revenue By Month'!D7:O7)","v":1407436238.5722947},{"$f":"SUM('Revenue By Month'!D8:O8)","v":1117030437.2165196},{"$f":"SUM('Revenue By Month'!D9:O9)","v":129131056.59664847},{"$f":"SUM('Revenue By Month'!D10:O10)","v":17873932.726955552}]
[]
["UE-150204","Base Revenue",{"$f":"SUM(D9:I9)","v":491872000},211363000,70145000,128034000,64138000,11284000,6908000]
[]
[null,"Percentage of Current Base Volumetric Revenue",{"$f":"SUM(D11:I11)","v":1},{"$f":"D9/$C$9","v":0.4297113883286709},0.14260823954199467,0.26029942749333163,0.13039571270574457,2.2940927721033115E-2,1.4044304209225164E-2]
[]
[null,"Revenue Requirement ",1200000]
[]
[null,"Revenue Spread Based on Current Allocation",{"$f":"SUM(D15:I15)","v":1200000},{"$f":"$C$13*D11","v":515653.66599440505},{"$f":"$C$13*E11","v":171129.88745039361},312359.31299199793,156474.85524689348,27529.113265239739,{"$f":"$C$13*I11","v":16853.165051070195}]
[]
[null,"Proposed Rates",null,{"$f":"D15/D7","v":2.0982205317739085E-4},2.7306427166901151E-4,2.2193496545808402E-4,1.4008110256763143E-4,2.1318739264427456E-4,{"$f":"I15/I7","v":9.4289070617648994E-4}]
[]
[null,"Present Billed Revenue",{"$f":"SUM(D19:I19)","v":523529000},227178000,77451000,133184000,67050000,11443000,7223000]
[]
[null,"Proposed Billed Revenue",{"$f":"SUM(D21:I21)","v":524728999.99999994},{"$f":"D15+D19","v":227693653.66599441},{"$f":"E15+E19","v":77622129.887450397},133496359.31299199,67206474.855246887,11470529.113265241,7239853.16505107]
[]
[null,"Overall Billed Percentage Increase <Decrease>",{"$f":"C21/C19-1","v":2.292136634264752E-3},{"$f":"D21/D19-1","v":2.2698221922650141E-3},{"$f":"E21/E19-1","v":2.2095245697331123E-3},{"$f":"F21/F19-1","v":2.3453216076405603E-3},2.3337040305277945E-3,2.4057601385336636E-3,2.3332638863449162E-3]
[]
[null,"Average Monthly Bill @ 938 kWh's - Increase <Decrease>",null,{"$f":"ROUND(D17,5)*938","v":0.19698000000000002}]
[]
[]
[null,null,"Present","Proposed","Change"]
[null,"Gross R&D Revenue",0,{"$f":"C15","v":1200000},{"$f":"D29-C29","v":1200000}]
[null,"Revenue Conversion Factor",{"$f":"'Rev Conv Factor'!E22","v":0.95385319887040521},{"$f":"'Rev Conv Factor'!E22","v":0.95385319887040521}]
[]
[null,"Net R&D Revenue ",{"$f":"C29*C30","v":0},{"$f":"D29*D30","v":1144623.8386444862},{"$f":"D32-C32","v":1144623.8386444862}]

{"sheet":"Revenue By Month","index":1,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Forecasted Usage",null,null,"2018-01-01","2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01"]
[null,"Residential Schedule 001/002",null,{"$f":"'Billing Determinants'!B19","v":276988691.23352349},{"$f":"'Billing Determinants'!C19","v":221800956.18741477},{"$f":"'Billing Determinants'!D19","v":217487024.82509917},{"$f":"'Billing Determinants'!E19","v":180931205.26870883},{"$f":"'Billing Determinants'!F19","v":165504786.80450183},{"$f":"'Billing Determinants'!G19","v":159180004.84981185},{"$f":"'Billing Determinants'!H19","v":194722364.15325752},{"$f":"'Billing Determinants'!I19","v":184091057.52748036},{"$f":"'Billing Determinants'!J19","v":157560688.52248412},{"$f":"'Billing Determinants'!K19","v":181198329.48622},{"$f":"'Billing Determinants'!L19","v":228683387.43968645},{"$f":"'Billing Determinants'!M19","v":289427617.29771477}]
[null,"General Svc Schedule 011/012",null,{"$f":"'Billing Determinants'!B20","v":61193498.039898932},{"$f":"'Billing Determinants'!C20","v":51637801.686451077},{"$f":"'Billing Determinants'!D20","v":52777939.273260735},{"$f":"'Billing Determinants'!E20","v":47067094.804081216},{"$f":"'Billing Determinants'!F20","v":46794956.499775536},{"$f":"'Billing Determinants'!G20","v":46841566.90901117},{"$f":"'Billing Determinants'!H20","v":55570138.20354601},{"$f":"'Billing Determinants'!I20","v":52554129.58545965},{"$f":"'Billing Determinants'!J20","v":46416735.866216689},{"$f":"'Billing Determinants'!K20","v":50028020.697334945},{"$f":"'Billing Determinants'!L20","v":53972345.10518676},{"$f":"'Billing Determinants'!M20","v":61847635.145755552}]
[null,"Large Gen Svc Schedule 021/022",null,{"$f":"'Billing Determinants'!B21","v":123159634.30691627},{"$f":"'Billing Determinants'!C21","v":106529006.72299543},{"$f":"'Billing Determinants'!D21","v":113991240.27262263},{"$f":"'Billing Determinants'!E21","v":108120868.36114801},{"$f":"'Billing Determinants'!F21","v":112835474.49912792},{"$f":"'Billing Determinants'!G21","v":113945299.39318484},{"$f":"'Billing Determinants'!H21","v":131530141.39469275},{"$f":"'Billing Determinants'!I21","v":124102703.99568848},{"$f":"'Billing Determinants'!J21","v":112087462.24230941},{"$f":"'Billing Determinants'!K21","v":118940759.07376145},{"$f":"'Billing Determinants'!L21","v":116959975.20762961},{"$f":"'Billing Determinants'!M21","v":125233673.1022177}]
[null,"Extra Large Gen Schedule 25",null,{"$f":"'Billing Determinants'!B22","v":91954920.140190691},{"$f":"'Billing Determinants'!C22","v":91680623.330278397},{"$f":"'Billing Determinants'!D22","v":89975531.042652205},{"$f":"'Billing Determinants'!E22","v":91951519.832541332},{"$f":"'Billing Determinants'!F22","v":92774510.056144252},{"$f":"'Billing Determinants'!G22","v":92304315.923737437},{"$f":"'Billing Determinants'!H22","v":92381168.796519667},{"$f":"'Billing Determinants'!I22","v":95801534.501396626},{"$f":"'Billing Determinants'!J22","v":96058766.262987971},{"$f":"'Billing Determinants'!K22","v":94925036.03878656},{"$f":"'Billing Determinants'!L22","v":94112428.564483255},{"$f":"'Billing Determinants'!M22","v":93110082.726801127}]
[null,"Pumping Schedule 31/32",null,{"$f":"'Billing Determinants'!B23","v":4026613.1143102683},{"$f":"'Billing Determinants'!C23","v":3512438.1874267613},{"$f":"'Billing Determinants'!D23","v":4392576.2785208877},{"$f":"'Billing Determinants'!E23","v":7255298.1315080794},{"$f":"'Billing Determinants'!F23","v":12858892.158851212},{"$f":"'Billing Determinants'!G23","v":17164120.109027181},{"$f":"'Billing Determinants'!H23","v":23738064.619275883},{"$f":"'Billing Determinants'!I23","v":23355253.281981029},{"$f":"'Billing Determinants'!J23","v":15917342.082980765},{"$f":"'Billing Determinants'!K23","v":8783785.5529983081},{"$f":"'Billing Determinants'!L23","v":4231260.1438364778},{"$f":"'Billing Determinants'!M23","v":3895412.9359316025}]
[null,"Street and Area Lights",null,{"$f":"'Billing Determinants'!B24","v":1525945.0664072267},{"$f":"'Billing Determinants'!C24","v":1504210.6625064076},{"$f":"'Billing Determinants'!D24","v":1506535.1899971869},{"$f":"'Billing Determinants'!E24","v":1503052.4514471977},{"$f":"'Billing Determinants'!F24","v":1495752.0990312933},{"$f":"'Billing Determinants'!G24","v":1491875.9970526437},{"$f":"'Billing Determinants'!H24","v":1487548.7332422216},{"$f":"'Billing Determinants'!I24","v":1479929.0624368056},{"$f":"'Billing Determinants'!J24","v":1467615.2121774405},{"$f":"'Billing Determinants'!K24","v":1467813.8842941311},{"$f":"'Billing Determinants'!L24","v":1471889.944256285},{"$f":"'Billing Determinants'!M24","v":1471764.4241067106}]
["Total Forecasted Usage",null,null,{"$f":"SUM(D5:D10)","v":558849301.90124691},476665036.77707279,480130846.8821528,436829038.84943461,432264372.117432,430927183.18182522,499429425.90053403,481384607.95444304,429508610.18915641,455343744.73339546,499431286.40507889,574986185.63252747]
[null,null,null,{"$f":"D11-'Billing Determinants'!B25","v":0},{"$f":"E11-'Billing Determinants'!C25","v":0},{"$f":"F11-'Billing Determinants'!D25","v":0},{"$f":"G11-'Billing Determinants'!E25","v":0},{"$f":"H11-'Billing Determinants'!F25","v":0},{"$f":"I11-'Billing Determinants'!G25","v":0},{"$f":"J11-'Billing Determinants'!H25","v":0},{"$f":"K11-'Billing Determinants'!I25","v":0},{"$f":"L11-'Billing Determinants'!J25","v":0},{"$f":"M11-'Billing Determinants'!K25","v":0},{"$f":"N11-'Billing Determinants'!L25","v":0},{"$f":"O11-'Billing Determinants'!M25","v":0}]
[]
["R&D Rates"]
[null,"Residential Schedule 001/002",null,{"$f":"'WA Electric - Sched 88'!$D$17","v":2.0982205317739085E-4},{"$f":"'WA Electric - Sched 88'!$D$17","v":2.0982205317739085E-4},{"$f":"'WA Electric - Sched 88'!$D$17","v":2.0982205317739085E-4},{"$f":"'WA Electric - Sched 88'!$D$17","v":2.0982205317739085E-4},{"$f":"'WA Electric - Sched 88'!$D$17","v":2.0982205317739085E-4},{"$f":"'WA Electric - Sched 88'!$D$17","v":2.0982205317739085E-4},{"$f":"'WA Electric - Sched 88'!$D$17","v":2.0982205317739085E-4},{"$f":"'WA Electric - Sched 88'!$D$17","v":2.0982205317739085E-4},{"$f":"'WA Electric - Sched 88'!$D$17","v":2.0982205317739085E-4},{"$f":"'WA Electric - Sched 88'!$D$17","v":2.0982205317739085E-4},{"$f":"'WA Electric - Sched 88'!$D$17","v":2.0982205317739085E-4},{"$f":"'WA Electric - Sched 88'!$D$17","v":2.0982205317739085E-4}]
[null,"General Svc Schedule 011/012",null,{"$f":"'WA Electric - Sched 88'!$E$17","v":2.7306427166901151E-4},{"$f":"'WA Electric - Sched 88'!$E$17","v":2.7306427166901151E-4},{"$f":"'WA Electric - Sched 88'!$E$17","v":2.7306427166901151E-4},{"$f":"'WA Electric - Sched 88'!$E$17","v":2.7306427166901151E-4},{"$f":"'WA Electric - Sched 88'!$E$17","v":2.7306427166901151E-4},{"$f":"'WA Electric - Sched 88'!$E$17","v":2.7306427166901151E-4},{"$f":"'WA Electric - Sched 88'!$E$17","v":2.7306427166901151E-4},{"$f":"'WA Electric - Sched 88'!$E$17","v":2.7306427166901151E-4},{"$f":"'WA Electric - Sched 88'!$E$17","v":2.7306427166901151E-4},{"$f":"'WA Electric - Sched 88'!$E$17","v":2.7306427166901151E-4},{"$f":"'WA Electric - Sched 88'!$E$17","v":2.7306427166901151E-4},{"$f":"'WA Electric - Sched 88'!$E$17","v":2.7306427166901151E-4}]
[null,"Large Gen Svc Schedule 021/022",null,{"$f":"'WA Electric - Sched 88'!$F$17","v":2.2193496545808402E-4},{"$f":"'WA Electric - Sched 88'!$F$17","v":2.2193496545808402E-4},{"$f":"'WA Electric - Sched 88'!$F$17","v":2.2193496545808402E-4},{"$f":"'WA Electric - Sched 88'!$F$17","v":2.2193496545808402E-4},{"$f":"'WA Electric - Sched 88'!$F$17","v":2.2193496545808402E-4},{"$f":"'WA Electric - Sched 88'!$F$17","v":2.2193496545808402E-4},{"$f":"'WA Electric - Sched 88'!$F$17","v":2.2193496545808402E-4},{"$f":"'WA Electric - Sched 88'!$F$17","v":2.2193496545808402E-4},{"$f":"'WA Electric - Sched 88'!$F$17","v":2.2193496545808402E-4},{"$f":"'WA Electric - Sched 88'!$F$17","v":2.2193496545808402E-4},{"$f":"'WA Electric - Sched 88'!$F$17","v":2.2193496545808402E-4},{"$f":"'WA Electric - Sched 88'!$F$17","v":2.2193496545808402E-4}]
[null,"Extra Large Gen Schedule 25",null,{"$f":"'WA Electric - Sched 88'!$G$17","v":1.4008110256763143E-4},{"$f":"'WA Electric - Sched 88'!$G$17","v":1.4008110256763143E-4},{"$f":"'WA Electric - Sched 88'!$G$17","v":1.4008110256763143E-4},{"$f":"'WA Electric - Sched 88'!$G$17","v":1.4008110256763143E-4},{"$f":"'WA Electric - Sched 88'!$G$17","v":1.4008110256763143E-4},{"$f":"'WA Electric - Sched 88'!$G$17","v":1.4008110256763143E-4},{"$f":"'WA Electric - Sched 88'!$G$17","v":1.4008110256763143E-4},{"$f":"'WA Electric - Sched 88'!$G$17","v":1.4008110256763143E-4},{"$f":"'WA Electric - Sched 88'!$G$17","v":1.4008110256763143E-4},{"$f":"'WA Electric - Sched 88'!$G$17","v":1.4008110256763143E-4},{"$f":"'WA Electric - Sched 88'!$G$17","v":1.4008110256763143E-4},{"$f":"'WA Electric - Sched 88'!$G$17","v":1.4008110256763143E-4}]
[null,"Pumping Schedule 31/32",null,{"$f":"'WA Electric - Sched 88'!$H$17","v":2.1318739264427456E-4},{"$f":"'WA Electric - Sched 88'!$H$17","v":2.1318739264427456E-4},{"$f":"'WA Electric - Sched 88'!$H$17","v":2.1318739264427456E-4},{"$f":"'WA Electric - Sched 88'!$H$17","v":2.1318739264427456E-4},{"$f":"'WA Electric - Sched 88'!$H$17","v":2.1318739264427456E-4},{"$f":"'WA Electric - Sched 88'!$H$17","v":2.1318739264427456E-4},{"$f":"'WA Electric - Sched 88'!$H$17","v":2.1318739264427456E-4},{"$f":"'WA Electric - Sched 88'!$H$17","v":2.1318739264427456E-4},{"$f":"'WA Electric - Sched 88'!$H$17","v":2.1318739264427456E-4},{"$f":"'WA Electric - Sched 88'!$H$17","v":2.1318739264427456E-4},{"$f":"'WA Electric - Sched 88'!$H$17","v":2.1318739264427456E-4},{"$f":"'WA Electric - Sched 88'!$H$17","v":2.1318739264427456E-4}]
[null,"Street and Area Lights",null,{"$f":"'WA Electric - Sched 88'!$I$17","v":9.4289070617648994E-4},{"$f":"'WA Electric - Sched 88'!$I$17","v":9.4289070617648994E-4},{"$f":"'WA Electric - Sched 88'!$I$17","v":9.4289070617648994E-4},{"$f":"'WA Electric - Sched 88'!$I$17","v":9.4289070617648994E-4},{"$f":"'WA Electric - Sched 88'!$I$17","v":9.4289070617648994E-4},{"$f":"'WA Electric - Sched 88'!$I$17","v":9.4289070617648994E-4},{"$f":"'WA Electric - Sched 88'!$I$17","v":9.4289070617648994E-4},{"$f":"'WA Electric - Sched 88'!$I$17","v":9.4289070617648994E-4},{"$f":"'WA Electric - Sched 88'!$I$17","v":9.4289070617648994E-4},{"$f":"'WA Electric - Sched 88'!$I$17","v":9.4289070617648994E-4},{"$f":"'WA Electric - Sched 88'!$I$17","v":9.4289070617648994E-4},{"$f":"'WA Electric - Sched 88'!$I$17","v":9.4289070617648994E-4}]
[]
[]
["Gross R&D Revenue",null,null,"January","February","March","April","May","June","July","August","September","October","November","December"]
[null,"Residential Schedule 001/002",null,{"$f":"D5*D15","v":58118.335901536258},46538.732023951881,45633.574088244481,37963.356973340444,34726.554178006918,33399.475442374554,40857.046246192062,38626.3636620131,33059.70716583098,38019.405525112044,47982.817880155766,60728.296907646632]
[null,"General Svc Schedule 011/012",null,{"$f":"D6*D16","v":16709.757973144086},14100.438708099617,14411.76954784426,12852.341962252753,12778.030714394283,12790.758351844406,15174.219315097602,14350.655118452389,12674.752172561344,13660.86503476,14737.919106416361,16888.379445526498]
[null,"Large Gen Svc Schedule 021/022",null,{"$f":"D7*D17","v":27333.42918573572},23642.51142735199,25298.641972428661,23995.801185029435,25042.137135410478,25288.446084937521,29191.137387128041,27542.729324537948,24876.127061031235,26397.11325659354,25957.508057683641,27793.730914129672]
[null,"Extra Large Gen Schedule 25",null,{"$f":"D8*D18","v":12881.14659975641},12842.722800193111,12603.871592562869,12880.670280911818,12995.955658836498,12930.090346348119,12940.855981502944,13419.984580626622,13456.017889405752,13297.20370958537,13183.372758630265,13042.963048533677]
[null,"Pumping Schedule 31/32",null,{"$f":"D9*D19","v":858.42315102704833},748.80753900169304,936.44188380895878,1546.7380915130846,2741.3536916393969,3659.1740130766661,5060.6561026047293,4979.0455517321716,3393.3766564976554,1872.5923395901566,902.05131766413683,830.4529270840369]
[null,"Street and Area Lights",null,{"$f":"D10*D20","v":1438.7994212512408},1418.3062538088725,1420.4980291761799,1417.2141873653527,1410.3307529205833,1406.6760123887223,1402.5958755587014,1395.4113587721504,1383.800743805346,1383.9880698977499,1387.831348953883,1387.7129971714114]
[null,"Total",null,{"$f":"SUM(D24:D29)","v":117339.89223245076},99291.518752407152,100304.7971140654,90656.122680412867,89694.362131208152,89474.620250969994,104626.51090808408,100314.18959613438,{"$f":"SUM(L24:L29)","v":88843.781689132302},94631.167935538877,104151.50046950407,120671.53624009194,null,{"$f":"SUM(D30:O30)-'WA Electric - Sched 88'!D29","v":0}]
[]
["Net R&D Revenue",null,{"$f":"'Rev Conv Factor'!E22","v":0.95385319887040521},"January","February","March","April","May","June","July","August","September","October","November","December"]
[null,"Residential Schedule 001/002",null,{"$f":"D24*$C$32","v":55436.360612705073},44391.11841241907,43527.730619961636,36211.469488879884,33124.03478843833,31858.196491302511,38971.624258326381,36843.880539742771,31534.107433846737,36264.931579279284,45768.564325802654,57925.88026731048]
[null,"General Svc Schedule 011/012",null,{"$f":"D25*$C$32","v":15938.656095033744},13449.748567196903,13746.71248459434,12259.24749367113,12188.365472189276,12200.505769885138,14473.977634066936,13688.418290621765,12089.852904687255,13030.459812742694,14057.811284348509,16109.034757852651]
[null,"Large Gen Svc Schedule 021/022",null,{"$f":"D26*$C$32","v":26072.078864911713},22551.485154309805,24131.190572478175,22888.471719798588,23886.522613162651,24121.465192579428,27844.059775377566,26271.720471832235,23728.173372671296,25178.970920746127,24759.65209552586,26511.139140985859]
[null,"Extra Large Gen Schedule 25",null,{"$f":"D27*$C$32","v":12286.722889296294},12250.072225170086,12022.243236717921,12286.268551042698,12396.233877559138,12333.408038547499,12343.676874077801,12800.695221022217,12835.065707867074,12683.580294419424,12575.002277720436,12441.072026592339]
[null,"Pumping Schedule 31/32",null,{"$f":"D28*$C$32","v":818.80966859156297},714.25246641504066,893.2280864274037,1475.3610764044613,2614.8489880054331,3490.3148375966362,4827.1230118525582,4749.2785268411935,3236.783178772449,1786.1781932982869,860.42453489920092,792.13018101039995]
[null,"Street and Area Lights",null,{"$f":"D29*$C$32","v":1372.4034304933837},1352.8559571734938,1354.9465891188054,1351.8142861029635,1345.2485001386056,1341.7624141912484,1337.8705626241042,1331.0175883049144,1319.9427660779754,1320.1214476704467,1323.7873716922909,1323.6744814659883]
[null,"Total",null,{"$f":"SUM(D33:D38)","v":111925.03156103178},94709.5327826844,95676.051589298266,86472.632615899725,85555.254239493428,85345.652744102466,99798.332116325342,95685.0106383651,84743.925363922783,90264.242248156268,99345.241889988945,115102.93085521774,null,{"$f":"SUM(D39:O39)-'WA Electric - Sched 88'!D32","v":0}]

{"sheet":"Rev Conv Factor","index":2,"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, 2014"]
[]
["Line "]
["No.",null,"Description",null,"Factor"]
[]
[1,null,"Revenues",null,1]
[]
[null,null,"Expense:"]
[2,null,"  Uncollectibles",null,5.6309087490816921E-3]
[]
[3,null,"  Commission Fees",null,2E-3]
[]
[4,null,"  Washington Excise Tax",null,3.8515892380513068E-2]
[]
[5,null,"  Franchise Fees",null,0]
[]
[6,null,"    Total Expense",null,{"$f":"E12+E14+E16+E18","v":4.614680112959476E-2}]
[]
[7,null,"Net Operating Income Before FIT",null,{"$f":"E9-E20","v":0.95385319887040521}]
[]
[8,null,"  Federal Income Tax @ 35%",null,0.33384900000000001]
[]
[9,null,"REVENUE CONVERSION FACTOR",null,{"$f":"E22-E24","v":0.62000419887040525}]
[]
[]
["Source:  UE-150204"]

{"sheet":"Billing Determinants","index":3,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Forecasted Loads"]
[]
[]
[null,"2018-01-01","2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01","2018-08-01","2018-09-01","2018-10-01","2018-11-01","2018-12-01"]
["WA001",276988691.23352349,221800956.18741477,217487024.82509917,180931205.26870883,165504786.80450183,159180004.84981185,194722364.15325752,184091057.52748036,157560688.52248412,181198329.48622,228683387.43968645,289427617.29771477]
["WA011",54396406.975658566,46064187.058452941,47384712.456686154,42599874.792132966,42625273.200821601,42911599.208197169,51160267.011545472,48305210.112373255,42472071.513467237,45506959.016959988,48493203.498039573,55018750.294665113]
["WA012",6797091.0642403662,5573614.6279981397,5393226.81657458,4467220.0119482484,4169683.2989539341,3929967.7008139975,4409871.1920005381,4248919.4730863925,3944664.3527494543,4521061.6803749613,5479141.607147187,6828884.8510904405]
["WA021",119785442.17422071,103726092.49836475,111192947.35589856,105676884.07343714,110438901.86648306,111595767.80093133,128779332.78404483,121490885.02102351,109755614.70641792,116414982.72033384,114186826.06901863,121940147.59064819]
["WA022",3374192.1326955515,2802914.2246306897,2798292.9167240681,2443984.2877108753,2396572.6326448624,2349531.5922535108,2750808.6106479224,2611818.9746649642,2331847.5358914919,2525776.3534276001,2773149.1386109758,3293525.511569513]
["WA025",91954920.140190691,91680623.330278397,89975531.042652205,91951519.832541332,92774510.056144252,92304315.923737437,92381168.796519667,95801534.501396626,96058766.262987971,94925036.03878656,94112428.564483255,93110082.726801127]
["WA031",3733492.1267063362,3265283.2220228999,4124007.1718869279,6769360.669073917,12065991.791762078,15995304.544423161,21975557.841599174,21766114.929709442,14925026.741142521,8244182.9589787452,3948466.5887096962,3616330.7470466699]
["WA032",293120.9876039321,247154.96540386151,268569.10663395945,485937.46243416233,792900.36708913429,1168815.5646040207,1762506.7776767076,1589138.3522715869,992315.34183824365,539602.59401956294,282793.55512678117,279082.18888493231]
["WA04X",1525945.0664072267,1504210.6625064076,1506535.1899971869,1503052.4514471977,1495752.0990312933,1491875.9970526437,1487548.7332422216,1479929.0624368056,1467615.2121774405,1467813.8842941311,1471889.944256285,1471764.4241067106]
[null,{"$f":"SUM(B8:B16)","v":558849301.90124679},476665036.77707285,480130846.8821528,436829038.84943467,432264372.117432,430927183.18182522,499429425.90053403,481384607.95444304,429508610.18915641,455343744.73339552,499431286.40507889,574986185.63252747]
[]
["WA001",{"$f":"B8","v":276988691.23352349},221800956.18741477,217487024.82509917,180931205.26870883,165504786.80450183,159180004.84981185,194722364.15325752,184091057.52748036,157560688.52248412,181198329.48622,228683387.43968645,289427617.29771477]
["WA011/12",{"$f":"B9+B10","v":61193498.039898932},51637801.686451077,52777939.273260735,47067094.804081216,46794956.499775536,46841566.90901117,55570138.20354601,52554129.58545965,46416735.866216689,50028020.697334945,53972345.10518676,61847635.145755552]
["WA021/22",{"$f":"B11+B12","v":123159634.30691627},106529006.72299543,113991240.27262263,108120868.36114801,112835474.49912792,113945299.39318484,131530141.39469275,124102703.99568848,112087462.24230941,118940759.07376145,116959975.20762961,125233673.1022177]
["WA025",{"$f":"B13","v":91954920.140190691},91680623.330278397,89975531.042652205,91951519.832541332,92774510.056144252,92304315.923737437,92381168.796519667,95801534.501396626,96058766.262987971,94925036.03878656,94112428.564483255,93110082.726801127]
["WA031/32",{"$f":"B14+B15","v":4026613.1143102683},3512438.1874267613,4392576.2785208877,7255298.1315080794,12858892.158851212,17164120.109027181,23738064.619275883,23355253.281981029,15917342.082980765,8783785.5529983081,4231260.1438364778,3895412.9359316025]
["WA04X",{"$f":"B16","v":1525945.0664072267},1504210.6625064076,1506535.1899971869,1503052.4514471977,1495752.0990312933,1491875.9970526437,1487548.7332422216,1479929.0624368056,1467615.2121774405,1467813.8842941311,1471889.944256285,1471764.4241067106]
["Total",{"$f":"SUM(B19:B24)","v":558849301.90124691},476665036.77707279,480130846.8821528,436829038.84943461,432264372.117432,430927183.18182522,499429425.90053403,481384607.95444304,429508610.18915641,455343744.73339546,499431286.40507889,574986185.63252747]