{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Notes","State Water data inputs","ACCC data inputs","Demand and Allocations data","Summary","Border","Gwydir","Namoi","Peel","Lachlan","Macquarie","Murray","Murrumbidgee","Lowbidgee","Fish River"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Notes","index":0,"n_rows":77,"n_cols":12,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["NSW State Water"]
[]
["Instructions"]
[]
["The purpose of this model is to illustrate the workings of the form of price control formulae which will apply in the ACCC's setting of Tariffs for the Regulatory Period 2014-15 to 2016-17."]
["The model calculates Tariffs for the Regulatory Period 2014-15 to 2016-17 based on actual inflation rates , actual water usage and actual average water allocations."]
[]
["Note the 2014-15 tariffs in this model (at the time of the Final Decision) are to apply for the year 2014-15."]
[]
["The State Water data input fields in this model (at the time of the Final Decision) are blank."]
[]
["The State Water data input fields are to be populated in 2015 and 2016 in order for the model to calculate applicable prices for 2015-16 and 2016-17"]
[]
["State Water data input fields are shaded",null,"      and located in tab \"State Water data inputs\"."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"G77","v":0},{"$f":"H77","v":0},{"$f":"I77","v":0},{"$f":"J77","v":0},{"$f":"K77","v":0}]

{"sheet":"State Water data inputs","index":1,"n_rows":88,"n_cols":14,"rows_kept":88,"cut":false,"hidden":false,"merged":[[41,5,41,7],[27,5,27,7],[56,1,56,4],[56,6,56,9],[71,9,71,12],[41,9,41,12],[28,1,28,3],[41,1,41,3],[28,5,28,7],[27,10,27,12],[28,10,28,12],[55,6,55,9],[70,9,70,12],[70,5,70,7],[71,5,71,7],[83,1,83,3],[84,1,84,3],[13,1,13,3],[27,1,27,3],[40,1,40,3],[14,1,14,3],[55,1,55,4],[70,1,70,3],[71,1,71,3],[13,5,13,7],[14,5,14,7],[13,10,13,12],[14,10,14,12],[40,9,40,12],[40,5,40,7],[83,5,83,7],[84,5,84,7],[55,11,55,13],[56,11,56,13],[83,10,83,12],[84,10,84,12]]}
[]
["Actual CPI"]
["CPI All Groups, Weighted Average of Eight Capital Cities, Index Numbers"]
["CPI Index March 2013",102.4]
["CPI Index March 2014",105.4]
["CPI Index March 2015"]
["CPI Index March 2016"]
[]
[]
[null,null,"2014-15","2015-16","2016-17"]
["Actual CPI",null,{"$f":"IF(B5=\"\",0,B5/B4-1)","v":2.9296875E-2},{"$f":"IF(B6=\"\",0,B6/B5-1)","v":0},{"$f":"IF(B7=\"\",0,B7/B6-1)","v":0}]
[]
[]
[null,"Forecast Data",null,null,null,"Estimated Data",null,null,null,null,"Actual Data"]
["General Security Entitlement (ML)","General Security Entitlement (ML)",null,null,null,"General Security Entitlement (ML)",null,null,null,null,"General Security Entitlement (ML)"]
[null,"2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17",null,null,"2014-15","2015-16","2016-17"]
["Border ",{"$f":"'ACCC data inputs'!C19","v":263238}]
["Gwydir ",{"$f":"'ACCC data inputs'!C20","v":509665}]
["Namoi ",{"$f":"'ACCC data inputs'!C21","v":256076}]
["Peel",null,"Not Required",null,null,"Not Required"]
["Lachlan",{"$f":"'ACCC data inputs'!C23","v":632837}]
["Macquarie",{"$f":"'ACCC data inputs'!C24","v":631716}]
["Murray ",{"$f":"'ACCC data inputs'!C25","v":2075822}]
["Murrumbidgee",{"$f":"'ACCC data inputs'!C26","v":2260113}]
["Lowbidgee",null,"Not Required",null,null,"Not Required"]
[]
[]
["High Security Entitlement (ML)","Forecast Data",null,null,null,"Estimated Data",null,null,null,null,"Actual Data"]
[null,"High Security Entitlement (ML)",null,null,null,"High Security Entitlement (ML)",null,null,null,null,"High Security Entitlement (ML)"]
[null,"2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17",null,null,"2014-15","2015-16","2016-17"]
["Border ",{"$f":"'ACCC data inputs'!D19","v":3122}]
["Gwydir ",{"$f":"'ACCC data inputs'!D20","v":21457.9}]
["Namoi ",{"$f":"'ACCC data inputs'!D21","v":8881}]
["Peel",null,"Not Required",null,null,"Not Required"]
["Lachlan",{"$f":"'ACCC data inputs'!D23","v":60745}]
["Macquarie",{"$f":"'ACCC data inputs'!D24","v":42606}]
["Murray ",{"$f":"'ACCC data inputs'!D25","v":261400.7}]
["Murrumbidgee",{"$f":"'ACCC data inputs'!D26","v":436928}]
[]
[]
[null,"Forecast Data (20 year average)",null,null,null,"Estimated Data",null,null,null,"Actual Data"]
["Water Volumes (ML)","Water Volumes (ML)",null,null,null,"Water Volumes (ML)",null,null,null,"Water Volumes (ML)"]
[null,"2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17",null,"2013-14","2014-15","2015-16","2016-17"]
["Border ",{"$f":"'Demand and Allocations data'!C$35","v":140676.93950000001},{"$f":"'Demand and Allocations data'!C$36","v":137272.5895},{"$f":"'Demand and Allocations data'!C$37","v":134078.38949999999}]
["Gwydir ",{"$f":"'Demand and Allocations data'!D$35","v":245876.74050000001},{"$f":"'Demand and Allocations data'!D$36","v":240933.61299999998},{"$f":"'Demand and Allocations data'!D$37","v":238674.57500000001}]
["Namoi ",{"$f":"'Demand and Allocations data'!E$35","v":158960.9705},{"$f":"'Demand and Allocations data'!E$36","v":152848.5105},{"$f":"'Demand and Allocations data'!E$37","v":150866.71549999999}]
["Peel",{"$f":"'Demand and Allocations data'!F$35","v":11163.91},{"$f":"'Demand and Allocations data'!F$36","v":10664.900000000001},{"$f":"'Demand and Allocations data'!F$37","v":10069.09},null,"Not Required"]
["Lachlan",{"$f":"'Demand and Allocations data'!G$35","v":227697.17900000006},{"$f":"'Demand and Allocations data'!G$36","v":213448.42650000006},{"$f":"'Demand and Allocations data'!G$37","v":193955.30800000002}]
["Macquarie",{"$f":"'Demand and Allocations data'!H$35","v":279670.66850000003},{"$f":"'Demand and Allocations data'!H$36","v":253939.84950000007},{"$f":"'Demand and Allocations data'!H$37","v":245588.85600000006}]
["Murray ",{"$f":"'Demand and Allocations data'!I$35","v":1459688.9339000001},{"$f":"'Demand and Allocations data'!I$36","v":1368381.7838999999},{"$f":"'Demand and Allocations data'!I$37","v":1261589.2338999999}]
["Murrumbidgee",{"$f":"'Demand and Allocations data'!J$35","v":1759739.925},{"$f":"'Demand and Allocations data'!J$36","v":1655354.4750000001},{"$f":"'Demand and Allocations data'!J$37","v":1527092.425}]
[]
[]
[]
[]
[null,"Actual Data",null,null,null,null,"Actual Data",null,null,null,null,"(20 year average)"]
[" Water Allocation Rates","General Security - Water Allocation (%)",null,null,null,null,"High Security - Water Allocation (%)",null,null,null,null,"Average Water Allocation (AWA)"]
[null,"2013-14","2014-15","2015-16","2016-17",null,"2013-14","2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17"]
["Border ",null,null,null,null,null,null,null,null,null,null,{"$f":"'Demand and Allocations data'!M$41","v":2.3184996774455522},{"$f":"'Demand and Allocations data'!M$42","v":2.2205942583240903},{"$f":"'Demand and Allocations data'!M$43","v":2.1037208763070332}]
["Gwydir ",null,null,null,null,null,null,null,null,null,null,{"$f":"'Demand and Allocations data'!O$41","v":2.2466505886379928},{"$f":"'Demand and Allocations data'!O$42","v":2.1343180592060933},{"$f":"'Demand and Allocations data'!O$43","v":2.0219855297741938}]
["Namoi ",null,null,null,null,null,null,null,null,null,null,{"$f":"'Demand and Allocations data'!Q$41","v":1.7205369620356692},{"$f":"'Demand and Allocations data'!Q$42","v":1.673378083325481},{"$f":"'Demand and Allocations data'!Q$43","v":1.58530555262414}]
["Peel",null,null,null,null,null,null,null,null,null,null,{"$f":"'Demand and Allocations data'!S$41","v":1.467351430667645},{"$f":"'Demand and Allocations data'!S$42","v":1.5043547110055424},{"$f":"'Demand and Allocations data'!S$43","v":1.4839241549876339}]
["Lachlan",null,null,null,null,null,null,null,null,null,null,{"$f":"'Demand and Allocations data'!U$41","v":1.64506480558325},{"$f":"'Demand and Allocations data'!U$42","v":1.7553793884484714},{"$f":"'Demand and Allocations data'!U$43","v":1.8057285180572851}]
["Macquarie",null,null,null,null,null,null,null,null,null,null,{"$f":"'Demand and Allocations data'!W$41","v":1.9607843137254897},{"$f":"'Demand and Allocations data'!W$42","v":2.0652173913043472},{"$f":"'Demand and Allocations data'!W$43","v":2.1428571428571428}]
["Murray ",null,null,null,null,null,null,null,null,null,null,{"$f":"'Demand and Allocations data'!Y$41","v":1.411111111111111},{"$f":"'Demand and Allocations data'!Y$42","v":1.4795081967213117},{"$f":"'Demand and Allocations data'!Y$43","v":1.5155555555555555}]
["Murrumbidgee",null,null,null,null,null,null,null,null,null,null,{"$f":"'Demand and Allocations data'!AA$41","v":1.4125433526011555},{"$f":"'Demand and Allocations data'!AA$42","v":1.4675316455696201},{"$f":"'Demand and Allocations data'!AA$43","v":1.5076975945017179}]
[]
[]
[]
["Fish River"]
[null,"Forecast Data (20 year average)",null,null,null,"Estimated Data",null,null,null,"Actual Data"]
["Water Volumes (ML)","Water Volumes (ML)",null,null,null,"Water Volumes (ML)",null,null,null,"Water Volumes (ML)"]
[null,"2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17",null,"2013-14","2014-15","2015-16","2016-17"]
["BULK RAW WATER"]
["   - Delta Electricity",{"$f":"'Demand and Allocations data'!$AE$35","v":6189.8481999999995},{"$f":"'Demand and Allocations data'!$AE$36","v":5929.7981999999993},{"$f":"'Demand and Allocations data'!AE$37","v":5615.7482}]
["   - Sydney Catchment Authority",{"$f":"'Demand and Allocations data'!$AF$35","v":2411.6287499999999},{"$f":"'Demand and Allocations data'!$AF$36","v":2224.8287499999997},{"$f":"'Demand and Allocations data'!AF$37","v":2060.17875}]
["   - Oberon Council",{"$f":"'Demand and Allocations data'!$AG$35","v":717.08692000000008},{"$f":"'Demand and Allocations data'!$AG$36","v":681.88692000000015},{"$f":"'Demand and Allocations data'!AG$37","v":652.08692000000008}]
["   - Individual Minor Customers",{"$f":"'Demand and Allocations data'!$AI$35","v":52.092876230661034},{"$f":"'Demand and Allocations data'!$AI$36","v":46.229233473980308},{"$f":"'Demand and Allocations data'!AI$37","v":44.088094233473974}]
["BULK FILTERED WATER"]
["   - Lithgow Council",{"$f":"'Demand and Allocations data'!$AH$35","v":985.50049999999987},{"$f":"'Demand and Allocations data'!$AH$36","v":881.1004999999999},{"$f":"'Demand and Allocations data'!AH$37","v":807.10049999999978}]
["   - Individual Minor Customers",{"$f":"'Demand and Allocations data'!$AJ$35","v":131.80557665260199},{"$f":"'Demand and Allocations data'!$AJ$36","v":116.74868495077358},{"$f":"'Demand and Allocations data'!AJ$37","v":111.25058368495078}]
[]
[]
[null,"Forecast Data",null,null,null,"Estimated Data",null,null,null,null,"Actual Data"]
[null,"Number of Minor Customers",null,null,null,"Number of Minor Customers",null,null,null,null,"Number of Minor Customers"]
["Number of Minor Customers","2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17",null,null,"2014-15","2015-16","2016-17"]
["BULK RAW WATER",{"$f":"'ACCC data inputs'!G29","v":74}]
["BULK FILTERED WATER",{"$f":"'ACCC data inputs'!G30","v":208}]

{"sheet":"ACCC data inputs","index":2,"n_rows":57,"n_cols":9,"rows_kept":57,"cut":false,"hidden":false,"merged":[[2,1,2,3],[3,1,3,3]]}
[]
[]
[null,"Benchmark Revenue (Rev BBM)"]
[null,"($ Real 2013-14)",null,null,null,"MDBA / BCR costs"]
[null,"2014-15","2015-16","2016-17",null,"($ Real 2013-14)","2014-15","2015-16","2016-17"]
["Border ",1492913.5864542236,1500530.6126571996,1508186.5018517796,null,"Border ",700000,700000,700000]
["Gwydir ",4836836.0816605203,4904575.5923878355,4973263.7896606736,null,"Gwydir ",0,0,0]
["Namoi ",5131008.4619597849,5165594.1951872259,5200413.0547000263,null,"Namoi ",0,0,0]
["Peel",null,null,null,null,"Peel"]
["Lachlan",6790422.2574992292,6927298.3260440426,7066933.4362846185,null,"Lachlan",0,0,0]
["Macquarie",6521658.323966573,6644104.1001923531,6768848.8266805876,null,"Macquarie",0,0,0]
["Murray ",6057234.6539847795,5950350.1234723832,5845351.6521132896,null,"Murray ",10200000,10400000,9300000]
["Murrumbidgee",9986019.5173155498,9955319.520979818,9924713.9055706784,null,"Murrumbidgee",2300000,2300000,2100000]
["Lowbidgee",null,null,null,null,"Lowbidgee"]
["Fish River",9444699.6594166141,9548404.01550713,9653247.0624888279,null,"Fish River"]
[]
[null,"Water sharing plan ratio (WSP)","General Security Entitlement (ML)","High Security Entitlement (ML)",null,"Fish River"]
[null,"2014-17","2014-15","2014-15",null,"Minimum Annual Quantity (MAQ)  ","2014-15","2015-16","2016-17"]
["Border",1.28,263238,3122,null,"BULK RAW WATER"]
["Gwydir",1.81,509665,21457.9,null,"   - Delta Electricity",8184,8184,8184]
["Namoi",1.25,256076,8881,null,"   - Sydney Catchment Authority",3650,3650,3650]
["Peel",null,null,null,null,"   - Oberon Council",1064,1064,1064]
["Lachlan",2.4500000000000002,632837,60745,null,"   - Individual Minor Customers",200,200,200]
["Macquarie",1.88,631716,42606,null,"BULK FILTERED WATER"]
["Murray",1.25,2075822,261400.7,null,"   - Lithgow Council",1778,1778,1778]
["Murrumbidgee",1.63,2260113,436928,null,"   - Individual Minor Customers",200,200,200]
["Lowbidgee"]
[null,null,null,null,null,"Number of Minor Customers","2014-15"]
["Tariff Structure 2014-17","2014-15","2015-16","2016-17",null,"BULK RAW WATER",74]
["Target Variable / Fixed ratio (%)",0.6,0.6,0.6,null,"BULK FILTERED WATER",208]
[]
["Fish River"]
["Raw Water /Filtered Water (%)",0.8,0.8,0.8]
["Target Variable / Fixed ratio (%)"]
["Raw Water",0.45,0.45,0.45]
["Filtered Water",0.4,0.4,0.4]
[]
["WACC","2014-15","2015-16","2016-17"]
["Real Pre Tax WACC",4.2572208678693269E-2,4.2572208678693269E-2,4.2572208678693269E-2]
[]
[]
[]
["Peel Valley"]
[]
["Base year prices per tariff component for 2013-14 ($ Nominal)"]
[null,"High Security Entitlement ($/ML)","General Security Entitlement ($/ML)","Usage ($/ML delivered)"]
[null,"2013-14","2013-14","2013-14"]
["Peel Valley Opening prices",25.076315111646519,2.7574987240675211,41.422210075252544]
[]
[]
["Peel Valley Annual real price increase cap",0.1,0.1,0.1]
[]
[]
["Lowbidgee"]
[null,"2014-15","2015-16","2016-17"]
["Tariffs ($ Real 2013-14)"]
["General Security Entitlement ($/ML)",0.71055047538099136,0.75043478278794451,0.79255785863211448]

