{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Disease Breakeven Calculator","Data (HIDE)"],"not_rendered":{"charts":3,"images":2,"macros":1,"external_links":1,"defined_names":7,"comments":1,"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":"Disease Breakeven Calculator","index":0,"n_rows":74,"n_cols":14,"rows_kept":74,"cut":false,"hidden":false,"merged":[[55,0,55,3],[56,0,56,3],[58,0,60,4],[28,1,28,3],[9,1,11,1],[12,1,14,1],[32,1,32,3],[34,1,34,3],[54,0,54,3]]}
[]
[". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ."]
["Fusarium & Sclerotinia Breakeven Calculator",null,null,"Printed:",{"$f":"TODAY()","v":"2022-11-28"}]
[]
[null,"*** Enter/select changes to items in BLUE only ***"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"**HIDE**"]
[]
[null,"Crop (Select from dropdown)","Wheat - Hard Red Spring"]
[]
[null,{"$f":"\"Estimated \"&C8&\" Yield\"","v":"Estimated Wheat - Hard Red Spring Yield"}]
[null,null,{"$f":"VLOOKUP('Disease Breakeven Calculator'!$C$8,'Data (HIDE)'!$A$2:$G$9,2,FALSE)","v":64},"bu/ac",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Disease Breakeven Calculator'!$C$8,'Data (HIDE)'!$A$2:$G$9,2,FALSE)","v":64}]
[]
[null,{"$f":"\"Estimated \"&C8&\" Price\"","v":"Estimated Wheat - Hard Red Spring Price"}]
[null,null,{"$f":"VLOOKUP('Disease Breakeven Calculator'!$C$8,'Data (HIDE)'!$A$2:$G$9,4,FALSE)","v":10.5},"$/bu",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Disease Breakeven Calculator'!$C$8,'Data (HIDE)'!$A$2:$G$9,4,FALSE)","v":10.5}]
[]
[]
[null,"Disease Treatment"]
[]
[null,"Estimated Seed Treatment Cost",{"$f":"VLOOKUP('Disease Breakeven Calculator'!$C$8,'Data (HIDE)'!$A$2:$G$9,5,FALSE)","v":1.5},"$/acre",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Disease Breakeven Calculator'!$C$8,'Data (HIDE)'!$A$2:$G$9,5,FALSE)","v":1.5}]
[]
[null,"Estimated Fungicide Cost",{"$f":"VLOOKUP('Disease Breakeven Calculator'!$C$8,'Data (HIDE)'!$A$2:$G$9,6,FALSE)","v":19.5},"$/acre",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Disease Breakeven Calculator'!$C$8,'Data (HIDE)'!$A$2:$G$9,6,FALSE)","v":19.5}]
[]
[null,"Estimated Application Cost",{"$f":"VLOOKUP('Disease Breakeven Calculator'!$C$8,'Data (HIDE)'!$A$2:$G$9,7,FALSE)","v":9},"$/acre",null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Disease Breakeven Calculator'!$C$8,'Data (HIDE)'!$A$2:$G$9,7,FALSE)","v":9}]
[]
[null,"Total Cost",{"$f":"SUM(C23+C21+C19)","v":30},"$/acre"]
[]
[]
[]
[null,"Breakeven Analysis  (compared to untreated)"]
[]
[null,{"$f":"\"Yield Increase Only Required to Breakeven = \"&ROUND(($C$25)/$C$14,1)&\" bushels / acre    (or \"&TEXT((($C$25/$C$14)/C11)*100,\"0.0\")&\"%)\"","v":"Yield Increase Only Required to Breakeven = 2.9 bushels / acre    (or 4.5%)"},null,null,null,null,null,null,null,"Can we hide or delete these rows now with the graphs???"]
[]
[null,{"$f":"\"Price Increase Only Required to Breakeven = $\"&TEXT(ROUND(($C$25)/$C$11,2),\"0.00\")&\" / bushel\"","v":"Price Increase Only Required to Breakeven = $0.47 / bushel"},null,null,null,null,"grey out for canola"]
[]
[null,{"$f":"\"Yield & Price Increase Required to Breakeven = \"&ROUND((($C$25)/$C$14)/2,1)&\" bu/ac & $\"&TEXT(ROUND((($C$25)/$C$11)/2,2),\"0.00\")&\" / bushel\"","v":"Yield & Price Increase Required to Breakeven = 1.4 bu/ac & $0.23 / bushel"},null,null,null,null,"grey out for canola"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Breakeven Formulas:"]
[{"$f":"\"B/E Yield = Total Cost of Treatment / Price per bu   (eg. $\"&C25&\" cost / $\"&C14&\" price = \"&ROUND(($C$25)/$C$14,1)&\" bu/acre or \"&TEXT((($C$25/$C$14)/C11)*100,\"0.0\")&\"%)\"","v":"B/E Yield = Total Cost of Treatment / Price per bu   (eg. $30 cost / $10.5 price = 2.9 bu/acre or 4.5%)"}]
[{"$f":"\"B/E Price = Total Cost of Treatment / Yield per acre   (eg. $\"&C25&\" cost / \"&C11&\" bu = $\"&TEXT(ROUND(($C$25)/$C$11,2),\"0.00\")&\"/bu)\"","v":"B/E Price = Total Cost of Treatment / Yield per acre   (eg. $30 cost / 64 bu = $0.47/bu)"}]
[{"$f":"\"B/E Yield & Price = (B/E Yield / 2) & (B/E Price / 2) (eg. (\"&ROUND(($C$25)/$C$14,1)&\" bu/acre) / 2  = \"&ROUND((($C$25)/$C$14)/2,1)&\" bu/ac & ($\"&TEXT(ROUND(($C$25)/$C$11,2),\"0.00\")&\"/bu) / 2 = $\"&TEXT(ROUND((($C$25)/$C$11)/2,2),\"0.00\")&\"/bu\"","v":"B/E Yield & Price = (B/E Yield / 2) & (B/E Price / 2) (eg. (2.9 bu/acre) / 2  = 1.4 bu/ac & ($0.47/bu) / 2 = $0.23/bu"}]
[]
["Note: This budget is only a guide and is not intended as an in-depth study of crop disease management. 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,"November, 2022"]
[]
[]
[]
[]
[null,"Wheat - Hard Red Spring",null,null,null,null,"**HIDE**"]
[null,"Wheat - Northern Hard Red",null,null,null,null,"**HIDE**"]
[null,"Wheat - Special Purpose",null,null,null,null,"**HIDE**"]
[null,"Wheat - Prairie Spring",null,null,null,null,"**HIDE**"]
[null,"Wheat - Winter",null,null,null,null,"**HIDE**"]
[null,"Barley",null,null,null,null,"**HIDE**"]
[null,"Oats",null,null,null,null,"**HIDE**"]
[null,"Canola",null,null,null,null,"**HIDE**"]

{"sheet":"Data (HIDE)","index":1,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[null,"Yield","Unit","Price","Seed Treatment","Fungicide","Application"]
["Wheat - Hard Red Spring",64,"bu",10.5,1.5,19.5,9]
["Wheat - Northern Hard Red",70,"bu",10.5,1.5,19.5,{"$f":"G2","v":9}]
["Wheat - Special Purpose",60,"bu",9.75,1.5,19.5,{"$f":"G2","v":9}]
["Wheat - Prairie Spring",70,"bu",10,1.5,19.5,{"$f":"G2","v":9}]
["Wheat - Winter",66,"bu",9.75,1.5,19.5,{"$f":"G2","v":9}]
["Barley",78,"bu",7.25,1.5,19.5,{"$f":"G2","v":9}]
["Oats",120,"bu",5,1.5,12.5,{"$f":"G2","v":9}]
["Canola",44,"bu",17,0,20.5,{"$f":"G2","v":9}]
[]
[]
[]
["**Graphs - DO NOT DELETE**"]
[null,"Price Increase Required to Breakeven"]
[null,"Yield Increase Required to Breakeven"]
[null,"Yield Increase (Bu/Ac)","Price Increase ($/Bu)","Yield Increase (%)"]
["Yield or Price",{"$f":"ROUND(('Disease Breakeven Calculator'!$C$25)/'Disease Breakeven Calculator'!$C$14,1)","v":2.9},{"$f":"IF('Disease Breakeven Calculator'!$C$8=\"canola\",\"\",ROUND('Disease Breakeven Calculator'!$C$25/'Disease Breakeven Calculator'!$C$11,2))","v":0.47},{"$f":"ROUND(((('Disease Breakeven Calculator'!$C$25/'Disease Breakeven Calculator'!$C$14)/'Disease Breakeven Calculator'!$C$11)*100),\"1\")","v":4.5}]
["Yield & Price",{"$f":"IF('Disease Breakeven Calculator'!$C$8=\"canola\",\"n/a\",ROUND(('Disease Breakeven Calculator'!$C$25/'Disease Breakeven Calculator'!$C$14)/2,1))","v":1.4},{"$f":"IF('Disease Breakeven Calculator'!$C$8=\"canola\",\"n/a\",ROUND(C17/2,2))","v":0.24}]
[]
["Based on Price Increase Only"]
["Based on both Yield & Price Increases"]
["Based on Yield Increase Only"]
[null,null,null,null,""]