{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calculator","DATA"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Calculator","index":0,"n_rows":67,"n_cols":5,"rows_kept":67,"cut":false,"hidden":false,"merged":[[17,0,17,2],[19,1,19,4]]}
[]
[null,null,"Zinc Distribution Model"]
[]
[null,"My crop row width is","30 cm / 12 inch"]
[]
["I want to compare dry blended product","MAP 1.0%Zn blend","with ZincStar","ZincStar 10"]
[]
[]
["Rate that I want to apply product is ",50,"kgs per ha"]
[]
[]
["Product Granule Spacing along the row is",{"$f":"100/((B9*VLOOKUP(B6,DATA!$A7:$N23,12,FALSE))/VLOOKUP(C4,DATA!$A29:$C38,3))","v":1.3761991855653217},"cm apart",{"$f":"100/((B9*VLOOKUP(D6,DATA!$A7:$N23,12,FALSE))/VLOOKUP(C4,DATA!$A29:$C38,3))","v":1.1096316023080335},"cm apart"]
[]
["Zinc granule spacing along the row is",{"$f":"100/((B9*VLOOKUP(B6,DATA!$A7:$N23,13,FALSE))/VLOOKUP(C4,DATA!$A29:$C38,3))","v":68.671885729982137},"cm apart",{"$f":"100/((B9*VLOOKUP(D6,DATA!$A7:$N23,13,FALSE))/VLOOKUP(C4,DATA!$A29:$C38,3))","v":1.1096316023080335},"cm apart"]
[]
["Number Zinc granules is",{"$f":"100/B14","v":1.4562000000000002},"per metre row",{"$f":"100/D14","v":90.120000000000019},"per metre row"]
[]
["Or at the same P rate per HA my extra Nutrient Value is",null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"Nutrients applied kg /  ha"]
[null,"N","P","S","Zn"]
[{"$f":"B6","v":"MAP 1.0%Zn blend"},{"$f":"(VLOOKUP(B6,DATA!O7:T23,3,FALSE))/100*B9","v":4.8499999999999996},{"$f":"(VLOOKUP(B6,DATA!O7:T23,4,FALSE))/100*B9","v":10.65},{"$f":"(VLOOKUP(B6,DATA!O7:T23,5,FALSE))/100*3","v":0.06},{"$f":"VLOOKUP(B6,DATA!O7:T23,6,FALSE)/100*B9","v":0.5}]
[{"$f":"D6","v":"ZincStar 10"},{"$f":"VLOOKUP(D6,DATA!O7:T23,3,FALSE)/100*B9","v":5.35},{"$f":"VLOOKUP(D6,DATA!O7:T23,4,FALSE)/100*B9","v":11.15},{"$f":"VLOOKUP(D6,DATA!O7:T23,5,FALSE)/100*B9","v":1},{"$f":"VLOOKUP(D6,DATA!O7:T23,6,FALSE)/100*B9","v":0.5}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Blend","Coat"]
[null,"Lists","Lists"]
[null,"MAP 0.5%Zn blend","ZincStar 10"]
[null,"MAP 1.0%Zn blend","ZincStar 5 Blend"]
[null,"MAP 1.5%Zn blend","ZincStar 15 Blend"]
[null,"MAP 2.0%Zn blend","ZincStar 20 Blend"]
[null,"MAP 2.5%Zn blend","ZincStar 25 Blend"]
[null,"MAP 5.0%Zn blend","ZincStar 50 Blend"]
[]
[]
[]
[]
[]
[]
[null,"List row spacings"]
[null,"17.5 cm / 7 inch"]
[null,"22.5 cm / 9 inch"]
[null,"27.5 cm / 11 inch"]
[null,"30 cm / 12 inch"]
[null,"35 cm / 14  inch"]
[null,"40 cm / 16 inch"]
[null,"45 cm / 18 inch"]
[null,"50 cm / 20 inch"]
[null,"55 cm / 22 inch"]
[null,"60 cm / 24 inch"]

{"sheet":"DATA","index":1,"n_rows":45,"n_cols":20,"rows_kept":45,"cut":false,"hidden":true,"merged":[[27,1,27,2],[4,16,4,19],[4,1,4,5],[4,6,4,10],[23,11,23,12]]}
[]
[]
[]
[]
["Granule Distribution","Blend Components",null,null,null,null,"Granules per kg",null,null,null,null,"Total Gran","Zinc","Zinc Granule",null,null,"Analysis %"]
[null,"Granulock","Urea","MAP","Zinc10","Zinc Mono","Granulock","Urea","MAP","ZincStar","Zinc Mono","per kg","Granules","Fractions",null,null,"N","P","S","Zn"]
["MAP 0.5%Zn blend",null,null,985,null,15,{"$f":"(B7/1000*$B$26)","v":0},{"$f":"(C7/1000*$C$26)","v":0},{"$f":"(D7/1000*$D$26)","v":48205.9},{"$f":"(E7/1000*$E$26)","v":0},{"$f":"(F7/1000*$F$26)","v":485.4},{"$f":"SUM(G7:K7)","v":48691.3},{"$f":"J7+K7","v":485.4},{"$f":"M7/L7","v":9.9689266871083732E-3},{"$f":"A7","v":"MAP 0.5%Zn blend"},null,9.9,21.7,1.7,0.5]
["MAP 1.0%Zn blend",null,null,970,null,30,{"$f":"(B8/1000*$B$26)","v":0},{"$f":"(C8/1000*$C$26)","v":0},47471.799999999996,{"$f":"(E8/1000*$E$26)","v":0},970.8,{"$f":"SUM(G8:K8)","v":48442.6},970.8,{"$f":"M8/L8","v":2.0040212540202218E-2},"MAP 1.0%Zn blend",null,9.6999999999999993,21.3,2,1]
["MAP 1.5%Zn blend",null,null,965,null,45,{"$f":"(B9/1000*$B$26)","v":0},{"$f":"(C9/1000*$C$26)","v":0},47227.1,{"$f":"(E9/1000*$E$26)","v":0},1456.2,48683.299999999996,1456.2,2.9911694564665917E-2,"MAP 1.5%Zn blend",null,9.6,21,2.2000000000000002,1.5]
["MAP 2.0%Zn blend",null,null,940,null,60,{"$f":"(B10/1000*$B$26)","v":0},{"$f":"(C10/1000*$C$26)","v":0},46003.6,{"$f":"(E10/1000*$E$26)","v":0},1941.6,47945.2,1941.6,4.0496233199569506E-2,"MAP 2.0%Zn blend",null,9.4,20.7,2.4,2]
["MAP 2.5%Zn blend",null,null,928,null,72,{"$f":"(B11/1000*$B$26)","v":0},{"$f":"(C11/1000*$C$26)","v":0},45416.32,{"$f":"(E11/1000*$E$26)","v":0},2329.9199999999996,47746.239999999998,2329.9199999999996,4.8797978647114403E-2,"MAP 2.5%Zn blend",null,9,20.399999999999999,2.6,2.5]
["MAP 5.0%Zn blend",null,null,855,null,145,null,null,41843.699999999997,null,4692.2,46535.899999999994,4692.2,0.10082968203043242,"MAP 5.0%Zn blend",null,8.6,18.8,3.8,5]
["ZincStar 10",null,null,null,1000,null,{"$f":"(B13/1000*$B$26)","v":0},{"$f":"(C13/1000*$C$26)","v":0},0,{"$f":"(E13/1000*$E$26)","v":60080},0,60080,60080,1,{"$f":"A13","v":"ZincStar 10"},null,10.7,22.3,2,1]
["ZincStar 5 Blend",null,null,500,500,null,0,0,24470,30040,0,54510,30040,0.5510915428361769,"ZincStar 5 Blend",null,10.4,21.8,1.8,0.5]
["ZincStar 15 Blend",null,null,null,985,15,0,0,0,59178.799999999996,485.4,59664.2,59664.2,1,"ZincStar 15 Blend",null,10.5,21.2,2,1.5]
["ZincStar 20 Blend",null,null,null,970,30,0,0,0,58277.599999999999,970.8,59248.4,59248.4,1,"ZincStar 20 Blend",null,10.4,20.9,3,2]
["ZincStar 25 Blend",null,null,null,955,45,0,0,0,57376.399999999994,1456.2,58832.599999999991,58832.599999999991,1,"ZincStar 25 Blend",null,10.199999999999999,20.6,3.5,2.5]
["ZincStar 50 Blend",null,null,null,882,118,0,0,0,52990.559999999998,3818.48,56809.04,56809.04,1,"ZincStar 50 Blend",null,9.4,19,4,5]
[null,null,null,null,null,null,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},0]
[null,null,null,null,null,null,0,0,0,0,0,0,0,{"$error":"#DIV/0!"},0]
[]
["Granule Numbers per kg",null,null,"MAP","ZincStar","Zinc Mono",null,null,null,null,null,"S","Zn"]
[null,null,null,48940,60080,32360,null,null,null,null,10,{"$f":"($S$17/100)*$K26","v":0.35000000000000003},{"$f":"($T$17/100)*$K26","v":0.25}]
[null,null,null,null,null,null,null,null,null,null,20,0.70000000000000007,0.5]
["Row Spacing","Linear Metres Row",null,null,null,null,null,null,null,null,30,1.05,0.75]
["17.5 cm / 7 inch",17.5,{"$f":"(10000/B29)*100","v":57142.857142857145},null,null,null,null,null,null,null,40,1.4000000000000001,1]
["22.5 cm / 9 inch",22.5,44444.444444444445,null,null,null,null,null,null,null,50,1.7500000000000002,1.25]
["27.5 cm / 11 inch",27.5,36363.63636363636,null,null,null,null,null,null,null,60,2.1,1.5]
["30 cm / 12 inch",30,33333.333333333328,null,null,null,null,null,null,null,70,2.4500000000000002,1.75]
["35 cm / 14  inch",35,28571.428571428572,null,null,null,null,null,null,null,80,2.8000000000000003,2]
["40 cm / 16 inch",40,25000,null,null,null,null,null,null,null,90,3.1500000000000004,2.25]
["45 cm / 18 inch",45,22222.222222222223,null,null,null,null,null,null,null,100,3.5000000000000004,2.5]
["50 cm / 20 inch",50,20000,null,null,null,null,null,null,null,110,3.8500000000000005,2.75]
["55 cm / 22 inch",55,18181.81818181818,null,null,null,null,null,null,null,120,4.2,3]
["60 cm / 24 inch",60,16666.666666666664,null,null,null,null,null,null,null,130,4.5500000000000007,3.25]
[null,null,null,null,null,null,null,null,null,null,140,4.9000000000000004,3.5]
[null,null,null,null,null,null,null,null,null,null,150,5.2500000000000009,3.75]
[null,null,null,null,null,null,null,null,null,null,160,5.6000000000000005,4]
[null,null,null,null,null,null,null,null,null,null,170,5.95,4.25]
[null,null,null,null,null,null,null,null,null,null,180,6.3000000000000007,4.5]
[null,null,null,null,null,null,null,null,null,null,190,6.65,4.75]
[null,null,null,null,null,null,null,null,null,null,200,7.0000000000000009,5]