{"sheet":"Demand and Allocations data","index":3,"n_rows":43,"n_cols":36,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,22,3,23],[4,22,4,23],[3,20,3,21],[4,20,4,21],[4,34,4,35],[3,30,3,35],[3,26,3,27],[4,26,4,27],[3,24,3,25],[4,24,4,25],[3,18,3,19],[4,18,4,19],[3,12,3,13],[4,12,4,13],[3,14,3,15],[4,14,4,15],[3,16,3,17],[4,16,4,17]]}
[]
[]
[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]
[21,2014,{"$f":"'State Water data inputs'!$J$44","v":0},{"$f":"'State Water data inputs'!$J$45","v":0},{"$f":"'State Water data inputs'!$J$46","v":0},{"$f":"'State Water data inputs'!$J$47","v":0},{"$f":"'State Water data inputs'!$J$48","v":0},{"$f":"'State Water data inputs'!$J$49","v":0},{"$f":"'State Water data inputs'!$J$50","v":0},{"$f":"'State Water data inputs'!$J$51","v":0},null,2014,{"$f":"'State Water data inputs'!$B$59","v":0},{"$f":"'State Water data inputs'!$G$59","v":0},{"$f":"'State Water data inputs'!$B$60","v":0},{"$f":"'State Water data inputs'!$G$60","v":0},{"$f":"'State Water data inputs'!$B$61","v":0},{"$f":"'State Water data inputs'!$G$61","v":0},{"$f":"'State Water data inputs'!$B$62","v":0},{"$f":"'State Water data inputs'!$G$62","v":0},{"$f":"'State Water data inputs'!$B$63","v":0},{"$f":"'State Water data inputs'!$G$63","v":0},{"$f":"'State Water data inputs'!$B$64","v":0},{"$f":"'State Water data inputs'!$G$64","v":0},{"$f":"'State Water data inputs'!$B$65","v":0},{"$f":"'State Water data inputs'!$G$65","v":0},{"$f":"'State Water data inputs'!$B$66","v":0},{"$f":"'State Water data inputs'!$G$66","v":0},null,2014,{"$f":"'State Water data inputs'!$J$75","v":0},{"$f":"'State Water data inputs'!$J$76","v":0},{"$f":"'State Water data inputs'!$J$77","v":0},{"$f":"'State Water data inputs'!$J$80","v":0},{"$f":"'State Water data inputs'!$J$78","v":0},{"$f":"'State Water data inputs'!$J$81","v":0}]
[22,2015,{"$f":"'State Water data inputs'!$K$44","v":0},{"$f":"'State Water data inputs'!$K$45","v":0},{"$f":"'State Water data inputs'!$K$46","v":0},{"$f":"'State Water data inputs'!$K$47","v":0},{"$f":"'State Water data inputs'!$K$48","v":0},{"$f":"'State Water data inputs'!$K$49","v":0},{"$f":"'State Water data inputs'!$K$50","v":0},{"$f":"'State Water data inputs'!$K$51","v":0},null,2015,{"$f":"'State Water data inputs'!$C$59","v":0},{"$f":"'State Water data inputs'!$H$59","v":0},{"$f":"'State Water data inputs'!$C$60","v":0},{"$f":"'State Water data inputs'!$H$60","v":0},{"$f":"'State Water data inputs'!$C$61","v":0},{"$f":"'State Water data inputs'!$H$61","v":0},{"$f":"'State Water data inputs'!$C$62","v":0},{"$f":"'State Water data inputs'!$H$62","v":0},{"$f":"'State Water data inputs'!$C$63","v":0},{"$f":"'State Water data inputs'!$H$63","v":0},{"$f":"'State Water data inputs'!$C$64","v":0},{"$f":"'State Water data inputs'!$H$64","v":0},{"$f":"'State Water data inputs'!$C$65","v":0},{"$f":"'State Water data inputs'!$H$65","v":0},{"$f":"'State Water data inputs'!$C$66","v":0},{"$f":"'State Water data inputs'!$H$66","v":0},null,2015,{"$f":"'State Water data inputs'!$K$75","v":0},{"$f":"'State Water data inputs'!$K$76","v":0},{"$f":"'State Water data inputs'!$K$77","v":0},{"$f":"'State Water data inputs'!$K$80","v":0},{"$f":"'State Water data inputs'!$K$78","v":0},{"$f":"'State Water data inputs'!$K$81","v":0}]
[23,2016,{"$f":"'State Water data inputs'!$L$44","v":0},{"$f":"'State Water data inputs'!$L$45","v":0},{"$f":"'State Water data inputs'!$L$46","v":0},{"$f":"'State Water data inputs'!$L$47","v":0},{"$f":"'State Water data inputs'!$L$48","v":0},{"$f":"'State Water data inputs'!$L$49","v":0},{"$f":"'State Water data inputs'!$L$50","v":0},{"$f":"'State Water data inputs'!$L$51","v":0},null,2016,{"$f":"'State Water data inputs'!$D$59","v":0},{"$f":"'State Water data inputs'!$I$59","v":0},{"$f":"'State Water data inputs'!$D$60","v":0},{"$f":"'State Water data inputs'!$I$60","v":0},{"$f":"'State Water data inputs'!$D$61","v":0},{"$f":"'State Water data inputs'!$I$61","v":0},{"$f":"'State Water data inputs'!$D$62","v":0},{"$f":"'State Water data inputs'!$I$62","v":0},{"$f":"'State Water data inputs'!$D$63","v":0},{"$f":"'State Water data inputs'!$I$63","v":0},{"$f":"'State Water data inputs'!$D$64","v":0},{"$f":"'State Water data inputs'!$I$64","v":0},{"$f":"'State Water data inputs'!$D$65","v":0},{"$f":"'State Water data inputs'!$I$65","v":0},{"$f":"'State Water data inputs'!$D$66","v":0},{"$f":"'State Water data inputs'!$I$66","v":0},null,2016,{"$f":"'State Water data inputs'!$L$75","v":0},{"$f":"'State Water data inputs'!$L$76","v":0},{"$f":"'State Water data inputs'!$L$77","v":0},{"$f":"'State Water data inputs'!$L$80","v":0},{"$f":"'State Water data inputs'!$L$78","v":0},{"$f":"'State Water data inputs'!$L$81","v":0}]
[24,2017,{"$f":"'State Water data inputs'!$M$44","v":0},{"$f":"'State Water data inputs'!$M$45","v":0},{"$f":"'State Water data inputs'!$M$46","v":0},{"$f":"'State Water data inputs'!$M$47","v":0},{"$f":"'State Water data inputs'!$M$48","v":0},{"$f":"'State Water data inputs'!$M$49","v":0},{"$f":"'State Water data inputs'!$M$50","v":0},{"$f":"'State Water data inputs'!$M$51","v":0},null,2017,{"$f":"'State Water data inputs'!$E$59","v":0},{"$f":"'State Water data inputs'!$J$59","v":0},{"$f":"'State Water data inputs'!$E$60","v":0},{"$f":"'State Water data inputs'!$J$60","v":0},{"$f":"'State Water data inputs'!$E$61","v":0},{"$f":"'State Water data inputs'!$J$61","v":0},{"$f":"'State Water data inputs'!$E$62","v":0},{"$f":"'State Water data inputs'!$J$62","v":0},{"$f":"'State Water data inputs'!$E$63","v":0},{"$f":"'State Water data inputs'!$J$63","v":0},{"$f":"'State Water data inputs'!$E$64","v":0},{"$f":"'State Water data inputs'!$J$64","v":0},{"$f":"'State Water data inputs'!$E$65","v":0},{"$f":"'State Water data inputs'!$J$65","v":0},{"$f":"'State Water data inputs'!$E$66","v":0},{"$f":"'State Water data inputs'!$J$66","v":0},null,2017,{"$f":"'State Water data inputs'!$M$75","v":0},{"$f":"'State Water data inputs'!$M$76","v":0},{"$f":"'State Water data inputs'!$M$77","v":0},{"$f":"'State Water data inputs'!$M$80","v":0},{"$f":"'State Water data inputs'!$M$78","v":0},{"$f":"'State Water data inputs'!$M$81","v":0}]
[]
[]
[]
[null,"Forecasts (20 year moving average)",null,null,null,null,null,null,null,null,null,"Allocations (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,{"$f":"AVERAGE(U7:U26)","v":0.50150000000000006},0.82499999999999996,0.51000000000000012,1,{"$f":"AVERAGE(Y7:Y26)","v":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,2016,137272.5895,240933.61299999998,152848.5105,10664.900000000001,{"$f":"AVERAGE(G8:G27)","v":213448.42650000006},253939.84950000007,{"$f":"AVERAGE(I8:I27)","v":1368381.7838999999},1655354.4750000001,null,2016,{"$f":"AVERAGE(M8:M27)","v":0.42781340915335725},0.95,{"$f":"AVERAGE(O8:O27)","v":0.44510704292750702},0.95,0.5677139012793081,0.95,0.63149999999999995,0.95,0.4415,0.77500000000000013,0.46000000000000008,0.95,0.61,0.90250000000000008,0.63200000000000001,0.92747999999999986,null,2016,{"$f":"AVERAGE(AE8:AE27)","v":5929.7981999999993},2224.8287499999997,681.88692000000015,881.1004999999999,{"$f":"AVERAGE(AI8:AI27)","v":46.229233473980308},{"$f":"AVERAGE(AJ8:AJ27)","v":116.74868495077358}]
[null,2017,134078.38949999999,238674.57500000001,150866.71549999999,10069.09,{"$f":"AVERAGE(G9:G28)","v":193955.30800000002},245588.85600000006,{"$f":"AVERAGE(I9:I28)","v":1261589.2338999999},1527092.425,null,2017,0.42781340915335725,0.9,{"$f":"AVERAGE(O9:O28)","v":0.44510704292750702},0.9,0.5677139012793081,0.9,0.60650000000000004,0.9,0.40150000000000008,0.72500000000000009,0.42000000000000004,0.9,0.5625,0.85250000000000004,0.58200000000000007,0.87747999999999993,null,2017,{"$f":"AVERAGE(AE9:AE28)","v":5615.7482},2060.17875,652.08692000000008,807.10049999999978,{"$f":"AVERAGE(AI9:AI28)","v":44.088094233473974},{"$f":"AVERAGE(AJ9:AJ28)","v":111.25058368495078}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"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}]
[null,null,null,null,null,null,null,null,null,null,null,2016,{"$f":"N36/M36","v":2.2205942583240903},null,2.1343180592060933,null,{"$f":"R36/Q36","v":1.673378083325481},null,{"$f":"T36/S36","v":1.5043547110055424},null,{"$f":"V36/U36","v":1.7553793884484714},null,{"$f":"X36/W36","v":2.0652173913043472},null,{"$f":"Z36/Y36","v":1.4795081967213117},null,{"$f":"AB36/AA36","v":1.4675316455696201}]
[null,null,null,null,null,null,null,null,null,null,null,2017,2.1037208763070332,null,2.0219855297741938,null,{"$f":"R37/Q37","v":1.58530555262414},null,{"$f":"T37/S37","v":1.4839241549876339},null,1.8057285180572851,null,{"$f":"X37/W37","v":2.1428571428571428},null,{"$f":"Z37/Y37","v":1.5155555555555555},null,1.5076975945017179]

{"sheet":"Summary","index":4,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[35,2,35,4],[35,6,35,8],[35,10,35,12],[43,2,43,4],[43,6,43,8],[43,10,43,12],[24,2,24,4],[24,6,24,8],[24,10,24,12],[4,2,4,4],[4,6,4,8],[4,10,4,12],[15,2,15,4],[15,6,15,8],[15,10,15,12]]}
[null,null,"Check",{"$f":"IF(E1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(Border!E1,Gwydir!E1,Namoi!E1,Peel!E1,Lachlan!E1,Macquarie!E1,Murray!E1,Murrumbidgee!E1,Lowbidgee!E1,'Fish River'!E1)","v":3.2596290111541748E-9}]
[]
["Tariffs ($ Nominal)"]
[null,null,"2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17"]
["Total Tariffs",null,"High Security Entitlement ($/ML)",null,null,null,"General Security Entitlement ($/ML)",null,null,null,"Usage ($/ML delivered)"]
["Border ",null,{"$f":"SUM(C26,C45)","v":9.8325855337143846},{"$f":"SUM(D26,D45)","v":0},0,null,{"$f":"SUM(G26,G45)","v":3.3132234276080723},0,0,null,{"$f":"SUM(K26,K45)","v":9.6269897953631887},13.469255683041041,17.636747476283812]
["Gwydir ",null,{"$f":"SUM(C27,C46)","v":13.566205303673041},0,0,null,{"$f":"SUM(G27,G46)","v":3.3361400698703698},0,0,null,{"$f":"SUM(K27,K46)","v":12.148868380839181},13.099571421284352,13.964246923485863]
["Namoi ",null,{"$f":"SUM(C28,C47)","v":16.510744920256986},0,0,null,{"$f":"SUM(G28,G47)","v":7.6770195745040644},0,0,null,{"$f":"SUM(K28,K47)","v":19.934444130084483},21.753962281553218,23.120535672708122]
[{"$f":"A29","v":"Peel Valley (10% price cap)"},null,{"$f":"SUM(C29,C48)","v":28.392070059026345},31.231277064928982,34.354404771421883,null,{"$f":"SUM(G29,G48)","v":3.1221133014491058},3.4343246315940168,3.7777570947534187,null,{"$f":"SUM(K29,K48)","v":46.899326524656054},51.589259177121662,56.748185094833829]
["Lachlan",null,{"$f":"SUM(C30,C49)","v":12.838614189054654},0,0,null,{"$f":"SUM(G30,G49)","v":3.1854372372595718},0,0,null,{"$f":"SUM(K30,K49)","v":18.417515158343878},20.879420338318194,24.400702110128446]
["Macquarie",null,{"$f":"SUM(C31,C50)","v":12.548565960523744},0,0,null,{"$f":"SUM(G31,G50)","v":3.4041322552484634},0,0,null,{"$f":"SUM(K31,K50)","v":14.401344056593185},16.833587227827227,18.460700977634549]
["Murray ",null,{"$f":"SUM(C32,C51)","v":4.6538732086229695},0,0,null,{"$f":"SUM(G32,G51)","v":2.6384163072508171},0,0,null,{"$f":"SUM(K32,K51)","v":6.8782548542501782},12.295066632430608,18.40474373623131]
["Murrumbidgee",null,{"$f":"SUM(C33,C52)","v":3.5659038938086267},0,0,null,{"$f":"SUM(G33,G52)","v":1.5487461651832213},0,0,null,{"$f":"SUM(K33,K52)","v":4.3117603853973714},5.6254216158605992,7.1944006941672525]
["Lowbidgee",null,null,null,null,null,0.73136738383941879,0.77242017681493502,0.81577732714672724]
[]
["Fish River",null,"Access  ($/KL)",null,null,null,"Usage < MAQ ($/KL)",null,null,null,"Usage > 200kl ($/KL)"]
["Raw water - major customers",null,{"$f":"C37","v":0.33125394427935684},{"$f":"D37","v":0.34153338940974032},0.35161229445058112,null,{"$f":"G37","v":0.37215646952047915},0.40397227988609374,0.44135041336060254]
["Raw water - minor customers *",null,{"$f":"C38","v":66.250788855871363},68.306677881948062,70.322458890116224,null,{"$f":"G38","v":0.37215646952047915},0.40397227988609374,0.44135041336060254,null,0.70341041379983604,0.74550566929583406,0.79296270781118361]
["Filtered water - major customers",null,{"$f":"C39","v":0.64111232214230052},0.67569756467023645,0.69563790374633294,null,{"$f":"G39","v":0.64429979922679725},0.72359636651075365,0.8136024290594982]
["Filtered water - minor customers *",null,{"$f":"C40","v":128.22246442846011},135.1395129340473,139.1275807492666,null,{"$f":"G40","v":0.64429979922679725},0.72359636651075365,0.8136024290594982,null,1.2854121213690979,1.3992939311809902,1.509240332805831]
["* Note : Access Fee for minor customers is an Annual Charge"]
[]
[]
[null,null,"2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17"]
["State Water Costs Tariffs",null,"High Security Entitlement ($/ML)",null,null,null,"General Security Entitlement ($/ML)",null,null,null,"Usage ($/ML delivered)"]
["Border ",null,{"$f":"Border!C$67","v":6.6939256630675636},{"$f":"Border!D$67","v":0},{"$f":"Border!E$67","v":0},null,{"$f":"Border!C$68","v":2.2556092955912637},{"$f":"Border!D$68","v":0},{"$f":"Border!E$68","v":0},null,{"$f":"Border!C$69","v":6.5539581454245717},{"$f":"Border!D$69","v":7.0367002574800814},{"$f":"Border!E$69","v":7.5463065810660988}]
["Gwydir ",null,{"$f":"Gwydir!C$67","v":13.566205303673041},{"$f":"Gwydir!D$67","v":0},{"$f":"Gwydir!E$67","v":0},null,{"$f":"Gwydir!C$68","v":3.3361400698703698},{"$f":"Gwydir!D$68","v":0},{"$f":"Gwydir!E$68","v":0},null,{"$f":"Gwydir!C$69","v":12.148868380839181},{"$f":"Gwydir!D$69","v":13.099571421284352},{"$f":"Gwydir!E$69","v":13.964246923485863}]
["Namoi ",null,{"$f":"Namoi!C$67","v":16.510744920256986},{"$f":"Namoi!D$67","v":0},{"$f":"Namoi!E$67","v":0},null,{"$f":"Namoi!C$68","v":7.6770195745040644},{"$f":"Namoi!D$68","v":0},{"$f":"Namoi!E$68","v":0},null,{"$f":"Namoi!C$69","v":19.934444130084483},{"$f":"Namoi!D$69","v":21.753962281553218},{"$f":"Namoi!E$69","v":23.120535672708122}]
[{"$f":"\"Peel Valley (\" &'ACCC data inputs'!B51*100& \"% price cap)\"","v":"Peel Valley (10% price cap)"},null,{"$f":"Peel!D11","v":28.392070059026345},{"$f":"Peel!E11","v":31.231277064928982},{"$f":"Peel!F11","v":34.354404771421883},null,{"$f":"Peel!D12","v":3.1221133014491058},{"$f":"Peel!E12","v":3.4343246315940168},{"$f":"Peel!F12","v":3.7777570947534187},null,{"$f":"Peel!D13","v":46.899326524656054},{"$f":"Peel!E13","v":51.589259177121662},{"$f":"Peel!F13","v":56.748185094833829}]
["Lachlan",null,{"$f":"Lachlan!C$67","v":12.838614189054654},{"$f":"Lachlan!D$67","v":0},{"$f":"Lachlan!E$67","v":0},null,{"$f":"Lachlan!C$68","v":3.1854372372595718},{"$f":"Lachlan!D$68","v":0},{"$f":"Lachlan!E$68","v":0},null,{"$f":"Lachlan!C$69","v":18.417515158343878},{"$f":"Lachlan!D$69","v":20.879420338318194},{"$f":"Lachlan!E$69","v":24.400702110128446}]
["Macquarie",null,{"$f":"Macquarie!C$67","v":12.548565960523744},{"$f":"Macquarie!D$67","v":0},{"$f":"Macquarie!E$67","v":0},null,{"$f":"Macquarie!C$68","v":3.4041322552484634},{"$f":"Macquarie!D$68","v":0},{"$f":"Macquarie!E$68","v":0},null,{"$f":"Macquarie!C$69","v":14.401344056593185},{"$f":"Macquarie!D$69","v":16.833587227827227},{"$f":"Macquarie!E$69","v":18.460700977634549}]
["Murray ",null,{"$f":"Murray!C$67","v":1.7339727619428122},{"$f":"Murray!D$67","v":0},{"$f":"Murray!E$67","v":0},null,{"$f":"Murray!C$68","v":0.98303967606206677},{"$f":"Murray!D$68","v":0},{"$f":"Murray!E$68","v":0},null,{"$f":"Murray!C$69","v":2.5627484962143434},{"$f":"Murray!D$69","v":2.801894106362504},{"$f":"Murray!E$69","v":3.1170530230087201}]
["Murrumbidgee",null,{"$f":"Murrumbidgee!C$67","v":2.8983500986839501},{"$f":"Murrumbidgee!D$67","v":0},{"$f":"Murrumbidgee!E$67","v":0},null,{"$f":"Murrumbidgee!C$68","v":1.2588136793279718},{"$f":"Murrumbidgee!D$68","v":0},{"$f":"Murrumbidgee!E$68","v":0},null,{"$f":"Murrumbidgee!C$69","v":3.5045787858209456},{"$f":"Murrumbidgee!D$69","v":3.872727405715874},{"$f":"Murrumbidgee!E$69","v":4.3643425845782993}]
["Lowbidgee",null,null,null,null,null,{"$f":"Lowbidgee!C14","v":0.73136738383941879},{"$f":"Lowbidgee!D14","v":0.77242017681493502},{"$f":"Lowbidgee!E14","v":0.81577732714672724}]
[]
["Fish River",null,"Access  ($/KL)",null,null,null,"Usage < MAQ ($/KL)",null,null,null,"Usage > 200kl ($/KL)"]
["Raw water - major customers",null,{"$f":"'Fish River'!C131","v":0.33125394427935684},{"$f":"'Fish River'!D131","v":0.34153338940974032},{"$f":"'Fish River'!E131","v":0.35161229445058112},null,{"$f":"'Fish River'!C153","v":0.37215646952047915},{"$f":"'Fish River'!D153","v":0.40397227988609374},{"$f":"'Fish River'!E153","v":0.44135041336060254}]
["Raw water - minor customers *",null,{"$f":"'Fish River'!C144","v":66.250788855871363},{"$f":"'Fish River'!D144","v":68.306677881948062},{"$f":"'Fish River'!E144","v":70.322458890116224},null,{"$f":"'Fish River'!C166","v":0.37215646952047915},{"$f":"'Fish River'!D166","v":0.40397227988609374},{"$f":"'Fish River'!E166","v":0.44135041336060254},null,{"$f":"'Fish River'!C180","v":0.70341041379983604},{"$f":"'Fish River'!D180","v":0.74550566929583406},{"$f":"'Fish River'!E180","v":0.79296270781118361}]
["Filtered water - major customers",null,{"$f":"'Fish River'!C195","v":0.64111232214230052},{"$f":"'Fish River'!D195","v":0.67569756467023645},{"$f":"'Fish River'!E195","v":0.69563790374633294},null,{"$f":"'Fish River'!C208","v":0.64429979922679725},{"$f":"'Fish River'!D208","v":0.72359636651075365},{"$f":"'Fish River'!E208","v":0.8136024290594982}]
["Filtered water - minor customers *",null,{"$f":"'Fish River'!C199","v":128.22246442846011},{"$f":"'Fish River'!D199","v":135.1395129340473},{"$f":"'Fish River'!E199","v":139.1275807492666},null,{"$f":"'Fish River'!C212","v":0.64429979922679725},{"$f":"'Fish River'!D212","v":0.72359636651075365},{"$f":"'Fish River'!E212","v":0.8136024290594982},null,{"$f":"'Fish River'!C225","v":1.2854121213690979},{"$f":"'Fish River'!D225","v":1.3992939311809902},{"$f":"'Fish River'!E225","v":1.509240332805831}]
[]
[]
[null,null,"2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17",null,"2014-15","2015-16","2016-17"]
["MDBA / BCR Tariffs",null,"High Security Entitlement ($/ML)",null,null,null,"General Security Entitlement ($/ML)",null,null,null,"Usage ($/ML delivered)"]
["Border ",null,{"$f":"Border!H$67","v":3.1386598706468205},{"$f":"Border!I$67","v":0},{"$f":"Border!J$67","v":0},null,{"$f":"Border!H$68","v":1.0576141320168087},{"$f":"Border!I$68","v":0},{"$f":"Border!J$68","v":0},null,{"$f":"Border!H$69","v":3.073031649938617},{"$f":"Border!I$69","v":6.4325554255609587},{"$f":"Border!J$69","v":10.090440895217714}]
["Gwydir ",null,{"$f":"Gwydir!H$67","v":0},{"$f":"Gwydir!I$67","v":0},{"$f":"Gwydir!J$67","v":0},null,{"$f":"Gwydir!H$68","v":0},{"$f":"Gwydir!I$68","v":0},{"$f":"Gwydir!J$68","v":0},null,{"$f":"Gwydir!H$69","v":0},{"$f":"Gwydir!I$69","v":0},{"$f":"Gwydir!J$69","v":0}]
["Namoi ",null,{"$f":"Namoi!H$67","v":0},{"$f":"Namoi!I$67","v":0},{"$f":"Namoi!J$67","v":0},null,{"$f":"Namoi!H$68","v":0},{"$f":"Namoi!I$68","v":0},{"$f":"Namoi!J$68","v":0},null,{"$f":"Namoi!H$69","v":0},{"$f":"Namoi!I$69","v":0},{"$f":"Namoi!J$69","v":0}]
["Peel",null,{"$f":"Peel!I11","v":0},{"$f":"Peel!J11","v":0},{"$f":"Peel!K11","v":0},null,{"$f":"Peel!I12","v":0},{"$f":"Peel!J12","v":0},{"$f":"Peel!K12","v":0},null,{"$f":"Peel!I13","v":0},{"$f":"Peel!J13","v":0},{"$f":"Peel!K13","v":0}]
["Lachlan",null,{"$f":"Lachlan!H$67","v":0},{"$f":"Lachlan!I$67","v":0},{"$f":"Lachlan!J$67","v":0},null,{"$f":"Lachlan!H$68","v":0},{"$f":"Lachlan!I$68","v":0},{"$f":"Lachlan!J$68","v":0},null,{"$f":"Lachlan!H$69","v":0},{"$f":"Lachlan!I$69","v":0},{"$f":"Lachlan!J$69","v":0}]
["Macquarie",null,{"$f":"Macquarie!H$67","v":0},{"$f":"Macquarie!I$67","v":0},{"$f":"Macquarie!J$67","v":0},null,{"$f":"Macquarie!H$68","v":0},{"$f":"Macquarie!I$68","v":0},{"$f":"Macquarie!J$68","v":0},null,{"$f":"Macquarie!H$69","v":0},{"$f":"Macquarie!I$69","v":0},{"$f":"Macquarie!J$69","v":0}]
["Murray ",null,{"$f":"Murray!H$67","v":2.919900446680157},{"$f":"Murray!I$67","v":0},{"$f":"Murray!J$67","v":0},null,{"$f":"Murray!H$68","v":1.6553766311887506},{"$f":"Murray!I$68","v":0},{"$f":"Murray!J$68","v":0},null,{"$f":"Murray!H$69","v":4.3155063580358348},{"$f":"Murray!I$69","v":9.4931725260681041},{"$f":"Murray!J$69","v":15.287690713222592}]
["Murrumbidgee",null,{"$f":"Murrumbidgee!H$67","v":0.6675537951246765},{"$f":"Murrumbidgee!I$67","v":0},{"$f":"Murrumbidgee!J$67","v":0},null,{"$f":"Murrumbidgee!H$68","v":0.28993248585524939},{"$f":"Murrumbidgee!I$68","v":0},{"$f":"Murrumbidgee!J$68","v":0},null,{"$f":"Murrumbidgee!H$69","v":0.80718159957642599},{"$f":"Murrumbidgee!I$69","v":1.7526942101447252},{"$f":"Murrumbidgee!J$69","v":2.8300581095889532}]
["Lowbidgee",null,{"$f":"Lowbidgee!H13","v":0},{"$f":"Lowbidgee!I13","v":0},{"$f":"Lowbidgee!J13","v":0},null,{"$f":"Lowbidgee!H14","v":0},{"$f":"Lowbidgee!I14","v":0},{"$f":"Lowbidgee!J14","v":0},null,{"$f":"Lowbidgee!H15","v":0},{"$f":"Lowbidgee!I15","v":0},{"$f":"Lowbidgee!J15","v":0}]

{"sheet":"Border","index":5,"n_rows":102,"n_cols":10,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[null,"Border","Check",{"$f":"IF(E1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(C76:E76,H76:J76)","v":0}]
[]
[null,"State Water Costs Tariffs","2014-15","2015-16"," 2016-17",null,"MDBA / BCR Tariffs","2014-15","2015-16"," 2016-17"]
[]
[]
[null,"Benchmark Revenue (Rev BBM)","Forecast 2014-15","Forecast 2015-16","Forecast 2016-17",null,"MDBA / BCR costs","Forecast 2014-15","Forecast 2015-16","Forecast 2016-17"]
[null,"Benchmark Revenue (Rev BBM)",{"$f":"'ACCC data inputs'!B$6*(1+C$31)","v":1536651.2891823747},{"$f":"'ACCC data inputs'!C$6*(1+C$31)*(1+D$31)","v":1544491.4704498909},{"$f":"'ACCC data inputs'!D$6*(1+C$31)*(1+D$31)*(1+E$31)","v":1552371.6532732185},null,"MDBA / BCR costs",{"$f":"'ACCC data inputs'!G$6*(1+H$31)","v":720507.8125},{"$f":"'ACCC data inputs'!H$6*(1+H$31)*(1+I$31)","v":720507.8125},{"$f":"'ACCC data inputs'!I$6*(1+H$31)*(1+I$31)*(1+J$31)","v":720507.8125}]
[]
[]
[]
[null,"Unders/Overs Adjustment",null,null,null,null,"Unders/Overs Adjustment"]
[null,"Calc. of UOM (t-1)","Estimated 2013-14","Estimated 2014-15","Estimated 2015-16",null,"Calc. of UOM (t-1)","Estimated 2013-14","Estimated 2014-15","Estimated 2015-16"]
[null,"Revenue Requirement",0,{"$f":"C47","v":1536651.2891823747},{"$f":"D47","v":1609910.109799346},null,"MDBA / BCR costs",0,{"$f":"H47","v":720507.8125},{"$f":"I47","v":1471689.2339483788}]
[null,"Estimated Tariff Revenue",0,{"$f":"C89","v":0},{"$f":"D89","v":0},null,"Estimated MDBA / BCR revenue",0,{"$f":"H89","v":0},{"$f":"I89","v":0}]
[null,"Difference",{"$f":"C14-C13","v":0},{"$f":"D14-D13","v":-1536651.2891823747},{"$f":"E14-E13","v":-1609910.109799346},null,"Difference",{"$f":"H14-H13","v":0},{"$f":"I14-I13","v":-720507.8125},{"$f":"J14-J13","v":-1471689.2339483788}]
[]
[]
[null,"Calc. of UOM (t-2)","Actual 2012-13","Actual 2013-14","Actual 2014-15",null,"Calc. of UOM (t-2)","Actual 2012-13","Actual 2013-14","Actual 2014-15"]
[null,"Estimated Tariff Revenue",0,{"$f":"C14","v":0},{"$f":"D14","v":0},null,"Estimated Tariff Revenue",0,{"$f":"H14","v":0},{"$f":"I14","v":0}]
[null,"Actual Tariff Revenue",0,0,{"$f":"C102","v":0},null,"Actual Tariff Revenue",0,0,{"$f":"H102","v":0}]
[null,"Difference",{"$f":"C20-C19","v":0},{"$f":"D20-D19","v":0},{"$f":"E20-E19","v":0},null,"Difference",{"$f":"H20-H19","v":0},{"$f":"I20-I19","v":0},{"$f":"J20-J19","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"WACC","Actual 2014-15","Actual 2015-16","Actual 2016-17",null,"WACC","Actual 2014-15","Actual 2015-16","Actual 2016-17"]
[null,"CPI (t)",{"$f":"'State Water data inputs'!C11","v":2.9296875E-2},{"$f":"'State Water data inputs'!D11","v":0},{"$f":"'State Water data inputs'!E11","v":0},null,"CPI (t)",{"$f":"C31","v":2.9296875E-2},{"$f":"D31","v":0},0]
[null,"Real Pre Tax WACC",{"$f":"'ACCC data inputs'!B39","v":4.2572208678693269E-2},{"$f":"'ACCC data inputs'!C39","v":4.2572208678693269E-2},{"$f":"'ACCC data inputs'!D39","v":4.2572208678693269E-2},null,"Real Pre Tax WACC",{"$f":"C32","v":4.2572208678693269E-2},4.2572208678693269E-2,4.2572208678693269E-2]
[null,"Nominal Pre Tax WACC",{"$f":"(1+C31)*(1+C32)-1","v":7.311631635482696E-2},{"$f":"(1+D31)*(1+D32)-1","v":4.2572208678693269E-2},4.2572208678693269E-2,null,"Nominal Pre Tax WACC",{"$f":"(1+H31)*(1+H32)-1","v":7.311631635482696E-2},{"$f":"(1+I31)*(1+I32)-1","v":4.2572208678693269E-2},{"$f":"(1+J31)*(1+J32)-1","v":4.2572208678693269E-2}]
[]
[]
[null,"RAB UOM","Actual 2014-15","Actual 2015-16","Actual 2016-17",null,null,"Actual 2014-15","Actual 2015-16","Actual 2016-17"]
[null,"Opening balance",0,{"$f":"C40","v":0},{"$f":"D40","v":-1536651.2891823747}]
[null,"UOM (t-1)",{"$f":"C15","v":0},{"$f":"D15","v":-1536651.2891823747},{"$f":"E15","v":-1609910.109799346},null,"UOM (t-1)",{"$f":"H15","v":0},{"$f":"I15","v":-720507.8125},{"$f":"J15","v":-1471689.2339483788}]
[null,"UOM (t-2)",0,{"$f":"D21*(1+C$33)","v":0},{"$f":"E21*(1+D$33)","v":0},null,"UOM (t-2)",0,{"$f":"I21*(1+H$33)","v":0},{"$f":"J21*(1+I$33)","v":0}]
[null,"Closing balance",{"$f":"SUM(C37:C39)","v":0},{"$f":"SUM(D37:D39)","v":-1536651.2891823747},-3146561.3989817207]
[]
[null,"Rev UOM (t)",{"$f":"C40*C$33","v":0},{"$f":"D40*D$33","v":-65418.639349455094},{"$f":"E40*E$33","v":-133956.06849777084},null,"Rev UOM (t)",{"$f":"SUM(H38:H40)*(1+H$33)","v":0},{"$f":"SUM(I38:I39)*(1+I$33)","v":-751181.42144837882},{"$f":"SUM(J38:J39)*(1+J$33)","v":-1534342.2951262156}]
[]
[]
[]
[null,"Revenue Requirement","2014-15","2015-16"," 2016-17",null,"Maximum pass through revenue","2014-15","2015-16"," 2016-17"]
[null,"Revenue Requirement",{"$f":"(C7-C42)","v":1536651.2891823747},{"$f":"(D7-D42)","v":1609910.109799346},{"$f":"(E7-E42)","v":1686327.7217709895},null,"Maximum MDBA / BCR Revenue",{"$f":"(H7-H42)","v":720507.8125},{"$f":"(I7-I42)","v":1471689.2339483788},{"$f":"(J7-J42)","v":2254850.1076262156}]
[]
[]
[]
[]
[null,"Forecast Tariff Revenue","2014-15","2015-16","2016-17",null,"Forecast Tariff Revenue","2014-15","2015-16","2016-17"]
[null,"Revenue Requirement",{"$f":"C47","v":1536651.2891823747},{"$f":"D47","v":1609910.109799346},1686327.7217709895,null,"Maximum MDBA / BCR Revenue",{"$f":"H47","v":720507.8125},{"$f":"I47","v":1471689.2339483788},{"$f":"J47","v":2254850.1076262156}]
[null,"Target Variable / Fixed ratio (%)",{"$f":"'ACCC data inputs'!B30","v":0.6},{"$f":"'ACCC data inputs'!C30","v":0.6},{"$f":"'ACCC data inputs'!D30","v":0.6},null,"Target Variable / Fixed ratio (%)",{"$f":"C54","v":0.6},0.6,0.6]
[null,"Variable Charge Revenue",{"$f":"C53*C54","v":921990.77350942476},{"$f":"D53*D54","v":965946.06587960757},{"$f":"E53*E54","v":1011796.6330625936},null,"Variable Charge Revenue",{"$f":"H53*H54","v":432304.6875},{"$f":"I53*I54","v":883013.54036902729},{"$f":"J53*J54","v":1352910.0645757292}]
[]
[null,"Water sharing plan ratio (WSP)",{"$f":"'ACCC data inputs'!$B$19","v":1.28},{"$f":"'ACCC data inputs'!$B$19","v":1.28},{"$f":"'ACCC data inputs'!$B$19","v":1.28},null,"Water sharing plan ratio (WSP)",{"$f":"C57","v":1.28},1.28,1.28]
[null,"Average Water Allocation (AWA)",{"$f":"'State Water data inputs'!L$59","v":2.3184996774455522},{"$f":"'State Water data inputs'!M$59","v":2.2205942583240903},{"$f":"'State Water data inputs'!N$59","v":2.1037208763070332},null,"Average Water Allocation (AWA)",2.3184996774455522,2.2205942583240903,2.1037208763070332]
[null,"High security premium (times)",{"$f":"C57*C58","v":2.967679587130307},{"$f":"D57*D58","v":2.8423606506548356},{"$f":"E57*E58","v":2.6927627216730023},null,"High security premium (times)",2.967679587130307,2.8423606506548356,2.6927627216730023]
[]
[null,"Forecast sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Forecast sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!B$31","v":3122},{"$f":"'State Water data inputs'!C$31","v":0},{"$f":"'State Water data inputs'!D$31","v":0},null,"High Security Entitlement (ML)",{"$f":"C62","v":3122},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!B$17","v":263238},{"$f":"'State Water data inputs'!C$17","v":0},{"$f":"'State Water data inputs'!D$17","v":0},null,"General Security Entitlement (ML)",263238,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!B$44","v":140676.93950000001},{"$f":"'State Water data inputs'!C$44","v":137272.5895},{"$f":"'State Water data inputs'!D$44","v":134078.38949999999},null,"Water volumes (ML)",140676.93950000001,137272.5895,134078.38949999999]
[]
[null,"Tariffs ($ Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs ($ Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement ($/ML)",{"$f":"C68*C59","v":6.6939256630675636},{"$f":"D68*D59","v":0},0,null,"High Security Entitlement ($/ML)",{"$f":"H68*H59","v":3.1386598706468205},{"$f":"I68*I59","v":0},{"$f":"J68*J59","v":0}]
[null,"General Security Entitlement ($/ML)",{"$f":"(C53-C55)/(C63+C62*C59)","v":2.2556092955912637},{"$f":"IF((D63+D62*D59)=0,0,(D53-D55)/(D63+D62*D59))","v":0},{"$f":"IF((E63+E62*E59)=0,0,(E53-E55)/(E63+E62*E59))","v":0},null,"General Security Entitlement ($/ML)",{"$f":"(H53-H55)/(H63+H62*H59)","v":1.0576141320168087},{"$f":"IF((I63+I62*I59)=0,0,(I53-I55)/(I63+I62*I59))","v":0},{"$f":"IF((J63+J62*J59)=0,0,(J53-J55)/(J63+J62*J59))","v":0}]
[null,"Usage ($/ML delivered)",{"$f":"C55/C64","v":6.5539581454245717},{"$f":"D55/D64","v":7.0367002574800814},7.5463065810660988,null,"Usage ($/ML delivered)",{"$f":"H55/H64","v":3.073031649938617},{"$f":"I55/I64","v":6.4325554255609587},{"$f":"J55/J64","v":10.090440895217714}]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C62*C67","v":20898.435920096934},{"$f":"D62*D67","v":0},0,null,"High Security Entitlement",{"$f":"H62*H67","v":9798.8961161593743},0,0]
[null,"General Security Entitlement",{"$f":"C63*C68","v":593762.07975285302},0,0,null,"General Security Entitlement",278404.22888384067,0,0]
[null,"Usage",{"$f":"C64*C69","v":921990.77350942476},965946.06587960757,1011796.6330625936,null,"Usage",432304.6875,883013.54036902729,1352910.0645757292]
[null,null,{"$f":"SUM(C72:C74)","v":1536651.2891823747},{"$f":"SUM(D72:D74)","v":965946.06587960757},1011796.6330625936,null,null,{"$f":"SUM(H72:H74)","v":720507.8125},{"$f":"SUM(I72:I74)","v":883013.54036902729},{"$f":"SUM(J72:J74)","v":1352910.0645757292}]
[null,"Check",{"$f":"ABS(C75-C53)","v":0},{"$f":"ABS(IF(SUM(D72:D73)=0,0,D75-D53))","v":0},{"$f":"ABS(IF(SUM(E72:E73)=0,0,E75-E53))","v":0},null,"Check",{"$f":"ABS(H75-H53)","v":0},{"$f":"ABS(IF(SUM(I72:I73)=0,0,I75-I53))","v":0},0]
[]
[]
[null,"Estimated Tariff Revenue",null,null,null,null,"Estimated Tariff Revenue"]
[null,"Estimated sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Estimated sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!F$31","v":0},{"$f":"'State Water data inputs'!G$31","v":0},{"$f":"'State Water data inputs'!H$31","v":0},null,"High Security Entitlement (ML)",{"$f":"C81","v":0},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!F$17","v":0},{"$f":"'State Water data inputs'!G$17","v":0},{"$f":"'State Water data inputs'!H$17","v":0},null,"General Security Entitlement (ML)",0,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!F$44","v":0},{"$f":"'State Water data inputs'!G$44","v":0},{"$f":"'State Water data inputs'!H$44","v":0},null,"Water volumes (ML)",0,0,0]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C81*C67","v":0},0,0,null,"High Security Entitlement",{"$f":"H81*H67","v":0},0,0]
[null,"General Security Entitlement",0,0,0,null,"General Security Entitlement",0,0,0]
[null,"Usage",0,0,0,null,"Usage",0,0,0]
[null,null,{"$f":"SUM(C86:C88)","v":0},{"$f":"SUM(D86:D88)","v":0},0,null,null,{"$f":"SUM(H86:H88)","v":0},{"$f":"SUM(I86:I88)","v":0},{"$f":"SUM(J86:J88)","v":0}]
[]
[]
[null,"Actual Tariff Revenue",null,null,null,null,"Actual Tariff Revenue"]
[null,"Actual sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Actual sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!K$31","v":0},{"$f":"'State Water data inputs'!L$31","v":0},{"$f":"'State Water data inputs'!M$31","v":0},null,"High Security Entitlement (ML)",{"$f":"C94","v":0},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!K$17","v":0},{"$f":"'State Water data inputs'!L$17","v":0},{"$f":"'State Water data inputs'!M$17","v":0},null,"General Security Entitlement (ML)",0,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!K$44","v":0},{"$f":"'State Water data inputs'!L$44","v":0},{"$f":"'State Water data inputs'!M$44","v":0},null,"Water volumes (ML)",0,0,0]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},{"$f":"E$52","v":"2016-17"},null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C94*C67","v":0},0,0,null,"High Security Entitlement",{"$f":"H94*H67","v":0},0,0]
[null,"General Security Entitlement",0,0,0,null,"General Security Entitlement",0,0,0]
[null,"Usage",0,0,0,null,"Usage",0,0,0]
[null,null,{"$f":"SUM(C99:C101)","v":0},{"$f":"SUM(D99:D101)","v":0},0,null,null,{"$f":"SUM(H99:H101)","v":0},{"$f":"SUM(I99:I101)","v":0},{"$f":"SUM(J99:J101)","v":0}]

