{"text_format":"1","workbook":"xlsx","n_sheets":31,"sheets":["Cover Page","Introduction","Southern MDB Correlations","SA Murray - Class 3a","Vic Murray AboveBC - High Rel","Vic Murray AboveBC - Low Rel","Vic Murray BelowBC - High Rel","Vic Murray BelowBC - Low Rel","Goulburn - High Reliability","Goulburn - Low Reliability","Campaspe - High Reliability","Loddon - High Reliability","NSW Murray - General Security","NSW Murray - High Security","NSW Murray Irrigation - Gen Sec","Murrumbidgee - General Sec","Murrumbidgee - High Sec","Lower Darling - General Sec","Lower Darling - High Sec","Northern MDB Correlations","Macquarie - General Security","Namoi - General Security","Gwydir - General Security","NSW Border Rivers - General Sec","Barwon Darling - Unregulated","Lachlan - General Security","QLD - Trade Summary","QLD - Condamine Balonne","QLD - Border Rivers","Appendix A","Appendix B"],"not_rendered":{"charts":52,"images":2,"macros":1,"external_links":2,"defined_names":231,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover Page","index":0,"n_rows":27,"n_cols":2,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Water entitlement market prices"]
[null,"Murray–Darling Basin"]
[null,"(November 2016)"]
[null,"Prepared for Australian Government Department of Agriculture and Water Resources"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Marsden Jacob Associates"]
[null,"Financial & Economic Consultants"]
[null,"ABN 66 663 324 657"]
[null,"ACN 072 233 204"]
[null,"Internet: http://www.marsdenjacob.com.au"]
[null,"E-mail: economists@marsdenjacob.com.au"]
[]
[]
[null,"This product has been prepared in accordance with the scope of services described in the contract or agreement between Marsden Jacob Associates Pty Ltd ACN 072 233 204 (MJA) and the Client. Any findings, conclusions or recommendations only apply to the aforementioned circumstances and no greater reliance should be assumed or drawn by the Client. Furthermore, the report has been prepared solely for use by the Client and Marsden Jacob Associates accepts no responsibility for its use by other parties."]
[]
[]
[null,"Copyright © Marsden Jacob Associates Pty Ltd 2016"]

{"sheet":"Introduction","index":1,"n_rows":82,"n_cols":3,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Introduction"]
[null,"This November 2016 monthly water entitlement market prices report has been prepared by Marsden Jacob Associates (Marsden Jacob) for the Australian Government Department of Agriculture and Water Resources."]
[]
[null,"A water access entitlement is a perpetual or ongoing entitlement to exclusive access to a share of water from a specified consumptive pool, as defined in the relevant water plan."]
[]
[null,"The report includes:"]
[null,"§  southern Murray–Darling Basin (MDB) market activity and price information, by region and entitlement type"]
[null,"§  northern MDB market activity and price information, by region and entitlement type"]
[null,"§  a list of catchments and water sources"]
[null,"§  a list of data outliers removed from the trade data"]
[]
[null,"Regions, entitlements and key statistics"]
[null,"The entitlement price report is broadly split into the southern and the northern MDB, as detailed in Table 1 and Table 2. Interactive maps showing the location of these trading regions are available on the Murray–Darling Basin Authority's website. "]
[]
[null,"The water sources included in each of the regions are listed in Appendix A."]
[]
[null,"Table 1: Regions and entitlement types, southern MDB"]
[null,"Region","Entitlement type"]
[null,"SA Murray","Class 3a"]
[null,"Vic. Murray above Barmah Choke","High reliability"]
[null,"Vic. Murray above Barmah Choke","Low reliability"]
[null,"Vic. Murray below Barmah Choke","High reliability"]
[null,"Vic. Murray below Barmah Choke","Low reliability"]
[null,"Goulburn","High reliability"]
[null,"Goulburn","Low reliability"]
[null,"Campaspe","High reliability"]
[null,"Loddon","High reliability"]
[null,"NSW Murray","General security"]
[null,"NSW Murray","High security"]
[null,"NSW Murray Irrigation Limited","General security"]
[null,"Murrumbidgee","General security"]
[null,"Murrumbidgee","High security"]
[null,"Lower Darling","General security"]
[null,"Lower Darling","High security"]
[]
[null,"Table 2: Regions and entitlement types, northern MDB"]
[null,"Region","Entitlement type"]
[null,"Macquarie","General security"]
[null,"Namoi","General security"]
[null,"Gwydir","General security"]
[null,"NSW Border Rivers","General security"]
[null,"Barwon–Darling","Unregulated"]
[null,"Lachlan","General security"]
[null,"Condamine–Balonne (St George)","Supplemented"]
[null,"Condamine–Balonne (Upper Condamine and Lower Balonne)","Unsupplemented"]
[null,"Central Condamine Alluvium Groundwater (1, 2, 3 and 4)","Groundwater (sub areas 1, 2, 3 and 4)"]
[null,"Upper Condamine Alluvium Groundwater (Dalrymple Creek)","Groundwater"]
[null,"Upper Condamine Alluvium Groundwater (Oakey Creek)","Groundwater"]
[null,"Qld Border Rivers","Supplemented"]
[null,"Qld Border Rivers","Unsupplemented"]
[null,"Lower Balonne","Overland flow"]
[]
[]
[null,"As requested by the department, for each of the regions and water entitlement categories Marsden Jacob reports a range of measures, subject to data availability and the number of trades:"]
[null,"§  volume weighted average price (VWAP)"]
[null,"§  median price"]
[null,"§  mean price"]
[null,"§  mode price"]
[null,"§  25th and 75th percentile prices"]
[null,"§  price quintiles"]
[null,"§  trade volume"]
[null,"§  number of trades"]
[null,"§  water trading exchange prices."]
[]
[null,"Data sources"]
[null,"The data sources for this report are:"]
[null,"§  National Water Market Register data, up to 31 December 2013"]
[null,"§  state government water registers and websites"]
[null,"§  water exchange and broker noticeboard prices."]
[]
[null,"Notes"]
[null,"Entitlement prices in the state government water registers can lag the exchange date of contracts or water sale agreements by periods of days to several months. This means the entitlement prices shown in the monthly and quarterly VWAPs may not reflect all exchanges during the month."]
[]
[null,"Entitlement prices that do not appear to reflect arm’s-length transactions have been excluded in the data cleaning process (see Appendix B). "]
[null,"Removing these values reduces price distortions in the reporting. This means prices in this report may differ from prices shown in registers where these transactions have not been removed."]
[]
[null,"Marsden Jacob uses a two-stage process to clean the data:"]
[null,"1.      Removing prices that may not be genuine; for example, removing transactions where the price was reported to be null ($0 per ML)"]
[null,"2.      Reviewing and potentially removing transactions outside two standard deviations from the average price of water entitlements by region (or trading zone) and by water product."]
[]
[null,"Marsden Jacob does not necessarily remove all trades that fall outside two standard deviations, as some of them reflect arm’s-length trades. If trades that fall outside two standard deviations are retained in the regional dataset, this is noted in the region and entitlement-specific reports. Also, trades that fall within two standard deviations but are removed because they are not considered representative on the basis of recent data trends are also noted in the region and entitlement-specific reports as well as Appendix B."]

{"sheet":"Southern MDB Correlations","index":2,"n_rows":66,"n_cols":2,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Southern Murray–Darling Basin"]
[]
[null,"Price correlations in the southern MDB, high security, high reliability, Class 3a, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Price correlations in the southern MDB, general security, low reliability, October 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Source: Marsden Jacob analysis, 2016."]

{"sheet":"SA Murray - Class 3a","index":3,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"Southern Australian Murray: Class 3a"]
[]
[null,"Entitlement market prices and volumes, SA Murray, Class 3a, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, SA Murray, Class 3a"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,2502.3965494487034,2074.3129816895334,2629.3779770648889,1875,2875,2775,2496.875,1875,333.39600000000002,8,"2 500 - 3 000"]
[]
[null,"Entitlement market price range, SA Murray, Class 3a, by volume month November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: One trade which is outside two standard deviations of the average price of water entitlements has been included for this region."]

{"sheet":"Vic Murray AboveBC - High Rel","index":4,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"Victorian Murray above Barmah Choke: high reliability"]
[]
[null,"Entitlement market prices and volumes, Vic. Murray above Barmah Choke, high reliability, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Vic. Murray above Barmah Choke, high reliability"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,2470.8250522960457,2567.0045453364178,2527.785377644514,2355.2600000000002,2600,2400,2453.5914285714284,2500,1003.8999999999999,21,"2 300 - 2 650"]
[]
[null,"Entitlement market price range, Vic. Murray above Barmah Choke, high reliability, by volume month November 2016"]

{"sheet":"Vic Murray AboveBC - Low Rel","index":5,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"Victorian Murray above Barmah Choke: low reliability"]
[]
[null,"Entitlement market prices and volumes, Vic. Murray above Barmah Choke, low reliability, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Vic. Murray above Barmah Choke, low reliability"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,244.42102343641662,241.49647490586722,232.82396637694873,242.5,250,250,245,250,721.09999999999991,6,"225 - 275"]
[]
[null,"Entitlement market price range, Vic. Murray above Barmah Choke, low reliability, by volume month November 2016"]

{"sheet":"Vic Murray BelowBC - High Rel","index":6,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"Victorian Murray below Barmah Choke: high reliability"]
[]
[null,"Entitlement market prices and volumes, Vic. Murray below Barmah Choke, high reliability, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Vic. Murray below Barmah Choke, high reliability"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,2836.9803726022747,2903.0628080532701,2792.5659177972725,2500,2837.5,2800,2630.906274509804,2800,2356.4,51,"2 500 - 3 000"]
[]
[null,"Entitlement market price range, Vic. Murray below Barmah Choke, high reliability, by volume month November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: One trade which is inside two standard deviations of the average price of water entitlements has been excluded for this region."]

{"sheet":"Vic Murray BelowBC - Low Rel","index":7,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"Victorian Murray below Barmah Choke: low reliability"]
[]
[null,"Entitlement market prices and volumes, Vic. Murray below Barmah Choke, low reliability, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Vic. Murray below Barmah Choke, low reliability"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,247.65870704717531,250.49074626865672,268.7033285993254,250,250,250,244,250,343.4,5,"240 - 275"]
[]
[null,"Entitlement market price range, Vic. Murray below Barmah Choke, low reliability, by volume month November 2016"]

{"sheet":"Goulburn - High Reliability","index":8,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"Goulburn: high reliability"]
[]
[null,"Entitlement market prices and volumes, Goulburn, high reliability, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Goulburn, high reliability"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,2520.9587532119317,2645.447869563413,2716.413637568231,2363.8900000000003,2600,2500,2498.681525423729,2500,3580.4,59,"2 400 - 2 700"]
[]
[null,"Entitlement market price range, Goulburn, high reliability, by volume month November 2016"]

{"sheet":"Goulburn - Low Reliability","index":9,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"Goulburn: low reliability"]
[]
[null,"Entitlement market prices and volumes, Goulburn, low reliability, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Goulburn, low reliability"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,244.04350303984612,238.49342206398981,230.67907895352207,220,250,250,238.26333333333332,250,2286.2999999999997,24,"230 - 275"]
[]
[null,"Entitlement market price range, Goulburn, low reliability, by volume month November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: One trade which is outside two standard deviations of the average price of water entitlements has been included for this region."]

{"sheet":"Campaspe - High Reliability","index":10,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"Campaspe: high reliability"]
[]
[null,"Entitlement market prices and volumes, Campaspe, high reliability, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Campaspe, high reliability"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,2016.1290322580646,2232.1428571428573,2282.0332072617243,2125,2375,2250,2250,0,62,2,"2 400 - 2 800"]
[]
[null,"Entitlement market price range, Campaspe, high reliability, by volume month November 2016"]

{"sheet":"Loddon - High Reliability","index":11,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"Loddon: high reliability"]
[]
[null,"Entitlement market prices and volumes, Loddon, high reliability, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Loddon, high reliability"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,"-","-",1520,"-","-","-","-","-","-","-","No listings"]
[]
[null,"Entitlement market price range, Loddon, high reliability, by volume month November 2016"]

{"sheet":"NSW Murray - General Security","index":12,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"New South Wales Murray: general security"]
[]
[null,"Entitlement market prices and volumes, NSW Murray, general security, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, NSW Murray, general security"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,1160.8150470219437,1190.0846999436837,1154.8331388958077,1150,1200,1175,1183.3333333333333,1150,957,6,"1 100 - 1 300"]
[]
[null,"Entitlement market price range, NSW Murray, general security, by volume month November 2016"]

{"sheet":"NSW Murray - High Security","index":13,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"New South Wales Murray: high security"]
[]
[null,"Entitlement market prices and volumes, NSW Murray, high security, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, NSW Murray, high security"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,3491.9308357348705,3387.3700351846601,3165.5925073458338,3400,3600,3500,3507.1428571428573,3400,694,7,"3 100 - 3 400"]
[]
[null,"Entitlement market price range, NSW Murray, high security, by volume month November 2016"]

{"sheet":"NSW Murray Irrigation - Gen Sec","index":14,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"New South Wales Murray Irrigation Limited"]
[]
[null,"Entitlement market prices and volumes, NSW Murray Irrigation Limited, general security, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, NSW Murray Irrigation Limited, general security"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,1216.4369034994697,1220.1567310383432,1125.3417270729674,1200,1250,1250,1225,1250,943,7,"1 100 - 1 300"]
[]
[null,"Entitlement market price range, NSW Murray Irrigation Limited, general security, by volume month November 2016"]

{"sheet":"Murrumbidgee - General Sec","index":15,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"Murrumbidgee: general security"]
[]
[null,"Entitlement market prices and volumes, Murrumbidgee, general security, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Murrumbidgee, general security"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,1550,1336.3127482845794,1411.6853841145833,1550,1550,1550,1550,0,833,1,"1 500 - 1 550"]
[]
[null,"Entitlement market price range, Murrumbidgee, general security, by volume month November 2016"]

{"sheet":"Murrumbidgee - High Sec","index":16,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"Murrumbidgee: high security"]
[]
[null,"Entitlement market prices and volumes, Murrumbidgee, high security, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Murrumbidgee, high security"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,3250,3250,3441.8787485816179,3250,3250,3250,3250,"-",3,1,"3 500 - 3 750"]
[]
[null,"Entitlement market price range, Murrumbidgee, high security, by volume month November 2016"]

{"sheet":"Lower Darling - General Sec","index":17,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"Lower Darling: general security"]
[]
[null,"Entitlement market prices and volumes, Lower Darling, general security, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Lower Darling, general security"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,"-","-","-","-","-","-","-","-","-","-","No listings"]
[]
[null,"Entitlement market price range, Lower Darling, general security, by volume month November 2016"]

{"sheet":"Lower Darling - High Sec","index":18,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"Lower Darling: high security"]
[]
[null,"Entitlement market prices and volumes, Lower Darling, high security, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Lower Darling, high security"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,"-","-",1649.5283018867924,"-","-","-","-","-","-","-","No listings"]
[]
[null,"Entitlement market price range,Lower Darling, high security, by volume month November 2016"]

{"sheet":"Northern MDB Correlations","index":19,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Northern Murray–Darling Basin"]
[]
[null,"Price correlations in the northern MDB, general security, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Source: Marsden Jacob analysis, 2016."]

{"sheet":"Macquarie - General Security","index":20,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"Macquarie: general security"]
[]
[null,"Entitlement market prices and volumes, Macquarie, general security, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Macquarie, general security"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,928.18181818181813,952.40193918025557,942.11874999999998,925,950,950,933.33333333333337,950,1100,3,"950 - 1 250"]
[]
[null,"Entitlement market price range, Macquarie, general security, by volume month November 2016"]

{"sheet":"Namoi - General Security","index":21,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"Namoi: general security"]
[]
[null,"Entitlement market prices and volumes,Namoi, general security, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Namoi, general security"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,2100,2017.2449035063876,1991.8997915835218,2100,2100,2100,2100,2100,3454.5,3,"1 950 - 2 100"]
[]
[null,"Entitlement market price range, Namoi, general security, by volume month November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: Three trades which are outside two standard deviations of the average price of water entitlements have been included for this region."]

{"sheet":"Gwydir - General Security","index":22,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"Gwydir: general security"]
[]
[null,"Entitlement market prices and volumes, Gwydir, general security, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Gwydir, general security"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,"-",2211.9645440333506,2214.555551012063,"-","-","-","-","-","-","-","2 000 - 2 300"]
[]
[null,"Entitlement market price range, Gwydir, general security, by volume month November 2016"]

{"sheet":"NSW Border Rivers - General Sec","index":23,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"New South Wales Border Rivers: general security"]
[]
[null,"Entitlement market prices and volumes, NSW Border Rivers, general security, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, NSW Border Rivers, general security"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,3300,2124.1116109422492,2252.4114717626926,3300,3300,3300,3300,"-",30,1,"2 000 - 2 500"]
[]
[null,"Entitlement market price range, NSW Border Rivers, general security, by volume month November 2016"]

{"sheet":"Barwon Darling - Unregulated","index":24,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"Barwon–Darling: unregulated"]
[]
[null,"Entitlement market prices and volumes, Barwon–Darling, unregulated, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Barwon–Darling, unregulated"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,"-","-",1102,"-","-","-","-","-","-","-","No listing"]
[]
[null,"Entitlement market price range, Barwon–Darling, unregulated, by volume month November 2016"]

{"sheet":"Lachlan - General Security","index":25,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,8],[21,9,22,9],[21,10,22,10],[21,11,22,11]]}
[]
[null,"Lachlan: General security"]
[]
[null,"Entitlement market prices and volumes, Lachlan, general security, September 2009 to November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Lachlan, general security"]
[null,"Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,424.48644880174299,462.36621064060807,467.78690944403979,452.74250000000001,600,542.5,510.24250000000001,600,1377,4,"400 - 600"]
[]
[null,"Entitlement market price range, Lachlan, general security, by volume month November 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: Two trades which are outside two standard deviations of the average price of water entitlements have been included for this region."]

{"sheet":"QLD - Trade Summary","index":26,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,12,5,12],[4,13,5,13],[4,14,5,14],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,4,6],[4,7,4,11]]}
[]
[null,"Queensland: Trade Summary"]
[]
[null,"Entitlement market prices and volumes, Lachlan, general security"]
[null,"Resource Operation Plan","Water Supply Scheme / Water Management Area","Type of Entitlement","Volume weighted average price ($/ML)",null,null,"November 2016 (in $/ML)",null,null,null,null,"November 2016 Volume","November 2016 # of trades","Broker buy/sell range ($/ML)"]
[null,null,null,null,"Month of November 2016","November 2016 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,"QLD Border Rivers","Border Rivers/ Macintyre Brook","Supplemented","-",1600,498,"-","-","-","-","-","-","-","No listings"]
[null,"QLD Border Rivers","Border Rivers","Unsupplemented","-",1800,1777,"-","-","-","-","-","-","-","No listings"]
[null,"Condamine-Balonne","St. George / Upper Condamine","Supplemented","-",1098,1346,"-","-","-","-","-","-","-","No listings"]
[null,"Condamine-Balonne","Condamine Balonne / Lower Balonne / Upper Condamine","Unsupplemented","-",1600,1393,"-","-","-","-","-","-","-","No listings"]
[null,"Condamine-Balonne","Upper Condamine","Alluvium Ground-water","-","-","-","-","-","-","-","-","-","-","No listings"]
[null,"Condamine-Balonne","Lower Balonne","Overland Flow","-","-","-","-","-","-","-","-","-","-","No listings"]

{"sheet":"QLD - Condamine Balonne","index":27,"n_rows":60,"n_cols":2,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Condamine Balonne: Supplemented"]
[]
[null,"Entitlement market prices and volumes, Condamine_Balonne - Supplemented, September 2009 to October 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: No trades have been reported for Queensland. Charts show the monthly trade volume and value until the end of October."]
[]
[null,"Condamine Balonne: Unsupplemented"]
[]
[null,"Entitlement market prices and volumes, Condamine_Balonne - Unsupplemented, September 2009 to October 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: No trades have been reported for Queensland. Charts show the monthly trade volume and value until the end of October."]
[]
[null,"Condamine Balonne: Alluvium Groundwater"]
[]
[null,"Entitlement market prices and volumes, Condamine_Balonne - Alluvium Groundwater, September 2009 to October 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: No trades have been reported for Queensland. Charts show the monthly trade volume and value until the end of October."]

{"sheet":"QLD - Border Rivers","index":28,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"QLD Border Rivers: Supplemented"]
[]
[null,"Entitlement market prices and volumes, QLD_Border_Rivers - Supplemented, September 2009 to October 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: No trades have been reported for Queensland. Charts show the monthly trade volume and value until the end of October."]
[]
[null,"QLD Border Rivers: Unsupplemented"]
[]
[null,"Entitlement market prices and volumes, QLD_Border_Rivers - Unsupplemented, September 2009 to October 2016"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: No trades have been reported for Queensland. Charts show the monthly trade volume and value until the end of October."]

{"sheet":"Appendix A","index":29,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,"Appendix A: Regions and water sources"]
[null,"Table A1 Water sources (southern MDB)"]
[null,"Region","Water source"]
[null,"SA Murray","River Murray Prescribed Water Course (Class 3a)"]
[null,"Vic. Murray above Barmah Choke","6 Vic. Murray Dart to Barmah"]
[null,"Vic. Murray below Barmah Choke","7 Vic. Murray Barmah to SA "]
[null,null,"6B Lower Broken Creek"]
[null,"Goulburn","1A Greater Goulburn "]
[null,null,"1B Boort"]
[null,null,"3 Lower Goulburn"]
[null,"Campaspe","4A Campaspe Eppalock to WWC "]
[null,null,"4C Lower Campaspe"]
[null,"Loddon","5A Loddon–Coliban Channel to Lower Weir Pool (now 5A Loddon – CC/Tull to LWP)"]
[null,null,"5B Bullarook"]
[null,"NSW Murray","New South Wales Murray Regulated River Water Source"]
[null,"Murrumbidgee","Murrumbidgee Regulated River Water Source"]
[null,"Lower Darling","Lower Darling Regulated River Water Source"]
[]
[null,"Table A2 Water sources (northern MDB)"]
[null,"Region","Water source"]
[null,"Macquarie","Macquarie and Cudgegong Regulated Rivers Water Source"]
[null,"Namoi","Lower Namoi Regulated River Water Source"]
[null,null,"Upper Namoi Regulated River Water Source"]
[null,"Gwydir","Gwydir Regulated River Water Source"]
[null,"NSW Border Rivers","Border Rivers Regulated River Water Source"]
[null,"Barwon–Darling","Barwon–Darling Unregulated River Water Source"]
[null,"Lachlan","Lachlan Regulated River Water Source"]

{"sheet":"Appendix B","index":30,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,"Appendix B: Trades Excluded"]
[]
[null,"Table B1 shows trades that have been excluded from the November 2016 analysis."]
[]
[null,"Table B1 Outliers removed from trade data"]
[null,"Date","Catchment","Product name","Volume (ML)","Price ($)","Price per ML ($/ML)"]
[null,"2016-11-30","Broken","High Reliability",123,290079.51,2358.37]
[null,"2016-11-04","Campaspe","High Reliability",16,12000,750]
[null,"2016-11-09","Goulburn","High Reliability",1,1800,1800]
[null,"2016-11-11","Goulburn","High Reliability",1,3000,3000]
[null,"2016-11-17","Goulburn","High Reliability",20,1,0.05]
[null,"2016-11-17","Goulburn","High Reliability",9.5,1.0449999999999999,0.11]
[null,"2016-11-17","Goulburn","High Reliability",5,1,0.2]
[null,"2016-11-18","Goulburn","High Reliability",1,3000,3000]
[null,"2016-11-24","Goulburn","High Reliability",1,1200,1200]
[null,"2016-11-24","Goulburn","High Reliability",160,224000,1400]
[null,"2016-11-24","Goulburn","High Reliability",35.5,49700,1400]
[null,"2016-11-17","Goulburn","Low Reliability",0.9,0.99900000000000011,1.1100000000000001]
[null,"2016-11-17","Goulburn","Low Reliability",23.5,0.94000000000000006,0.04]
[null,"2016-11-29","Goulburn","Low Reliability",44.1,7717.0590000000002,174.99]
[null,"2016-11-29","Lower_Darling","General Security",15,1.05,7.0000000000000007E-2]
[null,"2016-11-29","Lower_Darling","High Security",35,1.05,0.03]
[null,"2016-11-17","NSW_Murray","General Security",15,1.05,7.0000000000000007E-2]
[null,"2016-11-17","NSW_Murray","General Security",184,77000.320000000007,418.48]
[null,"2016-11-18","NSW_Murray","General Security",104,34499.919999999998,331.73]
[null,"2016-11-30","NSW_Murray","General Security",40,1.2,0.03]
[null,"2016-11-25","Vic_Murray_AboveBC","High Reliability",1,1800,1800]
[null,"2016-11-08","Vic_Murray_AboveBC","Low Reliability",34.6,6228,180]
[null,"2016-11-17","Vic_Murray_BelowBC","High Reliability",10,1,0.1]
[null,"2016-11-23","Vic_Murray_BelowBC","High Reliability",9,13500,1500]
[null,"2016-11-23","Vic_Murray_BelowBC","High Reliability",4.9000000000000004,7350.0000000000009,1500,"*"]
[null,"2016-11-28","Vic_Murray_BelowBC","High Reliability",8,1.04,0.13]
[null,"2016-11-30","Vic_Murray_BelowBC","High Reliability",3.8,3800,1000]
[null,"2016-11-28","Vic_Murray_BelowBC","Low Reliability",4.2,1.008,0.24]
[null,"2016-11-28","Vic_Murray_BelowBC","Low Reliability",5.3,899.99299999999994,169.81]
[]
[null,"* - Trades are within the bounds of two standard deviations for the catchment, but have been excluded"]