{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Start Menu","Fertilizer Calculator","Read Me","Selection of Fertilizers"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":19,"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":"Start Menu","index":0,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Fertilizer Calculator"]
[]
[null,"Choose from the following options"]

{"sheet":"Fertilizer Calculator","index":1,"n_rows":185,"n_cols":42,"rows_kept":185,"cut":false,"hidden":false,"merged":[[2,1,4,23],[50,2,50,6],[51,2,51,6],[53,9,54,12],[56,1,59,1],[55,5,55,8],[49,2,49,6],[56,20,57,23],[58,20,58,23],[45,16,45,17],[43,1,43,23],[33,17,33,19],[47,32,47,35],[56,14,58,14],[48,17,48,18],[49,17,49,18],[50,17,50,18],[51,17,51,18],[58,16,58,19],[56,16,57,19],[158,1,158,17],[134,1,134,17],[145,1,145,17],[146,1,146,17],[147,1,147,17],[148,1,148,17],[137,1,137,17],[144,1,144,17],[151,1,151,17],[140,1,140,17],[138,1,138,17],[141,1,141,17],[139,1,139,17],[152,1,152,17],[153,1,153,17],[154,1,154,17],[155,1,155,17],[93,1,93,4],[115,1,115,8],[130,1,130,8],[48,2,48,6],[117,1,120,23],[127,1,127,23],[56,2,58,8],[131,1,131,17],[132,1,132,17],[133,1,133,17],[123,1,123,23],[125,1,125,23],[126,1,126,23],[56,13,58,13],[159,1,159,17],[160,1,160,17],[161,1,161,17],[162,1,162,17],[167,5,167,8],[184,1,186,23],[190,1,190,23],[168,20,169,23],[170,20,170,23],[168,2,170,8],[168,13,170,13],[168,14,170,14],[168,16,169,19],[170,16,170,19],[182,1,182,22]]}
[null,"Fertilizer Calculator (ver. 3.0) -  by Craig Saxe and Justin Eckelberg, UW-Extension"]
[]
[null,"This spreadsheet is best suited for gardens, lawns and small field plots.  It computes the amount of fertilizer needed based on the nutrient ratio of the fertilizer (the numbers displayed on the fertilizer label, sometimes called the \"N-P-K ratio\"), then calculates the pounds of nitrogen (N), phosphate (P205), and potash (K20) necessary for a given area, as recommended by a current soil test report."]
[]
[]
[]
[null,"Input Data"]
[]
[null,"Step 1.  Type in a name that best identifies the"]
[null,"  garden, lawn or field:"]
[]
[null,"Step 2.  Select (by clicking to highlight) the units"]
[null,"  this garden, lawn or field is measured by:"]
[]
[]
[null,"Step 3.  Enter the measurements for this garden,",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE($AK$54,$AL$49,\"  \")","v":"  "},null,{"$f":"CHOOSE($AK$54,$AM$49,\"  \")","v":"  "},null,{"$f":"CHOOSE($AK$54,$AN$49,\" \")","v":" "},null,null,null,null,null,"Square Feet =",{"$f":"Q16*S16","v":0},"Calculation Choosen:",{"$f":"CHOOSE(AK54,AA16,AA17)","v":0}]
[null,"  lawn or field:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE($AK$54,\"  \",$AL$50)","v":"total acres ="},null,{"$f":"CHOOSE($AK$54,\"  \",$AM$50)","v":"acres"},null,null,null,null,null,null,null,"Acres sq ft =",{"$f":"Q17*43560","v":0}]
[]
[null,"Step 4.  Select (by clicking to highlight) the units that"]
[null,"  will be used when applying fertilizer to this"]
[null,"  garden, lawn or field:"]
[]
[]
[]
[]
[]
[]
[null,"Refer to Soil Test Report"]
[]
[null,"Step 5.  Select (by clicking to highlight) the units used"]
[null,"  on the soil test report when recommending"]
[null,"  nutrients to apply to this garden, lawn or field:"]
[]
[null,"Step 6.  Enter recommended nutrients to apply.  Usually",null,null,null,null,null,null,null,null,null,null,null,null,null,"Nutrient Needed",null,{"$f":"CHOOSE($AO$54,$AO$49,$AO$50,$AO$51)","v":"Pounds per Acre"}]
[null,"  labeled on the soil test report as \"Nutrients to",null,null,null,null,null,null,null,null,null,null,null,null,null,"Nitrogen:","       N"]
[null,"             Apply\" or \"Actual Nutrient Need\"):",null,null,null,null,null,null,null,null,null,null,null,null,null,"Phosphate:","  P205"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Potash:","   K20"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sulfur - if requested:","      S"]
[]
[]
[]
[null,"View All Calculated Results"]
[]
[null,"Select a fertilizer in the left column, then read across to the shaded column to view the recommended application rate."]
[]
[]
[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,1,2]
[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,"Sum Row","Divide by","lbs need in garden",null,null,"Step 5. Units Used","Conversion","Use Conversion factors?",null,null,null,"Step 1.  Area Units","Step 2. Area Covered",null,null,"Step 3. Test Report Units"]
[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,{"$f":"R35","v":0},{"$f":"CHOOSE($AO$54,$AP$49,$AP$50,$AP$51)","v":43560},{"$f":"(Z49/AA49)*AC16","v":0},null,null,"Ounces",16,1,null,null,null,"Square Feet","length x width =","feet by","feet","Pounds per 100 sq ft",100]
[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,{"$f":"R36","v":0},{"$f":"CHOOSE($AO$54,$AP$49,$AP$50,$AP$51)","v":43560},{"$f":"(Z50/AA50)*AC16","v":0},null,null,"Pounds",1,1,null,null,null,"Acres","total acres =","acres",null,"Pounds per 1000 sq ft",1000]
[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,{"$f":"R37","v":0},43560,{"$f":"(Z51/AA51)*AC16","v":0},null,null,"Tons",5.0000000000000001E-4,1,null,null,null,null,null,null,null,"Pounds per Acre",43560]
[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,{"$f":"R38","v":0},43560,{"$f":"(Z52/AA52)*AC16","v":0},null,"Tbsp","Tbsp-Estimated",32,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,null,null,null,null,null,"Cups-Estimated",2,0,null,null,null,"Control Cell Link",null,null,null,"Control Cell Link"]
[null,null,null,null,null,null,null,null,null,"Pounds needed of listed fertilizer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pints-Estimated ",1,0,null,null,null,2,null,null,null,3]
[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,"Quarts-Estimated",0.5,0]
[null,{"$f":"IF(P10=0,\"  \",P10)","v":"  "},"Calculated on:",null,null,{"$f":"TODAY()","v":"2017-06-12"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gallons -Estimated",0.125,0]
[null,"Common Fertilizer Options to Consider ","% Plant Food Analysis",null,null,null,null,null,null,"N","P2O5","K2O","S","Fertilizer to Apply:","Pounds of fertilizer required for entered square footage of:",{"$f":"CHOOSE(AE60,AE49,AE50,AE51,AE52,AE53,AE54,AE55,AE56)","v":"Tons"},"Nutrient Deficits",null,null,null,"Nutrient Surpluses"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer Applied to:",null,null,null,null,null,null,null,null,null,null,null,"Convert lbs to step 6 final units selected:",null,{"$f":"INDEX($AF$49:$AG$56,$AE$60,1)","v":5.0000000000000001E-4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE($AK$54,$AA$16,$AA$17/43560)","v":0},{"$f":"P57","v":"Tons"},null,null,null,{"$f":"P57","v":"Tons"},null,null,null,null,null,null,"Use Conversion factor (1=yes, 0=no):",null,{"$f":"INDEX($AF$49:$AG$56,$AE$60,2)","v":1},"Control Cell Link"]
[null,null,"N","-","P2O5","-","K2O","-","S",{"$f":"$R$35","v":0},{"$f":"$R$36","v":0},{"$f":"$R$37","v":0},{"$f":"$R$38","v":0},{"$f":"CHOOSE($AO$54,$AO$49,$AO$50,$AO$51)","v":"Pounds per Acre"},{"$f":"AC16","v":0},{"$f":"CHOOSE($AK$54,$AK$49,$AK$50)","v":"Acres"},"      N","P2O5","K2O","S","      N","P2O5","K2O","S",null,null,null,null,null,null,3,null,"Conversion factors weight to volume (0 if unknown)"]
[null,"Urea",46,"-",0,"-",0,"-",0,{"$f":"IF(C61=0,\"\",($J$60/C61)*100)","v":0},{"$f":"IF(E61=0,\"\",($K$60/E61)*100)","v":""},{"$f":"IF(G61=0,\"\",($L$60/G61)*100)","v":""},{"$f":"IF(I61=0,\"\",($M$60/I61)*100)","v":""},{"$f":"MAX(J61:M61)","v":0},{"$f":"+(N61/$AA$49)*$AC$16","v":0},{"$f":"IF($AD$59=1,(N61/$AA$49)*$AC$16*$AD$58,IF(AG61=0, \"  \", (N61/$AA$49)*$AC$16*$AD$58*AG61))","v":0},{"$f":"IF($AD$59=1,(((C61/100)*O61)-$AB$49)*$AD$58,IF(AG61=0, \"  \", (((C61/100)*O61)-$AB$49)*$AD$58*AG61))","v":0},{"$f":"IF($AD$59=1,(((E61/100)*O61)-$AB$50)*$AD$58,IF(AG61=0, \"  \", (((E61/100)*O61)-$AB$50)*$AD$58*AG61))","v":0},{"$f":"IF($AD$59=1,(((G61/100)*O61)-$AB$51)*$AD$58,IF(AG61=0, \"  \", (((G61/100)*O61)-$AB$51)*$AD$58*AG61))","v":0},{"$f":"IF($AD$59=1,(((I61/100)*O61)-$AB$52)*$AD$58,IF(AG61=0, \"  \", (((I61/100)*O61)-$AB$52)*$AD$58*AG61))","v":0},{"$f":"IF($AD$59=1,(((C61/100)*O61)-$AB$49)*$AD$58,IF(AG61=0, \"  \", (((C61/100)*O61)-$AB$49)*$AD$58*AG61))","v":0},{"$f":"IF($AD$59=1,(((E61/100)*O61)-$AB$50)*$AD$58,IF(AG61=0, \"  \", (((E61/100)*O61)-$AB$50)*$AD$58*AG61))","v":0},{"$f":"IF($AD$59=1,(((G61/100)*O61)-$AB$51)*$AD$58,IF(AG61=0, \"  \", (((G61/100)*O61)-$AB$51)*$AD$58*AG61))","v":0},{"$f":"IF($AD$59=1,(((I61/100)*O61)-$AB$51)*$AD$58,IF(AH61=0, \"  \", (((I61/100)*O61)-$AB$51)*$AD$58*AH61))","v":0},null,null,null,null,null,null,null,null,1]
[null,"Ammonium Sulfate ",21,"-",0,"-",0,"-",24,{"$f":"IF(C62=0,\"\",($J$60/C62)*100)","v":0},{"$f":"IF(E62=0,\"\",($K$60/E62)*100)","v":""},{"$f":"IF(G62=0,\"\",($L$60/G62)*100)","v":""},{"$f":"IF(I62=0,\"\",($M$60/I62)*100)","v":0},0,0,0,{"$f":"IF($AD$59=1,(((C62/100)*O62)-$AB$49)*$AD$58,IF(AG62=0, \"  \", (((C62/100)*O62)-$AB$49)*$AD$58*AG62))","v":0},{"$f":"IF($AD$59=1,(((E62/100)*O62)-$AB$50)*$AD$58,IF(AG62=0, \"  \", (((E62/100)*O62)-$AB$50)*$AD$58*AG62))","v":0},{"$f":"IF($AD$59=1,(((G62/100)*O62)-$AB$51)*$AD$58,IF(AG62=0, \"  \", (((G62/100)*O62)-$AB$51)*$AD$58*AG62))","v":0},{"$f":"IF($AD$59=1,(((I62/100)*O62)-$AB$52)*$AD$58,IF(AG62=0, \"  \", (((I62/100)*O62)-$AB$52)*$AD$58*AG62))","v":0},{"$f":"IF($AD$59=1,(((C62/100)*O62)-$AB$49)*$AD$58,IF(AG62=0, \"  \", (((C62/100)*O62)-$AB$49)*$AD$58*AG62))","v":0},{"$f":"IF($AD$59=1,(((E62/100)*O62)-$AB$50)*$AD$58,IF(AG62=0, \"  \", (((E62/100)*O62)-$AB$50)*$AD$58*AG62))","v":0},{"$f":"IF($AD$59=1,(((G62/100)*O62)-$AB$51)*$AD$58,IF(AG62=0, \"  \", (((G62/100)*O62)-$AB$51)*$AD$58*AG62))","v":0},{"$f":"IF($AD$59=1,(((I62/100)*O62)-$AB$51)*$AD$58,IF(AH62=0, \"  \", (((I62/100)*O62)-$AB$51)*$AD$58*AH62))","v":0},null,null,null,null,null,null,null,null,1]
[null,"MAP",11,"-",52,"-",0,"-",0,0,0,"","",0,0,0,0,0,0,0,0,0,{"$f":"IF($AD$59=1,(((G63/100)*O63)-$AB$51)*$AD$58,IF(AG63=0, \"  \", (((G63/100)*O63)-$AB$51)*$AD$58*AG63))","v":0},0,null,null,null,null,null,null,null,null,1]
[null,"DAP",18,"-",46,"-",0,"-",0,0,0,"","",0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,1.3]
[null,"TSP",0,"-",46,"-",0,"-",0,"",0,"","",0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,1]
[null,"Potassium Sulfate",0,"-",0,"-",50,"-",18,"","",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,1]
[null,"Magnesium Sulfate ",0,"-",0,"-",0,"-",14,"","","",0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0.75]
[null,"Potash",0,"-",0,"-",60,"-",0,"","",0,"",0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"Triple Ten",10,"-",10,"-",10,"-",0,0,0,0,"",0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"Triple Seventeen",17,"-",17,"-",17,"-",0,0,0,0,"",0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"18-18-18",18,"-",18,"-",18,"-",0,{"$f":"IF(C71=0,\"\",($J$60/C71)*100)","v":0},{"$f":"IF(E71=0,\"\",($K$60/E71)*100)","v":0},{"$f":"IF(G71=0,\"\",($L$60/G71)*100)","v":0},{"$f":"IF(I71=0,\"\",($M$60/I71)*100)","v":""},{"$f":"MAX(J71:M71)","v":0},0,0,{"$f":"IF($AD$59=1,(((C71/100)*O71)-$AB$49)*$AD$58,IF(AG71=0, \"  \", (((C71/100)*O71)-$AB$49)*$AD$58*AG71))","v":0},{"$f":"IF($AD$59=1,(((E71/100)*O71)-$AB$50)*$AD$58,IF(AG71=0, \"  \", (((E71/100)*O71)-$AB$50)*$AD$58*AG71))","v":0},{"$f":"IF($AD$59=1,(((G71/100)*O71)-$AB$51)*$AD$58,IF(AG71=0, \"  \", (((G71/100)*O71)-$AB$51)*$AD$58*AG71))","v":0},{"$f":"IF($AD$59=1,(((I71/100)*O71)-$AB$52)*$AD$58,IF(AG71=0, \"  \", (((I71/100)*O71)-$AB$52)*$AD$58*AG71))","v":0},{"$f":"IF($AD$59=1,(((C71/100)*O71)-$AB$49)*$AD$58,IF(AG71=0, \"  \", (((C71/100)*O71)-$AB$49)*$AD$58*AG71))","v":0},{"$f":"IF($AD$59=1,(((E71/100)*O71)-$AB$50)*$AD$58,IF(AG71=0, \"  \", (((E71/100)*O71)-$AB$50)*$AD$58*AG71))","v":0},{"$f":"IF($AD$59=1,(((G71/100)*O71)-$AB$51)*$AD$58,IF(AG71=0, \"  \", (((G71/100)*O71)-$AB$51)*$AD$58*AG71))","v":0},{"$f":"IF($AD$59=1,(((I71/100)*O71)-$AB$51)*$AD$58,IF(AH71=0, \"  \", (((I71/100)*O71)-$AB$51)*$AD$58*AH71))","v":0},null,null,null,null,null,null,null,null,0]
[null,"12-40-0-10-1Zn",12,"-",40,"-",0,"-",10,0,0,"",0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"11-41-8",11,"-",41,"-",8,"-",0,0,0,0,"",0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"10-34-0",10,"-",34,"-",0,"-",0,0,0,"","",0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"10-12-30",10,"-",12,"-",30,"-",0,0,0,0,"",0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"9-23-30",9,"-",23,"-",30,"-",0,0,0,0,"",0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"9-18-9",9,"-",18,"-",9,"-",0,0,0,0,"",0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"9-15-30",9,"-",15,"-",30,"-",0,0,0,0,"",0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"6-24-6",6,"-",24,"-",6,"-",0,0,0,0,"",0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"4-41-27",4,"-",41,"-",27,"-",0,0,0,0,"",0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"4-10-40",4,"-",10,"-",40,"-",0,0,0,0,"",0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,0]
[null,"Solid Manure Choices ",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,0]
[null,"Dairy Manure",0.15,"-",0.15,"-",0.36,null,0.04,0,0,0,0,{"$f":"MAX(J84:M84)","v":0},{"$f":"+(N84/$AA$49)*$AC$16","v":0},{"$f":"IF($AD$59=1,(N84/$AA$49)*$AC$16*$AD$58,IF(AG84=0, \"  \", (N84/$AA$49)*$AC$16*$AD$58*AG84))","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"Beef Manure",0.17499999999999999,"-",0.27,"-",0.44,null,0.04,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"Swine Manure",0.35,"-",0.3,"-",0.36,null,0.08,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"Chicken Manure",1,"-",1.5,"-",1.2,null,0.1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"Horse Manure",0.125,"-",0.18,"-",0.4,null,7.0000000000000007E-2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"Sheep Manure",0.32500000000000001,"-",0.54,"-",1.6,null,0.08,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[]
[null,"1. Add your own",0,"-",0,"-",0,"-",0,{"$f":"IF(C91=0,\"\",($J$60/C91)*100)","v":""},{"$f":"IF(E91=0,\"\",($K$60/E91)*100)","v":""},{"$f":"IF(G91=0,\"\",($L$60/G91)*100)","v":""},{"$f":"IF(I91=0,\"\",($M$60/I91)*100)","v":""},{"$f":"MAX(J91:M91)","v":0},{"$f":"+(N91/$AA$49)*$AC$16","v":0},{"$f":"IF($AD$59=1,(N91/$AA$49)*$AC$16*$AD$58,IF(AG91=0, \"  \", (N91/$AA$49)*$AC$16*$AD$58*AG91))","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"2. Add your own",0,"-",0,"-",0,"-",0,{"$f":"IF(C92=0,\"\",($J$60/C92)*100)","v":""},{"$f":"IF(E92=0,\"\",($K$60/E92)*100)","v":""},{"$f":"IF(G92=0,\"\",($L$60/G92)*100)","v":""},{"$f":"IF(I92=0,\"\",($M$60/I92)*100)","v":""},{"$f":"MAX(J92:M92)","v":0},{"$f":"+(N92/$AA$49)*$AC$16","v":0},{"$f":"IF($AD$59=1,(N92/$AA$49)*$AC$16*$AD$58,IF(AG92=0, \"  \", (N92/$AA$49)*$AC$16*$AD$58*AG92))","v":0},{"$f":"IF($AD$59=1,(((C92/100)*O92)-$AB$49)*$AD$58,IF(AG92=0, \"  \", (((C92/100)*O92)-$AB$49)*$AD$58*AG92))","v":0},{"$f":"IF($AD$59=1,(((E92/100)*O92)-$AB$50)*$AD$58,IF(AG92=0, \"  \", (((E92/100)*O92)-$AB$50)*$AD$58*AG92))","v":0},{"$f":"IF($AD$59=1,(((G92/100)*O92)-$AB$51)*$AD$58,IF(AG92=0, \"  \", (((G92/100)*O92)-$AB$51)*$AD$58*AG92))","v":0},{"$f":"IF($AD$59=1,(((I92/100)*O92)-$AB$52)*$AD$58,IF(AG92=0, \"  \", (((I92/100)*O92)-$AB$52)*$AD$58*AG92))","v":0},{"$f":"IF($AD$59=1,(((C92/100)*O92)-$AB$49)*$AD$58,IF(AG92=0, \"  \", (((C92/100)*O92)-$AB$49)*$AD$58*AG92))","v":0},{"$f":"IF($AD$59=1,(((E92/100)*O92)-$AB$50)*$AD$58,IF(AG92=0, \"  \", (((E92/100)*O92)-$AB$50)*$AD$58*AG92))","v":0},{"$f":"IF($AD$59=1,(((G92/100)*O92)-$AB$51)*$AD$58,IF(AG92=0, \"  \", (((G92/100)*O92)-$AB$51)*$AD$58*AG92))","v":0},{"$f":"IF($AD$59=1,(((I92/100)*O92)-$AB$51)*$AD$58,IF(AH92=0, \"  \", (((I92/100)*O92)-$AB$51)*$AD$58*AH92))","v":0},null,null,null,null,null,null,null,null,0]
[null,"3. Add your own",0,"-",0,"-",0,"-",0,{"$f":"IF(C93=0,\"\",($J$60/C93)*100)","v":""},{"$f":"IF(E93=0,\"\",($K$60/E93)*100)","v":""},{"$f":"IF(G93=0,\"\",($L$60/G93)*100)","v":""},{"$f":"IF(I93=0,\"\",($M$60/I93)*100)","v":""},{"$f":"MAX(J93:M93)","v":0},{"$f":"+(N93/$AA$49)*$AC$16","v":0},{"$f":"IF($AD$59=1,(N93/$AA$49)*$AC$16*$AD$58,IF(AG93=0, \"  \", (N93/$AA$49)*$AC$16*$AD$58*AG93))","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,0]
[null,"Personal Blend of:   (details below)"]
[null,{"$f":"INDEX(B61:B93,AE131)","v":0},{"$f":"AA131","v":0},"-",{"$f":"AB131","v":0},"-",{"$f":"AC131","v":0},"-",{"$f":"AD131","v":0},{"$f":"IF(C95=0,\"\",($J$60/C95)*100)","v":""},{"$f":"IF(E95=0,\"\",($K$60/E95)*100)","v":""},{"$f":"IF(G95=0,\"\",($L$60/G95)*100)","v":""},{"$f":"IF(I95=0,\"\",($M$60/I95)*100)","v":""},{"$f":"(CHOOSE(AE133,J95,K95,L95,M95,MAX(J95:M95))*(T135/100))","v":0},{"$f":"+(N95/$AA$49)*$AC$16","v":0},{"$f":"IF($AD$59=1,(N95/$AA$49)*$AC$16*$AD$58,IF(AG95=0, \"  \", (N95/$AA$49)*$AC$16*$AD$58*AG95))","v":0},{"$f":"IF($AD$59=1,(((C95/100)*O95)-$AB$49)*$AD$58,IF(AG95=0, \"  \", (((C95/100)*O95)-$AB$49)*$AD$58*AG95))","v":0},{"$f":"IF($AD$59=1,(((E95/100)*O95)-$AB$50)*$AD$58,IF(AG95=0, \"  \", (((E95/100)*O95)-$AB$50)*$AD$58*AG95))","v":0},{"$f":"IF($AD$59=1,(((G95/100)*O95)-$AB$51)*$AD$58,IF(AG95=0, \"  \", (((G95/100)*O95)-$AB$51)*$AD$58*AG95))","v":0},{"$f":"IF($AD$59=1,(((I95/100)*O95)-$AB$52)*$AD$58,IF(AG95=0, \"  \", (((I95/100)*O95)-$AB$52)*$AD$58*AG95))","v":0},{"$f":"IF($AD$59=1,(((C95/100)*O95)-$AB$49)*$AD$58,IF(AG95=0, \"  \", (((C95/100)*O95)-$AB$49)*$AD$58*AG95))","v":0},{"$f":"IF($AD$59=1,(((E95/100)*O95)-$AB$50)*$AD$58,IF(AG95=0, \"  \", (((E95/100)*O95)-$AB$50)*$AD$58*AG95))","v":0},{"$f":"IF($AD$59=1,(((G95/100)*O95)-$AB$51)*$AD$58,IF(AG95=0, \"  \", (((G95/100)*O95)-$AB$51)*$AD$58*AG95))","v":0},{"$f":"IF($AD$59=1,(((I95/100)*O95)-$AB$51)*$AD$58,IF(AH95=0, \"  \", (((I95/100)*O95)-$AB$51)*$AD$58*AH95))","v":0},null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Amount supplied:",null,null,null,null,{"$f":"+C95*N95/100","v":0},{"$f":"+E95*N95/100","v":0},{"$f":"+G95*N95/100","v":0},{"$f":"+I95*N95/100","v":0},null,null,null,{"$f":"(C95*$P$95)/100","v":0},{"$f":"(E95*$P$95)/100","v":0},{"$f":"(G95*$P$95)/100","v":0},{"$f":"(I95*$P$95)/100","v":0},{"$f":"(C95*$P$95)/100","v":0},{"$f":"(E95*$P$95)/100","v":0},{"$f":"(G95*$P$95)/100","v":0}]
[null,null,null,null,"Balance still needed:",null,null,null,null,{"$f":"+$J$60-J96","v":0},{"$f":"+$K$60-K96","v":0},{"$f":"+$L$60-L96","v":0},{"$f":"+$M$60-M96","v":0}]
[null,null,null,null,"Surplus:",null,null,null,null,{"$f":"J97*-1","v":0},{"$f":"K97*-1","v":0},0,0]
[null,{"$f":"INDEX(B61:B93,AE138)","v":0},{"$f":"AA138","v":0},"-",{"$f":"AB138","v":0},"-",{"$f":"AC138","v":0},"-",{"$f":"AD138","v":0},{"$f":"IF(SIGN(J97)=-1,0,IF(C99=0,\"\",(J97/C99)*100))","v":""},{"$f":"IF(SIGN(K97)=-1,0,IF(E99=0,\"\",(K97/E99)*100))","v":""},{"$f":"IF(SIGN(L97)=-1,0,IF(G99=0,\"\",(L97/G99)*100))","v":""},{"$f":"IF(SIGN(M97)=-1,0,IF(I99=0,\"\",(M97/I99)*100))","v":""},{"$f":"(CHOOSE(AE140,J99,K99,L99,M99,MAX(J99:M99))*(T142/100))","v":0},{"$f":"+(N99/$AA$49)*$AC$16","v":0},{"$f":"IF($AD$59=1,(N99/$AA$49)*$AC$16*$AD$58,IF(AG99=0, \"  \", (N99/$AA$49)*$AC$16*$AD$58*AG99))","v":0},{"$f":"+(J102/$AA$49)*$AC$16","v":0},{"$f":"+(K102/$AA$49)*$AC$16","v":0},{"$f":"+(L102/$AA$49)*$AC$16","v":0},{"$f":"+(M102/$AA$49)*$AC$16","v":0},{"$f":"+(J102/$AA$49)*$AC$16","v":0},{"$f":"+(K102/$AA$49)*$AC$16","v":0},{"$f":"+(L102/$AA$49)*$AC$16","v":0},{"$f":"+(M102/$AA$49)*$AC$16","v":0},null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Amount supplied:",null,null,null,null,{"$f":"+C99*N99/100","v":0},{"$f":"+E99*N99/100","v":0},{"$f":"+G99*N99/100","v":0},{"$f":"+I99*N99/100","v":0},null,null,null,{"$f":"(C99*$P$99)/100","v":0},{"$f":"(E99*$P$99)/100","v":0},{"$f":"(G99*$P$99)/100","v":0},{"$f":"(I99*$P$99)/100","v":0},{"$f":"(C99*$P$99)/100","v":0},{"$f":"(E99*$P$99)/100","v":0},{"$f":"(G99*$P$99)/100","v":0}]
[null,null,null,null,"Balance still needed:",null,null,null,null,{"$f":"+J97-J100","v":0},{"$f":"+K97-K100","v":0},{"$f":"+L97-L100","v":0},{"$f":"+M97-M100","v":0}]
[null,null,null,null,"Surplus:",null,null,null,null,{"$f":"J101*-1","v":0},{"$f":"K101*-1","v":0},0,0]
[null,{"$f":"INDEX(B61:B93,AE145)","v":0},{"$f":"AA145","v":0},"-",{"$f":"AB145","v":0},"-",{"$f":"AC145","v":0},"-",{"$f":"AD145","v":0},{"$f":"IF(SIGN(J101)=-1,0,IF(C103=0,\"\",(J101/C103)*100))","v":""},{"$f":"IF(SIGN(K101)=-1,0,IF(E103=0,\"\",(K101/E103)*100))","v":""},{"$f":"IF(SIGN(L101)=-1,0,IF(G103=0,\"\",(L101/G103)*100))","v":""},{"$f":"IF(SIGN(M101)=-1,0,IF(I103=0,\"\",(M101/I103)*100))","v":""},{"$f":"(CHOOSE(AE147,J103,K103,L103,M103,MAX(J103:M103))*(T149/100))","v":0},{"$f":"+(N103/$AA$49)*$AC$16","v":0},{"$f":"IF($AD$59=1,(N103/$AA$49)*$AC$16*$AD$58,IF(AG103=0, \"  \", (N103/$AA$49)*$AC$16*$AD$58*AG103))","v":0},{"$f":"+(J106/$AA$49)*$AC$16","v":0},{"$f":"+(K106/$AA$49)*$AC$16","v":0},{"$f":"+(L106/$AA$49)*$AC$16","v":0},{"$f":"+(M106/$AA$49)*$AC$16","v":0},{"$f":"+(J106/$AA$49)*$AC$16","v":0},{"$f":"+(K106/$AA$49)*$AC$16","v":0},{"$f":"+(L106/$AA$49)*$AC$16","v":0},{"$f":"+(M106/$AA$49)*$AC$16","v":0},null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Amount supplied:",null,null,null,null,{"$f":"+C103*N103/100","v":0},{"$f":"+E103*N103/100","v":0},{"$f":"+G103*N103/100","v":0},{"$f":"+I103*N103/100","v":0},null,null,null,{"$f":"(C103*$P$103)/100","v":0},{"$f":"(E103*$P$103)/100","v":0},{"$f":"(G103*$P$103)/100","v":0},{"$f":"(I103*$P$103)/100","v":0},{"$f":"(C103*$P$103)/100","v":0},{"$f":"(E103*$P$103)/100","v":0},{"$f":"(G103*$P$103)/100","v":0}]
[null,null,null,null,"Balance still needed:",null,null,null,null,{"$f":"+J101-J104","v":0},{"$f":"+K101-K104","v":0},{"$f":"+L101-L104","v":0},{"$f":"+M101-M104","v":0}]
[null,null,null,null,"Surplus:",null,null,null,null,{"$f":"J105*-1","v":0},{"$f":"K105*-1","v":0},0,0]
[null,{"$f":"INDEX(B61:B93,AE152)","v":0},{"$f":"AA152","v":0},"-",{"$f":"AB152","v":0},"-",{"$f":"AC152","v":0},"-",{"$f":"AD152","v":0},{"$f":"IF(SIGN(J105)=-1,0,IF(C107=0,\"\",(J105/C107)*100))","v":""},{"$f":"IF(SIGN(K105)=-1,0,IF(E107=0,\"\",(K105/E107)*100))","v":""},{"$f":"IF(SIGN(L105)=-1,0,IF(G107=0,\"\",(L105/G107)*100))","v":""},{"$f":"IF(SIGN(M105)=-1,0,IF(I107=0,\"\",(M105/I107)*100))","v":""},{"$f":"(CHOOSE(AE154,J107,K107,L107,M107,MAX(J107:M107))*(T156/100))","v":0},{"$f":"+(N107/$AA$49)*$AC$16","v":0},{"$f":"IF($AD$59=1,(N107/$AA$49)*$AC$16*$AD$58,IF(AG107=0, \"  \", (N107/$AA$49)*$AC$16*$AD$58*AG107))","v":0},{"$f":"+(J110/$AA$49)*$AC$16","v":0},{"$f":"+(K110/$AA$49)*$AC$16","v":0},{"$f":"+(L110/$AA$49)*$AC$16","v":0},{"$f":"+(M110/$AA$49)*$AC$16","v":0},{"$f":"+(J110/$AA$49)*$AC$16","v":0},{"$f":"+(K110/$AA$49)*$AC$16","v":0},{"$f":"+(L110/$AA$49)*$AC$16","v":0},{"$f":"+(M110/$AA$49)*$AC$16","v":0},null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Amount supplied:",null,null,null,null,{"$f":"+C107*N107/100","v":0},{"$f":"+E107*N107/100","v":0},{"$f":"+G107*N107/100","v":0},{"$f":"+I107*N107/100","v":0},null,null,null,{"$f":"(C107*$P$107)/100","v":0},{"$f":"(E107*$P$107)/100","v":0},{"$f":"(G107*$P$107)/100","v":0},{"$f":"(I107*$P$107)/100","v":0},{"$f":"(C107*$P$107)/100","v":0},{"$f":"(E107*$P$107)/100","v":0},{"$f":"(G107*$P$107)/100","v":0}]
[null,null,null,null,"Balance still needed:",null,null,null,null,{"$f":"J105-J108","v":0},{"$f":"K105-K108","v":0},0,0,null,null,null,{"$f":"Q96+Q100+Q104+Q108","v":0},{"$f":"R96+R100+R104+R108","v":0},0,0,0,0,0]
[null,null,null,null,"Surplus:",null,null,null,null,{"$f":"J109*-1","v":0},{"$f":"K109*-1","v":0},0,0]
[null,{"$f":"INDEX(B61:B93,AE159)","v":0},{"$f":"AA159","v":0},"-",{"$f":"AB159","v":0},"-",{"$f":"AC159","v":0},"-",{"$f":"AD159","v":0},{"$f":"IF(SIGN(J109)=-1,0,IF(C111=0,\"\",(J109/C111)*100))","v":""},{"$f":"IF(SIGN(K109)=-1,0,IF(E111=0,\"\",(K109/E111)*100))","v":""},{"$f":"IF(SIGN(L109)=-1,0,IF(G111=0,\"\",(L109/G111)*100))","v":""},{"$f":"IF(SIGN(M109)=-1,0,IF(I111=0,\"\",(M109/I111)*100))","v":""},{"$f":"(CHOOSE(AE161,J111,K111,L111,M111,MAX(J111:M111))*(T163/100))","v":0},{"$f":"+(N111/$AA$49)*$AC$16","v":0},{"$f":"IF($AD$59=1,(N111/$AA$49)*$AC$16*$AD$58,IF(AG111=0, \"  \", (N111/$AA$49)*$AC$16*$AD$58*AG111))","v":0},{"$f":"+(J114/$AA$49)*$AC$16","v":0},{"$f":"+(K114/$AA$49)*$AC$16","v":0},{"$f":"+(L114/$AA$49)*$AC$16","v":0},{"$f":"+(M114/$AA$49)*$AC$16","v":0},{"$f":"+(J114/$AA$49)*$AC$16","v":0},{"$f":"+(K114/$AA$49)*$AC$16","v":0},{"$f":"+(L114/$AA$49)*$AC$16","v":0},{"$f":"+(M114/$AA$49)*$AC$16","v":0},null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Amount supplied:",null,null,null,null,{"$f":"+C111*N111/100","v":0},{"$f":"+E111*N111/100","v":0},{"$f":"+G111*N111/100","v":0},{"$f":"+I111*N111/100","v":0}]
[null,null,null,null,"Sum of Deficits:",null,null,null,null,{"$f":"J109-J112","v":0},{"$f":"K109-K112","v":0},0,0]
[null,null,null,null,"Sum of Surplus:",null,null,null,null,{"$f":"J113*-1","v":0},{"$f":"K113*-1","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum of Blend:",{"$f":"+(J114/$AA$49)*$AC$16","v":0},{"$f":"+(K114/$AA$49)*$AC$16","v":0},{"$f":"+(L114/$AA$49)*$AC$16","v":0},{"$f":"+(M114/$AA$49)*$AC$16","v":0},{"$f":"+(J114/$AA$49)*$AC$16","v":0},{"$f":"+(K114/$AA$49)*$AC$16","v":0},{"$f":"+(L114/$AA$49)*$AC$16","v":0},{"$f":"+(M114/$AA$49)*$AC$16","v":0}]
[]
[null,"Select Nutrient Source"]
[null,"This spreadsheet balances nutrients based upon the nutrient in “greatest need”.  If the first fertilizer entered provides excessive nutrients as shown under the \"Nutrient Surpluses\" columns, consider trying a different product, switching the order if multiple fertilizers have been entered and/or experiment with a combination of products.   "]
[]
[]
[]
[]
[null,"Full Customization"]
[null,"These added steps are not necessary for most situations, but will allow for additional customization and experimentation."]
[]
[null,"Row B:  By default, the first selection entered balances the nutrient in greatest need.  Row B allows this default calculation to be changed."]
[null,"Row C:  Application amount of a nutrient can be limited.  As an example, this may be useful when applying manure to meet, but not exceed"]
[null,"             potassium (K2O) requirements."]
[]
[null,"Selection 1.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N","P2O4","K2O","S","O. Step 1a. Control Cell","Step b choices"]
[null,"a.  From drop down menu, select a fertilizer:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX($B$61:$I$93,$AE$131,2)","v":0},{"$f":"INDEX($B$61:$I$93,$AE$131,4)","v":0},{"$f":"INDEX($B$61:$I$93,$AE$131,6)","v":0},{"$f":"INDEX($B$61:$I$93,$AE$131,8)","v":0},22,"N"]
[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,"O. Step 1b. Control Cell","P205"]
[null,"b.  From the drop down menu, select the nutrient to balance for (default = greatest need):",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,5,"K20"]
[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,"S"]
[null,"c.  What percent of the nutrient (step b) will the fertilizer (step a) balance for (default = 100%):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"%",null,null,null,null,null,null,null,null,null,null,"Greatest Need"]
[]
[null,"Selection 2.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N","P2O4","K2O","S","O. Step 2. Control Cell"]
[null,"a.  From drop down menu, select another fertilizer (supplies what the above fertilizer does not):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX($B$61:$I$93,$AE$138,2)","v":0},{"$f":"INDEX($B$61:$I$93,$AE$138,4)","v":0},{"$f":"INDEX($B$61:$I$93,$AE$138,6)","v":0},{"$f":"INDEX($B$61:$I$93,$AE$138,8)","v":0},22]
[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,"O. Step 2b. Control Cell"]
[null,"b.  From the drop down menu, select the nutrient to balance for (default = greatest need):",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,5]
[]
[null,"c.  What percent of the nutrient (step b) will the fertilizer (step a) balance for (default = 100%):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"%"]
[]
[null,"Selection 3.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N","P2O4","K2O","S","O. Step 3. Control Cell"]
[null,"a.  From drop down menu, select another fertilizer (supplies what the above fertilizers do not):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX($B$61:$I$93,$AE$145,2)","v":0},{"$f":"INDEX($B$61:$I$93,$AE$145,4)","v":0},{"$f":"INDEX($B$61:$I$93,$AE$145,6)","v":0},{"$f":"INDEX($B$61:$I$93,$AE$145,8)","v":0},22]
[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,"O. Step 3b. Control Cell"]
[null,"b.  From the drop down menu, select the nutrient to balance for (default = greatest need):",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,5]
[]
[null,"c.  What percent of the nutrient (step b) will the fertilizer (step a) balance for (default = 100%):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"%"]
[]
[null,"Selection 4.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N","P2O4","K2O","S","O. Step 4. Control Cell"]
[null,"a.  From drop down menu, select another fertilizer (supplies what the above fertilizers do not):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX($B$61:$I$93,$AE$152,2)","v":0},{"$f":"INDEX($B$61:$I$93,$AE$152,4)","v":0},{"$f":"INDEX($B$61:$I$93,$AE$152,6)","v":0},{"$f":"INDEX($B$61:$I$93,$AE$152,8)","v":0},22]
[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,"O. Step 4b. Control Cell"]
[null,"b.  From the drop down menu, select the nutrient to balance for (default = greatest need):",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,5]
[]
[null,"c.  What percent of the nutrient (step b) will the fertilizer (step a) balance for (default = 100%):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"%"]
[]
[null,"Selection 5.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N","P2O4","K2O","S","O. Step 5. Control Cell"]
[null,"a.  From drop down menu, select another fertilizer (supplies what the above fertilizers do not):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX($B$61:$I$93,$AE$159,2)","v":0},{"$f":"INDEX($B$61:$I$93,$AE$159,4)","v":0},{"$f":"INDEX($B$61:$I$93,$AE$159,6)","v":0},{"$f":"INDEX($B$61:$I$93,$AE$159,8)","v":0},22]
[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,"O. Step 5b. Control Cell"]
[null,"b.  From the drop down menu, select the nutrient to balance for (default = greatest need):",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,5]
[]
[null,"c.  What percent of the nutrient (step b) will the fertilizer (step a) balance for (default = 100%):",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,"%"]
[]
[]
[null,"Results"]
[]
[null,{"$f":"B56","v":"  "},"Calculated on:",null,null,{"$f":"TODAY()","v":"2017-06-12"}]
[null,null,"% Plant Food Analysis",null,null,null,null,null,null,"N","P2O5","K2O","S","Fertilizer to Apply:","Pounds of fertilizer required for entered square footage of:",{"$f":"P57","v":"Tons"},"Nutrient Deficits",null,null,null,"Nutrient Surpluses"]
[null,"Fertilizers Selected",null,null,null,null,null,null,null,null,null,null,null,null,null,"Fertilizer Applied to:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHOOSE($AK$54,$AA$16,$AA$17/43560)","v":0},{"$f":"P169","v":"Tons"},null,null,null,{"$f":"P169","v":"Tons"}]
[null,null,"N","-","P2O5","-","K2O","-","S",{"$f":"$R$35","v":0},{"$f":"$R$36","v":0},{"$f":"$R$37","v":0},{"$f":"$R$38","v":0},{"$f":"CHOOSE($AO$54,$AO$49,$AO$50,$AO$51)","v":"Pounds per Acre"},{"$f":"AC16","v":0},{"$f":"CHOOSE($AK$54,$AK$49,$AK$50)","v":"Acres"},"      N","P2O5","K2O","S","      N","P2O5","K2O","S"]
[null,{"$f":"B95","v":0},{"$f":"C95","v":0},"-",{"$f":"E95","v":0},"-",{"$f":"G95","v":0},"-",{"$f":"I95","v":0},{"$f":"J95","v":""},{"$f":"K95","v":""},"","",0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"B99","v":0},{"$f":"C99","v":0},"-",{"$f":"E99","v":0},"-",{"$f":"G99","v":0},"-",{"$f":"I99","v":0},{"$f":"J99","v":""},{"$f":"K99","v":""},"","",0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"B103","v":0},{"$f":"C103","v":0},"-",{"$f":"E103","v":0},"-",{"$f":"G103","v":0},"-",{"$f":"I103","v":0},{"$f":"J103","v":""},{"$f":"K103","v":""},"","",0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"B107","v":0},{"$f":"C107","v":0},"-",{"$f":"E107","v":0},"-",{"$f":"G107","v":0},"-",{"$f":"I107","v":0},{"$f":"J107","v":""},{"$f":"K107","v":""},"","",0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"B111","v":0},{"$f":"C111","v":0},"-",{"$f":"E111","v":0},"-",{"$f":"G111","v":0},"-",{"$f":"I111","v":0},{"$f":"J111","v":""},{"$f":"K111","v":""},"","",0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surplus (+) or Deficit (-) of Blend:",{"$f":"Q115","v":0},{"$f":"R115","v":0},0,0,0,0,0,0]
[]
[]
[null,"Additional Comments:"]
[]
[]
[]
[null,"This spreadsheet is best suited for gardens, lawns and small field plots.  It computes the amount of fertilizer needed based on the nutrient ratio of the fertilizer (the numbers displayed on the fertilizer label, sometimes called the \"N-P-K ratio\"), then calculates the pounds of nitrogen (N), phosphate (P205), and potash (K20) necessary for a given area, as recommended by a current soil test report."]

{"sheet":"Read Me","index":2,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Fertilizer Calculator Notes"]
[]
["1.  While the information generated from this spreadsheet is believed to be accurate, any actions taken based upon the results are the sole responsibility of the user."]
["2.  These calculations are only meant to assist you in determining the appropriate amount of fertilizer that may be applied.  The results are only as accurate as the data entered and are not designed or intended to serve as a replacement for other standard University recommended practices.  For example, in a large scale operation, this spreadsheet should in no way be considered a substitute for a nutrient management plan or a replacement for software programs like SNAP-Plus.  For more information about SNAP-Plus go to:  http://www.snapplus.net/  "]
["3.    This fertilizer calculator spreadsheet was created to help reduce the amount of unnecessary nutrients applied to lawns and gardens.  Depending on the particular site, you may only need nitrogen or you may only need phosphorus or potassium.  It all depends on the soil and what is being grown.  In lawn and garden situations, it is often easy to over-apply fertilizers and other nutrients.  Some would argue that the environmental impact would be minor when over-applying to a small area.   However, excessive nutrients applied, especially nitrogen applied to sandy soils can be a contributing factor to nitrate contamination in local water resources.   Since, it really does not make sense to load up a lawn or garden with unnecessary nutrients; this spreadsheet was designed to help manage nutrient applications."]
["4.    In small garden situations, sometimes excessive nutrients applied is a necessary trade-off to storing bags of unused and unwanted fertilizer.  On the other hand, the larger a garden area, the more likely a customized application will minimize or eliminate excessive nutrient applications and save money.  A good example would be buying a bag of urea to supply nitrogen needs and a bag of potash to supply potassium needs."]
["5.    Some smaller units of measurement were estimated by converting weight to volume, based upon conversion recommendations given in UW-Extension publication A2304 “Garden Fertilization”.  The recommended application rate will be blank if an acceptable conversion factor is not known."]
["6.    Enter data in the input sections only.  Other areas of the spreadsheet are protected and do not allow for user inputs.  The one exception is the listing of common fertilizers.  These fertilizer options and their percent plant food analysis can be altered."]
["7.    The solid manure nutrient values are Wisconsin book values.  Nutrient values will vary based upon several factors; the most notable is dry matter percentage.  These Wisconsin book values are based upon average dry matter percentages of:  Dairy-24%, Beef-35%, Swine-20%, Chicken-60%, Horse-45% and Sheep-45%.  If better data is available, numbers should be adjusted accordingly.  "]
["8.  This spreadsheet can be downloaded at:  http://fyi.uwex.edu/cwas/  .  For more detailed information on soils and fertility go to:   http://uwlab.soils.wisc.edu/    or to:  http://www.soils.wisc.edu/soils/   "]
["9.  A special thanks to those that helped in the review process, in particular:  UW-Extension Soil Specialists; Carrie Laboski, John Peters and Dick Wolkowski and the Central Wisconsin Agricultural Specialization Agents."]
["10.  Please share comments or suggestions to:  Craig Saxe, Juneau County UW-Extension, 211 Hickory Street, Rm. 302, Mauston WI  53948, 608-847-9329, craig.saxe@ces.uwex.edu"]

{"sheet":"Selection of Fertilizers","index":3,"n_rows":73,"n_cols":15,"rows_kept":73,"cut":false,"hidden":true,"merged":[[4,3,7,3],[4,4,6,10],[9,14,15,17]]}
[]
["Nav's Farm ","Garden Ctr"]
["Choices","Sort Column"]
[]
[null,null,null,"Common Avaliable Fertilizer  Choices","% Plant Food Analysis"]
[]
[]
[null,null,null,null,"N","-","P2O5","-","K2O","-","S",null,"Conversion factors weight to volume (0 if unknown)"]
[]
[1,4,null,"Urea",46,"-",0,"-",0,"-",0,null,1.3,null,"Sort rows, then copy and paste rows 10-30 (top 21 choices) to master spreadsheet (into rows 63-83), Do second copy and paste for Conversion Factors (Column M) into Column AG"]
[2,6,null,"Ammonium Sulfate ",21,"-",0,"-",0,"-",24,null,1]
[3,null,null,"MAP",11,"-",52,"-",0,"-",0,null,0]
[4,null,null,"DAP",18,"-",46,"-",0,"-",0,null,0]
[5,null,null,"TSP",0,"-",46,"-",0,"-",0,null,1]
[6,7,null,"Potassium Sulfate",0,"-",0,"-",50,"-",18,null,0.75]
[7,8,null,"Magnesium Sulfate ",0,"-",0,"-",0,"-",14,null,0]
[8,3,null,"Potash",0,"-",0,"-",60,"-",0,null,1]
[9,1,null,"Triple Ten",10,"-",10,"-",10,"-",0,null,1]
[10,2,null,"Triple Seventeen",17,"-",17,"-",17,"-",0,null,1]
[11,null,null,"18-18-18",18,"-",18,"-",18,"-",0,null,0]
[12,null,null,"12-40-0-10-1Zn",12,"-",40,"-",0,"-",10,null,0]
[13,null,null,"11-41-8",11,"-",41,"-",8,"-",0,null,0]
[14,null,null,"10-34-0",10,"-",34,"-",0,"-",0,null,0]
[15,null,null,"10-12-30",10,"-",12,"-",30,"-",0,null,1]
[16,null,null,"9-23-30",9,"-",23,"-",30,"-",0,null,1]
[17,null,null,"9-18-9",9,"-",18,"-",9,"-",0,null,0]
[18,null,null,"9-15-30",9,"-",15,"-",30,"-",0,null,0]
[19,null,null,"6-24-6",6,"-",24,"-",6,"-",0,null,0]
[20,null,null,"4-41-27",4,"-",41,"-",27,"-",0,null,0]
[21,null,null,"4-10-40",4,"-",10,"-",40,"-",0,null,0]
[null,5,null,"Turf Builder w/o Phos.",26,"-",0,"-",7,"-",0,null,1]
[null,9,null,"Garden Ctr Option A -",32,"-",0,"-",4,"-",0,null,0]
[null,10,null,"Garden Ctr Option B -",29,"-",0,"-",4,"-",0,null,0]
[null,11,null,"Garden Ctr Option C -",26,"-",0,"-",7,"-",0,null,0]
[null,12,null,"Garden Ctr Option D -",26,"-",0,"-",2,"-",0,null,0]
[null,13,null,"Garden Ctr Option E -",24,"-",8,"-",16,"-",0,null,0]
[null,14,null,"Garden Ctr Option F -",22,"-",0,"-",4,"-",0,null,0]
[null,15,null,"Garden Ctr Option G -",15,"-",30,"-",15,"-",0,null,0]
[null,16,null,"Garden Ctr Option H -",12,"-",0,"-",12,"-",0,null,0]
[null,17,null,"Garden Ctr Option I -",11,"-",2,"-",3,"-",0,null,0]
[null,18,null,"Garden Ctr Option J -",10,"-",0,"-",6,"-",0,null,0]
[null,19,null,"Garden Ctr Option K -",9,"-",3,"-",5,"-",0,null,0]
[null,20,null,"Garden Ctr Option L -",7,"-",1,"-",2,"-",0,null,0]
[null,21,null,"Garden Ctr Option M -",6,"-",0,"-",0,"-",0,null,0]
[null,null,null,"Garden Ctr Option N -",3,"-",4,"-",6,"-",0,null,0]
[null,null,null,"4-10-10",4,"-",10,"-",10,"-",0,null,0]
[null,null,null,null,null,"-",null,"-",null,"-",null,null,0]
[null,null,null,null,null,"-",null,"-",null,"-",null,null,0]
[null,null,null,null,null,"-",null,"-",null,"-",null,null,0]
[null,null,null,null,null,"-",null,"-",null,"-",null,null,0]
[null,null,null,null,null,"-",null,"-",null,"-",null,null,0]
[null,null,null,null,null,"-",null,"-",null,"-",null,null,0]
[null,null,null,null,null,"-",null,"-",null,"-",null,null,0]
[null,null,null,null,null,"-",null,"-",null,"-",null,null,0]
[null,null,null,null,null,"-",null,"-",null,"-",null,null,0]
[null,null,null,null,null,"-",null,"-",null,"-",null,null,0]
[null,null,null,null,null,"-",null,"-",null,"-",null,null,0]
[null,null,null,null,null,"-",null,"-",null,"-",null,null,0]
[]
[]
[null,null,null,"Non-Sorted, Standard on all sheets below:"]
[]
[null,null,null,"Solid Manure Choices ",null,null,null,null,null,null,null,null,0]
[null,null,null,"Dairy Manure",0.15,"-",0.15,"-",0.36,null,0.04,null,0]
[null,null,null,"Beef Manure",0.17499999999999999,"-",0.27,"-",0.44,null,0.04,null,0]
[null,null,null,"Swine Manure",0.35,"-",0.3,"-",0.36,null,0.08,null,0]
[null,null,null,"Chicken Manure",1,"-",1.5,"-",1.2,null,0.1,null,0]
[null,null,null,"Horse Manure",0.125,"-",0.18,"-",0.4,null,7.0000000000000007E-2,null,0]
[null,null,null,"Sheep Manure",0.32500000000000001,"-",0.54,"-",1.6,null,0.08,null,0]
[]
[null,null,null,"1. Add your own",0,"-",0,"-",0,"-",0,null,0]
[null,null,null,"2. Add your own",0,"-",0,"-",0,"-",0,null,0]
[null,null,null,"3. Add your own",0,"-",0,"-",0,"-",0,null,0]