{"sheet":"Gwydir","index":6,"n_rows":102,"n_cols":10,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[null,"Gwydir ","Check",{"$f":"IF(E1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(C76:E76,H76:J76)","v":0}]
[]
[null,"State Water Costs Tariffs","2014-15","2015-16"," 2016-17",null,"MDBA / BCR Tariffs","2014-15","2015-16"," 2016-17"]
[]
[]
[null,"Benchmark Revenue (Rev BBM)","Forecast 2014-15","Forecast 2015-16","Forecast 2016-17",null,"MDBA / BCR costs","Forecast 2014-15","Forecast 2015-16","Forecast 2016-17"]
[null,"Benchmark Revenue (Rev BBM)",{"$f":"'ACCC data inputs'!B$7*(1+C$31)","v":4978540.2637404185},{"$f":"'ACCC data inputs'!C$7*(1+C$31)*(1+D$31)","v":5048264.3304460729},{"$f":"'ACCC data inputs'!D$7*(1+C$31)*(1+D$31)*(1+E$31)","v":5118964.8772483887},null,"MDBA / BCR costs",{"$f":"'ACCC data inputs'!G$7*(1+H$31)","v":0},{"$f":"'ACCC data inputs'!H$7*(1+H$31)*(1+I$31)","v":0},{"$f":"'ACCC data inputs'!I$7*(1+H$31)*(1+I$31)*(1+J$31)","v":0}]
[]
[]
[]
[null,"Unders/Overs Adjustment",null,null,null,null,"Unders/Overs Adjustment"]
[null,"Calc. of UOM (t-1)","Estimated 2013-14","Estimated 2014-15","Estimated 2015-16",null,"Calc. of UOM (t-1)","Estimated 2013-14","Estimated 2014-15","Estimated 2015-16"]
[null,"Revenue Requirement",0,{"$f":"C47","v":4978540.2637404185},{"$f":"D47","v":5260211.7854693066},null,"MDBA / BCR costs",0,{"$f":"H47","v":0},{"$f":"I47","v":0}]
[null,"Estimated Tariff Revenue",0,{"$f":"C89","v":0},{"$f":"D89","v":0},null,"Estimated MDBA / BCR revenue",0,{"$f":"H89","v":0},{"$f":"I89","v":0}]
[null,"Difference",{"$f":"C14-C13","v":0},{"$f":"D14-D13","v":-4978540.2637404185},{"$f":"E14-E13","v":-5260211.7854693066},null,"Difference",{"$f":"H14-H13","v":0},{"$f":"I14-I13","v":0},{"$f":"J14-J13","v":0}]
[]
[]
[null,"Calc. of UOM (t-2)","Actual 2012-13","Actual 2013-14","Actual 2014-15",null,"Calc. of UOM (t-2)","Actual 2012-13","Actual 2013-14","Actual 2014-15"]
[null,"Estimated Tariff Revenue",0,{"$f":"C14","v":0},{"$f":"D14","v":0},null,"Estimated Tariff Revenue",0,{"$f":"H14","v":0},{"$f":"I14","v":0}]
[null,"Actual Tariff Revenue",0,0,{"$f":"C102","v":0},null,"Actual Tariff Revenue",0,0,{"$f":"H102","v":0}]
[null,"Difference",{"$f":"C20-C19","v":0},{"$f":"D20-D19","v":0},{"$f":"E20-E19","v":0},null,"Difference",{"$f":"H20-H19","v":0},{"$f":"I20-I19","v":0},{"$f":"J20-J19","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"WACC","Actual 2014-15","Actual 2015-16","Actual 2016-17",null,"WACC","Actual 2014-15","Actual 2015-16","Actual 2016-17"]
[null,"CPI (t)",{"$f":"'State Water data inputs'!C11","v":2.9296875E-2},{"$f":"'State Water data inputs'!D11","v":0},{"$f":"'State Water data inputs'!E11","v":0},null,"CPI (t)",{"$f":"C31","v":2.9296875E-2},{"$f":"D31","v":0},0]
[null,"Real Pre Tax WACC",{"$f":"'ACCC data inputs'!B39","v":4.2572208678693269E-2},{"$f":"'ACCC data inputs'!C39","v":4.2572208678693269E-2},{"$f":"'ACCC data inputs'!D39","v":4.2572208678693269E-2},null,"Real Pre Tax WACC",{"$f":"C32","v":4.2572208678693269E-2},4.2572208678693269E-2,4.2572208678693269E-2]
[null,"Nominal Pre Tax WACC",{"$f":"(1+C31)*(1+C32)-1","v":7.311631635482696E-2},{"$f":"(1+D31)*(1+D32)-1","v":4.2572208678693269E-2},4.2572208678693269E-2,null,"Nominal Pre Tax WACC",{"$f":"(1+H31)*(1+H32)-1","v":7.311631635482696E-2},{"$f":"(1+I31)*(1+I32)-1","v":4.2572208678693269E-2},{"$f":"(1+J31)*(1+J32)-1","v":4.2572208678693269E-2}]
[]
[]
[null,"RAB UOM","Actual 2014-15","Actual 2015-16","Actual 2016-17",null,null,"Actual 2014-15","Actual 2015-16","Actual 2016-17"]
[null,"Opening balance",0,{"$f":"C40","v":0},{"$f":"D40","v":-4978540.2637404185}]
[null,"UOM (t-1)",{"$f":"C15","v":0},{"$f":"D15","v":-4978540.2637404185},{"$f":"E15","v":-5260211.7854693066},null,"UOM (t-1)",{"$f":"H15","v":0},{"$f":"I15","v":0},{"$f":"J15","v":0}]
[null,"UOM (t-2)",0,{"$f":"D21*(1+C$33)","v":0},{"$f":"E21*(1+D$33)","v":0},null,"UOM (t-2)",0,{"$f":"I21*(1+H$33)","v":0},{"$f":"J21*(1+I$33)","v":0}]
[null,"Closing balance",{"$f":"SUM(C37:C39)","v":0},{"$f":"SUM(D37:D39)","v":-4978540.2637404185},-10238752.049209725]
[]
[null,"Rev UOM (t)",{"$f":"C40*C$33","v":0},{"$f":"D40*D$33","v":-211947.45502323372},{"$f":"E40*E$33","v":-435886.28884835477},null,"Rev UOM (t)",{"$f":"SUM(H38:H40)*(1+H$33)","v":0},{"$f":"SUM(I38:I39)*(1+I$33)","v":0},{"$f":"SUM(J38:J39)*(1+J$33)","v":0}]
[]
[]
[]
[null,"Revenue Requirement","2014-15","2015-16"," 2016-17",null,"Maximum pass through revenue","2014-15","2015-16"," 2016-17"]
[null,"Revenue Requirement",{"$f":"(C7-C42)","v":4978540.2637404185},{"$f":"(D7-D42)","v":5260211.7854693066},{"$f":"(E7-E42)","v":5554851.1660967432},null,"Maximum MDBA / BCR Revenue",{"$f":"(H7-H42)","v":0},{"$f":"(I7-I42)","v":0},{"$f":"(J7-J42)","v":0}]
[]
[]
[]
[]
[null,"Forecast Tariff Revenue","2014-15","2015-16","2016-17",null,"Forecast Tariff Revenue","2014-15","2015-16","2016-17"]
[null,"Revenue Requirement",{"$f":"C47","v":4978540.2637404185},{"$f":"D47","v":5260211.7854693066},5554851.1660967432,null,"Maximum MDBA / BCR Revenue",{"$f":"H47","v":0},{"$f":"I47","v":0},{"$f":"J47","v":0}]
[null,"Target Variable / Fixed ratio (%)",{"$f":"'ACCC data inputs'!B30","v":0.6},{"$f":"'ACCC data inputs'!C30","v":0.6},{"$f":"'ACCC data inputs'!D30","v":0.6},null,"Target Variable / Fixed ratio (%)",{"$f":"C54","v":0.6},0.6,0.6]
[null,"Variable Charge Revenue",{"$f":"C53*C54","v":2987124.1582442508},{"$f":"D53*D54","v":3156127.071281584},{"$f":"E53*E54","v":3332910.699658046},null,"Variable Charge Revenue",{"$f":"H53*H54","v":0},{"$f":"I53*I54","v":0},{"$f":"J53*J54","v":0}]
[]
[null,"Water sharing plan ratio (WSP)",{"$f":"'ACCC data inputs'!$B$20","v":1.81},{"$f":"'ACCC data inputs'!$B$20","v":1.81},{"$f":"'ACCC data inputs'!$B$20","v":1.81},null,"Water sharing plan ratio (WSP)",{"$f":"C57","v":1.81},1.81,1.81]
[null,"Average Water Allocation (AWA)",{"$f":"'State Water data inputs'!L$60","v":2.2466505886379928},{"$f":"'State Water data inputs'!M$60","v":2.1343180592060933},{"$f":"'State Water data inputs'!N$60","v":2.0219855297741938},null,"Average Water Allocation (AWA)",2.2466505886379928,2.1343180592060933,2.0219855297741938]
[null,"High security premium (times)",{"$f":"C57*C58","v":4.0664375654347671},{"$f":"D57*D58","v":3.8631156871630288},{"$f":"E57*E58","v":3.6597938088912909},null,"High security premium (times)",4.0664375654347671,3.8631156871630288,3.6597938088912909]
[]
[null,"Forecast sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Forecast sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!B$32","v":21457.9},{"$f":"'State Water data inputs'!C$32","v":0},{"$f":"'State Water data inputs'!D$32","v":0},null,"High Security Entitlement (ML)",{"$f":"C62","v":21457.9},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!B$18","v":509665},{"$f":"'State Water data inputs'!C$18","v":0},{"$f":"'State Water data inputs'!D$18","v":0},null,"General Security Entitlement (ML)",509665,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!B$45","v":245876.74050000001},{"$f":"'State Water data inputs'!C$45","v":240933.61299999998},{"$f":"'State Water data inputs'!D$45","v":238674.57500000001},null,"Water volumes (ML)",245876.74050000001,240933.61299999998,238674.57500000001]
[]
[null,"Tariffs ($ Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs ($ Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement ($/ML)",{"$f":"C68*C59","v":13.566205303673041},{"$f":"D68*D59","v":0},0,null,"High Security Entitlement ($/ML)",{"$f":"H68*H59","v":0},{"$f":"I68*I59","v":0},{"$f":"J68*J59","v":0}]
[null,"General Security Entitlement ($/ML)",{"$f":"(C53-C55)/(C63+C62*C59)","v":3.3361400698703698},{"$f":"IF((D63+D62*D59)=0,0,(D53-D55)/(D63+D62*D59))","v":0},{"$f":"IF((E63+E62*E59)=0,0,(E53-E55)/(E63+E62*E59))","v":0},null,"General Security Entitlement ($/ML)",{"$f":"(H53-H55)/(H63+H62*H59)","v":0},{"$f":"IF((I63+I62*I59)=0,0,(I53-I55)/(I63+I62*I59))","v":0},{"$f":"IF((J63+J62*J59)=0,0,(J53-J55)/(J63+J62*J59))","v":0}]
[null,"Usage ($/ML delivered)",{"$f":"C55/C64","v":12.148868380839181},{"$f":"D55/D64","v":13.099571421284352},13.964246923485863,null,"Usage ($/ML delivered)",{"$f":"H55/H64","v":0},{"$f":"I55/I64","v":0},{"$f":"J55/J64","v":0}]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C62*C67","v":291102.27678568574},{"$f":"D62*D67","v":0},0,null,"High Security Entitlement",{"$f":"H62*H67","v":0},0,0]
[null,"General Security Entitlement",{"$f":"C63*C68","v":1700313.828710482},0,0,null,"General Security Entitlement",0,0,0]
[null,"Usage",{"$f":"C64*C69","v":2987124.1582442508},3156127.071281584,3332910.699658046,null,"Usage",0,0,0]
[null,null,{"$f":"SUM(C72:C74)","v":4978540.2637404185},{"$f":"SUM(D72:D74)","v":3156127.071281584},3332910.699658046,null,null,{"$f":"SUM(H72:H74)","v":0},{"$f":"SUM(I72:I74)","v":0},{"$f":"SUM(J72:J74)","v":0}]
[null,"Check",{"$f":"ABS(C75-C53)","v":0},{"$f":"ABS(IF(SUM(D72:D73)=0,0,D75-D53))","v":0},{"$f":"ABS(IF(SUM(E72:E73)=0,0,E75-E53))","v":0},null,"Check",{"$f":"ABS(H75-H53)","v":0},{"$f":"ABS(IF(SUM(I72:I73)=0,0,I75-I53))","v":0},0]
[]
[]
[null,"Estimated Tariff Revenue",null,null,null,null,"Estimated Tariff Revenue"]
[null,"Estimated sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Estimated sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!F$32","v":0},{"$f":"'State Water data inputs'!G$32","v":0},{"$f":"'State Water data inputs'!H$32","v":0},null,"High Security Entitlement (ML)",{"$f":"C81","v":0},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!F$18","v":0},{"$f":"'State Water data inputs'!G$18","v":0},{"$f":"'State Water data inputs'!H$18","v":0},null,"General Security Entitlement (ML)",0,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!F$45","v":0},{"$f":"'State Water data inputs'!G$45","v":0},{"$f":"'State Water data inputs'!H$45","v":0},null,"Water volumes (ML)",0,0,0]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C81*C67","v":0},0,0,null,"High Security Entitlement",{"$f":"H81*H67","v":0},0,0]
[null,"General Security Entitlement",0,0,0,null,"General Security Entitlement",0,0,0]
[null,"Usage",0,0,0,null,"Usage",0,0,0]
[null,null,{"$f":"SUM(C86:C88)","v":0},{"$f":"SUM(D86:D88)","v":0},0,null,null,{"$f":"SUM(H86:H88)","v":0},{"$f":"SUM(I86:I88)","v":0},{"$f":"SUM(J86:J88)","v":0}]
[]
[]
[null,"Actual Tariff Revenue",null,null,null,null,"Actual Tariff Revenue"]
[null,"Actual sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Actual sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!K$32","v":0},{"$f":"'State Water data inputs'!L$32","v":0},{"$f":"'State Water data inputs'!M$32","v":0},null,"High Security Entitlement (ML)",{"$f":"C94","v":0},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!K$18","v":0},{"$f":"'State Water data inputs'!L$18","v":0},{"$f":"'State Water data inputs'!M$18","v":0},null,"General Security Entitlement (ML)",0,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!K$45","v":0},{"$f":"'State Water data inputs'!L$45","v":0},{"$f":"'State Water data inputs'!M$45","v":0},null,"Water volumes (ML)",0,0,0]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},{"$f":"E$52","v":"2016-17"},null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C94*C67","v":0},0,0,null,"High Security Entitlement",{"$f":"H94*H67","v":0},0,0]
[null,"General Security Entitlement",0,0,0,null,"General Security Entitlement",0,0,0]
[null,"Usage",0,0,0,null,"Usage",0,0,0]
[null,null,{"$f":"SUM(C99:C101)","v":0},{"$f":"SUM(D99:D101)","v":0},0,null,null,{"$f":"SUM(H99:H101)","v":0},{"$f":"SUM(I99:I101)","v":0},{"$f":"SUM(J99:J101)","v":0}]

