{"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,"(April 2017)"]
[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 2017"]

{"sheet":"Introduction","index":1,"n_rows":82,"n_cols":3,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Introduction"]
[null,"This April 2017 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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Price correlations in the southern MDB, general security, low reliability, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Source: Marsden Jacob analysis, 2017."]

{"sheet":"SA Murray - Class 3a","index":3,"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,"Southern Australian Murray: Class 3a"]
[]
[null,"Entitlement market prices and volumes, SA Murray, Class 3a, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, SA Murray, Class 3a"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,2999.7374926169796,2966.4484327219061,2713.0926931569575,2999.9999999999995,3000,3000,2985.7,3000,1371.39,10,"2 700 - 3 000"]
[]
[null,"Entitlement market price range, SA Murray, Class 3a, by volume month April 2017"]

{"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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Vic. Murray above Barmah Choke, high reliability"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,2618.3191969078812,2557.7850652911634,2563.4818335229952,2500,2625,2605,2560,2625,931.39999999999986,12,"2 450 - 2 700"]
[]
[null,"Entitlement market price range, Vic. Murray above Barmah Choke, high reliability, by volume month April 2017"]

{"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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Vic. Murray above Barmah Choke, low reliability"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,282.72566700753003,274.09416767922238,247.03550214109944,252.5,290,290,275.83333333333331,290,1075.6999999999998,6,"290 - 310"]
[]
[null,"Entitlement market price range, Vic. Murray above Barmah Choke, low reliability, by volume month April 2017"]

{"sheet":"Vic Murray BelowBC - High Rel","index":6,"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: high reliability"]
[]
[null,"Entitlement market prices and volumes, Vic. Murray below Barmah Choke, high reliability, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Vic. Murray below Barmah Choke, high reliability"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,2764.3768466290621,2780.9344719184123,2875.5239733311951,2500,2850,2750,2619.2105263157896,2500,744.60000000000014,38,"2 700 - 2 900"]
[]
[null,"Entitlement market price range, Vic. Murray below Barmah Choke, high reliability, by volume month April 2017"]

{"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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Vic. Murray below Barmah Choke, low reliability"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,300.69828722002597,278.18627450980392,262.87726557502879,290,315,300,303.33333333333331,"-",75.900000000000006,3,"300 - 340"]
[]
[null,"Entitlement market price range, Vic. Murray below Barmah Choke, low reliability, by volume month April 2017"]

{"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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Goulburn, high reliability"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,2642.7709950366343,2593.2286735435359,2611.9389390379361,2500,2675,2650,2573.9006666666664,2650,2115.5,45,"2 500 - 2 650"]
[]
[null,"Entitlement market price range, Goulburn, high reliability, by volume month April 2017"]

{"sheet":"Goulburn - Low Reliability","index":9,"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: low reliability"]
[]
[null,"Entitlement market prices and volumes, Goulburn, low reliability, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Goulburn, low reliability"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,281.48208776679468,274.55994048215462,248.72219190091235,267,303.75,285,277.38888888888891,270,1588.3000000000002,18,"290 - 340"]
[]
[null,"Entitlement market price range, Goulburn, low reliability, by volume month April 2017"]

{"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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Campaspe, high reliability"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,2300,2353.1689873417722,2381.8005465023848,2300,2300,2300,2300,"-",2,1,"2 250 - 2 450"]
[]
[null,"Entitlement market price range, Campaspe, high reliability, by volume month April 2017"]

{"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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Loddon, high reliability"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,"-",2000,1826.3620945516218,"-","-","-","-","-","-","-","No listings"]
[]
[null,"Entitlement market price range, Loddon, high reliability, by volume month April 2017"]

{"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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, NSW Murray, general security"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,1214.9482792001252,1207.5832274866848,1187.7083398040925,1050,1277.5,1205,1182.5,1000,1084.67,6,"1 200 - 1 350"]
[]
[null,"Entitlement market price range, NSW Murray, general security, by volume month April 2017"]

{"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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, NSW Murray, high security"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,3394.5205479452056,3475.5390334572489,3324.2529654532286,3250,3500,3350,3370,3250,73,5,"3 350 - 3 400"]
[]
[null,"Entitlement market price range, NSW Murray, high security, by volume month April 2017"]

{"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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, NSW Murray Irrigation Limited, general security"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,1233.9950650515927,1224.914914914915,1191.4387015881862,1193.75,1260,1250,1230,1250,2229,14,"1 200 - 1 275"]
[]
[null,"Entitlement market price range, NSW Murray Irrigation Limited, general security, by volume month April 2017"]

{"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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Murrumbidgee, general security"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,1495.6375838926174,1429.725085910653,1416.2591131291367,1487.5,1500,1500,1487.5,1500,596,4,"1 450 - 1 550"]
[]
[null,"Entitlement market price range, Murrumbidgee, general security, by volume month April 2017"]

{"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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Murrumbidgee, high security"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,"-",3603.4322829200828,3592.1490814884596,"-","-","-","-","-","-","-","3 400 - 3 500"]
[]
[null,"Entitlement market price range, Murrumbidgee, high security, by volume month April 2017"]

{"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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Lower Darling, general security"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,"-",333.33,333.33,"-","-","-","-","-","-","-","No listings"]
[]
[null,"Entitlement market price range, Lower Darling, general security, by volume month April 2017"]

{"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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Lower Darling, high security"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,"-",1612.121212121212,1627.5459098497495,"-","-","-","-","-","-","-","No listings"]
[]
[null,"Entitlement market price range,Lower Darling, high security, by volume month April 2017"]

{"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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Source: Marsden Jacob analysis, 2017."]

{"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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Macquarie, general security"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,1300,1267.5490779298036,1076.7002518891688,1300,1300,1300,1300,1300,220,2,"1 250 - 1 300"]
[]
[null,"Entitlement market price range, Macquarie, general security, by volume month April 2017"]

{"sheet":"Namoi - General Security","index":21,"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,"Namoi: general security"]
[]
[null,"Entitlement market prices and volumes,Namoi, general security, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Namoi, general security"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,"-",2071.9897595102757,2023.2367006404902,"-","-","-","-","-","-","-","1 950 - 2 000"]
[]
[null,"Entitlement market price range, Namoi, general security, by volume month April 2017"]

{"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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Gwydir, general security"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,"-","-",2222.8626599965501,"-","-","-","-","-","-","-","2 200 - 2 300"]
[]
[null,"Entitlement market price range, Gwydir, general security, by volume month April 2017"]

{"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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, NSW Border Rivers, general security"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,"-",2000,2224.812480151229,"-","-","-","-","-","-","-","2 000 - 3 300"]
[]
[null,"Entitlement market price range, NSW Border Rivers, general security, by volume month April 2017"]

{"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, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Barwon–Darling, unregulated"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,1100,1100,1161.7900684931506,1100,1100,1100,1100,"-",634,1,"1 100 - 1 400"]
[]
[null,"Entitlement market price range, Barwon–Darling, unregulated, by volume month April 2017"]

{"sheet":"Lachlan - General Security","index":25,"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,"Lachlan: General security"]
[]
[null,"Entitlement market prices and volumes, Lachlan, general security, July 2010 to April 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entitlement market prices and volumes, Lachlan, general security"]
[null,"Volume weighted average price ($/ML)",null,null,"April 2017 (in $/ML)",null,null,null,null,"April 2017 Volume","April 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,"Month of April 2017","April 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,680.18108651911473,569.6009011908593,505.6717186032613,662.5,687.5,675,675,"-",497,2,"550 - 675"]
[]
[null,"Entitlement market price range, Lachlan, general security, by volume month April 2017"]

{"sheet":"QLD - Trade Summary","index":26,"n_rows":13,"n_cols":15,"rows_kept":13,"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, Queensland"]
[null,"Resource Operation Plan","Water Supply Scheme / Water Management Area","Type of Entitlement","Volume weighted average price ($/ML)",null,null,"March 2017 (in $/ML)",null,null,null,null,"March 2017 Volume","March 2017 # of trades","Broker buy/sell range ($/ML)"]
[null,null,null,null,"Month of March 2017","March 2017 Quarter","YTD ","25th percentile","75th percentile","Median","Mean","Mode"]
[null,"QLD Border Rivers","Border Rivers/ Macintyre Brook","Supplemented","-","-","1 600","-","-","-","-","-","-","-","No listings"]
[null,"QLD Border Rivers","Border Rivers","Unsupplemented","-","-","1 739","-","-","-","-","-","-","-","No listings"]
[null,"Condamine-Balonne","St. George / Upper Condamine","Supplemented",1000,1000,1236.4288872512896,1000,1000,1000,1000,"-",104,1,"No listings"]
[null,"Condamine-Balonne","Condamine Balonne / Lower Balonne / Upper Condamine","Unsupplemented","-",1509.433962264151,1489,"-","-","-","-","-","-","-","No listings"]
[null,"Condamine-Balonne","Upper Condamine","Alluvium Ground-water","-","-","-","-","-","-","-","-","-","-","No listings"]
[null,"Condamine-Balonne","Lower Balonne","Overland Flow","-","-","-","-","-","-","-","-","-","-","No listings"]
[null,"Note: No trades have been reported for Queensland in April 2017. Tables show the monthly trade figures until the end of March."]

{"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, July 2010 to March 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: No trades have been reported for Queensland in April 2017. Charts show the monthly trade volume and value until the end of March."]
[]
[null,"Condamine Balonne: Unsupplemented"]
[]
[null,"Entitlement market prices and volumes, Condamine_Balonne - Unsupplemented, July 2010 to March 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: No trades have been reported for Queensland in April 2017. Charts show the monthly trade volume and value until the end of March."]
[]
[null,"Condamine Balonne: Alluvium Groundwater"]
[]
[null,"Entitlement market prices and volumes, Condamine_Balonne - Alluvium Groundwater, July 2010 to March 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: No trades have been reported for Queensland in April 2017. Charts show the monthly trade volume and value until the end of March."]

{"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, July 2010 to March 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: No trades have been reported for Queensland in April 2017. Charts show the monthly trade volume and value until the end of March."]
[]
[null,"QLD Border Rivers: Unsupplemented"]
[]
[null,"Entitlement market prices and volumes, QLD_Border_Rivers - Unsupplemented, July 2010 to March 2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note: No trades have been reported for Queensland in April 2017. Charts show the monthly trade volume and value until the end of March."]

{"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":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[null,"Appendix B: Trades Excluded"]
[]
[null,"Table B1 shows trades that have been excluded from the April 2017 analysis."]
[]
[null,"Table B1 Outliers removed from trade data"]
[null,"Date","Catchment","Product name","Volume (ML)","Price ($)","Price per ML ($/ML)"]
[null,"2017-04-21","Broken","High Reliability",50,150000,3000]
[null,"2017-04-21","Broken","Low Reliability",10.5,5250,500]
[null,"2017-04-05","Goulburn","High Reliability",2,3000,1500]
[null,"2017-04-28","Goulburn","High Reliability",17,3400,200]
[null,"2017-04-03","Goulburn","Low Reliability",1.4,700,500]
[null,"2017-04-13","Goulburn","Low Reliability",21.6,3240,150]
[null,"2017-04-03","NSW_Murray","General Security",0,0,1]
[null,"2017-04-03","NSW_Murray","General Security",2140,266503701.59999999,124534.44]
[null,"2017-04-03","NSW_Murray","NOT_ALLOC",0,0,1]
[null,"2017-04-06","NSW_Murray","NOT_ALLOC",3,0.99,0.33]
[null,"2017-04-26","NSW_Murray_Irrigation","General Security",0,0,50]
[null,"2017-04-03","Ovens","High Reliability",2,4000,2000]
[null,"2017-04-28","SA_Murray","Class 3a",65.28,305480,4679.5343137254904]
[null,"2017-04-26","SA_Murray","NOT_ALLOC",0.5,2500,5000]
[null,"2017-04-28","SA_Murray","NOT_ALLOC",15,75000,5000]
[null,"2017-04-28","SA_Murray","NOT_ALLOC",11.015000000000001,305480,27733.091239219244]
[null,"2017-04-28","SA_Murray","NOT_ALLOC",1,305480,305480]
[null,"2017-04-28","SA_Murray","NOT_ALLOC",4.617,305480,66164.175871778207]
[null,"2017-04-28","SA_Murray","NOT_ALLOC",14,305480,21820]
[null,"2017-04-12","Vic_Murray_AboveBC","Low Reliability",2133.4,805358.5,377.5]
[null,"2017-04-12","Vic_Murray_AboveBC","Low Reliability",72.900000000000006,27519.750000000004,377.5]
[null,"2017-04-13","Vic_Murray_BelowBC","High Reliability",109.6,137000,1250]
[null,"2017-04-03","Vic_Murray_BelowBC","Low Reliability",6.1,915,150]
[]
[null,"* - Trades are within the bounds of two standard deviations for the catchment, but have been excluded"]