{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Verify fert equiv meets spec ","1 fert sub","3 fert sub 18-46-0","3 fert sub 11-52-0"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Verify fert equiv meets spec ","index":0,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,0,2,4],[0,0,0,4],[46,0,46,4]]}
["This spreadsheet will verify whether fertilizer substitute (up to a combination of 3 different types) meets minimum requirements for a specified fertilizer mix.  "]
[]
["Instructions:  Enter data in pink shaded cells.  Then go to \"Result\" section."]
[]
["Specification Requirement"]
["Enter # of pounds per acre:"]
[]
[null,"N","P2O5","K2O"]
["Enter mix (as whole numbers):"]
["Example enter 13, 13, and 13 for 13-13-13 mix"]
[]
["Enter # of Acres:"]
[]
["Total pounds required:",{"$f":"B6*B9/100*B12","v":0},{"$f":"B6*C9/100*B12","v":0},{"$f":"B6*D9/100*B12","v":0}]
[]
["Fertilizer 1:"]
[null,"N","P2O5","K2O"]
["Enter mix (as whole number):"]
[]
["Enter total # of pounds of Fertilizer 1:"]
[]
["Pounds provided by Fertilizer 1",{"$f":"B18*B20/100","v":0},{"$f":"C18*B20/100","v":0},{"$f":"D18*B20/100","v":0}]
[]
["Fertilizer 2:"]
[null,"N","P2O5","K2O"]
["Enter mix (as whole number):"]
[]
["Enter total # of pounds of Fertilizer 2:"]
[]
["Pounds provided by Fertilizer 2",{"$f":"B26*B28/100","v":0},{"$f":"C26*B28/100","v":0},{"$f":"D26*B28/100","v":0}]
[]
["Fertilizer 3"]
[null,"N","P2O5","K2O"]
["Enter mix (as whole number)"]
[]
["Enter total # of pounds of Fertilizer 3:"]
[]
["Pounds provided by Fertilizer 3",{"$f":"B34*B36/100","v":0},{"$f":"C34*B36/100","v":0},{"$f":"D34*B36/100","v":0}]
[]
[]
["Total pounds provided by Fertilizer 1 to 3:",{"$f":"ROUNDUP((B22+B30+B38),0)","v":0},{"$f":"ROUNDUP((C22+C30+C38),0)","v":0},{"$f":"ROUNDUP((D22+D30+D38),0)","v":0}]
[]
["Result:"]
["Fertilizer provided meets specification minimum?"]
[null,"N","P2O5","K2O"]
[null,{"$f":"IF(B41>=B14,\"YES\", \"NO\")","v":"YES"},{"$f":"IF(C41>=C14,\"YES\", \"NO\")","v":"YES"},"YES"]
["Note:  Need three \"YES\" to meet specification minimum.  If cell says \"NO\" then quantity of corresponding ingredient does not meet specification requirement."]

{"sheet":"1 fert sub","index":1,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,0,2,4],[0,0,0,4]]}
["This spreadsheet will calculate the amount of a single fertilizer needed to be equivalent to a specified fertilizer mix."]
[]
["Instructions: Enter data in pink shaded cells.  Then go to \"Results\" section for number of pounds of substitute fertilizer to meet specification requirements."]
[]
["Specification Requirement"]
["Enter # of pounds per acre:"]
[]
[null,"N","P2O5","K2O"]
["Enter mix (as whole numbers):"]
["Example enter 13, 13, and 13 for 13-13-13 mix"]
[]
["Enter # of Acres:"]
[]
["Total pounds required:",{"$f":"B6*B9/100*B12","v":0},{"$f":"B6*C9/100*B12","v":0},{"$f":"B6*D9/100*B12","v":0}]
[]
["Fertilizer Substitute:"]
[null,"N","P2O5","K2O"]
["Enter mix (as whole number):"]
[]
["Result:"]
["Total # of pounds of fertilizer substitute to meet spec requirements (Use largest of three values)?"]
[null,{"$f":"IF(B18=\"\",0,B6*B9*B12/B18)","v":0},{"$f":"IF(C18=\"\",0,B6*C9*B12/C18)","v":0},{"$f":"IF(D18=\"\",0,B6*D9*B12/D18)","v":0}]
["Or "]
[]
["# of pounds per acre of fertilizer substitute to meet spec requirements (Use largest of three values)?"]
[null,{"$f":"IF(B18=\"\",0,B6*B9/B18)","v":0},{"$f":"IF(C18=\"\",0,B6*C9/C18)","v":0},{"$f":"IF(D18=\"\",0,B6*D9/D18)","v":0}]