{"sheet":"Namoi","index":7,"n_rows":102,"n_cols":10,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[null,"Namoi ","Check",{"$f":"IF(E1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(C76:E76,H76:J76)","v":0}]
[]
[null,"State Water Costs Tariffs","2014-15","2015-16"," 2016-17",null,"MDBA / BCR Tariffs","2014-15","2015-16"," 2016-17"]
[]
[]
[null,"Benchmark Revenue (Rev BBM)","Forecast 2014-15","Forecast 2015-16","Forecast 2016-17",null,"MDBA / BCR costs","Forecast 2014-15","Forecast 2015-16","Forecast 2016-17"]
[null,"Benchmark Revenue (Rev BBM)",{"$f":"'ACCC data inputs'!B$8*(1+C$31)","v":5281330.9754937626},{"$f":"'ACCC data inputs'!C$8*(1+C$31)*(1+D$31)","v":5316929.9626243515},{"$f":"'ACCC data inputs'!D$8*(1+C$31)*(1+D$31)*(1+E$31)","v":5352768.9059119411},null,"MDBA / BCR costs",{"$f":"'ACCC data inputs'!G$8*(1+H$31)","v":0},{"$f":"'ACCC data inputs'!H$8*(1+H$31)*(1+I$31)","v":0},{"$f":"'ACCC data inputs'!I$8*(1+H$31)*(1+I$31)*(1+J$31)","v":0}]
[]
[]
[]
[null,"Unders/Overs Adjustment",null,null,null,null,"Unders/Overs Adjustment"]
[null,"Calc. of UOM (t-1)","Estimated 2013-14","Estimated 2014-15","Estimated 2015-16",null,"Calc. of UOM (t-1)","Estimated 2013-14","Estimated 2014-15","Estimated 2015-16"]
[null,"Revenue Requirement",0,{"$f":"C47","v":5281330.9754937626},{"$f":"D47","v":5541767.8870143183},null,"MDBA / BCR costs",0,{"$f":"H47","v":0},{"$f":"I47","v":0}]
[null,"Estimated Tariff Revenue",0,{"$f":"C89","v":0},{"$f":"D89","v":0},null,"Estimated MDBA / BCR revenue",0,{"$f":"H89","v":0},{"$f":"I89","v":0}]
[null,"Difference",{"$f":"C14-C13","v":0},{"$f":"D14-D13","v":-5281330.9754937626},{"$f":"E14-E13","v":-5541767.8870143183},null,"Difference",{"$f":"H14-H13","v":0},{"$f":"I14-I13","v":0},{"$f":"J14-J13","v":0}]
[]
[]
[null,"Calc. of UOM (t-2)","Actual 2012-13","Actual 2013-14","Actual 2014-15",null,"Calc. of UOM (t-2)","Actual 2012-13","Actual 2013-14","Actual 2014-15"]
[null,"Estimated Tariff Revenue",0,{"$f":"C14","v":0},{"$f":"D14","v":0},null,"Estimated Tariff Revenue",0,{"$f":"H14","v":0},{"$f":"I14","v":0}]
[null,"Actual Tariff Revenue",0,0,{"$f":"C102","v":0},null,"Actual Tariff Revenue",0,0,{"$f":"H102","v":0}]
[null,"Difference",{"$f":"C20-C19","v":0},{"$f":"D20-D19","v":0},{"$f":"E20-E19","v":0},null,"Difference",{"$f":"H20-H19","v":0},{"$f":"I20-I19","v":0},{"$f":"J20-J19","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"WACC","Actual 2014-15","Actual 2015-16","Actual 2016-17",null,"WACC","Actual 2014-15","Actual 2015-16","Actual 2016-17"]
[null,"CPI (t)",{"$f":"'State Water data inputs'!C11","v":2.9296875E-2},{"$f":"'State Water data inputs'!D11","v":0},{"$f":"'State Water data inputs'!E11","v":0},null,"CPI (t)",{"$f":"C31","v":2.9296875E-2},{"$f":"D31","v":0},0]
[null,"Real Pre Tax WACC",{"$f":"'ACCC data inputs'!B39","v":4.2572208678693269E-2},{"$f":"'ACCC data inputs'!C39","v":4.2572208678693269E-2},{"$f":"'ACCC data inputs'!D39","v":4.2572208678693269E-2},null,"Real Pre Tax WACC",{"$f":"C32","v":4.2572208678693269E-2},4.2572208678693269E-2,4.2572208678693269E-2]
[null,"Nominal Pre Tax WACC",{"$f":"(1+C31)*(1+C32)-1","v":7.311631635482696E-2},{"$f":"(1+D31)*(1+D32)-1","v":4.2572208678693269E-2},4.2572208678693269E-2,null,"Nominal Pre Tax WACC",{"$f":"(1+H31)*(1+H32)-1","v":7.311631635482696E-2},{"$f":"(1+I31)*(1+I32)-1","v":4.2572208678693269E-2},{"$f":"(1+J31)*(1+J32)-1","v":4.2572208678693269E-2}]
[]
[]
[null,"RAB UOM","Actual 2014-15","Actual 2015-16","Actual 2016-17",null,null,"Actual 2014-15","Actual 2015-16","Actual 2016-17"]
[null,"Opening balance",0,{"$f":"C40","v":0},{"$f":"D40","v":-5281330.9754937626}]
[null,"UOM (t-1)",{"$f":"C15","v":0},{"$f":"D15","v":-5281330.9754937626},{"$f":"E15","v":-5541767.8870143183},null,"UOM (t-1)",{"$f":"H15","v":0},{"$f":"I15","v":0},{"$f":"J15","v":0}]
[null,"UOM (t-2)",0,{"$f":"D21*(1+C$33)","v":0},{"$f":"E21*(1+D$33)","v":0},null,"UOM (t-2)",0,{"$f":"I21*(1+H$33)","v":0},{"$f":"J21*(1+I$33)","v":0}]
[null,"Closing balance",{"$f":"SUM(C37:C39)","v":0},{"$f":"SUM(D37:D39)","v":-5281330.9754937626},-10823098.862508081]
[]
[null,"Rev UOM (t)",{"$f":"C40*C$33","v":0},{"$f":"D40*D$33","v":-224837.92438996714},{"$f":"E40*E$33","v":-460763.22332482174},null,"Rev UOM (t)",{"$f":"SUM(H38:H40)*(1+H$33)","v":0},{"$f":"SUM(I38:I39)*(1+I$33)","v":0},{"$f":"SUM(J38:J39)*(1+J$33)","v":0}]
[]
[]
[]
[null,"Revenue Requirement","2014-15","2015-16"," 2016-17",null,"Maximum pass through revenue","2014-15","2015-16"," 2016-17"]
[null,"Revenue Requirement",{"$f":"(C7-C42)","v":5281330.9754937626},{"$f":"(D7-D42)","v":5541767.8870143183},{"$f":"(E7-E42)","v":5813532.1292367624},null,"Maximum MDBA / BCR Revenue",{"$f":"(H7-H42)","v":0},{"$f":"(I7-I42)","v":0},{"$f":"(J7-J42)","v":0}]
[]
[]
[]
[]
[null,"Forecast Tariff Revenue","2014-15","2015-16","2016-17",null,"Forecast Tariff Revenue","2014-15","2015-16","2016-17"]
[null,"Revenue Requirement",{"$f":"C47","v":5281330.9754937626},{"$f":"D47","v":5541767.8870143183},5813532.1292367624,null,"Maximum MDBA / BCR Revenue",{"$f":"H47","v":0},{"$f":"I47","v":0},{"$f":"J47","v":0}]
[null,"Target Variable / Fixed ratio (%)",{"$f":"'ACCC data inputs'!B30","v":0.6},{"$f":"'ACCC data inputs'!C30","v":0.6},{"$f":"'ACCC data inputs'!D30","v":0.6},null,"Target Variable / Fixed ratio (%)",{"$f":"C54","v":0.6},0.6,0.6]
[null,"Variable Charge Revenue",{"$f":"C53*C54","v":3168798.5852962574},{"$f":"D53*D54","v":3325060.732208591},{"$f":"E53*E54","v":3488119.2775420574},null,"Variable Charge Revenue",{"$f":"H53*H54","v":0},{"$f":"I53*I54","v":0},{"$f":"J53*J54","v":0}]
[]
[null,"Water sharing plan ratio (WSP)",{"$f":"'ACCC data inputs'!$B$21","v":1.25},{"$f":"'ACCC data inputs'!$B$21","v":1.25},{"$f":"'ACCC data inputs'!$B$21","v":1.25},null,"Water sharing plan ratio (WSP)",{"$f":"C57","v":1.25},1.25,1.25]
[null,"Average Water Allocation (AWA)",{"$f":"'State Water data inputs'!L$61","v":1.7205369620356692},{"$f":"'State Water data inputs'!M$61","v":1.673378083325481},{"$f":"'State Water data inputs'!N$61","v":1.58530555262414},null,"Average Water Allocation (AWA)",1.7205369620356692,1.673378083325481,1.58530555262414]
[null,"High security premium (times)",{"$f":"C57*C58","v":2.1506712025445864},{"$f":"D57*D58","v":2.0917226041568511},{"$f":"E57*E58","v":1.981631940780175},null,"High security premium (times)",2.1506712025445864,2.0917226041568511,1.981631940780175]
[]
[null,"Forecast sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Forecast sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!B$33","v":8881},{"$f":"'State Water data inputs'!C$33","v":0},{"$f":"'State Water data inputs'!D$33","v":0},null,"High Security Entitlement (ML)",{"$f":"C62","v":8881},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!B$19","v":256076},{"$f":"'State Water data inputs'!C$19","v":0},{"$f":"'State Water data inputs'!D$19","v":0},null,"General Security Entitlement (ML)",256076,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!B$46","v":158960.9705},{"$f":"'State Water data inputs'!C$46","v":152848.5105},{"$f":"'State Water data inputs'!D$46","v":150866.71549999999},null,"Water volumes (ML)",158960.9705,152848.5105,150866.71549999999]
[]
[null,"Tariffs ($ Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs ($ Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement ($/ML)",{"$f":"C68*C59","v":16.510744920256986},{"$f":"D68*D59","v":0},0,null,"High Security Entitlement ($/ML)",{"$f":"H68*H59","v":0},{"$f":"I68*I59","v":0},{"$f":"J68*J59","v":0}]
[null,"General Security Entitlement ($/ML)",{"$f":"(C53-C55)/(C63+C62*C59)","v":7.6770195745040644},{"$f":"IF((D63+D62*D59)=0,0,(D53-D55)/(D63+D62*D59))","v":0},{"$f":"IF((E63+E62*E59)=0,0,(E53-E55)/(E63+E62*E59))","v":0},null,"General Security Entitlement ($/ML)",{"$f":"(H53-H55)/(H63+H62*H59)","v":0},{"$f":"IF((I63+I62*I59)=0,0,(I53-I55)/(I63+I62*I59))","v":0},{"$f":"IF((J63+J62*J59)=0,0,(J53-J55)/(J63+J62*J59))","v":0}]
[null,"Usage ($/ML delivered)",{"$f":"C55/C64","v":19.934444130084483},{"$f":"D55/D64","v":21.753962281553218},23.120535672708122,null,"Usage ($/ML delivered)",{"$f":"H55/H64","v":0},{"$f":"I55/I64","v":0},{"$f":"J55/J64","v":0}]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C62*C67","v":146631.92563680231},{"$f":"D62*D67","v":0},0,null,"High Security Entitlement",{"$f":"H62*H67","v":0},0,0]
[null,"General Security Entitlement",{"$f":"C63*C68","v":1965900.4645607027},0,0,null,"General Security Entitlement",0,0,0]
[null,"Usage",{"$f":"C64*C69","v":3168798.5852962574},3325060.732208591,3488119.277542057,null,"Usage",0,0,0]
[null,null,{"$f":"SUM(C72:C74)","v":5281330.9754937626},{"$f":"SUM(D72:D74)","v":3325060.732208591},3488119.277542057,null,null,{"$f":"SUM(H72:H74)","v":0},{"$f":"SUM(I72:I74)","v":0},{"$f":"SUM(J72:J74)","v":0}]
[null,"Check",{"$f":"ABS(C75-C53)","v":0},{"$f":"ABS(IF(SUM(D72:D73)=0,0,D75-D53))","v":0},{"$f":"ABS(IF(SUM(E72:E73)=0,0,E75-E53))","v":0},null,"Check",{"$f":"ABS(H75-H53)","v":0},{"$f":"ABS(IF(SUM(I72:I73)=0,0,I75-I53))","v":0},0]
[]
[]
[null,"Estimated Tariff Revenue",null,null,null,null,"Estimated Tariff Revenue"]
[null,"Estimated sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Estimated sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!F$33","v":0},{"$f":"'State Water data inputs'!G$33","v":0},{"$f":"'State Water data inputs'!H$33","v":0},null,"High Security Entitlement (ML)",{"$f":"C81","v":0},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!F$19","v":0},{"$f":"'State Water data inputs'!G$19","v":0},{"$f":"'State Water data inputs'!H$19","v":0},null,"General Security Entitlement (ML)",0,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!F$46","v":0},{"$f":"'State Water data inputs'!G$46","v":0},{"$f":"'State Water data inputs'!H$46","v":0},null,"Water volumes (ML)",0,0,0]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C81*C67","v":0},0,0,null,"High Security Entitlement",{"$f":"H81*H67","v":0},0,0]
[null,"General Security Entitlement",0,0,0,null,"General Security Entitlement",0,0,0]
[null,"Usage",0,0,0,null,"Usage",0,0,0]
[null,null,{"$f":"SUM(C86:C88)","v":0},{"$f":"SUM(D86:D88)","v":0},0,null,null,{"$f":"SUM(H86:H88)","v":0},{"$f":"SUM(I86:I88)","v":0},{"$f":"SUM(J86:J88)","v":0}]
[]
[]
[null,"Actual Tariff Revenue",null,null,null,null,"Actual Tariff Revenue"]
[null,"Actual sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Actual sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!K$33","v":0},{"$f":"'State Water data inputs'!L$33","v":0},{"$f":"'State Water data inputs'!M$33","v":0},null,"High Security Entitlement (ML)",{"$f":"C94","v":0},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!K$19","v":0},{"$f":"'State Water data inputs'!L$19","v":0},{"$f":"'State Water data inputs'!M$19","v":0},null,"General Security Entitlement (ML)",0,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!K$46","v":0},{"$f":"'State Water data inputs'!L$46","v":0},{"$f":"'State Water data inputs'!M$46","v":0},null,"Water volumes (ML)",0,0,0]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},{"$f":"E$52","v":"2016-17"},null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C94*C67","v":0},0,0,null,"High Security Entitlement",{"$f":"H94*H67","v":0},0,0]
[null,"General Security Entitlement",0,0,0,null,"General Security Entitlement",0,0,0]
[null,"Usage",0,0,0,null,"Usage",0,0,0]
[null,null,{"$f":"SUM(C99:C101)","v":0},{"$f":"SUM(D99:D101)","v":0},0,null,null,{"$f":"SUM(H99:H101)","v":0},{"$f":"SUM(I99:I101)","v":0},{"$f":"SUM(J99:J101)","v":0}]

{"sheet":"Peel","index":8,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"Peel","Check",{"$f":"IF(E1>0.001,\"Error\",\"Ok\")","v":"Ok"},0]
[]
[null,"State Water Costs Tariffs",null,null,null,null,null,"MDBA / BCR Tariffs"]
[]
[null,null,null,"2014-15","2015-16"," 2016-17"]
[null,"Peel Valley Annual real price increase cap",null,{"$f":"'ACCC data inputs'!B51","v":0.1},{"$f":"'ACCC data inputs'!C51","v":0.1},{"$f":"'ACCC data inputs'!D51","v":0.1}]
[null,"Actual CPI",null,{"$f":"'State Water data inputs'!C11","v":2.9296875E-2},{"$f":"'State Water data inputs'!D11","v":0},{"$f":"'State Water data inputs'!E11","v":0}]
[]
[]
[null,"Tariffs ($ Nominal)","2013-14","2014-15","2015-16"," 2016-17",null,"Tariffs ($ Nominal)","2014-15","2015-16"," 2016-17"]
[null,"High Security Entitlement ($/ML)",{"$f":"'ACCC data inputs'!B48","v":25.076315111646519},{"$f":"C11*(1+D$6)*(1+D$7)","v":28.392070059026345},{"$f":"D11*(1+E$6)*(1+E$7)","v":31.231277064928982},34.354404771421883,null,"High Security Entitlement ($/ML)",0,0,0]
[null,"General Security Entitlement ($/ML)",{"$f":"'ACCC data inputs'!C48","v":2.7574987240675211},{"$f":"C12*(1+D$6)*(1+D$7)","v":3.1221133014491058},3.4343246315940168,3.7777570947534187,null,"General Security Entitlement ($/ML)",0,0,0]
[null,"Usage ($/ML delivered)",{"$f":"'ACCC data inputs'!D48","v":41.422210075252544},{"$f":"C13*(1+D$6)*(1+D$7)","v":46.899326524656054},51.589259177121662,56.748185094833829,null,"Usage ($/ML delivered)",0,0,0]

{"sheet":"Lachlan","index":9,"n_rows":102,"n_cols":10,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[null,"Lachlan","Check",{"$f":"IF(E1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(C76:E76,H76:J76)","v":9.3132257461547852E-10}]
[]
[null,"State Water Costs Tariffs","2014-15","2015-16"," 2016-17",null,"MDBA / BCR Tariffs","2014-15","2015-16"," 2016-17"]
[]
[]
[null,"Benchmark Revenue (Rev BBM)","Forecast 2014-15","Forecast 2015-16","Forecast 2016-17",null,"MDBA / BCR costs","Forecast 2014-15","Forecast 2015-16","Forecast 2016-17"]
[null,"Benchmark Revenue (Rev BBM)",{"$f":"'ACCC data inputs'!B$10*(1+C$31)","v":6989360.4095744016},{"$f":"'ACCC data inputs'!C$10*(1+C$31)*(1+D$31)","v":7130246.5191898644},{"$f":"'ACCC data inputs'!D$10*(1+C$31)*(1+D$31)*(1+E$31)","v":7273972.501800769},null,"MDBA / BCR costs",{"$f":"'ACCC data inputs'!G$10*(1+H$31)","v":0},{"$f":"'ACCC data inputs'!H$10*(1+H$31)*(1+I$31)","v":0},{"$f":"'ACCC data inputs'!I$10*(1+H$31)*(1+I$31)*(1+J$31)","v":0}]
[]
[]
[]
[null,"Unders/Overs Adjustment",null,null,null,null,"Unders/Overs Adjustment"]
[null,"Calc. of UOM (t-1)","Estimated 2013-14","Estimated 2014-15","Estimated 2015-16",null,"Calc. of UOM (t-1)","Estimated 2013-14","Estimated 2014-15","Estimated 2015-16"]
[null,"Revenue Requirement",0,{"$f":"C47","v":6989360.4095744016},{"$f":"D47","v":7427799.0290768631},null,"MDBA / BCR costs",0,{"$f":"H47","v":0},{"$f":"I47","v":0}]
[null,"Estimated Tariff Revenue",0,{"$f":"C89","v":0},{"$f":"D89","v":0},null,"Estimated MDBA / BCR revenue",0,{"$f":"H89","v":0},{"$f":"I89","v":0}]
[null,"Difference",{"$f":"C14-C13","v":0},{"$f":"D14-D13","v":-6989360.4095744016},{"$f":"E14-E13","v":-7427799.0290768631},null,"Difference",{"$f":"H14-H13","v":0},{"$f":"I14-I13","v":0},{"$f":"J14-J13","v":0}]
[]
[]
[null,"Calc. of UOM (t-2)","Actual 2012-13","Actual 2013-14","Actual 2014-15",null,"Calc. of UOM (t-2)","Actual 2012-13","Actual 2013-14","Actual 2014-15"]
[null,"Estimated Tariff Revenue",0,{"$f":"C14","v":0},{"$f":"D14","v":0},null,"Estimated Tariff Revenue",0,{"$f":"H14","v":0},{"$f":"I14","v":0}]
[null,"Actual Tariff Revenue",0,0,{"$f":"C102","v":0},null,"Actual Tariff Revenue",0,0,{"$f":"H102","v":0}]
[null,"Difference",{"$f":"C20-C19","v":0},{"$f":"D20-D19","v":0},{"$f":"E20-E19","v":0},null,"Difference",{"$f":"H20-H19","v":0},{"$f":"I20-I19","v":0},{"$f":"J20-J19","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"WACC","Actual 2014-15","Actual 2015-16","Actual 2016-17",null,"WACC","Actual 2014-15","Actual 2015-16","Actual 2016-17"]
[null,"CPI (t)",{"$f":"'State Water data inputs'!C11","v":2.9296875E-2},{"$f":"'State Water data inputs'!D11","v":0},{"$f":"'State Water data inputs'!E11","v":0},null,"CPI (t)",{"$f":"C31","v":2.9296875E-2},{"$f":"D31","v":0},0]
[null,"Real Pre Tax WACC",{"$f":"'ACCC data inputs'!B39","v":4.2572208678693269E-2},{"$f":"'ACCC data inputs'!C39","v":4.2572208678693269E-2},{"$f":"'ACCC data inputs'!D39","v":4.2572208678693269E-2},null,"Real Pre Tax WACC",{"$f":"C32","v":4.2572208678693269E-2},4.2572208678693269E-2,4.2572208678693269E-2]
[null,"Nominal Pre Tax WACC",{"$f":"(1+C31)*(1+C32)-1","v":7.311631635482696E-2},{"$f":"(1+D31)*(1+D32)-1","v":4.2572208678693269E-2},4.2572208678693269E-2,null,"Nominal Pre Tax WACC",{"$f":"(1+H31)*(1+H32)-1","v":7.311631635482696E-2},{"$f":"(1+I31)*(1+I32)-1","v":4.2572208678693269E-2},{"$f":"(1+J31)*(1+J32)-1","v":4.2572208678693269E-2}]
[]
[]
[null,"RAB UOM","Actual 2014-15","Actual 2015-16","Actual 2016-17",null,null,"Actual 2014-15","Actual 2015-16","Actual 2016-17"]
[null,"Opening balance",0,{"$f":"C40","v":0},{"$f":"D40","v":-6989360.4095744016}]
[null,"UOM (t-1)",{"$f":"C15","v":0},{"$f":"D15","v":-6989360.4095744016},{"$f":"E15","v":-7427799.0290768631},null,"UOM (t-1)",{"$f":"H15","v":0},{"$f":"I15","v":0},{"$f":"J15","v":0}]
[null,"UOM (t-2)",0,{"$f":"D21*(1+C$33)","v":0},{"$f":"E21*(1+D$33)","v":0},null,"UOM (t-2)",0,{"$f":"I21*(1+H$33)","v":0},{"$f":"J21*(1+I$33)","v":0}]
[null,"Closing balance",{"$f":"SUM(C37:C39)","v":0},{"$f":"SUM(D37:D39)","v":-6989360.4095744016},-14417159.438651264]
[]
[null,"Rev UOM (t)",{"$f":"C40*C$33","v":0},{"$f":"D40*D$33","v":-297552.50988699845},{"$f":"E40*E$33","v":-613770.32017625391},null,"Rev UOM (t)",{"$f":"SUM(H38:H40)*(1+H$33)","v":0},{"$f":"SUM(I38:I39)*(1+I$33)","v":0},{"$f":"SUM(J38:J39)*(1+J$33)","v":0}]
[]
[]
[]
[null,"Revenue Requirement","2014-15","2015-16"," 2016-17",null,"Maximum pass through revenue","2014-15","2015-16"," 2016-17"]
[null,"Revenue Requirement",{"$f":"(C7-C42)","v":6989360.4095744016},{"$f":"(D7-D42)","v":7427799.0290768631},{"$f":"(E7-E42)","v":7887742.821977023},null,"Maximum MDBA / BCR Revenue",{"$f":"(H7-H42)","v":0},{"$f":"(I7-I42)","v":0},{"$f":"(J7-J42)","v":0}]
[]
[]
[]
[]
[null,"Forecast Tariff Revenue","2014-15","2015-16","2016-17",null,"Forecast Tariff Revenue","2014-15","2015-16","2016-17"]
[null,"Revenue Requirement",{"$f":"C47","v":6989360.4095744016},{"$f":"D47","v":7427799.0290768631},7887742.821977023,null,"Maximum MDBA / BCR Revenue",{"$f":"H47","v":0},{"$f":"I47","v":0},{"$f":"J47","v":0}]
[null,"Target Variable / Fixed ratio (%)",{"$f":"'ACCC data inputs'!B30","v":0.6},{"$f":"'ACCC data inputs'!C30","v":0.6},{"$f":"'ACCC data inputs'!D30","v":0.6},null,"Target Variable / Fixed ratio (%)",{"$f":"C54","v":0.6},0.6,0.6]
[null,"Variable Charge Revenue",{"$f":"C53*C54","v":4193616.2457446409},{"$f":"D53*D54","v":4456679.4174461178},{"$f":"E53*E54","v":4732645.6931862133},null,"Variable Charge Revenue",{"$f":"H53*H54","v":0},{"$f":"I53*I54","v":0},{"$f":"J53*J54","v":0}]
[]
[null,"Water sharing plan ratio (WSP)",{"$f":"'ACCC data inputs'!$B$23","v":2.4500000000000002},{"$f":"'ACCC data inputs'!$B$23","v":2.4500000000000002},{"$f":"'ACCC data inputs'!$B$23","v":2.4500000000000002},null,"Water sharing plan ratio (WSP)",{"$f":"C57","v":2.4500000000000002},2.4500000000000002,2.4500000000000002]
[null,"Average Water Allocation (AWA)",{"$f":"'State Water data inputs'!L$63","v":1.64506480558325},{"$f":"'State Water data inputs'!M$63","v":1.7553793884484714},{"$f":"'State Water data inputs'!N$63","v":1.8057285180572851},null,"Average Water Allocation (AWA)",1.64506480558325,1.7553793884484714,1.8057285180572851]
[null,"High security premium (times)",{"$f":"C57*C58","v":4.0304087736789631},{"$f":"D57*D58","v":4.3006795016987551},{"$f":"E57*E58","v":4.4240348692403488},null,"High security premium (times)",4.0304087736789631,4.3006795016987551,4.4240348692403488]
[]
[null,"Forecast sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Forecast sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!B$35","v":60745},{"$f":"'State Water data inputs'!C$35","v":0},{"$f":"'State Water data inputs'!D$35","v":0},null,"High Security Entitlement (ML)",{"$f":"C62","v":60745},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!B$21","v":632837},{"$f":"'State Water data inputs'!C$21","v":0},{"$f":"'State Water data inputs'!D$21","v":0},null,"General Security Entitlement (ML)",632837,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!B$48","v":227697.17900000006},{"$f":"'State Water data inputs'!C$48","v":213448.42650000006},{"$f":"'State Water data inputs'!D$48","v":193955.30800000002},null,"Water volumes (ML)",227697.17900000006,213448.42650000006,193955.30800000002]
[]
[null,"Tariffs ($ Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs ($ Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement ($/ML)",{"$f":"C68*C59","v":12.838614189054654},{"$f":"D68*D59","v":0},0,null,"High Security Entitlement ($/ML)",{"$f":"H68*H59","v":0},{"$f":"I68*I59","v":0},{"$f":"J68*J59","v":0}]
[null,"General Security Entitlement ($/ML)",{"$f":"(C53-C55)/(C63+C62*C59)","v":3.1854372372595718},{"$f":"IF((D63+D62*D59)=0,0,(D53-D55)/(D63+D62*D59))","v":0},{"$f":"IF((E63+E62*E59)=0,0,(E53-E55)/(E63+E62*E59))","v":0},null,"General Security Entitlement ($/ML)",{"$f":"(H53-H55)/(H63+H62*H59)","v":0},{"$f":"IF((I63+I62*I59)=0,0,(I53-I55)/(I63+I62*I59))","v":0},{"$f":"IF((J63+J62*J59)=0,0,(J53-J55)/(J63+J62*J59))","v":0}]
[null,"Usage ($/ML delivered)",{"$f":"C55/C64","v":18.417515158343878},{"$f":"D55/D64","v":20.879420338318194},24.400702110128446,null,"Usage ($/ML delivered)",{"$f":"H55/H64","v":0},{"$f":"I55/I64","v":0},{"$f":"J55/J64","v":0}]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C62*C67","v":779881.61891412502},{"$f":"D62*D67","v":0},0,null,"High Security Entitlement",{"$f":"H62*H67","v":0},0,0]
[null,"General Security Entitlement",{"$f":"C63*C68","v":2015862.5449156356},0,0,null,"General Security Entitlement",0,0,0]
[null,"Usage",{"$f":"C64*C69","v":4193616.2457446405},4456679.4174461178,4732645.6931862133,null,"Usage",0,0,0]
[null,null,{"$f":"SUM(C72:C74)","v":6989360.4095744006},{"$f":"SUM(D72:D74)","v":4456679.4174461178},4732645.6931862133,null,null,{"$f":"SUM(H72:H74)","v":0},{"$f":"SUM(I72:I74)","v":0},{"$f":"SUM(J72:J74)","v":0}]
[null,"Check",{"$f":"ABS(C75-C53)","v":9.3132257461547852E-10},{"$f":"ABS(IF(SUM(D72:D73)=0,0,D75-D53))","v":0},{"$f":"ABS(IF(SUM(E72:E73)=0,0,E75-E53))","v":0},null,"Check",{"$f":"ABS(H75-H53)","v":0},{"$f":"ABS(IF(SUM(I72:I73)=0,0,I75-I53))","v":0},0]
[]
[]
[null,"Estimated Tariff Revenue",null,null,null,null,"Estimated Tariff Revenue"]
[null,"Estimated sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Estimated sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!F$35","v":0},{"$f":"'State Water data inputs'!G$35","v":0},{"$f":"'State Water data inputs'!H$35","v":0},null,"High Security Entitlement (ML)",{"$f":"C81","v":0},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!F$21","v":0},{"$f":"'State Water data inputs'!G$21","v":0},{"$f":"'State Water data inputs'!H$21","v":0},null,"General Security Entitlement (ML)",0,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!F$48","v":0},{"$f":"'State Water data inputs'!G$48","v":0},{"$f":"'State Water data inputs'!H$48","v":0},null,"Water volumes (ML)",0,0,0]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C81*C67","v":0},0,0,null,"High Security Entitlement",{"$f":"H81*H67","v":0},0,0]
[null,"General Security Entitlement",0,0,0,null,"General Security Entitlement",0,0,0]
[null,"Usage",0,0,0,null,"Usage",0,0,0]
[null,null,{"$f":"SUM(C86:C88)","v":0},{"$f":"SUM(D86:D88)","v":0},0,null,null,{"$f":"SUM(H86:H88)","v":0},{"$f":"SUM(I86:I88)","v":0},{"$f":"SUM(J86:J88)","v":0}]
[]
[]
[null,"Actual Tariff Revenue",null,null,null,null,"Actual Tariff Revenue"]
[null,"Actual sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Actual sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!K$35","v":0},{"$f":"'State Water data inputs'!L$35","v":0},{"$f":"'State Water data inputs'!M$35","v":0},null,"High Security Entitlement (ML)",{"$f":"C94","v":0},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!K$21","v":0},{"$f":"'State Water data inputs'!L$21","v":0},{"$f":"'State Water data inputs'!M$21","v":0},null,"General Security Entitlement (ML)",0,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!K$48","v":0},{"$f":"'State Water data inputs'!L$48","v":0},{"$f":"'State Water data inputs'!M$48","v":0},null,"Water volumes (ML)",0,0,0]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},{"$f":"E$52","v":"2016-17"},null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C94*C67","v":0},0,0,null,"High Security Entitlement",{"$f":"H94*H67","v":0},0,0]
[null,"General Security Entitlement",0,0,0,null,"General Security Entitlement",0,0,0]
[null,"Usage",0,0,0,null,"Usage",0,0,0]
[null,null,{"$f":"SUM(C99:C101)","v":0},{"$f":"SUM(D99:D101)","v":0},0,null,null,{"$f":"SUM(H99:H101)","v":0},{"$f":"SUM(I99:I101)","v":0},{"$f":"SUM(J99:J101)","v":0}]

