{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Scenario Summaries","Inputs and Revenues","Single Bills","Reduced Usage Scenario","Data","Assumptions","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"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":"Scenario Summaries","index":0,"n_rows":54,"n_cols":13,"rows_kept":54,"cut":false,"hidden":false,"merged":[[46,0,53,0],[46,1,46,4],[47,10,48,10],[47,11,48,11],[47,12,48,12],[46,6,46,8],[46,10,46,12],[2,0,2,12],[6,0,13,0],[7,10,8,10],[7,12,8,12],[7,11,8,11],[6,1,6,4],[6,6,6,8],[6,10,6,12],[4,6,4,12],[4,1,4,4],[16,0,23,0],[16,1,16,4],[17,10,18,10],[17,11,18,11],[17,12,18,12],[16,6,16,8],[16,10,16,12],[26,0,33,0],[26,1,26,4],[27,10,28,10],[27,11,28,11],[27,12,28,12],[26,6,26,8],[26,10,26,12],[36,0,43,0],[36,1,36,4],[37,10,38,10],[37,11,38,11],[37,12,38,12],[36,6,36,8],[36,10,36,12]]}
[]
[]
["scenario summaries"]
[]
[null,"Inputs",null,null,null,null,"Results"]
[]
["scenario 1","Assumptions",null,null,null,null,"Revenues",null,null,null,"Revenue Changes for Scenario 1"]
[null,"July 2010 through June 2011 bill frequency data",null,null,null,null,"revenues with minimum bill",":",{"$f":"ROUND(619017970.514264,-3)","v":619018000},null,"increased revenues with minimum bill",":",{"$f":"I8-I9","v":269000}]
[null,"(current) customer charge",":",4,null,null,"revenues with no minimum bill",":",{"$f":"ROUND(618748757.785942,-3)","v":618749000}]
[null,"(current) minimum bill",":",7]
[null,"(current) energy rates",":",8.4003999999999995E-2,"1st 400 kWh May-Sept",null,"revenues if 6% drop in usage in all tiers",":",{"$f":"ROUND(601171349.279336,-3)","v":601171000},null,"Lost revenue* from 6% efficiency scenario",":",{"$f":"ROUND(17846621.2349277,-3)","v":17847000}]
[null,null,null,0.103481,"next 66 kWh May-Sept",null,"revenues if 20% drop in tiers 2 & 3",":",{"$f":"ROUND(563817896.592554,-3)","v":563818000},null,"Lost revenue* from 20% efficiency scenario",":",{"$f":"ROUND(56550871.7198881,-3)","v":56551000}]
[null,null,null,0.12870899999999999,"all add'l kWh May-Sept",null,null,null,null,null,"(*Calculated using minimum bill scenario)"]
[null,null,null,8.7035000000000001E-2,"all kWh Oct-April",null,"Revenues from Customer Charge",":",{"$f":"ROUND(32316296.0616,-3)","v":32316000}]
[]
[]
["scenario 2","Assumptions",null,null,null,null,"Revenues",null,null,null,"Revenue Changes for Scenario 2"]
[null,"July 2010 through June 2011 bill frequency data",null,null,null,null,"revenues with minimum bill",":",{"$f":"ROUND(627419756.355084,-3)","v":627420000},null,"increased revenues with minimum bill",":",{"$f":"I18-I19","v":592000}]
[null,"customer charge",":",5,null,null,"revenues with no minimum bill",":",{"$f":"ROUND(626827831.801342,-3)","v":626828000}]
[null,"minimum bill",":",10]
[null,"energy rates",":",8.4003999999999995E-2,"1st 400 kWh May-Sept",null,"revenues if 6% drop in usage in all tiers",":",{"$f":"ROUND(609578524.391621,-3)","v":609579000},null,"Lost revenue* from 6% efficiency scenario",":",{"$f":"ROUND(17841231.9634633,-3)","v":17841000}]
[null,null,null,0.103481,"next 66 kWh May-Sept",null,"revenues if 20% drop in tiers 2 & 3",":",{"$f":"ROUND(572219682.433374,-3)","v":572220000},null,"Lost revenue* from 20% efficiency scenario",":",{"$f":"ROUND(56550871.7198881,-3)","v":56551000}]
[null,null,null,0.12870899999999999,"all add'l kWh May-Sept",null,null,null,null,null,"(*Calculated using minimum bill scenario)"]
[null,null,null,8.7035000000000001E-2,"all kWh Oct-April",null,"Revenues from Customer Charge",":",{"$f":"ROUND(40395370.077,-3)","v":40395000}]
[]
[]
["scenario 3","Assumptions",null,null,null,null,"Revenues",null,null,null,"Revenue Changes for Scenario 3"]
[null,"July 2010 through June 2011 bill frequency data",null,null,null,null,"revenues with minimum bill",":",{"$f":"ROUND(652098834.266533,-3)","v":652099000},null,"increased revenues with minimum bill",":",{"$f":"I28-I29","v":1034000}]
[null,"customer charge",":",8,null,null,"revenues with no minimum bill",":",{"$f":"ROUND(651065053.847542,-3)","v":651065000}]
[null,"minimum bill",":",15]
[null,"energy rates",":",8.4003999999999995E-2,"1st 400 kWh May-Sept",null,"revenues if 6% drop in usage in all tiers",":",{"$f":"ROUND(634265426.473492,-3)","v":634265000},null,"Lost revenue* from 6% efficiency scenario",":",{"$f":"ROUND(17833407.7930405,-3)","v":17833000}]
[null,null,null,0.103481,"next 66 kWh May-Sept",null,"revenues if 20% drop in tiers 2 & 3",":",{"$f":"ROUND(596898760.344823,-3)","v":596899000},null,"Lost revenue* from 20% efficiency scenario",":",{"$f":"ROUND(56550871.7198881,-3)","v":56551000}]
[null,null,null,0.12870899999999999,"all add'l kWh May-Sept",null,null,null,null,null,"(*Calculated using minimum bill scenario)"]
[null,null,null,8.7035000000000001E-2,"all kWh Oct-April",null,"Revenues from Customer Charge",":",{"$f":"ROUND(64632592.1232,-3)","v":64633000}]
[]
[]
["scenario 4","Assumptions",null,null,null,null,"Revenues",null,null,null,"Revenue Changes for Scenario 4"]
[null,"July 2010 through June 2011 bill frequency data",null,null,null,null,"revenues with minimum bill",":",{"$f":"ROUND(667223201.878342,-3)","v":667223000},null,"increased revenues with minimum bill",":",{"$f":"I38-I39","v":0}]
[null,"customer charge",":",10,null,null,"revenues with no minimum bill",":",{"$f":"ROUND(667223201.878342,-3)","v":667223000}]
[null,"minimum bill",":",0]
[null,"energy rates",":",8.4003999999999995E-2,"1st 400 kWh May-Sept",null,"revenues if 6% drop in usage in all tiers",":",{"$f":"ROUND(649372660.95492,-3)","v":649373000},null,"Lost revenue* from 6% efficiency scenario",":",{"$f":"ROUND(17850540.9234219,-3)","v":17851000}]
[null,null,null,0.103481,"next 66 kWh May-Sept",null,"revenues if 20% drop in tiers 2 & 3",":",{"$f":"ROUND(612023127.956632,-3)","v":612023000},null,"Lost revenue* from 20% efficiency scenario",":",{"$f":"ROUND(56550871.7198881,-3)","v":56551000}]
[null,null,null,0.12870899999999999,"all add'l kWh May-Sept",null,null,null,null,null,"(*Calculated using minimum bill scenario)"]
[null,null,null,8.7035000000000001E-2,"all kWh Oct-April",null,"Revenues from Customer Charge",":",{"$f":"ROUND(80790740.1539999,-3)","v":80791000}]
[]
[]
["scenario 5","Assumptions",null,null,null,null,"Revenues",null,null,null,"Revenue Changes for Scenario 5"]
[null,"July 2010 through June 2011 bill frequency data",null,null,null,null,"revenues with minimum bill",":",{"$f":"ROUND(817736350.785244,-3)","v":817736000},null,"increased revenues with minimum bill",":",0]
[null,"customer charge",":",28.63,null,null,"revenues with no minimum bill",":",{"$f":"ROUND(817736350.785244,-3)","v":817736000}]
[null,"minimum bill",":",0]
[null,"energy rates",":",8.4003999999999995E-2,"1st 400 kWh May-Sept",null,"revenues if 6% drop in usage in all tiers",":",{"$f":"ROUND(799885809.861822,-3)","v":799886000},null,"Lost revenue* from 6% efficiency scenario",":",{"$f":"ROUND(17850540.9234221,-3)","v":17851000}]
[null,null,null,0.103481,"next 66 kWh May-Sept",null,"revenues if 20% drop in tiers 2 & 3",":",{"$f":"ROUND(762536276.863534,-3)","v":762536000},null,"Lost revenue* from 20% efficiency scenario",":",{"$f":"ROUND(56550871.7198881,-3)","v":56551000}]
[null,null,null,0.12870899999999999,"all add'l kWh May-Sept",null,null,null,null,null,"(*Calculated using minimum bill scenario)"]
[null,null,null,8.7035000000000001E-2,"all kWh Oct-April",null,"Revenues from Customer Charge",":",{"$f":"ROUND(231303889.060902,-3)","v":231304000}]

