{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Title","Lime model","Instructions","Calculation tables"],"not_rendered":{"charts":2,"images":7,"macros":1,"external_links":1,"defined_names":3,"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":"Title","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Lime model","index":1,"n_rows":52,"n_cols":30,"rows_kept":52,"cut":false,"hidden":false,"merged":[[46,17,46,18],[4,14,5,14],[4,15,4,19],[27,17,27,18],[11,0,11,1],[12,0,12,1],[7,0,7,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[41,0,41,4],[17,0,17,1],[35,0,35,1],[34,0,34,1],[32,0,32,1],[31,0,31,1],[30,0,30,1],[29,0,29,1],[24,0,24,1],[19,0,19,1],[26,0,26,1],[1,4,2,4],[1,0,2,0],[22,0,22,1],[23,0,23,1],[25,0,25,1],[2,1,2,2],[49,0,49,3],[43,0,43,3],[44,0,44,3],[45,0,45,3],[46,0,46,3],[47,0,47,3]]}
["Maintenance Liming Rate Calculator"]
["Paddock name:","Enter",null,null,"Top Soil Texture:","Select "]
[null,"Crawford",null,null,null,"Clay Loam"]
[null,"Year",1,2,3,4,5,6,7]
["Year ( 20…… )","Enter",2011,2012,2013,2014,2015,2016,2017,null,null,null,null,null,"Annual Rainfall received","Soil texture"]
["Annual Rainfall","Enter",616,370,504,401,493,734,433,null,null,null,null,null,null,"Sand","Loamy Sand","Sandy Loam","Loam","Clay Loam","Clay",null,"Yes","No"]
["Saturated Soil","Select ","No","No","No","No","No","No","No",null,null,null,null,null,"Less than 325 mm",0.5,0.4,0.3,0.1,0,0,null,{"$f":"IF($F$3=V7,\"Texture!!\",IF($F$3=$P$6,P7,IF($F$3=$Q$6,Q7,IF($F$3=$R$6,R7,IF($F$3=$S$6,S7,IF($F$3=$T$6,T7,IF($F$3=$U$6,U7,0)))))))","v":0}]
["Leaching %  ",null,{"$f":"IF(C7=$W$6,$W$12,IF(C6<326,$W$7,IF(C6<451,$W$8,IF(C6<551,$W$9,IF(C6<751,$W$10,IF(C6>750,$W$11,))))))","v":0.2},{"$f":"IF(D7=$W$6,$W$12,IF(D6<326,$W$7,IF(D6<451,$W$8,IF(D6<551,$W$9,IF(D6<751,$W$10,IF(D6>750,$W$11,IF(D6=P12,$W$12,)))))))","v":0.05},0.1,0.05,0.1,0.2,0.05,null,null,null,null,null,"325 - 450 mm",0.65,0.56999999999999995,0.45,0.25,0.05,0,null,0.05]
[null,null,null,null,"Product Removal",null,null,null,null,null,null,null,null,null,"450 - 550 mm",0.75,0.68,0.5,0.3,0.1,0,null,0.1]
["Crop Type  ","Select ","Cereal grain","Pasture (40% legume)","Cereal grain","Pasture (80% legume)","Cereal grain","Pasture (80% legume)","Cereal grain",null,null,null,null,null,"550 - 750 mm",0.8,0.7,0.6,0.4,0.2,0,null,0.2]
["Yield (tonnes/ha)","Enter",3.6,4.5,3,5,1.3,6,2,null,null,null,null,null,"Greater than 750 mm",0.95,0.85,0.75,0.55000000000000004,0.35,0.15,null,0.35]
["Lime replacement/tonne grain yield (kg/ha)",null,{"$f":"VLOOKUP(C10,Crop_array,2,0)","v":9},2,9,4,9,4,9,null,null,null,null,null,"Saturated Soil",0.95,0.85,0.75,0.55000000000000004,0.35,0.15,null,0.35]
["Lime required due to product removal (kg/ha)",null,{"$f":"C11*C12","v":32.4},{"$f":"D11*D12","v":9},27,20,11.700000000000001,24,18,"Total (kg/ha) ",{"$f":"SUM(C13:I13)","v":142.10000000000002}]
[null,null,null,null,"Legume Fixed Nitrogen "]
["kg N fixed per tonne legume production  ",null,{"$f":"VLOOKUP(C10,Nfixed_array,2,0)","v":0},8,0,20,0,20,0,null,null,null,null,null,"Crop","lime equivalent per tonne",null,null," N fixed by legume crops and pastures (kg/ha)* "]
["Legume fixed nitrogen (kg/ha) ",null,{"$f":"C11*C15","v":0},{"$f":"D11*D15","v":36},0,100,0,120,0,null,null,null,null,null,null,null,null,null,"Crop/Pasture ","Select"]
["Leaching adjusted lime requirement (kg/ha)/kg N",null,{"$f":"IF(C10=$O$18,U46,IF(C10=$O$21,U45,IF(C10=$O$22,U45,IF(C10=$O$23,U45,IF(C10=$O$24,U45,IF(C10=$O$26,U45,0))))))","v":0},{"$f":"IF(D10=$O$18,V46,IF(D10=$O$21,V45,IF(D10=$O$22,V45,IF(D10=$O$23,V45,IF(D10=$O$24,V45,IF(D10=$O$26,V45,0))))))","v":0.18000000000000002},0,0.18000000000000002,0,0.72000000000000008,0,null,null,null,null,null,"Cereal grain",9,null,null,"Nil legumes",0]
["Lime required due to legume fixed N (kg/ha)",null,{"$f":"C16*C17","v":0},{"$f":"D16*D17","v":6.48},0,18.000000000000004,{"$f":"G16*G17","v":0},{"$f":"H16*H17","v":86.4},0,"Total (kg/ha) ",{"$f":"SUM(C18:I18)","v":110.88000000000001},null,null,null,"Grain legume",20,null,null,"Legume pasture (kg N/t DM) ",30]
[null,null,null,null,"Fertilisers Inputs ",null,null,null,null,null,null,null,null,null,"Oilseed",2,null,null,"Grain legume crop (kg N fixed/t grain)  ",60]
["Fertiliser 1. (Seeding)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Pasture (grass only)",10,null,null,"*Assumes 100% leaching, will be adjusted by fert leaching factor  "]
["Fertiliser Type ","Select ","DAP","DAP","DAP","DAP","MAP","DAP","MAP",null,null,null,null,null,"Pasture (40% legume)",30]
["Rate fertiliser (kg/ha)","Enter",92,20,75,0,75,0,55,null,null,null,null,null,"Pasture (60% legume)",40]
["Product N (%)",null,{"$f":"IF(C21=$O$31,$Q$31,IF(C21=$O$32,$Q$32,IF(C21=$O$33,$Q$33,IF(C21=$O$34,$Q$34,IF(C21=$O$35,$Q$35,IF(C21=$O$36,$Q$36,IF(C21=$O$37,$Q$37,IF(C21=$O$38,$Q$38,IF(C21=$O$39,$Q$39,IF(C21=$O$40,$Q$40,IF(C21=$O$41,$Q$41,IF(C21=$O$42,$Q$42,IF(C21=$O$43,$Q$43,IF(C21=$O$44,$Q$44,IF(C21=$O$45,$Q$45,IF(C21=$O$46,$Q$46,IF(C21=$O$47,$Q$47,0)))))))))))))))))","v":18},18,18,18,10,18,10,null,null,null,null,null,"Pasture (80% legume)",50]
["Rate of nitrogen",null,{"$f":"C22*C23/100","v":16.559999999999999},{"$f":"D22*D23/100","v":3.6},13.5,0,7.5,0,5.5,null,null,null,null,null,"Lucerne hay",70]
["Leaching adjusted lime requirement (kg/ha)/kg N",null,{"$f":"IF(C21=$O$31,U31,IF(C21=$O$32,U32,IF(C21=$O$33,U33,IF(C21=$O$34,U34,IF(C21=$O$35,U35,IF(C21=$O$36,U36,IF(C21=$O$37,U37,IF(C21=$O$38,U38,IF(C21=$O$39,U39,IF(C21=$O$40,U40,IF(C21=$O$41,U41,IF(C21=$O$42,U42,IF(C21=$O$43,U43,IF(C21=$O$44,U44,IF(C21=$O$45,U45,IF(C21=$O$46,U46,IF(C21=$O$47,O47,0)))))))))))))))))","v":2.5200000000000005},{"$f":"IF(D21=$O$31,V31,IF(D21=$O$32,V32,IF(D21=$O$33,V33,IF(D21=$O$34,V34,IF(D21=$O$35,V35,IF(D21=$O$36,V36,IF(D21=$O$37,V37,IF(D21=$O$38,V38,IF(D21=$O$39,V39,IF(D21=$O$40,V40,IF(D21=$O$41,V41,IF(D21=$O$42,V42,IF(D21=$O$43,V43,IF(D21=$O$44,V44,IF(D21=$O$45,V45,IF(D21=$O$46,V46,IF(D21=$O$47,P47,0)))))))))))))))))","v":1.98},2.16,1.98,3.96,2.5200000000000005,3.7800000000000002,null,null,null,null,null,"Export oaten hay",25]
["Lime required due to seeding fertiliser applications (kg/ha) ",null,{"$f":"C24*C25","v":41.731200000000001},{"$f":"D24*D25","v":7.1280000000000001},29.160000000000004,0,29.7,0,20.790000000000003,"Total (kg/ha) ",{"$f":"SUM(C26:I26)","v":128.50920000000002},null,null,null,"Clover hay",40]
["Fertiliser 2.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Fertiliser lime equivalent (leaching adjusted)* "]
["Fertiliser Type ","Select ","UAN","Urea","S.O.A","Urea","Urea","Urea","Urea",null,null,null,null,null,"Fertiliser ",null,"N %","Leaching %",null,null,"Year 1",2,3,4,5,6,7,8,9,10]
["Rate fertiliser (kg/ha)","Enter",20,0,30,0,0,0,40,null,null,null,null,null,"Select","Composition ","%",0,1,null," Lime equivalent (Leaching adj.) "," Lime equivalent (Leaching adj.) "," Lime equivalent (Leaching adj.) "," Lime equivalent (Leaching adj.) "," Lime equivalent (Leaching adj.) "," Lime equivalent (Leaching adj.) "," Lime equivalent (Leaching adj.) "," Lime equivalent (Leaching adj.) "," Lime equivalent (Leaching adj.) "," Lime equivalent (Leaching adj.) "]
["Product N (%)",null,{"$f":"IF(C28=$O$31,$Q$31,IF(C28=$O$32,$Q$32,IF(C28=$O$33,$Q$33,IF(C28=$O$34,$Q$34,IF(C28=$O$35,$Q$35,IF(C28=$O$36,$Q$36,IF(C28=$O$37,$Q$37,IF(C28=$O$38,$Q$38,IF(C28=$O$39,$Q$39,IF(C28=$O$40,$Q$40,IF(C28=$O$41,$Q$41,IF(C28=$O$42,$Q$42,IF(C28=$O$43,$Q$43,IF(C28=$O$44,$Q$44,IF(C28=$O$45,$Q$45,IF(C28=$O$46,$Q$46,IF(C28=$O$47,$Q$47,0)))))))))))))))))","v":30},{"$f":"IF(D28=$O$31,$Q$31,IF(D28=$O$32,$Q$32,IF(D28=$O$33,$Q$33,IF(D28=$O$34,$Q$34,IF(D28=$O$35,$Q$35,IF(D28=$O$36,$Q$36,IF(D28=$O$37,$Q$37,IF(D28=$O$38,$Q$38,IF(D28=$O$39,$Q$39,IF(D28=$O$40,$Q$40,IF(D28=$O$41,$Q$41,IF(D28=$O$42,$Q$42,IF(D28=$O$43,$Q$43,IF(D28=$O$44,$Q$44,IF(D28=$O$45,$Q$45,IF(D28=$O$46,$Q$46,IF(D28=$O$47,$Q$47,0)))))))))))))))))","v":46},21,46,46,46,46,null,null,null,null,null,null,null,null,null,null,null,"kg Lime/kg N ","kg Lime/kg N ","kg Lime/kg N ","kg Lime/kg N ","kg Lime/kg N ","kg Lime/kg N ","kg Lime/kg N ","kg Lime/kg N ","kg Lime/kg N ","kg Lime/kg N "]
["Rate of nitrogen",null,{"$f":"C29*C30/100","v":6},{"$f":"D29*D30/100","v":0},6.3,0,0,0,18.399999999999999,null,null,null,null,null,"Single Super","Phosphorus Sulphate",0,0,0,null,{"$f":"R31+(S31-R31)*C8","v":0},{"$f":"$R$31+($S$31-$R$31)*D8","v":0},0,0,0,0,0,{"$f":"$R$31+($S$31-$R$31)*#REF!","v":{"$error":"#REF!"}},0,{"$f":"$R$31+($S$31-$R$31)*L10","v":0}]
["Leaching adjusted lime requirement (kg/ha)/kg N",null,{"$f":"IF(C28=$O$31,U31,IF(C28=$O$32,U32,IF(C28=$O$33,U33,IF(C28=$O$34,U34,IF(C28=$O$35,U35,IF(C28=$O$36,U36,IF(C28=$O$37,U37,IF(C28=$O$38,U38,IF(C28=$O$39,U39,IF(C28=$O$40,U40,IF(C28=$O$41,U41,IF(C28=$O$42,U42,IF(C28=$O$43,U43,IF(C28=$O$44,U44,IF(C28=$O$45,U45,IF(C28=$O$46,U46,IF(C28=$O$47,U47,0)))))))))))))))))","v":0.72000000000000008},{"$f":"IF(D28=$O$31,V31,IF(D28=$O$32,V32,IF(D28=$O$33,V33,IF(D28=$O$34,V34,IF(D28=$O$35,V35,IF(D28=$O$36,V36,IF(D28=$O$37,V37,IF(D28=$O$38,V38,IF(D28=$O$39,V39,IF(D28=$O$40,V40,IF(D28=$O$41,V41,IF(D28=$O$42,V42,IF(D28=$O$43,V43,IF(D28=$O$44,V44,IF(D28=$O$45,V45,IF(D28=$O$46,V46,IF(D28=$O$47,V47,0)))))))))))))))))","v":0.18000000000000002},3.96,0.18000000000000002,0.36000000000000004,0.72000000000000008,0.18000000000000002,null,null,null,null,null,"Muriate Pot.","Potassium Chloride ",0,0,0,null,{"$f":"R32+(S32-R32)*$C$8","v":0},{"$f":"R32+(S32-R32)*$D$8","v":0},{"$f":"R32+(S32-R32)*$E$8","v":0},{"$f":"R32+(S32-R32)*$F$8","v":0},{"$f":"R32+(S32-R32)*$G$8","v":0},{"$f":"R32+(S32-R32)*$H$8","v":0},{"$f":"R32+(S32-R32)*$I$8","v":0},{"$f":"$R$32+($S$32-$R$32)*#REF!","v":{"$error":"#REF!"}},{"$f":"$R$32+($S$32-$R$32)*$K$8","v":0},{"$f":"$R$32+($S$32-$R$32)*$L$10","v":0}]
["Lime required due to in-crop fertiliser applications (kg/ha) ",null,{"$f":"C31*C32","v":4.32},{"$f":"D31*D32","v":0},24.948,0,0,0,3.3120000000000003,"Total (kg/ha) ",{"$f":"SUM(C33:I33)","v":32.58},null,null,null,"Sulphate Pot.","Potassium sulphate ",0,0,0,null,0,0,0,0,0,0,0,{"$f":"$R$32+($S$32-$R$32)*#REF!","v":{"$error":"#REF!"}},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ammonium Nitrate","Ammonium Nitrate ",34,0,3.6,null,0.72000000000000008,0.18000000000000002,0.36000000000000004,0.18000000000000002,0.36000000000000004,0.72000000000000008,0.18000000000000002,{"$f":"$R$32+($S$32-$R$32)*#REF!","v":{"$error":"#REF!"}},0,0]
["Annual replacement lime required (kg/ha)",null,{"$f":"C13+C18+C26+C33","v":78.4512},22.608000000000001,81.108000000000004,38,41.4,110.4,42.102000000000004,null,null,null,null,null,"Urea","Urea ",46,0,3.6,null,0.72000000000000008,0.18000000000000002,0.36000000000000004,0.18000000000000002,0.36000000000000004,0.72000000000000008,0.18000000000000002,{"$f":"$R$32+($S$32-$R$32)*#REF!","v":{"$error":"#REF!"}},0,0]
["Cumulative lime required over\"n\" years (kg/ha) ",null,{"$f":"C35","v":78.4512},{"$f":"C36+D35","v":101.0592},{"$f":"D36+E35","v":182.16720000000001},220.16720000000001,261.56720000000001,371.96720000000005,414.06920000000002,null,null,null,null,null,"UAN","Urea/Ammonium nitrate",30,0,3.6,null,0.72000000000000008,0.18000000000000002,0.36000000000000004,0.18000000000000002,0.36000000000000004,0.72000000000000008,0.18000000000000002,{"$f":"$R$32+($S$32-$R$32)*#REF!","v":{"$error":"#REF!"}},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"32:10","DAP/Urea Blend ",32,0.9,5.4,null,1.8,1.125,1.35,1.125,1.35,1.8,1.125,{"$f":"$R$32+($S$32-$R$32)*#REF!","v":{"$error":"#REF!"}},0,0]
["Summary of lime requirement to address annual acidification ",null,null,null,null,null,null,null,null,null,null,null,null,null,"DAP","18%N, 20% P",18,1.8,5.4,null,2.5200000000000005,1.98,2.16,1.98,2.16,2.5200000000000005,1.98,{"$f":"$R$32+($S$32-$R$32)*#REF!","v":{"$error":"#REF!"}},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27:12","MAP/Urea Blend ",27,3.6,7.2,null,4.32,3.7800000000000002,3.96,3.7800000000000002,3.96,4.32,3.7800000000000002,{"$f":"$R$32+($S$32-$R$32)*#REF!","v":{"$error":"#REF!"}},0,0]
["Number of years of management data (n=)",null,null,null,{"$f":"COUNTA(C10:I10)","v":7},null,null,null,null,null,null,null,null,null,"19:13","DAP/SOA blend ",19,2.7,6.3,null,3.42,2.8800000000000003,3.06,2.8800000000000003,3.06,3.42,2.8800000000000003,{"$f":"$R$32+($S$32-$R$32)*#REF!","v":{"$error":"#REF!"}},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MAP","10%N, 20% P",10,3.6,7.2,null,4.32,3.7800000000000002,3.96,3.7800000000000002,3.96,4.32,3.7800000000000002,{"$f":"$R$32+($S$32-$R$32)*#REF!","v":{"$error":"#REF!"}},0,0]
["Cumulative replacement lime required by management practice (kg/ha) ",null,null,null,null,null,null,null,null,null,null,null,null,null,"S.O.A","ammonium sulphate ",21,3.6,7.2,null,4.32,3.7800000000000002,3.96,3.7800000000000002,3.96,4.32,3.7800000000000002,{"$f":"$R$32+($S$32-$R$32)*#REF!","v":{"$error":"#REF!"}},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12:17","MAP/Urea Blend ",12,1.8,5.4,null,2.5200000000000005,1.98,2.16,1.98,2.16,2.5200000000000005,1.98,{"$f":"$R$32+($S$32-$R$32)*#REF!","v":{"$error":"#REF!"}},0,0]
["Lime required due to product removal (kg/ha)",null,null,null,{"$f":"K13","v":142.10000000000002},null,null,null,null,null,null,null,null,null,"24:16","80% DAP, 20% Urea",24,1.8,3.6,null,2.16,1.8900000000000001,1.98,1.8900000000000001,1.98,2.16,1.8900000000000001,{"$f":"$R$32+($S$32-$R$32)*#REF!","v":{"$error":"#REF!"}},0,0]
["Lime required due to legume fixed N (kg/ha)",null,null,null,{"$f":"K18","v":110.88000000000001},null,null,null,null,null,null,null,null,null,"Pasture Legume","Legume fixed N (30 kg/t DM) ",30,0,3.6,null,0.72000000000000008,0.18000000000000002,0.36000000000000004,0.18000000000000002,0.36000000000000004,0.72000000000000008,0.18000000000000002,{"$f":"$R$32+($S$32-$R$32)*#REF!","v":{"$error":"#REF!"}},0,0]
["Lime required due to seeding fertiliser applications (kg/ha) ",null,null,null,{"$f":"K26","v":128.50920000000002},null,null,null,null,null,null,null,null,null,"Grain Legume ","Legume fixed N (60 kg/t grain) ",60,0,3.6,null,0.72000000000000008,0.18000000000000002,0.36000000000000004,0.18000000000000002,0.36000000000000004,0.72000000000000008,0.18000000000000002,{"$f":"$R$32+($S$32-$R$32)*#REF!","v":{"$error":"#REF!"}},0,0]
["Lime required due to in-crop fertiliser applications (kg/ha) ",null,null,null,{"$f":"K33","v":32.58},null,null,null,null,null,null,null,null,null,"Other",null,"N % from product analysis. ","Function of base fertilisers used to create blend"]
["Total cumulative lime required over \"n\" years (kg/ha)",null,null,null,{"$f":"I36","v":414.06920000000002},null,null,null,null,null,null,null,null,null,"*adjusted from Soil Guide (AgWA 1998)"]
[]
["Average annual replacement lime required (kg/ha)",null,null,null,{"$f":"IF(ISERROR(SUM(E44:E47)/E40),\"0\",SUM(E44:E47)/E40)","v":59.152742857142862}]
[]
["Recommended lime application rate for 10 year period (t/ha)",null,null,null,{"$f":"E50*10/1000","v":0.59152742857142859}]

{"sheet":"Instructions","index":2,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,1,34,14],[28,2,29,14],[31,1,31,13],[32,1,32,13],[33,1,33,14]]}
[null,"How to use this tool "]
[]
[null,null,"these buttons to move to perform listed function"]
[]
[null,"Enter","type your information into the green shaded cell adjacent or below. "]
[]
[null,"Select ","Select an option from the drop down list which will appear when you click on the blue shaded cell adjacent or below"]
[]
[null,null,"Cells of this colour contain data calculated from your entries or selections "]
[]
[null,"Lime maintenance rate calculator "]
[null,"Paddock information"]
[null,"Enter"," the paddock name"]
[]
[null,"Select "," the paddock top soil (0-10 cm soil layer) texture.   ",null,null,null,null,"Note: this information is vital for the model to calculate leaching %"]
[]
[null,"Enter","the year that you have paddock data for "]
[]
[null,"Select ","the annual rainfall for that year ",null,null,null,null,"Note: this information is vital for the model to calculate leaching %"]
[]
[null,"Select ","whether or not the soil was saturated for any length of time during the course of that year "]
[null,"Select "]
[null,"Select ","crop or pasture type from the drop down list "]
[]
[null,"Enter","grain yield (t/ha) or pasture biomass (t/ha) if pasture is selected under crop type. "]
[]
[null,"Fertiliser information "]
[]
[null,"Select ","the seeding fertiliser (Fertiliser 1) type from the drop down list (if your blend is not listed use the product from the list with the closest composition made from the same base blend)"]
[]
[null,"Enter","kilograms per ha of fertiliser product applied "]
[null,"Repeat these steps for in crop nitrogen applications (Fertiliser 2). "]
[null,"If you applied multiple N applications during the season enter the total kg of product applied over the course of the season. "]
[null,"If you used a mixture of urea and S.O.A during the season selecting urea and entering the total kg of product (S.O.A + urea) will give a similar result in years where leaching is >25%"]
[null,"Note. Although sulphate of ammonia is twice as acidifying as urea per kg Nitrogen it contains roughly half the nitrogen of urea. Thus the acidifying effect per kg of product (not per kg nitrogen) is similar to urea in most years.  "]

{"sheet":"Calculation tables","index":3,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[42,3,42,4],[24,3,24,4],[2,0,3,0],[2,1,2,6]]}
["Tables used in calculations "]
[]
["Annual rainfall received","% leaching by soil texture and rainfall  "]
[null,"sand","loamy sand ","sandy loam ","loam ","clay loam","clay "]
["Less than 325 mm",0.5,0.4,0.3,0.1,0,0]
["325 - 450 mm",0.65,0.56999999999999995,0.45,0.25,0.05,0]
["450 - 550 mm",0.75,0.68,0.5,0.3,0.1,0]
["550 - 750 mm",0.8,0.7,0.6,0.4,0.2,0]
["Greater than 750 mm",0.95,0.85,0.75,0.55000000000000004,0.35,0.15]
["Saturated Soil",0.95,0.85,0.75,0.55000000000000004,0.35,0.15]
[]
["Lime replacement required due to product removal ",null,null," N fixed by legume crops and pastures (kg N/ha) "]
["Crop ","lime equivalent per tonne",null,"Crop ","Select"]
["Cereal grain",9,null,"Cereal grain",0]
["Grain legume",20,null,"Grain legume",30]
["Oilseed",2,null,"Oilseed",0]
["Pasture (grass only)",1,null,"Pasture (grass only)",0]
["Pasture (40% legume)",2,null,"Pasture (40% legume)",8]
["Pasture (60% legume)",3,null,"Pasture (60% legume)",15]
["Pasture (80% legume)",4,null,"Pasture (80% legume)",20]
["Lucerne hay",70,null,"Lucerne hay",20]
["Export oaten hay",25,null,"Export oaten hay",0]
["Clover hay",40,null,"Clover hay",20]
["Fertiliser lime equivalent (leaching adjusted)* "]
["Fertiliser ",null,"N %","Leaching %"]
["Select","Composition ","%",0,1]
["Single super","phosphorus sulphate ",0,0,0]
["Muriate of potash ","potassium chloride ",0,0,0]
["Sulphate of potash ","potassium sulphate ",0,0,0]
["ammonium nitrate ","ammonium nitrate ",34,0,3.6]
["Urea","urea ",46,0,3.6]
["UAN","urea/ammonium nitrate ",30,0,3.6]
["32:10","DAP/urea blend ",32,0.9,5.4]
["DAP ","18%N, 20% P",18,1.8,5.4]
["27:12","MAP/urea blend ",27,3.6,7.2]
["19:13","DAP/SOA blend ",19,2.7,6.3]
["MAP","10%N, 22% P",10,3.6,7.2]
["S.O.A ","ammonium sulphate ",21,3.6,7.2]
["12:17","MAP/urea Blend ",12,1.8,5.4]
["24:16","80% DAP, 20% Urea",24,1.8,3.6]
["Pasture Legume ","Legume fixed N (30 kg/t dry matter) ",30,0,3.6]
["Grain Legume ","Legume fixed N (60 kg/t grain) ",60,0,3.6]
["Other ",null,"N % from product analysis. ","Function of base fertilisers used to create blend"]
["*adjusted from Soil Guide (AgWA 1998)"]