{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Title","Lime cost comp","How to use tool ","Application rates ","ENV","data ","location of sources","Example","Sheet5","Sheet4","Sheet3","Sheet2","Notes","Sheet1"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":7,"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":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"A tool for calculating lime application rates for acidic soils and comparing the costs of lime from different suppliers. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Version ","02.06.2020"]

{"sheet":"Lime cost comp","index":1,"n_rows":55,"n_cols":22,"rows_kept":55,"cut":false,"hidden":false,"merged":[[16,12,16,13],[4,2,4,3],[16,8,16,9],[16,10,16,11],[16,14,16,15]]}
["Lime Sources Cost Comparison"]
[]
["Lime rate calculator"]
[null,null,"Enter",null,null,"Enter",null,null,null,null,null,null,null,null,null,null,null,null,"Lime rate factor"]
[null,"Paddock name",null,null,null,null,"ha",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$10=\"loam\",4,IF($D$10=\"clay loam\",4,IF($D$10=\"sandy loam\",3,IF($D$10=\"sand\",2,0))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$11=\"loam\",4,IF($D$11=\"clay loam\",4,IF($D$11=\"sandy loam\",3,IF($D$11=\"sand\",2,0))))","v":0}]
["Zone","Area","Initial","Soil ","Target ","Lime rate","Org C %","Adjusted",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$12=\"loam\",4,IF($D$12=\"clay loam\",4,IF($D$12=\"sandy loam\",3,IF($D$12=\"sand\",2,0))))","v":0}]
[null,"ha","pH (CaCl2)","Texture","pH (CaCl2)",null,null,"Lime rate",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$13=\"loam\",4,IF($D$13=\"clay loam\",4,IF($D$13=\"sandy loam\",3,IF($D$13=\"sand\",2,0))))","v":0}]
[null,"Enter","Enter","Select","Enter",null,"Select"]
[1,null,null,null,null,{"$f":"IF(B10<=0,\" \",(IF(E10>C10,+(E10-C10)*$S$5,0)))","v":" "},null,{"$f":"IF(G10=\"low\",F10-(F10*0.25),F10)","v":" "},{"$f":"IF(E10-C10>1,\"!!!\",\"  \")","v":"  "},{"$f":"IF(I10=\"!!!\",\"See application rate info\",\" \")","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($H$10*$B$10*1/I21*100),\"0\",($H$10*$B$10*1/I21*100))","v":"0"},{"$f":"IF(ISERROR($H$10*$B$10*1/K21*100),\"0\",($H$10*$B$10*1/K21*100))","v":"0"},{"$f":"IF(ISERROR($H$10*$B$10*1/M21*100),\"0\",($H$10*$B$10*1/M21*100))","v":"0"},{"$f":"IF(ISERROR($H$10*$B$10*1/O21*100),\"0\",($H$10*$B$10*1/O21*100))","v":"0"}]
[2,null,null,null,null,{"$f":"IF(B11<=0,\" \",(IF(E11>C11,+(E11-C11)*$S$6,0)))","v":" "},null,{"$f":"IF(G11=\"low\",F11-(F11*0.25),F11)","v":" "},{"$f":"IF(E11-C11>1,\"!!!\",\"  \")","v":"  "},{"$f":"IF(I11=\"!!!\",\"See application rate information\",\" \")","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($H$11*$B$11*1/I21*100),\"0\",($H$11*$B$11*1/I21*100))","v":"0"},{"$f":"IF(ISERROR($H$11*$B$11*1/K21*100),\"0\",($H$11*$B$11*1/K21*100))","v":"0"},{"$f":"IF(ISERROR($H$11*$B$11*1/M21*100),\"0\",($H$11*$B$11*1/M21*100))","v":"0"},{"$f":"IF(ISERROR($H$11*$B$11*1/O21*100),\"0\",($H$11*$B$11*1/O21*100))","v":"0"}]
[3,null,null,null,null,{"$f":"IF(B12<=0,\" \",(IF(E12>C12,+(E12-C12)*$S$7,0)))","v":" "},null," ",{"$f":"IF(E12-C12>1,\"!!!\",\"  \")","v":"  "},{"$f":"IF(I12=\"!!!\",\"See application rate information\",\" \")","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($H$12*$B$12*1/I21*100),\"0\",($H$12*$B$12*1/I21*100))","v":"0"},{"$f":"IF(ISERROR($H$12*$B$12*1/K21*100),\"0\",($H$12*$B$12*1/K21*100))","v":"0"},{"$f":"IF(ISERROR($H$12*$B$12*1/M21*100),\"0\",($H$12*$B$12*1/M21*100))","v":"0"},{"$f":"IF(ISERROR($H$12*$B$12*1/O21*100),\"0\",($H$12*$B$12*1/O21*100))","v":"0"}]
[4,null,null,null,null,{"$f":"IF(B13<=0,\" \",(IF(E13>C13,+(E13-C13)*$S$8,0)))","v":" "},null," ",{"$f":"IF(E13-C13>1,\"!!!\",\"  \")","v":"  "},{"$f":"IF(I13=\"!!!\",\"See application rate information\",\" \")","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($H$13*$B$13*1/I21*100),\"0\",($H$13*$B$13*1/I21*100))","v":"0"},{"$f":"IF(ISERROR($H$13*$B$13*1/K21*100),\"0\",($H$13*$B$13*1/K21*100))","v":"0"},{"$f":"IF(ISERROR($H$13*$B$13*1/M21*100),\"0\",($H$13*$B$13*1/M21*100))","v":"0"},{"$f":"IF(ISERROR($H$13*$B$13*1/O21*100),\"0\",($H$13*$B$13*1/O21*100))","v":"0"}]
[]
[null,{"$f":"IF((B10+B11+B13+B12)=F5,\" \",\"!!!\")","v":" "},null,null,null,null,null,null,"Lime Sources Comparison"]
[null,{"$f":"IF($B$15=\"!!!\",\"Sum of zone areas does not equal total area\",\" \")","v":" "},null,null,null,null,null,null,"Source 1",null,"Source 2",null,"Source 3 ",null,"Source 4 "]
[null,null,null,null,null,"Enter","Source"]
[]
[null,null,null,null,null,"Enter","Lime Cost $/t"]
[]
[null,null,null,null,null,null,"NV or ENV %"]
[]
[null,null,null,null,null,null,"Tonnes required ",null,{"$f":"SUM(S10:S13)","v":0},null,{"$f":"SUM(T10:T13)","v":0},null,{"$f":"SUM(U10:U13)","v":0},null,{"$f":"SUM(V10:V13)","v":0}]
[]
[]
[null,null,null,null,null,"Enter","Distance from source",null,null,"km",null,"km",null,"km",null,"km"]
[]
[null,null,null,"Either",null,"Enter","Freight cost ($/km/t)",null,null,"$/km/t",null,"$/km/t",null,"$/km/t",null,"$/km/t"]
[]
[null,null,null,null,null,null,null,null,{"$f":"(I26*I28)","v":0},"$/t",{"$f":"(K26*K28)","v":0},"$/t",{"$f":"(M26*M28)","v":0},"$/t",{"$f":"(O26*O28)","v":0},"$/t"]
[]
[null,null,null,null,null,"Enter","Spreading cost",null,null,"$/ha",null,"$/ha",null,"$/ha",null,"$/ha"]
[null,null,null,null,null,null,null,null,null,{"$f":"+I32*($F$5/I23)","v":{"$error":"#DIV/0!"}},null,{"$f":"+K32*($F$5/K23)","v":{"$error":"#DIV/0!"}},null,{"$f":"+M32*($F$5/M23)","v":{"$error":"#DIV/0!"}},null,{"$f":"+O32*($F$5/O23)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"     Or",null,"Enter","Contract F&S cost",null,null,"$/t",null,"$/t",null,"$/t",null,"$/t"]
[]
[null,null,null,null,null,null,"Total $/t",null,{"$f":"IF(ISERROR(I19+I30+J33+I34),\"  \",(I19+I30+J33+I34))","v":"  "},null,{"$f":"IF(ISERROR(K19+K30+L33+K34),\"  \",((K19+K30+L33+K34)))","v":"  "},null,{"$f":"IF(ISERROR(M19+M30+N33+M34),\"  \",((M19+M30+N33+M34)))","v":"  "},null,{"$f":"IF(ISERROR(O19+O30+P33+O34),\"  \",((O19+O30+P33+O34)))","v":"  "}]
[]
[null,null,null,null,null,null,"Product rate & cost",null," Rate t/ha","Cost $/ha","Rate t/ha","Cost $/ha","Rate t/ha","Cost $/ha","Rate t/ha","Cost $/ha"]
[null,null,null,null,null,null,"Zone 1",null,{"$f":"VALUE(S52)","v":0},{"$f":"I39*$I$36","v":{"$error":"#VALUE!"}},{"$f":"VALUE(T52)","v":0},{"$f":"K39*$K$36","v":{"$error":"#VALUE!"}},{"$f":"VALUE(U52)","v":0},{"$f":"M39*$M$36","v":{"$error":"#VALUE!"}},{"$f":"VALUE(V52)","v":0},{"$f":"O39*$O$36","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,"Zone 2",null,{"$f":"VALUE(S53)","v":0},{"$f":"I40*$I$36","v":{"$error":"#VALUE!"}},{"$f":"VALUE(T53)","v":0},{"$f":"K40*$K$36","v":{"$error":"#VALUE!"}},{"$f":"VALUE(U53)","v":0},{"$f":"M40*$M$36","v":{"$error":"#VALUE!"}},{"$f":"VALUE(V53)","v":0},{"$f":"O40*$O$36","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,"Zone 3",null,{"$f":"VALUE(S54)","v":0},{"$f":"I41*$I$36","v":{"$error":"#VALUE!"}},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,"Zone 4",null,0,{"$f":"I42*$I$36","v":{"$error":"#VALUE!"}},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,"Paddock",null,null,{"$f":"I45/$F$5","v":{"$error":"#VALUE!"}},null,{"$f":"K45/$F$5","v":{"$error":"#VALUE!"}},null,{"$f":"M45/$F$5","v":{"$error":"#VALUE!"}},null,{"$f":"O45/$F$5","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,null,null,"Cost per paddock",null,{"$f":"IF(ISERROR(($B$10*J39)+($B$11*J40)+($B$12*J41)+($B$13*J42)),\"  \",($B$10*J39)+($B$11*J40)+($B$12*J41)+($B$13*J42))","v":"  "},null,{"$f":"IF(ISERROR(($B$10*L39)+($B$11*L40)+($B$12*L41)+($B$13*L42)),\"  \",($B$10*L39)+($B$11*L40)+($B$12*L41)+($B$13*L42))","v":"  "},null,{"$f":"IF(ISERROR(($B$10*N39)+($B$11*N40)+($B$12*N41)+($B$13*N42)),\"  \",($B$10*N39)+($B$11*N40)+($B$12*N41)+($B$13*N42))","v":"  "},null,{"$f":"IF(ISERROR(($B$10*P39)+($B$11*P40)+($B$12*P41)+($B$13*P42)),\"  \",($B$10*P39)+($B$11*P40)+($B$12*P41)+($B$13*P42))","v":"  "}]
[]
[null,null,null,null,null,null,"Quantity of lime t",null,{"$f":"SUM(S47:S50)","v":0},null,{"$f":"SUM(T47:T50)","v":0},null,{"$f":"SUM(U47:U50)","v":0},null,{"$f":"SUM(V47:V50)","v":0},null,null,null,{"$f":"IF(ISERROR(I39*$B$10),\"0\",(I39*$B$10))","v":0},{"$f":"IF(ISERROR(K39*$B$10),\"0\",(K39*$B$10))","v":0},{"$f":"IF(ISERROR(M39*$B$10),\"0\",(M39*$B$10))","v":0},{"$f":"IF(ISERROR(O39*$B$10),\"0\",(O39*$B$10))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I40*$B$11),\"0\",(I40*$B$11))","v":0},{"$f":"IF(ISERROR(K40*$B$11),\"0\",(K40*$B$11))","v":0},{"$f":"IF(ISERROR(M40*$B$11),\"0\",(M40*$B$11))","v":0},{"$f":"IF(ISERROR(O40*$B$11),\"0\",(O40*$B$11))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I41*$B$12),\"0\",(I41*$B$12))","v":0},{"$f":"IF(ISERROR(K41*$B$12),\"0\",(K41*$B$12))","v":0},{"$f":"IF(ISERROR(M41*$B$12),\"0\",(M41*$B$12))","v":0},{"$f":"IF(ISERROR(O41*$B$12),\"0\",(O41*$B$12))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I42*$B$13),\"0\",(I42*$B$13))","v":0},{"$f":"IF(ISERROR(K42*$B$13),\"0\",(K42*$B$13))","v":0},{"$f":"IF(ISERROR(M42*$B$13),\"0\",(M42*$B$13))","v":0},{"$f":"IF(ISERROR(O42*$B$13),\"0\",(O42*$B$13))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($H$10*100/$I$21),\"0\",($H$10*100/$I$21))","v":"0"},{"$f":"IF(ISERROR($H$10*100/$K$21),\"0\",($H$10*100/$K$21))","v":"0"},{"$f":"IF(ISERROR($H$10*100/$M$21),\"0\",($H$10*100/$M$21))","v":"0"},{"$f":"IF(ISERROR($H$10*100/$O$21),\"0\",($H$10*100/$O$21))","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($H$11*100/$I$21),\"0\",($H$11*100/$I$21))","v":"0"},{"$f":"IF(ISERROR($H$11*100/$K$21),\"0\",($H$11*100/$K$21))","v":"0"},{"$f":"IF(ISERROR($H$11*100/$M$21),\"0\",($H$11*100/$M$21))","v":"0"},{"$f":"IF(ISERROR($H$11*100/$O$21),\"0\",($H$11*100/$O$21))","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($H$12*100/$I$21),\"0\",($H$12*100/$I$21))","v":"0"},{"$f":"IF(ISERROR($H$12*100/$K$21),\"0\",($H$12*100/$K$21))","v":"0"},{"$f":"IF(ISERROR($H$12*100/$M$21),\"0\",($H$12*100/$M$21))","v":"0"},{"$f":"IF(ISERROR($H$12*100/$O$21),\"0\",($H$12*100/$O$21))","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($H$13*100/$I$21),\"0\",($H$13*100/$I$21))","v":"0"},{"$f":"IF(ISERROR($H$13*100/$K$21),\"0\",($H$13*100/$K$21))","v":"0"},{"$f":"IF(ISERROR($H$13*100/$M$21),\"0\",($H$13*100/$M$21))","v":"0"},{"$f":"IF(ISERROR($H$13*100/$O$21),\"0\",($H$13*100/$O$21))","v":"0"}]

{"sheet":"How to use tool ","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Application rates ","index":3,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["Lime application rates:"]
["!!!","Check application rate information"]
[]
["Nutrient deficiencies, particularly manganese, can occur if too much lime is applied at once, especially if the lime is not incorporated into the topsoil."]
["As a general guide, single applications of pure lime (Neutralising Value 100%) should not exceed 2.0 t/ha for a sand; 3.0 t/ha for a sandy loam; and 4.0 t/ha for a loam to clay loam soil."]
["If more lime than this is required to lift pH to the desired level, then split applications over a period of years might be appropriate."]
["If rates higher than this are used, consideration should be given to mixing the lime into the soil with a tine or disc implement."]
["To avoid exceeding these rates in the calculator, lower the target pH until the warning message disappears."]
["Soils prone to nutrient deficiencies should be monitored and fertilised accordingly after liming."]
["Soils with low organic carbon levels have low buffering capacity and can be affected by overliming. "]
["When a “low” organic carbon percentage is selected in the calculator, the lime rate is adjusted accordingly."]

{"sheet":"ENV","index":4,"n_rows":26,"n_cols":1,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["Lime Effectiveness:"]
["NV or ENV %"]
[]
["The effectiveness of lime in neutralising acidity depends on a number of factors including purity, chemical composition, density, coarseness and surface area of particles of liming materials."]
[]
["The purity or quality is the proportion of liming materials in the substrate material, in particular the proportions of calcium and magnesium carbonates. More porous materials will generally "]
["react more quickly than denser ones, and lime particles with a greater surface area will provide more opportunities for chemical reactions to take place with acidic elements in the soil. "]
["Coarser liming materials tend to have less total particle surface area than finer ones."]
[]
["Neutralising Value is the analysis of the chemical composition of a liming material, particularly the proportions of calcium and magnesium carbonates. It is expressed as a comparison to the"]
[" effectiveness of pure calcium carbonate which has an NV of 100."]
[]
["Effective Neutralising Value laboratory analysis usually is based on NV and coarseness (particle size distribution)."]
[]
["An ENV analysis of liming materials from different sources can yield similar ENV results however more porous materials can still be more effective in neutralising materials than denser ones. "]
["Therefore ENV is more useful in comparing products from a similar source (eg ground limes with ground limes) rather than from different ones."]
[]
["Be careful when entering NV or ENV values that consistent measures are used to compare different products."]

{"sheet":"data ","index":5,"n_rows":25,"n_cols":31,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[null,4,null,null,null,null,"Select from list",null,null,null,null,null,null,null,"Source","Product","Year",null,null,null,null,"NV",null,null,null,null,null,null,null,"Direct cost ","Comments "]
[null,4.5,null,"loam",null,null,"Agricola: YP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(%)",null,null,null,null,null,null,null,"$/t"]
[null,5,null,"clay loam",null,null,"Agricola: Robe",null,null,null,null,null,null,null,"Agricola: YP",null,"Dolomite ",null,null,null,null,99,null,null,null,null,null,null,null,54]
[null,5.5,null,"sandy loam",null,null,"Agricola: SC",null,null,null,null,null,null,null,"Agricola: Robe",null,"Lime ",null,null,null,null,85,null,null,null,null,null,null,null,20]
[null,6,null,"sand",null,null,"Brian Foster",null,null,null,null,null,null,null,"Agricola: SC",null,"Magnesite ",null,null,null,null,85,null,null,null,null,null,null,null,52]
[null,null,null,null,null,null,"Bruce Teagle",null,null,null,null,null,null,null,"Brian Foster",null,"Limesand",null,null,null,null,97,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,"Cawtes",null,null,null,null,null,null,null,"Bruce Teagle",null,"Limestone",null,null,null,null,82,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,"Clare Quarry",null,null,null,null,null,null,null,"Cawtes",null,"Limestone",null,null,null,null,73,null,null,null,null,null,null,null,45]
["low",null,null,null,null,null,"GEM (Burnda)",null,null,null,null,null,null,null,"Clare Quarry",null,"Limestone",null,null,null,null,65,null,null,null,null,null,null,null,9.5]
["med ",null,null,null,null,null,"GEM (Martes)",null,null,null,null,null,null,null,"GEM (Burnda)",null,"Dolomite",null,null,null,null,104,null,null,null,null,null,null,null,21]
["high",null,null,null,null,null,"GEM (Telford)",null,null,null,null,null,null,null,"GEM (Martes)",null,"Limestone",null,null,null,null,97,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,"Goolwa",null,null,null,null,null,null,null,"GEM (Telford)",null,"Limestone",null,null,null,null,98,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,"Halloran",null,null,null,null,null,null,null,"Goolwa",null,"Limestone",null,null,null,null,81,null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,"Henschke",null,null,null,null,null,null,null,"Halloran",null,"Limesand",null,null,null,null,83,null,null,null,null,null,null,null,7]
["wheat (sens)",null,null,null,null,null,"Bruhns MGL",null,null,null,null,null,null,null,"Henschke",null,"Limestone",null,null,null,null,97,null,null,null,null,null,null,null,20]
["wheat (tol)",null,null,null,null,null,"Little Sahara",null,null,null,null,null,null,null,"Bruhns MGL",null,"Limestone",null,null,null,null,97,null,null,null,null,null,null,null,18]
["barley",null,null,null,null,null,"PenLime (Angaston)",null,null,null,null,null,null,null,"Little Sahara",null,"Limesand",null,null,null,null,77,null,null,null,null,null,null,null,7]
["triticale",null,null,null,null,null,"Whitehead",null,null,null,null,null,null,null,"PenLime (Angaston)",null,"Limestone",null,null,null,null,82,null,null,null,null,null,null,null,29]
["beans",null,null,null,null,null,"Sibelco (Caroline)",null,null,null,null,null,null,null,"Whitehead",null,"Dolomite",null,null,null,null,99,null,null,null,null,null,null,null,25]
["canola",null,null,null,null,null,"Sibleco (Tant)",null,null,null,null,null,null,null,"Sibelco (Caroline)",null,"Limestone",null,null,null,null,92,null,null,null,null,null,null,null,25]
["field pea",null,null,null,null,null,"Southern Quarry",null,null,null,null,null,null,null,"Sibleco (Tant)",null,"Dolomite",null,null,null,null,97,null,null,null,null,null,null,null,29.5]
["chick pea",null,null,null,null,null,null,null,null,null,null,null,null,null,"Southern Quarry",null,"Limestone",null,null,null,null,88,null,null,null,null,null,null,null,"Resell only"]
["lentils"]
["pasture (sens)"]
["pasture (tol)"]

{"sheet":"location of sources","index":6,"n_rows":38,"n_cols":16,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"Location of main lime sources in SA"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Note:"]
[null,null,null,null,null,null,null,null,null,null,"This information is a guide only and is based on data available at the time of development. "]
[null,null,null,null,null,null,null,null,null,null,"For more accurate, up-to date information and prices, contact the suppliers.  "]
[]
[null,null,null,null,null,null,null,null,null,null,"Current and potential lime sources ",null,"NV%","ENV%","ENV%","Type"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Est. ws*"]
[null,null,null,null,null,null,null,null,null,null,1,"Adelaide Brighton Cement Ltd: Penrice",98,91,null,"Limestone"]
[null,null,null,null,null,null,null,null,null,null,2,"Adelaide Brighton Cement Ltd: Southern Quarries",90,90,null,"Limestone"]
[null,null,null,null,null,null,null,null,null,null,3,"Agricola Mining Pty Ltd: Daly Head",99,52,104,"Dolomite"]
[null,null,null,null,null,null,null,null,null,null,4,"Agricola Mining Pty Ltd: Kongorong",100,80,null,"Limestone"]
[null,null,null,null,null,null,null,null,null,null,5,"Agricola Mining Pty Ltd: Robe",82,36,72,"Limestone"]
[null,null,null,null,null,null,null,null,null,null,6,"Agricola Mining Pty Ltd: Salt Creek ",85,27,null,"Magnesite"]
[null,null,null,null,null,null,null,null,null,null,7,"Brian Foster",97,77,null,"Limesand"]
[null,null,null,null,null,null,null,null,null,null,8,"Bruce Teagle Nomineees Pty Ltd",97,80,null,"Limestone"]
[null,null,null,null,null,null,null,null,null,null,9,"Cawte's Ag Lime Pty Ltd",73,55,null,"Limestone"]
[null,null,null,null,null,null,null,null,null,null,10,"Clare Quarry Pty Ltd",50,48,null,"Limestone"]
[null,null,null,null,null,null,null,null,null,null,11,"Cleve",68,30,null,"Limestone"]
[null,null,null,null,null,null,null,null,null,null,12,"DK Quarries Pty Ltd",100,76,null,"Limesand"]
[null,null,null,null,null,null,null,null,null,null,13,"Emu Bay Limesand",42,36,null,"Limesand"]
[null,null,null,null,null,null,null,null,null,null,14,"EP Limesand",94,71,null,"Limesand"]
[null,null,null,null,null,null,null,null,null,null,15,"Gambier Earth Movers Pty Ltd: Burnda Rd",104,79,null,"Dolomite"]
[null,null,null,null,null,null,null,null,null,null,16,"Gambier Earth Movers Pty Ltd: Marte's Quarry",97,48,null,"Limestone"]
[null,null,null,null,null,null,null,null,null,null,17,"Gambier Earth Movers Pty Ltd: Telford's Quarry",98,77,null,"Limestone"]
[null,null,null,null,null,null,null,null,null,null,18,"Goolwa Quarries Pty Ltd",81,35,null,"Limestone"]
[null,null,null,null,null,null,null,null,null,null,19,"Halloran Earthmovers",71,55,null,"Limesand"]
[null,null,null,null,null,null,null,null,null,null,20,"Henschke Industries Pty Ltd",97,70,null,"Limestone"]
[null,null,null,null,null,null,null,null,null,null,21,"Kulpara Mine",91,57,null,"Dolomite"]
[null,null,null,null,null,null,null,null,null,null,22,"Mt Gambier Limestone: Bruhns",100,78,null,"Limestone"]
[null,null,null,null,null,null,null,null,null,null,23,"Osier Pty Ltd (Little Sahara)",83,68,null,"Limesand"]
[null,null,null,null,null,null,null,null,null,null,24,"Peter Whitehead Pty Ltd",99,73,null,"Dolomite"]
[null,null,null,null,null,null,null,null,null,null,25,"Sibelco Australia Ltd: Caroline",92,67,null,"Limestone"]
[null,null,null,null,null,null,null,null,null,null,26,"Sibelco Australia Ltd: Tantanooola",97,81,null,"Dolomite"]
[null,null,null,null,null,null,null,null,null,null,27,"Wiseman Limesand ",90,72,null,"Limesand"]
[null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"*ENV%  Est. ws = ENV Calculated using wet sieving"]

{"sheet":"Example","index":7,"n_rows":50,"n_cols":22,"rows_kept":50,"cut":false,"hidden":false,"merged":[[4,2,4,3],[16,8,16,9],[16,10,16,11],[16,12,16,13],[16,14,16,15]]}
["Lime Sources Cost Comparison",null,null,null,"Example"]
[]
["Lime rate calculator"]
[null,null,"Enter",null,null,"Enter",null,null,null,null,null,null,null,null,null,null,null,null,"Lime rate factor"]
[null,"Paddock name","Fortune",null,null,120,"ha",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$10=\"loam\",4,IF($D$10=\"clay loam\",4,IF($D$10=\"sandy loam\",3,IF($D$10=\"sand\",2,0))))","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$11=\"loam\",4,IF($D$11=\"clay loam\",4,IF($D$11=\"sandy loam\",3,IF($D$11=\"sand\",2,0))))","v":2}]
["Zone","Area","Initial","Soil ","Target ","Lime rate","Org C %","Adjusted",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$12=\"loam\",4,IF($D$12=\"clay loam\",4,IF($D$12=\"sandy loam\",3,IF($D$12=\"sand\",2,0))))","v":3}]
[null,"ha","pH (CaCl2)","Texture","pH (CaCl2)",null,null,"Lime rate",null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$13=\"loam\",4,IF($D$13=\"clay loam\",4,IF($D$13=\"sandy loam\",3,IF($D$13=\"sand\",2,0))))","v":4}]
[null,"Enter","Enter","Select","Enter",null,"Select"]
[1,20,4.2,"loam",5.5,{"$f":"IF(B10<=0,\" \",(IF(E10>C10,+(E10-C10)*$S$5,0)))","v":5.1999999999999993},"med ",{"$f":"IF(G10=\"low\",F10-(F10*0.25),F10)","v":5.1999999999999993},{"$f":"IF(E10-C10>1,\"!!!\",\"  \")","v":"!!!"},{"$f":"IF(I10=\"!!!\",\"See application rate info\",\" \")","v":"See application rate info"},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($H$10*$B$10*1/I21*100),\"0\",($H$10*$B$10*1/I21*100))","v":182.45614035087715},{"$f":"IF(ISERROR($H$10*$B$10*1/K21*100),\"0\",($H$10*$B$10*1/K21*100))","v":114.28571428571428},{"$f":"IF(ISERROR($H$10*$B$10*1/M21*100),\"0\",($H$10*$B$10*1/M21*100))","v":116.85393258426964},{"$f":"IF(ISERROR($H$10*$B$10*1/O21*100),\"0\",($H$10*$B$10*1/O21*100))","v":144.44444444444443}]
[2,25,4.2,"sand",5.2,{"$f":"IF(B11<=0,\" \",(IF(E11>C11,+(E11-C11)*$S$6,0)))","v":2},"low",{"$f":"IF(G11=\"low\",F11-(F11*0.25),F11)","v":1.5},{"$f":"IF(E11-C11>1,\"!!!\",\"  \")","v":"  "},{"$f":"IF(I11=\"!!!\",\"See application rate information\",\" \")","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($H$11*$B$11*1/I21*100),\"0\",($H$11*$B$11*1/I21*100))","v":65.789473684210535},{"$f":"IF(ISERROR($H$11*$B$11*1/K21*100),\"0\",($H$11*$B$11*1/K21*100))","v":41.208791208791204},{"$f":"IF(ISERROR($H$11*$B$11*1/M21*100),\"0\",($H$11*$B$11*1/M21*100))","v":42.134831460674157},{"$f":"IF(ISERROR($H$11*$B$11*1/O21*100),\"0\",($H$11*$B$11*1/O21*100))","v":52.083333333333336}]
[3,35,4.5,"sandy loam",5.5,{"$f":"IF(B12<=0,\" \",(IF(E12>C12,+(E12-C12)*$S$7,0)))","v":3},"low",2.25,{"$f":"IF(E12-C12>1,\"!!!\",\"  \")","v":"  "},{"$f":"IF(I12=\"!!!\",\"See application rate information\",\" \")","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($H$12*$B$12*1/I21*100),\"0\",($H$12*$B$12*1/I21*100))","v":138.15789473684211},{"$f":"IF(ISERROR($H$12*$B$12*1/K21*100),\"0\",($H$12*$B$12*1/K21*100))","v":86.538461538461547},{"$f":"IF(ISERROR($H$12*$B$12*1/M21*100),\"0\",($H$12*$B$12*1/M21*100))","v":88.483146067415731},{"$f":"IF(ISERROR($H$12*$B$12*1/O21*100),\"0\",($H$12*$B$12*1/O21*100))","v":109.375}]
[4,40,6,"loam",5.5,{"$f":"IF(B13<=0,\" \",(IF(E13>C13,+(E13-C13)*$S$8,0)))","v":0},"med ",0,{"$f":"IF(E13-C13>1,\"!!!\",\"  \")","v":"  "},{"$f":"IF(I13=\"!!!\",\"See application rate information\",\" \")","v":" "},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR($H$13*$B$13*1/I21*100),\"0\",($H$13*$B$13*1/I21*100))","v":0},{"$f":"IF(ISERROR($H$13*$B$13*1/K21*100),\"0\",($H$13*$B$13*1/K21*100))","v":0},{"$f":"IF(ISERROR($H$13*$B$13*1/M21*100),\"0\",($H$13*$B$13*1/M21*100))","v":0},{"$f":"IF(ISERROR($H$13*$B$13*1/O21*100),\"0\",($H$13*$B$13*1/O21*100))","v":0}]
[]
[null,{"$f":"IF((B10+B11+B13+B12)=F5,\" \",\"!!!\")","v":" "},null,null,null,null,null,null,"Lime Sources Comparison"]
[null,{"$f":"IF($B$15=\"!!!\",\"Sum of zone areas does not equal total area\",\" \")","v":" "},null,null,null,null,null,null,"Source 1",null,"Source 2",null,"Source 3 ",null,"Source 4 "]
[null,null,null,null,null,"Enter","Source",null,"Kulpara",null,"Angaston",null,"New mine",null,"Agricola Robe"]
[]
[null,null,null,null,null,"Enter","Lime Cost $/t",null,16,null,26,null,24]
[]
[null,null,null,null,null,null,"NV or ENV %",null,57,null,91,null,89,null,72]
[]
[null,null,null,null,null,null,"Tonnes required ",null,{"$f":"SUM(S10:S13)","v":386.40350877192975},null,{"$f":"SUM(T10:T13)","v":242.03296703296704},null,{"$f":"SUM(U10:U13)","v":247.47191011235952},null,{"$f":"SUM(V10:V13)","v":305.90277777777777}]
[]
[]
[null,null,null,null,null,"Enter","Distance from source",null,150,"km",171,"km",null,"km",null,"km"]
[]
[null,null,null,"Either",null,"Enter","Freight cost ($/km/t)",null,0.18,"$/km/t",0.18,"$/km/t",null,"$/km/t",null,"$/km/t"]
[]
[null,null,null,null,null,null,null,null,{"$f":"(I26*I28)","v":27},"$/t",{"$f":"(K26*K28)","v":30.779999999999998},"$/t",{"$f":"(M26*M28)","v":0},"$/t",{"$f":"(O26*O28)","v":0},"$/t"]
[]
[null,null,null,null,null,"Enter","Spreading cost",null,12,"$/ha",12,"$/ha",null,"$/ha",12,"$/ha"]
[null,null,null,null,null,null,null,null,null,{"$f":"+I32*($F$5/I23)","v":3.7266742338251992},null,{"$f":"+K32*($F$5/K23)","v":5.9496027241770717},null,{"$f":"+M32*($F$5/M23)","v":0},null,{"$f":"+O32*($F$5/O23)","v":4.7073779795686725}]
[null,null,null,"     Or",null,"Enter","Contract F&S cost",null,null,"$/t",null,"$/t",30,"$/t",70,"$/t"]
[]
[null,null,null,null,null,null,"Total $/t",null,{"$f":"IF(ISERROR(I19+I30+J33+I34),\"  \",(I19+I30+J33+I34))","v":46.7266742338252},null,{"$f":"IF(ISERROR(K19+K30+L33+K34),\"  \",((K19+K30+L33+K34)))","v":62.72960272417707},null,{"$f":"IF(ISERROR(M19+M30+N33+M34),\"  \",((M19+M30+N33+M34)))","v":54},null,{"$f":"IF(ISERROR(O19+O30+P33+O34),\"  \",((O19+O30+P33+O34)))","v":74.707377979568676}]
[]
[null,null,null,null,null,null,"Product rate & cost",null," Rate t/ha","Cost $/ha","Rate t/ha","Cost $/ha","Rate t/ha","Cost $/ha","Rate t/ha","Cost $/ha"]
[null,null,null,null,null,null,"Zone 1",null,{"$f":"IF(ISERROR($H$10*100/$I$21),\"  \",($H$10*100/$I$21))","v":9.1228070175438578},{"$f":"I39*$I$36","v":426.2784316068263},{"$f":"IF(ISERROR($H$10*100/$K$21),\"  \",($H$10*100/$K$21))","v":5.7142857142857126},{"$f":"K39*$K$36","v":358.45487270958313},{"$f":"IF(ISERROR($H$10*100/$M$21),\"  \",($H$10*100/$M$21))","v":5.8426966292134814},{"$f":"M39*$M$36","v":315.505617977528},{"$f":"IF(ISERROR($H$10*100/$O$21),\"  \",($H$10*100/$O$21))","v":7.2222222222222205},{"$f":"O39*$O$36","v":539.55328540799587}]
[null,null,null,null,null,null,"Zone 2",null,{"$f":"IF(ISERROR($H$11*100/$I$21),\"  \",($H$11*100/$I$21))","v":2.6315789473684212},{"$f":"I40*$I$36","v":122.96493219427686},{"$f":"IF(ISERROR($H$11*100/$K$21),\"  \",($H$11*100/$K$21))","v":1.6483516483516483},{"$f":"K40*$K$36","v":103.40044405084132},{"$f":"IF(ISERROR($H$11*100/$M$21),\"  \",($H$11*100/$M$21))","v":1.6853932584269662},{"$f":"M40*$M$36","v":91.011235955056179},{"$f":"IF(ISERROR($H$11*100/$O$21),\"  \",($H$11*100/$O$21))","v":2.0833333333333335},{"$f":"O40*$O$36","v":155.64037079076809}]
[null,null,null,null,null,null,"Zone 3",null,{"$f":"IF(ISERROR($H$12*100/$I$21),\"  \",($H$12*100/$I$21))","v":3.9473684210526314},{"$f":"I41*$I$36","v":184.44739829141525},{"$f":"IF(ISERROR($H$12*100/$K$21),\"  \",($H$12*100/$K$21))","v":2.4725274725274726},155.100666076262,{"$f":"IF(ISERROR($H$12*100/$M$21),\"  \",($H$12*100/$M$21))","v":2.5280898876404496},136.51685393258427,{"$f":"IF(ISERROR($H$12*100/$O$21),\"  \",($H$12*100/$O$21))","v":3.125},233.4605561861521]
[null,null,null,null,null,null,"Zone 4",null,{"$f":"IF(ISERROR($H$13*100/$I$21),\"  \",($H$13*100/$I$21))","v":0},{"$f":"I42*$I$36","v":0},{"$f":"IF(ISERROR($H$13*100/$K$21),\"  \",($H$13*100/$K$21))","v":0},0,{"$f":"IF(ISERROR($H$13*100/$M$21),\"  \",($H$13*100/$M$21))","v":0},0,{"$f":"IF(ISERROR($H$13*100/$O$21),\"  \",($H$13*100/$O$21))","v":0},0]
[null,null,null,null,null,null,"Paddock",null,null,{"$f":"I45/$F$5","v":150.46125730994152},null,{"$f":"K45/$F$5","v":126.52193223443221},null,{"$f":"M45/$F$5","v":111.36235955056178},null,{"$f":"O45/$F$5","v":190.44328703703701}]
[]
[null,null,null,null,null,null,"Cost per paddock",null,{"$f":"IF(ISERROR(($B$10*J39)+($B$11*J40)+($B$12*J41)+($B$13*J42)),\"  \",($B$10*J39)+($B$11*J40)+($B$12*J41)+($B$13*J42))","v":18055.350877192981},null,{"$f":"IF(ISERROR(($B$10*L39)+($B$11*L40)+($B$12*L41)+($B$13*L42)),\"  \",($B$10*L39)+($B$11*L40)+($B$12*L41)+($B$13*L42))","v":15182.631868131866},null,{"$f":"IF(ISERROR(($B$10*N39)+($B$11*N40)+($B$12*N41)+($B$13*N42)),\"  \",($B$10*N39)+($B$11*N40)+($B$12*N41)+($B$13*N42))","v":13363.483146067414},null,{"$f":"IF(ISERROR(($B$10*P39)+($B$11*P40)+($B$12*P41)+($B$13*P42)),\"  \",($B$10*P39)+($B$11*P40)+($B$12*P41)+($B$13*P42))","v":22853.194444444442}]
[]
[null,null,null,null,null,null,"Quantity of lime t",null,{"$f":"SUM(S47:S50)","v":386.40350877192975},null,{"$f":"SUM(T47:T50)","v":242.03296703296701},null,{"$f":"SUM(U47:U50)","v":247.47191011235952},null,{"$f":"SUM(V47:V50)","v":305.90277777777771},null,null,null,{"$f":"IF(ISERROR(I39*$B$10),\"0\",(I39*$B$10))","v":182.45614035087715},{"$f":"IF(ISERROR(K39*$B$10),\"0\",(K39*$B$10))","v":114.28571428571425},{"$f":"IF(ISERROR(M39*$B$10),\"0\",(M39*$B$10))","v":116.85393258426963},{"$f":"IF(ISERROR(O39*$B$10),\"0\",(O39*$B$10))","v":144.4444444444444}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I40*$B$11),\"0\",(I40*$B$11))","v":65.789473684210535},{"$f":"IF(ISERROR(K40*$B$11),\"0\",(K40*$B$11))","v":41.208791208791204},{"$f":"IF(ISERROR(M40*$B$11),\"0\",(M40*$B$11))","v":42.134831460674157},{"$f":"IF(ISERROR(O40*$B$11),\"0\",(O40*$B$11))","v":52.083333333333336}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I41*$B$12),\"0\",(I41*$B$12))","v":138.15789473684211},{"$f":"IF(ISERROR(K41*$B$12),\"0\",(K41*$B$12))","v":86.538461538461547},{"$f":"IF(ISERROR(M41*$B$12),\"0\",(M41*$B$12))","v":88.483146067415731},{"$f":"IF(ISERROR(O41*$B$12),\"0\",(O41*$B$12))","v":109.375}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(I42*$B$13),\"0\",(I42*$B$13))","v":0},{"$f":"IF(ISERROR(K42*$B$13),\"0\",(K42*$B$13))","v":0},{"$f":"IF(ISERROR(M42*$B$13),\"0\",(M42*$B$13))","v":0},{"$f":"IF(ISERROR(O42*$B$13),\"0\",(O42*$B$13))","v":0}]

