{"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":"1904"}

{"sheet":"STEP 1--Field Information","index":0,"n_rows":67,"n_cols":6,"rows_kept":67,"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\"):",null,null,null,"Mixed Vegetable"]
[]
["Select previous cover crop on field from dropdown menu. If none, select \"No Cover Crop\".",null,null,null,"No Cover Crop"]
[]
["SIZE OF YOUR FIELD, BEDS, OR GROWING AREA:"]
["Enter the number of acres:",null,null,null,1,{"$f":"E13","v":1}]
["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":1}]
[]
["Blueberries - Establishment",null,"Alsike clover "]
["Blueberries - Maintenance",null,"Berseem clover"]
["Raspberries/Brambles -Establishment",null,"Buckwhat"]
["Raspberries/Brambles - Maintenance",null,"Field Peas"]
["Strawberries - Establishment",null,"Hairy vetch, mid summer incorp"]
["Strawberries - Maintenance",null,"Hairy vetch, spring incorp"]
["Mixed Vegetable",null,"Oat, leonard"]
["Asparagus - Establishment",null,"Other"]
["Asparagus - Maintenance",null,"Red clover, spring incorp"]
["Basil",null,"Red clover, mid summer incorp"]
["Beans: Dry/Snap/Lima",null,"Rye"]
["Beets, Swiss Chard",null,"Sudan grass"]
["Broccoli",null,"Sweet clover"]
["Cabbage, Cauliflower",null,"No Cover Crop"]
["Carrots, Parsnips"]
["Celery"]
["Collards"]
["Cucumbers, Melons"]
["Eggplant"]
["Garlic"]
["Leafy Greens"]
["Lettuce"]
["Muskmelon"]
["Okra"]
["Onions, Leeks"]
["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"]
["Other"]

{"sheet":"STEP 2--Soil Test Information","index":1,"n_rows":39,"n_cols":3,"rows_kept":39,"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)",null,"tons"]
["Nitrogen"]
["Phosphate"]
["Potash"]
[]
[]
[]
[]
[]
[]
["Under 2 ppm","Under 25 ppm"]
["2-3 ppm","25-49 ppm"]
["3-4 ppm","50-74 ppm"]
["4-6 ppm","75-99 ppm"]
["7-9 ppm","100-129 ppm"]
["10-13 ppm","130-159 ppm"]
["14-17 ppm","160-189 ppm"]
["18-20 ppm","190 ppm or more "]
["Over 20 ppm"]

