{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Input Information","Recommendation Summary","Lime Rate & Cost","Fertilizer Rate & Cost","Calc"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":22,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":62,"n_cols":3,"rows_kept":62,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[]
[null,"Fertility Recommendation Calculator"]
[]
[null,"This spreadsheet calculates fertilizer application rates and costs for major field crops in Ohio. Users should start by selecting phosphorous test and unit by clicking on box and making selection using down arrow on right side of box. Users can then enter crops, yield goals and soil tests results in the \"Input Information\" tab. Soil fertilizer application rates are summarized in the \"Recommendation Summary\" tab, or reported individually  with cost on the \"lime\" and \"fertilizer\" tabs. All calculations are based on the \"Tri-State Fertilizer Recommendations for Corn, Soybeans, Wheat and Alfalfa."]
[null,"Report for:"]
[null,"Prepared by:"]
[null,"Units Used to Report P&K Results (From soil test report or call lab)","ppm"]
[null,"Test Used to report Phosphorus results (From soil test report or call lab)","Bray 1"]
[]
[null,"Note for all sheets that light gray areas for data entry & white areas show results"]
[]
[null,"To Begin Click Start=====>"]
[]
[null,"Sources:","Developed by:"]
[null,"Vitosh, M.L., J.W. Johnson, and D.B. Mengel (eds.). 1996. Tri-State Fertilizer Recommendations ","Greg LaBarge"]
[null,"for Corn, Soybeans, Wheat, and Alfalfa. Ext. Bull. E-2567, ","Field Specialist, Agronomic Systems"]
[null,"Rep. August 1996. Mich. State Univ., E. Lansing, MI.","Ohio State University Extension"]
[null,"http://www.extension.purdue.edu/extmedia/AY/AY-9-32.pdf ","labarge.1@osu.edu"]
[null,"Understanding Soil Test for Plant Available Phosphorus"]
[null,"http://agcrops.osu.edu/specialists/fertility/fertility-fact-sheets-and-bulletins/Soil_Tests.pdf","Reviewed by:"]
[null,null,"Dr. Steve Culman"]
[null,"Version 2014-1. Published 5/2014","Extension Specialist, Soil Fertiltiy"]
[null,null,"Ohio State University Extension"]
[null,null,"culman.2@osu.edu"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Please select before proceeding"]
[null,"Mehlich III"]
[null,"Bray 1"]
[]
[null,"Please select before proceeding"]
[null,"ppm"]
[null,"pounds per acre"]

{"sheet":"Input Information","index":1,"n_rows":55,"n_cols":18,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Cropping Information",null,null,null,"Soil Test Information",null,null,null,null,null,null,null,null,"Fertilizer Recommendation"]
["Field Name","Acres","Year","Crop","Units","Yield Goal","OM","CEC","pH","Buffer pH","P","K","Ca","Mg","Target pH","P2O5","K2O","Lime"]
[null,null,null,null,{"$f":"IF(D4=\"\",\"\",VLOOKUP(D4,Calc!$Z$2:$AA$7,2,))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(F4=\"\",\"Enter Yield\",IF(Calc!G2<=0,\"\",IF(Calc!G2<Calc!F2,Calc!D2,IF(Calc!G2<=Calc!R2,Calc!K2,IF(Calc!G2>Calc!R2,Calc!Q2)))))))","v":"Enter Yield"},{"$f":"IF(Calc!G6=0,\"\",IF(H4=\"\", \"enter CEC\",(IF(OR(AND(D4=\"Alfalfa\",Calc!G6>Calc!F6),AND(D4=\"Corn-Silage\",Calc!G6>Calc!F6)),Calc!T6,IF(Calc!G6<=Calc!F6,Calc!E6,IF(Calc!G6<=Calc!R6,Calc!K6,IF(Calc!G6>Calc!R6,Calc!Q6,)))))))","v":""},{"$f":"IF(J4=\"\",\"Need Buff pH\",IF(O4=6.8,Calc!W2,IF(O4=6.5,Calc!X2,IF(O4=6,Calc!Y2,\"select target pH\"))))","v":"Need Buff pH"}]
[null,null,{"$f":"IF(C4=\"\",\"\",C4+1)","v":""},null,{"$f":"IF(D5=\"\",\"\",VLOOKUP(D5,Calc!$Z$2:$AA$7,2,))","v":""},null,{"$f":"G4","v":0},{"$f":"H4","v":0},{"$f":"I4","v":0},0,0,{"$f":"L4","v":0},0,0,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(D5=\"\",\"\",IF(F5=\"\",\"Enter Yield\",IF(Calc!G3<=0,\"\",IF(Calc!G3<Calc!F3,Calc!D3,IF(Calc!G3<=Calc!R3,Calc!K3,IF(Calc!G3>Calc!R3,Calc!Q3))))))))","v":""},{"$f":"IF(Calc!G7=0,\"\",IF(H4=\"\", \"enter CEC\",(IF(OR(AND(D5=\"Alfalfa\",Calc!G7>Calc!F7),AND(D5=\"Corn-Silage\",Calc!G7>Calc!F7)),Calc!T7,IF(Calc!G7<=Calc!F7,Calc!E7,IF(Calc!G7<=Calc!R7,Calc!K7,IF(Calc!G7>Calc!R7,Calc!Q7,)))))))","v":""}]
[null,null,{"$f":"IF(C4=\"\",\"\",C4+2)","v":""},null,{"$f":"IF(D6=\"\",\"\",VLOOKUP(D6,Calc!$Z$2:$AA$7,2,))","v":""},null,{"$f":"G4","v":0},{"$f":"H4","v":0},{"$f":"I4","v":0},0,0,0,0,0,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(D6=\"\",\"\",IF(F6=\"\",\"Enter Yield\",IF(Calc!G4<=0,\"\",IF(Calc!G4<Calc!F4,Calc!D4,IF(Calc!G4<=Calc!R4,Calc!K4,IF(Calc!G4>Calc!R4,Calc!Q4))))))))","v":""},{"$f":"IF(Calc!G8=0,\"\",IF(H4=\"\", \"enter CEC\",(IF(OR(AND(D6=\"Alfalfa\",Calc!G8>Calc!F8),AND(D6=\"Corn-Silage\",Calc!G8>Calc!F8)),Calc!T8,IF(Calc!G8<=Calc!F8,Calc!E8,IF(Calc!G8<=Calc!R8,Calc!K8,IF(Calc!G8>Calc!R8,Calc!Q8,)))))))","v":""}]
[]
[null,null,{"$f":"IF(C4=\"\",\"\",C4)","v":""},null,{"$f":"IF(D8=\"\",\"\",VLOOKUP(D8,Calc!$Z$2:$AA$7,2,))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(F8=\"\",\"Enter Yield\",IF(Calc!G11<=0,\"\",IF(Calc!G11<Calc!F11,Calc!D11,IF(Calc!G11<=Calc!R11,Calc!K11,IF(Calc!G11>Calc!R11,Calc!Q11)))))))","v":"Enter Yield"},{"$f":"IF(Calc!G15=0,\"\",IF(H8=\"\",\"enter CEC\",(IF(OR(AND(D8=\"Alfalfa\",Calc!G15>Calc!F15),AND(D8=\"Corn-Silage\",Calc!G15>Calc!F15)),Calc!T15,IF(Calc!G15<=Calc!F15,Calc!E15,IF(Calc!G15<=Calc!R15,Calc!K15,IF(Calc!G15>Calc!R15,Calc!Q15,)))))))","v":""},{"$f":"IF(J8=\"\",\"Need Buff pH\",IF(O8=6.8,Calc!W11,IF(O8=6.5,Calc!X11,IF(O8=6,Calc!Y11,\"select target pH\"))))","v":"Need Buff pH"}]
[null,null,{"$f":"C5","v":""},null,{"$f":"IF(D9=\"\",\"\",VLOOKUP(D9,Calc!$Z$2:$AA$7,2,))","v":""},null,{"$f":"G8","v":0},0,0,0,0,0,0,0,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(D9=\"\",\"\",IF(F9=\"\",\"Enter Yield\",IF(Calc!G12<=0,\"\",IF(Calc!G12<Calc!F12,Calc!D12,IF(Calc!G12<=Calc!R12,Calc!K12,IF(Calc!G12>Calc!R12,Calc!Q12))))))))","v":""},{"$f":"IF(Calc!G16=0,\"\",IF(H8=\"\",\"enter CEC\",(IF(OR(AND(D9=\"Alfalfa\",Calc!G16>Calc!F16),AND(D9=\"Corn-Silage\",Calc!G16>Calc!F16)),Calc!T16,IF(Calc!G16<=Calc!F16,Calc!E16,IF(Calc!G16<=Calc!R16,Calc!K16,IF(Calc!G16>Calc!R16,Calc!Q16,)))))))","v":""}]
[null,null,{"$f":"C6","v":""},null,{"$f":"IF(D10=\"\",\"\",VLOOKUP(D10,Calc!$Z$2:$AA$7,2,))","v":""},null,{"$f":"G8","v":0},0,0,0,0,0,0,0,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(D10=\"\",\"\",IF(F10=\"\",\"Enter Yield\",IF(Calc!G13<=0,\"\",IF(Calc!G13<Calc!F13,Calc!D13,IF(Calc!G13<=Calc!R13,Calc!K13,IF(Calc!G13>Calc!R13,Calc!Q13))))))))","v":""},{"$f":"IF(Calc!G17=0,\"\",IF(H8=\"\",\"enter CEC\",(IF(OR(AND(D10=\"Alfalfa\",Calc!G17>Calc!F17),AND(D10=\"Corn-Silage\",Calc!G17>Calc!F17)),Calc!T17,IF(Calc!G17<=Calc!F17,Calc!E17,IF(Calc!G17<=Calc!R17,Calc!K17,IF(Calc!G17>Calc!R17,Calc!Q17,)))))))","v":""}]
[]
[null,null,{"$f":"C8","v":""},null,{"$f":"IF(D12=\"\",\"\",VLOOKUP(D12,Calc!$Z$2:$AA$7,2,))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(F12=\"\",\"Enter Yield\",IF(Calc!G20<=0,\"\",IF(Calc!G20<Calc!F20,Calc!D20,IF(Calc!G20<=Calc!R20,Calc!K20,IF(Calc!G20>Calc!R20,Calc!Q20)))))))","v":"Enter Yield"},{"$f":"IF(Calc!G24=0,\"\",IF(H12=\"\",\"enter CEC\",(IF(OR(AND(D12=\"Alfalfa\",Calc!G24>Calc!F24),AND(D12=\"Corn-Silage\",Calc!G24>Calc!F24)),Calc!T24,IF(Calc!G24<=Calc!F24,Calc!E24,IF(Calc!G24<=Calc!R24,Calc!K24,IF(Calc!G24>Calc!R24,Calc!Q24,)))))))","v":""},{"$f":"IF(J12=\"\",\"Need Buff pH\",IF(O12=6.8,Calc!W20,IF(O12=6.5,Calc!X20,IF(O12=6,Calc!Y20,\"select target pH\"))))","v":"Need Buff pH"}]
[null,null,{"$f":"C9","v":""},null,{"$f":"IF(D13=\"\",\"\",VLOOKUP(D13,Calc!$Z$2:$AA$7,2,))","v":""},null,{"$f":"G12","v":0},0,0,0,0,0,0,0,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(D13=\"\",\"\",IF(F13=\"\",\"Enter Yield\",IF(Calc!G21<=0,\"\",IF(Calc!G21<Calc!F21,Calc!D21,IF(Calc!G21<=Calc!R21,Calc!K21,IF(Calc!G21>Calc!R21,Calc!Q21))))))))","v":""},{"$f":"IF(Calc!G25=0,\"\",IF(H12=\"\",\"enter CEC\",(IF(OR(AND(D13=\"Alfalfa\",Calc!G25>Calc!F25),AND(D13=\"Corn-Silage\",Calc!G25>Calc!F25)),Calc!T25,IF(Calc!G25<=Calc!F25,Calc!E25,IF(Calc!G25<=Calc!R25,Calc!K25,IF(Calc!G25>Calc!R25,Calc!Q25,)))))))","v":""}]
[null,null,{"$f":"C10","v":""},null,{"$f":"IF(D14=\"\",\"\",VLOOKUP(D14,Calc!$Z$2:$AA$7,2,))","v":""},null,{"$f":"G12","v":0},0,0,0,0,0,0,0,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(D14=\"\",\"\",IF(F14=\"\",\"Enter Yield\",IF(Calc!G22<=0,\"\",IF(Calc!G22<Calc!F22,Calc!D22,IF(Calc!G22<=Calc!R22,Calc!K22,IF(Calc!G22>Calc!R22,Calc!Q22))))))))","v":""},{"$f":"IF(Calc!G26=0,\"\",IF(H12=\"\",\"enter CEC\",(IF(OR(AND(D14=\"Alfalfa\",Calc!G26>Calc!F26),AND(D14=\"Corn-Silage\",Calc!G26>Calc!F26)),Calc!T26,IF(Calc!G26<=Calc!F26,Calc!E26,IF(Calc!G26<=Calc!R26,Calc!K26,IF(Calc!G26>Calc!R26,Calc!Q26,)))))))","v":""}]
[]
[null,null,{"$f":"C12","v":""},null,{"$f":"IF(D16=\"\",\"\",VLOOKUP(D16,Calc!$Z$2:$AA$7,2,))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(F16=\"\",\"Enter Yield\",IF(Calc!G29<=0,\"\",IF(Calc!G29<Calc!F29,Calc!D29,IF(Calc!G29<=Calc!R29,Calc!K29,IF(Calc!G29>Calc!R29,Calc!Q29)))))))","v":"Enter Yield"},{"$f":"IF(Calc!G33=0,\"\",IF(H16=\"\",\"enter CEC\",(IF(OR(AND(D16=\"Alfalfa\",Calc!G33>Calc!F33),AND(D16=\"Corn-Silage\",Calc!G33>Calc!F33)),Calc!T33,IF(Calc!G33<=Calc!F33,Calc!E33,IF(Calc!G33<=Calc!R33,Calc!K33,IF(Calc!G33>Calc!R33,Calc!Q33,)))))))","v":""},{"$f":"IF(J16=\"\",\"Need Buff pH\",IF(O16=6.8,Calc!W29,IF(O16=6.5,Calc!X29,IF(O16=6,Calc!Y29,\"select target pH\"))))","v":"Need Buff pH"}]
[null,null,{"$f":"C13","v":""},null,{"$f":"IF(D17=\"\",\"\",VLOOKUP(D17,Calc!$Z$2:$AA$7,2,))","v":""},null,{"$f":"G16","v":0},{"$f":"H16","v":0},0,0,0,0,0,0,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(D17=\"\",\"\",IF(F17=\"\",\"Enter Yield\",IF(Calc!G30<=0,\"\",IF(Calc!G30<Calc!F30,Calc!D30,IF(Calc!G30<=Calc!R30,Calc!K30,IF(Calc!G30>Calc!R30,Calc!Q30))))))))","v":""},{"$f":"IF(Calc!G34=0,\"\",IF(H16=\"\",\"enter CEC\",(IF(OR(AND(D17=\"Alfalfa\",Calc!G34>Calc!F34),AND(D17=\"Corn-Silage\",Calc!G34>Calc!F34)),Calc!T34,IF(Calc!G34<=Calc!F34,Calc!E34,IF(Calc!G34<=Calc!R34,Calc!K34,IF(Calc!G34>Calc!R34,Calc!Q34,)))))))","v":""}]
[null,null,{"$f":"C14","v":""},null,{"$f":"IF(D18=\"\",\"\",VLOOKUP(D18,Calc!$Z$2:$AA$7,2,))","v":""},null,{"$f":"G16","v":0},0,0,0,0,0,0,0,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(D18=\"\",\"\",IF(F18=\"\",\"Enter Yield\",IF(Calc!G31<=0,\"\",IF(Calc!G31<Calc!F31,Calc!D31,IF(Calc!G31<=Calc!R31,Calc!K31,IF(Calc!G31>Calc!R31,Calc!Q31))))))))","v":""},{"$f":"IF(Calc!G35=0,\"\",IF(H16=\"\",\"enter CEC\",(IF(OR(AND(D18=\"Alfalfa\",Calc!G35>Calc!F35),AND(D18=\"Corn-Silage\",Calc!G35>Calc!F35)),Calc!T35,IF(Calc!G35<=Calc!F35,Calc!E35,IF(Calc!G35<=Calc!R35,Calc!K35,IF(Calc!G35>Calc!R35,Calc!Q35,)))))))","v":""}]
[]
[null,null,{"$f":"C16","v":""},null,{"$f":"IF(D20=\"\",\"\",VLOOKUP(D20,Calc!$Z$2:$AA$7,2,))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(F20=\"\",\"Enter Yield\",IF(Calc!G38<=0,\"\",IF(Calc!G38<Calc!F38,Calc!D38,IF(Calc!G38<=Calc!R38,Calc!K38,IF(Calc!G38>Calc!R38,Calc!Q38)))))))","v":"Enter Yield"},{"$f":"IF(Calc!G42=0,\"\",IF(H20=\"\",\"enter CEC\",(IF(OR(AND(D20=\"Alfalfa\",Calc!G42>Calc!F42),AND(D20=\"Corn-Silage\",Calc!G42>Calc!F42)),Calc!T42,IF(Calc!G42<=Calc!F42,Calc!E42,IF(Calc!G42<=Calc!R42,Calc!K42,IF(Calc!G42>Calc!R42,Calc!Q42,)))))))","v":""},{"$f":"IF(J20=\"\",\"Need Buff pH\",IF(O20=6.8,Calc!W38,IF(O20=6.5,Calc!X38,IF(O20=6,Calc!Y38,\"select target pH\"))))","v":"Need Buff pH"}]
[null,null,{"$f":"C17","v":""},null,{"$f":"IF(D21=\"\",\"\",VLOOKUP(D21,Calc!$Z$2:$AA$7,2,))","v":""},null,{"$f":"G20","v":0},0,0,0,0,0,0,0,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(D21=\"\",\"\",IF(F21=\"\",\"Enter Yield\",IF(Calc!G39<=0,\"\",IF(Calc!G39<Calc!F39,Calc!D39,IF(Calc!G39<=Calc!R39,Calc!K39,IF(Calc!G39>Calc!R39,Calc!Q39))))))))","v":""},{"$f":"IF(Calc!G43=0,\"\",IF(H20=\"\",\"enter CEC\",(IF(OR(AND(D21=\"Alfalfa\",Calc!G43>Calc!F43),AND(D21=\"Corn-Silage\",Calc!G43>Calc!F43)),Calc!T43,IF(Calc!G43<=Calc!F43,Calc!E43,IF(Calc!G43<=Calc!R43,Calc!K43,IF(Calc!G43>Calc!R43,Calc!Q43,)))))))","v":""}]
[null,null,{"$f":"C18","v":""},null,{"$f":"IF(D22=\"\",\"\",VLOOKUP(D22,Calc!$Z$2:$AA$7,2,))","v":""},null,{"$f":"G20","v":0},0,0,0,0,0,0,0,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(D22=\"\",\"\",IF(F22=\"\",\"Enter Yield\",IF(Calc!G40<=0,\"\",IF(Calc!G40<Calc!F40,Calc!D40,IF(Calc!G40<=Calc!R40,Calc!K40,IF(Calc!G40>Calc!R40,Calc!Q40))))))))","v":""},{"$f":"IF(Calc!G44=0,\"\",IF(H20=\"\",\"enter CEC\",(IF(OR(AND(D22=\"Alfalfa\",Calc!G44>Calc!F44),AND(D22=\"Corn-Silage\",Calc!G44>Calc!F44)),Calc!T44,IF(Calc!G44<=Calc!F44,Calc!E44,IF(Calc!G44<=Calc!R44,Calc!K44,IF(Calc!G44>Calc!R44,Calc!Q44,)))))))","v":""}]
[]
[null,null,{"$f":"C20","v":""},null,{"$f":"IF(D24=\"\",\"\",VLOOKUP(D24,Calc!$Z$2:$AA$7,2,))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(F24=\"\",\"Enter Yield\",IF(Calc!G47<=0,\"\",IF(Calc!G47<Calc!F47,Calc!D47,IF(Calc!G47<=Calc!R47,Calc!K47,IF(Calc!G47>Calc!R47,Calc!Q47)))))))","v":"Enter Yield"},{"$f":"IF(Calc!G51=0,\"\",IF(H24=\"\",\"enter CEC\",(IF(OR(AND(D24=\"Alfalfa\",Calc!G51>Calc!F51),AND(D24=\"Corn-Silage\",Calc!G51>Calc!F51)),Calc!T51,IF(Calc!G51<=Calc!F51,Calc!E51,IF(Calc!G51<=Calc!R51,Calc!K51,IF(Calc!G51>Calc!R51,Calc!Q51,)))))))","v":""},{"$f":"IF(J24=\"\",\"Need Buff pH\",IF(O24=6.8,Calc!W47,IF(O24=6.5,Calc!X47,IF(O24=6,Calc!Y47,\"select target pH\"))))","v":"Need Buff pH"}]
[null,null,{"$f":"C21","v":""},null,{"$f":"IF(D25=\"\",\"\",VLOOKUP(D25,Calc!$Z$2:$AA$7,2,))","v":""},null,{"$f":"G24","v":0},0,0,0,0,0,0,0,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(D25=\"\",\"\",IF(F25=\"\",\"Enter Yield\",IF(Calc!G48<=0,\"\",IF(Calc!G48<Calc!F48,Calc!D48,IF(Calc!G48<=Calc!R48,Calc!K48,IF(Calc!G48>Calc!R48,Calc!Q48))))))))","v":""},{"$f":"IF(Calc!G52=0,\"\",IF(H24=\"\",\"enter CEC\",(IF(OR(AND(D25=\"Alfalfa\",Calc!G52>Calc!F52),AND(D25=\"Corn-Silage\",Calc!G52>Calc!F52)),Calc!T52,IF(Calc!G52<=Calc!F52,Calc!E52,IF(Calc!G52<=Calc!R52,Calc!K52,IF(Calc!G52>Calc!R52,Calc!Q52,)))))))","v":""}]
[null,null,{"$f":"C22","v":""},null,{"$f":"IF(D26=\"\",\"\",VLOOKUP(D26,Calc!$Z$2:$AA$7,2,))","v":""},null,{"$f":"G24","v":0},0,0,0,0,0,null,null,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(D26=\"\",\"\",IF(F26=\"\",\"Enter Yield\",IF(Calc!G49<=0,\"\",IF(Calc!G49<Calc!F49,Calc!D49,IF(Calc!G49<=Calc!R49,Calc!K49,IF(Calc!G49>Calc!R49,Calc!Q49))))))))","v":""},{"$f":"IF(Calc!G53=0,\"\",IF(H24=\"\",\"enter CEC\",(IF(OR(AND(D26=\"Alfalfa\",Calc!G53>Calc!F53),AND(D26=\"Corn-Silage\",Calc!G53>Calc!F53)),Calc!T53,IF(Calc!G53<=Calc!F53,Calc!E53,IF(Calc!G53<=Calc!R53,Calc!K53,IF(Calc!G53>Calc!R53,Calc!Q53,)))))))","v":""}]
[]
[null,null,{"$f":"C24","v":""},null,{"$f":"IF(D28=\"\",\"\",VLOOKUP(D28,Calc!$Z$2:$AA$7,2,))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(F28=\"\",\"Enter Yield\",IF(Calc!G56<=0,\"\",IF(Calc!G56<Calc!F56,Calc!D56,IF(Calc!G56<=Calc!R56,Calc!K56,IF(Calc!G56>Calc!R56,Calc!Q56)))))))","v":"Enter Yield"},{"$f":"IF(Calc!G60=0,\"\",IF(H28=\"\",\"enter CEC\",(IF(OR(AND(D28=\"Alfalfa\",Calc!G60>Calc!F60),AND(D28=\"Corn-Silage\",Calc!G60>Calc!F60)),Calc!T60,IF(Calc!R60,IF(Calc!G60<=Calc!F60,Calc!E60,IF(Calc!G60<=Calc!R60,Calc!K60,IF(Calc!G60>Calc!R60,Calc!Q60,))))))))","v":""},{"$f":"IF(J28=\"\",\"Need Buff pH\",IF(O28=6.8,Calc!W56,IF(O28=6.5,Calc!X56,IF(O28=6,Calc!Y56,\"select target pH\"))))","v":"Need Buff pH"}]
[null,null,{"$f":"C25","v":""},null,{"$f":"IF(D29=\"\",\"\",VLOOKUP(D29,Calc!$Z$2:$AA$7,2,))","v":""},null,{"$f":"G28","v":0},0,0,0,0,0,0,0,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(D29=\"\",\"\",IF(F29=\"\",\"Enter Yield\",IF(Calc!G57<=0,\"\",IF(Calc!G57<Calc!F57,Calc!D57,IF(Calc!G57<=Calc!R57,Calc!K57,IF(Calc!G57>Calc!R57,Calc!Q57))))))))","v":""},{"$f":"IF(Calc!G61=0,\"\",IF(H28=\"\",\"enter CEC\",(IF(OR(AND(D29=\"Alfalfa\",Calc!G61>Calc!F61),AND(D29=\"Corn-Silage\",Calc!G61>Calc!F61)),Calc!T61,IF(Calc!R61,IF(Calc!G61<=Calc!F61,Calc!E61,IF(Calc!G61<=Calc!R61,Calc!K61,IF(Calc!G61>Calc!R61,Calc!Q61,))))))))","v":""}]
[null,null,{"$f":"C26","v":""},null,{"$f":"IF(D30=\"\",\"\",VLOOKUP(D30,Calc!$Z$2:$AA$7,2,))","v":""},null,{"$f":"G28","v":0},0,0,0,0,0,0,0,null,{"$f":"IF(Introduction!C7=\"Please select before proceeding\",\"select test\",IF(Introduction!C8=\"Please select before proceeding\",\"select units\",IF(D30=\"\",\"\",IF(F30=\"\",\"Enter Yield\",IF(Calc!G58<=0,\"\",IF(Calc!G58<Calc!F58,Calc!D58,IF(Calc!G58<=Calc!R58,Calc!K58,IF(Calc!G58>Calc!R58,Calc!Q58))))))))","v":""},{"$f":"IF(Calc!G62=0,\"\",IF(H28=\"\",\"enter CEC\",(IF(OR(AND(D30=\"Alfalfa\",Calc!G62>Calc!F62),AND(D30=\"Corn-Silage\",Calc!G62>Calc!F62)),Calc!T62,IF(Calc!R62,IF(Calc!G62<=Calc!F62,Calc!E62,IF(Calc!G62<=Calc!R62,Calc!K62,IF(Calc!G62>Calc!R62,Calc!Q62,))))))))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"If error \"Select Units\" or \"Select Test\" return to "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Introduction page and make selections"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Target pH",null,"Year"]
[]
["Corn ",6.8,null,2012]
["Corn-Silage",6.5,null,2013]
["Soybeans",6,null,2014]
["Wheat (Grain Only)",null,null,2015]
["Wheat (Grain & Straw)",null,null,2016]
["Alfalfa",null,null,2017]
[null,null,null,2018]
[null,null,null,2019]
[null,null,null,2020]

{"sheet":"Recommendation Summary","index":2,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Report for:",{"$f":"Introduction!C5","v":0}]
["Prepared by:",{"$f":"Introduction!C6","v":0}]
[null,null,null,"P2O5 in Pounds/Acre",null,null,null,"K2O in Pounds/Acre",null,null,null,"Lime"]
["Field Name","Crop ",null,{"$f":"'Input Information'!C4","v":0},{"$f":"'Input Information'!C5","v":""},{"$f":"'Input Information'!C6","v":""},null,{"$f":"D6","v":0},{"$f":"E6","v":""},{"$f":"F6","v":""},null," in Tons/Acre"]
[{"$f":"'Input Information'!A4","v":0},{"$f":"'Input Information'!D4","v":0},null,{"$f":"'Input Information'!P4","v":"Enter Yield"},null,null,null,{"$f":"'Input Information'!Q4","v":""},null,null,null,{"$f":"'Input Information'!R4","v":"Need Buff pH"}]
[{"$f":"'Input Information'!A4","v":0},{"$f":"'Input Information'!D5","v":0},null,null,{"$f":"'Input Information'!P5","v":""},null,null,null,{"$f":"'Input Information'!Q5","v":""}]
[{"$f":"'Input Information'!A4","v":0},{"$f":"'Input Information'!D6","v":0},null,null,null,{"$f":"'Input Information'!P6","v":""},null,null,null,{"$f":"'Input Information'!Q6","v":""}]
[]
[{"$f":"'Input Information'!A8","v":0},{"$f":"'Input Information'!D8","v":0},null,{"$f":"'Input Information'!P8","v":"Enter Yield"},null,null,null,{"$f":"'Input Information'!Q8","v":""},null,null,null,{"$f":"'Input Information'!R8","v":"Need Buff pH"}]
[{"$f":"'Input Information'!A8","v":0},{"$f":"'Input Information'!D9","v":0},null,null,{"$f":"'Input Information'!P9","v":""},null,null,null,{"$f":"'Input Information'!Q9","v":""}]
[{"$f":"'Input Information'!A8","v":0},{"$f":"'Input Information'!D10","v":0},null,null,null,{"$f":"'Input Information'!P10","v":""},null,null,null,{"$f":"'Input Information'!Q10","v":""}]
[]
[{"$f":"'Input Information'!A12","v":0},{"$f":"'Input Information'!D12","v":0},null,{"$f":"'Input Information'!P12","v":"Enter Yield"},null,null,null,{"$f":"'Input Information'!Q12","v":""},null,null,null,{"$f":"'Input Information'!R12","v":"Need Buff pH"}]
[{"$f":"'Input Information'!A12","v":0},{"$f":"'Input Information'!D13","v":0},null,null,{"$f":"'Input Information'!P13","v":""},null,null,null,{"$f":"'Input Information'!Q13","v":""}]
[{"$f":"'Input Information'!A12","v":0},{"$f":"'Input Information'!D14","v":0},null,null,null,{"$f":"'Input Information'!P14","v":""},null,null,null,{"$f":"'Input Information'!Q14","v":""}]
[]
[{"$f":"'Input Information'!A16","v":0},{"$f":"'Input Information'!D16","v":0},null,{"$f":"'Input Information'!P16","v":"Enter Yield"},null,null,null,{"$f":"'Input Information'!Q16","v":""},null,null,null,{"$f":"'Input Information'!R16","v":"Need Buff pH"}]
[{"$f":"'Input Information'!A16","v":0},{"$f":"'Input Information'!D17","v":0},null,null,{"$f":"'Input Information'!P17","v":""},null,null,null,{"$f":"'Input Information'!Q17","v":""}]
[{"$f":"'Input Information'!A16","v":0},{"$f":"'Input Information'!D18","v":0},null,null,null,{"$f":"'Input Information'!P18","v":""},null,null,null,{"$f":"'Input Information'!Q18","v":""}]
[]
[{"$f":"'Input Information'!A20","v":0},{"$f":"'Input Information'!D20","v":0},null,{"$f":"'Input Information'!P20","v":"Enter Yield"},null,null,null,{"$f":"'Input Information'!Q20","v":""},null,null,null,{"$f":"'Input Information'!R20","v":"Need Buff pH"}]
[{"$f":"'Input Information'!A20","v":0},{"$f":"'Input Information'!D21","v":0},null,null,{"$f":"'Input Information'!P21","v":""},null,null,null,{"$f":"'Input Information'!Q21","v":""}]
[{"$f":"'Input Information'!A20","v":0},{"$f":"'Input Information'!D22","v":0},null,null,null,{"$f":"'Input Information'!P22","v":""},null,null,null,{"$f":"'Input Information'!Q22","v":""}]
[]
[{"$f":"'Input Information'!A24","v":0},{"$f":"'Input Information'!D24","v":0},null,{"$f":"'Input Information'!P24","v":"Enter Yield"},null,null,null,{"$f":"'Input Information'!Q24","v":""},null,null,null,{"$f":"'Input Information'!R24","v":"Need Buff pH"}]
[{"$f":"'Input Information'!A24","v":0},{"$f":"'Input Information'!D25","v":0},null,null,{"$f":"'Input Information'!P25","v":""},null,null,null,{"$f":"'Input Information'!Q25","v":""}]
[{"$f":"'Input Information'!A24","v":0},{"$f":"'Input Information'!D26","v":0},null,null,null,{"$f":"'Input Information'!P26","v":""},null,null,null,{"$f":"'Input Information'!Q26","v":""}]
[]
[{"$f":"'Input Information'!A28","v":0},{"$f":"'Input Information'!D28","v":0},null,{"$f":"'Input Information'!P28","v":"Enter Yield"},null,null,null,{"$f":"'Input Information'!Q28","v":""},null,null,null,{"$f":"'Input Information'!R28","v":"Need Buff pH"}]
[{"$f":"'Input Information'!A28","v":0},{"$f":"'Input Information'!D29","v":0},null,null,{"$f":"'Input Information'!P29","v":""},null,null,null,{"$f":"'Input Information'!Q29","v":""}]
[{"$f":"'Input Information'!A28","v":0},{"$f":"'Input Information'!D30","v":0},null,null,null,{"$f":"'Input Information'!P30","v":""},null,null,null,{"$f":"'Input Information'!Q30","v":""}]

{"sheet":"Lime Rate & Cost","index":3,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Report For:",{"$f":"Introduction!C5","v":0}]
["Prepared by:",{"$f":"Introduction!C6","v":0}]
["Material ","ENP",null,1500]
["Material Cost","$/Ton",null,20]
["Spreader Cost","$/Ac",null,10]
[]
[null,null,null,"Recommended","Actual *"]
[null,null,null,"Lime ENP=2000","Lime ENP=2000","Total Material ","Total Material ","Cost Material ","Spreader Cost","Total Lime Cost"]
["Field Name","Acres",null," in Tons/Acre","In Tons/Acre","Tons/Acre","for Field in Tons","for Field Total $","Total $","Total $"]
[{"$f":"'Input Information'!A4","v":0},{"$f":"'Input Information'!B4","v":0},null,{"$f":"IF(A12=0,0,'Input Information'!R4)","v":0},null,{"$f":"IF(E12=\"\",D12/($D$5/2000),E12/($D$5/2000))","v":0},{"$f":"F12*B12","v":0},{"$f":"G12*$D$6","v":0},{"$f":"IF(H12=0,0,B12*$D$7)","v":0},{"$f":"SUM(H12:I12)","v":0}]
[]
[{"$f":"'Input Information'!A8","v":0},{"$f":"'Input Information'!B8","v":0},null,{"$f":"IF(A14=0,0,'Input Information'!R8)","v":0},null,{"$f":"IF(E14=\"\",D14/($D$5/2000),E14/($D$5/2000))","v":0},{"$f":"F14*B14","v":0},{"$f":"G14*$D$6","v":0},{"$f":"IF(H14=0,0,B14*$D$7)","v":0},{"$f":"SUM(H14:I14)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B15*$D$7","v":0}]
[{"$f":"'Input Information'!A12","v":0},{"$f":"'Input Information'!B12","v":0},null,{"$f":"IF(A16=0,0,'Input Information'!R12)","v":0},null,{"$f":"IF(E16=\"\",D16/($D$5/2000),E16/($D$5/2000))","v":0},{"$f":"F16*B16","v":0},{"$f":"G16*$D$6","v":0},{"$f":"IF(H16=0,0,B16*$D$7)","v":0},{"$f":"SUM(H16:I16)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B17*$D$7","v":0}]
[{"$f":"'Input Information'!A16","v":0},{"$f":"'Input Information'!B16","v":0},null,{"$f":"IF(A18=0,0,'Input Information'!R16)","v":0},null,{"$f":"IF(E18=\"\",D18/($D$5/2000),E18/($D$5/2000))","v":0},{"$f":"F18*B18","v":0},{"$f":"G18*$D$6","v":0},{"$f":"IF(H18=0,0,B18*$D$7)","v":0},{"$f":"SUM(H18:I18)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B19*$D$7","v":0}]
[{"$f":"'Input Information'!A20","v":0},{"$f":"'Input Information'!B20","v":0},null,{"$f":"IF(A20=0,0,'Input Information'!R20)","v":0},null,{"$f":"IF(E20=\"\",D20/($D$5/2000),E20/($D$5/2000))","v":0},{"$f":"F20*B20","v":0},{"$f":"G20*$D$6","v":0},{"$f":"IF(H20=0,0,B20*$D$7)","v":0},{"$f":"SUM(H20:I20)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B21*$D$7","v":0}]
[{"$f":"'Input Information'!A24","v":0},{"$f":"'Input Information'!B24","v":0},null,{"$f":"IF(A22=0,0,'Input Information'!R24)","v":0},null,{"$f":"IF(E22=\"\",D22/($D$5/2000),E22/($D$5/2000))","v":0},{"$f":"F22*B22","v":0},{"$f":"G22*$D$6","v":0},{"$f":"IF(H22=0,0,B22*$D$7)","v":0},{"$f":"SUM(H22:I22)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"B23*$D$7","v":0}]
[{"$f":"'Input Information'!A28","v":0},{"$f":"'Input Information'!B28","v":0},null,{"$f":"IF(A24=0,0,'Input Information'!R28)","v":0},null,{"$f":"IF(E24=\"\",D24/($D$5/2000),E24/($D$5/2000))","v":0},{"$f":"F24*B24","v":0},{"$f":"G24*$D$6","v":0},{"$f":"IF(H24=0,0,B24*$D$7)","v":0},{"$f":"SUM(H24:I24)","v":0}]
[null,"Total",null,{"$f":"SUM(D12:D24)","v":0},null,{"$f":"SUM(F12:F24)","v":0},0,0,0,0]
[]
[null,null,null,"*Note:"," Do not apply more than 2 tons in a single year you can adjust rate for less than the recommended amount."]
[null,null,null,null," Leave blank if no change"]

{"sheet":"Fertilizer Rate & Cost","index":4,"n_rows":75,"n_cols":9,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Report for:",{"$f":"Introduction!C5","v":0}]
["Prepared by:",{"$f":"Introduction!C6","v":0}]
["Fertilizer Used","N","P2O5","K2O","Cost per Ton"]
["Primary P",11,52,0,450]
["Primary K",0,0,60,550]
[]
["Crop Year ",{"$f":"'Input Information'!C4","v":0},null,"P2O5 in Pounds/Acre"]
["Field Name","Crop ","Acres","Needed","Pound Fertilizer per Acre to meet need","Total Product Need in Pounds","Total Product needed in Tons","Cost per acre","Cost per field "]
[{"$f":"'Input Information'!A4","v":0},{"$f":"'Input Information'!D4","v":0},{"$f":"'Input Information'!B4","v":0},{"$f":"IF(B11=0,0,'Input Information'!P4)","v":0},{"$f":"D11/($C$6*0.01)","v":0},{"$f":"E11*C11","v":0},{"$f":"F11/2000","v":0},{"$f":"$E$6/(2000*($C$6*0.01))*D11","v":0},{"$f":"H11*C11","v":0}]
[{"$f":"'Input Information'!A8","v":0},{"$f":"'Input Information'!D8","v":0},{"$f":"'Input Information'!B8","v":0},{"$f":"IF(B12=0,0,'Input Information'!P8)","v":0},{"$f":"D12/($C$6*0.01)","v":0},0,{"$f":"F12/2000","v":0},0,0]
[{"$f":"'Input Information'!A12","v":0},{"$f":"'Input Information'!D12","v":0},{"$f":"'Input Information'!B12","v":0},{"$f":"IF(B13=0,0,'Input Information'!P12)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A16","v":0},{"$f":"'Input Information'!D16","v":0},{"$f":"'Input Information'!B16","v":0},{"$f":"IF(B14=0,0,'Input Information'!P16)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A20","v":0},{"$f":"'Input Information'!D20","v":0},{"$f":"'Input Information'!B20","v":0},{"$f":"IF(B15=0,0,'Input Information'!P20)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A24","v":0},{"$f":"'Input Information'!D24","v":0},{"$f":"'Input Information'!B24","v":0},{"$f":"IF(B16=0,0,'Input Information'!P24)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A28","v":0},{"$f":"'Input Information'!D28","v":0},{"$f":"'Input Information'!B28","v":0},{"$f":"IF(B17=0,0,'Input Information'!P28)","v":0},0,0,0,0,0]
[null,"Total",null,null,null,{"$f":"SUM(F11:F17)","v":0},{"$f":"SUM(G11:G17)","v":0},0,0]
[]
[null,null,null,"K2O in Pounds/Acre"]
["Field Name","Crop ","Acres","Needed","Pound Fertilizer per Acre to meet need","Total Product Need in Pounds","Total Product needed in Tons","Cost per acre","Cost per field "]
[{"$f":"'Input Information'!A4","v":0},{"$f":"'Input Information'!D4","v":0},{"$f":"'Input Information'!B4","v":0},{"$f":"IF(B22=0,0,'Input Information'!Q4)","v":0},{"$f":"D22/($D$7*0.01)","v":0},{"$f":"E22*C22","v":0},{"$f":"F22/2000","v":0},{"$f":"$E$7/(2000*($D$7*0.01))*D22","v":0},{"$f":"H22*C22","v":0}]
[{"$f":"'Input Information'!A8","v":0},{"$f":"'Input Information'!D8","v":0},{"$f":"'Input Information'!B8","v":0},{"$f":"IF(B23=0,0,'Input Information'!Q8)","v":0},{"$f":"D23/($D$7*0.01)","v":0},0,0,{"$f":"$E$7/(2000*($D$7*0.01))*D23","v":0},0]
[{"$f":"'Input Information'!A12","v":0},{"$f":"'Input Information'!D12","v":0},{"$f":"'Input Information'!B12","v":0},{"$f":"IF(B24=0,0,'Input Information'!Q12)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A16","v":0},{"$f":"'Input Information'!D16","v":0},{"$f":"'Input Information'!B16","v":0},{"$f":"IF(B25=0,0,'Input Information'!Q16)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A20","v":0},{"$f":"'Input Information'!D20","v":0},{"$f":"'Input Information'!B20","v":0},{"$f":"IF(B26=0,0,'Input Information'!Q20)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A24","v":0},{"$f":"'Input Information'!D24","v":0},{"$f":"'Input Information'!B24","v":0},{"$f":"IF(B27=0,0,'Input Information'!Q24)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A28","v":0},{"$f":"'Input Information'!D28","v":0},{"$f":"'Input Information'!B28","v":0},{"$f":"IF(B28=0,0,'Input Information'!Q28)","v":0},0,0,0,0,0]
[null,"Total",null,null,null,{"$f":"SUM(F22:F28)","v":0},{"$f":"SUM(G22:G28)","v":0},0,0]
[]
[]
["Crop Year ",{"$f":"'Input Information'!C5","v":""},null,"P2O5 in Pounds/Acre"]
["Field Name","Crop ","Acres","Needed","Pound Fertilizer per Acre to meet need","Total Product Need in Pounds","Total Product needed in Tons","Cost per acre","Cost per field "]
[{"$f":"'Input Information'!A4","v":0},{"$f":"'Input Information'!D5","v":0},{"$f":"'Input Information'!B4","v":0},{"$f":"IF(B34=0,0,'Input Information'!P5)","v":0},{"$f":"D34/($C$6*0.01)","v":0},{"$f":"E34*C34","v":0},{"$f":"F34/2000","v":0},{"$f":"$E$6/(2000*($C$6*0.01))*D34","v":0},{"$f":"H34*C34","v":0}]
[{"$f":"'Input Information'!A8","v":0},{"$f":"'Input Information'!D9","v":0},{"$f":"'Input Information'!B8","v":0},{"$f":"IF(B35=0,0,'Input Information'!P9)","v":0},{"$f":"D35/($C$6*0.01)","v":0},0,{"$f":"F35/2000","v":0},0,0]
[{"$f":"'Input Information'!A12","v":0},{"$f":"'Input Information'!D13","v":0},{"$f":"'Input Information'!B12","v":0},{"$f":"IF(B36=0,0,'Input Information'!P13)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A16","v":0},{"$f":"'Input Information'!D17","v":0},{"$f":"'Input Information'!B16","v":0},{"$f":"IF(B37=0,0,'Input Information'!P17)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A20","v":0},{"$f":"'Input Information'!D21","v":0},{"$f":"'Input Information'!B20","v":0},{"$f":"IF(B38=0,0,'Input Information'!P21)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A24","v":0},{"$f":"'Input Information'!D25","v":0},{"$f":"'Input Information'!B24","v":0},{"$f":"IF(B39=0,0,'Input Information'!P25)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A28","v":0},{"$f":"'Input Information'!D29","v":0},{"$f":"'Input Information'!B28","v":0},{"$f":"IF(B40=0,0,'Input Information'!P29)","v":0},0,0,0,0,0]
[null,"Total",null,null,null,{"$f":"SUM(F34:F40)","v":0},{"$f":"SUM(G34:G40)","v":0},0,0]
[]
[null,null,null,"K2O in Pounds/Acre"]
["Field Name","Crop ","Acres","Needed","Pound Fertilizer per Acre to meet need","Total Product Need in Pounds","Total Product needed in Tons","Cost per acre","Cost per field "]
[{"$f":"'Input Information'!A4","v":0},{"$f":"'Input Information'!D5","v":0},{"$f":"'Input Information'!B4","v":0},{"$f":"IF(B45=0,0,'Input Information'!Q5)","v":0},{"$f":"D45/($D$7*0.01)","v":0},{"$f":"E45*C45","v":0},{"$f":"F45/2000","v":0},{"$f":"$E$7/(2000*($D$7*0.01))*D45","v":0},{"$f":"H45*C45","v":0}]
[{"$f":"'Input Information'!A8","v":0},{"$f":"'Input Information'!D9","v":0},{"$f":"'Input Information'!B8","v":0},{"$f":"IF(B46=0,0,'Input Information'!Q9)","v":0},{"$f":"D46/($D$7*0.01)","v":0},0,0,{"$f":"$E$7/(2000*($D$7*0.01))*D46","v":0},0]
[{"$f":"'Input Information'!A12","v":0},{"$f":"'Input Information'!D13","v":0},{"$f":"'Input Information'!B12","v":0},{"$f":"IF(B47=0,0,'Input Information'!Q13)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A16","v":0},{"$f":"'Input Information'!D17","v":0},{"$f":"'Input Information'!B16","v":0},{"$f":"IF(B48=0,0,'Input Information'!Q17)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A20","v":0},{"$f":"'Input Information'!D21","v":0},{"$f":"'Input Information'!B20","v":0},{"$f":"IF(B49=0,0,'Input Information'!Q21)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A24","v":0},{"$f":"'Input Information'!D25","v":0},{"$f":"'Input Information'!B24","v":0},{"$f":"IF(B50=0,0,'Input Information'!Q25)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A28","v":0},{"$f":"'Input Information'!D29","v":0},{"$f":"'Input Information'!B28","v":0},{"$f":"IF(B51=0,0,'Input Information'!Q29)","v":0},0,0,0,0,0]
[null,"Total",null,null,null,{"$f":"SUM(F45:F51)","v":0},{"$f":"SUM(G45:G51)","v":0},{"$f":"SUM(H45:H51)","v":0},{"$f":"SUM(I45:I51)","v":0}]
[]
[]
["Crop Year ",{"$f":"'Input Information'!C6","v":""},null,"P2O5 in Pounds/Acre"]
["Field Name","Crop ","Acres","Needed","Pound Fertilizer per Acre to meet need","Total Product Need in Pounds","Total Product needed in Tons","Cost per acre","Cost per field "]
[{"$f":"'Input Information'!A4","v":0},{"$f":"'Input Information'!D6","v":0},{"$f":"'Input Information'!B4","v":0},{"$f":"IF(B57=0,0,'Input Information'!P6)","v":0},{"$f":"D57/($C$6*0.01)","v":0},{"$f":"E57*C57","v":0},{"$f":"F57/2000","v":0},{"$f":"$E$6/(2000*($C$6*0.01))*D57","v":0},{"$f":"H57*C57","v":0}]
[{"$f":"'Input Information'!A8","v":0},{"$f":"'Input Information'!D10","v":0},{"$f":"'Input Information'!B8","v":0},{"$f":"IF(B58=0,0,'Input Information'!P10)","v":0},{"$f":"D58/($C$6*0.01)","v":0},0,{"$f":"F58/2000","v":0},0,0]
[{"$f":"'Input Information'!A12","v":0},{"$f":"'Input Information'!D14","v":0},{"$f":"'Input Information'!B12","v":0},{"$f":"IF(B59=0,0,'Input Information'!P14)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A16","v":0},{"$f":"'Input Information'!D18","v":0},{"$f":"'Input Information'!B16","v":0},{"$f":"IF(B60=0,0,'Input Information'!P18)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A20","v":0},{"$f":"'Input Information'!D22","v":0},{"$f":"'Input Information'!B20","v":0},{"$f":"IF(B61=0,0,'Input Information'!P22)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A24","v":0},{"$f":"'Input Information'!D26","v":0},{"$f":"'Input Information'!B24","v":0},{"$f":"IF(B62=0,0,'Input Information'!P26)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A28","v":0},{"$f":"'Input Information'!D30","v":0},{"$f":"'Input Information'!B28","v":0},{"$f":"IF(B63=0,0,'Input Information'!P30)","v":0},0,0,0,0,0]
[null,"Total",null,null,null,{"$f":"SUM(F57:F63)","v":0},{"$f":"SUM(G57:G63)","v":0},0,0]
[]
[null,null,null,"K2O in Pounds/Acre"]
["Field Name","Crop ","Acres","Needed","Pound Fertilizer per Acre to meet need","Total Product Need in Pounds","Total Product needed in Tons","Cost per acre","Cost per field "]
[{"$f":"'Input Information'!A4","v":0},{"$f":"'Input Information'!D6","v":0},{"$f":"'Input Information'!B4","v":0},{"$f":"IF(B68=0,0,'Input Information'!Q6)","v":0},{"$f":"D68/($D$7*0.01)","v":0},{"$f":"E68*C68","v":0},{"$f":"F68/2000","v":0},{"$f":"$E$7/(2000*($D$7*0.01))*D68","v":0},{"$f":"H68*C68","v":0}]
[{"$f":"'Input Information'!A8","v":0},{"$f":"'Input Information'!D10","v":0},{"$f":"'Input Information'!B8","v":0},{"$f":"IF(B69=0,0,'Input Information'!Q10)","v":0},{"$f":"D69/($D$7*0.01)","v":0},0,0,{"$f":"$E$7/(2000*($D$7*0.01))*D69","v":0},0]
[{"$f":"'Input Information'!A12","v":0},{"$f":"'Input Information'!D14","v":0},{"$f":"'Input Information'!B12","v":0},{"$f":"IF(B70=0,0,'Input Information'!Q14)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A16","v":0},{"$f":"'Input Information'!D18","v":0},{"$f":"'Input Information'!B16","v":0},{"$f":"IF(B71=0,0,'Input Information'!Q18)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A20","v":0},{"$f":"'Input Information'!D22","v":0},{"$f":"'Input Information'!B20","v":0},{"$f":"IF(B72=0,0,'Input Information'!Q22)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A24","v":0},{"$f":"'Input Information'!D26","v":0},{"$f":"'Input Information'!B24","v":0},{"$f":"IF(B73=0,0,'Input Information'!Q26)","v":0},0,0,0,0,0]
[{"$f":"'Input Information'!A28","v":0},{"$f":"'Input Information'!D30","v":0},{"$f":"'Input Information'!B28","v":0},{"$f":"IF(B74=0,0,'Input Information'!Q30)","v":0},0,0,0,0,0]
[null,"Total",null,null,null,{"$f":"SUM(F68:F74)","v":0},{"$f":"SUM(G68:G74)","v":0},{"$f":"SUM(H68:H74)","v":0},{"$f":"SUM(I68:I74)","v":0}]

{"sheet":"Calc","index":5,"n_rows":62,"n_cols":33,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
["Field 1","CEC","Phos","Rate","forageover300","CL","STL","PPM","Bray P1","Phosphorous","Rate","YP","CR","adjust",null,"Rate","Rate","ML","forage",null,null,"BpH","pH=6.8","pH=6.5","pH=6.0",null,null,"CL-P","ML-P","CL-K","ML-K","removal-P2O5","removal-K2O"]
[{"$f":"'Input Information'!$D$4","v":0},null,"Build",{"$f":"((F2-G2)*5)+K2","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A2,$Z$1:$AG$7,3,)","v":{"$error":"#N/A"}},{"$f":"IF(I2<1,1,I2)","v":1},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K4/2),'Input Information'!K4)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H2,-8.08+0.832*H2)","v":0},"Maintenance",{"$f":"L2*M2","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$4","v":0},{"$f":"VLOOKUP(A2,$Z$2:$AG$7,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K2-(K2*(G2-(F2+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P2<0,\"0\",P2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A2,$Z$2:$AG$7,4,)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Input Information'!J4","v":0},{"$f":"IF(-6.7553*V2+46.8098<0.5,\"0\",-6.7553*V2+46.8098)","v":46.809800000000003},{"$f":"IF(-5.6399*V2+39.1496<0.5,\"0\",-5.6399*V2+39.1496)","v":39.1496},{"$f":"IF(-4.5721*V2+31.7602<0.5,\"0\",-4.5721*V2+31.7602)","v":31.760200000000001},"Corn ","Bu",15,30,{"$f":"75+(2.5*$B$6)","v":75},{"$f":"AD2+30","v":105},0.37,0.27]
[{"$f":"'Input Information'!$D$5","v":0},null,"Build",{"$f":"((F3-G3)*5)+K3","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A3,$Z$1:$AG$7,3,)","v":{"$error":"#N/A"}},{"$f":"IF(I3<1,1,I3)","v":1},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K5/2),'Input Information'!K5)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H3,-8.08+0.832*H3)","v":0},"Maintenance",{"$f":"L3*M3","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$5","v":0},{"$f":"VLOOKUP(A3,$Z$2:$AG$7,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K3-(K3*(G3-(F3+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P3<0,\"0\",P3)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A3,$Z$2:$AG$7,4,)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Corn-Silage","Ton",15,30,{"$f":"75+(2.5*$B$6)","v":75},{"$f":"AD3+30","v":105},3.3,8]
[{"$f":"'Input Information'!$D$6","v":0},null,"Build",{"$f":"((F4-G4)*5)+K4","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A4,$Z$1:$AG$7,3,)","v":{"$error":"#N/A"}},1,{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K6/2),'Input Information'!K6)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H4,-8.08+0.832*H4)","v":0},"Maintenance",{"$f":"L4*M4","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$6","v":0},{"$f":"VLOOKUP(A4,$Z$2:$AG$7,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K4-(K4*(G4-(F4+15))/10)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"VLOOKUP(A4,$Z$2:$AG$7,4,)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Soybeans","Bu",15,30,75,105,0.8,1.4]
[null,null,"Pot","Rate",null,null,null,null,null,"Potassium","Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheat (Grain Only)","Bu",25,40,75,105,0.63,0.37]
[{"$f":"'Input Information'!$D$4","v":0},{"$f":"'Input Information'!$H$4","v":0},"Build",{"$f":"((F6-G6)*((1+(0.05*B6)))+(K6))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D4=\"Alfalfa\",G6<=Calc!F6),AND('Input Information'!D4=\"Corn-Silage\",G6<=Calc!F6)),IF(D6>300,\"300\",D6),D6)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A6,$Z$1:$AG$7,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L4/2),'Input Information'!L4)","v":0},null,null,"Maintenance",{"$f":"(L6*M6)+N6","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$4","v":0},{"$f":"VLOOKUP(A6,$Z$2:$AG$7,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K6-(K6*(G6-(F6+30))/20)","v":{"$error":"#N/A"}},{"$f":"IF(P6<0,\"0\",P6)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A6,$Z$2:$AG$7,6,)","v":{"$error":"#N/A"}},{"$f":"K6-(K6*(G6-F6)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S6<0,\"0\",S6)","v":{"$error":"#N/A"}},null,null,null,null,null,"Wheat (Grain & Straw)","Bu",25,40,75,105,0.72,1.28]
[{"$f":"'Input Information'!$D$5","v":0},{"$f":"'Input Information'!$H$4","v":0},"Build",{"$f":"((F7-G7)*((1+(0.05*B7)))+(K7))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D5=\"Alfalfa\",G7<=Calc!F7),AND('Input Information'!D5=\"Corn-Silage\",G7<=Calc!F7)),IF(D7>300,\"300\",D7),D7)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A7,$Z$1:$AG$7,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L5/2),'Input Information'!L5)","v":0},null,null,"Maintenance",{"$f":"(L7*M7)+N7","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$5","v":0},{"$f":"VLOOKUP(A7,$Z$2:$AG$7,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K7-((K7*(G7-(F7+30))/20))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"VLOOKUP(A7,$Z$2:$AG$7,6,)","v":{"$error":"#N/A"}},{"$f":"K7-(K7*(G7-F7)/50)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,null,null,"Alfalfa","Ton",25,40,75,105,13,50]
[{"$f":"'Input Information'!$D$6","v":0},{"$f":"'Input Information'!$H$4","v":0},"Build",{"$f":"((F8-G8)*((1+(0.05*B8)))+(K8))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D6=\"Alfalfa\",G8<=Calc!F8),AND('Input Information'!D6=\"Corn-Silage\",G8<=Calc!F8)),IF(D8>300,\"300\",D8),D8)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A8,$Z$1:$AG$7,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L6/2),'Input Information'!L6)","v":0},null,null,"Maintenance",{"$error":"#N/A"},{"$f":"'Input Information'!$F$6","v":0},{"$f":"VLOOKUP(A8,$Z$2:$AG$7,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K8-((K8*(G8-(F8+30))/20))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"VLOOKUP(A8,$Z$2:$AG$7,6,)","v":{"$error":"#N/A"}},{"$f":"K8-(K8*(G8-F8)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S8<0,\"0\",IF(S8>300,\"300\",S8))","v":{"$error":"#N/A"}}]
["Field 2"]
["Crop","CEC","Phos","Rate",null,"CL","STL","PPM","Bray P1","Phosphorous","Rate","YP","CR",null,null,"Rate","Rate","ML",null,null,null,null,null,null,null,null,null,"CL-P","ML-P","CL-K","ML-K","removal-P2O5","removal-K2O"]
[{"$f":"'Input Information'!$D$8","v":0},null,"Build",{"$f":"((F11-G11)*5)+K11","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A11,$Z$10:$AG$16,3,)","v":{"$error":"#N/A"}},{"$f":"IF(I11<1,1,I11)","v":1},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K8/2),'Input Information'!K8)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H11,-8.08+0.832*H11)","v":0},"Maintenance",{"$f":"L11*M11","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$8","v":0},{"$f":"VLOOKUP(A11,$Z$2:$AG$7,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K11-(K11*(G11-(F11+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P11<0,\"0\",P11)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A11,$Z$11:$AG$16,4,)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Input Information'!J8","v":0},{"$f":"IF(-6.7553*V11+46.8098<0.5,\"0\",-6.7553*V11+46.8098)","v":46.809800000000003},{"$f":"IF(-5.6399*V11+39.1496<0.5,\"0\",-5.6399*V11+39.1496)","v":39.1496},{"$f":"IF(-4.5721*V11+31.7602<0.5,\"0\",-4.5721*V11+31.7602)","v":31.760200000000001},"Corn ","Bu",15,30,{"$f":"75+(2.5*$B$15)","v":75},{"$f":"AD11+30","v":105},0.37,0.27]
[{"$f":"'Input Information'!$D$9","v":0},null,"Build",{"$f":"((F12-G12)*5)+K12","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A12,$Z$10:$AG$16,3,)","v":{"$error":"#N/A"}},{"$f":"IF(I12<1,1,I12)","v":1},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K9/2),'Input Information'!K9)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H12,-8.08+0.832*H12)","v":0},"Maintenance",{"$f":"L12*M12","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$9","v":0},{"$f":"VLOOKUP(A12,$Z$2:$AG$7,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K12-(K12*(G12-(F12+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P12<0,\"0\",P12)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A12,$Z$11:$AG$16,4,)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Corn-Silage","Ton",15,30,{"$f":"75+(2.5*$B$15)","v":75},{"$f":"AD12+30","v":105},3.3,8]
[{"$f":"'Input Information'!$D$10","v":0},null,"Build",{"$f":"((F13-G13)*5)+K13","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A13,$Z$10:$AG$16,3,)","v":{"$error":"#N/A"}},1,{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K10/2),'Input Information'!K10)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H13,-8.08+0.832*H13)","v":0},"Maintenance",{"$f":"L13*M13","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$10","v":0},{"$f":"VLOOKUP(A13,$Z$2:$AG$7,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K13-(K13*(G13-(F13+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P13<0,\"0\",P13)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A13,$Z$11:$AG$16,4,)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Soybeans","Bu",15,30,75,105,0.8,1.4]
[null,null,"Pot","Rate",null,null,null,null,null,"Potassium","Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheat (Grain Only)","Bu",25,40,75,105,0.63,0.37]
[{"$f":"'Input Information'!$D$8","v":0},{"$f":"'Input Information'!$H$8","v":0},"Build",{"$f":"((F15-G15)*((1+(0.05*B15)))+(K15))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D8=\"Alfalfa\",G15<=Calc!F15),AND('Input Information'!D8=\"Corn-Silage\",G15<=Calc!F15)),IF(D15>300,\"300\",D15),D15)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A15,$Z$10:$AG$16,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L8/2),'Input Information'!L8)","v":0},null,null,"Maintenance",{"$f":"(L15*M15)+N15","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$8","v":0},{"$f":"VLOOKUP(A15,$Z$11:$AG$16,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K15-(K15*(G15-(F15+30))/20)","v":{"$error":"#N/A"}},{"$f":"IF(P15<0,\"0\",P15)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A15,$Z$11:$AG$16,6,)","v":{"$error":"#N/A"}},{"$f":"K15-(K15*(G15-F15)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S15<0,\"0\",S15)","v":{"$error":"#N/A"}},null,null,null,null,null,"Wheat (Grain & Straw)","Bu",25,40,75,105,0.72,1.28]
[{"$f":"'Input Information'!$D$9","v":0},{"$f":"'Input Information'!$H$8","v":0},"Build",{"$f":"((F16-G16)*((1+(0.05*B16)))+(K16))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D9=\"Alfalfa\",G16<=Calc!F16),AND('Input Information'!D9=\"Corn-Silage\",G16<=Calc!F16)),IF(D16>300,\"300\",D16),D16)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A16,$Z$10:$AG$16,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L9/2),'Input Information'!L9)","v":0},null,null,"Maintenance",{"$f":"(L16*M16)+N16","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$9","v":0},{"$f":"VLOOKUP(A16,$Z$11:$AG$16,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K16-((K16*(G16-(F16+30))/20))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"VLOOKUP(A16,$Z$11:$AG$16,6,)","v":{"$error":"#N/A"}},{"$f":"K16-(K16*(G16-F16)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S16<0,\"0\",S16)","v":{"$error":"#N/A"}},null,null,null,null,null,"Alfalfa","Ton",25,40,75,105,13,50]
[{"$f":"'Input Information'!$D$10","v":0},{"$f":"'Input Information'!$H$8","v":0},"Build",{"$f":"((F17-G17)*((1+(0.05*B17)))+(K17))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D10=\"Alfalfa\",G17<=Calc!F17),AND('Input Information'!D10=\"Corn-Silage\",G17<=Calc!F17)),IF(D17>300,\"300\",D17),D17)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A17,$Z$10:$AG$16,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L10/2),'Input Information'!L10)","v":0},null,null,"Maintenance",{"$error":"#N/A"},{"$f":"'Input Information'!$F$10","v":0},{"$f":"VLOOKUP(A17,$Z$11:$AG$16,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K17-((K17*(G17-(F17+30))/20))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"VLOOKUP(A17,$Z$11:$AG$16,6,)","v":{"$error":"#N/A"}},{"$f":"K17-(K17*(G17-F17)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S17<0,\"0\",IF(S17>300,\"300\",S17))","v":{"$error":"#N/A"}}]
["Field 3"]
["Crop","CEC","Phos","Rate",null,"CL","STL","PPM","Bray P1","Phosphorous","Rate","YP","CR",null,null,"Rate","Rate","ML",null,null,null,null,null,null,null,null,null,"CL-P","ML-P","CL-K","ML-K","removal-P2O5","removal-K2O"]
[{"$f":"'Input Information'!$D12","v":0},null,"Build",{"$f":"((F20-G20)*5)+K20","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A20,$Z$19:$AG$25,3,)","v":{"$error":"#N/A"}},{"$f":"IF(I20<1,1,I20)","v":1},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K12/2),'Input Information'!K12)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H20,-8.08+0.832*H20)","v":0},"Maintenance",{"$f":"L20*M20","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$12","v":0},{"$f":"VLOOKUP(A20,$Z$2:$AG$7,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K20-(K20*(G20-(F20+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P20<0,\"0\",P20)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A20,$Z$20:$AG$25,4,)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Input Information'!J12","v":0},{"$f":"IF(-6.7553*V20+46.8098<0.5,\"0\",-6.7553*V20+46.8098)","v":46.809800000000003},{"$f":"IF(-5.6399*V20+39.1496<0.5,\"0\",-5.6399*V20+39.1496)","v":39.1496},{"$f":"IF(-4.5721*V20+31.7602<0.5,\"0\",-4.5721*V20+31.7602)","v":31.760200000000001},"Corn ","Bu",15,30,{"$f":"75+(2.5*$B$24)","v":75},{"$f":"AD20+30","v":105},0.37,0.27]
[{"$f":"'Input Information'!$D$13","v":0},null,"Build",{"$f":"((F21-G21)*5)+K21","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A21,$Z$19:$AG$25,3,)","v":{"$error":"#N/A"}},1,{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K13/2),'Input Information'!K13)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H21,-8.08+0.832*H21)","v":0},"Maintenance",{"$f":"L21*M21","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$13","v":0},{"$f":"VLOOKUP(A21,$Z$2:$AG$7,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K21-(K21*(G21-(F21+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P21<0,\"0\",P21)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A21,$Z$20:$AG$25,4,)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Corn-Silage","Ton",15,30,{"$f":"75+(2.5*$B$24)","v":75},{"$f":"AD21+30","v":105},3.3,8]
[{"$f":"'Input Information'!$D$14","v":0},null,"Build",{"$f":"((F22-G22)*5)+K22","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A22,$Z$19:$AG$25,3,)","v":{"$error":"#N/A"}},1,{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K14/2),'Input Information'!K14)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H22,-8.08+0.832*H22)","v":0},"Maintenance",{"$f":"L22*M22","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$14","v":0},{"$f":"VLOOKUP(A22,$Z$2:$AG$7,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K22-(K22*(G22-(F22+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P22<0,\"0\",P22)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A22,$Z$20:$AG$25,4,)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Soybeans","Bu",15,30,75,105,0.8,1.4]
[null,null,"Pot","Rate",null,null,null,null,null,"Potassium","Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheat (Grain Only)","Bu",25,40,75,105,0.63,0.37]
[{"$f":"'Input Information'!$D$12","v":0},{"$f":"'Input Information'!$H$12","v":0},"Build",{"$f":"((F24-G24)*((1+(0.05*B24)))+(K24))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D12=\"Alfalfa\",G24<=Calc!F24),AND('Input Information'!D12=\"Corn-Silage\",G24<=Calc!F24)),IF(D24>300,\"300\",D24),D24)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A24,$Z$19:$AG$25,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L12/2),'Input Information'!L12)","v":0},null,null,"Maintenance",{"$f":"(L24*M24)+N24","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$12","v":0},{"$f":"VLOOKUP(A24,$Z$2:$AG$7,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K24-(K24*(G24-(F24+30))/20)","v":{"$error":"#N/A"}},{"$f":"IF(P24<0,\"0\",P24)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A24,$Z$20:$AG$25,6,)","v":{"$error":"#N/A"}},{"$f":"K24-(K24*(G24-F24)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S24<0,\"0\",S24)","v":{"$error":"#N/A"}},null,null,null,null,null,"Wheat (Grain & Straw)","Bu",25,40,75,105,0.72,1.28]
[{"$f":"'Input Information'!$D$13","v":0},{"$f":"'Input Information'!$H$12","v":0},"Build",{"$f":"((F25-G25)*((1+(0.05*B25)))+(K25))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D13=\"Alfalfa\",G25<=Calc!F25),AND('Input Information'!D13=\"Corn-Silage\",G25<=Calc!F25)),IF(D25>300,\"300\",D25),D25)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A25,$Z$19:$AG$25,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L13/2),'Input Information'!L13)","v":0},null,null,"Maintenance",{"$f":"(L25*M25)+N25","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$13","v":0},{"$f":"VLOOKUP(A25,$Z$2:$AG$7,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K25-((K25*(G25-(F25+30))/20))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"VLOOKUP(A25,$Z$20:$AG$25,6,)","v":{"$error":"#N/A"}},{"$f":"K25-(K25*(G25-F25)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S25<0,\"0\",S25)","v":{"$error":"#N/A"}},null,null,null,null,null,"Alfalfa","Ton",25,40,75,105,13,50]
[{"$f":"'Input Information'!$D$14","v":0},{"$f":"'Input Information'!$H$12","v":0},"Build",{"$f":"((F26-G26)*((1+(0.05*B26)))+(K26))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D14=\"Alfalfa\",G26<=Calc!F26),AND('Input Information'!D14=\"Corn-Silage\",G26<=Calc!F26)),IF(D26>300,\"300\",D26),D26)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L14/2),'Input Information'!L14)","v":0},null,null,"Maintenance",{"$error":"#N/A"},{"$f":"'Input Information'!$F$14","v":0},{"$f":"VLOOKUP(A26,$Z$2:$AG$7,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K26-((K26*(G26-(F26+30))/20))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"VLOOKUP(A26,$Z$20:$AG$25,6,)","v":{"$error":"#N/A"}},{"$f":"K26-(K26*(G26-F26)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S26<0,\"0\",IF(S26>300,\"300\",S26))","v":{"$error":"#N/A"}}]
["Field 4"]
["Crop","CEC","Phos","Rate",null,"CL","STL","PPM","Bray P1","Phosphorous","Rate","YP","CR",null,null,"Rate","Rate","ML",null,null,null,null,null,null,null,null,null,"CL-P","ML-P","CL-K","ML-K","removal-P2O5","removal-K2O"]
[{"$f":"'Input Information'!$D$16","v":0},null,"Build",{"$f":"((F29-G29)*5)+K29","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A29,$Z$28:$AG$34,3,)","v":{"$error":"#N/A"}},{"$f":"IF(I29<1,1,I29)","v":1},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K16/2),'Input Information'!K16)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H29,-8.08+0.832*H29)","v":0},"Maintenance",{"$f":"L29*M29","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$16","v":0},{"$f":"VLOOKUP(A29,$Z$29:$AG$34,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K29-(K29*(G29-(F29+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P29<0,\"0\",P29)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A29,$Z$29:$AG$34,4,)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Input Information'!J16","v":0},{"$f":"IF(-6.7553*V29+46.8098<0.5,\"0\",-6.7553*V29+46.8098)","v":46.809800000000003},{"$f":"IF(-5.6399*V29+39.1496<0.5,\"0\",-5.6399*V29+39.1496)","v":39.1496},{"$f":"IF(-4.5721*V29+31.7602<0.5,\"0\",-4.5721*V29+31.7602)","v":31.760200000000001},"Corn ","Bu",15,30,{"$f":"75+(2.5*$B$33)","v":75},{"$f":"AD29+30","v":105},0.37,0.27]
[{"$f":"'Input Information'!$D$17","v":0},null,"Build",{"$f":"((F30-G30)*5)+K30","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A30,$Z$28:$AG$34,3,)","v":{"$error":"#N/A"}},1,{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K17/2),'Input Information'!K17)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H30,-8.08+0.832*H30)","v":0},"Maintenance",{"$f":"L30*M30","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$17","v":0},{"$f":"VLOOKUP(A30,$Z$29:$AG$34,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K30-(K30*(G30-(F30+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P30<0,\"0\",P30)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A30,$Z$29:$AG$34,4,)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Corn-Silage","Ton",15,30,{"$f":"75+(2.5*$B$33)","v":75},{"$f":"AD30+30","v":105},3.3,8]
[{"$f":"'Input Information'!$D$18","v":0},null,"Build",{"$f":"((F31-G31)*5)+K31","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A31,$Z$28:$AG$34,3,)","v":{"$error":"#N/A"}},1,{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K18/2),'Input Information'!K18)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H31,-8.08+0.832*H31)","v":0},"Maintenance",{"$f":"L31*M31","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$18","v":0},{"$f":"VLOOKUP(A31,$Z$29:$AG$34,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K31-(K31*(G31-(F31+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P31<0,\"0\",P31)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A31,$Z$29:$AG$34,4,)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Soybeans","Bu",15,30,75,105,0.8,1.4]
[null,null,"Pot","Rate",null,null,null,null,null,"Potassium","Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheat (Grain Only)","Bu",25,40,75,105,0.63,0.37]
[{"$f":"'Input Information'!$D$16","v":0},{"$f":"'Input Information'!$H$16","v":0},"Build",{"$f":"((F33-G33)*((1+(0.05*B33)))+(K33))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D16=\"Alfalfa\",G33<=Calc!F33),AND('Input Information'!D16=\"Corn-Silage\",G33<=Calc!F33)),IF(D33>300,\"300\",D33),D33)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A33,$Z$28:$AG$34,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L16/2),'Input Information'!L16)","v":0},null,null,"Maintenance",{"$f":"(L33*M33)+N33","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$16","v":0},{"$f":"VLOOKUP(A33,$Z$29:$AG$34,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K33-(K33*(G33-(F33+30))/20)","v":{"$error":"#N/A"}},{"$f":"IF(P33<0,\"0\",P33)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A33,$Z$29:$AG$34,6,)","v":{"$error":"#N/A"}},{"$f":"K33-(K33*(G33-F33)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S33<0,\"0\",S33)","v":{"$error":"#N/A"}},null,null,null,null,null,"Wheat (Grain & Straw)","Bu",25,40,75,105,0.72,1.28]
[{"$f":"'Input Information'!$D$17","v":0},{"$f":"'Input Information'!$H$16","v":0},"Build",{"$f":"((F34-G34)*((1+(0.05*B34)))+(K34))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D22=\"Alfalfa\",G34<=Calc!F34),AND('Input Information'!D22=\"Corn-Silage\",G34<=Calc!F34)),IF(D34>300,\"300\",D34),D34)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A34,$Z$28:$AG$34,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L17/2),'Input Information'!L17)","v":0},null,null,"Maintenance",{"$f":"(L34*M34)+N34","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$17","v":0},{"$f":"VLOOKUP(A34,$Z$29:$AG$34,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K34-((K34*(G34-(F34+30))/20))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"VLOOKUP(A34,$Z$29:$AG$34,6,)","v":{"$error":"#N/A"}},{"$f":"K34-(K34*(G34-F34)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S34<0,\"0\",S34)","v":{"$error":"#N/A"}},null,null,null,null,null,"Alfalfa","Ton",25,40,75,105,13,50]
[{"$f":"'Input Information'!$D$18","v":0},{"$f":"'Input Information'!$H$16","v":0},"Build",{"$f":"((F35-G35)*((1+(0.05*B35)))+(K35))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D18=\"Alfalfa\",G35<=Calc!F35),AND('Input Information'!D18=\"Corn-Silage\",G35<=Calc!F35)),IF(D35>300,\"300\",D35),D35)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A35,$Z$28:$AG$34,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L18/2),'Input Information'!L18)","v":0},null,null,"Maintenance",{"$error":"#N/A"},{"$f":"'Input Information'!$F$18","v":0},{"$f":"VLOOKUP(A35,$Z$29:$AG$34,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K35-((K35*(G35-(F35+30))/20))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"VLOOKUP(A35,$Z$29:$AG$34,6,)","v":{"$error":"#N/A"}},{"$f":"K35-(K35*(G35-F35)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S35<0,\"0\",IF(S35>300,\"300\",S35))","v":{"$error":"#N/A"}}]
["Field 5"]
["Crop","CEC","Phos","Rate",null,"CL","STL","PPM","Bray P1","Phosphorous","Rate","YP","CR",null,null,"Rate","Rate","ML",null,null,null,null,null,null,null,null,null,"CL-P","ML-P","CL-K","ML-K","removal-P2O5","removal-K2O"]
[{"$f":"'Input Information'!$D$20","v":0},null,"Build",{"$f":"((F38-G38)*5)+K38","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A38,$Z$37:$AG$43,3,)","v":{"$error":"#N/A"}},{"$f":"IF(I38<1,1,I38)","v":1},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K20/2),'Input Information'!K20)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H38,-8.08+0.832*H38)","v":0},"Maintenance",{"$f":"L38*M38","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$20","v":0},{"$f":"VLOOKUP(A38,$Z$2:$AG$7,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K38-(K38*(G38-(F38+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P38<0,\"0\",P38)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A38,$Z$38:$AG$43,4,)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Input Information'!J20","v":0},{"$f":"IF(-6.7553*V38+46.8098<0.5,\"0\",-6.7553*V38+46.8098)","v":46.809800000000003},{"$f":"IF(-5.6399*V38+39.1496<0.5,\"0\",-5.6399*V38+39.1496)","v":39.1496},{"$f":"IF(-4.5721*V38+31.7602<0.5,\"0\",-4.5721*V38+31.7602)","v":31.760200000000001},"Corn ","Bu",15,30,{"$f":"75+(2.5*$B$42)","v":75},{"$f":"AD38+30","v":105},0.37,0.27]
[{"$f":"'Input Information'!$D$21","v":0},null,"Build",{"$f":"((F39-G39)*5)+K39","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A39,$Z$37:$AG$43,3,)","v":{"$error":"#N/A"}},1,{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K21/2),'Input Information'!K21)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H39,-8.08+0.832*H39)","v":0},"Maintenance",{"$f":"L39*M39","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$21","v":0},{"$f":"VLOOKUP(A39,$Z$2:$AG$7,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K39-(K39*(G39-(F39+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P39<0,\"0\",P39)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A39,$Z$38:$AG$43,4,)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Corn-Silage","Ton",15,30,{"$f":"75+(2.5*$B$42)","v":75},{"$f":"AD39+30","v":105},3.3,8]
[{"$f":"'Input Information'!$D$22","v":0},null,"Build",{"$f":"((F40-G40)*5)+K40","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A40,$Z$37:$AG$43,3,)","v":{"$error":"#N/A"}},1,{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K22/2),'Input Information'!K22)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H40,-8.08+0.832*H40)","v":0},"Maintenance",{"$f":"L40*M40","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$22","v":0},{"$f":"VLOOKUP(A40,$Z$2:$AG$7,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K40-(K40*(G40-(F40+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P40<0,\"0\",P40)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A40,$Z$38:$AG$43,4,)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Soybeans","Bu",15,30,75,105,0.8,1.4]
[null,null,"Pot","Rate",null,null,null,null,null,"Potassium","Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheat (Grain Only)","Bu",25,40,75,105,0.63,0.37]
[{"$f":"'Input Information'!$D$20","v":0},{"$f":"'Input Information'!$H$20","v":0},"Build",{"$f":"((F42-G42)*((1+(0.05*B42)))+(K42))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D20=\"Alfalfa\",G42<=Calc!F42),AND('Input Information'!D20=\"Corn-Silage\",G42<=Calc!F42)),IF(D42>300,\"300\",D42),D42)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A42,$Z$37:$AG$43,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L20/2),'Input Information'!L20)","v":0},null,null,"Maintenance",{"$f":"(L42*M42)+N42","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$20","v":0},{"$f":"VLOOKUP(A42,$Z$38:$AG$43,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K42-(K42*(G42-(F42+30))/20)","v":{"$error":"#N/A"}},{"$f":"IF(P42<0,\"0\",P42)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A42,$Z$38:$AG$43,6,)","v":{"$error":"#N/A"}},{"$f":"K42-(K42*(G42-F42)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S42<0,\"0\",S42)","v":{"$error":"#N/A"}},null,null,null,null,null,"Wheat (Grain & Straw)","Bu",25,40,75,105,0.72,1.28]
[{"$f":"'Input Information'!$D$21","v":0},{"$f":"'Input Information'!$H$20","v":0},"Build",{"$f":"((F43-G43)*((1+(0.05*B43)))+(K43))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D21=\"Alfalfa\",G43<=Calc!F43),AND('Input Information'!D21=\"Corn-Silage\",G43<=Calc!F43)),IF(D43>300,\"300\",D43),D43)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A43,$Z$37:$AG$43,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L21/2),'Input Information'!L21)","v":0},null,null,"Maintenance",{"$f":"(L43*M43)+N43","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$21","v":0},{"$f":"VLOOKUP(A43,$Z$38:$AG$43,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K43-((K43*(G43-(F43+30))/20))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"VLOOKUP(A43,$Z$38:$AG$43,6,)","v":{"$error":"#N/A"}},{"$f":"K43-(K43*(G43-F43)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S43<0,\"0\",S43)","v":{"$error":"#N/A"}},null,null,null,null,null,"Alfalfa","Ton",25,40,75,105,13,50]
[{"$f":"'Input Information'!$D$22","v":0},{"$f":"'Input Information'!$H$20","v":0},"Build",{"$f":"((F44-G44)*((1+(0.05*B44)))+(K44))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D22=\"Alfalfa\",G44<=Calc!F44),AND('Input Information'!D22=\"Corn-Silage\",G44<=Calc!F44)),IF(D44>300,\"300\",D44),D44)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A44,$Z$37:$AG$43,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L22/2),'Input Information'!L22)","v":0},null,null,"Maintenance",{"$error":"#N/A"},{"$f":"'Input Information'!$F$22","v":0},{"$f":"VLOOKUP(A44,$Z$38:$AG$43,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K44-((K44*(G44-(F44+30))/20))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"VLOOKUP(A44,$Z$38:$AG$43,6,)","v":{"$error":"#N/A"}},{"$f":"K44-(K44*(G44-F44)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S44<0,\"0\",IF(S44>300,\"300\",S44))","v":{"$error":"#N/A"}}]
["Field 6"]
["Crop","CEC","Phos","Rate",null,"CL","STL","PPM","Bray P1","Phosphorous","Rate","YP","CR",null,null,"Rate","Rate","ML",null,null,null,null,null,null,null,null,null,"CL-P","ML-P","CL-K","ML-K","removal-P2O5","removal-K2O"]
[{"$f":"'Input Information'!$D$24","v":0},null,"Build",{"$f":"((F47-G47)*5)+K47","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A47,$Z$46:$AG$52,3,)","v":{"$error":"#N/A"}},{"$f":"IF(I47<1,1,I47)","v":1},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K24/2),'Input Information'!K24)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H47,-8.08+0.832*H47)","v":0},"Maintenance",{"$f":"L47*M47","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$24","v":0},{"$f":"VLOOKUP(A47,$Z$47:$AG$52,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K47-(K47*(G47-(F47+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P47<0,\"0\",P47)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A47,$Z$47:$AG$52,4,)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Input Information'!J24","v":0},{"$f":"IF(-6.7553*V47+46.8098<0.5,\"0\",-6.7553*V47+46.8098)","v":46.809800000000003},{"$f":"IF(-5.6399*V47+39.1496<0.5,\"0\",-5.6399*V47+39.1496)","v":39.1496},{"$f":"IF(-4.5721*V47+31.7602<0.5,\"0\",-4.5721*V47+31.7602)","v":31.760200000000001},"Corn ","Bu",15,30,{"$f":"75+(2.5*$B$51)","v":75},{"$f":"AD47+30","v":105},0.37,0.27]
[{"$f":"'Input Information'!$D$25","v":0},null,"Build",{"$f":"((F48-G48)*5)+K48","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A48,$Z$46:$AG$52,3,)","v":{"$error":"#N/A"}},1,{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K25/2),'Input Information'!K25)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H48,-8.08+0.832*H48)","v":0},"Maintenance",{"$f":"L48*M48","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$25","v":0},{"$f":"VLOOKUP(A48,$Z$47:$AG$52,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K48-(K48*(G48-(F48+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P48<0,\"0\",P48)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A48,$Z$47:$AG$52,4,)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Corn-Silage","Ton",15,30,{"$f":"75+(2.5*$B$51)","v":75},{"$f":"AD48+30","v":105},3.3,8]
[{"$f":"'Input Information'!$D$26","v":0},null,"Build",{"$f":"((F49-G49)*5)+K49","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A49,$Z$46:$AG$52,3,)","v":{"$error":"#N/A"}},1,{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K26/2),'Input Information'!K26)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H49,-8.08+0.832*H49)","v":0},"Maintenance",{"$f":"L49*M49","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$26","v":0},{"$f":"VLOOKUP(A49,$Z$47:$AG$52,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K49-(K49*(G49-(F49+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P49<0,\"0\",P49)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A49,$Z$47:$AG$52,4,)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Soybeans","Bu",15,30,75,105,0.8,1.4]
[null,null,"Pot","Rate",null,null,null,null,null,"Potassium","Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheat (Grain Only)","Bu",25,40,75,105,0.63,0.37]
[{"$f":"'Input Information'!$D$24","v":0},{"$f":"'Input Information'!$H$24","v":0},"Build",{"$f":"((F51-G51)*((1+(0.05*B51)))+(K51))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D24=\"Alfalfa\",G51<=Calc!F51),AND('Input Information'!D24=\"Corn-Silage\",G51<=Calc!F51)),IF(D51>300,\"300\",D51),D51)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A51,$Z$46:$AG$52,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L24/2),'Input Information'!L24)","v":0},null,null,"Maintenance",{"$f":"(L51*M51)+N51","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$24","v":0},{"$f":"VLOOKUP(A51,$Z$47:$AG$52,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K51-(K51*(G51-(F51+30))/20)","v":{"$error":"#N/A"}},{"$f":"IF(P51<0,\"0\",P51)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A51,$Z$47:$AG$52,6,)","v":{"$error":"#N/A"}},{"$f":"K51-(K51*(G51-F51)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S51<0,\"0\",S51)","v":{"$error":"#N/A"}},null,null,null,null,null,"Wheat (Grain & Straw)","Bu",25,40,75,105,0.72,1.28]
[{"$f":"'Input Information'!$D$25","v":0},{"$f":"'Input Information'!$H$24","v":0},"Build",{"$f":"((F52-G52)*((1+(0.05*B52)))+(K52))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D25=\"Alfalfa\",G52<=Calc!F52),AND('Input Information'!D25=\"Corn-Silage\",G52<=Calc!F52)),IF(D52>300,\"300\",D52),D52)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A52,$Z$46:$AG$52,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L25/2),'Input Information'!L25)","v":0},null,null,"Maintenance",{"$f":"(L52*M52)+N52","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$25","v":0},{"$f":"VLOOKUP(A52,$Z$47:$AG$52,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K52-(K52*(G52-(F52+30))/20)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"VLOOKUP(A52,$Z$47:$AG$52,6,)","v":{"$error":"#N/A"}},{"$f":"K52-(K52*(G52-F52)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S52<0,\"0\",S52)","v":{"$error":"#N/A"}},null,null,null,null,null,"Alfalfa","Ton",25,40,75,105,13,50]
[{"$f":"'Input Information'!$D$26","v":0},{"$f":"'Input Information'!$H$24","v":0},"Build",{"$f":"((F53-G53)*((1+(0.05*B53)))+(K53))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D26=\"Alfalfa\",G53<=Calc!F53),AND('Input Information'!D26=\"Corn-Silage\",G53<=Calc!F53)),IF(D53>300,\"300\",D53),D53)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A53,$Z$46:$AG$52,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L26/2),'Input Information'!L26)","v":0},null,null,"Maintenance",{"$error":"#N/A"},{"$f":"'Input Information'!$F$26","v":0},{"$f":"VLOOKUP(A53,$Z$47:$AG$52,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K53-((K53*(G53-(F53+30))/20))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"VLOOKUP(A53,$Z$47:$AG$52,6,)","v":{"$error":"#N/A"}},{"$f":"K53-(K53*(G53-F53)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S53<0,\"0\",IF(S53>300,\"300\",S53))","v":{"$error":"#N/A"}}]
["Field 7"]
["Crop","CEC","Phos","Rate",null,"CL","STL","PPM","Bray P1","Phosphorous","Rate","YP","CR",null,null,"Rate","Rate","ML",null,null,null,null,null,null,null,null,null,"CL-P","ML-P","CL-K","ML-K","removal-P2O5","removal-K2O"]
[{"$f":"'Input Information'!$D$28","v":0},null,"Build",{"$f":"((F56-G56)*5)+K56","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A56,$Z$55:$AG$61,3,)","v":{"$error":"#N/A"}},{"$f":"IF(I56<1,1,I56)","v":1},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K28/2),'Input Information'!K28)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H56,-8.08+0.832*H56)","v":0},"Maintenance",{"$f":"L56*M56","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$28","v":0},{"$f":"VLOOKUP(A56,$Z$56:$AG$61,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K56-(K56*(G56-(F56+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P56<0,\"0\",P56)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A56,$Z$56:$AG$61,4,)","v":{"$error":"#N/A"}},null,null,null,{"$f":"'Input Information'!J28","v":0},{"$f":"IF(-6.7553*V56+46.8098<0.5,\"0\",-6.7553*V56+46.8098)","v":46.809800000000003},{"$f":"IF(-5.6399*V56+39.1496<0.5,\"0\",-5.6399*V56+39.1496)","v":39.1496},{"$f":"IF(-4.5721*V56+31.7602<0.5,\"0\",-4.5721*V56+31.7602)","v":31.760200000000001},"Corn ","Bu",15,30,{"$f":"75+(2.5*$B$60)","v":75},{"$f":"AD56+30","v":105},0.37,0.27]
[{"$f":"'Input Information'!$D$29","v":0},null,"Build",{"$f":"((F57-G57)*5)+K57","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A57,$Z$55:$AG$61,3,)","v":{"$error":"#N/A"}},1,{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K29/2),'Input Information'!K29)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H57,-8.08+0.832*H57)","v":0},"Maintenance",{"$f":"L57*M57","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$29","v":0},{"$f":"VLOOKUP(A57,$Z$56:$AG$61,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K57-(K57*(G57-(F57+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P57<0,\"0\",P57)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A57,$Z$56:$AG$61,4,)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Corn-Silage","Ton",15,30,{"$f":"75+(2.5*$B$60)","v":75},{"$f":"AD57+30","v":105},3.3,8]
[{"$f":"'Input Information'!$D$30","v":0},null,"Build",{"$f":"((F58-G58)*5)+K58","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(A58,$Z$55:$AG$61,3,)","v":{"$error":"#N/A"}},1,{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!K30/2),'Input Information'!K30)","v":0},{"$f":"IF(Introduction!C8=\"Bray 1\",H58,-8.08+0.832*H58)","v":0},"Maintenance",{"$f":"L58*M58","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$30","v":0},{"$f":"VLOOKUP(A58,$Z$56:$AG$61,7,)","v":{"$error":"#N/A"}},null,"Drawdown",{"$f":"K58-(K58*(G58-(F58+15))/10)","v":{"$error":"#N/A"}},{"$f":"IF(P58<0,\"0\",P58)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A58,$Z$56:$AG$61,4,)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,"Soybeans","Bu",15,30,75,105,0.8,1.4]
[null,null,"Pot","Rate",null,null,null,null,null,"Potassium","Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wheat (Grain Only)","Bu",25,40,75,105,0.63,0.37]
[{"$f":"'Input Information'!$D$28","v":0},{"$f":"'Input Information'!$H$28","v":0},"Build",{"$f":"((F60-G60)*((1+(0.05*B60)))+(K60))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D28=\"Alfalfa\",G60<=Calc!F60),AND('Input Information'!D28=\"Corn-Silage\",G60<=Calc!F60)),IF(D60>300,\"300\",D60),D60)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A60,$Z$55:$AG$61,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L28/2),'Input Information'!L28)","v":0},null,null,"Maintenance",{"$f":"(L60*M60)+N60","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$28","v":0},{"$f":"VLOOKUP(A60,$Z$56:$AG$61,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K60-(K60*(G60-(F60+30))/20)","v":{"$error":"#N/A"}},{"$f":"IF(P60<0,\"0\",P60)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A60,$Z$56:$AG$61,6,)","v":{"$error":"#N/A"}},{"$f":"K60-(K60*(G60-F60)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S60<0,\"0\",S60)","v":{"$error":"#N/A"}},null,null,null,null,null,"Wheat (Grain & Straw)","Bu",25,40,75,105,0.72,1.28]
[{"$f":"'Input Information'!$D$29","v":0},{"$f":"'Input Information'!$H$28","v":0},"Build",{"$f":"((F61-G61)*((1+(0.05*B61)))+(K61))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D29=\"Alfalfa\",G61<=Calc!F61),AND('Input Information'!D29=\"Corn-Silage\",G61<=Calc!F61)),IF(D61>300,\"300\",D61),D61)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A61,$Z$55:$AG$61,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L29/2),'Input Information'!L29)","v":0},null,null,"Maintenance",{"$f":"(L61*M61)+N61","v":{"$error":"#N/A"}},{"$f":"'Input Information'!$F$29","v":0},{"$f":"VLOOKUP(A61,$Z$56:$AG$61,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K61-((K61*(G61-(F61+30))/20))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"VLOOKUP(A61,$Z$56:$AG$61,6,)","v":{"$error":"#N/A"}},{"$f":"K61-(K61*(G61-F61)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S61<0,\"0\",S61)","v":{"$error":"#N/A"}},null,null,null,null,null,"Alfalfa","Ton",25,40,75,105,13,50]
[{"$f":"'Input Information'!$D$30","v":0},{"$f":"'Input Information'!$H$28","v":0},"Build",{"$f":"((F62-G62)*((1+(0.05*B62)))+(K62))","v":{"$error":"#N/A"}},{"$f":"IF(OR(AND('Input Information'!D30=\"Alfalfa\",G62<=Calc!F62),AND('Input Information'!D30=\"Corn-Silage\",G62<=Calc!F62)),IF(D62>300,\"300\",D62),D62)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A62,$Z$55:$AG$61,5,)","v":{"$error":"#N/A"}},{"$f":"IF(Introduction!C7=\"pounds per acre\",('Input Information'!L30/2),'Input Information'!L30)","v":0},null,null,"Maintenance",{"$error":"#N/A"},{"$f":"'Input Information'!$F$30","v":0},{"$f":"VLOOKUP(A62,$Z$56:$AG$61,8,)","v":{"$error":"#N/A"}},20,"Drawdown",{"$f":"K62-((K62*(G62-(F62+30))/20))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"VLOOKUP(A62,$Z$56:$AG$61,6,)","v":{"$error":"#N/A"}},{"$f":"K62-(K62*(G62-F62)/50)","v":{"$error":"#N/A"}},{"$f":"IF(S62<0,\"0\",IF(S62>300,\"300\",S62))","v":{"$error":"#N/A"}}]