{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Main","Useful links"],"not_rendered":{"charts":0,"images":4,"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":"Main","index":0,"n_rows":54,"n_cols":14,"rows_kept":54,"cut":false,"hidden":false,"merged":[[37,10,37,11],[18,11,18,12],[39,1,39,4],[39,10,39,11],[39,12,39,13],[16,6,16,8],[15,1,15,3],[16,1,16,3],[28,10,28,11],[28,12,28,13],[29,10,29,11],[29,12,29,13],[30,10,30,11],[30,12,30,13],[36,10,36,11],[36,12,36,13],[32,10,32,11],[32,12,32,13],[37,1,37,4],[36,5,36,6],[37,5,37,6],[33,10,33,11],[33,12,33,13],[34,10,34,11],[34,12,34,13],[1,1,8,13],[25,10,25,11],[25,12,25,13],[27,12,27,13],[27,10,27,11],[25,8,25,9],[26,10,26,11],[26,12,26,13],[10,1,10,3],[10,4,10,5],[11,1,11,3],[11,4,11,5],[12,4,12,5],[15,4,15,5],[17,1,17,3],[18,1,18,3],[16,4,16,5],[17,4,17,5],[18,4,18,5],[27,5,27,6],[15,6,15,7],[12,7,12,12],[20,4,20,5],[21,4,21,5],[51,2,51,3],[52,2,52,3],[10,7,10,12],[11,7,11,12],[41,1,41,13],[44,5,44,13],[9,1,9,5],[27,1,27,4],[36,1,36,4],[9,11,9,13],[25,1,25,4],[25,5,25,6],[20,10,20,11],[20,12,20,13],[21,10,21,11],[21,12,21,13],[22,10,22,11],[22,12,22,13],[21,6,21,7],[22,6,22,7],[23,6,23,7],[20,8,20,9],[20,1,20,3],[21,1,21,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[22,1,22,3],[23,1,23,3],[32,1,32,4],[33,1,33,4],[28,1,28,4],[29,1,29,4],[30,1,30,4],[34,1,34,4],[15,9,15,10],[15,11,15,12],[16,9,16,10],[17,9,17,10],[18,9,18,10],[16,11,16,12],[17,11,17,12],[23,10,23,11],[42,1,43,13],[22,4,22,5],[23,4,23,5],[17,6,17,8],[18,6,18,8],[23,8,23,9],[37,12,37,13],[32,5,32,6],[33,5,33,6],[34,5,34,6],[29,5,29,6],[30,5,30,6],[28,5,28,6],[23,12,23,13],[22,8,22,9],[21,8,21,9]]}
[]
[null,"The Economic Cost of a Bale of Hay\nEric A. DeVuyst and Roger Sahs\nDepartment of Agricultural Economics\nOklahoma State University\nStillwater, Oklahoma"]
[]
[]
[]
[]
[]
[]
[]
[null,"Hay yield and nutrient information",null,null,null,null,null,null,null,null,null,"Version 1.0  11-Sep-2024"]
[null,"Yield (tons/acre)",null,null,1.1000000000000001,null,null,"Cells with YELLOW background are user entered."]
[null,"Bale weight (lb)",null,null,1400,null,null,"Cells with GREY background are calculated."]
[null,"Bales per acre",null,null,1.6,null,null,"Cells with ORANGE background are display fields."]
[]
[null,"Nutrient content of hay"]
[null,"Percent protein",null,null,7.0000000000000007E-2,null,null,null,null,"Per ton",null,"Per bale"]
[null,"Percent nitrogen",null,null,1.12E-2,null,"Pounds of nitrogen",null,null,22.4,null,15.7]
[null,"Percent phosporous",null,null,1.8E-3,null,"Pounds of phosphorous",null,null,3.6,null,2.5]
[null,"Percent potassium",null,null,1.5E-3,null,"Pounds of potassium",null,null,3,null,2.1]
[]
[null,"Fertilizer",null,null,"$/ton",null,null,null,"Implied price $/lb",null,"$ per ton",null,"$ per bale"]
[null,"46-0-0",null,null,525,null,"Nitrogen",null,0.56999999999999995]
[null,"18-46-0",null,null,810,null,"Phosphorous",null,1.79,null,6.44,null,{"$f":"I23*L18","v":4.4749999999999996}]
[null,"0-0-60",null,null,515,null,"Potassium",null,0.52,null,1.56,null,{"$f":"I24*L19","v":1.0920000000000001}]
[]
[null,"Actual N applied (lb/acre)",null,null,null,0,null,null,"Nitrogen cost",null,0,null,0]
[]
[null,"Pesticides",null,null,null,"$/acre"]
[null,"Herbicide cost",null,null,null,0,null,null,null,null,0,null,0]
[null,"Insecticide cost",null,null,null,0,null,null,null,null,0,null,0]
[null,"Other pesticide cost",null,null,null,0,null,null,null,null,0,null,0]
[]
[null,"Harvest and post Harvest",null,null,null,"$/bale"]
[null,"Swathing, raking, and baling",null,null,null,28,null,null,null,null,40,null,28]
[null,"Stacking, loading, hauling",null,null,null,5,null,null,null,null,7.14,null,5]
[]
[null,"Land",null,null,null,"$/acre"]
[null,"Land rental charge",null,null,null,20,null,null,null,null,18.18,null,12.5]
[]
[null,"TOTAL ECONOMIC COST",null,null,null,null,null,null,null,null,{"$f":"SUM(K23:L38)","v":73.319999999999993},null,51.07]
[]
[null,"Total Economic Cost Sensitivity Analysis"]
[null,"Economic cost of a baling hay in $/bale and $/ton"]
[]
[null,null,null,null,null,"Bale Weight (lb)"]
[null,null,"Yield (tons/acre)",null,null,1120,1190,1260,1330,1400,1470,1540,1610,1680]
[null,null,0.8,null,"$/bale\n$/ton","$51\n$92","$53\n$88","$54\n$85","$55\n$83","$56\n$80","$57\n$78","$58\n$76","$60\n$74","$61\n$72"]
[null,null,0.9,null,"$/bale\n$/ton","$50\n$89","$51\n$86","$52\n$83","$53\n$80","$54\n$77","$55\n$75","$56\n$73","$57\n$71","$58\n$70"]
[null,null,1,null,"$/bale\n$/ton","$49\n$87","$50\n$83","$51\n$80","$52\n$78","$53\n$75","$54\n$73","$55\n$71","$56\n$69","$57\n$67"]
[null,null,1.1000000238418579,null,"$/bale\n$/ton","$48\n$85","$49\n$82","$49\n$79","$50\n$76","$51\n$73","$52\n$71","$53\n$69","$54\n$67","$55\n$65"]
[null,null,1.2,null,"$/bale\n$/ton","$47\n$84","$48\n$80","$49\n$77","$49\n$74","$50\n$72","$51\n$70","$52\n$68","$53\n$66","$54\n$64"]
[null,null,1.3,null,"$/bale\n$/ton","$46\n$82","$47\n$79","$48\n$76","$49\n$73","$49\n$71","$50\n$68","$51\n$66","$52\n$64","$53\n$63"]
[null,null,1.4,null,"$/bale\n$/ton","$45\n$81","$46\n$78","$47\n$75","$48\n$72","$49\n$69","$49\n$67","$50\n$65","$51\n$63","$52\n$62"]
[null,null,1.4,1.4,null,"5.04\n8","5.32\n8","5.6\n8","5.88\n8","5.6\n8","5.32\n8","5.6\n8"]

{"sheet":"Useful links","index":1,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
["Native Hay Meadow Management | Oklahoma State University (okstate.edu)"]
["Fertilizing Bermudagrass Hay and Pasture | Oklahoma State University (okstate.edu)"]
["Collecting Forage Samples for Analysis | Oklahoma State University (okstate.edu)"]
["Managing Bermudagrass Pasture to Reduce Winter Hay Feeding in Beef Cattle Operations | Oklahoma State University (okstate.edu)"]
["Bermudagrass Pasture Management | Oklahoma State University (okstate.edu)"]
["Oklahoma Forage and Pasture Fertility Guide | Oklahoma State University (okstate.edu)"]
["Oklahoma Farm and Ranch Custom Rates, 2021‑2022 | Oklahoma State University (okstate.edu)"]
["Soil, Water and Forage Analytical Laboratory | Oklahoma State University (okstate.edu)"]
["Extension | Oklahoma State University (okstate.edu)"]
["Ag Research | Oklahoma State University (okstate.edu)"]
["Agricultural Economics | Oklahoma State University (okstate.edu)"]