{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Inputs","Demand and Allocations data","ACCC Draft Decision Tariffs","SW Full-Cost Tariffs","Border","Gwydir","Namoi","Peel - cost reflective tariffs","Peel - 10% price cap","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":10,"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}]
[]
[]
["Forecast water entitlements and usage "]
[null,"High Security Entitlement (ML)","General Security Entitlement (ML)","Forecast water volumes (ML)",null,"High Security Entitlement (ML)","General Security Entitlement (ML)","Total Entitlements","% High security","% General security"]
[null,"2014-15","2014-15","2014-15",null,"2014-15","2014-15","2014-15"]
["Border ",3122,263238,{"$f":"'Demand and Allocations data'!C$35","v":140676.93950000001},null,3122,263238,{"$f":"SUM(F48:G48)","v":266360},{"$f":"F48/H48","v":1.1720979125994894E-2},{"$f":"G48/H48","v":0.9882790208740051}]
["Gwydir ",21457.9,509665,{"$f":"'Demand and Allocations data'!D$35","v":245876.74050000001},null,21457.9,509665,{"$f":"SUM(F49:G49)","v":531122.9},{"$f":"F49/H49","v":4.0401006998568509E-2},{"$f":"G49/H49","v":0.95959899300143148}]
["Namoi ",8881,256076,{"$f":"'Demand and Allocations data'!E$35","v":158960.9705},null,8881,256076,264957,3.3518646421872231E-2,0.96648135357812781]
["Peel",17382,30528,{"$f":"'Demand and Allocations data'!F$35","v":11163.91},null,17382,30528,47910,0.36280525986224171,0.63719474013775834]
["Lachlan",60745,632837,{"$f":"'Demand and Allocations data'!G$35","v":227697.17900000006},null,60745,632837,693582,8.7581569302548221E-2,0.91241843069745177]
["Macquarie",42606,631716,{"$f":"'Demand and Allocations data'!H$35","v":279670.66850000003},null,42606,631716,674322,6.3183464279676471E-2,0.93681653572032353]
["Murray ",261400.7,2075822,{"$f":"'Demand and Allocations data'!I$35","v":1459688.9339000001},null,261400.7,2075822,2337222.7000000002,0.11184244445341045,0.88815755554658948]
["Murrumbidgee",436928,2260113,{"$f":"'Demand and Allocations data'!J$35","v":1759739.925},null,436928,2260113,2697041,0.16200272817506298,0.837997271824937]
["Lowbidgee",0,747000,0,null,0,747000,747000,0,1]
[null,null,null,null,null,{"$f":"SUM(F48:F56)","v":852522.6},{"$f":"SUM(G48:G56)","v":7406995},8259517.5999999996,0.10321699659553968,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"]
["CPI Forecast",2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
["Nominal Vanilla WACC",7.4364600000000003E-2,7.4364600000000003E-2,7.4364600000000003E-2]
[]
[]
[]
["PTRM Building block requirement (user share)"]
["Unsmoothed ($'000 Nominal)","2014-15","2015-16","2016-17"]
["Border ",1549.5745969404561,1581.1579112188911,1603.9696085642925]
["Gwydir ",5105.6603994842471,5436.2333015825243,5816.4767188425412]
["Namoi ",5597.1692216211313,5805.8042592758547,5942.6756674129792]
["Peel",1371.6056882848941,1424.6060695110673,1457.2605831500264]
["Lachlan",7122.8222354706295,7610.4056612214335,8160.2641431053189]
["Macquarie",7030.3594397776315,7355.8047259259847,7821.8893224368585]
["Murray ",5417.1286275939538,5449.1673145676987,5580.8846552357691]
["Murrumbidgee",9627.5113924267371,9947.882480512968,10041.31419460198]
["Lowbidgee",544.05073284378193,582.03238789645786,649.3833617843992]
["Fish River",10171.162262431115,10516.696630717028,10821.389953733642]
[]
[]
["Other Costs"]
["ICD Rebates ($'000 Real 2013-14)","2014-15","2015-16","2016-17"]
["Border ",0,0,0]
["Gwydir ",0,0,0]
["Namoi ",0,0,0]
["Peel",0,0,0]
["Lachlan",68.153721672931482,62.360347724217938,59.988200702095938]
["Macquarie",0,0,0]
["Murray ",1031.1924099891594,961.86143801572246,932.81928104576673]
["Murrumbidgee",509.91774771189233,469.30450115227194,452.46590710135524]
["Lowbidgee",0,0,0]
["Fish River",0,0,0]
[]
[]
["MDBA / BCR costs ($'000 Real 2013-14)","2014-15"]
["Border ",0]
["Gwydir ",0]
["Namoi ",0]
["Peel",0]
["Lachlan",0]
["Macquarie",0]
["Murray ",0]
["Murrumbidgee",0]
["Lowbidgee",0]
["Fish River",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,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],[4,26,4,27],[4,34,4,35],[3,24,3,25],[3,26,3,27],[3,30,3,35]]}
[]
[]
[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":"ACCC Draft Decision Tariffs","index":2,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[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],[40,1,40,3],[40,5,40,7],[40,9,40,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],[102,1,102,4],[102,6,102,9],[102,11,102,14],[127,1,127,4],[109,1,109,4],[109,6,109,9],[109,11,109,14],[120,1,120,4],[120,6,120,9],[120,11,120,14]]}
["ACCC Draft Decision Tariffs","Check",{"$f":"IF(D1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(Border!D1,Gwydir!D1,Namoi!D1,'Peel - cost reflective tariffs'!D1,Lachlan!D1,Macquarie!D1,Murray!D1,Murrumbidgee!D1,Lowbidgee!D1,'Fish River'!D1)","v":2.5386270863236859E-9}]
[]
[null,"2014-15","2015-16","2016-17"]
["CPI Forecast",{"$f":"Inputs!B83","v":2.5000000000000001E-2},{"$f":"Inputs!C83","v":2.5000000000000001E-2},{"$f":"Inputs!D83","v":2.5000000000000001E-2}]
["CPI Index",{"$f":"1+B4","v":1.0249999999999999},{"$f":"B5*(1+C4)","v":1.0506249999999999},{"$f":"C5*(1+D4)","v":1.0768906249999999}]
[]
[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 Full-Cost Tariffs'!B10)","v":6.750221884638802},{"$f":"SUM('SW Full-Cost Tariffs'!C10)","v":6.8746297866899004},{"$f":"SUM('SW Full-Cost Tariffs'!D10)","v":7.0013305505694339},null,{"$f":"SUM('SW Full-Cost Tariffs'!F10)","v":2.2745790731290318},{"$f":"SUM('SW Full-Cost Tariffs'!G10)","v":2.316500007784716},{"$f":"SUM('SW Full-Cost Tariffs'!H10)","v":2.3591935534184785},null,{"$f":"SUM('SW Full-Cost Tariffs'!J10)","v":6.6090772337585131},{"$f":"SUM('SW Full-Cost Tariffs'!K10)","v":6.7308838124454553},{"$f":"SUM('SW Full-Cost Tariffs'!L10)","v":6.8549353100653514}]
["Gwydir ",{"$f":"SUM('SW Full-Cost Tariffs'!B11)","v":13.912599581588532},{"$f":"SUM('SW Full-Cost Tariffs'!C11)","v":14.837418424412627},{"$f":"SUM('SW Full-Cost Tariffs'!D11)","v":15.823713189621088},null,{"$f":"SUM('SW Full-Cost Tariffs'!F11)","v":3.4213237896106867},{"$f":"SUM('SW Full-Cost Tariffs'!G11)","v":3.6487510715847598},{"$f":"SUM('SW Full-Cost Tariffs'!H11)","v":3.8912962353399081},null,{"$f":"SUM('SW Full-Cost Tariffs'!J11)","v":12.459072921907993},{"$f":"SUM('SW Full-Cost Tariffs'!K11)","v":13.287270796412216},{"$f":"SUM('SW Full-Cost Tariffs'!L11)","v":14.170521861762381}]
["Namoi ",{"$f":"SUM('SW Full-Cost Tariffs'!B12)","v":17.498133277863712},{"$f":"SUM('SW Full-Cost Tariffs'!C12)","v":18.071296491064203},{"$f":"SUM('SW Full-Cost Tariffs'!D12)","v":18.663234053719552},null,{"$f":"SUM('SW Full-Cost Tariffs'!F12)","v":8.1361266460259642},{"$f":"SUM('SW Full-Cost Tariffs'!G12)","v":8.4026309877971972},{"$f":"SUM('SW Full-Cost Tariffs'!H12)","v":8.6778648598809411},null,{"$f":"SUM('SW Full-Cost Tariffs'!J12)","v":21.126579199972099},{"$f":"SUM('SW Full-Cost Tariffs'!K12)","v":21.818594618182985},{"$f":"SUM('SW Full-Cost Tariffs'!L12)","v":22.533277470364542}]
["Peel (10% cap on annual increase)",{"$f":"SUM('Peel - 10% price cap'!F16)","v":28.273545288381449},{"$f":"SUM('Peel - 10% price cap'!J16)","v":31.878422312650081},{"$f":"SUM('Peel - 10% price cap'!N16)","v":35.942921157512963},null,{"$f":"SUM('Peel - 10% price cap'!G16)","v":3.1090798113861302},{"$f":"SUM('Peel - 10% price cap'!K16)","v":3.5054874873378616},{"$f":"SUM('Peel - 10% price cap'!O16)","v":3.952437141973439},null,{"$f":"'Peel - 10% price cap'!H16","v":46.703541859847242},{"$f":"SUM('Peel - 10% price cap'!L16)","v":52.658243446977764},{"$f":"SUM('Peel - 10% price cap'!P16)","v":59.372169486467428}]
["Lachlan",{"$f":"SUM('SW Full-Cost Tariffs'!B14)","v":13.212087448443645},{"$f":"SUM('SW Full-Cost Tariffs'!C14)","v":14.118762475819635},{"$f":"SUM('SW Full-Cost Tariffs'!D14)","v":15.087657769938112},null,{"$f":"SUM('SW Full-Cost Tariffs'!F14)","v":3.2781011034728449},{"$f":"SUM('SW Full-Cost Tariffs'!G14)","v":3.5030596816937765},{"$f":"SUM('SW Full-Cost Tariffs'!H14)","v":3.7434559661714095},null,{"$f":"SUM('SW Full-Cost Tariffs'!J14)","v":18.953277765954354},{"$f":"SUM('SW Full-Cost Tariffs'!K14)","v":20.253940034832663},{"$f":"SUM('SW Full-Cost Tariffs'!L14)","v":21.643859811492689}]
["Macquarie",{"$f":"SUM('SW Full-Cost Tariffs'!B15)","v":13.142347047236655},{"$f":"SUM('SW Full-Cost Tariffs'!C15)","v":13.824716562138034},{"$f":"SUM('SW Full-Cost Tariffs'!D15)","v":14.54251568129451},null,{"$f":"SUM('SW Full-Cost Tariffs'!F15)","v":3.5652111670695192},{"$f":"SUM('SW Full-Cost Tariffs'!G15)","v":3.7503220461119149},{"$f":"SUM('SW Full-Cost Tariffs'!H15)","v":3.9450441475852145},null,{"$f":"SUM('SW Full-Cost Tariffs'!J15)","v":15.08279608473342},{"$f":"SUM('SW Full-Cost Tariffs'!K15)","v":15.86591649775432},{"$f":"SUM('SW Full-Cost Tariffs'!L15)","v":16.689697646214771}]
["Murray ",{"$f":"SUM('SW Full-Cost Tariffs'!B16)","v":1.8005561889736623},{"$f":"SUM('SW Full-Cost Tariffs'!C16)","v":1.8092163480729762},{"$f":"SUM('SW Full-Cost Tariffs'!D16)","v":1.8179181600549297},null,{"$f":"SUM('SW Full-Cost Tariffs'!F16)","v":1.0207877606779818},{"$f":"SUM('SW Full-Cost Tariffs'!G16)","v":1.0256974571752306},{"$f":"SUM('SW Full-Cost Tariffs'!H16)","v":1.030630767905157},null,{"$f":"SUM('SW Full-Cost Tariffs'!J16)","v":2.6611563727630623},{"$f":"SUM('SW Full-Cost Tariffs'!K16)","v":2.673955772036138},{"$f":"SUM('SW Full-Cost Tariffs'!L16)","v":2.6868167327504833}]
["Murrumbidgee",{"$f":"SUM('SW Full-Cost Tariffs'!B17)","v":2.8621434597406039},{"$f":"SUM('SW Full-Cost Tariffs'!C17)","v":2.9250522406563957},{"$f":"SUM('SW Full-Cost Tariffs'!D17)","v":2.9893437316885665},null,{"$f":"SUM('SW Full-Cost Tariffs'!F17)","v":1.2430883836140176},{"$f":"SUM('SW Full-Cost Tariffs'!G17)","v":1.2704109744917047},{"$f":"SUM('SW Full-Cost Tariffs'!H17)","v":1.2983341051074424},null,{"$f":"SUM('SW Full-Cost Tariffs'!J17)","v":3.4607990440967318},{"$f":"SUM('SW Full-Cost Tariffs'!K17)","v":3.5368660379148524},{"$f":"SUM('SW Full-Cost Tariffs'!L17)","v":3.6146049541632559}]
["Lowbidgee",null,null,null,null,{"$f":"SUM('SW Full-Cost Tariffs'!F18)","v":0.7283142340612877},{"$f":"SUM('SW Full-Cost Tariffs'!G18)","v":0.79023585237084426},{"$f":"SUM('SW Full-Cost Tariffs'!H18)","v":0.85742207575710416},null,{"$f":"SUM('SW Full-Cost Tariffs'!J18)","v":3.4607990440967318},{"$f":"SUM('SW Full-Cost Tariffs'!K18)","v":3.5368660379148524},{"$f":"SUM('SW Full-Cost Tariffs'!L18)","v":3.6146049541632559}]
[]
["Fish River","Access  ($/KL)",null,null,null,"Usage < MAQ ($/KL)",null,null,null,"Usage > 200kl ($/KL)"]
["Raw water - major customers",{"$f":"SUM('SW Full-Cost Tariffs'!B21)","v":0.34657947118128452},{"$f":"SUM('SW Full-Cost Tariffs'!C21)","v":0.35778299362259464},{"$f":"SUM('SW Full-Cost Tariffs'!D21)","v":0.36934868095112416},null,{"$f":"SUM('SW Full-Cost Tariffs'!F21)","v":0.389374359552764},{"$f":"SUM('SW Full-Cost Tariffs'!G21)","v":0.40196126887099753},{"$f":"SUM('SW Full-Cost Tariffs'!H21)","v":0.41495506241850438}]
["Raw water - minor customers *",{"$f":"SUM('SW Full-Cost Tariffs'!B22)","v":69.315894236256909},{"$f":"SUM('SW Full-Cost Tariffs'!C22)","v":71.556598724518935},{"$f":"SUM('SW Full-Cost Tariffs'!D22)","v":73.869736190224842},null,{"$f":"SUM('SW Full-Cost Tariffs'!F22)","v":0.389374359552764},{"$f":"SUM('SW Full-Cost Tariffs'!G22)","v":0.40196126887099753},{"$f":"SUM('SW Full-Cost Tariffs'!H22)","v":0.41495506241850438},null,{"$f":"SUM('SW Full-Cost Tariffs'!J22)","v":0.73595383073404852},{"$f":"SUM('SW Full-Cost Tariffs'!K22)","v":0.75974426249359217},{"$f":"SUM('SW Full-Cost Tariffs'!L22)","v":0.7843037433696286}]
["Filtered water - major customers",{"$f":"SUM('SW Full-Cost Tariffs'!B23)","v":0.67077350598578445},{"$f":"SUM('SW Full-Cost Tariffs'!C23)","v":0.69245691961017974},{"$f":"SUM('SW Full-Cost Tariffs'!D23)","v":0.71484127091653626},null,{"$f":"SUM('SW Full-Cost Tariffs'!F23)","v":0.67410845230544458},{"$f":"SUM('SW Full-Cost Tariffs'!G23)","v":0.69589967135122155},{"$f":"SUM('SW Full-Cost Tariffs'!H23)","v":0.71839531299528658}]
["Filtered water - minor customers *",{"$f":"SUM('SW Full-Cost Tariffs'!B24)","v":134.1547011971569},{"$f":"SUM('SW Full-Cost Tariffs'!C24)","v":138.49138392203599},{"$f":"SUM('SW Full-Cost Tariffs'!D24)","v":142.96825418330729},null,{"$f":"SUM('SW Full-Cost Tariffs'!F24)","v":0.67410845230544458},{"$f":"SUM('SW Full-Cost Tariffs'!G24)","v":0.69589967135122155},{"$f":"SUM('SW Full-Cost Tariffs'!H24)","v":0.71839531299528658},null,{"$f":"SUM('SW Full-Cost Tariffs'!J24)","v":1.344881958291229},{"$f":"SUM('SW Full-Cost Tariffs'!K24)","v":1.3883565909614013},{"$f":"SUM('SW Full-Cost Tariffs'!L24)","v":1.4332365839118228}]
["* 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.5855823264768807},6.54337159946689,6.5014314249132168,null,{"$f":"F10/B$5","v":2.2191015347600311},2.2048780561900929,2.1907457439500679,null,{"$f":"J10/B$5","v":6.4478802280570866},6.4065521117862758,6.3654888908196705]
["Gwydir ",13.573267884476618,14.122468458691378,14.693890746445202,null,3.3378768679128652,3.4729337980580701,3.6134553918508749,null,12.155193094544384,12.647015630136554,13.158738253257969]
["Namoi ",17.071349539379231,17.2005201580623,17.33066814814137,null,7.9376845327082588,7.9977451400806165,8.0582601969266303,null,20.611296780460584,20.767252462280059,20.924388185071763]
["Peel (10% cap on annual increase)",27.583946622811172,30.342341285092285,33.376575413601515,null,3.0332485964742735,3.3365734561217009,3.670230801733871,null,45.564431082777801,50.120874191055577,55.132961610161139]
["Lachlan",12.889841413115752,13.438441380911016,14.010390117323301,null,3.198147418022288,3.3342626357585026,3.4761710049907899,null,18.491002698492053,19.277991704778266,20.098475470981736]
["Macquarie",12.821801997304055,13.15856424712722,13.504171494941291,null,3.4782547971409947,3.5696105138483429,3.6633656715000327,null,14.714923009496021,15.101407731354499,15.498043402703754]
["Murray ",1.7566401843645487,1.7220381659231183,1.6881177325273213,null,0.99589049822242137,0.97627360587767353,0.95704312395249713,null,2.5962501197688415,2.5451095986066754,2.4949764352814228]
["Murrumbidgee",2.7923350826737603,2.7841068322725957,2.7759028282826463,null,1.2127691547453832,1.2091954546024555,1.2056322851797903,null,3.376389311313885,3.3664400122925429,3.3565200311436052]
["Lowbidgee",null,null,null,null,0.71055047225491486,0.75215786067421231,0.79620163445763514,null,3.376389311313885,3.3664400122925429,3.3565200311436052]
[]
["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.33812631334759469},{"$f":"C21/C$5","v":0.34054300404292176},{"$f":"D21/D$5","v":0.34297696755520013},null,{"$f":"F21/B$5","v":0.37987742395391616},{"$f":"G21/C$5","v":0.38259252242331715},{"$f":"H21/D$5","v":0.38532702651999079}]
["Raw water - minor customers",{"$f":"B22/B$5","v":67.625262669518946},68.108600808584356,68.595393511040044,null,{"$f":"F22/B$5","v":0.37987742395391616},0.38259252242331715,0.38532702651999079,null,{"$f":"J22/B$5","v":0.71800373730151079},0.72313552646623891,0.72830399407519097]
["Filtered water - major customers",0.65441317657149711,0.65909046482824962,0.66380118307422009,null,0.65766678273701917,0.6623673254978909,0.66710146445493168]
["Filtered water - minor customers",130.88263531429942,131.81809296564998,132.76023661484408,null,0.65766678273701917,0.6623673254978909,0.66710146445493168,null,{"$f":"J24/B$5","v":1.3120799593085162},1.3214577903261406,1.3309026475291519]

{"sheet":"SW Full-Cost Tariffs","index":3,"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],[29,1,29,3],[29,5,29,7],[29,9,29,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],[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]]}
["SW Costs Tariffs","Check",{"$f":"IF(D1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(Border!D1,Gwydir!D1,Namoi!D1,'Peel - cost reflective tariffs'!D1,Lachlan!D1,Macquarie!D1,Murray!D1,Murrumbidgee!D1,Lowbidgee!D1,'Fish River'!D1)","v":2.5386270863236859E-9}]
["These tariffs recover State Water's costs"]
[null,"2014-15","2015-16","2016-17",null,null,null,null,"Macro to Smooth Revenue Requirement"]
["CPI Forecast",{"$f":"Inputs!B83","v":2.5000000000000001E-2},{"$f":"Inputs!C83","v":2.5000000000000001E-2},{"$f":"Inputs!D83","v":2.5000000000000001E-2}]
["CPI Index",{"$f":"1+B4","v":1.0249999999999999},{"$f":"B5*(1+C4)","v":1.0506249999999999},{"$f":"C5*(1+D4)","v":1.0768906249999999}]
[]
[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.750221884638802},{"$f":"B10*(1+C$4)*(1+Border!D$24)","v":6.8746297866899004},{"$f":"C10*(1+D$4)*(1+Border!E$24)","v":7.0013305505694339},null,{"$f":"Border!C$41","v":2.2745790731290318},{"$f":"F10*(1+C$4)*(1+Border!D$24)","v":2.316500007784716},{"$f":"G10*(1+D$4)*(1+Border!E$24)","v":2.3591935534184785},null,{"$f":"Border!C$42","v":6.6090772337585131},{"$f":"J10*(1+C$4)*(1+Border!D$24)","v":6.7308838124454553},{"$f":"K10*(1+D$4)*(1+Border!E$24)","v":6.8549353100653514}]
["Gwydir ",{"$f":"Gwydir!C$40","v":13.912599581588532},{"$f":"B11*(1+C$4)*(1+Gwydir!D$24)","v":14.837418424412627},{"$f":"C11*(1+D$4)*(1+Gwydir!E$24)","v":15.823713189621088},null,{"$f":"Gwydir!C$41","v":3.4213237896106867},{"$f":"F11*(1+C$4)*(1+Gwydir!D$24)","v":3.6487510715847598},{"$f":"G11*(1+D$4)*(1+Gwydir!E$24)","v":3.8912962353399081},null,{"$f":"Gwydir!C$42","v":12.459072921907993},{"$f":"J11*(1+C$4)*(1+Gwydir!D$24)","v":13.287270796412216},{"$f":"K11*(1+D$4)*(1+Gwydir!E$24)","v":14.170521861762381}]
["Namoi ",{"$f":"Namoi!C$40","v":17.498133277863712},{"$f":"B12*(1+C$4)*(1+Namoi!D$24)","v":18.071296491064203},{"$f":"C12*(1+D$4)*(1+Namoi!E$24)","v":18.663234053719552},null,{"$f":"Namoi!C$41","v":8.1361266460259642},{"$f":"F12*(1+C$4)*(1+Namoi!D$24)","v":8.4026309877971972},{"$f":"G12*(1+D$4)*(1+Namoi!E$24)","v":8.6778648598809411},null,{"$f":"Namoi!C$42","v":21.126579199972099},{"$f":"J12*(1+C$4)*(1+Namoi!D$24)","v":21.818594618182985},{"$f":"K12*(1+D$4)*(1+Namoi!E$24)","v":22.533277470364542}]
["Peel (full cost recovery before ACCC 10% price cap)",{"$f":"'Peel - cost reflective tariffs'!C$40","v":26.797866014004811},{"$f":"B13*(1+C$4)*(1+'Peel - cost reflective tariffs'!D$24)","v":27.694313351308708},{"$f":"C13*(1+D$4)*(1+'Peel - cost reflective tariffs'!E$24)","v":28.620748816329165},null,{"$f":"'Peel - cost reflective tariffs'!C$41","v":2.7136323459946916},{"$f":"F13*(1+C$4)*(1+'Peel - cost reflective tariffs'!D$24)","v":2.8044092940441128},{"$f":"G13*(1+D$4)*(1+'Peel - cost reflective tariffs'!E$24)","v":2.8982229299150548},null,{"$f":"'Peel - cost reflective tariffs'!C$42","v":73.716414139036999},{"$f":"J13*(1+C$4)*(1+'Peel - cost reflective tariffs'!D$24)","v":76.182389718435573},{"$f":"K13*(1+D$4)*(1+'Peel - cost reflective tariffs'!E$24)","v":78.730857584378654}]
["Lachlan",{"$f":"Lachlan!C$40","v":13.212087448443645},{"$f":"B14*(1+C$4)*(1+Lachlan!D$24)","v":14.118762475819635},{"$f":"C14*(1+D$4)*(1+Lachlan!E$24)","v":15.087657769938112},null,{"$f":"Lachlan!C$41","v":3.2781011034728449},{"$f":"F14*(1+C$4)*(1+Lachlan!D$24)","v":3.5030596816937765},{"$f":"G14*(1+D$4)*(1+Lachlan!E$24)","v":3.7434559661714095},null,{"$f":"Lachlan!C$42","v":18.953277765954354},{"$f":"J14*(1+C$4)*(1+Lachlan!D$24)","v":20.253940034832663},{"$f":"K14*(1+D$4)*(1+Lachlan!E$24)","v":21.643859811492689}]
["Macquarie",{"$f":"Macquarie!C$40","v":13.142347047236655},{"$f":"B15*(1+C$4)*(1+Macquarie!D$24)","v":13.824716562138034},{"$f":"C15*(1+D$4)*(1+Macquarie!E$24)","v":14.54251568129451},null,{"$f":"Macquarie!C$41","v":3.5652111670695192},{"$f":"F15*(1+C$4)*(1+Macquarie!D$24)","v":3.7503220461119149},{"$f":"G15*(1+D$4)*(1+Macquarie!E$24)","v":3.9450441475852145},null,{"$f":"Macquarie!C$42","v":15.08279608473342},{"$f":"J15*(1+C$4)*(1+Macquarie!D$24)","v":15.86591649775432},{"$f":"K15*(1+D$4)*(1+Macquarie!E$24)","v":16.689697646214771}]
["Murray ",{"$f":"Murray!C$40","v":1.8005561889736623},{"$f":"B16*(1+C$4)*(1+Murray!D$24)","v":1.8092163480729762},{"$f":"C16*(1+D$4)*(1+Murray!E$24)","v":1.8179181600549297},null,{"$f":"Murray!C$41","v":1.0207877606779818},{"$f":"F16*(1+C$4)*(1+Murray!D$24)","v":1.0256974571752306},{"$f":"G16*(1+D$4)*(1+Murray!E$24)","v":1.030630767905157},null,{"$f":"Murray!C$42","v":2.6611563727630623},{"$f":"J16*(1+C$4)*(1+Murray!D$24)","v":2.673955772036138},{"$f":"K16*(1+D$4)*(1+Murray!E$24)","v":2.6868167327504833}]
["Murrumbidgee",{"$f":"Murrumbidgee!C$40","v":2.8621434597406039},{"$f":"B17*(1+C$4)*(1+Murrumbidgee!D$24)","v":2.9250522406563957},{"$f":"C17*(1+D$4)*(1+Murrumbidgee!E$24)","v":2.9893437316885665},null,{"$f":"Murrumbidgee!C$41","v":1.2430883836140176},{"$f":"F17*(1+C$4)*(1+Murrumbidgee!D$24)","v":1.2704109744917047},{"$f":"G17*(1+D$4)*(1+Murrumbidgee!E$24)","v":1.2983341051074424},null,{"$f":"Murrumbidgee!C$42","v":3.4607990440967318},{"$f":"J17*(1+C$4)*(1+Murrumbidgee!D$24)","v":3.5368660379148524},{"$f":"K17*(1+D$4)*(1+Murrumbidgee!E$24)","v":3.6146049541632559}]
["Lowbidgee",null,null,null,null,{"$f":"Lowbidgee!C$41","v":0.7283142340612877},{"$f":"F18*(1+C$4)*(1+Lowbidgee!D$24)","v":0.79023585237084426},{"$f":"G18*(1+D$4)*(1+Lowbidgee!E$24)","v":0.85742207575710416},null,{"$f":"J17","v":3.4607990440967318},{"$f":"K17","v":3.5368660379148524},3.6146049541632559]
[]
["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.34657947118128452},{"$f":"B21*(1+C$4)*(1+'Fish River'!D$24)","v":0.35778299362259464},{"$f":"C21*(1+D$4)*(1+'Fish River'!E$24)","v":0.36934868095112416},null,{"$f":"'Fish River'!C84","v":0.389374359552764},{"$f":"F21*(1+C$4)*(1+'Fish River'!D$24)","v":0.40196126887099753},{"$f":"G21*(1+D$4)*(1+'Fish River'!E$24)","v":0.41495506241850438}]
["Raw water - minor customers *",{"$f":"'Fish River'!C75","v":69.315894236256909},{"$f":"B22*(1+C$4)*(1+'Fish River'!D$24)","v":71.556598724518935},{"$f":"C22*(1+D$4)*(1+'Fish River'!E$24)","v":73.869736190224842},null,{"$f":"'Fish River'!C97","v":0.389374359552764},{"$f":"F22*(1+C$4)*(1+'Fish River'!D$24)","v":0.40196126887099753},{"$f":"G22*(1+D$4)*(1+'Fish River'!E$24)","v":0.41495506241850438},null,{"$f":"'Fish River'!C111","v":0.73595383073404852},{"$f":"J22*(1+C$4)*(1+'Fish River'!D$24)","v":0.75974426249359217},{"$f":"K22*(1+D$4)*(1+'Fish River'!E$24)","v":0.7843037433696286}]
["Filtered water - major customers",{"$f":"'Fish River'!C146","v":0.67077350598578445},{"$f":"B23*(1+C$4)*(1+'Fish River'!D$24)","v":0.69245691961017974},{"$f":"C23*(1+D$4)*(1+'Fish River'!E$24)","v":0.71484127091653626},null,{"$f":"'Fish River'!C159","v":0.67410845230544458},{"$f":"F23*(1+C$4)*(1+'Fish River'!D$24)","v":0.69589967135122155},{"$f":"G23*(1+D$4)*(1+'Fish River'!E$24)","v":0.71839531299528658}]
["Filtered water - minor customers *",{"$f":"'Fish River'!C150","v":134.1547011971569},{"$f":"B24*(1+C$4)*(1+'Fish River'!D$24)","v":138.49138392203599},{"$f":"C24*(1+D$4)*(1+'Fish River'!E$24)","v":142.96825418330729},null,{"$f":"'Fish River'!C163","v":0.67410845230544458},{"$f":"F24*(1+C$4)*(1+'Fish River'!D$24)","v":0.69589967135122155},{"$f":"G24*(1+D$4)*(1+'Fish River'!E$24)","v":0.71839531299528658},null,{"$f":"'Fish River'!C176","v":1.344881958291229},{"$f":"J24*(1+C$4)*(1+'Fish River'!D$24)","v":1.3883565909614013},{"$f":"K24*(1+D$4)*(1+'Fish River'!E$24)","v":1.4332365839118228}]
["* 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.5855823264768807},6.54337159946689,6.5014314249132168,null,{"$f":"F10/B$5","v":2.2191015347600311},{"$f":"G10/C$5","v":2.2048780561900929},{"$f":"H10/D$5","v":2.1907457439500679},null,{"$f":"J10/B$5","v":6.4478802280570866},{"$f":"K10/C$5","v":6.4065521117862758},{"$f":"L10/D$5","v":6.3654888908196705}]
["Gwydir ",13.573267884476618,14.122468458691378,14.693890746445202,null,3.3378768679128652,3.4729337980580701,3.6134553918508749,null,12.155193094544384,12.647015630136554,13.158738253257969]
["Namoi ",17.071349539379231,17.2005201580623,17.33066814814137,null,7.9376845327082588,7.9977451400806165,8.0582601969266303,null,20.611296780460584,20.767252462280059,20.924388185071763]
["Peel",26.144259525858352,26.359846140448504,26.57721049092536,null,2.6474461912143337,2.6692771388879124,2.6912881054332285,null,71.918452818572689,72.511495270372947,73.109427974060651]
["Lachlan",12.889841413115752,13.438441380911016,14.010390117323301,null,3.198147418022288,3.3342626357585026,3.4761710049907899,null,18.491002698492053,19.277991704778266,20.098475470981736]
["Macquarie",12.821801997304055,13.15856424712722,13.504171494941291,null,3.4782547971409947,3.5696105138483429,3.6633656715000327,null,14.714923009496021,15.101407731354499,15.498043402703754]
["Murray ",1.7566401843645487,1.7220381659231183,1.6881177325273213,null,0.99589049822242137,0.97627360587767353,0.95704312395249713,null,2.5962501197688415,2.5451095986066754,2.4949764352814228]
["Murrumbidgee",2.7923350826737603,2.7841068322725957,2.7759028282826463,null,1.2127691547453832,1.2091954546024555,1.2056322851797903,null,3.376389311313885,3.3664400122925429,3.3565200311436052]
["Lowbidgee",null,null,null,null,0.71055047225491486,0.75215786067421231,0.79620163445763514,null,{"$f":"J18/B$5","v":3.376389311313885},{"$f":"K18/C$5","v":3.3664400122925429},{"$f":"L18/D$5","v":3.3565200311436052}]
[]
["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.33812631334759469},{"$f":"C21/C$5","v":0.34054300404292176},{"$f":"D21/D$5","v":0.34297696755520013},null,{"$f":"F21/B$5","v":0.37987742395391616},{"$f":"G21/C$5","v":0.38259252242331715},{"$f":"H21/D$5","v":0.38532702651999079}]
["Raw water - minor customers",{"$f":"B22/B$5","v":67.625262669518946},68.108600808584356,68.595393511040044,null,{"$f":"F22/B$5","v":0.37987742395391616},0.38259252242331715,0.38532702651999079,null,{"$f":"J22/B$5","v":0.71800373730151079},0.72313552646623891,0.72830399407519097]
["Filtered water - major customers",{"$f":"B23/B$5","v":0.65441317657149711},0.65909046482824962,0.66380118307422009,null,{"$f":"F23/B$5","v":0.65766678273701917},0.6623673254978909,0.66710146445493168]
["Filtered water - minor customers",{"$f":"B24/B$5","v":130.88263531429942},131.81809296564998,132.76023661484408,null,{"$f":"F24/B$5","v":0.65766678273701917},0.6623673254978909,0.66710146445493168,null,{"$f":"J24/B$5","v":1.3120799593085162},1.3214577903261406,1.3309026475291519]
[]
[]
[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":1549.5745969404561},{"$f":"Border!D$22","v":1578.1335581081976},{"$f":"Border!E$22","v":1607.2188664841283},null,{"$f":"B50/B$5","v":1511.7800945760548},{"$f":"C50/C$5","v":1502.0902397222583},{"$f":"D50/D$5","v":1492.4624926362678}]
["Gwydir ",{"$f":"Gwydir!C$22","v":5105.6603994842471},{"$f":"Gwydir!D$22","v":5445.0513892711242},{"$f":"Gwydir!E$22","v":5807.0028775902092},null,{"$f":"B51/B$5","v":4981.1320970578026},5182.6783003175487,5392.3794513395542]
["Namoi ",{"$f":"Namoi!C$22","v":5597.1692216211313},{"$f":"Namoi!D$22","v":5780.5082924207409},{"$f":"Namoi!E$22","v":5969.8527587248882},null,5460.6528991425675,5501.9710100375887,5543.6017550295683]
["Peel",{"$f":"'Peel - cost reflective tariffs'!C$22","v":1371.6056882848941},{"$f":"'Peel - cost reflective tariffs'!D$22","v":1417.4889040025669},{"$f":"'Peel - cost reflective tariffs'!E$22","v":1464.9070138247012},null,1338.1518910096529,1349.1863452731154,1360.3117900898258]
["Lachlan",{"$f":"Lachlan!C$22","v":7192.679800185384},{"$f":"Lachlan!D$22","v":7686.2750159442694},{"$f":"Lachlan!E$22","v":8213.743036247266},null,7017.2485855467166,7315.9072132723568,7627.2769449054003]
["Macquarie",{"$f":"Macquarie!C$22","v":7030.3594397776315},{"$f":"Macquarie!D$22","v":7395.3857888202165},{"$f":"Macquarie!E$22","v":7779.3648296329366},null,6858.8872583196408,7039.0346591983025,7223.9135981269565]
["Murray ",{"$f":"Murray!C$22","v":6474.1008478328422},{"$f":"Murray!D$22","v":6505.2394169653026},{"$f":"Murray!E$22","v":6536.5277536887234},null,6316.1959491052121,6191.7805277480575,6069.8158215359372]
["Murrumbidgee",{"$f":"Murrumbidgee!C$22","v":10150.177083831426},{"$f":"Murrumbidgee!D$22","v":10373.273960492217},{"$f":"Murrumbidgee!E$22","v":10601.274418239795},null,9902.6117891038302,9873.4314912477985,9844.3371797760756]
["Lowbidgee",{"$f":"Lowbidgee!C$22","v":544.05073284378193},{"$f":"Lowbidgee!D$22","v":590.30618172102061},{"$f":"Lowbidgee!E$22","v":640.49429059055672},null,530.78120277442144,561.8619219236366,594.76262093985338]
["Fish River",{"$f":"'Fish River'!C$22","v":10171.162262431115},{"$f":"'Fish River'!D$22","v":10499.955091022364},{"$f":"'Fish River'!E$22","v":10839.376471331085},null,9923.0851340791378,9994.0084150123639,10065.43860601543]
[]
[]
[]
[]
[]
[]
[]
[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 - cost reflective tariffs'!$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",-6.4095663705068312E-3,{"$f":"B69","v":-6.4095663705068312E-3},null,4.0461926994225586E-2,{"$f":"E69","v":4.0461926994225586E-2},null,7.5665147846165461E-3,{"$f":"H69","v":7.5665147846165461E-3},null,8.2460401824318557E-3,{"$f":"K69","v":8.2460401824318557E-3},null,4.2560645256430246E-2,{"$f":"N69","v":4.2560645256430246E-2}]
["Difference in NPVs",{"$f":"Border!$B$26","v":1.5643308870494366E-10},{"$f":"B70*10^6","v":1.5643308870494366E-4},null,{"$f":"Gwydir!$B$26","v":0},{"$f":"E70*10^6","v":0},null,{"$f":"Namoi!$B$26","v":0},{"$f":"H70*10^6","v":0},null,{"$f":"'Peel - cost reflective tariffs'!$B$26","v":0},{"$f":"K70*10^6","v":0},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":2.0257602778048778E-3},null,null,{"$f":"Gwydir!$E$26","v":-1.6287938059893481E-3},null,null,{"$f":"Namoi!$E$26","v":4.573207900430365E-3},null,null,{"$f":"'Peel - cost reflective tariffs'!$E$26","v":5.2471265352873608E-3},null,null,{"$f":"Lachlan!$E$26","v":-1.3522213404192351E-3}]
["2014-15 Average Real Price Increase \\ (Decrease)",{"$f":"Border!$E$43","v":6.2905082865541528E-2},null,null,{"$f":"Gwydir!$E$43","v":-9.5841180139046855E-2},null,null,{"$f":"Namoi!$E$43","v":-2.1060471081619792E-2},null,null,{"$f":"'Peel - cost reflective tariffs'!$E$43","v":0.36199877951300485},null,null,{"$f":"Lachlan!$E$43","v":-8.3384170968976545E-2}]
[]
[]
[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",2.6264814407052531E-2,{"$f":"B77","v":2.6264814407052531E-2},null,-1.9697840655937847E-2,{"$f":"E77","v":-1.9697840655937847E-2},null,-2.946727436911086E-3,{"$f":"H77","v":-2.946727436911086E-3},null,5.8556555859089636E-2,{"$f":"K77","v":5.8556555859089636E-2},null,7.1473014667235895E-3,{"$f":"N77","v":7.1473014667235895E-3}]
["Difference in NPVs",{"$f":"Macquarie!$B$26","v":0},{"$f":"B78*10^6","v":0},null,{"$f":"Murray!$B$26","v":0},{"$f":"E78*10^6","v":0},null,{"$f":"Murrumbidgee!$B$26","v":9.6406438387930393E-10},{"$f":"H78*10^6","v":9.6406438387930393E-4},null,{"$f":"Lowbidgee!$B$26","v":8.3377926785033196E-10},{"$f":"K78*10^6","v":8.3377926785033196E-4},null,{"$f":"'Fish River'!$B$26","v":0},{"$f":"N78*10^6","v":0}]
["Difference between final year revenue and requirement",{"$f":"Macquarie!$E$26","v":-5.4366011907048817E-3},null,null,{"$f":"Murray!$E$26","v":-7.4256726737791379E-3},null,null,{"$f":"Murrumbidgee!$E$26","v":6.905394253709618E-3},null,null,{"$f":"Lowbidgee!$E$26","v":-1.368848005193235E-2},null,null,{"$f":"'Fish River'!$E$26","v":1.6621263695646427E-3}]
["2014-15 Average Real Price Increase \\ (Decrease)",{"$f":"Macquarie!$E$43","v":-2.4788070471004175E-2},null,null,{"$f":"Murray!$E$43","v":-9.7426962606742218E-2},null,null,{"$f":"Murrumbidgee!$E$43","v":-3.0559356895898948E-2},null,null,{"$f":"Lowbidgee!$E$43","v":0},null,null,{"$f":"'Fish River'!E196","v":-8.7683341265932802E-2}]
[]
[]
[]
[]
[]
[]
["State Water bulk water charges - ACCC Draft Decision",null,null,null,null,"Comparison of proposed prices against 2013-14"]
["Prices ($ Real 2013-14)"]
[null,"IPART-set","ACCCDraft Decision",null,null,null,{"$f":"$B89","v":"IPART-set"},{"$f":"$C89","v":"ACCCDraft Decision"},null,null,null,{"$f":"$B89","v":"IPART-set"},{"$f":"$C89","v":"ACCCDraft 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.5855823264768807},6.54337159946689,6.5014314249132168,null,{"$f":"Inputs!H5","v":2.0683927335313741},{"$f":"F31","v":2.2191015347600311},{"$f":"G31","v":2.2048780561900929},{"$f":"H31","v":2.1907457439500679},null,{"$f":"Inputs!I5","v":6.0763063791902985},{"$f":"J31","v":6.4478802280570866},6.4065521117862758,6.3654888908196705]
["Gwydir ",{"$f":"Inputs!G6","v":14.389781637543789},13.573267884476618,14.122468458691378,14.693890746445202,null,{"$f":"Inputs!H6","v":4.0152930205105006},3.3378768679128652,3.4729337980580701,3.6134553918508749,null,{"$f":"Inputs!I6","v":12.827179920202266},12.155193094544384,12.647015630136554,13.158738253257969]
["Namoi ",{"$f":"Inputs!G7","v":16.019857330139448},17.071349539379231,17.2005201580623,17.33066814814137,null,{"$f":"Inputs!H7","v":8.9778361979634766},7.9376845327082588,7.9977451400806165,8.0582601969266303,null,{"$f":"Inputs!I7","v":19.733461742058335},20.611296780460584,20.767252462280059,20.924388185071763]
["Peel",{"$f":"Inputs!G8","v":25.076315111646519},26.144259525858352,26.359846140448504,26.57721049092536,null,{"$f":"Inputs!H8","v":2.7574987240675211},2.6474461912143337,2.6692771388879124,2.6912881054332285,null,{"$f":"Inputs!I8","v":41.422210075252544},71.918452818572689,72.511495270372947,73.109427974060651]
["Lachlan",{"$f":"Inputs!G9","v":12.36},12.889841413115752,13.438441380911016,14.010390117323301,null,{"$f":"Inputs!H9","v":4.42},3.198147418022288,3.3342626357585026,3.4761710049907899,null,{"$f":"Inputs!I9","v":18.04},18.491002698492053,19.277991704778266,20.098475470981736]
["Macquarie",{"$f":"Inputs!G10","v":11.35284249530522},12.821801997304055,13.15856424712722,13.504171494941291,null,{"$f":"Inputs!H10","v":4.2150658651571051},3.4782547971409947,3.5696105138483429,3.6633656715000327,null,{"$f":"Inputs!I10","v":13.897787923324605},14.714923009496021,15.101407731354499,15.498043402703754]
["Murray ",{"$f":"Inputs!G11","v":1.7017878516072777},1.7566401843645487,1.7220381659231183,1.6881177325273213,null,{"$f":"Inputs!H11","v":1.2627916223710054},0.99589049822242137,0.97627360587767353,0.95704312395249713,null,{"$f":"Inputs!I11","v":2.6935941472892257},2.5962501197688415,2.5451095986066754,2.4949764352814228]
["Murrumbidgee",{"$f":"Inputs!G12","v":2.6360825366697194},2.7923350826737603,2.7841068322725957,2.7759028282826463,null,{"$f":"Inputs!H12","v":1.4065004138606891},1.2127691547453832,1.2091954546024555,1.2056322851797903,null,{"$f":"Inputs!I12","v":3.3437557008763554},3.376389311313885,3.3664400122925429,3.3565200311436052]
["Lowbidgee",null,null,null,null,null,null,0.71055047225491486,0.75215786067421231,0.79620163445763514,null,null,{"$f":"M100","v":3.376389311313885},{"$f":"N100","v":3.3664400122925429},3.3565200311436052]
[]
["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.33812631334759469},0.34054300404292176,0.34297696755520013,null,{"$f":"Inputs!H17","v":0.43},{"$f":"F42","v":0.37987742395391616},0.38259252242331715,0.38532702651999079,null,{"$f":"Inputs!I17","v":0.81}]
["Raw water - minor customers",{"$f":"Inputs!G18*'Fish River'!C36","v":94},67.625262669518946,68.108600808584356,68.595393511040044,null,{"$f":"Inputs!H18","v":0.85},0.37987742395391616,0.38259252242331715,0.38532702651999079,null,{"$f":"Inputs!I18","v":1.33},{"$f":"J43","v":0.71800373730151079},{"$f":"K43","v":0.72313552646623891},{"$f":"L43","v":0.72830399407519097}]
["Filtered water - major customers",{"$f":"Inputs!G19","v":0.56999999999999995},0.65441317657149711,0.65909046482824962,0.66380118307422009,null,{"$f":"Inputs!H19","v":0.61},0.65766678273701917,0.6623673254978909,0.66710146445493168,null,{"$f":"Inputs!I19","v":1.18}]
["Filtered water - minor customers",{"$f":"Inputs!G20*'Fish River'!C49","v":134.66272469999996},130.88263531429942,131.81809296564998,132.76023661484408,null,{"$f":"Inputs!H20","v":1.04},0.65766678273701917,0.6623673254978909,0.66710146445493168,null,{"$f":"Inputs!I20","v":1.71},{"$f":"J45","v":1.3120799593085162},{"$f":"K45","v":1.3214577903261406},{"$f":"L45","v":1.3309026475291519}]
[]
[]
["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.10739210131750598},{"$f":"D93/$B93-1","v":-0.11311333088695008},-0.11879788985574802,null,null,{"$f":"H93/$G93-1","v":7.2862758984533649E-2},{"$f":"I93/$G93-1","v":6.5986173924377001E-2},5.9153664792565896E-2,null,null,{"$f":"M93/$L93-1","v":6.1151269484917226E-2},{"$f":"N93/$L93-1","v":5.4349749994006213E-2},4.7591825293692214E-2]
["Gwydir ",null,{"$f":"C94/$B94-1","v":-5.6742609000878685E-2},-1.8576597309508558E-2,2.1133684760578531E-2,null,null,{"$f":"H94/$G94-1","v":-0.16870902052162295},-0.1350733855990105,-0.1000767880717548,null,null,{"$f":"M94/$L94-1","v":-5.2387729012791873E-2},-1.4045510485275137E-2,2.5848108089098654E-2]
["Namoi ",null,6.5636802349139822E-2,7.3699958969146051E-2,8.1824125582928176E-2,null,null,-0.11585772365630431,-0.10916784805064528,-0.10242735340230891,null,null,4.4484594232713892E-2,5.2387702357280075E-2,6.0350609466314875E-2]
["Peel",null,4.2587772942597635E-2,5.1184993611994356E-2,5.9853107308488029E-2,null,null,-3.9910275168088427E-2,-3.1993336718384779E-2,-2.4011114876102968E-2,null,null,0.73622925208280821,0.75054626826139614,0.76498134313068555]
["Lachlan",null,4.2867428245610961E-2,8.725253890865825E-2,0.13352670852130277,null,null,-0.27643723574156376,-0.24564193761119846,-0.21353597172154071,null,null,2.50001495838168E-2,6.8624817338041488E-2,0.1141061791009832]
["Macquarie",null,0.12939133988745977,0.15905459382253628,0.18949694761692659,null,null,-0.17480416477160976,-0.15313054930986336,-0.13088768036048459,null,null,5.8796053780617807E-2,8.660513562808525E-2,0.11514461784910712]
["Murray ",null,3.2232180236487773E-2,1.1899435230257938E-2,-8.0327986047411537E-3,null,null,-0.21135800984128561,-0.22689255409801368,-0.24212110137731024,null,null,-3.613908487971329E-2,-5.5125063600239055E-2,-7.3737059537231087E-2]
["Murrumbidgee",null,5.927452719346249E-2,5.6153133880960437E-2,5.3040938463773557E-2,null,null,-0.13773992329197748,-0.14028076871776607,-0.14281412696462559,null,null,9.7595677904869227E-3,6.7840815673949617E-3,3.8173632911950861E-3]
["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.11019391224317188},-0.10383419988704801,-9.7429032749473343E-2,null,null,{"$f":"H104/$G104-1","v":-0.1165641303397299},{"$f":"I104/$G104-1","v":-0.11024994785275077},-0.10389063600002135]
["Raw water - minor customers",null,{"$f":"C105/$B105-1","v":-0.28058231202639417},-0.27544041692995369,-0.27026177115914851,null,null,{"$f":"H105/$G105-1","v":-0.55308538358362802},-0.54989115009021505,-0.54667408644706961,null,null,{"$f":"M105/$L105-1","v":-0.46014756593871375},-0.45628907784493322,-0.4524030119735406]
["Filtered water - major customers",null,{"$f":"C106/$B106-1","v":0.14809329223069678},0.15629906110219238,0.16456347907757918,null,null,{"$f":"H106/$G106-1","v":7.8142266781998648E-2},8.5848074586706513E-2,9.3608958122838759E-2]
["Filtered water - minor customers",null,{"$f":"C107/$B107-1","v":-2.8070792374963238E-2},-2.1124121323753187E-2,-1.4127800320350103E-2,null,null,{"$f":"H107/$G107-1","v":-0.36762809352209702},-0.36310834086741262,-0.35855628417795038,null,null,{"$f":"M107/$L107-1","v":-0.23270177818215432},-0.2272176664759411,-0.22169435817008665]
[]
[]
["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":6.2905082865541528E-2},{"$f":"G50/$B130-1","v":5.6092322191365618E-2},{"$f":"H50/$B130-1","v":4.9323228358897353E-2}]
["Gwydir ",{"$f":"SUMPRODUCT(Gwydir!B$40:B$42,Gwydir!C$34:C$36)/10^3","v":5509.1340012851178},-9.5841180139046855E-2,-5.9257171978647993E-2,-2.1192904350906705E-2]
["Namoi ",{"$f":"SUMPRODUCT(Namoi!B$40:B$42,Namoi!C$34:C$36)/10^3","v":5578.1309650208768},-2.1060471081619681E-2,-1.3653310662813167E-2,-6.1901038551860355E-3]
["Peel",{"$f":"SUMPRODUCT('Peel - cost reflective tariffs'!B$40:B$42,'Peel - cost reflective tariffs'!C$34:C$36)/10^3","v":982.4912556001857},0.36199877951300508,0.37322987617729231,0.38455358491596603]
["Lachlan",{"$f":"SUMPRODUCT(Lachlan!B$40:B$42,Lachlan!C$34:C$36)/10^3","v":7655.6048491600004},-8.3384170968976545E-2,-4.4372409833158599E-2,-3.7002829708103757E-3]
["Macquarie",{"$f":"SUMPRODUCT(Macquarie!B$40:B$42,Macquarie!C$34:C$36)/10^3","v":7033.2273946159785},-2.4788070471004175E-2,8.2568986561848412E-4,2.7112190863749275E-2]
["Murray ",{"$f":"SUMPRODUCT(Murray!B$40:B$42,Murray!C$34:C$36)/10^3","v":6997.9887360109542},-9.7426962606742218E-2,-0.11520570247766038,-0.13263423956353793]
["Murrumbidgee",{"$f":"SUMPRODUCT(Murrumbidgee!B$40:B$42,Murrumbidgee!C$34:C$36)/10^3","v":10214.76854673243},-3.0559356895898948E-2,-3.3416034237390591E-2,-3.6264293729381669E-2]
["Lowbidgee"]
["Fish River",{"$f":"'Fish River'!B196/10^3","v":10876.799233117626},-8.7683341265932802E-2,-8.1162739072846435E-2,-7.4595532170141476E-2]

{"sheet":"Border","index":4,"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.5643308870494366E-10}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!B83","v":2.5000000000000001E-2},{"$f":"Inputs!C83","v":2.5000000000000001E-2},{"$f":"Inputs!D83","v":2.5000000000000001E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.0249999999999999},{"$f":"C5*(1+D4)","v":1.0506249999999999},{"$f":"D5*(1+E4)","v":1.0768906249999999}]
[]
["Nominal Vanilla WACC",null,{"$f":"Inputs!B84","v":7.4364600000000003E-2},{"$f":"Inputs!C84","v":7.4364600000000003E-2},{"$f":"Inputs!D84","v":7.4364600000000003E-2}]
["Real Vanilla WACC",null,{"$f":"(1+C7)/(1+C4)-1","v":4.816058536585377E-2},{"$f":"(1+D7)/(1+D4)-1","v":4.816058536585377E-2},4.816058536585377E-2]
[]
["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!B$90","v":1549.5745969404561},{"$f":"Inputs!C$90","v":1581.1579112188911},{"$f":"Inputs!D$90","v":1603.9696085642925}]
["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":1549.5745969404561},{"$f":"SUM(D15:D17)","v":1581.1579112188911},{"$f":"SUM(E15:E17)","v":1603.9696085642925}]
["NPV",{"$f":"NPV($C$7,C18:E18)","v":4105.5880745861459}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":-4.5054383559521849E-3},{"$f":"(E18/(1+E$4))/D18-1","v":-1.0314917000926571E-2}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":1549.5745969404561},{"$f":"C22*(1+D$4)*(1+D24)","v":1578.1335581081976},{"$f":"D22*(1+E$4)*(1+E24)","v":1607.2188664841283}]
["NPV",{"$f":"NPV($C$7,C22:E22)","v":4105.5880745859895}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Full-Cost Tariffs'!B69","v":-6.4095663705068312E-3},{"$f":"'SW Full-Cost Tariffs'!C69","v":-6.4095663705068312E-3}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":1.5643308870494366E-10},null,null,{"$f":"E22/E18-1","v":2.0257602778048778E-3},"Difference between final year revenue and requirement"]
[]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C22","v":929.74475816427366}]
["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.750221884638802},null,{"$f":"C40/(1+C$4)/B40-1","v":-0.10739210131750598}]
[{"$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.2745790731290318},null,{"$f":"C41/(1+C$4)/B41-1","v":7.2862758984533649E-2}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!I$5","v":6.0763063791902985},{"$f":"C30*10^3/C36","v":6.6090772337585131},null,6.1151269484917226E-2]
[null,null,null,null,{"$f":"C49/(1+C$4)/(SUMPRODUCT(B40:B42,C34:C36)/10^3)-1","v":6.2905082865541528E-2},"Average"]
[]
["Tariffs Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C40/10^3","v":21.074192723842341}]
["General Security Entitlement",null,{"$f":"C35*C41/10^3","v":598.75564605234001}]
["Usage",null,{"$f":"C36*C42/10^3","v":929.74475816427378}]
[null,null,{"$f":"SUM(C46:C48)","v":1549.5745969404561}]
["Check",null,{"$f":"ABS(C49-C22)","v":0}]
[]
[]
["Revenue Requirement  - MDBA / BCR costs",null,"2014-15"]
["MDBA / BCR costs ($'000 Nominal)",null,{"$f":"Inputs!B$117*C$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.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":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":1549.5745969404561}]
[{"$f":"A53","v":"Revenue Requirement  - MDBA / BCR costs"},null,{"$f":"C54","v":0}]
[null,null,{"$f":"SUM(C81:C82)","v":1549.5745969404561}]
[]
[]
[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":6.750221884638802},null,{"$f":"C88/(1+C$4)/B88-1","v":-0.42483997148673525}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!C$5","v":3.21},{"$f":"SUM(C41,C68)","v":2.2745790731290318},null,{"$f":"C89/(1+C$4)/B89-1","v":-0.308691110666657}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!D$5","v":9.43},{"$f":"SUM(C42,C69)","v":6.6090772337585131},null,-0.31623751558249347]
[null,null,null,null,{"$f":"C97/(1+C$4)/(SUMPRODUCT(B88:B90,C34:C36)/10^3)-1","v":-0.31510742995867613},"Average"]
[]
["Total Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C88/10^3","v":21.074192723842341}]
["General Security Entitlement",null,{"$f":"C35*C89/10^3","v":598.75564605234001}]
["Usage",null,{"$f":"C36*C90/10^3","v":929.74475816427378}]
[null,null,{"$f":"SUM(C94:C96)","v":1549.5745969404561}]
["Check",null,{"$f":"ABS(C97-C83)","v":0}]

{"sheet":"Gwydir","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":0}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!B83","v":2.5000000000000001E-2},{"$f":"Inputs!C83","v":2.5000000000000001E-2},{"$f":"Inputs!D83","v":2.5000000000000001E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.0249999999999999},{"$f":"C5*(1+D4)","v":1.0506249999999999},{"$f":"D5*(1+E4)","v":1.0768906249999999}]
[]
["Nominal Vanilla WACC",null,{"$f":"Inputs!B84","v":7.4364600000000003E-2},{"$f":"Inputs!C84","v":7.4364600000000003E-2},{"$f":"Inputs!D84","v":7.4364600000000003E-2}]
["Real Vanilla WACC",null,{"$f":"(1+C7)/(1+C4)-1","v":4.816058536585377E-2},{"$f":"(1+D7)/(1+D4)-1","v":4.816058536585377E-2},4.816058536585377E-2]
[]
["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!B$91","v":5105.6603994842471},{"$f":"Inputs!C$91","v":5436.2333015825243},{"$f":"Inputs!D$91","v":5816.4767188425412}]
["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":5105.6603994842471},{"$f":"SUM(D15:D17)","v":5436.2333015825243},{"$f":"SUM(E15:E17)","v":5816.4767188425412}]
["NPV",{"$f":"NPV($C$7,C18:E18)","v":14152.322774487875}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":3.8776931967922756E-2},{"$f":"(E18/(1+E$4))/D18-1","v":4.3849871447790179E-2}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":5105.6603994842471},{"$f":"C22*(1+D$4)*(1+D24)","v":5445.0513892711242},{"$f":"D22*(1+E$4)*(1+E24)","v":5807.0028775902092}]
["NPV",{"$f":"NPV($C$7,C22:E22)","v":14152.322774487873}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Full-Cost Tariffs'!E69","v":4.0461926994225586E-2},{"$f":"'SW Full-Cost Tariffs'!F69","v":4.0461926994225586E-2}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":0},null,null,{"$f":"E22/E18-1","v":-1.6287938059893481E-3},"Difference between final year revenue and requirement"]
[]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C22","v":3063.3962396905481}]
["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.912599581588532},null,{"$f":"C40/(1+C$4)/B40-1","v":-5.6742609000878685E-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.4213237896106867},null,{"$f":"C41/(1+C$4)/B41-1","v":-0.16870902052162295}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!I$6","v":12.827179920202266},{"$f":"C30*10^3/C36","v":12.459072921907993},null,-5.2387729012791873E-2]
[null,null,null,null,{"$f":"C49/(1+C$4)/(SUMPRODUCT(B40:B42,C34:C36)/10^3)-1","v":-9.5841180139046855E-2},"Average"]
[]
["Tariffs Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C40/10^3","v":298.53517056176855}]
["General Security Entitlement",null,{"$f":"C35*C41/10^3","v":1743.7289892319307}]
["Usage",null,{"$f":"C36*C42/10^3","v":3063.3962396905481}]
[null,null,{"$f":"SUM(C46:C48)","v":5105.6603994842471}]
["Check",null,{"$f":"ABS(C49-C22)","v":0}]
[]
[]
["Revenue Requirement  - MDBA / BCR costs",null,"2014-15"]
["MDBA / BCR costs ($'000 Nominal)",null,{"$f":"Inputs!B$118*C$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":5105.6603994842471}]
[{"$f":"A53","v":"Revenue Requirement  - MDBA / BCR costs"},null,{"$f":"C54","v":0}]
[null,null,{"$f":"SUM(C81:C82)","v":5105.6603994842471}]
[]
[]
[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.912599581588532},null,{"$f":"C88/(1+C$4)/B88-1","v":-6.712935501878925E-2}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!C$6","v":4.0599999999999996},{"$f":"SUM(C41,C68)","v":3.4213237896106867},null,{"$f":"C89/(1+C$4)/B89-1","v":-0.17786284041555034}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!D$6","v":12.97},{"$f":"SUM(C42,C69)","v":12.459072921907993},null,-6.2822429102206367E-2]
[null,null,null,null,{"$f":"C97/(1+C$4)/(SUMPRODUCT(B88:B90,C34:C36)/10^3)-1","v":-0.10579738945303063},"Average"]
[]
["Total Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C88/10^3","v":298.53517056176855}]
["General Security Entitlement",null,{"$f":"C35*C89/10^3","v":1743.7289892319307}]
["Usage",null,{"$f":"C36*C90/10^3","v":3063.3962396905481}]
[null,null,{"$f":"SUM(C94:C96)","v":5105.6603994842471}]
["Check",null,{"$f":"ABS(C97-C83)","v":0}]

{"sheet":"Namoi","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":1.8189894035458565E-12}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!B83","v":2.5000000000000001E-2},{"$f":"Inputs!C83","v":2.5000000000000001E-2},{"$f":"Inputs!D83","v":2.5000000000000001E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.0249999999999999},{"$f":"C5*(1+D4)","v":1.0506249999999999},{"$f":"D5*(1+E4)","v":1.0768906249999999}]
[]
["Nominal Vanilla WACC",null,{"$f":"Inputs!B84","v":7.4364600000000003E-2},{"$f":"Inputs!C84","v":7.4364600000000003E-2},{"$f":"Inputs!D84","v":7.4364600000000003E-2}]
["Real Vanilla WACC",null,{"$f":"(1+C7)/(1+C4)-1","v":4.816058536585377E-2},{"$f":"(1+D7)/(1+D4)-1","v":4.816058536585377E-2},4.816058536585377E-2]
[]
["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!B$92","v":5597.1692216211313},{"$f":"Inputs!C$92","v":5805.8042592758547},{"$f":"Inputs!D$92","v":5942.6756674129792}]
["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":5597.1692216211313},{"$f":"SUM(D15:D17)","v":5805.8042592758547},{"$f":"SUM(E15:E17)","v":5942.6756674129792}]
["NPV",{"$f":"NPV($C$7,C18:E18)","v":15031.7564011958}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":1.1975706480739978E-2},{"$f":"(E18/(1+E$4))/D18-1","v":-1.3903157019581336E-3}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":5597.1692216211313},{"$f":"C22*(1+D$4)*(1+D24)","v":5780.5082924207409},{"$f":"D22*(1+E$4)*(1+E24)","v":5969.8527587248882}]
["NPV",{"$f":"NPV($C$7,C22:E22)","v":15031.7564011958}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Full-Cost Tariffs'!H69","v":7.5665147846165461E-3},{"$f":"'SW Full-Cost Tariffs'!I69","v":7.5665147846165461E-3}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":0},null,null,{"$f":"E22/E18-1","v":4.573207900430365E-3},"Difference between final year revenue and requirement"]
[]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C22","v":3358.3015329726786}]
["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":17.498133277863712},null,{"$f":"C40/(1+C$4)/B40-1","v":6.5636802349139822E-2}]
[{"$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":8.1361266460259642},null,{"$f":"C41/(1+C$4)/B41-1","v":-0.11585772365630431}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!I$7","v":19.733461742058335},{"$f":"C30*10^3/C36","v":21.126579199972099},null,4.4484594232713892E-2]
[null,null,null,null,{"$f":"C49/(1+C$4)/(SUMPRODUCT(B40:B42,C34:C36)/10^3)-1","v":-2.1060471081619792E-2},"Average"]
[]
["Tariffs Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C40/10^3","v":155.40092164070762}]
["General Security Entitlement",null,{"$f":"C35*C41/10^3","v":2083.4667670077447}]
["Usage",null,{"$f":"C36*C42/10^3","v":3358.3015329726786}]
[null,null,{"$f":"SUM(C46:C48)","v":5597.1692216211304}]
["Check",null,{"$f":"ABS(C49-C22)","v":9.0949470177292824E-13}]
[]
[]
["Revenue Requirement  - MDBA / BCR costs",null,"2014-15"]
["MDBA / BCR costs ($'000 Nominal)",null,{"$f":"Inputs!B$119*C$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":5597.1692216211313}]
[{"$f":"A53","v":"Revenue Requirement  - MDBA / BCR costs"},null,{"$f":"C54","v":0}]
[null,null,{"$f":"SUM(C81:C82)","v":5597.1692216211313}]
[]
[]
[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":17.498133277863712},null,{"$f":"C88/(1+C$4)/B88-1","v":5.2487641145452013E-2}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!C$7","v":9.09},{"$f":"SUM(C41,C68)","v":8.1361266460259642},null,{"$f":"C89/(1+C$4)/B89-1","v":-0.12676737813990546}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!D$7","v":19.98},{"$f":"SUM(C42,C69)","v":21.126579199972099},null,3.1596435458487671E-2]
[null,null,null,null,{"$f":"C97/(1+C$4)/(SUMPRODUCT(B88:B90,C34:C36)/10^3)-1","v":-3.3139852767794631E-2},"Average"]
[]
["Total Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C88/10^3","v":155.40092164070762}]
["General Security Entitlement",null,{"$f":"C35*C89/10^3","v":2083.4667670077447}]
["Usage",null,{"$f":"C36*C90/10^3","v":3358.3015329726786}]
[null,null,{"$f":"SUM(C94:C96)","v":5597.1692216211304}]
["Check",null,{"$f":"ABS(C97-C83)","v":9.0949470177292824E-13}]

{"sheet":"Peel - cost reflective tariffs","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":4.5474735088646412E-13}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!B83","v":2.5000000000000001E-2},{"$f":"Inputs!C83","v":2.5000000000000001E-2},{"$f":"Inputs!D83","v":2.5000000000000001E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.0249999999999999},{"$f":"C5*(1+D4)","v":1.0506249999999999},{"$f":"D5*(1+E4)","v":1.0768906249999999}]
[]
["Nominal Vanilla WACC",null,{"$f":"Inputs!B84","v":7.4364600000000003E-2},{"$f":"Inputs!C84","v":7.4364600000000003E-2},{"$f":"Inputs!D84","v":7.4364600000000003E-2}]
["Real Vanilla WACC",null,{"$f":"(1+C7)/(1+C4)-1","v":4.816058536585377E-2},{"$f":"(1+D7)/(1+D4)-1","v":4.816058536585377E-2},4.816058536585377E-2]
[]
["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!B$93","v":1371.6056882848941},{"$f":"Inputs!C$93","v":1424.6060695110673},{"$f":"Inputs!D$93","v":1457.2605831500264}]
["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":1371.6056882848941},{"$f":"SUM(D15:D17)","v":1424.6060695110673},{"$f":"SUM(E15:E17)","v":1457.2605831500264}]
["NPV",{"$f":"NPV($C$7,C18:E18)","v":3686.0033549440341}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":1.3308410632744572E-2},{"$f":"(E18/(1+E$4))/D18-1","v":-2.0275271005070206E-3}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":1371.6056882848941},{"$f":"C22*(1+D$4)*(1+D24)","v":1417.4889040025669},{"$f":"D22*(1+E$4)*(1+E24)","v":1464.9070138247012}]
["NPV",{"$f":"NPV($C$7,C22:E22)","v":3686.003354944035}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Full-Cost Tariffs'!K69","v":8.2460401824318557E-3},{"$f":"'SW Full-Cost Tariffs'!L69","v":8.2460401824318557E-3}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":0},null,null,{"$f":"E22/E18-1","v":5.2471265352873608E-3},"Difference between final year revenue and requirement"]
[]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C22","v":822.96341297093647}]
["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}]
["General Security Entitlement (ML)",null,{"$f":"Inputs!C$51","v":30528}]
["Forecast water volumes (ML)",null,{"$f":"Inputs!D$51","v":11163.91}]
[]
[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$8","v":25.076315111646519},{"$f":"C41*C31","v":26.797866014004811},null,{"$f":"C40/(1+C$4)/B40-1","v":4.2587772942597635E-2}]
[{"$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.7136323459946916},null,{"$f":"C41/(1+C$4)/B41-1","v":-3.9910275168088427E-2}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!I$8","v":41.422210075252544},{"$f":"C30*10^3/C36","v":73.716414139036999},null,0.73622925208280821]
[null,null,null,null,{"$f":"C49/(1+C$4)/(SUMPRODUCT(B40:B42,C34:C36)/10^3)-1","v":0.36199877951300485},"Average"]
[]
["Tariffs Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C40/10^3","v":465.80050705543158}]
["General Security Entitlement",null,{"$f":"C35*C41/10^3","v":82.841768258525946}]
["Usage",null,{"$f":"C36*C42/10^3","v":822.96341297093647}]
[null,null,{"$f":"SUM(C46:C48)","v":1371.6056882848939}]
["Check",null,{"$f":"ABS(C49-C22)","v":2.2737367544323206E-13}]
[]
[]
["Revenue Requirement  - MDBA / BCR costs",null,"2014-15"]
["MDBA / BCR costs ($'000 Nominal)",null,{"$f":"Inputs!B$120*C$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":1371.6056882848941}]
[{"$f":"A53","v":"Revenue Requirement  - MDBA / BCR costs"},null,{"$f":"C54","v":0}]
[null,null,{"$f":"SUM(C81:C82)","v":1371.6056882848941}]
[]
[]
[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.797866014004811},null,{"$f":"C88/(1+C$4)/B88-1","v":3.7882474230184648E-2}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!C$8","v":2.77},{"$f":"SUM(C41,C68)","v":2.7136323459946916},null,{"$f":"C89/(1+C$4)/B89-1","v":-4.4243252269193678E-2}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!D$8","v":41.61},{"$f":"SUM(C42,C69)","v":73.716414139036999},null,0.72839348278232863]
[null,null,null,null,{"$f":"C97/(1+C$4)/(SUMPRODUCT(B88:B90,C34:C36)/10^3)-1","v":0.355851948263044},"Average"]
[]
["Total Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C88/10^3","v":465.80050705543158}]
["General Security Entitlement",null,{"$f":"C35*C89/10^3","v":82.841768258525946}]
["Usage",null,{"$f":"C36*C90/10^3","v":822.96341297093647}]
[null,null,{"$f":"SUM(C94:C96)","v":1371.6056882848939}]
["Check",null,{"$f":"ABS(C97-C83)","v":2.2737367544323206E-13}]

