{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Producer Info","Cattle info","Wheat info","cost_of_gain","Results","futures","basis","Lists","Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":13,"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":"Producer Info","index":0,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,2,9],[5,2,5,4],[6,2,6,4],[8,1,8,6],[8,7,8,9],[13,12,13,18],[14,1,14,6],[14,7,14,9],[9,1,10,5],[9,6,10,8],[12,1,12,3],[12,5,12,6]]}
[]
[null,"Oklahoma Graze Out Decision Maker\nOklahoma State University\nOklahoma Cooperative Extension Service\nOklahoma Agricultural Experiment Station\nStillwater, Oklahoma\nDeveloped by\nEric A. DeVuyst, Francis Epplin, Derrel Peel, Karen Taylor,\nDept. of Ag. Econ\nGerald Horn, David Lalman, Dept. of Animal Science\n\n"]
[]
[null,null,null,null,null,null,null,"Build date",null,"2020-02-13"]
[]
[null,"NAME","Spring 2019"]
[null,"Date","2020-02-13"]
[]
[null,"The current price data is dated as",null,null,null,null,null,{"$f":"futures!A1","v":"2020-02-07"}]
[null,"Do you want to update price data?"]
[]
[]
[null,"Interest rate",null,null,"%",0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,"Anticipated date of first-hollow-stem",null,null,null,null,null,"2020-03-05"]

{"sheet":"Cattle info","index":1,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,1,13],[3,5,3,6],[4,8,4,11],[4,12,4,13],[2,1,2,4],[2,5,2,6],[3,8,3,11],[3,12,3,13],[2,8,2,11],[3,1,3,4],[2,12,2,13],[4,1,4,4],[4,5,4,6],[7,1,7,4],[7,5,7,6],[17,1,17,3],[16,1,16,3],[14,1,14,4],[15,1,15,4],[8,5,8,6],[8,1,8,4],[13,1,13,8],[12,1,12,8],[10,1,11,8],[14,7,14,8],[15,7,15,8],[17,7,17,8],[5,8,5,11],[6,8,6,11],[5,12,5,13],[5,1,5,4],[5,5,5,6],[6,1,6,4],[6,5,6,6],[6,12,6,13],[32,1,32,5],[33,1,33,5],[34,1,34,5],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[29,7,29,8],[29,1,29,6],[30,1,30,6],[30,7,30,8],[31,1,31,5],[28,1,28,6],[28,7,28,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[18,7,18,8],[16,4,16,8],[18,10,19,13],[20,10,21,13],[27,1,27,12]]}
[]
[null,"Enter cattle data"]
[null,"Cattle gender",null,null,null,"Steers",null,null,"Purchase date",null,null,null,"2019-11-15"]
[null,"Weight at Purchase",null,null,null,450,null,null,"Purchase price ($/cwt)",null,null,null,170]
[null,"Days in receiving program",null,null,null,35,null,null,"Death loss (%)",null,null,null,1.7000000000000001E-2]
[null,"ADG in receiving program",null,null,null,1,null,null,"Fall/winter stocking rate (hd/ac)",null,null,null,0.5]
[null,"ADG grazing wheat",null,null,null,2.25,null,null,"Graze out stocking rate (hd/ac)",null,null,null,1.5]
[null,"Days in graze out",null,null,null,50]
[null,"ADG after first hollow stem",null,null,null,2.8]
[]
[null,"Enter Cattle Futures and Basis\n($/cwt)"]
[]
[null,"Do you want to load default price data?"]
[]
[null,"Month",null,null,null,"Mar","Apr","May"]
[null,"Futures price ($/cwt)",null,null,null,135.19999694824219,137.5,139.57499694824219]
[null,null,null,null,"Basis ($/cwt)"]
[null,"Weight Range",null,null,"Feb","Mar","Apr","May"]
[null,400,null,500,39.793999999999997,44.882000000000005,41.076000000000001,35.678000000000004,null,null,"Data entry continues below ↓."]
[null,500,null,600,25.32,30.78,27.483999999999998,24.802]
[null,600,null,700,8.9640000000000004,13.803999999999998,13.324000000000002,10.687999999999999]
[null,700,null,800,-0.378,1.026,0.92599999999999993,1.0100000000000002]
[null,800,null,900,-9.7200000000000006,-11.751999999999999,-11.472000000000001,-8.6679999999999993]
[null,900,null,1000,-19.062000000000001,-24.529999999999998,-23.870000000000005,-18.345999999999997]
[]
[]
[]
[null,"Enter Production Costs incurred during receiving and grazing"]
[null,"Total lbs of gain",null,null,null,null,null,{"$f":"$F$5*$F$6+$F$7*('Producer Info'!$H$15-'Cattle info'!$M$3+H30)","v":253.25},null,{"$f":"H29+7*F7","v":269},{"$f":"J29+7*F7","v":284.75},{"$f":"K29+7*F9","v":304.35000000000002},{"$f":"L29+7*F9","v":323.95000000000005}]
[null,"Days relative first hollow stem",null,null,null,null,null,-14,null,-7,0,7,14]
[null,"Final grazing date",null,null,null,null,null,{"$f":"'Producer Info'!$H$15+'Cattle info'!H30","v":"2020-02-20"},null,{"$f":"'Producer Info'!$H$15+'Cattle info'!J30","v":"2020-02-27"},{"$f":"'Producer Info'!$H$15+'Cattle info'!K30","v":"2020-03-05"},{"$f":"'Producer Info'!$H$15+'Cattle info'!L30","v":"2020-03-12"},{"$f":"'Producer Info'!$H$15+'Cattle info'!M30","v":"2020-03-19"}]
[null,"Veterinary expense",null,null,null,null,"$/hd",6,null,6,6,6.5,6.5]
[null,"Marketing expense",null,null,null,null,"$/hd",8,null,8,8,8,8]
[null,"Cost of gain excluding wheat expense",null,null,null,null,"$/lb",0.1032,null,9.7699999999999995E-2,9.2700000000000005E-2,8.7300000000000003E-2,8.2600000000000007E-2]
[null,"Other expenses",null,null,null,null,"$/hd",1,null,1,1,1,1]

