{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Inputs","Demand and Allocations data","Total Tariffs","MDBA & BCR Tariffs","SW Costs Tariffs","Border","Gwydir","Namoi","Peel","Lachlan","Macquarie","Murray","Murrumbidgee","Lowbidgee","Fish River"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"Inputs","index":0,"n_rows":155,"n_cols":11,"rows_kept":155,"cut":false,"hidden":false,"merged":[]}
[]
["Base year prices per tariff component for 2013-14 ($ Nominal)",null,null,null,null,null,"Calculated tariffs which exclude MDBA / BCR cost recovery for 2013-14 ($ Nominal) "]
[null,"High Security Entitlement ($/ML)","General Security Entitlement ($/ML)","Usage ($/ML delivered)",null,null,"High Security Entitlement ($/ML)","General Security Entitlement ($/ML)","Usage ($/ML delivered)"]
[null,"2013-14","2013-14","2013-14",null,null,"2013-14","2013-14","2013-14"]
["Border ",11.45,3.21,9.43,null,null,{"$f":"B5*(1-$B$155)","v":7.3779117753689203},{"$f":"C5*(1-$B$155)","v":2.0683927335313741},{"$f":"D5*(1-$B$155)","v":6.0763063791902985}]
["Gwydir ",14.55,4.0599999999999996,12.97,null,null,{"$f":"B6*(1-$C$155)","v":14.389781637543789},{"$f":"C6*(1-$C$155)","v":4.0152930205105006},{"$f":"D6*(1-$C$155)","v":12.827179920202266}]
["Namoi ",16.22,9.09,19.98,null,null,{"$f":"B7*(1-$D$155)","v":16.019857330139448},{"$f":"C7*(1-$D$155)","v":8.9778361979634766},{"$f":"D7*(1-$D$155)","v":19.733461742058335}]
["Peel",25.19,2.77,41.61,null,null,{"$f":"B8*(1-$E$155)","v":25.076315111646519},{"$f":"C8*(1-$E$155)","v":2.7574987240675211},{"$f":"D8*(1-$E$155)","v":41.422210075252544}]
["Lachlan",12.36,4.42,18.04,null,null,{"$f":"B9*(1-$F$155)","v":12.36},{"$f":"C9*(1-$F$155)","v":4.42},{"$f":"D9*(1-$F$155)","v":18.04}]
["Macquarie",11.42,4.24,13.98,null,null,{"$f":"B10*(1-$G$155)","v":11.35284249530522},{"$f":"C10*(1-$G$155)","v":4.2150658651571051},{"$f":"D10*(1-$G$155)","v":13.897787923324605}]
["Murray ",3.14,2.33,4.97,null,null,{"$f":"B11*(1-$H$155)","v":1.7017878516072777},{"$f":"C11*(1-$H$155)","v":1.2627916223710054},{"$f":"D11*(1-$H$155)","v":2.6935941472892257}]
["Murrumbidgee",2.98,1.59,3.78,null,null,{"$f":"B12*(1-$I$155)","v":2.6360825366697194},{"$f":"C12*(1-$I$155)","v":1.4065004138606891},{"$f":"D12*(1-$I$155)","v":3.3437557008763554}]
["Lowbidgee"]
[]
["Fish River","2013-14","2013-14","2013-14",null,null,"2013-14","2013-14","2013-14"]
[null,"Access ","Usage < MAQ","Usage > MAQ",null,null,"Access ","Usage < MAQ","Usage > MAQ"]
["Raw water - major customers",0.38,0.43,0.81,null,null,{"$f":"B17","v":0.38},{"$f":"C17","v":0.43},{"$f":"D17","v":0.81}]
["Raw water - minor customers",0.47,0.85,1.33,null,null,{"$f":"B18","v":0.47},0.85,1.33]
["Filtered water - major customers",0.56999999999999995,0.61,1.18,null,null,0.56999999999999995,0.61,1.18]
["Filtered water - minor customers",0.67331362349999979,1.04,1.71,null,null,0.67331362349999979,1.04,1.71]
[]
["High security premium (times)","Water sharing plan ratio (WSP)","Average Water Allocation","High security premium (times)"]
[null,"2014-17","2014-15","2014-15"]
["Border ",1.28,{"$f":"'Demand and Allocations data'!M$41","v":2.3184996774455522},{"$f":"B24*C24","v":2.967679587130307}]
["Gwydir ",1.81,{"$f":"'Demand and Allocations data'!O$41","v":2.2466505886379928},{"$f":"B25*C25","v":4.0664375654347671}]
["Namoi ",1.25,{"$f":"'Demand and Allocations data'!Q$41","v":1.7205369620356692},2.1506712025445864]
["Peel",6.73,{"$f":"'Demand and Allocations data'!S$41","v":1.467351430667645},9.8752751283932518]
["Lachlan",2.4500000000000002,{"$f":"'Demand and Allocations data'!U$41","v":1.64506480558325},4.0304087736789631]
["Macquarie",1.88,{"$f":"'Demand and Allocations data'!W$41","v":1.9607843137254897},3.6862745098039205]
["Murray ",1.25,{"$f":"'Demand and Allocations data'!Y$41","v":1.411111111111111},1.7638888888888888]
["Murrumbidgee",1.63,{"$f":"'Demand and Allocations data'!AA$41","v":1.4125433526011555},2.3024456647398832]
["Lowbidgee",0,0,0]
[]
[]
["Tariff Structure 2014-17","2014-15","2015-16","2016-17"]
["Target Variable / Fixed ratio (%)",0.6,{"$f":"B36","v":0.6},{"$f":"C36","v":0.6}]
[]
["Fish River"]
["Raw Water /Filtered Water (%)",0.8,{"$f":"B39","v":0.8},{"$f":"C39","v":0.8}]
["Target Variable / Fixed ratio (%)"]
["Raw Water",0.45,{"$f":"B41","v":0.45},{"$f":"C41","v":0.45}]
["Filtered Water",0.4,{"$f":"B42","v":0.4},{"$f":"C42","v":0.4}]
[]
["Peel Valley Annual real price increase cap",0.1,0.1,0.1]
["Forecast water entitlements and usage "]
[null,"High Security Entitlement (ML)","General Security Entitlement (ML)","Forecast water volumes (ML)",null,null,"Total Entitlements","% High security","% General security"]
[null,"2014-15","2014-15","2014-15",null,null,"2014-15","2014-15","2014-15"]
["Border ",3122,263238,{"$f":"'Demand and Allocations data'!C$35","v":140676.93950000001},null,null,{"$f":"SUM(B48:C48)","v":266360},{"$f":"B48/G48","v":1.1720979125994894E-2},{"$f":"C48/G48","v":0.9882790208740051}]
["Gwydir ",21457.9,509665,{"$f":"'Demand and Allocations data'!D$35","v":245876.74050000001},null,null,{"$f":"SUM(B49:C49)","v":531122.9},{"$f":"B49/G49","v":4.0401006998568509E-2},{"$f":"C49/G49","v":0.95959899300143148}]
["Namoi ",8881,256076,{"$f":"'Demand and Allocations data'!E$35","v":158960.9705},null,null,264957,3.3518646421872231E-2,0.96648135357812781]
["Peel",17382,30528,{"$f":"'Demand and Allocations data'!F$35","v":11163.91},null,null,47910,0.36280525986224171,0.63719474013775834]
["Lachlan",60745,632837,{"$f":"'Demand and Allocations data'!G$35","v":227697.17900000006},null,null,693582,8.7581569302548221E-2,0.91241843069745177]
["Macquarie",42606,631716,{"$f":"'Demand and Allocations data'!H$35","v":279670.66850000003},null,null,674322,6.3183464279676471E-2,0.93681653572032353]
["Murray ",261400.7,2075822,{"$f":"'Demand and Allocations data'!I$35","v":1459688.9339000001},null,null,2337222.7000000002,0.11184244445341045,0.88815755554658948]
["Murrumbidgee",436928,2260113,{"$f":"'Demand and Allocations data'!J$35","v":1759739.925},null,null,2697041,0.16200272817506298,0.837997271824937]
["Lowbidgee",0,747000,0,null,null,747000,0,1]
[null,{"$f":"SUM(B48:B56)","v":852522.6},{"$f":"SUM(C48:C56)","v":7406995},4283475.2669000002,null,null,{"$f":"SUM(G48:G56)","v":8259517.5999999996},{"$f":"B57/G57","v":0.10321699659553968},{"$f":"C57/G57","v":0.89678300340446038}]
[]
["Fish River","2014-15"]
["BULK RAW WATER"]
["   Minimum Annual Quantity (MAQ)  "]
["   - Delta Electricity",8184]
["   - Sydney Catchment Authority",3650]
["   - Oberon Council",1064]
["   - Individual Minor Customers",200]
["Number of Minor Customers",74]
["  Usage "]
["   - Delta Electricity",{"$f":"'Demand and Allocations data'!AE$35","v":6189.8481999999995}]
["   - Sydney Catchment Authority",{"$f":"'Demand and Allocations data'!AF$35","v":2411.6287499999999}]
["   - Oberon Council",{"$f":"'Demand and Allocations data'!AG$35","v":717.08692000000008}]
["   - Individual Minor Customers",{"$f":"'Demand and Allocations data'!AI$35","v":52.092876230661034}]
["  BULK FILTERED WATER"]
["   Minimum Annual Quantity (MAQ)  "]
["   - Lithgow Council",1778]
["   - Individual Minor Customers",200]
["Number of Minor Customers",208]
["  Usage "]
["   - Lithgow Council",{"$f":"'Demand and Allocations data'!AH$35","v":985.50049999999987}]
["   - Individual Minor Customers",{"$f":"'Demand and Allocations data'!AJ$35","v":131.80557665260199}]
[]
[]
["PTRM Data","2014-15","2015-16","2016-17",null,null,"CPI applicable to 2014-15 prices"]
["CPI Forecast",2.5499999999999998E-2,2.5499999999999998E-2,2.5499999999999998E-2,null,null,"CPI All Groups, Weighted Average of Eight Capital Cities, Index Numbers"]
["Nominal Vanilla WACC",6.9157799999999992E-2,6.9157799999999992E-2,6.9157799999999992E-2,null,null,"CPI Index March 2013",102.4]
["Real Vanila WACC",{"$f":"(1+B84)/(1+B83)-1","v":4.2572208678693269E-2},{"$f":"(1+C84)/(1+C83)-1","v":4.2572208678693269E-2},4.2572208678693269E-2,null,null,"CPI Index March 2014",105.4]
["Forecast CPI Index",{"$f":"(1+B83)","v":1.0255000000000001},{"$f":"B86*(1+C83)","v":1.0516502500000002},{"$f":"C86*(1+D83)","v":1.0784673313750004},null,null,"CPI 2014-15",{"$f":"H85/H84-1","v":2.9296875E-2}]
[]
["PTRM Building block requirement (user share)",null,null,null,null,null,"Unsmoothed($'000 Real 2013-14)"]
["Unsmoothed ($'000 Nominal)","2014-15","2015-16","2016-17",null,null,"2014-15","2015-16","2016-17"]
["Border ",1530.9828829088065,1593.6021231140408,1609.8844436285165,null,null,{"$f":"B90/B$86","v":1492.9135864542236},{"$f":"C90/C$86","v":1515.3347066803249},{"$f":"D90/D$86","v":1492.7521648485927}]
["Gwydir ",4960.1754017428639,5153.8722385802148,5367.8068597870006,null,null,{"$f":"B91/B$86","v":4836.83608166052},4900.7474096832229,4977.2549465576049]
["Namoi ",5261.8491777397594,5439.2020299148953,5601.2014637765833,null,null,5131.0084619597847,5172.063649407105,5193.6681815250604]
["Peel",1338.3852672463597,1381.4385226024017,1411.2506773710757,null,null,1305.1050875147339,1313.5912082961054,1308.5706319650783]
["Lachlan",6894.4105233480013,7252.3688007410892,7523.1897903064337,null,null,6722.9746692813269,6896.1794101613987,6975.816115556031]
["Macquarie",6687.9606112277215,6939.2386423418629,7351.3394277805137,null,null,6521.6583239665733,6598.4281773734774,6816.4692744173026]
["Murray ",5103.0586888478738,5148.0786638743293,5292.9856885293857,null,null,4976.1664445127972,4895.2383778488411,4907.8776283200459]
["Murrumbidgee",9280.193839894082,9555.4089904617613,9725.2706281025348,null,null,9049.4332909742388,9086.1091797979025,9017.6775366048641]
["Lowbidgee",544.31612583989545,573.98636391657658,655.11368986642242,null,null,530.78120510960059,545.79587074369681,607.44880332274886]
["Fish River",9685.5395007317384,10054.287892653523,10397.126427706109,null,null,9444.6996594166139,9560.48638095557,9640.650324057764]
[]
[]
["Other Costs",null,null,null,null,null,"ACCC Final decision: Rebates for each ICD"]
["ICD Rebates ($'000 Real 2013-14)","2014-15","2015-16","2016-17",null,null,"ICD","Entitlements","2014/15","2015/16","2016/17"]
["Border ",0,0,0,null,null,"Jemalong",99087,67447.588217902638,61654.214269189091,59282.067247067105]
["Gwydir ",0,0,0,null,null,"Murray Irrigation",1392519,958437.99885637197,896971.53683780623,871223.7564804944]
["Namoi ",0,0,0,null,null,"Western Murray",48657,33489.46600395003,31341.722495647911,30442.05093005655]
["Peel",0,0,0,null,null,"West Corugan",77278,53188.625559595748,49777.537271485693,48348.661277368315]
["Lachlan",{"$f":"I104/1000","v":67.447588217902634},{"$f":"J104/1000","v":61.65421426918909},{"$f":"K104/1000","v":59.282067247067104},null,null,"Moira",38615,26577.794145601463,24873.309373151737,24159.3151378863]
["Macquarie",0,0,0,null,null,"Eagle Creek",13620,9374.3249064636002,8773.1315204538823,8521.2967027841878]
["Murray ",{"$f":"SUM(I105:I109)/1000","v":1081.0682094719828},{"$f":"SUM(J105:J109)/1000","v":1011.7372374985455},{"$f":"SUM(K105:K109)/1000","v":982.69508052858976},null,null,"Murrumbidgee Irrigation",1198779.3,650930.67360036355,622704.3264722164,611001.44524272892]
["Murrumbidgee",{"$f":"SUM(I110:I111)/1000","v":936.58622634131177},{"$f":"SUM(J110:J111)/1000","v":895.97297978169172},{"$f":"SUM(K110:K111)/1000","v":879.13438573077497},null,null,"Coleambally",526074.4,285655.55274094833,273268.65330947522,268132.94048804604]
["Lowbidgee",0,0,0,null,null,"Total rebates",null,2085102.0240311972,1969364.4315494262,1921111.5335064318]
["Fish River",0,0,0]
[]
[]
["MDBA / BCR costs ($'000 Real 2013-14)","2014-15","2015-16","2016-17"]
["Border ",700,700,700]
["Gwydir ",0,0,0]
["Namoi ",0,0,0]
["Peel",0,0,0]
["Lachlan",0,0,0]
["Macquarie",0,0,0]
["Murray ",10200,10400,9300]
["Murrumbidgee",2300,2300,2100]
["Lowbidgee",0,0,0]
["Fish River",0,0,0]
[]
[]
[]
["IPART Model Data - Year 2013-14 ($,000)"]
[]
["Real $2009-10","Border Rivers","Gwydir","Namoi","Peel","Lachlan","Macquarie","Murray","Murrumbidgee","Fish River"]
["MDBA / BCR costs"]
["MDBA",18.293197843003512,55.750698188201184,64.461744780107608,4.3555232959532173,0,39.19970966357895,5520.1902252911077,1224.7731508220445,0]
["BRC",715,0,0,0,0,0,0,0,0]
["Total",{"$f":"SUM(B134:B135)","v":733.29319784300355},55.750698188201184,64.461744780107608,4.3555232959532173,0,39.19970966357895,5520.1902252911077,1224.7731508220445,0]
[]
["Tariff Revenue"]
["High Security Entitlement",{"$f":"B145*B150/10^3","v":32.372822863291269},282.46055094445347,125.14774363229107,396.13890359743345,680.00829206567414,440.23282371639874,730.81319661240263,1176.9354506375084]
["General Security Entitlement",762.5197184649918,1872.56083114382,2105.6308046494537,77.464450817750887,2530.3288530885025,2421.3662448850264,4394.0662899765057,3269.1460669577209]
["Usage",1266.9996997375563,2907.898037401013,2993.3423303986747,491.48209725824427,4216.9765475135027,3804.2335348078395,6927.165357271615,6166.4182202985412]
["Total",{"$f":"SUM(B139:B141)","v":2061.8922410658392},5062.9194194892862,5224.12087868042,965.08545167342868,7427.3136926676798,6665.8326034092643,12052.044843860524,10612.49973789377,10312.522129301229]
[]
["Tariffs"]
["High Security Entitlement",10.359303316253207,13.16341462132787,14.676644028649122,22.791490915219693,11.188413750157114,10.335559555721433,2.8387908112020774,2.693658707855223]
["General Security Entitlement",2.8983777808122539,3.6741012844590464,8.232210965497444,2.5060480352544685,3.9977009935895045,3.8329981271410354,2.1163749221429997,1.4439278466546124]
["Usage",8.5299999999999994,11.73800574180628,18.080365469994206,37.655392736178428,16.32471023955943,12.645689716921442,4.4941427589797733,3.4146978436997952]
[]
["Volumes"]
["High Security Entitlement",3125,21458,8527,17381,60777.9,42594,257438.2,436928.2]
["General Security Entitlement",263085,509665,255779.5,30911,632946,631716,2076223,2264064.7000000002]
["Usage",148534.54862104999,247733.56746999998,165557.6230119,13052.103869999999,258318.61549949998,300832.42748849996,1541376.3488999999,1805845.9350000001]
[]
[]
["Proportion of tariffs which recover MDBA / BCR costs",{"$f":"B136/B142","v":0.35564089298088031},{"$f":"C136/C142","v":1.1011571302832417E-2},1.2339252149232474E-2,4.5130960045049618E-3,0,5.8806921799281486E-3,0.45802934662188616,0.11540854474170489,0]

{"sheet":"Demand and Allocations data","index":1,"n_rows":41,"n_cols":36,"rows_kept":41,"cut":false,"hidden":false,"merged":[[4,26,4,27],[4,34,4,35],[3,24,3,25],[3,26,3,27],[3,30,3,35],[4,22,4,23],[4,24,4,25],[3,12,3,13],[3,14,3,15],[3,16,3,17],[3,18,3,19],[3,20,3,21],[3,22,3,23],[4,12,4,13],[4,14,4,15],[4,16,4,17],[4,18,4,19],[4,20,4,21]]}
[]
[]
[null,"Demand",null,null,null,null,null,null,null,null,null,"General Security and High Security Allocations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fish River"]
["Year",null,"Border  ","Gwydir  ","Namoi   ","Peel  ","Lachlan  ","Macquarie  ","Murray  ","Murrumbidgee  ",null,null,"Border  ",null,"Gwydir  ",null,"Namoi   ",null,"Peel  ",null,"Lachlan  ",null,"Macquarie  ",null,"Murray  ",null,"Murrumbidgee  ",null,null,null,"Actual Water usage"]
["Counter","FY ending","Actual  ","Actual  ","Actual  ","Actual  ","Actual  ","Actual  ","Actual  ","Actual  ",null,"FY ending","Actual  ",null,"Actual  ",null,"Actual  ",null,"Actual  ",null,"Actual  ",null,"Actual  ",null,"Actual  ",null,"Actual  ",null,null,"FY ending",null,null,null,null,"Minor customers"]
[null,null,null,null,null,null,null,null,null,null,null,null,"GS","HS","GS","HS","GS","HS","GS","HS","GS","HS","GS","HS","GS","HS","GS","HS",null,null,"Delta Electricity","SCA","Oberon Council","Lithgow Council","Raw","Filtered"]
[1,1994,68087,98862.55,122249.2,9980.2000000000007,284975.05,514616.38,1826143,2087709,null,1994,7.0000000000000007E-2,1,0,1,0.27,1,1,1,1.2,1,1,1,1.3,1,1.2,1,null,1994,5201,3736,704,2088,117.27285513361463,301.13783403656822]
[{"$f":"A7+1","v":2},1995,63884,45180.76,39635.9,11916.2,389862.37,167019.87,2135851,2565241,null,1995,0,1,0,1,0,1,0.5,1,0.8,1,0.8,1,0.95,1,1,1,null,1995,6281,3293,596,1480,42.822784810126578,109.96202531645571]
[{"$f":"A8+1","v":3},1996,139403,178003,97586,5942,385000,199100,2033592.8959999997,2159000,null,1996,0.05,1,0.18,1,0.3,1,0.3,1,1,1,0.55000000000000004,1,1,1,1.05,1,null,1996,7662,3215,622,1138,45.341772151898731,116.43037974683546]
[4,1997,169812,394616,198965.3,5641,436000,348937,2372283.84,2611000,null,1997,0.65,1,0.75,1,1,1,0.65,1,1,1,0.85,1,1,1,1,1,null,1997,7451,3650,734,1098,72.490857946554144,186.14486638537272]
[5,1998,187883,454913,323274.03000000003,16020,414000,403989,1972012.6,2442000,null,1998,0.55000000000000004,1,0.82,1,1,1,1,1,0.65,1,0.1,1,0.84,1,0.9,1,null,1998,7243,3003,827,970,53.738396624472571,137.99156118143461]
[6,1999,164331,374762,216487.31,5561,278000,336071,2063827.2,2119000,null,1999,0.35,1,1.6818532818532819,1,2.3193548387096774,1,1,1,1,1,1,1,0.93,1,0.85,1,null,1999,7204,3317,855,898,47.860759493670884,122.8987341772152]
[7,2000,180863,417837,246477.68,7309,285000,385748,1252922.3419999997,1713000,null,2000,0.6,1,0.49365735483382545,1,0.66704453441295553,1,1,1,0.74,1,1,1,0.35,1,0.78,1,null,2000,7294,3468,767,858,50.099859353023909,128.64838255977497]
[8,2001,231793,425315,248842.49,10241,407000,464188,2224902,2198000,null,2001,0.4,1,0.44698039215686275,1,1.2267206477732793,1,1,1,0.84,1,1,1,0.95,1,0.9,1,null,2001,8136.5239999999994,3779.4380000000001,968.54200000000014,926.60400000000004,50.379746835443036,129.36708860759495]
[9,2002,182622,443145,280339.88,14671,439572.22,545663.54,2076048,2254000,null,2002,0.96160074708827048,1,0.26623529411764707,1,0.29801619433198379,1,1,1,0.57999999999999996,1,0.9,1,1.05,1,0.72,1,null,2002,8359,3677,838,1019,50.379746835443036,129.36708860759495]
[10,2003,123803,278986,236853.11,21805,237252.44,375914.33,969209,1730000,null,2003,0.13839384105607955,1,0,1,0,1,0.6,1,0.03,1,0,1,0.1,1,0.38,1,null,2003,8303,4390,911,1183,66.333333333333329,170.33333333333334]
[11,2004,100542.36,159250,80652.710000000006,13325,43509.97,174168.35,1306721,1655000,null,2004,0.539439584742478,1,0.30715686274509807,1,0.46469635627530365,1,0.35,1,0,0.7,0.19,1,0.55000000000000004,1,0.41,0.95,null,2004,6734,3005,732,968,60.455696202531641,155.24050632911394]
[12,2005,107563.76,154840,96650,15165,21164.7,63783.6,1244515.1000000001,1533411,null,2005,0.16670339942696896,1,4.598039215686274E-2,1,0.14133603238866396,1,0.65,1,0,0.3,0.09,1,0.49,0.97,0.4,0.95,null,2005,4960,1878,677,735,45.341772151898731,116.43037974683546]
[13,2006,134417.37,218496,141325.29999999999,14753,112435.93,180723,1644734.3,1942641,null,2006,0.3804940350611139,1,0.21882630029440631,1,0.29975719497365222,1,0.45,1,0.19,1,0.44,1,0.63,0.97,0.54,0.95,null,2006,6367,2098,725,959,63.814345991561176,163.8649789029536]
[14,2007,131933.79999999999,129467,66558.5,9718,57260.200000000004,204745,559114.69999999995,934075,null,2007,0.25184189888614927,1,0,1,0,1,0,1,0,0.8,0,1,0,0.69,0.1,0.9,null,2007,6590,3115,749,795,47,112]
[15,2008,112269,79132,51211.6,9080,30776.5,30867,226153,471430,null,2008,0.25349809885931562,1,0.24245098039215687,1,0.1362753036437247,1,0.5,1,0,0.3,0.05,1,0,0.5,0.13,0.9,null,2008,4366.7,1077.2,600.97099999999989,747.33799999999997,40,110]
[16,2009,117688,143199,97482,10183,27797.599999999999,65439,301558,568580,null,2009,0.23741444866920153,1,0,1,0.23732793522267207,1,0.8,1,0,0.3,0.1,1,0.09,0.95,0.21,0.95,null,2009,3596.64,249.636,582.90839999999992,747.90599999999995,42,104]
[17,2010,100850,46959,75152,17517,11786.7,73820,414880,822914,null,2010,2.688212927756654E-2,1,0,1,5.7489878542510116E-3,1,0,1,0,0.1,0,1,0.27,0.97,0.27,0.95,null,2010,3824.4,0,591.11400000000003,747.19299999999998,40,88]
[18,2011,163725,245148,149958,6915,85698.8,203146,773243,1279759,null,2011,1,1,0.82900000000000007,1,1.093,1,1,1,1,1,1,1,1,1,1,0.99960000000000004,null,2011,4248.2,223.876,617.91300000000001,764.46400000000006,30,97]
[19,2012,134199.79999999999,200724.1,128271.7,4218.7,212768.7,296617.90000000002,1670161.2,1738425.6,null,2012,1,1,1,1,1.165,1,1,1,1,1,0.49,1,1,1,1,1,null,2012,4111.5,43.424999999999997,658.29,754.505,35.825597749648381,91.994374120956408]
[20,2013,197868.7,428699.4,281246.7,13317.1,394082.4,558856.4,2125906.5,2369612.9,null,2013,1,1,1.62,1,1,1,0.83,1,0,1,0.64,1,1,1,1,1,null,2013,5864,1014,585,833,40.700000000000003,65.3]
[]
[]
[]
[]
[]
[]
[]
[null,"Forecasts (20 year moving average)",null,null,null,null,null,null,null,null,null,"Forecasts (20 year moving average)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Forecasts (20 year moving average)"]
[null,2015,{"$f":"AVERAGE(C7:C26)","v":140676.93950000001},245876.74050000001,158960.9705,11163.91,{"$f":"AVERAGE(G7:G26)","v":227697.17900000006},279670.66850000003,{"$f":"AVERAGE(I7:I26)","v":1459688.9339000001},1759739.925,null,2015,{"$f":"AVERAGE(M7:M26)","v":0.43131340915335714},1,0.44510704292750702,1,0.58121390127930805,1,0.68149999999999999,1,0.50150000000000006,0.82499999999999996,0.51000000000000012,1,0.67500000000000004,0.95250000000000001,0.69200000000000017,0.9774799999999999,null,2015,{"$f":"AVERAGE(AE7:AE26)","v":6189.8481999999995},2411.6287499999999,717.08692000000008,985.50049999999987,{"$f":"AVERAGE(AI7:AI26)","v":52.092876230661034},{"$f":"AVERAGE(AJ7:AJ26)","v":131.80557665260199}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Forecast Average Water Allocation"]
[null,null,null,null,null,null,null,null,null,null,null,2015,{"$f":"N35/M35","v":2.3184996774455522},null,{"$f":"P35/O35","v":2.2466505886379928},null,{"$f":"R35/Q35","v":1.7205369620356692},null,{"$f":"T35/S35","v":1.467351430667645},null,{"$f":"V35/U35","v":1.64506480558325},null,{"$f":"X35/W35","v":1.9607843137254897},null,{"$f":"Z35/Y35","v":1.411111111111111},null,{"$f":"AB35/AA35","v":1.4125433526011555}]

{"sheet":"Total Tariffs","index":2,"n_rows":139,"n_cols":15,"rows_kept":139,"cut":false,"hidden":false,"merged":[[120,1,120,4],[120,6,120,9],[120,11,120,14],[102,1,102,4],[102,6,102,9],[102,11,102,14],[109,1,109,4],[109,6,109,9],[109,11,109,14],[88,12,88,14],[89,3,89,4],[89,8,89,9],[89,13,89,14],[91,1,91,4],[91,6,91,9],[91,11,91,14],[40,1,40,3],[40,5,40,7],[40,9,40,11],[88,2,88,4],[88,7,88,9],[127,1,127,4],[6,2,6,3],[6,6,6,7],[6,10,6,11],[8,1,8,3],[8,5,8,7],[8,9,8,11],[19,1,19,3],[19,5,19,7],[19,9,19,11],[27,2,27,3],[27,6,27,7],[27,10,27,11],[29,1,29,3],[29,5,29,7],[29,9,29,11]]}
["Total Tariffs","Check",{"$f":"IF(D1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(Border!D1,Gwydir!D1,Namoi!D1,Peel!D1,Lachlan!D1,Macquarie!D1,Murray!D1,Murrumbidgee!D1,Lowbidgee!D1,'Fish River'!D1)","v":4.6870809455867857E-9}]
[]
[null,"2014-15","2015-16","2016-17"]
["CPI Forecast",{"$f":"Inputs!H86","v":2.9296875E-2},{"$f":"Inputs!C83","v":2.5499999999999998E-2},{"$f":"Inputs!D83","v":2.5499999999999998E-2}]
["CPI Index",{"$f":"1+B4","v":1.029296875},{"$f":"B5*(1+C4)","v":1.0555439453125002},{"$f":"C5*(1+D4)","v":1.0824603159179691}]
[]
[null,null,"Indicative Prices",null,null,null,"Indicative Prices",null,null,null,"Indicative Prices"]
["Tariffs ($ Nominal)","2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17"]
[null,"High Security Entitlement ($/ML)",null,null,null,"General Security Entitlement ($/ML)",null,null,null,"Usage ($/ML delivered)"]
["Border ",{"$f":"SUM('SW Costs Tariffs'!B10,'MDBA & BCR Tariffs'!B10)","v":9.8325855337143846},{"$f":"SUM('SW Costs Tariffs'!C10,'MDBA & BCR Tariffs'!C10)","v":10.118340592632828},{"$f":"SUM('SW Costs Tariffs'!D10,'MDBA & BCR Tariffs'!D10)","v":10.412458774943575},null,{"$f":"SUM('SW Costs Tariffs'!F10,'MDBA & BCR Tariffs'!F10)","v":3.3132234276080723},{"$f":"SUM('SW Costs Tariffs'!G10,'MDBA & BCR Tariffs'!G10)","v":3.4095124812369257},{"$f":"SUM('SW Costs Tariffs'!H10,'MDBA & BCR Tariffs'!H10)","v":3.5086196030388299},null,{"$f":"SUM('SW Costs Tariffs'!J10,'MDBA & BCR Tariffs'!J10)","v":9.6269897953631887},{"$f":"SUM('SW Costs Tariffs'!K10,'MDBA & BCR Tariffs'!K10)","v":9.9067698213541799},{"$f":"SUM('SW Costs Tariffs'!L10,'MDBA & BCR Tariffs'!L10)","v":10.194738100910726}]
["Gwydir ",{"$f":"SUM('SW Costs Tariffs'!B11,'MDBA & BCR Tariffs'!B11)","v":13.566205303673039},{"$f":"SUM('SW Costs Tariffs'!C11,'MDBA & BCR Tariffs'!C11)","v":14.106982020226342},{"$f":"SUM('SW Costs Tariffs'!D11,'MDBA & BCR Tariffs'!D11)","v":14.669315203796033},null,{"$f":"SUM('SW Costs Tariffs'!F11,'MDBA & BCR Tariffs'!F11)","v":3.3361400698703694},{"$f":"SUM('SW Costs Tariffs'!G11,'MDBA & BCR Tariffs'!G11)","v":3.4691254429030143},{"$f":"SUM('SW Costs Tariffs'!H11,'MDBA & BCR Tariffs'!H11)","v":3.6074118851564489},null,{"$f":"SUM('SW Costs Tariffs'!J11,'MDBA & BCR Tariffs'!J11)","v":12.148868380839179},{"$f":"SUM('SW Costs Tariffs'!K11,'MDBA & BCR Tariffs'!K11)","v":12.633147146032988},{"$f":"SUM('SW Costs Tariffs'!L11,'MDBA & BCR Tariffs'!L11)","v":13.136730254237666}]
["Namoi ",{"$f":"SUM('SW Costs Tariffs'!B12,'MDBA & BCR Tariffs'!B12)","v":16.510744920256986},{"$f":"SUM('SW Costs Tariffs'!C12,'MDBA & BCR Tariffs'!C12)","v":17.045898067357065},{"$f":"SUM('SW Costs Tariffs'!D12,'MDBA & BCR Tariffs'!D12)","v":17.598396821347343},null,{"$f":"SUM('SW Costs Tariffs'!F12,'MDBA & BCR Tariffs'!F12)","v":7.6770195745040644},{"$f":"SUM('SW Costs Tariffs'!G12,'MDBA & BCR Tariffs'!G12)","v":7.9258503332304127},{"$f":"SUM('SW Costs Tariffs'!H12,'MDBA & BCR Tariffs'!H12)","v":8.182746298237328},null,{"$f":"SUM('SW Costs Tariffs'!J12,'MDBA & BCR Tariffs'!J12)","v":19.934444130084483},{"$f":"SUM('SW Costs Tariffs'!K12,'MDBA & BCR Tariffs'!K12)","v":20.580567643192413},{"$f":"SUM('SW Costs Tariffs'!L12,'MDBA & BCR Tariffs'!L12)","v":21.247633580953206}]
[{"$f":"\"Peel Valley (\" &Peel!H36*100& \"% price cap)\"","v":"Peel Valley (10% price cap)"},{"$f":"SUM('SW Costs Tariffs'!B13,'MDBA & BCR Tariffs'!B13)","v":28.392070059026345},{"$f":"SUM('SW Costs Tariffs'!C13,'MDBA & BCR Tariffs'!C13)","v":32.027674630084675},{"$f":"SUM('SW Costs Tariffs'!D13,'MDBA & BCR Tariffs'!D13)","v":36.12881836646703},null,{"$f":"SUM('SW Costs Tariffs'!F13,'MDBA & BCR Tariffs'!F13)","v":3.1221133014491054},{"$f":"SUM('SW Costs Tariffs'!G13,'MDBA & BCR Tariffs'!G13)","v":3.5218999096996635},{"$f":"SUM('SW Costs Tariffs'!H13,'MDBA & BCR Tariffs'!H13)","v":3.972879193136706},null,{"$f":"SUM('SW Costs Tariffs'!J13,'MDBA & BCR Tariffs'!J13)","v":46.899326524656054},{"$f":"SUM('SW Costs Tariffs'!K13,'MDBA & BCR Tariffs'!K13)","v":52.904785286138264},{"$f":"SUM('SW Costs Tariffs'!L13,'MDBA & BCR Tariffs'!L13)","v":59.679243042028276}]
["Lachlan",{"$f":"SUM('SW Costs Tariffs'!B14,'MDBA & BCR Tariffs'!B14)","v":12.838614189054658},{"$f":"SUM('SW Costs Tariffs'!C14,'MDBA & BCR Tariffs'!C14)","v":13.431388850618669},{"$f":"SUM('SW Costs Tariffs'!D14,'MDBA & BCR Tariffs'!D14)","v":14.051532649865148},null,{"$f":"SUM('SW Costs Tariffs'!F14,'MDBA & BCR Tariffs'!F14)","v":3.1854372372595727},{"$f":"SUM('SW Costs Tariffs'!G14,'MDBA & BCR Tariffs'!G14)","v":3.3325128057317319},{"$f":"SUM('SW Costs Tariffs'!H14,'MDBA & BCR Tariffs'!H14)","v":3.4863790347098935},null,{"$f":"SUM('SW Costs Tariffs'!J14,'MDBA & BCR Tariffs'!J14)","v":18.417515158343878},{"$f":"SUM('SW Costs Tariffs'!K14,'MDBA & BCR Tariffs'!K14)","v":19.267874562721403},{"$f":"SUM('SW Costs Tariffs'!L14,'MDBA & BCR Tariffs'!L14)","v":20.157496110248879}]
["Macquarie",{"$f":"SUM('SW Costs Tariffs'!B15,'MDBA & BCR Tariffs'!B15)","v":12.548565960523746},{"$f":"SUM('SW Costs Tariffs'!C15,'MDBA & BCR Tariffs'!C15)","v":13.110164739643821},{"$f":"SUM('SW Costs Tariffs'!D15,'MDBA & BCR Tariffs'!D15)","v":13.696897322076667},null,{"$f":"SUM('SW Costs Tariffs'!F15,'MDBA & BCR Tariffs'!F15)","v":3.4041322552484639},{"$f":"SUM('SW Costs Tariffs'!G15,'MDBA & BCR Tariffs'!G15)","v":3.5564808602225266},{"$f":"SUM('SW Costs Tariffs'!H15,'MDBA & BCR Tariffs'!H15)","v":3.7156476777973948},null,{"$f":"SUM('SW Costs Tariffs'!J15,'MDBA & BCR Tariffs'!J15)","v":14.401344056593187},{"$f":"SUM('SW Costs Tariffs'!K15,'MDBA & BCR Tariffs'!K15)","v":15.045862104736221},{"$f":"SUM('SW Costs Tariffs'!L15,'MDBA & BCR Tariffs'!L15)","v":15.719224926863523}]
["Murray ",{"$f":"SUM('SW Costs Tariffs'!B16,'MDBA & BCR Tariffs'!B16)","v":4.6538732086229695},{"$f":"SUM('SW Costs Tariffs'!C16,'MDBA & BCR Tariffs'!C16)","v":4.7998823717589252},{"$f":"SUM('SW Costs Tariffs'!D16,'MDBA & BCR Tariffs'!D16)","v":4.5595141057852384},null,{"$f":"SUM('SW Costs Tariffs'!F16,'MDBA & BCR Tariffs'!F16)","v":2.6384163072508171},{"$f":"SUM('SW Costs Tariffs'!G16,'MDBA & BCR Tariffs'!G16)","v":2.7211931556428555},{"$f":"SUM('SW Costs Tariffs'!H16,'MDBA & BCR Tariffs'!H16)","v":2.5849213828073796},null,{"$f":"SUM('SW Costs Tariffs'!J16,'MDBA & BCR Tariffs'!J16)","v":6.8782548542501782},{"$f":"SUM('SW Costs Tariffs'!K16,'MDBA & BCR Tariffs'!K16)","v":7.0940510717414691},{"$f":"SUM('SW Costs Tariffs'!L16,'MDBA & BCR Tariffs'!L16)","v":6.7387955419651426}]
["Murrumbidgee",{"$f":"SUM('SW Costs Tariffs'!B17,'MDBA & BCR Tariffs'!B17)","v":3.5659038938086276},{"$f":"SUM('SW Costs Tariffs'!C17,'MDBA & BCR Tariffs'!C17)","v":3.6476968372353697},{"$f":"SUM('SW Costs Tariffs'!D17,'MDBA & BCR Tariffs'!D17)","v":3.6703249419567436},null,{"$f":"SUM('SW Costs Tariffs'!F17,'MDBA & BCR Tariffs'!F17)","v":1.5487461651832215},{"$f":"SUM('SW Costs Tariffs'!G17,'MDBA & BCR Tariffs'!G17)","v":1.5842705402767734},{"$f":"SUM('SW Costs Tariffs'!H17,'MDBA & BCR Tariffs'!H17)","v":1.5940983963985942},null,{"$f":"SUM('SW Costs Tariffs'!J17,'MDBA & BCR Tariffs'!J17)","v":4.3117603853973714},{"$f":"SUM('SW Costs Tariffs'!K17,'MDBA & BCR Tariffs'!K17)","v":4.4106614168819291},{"$f":"SUM('SW Costs Tariffs'!L17,'MDBA & BCR Tariffs'!L17)","v":4.4380224923454739}]
["Lowbidgee",null,null,null,null,{"$f":"SUM('SW Costs Tariffs'!F18,'MDBA & BCR Tariffs'!F18)","v":0.73136738383941879},{"$f":"SUM('SW Costs Tariffs'!G18,'MDBA & BCR Tariffs'!G18)","v":0.7921168913237161},{"$f":"SUM('SW Costs Tariffs'!H18,'MDBA & BCR Tariffs'!H18)","v":0.85791243003818773},null,{"$f":"SUM('SW Costs Tariffs'!J18,'MDBA & BCR Tariffs'!J18)","v":0},{"$f":"SUM('SW Costs Tariffs'!K18,'MDBA & BCR Tariffs'!K18)","v":0},{"$f":"SUM('SW Costs Tariffs'!L18,'MDBA & BCR Tariffs'!L18)","v":0}]
[]
["Fish River","Access  ($/KL)",null,null,null,"Usage < MAQ ($/KL)",null,null,null,"Usage > 200kl ($/KL)"]
["Raw water - major customers",{"$f":"SUM('SW Costs Tariffs'!B21,'MDBA & BCR Tariffs'!B21)","v":0.33125394427935673},{"$f":"SUM('SW Costs Tariffs'!C21,'MDBA & BCR Tariffs'!C21)","v":0.34343089184569497},{"$f":"SUM('SW Costs Tariffs'!D21,'MDBA & BCR Tariffs'!D21)","v":0.35605546593722354},null,{"$f":"SUM('SW Costs Tariffs'!F21,'MDBA & BCR Tariffs'!F21)","v":0.37215646952047915},{"$f":"SUM('SW Costs Tariffs'!G21,'MDBA & BCR Tariffs'!G21)","v":0.38583700040648328},{"$f":"SUM('SW Costs Tariffs'!H21,'MDBA & BCR Tariffs'!H21)","v":0.40002042977914831}]
["Raw water - minor customers *",{"$f":"SUM('SW Costs Tariffs'!B22,'MDBA & BCR Tariffs'!B22)","v":66.250788855871349},{"$f":"SUM('SW Costs Tariffs'!C22,'MDBA & BCR Tariffs'!C22)","v":68.686178369139},{"$f":"SUM('SW Costs Tariffs'!D22,'MDBA & BCR Tariffs'!D22)","v":71.211093187444718},null,{"$f":"SUM('SW Costs Tariffs'!F22,'MDBA & BCR Tariffs'!F22)","v":0.37215646952047915},{"$f":"SUM('SW Costs Tariffs'!G22,'MDBA & BCR Tariffs'!G22)","v":0.38583700040648328},{"$f":"SUM('SW Costs Tariffs'!H22,'MDBA & BCR Tariffs'!H22)","v":0.40002042977914831},null,{"$f":"SUM('SW Costs Tariffs'!J22,'MDBA & BCR Tariffs'!J22)","v":0.70341041379983582},{"$f":"SUM('SW Costs Tariffs'!K22,'MDBA & BCR Tariffs'!K22)","v":0.72926789225217814},{"$f":"SUM('SW Costs Tariffs'!L22,'MDBA & BCR Tariffs'!L22)","v":0.75607589571637179}]
["Filtered water - major customers",{"$f":"SUM('SW Costs Tariffs'!B23,'MDBA & BCR Tariffs'!B23)","v":0.64111232214230041},{"$f":"SUM('SW Costs Tariffs'!C23,'MDBA & BCR Tariffs'!C23)","v":0.6646797128577342},{"$f":"SUM('SW Costs Tariffs'!D23,'MDBA & BCR Tariffs'!D23)","v":0.6891134445963415},null,{"$f":"SUM('SW Costs Tariffs'!F23,'MDBA & BCR Tariffs'!F23)","v":0.64429979922679725},{"$f":"SUM('SW Costs Tariffs'!G23,'MDBA & BCR Tariffs'!G23)","v":0.6679843621057544},{"$f":"SUM('SW Costs Tariffs'!H23,'MDBA & BCR Tariffs'!H23)","v":0.69253957327521298}]
["Filtered water - minor customers *",{"$f":"SUM('SW Costs Tariffs'!B24,'MDBA & BCR Tariffs'!B24)","v":128.22246442846009},{"$f":"SUM('SW Costs Tariffs'!C24,'MDBA & BCR Tariffs'!C24)","v":132.93594257154683},{"$f":"SUM('SW Costs Tariffs'!D24,'MDBA & BCR Tariffs'!D24)","v":137.82268891926827},null,{"$f":"SUM('SW Costs Tariffs'!F24,'MDBA & BCR Tariffs'!F24)","v":0.64429979922679725},{"$f":"SUM('SW Costs Tariffs'!G24,'MDBA & BCR Tariffs'!G24)","v":0.6679843621057544},{"$f":"SUM('SW Costs Tariffs'!H24,'MDBA & BCR Tariffs'!H24)","v":0.69253957327521298},null,{"$f":"SUM('SW Costs Tariffs'!J24,'MDBA & BCR Tariffs'!J24)","v":1.2854121213690977},{"$f":"SUM('SW Costs Tariffs'!K24,'MDBA & BCR Tariffs'!K24)","v":1.3326640749634886},{"$f":"SUM('SW Costs Tariffs'!L24,'MDBA & BCR Tariffs'!L24)","v":1.3816530178715547}]
["* Note : Access Fee for minor customers is an Annual Charge"]
[]
[]
[null,null,"Indicative Prices",null,null,null,"Indicative Prices",null,null,null,"Indicative Prices"]
["Tariffs ($ Real 2013-14)","2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17"]
[null,"High Security Entitlement ($/ML)",null,null,null,"General Security Entitlement ($/ML)",null,null,null,"Usage ($/ML delivered)"]
["Border ",{"$f":"B10/B$5","v":9.5527206703259289},9.5859017879518333,9.6192521996646114,null,{"$f":"F10/B$5","v":3.2189191554750152},3.2300999843521616,3.2413378591744326,null,{"$f":"J10/B$5","v":9.3529768030852996},9.3854641157751324,9.4181171826749015]
["Gwydir ",13.180070427856919,13.364656282548127,13.551827247686097,null,3.2411835213920854,3.2865760429102351,3.3326042831392124,null,11.803075163168234,11.96837630695979,12.135992480331439]
["Namoi ",16.040799618921397,16.148923162370586,16.257775516161264,null,7.4585085809223548,7.5087829061289497,7.5593961070970401,null,19.367050084636158,19.497594330001498,19.629018513195444]
[{"$f":"A13","v":"Peel Valley (10% price cap)"},27.583946622811172,30.342341285092292,33.376575413601529,null,3.033248596474273,3.3365734561217,3.6702308017338701,null,45.564431082777801,50.12087419105557,55.132961610161125]
["Lachlan",12.473188737753292,12.724613608239897,12.981106506383925,null,3.0947701432199266,3.1571521209807343,3.2207915462963705,null,17.893297459339784,18.253976680257527,18.621926193344581]
["Macquarie",12.19139615140068,12.420292682141696,12.65348680284982,null,3.307240445326781,3.3693347169639716,3.4325948241773454,null,13.991438628037404,14.25413140926293,14.521756313563328]
["Murray ",4.5214100243168129,4.547307000409055,4.2121766855892453,null,2.5633190689040197,2.5780008191295436,2.3880056800190999,null,6.6824790993853727,6.7207538854682474,6.2254435039037697]
["Murrumbidgee",3.4644075780455736,3.4557508035872888,3.3907247110894438,null,1.5046642060224087,1.5009043889761884,1.4726622056779382,null,4.1890347577295142,4.1785673031132076,4.099940133677654]
["Lowbidgee",null,null,null,null,0.71055047538099136,0.75043478278794451,0.79255785863211448,null,{"$f":"J18/B$5","v":0},{"$f":"K18/C$5","v":0},{"$f":"L18/D$5","v":0}]
[]
["Fish River","Access  ($/KL)",null,null,null,"Usage < MAQ ($/KL)",null,null,null,"Usage > 200kl ($/KL)"]
["Raw water - major customers",{"$f":"B21/B$5","v":0.32182546389189876},{"$f":"C21/C$5","v":0.32535916043175273},{"$f":"D21/D$5","v":0.32893165754097364},null,{"$f":"F21/B$5","v":0.36156378063469702},{"$f":"G21/C$5","v":0.36553381043008482},{"$f":"H21/D$5","v":0.36954743180577032}]
["Raw water - minor customers",{"$f":"B22/B$5","v":64.365092778379761},65.071832086350554,65.786331508194735,null,{"$f":"F22/B$5","v":0.36156378063469702},0.36553381043008482,0.36954743180577032,null,{"$f":"J22/B$5","v":0.68338924452659566},0.69089297086183743,0.69847908934674396]
["Filtered water - major customers",0.622864343333696,0.62970349629635902,0.63661774428372098,null,0.62596109526398513,0.63283425107231661,0.63978287526218647]
["Filtered water - minor customers",124.57286866673921,125.94069925927181,127.32354885674418,null,0.62596109526398513,0.63283425107231661,0.63978287526218647,null,{"$f":"J24/B$5","v":1.2488254385976811},1.2625377473686756,1.2764006195459077]
[]
[]
[null,"Total Revenue ($'000 Nominal)",null,null,null,"Total Revenue ($'000 Real 2013-14)"]
["Total Revenue","2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17"]
["Border ",{"$f":"SUM('SW Costs Tariffs'!B50,'MDBA & BCR Tariffs'!B50)","v":2257.159101682375},{"$f":"SUM('SW Costs Tariffs'!C50,'MDBA & BCR Tariffs'!C50)","v":2322.7567646651132},{"$f":"SUM('SW Costs Tariffs'!D50,'MDBA & BCR Tariffs'!D50)","v":2390.2742584002726},null,{"$f":"B50/B$5","v":2192.9135864542241},{"$f":"C50/C$5","v":2200.5306126571991},2208.1865018517797]
["Gwydir ",{"$f":"SUM('SW Costs Tariffs'!B51,'MDBA & BCR Tariffs'!B51)","v":4978.5402637404177},{"$f":"SUM('SW Costs Tariffs'!C51,'MDBA & BCR Tariffs'!C51)","v":5176.9950708724482},{"$f":"SUM('SW Costs Tariffs'!D51,'MDBA & BCR Tariffs'!D51)","v":5383.3606928994895},null,{"$f":"B51/B$5","v":4836.83608166052},4904.5755923878351,4973.2637896606739]
["Namoi ",{"$f":"SUM('SW Costs Tariffs'!B52,'MDBA & BCR Tariffs'!B52)","v":5281.3309754937627},{"$f":"SUM('SW Costs Tariffs'!C52,'MDBA & BCR Tariffs'!C52)","v":5452.5116766712736},{"$f":"SUM('SW Costs Tariffs'!D52,'MDBA & BCR Tariffs'!D52)","v":5629.240758094521},null,5131.0084619597847,5165.5941951872255,5200.4130547000259]
[{"$f":"A34","v":"Peel Valley (10% price cap)"},{"$f":"SUM('SW Costs Tariffs'!B53,'MDBA & BCR Tariffs'!B53)","v":1112.4026970145073},{"$f":"SUM('SW Costs Tariffs'!C53,'MDBA & BCR Tariffs'!C53)","v":1254.845862367215},{"$f":"SUM('SW Costs Tariffs'!D53,'MDBA & BCR Tariffs'!D53)","v":1415.5288750433369},null,1080.7403811602044,1188.8144192762247,1307.695861203847]
["Lachlan",{"$f":"SUM('SW Costs Tariffs'!B54,'MDBA & BCR Tariffs'!B54)","v":6989.3604095744022},{"$f":"SUM('SW Costs Tariffs'!C54,'MDBA & BCR Tariffs'!C54)","v":7312.0678054292066},{"$f":"SUM('SW Costs Tariffs'!D54,'MDBA & BCR Tariffs'!D54)","v":7649.6750000119073},null,6790.4222574992291,6927.2983260440424,7066.9334362846184]
["Macquarie",{"$f":"SUM('SW Costs Tariffs'!B55,'MDBA & BCR Tariffs'!B55)","v":6712.722532676532},{"$f":"SUM('SW Costs Tariffs'!C55,'MDBA & BCR Tariffs'!C55)","v":7013.143854983995},{"$f":"SUM('SW Costs Tariffs'!D55,'MDBA & BCR Tariffs'!D55)","v":7327.0102393296438},null,6521.6583239665733,6644.1041001923531,6768.848826680588]
["Murray ",{"$f":"SUM('SW Costs Tariffs'!B56,'MDBA & BCR Tariffs'!B56)","v":16733.520825488238},{"$f":"SUM('SW Costs Tariffs'!C56,'MDBA & BCR Tariffs'!C56)","v":17258.513076570765},{"$f":"SUM('SW Costs Tariffs'!D56,'MDBA & BCR Tariffs'!D56)","v":16394.242134035288},null,16257.234653984779,16350.350123472384,15145.351652113291]
["Murrumbidgee",{"$f":"SUM('SW Costs Tariffs'!B57,'MDBA & BCR Tariffs'!B57)","v":12645.961495361904},{"$f":"SUM('SW Costs Tariffs'!C57,'MDBA & BCR Tariffs'!C57)","v":12936.028318240336},{"$f":"SUM('SW Costs Tariffs'!D57,'MDBA & BCR Tariffs'!D57)","v":13016.275613047232},null,12286.01951731555,12255.319520979818,12024.713905570678]
["Lowbidgee",{"$f":"SUM('SW Costs Tariffs'!B58,'MDBA & BCR Tariffs'!B58)","v":546.3314357280459},{"$f":"SUM('SW Costs Tariffs'!C58,'MDBA & BCR Tariffs'!C58)","v":591.71131781881593},{"$f":"SUM('SW Costs Tariffs'!D58,'MDBA & BCR Tariffs'!D58)","v":640.86058523852626},null,530.78120510960059,560.57478274259461,592.04072039818959]
["Fish River",{"$f":"SUM('SW Costs Tariffs'!B59,'MDBA & BCR Tariffs'!B59)","v":9721.3998447510858},{"$f":"SUM('SW Costs Tariffs'!C59,'MDBA & BCR Tariffs'!C59)","v":10078.760045966115},{"$f":"SUM('SW Costs Tariffs'!D59,'MDBA & BCR Tariffs'!D59)","v":10449.256864895864},null,9444.6996594166139,9548.4040155071307,9653.2470624888283]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["State Water bulk water charges - ACCC Final Decision",null,null,null,null,"Comparison of proposed prices against 2013-14"]
["Prices ($ Real 2013-14)"]
[null,"IPART-set","ACCCFinal Decision",null,null,null,{"$f":"$B89","v":"IPART-set"},{"$f":"$C89","v":"ACCCFinal Decision"},null,null,null,{"$f":"$B89","v":"IPART-set"},{"$f":"$C89","v":"ACCCFinal Decision"}]
[null,null,null,"Indicative Prices",null,null,null,null,{"$f":"$D90","v":"Indicative Prices"},null,null,null,null,{"$f":"$D90","v":"Indicative Prices"}]
[null,"2013-14","2014-15","2015-16","2016-17",null,"2013-14","2014-15","2015-16","2016-17",null,"2013-14","2014-15","2015-16","2016-17"]
[null,"High Security Entitlement ($/ML)",null,null,null,null,"General Security Entitlement ($/ML)",null,null,null,null,"Usage ($/ML delivered)"]
["Border ",{"$f":"Inputs!B5","v":11.45},{"$f":"B31","v":9.5527206703259289},9.5859017879518333,9.6192521996646114,null,{"$f":"Inputs!C5","v":3.21},{"$f":"F31","v":3.2189191554750152},{"$f":"G31","v":3.2300999843521616},{"$f":"H31","v":3.2413378591744326},null,{"$f":"Inputs!D5","v":9.43},{"$f":"J31","v":9.3529768030852996},9.3854641157751324,9.4181171826749015]
["Gwydir ",{"$f":"Inputs!B6","v":14.55},13.180070427856919,13.364656282548127,13.551827247686097,null,{"$f":"Inputs!C6","v":4.0599999999999996},3.2411835213920854,3.2865760429102351,3.3326042831392124,null,{"$f":"Inputs!D6","v":12.97},11.803075163168234,11.96837630695979,12.135992480331439]
["Namoi ",{"$f":"Inputs!B7","v":16.22},16.040799618921397,16.148923162370586,16.257775516161264,null,{"$f":"Inputs!C7","v":9.09},7.4585085809223548,7.5087829061289497,7.5593961070970401,null,{"$f":"Inputs!D7","v":19.98},19.367050084636158,19.497594330001498,19.629018513195444]
["Peel",{"$f":"Inputs!B8","v":25.19},27.583946622811172,30.342341285092292,33.376575413601529,null,{"$f":"Inputs!C8","v":2.77},3.033248596474273,3.3365734561217,3.6702308017338701,null,{"$f":"Inputs!D8","v":41.61},45.564431082777801,50.12087419105557,55.132961610161125]
["Lachlan",{"$f":"Inputs!B9","v":12.36},12.473188737753292,12.724613608239897,12.981106506383925,null,{"$f":"Inputs!C9","v":4.42},3.0947701432199266,3.1571521209807343,3.2207915462963705,null,{"$f":"Inputs!D9","v":18.04},17.893297459339784,18.253976680257527,18.621926193344581]
["Macquarie",{"$f":"Inputs!B10","v":11.42},12.19139615140068,12.420292682141696,12.65348680284982,null,{"$f":"Inputs!C10","v":4.24},3.307240445326781,3.3693347169639716,3.4325948241773454,null,{"$f":"Inputs!D10","v":13.98},13.991438628037404,14.25413140926293,14.521756313563328]
["Murray ",{"$f":"Inputs!B11","v":3.14},4.5214100243168129,4.547307000409055,4.2121766855892453,null,{"$f":"Inputs!C11","v":2.33},2.5633190689040197,2.5780008191295436,2.3880056800190999,null,{"$f":"Inputs!D11","v":4.97},6.6824790993853727,6.7207538854682474,6.2254435039037697]
["Murrumbidgee",{"$f":"Inputs!B12","v":2.98},3.4644075780455736,3.4557508035872888,3.3907247110894438,null,{"$f":"Inputs!C12","v":1.59},1.5046642060224087,1.5009043889761884,1.4726622056779382,null,{"$f":"Inputs!D12","v":3.78},4.1890347577295142,4.1785673031132076,4.099940133677654]
["Lowbidgee",null,null,null,null,null,null,0.71055047538099136,0.75043478278794451,0.79255785863211448,null,null,0,{"$f":"K39","v":0},{"$f":"L39","v":0}]
[]
["Fish River","Access ",null,null,null,null,"Usage < MAQ",null,null,null,null,"Usage > MAQ"]
["Raw water - major customers",{"$f":"Inputs!B17","v":0.38},{"$f":"B42","v":0.32182546389189876},0.32535916043175273,0.32893165754097364,null,{"$f":"Inputs!C17","v":0.43},{"$f":"F42","v":0.36156378063469702},0.36553381043008482,0.36954743180577032,null,{"$f":"Inputs!D17","v":0.81}]
["Raw water - minor customers",{"$f":"Inputs!B18*'Fish River'!C36","v":94},64.365092778379761,65.071832086350554,65.786331508194735,null,{"$f":"Inputs!C18","v":0.85},0.36156378063469702,0.36553381043008482,0.36954743180577032,null,{"$f":"Inputs!D18","v":1.33},{"$f":"J43","v":0.68338924452659566},{"$f":"K43","v":0.69089297086183743},{"$f":"L43","v":0.69847908934674396}]
["Filtered water - major customers",{"$f":"Inputs!B19","v":0.56999999999999995},0.622864343333696,0.62970349629635902,0.63661774428372098,null,{"$f":"Inputs!C19","v":0.61},0.62596109526398513,0.63283425107231661,0.63978287526218647,null,{"$f":"Inputs!D19","v":1.18}]
["Filtered water - minor customers",{"$f":"Inputs!B20*'Fish River'!C49","v":134.66272469999996},124.57286866673921,125.94069925927181,127.32354885674418,null,{"$f":"Inputs!C20","v":1.04},0.62596109526398513,0.63283425107231661,0.63978287526218647,null,{"$f":"Inputs!D20","v":1.71},{"$f":"J45","v":1.2488254385976811},{"$f":"K45","v":1.2625377473686756},{"$f":"L45","v":1.2764006195459077}]
[]
[]
["Positive change implies real increase in price","% Real change in prices over 2013-14",null,null,null,null,{"$f":"$B110","v":"% Real change in prices over 2013-14"},null,null,null,null,{"$f":"$B110","v":"% Real change in prices over 2013-14"}]
["Border ",null,{"$f":"C93/$B93-1","v":-0.16570125149991888},{"$f":"D93/$B93-1","v":-0.16280333729678309},-0.15989063758387667,null,null,{"$f":"H93/$G93-1","v":2.7785531074813186E-3},{"$f":"I93/$G93-1","v":6.261677368274654E-3},9.7625729515367077E-3,null,null,{"$f":"M93/$L93-1","v":-8.167889386500593E-3},{"$f":"N93/$L93-1","v":-4.7227872985012853E-3},-1.2601078817707778E-3]
["Gwydir ",null,{"$f":"C94/$B94-1","v":-9.4153235198837226E-2},-8.1466922161640754E-2,-6.8602938303361061E-2,null,null,{"$f":"H94/$G94-1","v":-0.20167893561771288},-0.1904985115984642,-0.17916150661595742,null,null,{"$f":"M94/$L94-1","v":-8.9971074543698237E-2},-7.7226190673879036E-2,-6.4302815703050298E-2]
["Namoi ",null,-1.1048112273649879E-2,-4.3820491756727531E-3,2.328946742371496E-3,null,null,-0.17948200429897088,-0.17395127545336087,-0.16838326654598013,null,null,-3.0678173942134235E-2,-2.4144427927852985E-2,-1.7566640981209081E-2]
["Peel",null,9.5035594395044498E-2,0.20453915383454913,0.3249930692180043,null,null,9.5035594395044498E-2,0.20453915383454868,0.32499306921800364,null,null,9.5035594395044498E-2,0.20453915383454868,0.32499306921800342]
["Lachlan",null,9.1576648667712757E-3,2.9499482867305638E-2,5.0251335467955238E-2,null,null,-0.29982575945250534,-0.28571218982336333,-0.27131412979720126,null,null,-8.1320698813865944E-3,1.1861235047534668E-2,3.2257549520209761E-2]
["Macquarie",null,6.7547824115646193E-2,8.7591303164771928E-2,0.10801110357704191,null,null,-0.2199904610078347,-0.20534558562170491,-0.19042574901477705,null,null,8.1821373658108598E-4,1.9608827558149411E-2,3.8752239882927642E-2]
["Murray ",null,0.43993949819006772,0.44818694280543148,0.34145754318128829,null,null,0.10013693944378521,0.10643811979808726,2.4895141639098561E-2,null,null,0.34456319907150368,0.35226436327328936,0.25260432674120126]
["Murrumbidgee",null,0.16255287853878309,0.1596479206668755,0.13782708425820256,null,null,-5.3670310677730426E-2,-5.6034975486674021E-2,-7.3797354919535763E-2,null,null,0.10821025336759638,0.10544108547968456,8.4640247004670321E-2]
["Lowbidgee"]
[]
["Fish River","Access ",null,null,null,null,"Usage < MAQ",null,null,null,null,"Usage > MAQ"]
["Raw water - major customers",null,{"$f":"C104/$B104-1","v":-0.1530908844950033},-0.14379168307433499,-0.13439037489217465,null,null,{"$f":"H104/$G104-1","v":-0.15915399852396039},{"$f":"I104/$G104-1","v":-0.14992137109282599},-0.14058736789355741]
["Raw water - minor customers",null,{"$f":"C105/$B105-1","v":-0.31526497044276847},-0.30774646716648346,-0.30014540948729007,null,null,{"$f":"H105/$G105-1","v":-0.57463084631212114},-0.56996022302342964,-0.56523831552262316,null,null,{"$f":"M105/$L105-1","v":-0.48617350035594309},-0.48053160085576141,-0.47482775237086927]
["Filtered water - major customers",null,{"$f":"C106/$B106-1","v":9.2744461988940374E-2},0.10474297595852478,0.11687323558547558,null,null,{"$f":"H106/$G106-1","v":2.6165729940959226E-2},3.7433198479207563E-2,4.8824385675715565E-2]
["Filtered water - minor customers",null,{"$f":"C107/$B107-1","v":-7.4926866775782308E-2},-6.4769411581111047E-2,-5.450042585731063E-2,null,null,{"$f":"H107/$G107-1","v":-0.39811433147693742},-0.39150552781508019,-0.38482415840174378,null,null,-0.26969272596626837,-0.26167383194814287,-0.25356688915443992]
[]
[]
["Positive change implies real increase in price","% Average real change in prices over 2013-14"]
[null,null,"2014-15","2015-16","2016-17"]
["Border ",{"$f":"SUMPRODUCT(Border!B$88:B$90,Border!C$34:C$36)/10^3","v":2207.3244194849999},{"$f":"F50/$B130-1","v":-6.5286429595782236E-3},-3.0778469933232522E-3,3.9055535252074947E-4]
["Gwydir ",{"$f":"SUMPRODUCT(Gwydir!B$88:B$90,Gwydir!C$34:C$36)/10^3","v":5570.4736692850001},-0.13170111397701778,-0.11954065604310393,-0.10720989184766783]
["Namoi ",{"$f":"SUMPRODUCT(Namoi!B$88:B$90,Namoi!C$34:C$36)/10^3","v":5647.8208505900002},-9.1506512388088046E-2,-8.53827818126347E-2,-7.9217774027523502E-2]
["Peel",{"$f":"SUMPRODUCT(Peel!B$88:B$90,Peel!C$34:C$36)/10^3","v":986.94543510000005},9.5035594395044498E-2,0.2045391538345489,0.32499306921800364]
["Lachlan",{"$f":"SUMPRODUCT(Lachlan!B$88:B$90,Lachlan!C$34:C$36)/10^3","v":7655.6048491600004},-0.11301296353555945,-9.5133766366725436E-2,-7.6894174199700682E-2]
["Macquarie",{"$f":"SUMPRODUCT(Macquarie!B$88:B$90,Macquarie!C$34:C$36)/10^3","v":7074.8323056300005},-7.8188988482910449E-2,-6.0881754765393259E-2,-4.3249573379416706E-2]
["Murray ",{"$f":"SUMPRODUCT(Murray!B$88:B$90,Murray!C$34:C$36)/10^3","v":12912.117459482999},0.25906805796945709,0.26627953740184229,0.17295646509087059]
["Murrumbidgee",{"$f":"SUMPRODUCT(Murrumbidgee!B$88:B$90,Murrumbidgee!C$34:C$36)/10^3","v":11547.442026500001},6.3960268353857153E-2,6.1301671214743614E-2,4.133139425817367E-2]
["Lowbidgee"]
["Fish River",{"$f":"'Fish River'!B196/10^3","v":10876.799233117626},-0.13166553349082355,-0.12213107819125724,-0.11249193300390548]

{"sheet":"MDBA & BCR Tariffs","index":3,"n_rows":59,"n_cols":12,"rows_kept":59,"cut":false,"hidden":false,"merged":[[29,1,29,3],[29,5,29,7],[29,9,29,11],[40,1,40,3],[40,5,40,7],[40,9,40,11],[19,1,19,3],[19,5,19,7],[19,9,19,11],[27,2,27,3],[27,6,27,7],[27,10,27,11],[6,2,6,3],[6,6,6,7],[6,10,6,11],[8,1,8,3],[8,5,8,7],[8,9,8,11]]}
["MDBA & BCR Tariffs","Check",{"$f":"IF(D1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(Border!D1,Gwydir!D1,Namoi!D1,Peel!D1,Lachlan!D1,Macquarie!D1,Murray!D1,Murrumbidgee!D1,Lowbidgee!D1,'Fish River'!D1)","v":4.6870809455867857E-9}]
[]
[null,"2014-15","2015-16","2016-17"]
["CPI Forecast",{"$f":"Inputs!H86","v":2.9296875E-2},{"$f":"Inputs!C83","v":2.5499999999999998E-2},{"$f":"Inputs!D83","v":2.5499999999999998E-2}]
["CPI Index",{"$f":"1+B4","v":1.029296875},{"$f":"B5*(1+C4)","v":1.0555439453125002},{"$f":"C5*(1+D4)","v":1.0824603159179691}]
[]
[null,null,"Indicative Prices",null,null,null,"Indicative Prices",null,null,null,"Indicative Prices"]
["Tariffs ($ Nominal)","2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17"]
[null,"High Security Entitlement ($/ML)",null,null,null,"General Security Entitlement ($/ML)",null,null,null,"Usage ($/ML delivered)"]
["Border ",{"$f":"Border!C$67","v":3.1386598706468205},{"$f":"IF($B50=0,0,B10*$C50/$B50)","v":3.218695697348315},{"$f":"IF($C50=0,0,C10*$D50/$C50)","v":3.3007724376306977},null,{"$f":"Border!C$68","v":1.0576141320168087},{"$f":"IF($B50=0,0,F10*$C50/$B50)","v":1.0845832923832375},{"$f":"IF($C50=0,0,G10*$D50/$C50)","v":1.1122401663390102},null,{"$f":"Border!C$69","v":3.073031649938617},{"$f":"IF($B50=0,0,J10*$C50/$B50)","v":3.1513939570120519},{"$f":"IF($C50=0,0,K10*$D50/$C50)","v":3.2317545029158601}]
["Gwydir ",{"$f":"Gwydir!C$67","v":0},{"$f":"IF($B51=0,0,B11*$C51/$B51)","v":0},{"$f":"IF($C51=0,0,C11*$D51/$C51)","v":0},null,{"$f":"Gwydir!C$68","v":0},{"$f":"IF($B51=0,0,F11*$C51/$B51)","v":0},{"$f":"IF($C51=0,0,G11*$D51/$C51)","v":0},null,{"$f":"Gwydir!C$69","v":0},{"$f":"IF($B51=0,0,J11*$C51/$B51)","v":0},{"$f":"IF($C51=0,0,K11*$D51/$C51)","v":0}]
["Namoi ",{"$f":"Namoi!C$67","v":0},{"$f":"IF($B52=0,0,B12*$C52/$B52)","v":0},0,null,{"$f":"Namoi!C$68","v":0},{"$f":"IF($B52=0,0,F12*$C52/$B52)","v":0},0,null,{"$f":"Namoi!C$69","v":0},{"$f":"IF($B52=0,0,J12*$C52/$B52)","v":0},0]
["Peel",{"$f":"Peel!C$67","v":0},{"$f":"IF($B53=0,0,B13*$C53/$B53)","v":0},0,null,{"$f":"Peel!C$68","v":0},{"$f":"IF($B53=0,0,F13*$C53/$B53)","v":0},0,null,{"$f":"Peel!C$69","v":0},{"$f":"IF($B53=0,0,J13*$C53/$B53)","v":0},0]
["Lachlan",{"$f":"Lachlan!C$67","v":0},{"$f":"IF($B54=0,0,B14*$C54/$B54)","v":0},0,null,{"$f":"Lachlan!C$68","v":0},{"$f":"IF($B54=0,0,F14*$C54/$B54)","v":0},0,null,{"$f":"Lachlan!C$69","v":0},{"$f":"IF($B54=0,0,J14*$C54/$B54)","v":0},0]
["Macquarie",{"$f":"Macquarie!C$67","v":0},{"$f":"IF($B55=0,0,B15*$C55/$B55)","v":0},0,null,{"$f":"Macquarie!C$68","v":0},{"$f":"IF($B55=0,0,F15*$C55/$B55)","v":0},0,null,{"$f":"Macquarie!C$69","v":0},{"$f":"IF($B55=0,0,J15*$C55/$B55)","v":0},0]
["Murray ",{"$f":"Murray!C$67","v":2.919900446680157},{"$f":"IF($B56=0,0,B16*$C56/$B56)","v":3.053070808228747},2.7997686787210383,null,{"$f":"Murray!C$68","v":1.6553766311887506},{"$f":"IF($B56=0,0,F16*$C56/$B56)","v":1.730874788917085},1.5872704320308251,null,{"$f":"Murray!C$69","v":4.3155063580358348},{"$f":"IF($B56=0,0,J16*$C56/$B56)","v":4.5123272950709605},4.1379559867486551]
["Murrumbidgee",{"$f":"Murrumbidgee!C$67","v":0.6675537951246765},{"$f":"IF($B57=0,0,B17*$C57/$B57)","v":0.68457641690035587},0.64098675765902668,null,{"$f":"Murrumbidgee!C$68","v":0.28993248585524939},{"$f":"IF($B57=0,0,F17*$C57/$B57)","v":0.29732576424455831},0.2783938693864646,null,{"$f":"Murrumbidgee!C$69","v":0.80718159957642599},{"$f":"IF($B57=0,0,J17*$C57/$B57)","v":0.82776473036562503},0.77505771090386599]
["Lowbidgee",{"$f":"Lowbidgee!C$67","v":0},0,0,null,{"$f":"Lowbidgee!C$68","v":0},{"$f":"IF($B58=0,0,F18*$C58/$B58)","v":0},0,null,{"$f":"Lowbidgee!C$69","v":0},{"$f":"IF($B58=0,0,J18*$C58/$B58)","v":0},0]
[]
["Fish River","Access  ($/KL)",null,null,null,"Usage < MAQ ($/KL)",null,null,null,"Usage > 200kl ($/KL)"]
["Raw water - major customers"]
["Raw water - minor customers *"]
["Filtered water - major customers"]
["Filtered water - minor customers *"]
["* Note : Access Fee for minor customers is an Annual Charge"]
[]
[]
[null,null,"Indicative Prices",null,null,null,"Indicative Prices",null,null,null,"Indicative Prices"]
["Tariffs ($ Real 2013-14)","2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17"]
[null,"High Security Entitlement ($/ML)",null,null,null,"General Security Entitlement ($/ML)",null,null,null,"Usage ($/ML delivered)"]
["Border ",{"$f":"B10/B$5","v":3.0493242007043113},3.0493242007043113,3.0493242007043118,null,{"$f":"F10/B$5","v":1.0275112629840721},1.0275112629840721,1.0275112629840721,null,{"$f":"J10/B$5","v":2.9855639559175939},2.9855639559175935,2.9855639559175939]
["Gwydir ",0,0,0,null,0,0,0,null,0,0,0]
["Namoi ",0,0,0,null,0,0,0,null,0,0,0]
["Peel",0,0,0,null,0,0,0,null,0,0,0]
["Lachlan",0,0,0,null,0,0,0,null,0,0,0]
["Macquarie",0,0,0,null,0,0,0,null,0,0,0]
["Murray ",2.836791325806908,2.8924146851364552,2.5864862088239455,null,1.6082596492763572,1.6397941522033448,1.4663543861049142,null,4.1926741087558774,4.2748834050059932,3.8227322756303588]
["Murrumbidgee",0.64855321272074828,0.64855321272074828,0.59215728117981359,null,0.28168013806050796,0.28168013806050796,0.25718621301176808,null,0.78420679123933612,0.78420679123933612,0.71601489634895898]
["Lowbidgee",null,null,null,null,{"$f":"F18/B$5","v":0},{"$f":"G18/C$5","v":0},{"$f":"H18/D$5","v":0},null,{"$f":"J18/B$5","v":0},{"$f":"K18/C$5","v":0},{"$f":"L18/D$5","v":0}]
[]
["Fish River","Access  ($/KL)",null,null,null,"Usage < MAQ ($/KL)",null,null,null,"Usage > 200kl ($/KL)"]
["Raw water - major customers"]
["Raw water - minor customers"]
["Filtered water - major customers"]
["Filtered water - minor customers"]
[]
[]
[null,"MDBA / BCR costs ($'000 Nominal)",null,null,null,"MDBA / BCR costs ($'000 Real 2013-14)"]
["Revenue Requirement  - MDBA / BCR costs","2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17"]
["Border ",{"$f":"Border!C$54","v":720.5078125},{"$f":"Border!D$54","v":738.88076171875014},{"$f":"Border!E$54","v":757.72222114257841},null,{"$f":"B50/B$5","v":700},{"$f":"C50/C$5","v":700},700]
["Gwydir ",{"$f":"Gwydir!C$54","v":0},{"$f":"Gwydir!D$54","v":0},{"$f":"Gwydir!E$54","v":0},null,{"$f":"B51/B$5","v":0},0,0]
["Namoi ",{"$f":"Namoi!C$54","v":0},{"$f":"Namoi!D$54","v":0},{"$f":"Namoi!E$54","v":0},null,0,0,0]
["Peel",{"$f":"Peel!C$54","v":0},{"$f":"Peel!D$54","v":0},{"$f":"Peel!E$54","v":0},null,0,0,0]
["Lachlan",{"$f":"Lachlan!C$54","v":0},{"$f":"Lachlan!D$54","v":0},{"$f":"Lachlan!E$54","v":0},null,0,0,0]
["Macquarie",{"$f":"Macquarie!C$54","v":0},{"$f":"Macquarie!D$54","v":0},{"$f":"Macquarie!E$54","v":0},null,0,0,0]
["Murray ",{"$f":"Murray!C$54","v":10498.828125},{"$f":"Murray!D$54","v":10977.657031250003},{"$f":"Murray!E$54","v":10066.880938037113},null,10200,10400,9300]
["Murrumbidgee",{"$f":"Murrumbidgee!C$54","v":2367.3828125},{"$f":"Murrumbidgee!D$54","v":2427.7510742187505},{"$f":"Murrumbidgee!E$54","v":2273.1666634277349},null,2300,2300,2100]
["Lowbidgee",{"$f":"Lowbidgee!C$54","v":0},{"$f":"Lowbidgee!D$54","v":0},{"$f":"Lowbidgee!E$54","v":0},null,0,0,0]
["Fish River"]

{"sheet":"SW Costs Tariffs","index":4,"n_rows":139,"n_cols":15,"rows_kept":139,"cut":false,"hidden":false,"merged":[[127,1,127,4],[6,2,6,3],[6,6,6,7],[6,10,6,11],[27,2,27,3],[27,6,27,7],[27,10,27,11],[8,1,8,3],[8,5,8,7],[8,9,8,11],[19,1,19,3],[19,5,19,7],[19,9,19,11],[40,1,40,3],[40,5,40,7],[40,9,40,11],[29,1,29,3],[29,5,29,7],[29,9,29,11],[88,2,88,4],[88,7,88,9],[88,12,88,14],[89,3,89,4],[89,8,89,9],[89,13,89,14],[91,1,91,4],[91,6,91,9],[91,11,91,14],[120,1,120,4],[120,6,120,9],[120,11,120,14],[102,1,102,4],[102,6,102,9],[102,11,102,14],[109,1,109,4],[109,6,109,9],[109,11,109,14]]}
["SW Costs Tariffs","Check",{"$f":"IF(D1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(Border!D1,Gwydir!D1,Namoi!D1,Peel!D1,Lachlan!D1,Macquarie!D1,Murray!D1,Murrumbidgee!D1,Lowbidgee!D1,'Fish River'!D1)","v":4.6870809455867857E-9}]
[]
[null,"2014-15","2015-16","2016-17",null,null,null,null,"Macro to Smooth Revenue Requirement"]
["CPI Forecast",{"$f":"Inputs!H86","v":2.9296875E-2},{"$f":"Inputs!C83","v":2.5499999999999998E-2},{"$f":"Inputs!D83","v":2.5499999999999998E-2}]
["CPI Index",{"$f":"1+B4","v":1.029296875},{"$f":"B5*(1+C4)","v":1.0555439453125002},{"$f":"C5*(1+D4)","v":1.0824603159179691}]
[]
[null,null,"Indicative Prices",null,null,null,"Indicative Prices",null,null,null,"Indicative Prices"]
["Tariffs ($ Nominal)","2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17"]
[null,"High Security Entitlement ($/ML)",null,null,null,"General Security Entitlement ($/ML)",null,null,null,"Usage ($/ML delivered)"]
["Border ",{"$f":"Border!C$40","v":6.6939256630675636},{"$f":"B10*(1+C$4)*(1+Border!D$24)","v":6.8996448952845126},{"$f":"C10*(1+D$4)*(1+Border!E$24)","v":7.1116863373128769},null,{"$f":"Border!C$41","v":2.2556092955912637},{"$f":"F10*(1+C$4)*(1+Border!D$24)","v":2.3249291888536883},{"$f":"G10*(1+D$4)*(1+Border!E$24)","v":2.3963794366998195},null,{"$f":"Border!C$42","v":6.5539581454245717},{"$f":"J10*(1+C$4)*(1+Border!D$24)","v":6.7553758643421276},{"$f":"K10*(1+D$4)*(1+Border!E$24)","v":6.9629835979948664}]
["Gwydir ",{"$f":"Gwydir!C$40","v":13.566205303673039},{"$f":"B11*(1+C$4)*(1+Gwydir!D$24)","v":14.106982020226342},{"$f":"C11*(1+D$4)*(1+Gwydir!E$24)","v":14.669315203796033},null,{"$f":"Gwydir!C$41","v":3.3361400698703694},{"$f":"F11*(1+C$4)*(1+Gwydir!D$24)","v":3.4691254429030143},{"$f":"G11*(1+D$4)*(1+Gwydir!E$24)","v":3.6074118851564489},null,{"$f":"Gwydir!C$42","v":12.148868380839179},{"$f":"J11*(1+C$4)*(1+Gwydir!D$24)","v":12.633147146032988},{"$f":"K11*(1+D$4)*(1+Gwydir!E$24)","v":13.136730254237666}]
["Namoi ",{"$f":"Namoi!C$40","v":16.510744920256986},{"$f":"B12*(1+C$4)*(1+Namoi!D$24)","v":17.045898067357065},{"$f":"C12*(1+D$4)*(1+Namoi!E$24)","v":17.598396821347343},null,{"$f":"Namoi!C$41","v":7.6770195745040644},{"$f":"F12*(1+C$4)*(1+Namoi!D$24)","v":7.9258503332304127},{"$f":"G12*(1+D$4)*(1+Namoi!E$24)","v":8.182746298237328},null,{"$f":"Namoi!C$42","v":19.934444130084483},{"$f":"J12*(1+C$4)*(1+Namoi!D$24)","v":20.580567643192413},{"$f":"K12*(1+D$4)*(1+Namoi!E$24)","v":21.247633580953206}]
[{"$f":"\"Peel Valley (\" &Peel!H36*100& \"% price cap)\"","v":"Peel Valley (10% price cap)"},{"$f":"Peel!H$40","v":28.392070059026345},{"$f":"Peel!I$40","v":32.027674630084675},{"$f":"Peel!J$40","v":36.12881836646703},null,{"$f":"Peel!H$41","v":3.1221133014491054},{"$f":"Peel!I$41","v":3.5218999096996635},{"$f":"Peel!J$41","v":3.972879193136706},null,{"$f":"Peel!H$42","v":46.899326524656054},{"$f":"Peel!I$42","v":52.904785286138264},{"$f":"Peel!J$42","v":59.679243042028276}]
["Lachlan",{"$f":"Lachlan!C$40","v":12.838614189054658},{"$f":"B14*(1+C$4)*(1+Lachlan!D$24)","v":13.431388850618669},{"$f":"C14*(1+D$4)*(1+Lachlan!E$24)","v":14.051532649865148},null,{"$f":"Lachlan!C$41","v":3.1854372372595727},{"$f":"F14*(1+C$4)*(1+Lachlan!D$24)","v":3.3325128057317319},{"$f":"G14*(1+D$4)*(1+Lachlan!E$24)","v":3.4863790347098935},null,{"$f":"Lachlan!C$42","v":18.417515158343878},{"$f":"J14*(1+C$4)*(1+Lachlan!D$24)","v":19.267874562721403},{"$f":"K14*(1+D$4)*(1+Lachlan!E$24)","v":20.157496110248879}]
["Macquarie",{"$f":"Macquarie!C$40","v":12.548565960523746},{"$f":"B15*(1+C$4)*(1+Macquarie!D$24)","v":13.110164739643821},{"$f":"C15*(1+D$4)*(1+Macquarie!E$24)","v":13.696897322076667},null,{"$f":"Macquarie!C$41","v":3.4041322552484639},{"$f":"F15*(1+C$4)*(1+Macquarie!D$24)","v":3.5564808602225266},{"$f":"G15*(1+D$4)*(1+Macquarie!E$24)","v":3.7156476777973948},null,{"$f":"Macquarie!C$42","v":14.401344056593187},{"$f":"J15*(1+C$4)*(1+Macquarie!D$24)","v":15.045862104736221},{"$f":"K15*(1+D$4)*(1+Macquarie!E$24)","v":15.719224926863523}]
["Murray ",{"$f":"Murray!C$40","v":1.7339727619428122},{"$f":"B16*(1+C$4)*(1+Murray!D$24)","v":1.7468115635301782},{"$f":"C16*(1+D$4)*(1+Murray!E$24)","v":1.7597454270642006},null,{"$f":"Murray!C$41","v":0.98303967606206677},{"$f":"F16*(1+C$4)*(1+Murray!D$24)","v":0.99031836672577034},{"$f":"G16*(1+D$4)*(1+Murray!E$24)","v":0.99765095077655452},null,{"$f":"Murray!C$42","v":2.5627484962143439},{"$f":"J16*(1+C$4)*(1+Murray!D$24)","v":2.5817237766705086},{"$f":"K16*(1+D$4)*(1+Murray!E$24)","v":2.6008395552164871}]
["Murrumbidgee",{"$f":"Murrumbidgee!C$40","v":2.898350098683951},{"$f":"B17*(1+C$4)*(1+Murrumbidgee!D$24)","v":2.9631204203350139},{"$f":"C17*(1+D$4)*(1+Murrumbidgee!E$24)","v":3.0293381842977172},null,{"$f":"Murrumbidgee!C$41","v":1.2588136793279721},{"$f":"F17*(1+C$4)*(1+Murrumbidgee!D$24)","v":1.286944776032215},{"$f":"G17*(1+D$4)*(1+Murrumbidgee!E$24)","v":1.3157045270121297},null,{"$f":"Murrumbidgee!C$42","v":3.5045787858209452},{"$f":"J17*(1+C$4)*(1+Murrumbidgee!D$24)","v":3.5828966865163041},{"$f":"K17*(1+D$4)*(1+Murrumbidgee!E$24)","v":3.6629647814416075}]
["Lowbidgee",null,null,null,null,{"$f":"Lowbidgee!C$41","v":0.73136738383941879},{"$f":"F18*(1+C$4)*(1+Lowbidgee!D$24)","v":0.7921168913237161},{"$f":"G18*(1+D$4)*(1+Lowbidgee!E$24)","v":0.85791243003818773}]
[]
["Fish River","Access  ($/KL)",null,null,null,"Usage < MAQ ($/KL)",null,null,null,"Usage > 200kl ($/KL)"]
["Raw water - major customers",{"$f":"'Fish River'!C62","v":0.33125394427935673},{"$f":"B21*(1+C$4)*(1+'Fish River'!D$24)","v":0.34343089184569497},{"$f":"C21*(1+D$4)*(1+'Fish River'!E$24)","v":0.35605546593722354},null,{"$f":"'Fish River'!C84","v":0.37215646952047915},{"$f":"F21*(1+C$4)*(1+'Fish River'!D$24)","v":0.38583700040648328},{"$f":"G21*(1+D$4)*(1+'Fish River'!E$24)","v":0.40002042977914831}]
["Raw water - minor customers *",{"$f":"'Fish River'!C75","v":66.250788855871349},{"$f":"B22*(1+C$4)*(1+'Fish River'!D$24)","v":68.686178369139},{"$f":"C22*(1+D$4)*(1+'Fish River'!E$24)","v":71.211093187444718},null,{"$f":"'Fish River'!C97","v":0.37215646952047915},{"$f":"F22*(1+C$4)*(1+'Fish River'!D$24)","v":0.38583700040648328},{"$f":"G22*(1+D$4)*(1+'Fish River'!E$24)","v":0.40002042977914831},null,{"$f":"'Fish River'!C111","v":0.70341041379983582},{"$f":"J22*(1+C$4)*(1+'Fish River'!D$24)","v":0.72926789225217814},{"$f":"K22*(1+D$4)*(1+'Fish River'!E$24)","v":0.75607589571637179}]
["Filtered water - major customers",{"$f":"'Fish River'!C146","v":0.64111232214230041},{"$f":"B23*(1+C$4)*(1+'Fish River'!D$24)","v":0.6646797128577342},{"$f":"C23*(1+D$4)*(1+'Fish River'!E$24)","v":0.6891134445963415},null,{"$f":"'Fish River'!C159","v":0.64429979922679725},{"$f":"F23*(1+C$4)*(1+'Fish River'!D$24)","v":0.6679843621057544},{"$f":"G23*(1+D$4)*(1+'Fish River'!E$24)","v":0.69253957327521298}]
["Filtered water - minor customers *",{"$f":"'Fish River'!C150","v":128.22246442846009},{"$f":"B24*(1+C$4)*(1+'Fish River'!D$24)","v":132.93594257154683},{"$f":"C24*(1+D$4)*(1+'Fish River'!E$24)","v":137.82268891926827},null,{"$f":"'Fish River'!C163","v":0.64429979922679725},{"$f":"F24*(1+C$4)*(1+'Fish River'!D$24)","v":0.6679843621057544},{"$f":"G24*(1+D$4)*(1+'Fish River'!E$24)","v":0.69253957327521298},null,{"$f":"'Fish River'!C176","v":1.2854121213690977},{"$f":"J24*(1+C$4)*(1+'Fish River'!D$24)","v":1.3326640749634886},{"$f":"K24*(1+D$4)*(1+'Fish River'!E$24)","v":1.3816530178715547}]
["* Note : Access Fee for minor customers is an Annual Charge"]
[]
[]
[null,null,"Indicative Prices",null,null,null,"Indicative Prices",null,null,null,"Indicative Prices"]
["Tariffs ($ Real 2013-14)","2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17"]
[null,"High Security Entitlement ($/ML)",null,null,null,"General Security Entitlement ($/ML)",null,null,null,"Usage ($/ML delivered)"]
["Border ",{"$f":"B10/B$5","v":6.5033964696216175},6.536577587247522,6.5699279989603001,null,{"$f":"F10/B$5","v":2.1914078924909433},{"$f":"G10/C$5","v":2.2025887213680893},{"$f":"H10/D$5","v":2.2138265961903603},null,{"$f":"J10/B$5","v":6.3674128471677056},{"$f":"K10/C$5","v":6.3999001598575394},{"$f":"L10/D$5","v":6.4325532267573076}]
["Gwydir ",13.180070427856919,13.364656282548127,13.551827247686097,null,3.2411835213920854,3.2865760429102351,3.3326042831392124,null,11.803075163168234,11.96837630695979,12.135992480331439]
["Namoi ",16.040799618921397,16.148923162370586,16.257775516161264,null,7.4585085809223548,7.5087829061289497,7.5593961070970401,null,19.367050084636158,19.497594330001498,19.629018513195444]
[{"$f":"A13","v":"Peel Valley (10% price cap)"},27.583946622811172,30.342341285092292,33.376575413601529,null,3.033248596474273,3.3365734561217,3.6702308017338701,null,45.564431082777801,50.12087419105557,55.132961610161125]
["Lachlan",12.473188737753292,12.724613608239897,12.981106506383925,null,3.0947701432199266,3.1571521209807343,3.2207915462963705,null,17.893297459339784,18.253976680257527,18.621926193344581]
["Macquarie",12.19139615140068,12.420292682141696,12.65348680284982,null,3.307240445326781,3.3693347169639716,3.4325948241773454,null,13.991438628037404,14.25413140926293,14.521756313563328]
["Murray ",1.684618698509905,1.6548923152726001,1.6256904767653002,null,0.95505941962766261,0.93820666692619847,0.92165129391418577,null,2.4898049906294952,2.4458704804622546,2.40271122827341]
["Murrumbidgee",2.8158543653248254,2.8071975908665405,2.7985674299096304,null,1.2229840679619008,1.2192242509156805,1.2154759926661702,null,3.4048279664901782,3.3943605118738716,3.383925237328695]
["Lowbidgee",null,null,null,null,0.71055047538099136,0.75043478278794451,0.79255785863211448,null,{"$f":"J18/B$5","v":0},{"$f":"K18/C$5","v":0},{"$f":"L18/D$5","v":0}]
[]
["Fish River","Access  ($/KL)",null,null,null,"Usage < MAQ ($/KL)",null,null,null,"Usage > 200kl ($/KL)"]
["Raw water - major customers",{"$f":"B21/B$5","v":0.32182546389189876},{"$f":"C21/C$5","v":0.32535916043175273},{"$f":"D21/D$5","v":0.32893165754097364},null,{"$f":"F21/B$5","v":0.36156378063469702},{"$f":"G21/C$5","v":0.36553381043008482},{"$f":"H21/D$5","v":0.36954743180577032}]
["Raw water - minor customers",{"$f":"B22/B$5","v":64.365092778379761},65.071832086350554,65.786331508194735,null,{"$f":"F22/B$5","v":0.36156378063469702},0.36553381043008482,0.36954743180577032,null,{"$f":"J22/B$5","v":0.68338924452659566},0.69089297086183743,0.69847908934674396]
["Filtered water - major customers",{"$f":"B23/B$5","v":0.622864343333696},0.62970349629635902,0.63661774428372098,null,{"$f":"F23/B$5","v":0.62596109526398513},0.63283425107231661,0.63978287526218647]
["Filtered water - minor customers",{"$f":"B24/B$5","v":124.57286866673921},125.94069925927181,127.32354885674418,null,{"$f":"F24/B$5","v":0.62596109526398513},0.63283425107231661,0.63978287526218647,null,{"$f":"J24/B$5","v":1.2488254385976811},1.2625377473686756,1.2764006195459077]
[]
[]
[null,"Smoothed Revenue ($'000 Nominal)",null,null,null,"Smoothed Revenue ($'000 Real 2013-14)"]
["Smoothed Revenue","2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17"]
["Border ",{"$f":"Border!C$22","v":1536.6512891823747},{"$f":"Border!D$22","v":1583.8760029463633},{"$f":"Border!E$22","v":1632.5520372576941},null,{"$f":"B50/B$5","v":1492.9135864542236},{"$f":"C50/C$5","v":1500.5306126571995},{"$f":"D50/D$5","v":1508.1865018517797}]
["Gwydir ",{"$f":"Gwydir!C$22","v":4978.5402637404177},{"$f":"Gwydir!D$22","v":5176.9950708724482},{"$f":"Gwydir!E$22","v":5383.3606928994895},null,{"$f":"B51/B$5","v":4836.83608166052},4904.5755923878351,4973.2637896606739]
["Namoi ",{"$f":"Namoi!C$22","v":5281.3309754937627},{"$f":"Namoi!D$22","v":5452.5116766712736},{"$f":"Namoi!E$22","v":5629.240758094521},null,5131.0084619597847,5165.5941951872255,5200.4130547000259]
[{"$f":"A34","v":"Peel Valley (10% price cap)"},{"$f":"Peel!H$49","v":1112.4026970145073},{"$f":"Peel!I$49","v":1254.845862367215},{"$f":"Peel!J$49","v":1415.5288750433369},null,1080.7403811602044,1188.8144192762247,1307.695861203847]
["Lachlan",{"$f":"Lachlan!C$22","v":6989.3604095744022},{"$f":"Lachlan!D$22","v":7312.0678054292066},{"$f":"Lachlan!E$22","v":7649.6750000119073},null,6790.4222574992291,6927.2983260440424,7066.9334362846184]
["Macquarie",{"$f":"Macquarie!C$22","v":6712.722532676532},{"$f":"Macquarie!D$22","v":7013.143854983995},{"$f":"Macquarie!E$22","v":7327.0102393296438},null,6521.6583239665733,6644.1041001923531,6768.848826680588]
["Murray ",{"$f":"Murray!C$22","v":6234.69270048824},{"$f":"Murray!D$22","v":6280.856045320762},{"$f":"Murray!E$22","v":6327.3611959981745},null,6057.2346539847795,5950.3501234723835,5845.3516521132897]
["Murrumbidgee",{"$f":"Murrumbidgee!C$22","v":10278.578682861904},{"$f":"Murrumbidgee!D$22","v":10508.277244021587},{"$f":"Murrumbidgee!E$22","v":10743.108949619496},null,9986.0195173155498,9955.3195209798178,9924.7139055706775]
["Lowbidgee",{"$f":"Lowbidgee!C$22","v":546.3314357280459},{"$f":"Lowbidgee!D$22","v":591.71131781881593},{"$f":"Lowbidgee!E$22","v":640.86058523852626},null,530.78120510960059,560.57478274259461,592.04072039818959]
["Fish River",{"$f":"'Fish River'!C$22","v":9721.3998447510858},{"$f":"'Fish River'!D$22","v":10078.760045966115},{"$f":"'Fish River'!E$22","v":10449.256864895864},null,9444.6996594166139,9548.4040155071307,9653.2470624888283]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"Border!$A$12","v":"Border "},null,null,{"$f":"Gwydir!$A$12","v":"Gwydir "},null,null,{"$f":"Namoi!$A$12","v":"Namoi "},null,null,{"$f":"Peel!$A$12","v":"Peel"},null,null,{"$f":"Lachlan!$A$12","v":"Lachlan"}]
[null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17"]
["Real Growth in Smoothed Revenue",5.1021212962946748E-3,{"$f":"B69","v":5.1021212962946748E-3},null,1.4004921726448164E-2,{"$f":"E69","v":1.4004921726448164E-2},null,6.7405332662873437E-3,{"$f":"H69","v":6.7405332662873437E-3},null,3.0976574370142158E-3,{"$f":"K69","v":3.0976574370142158E-3},null,2.0157224890344598E-2,{"$f":"N69","v":2.0157224890344598E-2}]
["Difference in NPVs",{"$f":"Border!$B$26","v":-9.0949470177292824E-12},{"$f":"B70*10^6","v":-9.0949470177292824E-6},null,{"$f":"Gwydir!$B$26","v":-5.6752469390630722E-10},{"$f":"E70*10^6","v":-5.6752469390630722E-4},null,{"$f":"Namoi!$B$26","v":0},{"$f":"H70*10^6","v":0},null,{"$f":"Peel!$B$26","v":-1.7280399333685637E-11},{"$f":"K70*10^6","v":-1.7280399333685637E-5},null,{"$f":"Lachlan!$B$26","v":0},{"$f":"N70*10^6","v":0}]
["Difference between final year revenue and requirement",{"$f":"Border!$E$26","v":1.0339517413965771E-2},null,null,{"$f":"Gwydir!$E$26","v":-8.0187913614737649E-4},null,null,{"$f":"Namoi!$E$26","v":1.298672333161166E-3},null,null,{"$f":"Peel!$E$26","v":3.5401341809104814E-3},null,null,{"$f":"Lachlan!$E$26","v":4.5252038641534487E-3}]
["2014-15 Average Real Price Increase \\ (Decrease)",{"$f":"Border!$E$43","v":4.9640384216204092E-2},null,null,{"$f":"Gwydir!$E$43","v":-0.12203332129292388},null,null,{"$f":"Namoi!$E$43","v":-8.0156329398662574E-2},null,null,{"$f":"Peel!$E$43","v":0},null,null,{"$f":"Lachlan!$E$43","v":-0.11301296353555945}]
[]
[]
[null,{"$f":"Macquarie!$A$12","v":"Macquarie"},null,null,{"$f":"Murray!$A$12","v":"Murray "},null,null,{"$f":"Murrumbidgee!$A$12","v":"Murrumbidgee"},null,null,{"$f":"Lowbidgee!$A$12","v":"Lowbidgee"},null,null,{"$f":"'Fish River'!$A$12","v":"Fish River"}]
[null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17",null,"2015-16","2016-17"]
["Real Growth in Smoothed Revenue",1.8775251652758333E-2,{"$f":"B77","v":1.8775251652758333E-2},null,-1.7645763556820633E-2,{"$f":"E77","v":-1.7645763556820633E-2},null,-3.0742976500795802E-3,{"$f":"H77","v":-3.0742976500795802E-3},null,5.6131561076737828E-2,{"$f":"K77","v":5.6131561076737828E-2},null,1.0980164518743507E-2,{"$f":"N77","v":1.0980164518743507E-2}]
["Difference in NPVs",{"$f":"Macquarie!$B$26","v":0},{"$f":"B78*10^6","v":0},null,{"$f":"Murray!$B$26","v":-7.8216544352471828E-10},{"$f":"E78*10^6","v":-7.8216544352471828E-4},null,{"$f":"Murrumbidgee!$B$26","v":0},{"$f":"H78*10^6","v":0},null,{"$f":"Lowbidgee!$B$26","v":0},{"$f":"K78*10^6","v":0},null,{"$f":"'Fish River'!$B$26","v":5.1295501179993153E-10},{"$f":"N78*10^6","v":5.1295501179993153E-4}]
["Difference between final year revenue and requirement",{"$f":"Macquarie!$E$26","v":-6.986087051758294E-3},null,null,{"$f":"Murray!$E$26","v":-7.676852314786986E-3},null,null,{"$f":"Murrumbidgee!$E$26","v":2.8192900354169215E-3},null,null,{"$f":"Lowbidgee!$E$26","v":-2.5365237103566529E-2},null,null,{"$f":"'Fish River'!$E$26","v":1.3066274584847548E-3}]
["2014-15 Average Real Price Increase \\ (Decrease)",{"$f":"Macquarie!$E$43","v":-7.273603453245614E-2},null,null,{"$f":"Murray!$E$43","v":-0.13443206577129052},null,null,{"$f":"Murrumbidgee!$E$43","v":-2.2393951303972925E-2},null,null,{"$f":"Lowbidgee!$E$43","v":0},null,null,{"$f":"'Fish River'!E196","v":-0.13166553349082355}]
[]
[]
[]
[]
[]
[]
["State Water bulk water charges - ACCC Final Decision",null,null,null,null,"Comparison of proposed prices against 2013-14"]
["Prices ($ Real 2013-14)"]
[null,"IPART-set","ACCCFinal Decision",null,null,null,{"$f":"$B89","v":"IPART-set"},{"$f":"$C89","v":"ACCCFinal Decision"},null,null,null,{"$f":"$B89","v":"IPART-set"},{"$f":"$C89","v":"ACCCFinal Decision"}]
[null,null,null,"Indicative Prices",null,null,null,null,{"$f":"$D90","v":"Indicative Prices"},null,null,null,null,{"$f":"$D90","v":"Indicative Prices"}]
[null,"2013-14","2014-15","2015-16","2016-17",null,"2013-14","2014-15","2015-16","2016-17",null,"2013-14","2014-15","2015-16","2016-17"]
[null,"High Security Entitlement ($/ML)",null,null,null,null,"General Security Entitlement ($/ML)",null,null,null,null,"Usage ($/ML delivered)"]
["Border ",{"$f":"Inputs!G5","v":7.3779117753689203},{"$f":"B31","v":6.5033964696216175},6.536577587247522,6.5699279989603001,null,{"$f":"Inputs!H5","v":2.0683927335313741},{"$f":"F31","v":2.1914078924909433},{"$f":"G31","v":2.2025887213680893},{"$f":"H31","v":2.2138265961903603},null,{"$f":"Inputs!I5","v":6.0763063791902985},{"$f":"J31","v":6.3674128471677056},6.3999001598575394,6.4325532267573076]
["Gwydir ",{"$f":"Inputs!G6","v":14.389781637543789},13.180070427856919,13.364656282548127,13.551827247686097,null,{"$f":"Inputs!H6","v":4.0152930205105006},3.2411835213920854,3.2865760429102351,3.3326042831392124,null,{"$f":"Inputs!I6","v":12.827179920202266},11.803075163168234,11.96837630695979,12.135992480331439]
["Namoi ",{"$f":"Inputs!G7","v":16.019857330139448},16.040799618921397,16.148923162370586,16.257775516161264,null,{"$f":"Inputs!H7","v":8.9778361979634766},7.4585085809223548,7.5087829061289497,7.5593961070970401,null,{"$f":"Inputs!I7","v":19.733461742058335},19.367050084636158,19.497594330001498,19.629018513195444]
["Peel",{"$f":"Inputs!G8","v":25.076315111646519},27.583946622811172,30.342341285092292,33.376575413601529,null,{"$f":"Inputs!H8","v":2.7574987240675211},3.033248596474273,3.3365734561217,3.6702308017338701,null,{"$f":"Inputs!I8","v":41.422210075252544},45.564431082777801,50.12087419105557,55.132961610161125]
["Lachlan",{"$f":"Inputs!G9","v":12.36},12.473188737753292,12.724613608239897,12.981106506383925,null,{"$f":"Inputs!H9","v":4.42},3.0947701432199266,3.1571521209807343,3.2207915462963705,null,{"$f":"Inputs!I9","v":18.04},17.893297459339784,18.253976680257527,18.621926193344581]
["Macquarie",{"$f":"Inputs!G10","v":11.35284249530522},12.19139615140068,12.420292682141696,12.65348680284982,null,{"$f":"Inputs!H10","v":4.2150658651571051},3.307240445326781,3.3693347169639716,3.4325948241773454,null,{"$f":"Inputs!I10","v":13.897787923324605},13.991438628037404,14.25413140926293,14.521756313563328]
["Murray ",{"$f":"Inputs!G11","v":1.7017878516072777},1.684618698509905,1.6548923152726001,1.6256904767653002,null,{"$f":"Inputs!H11","v":1.2627916223710054},0.95505941962766261,0.93820666692619847,0.92165129391418577,null,{"$f":"Inputs!I11","v":2.6935941472892257},2.4898049906294952,2.4458704804622546,2.40271122827341]
["Murrumbidgee",{"$f":"Inputs!G12","v":2.6360825366697194},2.8158543653248254,2.8071975908665405,2.7985674299096304,null,{"$f":"Inputs!H12","v":1.4065004138606891},1.2229840679619008,1.2192242509156805,1.2154759926661702,null,{"$f":"Inputs!I12","v":3.3437557008763554},3.4048279664901782,3.3943605118738716,3.383925237328695]
["Lowbidgee",null,null,null,null,null,null,0.71055047538099136,0.75043478278794451,0.79255785863211448,null,null,{"$f":"M100","v":3.4048279664901782},{"$f":"N100","v":3.3943605118738716},3.383925237328695]
[]
["Fish River","Access ",null,null,null,null,"Usage < MAQ",null,null,null,null,"Usage > MAQ"]
["Raw water - major customers",{"$f":"Inputs!G17","v":0.38},{"$f":"B42","v":0.32182546389189876},0.32535916043175273,0.32893165754097364,null,{"$f":"Inputs!H17","v":0.43},{"$f":"F42","v":0.36156378063469702},0.36553381043008482,0.36954743180577032,null,{"$f":"Inputs!I17","v":0.81}]
["Raw water - minor customers",{"$f":"Inputs!G18*'Fish River'!C36","v":94},64.365092778379761,65.071832086350554,65.786331508194735,null,{"$f":"Inputs!H18","v":0.85},0.36156378063469702,0.36553381043008482,0.36954743180577032,null,{"$f":"Inputs!I18","v":1.33},{"$f":"J43","v":0.68338924452659566},{"$f":"K43","v":0.69089297086183743},{"$f":"L43","v":0.69847908934674396}]
["Filtered water - major customers",{"$f":"Inputs!G19","v":0.56999999999999995},0.622864343333696,0.62970349629635902,0.63661774428372098,null,{"$f":"Inputs!H19","v":0.61},0.62596109526398513,0.63283425107231661,0.63978287526218647,null,{"$f":"Inputs!I19","v":1.18}]
["Filtered water - minor customers",{"$f":"Inputs!G20*'Fish River'!C49","v":134.66272469999996},124.57286866673921,125.94069925927181,127.32354885674418,null,{"$f":"Inputs!H20","v":1.04},0.62596109526398513,0.63283425107231661,0.63978287526218647,null,{"$f":"Inputs!I20","v":1.71},{"$f":"J45","v":1.2488254385976811},{"$f":"K45","v":1.2625377473686756},{"$f":"L45","v":1.2764006195459077}]
[]
[]
["Positive change implies real increase in price","% Real change in prices over 2013-14",null,null,null,null,{"$f":"$B110","v":"% Real change in prices over 2013-14"},null,null,null,null,{"$f":"$B110","v":"% Real change in prices over 2013-14"}]
["Border ",null,{"$f":"C93/$B93-1","v":-0.11853154827181078},{"$f":"D93/$B93-1","v":-0.11403418931223652},-0.10951388428173747,null,null,{"$f":"H93/$G93-1","v":5.9473791879719462E-2},{"$f":"I93/$G93-1","v":6.4879355676134898E-2},7.031249931471506E-2,null,null,{"$f":"M93/$L93-1","v":4.7908457837868124E-2},{"$f":"N93/$L93-1","v":5.3255013897169912E-2},5.8628848734003647E-2]
["Gwydir ",null,{"$f":"C94/$B94-1","v":-8.4067377821124278E-2},-7.123981314080885E-2,-5.8232599421204623E-2,null,null,{"$f":"H94/$G94-1","v":-0.19279028832122336},-0.18148537949233334,-0.1700221463001701,null,null,{"$f":"M94/$L94-1","v":-7.9838652252870457E-2},-6.695186460196878E-2,-5.3884598498710967E-2]
["Namoi ",null,1.3072706173573589E-3,8.0566155847290322E-3,1.4851454736378944E-2,null,null,-0.16923093533225353,-0.16363110881525833,-0.15799353648133996,null,null,-1.8568037489399836E-2,-1.1952662697499616E-2,-5.2926967517457069E-3]
["Peel",null,0.10000000000000009,0.21000000000000019,0.33100000000000041,null,null,9.9999999999999867E-2,0.20999999999999974,0.33099999999999974,null,null,0.10000000000000009,0.20999999999999974,0.33099999999999974]
["Lachlan",null,9.1576648667712757E-3,2.9499482867305638E-2,5.0251335467955238E-2,null,null,-0.29982575945250534,-0.28571218982336333,-0.27131412979720126,null,null,-8.1320698813865944E-3,1.1861235047534668E-2,3.2257549520209761E-2]
["Macquarie",null,7.3862881163217819E-2,9.4024926997613445E-2,0.11456552031638423,null,null,-0.21537633073178264,-0.20064482388856131,-0.18563672929713404,null,null,6.7385331557423545E-3,2.5640302464270182E-2,4.4896957248248048E-2]
["Murray ",null,-1.0088891562574642E-2,-2.7556628924331861E-2,-4.4716134722730727E-2,null,null,-0.24369198947134907,-0.2570376218012671,-0.27014776025857523,null,null,-7.5656964455769748E-2,-9.1967703106377363E-2,-0.10799062631931911]
["Murrumbidgee",null,6.8196585711697733E-2,6.4912631458420966E-2,6.1638773057988372E-2,null,null,-0.13047727827897049,-0.13315044993904845,-0.13581540347377352,null,null,1.8264571660488338E-2,1.5134123280672984E-2,1.201329883095581E-2]
["Lowbidgee"]
[]
["Fish River","Access ",null,null,null,null,"Usage < MAQ",null,null,null,null,"Usage > MAQ"]
["Raw water - major customers",null,{"$f":"C104/$B104-1","v":-0.1530908844950033},-0.14379168307433499,-0.13439037489217465,null,null,{"$f":"H104/$G104-1","v":-0.15915399852396039},{"$f":"I104/$G104-1","v":-0.14992137109282599},-0.14058736789355741]
["Raw water - minor customers",null,{"$f":"C105/$B105-1","v":-0.31526497044276847},-0.30774646716648346,-0.30014540948729007,null,null,{"$f":"H105/$G105-1","v":-0.57463084631212114},-0.56996022302342964,-0.56523831552262316,null,null,{"$f":"M105/$L105-1","v":-0.48617350035594309},-0.48053160085576141,-0.47482775237086927]
["Filtered water - major customers",null,{"$f":"C106/$B106-1","v":9.2744461988940374E-2},0.10474297595852478,0.11687323558547558,null,null,{"$f":"H106/$G106-1","v":2.6165729940959226E-2},3.7433198479207563E-2,4.8824385675715565E-2]
["Filtered water - minor customers",null,{"$f":"C107/$B107-1","v":-7.4926866775782308E-2},-6.4769411581111047E-2,-5.450042585731063E-2,null,null,{"$f":"H107/$G107-1","v":-0.39811433147693742},-0.39150552781508019,-0.38482415840174378,null,null,{"$f":"M107/$L107-1","v":-0.26969272596626837},-0.26167383194814287,-0.25356688915443992]
[]
[]
["Positive change implies real increase in price","% Average real change in prices over 2013-14"]
[null,null,"2014-15","2015-16","2016-17"]
["Border ",{"$f":"SUMPRODUCT(Border!B$40:B$42,Border!C$34:C$36)/10^3","v":1422.3095918408515},{"$f":"F50/$B130-1","v":4.9640384216204092E-2},{"$f":"G50/$B130-1","v":5.4995776773964611E-2},{"$f":"H50/$B130-1","v":6.037849319414379E-2}]
["Gwydir ",{"$f":"SUMPRODUCT(Gwydir!B$40:B$42,Gwydir!C$34:C$36)/10^3","v":5509.1340012851178},-0.12203332129292388,-0.1097374666792017,-9.7269409584054611E-2]
["Namoi ",{"$f":"SUMPRODUCT(Namoi!B$40:B$42,Namoi!C$34:C$36)/10^3","v":5578.1309650208768},-8.0156329398662463E-2,-7.3956092537190377E-2,-6.7714062772894601E-2]
["Peel",{"$f":"SUMPRODUCT(Peel!B$40:B$42,Peel!C$34:C$36)/10^3","v":982.4912556001857},0.10000000000000009,0.20999999999999996,0.33099999999999996]
["Lachlan",{"$f":"SUMPRODUCT(Lachlan!B$40:B$42,Lachlan!C$34:C$36)/10^3","v":7655.6048491600004},-0.11301296353555945,-9.5133766366725436E-2,-7.6894174199700682E-2]
["Macquarie",{"$f":"SUMPRODUCT(Macquarie!B$40:B$42,Macquarie!C$34:C$36)/10^3","v":7033.2273946159785},-7.2736034532456251E-2,-5.5326420232268303E-2,-3.7589936042417116E-2]
["Murray ",{"$f":"SUMPRODUCT(Murray!B$40:B$42,Murray!C$34:C$36)/10^3","v":6997.9887360109542},-0.13443206577129052,-0.14970567288105607,-0.16470976553110306]
["Murrumbidgee",{"$f":"SUMPRODUCT(Murrumbidgee!B$40:B$42,Murrumbidgee!C$34:C$36)/10^3","v":10214.76854673243},-2.2393951303972925E-2,-2.5399403282182709E-2,-2.839561560643844E-2]
["Lowbidgee"]
["Fish River",{"$f":"'Fish River'!B196/10^3","v":10876.799233117626},-0.13166553349082355,-0.12213107819125724,-0.11249193300390548]

{"sheet":"Border","index":5,"n_rows":98,"n_cols":6,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[null,"Check",{"$f":"IF(D1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(ABS(B26),C50,C77,C98)","v":9.5496943686157465E-12}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!H86","v":2.9296875E-2},{"$f":"Inputs!C83","v":2.5499999999999998E-2},{"$f":"Inputs!D83","v":2.5499999999999998E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.029296875},{"$f":"C5*(1+D4)","v":1.0555439453125002},{"$f":"D5*(1+E4)","v":1.0824603159179691}]
["Real Vanilla WACC",null,{"$f":"Inputs!B$85","v":4.2572208678693269E-2},{"$f":"Inputs!C$85","v":4.2572208678693269E-2},{"$f":"Inputs!D$85","v":4.2572208678693269E-2}]
["Nominal Vanilla WACC",null,{"$f":"(1+C6)*(1+C4)-1","v":7.311631635482696E-2},{"$f":"(1+D6)*(1+D4)-1","v":6.9157799999999936E-2},6.9157799999999936E-2]
["Accumulated Discount rate",null,{"$f":"1/(1+C7)","v":0.93186543225510798},{"$f":"C8/(1+D7)","v":0.87158830273240118},{"$f":"D8/(1+E7)","v":0.81521016143024094}]
[]
["Target Variable / Fixed ratio (%)",null,{"$f":"Inputs!B$36","v":0.6},{"$f":"Inputs!C$36","v":0.6},{"$f":"Inputs!D$36","v":0.6}]
[]
["Border "]
["($'000 Nominal)"]
["Revenue Requirement  - State Water Costs",null,"2014-15","2015-16","2016-17"]
["PTRM Building block requirement (user share) - Unsmoothed",null,{"$f":"Inputs!G$90*C$5","v":1536.6512891823747},{"$f":"Inputs!H$90*D$5","v":1599.5023747583102},{"$f":"Inputs!I$90*E$5","v":1615.8449799492398}]
["ICD Rebates",null,{"$f":"Inputs!B$104*C$5","v":0},{"$f":"Inputs!C$104*D$5","v":0},{"$f":"Inputs!D$104*E$5","v":0}]
[]
["Total Revenue Requirement (user share) - Unsmoothed",null,{"$f":"SUM(C15:C17)","v":1536.6512891823747},{"$f":"SUM(D15:D17)","v":1599.5023747583102},{"$f":"SUM(E15:E17)","v":1615.8449799492398}]
["NPV",{"$f":"SUMPRODUCT(C$8:E$8,C18:E18)","v":4143.3130248020079}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":1.5018364377909599E-2},{"$f":"(E18/(1+E$4))/D18-1","v":-1.4902675779929875E-2}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":1536.6512891823747},{"$f":"C22*(1+D$4)*(1+D24)","v":1583.8760029463633},{"$f":"D22*(1+E$4)*(1+E24)","v":1632.5520372576941}]
["NPV",{"$f":"SUMPRODUCT(C$8:E$8,C22:E22)","v":4143.313024802017}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Costs Tariffs'!B69","v":5.1021212962946748E-3},{"$f":"'SW Costs Tariffs'!C69","v":5.1021212962946748E-3}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":-9.0949470177292824E-12},null,null,{"$f":"E22/E18-1","v":1.0339517413965771E-2},"Difference between final year revenue and requirement"]
[]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C22","v":921.9907735094248}]
["High security premium (times)",null,{"$f":"Inputs!D$24","v":2.967679587130307}]
[]
["Forecast sales quantities",null,"2014-15"]
["High Security Entitlement (ML)",null,{"$f":"Inputs!B$48","v":3122}]
["General Security Entitlement (ML)",null,{"$f":"Inputs!C$48","v":263238}]
["Forecast water volumes (ML)",null,{"$f":"Inputs!D$48","v":140676.93950000001}]
[]
[null,null,null,null,"Real Price Increase \\ (Decrease)"]
["Tariffs ($ Nominal)","2013-14","2014-15",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},{"$f":"Inputs!G$5","v":7.3779117753689203},{"$f":"C41*C31","v":6.6939256630675636},null,{"$f":"C40/(1+C$4)/B40-1","v":-0.11853154827181078}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!H$5","v":2.0683927335313741},{"$f":"(C22-C30)*10^3/(C35+C34*C31)","v":2.2556092955912637},null,{"$f":"C41/(1+C$4)/B41-1","v":5.9473791879719462E-2}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!I$5","v":6.0763063791902985},{"$f":"C30*10^3/C36","v":6.5539581454245717},null,4.7908457837868124E-2]
[null,null,null,null,{"$f":"C49/(1+C$4)/(SUMPRODUCT(B40:B42,C34:C36)/10^3)-1","v":4.9640384216204092E-2},"Average"]
[]
["Tariffs Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C40/10^3","v":20.898435920096933}]
["General Security Entitlement",null,{"$f":"C35*C41/10^3","v":593.76207975285297}]
["Usage",null,{"$f":"C36*C42/10^3","v":921.9907735094248}]
[null,null,{"$f":"SUM(C46:C48)","v":1536.6512891823747}]
["Check",null,{"$f":"ABS(C49-C22)","v":0}]
[]
[]
["Revenue Requirement  - MDBA / BCR costs",null,"2014-15","2015-16","2016-17"]
["MDBA / BCR costs ($'000 Nominal)",null,{"$f":"Inputs!B$117*C$5","v":720.5078125},{"$f":"Inputs!C$117*D$5","v":738.88076171875014},{"$f":"Inputs!D$117*E$5","v":757.72222114257841}]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C54","v":432.3046875}]
["High security premium (times)",null,{"$f":"C31","v":2.967679587130307}]
[]
["Forecast sales quantities"]
["High Security Entitlement (ML)",null,{"$f":"C34","v":3122}]
["General Security Entitlement (ML)",null,{"$f":"C35","v":263238}]
["Forecast water volumes (ML)",null,140676.93950000001]
[]
[]
["Tariffs ($ Nominal)",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},null,{"$f":"C68*C58","v":3.1386598706468205}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},null,{"$f":"(C54-C57)*10^3/(C62+C61*C58)","v":1.0576141320168087}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},null,{"$f":"C57*10^3/C63","v":3.073031649938617}]
[]
[]
["Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C61*C67/10^3","v":9.7988961161593746}]
["General Security Entitlement",null,{"$f":"C62*C68/10^3","v":278.40422888384069}]
["Usage",null,{"$f":"C63*C69/10^3","v":432.3046875}]
[null,null,{"$f":"SUM(C73:C75)","v":720.5078125}]
["Check",null,{"$f":"ABS(C76-C54)","v":0}]
[]
[]
["Total Revenue Requirement",null,"2014-15"]
[{"$f":"A14","v":"Revenue Requirement  - State Water Costs"},null,{"$f":"C22","v":1536.6512891823747}]
[{"$f":"A53","v":"Revenue Requirement  - MDBA / BCR costs"},null,{"$f":"C54","v":720.5078125}]
[null,null,{"$f":"SUM(C81:C82)","v":2257.159101682375}]
[]
[]
[null,null,null,null,"Real Price Increase \\ (Decrease)"]
["Tariffs ($ Nominal)","2013-14","2014-15",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},{"$f":"Inputs!B$5","v":11.45},{"$f":"SUM(C40,C67)","v":9.8325855337143846},null,{"$f":"C88/(1+C$4)/B88-1","v":-0.16570125149991888}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!C$5","v":3.21},{"$f":"SUM(C41,C68)","v":3.3132234276080723},null,{"$f":"C89/(1+C$4)/B89-1","v":2.7785531074813186E-3}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!D$5","v":9.43},{"$f":"SUM(C42,C69)","v":9.6269897953631887},null,-8.167889386500593E-3]
[null,null,null,null,{"$f":"C97/(1+C$4)/(SUMPRODUCT(B88:B90,C34:C36)/10^3)-1","v":-6.5286429595784456E-3},"Average"]
[]
["Total Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C88/10^3","v":30.697332036256309}]
["General Security Entitlement",null,{"$f":"C35*C89/10^3","v":872.16630863669377}]
["Usage",null,{"$f":"C36*C90/10^3","v":1354.2954610094246}]
[null,null,{"$f":"SUM(C94:C96)","v":2257.1591016823745}]
["Check",null,{"$f":"ABS(C97-C83)","v":4.5474735088646412E-13}]