{"sheet":"Macquarie","index":10,"n_rows":102,"n_cols":10,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[null,"Macquarie","Check",{"$f":"IF(E1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(C76:E76,H76:J76)","v":0}]
[]
[null,"State Water Costs Tariffs","2014-15","2015-16"," 2016-17",null,"MDBA / BCR Tariffs","2014-15","2015-16"," 2016-17"]
[]
[]
[null,"Benchmark Revenue (Rev BBM)","Forecast 2014-15","Forecast 2015-16","Forecast 2016-17",null,"MDBA / BCR costs","Forecast 2014-15","Forecast 2015-16","Forecast 2016-17"]
[null,"Benchmark Revenue (Rev BBM)",{"$f":"'ACCC data inputs'!B$11*(1+C$31)","v":6712722.532676531},{"$f":"'ACCC data inputs'!C$11*(1+C$31)*(1+D$31)","v":6838755.5875026761},{"$f":"'ACCC data inputs'!D$11*(1+C$31)*(1+D$31)*(1+E$31)","v":6967154.9446497457},null,"MDBA / BCR costs",{"$f":"'ACCC data inputs'!G$11*(1+H$31)","v":0},{"$f":"'ACCC data inputs'!H$11*(1+H$31)*(1+I$31)","v":0},{"$f":"'ACCC data inputs'!I$11*(1+H$31)*(1+I$31)*(1+J$31)","v":0}]
[]
[]
[]
[null,"Unders/Overs Adjustment",null,null,null,null,"Unders/Overs Adjustment"]
[null,"Calc. of UOM (t-1)","Estimated 2013-14","Estimated 2014-15","Estimated 2015-16",null,"Calc. of UOM (t-1)","Estimated 2013-14","Estimated 2014-15","Estimated 2015-16"]
[null,"Revenue Requirement",0,{"$f":"C47","v":6712722.532676531},{"$f":"D47","v":7124531.0119659482},null,"MDBA / BCR costs",0,{"$f":"H47","v":0},{"$f":"I47","v":0}]
[null,"Estimated Tariff Revenue",0,{"$f":"C89","v":0},{"$f":"D89","v":0},null,"Estimated MDBA / BCR revenue",0,{"$f":"H89","v":0},{"$f":"I89","v":0}]
[null,"Difference",{"$f":"C14-C13","v":0},{"$f":"D14-D13","v":-6712722.532676531},{"$f":"E14-E13","v":-7124531.0119659482},null,"Difference",{"$f":"H14-H13","v":0},{"$f":"I14-I13","v":0},{"$f":"J14-J13","v":0}]
[]
[]
[null,"Calc. of UOM (t-2)","Actual 2012-13","Actual 2013-14","Actual 2014-15",null,"Calc. of UOM (t-2)","Actual 2012-13","Actual 2013-14","Actual 2014-15"]
[null,"Estimated Tariff Revenue",0,{"$f":"C14","v":0},{"$f":"D14","v":0},null,"Estimated Tariff Revenue",0,{"$f":"H14","v":0},{"$f":"I14","v":0}]
[null,"Actual Tariff Revenue",0,0,{"$f":"C102","v":0},null,"Actual Tariff Revenue",0,0,{"$f":"H102","v":0}]
[null,"Difference",{"$f":"C20-C19","v":0},{"$f":"D20-D19","v":0},{"$f":"E20-E19","v":0},null,"Difference",{"$f":"H20-H19","v":0},{"$f":"I20-I19","v":0},{"$f":"J20-J19","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"WACC","Actual 2014-15","Actual 2015-16","Actual 2016-17",null,"WACC","Actual 2014-15","Actual 2015-16","Actual 2016-17"]
[null,"CPI (t)",{"$f":"'State Water data inputs'!C11","v":2.9296875E-2},{"$f":"'State Water data inputs'!D11","v":0},{"$f":"'State Water data inputs'!E11","v":0},null,"CPI (t)",{"$f":"C31","v":2.9296875E-2},{"$f":"D31","v":0},0]
[null,"Real Pre Tax WACC",{"$f":"'ACCC data inputs'!B39","v":4.2572208678693269E-2},{"$f":"'ACCC data inputs'!C39","v":4.2572208678693269E-2},{"$f":"'ACCC data inputs'!D39","v":4.2572208678693269E-2},null,"Real Pre Tax WACC",{"$f":"C32","v":4.2572208678693269E-2},4.2572208678693269E-2,4.2572208678693269E-2]
[null,"Nominal Pre Tax WACC",{"$f":"(1+C31)*(1+C32)-1","v":7.311631635482696E-2},{"$f":"(1+D31)*(1+D32)-1","v":4.2572208678693269E-2},4.2572208678693269E-2,null,"Nominal Pre Tax WACC",{"$f":"(1+H31)*(1+H32)-1","v":7.311631635482696E-2},{"$f":"(1+I31)*(1+I32)-1","v":4.2572208678693269E-2},{"$f":"(1+J31)*(1+J32)-1","v":4.2572208678693269E-2}]
[]
[]
[null,"RAB UOM","Actual 2014-15","Actual 2015-16","Actual 2016-17",null,null,"Actual 2014-15","Actual 2015-16","Actual 2016-17"]
[null,"Opening balance",0,{"$f":"C40","v":0},{"$f":"D40","v":-6712722.532676531}]
[null,"UOM (t-1)",{"$f":"C15","v":0},{"$f":"D15","v":-6712722.532676531},{"$f":"E15","v":-7124531.0119659482},null,"UOM (t-1)",{"$f":"H15","v":0},{"$f":"I15","v":0},{"$f":"J15","v":0}]
[null,"UOM (t-2)",0,{"$f":"D21*(1+C$33)","v":0},{"$f":"E21*(1+D$33)","v":0},null,"UOM (t-2)",0,{"$f":"I21*(1+H$33)","v":0},{"$f":"J21*(1+I$33)","v":0}]
[null,"Closing balance",{"$f":"SUM(C37:C39)","v":0},{"$f":"SUM(D37:D39)","v":-6712722.532676531},-13837253.544642478]
[]
[null,"Rev UOM (t)",{"$f":"C40*C$33","v":0},{"$f":"D40*D$33","v":-285775.42446327169},{"$f":"E40*E$33","v":-589082.44544250774},null,"Rev UOM (t)",{"$f":"SUM(H38:H40)*(1+H$33)","v":0},{"$f":"SUM(I38:I39)*(1+I$33)","v":0},{"$f":"SUM(J38:J39)*(1+J$33)","v":0}]
[]
[]
[]
[null,"Revenue Requirement","2014-15","2015-16"," 2016-17",null,"Maximum pass through revenue","2014-15","2015-16"," 2016-17"]
[null,"Revenue Requirement",{"$f":"(C7-C42)","v":6712722.532676531},{"$f":"(D7-D42)","v":7124531.0119659482},{"$f":"(E7-E42)","v":7556237.3900922537},null,"Maximum MDBA / BCR Revenue",{"$f":"(H7-H42)","v":0},{"$f":"(I7-I42)","v":0},{"$f":"(J7-J42)","v":0}]
[]
[]
[]
[]
[null,"Forecast Tariff Revenue","2014-15","2015-16","2016-17",null,"Forecast Tariff Revenue","2014-15","2015-16","2016-17"]
[null,"Revenue Requirement",{"$f":"C47","v":6712722.532676531},{"$f":"D47","v":7124531.0119659482},7556237.3900922537,null,"Maximum MDBA / BCR Revenue",{"$f":"H47","v":0},{"$f":"I47","v":0},{"$f":"J47","v":0}]
[null,"Target Variable / Fixed ratio (%)",{"$f":"'ACCC data inputs'!B30","v":0.6},{"$f":"'ACCC data inputs'!C30","v":0.6},{"$f":"'ACCC data inputs'!D30","v":0.6},null,"Target Variable / Fixed ratio (%)",{"$f":"C54","v":0.6},0.6,0.6]
[null,"Variable Charge Revenue",{"$f":"C53*C54","v":4027633.5196059183},{"$f":"D53*D54","v":4274718.6071795691},{"$f":"E53*E54","v":4533742.4340553517},null,"Variable Charge Revenue",{"$f":"H53*H54","v":0},{"$f":"I53*I54","v":0},{"$f":"J53*J54","v":0}]
[]
[null,"Water sharing plan ratio (WSP)",{"$f":"'ACCC data inputs'!$B$24","v":1.88},{"$f":"'ACCC data inputs'!$B$24","v":1.88},{"$f":"'ACCC data inputs'!$B$24","v":1.88},null,"Water sharing plan ratio (WSP)",{"$f":"C57","v":1.88},1.88,1.88]
[null,"Average Water Allocation (AWA)",{"$f":"'State Water data inputs'!L$64","v":1.9607843137254897},{"$f":"'State Water data inputs'!M$64","v":2.0652173913043472},{"$f":"'State Water data inputs'!N$64","v":2.1428571428571428},null,"Average Water Allocation (AWA)",1.9607843137254897,2.0652173913043472,2.1428571428571428]
[null,"High security premium (times)",{"$f":"C57*C58","v":3.6862745098039205},{"$f":"D57*D58","v":3.8826086956521726},{"$f":"E57*E58","v":4.0285714285714285},null,"High security premium (times)",3.6862745098039205,3.8826086956521726,4.0285714285714285]
[]
[null,"Forecast sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Forecast sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!B$36","v":42606},{"$f":"'State Water data inputs'!C$36","v":0},{"$f":"'State Water data inputs'!D$36","v":0},null,"High Security Entitlement (ML)",{"$f":"C62","v":42606},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!B$22","v":631716},{"$f":"'State Water data inputs'!C$22","v":0},{"$f":"'State Water data inputs'!D$22","v":0},null,"General Security Entitlement (ML)",631716,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!B$49","v":279670.66850000003},{"$f":"'State Water data inputs'!C$49","v":253939.84950000007},{"$f":"'State Water data inputs'!D$49","v":245588.85600000006},null,"Water volumes (ML)",279670.66850000003,253939.84950000007,245588.85600000006]
[]
[null,"Tariffs ($ Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs ($ Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement ($/ML)",{"$f":"C68*C59","v":12.548565960523744},{"$f":"D68*D59","v":0},0,null,"High Security Entitlement ($/ML)",{"$f":"H68*H59","v":0},{"$f":"I68*I59","v":0},{"$f":"J68*J59","v":0}]
[null,"General Security Entitlement ($/ML)",{"$f":"(C53-C55)/(C63+C62*C59)","v":3.4041322552484634},{"$f":"IF((D63+D62*D59)=0,0,(D53-D55)/(D63+D62*D59))","v":0},{"$f":"IF((E63+E62*E59)=0,0,(E53-E55)/(E63+E62*E59))","v":0},null,"General Security Entitlement ($/ML)",{"$f":"(H53-H55)/(H63+H62*H59)","v":0},{"$f":"IF((I63+I62*I59)=0,0,(I53-I55)/(I63+I62*I59))","v":0},{"$f":"IF((J63+J62*J59)=0,0,(J53-J55)/(J63+J62*J59))","v":0}]
[null,"Usage ($/ML delivered)",{"$f":"C55/C64","v":14.401344056593185},{"$f":"D55/D64","v":16.833587227827227},18.460700977634549,null,"Usage ($/ML delivered)",{"$f":"H55/H64","v":0},{"$f":"I55/I64","v":0},{"$f":"J55/J64","v":0}]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C62*C67","v":534644.20131407469},{"$f":"D62*D67","v":0},0,null,"High Security Entitlement",{"$f":"H62*H67","v":0},0,0]
[null,"General Security Entitlement",{"$f":"C63*C68","v":2150444.8117565382},0,0,null,"General Security Entitlement",0,0,0]
[null,"Usage",{"$f":"C64*C69","v":4027633.5196059183},4274718.6071795691,4533742.4340553517,null,"Usage",0,0,0]
[null,null,{"$f":"SUM(C72:C74)","v":6712722.532676531},{"$f":"SUM(D72:D74)","v":4274718.6071795691},4533742.4340553517,null,null,{"$f":"SUM(H72:H74)","v":0},{"$f":"SUM(I72:I74)","v":0},{"$f":"SUM(J72:J74)","v":0}]
[null,"Check",{"$f":"ABS(C75-C53)","v":0},{"$f":"ABS(IF(SUM(D72:D73)=0,0,D75-D53))","v":0},{"$f":"ABS(IF(SUM(E72:E73)=0,0,E75-E53))","v":0},null,"Check",{"$f":"ABS(H75-H53)","v":0},{"$f":"ABS(IF(SUM(I72:I73)=0,0,I75-I53))","v":0},0]
[]
[]
[null,"Estimated Tariff Revenue",null,null,null,null,"Estimated Tariff Revenue"]
[null,"Estimated sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Estimated sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!F$36","v":0},{"$f":"'State Water data inputs'!G$36","v":0},{"$f":"'State Water data inputs'!H$36","v":0},null,"High Security Entitlement (ML)",{"$f":"C81","v":0},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!F$22","v":0},{"$f":"'State Water data inputs'!G$22","v":0},{"$f":"'State Water data inputs'!H$22","v":0},null,"General Security Entitlement (ML)",0,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!F$49","v":0},{"$f":"'State Water data inputs'!G$49","v":0},{"$f":"'State Water data inputs'!H$49","v":0},null,"Water volumes (ML)",0,0,0]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C81*C67","v":0},0,0,null,"High Security Entitlement",{"$f":"H81*H67","v":0},0,0]
[null,"General Security Entitlement",0,0,0,null,"General Security Entitlement",0,0,0]
[null,"Usage",0,0,0,null,"Usage",0,0,0]
[null,null,{"$f":"SUM(C86:C88)","v":0},{"$f":"SUM(D86:D88)","v":0},0,null,null,{"$f":"SUM(H86:H88)","v":0},{"$f":"SUM(I86:I88)","v":0},{"$f":"SUM(J86:J88)","v":0}]
[]
[]
[null,"Actual Tariff Revenue",null,null,null,null,"Actual Tariff Revenue"]
[null,"Actual sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Actual sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!K$36","v":0},{"$f":"'State Water data inputs'!L$36","v":0},{"$f":"'State Water data inputs'!M$36","v":0},null,"High Security Entitlement (ML)",{"$f":"C94","v":0},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!K$22","v":0},{"$f":"'State Water data inputs'!L$22","v":0},{"$f":"'State Water data inputs'!M$22","v":0},null,"General Security Entitlement (ML)",0,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!K$49","v":0},{"$f":"'State Water data inputs'!L$49","v":0},{"$f":"'State Water data inputs'!M$49","v":0},null,"Water volumes (ML)",0,0,0]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},{"$f":"E$52","v":"2016-17"},null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C94*C67","v":0},0,0,null,"High Security Entitlement",{"$f":"H94*H67","v":0},0,0]
[null,"General Security Entitlement",0,0,0,null,"General Security Entitlement",0,0,0]
[null,"Usage",0,0,0,null,"Usage",0,0,0]
[null,null,{"$f":"SUM(C99:C101)","v":0},{"$f":"SUM(D99:D101)","v":0},0,null,null,{"$f":"SUM(H99:H101)","v":0},{"$f":"SUM(I99:I101)","v":0},{"$f":"SUM(J99:J101)","v":0}]

{"sheet":"Murray","index":11,"n_rows":102,"n_cols":10,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[null,"Murray ","Check",{"$f":"IF(E1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(C76:E76,H76:J76)","v":0}]
[]
[null,"State Water Costs Tariffs","2014-15","2015-16"," 2016-17",null,"MDBA / BCR Tariffs","2014-15","2015-16"," 2016-17"]
[]
[]
[null,"Benchmark Revenue (Rev BBM)","Forecast 2014-15","Forecast 2015-16","Forecast 2016-17",null,"MDBA / BCR costs","Forecast 2014-15","Forecast 2015-16","Forecast 2016-17"]
[null,"Benchmark Revenue (Rev BBM)",{"$f":"'ACCC data inputs'!B$12*(1+C$31)","v":6234692.7004882395},{"$f":"'ACCC data inputs'!C$12*(1+C$31)*(1+D$31)","v":6124676.7872459879},{"$f":"'ACCC data inputs'!D$12*(1+C$31)*(1+D$31)*(1+E$31)","v":6016602.1887962958},null,"MDBA / BCR costs",{"$f":"'ACCC data inputs'!G$12*(1+H$31)","v":10498828.125},{"$f":"'ACCC data inputs'!H$12*(1+H$31)*(1+I$31)","v":10704687.5},{"$f":"'ACCC data inputs'!I$12*(1+H$31)*(1+I$31)*(1+J$31)","v":9572460.9375}]
[]
[]
[]
[null,"Unders/Overs Adjustment",null,null,null,null,"Unders/Overs Adjustment"]
[null,"Calc. of UOM (t-1)","Estimated 2013-14","Estimated 2014-15","Estimated 2015-16",null,"Calc. of UOM (t-1)","Estimated 2013-14","Estimated 2014-15","Estimated 2015-16"]
[null,"Revenue Requirement",0,{"$f":"C47","v":6234692.7004882395},{"$f":"D47","v":6390101.4259386994},null,"MDBA / BCR costs",0,{"$f":"H47","v":10498828.125},{"$f":"I47","v":21650473.926819235}]
[null,"Estimated Tariff Revenue",0,{"$f":"C89","v":0},{"$f":"D89","v":0},null,"Estimated MDBA / BCR revenue",0,{"$f":"H89","v":0},{"$f":"I89","v":0}]
[null,"Difference",{"$f":"C14-C13","v":0},{"$f":"D14-D13","v":-6234692.7004882395},{"$f":"E14-E13","v":-6390101.4259386994},null,"Difference",{"$f":"H14-H13","v":0},{"$f":"I14-I13","v":-10498828.125},{"$f":"J14-J13","v":-21650473.926819235}]
[]
[]
[null,"Calc. of UOM (t-2)","Actual 2012-13","Actual 2013-14","Actual 2014-15",null,"Calc. of UOM (t-2)","Actual 2012-13","Actual 2013-14","Actual 2014-15"]
[null,"Estimated Tariff Revenue",0,{"$f":"C14","v":0},{"$f":"D14","v":0},null,"Estimated Tariff Revenue",0,{"$f":"H14","v":0},{"$f":"I14","v":0}]
[null,"Actual Tariff Revenue",0,0,{"$f":"C102","v":0},null,"Actual Tariff Revenue",0,0,{"$f":"H102","v":0}]
[null,"Difference",{"$f":"C20-C19","v":0},{"$f":"D20-D19","v":0},{"$f":"E20-E19","v":0},null,"Difference",{"$f":"H20-H19","v":0},{"$f":"I20-I19","v":0},{"$f":"J20-J19","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"WACC","Actual 2014-15","Actual 2015-16","Actual 2016-17",null,"WACC","Actual 2014-15","Actual 2015-16","Actual 2016-17"]
[null,"CPI (t)",{"$f":"'State Water data inputs'!C11","v":2.9296875E-2},{"$f":"'State Water data inputs'!D11","v":0},{"$f":"'State Water data inputs'!E11","v":0},null,"CPI (t)",{"$f":"C31","v":2.9296875E-2},{"$f":"D31","v":0},0]
[null,"Real Pre Tax WACC",{"$f":"'ACCC data inputs'!B39","v":4.2572208678693269E-2},{"$f":"'ACCC data inputs'!C39","v":4.2572208678693269E-2},{"$f":"'ACCC data inputs'!D39","v":4.2572208678693269E-2},null,"Real Pre Tax WACC",{"$f":"C32","v":4.2572208678693269E-2},4.2572208678693269E-2,4.2572208678693269E-2]
[null,"Nominal Pre Tax WACC",{"$f":"(1+C31)*(1+C32)-1","v":7.311631635482696E-2},{"$f":"(1+D31)*(1+D32)-1","v":4.2572208678693269E-2},4.2572208678693269E-2,null,"Nominal Pre Tax WACC",{"$f":"(1+H31)*(1+H32)-1","v":7.311631635482696E-2},{"$f":"(1+I31)*(1+I32)-1","v":4.2572208678693269E-2},{"$f":"(1+J31)*(1+J32)-1","v":4.2572208678693269E-2}]
[]
[]
[null,"RAB UOM","Actual 2014-15","Actual 2015-16","Actual 2016-17",null,null,"Actual 2014-15","Actual 2015-16","Actual 2016-17"]
[null,"Opening balance",0,{"$f":"C40","v":0},{"$f":"D40","v":-6234692.7004882395}]
[null,"UOM (t-1)",{"$f":"C15","v":0},{"$f":"D15","v":-6234692.7004882395},{"$f":"E15","v":-6390101.4259386994},null,"UOM (t-1)",{"$f":"H15","v":0},{"$f":"I15","v":-10498828.125},{"$f":"J15","v":-21650473.926819235}]
[null,"UOM (t-2)",0,{"$f":"D21*(1+C$33)","v":0},{"$f":"E21*(1+D$33)","v":0},null,"UOM (t-2)",0,{"$f":"I21*(1+H$33)","v":0},{"$f":"J21*(1+I$33)","v":0}]
[null,"Closing balance",{"$f":"SUM(C37:C39)","v":0},{"$f":"SUM(D37:D39)","v":-6234692.7004882395},-12624794.126426939]
[]
[null,"Rev UOM (t)",{"$f":"C40*C$33","v":0},{"$f":"D40*D$33","v":-265424.63869271101},{"$f":"E40*E$33","v":-537465.3700757887},null,"Rev UOM (t)",{"$f":"SUM(H38:H40)*(1+H$33)","v":0},{"$f":"SUM(I38:I39)*(1+I$33)","v":-10945786.426819233},{"$f":"SUM(J38:J39)*(1+J$33)","v":-22572182.42082439}]
[]
[]
[]
[null,"Revenue Requirement","2014-15","2015-16"," 2016-17",null,"Maximum pass through revenue","2014-15","2015-16"," 2016-17"]
[null,"Revenue Requirement",{"$f":"(C7-C42)","v":6234692.7004882395},{"$f":"(D7-D42)","v":6390101.4259386994},{"$f":"(E7-E42)","v":6554067.5588720841},null,"Maximum MDBA / BCR Revenue",{"$f":"(H7-H42)","v":10498828.125},{"$f":"(I7-I42)","v":21650473.926819235},{"$f":"(J7-J42)","v":32144643.35832439}]
[]
[]
[]
[]
[null,"Forecast Tariff Revenue","2014-15","2015-16","2016-17",null,"Forecast Tariff Revenue","2014-15","2015-16","2016-17"]
[null,"Revenue Requirement",{"$f":"C47","v":6234692.7004882395},{"$f":"D47","v":6390101.4259386994},6554067.5588720841,null,"Maximum MDBA / BCR Revenue",{"$f":"H47","v":10498828.125},{"$f":"I47","v":21650473.926819235},{"$f":"J47","v":32144643.35832439}]
[null,"Target Variable / Fixed ratio (%)",{"$f":"'ACCC data inputs'!B30","v":0.6},{"$f":"'ACCC data inputs'!C30","v":0.6},{"$f":"'ACCC data inputs'!D30","v":0.6},null,"Target Variable / Fixed ratio (%)",{"$f":"C54","v":0.6},0.6,0.6]
[null,"Variable Charge Revenue",{"$f":"C53*C54","v":3740815.6202929434},{"$f":"D53*D54","v":3834060.8555632196},{"$f":"E53*E54","v":3932440.5353232501},null,"Variable Charge Revenue",{"$f":"H53*H54","v":6299296.875},{"$f":"I53*I54","v":12990284.35609154},{"$f":"J53*J54","v":19286786.014994632}]
[]
[null,"Water sharing plan ratio (WSP)",{"$f":"'ACCC data inputs'!$B$25","v":1.25},{"$f":"'ACCC data inputs'!$B$25","v":1.25},{"$f":"'ACCC data inputs'!$B$25","v":1.25},null,"Water sharing plan ratio (WSP)",{"$f":"C57","v":1.25},1.25,1.25]
[null,"Average Water Allocation (AWA)",{"$f":"'State Water data inputs'!L$65","v":1.411111111111111},{"$f":"'State Water data inputs'!M$65","v":1.4795081967213117},{"$f":"'State Water data inputs'!N$65","v":1.5155555555555555},null,"Average Water Allocation (AWA)",1.411111111111111,1.4795081967213117,1.5155555555555555]
[null,"High security premium (times)",{"$f":"C57*C58","v":1.7638888888888888},{"$f":"D57*D58","v":1.8493852459016398},{"$f":"E57*E58","v":1.8944444444444444},null,"High security premium (times)",1.7638888888888888,1.8493852459016398,1.8944444444444444]
[]
[null,"Forecast sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Forecast sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!B$37","v":261400.7},{"$f":"'State Water data inputs'!C$37","v":0},{"$f":"'State Water data inputs'!D$37","v":0},null,"High Security Entitlement (ML)",{"$f":"C62","v":261400.7},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!B$23","v":2075822},{"$f":"'State Water data inputs'!C$23","v":0},{"$f":"'State Water data inputs'!D$23","v":0},null,"General Security Entitlement (ML)",2075822,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!B$50","v":1459688.9339000001},{"$f":"'State Water data inputs'!C$50","v":1368381.7838999999},{"$f":"'State Water data inputs'!D$50","v":1261589.2338999999},null,"Water volumes (ML)",1459688.9339000001,1368381.7838999999,1261589.2338999999]
[]
[null,"Tariffs ($ Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs ($ Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement ($/ML)",{"$f":"C68*C59","v":1.7339727619428122},{"$f":"D68*D59","v":0},0,null,"High Security Entitlement ($/ML)",{"$f":"H68*H59","v":2.919900446680157},{"$f":"I68*I59","v":0},{"$f":"J68*J59","v":0}]
[null,"General Security Entitlement ($/ML)",{"$f":"(C53-C55)/(C63+C62*C59)","v":0.98303967606206677},{"$f":"IF((D63+D62*D59)=0,0,(D53-D55)/(D63+D62*D59))","v":0},{"$f":"IF((E63+E62*E59)=0,0,(E53-E55)/(E63+E62*E59))","v":0},null,"General Security Entitlement ($/ML)",{"$f":"(H53-H55)/(H63+H62*H59)","v":1.6553766311887506},{"$f":"IF((I63+I62*I59)=0,0,(I53-I55)/(I63+I62*I59))","v":0},{"$f":"IF((J63+J62*J59)=0,0,(J53-J55)/(J63+J62*J59))","v":0}]
[null,"Usage ($/ML delivered)",{"$f":"C55/C64","v":2.5627484962143434},{"$f":"D55/D64","v":2.801894106362504},3.1170530230087201,null,"Usage ($/ML delivered)",{"$f":"H55/H64","v":4.3155063580358348},{"$f":"I55/I64","v":9.4931725260681041},{"$f":"J55/J64","v":15.287690713222592}]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C62*C67","v":453261.69375278451},{"$f":"D62*D67","v":0},0,null,"High Security Entitlement",{"$f":"H62*H67","v":763264.02069250576},0,0]
[null,"General Security Entitlement",{"$f":"C63*C68","v":2040615.3864425116},0,0,null,"General Security Entitlement",3436267.2293074946,0,0]
[null,"Usage",{"$f":"C64*C69","v":3740815.6202929434},3834060.8555632192,3932440.5353232501,null,"Usage",6299296.875,12990284.35609154,19286786.014994632]
[null,null,{"$f":"SUM(C72:C74)","v":6234692.7004882395},{"$f":"SUM(D72:D74)","v":3834060.8555632192},3932440.5353232501,null,null,{"$f":"SUM(H72:H74)","v":10498828.125},{"$f":"SUM(I72:I74)","v":12990284.35609154},{"$f":"SUM(J72:J74)","v":19286786.014994632}]
[null,"Check",{"$f":"ABS(C75-C53)","v":0},{"$f":"ABS(IF(SUM(D72:D73)=0,0,D75-D53))","v":0},{"$f":"ABS(IF(SUM(E72:E73)=0,0,E75-E53))","v":0},null,"Check",{"$f":"ABS(H75-H53)","v":0},{"$f":"ABS(IF(SUM(I72:I73)=0,0,I75-I53))","v":0},0]
[]
[]
[null,"Estimated Tariff Revenue",null,null,null,null,"Estimated Tariff Revenue"]
[null,"Estimated sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Estimated sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!F$37","v":0},{"$f":"'State Water data inputs'!G$37","v":0},{"$f":"'State Water data inputs'!H$37","v":0},null,"High Security Entitlement (ML)",{"$f":"C81","v":0},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!F$23","v":0},{"$f":"'State Water data inputs'!G$23","v":0},{"$f":"'State Water data inputs'!H$23","v":0},null,"General Security Entitlement (ML)",0,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!F$50","v":0},{"$f":"'State Water data inputs'!G$50","v":0},{"$f":"'State Water data inputs'!H$50","v":0},null,"Water volumes (ML)",0,0,0]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C81*C67","v":0},0,0,null,"High Security Entitlement",{"$f":"H81*H67","v":0},0,0]
[null,"General Security Entitlement",0,0,0,null,"General Security Entitlement",0,0,0]
[null,"Usage",0,0,0,null,"Usage",0,0,0]
[null,null,{"$f":"SUM(C86:C88)","v":0},{"$f":"SUM(D86:D88)","v":0},0,null,null,{"$f":"SUM(H86:H88)","v":0},{"$f":"SUM(I86:I88)","v":0},{"$f":"SUM(J86:J88)","v":0}]
[]
[]
[null,"Actual Tariff Revenue",null,null,null,null,"Actual Tariff Revenue"]
[null,"Actual sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Actual sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!K$37","v":0},{"$f":"'State Water data inputs'!L$37","v":0},{"$f":"'State Water data inputs'!M$37","v":0},null,"High Security Entitlement (ML)",{"$f":"C94","v":0},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!K$23","v":0},{"$f":"'State Water data inputs'!L$23","v":0},{"$f":"'State Water data inputs'!M$23","v":0},null,"General Security Entitlement (ML)",0,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!K$50","v":0},{"$f":"'State Water data inputs'!L$50","v":0},{"$f":"'State Water data inputs'!M$50","v":0},null,"Water volumes (ML)",0,0,0]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},{"$f":"E$52","v":"2016-17"},null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C94*C67","v":0},0,0,null,"High Security Entitlement",{"$f":"H94*H67","v":0},0,0]
[null,"General Security Entitlement",0,0,0,null,"General Security Entitlement",0,0,0]
[null,"Usage",0,0,0,null,"Usage",0,0,0]
[null,null,{"$f":"SUM(C99:C101)","v":0},{"$f":"SUM(D99:D101)","v":0},0,null,null,{"$f":"SUM(H99:H101)","v":0},{"$f":"SUM(I99:I101)","v":0},{"$f":"SUM(J99:J101)","v":0}]