{"sheet":"Wheat info","index":2,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,3,6],[6,1,6,4],[7,1,7,4],[11,1,11,4],[4,1,4,4],[5,1,5,4],[9,1,9,5],[10,1,10,5],[8,1,8,9],[4,7,4,9],[5,7,5,9],[6,7,6,9],[7,7,7,8],[13,1,13,4],[18,1,19,9],[20,1,21,9],[12,1,12,4],[15,1,17,8]]}
[]
[null,"Enter wheat production information"]
[]
[]
[null,"Expected wheat price",null,null,null,"$/bu",4.5,"Select owned or rented"]
[null,"Wheat harvest cost",null,null,null,"$/ac",{"$f":"25+20*0.25+0.23*40","v":39.200000000000003},"Rented $/lb of gain"]
[null,"Percent of acres grazed out",null,null,null,"%",{"$f":"'Cattle info'!M6/'Cattle info'!M7","v":0.33333333333333331},"Rental rate"]
[null,"Expected wheat yield",null,null,null,"bu/ac",40,"$/lb of gain",null,0.5]
[null,"Yield loss from grazing past first hollow stem"]
[null,"Days relative to first hollow stem",null,null,null,null,0,7,14,21]
[null,"Date when grazing terminates",null,null,null,null,{"$f":"'Cattle info'!K31","v":"2020-03-05"},{"$f":"'Cattle info'!L31","v":"2020-03-12"},{"$f":"'Cattle info'!M31","v":"2020-03-19"},{"$f":"I11+7","v":"2020-03-26"}]
[null,"Yield loss from extended grazing",null,null,null,"bu/ac",0,8,10,12]
[null,"Yield loss from extended grazing--worst case*",null,null,null,"bu/ac",0,{"$f":"G8*0.33","v":13.200000000000001},{"$f":"G8*0.58","v":23.2},{"$f":"G8*0.76","v":30.4}]
[null,"Yield loss from extended grazing--best case",null,null,null,"bu/ac",0,{"$f":"G8*0.06","v":2.4},{"$f":"G8*0.14","v":5.6000000000000005},{"$f":"G8*0.23","v":9.2000000000000011}]
[]
[null,"*OSU research shows that yield loss from extended grazing is sensitive to variety, stocking rate, weather and leaf area. So, estimates of damage vary with these condiions. A range of values is provided based on published results. For more information, see these references:"]
[]
[]
[null,"Fieser, B.G., G.W. Horn, J.T. Edwards, and E.G. Krenzer, Jr. “Time of grazing termination in Dual-Purpose Winter Wheat Enterprises,” The Professional Animal Scientist 22 (2006):210-216."]
[]
[null,"Redmon, L.A., E.G. Krenzer, Jr., D.J. Bernardo, and G.W. Horn. “Effect of wheat morphological stage at grazing termination on economic return,” Agronomy Journal 88 (1996):94-97."]