{"sheet":"Veg rec lookup","index":2,"n_rows":112,"n_cols":10,"rows_kept":112,"cut":false,"hidden":true,"merged":[]}
["Crop","Under 2 ppm","2-3 ppm","3-4 ppm","4-6 ppm","7-9 ppm","10-13 ppm","14-17 ppm","18-20 ppm","Over 20 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,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 vegetable",200,100,100,80,40,0,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",150,125,100,50,50,25,0,0,0]
["Cabbage, Cauliflower",150,125,100,50,50,25,0,0,0]
["Carrots, Parsnips",150,125,100,50,50,25,0,0,0]
["Celery",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",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,150,125,75,50,25,0,0,0]
["Rhubarb - Maintenance",150,125,100,50,25,25,0,0,0]
["Spinach",180,150,120,60,30,30,0,0,0]
["Sweet Potato",300,250,200,100,50,30,0,0,0]
["Squash",150,125,100,50,50,25,0,0,0]
["Sweet Corn, Early",140,110,80,40,30,20,0,0,0]
["Sweet Corn, Full Season",140,110,80,40,30,20,0,0,0]
["Tomatoes",180,150,120,60,30,30,0,0,0]
["Rutabagas, Turnips",180,150,120,60,30,30,0,0,0]
["Watermelon",150,125,100,50,50,25,0,0,0]
["Other",200,100,100,80,40,0,0,0,0]
[]
["K"]
["Crop","Under 25 ppm","25-49 ppm","50-74 ppm","75-99 ppm","100-129 ppm","130-159 ppm","160-189 ppm","190 ppm or more "]
["Blueberries - Establishment",125,125,100,75,25,0,0,0]
["Blueberries - Maintenance",100,100,75,50,25,0,0,0]
["Cranberries - Establishment"]
["Cranberries - Maintenance"]
["Hops - Establishment",150,150,100,80,60,40,0,0]
["Hops - Maintenance",150,150,100,80,60,40,0,0]
["Raspberries/Brambles -Establishment",200,200,150,100,75,50,0,0]
["Raspberries/Brambles - Maintenance",175,175,125,100,75,50,0,0]
["Strawberries - Establishment",125,125,100,75,50,25,0,0]
["Strawberries - Maintenance",125,125,100,75,50,25,0,0]
["Home Vegetable (mixed)",0.5,0.5,0.25,0.25,0.1,0.1,0,0]
["Home Blueberries-Establishment",0.3,0.3,0.25,0.2,0.1]
["Home Blueberries-Maintenance",0.25,0.25,0.2,0.1,0.1]
["Home Brambles-Establishment",0.5,0.5,0.5,0.25,0.25,0.1,0,0]
["Home Brambles-Maintenance",0.5,0.5,0.5,0.25,0.25,0.1,0,0]
["Home Strawberries-Establishment",0.5,0.5,0.5,0.25,0.25,0.1,0,0]
["Home Strawberries-Maintenance",0.5,0.5,0.5,0.25,0.25,0.1,0,0]
["Mixed vegetable",200,200,100,100,40,40,0,0]
["Asparagus - Establishment",200,175,150,150,75,50,0,0]
["Asparagus - Maintenance",300,200,175,150,100,75,0,0]
["Basil",100,100,75,75,50,25]
["Beans: Dry/Snap/Lima",100,100,75,75,50,25,0,0]
["Beets, Swiss Chard",300,200,175,150,100,75,0,0]
["Broccoli",175,175,150,150,75,50,0,0]
["Cabbage, Cauliflower",175,175,150,150,75,50,0,0]
["Carrots, Parsnips",300,200,175,150,100,75,0,0]
["Celery",300,200,175,150,100,75,0,0]
["Collards",175,175,150,150,75,50,0,0]
["Cucumbers, Melons",180,140,120,100,70,30,0,0]
["Eggplant",150,125,100,75,50,50,0,0]
["Garlic",150,125,100,75,50,50,0,0]
["Leafy Greens",180,140,120,100,60,30,0,0]
["Lettuce",180,140,120,100,60,30,0,0]
["Muskmelon",180,140,120,100,60,30,0,0]
["Okra"]
["Onions, Leeks",175,175,150,150,75,50,0,0]
["Ornamental Corn",180,140,120,100,80,40,0,0]
["Ornamental Gourds",180,140,120,100,80,40,0,0]
["Peas",150,125,100,75,50,50,0,0]
["Peppers",200,175,150,100,50,50,0,0]
["Potatoes",300,200,175,150,100,75,0,0]
["Pumpkins",200,175,150,100,80,40,0,0]
["Radishes",125,125,100,100,50,50,0,0]
["Rhubarb - Establishment",200,150,125,75,50,25,0,0]
["Rhubarb - Maintenance",200,200,175,150,100,50,0,0]
["Spinach",180,140,120,100,60,30,0,0]
["Sweet Potato",300,250,200,150,100,50,0,0]
["Squash",200,175,150,100,80,40,0,0]
["Sweet Corn, Early",180,140,120,100,80,40,0,0]
["Sweet Corn, Full Season",180,140,120,100,80,40,0,0]
["Tomatoes",250,200,150,125,100,50,0,0]
["Rutabagas, Turnips",100,100,75,50,25,25,0,0]
["Watermelon",180,140,120,100,70,30,0,0]
["Other",200,200,100,100,40,40,0,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:B44,2,FALSE)","v":100},{"$f":"B3","v":100}]
["Phosphate recommendations (lbs/acre)",{"$f":"VLOOKUP('STEP 1--Field Information'!E8,'Veg rec lookup'!A1:J55, 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'!A58:I112,MATCH('STEP 2--Soil Test Information'!B6,'Veg rec lookup'!A58:I58,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":"No Cover Crop"},{"$f":"VLOOKUP('STEP 1--Field Information'!E10,'Crop look up'!D16:E29,2,FALSE)","v":0}]
["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":"C3-SUM(C6:C10)","v":100},{"$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":44,"n_cols":5,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[null,"N"]
["Blueberries - Establishment",0,null,"Rye",25]
["Blueberries - Maintenance",10,null,"Oat, leonard",10]
["Raspberries/Brambles -Establishment",0,null,"Hairy vetch, spring incorp",50]
["Raspberries/Brambles - Maintenance",75,null,"Hairy vetch, mid summer incorp",80]
["Strawberries - Establishment",50,null,"Red clover, spring incorp",50]
["Strawberries - Maintenance",50,null,"Red clover, mid summer incorp",{"$f":"AVERAGE(70,150)","v":110}]
["Mixed Vegetable",100,null,"Alsike clover",{"$f":"90","v":90}]
["Asparagus - Establishment",50,null,"Sweetclover",100]
["Asparagus - Maintenance",50,null,"Sudangrass",25]
["Basil",100,null,"Field Peas",{"$f":"AVERAGE(90,150)","v":120}]
["Beans: Dry/Snap/Lima",70,null,"buckwheat",10]
["Beets, Swiss Chard",100,null,"Berseem clover",150]
["Broccoli",100,null,"other","Enter estimated N In Cell to Right->"]
["Cabbage, Cauliflower",100]
["Carrots, Parsnips",100,null,"Alsike clover ",90]
["Celery",100,null,"Berseem clover",150]
["Collards",100,null,"Buckwhat",10]
["Cucumbers, Melons",100,null,"Field Peas",120]
["Eggplant",100,null,"Hairy vetch, mid summer incorp",80]
["Garlic",120,null,"Hairy vetch, spring incorp",50]
["Leafy Greens",70,null,"Oat, leonard",10]
["Lettuce",70,null,"Other","Enter estimated N in Cell to Right->"]
["Muskmelon",100,null,"Red clover, spring incorp",50]
["Okra",100,null,"Red clover, mid summer incorp",110]
["Onions, Leeks",100,null,"Rye",25]
["Ornamental Corn",100,null,"Sudan grass",25]
["Ornamental Gourds",100,null,"Sweet clover",100]
["Peas",70,null,"No cover crop",0]
["Peppers",100]
["Potatoes",120]
["Pumpkins",100]
["Radishes",50]
["Rhubarb - Establishment",50]
["Rhubarb - Maintenance",50]
["Spinach",100]
["Sweet Potato",50]
["Squash",100]
["Sweet Corn, Early",100]
["Sweet Corn, Full Season",100]
["Tomatoes",100]
["Rutabagas, Turnips",50]
["Watermelon",100]
["Other",100]

{"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---->"]
["Based on your nutrient calculations, you should apply",null,{"$f":"'STEP 3--Nutrient Needs'!C11","v":100},"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":30},{"$f":"'N lookup'!J2","v":20}]
[{"$f":"'N lookup'!A3","v":"Ammonium sulfate"},{"$f":"'N lookup'!B3","v":0.21},{"$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.23},{"$f":"'N lookup'!H3","v":"rapid"},{"$f":"'N lookup'!I3","v":10.7},{"$f":"'N lookup'!J3","v":1.019047619047619}]
[{"$f":"'N lookup'!A4","v":"Blood meal"},{"$f":"'N lookup'!B4","v":0.12},{"$f":"'N lookup'!C4","v":0.01},{"$f":"'N lookup'!D4","v":5.0000000000000001E-3},{"$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":68},{"$f":"'N lookup'!J4","v":11.333333333333334}]
[{"$f":"'N lookup'!A5","v":"Bone meal"},{"$f":"'N lookup'!B5","v":0.03},{"$f":"'N lookup'!C5","v":0.2},{"$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":"med"},{"$f":"'N lookup'!I5","v":39},{"$f":"'N lookup'!J5","v":26}]
[{"$f":"'N lookup'!A6","v":"Calcium nitrate"},{"$f":"'N lookup'!B6","v":0.15},{"$f":"'N lookup'!C6","v":0},{"$f":"'N lookup'!D6","v":0},{"$f":"'N lookup'!E6","v":0.19},{"$f":"'N lookup'!F6","v":0},{"$f":"'N lookup'!G6","v":0},{"$f":"'N lookup'!H6","v":"rapid"},{"$f":"'N lookup'!I6","v":21.85},{"$f":"'N lookup'!J6","v":2.9133333333333336}]
[{"$f":"'N lookup'!A7","v":"Chilean nitrate"},{"$f":"'N lookup'!B7","v":0.15},{"$f":"'N lookup'!C7","v":0},{"$f":"'N lookup'!D7","v":0.02},{"$f":"'N lookup'!E7","v":0},{"$f":"'N lookup'!F7","v":0},{"$f":"'N lookup'!G7","v":0},{"$f":"'N lookup'!H7","v":"rapid"},{"$f":"'N lookup'!I7","v":45},{"$f":"'N lookup'!J7","v":6}]
[{"$f":"'N lookup'!A8","v":"Dehydrated Poultry Manure (Kreher's or other)"},{"$f":"'N lookup'!B8","v":0.05},{"$f":"'N lookup'!C8","v":0.04},{"$f":"'N lookup'!D8","v":0.03},{"$f":"'N lookup'!E8","v":0.09},{"$f":"'N lookup'!F8","v":0},{"$f":"'N lookup'!G8","v":0},{"$f":"'N lookup'!H8","v":"med"},{"$f":"'N lookup'!I8","v":15},{"$f":"'N lookup'!J8","v":6}]
[{"$f":"'N lookup'!A9","v":"Dehydrated High-K Blend Poultry Manure (Kreher's or other)"},{"$f":"'N lookup'!B9","v":0.04},{"$f":"'N lookup'!C9","v":0.03},{"$f":"'N lookup'!D9","v":0.1},{"$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":15},{"$f":"'N lookup'!J9","v":7.5}]
[{"$f":"'N lookup'!A10","v":"Feather meal"},{"$f":"'N lookup'!B10","v":0.12},{"$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":50},{"$f":"'N lookup'!J10","v":8.3333333333333339}]
[{"$f":"'N lookup'!A11","v":"Fish emulsion"},{"$f":"'N lookup'!B11","v":0.05},{"$f":"'N lookup'!C11","v":0.02},{"$f":"'N lookup'!D11","v":0},{"$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":0},{"$f":"'N lookup'!J11","v":0}]
[{"$f":"'N lookup'!A12","v":"Fish meal"},{"$f":"'N lookup'!B12","v":0.09},{"$f":"'N lookup'!C12","v":7.0000000000000007E-2},{"$f":"'N lookup'!D12","v":0},{"$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":90},{"$f":"'N lookup'!J12","v":20}]
[{"$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":2.5},{"$f":"'N lookup'!J13","v":2.5}]
[{"$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":"Naturesafe"},{"$f":"'N lookup'!B15","v":0.13},{"$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":"med"},{"$f":"'N lookup'!I15","v":36.25},{"$f":"'N lookup'!J15","v":5.5769230769230766}]
[{"$f":"'N lookup'!A16","v":"Peanut meal"},{"$f":"'N lookup'!B16","v":0.08},{"$f":"'N lookup'!C16","v":0.01},{"$f":"'N lookup'!D16","v":0.02},{"$f":"'N lookup'!E16","v":0},{"$f":"'N lookup'!F16","v":0},{"$f":"'N lookup'!G16","v":0},{"$f":"'N lookup'!H16","v":"slow/ med"},{"$f":"'N lookup'!I16","v":37},{"$f":"'N lookup'!J16","v":9.25}]
[{"$f":"'N lookup'!A17","v":"Soybean meal"},{"$f":"'N lookup'!B17","v":7.0000000000000007E-2},{"$f":"'N lookup'!C17","v":0.02},{"$f":"'N lookup'!D17","v":0.01},{"$f":"'N lookup'!E17","v":0},{"$f":"'N lookup'!F17","v":0.03},{"$f":"'N lookup'!G17","v":0},{"$f":"'N lookup'!H17","v":"slow/ med"},{"$f":"'N lookup'!I17","v":17},{"$f":"'N lookup'!J17","v":4.8571428571428568}]
[{"$f":"'N lookup'!A18","v":"Urea"},{"$f":"'N lookup'!B18","v":0.46},{"$f":"'N lookup'!C18","v":0},{"$f":"'N lookup'!D18","v":0},{"$f":"'N lookup'!E18","v":0},{"$f":"'N lookup'!F18","v":0},{"$f":"'N lookup'!G18","v":0},{"$f":"'N lookup'!H18","v":"rapid"},{"$f":"'N lookup'!I18","v":20},{"$f":"'N lookup'!J18","v":0.86956521739130432}]
["Blended Fertilizers"]
[{"$f":"'N lookup'!A19","v":"Cheep Cheep"},{"$f":"'N lookup'!B19","v":0.04},{"$f":"'N lookup'!C19","v":0.03},{"$f":"'N lookup'!D19","v":0.03},{"$f":"'N lookup'!E19","v":0},{"$f":"'N lookup'!F19","v":0},{"$f":"'N lookup'!G19","v":0},{"$f":"'N lookup'!H19","v":"med"},{"$f":"'N lookup'!I19","v":20.5},{"$f":"'N lookup'!J19","v":10.25}]
[{"$f":"'N lookup'!A20","v":"Custom 5-5-5"},{"$f":"'N lookup'!B20","v":0.05},{"$f":"'N lookup'!C20","v":0.05},{"$f":"'N lookup'!D20","v":0.05},{"$f":"'N lookup'!E20","v":0},{"$f":"'N lookup'!F20","v":0},{"$f":"'N lookup'!G20","v":0},{"$f":"'N lookup'!H20","v":"med"},{"$f":"'N lookup'!I20","v":27},{"$f":"'N lookup'!J20","v":10.8}]
[{"$f":"'N lookup'!A21","v":"Custom 6-0-6"},{"$f":"'N lookup'!B21","v":0.06},{"$f":"'N lookup'!C21","v":0},{"$f":"'N lookup'!D21","v":0.06},{"$f":"'N lookup'!E21","v":0},{"$f":"'N lookup'!F21","v":0},{"$f":"'N lookup'!G21","v":0},{"$f":"'N lookup'!H21","v":"med"},{"$f":"'N lookup'!I21","v":28.5},{"$f":"'N lookup'!J21","v":9.5}]
[{"$f":"'N lookup'!A22","v":"Pro-Start"},{"$f":"'N lookup'!B22","v":0.02},{"$f":"'N lookup'!C22","v":0.03},{"$f":"'N lookup'!D22","v":0.03},{"$f":"'N lookup'!E22","v":0},{"$f":"'N lookup'!F22","v":0},{"$f":"'N lookup'!G22","v":0},{"$f":"'N lookup'!H22","v":"med/ rapid"},{"$f":"'N lookup'!I22","v":17},{"$f":"'N lookup'!J22","v":17}]
[{"$f":"'N lookup'!A23","v":"Pro-Booster"},{"$f":"'N lookup'!B23","v":0.1},{"$f":"'N lookup'!C23","v":0},{"$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":"med/ rapid"},{"$f":"'N lookup'!I23","v":32},{"$f":"'N lookup'!J23","v":6.4}]
[{"$f":"'N lookup'!A24","v":"Pro-Gro"},{"$f":"'N lookup'!B24","v":0.05},{"$f":"'N lookup'!C24","v":0.03},{"$f":"'N lookup'!D24","v":0.04},{"$f":"'N lookup'!E24","v":0},{"$f":"'N lookup'!F24","v":0},{"$f":"'N lookup'!G24","v":0},{"$f":"'N lookup'!H24","v":"med"},{"$f":"'N lookup'!I24","v":22.5},{"$f":"'N lookup'!J24","v":9}]
["NONE NEEDED",0,0,0,0,0,0,null,0,0]
["OTHER--enter Name in this cell, analysis and price to right-->",0.08,0.02,0.02,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":30},{"$f":"'Appendix--Fertilizer Costs'!J2","v":20},{"$f":"('STEP 3--Nutrient Needs'!C11/B2)/R2","v":5555.5555555555557},{"$f":"K2*C2","v":27.777777777777779},{"$f":"K2*D2","v":138.88888888888889},null,null,null,{"$f":"K2*J2*B2","v":3333.333333333333},0.6]
[{"$f":"'Appendix--Fertilizer Costs'!A3","v":"Ammonium sulfate"},{"$f":"'Appendix--Fertilizer Costs'!B3","v":0.21},{"$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.23},{"$f":"'Appendix--Fertilizer Costs'!H3","v":"rapid"},{"$f":"'Appendix--Fertilizer Costs'!I3","v":10.7},{"$f":"'Appendix--Fertilizer Costs'!J3","v":1.019047619047619},{"$f":"('STEP 3--Nutrient Needs'!C11/B3)/R3","v":476.1904761904762},null,null,null,null,{"$f":"G3*K3","v":109.52380952380953},{"$f":"K3*B3*J3","v":101.9047619047619},1]
[{"$f":"'Appendix--Fertilizer Costs'!A4","v":"Blood meal"},{"$f":"'Appendix--Fertilizer Costs'!B4","v":0.12},{"$f":"'Appendix--Fertilizer Costs'!C4","v":0.01},{"$f":"'Appendix--Fertilizer Costs'!D4","v":5.0000000000000001E-3},{"$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":68},{"$f":"'Appendix--Fertilizer Costs'!J4","v":11.333333333333334},{"$f":"('STEP 3--Nutrient Needs'!C11/B4)/R4","v":1366.1202185792351},{"$f":"K4*C4","v":13.661202185792352},{"$f":"K4*D4","v":6.8306010928961758},null,null,null,1857.9234972677598,0.61]
[{"$f":"'Appendix--Fertilizer Costs'!A6","v":"Bone meal"},{"$f":"'Appendix--Fertilizer Costs'!B6","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!C6","v":0.2},{"$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":"med"},{"$f":"'Appendix--Fertilizer Costs'!I6","v":39},{"$f":"'Appendix--Fertilizer Costs'!J6","v":26},{"$f":"('STEP 3--Nutrient Needs'!C11/B5)/R5","v":10416.666666666666},{"$f":"K5*C5","v":2083.3333333333335},0,null,null,null,8124.9999999999982,0.32]
[{"$f":"'Appendix--Fertilizer Costs'!A8","v":"Calcium nitrate"},{"$f":"'Appendix--Fertilizer Costs'!B8","v":0.15},{"$f":"'Appendix--Fertilizer Costs'!C8","v":0},{"$f":"'Appendix--Fertilizer Costs'!D8","v":0},{"$f":"'Appendix--Fertilizer Costs'!E8","v":0.19},{"$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":21.85},{"$f":"'Appendix--Fertilizer Costs'!J8","v":2.9133333333333336},{"$f":"('STEP 3--Nutrient Needs'!C11/B6)/R6","v":666.66666666666674},null,null,{"$f":"K6*E6","v":126.66666666666669},null,null,291.33333333333337,1]
[{"$f":"'Appendix--Fertilizer Costs'!A9","v":"Chilean nitrate"},{"$f":"'Appendix--Fertilizer Costs'!B9","v":0.15},{"$f":"'Appendix--Fertilizer Costs'!C9","v":0},{"$f":"'Appendix--Fertilizer Costs'!D9","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!E9","v":0},{"$f":"'Appendix--Fertilizer Costs'!F9","v":0},{"$f":"'Appendix--Fertilizer Costs'!G9","v":0},{"$f":"'Appendix--Fertilizer Costs'!H9","v":"rapid"},{"$f":"'Appendix--Fertilizer Costs'!I9","v":45},{"$f":"'Appendix--Fertilizer Costs'!J9","v":6},{"$f":"('STEP 3--Nutrient Needs'!C11/B7)/R7","v":666.66666666666674},null,null,null,null,null,600.00000000000011,1]
[{"$f":"'Appendix--Fertilizer Costs'!A10","v":"Dehydrated Poultry Manure (Kreher's or other)"},{"$f":"'Appendix--Fertilizer Costs'!B10","v":0.05},{"$f":"'Appendix--Fertilizer Costs'!C10","v":0.04},{"$f":"'Appendix--Fertilizer Costs'!D10","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!E10","v":0.09},{"$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":15},{"$f":"'Appendix--Fertilizer Costs'!J10","v":6},{"$f":"('STEP 3--Nutrient Needs'!C11/B8)/R8","v":3333.3333333333335},{"$f":"K8*C8","v":133.33333333333334},{"$f":"K8*D8","v":100},{"$f":"K8*E8","v":300},{"$f":"F8*K8","v":0},{"$f":"G8*K8","v":0},1000.0000000000001,0.6]
[{"$f":"'Appendix--Fertilizer Costs'!A11","v":"Dehydrated High-K Blend Poultry Manure (Kreher's or other)"},{"$f":"'Appendix--Fertilizer Costs'!B11","v":0.04},{"$f":"'Appendix--Fertilizer Costs'!C11","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!D11","v":0.1},{"$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":15},{"$f":"'Appendix--Fertilizer Costs'!J11","v":7.5},{"$f":"('STEP 3--Nutrient Needs'!C11/B9)/R9","v":4166.666666666667},{"$f":"K9*C9","v":125},{"$f":"K9*D9","v":416.66666666666674},{"$f":"K9*E9","v":0},{"$f":"F9*K9","v":0},{"$f":"G9*K9","v":0},1250.0000000000002,0.6]
[{"$f":"'Appendix--Fertilizer Costs'!A16","v":"Feather meal"},{"$f":"'Appendix--Fertilizer Costs'!B16","v":0.12},{"$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":50},{"$f":"'Appendix--Fertilizer Costs'!J16","v":8.3333333333333339},{"$f":"('STEP 3--Nutrient Needs'!C11/B10)/R10","v":1282.051282051282},null,null,null,null,null,1282.051282051282,0.65]
[{"$f":"'Appendix--Fertilizer Costs'!A17","v":"Fish emulsion"},{"$f":"'Appendix--Fertilizer Costs'!B17","v":0.05},{"$f":"'Appendix--Fertilizer Costs'!C17","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!D17","v":0},{"$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":0},{"$f":"'Appendix--Fertilizer Costs'!J17","v":0},{"$f":"('STEP 3--Nutrient Needs'!C11/B11)/R11","v":2000},{"$f":"K11*C11","v":40},null,null,null,null,0,1]
[{"$f":"'Appendix--Fertilizer Costs'!A18","v":"Fish meal"},{"$f":"'Appendix--Fertilizer Costs'!B18","v":0.09},{"$f":"'Appendix--Fertilizer Costs'!C18","v":7.0000000000000007E-2},{"$f":"'Appendix--Fertilizer Costs'!D18","v":0},{"$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":90},{"$f":"'Appendix--Fertilizer Costs'!J18","v":20},{"$f":"('STEP 3--Nutrient Needs'!C11/B12)/R12","v":1709.4017094017092},119.65811965811966,null,null,null,null,3076.9230769230767,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":2.5},{"$f":"'Appendix--Fertilizer Costs'!J19","v":2.5},{"$f":"('STEP 3--Nutrient Needs'!C11/B13)/R13","v":8333.3333333333339},250,{"$f":"K13*D13","v":125},{"$f":"K13*E13","v":583.33333333333348},{"$f":"F13*K13","v":83.333333333333343},{"$f":"G13*K13","v":416.66666666666674},416.66666666666674,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":4166.666666666667},125,83.333333333333343,{"$f":"K14*E14","v":0},{"$f":"F14*K14","v":0},{"$f":"G14*K14","v":0},{"$f":"K14*B14*J14","v":691.66666666666686},0.6]
[{"$f":"'Appendix--Fertilizer Costs'!A26","v":"Naturesafe"},{"$f":"'Appendix--Fertilizer Costs'!B26","v":0.13},{"$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":"med"},{"$f":"'Appendix--Fertilizer Costs'!I26","v":36.25},{"$f":"'Appendix--Fertilizer Costs'!J26","v":5.5769230769230766},{"$f":"('STEP 3--Nutrient Needs'!C11/B15)/R15","v":1098.901098901099},0,0,0,null,null,{"$f":"K15*B15*J15","v":796.7032967032967},0.7]
[{"$f":"'Appendix--Fertilizer Costs'!A27","v":"Peanut meal"},{"$f":"'Appendix--Fertilizer Costs'!B27","v":0.08},{"$f":"'Appendix--Fertilizer Costs'!C27","v":0.01},{"$f":"'Appendix--Fertilizer Costs'!D27","v":0.02},{"$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":"slow/ med"},{"$f":"'Appendix--Fertilizer Costs'!I27","v":37},{"$f":"'Appendix--Fertilizer Costs'!J27","v":9.25},{"$f":"('STEP 3--Nutrient Needs'!C11/B16)/R16","v":2083.3333333333335},{"$f":"K16*C16","v":20.833333333333336},{"$f":"K16*D16","v":41.666666666666671},null,null,null,1541.6666666666667,0.6]
[{"$f":"'Appendix--Fertilizer Costs'!A31","v":"Soybean meal"},{"$f":"'Appendix--Fertilizer Costs'!B31","v":7.0000000000000007E-2},{"$f":"'Appendix--Fertilizer Costs'!C31","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!D31","v":0.01},{"$f":"'Appendix--Fertilizer Costs'!E31","v":0},{"$f":"'Appendix--Fertilizer Costs'!F31","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!G31","v":0},{"$f":"'Appendix--Fertilizer Costs'!H31","v":"slow/ med"},{"$f":"'Appendix--Fertilizer Costs'!I31","v":17},{"$f":"'Appendix--Fertilizer Costs'!J31","v":4.8571428571428568},{"$f":"('STEP 3--Nutrient Needs'!C11/B17)/R17","v":1904.7619047619046},38.095238095238095,19.047619047619047,{"$f":"K17*E17","v":0},{"$f":"F17*K17","v":57.142857142857139},{"$f":"G17*K17","v":0},647.61904761904759,0.75]
[{"$f":"'Appendix--Fertilizer Costs'!A34","v":"Urea"},{"$f":"'Appendix--Fertilizer Costs'!B34","v":0.46},{"$f":"'Appendix--Fertilizer Costs'!C34","v":0},{"$f":"'Appendix--Fertilizer Costs'!D34","v":0},{"$f":"'Appendix--Fertilizer Costs'!E34","v":0},{"$f":"'Appendix--Fertilizer Costs'!F34","v":0},{"$f":"'Appendix--Fertilizer Costs'!G34","v":0},{"$f":"'Appendix--Fertilizer Costs'!H34","v":"rapid"},{"$f":"'Appendix--Fertilizer Costs'!I34","v":20},{"$f":"'Appendix--Fertilizer Costs'!J34","v":0.86956521739130432},{"$f":"('STEP 3--Nutrient Needs'!C11/B18)/R18","v":217.39130434782606},0,0,null,{"$f":"F18*K18","v":0},null,86.956521739130437,1]
[{"$f":"'Appendix--Fertilizer Costs'!A37","v":"Cheep Cheep"},{"$f":"'Appendix--Fertilizer Costs'!B37","v":0.04},{"$f":"'Appendix--Fertilizer Costs'!C37","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!D37","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!E37","v":0},{"$f":"'Appendix--Fertilizer Costs'!F37","v":0},{"$f":"'Appendix--Fertilizer Costs'!G37","v":0},{"$f":"'Appendix--Fertilizer Costs'!H37","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I37","v":20.5},{"$f":"'Appendix--Fertilizer Costs'!J37","v":10.25},{"$f":"('STEP 3--Nutrient Needs'!C11/B19)/R19","v":3846.1538461538462},115.38461538461539,115.38461538461539,null,null,null,1576.9230769230769,0.65]
[{"$f":"'Appendix--Fertilizer Costs'!A38","v":"Custom 5-5-5"},{"$f":"'Appendix--Fertilizer Costs'!B38","v":0.05},{"$f":"'Appendix--Fertilizer Costs'!C38","v":0.05},{"$f":"'Appendix--Fertilizer Costs'!D38","v":0.05},{"$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":"med"},{"$f":"'Appendix--Fertilizer Costs'!I38","v":27},{"$f":"'Appendix--Fertilizer Costs'!J38","v":10.8},{"$f":"('STEP 3--Nutrient Needs'!C11/B20)/R20","v":3076.9230769230767},153.84615384615384,153.84615384615384,null,null,null,1661.5384615384617,0.65]
[{"$f":"'Appendix--Fertilizer Costs'!A39","v":"Custom 6-0-6"},{"$f":"'Appendix--Fertilizer Costs'!B39","v":0.06},{"$f":"'Appendix--Fertilizer Costs'!C39","v":0},{"$f":"'Appendix--Fertilizer Costs'!D39","v":0.06},{"$f":"'Appendix--Fertilizer Costs'!E39","v":0},{"$f":"'Appendix--Fertilizer Costs'!F39","v":0},{"$f":"'Appendix--Fertilizer Costs'!G39","v":0},{"$f":"'Appendix--Fertilizer Costs'!H39","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I39","v":28.5},{"$f":"'Appendix--Fertilizer Costs'!J39","v":9.5},{"$f":"('STEP 3--Nutrient Needs'!C11/B21)/R21","v":2564.102564102564},0,153.84615384615384,null,null,null,1461.5384615384614,0.65]
[{"$f":"'Appendix--Fertilizer Costs'!A40","v":"Pro-Start"},{"$f":"'Appendix--Fertilizer Costs'!B40","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!C40","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!D40","v":0.03},{"$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":"med/ rapid"},{"$f":"'Appendix--Fertilizer Costs'!I40","v":17},{"$f":"'Appendix--Fertilizer Costs'!J40","v":17},{"$f":"('STEP 3--Nutrient Needs'!C11/B22)/R22","v":7692.3076923076924},230.76923076923077,230.76923076923077,null,null,null,2615.3846153846152,0.65]
[{"$f":"'Appendix--Fertilizer Costs'!A41","v":"Pro-Booster"},{"$f":"'Appendix--Fertilizer Costs'!B41","v":0.1},{"$f":"'Appendix--Fertilizer Costs'!C41","v":0},{"$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":"med/ rapid"},{"$f":"'Appendix--Fertilizer Costs'!I41","v":32},{"$f":"'Appendix--Fertilizer Costs'!J41","v":6.4},{"$f":"('STEP 3--Nutrient Needs'!C11/B23)/R23","v":1250},0,0,null,null,null,800,0.8]
[{"$f":"'Appendix--Fertilizer Costs'!A42","v":"Pro-Gro"},{"$f":"'Appendix--Fertilizer Costs'!B42","v":0.05},{"$f":"'Appendix--Fertilizer Costs'!C42","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!D42","v":0.04},{"$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":"med"},{"$f":"'Appendix--Fertilizer Costs'!I42","v":22.5},{"$f":"'Appendix--Fertilizer Costs'!J42","v":9},{"$f":"('STEP 3--Nutrient Needs'!C11/B24)/R24","v":2500},75,100,null,null,null,1125,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":"OTHER--enter Name in this cell, analysis and price to right-->"},{"$f":"'STEP 4--Choose N'!B32","v":0.08},{"$f":"'STEP 4--Choose N'!C32","v":0.02},{"$f":"'STEP 4--Choose N'!D32","v":0.02},{"$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":1785.7142857142858},{"$f":"K26*C26","v":35.714285714285715},{"$f":"K26*D26","v":35.714285714285715},null,null,null,{"$f":"K26*B26*J26","v":0},0.7]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'STEP 4--Choose N'!B32","v":0.08},{"$f":"'STEP 4--Choose N'!C32","v":0.02},{"$f":"'STEP 4--Choose N'!D32","v":0.02},{"$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":1923.0769230769231},{"$f":"K47*C47","v":38.46153846153846},{"$f":"K47*D47","v":38.46153846153846},null,null,null,{"$f":"K47*B47*J47","v":0},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 char"},{"$f":"'Appendix--Fertilizer Costs'!B5","v":0},{"$f":"'Appendix--Fertilizer Costs'!C5","v":0.16},{"$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":34},{"$f":"'Appendix--Fertilizer Costs'!K5","v":4.25}]
[{"$f":"'Appendix--Fertilizer Costs'!A6","v":"Bone meal"},{"$f":"'Appendix--Fertilizer Costs'!B6","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!C6","v":0.2},{"$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":"med"},{"$f":"'Appendix--Fertilizer Costs'!I6","v":39},{"$f":"'Appendix--Fertilizer Costs'!K6","v":3.9}]
[{"$f":"'Appendix--Fertilizer Costs'!A10","v":"Dehydrated Poultry Manure (Kreher's or other)"},{"$f":"'Appendix--Fertilizer Costs'!B10","v":0.05},{"$f":"'Appendix--Fertilizer Costs'!C10","v":0.04},{"$f":"'Appendix--Fertilizer Costs'!D10","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!E10","v":0.09},{"$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":15},{"$f":"'Appendix--Fertilizer Costs'!K10","v":7.5}]
[{"$f":"'Appendix--Fertilizer Costs'!A11","v":"Dehydrated High-K Blend Poultry Manure (Kreher's or other)"},{"$f":"'Appendix--Fertilizer Costs'!B11","v":0.04},{"$f":"'Appendix--Fertilizer Costs'!C11","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!D11","v":0.1},{"$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":15},{"$f":"'Appendix--Fertilizer Costs'!K11","v":10}]
[{"$f":"'Appendix--Fertilizer Costs'!A12","v":"Diammonium phosphate"},{"$f":"'Appendix--Fertilizer Costs'!B12","v":0},{"$f":"'Appendix--Fertilizer Costs'!C12","v":0.46},{"$f":"'Appendix--Fertilizer Costs'!D12","v":0},{"$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":"rapid"},{"$f":"'Appendix--Fertilizer Costs'!I12","v":11.824999999999999},{"$f":"'Appendix--Fertilizer Costs'!K12","v":0.51413043478260867}]
[{"$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":2.5},{"$f":"'Appendix--Fertilizer Costs'!K19","v":1.6666666666666667}]
[{"$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":"Rock phosphate"},{"$f":"'Appendix--Fertilizer Costs'!B30","v":0},{"$f":"'Appendix--Fertilizer Costs'!C30","v":0.05},{"$f":"'Appendix--Fertilizer Costs'!D30","v":0},{"$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":"very slow"},{"$f":"'Appendix--Fertilizer Costs'!I30","v":24},{"$f":"'Appendix--Fertilizer Costs'!K30","v":9.6}]
[{"$f":"'Appendix--Fertilizer Costs'!A33","v":"Triple super phosphate"},{"$f":"'Appendix--Fertilizer Costs'!B33","v":0},{"$f":"'Appendix--Fertilizer Costs'!C33","v":0.46},{"$f":"'Appendix--Fertilizer Costs'!D33","v":0},{"$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":21},{"$f":"'Appendix--Fertilizer Costs'!K33","v":0.91304347826086951}]
[{"$f":"'Appendix--Fertilizer Costs'!A36","v":"Blended fertilizers"}]
[{"$f":"'Appendix--Fertilizer Costs'!A37","v":"Cheep Cheep"},{"$f":"'Appendix--Fertilizer Costs'!B37","v":0.04},{"$f":"'Appendix--Fertilizer Costs'!C37","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!D37","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!E37","v":0},{"$f":"'Appendix--Fertilizer Costs'!F37","v":0},{"$f":"'Appendix--Fertilizer Costs'!G37","v":0},{"$f":"'Appendix--Fertilizer Costs'!H37","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I37","v":20.5},{"$f":"'Appendix--Fertilizer Costs'!K37","v":13.666666666666666}]
[{"$f":"'Appendix--Fertilizer Costs'!A38","v":"Custom 5-5-5"},{"$f":"'Appendix--Fertilizer Costs'!B38","v":0.05},{"$f":"'Appendix--Fertilizer Costs'!C38","v":0.05},{"$f":"'Appendix--Fertilizer Costs'!D38","v":0.05},{"$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":"med"},{"$f":"'Appendix--Fertilizer Costs'!I38","v":27},{"$f":"'Appendix--Fertilizer Costs'!K38","v":10.8}]
[{"$f":"'Appendix--Fertilizer Costs'!A40","v":"Pro-Start"},{"$f":"'Appendix--Fertilizer Costs'!B40","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!C40","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!D40","v":0.03},{"$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":"med/ rapid"},{"$f":"'Appendix--Fertilizer Costs'!I40","v":17},{"$f":"'Appendix--Fertilizer Costs'!K40","v":11.333333333333334}]
[{"$f":"'Appendix--Fertilizer Costs'!A42","v":"Pro-Gro"},{"$f":"'Appendix--Fertilizer Costs'!B42","v":0.05},{"$f":"'Appendix--Fertilizer Costs'!C42","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!D42","v":0.04},{"$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":"med"},{"$f":"'Appendix--Fertilizer Costs'!I42","v":22.5},{"$f":"'Appendix--Fertilizer Costs'!K42","v":15}]
["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 char"},null,0.16,null,null,null,null,"med",{"$f":"'STEP 5--Choose P'!I8","v":34},{"$f":"I2*2/(C2*100)","v":4.25},{"$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 meal"},0.03,0.22,null,null,null,null,"med",{"$f":"'STEP 5--Choose P'!I9","v":39},{"$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 or other)"},{"$f":"'STEP 5--Choose P'!B10","v":0.05},{"$f":"'STEP 5--Choose P'!C10","v":0.04},{"$f":"'STEP 5--Choose P'!D10","v":0.03},{"$f":"'STEP 5--Choose P'!E10","v":0.09},{"$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":15},{"$f":"'STEP 5--Choose P'!J10","v":7.5},{"$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 High-K Blend Poultry Manure (Kreher's or other)"},{"$f":"'STEP 5--Choose P'!B11","v":0.04},{"$f":"'STEP 5--Choose P'!C11","v":0.03},{"$f":"'STEP 5--Choose P'!D11","v":0.1},{"$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":15},{"$f":"'STEP 5--Choose P'!J11","v":10},{"$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":"Diammonium phosphate"},{"$f":"'STEP 5--Choose P'!B12","v":0},{"$f":"'STEP 5--Choose P'!C12","v":0.46},{"$f":"'STEP 5--Choose P'!D12","v":0},{"$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":"rapid"},{"$f":"'STEP 5--Choose P'!I12","v":11.824999999999999},{"$f":"'STEP 5--Choose P'!J12","v":0.51413043478260867},{"$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":2.5},{"$f":"'STEP 5--Choose P'!J13","v":1.6666666666666667},{"$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":"Rock phosphate"},{"$f":"'STEP 5--Choose P'!B15","v":0},{"$f":"'STEP 5--Choose P'!C15","v":0.05},{"$f":"'STEP 5--Choose P'!D15","v":0},{"$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":"very slow"},{"$f":"'STEP 5--Choose P'!I15","v":24},{"$f":"'STEP 5--Choose P'!J15","v":9.6},{"$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":"Triple super phosphate"},{"$f":"'STEP 5--Choose P'!B16","v":0},{"$f":"'STEP 5--Choose P'!C16","v":0.46},{"$f":"'STEP 5--Choose P'!D16","v":0},{"$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":21},{"$f":"'STEP 5--Choose P'!J16","v":0.91304347826086951},{"$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":"Blended fertilizers"},null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[{"$f":"'STEP 5--Choose P'!A18","v":"Cheep Cheep"},{"$f":"'STEP 5--Choose P'!B18","v":0.04},{"$f":"'STEP 5--Choose P'!C18","v":0.03},{"$f":"'STEP 5--Choose P'!D18","v":0.03},{"$f":"'STEP 5--Choose P'!E18","v":0},{"$f":"'STEP 5--Choose P'!F18","v":0},{"$f":"'STEP 5--Choose P'!G18","v":0},{"$f":"'STEP 5--Choose P'!H18","v":"med"},{"$f":"'STEP 5--Choose P'!I18","v":20.5},{"$f":"'STEP 5--Choose P'!J18","v":13.666666666666666},{"$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":"Custom 5-5-5"},{"$f":"'STEP 5--Choose P'!B19","v":0.05},{"$f":"'STEP 5--Choose P'!C19","v":0.05},{"$f":"'STEP 5--Choose P'!D19","v":0.05},{"$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":"med"},{"$f":"'STEP 5--Choose P'!I19","v":27},{"$f":"'STEP 5--Choose P'!J19","v":10.8},{"$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":"Pro-Start"},{"$f":"'STEP 5--Choose P'!B20","v":0.02},{"$f":"'STEP 5--Choose P'!C20","v":0.03},{"$f":"'STEP 5--Choose P'!D20","v":0.03},{"$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":"med/ rapid"},{"$f":"'STEP 5--Choose P'!I20","v":17},{"$f":"'STEP 5--Choose P'!J20","v":11.333333333333334},{"$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":"Pro-Gro"},{"$f":"'STEP 5--Choose P'!B21","v":0.05},{"$f":"'STEP 5--Choose P'!C21","v":0.03},{"$f":"'STEP 5--Choose P'!D21","v":0.04},{"$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":"med"},{"$f":"'STEP 5--Choose P'!I21","v":22.5},{"$f":"'STEP 5--Choose P'!J21","v":15},{"$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,"NONE NEEDED"]
["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 or other)"},{"$f":"'Appendix--Fertilizer Costs'!B10","v":0.05},{"$f":"'Appendix--Fertilizer Costs'!C10","v":0.04},{"$f":"'Appendix--Fertilizer Costs'!D10","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!E10","v":0.09},{"$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":15},{"$f":"'Appendix--Fertilizer Costs'!L10","v":10}]
[{"$f":"'Appendix--Fertilizer Costs'!A11","v":"Dehydrated High-K Blend Poultry Manure (Kreher's or other)"},{"$f":"'Appendix--Fertilizer Costs'!B11","v":0.04},{"$f":"'Appendix--Fertilizer Costs'!C11","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!D11","v":0.1},{"$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":15},{"$f":"'Appendix--Fertilizer Costs'!L11","v":3}]
[{"$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":38},{"$f":"'Appendix--Fertilizer Costs'!L24","v":3.4545454545454546}]
[{"$f":"'Appendix--Fertilizer Costs'!A27","v":"Peanut meal"},{"$f":"'Appendix--Fertilizer Costs'!B27","v":0.08},{"$f":"'Appendix--Fertilizer Costs'!C27","v":0.01},{"$f":"'Appendix--Fertilizer Costs'!D27","v":0.02},{"$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":"slow/ med"},{"$f":"'Appendix--Fertilizer Costs'!I27","v":37},{"$f":"'Appendix--Fertilizer Costs'!L27","v":37}]
[{"$f":"'Appendix--Fertilizer Costs'!A29","v":"Potassium chloride"},{"$f":"'Appendix--Fertilizer Costs'!B29","v":0},{"$f":"'Appendix--Fertilizer Costs'!C29","v":0},{"$f":"'Appendix--Fertilizer Costs'!D29","v":0.6},{"$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":"rapid"},{"$f":"'Appendix--Fertilizer Costs'!I29","v":15},{"$f":"'Appendix--Fertilizer Costs'!L29","v":0.5}]
[{"$f":"'Appendix--Fertilizer Costs'!A32","v":"Sulfate of potash"},{"$f":"'Appendix--Fertilizer Costs'!B32","v":0},{"$f":"'Appendix--Fertilizer Costs'!C32","v":0},{"$f":"'Appendix--Fertilizer Costs'!D32","v":0.5},{"$f":"'Appendix--Fertilizer Costs'!E32","v":0},{"$f":"'Appendix--Fertilizer Costs'!F32","v":0},{"$f":"'Appendix--Fertilizer Costs'!G32","v":0.17},{"$f":"'Appendix--Fertilizer Costs'!H32","v":"rapid"},{"$f":"'Appendix--Fertilizer Costs'!I32","v":51},{"$f":"'Appendix--Fertilizer Costs'!L32","v":2.04}]
[{"$f":"'Appendix--Fertilizer Costs'!A36","v":"Blended fertilizers"}]
[{"$f":"'Appendix--Fertilizer Costs'!A37","v":"Cheep Cheep"},{"$f":"'Appendix--Fertilizer Costs'!B37","v":0.04},{"$f":"'Appendix--Fertilizer Costs'!C37","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!D37","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!E37","v":0},{"$f":"'Appendix--Fertilizer Costs'!F37","v":0},{"$f":"'Appendix--Fertilizer Costs'!G37","v":0},{"$f":"'Appendix--Fertilizer Costs'!H37","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I37","v":20.5},{"$f":"'Appendix--Fertilizer Costs'!L37","v":13.666666666666666}]
[{"$f":"'Appendix--Fertilizer Costs'!A38","v":"Custom 5-5-5"},{"$f":"'Appendix--Fertilizer Costs'!B38","v":0.05},{"$f":"'Appendix--Fertilizer Costs'!C38","v":0.05},{"$f":"'Appendix--Fertilizer Costs'!D38","v":0.05},{"$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":"med"},{"$f":"'Appendix--Fertilizer Costs'!I38","v":27},{"$f":"'Appendix--Fertilizer Costs'!L38","v":10.8}]
[{"$f":"'Appendix--Fertilizer Costs'!A39","v":"Custom 6-0-6"},{"$f":"'Appendix--Fertilizer Costs'!B39","v":0.06},{"$f":"'Appendix--Fertilizer Costs'!C39","v":0},{"$f":"'Appendix--Fertilizer Costs'!D39","v":0.06},{"$f":"'Appendix--Fertilizer Costs'!E39","v":0},{"$f":"'Appendix--Fertilizer Costs'!F39","v":0},{"$f":"'Appendix--Fertilizer Costs'!G39","v":0},{"$f":"'Appendix--Fertilizer Costs'!H39","v":"med"},{"$f":"'Appendix--Fertilizer Costs'!I39","v":28.5},{"$f":"'Appendix--Fertilizer Costs'!L39","v":9.5}]
[{"$f":"'Appendix--Fertilizer Costs'!A40","v":"Pro-Start"},{"$f":"'Appendix--Fertilizer Costs'!B40","v":0.02},{"$f":"'Appendix--Fertilizer Costs'!C40","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!D40","v":0.03},{"$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":"med/ rapid"},{"$f":"'Appendix--Fertilizer Costs'!I40","v":17},{"$f":"'Appendix--Fertilizer Costs'!L40","v":11.333333333333334}]
[{"$f":"'Appendix--Fertilizer Costs'!A42","v":"Pro-Gro"},{"$f":"'Appendix--Fertilizer Costs'!B42","v":0.05},{"$f":"'Appendix--Fertilizer Costs'!C42","v":0.03},{"$f":"'Appendix--Fertilizer Costs'!D42","v":0.04},{"$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":"med"},{"$f":"'Appendix--Fertilizer Costs'!I42","v":22.5},{"$f":"'Appendix--Fertilizer Costs'!L42","v":11.25}]
["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 or other)"},{"$f":"'STEP 6--Choose K'!B7","v":0.05},{"$f":"'STEP 6--Choose K'!C7","v":0.04},{"$f":"'STEP 6--Choose K'!D7","v":0.03},{"$f":"'STEP 6--Choose K'!E7","v":0.09},{"$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":15},{"$f":"'STEP 6--Choose K'!J7","v":10},{"$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 High-K Blend Poultry Manure (Kreher's or other)"},{"$f":"'STEP 6--Choose K'!B8","v":0.04},{"$f":"'STEP 6--Choose K'!C8","v":0.03},{"$f":"'STEP 6--Choose K'!D8","v":0.1},{"$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":15},{"$f":"'STEP 6--Choose K'!J8","v":3},{"$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":38},{"$f":"'STEP 6--Choose K'!J11","v":3.4545454545454546},{"$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":"Peanut meal"},{"$f":"'STEP 6--Choose K'!B12","v":0.08},{"$f":"'STEP 6--Choose K'!C12","v":0.01},{"$f":"'STEP 6--Choose K'!D12","v":0.02},{"$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":"slow/ med"},{"$f":"'STEP 6--Choose K'!I12","v":37},{"$f":"'STEP 6--Choose K'!J12","v":37},{"$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":"Potassium chloride"},{"$f":"'STEP 6--Choose K'!B13","v":0},{"$f":"'STEP 6--Choose K'!C13","v":0},{"$f":"'STEP 6--Choose K'!D13","v":0.6},{"$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":"rapid"},{"$f":"'STEP 6--Choose K'!I13","v":15},{"$f":"'STEP 6--Choose K'!J13","v":0.5},{"$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":"Sulfate of potash"},{"$f":"'STEP 6--Choose K'!B14","v":0},{"$f":"'STEP 6--Choose K'!C14","v":0},{"$f":"'STEP 6--Choose K'!D14","v":0.5},{"$f":"'STEP 6--Choose K'!E14","v":0},{"$f":"'STEP 6--Choose K'!F14","v":0},{"$f":"'STEP 6--Choose K'!G14","v":0.17},{"$f":"'STEP 6--Choose K'!H14","v":"rapid"},{"$f":"'STEP 6--Choose K'!I14","v":51},{"$f":"'STEP 6--Choose K'!J14","v":2.04},{"$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":"Blended fertilizers"}]
[{"$f":"'STEP 6--Choose K'!A16","v":"Cheep Cheep"},{"$f":"'STEP 6--Choose K'!B16","v":0.04},{"$f":"'STEP 6--Choose K'!C16","v":0.03},{"$f":"'STEP 6--Choose K'!D16","v":0.03},{"$f":"'STEP 6--Choose K'!E16","v":0},{"$f":"'STEP 6--Choose K'!F16","v":0},{"$f":"'STEP 6--Choose K'!G16","v":0},{"$f":"'STEP 6--Choose K'!H16","v":"med"},{"$f":"'STEP 6--Choose K'!I16","v":20.5},{"$f":"'STEP 6--Choose K'!J16","v":13.666666666666666},{"$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":"Custom 5-5-5"},{"$f":"'STEP 6--Choose K'!B17","v":0.05},{"$f":"'STEP 6--Choose K'!C17","v":0.05},{"$f":"'STEP 6--Choose K'!D17","v":0.05},{"$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":"med"},{"$f":"'STEP 6--Choose K'!I17","v":27},{"$f":"'STEP 6--Choose K'!J17","v":10.8},{"$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":"Custom 6-0-6"},{"$f":"'STEP 6--Choose K'!B18","v":0.06},{"$f":"'STEP 6--Choose K'!C18","v":0},{"$f":"'STEP 6--Choose K'!D18","v":0.06},{"$f":"'STEP 6--Choose K'!E18","v":0},{"$f":"'STEP 6--Choose K'!F18","v":0},{"$f":"'STEP 6--Choose K'!G18","v":0},{"$f":"'STEP 6--Choose K'!H18","v":"med"},{"$f":"'STEP 6--Choose K'!I18","v":28.5},{"$f":"'STEP 6--Choose K'!J18","v":9.5},{"$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":"Pro-Start"},{"$f":"'STEP 6--Choose K'!B19","v":0.02},{"$f":"'STEP 6--Choose K'!C19","v":0.03},{"$f":"'STEP 6--Choose K'!D19","v":0.03},{"$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":"med/ rapid"},{"$f":"'STEP 6--Choose K'!I19","v":17},{"$f":"'STEP 6--Choose K'!J19","v":11.333333333333334},{"$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":"Pro-Gro"},{"$f":"'STEP 6--Choose K'!B20","v":0.05},{"$f":"'STEP 6--Choose K'!C20","v":0.03},{"$f":"'STEP 6--Choose K'!D20","v":0.04},{"$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":"med"},{"$f":"'STEP 6--Choose K'!I20","v":22.5},{"$f":"'STEP 6--Choose K'!J20","v":11.25},{"$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":0},{"$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":{"$error":"#N/A"}},{"$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":"NONE NEEDED"},{"$f":"ROUNDUP(VLOOKUP('STEP 6--Choose K'!E2,'K lookup'!A2:P17,11,FALSE),-1)","v":0},{"$f":"VLOOKUP('STEP 6--Choose K'!E2,'K lookup'!A2:P17,8,FALSE)","v":0},{"$f":"ROUNDUP(VLOOKUP('STEP 6--Choose K'!E2,'K lookup'!A2:P17,15,FALSE),-1)","v":0},{"$f":"ROUNDUP(VLOOKUP('STEP 6--Choose K'!E2,'K lookup'!A2:P17,11,FALSE),-1)*'STEP 1--Field Information'!F23","v":0},{"$f":"ROUNDUP(VLOOKUP('STEP 6--Choose K'!E2,'K lookup'!A2:P17,15,FALSE),-1)*'STEP 1--Field Information'!F23","v":0}]
[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":[[1,0,1,6],[0,0,0,11],[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 (pounds per field)","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":1},{"$f":"'STEP 1--Field Information'!E8","v":"Mixed Vegetable"},{"$f":"'STEP 2--Soil Test Information'!B4","v":0},{"$f":"('STEP 2--Soil Test Information'!B21*C4)*2000","v":0},{"$f":"'STEP 3--Nutrient Needs'!C11","v":100},{"$f":"'STEP 4--Choose N'!D2","v":0},{"$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":"NONE NEEDED"},{"$f":"'STEP 7--Fertilizer Costs'!F6","v":0},{"$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":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["MATERIAL","% N","% P2O5","% K20","% Ca","% Mg","% S","Release Rate","Price per 50 lb","$/lb N","$/lb P","$/lb K"]
["Alfalfa meal",0.03,5.0000000000000001E-3,2.5000000000000001E-2,null,null,null,"slow/ med",30,{"$f":"I2*2/(B2*100)","v":20},{"$f":"I2*2/(C2*100)","v":120},{"$f":"I2*2/(D2*100)","v":24}]
["Ammonium sulfate",0.21,null,null,null,null,0.23,"rapid",10.7,{"$f":"I3*2/(B3*100)","v":1.019047619047619}]
["Blood meal",0.12,0.01,5.0000000000000001E-3,null,null,null,"med/ rapid",68,11.333333333333334,{"$f":"I4*2/(C4*100)","v":136},{"$f":"I4*2/(D4*100)","v":272}]
["Bone char",null,0.16,null,null,null,null,"med",34,null,{"$f":"I5*2/(C5*100)","v":4.25}]
["Bone meal",0.03,0.2,null,null,null,null,"med",39,26,{"$f":"I6*2/(C6*100)","v":3.9}]
["Calcitic limestone",null,null,null,0.38,null,null,"med"]
["Calcium nitrate",0.15,null,null,0.19,null,null,"rapid",21.85,2.9133333333333336]
["Chilean nitrate",0.15,null,0.02,null,null,null,"rapid",45,6,null,{"$f":"I9*2/(D9*100)","v":45}]
["Dehydrated Poultry Manure (Kreher's or other)",0.05,0.04,0.03,0.09,null,null,"med",15,6,{"$f":"I10*2/(C10*100)","v":7.5},{"$f":"I10*2/(D10*100)","v":10}]
["Dehydrated High-K Blend Poultry Manure (Kreher's or other)",0.04,0.03,0.1,null,null,null,"med",15,7.5,{"$f":"I11*2/(C11*100)","v":10},{"$f":"I11*2/(D11*100)","v":3}]
["Diammonium phosphate",null,0.46,null,null,null,null,"rapid",{"$f":"473/40","v":11.824999999999999},null,{"$f":"I12*2/(C12*100)","v":0.51413043478260867}]
["Dolomitic limestone",null,null,null,0.25,0.1,null,"med"]
["Elemental sulfur",null,null,null,null,null,null,"med"]
["Epsom salts (Mg sulfate)",null,null,null,null,9.8000000000000004E-2,0.13,"rapid",18]
["Feather meal",0.12,null,null,null,null,null,"med",50,8.3333333333333339]
["Fish emulsion",0.05,0.02,null,null,null,null,"rapid",null,0,{"$f":"I17*2/(C17*100)","v":0}]
["Fish meal",0.09,7.0000000000000007E-2,null,null,null,null,"med",90,20,{"$f":"I18*2/(C18*100)","v":25.714285714285712}]
["Grioux's Composted Poultry Manure",0.02,0.03,1.4999999999999999E-2,7.0000000000000007E-2,0.01,0.05,"med",2.5,2.5,{"$f":"I19*2/(C19*100)","v":1.6666666666666667},{"$f":"I19*2/(D19*100)","v":3.3333333333333335}]
["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,{"$f":"I22*2/(C22*100)","v":63},{"$f":"I22*2/(D22*100)","v":8.9999999999999982}]
["Gypsum",null,null,null,0.23,null,null,null,16.5]
["K-mag",null,null,0.22,null,0.11,0.22,"rapid",38,null,null,{"$f":"I24*2/(D24*100)","v":3.4545454545454546}]
["Kelp meal",null,null,null,null,null,null,null,69]
["Naturesafe",0.13,0,0,null,null,null,"med",36.25,{"$f":"I26*2/(B26*100)","v":5.5769230769230766}]
["Peanut meal",0.08,0.01,0.02,null,null,null,"slow/ med",37,9.25,{"$f":"I27*2/(C27*100)","v":74},{"$f":"I27*2/(D27*100)","v":37}]
["Planter's II Trace Minerals",null,null,8.9999999999999998E-4,0.05,null,0.05,null,38]
["Potassium chloride",null,null,0.6,null,null,null,"rapid",{"$f":"0.3*50","v":15},null,null,{"$f":"I29*2/(D29*100)","v":0.5}]
["Rock phosphate",null,0.05,null,null,null,null,"very slow",24,null,{"$f":"I30*2/(C30*100)","v":9.6}]
["Soybean meal",7.0000000000000007E-2,0.02,0.01,null,0.03,null,"slow/ med",17,4.8571428571428568,{"$f":"I31*2/(C31*100)","v":17},{"$f":"I31*2/(D31*100)","v":34}]
["Sulfate of potash",null,null,0.5,null,null,0.17,"rapid",51,null,null,{"$f":"I32*2/(D32*100)","v":2.04}]
["Triple super phosphate",null,0.46,null,null,null,null,"rapid",21,null,{"$f":"I33*2/(C33*100)","v":0.91304347826086951}]
["Urea",0.46,null,null,null,null,null,"rapid",20,0.86956521739130432]
["Sufur, granular",null,null,null,null,null,0.9,"slow/ med",28]
["Blended fertilizers"]
["Cheep Cheep",0.04,0.03,0.03,null,null,null,"med",20.5,10.25,{"$f":"I37*2/(C37*100)","v":13.666666666666666},{"$f":"I37*2/(D37*100)","v":13.666666666666666}]
["Custom 5-5-5",0.05,0.05,0.05,null,null,null,"med",27,10.8,{"$f":"I38*2/(C38*100)","v":10.8},{"$f":"I38*2/(D38*100)","v":10.8}]
["Custom 6-0-6",0.06,null,0.06,null,null,null,"med",28.5,9.5,null,{"$f":"I39*2/(D39*100)","v":9.5}]
["Pro-Start",0.02,0.03,0.03,null,null,null,"med/ rapid",17,17,{"$f":"I40*2/(C40*100)","v":11.333333333333334},{"$f":"I40*2/(D40*100)","v":11.333333333333334}]
["Pro-Booster",0.1,null,null,null,null,null,"med/ rapid",32,6.4]
["Pro-Gro",0.05,0.03,0.04,null,null,null,"med",22.5,9,{"$f":"I42*2/(C42*100)","v":15},{"$f":"I42*2/(D42*100)","v":11.25}]

{"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"]