{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Scenario","Wean","Preconditioning","Grass1","Feedlot","Drylot-Backgrounding","Grass2","Wheat","Results","data","More info"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Scenario","index":0,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,6,10,8],[18,1,18,6],[18,7,18,11],[19,1,19,6],[12,1,12,3],[12,5,12,6],[16,1,16,6],[16,7,16,11],[17,1,17,6],[17,7,17,11],[37,6,38,6],[28,1,31,11],[1,13,3,19],[19,7,19,11],[20,1,20,6],[1,2,2,10],[5,2,5,4],[5,6,5,11],[6,2,6,4],[6,6,6,11],[20,7,20,11],[15,1,15,11],[22,1,26,11],[8,1,8,6],[8,7,8,9],[9,1,10,5]]}
[]
[null,null,"Oklahoma Beef Calf Retention Decision Aid 2.0\nOklahoma State University\nOklahoma Cooperative Extension Service\nOklahoma Agricultural Experiment Station\nStillwater, Oklahoma\nDeveloped by\nEric A. DeVuyst, Kellie Curry Raper, Damona Doye\nDepartment of Agricultural Economics\nDavid Lalman, Department of Animal Science"]
[]
[null,null,null,null,null,null,null,"Build date",null,"2010-01-22"]
[]
[null,"NAME","DEMO",null,null,null,"A user's manual for this program can be downloaded from:"]
[null,"Date","2009-08-01",null,null,null,"User's manual download"]
[]
[null,"The current price data is dated as",null,null,null,null,null,{"$f":"data!A20","v":"2010-01-13"}]
[null,"Do you want to update price data?"]
[]
[]
[null,"Interest rate",null,null,"%",6.5000000000000002E-2]
[]
[]
[null,"Choose retention options"]
[null,"After Weaning, calves are retained in:",null,null,null,null,null,"Preconditioning"]
[null,{"$f":"IF(H17=\"None\",\"\",IF(H17=\"Feedlot\",\"\", \"After \" & H17 & \", calves are retained in:\"))","v":"After Preconditioning, calves are retained in:"},null,null,null,null,null,"Grass pasture"]
[null,{"$f":"IF(H18=\"None\",\"\",IF(H18=\"Feedlot\",\"\", \"After \" & H18 & \", calves are retained in:\"))","v":"After Grass pasture, calves are retained in:"},null,null,null,null,null,"Feedlot"]
[null,"",null,null,null,null,null,"None"]
[null,"",null,null,null,null,null,"None"]
[]
[null,"This program was developed in MS Excel 2007. If previous versions of Excel are used, calculation errors and loss of functionality will occur. Its use in MS Excel 2003 and previous versions is not recommended."]
[]
[]
[]
[]
[]
[null,"If you received a copy of this program secondhand, it is recommended that you download a new copy from www.okstate.edu/agecon to be sure that you have the most recent updates."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"→"]

{"sheet":"Wean","index":1,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[[27,1,27,6],[28,1,28,6],[29,1,29,6],[8,1,8,6],[12,1,12,8],[18,1,18,6],[15,1,15,6],[26,1,26,6],[25,1,25,6],[17,1,17,6],[9,1,9,6],[10,1,10,6],[19,1,19,6],[16,1,16,6],[37,7,38,7],[4,1,4,3],[4,4,4,5],[6,1,6,8],[1,1,1,5],[2,1,2,3],[2,4,2,5],[3,1,3,3],[3,4,3,5],[21,1,21,6],[20,1,20,6],[24,1,24,8],[22,1,22,6],[7,1,7,6],[13,1,13,6],[14,1,14,6]]}
[]
[null,"Calf weaning information"]
[null,"Calf gender",null,null,"Steers"]
[null,"Weaning date",null,null,"2009-10-16"]
[null,"Weight at weaning",null,null,450]
[]
[null,"Weaning related expenses"]
[null,"Veterinary",null,null,null,null,null,"$/head",8]
[null,"Labor",null,null,null,null,null,"$/head",2]
[null,"Hedging or option expense",null,null,null,null,null,"$/head",0]
[null,"Other weaning expense",null,null,null,null,null,"$/head",1]
[]
[null,"Sale related information expenses"]
[null,"Commission and transport if SOLD",null,null,null,null,null,"$/head",5]
[null,"Beef checkoff",null,null,null,null,null,"$/head",1]
[null,"Hedging and option expense",null,null,null,null,null,"$/head",0]
[null,"Other expense if SOLD",null,null,null,null,null,"$/head",0]
[null,"Total weaning expenses if SOLD",null,null,null,null,null,"$/head",{"$f":"SUM(I14:I17)+SUM(I8:I11)","v":17}]
[null,"Percent shrink if SOLD",null,null,null,null,null,"%",0.04]
[null,"Sale weight net of shrink",null,null,null,null,null,"lb",{"$f":"E5*(1-I19)","v":432}]
[null,"Sale price",null,null,null,null,null,"$/cwt",119.16]
[null,"Sale revenue",null,null,null,null,null,"$/head",{"$f":"I21/100*I20","v":514.77120000000002}]
[null,"Returns to cow-calf expenses",null,null,null,null,null,"$/head",{"$f":"I22-I18","v":497.77120000000002}]
[]
[null,"Retained calf information and expenses"]
[null,"Transport if RETAINED",null,null,null,null,null,"$/head",0]
[null,"Other expense if RETAINED",null,null,null,null,null,"$/head",1]
[null,"Total weaning expenses if RETAINED",null,null,null,null,null,"$/head",{"$f":"SUM(I8:I11)+SUM(I26:I27)","v":12}]
[null,"Percent shrink if RETAINED",null,null,null,null,null,"%",0]
[null,"Transfer weight net of shrink",null,null,null,null,null,"lb",{"$f":"E5*(1-I29)","v":450}]
[]
[]
[]
[]
[]
[]
[null,null,null,"←",null,null,null,"→"]

{"sheet":"Preconditioning","index":2,"n_rows":56,"n_cols":11,"rows_kept":56,"cut":false,"hidden":false,"merged":[[16,1,16,2],[16,4,16,5],[16,6,16,7],[35,1,35,8],[41,1,41,10],[23,1,23,8],[34,1,34,8],[17,1,17,8],[18,1,18,8],[19,1,19,8],[20,1,20,8],[26,1,26,10],[27,1,27,8],[28,1,28,8],[29,1,29,8],[22,1,22,2],[6,1,6,7],[13,1,13,2],[13,4,13,5],[13,6,13,7],[12,1,12,10],[7,1,7,7],[7,9,7,10],[8,1,8,5],[8,6,8,7],[8,9,8,10],[9,1,9,5],[9,6,9,7],[9,9,9,10],[10,1,10,5],[10,6,10,7],[10,9,10,10],[4,1,4,5],[4,6,4,7],[4,9,4,10],[5,1,5,7],[5,9,5,10],[0,9,0,10],[1,1,2,8],[1,9,1,10],[2,9,2,10],[3,1,3,5],[3,9,3,10],[11,9,11,10],[14,1,14,2],[14,4,14,5],[14,6,14,7],[15,1,15,2],[15,4,15,5],[15,6,15,7],[22,3,22,4],[22,6,22,7],[25,9,25,10],[24,1,24,8],[21,1,21,8],[45,1,45,8],[46,1,46,8],[47,1,47,8],[30,1,30,8],[32,1,32,8],[33,1,33,8],[44,1,44,8],[36,1,36,8],[38,1,38,8],[39,1,39,8],[37,1,37,8],[43,1,43,8],[31,1,31,8],[42,1,42,9]]}
[]
[null,"Preconditioning information"]
[]
[]
[null,"Death loss during preconditioning",null,null,null,null,"%",null,0.01]
[null,"Date preconditioning starts",null,null,null,null,null,null,{"$f":"Wean!E4","v":"2009-10-16"}]
[null,"Days preconditioning",null,null,null,null,null,null,45]
[null,"Date preconditioning ends",null,null,null,null,null,null,{"$f":"I6+I7","v":"2009-11-30"}]
[null,"ADG during preconditioning",null,null,null,null,"lb/day",null,2]
[null,"Starting weight",null,null,null,null,"lb/head",null,{"$f":"Wean!I30","v":450}]
[null,"End weight",null,null,null,null,"lb/head",null,{"$f":"I10+I7*I9","v":540}]
[]
[null,"Expenses during preconditioning"]
[null,"Hay",null,"$/ton",75,null,"lb/head/day",null,12,"$/head",{"$f":"E14/2000*I14*I7","v":20.249999999999996}]
[null,"Supplement",null,"$/ton",200,null,"lb/head/day",null,2,"$/head",{"$f":"E15/2000*I15*I7","v":9}]
[null,"Mineral",null,"$/ton",600,null,"oz/head/day",null,4,"$/head",{"$f":"E16/2000*I16*I7/128","v":0.421875}]
[null,"Other feed",null,"$/ton",200,null,"lb/head/day",null,0,"$/head",{"$f":"E17/2000*I17*I7","v":0}]
[null,"Veterinary costs",null,null,null,null,null,null,null,"$/head",3]
[null,"Labor",null,null,null,null,null,null,null,"$/head",0]
[null,"Equipment and machinery",null,null,null,null,null,null,null,"$/head",0]
[null,"Management fee",null,null,null,null,null,null,null,"$/head",0]
[null,"Other preconditioning expense (e.g., program fees)",null,null,null,null,null,null,null,"$/head",0]
[null,"Yardage",null,"$/hd/day",null,0,"Days",null,{"$f":"I7","v":45},"$/head",{"$f":"F23*I23","v":0}]
[null,"Interest expense on operating expense",null,null,null,null,null,null,null,"$/head",{"$f":"(SUM(K14:K23)/2+K36)*Scenario!F13/365*I7","v":0.22803730736301372}]
[null,"Opportunity cost of calf during preconditioning",null,null,null,null,null,null,null,"$/head",{"$f":"Wean!I23*Scenario!F13/365*Preconditioning!I7","v":3.9889883835616438}]
[]
[null,"Sale related information and expenses"]
[null,"% shrink if SOLD",null,null,null,null,null,null,null,"%",0.02]
[null,"Sale weight net of shrink",null,null,null,null,null,null,null,"lb",{"$f":"I11*(1-K28)","v":529.20000000000005}]
[null,"Commission and transport if SOLD",null,null,null,null,null,null,null,"$/head",5]
[null,"Beef checkoff",null,null,null,null,null,null,null,"$/head",1]
[null,"Hedging and option expense",null,null,null,null,null,null,null,"$/head",0]
[null,"Other expense if SOLD",null,null,null,null,null,null,null,"$/head",1]
[null,"Preconditioning  expense if SOLD*",null,null,null,null,null,null,null,"$/head",{"$f":"SUM(K14:K25)*(1+I5)+SUM(K30:K33)","v":44.257789697833907}]
[null,"Preconditioning cost of gain if SOLD* (breakeven sale price)",null,null,null,null,null,null,null,"$/lb",{"$f":"(data!C48+Preconditioning!K34)/Preconditioning!K29/(1-Preconditioning!I5)","v":1.0345881141304083}]
[null,"Prior production expense",null,null,null,null,null,null,null,"$/head",{"$f":"data!C46*(1+I5)","v":12.120000000000001}]
[null,"Market price if SOLD after preconditioning",null,null,null,null,null,null,null,"$/cwt",108.48000305175782]
[null,"Sale price premium if SOLD after preconditioning",null,null,null,null,null,null,null,"$/cwt",4]
[null,"Revenue if SOLD after preconditioning*",null,null,null,null,null,null,null,"$/head",{"$f":"(K37+K38)/100*K29*(1-I5)","v":589.29173438840348}]
[null,"Returns to cow-calf expense and retention if SOLD*",null,null,null,null,null,null,null,"$/head",{"$f":"K39-K34-K36","v":532.91394469056956}]
[]
[null,"Additional retention information and expenses"]
[null,"% shrink if RETAINED after preconditioning",null,null,null,null,null,null,null,null,0.01]
[null,"Transfer weight net  of shrink",null,null,null,null,null,null,null,"lb",{"$f":"I11*(1-K43)","v":534.6}]
[null,"Transport if RETAINED after preconditioning",null,null,null,null,null,null,null,"$/head",2]
[null,"Other expense",null,null,null,null,null,null,null,"$/head",1]
[null,"Preconditioning expense if RETAINED after preconditioning*",null,null,null,null,null,null,null,"$/head",{"$f":"SUM(K14:K25)*(1+I5)+SUM(K45:K46)","v":40.257789697833907}]
[null,"Preconditioning cost of gain if RETAINED after preconditioning*",null,null,null,null,null,null,null,"$/lb",{"$f":"IF(I11>I10,K47/(I11-I10),\"No gain\")","v":0.44730877442037675}]
[]
[null,"*Revenue, returns, expense and cost of gain are computed with \"deads in.\""]
[null,"With  \"deads in,\" the model assumes that all production-related expenses are incurred before death."]
[]
[]
[]
[]
[null,null,null,"←",null,null,null,null,"→"]