{"sheet":"Sheet5","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet4","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet3","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet2","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Notes","index":12,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["Version"]
[]
["09.12.16","M-AY","Updated NV and Env data Penrice at request of Hamish Weston, Penrice. APAL analysis provided"]
[]
["21.01.2017","M-AY","Updated NPV and ENV Southern Quarries; deleted \"Adelaide Brighton Cement\" from Southern Quarries' name at request of Adam Staltari Southern Quarries. APAL analysis provided"]
[null,null,"Included cautionary note on ENV/NV information tab regarding consistent use of NV or ENV values."]
[]
["27.01.2017","M-AY","Added Print Macro"]
[]
["31.01.2017","M-AY","Changed formula in rate calculator so 0 ha doesn't generate lime rate."]
[null,null,"Added \"Clear rate calculator\" and \"Clear sources comparison\" buttons / macros"]
[null,null,"Realigned information and command buttons"]
[]
["06.03.2017","M-AY","Error reported by Roger Cox and Steve Richmond - if data not entered for all zones, \"0\" in ISERROR formulae generate errors in addition of zone cell data."]
[null,null,"ISERROR formulae removed, conditional formatting used to blank out #value messages and 0 returns in cells."]
[]
["22.03.2017","M-AY","Added in example sheet"]
[]
["08.05.2017","M-AY","Formatting \"  \" in if statements resulting in blank \"cost per paddock\" cell. Changed \"  \" to \"0\" in zone / rate t/ha cells in formulae."]
[null,null,"Created table S52 - copied formulae to here; inserted value formulae in zone/rate t/ha table and conditonally formatted."]
[]
["10.01.2018","M-AY","Updated Adelaide Brighton Cement Penrice ENV values for product \"Penlime Plus\" as per APAL analysis 16.06.17."]
[null,null,"Added note in \"How to use tool\" tab regarding seeking advice from suppliers on prices and products."]
[]
["02.06.2020","M-AY","Replaced GRDC logo with newer version; removed PIRSA Premium Clean Environment Logo; changed DEWNR logo to DEW logo."]
[null,null,"Updated version date."]
[null,null,"Added $/t/km to freight cost input tab on calculator and example"]
[null,null,"Changed wording in ENV sheet - replaced word \"components\" with \"carbonates\"."]
[null,null,"Location of lime sources - replaced map and table with updated versions provided by APH."]
[null,null,"Example - changed order of examples; added bubble to explain how \"supply and transport\" cost worked in calculations. Deleted Salt Creek example, replaced with Agricola Robe. "]

{"sheet":"Sheet1","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}