{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Program","Feed Library","Feed Cost Analyzer","Brood Cows","Bulls","Heifers","Feeder Stocker","Analyzer","Batch Mix"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":6,"comments":4,"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":"Program","index":0,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,13,20,15]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"UGA Basic Balancer Program"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"UGA Beef Team"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"www.ugabeef.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"1-800-ASK-UGA-1"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"County","Simmental"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Agent","Joe Angus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact","706-542-1852"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"*Directions for this program located on the Beef Team website listed above. "]

{"sheet":"Feed Library","index":1,"n_rows":80,"n_cols":11,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[null,"Feed Library"]
[]
[null,null,"Feeds","DM","CP","TDN","Ca","P","$/ton*",null,"Legend"]
[null,null,"FORAGE/ROUGHAGE",null,null,null,null,null,null,null,"DM = Dry Matter"]
[null,1,"Bermudagrass Hay, Good",85,12,60.1,0.38,0.22,100,null,"CP = Crude Protein"]
[null,2,"Bermudagrass Hay, Average",85,9,55,0.36,0.18,90,null,"TDN = Total Digestible Nutrients"]
[null,3,"Bermudagrass Hay, Poor",85,6,48,0.34,0.18,80,null,"Ca = Calcium"]
[null,4,"Tall Fescue Hay, Good",85,16,60,0.43,0.32,120,null,"P = Phosphorus"]
[null,5,"Tall Fescue Hay, Average",85,13,55,0.42,0.31,100,null,"$/ton = dollars per ton of feed stuff"]
[null,6,"Tall Fescue Hay, Poor",85,10,50,0.41,0.3,80,null,"* prices for Pastures are based on "]
[null,7,"Peanut Hay",88,11,54,1.2,0.15,80,null,"   Average management"]
[null,8,"Bermudagrass Pasture",25,13,64,0.4,0.27,8.75]
[null,9,"Bahiagrass Pasture",25,10,58,0.46,0.22,8.25]
[null,10,"Summer annual Pasture",25,12,60,0.5,0.44,8.5]
[null,11,"Small Grains Pasture - Vegetative",22,18,70,0.45,0.35,12.5]
[null,12,"Small Grains Pasture - Mature",25,12,58,0.4,0.3,12.5]
[null,13,"Ann. Ryegrass Pasture - Vegetative",22,20,72,0.65,0.41,10]
[null,14,"Ann. Ryegrass Pasture - Mature",25,12,58,0.6,0.35,10]
[null,15,"Tall Fescue Pasture",25,14,62,0.44,0.33,8]
[null,16,"Corn Silage",29,9.1,72.400000000000006,0.28000000000000003,0.22,50]
[null,17,"Cottonseed Hulls",90,4,45,0.15,0.09,123]
[null,18,"Gin Trash",85,11.7,46.6,0.9,0.2,35]
[null,19,"Peanut Hulls",90,8,25,1.2,0.1,20]
[null,20,"Soybean Stubble",85,5,40,1.2,0.15,20]
[null,21,"Wheat Straw",89,4,44,0.18,0.5,50]
[null,22,"Alfalfa Hay",82.5,21.1,67.599999999999994,1.27,0.32,110]
[null,23,"Ryegrass Baleage - Vegetative",50,18,70,0.6,0.35,30]
[null,24,"Ryegrass Baleage - Mature",50,12,58,0.6,0.35,30]
[null,25,"BLANK",100,0.1,0.1,0,0,999]
[null,26,"BLANK",100,0.1,0.1,0,0,999]
[null,27,"BLANK",100,0.1,0.1,0,0,999]
[null,28,"PROTEIN"]
[null,29,"Chicken Litter",85,18,50,3,2,25]
[null,30,"Corn Gluten Feed",90,21,83,0.08,0.54,180]
[null,31,"Cottonseed Meal",90,46,78,0.21,1,243]
[null,32,"Dried Distiller's Grains",90,28,92,0.05,0.88,25]
[null,33,"Liquid Feed",67,45,80,0,0,285]
[null,34,"Molasses Block",76,30,80,2,1,650]
[null,35,"Range Cubes",85,25,75,1.75,0.5,330]
[null,36,"Soybean Meal",90,49,90,0.3,0.7,415]
[null,37,"Sunflower Meal",90,43.6,75,0.5,1.68,350]
[null,38,"Urea",99,291,0.1,0,0,150]
[null,39,"Wet Brewer's Grains",21.4,25.7,83.8,0.13,0.62,10]
[null,40,"Whole Cottonseed",90,25,95,0.21,0.64,215]
[null,41,"Whole Soybeans",90,42,91,0.27,0.3,125]
[null,42,"Whole Peanuts",93,23,110,0.15,3.3000000000000002E-2,40]
[null,43,"BLANK",100,0.1,0.1,0,0,999]
[null,44,"BLANK",100,0.1,0.1,0,0,999]
[null,45,"BLANK",100,0.1,0.1,0,0,999]
[null,46,"BLANK",100,0.1,0.1,0,0,999]
[null,47,"BLANK",100,0.1,0.1,0,0,999]
[null,48,"ENERGY/TDN"]
[null,49,"Barley",90,13.2,84,0.05,0.35,200]
[null,50,"Citrus Pulp",90,7,82,1.8,0.15,220]
[null,51,"Corn",90,9,90,0.02,0.35,160]
[null,52,"Grain Sorghum",90,12,76,0.05,0.34,0]
[null,53,"Molasses",78,9,78,1.1000000000000001,0.1,25]
[null,54,"Oats",90,13,77,7.0000000000000007E-2,0.38,250]
[null,55,"Soybean Hulls",90,12,78,0.55000000000000004,0.2,185]
[null,56,"Wheat",90,13,85,0.05,0.43,175]
[null,57,"Wheat Midds",90,18,83,0.15,1,190]
[null,58,"50:50 CGF:SH",90,18,80,0.31,0.37,140]
[null,59,"50:50 DDG:SH",90,19,81,0.31,0.37,150]
[null,60,"60:20:20 SH:CGF:Corn",90,13.4,82.1,0.3,0.32300000000000001,0]
[null,61,"65:25:10 SH:CGF:PH",90,15,74,0.498,0.27700000000000002,0]
[null,62,"Hominy",90,11.5,91,0.05,0.56999999999999995,240]
[null,63,"Milo",100,0.1,0.1,0,0,999]
[null,64,"Ground Ear Corn",29,9,73,0.28999999999999998,0.22,200]
[null,65,"30:30:30 CGF:SH:Corn",90,14,83.7,0.217,0.36,180]
[null,66,"BLANK",100,0.1,0.1,0,0,999]
[null,67,"BLANK",100,0.1,0.1,0,0,999]
[null,68,"BLANK",100,0.1,0.1,0,0,999]
[null,69,"MINERAL"]
[null,70,"Basic",99,0.1,0.1,12,8,220]
[null,71,"Low P",99,0.1,0.1,10,2,200]
[null,72,"Limestone",99,0.1,0.1,39,0.01,125]
[null,73,"Salt",99,0.1,0.1,0,0,20]
[null,74,"BLANK",100,0.1,0.1,0,0,999]
[null,75,"BLANK",100,0.1,0.1,0,0,999]
[null,76,"BLANK",100,0.1,0.1,0,0,999]

{"sheet":"Feed Cost Analyzer","index":2,"n_rows":36,"n_cols":20,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"UGA Feed Cost Analyzer"]
[]
[null,"Date",{"$f":"TODAY()","v":"2020-09-29"},null,"Dr. Lawton Stewart, Animal and Dairy Science"]
[null,"Farm","UGA Farms",null,"Dr. Curt Lacy, Agriculture and Applied Economics"]
[null,null,null,null,"Dr. Dennis Hancock, Crop and Soil Sciences"]
[null,null,null,null,"Local Extension Office: 1-800-ASK-UGA1",null,null,null,null,null,"Instructions:"]
[]
[null,"Ingredients","$/ton","% DM","% CP","% TDN","$/CWT DM","$/lb CP","$/lb TDN",null,"Analyzer"]
[null,"Cottonseed Meal",{"$f":"VLOOKUP(B10,'Feed Library'!$C$5:$I$80,7,FALSE)","v":243},{"$f":"VLOOKUP(B10,'Feed Library'!$C$5:$I$80,2,FALSE)","v":90},{"$f":"VLOOKUP(B10,'Feed Library'!$C$5:$I$80,3,FALSE)","v":46},{"$f":"VLOOKUP(B10,'Feed Library'!$C$5:$I$80,4,FALSE)","v":78},{"$f":"C10/20/(D10/100)","v":13.5},{"$f":"C10/(2000*(D10/100)*(E10/100))","v":0.29347826086956524},{"$f":"C10/(2000*(D10/100)*(F10/100))","v":0.17307692307692307},null,"1)","Adjust nutrient content if a nutrient analysis is available for a given feed."]
[null,"Soybean Meal",{"$f":"VLOOKUP(B11,'Feed Library'!$C$5:$I$80,7,FALSE)","v":415},{"$f":"VLOOKUP(B11,'Feed Library'!$C$5:$I$80,2,FALSE)","v":90},{"$f":"VLOOKUP(B11,'Feed Library'!$C$5:$I$80,3,FALSE)","v":49},{"$f":"VLOOKUP(B11,'Feed Library'!$C$5:$I$80,4,FALSE)","v":90},23.055555555555554,{"$f":"C11/(2000*(D11/100)*(E11/100))","v":0.47052154195011336},{"$f":"C11/(2000*(D11/100)*(F11/100))","v":0.25617283950617287},null,"2)","Select feeds to compare from drop down menus under \"Ingredients\"."]
[null,"Dried Distiller's Grains",{"$f":"VLOOKUP(B12,'Feed Library'!$C$5:$I$80,7,FALSE)","v":25},{"$f":"VLOOKUP(B12,'Feed Library'!$C$5:$I$80,2,FALSE)","v":90},{"$f":"VLOOKUP(B12,'Feed Library'!$C$5:$I$80,3,FALSE)","v":28},{"$f":"VLOOKUP(B12,'Feed Library'!$C$5:$I$80,4,FALSE)","v":92},1.3888888888888888,4.96031746031746E-2,{"$f":"C12/(2000*(D12/100)*(F12/100))","v":1.5096618357487922E-2},null,"3)","In the",null,"shaded cells, the values of each feedstuff will be reported "]
[null,"Corn Gluten Feed",{"$f":"VLOOKUP(B13,'Feed Library'!$C$5:$I$80,7,FALSE)","v":180},{"$f":"VLOOKUP(B13,'Feed Library'!$C$5:$I$80,2,FALSE)","v":90},{"$f":"VLOOKUP(B13,'Feed Library'!$C$5:$I$80,3,FALSE)","v":21},{"$f":"VLOOKUP(B13,'Feed Library'!$C$5:$I$80,4,FALSE)","v":83},10,0.47619047619047616,0.12048192771084337,null,null,"on a $/nutrient basis."]
[null,"Whole Cottonseed",{"$f":"VLOOKUP(B14,'Feed Library'!$C$5:$I$80,7,FALSE)","v":215},{"$f":"VLOOKUP(B14,'Feed Library'!$C$5:$I$80,2,FALSE)","v":90},{"$f":"VLOOKUP(B14,'Feed Library'!$C$5:$I$80,3,FALSE)","v":25},{"$f":"VLOOKUP(B14,'Feed Library'!$C$5:$I$80,4,FALSE)","v":95},11.944444444444445,0.4777777777777778,0.12573099415204678,null,"4)","The  three  cheapest  options will be highlighted in order of green, yellow, red."]
[null,"Soybean Hulls",{"$f":"VLOOKUP(B15,'Feed Library'!$C$5:$I$80,7,FALSE)","v":185},{"$f":"VLOOKUP(B15,'Feed Library'!$C$5:$I$80,2,FALSE)","v":90},{"$f":"VLOOKUP(B15,'Feed Library'!$C$5:$I$80,3,FALSE)","v":12},{"$f":"VLOOKUP(B15,'Feed Library'!$C$5:$I$80,4,FALSE)","v":78},10.277777777777777,0.85648148148148151,0.13176638176638178]
[null,"Sunflower Meal",{"$f":"VLOOKUP(B16,'Feed Library'!$C$5:$I$80,7,FALSE)","v":350},{"$f":"VLOOKUP(B16,'Feed Library'!$C$5:$I$80,2,FALSE)","v":90},{"$f":"VLOOKUP(B16,'Feed Library'!$C$5:$I$80,3,FALSE)","v":43.6},{"$f":"VLOOKUP(B16,'Feed Library'!$C$5:$I$80,4,FALSE)","v":75},19.444444444444443,0.44597349643221207,0.25925925925925924]
[null,"Soybean Hulls",{"$f":"VLOOKUP(B17,'Feed Library'!$C$5:$I$80,7,FALSE)","v":185},{"$f":"VLOOKUP(B17,'Feed Library'!$C$5:$I$80,2,FALSE)","v":90},{"$f":"VLOOKUP(B17,'Feed Library'!$C$5:$I$80,3,FALSE)","v":12},{"$f":"VLOOKUP(B17,'Feed Library'!$C$5:$I$80,4,FALSE)","v":78},10.277777777777777,0.85648148148148151,0.13176638176638178]
[null,"BLANK",{"$f":"VLOOKUP(B18,'Feed Library'!$C$5:$I$80,7,FALSE)","v":999},{"$f":"VLOOKUP(B18,'Feed Library'!$C$5:$I$80,2,FALSE)","v":100},{"$f":"VLOOKUP(B18,'Feed Library'!$C$5:$I$80,3,FALSE)","v":0.1},{"$f":"VLOOKUP(B18,'Feed Library'!$C$5:$I$80,4,FALSE)","v":0.1},49.95,499.5,499.5]
[null,"BLANK",{"$f":"VLOOKUP(B19,'Feed Library'!$C$5:$I$80,7,FALSE)","v":999},{"$f":"VLOOKUP(B19,'Feed Library'!$C$5:$I$80,2,FALSE)","v":100},{"$f":"VLOOKUP(B19,'Feed Library'!$C$5:$I$80,3,FALSE)","v":0.1},{"$f":"VLOOKUP(B19,'Feed Library'!$C$5:$I$80,4,FALSE)","v":0.1},49.95,499.5,499.5]
[null,"BLANK",{"$f":"VLOOKUP(B20,'Feed Library'!$C$5:$I$80,7,FALSE)","v":999},{"$f":"VLOOKUP(B20,'Feed Library'!$C$5:$I$80,2,FALSE)","v":100},{"$f":"VLOOKUP(B20,'Feed Library'!$C$5:$I$80,3,FALSE)","v":0.1},{"$f":"VLOOKUP(B20,'Feed Library'!$C$5:$I$80,4,FALSE)","v":0.1},49.95,499.5,499.5]
[null,"BLANK",{"$f":"VLOOKUP(B21,'Feed Library'!$C$5:$I$80,7,FALSE)","v":999},{"$f":"VLOOKUP(B21,'Feed Library'!$C$5:$I$80,2,FALSE)","v":100},{"$f":"VLOOKUP(B21,'Feed Library'!$C$5:$I$80,3,FALSE)","v":0.1},{"$f":"VLOOKUP(B21,'Feed Library'!$C$5:$I$80,4,FALSE)","v":0.1},49.95,499.5,499.5]
[null,"BLANK",{"$f":"VLOOKUP(B22,'Feed Library'!$C$5:$I$80,7,FALSE)","v":999},{"$f":"VLOOKUP(B22,'Feed Library'!$C$5:$I$80,2,FALSE)","v":100},{"$f":"VLOOKUP(B22,'Feed Library'!$C$5:$I$80,3,FALSE)","v":0.1},{"$f":"VLOOKUP(B22,'Feed Library'!$C$5:$I$80,4,FALSE)","v":0.1},49.95,499.5,499.5]
[null,"BLANK",{"$f":"VLOOKUP(B23,'Feed Library'!$C$5:$I$80,7,FALSE)","v":999},{"$f":"VLOOKUP(B23,'Feed Library'!$C$5:$I$80,2,FALSE)","v":100},{"$f":"VLOOKUP(B23,'Feed Library'!$C$5:$I$80,3,FALSE)","v":0.1},{"$f":"VLOOKUP(B23,'Feed Library'!$C$5:$I$80,4,FALSE)","v":0.1},49.95,499.5,499.5]
[null,"BLANK",{"$f":"VLOOKUP(B24,'Feed Library'!$C$5:$I$80,7,FALSE)","v":999},{"$f":"VLOOKUP(B24,'Feed Library'!$C$5:$I$80,2,FALSE)","v":100},{"$f":"VLOOKUP(B24,'Feed Library'!$C$5:$I$80,3,FALSE)","v":0.1},{"$f":"VLOOKUP(B24,'Feed Library'!$C$5:$I$80,4,FALSE)","v":0.1},49.95,499.5,499.5]
[]
[]
[]
[null,"Feed Comparison",null,null,null,null,null,null,null,null,"Feed Comparison"]
[null,"Current Feedstuff",null,"Potential Feedstuff",null,null,null,null,null,null,"1)","Make sure prices are correct in the Feed Library."]
[null,"Wheat Straw","vs.","Peanut Hulls",null,null,null,null,null,null,"2)","Select the current feed being utilized from the drop down menu"]
[null,null,null,null,null,null,null,null,null,null,null," in the",null,"box."]
[null,null,null,"TDN",null,null,null,null,null,null,"3)","Select the potential feed to utilize from the drop down menu"]
[null,null,null,{"$f":"(VLOOKUP(B30,'Feed Library'!C5:I89,7,FALSE))/(2000*(VLOOKUP(B30,'Feed Library'!C5:I89,2,FALSE)/100)*(VLOOKUP(B30,'Feed Library'!C5:I89,4,FALSE)/100))*(VLOOKUP(D30,'Feed Library'!$C$5:$I$96,2,FALSE)/100)*(VLOOKUP(D30,'Feed Library'!$C$5:$I$96,4,FALSE)/100)*2000","v":28.72829417773238},null,null,null,null,null,null,null," in the",null,"box."]
[null,null,null,"CP",null,null,null,null,null,null,"4)","The price at which the potential feed needs to be, or lower,  in order"]
[null,null,null,{"$f":"(VLOOKUP(B30,'Feed Library'!C5:I89,7,FALSE))/(2000*(VLOOKUP(B30,'Feed Library'!C5:I89,2,FALSE)/100)*(VLOOKUP(B30,'Feed Library'!C5:I89,3,FALSE)/100))*(VLOOKUP(D30,'Feed Library'!$C$5:$I$96,2,FALSE)/100)*(VLOOKUP(D30,'Feed Library'!$C$5:$I$96,3,FALSE)/100)*2000","v":101.12359550561797},null,null,null,null,null,null,null," to replace the current feed will appear in the ",null,null,null,null,null,null,null,"boxes for a"]
[null,null,null,null,null,null,null,null,null,null,null," given nutrient."]

{"sheet":"Brood Cows","index":3,"n_rows":142,"n_cols":52,"rows_kept":142,"cut":false,"hidden":false,"merged":[[136,9,136,18],[131,9,131,18],[132,9,132,18],[133,9,133,18],[134,9,134,18],[135,9,135,18]]}
[null,null,"UGA Basic Balancer - Brood Cows"]
[null,null,"Description",null,null,null,null,null,"REQUIREMENTS:",null,"Notes:"]
[null,null,"Farm","UGA Farms",null,null,null,null,"TDN, %",{"$f":"VLOOKUP(D6,U12:Z45,4,FALSE)","v":60},"•"]
[null,null,"Group Size",250,null,null,null,null,"CP, %",{"$f":"VLOOKUP(D6,U12:Z45,3,FALSE)","v":10.5},"•"]
[null,null,"Avg Weight",1200,null,null,null,null,"Ca, %",{"$f":"VLOOKUP(D6,U10:Z45,5,FALSE)","v":0.28000000000000003},"•"]
[null,null,"Target Gain","Peak Lactation       BW-1200",null,null,null,null,"P, %",{"$f":"VLOOKUP(D6,U12:Z45,6,FALSE)","v":0.19},"•"]
[null,null,null,null,null,null,null,null,"DM Intake, lb/d",{"$f":"VLOOKUP(D6,U12:Z45,2,FALSE)*D5","v":24},"•"]
[null,null,null,null,null,null,null,null,null,null,"•"]
[null,"Diet Formulation",null,null,null,"Ingredient","TDN, %","CP, %",null,null,null,null,null,null,null,null,null,null,null,null,null,"Requirements"]
[null,1,"Constant ingredient (% DM)",0,null,"BLANK",{"$f":"VLOOKUP(F10,'Feed Library'!C5:F80,4,FALSE)","v":0.1},{"$f":"VLOOKUP(F10,'Feed Library'!C5:F80,3,FALSE)","v":0.1},null,null,null,null,null,null,null,null,null,null,null,null,"Stage of Production  -  Mature Body Weight","DM Intake","CP","TDN","Ca","P"]
[null,2,"Forage/Roughage",null,null,"Bermudagrass Hay, Average",{"$f":"VLOOKUP(F11,'Feed Library'!C5:F80,4,FALSE)","v":55},{"$f":"VLOOKUP(F11,'Feed Library'!C5:F80,3,FALSE)","v":9},null,"NO SUPPLEMENT NEEDED:",null,null,null,null,null,null,null,null,null,null,"BROOD COWS",null,null,null,null,null,null,null,null,null,null,null,null,"Brood Cow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of ration","lb/ton"]
[null,3,"Energy Source",null,null,"Soybean Hulls",{"$f":"VLOOKUP(F12,'Feed Library'!C5:F80,4,FALSE)","v":78},{"$f":"VLOOKUP(F12,'Feed Library'!C5:F80,3,FALSE)","v":12},null,"FORAGE MEETS ",null,null,null,null,null,null,null,null,null,null,"Dry Cow (Post Weaning)",null,null,null,null,null,null,null,null,null,null,null,null,"Heifer",null,null,null,null,null,null,"% in diet",null,null,null,"Base Diet",{"$f":"D20","v":0.18434782608695652},null,{"$f":"ABS(AU13-AT14)","v":38.723478260869562},{"$f":"AV12/AV15","v":0.99762534163717009},{"$f":"AW12*2002","v":1997.2459339576146},null,{"$f":"((AW12*AT12)+(AW14*AT14))/D20","v":1.5}]
[null,4,"Protein Source",null,null,"Corn Gluten Feed",{"$f":"VLOOKUP(F13,'Feed Library'!C5:F80,4,FALSE)","v":83},{"$f":"VLOOKUP(F13,'Feed Library'!C5:F80,3,FALSE)","v":21},null,"NUTRIENT REQUIREMENTS!",null,null,null,null,null,null,null,null,null,null,"Dry Cow       BW-1000",1.8100000000000002E-2,7,48,0.2,0.2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F11,'Feed Library'!C5:F80,4,FALSE)","v":55},null,{"$f":"ABS(AM15-AL17)","v":18},{"$f":"(AN13/(AN13+AN17))*(1-G18)","v":0.78260869565217395},null,null,null,null,null,{"$f":"D20*1.5","v":0.27652173913043476}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dry Cow       BW-1200",1.8599999999999998E-2,7,48,0.2,0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Limestone",39,null,{"$f":"ABS(AU13-AT12)","v":9.2173913043478245E-2},{"$f":"AV14/AV15","v":2.3746583628298755E-3},{"$f":"AW14*2000","v":4.7493167256597513}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dry Cow       BW-1400",1.78E-2,7,48,0.2,0.2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((VLOOKUP(D6,U12:X45,4,FALSE)-(VLOOKUP(F10,'Feed Library'!C5:F80,4,FALSE)*G18)))/(1-D10)","v":60},null,null,null,null,null,null,null,null,{"$f":"SUM(AV12:AV14)","v":38.815652173913044}]
[null,"CHEMICAL COMPOSITION",null,null,null,"BASE DIET",null,null,null," -----Total Mixed Ration-----",null,null,"Grazing or Free Choice Forage",null,null,null,null,null,null,null,"Late Gestation (3 mo pre-calving)"]
[null,"TDN",null,{"$f":"((VLOOKUP(F18,'Feed Library'!C5:F80,4,FALSE)*G18)+(AL13*G19)+(AL17*G20))","v":60},null,"Ingredient","DM %","AF %","lb/ton","lb/hd/d","lb/group/d","lb/ton","lb/hd/d","lb/group/d",null,null,null,null,null,null,"Late Gestation       BW-1000",1.9599999999999999E-2,8,53,0.26,0.21,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F12,'Feed Library'!C5:F80,4,FALSE)","v":78},null,{"$f":"ABS(AM15-AL13)","v":5},{"$f":"(AN17/(AN17+AN13))*(1-G18)","v":0.21739130434782608}]
[null,"CP",null,{"$f":"(VLOOKUP(F18,'Feed Library'!C5:F80,3,FALSE)*G18)+(VLOOKUP(F19,'Feed Library'!C5:F80,3,FALSE)*G19)+(VLOOKUP(F20,'Feed Library'!C5:F80,3,FALSE)*G20)","v":9.6521739130434785},1,{"$f":"F10","v":"BLANK"},{"$f":"D10","v":0},{"$f":"J18/J21","v":0},{"$f":"H18*2000","v":0},{"$f":"IF(D10=0,0,((G18*(J7))/(VLOOKUP(F18,'Feed Library'!C5:F80,2, FALSE)/100)))","v":0},{"$f":"J18*D4","v":0},{"$f":"IF(H18=0,0,((H18/(H18+H20))*2000))","v":0},{"$f":"J18","v":0},{"$f":"M18*D4","v":0},null,null,null,null,null,null,"Late Gestation       BW-1200",1.8599999999999998E-2,8,53,0.26,0.21]
[null,"Ca",null,{"$f":"(VLOOKUP(F18,'Feed Library'!C5:I80,5,FALSE)*G18)+(VLOOKUP(F19,'Feed Library'!C5:I80,5,FALSE)*G19)+(VLOOKUP(F20,'Feed Library'!C5:I80,5,FALSE)*G20)","v":0.40130434782608693},2,{"$f":"F11","v":"Bermudagrass Hay, Average"},{"$f":"IF(AL17>1,AO13,(1-D10))","v":0.78260869565217395},{"$f":"J19/J21","v":0.79217603911980439},{"$f":"H19*2000","v":1584.3520782396088},{"$f":"G19*(J7)/(VLOOKUP(F19,'Feed Library'!C5:F80,2, FALSE)/100)","v":22.097186700767267},{"$f":"J19*D4","v":5524.2966751918166}," -"," -"," -",null,null,null,null,null,null,"Late Gestation       BW-1400",1.78E-2,8,53,0.26,0.21]
[null,"P",null,{"$f":"(VLOOKUP(F18,'Feed Library'!C5:I80,6,FALSE)*G18)+(VLOOKUP(F19,'Feed Library'!C5:I80,6,FALSE)*G19)+(VLOOKUP(F20,'Feed Library'!C5:I80,6,FALSE)*G20)","v":0.18434782608695652},3,{"$f":"F12","v":"Soybean Hulls"},{"$f":"IF(AL17>1,AO17,0)","v":0.21739130434782608},{"$f":"J20/J21","v":0.20782396088019556},{"$f":"H20*2000","v":415.64792176039111},{"$f":"IF(AL17>0,(G20*(J7)/(VLOOKUP(F20,'Feed Library'!C5:F80,2, FALSE)/100)),0)","v":5.7971014492753623},{"$f":"J20*D4","v":1449.2753623188405},{"$f":"IF(H20=0,0,((H20/(H18+H20))*2000))","v":2000},{"$f":"J20","v":5.7971014492753623},{"$f":"M20*D4","v":1449.2753623188405},null,null,null,null,null,null,"Peak Lactation (First 3 mo post-calving)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% in diet"]
[null,"$/ton",null,{"$f":"(VLOOKUP(F18,'Feed Library'!C5:I80,7,FALSE)*H18)+(VLOOKUP(F19,'Feed Library'!C5:I80,7,FALSE)*H19)+(VLOOKUP(F20,'Feed Library'!C5:I80,7,FALSE)*H20)","v":109.74327628361857},null,"Total",{"$f":"SUM(G18:G20)","v":1},1,2000,{"$f":"SUM(J18:J20)","v":27.89428815004263},6973.5720375106575,2000,{"$f":"SUM(M18:M20)","v":5.7971014492753623},{"$f":"SUM(N18:N20)","v":1449.2753623188405},null,null,null,null,null,null,"Peak Lactation       BW-1000",2.1000000000000001E-2,11,60,0.28000000000000003,0.19,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AL17=0.1,VLOOKUP(F11,'Feed Library'!C5:F80,3,FALSE),(VLOOKUP(F11,'Feed Library'!C5:F80,3,FALSE)*(AO13/(AO17+AO13)))+(VLOOKUP(F12,'Feed Library'!C5:F80,3,FALSE)*(AO17/(AO17+AO13))))","v":9.6521739130434785},null,{"$f":"ABS(AM23-AL25)","v":10.5},{"$f":"AN21/(AN21+AN25)","v":0.92528735632183912},null,null,null,"Final Diet",{"$f":"D29","v":0.37729885057471269},null,{"$f":"ABS(AU22-AT23)","v":38.683620689655172},{"$f":"AV21/AV24","v":0.99842766129450944},{"$f":"AW21*2002","v":1998.8521779116079},null,{"$f":"((AW21*AT21)+(AW23*AT23))/D29","v":1.1609545532283871}]
[null,"$/hd/d",null,{"$f":"(D21/2000)*J21","v":1.5306052855924981},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peak Lactation       BW-1200",0.02,10.5,60,0.28000000000000003,0.19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D30*1.5","v":0.31637931034482758}]
[null,"Ca:P",null,{"$f":"D19/D20","v":2.1768867924528301},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Peak Lactation       BW-1400",1.9099999999999999E-2,10,60,0.28000000000000003,0.18,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(((VLOOKUP(D6,U12:X45,3,FALSE)-(VLOOKUP(F10,'Feed Library'!C5:F80,3,FALSE)*G18))))/(1-D10)","v":10.5},null,null,null,null,null,"Limestone",39,null,{"$f":"ABS(AU22-AT21)","v":6.0919540229885105E-2},{"$f":"AV23/AV24","v":1.5723387054905784E-3},{"$f":"AW23*2000","v":3.1446774109811568}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Late Lactation (Last 3 mo pre-weaning)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AV21:AV23)","v":38.744540229885054}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Late Lactation       BW-1000",2.1999999999999999E-2,9,55,0.24,0.17,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F13,'Feed Library'!C5:F80,3,FALSE)","v":21},null,{"$f":"ABS(AM23-AL21)","v":0.84782608695652151},{"$f":"AN25/(AN25+AN21)","v":7.4712643678160898E-2}]
[null,"CHEMICAL COMPOSITION",null,null,null,"FINAL DIET",null,null,null," -----Total Mixed Ration-----",null,null,"Grazing or Free Choice Forage",null,null,null,null,null,null,null,"Late Lactation       BW-1200",2.1299999999999999E-2,9,54.5,0.24,0.17]
[null,"TDN",null,{"$f":"(VLOOKUP(F10,'Feed Library'!C5:F80,4,FALSE)*G28)+(AL13*G29)+(AL17*G30)+(VLOOKUP(F13,'Feed Library'!C5:F80,4,FALSE)*G31)","v":61.718390804597703},null,"Ingredient","DM %","AF %","lb/ton","lb/hd/d","lb/group/d","lb/ton","lb/hd/d","lb/group/d",null,null,null,null,null,null,"Late Lactation       BW-1400",2.07E-2,9,54,0.24,0.17]
[null,"CP",null,{"$f":"(VLOOKUP(F28,'Feed Library'!C5:F80,3,FALSE)*G28)+(VLOOKUP(F29,'Feed Library'!C5:F80,3,FALSE)*G29)+(VLOOKUP(F30,'Feed Library'!C5:F80,3,FALSE)*G30)+(VLOOKUP(F31,'Feed Library'!C5:F80,3,FALSE)*G31)","v":10.5},1,{"$f":"F10","v":"BLANK"},{"$f":"D10","v":0},{"$f":"J28/J32","v":0},{"$f":"H28*2000","v":0},{"$f":"IF(D10=0,0,((G28*(J7))/(VLOOKUP(F28,'Feed Library'!C5:F80,2, FALSE)/100)))","v":0},{"$f":"J28*D4","v":0},{"$f":"(H28/($H$28+$H$30+$H$31))*2000","v":0},{"$f":"J28","v":0},{"$f":"M28*D4","v":0}]
[null,"Ca",null,{"$f":"(VLOOKUP(F28,'Feed Library'!C5:I80,5,FALSE)*G28)+(VLOOKUP(F11,'Feed Library'!C5:I80,5,FALSE)*G29)+(VLOOKUP(F12,'Feed Library'!C5:I80,5,FALSE)*G30)+(VLOOKUP(F13,'Feed Library'!C5:I80,5,FALSE)*G31)","v":0.37729885057471269},2,{"$f":"F11","v":"Bermudagrass Hay, Average"},{"$f":"IF(AL17>1,(AO13*AO21),((1-D10)*AO21))","v":0.72413793103448276},{"$f":"J29/J32","v":0.7354085603112841},{"$f":"H29*2000","v":1470.8171206225682},{"$f":"(G29*(J7))/(VLOOKUP(F29,'Feed Library'!C5:F80,2, FALSE)/100)","v":20.446247464503045},{"$f":"J29*D4","v":5111.5618661257613}," -"," -"," -",null,null,null,null,null,null,"User Defined","-","-","-","-","-"]
[null,"P",null,{"$f":"(VLOOKUP(F28,'Feed Library'!C5:I80,6,FALSE)*G28)+(VLOOKUP(F11,'Feed Library'!C5:I80,6,FALSE)*G29)+(VLOOKUP(F12,'Feed Library'!C5:I80,6,FALSE)*G30)+(VLOOKUP(F13,'Feed Library'!C5:I80,6,FALSE)*G31)","v":0.21091954022988504},3,{"$f":"F12","v":"Soybean Hulls"},{"$f":"IF(AL17>1,(AO17*AO21),AO22)","v":0.20114942528735633},{"$f":"J30/J32","v":0.19293125810635536},{"$f":"H30*2000","v":385.86251621271072},{"$f":"IF(AL17>0,(G30*(J7)/(VLOOKUP(F30,'Feed Library'!C5:F80,2, FALSE)/100)),0)","v":5.3639846743295019},{"$f":"J30*D4","v":1340.9961685823755},{"$f":"(H30/($H$28+$H$30+$H$31))*2000","v":1458.3333333333335},{"$f":"J30","v":5.3639846743295019},{"$f":"M30*D4","v":1340.9961685823755}]
[null,"$/ton",null,{"$f":"(VLOOKUP(F28,'Feed Library'!C5:I80,7,FALSE)*H28)+(VLOOKUP(F29,'Feed Library'!C5:I80,7,FALSE)*H29)+(VLOOKUP(F30,'Feed Library'!C5:I80,7,FALSE)*H30)+(VLOOKUP(F31,'Feed Library'!C5:I80,7,FALSE)*H31)","v":114.7778858625162},4,{"$f":"F13","v":"Corn Gluten Feed"},{"$f":"AO25*(1-G28)","v":7.4712643678160898E-2},{"$f":"J31/J32","v":7.1660181582360552E-2},{"$f":"H31*2000","v":143.3203631647211},{"$f":"(G31*(J7))/(VLOOKUP(F31,'Feed Library'!C5:F80,2, FALSE)/100)","v":1.9923371647509573},{"$f":"J31*D4","v":498.08429118773932},{"$f":"(H31/($H$28+$H$30+$H$31))*2000","v":541.66666666666663},{"$f":"J31","v":1.9923371647509573},{"$f":"M31*D4","v":498.08429118773932}]
[null,"$/hd/d",null,{"$f":"D31/2000*J32","v":1.5955600631057019},null,"Total",{"$f":"SUM(G28:G31)","v":1},{"$f":"SUM(H28:H31)","v":1},2000,27.802569303583503,6950.6423258958757,2000,7.3563218390804597,{"$f":"SUM(N28:N31)","v":1839.0804597701149}]
[null,"Ca:P",null,{"$f":"D29/D30","v":1.7888283378746597}]
[]
[null,"NOT ENOUGH",null,null,"ADJUST MINERAL TO INCREASE",null,"ADJUST MINERAL TO INCREASE"]
[null,"ENERGY AVAILABLE",null,null," Ca:P RATIO To 1.5",null,"Ca:P RATIO TO 1.5"]
[null,"IN DIET",null,null,"Limestone needed:",null,"Limestone needed:"]
[null,null,null,null,{"$f":"AX23","v":3.1446774109811568},"Lb/ton TMR",{"$f":"AX14","v":4.7493167256597513},"Lb/ton TMR"]
[null,null,null,null,{"$f":"E38/(E38+I28+I30+I31)*2000","v":11.814821047226335},"Lb/ton Grazing or FC Forage",{"$f":"G38/(G38+I18+I20)*2000","v":22.594423991761484},"Lb/ton Grazing or FC Forage"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Brood Cow Ration"]
[null,null,null,null,null,null,null,null,"Date",{"$f":"TODAY()","v":"2020-09-29"}]
[null,null,null,null,null,null,null,null,"Producer",{"$f":"D3","v":"UGA Farms"}]
[null,null,null,null,null,null,null,null,"County",{"$f":"Program!O14","v":"Simmental"}]
[null,null,null,null,null,null,null,null,"Agent",{"$f":"Program!O15","v":"Joe Angus"}]
[null,null,null,null,null,null,null,null,"Local Contact",{"$f":"Program!O16","v":"706-542-1852"},null,null,null,null,"1-800-ASK-UGA1"]
[]
[]
[null,null,null,null,null,null,null,null,"Description:",null,null,null,null,null,"REQUIREMENTS:"]
[null,null,null,null,null,null,null,null,{"$f":"C4","v":"Group Size"},250,null,null,null,null,"TDN, %",null,{"$f":"J3","v":60}]
[null,null,null,null,null,null,null,null,"Avg Weight",1200,null,null,null,null,"CP, %",null,{"$f":"J4","v":10.5}]
[null,null,null,null,null,null,null,null,"Target Gain","Peak Lactation       BW-1200",null,null,null,null,"Ca, %",null,{"$f":"J5","v":0.28000000000000003}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P, %",null,{"$f":"J6","v":0.19}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DM Intake, lb/d",null,{"$f":"J7","v":24}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"CHEMICAL COMPOSITION",null,null,"RATION",null,null,null,{"$f":"J16","v":" -----Total Mixed Ration-----"},null,null,null,{"$f":"M16","v":"Grazing or Free Choice Forage"}]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B17,B27)","v":"TDN"},{"$f":"IF($D$18>($J$4-0.01),D17,D27)","v":61.718390804597703},null,{"$f":"IF($D$18>($J$4-0.01),F17,F27)","v":"Ingredient"},"DM %","AF %","lb/ton","lb/hd/d","lb/group/d","lb/ton","lb/hd/d","lb/group/d"]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B18,B28)","v":"CP"},{"$f":"IF($D$18>($J$4-0.01),D18,D28)","v":10.5},1,"BLANK",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B19,B29)","v":"Ca"},{"$f":"IF($D$18>($J$4-0.01),D19,D29)","v":0.37729885057471269},2,"Bermudagrass Hay, Average",0.72413793103448276,0.7354085603112841,1470.8171206225682,20.446247464503045,5111.5618661257613," -"," -"," -"]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B20,B30)","v":"P"},{"$f":"IF($D$18>($J$4-0.01),D20,D30)","v":0.21091954022988504},3,"Soybean Hulls",0.20114942528735633,0.19293125810635536,385.86251621271072,5.3639846743295019,1340.9961685823755,1458.3333333333335,5.3639846743295019,1340.9961685823755]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B23,B33)","v":"Ca:P"},{"$f":"IF($D$18>($J$4-0.01),D23,D33)","v":1.7888283378746597},4,{"$f":"IF($D$18>($J$4-0.01),N142,F31)","v":"Corn Gluten Feed"},{"$f":"IF($D$18>($J$4-0.01),N142,G31)","v":7.4712643678160898E-2},{"$f":"IF($D$18>($J$4-0.01),O142,H31)","v":7.1660181582360552E-2},{"$f":"IF($D$18>($J$4-0.01),Y122,I31)","v":143.3203631647211},{"$f":"IF($D$18>($J$4-0.01),Z122,J31)","v":1.9923371647509573},{"$f":"IF($D$18>($J$4-0.01),AA121,K31)","v":498.08429118773932},{"$f":"IF($D$18>($J$4-0.01),Y122,L31)","v":541.66666666666663},{"$f":"IF($D$18>($J$4-0.01),Z122,M31)","v":1.9923371647509573},{"$f":"IF($D$18>($J$4-0.01),AB121,N31)","v":498.08429118773932}]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B21,B31)","v":"$/ton"},{"$f":"IF($D$18>($J$4-0.01),D21,D31)","v":114.7778858625162},null,"Total",{"$f":"SUM(M117:M120)","v":1},1,2000,27.802569303583503,6950.6423258958757,2000,7.3563218390804597,1839.0804597701149,null,null,null,null,null,null," -"," -"," -"]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B22,B32)","v":"$/hd/d"},{"$f":"IF($D$18>($J$4-0.01),D22,D32)","v":1.5955600631057019},null,null,null,null,null,null,null,null,null,null,null,null,null,null," -"," -"]
[]
[null,null,null,null,null,null,null,null,"Limestone needed:",null,null,"Limestone needed:"]
[null,null,null,null,null,null,null,null,{"$f":"G38","v":4.7493167256597513},{"$f":"H38","v":"Lb/ton TMR"},null,{"$f":"E38","v":3.1446774109811568},{"$f":"F38","v":"Lb/ton TMR"}]
[null,null,null,null,null,null,null,null,{"$f":"G39","v":22.594423991761484},{"$f":"H39","v":"Lb/ton Grazing or FC Forage"},null,{"$f":"E39","v":11.814821047226335},{"$f":"F39","v":"Lb/ton Grazing or FC Forage"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Notes:"]
[null,null,null,null,null,null,null,null,"•",{"$f":"IF(L3=\"\",\"\",L3)","v":""}]
[null,null,null,null,null,null,null,null,"•",""]
[null,null,null,null,null,null,null,null,"•",""]
[null,null,null,null,null,null,null,null,"•",""]
[null,null,null,null,null,null,null,null,"•",""]
[null,null,null,null,null,null,null,null,"•",""]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," -"," -"," -"," -"," -"]

{"sheet":"Bulls","index":4,"n_rows":142,"n_cols":52,"rows_kept":142,"cut":false,"hidden":false,"merged":[[136,9,136,18],[131,9,131,18],[132,9,132,18],[133,9,133,18],[134,9,134,18],[135,9,135,18]]}
[null,null,"UGA Basic Balancer - Bulls"]
[null,null,"Description",null,null,null,null,null,"REQUIREMENTS:",null,"Notes:"]
[null,null,"Farm","UGA Farms",null,null,null,null,"TDN, %",{"$f":"VLOOKUP(D6,U12:Z45,4,FALSE)","v":76.5},"•"]
[null,null,"Group Size",10,null,null,null,null,"CP, %",{"$f":"VLOOKUP(D6,U12:Z45,3,FALSE)","v":10.8},"•"]
[null,null,"Avg Weight",800,null,null,null,null,"Ca, %",{"$f":"VLOOKUP(D6,U10:Z45,5,FALSE)","v":0.44},"•"]
[null,null,"Target Gain","BW-800     ADG-3.0",null,null,null,null,"P, %",{"$f":"VLOOKUP(D6,U12:Z45,6,FALSE)","v":0.24},"•"]
[null,null,null,null,null,null,null,null,"DM Intake, lb/d",{"$f":"VLOOKUP(D6,U12:Z45,2,FALSE)*D5","v":18.2},"•"]
[null,null,null,null,null,null,null,null,null,null,"•"]
[null,"Diet Formulation",null,null,null,"Ingredient","TDN, %","CP, %",null,null,null,null,null,null,null,null,null,null,null,null,null,"Requirements"]
[null,1,"Constant ingredient (% DM)",0,null,"Corn",{"$f":"VLOOKUP(F10,'Feed Library'!C5:F80,4,FALSE)","v":90},{"$f":"VLOOKUP(F10,'Feed Library'!C5:F80,3,FALSE)","v":9},null,null,null,null,null,null,null,null,null,null,null,null,"ADG","DM Intake","CP","TDN","Ca","P"]
[null,2,"Forage/Roughage",null,null,"Bermudagrass Hay, Average",{"$f":"VLOOKUP(F11,'Feed Library'!C5:F80,4,FALSE)","v":55},{"$f":"VLOOKUP(F11,'Feed Library'!C5:F80,3,FALSE)","v":9},null,"NO SUPPLEMENT NEEDED:",null,null,null,null,null,null,null,null,null,null,"BW 400 lb",null,null,null,null,null,null,null,null,null,null,null,null,"Brood Cow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of ration","lb/ton"]
[null,3,"Energy Source",null,null,"Soybean Hulls",{"$f":"VLOOKUP(F12,'Feed Library'!C5:F80,4,FALSE)","v":78},{"$f":"VLOOKUP(F12,'Feed Library'!C5:F80,3,FALSE)","v":12},null,"FORAGE MEETS ",null,null,null,null,null,null,null,null,null,null,"BW-400     ADG-1.0",2.58E-2,11.6,57.5,0.39,0.21,null,null,null,null,null,null,null,"Heifer",null,null,null,null,null,null,"% in diet",null,null,null,"Base Diet",{"$f":"D20","v":0.19869565217391308},null,{"$f":"ABS(AU13-AT14)","v":38.701956521739127},{"$f":"AV12/AV15","v":0.99743957509272441},{"$f":"AW12*2002","v":1996.8740293356343},null,{"$f":"((AW12*AT12)+(AW14*AT14))/D20","v":1.5}]
[null,4,"Protein Source",null,null,"Corn Gluten Feed",{"$f":"VLOOKUP(F13,'Feed Library'!C5:F80,4,FALSE)","v":83},{"$f":"VLOOKUP(F13,'Feed Library'!C5:F80,3,FALSE)","v":21},null,"NUTRIENT REQUIREMENTS!",null,null,null,null,null,null,null,null,null,null,"BW-400     ADG-1.5",2.6800000000000001E-2,13.4,61.5,0.49,0.25,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F11,'Feed Library'!C5:F80,4,FALSE)","v":55},null,{"$f":"ABS(AM15-AL17)","v":1.5},{"$f":"(AN13/(AN13+AN17))*(1-G18)","v":6.5217391304347824E-2},null,null,null,null,null,{"$f":"D20*1.5","v":0.29804347826086963}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-400     ADG-2.0",2.75E-2,15.2,65.5,0.6,0.28000000000000003,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Limestone",39,null,{"$f":"ABS(AU13-AT12)","v":9.9347826086956553E-2},{"$f":"AV14/AV15","v":2.5604249072756417E-3},{"$f":"AW14*2000","v":5.1208498145512831}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-400     ADG-2.5",2.7799999999999998E-2,17,70,0.7,0.32,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((VLOOKUP(D6,U12:X45,4,FALSE)-(VLOOKUP(F10,'Feed Library'!C5:F80,4,FALSE)*G18)))/(1-D10)","v":76.5},null,null,null,null,null,null,null,null,{"$f":"SUM(AV12:AV14)","v":38.801304347826083}]
[null,"CHEMICAL COMPOSITION",null,null,null,"BASE DIET",null,null,null," -----Total Mixed Ration-----",null,null,"Grazing or Free Choice Forage",null,null,null,null,null,null,null,"BW-400     ADG-3.0",2.7E-2,19.3,76.5,0.84,0.37]
[null,"TDN",null,{"$f":"((VLOOKUP(F18,'Feed Library'!C5:F80,4,FALSE)*G18)+(AL13*G19)+(AL17*G20))","v":76.5},null,"Ingredient","DM %","AF %","lb/ton","lb/hd/d","lb/group/d","lb/ton","lb/hd/d","lb/group/d",null,null,null,null,null,null,"BW 600 lb",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F12,'Feed Library'!C5:F80,4,FALSE)","v":78},null,{"$f":"ABS(AM15-AL13)","v":21.5},{"$f":"(AN17/(AN17+AN13))*(1-G18)","v":0.93478260869565222}]
[null,"CP",null,{"$f":"(VLOOKUP(F18,'Feed Library'!C5:F80,3,FALSE)*G18)+(VLOOKUP(F19,'Feed Library'!C5:F80,3,FALSE)*G19)+(VLOOKUP(F20,'Feed Library'!C5:F80,3,FALSE)*G20)","v":11.804347826086957},1,{"$f":"F10","v":"Corn"},{"$f":"D10","v":0},{"$f":"J18/J21","v":0},{"$f":"H18*2000","v":0},{"$f":"IF(D10=0,0,((G18*(J7))/(VLOOKUP(F18,'Feed Library'!C5:F80,2, FALSE)/100)))","v":0},{"$f":"J18*D4","v":0},{"$f":"IF(H18=0,0,((H18/(H18+H20))*2000))","v":0},{"$f":"J18","v":0},{"$f":"M18*D4","v":0},null,null,null,null,null,null,"BW-600     ADG-1.0",2.3199999999999998E-2,9.1999999999999993,57.5,0.3,0.79]
[null,"Ca",null,{"$f":"(VLOOKUP(F18,'Feed Library'!C5:I80,5,FALSE)*G18)+(VLOOKUP(F19,'Feed Library'!C5:I80,5,FALSE)*G19)+(VLOOKUP(F20,'Feed Library'!C5:I80,5,FALSE)*G20)","v":0.53760869565217395},2,{"$f":"F11","v":"Bermudagrass Hay, Average"},{"$f":"IF(AL17>1,AO13,(1-D10))","v":6.5217391304347824E-2},{"$f":"J19/J21","v":6.8789808917197451E-2},{"$f":"H19*2000","v":137.5796178343949},{"$f":"G19*(J7)/(VLOOKUP(F19,'Feed Library'!C5:F80,2, FALSE)/100)","v":1.3964194373401535},{"$f":"J19*D4","v":13.964194373401535}," -"," -"," -",null,null,null,null,null,null,"BW-600     ADG-1.5",2.4199999999999999E-2,10,61.5,0.36,0.21]
[null,"P",null,{"$f":"(VLOOKUP(F18,'Feed Library'!C5:I80,6,FALSE)*G18)+(VLOOKUP(F19,'Feed Library'!C5:I80,6,FALSE)*G19)+(VLOOKUP(F20,'Feed Library'!C5:I80,6,FALSE)*G20)","v":0.19869565217391308},3,{"$f":"F12","v":"Soybean Hulls"},{"$f":"IF(AL17>1,AO17,0)","v":0.93478260869565222},{"$f":"J20/J21","v":0.93121019108280256},{"$f":"H20*2000","v":1862.4203821656051},{"$f":"IF(AL17>0,(G20*(J7)/(VLOOKUP(F20,'Feed Library'!C5:F80,2, FALSE)/100)),0)","v":18.903381642512077},{"$f":"J20*D4","v":189.03381642512076},{"$f":"IF(H20=0,0,((H20/(H18+H20))*2000))","v":2000},{"$f":"J20","v":18.903381642512077},{"$f":"M20*D4","v":189.03381642512076},null,null,null,null,null,null,"BW-600     ADG-2.0",2.4799999999999999E-2,10.8,65.5,0.43,0.24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% in diet"]
[null,"$/ton",null,{"$f":"(VLOOKUP(F18,'Feed Library'!C5:I80,7,FALSE)*H18)+(VLOOKUP(F19,'Feed Library'!C5:I80,7,FALSE)*H19)+(VLOOKUP(F20,'Feed Library'!C5:I80,7,FALSE)*H20)","v":178.46496815286625},null,"Total",{"$f":"SUM(G18:G20)","v":1},1,2000,{"$f":"SUM(J18:J20)","v":20.29980107985223},202.9980107985223,2000,{"$f":"SUM(M18:M20)","v":18.903381642512077},{"$f":"SUM(N18:N20)","v":189.03381642512076},null,null,null,null,null,null,"BW-600     ADG-2.5",2.5000000000000001E-2,11.6,70,0.5,0.25,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AL17=0.1,VLOOKUP(F11,'Feed Library'!C5:F80,3,FALSE),(VLOOKUP(F11,'Feed Library'!C5:F80,3,FALSE)*(AO13/(AO17+AO13)))+(VLOOKUP(F12,'Feed Library'!C5:F80,3,FALSE)*(AO17/(AO17+AO13))))","v":11.804347826086957},null,{"$f":"ABS(AM23-AL25)","v":10.199999999999999},{"$f":"AN21/(AN21+AN25)","v":0.910360884749709},null,null,null,"Final Diet",{"$f":"D29","v":0.49658905704307343},null,{"$f":"ABS(AU22-AT23)","v":38.656065192083815},{"$f":"AV21/AV24","v":0.99606649610384235},{"$f":"AW21*2002","v":1994.1251251998924},null,{"$f":"((AW21*AT21)+(AW23*AT23))/D29","v":1.3049872219523027}]
[null,"$/hd/d",null,{"$f":"(D21/2000)*J21","v":1.8114016766126741},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-600     ADG-3.0",2.4500000000000001E-2,12.7,76.5,0.56999999999999995,0.28999999999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D30*1.5","v":0.34393480791618164}]
[null,"Ca:P",null,{"$f":"D19/D20","v":2.7056892778993431},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW 800 lb",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(((VLOOKUP(D6,U12:X45,3,FALSE)-(VLOOKUP(F10,'Feed Library'!C5:F80,3,FALSE)*G18))))/(1-D10)","v":10.8},null,null,null,null,null,"Limestone",39,null,{"$f":"ABS(AU22-AT21)","v":0.15265424912689179},{"$f":"AV23/AV24","v":3.933503896157659E-3},{"$f":"AW23*2000","v":7.8670077923153183}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-800     ADG-1.0",2.1600000000000001E-2,8.4,57.5,0.25,0.19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AV21:AV23)","v":38.808719441210705}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-800     ADG-1.5",2.2499999999999999E-2,9,61.5,0.28999999999999998,0.2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F13,'Feed Library'!C5:F80,3,FALSE)","v":21},null,{"$f":"ABS(AM23-AL21)","v":1.0043478260869563},{"$f":"AN25/(AN25+AN21)","v":8.9639115250291015E-2}]
[null,"CHEMICAL COMPOSITION",null,null,null,"FINAL DIET",null,null,null," -----Total Mixed Ration-----",null,null,"Grazing or Free Choice Forage",null,null,null,null,null,null,null,"BW-800     ADG-2.0",2.3099999999999999E-2,9.5,65.5,0.33,0.21]
[null,"TDN",null,{"$f":"(VLOOKUP(F10,'Feed Library'!C5:F80,4,FALSE)*G28)+(AL13*G29)+(AL17*G30)+(VLOOKUP(F13,'Feed Library'!C5:F80,4,FALSE)*G31)","v":77.08265424912689},null,"Ingredient","DM %","AF %","lb/ton","lb/hd/d","lb/group/d","lb/ton","lb/hd/d","lb/group/d",null,null,null,null,null,null,"BW-800     ADG-2.5",2.325E-2,10.1,70,0.38,0.23]
[null,"CP",null,{"$f":"(VLOOKUP(F28,'Feed Library'!C5:F80,3,FALSE)*G28)+(VLOOKUP(F29,'Feed Library'!C5:F80,3,FALSE)*G29)+(VLOOKUP(F30,'Feed Library'!C5:F80,3,FALSE)*G30)+(VLOOKUP(F31,'Feed Library'!C5:F80,3,FALSE)*G31)","v":12.628637951105938},1,{"$f":"F10","v":"Corn"},{"$f":"D10","v":0},{"$f":"J28/J32","v":0},{"$f":"H28*2000","v":0},{"$f":"IF(D10=0,0,((G28*(J7))/(VLOOKUP(F28,'Feed Library'!C5:F80,2, FALSE)/100)))","v":0},{"$f":"J28*D4","v":0},{"$f":"(H28/($H$28+$H$30+$H$31))*2000","v":0},{"$f":"J28","v":0},{"$f":"M28*D4","v":0},null,null,null,null,null,null,"BW-800     ADG-3.0",2.2749999999999999E-2,10.8,76.5,0.44,0.24]
[null,"Ca",null,{"$f":"(VLOOKUP(F28,'Feed Library'!C5:I80,5,FALSE)*G28)+(VLOOKUP(F11,'Feed Library'!C5:I80,5,FALSE)*G29)+(VLOOKUP(F12,'Feed Library'!C5:I80,5,FALSE)*G30)+(VLOOKUP(F13,'Feed Library'!C5:I80,5,FALSE)*G31)","v":0.49658905704307343},2,{"$f":"F11","v":"Bermudagrass Hay, Average"},{"$f":"IF(AL17>1,(AO13*AO21),((1-D10)*AO21))","v":5.9371362048894066E-2},{"$f":"J29/J32","v":6.2645011600928086E-2},{"$f":"H29*2000","v":125.29002320185617},{"$f":"(G29*(J7))/(VLOOKUP(F29,'Feed Library'!C5:F80,2, FALSE)/100)","v":1.2712456344586731},{"$f":"J29*D4","v":12.71245634458673}," -"," -"," -",null,null,null,null,null,null,"BW 1000 lb"]
[null,"P",null,{"$f":"(VLOOKUP(F28,'Feed Library'!C5:I80,6,FALSE)*G28)+(VLOOKUP(F11,'Feed Library'!C5:I80,6,FALSE)*G29)+(VLOOKUP(F12,'Feed Library'!C5:I80,6,FALSE)*G30)+(VLOOKUP(F13,'Feed Library'!C5:I80,6,FALSE)*G31)","v":0.22928987194412109},3,{"$f":"F12","v":"Soybean Hulls"},{"$f":"IF(AL17>1,(AO17*AO21),AO22)","v":0.85098952270081496},{"$f":"J30/J32","v":0.84802784222737826},{"$f":"H30*2000","v":1696.0556844547566},{"$f":"IF(AL17>0,(G30*(J7)/(VLOOKUP(F30,'Feed Library'!C5:F80,2, FALSE)/100)),0)","v":17.2088992368387},{"$f":"J30*D4","v":172.08899236838701},{"$f":"(H30/($H$28+$H$30+$H$31))*2000","v":1809.4059405940595},{"$f":"J30","v":17.2088992368387},{"$f":"M30*D4","v":172.08899236838701},null,null,null,null,null,null,"BW-1000    ADG-1.0",2.0400000000000001E-2,8,57.5,0.24,0.19]
[null,"$/ton",null,{"$f":"(VLOOKUP(F28,'Feed Library'!C5:I80,7,FALSE)*H28)+(VLOOKUP(F29,'Feed Library'!C5:I80,7,FALSE)*H29)+(VLOOKUP(F30,'Feed Library'!C5:I80,7,FALSE)*H30)+(VLOOKUP(F31,'Feed Library'!C5:I80,7,FALSE)*H31)","v":178.60208816705338},4,{"$f":"F13","v":"Corn Gluten Feed"},{"$f":"AO25*(1-G28)","v":8.9639115250291015E-2},{"$f":"J31/J32","v":8.9327146171693711E-2},{"$f":"H31*2000","v":178.65429234338743},{"$f":"(G31*(J7))/(VLOOKUP(F31,'Feed Library'!C5:F80,2, FALSE)/100)","v":1.8127021083947736},{"$f":"J31*D4","v":18.127021083947735},{"$f":"(H31/($H$28+$H$30+$H$31))*2000","v":190.59405940594053},{"$f":"J31","v":1.8127021083947736},{"$f":"M31*D4","v":18.127021083947735},null,null,null,null,null,null,"BW-1000    ADG-1.5",2.1299999999999999E-2,8.4,61.5,0.26,0.19]
[null,"$/hd/d",null,{"$f":"D31/2000*J32","v":1.8121724227137499},null,"Total",{"$f":"SUM(G28:G31)","v":1},{"$f":"SUM(H28:H31)","v":1},2000.0000000000002,20.292846979692147,202.92846979692149,2000,19.021601345233474,{"$f":"SUM(N28:N31)","v":190.21601345233475},null,null,null,null,null,null,"BW-1000    ADG-2.0",2.18E-2,8.6999999999999993,65.5,0.28000000000000003,0.19]
[null,"Ca:P",null,{"$f":"D29/D30","v":2.1657696994313569},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-1000    ADG-2.5",2.1999999999999999E-2,9.1,70,0.31,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-1000    ADG-3.0",2.1499999999999998E-2,9.6,76.5,35,0.21]
[null,"NOT ENOUGH",null,null,"ADJUST MINERAL TO INCREASE",null,"ADJUST MINERAL TO INCREASE"]
[null,"ENERGY AVAILABLE",null,null," Ca:P RATIO To 1.5",null,"Ca:P RATIO TO 1.5",null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-1500     ADG-2.0",1.7000000000000001E-2,6.1,65,0.22,0.19]
[null,"IN DIET",null,null,"Limestone needed:",null,"Limestone needed:"]
[null,null,null,null,{"$f":"AX23","v":7.8670077923153183},"Lb/ton TMR",{"$f":"AX14","v":5.1208498145512831},"Lb/ton TMR",null,null,null,null,null,null,null,null,null,null,null,null,"BW-2000     ADG-0.0",2.1000000000000001E-2,6.8,48.5,0.22,0.19]
[null,null,null,null,{"$f":"E38/(E38+I28+I30+I31)*2000","v":8.3577010201542734},"Lb/ton Grazing or FC Forage",{"$f":"G38/(G38+I18+I20)*2000","v":5.4840554273831366},"Lb/ton Grazing or FC Forage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User Defined",null," -"," -","-","-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Bull Ration"]
[null,null,null,null,null,null,null,null,"Date",{"$f":"TODAY()","v":"2020-09-29"}]
[null,null,null,null,null,null,null,null,"Producer",{"$f":"D3","v":"UGA Farms"}]
[null,null,null,null,null,null,null,null,"County",{"$f":"Program!O14","v":"Simmental"}]
[null,null,null,null,null,null,null,null,"Agent",{"$f":"Program!O15","v":"Joe Angus"}]
[null,null,null,null,null,null,null,null,"Local Contact",{"$f":"Program!O16","v":"706-542-1852"},null,null,null,null,"1-800-ASK-UGA1"]
[]
[]
[null,null,null,null,null,null,null,null,"Description:",null,null,null,null,null,"REQUIREMENTS:"]
[null,null,null,null,null,null,null,null,{"$f":"C4","v":"Group Size"},10,null,null,null,null,"TDN, %",null,{"$f":"J3","v":76.5}]
[null,null,null,null,null,null,null,null,"Avg Weight",800,null,null,null,null,"CP, %",null,{"$f":"J4","v":10.8}]
[null,null,null,null,null,null,null,null,"Target Gain","BW-800     ADG-3.0",null,null,null,null,"Ca, %",null,{"$f":"J5","v":0.44}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P, %",null,{"$f":"J6","v":0.24}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DM Intake, lb/d",null,{"$f":"J7","v":18.2}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"CHEMICAL COMPOSITION",null,null,"RATION",null,null,null,{"$f":"J16","v":" -----Total Mixed Ration-----"},null,null,null,{"$f":"M16","v":"Grazing or Free Choice Forage"}]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B17,B27)","v":"TDN"},{"$f":"IF($D$18>($J$4-0.01),D17,D27)","v":76.5},null,{"$f":"IF($D$18>($J$4-0.01),F17,F27)","v":"Ingredient"},"DM %","AF %","lb/ton","lb/hd/d","lb/group/d","lb/ton","lb/hd/d","lb/group/d"]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B18,B28)","v":"CP"},{"$f":"IF($D$18>($J$4-0.01),D18,D28)","v":11.804347826086957},1,"Corn",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B19,B29)","v":"Ca"},{"$f":"IF($D$18>($J$4-0.01),D19,D29)","v":0.53760869565217395},2,"Bermudagrass Hay, Average",6.5217391304347824E-2,6.8789808917197451E-2,137.5796178343949,1.3964194373401535,13.964194373401535," -"," -"," -"]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B20,B30)","v":"P"},{"$f":"IF($D$18>($J$4-0.01),D20,D30)","v":0.19869565217391308},3,"Soybean Hulls",0.93478260869565222,0.93121019108280256,1862.4203821656051,18.903381642512077,189.03381642512076,2000,18.903381642512077,189.03381642512076]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B23,B33)","v":"Ca:P"},{"$f":"IF($D$18>($J$4-0.01),D23,D33)","v":2.7056892778993431},4,{"$f":"IF($D$18>($J$4-0.01),N142,F31)","v":" -"},{"$f":"IF($D$18>($J$4-0.01),N142,G31)","v":" -"},{"$f":"IF($D$18>($J$4-0.01),O142,H31)","v":" -"},{"$f":"IF($D$18>($J$4-0.01),Y122,I31)","v":" -"},{"$f":"IF($D$18>($J$4-0.01),Z122,J31)","v":" -"},{"$f":"IF($D$18>($J$4-0.01),AA121,K31)","v":" -"},{"$f":"IF($D$18>($J$4-0.01),Y122,L31)","v":" -"},{"$f":"IF($D$18>($J$4-0.01),Z122,M31)","v":" -"},{"$f":"IF($D$18>($J$4-0.01),AB121,N31)","v":" -"}]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B21,B31)","v":"$/ton"},{"$f":"IF($D$18>($J$4-0.01),D21,D31)","v":178.46496815286625},null,"Total",{"$f":"SUM(M117:M120)","v":1},1,2000,20.29980107985223,202.9980107985223,2000,18.903381642512077,189.03381642512076,null,null,null,null,null,null," -"," -"," -"]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B22,B32)","v":"$/hd/d"},{"$f":"IF($D$18>($J$4-0.01),D22,D32)","v":1.8114016766126741},null,null,null,null,null,null,null,null,null,null,null,null,null,null," -"," -"]
[]
[null,null,null,null,null,null,null,null,"Limestone needed:",null,null,"Limestone needed:"]
[null,null,null,null,null,null,null,null,{"$f":"G38","v":5.1208498145512831},{"$f":"H38","v":"Lb/ton TMR"},null,{"$f":"E38","v":7.8670077923153183},{"$f":"F38","v":"Lb/ton TMR"}]
[null,null,null,null,null,null,null,null,{"$f":"G39","v":5.4840554273831366},{"$f":"H39","v":"Lb/ton Grazing or FC Forage"},null,{"$f":"E39","v":8.3577010201542734},{"$f":"F39","v":"Lb/ton Grazing or FC Forage"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Notes:"]
[null,null,null,null,null,null,null,null,"•",{"$f":"IF(L3=\"\",\"\",L3)","v":""}]
[null,null,null,null,null,null,null,null,"•",""]
[null,null,null,null,null,null,null,null,"•",""]
[null,null,null,null,null,null,null,null,"•",""]
[null,null,null,null,null,null,null,null,"•",""]
[null,null,null,null,null,null,null,null,"•",""]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," -"," -"," -"," -"," -"]

{"sheet":"Heifers","index":5,"n_rows":142,"n_cols":52,"rows_kept":142,"cut":false,"hidden":false,"merged":[[136,9,136,18],[131,9,131,18],[132,9,132,18],[133,9,133,18],[134,9,134,18],[135,9,135,18]]}
[null,null,"UGA Basic Balancer - Heifers"]
[null,null,"Description",null,null,null,null,null,"REQUIREMENTS:",null,"Notes:"]
[null,null,"Farm","UGA Farms",null,null,null,null,"TDN, %",{"$f":"VLOOKUP(D6,U12:Z65,4,FALSE)","v":65.5},"•"]
[null,null,"Group Size",50,null,null,null,null,"CP, %",{"$f":"VLOOKUP(D6,U12:Z65,3,FALSE)","v":10.7},"•"]
[null,null,"Avg Weight",700,null,null,null,null,"Ca, %",{"$f":"VLOOKUP(D6,U10:Z65,5,FALSE)","v":0.375},"•"]
[null,null,"Target Gain","BW-700      ADG-1.75",null,null,null,null,"P, %",{"$f":"VLOOKUP(D6,U12:Z65,6,FALSE)","v":0.2},"•"]
[null,null,null,null,null,null,null,null,"DM Intake, lb/d",{"$f":"VLOOKUP(D6,U12:Z65,2,FALSE)*D5","v":16.239999999999998},"•"]
[null,null,null,null,null,null,null,null,null,null,"•"]
[null,"Diet Formulation",null,null,null,"Ingredient","TDN, %","CP, %",null,null,null,null,null,null,null,null,null,null,null,null,null,"Requirements"]
[null,1,"Constant ingredient (% DM)",0,null,"BLANK",{"$f":"VLOOKUP(F10,'Feed Library'!C5:F80,4,FALSE)","v":0.1},{"$f":"VLOOKUP(F10,'Feed Library'!C5:F80,3,FALSE)","v":0.1},null,null,null,null,null,null,null,null,null,null,null,null,"ADG","DM Intake","CP","TDN","Ca","P"]
[null,2,"Forage/Roughage",null,null,"Bermudagrass Hay, Average",{"$f":"VLOOKUP(F11,'Feed Library'!C5:F80,4,FALSE)","v":55},{"$f":"VLOOKUP(F11,'Feed Library'!C5:F80,3,FALSE)","v":9},null,"NO SUPPLEMENT NEEDED:",null,null,null,null,null,null,null,null,null,null,"Growing Heifers",null,null,null,null,null,null,null,null,null,null,null,null,"Brood Cow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of ration","lb/ton"]
[null,3,"Energy Source",null,null,"Corn",{"$f":"VLOOKUP(F12,'Feed Library'!C5:F80,4,FALSE)","v":90},{"$f":"VLOOKUP(F12,'Feed Library'!C5:F80,3,FALSE)","v":9},null,"FORAGE MEETS ",null,null,null,null,null,null,null,null,null,null,"BW 400 lb",null,null,null,null,null,null,null,null,null,null,null,null,"Heifer",null,null,null,null,null,null,"% in diet",null,null,null,"Base Diet",{"$f":"D20","v":0.23099999999999998},null,{"$f":"ABS(AU13-AT14)","v":38.653500000000001},{"$f":"AV12/AV15","v":0.99702081560009292},{"$f":"AW12*2002","v":1996.0356728313861},null,{"$f":"((AW12*AT12)+(AW14*AT14))/D20","v":1.5000000000000002}]
[null,4,"Protein Source",null,null,"Dried Distiller's Grains",{"$f":"VLOOKUP(F13,'Feed Library'!C5:F80,4,FALSE)","v":92},{"$f":"VLOOKUP(F13,'Feed Library'!C5:F80,3,FALSE)","v":28},null,"NUTRIENT REQUIREMENTS!",null,null,null,null,null,null,null,null,null,null,"BW-400      ADG-1.00",2.5700000000000001E-2,10.4,58,0.39,0.2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F11,'Feed Library'!C5:F80,4,FALSE)","v":55},null,{"$f":"ABS(AM15-AL17)","v":24.5},{"$f":"(AN13/(AN13+AN17))*(1-G18)","v":0.7},null,null,null,null,null,{"$f":"D20*1.5","v":0.34649999999999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-400      ADG-1.25",2.5999999999999999E-2,11.3,60.5,0.45,0.22500000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Limestone",39,null,{"$f":"ABS(AU13-AT12)","v":0.11549999999999999},{"$f":"AV14/AV15","v":2.9791843999071423E-3},{"$f":"AW14*2000","v":5.9583687998142842}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-400      ADG-1.50",2.6499999999999999E-2,12.2,63,0.51,0.25,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((VLOOKUP(D6,U12:X65,4,FALSE)-(VLOOKUP(F10,'Feed Library'!C5:F80,4,FALSE)*G18)))/(1-D10)","v":65.5},null,null,null,null,null,null,null,null,{"$f":"SUM(AV12:AV14)","v":38.768999999999998}]
[null,"CHEMICAL COMPOSITION",null,null,null,"BASE DIET",null,null,null," -----Total Mixed Ration-----",null,null,"Grazing or Free Choice Forage",null,null,null,null,null,null,null,"BW-400      ADG-1.75",2.5499999999999998E-2,13.2,65.5,0.56999999999999995,0.27500000000000002]
[null,"TDN",null,{"$f":"((VLOOKUP(F18,'Feed Library'!C5:F80,4,FALSE)*G18)+(AL13*G19)+(AL17*G20))","v":65.5},null,"Ingredient","DM %","AF %","lb/ton","lb/hd/d","lb/group/d","lb/ton","lb/hd/d","lb/group/d",null,null,null,null,null,null,"BW-400      ADG-2.00",2.6499999999999999E-2,14.1,68,0.63,0.3,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F12,'Feed Library'!C5:F80,4,FALSE)","v":90},null,{"$f":"ABS(AM15-AL13)","v":10.5},{"$f":"(AN17/(AN17+AN13))*(1-G18)","v":0.3}]
[null,"CP",null,{"$f":"(VLOOKUP(F18,'Feed Library'!C5:F80,3,FALSE)*G18)+(VLOOKUP(F19,'Feed Library'!C5:F80,3,FALSE)*G19)+(VLOOKUP(F20,'Feed Library'!C5:F80,3,FALSE)*G20)","v":9},1,{"$f":"F10","v":"BLANK"},{"$f":"D10","v":0},{"$f":"J18/J21","v":0},{"$f":"H18*2000","v":0},{"$f":"IF(D10=0,0,((G18*(J7))/(VLOOKUP(F18,'Feed Library'!C5:F80,2, FALSE)/100)))","v":0},{"$f":"J18*D4","v":0},{"$f":"IF(H18=0,0,((H18/(H18+H20))*2000))","v":0},{"$f":"J18","v":0},{"$f":"M18*D4","v":0},null,null,null,null,null,null,"BW-400      ADG-2.25",2.6499999999999999E-2,15.1,70.5,0.7,0.32500000000000001]
[null,"Ca",null,{"$f":"(VLOOKUP(F18,'Feed Library'!C5:I80,5,FALSE)*G18)+(VLOOKUP(F19,'Feed Library'!C5:I80,5,FALSE)*G19)+(VLOOKUP(F20,'Feed Library'!C5:I80,5,FALSE)*G20)","v":0.25800000000000001},2,{"$f":"F11","v":"Bermudagrass Hay, Average"},{"$f":"IF(AL17>1,AO13,(1-D10))","v":0.7},{"$f":"J19/J21","v":0.71186440677966101},{"$f":"H19*2000","v":1423.7288135593219},{"$f":"G19*(J7)/(VLOOKUP(F19,'Feed Library'!C5:F80,2, FALSE)/100)","v":13.374117647058823},{"$f":"J19*D4","v":668.7058823529411}," -"," -"," -",null,null,null,null,null,null,"BW-400      ADG-2.50",2.6499999999999999E-2,16.100000000000001,73,0.76,0.35]
[null,"P",null,{"$f":"(VLOOKUP(F18,'Feed Library'!C5:I80,6,FALSE)*G18)+(VLOOKUP(F19,'Feed Library'!C5:I80,6,FALSE)*G19)+(VLOOKUP(F20,'Feed Library'!C5:I80,6,FALSE)*G20)","v":0.23099999999999998},3,{"$f":"F12","v":"Corn"},{"$f":"IF(AL17>1,AO17,0)","v":0.3},{"$f":"J20/J21","v":0.28813559322033894},{"$f":"H20*2000","v":576.27118644067787},{"$f":"IF(AL17>0,(G20*(J7)/(VLOOKUP(F20,'Feed Library'!C5:F80,2, FALSE)/100)),0)","v":5.4133333333333322},{"$f":"J20*D4","v":270.66666666666663},{"$f":"IF(H20=0,0,((H20/(H18+H20))*2000))","v":2000},{"$f":"J20","v":5.4133333333333322},{"$f":"M20*D4","v":270.66666666666663},null,null,null,null,null,null,"BW 500 lb",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% in diet"]
[null,"$/ton",null,{"$f":"(VLOOKUP(F18,'Feed Library'!C5:I80,7,FALSE)*H18)+(VLOOKUP(F19,'Feed Library'!C5:I80,7,FALSE)*H19)+(VLOOKUP(F20,'Feed Library'!C5:I80,7,FALSE)*H20)","v":110.16949152542372},null,"Total",{"$f":"SUM(G18:G20)","v":1},1,1999.9999999999998,{"$f":"SUM(J18:J20)","v":18.787450980392155},939.37254901960773,2000,{"$f":"SUM(M18:M20)","v":5.4133333333333322},{"$f":"SUM(N18:N20)","v":270.66666666666663},null,null,null,null,null,null,"BW-500      ADG-1.00",2.4400000000000002E-2,9.8000000000000007,58,0.34,0.18,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AL17=0.1,VLOOKUP(F11,'Feed Library'!C5:F80,3,FALSE),(VLOOKUP(F11,'Feed Library'!C5:F80,3,FALSE)*(AO13/(AO17+AO13)))+(VLOOKUP(F12,'Feed Library'!C5:F80,3,FALSE)*(AO17/(AO17+AO13))))","v":9},null,{"$f":"ABS(AM23-AL25)","v":17.3},{"$f":"AN21/(AN21+AN25)","v":0.91052631578947374},null,null,null,"Final Diet",{"$f":"D29","v":0.23938947368421051},null,{"$f":"ABS(AU22-AT23)","v":38.56639736842105},{"$f":"AV21/AV24","v":0.99498941953551323},{"$f":"AW21*2002","v":1991.9688179100974},null,{"$f":"((AW21*AT21)+(AW23*AT23))/D29","v":1.8112852871339371}]
[null,"$/hd/d",null,{"$f":"(D21/2000)*J21","v":1.0349019607843135},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-500      ADG-1.25",2.4799999999999999E-2,10.5,60.5,0.39,0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D30*1.5","v":0.4336026315789473}]
[null,"Ca:P",null,{"$f":"D19/D20","v":1.116883116883117},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-500      ADG-1.50",2.52E-2,11.2,63,0.43,0.22,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(((VLOOKUP(D6,U12:X65,3,FALSE)-(VLOOKUP(F10,'Feed Library'!C5:F80,3,FALSE)*G18))))/(1-D10)","v":10.7},null,null,null,null,null,"Limestone",39,null,{"$f":"ABS(AU22-AT21)","v":0.19421315789473678},{"$f":"AV23/AV24","v":5.0105804644867353E-3},{"$f":"AW23*2000","v":10.021160928973471}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-500      ADG-1.75",2.52E-2,12.2,65.5,0.48,0.24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AV21:AV23)","v":38.760610526315787}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-500      ADG-2.00",2.52E-2,12.9,68,0.53,0.26,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F13,'Feed Library'!C5:F80,3,FALSE)","v":28},null,{"$f":"ABS(AM23-AL21)","v":1.6999999999999993},{"$f":"AN25/(AN25+AN21)","v":8.9473684210526275E-2}]
[null,"CHEMICAL COMPOSITION",null,null,null,"FINAL DIET",null,null,null," -----Total Mixed Ration-----",null,null,"Grazing or Free Choice Forage",null,null,null,null,null,null,null,"BW-500      ADG-2.25",2.52E-2,13.75,70.5,0.57999999999999996,0.28000000000000003]
[null,"TDN",null,{"$f":"(VLOOKUP(F10,'Feed Library'!C5:F80,4,FALSE)*G28)+(AL13*G29)+(AL17*G30)+(VLOOKUP(F13,'Feed Library'!C5:F80,4,FALSE)*G31)","v":67.871052631578948},null,"Ingredient","DM %","AF %","lb/ton","lb/hd/d","lb/group/d","lb/ton","lb/hd/d","lb/group/d",null,null,null,null,null,null,"BW-500      ADG-2.50",2.52E-2,14.6,73,0.63,0.3]
[null,"CP",null,{"$f":"(VLOOKUP(F28,'Feed Library'!C5:F80,3,FALSE)*G28)+(VLOOKUP(F29,'Feed Library'!C5:F80,3,FALSE)*G29)+(VLOOKUP(F30,'Feed Library'!C5:F80,3,FALSE)*G30)+(VLOOKUP(F31,'Feed Library'!C5:F80,3,FALSE)*G31)","v":10.7},1,{"$f":"F10","v":"BLANK"},{"$f":"D10","v":0},{"$f":"J28/J32","v":0},{"$f":"H28*2000","v":0},{"$f":"IF(D10=0,0,((G28*(J7))/(VLOOKUP(F28,'Feed Library'!C5:F80,2, FALSE)/100)))","v":0},{"$f":"J28*D4","v":0},{"$f":"(H28/($H$28+$H$30+$H$31))*2000","v":0},{"$f":"J28","v":0},{"$f":"M28*D4","v":0},null,null,null,null,null,null,"BW 600 lb"]
[null,"Ca",null,{"$f":"(VLOOKUP(F28,'Feed Library'!C5:I80,5,FALSE)*G28)+(VLOOKUP(F11,'Feed Library'!C5:I80,5,FALSE)*G29)+(VLOOKUP(F12,'Feed Library'!C5:I80,5,FALSE)*G30)+(VLOOKUP(F13,'Feed Library'!C5:I80,5,FALSE)*G31)","v":0.23938947368421051},2,{"$f":"F11","v":"Bermudagrass Hay, Average"},{"$f":"IF(AL17>1,(AO13*AO21),((1-D10)*AO21))","v":0.63736842105263158},{"$f":"J29/J32","v":0.65047297902181378},{"$f":"H29*2000","v":1300.9459580436276},{"$f":"(G29*(J7))/(VLOOKUP(F29,'Feed Library'!C5:F80,2, FALSE)/100)","v":12.177486068111454},{"$f":"J29*D4","v":608.87430340557273}," -"," -"," -",null,null,null,null,null,null,"BW-600      ADG-1.00",2.3300000000000001E-2,9.3000000000000007,58,0.31,0.17]
[null,"P",null,{"$f":"(VLOOKUP(F28,'Feed Library'!C5:I80,6,FALSE)*G28)+(VLOOKUP(F11,'Feed Library'!C5:I80,6,FALSE)*G29)+(VLOOKUP(F12,'Feed Library'!C5:I80,6,FALSE)*G30)+(VLOOKUP(F13,'Feed Library'!C5:I80,6,FALSE)*G31)","v":0.28906842105263153},3,{"$f":"F12","v":"Corn"},{"$f":"IF(AL17>1,(AO17*AO21),AO22)","v":0.2731578947368421},{"$f":"J30/J32","v":0.26328668198501987},{"$f":"H30*2000","v":526.57336397003974},{"$f":"IF(AL17>0,(G30*(J7)/(VLOOKUP(F30,'Feed Library'!C5:F80,2, FALSE)/100)),0)","v":4.9289824561403508},{"$f":"J30*D4","v":246.44912280701755},{"$f":"(H30/($H$28+$H$30+$H$31))*2000","v":1506.5312046444126},{"$f":"J30","v":4.9289824561403508},{"$f":"M30*D4","v":246.44912280701755},null,null,null,null,null,null,"BW-600      ADG-1.25",2.3650000000000001E-2,10,60.5,0.34,0.185]
[null,"$/ton",null,{"$f":"(VLOOKUP(F28,'Feed Library'!C5:I80,7,FALSE)*H28)+(VLOOKUP(F29,'Feed Library'!C5:I80,7,FALSE)*H29)+(VLOOKUP(F30,'Feed Library'!C5:I80,7,FALSE)*H30)+(VLOOKUP(F31,'Feed Library'!C5:I80,7,FALSE)*H31)","v":102.82444570439559},4,{"$f":"F13","v":"Dried Distiller's Grains"},{"$f":"AO25*(1-G28)","v":8.9473684210526275E-2},{"$f":"J31/J32","v":8.6240338993166382E-2},{"$f":"H31*2000","v":172.48067798633275},{"$f":"(G31*(J7))/(VLOOKUP(F31,'Feed Library'!C5:F80,2, FALSE)/100)","v":1.6145029239766071},{"$f":"J31*D4","v":80.725146198830359},{"$f":"(H31/($H$28+$H$30+$H$31))*2000","v":493.46879535558764},{"$f":"J31","v":1.6145029239766071},{"$f":"M31*D4","v":80.725146198830359},null,null,null,null,null,null,"BW-600      ADG-1.50",2.4E-2,10.6,63,0.38,0.2]
[null,"$/hd/d",null,{"$f":"D31/2000*J32","v":0.96248675610595114},null,"Total",{"$f":"SUM(G28:G31)","v":0.99999999999999989},{"$f":"SUM(H28:H31)","v":1},2000,18.720971448228411,936.04857241142054,2000.0000000000002,6.5434853801169579,{"$f":"SUM(N28:N31)","v":327.17426900584792},null,null,null,null,null,null,"BW-600      ADG-1.75",2.4E-2,11.3,65.5,0.42,0.215]
[null,"Ca:P",null,{"$f":"D29/D30","v":0.82814121588405598},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-600      ADG-2.00",2.4E-2,12.1,68,0.46,0.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-600      ADG-2.25",2.3650000000000001E-2,12.8,70.5,0.5,0.245]
[null,"NOT ENOUGH",null,null,"ADJUST MINERAL TO INCREASE",null,"ADJUST MINERAL TO INCREASE",null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-600      ADG-2.50",2.3300000000000001E-2,13.5,73,0.54,0.26]
[null,"ENERGY AVAILABLE",null,null," Ca:P RATIO To 1.5",null,"Ca:P RATIO TO 1.5",null,null,null,null,null,null,null,null,null,null,null,null,null,"BW 700 lb"]
[null,"IN DIET",null,null,"Limestone needed:",null,"Limestone needed:",null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-700      ADG-1.00",2.24E-2,9,58,0.28999999999999998,0.17]
[null,null,null,null,{"$f":"AX23","v":10.021160928973471},"Lb/ton TMR",{"$f":"AX14","v":5.9583687998142842},"Lb/ton TMR",null,null,null,null,null,null,null,null,null,null,null,null,"BW-700      ADG-1.25",2.1999999999999999E-2,9.6,60.5,0.315,0.18]
[null,null,null,null,{"$f":"E38/(E38+I28+I30+I31)*2000","v":28.265438949763535},"Lb/ton Grazing or FC Forage",{"$f":"G38/(G38+I18+I20)*2000","v":20.46742129864279},"Lb/ton Grazing or FC Forage",null,null,null,null,null,null,null,null,null,null,null,null,"BW-700      ADG-1.50",2.3140000000000001E-2,10.1,63,0.34,0.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-700      ADG-1.75",2.3199999999999998E-2,10.7,65.5,0.375,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-700      ADG-2.00",2.3300000000000001E-2,11.3,68,0.41,0.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-700      ADG-2.25",2.3199999999999998E-2,12,70.5,0.44,0.22500000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-700      ADG-2.50",2.3140000000000001E-2,12.7,73,0.47,0.24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW 800 lb"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-800      ADG-1.00",2.1899999999999999E-2,8.8249999999999993,58,0.28749999999999998,0.18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-800      ADG-1.75",2.2249999999999999E-2,9.375,60.5,0.30625000000000002,0.17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-800      ADG-1.50",2.2624999999999999E-2,9.9250000000000007,63,0.32500000000000001,0.19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-800      ADG-1.75",2.6499999999999999E-2,10.4625,65.5,0.35625000000000001,0.19500000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-800      ADG-2.00",2.2700000000000001E-2,11,68,0.38750000000000001,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-800      ADG-2.25",2.2620000000000001E-2,11.65,70.5,0.41125,0.216]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-800      ADG-2.50",2.256E-2,12.3,73,0.435,0.23250000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pregnant Heifers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"      PH - 1.0 lb/d",2.0199999999999999E-2,8.5,55.1,0.26,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"      PH - 1.5 lb/d",2.1100000000000001E-2,9,60,0.3,0.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"      PH - 2.0 lb/d",2.1399999999999999E-2,9.5,66,0.34,0.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lactating Heifers",2.12E-2,11,63,0.34,0.24]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User Defined",null,"-","-","-","-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Heifer Ration"]
[null,null,null,null,null,null,null,null,"Date",{"$f":"TODAY()","v":"2020-09-29"}]
[null,null,null,null,null,null,null,null,"Producer",{"$f":"D3","v":"UGA Farms"}]
[null,null,null,null,null,null,null,null,"County",{"$f":"Program!O14","v":"Simmental"}]
[null,null,null,null,null,null,null,null,"Agent",{"$f":"Program!O15","v":"Joe Angus"}]
[null,null,null,null,null,null,null,null,"Local Contact",{"$f":"Program!O16","v":"706-542-1852"},null,null,null,null,"1-800-ASK-UGA1"]
[]
[]
[null,null,null,null,null,null,null,null,"Description:",null,null,null,null,null,"REQUIREMENTS:"]
[null,null,null,null,null,null,null,null,{"$f":"C4","v":"Group Size"},50,null,null,null,null,"TDN, %",null,{"$f":"J3","v":65.5}]
[null,null,null,null,null,null,null,null,"Avg Weight",700,null,null,null,null,"CP, %",null,{"$f":"J4","v":10.7}]
[null,null,null,null,null,null,null,null,"Target Gain","BW-700      ADG-1.75",null,null,null,null,"Ca, %",null,{"$f":"J5","v":0.375}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P, %",null,{"$f":"J6","v":0.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DM Intake, lb/d",null,{"$f":"J7","v":16.239999999999998}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"CHEMICAL COMPOSITION",null,null,"RATION",null,null,null,{"$f":"J16","v":" -----Total Mixed Ration-----"},null,null,null,{"$f":"M16","v":"Grazing or Free Choice Forage"}]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B17,B27)","v":"TDN"},{"$f":"IF($D$18>($J$4-0.01),D17,D27)","v":67.871052631578948},null,{"$f":"IF($D$18>($J$4-0.01),F17,F27)","v":"Ingredient"},"DM %","AF %","lb/ton","lb/hd/d","lb/group/d","lb/ton","lb/hd/d","lb/group/d"]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B18,B28)","v":"CP"},{"$f":"IF($D$18>($J$4-0.01),D18,D28)","v":10.7},1,"BLANK",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B19,B29)","v":"Ca"},{"$f":"IF($D$18>($J$4-0.01),D19,D29)","v":0.23938947368421051},2,"Bermudagrass Hay, Average",0.63736842105263158,0.65047297902181378,1300.9459580436276,12.177486068111454,608.87430340557273," -"," -"," -"]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B20,B30)","v":"P"},{"$f":"IF($D$18>($J$4-0.01),D20,D30)","v":0.28906842105263153},3,"Corn",0.2731578947368421,0.26328668198501987,526.57336397003974,4.9289824561403508,246.44912280701755,1506.5312046444126,4.9289824561403508,246.44912280701755]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B23,B33)","v":"Ca:P"},{"$f":"IF($D$18>($J$4-0.01),D23,D33)","v":0.82814121588405598},4,{"$f":"IF($D$18>($J$4-0.01),N142,F31)","v":"Dried Distiller's Grains"},{"$f":"IF($D$18>($J$4-0.01),N142,G31)","v":8.9473684210526275E-2},{"$f":"IF($D$18>($J$4-0.01),O142,H31)","v":8.6240338993166382E-2},{"$f":"IF($D$18>($J$4-0.01),Y142,I31)","v":172.48067798633275},{"$f":"IF($D$18>($J$4-0.01),Z142,J31)","v":1.6145029239766071},{"$f":"IF($D$18>($J$4-0.01),AA121,K31)","v":80.725146198830359},{"$f":"IF($D$18>($J$4-0.01),Y142,L31)","v":493.46879535558764},{"$f":"IF($D$18>($J$4-0.01),Z142,M31)","v":1.6145029239766071},{"$f":"IF($D$18>($J$4-0.01),AB121,N31)","v":80.725146198830359}]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B21,B31)","v":"$/ton"},{"$f":"IF($D$18>($J$4-0.01),D21,D31)","v":102.82444570439559},null,"Total",{"$f":"SUM(M117:M120)","v":0.99999999999999989},1,2000,18.720971448228411,936.04857241142054,2000.0000000000002,6.5434853801169579,327.17426900584792,null,null,null,null,null,null," -"," -"," -"]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B22,B32)","v":"$/hd/d"},{"$f":"IF($D$18>($J$4-0.01),D22,D32)","v":0.96248675610595114}]
[]
[null,null,null,null,null,null,null,null,"Limestone needed:",null,null,"Limestone needed:"]
[null,null,null,null,null,null,null,null,{"$f":"G38","v":5.9583687998142842},{"$f":"H38","v":"Lb/ton TMR"},null,{"$f":"E38","v":10.021160928973471},{"$f":"F38","v":"Lb/ton TMR"}]
[null,null,null,null,null,null,null,null,{"$f":"G39","v":20.46742129864279},{"$f":"H39","v":"Lb/ton Grazing or FC Forage"},null,{"$f":"E39","v":28.265438949763535},{"$f":"F39","v":"Lb/ton Grazing or FC Forage"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Notes:"]
[null,null,null,null,null,null,null,null,"•",{"$f":"IF(L3=\"\",\"\",L3)","v":""}]
[null,null,null,null,null,null,null,null,"•",""]
[null,null,null,null,null,null,null,null,"•",""]
[null,null,null,null,null,null,null,null,"•",""]
[null,null,null,null,null,null,null,null,"•",""]
[null,null,null,null,null,null,null,null,"•",""]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," -"," -"," -"," -"," -",null,null,null,null,null,null," -"," -"]

{"sheet":"Feeder Stocker","index":6,"n_rows":142,"n_cols":52,"rows_kept":142,"cut":false,"hidden":false,"merged":[[136,9,136,18],[131,9,131,18],[132,9,132,18],[133,9,133,18],[134,9,134,18],[135,9,135,18]]}
[null,null,"UGA Basic Balancer - Feeder/Stocker Cattle"]
[null,null,"Description",null,null,null,null,null,"REQUIREMENTS:",null,"Notes:"]
[null,null,"Farm","UGA Farms",null,null,null,null,"TDN, %",{"$f":"VLOOKUP(D6,U12:Z45,4,FALSE)","v":67.5},"•"]
[null,null,"Group Size",500,null,null,null,null,"CP, %",{"$f":"VLOOKUP(D6,U12:Z45,3,FALSE)","v":11.4},"•"]
[null,null,"Avg Weight",500,null,null,null,null,"Ca, %",{"$f":"VLOOKUP(D6,U10:Z45,5,FALSE)","v":0.47},"•"]
[null,null,"Target Gain","BW-500      ADG-2.0",null,null,null,null,"P, %",{"$f":"VLOOKUP(D6,U12:Z45,6,FALSE)","v":0.24},"•"]
[null,null,null,null,null,null,null,null,"DM Intake, lb/d",{"$f":"VLOOKUP(D6,U12:Z45,2,FALSE)*D5","v":13.100000000000001},"•"]
[null,null,null,null,null,null,null,null,null,null,"•"]
[null,"Diet Formulation",null,null,null,"Ingredient","TDN, %","CP, %",null,null,null,null,null,null,null,null,null,null,null,null,null,"Requirements"]
[null,1,"Constant ingredient (% DM)",0,null,"BLANK",{"$f":"VLOOKUP(F10,'Feed Library'!C5:F80,4,FALSE)","v":0.1},{"$f":"VLOOKUP(F10,'Feed Library'!C5:F80,3,FALSE)","v":0.1},null,null,null,null,null,null,null,null,null,null,null,null,"ADG","DM Intake","CP","TDN","Ca","P"]
[null,2,"Forage/Roughage",null,null,"Ryegrass Baleage - Mature",{"$f":"VLOOKUP(F11,'Feed Library'!C5:F80,4,FALSE)","v":58},{"$f":"VLOOKUP(F11,'Feed Library'!C5:F80,3,FALSE)","v":12},null,"NO SUPPLEMENT NEEDED:",null,null,null,null,null,null,null,null,null,null,"BW 400 lb",null,null,null,null,null,null,null,null,null,null,null,null,"Brood Cow",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% of ration","lb/ton"]
[null,3,"Energy Source",null,null,"Soybean Hulls",{"$f":"VLOOKUP(F12,'Feed Library'!C5:F80,4,FALSE)","v":78},{"$f":"VLOOKUP(F12,'Feed Library'!C5:F80,3,FALSE)","v":12},null,"FORAGE MEETS ",null,null,null,null,null,null,null,null,null,null,"BW-400      ADG-1.0",2.5999999999999999E-2,10.3,58.5,0.38,0.21,null,null,null,null,null,null,null,"Heifer",null,null,null,null,null,null,"% in diet",null,null,null,"Base Diet",{"$f":"D20","v":0.27875},null,{"$f":"ABS(AU13-AT14)","v":38.581874999999997},{"$f":"AV12/AV15","v":0.99640055525066984},{"$f":"AW12*2002","v":1994.7939116118409},null,{"$f":"((AW12*AT12)+(AW14*AT14))/D20","v":1.5}]
[null,4,"Protein Source",null,null,"Corn Gluten Feed",{"$f":"VLOOKUP(F13,'Feed Library'!C5:F80,4,FALSE)","v":83},{"$f":"VLOOKUP(F13,'Feed Library'!C5:F80,3,FALSE)","v":21},null,"NUTRIENT REQUIREMENTS!",null,null,null,null,null,null,null,null,null,null,"BW-400      ADG-1.5",2.7E-2,11.5,63,0.47,0.25,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F11,'Feed Library'!C5:F80,4,FALSE)","v":58},null,{"$f":"ABS(AM15-AL17)","v":10.5},{"$f":"(AN13/(AN13+AN17))*(1-G18)","v":0.52500000000000002},null,null,null,null,null,{"$f":"D20*1.5","v":0.41812499999999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-400      ADG-2.0",2.75E-2,12.7,67.5,0.56000000000000005,0.26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Limestone",39,null,{"$f":"ABS(AU13-AT12)","v":0.13937499999999997},{"$f":"AV14/AV15","v":3.5994447493301477E-3},{"$f":"AW14*2000","v":7.1988894986602956}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-400      ADG-2.5",2.75E-2,14.2,73.5,0.68,0.3,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"((VLOOKUP(D6,U12:X45,4,FALSE)-(VLOOKUP(F10,'Feed Library'!C5:F80,4,FALSE)*G18)))/(1-D10)","v":67.5},null,null,null,null,null,null,null,null,{"$f":"SUM(AV12:AV14)","v":38.721249999999998}]
[null,"CHEMICAL COMPOSITION",null,null,null,"BASE DIET",null,null,null," -----Total Mixed Ration-----",null,null,"Grazing or Free Choice Forage",null,null,null,null,null,null,null,"BW-400      ADG-3.0",2.5000000000000001E-2,16.600000000000001,85,0.86,0.37]
[null,"TDN",null,{"$f":"((VLOOKUP(F18,'Feed Library'!C5:F80,4,FALSE)*G18)+(AL13*G19)+(AL17*G20))","v":67.5},null,"Ingredient","DM %","AF %","lb/ton","lb/hd/d","lb/group/d","lb/ton","lb/hd/d","lb/group/d",null,null,null,null,null,null,"BW 500 lb",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F12,'Feed Library'!C5:F80,4,FALSE)","v":78},null,{"$f":"ABS(AM15-AL13)","v":9.5},{"$f":"(AN17/(AN17+AN13))*(1-G18)","v":0.47499999999999998}]
[null,"CP",null,{"$f":"(VLOOKUP(F18,'Feed Library'!C5:F80,3,FALSE)*G18)+(VLOOKUP(F19,'Feed Library'!C5:F80,3,FALSE)*G19)+(VLOOKUP(F20,'Feed Library'!C5:F80,3,FALSE)*G20)","v":12},1,{"$f":"F10","v":"BLANK"},{"$f":"D10","v":0},{"$f":"J18/J21","v":0},{"$f":"H18*2000","v":0},{"$f":"IF(D10=0,0,((G18*(J7))/(VLOOKUP(F18,'Feed Library'!C5:F80,2, FALSE)/100)))","v":0},{"$f":"J18*D4","v":0},{"$f":"IF(H18=0,0,((H18/(H18+H20))*2000))","v":0},{"$f":"J18","v":0},{"$f":"M18*D4","v":0},null,null,null,null,null,null,"BW-500      ADG-1.0",2.46E-2,9.5,58.5,0.32,0.2]
[null,"Ca",null,{"$f":"(VLOOKUP(F18,'Feed Library'!C5:I80,5,FALSE)*G18)+(VLOOKUP(F19,'Feed Library'!C5:I80,5,FALSE)*G19)+(VLOOKUP(F20,'Feed Library'!C5:I80,5,FALSE)*G20)","v":0.57624999999999993},2,{"$f":"F11","v":"Ryegrass Baleage - Mature"},{"$f":"IF(AL17>1,AO13,(1-D10))","v":0.52500000000000002},{"$f":"J19/J21","v":0.66549295774647899},{"$f":"H19*2000","v":1330.9859154929579},{"$f":"G19*(J7)/(VLOOKUP(F19,'Feed Library'!C5:F80,2, FALSE)/100)","v":13.755000000000003},{"$f":"J19*D4","v":6877.5000000000009}," -"," -"," -",null,null,null,null,null,null,"BW-500      ADG-1.5",2.5600000000000001E-2,10.5,63,0.4,0.22]
[null,"P",null,{"$f":"(VLOOKUP(F18,'Feed Library'!C5:I80,6,FALSE)*G18)+(VLOOKUP(F19,'Feed Library'!C5:I80,6,FALSE)*G19)+(VLOOKUP(F20,'Feed Library'!C5:I80,6,FALSE)*G20)","v":0.27875},3,{"$f":"F12","v":"Soybean Hulls"},{"$f":"IF(AL17>1,AO17,0)","v":0.47499999999999998},{"$f":"J20/J21","v":0.33450704225352107},{"$f":"H20*2000","v":669.01408450704218},{"$f":"IF(AL17>0,(G20*(J7)/(VLOOKUP(F20,'Feed Library'!C5:F80,2, FALSE)/100)),0)","v":6.9138888888888888},{"$f":"J20*D4","v":3456.9444444444443},{"$f":"IF(H20=0,0,((H20/(H18+H20))*2000))","v":2000},{"$f":"J20","v":6.9138888888888888},{"$f":"M20*D4","v":3456.9444444444443},null,null,null,null,null,null,"BW-500      ADG-2.0",2.6200000000000001E-2,11.4,67.5,0.47,0.24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"% in diet"]
[null,"$/ton",null,{"$f":"(VLOOKUP(F18,'Feed Library'!C5:I80,7,FALSE)*H18)+(VLOOKUP(F19,'Feed Library'!C5:I80,7,FALSE)*H19)+(VLOOKUP(F20,'Feed Library'!C5:I80,7,FALSE)*H20)","v":81.848591549295776},null,"Total",{"$f":"SUM(G18:G20)","v":1},1,2000,{"$f":"SUM(J18:J20)","v":20.66888888888889},10334.444444444445,2000,{"$f":"SUM(M18:M20)","v":6.9138888888888888},{"$f":"SUM(N18:N20)","v":3456.9444444444443},null,null,null,null,null,null,"BW-500      ADG-2.5",2.5999999999999999E-2,12.5,73.5,0.56000000000000005,0.27,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AL17=0.1,VLOOKUP(F11,'Feed Library'!C5:F80,3,FALSE),(VLOOKUP(F11,'Feed Library'!C5:F80,3,FALSE)*(AO13/(AO17+AO13)))+(VLOOKUP(F12,'Feed Library'!C5:F80,3,FALSE)*(AO17/(AO17+AO13))))","v":12},null,{"$f":"ABS(AM23-AL25)","v":9.6},{"$f":"AN21/(AN21+AN25)","v":0.94117647058823528},null,null,null,"Final Diet",{"$f":"D29","v":0.54705882352941182},null,{"$f":"ABS(AU22-AT23)","v":38.558823529411768},{"$f":"AV21/AV24","v":0.99726152441807381},{"$f":"AW21*2002","v":1996.5175718849837},null,{"$f":"((AW21*AT21)+(AW23*AT23))/D29","v":1.1924883320328028}]
[null,"$/hd/d",null,{"$f":"(D21/2000)*J21","v":0.84585972222222228},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-500      ADG-3.0",2.3599999999999999E-2,14.4,85,0.69,0.32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D30*1.5","v":0.44117647058823523}]
[null,"Ca:P",null,{"$f":"D19/D20","v":2.0672645739910314},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW 600 lb",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(((VLOOKUP(D6,U12:X45,3,FALSE)-(VLOOKUP(F10,'Feed Library'!C5:F80,3,FALSE)*G18))))/(1-D10)","v":11.4},null,null,null,null,null,"Limestone",39,null,{"$f":"ABS(AU22-AT21)","v":0.10588235294117659},{"$f":"AV23/AV24","v":2.738475581926064E-3},{"$f":"AW23*2000","v":5.476951163852128}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-600      ADG-1.0",2.35E-2,9,58.5,0.28000000000000003,0.19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AV21:AV23)","v":38.664705882352948}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-600      ADG-1.5",2.4500000000000001E-2,9.8000000000000007,63,0.35,0.21,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(F13,'Feed Library'!C5:F80,3,FALSE)","v":21},null,{"$f":"ABS(AM23-AL21)","v":0.59999999999999964},{"$f":"AN25/(AN25+AN21)","v":5.8823529411764677E-2}]
[null,"CHEMICAL COMPOSITION",null,null,null,"FINAL DIET",null,null,null," -----Total Mixed Ration-----",null,null,"Grazing or Free Choice Forage",null,null,null,null,null,null,null,"BW-600      ADG-2.0",2.5000000000000001E-2,10.5,67.5,0.4,0.22]
[null,"TDN",null,{"$f":"(VLOOKUP(F10,'Feed Library'!C5:F80,4,FALSE)*G28)+(AL13*G29)+(AL17*G30)+(VLOOKUP(F13,'Feed Library'!C5:F80,4,FALSE)*G31)","v":68.411764705882348},null,"Ingredient","DM %","AF %","lb/ton","lb/hd/d","lb/group/d","lb/ton","lb/hd/d","lb/group/d",null,null,null,null,null,null,"BW-600      ADG-2.5",2.4799999999999999E-2,11.4,73.5,0.46,0.24]
[null,"CP",null,{"$f":"(VLOOKUP(F28,'Feed Library'!C5:F80,3,FALSE)*G28)+(VLOOKUP(F29,'Feed Library'!C5:F80,3,FALSE)*G29)+(VLOOKUP(F30,'Feed Library'!C5:F80,3,FALSE)*G30)+(VLOOKUP(F31,'Feed Library'!C5:F80,3,FALSE)*G31)","v":12.52941176470588},1,{"$f":"F10","v":"BLANK"},{"$f":"D10","v":0},{"$f":"J28/J32","v":0},{"$f":"H28*2000","v":0},{"$f":"IF(D10=0,0,((G28*(J7))/(VLOOKUP(F28,'Feed Library'!C5:F80,2, FALSE)/100)))","v":0},{"$f":"J28*D4","v":0},{"$f":"(H28/($H$28+$H$30+$H$31))*2000","v":0},{"$f":"J28","v":0},{"$f":"M28*D4","v":0},null,null,null,null,null,null,"BW-600      ADG-3.0",2.2499999999999999E-2,12.9,85,0.56999999999999995,0.28999999999999998]
[null,"Ca",null,{"$f":"(VLOOKUP(F28,'Feed Library'!C5:I80,5,FALSE)*G28)+(VLOOKUP(F11,'Feed Library'!C5:I80,5,FALSE)*G29)+(VLOOKUP(F12,'Feed Library'!C5:I80,5,FALSE)*G30)+(VLOOKUP(F13,'Feed Library'!C5:I80,5,FALSE)*G31)","v":0.54705882352941182},2,{"$f":"F11","v":"Ryegrass Baleage - Mature"},{"$f":"IF(AL17>1,(AO13*AO21),((1-D10)*AO21))","v":0.49411764705882355},{"$f":"J29/J32","v":0.63743676222596968},{"$f":"H29*2000","v":1274.8735244519394},{"$f":"(G29*(J7))/(VLOOKUP(F29,'Feed Library'!C5:F80,2, FALSE)/100)","v":12.945882352941178},{"$f":"J29*D4","v":6472.9411764705892}," -"," -"," -",null,null,null,null,null,null,"BW 700 lb"]
[null,"P",null,{"$f":"(VLOOKUP(F28,'Feed Library'!C5:I80,6,FALSE)*G28)+(VLOOKUP(F11,'Feed Library'!C5:I80,6,FALSE)*G29)+(VLOOKUP(F12,'Feed Library'!C5:I80,6,FALSE)*G30)+(VLOOKUP(F13,'Feed Library'!C5:I80,6,FALSE)*G31)","v":0.29411764705882348},3,{"$f":"F12","v":"Soybean Hulls"},{"$f":"IF(AL17>1,(AO17*AO21),AO22)","v":0.44705882352941173},{"$f":"J30/J32","v":0.32040472175379425},{"$f":"H30*2000","v":640.80944350758853},{"$f":"IF(AL17>0,(G30*(J7)/(VLOOKUP(F30,'Feed Library'!C5:F80,2, FALSE)/100)),0)","v":6.5071895424836601},{"$f":"J30*D4","v":3253.5947712418301},{"$f":"(H30/($H$28+$H$30+$H$31))*2000","v":1767.4418604651164},{"$f":"J30","v":6.5071895424836601},{"$f":"M30*D4","v":3253.5947712418301},null,null,null,null,null,null,"BW-700      ADG-1.0",2.2599999999999999E-2,8.6,58.5,0.27,0.18]
[null,"$/ton",null,{"$f":"(VLOOKUP(F28,'Feed Library'!C5:I80,7,FALSE)*H28)+(VLOOKUP(F29,'Feed Library'!C5:I80,7,FALSE)*H29)+(VLOOKUP(F30,'Feed Library'!C5:I80,7,FALSE)*H30)+(VLOOKUP(F31,'Feed Library'!C5:I80,7,FALSE)*H31)","v":85.986509274873512},4,{"$f":"F13","v":"Corn Gluten Feed"},{"$f":"AO25*(1-G28)","v":5.8823529411764677E-2},{"$f":"J31/J32","v":4.2158516020236063E-2},{"$f":"H31*2000","v":84.317032040472128},{"$f":"(G31*(J7))/(VLOOKUP(F31,'Feed Library'!C5:F80,2, FALSE)/100)","v":0.85620915032679701},{"$f":"J31*D4","v":428.10457516339852},{"$f":"(H31/($H$28+$H$30+$H$31))*2000","v":232.55813953488359},{"$f":"J31","v":0.85620915032679701},{"$f":"M31*D4","v":428.10457516339852},null,null,null,null,null,null,"BW-700      ADG-1.5",2.3599999999999999E-2,9.1999999999999993,63,0.31,0.2]
[null,"$/hd/d",null,{"$f":"D31/2000*J32","v":0.87316209150326796},null,"Total",{"$f":"SUM(G28:G31)","v":1},{"$f":"SUM(H28:H31)","v":1},2000.0000000000002,20.309281045751636,10154.640522875818,2000,7.3633986928104571,{"$f":"SUM(N28:N31)","v":3681.6993464052284},null,null,null,null,null,null,"BW-700      ADG-2.0",2.4E-2,9.8000000000000007,67.5,0.34,0.21]
[null,"Ca:P",null,{"$f":"D29/D30","v":1.8600000000000005},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-700      ADG-2.5",2.3900000000000001E-2,10.5,73.5,0.4,0.22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-700      ADG-3.0",2.1700000000000001E-2,11.7,85,0.49,0.26]
[null,"NOT ENOUGH",null,null,"ADJUST MINERAL TO INCREASE",null,"ADJUST MINERAL TO INCREASE",null,null,null,null,null,null,null,null,null,null,null,null,null,"BW 800+ lb"]
[null,"ENERGY AVAILABLE",null,null," Ca:P RATIO To 1.5",null,"Ca:P RATIO TO 1.5",null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-800+      ADG-1.0",2.1899999999999999E-2,8,58.5,0.23,0.18]
[null,"IN DIET",null,null,"Limestone needed:",null,"Limestone needed:",null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-800+      ADG-1.5",2.2800000000000001E-2,8.4,63,0.25,0.19]
[null,null,null,null,{"$f":"AX23","v":5.476951163852128},"Lb/ton TMR",{"$f":"AX14","v":7.1988894986602956},"Lb/ton TMR",null,null,null,null,null,null,null,null,null,null,null,null,"BW-800+      ADG-2.0",2.3300000000000001E-2,8.8000000000000007,67.5,0.28000000000000003,0.2]
[null,null,null,null,{"$f":"E38/(E38+I28+I30+I31)*2000","v":14.992952301089513},"Lb/ton Grazing or FC Forage",{"$f":"G38/(G38+I18+I20)*2000","v":21.29178165871626},"Lb/ton Grazing or FC Forage",null,null,null,null,null,null,null,null,null,null,null,null,"BW-800+      ADG-2.5",2.3099999999999999E-2,9.3000000000000007,73.5,0.31,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BW-800+      ADG-3.0",2.1000000000000001E-2,10.1,85,0.37,0.23]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"User Defined",null," -"," -"," -"," -"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Stocker Ration"]
[null,null,null,null,null,null,null,null,"Date",{"$f":"TODAY()","v":"2020-09-29"}]
[null,null,null,null,null,null,null,null,"Producer",{"$f":"D3","v":"UGA Farms"}]
[null,null,null,null,null,null,null,null,"County",{"$f":"Program!O14","v":"Simmental"}]
[null,null,null,null,null,null,null,null,"Agent",{"$f":"Program!O15","v":"Joe Angus"}]
[null,null,null,null,null,null,null,null,"Local Contact",{"$f":"Program!O16","v":"706-542-1852"},null,null,null,null,"1-800-ASK-UGA1"]
[]
[]
[null,null,null,null,null,null,null,null,"Description:",null,null,null,null,null,"REQUIREMENTS:"]
[null,null,null,null,null,null,null,null,{"$f":"C4","v":"Group Size"},500,null,null,null,null,"TDN, %",null,{"$f":"J3","v":67.5}]
[null,null,null,null,null,null,null,null,"Avg Weight",500,null,null,null,null,"CP, %",null,{"$f":"J4","v":11.4}]
[null,null,null,null,null,null,null,null,"Target Gain","BW-500      ADG-2.0",null,null,null,null,"Ca, %",null,{"$f":"J5","v":0.47}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P, %",null,{"$f":"J6","v":0.24}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DM Intake, lb/d",null,{"$f":"J7","v":13.100000000000001}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"CHEMICAL COMPOSITION",null,null,"RATION",null,null,null,{"$f":"J16","v":" -----Total Mixed Ration-----"},null,null,null,{"$f":"M16","v":"Grazing or Free Choice Forage"}]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B17,B27)","v":"TDN"},{"$f":"IF($D$18>($J$4-0.01),D17,D27)","v":67.5},null,{"$f":"IF($D$18>($J$4-0.01),F17,F27)","v":"Ingredient"},"DM %","AF %","lb/ton","lb/hd/d","lb/group/d","lb/ton","lb/hd/d","lb/group/d"]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B18,B28)","v":"CP"},{"$f":"IF($D$18>($J$4-0.01),D18,D28)","v":12},1,"BLANK",0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B19,B29)","v":"Ca"},{"$f":"IF($D$18>($J$4-0.01),D19,D29)","v":0.57624999999999993},2,"Ryegrass Baleage - Mature",0.52500000000000002,0.66549295774647899,1330.9859154929579,13.755000000000003,6877.5000000000009," -"," -"," -"]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B20,B30)","v":"P"},{"$f":"IF($D$18>($J$4-0.01),D20,D30)","v":0.27875},3,"Soybean Hulls",0.47499999999999998,0.33450704225352107,669.01408450704218,6.9138888888888888,3456.9444444444443,2000,6.9138888888888888,3456.9444444444443]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B23,B33)","v":"Ca:P"},{"$f":"IF($D$18>($J$4-0.01),D23,D33)","v":2.0672645739910314},4,{"$f":"IF($D$18>($J$4-0.01),N142,F31)","v":" -"},{"$f":"IF($D$18>($J$4-0.01),N142,G31)","v":" -"},{"$f":"IF($D$18>($J$4-0.01),O142,H31)","v":" -"},{"$f":"IF($D$18>($J$4-0.01),Y122,I31)","v":" -"},{"$f":"IF($D$18>($J$4-0.01),Z122,J31)","v":" -"},{"$f":"IF($D$18>($J$4-0.01),AA121,K31)","v":" -"},{"$f":"IF($D$18>($J$4-0.01),Y122,L31)","v":" -"},{"$f":"IF($D$18>($J$4-0.01),Z122,M31)","v":" -"},{"$f":"IF($D$18>($J$4-0.01),AB121,N31)","v":" -"}]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B21,B31)","v":"$/ton"},{"$f":"IF($D$18>($J$4-0.01),D21,D31)","v":81.848591549295776},null,"Total",{"$f":"SUM(M117:M120)","v":1},1,2000,20.66888888888889,10334.444444444445,2000,6.9138888888888888,3456.9444444444443,null,null,null,null,null,null," -"," -"," -"]
[null,null,null,null,null,null,null,null,{"$f":"IF($D$18>($J$4-0.01),B22,B32)","v":"$/hd/d"},{"$f":"IF($D$18>($J$4-0.01),D22,D32)","v":0.84585972222222228},null,null,null,null,null,null,null,null,null,null,null,null,null,null," -"," -"]
[]
[null,null,null,null,null,null,null,null,"Limestone needed:",null,null,"Limestone needed:"]
[null,null,null,null,null,null,null,null,{"$f":"G38","v":7.1988894986602956},{"$f":"H38","v":"Lb/ton TMR"},null,{"$f":"E38","v":5.476951163852128},{"$f":"F38","v":"Lb/ton TMR"}]
[null,null,null,null,null,null,null,null,{"$f":"G39","v":21.29178165871626},{"$f":"H39","v":"Lb/ton Grazing or FC Forage"},null,{"$f":"E39","v":14.992952301089513},{"$f":"F39","v":"Lb/ton Grazing or FC Forage"}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Notes:"]
[null,null,null,null,null,null,null,null,"•",{"$f":"IF(L3=\"\",\"\",L3)","v":""}]
[null,null,null,null,null,null,null,null,"•",""]
[null,null,null,null,null,null,null,null,"•",""]
[null,null,null,null,null,null,null,null,"•",""]
[null,null,null,null,null,null,null,null,"•",""]
[null,null,null,null,null,null,null,null,"•",""]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null," -"," -"," -"," -"," -"]