{"sheet":"Gwydir","index":6,"n_rows":98,"n_cols":6,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[null,"Check",{"$f":"IF(D1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(ABS(B26),C50,C77,C98)","v":5.6752469390630722E-10}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!H86","v":2.9296875E-2},{"$f":"Inputs!C83","v":2.5499999999999998E-2},{"$f":"Inputs!D83","v":2.5499999999999998E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.029296875},{"$f":"C5*(1+D4)","v":1.0555439453125002},{"$f":"D5*(1+E4)","v":1.0824603159179691}]
["Real Vanilla WACC",null,{"$f":"Inputs!B$85","v":4.2572208678693269E-2},{"$f":"Inputs!C$85","v":4.2572208678693269E-2},{"$f":"Inputs!D$85","v":4.2572208678693269E-2}]
["Nominal Vanilla WACC",null,{"$f":"(1+C6)*(1+C4)-1","v":7.311631635482696E-2},{"$f":"(1+D6)*(1+D4)-1","v":6.9157799999999936E-2},6.9157799999999936E-2]
["Accumulated Discount rate",null,{"$f":"1/(1+C7)","v":0.93186543225510798},{"$f":"C8/(1+D7)","v":0.87158830273240118},{"$f":"D8/(1+E7)","v":0.81521016143024094}]
[]
["Target Variable / Fixed ratio (%)",null,{"$f":"Inputs!B$36","v":0.6},{"$f":"Inputs!C$36","v":0.6},{"$f":"Inputs!D$36","v":0.6}]
[]
["Gwydir "]
["($'000 Nominal)"]
["Revenue Requirement  - State Water Costs",null,"2014-15","2015-16","2016-17"]
["PTRM Building block requirement (user share) - Unsmoothed",null,{"$f":"Inputs!G$91*C$5","v":4978.5402637404177},{"$f":"Inputs!H$91*D$5","v":5172.9542557970444},{"$f":"Inputs!I$91*E$5","v":5387.6809618550196}]
["ICD Rebates",null,{"$f":"Inputs!B$105*C$5","v":0},{"$f":"Inputs!C$105*D$5","v":0},{"$f":"Inputs!D$105*E$5","v":0}]
[]
["Total Revenue Requirement (user share) - Unsmoothed",null,{"$f":"SUM(C15:C17)","v":4978.5402637404177},{"$f":"SUM(D15:D17)","v":5172.9542557970444},{"$f":"SUM(E15:E17)","v":5387.6809618550196}]
["NPV",{"$f":"SUMPRODUCT(C$8:E$8,C18:E18)","v":13540.108261440888}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":1.3213457504799742E-2},{"$f":"(E18/(1+E$4))/D18-1","v":1.561140178806486E-2}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":4978.5402637404177},{"$f":"C22*(1+D$4)*(1+D24)","v":5176.9950708724482},{"$f":"D22*(1+E$4)*(1+E24)","v":5383.3606928994895}]
["NPV",{"$f":"SUMPRODUCT(C$8:E$8,C22:E22)","v":13540.108261441455}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Costs Tariffs'!E69","v":1.4004921726448164E-2},{"$f":"'SW Costs Tariffs'!F69","v":1.4004921726448164E-2}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":-5.6752469390630722E-10},null,null,{"$f":"E22/E18-1","v":-8.0187913614737649E-4},"Difference between final year revenue and requirement"]
[]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C22","v":2987.1241582442503}]
["High security premium (times)",null,{"$f":"Inputs!D$25","v":4.0664375654347671}]
[]
["Forecast sales quantities",null,"2014-15"]
["High Security Entitlement (ML)",null,{"$f":"Inputs!B$49","v":21457.9}]
["General Security Entitlement (ML)",null,{"$f":"Inputs!C$49","v":509665}]
["Forecast water volumes (ML)",null,{"$f":"Inputs!D$49","v":245876.74050000001}]
[]
[null,null,null,null,"Real Price Increase \\ (Decrease)"]
["Tariffs ($ Nominal)","2013-14","2014-15",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},{"$f":"Inputs!G$6","v":14.389781637543789},{"$f":"C41*C31","v":13.566205303673039},null,{"$f":"C40/(1+C$4)/B40-1","v":-8.4067377821124278E-2}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!H$6","v":4.0152930205105006},{"$f":"(C22-C30)*10^3/(C35+C34*C31)","v":3.3361400698703694},null,{"$f":"C41/(1+C$4)/B41-1","v":-0.19279028832122336}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!I$6","v":12.827179920202266},{"$f":"C30*10^3/C36","v":12.148868380839179},null,-7.9838652252870457E-2]
[null,null,null,null,{"$f":"C49/(1+C$4)/(SUMPRODUCT(B40:B42,C34:C36)/10^3)-1","v":-0.12203332129292388},"Average"]
[]
["Tariffs Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C40/10^3","v":291.10227678568572}]
["General Security Entitlement",null,{"$f":"C35*C41/10^3","v":1700.3138287104819}]
["Usage",null,{"$f":"C36*C42/10^3","v":2987.1241582442503}]
[null,null,{"$f":"SUM(C46:C48)","v":4978.5402637404177}]
["Check",null,{"$f":"ABS(C49-C22)","v":0}]
[]
[]
["Revenue Requirement  - MDBA / BCR costs",null,"2014-15","2015-16","2016-17"]
["MDBA / BCR costs ($'000 Nominal)",null,{"$f":"Inputs!B$118*C$5","v":0},{"$f":"Inputs!C$118*D$5","v":0},{"$f":"Inputs!D$118*E$5","v":0}]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C54","v":0}]
["High security premium (times)",null,{"$f":"C31","v":4.0664375654347671}]
[]
["Forecast sales quantities"]
["High Security Entitlement (ML)",null,{"$f":"C34","v":21457.9}]
["General Security Entitlement (ML)",null,{"$f":"C35","v":509665}]
["Forecast water volumes (ML)",null,{"$f":"C36","v":245876.74050000001}]
[]
[]
["Tariffs ($ Nominal)",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},null,{"$f":"C68*C58","v":0}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},null,{"$f":"(C54-C57)*10^3/(C62+C61*C58)","v":0}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},null,{"$f":"C57*10^3/C63","v":0}]
[]
[]
["Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C61*C67/10^3","v":0}]
["General Security Entitlement",null,{"$f":"C62*C68/10^3","v":0}]
["Usage",null,{"$f":"C63*C69/10^3","v":0}]
[null,null,{"$f":"SUM(C73:C75)","v":0}]
["Check",null,{"$f":"ABS(C76-C54)","v":0}]
[]
[]
["Total Revenue Requirement",null,"2014-15"]
[{"$f":"A14","v":"Revenue Requirement  - State Water Costs"},null,{"$f":"C22","v":4978.5402637404177}]
[{"$f":"A53","v":"Revenue Requirement  - MDBA / BCR costs"},null,{"$f":"C54","v":0}]
[null,null,{"$f":"SUM(C81:C82)","v":4978.5402637404177}]
[]
[]
[null,null,null,null,"Real Price Increase \\ (Decrease)"]
["Tariffs ($ Nominal)","2013-14","2014-15",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},{"$f":"Inputs!B$6","v":14.55},{"$f":"SUM(C40,C67)","v":13.566205303673039},null,{"$f":"C88/(1+C$4)/B88-1","v":-9.4153235198837226E-2}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!C$6","v":4.0599999999999996},{"$f":"SUM(C41,C68)","v":3.3361400698703694},null,{"$f":"C89/(1+C$4)/B89-1","v":-0.20167893561771288}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!D$6","v":12.97},{"$f":"SUM(C42,C69)","v":12.148868380839179},null,-8.9971074543698237E-2]
[null,null,null,null,{"$f":"C97/(1+C$4)/(SUMPRODUCT(B88:B90,C34:C36)/10^3)-1","v":-0.13170111397701778},"Average"]
[]
["Total Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C88/10^3","v":291.10227678568572}]
["General Security Entitlement",null,{"$f":"C35*C89/10^3","v":1700.3138287104819}]
["Usage",null,{"$f":"C36*C90/10^3","v":2987.1241582442503}]
[null,null,{"$f":"SUM(C94:C96)","v":4978.5402637404177}]
["Check",null,{"$f":"ABS(C97-C83)","v":0}]

