{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["STEP 1--Field Information","STEP 2--Soil Test Information","Veg rec lookup","STEP 3--Nutrient Needs","Crop look up","STEP 4--Choose N","N lookup","STEP 5--Choose P","P lookup","STEP 6--Choose K","K lookup","STEP 7--Fertilizer Costs","Calcium","Magnesium","Sulfur","Trace Element ","STEP 8--Amendment Plan","Appendix--Fertilizer Costs","Cost per pound of Nutrients"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":5,"comments":3,"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":"STEP 1--Field Information","index":0,"n_rows":69,"n_cols":6,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,5],[9,0,9,3],[7,0,7,3]]}
["In the yellow cells below, enter descriptive information about a field. You can obtain calculations that are based on: acres,  OR length and width of beds, OR total square footage of growing area."]
[]
[]
[null,null,null,"Farm Name:"]
[null,null,null,null,null,"Acres:"]
[null,null,null,"Field name :"]
[]
["Select crop planned from dropdown menu. (If mixed field, select \"Mixed Vegetables\"):"]
[]
["Select previous cover crop on field from dropdown menu. If none, select \"No Cover Crop\"."]
[]
["SIZE OF YOUR FIELD, BEDS, OR GROWING AREA:"]
["Enter the number of acres:",null,null,null,null,{"$f":"E13","v":0}]
["OR"]
["Enter bed width (in feet): "]
[null,"AND"]
[null,"Enter bed length (in feet):"]
[null,null,"AND"]
[null,null,"Number of beds"]
["OR",null,null,null,null,{"$f":"(E15*E17*E19)/43560","v":0}]
["Enter total square feet of growing area:",null,null,null,null,{"$f":"E21/43560","v":0}]
[]
[null,null,null,null,null,{"$f":"F13+F21+F20","v":0}]
[]
["Mixed vegetables"]
["Basil",null,"No Cover Crop"]
["Beans: Dry/Snap/Lima",null,"Alsike clover "]
["Beets, Swiss Chard",null,"Berseem clover"]
["Broccoli, Cabbage, Cauliflower",null,"Buckwhat"]
["Carrots, Parsnips",null,"Field Peas"]
["Celery / Celeriac",null,"Hairy vetch, mid summer incorp"]
["Collards",null,"Hairy vetch, spring incorp"]
["Cucumbers, Melons",null,"Oat, leonard"]
["Eggplant",null,"Other"]
["Garlic",null,"Red clover, spring incorp"]
["Leafy Greens",null,"Red clover, mid summer incorp"]
["Lettuce / Escarole",null,"Rye"]
["Muskmelon",null,"Sudan grass"]
["Okra",null,"Sweet clover"]
["Ornamental Corn"]
["Ornamental Gourds"]
["Peas"]
["Peppers"]
["Potatoes"]
["Pumpkins"]
["Radishes"]
["Rhubarb - Establishment"]
["Rhubarb - Maintenance"]
["Spinach"]
["Sweet Potato"]
["Squash"]
["Sweet Corn, Early"]
["Sweet Corn, Full Season"]
["Tomatoes"]
["Rutabagas, Turnips"]
["Watermelon"]
["Blueberries - Establishment"]
["Blueberries - Maintenance"]
["Cranberries - Establishment"]
["Cranberries - Maintenance"]
["Hops - Establishment"]
["Hops - Maintenance"]
["Raspberries/Brambles -Establishment"]
["Raspberries/Brambles - Maintenance"]
["Strawberries - Establishment"]
["Strawberries - Maintenance"]
[]
["Asparagus - Establishment"]
["Asparagus - Maintenance"]

{"sheet":"STEP 2--Soil Test Information","index":1,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,1],[25,0,26,1]]}
["Instructions: Enter the information from your soil test results in the yellow cells. Select P and K levels from drop down menus. Only enter information from a soil test lab that uses the modified Morgan's extract (UVM, UMass, UMaine, Dairy One in NY)"]
[]
["Field Name",{"$f":"'STEP 1--Field Information'!E6","v":0}]
["pH"]
["Phosphorus (enter ppm P--if your results are in lbs/acre, divide that number by 2 for ppm)"]
["Potasssium (enter ppm K--if your results are in lbs/acre, divide that number by 2 for ppm)"]
["Calcium (Ca)"]
["Magnesium (Mg)"]
["Sulfur (S)"]
[]
["Micronutrients (Modified Morgan ppm)"]
["Iron (Fe)"]
["Manganese (Mn)"]
["Boron (B)"]
["Copper (Cu)"]
["Zinc (Zn)"]
["Sodium (Na)"]
["Aluminum (Al)"]
[]
["% Soil Organic Matter",null,"%"]
["Lime recommendation from soil test (enter number of tons per acre; if in pounds per 1000 square feet, divide that number by 435)",0,"tons"]
["Nitrogen"]
["Phosphate"]
["Potash"]
[]
[]
[]
[]
[]
[]
["Under 2 ppm","Under 25 ppm"]
["2-3 ppm","25-50 ppm"]
["3-4 ppm","50-75 ppm"]
["4-7 ppm","75-100 ppm"]
["7-10 ppm","100-130 ppm"]
["10-14 ppm","130-160 ppm"]
["14-18 ppm","160-190 ppm"]
["over 18 ppm","over 190 ppm"]

{"sheet":"Veg rec lookup","index":2,"n_rows":108,"n_cols":11,"rows_kept":108,"cut":false,"hidden":true,"merged":[]}
["Crop","Under 2 ppm","2-3 ppm","3-4 ppm","4-7 ppm","7-10 ppm","10-14 ppm","14-18 ppm","over 18 ppm"]
["Blueberries - Establishment",60,40,20,20,0,0,0,0,0]
["Blueberries - Maintenance",50,30,20,0,0,0,0,0,0]
["Cranberries - Establishment"]
["Cranberries - Maintenance"]
["Hops - Establishment",120,100,80,60,30,0,0,0,0]
["Hops - Maintenance",100,80,60,40,20,0,0,0,0]
["Raspberries/Brambles -Establishment",150,120,90,40,20,0,0,0,0]
["Raspberries/Brambles - Maintenance",120,90,60,20,20,0,0,0,0]
["Strawberries - Establishment",125,100,75,50,25,0,0,0,0]
["Strawberries - Maintenance",100,75,50,25,25,0,0,0,0]
["Home Vegetable (mixed)",0.5,0.25,0.25,0.2,0.1,0.1,0,0,0]
["Home Blueberries-Establishment",0.25,0.2,0.1,0.1,0,0,0,0,0]
["Home Blueberries-Maintenance",0.2,0.1,0.1,0,0,0,0,0,0]
["Home Brambles-Establishment",0.5,0.3,0.25,0.2,0.1,0,0,0,0]
["Home Brambles-Maintenance",0.3,0.25,0.15,0.1,0.1,0,0,0,0]
["Home Strawberries-Establishment",0.5,0.3,0.25,0.2,0.1,0,0,0,0]
["Home Strawberries-Maintenance",0.3,0.25,0.15,0.1,0.1,0,0,0,0]
["Mixed vegetables",200,100,100,80,40,30,0,0,0]
["Asparagus - Establishment",180,150,120,60,30,30,0,0,0]
["Asparagus - Maintenance",150,120,90,60,30,30,0,0,0]
["Basil",120,90,60,45,30,30,0,0,0]
["Beans: Dry/Snap/Lima",100,75,75,50,25,0,0,0,0]
["Beets, Swiss Chard",150,125,100,50,50,25,0,0,0]
["Broccoli, Cabbage, Cauliflower",150,125,100,50,50,25,0,0,0]
["Carrots, Parsnips",150,125,100,50,50,25,0,0,0]
["Celery / Celeriac",180,150,120,60,30,30,0,0,0]
["Collards",150,125,100,50,50,25,0,0,0]
["Cucumbers, Melons",150,125,100,50,50,25,0,0,0]
["Eggplant",150,125,100,50,50,25,0,0,0]
["Garlic",150,125,100,50,50,25,0,0,0]
["Leafy Greens",180,150,120,60,30,30,0,0,0]
["Lettuce / Escarole",180,150,120,60,30,30,0,0,0]
["Muskmelon",150,125,100,50,50,25,0,0,0]
["Okra",150,125,100,50,25,25,0,0,0]
["Onions, Leeks",150,125,100,50,25,25,0,0,0]
["Ornamental Corn",140,110,80,40,30,20,0,0,0]
["Ornamental Gourds",150,125,100,50,50,25,0,0,0]
["Peas",150,125,100,50,50,25,0,0,0]
["Peppers",150,125,100,50,25,25,0,0,0]
["Potatoes",200,160,120,90,60,30,0,0,0]
["Pumpkins",150,125,100,50,25,25,0,0,0]
["Radishes",150,125,100,50,25,25,0,0,0]
["Rhubarb - Establishment",200,200,150,125,75,50,25,0,0,0]
["Rhubarb - Maintenance",150,125,100,50,25,25,0]
["Spinach",180,150,120,60,30,30,0]
["Sweet Potato",300,250,200,100,50,30,0]
["Squash",150,125,100,50,50,25,0]
["Sweet Corn, Early",140,110,80,40,30,20,0]
["Sweet Corn, Full Season",140,110,80,40,30,20,0]
["Tomatoes",180,150,120,60,30,30,0]
["Rutabagas, Turnips",180,150,120,60,30,30,0]
["Watermelon",150,125,100,50,50,25,0]
[]
["K"]
["Crop","50-75 ppm","75-100 ppm","100-130 ppm","130-160 ppm","160-190 ppm","over 190 ppm"]
["Blueberries - Establishment",125,100,75,25,0,0]
["Blueberries - Maintenance",100,75,50,25,0,0]
["Cranberries - Establishment"]
["Cranberries - Maintenance"]
["Hops - Establishment",150,100,80,60,40,0]
["Hops - Maintenance",150,100,80,60,40,0]
["Raspberries/Brambles -Establishment",200,150,100,75,50,0]
["Raspberries/Brambles - Maintenance",175,125,100,75,50,0]
["Strawberries - Establishment",125,100,75,50,25,0]
["Strawberries - Maintenance",125,100,75,50,25,0]
["Home Vegetable (mixed)",0.5,0.25,0.25,0.1,0.1,0]
["Home Blueberries-Establishment",0.3,0.25,0.2,0.1]
["Home Blueberries-Maintenance",0.25,0.2,0.1,0.1]
["Home Brambles-Establishment",0.5,0.5,0.25,0.25,0.1,0]
["Home Brambles-Maintenance",0.5,0.5,0.25,0.25,0.1,0]
["Home Strawberries-Establishment",0.5,0.5,0.25,0.25,0.1,0]
["Home Strawberries-Maintenance",0.5,0.5,0.25,0.25,0.1,0]
["Mixed vegetables",200,100,100,40,40,0]
["Asparagus - Establishment",175,150,150,75,50,0]
["Asparagus - Maintenance",200,175,150,100,75,0]
["Basil",100,75,75,50,25]
["Beans: Dry/Snap/Lima",100,75,75,50,25,0]
["Beets, Swiss Chard",200,175,150,100,75,0]
["Broccoli, Cabbage, Cauliflower",175,150,150,75,50,0]
["Carrots, Parsnips",200,175,150,100,75,0]
["Celery / Celeriac",200,175,150,100,75,0]
["Collards",175,150,150,75,50,0]
["Cucumbers, Melons",140,120,100,70,30,0]
["Eggplant",125,100,75,50,50,0]
["Garlic",125,100,75,50,50,0]
["Leafy Greens",140,120,100,60,30,0]
["Lettuce / Escarole",140,120,100,60,30,0]
["Muskmelon",140,120,100,60,30,0]
["Okra"]
["Onions, Leeks",175,150,150,75,50,0]
["Ornamental Corn",140,120,100,80,40,0]
["Ornamental Gourds",140,120,100,80,40,0]
["Peas",125,100,75,50,50,0]
["Peppers",175,150,100,50,50,0]
["Potatoes",200,175,150,100,75,0]
["Pumpkins",175,150,100,80,40,0]
["Radishes",125,100,100,50,50,0]
["Rhubarb - Establishment",150,125,75,50,25,0]
["Rhubarb - Maintenance",200,175,150,100,50,0]
["Spinach",140,120,100,60,30,0]
["Sweet Potato",250,200,150,100,50,0]
["Squash",175,150,100,80,40,0]
["Sweet Corn, Early",140,120,100,80,40,0]
["Sweet Corn, Full Season",140,120,100,80,40,0]
["Tomatoes",200,150,125,100,50,0]
["Rutabagas, Turnips",100,75,50,25,25,0]
["Watermelon",140,120,100,70,30,0]