{"sheet":"Murrumbidgee","index":12,"n_rows":102,"n_cols":10,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[null,"Murrumbidgee","Check",{"$f":"IF(E1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(C76:E76,H76:J76)","v":0}]
[]
[null,"State Water Costs Tariffs","2014-15","2015-16"," 2016-17",null,"MDBA / BCR Tariffs","2014-15","2015-16"," 2016-17"]
[]
[]
[null,"Benchmark Revenue (Rev BBM)","Forecast 2014-15","Forecast 2015-16","Forecast 2016-17",null,"MDBA / BCR costs","Forecast 2014-15","Forecast 2015-16","Forecast 2016-17"]
[null,"Benchmark Revenue (Rev BBM)",{"$f":"'ACCC data inputs'!B$13*(1+C$31)","v":10278578.682861904},{"$f":"'ACCC data inputs'!C$13*(1+C$31)*(1+D$31)","v":10246979.272571024},{"$f":"'ACCC data inputs'!D$13*(1+C$31)*(1+D$31)*(1+E$31)","v":10215477.008272944},null,"MDBA / BCR costs",{"$f":"'ACCC data inputs'!G$13*(1+H$31)","v":2367382.8125},{"$f":"'ACCC data inputs'!H$13*(1+H$31)*(1+I$31)","v":2367382.8125},{"$f":"'ACCC data inputs'!I$13*(1+H$31)*(1+I$31)*(1+J$31)","v":2161523.4375}]
[]
[]
[]
[null,"Unders/Overs Adjustment",null,null,null,null,"Unders/Overs Adjustment"]
[null,"Calc. of UOM (t-1)","Estimated 2013-14","Estimated 2014-15","Estimated 2015-16",null,"Calc. of UOM (t-1)","Estimated 2013-14","Estimated 2014-15","Estimated 2015-16"]
[null,"Revenue Requirement",0,{"$f":"C47","v":10278578.682861904},{"$f":"D47","v":10684561.069178188},null,"MDBA / BCR costs",0,{"$f":"H47","v":2367382.8125},{"$f":"I47","v":4835550.3401161022}]
[null,"Estimated Tariff Revenue",0,{"$f":"C89","v":0},{"$f":"D89","v":0},null,"Estimated MDBA / BCR revenue",0,{"$f":"H89","v":0},{"$f":"I89","v":0}]
[null,"Difference",{"$f":"C14-C13","v":0},{"$f":"D14-D13","v":-10278578.682861904},{"$f":"E14-E13","v":-10684561.069178188},null,"Difference",{"$f":"H14-H13","v":0},{"$f":"I14-I13","v":-2367382.8125},{"$f":"J14-J13","v":-4835550.3401161022}]
[]
[]
[null,"Calc. of UOM (t-2)","Actual 2012-13","Actual 2013-14","Actual 2014-15",null,"Calc. of UOM (t-2)","Actual 2012-13","Actual 2013-14","Actual 2014-15"]
[null,"Estimated Tariff Revenue",0,{"$f":"C14","v":0},{"$f":"D14","v":0},null,"Estimated Tariff Revenue",0,{"$f":"H14","v":0},{"$f":"I14","v":0}]
[null,"Actual Tariff Revenue",0,0,{"$f":"C102","v":0},null,"Actual Tariff Revenue",0,0,{"$f":"H102","v":0}]
[null,"Difference",{"$f":"C20-C19","v":0},{"$f":"D20-D19","v":0},{"$f":"E20-E19","v":0},null,"Difference",{"$f":"H20-H19","v":0},{"$f":"I20-I19","v":0},{"$f":"J20-J19","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"WACC","Actual 2014-15","Actual 2015-16","Actual 2016-17",null,"WACC","Actual 2014-15","Actual 2015-16","Actual 2016-17"]
[null,"CPI (t)",{"$f":"'State Water data inputs'!C11","v":2.9296875E-2},{"$f":"'State Water data inputs'!D11","v":0},{"$f":"'State Water data inputs'!E11","v":0},null,"CPI (t)",{"$f":"C31","v":2.9296875E-2},{"$f":"D31","v":0},0]
[null,"Real Pre Tax WACC",{"$f":"'ACCC data inputs'!B39","v":4.2572208678693269E-2},{"$f":"'ACCC data inputs'!C39","v":4.2572208678693269E-2},{"$f":"'ACCC data inputs'!D39","v":4.2572208678693269E-2},null,"Real Pre Tax WACC",{"$f":"C32","v":4.2572208678693269E-2},4.2572208678693269E-2,4.2572208678693269E-2]
[null,"Nominal Pre Tax WACC",{"$f":"(1+C31)*(1+C32)-1","v":7.311631635482696E-2},{"$f":"(1+D31)*(1+D32)-1","v":4.2572208678693269E-2},4.2572208678693269E-2,null,"Nominal Pre Tax WACC",{"$f":"(1+H31)*(1+H32)-1","v":7.311631635482696E-2},{"$f":"(1+I31)*(1+I32)-1","v":4.2572208678693269E-2},{"$f":"(1+J31)*(1+J32)-1","v":4.2572208678693269E-2}]
[]
[]
[null,"RAB UOM","Actual 2014-15","Actual 2015-16","Actual 2016-17",null,null,"Actual 2014-15","Actual 2015-16","Actual 2016-17"]
[null,"Opening balance",0,{"$f":"C40","v":0},{"$f":"D40","v":-10278578.682861904}]
[null,"UOM (t-1)",{"$f":"C15","v":0},{"$f":"D15","v":-10278578.682861904},{"$f":"E15","v":-10684561.069178188},null,"UOM (t-1)",{"$f":"H15","v":0},{"$f":"I15","v":-2367382.8125},{"$f":"J15","v":-4835550.3401161022}]
[null,"UOM (t-2)",0,{"$f":"D21*(1+C$33)","v":0},{"$f":"E21*(1+D$33)","v":0},null,"UOM (t-2)",0,{"$f":"I21*(1+H$33)","v":0},{"$f":"J21*(1+I$33)","v":0}]
[null,"Closing balance",{"$f":"SUM(C37:C39)","v":0},{"$f":"SUM(D37:D39)","v":-10278578.682861904},-20963139.752040092]
[]
[null,"Rev UOM (t)",{"$f":"C40*C$33","v":0},{"$f":"D40*D$33","v":-437581.79660716519},{"$f":"E40*E$33","v":-892447.16008446109},null,"Rev UOM (t)",{"$f":"SUM(H38:H40)*(1+H$33)","v":0},{"$f":"SUM(I38:I39)*(1+I$33)","v":-2468167.5276161018},{"$f":"SUM(J38:J39)*(1+J$33)","v":-5041410.3982718512}]
[]
[]
[]
[null,"Revenue Requirement","2014-15","2015-16"," 2016-17",null,"Maximum pass through revenue","2014-15","2015-16"," 2016-17"]
[null,"Revenue Requirement",{"$f":"(C7-C42)","v":10278578.682861904},{"$f":"(D7-D42)","v":10684561.069178188},{"$f":"(E7-E42)","v":11107924.168357406},null,"Maximum MDBA / BCR Revenue",{"$f":"(H7-H42)","v":2367382.8125},{"$f":"(I7-I42)","v":4835550.3401161022},{"$f":"(J7-J42)","v":7202933.8357718512}]
[]
[]
[]
[]
[null,"Forecast Tariff Revenue","2014-15","2015-16","2016-17",null,"Forecast Tariff Revenue","2014-15","2015-16","2016-17"]
[null,"Revenue Requirement",{"$f":"C47","v":10278578.682861904},{"$f":"D47","v":10684561.069178188},11107924.168357406,null,"Maximum MDBA / BCR Revenue",{"$f":"H47","v":2367382.8125},{"$f":"I47","v":4835550.3401161022},{"$f":"J47","v":7202933.8357718512}]
[null,"Target Variable / Fixed ratio (%)",{"$f":"'ACCC data inputs'!B30","v":0.6},{"$f":"'ACCC data inputs'!C30","v":0.6},{"$f":"'ACCC data inputs'!D30","v":0.6},null,"Target Variable / Fixed ratio (%)",{"$f":"C54","v":0.6},0.6,0.6]
[null,"Variable Charge Revenue",{"$f":"C53*C54","v":6167147.2097171424},{"$f":"D53*D54","v":6410736.6415069131},{"$f":"E53*E54","v":6664754.5010144431},null,"Variable Charge Revenue",{"$f":"H53*H54","v":1420429.6875},{"$f":"I53*I54","v":2901330.2040696614},{"$f":"J53*J54","v":4321760.3014631104}]
[]
[null,"Water sharing plan ratio (WSP)",{"$f":"'ACCC data inputs'!$B$26","v":1.63},{"$f":"'ACCC data inputs'!$B$26","v":1.63},{"$f":"'ACCC data inputs'!$B$26","v":1.63},null,"Water sharing plan ratio (WSP)",{"$f":"C57","v":1.63},1.63,1.63]
[null,"Average Water Allocation (AWA)",{"$f":"'State Water data inputs'!L$66","v":1.4125433526011555},{"$f":"'State Water data inputs'!M$66","v":1.4675316455696201},{"$f":"'State Water data inputs'!N$66","v":1.5076975945017179},null,"Average Water Allocation (AWA)",1.4125433526011555,1.4675316455696201,1.5076975945017179]
[null,"High security premium (times)",{"$f":"C57*C58","v":2.3024456647398832},{"$f":"D57*D58","v":2.3920765822784809},{"$f":"E57*E58","v":2.4575470790378002},null,"High security premium (times)",2.3024456647398832,2.3920765822784809,2.4575470790378002]
[]
[null,"Forecast sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Forecast sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!B$38","v":436928},{"$f":"'State Water data inputs'!C$38","v":0},{"$f":"'State Water data inputs'!D$38","v":0},null,"High Security Entitlement (ML)",{"$f":"C62","v":436928},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!B$24","v":2260113},{"$f":"'State Water data inputs'!C$24","v":0},{"$f":"'State Water data inputs'!D$24","v":0},null,"General Security Entitlement (ML)",2260113,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!B$51","v":1759739.925},{"$f":"'State Water data inputs'!C$51","v":1655354.4750000001},{"$f":"'State Water data inputs'!D$51","v":1527092.425},null,"Water volumes (ML)",1759739.925,1655354.4750000001,1527092.425]
[]
[null,"Tariffs ($ Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs ($ Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement ($/ML)",{"$f":"C68*C59","v":2.8983500986839501},{"$f":"D68*D59","v":0},0,null,"High Security Entitlement ($/ML)",{"$f":"H68*H59","v":0.6675537951246765},{"$f":"I68*I59","v":0},{"$f":"J68*J59","v":0}]
[null,"General Security Entitlement ($/ML)",{"$f":"(C53-C55)/(C63+C62*C59)","v":1.2588136793279718},{"$f":"IF((D63+D62*D59)=0,0,(D53-D55)/(D63+D62*D59))","v":0},{"$f":"IF((E63+E62*E59)=0,0,(E53-E55)/(E63+E62*E59))","v":0},null,"General Security Entitlement ($/ML)",{"$f":"(H53-H55)/(H63+H62*H59)","v":0.28993248585524939},{"$f":"IF((I63+I62*I59)=0,0,(I53-I55)/(I63+I62*I59))","v":0},{"$f":"IF((J63+J62*J59)=0,0,(J53-J55)/(J63+J62*J59))","v":0}]
[null,"Usage ($/ML delivered)",{"$f":"C55/C64","v":3.5045787858209456},{"$f":"D55/D64","v":3.872727405715874},4.3643425845782993,null,"Usage ($/ML delivered)",{"$f":"H55/H64","v":0.80718159957642599},{"$f":"I55/I64","v":1.7526942101447252},{"$f":"J55/J64","v":2.8300581095889532}]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C62*C67","v":1266370.3119177809},{"$f":"D62*D67","v":0},0,null,"High Security Entitlement",{"$f":"H62*H67","v":291672.94459623465},0,0]
[null,"General Security Entitlement",{"$f":"C63*C68","v":2845061.1612269804},0,0,null,"General Security Entitlement",655280.18040376529,0,0]
[null,"Usage",{"$f":"C64*C69","v":6167147.2097171424},6410736.6415069131,6664754.5010144431,null,"Usage",1420429.6875,2901330.2040696614,4321760.3014631104]
[null,null,{"$f":"SUM(C72:C74)","v":10278578.682861904},{"$f":"SUM(D72:D74)","v":6410736.6415069131},6664754.5010144431,null,null,{"$f":"SUM(H72:H74)","v":2367382.8125},{"$f":"SUM(I72:I74)","v":2901330.2040696614},{"$f":"SUM(J72:J74)","v":4321760.3014631104}]
[null,"Check",{"$f":"ABS(C75-C53)","v":0},{"$f":"ABS(IF(SUM(D72:D73)=0,0,D75-D53))","v":0},{"$f":"ABS(IF(SUM(E72:E73)=0,0,E75-E53))","v":0},null,"Check",{"$f":"ABS(H75-H53)","v":0},{"$f":"ABS(IF(SUM(I72:I73)=0,0,I75-I53))","v":0},0]
[]
[]
[null,"Estimated Tariff Revenue",null,null,null,null,"Estimated Tariff Revenue"]
[null,"Estimated sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Estimated sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!F$38","v":0},{"$f":"'State Water data inputs'!G$38","v":0},{"$f":"'State Water data inputs'!H$38","v":0},null,"High Security Entitlement (ML)",{"$f":"C81","v":0},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!F$24","v":0},{"$f":"'State Water data inputs'!G$24","v":0},{"$f":"'State Water data inputs'!H$24","v":0},null,"General Security Entitlement (ML)",0,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!F$51","v":0},{"$f":"'State Water data inputs'!G$51","v":0},{"$f":"'State Water data inputs'!H$51","v":0},null,"Water volumes (ML)",0,0,0]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C81*C67","v":0},0,0,null,"High Security Entitlement",{"$f":"H81*H67","v":0},0,0]
[null,"General Security Entitlement",0,0,0,null,"General Security Entitlement",0,0,0]
[null,"Usage",0,0,0,null,"Usage",0,0,0]
[null,null,{"$f":"SUM(C86:C88)","v":0},{"$f":"SUM(D86:D88)","v":0},0,null,null,{"$f":"SUM(H86:H88)","v":0},{"$f":"SUM(I86:I88)","v":0},{"$f":"SUM(J86:J88)","v":0}]
[]
[]
[null,"Actual Tariff Revenue",null,null,null,null,"Actual Tariff Revenue"]
[null,"Actual sales quantities",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},"2016-17",null,"Actual sales quantities",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement (ML)",{"$f":"'State Water data inputs'!K$38","v":0},{"$f":"'State Water data inputs'!L$38","v":0},{"$f":"'State Water data inputs'!M$38","v":0},null,"High Security Entitlement (ML)",{"$f":"C94","v":0},0,0]
[null,"General Security Entitlement (ML)",{"$f":"'State Water data inputs'!K$24","v":0},{"$f":"'State Water data inputs'!L$24","v":0},{"$f":"'State Water data inputs'!M$24","v":0},null,"General Security Entitlement (ML)",0,0,0]
[null,"Water volumes (ML)",{"$f":"'State Water data inputs'!K$51","v":0},{"$f":"'State Water data inputs'!L$51","v":0},{"$f":"'State Water data inputs'!M$51","v":0},null,"Water volumes (ML)",0,0,0]
[]
[null,"Tariffs Revenue ($'000 Nominal)",{"$f":"C$52","v":"2014-15"},{"$f":"D$52","v":"2015-16"},{"$f":"E$52","v":"2016-17"},null,"Tariffs Revenue ($'000 Nominal)",{"$f":"H$52","v":"2014-15"},{"$f":"I$52","v":"2015-16"},{"$f":"J$52","v":"2016-17"}]
[null,"High Security Entitlement",{"$f":"C94*C67","v":0},0,0,null,"High Security Entitlement",{"$f":"H94*H67","v":0},0,0]
[null,"General Security Entitlement",0,0,0,null,"General Security Entitlement",0,0,0]
[null,"Usage",0,0,0,null,"Usage",0,0,0]
[null,null,{"$f":"SUM(C99:C101)","v":0},{"$f":"SUM(D99:D101)","v":0},0,null,null,{"$f":"SUM(H99:H101)","v":0},{"$f":"SUM(I99:I101)","v":0},{"$f":"SUM(J99:J101)","v":0}]

{"sheet":"Lowbidgee","index":13,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"Lowbidgee","Check",{"$f":"IF(E1>0.001,\"Error\",\"Ok\")","v":"Ok"},0]
[]
[null,"State Water Costs Tariffs",null,null,null,null,"MDBA / BCR Tariffs"]
[]
[null,null,"2014-15","2015-16"," 2016-17"]
[null,"Tariffs ($ Real 2013-14)"]
[null,"General Security Entitlement ($/ML)",{"$f":"'ACCC data inputs'!B57","v":0.71055047538099136},{"$f":"'ACCC data inputs'!C57","v":0.75043478278794451},{"$f":"'ACCC data inputs'!D57","v":0.79255785863211448}]
[]
[null,"Actual CPI",{"$f":"'State Water data inputs'!C11","v":2.9296875E-2},{"$f":"'State Water data inputs'!D11","v":0},{"$f":"'State Water data inputs'!E11","v":0}]
[]
[]
[null,"Tariffs ($ Nominal)","2014-15","2015-16"," 2016-17",null,"Tariffs ($ Nominal)","2014-15","2015-16"," 2016-17"]
[null,"High Security Entitlement ($/ML)",null,null,null,null,"High Security Entitlement ($/ML)",0,0,0]
[null,"General Security Entitlement ($/ML)",{"$f":"C$7*(1+C$9)","v":0.73136738383941879},{"$f":"D$7*(1+C$9)*(1+D$9)","v":0.77242017681493502},{"$f":"E$7*(1+C$9)*(1+D$9)*(1+E$9)","v":0.81577732714672724},null,"General Security Entitlement ($/ML)",0,0,0]
[null,"Usage ($/ML delivered)",null,null,null,null,"Usage ($/ML delivered)",0,0,0]