{"sheet":"Peel - 10% price cap","index":8,"n_rows":57,"n_cols":17,"rows_kept":57,"cut":false,"hidden":false,"merged":[[36,5,36,7]]}
[]
[null,"Peel Valley prices capped at 10% annual real increase - in $2013-14"]
[]
[null,"2013-14 Peel tariffs (excluding MDBA costs)  ($2013-14)",null,null,null,"2014-15 Peel tariffs (excluding MDBA costs)  ($2013-14)",null,null,null,"2015-16 Peel tariffs (excluding MDBA costs)  ($2013-14)",null,null,null,"2016-17 Peel tariffs (excluding MDBA costs)  ($2013-14)"]
[null,"High Security Entitlement ($/ML)","General Security Entitlement ($/ML)","Usage ($/ML delivered)",null,"High Security Entitlement ($/ML)","General Security Entitlement ($/ML)","Usage ($/ML delivered)",null,"High Security Entitlement ($/ML)","General Security Entitlement ($/ML)","Usage ($/ML delivered)",null,"High Security Entitlement ($/ML)","General Security Entitlement ($/ML)","Usage ($/ML delivered)"]
[null,"2013-14","2013-14","2013-14",null,"2014-15","2014-15","2014-15",null,"2015-16","2015-16","2015-16",null,"2016-17","2016-17","2016-17"]
[null,{"$f":"Inputs!G8","v":25.076315111646519},{"$f":"Inputs!H8","v":2.7574987240675211},{"$f":"Inputs!I8","v":41.422210075252544},null,{"$f":"B7*1.1","v":27.583946622811172},{"$f":"C7*1.1","v":3.0332485964742735},45.564431082777801,null,{"$f":"F7*1.1","v":30.342341285092292},3.3365734561217013,50.120874191055584,null,{"$f":"J7*1.1","v":33.376575413601522},3.6702308017338718,55.132961610161146]
[]
[]
[]
[null,"Peel Valley prices capped at 10% annual increase - in nominal $"]
[null,"- assuming inflation of 2.5 per cent per annum"]
[null,"2013-14 Peel tariffs (excluding MDBA costs)  ($2013-14)",null,null,null,"2014-15 Peel tariffs (excluding MDBA costs)  ($2014-15)",null,null,null,"2015-16 Peel tariffs (excluding MDBA costs)  ($2015-16)",null,null,null,"2016-17 Peel tariffs (excluding MDBA costs)  ($2016-17)"]
[null,"High Security Entitlement ($/ML)","General Security Entitlement ($/ML)","Usage ($/ML delivered)",null,"High Security Entitlement ($/ML)","General Security Entitlement ($/ML)","Usage ($/ML delivered)",null,"High Security Entitlement ($/ML)","General Security Entitlement ($/ML)","Usage ($/ML delivered)",null,"High Security Entitlement ($/ML)","General Security Entitlement ($/ML)","Usage ($/ML delivered)"]
[null,"2013-14","2013-14","2013-14",null,"2014-15","2014-15","2014-15",null,"2015-16","2015-16","2015-16",null,"2016-17","2016-17","2016-17"]
[null,{"$f":"B7","v":25.076315111646519},{"$f":"C7","v":2.7574987240675211},{"$f":"D7","v":41.422210075252544},null,{"$f":"B16*1.1*'SW Full-Cost Tariffs'!$B$5","v":28.273545288381449},{"$f":"C16*1.1*'SW Full-Cost Tariffs'!$B$5","v":3.1090798113861302},{"$f":"D16*1.1*'SW Full-Cost Tariffs'!$B$5","v":46.703541859847242},null,{"$f":"F16*1.1*1.025","v":31.878422312650081},{"$f":"G16*1.1*1.025","v":3.5054874873378616},52.658243446977764,null,{"$f":"J16*1.1*1.025","v":35.942921157512963},3.952437141973439,59.372169486467428]
[]
[]
[null,null,null,null,null,"Forecast revenue recovery (10% cap)",null,null,null,null,"Forecast revenue recovery (10% cap)",null,null,null,"Forecast revenue recovery (10% cap)"]
[null,null,null,null,null,"High Security Entitlement Revenue","General Security Entitlement Revenue","Usage revenue",null,"High Security Entitlement Revenue","General Security Entitlement Revenue","Usage revenue",null,"High Security Entitlement Revenue","General Security Entitlement Revenue","Usage revenue"]
[null,null,null,null,null,"2014-15","2014-15","2014-15",null,"2015-16","2015-16","2015-16",null,"2016-17","2016-17","2016-17"]
[null,null,null,null,null,{"$f":"F16*$D$55","v":491450.76420264633},{"$f":"G16*$D$56","v":94913.988481995781},{"$f":"H16*$D$57","v":521394.13800456724},null,{"$f":"J16*$D$55","v":554110.73663848371},{"$f":"K16*$D$56","v":107015.52201345025},{"$f":"L16*$D$57","v":587871.89060014952},null,{"$f":"N16*$D$55","v":624759.85555989027},{"$f":"O16*$D$56","v":120660.00107016515},{"$f":"P16*$D$57","v":662825.55665166862}]
[]
[null,null,null,"Total 2014-17",null,null,null,null,"2014-15",null,null,null,"2015-16",null,null,null,"2016-17"]
[null,"Total revenue 2014-17 at capped prices",null,{"$f":"SUM(Q25,M25,I25)","v":3765002.453223017},null,null,"Total revenue - capped prices",null,{"$f":"SUM(F22:H22)","v":1107758.8906892093},null,"Total revenue - capped prices",null,{"$f":"SUM(J22:L22)","v":1248998.1492520836},null,"Total revenue - capped prices",null,{"$f":"SUM(N22:P22)","v":1408245.4132817241}]
[]
[]
[]
[null,"Peel Valley prices for full-cost recovery - in nominal $"]
[]
[null,"2013-14 Peel tariffs (excluding MDBA costs)  ($2013-14)",null,null,null,"2014-15 Peel tariffs (excluding MDBA costs)  ($2014-15)",null,null,null,"2015-16 Peel tariffs (excluding MDBA costs)  ($2015-16)",null,null,null,"2016-17 Peel tariffs (excluding MDBA costs)  ($2016-17)"]
[null,"High Security Entitlement ($/ML)","General Security Entitlement ($/ML)","Usage ($/ML delivered)",null,"High Security Entitlement ($/ML)","General Security Entitlement ($/ML)","Usage ($/ML delivered)",null,"High Security Entitlement ($/ML)","General Security Entitlement ($/ML)","Usage ($/ML delivered)",null,"High Security Entitlement ($/ML)","General Security Entitlement ($/ML)","Usage ($/ML delivered)"]
[null,"2013-14","2013-14","2013-14",null,"2014-15","2014-15","2014-15",null,"2015-16","2015-16","2015-16",null,"2016-17","2016-17","2016-17"]
[null,{"$f":"B16","v":25.076315111646519},{"$f":"C16","v":2.7574987240675211},{"$f":"D16","v":41.422210075252544},null,{"$f":"'SW Full-Cost Tariffs'!B13","v":26.797866014004811},{"$f":"'SW Full-Cost Tariffs'!F13","v":2.7136323459946916},{"$f":"'SW Full-Cost Tariffs'!J13","v":73.716414139036999},null,{"$f":"'SW Full-Cost Tariffs'!C13","v":27.694313351308708},{"$f":"'SW Full-Cost Tariffs'!G13","v":2.8044092940441128},{"$f":"'SW Full-Cost Tariffs'!K13","v":76.182389718435573},null,{"$f":"'SW Full-Cost Tariffs'!D13","v":28.620748816329165},{"$f":"'SW Full-Cost Tariffs'!H13","v":2.8982229299150548},{"$f":"'SW Full-Cost Tariffs'!L13","v":78.730857584378654}]
[]
[]
[null,null,null,null,null,"Forecast revenue recovery (cost reflective)",null,null,null,null,"Forecast revenue recovery (cost reflective)",null,null,null,"Forecast revenue recovery (cost reflective)"]
[null,null,null,null,null,"High Security Entitlement Revenue","General Security Entitlement Revenue","Usage revenue",null,"High Security Entitlement Revenue","General Security Entitlement Revenue","Usage revenue",null,"High Security Entitlement Revenue","General Security Entitlement Revenue","Usage revenue"]
[null,null,null,null,null,"2014-15","2014-15","2014-15",null,"2015-16","2015-16","2015-16",null,"2016-17","2016-17","2016-17"]
[null,null,null,null,null,{"$f":"F34*$D$55","v":465800.5070554316},{"$f":"G34*$D$56","v":82841.768258525946},{"$f":"H34*$D$57","v":822963.41297093651},null,{"$f":"J34*$D$55","v":481382.55467244796},{"$f":"K34*$D$56","v":85613.006928578674},{"$f":"L34*$D$57","v":850493.34240154002},null,{"$f":"N34*$D$55","v":497485.85592543357},{"$f":"O34*$D$56","v":88476.949604446796},{"$f":"P34*$D$57","v":878944.20829482074}]
[]
[null,null,null,"Total 2014-17",null,null,null,null,"2014-15",null,null,null,"2015-16",null,null,null,"2016-17"]
[null,"Total revenue for full-cost recovery",null,{"$f":"SUM(Q43,M43,I43)","v":4254001.6061121617},null,null,"Total revenue for full-cost recovery",null,{"$f":"SUM(F40:H40)","v":1371605.688284894},null,"Total revenue for full-cost recovery",null,{"$f":"SUM(J40:L40)","v":1417488.9040025668},null,"Total revenue for full-cost recovery",null,{"$f":"SUM(N40:P40)","v":1464907.0138247011}]
[]
[null,"Extent of cost recovery"]
[]
[null,"Total difference (shortfall) 2014-17",null,{"$f":"SUM(I47,M47,Q47)","v":-488999.15288914484},null,null,"Difference (shortfall)",null,{"$f":"I25-I43","v":-263846.79759568465},null,"Difference (shortfall)",null,{"$f":"M25-M43","v":-168490.7547504832},null,"Difference (shortfall)",null,{"$f":"Q25-Q43","v":-56661.600542976987}]
[null,"% difference (shortfall)",null,{"$f":"D47/D43","v":-0.11495039216406253},null,null,"% difference (shortfall)",null,{"$f":"I47/I43","v":-0.19236344661533764},null,"% difference (shortfall)",null,{"$f":"M47/M43","v":-0.11886566044694633},null,"% difference (shortfall)",null,{"$f":"Q47/Q43","v":-3.8679315484359766E-2}]
[]
[null,"% revenue recovered through tariffs",null,{"$f":"D25/D43","v":0.88504960783593756},null,null,"check",null,{"$f":"I43-'Peel - cost reflective tariffs'!$C$22*1000","v":0},null,"check",null,{"$f":"M43-'Peel - cost reflective tariffs'!D22*1000","v":0},null,"check",null,{"$f":"Q43-'Peel - cost reflective tariffs'!E22*1000","v":0}]
[]
[]
[null,"Forecast sales quantities"]
[null,"(per annum, 2014-15 to 2016-17)",null,"2014-15"]
[null,"High Security Entitlement (ML)",null,{"$f":"Inputs!B$51","v":17382}]
[null,"General Security Entitlement (ML)",null,{"$f":"Inputs!C$51","v":30528}]
[null,"Forecast water volumes (ML)",null,{"$f":"Inputs!D$51","v":11163.91}]