{"sheet":"STEP 3--Nutrient Needs","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,4],[12,0,12,3]]}
["Instructions: In the yellow highlighted areas, enter the necessary information. All shaded areas will autofill, but you can overwrite those numbers if you choose. Leave blank whatever you don't know or is not applicable. (If your soil test results are reported in 1000 square feet, multiply the recommendations by 43.5 to convert to pounds per acre)"]
[null,"ENTER YOUR VALUES IN YELLOW SQUARES:","N ","P2O5 ","K2O"]
["Nitrogen recommendations (lbs/ acre)",{"$f":"VLOOKUP('STEP 1--Field Information'!E8,'Crop look up'!A2:B45,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"B3","v":{"$error":"#N/A"}}]
["Phosphate recommendations (lbs/acre)",{"$f":"VLOOKUP('STEP 1--Field Information'!E8,'Veg rec lookup'!A2:I54, MATCH('STEP 2--Soil Test Information'!B5,'Veg rec lookup'!A1:J1,0), FALSE)","v":{"$error":"#N/A"}},null,{"$f":"B4","v":{"$error":"#N/A"}}]
["Potash recommendations (lbs/acre)",{"$f":"VLOOKUP('STEP 1--Field Information'!E8,'Veg rec lookup'!A57:G109,MATCH('STEP 2--Soil Test Information'!B6,'Veg rec lookup'!A56:G56,0), FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"B5","v":{"$error":"#N/A"}}]
["% soil organic matter",{"$f":"'STEP 2--Soil Test Information'!B20","v":0},{"$f":"MIN(40,B6*10)","v":0}]
["Cover crop contributions (lbs N per acre)--",{"$f":"'STEP 1--Field Information'!E10","v":0},{"$f":"VLOOKUP('STEP 1--Field Information'!E10,'Crop look up'!D16:E29,2,FALSE)","v":{"$error":"#N/A"}}]
["Manure contributions--Enter tons of manure applied per acre* (read below)",null,{"$f":"B8*0.6","v":0},{"$f":"B8*0.24","v":0},{"$f":"B8*0.9","v":0}]
["Compost contributions--Enter yards compost applied per acre",null,{"$f":"B9*0.75","v":0},{"$f":"B9*(0.375*0.8)","v":0},{"$f":"B9*(0.375*6)","v":0}]
["Sod contribution--(Enter a \"1\" in the cell to the right if in sod last season)",0,{"$f":"B10*30","v":0}]
["Total Nutrients Needed (lbs/Acre)",null,{"$f":"MAX(C3-SUM(C6:C10),0)","v":{"$error":"#N/A"}},{"$f":"MAX(D4-D8-D9,0)","v":{"$error":"#N/A"}},{"$f":"MAX(E5-E8-E9,0)","v":{"$error":"#N/A"}}]

{"sheet":"Crop look up","index":4,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":true,"merged":[]}
[null,"middle N needs","MaxN Lbs"]
["Asparagus - Establishment",50,null,"Rye",25]
["Asparagus - Maintenance",60,75,"Oat, leonard",10]
["Basil",115,130,"Hairy vetch, spring incorp",50]
["Beans: Dry/Snap/Lima",50,null,"Hairy vetch, mid summer incorp",80]
["Beets, Swiss Chard",115,130,"Red clover, spring incorp",50]
["Blueberries - Establishment",0,30,"Red clover, mid summer incorp",{"$f":"AVERAGE(70,150)","v":110}]
["Broccoli, Cabbage, Cauliflower",115,130,"Alsike clover",{"$f":"90","v":90}]
["Carrots, Parsnips",130,150,"Sweetclover",100]
["Celery / Celeriac",140,180,"Sudangrass",25]
["Collards, Kale",115,130,"Field Peas",{"$f":"AVERAGE(90,150)","v":120}]
["Cucumbers, Melons",115,130,"buckwheat",10]
["Eggplant",90,100,"Berseem clover",150]
["Garlic",120,null,"other","Enter estimated N In Cell to Right->"]
["Hops - Establishment",75,100]
["Hops - Maintenance",140,175,"Alsike clover ",90]
["Leafy Greens",85,100,"Berseem clover",150]
["Lettuce / Escarole",90,125,"Buckwhat",10]
["Mixed vegetables",115,130,"Field Peas",120]
["Muskmelon",115,130,"Hairy vetch, mid summer incorp",80]
["Okra",115,130,"Hairy vetch, spring incorp",50]
["Onions, leeks",140,150,"Oat, leonard",10]
["Ornamental Corn",115,130,"Other","Enter estimated N in Cell to Right->"]
["Ornamental Gourds",115,130,"Red clover, spring incorp",50]
["Peas",60,75,"Red clover, mid summer incorp",110]
["Peppers",140,150,"Rye",25]
["Potatoes",150,180,"Sudan grass",25]
["Pumpkins",125,140,"Sweet clover",100]
["Radishes",50,null,"No cover crop",0]
["Raspberries/Brambles -Establishment",0,30]
["Raspberries/Brambles -Establishment",30]
["Rhubarb - Establishment",50]
["Rhubarb - Establishment"]
["Rhubarb - Maintenance",50]
["Rhubarb - Maintenance"]
["Rutabagas, Turnips",50]
["Spinach",100,110]
["Squash",115,130]
["Strawberries - Establishment",50]
["Strawberries - Maintenance",30]
["Sweet Corn, Early",110,120]
["Sweet Corn, Full Season",120,140]
["Sweet Potato",60,75]
["Tomatoes",150,160]
["Watermelon",115,130]

{"sheet":"STEP 4--Choose N","index":5,"n_rows":37,"n_cols":10,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,0,36,7],[0,0,0,9],[1,0,1,2],[1,3,1,4],[2,0,2,1],[4,0,4,9]]}
["Instructions: Select your nitrogen amendment from the drop down menu in the yellow cell after reviewing the chart below. If you have a custom blend or a product with a unique analysis, enter the analysis at the bottom of the chart to the right of \"other\"."]
["Select Your Nitrogen Amendment---->",null,null,"Soybean meal, OG"]
["Based on your nutrient calculations, you should apply",null,{"$f":"'STEP 3--Nutrient Needs'!C11","v":{"$error":"#N/A"}},"lbs N/ acre"]
[]
["POSSIBLE NITROGEN AMENDMENTS"]
["AMENDMENT NAME",{"$f":"'Appendix--Fertilizer Costs'!B1","v":"% N"},{"$f":"'Appendix--Fertilizer Costs'!C1","v":"% P2O5"},{"$f":"'Appendix--Fertilizer Costs'!D1","v":"% K20"},{"$f":"'Appendix--Fertilizer Costs'!E1","v":"% Ca"},{"$f":"'Appendix--Fertilizer Costs'!F1","v":"% Mg"},{"$f":"'Appendix--Fertilizer Costs'!G1","v":"% S"},{"$f":"'Appendix--Fertilizer Costs'!H1","v":"Release Rate"},{"$f":"'Appendix--Fertilizer Costs'!I1","v":"Price per 50 lb"},{"$f":"'Appendix--Fertilizer Costs'!J1","v":"$/lb N"}]
[{"$f":"'N lookup'!A2","v":"Alfalfa meal"},{"$f":"'N lookup'!B2","v":0.03},{"$f":"'N lookup'!C2","v":5.0000000000000001E-3},{"$f":"'N lookup'!D2","v":2.5000000000000001E-2},{"$f":"'N lookup'!E2","v":0},{"$f":"'N lookup'!F2","v":0},{"$f":"'N lookup'!G2","v":0},{"$f":"'N lookup'!H2","v":"slow/ med"},{"$f":"'N lookup'!I2","v":31.06},{"$f":"'N lookup'!J2","v":20.706666666666667}]
[{"$f":"'N lookup'!A3","v":"Azomite"},{"$f":"'N lookup'!B3","v":0},{"$f":"'N lookup'!C3","v":0},{"$f":"'N lookup'!D3","v":0},{"$f":"'N lookup'!E3","v":0},{"$f":"'N lookup'!F3","v":0},{"$f":"'N lookup'!G3","v":0},{"$f":"'N lookup'!H3","v":0},{"$f":"'N lookup'!I3","v":56.81818181818182},{"$f":"'N lookup'!J3","v":0}]
[{"$f":"'N lookup'!A4","v":"Blood meal"},{"$f":"'N lookup'!B4","v":0.13},{"$f":"'N lookup'!C4","v":0},{"$f":"'N lookup'!D4","v":0},{"$f":"'N lookup'!E4","v":0},{"$f":"'N lookup'!F4","v":0},{"$f":"'N lookup'!G4","v":0},{"$f":"'N lookup'!H4","v":"med/ rapid"},{"$f":"'N lookup'!I4","v":91.49},{"$f":"'N lookup'!J4","v":14.075384615384614}]
[{"$f":"'N lookup'!A5","v":"Bone char"},{"$f":"'N lookup'!B5","v":0},{"$f":"'N lookup'!C5","v":0.16},{"$f":"'N lookup'!D5","v":0},{"$f":"'N lookup'!E5","v":0},{"$f":"'N lookup'!F5","v":0},{"$f":"'N lookup'!G5","v":0},{"$f":"'N lookup'!H5","v":"rapid"},{"$f":"'N lookup'!I5","v":47.2},{"$f":"'N lookup'!J5","v":0}]
[{"$f":"'N lookup'!A6","v":"Chilean nitrate"},{"$f":"'N lookup'!B6","v":0.15},{"$f":"'N lookup'!C6","v":0},{"$f":"'N lookup'!D6","v":0.02},{"$f":"'N lookup'!E6","v":0},{"$f":"'N lookup'!F6","v":0},{"$f":"'N lookup'!G6","v":0},{"$f":"'N lookup'!H6","v":"rapid"},{"$f":"'N lookup'!I6","v":76.540000000000006},{"$f":"'N lookup'!J6","v":10.205333333333334}]
[{"$f":"'N lookup'!A7","v":"Dehydrated Poultry Manure (Kreher's 5-4-3)"},{"$f":"'N lookup'!B7","v":0.05},{"$f":"'N lookup'!C7","v":0.04},{"$f":"'N lookup'!D7","v":0.03},{"$f":"'N lookup'!E7","v":0.09},{"$f":"'N lookup'!F7","v":0},{"$f":"'N lookup'!G7","v":0},{"$f":"'N lookup'!H7","v":"med"},{"$f":"'N lookup'!I7","v":15},{"$f":"'N lookup'!J7","v":6}]
[{"$f":"'N lookup'!A8","v":"Dehydrated Poultry Manure (Kreher's 4-3-10)"},{"$f":"'N lookup'!B8","v":0.04},{"$f":"'N lookup'!C8","v":0.03},{"$f":"'N lookup'!D8","v":0.1},{"$f":"'N lookup'!E8","v":0},{"$f":"'N lookup'!F8","v":0},{"$f":"'N lookup'!G8","v":0},{"$f":"'N lookup'!H8","v":"med"},{"$f":"'N lookup'!I8","v":22.5},{"$f":"'N lookup'!J8","v":11.25}]
[{"$f":"'N lookup'!A9","v":"Dehydrated Poultry Manure (Kreher's 7-2-6)"},{"$f":"'N lookup'!B9","v":7.0000000000000007E-2},{"$f":"'N lookup'!C9","v":0.02},{"$f":"'N lookup'!D9","v":0.06},{"$f":"'N lookup'!E9","v":0},{"$f":"'N lookup'!F9","v":0},{"$f":"'N lookup'!G9","v":0},{"$f":"'N lookup'!H9","v":"med"},{"$f":"'N lookup'!I9","v":28.75},{"$f":"'N lookup'!J9","v":8.2142857142857135}]
[{"$f":"'N lookup'!A10","v":"Feather meal"},{"$f":"'N lookup'!B10","v":0.13},{"$f":"'N lookup'!C10","v":0},{"$f":"'N lookup'!D10","v":0},{"$f":"'N lookup'!E10","v":0},{"$f":"'N lookup'!F10","v":0},{"$f":"'N lookup'!G10","v":0},{"$f":"'N lookup'!H10","v":"med"},{"$f":"'N lookup'!I10","v":56.77},{"$f":"'N lookup'!J10","v":8.7338461538461551}]
[{"$f":"'N lookup'!A11","v":"Fish emulsion"},{"$f":"'N lookup'!B11","v":0.02},{"$f":"'N lookup'!C11","v":0.05},{"$f":"'N lookup'!D11","v":2.0000000000000001E-4},{"$f":"'N lookup'!E11","v":0},{"$f":"'N lookup'!F11","v":0},{"$f":"'N lookup'!G11","v":0},{"$f":"'N lookup'!H11","v":"rapid"},{"$f":"'N lookup'!I11","v":109},{"$f":"'N lookup'!J11","v":0}]
[{"$f":"'N lookup'!A12","v":"Fish meal"},{"$f":"'N lookup'!B12","v":6.7000000000000004E-2},{"$f":"'N lookup'!C12","v":0.11},{"$f":"'N lookup'!D12","v":4.0000000000000001E-3},{"$f":"'N lookup'!E12","v":0},{"$f":"'N lookup'!F12","v":0},{"$f":"'N lookup'!G12","v":0},{"$f":"'N lookup'!H12","v":"med"},{"$f":"'N lookup'!I12","v":112},{"$f":"'N lookup'!J12","v":33.432835820895519}]
[{"$f":"'N lookup'!A13","v":"Grioux's Composted Poultry Manure"},{"$f":"'N lookup'!B13","v":0.02},{"$f":"'N lookup'!C13","v":0.03},{"$f":"'N lookup'!D13","v":1.4999999999999999E-2},{"$f":"'N lookup'!E13","v":7.0000000000000007E-2},{"$f":"'N lookup'!F13","v":0.01},{"$f":"'N lookup'!G13","v":0.05},{"$f":"'N lookup'!H13","v":"med"},{"$f":"'N lookup'!I13","v":1},{"$f":"'N lookup'!J13","v":1}]
[{"$f":"'N lookup'!A14","v":"Giroux's pellets"},{"$f":"'N lookup'!B14","v":0.04},{"$f":"'N lookup'!C14","v":0.03},{"$f":"'N lookup'!D14","v":0.02},{"$f":"'N lookup'!E14","v":0},{"$f":"'N lookup'!F14","v":0},{"$f":"'N lookup'!G14","v":0},{"$f":"'N lookup'!H14","v":"med"},{"$f":"'N lookup'!I14","v":8.3000000000000007},{"$f":"'N lookup'!J14","v":4.1500000000000004}]
[{"$f":"'N lookup'!A15","v":"Ag-Lime"},{"$f":"'N lookup'!B15","v":0},{"$f":"'N lookup'!C15","v":0},{"$f":"'N lookup'!D15","v":0},{"$f":"'N lookup'!E15","v":0},{"$f":"'N lookup'!F15","v":0},{"$f":"'N lookup'!G15","v":0},{"$f":"'N lookup'!H15","v":0},{"$f":"'N lookup'!I15","v":200},{"$f":"'N lookup'!J15","v":0}]
[{"$f":"'N lookup'!A16","v":"Makro 60"},{"$f":"'N lookup'!B16","v":0},{"$f":"'N lookup'!C16","v":0},{"$f":"'N lookup'!D16","v":0.6},{"$f":"'N lookup'!E16","v":0},{"$f":"'N lookup'!F16","v":0},{"$f":"'N lookup'!G16","v":0},{"$f":"'N lookup'!H16","v":0},{"$f":"'N lookup'!I16","v":36.25},{"$f":"'N lookup'!J16","v":0}]
[{"$f":"'N lookup'!A17","v":"Organo-Phos w. humic acid"},{"$f":"'N lookup'!B17","v":0},{"$f":"'N lookup'!C17","v":0.12},{"$f":"'N lookup'!D17","v":0},{"$f":"'N lookup'!E17","v":0.25},{"$f":"'N lookup'!F17","v":0},{"$f":"'N lookup'!G17","v":0},{"$f":"'N lookup'!H17","v":0},{"$f":"'N lookup'!I17","v":0},{"$f":"'N lookup'!J17","v":0}]
[{"$f":"'N lookup'!A18","v":"Polysulfate"},{"$f":"'N lookup'!B18","v":0},{"$f":"'N lookup'!C18","v":0},{"$f":"'N lookup'!D18","v":0.14000000000000001},{"$f":"'N lookup'!E18","v":0.12},{"$f":"'N lookup'!F18","v":3.5999999999999997E-2},{"$f":"'N lookup'!G18","v":0.19},{"$f":"'N lookup'!H18","v":0},{"$f":"'N lookup'!I18","v":20},{"$f":"'N lookup'!J18","v":0}]
["Blended Fertilizers"]
[{"$f":"'N lookup'!A19","v":"Soybean meal"},{"$f":"'N lookup'!B19","v":7.0000000000000007E-2},{"$f":"'N lookup'!C19","v":0.01},{"$f":"'N lookup'!D19","v":0.02},{"$f":"'N lookup'!E19","v":0},{"$f":"'N lookup'!F19","v":0.03},{"$f":"'N lookup'!G19","v":0},{"$f":"'N lookup'!H19","v":"slow/ med"},{"$f":"'N lookup'!I19","v":17},{"$f":"'N lookup'!J19","v":4.8571428571428568}]
[{"$f":"'N lookup'!A20","v":"Soybean meal, OG"},{"$f":"'N lookup'!B20","v":7.0000000000000007E-2},{"$f":"'N lookup'!C20","v":0.01},{"$f":"'N lookup'!D20","v":0.02},{"$f":"'N lookup'!E20","v":0},{"$f":"'N lookup'!F20","v":0},{"$f":"'N lookup'!G20","v":0},{"$f":"'N lookup'!H20","v":"slow/ med"},{"$f":"'N lookup'!I20","v":43.6},{"$f":"'N lookup'!J20","v":12.457142857142856}]
[{"$f":"'N lookup'!A21","v":"Sulfate of potash"},{"$f":"'N lookup'!B21","v":0},{"$f":"'N lookup'!C21","v":0},{"$f":"'N lookup'!D21","v":0.5},{"$f":"'N lookup'!E21","v":0},{"$f":"'N lookup'!F21","v":0},{"$f":"'N lookup'!G21","v":0.17},{"$f":"'N lookup'!H21","v":"rapid"},{"$f":"'N lookup'!I21","v":34.14},{"$f":"'N lookup'!J21","v":0}]
[{"$f":"'N lookup'!A22","v":"SOP soluble"},{"$f":"'N lookup'!B22","v":0},{"$f":"'N lookup'!C22","v":0},{"$f":"'N lookup'!D22","v":0.52},{"$f":"'N lookup'!E22","v":0},{"$f":"'N lookup'!F22","v":0},{"$f":"'N lookup'!G22","v":0},{"$f":"'N lookup'!H22","v":0},{"$f":"'N lookup'!I22","v":54.3},{"$f":"'N lookup'!J22","v":0}]
[{"$f":"'N lookup'!A23","v":"Triple super phosphate"},{"$f":"'N lookup'!B23","v":0.18},{"$f":"'N lookup'!C23","v":0.46},{"$f":"'N lookup'!D23","v":0},{"$f":"'N lookup'!E23","v":0},{"$f":"'N lookup'!F23","v":0},{"$f":"'N lookup'!G23","v":0},{"$f":"'N lookup'!H23","v":"rapid"},{"$f":"'N lookup'!I23","v":24.5},{"$f":"'N lookup'!J23","v":0}]
[{"$f":"'N lookup'!A24","v":"Urea"},{"$f":"'N lookup'!B24","v":0.46},{"$f":"'N lookup'!C24","v":0},{"$f":"'N lookup'!D24","v":0},{"$f":"'N lookup'!E24","v":0},{"$f":"'N lookup'!F24","v":0},{"$f":"'N lookup'!G24","v":0},{"$f":"'N lookup'!H24","v":"rapid"},{"$f":"'N lookup'!I24","v":18.75},{"$f":"'N lookup'!J24","v":0.81521739130434778}]
["NONE NEEDED",0,0,0,0,0,0,null,0,0]
["Naturesafe 10-2-8",0.1,0.02,0.08,null,null,null,null,null,{"$f":"I32/B32/50","v":0}]
[]
[]
[]
[]
["Blue shading indicates an organic material, but check with your certifying agency before using. "]

{"sheet":"N lookup","index":6,"n_rows":47,"n_cols":18,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["Material","% N","%P2 O5","%K20","%Ca","%Mg","%S","Relative Availability","Price per 50 lb ","Price per pound of N","Pounds of fertilizer to meet your N needs (for your specified area)","P205 Contributions","K20 Contributions","PoundsCa","Pounds Mg","Pounds S","Estimated Cost of fertilizer","Divide by to accout for availability (% avail)"]
[{"$f":"'Appendix--Fertilizer Costs'!A2","v":"Alfalfa meal"},{"$f":"'Appendix--Fertilizer Costs'!B2","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!C2","v":5.0000000000000001E-3},{"$f":"'Appendix--Fertilizer Costs'!D2","v":2.5000000000000001E-2},{"$f":"'Appendix--Fertilizer Costs'!E2","v":0},{"$f":"'Appendix--Fertilizer Costs'!F2","v":0},{"$f":"'Appendix--Fertilizer Costs'!G2","v":0},{"$f":"'Appendix--Fertilizer Costs'!H2","v":"slow/ med"},{"$f":"'Appendix--Fertilizer Costs'!I2","v":31.06},{"$f":"'Appendix--Fertilizer Costs'!J2","v":20.706666666666667},{"$f":"('STEP 3--Nutrient Needs'!C11/B2)/R2","v":{"$error":"#N/A"}},{"$f":"K2*C2","v":{"$error":"#N/A"}},{"$f":"K2*D2","v":{"$error":"#N/A"}},null,null,null,{"$f":"K2*J2*B2","v":{"$error":"#N/A"}},0.6]
[{"$f":"'Appendix--Fertilizer Costs'!A3","v":"Azomite"},{"$f":"'Appendix--Fertilizer Costs'!B3","v":0},{"$f":"'Appendix--Fertilizer Costs'!C3","v":0},{"$f":"'Appendix--Fertilizer Costs'!D3","v":0},{"$f":"'Appendix--Fertilizer Costs'!E3","v":0},{"$f":"'Appendix--Fertilizer Costs'!F3","v":0},{"$f":"'Appendix--Fertilizer Costs'!G3","v":0},{"$f":"'Appendix--Fertilizer Costs'!H3","v":0},{"$f":"'Appendix--Fertilizer Costs'!I3","v":56.81818181818182},{"$f":"'Appendix--Fertilizer Costs'!J3","v":0},{"$f":"('STEP 3--Nutrient Needs'!C11/B3)/R3","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"G3*K3","v":{"$error":"#N/A"}},{"$f":"K3*B3*J3","v":{"$error":"#N/A"}},1]
[{"$f":"'Appendix--Fertilizer Costs'!A4","v":"Blood meal"},{"$f":"'Appendix--Fertilizer Costs'!B4","v":0.13},{"$f":"'Appendix--Fertilizer Costs'!C4","v":0},{"$f":"'Appendix--Fertilizer Costs'!D4","v":0},{"$f":"'Appendix--Fertilizer Costs'!E4","v":0},{"$f":"'Appendix--Fertilizer Costs'!F4","v":0},{"$f":"'Appendix--Fertilizer Costs'!G4","v":0},{"$f":"'Appendix--Fertilizer Costs'!H4","v":"med/ rapid"},{"$f":"'Appendix--Fertilizer Costs'!I4","v":91.49},{"$f":"'Appendix--Fertilizer Costs'!J4","v":14.075384615384614},{"$f":"('STEP 3--Nutrient Needs'!C11/B4)/R4","v":{"$error":"#N/A"}},{"$f":"K4*C4","v":{"$error":"#N/A"}},{"$f":"K4*D4","v":{"$error":"#N/A"}},null,null,null,{"$error":"#N/A"},0.61]
[{"$f":"'Appendix--Fertilizer Costs'!A6","v":"Bone char"},{"$f":"'Appendix--Fertilizer Costs'!B6","v":0},{"$f":"'Appendix--Fertilizer Costs'!C6","v":0.16},{"$f":"'Appendix--Fertilizer Costs'!D6","v":0},{"$f":"'Appendix--Fertilizer Costs'!E6","v":0},{"$f":"'Appendix--Fertilizer Costs'!F6","v":0},{"$f":"'Appendix--Fertilizer Costs'!G6","v":0},{"$f":"'Appendix--Fertilizer Costs'!H6","v":"rapid"},{"$f":"'Appendix--Fertilizer Costs'!I6","v":47.2},{"$f":"'Appendix--Fertilizer Costs'!J6","v":0},{"$f":"('STEP 3--Nutrient Needs'!C11/B5)/R5","v":{"$error":"#N/A"}},{"$f":"K5*C5","v":{"$error":"#N/A"}},0,null,null,null,{"$error":"#N/A"},0.32]
[{"$f":"'Appendix--Fertilizer Costs'!A8","v":"Chilean nitrate"},{"$f":"'Appendix--Fertilizer Costs'!B8","v":0.15},{"$f":"'Appendix--Fertilizer Costs'!C8","v":0},{"$f":"'Appendix--Fertilizer Costs'!D8","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!E8","v":0},{"$f":"'Appendix--Fertilizer Costs'!F8","v":0},{"$f":"'Appendix--Fertilizer Costs'!G8","v":0},{"$f":"'Appendix--Fertilizer Costs'!H8","v":"rapid"},{"$f":"'Appendix--Fertilizer Costs'!I8","v":76.540000000000006},{"$f":"'Appendix--Fertilizer Costs'!J8","v":10.205333333333334},{"$f":"('STEP 3--Nutrient Needs'!C11/B6)/R6","v":{"$error":"#N/A"}},null,null,{"$f":"K6*E6","v":{"$error":"#N/A"}},null,null,{"$error":"#N/A"},1]
[{"$f":"'Appendix--Fertilizer Costs'!A9","v":"Dehydrated Poultry Manure (Kreher's 5-4-3)"},{"$f":"'Appendix--Fertilizer Costs'!B9","v":0.05},{"$f":"'Appendix--Fertilizer Costs'!C9","v":0.04},{"$f":"'Appendix--Fertilizer Costs'!D9","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!E9","v":0.09},{"$f":"'Appendix--Fertilizer Costs'!F9","v":0},{"$f":"'Appendix--Fertilizer Costs'!G9","v":0},{"$f":"'Appendix--Fertilizer Costs'!H9","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I9","v":15},{"$f":"'Appendix--Fertilizer Costs'!J9","v":6},{"$f":"('STEP 3--Nutrient Needs'!C11/B7)/R7","v":{"$error":"#N/A"}},null,null,null,null,null,{"$error":"#N/A"},1]
[{"$f":"'Appendix--Fertilizer Costs'!A10","v":"Dehydrated Poultry Manure (Kreher's 4-3-10)"},{"$f":"'Appendix--Fertilizer Costs'!B10","v":0.04},{"$f":"'Appendix--Fertilizer Costs'!C10","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!D10","v":0.1},{"$f":"'Appendix--Fertilizer Costs'!E10","v":0},{"$f":"'Appendix--Fertilizer Costs'!F10","v":0},{"$f":"'Appendix--Fertilizer Costs'!G10","v":0},{"$f":"'Appendix--Fertilizer Costs'!H10","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I10","v":22.5},{"$f":"'Appendix--Fertilizer Costs'!J10","v":11.25},{"$f":"('STEP 3--Nutrient Needs'!C11/B8)/R8","v":{"$error":"#N/A"}},{"$f":"K8*C8","v":{"$error":"#N/A"}},{"$f":"K8*D8","v":{"$error":"#N/A"}},{"$f":"K8*E8","v":{"$error":"#N/A"}},{"$f":"F8*K8","v":{"$error":"#N/A"}},{"$f":"G8*K8","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.6]
[{"$f":"'Appendix--Fertilizer Costs'!A11","v":"Dehydrated Poultry Manure (Kreher's 7-2-6)"},{"$f":"'Appendix--Fertilizer Costs'!B11","v":7.0000000000000007E-2},{"$f":"'Appendix--Fertilizer Costs'!C11","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!D11","v":0.06},{"$f":"'Appendix--Fertilizer Costs'!E11","v":0},{"$f":"'Appendix--Fertilizer Costs'!F11","v":0},{"$f":"'Appendix--Fertilizer Costs'!G11","v":0},{"$f":"'Appendix--Fertilizer Costs'!H11","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I11","v":28.75},{"$f":"'Appendix--Fertilizer Costs'!J11","v":8.2142857142857135},{"$f":"('STEP 3--Nutrient Needs'!C11/B9)/R9","v":{"$error":"#N/A"}},{"$f":"K9*C9","v":{"$error":"#N/A"}},{"$f":"K9*D9","v":{"$error":"#N/A"}},{"$f":"K9*E9","v":{"$error":"#N/A"}},{"$f":"F9*K9","v":{"$error":"#N/A"}},{"$f":"G9*K9","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.6]
[{"$f":"'Appendix--Fertilizer Costs'!A16","v":"Feather meal"},{"$f":"'Appendix--Fertilizer Costs'!B16","v":0.13},{"$f":"'Appendix--Fertilizer Costs'!C16","v":0},{"$f":"'Appendix--Fertilizer Costs'!D16","v":0},{"$f":"'Appendix--Fertilizer Costs'!E16","v":0},{"$f":"'Appendix--Fertilizer Costs'!F16","v":0},{"$f":"'Appendix--Fertilizer Costs'!G16","v":0},{"$f":"'Appendix--Fertilizer Costs'!H16","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I16","v":56.77},{"$f":"'Appendix--Fertilizer Costs'!J16","v":8.7338461538461551},{"$f":"('STEP 3--Nutrient Needs'!C11/B10)/R10","v":{"$error":"#N/A"}},null,null,null,null,null,{"$error":"#N/A"},0.65]
[{"$f":"'Appendix--Fertilizer Costs'!A17","v":"Fish emulsion"},{"$f":"'Appendix--Fertilizer Costs'!B17","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!C17","v":0.05},{"$f":"'Appendix--Fertilizer Costs'!D17","v":2.0000000000000001E-4},{"$f":"'Appendix--Fertilizer Costs'!E17","v":0},{"$f":"'Appendix--Fertilizer Costs'!F17","v":0},{"$f":"'Appendix--Fertilizer Costs'!G17","v":0},{"$f":"'Appendix--Fertilizer Costs'!H17","v":"rapid"},{"$f":"'Appendix--Fertilizer Costs'!I17","v":109},{"$f":"'Appendix--Fertilizer Costs'!J17","v":0},{"$f":"('STEP 3--Nutrient Needs'!C11/B11)/R11","v":{"$error":"#N/A"}},{"$f":"K11*C11","v":{"$error":"#N/A"}},null,null,null,null,{"$error":"#N/A"},1]
[{"$f":"'Appendix--Fertilizer Costs'!A18","v":"Fish meal"},{"$f":"'Appendix--Fertilizer Costs'!B18","v":6.7000000000000004E-2},{"$f":"'Appendix--Fertilizer Costs'!C18","v":0.11},{"$f":"'Appendix--Fertilizer Costs'!D18","v":4.0000000000000001E-3},{"$f":"'Appendix--Fertilizer Costs'!E18","v":0},{"$f":"'Appendix--Fertilizer Costs'!F18","v":0},{"$f":"'Appendix--Fertilizer Costs'!G18","v":0},{"$f":"'Appendix--Fertilizer Costs'!H18","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I18","v":112},{"$f":"'Appendix--Fertilizer Costs'!J18","v":33.432835820895519},{"$f":"('STEP 3--Nutrient Needs'!C11/B12)/R12","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,null,{"$error":"#N/A"},0.65]
[{"$f":"'Appendix--Fertilizer Costs'!A19","v":"Grioux's Composted Poultry Manure"},{"$f":"'Appendix--Fertilizer Costs'!B19","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!C19","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!D19","v":1.4999999999999999E-2},{"$f":"'Appendix--Fertilizer Costs'!E19","v":7.0000000000000007E-2},{"$f":"'Appendix--Fertilizer Costs'!F19","v":0.01},{"$f":"'Appendix--Fertilizer Costs'!G19","v":0.05},{"$f":"'Appendix--Fertilizer Costs'!H19","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I19","v":1},{"$f":"'Appendix--Fertilizer Costs'!J19","v":1},{"$f":"('STEP 3--Nutrient Needs'!C11/B13)/R13","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"K13*D13","v":{"$error":"#N/A"}},{"$f":"K13*E13","v":{"$error":"#N/A"}},{"$f":"F13*K13","v":{"$error":"#N/A"}},{"$f":"G13*K13","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.6]
["Giroux's pellets",0.04,0.03,0.02,null,null,null,"med",8.3000000000000007,{"$f":"I14*2/(B14*100)","v":4.1500000000000004},{"$f":"('STEP 3--Nutrient Needs'!C11/B14)/R14","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"K14*E14","v":{"$error":"#N/A"}},{"$f":"F14*K14","v":{"$error":"#N/A"}},{"$f":"G14*K14","v":{"$error":"#N/A"}},{"$f":"K14*B14*J14","v":{"$error":"#N/A"}},0.6]
[{"$f":"'Appendix--Fertilizer Costs'!A26","v":"Ag-Lime"},{"$f":"'Appendix--Fertilizer Costs'!B26","v":0},{"$f":"'Appendix--Fertilizer Costs'!C26","v":0},{"$f":"'Appendix--Fertilizer Costs'!D26","v":0},{"$f":"'Appendix--Fertilizer Costs'!E26","v":0},{"$f":"'Appendix--Fertilizer Costs'!F26","v":0},{"$f":"'Appendix--Fertilizer Costs'!G26","v":0},{"$f":"'Appendix--Fertilizer Costs'!H26","v":0},{"$f":"'Appendix--Fertilizer Costs'!I26","v":200},{"$f":"'Appendix--Fertilizer Costs'!J26","v":0},{"$f":"('STEP 3--Nutrient Needs'!C11/B15)/R15","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$f":"K15*B15*J15","v":{"$error":"#N/A"}},0.7]
[{"$f":"'Appendix--Fertilizer Costs'!A27","v":"Makro 60"},{"$f":"'Appendix--Fertilizer Costs'!B27","v":0},{"$f":"'Appendix--Fertilizer Costs'!C27","v":0},{"$f":"'Appendix--Fertilizer Costs'!D27","v":0.6},{"$f":"'Appendix--Fertilizer Costs'!E27","v":0},{"$f":"'Appendix--Fertilizer Costs'!F27","v":0},{"$f":"'Appendix--Fertilizer Costs'!G27","v":0},{"$f":"'Appendix--Fertilizer Costs'!H27","v":0},{"$f":"'Appendix--Fertilizer Costs'!I27","v":36.25},{"$f":"'Appendix--Fertilizer Costs'!J27","v":0},{"$f":"('STEP 3--Nutrient Needs'!C11/B16)/R16","v":{"$error":"#N/A"}},{"$f":"K16*C16","v":{"$error":"#N/A"}},{"$f":"K16*D16","v":{"$error":"#N/A"}},null,null,null,{"$error":"#N/A"},0.6]
[{"$f":"'Appendix--Fertilizer Costs'!A31","v":"Organo-Phos w. humic acid"},{"$f":"'Appendix--Fertilizer Costs'!B31","v":0},{"$f":"'Appendix--Fertilizer Costs'!C31","v":0.12},{"$f":"'Appendix--Fertilizer Costs'!D31","v":0},{"$f":"'Appendix--Fertilizer Costs'!E31","v":0.25},{"$f":"'Appendix--Fertilizer Costs'!F31","v":0},{"$f":"'Appendix--Fertilizer Costs'!G31","v":0},{"$f":"'Appendix--Fertilizer Costs'!H31","v":0},{"$f":"'Appendix--Fertilizer Costs'!I31","v":0},{"$f":"'Appendix--Fertilizer Costs'!J31","v":0},{"$f":"('STEP 3--Nutrient Needs'!C11/B17)/R17","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"K17*E17","v":{"$error":"#N/A"}},{"$f":"F17*K17","v":{"$error":"#N/A"}},{"$f":"G17*K17","v":{"$error":"#N/A"}},{"$error":"#N/A"},0.75]
[{"$f":"'Appendix--Fertilizer Costs'!A34","v":"Polysulfate"},{"$f":"'Appendix--Fertilizer Costs'!B34","v":0},{"$f":"'Appendix--Fertilizer Costs'!C34","v":0},{"$f":"'Appendix--Fertilizer Costs'!D34","v":0.14000000000000001},{"$f":"'Appendix--Fertilizer Costs'!E34","v":0.12},{"$f":"'Appendix--Fertilizer Costs'!F34","v":3.5999999999999997E-2},{"$f":"'Appendix--Fertilizer Costs'!G34","v":0.19},{"$f":"'Appendix--Fertilizer Costs'!H34","v":0},{"$f":"'Appendix--Fertilizer Costs'!I34","v":20},{"$f":"'Appendix--Fertilizer Costs'!J34","v":0},{"$f":"('STEP 3--Nutrient Needs'!C11/B18)/R18","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,{"$f":"F18*K18","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},1]
[{"$f":"'Appendix--Fertilizer Costs'!A37","v":"Soybean meal"},{"$f":"'Appendix--Fertilizer Costs'!B37","v":7.0000000000000007E-2},{"$f":"'Appendix--Fertilizer Costs'!C37","v":0.01},{"$f":"'Appendix--Fertilizer Costs'!D37","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!E37","v":0},{"$f":"'Appendix--Fertilizer Costs'!F37","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!G37","v":0},{"$f":"'Appendix--Fertilizer Costs'!H37","v":"slow/ med"},{"$f":"'Appendix--Fertilizer Costs'!I37","v":17},{"$f":"'Appendix--Fertilizer Costs'!J37","v":4.8571428571428568},{"$f":"('STEP 3--Nutrient Needs'!C11/B19)/R19","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},0.65]
[{"$f":"'Appendix--Fertilizer Costs'!A38","v":"Soybean meal, OG"},{"$f":"'Appendix--Fertilizer Costs'!B38","v":7.0000000000000007E-2},{"$f":"'Appendix--Fertilizer Costs'!C38","v":0.01},{"$f":"'Appendix--Fertilizer Costs'!D38","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!E38","v":0},{"$f":"'Appendix--Fertilizer Costs'!F38","v":0},{"$f":"'Appendix--Fertilizer Costs'!G38","v":0},{"$f":"'Appendix--Fertilizer Costs'!H38","v":"slow/ med"},{"$f":"'Appendix--Fertilizer Costs'!I38","v":43.6},{"$f":"'Appendix--Fertilizer Costs'!J38","v":12.457142857142856},{"$f":"('STEP 3--Nutrient Needs'!C11/B20)/R20","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},0.65]
[{"$f":"'Appendix--Fertilizer Costs'!A39","v":"Sulfate of potash"},{"$f":"'Appendix--Fertilizer Costs'!B39","v":0},{"$f":"'Appendix--Fertilizer Costs'!C39","v":0},{"$f":"'Appendix--Fertilizer Costs'!D39","v":0.5},{"$f":"'Appendix--Fertilizer Costs'!E39","v":0},{"$f":"'Appendix--Fertilizer Costs'!F39","v":0},{"$f":"'Appendix--Fertilizer Costs'!G39","v":0.17},{"$f":"'Appendix--Fertilizer Costs'!H39","v":"rapid"},{"$f":"'Appendix--Fertilizer Costs'!I39","v":34.14},{"$f":"'Appendix--Fertilizer Costs'!J39","v":0},{"$f":"('STEP 3--Nutrient Needs'!C11/B21)/R21","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},0.65]
[{"$f":"'Appendix--Fertilizer Costs'!A40","v":"SOP soluble"},{"$f":"'Appendix--Fertilizer Costs'!B40","v":0},{"$f":"'Appendix--Fertilizer Costs'!C40","v":0},{"$f":"'Appendix--Fertilizer Costs'!D40","v":0.52},{"$f":"'Appendix--Fertilizer Costs'!E40","v":0},{"$f":"'Appendix--Fertilizer Costs'!F40","v":0},{"$f":"'Appendix--Fertilizer Costs'!G40","v":0},{"$f":"'Appendix--Fertilizer Costs'!H40","v":0},{"$f":"'Appendix--Fertilizer Costs'!I40","v":54.3},{"$f":"'Appendix--Fertilizer Costs'!J40","v":0},{"$f":"('STEP 3--Nutrient Needs'!C11/B22)/R22","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},0.65]
[{"$f":"'Appendix--Fertilizer Costs'!A41","v":"Triple super phosphate"},{"$f":"'Appendix--Fertilizer Costs'!B41","v":0.18},{"$f":"'Appendix--Fertilizer Costs'!C41","v":0.46},{"$f":"'Appendix--Fertilizer Costs'!D41","v":0},{"$f":"'Appendix--Fertilizer Costs'!E41","v":0},{"$f":"'Appendix--Fertilizer Costs'!F41","v":0},{"$f":"'Appendix--Fertilizer Costs'!G41","v":0},{"$f":"'Appendix--Fertilizer Costs'!H41","v":"rapid"},{"$f":"'Appendix--Fertilizer Costs'!I41","v":24.5},{"$f":"'Appendix--Fertilizer Costs'!J41","v":0},{"$f":"('STEP 3--Nutrient Needs'!C11/B23)/R23","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},0.8]
[{"$f":"'Appendix--Fertilizer Costs'!A42","v":"Urea"},{"$f":"'Appendix--Fertilizer Costs'!B42","v":0.46},{"$f":"'Appendix--Fertilizer Costs'!C42","v":0},{"$f":"'Appendix--Fertilizer Costs'!D42","v":0},{"$f":"'Appendix--Fertilizer Costs'!E42","v":0},{"$f":"'Appendix--Fertilizer Costs'!F42","v":0},{"$f":"'Appendix--Fertilizer Costs'!G42","v":0},{"$f":"'Appendix--Fertilizer Costs'!H42","v":"rapid"},{"$f":"'Appendix--Fertilizer Costs'!I42","v":18.75},{"$f":"'Appendix--Fertilizer Costs'!J42","v":0.81521739130434778},{"$f":"('STEP 3--Nutrient Needs'!C11/B24)/R24","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},0.8]
[{"$f":"'STEP 4--Choose N'!A31","v":"NONE NEEDED"},{"$f":"'STEP 4--Choose N'!B31","v":0},{"$f":"'STEP 4--Choose N'!C31","v":0},{"$f":"'STEP 4--Choose N'!D31","v":0},{"$f":"'STEP 4--Choose N'!E31","v":0},{"$f":"'STEP 4--Choose N'!F31","v":0},{"$f":"'STEP 4--Choose N'!G31","v":0},{"$f":"'STEP 4--Choose N'!H31","v":0},{"$f":"'STEP 4--Choose N'!I31","v":0},{"$f":"'STEP 4--Choose N'!J31","v":0},{"$f":"'STEP 4--Choose N'!K30","v":0},0,0,0,0,0,0,0]
[{"$f":"'STEP 4--Choose N'!A32","v":"Naturesafe 10-2-8"},{"$f":"'STEP 4--Choose N'!B32","v":0.1},{"$f":"'STEP 4--Choose N'!C32","v":0.02},{"$f":"'STEP 4--Choose N'!D32","v":0.08},{"$f":"'STEP 4--Choose N'!E32","v":0},{"$f":"'STEP 4--Choose N'!F32","v":0},{"$f":"'STEP 4--Choose N'!G32","v":0},{"$f":"'STEP 4--Choose N'!H32","v":0},{"$f":"'STEP 4--Choose N'!I32","v":0},{"$f":"'STEP 4--Choose N'!J32","v":0},{"$f":"('STEP 3--Nutrient Needs'!C11/B26)/R26","v":{"$error":"#N/A"}},{"$f":"K26*C26","v":{"$error":"#N/A"}},{"$f":"K26*D26","v":{"$error":"#N/A"}},null,null,null,{"$f":"K26*B26*J26","v":{"$error":"#N/A"}},0.7]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'STEP 4--Choose N'!B32","v":0.1},{"$f":"'STEP 4--Choose N'!C32","v":0.02},{"$f":"'STEP 4--Choose N'!D32","v":0.08},{"$f":"'STEP 4--Choose N'!E32","v":0},{"$f":"'STEP 4--Choose N'!F32","v":0},{"$f":"'STEP 4--Choose N'!G32","v":0},{"$f":"'STEP 4--Choose N'!H32","v":0},{"$f":"'STEP 4--Choose N'!#REF!","v":{"$error":"#REF!"}},{"$f":"'STEP 4--Choose N'!J32","v":0},{"$f":"('STEP 3--Nutrient Needs'!C11*'STEP 1--Field Information'!F23/B47)/R47","v":{"$error":"#N/A"}},{"$f":"K47*C47","v":{"$error":"#N/A"}},{"$f":"K47*D47","v":{"$error":"#N/A"}},null,null,null,{"$f":"K47*B47*J47","v":{"$error":"#N/A"}},0.65]

{"sheet":"STEP 5--Choose P","index":7,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,9],[28,0,28,7],[1,0,1,2],[1,3,1,5],[2,0,2,1],[3,0,3,1],[5,0,5,9]]}
["Instructions: Select your phosphate amendment from the drop down menu in the yellow cell after reviewing the chart below."]
["Select Your Phosphate Amendment->",null,null,"NONE NEEDED"]
["Your N selection contributes",null,{"$f":"VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,12,FALSE)","v":{"$error":"#N/A"}},"lbs P205/ acre"]
["You should apply an additional",null,{"$f":"('STEP 3--Nutrient Needs'!D11)-VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,12,FALSE)","v":{"$error":"#N/A"}},"lbs P205/ acre"]
[]
["POSSIBLE PHOSPHATE AMENDMENTS"]
[{"$f":"'Appendix--Fertilizer Costs'!A1","v":"MATERIAL"},{"$f":"'Appendix--Fertilizer Costs'!B1","v":"% N"},{"$f":"'Appendix--Fertilizer Costs'!C1","v":"% P2O5"},{"$f":"'Appendix--Fertilizer Costs'!D1","v":"% K20"},{"$f":"'Appendix--Fertilizer Costs'!E1","v":"% Ca"},{"$f":"'Appendix--Fertilizer Costs'!F1","v":"% Mg"},{"$f":"'Appendix--Fertilizer Costs'!G1","v":"% S"},{"$f":"'Appendix--Fertilizer Costs'!H1","v":"Release Rate"},{"$f":"'Appendix--Fertilizer Costs'!I1","v":"Price per 50 lb"},{"$f":"'Appendix--Fertilizer Costs'!K1","v":"$/lb P"}]
[{"$f":"'Appendix--Fertilizer Costs'!A5","v":"Bone meal, OG"},{"$f":"'Appendix--Fertilizer Costs'!B5","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!C5","v":0.15},{"$f":"'Appendix--Fertilizer Costs'!D5","v":0},{"$f":"'Appendix--Fertilizer Costs'!E5","v":0},{"$f":"'Appendix--Fertilizer Costs'!F5","v":0},{"$f":"'Appendix--Fertilizer Costs'!G5","v":0},{"$f":"'Appendix--Fertilizer Costs'!H5","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I5","v":71},{"$f":"'Appendix--Fertilizer Costs'!K5","v":9.4666666666666668}]
[{"$f":"'Appendix--Fertilizer Costs'!A6","v":"Bone char"},{"$f":"'Appendix--Fertilizer Costs'!B6","v":0},{"$f":"'Appendix--Fertilizer Costs'!C6","v":0.16},{"$f":"'Appendix--Fertilizer Costs'!D6","v":0},{"$f":"'Appendix--Fertilizer Costs'!E6","v":0},{"$f":"'Appendix--Fertilizer Costs'!F6","v":0},{"$f":"'Appendix--Fertilizer Costs'!G6","v":0},{"$f":"'Appendix--Fertilizer Costs'!H6","v":"rapid"},{"$f":"'Appendix--Fertilizer Costs'!I6","v":47.2},{"$f":"'Appendix--Fertilizer Costs'!K6","v":5.9}]
[{"$f":"'Appendix--Fertilizer Costs'!A10","v":"Dehydrated Poultry Manure (Kreher's 4-3-10)"},{"$f":"'Appendix--Fertilizer Costs'!B10","v":0.04},{"$f":"'Appendix--Fertilizer Costs'!C10","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!D10","v":0.1},{"$f":"'Appendix--Fertilizer Costs'!E10","v":0},{"$f":"'Appendix--Fertilizer Costs'!F10","v":0},{"$f":"'Appendix--Fertilizer Costs'!G10","v":0},{"$f":"'Appendix--Fertilizer Costs'!H10","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I10","v":22.5},{"$f":"'Appendix--Fertilizer Costs'!K10","v":15}]
[{"$f":"'Appendix--Fertilizer Costs'!A11","v":"Dehydrated Poultry Manure (Kreher's 7-2-6)"},{"$f":"'Appendix--Fertilizer Costs'!B11","v":7.0000000000000007E-2},{"$f":"'Appendix--Fertilizer Costs'!C11","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!D11","v":0.06},{"$f":"'Appendix--Fertilizer Costs'!E11","v":0},{"$f":"'Appendix--Fertilizer Costs'!F11","v":0},{"$f":"'Appendix--Fertilizer Costs'!G11","v":0},{"$f":"'Appendix--Fertilizer Costs'!H11","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I11","v":28.75},{"$f":"'Appendix--Fertilizer Costs'!K11","v":0}]
[{"$f":"'Appendix--Fertilizer Costs'!A12","v":"Dehydrated Poultry Manure (Kreher's 8-2-2)"},{"$f":"'Appendix--Fertilizer Costs'!B12","v":0.08},{"$f":"'Appendix--Fertilizer Costs'!C12","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!D12","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!E12","v":0},{"$f":"'Appendix--Fertilizer Costs'!F12","v":0},{"$f":"'Appendix--Fertilizer Costs'!G12","v":0},{"$f":"'Appendix--Fertilizer Costs'!H12","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I12","v":28.75},{"$f":"'Appendix--Fertilizer Costs'!K12","v":28.75}]
[{"$f":"'Appendix--Fertilizer Costs'!A19","v":"Grioux's Composted Poultry Manure"},{"$f":"'Appendix--Fertilizer Costs'!B19","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!C19","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!D19","v":1.4999999999999999E-2},{"$f":"'Appendix--Fertilizer Costs'!E19","v":7.0000000000000007E-2},{"$f":"'Appendix--Fertilizer Costs'!F19","v":0.01},{"$f":"'Appendix--Fertilizer Costs'!G19","v":0.05},{"$f":"'Appendix--Fertilizer Costs'!H19","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I19","v":1},{"$f":"'Appendix--Fertilizer Costs'!K19","v":0.66666666666666663}]
[{"$f":"'Appendix--Fertilizer Costs'!A20","v":"Giroux's pellets"},{"$f":"'Appendix--Fertilizer Costs'!B20","v":0.04},{"$f":"'Appendix--Fertilizer Costs'!C20","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!D20","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!E20","v":0},{"$f":"'Appendix--Fertilizer Costs'!F20","v":0},{"$f":"'Appendix--Fertilizer Costs'!G20","v":0},{"$f":"'Appendix--Fertilizer Costs'!H20","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I20","v":8.3000000000000007},{"$f":"'Appendix--Fertilizer Costs'!K20","v":5.5333333333333341}]
[{"$f":"'Appendix--Fertilizer Costs'!A30","v":"Naturesafe"},{"$f":"'Appendix--Fertilizer Costs'!B30","v":0.1},{"$f":"'Appendix--Fertilizer Costs'!C30","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!D30","v":0.08},{"$f":"'Appendix--Fertilizer Costs'!E30","v":0},{"$f":"'Appendix--Fertilizer Costs'!F30","v":0},{"$f":"'Appendix--Fertilizer Costs'!G30","v":0},{"$f":"'Appendix--Fertilizer Costs'!H30","v":0},{"$f":"'Appendix--Fertilizer Costs'!I30","v":36.25},{"$f":"'Appendix--Fertilizer Costs'!K30","v":0}]
[{"$f":"'Appendix--Fertilizer Costs'!A33","v":"Potassium chloride"},{"$f":"'Appendix--Fertilizer Costs'!B33","v":0},{"$f":"'Appendix--Fertilizer Costs'!C33","v":0},{"$f":"'Appendix--Fertilizer Costs'!D33","v":0.6},{"$f":"'Appendix--Fertilizer Costs'!E33","v":0},{"$f":"'Appendix--Fertilizer Costs'!F33","v":0},{"$f":"'Appendix--Fertilizer Costs'!G33","v":0},{"$f":"'Appendix--Fertilizer Costs'!H33","v":"rapid"},{"$f":"'Appendix--Fertilizer Costs'!I33","v":18.5},{"$f":"'Appendix--Fertilizer Costs'!K33","v":0}]
[{"$f":"'Appendix--Fertilizer Costs'!A36","v":"Solubor"}]
[{"$f":"'Appendix--Fertilizer Costs'!A37","v":"Soybean meal"},{"$f":"'Appendix--Fertilizer Costs'!B37","v":7.0000000000000007E-2},{"$f":"'Appendix--Fertilizer Costs'!C37","v":0.01},{"$f":"'Appendix--Fertilizer Costs'!D37","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!E37","v":0},{"$f":"'Appendix--Fertilizer Costs'!F37","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!G37","v":0},{"$f":"'Appendix--Fertilizer Costs'!H37","v":"slow/ med"},{"$f":"'Appendix--Fertilizer Costs'!I37","v":17},{"$f":"'Appendix--Fertilizer Costs'!K37","v":34}]
[{"$f":"'Appendix--Fertilizer Costs'!A38","v":"Soybean meal, OG"},{"$f":"'Appendix--Fertilizer Costs'!B38","v":7.0000000000000007E-2},{"$f":"'Appendix--Fertilizer Costs'!C38","v":0.01},{"$f":"'Appendix--Fertilizer Costs'!D38","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!E38","v":0},{"$f":"'Appendix--Fertilizer Costs'!F38","v":0},{"$f":"'Appendix--Fertilizer Costs'!G38","v":0},{"$f":"'Appendix--Fertilizer Costs'!H38","v":"slow/ med"},{"$f":"'Appendix--Fertilizer Costs'!I38","v":43.6},{"$f":"'Appendix--Fertilizer Costs'!K38","v":87.2}]
[{"$f":"'Appendix--Fertilizer Costs'!A40","v":"SOP soluble"},{"$f":"'Appendix--Fertilizer Costs'!B40","v":0},{"$f":"'Appendix--Fertilizer Costs'!C40","v":0},{"$f":"'Appendix--Fertilizer Costs'!D40","v":0.52},{"$f":"'Appendix--Fertilizer Costs'!E40","v":0},{"$f":"'Appendix--Fertilizer Costs'!F40","v":0},{"$f":"'Appendix--Fertilizer Costs'!G40","v":0},{"$f":"'Appendix--Fertilizer Costs'!H40","v":0},{"$f":"'Appendix--Fertilizer Costs'!I40","v":54.3},{"$f":"'Appendix--Fertilizer Costs'!K40","v":0}]
[{"$f":"'Appendix--Fertilizer Costs'!A42","v":"Urea"},{"$f":"'Appendix--Fertilizer Costs'!B42","v":0.46},{"$f":"'Appendix--Fertilizer Costs'!C42","v":0},{"$f":"'Appendix--Fertilizer Costs'!D42","v":0},{"$f":"'Appendix--Fertilizer Costs'!E42","v":0},{"$f":"'Appendix--Fertilizer Costs'!F42","v":0},{"$f":"'Appendix--Fertilizer Costs'!G42","v":0},{"$f":"'Appendix--Fertilizer Costs'!H42","v":"rapid"},{"$f":"'Appendix--Fertilizer Costs'!I42","v":18.75},{"$f":"'Appendix--Fertilizer Costs'!K42","v":0}]
["NONE NEEDED",0,0,0,0,0,0,null,0,0]
["OTHER--enter Name in this cell, analysis and price to right-->",null,null,null,null,null,null,null,null,{"$f":"I23*2/(C23*100)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
["Blue shading indicates an organic material, but check with your certifying agency before using. "]

{"sheet":"P lookup","index":8,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'STEP 5--Choose P'!A7","v":"MATERIAL"},{"$f":"'STEP 5--Choose P'!B7","v":"% N"},{"$f":"'STEP 5--Choose P'!C7","v":"% P2O5"},{"$f":"'STEP 5--Choose P'!D7","v":"% K20"},{"$f":"'STEP 5--Choose P'!E7","v":"% Ca"},{"$f":"'STEP 5--Choose P'!F7","v":"% Mg"},{"$f":"'STEP 5--Choose P'!G7","v":"% S"},{"$f":"'STEP 5--Choose P'!H7","v":"Release Rate"},{"$f":"'STEP 5--Choose P'!I7","v":"Price per 50 lb"},{"$f":"'STEP 5--Choose P'!J7","v":"$/lb P"},"Pounds of P205 fertilizer per acre (accounts for any P205 in your N fertilizer selection)","K20 Contributions (pounds) ","PoundsCa","Pounds Mg","Pounds S","Estimated Cost"]
[{"$f":"'STEP 5--Choose P'!A8","v":"Bone meal, OG"},null,0.16,null,null,null,null,"med",{"$f":"'STEP 5--Choose P'!I8","v":71},{"$f":"I2*2/(C2*100)","v":8.875},{"$f":"('STEP 3--Nutrient Needs'!D11/C2)-(VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,12,FALSE)/C2)","v":{"$error":"#N/A"}},{"$f":"K2*D2","v":{"$error":"#N/A"}},null,null,null,{"$f":"(K2*I2)/50","v":{"$error":"#N/A"}}]
[{"$f":"'STEP 5--Choose P'!A9","v":"Bone char"},0.03,0.22,null,null,null,null,"med",{"$f":"'STEP 5--Choose P'!I9","v":47.2},{"$f":"78/22","v":3.5454545454545454},{"$f":"('STEP 3--Nutrient Needs'!D11/C3)-VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,12,FALSE)/C3","v":{"$error":"#N/A"}},{"$f":"K3*D3","v":{"$error":"#N/A"}},null,null,null,{"$error":"#N/A"}]
[{"$f":"'STEP 5--Choose P'!A10","v":"Dehydrated Poultry Manure (Kreher's 4-3-10)"},{"$f":"'STEP 5--Choose P'!B10","v":0.04},{"$f":"'STEP 5--Choose P'!C10","v":0.03},{"$f":"'STEP 5--Choose P'!D10","v":0.1},{"$f":"'STEP 5--Choose P'!E10","v":0},{"$f":"'STEP 5--Choose P'!F10","v":0},{"$f":"'STEP 5--Choose P'!G10","v":0},{"$f":"'STEP 5--Choose P'!H10","v":"med"},{"$f":"'STEP 5--Choose P'!I10","v":22.5},{"$f":"'STEP 5--Choose P'!J10","v":15},{"$f":"('STEP 3--Nutrient Needs'!D11/C4)-VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,12,FALSE)/C4","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"}]
[{"$f":"'STEP 5--Choose P'!A11","v":"Dehydrated Poultry Manure (Kreher's 7-2-6)"},{"$f":"'STEP 5--Choose P'!B11","v":7.0000000000000007E-2},{"$f":"'STEP 5--Choose P'!C11","v":0.02},{"$f":"'STEP 5--Choose P'!D11","v":0.06},{"$f":"'STEP 5--Choose P'!E11","v":0},{"$f":"'STEP 5--Choose P'!F11","v":0},{"$f":"'STEP 5--Choose P'!G11","v":0},{"$f":"'STEP 5--Choose P'!H11","v":"med"},{"$f":"'STEP 5--Choose P'!I11","v":28.75},{"$f":"'STEP 5--Choose P'!J11","v":0},{"$f":"('STEP 3--Nutrient Needs'!D11/C5)-VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,12,FALSE)/C5","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"}]
[{"$f":"'STEP 5--Choose P'!A12","v":"Dehydrated Poultry Manure (Kreher's 8-2-2)"},{"$f":"'STEP 5--Choose P'!B12","v":0.08},{"$f":"'STEP 5--Choose P'!C12","v":0.02},{"$f":"'STEP 5--Choose P'!D12","v":0.02},{"$f":"'STEP 5--Choose P'!E12","v":0},{"$f":"'STEP 5--Choose P'!F12","v":0},{"$f":"'STEP 5--Choose P'!G12","v":0},{"$f":"'STEP 5--Choose P'!H12","v":"med"},{"$f":"'STEP 5--Choose P'!I12","v":28.75},{"$f":"'STEP 5--Choose P'!J12","v":28.75},{"$f":"('STEP 3--Nutrient Needs'!D11/C6)-VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,12,FALSE)/C6","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"}]
[{"$f":"'STEP 5--Choose P'!A13","v":"Grioux's Composted Poultry Manure"},{"$f":"'STEP 5--Choose P'!B13","v":0.02},{"$f":"'STEP 5--Choose P'!C13","v":0.03},{"$f":"'STEP 5--Choose P'!D13","v":1.4999999999999999E-2},{"$f":"'STEP 5--Choose P'!E13","v":7.0000000000000007E-2},{"$f":"'STEP 5--Choose P'!F13","v":0.01},{"$f":"'STEP 5--Choose P'!G13","v":0.05},{"$f":"'STEP 5--Choose P'!H13","v":"med"},{"$f":"'STEP 5--Choose P'!I13","v":1},{"$f":"'STEP 5--Choose P'!J13","v":0.66666666666666663},{"$f":"('STEP 3--Nutrient Needs'!D11/C7)-VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,12,FALSE)/C7","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"}]
[{"$f":"'STEP 5--Choose P'!A15","v":"Naturesafe"},{"$f":"'STEP 5--Choose P'!B15","v":0.1},{"$f":"'STEP 5--Choose P'!C15","v":0.02},{"$f":"'STEP 5--Choose P'!D15","v":0.08},{"$f":"'STEP 5--Choose P'!E15","v":0},{"$f":"'STEP 5--Choose P'!F15","v":0},{"$f":"'STEP 5--Choose P'!G15","v":0},{"$f":"'STEP 5--Choose P'!H15","v":0},{"$f":"'STEP 5--Choose P'!I15","v":36.25},{"$f":"'STEP 5--Choose P'!J15","v":0},{"$f":"('STEP 3--Nutrient Needs'!D11/C8)-VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,12,FALSE)/C8","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"}]
[{"$f":"'STEP 5--Choose P'!A16","v":"Potassium chloride"},{"$f":"'STEP 5--Choose P'!B16","v":0},{"$f":"'STEP 5--Choose P'!C16","v":0},{"$f":"'STEP 5--Choose P'!D16","v":0.6},{"$f":"'STEP 5--Choose P'!E16","v":0},{"$f":"'STEP 5--Choose P'!F16","v":0},{"$f":"'STEP 5--Choose P'!G16","v":0},{"$f":"'STEP 5--Choose P'!H16","v":"rapid"},{"$f":"'STEP 5--Choose P'!I16","v":18.5},{"$f":"'STEP 5--Choose P'!J16","v":0},{"$f":"('STEP 3--Nutrient Needs'!D11/C9)-VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,12,FALSE)/C9","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"}]
[{"$f":"'STEP 5--Choose P'!A17","v":"Solubor"},null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[{"$f":"'STEP 5--Choose P'!A18","v":"Soybean meal"},{"$f":"'STEP 5--Choose P'!B18","v":7.0000000000000007E-2},{"$f":"'STEP 5--Choose P'!C18","v":0.01},{"$f":"'STEP 5--Choose P'!D18","v":0.02},{"$f":"'STEP 5--Choose P'!E18","v":0},{"$f":"'STEP 5--Choose P'!F18","v":0.03},{"$f":"'STEP 5--Choose P'!G18","v":0},{"$f":"'STEP 5--Choose P'!H18","v":"slow/ med"},{"$f":"'STEP 5--Choose P'!I18","v":17},{"$f":"'STEP 5--Choose P'!J18","v":34},{"$f":"('STEP 3--Nutrient Needs'!D11/C11)-VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,12,FALSE)/C11","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"}]
[{"$f":"'STEP 5--Choose P'!A19","v":"Soybean meal, OG"},{"$f":"'STEP 5--Choose P'!B19","v":7.0000000000000007E-2},{"$f":"'STEP 5--Choose P'!C19","v":0.01},{"$f":"'STEP 5--Choose P'!D19","v":0.02},{"$f":"'STEP 5--Choose P'!E19","v":0},{"$f":"'STEP 5--Choose P'!F19","v":0},{"$f":"'STEP 5--Choose P'!G19","v":0},{"$f":"'STEP 5--Choose P'!H19","v":"slow/ med"},{"$f":"'STEP 5--Choose P'!I19","v":43.6},{"$f":"'STEP 5--Choose P'!J19","v":87.2},{"$f":"('STEP 3--Nutrient Needs'!D11/C12)-VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,12,FALSE)/C12","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"K12*E12","v":{"$error":"#N/A"}},{"$f":"K12*F12","v":{"$error":"#N/A"}},{"$f":"K12*G12","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[{"$f":"'STEP 5--Choose P'!A20","v":"SOP soluble"},{"$f":"'STEP 5--Choose P'!B20","v":0},{"$f":"'STEP 5--Choose P'!C20","v":0},{"$f":"'STEP 5--Choose P'!D20","v":0.52},{"$f":"'STEP 5--Choose P'!E20","v":0},{"$f":"'STEP 5--Choose P'!F20","v":0},{"$f":"'STEP 5--Choose P'!G20","v":0},{"$f":"'STEP 5--Choose P'!H20","v":0},{"$f":"'STEP 5--Choose P'!I20","v":54.3},{"$f":"'STEP 5--Choose P'!J20","v":0},{"$f":"('STEP 3--Nutrient Needs'!D11/C13)-VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,12,FALSE)/C13","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"K13*E13","v":{"$error":"#N/A"}},null,{"$f":"G13*K13","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[{"$f":"'STEP 5--Choose P'!A21","v":"Urea"},{"$f":"'STEP 5--Choose P'!B21","v":0.46},{"$f":"'STEP 5--Choose P'!C21","v":0},{"$f":"'STEP 5--Choose P'!D21","v":0},{"$f":"'STEP 5--Choose P'!E21","v":0},{"$f":"'STEP 5--Choose P'!F21","v":0},{"$f":"'STEP 5--Choose P'!G21","v":0},{"$f":"'STEP 5--Choose P'!H21","v":"rapid"},{"$f":"'STEP 5--Choose P'!I21","v":18.75},{"$f":"'STEP 5--Choose P'!J21","v":0},{"$f":"('STEP 3--Nutrient Needs'!D11/C14)-VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,12,FALSE)/C14","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"}]
[{"$f":"'STEP 5--Choose P'!A22","v":"NONE NEEDED"},{"$f":"'STEP 5--Choose P'!B22","v":0},{"$f":"'STEP 5--Choose P'!C22","v":0},{"$f":"'STEP 5--Choose P'!D22","v":0},{"$f":"'STEP 5--Choose P'!E22","v":0},{"$f":"'STEP 5--Choose P'!F22","v":0},{"$f":"'STEP 5--Choose P'!G22","v":0},{"$f":"'STEP 5--Choose P'!H22","v":0},{"$f":"'STEP 5--Choose P'!I22","v":0},{"$f":"'STEP 5--Choose P'!J22","v":0},0,0,0,0,0,0]
[{"$f":"'STEP 5--Choose P'!A23","v":"OTHER--enter Name in this cell, analysis and price to right-->"},{"$f":"'STEP 5--Choose P'!B23","v":0},{"$f":"'STEP 5--Choose P'!C23","v":0},{"$f":"'STEP 5--Choose P'!D23","v":0},{"$f":"'STEP 5--Choose P'!E23","v":0},{"$f":"'STEP 5--Choose P'!F23","v":0},{"$f":"'STEP 5--Choose P'!G23","v":0},{"$f":"'STEP 5--Choose P'!H23","v":0},{"$f":"'STEP 5--Choose P'!I23","v":0},{"$f":"'STEP 5--Choose P'!J23","v":{"$error":"#DIV/0!"}},{"$f":"('STEP 3--Nutrient Needs'!D11/C16)-VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,12,FALSE)/C16","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"STEP 6--Choose K","index":9,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,3],[23,0,23,5],[1,4,1,6],[2,0,2,2],[3,0,3,2],[4,0,4,9]]}
["Instructions: Select your potash amendments from the drop down menu in the yellow cell after reviewing the chart below."]
["Select Your Potash Amendments --->",null,null,null,"Sulfate of potash"]
["Your N and P205 selections contribute",null,null,{"$f":"VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,13,FALSE)+VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:L16,12,FALSE)","v":{"$error":"#N/A"}},"lbs K20/ acre"]
["You still need to add",null,null,{"$f":"('STEP 3--Nutrient Needs'!E11)-(VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,13,FALSE)+VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:L16,12,FALSE))","v":{"$error":"#N/A"}},"lbs K20/ acre"]
["POSSIBLE POTASH AMENDMENTS"]
[{"$f":"'Appendix--Fertilizer Costs'!A1","v":"MATERIAL"},{"$f":"'Appendix--Fertilizer Costs'!B1","v":"% N"},{"$f":"'Appendix--Fertilizer Costs'!C1","v":"% P2O5"},{"$f":"'Appendix--Fertilizer Costs'!D1","v":"% K20"},{"$f":"'Appendix--Fertilizer Costs'!E1","v":"% Ca"},{"$f":"'Appendix--Fertilizer Costs'!F1","v":"% Mg"},{"$f":"'Appendix--Fertilizer Costs'!G1","v":"% S"},{"$f":"'Appendix--Fertilizer Costs'!H1","v":"Release Rate"},{"$f":"'Appendix--Fertilizer Costs'!I1","v":"Price per 50 lb"},{"$f":"'Appendix--Fertilizer Costs'!L1","v":"$/lb K"}]
[{"$f":"'Appendix--Fertilizer Costs'!A10","v":"Dehydrated Poultry Manure (Kreher's 4-3-10)"},{"$f":"'Appendix--Fertilizer Costs'!B10","v":0.04},{"$f":"'Appendix--Fertilizer Costs'!C10","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!D10","v":0.1},{"$f":"'Appendix--Fertilizer Costs'!E10","v":0},{"$f":"'Appendix--Fertilizer Costs'!F10","v":0},{"$f":"'Appendix--Fertilizer Costs'!G10","v":0},{"$f":"'Appendix--Fertilizer Costs'!H10","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I10","v":22.5},{"$f":"'Appendix--Fertilizer Costs'!L10","v":4.5}]
[{"$f":"'Appendix--Fertilizer Costs'!A11","v":"Dehydrated Poultry Manure (Kreher's 7-2-6)"},{"$f":"'Appendix--Fertilizer Costs'!B11","v":7.0000000000000007E-2},{"$f":"'Appendix--Fertilizer Costs'!C11","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!D11","v":0.06},{"$f":"'Appendix--Fertilizer Costs'!E11","v":0},{"$f":"'Appendix--Fertilizer Costs'!F11","v":0},{"$f":"'Appendix--Fertilizer Costs'!G11","v":0},{"$f":"'Appendix--Fertilizer Costs'!H11","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I11","v":28.75},{"$f":"'Appendix--Fertilizer Costs'!L11","v":0}]
[{"$f":"'Appendix--Fertilizer Costs'!A21","v":"Granite dust"},{"$f":"'Appendix--Fertilizer Costs'!B21","v":0},{"$f":"'Appendix--Fertilizer Costs'!C21","v":0},{"$f":"'Appendix--Fertilizer Costs'!D21","v":0.06},{"$f":"'Appendix--Fertilizer Costs'!E21","v":0},{"$f":"'Appendix--Fertilizer Costs'!F21","v":0.11},{"$f":"'Appendix--Fertilizer Costs'!G21","v":0.22},{"$f":"'Appendix--Fertilizer Costs'!H21","v":"very slow"},{"$f":"'Appendix--Fertilizer Costs'!I21","v":89},{"$f":"'Appendix--Fertilizer Costs'!L21","v":29.666666666666668}]
[{"$f":"'Appendix--Fertilizer Costs'!A22","v":"Greensand"},{"$f":"'Appendix--Fertilizer Costs'!B22","v":0},{"$f":"'Appendix--Fertilizer Costs'!C22","v":0.01},{"$f":"'Appendix--Fertilizer Costs'!D22","v":7.0000000000000007E-2},{"$f":"'Appendix--Fertilizer Costs'!E22","v":0},{"$f":"'Appendix--Fertilizer Costs'!F22","v":0},{"$f":"'Appendix--Fertilizer Costs'!G22","v":0},{"$f":"'Appendix--Fertilizer Costs'!H22","v":"very slow"},{"$f":"'Appendix--Fertilizer Costs'!I22","v":31.5},{"$f":"'Appendix--Fertilizer Costs'!L22","v":8.9999999999999982}]
[{"$f":"'Appendix--Fertilizer Costs'!A24","v":"K-mag"},{"$f":"'Appendix--Fertilizer Costs'!B24","v":0},{"$f":"'Appendix--Fertilizer Costs'!C24","v":0},{"$f":"'Appendix--Fertilizer Costs'!D24","v":0.22},{"$f":"'Appendix--Fertilizer Costs'!E24","v":0},{"$f":"'Appendix--Fertilizer Costs'!F24","v":0.11},{"$f":"'Appendix--Fertilizer Costs'!G24","v":0.22},{"$f":"'Appendix--Fertilizer Costs'!H24","v":"rapid"},{"$f":"'Appendix--Fertilizer Costs'!I24","v":27.65},{"$f":"'Appendix--Fertilizer Costs'!L24","v":2.5136363636363637}]
[{"$f":"'Appendix--Fertilizer Costs'!A27","v":"Makro 60"},{"$f":"'Appendix--Fertilizer Costs'!B27","v":0},{"$f":"'Appendix--Fertilizer Costs'!C27","v":0},{"$f":"'Appendix--Fertilizer Costs'!D27","v":0.6},{"$f":"'Appendix--Fertilizer Costs'!E27","v":0},{"$f":"'Appendix--Fertilizer Costs'!F27","v":0},{"$f":"'Appendix--Fertilizer Costs'!G27","v":0},{"$f":"'Appendix--Fertilizer Costs'!H27","v":0},{"$f":"'Appendix--Fertilizer Costs'!I27","v":36.25},{"$f":"'Appendix--Fertilizer Costs'!L27","v":0}]
[{"$f":"'Appendix--Fertilizer Costs'!A29","v":"Naturesafe"},{"$f":"'Appendix--Fertilizer Costs'!B29","v":7.0000000000000007E-2},{"$f":"'Appendix--Fertilizer Costs'!C29","v":0.12},{"$f":"'Appendix--Fertilizer Costs'!D29","v":0},{"$f":"'Appendix--Fertilizer Costs'!E29","v":0},{"$f":"'Appendix--Fertilizer Costs'!F29","v":0},{"$f":"'Appendix--Fertilizer Costs'!G29","v":0},{"$f":"'Appendix--Fertilizer Costs'!H29","v":0},{"$f":"'Appendix--Fertilizer Costs'!I29","v":35},{"$f":"'Appendix--Fertilizer Costs'!L29","v":0}]
[{"$f":"'Appendix--Fertilizer Costs'!A32","v":"Peanut meal"},{"$f":"'Appendix--Fertilizer Costs'!B32","v":0.08},{"$f":"'Appendix--Fertilizer Costs'!C32","v":0.01},{"$f":"'Appendix--Fertilizer Costs'!D32","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!E32","v":0},{"$f":"'Appendix--Fertilizer Costs'!F32","v":0},{"$f":"'Appendix--Fertilizer Costs'!G32","v":0},{"$f":"'Appendix--Fertilizer Costs'!H32","v":"slow/ med"},{"$f":"'Appendix--Fertilizer Costs'!I32","v":28},{"$f":"'Appendix--Fertilizer Costs'!L32","v":28}]
[{"$f":"'Appendix--Fertilizer Costs'!A36","v":"Solubor"}]
[{"$f":"'Appendix--Fertilizer Costs'!A37","v":"Soybean meal"},{"$f":"'Appendix--Fertilizer Costs'!B37","v":7.0000000000000007E-2},{"$f":"'Appendix--Fertilizer Costs'!C37","v":0.01},{"$f":"'Appendix--Fertilizer Costs'!D37","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!E37","v":0},{"$f":"'Appendix--Fertilizer Costs'!F37","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!G37","v":0},{"$f":"'Appendix--Fertilizer Costs'!H37","v":"slow/ med"},{"$f":"'Appendix--Fertilizer Costs'!I37","v":17},{"$f":"'Appendix--Fertilizer Costs'!L37","v":17}]
[{"$f":"'Appendix--Fertilizer Costs'!A38","v":"Soybean meal, OG"},{"$f":"'Appendix--Fertilizer Costs'!B38","v":7.0000000000000007E-2},{"$f":"'Appendix--Fertilizer Costs'!C38","v":0.01},{"$f":"'Appendix--Fertilizer Costs'!D38","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!E38","v":0},{"$f":"'Appendix--Fertilizer Costs'!F38","v":0},{"$f":"'Appendix--Fertilizer Costs'!G38","v":0},{"$f":"'Appendix--Fertilizer Costs'!H38","v":"slow/ med"},{"$f":"'Appendix--Fertilizer Costs'!I38","v":43.6},{"$f":"'Appendix--Fertilizer Costs'!L38","v":43.6}]
[{"$f":"'Appendix--Fertilizer Costs'!A39","v":"Sulfate of potash"},{"$f":"'Appendix--Fertilizer Costs'!B39","v":0},{"$f":"'Appendix--Fertilizer Costs'!C39","v":0},{"$f":"'Appendix--Fertilizer Costs'!D39","v":0.5},{"$f":"'Appendix--Fertilizer Costs'!E39","v":0},{"$f":"'Appendix--Fertilizer Costs'!F39","v":0},{"$f":"'Appendix--Fertilizer Costs'!G39","v":0.17},{"$f":"'Appendix--Fertilizer Costs'!H39","v":"rapid"},{"$f":"'Appendix--Fertilizer Costs'!I39","v":34.14},{"$f":"'Appendix--Fertilizer Costs'!L39","v":1.3655999999999999}]
[{"$f":"'Appendix--Fertilizer Costs'!A40","v":"SOP soluble"},{"$f":"'Appendix--Fertilizer Costs'!B40","v":0},{"$f":"'Appendix--Fertilizer Costs'!C40","v":0},{"$f":"'Appendix--Fertilizer Costs'!D40","v":0.52},{"$f":"'Appendix--Fertilizer Costs'!E40","v":0},{"$f":"'Appendix--Fertilizer Costs'!F40","v":0},{"$f":"'Appendix--Fertilizer Costs'!G40","v":0},{"$f":"'Appendix--Fertilizer Costs'!H40","v":0},{"$f":"'Appendix--Fertilizer Costs'!I40","v":54.3},{"$f":"'Appendix--Fertilizer Costs'!L40","v":0}]
[{"$f":"'Appendix--Fertilizer Costs'!A42","v":"Urea"},{"$f":"'Appendix--Fertilizer Costs'!B42","v":0.46},{"$f":"'Appendix--Fertilizer Costs'!C42","v":0},{"$f":"'Appendix--Fertilizer Costs'!D42","v":0},{"$f":"'Appendix--Fertilizer Costs'!E42","v":0},{"$f":"'Appendix--Fertilizer Costs'!F42","v":0},{"$f":"'Appendix--Fertilizer Costs'!G42","v":0},{"$f":"'Appendix--Fertilizer Costs'!H42","v":"rapid"},{"$f":"'Appendix--Fertilizer Costs'!I42","v":18.75},{"$f":"'Appendix--Fertilizer Costs'!L42","v":0}]
["NONE NEEDED",0,0,0,null,null,null,null,0]
["OTHER--enter Name in this cell, analysis and price to right-->",null,null,null,null,null,null,null,null,{"$f":"I22/D22/50","v":{"$error":"#DIV/0!"}}]
[]
["Blue shading indicates an organic material, but check with your certifying agency before using. "]

{"sheet":"K lookup","index":10,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[{"$f":"'STEP 6--Choose K'!A6","v":"MATERIAL"},{"$f":"'STEP 6--Choose K'!B6","v":"% N"},{"$f":"'STEP 6--Choose K'!C6","v":"% P2O5"},{"$f":"'STEP 6--Choose K'!D6","v":"% K20"},{"$f":"'STEP 6--Choose K'!E6","v":"% Ca"},{"$f":"'STEP 6--Choose K'!F6","v":"% Mg"},{"$f":"'STEP 6--Choose K'!G6","v":"% S"},{"$f":"'STEP 6--Choose K'!H6","v":"Release Rate"},{"$f":"'STEP 6--Choose K'!I6","v":"Price per 50 lb"},{"$f":"'STEP 6--Choose K'!J6","v":"$/lb K"},"Pounds of K20 fertilizer per acre (accounts for any K20 in your N&P fertilizer selection)","PoundsCa","Pounds Mg","Pounds S","Estimated Cost"]
[{"$f":"'STEP 6--Choose K'!A7","v":"Dehydrated Poultry Manure (Kreher's 4-3-10)"},{"$f":"'STEP 6--Choose K'!B7","v":0.04},{"$f":"'STEP 6--Choose K'!C7","v":0.03},{"$f":"'STEP 6--Choose K'!D7","v":0.1},{"$f":"'STEP 6--Choose K'!E7","v":0},{"$f":"'STEP 6--Choose K'!F7","v":0},{"$f":"'STEP 6--Choose K'!G7","v":0},{"$f":"'STEP 6--Choose K'!H7","v":"med"},{"$f":"'STEP 6--Choose K'!I7","v":22.5},{"$f":"'STEP 6--Choose K'!J7","v":4.5},{"$f":"('STEP 3--Nutrient Needs'!E11/D2)-((VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,13,FALSE)+VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:L16,12,FALSE))/D2)","v":{"$error":"#N/A"}},{"$f":"K2*E2","v":{"$error":"#N/A"}},{"$f":"K2*F2","v":{"$error":"#N/A"}},{"$f":"K2*G2","v":{"$error":"#N/A"}},{"$f":"K2/50*I2","v":{"$error":"#N/A"}}]
[{"$f":"'STEP 6--Choose K'!A8","v":"Dehydrated Poultry Manure (Kreher's 7-2-6)"},{"$f":"'STEP 6--Choose K'!B8","v":7.0000000000000007E-2},{"$f":"'STEP 6--Choose K'!C8","v":0.02},{"$f":"'STEP 6--Choose K'!D8","v":0.06},{"$f":"'STEP 6--Choose K'!E8","v":0},{"$f":"'STEP 6--Choose K'!F8","v":0},{"$f":"'STEP 6--Choose K'!G8","v":0},{"$f":"'STEP 6--Choose K'!H8","v":"med"},{"$f":"'STEP 6--Choose K'!I8","v":28.75},{"$f":"'STEP 6--Choose K'!J8","v":0},{"$f":"('STEP 3--Nutrient Needs'!E11/D3)-((VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,13,FALSE)+VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:L16,12,FALSE))/D3)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'STEP 6--Choose K'!A9","v":"Granite dust"},{"$f":"'STEP 6--Choose K'!B9","v":0},{"$f":"'STEP 6--Choose K'!C9","v":0},{"$f":"'STEP 6--Choose K'!D9","v":0.06},{"$f":"'STEP 6--Choose K'!E9","v":0},{"$f":"'STEP 6--Choose K'!F9","v":0.11},{"$f":"'STEP 6--Choose K'!G9","v":0.22},{"$f":"'STEP 6--Choose K'!H9","v":"very slow"},{"$f":"'STEP 6--Choose K'!I9","v":89},{"$f":"'STEP 6--Choose K'!J9","v":29.666666666666668},{"$f":"('STEP 3--Nutrient Needs'!E11/D4)-((VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,13,FALSE)+VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:L16,12,FALSE))/D4)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'STEP 6--Choose K'!A10","v":"Greensand"},{"$f":"'STEP 6--Choose K'!B10","v":0},{"$f":"'STEP 6--Choose K'!C10","v":0.01},{"$f":"'STEP 6--Choose K'!D10","v":7.0000000000000007E-2},{"$f":"'STEP 6--Choose K'!E10","v":0},{"$f":"'STEP 6--Choose K'!F10","v":0},{"$f":"'STEP 6--Choose K'!G10","v":0},{"$f":"'STEP 6--Choose K'!H10","v":"very slow"},{"$f":"'STEP 6--Choose K'!I10","v":31.5},{"$f":"'STEP 6--Choose K'!J10","v":8.9999999999999982},{"$f":"('STEP 3--Nutrient Needs'!E11/D5)-((VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,13,FALSE)+VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:L16,12,FALSE))/D5)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'STEP 6--Choose K'!A11","v":"K-mag"},{"$f":"'STEP 6--Choose K'!B11","v":0},{"$f":"'STEP 6--Choose K'!C11","v":0},{"$f":"'STEP 6--Choose K'!D11","v":0.22},{"$f":"'STEP 6--Choose K'!E11","v":0},{"$f":"'STEP 6--Choose K'!F11","v":0.11},{"$f":"'STEP 6--Choose K'!G11","v":0.22},{"$f":"'STEP 6--Choose K'!H11","v":"rapid"},{"$f":"'STEP 6--Choose K'!I11","v":27.65},{"$f":"'STEP 6--Choose K'!J11","v":2.5136363636363637},{"$f":"('STEP 3--Nutrient Needs'!E11/D6)-((VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,13,FALSE)+VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:L16,12,FALSE))/D6)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'STEP 6--Choose K'!A12","v":"Makro 60"},{"$f":"'STEP 6--Choose K'!B12","v":0},{"$f":"'STEP 6--Choose K'!C12","v":0},{"$f":"'STEP 6--Choose K'!D12","v":0.6},{"$f":"'STEP 6--Choose K'!E12","v":0},{"$f":"'STEP 6--Choose K'!F12","v":0},{"$f":"'STEP 6--Choose K'!G12","v":0},{"$f":"'STEP 6--Choose K'!H12","v":0},{"$f":"'STEP 6--Choose K'!I12","v":36.25},{"$f":"'STEP 6--Choose K'!J12","v":0},{"$f":"('STEP 3--Nutrient Needs'!E11/D7)-((VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,13,FALSE)+VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:L16,12,FALSE))/D7)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'STEP 6--Choose K'!A13","v":"Naturesafe"},{"$f":"'STEP 6--Choose K'!B13","v":7.0000000000000007E-2},{"$f":"'STEP 6--Choose K'!C13","v":0.12},{"$f":"'STEP 6--Choose K'!D13","v":0},{"$f":"'STEP 6--Choose K'!E13","v":0},{"$f":"'STEP 6--Choose K'!F13","v":0},{"$f":"'STEP 6--Choose K'!G13","v":0},{"$f":"'STEP 6--Choose K'!H13","v":0},{"$f":"'STEP 6--Choose K'!I13","v":35},{"$f":"'STEP 6--Choose K'!J13","v":0},{"$f":"('STEP 3--Nutrient Needs'!E11/D8)-((VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,13,FALSE)+VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:L16,12,FALSE))/D8)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'STEP 6--Choose K'!A14","v":"Peanut meal"},{"$f":"'STEP 6--Choose K'!B14","v":0.08},{"$f":"'STEP 6--Choose K'!C14","v":0.01},{"$f":"'STEP 6--Choose K'!D14","v":0.02},{"$f":"'STEP 6--Choose K'!E14","v":0},{"$f":"'STEP 6--Choose K'!F14","v":0},{"$f":"'STEP 6--Choose K'!G14","v":0},{"$f":"'STEP 6--Choose K'!H14","v":"slow/ med"},{"$f":"'STEP 6--Choose K'!I14","v":28},{"$f":"'STEP 6--Choose K'!J14","v":28},{"$f":"('STEP 3--Nutrient Needs'!E11/D9)-((VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,13,FALSE)+VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:L16,12,FALSE))/D9)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$f":"'STEP 6--Choose K'!A15","v":"Solubor"}]
[{"$f":"'STEP 6--Choose K'!A16","v":"Soybean meal"},{"$f":"'STEP 6--Choose K'!B16","v":7.0000000000000007E-2},{"$f":"'STEP 6--Choose K'!C16","v":0.01},{"$f":"'STEP 6--Choose K'!D16","v":0.02},{"$f":"'STEP 6--Choose K'!E16","v":0},{"$f":"'STEP 6--Choose K'!F16","v":0.03},{"$f":"'STEP 6--Choose K'!G16","v":0},{"$f":"'STEP 6--Choose K'!H16","v":"slow/ med"},{"$f":"'STEP 6--Choose K'!I16","v":17},{"$f":"'STEP 6--Choose K'!J16","v":17},{"$f":"('STEP 3--Nutrient Needs'!E11/D11)-((VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,13,FALSE)+VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:L16,12,FALSE))/D11)","v":{"$error":"#N/A"}},{"$f":"K11*E11","v":{"$error":"#N/A"}},{"$f":"K11*F11","v":{"$error":"#N/A"}},{"$f":"K11*G11","v":{"$error":"#N/A"}},{"$f":"K11/50*I11","v":{"$error":"#N/A"}}]
[{"$f":"'STEP 6--Choose K'!A17","v":"Soybean meal, OG"},{"$f":"'STEP 6--Choose K'!B17","v":7.0000000000000007E-2},{"$f":"'STEP 6--Choose K'!C17","v":0.01},{"$f":"'STEP 6--Choose K'!D17","v":0.02},{"$f":"'STEP 6--Choose K'!E17","v":0},{"$f":"'STEP 6--Choose K'!F17","v":0},{"$f":"'STEP 6--Choose K'!G17","v":0},{"$f":"'STEP 6--Choose K'!H17","v":"slow/ med"},{"$f":"'STEP 6--Choose K'!I17","v":43.6},{"$f":"'STEP 6--Choose K'!J17","v":43.6},{"$f":"('STEP 3--Nutrient Needs'!E11/D12)-((VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,13,FALSE)+VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:L16,12,FALSE))/D12)","v":{"$error":"#N/A"}},{"$f":"K12*E12","v":{"$error":"#N/A"}},{"$f":"K12*F12","v":{"$error":"#N/A"}},{"$f":"K12*G12","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[{"$f":"'STEP 6--Choose K'!A18","v":"Sulfate of potash"},{"$f":"'STEP 6--Choose K'!B18","v":0},{"$f":"'STEP 6--Choose K'!C18","v":0},{"$f":"'STEP 6--Choose K'!D18","v":0.5},{"$f":"'STEP 6--Choose K'!E18","v":0},{"$f":"'STEP 6--Choose K'!F18","v":0},{"$f":"'STEP 6--Choose K'!G18","v":0.17},{"$f":"'STEP 6--Choose K'!H18","v":"rapid"},{"$f":"'STEP 6--Choose K'!I18","v":34.14},{"$f":"'STEP 6--Choose K'!J18","v":1.3655999999999999},{"$f":"('STEP 3--Nutrient Needs'!E11/D13)-((VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,13,FALSE)+VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:L16,12,FALSE))/D13)","v":{"$error":"#N/A"}},{"$f":"K13*E13","v":{"$error":"#N/A"}},{"$f":"K13*F13","v":{"$error":"#N/A"}},{"$f":"K13*G13","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[{"$f":"'STEP 6--Choose K'!A19","v":"SOP soluble"},{"$f":"'STEP 6--Choose K'!B19","v":0},{"$f":"'STEP 6--Choose K'!C19","v":0},{"$f":"'STEP 6--Choose K'!D19","v":0.52},{"$f":"'STEP 6--Choose K'!E19","v":0},{"$f":"'STEP 6--Choose K'!F19","v":0},{"$f":"'STEP 6--Choose K'!G19","v":0},{"$f":"'STEP 6--Choose K'!H19","v":0},{"$f":"'STEP 6--Choose K'!I19","v":54.3},{"$f":"'STEP 6--Choose K'!J19","v":0},{"$f":"('STEP 3--Nutrient Needs'!E11/D14)-((VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,13,FALSE)+VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:L16,12,FALSE))/D14)","v":{"$error":"#N/A"}},{"$f":"K14*E14","v":{"$error":"#N/A"}},{"$f":"K14*F14","v":{"$error":"#N/A"}},{"$f":"K14*G14","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[{"$f":"'STEP 6--Choose K'!A20","v":"Urea"},{"$f":"'STEP 6--Choose K'!B20","v":0.46},{"$f":"'STEP 6--Choose K'!C20","v":0},{"$f":"'STEP 6--Choose K'!D20","v":0},{"$f":"'STEP 6--Choose K'!E20","v":0},{"$f":"'STEP 6--Choose K'!F20","v":0},{"$f":"'STEP 6--Choose K'!G20","v":0},{"$f":"'STEP 6--Choose K'!H20","v":"rapid"},{"$f":"'STEP 6--Choose K'!I20","v":18.75},{"$f":"'STEP 6--Choose K'!J20","v":0},{"$f":"('STEP 3--Nutrient Needs'!E11/D15)-((VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,13,FALSE)+VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:L16,12,FALSE))/D15)","v":{"$error":"#N/A"}},{"$f":"K15*E15","v":{"$error":"#N/A"}},{"$f":"K15*F15","v":{"$error":"#N/A"}},{"$f":"K15*G15","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[{"$f":"'STEP 6--Choose K'!A21","v":"NONE NEEDED"},{"$f":"'STEP 6--Choose K'!B21","v":0},{"$f":"'STEP 6--Choose K'!C21","v":0},{"$f":"'STEP 6--Choose K'!D21","v":0},{"$f":"'STEP 6--Choose K'!E21","v":0},{"$f":"'STEP 6--Choose K'!F21","v":0},{"$f":"'STEP 6--Choose K'!G21","v":0},{"$f":"'STEP 6--Choose K'!H21","v":0},{"$f":"'STEP 6--Choose K'!I21","v":0},{"$f":"'STEP 6--Choose K'!J21","v":0},0,0,0,0,0]
[{"$f":"'STEP 6--Choose K'!A22","v":"OTHER--enter Name in this cell, analysis and price to right-->"},{"$f":"'STEP 6--Choose K'!B22","v":0},{"$f":"'STEP 6--Choose K'!C22","v":0},{"$f":"'STEP 6--Choose K'!D22","v":0},{"$f":"'STEP 6--Choose K'!E22","v":0},{"$f":"'STEP 6--Choose K'!F22","v":0},{"$f":"'STEP 6--Choose K'!G22","v":0},{"$f":"'STEP 6--Choose K'!H22","v":0},{"$f":"'STEP 6--Choose K'!I22","v":0},{"$f":"'STEP 6--Choose K'!J22","v":{"$error":"#DIV/0!"}},{"$f":"('STEP 3--Nutrient Needs'!E11/D16)-((VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,13,FALSE)+VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:L16,12,FALSE))/D17)","v":{"$error":"#N/A"}},{"$f":"K17*E17","v":{"$error":"#N/A"}},{"$f":"K17*F17","v":{"$error":"#N/A"}},{"$f":"K17*G17","v":{"$error":"#N/A"}},{"$error":"#N/A"}]

{"sheet":"STEP 7--Fertilizer Costs","index":11,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["The chart below collects the fertilizer you selected on the other worksheets for a total volume and cost of ammending the area specified in Step 1. "]
[]
[null,"Fertilizer","Pounds of fertilizer to add per acre","Relative availability of fertilizer","Estimated cost of fertilizer per acre","Pounds of fertilizer for your field","Estimated cost of fertilizer for your field "]
["N-->",{"$f":"'STEP 4--Choose N'!D2","v":"Soybean meal, OG"},{"$f":"ROUNDUP(VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,11,FALSE),-2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,8,FALSE)","v":"slow/ med"},{"$f":"ROUNDUP(VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,17,FALSE),-1)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,11,FALSE),-2)*'STEP 1--Field Information'!F23","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,17,FALSE),-1)*'STEP 1--Field Information'!F23","v":{"$error":"#N/A"}}]
["P-->",{"$f":"'STEP 5--Choose P'!D2","v":"NONE NEEDED"},{"$f":"ROUNDUP(VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:P16,11,FALSE),-2)","v":0},{"$f":"VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:P16,8,FALSE)","v":0},{"$f":"ROUNDUP(VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:P16,16,FALSE),-1)","v":0},{"$f":"ROUNDUP(VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:P16,11,FALSE),-2)*'STEP 1--Field Information'!F23","v":0},{"$f":"ROUNDUP(VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:P16,16,FALSE),-1)*'STEP 1--Field Information'!F23","v":0}]
["K-->",{"$f":"'STEP 6--Choose K'!E2","v":"Sulfate of potash"},{"$f":"ROUNDUP(VLOOKUP('STEP 6--Choose K'!E2,'K lookup'!A2:P17,11,FALSE),-1)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP('STEP 6--Choose K'!E2,'K lookup'!A2:P17,8,FALSE)","v":"rapid"},{"$f":"ROUNDUP(VLOOKUP('STEP 6--Choose K'!E2,'K lookup'!A2:P17,15,FALSE),-1)","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(VLOOKUP('STEP 6--Choose K'!E2,'K lookup'!A2:P17,11,FALSE),-1)*'STEP 1--Field Information'!F23","v":{"$error":"#N/A"}},{"$f":"ROUNDUP(VLOOKUP('STEP 6--Choose K'!E2,'K lookup'!A2:P17,15,FALSE),-1)*'STEP 1--Field Information'!F23","v":{"$error":"#N/A"}}]
[null,"Cost per acre",null,null,{"$f":"SUM(E4:E6)","v":{"$error":"#N/A"}}]
[]
[]
["TOTAL FERTILIZER COST for your field",null,null,null,null,null,{"$f":"SUM(E4:E6)*'STEP 1--Field Information'!F23","v":{"$error":"#N/A"}}]

{"sheet":"Calcium","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Magnesium","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sulfur","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Trace Element ","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"STEP 8--Amendment Plan","index":16,"n_rows":4,"n_cols":19,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,6],[1,7,1,11]]}
["Instructions: The information below will autofill from the calculator. Once you complete the calculator for each field, click \"Save Line\" in the left hand column, and the information will be saved in the line below. You may then start the calculator again for your next field. "]
[]
["click here to save line for each field:","Field Name","Size (acre equivalents)","Crop","pH","Lime needed (tons per acre)","lb/ acre N ","N Amendment","lb/ field N Amendment","lb/ acre P205 ","P205 Amendment","lb/ field P205 Amendment ","Recommended lb/ field unit K20 ","K20 Amendment","lb/ field K20 Amendment","Estimated cost of Amendments per field"," Pounds Ca contributed by selected fertilizlers","Pounds Mg contributed by selected fertilizlers","Pounds S contributed by selected fertilizlers"]
[null,{"$f":"'STEP 1--Field Information'!E6","v":0},{"$f":"'STEP 1--Field Information'!F23","v":0},{"$f":"'STEP 1--Field Information'!E8","v":0},{"$f":"'STEP 2--Soil Test Information'!B4","v":0},{"$f":"'STEP 2--Soil Test Information'!B21","v":0},{"$f":"'STEP 3--Nutrient Needs'!C11","v":{"$error":"#N/A"}},{"$f":"'STEP 4--Choose N'!D2","v":"Soybean meal, OG"},{"$f":"'STEP 7--Fertilizer Costs'!F4","v":{"$error":"#N/A"}},{"$f":"'STEP 3--Nutrient Needs'!D11","v":{"$error":"#N/A"}},{"$f":"'STEP 5--Choose P'!D2","v":"NONE NEEDED"},{"$f":"'STEP 7--Fertilizer Costs'!F5","v":0},{"$f":"'STEP 3--Nutrient Needs'!E11","v":{"$error":"#N/A"}},{"$f":"'STEP 6--Choose K'!E2","v":"Sulfate of potash"},{"$f":"'STEP 7--Fertilizer Costs'!F6","v":{"$error":"#N/A"}},{"$f":"(ROUNDUP(VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,17,FALSE),-1)+ROUNDUP(VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:P16,16,FALSE),-1)+ROUNDUP(VLOOKUP('STEP 6--Choose K'!E2,'K lookup'!A2:P17,15,FALSE),-1))*'STEP 1--Field Information'!F23","v":{"$error":"#N/A"}},{"$f":"C4*(VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:P16,13,FALSE)+VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,14,FALSE)+VLOOKUP('STEP 6--Choose K'!E2,'K lookup'!A2:P17,12,FALSE))","v":{"$error":"#N/A"}},{"$f":"C4*(VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:P16,14,FALSE)+VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,15,FALSE)+VLOOKUP('STEP 6--Choose K'!E2,'K lookup'!A2:P17,13,FALSE))","v":{"$error":"#N/A"}},{"$f":"C4*(VLOOKUP('STEP 5--Choose P'!D2,'P lookup'!A2:P16,15,FALSE)+VLOOKUP('STEP 4--Choose N'!D2,'N lookup'!A2:Q47,16,FALSE)+VLOOKUP('STEP 6--Choose K'!E2,'K lookup'!A2:P17,14,FALSE))","v":{"$error":"#N/A"}}]

{"sheet":"Appendix--Fertilizer Costs","index":17,"n_rows":50,"n_cols":13,"rows_kept":50,"cut":false,"hidden":false,"merged":[[43,0,43,2]]}
["MATERIAL","% N","% P2O5","% K20","% Ca","% Mg","% S","Release Rate","Price per 50 lb","$/lb N","$/lb P","$/lb K","pricing source"]
["Alfalfa meal",0.03,5.0000000000000001E-3,2.5000000000000001E-2,null,null,null,"slow/ med",31.06,{"$f":"I2*2/(B2*100)","v":20.706666666666667},{"$f":"I2*2/(C2*100)","v":124.24},{"$f":"I2*2/(D2*100)","v":24.847999999999999},"Oliver"]
["Azomite",null,null,null,null,null,null,null,{"$f":"50/44*50","v":56.81818181818182},null,null,null,"Lawes "]
["Blood meal",0.13,0,0,null,null,null,"med/ rapid",91.49,{"$f":"I4*2/(B4*100)","v":14.075384615384614},null,null,"Oliver"]
["Bone meal, OG",0.03,0.15,null,null,null,null,"med",71,{"$f":"I5*2/(B5*100)","v":47.333333333333336},{"$f":"I5*2/(C5*100)","v":9.4666666666666668},null,"Oliver"]
["Bone char",0,0.16,0,null,null,null,"rapid",47.2,null,{"$f":"I6*2/(C6*100)","v":5.9},null,"Oliver"]
["Calcitic limestone",null,null,null,0.38,null,null,"med"]
["Chilean nitrate",0.15,null,0.02,null,null,null,"rapid",76.540000000000006,{"$f":"I8*2/(B8*100)","v":10.205333333333334},null,null,"Oliver"]
["Dehydrated Poultry Manure (Kreher's 5-4-3)",0.05,0.04,0.03,0.09,null,null,"med",15,{"$f":"I9*2/(B9*100)","v":6},{"$f":"I9*2/(C9*100)","v":7.5},{"$f":"I9*2/(D9*100)","v":10},"Lawes "]
["Dehydrated Poultry Manure (Kreher's 4-3-10)",0.04,0.03,0.1,null,null,null,"med",22.5,{"$f":"I10*2/(B10*100)","v":11.25},{"$f":"I10*2/(C10*100)","v":15},{"$f":"I10*2/(D10*100)","v":4.5},"Lawes "]
["Dehydrated Poultry Manure (Kreher's 7-2-6)",7.0000000000000007E-2,0.02,0.06,null,null,null,"med",28.75,{"$f":"I11*2/(B11*100)","v":8.2142857142857135},null,null,"Lawes "]
["Dehydrated Poultry Manure (Kreher's 8-2-2)",0.08,0.02,0.02,null,null,null,"med",28.75,{"$f":"I12*2/(B12*100)","v":7.1875},{"$f":"I12*2/(C12*100)","v":28.75},{"$f":"I12*2/(D12*100)","v":28.75},"Lawes "]
["Diammonium phosphate",null,0.46,null,null,null,null,"rapid",{"$f":"473/40","v":11.824999999999999},null,{"$f":"I13*2/(C13*100)","v":0.51413043478260867},null,"Lawes "]
["Dolomitic limestone",null,null,null,0.25,0.1,null,"med"]
["Epsom salts (Mg sulfate)",null,null,null,null,9.8000000000000004E-2,0.13,"rapid",21.52,null,null,null,"Oliver"]
["Feather meal",0.13,null,null,null,null,null,"med",56.77,{"$f":"I16*2/(B16*100)","v":8.7338461538461551},null,null,"Oliver"]
["Fish emulsion",0.02,0.05,2.0000000000000001E-4,null,null,null,"rapid",109,null,null,null,"Fedco"]
["Fish meal",6.7000000000000004E-2,0.11,4.0000000000000001E-3,null,null,null,"med",112,{"$f":"I18*2/(B18*100)","v":33.432835820895519},{"$f":"I18*2/(C18*100)","v":20.363636363636363},null,"Fedco"]
["Grioux's Composted Poultry Manure",0.02,0.03,1.4999999999999999E-2,7.0000000000000007E-2,0.01,0.05,"med",{"$f":"40/2000*50","v":1},{"$f":"I19*2/(B19*100)","v":1},{"$f":"I19*2/(C19*100)","v":0.66666666666666663},{"$f":"I19*2/(D19*100)","v":1.3333333333333333},"Giroux"]
["Giroux's pellets",0.04,0.03,0.02,null,null,null,"med",8.3000000000000007,{"$f":"I20*2/(B20*100)","v":4.1500000000000004},{"$f":"I20*2/(C20*100)","v":5.5333333333333341},{"$f":"I20*2/(D20*100)","v":8.3000000000000007}]
["Granite dust",null,null,0.06,null,0.11,0.22,"very slow",89,null,null,{"$f":"I21*2/(D21*100)","v":29.666666666666668}]
["Greensand",null,0.01,7.0000000000000007E-2,null,null,null,"very slow",31.5,null,null,{"$f":"I22*2/(D22*100)","v":8.9999999999999982}]
["Gypsum",null,null,null,0.23,null,null,null,24,null,null,null,"Fedco"]
["K-mag",null,null,0.22,null,0.11,0.22,"rapid",27.65,null,null,{"$f":"I24*2/(D24*100)","v":2.5136363636363637},"Oliver"]
["Kelp meal",null,null,null,null,null,null,null,98,null,null,null,"Fedco"]
["Ag-Lime",null,null,null,null,null,null,null,200,null,null,null,"Lawes"]
["Makro 60",0,0,0.6,null,null,null,null,36.25,null,null,null,"Lawes"]
["Naturesafe",0.13,0,0,null,null,null,"med",42.5,{"$f":"I28*2/(B28*100)","v":6.5384615384615383},null,null,"Lawes"]
["Naturesafe",7.0000000000000007E-2,0.12,0,null,null,null,null,{"$f":"28/40*50","v":35},{"$f":"I29*2/(B29*100)","v":9.9999999999999982},null,null,"Lawes"]
["Naturesafe",0.1,0.02,0.08,null,null,null,null,36.25,{"$f":"I30*2/(B30*100)","v":7.25},null,null,"Lawes"]
["Organo-Phos w. humic acid",0,0.12,0,0.25,null,null,null,null,null,null,null,"Lawes"]
["Peanut meal",0.08,0.01,0.02,null,null,null,"slow/ med",28,{"$f":"I32*2/(B32*100)","v":7},{"$f":"I32*2/(C32*100)","v":56},{"$f":"I32*2/(D32*100)","v":28},"Oliver"]
["Potassium chloride",null,null,0.6,null,null,null,"rapid",{"$f":"740/2000*50","v":18.5},null,null,{"$f":"I33*2/(D33*100)","v":0.6166666666666667},"Lawes"]
["Polysulfate",0,0,0.14000000000000001,0.12,3.5999999999999997E-2,0.19,null,20,null,null,null,"Lawes"]
["Rock phosphate",null,0.05,null,null,null,null,"very slow",25,null,{"$f":"I35*2/(C35*100)","v":10},null,"Fedco"]
["Solubor",null,null,null,null,null,null,"20.5 % B",90,null,null,null,"Lawes"]
["Soybean meal",7.0000000000000007E-2,0.01,0.02,null,0.03,null,"slow/ med",17,{"$f":"I37*2/(B37*100)","v":4.8571428571428568},{"$f":"I37*2/(C37*100)","v":34},{"$f":"I37*2/(D37*100)","v":17},"Depot"]
["Soybean meal, OG",7.0000000000000007E-2,0.01,0.02,null,null,null,"slow/ med",43.6,{"$f":"I38*2/(B38*100)","v":12.457142857142856},{"$f":"I38*2/(C38*100)","v":87.2},{"$f":"I38*2/(D38*100)","v":43.6},"Oliver"]
["Sulfate of potash",0,0,0.5,null,null,0.17,"rapid",34.14,null,null,{"$f":"I39*2/(D39*100)","v":1.3655999999999999},"Oliver"]
["SOP soluble",0,0,0.52,null,null,null,null,54.3,null,null,null,"Oliver"]
["Triple super phosphate",0.18,0.46,null,null,null,null,"rapid",{"$f":"980/2000*50","v":24.5},null,{"$f":"I41*2/(C41*100)","v":1.0652173913043479},null,"Lawes"]
["Urea",0.46,null,null,null,null,null,"rapid",{"$f":"750/2000*50","v":18.75},{"$f":"I42*2/(B42*100)","v":0.81521739130434778},null,null,"Lawes"]
["Sufur, elemental",null,null,null,null,null,0.9,"slow/ med",38,null,null,null,"Fedco"]
["Blended fertilizers"]
["10-10-10",0.1,0.1,0.1,null,null,null,"med",{"$f":"500/2000*50","v":12.5},{"$f":"I45*2/(B45*100)","v":2.5},{"$f":"I45*2/(C45*100)","v":2.5},{"$f":"I45*2/(D45*100)","v":2.5}]
["Cheep Cheep",0.04,0.03,0.03,null,null,null,"med",27.65,13.824999999999999,{"$f":"I46*2/(C46*100)","v":18.433333333333334},{"$f":"I46*2/(D46*100)","v":18.433333333333334},"Oliver"]
["Custom 6-0-6",0.06,null,0.06,null,null,null,"med",38.69,12.896666666666667,null,{"$f":"I47*2/(D47*100)","v":12.896666666666667},"Oliver"]
["Pro-Start",0.02,0.03,0.03,null,null,null,"med/ rapid",20,20,{"$f":"I48*2/(C48*100)","v":13.333333333333334},{"$f":"I48*2/(D48*100)","v":13.333333333333334},"Oliver"]
["Pro-Booster",0.1,null,null,null,null,null,"med/ rapid",45.43,9.0860000000000003,null,null,"Oliver"]
["Pro-Gro",0.05,0.03,0.04,null,null,null,"med",31.6,12.64,{"$f":"I50*2/(C50*100)","v":21.066666666666666},{"$f":"I50*2/(D50*100)","v":15.8},"Oliver"]

{"sheet":"Cost per pound of Nutrients","index":18,"n_rows":56,"n_cols":12,"rows_kept":56,"cut":false,"hidden":true,"merged":[[53,0,53,7],[54,0,54,7]]}
["MATERIAL","% N","%P2 O5","%K20","%Ca","%Mg","%S","Relative Availability","Price per 50 lb (2015)","Price per pound of N","Price per pound of P","Price per pound of K"]
["Bagged Amendments"]
["Alfalfa meal",0.03,5.0000000000000001E-3,2.5000000000000001E-2,null,null,null,"Slow/ med",31,{"$f":"I3*2/3","v":20.666666666666668},{"$f":"62/0.5","v":124},{"$f":"62/2.5","v":24.8}]
["Ammonium Nitrate",0.34,null,null,null,null,null,"rapid",12,{"$f":"24/34","v":0.70588235294117652}]
["Ammonium Sulfate",0.21,null,null,null,null,0.23,"rapid"]
["Blood Meal",0.12,0.01,5.0000000000000001E-3,null,null,null,"med/ rapid",82,{"$f":"164/12","v":13.666666666666666},{"$f":"164/1","v":164},{"$f":"164/0.5","v":328}]
["Bone char",null,0.16,null,null,null,null,"med",16,null,{"$f":"32/16","v":2}]
["Bone Meal",0.03,0.15,null,null,null,null,"med",70,{"$f":"140/3","v":46.666666666666664},{"$f":"140/15","v":9.3333333333333339}]
["Calcitic Limestone",null,null,null,0.38,null,null,"med"]
["Calcium Nitrate",0.15,null,null,0.19,null,null,"rapid"]
["Chilean Nitrate**",0.16,null,null,null,null,null,"rapid",50,{"$f":"100/16","v":6.25}]
["Diammonium phosphate (DAP)",null,0.46,null,null,null,null,"rapid",{"$f":"473/40","v":11.824999999999999},null,{"$f":"11.83*2/46","v":0.51434782608695651}]
["Dolomitic Limestone",null,null,null,0.25,0.1,null,"med"]
["Elemental Sulfur",null,null,null,null,null,null,"?"]
["Epsom Salts",null,null,null,null,9.8000000000000004E-2,0.13,"rapid"]
["Feather meal",0.12,null,null,null,null,null,"med",50,{"$f":"100/12","v":8.3333333333333339}]
["Fish Emulsion",0.05,0.02,null,null,null,null,"rapid"]
["Fish Meal",0.09,7.0000000000000007E-2,null,null,null,null,null,90]
["Granite dust",null,null,0.06,null,0.11,0.22,"very slow",89]
["Greensand",null,0.01,7.0000000000000007E-2,null,null,null,"very slow",30]
["Gypsum",null,null,null,0.23,null,null,null,20]
["Peanut meal",0.08,0.01,0.02,null,null,null,"Slow/ med",31.5,{"$f":"63/8","v":7.875}]
["Pelletized chicken manure",0.03,1.4999999999999999E-2,1.4999999999999999E-2,7.0000000000000007E-2,0.01,0.05,"med/ rapid",12,{"$f":"24/3","v":8},{"$f":"24/2","v":12},{"$f":"24/2","v":12}]
["Potassium Choloride",null,null,0.6,null,null,null,"rapid",{"$f":"0.3*50","v":15},"="]
["Potassium Nitrate",null,null,null,null,null,null,"rapid"]
["Potassium Sulfate",null,null,0.5,null,null,0.17,"rapid",54,null,null,{"$f":"108/50","v":2.16}]
["Pro start",0.02,0.03,0.03,null,null,null,"med/ rapid",15.5,{"$f":"31/2","v":15.5}]
["Probooster",0.1,null,null,null,null,null,"med/ rapid",38,{"$f":"76/10","v":7.6}]
["Progro",0.05,0.03,0.04,null,null,null,"med",22,{"$f":"44/5","v":8.8000000000000007},{"$f":"44/3","v":14.666666666666666},{"$f":"44/4","v":11}]
["Rock phosphate",null,"30%***",null,null,null,null,"very slow",24]
["Sol-po-mag",null,null,0.22,null,0.11,0.22,"rapid",16,null,null,{"$f":"32/22","v":1.4545454545454546}]
["Soymeal",7.0000000000000007E-2,0.02,0.01,null,0.03,null,"slow/ med",17,{"$f":"34/7","v":4.8571428571428568}]
["Super phosphate",null,0.45,null,null,null,null,"rapid",3.5]
["Triple superphosphate",null,0.46,null,null,null,null,"rapid",9.5]
["Urea",0.46,null,null,null,null,null,"rapid",20,{"$f":"40/46","v":0.86956521739130432}]
[]
["Blended Fertilizers"]
["Cheep cheep",0.04,0.03,0.03,null,null,null,"med",22,{"$f":"44/4","v":11},{"$f":"44/3","v":14.666666666666666},{"$f":"44/3","v":14.666666666666666}]
["Custom 5-5-5",0.05,0.05,0.05,null,null,null,"med",25,{"$f":"50/5","v":10},{"$f":"50/5","v":10},{"$f":"50/5","v":10}]
["custom 6-0-6",0.06,null,0.06,null,null,null,"med",28,{"$f":"56/6","v":9.3333333333333339},null,{"$f":"56/6","v":9.3333333333333339}]
[]
[]
[]
["Bulk Materials"]
["Compost (mature)",0.01,0.01,0.01,null,null,null,"med"]
["Manure (fresh)",null,null,null,null,null,null,"med"]
["Dairy",5.0000000000000001E-3,2E-3,5.0000000000000001E-3,null,null,null,"med"]
["Horse",5.0000000000000001E-3,2E-3,5.0000000000000001E-3,null,null,null,"med"]
["Sheep",0.01,5.0000000000000001E-3,0.01]
[]
[]
[]
[]
["Blue shading indicates an organic material, but check with your certifying agency before using. "]
["**No more than 20% of a crop's annual N needs can be supplied by Chilean nitrate according to the NOP"]
["***about 2% available"]