{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["VolumeData","Input","Calculation","Output","Check"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2461,"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":"VolumeData","index":0,"n_rows":64,"n_cols":21,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"CIP Avg Annual Est",null,"T1","T2","T3"]
[null,null,null,null,null,null,{"$f":"SUM(I3:K3)","v":2149},null,1001.3160527512506,1147.6839472487495,0]
[null,null,null,null,null,null,2066,null,1001.3160527512506,1064.6839472487495,0]
[null,null,null,null,null,null,{"$f":"SUM(I5:K5)","v":4693},null,1198.1709868121875,2875.0040927694408,619.82492041837202]
[null,null,null,null,null,null,4720,null,1198.7357889949976,2884.0654843110506,637.1987266939517]
[null,null,null,null,null,null,26933,null,9831.5433379437527,17101.456662056247,0]
[null,null,null,null,null,null,75685,null,11715.326187183033,45792.7184186261,18176.955394190871]
[]
[]
[null,null,null,null,null,"Volumes under CIP m3/cx",null,null,null,null,null,null,null,null,null,null,null,"Actual/Forecasted Volumes"]
[]
[null,null,"Connection Growth (Rate 1)","%"]
[null,null,"Connection Growth (Rate 6)","%"]
[]
[null,null,"Rate Class","Tier",null,null,null,2020,2021,null,null,null,null,null,null,null,null,null,null,2020,2021]
[null,null,null,null,null,null,null,"*Year-end customer connections",null,null,null,null,null,null,null,null,null,null,null,"*Year-end customer connections"]
[null,null,null,null,null,"RATE 1","Existing Residential",161.20897248130734,1694.5471877489144,null,null,null,null,null,null,null,null,"RATE 1","Existing Residential",161.20897248130734,1694.5471877489144]
[null,null,null,null,null,null,"New Residential",12.79102751869266,134.4528122510855,null,null,null,null,null,null,null,null,null,"New Residential",12.79102751869266,134.4528122510855]
[null,null,null,null,null,null,"Small Commercial",1,18,null,null,null,null,null,null,null,null,null,"Small Commercial",1,18]
[null,null,null,null,null,null,"Small Agricultural",0,0,null,null,null,null,null,null,null,null,null,"Small Agricultural",0,0]
[null,null,null,null,null,"RATE 6","Medium Commercial",0,5,null,null,null,null,null,null,null,null,"RATE 6","Medium Commercial",0,5]
[null,null,null,null,null,null,"Large Commercial",0,2,null,null,null,null,null,null,null,null,null,"Large Commercial",0,2]
[]
[null,null,null,null,null,null,null,"*this # represents mid-year connections",null,null,null,null,null,null,null,null,null,null,null,"*this # represents mid-year connections"]
[null,null,null,null,null,"RATE 1","Existing Residential",80.604486240653671,927.87808011511083,null,null,null,null,null,null,null,null,"RATE 1","Existing Residential",80.604486240653671,927.87808011511083]
[null,null,null,null,null,null,"New Residential",6.39551375934633,73.621919884889081,null,null,null,null,null,null,null,null,null,"New Residential",6.39551375934633,73.621919884889081]
[null,null,null,null,null,null,"Small Commercial",0.5,9.5,null,null,null,null,null,null,null,null,null,"Small Commercial",0.5,9.5]
[null,null,null,null,null,null,"Small Agricultural",0,0,null,null,null,null,null,null,null,null,null,"Small Agricultural",0,0]
[null,null,null,null,null,"RATE 6","Medium Commercial",0,2.5,null,null,null,null,null,null,null,null,"RATE 6","Medium Commercial",0,2.5]
[null,null,null,null,null,null,"Large Commercial",0,1,null,null,null,null,null,null,null,null,null,"Large Commercial",0,1]
[null,null,null,null,null,null,null,"*T1 volume",null,null,null,null,null,null,null,null,null,null,null,"*T1 volume"]
[null,null,"Rate 1","Tier 1",null,"RATE 1","Existing Residential",{"$f":"H26*$I3","v":80710.565996533827},929099.21661527141,null,null,null,null,null,null,null,null,"RATE 1","Existing Residential",2517.1761915773791,506667.84880906501]
[null,null,"Rate 1","Tier 1",null,null,"New Residential",6403.9305928249787,73718.810215105943,null,null,null,null,null,null,null,null,null,"New Residential",199.72380842262118,40201.251190935]
[null,null,"Rate 1","Tier 1",null,null,"Small Commercial",599.08549340609375,11382.624374715781,null,null,null,null,null,null,null,null,null,"Small Commercial",0,9031.7999999999993]
[null,null,"Rate 1","Tier 1",null,null,"Small Agricultural",0,0,null,null,null,null,null,null,null,null,null,"Small Agricultural",0,0]
[null,null,"Rate 6","Tier 1",null,"RATE 6","Medium Commercial",0,24578.858344859382,null,null,null,null,null,null,null,null,"RATE 6","Medium Commercial",0,5510]
[null,null,"Rate 6","Tier 1",null,null,"Large Commercial",0,11715.326187183033,null,null,null,null,null,null,null,null,null,"Large Commercial",0,10000]
[]
[null,null,null,null,null,null,null,"*T2 volume",null,null,null,null,null,null,null,null,null,null,null,"*T2 volume"]
[null,null,"Rate 1","Tier 2",null,"RATE 1","Existing Residential",{"$f":"H26*$J3","v":92508.474934630925},1064910.7775521018,null,null,null,null,null,null,null,null,"RATE 1","Existing Residential",332.71043639436567,258366.79235974807]
[null,null,"Rate 1","Tier 2",null,null,"New Residential",6809.2008339845397,78384.07626707491,null,null,null,null,null,null,null,null,null,"New Residential",24.489563605634348,19017.407640251964]
[null,null,"Rate 1","Tier 2",null,null,"Small Commercial",1437.5020463847204,27312.538881309687,null,null,null,null,null,null,null,null,null,"Small Commercial",0,13582.2]
[null,null,"Rate 1","Tier 2",null,null,"Small Agricultural",0,0,null,null,null,null,null,null,null,null,null,"Small Agricultural",0,0]
[null,null,"Rate 6","Tier 2",null,"RATE 6","Medium Commercial",0,42753.641655140615,null,null,null,null,null,null,null,null,"RATE 6","Medium Commercial",0,2689]
[null,null,"Rate 6","Tier 2",null,null,"Large Commercial",0,45792.7184186261,null,null,null,null,null,null,null,null,null,"Large Commercial",0,56088.7]
[]
[null,null,null,null,null,null,null,"*T3 volume",null,null,null,null,null,null,null,null,null,null,null,"*T3 volume"]
[null,null,"Rate 1","Tier 3",null,"RATE 1","Existing Residential",{"$f":"H26*$K3","v":0},0,null,null,null,null,null,null,null,null,"RATE 1","Existing Residential",0,11156.587384054061]
[null,null,"Rate 1","Tier 3",null,null,"New Residential",0,0,null,null,null,null,null,null,null,null,null,"New Residential",0,885.21261594593852]
[null,null,"Rate 1","Tier 3",null,null,"Small Commercial",309.91246020918601,5888.3367439745343,null,null,null,null,null,null,null,null,null,"Small Commercial",0,8653.7999999999993]
[null,null,"Rate 1","Tier 3",null,null,"Small Agricultural",0,0,null,null,null,null,null,null,null,null,null,"Small Agricultural",0,0]
[null,null,"Rate 6","Tier 3",null,"RATE 6","Medium Commercial",0,0,null,null,null,null,null,null,null,null,"RATE 6","Medium Commercial",0,0]
[null,null,"Rate 6","Tier 3",null,null,"Large Commercial",0,18176.955394190871,null,null,null,null,null,null,null,null,null,"Large Commercial",0,44542]
[]
[null,null,null,null,null,null,null,"TOTAL VOL",null,null,null,null,null,null,null,null,null,null,null,"TOTAL VOL"]
[null,null,null,null,null,"RATE 1","Existing Residential",{"$f":"SUM(H33,H41,H49)","v":173219.04093116475},{"$f":"SUM(I33,I41,I49)","v":1994009.9941673731},null,null,null,null,null,null,null,null,"RATE 1","Existing Residential",2849.8866279717449,776191.22855286719]
[null,null,null,null,null,null,"New Residential",{"$f":"SUM(H34,H42,H50)","v":13213.131426809519},152102.88648218085,null,null,null,null,null,null,null,null,null,"New Residential",224.21337202825552,60103.8714471329]
[null,null,null,null,null,null,"Small Commercial",2346.5,44583.5,null,null,null,null,null,null,null,null,null,"Small Commercial",0,31267.8]
[null,null,null,null,null,null,"Small Agricultural",0,0,null,null,null,null,null,null,null,null,null,"Small Agricultural",0,0]
[null,null,null,null,null,"RATE 6","Medium Commercial",0,67332.5,null,null,null,null,null,null,null,null,"RATE 6","Medium Commercial",0,8199]
[null,null,null,null,null,null,"Large Commercial",0,75685,null,null,null,null,null,null,null,null,null,"Large Commercial",0,110630.7]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Check",null,{"$f":"ABS(SUM(T57:T58)-SUM(#REF!))","v":{"$error":"#REF!"}},{"$f":"ABS(SUM(U57:U58)-SUM(#REF!))","v":{"$error":"#REF!"}}]

{"sheet":"Input","index":1,"n_rows":89,"n_cols":11,"rows_kept":89,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)","v":"Input"}]
[null,null,"Master Check",{"$f":"Check!E18","v":3.8562575355172157E-10}]
[null,null,null,null,null,null,null,null,2019,2020,2021]
[]
[null,null,"General"]
[]
[null,null,"OEB Prescribed Rate","%",null,null,null,null,{"$f":"AVERAGE(0.0245,0.0218,0.0218,0.0218)","v":2.2474999999999998E-2},{"$f":"AVERAGE(0.0218,0.0218,0.0057,0.0057)","v":1.3749999999999998E-2},{"$f":"AVERAGE(0.0057,0.0057,0.0057,0.0057)","v":5.7000000000000002E-3}]
[]
[null,null,"List"]
[]
[null,null,"Rate Class"]
[]
[null,null,"Rate 1"]
[null,null,"Rate 6"]
[]
[null,null,"Tier"]
[]
[null,null,"Tier 1"]
[null,null,"Tier 2"]
[null,null,"Tier 3"]
[]
[null,null,"Customer Type"]
[]
[null,null,null,null,"Rate Class"]
[null,null,"Existing Residential",null,"Rate 1"]
[null,null,"New Residential",null,"Rate 1"]
[null,null,"Small Commercial",null,"Rate 1"]
[null,null,"Small Agricultural",null,"Rate 1"]
[null,null,"Medium Commercial",null,"Rate 6"]
[null,null,"Large Commercial",null,"Rate 6"]
[]
[]
[]
[]
[]
[null,null,"Volume with CIP Assumptions"]
[]
[null,null,null,null,"Rate Class","Tier"]
[null,null,"Rate 1 - General Firm Service"]
[null,null,"Tier 1","m3","Rate 1","Tier 1",null,{"$f":"SUM(I40:K40)","v":1101914.2332878578},0,{"$f":"SUMIFS(VolumeData!H$18:H$62,VolumeData!$C$18:$C$62,$E40,VolumeData!$D$18:$D$62,$F40)","v":87713.5820827649},{"$f":"SUMIFS(VolumeData!I$18:I$62,VolumeData!$C$18:$C$62,$E40,VolumeData!$D$18:$D$62,$F40)","v":1014200.651205093}]
[null,null,"Tier 2","m3","Rate 1","Tier 2",null,{"$f":"SUM(I41:K41)","v":1271362.5705154864},0,{"$f":"SUMIFS(VolumeData!H$18:H$62,VolumeData!$C$18:$C$62,$E41,VolumeData!$D$18:$D$62,$F41)","v":100755.17781500018},{"$f":"SUMIFS(VolumeData!I$18:I$62,VolumeData!$C$18:$C$62,$E41,VolumeData!$D$18:$D$62,$F41)","v":1170607.3927004864}]
[null,null,"Tier 3","m3","Rate 1","Tier 3",null,{"$f":"SUM(I42:K42)","v":6198.2492041837204},0,{"$f":"SUMIFS(VolumeData!H$18:H$62,VolumeData!$C$18:$C$62,$E42,VolumeData!$D$18:$D$62,$F42)","v":309.91246020918601},{"$f":"SUMIFS(VolumeData!I$18:I$62,VolumeData!$C$18:$C$62,$E42,VolumeData!$D$18:$D$62,$F42)","v":5888.3367439745343}]
[null,null,"Upstream Recover Charge","m3",null,null,null,{"$f":"SUM(I43:K43)","v":2379475.0530075282},{"$f":"SUM(I40:I42)","v":0},188778.67235797425,2190696.3806495541]
[null,null,"Delay Rate Rider","m3",null,null,null,{"$f":"SUM(I44:K44)","v":2379475.0530075282},{"$f":"I43","v":0},188778.67235797425,2190696.3806495541]
[]
[null,null,"Rate 6 - Large Volume General Firm Service"]
[null,null,"Tier 1","m3","Rate 6","Tier 1",null,{"$f":"SUM(I47:K47)","v":36294.184532042418},0,{"$f":"SUMIFS(VolumeData!H$18:H$62,VolumeData!$C$18:$C$62,$E47,VolumeData!$D$18:$D$62,$F47)","v":0},{"$f":"SUMIFS(VolumeData!I$18:I$62,VolumeData!$C$18:$C$62,$E47,VolumeData!$D$18:$D$62,$F47)","v":36294.184532042418}]
[null,null,"Tier 2","m3","Rate 6","Tier 2",null,{"$f":"SUM(I48:K48)","v":88546.360073766715},0,{"$f":"SUMIFS(VolumeData!H$18:H$62,VolumeData!$C$18:$C$62,$E48,VolumeData!$D$18:$D$62,$F48)","v":0},{"$f":"SUMIFS(VolumeData!I$18:I$62,VolumeData!$C$18:$C$62,$E48,VolumeData!$D$18:$D$62,$F48)","v":88546.360073766715}]
[null,null,"Tier 3","m3","Rate 6","Tier 3",null,{"$f":"SUM(I49:K49)","v":18176.955394190871},0,{"$f":"SUMIFS(VolumeData!H$18:H$62,VolumeData!$C$18:$C$62,$E49,VolumeData!$D$18:$D$62,$F49)","v":0},{"$f":"SUMIFS(VolumeData!I$18:I$62,VolumeData!$C$18:$C$62,$E49,VolumeData!$D$18:$D$62,$F49)","v":18176.955394190871}]
[null,null,"Upstream Recover Charge","m3",null,null,null,{"$f":"SUM(I50:K50)","v":143017.5},{"$f":"SUM(I47:I49)","v":0},{"$f":"SUM(J47:J49)","v":0},{"$f":"SUM(K47:K49)","v":143017.5}]
[null,null,"Delay Rate Rider","m3",null,null,null,{"$f":"SUM(I51:K51)","v":143017.5},{"$f":"I50","v":0},{"$f":"J50","v":0},{"$f":"K50","v":143017.5}]
[]
[null,null,"Volume with Actual Experience"]
[]
[null,null,"Rate 1 - General Firm Service"]
[null,null,"Tier 1","m3","Rate 1","Tier 1",null,{"$f":"SUM(I56:K56)","v":558617.80000000005},0,{"$f":"SUMIFS(VolumeData!T$18:T$62,VolumeData!$C$18:$C$62,$E56,VolumeData!$D$18:$D$62,$F56)","v":2716.9},{"$f":"SUMIFS(VolumeData!U$18:U$62,VolumeData!$C$18:$C$62,$E56,VolumeData!$D$18:$D$62,$F56)","v":555900.9}]
[null,null,"Tier 2","m3","Rate 1","Tier 2",null,{"$f":"SUM(I57:K57)","v":291323.60000000003},0,{"$f":"SUMIFS(VolumeData!T$18:T$62,VolumeData!$C$18:$C$62,$E57,VolumeData!$D$18:$D$62,$F57)","v":357.20000000000005},{"$f":"SUMIFS(VolumeData!U$18:U$62,VolumeData!$C$18:$C$62,$E57,VolumeData!$D$18:$D$62,$F57)","v":290966.40000000002}]
[null,null,"Tier 3","m3","Rate 1","Tier 3",null,{"$f":"SUM(I58:K58)","v":20695.599999999999},0,{"$f":"SUMIFS(VolumeData!T$18:T$62,VolumeData!$C$18:$C$62,$E58,VolumeData!$D$18:$D$62,$F58)","v":0},{"$f":"SUMIFS(VolumeData!U$18:U$62,VolumeData!$C$18:$C$62,$E58,VolumeData!$D$18:$D$62,$F58)","v":20695.599999999999}]
[]
[null,null,"Delay Rate Rider","m3",null,null,null,{"$f":"SUM(I60:K60)","v":870637},{"$f":"I59","v":0},{"$f":"SUM(J56:J59)","v":3074.1000000000004},{"$f":"SUM(K56:K59)","v":867562.9}]
[]
[null,null,"Rate 6 - Large Volume General Firm Service"]
[null,null,"Tier 1","m3","Rate 6","Tier 1",null,{"$f":"SUM(I63:K63)","v":15510},0,{"$f":"SUMIFS(VolumeData!T$18:T$62,VolumeData!$C$18:$C$62,$E63,VolumeData!$D$18:$D$62,$F63)","v":0},{"$f":"SUMIFS(VolumeData!U$18:U$62,VolumeData!$C$18:$C$62,$E63,VolumeData!$D$18:$D$62,$F63)","v":15510}]
[null,null,"Tier 2","m3","Rate 6","Tier 2",null,{"$f":"SUM(I64:K64)","v":58777.7},0,{"$f":"SUMIFS(VolumeData!T$18:T$62,VolumeData!$C$18:$C$62,$E64,VolumeData!$D$18:$D$62,$F64)","v":0},{"$f":"SUMIFS(VolumeData!U$18:U$62,VolumeData!$C$18:$C$62,$E64,VolumeData!$D$18:$D$62,$F64)","v":58777.7}]
[null,null,"Tier 3","m3","Rate 6","Tier 3",null,{"$f":"SUM(I65:K65)","v":44542},0,{"$f":"SUMIFS(VolumeData!T$18:T$62,VolumeData!$C$18:$C$62,$E65,VolumeData!$D$18:$D$62,$F65)","v":0},{"$f":"SUMIFS(VolumeData!U$18:U$62,VolumeData!$C$18:$C$62,$E65,VolumeData!$D$18:$D$62,$F65)","v":44542}]
[]
[null,null,"Delay Rate Rider","m3",null,null,null,{"$f":"SUM(I67:K67)","v":118829.7},{"$f":"I66","v":0},{"$f":"SUM(J63:J66)","v":0},{"$f":"SUM(K63:K66)","v":118829.7}]
[]
[null,null,"Revenue Rates"]
[]
[null,null,null,null,"Rate Class","Tier"]
[]
[null,null,"Rate 1"]
[]
[null,null,"Tier 1 Volumetric Rate","cents/ m3","Rate 1","Tier 1",null,null,26.794799999999999,{"$f":"I75*1.015","v":27.196721999999998},27.620999999999999]
[null,null,"Tier 2 Volumetric Rate","cents/ m3","Rate 1","Tier 2",null,null,26.266999999999999,{"$f":"I76*1.015","v":26.661004999999996},27.076899999999998]
[null,null,"Tier 3 Volumetric Rate","cents/ m3","Rate 1","Tier 3",null,null,25.491099999999999,25.873466499999996,26.277100000000001]
[null,null,"Upstream Recover Charge","cents/ m3"]
[null,null,"Delay Rate Rider","cents/ m3",null,null,null,null,1.633,1.633,1.633]
[]
[null,null,"Rate 6"]
[]
[null,null,"Tier 1 Volumetric Rate","cents/ m3","Rate 6","Tier 1",null,null,24.718900000000001,25.089700000000001,25.481100000000001]
[null,null,"Tier 2 Volumetric Rate","cents/ m3","Rate 6","Tier 2",null,null,22.247,22.5807,22.933]
[null,null,"Tier 3 Volumetric Rate","cents/ m3","Rate 6","Tier 3",null,null,21.134599999999999,21.451599999999999,21.786200000000001]
[null,null,"Upstream Recover Charge","cents/ m3"]
[null,null,"Delay Rate Rider","cents/ m3",null,null,null,null,0.90900000000000003,0.90900000000000003,0.90900000000000003]
[]
[null,null,"Check",null,null,null,null,null,null,{"$f":"ABS(J43+J50-SUM(VolumeData!H57:H62))","v":2.9103830456733704E-11},{"$f":"ABS(K43+K50-SUM(VolumeData!I57:I62))","v":0}]

{"sheet":"Calculation","index":2,"n_rows":324,"n_cols":11,"rows_kept":324,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)","v":"Calculation"}]
[null,null,"Master Check",{"$f":"Check!E18","v":3.8562575355172157E-10}]
[null,null,null,null,null,null,null,null,{"$f":"Input!I3","v":2019},{"$f":"Input!J3","v":2020},{"$f":"Input!K3","v":2021}]
[]
[null,null,"Connection Growth"]
[null,null,"Connection Growth"]
[]
[null,null,"Shared Between CIP and Actual / Forecast"]
[]
[null,null,"Revenue Rates by Customer Type by Tiers"]
[]
[null,null,"Tier 1"]
[null,null,null,null,"Rate Class","Tier"]
[null,null,"Existing Residential","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C14,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C12","v":"Tier 1"},null,null,null,{"$f":"SUMIFS(Input!J$75:J$87,Input!$E$75:$E$87,$E14,Input!$F$75:$F$87,$F14)","v":27.196721999999998},{"$f":"SUMIFS(Input!K$75:K$87,Input!$E$75:$E$87,$E14,Input!$F$75:$F$87,$F14)","v":27.620999999999999}]
[null,null,"New Residential","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C15,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C12","v":"Tier 1"},null,null,null,{"$f":"SUMIFS(Input!J$75:J$87,Input!$E$75:$E$87,$E15,Input!$F$75:$F$87,$F15)","v":27.196721999999998},{"$f":"SUMIFS(Input!K$75:K$87,Input!$E$75:$E$87,$E15,Input!$F$75:$F$87,$F15)","v":27.620999999999999}]
[null,null,"Small Commercial","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C16,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C12","v":"Tier 1"},null,null,null,{"$f":"SUMIFS(Input!J$75:J$87,Input!$E$75:$E$87,$E16,Input!$F$75:$F$87,$F16)","v":27.196721999999998},{"$f":"SUMIFS(Input!K$75:K$87,Input!$E$75:$E$87,$E16,Input!$F$75:$F$87,$F16)","v":27.620999999999999}]
[null,null,"Small Agricultural","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C17,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C12","v":"Tier 1"},null,null,null,{"$f":"SUMIFS(Input!J$75:J$87,Input!$E$75:$E$87,$E17,Input!$F$75:$F$87,$F17)","v":27.196721999999998},{"$f":"SUMIFS(Input!K$75:K$87,Input!$E$75:$E$87,$E17,Input!$F$75:$F$87,$F17)","v":27.620999999999999}]
[]
[]
[null,null,"Medium Commercial","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C20,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C12","v":"Tier 1"},null,null,null,{"$f":"SUMIFS(Input!J$75:J$87,Input!$E$75:$E$87,$E20,Input!$F$75:$F$87,$F20)","v":25.089700000000001},{"$f":"SUMIFS(Input!K$75:K$87,Input!$E$75:$E$87,$E20,Input!$F$75:$F$87,$F20)","v":25.481100000000001}]
[null,null,"Large Commercial","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C21,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C12","v":"Tier 1"},null,null,null,{"$f":"SUMIFS(Input!J$75:J$87,Input!$E$75:$E$87,$E21,Input!$F$75:$F$87,$F21)","v":25.089700000000001},{"$f":"SUMIFS(Input!K$75:K$87,Input!$E$75:$E$87,$E21,Input!$F$75:$F$87,$F21)","v":25.481100000000001}]
[]
[]
[null,null,"Tier 2"]
[null,null,null,null,"Rate Class","Tier"]
[null,null,"Existing Residential","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C26,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C24","v":"Tier 2"},null,null,null,{"$f":"SUMIFS(Input!J$75:J$87,Input!$E$75:$E$87,$E26,Input!$F$75:$F$87,$F26)","v":26.661004999999996},{"$f":"SUMIFS(Input!K$75:K$87,Input!$E$75:$E$87,$E26,Input!$F$75:$F$87,$F26)","v":27.076899999999998}]
[null,null,"New Residential","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C27,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C24","v":"Tier 2"},null,null,null,{"$f":"SUMIFS(Input!J$75:J$87,Input!$E$75:$E$87,$E27,Input!$F$75:$F$87,$F27)","v":26.661004999999996},{"$f":"SUMIFS(Input!K$75:K$87,Input!$E$75:$E$87,$E27,Input!$F$75:$F$87,$F27)","v":27.076899999999998}]
[null,null,"Small Commercial","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C28,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C24","v":"Tier 2"},null,null,null,{"$f":"SUMIFS(Input!J$75:J$87,Input!$E$75:$E$87,$E28,Input!$F$75:$F$87,$F28)","v":26.661004999999996},{"$f":"SUMIFS(Input!K$75:K$87,Input!$E$75:$E$87,$E28,Input!$F$75:$F$87,$F28)","v":27.076899999999998}]
[null,null,"Small Agricultural","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C29,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C24","v":"Tier 2"},null,null,null,{"$f":"SUMIFS(Input!J$75:J$87,Input!$E$75:$E$87,$E29,Input!$F$75:$F$87,$F29)","v":26.661004999999996},{"$f":"SUMIFS(Input!K$75:K$87,Input!$E$75:$E$87,$E29,Input!$F$75:$F$87,$F29)","v":27.076899999999998}]
[]
[]
[null,null,"Medium Commercial","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C32,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C24","v":"Tier 2"},null,null,null,{"$f":"SUMIFS(Input!J$75:J$87,Input!$E$75:$E$87,$E32,Input!$F$75:$F$87,$F32)","v":22.5807},{"$f":"SUMIFS(Input!K$75:K$87,Input!$E$75:$E$87,$E32,Input!$F$75:$F$87,$F32)","v":22.933}]
[null,null,"Large Commercial","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C33,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C24","v":"Tier 2"},null,null,null,{"$f":"SUMIFS(Input!J$75:J$87,Input!$E$75:$E$87,$E33,Input!$F$75:$F$87,$F33)","v":22.5807},{"$f":"SUMIFS(Input!K$75:K$87,Input!$E$75:$E$87,$E33,Input!$F$75:$F$87,$F33)","v":22.933}]
[]
[]
[null,null,"Tier 3"]
[null,null,null,null,"Rate Class","Tier"]
[null,null,"Existing Residential","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C38,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C36","v":"Tier 3"},null,null,null,{"$f":"SUMIFS(Input!J$75:J$87,Input!$E$75:$E$87,$E38,Input!$F$75:$F$87,$F38)","v":25.873466499999996},{"$f":"SUMIFS(Input!K$75:K$87,Input!$E$75:$E$87,$E38,Input!$F$75:$F$87,$F38)","v":26.277100000000001}]
[null,null,"New Residential","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C39,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C36","v":"Tier 3"},null,null,null,{"$f":"SUMIFS(Input!J$75:J$87,Input!$E$75:$E$87,$E39,Input!$F$75:$F$87,$F39)","v":25.873466499999996},{"$f":"SUMIFS(Input!K$75:K$87,Input!$E$75:$E$87,$E39,Input!$F$75:$F$87,$F39)","v":26.277100000000001}]
[null,null,"Small Commercial","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C40,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C36","v":"Tier 3"},null,null,null,{"$f":"SUMIFS(Input!J$75:J$87,Input!$E$75:$E$87,$E40,Input!$F$75:$F$87,$F40)","v":25.873466499999996},{"$f":"SUMIFS(Input!K$75:K$87,Input!$E$75:$E$87,$E40,Input!$F$75:$F$87,$F40)","v":26.277100000000001}]
[null,null,"Small Agricultural","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C41,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C36","v":"Tier 3"},null,null,null,{"$f":"SUMIFS(Input!J$75:J$87,Input!$E$75:$E$87,$E41,Input!$F$75:$F$87,$F41)","v":25.873466499999996},{"$f":"SUMIFS(Input!K$75:K$87,Input!$E$75:$E$87,$E41,Input!$F$75:$F$87,$F41)","v":26.277100000000001}]
[]
[]
[null,null,"Medium Commercial","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C44,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C36","v":"Tier 3"},null,null,null,{"$f":"SUMIFS(Input!J$75:J$87,Input!$E$75:$E$87,$E44,Input!$F$75:$F$87,$F44)","v":21.451599999999999},{"$f":"SUMIFS(Input!K$75:K$87,Input!$E$75:$E$87,$E44,Input!$F$75:$F$87,$F44)","v":21.786200000000001}]
[null,null,"Large Commercial","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C45,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C36","v":"Tier 3"},null,null,null,{"$f":"SUMIFS(Input!J$75:J$87,Input!$E$75:$E$87,$E45,Input!$F$75:$F$87,$F45)","v":21.451599999999999},{"$f":"SUMIFS(Input!K$75:K$87,Input!$E$75:$E$87,$E45,Input!$F$75:$F$87,$F45)","v":21.786200000000001}]
[]
[]
[null,null,"Upstream Recover Charge"]
[null,null,null,null,"Rate Class"]
[null,null,"Existing Residential","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C50,Input!$C$25:$C$30,0))","v":"Rate 1"}]
[null,null,"New Residential","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C51,Input!$C$25:$C$30,0))","v":"Rate 1"}]
[null,null,"Small Commercial","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C52,Input!$C$25:$C$30,0))","v":"Rate 1"}]
[null,null,"Small Agricultural","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C53,Input!$C$25:$C$30,0))","v":"Rate 1"}]
[]
[]
[null,null,"Medium Commercial","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C56,Input!$C$25:$C$30,0))","v":"Rate 6"}]
[null,null,"Large Commercial","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C57,Input!$C$25:$C$30,0))","v":"Rate 6"}]
[]
[]
[null,null,"Delay Rate Rider"]
[null,null,null,null,"Rate Class"]
[null,null,"Existing Residential","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C62,Input!$C$25:$C$30,0))","v":"Rate 1"},null,null,null,null,{"$f":"Input!J$79","v":1.633},{"$f":"Input!K$79","v":1.633}]
[null,null,"New Residential","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C63,Input!$C$25:$C$30,0))","v":"Rate 1"},null,null,null,null,{"$f":"Input!J$79","v":1.633},{"$f":"Input!K$79","v":1.633}]
[null,null,"Small Commercial","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C64,Input!$C$25:$C$30,0))","v":"Rate 1"},null,null,null,null,{"$f":"Input!J$79","v":1.633},{"$f":"Input!K$79","v":1.633}]
[null,null,"Small Agricultural","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C65,Input!$C$25:$C$30,0))","v":"Rate 1"},null,null,null,null,{"$f":"Input!J$79","v":1.633},{"$f":"Input!K$79","v":1.633}]
[]
[]
[null,null,"Medium Commercial","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C68,Input!$C$25:$C$30,0))","v":"Rate 6"},null,null,null,null,{"$f":"Input!J$87","v":0.90900000000000003},{"$f":"Input!K$87","v":0.90900000000000003}]
[null,null,"Large Commercial","cents/ m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C69,Input!$C$25:$C$30,0))","v":"Rate 6"},null,null,null,null,{"$f":"Input!J$87","v":0.90900000000000003},{"$f":"Input!K$87","v":0.90900000000000003}]
[]
[]
[]
[null,null,"CIP"]
[]
[null,null,"Volume by Customer Type by Tiers"]
[]
[null,null,"Tier 1"]
[null,null,null,null,"Rate Class","Tier","Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C79,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C77","v":"Tier 1"},{"$f":"C79","v":"Existing Residential"},null,null,{"$f":"SUMIFS(VolumeData!H$33:H$54,VolumeData!$C$33:$C$54,$E79,VolumeData!$D$33:$D$54,$F79,VolumeData!$G$33:$G$54,$G79)","v":80710.565996533827},{"$f":"SUMIFS(VolumeData!I$33:I$54,VolumeData!$C$33:$C$54,$E79,VolumeData!$D$33:$D$54,$F79,VolumeData!$G$33:$G$54,$G79)","v":929099.21661527141}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C80,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C77","v":"Tier 1"},{"$f":"C80","v":"New Residential"},null,null,{"$f":"SUMIFS(VolumeData!H$33:H$54,VolumeData!$C$33:$C$54,$E80,VolumeData!$D$33:$D$54,$F80,VolumeData!$G$33:$G$54,$G80)","v":6403.9305928249787},{"$f":"SUMIFS(VolumeData!I$33:I$54,VolumeData!$C$33:$C$54,$E80,VolumeData!$D$33:$D$54,$F80,VolumeData!$G$33:$G$54,$G80)","v":73718.810215105943}]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C81,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C77","v":"Tier 1"},"Small Commercial",null,null,{"$f":"SUMIFS(VolumeData!H$33:H$54,VolumeData!$C$33:$C$54,$E81,VolumeData!$D$33:$D$54,$F81,VolumeData!$G$33:$G$54,$G81)","v":599.08549340609375},{"$f":"SUMIFS(VolumeData!I$33:I$54,VolumeData!$C$33:$C$54,$E81,VolumeData!$D$33:$D$54,$F81,VolumeData!$G$33:$G$54,$G81)","v":11382.624374715781}]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C82,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C77","v":"Tier 1"},"Small Agricultural",null,null,{"$f":"SUMIFS(VolumeData!H$33:H$54,VolumeData!$C$33:$C$54,$E82,VolumeData!$D$33:$D$54,$F82,VolumeData!$G$33:$G$54,$G82)","v":0},{"$f":"SUMIFS(VolumeData!I$33:I$54,VolumeData!$C$33:$C$54,$E82,VolumeData!$D$33:$D$54,$F82,VolumeData!$G$33:$G$54,$G82)","v":0}]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J79:J82)","v":87713.5820827649},{"$f":"SUM(K79:K82)","v":1014200.651205093}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C85,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C77","v":"Tier 1"},{"$f":"C85","v":"Medium Commercial"},null,null,{"$f":"SUMIFS(VolumeData!H$33:H$54,VolumeData!$C$33:$C$54,$E85,VolumeData!$D$33:$D$54,$F85,VolumeData!$G$33:$G$54,$G85)","v":0},{"$f":"SUMIFS(VolumeData!I$33:I$54,VolumeData!$C$33:$C$54,$E85,VolumeData!$D$33:$D$54,$F85,VolumeData!$G$33:$G$54,$G85)","v":24578.858344859382}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C86,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C77","v":"Tier 1"},{"$f":"C86","v":"Large Commercial"},null,null,{"$f":"SUMIFS(VolumeData!H$33:H$54,VolumeData!$C$33:$C$54,$E86,VolumeData!$D$33:$D$54,$F86,VolumeData!$G$33:$G$54,$G86)","v":0},{"$f":"SUMIFS(VolumeData!I$33:I$54,VolumeData!$C$33:$C$54,$E86,VolumeData!$D$33:$D$54,$F86,VolumeData!$G$33:$G$54,$G86)","v":11715.326187183033}]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J85:J86)","v":0},{"$f":"SUM(K85:K86)","v":36294.184532042418}]
[]
[null,null,"Tier 2"]
[null,null,null,null,"Rate Class","Tier","Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C91,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C89","v":"Tier 2"},{"$f":"C91","v":"Existing Residential"},null,null,{"$f":"SUMIFS(VolumeData!H$33:H$54,VolumeData!$C$33:$C$54,$E91,VolumeData!$D$33:$D$54,$F91,VolumeData!$G$33:$G$54,$G91)","v":92508.474934630925},{"$f":"SUMIFS(VolumeData!I$33:I$54,VolumeData!$C$33:$C$54,$E91,VolumeData!$D$33:$D$54,$F91,VolumeData!$G$33:$G$54,$G91)","v":1064910.7775521018}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C92,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C89","v":"Tier 2"},{"$f":"C92","v":"New Residential"},null,null,{"$f":"SUMIFS(VolumeData!H$33:H$54,VolumeData!$C$33:$C$54,$E92,VolumeData!$D$33:$D$54,$F92,VolumeData!$G$33:$G$54,$G92)","v":6809.2008339845397},{"$f":"SUMIFS(VolumeData!I$33:I$54,VolumeData!$C$33:$C$54,$E92,VolumeData!$D$33:$D$54,$F92,VolumeData!$G$33:$G$54,$G92)","v":78384.07626707491}]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C93,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C89","v":"Tier 2"},"Small Commercial",null,null,{"$f":"SUMIFS(VolumeData!H$33:H$54,VolumeData!$C$33:$C$54,$E93,VolumeData!$D$33:$D$54,$F93,VolumeData!$G$33:$G$54,$G93)","v":1437.5020463847204},{"$f":"SUMIFS(VolumeData!I$33:I$54,VolumeData!$C$33:$C$54,$E93,VolumeData!$D$33:$D$54,$F93,VolumeData!$G$33:$G$54,$G93)","v":27312.538881309687}]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C94,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C89","v":"Tier 2"},"Small Agricultural",null,null,{"$f":"SUMIFS(VolumeData!H$33:H$54,VolumeData!$C$33:$C$54,$E94,VolumeData!$D$33:$D$54,$F94,VolumeData!$G$33:$G$54,$G94)","v":0},{"$f":"SUMIFS(VolumeData!I$33:I$54,VolumeData!$C$33:$C$54,$E94,VolumeData!$D$33:$D$54,$F94,VolumeData!$G$33:$G$54,$G94)","v":0}]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J91:J94)","v":100755.17781500018},{"$f":"SUM(K91:K94)","v":1170607.3927004864}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C97,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C89","v":"Tier 2"},{"$f":"C97","v":"Medium Commercial"},null,null,{"$f":"SUMIFS(VolumeData!H$33:H$54,VolumeData!$C$33:$C$54,$E97,VolumeData!$D$33:$D$54,$F97,VolumeData!$G$33:$G$54,$G97)","v":0},{"$f":"SUMIFS(VolumeData!I$33:I$54,VolumeData!$C$33:$C$54,$E97,VolumeData!$D$33:$D$54,$F97,VolumeData!$G$33:$G$54,$G97)","v":42753.641655140615}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C98,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C89","v":"Tier 2"},"Large Commercial",null,null,{"$f":"SUMIFS(VolumeData!H$33:H$54,VolumeData!$C$33:$C$54,$E98,VolumeData!$D$33:$D$54,$F98,VolumeData!$G$33:$G$54,$G98)","v":0},{"$f":"SUMIFS(VolumeData!I$33:I$54,VolumeData!$C$33:$C$54,$E98,VolumeData!$D$33:$D$54,$F98,VolumeData!$G$33:$G$54,$G98)","v":45792.7184186261}]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J97:J98)","v":0},{"$f":"SUM(K97:K98)","v":88546.360073766715}]
[]
[null,null,"Tier 3"]
[null,null,null,null,"Rate Class","Tier","Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C103,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C101","v":"Tier 3"},{"$f":"C103","v":"Existing Residential"},null,null,{"$f":"SUMIFS(VolumeData!H$33:H$54,VolumeData!$C$33:$C$54,$E103,VolumeData!$D$33:$D$54,$F103,VolumeData!$G$33:$G$54,$G103)","v":0},{"$f":"SUMIFS(VolumeData!I$33:I$54,VolumeData!$C$33:$C$54,$E103,VolumeData!$D$33:$D$54,$F103,VolumeData!$G$33:$G$54,$G103)","v":0}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C104,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C101","v":"Tier 3"},{"$f":"C104","v":"New Residential"},null,null,{"$f":"SUMIFS(VolumeData!H$33:H$54,VolumeData!$C$33:$C$54,$E104,VolumeData!$D$33:$D$54,$F104,VolumeData!$G$33:$G$54,$G104)","v":0},{"$f":"SUMIFS(VolumeData!I$33:I$54,VolumeData!$C$33:$C$54,$E104,VolumeData!$D$33:$D$54,$F104,VolumeData!$G$33:$G$54,$G104)","v":0}]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C105,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C101","v":"Tier 3"},"Small Commercial",null,null,{"$f":"SUMIFS(VolumeData!H$33:H$54,VolumeData!$C$33:$C$54,$E105,VolumeData!$D$33:$D$54,$F105,VolumeData!$G$33:$G$54,$G105)","v":309.91246020918601},{"$f":"SUMIFS(VolumeData!I$33:I$54,VolumeData!$C$33:$C$54,$E105,VolumeData!$D$33:$D$54,$F105,VolumeData!$G$33:$G$54,$G105)","v":5888.3367439745343}]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C106,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C101","v":"Tier 3"},"Small Agricultural",null,null,{"$f":"SUMIFS(VolumeData!H$33:H$54,VolumeData!$C$33:$C$54,$E106,VolumeData!$D$33:$D$54,$F106,VolumeData!$G$33:$G$54,$G106)","v":0},{"$f":"SUMIFS(VolumeData!I$33:I$54,VolumeData!$C$33:$C$54,$E106,VolumeData!$D$33:$D$54,$F106,VolumeData!$G$33:$G$54,$G106)","v":0}]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J103:J106)","v":309.91246020918601},{"$f":"SUM(K103:K106)","v":5888.3367439745343}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C109,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C101","v":"Tier 3"},{"$f":"C109","v":"Medium Commercial"},null,null,{"$f":"SUMIFS(VolumeData!H$33:H$54,VolumeData!$C$33:$C$54,$E109,VolumeData!$D$33:$D$54,$F109,VolumeData!$G$33:$G$54,$G109)","v":0},{"$f":"SUMIFS(VolumeData!I$33:I$54,VolumeData!$C$33:$C$54,$E109,VolumeData!$D$33:$D$54,$F109,VolumeData!$G$33:$G$54,$G109)","v":0}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C110,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C101","v":"Tier 3"},"Large Commercial",null,null,{"$f":"SUMIFS(VolumeData!H$33:H$54,VolumeData!$C$33:$C$54,$E110,VolumeData!$D$33:$D$54,$F110,VolumeData!$G$33:$G$54,$G110)","v":0},{"$f":"SUMIFS(VolumeData!I$33:I$54,VolumeData!$C$33:$C$54,$E110,VolumeData!$D$33:$D$54,$F110,VolumeData!$G$33:$G$54,$G110)","v":18176.955394190871}]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J109:J110)","v":0},{"$f":"SUM(K109:K110)","v":18176.955394190871}]
[]
[null,null,"Total Volume"]
[null,null,null,null,"Rate Class",null,"Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C115,Input!$C$25:$C$30,0))","v":"Rate 1"},null,{"$f":"C115","v":"Existing Residential"},null,null,{"$f":"J79+J91+J103","v":173219.04093116475},{"$f":"K79+K91+K103","v":1994009.9941673731}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C116,Input!$C$25:$C$30,0))","v":"Rate 1"},null,{"$f":"C116","v":"New Residential"},null,null,{"$f":"J80+J92+J104","v":13213.131426809519},152102.88648218085]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C117,Input!$C$25:$C$30,0))","v":"Rate 1"},null,"Small Commercial",null,null,2346.5,44583.5]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C118,Input!$C$25:$C$30,0))","v":"Rate 1"},null,"Small Agricultural",null,null,0,0]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J115:J118)","v":188778.67235797428},{"$f":"SUM(K115:K118)","v":2190696.3806495541}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C121,Input!$C$25:$C$30,0))","v":"Rate 6"},null,{"$f":"C121","v":"Medium Commercial"},null,null,{"$f":"J85+J97+J109","v":0},{"$f":"K85+K97+K109","v":67332.5}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C122,Input!$C$25:$C$30,0))","v":"Rate 6"},null,"Large Commercial",null,null,{"$f":"J86+J98+J110","v":0},75685]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J121:J122)","v":0},{"$f":"SUM(K121:K122)","v":143017.5}]
[]
[null,null,"Revenue by Customer Type by Tiers"]
[]
[null,null,"Tier 1"]
[null,null,null,null,"Rate Class","Tier","Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C129,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C127","v":"Tier 1"},{"$f":"C129","v":"Existing Residential"},null,null,{"$f":"J14*J79/100","v":21950.628258703829},{"$f":"K14*K79/100","v":256626.4946213041}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C130,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C127","v":"Tier 1"},{"$f":"C130","v":"New Residential"},null,null,{"$f":"J15*J80/100","v":1741.659200403561},20361.872569514409]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C131,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C127","v":"Tier 1"},"Small Commercial",null,null,{"$f":"J16*J81/100","v":162.93161618398364},3143.9946785402453]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C132,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C127","v":"Tier 1"},"Small Agricultural",null,null,{"$f":"J17*J82/100","v":0},0]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J129:J132)","v":23855.219075291378},{"$f":"SUM(K129:K132)","v":280132.36186935881}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C135,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C127","v":"Tier 1"},{"$f":"C135","v":"Medium Commercial"},null,null,{"$f":"J20*J85/100","v":0},{"$f":"K20*K85/100","v":6262.9634737119641}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C136,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C127","v":"Tier 1"},"Large Commercial",null,null,{"$f":"J21*J86/100","v":0},2985.1939810822955]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J135:J136)","v":0},{"$f":"SUM(K135:K136)","v":9248.15745479426}]
[]
[null,null,"Tier 2"]
[null,null,null,null,"Rate Class","Tier","Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C141,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C139","v":"Tier 2"},{"$f":"C141","v":"Existing Residential"},null,null,{"$f":"J26*J91/100","v":24663.689127745693},{"$f":"K26*K91/100","v":288344.82632700505}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C142,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C139","v":"Tier 2"},{"$f":"C142","v":"New Residential"},null,null,{"$f":"J27*J92/100","v":1815.4013748086595},21223.977946759605]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C143,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C139","v":"Tier 2"},"Small Commercial",null,null,{"$f":"J28*J93/100","v":383.25249246173257},7395.3888403533419]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C144,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C139","v":"Tier 2"},"Small Agricultural",null,null,{"$f":"J29*J94/100","v":0},0]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J141:J144)","v":26862.342995016083},{"$f":"SUM(K141:K144)","v":316964.19311411801}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C147,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C139","v":"Tier 2"},{"$f":"C147","v":"Medium Commercial"},null,null,{"$f":"J32*J97/100","v":0},{"$f":"K32*K97/100","v":9804.6926407733972}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C148,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C139","v":"Tier 2"},"Large Commercial",null,null,{"$f":"J33*J98/100","v":0},10501.644114943523]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J147:J148)","v":0},{"$f":"SUM(K147:K148)","v":20306.336755716919}]
[]
[null,null,"Tier 3"]
[null,null,null,null,"Rate Class","Tier","Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C153,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C151","v":"Tier 3"},{"$f":"C153","v":"Existing Residential"},null,null,{"$f":"J38*J103/100","v":0},{"$f":"K38*K103/100","v":0}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C154,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C151","v":"Tier 3"},{"$f":"C154","v":"New Residential"},null,null,{"$f":"J39*J104/100","v":0},0]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C155,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C151","v":"Tier 3"},"Small Commercial",null,null,{"$f":"J40*J105/100","v":80.185096571549551},1547.2841345509325]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C156,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C151","v":"Tier 3"},"Small Agricultural",null,null,{"$f":"J41*J106/100","v":0},0]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J153:J156)","v":80.185096571549551},{"$f":"SUM(K153:K156)","v":1547.2841345509325}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C159,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C151","v":"Tier 3"},{"$f":"C159","v":"Medium Commercial"},null,null,{"$f":"J44*J109/100","v":0},{"$f":"K44*K109/100","v":0}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C160,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C151","v":"Tier 3"},"Large Commercial",null,null,{"$f":"J45*J110/100","v":0},3960.0678560892115]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J159:J160)","v":0},{"$f":"SUM(K159:K160)","v":3960.0678560892115}]
[]
[null,null,"Upstream Recover Charge"]
[null,null,null,null,"Rate Class",null,"Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C165,Input!$C$25:$C$30,0))","v":"Rate 1"},null,{"$f":"C165","v":"Existing Residential"},null,null,{"$f":"J50*J115/100","v":0},{"$f":"K50*K115/100","v":0}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C166,Input!$C$25:$C$30,0))","v":"Rate 1"},null,{"$f":"C166","v":"New Residential"},null,null,{"$f":"J51*J116/100","v":0},0]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C167,Input!$C$25:$C$30,0))","v":"Rate 1"},null,"Small Commercial",null,null,{"$f":"J52*J117/100","v":0},0]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C168,Input!$C$25:$C$30,0))","v":"Rate 1"},null,"Small Agricultural",null,null,{"$f":"J53*J118/100","v":0},0]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J165:J168)","v":0},{"$f":"SUM(K165:K168)","v":0}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C171,Input!$C$25:$C$30,0))","v":"Rate 6"},null,{"$f":"C171","v":"Medium Commercial"},null,null,{"$f":"J56*J121/100","v":0},{"$f":"K56*K121/100","v":0}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C172,Input!$C$25:$C$30,0))","v":"Rate 6"},null,"Large Commercial",null,null,{"$f":"J57*J122/100","v":0},0]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J171:J172)","v":0},{"$f":"SUM(K171:K172)","v":0}]
[]
[null,null,"Delay Rate Rider"]
[null,null,null,null,"Rate Class",null,"Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C177,Input!$C$25:$C$30,0))","v":"Rate 1"},null,{"$f":"C177","v":"Existing Residential"},null,null,{"$f":"J62*J115/100","v":2828.6669384059205},{"$f":"K62*K115/100","v":32562.183204753204}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C178,Input!$C$25:$C$30,0))","v":"Rate 1"},null,{"$f":"C178","v":"New Residential"},null,null,{"$f":"J63*J116/100","v":215.77043619979943},2483.8401362540135]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C179,Input!$C$25:$C$30,0))","v":"Rate 1"},null,"Small Commercial",null,null,{"$f":"J64*J117/100","v":38.318345000000001},728.04855500000008]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C180,Input!$C$25:$C$30,0))","v":"Rate 1"},null,"Small Agricultural",null,null,{"$f":"J65*J118/100","v":0},0]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J177:J180)","v":3082.7557196057201},{"$f":"SUM(K177:K180)","v":35774.071896007219}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C183,Input!$C$25:$C$30,0))","v":"Rate 6"},null,{"$f":"C183","v":"Medium Commercial"},null,null,{"$f":"J68*J121/100","v":0},{"$f":"K68*K121/100","v":612.05242499999997}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C184,Input!$C$25:$C$30,0))","v":"Rate 6"},null,"Large Commercial",null,null,{"$f":"J69*J122/100","v":0},687.97665000000006]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J183:J184)","v":0},{"$f":"SUM(K183:K184)","v":1300.0290749999999}]
[]
[null,null,"Total Revenue"]
[null,null,null,null,"Rate Class",null,"Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C189,Input!$C$25:$C$30,0))","v":"Rate 1"},null,{"$f":"C189","v":"Existing Residential"},null,null,{"$f":"J129+J141+J153+J165+J177","v":49442.984324855439},{"$f":"K129+K141+K153+K165+K177","v":577533.50415306236}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C190,Input!$C$25:$C$30,0))","v":"Rate 1"},null,{"$f":"C190","v":"New Residential"},null,null,{"$f":"J130+J142+J154+J166+J178","v":3772.83101141202},44069.690652528036]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C191,Input!$C$25:$C$30,0))","v":"Rate 1"},null,"Small Commercial",null,null,{"$f":"J131+J143+J155+J167+J179","v":664.68755021726577},12814.716208444521]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C192,Input!$C$25:$C$30,0))","v":"Rate 1"},null,"Small Agricultural",null,null,{"$f":"J132+J144+J156+J168+J180","v":0},0]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J189:J192)","v":53880.502886484719},{"$f":"SUM(K189:K192)","v":634417.91101403499}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C195,Input!$C$25:$C$30,0))","v":"Rate 6"},null,{"$f":"C195","v":"Medium Commercial"},null,null,{"$f":"J135+J147+J159+J171+J183","v":0},{"$f":"K135+K147+K159+K171+K183","v":16679.708539485364}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C196,Input!$C$25:$C$30,0))","v":"Rate 6"},null,"Large Commercial",null,null,{"$f":"J136+J148+J160+J172+J184","v":0},18134.882602115031]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J195:J196)","v":0},{"$f":"SUM(K195:K196)","v":34814.591141600395}]
[]
[]
[null,null,"Actual / Forecast"]
[]
[null,null,"Volume by Customer Type by Tiers"]
[]
[null,null,"Tier 1"]
[null,null,null,null,"Rate Class","Tier","Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C206,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C204","v":"Tier 1"},{"$f":"C206","v":"Existing Residential"},null,null,{"$f":"SUMIFS(VolumeData!T$33:T$54,VolumeData!$C$33:$C$54,$E206,VolumeData!$D$33:$D$54,$F206,VolumeData!$G$33:$G$54,$G206)","v":2517.1761915773791},{"$f":"SUMIFS(VolumeData!U$33:U$54,VolumeData!$C$33:$C$54,$E206,VolumeData!$D$33:$D$54,$F206,VolumeData!$G$33:$G$54,$G206)","v":506667.84880906501}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C207,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C204","v":"Tier 1"},{"$f":"C207","v":"New Residential"},null,null,{"$f":"SUMIFS(VolumeData!T$33:T$54,VolumeData!$C$33:$C$54,$E207,VolumeData!$D$33:$D$54,$F207,VolumeData!$G$33:$G$54,$G207)","v":199.72380842262118},{"$f":"SUMIFS(VolumeData!U$33:U$54,VolumeData!$C$33:$C$54,$E207,VolumeData!$D$33:$D$54,$F207,VolumeData!$G$33:$G$54,$G207)","v":40201.251190935}]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C208,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C204","v":"Tier 1"},"Small Commercial",null,null,{"$f":"SUMIFS(VolumeData!T$33:T$54,VolumeData!$C$33:$C$54,$E208,VolumeData!$D$33:$D$54,$F208,VolumeData!$G$33:$G$54,$G208)","v":0},{"$f":"SUMIFS(VolumeData!U$33:U$54,VolumeData!$C$33:$C$54,$E208,VolumeData!$D$33:$D$54,$F208,VolumeData!$G$33:$G$54,$G208)","v":9031.7999999999993}]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C209,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C204","v":"Tier 1"},"Small Agricultural",null,null,{"$f":"SUMIFS(VolumeData!T$33:T$54,VolumeData!$C$33:$C$54,$E209,VolumeData!$D$33:$D$54,$F209,VolumeData!$G$33:$G$54,$G209)","v":0},{"$f":"SUMIFS(VolumeData!U$33:U$54,VolumeData!$C$33:$C$54,$E209,VolumeData!$D$33:$D$54,$F209,VolumeData!$G$33:$G$54,$G209)","v":0}]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J206:J209)","v":2716.9},{"$f":"SUM(K206:K209)","v":555900.9}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C212,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C204","v":"Tier 1"},{"$f":"C212","v":"Medium Commercial"},null,null,{"$f":"SUMIFS(VolumeData!T$33:T$54,VolumeData!$C$33:$C$54,$E212,VolumeData!$D$33:$D$54,$F212,VolumeData!$G$33:$G$54,$G212)","v":0},{"$f":"SUMIFS(VolumeData!U$33:U$54,VolumeData!$C$33:$C$54,$E212,VolumeData!$D$33:$D$54,$F212,VolumeData!$G$33:$G$54,$G212)","v":5510}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C213,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C204","v":"Tier 1"},"Large Commercial",null,null,{"$f":"SUMIFS(VolumeData!T$33:T$54,VolumeData!$C$33:$C$54,$E213,VolumeData!$D$33:$D$54,$F213,VolumeData!$G$33:$G$54,$G213)","v":0},{"$f":"SUMIFS(VolumeData!U$33:U$54,VolumeData!$C$33:$C$54,$E213,VolumeData!$D$33:$D$54,$F213,VolumeData!$G$33:$G$54,$G213)","v":10000}]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J212:J213)","v":0},{"$f":"SUM(K212:K213)","v":15510}]
[]
[null,null,"Tier 2"]
[null,null,null,null,"Rate Class","Tier","Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C218,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C216","v":"Tier 2"},{"$f":"C218","v":"Existing Residential"},null,null,{"$f":"SUMIFS(VolumeData!T$33:T$54,VolumeData!$C$33:$C$54,$E218,VolumeData!$D$33:$D$54,$F218,VolumeData!$G$33:$G$54,$G218)","v":332.71043639436567},{"$f":"SUMIFS(VolumeData!U$33:U$54,VolumeData!$C$33:$C$54,$E218,VolumeData!$D$33:$D$54,$F218,VolumeData!$G$33:$G$54,$G218)","v":258366.79235974807}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C219,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C216","v":"Tier 2"},{"$f":"C219","v":"New Residential"},null,null,{"$f":"SUMIFS(VolumeData!T$33:T$54,VolumeData!$C$33:$C$54,$E219,VolumeData!$D$33:$D$54,$F219,VolumeData!$G$33:$G$54,$G219)","v":24.489563605634348},{"$f":"SUMIFS(VolumeData!U$33:U$54,VolumeData!$C$33:$C$54,$E219,VolumeData!$D$33:$D$54,$F219,VolumeData!$G$33:$G$54,$G219)","v":19017.407640251964}]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C220,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C216","v":"Tier 2"},"Small Commercial",null,null,{"$f":"SUMIFS(VolumeData!T$33:T$54,VolumeData!$C$33:$C$54,$E220,VolumeData!$D$33:$D$54,$F220,VolumeData!$G$33:$G$54,$G220)","v":0},{"$f":"SUMIFS(VolumeData!U$33:U$54,VolumeData!$C$33:$C$54,$E220,VolumeData!$D$33:$D$54,$F220,VolumeData!$G$33:$G$54,$G220)","v":13582.2}]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C221,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C216","v":"Tier 2"},"Small Agricultural",null,null,{"$f":"SUMIFS(VolumeData!T$33:T$54,VolumeData!$C$33:$C$54,$E221,VolumeData!$D$33:$D$54,$F221,VolumeData!$G$33:$G$54,$G221)","v":0},{"$f":"SUMIFS(VolumeData!U$33:U$54,VolumeData!$C$33:$C$54,$E221,VolumeData!$D$33:$D$54,$F221,VolumeData!$G$33:$G$54,$G221)","v":0}]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J218:J221)","v":357.20000000000005},{"$f":"SUM(K218:K221)","v":290966.40000000002}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C224,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C216","v":"Tier 2"},{"$f":"C224","v":"Medium Commercial"},null,null,{"$f":"SUMIFS(VolumeData!T$33:T$54,VolumeData!$C$33:$C$54,$E224,VolumeData!$D$33:$D$54,$F224,VolumeData!$G$33:$G$54,$G224)","v":0},{"$f":"SUMIFS(VolumeData!U$33:U$54,VolumeData!$C$33:$C$54,$E224,VolumeData!$D$33:$D$54,$F224,VolumeData!$G$33:$G$54,$G224)","v":2689}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C225,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C216","v":"Tier 2"},"Large Commercial",null,null,{"$f":"SUMIFS(VolumeData!T$33:T$54,VolumeData!$C$33:$C$54,$E225,VolumeData!$D$33:$D$54,$F225,VolumeData!$G$33:$G$54,$G225)","v":0},{"$f":"SUMIFS(VolumeData!U$33:U$54,VolumeData!$C$33:$C$54,$E225,VolumeData!$D$33:$D$54,$F225,VolumeData!$G$33:$G$54,$G225)","v":56088.7}]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J224:J225)","v":0},{"$f":"SUM(K224:K225)","v":58777.7}]
[]
[null,null,"Tier 3"]
[null,null,null,null,"Rate Class","Tier","Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C230,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C228","v":"Tier 3"},{"$f":"C230","v":"Existing Residential"},null,null,{"$f":"SUMIFS(VolumeData!T$33:T$54,VolumeData!$C$33:$C$54,$E230,VolumeData!$D$33:$D$54,$F230,VolumeData!$G$33:$G$54,$G230)","v":0},{"$f":"SUMIFS(VolumeData!U$33:U$54,VolumeData!$C$33:$C$54,$E230,VolumeData!$D$33:$D$54,$F230,VolumeData!$G$33:$G$54,$G230)","v":11156.587384054061}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C231,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C228","v":"Tier 3"},{"$f":"C231","v":"New Residential"},null,null,{"$f":"SUMIFS(VolumeData!T$33:T$54,VolumeData!$C$33:$C$54,$E231,VolumeData!$D$33:$D$54,$F231,VolumeData!$G$33:$G$54,$G231)","v":0},{"$f":"SUMIFS(VolumeData!U$33:U$54,VolumeData!$C$33:$C$54,$E231,VolumeData!$D$33:$D$54,$F231,VolumeData!$G$33:$G$54,$G231)","v":885.21261594593852}]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C232,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C228","v":"Tier 3"},"Small Commercial",null,null,{"$f":"SUMIFS(VolumeData!T$33:T$54,VolumeData!$C$33:$C$54,$E232,VolumeData!$D$33:$D$54,$F232,VolumeData!$G$33:$G$54,$G232)","v":0},{"$f":"SUMIFS(VolumeData!U$33:U$54,VolumeData!$C$33:$C$54,$E232,VolumeData!$D$33:$D$54,$F232,VolumeData!$G$33:$G$54,$G232)","v":8653.7999999999993}]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C233,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C228","v":"Tier 3"},"Small Agricultural",null,null,{"$f":"SUMIFS(VolumeData!T$33:T$54,VolumeData!$C$33:$C$54,$E233,VolumeData!$D$33:$D$54,$F233,VolumeData!$G$33:$G$54,$G233)","v":0},{"$f":"SUMIFS(VolumeData!U$33:U$54,VolumeData!$C$33:$C$54,$E233,VolumeData!$D$33:$D$54,$F233,VolumeData!$G$33:$G$54,$G233)","v":0}]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J230:J233)","v":0},{"$f":"SUM(K230:K233)","v":20695.599999999999}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C236,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C228","v":"Tier 3"},{"$f":"C236","v":"Medium Commercial"},null,null,{"$f":"SUMIFS(VolumeData!T$33:T$54,VolumeData!$C$33:$C$54,$E236,VolumeData!$D$33:$D$54,$F236,VolumeData!$G$33:$G$54,$G236)","v":0},{"$f":"SUMIFS(VolumeData!U$33:U$54,VolumeData!$C$33:$C$54,$E236,VolumeData!$D$33:$D$54,$F236,VolumeData!$G$33:$G$54,$G236)","v":0}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C237,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C228","v":"Tier 3"},"Large Commercial",null,null,{"$f":"SUMIFS(VolumeData!T$33:T$54,VolumeData!$C$33:$C$54,$E237,VolumeData!$D$33:$D$54,$F237,VolumeData!$G$33:$G$54,$G237)","v":0},{"$f":"SUMIFS(VolumeData!U$33:U$54,VolumeData!$C$33:$C$54,$E237,VolumeData!$D$33:$D$54,$F237,VolumeData!$G$33:$G$54,$G237)","v":44542}]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J236:J237)","v":0},{"$f":"SUM(K236:K237)","v":44542}]
[]
[null,null,"Total Volume"]
[null,null,null,null,"Rate Class",null,"Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C242,Input!$C$25:$C$30,0))","v":"Rate 1"},null,{"$f":"C242","v":"Existing Residential"},null,null,{"$f":"J206+J218+J230","v":2849.8866279717449},{"$f":"K206+K218+K230","v":776191.22855286719}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C243,Input!$C$25:$C$30,0))","v":"Rate 1"},null,{"$f":"C243","v":"New Residential"},null,null,{"$f":"J207+J219+J231","v":224.21337202825552},60103.8714471329]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C244,Input!$C$25:$C$30,0))","v":"Rate 1"},null,"Small Commercial",null,null,{"$f":"J208+J220+J232","v":0},31267.8]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C245,Input!$C$25:$C$30,0))","v":"Rate 1"},null,"Small Agricultural",null,null,{"$f":"J209+J221+J233","v":0},0]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J242:J245)","v":3074.1000000000004},{"$f":"SUM(K242:K245)","v":867562.90000000014}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C248,Input!$C$25:$C$30,0))","v":"Rate 6"},null,{"$f":"C248","v":"Medium Commercial"},null,null,{"$f":"J212+J224+J236","v":0},{"$f":"K212+K224+K236","v":8199}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C249,Input!$C$25:$C$30,0))","v":"Rate 6"},null,"Large Commercial",null,null,{"$f":"J213+J225+J237","v":0},110630.7]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J248:J249)","v":0},{"$f":"SUM(K248:K249)","v":118829.7}]
[]
[null,null,"Revenue by Customer Type by Tiers"]
[]
[null,null,"Tier 1"]
[null,null,null,null,"Rate Class","Tier","Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C256,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C254","v":"Tier 1"},{"$f":"C256","v":"Existing Residential"},null,null,{"$f":"J14*J206/100","v":684.5894110734871},{"$f":"K14*K206/100","v":139946.72651955183}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C257,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C254","v":"Tier 1"},{"$f":"C257","v":"New Residential"},null,null,{"$f":"J15*J207/100","v":54.318328944512857},11103.987591448156]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C258,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C254","v":"Tier 1"},"Small Commercial",null,null,{"$f":"J16*J208/100","v":0},2494.6734779999997]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C259,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C254","v":"Tier 1"},"Small Agricultural",null,null,{"$f":"J17*J209/100","v":0},0]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J256:J259)","v":738.90774001799991},{"$f":"SUM(K256:K259)","v":153545.38758899999}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C262,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C254","v":"Tier 1"},{"$f":"C262","v":"Medium Commercial"},null,null,{"$f":"J20*J212/100","v":0},{"$f":"K20*K212/100","v":1404.0086100000001}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C263,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C254","v":"Tier 1"},"Large Commercial",null,null,{"$f":"J21*J213/100","v":0},2548.11]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J262:J263)","v":0},{"$f":"SUM(K262:K263)","v":3952.1186100000004}]
[]
[null,null,"Tier 2"]
[null,null,null,null,"Rate Class","Tier","Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C268,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C266","v":"Tier 2"},{"$f":"C268","v":"Existing Residential"},null,null,{"$f":"J26*J218/100","v":88.703946082623645},{"$f":"K26*K218/100","v":69957.718000456618}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C269,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C266","v":"Tier 2"},{"$f":"C269","v":"New Residential"},null,null,{"$f":"J27*J219/100","v":6.5291637773763531},5149.324449343384]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C270,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C266","v":"Tier 2"},"Small Commercial",null,null,{"$f":"J28*J220/100","v":0},3677.6387118000002]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C271,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C266","v":"Tier 2"},"Small Agricultural",null,null,{"$f":"J29*J221/100","v":0},0]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J268:J271)","v":95.233109859999999},{"$f":"SUM(K268:K271)","v":78784.681161600005}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C274,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C266","v":"Tier 2"},{"$f":"C274","v":"Medium Commercial"},null,null,{"$f":"J32*J224/100","v":0},{"$f":"K32*K224/100","v":616.66836999999998}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C275,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C266","v":"Tier 2"},"Large Commercial",null,null,{"$f":"J33*J225/100","v":0},12862.821571]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J274:J275)","v":0},{"$f":"SUM(K274:K275)","v":13479.489941}]
[]
[null,null,"Tier 3"]
[null,null,null,null,"Rate Class","Tier","Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C280,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C278","v":"Tier 3"},{"$f":"C280","v":"Existing Residential"},null,null,{"$f":"J38*J230/100","v":0},{"$f":"K38*K230/100","v":2931.6276234952697}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C281,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C278","v":"Tier 3"},{"$f":"C281","v":"New Residential"},null,null,{"$f":"J39*J231/100","v":0},232.60820430473021]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C282,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C278","v":"Tier 3"},"Small Commercial",null,null,{"$f":"J40*J232/100","v":0},2273.9676797999996]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C283,Input!$C$25:$C$30,0))","v":"Rate 1"},{"$f":"C278","v":"Tier 3"},"Small Agricultural",null,null,{"$f":"J41*J233/100","v":0},0]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J280:J283)","v":0},{"$f":"SUM(K280:K283)","v":5438.2035075999993}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C286,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C278","v":"Tier 3"},{"$f":"C286","v":"Medium Commercial"},null,null,{"$f":"J44*J236/100","v":0},{"$f":"K44*K236/100","v":0}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C287,Input!$C$25:$C$30,0))","v":"Rate 6"},{"$f":"C278","v":"Tier 3"},"Large Commercial",null,null,{"$f":"J45*J237/100","v":0},9704.009204]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J286:J287)","v":0},{"$f":"SUM(K286:K287)","v":9704.009204}]
[]
[null,null,"Upstream Recover Charge"]
[null,null,null,null,"Rate Class",null,"Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C292,Input!$C$25:$C$30,0))","v":"Rate 1"},null,{"$f":"C292","v":"Existing Residential"},null,null,{"$f":"J50*J242/100","v":0},{"$f":"K50*K242/100","v":0}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C293,Input!$C$25:$C$30,0))","v":"Rate 1"},null,{"$f":"C293","v":"New Residential"},null,null,{"$f":"J51*J243/100","v":0},0]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C294,Input!$C$25:$C$30,0))","v":"Rate 1"},null,"Small Commercial",null,null,{"$f":"J52*J244/100","v":0},0]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C295,Input!$C$25:$C$30,0))","v":"Rate 1"},null,"Small Agricultural",null,null,{"$f":"J53*J245/100","v":0},0]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J292:J295)","v":0},{"$f":"SUM(K292:K295)","v":0}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C298,Input!$C$25:$C$30,0))","v":"Rate 6"},null,{"$f":"C298","v":"Medium Commercial"},null,null,{"$f":"J56*J248/100","v":0},{"$f":"K56*K248/100","v":0}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C299,Input!$C$25:$C$30,0))","v":"Rate 6"},null,"Large Commercial",null,null,{"$f":"J57*J249/100","v":0},0]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J298:J299)","v":0},{"$f":"SUM(K298:K299)","v":0}]
[]
[null,null,"Delay Rate Rider"]
[null,null,null,null,"Rate Class",null,"Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C304,Input!$C$25:$C$30,0))","v":"Rate 1"},null,{"$f":"C304","v":"Existing Residential"},null,null,{"$f":"J62*J242/100","v":46.538648634778589},{"$f":"K62*K242/100","v":12675.20276226832}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C305,Input!$C$25:$C$30,0))","v":"Rate 1"},null,{"$f":"C305","v":"New Residential"},null,null,{"$f":"J63*J243/100","v":3.6614043652214128},981.49622073168018]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C306,Input!$C$25:$C$30,0))","v":"Rate 1"},null,"Small Commercial",null,null,{"$f":"J64*J244/100","v":0},510.60317400000002]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C307,Input!$C$25:$C$30,0))","v":"Rate 1"},null,"Small Agricultural",null,null,{"$f":"J65*J245/100","v":0},0]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J304:J307)","v":50.200053000000004},{"$f":"SUM(K304:K307)","v":14167.302157}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C310,Input!$C$25:$C$30,0))","v":"Rate 6"},null,{"$f":"C310","v":"Medium Commercial"},null,null,{"$f":"J68*J248/100","v":0},{"$f":"K68*K248/100","v":74.52891000000001}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C311,Input!$C$25:$C$30,0))","v":"Rate 6"},null,"Large Commercial",null,null,{"$f":"J69*J249/100","v":0},1005.633063]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J310:J311)","v":0},{"$f":"SUM(K310:K311)","v":1080.161973}]
[]
[null,null,"Total Revenue"]
[null,null,null,null,"Rate Class",null,"Customer Type"]
[null,null,"Existing Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C316,Input!$C$25:$C$30,0))","v":"Rate 1"},null,{"$f":"C316","v":"Existing Residential"},null,null,{"$f":"J256+J268+J280+J292+J304","v":819.8320057908893},{"$f":"K256+K268+K280+K292+K304","v":225511.27490577204}]
[null,null,"New Residential","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C317,Input!$C$25:$C$30,0))","v":"Rate 1"},null,{"$f":"C317","v":"New Residential"},null,null,{"$f":"J257+J269+J281+J293+J305","v":64.508897087110626},17467.416465827951]
[null,null,"Small Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C318,Input!$C$25:$C$30,0))","v":"Rate 1"},null,"Small Commercial",null,null,{"$f":"J258+J270+J282+J294+J306","v":0},8956.8830435999989]
[null,null,"Small Agricultural","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C319,Input!$C$25:$C$30,0))","v":"Rate 1"},null,"Small Agricultural",null,null,{"$f":"J259+J271+J283+J295+J307","v":0},0]
[null,null,"Rate 1","m3",null,null,null,null,null,{"$f":"SUM(J316:J319)","v":884.34090287799995},{"$f":"SUM(K316:K319)","v":251935.57441519998}]
[]
[null,null,"Medium Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C322,Input!$C$25:$C$30,0))","v":"Rate 6"},null,{"$f":"C322","v":"Medium Commercial"},null,null,{"$f":"J262+J274+J286+J298+J310","v":0},{"$f":"K262+K274+K286+K298+K310","v":2095.2058900000002}]
[null,null,"Large Commercial","m3",{"$f":"INDEX(Input!$E$25:$E$30,MATCH($C323,Input!$C$25:$C$30,0))","v":"Rate 6"},null,"Large Commercial",null,null,{"$f":"J263+J275+J287+J299+J311","v":0},26120.573838000004]
[null,null,"Rate 6","m3",null,null,null,null,null,{"$f":"SUM(J322:J323)","v":0},{"$f":"SUM(K322:K323)","v":28215.779728000005}]