{"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!B83","v":2.5000000000000001E-2},{"$f":"Inputs!C83","v":2.5000000000000001E-2},{"$f":"Inputs!D83","v":2.5000000000000001E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.0249999999999999},{"$f":"C5*(1+D4)","v":1.0506249999999999},{"$f":"D5*(1+E4)","v":1.0768906249999999}]
[]
["Nominal Vanilla WACC",null,{"$f":"Inputs!B84","v":7.4364600000000003E-2},{"$f":"Inputs!C84","v":7.4364600000000003E-2},{"$f":"Inputs!D84","v":7.4364600000000003E-2}]
["Real Vanilla WACC",null,{"$f":"(1+C7)/(1+C4)-1","v":4.816058536585377E-2},{"$f":"(1+D7)/(1+D4)-1","v":4.816058536585377E-2},4.816058536585377E-2]
[]
["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!B$94","v":7122.8222354706295},{"$f":"Inputs!C$94","v":7610.4056612214335},{"$f":"Inputs!D$94","v":8160.2641431053189}]
["ICD Rebates",null,{"$f":"Inputs!B$108*C$5","v":69.857564714754758},{"$f":"Inputs!C$108*D$5","v":65.517340327756472},{"$f":"Inputs!D$108*E$5","v":64.600730946705525}]
[]
["Total Revenue Requirement (user share) - Unsmoothed",null,{"$f":"SUM(C15:C17)","v":7192.679800185384},{"$f":"SUM(D15:D17)","v":7675.9230015491903},{"$f":"SUM(E15:E17)","v":8224.8648740520239}]
["NPV",{"$f":"NPV($C$7,C18:E18)","v":19977.353222649541}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":4.1156505697925061E-2},{"$f":"(E18/(1+E$4))/D18-1","v":4.5380263987770508E-2}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":7192.679800185384},{"$f":"C22*(1+D$4)*(1+D24)","v":7686.2750159442694},{"$f":"D22*(1+E$4)*(1+E24)","v":8213.743036247266}]
["NPV",{"$f":"NPV($C$7,C22:E22)","v":19977.353222649544}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Full-Cost Tariffs'!N69","v":4.2560645256430246E-2},{"$f":"'SW Full-Cost Tariffs'!O69","v":4.2560645256430246E-2}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":0},null,null,{"$f":"E22/E18-1","v":-1.3522213404192351E-3},"Difference between final year revenue and requirement"]
[]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C22","v":4315.6078801112299}]
["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":13.212087448443645},null,{"$f":"C40/(1+C$4)/B40-1","v":4.2867428245610961E-2}]
[{"$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.2781011034728449},null,{"$f":"C41/(1+C$4)/B41-1","v":-0.27643723574156376}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!I$9","v":18.04},{"$f":"C30*10^3/C36","v":18.953277765954354},null,2.50001495838168E-2]
[null,null,null,null,{"$f":"C49/(1+C$4)/(SUMPRODUCT(B40:B42,C34:C36)/10^3)-1","v":-8.3384170968976545E-2},"Average"]
[]
["Tariffs Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C40/10^3","v":802.56825205570919}]
["General Security Entitlement",null,{"$f":"C35*C41/10^3","v":2074.5036680184448}]
["Usage",null,{"$f":"C36*C42/10^3","v":4315.6078801112299}]
[null,null,{"$f":"SUM(C46:C48)","v":7192.679800185384}]
["Check",null,{"$f":"ABS(C49-C22)","v":0}]
[]
[]
["Revenue Requirement  - MDBA / BCR costs",null,"2014-15"]
["MDBA / BCR costs ($'000 Nominal)",null,{"$f":"Inputs!B$121*C$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":7192.679800185384}]
[{"$f":"A53","v":"Revenue Requirement  - MDBA / BCR costs"},null,{"$f":"C54","v":0}]
[null,null,{"$f":"SUM(C81:C82)","v":7192.679800185384}]
[]
[]
[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":13.212087448443645},null,{"$f":"C88/(1+C$4)/B88-1","v":4.2867428245610961E-2}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!C$9","v":4.42},{"$f":"SUM(C41,C68)","v":3.2781011034728449},null,{"$f":"C89/(1+C$4)/B89-1","v":-0.27643723574156376}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!D$9","v":18.04},{"$f":"SUM(C42,C69)","v":18.953277765954354},null,2.50001495838168E-2]
[null,null,null,null,{"$f":"C97/(1+C$4)/(SUMPRODUCT(B88:B90,C34:C36)/10^3)-1","v":-8.3384170968976545E-2},"Average"]
[]
["Total Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C88/10^3","v":802.56825205570919}]
["General Security Entitlement",null,{"$f":"C35*C89/10^3","v":2074.5036680184448}]
["Usage",null,{"$f":"C36*C90/10^3","v":4315.6078801112299}]
[null,null,{"$f":"SUM(C94:C96)","v":7192.679800185384}]
["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":0}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!B83","v":2.5000000000000001E-2},{"$f":"Inputs!C83","v":2.5000000000000001E-2},{"$f":"Inputs!D83","v":2.5000000000000001E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.0249999999999999},{"$f":"C5*(1+D4)","v":1.0506249999999999},{"$f":"D5*(1+E4)","v":1.0768906249999999}]
[]
["Nominal Vanilla WACC",null,{"$f":"Inputs!B84","v":7.4364600000000003E-2},{"$f":"Inputs!C84","v":7.4364600000000003E-2},{"$f":"Inputs!D84","v":7.4364600000000003E-2}]
["Real Vanilla WACC",null,{"$f":"(1+C7)/(1+C4)-1","v":4.816058536585377E-2},{"$f":"(1+D7)/(1+D4)-1","v":4.816058536585377E-2},4.816058536585377E-2]
[]
["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!B$95","v":7030.3594397776315},{"$f":"Inputs!C$95","v":7355.8047259259847},{"$f":"Inputs!D$95","v":7821.8893224368585}]
["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":7030.3594397776315},{"$f":"SUM(D15:D17)","v":7355.8047259259847},{"$f":"SUM(E15:E17)","v":7821.8893224368585}]
["NPV",{"$f":"NPV($C$7,C18:E18)","v":19223.976396745766}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":2.0772112156604683E-2},{"$f":"(E18/(1+E$4))/D18-1","v":3.7427150178201529E-2}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":7030.3594397776315},{"$f":"C22*(1+D$4)*(1+D24)","v":7395.3857888202165},{"$f":"D22*(1+E$4)*(1+E24)","v":7779.3648296329366}]
["NPV",{"$f":"NPV($C$7,C22:E22)","v":19223.976396745773}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Full-Cost Tariffs'!B77","v":2.6264814407052531E-2},{"$f":"'SW Full-Cost Tariffs'!C77","v":2.6264814407052531E-2}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":0},null,null,{"$f":"E22/E18-1","v":-5.4366011907048817E-3},"Difference between final year revenue and requirement"]
[]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C22","v":4218.2156638665783}]
["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":13.142347047236655},null,{"$f":"C40/(1+C$4)/B40-1","v":0.12939133988745977}]
[{"$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.5652111670695192},null,{"$f":"C41/(1+C$4)/B41-1","v":-0.17480416477160976}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!I$10","v":13.897787923324605},{"$f":"C30*10^3/C36","v":15.08279608473342},null,5.8796053780617807E-2]
[null,null,null,null,{"$f":"C49/(1+C$4)/(SUMPRODUCT(B40:B42,C34:C36)/10^3)-1","v":-2.4788070471004175E-2},"Average"]
[]
["Tariffs Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C40/10^3","v":559.94283829456481}]
["General Security Entitlement",null,{"$f":"C35*C41/10^3","v":2252.2009376164883}]
["Usage",null,{"$f":"C36*C42/10^3","v":4218.2156638665783}]
[null,null,{"$f":"SUM(C46:C48)","v":7030.3594397776315}]
["Check",null,{"$f":"ABS(C49-C22)","v":0}]
[]
[]
["Revenue Requirement  - MDBA / BCR costs",null,"2014-15"]
["MDBA / BCR costs ($'000 Nominal)",null,{"$f":"Inputs!B$122*C$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":7030.3594397776315}]
[{"$f":"A53","v":"Revenue Requirement  - MDBA / BCR costs"},null,{"$f":"C54","v":0}]
[null,null,{"$f":"SUM(C81:C82)","v":7030.3594397776315}]
[]
[]
[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":13.142347047236655},null,{"$f":"C88/(1+C$4)/B88-1","v":0.12274973706690506}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!C$10","v":4.24},{"$f":"SUM(C41,C68)","v":3.5652111670695192},null,{"$f":"C89/(1+C$4)/B89-1","v":-0.17965688746674657}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!D$10","v":13.98},{"$f":"SUM(C42,C69)","v":15.08279608473342},null,5.2569600107011505E-2]
[null,null,null,null,{"$f":"C97/(1+C$4)/(SUMPRODUCT(B88:B90,C34:C36)/10^3)-1","v":-3.0522991638758046E-2},"Average"]
[]
["Total Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C88/10^3","v":559.94283829456481}]
["General Security Entitlement",null,{"$f":"C35*C89/10^3","v":2252.2009376164883}]
["Usage",null,{"$f":"C36*C90/10^3","v":4218.2156638665783}]
[null,null,{"$f":"SUM(C94:C96)","v":7030.3594397776315}]
["Check",null,{"$f":"ABS(C97-C83)","v":0}]

