{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["ReadMe-Orientation","Fields","Inputs","By-Field","FertCosts"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":1,"defined_names":118,"comments":4,"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":"ReadMe-Orientation","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Author","Dennis Buckmaster, Professor & Dean's Fellow for Digital Agriculture"]
["Affiliation","Purdue University, Department of Agricultural & Biological Engineering"]
["Date","November 2020, updated December, 2021"]
["URL to acquire",null,"https://engineering.purdue.edu/~dbuckmas/outreach/PCP.xlsm"]
["Orientation video",null,"https://youtu.be/s5aUeZfmozI"]
["Brief site post",null,"https://ag.purdue.edu/digital-ag-resources/?p=7463"]
["Related tools:","Fertilizer tools",null,null,"https://engineering.purdue.edu/~dbuckmas/outreach/Fertilizer_tools.xlsx"]
[null,"Phosphorus cost comparison",null,null,"https://engineering.purdue.edu/~dbuckmas/outreach/Purdue_Phosphorus_Cost_Calculator.xlsx"]
[]
["You should read ALL of the panels on this page to use this tool to its fullest potential."]

{"sheet":"Fields","index":1,"n_rows":73,"n_cols":15,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["FIELDS LIST",null,null,"Optional information for record keeping …"]
["Index","Label","Area","NCPI","Owned or Rented","Coordinate","Map link","Plant Date","Spray date 1","Spray date 2","Harvest Date","MC at harvest","Soil sample date","Misc. notes","Boundary"]
[null,null,"(ac)","(index)","(1 owned, 0 rented)","(GPS of center)",null,null,null,null,null,null,null,null,"(GeoJSON)"]
[1,"testing123_123",123,95,1,"40.46842546569507, -86.99335322285127","https://www.google.com/maps/place/40%C2%B028'06.2%22N+86%C2%B059'35.1%22W/@40.4684051,-86.9952737,850m/data=!3m2!1e3!4b1!4m6!3m5!1s0x0:0x0!7e2!8m2!3d40.4684006!4d-86.9930853","2020-04-30","2020-03-15","5.20/20","2020-10-15",18]
[2,"north40_40",40,108,1]
[3,"back20a_15",15,100,1]
[4,"back20b_5",5,120,1]
[5,"Big1_244",244,98,1]
[6,"Jones_35",35,110,0]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]

{"sheet":"Inputs","index":2,"n_rows":153,"n_cols":12,"rows_kept":153,"cut":false,"hidden":false,"merged":[]}
["SEEDS LIST",null,null,null,null,null,null,null,null,null,"Tallying the needs"]
["Index","Label","Price","Rate","Cost","Maturity Info 1","Maturity Info 2","Treatment",null,null,"Area","Amount"]
[null,null,"($/100000 seeds)","(seeds/ac)","($/ac)","(GDD to blacklayer or Maturity Group)","(GDD to silking or GDD to full maturity)",null,null,null,"(ac)","(100K seeds)"]
[1,"Becks1_30_I",300,30000,{"$f":"C4/100000*D4","v":90},2200,1300,"Ilevo",null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B4,'By-Field'!$D$49:$F$49)","v":40},{"$f":"K4*D4/100000","v":12}]
[2,"Becks1-25_I",300,25000,75,2200,1300,"Ilevo",null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B5,'By-Field'!$D$49:$F$49)","v":0},0]
[3,"Xpensive2_32_N",425,32000,136,2600,1600,"Neo",null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B6,'By-Field'!$D$49:$F$49)","v":0},0]
[4,"Xpensive2-28_N",425,28000,119.00000000000001,2600,1600,"Neo",null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B7,'By-Field'!$D$49:$F$49)","v":244},68.319999999999993]
[5,"Xpensive2_32",400,32000,128,2600,1600,"none",null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B8,'By-Field'!$D$49:$F$49)","v":0},0]
[5,"Xpensive2-28",400,28000,112,2600,1600,"none",null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B9,'By-Field'!$D$49:$F$49)","v":0},0]
[7,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B10,'By-Field'!$D$49:$F$49)","v":0},0]
[8,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B11,'By-Field'!$D$49:$F$49)","v":0},0]
[9,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B12,'By-Field'!$D$49:$F$49)","v":0},0]
[10,"Beans1",100,80000,80,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B13,'By-Field'!$D$49:$F$49)","v":0},0]
[11,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B14,'By-Field'!$D$49:$F$49)","v":0},0]
[12,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B15,'By-Field'!$D$49:$F$49)","v":0},0]
[13,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B16,'By-Field'!$D$49:$F$49)","v":0},0]
[14,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B17,'By-Field'!$D$49:$F$49)","v":0},0]
[15,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B18,'By-Field'!$D$49:$F$49)","v":0},0]
[16,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B19,'By-Field'!$D$49:$F$49)","v":0},0]
[17,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B20,'By-Field'!$D$49:$F$49)","v":0},0]
[18,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B21,'By-Field'!$D$49:$F$49)","v":0},0]
[19,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B22,'By-Field'!$D$49:$F$49)","v":0},0]
[20,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B23,'By-Field'!$D$49:$F$49)","v":0},0]
[21,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B24,'By-Field'!$D$49:$F$49)","v":0},0]
[22,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B25,'By-Field'!$D$49:$F$49)","v":0},0]
[23,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B26,'By-Field'!$D$49:$F$49)","v":0},0]
[24,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B27,'By-Field'!$D$49:$F$49)","v":0},0]
[25,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B28,'By-Field'!$D$49:$F$49)","v":0},0]
[26,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B29,'By-Field'!$D$49:$F$49)","v":0},0]
[27,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B30,'By-Field'!$D$49:$F$49)","v":0},0]
[28,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B31,'By-Field'!$D$49:$F$49)","v":0},0]
[29,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B32,'By-Field'!$D$49:$F$49)","v":0},0]
[30,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$15:$E$15,\"=\"&Inputs!B33,'By-Field'!$D$49:$F$49)","v":0},0]
[]
[]
[]
[]
[]
[]
[]
["FERTILIZER LIST",null,"See \"FertCosts\" sheet to determine which types and rates would economically meet nutrient goals.",null,null,null,null,null,null,null,"Tallying the needs"]
["Index","Label","Price","Rate","Cost","N","P2O5","K20","S",null,"Area","Amount"]
[null,null,"($/ton)","(lb/ac)","($/ac)","(%)","(%)","(%)","(%)",null,"(ac)","(tons)"]
[1,"nul - nothing",0,0,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B44,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B44,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B44,'By-Field'!$D$49:$F$49)","v":0},{"$f":"K44*D44/2000","v":0}]
[2,"82-0-0-0_120",800,120,{"$f":"D45*C45/2000","v":48},82,0,0,0,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B45,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B45,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B45,'By-Field'!$D$49:$F$49)","v":0},0]
[3,"82-0-0-0_150",800,150,60,82,0,0,0,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B46,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B46,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B46,'By-Field'!$D$49:$F$49)","v":284},21.3]
[4,"18-46-0-0_40",600,40,12,18,46,0,0,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B47,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B47,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B47,'By-Field'!$D$49:$F$49)","v":0},0]
[5,"18-46-0-0_60",600,60,18,18,46,0,0,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B48,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B48,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B48,'By-Field'!$D$49:$F$49)","v":289},8.67]
[6,"0-0-60-0_50",602,50,15.05,0,0,60,0,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B49,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B49,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B49,'By-Field'!$D$49:$F$49)","v":5},0.125]
[7,"28-0-0-0_70",360,70,12.6,28,0,0,0,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B50,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B50,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B50,'By-Field'!$D$49:$F$49)","v":284},9.94]
[8,"46-0-0-0_40",550,40,11,46,0,0,0,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B51,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B51,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B51,'By-Field'!$D$49:$F$49)","v":0},0]
[9,"0-0-0-17_20",58,20,0.57999999999999996,0,0,0,17,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B52,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B52,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B52,'By-Field'!$D$49:$F$49)","v":0},0]
[10,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B53,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B53,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B53,'By-Field'!$D$49:$F$49)","v":0},0]
[11,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B54,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B54,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B54,'By-Field'!$D$49:$F$49)","v":0},0]
[12,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B55,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B55,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B55,'By-Field'!$D$49:$F$49)","v":0},0]
[13,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B56,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B56,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B56,'By-Field'!$D$49:$F$49)","v":0},0]
[14,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B57,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B57,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B57,'By-Field'!$D$49:$F$49)","v":0},0]
[15,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B58,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B58,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B58,'By-Field'!$D$49:$F$49)","v":0},0]
[16,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B59,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B59,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B59,'By-Field'!$D$49:$F$49)","v":0},0]
[17,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B60,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B60,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B60,'By-Field'!$D$49:$F$49)","v":0},0]
[18,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B61,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B61,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B61,'By-Field'!$D$49:$F$49)","v":0},0]
[19,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B62,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B62,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B62,'By-Field'!$D$49:$F$49)","v":0},0]
[20,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B63,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B63,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B63,'By-Field'!$D$49:$F$49)","v":0},0]
[21,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B64,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B64,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B64,'By-Field'!$D$49:$F$49)","v":0},0]
[22,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B65,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B65,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B65,'By-Field'!$D$49:$F$49)","v":0},0]
[23,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B66,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B66,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B66,'By-Field'!$D$49:$F$49)","v":0},0]
[24,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B67,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B67,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B67,'By-Field'!$D$49:$F$49)","v":0},0]
[25,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B68,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B68,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B68,'By-Field'!$D$49:$F$49)","v":0},0]
[26,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B69,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B69,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B69,'By-Field'!$D$49:$F$49)","v":0},0]
[27,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B70,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B70,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B70,'By-Field'!$D$49:$F$49)","v":0},0]
[28,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B71,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B71,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B71,'By-Field'!$D$49:$F$49)","v":0},0]
[29,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B72,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B72,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B72,'By-Field'!$D$49:$F$49)","v":0},0]
[30,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$16:$E$16,\"=\"&Inputs!B73,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$17:$F$17,\"=\"&Inputs!B73,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$18:$F$18,\"=\"&Inputs!B73,'By-Field'!$D$49:$F$49)","v":0},0]
[]
[]
[]
[]
[]
[]
[]
["HERBICIDE LIST",null,null,null,null,null,null,null,null,null,"Tallying the needs"]
["Index","Label","Price","Rate","Cost",null,null,null,null,null,"Area","Amount"]
[null,null,"($/gal)","(pt/ac)","($/ac)",null,null,null,null,null,"(ac)","(gal)"]
[1,"nul - nothing",0,0,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B84,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B84,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B84,'By-Field'!$D$49:$F$49)","v":578},{"$f":"K84*D84/8","v":0}]
[2,"Herb1_1",80,2,{"$f":"C85/8*D85","v":20},null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B85,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B85,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B85,'By-Field'!$D$49:$F$49)","v":289},72.25]
[3,"Herb1_1.5",80,1.5,{"$f":"C86/8*D86","v":15},null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B86,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B86,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B86,'By-Field'!$D$49:$F$49)","v":0},0]
[4,"Herb 3",60,2,{"$f":"C87/8*D87","v":15},null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B87,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B87,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B87,'By-Field'!$D$49:$F$49)","v":0},0]
[5,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B88,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B88,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B88,'By-Field'!$D$49:$F$49)","v":0},0]
[6,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B89,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B89,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B89,'By-Field'!$D$49:$F$49)","v":0},0]
[7,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B90,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B90,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B90,'By-Field'!$D$49:$F$49)","v":0},0]
[8,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B91,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B91,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B91,'By-Field'!$D$49:$F$49)","v":0},0]
[9,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B92,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B92,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B92,'By-Field'!$D$49:$F$49)","v":0},0]
[10,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B93,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B93,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B93,'By-Field'!$D$49:$F$49)","v":0},0]
[11,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B94,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B94,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B94,'By-Field'!$D$49:$F$49)","v":0},0]
[12,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B95,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B95,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B95,'By-Field'!$D$49:$F$49)","v":0},0]
[13,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B96,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B96,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B96,'By-Field'!$D$49:$F$49)","v":0},0]
[14,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B97,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B97,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B97,'By-Field'!$D$49:$F$49)","v":0},0]
[15,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B98,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B98,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B98,'By-Field'!$D$49:$F$49)","v":0},0]
[16,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B99,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B99,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B99,'By-Field'!$D$49:$F$49)","v":0},0]
[17,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B100,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B100,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B100,'By-Field'!$D$49:$F$49)","v":0},0]
[18,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B101,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B101,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B101,'By-Field'!$D$49:$F$49)","v":0},0]
[19,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B102,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B102,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B102,'By-Field'!$D$49:$F$49)","v":0},0]
[20,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B103,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B103,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B103,'By-Field'!$D$49:$F$49)","v":0},0]
[21,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B104,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B104,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B104,'By-Field'!$D$49:$F$49)","v":0},0]
[22,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B105,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B105,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B105,'By-Field'!$D$49:$F$49)","v":0},0]
[23,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B106,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B106,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B106,'By-Field'!$D$49:$F$49)","v":0},0]
[24,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B107,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B107,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B107,'By-Field'!$D$49:$F$49)","v":0},0]
[25,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B108,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B108,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B108,'By-Field'!$D$49:$F$49)","v":0},0]
[26,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B109,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B109,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B109,'By-Field'!$D$49:$F$49)","v":0},0]
[27,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B110,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B110,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B110,'By-Field'!$D$49:$F$49)","v":0},0]
[28,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B111,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B111,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B111,'By-Field'!$D$49:$F$49)","v":0},0]
[29,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B112,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B112,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B112,'By-Field'!$D$49:$F$49)","v":0},0]
[30,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$20:$F$20,\"=\"&Inputs!B113,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$21:$F$21,\"=\"&Inputs!B113,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$22:$F$22,\"=\"&Inputs!B113,'By-Field'!$D$49:$F$49)","v":0},0]
[]
[]
[]
[]
[]
[]
[]
["INSECTICIDE LIST",null,null,null,null,null,null,null,null,null,"Tallying the needs"]
["Index","Label","Price","Rate","Cost",null,null,null,null,null,"Area","Amount"]
[null,null,"($/gal)","(pt/ac)","($/ac)",null,null,null,null,null,"(ac)","(gal)"]
[1,"nul - nothing",0,0,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$23:$F$23,\"=\"&Inputs!B124,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$24:$F$24,\"=\"&Inputs!B124,'By-Field'!$D$49:$F$49)","v":5},{"$f":"K124*D124/8","v":0}]
[2,"Inse1_.5",80,0.5,{"$f":"C125/8*D125","v":5},null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$23:$F$23,\"=\"&Inputs!B125,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$24:$F$24,\"=\"&Inputs!B125,'By-Field'!$D$49:$F$49)","v":289},18.0625]
[3,"Inse1_1",80,1,{"$f":"C126/8*D126","v":10},null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$23:$F$23,\"=\"&Inputs!B126,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$24:$F$24,\"=\"&Inputs!B126,'By-Field'!$D$49:$F$49)","v":284},35.5]
[4,null,null,null,{"$f":"C127/8*D127","v":0},null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$23:$F$23,\"=\"&Inputs!B127,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$24:$F$24,\"=\"&Inputs!B127,'By-Field'!$D$49:$F$49)","v":0},0]
[5,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$23:$F$23,\"=\"&Inputs!B128,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$24:$F$24,\"=\"&Inputs!B128,'By-Field'!$D$49:$F$49)","v":0},0]
[6,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$23:$F$23,\"=\"&Inputs!B129,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$24:$F$24,\"=\"&Inputs!B129,'By-Field'!$D$49:$F$49)","v":0},0]
[7,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$23:$F$23,\"=\"&Inputs!B130,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$24:$F$24,\"=\"&Inputs!B130,'By-Field'!$D$49:$F$49)","v":0},0]
[8,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$23:$F$23,\"=\"&Inputs!B131,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$24:$F$24,\"=\"&Inputs!B131,'By-Field'!$D$49:$F$49)","v":0},0]
[9,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$23:$F$23,\"=\"&Inputs!B132,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$24:$F$24,\"=\"&Inputs!B132,'By-Field'!$D$49:$F$49)","v":0},0]
[10,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$23:$F$23,\"=\"&Inputs!B133,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$24:$F$24,\"=\"&Inputs!B133,'By-Field'!$D$49:$F$49)","v":0},0]
[]
[]
[]
[]
[]
[]
[]
["FUNGICIDE LIST",null,null,null,null,null,null,null,null,null,"Tallying the needs"]
["Index","Label","Price","Rate","Cost",null,null,null,null,null,"Area","Amount"]
[null,null,"($/lb)","(oz/ac)","($/ac)",null,null,null,null,null,"(ac)","(lb)"]
[1,"nul - nothing",0,0,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$25:$F$25,\"=\"&Inputs!B144,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$26:$F$26,\"=\"&Inputs!B144,'By-Field'!$D$49:$F$49)","v":0},{"$f":"K144*D144/16","v":0}]
[2,"Fung_1",80,2,{"$f":"C145/16*D145","v":10},null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$25:$F$25,\"=\"&Inputs!B145,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$26:$F$26,\"=\"&Inputs!B145,'By-Field'!$D$49:$F$49)","v":289},36.125]
[3,"Fung_2",70,1,4.375,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$25:$F$25,\"=\"&Inputs!B146,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$26:$F$26,\"=\"&Inputs!B146,'By-Field'!$D$49:$F$49)","v":289},18.0625]
[4,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$25:$F$25,\"=\"&Inputs!B147,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$26:$F$26,\"=\"&Inputs!B147,'By-Field'!$D$49:$F$49)","v":0},0]
[5,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$25:$F$25,\"=\"&Inputs!B148,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$26:$F$26,\"=\"&Inputs!B148,'By-Field'!$D$49:$F$49)","v":0},0]
[6,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$25:$F$25,\"=\"&Inputs!B149,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$26:$F$26,\"=\"&Inputs!B149,'By-Field'!$D$49:$F$49)","v":0},0]
[7,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$25:$F$25,\"=\"&Inputs!B150,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$26:$F$26,\"=\"&Inputs!B150,'By-Field'!$D$49:$F$49)","v":0},0]
[8,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$25:$F$25,\"=\"&Inputs!B151,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$26:$F$26,\"=\"&Inputs!B151,'By-Field'!$D$49:$F$49)","v":0},0]
[9,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$25:$F$25,\"=\"&Inputs!B152,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$26:$F$26,\"=\"&Inputs!B152,'By-Field'!$D$49:$F$49)","v":0},0]
[10,null,null,null,0,null,null,null,null,null,{"$f":"SUMIF('By-Field'!$D$25:$F$25,\"=\"&Inputs!B153,'By-Field'!$D$49:$F$49) + SUMIF('By-Field'!$D$26:$F$26,\"=\"&Inputs!B153,'By-Field'!$D$49:$F$49)","v":0},0]