{"sheet":"cost_of_gain","index":3,"n_rows":26,"n_cols":12,"rows_kept":26,"cut":false,"hidden":true,"merged":[[9,1,9,4],[10,1,10,4],[13,1,13,2],[13,5,13,6],[14,1,14,2],[14,5,14,6],[10,5,10,6],[20,1,20,6],[22,1,22,6],[21,1,21,6],[28,3,29,5],[24,1,24,6],[25,1,25,6],[23,1,23,6],[1,1,1,11],[4,1,4,4],[5,5,5,6],[5,1,5,2],[12,1,12,4],[12,5,12,6],[4,5,4,6],[2,1,2,6],[11,1,11,6],[6,1,6,2],[6,5,6,6],[7,1,7,2],[7,5,7,6],[8,1,8,4],[8,5,8,6],[9,5,9,6],[19,1,19,6],[17,1,17,6],[18,1,18,6],[15,1,15,2],[15,5,15,6],[16,1,16,4],[16,5,16,6]]}
[]
[null,{"$f":"\"Cost of Gain Analysis for \" & 'Cattle info'!F3","v":"Cost of Gain Analysis for Steers"}]
[null,"  Receiving Weight (lb)",null,null,null,null,null,{"$f":"'Cattle info'!F4","v":450},{"$f":"H3","v":450},{"$f":"I3","v":450},450,450]
[null,"End Weight",null,null,null,null,null,{"$f":"H3+'Cattle info'!F5*'Cattle info'!F6+'Cattle info'!F7*(-'Cattle info'!M3+'Cattle info'!H31)","v":703.25},{"$f":"H4+7*'Cattle info'!F7","v":719},{"$f":"I4+7*'Cattle info'!F7","v":734.75},{"$f":"J4+7*'Cattle info'!F9","v":754.35},{"$f":"K4+'Cattle info'!F9*7","v":773.95}]
[null,"Receiving Program Expenses",null,null,null,"days in receiving ",null,{"$f":"'Cattle info'!$F$5","v":35},{"$f":"'Cattle info'!$F$5","v":35},{"$f":"'Cattle info'!$F$5","v":35},{"$f":"'Cattle info'!$F$5","v":35},{"$f":"'Cattle info'!$F$5","v":35}]
[null,"Hay",null,"$/ton",80,"lb/day/hd",null,10,10,10,10,10]
[null,"Supplement",null,"$/ton",400,"lb/day/hd",null,2,2,2,2,2]
[null,"Mineral",null,"$/ton",300,"ounces/day/hd",null,4,4,4,4,4]
[null,"Feed cost during receiving",null,null,null,"$/hd",null,{"$f":"$E$6*H6*H5/2000+$E$7/2000*H7*H5+$E$8/2000/128*H5*H8","v":28.1640625},{"$f":"$E$6*I6*I5/2000+$E$7/2000*I7*I5+$E$8/2000/128*I5*I8","v":28.1640625},28.1640625,28.1640625,28.1640625]
[null,"Transport to pasture",null,null,null,"$/hd",null,2.5,2.5,2.5,2.5,2.5]
[null,"Other receiving costs",null,null,null,"$/hd"]
[null,"Total receiving program expenses",null,null,null,null,null,{"$f":"SUM(H9:H11)","v":30.6640625},{"$f":"SUM(I9:I11)","v":30.6640625},30.6640625,30.6640625,30.6640625]
[null,"Grazing Expenses",null,null,null,"days grazing",null,{"$f":"'Producer Info'!$H$15-'Cattle info'!$M$3+'Cattle info'!H30","v":97},{"$f":"'Producer Info'!$H$15-'Cattle info'!$M$3+'Cattle info'!J30","v":104},{"$f":"'Producer Info'!$H$15-'Cattle info'!$M$3+'Cattle info'!K30","v":111},{"$f":"'Producer Info'!$H$15-'Cattle info'!$M$3+'Cattle info'!L30","v":118},{"$f":"'Producer Info'!$H$15-'Cattle info'!$M$3+'Cattle info'!M30","v":125}]
[null,"Hay",null,"$/ton",80,"lb/day/hd",null,2,2,2,2,2]
[null,"Supplement",null,"$/ton",400,"lb/day/hd",null,0,0,0,0,0]
[null,"Mineral",null,"$/ton",300,"ounces/day/hd",null,4,4,4,4,4]
[null,"Feed cost during receiving",null,null,null,"$/hd",null,{"$f":"$E$14*H14*H13/2000+$E$15/2000*H15*H13+$E$16/2000/128*H13*H16","v":8.2146875000000001},{"$f":"$E$14*I14*I13/2000+$E$15/2000*I15*I13+$E$16/2000/128*I13*I16","v":8.807500000000001},9.4003125000000001,9.9931249999999991,{"$f":"$E$14*L14*L13/2000+$E$15/2000*L15*L13+$E$16/2000/128*L13*L16","v":10.5859375}]
[null,"Freight ($/head)",null,null,null,null,null,2,2,2,2,2]
[null,"Labor ($/head/day)",null,null,null,null,null,0.1,0.1,0.1,0.1,0.1]
[null,"Equipment and machinery ($/head)",null,null,null,null,null,3,3,3,3,3]
[null,"Management fee ($/head)",null,null,null,null,null,0,0,0,0,0]
[null,"Other ($/head)",null,null,null,null,null,0,0,0,0,0]
[null,"Total Grazing Expenses",null,null,null,null,null,{"$f":"SUM(H18:H22)","v":5.0999999999999996},{"$f":"SUM(I18:I22)","v":5.0999999999999996},5.0999999999999996,5.0999999999999996,5.0999999999999996]
[null,"Total Expenses",null,null,null,null,null,{"$f":"H12+H23","v":35.764062500000001},{"$f":"I12+I23","v":35.764062500000001},35.764062500000001,35.764062500000001,35.764062500000001]
[null,"Gain (lb/head)",null,null,null,null,null,{"$f":"H4-H3","v":253.25},{"$f":"I4-I3","v":269},284.75,304.35000000000002,323.95000000000005]
[null,"Cost of gain ($/lb)",null,null,null,null,null,{"$f":"H24/H25","v":0.14122038499506417},{"$f":"I24/I25","v":0.13295190520446099},0.12559811237928006,0.11750965171677345,0.11039994597931778]