{"sheet":"Inputs and Revenues","index":1,"n_rows":101,"n_cols":17,"rows_kept":101,"cut":false,"hidden":false,"merged":[[2,6,2,9],[2,10,2,13],[2,1,2,4],[41,7,41,10],[49,11,49,12]]}
[]
[]
[null,"Rates",null,null,null,null,"Revenues with minimum bill",null,null,null,"Revenues without minimum bill"]
[]
[]
[null,"Monthly fixed charges:",null,null,null,null,"Revenues per kWh range: ",null,null,null,"Revenues per kWh range: "]
[null,null,"Customer charge",4,null,null,null,"0 kWh",{"$f":"'Inputs and Revenues'!D12*(((5/12)*'Single Bills'!G5)+((7/12)*'Single Bills'!K5))","v":319569.18279999966},null,null,"0 kWh",{"$f":"D12*(((5/12)*'Single Bills'!F5)+((7/12)*'Single Bills'!J5))","v":182610.96159999978}]
[null,null,"Minimum bill",7,null,null,null,"0 - 20 kWh",{"$f":"'Inputs and Revenues'!D13*(((5/12)*'Single Bills'!G6)+((7/12)*'Single Bills'!K6))","v":369946.8653999989},null,null,"0 - 20 kWh",{"$f":"D13*(((5/12)*'Single Bills'!F6)+((7/12)*'Single Bills'!J6))","v":256728.37075427672},null,null,null,"color coding key:"]
[null,null,null,null,null,null,null,"20 - 40 kWh",{"$f":"'Inputs and Revenues'!D14*(((5/12)*'Single Bills'!G7)+((7/12)*'Single Bills'!K7))","v":312184.58389999915},null,null,"20 - 40 kWh",{"$f":"D14*(((5/12)*'Single Bills'!F7)+((7/12)*'Single Bills'!J7))","v":293148.5714242254},null,null,null,"pick a number or rate"]
[null,"Bill frequency: ",null,null,null,null,null,"40 - 60 kWh",{"$f":"'Inputs and Revenues'!D15*(((5/12)*'Single Bills'!G8)+((7/12)*'Single Bills'!K8))","v":425403.91327953414},null,null,"40 - 60 kWh",{"$f":"D15*(((5/12)*'Single Bills'!F8)+((7/12)*'Single Bills'!J8))","v":425403.91327953414},null,null,null,"inputs from \"Data\" tab "]
[null,null,"kWh range","# of bills",null,null,null,"60 - 80 kWh",{"$f":"'Inputs and Revenues'!D16*(((5/12)*'Single Bills'!G9)+((7/12)*'Single Bills'!K9))","v":532446.47885155573},null,null,"60 - 80 kWh",{"$f":"D16*(((5/12)*'Single Bills'!F9)+((7/12)*'Single Bills'!J9))","v":532446.47885155573},null,null,null,"unlocked formula "]
[null,null,"0 kWh",{"$f":"Data!P5","v":45652.740399999944},null,null,null,"80 - 100 kWh",{"$f":"'Inputs and Revenues'!D17*(((5/12)*'Single Bills'!G10)+((7/12)*'Single Bills'!K10))","v":691210.34508986119},null,null,"80 - 100 kWh",{"$f":"D17*(((5/12)*'Single Bills'!F10)+((7/12)*'Single Bills'!J10))","v":691210.34508986119}]
[null,null,"0 - 20 kWh",{"$f":"Data!P6","v":52849.552199999838},null,null,null,"100 - 200 kWh",{"$f":"'Inputs and Revenues'!D18*(((5/12)*'Single Bills'!G11)+((7/12)*'Single Bills'!K11))","v":6528911.3124052342},null,null,"100 - 200 kWh",{"$f":"D18*(((5/12)*'Single Bills'!F11)+((7/12)*'Single Bills'!J11))","v":6528911.3124052342}]
[null,null,"20 - 40 kWh",{"$f":"Data!P7","v":44597.797699999872},null,null,null,"200 - 300 kWh",{"$f":"'Inputs and Revenues'!D19*(((5/12)*'Single Bills'!G12)+((7/12)*'Single Bills'!K12))","v":15183088.171378223},null,null,"200 - 300 kWh",{"$f":"D19*(((5/12)*'Single Bills'!F12)+((7/12)*'Single Bills'!J12))","v":15183088.171378223}]
[null,null,"40 - 60 kWh",{"$f":"Data!P8","v":51323.950899999851},null,null,null,"300 - 400 kWh",{"$f":"'Inputs and Revenues'!D20*(((5/12)*'Single Bills'!G13)+((7/12)*'Single Bills'!K13))","v":25790262.499656204},null,null,"300 - 400 kWh",{"$f":"D20*(((5/12)*'Single Bills'!F13)+((7/12)*'Single Bills'!J13))","v":25790262.499656204}]
[null,null,"60 - 80 kWh",{"$f":"Data!P9","v":53223.114699999867},null,null,null,"400 - 500 kWh",{"$f":"'Inputs and Revenues'!D21*(((5/12)*'Single Bills'!G14)+((7/12)*'Single Bills'!K14))","v":36456458.718916662},null,null,"400 - 500 kWh",{"$f":"D21*(((5/12)*'Single Bills'!F14)+((7/12)*'Single Bills'!J14))","v":36456458.718916662}]
[null,null,"80 - 100 kWh",{"$f":"Data!P10","v":58979.570999999894},null,null,null,"500 - 600 kWh",{"$f":"'Inputs and Revenues'!D22*(((5/12)*'Single Bills'!G15)+((7/12)*'Single Bills'!K15))","v":43974503.087081909},null,null,"500 - 600 kWh",{"$f":"D22*(((5/12)*'Single Bills'!F15)+((7/12)*'Single Bills'!J15))","v":43974503.087081909}]
[null,null,"100 - 200 kWh",{"$f":"Data!P11","v":387109.2076000034},null,null,null,"600 - 700 kWh",{"$f":"'Inputs and Revenues'!D23*(((5/12)*'Single Bills'!G16)+((7/12)*'Single Bills'!K16))","v":47234512.806109615},null,null,"600 - 700 kWh",{"$f":"D23*(((5/12)*'Single Bills'!F16)+((7/12)*'Single Bills'!J16))","v":47234512.806109615}]
[null,null,"200 - 300 kWh",{"$f":"Data!P12","v":596748.64360000053},null,null,null,"700 - 800 kWh",{"$f":"'Inputs and Revenues'!D24*(((5/12)*'Single Bills'!G17)+((7/12)*'Single Bills'!K17))","v":46707977.149072438},null,null,"700 - 800 kWh",{"$f":"D24*(((5/12)*'Single Bills'!F17)+((7/12)*'Single Bills'!J17))","v":46707977.149072438}]
[null,null,"300 - 400 kWh",{"$f":"Data!P13","v":758086.08969999943},null,null,null,"800 - 900 kWh",{"$f":"'Inputs and Revenues'!D25*(((5/12)*'Single Bills'!G18)+((7/12)*'Single Bills'!K18))","v":43848995.641642921},null,null,"800 - 900 kWh",{"$f":"D25*(((5/12)*'Single Bills'!F18)+((7/12)*'Single Bills'!J18))","v":43848995.641642921}]
[null,null,"400 - 500 kWh",{"$f":"Data!P14","v":839836.81299999845},null,null,null,"900 - 1000 kWh",{"$f":"'Inputs and Revenues'!D26*(((5/12)*'Single Bills'!G19)+((7/12)*'Single Bills'!K19))","v":39861005.469395548},null,null,"900 - 1000 kWh",{"$f":"D26*(((5/12)*'Single Bills'!F19)+((7/12)*'Single Bills'!J19))","v":39861005.469395548}]
[null,null,"500 - 600 kWh",{"$f":"Data!P15","v":832886.25819999818},null,null,null,"1000 - 1100 kWh",{"$f":"'Inputs and Revenues'!D27*(((5/12)*'Single Bills'!G20)+((7/12)*'Single Bills'!K20))","v":35940714.363064677},null,null,"1000 - 1100 kWh",{"$f":"D27*(((5/12)*'Single Bills'!F20)+((7/12)*'Single Bills'!J20))","v":35940714.363064677}]
[null,null,"600 - 700 kWh",{"$f":"Data!P16","v":759562.4231999995},null,null,null,"1100 - 1200 kWh",{"$f":"'Inputs and Revenues'!D28*(((5/12)*'Single Bills'!G21)+((7/12)*'Single Bills'!K21))","v":32115760.993336525},null,null,"1100 - 1200 kWh",{"$f":"D28*(((5/12)*'Single Bills'!F21)+((7/12)*'Single Bills'!J21))","v":32115760.993336525}]
[null,null,"700 - 800 kWh",{"$f":"Data!P17","v":652571.81420000014},null,null,null,"1200 - 1300 kWh",{"$f":"'Inputs and Revenues'!D29*(((5/12)*'Single Bills'!G22)+((7/12)*'Single Bills'!K22))","v":28460444.899061169},null,null,"1200 - 1300 kWh",{"$f":"D29*(((5/12)*'Single Bills'!F22)+((7/12)*'Single Bills'!J22))","v":28460444.899061169}]
[null,null,"800 - 900 kWh",{"$f":"Data!P18","v":541586.46959999949},null,null,null,"1300 - 1400 kWh",{"$f":"'Inputs and Revenues'!D30*(((5/12)*'Single Bills'!G23)+((7/12)*'Single Bills'!K23))","v":24956538.118264742},null,null,"1300 - 1400 kWh",{"$f":"D30*(((5/12)*'Single Bills'!F23)+((7/12)*'Single Bills'!J23))","v":24956538.118264742}]
[null,null,"900 - 1000 kWh",{"$f":"Data!P19","v":441171.01760000014},null,null,null,"1400 - 1500 kWh",{"$f":"'Inputs and Revenues'!D31*(((5/12)*'Single Bills'!G24)+((7/12)*'Single Bills'!K24))","v":21829854.205524281},null,null,"1400 - 1500 kWh",{"$f":"D31*(((5/12)*'Single Bills'!F24)+((7/12)*'Single Bills'!J24))","v":21829854.205524281}]
[null,null,"1000 - 1100 kWh",{"$f":"Data!P20","v":356580.72139999969},null,null,null,"1500 - 1600 kWh",{"$f":"'Inputs and Revenues'!D32*(((5/12)*'Single Bills'!G25)+((7/12)*'Single Bills'!K25))","v":19150709.465552036},null,null,"1500 - 1600 kWh",{"$f":"D32*(((5/12)*'Single Bills'!F25)+((7/12)*'Single Bills'!J25))","v":19150709.465552036}]
[null,null,"1100 - 1200 kWh",{"$f":"Data!P21","v":288726.25309999957},null,null,null,"1600 - 1700 kWh",{"$f":"'Inputs and Revenues'!D33*(((5/12)*'Single Bills'!G26)+((7/12)*'Single Bills'!K26))","v":16720883.015959801},null,null,"1600 - 1700 kWh",{"$f":"D33*(((5/12)*'Single Bills'!F26)+((7/12)*'Single Bills'!J26))","v":16720883.015959801}]
[null,null,"1200 - 1300 kWh",{"$f":"Data!P22","v":233910.29009999969},null,null,null,"1700 - 1800 kWh",{"$f":"'Inputs and Revenues'!D34*(((5/12)*'Single Bills'!G27)+((7/12)*'Single Bills'!K27))","v":14472527.246053537},null,null,"1700 - 1800 kWh",{"$f":"D34*(((5/12)*'Single Bills'!F27)+((7/12)*'Single Bills'!J27))","v":14472527.246053537}]
[null,null,"1300 - 1400 kWh",{"$f":"Data!P23","v":188903.83419999972},null,null,null,"1800 - 1900 kWh",{"$f":"'Inputs and Revenues'!D35*(((5/12)*'Single Bills'!G28)+((7/12)*'Single Bills'!K28))","v":12551597.67582343},null,null,"1800 - 1900 kWh",{"$f":"D35*(((5/12)*'Single Bills'!F28)+((7/12)*'Single Bills'!J28))","v":12551597.67582343}]
[null,null,"1400 - 1500 kWh",{"$f":"Data!P24","v":153135.74239999984},null,null,null,"1900 - 2000 kWh",{"$f":"'Inputs and Revenues'!D36*(((5/12)*'Single Bills'!G29)+((7/12)*'Single Bills'!K29))","v":10929517.214164028},null,null,"1900 - 2000 kWh",{"$f":"D36*(((5/12)*'Single Bills'!F29)+((7/12)*'Single Bills'!J29))","v":10929517.214164028}]
[null,null,"1500 - 1600 kWh",{"$f":"Data!P25","v":125174.39329999981},null,null,null,"2000 - 3000 kWh",{"$f":"'Inputs and Revenues'!D37*(((5/12)*'Single Bills'!G30)+((7/12)*'Single Bills'!K30))","v":58014961.838618413},null,null,"2000 - 3000 kWh",{"$f":"D37*(((5/12)*'Single Bills'!F30)+((7/12)*'Single Bills'!J30))","v":58014961.838618413}]
[null,null,"1600 - 1700 kWh",{"$f":"Data!P26","v":102310.85769999992},null,null,null,"3000 - 4000 kWh",{"$f":"'Inputs and Revenues'!D38*(((5/12)*'Single Bills'!G31)+((7/12)*'Single Bills'!K31))","v":16935257.731898889},null,null,"3000 - 4000 kWh",{"$f":"D38*(((5/12)*'Single Bills'!F31)+((7/12)*'Single Bills'!J31))","v":16935257.731898889}]
[null,null,"1700 - 1800 kWh",{"$f":"Data!P27","v":83236.645599999931},null,null,null,"4000 - 5000 kWh",{"$f":"'Inputs and Revenues'!D39*(((5/12)*'Single Bills'!G32)+((7/12)*'Single Bills'!K32))","v":6777334.0700288648},null,null,"4000 - 5000 kWh",{"$f":"D39*(((5/12)*'Single Bills'!F32)+((7/12)*'Single Bills'!J32))","v":6777334.0700288648}]
[null,null,"1800 - 1900 kWh",{"$f":"Data!P28","v":68099.738999999958},null,null,null,"Over 5000 kWh",{"$f":"'Inputs and Revenues'!D40*(((5/12)*'Single Bills'!G33)+((7/12)*'Single Bills'!K33))","v":11925393.451933689},null,null,"Over 5000 kWh",{"$f":"D40*(((5/12)*'Single Bills'!F33)+((7/12)*'Single Bills'!J33))","v":11925393.451933689}]
[null,null,"1900 - 2000 kWh",{"$f":"Data!P29","v":56120.20959999998}]
[null,null,"2000 - 3000 kWh",{"$f":"Data!P30","v":230061.58989999979},null,null,"Revenue Total:",{"$f":"SUM(I7:I35)","v":619017970.51426387},null,null,"Revenue Total:",{"$f":"SUM(M7:M35)","v":618748757.78594232}]
[null,null,"3000 - 4000 kWh",{"$f":"Data!P31","v":47494.822999999989}]
[null,null,"4000 - 5000 kWh",{"$f":"Data!P32","v":14702.339500000002}]
[null,null,"Over 5000 kWh",{"$f":"Data!P33","v":14431.112999999999}]
[]
[null,"May - September Energy Charges:",null,null,null,null,null,"Revenue Difference:"]
[null,null,"kWh range","$/kWh",null,null,null,null,null,null,{"$f":"H37-L37","v":269212.72832155228}]
[null,null,"0 - 100 kWh",{"$f":"I48","v":8.4003999999999995E-2}]
[null,null,"100 - 200 kWh",{"$f":"I49","v":8.4003999999999995E-2}]
[null,null,"200 - 300 kWh",8.4003999999999995E-2,null,null,null,"proposed rates","current rates "]
[null,null,"300 - 400 kWh",8.4003999999999995E-2,null,null,"kWh range","May-Sept","May-Sept"]
[null,null,"400 - 500 kWh",0.103481,null,null,"0 - 100 kWh",8.6309999999999998E-2,8.4003999999999995E-2,null,null,"Revenus from Customer Charges"]
[null,null,"500 - 600 kWh",0.103481,null,null,"100 - 200 kWh",8.6309999999999998E-2,8.4003999999999995E-2]
[null,null,"600 - 700 kWh",0.103481,null,null,"200 - 300 kWh",8.6309999999999998E-2,8.4003999999999995E-2,null,null,{"$f":"SUM($D$12:$D$40)*$D$7","v":32316296.061599977}]
[null,null,"700 - 800 kWh",0.103481,null,null,"300 - 400 kWh",8.6309999999999998E-2,8.4003999999999995E-2]
[null,null,"800 - 900 kWh",0.103481,null,null,"400 - 500 kWh",0.106321,0.103481]
[null,null,"900 - 1000 kWh",0.103481,null,null,"500 - 600 kWh",0.106321,0.103481]
[null,null,"1000 - 1100 kWh",0.12870899999999999,null,null,"600 - 700 kWh",0.106321,0.103481]
[null,null,"1100 - 1200 kWh",0.12870899999999999,null,null,"700 - 800 kWh",0.106321,0.103481]
[null,null,"1200 - 1300 kWh",0.12870899999999999,null,null,"800 - 900 kWh",0.106321,0.103481]
[null,null,"1300 - 1400 kWh",0.12870899999999999,null,null,"900 - 1000 kWh",0.106321,0.103481]
[null,null,"1400 - 1500 kWh",0.12870899999999999,null,null,"1000 - 1100 kWh",0.132242,0.12870899999999999]
[null,null,"1500 - 1600 kWh",0.12870899999999999,null,null,"1100 - 1200 kWh",0.132242,0.12870899999999999]
[null,null,"1600 - 1700 kWh",0.12870899999999999,null,null,"1200 - 1300 kWh",0.132242,0.12870899999999999]
[null,null,"1700 - 1800 kWh",0.12870899999999999,null,null,"1300 - 1400 kWh",0.132242,0.12870899999999999]
[null,null,"1800 - 1900 kWh",0.12870899999999999,null,null,"1400 - 1500 kWh",0.132242,0.12870899999999999]
[null,null,"1900 - 2000 kWh",0.12870899999999999,null,null,"1500 - 1600 kWh",0.132242,0.12870899999999999]
[null,null,"2000 - 3000 kWh",0.12870899999999999,null,null,"1600 - 1700 kWh",0.132242,0.12870899999999999]
[null,null,"3000 - 4000 kWh",0.12870899999999999,null,null,"1700 - 1800 kWh",0.132242,0.12870899999999999]
[null,null,"4000 - 5000 kWh",0.12870899999999999,null,null,"1800 - 1900 kWh",0.132242,0.12870899999999999]
[null,null,"Over 5000 kWh",0.12870899999999999,null,null,"1900 - 2000 kWh",0.132242,0.12870899999999999]
[null,null,null,null,null,null,"2000 - 3000 kWh",0.132242,0.12870899999999999]
[null,"October to April Energy Charges:",null,null,null,null,"3000 - 4000 kWh",0.132242,0.12870899999999999]
[null,null,"kWh range","$/kWh",null,null,"4000 - 5000 kWh",0.132242,0.12870899999999999]
[null,null,"0 kWh",{"$f":"I73","v":8.7035000000000001E-2},null,null,"Over 5000 kWh",0.132242,0.12870899999999999]
[null,null,"0 - 20 kWh",{"$f":"I74","v":8.7035000000000001E-2},null,null,null,"Oct-April","Oct-April "]
[null,null,"20 - 40 kWh",8.7035000000000001E-2,null,null,"0 kWh",{"$f":"8.9424/100","v":8.942399999999999E-2},8.7035000000000001E-2]
[null,null,"40 - 60 kWh",8.7035000000000001E-2,null,null,"0 - 20 kWh",{"$f":"8.9424/100","v":8.942399999999999E-2},8.7035000000000001E-2]
[null,null,"60 - 80 kWh",8.7035000000000001E-2,null,null,"20 - 40 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"80 - 100 kWh",8.7035000000000001E-2,null,null,"40 - 60 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"100 - 200 kWh",8.7035000000000001E-2,null,null,"60 - 80 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"200 - 300 kWh",8.7035000000000001E-2,null,null,"80 - 100 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"300 - 400 kWh",8.7035000000000001E-2,null,null,"100 - 200 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"400 - 500 kWh",8.7035000000000001E-2,null,null,"200 - 300 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"500 - 600 kWh",8.7035000000000001E-2,null,null,"300 - 400 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"600 - 700 kWh",8.7035000000000001E-2,null,null,"400 - 500 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"700 - 800 kWh",8.7035000000000001E-2,null,null,"500 - 600 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"800 - 900 kWh",8.7035000000000001E-2,null,null,"600 - 700 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"900 - 1000 kWh",8.7035000000000001E-2,null,null,"700 - 800 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"1000 - 1100 kWh",8.7035000000000001E-2,null,null,"800 - 900 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"1100 - 1200 kWh",8.7035000000000001E-2,null,null,"900 - 1000 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"1200 - 1300 kWh",8.7035000000000001E-2,null,null,"1000 - 1100 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"1300 - 1400 kWh",8.7035000000000001E-2,null,null,"1100 - 1200 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"1400 - 1500 kWh",8.7035000000000001E-2,null,null,"1200 - 1300 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"1500 - 1600 kWh",8.7035000000000001E-2,null,null,"1300 - 1400 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"1600 - 1700 kWh",8.7035000000000001E-2,null,null,"1400 - 1500 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"1700 - 1800 kWh",8.7035000000000001E-2,null,null,"1500 - 1600 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"1800 - 1900 kWh",8.7035000000000001E-2,null,null,"1600 - 1700 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"1900 - 2000 kWh",8.7035000000000001E-2,null,null,"1700 - 1800 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"2000 - 3000 kWh",8.7035000000000001E-2,null,null,"1800 - 1900 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"3000 - 4000 kWh",8.7035000000000001E-2,null,null,"1900 - 2000 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"4000 - 5000 kWh",8.7035000000000001E-2,null,null,"2000 - 3000 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,"Over 5000 kWh",8.7035000000000001E-2,null,null,"3000 - 4000 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,null,null,null,null,"4000 - 5000 kWh",8.942399999999999E-2,8.7035000000000001E-2]
[null,null,null,null,null,null,"Over 5000 kWh",8.942399999999999E-2,8.7035000000000001E-2]

{"sheet":"Single Bills","index":2,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,4,2,5],[33,4,33,5],[35,0,35,1],[36,0,36,1],[37,0,37,1],[34,0,34,1]]}
[null,null,null,null,null,"May to September Rates",null,null,null,"October to April Rates"]
[]
[null,null,null,null,"no minimum bill",null,"minimum bill"]
["kWh range","energy charge per kWh ($)","assumed kWh usage within range (kWh)",null,"energy charge*","energy charge + customer charge","minimum bill or energy charge + customer charge",null,"energy Charge","energy charge + customer charge","minimum bill or energy charge + customer charge"]
["0 kWh",{"$f":"'Inputs and Revenues'!$D$44","v":8.4003999999999995E-2},0,0,{"$f":"D5","v":0},{"$f":"E5+'Inputs and Revenues'!$D$7","v":4},{"$f":"IF(F5<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F5)","v":7},null,{"$f":"C5*'Inputs and Revenues'!D71","v":0},{"$f":"I5+'Inputs and Revenues'!$D$7","v":4},{"$f":"IF(J5<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J5)","v":7}]
["0 - 20 kWh",{"$f":"'Inputs and Revenues'!$D$44","v":8.4003999999999995E-2},10,0.8400399999999999,{"$f":"D6","v":0.8400399999999999},{"$f":"E6+'Inputs and Revenues'!$D$7","v":4.8400400000000001},{"$f":"IF(F6<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F6)","v":7},null,{"$f":"C6*'Inputs and Revenues'!D72","v":0.87034999999999996},{"$f":"I6+'Inputs and Revenues'!$D$7","v":4.8703500000000002},{"$f":"IF(J6<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J6)","v":7}]
["20 - 40 kWh",{"$f":"'Inputs and Revenues'!$D$44","v":8.4003999999999995E-2},30,2.5201199999999995,2.5201199999999995,{"$f":"E7+'Inputs and Revenues'!$D$7","v":6.5201199999999995},{"$f":"IF(F7<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F7)","v":7},null,{"$f":"C7*'Inputs and Revenues'!D73","v":2.6110500000000001},{"$f":"I7+'Inputs and Revenues'!$D$7","v":6.6110500000000005},{"$f":"IF(J7<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J7)","v":7}]
["40 - 60 kWh",{"$f":"'Inputs and Revenues'!$D$44","v":8.4003999999999995E-2},50,4.2001999999999997,4.2001999999999997,{"$f":"E8+'Inputs and Revenues'!$D$7","v":8.2001999999999988},{"$f":"IF(F8<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F8)","v":8.2001999999999988},null,{"$f":"C8*'Inputs and Revenues'!D74","v":4.35175},{"$f":"I8+'Inputs and Revenues'!$D$7","v":8.3517499999999991},{"$f":"IF(J8<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J8)","v":8.3517499999999991}]
["60 - 80 kWh",{"$f":"'Inputs and Revenues'!$D$44","v":8.4003999999999995E-2},70,5.8802799999999991,5.8802799999999991,{"$f":"E9+'Inputs and Revenues'!$D$7","v":9.8802799999999991},{"$f":"IF(F9<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F9)","v":9.8802799999999991},null,{"$f":"C9*'Inputs and Revenues'!D75","v":6.0924500000000004},{"$f":"I9+'Inputs and Revenues'!$D$7","v":10.092449999999999},{"$f":"IF(J9<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J9)","v":10.092449999999999}]
["80 - 100 kWh",{"$f":"'Inputs and Revenues'!$D$44","v":8.4003999999999995E-2},90,7.5603599999999993,7.5603599999999993,{"$f":"E10+'Inputs and Revenues'!$D$7","v":11.560359999999999},{"$f":"IF(F10<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F10)","v":11.560359999999999},null,{"$f":"C10*'Inputs and Revenues'!D76","v":7.8331499999999998},{"$f":"I10+'Inputs and Revenues'!$D$7","v":11.83315},{"$f":"IF(J10<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J10)","v":11.83315}]
["100 - 200 kWh",{"$f":"'Inputs and Revenues'!D45","v":8.4003999999999995E-2},150,12.6006,12.6006,{"$f":"E11+'Inputs and Revenues'!$D$7","v":16.6006},{"$f":"IF(F11<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F11)","v":16.6006},null,{"$f":"C11*'Inputs and Revenues'!D77","v":13.055250000000001},{"$f":"I11+'Inputs and Revenues'!$D$7","v":17.055250000000001},{"$f":"IF(J11<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J11)","v":17.055250000000001}]
["200 - 300 kWh",{"$f":"'Inputs and Revenues'!D46","v":8.4003999999999995E-2},250,21.000999999999998,21.000999999999998,{"$f":"E12+'Inputs and Revenues'!$D$7","v":25.000999999999998},{"$f":"IF(F12<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F12)","v":25.000999999999998},null,{"$f":"C12*'Inputs and Revenues'!D78","v":21.758749999999999},{"$f":"I12+'Inputs and Revenues'!$D$7","v":25.758749999999999},{"$f":"IF(J12<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J12)","v":25.758749999999999}]
["300 - 400 kWh",{"$f":"'Inputs and Revenues'!D47","v":8.4003999999999995E-2},350,29.401399999999999,29.401399999999999,{"$f":"E13+'Inputs and Revenues'!$D$7","v":33.401399999999995},{"$f":"IF(F13<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F13)","v":33.401399999999995},null,{"$f":"C13*'Inputs and Revenues'!D79","v":30.462250000000001},{"$f":"I13+'Inputs and Revenues'!$D$7","v":34.462249999999997},{"$f":"IF(J13<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J13)","v":34.462249999999997}]
["400 - 500 kWh",{"$f":"'Inputs and Revenues'!D48","v":0.103481},450,39.749499999999983,39.749499999999983,{"$f":"E14+'Inputs and Revenues'!$D$7","v":43.749499999999983},{"$f":"IF(F14<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F14)","v":43.749499999999983},null,{"$f":"C14*'Inputs and Revenues'!D80","v":39.165750000000003},{"$f":"I14+'Inputs and Revenues'!$D$7","v":43.165750000000003},{"$f":"IF(J14<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J14)","v":43.165750000000003}]
["500 - 600 kWh",{"$f":"'Inputs and Revenues'!D49","v":0.103481},550,50.097599999999986,50.097599999999986,{"$f":"E15+'Inputs and Revenues'!$D$7","v":54.097599999999986},{"$f":"IF(F15<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F15)","v":54.097599999999986},null,{"$f":"C15*'Inputs and Revenues'!D81","v":47.869250000000001},{"$f":"I15+'Inputs and Revenues'!$D$7","v":51.869250000000001},{"$f":"IF(J15<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J15)","v":51.869250000000001}]
["600 - 700 kWh",{"$f":"'Inputs and Revenues'!D50","v":0.103481},650,60.445699999999981,60.445699999999981,{"$f":"E16+'Inputs and Revenues'!$D$7","v":64.445699999999988},{"$f":"IF(F16<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F16)","v":64.445699999999988},null,{"$f":"C16*'Inputs and Revenues'!D82","v":56.572749999999999},{"$f":"I16+'Inputs and Revenues'!$D$7","v":60.572749999999999},{"$f":"IF(J16<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J16)","v":60.572749999999999}]
["700 - 800 kWh",{"$f":"'Inputs and Revenues'!D51","v":0.103481},750,70.793800000000005,70.793800000000005,{"$f":"E17+'Inputs and Revenues'!$D$7","v":74.793800000000005},{"$f":"IF(F17<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F17)","v":74.793800000000005},null,{"$f":"C17*'Inputs and Revenues'!D83","v":65.276250000000005},{"$f":"I17+'Inputs and Revenues'!$D$7","v":69.276250000000005},{"$f":"IF(J17<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J17)","v":69.276250000000005}]
["800 - 900 kWh",{"$f":"'Inputs and Revenues'!D52","v":0.103481},850,81.141900000000021,81.141900000000021,{"$f":"E18+'Inputs and Revenues'!$D$7","v":85.141900000000021},{"$f":"IF(F18<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F18)","v":85.141900000000021},null,{"$f":"C18*'Inputs and Revenues'!D84","v":73.979749999999996},{"$f":"I18+'Inputs and Revenues'!$D$7","v":77.979749999999996},{"$f":"IF(J18<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J18)","v":77.979749999999996}]
["900 - 1000 kWh",{"$f":"'Inputs and Revenues'!D53","v":0.103481},950,91.490000000000023,91.490000000000023,{"$f":"E19+'Inputs and Revenues'!$D$7","v":95.490000000000023},{"$f":"IF(F19<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F19)","v":95.490000000000023},null,{"$f":"C19*'Inputs and Revenues'!D85","v":82.683250000000001},{"$f":"I19+'Inputs and Revenues'!$D$7","v":86.683250000000001},{"$f":"IF(J19<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J19)","v":86.683250000000001}]
["1000 - 1100 kWh",{"$f":"'Inputs and Revenues'!D54","v":0.12870899999999999},1050,104.36090000000003,104.36090000000003,{"$f":"E20+'Inputs and Revenues'!$D$7","v":108.36090000000003},{"$f":"IF(F20<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F20)","v":108.36090000000003},null,{"$f":"C20*'Inputs and Revenues'!D86","v":91.386750000000006},{"$f":"I20+'Inputs and Revenues'!$D$7","v":95.386750000000006},{"$f":"IF(J20<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J20)","v":95.386750000000006}]
["1100 - 1200 kWh",{"$f":"'Inputs and Revenues'!D55","v":0.12870899999999999},1150,117.23180000000004,117.23180000000004,{"$f":"E21+'Inputs and Revenues'!$D$7","v":121.23180000000004},{"$f":"IF(F21<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F21)","v":121.23180000000004},null,{"$f":"C21*'Inputs and Revenues'!D87","v":100.09025},{"$f":"I21+'Inputs and Revenues'!$D$7","v":104.09025},{"$f":"IF(J21<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J21)","v":104.09025}]
["1200 - 1300 kWh",{"$f":"'Inputs and Revenues'!D56","v":0.12870899999999999},1250,130.1027,130.1027,{"$f":"E22+'Inputs and Revenues'!$D$7","v":134.1027},{"$f":"IF(F22<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F22)","v":134.1027},null,{"$f":"C22*'Inputs and Revenues'!D88","v":108.79375},{"$f":"I22+'Inputs and Revenues'!$D$7","v":112.79375},{"$f":"IF(J22<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J22)","v":112.79375}]
["1300 - 1400 kWh",{"$f":"'Inputs and Revenues'!D57","v":0.12870899999999999},1350,142.97360000000003,142.97360000000003,{"$f":"E23+'Inputs and Revenues'!$D$7","v":146.97360000000003},{"$f":"IF(F23<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F23)","v":146.97360000000003},null,{"$f":"C23*'Inputs and Revenues'!D89","v":117.49725000000001},{"$f":"I23+'Inputs and Revenues'!$D$7","v":121.49725000000001},{"$f":"IF(J23<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J23)","v":121.49725000000001}]
["1400 - 1500 kWh",{"$f":"'Inputs and Revenues'!D58","v":0.12870899999999999},1450,155.84450000000001,155.84450000000001,{"$f":"E24+'Inputs and Revenues'!$D$7","v":159.84450000000001},{"$f":"IF(F24<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F24)","v":159.84450000000001},null,{"$f":"C24*'Inputs and Revenues'!D90","v":126.20075},{"$f":"I24+'Inputs and Revenues'!$D$7","v":130.20075},{"$f":"IF(J24<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J24)","v":130.20075}]
["1500 - 1600 kWh",{"$f":"'Inputs and Revenues'!D59","v":0.12870899999999999},1550,168.71539999999999,168.71539999999999,{"$f":"E25+'Inputs and Revenues'!$D$7","v":172.71539999999999},{"$f":"IF(F25<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F25)","v":172.71539999999999},null,{"$f":"C25*'Inputs and Revenues'!D91","v":134.90424999999999},{"$f":"I25+'Inputs and Revenues'!$D$7","v":138.90424999999999},{"$f":"IF(J25<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J25)","v":138.90424999999999}]
["1600 - 1700 kWh",{"$f":"'Inputs and Revenues'!D60","v":0.12870899999999999},1650,181.58629999999999,181.58629999999999,{"$f":"E26+'Inputs and Revenues'!$D$7","v":185.58629999999999},{"$f":"IF(F26<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F26)","v":185.58629999999999},null,{"$f":"C26*'Inputs and Revenues'!D92","v":143.60775000000001},{"$f":"I26+'Inputs and Revenues'!$D$7","v":147.60775000000001},{"$f":"IF(J26<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J26)","v":147.60775000000001}]
["1700 - 1800 kWh",{"$f":"'Inputs and Revenues'!D61","v":0.12870899999999999},1750,194.45719999999997,194.45719999999997,{"$f":"E27+'Inputs and Revenues'!$D$7","v":198.45719999999997},{"$f":"IF(F27<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F27)","v":198.45719999999997},null,{"$f":"C27*'Inputs and Revenues'!D93","v":152.31125},{"$f":"I27+'Inputs and Revenues'!$D$7","v":156.31125},{"$f":"IF(J27<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J27)","v":156.31125}]
["1800 - 1900 kWh",{"$f":"'Inputs and Revenues'!D62","v":0.12870899999999999},1850,207.32809999999998,207.32809999999998,{"$f":"E28+'Inputs and Revenues'!$D$7","v":211.32809999999998},{"$f":"IF(F28<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F28)","v":211.32809999999998},null,{"$f":"C28*'Inputs and Revenues'!D94","v":161.01474999999999},{"$f":"I28+'Inputs and Revenues'!$D$7","v":165.01474999999999},{"$f":"IF(J28<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J28)","v":165.01474999999999}]
["1900 - 2000 kWh",{"$f":"'Inputs and Revenues'!D63","v":0.12870899999999999},1950,220.19899999999996,220.19899999999996,{"$f":"E29+'Inputs and Revenues'!$D$7","v":224.19899999999996},{"$f":"IF(F29<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F29)","v":224.19899999999996},null,{"$f":"C29*'Inputs and Revenues'!D95","v":169.71825000000001},{"$f":"I29+'Inputs and Revenues'!$D$7","v":173.71825000000001},{"$f":"IF(J29<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J29)","v":173.71825000000001}]
["2000 - 3000 kWh",{"$f":"'Inputs and Revenues'!D64","v":0.12870899999999999},2500,290.98894999999982,290.98894999999982,{"$f":"E30+'Inputs and Revenues'!$D$7","v":294.98894999999982},{"$f":"IF(F30<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F30)","v":294.98894999999982},null,{"$f":"C30*'Inputs and Revenues'!D96","v":217.58750000000001},{"$f":"I30+'Inputs and Revenues'!$D$7","v":221.58750000000001},{"$f":"IF(J30<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J30)","v":221.58750000000001}]
["3000 - 4000 kWh",{"$f":"'Inputs and Revenues'!D65","v":0.12870899999999999},3500,419.69794999999982,419.69794999999982,{"$f":"E31+'Inputs and Revenues'!$D$7","v":423.69794999999982},{"$f":"IF(F31<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F31)","v":423.69794999999982},null,{"$f":"C31*'Inputs and Revenues'!D97","v":304.6225},{"$f":"I31+'Inputs and Revenues'!$D$7","v":308.6225},{"$f":"IF(J31<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J31)","v":308.6225}]
["4000 - 5000 kWh",{"$f":"'Inputs and Revenues'!D66","v":0.12870899999999999},4500,548.40694999999994,548.40694999999994,{"$f":"E32+'Inputs and Revenues'!$D$7","v":552.40694999999994},{"$f":"IF(F32<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F32)","v":552.40694999999994},null,{"$f":"C32*'Inputs and Revenues'!D98","v":391.65750000000003},{"$f":"I32+'Inputs and Revenues'!$D$7","v":395.65750000000003},{"$f":"IF(J32<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J32)","v":395.65750000000003}]
["Over 5000 kWh",{"$f":"'Inputs and Revenues'!D67","v":0.12870899999999999},8000,998.88845000000026,998.88845000000026,{"$f":"E33+'Inputs and Revenues'!$D$7","v":1002.8884500000003},{"$f":"IF(F33<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!F33)","v":1002.8884500000003},null,{"$f":"C33*'Inputs and Revenues'!D99","v":696.28},{"$f":"I33+'Inputs and Revenues'!$D$7","v":700.28},{"$f":"IF(J33<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,'Single Bills'!J33)","v":700.28}]
[null,null,null,null,"*energy charge is derived from \"eCharge\" macro"]
["color coding key:                     "]
["pick a number within kWh range "]
["inputs from \"Inputs and Revenues\" tab"]
["unlocked formula       "]