{"sheet":"3 fert sub 18-46-0","index":2,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[2,0,2,4],[0,0,0,4]]}
["This spreadsheet will calculate the amount of diammonium phosphate (18-46-0), potash (0-0-60), and urea (46-0-0) needed to be equivalent to a specified fertilizer mix."]
[]
["Instructions:  Enter data in pink shaded cells.  Then go to \"Results\" section for number of pounds of Fertilizers 1 to 3 to meet specification requirements."]
[]
["Specification Requirement"]
["Enter # of pounds per acre:"]
[]
[null,"N","P2O5","K2O"]
["Enter mix (as whole numbers):"]
["Example enter 13, 13, and 13 for 13-13-13 mix"]
[]
["Enter # of Acres:"]
[]
["Total pounds required:",{"$f":"B6*B9/100*B12","v":0},{"$f":"B6*C9/100*B12","v":0},{"$f":"B6*D9/100*B12","v":0}]
[]
["Fertilizer 1:"]
[null,"N","P2O5","K2O"]
["Enter mix (as whole number):",18,46,0]
[]
["Pounds provided by Fertilizer 1",{"$f":"B18/100*D38","v":0},{"$f":"C18/100*D38","v":0},{"$f":"D18*D38","v":0}]
[]
["Fertilizer 2:"]
[null,"N","P2O5","K2O"]
["Enter mix (as whole number):",0,0,60]
[]
["Pounds provided by Fertilizer 2",{"$f":"B24*D40","v":0},{"$f":"C24*D40","v":0},{"$f":"D24/100*D40","v":0}]
[]
["Fertilizer 3:"]
[null,"N","P2O5","K2O"]
["Enter mix (as whole number):",46,0,0]
[]
["Pounds provided by Fertilizer 3",{"$f":"B30/100*D42","v":0},{"$f":"C30*C20/100","v":0},0]
[]
["Total pounds provided:",{"$f":"SUM(B20,B26,B32)","v":0},{"$f":"SUM(C20,C26,C32)","v":0},{"$f":"D20+D26","v":0}]
[]
[]
["Result:"]
["Total # of pounds of Fertilizer 1 to meet spec requirements?",null,null,{"$f":"B6*C9*B12/C18","v":0}]
[]
["Total # of pounds of Fertilizer 2 to meet spec requirements?",null,null,{"$f":"B6*D9*B12/D24","v":0}]
[]
["Total # of pounds of Fertilizer 3 to meet spec requirements?",null,null,{"$f":"(B6*B9/100*B12-(D38*B18/100))/(B30/100)","v":0}]

{"sheet":"3 fert sub 11-52-0","index":3,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[2,0,2,4],[0,0,0,4]]}
["This spreadsheet will calculate the amount of monoammonium phosphate (11-52-0), potash (0-0-60), and urea (46-0-0) needed to be equivalent to a specified fertilizer mix."]
[]
["Instructions:  Enter data in pink shaded cells.  Then go to \"Results\" section for number of pounds of Fertilizers 1 to 3 to meet specification requirements."]
[]
["Specification Requirement"]
["Enter # of pounds per acre:"]
[]
[null,"N","P2O5","K2O"]
["Enter mix (as whole numbers):"]
["Example enter 13, 13, and 13 for 13-13-13 mix"]
[]
["Enter # of Acres:"]
[]
["Total pounds required:",{"$f":"B6*B9/100*B12","v":0},{"$f":"B6*C9/100*B12","v":0},{"$f":"B6*D9/100*B12","v":0}]
[]
["Fertilizer 1:"]
[null,"N","P2O5","K2O"]
["Enter mix (as whole number):",11,52,0]
[]
["Pounds provided by Fertilizer 1",{"$f":"B18/100*D38","v":0},{"$f":"C18/100*D38","v":0},{"$f":"D18*D38","v":0}]
[]
["Fertilizer 2:"]
[null,"N","P2O5","K2O"]
["Enter mix (as whole number):",0,0,60]
[]
["Pounds provided by Fertilizer 2",{"$f":"B24*D40","v":0},{"$f":"C24*D40","v":0},{"$f":"D24/100*D40","v":0}]
[]
["Fertilizer 3:"]
[null,"N","P2O5","K2O"]
["Enter mix (as whole number):",46,0,0]
[]
["Pounds provided by Fertilizer 3",{"$f":"B30/100*D42","v":0},{"$f":"C30*C20/100","v":0},0]
[]
["Total pounds provided:",{"$f":"SUM(B20,B26,B32)","v":0},{"$f":"SUM(C20,C26,C32)","v":0},{"$f":"D20+D26","v":0}]
[]
[]
["Result:"]
["Total # of pounds of Fertilizer 1 to meet spec requirements?",null,null,{"$f":"B6*C9*B12/C18","v":0}]
[]
["Total # of pounds of Fertilizer 2 to meet spec requirements?",null,null,{"$f":"B6*D9*B12/D24","v":0}]
[]
["Total # of pounds of Fertilizer 3 to meet spec requirements?",null,null,{"$f":"(B6*B9/100*B12-(D38*B18/100))/(B30/100)","v":0}]