{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Scenario","Grain","Dual purpose","Grazing","Canola","Results","More info"],"not_rendered":{"charts":0,"images":2,"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":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,1,12,12],[13,9,13,10],[13,11,13,12],[24,1,27,12],[28,9,28,10],[28,11,28,12],[14,1,17,7],[19,1,20,6],[14,8,17,12],[19,7,20,12],[21,1,22,6],[21,7,22,12]]}
[]
[null,"Oklahoma Canola Systems vs. Continuous\nWheat Systems Budget Comparison\nOklahoma State University\nOklahoma Cooperative Extension Service\nOklahoma Agricultural Experiment Station\nStillwater, Oklahoma\nDeveloped by Eric A. DeVuyst and Francis Epplin, Department of Agricultural Economics\nThomas F. Peeper and Mark C. Bowles, Department of Plant and Soil Sciences"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Enter scenario description",null,null,null,null,null,null,"2010-08-11"]
[]
[]
[]
[]
[null,"Select wheat system",null,null,null,null,null,"Select canola system"]
[]
[null,"Dual-purpose",null,null,null,null,null,"RoundUp Ready Canola"]
[]
[]
[null,"This program was developed in MS Excel 2007. If you are using an earlier version of MS Excel, you may experience loss of functionality and calculation errors. Users are strongly encouraged to upgrade to MS Excel 2007 or later versions. This program utilizes MS Excel Macros. To enable macros, click on the \"Options\" button at the top of the worksheet and select \"Enable.\""]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Build date",null,"2010-08-12"]

{"sheet":"Grain","index":1,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":true,"merged":[[49,1,49,3],[49,7,49,8],[49,10,49,11],[48,1,48,3],[48,7,48,8],[48,10,48,11],[16,1,16,3],[16,7,16,8],[16,10,16,11],[46,1,46,3],[46,7,46,8],[46,10,46,11],[47,1,47,3],[47,7,47,8],[47,10,47,11],[44,1,44,3],[44,7,44,8],[44,10,44,11],[45,1,45,3],[45,7,45,8],[45,10,45,11],[42,1,42,3],[42,7,42,8],[42,10,42,11],[43,1,43,3],[43,7,43,8],[43,10,43,11],[40,1,40,3],[40,7,40,8],[40,10,40,11],[41,1,41,3],[41,7,41,8],[41,10,41,11],[39,1,39,3],[39,7,39,8],[39,10,39,11],[37,1,37,3],[37,7,37,8],[37,10,37,11],[38,1,38,3],[38,7,38,8],[38,10,38,11],[35,1,35,3],[35,7,35,8],[35,10,35,11],[36,1,36,3],[36,7,36,8],[36,10,36,11],[29,1,29,3],[29,7,29,8],[29,10,29,11],[34,1,34,3],[34,7,34,8],[34,10,34,11],[32,1,32,3],[32,7,32,8],[32,10,32,11],[33,1,33,3],[33,7,33,8],[33,10,33,11],[30,1,30,3],[30,7,30,8],[30,10,30,11],[31,1,31,3],[31,7,31,8],[31,10,31,11],[27,1,27,3],[27,7,27,8],[27,10,27,11],[28,1,28,3],[28,7,28,8],[28,10,28,11],[25,1,25,3],[25,7,25,8],[25,10,25,11],[26,1,26,3],[26,7,26,8],[26,10,26,11],[21,7,21,8],[13,7,13,8],[21,1,21,3],[23,1,23,3],[23,7,23,8],[23,10,23,11],[24,1,24,3],[24,7,24,8],[24,10,24,11],[19,10,19,11],[20,10,20,11],[21,10,21,11],[22,1,22,3],[22,7,22,8],[22,10,22,11],[19,1,19,3],[20,1,20,3],[17,1,17,3],[18,1,18,3],[17,10,17,11],[18,10,18,11],[14,1,14,3],[15,1,15,3],[14,10,14,11],[12,1,12,3],[12,4,12,5],[12,6,12,8],[12,9,12,11],[13,1,13,3],[13,10,13,11],[10,1,10,3],[10,4,10,5],[10,6,10,8],[10,9,10,11],[11,1,11,3],[11,4,11,5],[15,10,15,11],[14,7,14,8],[15,7,15,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[11,6,11,8],[11,9,11,11],[1,1,3,11],[5,6,6,11],[7,6,8,8],[7,9,8,11],[9,1,9,3],[9,4,9,5],[9,6,9,8],[9,9,9,11],[7,1,8,3],[7,4,8,5]]}
[]
[null,"Grain-only Wheat Budgets"]
[]
[]
[]
[null,null,null,null,null,null,"Rotation"]
[]
[null,"Revenue",null,null,"units",null,"Grain-only Continuous Wheat",null,null,"Grain-only Wheat-Wheat-Canola"]
[]
[null,"Wheat grain yield",null,null,"bu/acre",null,40,null,null,43]
[null,"Wheat sale price",null,null,"$/bu",null,6,null,null,6]
[null,"Gross revenue",null,null,"$/acre",null,{"$f":"G11*G10","v":240},null,null,{"$f":"J11*J10","v":258}]
[]
[null,"Cash expenses for WHEAT production",null,null,"units","$/unit","Quantity\nper acre","$/acre",null,"Quantity\nper acre","$/acre"]
[null,"Wheat seed",null,null,"bu/acre",14,1,{"$f":"G15*F15","v":14},null,1,{"$f":"J15*F15","v":14}]
[]
[null,"Anhyrdous ammonia (82-0-0)",null,null,"lb/acre",0.43,68,{"$f":"G17*F17","v":29.24},null,76,{"$f":"J17*F17","v":32.68}]
[null,"Fertilizer application",null,null,"per acre",12,1,{"$f":"G18*F18","v":12},null,1,{"$f":"J18*F18","v":12}]
[null,"DAP (18-46-0)",null,null,"lb/acre",0.89,50,44.5,null,50,44.5]
[null,"Fertilizer application",null,null,"per acre",4,1,4,null,1,4]
[]
[null,"Herbicide (broadleaf)",null,null,"per acre",2.7,1,2.7,null,1,2.7]
[null,"Herbicide (grass)",null,null,"per acre",17.170000000000002,1,{"$f":"G23*F23","v":17.170000000000002},null,1,{"$f":"J23*F23","v":17.170000000000002}]
[null,"Herbicide3",null,null,"$/oz",null,null,0,null,null,0]
[null,"Herbicide application",null,null,"per acre",5,2,10,null,2,10]
[]
[null,"Insecticide1",null,null,"$/pint",5.91,0.75,4.4325000000000001,null,0.75,4.4325000000000001]
[null,"Insecticide2",null,null,"$/oz",null,null,0,null,null,0]
[null,"Pesticide application (aerial)",null,null,"per acre",5,1.33,6.65,null,1.33,6.65]
[null,null,null,null,null,null,null,null,null,0.75]
[null,"Foliar fungicide (1 out of 3 years)",null,null,"per acre",16.2,0.33,5.3460000000000001,null,0.33,5.3460000000000001]
[null,"Fungicide2",null,null,"$/oz",null,null,0,null,null,0]
[null,"Fungicide application",null,null,"per acre",null,null,0,null,null,0]
[null,"Other pesticide",null,null,null,null,null,0,null,null,0]
[]
[null,"Crop Insurance",null,null,"$/acre",7,1,{"$f":"G36*F36","v":7},null,1,{"$f":"J36*F36","v":7}]
[null,"Fuel",null,null,"$/gal",3.5,4.92,17.22,null,4.92,17.22]
[null,"Lube",null,null,"per acre",2.58,1,2.58,null,1,2.58]
[null,"Repair",null,null,"per acre",7.12,1,7.12,null,1,7.12]
[]
[null,"Wheat harvest and hauling"]
[null,"Base charge",null,null,"$/acre",21,1,{"$f":"G42*F42","v":21},null,1,{"$f":"J42*F42","v":21}]
[null,"Excess for > 20 bu/acre",null,null,"per bu",0.21,{"$f":"IF(G10>20, (G10-20),0)","v":20},4.2,null,{"$f":"IF(J10>20, (J10-20),0)","v":23},4.83]
[null,"Hauling",null,null,"per bu",0.23,{"$f":"G10","v":40},9.2000000000000011,null,{"$f":"J10","v":43},9.89]
[]
[null,"Cash cost pre-harvest subtotal",null,null,"per acre","xxx","xxx",{"$f":"SUM(H15:I39)","v":183.95850000000004},null,"xxx",{"$f":"SUM(K15:L39)","v":187.39850000000004}]
[null,"Operating note interest rate",null,null,"%",7.0000000000000007E-2,"xxx",{"$f":"H46*$F$47/12*8/2","v":4.2923650000000011},null,"xxx",{"$f":"K46*$F$47/12*8/2","v":4.3726316666666678}]
[]
[null,"Total cash expense",null,null,"per acre","xxx","xxx",{"$f":"SUM(H15:I44)+H47","v":222.65086500000001},null,"xxx",{"$f":"SUM(K15:L44)+K47","v":227.49113166666672}]
[null,"Net returns to land, fixed costs,\nlabor and management",null,null,"per acre","xxx","xxx",{"$f":"G12-H49","v":17.34913499999999},null,"xxx",{"$f":"J12-K49","v":30.508868333333282}]

{"sheet":"Dual purpose","index":2,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[50,1,50,3],[50,7,50,8],[50,10,50,11],[11,1,11,3],[11,4,11,5],[11,6,11,8],[11,9,11,11],[48,1,48,3],[48,7,48,8],[48,10,48,11],[49,1,49,3],[49,7,49,8],[49,10,49,11],[46,1,46,3],[46,7,46,8],[46,10,46,11],[47,1,47,3],[47,7,47,8],[47,10,47,11],[44,1,44,3],[44,7,44,8],[44,10,44,11],[45,1,45,3],[45,7,45,8],[45,10,45,11],[42,1,42,3],[42,7,42,8],[42,10,42,11],[43,1,43,3],[43,7,43,8],[43,10,43,11],[40,1,40,3],[40,7,40,8],[40,10,40,11],[41,1,41,3],[41,7,41,8],[41,10,41,11],[38,1,38,3],[38,7,38,8],[38,10,38,11],[39,1,39,3],[39,7,39,8],[39,10,39,11],[36,1,36,3],[36,7,36,8],[36,10,36,11],[37,1,37,3],[37,7,37,8],[37,10,37,11],[34,1,34,3],[34,7,34,8],[34,10,34,11],[35,1,35,3],[35,7,35,8],[35,10,35,11],[32,1,32,3],[32,7,32,8],[32,10,32,11],[33,1,33,3],[33,7,33,8],[33,10,33,11],[30,1,30,3],[30,7,30,8],[30,10,30,11],[31,1,31,3],[31,7,31,8],[31,10,31,11],[28,1,28,3],[28,7,28,8],[28,10,28,11],[29,1,29,3],[29,7,29,8],[29,10,29,11],[26,1,26,3],[26,7,26,8],[26,10,26,11],[27,1,27,3],[27,7,27,8],[27,10,27,11],[24,1,24,3],[24,7,24,8],[24,10,24,11],[25,1,25,3],[25,7,25,8],[25,10,25,11],[22,1,22,3],[22,7,22,8],[22,10,22,11],[23,1,23,3],[23,7,23,8],[23,10,23,11],[20,1,20,3],[20,7,20,8],[20,10,20,11],[21,1,21,3],[21,7,21,8],[21,10,21,11],[18,1,18,3],[18,7,18,8],[18,10,18,11],[19,1,19,3],[19,7,19,8],[19,10,19,11],[16,1,16,3],[16,7,16,8],[16,10,16,11],[17,1,17,3],[17,7,17,8],[17,10,17,11],[14,1,14,3],[14,7,14,8],[14,10,14,11],[15,1,15,3],[15,7,15,8],[15,10,15,11],[12,1,12,3],[12,4,12,5],[12,6,12,8],[12,9,12,11],[13,1,13,3],[13,4,13,5],[13,6,13,8],[13,9,13,11],[9,1,9,3],[9,4,9,5],[9,6,9,8],[9,9,9,11],[10,1,10,3],[10,4,10,5],[10,6,10,8],[10,9,10,11],[1,1,3,11],[5,6,6,11],[7,1,8,3],[7,4,8,5],[7,6,8,8],[7,9,8,11]]}
[]
[null,"Dual-Purpose Wheat Budgets"]
[]
[]
[]
[null,null,null,null,null,null,"Rotation"]
[]
[null,"Revenue",null,null,"units",null,"Dual-purpose Continuous Wheat",null,null,"Dual-purpose Wheat-Wheat-Canola"]
[]
[null,"Wheat grain yield",null,null,"bu/acre",null,33,null,null,36]
[null,"Wheat sale price",null,null,"$/bu",null,6,null,null,{"$f":"G11","v":6}]
[null,"Grazing revenue or return",null,null,"$/acre",null,90.447500000000005,null,null,{"$f":"G12","v":90.447500000000005}]
[null,"Gross revenue",null,null,"$/acre",null,{"$f":"G11*G10+G12","v":288.44749999999999},null,null,{"$f":"J11*J10+J12","v":306.44749999999999}]
[]
[null,"Cash expenses for WHEAT production",null,null,"units","$/unit","Quantity\nper acre","$/acre",null,"Quantity\nper acre","$/acre"]
[null,"Wheat seed",null,null,"bu/acre",14,2,{"$f":"G16*F16","v":28},null,2,{"$f":"J16*F16","v":28}]
[]
[null,"Anhyrdous ammonia (82-0-0)",null,null,"lb/acre",0.43,110,{"$f":"G18*F18","v":47.3},null,110,{"$f":"J18*F18","v":47.3}]
[null,"Anhyrdous ammonia application",null,null,"per acre",12,1,12,null,1,12]
[null,"Urea (46-0-0)",null,null,"lb/acre",0.89,20,17.8,null,33,29.37]
[null,"Fertilizer application",null,null,"per acre",4,2,8,null,2,8]
[]
[null,"Herbicide1 (broadleaf)",null,null,"$/pint",2.7,1,4,null,1,4]
[null,"Herbicide2 (grass)",null,null,"$/quart",17.170000000000002,1,17.170000000000002,null,1,17.170000000000002]
[null,"Herbicide3",null,null,"$/oz",null,null,0,null,null,0]
[null,"Herbicide application",null,null,"per acre",5,2,10,null,2,10]
[]
[null,"Insecticide1",null,null,"$/pint",5.91,1,5.91,null,1,5.91]
[null,"Insecticide2",null,null,"$/oz",null,null,0,null,null,0]
[null,"Insecticide application",null,null,"per acre",5,1,5,null,1,5]
[]
[null,"Fungicide1 (1 out 3 years)",null,null,"$/acre",16.2,0.33,5.3460000000000001,null,0.33,5.3460000000000001]
[null,"Fungicide2",null,null,"$/oz",null,null,0,null,null,0]
[null,"Fungicide application",null,null,"per acre",null,null,0,null,null,0]
[null,"Other pesticide",null,null,null,null,null,0,null,null,0]
[]
[null,"Crop Insurance",null,null,"$/acre",7,1,{"$f":"G37*F37","v":7},null,1,{"$f":"J37*F37","v":7}]
[null,"Fuel",null,null,"$/gal",3.5,4.92,17.22,null,4.92,17.22]
[null,"Lube",null,null,"per acre",2.58,1,2.58,null,1,2.58]
[null,"Repair",null,null,"per acre",7.12,1,7.12,null,1,7.12]
[]
[null,"Wheat harvest and hauling"]
[null,"Base charge",null,null,"$/acre",21,1,{"$f":"G43*F43","v":21},null,1,{"$f":"J43*F43","v":21}]
[null,"Excess for > 20 bu/acre",null,null,"per bu",0.21,{"$f":"IF(G10>20, (G10-20),0)","v":13},2.73,null,{"$f":"IF(J10>20, (J10-20),0)","v":16},3.36]
[null,"Hauling",null,null,"per bu",0.23,{"$f":"G10","v":33},7.5900000000000007,null,{"$f":"J10","v":36},8.2800000000000011]
[]
[null,"Cash cost pre-harvest subtotal",null,null,"per acre","xxx","xxx",{"$f":"SUM(H16:I40)","v":194.446},null,"xxx",{"$f":"SUM(K16:L40)","v":206.01600000000005}]
[null,"Operating note interest rate",null,null,"%",7.0000000000000007E-2,"xxx",{"$f":"H47*$F$48/12*8/2","v":4.5370733333333337},null,"xxx",{"$f":"K47*$F$48/12*8/2","v":4.8070400000000015}]
[]
[null,"Total cash expense",null,null,"per acre","xxx","xxx",{"$f":"SUM(H16:I45)+H48","v":230.30307333333332},null,"xxx",{"$f":"SUM(K16:L45)+K48","v":243.46304000000006}]
[null,"Net returns to land, fixed costs,\nlabor and management",null,null,"per acre","xxx","xxx",{"$f":"G13-H50","v":58.144426666666675},null,"xxx",{"$f":"J13-K50","v":62.984459999999928}]

{"sheet":"Grazing","index":3,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":true,"merged":[[7,1,7,5],[7,7,7,8],[1,1,3,8],[5,1,5,5],[5,7,5,8],[6,1,6,5],[6,7,6,8],[8,1,8,5],[8,7,8,8],[9,1,9,5],[9,7,9,8],[10,1,10,5],[10,7,10,8],[11,1,11,5],[11,7,11,8],[12,1,12,5],[12,7,12,8],[13,1,13,5],[13,7,13,8],[14,1,14,5],[14,7,14,8],[16,1,16,5],[16,7,16,8],[17,1,17,5],[17,7,17,8],[18,1,18,5],[18,7,18,8],[19,1,19,5],[19,7,19,8],[20,1,20,5],[20,7,20,8],[24,1,24,5],[24,7,24,8],[26,1,26,5],[26,7,26,8],[21,1,21,5],[21,7,21,8],[22,1,22,5],[22,7,22,8],[23,1,23,5],[23,7,23,8]]}
[]
[null,"Grazing returns worksheet"]
[]
[]
[]
[null,"Purchase price (or value) of stockers",null,null,null,null,"$/cwt",180]
[null,"Purchase weight of stockers",null,null,null,null,"lb",475]
[null,"Average daily gain of stockers",null,null,null,null,"#/day",2]
[null,"Days grazing wheat",null,null,null,null,"days",115]
[null,"Sale weight",null,null,null,null,"lb",{"$f":"H7+H8*H9","v":705}]
[null,"Sale price of stockers",null,null,null,null,"$/cwt",155]
[null,"Death loss",null,null,null,null,"%",0.02]
[null,"Value of gain net of death loss",null,null,null,null,"$/hd",{"$f":"(H10*H11/100*(1-H12))-H7*H6/100","v":215.89499999999998}]
[null,"Stocking rate",null,null,null,null,"ac/hd",2]
[null,"Value of gain",null,null,null,null,"$/ac",{"$f":"H13/H14","v":107.94749999999999}]
[]
[null,"Feed expense--excluding wheat",null,null,null,null,"$/hd",15]
[null,"Veterinary expense",null,null,null,null,"$/hd",12]
[null,"Trucking expense",null,null,null,null,"$/hd",8]
[null,"Other expenses",null,null,null,null,"$/hd"]
[null,"Other expenses",null,null,null,null,"$/hd"]
[null,"Other expenses",null,null,null,null,"$/hd"]
[null,"Other expenses",null,null,null,null,"$/hd"]
[null,"Total stocker expense",null,null,null,null,"$/hd",{"$f":"SUM(H17:I23)","v":35}]
[null,"Total stocker expense",null,null,null,null,"$/ac",{"$f":"H24/H14","v":17.5}]
[]
[null,"Stocker returns to wheat",null,null,null,null,"$/ac",{"$f":"H15-H25","v":90.447499999999991}]

{"sheet":"Canola","index":4,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[47,1,47,3],[48,1,48,3],[47,7,47,8],[48,7,48,8],[42,1,42,3],[42,7,42,8],[44,1,44,3],[45,1,45,3],[44,7,44,8],[45,7,45,8],[39,1,39,3],[39,7,39,8],[40,1,40,3],[40,7,40,8],[41,1,41,3],[41,7,41,8],[38,1,38,3],[38,7,38,8],[32,1,32,3],[33,1,33,3],[33,7,33,8],[34,1,34,3],[34,7,34,8],[35,1,35,3],[35,7,35,8],[36,1,36,3],[36,7,36,8],[37,1,37,3],[27,1,27,3],[27,7,27,8],[21,1,21,3],[22,1,22,3],[31,1,31,3],[31,7,31,8],[25,1,25,3],[25,7,25,8],[26,1,26,3],[26,7,26,8],[28,1,28,3],[29,1,29,3],[29,7,29,8],[30,1,30,3],[30,7,30,8],[23,1,23,3],[24,1,24,3],[24,7,24,8],[1,1,3,8],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[20,7,20,8],[21,7,21,8],[5,5,5,6],[5,7,5,8],[15,7,15,8],[16,7,16,8],[22,7,22,8],[6,7,6,8],[19,7,19,8],[16,1,16,3],[17,1,17,3],[19,1,19,3],[18,1,18,3],[6,5,6,6],[7,5,7,6],[8,5,8,6],[17,7,17,8],[11,7,11,8],[13,7,13,8],[7,7,7,8],[8,7,8,8],[10,7,10,8],[14,7,14,8],[20,1,20,3],[10,1,10,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4]]}
[]
[null,{"$f":"Scenario!H22 & \" Budget\"","v":"RoundUp Ready Canola Budget"}]
[]
[]
[]
[null,"Revenue",null,null,null,"units",null,"Canola"]
[null,"Canola production",null,null,null,"bu/acre",null,41]
[null,"Canola sale price",null,null,null,"$/bu",null,12]
[null,"Gross revenue",null,null,null,"$/acre",null,{"$f":"H8*H7","v":492}]
[]
[null,"Cash expenses for CANOLA production",null,null,null,"# of units","$/unit","$/acre"]
[null,"Canola seed, treatment & fees",null,null,"lb/acre",5,5.4,{"$f":"G12*F12","v":27}]
[]
[null,"Anhyrdous ammonia (82-0-0)",null,null,"lb/acre",36,0.43,{"$f":"G14*F14","v":15.48}]
[null,"Urea (46-0-0)",null,null,"lb/acre",106,0.89,94.34]
[null,"DAP (18-46-0)",null,null,"lb/acre",50,0.89,44.5]
[null,"Anhyrdous ammonia application",null,null,"per acre",1,12,12]
[null,"Fertilizer application",null,null,"per acre",2,4,8]
[]
[null,"Glyphosate",null,null,"oz/acre",44,0.11,{"$f":"G20*F20","v":4.84}]
[null,"AMS",null,null,"lb/acre",4,0.28999999999999998,1.1599999999999999]
[null,"Other herbicide",null,null,"per acre",null,null,0]
[null,"Herbicide application",null,null,"per acre",3,5,15]
[]
[null,"Warrior (1 out of 3 Falls)",null,null,"oz/acre",0.33,3.67,{"$f":"G25*F25","v":1.2111000000000001}]
[null,"Warrior Spring",null,null,"oz/acre",3,3.67,11.01]
[null,"Aerial application",null,null,"per acre",1.33,5,6.65]
[null,"Insecticide application",null,null,"per acre",null,null,0]
[]
[null,"Fungicide1",null,null,"per acre",null,null,{"$f":"G30*F30","v":0}]
[null,"Fungicide2",null,null,"pint/acre",null,null,0]
[null,"Fungicide application",null,null,"per acre",null,null,0]
[]
[null,"Canola crop insurance",null,null,"per acre",1,16,{"$f":"G34*F34","v":16}]
[null,"Fuel",null,null,"per gal",4.92,3.5,17.22]
[null,"Lube",null,null,"per acre",1,2.58,2.58]
[null,"Repair",null,null,"per acre",1,7.12,7.12]
[]
[null,"Canola custom harvest & hauling"]
[null,"Swathing or Pushing",null,null,"per acre",1,15,{"$f":"G40*F40","v":15}]
[null,"Combining base rate",null,null,"per acre",1,21,21]
[null,"Excess for > 20 bu/acre",null,null,"per bushel",{"$f":"IF(H7>20,H7-20,0)","v":21},0.21,4.41]
[null,"Hauling",null,null,"per bushel",{"$f":"H7","v":41},0.23,{"$f":"G43*F43","v":9.43}]
[]
[null,"Cash expense pre-harvest subtotal",null,null,"per acre","xxx","xxx",{"$f":"SUM(H12:I37)","v":284.11110000000002}]
[null,"Operating note interest rate",null,null,"%",7.0000000000000007E-2,"xxx",{"$f":"H45*F46/12*8/2","v":6.6292590000000011}]
[]
[null,"Total cash expense",null,null,"per acre","xxx","xxx",{"$f":"SUM(H12:I43)+H46","v":340.58035900000004}]
[null,"Net returns to land, fixed costs,\nlabor and management",null,null,"per acre","xxx","xxx",{"$f":"H9-H48","v":151.41964099999996}]

{"sheet":"Results","index":5,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[12,5,12,8],[12,9,12,12],[13,5,13,8],[13,9,13,12],[9,5,9,8],[9,9,9,12],[10,5,10,8],[10,9,10,12],[11,5,11,8],[11,9,11,12],[8,5,8,8],[8,9,8,12],[7,1,7,4],[8,1,8,4],[1,1,3,12],[5,5,5,8],[5,9,5,12],[5,1,5,4],[6,1,6,4],[6,5,6,8],[6,9,6,12],[7,5,7,8],[7,9,7,12]]}
[]
[null,{"$f":"\"Results \" & IF(Scenario!B15<>\"Enter scenario description\", \"for \" & Scenario!B15,\"\")","v":"Results "}]
[]
[]
[]
[null,"Revenues",null,null,null,{"$f":"Scenario!B22 &\n\" continuous wheat\"","v":"Dual-purpose continuous wheat"},null,null,null,{"$f":"Scenario!B22 & \" Wheat-Wheat-\" & Scenario!H22","v":"Dual-purpose Wheat-Wheat-RoundUp Ready Canola"}]
[null,{"$f":"\"Wheat\" & IF(Scenario!B22=\"Dual-purpose\", \" + grazing\",\"\")","v":"Wheat + grazing"},null,null,null,{"$f":"IF(Scenario!$B$22=\"Grain-only\",Grain!G12,'Dual purpose'!G13)","v":288.44749999999999},null,null,null,{"$f":"IF(Scenario!$B$22=\"Grain-only\",Grain!J12,'Dual purpose'!J13)","v":306.44749999999999}]
[null,"Canola",null,null,null,null,null,null,null,{"$f":"Canola!H9","v":492}]
[null,"Total revenue (weighted avg)",null,null,null,{"$f":"F7","v":288.44749999999999},null,null,null,{"$f":"J8/3+J7*2/3","v":368.29833333333329}]
[null,"Cash expenses"]
[null,"Wheat",null,null,null,{"$f":"IF(Scenario!$B$22=\"Grain-only\",Grain!H49,'Dual purpose'!H50)","v":230.30307333333332},null,null,null,{"$f":"IF(Scenario!$B$22=\"Grain-only\",Grain!K49,'Dual purpose'!K50)","v":243.46304000000006}]
[null,"Canola",null,null,null,null,null,null,null,{"$f":"Canola!H48","v":340.58035900000004}]
[null,"Total expenses (weighted avg)",null,null,null,{"$f":"F11","v":230.30307333333332},null,null,null,{"$f":"J12/3+J11*2/3","v":275.83547966666674}]
[null,"Net returns to land,  fixed costs, labor and management",null,null,null,{"$f":"F9-F13","v":58.144426666666675},null,null,null,{"$f":"J9-J13","v":92.462853666666547}]

{"sheet":"More info","index":6,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,1,4,9],[6,1,7,9],[25,1,25,9],[26,2,26,4],[26,6,26,8],[21,1,21,9],[23,1,23,9],[9,1,9,9],[11,1,11,9],[13,1,13,9],[15,1,15,9],[17,1,17,9],[19,1,19,9]]}
[]
[null,"This program is joint product of the Oklahoma Cooperative Extension Service and the Oklahoma Agricultural Experiment Station, Oklahoma State University, Stillwater, OK."]
[]
[]
[]
[]
[null,"More information on canola can be found at the links below."]
[]
[]
[null,"OSU Okanola website"]
[]
[null,"OSU Division of Agricultural Sciences and Natural Resources"]
[]
[null,"Oklahoma Cooperative Extension Service"]
[]
[null,"Oklahoma Agricultural Experiment Station"]
[]
[null,"Find your local OCES office"]
[]
[null,"OCES factsheets"]
[]
[null,"OSU Department of Agricultural Economics"]
[]
[null,"OSU Department of Plant and Soil Sciences"]
[]
[null,"For questions on this program, contact Eric A. DeVuyst."]
[null,null,"405-744-6166",null,null,null,"eric.devuyst@okstate.edu"]