{"sheet":"Namoi","index":7,"n_rows":98,"n_cols":6,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[null,"Check",{"$f":"IF(D1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(ABS(B26),C50,C77,C98)","v":1.8189894035458565E-12}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!H86","v":2.9296875E-2},{"$f":"Inputs!C83","v":2.5499999999999998E-2},{"$f":"Inputs!D83","v":2.5499999999999998E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.029296875},{"$f":"C5*(1+D4)","v":1.0555439453125002},{"$f":"D5*(1+E4)","v":1.0824603159179691}]
["Real Vanilla WACC",null,{"$f":"Inputs!B$85","v":4.2572208678693269E-2},{"$f":"Inputs!C$85","v":4.2572208678693269E-2},{"$f":"Inputs!D$85","v":4.2572208678693269E-2}]
["Nominal Vanilla WACC",null,{"$f":"(1+C6)*(1+C4)-1","v":7.311631635482696E-2},{"$f":"(1+D6)*(1+D4)-1","v":6.9157799999999936E-2},6.9157799999999936E-2]
["Accumulated Discount rate",null,{"$f":"1/(1+C7)","v":0.93186543225510798},{"$f":"C8/(1+D7)","v":0.87158830273240118},{"$f":"D8/(1+E7)","v":0.81521016143024094}]
[]
["Target Variable / Fixed ratio (%)",null,{"$f":"Inputs!B$36","v":0.6},{"$f":"Inputs!C$36","v":0.6},{"$f":"Inputs!D$36","v":0.6}]
[]
["Namoi "]
["($'000 Nominal)"]
["Revenue Requirement  - State Water Costs",null,"2014-15","2015-16","2016-17"]
["PTRM Building block requirement (user share) - Unsmoothed",null,{"$f":"Inputs!G$92*C$5","v":5281.3309754937627},{"$f":"Inputs!H$92*D$5","v":5459.3404699025432},{"$f":"Inputs!I$92*E$5","v":5621.9397005467208}]
["ICD Rebates",null,{"$f":"Inputs!B$106*C$5","v":0},{"$f":"Inputs!C$106*D$5","v":0},{"$f":"Inputs!D$106*E$5","v":0}]
[]
["Total Revenue Requirement (user share) - Unsmoothed",null,{"$f":"SUM(C15:C17)","v":5281.3309754937627},{"$f":"SUM(D15:D17)","v":5459.3404699025432},{"$f":"SUM(E15:E17)","v":5621.9397005467208}]
["NPV",{"$f":"SUMPRODUCT(C$8:E$8,C18:E18)","v":14262.849437395227}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":8.0013875930424749E-3},{"$f":"(E18/(1+E$4))/D18-1","v":4.1771589799426412E-3}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":5281.3309754937627},{"$f":"C22*(1+D$4)*(1+D24)","v":5452.5116766712736},{"$f":"D22*(1+E$4)*(1+E24)","v":5629.240758094521}]
["NPV",{"$f":"SUMPRODUCT(C$8:E$8,C22:E22)","v":14262.849437395227}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Costs Tariffs'!H69","v":6.7405332662873437E-3},{"$f":"'SW Costs Tariffs'!I69","v":6.7405332662873437E-3}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":0},null,null,{"$f":"E22/E18-1","v":1.298672333161166E-3},"Difference between final year revenue and requirement"]
[]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C22","v":3168.7985852962574}]
["High security premium (times)",null,{"$f":"Inputs!D$26","v":2.1506712025445864}]
[]
["Forecast sales quantities",null,"2014-15"]
["High Security Entitlement (ML)",null,{"$f":"Inputs!B$50","v":8881}]
["General Security Entitlement (ML)",null,{"$f":"Inputs!C$50","v":256076}]
["Forecast water volumes (ML)",null,{"$f":"Inputs!D$50","v":158960.9705}]
[]
[null,null,null,null,"Real Price Increase \\ (Decrease)"]
["Tariffs ($ Nominal)","2013-14","2014-15",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},{"$f":"Inputs!G$7","v":16.019857330139448},{"$f":"C41*C31","v":16.510744920256986},null,{"$f":"C40/(1+C$4)/B40-1","v":1.3072706173573589E-3}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!H$7","v":8.9778361979634766},{"$f":"(C22-C30)*10^3/(C35+C34*C31)","v":7.6770195745040644},null,{"$f":"C41/(1+C$4)/B41-1","v":-0.16923093533225353}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!I$7","v":19.733461742058335},{"$f":"C30*10^3/C36","v":19.934444130084483},null,-1.8568037489399836E-2]
[null,null,null,null,{"$f":"C49/(1+C$4)/(SUMPRODUCT(B40:B42,C34:C36)/10^3)-1","v":-8.0156329398662574E-2},"Average"]
[]
["Tariffs Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C40/10^3","v":146.63192563680229}]
["General Security Entitlement",null,{"$f":"C35*C41/10^3","v":1965.9004645607026}]
["Usage",null,{"$f":"C36*C42/10^3","v":3168.7985852962574}]
[null,null,{"$f":"SUM(C46:C48)","v":5281.3309754937618}]
["Check",null,{"$f":"ABS(C49-C22)","v":9.0949470177292824E-13}]
[]
[]
["Revenue Requirement  - MDBA / BCR costs",null,"2014-15","2015-16","2016-17"]
["MDBA / BCR costs ($'000 Nominal)",null,{"$f":"Inputs!B$119*C$5","v":0},{"$f":"Inputs!C$119*D$5","v":0},{"$f":"Inputs!D$119*E$5","v":0}]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C54","v":0}]
["High security premium (times)",null,{"$f":"C31","v":2.1506712025445864}]
[]
["Forecast sales quantities"]
["High Security Entitlement (ML)",null,{"$f":"C34","v":8881}]
["General Security Entitlement (ML)",null,{"$f":"C35","v":256076}]
["Forecast water volumes (ML)",null,{"$f":"C36","v":158960.9705}]
[]
[]
["Tariffs ($ Nominal)",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},null,{"$f":"C68*C58","v":0}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},null,{"$f":"(C54-C57)*10^3/(C62+C61*C58)","v":0}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},null,{"$f":"C57*10^3/C63","v":0}]
[]
[]
["Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C61*C67/10^3","v":0}]
["General Security Entitlement",null,{"$f":"C62*C68/10^3","v":0}]
["Usage",null,{"$f":"C63*C69/10^3","v":0}]
[null,null,{"$f":"SUM(C73:C75)","v":0}]
["Check",null,{"$f":"ABS(C76-C54)","v":0}]
[]
[]
["Total Revenue Requirement",null,"2014-15"]
[{"$f":"A14","v":"Revenue Requirement  - State Water Costs"},null,{"$f":"C22","v":5281.3309754937627}]
[{"$f":"A53","v":"Revenue Requirement  - MDBA / BCR costs"},null,{"$f":"C54","v":0}]
[null,null,{"$f":"SUM(C81:C82)","v":5281.3309754937627}]
[]
[]
[null,null,null,null,"Real Price Increase \\ (Decrease)"]
["Tariffs ($ Nominal)","2013-14","2014-15",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},{"$f":"Inputs!B$7","v":16.22},{"$f":"SUM(C40,C67)","v":16.510744920256986},null,{"$f":"C88/(1+C$4)/B88-1","v":-1.1048112273649879E-2}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!C$7","v":9.09},{"$f":"SUM(C41,C68)","v":7.6770195745040644},null,{"$f":"C89/(1+C$4)/B89-1","v":-0.17948200429897088}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!D$7","v":19.98},{"$f":"SUM(C42,C69)","v":19.934444130084483},null,-3.0678173942134235E-2]
[null,null,null,null,{"$f":"C97/(1+C$4)/(SUMPRODUCT(B88:B90,C34:C36)/10^3)-1","v":-9.1506512388088157E-2},"Average"]
[]
["Total Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C88/10^3","v":146.63192563680229}]
["General Security Entitlement",null,{"$f":"C35*C89/10^3","v":1965.9004645607026}]
["Usage",null,{"$f":"C36*C90/10^3","v":3168.7985852962574}]
[null,null,{"$f":"SUM(C94:C96)","v":5281.3309754937618}]
["Check",null,{"$f":"ABS(C97-C83)","v":9.0949470177292824E-13}]