{"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":0}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!B83","v":2.5000000000000001E-2},{"$f":"Inputs!C83","v":2.5000000000000001E-2},{"$f":"Inputs!D83","v":2.5000000000000001E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.0249999999999999},{"$f":"C5*(1+D4)","v":1.0506249999999999},{"$f":"D5*(1+E4)","v":1.0768906249999999}]
[]
["Nominal Vanilla WACC",null,{"$f":"Inputs!B84","v":7.4364600000000003E-2},{"$f":"Inputs!C84","v":7.4364600000000003E-2},{"$f":"Inputs!D84","v":7.4364600000000003E-2}]
["Real Vanilla WACC",null,{"$f":"(1+C7)/(1+C4)-1","v":4.816058536585377E-2},{"$f":"(1+D7)/(1+D4)-1","v":4.816058536585377E-2},4.816058536585377E-2]
[]
["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!B$96","v":5417.1286275939538},{"$f":"Inputs!C$96","v":5449.1673145676987},{"$f":"Inputs!D$96","v":5580.8846552357691}]
["ICD Rebates",null,{"$f":"Inputs!B$110*C$5","v":1056.9722202388882},{"$f":"Inputs!C$110*D$5","v":1010.5556733152683},{"$f":"Inputs!D$110*E$5","v":1004.5443385774263}]
[]
["Total Revenue Requirement (user share) - Unsmoothed",null,{"$f":"SUM(C15:C17)","v":6474.1008478328422},{"$f":"SUM(D15:D17)","v":6459.7229878829667},{"$f":"SUM(E15:E17)","v":6585.4289938131951}]
["NPV",{"$f":"NPV($C$7,C18:E18)","v":16932.82553097557}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":-2.6556904689565508E-2},{"$f":"(E18/(1+E$4))/D18-1","v":-5.4049087703234022E-3}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":6474.1008478328422},{"$f":"C22*(1+D$4)*(1+D24)","v":6505.2394169653026},{"$f":"D22*(1+E$4)*(1+E24)","v":6536.5277536887234}]
["NPV",{"$f":"NPV($C$7,C22:E22)","v":16932.82553097557}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Full-Cost Tariffs'!E77","v":-1.9697840655937847E-2},{"$f":"'SW Full-Cost Tariffs'!F77","v":-1.9697840655937847E-2}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":0},null,null,{"$f":"E22/E18-1","v":-7.4256726737791379E-3},"Difference between final year revenue and requirement"]
[]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C22","v":3884.4605086997053}]
["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.8005561889736623},null,{"$f":"C40/(1+C$4)/B40-1","v":3.2232180236487773E-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":1.0207877606779818},null,{"$f":"C41/(1+C$4)/B41-1","v":-0.21135800984128561}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!I$11","v":2.6935941472892257},{"$f":"C30*10^3/C36","v":2.6611563727630623},null,-3.613908487971329E-2]
[null,null,null,null,{"$f":"C49/(1+C$4)/(SUMPRODUCT(B40:B42,C34:C36)/10^3)-1","v":-9.7426962606742218E-2},"Average"]
[]
["Tariffs Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C40/10^3","v":470.6666481870476}]
["General Security Entitlement",null,{"$f":"C35*C41/10^3","v":2118.9736909460894}]
["Usage",null,{"$f":"C36*C42/10^3","v":3884.4605086997053}]
[null,null,{"$f":"SUM(C46:C48)","v":6474.1008478328422}]
["Check",null,{"$f":"ABS(C49-C22)","v":0}]
[]
[]
["Revenue Requirement  - MDBA / BCR costs",null,"2014-15"]
["MDBA / BCR costs ($'000 Nominal)",null,{"$f":"Inputs!B$123*C$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":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":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":6474.1008478328422}]
[{"$f":"A53","v":"Revenue Requirement  - MDBA / BCR costs"},null,{"$f":"C54","v":0}]
[null,null,{"$f":"SUM(C81:C82)","v":6474.1008478328422}]
[]
[]
[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":1.8005561889736623},null,{"$f":"C88/(1+C$4)/B88-1","v":-0.44056045083931572}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!C$11","v":2.33},{"$f":"SUM(C41,C68)","v":1.0207877606779818},null,{"$f":"C89/(1+C$4)/B89-1","v":-0.57257918531226548}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!D$11","v":4.97},{"$f":"SUM(C42,C69)","v":2.6611563727630623},null,-0.47761567006663153]
[null,null,null,null,{"$f":"C97/(1+C$4)/(SUMPRODUCT(B88:B90,C34:C36)/10^3)-1","v":-0.5108319012025071},"Average"]
[]
["Total Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C88/10^3","v":470.6666481870476}]
["General Security Entitlement",null,{"$f":"C35*C89/10^3","v":2118.9736909460894}]
["Usage",null,{"$f":"C36*C90/10^3","v":3884.4605086997053}]
[null,null,{"$f":"SUM(C94:C96)","v":6474.1008478328422}]
["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":9.6406438387930393E-10}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!B83","v":2.5000000000000001E-2},{"$f":"Inputs!C83","v":2.5000000000000001E-2},{"$f":"Inputs!D83","v":2.5000000000000001E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.0249999999999999},{"$f":"C5*(1+D4)","v":1.0506249999999999},{"$f":"D5*(1+E4)","v":1.0768906249999999}]
[]
["Nominal Vanilla WACC",null,{"$f":"Inputs!B84","v":7.4364600000000003E-2},{"$f":"Inputs!C84","v":7.4364600000000003E-2},{"$f":"Inputs!D84","v":7.4364600000000003E-2}]
["Real Vanilla WACC",null,{"$f":"(1+C7)/(1+C4)-1","v":4.816058536585377E-2},{"$f":"(1+D7)/(1+D4)-1","v":4.816058536585377E-2},4.816058536585377E-2]
[]
["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!B$97","v":9627.5113924267371},{"$f":"Inputs!C$97","v":9947.882480512968},{"$f":"Inputs!D$97","v":10041.31419460198}]
["ICD Rebates",null,{"$f":"Inputs!B$111*C$5","v":522.6656914046896},{"$f":"Inputs!C$111*D$5","v":493.06304152310565},{"$f":"Inputs!D$111*E$5","v":487.25629348957034}]
[]
["Total Revenue Requirement (user share) - Unsmoothed",null,{"$f":"SUM(C15:C17)","v":10150.177083831426},{"$f":"SUM(D15:D17)","v":10440.945522036074},{"$f":"SUM(E15:E17)","v":10528.570488091551}]
["NPV",{"$f":"NPV($C$7,C18:E18)","v":26983.320008501749}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":3.5576946147701793E-3},{"$f":"(E18/(1+E$4))/D18-1","v":-1.6202501558508886E-2}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":10150.177083831426},{"$f":"C22*(1+D$4)*(1+D24)","v":10373.273960492217},{"$f":"D22*(1+E$4)*(1+E24)","v":10601.274418239795}]
["NPV",{"$f":"NPV($C$7,C22:E22)","v":26983.320008500785}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Full-Cost Tariffs'!H77","v":-2.946727436911086E-3},{"$f":"'SW Full-Cost Tariffs'!I77","v":-2.946727436911086E-3}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":9.6406438387930393E-10},null,null,{"$f":"E22/E18-1","v":6.905394253709618E-3},"Difference between final year revenue and requirement"]
[]
[]
["Tariff Revenue",null,"2014-15"]
["Variable Charge Revenue",null,{"$f":"C$10*C22","v":6090.1062502988552}]
["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.8621434597406039},null,{"$f":"C40/(1+C$4)/B40-1","v":5.927452719346249E-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.2430883836140176},null,{"$f":"C41/(1+C$4)/B41-1","v":-0.13773992329197748}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!I$12","v":3.3437557008763554},{"$f":"C30*10^3/C36","v":3.4607990440967318},null,9.7595677904869227E-3]
[null,null,null,null,{"$f":"C49/(1+C$4)/(SUMPRODUCT(B40:B42,C34:C36)/10^3)-1","v":-3.0559356895898948E-2},"Average"]
[]
["Tariffs Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C40/10^3","v":1250.5506175775427}]
["General Security Entitlement",null,{"$f":"C35*C41/10^3","v":2809.5202159550281}]
["Usage",null,{"$f":"C36*C42/10^3","v":6090.1062502988552}]
[null,null,{"$f":"SUM(C46:C48)","v":10150.177083831426}]
["Check",null,{"$f":"ABS(C49-C22)","v":0}]
[]
[]
["Revenue Requirement  - MDBA / BCR costs",null,"2014-15"]
["MDBA / BCR costs ($'000 Nominal)",null,{"$f":"Inputs!B$124*C$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.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}]
[{"$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":10150.177083831426}]
[{"$f":"A53","v":"Revenue Requirement  - MDBA / BCR costs"},null,{"$f":"C54","v":0}]
[null,null,{"$f":"SUM(C81:C82)","v":10150.177083831426}]
[]
[]
[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":2.8621434597406039},null,{"$f":"C88/(1+C$4)/B88-1","v":-6.297480447189252E-2}]
[{"$f":"Inputs!C$3","v":"General Security Entitlement ($/ML)"},{"$f":"Inputs!C$12","v":1.59},{"$f":"SUM(C41,C68)","v":1.2430883836140176},null,{"$f":"C89/(1+C$4)/B89-1","v":-0.23725210393372131}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},{"$f":"Inputs!D$12","v":3.78},{"$f":"SUM(C42,C69)","v":3.4607990440967318},null,-0.1067753144672261]
[null,null,null,null,{"$f":"C97/(1+C$4)/(SUMPRODUCT(B88:B90,C34:C36)/10^3)-1","v":-0.14244109073000599},"Average"]
[]
["Total Tariff Revenue ($'000 Nominal)",null,"2014-15"]
["High Security Entitlement",null,{"$f":"C34*C88/10^3","v":1250.5506175775427}]
["General Security Entitlement",null,{"$f":"C35*C89/10^3","v":2809.5202159550281}]
["Usage",null,{"$f":"C36*C90/10^3","v":6090.1062502988552}]
[null,null,{"$f":"SUM(C94:C96)","v":10150.177083831426}]
["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":8.3377926785033196E-10}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!B83","v":2.5000000000000001E-2},{"$f":"Inputs!C83","v":2.5000000000000001E-2},{"$f":"Inputs!D83","v":2.5000000000000001E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.0249999999999999},{"$f":"C5*(1+D4)","v":1.0506249999999999},{"$f":"D5*(1+E4)","v":1.0768906249999999}]
[]
["Nominal Vanilla WACC",null,{"$f":"Inputs!B84","v":7.4364600000000003E-2},{"$f":"Inputs!C84","v":7.4364600000000003E-2},{"$f":"Inputs!D84","v":7.4364600000000003E-2}]
["Real Vanilla WACC",null,{"$f":"(1+C7)/(1+C4)-1","v":4.816058536585377E-2},{"$f":"(1+D7)/(1+D4)-1","v":4.816058536585377E-2},4.816058536585377E-2]
[]
["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!B$98","v":544.05073284378193},{"$f":"Inputs!C$98","v":582.03238789645786},{"$f":"Inputs!D$98","v":649.3833617843992}]
["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":544.05073284378193},{"$f":"SUM(D15:D17)","v":582.03238789645786},{"$f":"SUM(E15:E17)","v":649.3833617843992}]
["NPV",{"$f":"NPV($C$7,C18:E18)","v":1534.2965436544462}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":4.3719715307491747E-2},{"$f":"(E18/(1+E$4))/D18-1","v":8.8504276358239542E-2}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":544.05073284378193},{"$f":"C22*(1+D$4)*(1+D24)","v":590.30618172102061},{"$f":"D22*(1+E$4)*(1+E24)","v":640.49429059055672}]
["NPV",{"$f":"NPV($C$7,C22:E22)","v":1534.2965436536124}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Full-Cost Tariffs'!K77","v":5.8556555859089636E-2},{"$f":"'SW Full-Cost Tariffs'!L77","v":5.8556555859089636E-2}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":8.3377926785033196E-10},null,null,{"$f":"E22/E18-1","v":-1.368848005193235E-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.7283142340612877}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},null,{"$f":"Murrumbidgee!C42","v":3.4607990440967318}]
[]
[]
["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":544.05073284378193}]
["Usage",null,{"$f":"C36*C42/10^3","v":0}]
[null,null,{"$f":"SUM(C46:C48)","v":544.05073284378193}]
["Check",null,{"$f":"ABS(C49-C22)","v":0}]
[]
[]
["Revenue Requirement  - MDBA / BCR costs",null,"2014-15"]
["MDBA / BCR costs ($'000 Nominal)",null,{"$f":"Inputs!B$125*C$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":544.05073284378193}]
[{"$f":"A53","v":"Revenue Requirement  - MDBA / BCR costs"},null,{"$f":"C54","v":0}]
[null,null,{"$f":"SUM(C81:C82)","v":544.05073284378193}]
[]
[]
[]
["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.7283142340612877}]
[{"$f":"Inputs!D$3","v":"Usage ($/ML delivered)"},null,{"$f":"SUM(C42,C69)","v":3.4607990440967318}]
[]
[]
["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":544.05073284378193}]
["Usage",null,{"$f":"C36*C90/10^3","v":0}]
[null,null,{"$f":"SUM(C94:C96)","v":544.05073284378193}]
["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":5.8207660913467407E-10}]
[]
[null,null,"2014-15","2015-16","2016-17"]
["CPI Forecast",null,{"$f":"Inputs!B83","v":2.5000000000000001E-2},{"$f":"Inputs!C83","v":2.5000000000000001E-2},{"$f":"Inputs!D83","v":2.5000000000000001E-2}]
["CPI Index",null,{"$f":"1+C4","v":1.0249999999999999},{"$f":"C5*(1+D4)","v":1.0506249999999999},{"$f":"D5*(1+E4)","v":1.0768906249999999}]
["Nominal Vanilla WACC",null,{"$f":"Inputs!B84","v":7.4364600000000003E-2},{"$f":"Inputs!C84","v":7.4364600000000003E-2},{"$f":"Inputs!D84","v":7.4364600000000003E-2}]
["Real Vanilla WACC",null,{"$f":"(1+C6)/(1+C4)-1","v":4.816058536585377E-2},{"$f":"(1+D6)/(1+D4)-1","v":4.816058536585377E-2},{"$f":"(1+E6)/(1+E4)-1","v":4.816058536585377E-2}]
["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!B$99","v":10171.162262431115},{"$f":"Inputs!C$99","v":10516.696630717028},{"$f":"Inputs!D$99","v":10821.389953733642}]
["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":10171.162262431115},{"$f":"SUM(D15:D17)","v":10516.696630717028},{"$f":"SUM(E15:E17)","v":10821.389953733642}]
["NPV",{"$f":"NPV($C$6,C18:E18)","v":27304.606690909997}]
["Real Growth in Unsmoothed Revenue Requirement",null,null,{"$f":"(D18/(1+D$4))/C18-1","v":8.7531365755133539E-3},{"$f":"(E18/(1+E$4))/D18-1","v":3.8754548232005082E-3}]
[]
["Smoothed revenue requirement",null,{"$f":"C18","v":10171.162262431115},{"$f":"C22*(1+D$4)*(1+D24)","v":10499.955091022364},{"$f":"D22*(1+E$4)*(1+E24)","v":10839.376471331085}]
["NPV",{"$f":"NPV($C$6,C22:E22)","v":27304.606690910005}]
["Real Growth in Smoothed Revenue",null,null,{"$f":"'SW Full-Cost Tariffs'!N77","v":7.1473014667235895E-3},{"$f":"'SW Full-Cost Tariffs'!O77","v":7.1473014667235895E-3}]
[]
["Difference in NPVs",{"$f":"B19-B23","v":0},null,null,{"$f":"E22/E18-1","v":1.6621263695646427E-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.34657947118128452},null,{"$f":"C62/(1+C$4)/B62-1","v":-0.11019391224317188}]
["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":2836406.3921476323}]
["Sydney Catchment"]
["Price $",{"$f":"Inputs!$B$17","v":0.38},{"$f":"C$62","v":0.34657947118128452}]
["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":1265015.0698116885}]
["Oberon Council"]
["Price $",{"$f":"Inputs!$B$17","v":0.38},{"$f":"C$62","v":0.34657947118128452}]
["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":368760.5573368867}]
[]
["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":69.315894236256909}]
["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":5129.3761734830114}]
[]
["Sub total",{"$f":"SUM(B64,B68,B72,B78)","v":4801378},{"$f":"SUM(C64,C68,C72,C78)","v":4475311.3954696907}]
[]
["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.389374359552764},null,{"$f":"C84/(1+C$4)/B84-1","v":-0.1165641303397299}]
["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":2410168.1786038289}]
["Sydney Catchment"]
["Price $",{"$f":"Inputs!$C$17","v":0.43},{"$f":"C$84","v":0.389374359552764}]
["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":939026.40001028287}]
["Oberon Council"]
["Price $",{"$f":"Inputs!$C$17","v":0.43},{"$f":"C$84","v":0.389374359552764}]
["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":279215.26021866413}]
[]
["Individual Minor Customer tier 1"]
["Price $",{"$f":"Inputs!$C$18","v":0.85},{"$f":"C$84","v":0.389374359552764}]
["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":5762.740521380907}]
[]
["Individual Minor Customer tier 2"]
["Price $",null,{"$f":"C97","v":0.389374359552764}]
["Quantity (per unit) ",null,{"$f":"C44*10^3-C98","v":37292.876230661037}]
["Revenue  $",null,{"$f":"C102*C103","v":14520.889798194137}]
[]
["Raw Water: Individual Minor Customer access charge in excess of deemed MAQ"]
["Price $",null,{"$f":"C$62","v":0.34657947118128452}]
["Quantity (per unit) ",null,{"$f":"C44*10^3-C76","v":37292.876230661037}]
["Revenue  $",null,{"$f":"C107*C108","v":12924.945322851598}]
[]
["Tier 2 usage charge",null,{"$f":"SUM(C102,C107)","v":0.73595383073404852}]
["Quantity (kL)",null,{"$f":"C108","v":37292.876230661037}]
["Revenue",null,{"$f":"C111*C112","v":27445.835121045733}]
[]
["Sub total",{"$f":"SUM(B86,B90,B94,B99,B113)","v":4042172.4640999995},{"$f":"SUM(C86,C90,C94,C99,C113)","v":3661618.4144752026}]
[]
["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":8136929.8099448932}]
[]
[]
[]
[]
["  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.67077350598578445},null,{"$f":"C146/(1+C$4)/B146-1","v":0.14809329223069678}]
["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":1192635.2936427246}]
["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":134.1547011971569}]
["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":27904.177849008636}]
[]
["Sub total",{"$f":"SUM(B148,B153)","v":1201462.4025548999},{"$f":"SUM(C148,C153)","v":1220539.4714917333}]
[]
["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.67410845230544458},null,{"$f":"C159/(1+C$4)/B159-1","v":7.8142266781998648E-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":664334.21680124174}]
["Individual Minor Customer tier 1"]
["Price $",{"$f":"Inputs!$C$20","v":1.04},{"$f":"C$159","v":0.67410845230544458}]
["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":28042.911615906494}]
["Individual Minor Customer tier 2"]
["Price $",null,{"$f":"C163","v":0.67410845230544458}]
["Quantity (per kL) ",null,{"$f":"C55*10^3-C164","v":90205.576652601972}]
["Revenue  $",null,{"$f":"C167*C168","v":60808.341666605666}]
[]
["FIltered Water: Individual Minor Customer access charge in excess of deemed MAQ"]
["Price $",null,{"$f":"C146","v":0.67077350598578445}]
["Quantity (per unit) ",null,{"$f":"C55*10^3-C151","v":90205.576652601972}]
["Revenue  $",null,{"$f":"C172*C173","v":60507.510910735247}]
[]
["Tier 2 usage charge",null,{"$f":"SUM(C167,C172)","v":1.344881958291229}]
["Quantity (kL)",null,{"$f":"C173","v":90205.576652601972}]
["Revenue",null,{"$f":"C176*C177","v":121315.85257734091}]
[]
["Sub total",{"$f":"SUM(B161,B165,B178)","v":615091.30499999993},{"$f":"SUM(C161,C165,C178)","v":813692.98099448916}]
[]
["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":2034232.4524862226}]
[]
["Total revenue ",{"$f":"SUM(B138,B194)","v":10876799.233117627},{"$f":"SUM(C138,C194)","v":10171162.262431115},null,{"$f":"C196/(1+C$4)/B196-1","v":-8.7683341265932802E-2},"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":4475311.3954696907},{"$f":"ABS(C204-C266)","v":0}]
["Usage",{"$f":"SUM(B115,B136)","v":4056393.9894867786},{"$f":"SUM(C115,C136)","v":3661618.4144752026},{"$f":"ABS(C205-C265)","v":4.6566128730773926E-10}]
[null,{"$f":"SUM(B204:B205)","v":8857771.9894867782},{"$f":"SUM(C204:C205)","v":8136929.8099448932}]
[]
["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":1220539.4714917333},{"$f":"ABS(C209-C271)","v":0}]
["Usage",{"$f":"SUM(B180,B192)","v":817564.84107594937},{"$f":"SUM(C180,C192)","v":813692.98099448916},{"$f":"ABS(C210-C270)","v":1.1641532182693481E-10}]
[null,{"$f":"SUM(B209:B210)","v":2019027.2436308493},2034232.4524862226]
[]
["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":5695850.8669614242}]
["Usage",{"$f":"SUM(B205,B210)","v":4873958.8305627275},4475311.3954696916]
[null,{"$f":"SUM(B214:B215)","v":10876799.233117627},{"$f":"SUM(C214:C215)","v":10171162.262431115}]
["Check",{"$f":"ABS(B196-B216)","v":0},{"$f":"ABS(C196-C216)","v":0}]
[]
[]
[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.11999999999999995}]
["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":3661618.4144752021}]
[{"$f":"A$204","v":"Minimum Annual Quantity (MAQ) access charge"},{"$f":"B204","v":4801378},{"$f":"C246*C$22*10^3","v":4475311.3954696907}]
[null,{"$f":"SUM(B265:B266)","v":8857771.9894867782},{"$f":"SUM(C265:C266)","v":8136929.8099448923}]
[]
[{"$f":"A$208","v":"BULK FILTERED WATER"}]
[{"$f":"A$221","v":"Usage"},{"$f":"B210","v":817564.84107594937},{"$f":"C243*C$22*10^3","v":813692.98099448904}]
[{"$f":"A$204","v":"Minimum Annual Quantity (MAQ) access charge"},{"$f":"B209","v":1201462.4025548999},{"$f":"C247*C$22*10^3","v":1220539.4714917333}]
[null,{"$f":"SUM(B270:B271)","v":2019027.2436308493},{"$f":"SUM(C270:C271)","v":2034232.4524862224}]
[]
["Total Revenue",{"$f":"SUM(B267,B272)","v":10876799.233117627},{"$f":"SUM(C267,C272)","v":10171162.262431115}]