{"sheet":"By-Field","index":3,"n_rows":109,"n_cols":7,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
["INPUTS",null,false]
["FIELD"]
["N","name"," -- ","Big1_244","north40_40","back20b_5"]
[]
["INCOME"]
["Y","yield goal","bu/ac",180,177,180]
["SP","selling price","$/bu",3.33,3.33,3.33]
["CCB","cover crops income","$/ac",0,0,0]
["OI_1","other income 1","$/ac",2,2,2]
["OI_2","other income 2","$/ac",0,0,0]
[]
["COSTS"]
["Crop Inputs"]
["LC","land cost","$/ac",180,150,150]
["WS","which seed"," -- ","Xpensive2-28_N","Becks1_30_I","Xpensive2-28"]
["WF_1","which fertilizer1"," -- ","82-0-0-0_150","82-0-0-0_150","82-0-0-0_150"]
["WF_2","which fertilizer 2"," -- ","18-46-0-0_60","18-46-0-0_60","0-0-60-0_50"]
["WF_3","which fertilizer 3"," -- ","28-0-0-0_70","28-0-0-0_70","18-46-0-0_60"]
["WF_4","which fertilizer 4","--","0-0-0-17_20","nul - nothing","nul - nothing"]
["WHC_1","which herbicide 1"," -- ","nul - nothing","nul - nothing","nul - nothing"]
["WHC_2","which herbicide 2"," -- ","Herb1_1","Herb1_1","Herb1_1"]
["WHC_3","which herbicide 3"," -- ","nul - nothing","nul - nothing","nul - nothing"]
["WIC_1","which insecticide 1"," -- ","Inse1_.5","Inse1_.5","Inse1_.5"]
["WIC_2","which insecticide 2"," -- ","Inse1_1","Inse1_1","nul - nothing"]
["WFC_1","which fungicide 1"," -- ","Fung_1","Fung_1","Fung_1"]
["WFC_2","which fungicide 2"," -- ","Fung_2","Fung_2","Fung_2"]
["CI","crop insurance","$/ac",4.4400000000000004,4.4400000000000004,4.4400000000000004]
["S","scouting","$/ac",6,6,6]
["OMI","other misc. inputs","$/ac",0.02,0.02,0.02]
["Cover Crops"]
["CCS","cover crops seed","$/ac"]
["CCP","cover crops planting","$/ac"]
["CCT","cover crops termination","$/ac"]
["Water Management"]
["DRI","drainage repair or improvement","$/ac"]
["IR","irrigation cost","$/ac"]
["Machinery"]
["T","tillage","$/ac",25,0,25]
["P","planting","$/ac",22,22,22]
["SS","spraying/spreading","$/ac",20,20,20]
["H","harvest","$/ac",29,29,29]
["OM","other machinery operations","$/ac",8,8,8]
["Post harvest"]
["DC","drying cost","$/bu",0.05,0.04,0.02]
["SC","storage cost","$/bu",0.2,0.11,0.1]
["TC","transport cost","$/bu",0.12,0.2,0.2]
[]
["COMPUTED:"]
["A","area","ac",{"$f":"VLOOKUP(N,fields,2,FALSE)","v":244},{"$f":"VLOOKUP(N,fields,2,FALSE)","v":40},{"$f":"VLOOKUP(N,fields,2,FALSE)","v":5}]
["Components of cost"]
["SEC","seed cost","$/ac",{"$f":"VLOOKUP(WS,seeds,4,FALSE)","v":119.00000000000001},{"$f":"VLOOKUP(WS,seeds,4,FALSE)","v":90},{"$f":"VLOOKUP(WS,seeds,4,FALSE)","v":112},"=VLOOKUP(WS,seeds,4,FALSE)"]
["FTC","fertilizer cost","$/ac",{"$f":"VLOOKUP(WF_1,ferts,4,FALSE)+VLOOKUP(WF_2,ferts,4,FALSE)+VLOOKUP(WF_3,ferts,4,FALSE)+VLOOKUP(WF_4,ferts,4,FALSE)","v":91.179999999999993},{"$f":"VLOOKUP(WF_1,ferts,4,FALSE)+VLOOKUP(WF_2,ferts,4,FALSE)+VLOOKUP(WF_3,ferts,4,FALSE)+VLOOKUP(WF_4,ferts,4,FALSE)","v":90.6},{"$f":"VLOOKUP(WF_1,ferts,4,FALSE)+VLOOKUP(WF_2,ferts,4,FALSE)+VLOOKUP(WF_3,ferts,4,FALSE)+VLOOKUP(WF_4,ferts,4,FALSE)","v":93.05},"=VLOOKUP(WF_1,ferts,4,FALSE)+VLOOKUP(WF_2,ferts,4,FALSE)+VLOOKUP(WF_3,ferts,4,FALSE)+VLOOKUP(WF_4,ferts,4,FALSE)"]
["HC","herbicide cost","$/ac",{"$f":"VLOOKUP(WHC_1,hcides,4,FALSE)+VLOOKUP(WHC_2,hcides,4,FALSE)+VLOOKUP(WHC_3,hcides,4,FALSE)","v":20},{"$f":"VLOOKUP(WHC_1,hcides,4,FALSE)+VLOOKUP(WHC_2,hcides,4,FALSE)+VLOOKUP(WHC_3,hcides,4,FALSE)","v":20},{"$f":"VLOOKUP(WHC_1,hcides,4,FALSE)+VLOOKUP(WHC_2,hcides,4,FALSE)+VLOOKUP(WHC_3,hcides,4,FALSE)","v":20},"=VLOOKUP(WHC_1,hcides,4,FALSE)+VLOOKUP(WHC_2,hcides,4,FALSE)+VLOOKUP(WHC_3,hcides,4,FALSE)"]
["IC","insecticide cost","$/ac",{"$f":"VLOOKUP(WIC_1,icides,4,FALSE) + VLOOKUP(WIC_2,icides,4,FALSE)","v":15},{"$f":"VLOOKUP(WIC_1,icides,4,FALSE) + VLOOKUP(WIC_2,icides,4,FALSE)","v":15},{"$f":"VLOOKUP(WIC_1,icides,4,FALSE) + VLOOKUP(WIC_2,icides,4,FALSE)","v":5},"=VLOOKUP(WIC_1,icides,4,FALSE) + VLOOKUP(WIC_2,icides,4,FALSE)"]
["FNC","fungicide cost","$/ac",{"$f":"VLOOKUP(WFC_1,fcides,4,FALSE) + VLOOKUP(WFC_2,fcides,4,FALSE)","v":14.375},{"$f":"VLOOKUP(WFC_1,fcides,4,FALSE) + VLOOKUP(WFC_2,fcides,4,FALSE)","v":14.375},{"$f":"VLOOKUP(WFC_1,fcides,4,FALSE) + VLOOKUP(WFC_2,fcides,4,FALSE)","v":14.375},"=VLOOKUP(WFC_1,fcides,4,FALSE) + VLOOKUP(WFC_2,fcides,4,FALSE)"]
["CCC","cover crops cost","$/ac",{"$f":"CCS+CCP+CCT","v":0},{"$f":"CCS+CCP+CCT","v":0},{"$f":"CCS+CCP+CCT","v":0},"=CCS+CCP+CCT"]
["WMC","water mgmt cost","$/ac",{"$f":"DRI+IR","v":0},{"$f":"DRI+IR","v":0},{"$f":"DRI+IR","v":0},"=DRI+IR"]
["MC","machinery costs","$/ac",{"$f":"T+P+SS+H+OM","v":104},{"$f":"T+P+SS+H+OM","v":79},{"$f":"T+P+SS+H+OM","v":104},"=T+P+SS+H+OM"]
["PHC","post harvest cost per bu","$/bu",{"$f":"DC+SC+TC","v":0.37},{"$f":"DC+SC+TC","v":0.35},{"$f":"DC+SC+TC","v":0.32},"=DC+SC+TC"]
["PHC_du","post harvest cost","$/ac",{"$f":"PHC*Y","v":66.599999999999994},{"$f":"PHC*Y","v":61.949999999999996},{"$f":"PHC*Y","v":57.6},"=PHC*Y"]
["Summed"]
["TI","total income","$/ac",{"$f":"SP*Y+OI_1+OI_2","v":601.4},{"$f":"SP*Y+OI_1+OI_2","v":591.41},{"$f":"SP*Y+OI_1+OI_2","v":601.4},"=SP*Y+OI_1+OI_2"]
["STOC","subtotal of cost","$/ac",{"$f":"(LC+CI+S+OMI+SEC+FTC+HC+IC+FNC+CCC+WMC+MC)+PHC*Y","v":620.61500000000012},{"$f":"(LC+CI+S+OMI+SEC+FTC+HC+IC+FNC+CCC+WMC+MC)+PHC*Y","v":531.38499999999999},{"$f":"(LC+CI+S+OMI+SEC+FTC+HC+IC+FNC+CCC+WMC+MC)+PHC*Y","v":566.48500000000001},"=(LC+CI+S+OMI+SEC+FTC+HC+IC+FNC+CCC+WMC+MC)+PHC*Y"]
[]
["Return over considered costs"]
["RPA","return per acre","$/ac",{"$f":"TI-STOC","v":-19.215000000000146},{"$f":"TI-STOC","v":60.024999999999977},{"$f":"TI-STOC","v":34.914999999999964},"=TI-STOC"]
["RFF","return for field","$",{"$f":"RPA*A","v":-4688.4600000000355},{"$f":"RPA*A","v":2400.9999999999991},{"$f":"RPA*A","v":174.57499999999982},"=RPA*A"]
[]
["Farm Summary (summed across all columns)"]
["Area",null,null,{"$f":"SUM(49:49)","v":289},"ac"]
["Returns over considered costs",null,null,{"$f":"SUM(67:67)","v":-2112.8850000000366},"$"]
["Average return over considered costs",null,null,{"$f":"D71/D70","v":-7.3110207612458016},"$/ac"]
[]
[]
["Data table of sensitivity (what if?) analysis for varied price and yield"]
["Table is based on Column E scenario"]
["Table has Return over Considered Costs ($/ac)"]
[null,null,null,"Yield (bu/ac)"]
[null,"Crop Price ($/bu)","-15%","baseline","+15%"]
[null,{"$f":"E66","v":60.024999999999977},{"$f":"D80*0.85","v":150.44999999999999},177,{"$f":"D80*1.15","v":203.54999999999998}]
["-30%",{"$f":"B83*0.7","v":2.331},-169.39355,-116.798,-64.202450000000056]
["-15%",{"$f":"B83*0.85","v":2.8304999999999998},-94.243775000000028,-28.386500000000012,37.47077499999989]
["baseline",3.33,-19.093999999999994,60.024999999999977,139.14399999999989]
["+15%",{"$f":"B83*1.15","v":3.8294999999999999},56.055774999999926,148.43650000000002,240.81722499999989]
["+30%",{"$f":"B83*1.3","v":4.3290000000000006},131.20555000000002,236.84800000000007,342.49045000000001]
[]
[]
["Figure 1. Column D scenario"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Figure 2. Column E scenario"]

{"sheet":"FertCosts","index":4,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["INPUTS",null,null,"Combo 1","Combo 2","Combo 3","Combo 4",true]
["T_1","type 1"," -- ","82-0-0, anhydrous ammonia","82-0-0, anhydrous ammonia","82-0-0, anhydrous ammonia","82-0-0, anhydrous ammonia"]
["R_1","rate of type 1","lb/ac",150,150,150,120]
["T_2","type 2"," --","18-46-0, diammonium phosphate","18-46-0, diammonium phosphate","46-0-0, urea","0-0-60, muriate of potash"]
["R_2","rate of type 2","lb/ac",40,50,80,40]
["T_3","type 3"," --","28-0-0, 28% urea ammonium nitrate","46-0-0, urea","18-46-0, diammonium phosphate","18-46-0, diammonium phosphate"]
["R_3","rate of type 3","lb/ac",70,50,60,40]
["T_4","type 4"," --","0-0-0-17, pelleted gypsum","0-0-0-17, ground gypsum","0-0-0-22-21, K-Mag","0-0-0-17, pelleted gypsum"]
["R_4","rate of type 4","lb/ac",20,20,20,20]
["OUTPUTS"]
["N","total N contribution","lb N/ac",{"$f":"VLOOKUP(T_1,Flizers,2,FALSE)*R_1+VLOOKUP(T_2,Flizers,2,FALSE)*R_2+VLOOKUP(T_3,Flizers,2,FALSE)*R_3+VLOOKUP(T_4,Flizers,2,FALSE)*R_4","v":149.79999999999998},{"$f":"VLOOKUP(T_1,Flizers,2,FALSE)*R_1+VLOOKUP(T_2,Flizers,2,FALSE)*R_2+VLOOKUP(T_3,Flizers,2,FALSE)*R_3+VLOOKUP(T_4,Flizers,2,FALSE)*R_4","v":155},{"$f":"VLOOKUP(T_1,Flizers,2,FALSE)*R_1+VLOOKUP(T_2,Flizers,2,FALSE)*R_2+VLOOKUP(T_3,Flizers,2,FALSE)*R_3+VLOOKUP(T_4,Flizers,2,FALSE)*R_4","v":170.6},{"$f":"VLOOKUP(T_1,Flizers,2,FALSE)*R_1+VLOOKUP(T_2,Flizers,2,FALSE)*R_2+VLOOKUP(T_3,Flizers,2,FALSE)*R_3+VLOOKUP(T_4,Flizers,2,FALSE)*R_4","v":105.6},"=VLOOKUP(T_1,Flizers,2,FALSE)*R_1+VLOOKUP(T_2,Flizers,2,FALSE)*R_2+VLOOKUP(T_3,Flizers,2,FALSE)*R_3+VLOOKUP(T_4,Flizers,2,FALSE)*R_4"]
["P","total P2O5 contribution","lb P2O5/ac",{"$f":"VLOOKUP(T_1,Flizers,3,FALSE)*R_1+VLOOKUP(T_2,Flizers,3,FALSE)*R_2+VLOOKUP(T_3,Flizers,3,FALSE)*R_3+VLOOKUP(T_4,Flizers,3,FALSE)*R_4","v":18.400000000000002},{"$f":"VLOOKUP(T_1,Flizers,3,FALSE)*R_1+VLOOKUP(T_2,Flizers,3,FALSE)*R_2+VLOOKUP(T_3,Flizers,3,FALSE)*R_3+VLOOKUP(T_4,Flizers,3,FALSE)*R_4","v":23},{"$f":"VLOOKUP(T_1,Flizers,3,FALSE)*R_1+VLOOKUP(T_2,Flizers,3,FALSE)*R_2+VLOOKUP(T_3,Flizers,3,FALSE)*R_3+VLOOKUP(T_4,Flizers,3,FALSE)*R_4","v":27.6},{"$f":"VLOOKUP(T_1,Flizers,3,FALSE)*R_1+VLOOKUP(T_2,Flizers,3,FALSE)*R_2+VLOOKUP(T_3,Flizers,3,FALSE)*R_3+VLOOKUP(T_4,Flizers,3,FALSE)*R_4","v":18.400000000000002},"=VLOOKUP(T_1,Flizers,3,FALSE)*R_1+VLOOKUP(T_2,Flizers,3,FALSE)*R_2+VLOOKUP(T_3,Flizers,3,FALSE)*R_3+VLOOKUP(T_4,Flizers,3,FALSE)*R_4"]
["K","total K2O contribution","lb K2O/ac",{"$f":"VLOOKUP(T_1,Flizers,4,FALSE)*R_1+VLOOKUP(T_2,Flizers,4,FALSE)*R_2+VLOOKUP(T_3,Flizers,4,FALSE)*R_3+VLOOKUP(T_4,Flizers,4,FALSE)*R_4","v":0},{"$f":"VLOOKUP(T_1,Flizers,4,FALSE)*R_1+VLOOKUP(T_2,Flizers,4,FALSE)*R_2+VLOOKUP(T_3,Flizers,4,FALSE)*R_3+VLOOKUP(T_4,Flizers,4,FALSE)*R_4","v":0},{"$f":"VLOOKUP(T_1,Flizers,4,FALSE)*R_1+VLOOKUP(T_2,Flizers,4,FALSE)*R_2+VLOOKUP(T_3,Flizers,4,FALSE)*R_3+VLOOKUP(T_4,Flizers,4,FALSE)*R_4","v":4.4000000000000004},{"$f":"VLOOKUP(T_1,Flizers,4,FALSE)*R_1+VLOOKUP(T_2,Flizers,4,FALSE)*R_2+VLOOKUP(T_3,Flizers,4,FALSE)*R_3+VLOOKUP(T_4,Flizers,4,FALSE)*R_4","v":24},"=VLOOKUP(T_1,Flizers,4,FALSE)*R_1+VLOOKUP(T_2,Flizers,4,FALSE)*R_2+VLOOKUP(T_3,Flizers,4,FALSE)*R_3+VLOOKUP(T_4,Flizers,4,FALSE)*R_4"]
["S","total S contribution","lb S/ac",{"$f":"VLOOKUP(T_1,Flizers,5,FALSE)*R_1+VLOOKUP(T_2,Flizers,5,FALSE)*R_2+VLOOKUP(T_3,Flizers,5,FALSE)*R_3+VLOOKUP(T_4,Flizers,5,FALSE)*R_4","v":3.4000000000000004},{"$f":"VLOOKUP(T_1,Flizers,5,FALSE)*R_1+VLOOKUP(T_2,Flizers,5,FALSE)*R_2+VLOOKUP(T_3,Flizers,5,FALSE)*R_3+VLOOKUP(T_4,Flizers,5,FALSE)*R_4","v":3.4000000000000004},{"$f":"VLOOKUP(T_1,Flizers,5,FALSE)*R_1+VLOOKUP(T_2,Flizers,5,FALSE)*R_2+VLOOKUP(T_3,Flizers,5,FALSE)*R_3+VLOOKUP(T_4,Flizers,5,FALSE)*R_4","v":4.2},{"$f":"VLOOKUP(T_1,Flizers,5,FALSE)*R_1+VLOOKUP(T_2,Flizers,5,FALSE)*R_2+VLOOKUP(T_3,Flizers,5,FALSE)*R_3+VLOOKUP(T_4,Flizers,5,FALSE)*R_4","v":3.4000000000000004},"=VLOOKUP(T_1,Flizers,5,FALSE)*R_1+VLOOKUP(T_2,Flizers,5,FALSE)*R_2+VLOOKUP(T_3,Flizers,5,FALSE)*R_3+VLOOKUP(T_4,Flizers,5,FALSE)*R_4"]
["CPA","cost per acre","$/ac",{"$f":"(R_1*VLOOKUP(T_1,Flizers,6,FALSE)+R_2*VLOOKUP(T_2,Flizers,6,FALSE)+R_3*VLOOKUP(T_3,Flizers,6,FALSE)+R_4*VLOOKUP(T_4,Flizers,6,FALSE))/2000","v":48.78},{"$f":"(R_1*VLOOKUP(T_1,Flizers,6,FALSE)+R_2*VLOOKUP(T_2,Flizers,6,FALSE)+R_3*VLOOKUP(T_3,Flizers,6,FALSE)+R_4*VLOOKUP(T_4,Flizers,6,FALSE))/2000","v":52.37},{"$f":"(R_1*VLOOKUP(T_1,Flizers,6,FALSE)+R_2*VLOOKUP(T_2,Flizers,6,FALSE)+R_3*VLOOKUP(T_3,Flizers,6,FALSE)+R_4*VLOOKUP(T_4,Flizers,6,FALSE))/2000","v":63.65},{"$f":"(R_1*VLOOKUP(T_1,Flizers,6,FALSE)+R_2*VLOOKUP(T_2,Flizers,6,FALSE)+R_3*VLOOKUP(T_3,Flizers,6,FALSE)+R_4*VLOOKUP(T_4,Flizers,6,FALSE))/2000","v":41.58},"=(R_1*VLOOKUP(T_1,Flizers,6,FALSE)+R_2*VLOOKUP(T_2,Flizers,6,FALSE)+R_3*VLOOKUP(T_3,Flizers,6,FALSE)+R_4*VLOOKUP(T_4,Flizers,6,FALSE))/2000"]
[]
[]
["FERTILIZER COMPOSITION AND PRICE TABLE"]
["Name","N (fraction)","P2O5 (fraction)","K20 (fraction)","S (fraction)","Price ($/ton)"]
["82-0-0, anhydrous ammonia",0.82,0,0,0,430]
["46-0-0, urea",0.46,0,0,0,350]
["33.5-0-0, ammonium nitrate",0.33500000000000002,0,0,0,250]
["32-0-0, 32% urea ammonium nitrate",0.32,0,0,0,245]
["28-0-0, 28% urea ammonium nitrate",0.28000000000000003,0,0,0,210]
["21-0-0, ammonium sulfate",0.21,0,0,0,150]
["18-46-0, diammonium phosphate",0.18,0.46,0,0,430]
["16-20-0, ammonium phosphate sulfate",0.16,0.2,0,0,300]
["11-52-0, monoammonium phosphate",0.11,0.52,0,0,400]
["10-34-0, ammonium polyphosphate",0.1,0.34,0,0,380]
["0-46-0, triple superphosphate",0,0.46,0,0,410]
["0-0-60, muriate of potash",0,0,0.6,0,330]
["9-18-9, starter",0.09,0.18,0.09,0,290]
["7-21-7, starter",7.0000000000000007E-2,0.21,7.0000000000000007E-2,0,290]
["12-0-0. ammonium thiosulfate",12,0,0,0.26,400]
["0-0-0-17, ground gypsum",0,0,0,0.17,62]
["0-0-0-17, pelleted gypsum",0,0,0,0.17,58]
["0-0-0-22-21, K-Mag",0,0,0.22,0.21,450]