{"sheet":"Peel","index":8,"n_rows":98,"n_cols":10,"rows_kept":98,"cut":false,"hidden":false,"merged":[[37,3,37,4],[37,8,37,9],[43,8,43,9]]}
[null,"Check",{"$f":"IF(D1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(ABS(B26),C50,C77,C98)","v":1.7280399333685637E-11}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!H86","v":2.9296875E-2},{"$f":"Inputs!C83","v":2.5499999999999998E-2},{"$f":"Inputs!D83","v":2.5499999999999998E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.029296875},{"$f":"C5*(1+D4)","v":1.0555439453125002},{"$f":"D5*(1+E4)","v":1.0824603159179691}]
["Real Vanilla WACC",null,{"$f":"Inputs!B$85","v":4.2572208678693269E-2},{"$f":"Inputs!C$85","v":4.2572208678693269E-2},{"$f":"Inputs!D$85","v":4.2572208678693269E-2}]
["Nominal Vanilla WACC",null,{"$f":"(1+C6)*(1+C4)-1","v":7.311631635482696E-2},{"$f":"(1+D6)*(1+D4)-1","v":6.9157799999999936E-2},6.9157799999999936E-2]
["Accumulated Discount rate",null,{"$f":"1/(1+C7)","v":0.93186543225510798},{"$f":"C8/(1+D7)","v":0.87158830273240118},{"$f":"D8/(1+E7)","v":0.81521016143024094}]
[]
["Target Variable / Fixed ratio (%)",null,{"$f":"Inputs!B$36","v":0.6},{"$f":"Inputs!C$36","v":0.6},{"$f":"Inputs!D$36","v":0.6}]
[]
["Peel"]
["($'000 Nominal)"]
["Revenue Requirement  - State Water Costs",null,"2014-15","2015-16","2016-17"]
["PTRM Building block requirement (user share) - Unsmoothed",null,{"$f":"Inputs!G$93*C$5","v":1343.3405881255171},{"$f":"Inputs!H$93*D$5","v":1386.5532465326853},{"$f":"Inputs!I$93*E$5","v":1416.4757796778952}]
["ICD Rebates",null,{"$f":"Inputs!B$107*C$5","v":0},{"$f":"Inputs!C$107*D$5","v":0},{"$f":"Inputs!D$107*E$5","v":0}]
[]
["Total Revenue Requirement (user share) - Unsmoothed",null,{"$f":"SUM(C15:C17)","v":1343.3405881255171},{"$f":"SUM(D15:D17)","v":1386.5532465326853},{"$f":"SUM(E15:E17)","v":1416.4757796778952}]
["NPV",{"$f":"SUMPRODUCT(C$8:E$8,C18:E18)","v":3615.0416976261831}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":6.5022509394485617E-3},{"$f":"(E18/(1+E$4))/D18-1","v":-3.8220233961061556E-3}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":1343.3405881255171},{"$f":"C22*(1+D$4)*(1+D24)","v":1381.8630929145309},{"$f":"D22*(1+E$4)*(1+E24)","v":1421.4902940019647}]
["NPV",{"$f":"SUMPRODUCT(C$8:E$8,C22:E22)","v":3615.0416976262004}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Costs Tariffs'!K69","v":3.0976574370142158E-3},{"$f":"'SW Costs Tariffs'!L69","v":3.0976574370142158E-3}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":-1.7280399333685637E-11},null,null,{"$f":"E22/E18-1","v":3.5401341809104814E-3},"Difference between final year revenue and requirement"]
[]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C22","v":806.00435287531025}]
["High security premium (times)",null,{"$f":"Inputs!D$27","v":9.8752751283932518}]
[]
["Forecast sales quantities",null,"2014-15"]
["High Security Entitlement (ML)",null,{"$f":"Inputs!B$51","v":17382},null,null,null,{"$f":"\"Peel Valley prices capped at \" &H36*100& \"% annual real increase\"","v":"Peel Valley prices capped at 10% annual real increase"}]
["General Security Entitlement (ML)",null,{"$f":"Inputs!C$51","v":30528},null,null,null,null,"2014-15","2015-16","2016-17"]
["Forecast water volumes (ML)",null,{"$f":"Inputs!D$51","v":11163.91},null,null,null,"Annual real price increase cap",{"$f":"Inputs!B44","v":0.1},{"$f":"Inputs!C44","v":0.1},{"$f":"Inputs!D44","v":0.1}]
[]
[null,null,null,"Indicative Prices",null,null,null,null,"Indicative Prices"]
["Tariffs ($ Nominal) - Cost Reflective","2013-14","2014-15","2015-16","2016-17",null,"Tariffs ($ Nominal) - Capped","2014-15","2015-16","2016-17"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},{"$f":"Inputs!G$8","v":25.076315111646519},{"$f":"C41*C31","v":26.245634149254716},{"$f":"C40*(1+D$4)*(1+D$24)","v":26.998270953459503},{"$f":"D40*(1+E$4)*(1+E$24)","v":27.772490858145773},null,{"$f":"A40","v":"High Security Entitlement ($/ML)"},{"$f":"B40*(1+C$4)*(1+H$36)","v":28.392070059026345},{"$f":"H40*(1+D$4)*(1+I$36)","v":32.027674630084675},36.12881836646703]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!H$8","v":2.7574987240675211},{"$f":"(C22-C30)*10^3/(C35+C34*C31)","v":2.6577116898539503},{"$f":"C41*(1+D$4)*(1+D$24)","v":2.7339259516764707},2.8123257830351176,null,{"$f":"A41","v":"General Security Entitlement ($/ML)"},{"$f":"B41*(1+C$4)*(1+H$36)","v":3.1221133014491054},3.5218999096996635,3.972879193136706]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!I$8","v":41.422210075252544},{"$f":"C30*10^3/C36","v":72.197317326573781},{"$f":"C42*(1+D$4)*(1+D$24)","v":74.267694360552767},76.397442867344779,null,"Usage ($/ML delivered)",{"$f":"B42*(1+C$4)*(1+H$36)","v":46.899326524656054},52.904785286138264,59.679243042028276]
[]
[null,null,null,null,null,null,null,null,"Indicative Revenue"]
["Tariffs Revenue ($'000 Nominal) - Cost Reflective",null,"2014-15","2015-16","2016-17",null,"Tariffs Revenue ($'000 Nominal)","2014-15","2015-16","2016-17"]
["High Security Entitlement",null,{"$f":"$C34*C40/10^3","v":456.20161278234548},{"$f":"$C34*D40/10^3","v":469.28394571303306},482.74143609628982,null,"High Security Entitlement",{"$f":"$C34*H40/10^3","v":493.51096176599594},{"$f":"$C34*I40/10^3","v":556.70504042013192},627.99112084592991]
["General Security Entitlement",null,{"$f":"$C35*C41/10^3","v":81.134622467861391},{"$f":"$C35*D41/10^3","v":83.461291452779307},85.854681504496071,null,"General Security Entitlement",{"$f":"$C35*H41/10^3","v":95.311874866638291},{"$f":"$C35*I41/10^3","v":107.51656044331133},121.28405600807736]
["Usage",null,{"$f":"$C36*C42/10^3","v":806.00435287531036},{"$f":"$C36*D42/10^3","v":829.11785574871863},852.89417640117904,null,"Usage",{"$f":"$C36*H42/10^3","v":523.579860381873},{"$f":"$C36*I42/10^3","v":590.62426150377178},666.25369818932984]
[null,null,{"$f":"SUM(C46:C48)","v":1343.3405881255171},{"$f":"SUM(D46:D48)","v":1381.8630929145311},1421.4902940019649,null,null,{"$f":"SUM(H46:H48)","v":1112.4026970145073},{"$f":"SUM(I46:I48)","v":1254.845862367215},1415.5288750433369]
["Check",null,{"$f":"ABS(C49-C22)","v":0},{"$f":"ABS(D49-D22)","v":2.2737367544323206E-13},2.2737367544323206E-13]
[null,null,null,null,null,null,"Subsidy required"]
[null,null,null,null,null,null,"Under recovery ($'000 Nominal)",{"$f":"C49-H49","v":230.93789111100978},{"$f":"D49-I49","v":127.0172305473161},{"$f":"E49-J49","v":5.9614189586279736}]
["Revenue Requirement  - MDBA / BCR costs",null,"2014-15","2015-16","2016-17",null,"Under recovery ($ Real 2013-14)",{"$f":"H52/C5","v":224.36470635452943},{"$f":"I52/D5","v":120.33343671893441},{"$f":"J52/E5","v":5.5072863835866857}]
["MDBA / BCR costs ($'000 Nominal)",null,{"$f":"Inputs!B$120*C$5","v":0},{"$f":"Inputs!C$120*D$5","v":0},{"$f":"Inputs!D$120*E$5","v":0}]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C54","v":0}]
["High security premium (times)",null,{"$f":"C31","v":9.8752751283932518}]
[]
["Forecast sales quantities"]
["High Security Entitlement (ML)",null,{"$f":"C34","v":17382}]
["General Security Entitlement (ML)",null,{"$f":"C35","v":30528}]
["Forecast water volumes (ML)",null,{"$f":"C36","v":11163.91}]
[]
[]
["Tariffs ($ Nominal)",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},null,{"$f":"C68*C58","v":0}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},null,{"$f":"(C54-C57)*10^3/(C62+C61*C58)","v":0}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},null,{"$f":"C57*10^3/C63","v":0}]
[]
[]
["Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C61*C67/10^3","v":0}]
["General Security Entitlement",null,{"$f":"C62*C68/10^3","v":0}]
["Usage",null,{"$f":"C63*C69/10^3","v":0}]
[null,null,{"$f":"SUM(C73:C75)","v":0}]
["Check",null,{"$f":"ABS(C76-C54)","v":0}]
[]
[]
["Total Revenue Requirement",null,"2014-15"]
[{"$f":"A14","v":"Revenue Requirement  - State Water Costs"},null,{"$f":"C22","v":1343.3405881255171}]
[{"$f":"A53","v":"Revenue Requirement  - MDBA / BCR costs"},null,{"$f":"C54","v":0}]
[null,null,{"$f":"SUM(C81:C82)","v":1343.3405881255171}]
[]
[]
[null,null,null,null,"Real Price Increase \\ (Decrease)"]
["Tariffs ($ Nominal)","2013-14","2014-15",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},{"$f":"Inputs!B$8","v":25.19},{"$f":"SUM(C40,C67)","v":26.245634149254716},null,{"$f":"C88/(1+C$4)/B88-1","v":1.2251080359922284E-2}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!C$8","v":2.77},{"$f":"SUM(C41,C68)","v":2.6577116898539503},null,{"$f":"C89/(1+C$4)/B89-1","v":-6.7846481202623266E-2}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!D$8","v":41.61},{"$f":"SUM(C42,C69)","v":72.197317326573781},null,0.68570932998087764]
[null,null,null,null,{"$f":"C97/(1+C$4)/(SUMPRODUCT(B88:B90,C34:C36)/10^3)-1","v":0.32236802674151588},"Average"]
[]
["Total Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C88/10^3","v":456.20161278234548}]
["General Security Entitlement",null,{"$f":"C35*C89/10^3","v":81.134622467861391}]
["Usage",null,{"$f":"C36*C90/10^3","v":806.00435287531036}]
[null,null,{"$f":"SUM(C94:C96)","v":1343.3405881255171}]
["Check",null,{"$f":"ABS(C97-C83)","v":0}]

