{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Seed Calculator","Small Grains","Speciality Crop","DATA (hide)","names (hide)","Seeding Rates DV (hide)"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"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":"Seed Calculator","index":0,"n_rows":56,"n_cols":37,"rows_kept":56,"cut":false,"hidden":true,"merged":[[2,14,2,15],[5,2,5,4],[5,8,5,10],[5,11,5,12],[5,14,5,15],[49,0,50,15],[5,23,5,25],[5,29,5,31],[5,32,5,33],[5,35,5,36]]}
[]
[". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ."]
["MERFELD - Seeding Rate & Seed Cost Calculator",null,null,null,null,null,null,null,null,null,null,null,"Printed:",null,{"$f":"TODAY()","v":"2025-05-13"}]
[null,null,null,null,null,"*** Enter changes to BLUE values only ***",null,null,null,null,null,null,null,null,null,"Version 1.0"]
[]
[null,null,"Seed and Treatment",null,null,"Seed","Seeding","Seeding","Target Plant Stand Population",null,null,"1,000 Kernal Weight",null,"Seed","Seed Survival",null,null,null,null,null,null,null,null,"Seed and Treatment",null,null,"Seed","Seeding","Seeding","Target Plant Stand Population",null,null,"1,000 Kernal Weight",null,"Seed","Seed Survival"]
[null,null,"Price",null,"Number","Cost","Rate","Rate","Plants","Range/ft.2","Plants","Actual","Range","Germination","Expected","Range",null,null,null,null,null,null,null,"Price",null,"Pounds","Cost","Rate","Rate","Optimal","Range/ft.2","Optimal","Actual","Range","Germination","Expected","Range"]
[null,"Crop","per Unit","unit","per unit","($/acre)","(lb./acre)","(units/ac)","per ft.2","low - high","per m2","(grams)","(grams)","%","%","%",null,null,null,null,null,null,"Crop","per Unit","unit","per unit","($/acre)","(lb./acre)","(units/ac)","per ft.2","low - high","per m2","(grams)","(grams)","%","%","%"]
[]
["#1","Canola",{"$f":"VLOOKUP(B10,'DATA (hide)'!$A$4:$Y$30,2,FALSE)","v":825},{"$f":"VLOOKUP(B10,'DATA (hide)'!$A$4:$Y$30,3,FALSE)","v":"Bag"},{"$f":"VLOOKUP(B10,'DATA (hide)'!$A$4:$Y$30,4,FALSE)","v":50},{"$f":"G10*(C10/E10)","v":82.5},{"$f":"IF(L10=0,0,ROUND(((I10*L10)/(N10*O10))/10.4,1))","v":5},{"$f":"SUM(G10/E10)","v":0.1},{"$f":"VLOOKUP(B10,'DATA (hide)'!$A$4:$Y$30,10,FALSE)","v":7.5},{"$f":"VLOOKUP(B10,'DATA (hide)'!$A$4:$Y$30,8,FALSE)&\"-\"&VLOOKUP(B10,'DATA (hide)'!$A$4:$Y$30,9,FALSE)","v":"3-12"},{"$f":"ROUND(I10*10.7639,0)","v":81},{"$f":"VLOOKUP(B10,'DATA (hide)'!$A$4:$Y$30,14,FALSE)","v":4.95},{"$f":"VLOOKUP(B10,'DATA (hide)'!$A$4:$Y$30,12,FALSE)&\"-\"&VLOOKUP(B10,'DATA (hide)'!$A$4:$Y$30,13,FALSE)","v":"3-7"},{"$f":"VLOOKUP(B10,'DATA (hide)'!$A$4:$Y$30,15,FALSE)","v":0.95},{"$f":"VLOOKUP(B10,'DATA (hide)'!$A$4:$Y$30,18,FALSE)","v":0.75},{"$f":"VLOOKUP(B10,'DATA (hide)'!$A$4:$Y$30,16,FALSE)&\"-\"&VLOOKUP(B10,'DATA (hide)'!$A$4:$Y$30,17,FALSE)","v":"40-80"},null,null,null,null,null,"#1","(Select Crop)",{"$f":"VLOOKUP(W10,'DATA (hide)'!$A$4:$Y$30,2,FALSE)","v":0},{"$f":"VLOOKUP(W10,'DATA (hide)'!$A$4:$Y$30,3,FALSE)","v":"Bu"},{"$f":"VLOOKUP(W10,'DATA (hide)'!$A$4:$Y$30,4,FALSE)","v":1},{"$f":"AB10*(X10/Z10)","v":0},{"$f":"IF(AG10=0,0,ROUND(((AD10*AG10)/(AI10*AJ10))/10.4,1))","v":0},{"$f":"SUM(AB10/Z10)","v":0},{"$f":"VLOOKUP(W10,'DATA (hide)'!$A$4:$Y$30,10,FALSE)","v":0},{"$f":"VLOOKUP(W10,'DATA (hide)'!$A$4:$Y$30,8,FALSE)&\"-\"&VLOOKUP(W10,'DATA (hide)'!$A$4:$Y$30,9,FALSE)","v":"0-0"},{"$f":"ROUND(AD10*10.7639,0)","v":0},{"$f":"VLOOKUP(W10,'DATA (hide)'!$A$4:$Y$30,14,FALSE)","v":0},{"$f":"VLOOKUP(W10,'DATA (hide)'!$A$4:$Y$30,12,FALSE)&\"-\"&VLOOKUP(W10,'DATA (hide)'!$A$4:$Y$30,13,FALSE)","v":"0-0"},{"$f":"VLOOKUP(W10,'DATA (hide)'!$A$4:$Y$30,15,FALSE)","v":0},{"$f":"VLOOKUP(W10,'DATA (hide)'!$A$4:$Y$30,18,FALSE)","v":0},{"$f":"VLOOKUP(W10,'DATA (hide)'!$A$4:$Y$30,16,FALSE)&\"-\"&VLOOKUP(W10,'DATA (hide)'!$A$4:$Y$30,17,FALSE)","v":"0-0"}]
[]
[null,"bigyield","Acres",160,null,"Row Spacing (inches)",null,null,null,"Seed per 100ft. Row (grams)",{"$f":"ROUND((G10*F13)/11.5,1)","v":4.3},null,"Seeds per acre",{"$f":"IF(I10=0,0,(I10*43560)/(N10*O10))","v":458526.31578947377},null,null,null,null,null,null,null,null,"(enter variety)","Acres",0,null,"Row Spacing (inches)",null,null,null,"Seed per 100ft. Row (grams)",{"$f":"ROUND((AB10*AA13)/11.5,1)","v":0},null,"Seeds per acre",{"$f":"IF(AD10=0,0,(AD10*43560)/(AI10*AJ10))","v":0}]
[null,null,"Total Cost",{"$f":"SUM(D12*F10)","v":13200},null,10,null,null,null,"Seeds per ft. row",{"$f":"IF(L10=0,0,ROUND(((K12/100)*1000)/L10,1))","v":8.6999999999999993},null,"Seeds per pound",{"$f":"IF(L10=0,0,ROUND((1000*453.592)/L10,0))","v":91635},null,null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(Y12*AA10)","v":0},null,10,null,null,null,"Seeds per ft. row",{"$f":"IF(AG10=0,0,ROUND(((AF12/100)*1000)/AG10,1))","v":0},null,"Seeds per pound",{"$f":"IF(AG10=0,0,ROUND((1000*453.592)/AG10,0))","v":0}]
[]
[]
["#2","Wheat - Hard Red Spring",{"$f":"VLOOKUP(B16,'DATA (hide)'!$A$4:$Y$30,2,FALSE)","v":17},{"$f":"VLOOKUP(B16,'DATA (hide)'!$A$4:$Y$30,3,FALSE)","v":"Bu"},{"$f":"VLOOKUP(B16,'DATA (hide)'!$A$4:$Y$30,4,FALSE)","v":60},{"$f":"G16*(C16/E16)","v":34},{"$f":"IF(L16=0,0,ROUND(((I16*L16)/(N16*O16))/10.4,1))","v":120},{"$f":"SUM(G16/E16)","v":2},{"$f":"VLOOKUP(B16,'DATA (hide)'!$A$4:$Y$30,10,FALSE)","v":28},{"$f":"VLOOKUP(B16,'DATA (hide)'!$A$4:$Y$30,8,FALSE)&\"-\"&VLOOKUP(B16,'DATA (hide)'!$A$4:$Y$30,9,FALSE)","v":"23-28"},{"$f":"ROUND(I16*10.7639,0)","v":301},{"$f":"VLOOKUP(B16,'DATA (hide)'!$A$4:$Y$30,14,FALSE)","v":36},{"$f":"VLOOKUP(B16,'DATA (hide)'!$A$4:$Y$30,12,FALSE)&\"-\"&VLOOKUP(B16,'DATA (hide)'!$A$4:$Y$30,13,FALSE)","v":"31-38"},{"$f":"VLOOKUP(B16,'DATA (hide)'!$A$4:$Y$30,15,FALSE)","v":0.95},{"$f":"VLOOKUP(B16,'DATA (hide)'!$A$4:$Y$30,18,FALSE)","v":0.85},{"$f":"VLOOKUP(B16,'DATA (hide)'!$A$4:$Y$30,16,FALSE)&\"-\"&VLOOKUP(B16,'DATA (hide)'!$A$4:$Y$30,17,FALSE)","v":"85-90"},null,null,null,null,null,"#2","(Select Crop)",{"$f":"VLOOKUP(W16,'DATA (hide)'!$A$4:$Y$30,2,FALSE)","v":0},{"$f":"VLOOKUP(W16,'DATA (hide)'!$A$4:$Y$30,3,FALSE)","v":"Bu"},{"$f":"VLOOKUP(W16,'DATA (hide)'!$A$4:$Y$30,4,FALSE)","v":1},{"$f":"AB16*(X16/Z16)","v":0},{"$f":"IF(AG16=0,0,ROUND(((AD16*AG16)/(AI16*AJ16))/10.4,1))","v":0},{"$f":"SUM(AB16/Z16)","v":0},{"$f":"VLOOKUP(W16,'DATA (hide)'!$A$4:$Y$30,10,FALSE)","v":0},{"$f":"VLOOKUP(W16,'DATA (hide)'!$A$4:$Y$30,8,FALSE)&\"-\"&VLOOKUP(W16,'DATA (hide)'!$A$4:$Y$30,9,FALSE)","v":"0-0"},{"$f":"ROUND(AD16*10.7639,0)","v":0},{"$f":"VLOOKUP(W16,'DATA (hide)'!$A$4:$Y$30,14,FALSE)","v":0},{"$f":"VLOOKUP(W16,'DATA (hide)'!$A$4:$Y$30,12,FALSE)&\"-\"&VLOOKUP(W16,'DATA (hide)'!$A$4:$Y$30,13,FALSE)","v":"0-0"},{"$f":"VLOOKUP(W16,'DATA (hide)'!$A$4:$Y$30,15,FALSE)","v":0},{"$f":"VLOOKUP(W16,'DATA (hide)'!$A$4:$Y$30,18,FALSE)","v":0},{"$f":"VLOOKUP(W16,'DATA (hide)'!$A$4:$Y$30,16,FALSE)&\"-\"&VLOOKUP(W16,'DATA (hide)'!$A$4:$Y$30,17,FALSE)","v":"0-0"}]
[]
[null,"bigbin","Acres",160,null,"Row Spacing (inches)",null,null,null,"Seed per 100ft. Row (grams)",{"$f":"ROUND((G16*F19)/11.5,1)","v":104.3},null,"Seeds per acre",{"$f":"IF(I16=0,0,(I16*43560)/(N16*O16))","v":1510439.628482972},null,null,null,null,null,null,null,null,"(enter variety)","Acres",0,null,"Row Spacing (inches)",null,null,null,"Seed per 100ft. Row (grams)",{"$f":"ROUND((AB16*AA19)/11.5,1)","v":0},null,"Seeds per acre",{"$f":"IF(AD16=0,0,(AD16*43560)/(AI16*AJ16))","v":0}]
[null,null,"Total Cost",{"$f":"SUM(D18*F16)","v":5440},null,10,null,null,null,"Seeds per ft. row",{"$f":"IF(L16=0,0,ROUND(((K18/100)*1000)/L16,1))","v":29},null,"Seeds per pound",{"$f":"IF(L16=0,0,ROUND((1000*453.592)/L16,0))","v":12600},null,null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(Y18*AA16)","v":0},null,10,null,null,null,"Seeds per ft. row",{"$f":"IF(AG16=0,0,ROUND(((AF18/100)*1000)/AG16,1))","v":0},null,"Seeds per pound",{"$f":"IF(AG16=0,0,ROUND((1000*453.592)/AG16,0))","v":0}]
[]
[]
["#3","Soybeans",{"$f":"VLOOKUP(B22,'DATA (hide)'!$A$4:$Y$30,2,FALSE)","v":62.94},{"$f":"VLOOKUP(B22,'DATA (hide)'!$A$4:$Y$30,3,FALSE)","v":"Unit"},{"$f":"VLOOKUP(B22,'DATA (hide)'!$A$4:$Y$30,4,FALSE)","v":140000},{"$f":"G22*(C22/E22)","v":1296.8406662571429},{"$f":"IF(L22=0,0,ROUND(((I22*L22)/(N22*O22))/10.4,1))","v":2884615.4},{"$f":"SUM(G22/E22)","v":20.604395714285715},{"$f":"VLOOKUP(B22,'DATA (hide)'!$A$4:$Y$30,10,FALSE)","v":162000},{"$f":"VLOOKUP(B22,'DATA (hide)'!$A$4:$Y$30,8,FALSE)&\"-\"&VLOOKUP(B22,'DATA (hide)'!$A$4:$Y$30,9,FALSE)","v":"150000-200000"},{"$f":"ROUND(I22*10.7639,0)","v":1743752},{"$f":"VLOOKUP(B22,'DATA (hide)'!$A$4:$Y$30,14,FALSE)","v":150},{"$f":"VLOOKUP(B22,'DATA (hide)'!$A$4:$Y$30,12,FALSE)&\"-\"&VLOOKUP(B22,'DATA (hide)'!$A$4:$Y$30,13,FALSE)","v":"100-200"},{"$f":"VLOOKUP(B22,'DATA (hide)'!$A$4:$Y$30,15,FALSE)","v":0.9},{"$f":"VLOOKUP(B22,'DATA (hide)'!$A$4:$Y$30,18,FALSE)","v":0.9},{"$f":"VLOOKUP(B22,'DATA (hide)'!$A$4:$Y$30,16,FALSE)&\"-\"&VLOOKUP(B22,'DATA (hide)'!$A$4:$Y$30,17,FALSE)","v":"75-80"},null,null,null,null,null,"#3","(Select Crop)",{"$f":"VLOOKUP(W22,'DATA (hide)'!$A$4:$Y$30,2,FALSE)","v":0},{"$f":"VLOOKUP(W22,'DATA (hide)'!$A$4:$Y$30,3,FALSE)","v":"Bu"},{"$f":"VLOOKUP(W22,'DATA (hide)'!$A$4:$Y$30,4,FALSE)","v":1},{"$f":"AB22*(X22/Z22)","v":0},{"$f":"IF(AG22=0,0,ROUND(((AD22*AG22)/(AI22*AJ22))/10.4,1))","v":0},{"$f":"SUM(AB22/Z22)","v":0},{"$f":"VLOOKUP(W22,'DATA (hide)'!$A$4:$Y$30,10,FALSE)","v":0},{"$f":"VLOOKUP(W22,'DATA (hide)'!$A$4:$Y$30,8,FALSE)&\"-\"&VLOOKUP(W22,'DATA (hide)'!$A$4:$Y$30,9,FALSE)","v":"0-0"},{"$f":"ROUND(AD22*10.7639,0)","v":0},{"$f":"VLOOKUP(W22,'DATA (hide)'!$A$4:$Y$30,14,FALSE)","v":0},{"$f":"VLOOKUP(W22,'DATA (hide)'!$A$4:$Y$30,12,FALSE)&\"-\"&VLOOKUP(W22,'DATA (hide)'!$A$4:$Y$30,13,FALSE)","v":"0-0"},{"$f":"VLOOKUP(W22,'DATA (hide)'!$A$4:$Y$30,15,FALSE)","v":0},{"$f":"VLOOKUP(W22,'DATA (hide)'!$A$4:$Y$30,18,FALSE)","v":0},{"$f":"VLOOKUP(W22,'DATA (hide)'!$A$4:$Y$30,16,FALSE)&\"-\"&VLOOKUP(W22,'DATA (hide)'!$A$4:$Y$30,17,FALSE)","v":"0-0"}]
[]
[null,"ridgeville","Acres",160,null,"Row Spacing (inches)",null,null,null,"Seed per 100ft. Row (grams)",{"$f":"ROUND((G22*F25)/11.5,1)","v":2508361.2000000002},null,"Seeds per acre",{"$f":"IF(I22=0,0,(I22*43560)/(N22*O22))","v":8712000000},null,null,null,null,null,null,null,null,"(enter variety)","Acres",0,null,"Row Spacing (inches)",null,null,null,"Seed per 100ft. Row (grams)",{"$f":"ROUND((AB22*AA25)/11.5,1)","v":0},null,"Seeds per acre",{"$f":"IF(AD22=0,0,(AD22*43560)/(AI22*AJ22))","v":0}]
[null,null,"Total Cost",{"$f":"SUM(D24*F22)","v":207494.50660114287},null,10,null,null,null,"Seeds per ft. row",{"$f":"IF(L22=0,0,ROUND(((K24/100)*1000)/L22,1))","v":167224.1},null,"Seeds per pound",{"$f":"IF(L22=0,0,ROUND((1000*453.592)/L22,0))","v":3024},null,null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(Y24*AA22)","v":0},null,10,null,null,null,"Seeds per ft. row",{"$f":"IF(AG22=0,0,ROUND(((AF24/100)*1000)/AG22,1))","v":0},null,"Seeds per pound",{"$f":"IF(AG22=0,0,ROUND((1000*453.592)/AG22,0))","v":0}]
[]
[]
["#4","Sunflower Confectionary",{"$f":"VLOOKUP(B28,'DATA (hide)'!$A$4:$Y$30,2,FALSE)","v":500},{"$f":"VLOOKUP(B28,'DATA (hide)'!$A$4:$Y$30,3,FALSE)","v":"Bag"},{"$f":"VLOOKUP(B28,'DATA (hide)'!$A$4:$Y$30,4,FALSE)","v":200000},{"$f":"G28*(C28/E28)","v":408.94775000000004},{"$f":"IF(L28=0,0,ROUND(((I28*L28)/(N28*O28))/10.4,1))","v":163579.1},{"$f":"SUM(G28/E28)","v":0.8178955},{"$f":"VLOOKUP(B28,'DATA (hide)'!$A$4:$Y$30,10,FALSE)","v":16000},{"$f":"VLOOKUP(B28,'DATA (hide)'!$A$4:$Y$30,8,FALSE)&\"-\"&VLOOKUP(B28,'DATA (hide)'!$A$4:$Y$30,9,FALSE)","v":"14000-18000"},{"$f":"ROUND(I28*10.7639,0)","v":172222},{"$f":"VLOOKUP(B28,'DATA (hide)'!$A$4:$Y$30,14,FALSE)","v":100},{"$f":"VLOOKUP(B28,'DATA (hide)'!$A$4:$Y$30,12,FALSE)&\"-\"&VLOOKUP(B28,'DATA (hide)'!$A$4:$Y$30,13,FALSE)","v":"91-151"},{"$f":"VLOOKUP(B28,'DATA (hide)'!$A$4:$Y$30,15,FALSE)","v":0.99},{"$f":"VLOOKUP(B28,'DATA (hide)'!$A$4:$Y$30,18,FALSE)","v":0.95},{"$f":"VLOOKUP(B28,'DATA (hide)'!$A$4:$Y$30,16,FALSE)&\"-\"&VLOOKUP(B28,'DATA (hide)'!$A$4:$Y$30,17,FALSE)","v":"95-99"},null,null,null,null,null,"#4","(Select Crop)",{"$f":"VLOOKUP(W28,'DATA (hide)'!$A$4:$Y$30,2,FALSE)","v":0},{"$f":"VLOOKUP(W28,'DATA (hide)'!$A$4:$Y$30,3,FALSE)","v":"Bu"},{"$f":"VLOOKUP(W28,'DATA (hide)'!$A$4:$Y$30,4,FALSE)","v":1},{"$f":"AB28*(X28/Z28)","v":0},{"$f":"IF(AG28=0,0,ROUND(((AD28*AG28)/(AI28*AJ28))/10.4,1))","v":0},{"$f":"SUM(AB28/Z28)","v":0},{"$f":"VLOOKUP(W28,'DATA (hide)'!$A$4:$Y$30,10,FALSE)","v":0},{"$f":"VLOOKUP(W28,'DATA (hide)'!$A$4:$Y$30,8,FALSE)&\"-\"&VLOOKUP(W28,'DATA (hide)'!$A$4:$Y$30,9,FALSE)","v":"0-0"},{"$f":"ROUND(AD28*10.7639,0)","v":0},{"$f":"VLOOKUP(W28,'DATA (hide)'!$A$4:$Y$30,14,FALSE)","v":0},{"$f":"VLOOKUP(W28,'DATA (hide)'!$A$4:$Y$30,12,FALSE)&\"-\"&VLOOKUP(W28,'DATA (hide)'!$A$4:$Y$30,13,FALSE)","v":"0-0"},{"$f":"VLOOKUP(W28,'DATA (hide)'!$A$4:$Y$30,15,FALSE)","v":0},{"$f":"VLOOKUP(W28,'DATA (hide)'!$A$4:$Y$30,18,FALSE)","v":0},{"$f":"VLOOKUP(W28,'DATA (hide)'!$A$4:$Y$30,16,FALSE)&\"-\"&VLOOKUP(W28,'DATA (hide)'!$A$4:$Y$30,17,FALSE)","v":"0-0"}]
[]
[null,"(enter variety)","Acres",80,null,"Row Spacing (inches)",null,null,null,"Seed per 100ft. Row (grams)",{"$f":"ROUND((G28*F31)/11.5,1)","v":142242.70000000001},null,"Seeds per acre",{"$f":"IF(I28=0,0,(I28*43560)/(N28*O28))","v":741052631.57894742},null,null,null,null,null,null,null,null,"(enter variety)","Acres",0,null,"Row Spacing (inches)",null,null,null,"Seed per 100ft. Row (grams)",{"$f":"ROUND((AB28*AA31)/11.5,1)","v":0},null,"Seeds per acre",{"$f":"IF(AD28=0,0,(AD28*43560)/(AI28*AJ28))","v":0}]
[null,null,"Total Cost",{"$f":"SUM(D30*F28)","v":32715.820000000003},null,10,null,null,null,"Seeds per ft. row",{"$f":"IF(L28=0,0,ROUND(((K30/100)*1000)/L28,1))","v":14224.3},null,"Seeds per pound",{"$f":"IF(L28=0,0,ROUND((1000*453.592)/L28,0))","v":4536},null,null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(Y30*AA28)","v":0},null,10,null,null,null,"Seeds per ft. row",{"$f":"IF(AG28=0,0,ROUND(((AF30/100)*1000)/AG28,1))","v":0},null,"Seeds per pound",{"$f":"IF(AG28=0,0,ROUND((1000*453.592)/AG28,0))","v":0}]
[]
[]
["#5","Corn - Grain",{"$f":"VLOOKUP(B34,'DATA (hide)'!$A$4:$Y$30,2,FALSE)","v":250},{"$f":"VLOOKUP(B34,'DATA (hide)'!$A$4:$Y$30,3,FALSE)","v":"Bag"},{"$f":"VLOOKUP(B34,'DATA (hide)'!$A$4:$Y$30,4,FALSE)","v":80000},{"$f":"G34*(C34/E34)","v":3365.5062500000004},{"$f":"IF(L34=0,0,ROUND(((I34*L34)/(N34*O34))/10.4,1))","v":1076962},{"$f":"SUM(G34/E34)","v":13.462025000000001},{"$f":"VLOOKUP(B34,'DATA (hide)'!$A$4:$Y$30,10,FALSE)","v":31000},{"$f":"VLOOKUP(B34,'DATA (hide)'!$A$4:$Y$30,8,FALSE)&\"-\"&VLOOKUP(B34,'DATA (hide)'!$A$4:$Y$30,9,FALSE)","v":"30000-36000"},{"$f":"ROUND(I34*10.7639,0)","v":333681},{"$f":"VLOOKUP(B34,'DATA (hide)'!$A$4:$Y$30,14,FALSE)","v":350},{"$f":"VLOOKUP(B34,'DATA (hide)'!$A$4:$Y$30,12,FALSE)&\"-\"&VLOOKUP(B34,'DATA (hide)'!$A$4:$Y$30,13,FALSE)","v":"204-369"},{"$f":"VLOOKUP(B34,'DATA (hide)'!$A$4:$Y$30,15,FALSE)","v":0.99},{"$f":"VLOOKUP(B34,'DATA (hide)'!$A$4:$Y$30,18,FALSE)","v":0.97850000000000004},{"$f":"VLOOKUP(B34,'DATA (hide)'!$A$4:$Y$30,16,FALSE)&\"-\"&VLOOKUP(B34,'DATA (hide)'!$A$4:$Y$30,17,FALSE)","v":"95-99"},null,null,null,null,null,"#5","(Select Crop)",{"$f":"VLOOKUP(W34,'DATA (hide)'!$A$4:$Y$30,2,FALSE)","v":0},{"$f":"VLOOKUP(W34,'DATA (hide)'!$A$4:$Y$30,3,FALSE)","v":"Bu"},{"$f":"VLOOKUP(W34,'DATA (hide)'!$A$4:$Y$30,4,FALSE)","v":1},{"$f":"AB34*(X34/Z34)","v":0},{"$f":"IF(AG34=0,0,ROUND(((AD34*AG34)/(AI34*AJ34))/10.4,1))","v":0},{"$f":"SUM(AB34/Z34)","v":0},{"$f":"VLOOKUP(W34,'DATA (hide)'!$A$4:$Y$30,10,FALSE)","v":0},{"$f":"VLOOKUP(W34,'DATA (hide)'!$A$4:$Y$30,8,FALSE)&\"-\"&VLOOKUP(W34,'DATA (hide)'!$A$4:$Y$30,9,FALSE)","v":"0-0"},{"$f":"ROUND(AD34*10.7639,0)","v":0},{"$f":"VLOOKUP(W34,'DATA (hide)'!$A$4:$Y$30,14,FALSE)","v":0},{"$f":"VLOOKUP(W34,'DATA (hide)'!$A$4:$Y$30,12,FALSE)&\"-\"&VLOOKUP(W34,'DATA (hide)'!$A$4:$Y$30,13,FALSE)","v":"0-0"},{"$f":"VLOOKUP(W34,'DATA (hide)'!$A$4:$Y$30,15,FALSE)","v":0},{"$f":"VLOOKUP(W34,'DATA (hide)'!$A$4:$Y$30,18,FALSE)","v":0},{"$f":"VLOOKUP(W34,'DATA (hide)'!$A$4:$Y$30,16,FALSE)&\"-\"&VLOOKUP(W34,'DATA (hide)'!$A$4:$Y$30,17,FALSE)","v":"0-0"}]
[]
[null,"(enter variety)","Acres",80,null,"Row Spacing (inches)",null,null,null,"Seed per 100ft. Row (grams)",{"$f":"ROUND((G34*F37)/11.5,1)","v":936488.7},null,"Seeds per acre",{"$f":"IF(I34=0,0,(I34*43560)/(N34*O34))","v":1393970362.8002045},null,null,null,null,null,null,null,null,"(enter variety)","Acres",0,null,"Row Spacing (inches)",null,null,null,"Seed per 100ft. Row (grams)",{"$f":"ROUND((AB34*AA37)/11.5,1)","v":0},null,"Seeds per acre",{"$f":"IF(AD34=0,0,(AD34*43560)/(AI34*AJ34))","v":0}]
[null,null,"Total Cost",{"$f":"SUM(D36*F34)","v":269240.5},null,10,null,null,null,"Seeds per ft. row",{"$f":"IF(L34=0,0,ROUND(((K36/100)*1000)/L34,1))","v":26756.799999999999},null,"Seeds per pound",{"$f":"IF(L34=0,0,ROUND((1000*453.592)/L34,0))","v":1296},null,null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(Y36*AA34)","v":0},null,10,null,null,null,"Seeds per ft. row",{"$f":"IF(AG34=0,0,ROUND(((AF36/100)*1000)/AG34,1))","v":0},null,"Seeds per pound",{"$f":"IF(AG34=0,0,ROUND((1000*453.592)/AG34,0))","v":0}]
[]
[]
["#6","(Select Crop)",{"$f":"VLOOKUP(B40,'DATA (hide)'!$A$4:$Y$30,2,FALSE)","v":0},{"$f":"VLOOKUP(B40,'DATA (hide)'!$A$4:$Y$30,3,FALSE)","v":"Bu"},{"$f":"VLOOKUP(B40,'DATA (hide)'!$A$4:$Y$30,4,FALSE)","v":1},{"$f":"G40*(C40/E40)","v":0},{"$f":"IF(L40=0,0,ROUND(((I40*L40)/(N40*O40))/10.4,1))","v":0},{"$f":"SUM(G40/E40)","v":0},{"$f":"VLOOKUP(B40,'DATA (hide)'!$A$4:$Y$30,10,FALSE)","v":0},{"$f":"VLOOKUP(B40,'DATA (hide)'!$A$4:$Y$30,8,FALSE)&\"-\"&VLOOKUP(B40,'DATA (hide)'!$A$4:$Y$30,9,FALSE)","v":"0-0"},{"$f":"ROUND(I40*10.7639,0)","v":0},{"$f":"VLOOKUP(B40,'DATA (hide)'!$A$4:$Y$30,14,FALSE)","v":0},{"$f":"VLOOKUP(B40,'DATA (hide)'!$A$4:$Y$30,12,FALSE)&\"-\"&VLOOKUP(B40,'DATA (hide)'!$A$4:$Y$30,13,FALSE)","v":"0-0"},{"$f":"VLOOKUP(B40,'DATA (hide)'!$A$4:$Y$30,15,FALSE)","v":0},{"$f":"VLOOKUP(B40,'DATA (hide)'!$A$4:$Y$30,18,FALSE)","v":0},{"$f":"VLOOKUP(B40,'DATA (hide)'!$A$4:$Y$30,16,FALSE)&\"-\"&VLOOKUP(B40,'DATA (hide)'!$A$4:$Y$30,17,FALSE)","v":"0-0"},null,null,null,null,null,"#6","(Select Crop)",{"$f":"VLOOKUP(W40,'DATA (hide)'!$A$4:$Y$30,2,FALSE)","v":0},{"$f":"VLOOKUP(W40,'DATA (hide)'!$A$4:$Y$30,3,FALSE)","v":"Bu"},{"$f":"VLOOKUP(W40,'DATA (hide)'!$A$4:$Y$30,4,FALSE)","v":1},{"$f":"AB40*(X40/Z40)","v":0},{"$f":"IF(AG40=0,0,ROUND(((AD40*AG40)/(AI40*AJ40))/10.4,1))","v":0},{"$f":"SUM(AB40/Z40)","v":0},{"$f":"VLOOKUP(W40,'DATA (hide)'!$A$4:$Y$30,10,FALSE)","v":0},{"$f":"VLOOKUP(W40,'DATA (hide)'!$A$4:$Y$30,8,FALSE)&\"-\"&VLOOKUP(W40,'DATA (hide)'!$A$4:$Y$30,9,FALSE)","v":"0-0"},{"$f":"ROUND(AD40*10.7639,0)","v":0},{"$f":"VLOOKUP(W40,'DATA (hide)'!$A$4:$Y$30,14,FALSE)","v":0},{"$f":"VLOOKUP(W40,'DATA (hide)'!$A$4:$Y$30,12,FALSE)&\"-\"&VLOOKUP(W40,'DATA (hide)'!$A$4:$Y$30,13,FALSE)","v":"0-0"},{"$f":"VLOOKUP(W40,'DATA (hide)'!$A$4:$Y$30,15,FALSE)","v":0},{"$f":"VLOOKUP(W40,'DATA (hide)'!$A$4:$Y$30,18,FALSE)","v":0},{"$f":"VLOOKUP(W40,'DATA (hide)'!$A$4:$Y$30,16,FALSE)&\"-\"&VLOOKUP(W40,'DATA (hide)'!$A$4:$Y$30,17,FALSE)","v":"0-0"}]
[]
[null,"(enter variety)","Acres",0,null,"Row Spacing (inches)",null,null,null,"Seed per 100ft. Row (grams)",{"$f":"ROUND((G40*F43)/11.5,1)","v":0},null,"Seeds per acre",{"$f":"IF(I40=0,0,(I40*43560)/(N40*O40))","v":0},null,null,null,null,null,null,null,null,"(enter variety)","Acres",0,null,"Row Spacing (inches)",null,null,null,"Seed per 100ft. Row (grams)",{"$f":"ROUND((AB40*AA43)/11.5,1)","v":0},null,"Seeds per acre",{"$f":"IF(AD40=0,0,(AD40*43560)/(AI40*AJ40))","v":0}]
[null,null,"Total Cost",{"$f":"SUM(D42*F40)","v":0},null,10,null,null,null,"Seeds per ft. row",{"$f":"IF(L40=0,0,ROUND(((K42/100)*1000)/L40,1))","v":0},null,"Seeds per pound",{"$f":"IF(L40=0,0,ROUND((1000*453.592)/L40,0))","v":0},null,null,null,null,null,null,null,null,null,"Total Cost",{"$f":"SUM(Y42*AA40)","v":0},null,10,null,null,null,"Seeds per ft. row",{"$f":"IF(AG40=0,0,ROUND(((AF42/100)*1000)/AG40,1))","v":0},null,"Seeds per pound",{"$f":"IF(AG40=0,0,ROUND((1000*453.592)/AG40,0))","v":0}]
[]
[]
[null,null,"Total Acres",{"$f":"D42+D36+D30+D24+D18+D12","v":640}]
[null,null," Total Seed Cost",{"$f":"ROUND(D43+D37+D31+D25+D19+D13,0)","v":528091}]
[null,null,"Average Seed Cost per Acre",{"$f":"IF(D46=0,0,D47/D46)","v":825.14218749999998}]
[]
["Note: This budget is only a guide and is not intended as an in-depth study of seeding rates. Interpretation and use of this information is the responsibility of the user.  If you need help with a budget, contact your nearest ARD and MASC Service Centre location."]
[]
[]
["Created and maintained by ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"December, 2021"]
["For more information, contact your nearest "]
["Roy Arnott",null,null,"Darren Bond",null,null,null,null,null,null,null,null,null,null,null,"D.V. thanks for the idea!"]
["Farm Management Specialist",null,null,"Farm Management Specialist"]

{"sheet":"Small Grains","index":1,"n_rows":28,"n_cols":28,"rows_kept":28,"cut":false,"hidden":false,"merged":[[6,25,6,26],[11,6,12,7],[25,0,26,11],[6,13,6,14],[6,9,6,10],[18,2,18,10],[11,3,12,4]]}
[]
[". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ."]
["Small Grains - Seeding Rate & Cost Calculator",null,null,null,null,null,null,null,null,null,"Printed:",{"$f":"TODAY()","v":"2025-05-13"}]
[]
[null,null,null,"*** Enter changes to BLUE values only ***",null,null,null,null,null,null,null,"Version 1.0"]
[]
[null,null,null,null,null,null,"Seed","1,000 Seed","Seed Survival1","Target Plant Stand Population",null,"Row "]
[null,"Wheat - Hard Red Spring",null,"Price",null,"Pounds","Germ","Wt. (grams)","Expected %","Plants/ft.2","Plants/m2","Spacing",null,null,null,null,null,"(Select Crop)"]
[null,null,"Acres",{"$f":"\"per \"&E10","v":"per Bu"},"unit",{"$f":"\"per \"&E10","v":"per Bu"},"%",{"$f":"\"(Range \"&VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,12,FALSE)&\"-\"&VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,13,FALSE)&\")\"","v":"(Range 31-38)"},{"$f":"\"(Range \"&VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,16,FALSE)&\"-\"&VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,17,FALSE)&\"%)\"","v":"(Range 85-90%)"},{"$f":"\"(Range \"&VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,8,FALSE)&\"-\"&VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,9,FALSE)&\")\"","v":"(Range 23-28)"},{"$f":"\"(Range \"&ROUND(VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,8,FALSE)*10.7639,0)&\"-\"&ROUND(VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,9,FALSE)*10.7639,0)&\")\"","v":"(Range 248-301)"},"(inches)"]
[null,"Enter Variety Name Here",160,{"$f":"VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,2,FALSE)","v":17},{"$f":"VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,3,FALSE)","v":"Bu"},{"$f":"VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,4,FALSE)","v":60},{"$f":"VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,15,FALSE)","v":0.95},{"$f":"VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,14,FALSE)","v":36},{"$f":"VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,18,FALSE)","v":0.85},{"$f":"VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,10,FALSE)","v":28},{"$f":"ROUND(J10*10.7639,0)","v":301},{"$f":"VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,19,FALSE)","v":10},null,null,null,null,null,"Enter Variety Name Here",0,{"$f":"VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,2,FALSE)","v":0},{"$f":"VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,3,FALSE)","v":"Bu"},{"$f":"VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,4,FALSE)","v":1},{"$f":"VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,15,FALSE)","v":0},{"$f":"VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,14,FALSE)","v":0},{"$f":"VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,18,FALSE)","v":0},{"$f":"VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,10,FALSE)","v":0},null,{"$f":"VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,19,FALSE)","v":10}]
[]
[null,null,"Seeding","Seeding Rate",null,{"$f":"E10&\" of\"","v":"Bu of"},"Seed Cost",null,"Seeds","Seeds","Seeds","Seed per"]
[null,null,"Rate",null,null,"Seed ",null,null,"per","per","per","100ft. Row"]
[null,null,"(lb./acre)",{"$f":"\"(\"&E10&\"/ac)\"","v":"(Bu/ac)"},{"$f":"\"(acres/\"&E10&\")\"","v":"(acres/Bu)"},"Required","$/acre","Total $","Pound","Sq. Foot","Foot Row","(grams)"]
[null,null,{"$f":"IF(H10=0,0,ROUND(((J10*H10)/(G10*I10))/10.4,1))","v":120},{"$f":"SUM(C15/F10)","v":2},{"$f":"IF(C15=0,0,SUM(F10/C15))","v":0.5},{"$f":"C10*D15","v":320},{"$f":"C15*(D10/F10)","v":34},{"$f":"SUM(C10*G15)","v":5440},{"$f":"IF(H10=0,0,ROUND((1000*453.592)/H10,0))","v":12600},{"$f":"IF(J10=0,0,(J10)/(G10*I10))","v":34.674922600619198},{"$f":"IF(H10=0,0,ROUND(((L15/100)*1000)/H10,1))","v":29},{"$f":"ROUND((C15*L10)/11.5,1)","v":104.3}]
[]
[null,"1 Seed/Seedling Survival % can be impacted by seed quality, seed placed fertilizer, insect damage, and frost damage."]
[]
[null,null,"Risk & Sensitivity Analysis (Stess Test) ",null,null,null,null,null,null,null,null,0.02]
[null,"Seed Survival %1",{"$f":"IF($I$10=0%,0%,D20-$L$19)","v":0.74999999999999989},{"$f":"IF($I$10=0%,0%,E20-$L$19)","v":0.76999999999999991},0.78999999999999992,0.80999999999999994,0.83,{"$f":"I10","v":0.85},{"$f":"IF($I$10=0%,0%,IF(H20+$L$19>100%,100%,H20+$L$19))","v":0.87},{"$f":"IF($I$10=0%,0%,IF(I20+$L$19>100%,100%,I20+$L$19))","v":0.89},0.91,0.93]
[null,"Seeding Rate (lbs/acre)",{"$f":"IF($H$10=0,0,ROUND((($J$10*$H$10)/($G$10*C20))/10.4,1))","v":136},132.5,{"$f":"IF($H$10=0,0,ROUND((($J$10*$H$10)/($G$10*E20))/10.4,1))","v":129.1},{"$f":"IF($H$10=0,0,ROUND((($J$10*$H$10)/($G$10*F20))/10.4,1))","v":126},122.9,120,117.3,114.6,112.1,109.7]
[null,"Seeding Rate (seed/sq.ft)",{"$f":"IF($J$10=0,0,($J$10)/($G$10*C20))","v":39.298245614035089},38.277511961722489,37.30846102598268,36.387264457439898,35.510462904248577,{"$f":"IF($J$10=0,0,($J$10)/($G$10*H20))","v":34.674922600619198},33.877797943133693,33.116499112950919,32.388663967611336,31.692133559705717]
[null,"Seed Cost ($/acre)",{"$f":"C21*($D$10/$F$10)","v":38.533333333333331},37.541666666666664,{"$f":"E21*($D$10/$F$10)","v":36.578333333333333},{"$f":"F21*($D$10/$F$10)","v":35.699999999999996},34.821666666666665,34,33.234999999999999,32.47,31.761666666666663,31.081666666666667]
[]
[]
["Note: This budget is only a guide and is not intended as an in-depth study of seeding rates. Interpretation and use of this information is the responsibility of the user.  If you need help with a budget, contact a Farm Management Specialist."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"May 2025"]

{"sheet":"Speciality Crop","index":2,"n_rows":30,"n_cols":28,"rows_kept":30,"cut":false,"hidden":false,"merged":[[11,6,12,7],[27,0,28,11],[7,9,7,10],[8,9,8,10],[9,9,9,10],[18,2,18,10],[11,3,12,4],[8,25,8,26],[9,25,9,26],[6,9,6,10],[6,13,6,14],[6,25,6,26],[7,25,7,26]]}
[]
[". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ."]
["Speciality Crop - Seeding Rate & Cost Calculator   ",null,null,null,null,null,null,null,null,null,"Printed:",{"$f":"TODAY()","v":"2025-05-13"}]
[]
[null,null,null,"*** Enter changes to BLUE values only ***",null,null,null,null,null,null,null,"Version 1.0"]
[]
[null,null,null,null,null,null,"Seed","1,000 Seed","Seed Survival1","Target Plant Stand Population",null,"Row ",null,null,null,null,null,null,null,null,null,null,"Seed","1,000 Seed","Seed Survival","Target Plant Stand Population",null,"Row "]
[null,"Soybeans",null,"Price",null,"Seeds","Germ","Wt. (grams)","Expected %","Plants/Acre",null,"Spacing",null,null,null,null,null,"(Select Crop - Other)",null,"Price",null,"Seeds","Germ","Wt. (grams)","Expected %","Plants/Acre",null,"Spacing"]
[null,null,"Acres",{"$f":"\"per \"&E10","v":"per Unit"},"unit",{"$f":"\"per \"&E10","v":"per Unit"},"%",{"$f":"\"(Range \"&VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,12,FALSE)&\"-\"&VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,13,FALSE)&\")\"","v":"(Range 100-200)"},{"$f":"\"(Range \"&VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,16,FALSE)&\"-\"&VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,17,FALSE)&\"%)\"","v":"(Range 75-80%)"},{"$f":"\"(Range \"&TEXT(VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,8,FALSE),\"#,###\")&\"-\"&TEXT(VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,9,FALSE),\"#,###\")&\")\"","v":"(Range 150,000-200,000)"},null,"(inches)",null,null,null,null,null,null,"Acres",{"$f":"\"per \"&U10","v":"per Bag"},"unit",{"$f":"\"per \"&U10","v":"per Bag"},"%",{"$f":"\"(Range \"&VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,12,FALSE)&\"-\"&VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,13,FALSE)&\")\"","v":"(Range 0-0)"},{"$f":"\"(Range \"&VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,16,FALSE)&\"-\"&VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,17,FALSE)&\"%)\"","v":"(Range 0-0%)"},{"$f":"\"(Range \"&TEXT(VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,8,FALSE),\"#,###\")&\"-\"&TEXT(VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,9,FALSE),\"#,###\")&\")\"","v":"(Range -)"},null,"(inches)"]
[null,"Enter Variety Name Here",160,{"$f":"VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,2,FALSE)","v":62.94},{"$f":"VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,3,FALSE)","v":"Unit"},{"$f":"VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,4,FALSE)","v":140000},{"$f":"VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,15,FALSE)","v":0.9},{"$f":"VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,14,FALSE)","v":150},{"$f":"VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,18,FALSE)","v":0.9},{"$f":"VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,10,FALSE)","v":162000},null,{"$f":"VLOOKUP(B8,'DATA (hide)'!$A$4:$Y$30,19,FALSE)","v":10},null,null,null,null,null,"Enter Variety Name Here",0,{"$f":"VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,2,FALSE)","v":0},{"$f":"VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,3,FALSE)","v":"Bag"},{"$f":"VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,4,FALSE)","v":1},{"$f":"VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,15,FALSE)","v":0},{"$f":"VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,14,FALSE)","v":0},{"$f":"VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,18,FALSE)","v":0},{"$f":"VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,10,FALSE)","v":0},null,{"$f":"VLOOKUP(R8,'DATA (hide)'!$A$4:$Y$30,19,FALSE)","v":10}]
[]
[null,null,"Seeding","Seeding Rate",null,{"$f":"E10&\" of\"","v":"Unit of"},"Seed Cost",null,"Seeds","Seeds","Seeds","Seed per"]
[null,null,"Rate",null,null,"Seed ",null,null,"per","per","per","100ft. Row"]
[null,null,"(lb./acre)",{"$f":"\"(\"&E10&\"/ac)\"","v":"(Unit/ac)"},{"$f":"\"(acres/\"&E10&\")\"","v":"(acres/Unit)"},"Required","$/acre","Total $","Pound","Acre","Foot Row","(grams)"]
[null,null,{"$f":"IF(H10=0,0,ROUND(((J10/1000)*(H10/453.6)/(G10*I10)),2))","v":66.14},{"$f":"IF(C15=0,0,SUM(C15/((H10/453.592)*(F10/1000))))","v":1.4285988038095239},{"$f":"IF(H10=0,0,SUM(F10/J15))","v":0.7},{"$f":"C10*D15","v":228.57580860952382},{"$f":"D15*D10","v":89.916008711771426},{"$f":"SUM(C10*G15)","v":14386.561393883429},{"$f":"IF(H10=0,0,ROUND((1000*453.592)/H10,0))","v":3024},{"$f":"IF(H10=0,0,ROUND((J10)/(G10*I10),-3))","v":200000},{"$f":"IF(H10=0,0,ROUND(((L15/100)*1000)/H10,1))","v":3.8},{"$f":"ROUND((C15*L10)/11.5,1)","v":57.5}]
[]
[null,"1 Seed/Seedling Survival % can be impacted by seed quality, seed placed fertilizer, insect damage, and frost damage."]
[]
[null,null,"Risk & Sensitivity Analysis (Stess Test) ",null,null,null,null,null,null,null,null,0.02]
[null,"Seed Survival %1",{"$f":"IF($I$10=0%,0%,D20-$L$19)","v":0.79999999999999993},{"$f":"IF($I$10=0%,0%,E20-$L$19)","v":0.82},0.84,0.86,0.88,{"$f":"I10","v":0.9},{"$f":"IF($I$10=0%,0%,IF(H20+$L$19>100%,100%,H20+$L$19))","v":0.92},{"$f":"IF($I$10=0%,0%,IF(I20+$L$19>100%,100%,I20+$L$19))","v":0.94000000000000006},0.96000000000000008,0.98000000000000009]
[null,"Seeding Rate (lbs/acre)",{"$f":"IF($H$10=0,0,ROUND((($J$10/1000)*($H$10/453.6)/($G$10*C20)),2))","v":74.400000000000006},{"$f":"IF($H$10=0,0,ROUND((($J$10/1000)*($H$10/453.6)/($G$10*D20)),2))","v":72.59},70.86,69.209999999999994,67.64,66.14,64.7,63.32,62,60.74]
[null,{"$f":"\"Seeding Rate (\"&E10&\"/ac)\"","v":"Seeding Rate (Unit/ac)"},{"$f":"IF($C$15=0,0,SUM(C21/(($H$10/453.6)*($F$10/1000))))","v":1.60704},{"$f":"IF($C$15=0,0,SUM(D21/(($H$10/453.6)*($F$10/1000))))","v":1.567944},1.5305759999999999,1.4949359999999998,1.4610239999999999,1.4286239999999999,1.3975200000000001,1.367712,1.3391999999999999,1.311984]
[null,"Seeding Rate (seeds/ac)",{"$f":"IF($H$10=0,0,ROUND(($J$10)/($G$10*C20),-3))","v":225000},220000,214000,209000,205000,{"$f":"IF($H$10=0,0,ROUND(($J$10)/($G$10*H20),-3))","v":200000},{"$f":"IF($H$10=0,0,ROUND(($J$10)/($G$10*I20),-3))","v":196000},191000,188000,184000]
[null,"Seed Cost ($/acre)",{"$f":"C22*$D$10","v":101.1470976},{"$f":"D22*$D$10","v":98.686395359999992},96.33445343999999,94.09127183999999,91.956850559999992,89.917594559999984,87.959908800000008,86.083793279999995,84.289248000000001,82.576272959999997]
[]
[]
[]
["Note: This budget is only a guide and is not intended as an in-depth study of seeding rates. Interpretation and use of this information is the responsibility of the user.  If you need help with a budget, contact a Farm Management Specialist."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"May 2025"]

{"sheet":"DATA (hide)","index":3,"n_rows":38,"n_cols":25,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[null,"Seed and Treatment",null,null,"Seed","Seeding","Seeding","Target Plant Stand Population",null,null,null,"1,000 Kernal Weight",null,null,"Seed","Seed Survival (Emergence)",null,null,"Row","Seed per","Seed","Seeds","Seeds per pound"]
[null,"Price",null,"Number","Cost","Rate","Rate","low range","high range","Optimal","Optimal","low range","high range","Actual","Germination","low range","high range","Expected","Spacing","100 ft. row","/ft. of","per","low","high"]
["Crop","per Unit","unit","per unit","($/acre)","(lb./acre)","(units/ac)","per ft.2","per ft.2","per ft.2","per m2","(grams)","(grams)","(grams)","%","%","%","%","(inches)","(grams)","row","acre","range","range","Actual"]
["(Select Crop)",0,"Bu",1,{"$f":"F4*(B4/D4)","v":0},{"$f":"IF(N4=0,0,ROUND(((J4*N4)/(O4*R4))/10.4,2))","v":0},{"$f":"SUM(F4/D4)","v":0},0,0,0,{"$f":"ROUND(J4*10.7639,0)","v":0},0,0,0,0,0,0,0,10,{"$f":"ROUND((F4*S4)/11.5,1)","v":0},{"$f":"IF(N4=0,0,ROUND(((T4/100)*1000)/N4,1))","v":0},{"$f":"IF(J4=0,0,(J4*43560)/(O4*R4))","v":0},{"$f":"IF(M4=0,0,ROUND((1000*453.592)/M4,0))","v":0},{"$f":"IF(L4=0,0,ROUND((1000*453.592)/L4,0))","v":0},{"$f":"IF(N4=0,0,ROUND((1000*453.592)/N4,0))","v":0}]
["Canola",825,"Bag",50,{"$f":"F5*(B5/D5)","v":82.664999999999992},{"$f":"ROUND(((J5*N5)/(O5*R5))/10.4,2)","v":5.01},{"$f":"SUM(F5/D5)","v":0.1002},3,12,7.5,81,3,7,4.95,0.95,40,80,0.75,10,{"$f":"ROUND((F5*S5)/11.5,1)","v":4.4000000000000004},{"$f":"ROUND(((T5/100)*1000)/N5,1)","v":8.9},{"$f":"(J5*43560)/(O5*R5)","v":458526.31578947377},{"$f":"ROUND((1000*453.592)/M5,0)","v":64799},{"$f":"ROUND((1000*453.592)/L5,0)","v":151197},{"$f":"ROUND((1000*453.592)/N5,0)","v":91635}]
["Wheat - Hard Red Spring",17,"Bu",60,{"$f":"F6*(B6/D6)","v":34.008499999999998},120.03,2.0005000000000002,23,28,28,301,31,38,36,0.95,85,90,0.85,10,104.4,29,1510439.628482972,11937,14632,12600]
["Wheat - Northern Hard Red",17,"Bu",60,34.008499999999998,120.03,2.0005000000000002,23,28,28,301,31,38,36,0.95,85,90,0.85,10,104.4,29,1510439.628482972,11937,14632,12600]
["Wheat - Prairie Spring",17,"Bu",60,42.511333333333333,150.04,2.5006666666666666,23,28,28,301,39,50,45,0.95,85,90,0.85,10,130.5,29,1510439.628482972,9072,11631,10080]
["Wheat - Winter",17,"Bu",60,37.448166666666665,132.16999999999999,2.202833333333333,30,35,30,323,30,40,37,0.95,85,90,0.85,10,114.9,31.1,1618328.173374613,11340,15120,12259]
["Wheat - Special Purpose",17,"Bu",60,34.008499999999998,120.03,2.0005000000000002,23,28,28,301,31,38,36,0.95,85,90,0.85,10,104.4,29,1510439.628482972,11937,14632,12600]
["Oats",10,"Bu",32,25.056250000000002,80.180000000000007,2.5056250000000002,20,30,23,248,30,45,31,0.95,85,90,0.9,10,69.7,22.5,1171789.4736842106,10080,15120,14632]
["Barley",10,"Bu",48,{"$f":"F12*(B12/D12)","v":19.9375},{"$f":"ROUND(((J12*N12)/(O12*R12))/10.4,2)","v":95.7},{"$f":"SUM(F12/D12)","v":1.9937500000000001},22,25,23,{"$f":"ROUND(J12*10.7639,0)","v":248},30,45,37,0.95,85,90,0.9,10,{"$f":"ROUND((F12*S12)/11.5,1)","v":83.2},{"$f":"ROUND(((T12/100)*1000)/N12,1)","v":22.5},{"$f":"(J12*43560)/(O12*R12)","v":1171789.4736842106},{"$f":"ROUND((1000*453.592)/M12,0)","v":10080},{"$f":"ROUND((1000*453.592)/L12,0)","v":15120},{"$f":"ROUND((1000*453.592)/N12,0)","v":12259}]
["Peas",28.33,"Bu",60,93.455948333333325,197.93,3.2988333333333335,7,9,8,86,125,300,220,0.95,85,90,0.9,10,172.1,7.8,407578.94736842107,1512,3629,2062]
["Flaxseed",54,"Bu",56,56.39142857142857,58.48,1.0442857142857143,28,48,40,431,5,6.5,6.5,0.95,40,75,0.45,10,50.9,78.3,4075789.4736842108,69783,90718,69783]
["Hempseed",2.35,"Lb",1,{"$f":"F15*(B15/D15)","v":59.807499999999997},{"$f":"ROUND(((J15*N15)/(O15*R15))/10.4,2)","v":25.45},{"$f":"SUM(F15/D15)","v":25.45},10,12,11,{"$f":"ROUND(J15*10.7639,0)","v":118},13.5,21.5,16,0.95,70,75,0.7,10,{"$f":"ROUND((F15*S15)/11.5,1)","v":22.1},{"$f":"ROUND(((T15/100)*1000)/N15,1)","v":13.8},{"$f":"(J15*43560)/(O15*R15)","v":720541.35338345869},{"$f":"ROUND((1000*453.592)/M15,0)","v":21097},{"$f":"ROUND((1000*453.592)/L15,0)","v":33599},{"$f":"ROUND((1000*453.592)/N15,0)","v":28350}]
["Fababean",0.3,"Lb",1,{"$f":"F16*(B16/D16)","v":53.981999999999999},{"$f":"ROUND(((J16*N16)/(O16*R16))/10.4,2)","v":179.94},{"$f":"SUM(F16/D16)","v":179.94},4,4.3,4,{"$f":"ROUND(J16*10.7639,0)","v":43},350,425,400,0.95,85,90,0.9,10,{"$f":"ROUND((F16*S16)/11.5,1)","v":156.5},{"$f":"ROUND(((T16/100)*1000)/N16,1)","v":3.9},{"$f":"(J16*43560)/(O16*R16)","v":203789.47368421053},{"$f":"ROUND((1000*453.592)/M16,0)","v":1067},{"$f":"ROUND((1000*453.592)/L16,0)","v":1296},{"$f":"ROUND((1000*453.592)/N16,0)","v":1134}]
["Buckwheat",33,"Bu",48,{"$f":"F17*(B17/D17)","v":32.470624999999998},{"$f":"ROUND(((J17*N17)/(O17*R17))/10.4,2)","v":47.23},{"$f":"SUM(F17/D17)","v":0.98395833333333327},13,17,14,{"$f":"ROUND(J17*10.7639,0)","v":151},30,30,30,0.95,85,90,0.9,10,{"$f":"ROUND((F17*S17)/11.5,1)","v":41.1},{"$f":"ROUND(((T17/100)*1000)/N17,1)","v":13.7},{"$f":"(J17*43560)/(O17*R17)","v":713263.15789473685},{"$f":"ROUND((1000*453.592)/M17,0)","v":15120},{"$f":"ROUND((1000*453.592)/L17,0)","v":15120},{"$f":"ROUND((1000*453.592)/N17,0)","v":15120}]
["Canaryseed",0.75,"Lb",1,{"$f":"F18*(B18/D18)","v":33.734999999999999},{"$f":"ROUND(((J18*N18)/(O18*R18))/10.4,2)","v":44.98},{"$f":"SUM(F18/D18)","v":44.98},40,55,50,{"$f":"ROUND(J18*10.7639,0)","v":538},7,10,8,0.95,85,90,0.9,10,{"$f":"ROUND((F18*S18)/11.5,1)","v":39.1},{"$f":"ROUND(((T18/100)*1000)/N18,1)","v":48.9},{"$f":"(J18*43560)/(O18*R18)","v":2547368.4210526315},{"$f":"ROUND((1000*453.592)/M18,0)","v":45359},{"$f":"ROUND((1000*453.592)/L18,0)","v":64799},{"$f":"ROUND((1000*453.592)/N18,0)","v":56699}]
["Lentil",35,"Bu",60,{"$f":"F19*(B19/D19)","v":71.639166666666668},{"$f":"ROUND(((J19*N19)/(O19*R19))/10.4,2)","v":122.81},{"$f":"SUM(F19/D19)","v":2.0468333333333333},10,14,14,{"$f":"ROUND(J19*10.7639,0)","v":151},30,80,65,0.95,75,80,0.75,10,{"$f":"ROUND((F19*S19)/11.5,1)","v":106.8},{"$f":"ROUND(((T19/100)*1000)/N19,1)","v":16.399999999999999},{"$f":"(J19*43560)/(O19*R19)","v":855915.78947368427},{"$f":"ROUND((1000*453.592)/M19,0)","v":5670},{"$f":"ROUND((1000*453.592)/L19,0)","v":15120},{"$f":"ROUND((1000*453.592)/N19,0)","v":6978}]
["(Select Crop - Other)",0,"Bag",1,{"$f":"F20*(B20/D20)","v":0},{"$f":"IF(N20=0,0,ROUND(((J20*N20)/(O20*R20))/10.4,2))","v":0},{"$f":"SUM(F20/D20)","v":0},0,0,0,{"$f":"ROUND(J20*10.7639,0)","v":0},0,0,0,0,0,0,0,10,{"$f":"ROUND((F20*S20)/11.5,1)","v":0},{"$f":"IF(N20=0,0,ROUND(((T20/100)*1000)/N20,1))","v":0},{"$f":"IF(J20=0,0,(J20*43560)/(O20*R20))","v":0},{"$f":"IF(M20=0,0,ROUND((1000*453.592)/M20,0))","v":0},{"$f":"IF(L20=0,0,ROUND((1000*453.592)/L20,0))","v":0},{"$f":"IF(N20=0,0,ROUND((1000*453.592)/N20,0))","v":0}]
["Fall Rye - Hybrid",98,"Unit",1000000,{"$f":"(B21*G21)","v":78.402038399999995},{"$f":"ROUND(((J21/1000)*(N21/453.6)/(O21*R21)),2)","v":61.73},{"$f":"SUM(F21/((N21/453.6)*(D21/1000)))","v":0.80002079999999998},800000,800000,684000,{"$f":"ROUND((J21/43560)*10.7639,1)","v":169},31.75,40.82,35,0.95,85,90,0.9,10,{"$f":"ROUND((F21*S21)/11.5,1)","v":53.7},{"$f":"ROUND(((T21/100)*1000)/N21,1)","v":15.3},{"$f":"(J21)/(O21*R21)","v":800000},{"$f":"ROUND((1000*453.592)/M21,0)","v":11112},{"$f":"ROUND((1000*453.592)/L21,0)","v":14286},{"$f":"ROUND((1000*453.592)/N21,0)","v":12960}]
["Soybeans",62.94,"Unit",140000,{"$f":"(B22*G22)","v":89.917594559999984},{"$f":"ROUND(((J22/1000)*(N22/453.6)/(O22*R22)),2)","v":66.14},{"$f":"SUM(F22/((N22/453.6)*(D22/1000)))","v":1.4286239999999999},150000,200000,162000,{"$f":"ROUND((J22/43560)*10.7639,1)","v":40},100,200,150,0.9,75,80,0.9,10,{"$f":"ROUND((F22*S22)/11.5,1)","v":57.5},{"$f":"ROUND(((T22/100)*1000)/N22,1)","v":3.8},{"$f":"(J22)/(O22*R22)","v":200000},{"$f":"ROUND((1000*453.592)/M22,0)","v":2268},{"$f":"ROUND((1000*453.592)/L22,0)","v":4536},{"$f":"ROUND((1000*453.592)/N22,0)","v":3024}]
["Corn - Grain",250,"Bag",80000,{"$f":"(B23*G23)","v":99.994500000000016},{"$f":"ROUND(((J23/1000)*(N23/453.6)/(O23*R23)),2)","v":24.69},{"$f":"SUM(F23/((N23/453.6)*(D23/1000)))","v":0.39997800000000006},30000,36000,31000,{"$f":"ROUND((J23/43560)*10.7639,1)","v":7.7},204,369,350,0.99,95,99,0.97850000000000004,30,{"$f":"ROUND((F23*S23)/11.5,1)","v":64.400000000000006},{"$f":"ROUND(((T23/100)*1000)/N23,1)","v":1.8},{"$f":"(J23)/(O23*R23)","v":32001.156170803592},{"$f":"ROUND((1000*453.592)/M23,0)","v":1229},{"$f":"ROUND((1000*453.592)/L23,0)","v":2223},{"$f":"ROUND((1000*453.592)/N23,0)","v":1296}]
["Corn - Silage",250,"Bag",80000,{"$f":"(B24*G24)","v":87.520499999999998},{"$f":"ROUND(((J24/1000)*(N24/453.6)/(O24*R24)),2)","v":21.61},{"$f":"SUM(F24/((N24/453.6)*(D24/1000)))","v":0.350082},26000,32000,27000,{"$f":"ROUND((J24/43560)*10.7639,1)","v":6.7},204,369,350,0.99,95,99,0.97399999999999998,30,56.4,1.6,{"$f":"(J24)/(O24*R24)","v":28000.74668657831},1229,2223,1296]
["Beans - Pinto",140,"Unit",100000,{"$f":"(B25*G25)","v":112.455},{"$f":"ROUND(((J25/1000)*(N25/453.6)/(O25*R25)),2)","v":63.75},{"$f":"SUM(F25/((N25/453.6)*(D25/1000)))","v":0.80325000000000002},55000,60000,60000,{"$f":"ROUND((J25/43560)*10.7639,1)","v":14.8},320,375,360,0.9,75,80,0.83,30,166.3,4.5999999999999996,{"$f":"(J25)/(O25*R25)","v":80321.28514056225},1210,1417,1260]
["Beans - White",100,"Unit",100000,109.74852,48.39,1.0974851999999999,75000,80000,80000,19.8,190,210,200,0.9,75,80,0.81,30,126.2,6.3,109739.36899862824,2160,2387,2268]
["Beans - Black",92,"Unit",100000,114.9903216,55.11,1.2498948000000001,85000,90000,90000,22.2,190,210,200,0.9,75,80,0.8,15,71.900000000000006,3.6,124999.99999999999,2160,2387,2268]
["Beans - Kidney",222,"Unit",100000,167.48366943396226,88.15,0.75443094339622641,75000,80000,55000,13.6,450,600,530,0.9,75,80,0.81,30,230,4.3,75445.816186556913,756,1008,856]
["Sunflower Oil",470,"Bag",200000,50.029055999999997,3.52,0.10644479999999999,19000,22000,20000,4.9000000000000004,51,90,75,0.99,95,99,0.95,30,{"$f":"ROUND((F29*S29)/11.5,1)","v":9.1999999999999993},{"$f":"ROUND(((T29/100)*1000)/N29,1)","v":1.2},21265.284423179161,{"$f":"ROUND((1000*453.592)/M29,0)","v":5040},{"$f":"ROUND((1000*453.592)/L29,0)","v":8894},{"$f":"ROUND((1000*453.592)/N29,0)","v":6048}]
["Sunflower Confectionary",500,"Bag",200000,42.524999999999999,3.75,8.5050000000000001E-2,14000,18000,16000,4,91,151,100,0.99,95,99,0.95,30,9.8000000000000007,1,17012.227538543328,3004,4985,4536]
[]
[]
[]
[]
["Seeding rate (lb./ac.) = ((Plants/ft.2 x TKW (g)) ÷ (germination% x seed survival rate%))  / 10.4 (conversion factor)"]
["Seed weight per 100 ft./row (g) = (seeding rate (lb./ac.) x row spacing (in.)) / 11.5 (conversion factor)"]
["Seed per foot of row = ((Seed Weight per 100 ft (g) /100) * 1000) / TKW (g)"]
["Seeds/ac = plants per acre / (germination% x seed survival%)"]

{"sheet":"names (hide)","index":4,"n_rows":66,"n_cols":3,"rows_kept":66,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["UNIT","ROW","CROP"]
["Lb",5.5]
["Bu",{"$f":"SUM(B5+0.5)","v":6}]
["Bag",6.5]
["Unit",7]
["Kg",7.5]
["Tonne",8]
[null,8.5]
[null,9]
[null,9.5]
[null,10]
[null,10.5]
[null,11]
[null,11.5]
[null,12]
[null,12.5]
[null,13]
[null,13.5]
[null,14]
[null,14.5]
[null,15]
[null,15.5]
[null,16]
[null,16.5]
[null,17]
[null,17.5]
[null,18]
[null,18.5]
[null,19]
[null,19.5]
[null,20]
[null,20.5]
[null,21]
[null,21.5]
[null,{"$f":"SUM(B37+0.5)","v":22}]
[null,22.5]
[null,23]
[null,23.5]
[null,24]
[null,24.5]
[null,25]
[null,25.5]
[null,26]
[null,26.5]
[null,27]
[null,27.5]
[null,28]
[null,28.5]
[null,29]
[null,29.5]
[null,30]
[null,30.5]
[null,31]
[null,31.5]
[null,32]
[null,32.5]
[null,33]
[null,33.5]
[null,34]
[null,34.5]
[null,35]
[null,35.5]
[null,36]

{"sheet":"Seeding Rates DV (hide)","index":5,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":true,"merged":[[0,9,0,10],[0,13,0,14],[1,3,1,4],[1,9,1,10],[1,11,1,12],[1,13,1,14]]}
[null,null,null,null,null,null,"Emergence"]
["Crop","Variety",null,"Optimal Targeted Stand",null,"Germination (%)","Mortality (%)","Row Spacing","TKW","Targeted Seeding Rate"]
["Wheat","Brandon",null,32,"plants/ft2",99,15,7.5,39.159999999999997,{"$f":"((D3*I3)/((F3/100)*(1-(G3/100))))/10.4","v":143.18753142282551},"lbs/ac"]
[null,null,null,"32-34",null,null,"10-15%",null,null,{"$f":"SUM(J3*H3/11.5)","v":93.383172667060123},"grams seed/100ft row"]
[null,null,null,null,null,null,null,null,null,{"$f":"((J4/100)*1000)/I3","v":23.846571161149164},"seeds/ft of row"]
[]
["Oats","ORE3542",null,29,"plants/ft2",99,15,7.5,40.299999999999997,{"$f":"((D7*I7)/((F7/100)*(1-(G7/100))))/10.4","v":133.54129530600116},"lbs/ac"]
[null,null,null,"28-30",null,null,"10-15%",null,null,{"$f":"SUM(J7*H7/11.5)","v":87.092149112609462},"grams seed/100ft row"]
[null,null,null,null,null,null,null,null,null,{"$f":"((J8/100)*1000)/I7","v":21.610955114791434},"seeds/ft of row"]
[]
["Canola","L233P",null,7,"plants/ft2",99,25,7.5,4.3,{"$f":"((D11*I11)/((F11/100)*(1-(G11/100))))/10.4","v":3.8979538979538981},"lbs/ac"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J11*H11/11.5)","v":2.5421438464916726},"grams seed/100ft row"]
[null,null,null,null,null,null,null,null,null,{"$f":"((J12/100)*1000)/I11","v":5.9119624337015644},"seeds/ft of row"]
[null,null,null,7,"plants/ft2",99,25,15,4.3,{"$f":"((D14*I14)/((F14/100)*(1-(G14/100))))/10.4","v":3.8979538979538981},"lbs/ac"]
[null,null,null,"7 to 14",null,null,"20-60%",null,null,{"$f":"SUM(J14*H14/11.5)","v":5.0842876929833452},"grams seed/100ft row"]
[null,null,null,null,null,null,null,null,null,{"$f":"((J15/100)*1000)/I14","v":11.823924867403129},"seeds/ft of row"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"((D19*I19)/((F19/100)*(1-(G19/100))))/10.4","v":47.11782572745139},"lbs/ac","**two different calcs, same number"]
["Navies","T9905",80000,{"$f":"C19/43560","v":1.8365472910927456},"plants/ft2",90,15,30,{"$f":"0.45*B36","v":204.1164},{"$f":"((J20*I19)/1000)/B36","v":47.058823529411761},"lbs/ac"]
[null,null,null,"85-100",null,null,"10-15%",null,null,{"$f":"((C19)/((F19/100)*(1-(G19/100))))","v":104575.16339869281},"seeds/ac"]
[null,null,null,null,null,null,null,null,null,2140,"seeds/lb"]
["Soybeans","RR1",160000,{"$f":"C22/43560","v":3.6730945821854912},"plants/ft2",82,20,15,111.57,{"$f":"((D22*I22)/((F22/100)*(1-(G22/100))))/10.4","v":60.067888504695595},"lbs/ac"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J22*H22/11.5)","v":78.349419788733385},"grams seed/100ft row"]
[null,null,null,null,null,null,null,null,null,{"$f":"((J23/100)*1000)/I22","v":7.0224450827940652},"seeds/ft of row"]
[null,null,null,null,null,null,null,null,null,4122,"seeds/lb"]
[null,null,160000,{"$f":"C26/43560","v":3.6730945821854912},"plants/ft2",92,20,7.5,111.57,{"$f":"((D26*I26)/((F26/100)*(1-(G26/100))))/10.4","v":53.538770188967803},"lbs/ac"]
[null,null,null,"140-160",null,null,"10-25%",null,null,{"$f":"SUM(J26*H26/11.5)","v":34.916589253674658},"grams seed/100ft row"]
[null,null,null,null,null,null,null,null,null,{"$f":"((J27/100)*1000)/I26","v":3.1295679173321376},"seeds/ft of row"]
[null,null,null,null,null,null,null,null,null,4122,"seeds/lb"]
[]
["Seeding rate for canola = 9.6 x target plant stand x TKW = Seeding Rate / % Survivability",null,null,null,null,"Seeding rate (lb./ac.) = (Plants/ft.2 x TKW (g) ÷ seed survival rate)  / 10.4 (conversion factor)"]
["Targeted plant stand = 7 plants/ft2",null,null,null,null,"Seed weight per 100 ft./row (g) = (seeding rate (lb./ac.) x row spacing (in.)) / 11.5 (conversion factor)"]
["Emergence = 50% in cold conditions and 75% in good conditions",null,null,null,null,"Seed per foot of row = ((Seed Weight per 100 ft (g) /100) * 1000) / TKW (g)"]
[null,null,null,null,null,"seeds/ac"," = plants per acre / (germ% x (1-mortality%))"]
["1 AC = ",43560,"ft2",null,null,"https://2020seedlabs.ca/1000-kernel-weight/"]
["1 LB =",453.59199999999998,"grams"]
[]
["To find Soybean seeds/lb"]
[null,"Weight out 100 grams of seed"]
[null,"Count all seeds"]
[null,"Multiply by 4.54"]
["***For splits, count them seperatly and divide by 2 to add with the total.  Then bump seeding rate!***"]