{"sheet":"Fish River","index":14,"n_rows":462,"n_cols":10,"rows_kept":462,"cut":false,"hidden":false,"merged":[]}
[null,"Fish River","Check",{"$f":"IF(E1>0.001,\"Error\",\"Ok\")","v":"Ok"},{"$f":"SUM(J149,J184,J204,J229,C235:E235)","v":2.3283064365386963E-9}]
[]
[null,"State Water Costs Tariffs","2014-15","2015-16"," 2016-17"]
[]
[]
[null,"Benchmark Revenue (Rev BBM)","Forecast 2014-15","Forecast 2015-16","Forecast 2016-17"]
[null,"Benchmark Revenue (Rev BBM)",{"$f":"'ACCC data inputs'!B$15*(1+C$31)","v":9721399.8447510861},{"$f":"'ACCC data inputs'!C$15*(1+C$31)*(1+D$31)","v":9828142.4143989403},{"$f":"'ACCC data inputs'!D$15*(1+C$31)*(1+D$31)*(1+E$31)","v":9936057.0350226797}]
[]
[]
[]
[null,"Unders/Overs Adjustment"]
[null,"Calc. of UOM (t-1)","Estimated 2013-14","Estimated 2014-15","Estimated 2015-16"]
[null,"Revenue Requirement",0,{"$f":"C47","v":9721399.8447510861},{"$f":"D47","v":10011585.58319734}]
[null,"Estimated Tariff Revenue",0,{"$f":"C349","v":5412411.0820841547},{"$f":"D349","v":5606487.9265905116}]
[null,"Difference",{"$f":"C14-C13","v":0},{"$f":"D14-D13","v":-4308988.7626669314},{"$f":"E14-E13","v":-4405097.6566068288}]
[]
[]
[null,"Calc. of UOM (t-2)","Actual 2012-13","Actual 2013-14","Actual 2014-15"]
[null,"Estimated Tariff Revenue",0,{"$f":"C14","v":0},{"$f":"D14","v":5412411.0820841547}]
[null,"Actual Tariff Revenue",0,0,{"$f":"C462","v":5412411.0820841547}]
[null,"Difference",{"$f":"C20-C19","v":0},{"$f":"D20-D19","v":0},{"$f":"E20-E19","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"WACC","Actual 2014-15","Actual 2015-16","Actual 2016-17"]
[null,"CPI (t)",{"$f":"'State Water data inputs'!C11","v":2.9296875E-2},{"$f":"'State Water data inputs'!D11","v":0},{"$f":"'State Water data inputs'!E11","v":0}]
[null,"Real Pre Tax WACC",{"$f":"'ACCC data inputs'!B39","v":4.2572208678693269E-2},{"$f":"'ACCC data inputs'!C39","v":4.2572208678693269E-2},{"$f":"'ACCC data inputs'!D39","v":4.2572208678693269E-2}]
[null,"Nominal Pre Tax WACC",{"$f":"(1+C31)*(1+C32)-1","v":7.311631635482696E-2},{"$f":"(1+D31)*(1+D32)-1","v":4.2572208678693269E-2},4.2572208678693269E-2]
[]
[]
[null,"RAB UOM","Actual 2014-15","Actual 2015-16","Actual 2016-17"]
[null,"Opening balance",0,{"$f":"C40","v":0},{"$f":"D40","v":-4308988.7626669314}]
[null,"UOM (t-1)",{"$f":"C15","v":0},{"$f":"D15","v":-4308988.7626669314},{"$f":"E15","v":-4405097.6566068288}]
[null,"UOM (t-2)",0,{"$f":"D21*(1+C$33)","v":0},{"$f":"E21*(1+D$33)","v":0}]
[null,"Closing balance",{"$f":"SUM(C37:C39)","v":0},{"$f":"SUM(D37:D39)","v":-4308988.7626669314},-8714086.4192737602]
[]
[null,"Rev UOM (t)",{"$f":"C40*C$33","v":0},{"$f":"D40*D$33","v":-183443.1687984009},{"$f":"E40*E$33","v":-370977.90548548952}]
[]
[]
[]
[null,"Revenue Requirement","2014-15","2015-16"," 2016-17"]
[null,"Revenue Requirement",{"$f":"(C7-C42)","v":9721399.8447510861},{"$f":"(D7-D42)","v":10011585.58319734},{"$f":"(E7-E42)","v":10307034.94050817}]
[]
[]
[]
[]
[null,"Forecast Tariff Revenue","2014-15","2015-16","2016-17"]
[null,"Revenue Requirement",{"$f":"'Fish River'!C47","v":9721399.8447510861},{"$f":"'Fish River'!D47","v":10011585.58319734},{"$f":"'Fish River'!E47","v":10307034.94050817}]
[]
[]
[]
[null,"Target (%) : 2014-15 to 2016-17",{"$f":"C$110","v":"2014-15"},{"$f":"D$110","v":"2015-16"},{"$f":"E$110","v":"2016-17"}]
[]
[null,"Total Revenue"]
[null,"BULK RAW WATER",{"$f":"SUM(C61:C62)","v":1},{"$f":"SUM(D61:D62)","v":1},{"$f":"SUM(E61:E62)","v":1}]
[null,"BULK FILTERED WATER",{"$f":"'ACCC data inputs'!B33","v":0.8},{"$f":"'ACCC data inputs'!C33","v":0.8},{"$f":"'ACCC data inputs'!D33","v":0.8}]
[null,null,{"$f":"1-C61","v":0.19999999999999996},{"$f":"1-D61","v":0.19999999999999996},{"$f":"1-E61","v":0.19999999999999996}]
[null,"BULK RAW WATER"]
[null,"Usage",{"$f":"'ACCC data inputs'!B35","v":0.45},{"$f":"'ACCC data inputs'!C35","v":0.45},{"$f":"'ACCC data inputs'!D35","v":0.45}]
[null,"Minimum Annual Quantity (MAQ) access charge",{"$f":"1-C64","v":0.55000000000000004},{"$f":"1-D64","v":0.55000000000000004},{"$f":"1-E64","v":0.55000000000000004}]
[]
[null,"BULK FILTERED WATER"]
[null,"Usage",{"$f":"'ACCC data inputs'!B36","v":0.4},{"$f":"'ACCC data inputs'!C36","v":0.4},{"$f":"'ACCC data inputs'!D36","v":0.4}]
[null,"Minimum Annual Quantity (MAQ) access charge",{"$f":"1-C68","v":0.6},{"$f":"1-D68","v":0.6},{"$f":"1-E68","v":0.6}]
[]
[null,"Usage",{"$f":"SUM(C72:C73)","v":0.44000000000000006},{"$f":"SUM(D72:D73)","v":0.44000000000000006},{"$f":"SUM(E72:E73)","v":0.44000000000000006}]
[null,"BULK RAW WATER",{"$f":"C64*C61","v":0.36000000000000004},{"$f":"D64*D61","v":0.36000000000000004},{"$f":"E64*E61","v":0.36000000000000004}]
[null,"BULK FILTERED WATER",{"$f":"C68*C62","v":7.9999999999999988E-2},{"$f":"D68*D62","v":7.9999999999999988E-2},{"$f":"E68*E62","v":7.9999999999999988E-2}]
[]
[null,"Minimum Annual Quantity (MAQ) access charge",{"$f":"SUM(C76:C77)","v":0.56000000000000005},{"$f":"SUM(D76:D77)","v":0.56000000000000005},{"$f":"SUM(E76:E77)","v":0.56000000000000005}]
[null,"BULK RAW WATER",{"$f":"C65*C61","v":0.44000000000000006},{"$f":"D65*D61","v":0.44000000000000006},{"$f":"E65*E61","v":0.44000000000000006}]
[null,"BULK FILTERED WATER",{"$f":"C69*C62","v":0.11999999999999997},{"$f":"D69*D62","v":0.11999999999999997},{"$f":"E69*E62","v":0.11999999999999997}]
[]
[]
[]
[null,"Forecast Revenue Composition",{"$f":"C$110","v":"2014-15"},{"$f":"D$110","v":"2015-16"},{"$f":"E$110","v":"2016-17"}]
[null,"BULK RAW WATER"]
[null,"Minimum Annual Quantity (MAQ) access charge",{"$f":"C72*C$53","v":3499703.9441103912},{"$f":"D72*D$53","v":3604170.8099510428},{"$f":"E72*E$53","v":3710532.5785829416}]
[null,"Usage",{"$f":"C76*C$53","v":4277415.9316904787},{"$f":"D76*D$53","v":4405097.6566068307},{"$f":"E76*E$53","v":4535095.3738235952}]
[null,null,{"$f":"SUM(C83:C84)","v":7777119.8758008704},{"$f":"SUM(D83:D84)","v":8009268.4665578734},{"$f":"SUM(E83:E84)","v":8245627.9524065368}]
[]
[null,"BULK FILTERED WATER"]
[null,"Minimum Annual Quantity (MAQ) access charge",{"$f":"C73*C$53","v":777711.9875800868},{"$f":"D73*D$53","v":800926.84665578709},{"$f":"E73*E$53","v":824562.79524065345}]
[null,"Usage",{"$f":"C77*C$53","v":1166567.9813701301},{"$f":"D77*D$53","v":1201390.2699836805},{"$f":"E77*E$53","v":1236844.1928609801}]
[null,null,{"$f":"SUM(C88:C89)","v":1944279.9689502169},{"$f":"SUM(D88:D89)","v":2002317.1166394674},{"$f":"SUM(E88:E89)","v":2061406.9881016335}]
[]
[null,"Total",{"$f":"SUM(C85,C90)","v":9721399.8447510879},{"$f":"SUM(D85,D90)","v":10011585.58319734},{"$f":"SUM(E85,E90)","v":10307034.94050817}]
[]
[]
[]
[null,"Minimum Annual Quantity (MAQ)  ","2014-15","2015-16","2016-17"]
[null,"BULK RAW WATER"]
[null,"   - Delta Electricity",{"$f":"'ACCC data inputs'!G20","v":8184},{"$f":"'ACCC data inputs'!H20","v":8184},{"$f":"'ACCC data inputs'!I20","v":8184}]
[null,"   - Sydney Catchment Authority",{"$f":"'ACCC data inputs'!G21","v":3650},{"$f":"'ACCC data inputs'!H21","v":3650},{"$f":"'ACCC data inputs'!I21","v":3650}]
[null,"   - Oberon Council",{"$f":"'ACCC data inputs'!G22","v":1064},{"$f":"'ACCC data inputs'!H22","v":1064},{"$f":"'ACCC data inputs'!I22","v":1064}]
[null,"   - Individual Minor Customers",{"$f":"'ACCC data inputs'!G23","v":200},{"$f":"'ACCC data inputs'!H23","v":200},{"$f":"'ACCC data inputs'!I23","v":200}]
[null,"BULK FILTERED WATER"]
[null,"   - Lithgow Council",{"$f":"'ACCC data inputs'!G25","v":1778},{"$f":"'ACCC data inputs'!H25","v":1778},{"$f":"'ACCC data inputs'!I25","v":1778}]
[null,"   - Individual Minor Customers",{"$f":"'ACCC data inputs'!G26","v":200},{"$f":"'ACCC data inputs'!H26","v":200},{"$f":"'ACCC data inputs'!I26","v":200}]
[]
[]
[]
[]
[null,"Forecast Tariff Revenue"]
[null,"Forecast Tariff quantities","2014-15","2015-16","2016-17"]
[null,"BULK RAW WATER"]
[null,"  Number of Minor Customers",{"$f":"'State Water data inputs'!B$87","v":74},{"$f":"'State Water data inputs'!C$87","v":0},{"$f":"'State Water data inputs'!D$87","v":0}]
[]
[null,"  Usage  (ML)"]
[null,"   - Delta Electricity",{"$f":"'State Water data inputs'!B$75","v":6189.8481999999995},{"$f":"'State Water data inputs'!C$75","v":5929.7981999999993},{"$f":"'State Water data inputs'!D$75","v":5615.7482}]
[null,"   - Sydney Catchment Authority",{"$f":"'State Water data inputs'!B$76","v":2411.6287499999999},{"$f":"'State Water data inputs'!C$76","v":2224.8287499999997},{"$f":"'State Water data inputs'!D$76","v":2060.17875}]
[null,"   - Oberon Council",{"$f":"'State Water data inputs'!B$77","v":717.08692000000008},{"$f":"'State Water data inputs'!C$77","v":681.88692000000015},{"$f":"'State Water data inputs'!D$77","v":652.08692000000008}]
[null,"   - Individual Minor Customers",{"$f":"'State Water data inputs'!B$78","v":52.092876230661034},{"$f":"'State Water data inputs'!C$78","v":46.229233473980308},{"$f":"'State Water data inputs'!D$78","v":44.088094233473974}]
[]
[null,"  BULK FILTERED WATER"]
[null,"  Number of Minor Customers",{"$f":"'State Water data inputs'!B$88","v":208},{"$f":"'State Water data inputs'!C$88","v":0},{"$f":"'State Water data inputs'!D$88","v":0}]
[]
[null,"  Usage "]
[null,"   - Lithgow Council",{"$f":"'State Water data inputs'!B$80","v":985.50049999999987},{"$f":"'State Water data inputs'!C$80","v":881.1004999999999},{"$f":"'State Water data inputs'!D$80","v":807.10049999999978}]
[null,"   - Individual Minor Customers",{"$f":"'State Water data inputs'!B$81","v":131.80557665260199},{"$f":"'State Water data inputs'!C$81","v":116.74868495077358},{"$f":"'State Water data inputs'!D$81","v":111.25058368495078}]
[]
[null,"Tariff Revenue"]
[null,"BULK RAW WATER",{"$f":"C$110","v":"2014-15"},{"$f":"D$110","v":"2015-16"},{"$f":"E$110","v":"2016-17"}]
[null,"Raw Water: Major customer Minimum Annual Quantity (MAQ) access charge"]
[null,"Delta "]
[null,"Price $",{"$f":"C84/SUM(C132,C136,C140,C145)","v":0.33125394427935684},{"$f":"D84/SUM(D132,D136,D140,D145)","v":0.34153338940974032},{"$f":"E84/SUM(E132,E136,E140,E145)","v":0.35161229445058112}]
[null,"Quantity (per kL) ",{"$f":"C$98*10^3","v":8184000},{"$f":"D$98*10^3","v":8184000},{"$f":"E$98*10^3","v":8184000}]
[null,"Revenue  $",{"$f":"C131*C132","v":2710982.2799822562},{"$f":"D131*D132","v":2795109.2589293146},{"$f":"E131*E132","v":2877595.0177835557}]
[null,"Sydney Catchment"]
[null,"Price $",{"$f":"C$131","v":0.33125394427935684},{"$f":"D$131","v":0.34153338940974032},{"$f":"E$131","v":0.35161229445058112}]
[null,"Quantity (per kL) ",{"$f":"C$99*10^3","v":3650000},{"$f":"D$99*10^3","v":3650000},{"$f":"E$99*10^3","v":3650000}]
[null,"Revenue  $",{"$f":"C135*C136","v":1209076.8966196524},{"$f":"D135*D136","v":1246596.8713455522},{"$f":"E135*E136","v":1283384.8747446211}]
[null,"Oberon Council"]
[null,"Price $",{"$f":"C$131","v":0.33125394427935684},{"$f":"D$131","v":0.34153338940974032},{"$f":"E$131","v":0.35161229445058112}]
[null,"Quantity (per kL) ",{"$f":"C$100*10^3","v":1064000},{"$f":"D$100*10^3","v":1064000},{"$f":"E$100*10^3","v":1064000}]
[null,"Revenue  $",{"$f":"C139*C140","v":352454.19671323569},{"$f":"D139*D140","v":363391.52633196372},{"$f":"E139*E140","v":374115.48129541829}]
[]
[null,"Raw Water: Individual Minor Customer access charge"]
[null,"Price $ (Annual Service Charge 2014-15 onwards)",{"$f":"C131*C$101","v":66.250788855871363},{"$f":"D131*D$101","v":68.306677881948062},{"$f":"E131*E$101","v":70.322458890116224}]
[null,"Quantity (per unit) ",{"$f":"C$101*C112","v":14800},{"$f":"D$101*D112","v":0},{"$f":"E$101*E112","v":0}]
[null,"Number of Minor Customers",{"$f":"C112","v":74},{"$f":"D112","v":0},{"$f":"E112","v":0}]
[null,"Revenue  $",{"$f":"C144*C146","v":4902.5583753344808},{"$f":"D144*D146","v":0},{"$f":"E144*E146","v":0},null,"Check"]
[null,null,null,null,null,null,{"$f":"C$81","v":"2014-15"},{"$f":"D$81","v":"2015-16"},{"$f":"E$81","v":"2016-17"}]
[null,"Sub total",{"$f":"SUM(C133,C137,C141,C147)","v":4277415.9316904787},{"$f":"SUM(D133,D137,D141,D147)","v":4405097.6566068307},{"$f":"SUM(E133,E137,E141,E147)","v":4535095.3738235952},null,{"$f":"ABS(C149-C$84)","v":0},{"$f":"ABS(D149-D$84)","v":0},{"$f":"ABS(E149-E$84)","v":0},{"$f":"SUM(G149:I149)","v":0}]
[]
[null,"Raw Water:  Usage up to MAQ",{"$f":"C$110","v":"2014-15"},{"$f":"D$110","v":"2015-16"},{"$f":"E$110","v":"2016-17"}]
[null,"Delta "]
[null,"Price $",{"$f":"(C83-C178)/SUM(C154,C158,C162,C167,C172)","v":0.37215646952047915},{"$f":"(D83-D178)/SUM(D154,D158,D162,D167,D172)","v":0.40397227988609374},{"$f":"(E83-E178)/SUM(E154,E158,E162,E167,E172)","v":0.44135041336060254}]
[null,"Quantity (per kL) ",{"$f":"MIN(C115,C$98)*10^3","v":6189848.1999999993},{"$f":"MIN(D115,D$98)*10^3","v":5929798.1999999993},{"$f":"MIN(E115,E$98)*10^3","v":5615748.2000000002}]
[null,"Revenue  $",{"$f":"C153*C154","v":2303592.0529796924},{"$f":"D153*D154","v":2395474.0981184547},{"$f":"E153*E154","v":2478512.78939906}]
[null,"Sydney Catchment"]
[null,"Price $",{"$f":"C$153","v":0.37215646952047915},{"$f":"D$153","v":0.40397227988609374},{"$f":"E$153","v":0.44135041336060254}]
[null,"Quantity (per kL) ",{"$f":"MIN(C116,C$99)*10^3","v":2411628.75},{"$f":"MIN(D116,D$99)*10^3","v":2224828.7499999995},{"$f":"MIN(E116,E$99)*10^3","v":2060178.75}]
[null,"Revenue  $",{"$f":"C157*C158","v":897503.24139408628},{"$f":"D157*D158","v":898769.14249362785},{"$f":"E157*E158","v":909260.74290922948}]
[null,"Oberon Council"]
[null,"Price $",{"$f":"C$153","v":0.37215646952047915},{"$f":"D$153","v":0.40397227988609374},{"$f":"E$153","v":0.44135041336060254}]
[null,"Quantity (per kL) ",{"$f":"MIN(C117,C$100)*10^3","v":717086.92},{"$f":"MIN(D117,D$100)*10^3","v":681886.92000000016},{"$f":"MIN(E117,E$100)*10^3","v":652086.92000000004}]
[null,"Revenue  $",{"$f":"C161*C162","v":266868.53648651426},{"$f":"D161*D162","v":275463.41369690647},{"$f":"E161*E162","v":287798.83168904216}]
[]
[null,"Individual Minor Customer tier 1"]
[null,"Price $",{"$f":"C$153","v":0.37215646952047915},{"$f":"D$153","v":0.40397227988609374},{"$f":"E$153","v":0.44135041336060254}]
[null,"Quantity (per kL) ",{"$f":"C$101*C112","v":14800},{"$f":"D$101*D112","v":0},{"$f":"E$101*E112","v":0}]
[null,"Revenue  $",{"$f":"C166*C167","v":5507.9157489030913},{"$f":"D166*D167","v":0},{"$f":"E166*E167","v":0}]
[]
[null,"Individual Minor Customer tier 2"]
[null,"Price $",{"$f":"C166","v":0.37215646952047915},{"$f":"D166","v":0.40397227988609374},{"$f":"E166","v":0.44135041336060254}]
[null,"Quantity (per unit) ",{"$f":"C118*10^3-C167","v":37292.876230661037},{"$f":"D118*10^3-D167","v":46229.233473980305},{"$f":"E118*10^3-E167","v":44088.094233473974}]
[null,"Revenue  $",{"$f":"C171*C172","v":13878.785156267006},{"$f":"D171*D172","v":18675.328843870346},{"$f":"E171*E172","v":19458.298614224936}]
[]
[null,"Raw Water: Individual Minor Customer access charge in excess of deemed MAQ"]
[null,"Price $",{"$f":"C$131","v":0.33125394427935684},{"$f":"D$131","v":0.34153338940974032},{"$f":"E$131","v":0.35161229445058112}]
[null,"Quantity (per unit) ",{"$f":"C118*10^3-C145","v":37292.876230661037},{"$f":"D118*10^3-D145","v":46229.233473980305},{"$f":"E118*10^3-E145","v":44088.094233473974}]
[null,"Revenue  $",{"$f":"C176*C177","v":12353.412344928342},{"$f":"D176*D177","v":15788.826798182718},{"$f":"E176*E177","v":15501.915971385219}]
[]
[null,"Tier 2 usage charge",{"$f":"SUM(C171,C176)","v":0.70341041379983604},{"$f":"SUM(D171,D176)","v":0.74550566929583406},{"$f":"SUM(E171,E176)","v":0.79296270781118361}]
[null,"Quantity (kL)",{"$f":"C177","v":37292.876230661037},{"$f":"D177","v":46229.233473980305},{"$f":"E177","v":44088.094233473974}]
[null,"Revenue",{"$f":"C180*C181","v":26232.197501195351},{"$f":"D180*D181","v":34464.155642053061},{"$f":"E180*E181","v":34960.214585610149},null,"Check"]
[null,null,null,null,null,null,{"$f":"C$81","v":"2014-15"},{"$f":"D$81","v":"2015-16"},{"$f":"E$81","v":"2016-17"}]
[null,"Sub total",{"$f":"SUM(C155,C159,C163,C168,C182)","v":3499703.9441103912},{"$f":"SUM(D155,D159,D163,D168,D182)","v":3604170.8099510423},{"$f":"SUM(E155,E159,E163,E168,E182)","v":3710532.5785829416},null,{"$f":"ABS(C184-C$83)","v":0},{"$f":"ABS(D184-D$83)","v":4.6566128730773926E-10},{"$f":"ABS(E184-E$83)","v":0},{"$f":"SUM(G184:I184)","v":4.6566128730773926E-10}]
[]
[]
[null,"Total Raw Water Revenue",{"$f":"SUM(C149,C184)","v":7777119.8758008704},{"$f":"SUM(D149,D184)","v":8009268.4665578734},{"$f":"SUM(E149,E184)","v":8245627.9524065368}]
[]
[]
[]
[]
[null,"  BULK FILTERED WATER",{"$f":"C$110","v":"2014-15"},{"$f":"D$110","v":"2015-16"},{"$f":"E$110","v":"2016-17"}]
[null,"Filtered Water: Minimum Annual Quantity (MAQ)"]
[null,"Lithgow Council"]
[null,"Price $",{"$f":"C89/SUM(C196,C200)","v":0.64111232214230052},{"$f":"D89/SUM(D196,D200)","v":0.67569756467023645},{"$f":"E89/SUM(E196,E200)","v":0.69563790374633294}]
[null,"Quantity (per kL) ",{"$f":"C$103*10^3","v":1778000},{"$f":"D$103*10^3","v":1778000},{"$f":"E$103*10^3","v":1778000}]
[null,"Revenue  $",{"$f":"C195*C196","v":1139897.7087690104},{"$f":"D195*D196","v":1201390.2699836805},{"$f":"E195*E196","v":1236844.1928609801}]
[null,"Filtered Water: Individual Minor Customer access charge"]
[null,"Price $ (Annual Service Charge)",{"$f":"C195*C$101","v":128.22246442846011},{"$f":"D195*D$101","v":135.1395129340473},{"$f":"E195*E$101","v":139.1275807492666}]
[null,"Quantity (per kL) ",{"$f":"C$104*C121","v":41600},{"$f":"D$104*D121","v":0},{"$f":"E$104*E121","v":0}]
[null,"Number of Minor Customers",{"$f":"C121","v":208},{"$f":"D121","v":0},{"$f":"E121","v":0}]
[null,"Revenue  $",{"$f":"C199*C201","v":26670.272601119705},{"$f":"D199*D201","v":0},{"$f":"E199*E201","v":0},null,"Check"]
[null,null,null,null,null,null,{"$f":"C$81","v":"2014-15"},{"$f":"D$81","v":"2015-16"},{"$f":"E$81","v":"2016-17"}]
[null,"Sub total",{"$f":"SUM(C197,C202)","v":1166567.9813701301},{"$f":"SUM(D197,D202)","v":1201390.2699836805},{"$f":"SUM(E197,E202)","v":1236844.1928609801},null,{"$f":"ABS(C204-C$89)","v":0},{"$f":"ABS(D204-D$89)","v":0},{"$f":"ABS(E204-E$89)","v":0},{"$f":"SUM(G204:I204)","v":0}]
[]
[null,"Usage up to MAQ",{"$f":"C$110","v":"2014-15"},{"$f":"D$110","v":"2015-16"},{"$f":"E$110","v":"2016-17"}]
[null,"Lithgow Council"]
[null,"Price $",{"$f":"(C88-C223)/SUM(C209,C213,C217)","v":0.64429979922679725},{"$f":"(D88-D223)/SUM(D209,D213,D217)","v":0.72359636651075365},{"$f":"(E88-E223)/SUM(E209,E213,E217)","v":0.8136024290594982}]
[null,"Quantity (per kL) ",{"$f":"MIN(C124,C$103)*10^3","v":985500.49999999988},{"$f":"MIN(D124,D$103)*10^3","v":881100.49999999988},{"$f":"MIN(E124,E$103)*10^3","v":807100.49999999977}]
[null,"Revenue  $",{"$f":"C208*C209","v":634957.77428790822},{"$f":"D208*D209","v":637561.12033080822},{"$f":"E208*E209","v":656658.92729513533}]
[null,"Individual Minor Customer tier 1"]
[null,"Price $",{"$f":"C$208","v":0.64429979922679725},{"$f":"D$208","v":0.72359636651075365},{"$f":"E$208","v":0.8136024290594982}]
[null,"Quantity (per kL) ",{"$f":"C$104*C121","v":41600},{"$f":"D$104*D121","v":0},{"$f":"E$104*E121","v":0}]
[null,"Revenue  $",{"$f":"C212*C213","v":26802.871647834767},{"$f":"D212*D213","v":0},{"$f":"E212*E213","v":0}]
[null,"Individual Minor Customer tier 2"]
[null,"Price $",{"$f":"C212","v":0.64429979922679725},{"$f":"D212","v":0.72359636651075365},{"$f":"E212","v":0.8136024290594982}]
[null,"Quantity (per kL) ",{"$f":"C125*10^3-C213","v":90205.576652601972},{"$f":"D125*10^3-D213","v":116748.68495077358},{"$f":"E125*10^3-E213","v":111250.58368495078}]
[null,"Revenue  $",{"$f":"C216*C217","v":58119.434926408918},{"$f":"D216*D217","v":84478.924225288472},{"$f":"E216*E217","v":90513.745120362932}]
[]
[null,"FIltered Water: Individual Minor Customer access charge in excess of deemed MAQ"]
[null,"Price $",{"$f":"C195","v":0.64111232214230052},{"$f":"D195","v":0.67569756467023645},{"$f":"E195","v":0.69563790374633294}]
[null,"Quantity (per unit) ",{"$f":"C125*10^3-C200","v":90205.576652601972},{"$f":"D125*10^3-D200","v":116748.68495077358},{"$f":"E125*10^3-E200","v":111250.58368495078}]
[null,"Revenue  $",{"$f":"C221*C222","v":57831.906717934937},{"$f":"D221*D222","v":78886.802099690394},{"$f":"E221*E222","v":77390.122825155151}]
[]
[null,"Tier 2 usage charge",{"$f":"SUM(C216,C221)","v":1.2854121213690979},{"$f":"SUM(D216,D221)","v":1.3992939311809902},{"$f":"SUM(E216,E221)","v":1.509240332805831}]
[null,"Quantity (kL)",{"$f":"C222","v":90205.576652601972},{"$f":"D222","v":116748.68495077358},{"$f":"E222","v":111250.58368495078}]
[null,"Revenue",{"$f":"C225*C226","v":115951.34164434386},{"$f":"D225*D226","v":163365.72632497887},{"$f":"E225*E226","v":167903.86794551805},null,"Check"]
[null,null,null,null,null,null,{"$f":"C$81","v":"2014-15"},{"$f":"D$81","v":"2015-16"},{"$f":"E$81","v":"2016-17"}]
[null,"Sub total",{"$f":"SUM(C210,C214,C227)","v":777711.9875800868},{"$f":"SUM(D210,D214,D227)","v":800926.84665578709},{"$f":"SUM(E210,E214,E227)","v":824562.79524065345},null,{"$f":"ABS(C229-C$88)","v":0},{"$f":"ABS(D229-D$88)","v":0},{"$f":"ABS(E229-E$88)","v":0},{"$f":"SUM(G229:I229)","v":0}]
[]
[]
[null,"Total Filtered Water Revenue",{"$f":"SUM(C204,C229)","v":1944279.9689502169},{"$f":"SUM(D204,D229)","v":2002317.1166394674},{"$f":"SUM(E204,E229)","v":2061406.9881016335}]
[]
[null,"Total Forecast Revenue ",{"$f":"SUM(C187,C232)","v":9721399.8447510879},{"$f":"SUM(D187,D232)","v":10011585.58319734},{"$f":"SUM(E187,E232)","v":10307034.94050817}]
[null,"Check",{"$f":"ABS(C234-C53)","v":1.862645149230957E-9},{"$f":"ABS(D234-D53)","v":0},{"$f":"ABS(E234-E53)","v":0}]
[]
[]
[]
[]
[]
[null,"Estimated Tariff Revenue","2014-15","2015-16","2016-17"]
[null,"Estimated Tariff quantities"]
[null,"BULK RAW WATER"]
[null,"  Number of Minor Customers",{"$f":"'State Water data inputs'!F$87","v":0},{"$f":"'State Water data inputs'!G$87","v":0},{"$f":"'State Water data inputs'!H$87","v":0}]
[]
[null,"  Usage  (ML)"]
[null,"   - Delta Electricity",{"$f":"'State Water data inputs'!F$75","v":0},{"$f":"'State Water data inputs'!G$75","v":0},{"$f":"'State Water data inputs'!H$75","v":0}]
[null,"   - Sydney Catchment Authority",{"$f":"'State Water data inputs'!F$76","v":0},{"$f":"'State Water data inputs'!G$76","v":0},{"$f":"'State Water data inputs'!H$76","v":0}]
[null,"   - Oberon Council",{"$f":"'State Water data inputs'!F$77","v":0},{"$f":"'State Water data inputs'!G$77","v":0},{"$f":"'State Water data inputs'!H$77","v":0}]
[null,"   - Individual Minor Customers",{"$f":"'State Water data inputs'!F$78","v":0},{"$f":"'State Water data inputs'!G$78","v":0},{"$f":"'State Water data inputs'!H$78","v":0}]
[]
[null,"  BULK FILTERED WATER"]
[null,"  Number of Minor Customers",{"$f":"'State Water data inputs'!F$88","v":0},{"$f":"'State Water data inputs'!G$88","v":0},{"$f":"'State Water data inputs'!H$88","v":0}]
[]
[null,"  Usage "]
[null,"   - Lithgow Council",{"$f":"'State Water data inputs'!F$80","v":0},{"$f":"'State Water data inputs'!G$80","v":0},{"$f":"'State Water data inputs'!H$80","v":0}]
[null,"   - Individual Minor Customers",{"$f":"'State Water data inputs'!F$81","v":0},{"$f":"'State Water data inputs'!G$81","v":0},{"$f":"'State Water data inputs'!H$81","v":0}]
[]
[]
[null,"Tariff Revenue"]
[null,"BULK RAW WATER"]
[null,"Raw Water: Major customer Minimum Annual Quantity (MAQ) access charge"]
[null,"Delta "]
[null,"Price $",{"$f":"C$131","v":0.33125394427935684},{"$f":"D$131","v":0.34153338940974032},{"$f":"E$131","v":0.35161229445058112}]
[null,"Quantity (per kL) ",{"$f":"C$98*10^3","v":8184000},{"$f":"D$98*10^3","v":8184000},{"$f":"E$98*10^3","v":8184000}]
[null,"Revenue  $",{"$f":"C264*C265","v":2710982.2799822562},{"$f":"D264*D265","v":2795109.2589293146},{"$f":"E264*E265","v":2877595.0177835557}]
[null,"Sydney Catchment"]
[null,"Price $",{"$f":"C$131","v":0.33125394427935684},{"$f":"D$131","v":0.34153338940974032},{"$f":"E$131","v":0.35161229445058112}]
[null,"Quantity (per kL) ",{"$f":"C$99*10^3","v":3650000},{"$f":"D$99*10^3","v":3650000},{"$f":"E$99*10^3","v":3650000}]
[null,"Revenue  $",{"$f":"C268*C269","v":1209076.8966196524},{"$f":"D268*D269","v":1246596.8713455522},{"$f":"E268*E269","v":1283384.8747446211}]
[null,"Oberon Council"]
[null,"Price $",{"$f":"C$131","v":0.33125394427935684},{"$f":"D$131","v":0.34153338940974032},{"$f":"E$131","v":0.35161229445058112}]
[null,"Quantity (per kL) ",{"$f":"C$100*10^3","v":1064000},{"$f":"D$100*10^3","v":1064000},{"$f":"E$100*10^3","v":1064000}]
[null,"Revenue  $",{"$f":"C272*C273","v":352454.19671323569},{"$f":"D272*D273","v":363391.52633196372},{"$f":"E272*E273","v":374115.48129541829}]
[]
[null,"Raw Water: Individual Minor Customer access charge"]
[null,"Price $ (Annual Service Charge 2014-15 onwards)",{"$f":"C264*C$101","v":66.250788855871363},{"$f":"D264*D$101","v":68.306677881948062},{"$f":"E264*E$101","v":70.322458890116224}]
[null,"Quantity (per unit) ",{"$f":"C$101*C244","v":0},{"$f":"D$101*D244","v":0},{"$f":"E$101*E244","v":0}]
[null,"Number of Minor Customers",{"$f":"C244","v":0},{"$f":"D244","v":0},{"$f":"E244","v":0}]
[null,"Revenue  $",{"$f":"C277*C279","v":0},{"$f":"D277*D279","v":0},{"$f":"E277*E279","v":0}]
[]
[null,"Sub total",{"$f":"SUM(C266,C270,C274,C280)","v":4272513.3733151443},{"$f":"SUM(D266,D270,D274,D280)","v":4405097.6566068307},{"$f":"SUM(E266,E270,E274,E280)","v":4535095.3738235952}]
[]
[]
[null,"Raw Water:  Usage",{"$f":"C$110","v":"2014-15"},{"$f":"D$110","v":"2015-16"},{"$f":"E$110","v":"2016-17"}]
[null,"Delta "]
[null,"Price $",{"$f":"C$153","v":0.37215646952047915},{"$f":"D$153","v":0.40397227988609374},{"$f":"E$153","v":0.44135041336060254}]
[null,"Quantity (per kL) ",{"$f":"C247*10^3","v":0},{"$f":"D247*10^3","v":0},{"$f":"E247*10^3","v":0}]
[null,"Revenue  $",{"$f":"C287*C288","v":0},{"$f":"D287*D288","v":0},{"$f":"E287*E288","v":0}]
[null,"Sydney Catchment"]
[null,"Price $",{"$f":"C$153","v":0.37215646952047915},{"$f":"D$153","v":0.40397227988609374},{"$f":"E$153","v":0.44135041336060254}]
[null,"Quantity (per kL) ",{"$f":"C248*10^3","v":0},{"$f":"D248*10^3","v":0},{"$f":"E248*10^3","v":0}]
[null,"Revenue  $",{"$f":"C291*C292","v":0},{"$f":"D291*D292","v":0},{"$f":"E291*E292","v":0}]
[null,"Oberon Council"]
[null,"Price $",{"$f":"C$153","v":0.37215646952047915},{"$f":"D$153","v":0.40397227988609374},{"$f":"E$153","v":0.44135041336060254}]
[null,"Quantity (per kL) ",{"$f":"C249*10^3","v":0},{"$f":"D249*10^3","v":0},{"$f":"E249*10^3","v":0}]
[null,"Revenue  $",{"$f":"C295*C296","v":0},{"$f":"D295*D296","v":0},{"$f":"E295*E296","v":0}]
[]
[null,"Individual Minor Customer tier 1"]
[null,"Price $",{"$f":"C$153","v":0.37215646952047915},{"$f":"D$153","v":0.40397227988609374},{"$f":"E$153","v":0.44135041336060254}]
[null,"Quantity (per kL) ",{"$f":"C$101*C244","v":0},{"$f":"D$101*D244","v":0},{"$f":"E$101*E244","v":0}]
[null,"Revenue  $",{"$f":"C300*C301","v":0},{"$f":"D300*D301","v":0},{"$f":"E300*E301","v":0}]
[]
[null,"Tier 2 usage charge",{"$f":"C$180","v":0.70341041379983604},{"$f":"D$180","v":0.74550566929583406},{"$f":"E$180","v":0.79296270781118361}]
[null,"Quantity (kL)",{"$f":"C250*10^3-C301","v":0},{"$f":"D250*10^3-D301","v":0},{"$f":"E250*10^3-E301","v":0}]
[null,"Revenue",{"$f":"C304*C305","v":0},{"$f":"D304*D305","v":0},{"$f":"E304*E305","v":0}]
[]
[null,"Sub total",{"$f":"SUM(C289,C293,C297,C302,C306)","v":0},{"$f":"SUM(D289,D293,D297,D302,D306)","v":0},{"$f":"SUM(E289,E293,E297,E302,E306)","v":0}]
[]
[]
[null,"Total Raw Water Revenue",{"$f":"SUM(C282,C308)","v":4272513.3733151443},{"$f":"SUM(D282,D308)","v":4405097.6566068307},{"$f":"SUM(E282,E308)","v":4535095.3738235952}]
[]
[]
[]
[null,"  BULK FILTERED WATER",{"$f":"C$110","v":"2014-15"},{"$f":"D$110","v":"2015-16"},{"$f":"E$110","v":"2016-17"}]
[null,"Filtered Water: Minimum Annual Quantity (MAQ)"]
[null,"Lithgow Council"]
[null,"Price $",{"$f":"C$195","v":0.64111232214230052},{"$f":"D$195","v":0.67569756467023645},{"$f":"E$195","v":0.69563790374633294}]
[null,"Quantity (per kL) ",{"$f":"C$103*10^3","v":1778000},{"$f":"D$103*10^3","v":1778000},{"$f":"E$103*10^3","v":1778000}]
[null,"Revenue  $",{"$f":"C318*C319","v":1139897.7087690104},{"$f":"D318*D319","v":1201390.2699836805},{"$f":"E318*E319","v":1236844.1928609801}]
[null,"Filtered Water: Individual Minor Customer access charge"]
[null,"Price $ (Annual Service Charge)",{"$f":"C318*C$101","v":128.22246442846011},{"$f":"D318*D$101","v":135.1395129340473},{"$f":"E318*E$101","v":139.1275807492666}]
[null,"Quantity (per kL) ",{"$f":"C$104*C253","v":0},{"$f":"D$104*D253","v":0},{"$f":"E$104*E253","v":0}]
[null,"Number of Minor Customers",{"$f":"C253","v":0},{"$f":"D253","v":0},{"$f":"E253","v":0}]
[null,"Revenue  $",{"$f":"C322*C324","v":0},{"$f":"D322*D324","v":0},{"$f":"E322*E324","v":0}]
[]
[null,"Sub total",{"$f":"SUM(C320,C325)","v":1139897.7087690104},{"$f":"SUM(D320,D325)","v":1201390.2699836805},{"$f":"SUM(E320,E325)","v":1236844.1928609801}]
[]
[]
[null,"Bulk Filtered Water:  Usage",{"$f":"C$110","v":"2014-15"},{"$f":"D$110","v":"2015-16"},{"$f":"E$110","v":"2016-17"}]
[null,"Lithgow Council"]
[null,"Price $",{"$f":"C$208","v":0.64429979922679725},{"$f":"D$208","v":0.72359636651075365},{"$f":"E$208","v":0.8136024290594982}]
[null,"Quantity (per kL) ",{"$f":"C256*10^3","v":0},{"$f":"D256*10^3","v":0},{"$f":"E256*10^3","v":0}]
[null,"Revenue  $",{"$f":"C332*C333","v":0},{"$f":"D332*D333","v":0},{"$f":"E332*E333","v":0}]
[null,"Individual Minor Customer tier 1"]
[null,"Price $",{"$f":"C$212","v":0.64429979922679725},{"$f":"D$212","v":0.72359636651075365},{"$f":"E$212","v":0.8136024290594982}]
[null,"Quantity (per kL) ",{"$f":"C$104*C253","v":0},{"$f":"D$104*D253","v":0},{"$f":"E$104*E253","v":0}]
[null,"Revenue  $",{"$f":"C336*C337","v":0},{"$f":"D336*D337","v":0},{"$f":"E336*E337","v":0}]
[]
[null,"Tier 2 usage charge",{"$f":"C$225","v":1.2854121213690979},{"$f":"D$225","v":1.3992939311809902},{"$f":"E$225","v":1.509240332805831}]
[null,"Quantity (kL)",{"$f":"C257*10^3-C337","v":0},{"$f":"D257*10^3-D337","v":0},{"$f":"E257*10^3-E337","v":0}]
[null,"Revenue",{"$f":"C340*C341","v":0},{"$f":"D340*D341","v":0},{"$f":"E340*E341","v":0}]
[]
[null,"Sub total",{"$f":"SUM(C334,C338,C342)","v":0},{"$f":"SUM(D334,D338,D342)","v":0},{"$f":"SUM(E334,E338,E342)","v":0}]
[]
[]
[null,"Total Filtered Water Revenue",{"$f":"SUM(C327,C344)","v":1139897.7087690104},{"$f":"SUM(D327,D344)","v":1201390.2699836805},{"$f":"SUM(E327,E344)","v":1236844.1928609801}]
[]
[null,"Total Estimated Revenue ",{"$f":"SUM(C311,C347)","v":5412411.0820841547},{"$f":"SUM(D311,D347)","v":5606487.9265905116},{"$f":"SUM(E311,E347)","v":5771939.5666845758}]
[]
[]
[]
[]
[null,"Actual Tariff Revenue","2014-15","2015-16","2016-17"]
[null,"Actual Tariff quantities"]
[null,"BULK RAW WATER"]
[null,"  Number of Minor Customers",{"$f":"'State Water data inputs'!K$87","v":0},{"$f":"'State Water data inputs'!L$87","v":0},{"$f":"'State Water data inputs'!M$87","v":0}]
[]
[null,"  Usage  (ML)"]
[null,"   - Delta Electricity",{"$f":"'State Water data inputs'!K$75","v":0},{"$f":"'State Water data inputs'!L$75","v":0},{"$f":"'State Water data inputs'!M$75","v":0}]
[null,"   - Sydney Catchment Authority",{"$f":"'State Water data inputs'!K$76","v":0},{"$f":"'State Water data inputs'!L$76","v":0},{"$f":"'State Water data inputs'!M$76","v":0}]
[null,"   - Oberon Council",{"$f":"'State Water data inputs'!K$77","v":0},{"$f":"'State Water data inputs'!L$77","v":0},{"$f":"'State Water data inputs'!M$77","v":0}]
[null,"   - Individual Minor Customers",{"$f":"'State Water data inputs'!K$78","v":0},{"$f":"'State Water data inputs'!L$78","v":0},{"$f":"'State Water data inputs'!M$78","v":0}]
[]
[null,"  BULK FILTERED WATER"]
[null,"  Number of Minor Customers",{"$f":"'State Water data inputs'!K$88","v":0},{"$f":"'State Water data inputs'!L$88","v":0},{"$f":"'State Water data inputs'!M$88","v":0}]
[]
[null,"  Usage "]
[null,"   - Lithgow Council",{"$f":"'State Water data inputs'!K$80","v":0},{"$f":"'State Water data inputs'!L$80","v":0},{"$f":"'State Water data inputs'!M$80","v":0}]
[null,"   - Individual Minor Customers",{"$f":"'State Water data inputs'!K$81","v":0},{"$f":"'State Water data inputs'!L$81","v":0},{"$f":"'State Water data inputs'!M$81","v":0}]
[]
[]
[null,"Tariff Revenue"]
[null,"BULK RAW WATER"]
[null,"Raw Water: Major customer Minimum Annual Quantity (MAQ) access charge"]
[null,"Delta "]
[null,"Price $",{"$f":"C$131","v":0.33125394427935684},{"$f":"D$131","v":0.34153338940974032},{"$f":"E$131","v":0.35161229445058112}]
[null,"Quantity (per kL) ",{"$f":"C$98*10^3","v":8184000},{"$f":"D$98*10^3","v":8184000},{"$f":"E$98*10^3","v":8184000}]
[null,"Revenue  $",{"$f":"C377*C378","v":2710982.2799822562},{"$f":"D377*D378","v":2795109.2589293146},{"$f":"E377*E378","v":2877595.0177835557}]
[null,"Sydney Catchment"]
[null,"Price $",{"$f":"C$131","v":0.33125394427935684},{"$f":"D$131","v":0.34153338940974032},{"$f":"E$131","v":0.35161229445058112}]
[null,"Quantity (per kL) ",{"$f":"C$99*10^3","v":3650000},{"$f":"D$99*10^3","v":3650000},{"$f":"E$99*10^3","v":3650000}]
[null,"Revenue  $",{"$f":"C381*C382","v":1209076.8966196524},{"$f":"D381*D382","v":1246596.8713455522},{"$f":"E381*E382","v":1283384.8747446211}]
[null,"Oberon Council"]
[null,"Price $",{"$f":"C$131","v":0.33125394427935684},{"$f":"D$131","v":0.34153338940974032},{"$f":"E$131","v":0.35161229445058112}]
[null,"Quantity (per kL) ",{"$f":"C$100*10^3","v":1064000},{"$f":"D$100*10^3","v":1064000},{"$f":"E$100*10^3","v":1064000}]
[null,"Revenue  $",{"$f":"C385*C386","v":352454.19671323569},{"$f":"D385*D386","v":363391.52633196372},{"$f":"E385*E386","v":374115.48129541829}]
[]
[null,"Raw Water: Individual Minor Customer access charge"]
[null,"Price $ (Annual Service Charge 2014-15 onwards)",{"$f":"C377*C$101","v":66.250788855871363},{"$f":"D377*D$101","v":68.306677881948062},{"$f":"E377*E$101","v":70.322458890116224}]
[null,"Quantity (per unit) ",{"$f":"C$101*C357","v":0},{"$f":"D$101*D357","v":0},{"$f":"E$101*E357","v":0}]
[null,"Number of Minor Customers",{"$f":"C357","v":0},{"$f":"D357","v":0},{"$f":"E357","v":0}]
[null,"Revenue  $",{"$f":"C390*C392","v":0},{"$f":"D390*D392","v":0},{"$f":"E390*E392","v":0}]
[]
[null,"Sub total",{"$f":"SUM(C379,C383,C387,C393)","v":4272513.3733151443},{"$f":"SUM(D379,D383,D387,D393)","v":4405097.6566068307},{"$f":"SUM(E379,E383,E387,E393)","v":4535095.3738235952}]
[]
[]
[null,"Raw Water:  Usage",{"$f":"C$110","v":"2014-15"},{"$f":"D$110","v":"2015-16"},{"$f":"E$110","v":"2016-17"}]
[null,"Delta "]
[null,"Price $",{"$f":"C$153","v":0.37215646952047915},{"$f":"D$153","v":0.40397227988609374},{"$f":"E$153","v":0.44135041336060254}]
[null,"Quantity (per kL) ",{"$f":"C360*10^3","v":0},{"$f":"D360*10^3","v":0},{"$f":"E360*10^3","v":0}]
[null,"Revenue  $",{"$f":"C400*C401","v":0},{"$f":"D400*D401","v":0},{"$f":"E400*E401","v":0}]
[null,"Sydney Catchment"]
[null,"Price $",{"$f":"C$153","v":0.37215646952047915},{"$f":"D$153","v":0.40397227988609374},{"$f":"E$153","v":0.44135041336060254}]
[null,"Quantity (per kL) ",{"$f":"C361*10^3","v":0},{"$f":"D361*10^3","v":0},{"$f":"E361*10^3","v":0}]
[null,"Revenue  $",{"$f":"C404*C405","v":0},{"$f":"D404*D405","v":0},{"$f":"E404*E405","v":0}]
[null,"Oberon Council"]
[null,"Price $",{"$f":"C$153","v":0.37215646952047915},{"$f":"D$153","v":0.40397227988609374},{"$f":"E$153","v":0.44135041336060254}]
[null,"Quantity (per kL) ",{"$f":"C362*10^3","v":0},{"$f":"D362*10^3","v":0},{"$f":"E362*10^3","v":0}]
[null,"Revenue  $",{"$f":"C408*C409","v":0},{"$f":"D408*D409","v":0},{"$f":"E408*E409","v":0}]
[]
[null,"Individual Minor Customer tier 1"]
[null,"Price $",{"$f":"C$153","v":0.37215646952047915},{"$f":"D$153","v":0.40397227988609374},{"$f":"E$153","v":0.44135041336060254}]
[null,"Quantity (per kL) ",{"$f":"C$101*C357","v":0},{"$f":"D$101*D357","v":0},{"$f":"E$101*E357","v":0}]
[null,"Revenue  $",{"$f":"C413*C414","v":0},{"$f":"D413*D414","v":0},{"$f":"E413*E414","v":0}]
[]
[null,"Tier 2 usage charge",{"$f":"C$180","v":0.70341041379983604},{"$f":"D$180","v":0.74550566929583406},{"$f":"E$180","v":0.79296270781118361}]
[null,"Quantity (kL)",{"$f":"C363*10^3-C414","v":0},{"$f":"D363*10^3-D414","v":0},{"$f":"E363*10^3-E414","v":0}]
[null,"Revenue",{"$f":"C417*C418","v":0},{"$f":"D417*D418","v":0},{"$f":"E417*E418","v":0}]
[]
[null,"Sub total",{"$f":"SUM(C402,C406,C410,C415,C419)","v":0},{"$f":"SUM(D402,D406,D410,D415,D419)","v":0},{"$f":"SUM(E402,E406,E410,E415,E419)","v":0}]
[]
[]
[null,"Total Raw Water Revenue",{"$f":"SUM(C395,C421)","v":4272513.3733151443},{"$f":"SUM(D395,D421)","v":4405097.6566068307},{"$f":"SUM(E395,E421)","v":4535095.3738235952}]
[]
[]
[]
[null,"  BULK FILTERED WATER",{"$f":"C$110","v":"2014-15"},{"$f":"D$110","v":"2015-16"},{"$f":"E$110","v":"2016-17"}]
[null,"Filtered Water: Minimum Annual Quantity (MAQ)"]
[null,"Lithgow Council"]
[null,"Price $",{"$f":"C$195","v":0.64111232214230052},{"$f":"D$195","v":0.67569756467023645},{"$f":"E$195","v":0.69563790374633294}]
[null,"Quantity (per kL) ",{"$f":"C$103*10^3","v":1778000},{"$f":"D$103*10^3","v":1778000},{"$f":"E$103*10^3","v":1778000}]
[null,"Revenue  $",{"$f":"C431*C432","v":1139897.7087690104},{"$f":"D431*D432","v":1201390.2699836805},{"$f":"E431*E432","v":1236844.1928609801}]
[null,"Filtered Water: Individual Minor Customer access charge"]
[null,"Price $ (Annual Service Charge)",{"$f":"C431*C$101","v":128.22246442846011},{"$f":"D431*D$101","v":135.1395129340473},{"$f":"E431*E$101","v":139.1275807492666}]
[null,"Quantity (per kL) ",{"$f":"C$104*C366","v":0},{"$f":"D$104*D366","v":0},{"$f":"E$104*E366","v":0}]
[null,"Number of Minor Customers",{"$f":"C366","v":0},{"$f":"D366","v":0},{"$f":"E366","v":0}]
[null,"Revenue  $",{"$f":"C435*C437","v":0},{"$f":"D435*D437","v":0},{"$f":"E435*E437","v":0}]
[]
[null,"Sub total",{"$f":"SUM(C433,C438)","v":1139897.7087690104},{"$f":"SUM(D433,D438)","v":1201390.2699836805},{"$f":"SUM(E433,E438)","v":1236844.1928609801}]
[]
[]
[null,"Bulk Filtered Water:  Usage",{"$f":"C$110","v":"2014-15"},{"$f":"D$110","v":"2015-16"},{"$f":"E$110","v":"2016-17"}]
[null,"Lithgow Council"]
[null,"Price $",{"$f":"C$208","v":0.64429979922679725},{"$f":"D$208","v":0.72359636651075365},{"$f":"E$208","v":0.8136024290594982}]
[null,"Quantity (per kL) ",{"$f":"C369*10^3","v":0},{"$f":"D369*10^3","v":0},{"$f":"E369*10^3","v":0}]
[null,"Revenue  $",{"$f":"C445*C446","v":0},{"$f":"D445*D446","v":0},{"$f":"E445*E446","v":0}]
[null,"Individual Minor Customer tier 1"]
[null,"Price $",{"$f":"C$212","v":0.64429979922679725},{"$f":"D$212","v":0.72359636651075365},{"$f":"E$212","v":0.8136024290594982}]
[null,"Quantity (per kL) ",{"$f":"C$104*C366","v":0},{"$f":"D$104*D366","v":0},{"$f":"E$104*E366","v":0}]
[null,"Revenue  $",{"$f":"C449*C450","v":0},{"$f":"D449*D450","v":0},{"$f":"E449*E450","v":0}]
[]
[null,"Tier 2 usage charge",{"$f":"C$225","v":1.2854121213690979},{"$f":"D$225","v":1.3992939311809902},{"$f":"E$225","v":1.509240332805831}]
[null,"Quantity (kL)",{"$f":"C370*10^3-C450","v":0},{"$f":"D370*10^3-D450","v":0},{"$f":"E370*10^3-E450","v":0}]
[null,"Revenue",{"$f":"C453*C454","v":0},{"$f":"D453*D454","v":0},{"$f":"E453*E454","v":0}]
[]
[null,"Sub total",{"$f":"SUM(C447,C451,C455)","v":0},{"$f":"SUM(D447,D451,D455)","v":0},{"$f":"SUM(E447,E451,E455)","v":0}]
[]
[]
[null,"Total Filtered Water Revenue",{"$f":"SUM(C440,C457)","v":1139897.7087690104},{"$f":"SUM(D440,D457)","v":1201390.2699836805},{"$f":"SUM(E440,E457)","v":1236844.1928609801}]
[]
[null,"Total Actual Revenue ",{"$f":"SUM(C424,C460)","v":5412411.0820841547},{"$f":"SUM(D424,D460)","v":5606487.9265905116},{"$f":"SUM(E424,E460)","v":5771939.5666845758}]