{"sheet":"Lachlan","index":9,"n_rows":98,"n_cols":6,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[null,"Check",{"$f":"IF(D1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(ABS(B26),C50,C77,C98)","v":0}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!H86","v":2.9296875E-2},{"$f":"Inputs!C83","v":2.5499999999999998E-2},{"$f":"Inputs!D83","v":2.5499999999999998E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.029296875},{"$f":"C5*(1+D4)","v":1.0555439453125002},{"$f":"D5*(1+E4)","v":1.0824603159179691}]
["Real Vanilla WACC",null,{"$f":"Inputs!B$85","v":4.2572208678693269E-2},{"$f":"Inputs!C$85","v":4.2572208678693269E-2},{"$f":"Inputs!D$85","v":4.2572208678693269E-2}]
["Nominal Vanilla WACC",null,{"$f":"(1+C6)*(1+C4)-1","v":7.311631635482696E-2},{"$f":"(1+D6)*(1+D4)-1","v":6.9157799999999936E-2},6.9157799999999936E-2]
["Accumulated Discount rate",null,{"$f":"1/(1+C7)","v":0.93186543225510798},{"$f":"C8/(1+D7)","v":0.87158830273240118},{"$f":"D8/(1+E7)","v":0.81521016143024094}]
[]
["Target Variable / Fixed ratio (%)",null,{"$f":"Inputs!B$36","v":0.6},{"$f":"Inputs!C$36","v":0.6},{"$f":"Inputs!D$36","v":0.6}]
[]
["Lachlan"]
["($'000 Nominal)"]
["Revenue Requirement  - State Water Costs",null,"2014-15","2015-16","2016-17"]
["PTRM Building block requirement (user share) - Unsmoothed",null,{"$f":"Inputs!G$94*C$5","v":6919.9368177954284},{"$f":"Inputs!H$94*D$5","v":7279.2204221845932},{"$f":"Inputs!I$94*E$5","v":7551.0441162304414}]
["ICD Rebates",null,{"$f":"Inputs!B$108*C$5","v":69.423591778974},{"$f":"Inputs!C$108*D$5","v":65.078732574842093},{"$f":"Inputs!D$108*E$5","v":64.170485240530553}]
[]
["Total Revenue Requirement (user share) - Unsmoothed",null,{"$f":"SUM(C15:C17)","v":6989.3604095744022},{"$f":"SUM(D15:D17)","v":7344.2991547594356},{"$f":"SUM(E15:E17)","v":7615.2146014709724}]
["NPV",{"$f":"SUMPRODUCT(C$8:E$8,C18:E18)","v":19122.348918901655}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":2.4654043678428383E-2},{"$f":"(E18/(1+E$4))/D18-1","v":1.1104686105344097E-2}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":6989.3604095744022},{"$f":"C22*(1+D$4)*(1+D24)","v":7312.0678054292066},{"$f":"D22*(1+E$4)*(1+E24)","v":7649.6750000119073}]
["NPV",{"$f":"SUMPRODUCT(C$8:E$8,C22:E22)","v":19122.348918901651}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Costs Tariffs'!N69","v":2.0157224890344598E-2},{"$f":"'SW Costs Tariffs'!O69","v":2.0157224890344598E-2}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":0},null,null,{"$f":"E22/E18-1","v":4.5252038641534487E-3},"Difference between final year revenue and requirement"]
[]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C22","v":4193.6162457446408}]
["High security premium (times)",null,{"$f":"Inputs!D$28","v":4.0304087736789631}]
[]
["Forecast sales quantities",null,"2014-15"]
["High Security Entitlement (ML)",null,{"$f":"Inputs!B$52","v":60745}]
["General Security Entitlement (ML)",null,{"$f":"Inputs!C$52","v":632837}]
["Forecast water volumes (ML)",null,{"$f":"Inputs!D$52","v":227697.17900000006}]
[]
[null,null,null,null,"Real Price Increase \\ (Decrease)"]
["Tariffs ($ Nominal)","2013-14","2014-15",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},{"$f":"Inputs!G$9","v":12.36},{"$f":"C41*C31","v":12.838614189054658},null,{"$f":"C40/(1+C$4)/B40-1","v":9.1576648667712757E-3}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!H$9","v":4.42},{"$f":"(C22-C30)*10^3/(C35+C34*C31)","v":3.1854372372595727},null,{"$f":"C41/(1+C$4)/B41-1","v":-0.29982575945250534}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!I$9","v":18.04},{"$f":"C30*10^3/C36","v":18.417515158343878},null,-8.1320698813865944E-3]
[null,null,null,null,{"$f":"C49/(1+C$4)/(SUMPRODUCT(B40:B42,C34:C36)/10^3)-1","v":-0.11301296353555945},"Average"]
[]
["Tariffs Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C40/10^3","v":779.88161891412517}]
["General Security Entitlement",null,{"$f":"C35*C41/10^3","v":2015.8625449156364}]
["Usage",null,{"$f":"C36*C42/10^3","v":4193.6162457446408}]
[null,null,{"$f":"SUM(C46:C48)","v":6989.3604095744022}]
["Check",null,{"$f":"ABS(C49-C22)","v":0}]
[]
[]
["Revenue Requirement  - MDBA / BCR costs",null,"2014-15","2015-16","2016-17"]
["MDBA / BCR costs ($'000 Nominal)",null,{"$f":"Inputs!B$121*C$5","v":0},{"$f":"Inputs!C$121*D$5","v":0},{"$f":"Inputs!D$121*E$5","v":0}]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C54","v":0}]
["High security premium (times)",null,{"$f":"C31","v":4.0304087736789631}]
[]
["Forecast sales quantities"]
["High Security Entitlement (ML)",null,{"$f":"C34","v":60745}]
["General Security Entitlement (ML)",null,{"$f":"C35","v":632837}]
["Forecast water volumes (ML)",null,{"$f":"C36","v":227697.17900000006}]
[]
[]
["Tariffs ($ Nominal)",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},null,{"$f":"C68*C58","v":0}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},null,{"$f":"(C54-C57)*10^3/(C62+C61*C58)","v":0}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},null,{"$f":"C57*10^3/C63","v":0}]
[]
[]
["Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C61*C67/10^3","v":0}]
["General Security Entitlement",null,{"$f":"C62*C68/10^3","v":0}]
["Usage",null,{"$f":"C63*C69/10^3","v":0}]
[null,null,{"$f":"SUM(C73:C75)","v":0}]
["Check",null,{"$f":"ABS(C76-C54)","v":0}]
[]
[]
["Total Revenue Requirement",null,"2014-15"]
[{"$f":"A14","v":"Revenue Requirement  - State Water Costs"},null,{"$f":"C22","v":6989.3604095744022}]
[{"$f":"A53","v":"Revenue Requirement  - MDBA / BCR costs"},null,{"$f":"C54","v":0}]
[null,null,{"$f":"SUM(C81:C82)","v":6989.3604095744022}]
[]
[]
[null,null,null,null,"Real Price Increase \\ (Decrease)"]
["Tariffs ($ Nominal)","2013-14","2014-15",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},{"$f":"Inputs!B$9","v":12.36},{"$f":"SUM(C40,C67)","v":12.838614189054658},null,{"$f":"C88/(1+C$4)/B88-1","v":9.1576648667712757E-3}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!C$9","v":4.42},{"$f":"SUM(C41,C68)","v":3.1854372372595727},null,{"$f":"C89/(1+C$4)/B89-1","v":-0.29982575945250534}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!D$9","v":18.04},{"$f":"SUM(C42,C69)","v":18.417515158343878},null,-8.1320698813865944E-3]
[null,null,null,null,{"$f":"C97/(1+C$4)/(SUMPRODUCT(B88:B90,C34:C36)/10^3)-1","v":-0.11301296353555945},"Average"]
[]
["Total Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C88/10^3","v":779.88161891412517}]
["General Security Entitlement",null,{"$f":"C35*C89/10^3","v":2015.8625449156364}]
["Usage",null,{"$f":"C36*C90/10^3","v":4193.6162457446408}]
[null,null,{"$f":"SUM(C94:C96)","v":6989.3604095744022}]
["Check",null,{"$f":"ABS(C97-C83)","v":0}]

