{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Lodging Decision Tool","Yield & Risk Factors"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"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":"Lodging Decision Tool","index":0,"n_rows":73,"n_cols":10,"rows_kept":73,"cut":false,"hidden":false,"merged":[[9,5,9,7],[8,5,8,7],[10,5,10,7],[59,0,61,9],[15,7,15,8],[35,7,35,8],[23,7,23,8],[43,6,43,9],[45,6,45,9],[34,0,34,9],[11,5,11,7],[47,0,47,9]]}
[]
[". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ."]
["PGR Lodging Management Decision Tool for Wheat",null,null,null,null,null,null,"Printed:",{"$f":"TODAY()","v":"2025-04-22"}]
[null,null,null,null,null,null,null,null,"Version 1.0"]
[null,null,"*** Enter/select changes to items in BLUE only ***"]
[]
["Step #1 - Yield and Risk Factors"]
[null,1.1000000000000001,"Target Wheat Yield (bu/acre) = ",null,null,80,"bu/ac ",null,null,"For more information:"]
[null,1.2,"Cultivar Lodging Rating",null,null,"VG"]
[null,1.3,"Nitrogen Fertilizer Applied",null,null,"Recommeded rate: 125 to 145 lb/acre"]
[null,1.4,"Seeding Rate",null,null,"Medium: 23-30 plants/ft2 (1.75 to 1.9 bu/acre)"]
[null,1.5,"Fungicide Applied",null,null,"Yes"]
[]
[null," =","Lodging Risk Factor (0 to 1 scale)  =",null,null,null,{"$f":"'Yield & Risk Factors'!J32","v":0.31}]
[]
[null,null,null,null,null,null,null,"Range"]
["Step #2 - Yield Loss From Lodging",null,null,null,null,null,null,"Low","High"]
[null,null,"Potential Yield Loss Due to Lodging",null,null,null,null,0.1,0.3]
[null,"x","Target Yield Lodging Yield Risk Factor",null,null,null,null,{"$f":"G14","v":0.31},{"$f":"G14","v":0.31}]
[null," =","Estimated Yield Loss From Lodging",null,null,null,null,{"$f":"SUM(H18*H19)","v":3.1E-2},{"$f":"SUM(I18*I19)","v":9.2999999999999999E-2}]
[null,"x","Target Yield (bu/acre)",null,null,null,null,{"$f":"F8","v":80},{"$f":"F8","v":80}]
[null," =","Est. Yield Loss From Lodging (bu/acre)",null,null,null,null,{"$f":"ROUND(H20*H21,1)","v":2.5},{"$f":"ROUND(I20*I21,1)","v":7.4}]
[]
[null,null,null,null,null,null,null,"Range"]
["Step #3 - Revenue Loss Due to Lodging",null,null,null,null,null,null,"Low","High"]
[null,null,"Est. Market Price ($/bu)",null,null,8]
[null,"x","Est. Yield Loss From Lodging (bu/acre)",null,null,null,null,{"$f":"H22","v":2.5},{"$f":"I22","v":7.4}]
[null," =","Est. Loss From Lodging ($/acre)",null,null,null,null,{"$f":"ROUND($F$26*H22,0)","v":20},{"$f":"ROUND($F$26*I22,0)","v":59}]
[]
["Step #4 - Lodging Management Cost"]
[null,null,"PGR Cost ($/acre)",null,null,18.5]
[null,"+","Application Cost ($/acre)",null,null,11]
[null," =","Total Cost ($/acre)",null,null,{"$f":"SUM(F31:F32)","v":29.5}]
[]
["Lodging Management Profitability Analysis"]
[null,null,null,null,null,null,null,"Range"]
[null,null,null,null,null,null,null,"Low","High"]
[null,null,"Est. Loss From Lodging ($/acre)",null,null,null,null,{"$f":"H28","v":20},{"$f":"I28","v":59}]
[null,"-","Total Cost ($/acre)",null,null,null,null,{"$f":"ROUND($F$33,0)","v":30},{"$f":"ROUND($F$33,0)","v":30}]
[null," =","Potential Return ($/acre)",null,null,null,null,{"$f":"SUM(H38-H39)","v":-10},{"$f":"SUM(I38-I39)","v":29}]
[]
[null," =","Potential Return on Investment (ROI)",null,null,null,null,{"$f":"SUM(H40/H39)","v":-0.33333333333333331},{"$f":"SUM(I40/I39)","v":0.96666666666666667}]
[]
[{"$f":"\"Low Range of Yield Loss (\"&H18*100&\"% or \"&$H$22&\" bu/ac) -\"","v":"Low Range of Yield Loss (10% or 2.5 bu/ac) -"},null,null,null,null,null,{"$f":"IF($H$42<-5%,$A$71,IF(H42<5%,$A$72,$A$73))","v":"Likely Not Beneficial to Spray"}]
[]
[{"$f":"\"High Range of Yield Loss (\"&I18*100&\"% or \"&$I$22&\" bu/ac) -\"","v":"High Range of Yield Loss (30% or 7.4 bu/ac) -"},null,null,null,null,null,{"$f":"IF($I$42<-5%,$A$71,IF(I42<5%,$A$72,$A$73))","v":"Likely Beneficial to Spray"}]
[]
["Breakeven Analysis  (compared to untreated)"]
[]
["Breakeven Yield Loss     = ",null,null,null,"Total Cost of Treatment "]
[null,null,null,null,"     Price per bushel"]
[]
[null,null,null,{"$f":"\"            = $\"&TEXT($F$33,\"0.00\")&\" cost / $\"&TEXT($F$26,\"0.00\")&\" price = \"&ROUND(($F$33)/$F$26,1)&\" bu/acre or \"&TEXT((($F$33/$F$26)/$G$14/$F$8)*100,\"0.0\")&\"% yield loss\"","v":"            = $29.50 cost / $8.00 price = 3.7 bu/acre or 14.9% yield loss"}]
[]
["Breakeven Yield Loss     = ",null,null,null,"Total Cost of Treatment +",null,0.2,"producer profit margin"]
[" (with producer profit margin)",null,null,null,"     Price per bushel"]
[]
[null,null,null,{"$f":"\"            = $\"&TEXT($F$33*(1+G55),\"0.00\")&\" cost / $\"&TEXT($F$26,\"0.00\")&\" price = \"&ROUND(($F$33*(1+G55))/$F$26,1)&\" bu/acre or \"&TEXT((($F$33*(1+G55)/$F$26)/$G$14/$F$8)*100,\"0.0\")&\"% yield loss\"","v":"            = $35.40 cost / $8.00 price = 4.4 bu/acre or 17.8% yield loss"}]
[]
["Note: This budget is only a guide and is not intended as an in-depth study of cereal lodging 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,null,null,null,null,null,"April, 2025"]
[]
[]
[]
[]
[]
[]
[]
["Likely Not Beneficial to Spray"]
["Uncertain if Beneficial to Spray"]
["Likely Beneficial to Spray"]

{"sheet":"Yield & Risk Factors","index":1,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["Yield and Risk Factors"]
[]
[null,null,null,null,"Relative",null,"Assigned ",null,null,"Risk"]
["Cultivar Lodging Rating",null,null,null,"Rating",null,"Weight",null,null,"Factor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(select rating)"]
[null,null,"Poor ",null,1,"x",0.375,{"$f":"IF('Lodging Decision Tool'!F9=N6,E6,IF('Lodging Decision Tool'!F9=N7,E7,IF('Lodging Decision Tool'!F9=N8,E8,E9)))","v":0},"=",{"$f":"H6*G6","v":0},null,null,null,"P"]
[null,null,"Fair",null,0.7,null,null,null,null,null,null,null,null,"F"]
[null,null,"Good",null,0.3,null,null,null,null,null,null,null,null,"G"]
[null,null,"Very Good",null,0,null,null,null,null,null,null,null,null,"VG"]
[]
["Nitrogen Fertilizer Applied"]
[null,"soil test (lb/ac)",35,null,null,null,null,null,null,null,null,null,null,"(select rate)"]
[null,null,{"$f":"N13","v":"Higher rate: More than 145 lb/acre"},null,1,"x",0.25,{"$f":"IF('Lodging Decision Tool'!F10=N13,E13,IF('Lodging Decision Tool'!F10=N14,E14,E15))","v":0.5},"=",{"$f":"H13*G13","v":0.125},null,null,null,{"$f":"\"Higher rate: More than \"&CEILING((2.25*'Lodging Decision Tool'!F8)-C12,5)&\" lb/acre\"","v":"Higher rate: More than 145 lb/acre"}]
[null,null,{"$f":"N14","v":"Recommeded rate: 125 to 145 lb/acre"},null,0.5,null,null,null,null,null,null,null,null,{"$f":"\"Recommeded rate: \"&CEILING((2.25*'Lodging Decision Tool'!F8)-C12,5)-20&\" to \"&CEILING((2.25*'Lodging Decision Tool'!F8)-C12,5)&\" lb/acre\"","v":"Recommeded rate: 125 to 145 lb/acre"}]
[null,null,{"$f":"N15","v":"Lower rate: Less than 125 lb/acre"},null,0,null,null,null,null,null,null,null,null,{"$f":"\"Lower rate: Less than \"&CEILING((2.25*'Lodging Decision Tool'!F8)-C12,5)-20&\" lb/acre\"","v":"Lower rate: Less than 125 lb/acre"}]
[]
["Target Wheat Yield (bu)"]
[null,"more than or equal to",80,null,1,"x",0.125,{"$f":"ROUND(1-SUM(C18-'Lodging Decision Tool'!F8)/(C18-C19),1)","v":1},"=",{"$f":"H18*G18","v":0.125}]
[null,"less than or equal to",60,null,0]
[]
["Seeding Rate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(select rate)"]
[null,null,{"$f":"N23","v":"High: >30 plants/ft2 (2.0 or higher bu/acre)"},null,1,"x",0.125,{"$f":"IF('Lodging Decision Tool'!F11=N23,E23,IF('Lodging Decision Tool'!F11=N24,E24,E25))","v":0.5},"=",{"$f":"H23*G23","v":6.25E-2},null,null,null,"High: >30 plants/ft2 (2.0 or higher bu/acre)"]
[null,null,{"$f":"N24","v":"Medium: 23-30 plants/ft2 (1.75 to 1.9 bu/acre)"},null,0.5,null,null,null,null,null,null,null,null,"Medium: 23-30 plants/ft2 (1.75 to 1.9 bu/acre)"]
[null,null,"Low: <23 plants/ft2 (1.7 or lower bu/acre)",null,0,null,null,null,null,null,null,null,null,"Low: <23 plants/ft2 (1.7 or lower bu/acre)"]
[]
["Fungicide Application"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(select)"]
[null,null,{"$f":"N29","v":"Yes"},null,0,"x",0.125,{"$f":"IF('Lodging Decision Tool'!F12=N29,E29,E30)","v":0},"=",{"$f":"H29*G29","v":0},null,null,null,"Yes"]
[null,null,{"$f":"N30","v":"No"},null,1,null,null,null,null,null,null,null,null,"No"]
[]
[null,null,null,null,"TOTAL",null,{"$f":"SUM(G6+G13+G18+G23+G29)","v":1},null,null,{"$f":"ROUND((J6+J13+J18+J23+J29),2)","v":0.31}]