{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","Home","Instructions","Fertilizer list (old)","Fertilizer list"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":3,"defined_names":183,"comments":2,"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":"Introduction","index":0,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":false,"merged":[[30,1,30,11],[45,1,45,11],[27,1,27,4],[28,1,29,11],[33,6,34,8],[38,4,38,6],[4,1,5,8],[4,13,5,23],[7,2,7,3],[7,4,7,5],[7,13,8,13]]}
[]
[]
[null,"KSU-Fertilizer Tool"]
[]
[null,"An Excel spreadsheet designed to find the minimum priced fertilizer combination that meets nutrient requirements of N-P-K"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Version- 3.30.2017"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INSTRUCTIONS FOR THE USER:"]
[null,"Be sure to \"Enable Content\" and \"Enable Macros\" for the spreadsheet to function correctly. This spreadsheet uses macros to solve and save scenario results."]
[]
[null,"***The Solver tool must be enabled under Excel Add-ins for this spreadsheet to work***"]
[null,"If the solver is not  enabled, here are the steps needed to load the solver add-in. This step is only needed once."]
[null,"Windows",null,"Click Here"]
[null,"Mac",null,"Click Here"]
[]
[null,"FOR MORE INFORMATION:"]
[null,"Deveolepd by:"]
[]
[null,"Gregg Ibendahl, Ph.D."]
[null,"Associate Professor"]
[null,"    Dept. of Agricultural Economics"]
[null,"Kansas State University"]
[null,"ibendahl@ksu.edu"]
[null,"(785) 477-2071"]
[]
[null,"Copyright 2017 AgManager.info, K-State Department of Agricultural Economics"]

{"sheet":"Home","index":1,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,9,1,10],[22,9,23,9],[22,10,23,10],[22,11,23,11]]}
[null,null,null,null,null,null,null,null,"SOLVER MUST BE ENABLED IN ADD-INS"]
[null,"Fertilizer","Price per ton","Use or not","Minimum lbs","Maximum lbs",null,null,null,"Fertilizer  recommendations"]
[null,"Anhydrous Ammonia",482,null,null,null,null,null,null,"N","P","K "]
[null,"Urea",353,null,null,null,null,null,"Required",200,100,100]
[null,"UAN28",236,null,null,null,null,null,"Maximum"]
[null,"UAN32",270]
[null,"DAP",430]
[null,"MAP",448]
[null,"10-34-0",439]
[null,"Potash",329]
[null,"Ammonium nitrate",250,null,null,null,null,null,{"$f":"IF('Fertilizer list'!D136>0, \"Press Find Minimum Cost button\", \"\")","v":""}]
[null,"AMS",200]
[]
[]
[]
[]
[]
[null,"Fertilizer Prices Need to Be Updated Before Using!"]
[]
[null,"Solutions",null,null,null,null,null,null,"Nutrients Applied"]
[null,"Fertilizers to use","Pounds","Cost",null,null,null,null,null,"N","P","K "]
[null,{"$f":"IF(ISBLANK('Fertilizer list'!$AD4), \"\", 'Fertilizer list'!AD4)","v":"DAP"},{"$f":"IF(B22=\"\", \"\", 'Fertilizer list'!AE4)","v":217},{"$f":"IF(B22=\"\", \"\", 'Fertilizer list'!AG4)","v":46.655000000000001},null,null,null,null,"Lbs applied",{"$f":"ROUND('Fertilizer list'!AK19, 0)","v":200},{"$f":"ROUND('Fertilizer list'!AL19, 0)","v":100},{"$f":"ROUND('Fertilizer list'!AM19, 0)","v":100}]
[null,{"$f":"IF(ISBLANK('Fertilizer list'!$AD5), \"\", 'Fertilizer list'!AD5)","v":"Anhydrous Ammonia"},{"$f":"IF(B23=\"\", \"\", 'Fertilizer list'!AE5)","v":196},{"$f":"IF(B23=\"\", \"\", 'Fertilizer list'!AG5)","v":47.235999999999997},null,null,null,null,"Cost per unit",{"$f":"'Fertilizer list'!M22","v":0.29390243902439023},{"$f":"'Fertilizer list'!N22","v":0.35238600212089083},{"$f":"'Fertilizer list'!O22","v":0.27416666666666667}]
[null,{"$f":"IF(ISBLANK('Fertilizer list'!$AD6), \"\", 'Fertilizer list'!AD6)","v":"Potash"},{"$f":"IF(B24=\"\", \"\", 'Fertilizer list'!AE6)","v":167},{"$f":"IF(B24=\"\", \"\", 'Fertilizer list'!AG6)","v":27.471499999999999}]
[null,{"$f":"IF(ISBLANK('Fertilizer list'!$AD7), \"\", 'Fertilizer list'!AD7)","v":""},{"$f":"IF(B25=\"\", \"\", 'Fertilizer list'!AE7)","v":""},{"$f":"IF(B25=\"\", \"\", 'Fertilizer list'!AG7)","v":""}]
[null,{"$f":"IF(ISBLANK('Fertilizer list'!$AD8), \"\", 'Fertilizer list'!AD8)","v":""},{"$f":"IF(B26=\"\", \"\", 'Fertilizer list'!AE8)","v":""},{"$f":"IF(B26=\"\", \"\", 'Fertilizer list'!AG8)","v":""}]
[null,{"$f":"IF(ISBLANK('Fertilizer list'!AD9), \"\", 'Fertilizer list'!AD9)","v":""}]
[null,null,"Total",{"$f":"'Fertilizer list'!AG19","v":121.36249999999998}]
[]
[]
[]
[]
[null,"Scenarios to Exam"]
[null,null,"Quantities"]
[null,"Fertilizer","Scenario #1","Scenario #2","Scenario #3","Scenario #4","Scenario #5"]
[null,{"$f":"IF(B3<>\"\",B3, \"\")","v":"Anhydrous Ammonia"},{"$f":"IF(AND('Fertilizer list'!O43<>9999, 'Fertilizer list'!O43<>0), 'Fertilizer list'!O43, \"\")","v":196},{"$f":"IF(AND('Fertilizer list'!P43<>9999, 'Fertilizer list'!P43<>0), 'Fertilizer list'!P43, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!Q43<>9999, 'Fertilizer list'!Q43<>0), 'Fertilizer list'!Q43, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!R43<>9999, 'Fertilizer list'!R43<>0), 'Fertilizer list'!R43, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!S43<>9999, 'Fertilizer list'!S43<>0), 'Fertilizer list'!S43, \"\")","v":""}]
[null,{"$f":"IF(B4<>\"\",B4, \"\")","v":"Urea"},{"$f":"IF(AND('Fertilizer list'!O44<>9999, 'Fertilizer list'!O44<>0), 'Fertilizer list'!O44, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!P44<>9999, 'Fertilizer list'!P44<>0), 'Fertilizer list'!P44, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!Q44<>9999, 'Fertilizer list'!Q44<>0), 'Fertilizer list'!Q44, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!R44<>9999, 'Fertilizer list'!R44<>0), 'Fertilizer list'!R44, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!S44<>9999, 'Fertilizer list'!S44<>0), 'Fertilizer list'!S44, \"\")","v":""}]
[null,"UAN28",{"$f":"IF(AND('Fertilizer list'!O45<>9999, 'Fertilizer list'!O45<>0), 'Fertilizer list'!O45, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!P45<>9999, 'Fertilizer list'!P45<>0), 'Fertilizer list'!P45, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!Q45<>9999, 'Fertilizer list'!Q45<>0), 'Fertilizer list'!Q45, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!R45<>9999, 'Fertilizer list'!R45<>0), 'Fertilizer list'!R45, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!S45<>9999, 'Fertilizer list'!S45<>0), 'Fertilizer list'!S45, \"\")","v":""}]
[null,"UAN32",{"$f":"IF(AND('Fertilizer list'!O46<>9999, 'Fertilizer list'!O46<>0), 'Fertilizer list'!O46, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!P46<>9999, 'Fertilizer list'!P46<>0), 'Fertilizer list'!P46, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!Q46<>9999, 'Fertilizer list'!Q46<>0), 'Fertilizer list'!Q46, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!R46<>9999, 'Fertilizer list'!R46<>0), 'Fertilizer list'!R46, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!S46<>9999, 'Fertilizer list'!S46<>0), 'Fertilizer list'!S46, \"\")","v":""}]
[null,"DAP",{"$f":"IF(AND('Fertilizer list'!O47<>9999, 'Fertilizer list'!O47<>0), 'Fertilizer list'!O47, \"\")","v":217},{"$f":"IF(AND('Fertilizer list'!P47<>9999, 'Fertilizer list'!P47<>0), 'Fertilizer list'!P47, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!Q47<>9999, 'Fertilizer list'!Q47<>0), 'Fertilizer list'!Q47, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!R47<>9999, 'Fertilizer list'!R47<>0), 'Fertilizer list'!R47, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!S47<>9999, 'Fertilizer list'!S47<>0), 'Fertilizer list'!S47, \"\")","v":""}]
[null,"MAP",{"$f":"IF(AND('Fertilizer list'!O48<>9999, 'Fertilizer list'!O48<>0), 'Fertilizer list'!O48, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!P48<>9999, 'Fertilizer list'!P48<>0), 'Fertilizer list'!P48, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!Q48<>9999, 'Fertilizer list'!Q48<>0), 'Fertilizer list'!Q48, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!R48<>9999, 'Fertilizer list'!R48<>0), 'Fertilizer list'!R48, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!S48<>9999, 'Fertilizer list'!S48<>0), 'Fertilizer list'!S48, \"\")","v":""}]
[null,"10-34-0",{"$f":"IF(AND('Fertilizer list'!O49<>9999, 'Fertilizer list'!O49<>0), 'Fertilizer list'!O49, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!P49<>9999, 'Fertilizer list'!P49<>0), 'Fertilizer list'!P49, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!Q49<>9999, 'Fertilizer list'!Q49<>0), 'Fertilizer list'!Q49, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!R49<>9999, 'Fertilizer list'!R49<>0), 'Fertilizer list'!R49, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!S49<>9999, 'Fertilizer list'!S49<>0), 'Fertilizer list'!S49, \"\")","v":""}]
[null,"Potash",{"$f":"IF(AND('Fertilizer list'!O50<>9999, 'Fertilizer list'!O50<>0), 'Fertilizer list'!O50, \"\")","v":167},{"$f":"IF(AND('Fertilizer list'!P50<>9999, 'Fertilizer list'!P50<>0), 'Fertilizer list'!P50, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!Q50<>9999, 'Fertilizer list'!Q50<>0), 'Fertilizer list'!Q50, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!R50<>9999, 'Fertilizer list'!R50<>0), 'Fertilizer list'!R50, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!S50<>9999, 'Fertilizer list'!S50<>0), 'Fertilizer list'!S50, \"\")","v":""}]
[null,"Ammonium nitrate",{"$f":"IF(AND('Fertilizer list'!O51<>9999, 'Fertilizer list'!O51<>0), 'Fertilizer list'!O51, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!P51<>9999, 'Fertilizer list'!P51<>0), 'Fertilizer list'!P51, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!Q51<>9999, 'Fertilizer list'!Q51<>0), 'Fertilizer list'!Q51, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!R51<>9999, 'Fertilizer list'!R51<>0), 'Fertilizer list'!R51, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!S51<>9999, 'Fertilizer list'!S51<>0), 'Fertilizer list'!S51, \"\")","v":""}]
[null,"AMS",{"$f":"IF(AND('Fertilizer list'!O52<>9999, 'Fertilizer list'!O52<>0), 'Fertilizer list'!O52, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!P52<>9999, 'Fertilizer list'!P52<>0), 'Fertilizer list'!P52, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!Q52<>9999, 'Fertilizer list'!Q52<>0), 'Fertilizer list'!Q52, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!R52<>9999, 'Fertilizer list'!R52<>0), 'Fertilizer list'!R52, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!S52<>9999, 'Fertilizer list'!S52<>0), 'Fertilizer list'!S52, \"\")","v":""}]
[null,"",{"$f":"IF(AND('Fertilizer list'!O53<>9999, 'Fertilizer list'!O53<>0), 'Fertilizer list'!O53, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!P53<>9999, 'Fertilizer list'!P53<>0), 'Fertilizer list'!P53, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!Q53<>9999, 'Fertilizer list'!Q53<>0), 'Fertilizer list'!Q53, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!R53<>9999, 'Fertilizer list'!R53<>0), 'Fertilizer list'!R53, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!S53<>9999, 'Fertilizer list'!S53<>0), 'Fertilizer list'!S53, \"\")","v":""}]
[null,"",{"$f":"IF(AND('Fertilizer list'!O54<>9999, 'Fertilizer list'!O54<>0), 'Fertilizer list'!O54, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!P54<>9999, 'Fertilizer list'!P54<>0), 'Fertilizer list'!P54, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!Q54<>9999, 'Fertilizer list'!Q54<>0), 'Fertilizer list'!Q54, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!R54<>9999, 'Fertilizer list'!R54<>0), 'Fertilizer list'!R54, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!S54<>9999, 'Fertilizer list'!S54<>0), 'Fertilizer list'!S54, \"\")","v":""}]
[null,"",{"$f":"IF(AND('Fertilizer list'!O55<>9999, 'Fertilizer list'!O55<>0), 'Fertilizer list'!O55, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!P55<>9999, 'Fertilizer list'!P55<>0), 'Fertilizer list'!P55, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!Q55<>9999, 'Fertilizer list'!Q55<>0), 'Fertilizer list'!Q55, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!R55<>9999, 'Fertilizer list'!R55<>0), 'Fertilizer list'!R55, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!S55<>9999, 'Fertilizer list'!S55<>0), 'Fertilizer list'!S55, \"\")","v":""}]
[null,"",{"$f":"IF(AND('Fertilizer list'!O56<>9999, 'Fertilizer list'!O56<>0), 'Fertilizer list'!O56, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!P56<>9999, 'Fertilizer list'!P56<>0), 'Fertilizer list'!P56, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!Q56<>9999, 'Fertilizer list'!Q56<>0), 'Fertilizer list'!Q56, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!R56<>9999, 'Fertilizer list'!R56<>0), 'Fertilizer list'!R56, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!S56<>9999, 'Fertilizer list'!S56<>0), 'Fertilizer list'!S56, \"\")","v":""}]
[null,"Application cost"]
[]
[null,"Total cost",{"$f":"IF(AND('Fertilizer list'!O59<>9999, 'Fertilizer list'!O59<>0), 'Fertilizer list'!O59, \"\")","v":121.3625},{"$f":"IF(AND('Fertilizer list'!P59<>9999, 'Fertilizer list'!P59<>0), 'Fertilizer list'!P59, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!Q59<>9999, 'Fertilizer list'!Q59<>0), 'Fertilizer list'!Q59, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!R59<>9999, 'Fertilizer list'!R59<>0), 'Fertilizer list'!R59, \"\")","v":""},{"$f":"IF(AND('Fertilizer list'!S59<>9999, 'Fertilizer list'!S59<>0), 'Fertilizer list'!S59, \"\")","v":""},{"$f":"MIN(C52:G52)","v":121.3625}]
[null,null,{"$f":"IF(C52=$H$52, TRUE, FALSE)","v":true},{"$f":"IF(D52=$H$52, TRUE, FALSE)","v":false},false,false,false]