{"sheet":"Results","index":4,"n_rows":59,"n_cols":8,"rows_kept":59,"cut":false,"hidden":false,"merged":[[13,1,13,2],[14,1,14,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[7,1,7,2],[6,1,6,2],[2,1,2,7],[4,1,4,2],[3,1,3,2],[5,1,5,2],[15,1,15,2],[19,1,19,7],[16,1,16,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[29,3,29,7],[30,3,30,7],[36,1,36,2],[38,1,38,2],[40,1,40,2],[43,1,43,2],[46,1,46,2],[39,1,39,2],[41,1,41,2],[42,1,42,2],[44,1,44,2],[45,1,45,2],[33,1,33,5],[55,1,55,2],[53,1,53,2],[54,1,54,2],[53,3,53,5],[54,3,54,5],[55,3,55,5],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[34,1,34,2],[35,1,35,2],[37,1,37,2],[47,1,47,2]]}
[]
[]
[null,"Projected cattle returns"]
[null,"Days relative to first hollow stem",null,-14,-7,0,7,14]
[null,"Date",null,{"$f":"'Producer Info'!$H$15+Results!D4","v":"2020-02-20"},{"$f":"'Producer Info'!$H$15+Results!E4","v":"2020-02-27"},{"$f":"'Producer Info'!$H$15+Results!F4","v":"2020-03-05"},{"$f":"'Producer Info'!$H$15+Results!G4","v":"2020-03-12"},{"$f":"'Producer Info'!$H$15+Results!H4","v":"2020-03-19"}]
[null,"Sale weight (lbs)",null,{"$f":"'Cattle info'!F4+'Cattle info'!H29","v":703.25},{"$f":"'Cattle info'!$F$4+'Cattle info'!J29","v":719},{"$f":"'Cattle info'!$F$4+'Cattle info'!K29","v":734.75},{"$f":"'Cattle info'!$F$4+'Cattle info'!L29","v":754.35},{"$f":"'Cattle info'!$F$4+'Cattle info'!M29","v":773.95}]
[null,"Sales price",null,140.37405301967075,142.88576551967077,145.66806301967077,135.58054743652343,133.16566438842773]
[null,"Sales revenue",null,{"$f":"D6*D7/100","v":987.18052786083456},{"$f":"E6*E7/100","v":1027.3486540864328},1070.2960930370309,1022.7518595874145,1030.6356595342365]
[null,"Expenses per head sold"]
[null,"purchase",null,{"$f":"('Cattle info'!$F$4*'Cattle info'!$M$4/100/(1-'Cattle info'!$M$5))","v":778.22990844354024},{"$f":"'Cattle info'!$F$4*'Cattle info'!$M$4/100/(1-'Cattle info'!$M$5)","v":778.22990844354024},{"$f":"'Cattle info'!$F$4*'Cattle info'!$M$4/100/(1-'Cattle info'!$M$5)","v":778.22990844354024},{"$f":"'Cattle info'!$F$4*'Cattle info'!$M$4/100/(1-'Cattle info'!$M$5)","v":778.22990844354024},{"$f":"'Cattle info'!$F$4*'Cattle info'!$M$4/100/(1-'Cattle info'!$M$5)","v":778.22990844354024}]
[null,"vet, marketing and other",null,{"$f":"('Cattle info'!H32+'Cattle info'!H33+'Cattle info'!H35)/(1-'Cattle info'!$M$5)","v":15.25940996948118},{"$f":"'Cattle info'!J32+'Cattle info'!J33+'Cattle info'!J35","v":15},{"$f":"'Cattle info'!K32+'Cattle info'!K33+'Cattle info'!K35","v":15},{"$f":"'Cattle info'!L32+'Cattle info'!L33+'Cattle info'!L35","v":15.5},{"$f":"'Cattle info'!M32+'Cattle info'!M33+'Cattle info'!M35","v":15.5}]
[null,"cost of gain",null,{"$f":"'Cattle info'!H29*'Cattle info'!H34+Lists!C32","v":135.2604},{"$f":"('Cattle info'!J29*'Cattle info'!J34)/(1-'Cattle info'!$M$5)+Lists!D32","v":143.73580874872837},{"$f":"('Cattle info'!K29*'Cattle info'!K34)/(1-'Cattle info'!$M$5)+Lists!E32","v":151.72782299084434},{"$f":"('Cattle info'!L29*'Cattle info'!L34)/(1-'Cattle info'!$M$5)+Lists!F32","v":161.7042522889115},{"$f":"('Cattle info'!M29*'Cattle info'!M34)/(1-'Cattle info'!$M$5)+Lists!G32","v":171.69602746693798}]
[null,"interest",null,{"$f":"D10*'Producer Info'!$F$13/365*(-'Cattle info'!$M$3+Results!D5)+(Results!D11+D12)*'Producer Info'!$F$13/365/2*(-'Cattle info'!$M$3+Results!D5)","v":9.0727136331554235},{"$f":"E10*'Producer Info'!$F$13/365*(-'Cattle info'!$M$3+Results!E5)+(Results!E11+E12)*'Producer Info'!$F$13/365/2*(-'Cattle info'!$M$3+Results!E5)","v":9.7742654830752951},{"$f":"F10*'Producer Info'!$F$13/365*(-'Cattle info'!$M$3+Results!F5)+(Results!F11+F12)*'Producer Info'!$F$13/365/2*(-'Cattle info'!$M$3+Results!F5)","v":10.480757700079433},{"$f":"G10*'Producer Info'!$F$13/365*(-'Cattle info'!$M$3+Results!G5)+(Results!G11+G12)*'Producer Info'!$F$13/365/2*(-'Cattle info'!$M$3+Results!G5)","v":11.209444392480387},{"$f":"H10*'Producer Info'!$F$13/365*(-'Cattle info'!$M$3+Results!H5)+(Results!H11+H12)*'Producer Info'!$F$13/365/2*(-'Cattle info'!$M$3+Results!H5)","v":11.942848249000125}]
[null,"Total Expenses",null,{"$f":"SUM(D10:D13)","v":937.82243204617691},{"$f":"SUM(E10:E13)","v":946.73998267534387},955.43848913446402,966.64360512493215,977.36878415947831]
[null,"Returns to wheat pasture $/hd",null,{"$f":"D8-D14","v":49.358095814657645},{"$f":"E8-E14","v":80.608671411088949},114.85760390256689,56.108254462482364,53.266875374758229]
[null,"Returns to wheat pasture $/ac",null,{"$f":"D15*'Cattle info'!$M$6","v":24.679047907328822},{"$f":"E15*'Cattle info'!$M$6","v":40.304335705544474},{"$f":"F15*'Cattle info'!$M$6","v":57.428801951283447},{"$f":"G15*'Cattle info'!$M$6","v":28.054127231241182},{"$f":"H15*'Cattle info'!$M$6","v":26.633437687379114}]
[null,"Breakeven stocker price $/cwt",null,{"$f":"D14/D6*100","v":133.35548269408844},{"$f":"E14/E6*100","v":131.67454557376132},130.0358610594711,128.1425870119881,126.28319454221568]
[]
[]
[null,"Projected cattle and wheat returns"]
[null,"Days relative to first hollow stem",null,-14,-7,0,7,14]
[null,"Date",null,{"$f":"'Producer Info'!$H$15+Results!D21","v":"2020-02-20"},{"$f":"'Producer Info'!$H$15+Results!E21","v":"2020-02-27"},{"$f":"'Producer Info'!$H$15+Results!F21","v":"2020-03-05"},{"$f":"'Producer Info'!$H$15+Results!G21","v":"2020-03-12"},{"$f":"'Producer Info'!$H$15+Results!H21","v":"2020-03-19"}]
[null,"Returns from stockers $/hd",null,{"$f":"D15","v":49.358095814657645},{"$f":"E15","v":80.608671411088949},114.85760390256689,56.108254462482364,53.266875374758229]
[null,"Wheat yield bu/ac",null,{"$f":"'Wheat info'!$G$8","v":40},{"$f":"'Wheat info'!$G$8","v":40},{"$f":"'Wheat info'!$G$8","v":40},{"$f":"$F$24-'Wheat info'!H12","v":32},{"$f":"IF($F$24-'Wheat info'!I12>0,$F$24-'Wheat info'!I12,0)","v":30}]
[null,"Wheat price",null,{"$f":"'Wheat info'!$G$5","v":4.5},{"$f":"'Wheat info'!$G$5","v":4.5},{"$f":"'Wheat info'!$G$5","v":4.5},{"$f":"'Wheat info'!$G$5","v":4.5},{"$f":"'Wheat info'!$G$5","v":4.5}]
[null,"Wheat revenue + rent*  $/ac",null,{"$f":"D24*D25+Lists!C32","v":289.125},{"$f":"E24*E25+Lists!D32","v":297},{"$f":"F24*F25+Lists!E32","v":304.875},{"$f":"G24*G25+Lists!F32","v":278.67500000000001},{"$f":"H24*H25+Lists!G32","v":279.47500000000002}]
[null,"Harvest expense  $/ac",null,{"$f":"'Wheat info'!$G$6","v":39.200000000000003},{"$f":"'Wheat info'!$G$6","v":39.200000000000003},{"$f":"IF(F26>0,'Wheat info'!$G$6,0)","v":39.200000000000003},{"$f":"IF(G26>0,'Wheat info'!$G$6,0)","v":39.200000000000003},{"$f":"IF(H26>0,'Wheat info'!$G$6,0)","v":39.200000000000003}]
[null,"Wheat returns  $/ac",null,{"$f":"D26-D27","v":249.92500000000001},{"$f":"E26-E27","v":257.8},265.67500000000001,239.47500000000002,240.27500000000003]
[null,"Returns to stockers & wheat  $/ac",null,{"$f":"D23*'Cattle info'!$M$6+D28","v":274.60404790732883},{"$f":"E23*'Cattle info'!$M$6+E28","v":298.10433570554449},{"$f":"F23*'Cattle info'!$M$6+F28","v":323.10380195128346},{"$f":"G23*'Cattle info'!$M$6+G28","v":267.5291272312412},{"$f":"H23*'Cattle info'!$M$6+H28","v":266.90843768737915}]
[null,"Maximum return $/ac",null,{"$f":"MAX(D29:H29)","v":323.10380195128346}]
[null,"Optimal selling date",null,"2020-03-05"]
[]
[]
[null,"Projected returns from graze out"]
[null,"Days relative to first hollow stem",null,0,7,14]
[null,"Graze out start date",null,{"$f":"'Producer Info'!$H$15+Results!D35","v":"2020-03-05"},{"$f":"'Producer Info'!$H$15+Results!E35","v":"2020-03-12"},{"$f":"'Producer Info'!$H$15+Results!F35","v":"2020-03-19"}]
[null,"Sale date",null,{"$f":"D36+'Cattle info'!$F$8","v":"2020-04-24"},{"$f":"E36+'Cattle info'!$F$8","v":"2020-05-01"},{"$f":"F36+'Cattle info'!$F$8","v":"2020-05-08"}]
[null,"Sales weight",null,{"$f":"F6+'Cattle info'!F8*'Cattle info'!F9","v":874.75},{"$f":"G6+'Cattle info'!$F$8*'Cattle info'!$F$9","v":894.35},{"$f":"H6+'Cattle info'!$F$8*'Cattle info'!$F$9","v":913.95}]
[null,"Sales price",null,122.959495,126.61480631103515,115.03991476684571]
[null,"Stocker revenue",null,{"$f":"D39*D38/100","v":1075.5881825125},1132.379520242743,1051.4073010115865]
[null,"Expenses per head sold"]
[null,"purchase",null,{"$f":"F10","v":778.22990844354024},778.22990844354024,778.22990844354024]
[null,"vet, marketing and other",null,15,15.5,15.5]
[null,"cost of gain",null,{"$f":"(D38-'Cattle info'!$F$4)*'Cattle info'!K34+Lists!E33","v":234.249325},{"$f":"(E38-'Cattle info'!$F$4)*'Cattle info'!L34+Lists!F33","v":243.46675500000001},{"$f":"(F38-'Cattle info'!$F$4)*'Cattle info'!M34+Lists!G33","v":252.79727000000003}]
[null,"interest",null,{"$f":"(D44+D43)*'Producer Info'!$F$13/365/2+D42*'Producer Info'!$F$13/365*(Results!D37-'Cattle info'!$M$3)","v":13.744618073633971},{"$f":"(E44+E43)*'Producer Info'!$F$13/365/2+E42*'Producer Info'!$F$13/365*(Results!E37-'Cattle info'!$M$3)","v":14.34214882148107},{"$f":"(F44+F43)*'Producer Info'!$F$13/365/2+F42*'Producer Info'!$F$13/365*(Results!F37-'Cattle info'!$M$3)","v":14.939658368506251}]
[null,"Total expenses per head sold",null,{"$f":"SUM(D42:D45)","v":1041.2238515171741},1051.5388122650213,1061.4668368120467]
[null,"Stocker return $/hd",null,{"$f":"D40-D46","v":34.364330995325872},80.84070797772165,-10.059535800460253]
[null,"Wheat yield bu/ac",null,{"$f":"'Wheat info'!$G$8*(1-'Wheat info'!$G$7)","v":26.666666666666671},{"$f":"IF(('Wheat info'!$G$8-'Wheat info'!$G$12)*(1-'Wheat info'!$G$7)-'Wheat info'!H12>0,('Wheat info'!$G$8-'Wheat info'!$G$12)*(1-'Wheat info'!$G$7)-'Wheat info'!H12,0)","v":18.666666666666671},{"$f":"IF(('Wheat info'!$G$8-'Wheat info'!$G$12)*(1-'Wheat info'!$G$7)-'Wheat info'!I12>0,('Wheat info'!$G$8-'Wheat info'!$G$12)*(1-'Wheat info'!$G$7)-'Wheat info'!I12,0)","v":16.666666666666671}]
[null,"Wheat price $/bu",null,{"$f":"'Wheat info'!$G$5","v":4.5},{"$f":"'Wheat info'!$G$5","v":4.5},{"$f":"'Wheat info'!$G$5","v":4.5}]
[null,"Wheat revenue  $/ac",null,{"$f":"D48*D49","v":120.00000000000003},{"$f":"E48*E49","v":84.000000000000028},{"$f":"F48*F49","v":75.000000000000028}]
[null,"Harvest expense  $/ac",null,{"$f":"IF(D48>0,'Wheat info'!$G$6*(1-'Wheat info'!$G$7),0)","v":26.133333333333336},{"$f":"IF(E48>0,'Wheat info'!$G$6*(1-'Wheat info'!$G$7),0)","v":26.133333333333336},{"$f":"IF(F48>0,'Wheat info'!$G$6*(1-'Wheat info'!$G$7),0)","v":26.133333333333336}]
[null,"Wheat returns  $/ac",null,{"$f":"D50-D51","v":93.866666666666688},{"$f":"E50-E51","v":57.866666666666688},{"$f":"F50-F51","v":48.866666666666688}]
[null,"Returns to stockers & wheat  $/ac",null,{"$f":"D47*'Cattle info'!$M$6+D52","v":111.04883216432962},{"$f":"E47*'Cattle info'!$M$6+E52","v":98.287020655527513},{"$f":"F47*'Cattle info'!$M$6+F52","v":43.836898766436562}]
[null,"Maximum return $/ac",null,{"$f":"MAX(D53:F53)","v":111.04883216432962}]
[null,"Optimal selling date",null,"2020-04-24"]
[null,"Optimal graze out start date",null,"2020-03-05"]
[]
[]
[null,"*Wheat rent includes opportunity cost if both cattle and wheat are owned. "]

{"sheet":"futures","index":5,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["2020-02-07",null,null,"Feeder Cattle Futures"]
[null,null,"DAILY"]
[null,null,"JAN","MAR","APR","MAY","AUG","SEP","OCT","NOV","Nearby"]
[null,null,1,3,4,5,8,9,10,11]
["2020-02-07",null,147.30000305175781,135.19999694824219,137.5,139.57499694824219,147.875,149.47500610351562,150.35000610351562,150.85000610351562,150.35000610351562]
[]
[]
[]
[]
[null,null,null,"Live Cattle Futures",null,null,null,null,null,null,null,null,null,null,"Nearby"]
[null,null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","(even "]
[null,null,1,2,3,4,5,6,7,8,9,10,11,12,"mnth only)"]
["2020-02-07","",121.32499694824219,"",119.80000305175781,"",111.27500152587891,"",109.875,"",113.09999847412109,"",117.59999847412109,121.32499694824219,121.32499694824219]

{"sheet":"basis","index":6,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Steer basis"]
["2009-2013","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","steers"]
[499,38.463999999999999,39.793999999999997,44.882000000000005,41.076000000000001,35.678000000000004,34.025999999999996,24.54,35.036000000000001,31.077999999999996,33.765999999999998,44.489999999999995,51.088000000000001]
[599,22.052,25.32,30.78,27.483999999999998,24.802,19.242000000000001,17.084,19.963999999999999,12.878,16.164000000000001,24.032000000000004,25.57]
[699,6.734,8.9640000000000004,13.803999999999998,13.324000000000002,10.687999999999999,6.2960000000000012,7.0220000000000002,8.6,7.9819999999999993,6.0679999999999996,7.5,10.812000000000001]
[799,-6.5999999999999975E-2,-0.378,1.026,0.92599999999999993,1.0100000000000002,-1.6,0.40399999999999991,1.8359999999999999,1.4780000000000002,1.1519999999999999,0.94800000000000006,0.9760000000000002]
[]
["2010-2014","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","heifers"]
[499,10.141999999999999,16.344000000000001,20.602,17.646000000000001,15.877999999999997,8.8439999999999994,8.604000000000001,12.836000000000002,9.6419999999999995,9.3040000000000003,16.690000000000001,19.158000000000001]
[599,1.19,5.7620000000000005,10.17,8.2680000000000007,6.7159999999999993,2.024,0.50200000000000033,4.016,0.33200000000000002,-1.8820000000000001,3.6559999999999997,4.9600000000000009]
[699,-5.3959999999999999,-4.508,-2.06,-2.3800000000000003,-2.8919999999999999,-5.2160000000000002,-3.9659999999999997,-5.2160000000000002,-3.46,-4.9139999999999997,-5.4660000000000002,-3.1459999999999999]
[799,-10.040000000000001,-10.712,-11.182,-11.182,-10.401999999999999,-12.745999999999999,-10.995999999999999,-9.7880000000000003,-10.99,-10.994,-10.809999999999999,-10.011999999999999]

{"sheet":"Lists","index":7,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":true,"merged":[[29,0,29,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1]]}
[]
[]
[null,"days to FHS",null,{"$f":"-'Producer Info'!C7+'Producer Info'!H15","v":21}]
[null,"days on farm",null,{"$f":"MAX(-'Cattle info'!M3+'Producer Info'!C7,0)","v":90}]
[null,"day grazed",null,{"$f":"MAX(D4-'Cattle info'!F5,0)","v":55}]
[]
[1,"Jan"]
[3,"Mar"]
[4,"Apr"]
[5,"May"]
[8,"Aug"]
[9,"Sept"]
[10,"Oct"]
[11,"Nov"]
[]
["download price data"]
[]
["days grazing",null,{"$f":"'Producer Info'!H15-'Cattle info'!M3-'Cattle info'!F5","v":76}]
["grazing rent",null,-14,-7,0,7,14]
["pre-graze out adg",null,0,0,0,35,70]
["POST FHS ADG",null,{"$f":"'Cattle info'!F9","v":2.8},{"$f":"C21","v":2.8},{"$f":"D21","v":2.8},2.8,2.8]
["Stock rate pre",null,1,{"$f":"C22","v":1},1,1,1]
["Stocking rate grazeout",null,1,{"$f":"C23","v":1},1,1,1]
["per ac gains pre",null,{"$f":"C20*C22","v":0},{"$f":"D20*D22","v":0},0,{"$f":"F21*F22","v":2.8},{"$f":"G21*G22","v":2.8}]
["per ac gains graze",null,null,null,{"$f":"E24","v":0},{"$f":"F21*F23","v":2.8},{"$f":"G21*G23","v":2.8}]
["owned opp cost",null,0,0,0,{"$f":"'Wheat info'!J8*7","v":3.5},{"$f":"F26*2","v":7}]
["rent $/cwt/month",null,{"$f":"($C$18+C19)*'Cattle info'!$F$4/100*'Wheat info'!$J$8*'Cattle info'!$M$6/30.5","v":2.2868852459016393},{"$f":"($C$18+D19)*'Cattle info'!$F$4/100*'Wheat info'!$J$8*'Cattle info'!$M$6/30.5","v":2.5450819672131146},{"$f":"($C$18+E19)*'Cattle info'!$F$4/100*'Wheat info'!$J$8*'Cattle info'!$M$6/30.5","v":2.8032786885245899},{"$f":"($C$18+F19)*'Cattle info'!$F$4/100*'Wheat info'!$J$8*'Cattle info'!$M$6/30.5","v":3.0614754098360657},{"$f":"($C$18+G19)*'Cattle info'!$F$4/100*'Wheat info'!$J$8*'Cattle info'!$M$6/30.5","v":3.319672131147541},"pre"]
["rent $/lb of gain",null,{"$f":"(Results!D6-'Cattle info'!$F$4-'Cattle info'!$F$5*'Cattle info'!$F$6)*'Wheat info'!$J$8","v":109.125},{"$f":"(Results!E6-'Cattle info'!$F$4-'Cattle info'!$F$5*'Cattle info'!$F$6)*'Wheat info'!$J$8","v":117},{"$f":"(Results!F6-'Cattle info'!$F$4-'Cattle info'!$F$5*'Cattle info'!$F$6)*'Wheat info'!$J$8","v":124.875},{"$f":"(Results!G6-'Cattle info'!$F$4-'Cattle info'!$F$5*'Cattle info'!$F$6)*'Wheat info'!$J$8","v":134.67500000000001},{"$f":"(Results!H6-'Cattle info'!$F$4-'Cattle info'!$F$5*'Cattle info'!$F$6)*'Wheat info'!$J$8","v":144.47500000000002},"pre"]
["rent $/cwt/month",null,null,null,{"$f":"E27","v":2.8032786885245899},{"$f":"F27","v":3.0614754098360657},{"$f":"G27","v":3.319672131147541},"graze out"]
["rent $/lb of gain",null,null,null,{"$f":"(Results!D38-'Cattle info'!$F$4-'Cattle info'!$F$5*'Cattle info'!$F$6)*'Wheat info'!$J$8","v":194.875},{"$f":"(Results!E38-'Cattle info'!$F$4-'Cattle info'!$F$5*'Cattle info'!$F$6)*'Wheat info'!$J$8","v":204.67500000000001},{"$f":"(Results!F38-'Cattle info'!$F$4-'Cattle info'!$F$5*'Cattle info'!$F$6)*'Wheat info'!$J$8","v":214.47500000000002},"graze out"]
[]
["RENT PRE",null,{"$f":"IF('Wheat info'!$H$6=\"Owned\", Lists!C$26,IF('Wheat info'!$H$6=\"Rented $/cwt/month\",Lists!C27,Lists!C28))","v":109.125},{"$f":"IF('Wheat info'!$H$6=\"Owned\", Lists!D$26,IF('Wheat info'!$H$6=\"Rented $/cwt/month\",Lists!D27,Lists!D28))","v":117},{"$f":"IF('Wheat info'!$H$6=\"Owned\", Lists!E$26,IF('Wheat info'!$H$6=\"Rented $/cwt/month\",Lists!E27,Lists!E28))","v":124.875},{"$f":"IF('Wheat info'!$H$6=\"Owned\", Lists!F$26,IF('Wheat info'!$H$6=\"Rented $/cwt/month\",Lists!F27,Lists!F28))","v":134.67500000000001},{"$f":"IF('Wheat info'!$H$6=\"Owned\", Lists!G$26,IF('Wheat info'!$H$6=\"Rented $/cwt/month\",Lists!G27,Lists!G28))","v":144.47500000000002}]
["RENT GRAZEOUT",null,null,null,{"$f":"IF('Wheat info'!$H$6=\"Owned\", Lists!E$26,IF('Wheat info'!$H$6=\"Rented $/cwt/month\",Lists!E29,Lists!E30))","v":194.875},{"$f":"IF('Wheat info'!$H$6=\"Owned\", Lists!F$26,IF('Wheat info'!$H$6=\"Rented $/cwt/month\",Lists!F29,Lists!F30))","v":204.67500000000001},{"$f":"IF('Wheat info'!$H$6=\"Owned\", Lists!G$26,IF('Wheat info'!$H$6=\"Rented $/cwt/month\",Lists!G29,Lists!G30))","v":214.47500000000002}]

{"sheet":"Sheet1","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet2","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}