{"sheet":"Reduced Usage Scenario","index":3,"n_rows":40,"n_cols":16,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,6,3,7],[35,6,35,7],[37,14,37,15],[38,14,38,15],[36,14,36,15],[1,6,1,8],[1,10,1,12],[1,14,1,15]]}
[]
[null,"percentage usage drop:",null,20,"%",null,"May to September rates",null,null,null,"October to April rates",null,null,null,"revenues with decreased usage"]
[]
[null,null,null,null,null,null,"no minimum bill",null,"minimum bill",null,null,"no minimum bill","minimum bill",null,"no minimum bill","minimum bill"]
[null,"kWh range","assumed use within range (kWh)","energy charge per kWh ($)","decreased tailblock usage**",null,"energy charge*","energy charge + customer charge","minimum bill or energy charge + customer charge",null,"energy Charge","energy charge + customer charge","minimum bill or energy charge + customer charge",null,"revenues with no minimum bill","revenues with minimum bill"]
[null,"0 kWh",0,{"$f":"'Single Bills'!B5","v":8.4003999999999995E-2},{"$f":"C6","v":0},0,{"$f":"F6","v":0},{"$f":"G6+'Inputs and Revenues'!$D$7","v":4},{"$f":"IF(H6<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H6)","v":7},null,{"$f":"C6*'Inputs and Revenues'!D71","v":0},{"$f":"K6+'Inputs and Revenues'!$D$7","v":4},{"$f":"IF(L6<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L6)","v":7},null,{"$f":"'Inputs and Revenues'!D12*(((5/12)*H6)+((7/12)*L6))","v":182610.96159999978},{"$f":"'Inputs and Revenues'!D12*(((5/12)*I6)+((7/12)*'Reduced Usage Scenario'!M6))","v":319569.18279999966}]
[null,"0 - 20 kWh",10,{"$f":"'Single Bills'!B6","v":8.4003999999999995E-2},{"$f":"C7","v":10},0.8400399999999999,{"$f":"F7","v":0.8400399999999999},{"$f":"G7+'Inputs and Revenues'!$D$7","v":4.8400400000000001},{"$f":"IF(H7<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H7)","v":7},null,{"$f":"C7*'Inputs and Revenues'!D72","v":0.87034999999999996},{"$f":"K7+'Inputs and Revenues'!$D$7","v":4.8703500000000002},{"$f":"IF(L7<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L7)","v":7},null,{"$f":"'Inputs and Revenues'!D13*(((5/12)*H7)+((7/12)*L7))","v":256728.37075427672},{"$f":"'Inputs and Revenues'!D13*(((5/12)*I7)+((7/12)*'Reduced Usage Scenario'!M7))","v":369946.8653999989}]
[null,"20 - 40 kWh",30,{"$f":"'Single Bills'!B7","v":8.4003999999999995E-2},30,2.5201199999999995,2.5201199999999995,{"$f":"G8+'Inputs and Revenues'!$D$7","v":6.5201199999999995},{"$f":"IF(H8<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H8)","v":7},null,{"$f":"C8*'Inputs and Revenues'!D73","v":2.6110500000000001},{"$f":"K8+'Inputs and Revenues'!$D$7","v":6.6110500000000005},{"$f":"IF(L8<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L8)","v":7},null,{"$f":"'Inputs and Revenues'!D14*(((5/12)*H8)+((7/12)*L8))","v":293148.5714242254},{"$f":"'Inputs and Revenues'!D14*(((5/12)*I8)+((7/12)*'Reduced Usage Scenario'!M8))","v":312184.58389999915}]
[null,"40 - 60 kWh",50,{"$f":"'Single Bills'!B8","v":8.4003999999999995E-2},50,4.2001999999999997,4.2001999999999997,{"$f":"G9+'Inputs and Revenues'!$D$7","v":8.2001999999999988},{"$f":"IF(H9<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H9)","v":8.2001999999999988},null,{"$f":"C9*'Inputs and Revenues'!D74","v":4.35175},{"$f":"K9+'Inputs and Revenues'!$D$7","v":8.3517499999999991},{"$f":"IF(L9<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L9)","v":8.3517499999999991},null,{"$f":"'Inputs and Revenues'!D15*(((5/12)*H9)+((7/12)*L9))","v":425403.91327953414},{"$f":"'Inputs and Revenues'!D15*(((5/12)*I9)+((7/12)*'Reduced Usage Scenario'!M9))","v":425403.91327953414}]
[null,"60 - 80 kWh",70,{"$f":"'Single Bills'!B9","v":8.4003999999999995E-2},70,5.8802799999999991,5.8802799999999991,{"$f":"G10+'Inputs and Revenues'!$D$7","v":9.8802799999999991},{"$f":"IF(H10<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H10)","v":9.8802799999999991},null,{"$f":"C10*'Inputs and Revenues'!D75","v":6.0924500000000004},{"$f":"K10+'Inputs and Revenues'!$D$7","v":10.092449999999999},{"$f":"IF(L10<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L10)","v":10.092449999999999},null,{"$f":"'Inputs and Revenues'!D16*(((5/12)*H10)+((7/12)*L10))","v":532446.47885155573},{"$f":"'Inputs and Revenues'!D16*(((5/12)*I10)+((7/12)*'Reduced Usage Scenario'!M10))","v":532446.47885155573}]
[null,"80 - 100 kWh",90,{"$f":"'Single Bills'!B10","v":8.4003999999999995E-2},90,7.5603599999999993,7.5603599999999993,{"$f":"G11+'Inputs and Revenues'!$D$7","v":11.560359999999999},{"$f":"IF(H11<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H11)","v":11.560359999999999},null,{"$f":"C11*'Inputs and Revenues'!D76","v":7.8331499999999998},{"$f":"K11+'Inputs and Revenues'!$D$7","v":11.83315},{"$f":"IF(L11<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L11)","v":11.83315},null,{"$f":"'Inputs and Revenues'!D17*(((5/12)*H11)+((7/12)*L11))","v":691210.34508986119},{"$f":"'Inputs and Revenues'!D17*(((5/12)*I11)+((7/12)*'Reduced Usage Scenario'!M11))","v":691210.34508986119}]
[null,"100 - 200 kWh",150,{"$f":"'Single Bills'!B11","v":8.4003999999999995E-2},150,12.6006,12.6006,{"$f":"G12+'Inputs and Revenues'!$D$7","v":16.6006},{"$f":"IF(H12<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H12)","v":16.6006},null,{"$f":"C12*'Inputs and Revenues'!D77","v":13.055250000000001},{"$f":"K12+'Inputs and Revenues'!$D$7","v":17.055250000000001},{"$f":"IF(L12<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L12)","v":17.055250000000001},null,{"$f":"'Inputs and Revenues'!D18*(((5/12)*H12)+((7/12)*L12))","v":6528911.3124052342},{"$f":"'Inputs and Revenues'!D18*(((5/12)*I12)+((7/12)*'Reduced Usage Scenario'!M12))","v":6528911.3124052342}]
[null,"200 - 300 kWh",250,{"$f":"'Single Bills'!B12","v":8.4003999999999995E-2},250,21.000999999999998,21.000999999999998,{"$f":"G13+'Inputs and Revenues'!$D$7","v":25.000999999999998},{"$f":"IF(H13<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H13)","v":25.000999999999998},null,{"$f":"C13*'Inputs and Revenues'!D78","v":21.758749999999999},{"$f":"K13+'Inputs and Revenues'!$D$7","v":25.758749999999999},{"$f":"IF(L13<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L13)","v":25.758749999999999},null,{"$f":"'Inputs and Revenues'!D19*(((5/12)*H13)+((7/12)*L13))","v":15183088.171378223},{"$f":"'Inputs and Revenues'!D19*(((5/12)*I13)+((7/12)*'Reduced Usage Scenario'!M13))","v":15183088.171378223}]
[null,"300 - 400 kWh",350,{"$f":"'Single Bills'!B13","v":8.4003999999999995E-2},350,29.401399999999999,29.401399999999999,{"$f":"G14+'Inputs and Revenues'!$D$7","v":33.401399999999995},{"$f":"IF(H14<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H14)","v":33.401399999999995},null,{"$f":"C14*'Inputs and Revenues'!D79","v":30.462250000000001},{"$f":"K14+'Inputs and Revenues'!$D$7","v":34.462249999999997},{"$f":"IF(L14<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L14)","v":34.462249999999997},null,{"$f":"'Inputs and Revenues'!D20*(((5/12)*H14)+((7/12)*L14))","v":25790262.499656204},{"$f":"'Inputs and Revenues'!D20*(((5/12)*I14)+((7/12)*'Reduced Usage Scenario'!M14))","v":25790262.499656204}]
[null,"400 - 500 kWh",450,{"$f":"D14","v":8.4003999999999995E-2},{"$f":"C15*(1-($D$2/100))","v":360},35.533691999999995,35.533691999999995,{"$f":"G15+'Inputs and Revenues'!$D$7","v":39.533691999999995},{"$f":"IF(H15<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H15)","v":39.533691999999995},null,{"$f":"C15*'Inputs and Revenues'!D80","v":39.165750000000003},{"$f":"K15+'Inputs and Revenues'!$D$7","v":43.165750000000003},{"$f":"IF(L15<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L15)","v":43.165750000000003},null,{"$f":"'Inputs and Revenues'!D21*(((5/12)*H15)+((7/12)*L15))","v":34981212.571025044},{"$f":"'Inputs and Revenues'!D21*(((5/12)*I15)+((7/12)*'Reduced Usage Scenario'!M15))","v":34981212.571025044}]
[null,"500 - 600 kWh",550,{"$f":"'Single Bills'!B15","v":0.103481},440,45.260905999999984,45.260905999999984,{"$f":"G16+'Inputs and Revenues'!$D$7","v":49.260905999999984},{"$f":"IF(H16<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H16)","v":49.260905999999984},null,{"$f":"C16*'Inputs and Revenues'!D81","v":47.869250000000001},{"$f":"K16+'Inputs and Revenues'!$D$7","v":51.869250000000001},{"$f":"IF(L16<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L16)","v":51.869250000000001},null,{"$f":"'Inputs and Revenues'!D22*(((5/12)*H16)+((7/12)*L16))","v":42295996.433865912},{"$f":"'Inputs and Revenues'!D22*(((5/12)*I16)+((7/12)*'Reduced Usage Scenario'!M16))","v":42295996.433865912}]
[null,"600 - 700 kWh",650,{"$f":"'Single Bills'!B16","v":0.103481},520,54.988119999999981,54.988119999999981,{"$f":"G17+'Inputs and Revenues'!$D$7","v":58.988119999999981},{"$f":"IF(H17<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H17)","v":58.988119999999981},null,{"$f":"C17*'Inputs and Revenues'!D82","v":56.572749999999999},{"$f":"K17+'Inputs and Revenues'!$D$7","v":60.572749999999999},{"$f":"IF(L17<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L17)","v":60.572749999999999},null,{"$f":"'Inputs and Revenues'!D23*(((5/12)*H17)+((7/12)*L17))","v":45507274.185439676},{"$f":"'Inputs and Revenues'!D23*(((5/12)*I17)+((7/12)*'Reduced Usage Scenario'!M17))","v":45507274.185439676}]
[null,"700 - 800 kWh",750,{"$f":"'Single Bills'!B17","v":0.103481},600,64.715333999999984,64.715333999999984,{"$f":"G18+'Inputs and Revenues'!$D$7","v":68.715333999999984},{"$f":"IF(H18<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H18)","v":68.715333999999984},null,{"$f":"C18*'Inputs and Revenues'!D83","v":65.276250000000005},{"$f":"K18+'Inputs and Revenues'!$D$7","v":69.276250000000005},{"$f":"IF(L18<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L18)","v":69.276250000000005},null,{"$f":"'Inputs and Revenues'!D24*(((5/12)*H18)+((7/12)*L18))","v":45055212.321917005},{"$f":"'Inputs and Revenues'!D24*(((5/12)*I18)+((7/12)*'Reduced Usage Scenario'!M18))","v":45055212.321917005}]
[null,"800 - 900 kWh",850,{"$f":"'Single Bills'!B18","v":0.103481},680,74.442548000000016,74.442548000000016,{"$f":"G19+'Inputs and Revenues'!$D$7","v":78.442548000000016},{"$f":"IF(H19<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H19)","v":78.442548000000016},null,{"$f":"C19*'Inputs and Revenues'!D84","v":73.979749999999996},{"$f":"K19+'Inputs and Revenues'!$D$7","v":77.979749999999996},{"$f":"IF(L19<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L19)","v":77.979749999999996},null,{"$f":"'Inputs and Revenues'!D25*(((5/12)*H19)+((7/12)*L19))","v":42337212.975689702},{"$f":"'Inputs and Revenues'!D25*(((5/12)*I19)+((7/12)*'Reduced Usage Scenario'!M19))","v":42337212.975689702}]
[null,"900 - 1000 kWh",950,{"$f":"'Single Bills'!B19","v":0.103481},760,84.16976200000002,84.16976200000002,{"$f":"G20+'Inputs and Revenues'!$D$7","v":88.16976200000002},{"$f":"IF(H20<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H20)","v":88.16976200000002},null,{"$f":"C20*'Inputs and Revenues'!D85","v":82.683250000000001},{"$f":"K20+'Inputs and Revenues'!$D$7","v":86.683250000000001},{"$f":"IF(L20<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L20)","v":86.683250000000001},null,{"$f":"'Inputs and Revenues'!D26*(((5/12)*H20)+((7/12)*L20))","v":38515390.116256312},{"$f":"'Inputs and Revenues'!D26*(((5/12)*I20)+((7/12)*'Reduced Usage Scenario'!M20))","v":38515390.116256312}]
[null,"1000 - 1100 kWh",1050,{"$f":"D20","v":0.103481},840,93.896976000000024,93.896976000000024,{"$f":"G21+'Inputs and Revenues'!$D$7","v":97.896976000000024},{"$f":"IF(H21<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H21)","v":97.896976000000024},null,{"$f":"C21*'Inputs and Revenues'!D86","v":91.386750000000006},{"$f":"K21+'Inputs and Revenues'!$D$7","v":95.386750000000006},{"$f":"IF(L21<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L21)","v":95.386750000000006},null,{"$f":"'Inputs and Revenues'!D27*(((5/12)*H21)+((7/12)*L21))","v":34386033.709483519},{"$f":"'Inputs and Revenues'!D27*(((5/12)*I21)+((7/12)*'Reduced Usage Scenario'!M21))","v":34386033.709483519}]
[null,"1100 - 1200 kWh",1150,{"$f":"D21","v":0.103481},920,103.62419000000003,103.62419000000003,{"$f":"G22+'Inputs and Revenues'!$D$7","v":107.62419000000003},{"$f":"IF(H22<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H22)","v":107.62419000000003},null,{"$f":"C22*'Inputs and Revenues'!D87","v":100.09025},{"$f":"K22+'Inputs and Revenues'!$D$7","v":104.09025},{"$f":"IF(L22<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L22)","v":104.09025},null,{"$f":"'Inputs and Revenues'!D28*(((5/12)*H22)+((7/12)*L22))","v":30478730.056275655},{"$f":"'Inputs and Revenues'!D28*(((5/12)*I22)+((7/12)*'Reduced Usage Scenario'!M22))","v":30478730.056275655}]
[null,"1200 - 1300 kWh",1250,{"$f":"'Single Bills'!B22","v":0.12870899999999999},1000,115.72283600000003,115.72283600000003,{"$f":"G23+'Inputs and Revenues'!$D$7","v":119.72283600000003},{"$f":"IF(H23<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H23)","v":119.72283600000003},null,{"$f":"C23*'Inputs and Revenues'!D88","v":108.79375},{"$f":"K23+'Inputs and Revenues'!$D$7","v":112.79375},{"$f":"IF(L23<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L23)","v":112.79375},null,{"$f":"'Inputs and Revenues'!D29*(((5/12)*H23)+((7/12)*L23))","v":27058945.665795118},{"$f":"'Inputs and Revenues'!D29*(((5/12)*I23)+((7/12)*'Reduced Usage Scenario'!M23))","v":27058945.665795118}]
[null,"1300 - 1400 kWh",1350,{"$f":"'Single Bills'!B23","v":0.12870899999999999},1080,127.82148200000003,127.82148200000003,{"$f":"G24+'Inputs and Revenues'!$D$7","v":131.82148200000003},{"$f":"IF(H24<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H24)","v":131.82148200000003},null,{"$f":"C24*'Inputs and Revenues'!D89","v":117.49725000000001},{"$f":"K24+'Inputs and Revenues'!$D$7","v":121.49725000000001},{"$f":"IF(L24<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L24)","v":121.49725000000001},null,{"$f":"'Inputs and Revenues'!D30*(((5/12)*H24)+((7/12)*L24))","v":23763915.957243558},{"$f":"'Inputs and Revenues'!D30*(((5/12)*I24)+((7/12)*'Reduced Usage Scenario'!M24))","v":23763915.957243558}]
[null,"1400 - 1500 kWh",1450,{"$f":"'Single Bills'!B24","v":0.12870899999999999},1160,139.92012800000003,139.92012800000003,{"$f":"G25+'Inputs and Revenues'!$D$7","v":143.92012800000003},{"$f":"IF(H25<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H25)","v":143.92012800000003},null,{"$f":"C25*'Inputs and Revenues'!D90","v":126.20075},{"$f":"K25+'Inputs and Revenues'!$D$7","v":130.20075},{"$f":"IF(L25<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L25)","v":130.20075},null,{"$f":"'Inputs and Revenues'!D31*(((5/12)*H25)+((7/12)*L25))","v":20813774.818660211},{"$f":"'Inputs and Revenues'!D31*(((5/12)*I25)+((7/12)*'Reduced Usage Scenario'!M25))","v":20813774.818660211}]
[null,"1500 - 1600 kWh",1550,{"$f":"'Single Bills'!B25","v":0.12870899999999999},1240,152.01877400000001,152.01877400000001,{"$f":"G26+'Inputs and Revenues'!$D$7","v":156.01877400000001},{"$f":"IF(H26<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H26)","v":156.01877400000001},null,{"$f":"C26*'Inputs and Revenues'!D91","v":134.90424999999999},{"$f":"K26+'Inputs and Revenues'!$D$7","v":138.90424999999999},{"$f":"IF(L26<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L26)","v":138.90424999999999},null,{"$f":"'Inputs and Revenues'!D32*(((5/12)*H26)+((7/12)*L26))","v":18279880.28650745},{"$f":"'Inputs and Revenues'!D32*(((5/12)*I26)+((7/12)*'Reduced Usage Scenario'!M26))","v":18279880.28650745}]
[null,"1600 - 1700 kWh",1650,{"$f":"'Single Bills'!B26","v":0.12870899999999999},1320,164.11742000000001,164.11742000000001,{"$f":"G27+'Inputs and Revenues'!$D$7","v":168.11742000000001},{"$f":"IF(H27<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H27)","v":168.11742000000001},null,{"$f":"C27*'Inputs and Revenues'!D92","v":143.60775000000001},{"$f":"K27+'Inputs and Revenues'!$D$7","v":147.60775000000001},{"$f":"IF(L27<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L27)","v":147.60775000000001},null,{"$f":"'Inputs and Revenues'!D33*(((5/12)*H27)+((7/12)*L27))","v":15976192.976018816},{"$f":"'Inputs and Revenues'!D33*(((5/12)*I27)+((7/12)*'Reduced Usage Scenario'!M27))","v":15976192.976018816}]
[null,"1700 - 1800 kWh",1750,{"$f":"'Single Bills'!B27","v":0.12870899999999999},1400,176.21606600000001,176.21606600000001,{"$f":"G28+'Inputs and Revenues'!$D$7","v":180.21606600000001},{"$f":"IF(H28<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H28)","v":180.21606600000001},null,{"$f":"C28*'Inputs and Revenues'!D93","v":152.31125},{"$f":"K28+'Inputs and Revenues'!$D$7","v":156.31125},{"$f":"IF(L28<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L28)","v":156.31125},null,{"$f":"'Inputs and Revenues'!D34*(((5/12)*H28)+((7/12)*L28))","v":13839889.410178492},{"$f":"'Inputs and Revenues'!D34*(((5/12)*I28)+((7/12)*'Reduced Usage Scenario'!M28))","v":13839889.410178492}]
[null,"1800 - 1900 kWh",1850,{"$f":"'Single Bills'!B28","v":0.12870899999999999},1480,188.31471200000001,188.31471200000001,{"$f":"G29+'Inputs and Revenues'!$D$7","v":192.31471200000001},{"$f":"IF(H29<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H29)","v":192.31471200000001},null,{"$f":"C29*'Inputs and Revenues'!D94","v":161.01474999999999},{"$f":"K29+'Inputs and Revenues'!$D$7","v":165.01474999999999},{"$f":"IF(L29<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L29)","v":165.01474999999999},null,{"$f":"'Inputs and Revenues'!D35*(((5/12)*H29)+((7/12)*L29))","v":12012094.859029377},{"$f":"'Inputs and Revenues'!D35*(((5/12)*I29)+((7/12)*'Reduced Usage Scenario'!M29))","v":12012094.859029377}]
[null,"1900 - 2000 kWh",1950,{"$f":"'Single Bills'!B29","v":0.12870899999999999},1560,200.41335800000002,200.41335800000002,{"$f":"G30+'Inputs and Revenues'!$D$7","v":204.41335800000002},{"$f":"IF(H30<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H30)","v":204.41335800000002},null,{"$f":"C30*'Inputs and Revenues'!D95","v":169.71825000000001},{"$f":"K30+'Inputs and Revenues'!$D$7","v":173.71825000000001},{"$f":"IF(L30<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L30)","v":173.71825000000001},null,{"$f":"'Inputs and Revenues'!D36*(((5/12)*H30)+((7/12)*L30))","v":10466861.224117963},{"$f":"'Inputs and Revenues'!D36*(((5/12)*I30)+((7/12)*'Reduced Usage Scenario'!M30))","v":10466861.224117963}]
[null,"2000 - 3000 kWh",2500,{"$f":"'Single Bills'!B30","v":0.12870899999999999},2000,266.9559109999999,266.9559109999999,{"$f":"G31+'Inputs and Revenues'!$D$7","v":270.9559109999999},{"$f":"IF(H31<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H31)","v":270.9559109999999},null,{"$f":"C31*'Inputs and Revenues'!D96","v":217.58750000000001},{"$f":"K31+'Inputs and Revenues'!$D$7","v":221.58750000000001},{"$f":"IF(L31<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L31)","v":221.58750000000001},null,{"$f":"'Inputs and Revenues'!D37*(((5/12)*H31)+((7/12)*L31))","v":55711178.854256459},{"$f":"'Inputs and Revenues'!D37*(((5/12)*I31)+((7/12)*'Reduced Usage Scenario'!M31))","v":55711178.854256459}]
[null,"3000 - 4000 kWh",3500,{"$f":"'Single Bills'!B31","v":0.12870899999999999},2800,387.94237099999981,387.94237099999981,{"$f":"G32+'Inputs and Revenues'!$D$7","v":391.94237099999981},{"$f":"IF(H32<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H32)","v":391.94237099999981},null,{"$f":"C32*'Inputs and Revenues'!D97","v":304.6225},{"$f":"K32+'Inputs and Revenues'!$D$7","v":308.6225},{"$f":"IF(L32<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L32)","v":308.6225},null,{"$f":"'Inputs and Revenues'!D38*(((5/12)*H32)+((7/12)*L32))","v":16306830.396954091},{"$f":"'Inputs and Revenues'!D38*(((5/12)*I32)+((7/12)*'Reduced Usage Scenario'!M32))","v":16306830.396954091}]
[null,"4000 - 5000 kWh",4500,{"$f":"'Single Bills'!B32","v":0.12870899999999999},3600,508.92883099999966,508.92883099999966,{"$f":"G33+'Inputs and Revenues'!$D$7","v":512.92883099999972},{"$f":"IF(H33<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H33)","v":512.92883099999972},null,{"$f":"C33*'Inputs and Revenues'!D98","v":391.65750000000003},{"$f":"K33+'Inputs and Revenues'!$D$7","v":395.65750000000003},{"$f":"IF(L33<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L33)","v":395.65750000000003},null,{"$f":"'Inputs and Revenues'!D39*(((5/12)*H33)+((7/12)*L33))","v":6535492.1082124477},{"$f":"'Inputs and Revenues'!D39*(((5/12)*I33)+((7/12)*'Reduced Usage Scenario'!M33))","v":6535492.1082124477}]
[null,"Over 5000 kWh",8000,{"$f":"'Single Bills'!B33","v":0.12870899999999999},6400,932.38144100000022,932.38144100000022,{"$f":"G34+'Inputs and Revenues'!$D$7","v":936.38144100000022},{"$f":"IF(H34<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,H34)","v":936.38144100000022},null,{"$f":"C34*'Inputs and Revenues'!D99","v":696.28},{"$f":"K34+'Inputs and Revenues'!$D$7","v":700.28},{"$f":"IF(L34<'Inputs and Revenues'!$D$8,'Inputs and Revenues'!$D$8,L34)","v":700.28},null,{"$f":"'Inputs and Revenues'!D40*(((5/12)*H34)+((7/12)*L34))","v":11525489.217695765},{"$f":"'Inputs and Revenues'!D40*(((5/12)*I34)+((7/12)*'Reduced Usage Scenario'!M34))","v":11525489.217695765}]
[]
[null,null,null,null,"**purple cells have % usage drop factored in ",null,"*energy charge is derived from \"eCharge2\" macro",null,null,null,null,null,null,null,{"$f":"SUM(O6:O34)","v":595731418.76906145},{"$f":"SUM(P6:P34)","v":596000631.497383}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"revenue difference between \"normal\" usage and % decreased usage in blocks 2 and 3:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Inputs and Revenues'!L37-O36","v":23017339.01688087},{"$f":"'Inputs and Revenues'!H37-P36","v":23017339.01688087}]

