{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":30,"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":"Sheet1","index":0,"n_rows":29,"n_cols":34,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[null,null,"Developed by: Shane Janzen "]
[]
["Legend"]
["Input Cells",null,null,"Imperial",null,null,"Metric",null,null,"N","P","K","S",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min cost"]
["Output Cells",null,"Total Acres ",25,null,"Total Hectares",{"$f":"D5/2.47105","v":10.117156674288259},null,"Desired Blend (lbs/ac)",75,50,20,15,null,null,null,null,null,null,null,null,null,null,null,null,"Price (per lbs)",{"$f":"N17*0.98420653/2240","v":0.18673561395089289},{"$f":"N18*0.98420653/2240","v":0.2768080865625},{"$f":"N19*0.98420653/2240","v":0.19772006183035715},{"$f":"N20*0.98420653/2240","v":0.19772006183035715},{"$f":"N21*0.98420653/2240","v":0.20211384098214286},null,null,{"$f":"SUMPRODUCT(AA5:AE5,AA8:AE8)","v":68.62088373128293}]
[null,null,"Total Cost",{"$f":"D5*D11","v":1715.5220932820732},null,"Total Cost",{"$f":"D6","v":1715.5220932820732},null,"Actual Blend",{"$f":"AF9","v":75},{"$f":"AF10","v":55},{"$f":"AF11","v":20},{"$f":"AF12","v":15.000000000000002},null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer",1,2,3,4,5]
[null,null,"Total lbs of Fertilizer",{"$f":"D10*D5","v":7770.5197881828326},null,"Total kg of fertilizer",{"$f":"D7*0.45359237","v":3524.6484868537491}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quantity",109.21822742474916,105.76923076923076,33.333333333333336,62.500000000000007,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nitrogen",{"$f":"T17","v":0.46},{"$f":"T18","v":0.11},{"$f":"T19","v":0},{"$f":"T20","v":0.21},{"$f":"T21","v":0},{"$f":"SUMPRODUCT(AA$8:AE$8,AA9:AE9)","v":75},">=",{"$f":"J5","v":75}]
[null,null,"Total fertilizer lbs/acre",{"$f":"SUM(AA8:AE8)","v":310.8207915273133},null,"kg/ha",{"$f":"D10*1.121","v":348.43010730211819},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phosphorous",{"$f":"U17","v":0},{"$f":"U18","v":0.52},{"$f":"U19","v":0},{"$f":"U20","v":0},{"$f":"U21","v":0},{"$f":"SUMPRODUCT(AA$8:AE$8,AA10:AE10)","v":55},">=",{"$f":"K5","v":50}]
[null,null,"Price/acre",{"$f":"AH5","v":68.62088373128293},null,"Price/ha",{"$f":"G6/G5","v":169.56563474418667},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Potassium",{"$f":"V17","v":0},{"$f":"V18","v":0},{"$f":"V19","v":0.6},{"$f":"V20","v":0},{"$f":"V21","v":0},{"$f":"SUMPRODUCT(AA$8:AE$8,AA11:AE11)","v":20},">=",{"$f":"L5","v":20}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sulpher",{"$f":"W17","v":0},{"$f":"W18","v":0},{"$f":"W19","v":0},{"$f":"W20","v":0.24},{"$f":"W21","v":0},15.000000000000002,">=",{"$f":"M5","v":15}]
[]
[]
[]
[null,null,null,null,null,null,null,"Bulk Density (lbs/cu ft)","Fertilizer Type ","N","P","K","S","Price (mt)","Quantity to Purchase","Product lbs/ac",null,null,null,"%N","%P","%K","%S","Bulk Density (lbs/cu ft)"]
[null,null,null,null,null,null,null,46,1,46,0,0,0,425,{"$f":"AA8*D5","v":2730.4556856187291},{"$f":"O17/D5","v":109.21822742474916},null,null,null,{"$f":"J17/100","v":0.46},0,0,0,{"$f":"H17","v":46}]
[null,null,"Percent of Blend ","%",null,null,null,58,2,11,52,0,0,630,{"$f":"AB8*D5","v":2644.2307692307691},{"$f":"O18/D5","v":105.76923076923076},null,null,null,0.11,0.52,0,0,{"$f":"H18","v":58}]
[null,null,"N",{"$f":"(AA8*AA9+AB8*AB9+AC8*AC9+AD8*AD9+AE8*AE9)/D10","v":0.24129659934094014},null,null,null,65,3,0,0,60,0,450,{"$f":"AC8*D5","v":833.33333333333337},{"$f":"O19/D5","v":33.333333333333336},null,null,null,0,0,0.6,0,{"$f":"H19","v":65}]
[null,null,"P",{"$f":"(AA8*AA10+AB8*AB10+AC8*AC10+AD8*AD10+AE8*AE10)/D10","v":0.17695083951668944},null,null,null,65,4,21,0,0,24,450,{"$f":"AD8*D5","v":1562.5000000000002},{"$f":"O20/D5","v":62.500000000000007},null,null,null,0.21,0,0,0.24,{"$f":"H20","v":65}]
[null,null,"K",{"$f":"(AA8*AA11+AB8*AB11+AC8*AC11+AD8*AD11+AE8*AE11)/D10","v":6.4345759824250698E-2},null,null,null,49,5,0,0,0,0,460,{"$f":"AE8*D5","v":0},{"$f":"O21/D5","v":0},null,null,null,0,0,0,0,{"$f":"H21","v":49}]
[null,null,"S",{"$f":"(AA8*AA12+AB8*AB12+AC8*AC12+AD8*AD12+AE8*AE12)/D10","v":4.825931986818803E-2}]
[]
[null,null,"Density of Blend (lbs/gal)",{"$f":"(D26/D25)*8.34","v":5.56}]
[null,null,"Weight of water",15]
[null,null,"Weight of Fertilizer",10]
[]
[null,null,"Bulk Density (lbs/cu ft)",{"$f":"(AA8/D10*X17)+(AB8/D10*X18)+(AC8/D10*X19)+(AD8/D10*X20)+(AE8/D10*X21)","v":55.94162612925642},null,null,null,null,"To Optimize Blend press: \"Control r\""]
[null,null,"Bulk Density (kg/m3)",{"$f":"D28*16.01846","v":896.09870048644882},null,null,null,null,"Then Press Ok"]