{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["GB Fertiliser Price Series ","Charts ","Key information"],"not_rendered":{"charts":14,"images":11,"macros":0,"external_links":1,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"GB Fertiliser Price Series ","index":0,"n_rows":58,"n_cols":201,"rows_kept":58,"cut":false,"hidden":false,"merged":[[15,14,15,15],[54,1,54,11],[55,1,55,11],[56,1,56,6],[15,2,15,3],[15,4,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11],[15,12,15,13]]}
[]
[null,"GB Fertiliser Prices"]
[null,"HISTORICAL DATA SERIES"]
[]
[null,"Prices in £/tonne"]
[null,"The prices collected are spot prices for bags delivered to farm with standard 28 day buying terms"]
[]
[null,"Variation Indicator"]
[null,"The arrows in the table below are an indication of the level of variation between the start and end of the month. For example:"]
[null,"In January, the UAN price at the end of the month was 7% higher than at the start of the month which means it has been given a variation indicator of “↗”"]
[null,"In January, the TSP price at the end of the month was 1% higher than at the start of the month which means it has been given a variation indicator of “→”"]
[]
[null,"Variation Indicator Key"]
[null,"→ Less than \n5% variation","↗ Between 5% and 10% variation (upwards)                 ",null,"↑More than 10% variation (upwards) ",null,"↘ Between 5% and 10% variation (downwards)",null,"↓ More than 10% variation (downwards)"]
[]
[null,"Month","AN – UK produced (34.5% N)",null,"AN – Imported* \n(34.5% N)",null,"Granular Urea - Standard Specification (46% N)",null,"UAN (30% N w/w kg per 100kg)",null,"Muriate of Potash (MOP)",null,"Diammonium Phosphate (DAP)",null,"Triple Super Phosphate (TSP)"]
[null,"2017-01-01",239.27272727272728,"→",232.57142857142858,"→","N/a","",190,"↗",246.375,"→",335.45,"→",271.69565217391306,"→"]
[null,{"$f":"EDATE(B17,1)","v":"2017-02-01"},248.5,"→",237.91304347826087,"→","N/a","",204.15384615384616,"→",245.79166666666666,"→",342.26315789473682,"→",271.43478260869563,"→"]
[null,{"$f":"EDATE(B18,1)","v":"2017-03-01"},244.46666666666667,"↘",236.59259259259258,"↘","N/a","",204,"→",244.27586206896552,"→",347.6,"→",271.03571428571428,"→"]
[null,"2017-04-01",237.66666666666666,"→",226.20833333333334,"→","N/a","",205.05882352941177,"→",248.23809523809524,"→",348,"→",265.69565217391306,"→"]
[null,"2017-05-01",209.20833333333334,"↓",202.625,"↓","N/a","",204.21428571428572,"→",249.94736842105263,"→",345.44444444444446,"→",267.8235294117647,"→"]
[null,"2017-06-01",186.07466666666667,"→",180.84782608695653,"→","N/a","",155.8305,"→",249.80357142857142,"→",342.4708,"→",266.375,"→"]
[null,"2017-07-01",192.68304347826091,"→",184.86222222222221,"→","N/a","",155.5625,"→",249.77083333333334,"→",334.286,"→",266.13043478260869,"→"]
[null,"2017-08-01",198.02599999999998,"→",192.71428571428572,"→","N/a","",157.70588235294119,"→",250.89399999999998,"→",330.21733333333333,"→",264.39620689655169,"→"]
[null,"2017-09-01",211.43772727272727,"→",212.655,"→","N/a","",157.84615384615384,"→",257.55714285714282,"→",330.94736842105266,"→",265.61363636363637,"→"]
[null,"2017-10-01",224.10058823529411,"→",224.25,"→","N/a","",157.33333333333334,"→",259.5,"→",335.16666666666669,"→",264.82045454545454,"→"]
[null,"2017-11-01",236.37074074074076,"→",229.38434782608695,"→","N/a","",194.1875,"↑",261.93266666666665,"→",354.90384615384613,"↗",278.45862068965516,"↗"]
[null,"2017-12-01",246.08850000000001,"→","N/a","","N/a","","N/a","",263.70809523809521,"→",371.10526315789474,"→",287.41700000000003,"→"]
[null,"2018-01-01",243.03039999999999,"→",233.40909090909091,"→","N/a","",214,"→",260.42439999999999,"→",364.04347826086956,"→",284.65480000000002,"→"]
[null,"2018-02-01",242.74666666666667,"→",232.7883333333333,"→",251.91,"→",214,"→",259.53086956521742,"→",364,"→",284.61478260869563,"→"]
[null,"2018-03-01",242.24166666666667,"→",232.19541666666669,"→",252.65909090909091,"→",214,"→",263.31695652173914,"→",367.93181818181819,"→",287.33130434782606,"→"]
[null,"2018-04-01",240.0879166666667,"→",225.73526315789471,"→",250.25,"→",214.66666666666666,"→",263.32086956521738,"→",368.6,"→",289.61904761904759,"→"]
[null,"2018-05-01",227.8,"→",213.56,"→",244.32,"→",212.66666666666666,"→",264.39999999999998,"→",374.72,"→",292.60000000000002,"→"]
[null,"2018-06-01",226.55,"↗",214.83333333333334,"→",266.33333333333331,"↗",204.61538461538461,"↘",269.35000000000002,"→",393.15,"→",311.05,"→"]
[null,"2018-07-01",242.65,"→",232.33333333333334,"→",281.91666666666669,"→",202.35714285714286,"↗",276.52941176470586,"→",405.64705882352939,"→",324.5263157894737,"→"]
[null,"2018-08-01",259.62499999999994,"↗",245.35038461538463,"↗",284.86296296296297,"↗",207.57142857142858,"→",269.57758620689651,"→",404.98214285714283,"→",329.08586206896553,"→"]
[null,"2018-09-01",275.60000000000002,"→",260.88235294117646,"→",296.84210526315792,"→",220,"→",271.25,"→",405.95,"→",335.1,"→"]
[null,"2018-10-01",283.31261704444807,"→",271.06705461737408,"→",305.18237547892716,"→","N/a","",273.09953388026639,"→",409.44,"→",338.23483057525613,"→"]
[null,"2018-11-01",292.8844338549639,"→",274.15789473684208,"→",298.37102382011915,"→",247.91666666666666,"↗",273.09194673430568,"→",409.70588235294116,"→",337.47150259067359,"→"]
[null,"2018-12-01",291.90183936124527,"→",273.63143004115227,"→",293.99786457200645,"→",251.66666666666666,"→",273.67435818371831,"→",409.1764705882353,"→",337.38832951945079,"→"]
[null,"2019-01-01",277.83147747371771,"→",271.66663582531459,"→",285.27258693865008,"→",247.5,"→",279.05236520888747,"→",408.88,"→",336.62593171394599,"→"]
[null,"2019-02-01",278.08418753217819,"→",262.35642006330647,"→",273.99011345153804,"→",244.875,"→",278.67572463768113,"→",403.35,"→",332.54545454545456,"→"]
[null,"2019-03-01",263.9378125030417,"→",254.19565217391303,"→",261.11240310077523,"→",245.1764705882353,"→",278.67206695331697,"→",398.85634118967459,"→",332.1,"→"]
[null,"2019-04-01",263.36173034719951,"→",251.25545595141543,"→",262.13043478260869,"→",241.34996481351163,"→",278.8,"→",393.71428571428572,"→",324.62008281573497,"→"]
[null,"2019-05-01",263.08560553265545,"→",245.34887387387388,"→",268.30769230769232,"→",243.05555555555554,"→",278.68399008966492,"→",386.2,"→",318.61538461538464,"→"]
[null,"2019-06-01",258.10000000000002,"→",244.94736842105263,"→",279.95,"→",241.92307692307693,"→",278.8,"→",375.9,"→",311.2,"→"]
[null,"2019-07-01",258.2,"→",245.44,"→",282.04000000000002,"→",224.25,"→",280.88,"→",364.84,"→",307.27999999999997,"→"]
[null,"*Imported prices are based upon product delivered via a range of sea ports"]
[]
[null,"Last updated: August 2019"]
[]
[null,"Source: AHDB"]
[]
[{"$nulls":163},{"$f":"(LEFT(#REF!,3)+RIGHT(#REF!,6))/2","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,3)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,3)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,5))/2","v":{"$error":"#REF!"}},null,{"$f":"(LEFT(#REF!,3)+RIGHT(#REF!,2))/2","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,3)+RIGHT(#REF!,5))/2","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},"-",{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},"-",{"$f":"(LEFT(#REF!,3)+RIGHT(#REF!,5))/2","v":{"$error":"#REF!"}},"-","-","-",{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}}]
[null,"This publication and its content is produced by the AHDB Market Intelligence team whose quality management systems are certificated to ISO 9001:2015"]
[null,"While the Agriculture and Horticulture Development Board seeks to ensure that the information contained within this document is accurate at the time of printing, no warranty is given in respect thereof and, to the maximum extent permitted by law the Agriculture and Horticulture development Board accepts no liability for loss, damage or injury howsoever caused (including that caused by negligence) or suffered directly or indirectly in relation to information and opinions contained in or omitted from this document. "]
[null,"© Agriculture and Horticulture Development Board 2019. All rights reserved."]
[null,"AHDB, Stoneleigh Park, Kenilworth, CV8 2TL, UK    T +44 (0) 24 7669 2051",{"$nulls":9},"mi@ahdb.org.uk",null,null,null,"www.ahdb.org.uk"]

{"sheet":"Charts ","index":1,"n_rows":119,"n_cols":201,"rows_kept":119,"cut":false,"hidden":false,"merged":[[1,1,1,9],[116,1,116,11],[117,1,117,6]]}
[]
[null,"GB Fertiliser Prices"]
[null,"PRICE CHARTS"]
{"$rows_empty":111}
[{"$nulls":163},{"$f":"(LEFT(#REF!,3)+RIGHT(#REF!,6))/2","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,3)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,3)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,5))/2","v":{"$error":"#REF!"}},null,{"$f":"(LEFT(#REF!,3)+RIGHT(#REF!,2))/2","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,3)+RIGHT(#REF!,5))/2","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},"-",{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},"-",{"$f":"(LEFT(#REF!,3)+RIGHT(#REF!,5))/2","v":{"$error":"#REF!"}},"-","-","-",{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}}]
[null,"This publication and its content is produced by the AHDB Market Intelligence team whose quality management systems are certificated to ISO 9001:2015"]
[null,"While the Agriculture and Horticulture Development Board seeks to ensure that the information contained within this document is accurate at the time of printing, no warranty is given in respect thereof and, to the maximum extent permitted by law the Agriculture and Horticulture development Board accepts no liability for loss, damage or injury howsoever caused (including that caused by negligence) or suffered directly or indirectly in relation to information and opinions contained in or omitted from this document. "]
[null,"© Agriculture and Horticulture Development Board 2019. All rights reserved."]
[null,"AHDB, Stoneleigh Park, Kenilworth, CV8 2TL, UK    T +44 (0) 24 7669 2051",{"$nulls":9},"mi@ahdb.org.uk",null,null,null,"www.ahdb.org.uk"]

{"sheet":"Key information","index":2,"n_rows":37,"n_cols":191,"rows_kept":37,"cut":false,"hidden":false,"merged":[[33,1,33,2],[34,1,34,2],[35,1,35,2]]}
[]
[null,"Key information"]
[]
[null,"The below outlines the key information in relation to the collection and validation of the AHDB GB Fertiliser Price Series. \nPlease be aware that this series is an average of spot prices and therefore should be used as an indicator of pricing trends"]
[]
[null,"Product identification "]
[null,"The products and specifications covered in this price series are:"]
[]
[null,"·       Ammonium Nitrate – UK produced (34.5% N)"]
[null,"·       Ammonium Nitrate – Imported (34.5% N)"]
[null,"·       Granular Urea - Standard Specification (46% N)"]
[null,"·       Liquid Urea Ammonium Nitrate (UAN - 30% N w/w kg per 100kg)"]
[null,"·       Muriate of Potash (MOP)"]
[null,"·       Diammonium Phosphate (DAP)"]
[null,"·       Triple Super Phosphate (TSP)"]
[]
[null,"Specification"]
[null,"The prices shown are spot prices for bags delivered to farm with standard 28 day buying terms. Data providers may have made some adjustments to ensure prices meet this specification.   "]
[]
[null,"Frequency of collection and publication"]
[null,"Prices are submitted on a monthly basis. These prices are broken down into weekly figures to allow AHDB to assess the level of variation within a particular month."]
[null,"The UK Fertiliser Price Series will be published on a monthly basis and prices will be one month in arrears."]
[]
[null,"Validation criteria"]
[null,"AHDB will follow the validation criteria below:"]
[]
[null,"·       Aggregated and anonymised prices will only be published if there are three or more prices for each week within a month."]
[null,"·       Individual pricing contributions may be queried with the data provider if:"]
[null,"   There are three prices and the variation between the average and the min and/or max price is greater than 3% "]
[null,"   There are more than three prices and the variation between the average and the min and/or max price is greater than 5%"]
[]
[]
[{"$nulls":153},{"$f":"(LEFT(#REF!,3)+RIGHT(#REF!,6))/2","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,3)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,3)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,5))/2","v":{"$error":"#REF!"}},null,{"$f":"(LEFT(#REF!,3)+RIGHT(#REF!,2))/2","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,3)+RIGHT(#REF!,5))/2","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},"-",{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},"-",{"$f":"(LEFT(#REF!,3)+RIGHT(#REF!,5))/2","v":{"$error":"#REF!"}},"-","-","-",{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}},{"$f":"(LEFT(#REF!,5)+RIGHT(#REF!,3))/2","v":{"$error":"#REF!"}}]
[null,"This publication and its content is produced by the AHDB Market Intelligence team whose quality management systems are certificated to ISO 9001:2015"]
[null,"While the Agriculture and Horticulture Development Board seeks to ensure that the information contained within this document is accurate at the time of printing, no warranty is given in respect thereof and, to the maximum extent permitted by law the Agriculture and Horticulture development Board accepts no liability for loss, damage or injury howsoever caused (including that caused by negligence) or suffered directly or indirectly in relation to information and opinions contained in or omitted from this document. "]
[null,"© Agriculture and Horticulture Development Board 2019. All rights reserved."]
[null,"AHDB, Stoneleigh Park, Kenilworth, CV8 2TL, UK    T +44 (0) 24 7669 2051","mi@ahdb.org.uk",null,null,"www.ahdb.org.uk"]