{"sheet":"Grass1","index":3,"n_rows":61,"n_cols":11,"rows_kept":61,"cut":false,"hidden":false,"merged":[[6,1,6,7],[0,9,0,10],[1,1,2,8],[1,9,1,10],[2,9,2,10],[3,1,3,5],[3,9,3,10],[4,1,4,5],[4,6,4,7],[4,9,4,10],[5,1,5,7],[5,9,5,10],[13,1,13,2],[13,4,13,5],[13,6,13,7],[7,1,7,7],[7,9,7,10],[8,1,8,5],[8,6,8,7],[8,9,8,10],[9,1,9,5],[9,6,9,7],[9,9,9,10],[10,1,10,5],[10,6,10,7],[10,9,10,10],[11,9,11,10],[12,1,12,10],[19,1,19,8],[14,1,14,2],[14,4,14,5],[14,6,14,7],[15,1,15,2],[15,4,15,5],[15,6,15,7],[16,1,16,2],[16,4,16,5],[16,6,16,7],[17,1,17,8],[18,1,18,8],[34,1,34,8],[20,1,20,8],[21,1,21,8],[28,1,28,8],[29,1,29,8],[23,1,23,2],[23,3,23,4],[23,5,23,7],[24,1,24,8],[25,1,25,2],[25,3,25,4],[25,5,25,6],[26,1,26,2],[26,3,26,4],[26,5,26,6],[27,1,27,2],[30,9,30,10],[31,1,31,10],[32,1,32,8],[33,1,33,8],[22,1,22,4],[22,6,22,7],[27,3,27,4],[27,5,27,6],[42,1,42,8],[43,1,43,8],[44,1,44,8],[46,1,46,10],[47,1,47,9],[41,1,41,8],[35,1,35,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[39,1,39,8],[40,1,40,8],[48,1,48,8],[49,1,49,8],[50,1,50,8],[51,1,51,8],[52,1,52,8]]}
[]
[null,"Grass pasture (1)  information"]
[]
[]
[null,"Death loss during grazing",null,null,null,null,"%",null,0.01]
[null,"Date grazing starts",null,null,null,null,null,null,{"$f":"data!E45","v":"2009-11-30"}]
[null,"Days grazing",null,null,null,null,null,null,45]
[null,"Date grazing ends",null,null,null,null,null,null,{"$f":"I6+I7","v":"2010-01-14"}]
[null,"ADG during grazing",null,null,null,null,"lb/day",null,1.5]
[null,"Starting weight",null,null,null,null,"lb/head",null,{"$f":"data!E47","v":534.6}]
[null,"End weight",null,null,null,null,"lb/head",null,{"$f":"I10+I7*I9","v":602.1}]
[]
[null,"Expenses during grazing"]
[null,"Hay",null,"$/ton",80,null,"lb/head/day",null,5,"$/head",{"$f":"E14/2000*I14*I7","v":9}]
[null,"Supplement",null,"$/ton",380,null,"lb/head/day",null,0,"$/head",{"$f":"E15/2000*I15*I7","v":0}]
[null,"Mineral",null,"$/ton",600,null,"oz/head/day",null,4,"$/head",{"$f":"E16/2000*I16*I7/128","v":0.421875}]
[null,"Other feed",null,"$/ton",200,null,"lb/head/day",null,0,"$/head",{"$f":"E17/2000*I17*I7","v":0}]
[null,"Veterinary costs",null,null,null,null,null,null,null,"$/head",2]
[null,"Labor",null,null,null,null,null,null,null,"$/head",0.5]
[null,"Equipment and machinery",null,null,null,null,null,null,null,"$/head",0]
[null,"Management fee",null,null,null,null,null,null,null,"$/head",0]
[null,"Other grazing expense",null,null,null,null,null,null,null,"$/head",0]
[null,"Is pasture owned or leased?",null,null,null,"Leased","Stocking rate",null,0.25,"head/ac"]
[null,"Terms",null,"$/lb of gain",null,"Rate ($/lb of gain)",null,null,0.4,"$/head",{"$f":"IF(F23=\"Leased\",IF(D24=\"$/cwt/month\",I24*I10/100*I7/30*I23,IF(D24=\"$/hd/month\",I24*I7/30*I23,I24*(I11-I10))),I24)","v":27}]
[null,"Pasture expenses"]
[null,"Seed ",null,"$/acre",null,0,null,null,null,"$/head",{"$f":"F26/$I$23","v":0}]
[null,"Fertilizer",null,"$/acre",null,0,null,null,null,"$/head",{"$f":"F27/$I$23","v":0}]
[null,"Weed control",null,"$/acre",null,0,null,null,null,"$/head",0]
[null,"Interest expense on operating",null,null,null,null,null,null,null,"$/head",{"$f":"(SUM(K14:K28)/2+K41)*Scenario!F13/365*I7","v":0.57892013106164397}]
[null,"Opportunity cost of calf during grazing",null,null,null,null,null,null,null,"$/head",{"$f":"Scenario!F13/365*I7*data!E48","v":4.2706113904109584}]
[]
[null,"Sale related information and expenses"]
[null,"% shrink if SOLD",null,null,null,null,null,null,null,"%",0.03]
[null,"Sale weight net of shrink",null,null,null,null,null,null,null,"lb",{"$f":"I11*(1-K33)","v":584.03700000000003}]
[null,"Commission and transport if SOLD",null,null,null,null,null,null,null,"$/head",5]
[null,"Beef checkoff",null,null,null,null,null,null,null,"$/head",1]
[null,"Hedging and option expense",null,null,null,null,null,null,null,"$/head",0]
[null,"Other expense if SOLD",null,null,null,null,null,null,null,"$/head",0]
[null,"Grass stocker  expense if SOLD*",null,null,null,null,null,null,null,"$/head",{"$f":"SUM(K14:K30)*(1+I5)+SUM(K35:K38)","v":50.209120586687327}]
[null,"Grass stocker cost of gain if SOLD* (breakeven sale price)",null,null,null,null,null,null,null,"$/lb",{"$f":"(data!E48+Grass1!K39)/Grass1!K34/(1-Grass1!I5)","v":1.0085202685921695}]
[null,"Prior production expense",null,null,null,null,null,null,null,"$/head",{"$f":"data!E49*(1+I5)","v":52.780378000000006}]
[null,"Market price if SOLD after grazing",null,null,null,null,null,null,null,"$/cwt",110.41499694824219]
[null,"Sale price premium if SOLD after grazing",null,null,null,null,null,null,null,"$/cwt",0]
[null,"Revenue if SOLD after grazing",null,null,null,null,null,null,null,"$/head",{"$f":"(K42+K43)/100*K34*(1-I5)","v":638.41579136933922}]
[null,"Returns to cow-calf expense and retention if SOLD",null,null,null,null,null,null,null,"$/head",{"$f":"K44-K39-K41","v":535.4262927826519}]
[]
[null,"Additional retention information and expenses"]
[null,"% shrink if RETAINED after grazing",null,null,null,null,null,null,null,null,0.01]
[null,"Transfer weight net of shrink",null,null,null,null,null,null,null,"lb",{"$f":"I11*(1-K48)","v":596.07900000000006}]
[null,"Transport if RETAINED after grazing",null,null,null,null,null,null,null,"$/head",2]
[null,"Other expense",null,null,null,null,null,null,null,"$/head",0]
[null,"Production expense if RETAINED after grazing*",null,null,null,null,null,null,null,"$/head",{"$f":"SUM(K14:K30)*(1+I5)+SUM(K50:K51)","v":46.209120586687327}]
[null,"Production cost of gain if RETAINED after grazing*",null,null,null,null,null,null,null,"$/lb",{"$f":"K52/(I11-I10)","v":0.68457956424721966}]
[]
[null,"*Revenue, returns, expense and cost of gain are computed with \"deads in.\""]
[null,"With  \"deads in,\" the model assumes that all production-related expenses are incurred before death."]
[]
[]
[]
[]
[null,null,null,"←",null,null,null,null,null,"→"]

{"sheet":"Feedlot","index":4,"n_rows":64,"n_cols":11,"rows_kept":64,"cut":false,"hidden":false,"merged":[[54,1,54,8],[40,1,40,8],[41,1,41,6],[42,1,42,8],[52,1,52,8],[19,1,19,3],[19,4,19,5],[19,6,19,7],[6,1,6,7],[13,1,13,2],[13,4,13,5],[13,6,13,7],[7,1,7,7],[10,1,10,5],[10,6,10,7],[15,1,15,2],[15,4,15,5],[15,6,15,7],[0,9,0,10],[1,1,2,8],[1,9,1,10],[2,9,2,10],[3,1,3,5],[3,9,3,10],[4,1,4,5],[4,6,4,7],[4,9,4,10],[5,1,5,7],[5,9,5,10],[7,9,7,10],[8,1,8,5],[8,6,8,7],[8,9,8,10],[9,1,9,5],[9,6,9,7],[9,9,9,10],[10,9,10,10],[11,9,11,10],[12,1,12,10],[14,1,14,2],[14,4,14,5],[14,6,14,7],[26,1,26,8],[16,1,16,2],[16,4,16,5],[16,6,16,7],[20,1,20,8],[21,1,21,8],[22,1,22,8],[23,1,23,8],[24,1,24,8],[25,1,25,2],[25,3,25,4],[25,6,25,7],[17,6,17,7],[17,1,17,2],[18,1,18,2],[18,3,18,4],[38,1,38,8],[27,1,27,8],[28,9,28,10],[29,1,29,10],[30,1,30,8],[31,1,31,8],[32,1,32,8],[33,1,33,8],[34,1,34,8],[35,1,35,8],[36,1,36,8],[37,1,37,8],[39,1,39,8],[51,1,51,8],[53,1,53,8],[43,1,43,8],[45,1,45,2],[44,1,44,2],[46,1,46,2],[48,1,48,2],[49,1,49,2],[47,1,47,2],[50,1,50,4],[50,6,50,7]]}
[]
[null,"Feedlot information"]
[]
[]
[null,"Death loss during finishing",null,null,null,null,"%",null,5.0000000000000001E-3]
[null,"Date finishing starts",null,null,null,null,null,null,{"$f":"data!H45","v":"2010-01-14"}]
[null,"Days finishing",null,null,null,null,null,null,160]
[null,"Date finishing ends",null,null,null,null,null,null,{"$f":"I6+I7","v":"2010-06-23"}]
[null,"ADG during finishing",null,null,null,null,"lb/day",null,3.2]
[null,"Starting weight",null,null,null,null,"lb/head",null,{"$f":"data!H47","v":596.07900000000006}]
[null,"End weight",null,null,null,null,"lb/head",null,{"$f":"I10+I7*I9","v":1108.0790000000002}]
[]
[null,"Expenses during finishing"]
[null,"Hay",null,"$/ton",80,null,"lb/head/day",null,25,"$/head",{"$f":"E14/2000*I14*I7","v":160}]
[null,"Supplement",null,"$/ton",380,null,"lb/head/day",null,7,"$/head",{"$f":"E15/2000*I15*I7","v":212.8}]
[null,"Mineral",null,"$/ton",600,null,"oz/head/day",null,4,"$/head",{"$f":"E16/2000*I16*I7/128","v":1.5}]
[null,"Other feed",null,"$/ton",200,null,"lb/head/day",null,2,"$/head",{"$f":"E17*I17*I7/2000","v":32}]
[null,"% dry matter",null,0.78,"DM",{"$f":"ROUND((I14+I15+I17+I16/16)*D18,1) & \" lb\"","v":"26.7 lb"},"Total as fed",null,{"$f":"ROUND(I14+I15+I17+I16/16,1) & \" lb\"","v":"34.3 lb"}]
[null,"Feed efficiency",null,"lb feed/ lb gain",null,"DM",{"$f":"(I11-I10)/((I14+I15+I17+I16/16)*D18)","v":19.165262960883403},"As fed",{"$f":"(I11-I10)/(I14+I15+I17+I16/16)","v":14.948905109489054}]
[null,"Feed cost of gain",null,null,"$/lb gain",null,{"$f":"SUM(K14:K17)/I9/I7","v":0.79355468750000002}]
[null,"Veterinary costs",null,null,null,null,null,null,null,"$/head",4]
[null,"Labor",null,null,null,null,null,null,null,"$/head",0]
[null,"Equipment and machinery",null,null,null,null,null,null,null,"$/head",0]
[null,"Management fee",null,null,null,null,null,null,null,"$/head",0]
[null,"Other finishing expense",null,null,null,null,null,null,null,"$/head",0]
[null,"Yardage",null,"$/hd/day",null,0.3,"Days",null,{"$f":"I7","v":160},"$/head",{"$f":"F26*I26","v":48}]
[null,"Interest expense on operating",null,null,null,null,null,null,null,"$/head",{"$f":"(SUM(K14:K26)/2+K39)*Scenario!F13/365*I7","v":9.3488658597260272}]
[null,"Opportunity cost of calf during finishing",null,null,null,null,null,null,null,"$/head",{"$f":"data!H48*I7*Scenario!F13/365","v":15.255982246575345}]
[]
[null,"Sale related information and expenses"]
[null,"% shrink when SOLD",null,null,null,null,null,null,null,"%",0.03]
[null,"Sale weight net of shrink",null,null,null,null,null,null,null,"lb",{"$f":"I11*(1-K31)","v":1074.8366300000002}]
[null,"Commission and transport when SOLD",null,null,null,null,null,null,null,"$/head",5]
[null,"Beef checkoff",null,null,null,null,null,null,null,"$/head",1]
[null,"Hedging and option expense",null,null,null,null,null,null,null,"$/head",0]
[null,"Other expense when SOLD",null,null,null,null,null,null,null,"$/head"]
[null,"Finishing  expense*",null,null,null,null,null,null,null,"$/head",{"$f":"SUM(K14:K28)*(1+I5)+SUM(K33:K36)","v":491.31937234683284}]
[null,"Finishing cost of gain* (breakeven sale price)",null,null,null,null,null,null,null,"$/lb",{"$f":"(K37+data!H48)/Feedlot!K32/(1-Feedlot!I5)","v":0.96005771438820919}]
[null,"Prior production expense",null,null,null,null,null,null,null,"$/head",{"$f":"data!H49*(1+I5)","v":98.95923449999998}]
[null,"Market (base) price",null,null,null,null,null,null,null,"$/cwt",85.125]
[null,"Revenue if sold LIVE",null,null,null,null,null,null,null,"$/head",{"$f":"K40*K32/100*(1-I5)","v":910.37990788106254}]
[null,"Anticipated dressing percentage",null,null,null,null,null,"%",0.625]
[null,"Plant average base carcass price",null,null,null,null,null,null,null,"$/cwt",135]
[null,"Grid pricing"]
[null,"Quality grade",null,"% Std","% Sel","% Ch","%Hg Ch","% Pr"]
[null,"%",null,0.01,0.15,0.65,0.15,0.04,"Total",{"$f":"SUM(D46:H46)","v":1}]
[null,"Premium (disc)",null,-12,-6,0,6,9,"Wtd avg","$/cwt",{"$f":"SUMPRODUCT(D46:H46,D47:H47)","v":0.23999999999999988}]
[null,"Yield Grade",null,"% YG1","% YG2","% YG3","% YG4","% YG5"]
[null,"%",null,0.05,0.18,0.72,0.04,0.01,"Total",{"$f":"SUM(D49:H49)","v":1}]
[null,"Premium (disc)",null,5,2,0,-8,-20,"Wtd avg","$/cwt",{"$f":"SUMPRODUCT(D49:H49,D50:H50)","v":8.9999999999999969E-2}]
[null,"Program premium (e.g., CAB) $/cwt",null,null,null,3,"% qualifying",null,0.6,"$/cwt",{"$f":"F51*I51","v":1.7999999999999998}]
[null,"Revenue if sold on GRID",null,null,null,null,null,null,null,"$/head",{"$f":"SUM(K43:K51)*K32/100*(1-I5)*I42","v":916.59615835337843}]
[null,"Returns to cow-calf expense and retention if sold LIVE",null,null,null,null,null,null,null,"$/head",{"$f":"K41-K39-K37","v":320.10130103422972}]
[null,"Returns to cow-calf expense and retention if sold on GRID",null,null,null,null,null,null,null,"$/head",{"$f":"K52-K39-K37","v":326.31755150654561}]
[null,"MAXIMUM of Returns to cow-calf expense and retention",null,null,null,null,null,null,null,"$/head",{"$f":"MAX(K53:K54)","v":326.31755150654561}]
[]
[null,"*Revenue, returns, expense and cost of gain are computed with \"deads in.\""]
[null,"With  \"deads in,\" the model assumes that all production-related expenses are incurred before death."]
[]
[]
[]
[]
[]
[null,null,null,null,"←",null,null,null,null,"→"]

{"sheet":"Drylot-Backgrounding","index":5,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":true,"merged":[[43,1,43,8],[44,1,44,8],[45,1,45,8],[46,1,46,8],[47,1,47,8],[37,1,37,8],[38,1,38,8],[39,1,39,8],[41,1,41,10],[42,1,42,9],[36,1,36,8],[24,1,24,8],[25,9,25,10],[26,1,26,10],[27,1,27,8],[28,1,28,8],[29,1,29,8],[31,1,31,8],[30,1,30,8],[32,1,32,8],[33,1,33,8],[34,1,34,8],[35,1,35,8],[23,1,23,8],[16,1,16,2],[16,4,16,5],[16,6,16,7],[17,1,17,8],[18,1,18,8],[19,1,19,8],[20,1,20,8],[21,1,21,8],[22,1,22,2],[22,3,22,4],[22,6,22,7],[14,1,14,2],[14,4,14,5],[14,6,14,7],[15,1,15,2],[15,4,15,5],[15,6,15,7],[13,1,13,2],[13,4,13,5],[13,6,13,7],[7,1,7,7],[7,9,7,10],[8,1,8,5],[8,6,8,7],[8,9,8,10],[9,1,9,5],[9,6,9,7],[9,9,9,10],[10,1,10,5],[10,6,10,7],[10,9,10,10],[11,9,11,10],[12,1,12,10],[6,1,6,7],[0,9,0,10],[1,1,2,8],[1,9,1,10],[2,9,2,10],[3,1,3,5],[3,9,3,10],[4,1,4,5],[4,6,4,7],[4,9,4,10],[5,1,5,7],[5,9,5,10]]}
[]
[null,"Drylot/Backgrounding information"]
[]
[]
[null,"Death loss during backgrounding",null,null,null,null,"%",null,0.01]
[null,"Date backgrounding starts",null,null,null,null,null,null,{"$f":"data!G45","v":"2009-11-30"}]
[null,"Days backgrounding",null,null,null,null,null,null,30]
[null,"Date backgrounding ends",null,null,null,null,null,null,{"$f":"I6+I7","v":"2009-12-30"}]
[null,"ADG during backgrounding",null,null,null,null,"lb/day",null,2.5]
[null,"Starting weight",null,null,null,null,"lb/head",null,{"$f":"data!G47","v":524.79}]
[null,"End weight",null,null,null,null,"lb/head",null,{"$f":"I10+I7*I9","v":599.79}]
[]
[null,"Expenses during backgrounding"]
[null,"Hay",null,"$/ton",80,null,"lb/head/day",null,10,"$/head",{"$f":"E14/2000*I14*I7","v":12}]
[null,"Supplement",null,"$/ton",380,null,"lb/head/day",null,1,"$/head",{"$f":"E15/2000*I15*I7","v":5.7}]
[null,"Mineral",null,"$/ton",600,null,"oz/head/day",null,4,"$/head",{"$f":"E16/2000*I16*I7/128","v":0.28125}]
[null,"Other feed",null,"$/ton",200,null,"lb/head/day",null,6,"$/head",{"$f":"E17/2000*I17*I7","v":18.000000000000004}]
[null,"Veterinary costs",null,null,null,null,null,null,null,"$/head",2]
[null,"Labor",null,null,null,null,null,null,null,"$/head",1]
[null,"Equipment and machinery",null,null,null,null,null,null,null,"$/head",2]
[null,"Management fee",null,null,null,null,null,null,null,"$/head",0]
[null,"Other backgrounding expense",null,null,null,null,null,null,null,"$/head",0]
[null,"Yardage",null,"$/hd/day",null,0.2,"Days",null,{"$f":"I7","v":30},"$/head",{"$f":"F23*I23","v":6}]
[null,"Interest expense on operating",null,null,null,null,null,null,null,"$/head",{"$f":"(SUM(K14:K23)/2+K36)*Scenario!F13/365*I7","v":0.12549785958904111}]
[null,"Opportunity cost of calf during backgrounding",null,null,null,null,null,null,null,"$/head",{"$f":"data!G48*Scenario!F13/365*'Drylot-Backgrounding'!I7","v":2.7609195205479455}]
[]
[null,"Sale related information and expenses"]
[null,"% shrink if SOLD",null,null,null,null,null,null,null,"%",0.03]
[null,"Sale weight net of shrink",null,null,null,null,null,null,null,"lb",{"$f":"I11*(1-K28)","v":581.79629999999997}]
[null,"Commission and transport if SOLD",null,null,null,null,null,null,null,"$/head",2]
[null,"Beef checkoff",null,null,null,null,null,null,null,"$/head",1]
[null,"Hedging and option expense",null,null,null,null,null,null,null,"$/head",0]
[null,"Other expense if SOLD",null,null,null,null,null,null,null,"$/head",5]
[null,"Backgrounding  expense if SOLD*",null,null,null,null,null,null,null,"$/head",{"$f":"SUM(K14:K25)*(1+I5)+SUM(K30:K33)","v":58.366344053938356}]
[null,"Backgrounding cost of gain if SOLD* (breakeven sale price)",null,null,null,null,null,null,null,"$/lb",{"$f":"(K34+data!G48)/'Drylot-Backgrounding'!K29/(1-'Drylot-Backgrounding'!I5)","v":0.99856853479879826}]
[null,"Prior production expense",null,null,null,null,null,null,null,"$/head",{"$f":"data!G49*(1+I5)","v":0}]
[null,"Market price if SOLD after backgrounding",null,null,null,null,null,null,null,"$/cwt",112.65000152587891]
[null,"Sale price premium if SOLD after backgrounding",null,null,null,null,null,null,null,"$/cwt",4]
[null,"Revenue if SOLD after backgrounding",null,null,null,null,null,null,null,"$/head",{"$f":"(K37+K38)/100*K29*(1-I5)","v":671.87873889923185}]
[null,"Returns to cow-calf expense and retention if SOLD",null,null,null,null,null,null,null,"$/head",{"$f":"K39-K34-K36","v":613.51239484529344}]
[]
[null,"Additional retention information and expenses"]
[null,"% shrink if RETAINED after backgrounding",null,null,null,null,null,null,null,null,0.02]
[null,"Transfer weight net of shrink",null,null,null,null,null,null,null,"lb",{"$f":"I11*(1-K43)","v":587.79419999999993}]
[null,"Transport if RETAINED after backgrounding",null,null,null,null,null,null,null,"$/head",1]
[null,"Other expense",null,null,null,null,null,null,null,"$/head",0]
[null,"Production expense if RETAINED after backgrounding*",null,null,null,null,null,null,null,"$/head",{"$f":"SUM(K14:K25)*(1+I5)+SUM(K45:K46)","v":51.366344053938356}]
[null,"Production cost of gain if RETAINED after backgrounding*",null,null,null,null,null,null,null,"$/lb",{"$f":"K47/(I11-I10)","v":0.68488458738584479}]
[]
[null,"*Revenue, returns, expense and cost of gain are computed with \"deads in.\""]
[null,"With  \"deads in,\" the model assumes that all production-related expenses are incurred before death."]
[]
[]
[]
[]
[]
[null,null,null,"←",null,null,null,null,null,"→"]

{"sheet":"Grass2","index":6,"n_rows":61,"n_cols":11,"rows_kept":61,"cut":false,"hidden":true,"merged":[[26,1,26,2],[26,3,26,4],[26,5,26,6],[27,1,27,2],[27,3,27,4],[27,5,27,6],[23,3,23,4],[23,5,23,7],[24,1,24,8],[25,1,25,2],[25,3,25,4],[25,5,25,6],[23,1,23,2],[6,1,6,7],[0,9,0,10],[1,1,2,8],[1,9,1,10],[2,9,2,10],[3,1,3,5],[3,9,3,10],[4,1,4,5],[4,6,4,7],[4,9,4,10],[5,1,5,7],[5,9,5,10],[13,1,13,2],[13,4,13,5],[13,6,13,7],[7,1,7,7],[7,9,7,10],[8,1,8,5],[8,6,8,7],[8,9,8,10],[9,1,9,5],[9,6,9,7],[9,9,9,10],[10,1,10,5],[10,6,10,7],[10,9,10,10],[11,9,11,10],[12,1,12,10],[14,1,14,2],[14,4,14,5],[14,6,14,7],[15,1,15,2],[15,4,15,5],[15,6,15,7],[16,1,16,2],[16,4,16,5],[16,6,16,7],[17,1,17,8],[18,1,18,8],[19,1,19,8],[20,1,20,8],[21,1,21,8],[22,1,22,4],[22,6,22,7],[39,1,39,8],[28,1,28,8],[29,1,29,8],[30,9,30,10],[31,1,31,10],[32,1,32,8],[33,1,33,8],[34,1,34,8],[35,1,35,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[52,1,52,8],[40,1,40,8],[41,1,41,8],[42,1,42,8],[43,1,43,8],[44,1,44,8],[46,1,46,10],[47,1,47,9],[48,1,48,8],[49,1,49,8],[50,1,50,8],[51,1,51,8]]}
[]
[null,"Grass pasture (2)  information"]
[]
[]
[null,"Death loss during grazing",null,null,null,null,"%",null,0.01]
[null,"Date grazing starts",null,null,null,null,null,null,{"$f":"data!F45","v":"2009-11-30"}]
[null,"Days grazing",null,null,null,null,null,null,20]
[null,"Date grazing ends",null,null,null,null,null,null,{"$f":"I6+I7","v":"2009-12-20"}]
[null,"ADG during grazing",null,null,null,null,"lb/day",null,2.5]
[null,"Starting weight",null,null,null,null,"lb/head",null,{"$f":"data!F47","v":512.32500000000005}]
[null,"End weight",null,null,null,null,"lb/head",null,{"$f":"I10+I7*I9","v":562.32500000000005}]
[]
[null,"Expenses during grazing"]
[null,"Hay",null,"$/ton",80,null,"lb/head/day",null,0,"$/head",{"$f":"E14/2000*I14*I7","v":0}]
[null,"Supplement",null,"$/ton",380,null,"lb/head/day",null,0,"$/head",{"$f":"E15/2000*I15*I7","v":0}]
[null,"Mineral",null,"$/ton",600,null,"oz/head/day",null,0,"$/head",{"$f":"E16/2000*I16*I7/128","v":0}]
[null,"Other feed",null,"$/ton",200,null,"lb/head/day",null,0,"$/head",{"$f":"E17/2000*I17*I7","v":0}]
[null,"Veterinary costs",null,null,null,null,null,null,null,"$/head",7]
[null,"Labor",null,null,null,null,null,null,null,"$/head",1]
[null,"Equipment and machinery",null,null,null,null,null,null,null,"$/head",2]
[null,"Management fee",null,null,null,null,null,null,null,"$/head",0]
[null,"Other grazing expense",null,null,null,null,null,null,null,"$/head",0]
[null,"Is pasture owned or leased?",null,null,null,"Leased","Stocking rate",null,0.6,"head/ac"]
[null,"Terms",null,"$/lb of gain",null,"Rate ($/lb of gain)",null,null,0.35,"$/head",{"$f":"IF(F23=\"Leased\",IF(D24=\"$/cwt/month\",I24*I10/100*I7/30*I23,IF(D24=\"$/hd/month\",I24*I7/30*I23,I24*(I11-I10))),I24)","v":17.5}]
[null,"Pasture expenses"]
[null,"Seed ",null,"$/acre",null,5,null,null,null,"$/head",{"$f":"F26/$I$23","v":8.3333333333333339}]
[null,"Fertilizer",null,"$/acre",null,5,null,null,null,"$/head",{"$f":"F27/$I$23","v":8.3333333333333339}]
[null,"Weed control",null,"$/acre",null,5,null,null,null,"$/head",8.3333333333333339]
[null,"Interest expense on operating",null,null,null,null,null,null,null,"$/head",{"$f":"(SUM(K14:K28)/2+K41)*Scenario!F13/365*I7","v":9.3493150684931525E-2}]
[null,"Opportunity cost of calf during grazing",null,null,null,null,null,null,null,"$/head",{"$f":"Scenario!F13/365*I7*data!F48","v":1.6369966849315067}]
[]
[null,"Sale related information and expenses"]
[null,"% shrink if SOLD",null,null,null,null,null,null,null,"%",0.01]
[null,"Sale weight net of shrink",null,null,null,null,null,null,null,"lb",{"$f":"I11*(1-K33)","v":556.70175000000006}]
[null,"Commission and transport if SOLD",null,null,null,null,null,null,null,"$/head",1]
[null,"Beef checkoff",null,null,null,null,null,null,null,"$/head",2]
[null,"Hedging and option expense",null,null,null,null,null,null,null,"$/head",2]
[null,"Other expense if SOLD",null,null,null,null,null,null,null,"$/head",5]
[null,"Grazing  expense if SOLD*",null,null,null,null,null,null,null,"$/head",{"$f":"SUM(K14:K30)*(1+I5)+SUM(K35:K38)","v":64.772794733972603}]
[null,"Grazing cost of gain if SOLD* (breakeven sale price)",null,null,null,null,null,null,null,"$/lb",{"$f":"(K39+data!F48)/Grass2!K34/(1-Grass2!I5)","v":0.95147531775993166}]
[null,"Prior production expense",null,null,null,null,null,null,null,"$/head",{"$f":"data!F49*(1+I5)","v":0}]
[null,"Market price if SOLD after grazing",null,null,null,null,null,null,null,"$/cwt",78.430003051757808]
[null,"Sale price premium if SOLD after grazing",null,null,null,null,null,null,null,"$/cwt",3]
[null,"Revenue if SOLD after grazing",null,null,null,null,null,null,null,"$/head",{"$f":"(K42+K43)/100*K34*(1-I5)","v":448.78902949404721}]
[null,"Returns to cow-calf expense and retention if SOLD",null,null,null,null,null,null,null,"$/head",{"$f":"K44-K39-K41","v":384.01623476007461}]
[]
[null,"Additional retention information and expenses"]
[null,"% shrink if RETAINED after grazing",null,null,null,null,null,null,null,null,0.04]
[null,"Transfer weight net of shrink",null,null,null,null,null,null,null,"lb",{"$f":"I11*(1-K48)","v":539.83199999999999}]
[null,"Transport if RETAINED after grazing",null,null,null,null,null,null,null,"$/head",1]
[null,"Other expense",null,null,null,null,null,null,null,"$/head",1]
[null,"Production expense if RETAINED after grazing*",null,null,null,null,null,null,null,"$/head",{"$f":"SUM(K14:K30)*(1+I5)+SUM(K50:K51)","v":56.772794733972603}]
[null,"Production cost of gain if RETAINED after grazing*",null,null,null,null,null,null,null,"$/lb",{"$f":"K52/(I11-I10)","v":1.135455894679452}]
[]
[null,"*Revenue, returns, expense and cost of gain are computed with \"deads in.\""]
[null,"With  \"deads in,\" the model assumes that all production-related expenses are incurred before death."]
[]
[]
[]
[]
[null,null,null,"←",null,null,null,null,"→"]

{"sheet":"Wheat","index":7,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":true,"merged":[[6,1,6,7],[0,9,0,10],[1,1,2,8],[1,9,1,10],[2,9,2,10],[3,1,3,5],[3,9,3,10],[4,1,4,5],[4,6,4,7],[4,9,4,10],[5,1,5,7],[5,9,5,10],[13,1,13,2],[13,4,13,5],[13,6,13,7],[7,1,7,7],[7,9,7,10],[8,1,8,5],[8,6,8,7],[8,9,8,10],[9,1,9,5],[9,6,9,7],[9,9,9,10],[10,1,10,5],[10,6,10,7],[10,9,10,10],[11,9,11,10],[12,1,12,10],[14,1,14,2],[14,4,14,5],[14,6,14,7],[15,1,15,2],[15,4,15,5],[15,6,15,7],[19,1,19,8],[20,1,20,8],[21,1,21,8],[22,1,22,4],[22,6,22,7],[16,1,16,2],[16,4,16,5],[16,6,16,7],[17,1,17,8],[18,1,18,8],[40,1,40,8],[29,1,29,8],[30,1,30,8],[31,9,31,10],[32,1,32,10],[33,1,33,8],[34,1,34,8],[35,1,35,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[39,1,39,8],[53,1,53,8],[41,1,41,8],[42,1,42,8],[43,1,43,8],[44,1,44,8],[45,1,45,8],[47,1,47,10],[48,1,48,9],[49,1,49,8],[50,1,50,8],[51,1,51,8],[52,1,52,8],[28,5,28,6],[28,1,28,2],[27,1,27,2],[23,5,23,7],[24,1,24,8],[25,5,25,6],[25,1,25,2],[25,3,25,4],[27,3,27,4],[27,5,27,6],[26,1,26,2],[26,3,26,4],[26,5,26,6],[23,1,23,2],[23,3,23,4]]}
[]
[null,"Wheat pasture  information"]
[]
[]
[null,"Death loss during grazing",null,null,null,null,"%",null,0.01]
[null,"Date grazing starts",null,null,null,null,null,null,{"$f":"data!D45","v":"2009-12-20"}]
[null,"Days grazing",null,null,null,null,null,null,50]
[null,"Date grazing ends",null,null,null,null,null,null,{"$f":"I6+I7","v":"2010-02-08"}]
[null,"ADG during grazing",null,null,null,null,"lb/day",null,3.2]
[null,"Starting weight",null,null,null,null,"lb/head",null,{"$f":"data!D47","v":539.83199999999999}]
[null,"End weight",null,null,null,null,"lb/head",null,{"$f":"I10+I7*I9","v":699.83199999999999}]
[]
[null,"Expenses during grazing"]
[null,"Hay",null,"$/ton",80,null,"lb/head/day",null,0,"$/head",{"$f":"E14/2000*I14*I7","v":0}]
[null,"Supplement",null,"$/ton",380,null,"lb/head/day",null,2,"$/head",{"$f":"E15/2000*I15*I7","v":19}]
[null,"Mineral",null,"$/ton",600,null,"oz/head/day",null,4,"$/head",{"$f":"E16/2000*I16*I7/128","v":0.46875}]
[null,"Other feed",null,"$/ton",200,null,"lb/head/day",null,0,"$/head",{"$f":"E17/2000*I17*I7","v":0}]
[null,"Veterinary costs",null,null,null,null,null,null,null,"$/head",3]
[null,"Labor",null,null,null,null,null,null,null,"$/head",0.5]
[null,"Equipment and machinery",null,null,null,null,null,null,null,"$/head",0]
[null,"Management fee",null,null,null,null,null,null,null,"$/head",0]
[null,"Other grazing expense",null,null,null,null,null,null,null,"$/head",0]
[null,"Is pasture owned or leased?",null,null,null,"Leased","Stocking rate",null,0.5,"head/ac"]
[null,"Terms",null,"$/lb of gain",null,"Rate ($/lb of gain)",null,null,0.4,"$/head",{"$f":"IF(F23=\"Leased\",IF(D24=\"$/cwt/month\",I24*I10/100*I7/30*I23,IF(D24=\"$/hd/month\",I24*I7/30*I23,I24*(I11-I10))),I24)","v":64}]
[null,"Pasture expenses"]
[null,"Seed ",null,"$/acre",null,0,null,null,null,"$/head",{"$f":"F26/$I$23","v":0}]
[null,"Fertilizer",null,"$/acre",null,0,null,null,null,"$/head",{"$f":"F27/$I$23","v":0}]
[null,"Weed control",null,"$/acre",null,0,null,null,null,"$/head",0]
[null,"Reduced yield",null,"bu/acre",0,"Wheat price",null,"$/bu",0,"$/head",{"$f":"IF(F23=\"Owned\",E29*I29/I23,0)","v":0}]
[null,"Interest expense on operating",null,null,null,null,null,null,null,"$/head",{"$f":"(SUM(K14:K29)/2+K42)*Scenario!F13/365*I7","v":0.38718964041095894}]
[null,"Opportunity cost of calf during grazing",null,null,null,null,null,null,null,"$/head",{"$f":"I7*data!D48*Scenario!F13/365","v":3.0157524657534247}]
[]
[null,"Sale related information and expenses"]
[null,"% shrink if SOLD",null,null,null,null,null,null,null,"%",0.03]
[null,"Sale weight net of shrink",null,null,null,null,null,null,null,"lb",{"$f":"I11*(1-K34)","v":678.83704}]
[null,"Commission and transport if SOLD",null,null,null,null,null,null,null,"$/head",5]
[null,"Beef checkoff",null,null,null,null,null,null,null,"$/head",1]
[null,"Hedging and option expense",null,null,null,null,null,null,null,"$/head",0]
[null,"Other expense if SOLD",null,null,null,null,null,null,null,"$/head"]
[null,"Wheat stocker  expense if SOLD*",null,null,null,null,null,null,null,"$/head",{"$f":"SUM(K14:K31)*(1+I5)+SUM(K36:K39)","v":97.275409027226019}]
[null,"Wheat stocker cost of gain if SOLD* (breakeven sale price)",null,null,null,null,null,null,null,"$/lb",{"$f":"(K40+data!D48)/Wheat!K35/(1-Wheat!I5)","v":0.64871433982112003}]
[null,"Prior production expense",null,null,null,null,null,null,null,"$/head",{"$f":"data!D49*(1+I5)","v":0}]
[null,"Market price if SOLD after grazing",null,null,null,null,null,null,null,"$/cwt",97.589998474121089]
[null,"Sale price premium if SOLD after grazing",null,null,null,null,null,null,null,"$/cwt"]
[null,"Revenue if SOLD after grazing",null,null,null,null,null,null,null,"$/head",{"$f":"(K43+K44)/100*K35*(1-I5)","v":655.85228640799107}]
[null,"Returns to cow-calf expense and retention if SOLD",null,null,null,null,null,null,null,"$/head",{"$f":"K45-K40-K42","v":558.57687738076504}]
[]
[null,"Additional retention information and expenses"]
[null,"% shrink if RETAINED after grazing",null,null,null,null,null,null,null,null,0.03]
[null,"Transfer weight net of shrink",null,null,null,null,null,null,null,"lb",{"$f":"I11*(1-K49)","v":678.83704}]
[null,"Transport if RETAINED after grazing",null,null,null,null,null,null,null,"$/head",3]
[null,"Other expense",null,null,null,null,null,null,null,"$/head",0]
[null,"Production expense if RETAINED after grazing*",null,null,null,null,null,null,null,"$/head",{"$f":"SUM(K14:K31)*(1+I5)+SUM(K51:K52)","v":94.275409027226019}]
[null,"Production cost of gain if RETAINED after grazing*",null,null,null,null,null,null,null,"$/lb",{"$f":"K53/(I11-I10)","v":0.58922130642016257}]
[]
[null,"*Revenue, returns, expense and cost of gain are computed with \"deads in.\""]
[null,"With  \"deads in,\" the model assumes that all production-related expenses are incurred before death."]
[]
[]
[]
[]
[null,null,null,"←",null,null,null,null,"→"]

{"sheet":"Results","index":8,"n_rows":76,"n_cols":10,"rows_kept":76,"cut":false,"hidden":false,"merged":[[32,1,32,3],[33,1,33,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[37,1,37,3],[41,1,41,3],[42,1,42,3],[18,1,18,9],[35,1,35,3],[36,1,36,9],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[20,1,20,3],[22,1,22,3],[23,1,23,3],[21,1,21,3],[34,1,34,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[8,1,8,3],[16,1,16,3],[17,1,17,3],[15,1,15,3],[14,1,14,3],[13,1,13,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[19,1,19,3],[3,1,3,3],[1,1,2,9],[4,1,4,3],[6,1,6,3],[7,1,7,3],[5,1,5,3],[54,1,54,9],[53,1,53,3],[61,1,61,3],[62,1,62,3],[63,1,63,3],[56,1,56,3],[59,1,59,3],[60,1,60,3],[57,1,57,3],[48,1,48,3],[49,1,49,3],[50,1,50,3],[51,1,51,3],[52,1,52,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[46,1,46,3],[47,1,47,3],[69,1,69,3],[55,1,55,3],[64,1,64,3],[65,1,65,3],[66,1,66,3],[67,1,67,3],[68,1,68,3],[58,1,58,3]]}
[]
[null,"Results\n($/head)"]
[]
[null,"Sale after:",null,null,"Weaning",{"$f":"Scenario!H17","v":"Preconditioning"},{"$f":"IF(Scenario!H18<>\"None\",Scenario!H18,\"\")","v":"Grass pasture"},{"$f":"IF(Scenario!H19<>\"None\",Scenario!H19,\"\")","v":"Feedlot"},{"$f":"IF(Scenario!H20<>\"None\",Scenario!H20,\"\")","v":""},{"$f":"IF(Scenario!H21<>\"None\",Scenario!H21,\"\")","v":""}]
[null,"Sale weight net of shrink",null,null,{"$f":"Wean!I20","v":432},529.20000000000005,584.03700000000003,1074.8366300000002]
[null,"Market price ($/cwt)",null,null,{"$f":"Wean!I21","v":119.16},108.48,110.41500000000001,135]
[null,"Premium ($/cwt)",null,null,{"$f":"\"--\"","v":"--"},4,0,2.13]
[null,"Death loss (%)",null,null,{"$f":"E7","v":"--"},0.01,0.01,5.0000000000000001E-3]
[null,"Revenue ($/hd)",null,null,{"$f":"E6/100*E5","v":514.77120000000002},589.29169999999999,638.41579999999999,916.6]
[null,"Feed expense",null,null,"--",40.020000000000003,9.42,406.3]
[null,"Prior expense",null,null,"--",12.120000000000001,63.380732000000002,137.02411199999997]
[null,"Pasture rent/yardage",null,null,null,0,54,48]
[null,"Other expense",null,null,null,{"$f":"IF(F4<>\"\",F15-SUM(F10:F12)-F14,\"\")","v":10.470000000000004},{"$f":"IF(G4<>\"\",G15-SUM(G10:G12)-G14,\"\")","v":9.2092680000000016},12.41588800000001,"",""]
[null,"Interest expense + opportunity cost",null,null,null,4.26,4.96,24.61]
[null,"Total expense",null,null,{"$f":"Wean!I18","v":17},66.87,140.97,628.35]
[null,"Returns to cow-calf + prior retention",null,null,{"$f":"E9-E15","v":497.77120000000002},{"$f":"IF(F5<>\"\",F9-F15,\"\")","v":522.42169999999999},{"$f":"IF(G5<>\"\",G9-G15,\"\")","v":497.44579999999996},288.25,"",""]
[null,"Returns to retention",null,null,"--",{"$f":"IF(F4<>\"\",F16-E16,\"\")","v":24.650499999999965},{"$f":"IF(G4<>\"\",G16-F16,\"\")","v":-24.975900000000024},-209.19579999999996,"",""]
[]
[null,"Sensitivity analysis--feeder calf sale price"]
[null,"Percent change in calf sale price",null,null,{"$f":"\"+/-\"","v":"+/-"},-0.15]
[null,null,null,null,"Weaning",{"$f":"IF(F4<>\"\",F4,\"\")","v":"Preconditioning"},{"$f":"IF(G4<>\"\",G4,\"\")","v":"Grass pasture"},"Feedlot","",""]
[null,"Days",null,null,{"$f":"\"--\"","v":"--"},45,45,160]
[null,"Sale weight net of shrink",null,null,{"$f":"$E$5","v":432},{"$f":"F5","v":529.20000000000005},{"$f":"IF(G21<>\"\",G5,\"\")","v":584.03700000000003},{"$f":"IF(H21<>\"\",H5,\"\")","v":1074.8366300000002},"",""]
[null,"Market price ($/cwt)",null,null,{"$f":"$E$6*(1+$F$20)","v":101.286},{"$f":"IF(F21<>\"Feedlot\",IF(F4<>\"\",F6*(1+G20)*(1+$F$20),\"\"),IF(F4<>\"\",F6*(1+G20),\"\"))","v":92.207999999999998},{"$f":"IF(G21<>\"Feedlot\",IF(G4<>\"\",G6*(1+H20)*(1+$F$20),\"\"),IF(G4<>\"\",G6*(1+H20),\"\"))","v":93.85275},{"$f":"IF(H21<>\"Feedlot\",IF(H4<>\"\",H6*(1+I20)*(1+$F$20),\"\"),IF(H4<>\"\",H6*(1+I20),\"\"))","v":135},{"$f":"IF(I21<>\"Feedlot\",IF(I4<>\"\",I6*(1+J20)*(1+$F$20),\"\"),IF(I4<>\"\",I6*(1+J20),\"\"))","v":""},{"$f":"IF(J21<>\"Feedlot\",IF(J4<>\"\",J6*(1+K20)*(1+$F$20),\"\"),IF(J4<>\"\",J6*(1+K20),\"\"))","v":""}]
[null,"Premium ($/cwt)",null,null,{"$f":"\"--\"","v":"--"},{"$f":"IF(F4<>\"\",F7,\"\")","v":4},{"$f":"IF(G4<>\"\",G7,\"\")","v":0},2.13,"",""]
[null,"Death loss (%)",null,null,{"$f":"E25","v":"--"},{"$f":"IF(F4<>\"\",F8,\"\")","v":0.01},{"$f":"IF(G4<>\"\",G8,\"\")","v":0.01},5.0000000000000001E-3,"",""]
[null,"Revenue ($/hd)",null,null,{"$f":"E24/100*E23","v":437.55552000000006},{"$f":"IF(F21<>\"Feedlot\",IF(F21<>\"\",F23*(F24+F25)/100*(1-F26),\"\"),IF(F21<>\"\",F9,\"\"))","v":504.04140864000004},542.65343766232502,916.6,"",{"$f":"IF(J21<>\"Feedlot\",IF(J21<>\"\",J23*(J24+J25)/100*(1-J26),\"\"),IF(J21<>\"\",J9,\"\"))","v":""}]
[null,"Feed expense",null,null,null,{"$f":"IF(F$4<>\"\",F10,\"\")","v":40.020000000000003},{"$f":"IF(G$4<>\"\",G10,\"\")","v":9.42},{"$f":"IF(H$4<>\"\",H10,\"\")","v":406.3},{"$f":"IF(I$4<>\"\",I10,\"\")","v":""},{"$f":"IF(J$4<>\"\",J10,\"\")","v":""}]
[null,"Prior expense",null,null,null,{"$f":"IF(F21<>\"\",IF($F$21<>\"\",F11,\"\"),\"\")","v":12.120000000000001},{"$f":"IF(G21<>\"\",IF($F$21<>\"\",G11,\"\"),\"\")","v":63.380732000000002},137.02411199999997,"",""]
[null,"Pasture rent/yardage",null,null,null,{"$f":"IF(F$21<>\"\",F12,\"\")","v":0},{"$f":"IF(G$21<>\"\",G12,\"\")","v":54},48,"",""]
[null,"Other expense",null,null,null,{"$f":"IF($F$21<>\"\",F13,\"\")","v":10.470000000000004},{"$f":"IF($F$21<>\"\",G13,\"\")","v":9.2092680000000016},12.41588800000001,"",""]
[null,"Returns to cow-calf + prior retention",null,null,null,{"$f":"IF(F21<>\"\",F14+(E34-E16)*F22*Scenario!$F$13/365,\"\")","v":3.641216810958904},{"$f":"IF(G21<>\"\",G14+(F34-F16)*G22*Scenario!$F$13/365,\"\")","v":4.2817885989039599},{"$f":"IF(H21<>\"\",H14+(G34-G16)*H22*Scenario!$F$13/365,\"\")","v":21.900752959615286},{"$f":"IF(I21<>\"\",I14+(H34-H16)*I22*Scenario!$F$13/365,\"\")","v":""},{"$f":"IF(J21<>\"\",J14+(I34-I16)*J22*Scenario!$F$13/365,\"\")","v":""}]
[null,"Total expense",null,null,{"$f":"E15","v":17},{"$f":"IF(F21<>\"\",SUM(F28:F32),\"\")","v":66.251216810958908},{"$f":"IF(G21<>\"\",SUM(G28:G32),\"\")","v":140.29178859890396},625.64075295961527,"",""]
[null,"Net return",null,null,{"$f":"E27-E33","v":420.55552000000006},{"$f":"IF(F21<>\"\",F27-F33,\"\")","v":437.79019182904113},{"$f":"IF(G21<>\"\",G27-G33,\"\")","v":402.36164906342105},{"$f":"IF(H21<>\"\",H27-H33,\"\")","v":290.95924704038475},{"$f":"IF(I21<>\"\",I27-I33,\"\")","v":""},{"$f":"IF(J21<>\"\",J27-J33,\"\")","v":""}]
[null,"Returns to retention",null,null,"--",{"$f":"IF(F21<>\"\",F34-E34,\"\")","v":17.234671829041076},{"$f":"IF(G21<>\"\",G34-F34,\"\")","v":-35.42854276562008},-111.4024020230363,"",""]
[]
[null,"Sensitivity analysis--feed expense"]
[null,"Percent change in feed expense",null,null,{"$f":"\"+/-\"","v":"+/-"},0.1]
[null,null,null,null,"Weaning",{"$f":"F4","v":"Preconditioning"},{"$f":"G4","v":"Grass pasture"},"Feedlot","",""]
[null,"Days",null,null,{"$f":"\"--\"","v":"--"},15]
[null,"Sale weight net of shrink",null,null,{"$f":"E5","v":432},{"$f":"F23","v":529.20000000000005},{"$f":"G23","v":584.03700000000003},{"$f":"H23","v":1074.8366300000002},{"$f":"I23","v":""},{"$f":"J23","v":""}]
[null,"Market price ($/cwt)",null,null,{"$f":"IF(E39<>\"\",E6,\"\")","v":119.16},{"$f":"IF(F39<>\"\",F6,\"\")","v":108.48},110.41500000000001,135,"",""]
[null,"Premium ($/cwt)",null,null,{"$f":"\"--\"","v":"--"},{"$f":"IF(F40<>\"\",F7,\"\")","v":4},{"$f":"IF(G22<>\"\",G25,\"\")","v":0},2.13,"",""]
[null,"Death loss (%)",null,null,{"$f":"E43","v":"--"},{"$f":"IF(F41<>\"\",F8,\"\")","v":0.01},{"$f":"IF(G22<>\"\",G26,\"\")","v":0.01},5.0000000000000001E-3,"",""]
[null,"Revenue ($/hd)",null,null,{"$f":"E42/100*E41","v":514.77120000000002},{"$f":"IF(F39<>\"Feedlot\",IF(F39<>\"\",F41*(F42+F43)/100*(1-F44),\"\"),IF(F39<>\"\",F9,\"\"))","v":589.29171840000004},638.41580901450016,916.6,"",{"$f":"IF(J39<>\"Feedlot\",IF(J39<>\"\",J41*(J42+J43)/100*(1-J44),\"\"),IF(J39<>\"\",J9,\"\"))","v":""}]
[null,"Feed expense",null,null,null,{"$f":"IF(F43<>\"\",F10*(1+$F$38),\"\")","v":44.022000000000006},{"$f":"IF(G43<>\"\",G10*(1+$F$38),\"\")","v":10.362},446.93000000000006,"",""]
[null,"Prior expense",null,null,null,{"$f":"IF(F44<>\"\",F11,\"\")","v":12.120000000000001},{"$f":"IF(G44<>\"\",G11-F10+F46-F14+F50,\"\")","v":67.383088342465754},{"$f":"IF(H44<>\"\",H11-G10+G46-G14+G50,\"\")","v":137.96611199999998},"",""]
[null,"Pasture rent/yardage",null,null,null,{"$f":"IF(F45<>\"\",F12,\"\")","v":0},54,48,"",""]
[null,"Other expense",null,null,null,{"$f":"IF(F46<>\"\",F13,\"\")","v":10.470000000000004},9.2092680000000016,12.41588800000001,"",""]
[null,"Interest expense + opportunity cost",null,null,null,{"$f":"IF(F47<>\"\",F14+(F46-F10)/2*Scenario!$F$13/365,\"\")","v":4.2603563424657533},{"$f":"IF(G47<>\"\",G14,\"\")","v":4.96},24.61,"",""]
[null,"Total expense",null,null,{"$f":"E33","v":17},{"$f":"IF(F39<>\"\",SUM(F46:F50),\"\")","v":70.872356342465764},{"$f":"IF(G39<>\"\",SUM(G46:G50),\"\")","v":145.91435634246577},669.92200000000003,"",""]
[null,"Returns to cow-calf + prior retention",null,null,{"$f":"E45-E51","v":497.77120000000002},{"$f":"IF(F39<>\"\",F45-F51,\"\")","v":518.41936205753427},{"$f":"IF(G39<>\"\",G45-G51,\"\")","v":492.50145267203436},246.678,"",""]
[null,"Returns to retention",null,null,"--",{"$f":"IF(F39<>\"\",F52-E52,\"\")","v":20.64816205753425},{"$f":"IF(G39<>\"\",G52-F52,\"\")","v":-25.917909385499911},{"$f":"IF(H39<>\"\",H52-G52,\"\")","v":-245.82345267203436},{"$f":"IF(I39<>\"\",I52-H52,\"\")","v":""},{"$f":"IF(J39<>\"\",J52-I52,\"\")","v":""}]
[]
[null,"Sensitivity analysis--death loss"]
[null,null,null,null,"Weaning",{"$f":"F4","v":"Preconditioning"},{"$f":"G4","v":"Grass pasture"},"Feedlot","",""]
[null,"Death loss",null,null,null,0.03,0.01,0.02]
[null,"Days",null,null,{"$f":"\"--\"","v":"--"},{"$f":"IF(F56<>\"\",F22,\"\")","v":45},{"$f":"IF(G56<>\"\",G22,\"\")","v":45},160,"",""]
[null,"Sale weight net of shrink",null,null,{"$f":"E23","v":432},{"$f":"F23","v":529.20000000000005},584.03700000000003,1074.8366300000002,"",""]
[null,"Market price ($/cwt)",null,null,{"$f":"E6","v":119.16},{"$f":"IF(F$56<>\"\",F6,\"\")","v":108.48},{"$f":"IF(G$56<>\"\",G6,\"\")","v":110.41500000000001},135,"",""]
[null,"Premium ($/cwt)",null,null,{"$f":"E25","v":"--"},{"$f":"IF(F$56<>\"\",F7,\"\")","v":4},{"$f":"IF(G$56<>\"\",G7,\"\")","v":0},2.13,"",""]
[null,"Revenue ($/hd)",null,null,{"$f":"E60/100*E59","v":514.77120000000002},{"$f":"IF(F56<>\"\",F9/(1-F8)*(1-F57),\"\")","v":577.3868171717171},{"$f":"IF(G56<>\"\",G9/(1-G8)*(1-G57),\"\")","v":638.41579999999999},902.78190954773868,"",""]
[null,"Feed expense",null,null,null,{"$f":"IF(F$56<>\"\",F10*(1+F$57)/(1+F$8),\"\")","v":40.812475247524759},{"$f":"IF(G$56<>\"\",G10*(1+G$57)/(1+G$8),\"\")","v":9.42},412.36417910447773,"",""]
[null,"Prior expense",null,null,null,{"$f":"IF(F$56<>\"\",F11*(1+F$57)/(1+F$8),\"\")","v":12.360000000000001},63.380731999999995,139.06924799999999,"",""]
[null,"Pasture rent/yardage",null,null,null,0,54,48.716417910447767,"",""]
[null,"Other expense",null,null,null,10.67732673267327,9.2092680000000016,12.601199761194042,"",""]
[null,"Interest expense + opportunity cost",null,null,null,{"$f":"IF(F56<>\"\",(F72/2+E69+F64)*Scenario!$F$13/365*F58*(1+F57)/(1+F8),\"\")","v":4.3447847210429957},{"$f":"IF(G56<>\"\",(G72/2+G64+F69)*Scenario!$F$13/365*G58*(1+G57)/(1+G8),\"\")","v":4.8525662848661444},{"$f":"IF(H56<>\"\",(H72/2+G69+H64)*Scenario!$F$13/365*H58*(1+H57)/(1+H8),\"\")","v":25.036773627844724},{"$f":"IF(I56<>\"\",(I72/2+H69+I64)*Scenario!$F$13/365*I58*(1+I57)/(1+I8),\"\")","v":""},{"$f":"IF(J56<>\"\",(J72/2+I69+J64)*Scenario!$F$13/365*J58*(1+J57)/(1+J8),\"\")","v":""}]
[null,"Total expense",null,null,{"$f":"E51","v":17},{"$f":"IF(F56<>\"\",SUM(F63:F67),\"\")","v":68.194586701241022},{"$f":"IF(G56<>\"\",SUM(G63:G67),\"\")","v":140.86256628486615},637.78781840396414,"",""]
[null,"Returns to cow-calf + prior retention",null,null,{"$f":"E62-E68","v":497.77120000000002},{"$f":"IF(F56<>\"\",F62-F68,\"\")","v":509.19223047047609},{"$f":"IF(G56<>\"\",G62-G68,\"\")","v":497.55323371513384},264.99409114377454,"",""]
[null,"Returns to retention",null,null,"--",{"$f":"IF(F56<>\"\",F69-E69,\"\")","v":11.421030470476069},{"$f":"IF(G56<>\"\",G69-F69,\"\")","v":-11.638996755342248},-232.5591425713593,"",""]
[]
[null,null,null,"presale expense",null,43.021900000000002,65.921899999999994,458.3,458.3,377.81880000000001]
[]
[]
[]
[null,null,null,"←",null,null,null,"→"]

{"sheet":"data","index":9,"n_rows":50,"n_cols":15,"rows_kept":50,"cut":false,"hidden":true,"merged":[]}
["Steer basis"]
["2003-07 Avg","low","high","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["400-500",400,499.99,28.27,33.840000000000003,35.44,33.5,28.02,26.88,24.77,21.07,19,20.16,26.03,29.42]
["500-600",500,599.99,15.34,22.54,24.17,22.66,19.649999999999999,16.57,15.01,12.54,9.6,7.26,13.68,15.5]
["600-700",600,699.99,4.71,9.83,13.29,13.27,11.48,9.69,8.43,7.74,7.19,4.68,5.97,6.79]
["700-800",700,799.99,0.34,2.4700000000000002,1.99,2.96,2.4900000000000002,3.44,2.66,2.38,1.72,1.4,3.54,4.0199999999999996]
[]
["heifer basis"]
["2003-07 Avg","low","high","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
["400-500",400,499.99,13.46,19.68,20.62,18.600000000000001,17.16,12.27,9.84,7.81,5.14,4.97,9.06,12.77]
["500-600",500,599.99,3.45,8.91,11.92,10.32,8.8699999999999992,7.49,4.82,3.35,0.81,-1.53,-0.45,4.2300000000000004]
["600-700",600,699.99,-1.27,1.18,2.2799999999999998,2.34,2.4700000000000002,1.66,-0.23,-0.57999999999999996,-2,-2.23,-2.2599999999999998,-0.81]
["700-800",700,799.99,-4.2699999999999996,-3.22,-5.51,-5.88,-5.78,-3.9,-4.6900000000000004,-5.78,-5.39,-6.5,-4.3099999999999996,-3.35]
[]
[]
["Feeder futures"]
["Steer basis",null,"DAILY"]
[null,null,"JAN","MAR","APR","MAY","AUG","SEP","OCT","NOV","Nearby"]
[null,null,1,3,4,5,8,9,10,11]
["2010-01-13",null,97.300003051757813,97.574996948242188,98.75,99.375,100.5,100.69999694824219,99.900001525878906,100.30000305175781,97.574996948242188]
[]
[]
["Fed cattle futures"]
[null,"JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","Nearby"]
[null,1,2,3,4,5,6,7,8,9,10,11,12]
["2010-01-13","",85.699996948242188,"",89.699996948242188,"",87.449996948242188,"",87.375,"",89.949996948242188,"",90.650001525878906,85.699996948242188]
[]
[]
[]
[]
[]
["download"]
[]
[null,"wean","precond","wheat","grass1","grass2","drylot","feedlot"]
["market price",{"$f":"Wean!I21","v":119.16},{"$f":"Preconditioning!K37","v":108.48000305175782},{"$f":"Wheat!K43","v":97.589998474121089},{"$f":"Grass1!K42","v":110.41499694824219},{"$f":"Grass2!K42","v":78.430003051757808},{"$f":"'Drylot-Backgrounding'!K37","v":112.65000152587891},{"$f":"IF(Feedlot!K53>Feedlot!K54,Feedlot!K40,Feedlot!K43)","v":135}]
["premium",null,{"$f":"Preconditioning!K38","v":4},{"$f":"Wheat!K44","v":0},{"$f":"Grass1!K43","v":0},{"$f":"Grass2!K43","v":3},{"$f":"'Drylot-Backgrounding'!K38","v":4},{"$f":"IF(Feedlot!K54>Feedlot!K53,SUM(Feedlot!K47:K51),0)","v":2.13}]
["death loss",null,{"$f":"Preconditioning!I5","v":0.01},{"$f":"Wheat!I5","v":0.01},{"$f":"Grass1!I5","v":0.01},{"$f":"Grass2!I5","v":0.01},{"$f":"'Drylot-Backgrounding'!I5","v":0.01},{"$f":"Feedlot!I5","v":5.0000000000000001E-3}]
["presale expense",{"$f":"SUM(Wean!I8:I11)","v":11},{"$f":"SUM(Preconditioning!K14:K23)","v":32.671875},{"$f":"SUM(Wheat!K14:K29)","v":86.96875},{"$f":"SUM(Grass1!K14:K28)","v":38.921875},{"$f":"SUM(Grass2!K14:K28)","v":52.500000000000007},{"$f":"SUM('Drylot-Backgrounding'!K14:K23)","v":46.981250000000003},{"$f":"SUM(Feedlot!K14:K26)","v":458.3}]
["gain",null,{"$f":"-C47+C43","v":84.600000000000023},{"$f":"-D47+D43","v":139.00504000000001},61.479000000000042,27.506999999999948,63.004199999999969,478.75763000000018]
["cost of gain",null,{"$f":"Preconditioning!K48","v":0.44730877442037675},{"$f":"Wheat!K54","v":0.58922130642016257},{"$f":"Grass1!K53","v":0.68457956424721966},{"$f":"Grass2!K53","v":1.135455894679452},{"$f":"'Drylot-Backgrounding'!K48","v":0.68488458738584479},{"$f":"Feedlot!K38","v":0.96005771438820919}]
["end date",{"$f":"Wean!E4","v":"2009-10-16"},{"$f":"Preconditioning!I8","v":"2009-11-30"},{"$f":"Wheat!I8","v":"2010-02-08"},{"$f":"Grass1!I8","v":"2010-01-14"},{"$f":"Grass2!I8","v":"2009-12-20"},{"$f":"'Drylot-Backgrounding'!I8","v":"2009-12-30"},{"$f":"Feedlot!I8","v":"2010-06-23"}]
["transfer exp out",{"$f":"Wean!I28","v":12},{"$f":"Preconditioning!K47","v":40.257789697833907},{"$f":"Wheat!K53","v":94.275409027226019},{"$f":"Grass1!K52","v":46.209120586687327},{"$f":"Grass2!K52","v":56.772794733972603},{"$f":"'Drylot-Backgrounding'!K47","v":51.366344053938356},{"$f":"Feedlot!K55","v":326.31755150654561}]
["transfer weight out",{"$f":"Wean!I30","v":450},{"$f":"Preconditioning!K44","v":534.6},{"$f":"Wheat!K50","v":678.83704},{"$f":"Grass1!K49","v":596.07900000000006},{"$f":"Grass2!K49","v":539.83199999999999},{"$f":"'Drylot-Backgrounding'!K44","v":587.79419999999993},{"$f":"Feedlot!K32","v":1074.8366300000002}]
["transfer value out",{"$f":"Wean!I23","v":497.77120000000002},{"$f":"Preconditioning!K40","v":532.91394469056956},{"$f":"Wheat!K46","v":558.57687738076504},{"$f":"Grass1!K45","v":535.4262927826519},{"$f":"Grass2!K45","v":384.01623476007461},{"$f":"'Drylot-Backgrounding'!K40","v":613.51239484529344},{"$f":"IF(Feedlot!K54>Feedlot!K53,Feedlot!K52,Feedlot!K41)","v":916.59615835337843}]
["end date in",null,"2009-10-16","2009-12-20","2009-11-30","2009-11-30","2009-11-30","2010-01-14"]
["transfer exp in",null,12,16.272300000000001,40.257800000000003,72.974800000000002,50.79,46.209099999999999]
["transfer weight in",null,450,539.83199999999999,534.6,512.32500000000005,524.79,596.07900000000006]
["transfer value in",null,497.77120000000002,338.69220000000001,532.91390000000001,459.61829999999998,516.78750000000002,535.42629999999997]
["total prior exp",null,12,0,52.257800000000003,0,0,98.466899999999995,0]
["order",2,3,0,4,0,0,5]

{"sheet":"More info","index":10,"n_rows":42,"n_cols":8,"rows_kept":42,"cut":false,"hidden":false,"merged":[[21,1,21,5],[22,1,22,3],[19,1,19,3],[1,1,1,9],[2,1,2,3],[3,2,3,5],[5,1,5,9],[6,1,6,5],[7,2,7,5],[9,1,9,6],[12,1,12,4],[13,1,13,3],[15,1,15,5],[16,1,16,2],[24,1,24,6],[25,1,25,6],[25,7,25,8],[41,4,41,5],[27,1,27,5],[27,7,27,8],[28,1,28,6],[30,1,32,9],[26,1,26,5],[26,7,26,8]]}
[]
[null,"For more information on improving sale price of calves through preconditioning, see:"]
[null,"Value of preconditioning"]
[null,"and","Cost and benefits of preconditioning"]
[]
[null,"How to participate in the OQBN vac-45 program and improving sale price of calves see:"]
[null,"The economic benefits of OQBN participation"]
[null,"and","Information on participating in OQBN"]
[]
[null,"Improving value through age and source verification:"]
[null,"Age and source verification"]
[]
[null,"Buyer preferences for calves:"]
[null,"Preferences for calves",null,null,"and","Calves"]
[]
[null,"Information on value-added in OK markets:"]
[null,"OK value-added"]
[]
[null,"Value added opportunities for OK calf producers:"]
[null,"Ok value-added opportunities"]
[]
[null,"Effects of preconditioning and price impact:"]
[null,"Impacts of preconditioning"]
[]
[null,"For more information on beef production,"]
[null,"see the OK Cooperative Extension Service factsheet library at:",null,null,null,null,null,"OSU factsheets"]
[null,"see the Master Cattleman homepage at:",null,null,null,null,null,"Master Cattleman"]
[null,"see the OSU Beef Extension homepage at:",null,null,null,null,null,"Beefextension.com"]
[null,"find your local OK Cooperative Extension Service office:",null,null,null,null,null,"OCES"]
[]
[null,"This program is a product of the Oklahoma Cooperative Extension Service and Oklahoma Agricultural Experiment Station at Oklahoma State University, Stillwater."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"←"]