{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sched 76 - % of Rate Base","Sched 176 % of Rate Base","BFG"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":26,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sched 76 - % of Rate Base","index":0,"n_rows":76,"n_cols":24,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
["Staff Calculation of Year 1 Revenue Requirement Amount to Refund to Customers",null,null,null,null,null,null,"Exh. BAE-8"]
["For EDIT and ADFIT related to Accounting Petition and AFUDC Equity Portion Deferral",null,null,null,null,null,null,"Docket UE-200900/UG-200901/UE-200894"]
[null,null,null,null,null,null,null,"Page 1 of 2"]
[]
[]
[]
["Schedule 76 Electric Rate Spread - Percentage of Rate Base"]
[]
[null,null,null,"Base Tariff",null,null,"Base","Proposed"]
[null,null,null,"Revenue",null,"Percentage","Tariff","Tax",null,null,null,null,null,"Schedule 76 Rate Design"]
[null,"Type of","Schedule","Under Present","Total","of Rate","Percent","Customer"]
["No.","Service","Number","Rates(1)","Rate Base","Base","Increase","Credit",null,null,null,null,null,null,null,null,null,"Sch 76"]
[null,"(a)","(b)","(c)","(d)","(e)","(f)","(g)",null,null,null,null,null,"Residential Service - Schedule 1 & 2",null,null,null,"Tax Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Charge:",null,"Billing Determinants","Base Rates","Credit","Credit","Percentage"]
[1,"Residential","1/2",232554.03877000001,{"$f":"C43/1000","v":1000841.966},{"$f":"E15/$E$27","v":0.53305537961772875},{"$f":"F15*$D$30/D15","v":3.3377026185007271E-2},{"$f":"G15*D15","v":7761.962241455486},null,null,{"$f":"F15/D15","v":2.2921785510030629E-6},null,null,"First 800 kWhs",null,1624555175.5943277,8.1029999999999991E-2,{"$f":"Q15*$V$15","v":3.0096500081605035E-3},{"$f":"P15*R15","v":4889342.497484657},{"$f":"R15/Q15","v":3.7142416489701395E-2},null,3.7142416489701395E-2,{"$f":"H15*1000-S18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"800 - 1,500 kWhs",null,484025314.50355577,9.4269999999999993E-2,{"$f":"Q16*$V$15","v":3.5014156024841502E-3},{"$f":"P16*R16","v":1694773.788200048},{"$f":"R16/Q16","v":3.7142416489701395E-2}]
[2,"General Service","11/12",77795.989848461526,{"$f":"C44/1000","v":232908.576},{"$f":"E17/$E$27","v":0.12404872458745862},{"$f":"F17*$D$30/D17","v":2.3218506857418636E-2},{"$f":"G17*D17","v":1806.3067237761745},null,null,{"$f":"F17/D17","v":1.5945388037235929E-6},null,null,"All over 1,500 kWhs",null,286905034.73311692,0.11053,{"$f":"Q17*$V$15","v":4.1053512946066951E-3},1177845.9557707803,3.7142416489701395E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"SUM(S15:S17)","v":7761962.2414554851}]
[3,"Large General Service","21/22",133265.83332076925,{"$f":"C45/1000","v":385101.73100000003},{"$f":"E19/$E$27","v":0.20510785556892752},{"$f":"F19*$D$30/D19","v":2.2411074012163815E-2},{"$f":"G19*D19+0.1","v":2986.7304538444459},null,null,{"$f":"F19/D19","v":1.5390880802526136E-6},null,null,"General Services - Schedule 11 & 12"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Charge:"]
[4,"Extra Large General Service",25,68105.024659200004,{"$f":"C46/1000","v":181619.96900000001},{"$f":"E21/$E$27","v":9.673205641884039E-2},{"$f":"F21*$D$30/D21","v":2.0681901295157692E-2},{"$f":"G21*D21","v":1408.5413977058552},null,null,1.4203365596428617E-6,null,null,"First 3,650 kWhs",null,435222743.07519329,0.11686000000000001,{"$f":"Q21*$V$21","v":3.1556178715844746E-3},{"$f":"P21*R21","v":1373396.6661680981},{"$f":"R21/Q21","v":2.7003404685816142E-2},null,2.7003404685816142E-2,{"$f":"H17*1000-S23","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"All over 3,650 kWhs",null,186675410.46080667,8.5879999999999998E-2,{"$f":"Q22*$V$21","v":2.3190523944178901E-3},432910.05760807614,2.7003404685816142E-2]
[5,"Pumping Service","30/31/32",12229.340050000001,{"$f":"C47/1000","v":43824.83},{"$f":"E23/$E$27","v":2.3341408719798257E-2},{"$f":"F23*$D$30/D23","v":2.779221989714149E-2},{"$f":"G23*D23+0.1","v":339.98050786651936},null,null,1.9086400921363092E-6,null,null,null,null,0,null,null,{"$f":"SUM(S20:S22)","v":1806306.7237761742}]
[]
[6,"Street & Area Lights","41-48",6628.6650019919989,{"$f":"C48/1000","v":33259.928},{"$f":"E25/$E$27","v":1.7714468565857806E-2},{"$f":"F25*$D$30/D25","v":3.8913585795558432E-2},{"$f":"G25*D25","v":257.94512426503115},null,null,2.6724036530031887E-6,null,null,"Large General Service - Schedule 21 & 22"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Charge:"]
[7,"Total",null,{"$f":"SUM(D15:D25)+0.2","v":530579.09165042278},{"$f":"SUM(E15:E25)+0.2","v":1877557.2000000002},null,{"$f":"D30/$D$27","v":2.7444104430699719E-2},{"$f":"SUM(H15:H25)","v":14561.466448913514},null,null,null,null,null,"First 250,000 kWhs",null,1223990540.2466698,7.535E-2,{"$f":"Q27*$V$27","v":2.2054514583342171E-3},{"$f":"P27*R27","v":2699451.7219743039},{"$f":"R27/Q27","v":2.9269428776831016E-2},null,2.9269428776831016E-2,{"$f":"H19*1000-S29","v":0}]
[null,null,null,null,null,null,null,{"$f":"ROUND(H27-D30,0)","v":0},null,null,null,null,null,"All over 250,000 kWhs",null,145579586.0103302,6.7419999999999994E-2,{"$f":"Q28*$V$27","v":1.9733448881339467E-3},287278.73187014135,2.9269428776831013E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"SUM(S26:S28)","v":2986730.4538444453}]
[8,"Revenue Requirement from BAE-7, Ln 64",null,{"$f":"14561268/1000","v":14561.268},null,{"$f":"D30/D27","v":2.7444104430699719E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Extra Large General Service - Schedule 25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Charge:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"First 500,000 kWhs",null,132000000,5.5050000000000002E-2,{"$f":"Q33*$V$33","v":1.5193761782607725E-3},{"$f":"P33*R33","v":200557.65553042197},{"$f":"R33/Q33","v":2.7599930576944095E-2},null,2.7599930576944095E-2,{"$f":"H21*1000-S36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"500,000 - 6,000,000 kWhs",null,555959799.31499994,4.9530000000000005E-2,{"$f":"Q34*$V$33","v":1.3670245614760411E-3},{"$f":"P34*R34","v":760010.70085689565},{"$f":"R34/Q34","v":2.7599930576944095E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"All over 6,000,000 kWhs",null,383257334.60000014,4.2350000000000006E-2,{"$f":"Q35*$V$33","v":1.1688570599335825E-3},447973.04131853749,2.7599930576944095E-2]
[9,"Bill Impact",914,"kwh",null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"SUM(S33:S35)","v":1408541.3977058551}]
[10,"Present Bill",{"$f":"9+IF(C36>800,(800*0.07858)+((C36-800)*0.09182),C36*0.07858)","v":82.331479999999999},null,null,null,null,null,null,null,null,null,null,"Pumping Service - Schedule 31 & 32"]
[11,"Schedule 76",{"$f":"IF(C36>800,(800*-R15)+((C36-800)*-R16),C36*R15)","v":-2.8068813852115961},null,null,null,null,null,null,null,null,null,null,"Energy Charge:"]
[12,"Proposed Bill",{"$f":"C37+C38","v":79.524598614788403},null,null,null,null,null,null,null,null,null,null,"First 85 kW/kWh",null,46811884.739644997,0.10292,{"$f":"Q39*$V$39","v":2.4349883522762523E-3},{"$f":"P39*R39","v":113986.39408913402},{"$f":"R39/Q39","v":2.3659039567394603E-2},null,2.3659039567394603E-2,{"$f":"H23*1000-S42","v":0}]
[null,null,{"$f":"C38/C37","v":-3.4092444168519698E-2},null,null,null,null,null,null,null,null,null,null,"Next 80 kW/kWh",null,92811168.302354991,0.10292,{"$f":"Q40*$V$39","v":2.4349883522762523E-3},{"$f":"P40*R40","v":225994.11377738533},{"$f":"R40/Q40","v":2.3659039567394603E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"All additional kWhs",null,0,7.3499999999999996E-2,{"$f":"Q41*$V$39","v":1.7389394082035032E-3},0,2.3659039567394603E-2]
[null,null,"Total Rate Base (per TLK-E-5)",null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"SUM(S39:S41)","v":339980.50786651933}]
[null,"Sch 1-2",1000841966,{"$f":"C43/$C$49","v":0.53305543639953412},{"$f":"($D$30*D43)","v":7761.9630682705711},{"$f":"E43/D15","v":3.3377029740374826E-2},null,null,null,null,null,null,null,"Street & Area Lights - Schedules 41-48"]
[null,"Sch 11-22",232908576,0.12404873780130243,{"$f":"($D$30*D44)","v":1806.3069161864955},{"$f":"E44/D17","v":2.321850933068649E-2}]
[null,"Sch 21-22",385101731,0.20510787741730344,2986.6307719845031,{"$f":"E45/D19","v":2.2411076399422792E-2},null,null,null,null,null,null,null,"8.3% of base rates"]
[null,"Sch 25",181619969,9.673206672287446E-2,1408.5415477456568,{"$f":"E46/D21","v":2.0681903498222774E-2},null,null,null,null,null,null,null,null,"Schedule 41",28214.475000000002,7.7096596693718392E-2,{"$f":"Q46*$V$46","v":3.0001050299865765E-3},{"$f":"P46*R46","v":84.64638836593052},{"$f":"R46/Q46","v":3.8913585795558425E-2},null,3.8913585795558425E-2,{"$f":"H25*1000-S53","v":0}]
[null,"Sch 30-32",43824830,2.3341411206157788E-2,339.88054407106682,{"$f":"E47/D23","v":2.779222285760766E-2},null,null,null,null,null,null,null,null,"Schedule 42",9111659.5536700003,0.4617844439002608,1.7969688576767034E-2,163733.68459697402,3.8913585795558425E-2]
[null,"Sch 41-48",33259928,1.7714470452827796E-2,257.94515174170687,{"$f":"E48/D25","v":3.8913589940688061E-2},null,null,null,null,null,null,null,null,"Schedule 44",123112.35188,0.19451500709970837,7.5692764172981576E-3,931.87142176339648,3.8913585795558425E-2]
[null,"Total",{"$f":"SUM(C43:C48)","v":1877557000},{"$f":"SUM(D43:D48)","v":1},{"$f":"SUM(E43:E48)","v":14561.268000000002},{"$f":"E49/D27","v":2.7444104430699723E-2},null,null,null,null,null,null,null,null,"Schedule 45",424923.17200000002,7.6837042909017925E-2,2.9900048615170731E-3,1270.5223500512554,3.8913585795558425E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 46",1041932.9840000002,0.10414113159508154,4.0525048591717461E-3,4222.4384805913178,3.8913585795558432E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 47",4732835.9471299993,0.3047292777757431,1.1858108895144935E-2,56122.484043923949,3.8913585795558425E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 48",2499245.1762899999,0.32470936812876905,1.2635605855300418E-2,31579.476983361248,3.8913585795558425E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17961923.65997,null,null,{"$f":"SUM(S46:S52)","v":257945.12426503107}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check",{"$f":"S53+S42+S36+S29+S23+S18-(H27*1000)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Original"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule 76"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Residential Service - Schedule 1 & 2",null,null,null,null,null,null,"Extra Large General Service - Schedule 25"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Charge:",null,null,null,null,null,null,"Energy Charge:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"First 800 kWhs",null,null,null,5.5050000000000002E-2,null,null,"First 500,000 kWhs",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"800 - 1,500 kWhs",null,null,null,4.9530000000000005E-2,null,null,"500,000 - 6,000,000 kWhs",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"All over 1,500 kWhs",null,null,null,4.2350000000000006E-2,null,null,"All over 6,000,000 kWhs",null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"General Services - Schedule 11 & 12",null,null,null,null,null,null,"Pumping Service - Schedule 31 & 32"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Charge:",null,null,null,null,null,null,"Energy Charge:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"First 3,650 kWhs",null,null,null,0,null,null,"First 85 kW/kWh",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"All over 3,650 kWhs",null,null,null,0,null,null,"Next 80 kW/kWh",null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All additional kWhs",null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Large General Service - Schedule 21 & 22",null,null,null,null,null,null,"Street & Area Lights - Schedules 41-48"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Charge:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"First 250,000 kWhs",null,null,null,8.9900000000000119E-3,null,null,"8.3% of base rates"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"All over 250,000 kWhs",null,null,null,6.420000000000009E-3]

{"sheet":"Sched 176 % of Rate Base","index":1,"n_rows":61,"n_cols":23,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Staff Calculation of Year 1 Revenue Requirement Amount to Refund to Customers",null,null,null,null,null,null,"Exh. BAE-8"]
["For EDIT and ADFIT related to Accounting Petition and AFUDC Equity Portion Deferral",null,null,null,null,null,null,"Docket UE-200900/UG-200901/UE-200894"]
[null,null,null,null,null,null,null,"Page 2 of 2"]
[]
[]
[]
["Schedule 176 Gas Rate Spread - Percentage of Rate Base"]
[]
[null,null,null,"Base Tariff",null,null,"Base","Proposed"]
[null,null,null,"Revenue",null,"Percentage","Tariff","Tax"]
[null,"Type of","Schedule","Under Present","Total","of Rate","Percent","Customer",null,null,null,null,null,"Schedule 176 Rate Design"]
["No.","Service","Number","Rates(1)","Rate Base","Base","Increase","Credit"]
[null,"(a)","(b)","(c)","(d)","(e)","(f)","(g)",null,null,null,null,null,null,null,null,null,"Sch 176"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"General Service - Schedule 101 & 102",null,null,null,"Tax Rate"]
[1,"General Service","101/102",79468.390430000014,{"$f":"C39/1000","v":589374.73400000005},{"$f":"E15/E23","v":0.8073248255940273},{"$f":"F15*$D$26/D15","v":6.7236880853480313E-2},{"$f":"G15*D15","v":5343.2066989597661},null,null,{"$f":"F15/D15","v":1.0159068545690024E-5},null,null,"Energy Charge:",null,"Billing Determinants","Base Rates","Credit","Credit","Percentage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"   First 70 Therms",null,79959168.393630221,0.41034999999999999,{"$f":"Q16*$V$16","v":3.6171020051914034E-2},{"$f":"P16*R16","v":2892204.6833003694},{"$f":"R16/Q16","v":8.8146752898535477E-2},null,8.8146752898535477E-2,{"$f":"H15*1000-S18","v":0}]
[2,"Large General Service","111/112/116",20145.480680000004,{"$f":"C40/1000","v":102455.058},{"$f":"E17/E23","v":0.14034281936333556},{"$f":"F17*$D$26/D17","v":4.6106932560047185E-2},{"$f":"G17*D17","v":928.84631910249368},null,null,{"$f":"F17/D17","v":6.9664666528739058E-6},null,null,"   All over 70 Therms",null,52136435.558899775,0.53332999999999997,{"$f":"Q17*$V$16","v":4.7011307723375924E-2},{"$f":"P17*R17","v":2451002.0156593961},{"$f":"R17/Q17","v":8.8146752898535477E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"SUM(S16:S17)","v":5343206.698959766}]
[3,"Interruptible Service ","131/132",216.98343000000003,{"$f":"C41/1000","v":1350.412},{"$f":"E19/E23","v":1.8497927879956957E-3},{"$f":"F19*$D$26/D19","v":5.6422221208313417E-2},{"$f":"G19*D19","v":12.242687085998591},null,null,{"$f":"F19/D19","v":8.5250416955603265E-6},null,null,"Large General Services - Schedule 111/112/116"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Charge:"]
[4,"Transportation Service","146",3580.8606365599999,{"$f":"C42/1000","v":36853.796999999999},{"$f":"E21/E23","v":5.0482288294874007E-2},{"$f":"F21*$D$26/D21","v":9.3305078187752799E-2},{"$f":"G21*D21+0.1","v":334.21248167367708},null,null,{"$f":"F21/D21","v":1.4097808716557724E-5},null,null,"First 200 therms",null,6563649.9786088606,0.53780000000000006,{"$f":"Q21*$V$21","v":2.5397809526230653E-2},{"$f":"P21*R21","v":166702.33195355575},{"$f":"R21/Q21","v":4.72253803016561E-2},null,4.72253803016561E-2,{"$f":"H17*1000-S26","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"200 - 1,000 therms",null,17370505.201274935,0.36158999999999997,{"$f":"Q22*$V$21","v":1.7076225263275829E-2},{"$f":"P22*R22","v":296622.65975387522},{"$f":"R22/Q22","v":4.72253803016561E-2}]
[5,"Total",null,{"$f":"SUM(D15:D22)+0.2","v":103411.91517656001},{"$f":"SUM(E15:E22)+0.2","v":730034.201},null,{"$f":"D26/$D$23","v":6.400045863864022E-2},{"$f":"SUM(H15:H22)","v":6618.5081868219359},null,null,null,null,null,"1,000 - 10,000 therms",null,34375335.17900046,0.27562000000000003,{"$f":"Q23*$V$21","v":1.3016259318742457E-2},{"$f":"P23*R23","v":447438.2768585601},{"$f":"R23/Q23","v":4.72253803016561E-2}]
[null,null,null,null,null,null,null,{"$f":"ROUND(H23-D26,0)","v":0},null,null,null,null,null,"10,000 - 25,000 therms",null,715938.61765987775,0.23516999999999999,{"$f":"Q24*$V$21","v":1.1105992685540465E-2},{"$f":"P24*R24","v":7951.2090510265543},{"$f":"R24/Q24","v":4.72253803016561E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"All over 25,000 therms",null,1300492.7882758321,0.16497000000000001,{"$f":"Q25*$V$21","v":7.7907709883642071E-3},{"$f":"P25*R25","v":10131.841485476229},{"$f":"R25/Q25","v":4.72253803016561E-2}]
[6,"Revenue Requirement",null,{"$f":"6618410/1000","v":6618.41},null,{"$f":"D26/D23","v":6.400045863864022E-2},null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"SUM(S20:S25)","v":928846.31910249381}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Interuptible Service - Schedule 131/132"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Charge:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"First 10,000 therms",null,220000,0.27007999999999999,{"$f":"Q30*$V$30","v":1.5238513743039911E-2},{"$f":"P30*R30","v":3352.4730234687804},{"$f":"R30/Q30","v":5.6422222093601572E-2},null,5.6422222093601572E-2,{"$f":"H19*1000-S34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"10,000 - 25,000 therms",null,285403.25800000003,0.21681,{"$f":"Q31*$V$30","v":1.2232901972113757E-2},{"$f":"P31*R31","v":3491.3100776358915},{"$f":"R31/Q31","v":5.6422222093601572E-2}]
[7,"Bill Impact",67,"Therms",null,null,null,null,null,null,null,null,null,"25,000 - 50,000 therms",null,317689.05499999993,0.20373000000000002,{"$f":"Q32*$V$30","v":1.149489930712945E-2},{"$f":"P32*R32","v":3651.803698202109},{"$f":"R32/Q32","v":5.6422222093601572E-2}]
[8,"Present Bill",{"$f":"9.5+IF(C32>70,(70*0.70194)+((C32-70)*0.82492),C32*0.70194)","v":56.529980000000002},null,null,null,null,null,null,null,null,null,null,"All over 50,000 therms",null,170107.97699999809,0.18203,{"$f":"Q33*$V$30","v":1.0270537087698295E-2},{"$f":"P33*R33","v":1747.1002866918088},{"$f":"R33/Q33","v":5.6422222093601572E-2}]
[9,"Schedule 176",{"$f":"IF(C32>70,(70*-R16)+((C32-70)*-R17),C32*-R16)","v":-2.4234583434782402},null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"SUM(S29:S33)","v":12242.68708599859}]
[10,"Proposed Bill",{"$f":"C33+C34","v":54.106521656521764}]
[null,null,{"$f":"C34/C33","v":-4.2870320199622218E-2},null,null,null,null,null,null,null,null,null,null,"Transportation Service - Schedule 146"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Energy Charge:"]
[null,null,"Total Rate Base (per JCA-G-64)",null,null,null,null,null,null,null,null,null,null,"First 20,000 therms",null,8146142,0.10493999999999999,{"$f":"Q38*$V$38","v":1.0727757274177732E-2},{"$f":"P38*R38","v":87389.834096984734},{"$f":"R38/Q38","v":0.10222753262986213},null,0.10222753262986214,{"$f":"H21*1000-S43","v":0}]
[null,"Sch 101-102",589374734,{"$f":"C39/$C$43","v":0.80732504676860939},{"$f":"($D$26*D39)","v":5343.2081627838315},{"$f":"E39/D15","v":6.7236899273685605E-2},null,null,null,null,null,null,null,"20,000 - 50,000 therms",null,8282125,9.3359999999999999E-2,{"$f":"Q39*$V$38","v":9.5439624463239305E-3},{"$f":"P39*R39","v":79044.289975760577},{"$f":"R39/Q39","v":0.10222753262986216}]
[null,"Sch 111/112/116",102455058,{"$f":"C40/$C$43","v":0.14034285781163225},{"$f":"($D$26*D40)","v":928.84657356908497},{"$f":"E40/D17","v":4.6106945191495163E-2},null,null,null,null,null,null,null,"50,000 - 300,000 therms",null,14410467,8.4190000000000001E-2,{"$f":"Q40*$V$38","v":8.6065359721080939E-3},{"$f":"P40*R40","v":124024.20261037661},{"$f":"R40/Q40","v":0.10222753262986214}]
[null,"Sch 131/132",1350412,{"$f":"C41/$C$43","v":1.8497932947646365E-3},{"$f":"($D$26*D41)","v":12.242690440003217},{"$f":"E41/D19","v":5.6422236665736251E-2},null,null,null,null,null,null,null,"300,000 - 500,000 therms",null,2975780.8679999998,7.7850000000000003E-2,{"$f":"Q41*$V$38","v":7.9584134152347677E-3},{"$f":"P41*R41","v":23682.494380690161},{"$f":"R41/Q41","v":0.10222753262986214}]
[null,"Sch 146",36853797,{"$f":"C42/$C$43","v":5.0482302124993765E-2},{"$f":"($D$26*D42)","v":334.11257320708},{"$f":"E42/D21","v":9.3305103749597357E-2},null,null,null,null,null,null,null,"All over 500,000 therms",null,3355717,5.851E-2,{"$f":"Q42*$V$38","v":5.9813329341732342E-3},{"$f":"P42*R42","v":20071.660609865005},{"$f":"R42/Q42","v":0.10222753262986214}]
[null,"Total",{"$f":"SUM(C39:C42)","v":730034001},{"$f":"SUM(D39:D42)","v":1},{"$f":"SUM(E39:E42)","v":6618.41},{"$f":"E43/D23","v":6.400045863864022E-2},null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"SUM(S38:S42)","v":334212.4816736771}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check",{"$f":"S18+S26+S34+S43-(H23*1000)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Original"]
[null,null,null,null,null,null,null,null,null,null,null,null,"General Service - Schedules 101 & 102",null,null,null,"Interruptible Service - Schedules 131 & 132"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Usage Charge:",null,null,null,"Usage Charge:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"   First 70 Therms",null,6.6539999999999988E-2,null,"First 10,000 therms",null,3.3399999999999985E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,"   All over 70 Therms",null,8.6470000000000047E-2,null,"10,000 - 25,000 therms",null,2.6819999999999983E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25,000 - 50,000 therms",null,2.5199999999999972E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All over 50,000 therms",null,2.2510000000000002E-2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Large General Service - Schedules 111, 112 & 116",null,null,null,"Transportation Service - Schedule 146"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Usage Charge:",null,null,null,"Usage Charge:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"First 200 therms",null,7.9499999999999904E-2,null,"First 20,000 therms",null,1.4100000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,"200 - 1,000 therms",null,4.2550000000000032E-2,null,"20,000 - 50,000 therms",null,1.2549999999999992E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,"1,000 - 10,000 therms",null,3.2439999999999969E-2,null,"50,000 - 300,000 therms",null,1.1310000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,"10,000 - 25,000 therms",null,2.7680000000000038E-2,null,"300,000 - 500,000 therms",null,1.0459999999999997E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,"All over 25,000 therms",null,1.9409999999999983E-2,null,"All over 500,000 therms",null,7.8599999999999989E-3]

{"sheet":"BFG","index":2,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["AVISTA UTILITIES"]
["GAS ANNUAL MINIMUM DEFICIENCY FOR B.F. GOODRICH"]
["STATE OF WASHINGTON"]
["BASED ON 2007 ANNUAL MINIMUM"]
[]
[null,null,null,null,null,"Gas"]
["Annual Minimum Usage Requirement(1)",null,null,null,null,10500000]
["Less: Jan 09 - Dec 09 Usage(2)",null,null,null,null,{"$f":"SUMIF(#REF!,\"BF Goodrich\",#REF!)","v":{"$error":"#REF!"}}]
["Usage Deficiency",null,null,null,null,{"$f":"F7-F8","v":{"$error":"#REF!"}}]
["Deficiency Charge per therm(3)",null,null,null,null,0]
["Annual Minimum Deficiency",null,null,null,null,{"$f":"F9*F10","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
["(1) Per Contract - workpaper BJH-G-36"]
["(2) From workpaper BJH-G-9"]
["(3) From workpaper BJH-G-35"]
[]
[]
["**  Annual Minimum Ended in 2009"]
[]
[]
[null,null,null,null,null,{"$f":"ROUND(F11-#REF!,0)","v":{"$error":"#REF!"}}]