{"sheet":"Macquarie","index":10,"n_rows":98,"n_cols":6,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[null,"Check",{"$f":"IF(D1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(ABS(B26),C50,C77,C98)","v":1.8189894035458565E-12}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!H86","v":2.9296875E-2},{"$f":"Inputs!C83","v":2.5499999999999998E-2},{"$f":"Inputs!D83","v":2.5499999999999998E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.029296875},{"$f":"C5*(1+D4)","v":1.0555439453125002},{"$f":"D5*(1+E4)","v":1.0824603159179691}]
["Real Vanilla WACC",null,{"$f":"Inputs!B$85","v":4.2572208678693269E-2},{"$f":"Inputs!C$85","v":4.2572208678693269E-2},{"$f":"Inputs!D$85","v":4.2572208678693269E-2}]
["Nominal Vanilla WACC",null,{"$f":"(1+C6)*(1+C4)-1","v":7.311631635482696E-2},{"$f":"(1+D6)*(1+D4)-1","v":6.9157799999999936E-2},6.9157799999999936E-2]
["Accumulated Discount rate",null,{"$f":"1/(1+C7)","v":0.93186543225510798},{"$f":"C8/(1+D7)","v":0.87158830273240118},{"$f":"D8/(1+E7)","v":0.81521016143024094}]
[]
["Target Variable / Fixed ratio (%)",null,{"$f":"Inputs!B$36","v":0.6},{"$f":"Inputs!C$36","v":0.6},{"$f":"Inputs!D$36","v":0.6}]
[]
["Macquarie"]
["($'000 Nominal)"]
["Revenue Requirement  - State Water Costs",null,"2014-15","2015-16","2016-17"]
["PTRM Building block requirement (user share) - Unsmoothed",null,{"$f":"Inputs!G$95*C$5","v":6712.722532676532},{"$f":"Inputs!H$95*D$5","v":6964.93091120597},{"$f":"Inputs!I$95*E$5","v":7378.5574842308833}]
["ICD Rebates",null,{"$f":"Inputs!B$109*C$5","v":0},{"$f":"Inputs!C$109*D$5","v":0},{"$f":"Inputs!D$109*E$5","v":0}]
[]
["Total Revenue Requirement (user share) - Unsmoothed",null,{"$f":"SUM(C15:C17)","v":6712.722532676532},{"$f":"SUM(D15:D17)","v":6964.93091120597},{"$f":"SUM(E15:E17)","v":7378.5574842308833}]
["NPV",{"$f":"SUMPRODUCT(C$8:E$8,C18:E18)","v":18340.981433909838}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":1.1771523375393667E-2},{"$f":"(E18/(1+E$4))/D18-1","v":3.3044399542228264E-2}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":6712.722532676532},{"$f":"C22*(1+D$4)*(1+D24)","v":7013.143854983995},{"$f":"D22*(1+E$4)*(1+E24)","v":7327.0102393296438}]
["NPV",{"$f":"SUMPRODUCT(C$8:E$8,C22:E22)","v":18340.981433909838}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Costs Tariffs'!B77","v":1.8775251652758333E-2},{"$f":"'SW Costs Tariffs'!C77","v":1.8775251652758333E-2}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":0},null,null,{"$f":"E22/E18-1","v":-6.986087051758294E-3},"Difference between final year revenue and requirement"]
[]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C22","v":4027.633519605919}]
["High security premium (times)",null,{"$f":"Inputs!D$29","v":3.6862745098039205}]
[]
["Forecast sales quantities",null,"2014-15"]
["High Security Entitlement (ML)",null,{"$f":"Inputs!B$53","v":42606}]
["General Security Entitlement (ML)",null,{"$f":"Inputs!C$53","v":631716}]
["Forecast water volumes (ML)",null,{"$f":"Inputs!D$53","v":279670.66850000003}]
[]
[null,null,null,null,"Real Price Increase \\ (Decrease)"]
["Tariffs ($ Nominal)","2013-14","2014-15",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},{"$f":"Inputs!G$10","v":11.35284249530522},{"$f":"C41*C31","v":12.548565960523746},null,{"$f":"C40/(1+C$4)/B40-1","v":7.3862881163217819E-2}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!H$10","v":4.2150658651571051},{"$f":"(C22-C30)*10^3/(C35+C34*C31)","v":3.4041322552484639},null,{"$f":"C41/(1+C$4)/B41-1","v":-0.21537633073178264}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!I$10","v":13.897787923324605},{"$f":"C30*10^3/C36","v":14.401344056593187},null,6.7385331557423545E-3]
[null,null,null,null,{"$f":"C49/(1+C$4)/(SUMPRODUCT(B40:B42,C34:C36)/10^3)-1","v":-7.273603453245614E-2},"Average"]
[]
["Tariffs Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C40/10^3","v":534.64420131407473}]
["General Security Entitlement",null,{"$f":"C35*C41/10^3","v":2150.4448117565389}]
["Usage",null,{"$f":"C36*C42/10^3","v":4027.633519605919}]
[null,null,{"$f":"SUM(C46:C48)","v":6712.7225326765329}]
["Check",null,{"$f":"ABS(C49-C22)","v":9.0949470177292824E-13}]
[]
[]
["Revenue Requirement  - MDBA / BCR costs",null,"2014-15","2015-16","2016-17"]
["MDBA / BCR costs ($'000 Nominal)",null,{"$f":"Inputs!B$122*C$5","v":0},{"$f":"Inputs!C$122*D$5","v":0},{"$f":"Inputs!D$122*E$5","v":0}]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C54","v":0}]
["High security premium (times)",null,{"$f":"C31","v":3.6862745098039205}]
[]
["Forecast sales quantities"]
["High Security Entitlement (ML)",null,{"$f":"C34","v":42606}]
["General Security Entitlement (ML)",null,{"$f":"C35","v":631716}]
["Forecast water volumes (ML)",null,{"$f":"C36","v":279670.66850000003}]
[]
[]
["Tariffs ($ Nominal)",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},null,{"$f":"C68*C58","v":0}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},null,{"$f":"(C54-C57)*10^3/(C62+C61*C58)","v":0}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},null,{"$f":"C57*10^3/C63","v":0}]
[]
[]
["Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C61*C67/10^3","v":0}]
["General Security Entitlement",null,{"$f":"C62*C68/10^3","v":0}]
["Usage",null,{"$f":"C63*C69/10^3","v":0}]
[null,null,{"$f":"SUM(C73:C75)","v":0}]
["Check",null,{"$f":"ABS(C76-C54)","v":0}]
[]
[]
["Total Revenue Requirement",null,"2014-15"]
[{"$f":"A14","v":"Revenue Requirement  - State Water Costs"},null,{"$f":"C22","v":6712.722532676532}]
[{"$f":"A53","v":"Revenue Requirement  - MDBA / BCR costs"},null,{"$f":"C54","v":0}]
[null,null,{"$f":"SUM(C81:C82)","v":6712.722532676532}]
[]
[]
[null,null,null,null,"Real Price Increase \\ (Decrease)"]
["Tariffs ($ Nominal)","2013-14","2014-15",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},{"$f":"Inputs!B$10","v":11.42},{"$f":"SUM(C40,C67)","v":12.548565960523746},null,{"$f":"C88/(1+C$4)/B88-1","v":6.7547824115646193E-2}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!C$10","v":4.24},{"$f":"SUM(C41,C68)","v":3.4041322552484639},null,{"$f":"C89/(1+C$4)/B89-1","v":-0.2199904610078347}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!D$10","v":13.98},{"$f":"SUM(C42,C69)","v":14.401344056593187},null,8.1821373658108598E-4]
[null,null,null,null,{"$f":"C97/(1+C$4)/(SUMPRODUCT(B88:B90,C34:C36)/10^3)-1","v":-7.8188988482910338E-2},"Average"]
[]
["Total Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C88/10^3","v":534.64420131407473}]
["General Security Entitlement",null,{"$f":"C35*C89/10^3","v":2150.4448117565389}]
["Usage",null,{"$f":"C36*C90/10^3","v":4027.633519605919}]
[null,null,{"$f":"SUM(C94:C96)","v":6712.7225326765329}]
["Check",null,{"$f":"ABS(C97-C83)","v":9.0949470177292824E-13}]