{"sheet":"Data","index":4,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,0,1,3]]}
[]
["2010 - 2011 bill frequency data (OCS 3.37)"]
[]
[null,"kWh range",201007,201008,201009,201010,201011,201012,201101,201102,201103,201104,201105,201106,null,"Total Bills",null,"Ave # of bills"]
[null,0,3189.7983999999901,3151.3622,3079.6812,2987.7826,3549.5812999999898,4305.4961000000103,4497.8545999999897,4549.4084999999905,4544.3154999999897,4429.0237999999899,4083.5346,3284.9016000000001,null,{"$f":"SUM(C5:N5)","v":45652.740399999944},null,{"$f":"SUM(C5:N5)/12","v":3804.3950333333287}]
[null,20,4800.3055999999797,4562.8441999999905,4614.8871999999901,4974.7452999999896,4892.1333999999797,3883.7174999999902,3721.9580999999898,3722.7864999999902,3951.8289999999902,4291.2417999999898,4637.0117999999802,4796.0917999999801,null,52849.552199999838,null,{"$f":"SUM(C6:N6)/12","v":4404.1293499999865}]
[null,40,3547.3580999999999,2947.7055999999998,3286.0281999999902,3943.7159999999899,4622.0914999999904,3424.2223999999901,2972.8293999999901,3063.9063999999898,3551.0521999999901,4136.01079999997,4538.9199999999801,4563.9570999999896,null,44597.797699999872,null,3716.4831416666561]
[null,60,4172.1245999999901,3344.4279999999899,3830.55059999998,4820.0253999999904,5108.9114999999902,3647.58679999999,3034.8719999999898,3401.8679999999699,4131.5289999999804,4818.89929999998,5489.5389999999898,5523.6167000000096,null,51323.950899999851,null,4276.9959083333206]
[null,80,4337.4089000000104,3717.2291999999802,4207.1896999999899,5258.2756999999801,5008.2781999999997,3740.8329999999901,3250.9357999999902,3721.33339999998,4284.8228999999801,4887.0816999999797,5251.09669999998,5558.6295,null,53223.114699999867,null,4435.2595583333223]
[null,100,4852.8204999999898,3885.6283999999901,4651.2047999999904,5876.8580999999904,5316.0843000000104,4055.00719999999,3717.2513999999901,4288.6508999999696,4814.1314999999904,5213.4229999999798,5974.3712999999998,6334.1396000000104,null,58979.570999999894,null,4914.9642499999909]
[null,200,28143.138699999599,21891.9656,29012.0612000002,39248.931000000499,36517.158200000304,24842.708700000301,23741.578099999901,28701.111500000799,33290.793600000798,37122.0106000007,42198.9699000002,42398.780500000103,null,387109.2076000034,null,32259.100633333615]
[null,300,38739.857699998996,27702.423599999998,41267.122800000099,58793.617900000303,59246.836300000701,38095.428100000201,35812.608299999702,46782.889400000298,54851.392900000203,61310.695899999897,68264.535699999804,65881.235000000393,null,596748.64360000053,null,49729.05363333338]
[null,400,47694.540699998601,34094.354399999902,51881.4165000004,71208.084900000002,75347.626500000406,50781.457800000098,48115.986499999897,63348.834500000201,72046.755900000106,78746.588600000003,84806.178199999602,80014.265200000198,null,758086.08969999943,null,63173.840808333283]
[null,500,52868.5944999985,40021.908499999998,57762.437900000201,76535.030599999795,82902.401500000095,59147.660000000098,56684.578600000401,73228.478499999997,80062.478399999905,85932.5145999995,90365.920199999702,84324.809700000202,null,839836.81299999845,null,69986.401083333199]
[null,600,54321.736799997998,42678.942100000102,59673.960700000098,72711.906800000099,80750.401600000303,63858.412700000103,60177.727900000398,74645.768499999802,79181.313999999693,82193.325599999895,83028.122299999595,79664.639200000194,null,832886.25819999818,null,69407.188183333186]
[null,700,53578.430299998603,44014.5090000001,57083.279200000201,65530.455200000099,71366.981800000198,62762.077000000099,60102.190200000397,68484.599499999997,69768.394599999796,69936.417299999899,68676.982199999999,68258.106900000101,null,759562.4231999995,null,63296.868599999958]
[null,800,49540.6441999987,43063.978600000199,52861.697700000201,55891.867100000098,57884.415700000201,58559.854700000098,56822.432700000398,59071.204400000097,57436.012900000198,54976.776299999998,52243.341,54219.588900000002,null,652571.81420000014,null,54380.984516666678]
[null,900,45089.307399999001,41163.540999999997,47466.1646000002,45269.982400000001,44731.781500000099,51684.680500000097,50572.395700000001,47903.750800000002,45316.503400000103,42020.782800000001,38972.089699999997,41395.489800000003,null,541586.46959999949,null,45132.20579999996]
[null,1000,39890.530699999399,38459.884599999998,41734.602299999999,36306.5384000001,34355.887200000099,44415.144500000097,43843.524800000101,37693.258200000098,34350.144300000102,31127.421400000101,28158.681100000002,30835.400099999999,null,441171.01760000014,null,36764.251466666676]
[null,1100,35523.686899999499,36200.667899999899,36180.328500000098,28102.011999999999,24997.485199999999,36828.293899999997,36564.21,29935.398500000101,26512.341600000102,23006.8511,20129.361099999998,22600.084699999999,null,356580.72139999969,null,29715.060116666642]
[null,1200,31062.9477999995,33922.112800000003,30683.0023,21934.596100000101,18577.9902,29860.973099999999,30873.813899999899,23090.030400000102,20131.872299999999,17264.120800000001,14630.498299999999,16694.295099999999,null,288726.25309999957,null,24060.521091666629]
[null,1300,26639.767399999699,31381.955699999999,26162.031200000001,16896.483199999999,13657.7125,24079.995599999998,25566.234,18305.960800000001,15577.0833,12821.598099999999,10690.4702,12130.998100000001,null,233910.29009999969,null,19492.524174999973]
[null,1400,22628.0904999997,28402.179800000002,21695.188600000001,12925.0828,10149.9629,19359.782599999999,20714.926299999999,14612.486199999999,12202.156999999999,9507.4570000000094,7653.7496000000001,9052.7708999999995,null,188903.83419999972,null,15741.986183333311]
[null,1500,19117.235799999798,25754.6675,17751.931700000001,9457.2644999999993,7650.5119999999997,15733.015299999999,17074.800899999998,11523.013300000001,9399.0805,7230.4969000000001,5858.6939000000002,6585.0300999999999,null,153135.74239999984,null,12761.311866666654]
[null,1600,16051.787099999799,23066.946400000001,14470.0383,7399.5730000000003,5749.4267,12572.841399999999,13952.112499999999,9320.6110000000008,7608.2587999999996,5639.2641000000003,4352.4002,4991.1337999999996,null,125174.39329999981,null,10431.199441666651]
[null,1700,13527.083399999899,20273.862400000002,11852.4216,5558.5627000000004,4418.8851999999997,10249.9642,11592.9866,7560.1814999999997,5905.7574000000004,4371.5447000000004,3247.0212000000001,3752.5868,null,102310.85769999992,null,8525.9048083333273]
[null,1800,11176.8366999999,17689.227699999999,9578.1234000000004,4185.2560000000003,3429.5333999999998,8253.59170000001,9549.9656000000105,6149.2938999999997,4604.9763999999996,3246.7256000000002,2448.3546000000001,2924.7606000000001,null,83236.645599999931,null,6936.3871333333273]
[null,1900,9282.3415999999506,15064.691199999999,7702.5228999999999,3235.9441000000002,2644.7305999999999,6721.2179999999998,7961.8907000000099,5073.9517999999998,3637.2689999999998,2631.7413999999999,1865.7893999999999,2277.6482999999998,null,68099.738999999958,null,5674.9782499999965]
[null,2000,7456.5803999999698,13044.0756,6130.6216000000004,2596.6882000000001,2093.5839000000001,5627.5968000000003,6789.5550000000003,4081.5016999999998,2993.2323999999999,2008.6424999999999,1546.9495999999999,1751.1819,null,56120.20959999998,null,4676.6841333333314]
[null,3000,31784.910099999801,56153.364100000101,22874.763599999998,8651.5228999999999,7546.9229999999998,23339.910400000001,29189.427799999899,17614.6623,12414.44,8178.8672999999999,5745.1606000000002,6567.6378000000004,null,230061.58989999979,null,19171.799158333317]
[null,4000,6211.0943999999899,10182.7336,3608.7388000000001,1600.1971000000001,1558.3842,5186.8635000000004,7182.0324000000001,4470.2641000000003,2867.8240000000001,1846.0242000000001,1284.952,1495.7147,null,47494.822999999989,null,3957.9019166666658]
[null,5000,1684.8377,2505.5731999999998,1081.1067,495.5761,515.30399999999997,1674.4509,2518.1305000000002,1540.3575000000001,1075.4480000000001,650.37599999999998,414.37619999999998,546.80269999999996,null,14702.339500000002,null,1225.1949583333335]
[null,"Over 5,000",1350.4725000000001,1730.4852000000001,896.43740000000003,529.07470000000001,606.7414,1784.6158,2498.8879999999999,1641.7627,1248.4773,915.57899999999995,641.53880000000004,587.04020000000003,null,14431.112999999999,null,1202.59275]
[]
[null,"Total bills",{"$f":"SUM(C5:C33)","v":668264.26939998684},{"$f":"SUM(D5:D33)","v":670073.2481000002},673079.54120000161,672925.65080000099,675197.7457000023,678477.40020000131,679097.69830000121,677527.32470000139,677759.68810000096,670461.50219999999,667198.60939999879,669011.33730000118,null,8079074.0153999943]