{"sheet":"Output","index":3,"n_rows":329,"n_cols":11,"rows_kept":329,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)","v":"Output"}]
[]
[null,null,"Master Check",{"$f":"Check!E18","v":3.8562575355172157E-10}]
[null,null,null,null,null,null,"Summary"]
[null,null,null,null,null,null,"($)"]
[]
[]
[null,null,null,null,null,null,null,"Col. 1","Col. 2","Col. 3","Col. 4"]
[null,null,null,null,null,null,null,null,"Actual","Actual","Actual"]
[null,null,null,null,null,null,"Forecasted Revenue","Total",{"$f":"Input!I$3","v":2019},{"$f":"Input!J$3","v":2020},{"$f":"Input!K$3","v":2021}]
[]
[null,null,null,null,null,"Row 1","CIP Common Assumptions",{"$f":"SUM(I12:K12)","v":723113.00504211988},{"$f":"I283+I291","v":0},53880.502886484726,669232.50215563516]
[null,null,null,null,null,"Row 2","Actual / Forecast",{"$f":"SUM(I13:K13)","v":281035.69504607795},{"$f":"I309+I317","v":0},884.34090287799995,280151.35414319998]
[null,null,null,null,null,"Row 3","Difference (negative = shortfall)",{"$f":"SUM(I14:K14)","v":-442077.30999604193},{"$f":"I13-I12","v":0},-52996.161983606726,-389081.14801243518]
[]
[]
[]
[null,null,null,null,null,null,"Projected Cumulative Deferral Account"]
[null,null,null,null,null,null,"($)"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"H$8","v":"Col. 1"},{"$f":"I$8","v":"Col. 2"},"Col. 3","Col. 4"]
[null,null,null,null,null,null,null,null,"Actual","Actual","Actual"]
[null,null,null,null,null,null,"Description","Total",{"$f":"Input!I$3","v":2019},{"$f":"Input!J$3","v":2020},{"$f":"Input!K$3","v":2021}]
[]
[null,null,null,null,null,"Row 1","Opening",null,0,{"$f":"I30","v":0},0]
[null,null,null,null,null,"Row 2","Addition",{"$f":"SUM(I27:K27)","v":442077.30999604193},{"$f":"-MIN(0,I14)","v":0},{"$f":"-MIN(0,J14)","v":52996.161983606726},389081.14801243518]
[null,null,null,null,null,"Row 3","Disposal",{"$f":"SUM(I28:K28)","v":-443550.53988151462},{"$f":"-SUM(I26:I27,I29)","v":0},{"$f":"-SUM(J26:J27,J29)","v":-53360.510597244021},{"$f":"-SUM(K26:K27,K29)","v":-390190.0292842706}]
[null,null,null,null,null,"Row 4","Carrying Cost",{"$f":"SUM(I29:K29)","v":1473.2298854727364},{"$f":"(I26+0.5*I27)*I32","v":0},364.34861363729618,1108.8812718354402]
[null,null,null,null,null,"Row 5","Closing",null,{"$f":"SUM(I26:I29)","v":0},{"$f":"SUM(J26:J29)","v":0},2.3646862246096134E-11]
[null,null,null,null,null,"Row 6"]
[null,null,null,null,null,"Row 7","OEB Prescribed Rate (Annual Average)",null,{"$f":"Input!I7","v":2.2474999999999998E-2},{"$f":"Input!J7","v":1.3749999999999998E-2},{"$f":"Input!K7","v":5.7000000000000002E-3}]
[]
[]
[]
[null,null,null,null,null,null,"Revenue with CIP Common Assumptions"]
[null,null,null,null,null,null,"($)"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"H$8","v":"Col. 1"},{"$f":"I$8","v":"Col. 2"},"Col. 3","Col. 4"]
[null,null,null,null,null,null,null,null,"Actual","Actual","Actual"]
[null,null,null,null,null,null,"Description","Total",{"$f":"Input!I$3","v":2019},{"$f":"Input!J$3","v":2020},{"$f":"Input!K$3","v":2021}]
[]
[null,null,null,null,null,null,{"$f":"VolumeData!G$26","v":"Existing Residential"},{"$f":"SUM(I44:K44)","v":626976.48847791785},{"$f":"Calculation!I189","v":0},{"$f":"Calculation!J189","v":49442.984324855439},{"$f":"Calculation!K189","v":577533.50415306236}]
[null,null,null,null,null,null,{"$f":"VolumeData!G$27","v":"New Residential"},{"$f":"SUM(I45:K45)","v":47842.521663940053},{"$f":"Calculation!I190","v":0},{"$f":"Calculation!J190","v":3772.83101141202},{"$f":"Calculation!K190","v":44069.690652528036}]
[null,null,null,null,null,null,{"$f":"VolumeData!G$28","v":"Small Commercial"},{"$f":"SUM(I46:K46)","v":13479.403758661787},{"$f":"Calculation!I191","v":0},{"$f":"Calculation!J191","v":664.68755021726577},{"$f":"Calculation!K191","v":12814.716208444521}]
[null,null,null,null,null,null,{"$f":"VolumeData!G$29","v":"Small Agricultural"},{"$f":"SUM(I47:K47)","v":0},{"$f":"Calculation!I192","v":0},{"$f":"Calculation!J192","v":0},{"$f":"Calculation!K192","v":0}]
[null,null,null,null,null,null,"Rate 1",{"$f":"SUM(I48:K48)","v":688298.41390051972},{"$f":"SUM(I44:I47)","v":0},53880.502886484719,634417.91101403499]
[]
[null,null,null,null,null,null,{"$f":"VolumeData!G$30","v":"Medium Commercial"},{"$f":"SUM(I50:K50)","v":16679.708539485364},{"$f":"Calculation!I195","v":0},{"$f":"Calculation!J195","v":0},{"$f":"Calculation!K195","v":16679.708539485364}]
[null,null,null,null,null,null,{"$f":"VolumeData!G$31","v":"Large Commercial"},{"$f":"SUM(I51:K51)","v":18134.882602115031},{"$f":"Calculation!I196","v":0},{"$f":"Calculation!J196","v":0},{"$f":"Calculation!K196","v":18134.882602115031}]
[null,null,null,null,null,null,"Rate 6",{"$f":"SUM(I52:K52)","v":34814.591141600395},{"$f":"SUM(I50:I51)","v":0},0,34814.591141600395]
[]
[null,null,null,null,null,null,"Rate 1 & Rate 6 Sum",{"$f":"SUM(I54:K54)","v":723113.00504212012},{"$f":"I48+I52","v":0},{"$f":"J48+J52","v":53880.502886484719},669232.50215563539]
[]
[]
[]
[null,null,null,null,null,null,"Revenue with Actual / Forecast"]
[null,null,null,null,null,null,"($)"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"H$8","v":"Col. 1"},{"$f":"I$8","v":"Col. 2"},"Col. 3","Col. 4"]
[null,null,null,null,null,null,null,null,"Actual","Actual","Actual"]
[null,null,null,null,null,null,"Description","Total",{"$f":"Input!I$3","v":2019},{"$f":"Input!J$3","v":2020},{"$f":"Input!K$3","v":2021}]
[]
[null,null,null,null,null,null,{"$f":"VolumeData!G$26","v":"Existing Residential"},{"$f":"SUM(I66:K66)","v":226331.10691156294},{"$f":"Calculation!I316","v":0},{"$f":"Calculation!J316","v":819.8320057908893},{"$f":"Calculation!K316","v":225511.27490577204}]
[null,null,null,null,null,null,{"$f":"VolumeData!G$27","v":"New Residential"},{"$f":"SUM(I67:K67)","v":17531.925362915063},{"$f":"Calculation!I317","v":0},{"$f":"Calculation!J317","v":64.508897087110626},{"$f":"Calculation!K317","v":17467.416465827951}]
[null,null,null,null,null,null,{"$f":"VolumeData!G$28","v":"Small Commercial"},{"$f":"SUM(I68:K68)","v":8956.8830435999989},{"$f":"Calculation!I318","v":0},{"$f":"Calculation!J318","v":0},{"$f":"Calculation!K318","v":8956.8830435999989}]
[null,null,null,null,null,null,{"$f":"VolumeData!G$29","v":"Small Agricultural"},{"$f":"SUM(I69:K69)","v":0},{"$f":"Calculation!I319","v":0},{"$f":"Calculation!J319","v":0},{"$f":"Calculation!K319","v":0}]
[null,null,null,null,null,null,"Rate 1",{"$f":"SUM(I70:K70)","v":252819.91531807798},{"$f":"SUM(I66:I69)","v":0},884.34090287799995,251935.57441519998]
[]
[null,null,null,null,null,null,{"$f":"VolumeData!G$30","v":"Medium Commercial"},{"$f":"SUM(I72:K72)","v":2095.2058900000002},{"$f":"Calculation!I322","v":0},{"$f":"Calculation!J322","v":0},{"$f":"Calculation!K322","v":2095.2058900000002}]
[null,null,null,null,null,null,{"$f":"VolumeData!G$31","v":"Large Commercial"},{"$f":"SUM(I73:K73)","v":26120.573838000004},{"$f":"Calculation!I323","v":0},{"$f":"Calculation!J323","v":0},{"$f":"Calculation!K323","v":26120.573838000004}]
[null,null,null,null,null,null,"Rate 6",{"$f":"SUM(I74:K74)","v":28215.779728000005},{"$f":"SUM(I72:I73)","v":0},0,28215.779728000005]
[]
[null,null,null,null,null,null,"Rate 1 & Rate 6 Sum",{"$f":"SUM(I76:K76)","v":281035.69504607795},{"$f":"I70+I74","v":0},{"$f":"J70+J74","v":884.34090287799995},280151.35414319998]
[]
[]
[]
[null,null,null,null,null,null,"Revenue Variance (Actual / Forecast less CIP)"]
[null,null,null,null,null,null,"($)"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"H$8","v":"Col. 1"},{"$f":"I$8","v":"Col. 2"},"Col. 3","Col. 4"]
[null,null,null,null,null,null,null,null,"Actual","Actual","Actual"]
[null,null,null,null,null,null,"Description","Total",{"$f":"Input!I$3","v":2019},{"$f":"Input!J$3","v":2020},{"$f":"Input!K$3","v":2021}]
[]
[null,null,null,null,null,null,{"$f":"VolumeData!G$26","v":"Existing Residential"},{"$f":"SUM(I88:K88)","v":-400645.38156635483},{"$f":"I66-I44","v":0},{"$f":"J66-J44","v":-48623.152319064553},-352022.22924729029]
[null,null,null,null,null,null,{"$f":"VolumeData!G$27","v":"New Residential"},{"$f":"SUM(I89:K89)","v":-30310.596301024994},{"$f":"I67-I45","v":0},-3708.3221143249093,-26602.274186700084]
[null,null,null,null,null,null,{"$f":"VolumeData!G$28","v":"Small Commercial"},{"$f":"SUM(I90:K90)","v":-4522.520715061788},{"$f":"I68-I46","v":0},-664.68755021726577,-3857.8331648445219]
[null,null,null,null,null,null,{"$f":"VolumeData!G$29","v":"Small Agricultural"},{"$f":"SUM(I91:K91)","v":0},{"$f":"I69-I47","v":0},0,0]
[null,null,null,null,null,null,"Rate 1",{"$f":"SUM(I92:K92)","v":-435478.49858244159},{"$f":"SUM(I88:I91)","v":0},-52996.161983606726,-382482.3365988349]
[]
[null,null,null,null,null,null,{"$f":"VolumeData!G$30","v":"Medium Commercial"},{"$f":"SUM(I94:K94)","v":-14584.502649485363},{"$f":"I72-I50","v":0},0,{"$f":"K72-K50","v":-14584.502649485363}]
[null,null,null,null,null,null,{"$f":"VolumeData!G$31","v":"Large Commercial"},{"$f":"SUM(I95:K95)","v":7985.6912358849731},{"$f":"I73-I51","v":0},0,7985.6912358849731]
[null,null,null,null,null,null,"Rate 6",{"$f":"SUM(I96:K96)","v":-6598.8114136003896},{"$f":"SUM(I94:I95)","v":0},0,-6598.8114136003896]
[]
[null,null,null,null,null,null,"Rate 1 & Rate 6 Sum",{"$f":"SUM(I98:K98)","v":-442077.30999604205},{"$f":"I92+I96","v":0},{"$f":"J92+J96","v":-52996.161983606726},-389081.1480124353]
[]
[]
[]
[null,null,null,null,null,null,"Actual / Forecasted Connection Count"]
[null,null,null,null,null,null,"(Average Annual)"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"H$8","v":"Col. 1"},{"$f":"I$8","v":"Col. 2"},"Col. 3","Col. 4"]
[null,null,null,null,null,null,null,null,"Actual","Actual","Actual"]
[null,null,null,null,null,null,"Description","Total",{"$f":"Input!I$3","v":2019},{"$f":"Input!J$3","v":2020},{"$f":"Input!K$3","v":2021}]
[]
[null,null,null,null,null,null,{"$f":"VolumeData!G$26","v":"Existing Residential"},null,0,{"$f":"VolumeData!H26","v":80.604486240653671},{"$f":"VolumeData!I26","v":927.87808011511083}]
[null,null,null,null,null,null,{"$f":"VolumeData!G$27","v":"New Residential"},null,0,{"$f":"VolumeData!H27","v":6.39551375934633},{"$f":"VolumeData!I27","v":73.621919884889081}]
[null,null,null,null,null,null,{"$f":"VolumeData!G$28","v":"Small Commercial"},null,0,{"$f":"VolumeData!H28","v":0.5},{"$f":"VolumeData!I28","v":9.5}]
[null,null,null,null,null,null,{"$f":"VolumeData!G$29","v":"Small Agricultural"},null,0,{"$f":"VolumeData!H29","v":0},{"$f":"VolumeData!I29","v":0}]
[null,null,null,null,null,null,"Rate 1",null,{"$f":"SUM(I110:I113)","v":0},{"$f":"SUM(J110:J113)","v":87.5},{"$f":"SUM(K110:K113)","v":1010.9999999999999}]
[]
[null,null,null,null,null,null,{"$f":"VolumeData!G$30","v":"Medium Commercial"},null,0,{"$f":"VolumeData!H30","v":0},{"$f":"VolumeData!I30","v":2.5}]
[null,null,null,null,null,null,{"$f":"VolumeData!G$31","v":"Large Commercial"},null,0,{"$f":"VolumeData!H31","v":0},{"$f":"VolumeData!I31","v":1}]
[null,null,null,null,null,null,"Rate 6",null,{"$f":"SUM(I116:I117)","v":0},{"$f":"SUM(J116:J117)","v":0},{"$f":"SUM(K116:K117)","v":3.5}]
[]
[]
[]
[null,null,null,null,null,null,"Volume per Customer with CIP Common Assumptions"]
[null,null,null,null,null,null,"(m3 / connection / year)"]
[]
[]
[null,null,null,null,null,null,null,"Col. 1"]
[]
[null,null,null,null,null,null,"Description"]
[]
[null,null,null,null,null,null,{"$f":"VolumeData!G$26","v":"Existing Residential"},2149]
[null,null,null,null,null,null,{"$f":"VolumeData!G$27","v":"New Residential"},2066]
[null,null,null,null,null,null,{"$f":"VolumeData!G$28","v":"Small Commercial"},4693]
[null,null,null,null,null,null,{"$f":"VolumeData!G$29","v":"Small Agricultural"},4720]
[]
[null,null,null,null,null,null,{"$f":"VolumeData!G$30","v":"Medium Commercial"},26933]
[null,null,null,null,null,null,{"$f":"VolumeData!G$31","v":"Large Commercial"},75685]
[]
[]
[]
[null,null,null,null,null,null,"Volume with CIP Common Assumptions"]
[null,null,null,null,null,null,"(m3)"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"H$8","v":"Col. 1"},{"$f":"I$8","v":"Col. 2"},"Col. 3","Col. 4"]
[null,null,null,null,null,null,null,null,"Actual","Actual","Actual"]
[null,null,null,null,null,null,"Description","Total",{"$f":"Input!I$3","v":2019},{"$f":"Input!J$3","v":2020},{"$f":"Input!K$3","v":2021}]
[]
[null,null,null,null,null,null,{"$f":"VolumeData!G$26","v":"Existing Residential"},{"$f":"SUM(I148:K148)","v":2167229.0350985378},{"$f":"I110*$H130","v":0},173219.04093116475,1994009.9941673733]
[null,null,null,null,null,null,{"$f":"VolumeData!G$27","v":"New Residential"},{"$f":"SUM(I149:K149)","v":165316.01790899038},{"$f":"I111*$H131","v":0},13213.131426809518,152102.88648218085]
[null,null,null,null,null,null,{"$f":"VolumeData!G$28","v":"Small Commercial"},{"$f":"SUM(I150:K150)","v":46930},{"$f":"I112*$H132","v":0},2346.5,44583.5]
[null,null,null,null,null,null,{"$f":"VolumeData!G$29","v":"Small Agricultural"},{"$f":"SUM(I151:K151)","v":0},{"$f":"I113*$H133","v":0},0,0]
[null,null,null,null,null,null,"Rate 1",{"$f":"SUM(I152:K152)","v":2379475.0530075282},{"$f":"SUM(I148:I151)","v":0},{"$f":"SUM(J148:J151)","v":188778.67235797428},{"$f":"SUM(K148:K151)","v":2190696.3806495541}]
[]
[null,null,null,null,null,null,{"$f":"VolumeData!G$30","v":"Medium Commercial"},{"$f":"SUM(I154:K154)","v":67332.5},{"$f":"I116*$H135","v":0},0,67332.5]
[null,null,null,null,null,null,{"$f":"VolumeData!G$31","v":"Large Commercial"},{"$f":"SUM(I155:K155)","v":75685},{"$f":"I117*$H136","v":0},0,75685]
[null,null,null,null,null,null,"Rate 6",{"$f":"SUM(I156:K156)","v":143017.5},{"$f":"SUM(I154:I155)","v":0},{"$f":"SUM(J154:J155)","v":0},{"$f":"SUM(K154:K155)","v":143017.5}]
[]
[]
[]
[null,null,null,null,null,null,"Volume with Actual / Forecast"]
[null,null,null,null,null,null,"(m3)"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"H$8","v":"Col. 1"},{"$f":"I$8","v":"Col. 2"},"Col. 3","Col. 4"]
[null,null,null,null,null,null,null,null,"Actual","Actual","Actual"]
[null,null,null,null,null,null,"Description","Total",{"$f":"Input!I$3","v":2019},{"$f":"Input!J$3","v":2020},{"$f":"Input!K$3","v":2021}]
[]
[null,null,null,null,null,null,{"$f":"VolumeData!G$26","v":"Existing Residential"},{"$f":"SUM(I168:K168)","v":779041.11518083897},0,{"$f":"VolumeData!T57","v":2849.8866279717449},{"$f":"VolumeData!U57","v":776191.22855286719}]
[null,null,null,null,null,null,{"$f":"VolumeData!G$27","v":"New Residential"},{"$f":"SUM(I169:K169)","v":60328.084819161159},0,{"$f":"VolumeData!T58","v":224.21337202825552},{"$f":"VolumeData!U58","v":60103.8714471329}]
[null,null,null,null,null,null,{"$f":"VolumeData!G$28","v":"Small Commercial"},{"$f":"SUM(I170:K170)","v":31267.8},0,{"$f":"VolumeData!T59","v":0},{"$f":"VolumeData!U59","v":31267.8}]
[null,null,null,null,null,null,{"$f":"VolumeData!G$29","v":"Small Agricultural"},{"$f":"SUM(I171:K171)","v":0},0,{"$f":"VolumeData!T60","v":0},{"$f":"VolumeData!U60","v":0}]
[null,null,null,null,null,null,"Rate 1",{"$f":"SUM(I172:K172)","v":870637.00000000012},{"$f":"SUM(I168:I171)","v":0},3074.1000000000004,{"$f":"SUM(K168:K171)","v":867562.90000000014}]
[]
[null,null,null,null,null,null,{"$f":"VolumeData!G$30","v":"Medium Commercial"},{"$f":"SUM(I174:K174)","v":8199},0,{"$f":"VolumeData!T61","v":0},{"$f":"VolumeData!U61","v":8199}]
[null,null,null,null,null,null,{"$f":"VolumeData!G$31","v":"Large Commercial"},{"$f":"SUM(I175:K175)","v":110630.7},0,{"$f":"VolumeData!T62","v":0},{"$f":"VolumeData!U62","v":110630.7}]
[null,null,null,null,null,null,"Rate 6",{"$f":"SUM(I176:K176)","v":118829.7},{"$f":"SUM(I174:I175)","v":0},0,{"$f":"SUM(K174:K175)","v":118829.7}]
[]
[]
[]
[null,null,null,null,null,null,"Volume Variance (Actual / Forecast less CIP)"]
[null,null,null,null,null,null,"(m3)"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"H$8","v":"Col. 1"},{"$f":"I$8","v":"Col. 2"},"Col. 3","Col. 4"]
[null,null,null,null,null,null,null,null,"Actual","Actual","Actual"]
[null,null,null,null,null,null,"Description","Total",{"$f":"Input!I$3","v":2019},{"$f":"Input!J$3","v":2020},{"$f":"Input!K$3","v":2021}]
[]
[null,null,null,null,null,null,{"$f":"VolumeData!G$26","v":"Existing Residential"},{"$f":"SUM(I188:K188)","v":-1388187.9199176992},{"$f":"I168-I148","v":0},{"$f":"J168-J148","v":-170369.15430319301},-1217818.7656145061]
[null,null,null,null,null,null,{"$f":"VolumeData!G$27","v":"New Residential"},{"$f":"SUM(I189:K189)","v":-104987.93308982921},{"$f":"I169-I149","v":0},-12988.918054781261,-91999.015035047953]
[null,null,null,null,null,null,{"$f":"VolumeData!G$28","v":"Small Commercial"},{"$f":"SUM(I190:K190)","v":-15662.2},{"$f":"I170-I150","v":0},-2346.5,-13315.7]
[null,null,null,null,null,null,{"$f":"VolumeData!G$29","v":"Small Agricultural"},{"$f":"SUM(I191:K191)","v":0},{"$f":"I171-I151","v":0},0,0]
[null,null,null,null,null,null,"Rate 1",{"$f":"SUM(I192:K192)","v":-1508838.0530075282},{"$f":"SUM(I188:I191)","v":0},-185704.57235797428,-1323133.4806495539]
[]
[null,null,null,null,null,null,{"$f":"VolumeData!G$30","v":"Medium Commercial"},{"$f":"SUM(I194:K194)","v":-59133.5},{"$f":"I174-I154","v":0},{"$f":"J174-J154","v":0},-59133.5]
[null,null,null,null,null,null,{"$f":"VolumeData!G$31","v":"Large Commercial"},{"$f":"SUM(I195:K195)","v":34945.699999999997},{"$f":"I175-I155","v":0},0,34945.699999999997]
[null,null,null,null,null,null,"Rate 6",{"$f":"SUM(I196:K196)","v":-24187.800000000003},{"$f":"SUM(I194:I195)","v":0},0,-24187.800000000003]
[]
[]
[]
[null,null,null,null,null,null,"Volume with CIP Common Assumptions by Tiers"]
[null,null,null,null,null,null,"(m3)"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"H$8","v":"Col. 1"},{"$f":"I$8","v":"Col. 2"},"Col. 3","Col. 4"]
[]
[null,null,null,null,null,null,"Description","Total",{"$f":"Input!I$3","v":2019},{"$f":"Input!J$3","v":2020},{"$f":"Input!K$3","v":2021}]
[]
[null,null,null,null,null,"Row 1","Rate 1 - General Firm Service"]
[null,null,null,null,null,"Row 2","Tier 1",{"$f":"SUM(I209:K209)","v":1101914.2332878578},{"$f":"Input!I40","v":0},{"$f":"Input!J40","v":87713.5820827649},{"$f":"Input!K40","v":1014200.651205093}]
[null,null,null,null,null,"Row 3","Tier 2",{"$f":"SUM(I210:K210)","v":1271362.5705154864},{"$f":"Input!I41","v":0},{"$f":"Input!J41","v":100755.17781500018},{"$f":"Input!K41","v":1170607.3927004864}]
[null,null,null,null,null,"Row 4","Tier 3",{"$f":"SUM(I211:K211)","v":6198.2492041837204},{"$f":"Input!I42","v":0},{"$f":"Input!J42","v":309.91246020918601},{"$f":"Input!K42","v":5888.3367439745343}]
[null,null,null,null,null,"Row 5","Sum",{"$f":"SUM(H209:H211)","v":2379475.0530075282},{"$f":"SUM(I209:I211)","v":0},188778.67235797425,2190696.3806495541]
[null,null,null,null,null,"Row 6"]
[null,null,null,null,null,"Row 7","Rate 6 - Large Volume General Firm Service"]
[null,null,null,null,null,"Row 8","Tier 1",{"$f":"SUM(I215:K215)","v":36294.184532042418},{"$f":"Input!I47","v":0},{"$f":"Input!J47","v":0},{"$f":"Input!K47","v":36294.184532042418}]
[null,null,null,null,null,"Row 9","Tier 2",{"$f":"SUM(I216:K216)","v":88546.360073766715},{"$f":"Input!I48","v":0},{"$f":"Input!J48","v":0},{"$f":"Input!K48","v":88546.360073766715}]
[null,null,null,null,null,"Row 10","Tier 3",{"$f":"SUM(I217:K217)","v":18176.955394190871},{"$f":"Input!I49","v":0},{"$f":"Input!J49","v":0},{"$f":"Input!K49","v":18176.955394190871}]
[null,null,null,null,null,"Row 11","Sum",{"$f":"SUM(H215:H217)","v":143017.5},{"$f":"SUM(I215:I217)","v":0},0,143017.5]
[]
[]
[]
[null,null,null,null,null,null,"Volume with Actual / Forecast by Tiers"]
[null,null,null,null,null,null,"(m3)"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"H$8","v":"Col. 1"},{"$f":"I$8","v":"Col. 2"},"Col. 3","Col. 4"]
[]
[null,null,null,null,null,null,"Description","Total",{"$f":"Input!I$3","v":2019},{"$f":"Input!J$3","v":2020},{"$f":"Input!K$3","v":2021}]
[]
[null,null,null,null,null,"Row 1","Rate 1 - General Firm Service"]
[null,null,null,null,null,"Row 2","Tier 1",{"$f":"SUM(I231:K231)","v":558617.80000000005},{"$f":"Input!I56","v":0},{"$f":"Input!J56","v":2716.9},{"$f":"Input!K56","v":555900.9}]
[null,null,null,null,null,"Row 3","Tier 2",{"$f":"SUM(I232:K232)","v":291323.60000000003},{"$f":"Input!I57","v":0},{"$f":"Input!J57","v":357.20000000000005},{"$f":"Input!K57","v":290966.40000000002}]
[null,null,null,null,null,"Row 4","Tier 3",{"$f":"SUM(I233:K233)","v":20695.599999999999},{"$f":"Input!I58","v":0},{"$f":"Input!J58","v":0},{"$f":"Input!K58","v":20695.599999999999}]
[null,null,null,null,null,"Row 5","Sum",{"$f":"SUM(H231:H233)","v":870637.00000000012},{"$f":"SUM(I231:I233)","v":0},3074.1000000000004,867562.9]
[null,null,null,null,null,"Row 6"]
[null,null,null,null,null,"Row 7","Rate 6 - Large Volume General Firm Service"]
[null,null,null,null,null,"Row 8","Tier 1",{"$f":"SUM(I237:K237)","v":15510},{"$f":"Input!I63","v":0},{"$f":"Input!J63","v":0},{"$f":"Input!K63","v":15510}]
[null,null,null,null,null,"Row 9","Tier 2",{"$f":"SUM(I238:K238)","v":58777.7},{"$f":"Input!I64","v":0},{"$f":"Input!J64","v":0},{"$f":"Input!K64","v":58777.7}]
[null,null,null,null,null,"Row 10","Tier 3",{"$f":"SUM(I239:K239)","v":44542},{"$f":"Input!I65","v":0},{"$f":"Input!J65","v":0},{"$f":"Input!K65","v":44542}]
[null,null,null,null,null,"Row 11","Sum",{"$f":"SUM(H237:H239)","v":118829.7},{"$f":"SUM(I237:I239)","v":0},{"$f":"SUM(J237:J239)","v":0},{"$f":"SUM(K237:K239)","v":118829.7}]
[]
[]
[]
[null,null,null,null,null,null,"Volumetric Revenue Rates"]
[null,null,null,null,null,null,"(cents / m3)"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"H$8","v":"Col. 1"},{"$f":"I$8","v":"Col. 2"},"Col. 3","Col. 4"]
[]
[null,null,null,null,null,null,"Description",null,{"$f":"Input!I$3","v":2019},{"$f":"Input!J$3","v":2020},{"$f":"Input!K$3","v":2021}]
[]
[null,null,null,null,null,"Row 1","Rate 1 - General Firm Service"]
[null,null,null,null,null,"Row 2","Tier 1",null,{"$f":"Input!I75","v":26.794799999999999},{"$f":"Input!J75","v":27.196721999999998},{"$f":"Input!K75","v":27.620999999999999}]
[null,null,null,null,null,"Row 3","Tier 2",null,{"$f":"Input!I76","v":26.266999999999999},{"$f":"Input!J76","v":26.661004999999996},{"$f":"Input!K76","v":27.076899999999998}]
[null,null,null,null,null,"Row 4","Tier 3",null,{"$f":"Input!I77","v":25.491099999999999},{"$f":"Input!J77","v":25.873466499999996},{"$f":"Input!K77","v":26.277100000000001}]
[null,null,null,null,null,"Row 5","Upstream Recovery"]
[null,null,null,null,null,"Row 6","Delay Rate Rider",null,{"$f":"Input!I79","v":1.633},{"$f":"Input!J79","v":1.633},{"$f":"Input!K79","v":1.633}]
[null,null,null,null,null,"Row 7"]
[null,null,null,null,null,"Row 8"]
[null,null,null,null,null,"Row 9","Rate 6 - Large Volume General Firm Service"]
[null,null,null,null,null,"Row 10","Tier 1",null,{"$f":"Input!I83","v":24.718900000000001},{"$f":"Input!J83","v":25.089700000000001},{"$f":"Input!K83","v":25.481100000000001}]
[null,null,null,null,null,"Row 11","Tier 2",null,{"$f":"Input!I84","v":22.247},{"$f":"Input!J84","v":22.5807},{"$f":"Input!K84","v":22.933}]
[null,null,null,null,null,"Row 12","Tier 3",null,{"$f":"Input!I85","v":21.134599999999999},{"$f":"Input!J85","v":21.451599999999999},{"$f":"Input!K85","v":21.786200000000001}]
[null,null,null,null,null,"Row 13","Upstream Recovery"]
[null,null,null,null,null,"Row 14","Delay Rate Rider",null,{"$f":"Input!I87","v":0.90900000000000003},{"$f":"Input!J87","v":0.90900000000000003},{"$f":"Input!K87","v":0.90900000000000003}]
[]
[]
[]
[null,null,null,null,null,null,"Volumetric Revenue with CIP Common Assumptions"]
[null,null,null,null,null,null,"($)"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"H$8","v":"Col. 1"},{"$f":"I$8","v":"Col. 2"},"Col. 3","Col. 4"]
[]
[null,null,null,null,null,null,"Description",null,{"$f":"Input!I$3","v":2019},{"$f":"Input!J$3","v":2020},{"$f":"Input!K$3","v":2021}]
[]
[null,null,null,null,null,"Row 1","Rate 1 - General Firm Service"]
[null,null,null,null,null,"Row 2","Tier 1",null,{"$f":"I209*I253/100","v":0},23855.219075291374,280132.36186935869]
[null,null,null,null,null,"Row 3","Tier 2",null,{"$f":"I210*I254/100","v":0},26862.342995016086,316964.19311411795]
[null,null,null,null,null,"Row 4","Tier 3",null,{"$f":"I211*I255/100","v":0},80.185096571549551,1547.2841345509325]
[null,null,null,null,null,"Row 5","Upstream Recovery",null,{"$f":"I212*I256/100","v":0},0,0]
[null,null,null,null,null,"Row 6","Delay Rate Rider",null,{"$f":"I212*I257/100","v":0},3082.7557196057196,35774.071896007219]
[null,null,null,null,null,"Row 7","Sum",null,{"$f":"SUM(I278:I282)","v":0},53880.502886484726,634417.91101403476]
[null,null,null,null,null,"Row 8"]
[null,null,null,null,null,"Row 9","Rate 6 - Large Volume General Firm Service"]
[null,null,null,null,null,"Row 10","Tier 1",null,{"$f":"I215*I261/100","v":0},0,9248.1574547942619]
[null,null,null,null,null,"Row 11","Tier 2",null,{"$f":"I216*I262/100","v":0},0,20306.336755716919]
[null,null,null,null,null,"Row 12","Tier 3",null,{"$f":"I217*I263/100","v":0},0,3960.0678560892115]
[null,null,null,null,null,"Row 13","Upstream Recovery",null,{"$f":"I218*I264/100","v":0},0,0]
[null,null,null,null,null,"Row 14","Delay Rate Rider",null,{"$f":"I218*I265/100","v":0},0,1300.0290749999999]
[null,null,null,null,null,"Row 15","Sum",null,{"$f":"SUM(I286:I290)","v":0},{"$f":"SUM(J286:J290)","v":0},{"$f":"SUM(K286:K290)","v":34814.591141600387}]
[]
[]
[]
[null,null,null,null,null,null,"Volumetric Revenue with Actual / Forecast"]
[null,null,null,null,null,null,"($)"]
[]
[]
[null,null,null,null,null,null,null,{"$f":"H$8","v":"Col. 1"},{"$f":"I$8","v":"Col. 2"},"Col. 3","Col. 4"]
[]
[null,null,null,null,null,null,"Description",null,{"$f":"Input!I$3","v":2019},{"$f":"Input!J$3","v":2020},{"$f":"Input!K$3","v":2021}]
[]
[null,null,null,null,null,"Row 1","Rate 1 - General Firm Service"]
[null,null,null,null,null,"Row 2","Tier 1",null,{"$f":"I231*I253/100","v":0},738.90774001799991,153545.38758899999]
[null,null,null,null,null,"Row 3","Tier 2",null,{"$f":"I232*I254/100","v":0},95.233109859999999,78784.68116159999]
[null,null,null,null,null,"Row 4","Tier 3",null,{"$f":"I233*I255/100","v":0},0,5438.2035075999993]
[null,null,null,null,null,"Row 5","Upstream Recovery",null,{"$f":"I$234*I256/100","v":0},0,0]
[null,null,null,null,null,"Row 6","Delay Rate Rider",null,{"$f":"I$234*I257/100","v":0},50.200053000000004,14167.302157]
[null,null,null,null,null,"Row 7","Sum",null,{"$f":"SUM(I304:I308)","v":0},884.34090287799995,251935.57441519998]
[null,null,null,null,null,"Row 8"]
[null,null,null,null,null,"Row 9","Rate 6 - Large Volume General Firm Service"]
[null,null,null,null,null,"Row 10","Tier 1",null,{"$f":"I237*I261/100","v":0},0,3952.1186100000004]
[null,null,null,null,null,"Row 11","Tier 2",null,{"$f":"I238*I262/100","v":0},0,13479.489941]
[null,null,null,null,null,"Row 12","Tier 3",null,{"$f":"I239*I263/100","v":0},0,9704.009204]
[null,null,null,null,null,"Row 13","Upstream Recovery",null,{"$f":"I$240*I264/100","v":0},0,0]
[null,null,null,null,null,"Row 14","Delay Rate Rider",null,{"$f":"I$240*I265/100","v":0},0,1080.161973]
[null,null,null,null,null,"Row 15","Sum",null,{"$f":"SUM(I312:I316)","v":0},0,28215.779727999998]
[]
[]
[]
[]
[null,null,null,null,null,null,"Check",null,{"$f":"SUMPRODUCT(Input!I40:I44,Input!I75:I79)/100-I283","v":0},{"$f":"SUMPRODUCT(Input!J40:J44,Input!J75:J79)/100-J283","v":0},{"$f":"SUMPRODUCT(Input!K40:K44,Input!K75:K79)/100-K283","v":0}]
[null,null,null,null,null,null,"Check",null,{"$f":"SUMPRODUCT(Input!I47:I51,Input!I83:I87)/100-I291","v":0},{"$f":"SUMPRODUCT(Input!J47:J51,Input!J83:J87)/100-J291","v":0},{"$f":"SUMPRODUCT(Input!K47:K51,Input!K83:K87)/100-K291","v":0}]
[null,null,null,null,null,null,"Check",null,{"$f":"SUMPRODUCT(Input!I56:I60,Input!I75:I79)/100-I309","v":0},{"$f":"SUMPRODUCT(Input!J56:J60,Input!J75:J79)/100-J309","v":0},{"$f":"SUMPRODUCT(Input!K56:K60,Input!K75:K79)/100-K309","v":0}]
[null,null,null,null,null,null,"Check",null,{"$f":"SUMPRODUCT(Input!I63:I67,Input!I83:I87)/100-I317","v":0},{"$f":"SUMPRODUCT(Input!J63:J67,Input!J83:J87)/100-J317","v":0},{"$f":"SUMPRODUCT(Input!K63:K67,Input!K83:K87)/100-K317","v":0}]
[null,null,null,null,null,null,"Check",null,{"$f":"ABS(SUM(I234,I240)-SUM(I172,I176))","v":0},0,1.1641532182693481E-10]
[null,null,null,null,null,null,"Check",null,{"$f":"ABS(SUM(I48,I52)-SUM(I283,I291))","v":0},{"$f":"ABS(SUM(J48,J52)-SUM(J283,J291))","v":7.2759576141834259E-12},2.3283064365386963E-10]
[null,null,null,null,null,null,"Check",null,{"$f":"ABS(SUM(I70,I74)-SUM(I309,I317))","v":0},{"$f":"ABS(SUM(J70,J74)-SUM(J309,J317))","v":0},0]
[null,null,null,null,null,null,"Check",null,{"$f":"ABS(SUM(I152,I156)-SUM(I212,I218))","v":0},2.9103830456733704E-11,0]

{"sheet":"Check","index":4,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[{"$f":"MID(CELL(\"filename\",A1),FIND(\"]\",CELL(\"filename\",A1))+1,256)","v":"Check"}]
[]
[null,null,"Description","Tab","Value"]
[null,null,"Revenues",null,{"$f":"SUM(Output!I322:K325)","v":0}]
[null,null,"Volumes",null,{"$f":"SUM(Output!I322:K329)","v":3.8562575355172157E-10}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sum",null,{"$f":"SUM(E4:E17)","v":3.8562575355172157E-10}]