{"sheet":"Instructions","index":2,"n_rows":45,"n_cols":2,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["This spreadsheet is designed to find the minimum priced fertilizer combination that meets nutrient requirements of N-P-K"]
["The Solver tool must be enabled under Excel Add-ins for this spreadsheet to work"]
[]
[null,"If the solver is not  enabled, here are the steps needed to load the solver add-in. This step is only needed once"]
["Windows","https://support.office.com/en-us/article/Load-the-Solver-Add-in-612926fc-d53b-46b4-872c-e24772f078ca?ui=en-US&rs=en-US&ad=US&fromAR=1"]
["Mac","https://support.office.com/en-us/article/Load-the-Solver-Add-in-in-Excel-2016-for-Mac-d7a34027-56bf-4569-9b42-45a624c3e774"]
[]
["Home page"]
["Cells in blue are for user input. Other cells are read only."]
[]
["Big box in upper left"]
["A default list of fertilizers is listed and can be expanded by adding more to the list."]
["Prices should be updated by the user to reflect current and local prices"]
["The 'Use or not' checkboxes are used to control whether Excel should possibly include that particular fertilizer in the mix"]
[null,"Uncheck the box if a fertilizer should be excluded. "]
[null,"Check a box if that fertilizer should be a candidate for a fertilizer in the low cost mix"]
[null,"Any blank lines in the fertilizer list should have the corresponding checkbox NOT checked"]
["The minimum lbs and the maximum lbs are optional inputs if for some reason the use of that particular fertilizer"]
[null,"is either required or restricted. Leaving these two cells blank will default to a minimum pounds of "]
[null,"0 lbs and a maximum pounds of 1000 lbs."]
[]
["Smaller box to the right"]
["The required row is the minimum pounds of N, P, and K required to meet the fertility needs of that crop. This is a required row."]
["The maximum row is optional and is used if there is a need to limit the applied amount of N-P-K."]
[null,"If left blank, this row defaults to a maximum of 1000 lbs."]
[]
["After making any worksheet change, the red \"Find Minimum Cost\" button needs to be pressed to resolve for the correct "]
[null,"fertilizer combination"]
[]
["The cost per unit (i.e., nutrient cost per pound of N, P, or K) is based on first calculating the nitrogen price per pound of N"]
[null,"and then calculating P based on the remainder. There may be times when this calculation is incorrect."]
[null,"However, it does not affect the answer to the minimum cost fertilizer combination."]
[null,"Adding any fertilizers that have all 3 nutrients will not correctly calculate a cost per unit."]
[]
["Scenarios"]
["This bottom section allows the user to store the solution as a possible scenario to consider. "]
["Once Excel has calculated a solution, press the blue \"add scenario\" button to put the quantities of those fertilizers into the table"]
["Different solutions can be generated by using the constraints available in the main table in the upper left hand corner."]
["For example, once the first solution is identified, just unclick the \"use\" checkbox to get a new solution that doesn't use that "]
["particular fertilizer. Once all the possible solutions are added to the table, What-If analyses can be run by adjusting fertilizer prices."]
["As the scenario table only stores the quantities, changing prices only affects the total cost of that option."]
[]
["Fertilizer list page"]
["If any additional fertilizers are added the N, P, and K percentages need to be added on this page. Do not add to the list of fertilizers"]
[null,"here as this list comes from the Home page."]

{"sheet":"Fertilizer list (old)","index":3,"n_rows":42,"n_cols":39,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[]
["Quantity",null,null,"Formulation (if use is true)",null,null,"# per ton",null,null,"Price per unit"]
[null,"$ / ton","Fertilizer","N","P","K","N","P","K","N","P","K","Checkbox",null,"N price to use","N provided from DAP MAP and 10-34-0","Tons of fertilzer to get required P","Lbs of fertilizer required to get required P","Pounds of N that DAP MAP provide and which has value","Value of the N","Value of P","Price of P per unit",null,"Pounds of N needed after applying P","Lbs of fertilizer to get required N",null,"Price per pound of fertilizer"]
[8.6772983114446773E-4,{"$f":"Home!C3","v":482},"Anhydrous Ammonia",{"$f":"IF($M4,D35,0)","v":0},{"$f":"IF($M4,E35,0)","v":0},0,{"$f":"2000 *D4/100","v":0},{"$f":"2000 *E4/100","v":0},0,{"$f":"IFERROR($B4/G4,\"\")","v":""},null,null,false,null,{"$f":"IF(AND(M4, B4>0),J4,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"MAX(0, $G$24-$Z$24)","v":0},{"$f":"X4/G4 * 2000","v":{"$error":"#DIV/0!"}},null,{"$f":"B4/2000","v":0.24099999999999999}]
[0,{"$f":"Home!C4","v":353},"Urea",{"$f":"IF($M5,D36,0)","v":0},0,0,{"$f":"2000 *D5/100","v":0},{"$f":"2000 *E5/100","v":0},{"$f":"2000 *F5/100","v":0},{"$f":"IFERROR($B5/G5,\"\")","v":""},null,null,false,null,{"$f":"IF(AND(M5, B5>0),J5,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"MAX(0, $G$24-$Z$24)","v":0},{"$f":"X5/G5 * 2000","v":{"$error":"#DIV/0!"}},null,{"$f":"B5/2000","v":0.17649999999999999}]
[0,{"$f":"Home!C5","v":236},"UAN28",{"$f":"IF($M6,D37,0)","v":0},0,0,0,0,0,"",null,null,false,null,"",null,null,null,null,null,null,null,null,{"$f":"MAX(0, $G$24-$Z$24)","v":0},{"$error":"#DIV/0!"},null,0.11799999999999999]
[0,200,"UAN32",{"$f":"IF($M7,D38,0)","v":0},0,0,0,0,0,"",null,null,false,null,"",null,null,null,null,null,null,null,null,{"$f":"MAX(0, $G$24-$Z$24)","v":0},{"$error":"#DIV/0!"},null,0.1]
[0,10,"DAP",{"$f":"IF($M8,D39,0)","v":0},0,0,0,0,0,null,null,null,false,null,null,{"$f":"IFERROR($G$25/H8 * G8, \"\")","v":""},{"$f":"IFERROR($G$25 / H8, 0)","v":0},{"$f":"Q8*2000","v":0},{"$f":"MIN(P8,$G$24)","v":100},{"$f":"S8*$O$13","v":0},{"$f":"Q8*B8 - T8","v":0},{"$f":"IFERROR(U8/$G$25, 0)","v":0},null,{"$f":"MAX(0, $G$24-$Z$24)","v":0},{"$error":"#DIV/0!"},null,5.0000000000000001E-3]
[4.8076923076923059E-2,100,"MAP",{"$f":"IF($M9,D40,0)","v":0},0,0,0,0,0,null,null,null,false,null,null,{"$f":"IFERROR($G$25/H9 * G9, \"\")","v":""},{"$f":"IFERROR($G$25 / H9, 0)","v":0},{"$f":"Q9*2000","v":0},{"$f":"MIN(P9,$G$24)","v":100},{"$f":"S9*$O$13","v":0},{"$f":"Q9*B9 - T9","v":0},{"$f":"IFERROR(U9/$G$25, 0)","v":0},null,0,{"$error":"#DIV/0!"},null,0.05]
[0,300,"10-34-0",{"$f":"IF($M10,D41,0)","v":0},0,0,0,0,0,null,null,null,false,null,null,"",0,0,{"$f":"MIN(P10,$G$24)","v":100},0,{"$f":"Q10*B10 - T10","v":0},0,null,0,{"$f":"X10/G10 * 2000","v":{"$error":"#DIV/0!"}},null,0.15]
[0,{"$f":"Home!C10","v":329},"Potash",{"$f":"IF($M11,D42,0)","v":0},0,0,0,0,0,null,null,{"$f":"$B11/I11","v":{"$error":"#DIV/0!"}},false,null,null,null,null,null,null,null,null,null,null,0,{"$error":"#DIV/0!"},null,0.16450000000000001]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Min N price",{"$f":"MIN(O4:O11)","v":0},null,null,null,null,null,"Min P price",{"$f":"MIN(V8:V10)","v":0}]
[]
[]
[]
[]
[]
[null,null,null,"Minimize"]
[null,null,null,{"$f":"SUMPRODUCT(A4:A11,B4:B11)","v":5.2259380863039393},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,null,null,null,"Percentage",null,null,null,"Pounds"]
[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,null,null,null,null,null,null,null,2,3,4]
[null,null,null,null,null,null,"fertilization recommendations",null,null,null,null,null,null,null,null,"Lookup table to find the P info",null,null,null,null,null,null,null,2,3,4,5,6,null,null,"Total cost",null,"N","P","K",null,"N","P","K"]
[null,null,null,"Constraint",null,null,"pounds",null,null,null,null,null,null,null,null,"Price of P per unit","Fertilizer","Lb of fert","Lb of N provided","Price of P per unit","Price of fertilizer per pound",null,null,"Fertilizer","Lb","N contribution","Price per unit","price per pound of fertilizer",null,null,{"$f":"Y24*AB24","v":0},null,{"$f":"VLOOKUP($X24,$C$4:$F$11,AG$21,FALSE)","v":0},{"$f":"VLOOKUP($X24,$C$4:$F$11,AH$21,FALSE)","v":0},0,null,{"$f":"$Y24 * AG23/100","v":0},{"$f":"$Y24 * AH23/100","v":0},0]
[null,null,null,"N amount",{"$f":"SUMPRODUCT(A4:A11,G4:G11)","v":0},">",100,null,null,null,null,null,null,null,null,{"$f":"V8","v":0},{"$f":"C8","v":"DAP"},{"$f":"R8","v":0},{"$f":"S8","v":100},{"$f":"V8","v":0},{"$f":"AA8","v":5.0000000000000001E-3},null,null,{"$f":"VLOOKUP($V$13,$P$24:$S$26,X22,FALSE)","v":"DAP"},{"$f":"VLOOKUP($V$13,$P$24:$S$26,Y22,FALSE)","v":0},{"$f":"VLOOKUP($V$13,$P$24:$T$26,Z22,FALSE)","v":100},{"$f":"VLOOKUP($V$13,$P$24:$U$26,AA22,FALSE)","v":0},{"$f":"VLOOKUP($V$13,$P$24:$U$26,AB22,FALSE)","v":5.0000000000000001E-3}]
[null,null,null,"P",{"$f":"SUMPRODUCT(A4:A11,H4:H11)","v":0},">",0,null,null,null,null,null,null,null,null,{"$f":"V9","v":0},{"$f":"C9","v":"MAP"},{"$f":"R9","v":0},100,{"$f":"V9","v":0},{"$f":"AA9","v":0.05}]
[null,null,null,"K",{"$f":"SUMPRODUCT(A4:A11,I4:I11)","v":0},">",0,null,null,null,null,null,null,null,null,0,"10-34-0",{"$f":"R10","v":0},100,0,0.15]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lookup table to find the N info",null,null,null,null,null,null,null,2,3,4,5,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Price of N per unit","Fertilizer","Lb of fert",null,"Price of N per unit","Price of fertilizer per pound",null,null,"Fertilizer","Lb","N contribution","Price per unit",null,null,null,{"$f":"Y33*AB33","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP($X33,$C$4:$F$11,AG$21,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($X33,$C$4:$F$11,AH$21,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($X33,$C$4:$F$11,AI$21,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"$Y33 * AG32/100","v":{"$error":"#N/A"}},{"$f":"$Y33 * AH32/100","v":{"$error":"#N/A"}},{"$f":"$Y33 * AI32/100","v":{"$error":"#N/A"}}]
[null,null,null,"Formulation",null,null,null,null,null,null,null,null,null,null,null,{"$f":"O4","v":""},{"$f":"C4","v":"Anhydrous Ammonia"},{"$f":"Y4","v":{"$error":"#DIV/0!"}},null,{"$f":"P33","v":""},{"$f":"AA4","v":0.24099999999999999},null,null,{"$f":"VLOOKUP($O$13,$P$33:$T$36,X31,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($O$13,$P$33:$T$36,Y31,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"VLOOKUP($O$13,$P$33:$U$36,AA31,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($O$13,$P$33:$U$36,AB31,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,"N","P","K",null,null,null,null,null,null,null,null,null,{"$f":"O5","v":""},{"$f":"C5","v":"Urea"},{"$f":"Y5","v":{"$error":"#DIV/0!"}},null,{"$f":"P34","v":""},{"$f":"AA5","v":0.17649999999999999}]
[null,null,"Anhydrous Ammonia",82,0,0,null,null,null,null,null,null,null,null,null,"","UAN28",{"$error":"#DIV/0!"},null,"",0.11799999999999999]
[null,null,"Urea",46,0,0,null,null,null,null,null,null,null,null,null,"","UAN32",{"$error":"#DIV/0!"},null,"",0.1]
[null,null,"UAN28",28,0,0]
[null,null,"UAN32",32,0,0]
[null,null,"DAP",18,46,0]
[null,null,"MAP",11,52,0,null,null,null,null,null,null,null,null,null,"K info",null,null,null,null,null,null,null,"Potash",{"$f":"G26/I11 * 2000","v":{"$error":"#DIV/0!"}},null,{"$f":"L11","v":{"$error":"#DIV/0!"}},{"$f":"AA11","v":0.16450000000000001},null,null,{"$f":"Y41*AB41","v":0},null,0,0,60,null,{"$f":"$Y40 * AG40/100","v":{"$error":"#DIV/0!"}},{"$f":"$Y40 * AH40/100","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"10-34-0",10,34,0]
[null,null,"Potash",0,0,60,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grand total",{"$f":"SUM(AE23:AE40)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"SUM(AK23:AK40)","v":{"$error":"#N/A"}},{"$f":"SUM(AL23:AL40)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]

{"sheet":"Fertilizer list","index":4,"n_rows":136,"n_cols":39,"rows_kept":136,"cut":false,"hidden":false,"merged":[]}
[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,null,null,null,null,null,null,null,null,"Formaulation",null,null,"Pounds"]
["Quantity",null,null,"Formulation",null,null,"Formulation (if use is true)",null,null,"# per ton",null,null,"Price per unit",null,null,null,null,null,null,"Units",null,null,null,null,null,null,null,null,null,3,null,2,null,7,8,9]
[null,"$ / ton","Fertilizer","N","P","K","N","P","K","N","P","K","N","P","K","Checkbox","Lower requirement","Upperlimit","Cost","N","P","K","Revised checkbox if fertilizer is blank",null,null,null,"List of products used",null,null,"Product","Lbs","$ per ton","Cost","N","P","K","N","P","K"]
[9.8091198303287372E-2,{"$f":"Home!C3","v":482},{"$f":"Home!B3","v":"Anhydrous Ammonia"},82,0,0,{"$f":"IF($P4,D4,0)","v":82},0,0,{"$f":"2000 *G4/100","v":1640},{"$f":"2000 *H4/100","v":0},0,{"$f":"IF(AND($G4>0, $H4=0, $I4=0, A4>0), $B4/J4, \"\")","v":0.29390243902439023},{"$f":"IF(AND($G4=0, $H4>0, $I4=0, A4>0), $B4/K4, \"\")","v":""},{"$f":"IF(AND($G4=0, $H4=0, $I4>0, A4>0), $B4/L4, \"\")","v":""},true,{"$f":"IF(Home!E3=\"\", 0, Home!E3/2000)","v":0},{"$f":"IF(Home!F3=\"\", 10000, Home!F3/2000)","v":10000},{"$f":"A4 *B4","v":47.279957582184515},null,null,null,{"$f":"IF(AND(P4, C4<>0), TRUE, FALSE)","v":true},null,null,null,1,{"$f":"LARGE($A$4:$A$17, AA4)","v":0.10869565217391304},{"$f":"IF(AB4>0,AB4, \"\")","v":0.10869565217391304},{"$f":"IF(ISNUMBER($AC4), VLOOKUP($AB4, $A$4:$O$17, AD$2, FALSE), \"\")","v":"DAP"},{"$f":"ROUND(AB4 * 2000, 0)","v":217},{"$f":"IF(ISNUMBER($AC4), VLOOKUP($AB4, $A$4:$O$17, AF$2, FALSE), \"\")","v":430},{"$f":"IF(ISNUMBER(AF4), AF4*AE4/2000, 0)","v":46.655000000000001},{"$f":"IF(ISNUMBER($AC4), VLOOKUP($AB4, $A$4:$O$17, AH$2, FALSE), 0)","v":18},{"$f":"IF(ISNUMBER($AC4), VLOOKUP($AB4, $A$4:$O$17, AI$2, FALSE), 0)","v":46},0,{"$f":"$AE4 * AH4 / 100","v":39.06},{"$f":"$AE4 * AI4 / 100","v":99.82},0]
[0,{"$f":"Home!C4","v":353},{"$f":"Home!B4","v":"Urea"},46,0,0,46,0,0,{"$f":"2000 *G5/100","v":920},0,0,{"$f":"IF(AND($G5>0, $H5=0, $I5=0, A5>0), $B5/J5, \"\")","v":""},{"$f":"IF(AND($G5=0, $H5>0, $I5=0, A5>0), $B5/K5, \"\")","v":""},{"$f":"IF(AND($G5=0, $H5=0, $I5>0, A5>0), $B5/L5, \"\")","v":""},true,{"$f":"IF(Home!E4=\"\", 0, Home!E4/2000)","v":0},{"$f":"IF(Home!F4=\"\", 10000, Home!F4/2000)","v":10000},{"$f":"A5 *B5","v":0},null,null,null,{"$f":"IF(AND(P5, C5<>0), TRUE, FALSE)","v":true},null,null,null,2,{"$f":"LARGE($A$4:$A$17, AA5)","v":9.8091198303287372E-2},{"$f":"IF(AB5>0,AB5, \"\")","v":9.8091198303287372E-2},{"$f":"IF(ISNUMBER($AC5), VLOOKUP($AB5, $A$4:$O$17, AD$2, FALSE), \"\")","v":"Anhydrous Ammonia"},{"$f":"ROUND(AB5 * 2000, 0)","v":196},{"$f":"IF(ISNUMBER($AC5), VLOOKUP($AB5, $A$4:$O$17, AF$2, FALSE), \"\")","v":482},{"$f":"IF(ISNUMBER(AF5), AF5*AE5/2000, 0)","v":47.235999999999997},{"$f":"IF(ISNUMBER($AC5), VLOOKUP($AB5, $A$4:$O$17, AH$2, FALSE), 0)","v":82},0,0,{"$f":"$AE5 * AH5 / 100","v":160.72},{"$f":"$AE5 * AI5 / 100","v":0},{"$f":"$AE5 * AJ5 / 100","v":0}]
[0,{"$f":"Home!C5","v":236},{"$f":"Home!B5","v":"UAN28"},28,0,0,28,0,0,560,0,0,"","","",true,{"$f":"IF(Home!E5=\"\", 0, Home!E5/2000)","v":0},{"$f":"IF(Home!F5=\"\", 10000, Home!F5/2000)","v":10000},0,null,null,null,true,null,null,null,3,8.3333333333333343E-2,8.3333333333333343E-2,"Potash",{"$f":"ROUND(AB6 * 2000, 0)","v":167},329,27.471499999999999,0,0,60,0,0,100.2]
[0,{"$f":"Home!C6","v":270},{"$f":"Home!B6","v":"UAN32"},32,0,0,32,0,0,640,0,0,"","","",true,{"$f":"IF(Home!E6=\"\", 0, Home!E6/2000)","v":0},{"$f":"IF(Home!F6=\"\", 10000, Home!F6/2000)","v":10000},0,null,null,null,true,null,null,null,4,0,"","",{"$f":"ROUND(AB7 * 2000, 0)","v":0},"",0,0,0,0,0,0,0]
[0.10869565217391304,{"$f":"Home!C7","v":430},{"$f":"Home!B7","v":"DAP"},18,46,0,18,46,0,360,920,0,"","","",true,{"$f":"IF(Home!E7=\"\", 0, Home!E7/2000)","v":0},{"$f":"IF(Home!F7=\"\", 10000, Home!F7/2000)","v":10000},46.739130434782609,null,null,null,true,null,null,null,5,0,"","",0,"",0,0,0,0,0,0,0]
[0,{"$f":"Home!C8","v":448},{"$f":"Home!B8","v":"MAP"},11,52,0,11,52,0,220,1040,0,"","","",true,{"$f":"IF(Home!E8=\"\", 0, Home!E8/2000)","v":0},{"$f":"IF(Home!F8=\"\", 10000, Home!F8/2000)","v":10000},0,null,null,null,true,null,null,null,6,0,"","",0,"",0,0,0,0,0,0,0]
[0,{"$f":"Home!C9","v":439},{"$f":"Home!B9","v":"10-34-0"},10,34,0,10,34,0,200,680,0,"","","",true,{"$f":"IF(Home!E9=\"\", 0, Home!E9/2000)","v":0},{"$f":"IF(Home!F9=\"\", 10000, Home!F9/2000)","v":10000},0,null,null,null,true,null,null,null,7,0,"","",0,"",0,0,0,0,0,0,0]
[8.3333333333333343E-2,{"$f":"Home!C10","v":329},{"$f":"Home!B10","v":"Potash"},0,0,60,0,0,60,0,0,1200,"","",0.27416666666666667,true,{"$f":"IF(Home!E10=\"\", 0, Home!E10/2000)","v":0},{"$f":"IF(Home!F10=\"\", 10000, Home!F10/2000)","v":10000},27.416666666666671,null,null,null,true,null,null,null,8,0,"","",0,"",0,0,0,0,0,0,0]
[0,{"$f":"Home!C11","v":250},{"$f":"Home!B11","v":"Ammonium nitrate"},34,0,0,{"$f":"IF($P12,D12,0)","v":34},{"$f":"IF($P12,E12,0)","v":0},{"$f":"IF($P12,F12,0)","v":0},{"$f":"2000 *G12/100","v":680},{"$f":"2000 *H12/100","v":0},{"$f":"2000 *I12/100","v":0},"","","",true,{"$f":"IF(Home!E11=\"\", 0, Home!E11/2000)","v":0},{"$f":"IF(Home!F11=\"\", 10000, Home!F11/2000)","v":10000},0,null,null,null,true,null,null,null,9,0,"","",0,"",0,0,0,0,0,0,0]
[0,{"$f":"Home!C12","v":200},{"$f":"Home!B12","v":"AMS"},21,0,0,21,0,0,420,0,0,"","","",true,{"$f":"IF(Home!E12=\"\", 0, Home!E12/2000)","v":0},{"$f":"IF(Home!F12=\"\", 10000, Home!F12/2000)","v":10000},0,null,null,null,true,null,null,null,10,0,"","",0,"",0,0,0,0,0,0,0]
[0,{"$f":"Home!C13","v":0},{"$f":"Home!B13","v":0},null,null,null,0,0,0,0,0,0,"","","",false,{"$f":"IF(Home!E13=\"\", 0, Home!E13/2000)","v":0},{"$f":"IF(Home!F13=\"\", 10000, Home!F13/2000)","v":10000},0,null,null,null,false,null,null,null,11,0,"","",0,"",0,0,0,0,0,0,0]
[0,{"$f":"Home!C14","v":0},{"$f":"Home!B14","v":0},null,null,null,0,0,0,0,0,0,"","","",false,{"$f":"IF(Home!E14=\"\", 0, Home!E14/2000)","v":0},{"$f":"IF(Home!F14=\"\", 10000, Home!F14/2000)","v":10000},0,null,null,null,false,null,null,null,12,0,"","",0,"",0,0,0,0,0,0,0]
[0,{"$f":"Home!C15","v":0},{"$f":"Home!B15","v":0},null,null,null,0,0,0,0,0,0,"","","",false,{"$f":"IF(Home!E15=\"\", 0, Home!E15/2000)","v":0},{"$f":"IF(Home!F15=\"\", 10000, Home!F15/2000)","v":10000},0,null,null,null,false,null,null,null,13,0,"","",0,"",0,0,0,0,0,0,0]
[0,{"$f":"Home!C16","v":0},{"$f":"Home!B16","v":0},null,null,null,0,0,0,0,0,0,"","","",false,{"$f":"IF(Home!E16=\"\", 0, Home!E16/2000)","v":0},{"$f":"IF(Home!F16=\"\", 10000, Home!F16/2000)","v":10000},0,null,null,null,false,null,null,null,14,0,"","",0,"",0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total cost",{"$f":"SUM(S4:S17)","v":121.43575468363379},null,null,null,null,null,null,null,null,null,null,null,null,"sum",{"$f":"SUM(AG4:AG17)","v":121.36249999999998},null,null,"Sum",{"$f":"SUM(AK4:AK17)","v":199.78},{"$f":"SUM(AL4:AL17)","v":99.82},100.2]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(M4:M17)","v":1},null,{"$f":"COUNT(O4:O17)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,"Min price per unit",{"$f":"IF(M20=1, LARGE(M4:M17, 1), \"\")","v":0.29390243902439023},{"$f":"IFERROR((S19-K37)/ E34, \"\")","v":0.35238600212089083},{"$f":"IF(O20=1, LARGE(O4:O17, 1), \"\")","v":0.27416666666666667}]
[null,null,null,null,null,null,null,null,null,null,null,"Answer",{"$f":"IF(ISNUMBER(M21), M21, IF(G33>0, \"Unable to calculate a price per unit\", \"\"))","v":0.29390243902439023},{"$f":"IF(M22= \"Unable to calculate a price per unit\", M22, N21)","v":0.35238600212089083},{"$f":"O21","v":0.27416666666666667}]
[]
[]
[]
[]
[null,null,null,"Without application cost",null,null,"With app cost"]
[null,null,null,"Minimize",null,null,"material","applications","Minimize"]
[null,null,null,{"$f":"SUMPRODUCT(A4:A17,B4:B17)","v":121.43575468363379},null,null,{"$f":"SUMPRODUCT(A4:A17, B4:B17, Y4:Y17)","v":0},{"$f":"SUMPRODUCT(X4:X17, Y4:Y17)","v":0},{"$f":"G29+H29","v":0}]
[]
[null,null,null,null,null,null,"fertilization recommendations"]
[null,null,null,"Constraint",null,null,"pounds",null,"Maximum level",null,"Cost "]
[null,null,null,"N amount",{"$f":"SUMPRODUCT(A4:A17,J4:J17)","v":199.99999999999997},">",{"$f":"Home!J4","v":200},null,{"$f":"IF(Home!J5=\"\", 10000, Home!J5)","v":10000},null,{"$f":"IFERROR(E33*M21, 0)","v":58.780487804878035}]
[null,null,null,"P",{"$f":"SUMPRODUCT(A4:A17,K4:K17)","v":100},">",{"$f":"Home!K4","v":100},null,{"$f":"IF(Home!K5=\"\", 10000, Home!K5)","v":10000}]
[null,null,null,"K",{"$f":"SUMPRODUCT(A4:A17,L4:L17)","v":100.00000000000001},">",{"$f":"Home!L4","v":100},null,{"$f":"IF(Home!L5=\"\", 10000, Home!L5)","v":10000},null,{"$f":"IFERROR(G35*O21, 0)","v":27.416666666666668}]
[]
[null,null,null,null,null,null,null,null,null,"sum",{"$f":"SUM(K33:K35)","v":86.197154471544707}]
[]
[]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21]
[]
[null,"Worksheet values",null,"Check",null,null,null,"Latest Solution",null,null,null,null,null,"Scenarios"]
[null,{"$f":"B4","v":482},482,{"$f":"IF(B43=C43, 0, 1)","v":0},null,null,null,{"$f":"C4","v":"Anhydrous Ammonia"},{"$f":"ROUND(A4*2000, 0)","v":196},null,null,null,null,{"$f":"H43","v":"Anhydrous Ammonia"},196,9999,9999,9999,9999]
[null,{"$f":"B5","v":353},353,{"$f":"IF(B44=C44, 0, 1)","v":0},null,null,null,{"$f":"C5","v":"Urea"},{"$f":"ROUND(A5*2000, 0)","v":0},null,null,null,null,{"$f":"H44","v":"Urea"},0,9999,9999,9999,9999]
[null,236,236,0,null,null,null,"UAN28",0,null,null,null,null,"UAN28",0,9999,9999,9999,9999]
[null,270,270,0,null,null,null,"UAN32",0,null,null,null,null,"UAN32",0,9999,9999,9999,9999]
[null,430,430,0,null,null,null,"DAP",217,null,null,null,null,"DAP",217,9999,9999,9999,9999]
[null,448,448,0,null,null,null,"MAP",0,null,null,null,null,"MAP",0,9999,9999,9999,9999]
[null,439,439,0,null,null,null,"10-34-0",0,null,null,null,null,"10-34-0",0,9999,9999,9999,9999]
[null,329,329,0,null,null,null,"Potash",167,null,null,null,null,"Potash",167,9999,9999,9999,9999]
[null,250,250,0,null,null,null,"Ammonium nitrate",0,null,null,null,null,"Ammonium nitrate",0,9999,9999,9999,9999]
[null,200,200,0,null,null,null,"AMS",0,null,null,null,null,"AMS",0,9999,9999,9999,9999]
[null,0,0,0,null,null,null,0,0,null,null,null,null,0,0,9999,9999,9999,9999]
[null,0,0,0,null,null,null,0,0,null,null,null,null,0,0,9999,9999,9999,9999]
[null,0,0,0,null,null,null,0,0,null,null,null,null,0,0,9999,9999,9999,9999]
[null,0,0,0,null,null,null,0,0,null,null,null,null,0,0,9999,9999,9999,9999]
[null,{"$f":"C4","v":"Anhydrous Ammonia"},"Anhydrous Ammonia",0,null,null,null,null,null,null,null,null,null,"App cost",{"$f":"Home!C50","v":0},{"$f":"Home!D50","v":0},{"$f":"Home!E50","v":0},{"$f":"Home!F50","v":0},{"$f":"Home!G50","v":0}]
[null,"Urea","Urea",0]
[null,"UAN28","UAN28",0,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O43=9999, 9999, SUMPRODUCT(O43:O56, $B$4:$B$17) / 2000 + O57)","v":121.3625},{"$f":"IF(P43=9999, 9999, SUMPRODUCT(P43:P56, $B$4:$B$17) / 2000 + P57)","v":9999},9999,9999,9999]
[null,"UAN32","UAN32",0]
[null,"DAP","DAP",0]
[null,"MAP","MAP",0]
[null,"10-34-0","10-34-0",0]
[null,"Potash","Potash",0]
[null,"Ammonium nitrate","Ammonium nitrate",0]
[null,"AMS","AMS",0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,{"$f":"P4","v":true},true,0]
[null,true,true,0]
[null,true,true,0]
[null,true,true,0]
[null,true,true,0]
[null,true,true,0]
[null,true,true,0]
[null,true,true,0]
[null,true,true,0]
[null,true,true,0]
[null,false,false,0]
[null,false,false,0]
[null,false,false,0]
[null,false,false,0]
[null,{"$f":"Q4","v":0},0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,{"$f":"R4","v":10000},10000,0]
[null,10000,10000,0]
[null,10000,10000,0]
[null,10000,10000,0]
[null,10000,10000,0]
[null,10000,10000,0]
[null,10000,10000,0]
[null,10000,10000,0]
[null,10000,10000,0]
[null,10000,10000,{"$f":"IF(B108=C108, 0, 1)","v":0}]
[null,10000,10000,0]
[null,10000,10000,0]
[null,10000,10000,0]
[null,10000,10000,0]
[null,{"$f":"G33","v":200},200,0]
[null,{"$f":"G34","v":100},100,0]
[null,100,100,0]
[null,{"$f":"I33","v":10000},10000,0]
[null,{"$f":"I34","v":10000},10000,0]
[null,10000,10000,0]
[null,{"$f":"X4","v":0},0,0]
[null,{"$f":"X5","v":0},0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[null,0,0,0]
[]
[]
[]
[null,null,"Sum",{"$f":"SUM(D43:D132)","v":0}]