{"sheet":"Assumptions","index":5,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[20,1,20,10],[0,0,0,10],[2,0,2,7],[4,0,4,7],[5,1,5,10],[19,1,19,7]]}
["Assumptions:"]
[]
["Assumed kWh usage in \"Single Bills\" tab to be the midpoint of the kWh range."]
[]
["Assumed the average kWh usage for the \"Over 5000kWh\" range as follows:"]
[null,"Monthly usage numbers were derived by taking a simple average of the kWh used by the number of bills for a specific month, according to the bill frequency data from OCS data request 3.37:"]
[null,null,"month ","average kWh"]
[null,null,"July",{"$f":"'[1]Sch 1'!D37/'[1]Sch 1'!C37","v":7305.1209854328754}]
[null,null,"August",{"$f":"'[1]Sch 1'!D66/'[1]Sch 1'!C66","v":7145.5993960537771}]
[null,null,"Sept",{"$f":"'[1]Sch 1'!D95/'[1]Sch 1'!C95","v":7635.6999384452274}]
[null,null,"Oct",{"$f":"'[1]Sch 1'!D124/'[1]Sch 1'!C124","v":7916.9765630448783}]
[null,null,"Nov",{"$f":"'[1]Sch 1'!D153/'[1]Sch 1'!C153","v":8129.3101146551071}]
[null,null,"Dec",{"$f":"'[1]Sch 1'!D182/'[1]Sch 1'!C182","v":8196.9289972665265}]
[null,null,"Jan",{"$f":"'[1]Sch 1'!D211/'[1]Sch 1'!C211","v":8097.4945655827714}]
[null,null,"Feb",{"$f":"'[1]Sch 1'!D240/'[1]Sch 1'!C240","v":8264.3429528518336}]
[null,null,"Mar",{"$f":"'[1]Sch 1'!D269/'[1]Sch 1'!C269","v":8631.1493208566953}]
[null,null,"April",{"$f":"'[1]Sch 1'!D298/'[1]Sch 1'!C298","v":8976.5285136509247}]
[null,null,"May",{"$f":"'[1]Sch 1'!D327/'[1]Sch 1'!C327","v":8755.5561721286376}]
[null,null,"June",{"$f":"'[1]Sch 1'!D356/'[1]Sch 1'!C356","v":8257.8382195972263}]
[null,"Taking another simple average of these numbers gave an average usage of:",null,null,null,null,null,null,{"$f":"SUM(D8:D19)/12","v":8109.3788116305395},"kWh/month."]
[null,"For simplicity, the model will assume the average usage above 5000 kWh per month is 8000 kWh/month."]
[]
["On the \"Reduced Usage Scenario\" data, to use the correct energy rate, it will need to be re-entered manually after the drop in usage is factored in. This is only applicable if there is a new rate for that usage amount"]
[]
["The bills can be split up evenly by fraction of the year. IE billing rates for May-Sept. can be 5/12 of the year and Oct-April can be 7/12ths of the year."]

{"sheet":"Sheet1","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}