{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["BaleInventory","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":"BaleInventory","index":0,"n_rows":48,"n_cols":6,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["BEEF CATTLE HAY INVENTORY FOR WINTER FEEDING"]
[]
[null,null,"Indicates Input Needed"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"HAY INVENTORY PARAMETERS"]
[null,"Livestock Class and Number"]
[null," Select Cattle Class",0]
[null,"Average Weight (lbs)",0]
[null,"Daily Dry Matter Intake (% Body Weight)",{"$f":"IF(F24=0,0,120/F24)","v":0}]
[null,"Feeding Period (days)",0,null,"Forage Analysis","Percent Dry Matter"]
[null,"Hay Needed (tons dry matter)",{"$f":"IF(C19, ((C17*C18*(C19/100)*C20)/2000), 0)","v":0},null,"Dry Matter (DM)",0]
[null,"Hay Dry Matter Concentration (%)",{"$f":"F21","v":0},null,"Crude Protein (CP)",0]
[null,"Hay Needed As-fed (tons)",{"$f":"IF(C22, ((C21/(C22/100))), 0)","v":0},null,"Acid Detergent Fiber (ADF)",0]
[null,"Bale Size and Average Weight (lbs)",null,null,"Neutral Detergent Fiber (NDF)",0]
[null," Select Bale Size",0,null,"Total Digestible Nutrients (TDN)",0]
[null,"Number of Bales Needed",{"$f":"IF(C25, (C23/(C25/2000)), 0)","v":0}]
[]
[null,"FEEDING LOSSES"]
[null,"Hay Feeding Waste (%)",0]
[null,"Number of Extra Dales Needed",{"$f":"(C26*(C29/100))","v":0},null,"Estimated Feed Losses","Percent"]
[null,null,null,null,"Cone","0 - 4"]
[null,"EMERGENCY/SURPLUS HAY ALLOCATION",null,null,"Craddle","5 -15"]
[null,"Percent of Emergency/Surplus Hay",0,null,"Ground","0 - 28"]
[null,"Number of Extra Bales Needed",{"$f":"IF(C33=0, 0, ((C33/100)*C26))","v":0},null,"Ring ","0 - 6"]
[null,null,null,null,"Trailer","5 - 11"]
[null,"TOTAL BALES NEEDED",{"$f":"C26+C30+C34","v":0},null,"Trough","8 - 20"]
[null,"TOTAL TONS OF HAY",{"$f":"(C25*C36)/2000","v":0}]
[]
[null,"ECONOMIC COST OF HAY"]
[null,"Cost Per Bale ($)",0]
[null,"Cost Per Ton ($)",{"$f":"IF(C25 = 0, 0, (C40*(2000/C25)))","v":0}]
[null,"Total Hay Cost ($)",{"$f":"C36*C40","v":0}]
[]
[null,"ECONOMIC COST OF NUTRIENTS"]
[null,"Crude Protein Content (lb/ton of Hay)",{"$f":"(2000*(F22/100))","v":0}]
[null,"Cost of Protein ($/lb)",{"$f":"IF(C45=0,0, C41/C45)","v":0}]
[null,"Total Digestible Nutritent Content (lb/ton of Hay)",{"$f":"(2000*(F25/100))","v":0}]
[null,"Cost of Total Digestible Nutrients ($/lb)",{"$f":"IF(C47=0,0,C41/C47)","v":0}]

{"sheet":"Info","index":1,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"DM INTAKE",null,"Bale "]
[null,null,"Select Intake",null,"Select Bale Size",null,null,"Emergency"]
[null,null,0,null,"4' x 4'",null,null,5]
[null,null,1.1000000000000001,null,"4' x 5'",null,null,10]
[null,null,1.2,null,"4 x 6'",null,null,15]
[null,null,1.3,null,"5' x 5'",null,null,20]
[null,null,1.4,null,"5' x 6'",null,null,25]
[null,null,1.5,null,null,null,null,30]
[null,null,1.6,null,null,null,null,35]
[null,null,1.7,null,null,null,null,40]
[null,null,1.8]
[null,null,1.9]
[null,null,2]
[null,null,2.1]
[null,null,2.2000000000000002]
[null,null,2.2999999999999998]
[null,null,2.4]
[null,null,2.5]
[null,null,2.6]
[null,null,2.7]
[null,null,2.8]
[null,null,2.9]
[null,null,3]
[null,null,3.1]
[null,null,3.2]
[null,null,3.3]
[null,null,3.4]
[null,null,3.5]
[]
[]
[]
[]
[null,null,"Livestock"]
[null,null,"Select Cattle Class"]
[null,null,"Bull"]
[null,null,"Cow (Dry)"]
[null,null,"Cow (Lactating)"]
[null,null,"Heifers (Replacement)"]
[null,null,"Stocker (Steers)"]
[null,null,"Stocker (Feeder Heifers)"]