{"sheet":"Murray","index":11,"n_rows":98,"n_cols":6,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[null,"Check",{"$f":"IF(D1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(ABS(B26),C50,C77,C98)","v":7.8216544352471828E-10}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!H86","v":2.9296875E-2},{"$f":"Inputs!C83","v":2.5499999999999998E-2},{"$f":"Inputs!D83","v":2.5499999999999998E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.029296875},{"$f":"C5*(1+D4)","v":1.0555439453125002},{"$f":"D5*(1+E4)","v":1.0824603159179691}]
["Real Vanilla WACC",null,{"$f":"Inputs!B$85","v":4.2572208678693269E-2},{"$f":"Inputs!C$85","v":4.2572208678693269E-2},{"$f":"Inputs!D$85","v":4.2572208678693269E-2}]
["Nominal Vanilla WACC",null,{"$f":"(1+C6)*(1+C4)-1","v":7.311631635482696E-2},{"$f":"(1+D6)*(1+D4)-1","v":6.9157799999999936E-2},6.9157799999999936E-2]
["Accumulated Discount rate",null,{"$f":"1/(1+C7)","v":0.93186543225510798},{"$f":"C8/(1+D7)","v":0.87158830273240118},{"$f":"D8/(1+E7)","v":0.81521016143024094}]
[]
["Target Variable / Fixed ratio (%)",null,{"$f":"Inputs!B$36","v":0.6},{"$f":"Inputs!C$36","v":0.6},{"$f":"Inputs!D$36","v":0.6}]
[]
["Murray "]
["($'000 Nominal)"]
["Revenue Requirement  - State Water Costs",null,"2014-15","2015-16","2016-17"]
["PTRM Building block requirement (user share) - Unsmoothed",null,{"$f":"Inputs!G$96*C$5","v":5121.9525708168831},{"$f":"Inputs!H$96*D$5","v":5167.1392305997288},{"$f":"Inputs!I$96*E$5","v":5312.5827680380498}]
["ICD Rebates",null,{"$f":"Inputs!B$110*C$5","v":1112.7401296713572},{"$f":"Inputs!C$110*D$5","v":1067.9331152887846},{"$f":"Inputs!D$110*E$5","v":1063.7284273200114}]
[]
["Total Revenue Requirement (user share) - Unsmoothed",null,{"$f":"SUM(C15:C17)","v":6234.69270048824},{"$f":"SUM(D15:D17)","v":6235.0723458885132},{"$f":"SUM(E15:E17)","v":6376.311195358061}]
["NPV",{"$f":"SUMPRODUCT(C$8:E$8,C18:E18)","v":16442.344410582238}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":-2.4806540809599431E-2},{"$f":"(E18/(1+E$4))/D18-1","v":-2.7768705284870743E-3}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":6234.69270048824},{"$f":"C22*(1+D$4)*(1+D24)","v":6280.856045320762},{"$f":"D22*(1+E$4)*(1+E24)","v":6327.3611959981745}]
["NPV",{"$f":"SUMPRODUCT(C$8:E$8,C22:E22)","v":16442.34441058302}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Costs Tariffs'!E77","v":-1.7645763556820633E-2},{"$f":"'SW Costs Tariffs'!F77","v":-1.7645763556820633E-2}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":-7.8216544352471828E-10},null,null,{"$f":"E22/E18-1","v":-7.676852314786986E-3},"Difference between final year revenue and requirement"]
[]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C22","v":3740.815620292944}]
["High security premium (times)",null,{"$f":"Inputs!D$30","v":1.7638888888888888}]
[]
["Forecast sales quantities",null,"2014-15"]
["High Security Entitlement (ML)",null,{"$f":"Inputs!B$54","v":261400.7}]
["General Security Entitlement (ML)",null,{"$f":"Inputs!C$54","v":2075822}]
["Forecast water volumes (ML)",null,{"$f":"Inputs!D$54","v":1459688.9339000001}]
[]
[null,null,null,null,"Real Price Increase \\ (Decrease)"]
["Tariffs ($ Nominal)","2013-14","2014-15",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},{"$f":"Inputs!G$11","v":1.7017878516072777},{"$f":"C41*C31","v":1.7339727619428122},null,{"$f":"C40/(1+C$4)/B40-1","v":-1.0088891562574642E-2}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!H$11","v":1.2627916223710054},{"$f":"(C22-C30)*10^3/(C35+C34*C31)","v":0.98303967606206677},null,{"$f":"C41/(1+C$4)/B41-1","v":-0.24369198947134907}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!I$11","v":2.6935941472892257},{"$f":"C30*10^3/C36","v":2.5627484962143439},null,-7.5656964455769748E-2]
[null,null,null,null,{"$f":"C49/(1+C$4)/(SUMPRODUCT(B40:B42,C34:C36)/10^3)-1","v":-0.13443206577129052},"Average"]
[]
["Tariffs Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C40/10^3","v":453.26169375278454}]
["General Security Entitlement",null,{"$f":"C35*C41/10^3","v":2040.6153864425116}]
["Usage",null,{"$f":"C36*C42/10^3","v":3740.815620292944}]
[null,null,{"$f":"SUM(C46:C48)","v":6234.69270048824}]
["Check",null,{"$f":"ABS(C49-C22)","v":0}]
[]
[]
["Revenue Requirement  - MDBA / BCR costs",null,"2014-15","2015-16","2016-17"]
["MDBA / BCR costs ($'000 Nominal)",null,{"$f":"Inputs!B$123*C$5","v":10498.828125},{"$f":"Inputs!C$123*D$5","v":10977.657031250003},{"$f":"Inputs!D$123*E$5","v":10066.880938037113}]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C54","v":6299.296875}]
["High security premium (times)",null,{"$f":"C31","v":1.7638888888888888}]
[]
["Forecast sales quantities"]
["High Security Entitlement (ML)",null,{"$f":"C34","v":261400.7}]
["General Security Entitlement (ML)",null,{"$f":"C35","v":2075822}]
["Forecast water volumes (ML)",null,{"$f":"C36","v":1459688.9339000001}]
[]
[]
["Tariffs ($ Nominal)",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},null,{"$f":"C68*C58","v":2.919900446680157}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},null,{"$f":"(C54-C57)*10^3/(C62+C61*C58)","v":1.6553766311887506}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},null,{"$f":"C57*10^3/C63","v":4.3155063580358348}]
[]
[]
["Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C61*C67/10^3","v":763.26402069250571}]
["General Security Entitlement",null,{"$f":"C62*C68/10^3","v":3436.2672293074947}]
["Usage",null,{"$f":"C63*C69/10^3","v":6299.296875}]
[null,null,{"$f":"SUM(C73:C75)","v":10498.828125}]
["Check",null,{"$f":"ABS(C76-C54)","v":0}]
[]
[]
["Total Revenue Requirement",null,"2014-15"]
[{"$f":"A14","v":"Revenue Requirement  - State Water Costs"},null,{"$f":"C22","v":6234.69270048824}]
[{"$f":"A53","v":"Revenue Requirement  - MDBA / BCR costs"},null,{"$f":"C54","v":10498.828125}]
[null,null,{"$f":"SUM(C81:C82)","v":16733.520825488238}]
[]
[]
[null,null,null,null,"Real Price Increase \\ (Decrease)"]
["Tariffs ($ Nominal)","2013-14","2014-15",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},{"$f":"Inputs!B$11","v":3.14},{"$f":"SUM(C40,C67)","v":4.6538732086229695},null,{"$f":"C88/(1+C$4)/B88-1","v":0.43993949819006772}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!C$11","v":2.33},{"$f":"SUM(C41,C68)","v":2.6384163072508171},null,{"$f":"C89/(1+C$4)/B89-1","v":0.10013693944378521}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!D$11","v":4.97},{"$f":"SUM(C42,C69)","v":6.8782548542501782},null,0.34456319907150368]
[null,null,null,null,{"$f":"C97/(1+C$4)/(SUMPRODUCT(B88:B90,C34:C36)/10^3)-1","v":0.25906805796945709},"Average"]
[]
["Total Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C88/10^3","v":1216.5257144452903}]
["General Security Entitlement",null,{"$f":"C35*C89/10^3","v":5476.8826157500052}]
["Usage",null,{"$f":"C36*C90/10^3","v":10040.112495292942}]
[null,null,{"$f":"SUM(C94:C96)","v":16733.520825488238}]
["Check",null,{"$f":"ABS(C97-C83)","v":0}]

{"sheet":"Murrumbidgee","index":12,"n_rows":98,"n_cols":6,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[null,"Check",{"$f":"IF(D1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(ABS(B26),C50,C77,C98)","v":0}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!H86","v":2.9296875E-2},{"$f":"Inputs!C83","v":2.5499999999999998E-2},{"$f":"Inputs!D83","v":2.5499999999999998E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.029296875},{"$f":"C5*(1+D4)","v":1.0555439453125002},{"$f":"D5*(1+E4)","v":1.0824603159179691}]
["Real Vanilla WACC",null,{"$f":"Inputs!B$85","v":4.2572208678693269E-2},{"$f":"Inputs!C$85","v":4.2572208678693269E-2},{"$f":"Inputs!D$85","v":4.2572208678693269E-2}]
["Nominal Vanilla WACC",null,{"$f":"(1+C6)*(1+C4)-1","v":7.311631635482696E-2},{"$f":"(1+D6)*(1+D4)-1","v":6.9157799999999936E-2},6.9157799999999936E-2]
["Accumulated Discount rate",null,{"$f":"1/(1+C7)","v":0.93186543225510798},{"$f":"C8/(1+D7)","v":0.87158830273240118},{"$f":"D8/(1+E7)","v":0.81521016143024094}]
[]
["Target Variable / Fixed ratio (%)",null,{"$f":"Inputs!B$36","v":0.6},{"$f":"Inputs!C$36","v":0.6},{"$f":"Inputs!D$36","v":0.6}]
[]
["Murrumbidgee"]
["($'000 Nominal)"]
["Revenue Requirement  - State Water Costs",null,"2014-15","2015-16","2016-17"]
["PTRM Building block requirement (user share) - Unsmoothed",null,{"$f":"Inputs!G$97*C$5","v":9314.5534069207497},{"$f":"Inputs!H$97*D$5","v":9590.7875311840035},{"$f":"Inputs!I$97*E$5","v":9761.2780751196751}]
["ICD Rebates",null,{"$f":"Inputs!B$111*C$5","v":964.02527594115486},{"$f":"Inputs!C$111*D$5","v":945.73885397216384},{"$f":"Inputs!D$111*E$5","v":951.62808491248438}]
[]
["Total Revenue Requirement (user share) - Unsmoothed",null,{"$f":"SUM(C15:C17)","v":10278.578682861904},{"$f":"SUM(D15:D17)","v":10536.526385156167},{"$f":"SUM(E15:E17)","v":10712.90616003216}]
["NPV",{"$f":"SUMPRODUCT(C$8:E$8,C18:E18)","v":27495.035276113515}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":-3.9428700586130461E-4},{"$f":"(E18/(1+E$4))/D18-1","v":-8.5423297344954241E-3}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":10278.578682861904},{"$f":"C22*(1+D$4)*(1+D24)","v":10508.277244021587},{"$f":"D22*(1+E$4)*(1+E24)","v":10743.108949619496}]
["NPV",{"$f":"SUMPRODUCT(C$8:E$8,C22:E22)","v":27495.035276113515}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Costs Tariffs'!H77","v":-3.0742976500795802E-3},{"$f":"'SW Costs Tariffs'!I77","v":-3.0742976500795802E-3}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":0},null,null,{"$f":"E22/E18-1","v":2.8192900354169215E-3},"Difference between final year revenue and requirement"]
[]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C22","v":6167.1472097171418}]
["High security premium (times)",null,{"$f":"Inputs!D$31","v":2.3024456647398832}]
[]
["Forecast sales quantities",null,"2014-15"]
["High Security Entitlement (ML)",null,{"$f":"Inputs!B$55","v":436928}]
["General Security Entitlement (ML)",null,{"$f":"Inputs!C$55","v":2260113}]
["Forecast water volumes (ML)",null,{"$f":"Inputs!D$55","v":1759739.925}]
[]
[null,null,null,null,"Real Price Increase \\ (Decrease)"]
["Tariffs ($ Nominal)","2013-14","2014-15",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},{"$f":"Inputs!G$12","v":2.6360825366697194},{"$f":"C41*C31","v":2.898350098683951},null,{"$f":"C40/(1+C$4)/B40-1","v":6.8196585711697733E-2}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!H$12","v":1.4065004138606891},{"$f":"(C22-C30)*10^3/(C35+C34*C31)","v":1.2588136793279721},null,{"$f":"C41/(1+C$4)/B41-1","v":-0.13047727827897049}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!I$12","v":3.3437557008763554},{"$f":"C30*10^3/C36","v":3.5045787858209452},null,1.8264571660488338E-2]
[null,null,null,null,{"$f":"C49/(1+C$4)/(SUMPRODUCT(B40:B42,C34:C36)/10^3)-1","v":-2.2393951303972925E-2},"Average"]
[]
["Tariffs Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C40/10^3","v":1266.3703119177815}]
["General Security Entitlement",null,{"$f":"C35*C41/10^3","v":2845.0611612269809}]
["Usage",null,{"$f":"C36*C42/10^3","v":6167.1472097171418}]
[null,null,{"$f":"SUM(C46:C48)","v":10278.578682861904}]
["Check",null,{"$f":"ABS(C49-C22)","v":0}]
[]
[]
["Revenue Requirement  - MDBA / BCR costs",null,"2014-15","2015-16","2016-17"]
["MDBA / BCR costs ($'000 Nominal)",null,{"$f":"Inputs!B$124*C$5","v":2367.3828125},{"$f":"Inputs!C$124*D$5","v":2427.7510742187505},{"$f":"Inputs!D$124*E$5","v":2273.1666634277349}]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C54","v":1420.4296875}]
["High security premium (times)",null,{"$f":"C31","v":2.3024456647398832}]
[]
["Forecast sales quantities"]
["High Security Entitlement (ML)",null,{"$f":"C34","v":436928}]
["General Security Entitlement (ML)",null,{"$f":"C35","v":2260113}]
["Forecast water volumes (ML)",null,{"$f":"C36","v":1759739.925}]
[]
[]
["Tariffs ($ Nominal)",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},null,{"$f":"C68*C58","v":0.6675537951246765}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},null,{"$f":"(C54-C57)*10^3/(C62+C61*C58)","v":0.28993248585524939}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},null,{"$f":"C57*10^3/C63","v":0.80718159957642599}]
[]
[]
["Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C61*C67/10^3","v":291.67294459623463}]
["General Security Entitlement",null,{"$f":"C62*C68/10^3","v":655.28018040376526}]
["Usage",null,{"$f":"C63*C69/10^3","v":1420.4296875}]
[null,null,{"$f":"SUM(C73:C75)","v":2367.3828125}]
["Check",null,{"$f":"ABS(C76-C54)","v":0}]
[]
[]
["Total Revenue Requirement",null,"2014-15"]
[{"$f":"A14","v":"Revenue Requirement  - State Water Costs"},null,{"$f":"C22","v":10278.578682861904}]
[{"$f":"A53","v":"Revenue Requirement  - MDBA / BCR costs"},null,{"$f":"C54","v":2367.3828125}]
[null,null,{"$f":"SUM(C81:C82)","v":12645.961495361904}]
[]
[]
[null,null,null,null,"Real Price Increase \\ (Decrease)"]
["Tariffs ($ Nominal)","2013-14","2014-15",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},{"$f":"Inputs!B$12","v":2.98},{"$f":"SUM(C40,C67)","v":3.5659038938086276},null,{"$f":"C88/(1+C$4)/B88-1","v":0.16255287853878309}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!C$12","v":1.59},{"$f":"SUM(C41,C68)","v":1.5487461651832215},null,{"$f":"C89/(1+C$4)/B89-1","v":-5.3670310677730426E-2}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!D$12","v":3.78},{"$f":"SUM(C42,C69)","v":4.3117603853973714},null,0.10821025336759638]
[null,null,null,null,{"$f":"C97/(1+C$4)/(SUMPRODUCT(B88:B90,C34:C36)/10^3)-1","v":6.3960268353857153E-2},"Average"]
[]
["Total Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C88/10^3","v":1558.0432565140161}]
["General Security Entitlement",null,{"$f":"C35*C89/10^3","v":3500.3413416307462}]
["Usage",null,{"$f":"C36*C90/10^3","v":7587.5768972171418}]
[null,null,{"$f":"SUM(C94:C96)","v":12645.961495361904}]
["Check",null,{"$f":"ABS(C97-C83)","v":0}]

{"sheet":"Lowbidgee","index":13,"n_rows":98,"n_cols":6,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[null,"Check",{"$f":"IF(D1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(ABS(B26),C50,C77,C98)","v":0}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!H86","v":2.9296875E-2},{"$f":"Inputs!C83","v":2.5499999999999998E-2},{"$f":"Inputs!D83","v":2.5499999999999998E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.029296875},{"$f":"C5*(1+D4)","v":1.0555439453125002},{"$f":"D5*(1+E4)","v":1.0824603159179691}]
["Real Vanilla WACC",null,{"$f":"Inputs!B$85","v":4.2572208678693269E-2},{"$f":"Inputs!C$85","v":4.2572208678693269E-2},{"$f":"Inputs!D$85","v":4.2572208678693269E-2}]
["Nominal Vanilla WACC",null,{"$f":"(1+C6)*(1+C4)-1","v":7.311631635482696E-2},{"$f":"(1+D6)*(1+D4)-1","v":6.9157799999999936E-2},6.9157799999999936E-2]
["Accumulated Discount rate",null,{"$f":"1/(1+C7)","v":0.93186543225510798},{"$f":"C8/(1+D7)","v":0.87158830273240118},{"$f":"D8/(1+E7)","v":0.81521016143024094}]
[]
["Target Variable / Fixed ratio (%)",null,0,0,0]
[]
["Lowbidgee"]
["($'000 Nominal)"]
["Revenue Requirement  - State Water Costs",null,"2014-15","2015-16","2016-17"]
["PTRM Building block requirement (user share) - Unsmoothed",null,{"$f":"Inputs!G$98*C$5","v":546.3314357280459},{"$f":"Inputs!H$98*D$5","v":576.11152674007315},{"$f":"Inputs!I$98*E$5","v":657.53922354873498}]
["ICD Rebates",null,{"$f":"Inputs!B$112*C$5","v":0},{"$f":"Inputs!C$112*D$5","v":0},{"$f":"Inputs!D$112*E$5","v":0}]
[]
["Total Revenue Requirement (user share) - Unsmoothed",null,{"$f":"SUM(C15:C17)","v":546.3314357280459},{"$f":"SUM(D15:D17)","v":576.11152674007315},{"$f":"SUM(E15:E17)","v":657.53922354873498}]
["NPV",{"$f":"SUMPRODUCT(C$8:E$8,C18:E18)","v":1547.2721038611016}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":2.8287862285922394E-2},{"$f":"(E18/(1+E$4))/D18-1","v":0.11295969039678577}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":546.3314357280459},{"$f":"C22*(1+D$4)*(1+D24)","v":591.71131781881593},{"$f":"D22*(1+E$4)*(1+E24)","v":640.86058523852626}]
["NPV",{"$f":"SUMPRODUCT(C$8:E$8,C22:E22)","v":1547.2721038611012}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Costs Tariffs'!K77","v":5.6131561076737828E-2},{"$f":"'SW Costs Tariffs'!L77","v":5.6131561076737828E-2}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":0},null,null,{"$f":"E22/E18-1","v":-2.5365237103566529E-2},"Difference between final year revenue and requirement"]
[]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C22","v":0}]
["High security premium (times)",null,{"$f":"Inputs!D$32","v":0}]
[]
["Forecast sales quantities",null,"2014-15"]
["High Security Entitlement (ML)",null,{"$f":"Inputs!B$56","v":0}]
["General Security Entitlement (ML)",null,{"$f":"Inputs!C$56","v":747000}]
["Forecast water volumes (ML)",null,{"$f":"Inputs!D$56","v":0}]
[]
[]
["Tariffs ($ Nominal)",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},null,{"$f":"C41*C31","v":0}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},null,{"$f":"(C22-C30)*10^3/(C35+C34*C31)","v":0.73136738383941879}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},null,0]
[]
[]
["Tariffs Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C40/10^3","v":0}]
["General Security Entitlement",null,{"$f":"C35*C41/10^3","v":546.3314357280459}]
["Usage",null,{"$f":"C36*C42/10^3","v":0}]
[null,null,{"$f":"SUM(C46:C48)","v":546.3314357280459}]
["Check",null,{"$f":"ABS(C49-C22)","v":0}]
[]
[]
["Revenue Requirement  - MDBA / BCR costs",null,"2014-15","2015-16","2016-17"]
["MDBA / BCR costs ($'000 Nominal)",null,{"$f":"Inputs!B$125*C$5","v":0},{"$f":"Inputs!C$125*D$5","v":0},{"$f":"Inputs!D$125*E$5","v":0}]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C54","v":0}]
["High security premium (times)",null,{"$f":"C31","v":0}]
[]
["Forecast sales quantities"]
["High Security Entitlement (ML)",null,{"$f":"C34","v":0}]
["General Security Entitlement (ML)",null,{"$f":"C35","v":747000}]
["Forecast water volumes (ML)",null,{"$f":"C36","v":0}]
[]
[]
["Tariffs ($ Nominal)",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},null,{"$f":"C68*C58","v":0}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},null,{"$f":"(C54-C57)*10^3/(C62+C61*C58)","v":0}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},null,0]
[]
[]
["Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C61*C67/10^3","v":0}]
["General Security Entitlement",null,{"$f":"C62*C68/10^3","v":0}]
["Usage",null,{"$f":"C63*C69/10^3","v":0}]
[null,null,{"$f":"SUM(C73:C75)","v":0}]
["Check",null,{"$f":"ABS(C76-C54)","v":0}]
[]
[]
["Total Revenue Requirement",null,"2014-15"]
[{"$f":"A14","v":"Revenue Requirement  - State Water Costs"},null,{"$f":"C22","v":546.3314357280459}]
[{"$f":"A53","v":"Revenue Requirement  - MDBA / BCR costs"},null,{"$f":"C54","v":0}]
[null,null,{"$f":"SUM(C81:C82)","v":546.3314357280459}]
[]
[]
[]
["Tariffs ($ Nominal)",null,"2014-15"]
[{"$f":"Inputs!B$3","v":"High Security Entitlement ($/ML)"},null,{"$f":"SUM(C40,C67)","v":0}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},null,{"$f":"SUM(C41,C68)","v":0.73136738383941879}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},null,{"$f":"SUM(C42,C69)","v":0}]
[]
[]
["Total Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C88/10^3","v":0}]
["General Security Entitlement",null,{"$f":"C35*C89/10^3","v":546.3314357280459}]
["Usage",null,{"$f":"C36*C90/10^3","v":0}]
[null,null,{"$f":"SUM(C94:C96)","v":546.3314357280459}]
["Check",null,{"$f":"ABS(C97-C83)","v":0}]