{"sheet":"Analyzer","index":7,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,13,3,14],[3,2,3,3],[3,4,3,5],[3,11,3,12]]}
[null,"Ration Analyzer"]
[]
[null,"Ration 1",null,null,null,null,null,null,null,null,"Ration 2"]
[null,null,"As Fed",null,"Dry Matter",null,null,"Diet Analysis",null,null,null,"As Fed",null,"Dry Matter",null,null,"Diet Analysis"]
[null,"Ingredients","lb/ton, lb/hd, or %"," %","lb","% of ration",null,"Item","%",null,"Ingredients","lb/ton, lb/hd, or %"," %","lb","% of ration",null,"Item","%"]
[null,"Dried Distiller's Grains",0,{"$f":"$C6/SUM($C$6:$C$15)","v":0},{"$f":"C6*(VLOOKUP(B6,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},{"$f":"$E6/SUM($E$6:$E$15)","v":0},null,"DM",{"$f":"(VLOOKUP(B6,'Feed Library'!C5:I80,2,FALSE)*F6)+(VLOOKUP(B7,'Feed Library'!C5:I80,2,FALSE)*F7)+(VLOOKUP(B8,'Feed Library'!C5:I80,2,FALSE)*F8)+(VLOOKUP(B9,'Feed Library'!C5:I80,2,FALSE)*F9)+(VLOOKUP(B10,'Feed Library'!C5:I80,2,FALSE)*F10)+(VLOOKUP(B11,'Feed Library'!C5:I80,2,FALSE)*F11)+(VLOOKUP(B12,'Feed Library'!C5:I80,2,FALSE)*F12)+(VLOOKUP(B13,'Feed Library'!C5:I80,2,FALSE)*F13)+(VLOOKUP(B14,'Feed Library'!C5:I80,2,FALSE)*F14)+(VLOOKUP(B15,'Feed Library'!C5:I80,2,FALSE)*F15)","v":90},null,"Bermudagrass Hay, Average",1000,{"$f":"$L6/SUM($L$6:$L$15)","v":0.49627791563275436},{"$f":"L6*(VLOOKUP(K6,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":850},{"$f":"$N6/SUM($N$6:$N$15)","v":0.4816273337677423},null,"DM",{"$f":"(VLOOKUP(K6,'Feed Library'!C5:I80,2,FALSE)*O6)+(VLOOKUP(K7,'Feed Library'!C5:I80,2,FALSE)*O7)+(VLOOKUP(K8,'Feed Library'!C5:I80,2,FALSE)*O8)+(VLOOKUP(K9,'Feed Library'!C5:I80,2,FALSE)*O9)+(VLOOKUP(K10,'Feed Library'!C5:I80,2,FALSE)*O10)+(VLOOKUP(K11,'Feed Library'!C5:I80,2,FALSE)*O11)+(VLOOKUP(K12,'Feed Library'!C5:I80,2,FALSE)*O12)+(VLOOKUP(K13,'Feed Library'!C5:I80,2,FALSE)*O13)+(VLOOKUP(K14,'Feed Library'!C5:I80,2,FALSE)*O14)+(VLOOKUP(K15,'Feed Library'!C5:I80,2,FALSE)*O15)","v":87.667592146641354}]
[null,"Salt",0,0,{"$f":"C7*(VLOOKUP(B7,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},0,null,"CP",{"$f":"(VLOOKUP(B6,'Feed Library'!C5:I80,3,FALSE)*F6)+(VLOOKUP(B7,'Feed Library'!C5:I80,3,FALSE)*F7)+(VLOOKUP(B8,'Feed Library'!C5:I80,3,FALSE)*F8)+(VLOOKUP(B9,'Feed Library'!C5:I80,3,FALSE)*F9)+(VLOOKUP(B10,'Feed Library'!C5:I80,3,FALSE)*F10)+(VLOOKUP(B11,'Feed Library'!C5:I80,3,FALSE)*F11)+(VLOOKUP(B12,'Feed Library'!C5:I80,3,FALSE)*F12)+(VLOOKUP(B13,'Feed Library'!C5:I80,3,FALSE)*F13)+(VLOOKUP(B14,'Feed Library'!C5:I80,3,FALSE)*F14)+(VLOOKUP(B15,'Feed Library'!C5:I80,3,FALSE)*F15)","v":12.5},null,"Gin Trash",0,{"$f":"$L7/SUM($L$6:$L$15)","v":0},{"$f":"L7*(VLOOKUP(K7,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},{"$f":"$N7/SUM($N$6:$N$15)","v":0},null,"CP",{"$f":"(VLOOKUP(K6,'Feed Library'!C5:I80,3,FALSE)*O6)+(VLOOKUP(K7,'Feed Library'!C5:I80,3,FALSE)*O7)+(VLOOKUP(K8,'Feed Library'!C5:I80,3,FALSE)*O8)+(VLOOKUP(K9,'Feed Library'!C5:I80,3,FALSE)*O9)+(VLOOKUP(K10,'Feed Library'!C5:I80,3,FALSE)*O10)+(VLOOKUP(K11,'Feed Library'!C5:I80,3,FALSE)*O11)+(VLOOKUP(K12,'Feed Library'!C5:I80,3,FALSE)*O12)+(VLOOKUP(K13,'Feed Library'!C5:I80,3,FALSE)*O13)+(VLOOKUP(K14,'Feed Library'!C5:I80,3,FALSE)*O14)+(VLOOKUP(K15,'Feed Library'!C5:I80,3,FALSE)*O15)","v":8.7211292744425872}]
[null,"Limestone",0,0,{"$f":"C8*(VLOOKUP(B8,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},0,null,"TDN",{"$f":"(VLOOKUP(B6,'Feed Library'!C5:I80,4,FALSE)*F6)+(VLOOKUP(B7,'Feed Library'!C5:I80,4,FALSE)*F7)+(VLOOKUP(B8,'Feed Library'!C5:I80,4,FALSE)*F8)+(VLOOKUP(B9,'Feed Library'!C5:I80,4,FALSE)*F9)+(VLOOKUP(B10,'Feed Library'!C5:I80,4,FALSE)*F10)+(VLOOKUP(B11,'Feed Library'!C5:I80,4,FALSE)*F11)+(VLOOKUP(B12,'Feed Library'!C5:I80,4,FALSE)*F12)+(VLOOKUP(B13,'Feed Library'!C5:I80,4,FALSE)*F13)+(VLOOKUP(B14,'Feed Library'!C5:I80,4,FALSE)*F14)+(VLOOKUP(B15,'Feed Library'!C5:I80,4,FALSE)*F15)","v":69},null,"Corn",800,0.3970223325062035,{"$f":"L8*(VLOOKUP(K8,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":720},0.40796668272091113,null,"TDN",{"$f":"(VLOOKUP(K6,'Feed Library'!C5:I80,4,FALSE)*O6)+(VLOOKUP(K7,'Feed Library'!C5:I80,4,FALSE)*O7)+(VLOOKUP(K8,'Feed Library'!C5:I80,4,FALSE)*O8)+(VLOOKUP(K9,'Feed Library'!C5:I80,4,FALSE)*O9)+(VLOOKUP(K10,'Feed Library'!C5:I80,4,FALSE)*O10)+(VLOOKUP(K11,'Feed Library'!C5:I80,4,FALSE)*O11)+(VLOOKUP(K12,'Feed Library'!C5:I80,4,FALSE)*O12)+(VLOOKUP(K13,'Feed Library'!C5:I80,4,FALSE)*O13)+(VLOOKUP(K14,'Feed Library'!C5:I80,4,FALSE)*O14)+(VLOOKUP(K15,'Feed Library'!C5:I80,4,FALSE)*O15)","v":71.570663229169611}]
[null,"Peanut Hulls",25,0.25,{"$f":"C9*(VLOOKUP(B9,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":22.5},0.25,null,"Ca",{"$f":"(VLOOKUP(B6,'Feed Library'!C5:I80,5,FALSE)*F6)+(VLOOKUP(B7,'Feed Library'!C5:I80,5,FALSE)*F7)+(VLOOKUP(B8,'Feed Library'!C5:I80,5,FALSE)*F8)+(VLOOKUP(B9,'Feed Library'!C5:I80,5,FALSE)*F9)+(VLOOKUP(B10,'Feed Library'!C5:I80,5,FALSE)*F10)+(VLOOKUP(B11,'Feed Library'!C5:I80,5,FALSE)*F11)+(VLOOKUP(B12,'Feed Library'!C5:I80,5,FALSE)*F12)+(VLOOKUP(B13,'Feed Library'!C5:I80,5,FALSE)*F13)+(VLOOKUP(B14,'Feed Library'!C5:I80,5,FALSE)*F14)+(VLOOKUP(B15,'Feed Library'!C5:I80,5,FALSE)*F15)","v":0.46250000000000002},null,"Citrus Pulp",200,9.9255583126550875E-2,{"$f":"L9*(VLOOKUP(K9,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":180},0.10199167068022778,null,"Ca",{"$f":"(VLOOKUP(K6,'Feed Library'!C5:I80,5,FALSE)*O6)+(VLOOKUP(K7,'Feed Library'!C5:I80,5,FALSE)*O7)+(VLOOKUP(K8,'Feed Library'!C5:I80,5,FALSE)*O8)+(VLOOKUP(K9,'Feed Library'!C5:I80,5,FALSE)*O9)+(VLOOKUP(K10,'Feed Library'!C5:I80,5,FALSE)*O10)+(VLOOKUP(K11,'Feed Library'!C5:I80,5,FALSE)*O11)+(VLOOKUP(K12,'Feed Library'!C5:I80,5,FALSE)*O12)+(VLOOKUP(K13,'Feed Library'!C5:I80,5,FALSE)*O13)+(VLOOKUP(K14,'Feed Library'!C5:I80,5,FALSE)*O14)+(VLOOKUP(K15,'Feed Library'!C5:I80,5,FALSE)*O15)","v":0.6932883814488483}]
[null,"Corn Gluten Feed",25,0.25,{"$f":"C10*(VLOOKUP(B10,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":22.5},0.25,null,"P",{"$f":"(VLOOKUP(B6,'Feed Library'!C5:I80,6,FALSE)*F6)+(VLOOKUP(B7,'Feed Library'!C5:I80,6,FALSE)*F7)+(VLOOKUP(B8,'Feed Library'!C5:I80,6,FALSE)*F8)+(VLOOKUP(B9,'Feed Library'!C5:I80,6,FALSE)*F9)+(VLOOKUP(B10,'Feed Library'!C5:I80,6,FALSE)*F10)+(VLOOKUP(B11,'Feed Library'!C5:I80,6,FALSE)*F11)+(VLOOKUP(B12,'Feed Library'!C5:I80,6,FALSE)*F12)+(VLOOKUP(B13,'Feed Library'!C5:I80,6,FALSE)*F13)+(VLOOKUP(B14,'Feed Library'!C5:I80,6,FALSE)*F14)+(VLOOKUP(B15,'Feed Library'!C5:I80,6,FALSE)*F15)","v":0.29749999999999999},null,"Limestone",15,7.4441687344913151E-3,{"$f":"L10*(VLOOKUP(K10,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":14.85},8.414312831118792E-3,null,"P",{"$f":"(VLOOKUP(K6,'Feed Library'!C5:I80,6,FALSE)*O6)+(VLOOKUP(K7,'Feed Library'!C5:I80,6,FALSE)*O7)+(VLOOKUP(K8,'Feed Library'!C5:I80,6,FALSE)*O8)+(VLOOKUP(K9,'Feed Library'!C5:I80,6,FALSE)*O9)+(VLOOKUP(K10,'Feed Library'!C5:I80,6,FALSE)*O10)+(VLOOKUP(K11,'Feed Library'!C5:I80,6,FALSE)*O11)+(VLOOKUP(K12,'Feed Library'!C5:I80,6,FALSE)*O12)+(VLOOKUP(K13,'Feed Library'!C5:I80,6,FALSE)*O13)+(VLOOKUP(K14,'Feed Library'!C5:I80,6,FALSE)*O14)+(VLOOKUP(K15,'Feed Library'!C5:I80,6,FALSE)*O15)","v":0.24486415276085782}]
[null,"Limestone",0,0,{"$f":"C11*(VLOOKUP(B11,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},0,null,"Ca:P",{"$f":"I9/I10","v":1.554621848739496},null,"BLANK",0,0,{"$f":"L11*(VLOOKUP(K11,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},0,null,"Ca:P",{"$f":"R9/R10","v":2.8313184009663348}]
[null,"Soybean Hulls",25,0.25,{"$f":"C12*(VLOOKUP(B12,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":22.5},0.25,null,"$/ton",{"$f":"((VLOOKUP(B6,'Feed Library'!C5:I80,7,FALSE)*D6)+(VLOOKUP(B7,'Feed Library'!C5:I80,7,FALSE)*D7)+(VLOOKUP(B8,'Feed Library'!C5:I80,7,FALSE)*D8)+(VLOOKUP(B9,'Feed Library'!C5:I80,7,FALSE)*D9)+(VLOOKUP(B10,'Feed Library'!C5:I80,7,FALSE)*D10)+(VLOOKUP(B11,'Feed Library'!C5:I80,7,FALSE)*D11)+(VLOOKUP(B12,'Feed Library'!C5:I80,7,FALSE)*D12)+(VLOOKUP(B13,'Feed Library'!C5:I80,7,FALSE)*D13)+(VLOOKUP(B14,'Feed Library'!C5:I80,7,FALSE)*D14)+(VLOOKUP(B15,'Feed Library'!C5:I80,7,FALSE)*D15))","v":136.25},null,"BLANK",0,0,{"$f":"L12*(VLOOKUP(K12,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},0,null,"$/ton",{"$f":"((VLOOKUP(K6,'Feed Library'!C5:I80,7,FALSE)*M6)+(VLOOKUP(K7,'Feed Library'!C5:I80,7,FALSE)*M7)+(VLOOKUP(K8,'Feed Library'!C5:I80,7,FALSE)*M8)+(VLOOKUP(K9,'Feed Library'!C5:I80,7,FALSE)*M9)+(VLOOKUP(K10,'Feed Library'!C5:I80,7,FALSE)*M10)+(VLOOKUP(K11,'Feed Library'!C5:I80,7,FALSE)*M11)+(VLOOKUP(K12,'Feed Library'!C5:I80,7,FALSE)*M12)+(VLOOKUP(K13,'Feed Library'!C5:I80,7,FALSE)*M13)+(VLOOKUP(K14,'Feed Library'!C5:I80,7,FALSE)*M14)+(VLOOKUP(K15,'Feed Library'!C5:I80,7,FALSE)*M15))","v":130.95533498759306}]
[null,"Corn",25,0.25,{"$f":"C13*(VLOOKUP(B13,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":22.5},0.25,null,null,null,null,"BLANK",0,0,{"$f":"L13*(VLOOKUP(K13,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},0]
[null,"BLANK",0,0,{"$f":"C14*(VLOOKUP(B14,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},0,null,null,null,null,"BLANK",0,0,{"$f":"L14*(VLOOKUP(K14,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},0]
[null,"BLANK",0,0,{"$f":"C15*(VLOOKUP(B15,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},0,null,null,null,null,"BLANK",0,0,{"$f":"L15*(VLOOKUP(K15,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},0]
[null,"Total",{"$f":"SUM(C6:C15)","v":100},{"$f":"SUM(D6:D15)","v":1},{"$f":"SUM(E6:E15)","v":90},{"$f":"SUM(F6:F15)","v":1},null,null,null,null,"Total",{"$f":"SUM(L6:L15)","v":2015},{"$f":"SUM(M6:M15)","v":1},{"$f":"SUM(N6:N15)","v":1764.85},{"$f":"SUM(O6:O15)","v":1}]

{"sheet":"Batch Mix","index":8,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,5,3,6],[3,2,3,4]]}
[null,"Batch Mix"]
[]
[null,"Batch size, lb",2000]
[null,null,"As Fed",null,null,"Dry Matter",null,null,"Diet Analysis"]
[null,"Ingredients","lb/ton, lb/hd, or %"," %","lb/batch","lb","% of ration",null,"Item","%"]
[null,"Dried Distiller's Grains",3,{"$f":"$C6/SUM($C$6:$C$15)","v":0.88235294117647056},{"$f":"$C$3*D6","v":1764.7058823529412},{"$f":"C6*(VLOOKUP(B6,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":2.7},{"$f":"$F6/SUM($F$6:$F$15)","v":0.87209302325581395},null,"DM",{"$f":"(VLOOKUP(B6,'Feed Library'!C5:I80,2,FALSE)*G6)+(VLOOKUP(B7,'Feed Library'!C5:I80,2,FALSE)*G7)+(VLOOKUP(B8,'Feed Library'!C5:I80,2,FALSE)*G8)+(VLOOKUP(B9,'Feed Library'!C5:I80,2,FALSE)*G9)+(VLOOKUP(B10,'Feed Library'!C5:I80,2,FALSE)*G10)+(VLOOKUP(B11,'Feed Library'!C5:I80,2,FALSE)*G11)+(VLOOKUP(B12,'Feed Library'!C5:I80,2,FALSE)*G12)+(VLOOKUP(B13,'Feed Library'!C5:I80,2,FALSE)*G13)+(VLOOKUP(B14,'Feed Library'!C5:I80,2,FALSE)*G14)+(VLOOKUP(B15,'Feed Library'!C5:I80,2,FALSE)*G15)","v":91.151162790697683}]
[null,"Soybean Hulls",0,0,{"$f":"$C$3*D7","v":0},{"$f":"C7*(VLOOKUP(B7,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},0,null,"CP",{"$f":"(VLOOKUP(B6,'Feed Library'!C5:I80,3,FALSE)*G6)+(VLOOKUP(B7,'Feed Library'!C5:I80,3,FALSE)*G7)+(VLOOKUP(B8,'Feed Library'!C5:I80,3,FALSE)*G8)+(VLOOKUP(B9,'Feed Library'!C5:I80,3,FALSE)*G9)+(VLOOKUP(B10,'Feed Library'!C5:I80,3,FALSE)*G10)+(VLOOKUP(B11,'Feed Library'!C5:I80,3,FALSE)*G11)+(VLOOKUP(B12,'Feed Library'!C5:I80,3,FALSE)*G12)+(VLOOKUP(B13,'Feed Library'!C5:I80,3,FALSE)*G13)+(VLOOKUP(B14,'Feed Library'!C5:I80,3,FALSE)*G14)+(VLOOKUP(B15,'Feed Library'!C5:I80,3,FALSE)*G15)","v":24.431395348837214}]
[null,"Limestone",0.15,4.4117647058823532E-2,88.235294117647058,{"$f":"C8*(VLOOKUP(B8,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0.14849999999999999},4.7965116279069762E-2,null,"TDN",{"$f":"(VLOOKUP(B6,'Feed Library'!C5:I80,4,FALSE)*G6)+(VLOOKUP(B7,'Feed Library'!C5:I80,4,FALSE)*G7)+(VLOOKUP(B8,'Feed Library'!C5:I80,4,FALSE)*G8)+(VLOOKUP(B9,'Feed Library'!C5:I80,4,FALSE)*G9)+(VLOOKUP(B10,'Feed Library'!C5:I80,4,FALSE)*G10)+(VLOOKUP(B11,'Feed Library'!C5:I80,4,FALSE)*G11)+(VLOOKUP(B12,'Feed Library'!C5:I80,4,FALSE)*G12)+(VLOOKUP(B13,'Feed Library'!C5:I80,4,FALSE)*G13)+(VLOOKUP(B14,'Feed Library'!C5:I80,4,FALSE)*G14)+(VLOOKUP(B15,'Feed Library'!C5:I80,4,FALSE)*G15)","v":80.245348837209306}]
[null,"Basic",0.25,7.3529411764705885E-2,147.05882352941177,{"$f":"C9*(VLOOKUP(B9,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0.2475},7.9941860465116282E-2,null,"Ca",{"$f":"(VLOOKUP(B6,'Feed Library'!C5:I80,5,FALSE)*G6)+(VLOOKUP(B7,'Feed Library'!C5:I80,5,FALSE)*G7)+(VLOOKUP(B8,'Feed Library'!C5:I80,5,FALSE)*G8)+(VLOOKUP(B9,'Feed Library'!C5:I80,5,FALSE)*G9)+(VLOOKUP(B10,'Feed Library'!C5:I80,5,FALSE)*G10)+(VLOOKUP(B11,'Feed Library'!C5:I80,5,FALSE)*G11)+(VLOOKUP(B12,'Feed Library'!C5:I80,5,FALSE)*G12)+(VLOOKUP(B13,'Feed Library'!C5:I80,5,FALSE)*G13)+(VLOOKUP(B14,'Feed Library'!C5:I80,5,FALSE)*G14)+(VLOOKUP(B15,'Feed Library'!C5:I80,5,FALSE)*G15)","v":2.8735465116279069}]
[null,"Corn Gluten Feed",0,0,0,{"$f":"C10*(VLOOKUP(B10,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},0,null,"P",{"$f":"(VLOOKUP(B6,'Feed Library'!C5:I80,6,FALSE)*G6)+(VLOOKUP(B7,'Feed Library'!C5:I80,6,FALSE)*G7)+(VLOOKUP(B8,'Feed Library'!C5:I80,6,FALSE)*G8)+(VLOOKUP(B9,'Feed Library'!C5:I80,6,FALSE)*G9)+(VLOOKUP(B10,'Feed Library'!C5:I80,6,FALSE)*G10)+(VLOOKUP(B11,'Feed Library'!C5:I80,6,FALSE)*G11)+(VLOOKUP(B12,'Feed Library'!C5:I80,6,FALSE)*G12)+(VLOOKUP(B13,'Feed Library'!C5:I80,6,FALSE)*G13)+(VLOOKUP(B14,'Feed Library'!C5:I80,6,FALSE)*G14)+(VLOOKUP(B15,'Feed Library'!C5:I80,6,FALSE)*G15)","v":1.4074563953488373}]
[null,"Limestone",0,0,0,{"$f":"C11*(VLOOKUP(B11,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},0,null,"Ca:P",{"$f":"J9/J10","v":2.0416593516673034}]
[null,"BLANK",0,0,0,{"$f":"C12*(VLOOKUP(B12,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},0,null,"$/ton",{"$f":"((VLOOKUP(B6,'Feed Library'!C5:I80,7,FALSE)*D6)+(VLOOKUP(B7,'Feed Library'!C5:I80,7,FALSE)*D7)+(VLOOKUP(B8,'Feed Library'!C5:I80,7,FALSE)*D8)+(VLOOKUP(B9,'Feed Library'!C5:I80,7,FALSE)*D9)+(VLOOKUP(B10,'Feed Library'!C5:I80,7,FALSE)*D10)+(VLOOKUP(B11,'Feed Library'!C5:I80,7,FALSE)*D11)+(VLOOKUP(B12,'Feed Library'!C5:I80,7,FALSE)*D12)+(VLOOKUP(B13,'Feed Library'!C5:I80,7,FALSE)*D13)+(VLOOKUP(B14,'Feed Library'!C5:I80,7,FALSE)*D14)+(VLOOKUP(B15,'Feed Library'!C5:I80,7,FALSE)*D15))","v":43.75}]
[null,"BLANK",0,0,0,{"$f":"C13*(VLOOKUP(B13,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},0]
[null,"BLANK",0,0,0,{"$f":"C14*(VLOOKUP(B14,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},0]
[null,"BLANK",0,0,0,{"$f":"C15*(VLOOKUP(B15,'Feed Library'!$C$5:$I$80,2,FALSE)/100)","v":0},0]
[null,"Total",{"$f":"SUM(C6:C15)","v":3.4},{"$f":"SUM(D6:D15)","v":0.99999999999999989},{"$f":"SUM(E6:E15)","v":2000},{"$f":"SUM(F6:F15)","v":3.0960000000000001},{"$f":"SUM(G6:G15)","v":1}]