{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Overwinter","Winter Feed Rations (HIDE)"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":23,"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":"Overwinter","index":0,"n_rows":121,"n_cols":21,"rows_kept":121,"cut":false,"hidden":false,"merged":[[2,10,2,11],[64,6,64,7],[117,0,118,11],[109,0,109,11],[58,2,58,4],[17,2,17,6],[38,2,38,6],[39,6,39,7],[18,6,18,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HIDE","HIDE","HIDE"]
[". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ."]
["Beef Cow Overwinter Cost Calculator",null,null,null,null,null,null,null,null,"Printed:",{"$f":"TODAY()","v":"2024-10-02"}]
[null,null,"*** Enter changes to BLUE values only ***"]
["Input Data:"]
[null,"Number of cows to be wintered",300]
[null,"Average weight of cows",1350]
[null,"Number of bulls to be wintered",0]
[null,"Days winter feeding (pre calving)",135,null,"Operating Interest",null,7.4999999999999997E-2]
[null,"Days winter feeding (post calving)",60,null,"Investment Rate  ",null,4.7500000000000001E-2]
[null,"Total Feeding Days",{"$f":"SUM(C9:C10)","v":195}]
[null,"Number of days in extended grazing",0]
[]
["For more information on production costs, "]
[]
["A. Operating Costs:"]
["1. Feed Costs Per Cow - Pre Calving"]
[null,"Select Base Ration - ","#3 - Corn Silage, Straw & Supplement",null,null,null,null,null,{"$f":"C9","v":135},"Days"]
[null,"Feed Type","$/unit","lbs/ unit","$/lb","lbs/ cow/ day","Total\nFeed Required",null,null,"Total Cost",null,"$/cow/day",null,null,null,null,null,null,1400,{"$f":"$C$7","v":1350},"*reset copy*"]
[null,"Alfalfa Hay",155,2000,{"$f":"SUM(C20/D20)","v":7.7499999999999999E-2},{"$f":"T20","v":0},{"$f":"SUM($C$9*F20*$C$6)/D20","v":0},null,null,{"$f":"G20*C20","v":0},null,{"$f":"SUM(J20/$C$6)/$C$9","v":0},null,null,null,null,null,null,{"$f":"HLOOKUP($C$18,'Winter Feed Rations (HIDE)'!$E$8:$L$25,4,FALSE)","v":0},{"$f":"SUM(($C$7/1400)*S20)","v":0},{"$f":"AI20","v":0}]
[null,"Alfalfa Grass Hay",115,2000,{"$f":"SUM(C21/D21)","v":5.7500000000000002E-2},{"$f":"T21","v":0},0,null,null,0,null,{"$f":"SUM(J21/$C$6)/$C$9","v":0},null,null,null,null,null,null,{"$f":"HLOOKUP($C$18,'Winter Feed Rations (HIDE)'!$E$8:$L$25,5,FALSE)","v":0},0,{"$f":"AI21","v":0}]
[null,"Grass Hay",95,2000,{"$f":"SUM(C22/D22)","v":4.7500000000000001E-2},0,0,null,null,0,null,0,null,null,null,null,null,null,{"$f":"HLOOKUP($C$18,'Winter Feed Rations (HIDE)'!$E$8:$L$25,6,FALSE)","v":0},0,0]
[null,"Barley Straw",70,2000,3.5000000000000003E-2,18.321428571428573,371.00892857142856,null,null,25970.625,null,0.64124999999999999,null,null,null,null,null,null,{"$f":"HLOOKUP($C$18,'Winter Feed Rations (HIDE)'!$E$8:$L$25,7,FALSE)","v":19},18.321428571428573,0]
[null,"Barley Greenfeed",115,2000,5.7500000000000002E-2,0,0,null,null,0,null,0,null,null,null,null,null,null,{"$f":"HLOOKUP($C$18,'Winter Feed Rations (HIDE)'!$E$8:$L$25,8,FALSE)","v":0},0,0]
[null,"Corn Silage",40,2000,0.02,45.321428571428569,917.75892857142856,null,null,36710.357142857145,null,0.90642857142857147,null,null,null,null,null,null,{"$f":"HLOOKUP($C$18,'Winter Feed Rations (HIDE)'!$E$8:$L$25,9,FALSE)","v":47},45.321428571428569,0]
[null,"Barley Silage",50,2000,2.5000000000000001E-2,0,0,null,null,0,null,0,null,null,null,null,null,null,{"$f":"HLOOKUP($C$18,'Winter Feed Rations (HIDE)'!$E$8:$L$25,10,FALSE)","v":0},0,0]
[null,"Barley Grain",4.5,48,9.375E-2,0,0,null,null,0,null,0,null,null,null,null,null,null,{"$f":"HLOOKUP($C$18,'Winter Feed Rations (HIDE)'!$E$8:$L$25,11,FALSE)","v":0},0,0]
[null,"32% Feedlot Suppl.",550,2205,0.24943310657596371,0.48214285714285715,8.8556851311953366,null,null,4870.6268221574355,null,0.12026239067055397,null,null,null,null,null,null,{"$f":"HLOOKUP($C$18,'Winter Feed Rations (HIDE)'!$E$8:$L$25,12,FALSE)","v":0.5},0.48214285714285715,0]
[null,"32% Liquid Suppl.",475,2205,0.21541950113378686,0,0,null,null,0,null,0,null,null,null,null,null,null,{"$f":"HLOOKUP($C$18,'Winter Feed Rations (HIDE)'!$E$8:$L$25,13,FALSE)","v":0},0,0]
[null,"20% Grain Pellets",300,2205,0.1360544217687075,0,0,null,null,0,null,0,null,null,null,null,null,null,{"$f":"HLOOKUP($C$18,'Winter Feed Rations (HIDE)'!$E$8:$L$25,14,FALSE)","v":0},0,0]
[null,"(enter other feed here)",0,2205,{"$f":"SUM(C31/D31)","v":0},0,0,null,null,0,null,{"$f":"SUM(J31/$C$6)/$C$9","v":0},null,null,null,null,null,null,null,null,0]
[null,"(enter other feed here)",0,2205,{"$f":"SUM(C32/D32)","v":0},0,0,null,null,0,null,{"$f":"SUM(J32/$C$6)/$C$9","v":0},null,null,null,null,null,null,null,null,0]
[null,"1:1 Mineral",50,55,0.90909090909090906,0,0,null,null,0,null,0,null,null,null,null,null,null,{"$f":"HLOOKUP($C$18,'Winter Feed Rations (HIDE)'!$E$8:$L$25,15,FALSE)","v":0},{"$f":"SUM(($C$7/1400)*S33)","v":0},0]
[null,"2:1 Mineral",50,55,0.90909090909090906,5.7857142857142857E-2,42.603896103896105,null,null,2130.1948051948052,null,5.2597402597402601E-2,null,null,null,null,null,null,{"$f":"HLOOKUP($C$18,'Winter Feed Rations (HIDE)'!$E$8:$L$25,16,FALSE)","v":0.06},{"$f":"SUM(($C$7/1400)*S34)","v":5.7857142857142857E-2},0]
[null,"Limestone",20,55,0.36363636363636365,0,0,null,null,0,null,0,null,null,null,null,null,null,{"$f":"HLOOKUP($C$18,'Winter Feed Rations (HIDE)'!$E$8:$L$25,17,FALSE)","v":0},{"$f":"SUM(($C$7/1400)*S35)","v":0},0]
[null,"Blue Salt",10,55,0.18181818181818182,6.7500000000000004E-2,49.704545454545453,null,null,497.0454545454545,null,1.2272727272727272E-2,null,null,null,null,null,null,{"$f":"HLOOKUP($C$18,'Winter Feed Rations (HIDE)'!$E$8:$L$25,18,FALSE)","v":7.0000000000000007E-2},{"$f":"SUM(($C$7/1400)*S36)","v":6.7500000000000004E-2},0]
[null,null,null,null,null,{"$f":"SUM(F20:F36)","v":64.250357142857141},null,null,null,{"$f":"SUM(J20:J36)","v":70178.849224754827},null,1.732811091969255]
["2. Feed Costs Per Cow - Post Calving"]
[null,"Select Base Ration - ","#3 - Corn Silage, Straw, Grain & Supplement",null,null,null,null,null,{"$f":"C10","v":60},"Days"]
[null,"Feed Type","$/unit","lbs/ unit","$/lb","lbs/ cow/ day","Total\nFeed Required",null,null,"Total Cost",null,"$/cow/day",null,null,null,null,null,null,1400,{"$f":"$C$7","v":1350},"*reset copy*"]
[null,"Alfalfa Hay",{"$f":"C20","v":155},{"$f":"D20","v":2000},{"$f":"SUM(C41/D41)","v":7.7499999999999999E-2},{"$f":"T41","v":0},{"$f":"SUM($C$10*F41*$C$6)/D41","v":0},null,null,{"$f":"G41*C41","v":0},null,{"$f":"SUM(J41/$C$6)/$C$10","v":0},null,null,null,null,null,null,{"$f":"HLOOKUP($C$39,'Winter Feed Rations (HIDE)'!$E$29:$L$45,3,FALSE)","v":0},{"$f":"SUM(($C$7/1400)*S41)","v":0},{"$f":"AI41","v":0}]
[null,"Alfalfa Grass Hay",{"$f":"C21","v":115},2000,{"$f":"SUM(C42/D42)","v":5.7500000000000002E-2},{"$f":"T42","v":0},{"$f":"SUM($C$10*F42*$C$6)/D42","v":0},null,null,0,null,{"$f":"SUM(J42/$C$6)/$C$10","v":0},null,null,null,null,null,null,{"$f":"HLOOKUP($C$39,'Winter Feed Rations (HIDE)'!$E$29:$L$45,4,FALSE)","v":0},0,{"$f":"AI42","v":0}]
[null,"Grass Hay",{"$f":"C22","v":95},2000,{"$f":"SUM(C43/D43)","v":4.7500000000000001E-2},0,0,null,null,0,null,0,null,null,null,null,null,null,{"$f":"HLOOKUP($C$39,'Winter Feed Rations (HIDE)'!$E$29:$L$45,5,FALSE)","v":0},0,0]
[null,"Barley Straw",{"$f":"C23","v":70},2000,3.5000000000000003E-2,11.571428571428571,104.14285714285712,null,null,7289.9999999999991,null,0.40499999999999997,null,null,null,null,null,null,{"$f":"HLOOKUP($C$39,'Winter Feed Rations (HIDE)'!$E$29:$L$45,6,FALSE)","v":12},11.571428571428571,0]
[null,"Barley Greenfeed",{"$f":"C24","v":115},2000,5.7500000000000002E-2,0,0,null,null,0,null,0,null,null,null,null,null,null,{"$f":"HLOOKUP($C$39,'Winter Feed Rations (HIDE)'!$E$29:$L$45,7,FALSE)","v":0},0,0]
[null,"Corn Silage",{"$f":"C25","v":40},2000,0.02,46.285714285714285,416.5714285714285,null,null,16662.857142857141,null,0.9257142857142856,null,null,null,null,null,null,{"$f":"HLOOKUP($C$39,'Winter Feed Rations (HIDE)'!$E$29:$L$45,8,FALSE)","v":48},46.285714285714285,0]
[null,"Barley Silage",{"$f":"C26","v":50},2000,2.5000000000000001E-2,0,0,null,null,0,null,0,null,null,null,null,null,null,{"$f":"HLOOKUP($C$39,'Winter Feed Rations (HIDE)'!$E$29:$L$45,9,FALSE)","v":0},0,0]
[null,"Barley Grain",{"$f":"C27","v":4.5},48,9.375E-2,6.75,2531.25,null,null,11390.625,null,0.6328125,null,null,null,null,null,null,{"$f":"HLOOKUP($C$39,'Winter Feed Rations (HIDE)'!$E$29:$L$45,10,FALSE)","v":7},6.75,0]
[null,"32% Feedlot Suppl.",{"$f":"C28","v":550},2205,0.24943310657596371,1.9285714285714286,15.743440233236154,null,null,8658.8921282798838,null,0.48104956268221577,null,null,null,null,null,null,{"$f":"HLOOKUP($C$39,'Winter Feed Rations (HIDE)'!$E$29:$L$45,11,FALSE)","v":2},1.9285714285714286,0]
[null,"32% Liquid Suppl.",{"$f":"C29","v":475},2205,0.21541950113378686,0,0,null,null,0,null,0,null,null,null,null,null,null,{"$f":"HLOOKUP($C$39,'Winter Feed Rations (HIDE)'!$E$29:$L$45,12,FALSE)","v":0},0,0]
[null,"20% Grain Pellets",{"$f":"C30","v":300},2205,0.1360544217687075,0,0,null,null,0,null,0,null,null,null,null,null,null,{"$f":"HLOOKUP($C$39,'Winter Feed Rations (HIDE)'!$E$29:$L$45,13,FALSE)","v":0},0,0]
[null,"(enter other feed here)",0,2205,0,0,{"$f":"SUM($C$9*F52*$C$6)/D52","v":0},null,null,0,null,{"$f":"SUM(J52/$C$6)/$C$9","v":0},null,null,null,null,null,null,null,null,0]
[null,"(enter other feed here)",0,2205,0,0,{"$f":"SUM($C$9*F53*$C$6)/D53","v":0},null,null,0,null,0,null,null,null,null,null,null,null,null,0]
[null,"1:1 Mineral",{"$f":"C33","v":50},55,0.90909090909090906,0,0,null,null,0,null,0,null,null,null,null,null,null,{"$f":"HLOOKUP($C$39,'Winter Feed Rations (HIDE)'!$E$29:$L$45,14,FALSE)","v":0},{"$f":"SUM(($C$7/1400)*S54)","v":0},0]
[null,"2:1 Mineral",{"$f":"C34","v":50},55,0.90909090909090906,0.17357142857142857,56.805194805194802,null,null,2840.2597402597403,null,0.15779220779220779,null,null,null,null,null,null,{"$f":"HLOOKUP($C$39,'Winter Feed Rations (HIDE)'!$E$29:$L$45,15,FALSE)","v":0.18},{"$f":"SUM(($C$7/1400)*S55)","v":0.17357142857142857},0]
[null,"Limestone",{"$f":"C35","v":20},55,0.36363636363636365,9.6428571428571433E-2,31.558441558441558,null,null,631.16883116883116,null,3.5064935064935063E-2,null,null,null,null,null,null,{"$f":"HLOOKUP($C$39,'Winter Feed Rations (HIDE)'!$E$29:$L$45,16,FALSE)","v":0.1},{"$f":"SUM(($C$7/1400)*S56)","v":9.6428571428571433E-2},0]
[null,"Blue Salt",{"$f":"C36","v":10},55,0.18181818181818182,9.6428571428571433E-2,31.558441558441558,null,null,315.58441558441558,null,1.7532467532467531E-2,null,null,null,null,null,null,{"$f":"HLOOKUP($C$39,'Winter Feed Rations (HIDE)'!$E$29:$L$45,17,FALSE)","v":0.1},{"$f":"SUM(($C$7/1400)*S57)","v":9.6428571428571433E-2},0]
[null,null,null,null,null,{"$f":"SUM(F41:F57)","v":66.902142857142877},null,null,null,{"$f":"SUM(J41:J57)","v":47789.387258150018},null,{"$f":"SUM(J58/$C$6)/$C$10","v":2.6549659587861121}]
[]
[null,"Total Feed per Cow",null,null,null,null,null,null,null,{"$f":"SUM(J58+J37)","v":117968.23648290485},null,{"$f":"SUM((J60/$C$6)/($C$9+$C$10))","v":2.0165510509898263}]
[null,"Bedding (straw)",70,"/ton*",null,null,{"$f":"C6","v":300},"tons",null,{"$f":"ROUND(G61*C61,0)","v":21000},null,{"$f":"SUM((J61/$C$6)/($C$9+$C$10))","v":0.35897435897435898}]
[null,{"$f":"\"Total Feed Cost & Bedding (for Cows) - based on \"&C9+C10&\" days\"","v":"Total Feed Cost & Bedding (for Cows) - based on 195 days"},null,null,null,null,null,null,null,{"$f":"SUM(J60:J61)","v":138968.23648290485},null,{"$f":"SUM((J62/$C$6)/($C$9+$C$10))","v":2.3755254099641854}]
[]
["3. Feed Costs For Breeding Bulls:"]
[null,"Item","$/unit",null,"lbs/hd/day","Days","Feed Required",null,null,"Total Cost",null,"$/cow/day"]
[null,"Ground Barley",4.5,"/bus",7,120,{"$f":"(E66/48)*F66*C8","v":0},"bus",null,{"$f":"ROUND(G66*C66,0)","v":0},null,{"$f":"SUM((J66/$C$6)/($C$9+$C$10))","v":0}]
[null,"Good quality hay",115,"/ton*",41,{"$f":"$C$9+$C$10","v":195},{"$f":"ROUND((E67/2000)*C11*C8,0)","v":0},"tons*",null,{"$f":"ROUND(G67*C67,0)","v":0},null,0]
[null,"Total Feed per Bull",null,null,{"$f":"SUM(E66:E67)","v":48},null,null,null,null,{"$f":"SUM(J66:J67)","v":0},null,0]
[null,"Bedding (straw)",70,"/ton*",null,null,{"$f":"C8","v":0},"tons*",null,{"$f":"ROUND(G69*C69,0)","v":0},null,0]
[null,{"$f":"\"Total Feed & Bedding (for Breeding Bulls) per cow per day based on \"&C9+C10&\" days\"","v":"Total Feed & Bedding (for Breeding Bulls) per cow per day based on 195 days"},null,null,null,null,null,null,null,{"$f":"SUM(J68:J69)","v":0},null,0]
[]
[null,"Total All Feed & Bedding for Cows and Bulls",null,null,null,null,null,null,null,{"$f":"J62+J70","v":138968.23648290485},null,2.3755254099641854]
[]
["4. Extended Grazing Costs:",null,"$/cow/yr",null,null,"Days",null,null,null,"Total Cost",null,"$/cow/day"]
[null,"Extended grazing",41.65,null,null,{"$f":"C12","v":0},null,null,null,{"$f":"IF(F75<1,0,ROUND(C75*C6,0))","v":0},null,{"$f":"IF(F75<1,0,SUM(C75/F75))","v":0}]
[]
["5. Other Operating Costs:",null,"$/cow/yr",null,null,null,null,null,null,"Total Cost",null,"$/cow/day"]
[null,"Veterinary Medicine & Supplies: ",0,null,null,null,null,null,null,{"$f":"ROUND(C78*C6,0)","v":0},null,{"$f":"SUM(J78/$C$6)/($C$9+$C$10+$C$12)","v":0}]
[null,"Specialized Vet Services",null,null,null,null,null,null,null,0,null,0]
[null,"Utilities",null,null,null,null,null,null,null,2906.6322,null,4.9686020512820513E-2]
[null,"Equipment fuel & repairs",null,null,null,null,null,null,null,7994.63,null,0.13666034188034187]
[null,"Building and fences repair",null,null,null,null,null,null,null,2237.6200000000003,null,3.8249914529914539E-2]
[null,"Building and equipment insurance",null,null,null,null,null,null,null,1355.9999999999998,null,2.3179487179487177E-2]
[null,"Manure Removal",null,null,null,null,null,null,null,3251.8906874999998,null,5.5587874999999995E-2]
[" ","Miscellaneous",null,null,null,null,null,null,null,1000,null,1.7094017094017096E-2]
[null,"Total Other Operating Costs",null,null,null,null,null,null,null,{"$f":"ROUND(SUM(J78:J85),0)","v":18747},null,0.32046153846153846]
[]
["Subtotal Operating Costs",null,null,null,null,null,null,null,null,{"$f":"ROUND(J62+J70+J86+J75,0)","v":157715},null,{"$f":"SUM(J88/$C$6)/($C$9+$C$10+$C$12)","v":2.6959829059829064}]
[null,"Operating Interest",null,null,null,null,null,null,null,{"$f":"ROUND((J88/2)*G9,0)","v":5914},null,{"$f":"SUM(J89/$C$6)/($C$9+$C$10+$C$12)","v":0.10109401709401711}]
["Total Operating Costs for Winter Period",null,null,null,null,null,null,null,null,{"$f":"ROUND(J88+J89,0)","v":163629},null,{"$f":"SUM(J90/$C$6)/($C$9+$C$10+$C$12)","v":2.797076923076923}]
[]
["B. Fixed Costs:"]
[null,null,"Facilities",null,"Equipment"]
[null,"Original Value",101710,null,237500]
[null,"Salvage Value",20342,null,47500]
[null,"Useful Life ",20,"yrs",10,"yrs"]
[null,"Investment Rate",{"$f":"G10","v":4.7500000000000001E-2},null,{"$f":"G10","v":4.7500000000000001E-2},null,null,null,null,"Total Cost",null,"$/cow/day"]
["Total Fixed Costs",null,{"$f":"IF(C96=0,0,(((C94-C95)/C96)+((C94+C95)/2)*C97)/C6)","v":23.223783333333333},null,{"$f":"IF(E96=0,0,(((E94-E95)/E96)+((E94+E95)/2)*E97)/C6)","v":85.895833333333329},null,null,null,null,{"$f":"ROUND((C98+E98)*C6,0)","v":32736},null,{"$f":"SUM(J98/$C$6)/($C$9+$C$10+$C$12)","v":0.55958974358974356}]
[]
["C. Labour Costs:"]
[null,null,null,null,null,null,null,null,null,"Total Cost",null,"$/cow/day"]
[null,"Feeding, bedding",5,"hr/cow",27,"/hr",{"$f":"\"(\"&TEXT(((C102*C6)/((C9+C12)/7)),\"#.#\")&\" hrs per week)\"","v":"(77.8 hrs per week)"},null,null,{"$f":"SUM(C102*E102*C6)","v":40500},null,{"$f":"SUM(J102/$C$6)/($C$9+$C$10+$C$12)","v":0.69230769230769229}]
[null,"Optional Calving Management Fee",null,null,0,"/cow",null,null,null,{"$f":"SUM(E103*C6)","v":0},null,{"$f":"SUM(J103/$C$6)/($C$9+$C$10+$C$12)","v":0}]
[null,"Calf Crop Bonus",1,"/rate",0,"/calf",null,null,null,{"$f":"SUM(C104*E104*C6)","v":0},null,{"$f":"SUM(J104/$C$6)/($C$9+$C$10+$C$12)","v":0}]
["Total Labour Costs for Winter Period",null,null,null,null,null,null,null,null,{"$f":"ROUND(J103+J104+J102,0)","v":40500},null,{"$f":"SUM(J105/$C$6)/($C$9+$C$10+$C$12)","v":0.69230769230769229}]
[]
[null,null,null,null,null,null,null,null,null,"Total Cost",null,"$/cow/day"]
["Total Cost of Production (Winter Feed, Extended Grazing, Operating, Fixed & Labour) ",null,null,null,null,null,null,null,null,{"$f":"SUM(J105+J98+J90)","v":236865},null,{"$f":"SUM(J108/$C$6)/($C$9+$C$10+$C$12)","v":4.048974358974359}]
[]
["Cost Summary"]
[null,null,null,null,"Cost/cow/day"]
[null,{"$f":"\"Extended grazing (based on \"&C12&\" days)\"","v":"Extended grazing (based on 0 days)"},null,null,{"$f":"L75","v":0}]
[null,{"$f":"\"Winter Feed (based on \"&C9+C10&\" days)\"","v":"Winter Feed (based on 195 days)"},null,null,{"$f":"ROUND((J60+J68)/(C9+C10)/C6,3)","v":2.0169999999999999},null,{"$f":"\"($\"&ROUND(SUM((J60+J68)/$C$6),0)&\" per cow)\"","v":"($393 per cow)"}]
[null,{"$f":"\"Yardage (not including labour, based on \"&C9+C10+C12&\" days)\"","v":"Yardage (not including labour, based on 195 days)"},null,null,{"$f":"ROUND((((J61+J69+J86+J89+J98)/C6)/(C9+C10+C12)),3)","v":1.34}]
[null,{"$f":"\"Labour (based on \"&C9+C10+C12&\" days)\"","v":"Labour (based on 195 days)"},null,null,{"$f":"ROUND((J105)/(C9+C10+C12)/C6,3)","v":0.69199999999999995}]
[null,{"$f":"\"Total Overwinter Costs (based on \"&C9+C10+C12&\" days)\"","v":"Total Overwinter Costs (based on 195 days)"},null,null,{"$f":"SUM(((J75+(E113*(C9+C10)*C6)+((E114*(C9+C10+C12)*C6)+J102))/C6)/(C9+C10+C12))","v":4.0493076923076927}]
[]
["Note: This budget is only a guide and is not intended to be an in-depth study of the cost of production of this industry. Interpretation and utilization of this information is the responsibility of the user. "]
[]
[]
[null,null,null,null,null,null,null,"                                         ",null,null,null,"September, 2024"]

{"sheet":"Winter Feed Rations (HIDE)","index":1,"n_rows":46,"n_cols":12,"rows_kept":46,"cut":false,"hidden":true,"merged":[[45,1,45,3],[25,1,25,3],[27,0,27,14],[28,1,28,3],[28,13,29,13],[28,14,29,14],[0,0,0,14],[2,0,2,14],[4,0,4,14],[6,0,6,14],[7,1,7,3],[7,13,9,13],[7,14,9,14]]}
["Winter Feed Costs & Requirements Worksheet"]
[]
[]
[]
["Enter your days on feed for each selected ration number in the \"blue\" numbers in the \"gray\" shaded area"]
[]
["Pre Calving - Cows (1400 lb cow Ration)"]
[null,"Ration Number",null,null,"#1 - Alfalfa Grass Hay","#2 - Barley Silage, Straw & Supplement","#3 - Corn Silage, Straw & Supplement","#4 - Straw, Grain & Supplement","#5 - Hay & Greenfeed","#6 - Straw, Grain & Supplement","#7 - Corn Silage, Hay & Straw","#8 - Straw & Pellets"]
[null,null,null,null,"Hay","Barley Silage","Corn Silage","Straw & Grain","Greenfeed & Hay","Straw, Grain & Suppl.","Corn Silage & Hay","Straw & Pellets"]
["Feed Type","$/unit","lbs/Unit","$/lb"]
["Alfalfa Hay",200,2000,{"$f":"SUM(B11/C11)","v":0.1},0,0,0,0,0,0,0,0]
["Alfalfa Grass Hay",170,2000,{"$f":"SUM(B12/C12)","v":8.5000000000000006E-2},35,0,0,0,16,0,10,0]
["Grass Hay",160,2000,{"$f":"SUM(B13/C13)","v":0.08},0,0,0,0,0,0,0,0]
["Barley Straw",60,2000,0.03,0,17,19,23,0,23,15,23]
["Barley Greenfeed",170,2000,8.5000000000000006E-2,0,0,0,0,19,0,0,0]
["Corn Silage",50,2000,2.5000000000000001E-2,0,0,47,0,0,0,32,0]
["Barley Silage",50,2000,2.5000000000000001E-2,0,48,0,0,0,0,0,0]
["Barley Grain",7.5,48,0.15625,0,0,0,11,0,10,0,0]
["32% Feedlot Suppl.",475,2205,0.21541950113378686,0,0.5,0.5,1,0,0,0,0]
["32% Liquid Suppl.",405,2205,0.18367346938775511,0,0,0,0,0,2.9,0,0]
["20% Grain Pellets",320,2205,0.14512471655328799,0,0,0,0,0,0,0,14]
["1:1 Mineral",40,55,0.72727272727272729,0.12,0,0,0,0,0,0,0]
["2:1 Mineral",40,55,0.72727272727272729,0,0.06,0.06,0.06,0.12,0.2,0.2,0.06]
["Limestone",5.5,55,0.1,0,0,0,0,0,0.2,0,0.2]
["Blue Salt",7.75,55,0.1409090909090909,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2]
[null,"$/head/day",null,null,{"$f":"SUM((E11*$D$11)+(E12*$D$12)+(E13*$D$13)+(E14*$D$14)+(E15*$D$15)+(E16*$D$16)+(E17*$D$17)+(E18*$D$18)+(E19*$D$19)+(E20*$D$20)+(E21*$D$21)+(E22*$D$22)+(E23*$D$23)+(E24*$D$24+(E25*$D$25)))","v":3.0721363636363637},{"$f":"SUM((F11*$D$11)+(F12*$D$12)+(F13*$D$13)+(F14*$D$14)+(F15*$D$15)+(F16*$D$16)+(F17*$D$17)+(F18*$D$18)+(F19*$D$19)+(F20*$D$20)+(F21*$D$21)+(F22*$D$22)+(F23*$D$23)+(F24*$D$24+(F25*$D$25)))","v":1.8712097505668936},1.9062097505668936,2.6776695011337863,3.0721363636363641,2.9604712430426714,2.2553181818181818,2.7952460317460313]
[]
["Post Calving - Cows"]
[null,"Ration Number",null,null,"#1 - Alfalfa Grass Hay & Grain","#2 - Barley Silage, Straw & Grain","#3 - Corn Silage, Straw, Grain & Supplement","#4 - Straw, Grain & Supplement","#5 - Hay, Greenfeed & Grain","#6 - Straw, Grain & Supplement","#7 - Corn Silage, Hay & Straw","#8 - Hay, Pellets & Straw"]
["Feed Type","$/unit","lbs/Unit","$/lb"]
[{"$f":"A11","v":"Alfalfa Hay"},200,2000,{"$f":"SUM(B31/C31)","v":0.1},0,0,0,0,0,0,0,0]
["Alfalfa Grass Hay",170,2000,{"$f":"SUM(B32/C32)","v":8.5000000000000006E-2},44,0,0,0,20,0,20,15]
["Grass Hay",160,2000,{"$f":"SUM(B33/C33)","v":0.08},0,0,0,0,0,0,0,0]
["Barley Straw",60,2000,0.03,0,12,12,24,0,23,8,11]
["Barley Greenfeed",170,2000,8.5000000000000006E-2,0,0,0,0,16,0,0,0]
["Corn Silage",50,2000,2.5000000000000001E-2,0,0,48,0,0,0,40,0]
["Barley Silage",50,2000,2.5000000000000001E-2,0,45,0,0,0,0,0,0]
["Barley Grain",7.5,48,0.15625,5,12,7,15,5,15,0,0]
["32% Feedlot Suppl.",475,2205,0.21541950113378686,0,0,2,2.5,0,0,0,0]
["32% Liquid Suppl.",405,2205,0.18367346938775511,0,0,0,0,0,3.5,0,0]
["20% Grain Pellets",320,2205,0.14512471655328799,0,0,0,0,0,0,0,15]
["1:1 Mineral",40,55,0.72727272727272729,0.18,0,0,0,0,0,0,0]
["2:1 Mineral",40,55,0.72727272727272729,0,0.18,0.18,0.18,0.18,0.18,0.18,0.18]
["Limestone",5.5,55,0.1,0,0.1,0.1,0.1,0,0.3,0,0.1]
["Blue Salt",7.75,55,0.1409090909090909,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,"$/head/day",null,null,{"$f":"SUM((E31*$D$31)+(E32*$D$32)+(E33*$D$33)+(E34*$D$34)+(E35*$D$35)+(E36*$D$36)+(E37*$D$37)+(E38*$D$38)+(E39*$D$39)+(E40*$D$40)+(E41*$D$41)+(E42*$D$42)+(E43*$D$43)+(E44*$D$44+(E45*$D$45)))","v":4.6662499999999998},{"$f":"SUM((F31*$D$31)+(F32*$D$32)+(F33*$D$33)+(F34*$D$34)+(F35*$D$35)+(F36*$D$36)+(F37*$D$37)+(F38*$D$38)+(F39*$D$39)+(F40*$D$40)+(F41*$D$41)+(F42*$D$42)+(F43*$D$43)+(F44*$D$44+(F45*$D$45)))","v":3.5149999999999997},3.2395890022675737,3.7572987528344668,3.9862500000000005,3.8516071428571426,3.0850000000000004,3.9368707482993197]