{"sheet":"Fish River","index":14,"n_rows":274,"n_cols":6,"rows_kept":274,"cut":false,"hidden":false,"merged":[]}
[null,"Check",{"$f":"IF(D1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(ABS(B26),C197,C217,C224,C230,D204,D205,D209,D210,)","v":3.3069227356463671E-9}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!H86","v":2.9296875E-2},{"$f":"Inputs!C83","v":2.5499999999999998E-2},{"$f":"Inputs!D83","v":2.5499999999999998E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.029296875},{"$f":"C5*(1+D4)","v":1.0555439453125002},{"$f":"D5*(1+E4)","v":1.0824603159179691}]
["Nominal Vanilla WACC",null,{"$f":"(1+Inputs!B$85)*(1+C4)-1","v":7.311631635482696E-2},{"$f":"(1+Inputs!C$85)*(1+D4)-1","v":6.9157799999999936E-2},{"$f":"(1+Inputs!D$85)*(1+E4)-1","v":6.9157799999999936E-2}]
["Accumulated Discount rate",null,{"$f":"1/(1+C6)","v":0.93186543225510798},{"$f":"C7/(1+D6)","v":0.87158830273240118},{"$f":"D7/(1+E6)","v":0.81521016143024094}]
["Raw Water /Filtered Water (%)",null,{"$f":"Inputs!B39","v":0.8},{"$f":"Inputs!C39","v":0.8},{"$f":"Inputs!D39","v":0.8}]
["Target Variable / Fixed ratio (%)"]
["Raw Water",null,{"$f":"Inputs!B41","v":0.45},{"$f":"Inputs!C41","v":0.45},{"$f":"Inputs!D41","v":0.45}]
["Filtered Water",null,{"$f":"Inputs!B42","v":0.4},{"$f":"Inputs!C42","v":0.4},{"$f":"Inputs!D42","v":0.4}]
["Fish River"]
["($'000 Nominal)"]
["Revenue Requirement",null,"2014-15","2015-16","2016-17"]
["PTRM Building block requirement (user share) - Unsmoothed",null,{"$f":"Inputs!G$99*C$5","v":9721.3998447510858},{"$f":"Inputs!H$99*D$5","v":10091.513513660269},{"$f":"Inputs!I$99*E$5","v":10435.621395434238}]
["ICD Rebates",null,{"$f":"Inputs!B$113*C$5","v":0},{"$f":"Inputs!C$113*D$5","v":0},{"$f":"Inputs!D$113*E$5","v":0}]
[]
["Total Revenue Requirement (user share) - Unsmoothed",null,{"$f":"SUM(C15:C17)","v":9721.3998447510858},{"$f":"SUM(D15:D17)","v":10091.513513660269},{"$f":"SUM(E15:E17)","v":10435.621395434238}]
["NPV",{"$f":"SUMPRODUCT(C$7:E$7,C18:E18)","v":26361.906206222779}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":1.2259439231983915E-2},{"$f":"(E18/(1+E$4))/D18-1","v":8.3849230999251123E-3}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":9721.3998447510858},{"$f":"C22*(1+D$4)*(1+D24)","v":10078.760045966115},{"$f":"D22*(1+E$4)*(1+E24)","v":10449.256864895864}]
["NPV",{"$f":"SUMPRODUCT(C$7:E$7,C22:E22)","v":26361.906206222266}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Costs Tariffs'!N77","v":1.0980164518743507E-2},{"$f":"'SW Costs Tariffs'!O77","v":1.0980164518743507E-2}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":5.1295501179993153E-10},null,null,{"$f":"E22/E18-1","v":1.3066274584847548E-3},"Difference between final year revenue and requirement"]
[]
[]
["Tariff Revenue"]
["Tariff quantities (ML)","2013-14","2014-15"]
["BULK RAW WATER"]
["   Minimum Annual Quantity (MAQ)  ",null," "]
["   - Delta Electricity",{"$f":"C33","v":8184},{"$f":"Inputs!B62","v":8184}]
["   - Sydney Catchment Authority",{"$f":"C34","v":3650},{"$f":"Inputs!B63","v":3650}]
["   - Oberon Council",750,{"$f":"Inputs!B64","v":1064}]
["   - Individual Minor Customers",{"$f":"41.4","v":41.4},{"$f":"Inputs!B65","v":200}]
[]
["  Number of Minor Customers",null,{"$f":"Inputs!B66","v":74}]
[]
["  Usage "]
["   - Delta Electricity",{"$f":"C41","v":6189.8481999999995},{"$f":"Inputs!B68","v":6189.8481999999995}]
["   - Sydney Catchment Authority",2411.6287499999999,{"$f":"Inputs!B69","v":2411.6287499999999}]
["   - Oberon Council",717.08692000000008,{"$f":"Inputs!B70","v":717.08692000000008}]
["   - Individual Minor Customers",52.092876230661034,{"$f":"Inputs!B71","v":52.092876230661034}]
[]
["  BULK FILTERED WATER"]
["   Minimum Annual Quantity (MAQ)  "]
["   - Lithgow Council",2092,{"$f":"Inputs!B74","v":1778}]
["   - Individual Minor Customers",{"$f":"13.4","v":13.4},{"$f":"Inputs!B75","v":200}]
[]
["  Number of Minor Customers",null,{"$f":"Inputs!B76","v":208}]
[]
["  Usage "]
["   - Lithgow Council",{"$f":"C54","v":985.50049999999987},{"$f":"Inputs!B78","v":985.50049999999987}]
["   - Individual Minor Customers",131.80557665260199,{"$f":"Inputs!B79","v":131.80557665260199}]
[]
[]
["Tariff Revenue",null,null,null,"Real Price Increase \\ (Decrease)"]
["BULK RAW WATER",{"$f":"B$30","v":"2013-14"},{"$f":"C$30","v":"2014-15"},null,{"$f":"C59","v":"2014-15"}]
["Raw Water: Major customer Minimum Annual Quantity (MAQ) access charge"]
["Delta "]
["Price $",{"$f":"Inputs!$B$17","v":0.38},{"$f":"C266/SUM(C63,C67,C71,C76)","v":0.33125394427935673},null,{"$f":"C62/(1+C$4)/B62-1","v":-0.1530908844950033}]
["Quantity (per kL) ",{"$f":"B33*10^3","v":8184000},{"$f":"C33*10^3","v":8184000}]
["Revenue  $",{"$f":"B62*B63","v":3109920},{"$f":"C62*C63","v":2710982.2799822553}]
["Sydney Catchment"]
["Price $",{"$f":"Inputs!$B$17","v":0.38},{"$f":"C$62","v":0.33125394427935673}]
["Quantity (per kL) ",{"$f":"B34*10^3","v":3650000},{"$f":"C34*10^3","v":3650000}]
["Revenue  $",{"$f":"B66*B67","v":1387000},{"$f":"C66*C67","v":1209076.8966196522}]
["Oberon Council"]
["Price $",{"$f":"Inputs!$B$17","v":0.38},{"$f":"C$62","v":0.33125394427935673}]
["Quantity (per kL) ",{"$f":"B35*10^3","v":750000},{"$f":"C35*10^3","v":1064000}]
["Revenue  $",{"$f":"B70*B71","v":285000},{"$f":"C70*C71","v":352454.19671323558}]
[]
["Raw Water: Individual Minor Customer access charge"]
["Price $ (Annual Service Charge 2014-15 onwards)",{"$f":"Inputs!$B$18","v":0.47},{"$f":"C62*C36","v":66.250788855871349}]
["Quantity (per unit) ",{"$f":"B36*10^3","v":41400},{"$f":"C36*C38","v":14800}]
["Number of Minor Customers",null,{"$f":"C38","v":74}]
["Revenue  $",{"$f":"B75*B76","v":19458},{"$f":"C75*C77","v":4902.5583753344799}]
[]
["Sub total",{"$f":"SUM(B64,B68,B72,B78)","v":4801378},{"$f":"SUM(C64,C68,C72,C78)","v":4277415.9316904768}]
[]
["Raw Water:  Usage up to MAQ",{"$f":"B$30","v":"2013-14"},{"$f":"C$30","v":"2014-15"}]
["Delta "]
["Price $",{"$f":"Inputs!$C$17","v":0.43},{"$f":"(C265-C109)/SUM(C85,C89,C93,C98,C103)","v":0.37215646952047915},null,{"$f":"C84/(1+C$4)/B84-1","v":-0.15915399852396039}]
["Quantity (per kL) ",{"$f":"MIN(B41,B33)*10^3","v":6189848.1999999993},{"$f":"MIN(C41,C33)*10^3","v":6189848.1999999993}]
["Revenue  $",{"$f":"B84*B85","v":2661634.7259999998},{"$f":"C84*C85","v":2303592.0529796924}]
["Sydney Catchment"]
["Price $",{"$f":"Inputs!$C$17","v":0.43},{"$f":"C$84","v":0.37215646952047915}]
["Quantity (per kL) ",{"$f":"MIN(B42,B34)*10^3","v":2411628.75},{"$f":"MIN(C42,C34)*10^3","v":2411628.75}]
["Revenue  $",{"$f":"B88*B89","v":1037000.3624999999},{"$f":"C88*C89","v":897503.24139408628}]
["Oberon Council"]
["Price $",{"$f":"Inputs!$C$17","v":0.43},{"$f":"C$84","v":0.37215646952047915}]
["Quantity (per kL) ",{"$f":"MIN(B43,B35)*10^3","v":717086.92},{"$f":"MIN(C43,C35)*10^3","v":717086.92}]
["Revenue  $",{"$f":"B92*B93","v":308347.37560000003},{"$f":"C92*C93","v":266868.53648651426}]
[]
["Individual Minor Customer tier 1"]
["Price $",{"$f":"Inputs!$C$18","v":0.85},{"$f":"C$84","v":0.37215646952047915}]
["Quantity (per kL) ",{"$f":"MIN(B44,B36)*10^3","v":41400},{"$f":"C36*C38","v":14800}]
["Revenue  $",{"$f":"B97*B98","v":35190},{"$f":"C97*C98","v":5507.9157489030913}]
[]
["Individual Minor Customer tier 2"]
["Price $",null,{"$f":"C97","v":0.37215646952047915}]
["Quantity (per unit) ",null,{"$f":"C44*10^3-C98","v":37292.876230661037}]
["Revenue  $",null,{"$f":"C102*C103","v":13878.785156267006}]
[]
["Raw Water: Individual Minor Customer access charge in excess of deemed MAQ"]
["Price $",null,{"$f":"C$62","v":0.33125394427935673}]
["Quantity (per unit) ",null,{"$f":"C44*10^3-C76","v":37292.876230661037}]
["Revenue  $",null,{"$f":"C107*C108","v":12353.412344928338}]
[]
["Tier 2 usage charge",null,{"$f":"SUM(C102,C107)","v":0.70341041379983582}]
["Quantity (kL)",null,{"$f":"C108","v":37292.876230661037}]
["Revenue",null,{"$f":"C111*C112","v":26232.19750119534}]
[]
["Sub total",{"$f":"SUM(B86,B90,B94,B99,B113)","v":4042172.4640999995},{"$f":"SUM(C86,C90,C94,C99,C113)","v":3499703.9441103912}]
[]
["Raw Water: Usage in excess of MAQ",{"$f":"B$30","v":"2013-14"},{"$f":"C$30","v":"2014-15"}]
["Delta "]
["Price $",{"$f":"Inputs!$D$17","v":0.81}]
["Quantity (per kL) ",{"$f":"MAX(B41-B33,0)*10^3","v":0}]
["Revenue  $",{"$f":"B119*B120","v":0}]
["Sydney Catchment"]
["Price $",{"$f":"Inputs!$D$17","v":0.81}]
["Quantity (per kL) ",{"$f":"MAX(B42-B34,0)*10^3","v":0}]
["Revenue  $",{"$f":"B123*B124","v":0}]
["Oberon Council"]
["Price $",{"$f":"Inputs!$D$17","v":0.81}]
["Quantity (per kL) ",{"$f":"MAX(B43-B35,0)*10^3","v":0}]
["Revenue  $",{"$f":"B127*B128","v":0}]
[]
["Individual Minor Customer"]
["Price $",{"$f":"Inputs!$D$18","v":1.33}]
["Quantity (per kL) ",{"$f":"MAX(B44-B36,0)*10^3","v":10692.876230661035}]
["Revenue  $",{"$f":"B132*B133","v":14221.525386779178}]
[]
["Sub total",{"$f":"SUM(B120,B124,B128,B134)","v":14221.525386779178},{"$f":"SUM(C120,C124,C128,C134)","v":0}]
[]
["Total Raw Water Revenue",{"$f":"SUM(B80,B115,B136)","v":8857771.9894867782},{"$f":"SUM(C80,C115,C136)","v":7777119.8758008685}]
[]
[]
[]
[]
["  BULK FILTERED WATER",{"$f":"B$30","v":"2013-14"},{"$f":"C$30","v":"2014-15"}]
["Filtered Water: Minimum Annual Quantity (MAQ)"]
["Lithgow Council"]
["Price $",{"$f":"Inputs!$B$19","v":0.56999999999999995},{"$f":"C271/SUM(C147,C151)","v":0.64111232214230041},null,{"$f":"C146/(1+C$4)/B146-1","v":9.2744461988940374E-2}]
["Quantity (per kL) ",{"$f":"B48*10^3","v":2092000},{"$f":"C48*10^3","v":1778000}]
["Revenue  $",{"$f":"B146*B147","v":1192440},{"$f":"C146*C147","v":1139897.7087690101}]
["Filtered Water: Individual Minor Customer access charge"]
["Price $ (Annual Service Charge 2014-15 onwards)",{"$f":"Inputs!$B$20","v":0.67331362349999979},{"$f":"C146*C49","v":128.22246442846009}]
["Quantity (per kL) ",{"$f":"B49*10^3","v":13400},{"$f":"C49*C51","v":41600}]
["Number of Minor Customers",null,{"$f":"C51","v":208}]
["Revenue  $",{"$f":"B150*B151","v":9022.402554899998},{"$f":"C150*C152","v":26670.272601119697}]
[]
["Sub total",{"$f":"SUM(B148,B153)","v":1201462.4025548999},{"$f":"SUM(C148,C153)","v":1166567.9813701299}]
[]
["Usage up to MAQ",{"$f":"B$30","v":"2013-14"},{"$f":"C$30","v":"2014-15"}]
["Lithgow Council"]
["Price $",{"$f":"Inputs!$C$19","v":0.61},{"$f":"(C270-C174)/SUM(C160,C164,C168)","v":0.64429979922679725},null,{"$f":"C159/(1+C$4)/B159-1","v":2.6165729940959226E-2}]
["Quantity (per kL) ",{"$f":"MIN(B54,B48)*10^3","v":985500.49999999988},{"$f":"MIN(C54,C48)*10^3","v":985500.49999999988}]
["Revenue  $",{"$f":"B159*B160","v":601155.30499999993},{"$f":"C159*C160","v":634957.77428790822}]
["Individual Minor Customer tier 1"]
["Price $",{"$f":"Inputs!$C$20","v":1.04},{"$f":"C$159","v":0.64429979922679725}]
["Quantity (per kL) ",{"$f":"MIN(B55,B49)*10^3","v":13400},{"$f":"C49*C51","v":41600}]
["Revenue  $",{"$f":"B163*B164","v":13936},{"$f":"C163*C164","v":26802.871647834767}]
["Individual Minor Customer tier 2"]
["Price $",null,{"$f":"C163","v":0.64429979922679725}]
["Quantity (per kL) ",null,{"$f":"C55*10^3-C164","v":90205.576652601972}]
["Revenue  $",null,{"$f":"C167*C168","v":58119.434926408918}]
[]
["FIltered Water: Individual Minor Customer access charge in excess of deemed MAQ"]
["Price $",null,{"$f":"C146","v":0.64111232214230041}]
["Quantity (per unit) ",null,{"$f":"C55*10^3-C151","v":90205.576652601972}]
["Revenue  $",null,{"$f":"C172*C173","v":57831.906717934929}]
[]
["Tier 2 usage charge",null,{"$f":"SUM(C167,C172)","v":1.2854121213690977}]
["Quantity (kL)",null,{"$f":"C173","v":90205.576652601972}]
["Revenue",null,{"$f":"C176*C177","v":115951.34164434385}]
[]
["Sub total",{"$f":"SUM(B161,B165,B178)","v":615091.30499999993},{"$f":"SUM(C161,C165,C178)","v":777711.9875800868}]
[]
["Usage in excess of MAQ",{"$f":"B$30","v":"2013-14"},{"$f":"C$30","v":"2014-15"}]
["Lithgow Council"]
["Price $",{"$f":"Inputs!$D$19","v":1.18}]
["Quantity (per kL) ",{"$f":"MAX(B54-B48,0)*10^3","v":0}]
["Revenue  $",{"$f":"B184*B185","v":0}]
["Individual Minor Customer"]
["Price $",{"$f":"Inputs!$D$20","v":1.71}]
["Quantity (per kL) ",{"$f":"MAX(B55-B49,0)*10^3","v":118405.57665260197}]
["Revenue  $",{"$f":"B188*B189","v":202473.53607594938}]
[]
["Sub total",{"$f":"SUM(B186,B190)","v":202473.53607594938},{"$f":"SUM(C186,C190)","v":0}]
[]
["Total Filtered Water Revenue",{"$f":"SUM(B155,B180,B192)","v":2019027.2436308493},{"$f":"SUM(C155,C180,C192)","v":1944279.9689502167}]
[]
["Total revenue ",{"$f":"SUM(B138,B194)","v":10876799.233117627},{"$f":"SUM(C138,C194)","v":9721399.8447510861},null,{"$f":"C196/(1+C$4)/B196-1","v":-0.13166553349082355},"Average Real Price Increase \\ (Decrease)"]
["Check",null,{"$f":"ABS(C196/10^3-C22)","v":0}]
[]
[]
[]
[]
[]
["BULK RAW WATER",{"$f":"B$30","v":"2013-14"},{"$f":"C$30","v":"2014-15"},"Check"]
["Minimum Annual Quantity (MAQ) access charge",{"$f":"B80","v":4801378},{"$f":"C80","v":4277415.9316904768},{"$f":"ABS(C204-C266)","v":9.3132257461547852E-10}]
["Usage",{"$f":"SUM(B115,B136)","v":4056393.9894867786},{"$f":"SUM(C115,C136)","v":3499703.9441103912},{"$f":"ABS(C205-C265)","v":0}]
[null,{"$f":"SUM(B204:B205)","v":8857771.9894867782},{"$f":"SUM(C204:C205)","v":7777119.8758008685}]
[]
["BULK FILTERED WATER",{"$f":"B$30","v":"2013-14"},{"$f":"C$30","v":"2014-15"}]
["Minimum Annual Quantity (MAQ) access charge",{"$f":"B155","v":1201462.4025548999},{"$f":"C155","v":1166567.9813701299},{"$f":"ABS(C209-C271)","v":0}]
["Usage",{"$f":"SUM(B180,B192)","v":817564.84107594937},{"$f":"SUM(C180,C192)","v":777711.9875800868},{"$f":"ABS(C210-C270)","v":0}]
[null,{"$f":"SUM(B209:B210)","v":2019027.2436308493},1944279.9689502167]
[]
["Total",{"$f":"B$30","v":"2013-14"},{"$f":"C$30","v":"2014-15"}]
["Minimum Annual Quantity (MAQ) access charge",{"$f":"SUM(B204,B209)","v":6002840.4025548995},{"$f":"SUM(C204,C209)","v":5443983.9130606065}]
["Usage",{"$f":"SUM(B205,B210)","v":4873958.8305627275},4277415.9316904778]
[null,{"$f":"SUM(B214:B215)","v":10876799.233117627},{"$f":"SUM(C214:C215)","v":9721399.8447510842}]
["Check",{"$f":"ABS(B196-B216)","v":0},{"$f":"ABS(C196-C216)","v":1.862645149230957E-9}]
[]
[]
[null,{"$f":"B$30","v":"2013-14"},{"$f":"C$30","v":"2014-15"}]
["Usage",{"$f":"SUM(B222:B223)","v":0.44810598468366697},{"$f":"SUM(C222:C223)","v":0.44000000000000011}]
[{"$f":"A$203","v":"BULK RAW WATER"},{"$f":"B205/B$216","v":0.3729400444513023},{"$f":"C205/C$216","v":0.3600000000000001}]
[{"$f":"A$208","v":"BULK FILTERED WATER"},{"$f":"B210/B$216","v":7.516594023236467E-2},{"$f":"C210/C$216","v":0.08}]
["Check",{"$f":"B215/B216-B221","v":0},{"$f":"C215/C216-C221","v":0}]
[]
[null,{"$f":"B$30","v":"2013-14"},{"$f":"C$30","v":"2014-15"}]
[{"$f":"A$204","v":"Minimum Annual Quantity (MAQ) access charge"},{"$f":"SUM(B228:B229)","v":0.55189401531633309},{"$f":"SUM(C228:C229)","v":0.55999999999999994}]
[{"$f":"A$203","v":"BULK RAW WATER"},{"$f":"B204/B$216","v":0.4414329893467912},{"$f":"C204/C$216","v":0.44}]
[{"$f":"A$208","v":"BULK FILTERED WATER"},{"$f":"B209/B$216","v":0.11046102596954192},{"$f":"C209/C$216","v":0.11999999999999997}]
["Check",{"$f":"B214/B216-B227","v":0},{"$f":"C214/C216-C227","v":0}]
[]
[null,{"$f":"B$30","v":"2013-14"},{"$f":"C$30","v":"2014-15"}]
["Total Revenue",{"$f":"SUM(B234:B235)","v":1},{"$f":"SUM(C234:C235)","v":1}]
[{"$f":"A$203","v":"BULK RAW WATER"},{"$f":"SUM(B222,B228)","v":0.81437303379809345},{"$f":"SUM(C222,C228)","v":0.8}]
[{"$f":"A$208","v":"BULK FILTERED WATER"},{"$f":"SUM(B223,B229)","v":0.18562696620190661},{"$f":"SUM(C223,C229)","v":0.19999999999999996}]
[]
[]
[]
[]
["Target (%) 2014-15",{"$f":"B$30","v":"2013-14"},{"$f":"C$30","v":"2014-15"}]
[{"$f":"A$221","v":"Usage"},{"$f":"B221","v":0.44810598468366697},{"$f":"SUM(C242:C243)","v":0.44000000000000006}]
[{"$f":"A$203","v":"BULK RAW WATER"},{"$f":"B222","v":0.3729400444513023},{"$f":"C255*C250","v":0.36000000000000004}]
[{"$f":"A$208","v":"BULK FILTERED WATER"},{"$f":"B223","v":7.516594023236467E-2},{"$f":"C259*C251","v":7.9999999999999988E-2}]
[]
[{"$f":"A$204","v":"Minimum Annual Quantity (MAQ) access charge"},{"$f":"B227","v":0.55189401531633309},{"$f":"SUM(C246:C247)","v":0.56000000000000005}]
[{"$f":"A$203","v":"BULK RAW WATER"},{"$f":"B228","v":0.4414329893467912},{"$f":"C256*C250","v":0.44000000000000006}]
[{"$f":"A$208","v":"BULK FILTERED WATER"},{"$f":"B229","v":0.11046102596954192},{"$f":"C260*C251","v":0.11999999999999997}]
[]
["Total Revenue",{"$f":"B233","v":1},{"$f":"SUM(C250:C251)","v":1}]
[{"$f":"A$203","v":"BULK RAW WATER"},{"$f":"B234","v":0.81437303379809345},{"$f":"C8","v":0.8}]
[{"$f":"A$208","v":"BULK FILTERED WATER"},{"$f":"B235","v":0.18562696620190661},{"$f":"1-C250","v":0.19999999999999996}]
[]
[]
[{"$f":"A$203","v":"BULK RAW WATER"}]
[{"$f":"A$221","v":"Usage"},{"$f":"B205/B206","v":0.4579474380579317},{"$f":"C10","v":0.45}]
[{"$f":"A$204","v":"Minimum Annual Quantity (MAQ) access charge"},{"$f":"B204/B206","v":0.54205256194206841},{"$f":"1-C255","v":0.55000000000000004}]
[]
[{"$f":"A$208","v":"BULK FILTERED WATER"}]
[{"$f":"A$221","v":"Usage"},{"$f":"B210/B211","v":0.40493006899981665},{"$f":"C11","v":0.4}]
[{"$f":"A$204","v":"Minimum Annual Quantity (MAQ) access charge"},{"$f":"B209/B211","v":0.59506993100018335},{"$f":"1-C259","v":0.6}]
[]
[]
["Target Revenue",{"$f":"B$30","v":"2013-14"},{"$f":"C$30","v":"2014-15"}]
[{"$f":"A$203","v":"BULK RAW WATER"}]
[{"$f":"A$221","v":"Usage"},{"$f":"B205","v":4056393.9894867786},{"$f":"C242*C$22*10^3","v":3499703.9441103912}]
[{"$f":"A$204","v":"Minimum Annual Quantity (MAQ) access charge"},{"$f":"B204","v":4801378},{"$f":"C246*C$22*10^3","v":4277415.9316904778}]
[null,{"$f":"SUM(B265:B266)","v":8857771.9894867782},{"$f":"SUM(C265:C266)","v":7777119.8758008685}]
[]
[{"$f":"A$208","v":"BULK FILTERED WATER"}]
[{"$f":"A$221","v":"Usage"},{"$f":"B210","v":817564.84107594937},{"$f":"C243*C$22*10^3","v":777711.9875800868}]
[{"$f":"A$204","v":"Minimum Annual Quantity (MAQ) access charge"},{"$f":"B209","v":1201462.4025548999},{"$f":"C247*C$22*10^3","v":1166567.9813701299}]
[null,{"$f":"SUM(B270:B271)","v":2019027.2436308493},{"$f":"SUM(C270:C271)","v":1944279.9689502167}]
[]
["Total Revenue",{"$f":"SUM(B267,B272)","v":10876799.233117627},{"$f":"SUM(C267,C272)","v":9721399.8447510861}]