{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Cowculator Home","Cattle","Balancer","Feed List"," Summary","BCS","Finish Weight","Nutrient and Energy Balance","Requirement Calculator","Feed Categories"],"not_rendered":{"charts":1,"images":11,"macros":1,"external_links":5,"defined_names":142,"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":"Cowculator Home","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[7,1,7,3],[8,1,8,3],[9,1,9,3]]}
[]
[]
[]
[]
[]
[]
[]
[null,"      Oklahoma State University"]
[null,"      Department of Animal and Food Sciences"]
[null,"      M.A. Gross, D.L. Lalman, and P.A Beck"]
[]
[]
[null,null,null,null,"Copyright 2020. Oklahoma Board of Regents for A&M Colleges"]

{"sheet":"Cattle","index":1,"n_rows":51,"n_cols":23,"rows_kept":51,"cut":false,"hidden":false,"merged":[[7,7,7,9],[2,19,2,21],[4,22,4,24],[2,2,2,3],[6,1,6,2],[5,1,5,2],[3,2,3,3],[2,5,2,9],[3,5,3,9],[5,7,5,9],[6,7,6,9],[16,6,16,8],[17,6,17,8],[19,6,19,8],[20,6,20,8],[18,6,18,8]]}
[]
[]
[null,"Client","Pistol Pete, Bullet Ranch",null,"Cattle Description","Angus cows, 1200 lb, BCS = 5",null,null,null,null,null,"Stage","Days","Day in Gestation",null,null,"Class of Cattle","Ionophore","Implant","Genetic Potential for Growth and Feed Efficiency"]
[null,"Contact Info","(405) 718-2134",null,"Ration ID","2020 dry cow precalving",null,null,null,null,null,"Mid Gestation, dry Cow",95,"94-189",null,null,"Growing and Finishing Cattle","Rumensin","Yes","Above Average",0.97,null,"Adjusts to 5% below default NASEM values (NASEM equations were extremely optimistic with 750 lb steers converting at 5.2:1)"]
[null,null,null,null,null,null,null,null,null,null,null,"Late Gestation, dry Cow",95,"189-283",null,null,"Mid Gestation, Bred Heifer","Bovatec","No","Average",0.89500000000000002,null,"Adjusts to Hitch and K-State newsletter data using 2016, 2017 and 2018 closeouts"]
[null,"Select Class of Cattle",null,null,"Feeding Period, Days",null,null,null,null,null,null,"Early Lactation, Mature Cow",90,"0 - 30",null,null,"Late Gestation, Bred Heifer","Cattlyst",null,"Below Average",0.82,null,"Adjusts to below average (Hitch data)"]
[null,"Late Gestation, Dry Cow",null,null,90,null,null,null,null,null,null,"Late Lactation, Mature Cow",120,"30 - 94",null,null,"Early Lactation, First Calf Heifer","None",null,"Decision",{"$f":"VLOOKUP(F15, T4:U6, 2,)","v":0.97}]
[null,null,null,null,null,null,null,null,null,null,null,"Mid Gestation, Bred Heifer ",95,"94-189",null,null,"Mid Gestation, Dry Cow"]
[null,"Inputs for Cows, Bred Heifers and Mature Bulls",null,null,null,null,null,null,null,null,null,"Late Gestation, Bred Heifer",95,"189-283",null,null,"Late Gestation, Dry Cow"]
[null,"Number of Cattle","Initial Weight, lb","Mature Weight, lb","Expected Calf Birth Weight, lb","Genetic Potential for Milk","Peak Milk, lb/day","Initial Body Condition Score","Desired Body Condition Score",null,null,"Early Lactation, First Calf Heifer",90,"0 - 30",null,null,"Early Lactation, Mature Cow"]
[null,10,1200,1200,80,"Average",{"$f":"VLOOKUP(F11,L12:M16,2,)","v":24.229074889867842},5,5,null,null,"Productivity","Cow ","Heifer ","Milk Adjustment","Helper Cells","Late Lactation, Mature Cow"]
[null,null,null,null,null,null,null,null,null,null,null,"Low",{"$f":"($L$19/0.454)*O12","v":19.383259911894275},{"$f":"M12*0.8","v":15.50660792951542},0.8,{"$f":"VLOOKUP(F11,L12:N16,2)","v":24.229074889867842},"Mature Bulls"]
[null,"Inputs for Growing and Finishing Cattle",null,null,null,null,null,null,null,null,null,"Med Low",{"$f":"($L$19/0.454)*O13","v":21.806167400881058},{"$f":"M13*0.8","v":17.444933920704848},0.9,{"$f":"VLOOKUP(F11,L12:N16,3)","v":19.383259911894275}]
[null,"Number of Cattle","Initial Weight, lb","Desired Weight, End of Feeding Period, lb","Finish Weight, lb","Genetic Potential for Growth and Feed Efficiency","Ionophore","Implant","Initial Body Condition",null,null,"Average",{"$f":"($L$19/0.454)*O14","v":24.229074889867842},{"$f":"M14*0.8","v":19.383259911894275},1,{"$f":"IF(OR(B7=\"Mid Gestation, Dry Cow\",B7=\"Late Gestation, Dry Cow\",B7=\"Early Lactation, Dry Cow\",B7=\"Late Lactation, Mature Cow\"),P12,P13)","v":24.229074889867842}]
[null,100,818,1438,1438,"Above Average","Rumensin","Yes",6,null,null,"Med High",{"$f":"($L$19/0.454)*O15","v":26.65198237885463},{"$f":"M15*0.8","v":21.321585903083704},1.1000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,"High",{"$f":"($L$19/0.454)*O16","v":29.07488986784141},{"$f":"M16*0.8","v":23.259911894273131},1.2]
[null,"Breed","Percentage"]
[null,"Angus",1,null,null,null,null,null,null,null,null,"Breed Average Milk, kg/d","Lact Adj","Maint Adj","Maint","Adj Maint for lactation"]
[null,"Braford",null,null,null,null,null,null,null,null,null,{"$f":"R44","v":11},{"$f":"P44","v":1.2},{"$f":"N44","v":1},{"$f":"0.077*N44","v":7.6999999999999999E-2},{"$f":"O19*P44","v":9.2399999999999996E-2}]
[null,"Brahman",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maintenance, non lact","Maint, lactating"]
[null,"Brangus",null,null,null,null,null,null,null,null,null,"Breed","Breed Factor","Breed adjustment","Lactation Factor","Lactaion Adjustment","Peak Milk, kg/d ","Milk Breed adj","Column1","Column2","Column3"]
[null,"Braunvieh",null,null,null,null,null,null,null,null,null,"Angus ",1,{"$f":"C18*M22","v":1},1.2,{"$f":"Table4[[#This Row],[Lactation Factor]]*C18","v":1.2},11,{"$f":"Q22*C18","v":11},null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":77},{"$f":"((T22*160)+(T22*Table4[[#This Row],[Lactation Factor]]*205))/365","v":85.649315068493152}]
[null,"Charolais",null,null,null,null,null,null,null,null,null,"Braford",0.95,0,1.2,{"$f":"Table4[[#This Row],[Lactation Factor]]*C19","v":0},9,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":73.149999999999991},{"$f":"((T23*160)+(T23*Table4[[#This Row],[Lactation Factor]]*205))/365","v":81.366849315068478}]
[null,"Chianina",null,null,null,null,null,null,null,null,null,"Brahman",0.9,0,1.2,{"$f":"Table4[[#This Row],[Lactation Factor]]*C20","v":0},9,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":69.3},{"$f":"((T24*160)+(T24*Table4[[#This Row],[Lactation Factor]]*205))/365","v":77.084383561643833}]
[null,"Devon",null,null,null,null,null,null,null,null,null,"Brangus",0.95,0,1.2,{"$f":"Table4[[#This Row],[Lactation Factor]]*C21","v":0},10,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":73.149999999999991},{"$f":"((T25*160)+(T25*Table4[[#This Row],[Lactation Factor]]*205))/365","v":81.366849315068478}]
[null,"Gelbvieh",null,null,null,null,null,null,null,null,null,"Braunvieh",1.2,0,1,{"$f":"Table4[[#This Row],[Lactation Factor]]*C22","v":0},12,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":92.399999999999991},{"$f":"((T26*160)+(T26*Table4[[#This Row],[Lactation Factor]]*205))/365","v":92.4}]
[null,"Hereford",null,null,null,null,null,null,null,null,null,"Charolais",1,0,1.2,{"$f":"Table4[[#This Row],[Lactation Factor]]*C23","v":0},10,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":77},{"$f":"((T27*160)+(T27*Table4[[#This Row],[Lactation Factor]]*205))/365","v":85.649315068493152}]
[null,"Holstein",null,null,null,null,null,null,null,null,null,"Chianina",1,0,1.2,{"$f":"Table4[[#This Row],[Lactation Factor]]*C24","v":0},8,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":77},{"$f":"((T28*160)+(T28*Table4[[#This Row],[Lactation Factor]]*205))/365","v":85.649315068493152}]
[null,"Jersey",null,null,null,null,null,null,null,null,null,"Devon",1,0,1,{"$f":"Table4[[#This Row],[Lactation Factor]]*C25","v":0},9,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":77},{"$f":"((T29*160)+(T29*Table4[[#This Row],[Lactation Factor]]*205))/365","v":77}]
[null,"Limousin",null,null,null,null,null,null,null,null,null,"Gelbvieh",1,0,1.2,{"$f":"Table4[[#This Row],[Lactation Factor]]*C26","v":0},12,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":77},{"$f":"((T30*160)+(T30*Table4[[#This Row],[Lactation Factor]]*205))/365","v":85.649315068493152}]
[null,"Longhorn",null,null,null,null,null,null,null,null,null,"Hereford",1,0,1,{"$f":"Table4[[#This Row],[Lactation Factor]]*C27","v":0},8,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":77},{"$f":"((T31*160)+(T31*Table4[[#This Row],[Lactation Factor]]*205))/365","v":77}]
[null,"Maine Anjou",null,null,null,null,null,null,null,null,null,"Holstein",1.2,0,1,{"$f":"Table4[[#This Row],[Lactation Factor]]*C28","v":0},43,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":92.399999999999991},{"$f":"((T32*160)+(T32*Table4[[#This Row],[Lactation Factor]]*205))/365","v":92.4}]
[null,"Pinzgauer",null,null,null,null,null,null,null,null,null,"Jersey",1.2,0,1,{"$f":"Table4[[#This Row],[Lactation Factor]]*C29","v":0},34,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":92.399999999999991},{"$f":"((T33*160)+(T33*Table4[[#This Row],[Lactation Factor]]*205))/365","v":92.4}]
[null,"Salers",null,null,null,null,null,null,null,null,null,"Limousin",1,0,1.2,{"$f":"Table4[[#This Row],[Lactation Factor]]*C30","v":0},9,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":77},{"$f":"((T34*160)+(T34*Table4[[#This Row],[Lactation Factor]]*205))/365","v":85.649315068493152}]
[null,"S. Gertrudis",null,null,null,null,null,null,null,null,null,"Longhorn",1,0,1,{"$f":"Table4[[#This Row],[Lactation Factor]]*C31","v":0},5,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":77},{"$f":"((T35*160)+(T35*Table4[[#This Row],[Lactation Factor]]*205))/365","v":77}]
[null,"Shorthorn",null,null,null,null,null,null,null,null,null,"Maine Anjou",1,0,1.2,{"$f":"Table4[[#This Row],[Lactation Factor]]*C32","v":0},9,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":77},{"$f":"((T36*160)+(T36*Table4[[#This Row],[Lactation Factor]]*205))/365","v":85.649315068493152}]
[null,"Simmental",null,null,null,null,null,null,null,null,null,"Pinzgauer",1,0,1.2,{"$f":"Table4[[#This Row],[Lactation Factor]]*C33","v":0},11,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":77},{"$f":"((T37*160)+(T37*Table4[[#This Row],[Lactation Factor]]*205))/365","v":85.649315068493152}]
[null,"South Devon",null,null,null,null,null,null,null,null,null,"Salers",1,0,1.2,{"$f":"Table4[[#This Row],[Lactation Factor]]*C34","v":0},9,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":77},{"$f":"((T38*160)+(T38*Table4[[#This Row],[Lactation Factor]]*205))/365","v":85.649315068493152}]
[null,"Tarentaise",null,null,null,null,null,null,null,null,null,"S. Gertrudis",0.95,0,1.2,{"$f":"Table4[[#This Row],[Lactation Factor]]*C35","v":0},8,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":73.149999999999991},{"$f":"((T39*160)+(T39*Table4[[#This Row],[Lactation Factor]]*205))/365","v":81.366849315068478}]
[null,"Total",{"$f":"SUM(C18:C39)","v":1},null,null,null,null,null,null,null,null,"Shorthorn",1,0,1.2,{"$f":"Table4[[#This Row],[Lactation Factor]]*C36","v":0},8.5,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":77},{"$f":"((T40*160)+(T40*Table4[[#This Row],[Lactation Factor]]*205))/365","v":85.649315068493152}]
[null,null,null,null,null,null,null,null,null,null,null,"Simmental",1.1000000000000001,0,1.1000000000000001,{"$f":"Table4[[#This Row],[Lactation Factor]]*C37","v":0},12,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":84.7},{"$f":"((T41*160)+(T41*Table4[[#This Row],[Lactation Factor]]*205))/365","v":89.457123287671237}]
[null,null,null,null,null,null,null,null,null,null,null,"South Devon",1,0,1.2,{"$f":"Table4[[#This Row],[Lactation Factor]]*C38","v":0},8,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":77},{"$f":"((T42*160)+(T42*Table4[[#This Row],[Lactation Factor]]*205))/365","v":85.649315068493152}]
[null,null,null,null,null,null,null,null,null,null,null,"Tarentaise",1,0,1.2,{"$f":"Table4[[#This Row],[Lactation Factor]]*C39","v":0},9,0,null,{"$f":"(77*Table4[[#This Row],[Breed Factor]])","v":77},{"$f":"((T43*160)+(T43*Table4[[#This Row],[Lactation Factor]]*205))/365","v":85.649315068493152}]
[null,null,null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(N22:N43)","v":1},null,{"$f":"SUM(P22:P43)","v":1.2},null,{"$f":"SUM(R22:R43)","v":11}]
[null,null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,{"$f":"AVERAGE(Q22:Q43)","v":11.977272727272727},null,{"$f":"SUBTOTAL(109,Table4[Column1])","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Feed Intake Adjustments for Growing Cattle"]
[null,null,null,null,null,null,null,null,null,null,null,"Ionophore","Adjustment",null,"Implant","Adjustment"]
[null,null,null,null,null,null,null,null,null,null,null,"Monensin",0.97,null,"Yes",1]
[null,null,null,null,null,null,null,null,null,null,null,"Lasalocid",1,null,"No",0.94]
[null,null,null,null,null,null,null,null,null,null,null,"Laidlomycin",1]
[null,null,null,null,null,null,null,null,null,null,null,"None",1]

{"sheet":"Balancer","index":2,"n_rows":34,"n_cols":26,"rows_kept":34,"cut":false,"hidden":false,"merged":[[18,3,18,4],[17,3,17,4],[22,3,22,4],[21,3,21,4],[20,3,20,4],[25,3,25,4],[23,3,23,4],[31,2,31,4],[32,2,32,4],[33,2,33,4],[2,10,2,12],[2,13,2,16],[28,5,28,6],[6,1,6,2],[7,1,7,2],[8,1,8,2],[12,3,12,4],[13,3,13,4],[7,3,7,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[8,3,8,4],[9,1,9,2],[10,1,10,2],[11,1,11,2],[5,15,5,16],[12,1,12,2],[13,1,13,2],[16,1,16,2],[14,1,14,2],[15,1,15,2],[5,5,6,5],[6,3,6,4],[14,3,14,4],[15,3,15,4],[16,3,16,4]]}
[" "]
[]
[null,{"$f":"Cattle!C3","v":"Pistol Pete, Bullet Ranch"},null,{"$f":"Cattle!F3","v":"Angus cows, 1200 lb, BCS = 5"},null,null,null,null,null,null,"Diet Concentration",null,null,"Daily Amount"]
[null,"Class of cattle:",null,{"$f":"Cattle!B7","v":"Late Gestation, Dry Cow"},null,null,null,null,null,"Nutrient","As Fed","DM","Required","  DM",null,"Required",null,"Status"]
[null,null,null,null,null,null,null,null,null,"Diet DM",{"$f":"'Nutrient and Energy Balance'!E33","v":0.90807999999999989},"-","-","-",null,"-",null,"-"]
[null,null,null,null,null,"lb or %",null,null,null,"TDN",{"$f":"'Nutrient and Energy Balance'!J36","v":0.50329219999999997},{"$f":"'Nutrient and Energy Balance'!J34","v":0.55423773235838258},"-",{"$f":"'Nutrient and Energy Balance'!J32/0.454","v":12.582305000000002},"lb","TDN:CP",null,{"$f":"N6/N12","v":6.8137215017063006}]
[null,"Feed Category",null,"Feed or Forage",null,null,"% As Fed","% DM",null,"ME, Mcal/lb",{"$f":"'Nutrient and Energy Balance'!K36","v":0.82609302932346396},{"$f":"'Nutrient and Energy Balance'!K35","v":0.90971393415058599},"-",{"$f":"'Nutrient and Energy Balance'!K32","v":20.652325733086602},"Mcal","-",null,"-"]
[null,"Harvested Forages",null,"Prairie Hay, mature",null,21.85,{"$f":"(F8/$F$18)*100","v":87.4},{"$f":"'Nutrient and Energy Balance'!E22/'Nutrient and Energy Balance'!$E$32*100","v":87.584794291251882},null,"NEm, Mcal/lb",{"$f":"'Nutrient and Energy Balance'!L36","v":0.47545585293499021},{"$f":"'Nutrient and Energy Balance'!L35","v":0.52358366326203676},"-",{"$f":"'Nutrient and Energy Balance'!L32","v":11.886396323374758},"Mcal","-",null,"-"]
[null,"Commercial Feeds",null,"Range Cube, 25%",null,3,{"$f":"(F9/$F$18)*100","v":12},{"$f":"'Nutrient and Energy Balance'!E23/'Nutrient and Energy Balance'!$E$32*100","v":11.76107831909083},null,"NEg, Mcal/lb",{"$f":"'Nutrient and Energy Balance'!M36","v":0.24476130447997493},{"$f":"'Nutrient and Energy Balance'!M35","v":0.26953716025017072},"-",{"$f":"'Nutrient and Energy Balance'!M32","v":6.1190326119993745},"Mcal","-",null,"-"]
[null,"Mineral and Vitamins",null,"B-350 RCRC Mineral",null,0.15,0.6,{"$f":"'Nutrient and Energy Balance'!E24/'Nutrient and Energy Balance'!$E$32*100","v":0.654127389657299},null,"NDF",{"$f":"'Nutrient and Energy Balance'!Z36","v":0.61263819999999991},{"$f":"'Nutrient and Energy Balance'!Z34","v":0.67465223328341117},"-",{"$f":"'Nutrient and Energy Balance'!Z32*0.454","v":3.1568633807800004},"lb","-",null,"-"]
[null,null,null,null,null,null,0,{"$f":"'Nutrient and Energy Balance'!E25/'Nutrient and Energy Balance'!$E$32*100","v":0},null,"peNDF",{"$f":"'Nutrient and Energy Balance'!AA36","v":0.59021020000000002},{"$f":"'Nutrient and Energy Balance'!AA34","v":0.64995396881332046},"7 - 20 Min",{"$f":"'Nutrient and Energy Balance'!AA32/0.454","v":14.755255},"lb",{"$f":"IF(V11>=7,7,V11)","v":7},"pH",{"$f":"IF(P11>=6,\"ADEQUATE\",W11)","v":"ADEQUATE"},null,null,null,{"$f":"5.46+0.038*(L11*100)","v":7.9298250814906179},"CAUTION"]
[null,null,null,null,null,null,0,{"$f":"'Nutrient and Energy Balance'!E26/'Nutrient and Energy Balance'!$E$32*100","v":0},null,"Crude Protein",{"$f":"'Nutrient and Energy Balance'!I36","v":7.3864509999999994E-2},{"$f":"'Nutrient and Energy Balance'!I34","v":8.1341412650867764E-2},"-",{"$f":"'Nutrient and Energy Balance'!H32","v":1.84661275},"lb",{"$f":"'Nutrient and Energy Balance'!H33","v":1.8452802222625628},"lb",{"$f":"IF(N12>P12*0.98,\"ADEQUATE\",\"DEFICIENT\")","v":"ADEQUATE"},null,"Protein","Low","High","Toxic","DEFICIENT","EXCESSIVE"]
[null,null,null,null,null,null,0,{"$f":"'Nutrient and Energy Balance'!E27/'Nutrient and Energy Balance'!$E$32*100","v":0},null,"Fat",{"$f":"'Nutrient and Energy Balance'!AB36","v":1.5989365999999998E-2},{"$f":"'Nutrient and Energy Balance'!AB34","v":1.7607882565412739E-2},"-",{"$f":"'Nutrient and Energy Balance'!AB32/0.454","v":0.39973415000000001},"lb","-",null,{"$f":"IF(L13*100>=7, Y14, \"ADEQUATE\")","v":"ADEQUATE"}]
[null,null,null,null,null,null,0,{"$f":"'Nutrient and Energy Balance'!E28/'Nutrient and Energy Balance'!$E$32*100","v":0},null,"Calcium",{"$f":"'Nutrient and Energy Balance'!N36","v":5.9113599999999992E-3},{"$f":"'Nutrient and Energy Balance'!N34","v":6.5097348251255396E-3},{"$f":"'Nutrient and Energy Balance'!N35","v":2.6341996299885473E-3},{"$f":"'Nutrient and Energy Balance'!N32","v":67.093935999999999},"g",{"$f":"'Nutrient and Energy Balance'!N33","v":27.149926400000002},"g",{"$f":" IF(N14/N15<1.25,X14,IF(N14>=P14,\"ADEQUATE\",\"DEFICIENT\"))","v":"ADEQUATE"},null,"Calcium",{"$f":"P14","v":27.149926400000002},{"$f":"P14*2","v":54.299852800000004},{"$f":"F22*0.454*1000*0.02","v":206.13415999999998},"DEFICIENT","EXCESSIVE","TOXIC"]
[null,null,null,null,null,null,0,{"$f":"'Nutrient and Energy Balance'!E29/'Nutrient and Energy Balance'!$E$32*100","v":0},null,"Phosphorus",{"$f":"'Nutrient and Energy Balance'!O36","v":2.6648100000000001E-3},{"$f":"'Nutrient and Energy Balance'!O34","v":2.934554224297419E-3},{"$f":"'Nutrient and Energy Balance'!O35","v":1.2492913296055803E-3},{"$f":"'Nutrient and Energy Balance'!O32","v":30.245593500000005},"g",{"$f":"'Nutrient and Energy Balance'!O33","v":12.876080941176472},"g",{"$f":" IF(N15>P15*2,Y15,IF(N15>=P15,\"ADEQUATE\",\"DEFICIENT\"))","v":"EXCESSIVE"},null,"Phosphorus",12.876080941176472,{"$f":"P15*2","v":25.752161882352944},{"$f":"F22*0.454*1000*0.007","v":72.146955999999989},"DEFICIENT","EXCESSIVE","TOXIC"]
[null,null,null,null,null,null,0,{"$f":"'Nutrient and Energy Balance'!E30/'Nutrient and Energy Balance'!$E$32*100","v":0},null,"Sodium",{"$f":"'Nutrient and Energy Balance'!P36","v":1.5989739999999998E-3},{"$f":"'Nutrient and Energy Balance'!P34","v":1.760829442339882E-3},{"$f":"'Nutrient and Energy Balance'!P35","v":7.000000000000001E-4},{"$f":"'Nutrient and Energy Balance'!P32","v":18.148354900000001},"g",{"$f":"'Nutrient and Energy Balance'!P33","v":7.2146956000000015},"g",{"$f":" IF(N16>P16*2,Y16,IF(N16>=P16*0.95,\"ADEQUATE\",\"DEFICIENT\"))","v":"EXCESSIVE"},null,"Sodium",7.2146956000000015,{"$f":"P16*4","v":28.858782400000006},{"$f":"P16*10","v":72.146956000000017},"DEFICIENT","EXCESSIVE","TOXIC"]
[null,null,null,null,null,null,0,{"$f":"'Nutrient and Energy Balance'!E31/'Nutrient and Energy Balance'!$E$32*100","v":0},null,"Potassium",{"$f":"'Nutrient and Energy Balance'!Q36","v":8.7926959999999992E-3},{"$f":"'Nutrient and Energy Balance'!Q34","v":9.6827327988723462E-3},6.0000000000000001E-3,{"$f":"'Nutrient and Energy Balance'!Q32","v":99.79709960000001},"g",{"$f":"'Nutrient and Energy Balance'!Q33","v":61.840248000000003},"g",{"$f":" IF(N17>P17*2,Y17,IF(N17>=P17,\"ADEQUATE\",\"DEFICIENT\"))","v":"ADEQUATE"},null,"Potassium",61.840248000000003,{"$f":"P17*2","v":123.68049600000001},2,"DEFICIENT","EXCESSIVE","TOXIC"]
[null,null,null,null,null,{"$f":"SUM(F8:F17)","v":25},{"$f":"SUM(G8:G17)","v":100},{"$f":"SUM(H8:H17)","v":100.00000000000001},null,"Magnesium",{"$f":"'Nutrient and Energy Balance'!R36","v":1.6542379999999997E-3},{"$f":"'Nutrient and Energy Balance'!R34","v":1.8216875165183684E-3},1.5E-3,{"$f":"'Nutrient and Energy Balance'!R32","v":18.775601300000002},"g",{"$f":"'Nutrient and Energy Balance'!R33","v":12.368049600000001},"g",{"$f":" IF(N18>P18*2,Y18,IF(N18>=P18,\"ADEQUATE\",\"DEFICIENT\"))","v":"ADEQUATE"},null,"Magnesium",12.368049600000001,24.736099200000002,0.4,"DEFICIENT","EXCESSIVE","TOXIC"]
[null,"Cost Per Day",{"$f":"'Nutrient and Energy Balance'!G18","v":1.2215},"  Feed Intake, lb As Fed",null,25,null,null,null,"Sulfur",{"$f":"'Nutrient and Energy Balance'!S36","v":1.76935E-3},{"$f":"'Nutrient and Energy Balance'!S34","v":1.9484516782662324E-3},{"$f":"'Nutrient and Energy Balance'!S35","v":1.5E-3},{"$f":"'Nutrient and Energy Balance'!S32","v":20.082122500000004},"g",{"$f":"'Nutrient and Energy Balance'!S33","v":15.460062000000001},"g",{"$f":" IF(L19>W19,Z19,IF(N19>=P19,\"ADEQUATE\",\"DEFICIENT\"))","v":"ADEQUATE"},null,"Sulfur",15.460062000000001,30.920124000000001,3.5000000000000001E-3,"DEFICIENT","EXCESSIVE","TOXIC"]
[null,null,null,null,null,null,null,null,null,"Cobalt ppm",{"$f":"'Nutrient and Energy Balance'!T36","v":1.0043609999999998},{"$f":"'Nutrient and Energy Balance'!T34","v":1.106027002026253},".15 ppm",{"$f":"'Nutrient and Energy Balance'!T32","v":11.399497349999999},"mg",{"$f":"'Nutrient and Energy Balance'!T33","v":1.5460062000000001},"mg",{"$f":" IF(N20>P20*2,Y20,IF(N20>=P20,\"ADEQUATE\",\"DEFICIENT\"))","v":"EXCESSIVE"},null,"Cobalt",1.5460062000000001,3.0920124000000002,25,"DEFICIENT","EXCESSIVE","TOXIC"]
[null,"Projected ADG, lb",{"$f":"VLOOKUP(D4, 'Requirement Calculator'!A8:BT79, 68, FALSE)","v":1.2173560575126212},"Feed Intake Ratio",null,{"$f":"F22/F23","v":1.0085554723441079},null,null,null,"Copper ppm",{"$f":"'Nutrient and Energy Balance'!U36","v":16.782719999999998},{"$f":"'Nutrient and Energy Balance'!U34","v":18.481543476345696},"10 ppm",{"$f":"'Nutrient and Energy Balance'!U32","v":190.48387199999999},"mg",{"$f":"'Nutrient and Energy Balance'!U33","v":103.06708},"mg","ADEQUATE",null,"Copper",103.06708,206.13416000000001,40,"DEFICIENT","EXCESSIVE","TOXIC"]
[null,"Desired ADG, lb",{"$f":"VLOOKUP(D4, 'Requirement Calculator'!A8:BT79, 69, FALSE)","v":1.1777894334968786},"Feed Intake, lb DM",null,{"$f":"'Nutrient and Energy Balance'!E32","v":22.701999999999998},null,null,null,"Iron ppm, mg",{"$f":"'Nutrient and Energy Balance'!V36","v":260.78195999999997},{"$f":"'Nutrient and Energy Balance'!V34","v":287.17949960355918},"50 ppm",{"$f":"'Nutrient and Energy Balance'!V32","v":2959.8752460000005},"mg",{"$f":"'Nutrient and Energy Balance'!V33","v":515.33540000000005},"mg","EXCESSIVE",null,"Iron",515.33540000000005,1030.6708000000001,500,"DEFICIENT","EXCESSIVE","TOXIC"]
[null,"Days to",{"$f":"IF('Nutrient and Energy Balance'!R86<0,\"lose\",\"gain\")","v":"gain"},"Predicted Intake, lb DM",null,{"$f":"VLOOKUP(Cattle!B7,'Requirement Calculator'!A8:R73, 17,FALSE)","v":22.509421268852456},null,null,null,"Manganese ppm",{"$f":"'Nutrient and Energy Balance'!W36","v":82.1006},{"$f":"'Nutrient and Energy Balance'!W34","v":90.411197251343509},"40 ppm",{"$f":"'Nutrient and Energy Balance'!W32","v":931.84181000000012},"mg",{"$f":"'Nutrient and Energy Balance'!W33","v":412.26832000000002},"mg","EXCESSIVE",null,"Magnesium",412.26832000000002,824.53664000000003,1000,"DEFICIENT","EXCESSIVE","TOXIC"]
[null,"one condition score:",{"$f":"VLOOKUP(D4, 'Requirement Calculator'!A8:BT82,70,FALSE)","v":2068.6526090129441},"DM Intake, % of Body Weight",null,{"$f":"F22/((L28+L29)/2)* 100","v":1.8092399862069668},null,null,null,"Selenium ppm",{"$f":"'Nutrient and Energy Balance'!X36","v":0.27162739999999991},{"$f":"'Nutrient and Energy Balance'!X34","v":0.29912276451413966},".1 ppm",{"$f":"'Nutrient and Energy Balance'!X32","v":3.0829709899999997},"mg",{"$f":"'Nutrient and Energy Balance'!X33","v":1.0306708000000002},"mg","EXCESSIVE",null,"Selenium",1.0306708000000002,2.0613416000000004,5,"DEFICIENT","EXCESSIVE","TOXIC"]
[null,null,null,null,null,null,null,null,null,"Zinc ppm",{"$f":"'Nutrient and Energy Balance'!Y36","v":50.169959999999989},{"$f":"'Nutrient and Energy Balance'!Y34","v":55.248392212139898},"30 ppm",{"$f":"'Nutrient and Energy Balance'!Y32","v":569.42904599999997},"mg",{"$f":"'Nutrient and Energy Balance'!Y33","v":309.20124000000004},"mg","ADEQUATE",null,"Zinc",309.20124000000004,618.40248000000008,500,"DEFICIENT","EXCESSIVE","TOXIC"]
[null,"DM Feed:Gain, lb",{"$f":"F22/C21","v":18.648611357293575},"Protein Ratio",null,{"$f":"'Nutrient and Energy Balance'!I32/'Nutrient and Energy Balance'!I33","v":1.0007221275778935}]
[null,"Cost per lb Gain",{"$f":"'Nutrient and Energy Balance'!G18/C21","v":1.003404051314162},"Ca:P Ratio",null,{"$f":"N14/N15","v":2.2183044945042982},null,null,null,null,null,"Desired Time on Feed",null,null,"Desired Final Weight"]
[null,null,null,null,null,null,null,null,null,"Initial Weight, lb",null,{"$f":"VLOOKUP(D4, 'Requirement Calculator'!A8:BN81, 22, FALSE)","v":1200},null,null,null,{"$f":"L28","v":1200}]
[null,"Maternal Tissue ADG, lb",{"$f":"VLOOKUP(D4, 'Requirement Calculator'!A8:BT93, 65, FALSE)","v":3.9566624015742534E-2},"Fetal Tissue ADG, lb",{"$f":"VLOOKUP(D4, 'Requirement Calculator'!A8:BT94, 67, FALSE)","v":1.1777894334968786},"Milk Yield, lb",null,{"$f":"VLOOKUP(D4, 'Requirement Calculator'!A24:H58, 8, FALSE)/0.454","v":{"$error":"#N/A"}},null,"Final Weight, lb",null,{"$f":"L28+(L31*C21)","v":1309.5620451761358},null,null,null,{"$f":"(C22*L31)+P28","v":1306.001049014719}]
[null,null,null,null,null,null,null,null,null,"Average Weight, lb",null,{"$f":"(L29+L28)/2","v":1254.781022588068},null,null,null,{"$f":"(P29+P28)/2","v":1253.0005245073594},null,null,null,null,"Days to achieve desired final weight"]
[null,null,null,null,null,null,null,null,null,"Days on Feed",null,{"$f":"Cattle!E7","v":90},null,null,null,{"$f":"IF(U31<1, \"-\", U31)","v":87.07481131798616},null,null,null,null,{"$f":"(P29-P28)/C21","v":87.07481131798616}]
[null,"Prepared by",{"$f":"' Summary'!H34","v":0}]
[null,"Phone",{"$f":"' Summary'!H37","v":0},null,null,null,null,null,null,"The latest version of Cowculator is available at: beef.okstate.edu/pages/calculators"]
[null,"Email",{"$f":"' Summary'!H38","v":0}]

{"sheet":"Feed List","index":3,"n_rows":150,"n_cols":97,"rows_kept":150,"cut":false,"hidden":false,"merged":[[1,6,1,7],[1,24,1,29],[1,1,1,2],[1,8,1,14],[1,3,1,4],[1,15,1,16],[1,18,1,23]]}
[]
[null,"Dry Matter Basis",null,"Units and Cost",null,"DM","Protein",null,"Energy",null,null,null,null,null,null,"Fiber",null,"Fat","Macromineral",null,null,null,null,null,"Trace mineral"]
[null,null,null,"Units","Cost","DM","Protein","DIP","TDN","ME","ME","NE m","NE m","NE g","NE g","NDF","peNDF","FAT","CA","Phos","Na","K","MG","S","CO","CU","FE","MN","SE","ZN"]
[null,"Number","FEED NAME ","LB.","$/Unit","%","%","% of CP","%","Mcal/kg","Mcal/lb","Mcal/kg","Mcal/lb","Mcal/kg","Mcal/lb","%","% of NDF","%","%","%","%","%","%","%","ppm","ppm","ppm","ppm","ppm","ppm"]
[null,null,"Grazed forages"]
[null,1,"Alfalfa, fresh and greenchop",2000,60,25,23,78,61,{"$f":"(I6/100*4.409)*0.82","v":2.2053817999999996},{"$f":"J6*0.454","v":1.0012433371999998},{"$f":"IF(I6<29,0,((1.37*J6)-(0.138*J6^2)+(0.0105*J6^3))-1.12)","v":1.3428077580936262},{"$f":"L6*0.454","v":0.60963472217450632},{"$f":"IF(I6<38,0,((1.42*J6)-(0.174*J6^2)+(0.0122*J6^3)-1.65))","v":0.76621809786756634},{"$f":"N6*0.454","v":0.34786301643187512},36,0.8,2,1.8,0.34,0.08,2.9,0.36,0.33,0.4,8.3000000000000007,198,48,0.3,23]
[null,{"$f":"B6+1","v":2},"Bermuda, vegetative",2000,40,30,16,85,65,{"$f":"(I7/100*4.409)*0.82","v":2.3499969999999997},{"$f":"J7*0.454","v":1.0668986379999998},1.4736600014231738,{"$f":"L7*0.454","v":0.66904164064612093},0.88441266202870761,{"$f":"N7*0.454","v":0.40152334856103328},64,0.8,3,0.46,0.31,0.04,1.9,0.22,0.33,0.1,11,500,77,0.2,41]
[null,{"$f":"B7+1","v":3},"Bermuda, boot stage",2000,40,35,13,75,60,{"$f":"(I8/100*4.409)*0.82","v":2.1692279999999999},{"$f":"J8*0.454","v":0.98482951200000002},1.3096542601976631,{"$f":"L8*0.454","v":0.59458303412973901},0.73606845483613181,{"$f":"N8*0.454","v":0.33417507849560385},66,0.9,2.7,0.59,0.28000000000000003,0.04,1.9,0.21,0.3,0.1,12,400,160,0.18,36]
[null,4,"Bermuda, fall, mature",2000,40,80,8,60,48,1.7353823999999998,0.7878636095999999,0.89675474365246233,0.40712665361821793,0.35399251957290367,0.16071260388609826,70,1,2.1,0.26,0.18,0.03,1.3,0.2,0.21,0.1,9,300,140,0.15,20]
[null,5,"Bermuda, winter, mature",2000,40,90,5,55,44,1.5907671999999999,0.72220830879999998,0.7524042597974181,0.34159153394802783,0.21768652037309155,9.8829680249383572E-2,72,1,1.5,0.3,0.15,0.02,1,0.1,0.21,0.1,7,200,45,0.12,15]
[null,6,"Bermuda, stockpiled, Sep-Oct",2000,45,35,13,70,57,2.0607665999999996,0.93558803639999988,1.2090890829722096,0.54892644366938315,0.64412177411195115,0.29243128544682584,66,1,2.5,0.66,0.24,0.04,0.88,0.16,0.25,0.1,6,450,151,0.18,27]
[null,7,"Bermuda, stockpiled, Nov-Dec",2000,45,85,11,65,54,1.9523052000000001,0.88634656080000007,1.1068043600476276,0.50248917946162297,0.54985582320086168,0.24963454373319122,68,1,2.1,0.52,0.22,0.03,0.55000000000000004,0.15,0.22,0.1,5,300,117,0.16,26]
[null,8,"Bermuda, stockpiled, Jan-Feb",2000,45,90,7,60,47,1.6992285999999996,0.77144978439999989,0.86100134822353525,0.39089461209348503,0.32035791165522065,0.14544249189147018,70,1,1.5,0.48,0.18,0.02,0.32,0.09,0.21,0.1,4,250,116,0.14000000000000001,26]
[null,9,"Fescue, vegetative",2000,40,29,18,80,64,2.3138431999999995,1.0504848127999997,1.4412052485058107,0.65430718282163802,0.85521770382672191,0.38826883753733177,60,0.8,4.5,0.5,0.4,0.03,2.5,0.19,0.24,null,7,200,100,0.12,36]
[null,10,"Fescue, boot stage",2000,40,33,12,75,57,2.0607665999999996,0.93558803639999988,1.2090890829722096,0.54892644366938315,0.64412177411195115,0.29243128544682584,65,0.9,3.8,0.45,0.3,0.02,1.8,0.17,0.21,null,5,180,95,0.1,32]
[null,11,"Fescue, mature",2000,40,70,8,70,49,1.7715361999999997,0.80427743479999991,0.93229028399410119,0.42325978893332195,0.3873382981993978,0.1758515873825266,74,1,3.2,0.38,0.2,0.02,1.4,0.15,0.18,null,4,160,80,0.09,26]
[null,12,"Fescue, stockpiled, Jan-Feb",2000,40,40,13,75,52,1.8799975999999998,0.85351891039999994,1.0376195461109057,0.47107927393435117,0.48567725011369767,0.22049747155161875,72,1,2.7,0.45,0.3,0.02,1.8,0.13,0.21,null,4,160,80,0.1,32]
[null,13,"Fescue, stockpiled, Nov-Dec",2000,40,60,11,68,40,1.4461519999999999,0.65655300799999994,0.60437755620585709,0.27438741051745913,7.6537865109784997E-2,3.4748190759842389E-2,75,1,2.2000000000000002,0.38,0.2,0.03,1.4,0.15,0.18,null,5,180,90,0.11,26]
[null,14,"Native Range, April-June",2000,45,30,14,75,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265,68,0.9,3.2,0.33,0.17,0.02,1.6,null,0.15,null,10,200,58,0.2,28]
[null,15,"Native Range, July-August",2000,45,35,9,70,64,2.3138431999999995,1.0504848127999997,1.4412052485058107,0.65430718282163802,0.85521770382672191,0.38826883753733177,71,1,3,0.3,0.13,0.02,1.5,null,0.13,null,9,190,52,0.21,25,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,3,"Bermuda Pasture Summer",0,2000,{"$f":"IF(BS20=0,0,BS20/BT20)","v":0},25,61,{"$f":"IF(BW20=0,0,(((BW20/100)*4.4)*0.82))","v":2.2008800000000002},{"$f":"BX20*0.454","v":0.99919952000000012},{"$f":"IF(BW20=0,0,((1.37*BX20)-(0.138*BX20^2)+(0.0105*BX20^3))-1.12)","v":1.3386893756058758},{"$f":"BZ20*0.454","v":0.60776497652506756},{"$f":"IF(BW20=0,0,((1.42*BX20)-(0.174*BX20^2)+(0.0122*BX20^3)-1.65))","v":0.7624772863374023},{"$f":"CB20*0.454","v":0.34616468799718064},66.3,45,15.1,90,3,0.45,0.33,0.04,0.19,0.3,0,9.6999999999999993,134,125,0,31.5]
[null,16,"Native Range, Sept Oct",2000,45,89,7,65,59,2.1330741999999998,0.9684156867999999,1.2763186331531466,0.57944865945152857,0.70567149265184748,0.32037485766393875,74,1,2.5,0.25,0.1,0.01,1.1000000000000001,null,0.11,null,8,180,48,0.18,23]
[null,17,"Native Range, Nov-Dec",2000,45,75,5,65,55,1.9884589999999998,0.90276038599999997,1.1410952902583267,0.51805726177728029,0.58154126882231694,0.26401973604533191,77,1,2.2000000000000002,0.22,0.08,0.01,0.8,null,0.1,null,7,170,42,0.16,22]
[null,18,"Native Range, Jan-March",2000,45,85,3.5,55,49,1.7715361999999997,0.80427743479999991,0.93229028399410119,0.42325978893332195,0.3873382981993978,0.1758515873825266,78,1,1.7,0.2,0.05,0.01,0.6,null,0.09,null,6,160,40,0.14000000000000001,20]
[null,19,"Wheat Forage, vegetative",2000,45,21,22,84,71,2.5669197999999995,1.1653815891999999,1.6649806094263102,0.75590119667954481,1.0548729939780714,0.47891233926604443,50,0.8,4,0.35,0.36,0.03,3.1,null,0.22,null,5,886,176,0.2,23.5]
[null,20,"Added Feed",2000,0,null,null,null,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,21,"Added Feed",2000,0,null,null,null,70,2.5307659999999994,{"$f":"J26*0.454","v":1.1489677639999998},1.6334846591300103,{"$f":"L26*0.454","v":0.74160203524502466},1.027006287674411,{"$f":"N26*0.454","v":0.46626085460418265}]
[null,22,"Added Feed",2000,0,null,null,null,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265]
[null,23,"Added Feed",2000,0,null,null,null,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265]
[null,24,"Added Feed",2000,0,null,null,null,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0]
[null,25,"Added Feed",2000,0,null,null,null,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,{"$f":"L30*0.454","v":0.74160203524502466},1.027006287674411,0.46626085460418265,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0]
[null,null,"Harvested Forages"]
[null,{"$f":"B30+1","v":26},"Alfalfa Hay,early bloom",2000,180,90,24,88,60,2.1692279999999999,0.98482951200000002,1.3096542601976631,0.59458303412973901,0.73606845483613181,0.33417507849560385,39,0.9,2.5,1.41,0.22,0.08,2.5099999999999998,0.3,0.3,0.4,12.7,150,36,0.55000000000000004,30]
[null,{"$f":"B32+1","v":27},"Alfalfa Hay, mid bloom",2000,150,90,20,84,58,2.0969203999999997,0.95200186159999989,1.2427978997985161,0.56423024650852627,0.67502375213651922,0.30646078346997974,47,1,2.6,1.37,0.22,7.0000000000000007E-2,1.56,0.28000000000000003,0.28000000000000003,0.35,11,140,28,0.5,31]
[null,{"$f":"B33+1","v":28},"Alfalfa Hay, full bloom",2000,130,90,16,82,55,1.9884589999999998,0.90276038599999997,1.1410952902583267,0.51805726177728029,0.58154126882231694,0.26401973604533191,49,1,2.2999999999999998,1.19,0.24,0.06,1.56,0.26,0.27,0.3,9.9,130,28,0.45,26]
[null,29,"Alfalfa Silage",2000,60,40,21,75,60,{"$f":"(I35/100*4.409)*0.82","v":2.1692279999999999},{"$f":"J35*0.454","v":0.98482951200000002},1.3096542601976631,{"$f":"L35*0.454","v":0.59458303412973901},0.73606845483613181,{"$f":"N35*0.454","v":0.33417507849560385},44,0.7,3.8,1.4,0.33,7.0000000000000007E-2,2.8,0.28000000000000003,0.25,0.71,11,499,45,0.14000000000000001,26]
[null,30,"Bermuda Hay, vegetative",2000,90,90,14,80,57,2.0607665999999996,0.93558803639999988,1.2090890829722096,0.54892644366938315,0.64412177411195115,0.29243128544682584,69,1,2.2999999999999998,0.59,0.28000000000000003,0.04,1.9,0.21,0.25,0.57999999999999996,12,250,170,0.3,36]
[null,31,"Bermuda Hay, early bloom",2000,80,92.99,11,70,55,1.9884589999999998,0.90276038599999997,1.1410952902583267,0.51805726177728029,0.58154126882231694,0.26401973604533191,66,1,1.86,0.49,0.2,0.03,1.65,0.2,0.23,0.55000000000000004,10.65,217.79,63.11,0.27,34.840000000000003]
[null,32,"Bermuda Hay, full bloom",2000,50,91,8,68,52,1.8799975999999998,0.85351891039999994,1.0376195461109057,0.47107927393435117,0.48567725011369767,0.22049747155161875,70,1,1.8,0.43,0.18,0.03,1.4,0.19,0.21,0.5,8,200,110,0.12,26]
[null,33,"Brome Hay, early bloom",2000,90,88,13,79,57,{"$f":"(I39/100*4.409)*0.82","v":2.0607665999999996},{"$f":"J39*0.454","v":0.93558803639999988},1.2090890829722096,{"$f":"L39*0.454","v":0.54892644366938315},0.64412177411195115,{"$f":"N39*0.454","v":0.29243128544682584},57,1,2.6,0.32,0.37,0.02,1.7,0.12,0.19,0.55000000000000004,8,200,86,0.12,31]
[null,34,"Corn Silage",2000,50,35,8.3000000000000007,74,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265,44,0.8,3.3,0.24,0.24,0.03,1.1000000000000001,0.17,0.1,0.6,6.5,200,31,0.1,27.6]
[null,35,"Cotton Gin Trash",2000,40,91,10,72,44,1.5907671999999999,0.72220830879999998,0.7524042597974181,0.34159153394802783,0.21768652037309155,9.8829680249383572E-2,65,0.9,3,1.2,0.2,0.01,2.2999999999999998,0.28999999999999998,0.25,0.04,9,750,59,0.49,26]
[null,36,"Fescue Hay, early bloom",2000,70,87,11,72,56,2.0246127999999999,0.91917421119999998,1.1751892055126674,0.53353589930275103,0.61296209939994917,0.27828479312757692,68,1,3.7,0.45,0.37,0.02,2.5,0.2,0.21,0.5,11,150,200,0.15,34]
[null,37,"Fescue Hay, full bloom",2000,60,88,9,68,52,1.8799975999999998,0.85351891039999994,1.0376195461109057,0.47107927393435117,0.48567725011369767,0.22049747155161875,73,1,3.4,0.4,0.26,0.02,1.7,0.18,0.17,0.4,7,140,100,0.1,23]
[null,38,"Oat Hay",2000,75,90,8.5,68,55,1.9884589999999998,0.90276038599999997,1.1410952902583267,0.51805726177728029,0.58154126882231694,0.26401973604533191,63,1,2.6,0.32,0.25,0.02,1.49,0.28999999999999998,0.23,0.28000000000000003,8.9,406,99,0.09,45]
[null,39,"Poultry Litter",2000,20,79,23,67,50,1.8076899999999998,0.82069125999999992,0.96761094641001444,0.4392953696701466,0.42039870671289847,0.19086101284765591,35,0.2,2.5,4,1.9,0.1,2.4,0.62,0.8,0.2,280,453,422,0.4,493]
[null,40,"Prairie Hay, vegetative",2000,60,90,7,65,56,2.0246127999999999,0.91917421119999998,1.1751892055126674,0.53353589930275103,0.61296209939994917,0.27828479312757692,68.599999999999994,1,2.2000000000000002,0.37,0.08,0.01,0.96,0.18,0.11,0.15,6,400,86,0.2,21]
[null,41,"Prairie Hay, mature",2000,55,91,5.5,61,53,1.9161513999999999,0.86993273559999995,1.0723134377190071,0.48683030072442923,0.51790230335738707,0.23512764572425374,73,1,2,0.4,0.15,0.01,1.1000000000000001,0.2,0.22,0.15,6,300,80,0.11,18]
[null,42,"Red Clover Hay",2000,100,87,14.9,70,57,{"$f":"(I48/100*4.409)*0.82","v":2.0607665999999996},{"$f":"J48*0.454","v":0.93558803639999988},1.2090890829722096,{"$f":"L48*0.454","v":0.54892644366938315},0.64412177411195115,{"$f":"N48*0.454","v":0.29243128544682584},51,1,2.6,1.5,0.2,0.04,1.7,0.4,0.2,0.2,10.9,147,75,0.1,17]
[null,43,"Sorghum Sudan Hay, early bloom",2000,90,91,9.5,69,54,{"$f":"(I49/100*4.409)*0.82","v":1.9523052000000001},{"$f":"J49*0.454","v":0.88634656080000007},1.1068043600476276,{"$f":"L49*0.454","v":0.50248917946162297},0.54985582320086168,{"$f":"N49*0.454","v":0.24963454373319122},65,1,1.7,0.51,0.21,0.02,2.2000000000000002,0.28000000000000003,0.15,7.0000000000000007E-2,10.8,519,66,0.25,34.5]
[null,44,"Soybean Hay",2000,90,92,16,64,53,{"$f":"(I50/100*4.409)*0.82","v":1.9161513999999999},{"$f":"J50*0.454","v":0.86993273559999995},1.0723134377190071,{"$f":"L50*0.454","v":0.48683030072442923},0.51790230335738707,{"$f":"N50*0.454","v":0.23512764572425374},53,0.9,4,1.3,0.26,0.04,1.1000000000000001,0.6,0.23,0.2,8.4,500,61,0.1,26]
[null,45,"Sudan Hay, full bloom",2000,70,91,8,58,54.4,{"$f":"(I51/100*4.409)*0.82","v":1.9667667200000001},{"$f":"J51*0.454","v":0.89291209088000012},1.1205445644650101,{"$f":"L51*0.454","v":0.50872723226711458},0.56256197664210772,{"$f":"N51*0.454","v":0.2554031373955169},65.8,1,2.6,0.46,0.21,0.02,2.1,0.3,0.13100000000000001,0.33,8.4,283,41.7,0.151,32]
[null,46,"Sorghum Silage",2000,70,32,9.6999999999999993,70,60,{"$f":"(I52/100*4.409)*0.82","v":2.1692279999999999},{"$f":"J52*0.454","v":0.98482951200000002},1.3096542601976631,{"$f":"L52*0.454","v":0.59458303412973901},0.73606845483613181,{"$f":"N52*0.454","v":0.33417507849560385},58,0.8,3,0.46,0.25,0.02,1.9,0.26,0.15,0.5,9.8000000000000007,436,55.7,0.11,69]
[null,47,"Sorghum Sudan Silage",2000,40,32,11,70,58,{"$f":"(I53/100*4.409)*0.82","v":2.0969203999999997},{"$f":"J53*0.454","v":0.95200186159999989},1.2427978997985161,{"$f":"L53*0.454","v":0.56423024650852627},0.67502375213651922,{"$f":"N53*0.454","v":0.30646078346997974},61,0.9,3.3,0.55000000000000004,0.28999999999999998,0.02,2.5,0.28000000000000003,0.17,0.45,11,634,69,0.23,34]
[null,48,"Triticale Hay",2000,80,90,10.5,70,57,{"$f":"(I54/100*4.409)*0.82","v":2.0607665999999996},{"$f":"J54*0.454","v":0.93558803639999988},1.2090890829722096,{"$f":"L54*0.454","v":0.54892644366938315},0.64412177411195115,{"$f":"N54*0.454","v":0.29243128544682584},64,1,2.1,0.3,0.25,0.03,2.2000000000000002,0.15,0.17,0.17,6.8,260,41,7.0000000000000007E-2,25]
[null,49,"Triticale Silage",2000,45,34,14.4,82,61,{"$f":"(I55/100*4.409)*0.82","v":2.2053817999999996},{"$f":"J55*0.454","v":1.0012433371999998},1.3428077580936262,{"$f":"L55*0.454","v":0.60963472217450632},0.76621809786756634,{"$f":"N55*0.454","v":0.34786301643187512},58.5,0.8,3.7,0.43,0.35,0.03,3,0.17,0.2,1.5,10.6,631,52,0.25,36.5]
[null,50,"Wheat Hay",2000,80,89,9,70,57,2.0607665999999996,0.93558803639999988,1.2090890829722096,0.54892644366938315,0.64412177411195115,0.29243128544682584,62,1,2.1,0.21,0.2,0.03,1.3,0.13,0.19,0.35,8,292,61,0.31,23]
[null,51,"Wheat Silage",2000,45,34,12.7,81,60,{"$f":"(I57/100*4.409)*0.82","v":2.1692279999999999},{"$f":"J57*0.454","v":0.98482951200000002},1.3096542601976631,{"$f":"L57*0.454","v":0.59458303412973901},0.73606845483613181,{"$f":"N57*0.454","v":0.33417507849560385},57,0.8,3.5,0.39,0.33,0.03,2.4,0.16,0.18,0.56999999999999995,10,565,57,0.3,30]
[null,52,"Wheat Straw",2000,40,91,4,40,44,1.5907671999999999,0.72220830879999998,0.7524042597974181,0.34159153394802783,0.21768652037309155,9.8829680249383572E-2,72,1,1.8,0.16,0.05,0.01,1.3,0.12,0.17,0.15,5,130,35,0.1,6]
[null,53,"Wheat Straw, Ammoniated",2000,70,85,9,75,50,1.8076899999999998,0.82069125999999992,0.96761094641001444,0.4392953696701466,0.42039870671289847,0.19086101284765591,76,1,1.5,0.15,0.05,0.01,1.3,0.12,0.16,0.15,5,120,35,0.1,6]
[null,54,"Added Feed",2000,0,null,null,null,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265]
[null,55,"Added Feed",2000,0,null,null,null,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265]
[null,56,"Added Feed",2000,0,null,null,null,70,{"$f":"(I62/100*4.409)*0.82","v":2.5307659999999994},{"$f":"J62*0.454","v":1.1489677639999998},1.6334846591300103,{"$f":"L62*0.454","v":0.74160203524502466},1.027006287674411,{"$f":"N62*0.454","v":0.46626085460418265}]
[null,57,"Added Feed",2000,0,null,null,null,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265]
[null,58,"Added Feed",2000,0,null,null,null,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265]
[null,59,"Added Feed",2000,0,0,0,0,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265,0,0,0,0,0,null,0,0,0,6.5000000000000002E-2,0,0,0,0,0]
[null,null,"Concentrates"]
[null,{"$f":"B65+1","v":60},"Barley Malt pellets with hulls",2000,160,90,18,64,68,2.4584584,1.1161401136,1.5700327087770276,0.71279484978477059,0.97063123377619531,0.44066658013439269,50,0.5,1.9,0.21,0.59,0.04,1.2,null,0.32,null,10,null,44,null,61]
[null,{"$f":"B67+1","v":61},"Corn Gluten Feed",2000,180,89,22.6,64,77,2.7838425999999998,1.2638645404,1.8509235240597759,0.84031927992313826,1.217799670990042,0.55288105062947912,35,0.3,3.3,0.14000000000000001,1.07,0.04,1.5,0.43,0.53,0.11,6.3,133,22,0.26,67]
[null,{"$f":"B68+1","v":62},"Corn Grain, rolled",2000,190,87,9,42,87.6,3.1670728799999992,1.4378510875199997,2.1682533992502093,0.98438704325959503,1.4895180681321492,0.67624120293199574,9.6999999999999993,0.2,3.8,0.03,0.28999999999999998,0.04,0.37,0.11,0.11,0.14000000000000001,3.1,50,7.6,0.61,20]
[null,63,"Corn Grain, steam flaked",2000,220,81,8.5,30,95,3.4346109999999994,1.5593133939999997,{"$f":"IF(I70<29,0,((1.37*J70)-(0.138*J70^2)+(0.0105*J70^3))-1.12)","v":2.3829167767143562},1.0818442166283178,{"$f":"IF(I70<38,0,((1.42*J70)-(0.174*J70^2)+(0.0122*J70^3)-1.65))","v":1.6688495973026396},0.75765771717539843,9,0.1,3.2,0.02,0.25,0.04,0.33,0.09,0.12,0.04,2.7,34,7,0.5,18]
[null,64,"Corn Grain, whole",2000,180,82,9,0,92,3.3261495999999999,1.5100719184,2.2964735286641429,1.0425989820135209,1.5970600082601858,0.72506524375012438,0,0.6,4.2,0.28999999999999998,0.4,0.04,0.13,0.14000000000000001,7.0000000000000007E-2,4,26,6,0.15,16,0]
[null,65,"Cotton Seed Hulls",2000,70,91.4,6.7,30,39,1.4099982,0.64013918280000004,0.56677414226242684,0.25731546058714178,4.0468092447575099E-2,1.8372513971199097E-2,81,0.7,4.2,0.22,0.16,0.04,1.2,0.22,0.11,0.02,5.5,101,21,0.09,17.7]
[null,66,"Cottonseed meal, 41%",2000,280,90,46,75,72,2.6030735999999997,1.1817954143999998,1.69632717935123,0.77013253942545845,1.0825304320890257,0.49146881616841764,33,0.1,4,0.22,1.2,0.04,1.7,0.67,0.44,0.3,13.5,203,26.2,1.3,66]
[null,67,"Cottonseed, whole",2000,300,92.6,23,56,93,3.3623033999999996,1.5264857435999999,2.3253708351107267,1.0557183591402699,1.6211218844873554,0.73598933555725932,48,0.7,19.399999999999999,0.22,0.53,0.04,1.1200000000000001,0.38,0.26,0.03,8.9,150,21.7,1,29.4]
[null,68,"Distillers Grains with Solubles, corn",2000,190,92,31,29,80,2.8923039999999998,1.3131060159999999,1.9420793047682641,0.8817040043647919,1.2966713834226633,0.58868880807388912,34.299999999999997,0.2,11,0.08,0.99,0.04,1.24,0.35,0.66,0.38,7.4,109,28,0.68,67]
[null,69,"Distillers Grains with Solubles, sorghum",2000,180,91,33,30,78,2.8199964,1.2802783656000001,1.8814363321492031,0.8541720947957383,1.2442741426868578,0.56490046077983347,38,0.2,10,0.1,0.65,0.04,1,0.3,0.4,0.1,7.4,109,28,0.68,68]
[null,70,"Grain Screenings",2000,130,90,12.9,54,76,2.7476887999999997,1.2474507151999998,1.8202791985683366,0.8264067561500249,1.1911366861696902,0.54077605552103936,30,0.5,5.5,0.38,0.4,0.04,0.74,0.21,0.17,1.3,12.6,476,61,0.52,57]
[null,71,"Milo, ground",2000,195,89,11.6,28.6,86,3.1092267999999996,1.4115889671999999,2.1211614297795118,0.96300728911989841,1.44969854519749,0.65816313951966043,7.2,0.2,3.5,0.06,0.34,0.04,0.39,0.15,0.14000000000000001,0.65,4.95,43,20,0.46,19.899999999999999]
[null,72,"Milo, steam flaked",2000,210,82,11,38,90,3.2538419999999997,1.477244268,2.2384153586736293,1.0162405728378276,1.5485229202758135,0.70302940580521933,7.2,0.1,3.1,0.04,0.28000000000000003,0.04,0.4,0.14000000000000001,0.14000000000000001,0.5,5,44,15,0.3,18]
[null,73,"Mung Beans",2000,210,90,23,25,79,2.8561501999999996,1.2966921908,1.9118205999981783,0.86796655239917297,1.2705635604383341,0.5768358564390037,null,0.2,null,1.19,0.68,0.04,1.4,null,0.25]
[null,74,"Oats",2000,300,89,12.5,44,83,3.0007653999999997,1.3623474916,2.0321318122207916,0.92258784274823946,1.3739398755547247,0.6237687035018451,27,0.6,6.2,0.1,0.38,0.04,0.5,0.14000000000000001,0.17,0.52,6.2,105,50,0.28000000000000003,31]
[null,75,"Peanut Hulls",2000,40,93,9.5,47,43,1.5546133999999998,0.70579448359999997,0.71574967240372911,0.32495035127129301,0.18286200350870452,8.301934959295186E-2,68.5,0.65,4.5,0.28999999999999998,0.1,0.04,0.7,0.14000000000000001,0.1,3.1,12.5,634,50,0.4,16]
[null,76,"Peanut Meal, solvent",2000,300,91,50,73,77,2.7838425999999998,1.2638645404,1.8509235240597759,0.84031927992313826,1.217799670990042,0.55288105062947912,27,0.2,7.8,0.24,0.57999999999999996,0.04,1,0.32,0.27,1.19,14,463,32,0.05,53]
[null,77,"Milo, rolled or grnd",2000,230,88,10,60,85,3.0730729999999995,1.3951751419999998,2.0915935830899812,0.94958348672285153,1.4246076480739429,0.64677187222557009,0,0.2,2.1,0.36,0.4,0.04,0.18,0.09,0.3,6,5,55,0.22,32,0]
[null,78,"Rice Bran, full fat",2000,200,91,14,50,83,3.0007653999999997,1.3623474916,2.0321318122207916,0.92258784274823946,1.3739398755547247,0.6237687035018451,23,0.3,17,0.66,1.7,0.04,1.8,0.73,0.16,1,9.5,222,187,0.08,66.7]
[null,79,"Rice Grain",2000,160,88.81,8,45,83,3.0007653999999997,1.3623474916,2.0321318122207916,0.92258784274823946,1.3739398755547247,0.6237687035018451,8.17,0.6,1.84,0.03,0.25,0.04,0.27,0.1,0.1,0,5.46,144.13999999999999,66.33,0,23.85]
[null,80,"Rice Hulls",2000,30,92,3.3,45,31.5,1.1388446999999999,{"$f":"J87*0.454","v":0.51703549380000002},0.27674472333621902,{"$f":"L87*0.454","v":0.12564210439464343},0,0,53.8,0.6,4.3,0.18,0.31,0.04,0.54,0.19,0.09,null,3.4,null,320,0.15,24]
[null,81,"Rice Mill Byproduct",2000,100,91,8.3000000000000007,38,76.5,{"$f":"(I88/100*4.409)*0.82","v":2.7657656999999998},1.2556576278,1.8356179870619052,0.83337056612610494,1.2044919589189456,{"$f":"N88*0.454","v":0.54683934934920131},24,0.5,2.9,0.04,0.49,0.04,0.52,0.19,0.1,0.01,6.4,247,83.9,0.01,25.6]
[null,82,"Soybean Hulls",2000,180,90,12.4,47,68,2.4584584,1.1161401136,1.5700327087770276,0.71279484978477059,0.97063123377619531,0.44066658013439269,65,0.4,2.2799999999999998,0.6,0.15,0.04,1.34,0.27,0.12,0.6,7.55,437,20,0.14000000000000001,44.8]
[null,83,"Soybean meal, 48%",2000,330,89,52.8,70.400000000000006,79.5,2.8742271000000001,1.3048991034000001,1.926965461695485,0.87484231960975023,1.2836399550777542,0.5827725396053004,11.3,0.2,1.9,0.42,0.75,0.04,2.36,0.32,0.41,0.75,15.9,202,42,0.53,51.7]
[null,84,"Soybeans, Whole",2000,240,88,40,71,91,3.2899958000000002,1.4936580932000001,2.2674893622389645,1.0294401704564899,1.5728615065824036,0.71407912398841122,18,0.3,20.6,0.27,0.64,0.04,2,0.25,0.34,1.01,15,139,31.6,null,47.2]
[null,85,"Sunflower Seed Hulls",2000,250,90,4,35,40,1.4461519999999999,0.65655300799999994,0.60437755620585709,0.27438741051745913,7.6537865109784997E-2,3.4748190759842389E-2,73,0.5,2.2000000000000002,0,0.11,0.04,0.2,null,0.19,null,null,null,null,null,200]
[null,86,"Sunflower Seed Meal with hulls",2000,280,92,32,71,66,2.3861508000000002,1.0833124632000002,1.5059475109997909,0.68370016999390504,0.91337759696881893,0.4146734290238438,40,0.5,11.5,0.42,1.04,0.04,1.27,0.55000000000000004,0.39,0.62,29,220,44,1.04,87.4]
[null,87,"Wheat Grain, rolled",2000,220,89,13.8,64,86.8,3.1381498399999996,1.4247200273599998,2.1447401637048498,0.97371203432200182,1.4696577828815323,0.6672246334282157,12.4,0.3,1.9,0.08,0.36,0.04,0.43,0.13,0.15,0.02,5.4,72,43,0.05,29.3]
[null,88,"Wheat Bran",2000,240,90,17.5,64,71.900000000000006,2.5994582199999998,1.1801540318799999,1.6931991596263454,0.76871241847036087,1.0797740067600241,0.49021739906905099,40,0.4,4.3,0.13,1.04,0.04,1.2,0.42,0.24,null,12.4,165,131,null,79]
[null,89,"Wheat Middlings",2000,240,89,18.5,68,72.900000000000006,2.6356120199999999,1.19656785708,1.7244138326901588,0.78288388004133214,1.1072460610949006,0.50268971173708488,38.299999999999997,0.3,4.0999999999999996,0.12,1.1000000000000001,0.04,1.1499999999999999,0.43,0.2,0.56000000000000005,12.8,144,136.6,0.39,87.9]
[null,90,"Wheat Mill Run",2000,225,90,17,72,75,2.711535,1.2310368900000002,1.7895003785133232,0.81243317184504882,1.164281729047608,0.52858390498761398,37,0.3,4.4000000000000004,0.12,1,0.04,1.2,null,0.22,null,21,null,null,null,90]
[null,91,"Wheat Shorts",2000,215,89,20,75,80,2.8923039999999998,1.3131060159999999,1.9420793047682641,0.8817040043647919,1.2966713834226633,0.58868880807388912,30,0.2,5.4,0.1,0.95,0.04,1.1000000000000001,null,0.2,null,13,null,null,null,118]
[null,92,"Finishing Ration",2000,170,75,13.5,65,88.3,3.1923805399999998,1.4493407651599999,2.1887749495201052,0.99370382708212779,1.5068160381276203,0.68409448130993966,12,0.6,5,0.6,0.3,0.08,0.6,0.2,0.25,0.2,12,100,40,0.2,50]
[null,93,"Added Feed",2000,0,null,null,null,70,{"$f":"(I100/100*4.409)*0.82","v":2.5307659999999994},{"$f":"J100*0.454","v":1.1489677639999998},1.6334846591300103,{"$f":"L100*0.454","v":0.74160203524502466},1.027006287674411,{"$f":"N100*0.454","v":0.46626085460418265}]
[null,94,"Added Feed",2000,0,null,null,null,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265]
[null,95,"Added Feed",2000,0,null,null,null,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265]
[null,96,"Added Feed",2000,0,null,null,null,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265]
[null,97,"Added Feed",2000,0,null,null,null,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265]
[null,null,"Commercial Feeds"]
[null,{"$f":"B104+1","v":98},"Alfalfa Pellets",2000,157,91,18.456,70,57.332000000000001,2.0727696616000002,0.94103742636640009,1.22030144991166,0.55401685825989366,0.65440963597626434,0.29710197473322403,45.677,0.4,2.4369999999999998,1.4710000000000001,0.28199999999999997,0.04,2.266,0.29299999999999998,0.25,1.77,10.994,688,57.588000000000001,0.19,35.234999999999999]
[null,{"$f":"B106+1","v":99},"Aalfala Cubes",2000,150,91,17.100000000000001,71,57,2.0607665999999996,0.93558803639999988,1.2090890829722096,0.54892644366938315,0.64412177411195115,{"$f":"IF(M107<0,0,M107*0.454)","v":0.24921260542589996},45.5,0.6,2.2000000000000002,1.5,0.24,0.04,2.15,0.28999999999999998,0.28000000000000003,0.66,8.8000000000000007,720,47.8,0.51,25.6]
[null,{"$f":"B107+1","v":100},"Alfalfa Dehydrated, 17% CP",2000,175,91,17.899999999999999,69,57,2.0607665999999996,0.93558803639999988,1.2090890829722096,0.54892644366938315,0.64412177411195115,0.24921260542589996,46.7,0.4,2.4,1.47,0.28000000000000003,0.04,2.2000000000000002,0.28000000000000003,0.27,0.8,9.6,646,54,0.18,31.7]
[null,101,"Cane molasses",2000,200,75,5.8,50,72,2.6030735999999997,1.1817954143999998,1.69632717935123,0.77013253942545845,1.0825304320890257,0.34964017289915816,0,0,1,1,0.11,0.06,3.84,0.43,0.47,1.21,79,250,56,0.1,30]
[null,102,"Liquid 20%",2000,200,61,20,85,75,2.711535,1.2310368900000002,1.7895003785133232,0.81243317184504882,1.164281729047608,0.52858390498761398,0,0,2.2999999999999998,2.2999999999999998,0.7,1,3.4,0.7,0.6,3,400,170,900,2.5,900]
[null,103,"Liquid 25%",2000,215,60,25,90,72,2.6030735999999997,1.1817954143999998,1.69632717935123,0.77013253942545845,1.0825304320890257,0.49146881616841764,0,0,0.8,0.46,1.04,1.9,3.8,0.85,0.88,4.3,431,204.4,1033,4.3,1035]
[null,104,"Liquid 30%",2000,225,59,30,95,72,2.6030735999999997,1.1817954143999998,1.69632717935123,0.77013253942545845,1.0825304320890257,0.49146881616841764,0,0,null,null,null,2,4,0.9,0.92,5,460,225,1100,5.5,1100]
[null,105,"Protein block",2000,350,87,28.7,65,82,2.9646115999999996,1.3459336663999999,2.0022319337180088,0.90901329790797603,1.3483560818026636,0.6121536611384093,25,0.2,1,2.5,1,6,1.4,0.5,0.3,null,16,null,null,1.2]
[null,106,"Range Cube, 20%",2000,325,89,22.5,60,77,2.7838425999999998,1.2638645404,1.8509235240597759,0.84031927992313826,1.217799670990042,{"$f":"N114*0.454","v":0.55288105062947912},30,0.3,2.25,1.98,0.81,0.68,0.81,0.45,0.2,0.37,19,30,85,0.1,110]
[null,107,"Range Cube, 25%",2000,360,89,28,65,76,2.7476887999999997,1.2474507151999998,1.8202791985683366,0.8264067561500249,1.1911366861696902,{"$f":"N115*0.454","v":0.54077605552103936},30,0.3,null,2,1.1000000000000001,1]
[null,108,"Range Cube, 32%",2000,385,89,35.5,70,76,2.7476887999999997,1.2474507151999998,1.8202791985683366,0.8264067561500249,1.1911366861696902,0.54077605552103936,30,0.3,1.8,2,0.99,0.63,0.9,0.45,0.2,0.37,19,30,80,0.1,110]
[null,109,"Range Cube, 38%",2000,415,89,42.7,75,78,2.8199964,1.2802783656000001,1.8814363321492031,0.8541720947957383,1.2442741426868578,0.56490046077983347,30,0.3,null,2,1.4,1]
[null,110,"B-283 Oklahoma Gold Cube w Rumensin",2000,400,90,42.9,80,75,{"$f":"(I118/100*4.409)*0.82","v":2.711535},{"$f":"J118*0.454","v":1.2310368900000002},1.7895003785133232,{"$f":"L118*0.454","v":0.81243317184504882},1.164281729047608,{"$f":"N118*0.454","v":0.52858390498761398},24,0.1,1.7,0.65,1.1000000000000001,1,1.8,0.6,0.4,8.25,42.2,116,43,1.4,143]
[null,111,"1925 Hfr Feed Intake TMR, R2",2000,250,88.5,14,60,66.7,2.4114584599999995,1.0948021408399997,1.5284508521856934,0.69391668689230479,0.93351803997600369,0.42381719014910568,41.5,0.6,4.0999999999999996,0.75,0.4,1,1.05,0.3,0.2,0.37,21.9,126,102.5,0.3,70.8]
[null,112,"1920 TMR, Creep Feed",2000,200,88,17.399999999999999,70,71,2.5669197999999995,1.1653815891999999,1.6649806094263102,0.75590119667954481,1.0548729939780714,0.47891233926604443,36,0.75,4,0.88,0.73,1,0.7,0.3,0.31,0.44,97,135,97,1.4,188]
[null,113,"OSU 25 Custom Liquid NPT 7294",2000,251,58,43.6,80,79,2.8561501999999996,1.2966921908,1.9118205999981783,0.86796655239917297,1.2705635604383341,0.5768358564390037,2,0,0.8,0.46,1.04,1.44,3.8,0.85,0.88,4.3,431.3,204,1034,4.3,1036]
[null,114,"Added Feed",2000,0,null,null,0,70,{"$f":"(I122/100*4.409)*0.82","v":2.5307659999999994},{"$f":"J122*0.454","v":1.1489677639999998},1.6334846591300103,{"$f":"L122*0.454","v":0.74160203524502466},1.027006287674411,{"$f":"N122*0.454","v":0.46626085460418265}]
[null,115,"Added Feed",2000,0,null,null,0,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265]
[null,116,"Added Feed",2000,0,null,null,0,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265]
[null,117,"Added Feed",2000,0,null,null,0,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265]
[null,118,"Added Feed",2000,0,null,null,0,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265]
[null,119,"Added Feed",2000,0,null,null,0,70,2.5307659999999994,1.1489677639999998,1.6334846591300103,0.74160203524502466,1.027006287674411,0.46626085460418265]
[null,null,"Mineral and Vitamins"]
[null,{"$f":"B127+1","v":120},"Calcium Carbonate",2000,200,100,0,0,0,{"$f":"IF(I129=0,0,(((I129/100)*4.4)*0.82))","v":0},{"$f":"J129*0.454","v":0},{"$f":"IF(I129<29,0,((1.37*J129)-(0.138*J129^2)+(0.0105*J129^3))-1.12)","v":0},{"$f":"L129*0.454","v":0},{"$f":"IF(I129<38,0,((1.42*J129)-(0.174*J129^2)+(0.0122*J129^3)-1.65))","v":0},{"$f":"N129*0.454","v":0},0,0,0,39.4,0.04,null,0.06,0.05,null,null,null,300,300]
[null,{"$f":"B129+1","v":121},"Cobalt Carbonate",2000,0,99,{"$f":"IF(L130=0,0,((1.42*P130)-(0.174*P130^2)+(0.0122*P130^3)-1.65))","v":0},{"$f":"G130*0.454","v":0},0,{"$f":"IF(I130=0,0,(((I130/100)*4.4)*0.82))","v":0},{"$f":"J130*0.454","v":0},{"$f":"IF(I130<29,0,((1.37*J130)-(0.138*J130^2)+(0.0105*J130^3))-1.12)","v":0},{"$f":"L130*0.454","v":0},{"$f":"IF(I130<38,0,((1.42*J130)-(0.174*J130^2)+(0.0122*J130^3)-1.65))","v":0},0,{"$f":"(((L130/100)*4.4)*0.82)","v":0},{"$f":"P130*0.454","v":0},null,null,null,null,null,null,null,460000]
[null,{"$f":"B130+1","v":122},"Cobalt Sulfate",2000,0,99,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,210000]
[null,123,"Copper Sulfate",2000,0,99,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,25200]
[null,124,"Dicalcium phosphate",2000,0,97,0,0,0,0,0,0,0,0,0,0,0,null,22,19.3,null,0,0.59,1.1399999999999999,0,10,14400,330,0,100]
[null,125,"Limestone 38%",2000,175,99,0,0,0,0,0,0,0,0,0,0,0,null,39.4,0.09,null,0.09,0.17,0.01,0,33,542,281,0,39]
[null,126,"Magnesium Oxide",2000,0,99,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,54,null,null,null,null,600000]
[null,127,"Potassium chloride",2000,0,99,0,0,0,0,0,0,0,0,0,0,0,null,0.05,null,null,50.54,0.11,0.19,null,null,600]
[null,128,"Selenium 600",2000,0,99,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,600]
[null,129,"Sodium Chloride",2000,150,99,{"$f":"IF(L138=0,0,((1.42*P138)-(0.174*P138^2)+(0.0122*P138^3)-1.65))","v":0},{"$f":"G138*0.454","v":0},1,{"$f":"IF(I138=0,0,(((I138/100)*4.4)*0.82))","v":3.6080000000000001E-2},{"$f":"J138*0.454","v":1.638032E-2},{"$f":"IF(I138<29,0,((1.37*J138)-(0.138*J138^2)+(0.0105*J138^3))-1.12)","v":0},{"$f":"L138*0.454","v":0},{"$f":"IF(I138<38,0,((1.42*J138)-(0.174*J138^2)+(0.0122*J138^3)-1.65))","v":0},{"$f":"N138*0.454","v":0},{"$f":"(((L138/100)*4.4)*0.82)","v":0},{"$f":"P138*0.454","v":0},null,null,null,39]
[null,130,"Zinc Oxide",2000,0,97,{"$f":"IF(L139=0,0,((1.42*P139)-(0.174*P139^2)+(0.0122*P139^3)-1.65))","v":0},{"$f":"G139*0.454","v":0},0,{"$f":"IF(I139=0,0,(((I139/100)*4.4)*0.82))","v":0},{"$f":"J139*0.454","v":0},{"$f":"IF(I139<29,0,((1.37*J139)-(0.138*J139^2)+(0.0105*J139^3))-1.12)","v":0},{"$f":"L139*0.454","v":0},{"$f":"IF(I139<38,0,((1.42*J139)-(0.174*J139^2)+(0.0122*J139^3)-1.65))","v":0},{"$f":"N139*0.454","v":0},{"$f":"(((L139/100)*4.4)*0.82)","v":0},{"$f":"P139*0.454","v":0},null,null,null,null,null,null,null,null,null,null,null,null,720000]
[null,131,"Zinc Sulfate",2000,0,99,{"$f":"IF(L140=0,0,((1.42*P140)-(0.174*P140^2)+(0.0122*P140^3)-1.65))","v":0},{"$f":"G140*0.454","v":0},0,{"$f":"IF(I140=0,0,(((I140/100)*4.4)*0.82))","v":0},{"$f":"J140*0.454","v":0},0,{"$f":"L140*0.454","v":0},0,{"$f":"N140*0.454","v":0},{"$f":"(((L140/100)*4.4)*0.82)","v":0},{"$f":"P140*0.454","v":0},null,null,null,null,null,null,null,null,null,null,null,null,360000]
[null,132,"Stillwater CTC 2.0 Beef Mineral",2000,800,98,0,0,0,{"$f":"IF(I141=0,0,(((I141/100)*4.4)*0.82))","v":0},{"$f":"J141*0.454","v":0},0,{"$f":"L141*0.454","v":0},0,{"$f":"N141*0.454","v":0},0,0,2,15,7,null,0.7,0.3,null,null,2600,null,null,26.4,4100]
[null,133,"B-628 Dry TMR Supplement",2000,300,95,19.899999999999999,75,45,{"$f":"IF(I142=0,0,(((I142/100)*4.4)*0.82))","v":1.6236000000000002},{"$f":"J142*0.454","v":0.73711440000000006},0.78549269231868823,{"$f":"L142*0.454","v":0.35661368231268448},0.24904981049752339,{"$f":"N142*0.454","v":0.11306861396587563},5,0,0.5,13.4,0.32,null,0.91,0.18,0.16,0.26,17,262,110,0.05,34.299999999999997]
[null,134,"Sweetlix Aureo FC C6000",2000,1100,99,0,0,0,{"$f":"IF(I143=0,0,(((I143/100)*4.4)*0.82))","v":0},{"$f":"J143*0.454","v":0},0,{"$f":"L143*0.454","v":0},0,{"$f":"N143*0.454","v":0},0,0,0,10,9.5,null,1.2,6,0.16,0.26,750,150,2900,10,3000]
[null,135,"Deccox, 6%",2000,1500,95,10,0,70,{"$f":"IF(I144=0,0,(((I144/100)*4.4)*0.82))","v":2.5255999999999998},{"$f":"J144*0.454","v":1.1466224},1.6289718460807681,{"$f":"L144*0.454","v":0.73955321812066876},1.0230071374820353,{"$f":"N144*0.454","v":0.46444524041684404},{"$f":"(((L144/100)*4.4)*0.82)","v":5.8773304206594122E-2},{"$f":"P144*0.454","v":2.6683080109793731E-2}]
[null,136,"B-350 RCRC Mineral",2000,1075,99,3.65,70,10,{"$f":"IF(I145=0,0,(((I145/100)*4.4)*0.82))","v":0.36080000000000001},{"$f":"J145*0.454","v":0.16380320000000001},0,{"$f":"L145*0.454","v":0},0,{"$f":"N145*0.454","v":0},0,{"$f":"P145*0.454","v":0},1.39,10,5,7.6,0.74,1.07,0.33,149,2022,3734,3110,31,6036]
[null,137,"Added Feed",2000,0,0,null,null,70,{"$f":"IF(I146=0,0,(((I146/100)*4.4)*0.82))","v":2.5255999999999998},{"$f":"J146*0.454","v":1.1466224},1.6289718460807681,{"$f":"L146*0.454","v":0.73955321812066876},1.0230071374820353,{"$f":"N146*0.454","v":0.46444524041684404}]
[null,138,"Added Feed",2000,0,0,null,null,70,2.5255999999999998,1.1466224,1.6289718460807681,0.73955321812066876,1.0230071374820353,0.46444524041684404]
[null,139,"Added Feed",2000,0,0,null,null,70,2.5255999999999998,1.1466224,1.6289718460807681,0.73955321812066876,1.0230071374820353,0.46444524041684404]
[null,140,"Added Feed",2000,0,0,null,0,70,{"$f":"IF(I149=0,0,(((I149/100)*4.4)*0.82))","v":2.5255999999999998},{"$f":"J149*0.454","v":1.1466224},1.6289718460807681,{"$f":"L149*0.454","v":0.73955321812066876},1.0230071374820353,{"$f":"N149*0.454","v":0.46444524041684404},0,0]
[null,141,"Added Feed",2000,0,0,null,0,70,2.5255999999999998,1.1466224,1.6289718460807681,0.73955321812066876,1.0230071374820353,0.46444524041684404,0,0]

{"sheet":" Summary","index":4,"n_rows":38,"n_cols":20,"rows_kept":38,"cut":false,"hidden":false,"merged":[[24,8,24,9],[24,10,24,11],[35,7,35,11],[36,7,36,11],[37,7,37,11],[34,7,34,11],[3,8,3,11],[4,8,4,11],[30,6,30,11],[31,6,31,11],[32,6,32,11],[26,8,26,10],[27,8,27,10],[10,9,10,11],[7,9,7,10],[28,8,28,10],[29,8,29,10],[25,8,25,10]]}
[]
[]
[]
[null,null,null,null,null,null,{"$f":"Cattle!C3","v":"Pistol Pete, Bullet Ranch"},null,{"$f":"Cattle!F3","v":"Angus cows, 1200 lb, BCS = 5"}]
[null,null,null,null,null,null,{"$f":"Cattle!C4","v":"(405) 718-2134"},null,{"$f":"Cattle!F4","v":"2020 dry cow precalving"}]
[]
[]
[null,null,null,null,null,null,"Batch Size, lb",2000,null,"Diet Dry Matter, %",null,{"$f":"S23","v":90.807999999999993}]
[]
[]
[]
[null,null,null,null,null,null,"Feed Ingredient","% DM","% As Fed","lb/Head","Batch,lb","Cumulative",null,null,null,null,"$/day","% comp","DM parts","% DM"]
[null,null,null,null,null,null,{"$f":"Balancer!$D$8","v":"Prairie Hay, mature"},{"$f":"IF(N13=TRUE,P13/$P$23*100,0)","v":87.584794291251882},{"$f":"IF(N13=TRUE,J13/$J$23*100,0)","v":87.4},{"$f":"IF(N13=TRUE, 'Nutrient and Energy Balance'!E8,0)","v":21.85},{"$f":"IF(N13=TRUE,$H$8*(I13/100),0)","v":1748.0000000000002},{"$f":"IF(J13=0,0,SUM(K$13:$K13))","v":1748.0000000000002},null,true,{"$f":"J13*'Nutrient and Energy Balance'!H8/100","v":19.883500000000002},{"$f":"IF(N13=TRUE, O13,0)","v":19.883500000000002},{"$f":"IF(J13>0, 'Nutrient and Energy Balance'!F8, 0)","v":0.60087500000000005},{"$f":"J13/$J$23*100","v":87.4},{"$f":"R13/100*T13","v":79.534000000000006},{"$f":"'Nutrient and Energy Balance'!H8","v":91}]
[null,null,null,null,null,null,{"$f":"Balancer!$D$9","v":"Range Cube, 25%"},{"$f":"IF(N14=TRUE,P14/$P$23*100,0)","v":11.76107831909083},12,{"$f":"IF(N14=TRUE, 'Nutrient and Energy Balance'!E9,0)","v":3},240,{"$f":"IF(J14=0,0,SUM(K$13:$K14))","v":1988.0000000000002},null,true,{"$f":"J14*'Nutrient and Energy Balance'!H9/100","v":2.67},{"$f":"IF(N14=TRUE, O14,0)","v":2.67},{"$f":"IF(J14>0, 'Nutrient and Energy Balance'!F9, 0)","v":0.54},{"$f":"J14/$J$23*100","v":12},{"$f":"R14/100*T14","v":10.68},{"$f":"'Nutrient and Energy Balance'!H9","v":89}]
[null,null,null,null,null,null,{"$f":"Balancer!$D$10","v":"B-350 RCRC Mineral"},0.654127389657299,0.6,{"$f":"IF(N15=TRUE, 'Nutrient and Energy Balance'!E10,0)","v":0.15},12,{"$f":"IF(J15=0,0,SUM(K$13:$K15))","v":2000.0000000000002},null,true,{"$f":"J15*'Nutrient and Energy Balance'!H10/100","v":0.14849999999999999},0.14849999999999999,{"$f":"IF(J15>0, 'Nutrient and Energy Balance'!F10, 0)","v":8.0624999999999988E-2},0.6,0.59399999999999997,{"$f":"'Nutrient and Energy Balance'!H10","v":99}]
[null,null,null,null,null,null,{"$f":"Balancer!$D$11","v":0},0,0,{"$f":"IF(N16=TRUE, 'Nutrient and Energy Balance'!E11,0)","v":0},0,{"$f":"IF(J16=0,0,SUM(K$13:$K16))","v":0},null,true,{"$f":"J16*'Nutrient and Energy Balance'!H11/100","v":0},0,{"$f":"IF(J16>0, 'Nutrient and Energy Balance'!F11, 0)","v":0},0,0,{"$f":"'Nutrient and Energy Balance'!H11","v":0}]
[null,null,null,null,null,null,{"$f":"Balancer!$D$12","v":0},0,0,{"$f":"IF(N17=TRUE, 'Nutrient and Energy Balance'!E12,0)","v":0},0,{"$f":"IF(J17=0,0,SUM(K$13:$K17))","v":0},null,true,{"$f":"J17*'Nutrient and Energy Balance'!H12/100","v":0},0,{"$f":"IF(J17>0, 'Nutrient and Energy Balance'!F12, 0)","v":0},0,0,{"$f":"'Nutrient and Energy Balance'!H12","v":0}]
[null,null,null,null,null,null,{"$f":"Balancer!$D$13","v":0},0,0,{"$f":"IF(N18=TRUE, 'Nutrient and Energy Balance'!E13,0)","v":0},0,{"$f":"IF(J18=0,0,SUM(K$13:$K18))","v":0},null,true,{"$f":"J18*'Nutrient and Energy Balance'!H13/100","v":0},0,{"$f":"IF(J18>0, 'Nutrient and Energy Balance'!F13, 0)","v":0},0,0,{"$f":"'Nutrient and Energy Balance'!H13","v":0}]
[null,null,null,null,null,null,{"$f":"Balancer!$D$14","v":0},0,0,{"$f":"IF(N19=TRUE, 'Nutrient and Energy Balance'!E14,0)","v":0},0,{"$f":"IF(J19=0,0,SUM(K$13:$K19))","v":0},null,true,{"$f":"J19*'Nutrient and Energy Balance'!H14/100","v":0},0,{"$f":"IF(J19>0, 'Nutrient and Energy Balance'!F14, 0)","v":0},0,0,{"$f":"'Nutrient and Energy Balance'!H14","v":0}]
[null,null,null,null,null,null,{"$f":"Balancer!$D$15","v":0},0,0,{"$f":"IF(N20=TRUE, 'Nutrient and Energy Balance'!E15,0)","v":0},0,{"$f":"IF(J20=0,0,SUM(K$13:$K20))","v":0},null,true,{"$f":"J20*'Nutrient and Energy Balance'!H15/100","v":0},0,{"$f":"IF(J20>0, 'Nutrient and Energy Balance'!F15, 0)","v":0},0,0,{"$f":"'Nutrient and Energy Balance'!H15","v":0}]
[null,null,null,null,null,null,{"$f":"Balancer!$D$16","v":0},0,0,{"$f":"IF(N21=TRUE, 'Nutrient and Energy Balance'!E16,0)","v":0},0,{"$f":"IF(J21=0,0,SUM(K$13:$K21))","v":0},null,true,{"$f":"J21*'Nutrient and Energy Balance'!H16/100","v":0},0,{"$f":"IF(J21>0, 'Nutrient and Energy Balance'!F16, 0)","v":0},0,0,{"$f":"'Nutrient and Energy Balance'!H16","v":0}]
[null,null,null,null,null,null,{"$f":"Balancer!$D$17","v":0},0,0,{"$f":"IF(N22=TRUE, 'Nutrient and Energy Balance'!E17,0)","v":0},0,{"$f":"IF(J22=0,0,SUM(K$13:$K22))","v":0},null,true,{"$f":"J22*'Nutrient and Energy Balance'!H17/100","v":0},0,{"$f":"IF(J22>0, 'Nutrient and Energy Balance'!F17, 0)","v":0},0,0,{"$f":"'Nutrient and Energy Balance'!H17","v":0}]
[null,null,null,null,null,null,"Total",null,{"$f":"SUM(I13:I22)","v":100},{"$f":"SUM(J13:J22)","v":25},{"$f":"SUM(K13:K22)","v":2000.0000000000002},null,null,null,null,{"$f":"SUM(P13:P22)","v":22.701999999999998},{"$f":"SUM(Q13:Q22)","v":1.2215},null,{"$f":"SUM(S13:S22)","v":90.807999999999993}]
[]
[null,null,null,null,null,null,"Finish or Mature Weight",{"$f":"IF(Cattle!B7 = \"Growing and Finishing Cattle\", Cattle!E15, Cattle!D11)","v":1200},"Genetic Potential",null,{"$f":"IF(Cattle!B7 = \"Growing and Finishing Cattle\", Cattle!F15, Cattle!F11)","v":"Average"}]
[null,null,null,null,null,null,"Ionophore",{"$f":"IF(Cattle!B7=\"Growing and Finishing Cattle\", Cattle!G15, \" \")","v":" "},"Implant",null,null,{"$f":"IF(Cattle!B7 = \"Growing and Finishing Cattle\", Cattle!H15, \" \")","v":" "}]
[null,null,null,null,null,null,"Initial BCS",{"$f":"IF(Cattle!B7 = \"Growing and Finishing Cattle\", Cattle!I15, Cattle!H11)","v":5},"Projected ADG",null,null,{"$f":"Balancer!C21","v":1.2173560575126212}]
[null,null,null,null,null,null,"Length of Period, Days ",{"$f":"Cattle!E7","v":90},"Feed Intake, lb DM",null,null,{"$f":"Balancer!F22","v":22.701999999999998}]
[null,null,null,null,null,null,"Initial Weight, lb",{"$f":"Balancer!L28","v":1200},"Final Weight, lb",null,null,{"$f":"Balancer!L29","v":1309.5620451761358}]
[null,null,null,null,null,null,"Cost Per Day",{"$f":"'Nutrient and Energy Balance'!G18","v":1.2215},"Cost per Ton, As Fed",null,null,{"$f":"(Q23/J23)*2000","v":97.72}]
[null,null,null,null,null,null,"   Comments:"]
[null,null,null,null,null,null,"This example is for dry beef cows during late gestation consuming hay, supplement and mineral."]
[]
[null,null,null,null,null,null,"Prepared by"]
[null,null,null,null,null,null,"Title"]
[null,null,null,null,null,null,"Address"]
[null,null,null,null,null,null,"Phone"]
[null,null,null,null,null,null,"Email"]

{"sheet":"BCS","index":5,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[14,7,19,7],[14,9,15,9],[16,9,17,9],[18,9,19,9],[2,7,7,7],[2,9,3,9],[4,9,5,9],[6,9,7,9],[8,7,13,7],[8,9,9,9],[10,9,11,9],[12,9,13,9]]}
[]
[null,null,null,null,null,null,null,null,"BCS","Description"]
[null,null,null,null,null,null,null,"Thin",1,"No palpable fat over spinous processes, transverse processes, hip bones, or ribs.  Tail head and ribs project quite prominently. "]
[null,null,null,null,null,null,null,null,"Emaciated"]
[null,null,1,null,null,null,null,null,2,"Tail head and ribs are less prominent.  Individual spinous processes are still sharp to the touch, but some tissue cover on dorsal portion of ribs. "]
[null,null,null,null,null,null,null,null,"Very Thin"]
[null,null,null,null,null,null,null,null,3,"Ribs are individually identifiable but not as sharp to the touch. Obvious palpable fat along spine and over tail head with some tissue cover on dorsal portion of the ribs."]
[null,null,null,null,null,null,null,null,"Thin"]
[null,null,3,null,null,null,null,"Optimum/moderate",4,"Individual ribs are no longer visually obvious.  The spinous processes can be identified individually on palpation but feel rounded rather than sharp.  Some fat cover over ribs, transverse processes, and hip bones. "]
[null,null,null,null,null,null,null,null,"Borderline "]
[null,null,null,null,null,null,null,null,5,"Cow has generally good overall appearance.  On palpation, slight fat cover over ribs feels spongy and areas on either side of tail head have palpable fat cover. "]
[null,null,null,null,null,null,null,null,"Moderate"]
[null,null,5,null,null,null,null,null,6,"Some fat in brisket.  Firm pressure required to feel spinous processes.  A high degree of fat is palpable over ribs and around tail head."]
[null,null,null,null,null,null,null,null,"High Moderate"]
[null,null,null,null,null,null,null,"Fat",7,"Brisket is full. Very spongy fat cover over ribs and around tail head. “Pones” beginning to be obvious.  Some fat around the vulva and in crotch."]
[null,null,null,null,null,null,null,null,"Fleshy"]
[null,null,7,null,null,null,null,null,8,"Cow very fleshy and over-conditioned.  Spinous processes almost impossible to palpate.  Cow has large fat deposits over ribs and around tail head, and below vulva. “Pones” are obvious. "]
[null,null,null,null,null,null,null,null,"Fat"]
[null,null,null,null,null,null,null,null,9,"Cow looks patchy and blocky.  Tail head and hips buried in fatty tissue and “pones” of fat are protruding.  Bone structure no longer visible and barely palpable.  Animal’s mobility might even be impaired by large fatty deposits. "]
[null,null,null,null,null,null,null,null,"Extremely Fat"]

{"sheet":"Finish Weight","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Nutrient and Energy Balance","index":7,"n_rows":94,"n_cols":32,"rows_kept":94,"cut":false,"hidden":true,"merged":[[0,1,0,4]]}
[null,"Nutrient and Energy Balance",null,null,null,null,null,null,null,"Nutrient and Energy Balance"]
[]
[]
[]
[]
[null,null,null,null,null,"Dietary Components, Nutrient Concentration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"peNDF"]
[null,"Feed Ingredient","Units","Unit Cost","Lb as fed","Cost/day","Cost/d","D.M. %","PROT %","TDN %","ME Mcal/kg","NEM Mcal/kg","NEG Mcal/kg","CA%","PHOS %","Na, %","K%","MG %","S %","CO ppm","CU ppm","FE ppm","MN ppm","SE ppm","ZN ppm","NDF%","% of NDF","Fat %","Na","Cl"]
[null,{"$f":"Balancer!D8","v":"Prairie Hay, mature"},{"$f":"IFERROR(VLOOKUP(Balancer!D8,'Feed List'!C5:AD168,2,),)","v":2000},{"$f":"IFERROR(VLOOKUP(Balancer!D8,'Feed List'!C5:AD154,3,),)","v":55},{"$f":"Balancer!$F$19*(Balancer!G8/100)","v":21.85},{"$f":"IFERROR((D8/C8)*E8,)","v":0.60087500000000005},{"$f":"IF(E8 = 0,0,F8)","v":0.60087500000000005},{"$f":"IFERROR(VLOOKUP(B8,'Feed List'!$C$5:AD168,4,FALSE),0)","v":91},{"$f":"IFERROR(VLOOKUP(Balancer!D8,'Feed List'!C5:AD168,5,),)","v":5.5},{"$f":"IFERROR(VLOOKUP(Balancer!D8,'Feed List'!C3:AD168,7,),)","v":53},{"$f":"IFERROR(VLOOKUP(Balancer!D8,'Feed List'!C5:AD168,8,),)*$L$40","v":1.9161513999999999},{"$f":"IF(J8<29,0,(1.37*K8-0.138*K8^2+0.0105*K8^3-1.12))","v":1.0723134377190071},{"$f":"IF(J8<38,0,(1.42*K8-0.174*K8^2+0.0122*K8^3-1.65))","v":0.51790230335738707},{"$f":"IFERROR(VLOOKUP(Balancer!$D8,'Feed List'!C5:AD168,17,),)","v":0.4},{"$f":"IFERROR(VLOOKUP(Balancer!D8,'Feed List'!C5:AD156,18,),)","v":0.15},{"$f":"IFERROR(VLOOKUP(Balancer!D8,'Feed List'!$C$5:$AE$156,19,),)","v":0.01},{"$f":"IFERROR(VLOOKUP(Balancer!D8,'Feed List'!$C$5:$AD$156,20,),)","v":1.1000000000000001},{"$f":"IFERROR(VLOOKUP(Balancer!D8,'Feed List'!$C$5:$AD$156,21,),)","v":0.2},{"$f":"IFERROR(VLOOKUP(Balancer!D8,'Feed List'!$C$5:$AD$156,22,),)","v":0.22},{"$f":"IFERROR(VLOOKUP(Balancer!D8,'Feed List'!$C$5:$AD$156,23,),)","v":0.15},{"$f":"IFERROR(VLOOKUP(Balancer!D8,'Feed List'!$C$5:$AD$156,24,),)","v":6},{"$f":"IFERROR(VLOOKUP(Balancer!D8,'Feed List'!$C$5:$AD$156,25,),)","v":300},{"$f":"IFERROR(VLOOKUP(Balancer!D8,'Feed List'!$C$5:$AD$156,26,),)","v":80},{"$f":"IFERROR(VLOOKUP(Balancer!D8,'Feed List'!$C$5:$AD$156,27,),)","v":0.11},{"$f":"IFERROR(VLOOKUP(Balancer!D8,'Feed List'!$C5:$AD156,28,),)","v":18},{"$f":"IFERROR(VLOOKUP(Balancer!D8,'Feed List'!$C$5:$AD$156,14,),)","v":73},{"$f":"IFERROR(VLOOKUP(Balancer!$D8,'Feed List'!$C$5:$AD$156,15,),)","v":1},{"$f":"IFERROR(VLOOKUP(Balancer!$D8,'Feed List'!$C$5:$AD$156,16,),)","v":2}]
[null,{"$f":"Balancer!D9","v":"Range Cube, 25%"},{"$f":"IFERROR(VLOOKUP(Balancer!D9,'Feed List'!C5:AD168,2,),)","v":2000},{"$f":"IFERROR(VLOOKUP(Balancer!D9,'Feed List'!C5:AD154,3,),)","v":360},{"$f":"Balancer!$F$19*(Balancer!G9/100)","v":3},0.54,{"$f":"IF(E9 = 0,0,F9)","v":0.54},{"$f":"IFERROR(VLOOKUP(B9,'Feed List'!$C$5:AD1168,4,FALSE),0)","v":89},{"$f":"IFERROR(VLOOKUP(Balancer!D9,'Feed List'!C5:AD168,5,),)","v":28},{"$f":"IFERROR(VLOOKUP(Balancer!D9,'Feed List'!C4:AD168,7,),)","v":76},{"$f":"IFERROR(VLOOKUP(Balancer!D9,'Feed List'!C5:AD168,8,),)*$L$40","v":2.7476887999999997},{"$f":"IF(J9<29,0,(1.37*K9-0.138*K9^2+0.0105*K9^3-1.12))","v":1.8202791985683366},{"$f":"IF(J9<38,0,(1.42*K9-0.174*K9^2+0.0122*K9^3-1.65))","v":1.1911366861696902},{"$f":"IFERROR(VLOOKUP(Balancer!$D9,'Feed List'!C$5:AD168,17,),)","v":2},{"$f":"IFERROR(VLOOKUP(Balancer!D9,'Feed List'!C5:AD156,18,),)","v":1.1000000000000001},{"$f":"IFERROR(VLOOKUP(Balancer!D9,'Feed List'!$C$5:$AE$156,19,),)","v":1},{"$f":"IFERROR(VLOOKUP(Balancer!D9,'Feed List'!$C$5:$AD$156,20,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D9,'Feed List'!$C$5:$AD$156,21,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D9,'Feed List'!$C$5:$AD$156,22,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D9,'Feed List'!$C$5:$AD$156,23,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D9,'Feed List'!$C$5:$AD$156,24,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D9,'Feed List'!$C$5:$AD$156,25,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D9,'Feed List'!$C$5:$AD$156,26,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D9,'Feed List'!$C$5:$AD$156,27,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D9,'Feed List'!$C6:$AD157,28,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D9,'Feed List'!$C$5:$AD$156,14,),)","v":30},{"$f":"IFERROR(VLOOKUP(Balancer!D9,'Feed List'!$C$5:$AD$156,15,),)","v":0.3},{"$f":"IFERROR(VLOOKUP(Balancer!$D9,'Feed List'!$C$5:$AD$156,16,),)","v":0}]
[null,{"$f":"Balancer!D10","v":"B-350 RCRC Mineral"},{"$f":"IFERROR(VLOOKUP(Balancer!D10,'Feed List'!C5:AD168,2,),0)","v":2000},{"$f":"IFERROR(VLOOKUP(Balancer!D10,'Feed List'!C5:AD154,3,),)","v":1075},{"$f":"Balancer!$F$19*(Balancer!G10/100)","v":0.15},{"$f":"IFERROR((D10/C10)*E10,)","v":8.0624999999999988E-2},8.0624999999999988E-2,{"$f":"IFERROR(VLOOKUP(B10,'Feed List'!$C$5:AD168,4,FALSE),0)","v":99},{"$f":"IFERROR(VLOOKUP(Balancer!D10,'Feed List'!C5:AD168,5,),)","v":3.65},{"$f":"IFERROR(VLOOKUP(Balancer!D10,'Feed List'!C5:AD168,7,),)","v":10},{"$f":"IFERROR(VLOOKUP(Balancer!D10,'Feed List'!C5:AD168,8,),)*$L$40","v":0.36080000000000001},0,0,{"$f":"IFERROR(VLOOKUP(Balancer!$D10,'Feed List'!C$5:AD168,17,),)","v":10},{"$f":"IFERROR(VLOOKUP(Balancer!D10,'Feed List'!C5:AD156,18,),)","v":5},{"$f":"IFERROR(VLOOKUP(Balancer!D10,'Feed List'!$C$5:$AE$156,19,),)","v":7.6},{"$f":"IFERROR(VLOOKUP(Balancer!D10,'Feed List'!$C$5:$AD$156,20,),)","v":0.74},{"$f":"IFERROR(VLOOKUP(Balancer!D10,'Feed List'!$C$5:$AD$156,21,),)","v":1.07},{"$f":"IFERROR(VLOOKUP(Balancer!D10,'Feed List'!$C$5:$AD$156,22,),)","v":0.33},{"$f":"IFERROR(VLOOKUP(Balancer!D10,'Feed List'!$C$5:$AD$156,23,),)","v":149},{"$f":"IFERROR(VLOOKUP(Balancer!D10,'Feed List'!$C$5:$AD$156,24,),)","v":2022},{"$f":"IFERROR(VLOOKUP(Balancer!D10,'Feed List'!$C$5:$AD$156,25,),)","v":3734},{"$f":"IFERROR(VLOOKUP(Balancer!D10,'Feed List'!$C$5:$AD$156,26,),)","v":3110},{"$f":"IFERROR(VLOOKUP(Balancer!D10,'Feed List'!$C$5:$AD$156,27,),)","v":31},{"$f":"IFERROR(VLOOKUP(Balancer!D10,'Feed List'!$C7:$AD158,28,),)","v":6036},{"$f":"IFERROR(VLOOKUP(Balancer!D10,'Feed List'!$C$5:$AD$156,14,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D10,'Feed List'!$C$5:$AD$156,15,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!$D10,'Feed List'!$C$5:$AD$156,16,),)","v":1.39}]
[null,{"$f":"Balancer!D11","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D11,'Feed List'!C5:AD168,2,),0)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D11,'Feed List'!C5:AD154,3,),)","v":0},{"$f":"Balancer!$F$19*(Balancer!G11/100)","v":0},{"$f":"IFERROR((D11/C11)*E11,)","v":0},0,{"$f":"IFERROR(VLOOKUP(B11,'Feed List'!$C$5:AD168,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D11,'Feed List'!C5:AD168,5,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D11,'Feed List'!C5:AD168,7,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D11,'Feed List'!C5:AD168,8,),)*$L$40","v":0},0,0,{"$f":"IFERROR(VLOOKUP(Balancer!$D11,'Feed List'!C$5:AD168,17,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D11,'Feed List'!C5:AD156,18,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D11,'Feed List'!$C$5:$AE$156,19,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D11,'Feed List'!$C$5:$AD$156,20,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D11,'Feed List'!$C$5:$AD$156,21,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D11,'Feed List'!$C$5:$AD$156,22,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D11,'Feed List'!$C$5:$AD$156,23,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D11,'Feed List'!$C$5:$AD$156,24,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D11,'Feed List'!$C$5:$AD$156,25,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D11,'Feed List'!$C$5:$AD$156,26,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D11,'Feed List'!$C$5:$AD$156,27,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D11,'Feed List'!$C8:$AD159,28,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D11,'Feed List'!$C$5:$AD$156,14,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D11,'Feed List'!$C$5:$AD$156,15,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!$D11,'Feed List'!$C$5:$AD$156,16,),)","v":0}]
[null,{"$f":"Balancer!D12","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D12,'Feed List'!C5:AD168,2,),0)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D12,'Feed List'!C5:AD154,3,),)","v":0},{"$f":"Balancer!$F$19*(Balancer!G12/100)","v":0},0,0,{"$f":"IFERROR(VLOOKUP(B12,'Feed List'!$C$5:AD168,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D12,'Feed List'!C5:AD168,5,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D12,'Feed List'!C5:AD168,7,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D12,'Feed List'!C5:AD168,8,),)*$L$40","v":0},0,0,{"$f":"IFERROR(VLOOKUP(Balancer!$D12,'Feed List'!C$5:AD168,17,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D12,'Feed List'!C5:AD156,18,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D12,'Feed List'!$C$5:$AE$156,19,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D12,'Feed List'!$C$5:$AD$156,20,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D12,'Feed List'!$C$5:$AD$156,21,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D12,'Feed List'!$C$5:$AD$156,22,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D12,'Feed List'!$C$5:$AD$156,23,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D12,'Feed List'!$C$5:$AD$156,24,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D12,'Feed List'!$C$5:$AD$156,25,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D12,'Feed List'!$C$5:$AD$156,26,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D12,'Feed List'!$C$5:$AD$156,27,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D12,'Feed List'!$C9:$AD160,28,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D12,'Feed List'!$C$5:$AD$156,14,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D12,'Feed List'!$C$5:$AD$156,15,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!$D12,'Feed List'!$C$5:$AD$156,16,),)","v":0}]
[null,{"$f":"Balancer!D13","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D13,'Feed List'!C5:AD168,2,),0)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D13,'Feed List'!C5:AD154,3,),)","v":0},{"$f":"Balancer!$F$19*(Balancer!G13/100)","v":0},0,0,{"$f":"IFERROR(VLOOKUP(B13,'Feed List'!$C$5:AD168,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D13,'Feed List'!C5:AD168,5,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D13,'Feed List'!C5:AD168,7,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D13,'Feed List'!C5:AD168,8,),)*$L$40","v":0},0,0,{"$f":"IFERROR(VLOOKUP(Balancer!$D13,'Feed List'!C$5:AD168,17,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D13,'Feed List'!C5:AD156,18,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D13,'Feed List'!$C$5:$AE$156,19,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D13,'Feed List'!$C$5:$AD$156,20,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D13,'Feed List'!$C$5:$AD$156,21,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D13,'Feed List'!$C$5:$AD$156,22,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D13,'Feed List'!$C$5:$AD$156,23,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D13,'Feed List'!$C$5:$AD$156,24,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D13,'Feed List'!$C$5:$AD$156,25,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D13,'Feed List'!$C$5:$AD$156,26,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D13,'Feed List'!$C$5:$AD$156,27,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D13,'Feed List'!$C10:$AD161,28,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D13,'Feed List'!$C$5:$AD$156,14,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D13,'Feed List'!$C$5:$AD$156,15,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!$D13,'Feed List'!$C$5:$AD$156,16,),)","v":0}]
[null,{"$f":"Balancer!D14","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D14,'Feed List'!C5:AD168,2,),0)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D14,'Feed List'!C5:AD154,3,),)","v":0},{"$f":"Balancer!$F$19*(Balancer!G14/100)","v":0},0,0,{"$f":"IFERROR(VLOOKUP(B14,'Feed List'!$C$5:AD168,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D14,'Feed List'!C5:AD168,5,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D14,'Feed List'!C5:AD168,7,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D14,'Feed List'!C5:AD168,8,),)*$L$40","v":0},0,0,{"$f":"IFERROR(VLOOKUP(Balancer!$D14,'Feed List'!C$5:AD168,17,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D14,'Feed List'!C5:AD156,18,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D14,'Feed List'!$C$5:$AE$156,19,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D14,'Feed List'!$C$5:$AD$156,20,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D14,'Feed List'!$C$5:$AD$156,21,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D14,'Feed List'!$C$5:$AD$156,22,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D14,'Feed List'!$C$5:$AD$156,23,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D14,'Feed List'!$C$5:$AD$156,24,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D14,'Feed List'!$C$5:$AD$156,25,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D14,'Feed List'!$C$5:$AD$156,26,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D14,'Feed List'!$C$5:$AD$156,27,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D14,'Feed List'!$C11:$AD162,28,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D14,'Feed List'!$C$5:$AD$156,14,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D14,'Feed List'!$C$5:$AD$156,15,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!$D14,'Feed List'!$C$5:$AD$156,16,),)","v":0}]
[null,{"$f":"Balancer!D15","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D15,'Feed List'!C5:AD168,2,),0)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D15,'Feed List'!C5:AD154,3,),)","v":0},{"$f":"Balancer!$F$19*(Balancer!G15/100)","v":0},0,0,{"$f":"IFERROR(VLOOKUP(B15,'Feed List'!$C$5:AD168,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D15,'Feed List'!C5:AD168,5,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D15,'Feed List'!C5:AD168,7,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D15,'Feed List'!C5:AD168,8,),)*$L$40","v":0},0,0,{"$f":"IFERROR(VLOOKUP(Balancer!$D15,'Feed List'!C$5:AD168,17,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D15,'Feed List'!C5:AD156,18,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D15,'Feed List'!$C$5:$AE$156,19,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D15,'Feed List'!$C$5:$AD$156,20,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D15,'Feed List'!$C$5:$AD$156,21,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D15,'Feed List'!$C$5:$AD$156,22,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D15,'Feed List'!$C$5:$AD$156,23,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D15,'Feed List'!$C$5:$AD$156,24,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D15,'Feed List'!$C$5:$AD$156,25,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D15,'Feed List'!$C$5:$AD$156,26,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D15,'Feed List'!$C$5:$AD$156,27,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D15,'Feed List'!$C12:$AD163,28,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D15,'Feed List'!$C$5:$AD$156,14,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D15,'Feed List'!$C$5:$AD$156,15,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!$D15,'Feed List'!$C$5:$AD$156,16,),)","v":0}]
[null,{"$f":"Balancer!D16","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D16,'Feed List'!C5:AD168,2,),0)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D16,'Feed List'!C5:AD154,3,),)","v":0},{"$f":"Balancer!$F$19*(Balancer!G16/100)","v":0},0,0,{"$f":"IFERROR(VLOOKUP(B16,'Feed List'!$C$5:AD168,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D16,'Feed List'!C5:AD168,5,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D16,'Feed List'!C5:AD168,7,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D16,'Feed List'!C5:AD168,8,),)*$L$40","v":0},0,0,{"$f":"IFERROR(VLOOKUP(Balancer!$D16,'Feed List'!C$5:AD168,17,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D16,'Feed List'!C5:AD156,18,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D16,'Feed List'!$C$5:$AE$156,19,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D16,'Feed List'!$C$5:$AD$156,20,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D16,'Feed List'!$C$5:$AD$156,21,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D16,'Feed List'!$C$5:$AD$156,22,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D16,'Feed List'!$C$5:$AD$156,23,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D16,'Feed List'!$C$5:$AD$156,24,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D16,'Feed List'!$C$5:$AD$156,25,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D16,'Feed List'!$C$5:$AD$156,26,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D16,'Feed List'!$C$5:$AD$156,27,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D16,'Feed List'!$C13:$AD164,28,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D16,'Feed List'!$C$5:$AD$156,14,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D16,'Feed List'!$C$5:$AD$156,15,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!$D16,'Feed List'!$C$5:$AD$156,16,),)","v":0}]
[null,{"$f":"Balancer!D17","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D17,'Feed List'!C5:AD168,2,),0)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D17,'Feed List'!C5:AD154,3,),)","v":0},{"$f":"Balancer!$F$19*(Balancer!G17/100)","v":0},0,0,{"$f":"IFERROR(VLOOKUP(B17,'Feed List'!$C$5:AD168,4,FALSE),0)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D17,'Feed List'!C5:AD168,5,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D17,'Feed List'!C5:AD168,7,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D17,'Feed List'!C5:AD168,8,),)*$L$40","v":0},0,0,{"$f":"IFERROR(VLOOKUP(Balancer!$D17,'Feed List'!C$5:AD168,17,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D17,'Feed List'!C5:AD156,18,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D17,'Feed List'!$C$5:$AE$156,19,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D17,'Feed List'!$C$5:$AD$156,20,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D17,'Feed List'!$C$5:$AD$156,21,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D17,'Feed List'!$C$5:$AD$156,22,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D17,'Feed List'!$C$5:$AD$156,23,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D17,'Feed List'!$C$5:$AD$156,24,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D17,'Feed List'!$C$5:$AD$156,25,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D17,'Feed List'!$C$5:$AD$156,26,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D17,'Feed List'!$C$5:$AD$156,27,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D17,'Feed List'!$C14:$AD165,28,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D17,'Feed List'!$C$5:$AD$156,14,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!D17,'Feed List'!$C$5:$AD$156,15,),)","v":0},{"$f":"IFERROR(VLOOKUP(Balancer!$D17,'Feed List'!$C$5:$AD$156,16,),)","v":0}]
[null,null,null,{"$f":"SUM(D8:D17)","v":1490},{"$f":"SUM(E8:E17)","v":25},1.2215,{"$f":"SUM(G8:G17)","v":1.2215}]
[]
[null,null,null,null,"Ingredient DM Intake, kg per Day",null,null,null,"kg","kg","Mcal","Mcal","Mcal","Grams","Grams","Grams",null,null,null,"Milligrams"]
[null,null,null,null,"Lb DM","Kg DM",null,"lb Protein","Protein","TDN","ME/day","NEM/day","NEG/day","CA/day","Phos/day","Na/day","K","MG","S","CO/day","CU","FE","MN","SE","ZN","NDF","peNDF","Fat, kg",null,null,"% Composition","DM parts"]
[null,{"$f":"Balancer!D8","v":"Prairie Hay, mature"},null,null,{"$f":"E8*(H8/100)","v":19.883500000000002},{"$f":"E22*0.454","v":9.0271090000000012},null,null,{"$f":"I8/100*$F22","v":0.49649099500000005},{"$f":"J8/100*$F22","v":4.7843677700000011},{"$f":"K8*$F22","v":17.297307548302602},{"$f":"L8*$F22","v":9.6798902844541903},{"$f":"M8*$F22","v":4.6751605437581993},{"$f":"N8/100*$F22*1000","v":36.108436000000005},{"$f":"O8/100*$F22*1000","v":13.540663500000003},0.90271090000000009,99.298199000000011,18.054218000000002,19.859639800000004,{"$f":"T8*$F22","v":1.3540663500000001},{"$f":"U8*$F22","v":54.162654000000003},2708.1327000000006,722.16872000000012,0.99298199000000009,{"$f":"Y8*$F22","v":162.48796200000001},{"$f":"Z8/100*$F22","v":6.5897895700000007},{"$f":"Z22*AA8","v":6.5897895700000007},{"$f":"AB8/100*$F22","v":0.18054218000000002},null,null,{"$f":"E8/$E$18*100","v":87.4},{"$f":"AE22/100*H8","v":79.534000000000006}]
[null,{"$f":"B9","v":"Range Cube, 25%"},null,null,{"$f":"E9*(H9/100)","v":2.67},{"$f":"E23*0.454","v":1.21218},null,null,{"$f":"I9/100*$F23","v":0.33941040000000006},0.92125679999999999,{"$f":"K9*$F23","v":3.3306934095839997},{"$f":"L9*$F23","v":2.2065060389205664},1.443872068241175,{"$f":"N9/100*$F23*1000","v":24.243600000000001},13.333980000000002,12.1218,0,{"$f":"R9/100*$F23*1000","v":0},0,{"$f":"T9*$F23","v":0},0,0,0,0,0,{"$f":"Z9/100*$F23","v":0.36365399999999998},{"$f":"Z23*AA9","v":0.10909619999999999},{"$f":"AB9/100*$F23","v":0},null,null,{"$f":"E9/$E$18*100","v":12},{"$f":"AE23/100*H9","v":10.68}]
[null,"B-350 RCRC Mineral",null,null,0.14849999999999999,6.7418999999999993E-2,null,null,2.4607934999999995E-3,6.7418999999999995E-3,2.4324775199999999E-2,0,0,6.7418999999999993,3.3709499999999997,5.1238439999999992,0.49890059999999992,{"$f":"R10/100*$F24*1000","v":0.72138330000000006},0.22248269999999998,{"$f":"T10*$F24","v":10.045430999999999},136.32121799999999,251.74254599999998,209.67308999999997,2.0899889999999997,406.94108399999993,0,0,9.3712409999999983E-4,null,null,0.6,0.59399999999999997]
[null,0,null,null,0,0,null,null,0,0,0,0,0,0,0,0,0,{"$f":"R11/100*$F25*1000","v":0},0,{"$f":"T11*$F25","v":0},0,0,0,0,0,0,0,0,null,null,0,0]
[null,0,null,null,0,0,null,null,0,0,0,0,0,0,0,0,0,{"$f":"R12/100*$F26*1000","v":0},0,{"$f":"T12*$F26","v":0},0,0,0,0,0,0,0,0,null,null,0,0]
[null,0,null,null,0,0,null,null,0,0,0,0,0,0,0,0,0,{"$f":"R13/100*$F27*1000","v":0},0,{"$f":"T13*$F27","v":0},0,0,0,0,0,0,0,0,null,null,0,0]
[null,0,null,null,0,0,null,null,0,0,0,0,0,0,0,0,0,{"$f":"R14/100*$F28*1000","v":0},0,{"$f":"T14*$F28","v":0},0,0,0,0,0,0,0,0,null,null,0,0]
[null,0,null,null,0,0,null,null,0,0,0,0,0,0,0,0,0,{"$f":"R15/100*$F29*1000","v":0},0,{"$f":"T15*$F29","v":0},0,0,0,0,0,0,0,0,null,null,0,0]
[null,0,null,null,0,0,null,null,0,0,0,0,0,0,0,0,0,{"$f":"R16/100*$F30*1000","v":0},0,{"$f":"T16*$F30","v":0},0,0,0,0,0,0,0,0,null,null,0,0]
[null,0,null,null,0,0,null,null,0,0,0,0,0,0,0,0,0,{"$f":"R17/100*$F31*1000","v":0},0,{"$f":"T17*$F31","v":0},0,0,0,0,0,0,0,0,null,null,0,0]
[null,"Total",null,null,{"$f":"SUM(E22:E31)","v":22.701999999999998},{"$f":"SUM(F22:F31)","v":10.306708},null,{"$f":"I32/0.454","v":1.84661275},{"$f":"SUM(I22:I31)","v":0.83836218849999999},{"$f":"SUM(J22:J31)","v":5.712366470000001},{"$f":"SUM(K22:K31)","v":20.652325733086602},11.886396323374758,6.1190326119993745,{"$f":"SUM(N22:N31)","v":67.093935999999999},30.245593500000005,18.148354900000001,99.79709960000001,18.775601300000002,20.082122500000004,11.399497349999999,190.48387199999999,{"$f":"SUM(V22:V30)","v":2959.8752460000005},{"$f":"SUM(W22:W31)","v":931.84181000000012},{"$f":"SUM(X22:X31)","v":3.0829709899999997},{"$f":"SUM(Y22:Y31)","v":569.42904599999997},{"$f":"SUM(Z22:Z31)","v":6.953443570000001},6.6988857700000004,0.18147930410000002,null,null,{"$f":"SUM(AE22:AE31)","v":100},{"$f":"SUM(AF22:AF31)","v":90.807999999999993}]
[null,"Requirement",null,"DM %",{"$f":"(E32/E18)","v":0.90807999999999989},null,null,{"$f":"IFERROR(VLOOKUP(Cattle!B7, 'Requirement Calculator'!A4:AQ73,28,FALSE),)","v":1.8452802222625628},{"$f":"H33*0.454","v":0.8377572209072035},null,{"$f":"IFERROR(VLOOKUP(Cattle!B7,'Requirement Calculator'!A4:AQ73,24,FALSE),)","v":20.352890678176077},{"$f":"IFERROR(VLOOKUP(Cattle!B7,'Requirement Calculator'!A4:AQ73,19,FALSE),)","v":11.785565245854171},null,{"$f":"IFERROR(VLOOKUP(Cattle!B7,'Requirement Calculator'!A4:AQ73,30,FALSE),)","v":27.149926400000002},{"$f":"IFERROR(VLOOKUP(Cattle!B7,'Requirement Calculator'!A4:AQ73,32,FALSE),)","v":12.876080941176472},{"$f":"IFERROR(VLOOKUP(Cattle!B7,'Requirement Calculator'!A4:AQ73,34,FALSE),) / 100 * $F$32*1000","v":7.2146956000000015},{"$f":"IFERROR(VLOOKUP(Cattle!B7,'Requirement Calculator'!A4:AQ73,35,FALSE),) / 100 * $F$32*1000","v":61.840248000000003},{"$f":"IFERROR(VLOOKUP(Cattle!$B7,'Requirement Calculator'!$A$4:$AQ$73,36,FALSE),) / 100 * $F$32*1000","v":12.368049600000001},{"$f":"IFERROR(VLOOKUP(Cattle!$B7,'Requirement Calculator'!$A$4:$AQ$73,37,FALSE),) / 100 * $F$32*1000","v":15.460062000000001},{"$f":"IFERROR(VLOOKUP(Cattle!$B7,'Requirement Calculator'!$A$4:$AQ$73,38,FALSE),) / 100 * $F$32*100","v":1.5460062000000001},{"$f":"IFERROR(VLOOKUP(Cattle!$B7,'Requirement Calculator'!$A$4:$AQ$73,39,FALSE),) / 100 * $F$32*100","v":103.06708},{"$f":"IFERROR(VLOOKUP(Cattle!$B7,'Requirement Calculator'!$A$4:$AQ$73,40,FALSE),) / 100 * $F$32*100","v":515.33540000000005},{"$f":"IFERROR(VLOOKUP(Cattle!$B7,'Requirement Calculator'!$A$4:$AQ$73,41,FALSE),) / 100 * $F$32*100","v":412.26832000000002},{"$f":"IFERROR(VLOOKUP(Cattle!$B7,'Requirement Calculator'!$A$4:$AQ$73,42,FALSE),) / 100 * $F$32*100","v":1.0306708000000002},{"$f":"IFERROR(VLOOKUP(Cattle!$B7,'Requirement Calculator'!$A$4:$AQ$73,43,FALSE),) / 100 * $F$32*100","v":309.20124000000004}]
[null,"Decision for DMI to calculate \"requirements\"","Predicted DMI, lb",{"$f":"Balancer!F23","v":22.509421268852456},null,null,null,"DM Supplied, Mcal/kg, % or mg/day",{"$f":"I32/F32","v":8.1341412650867764E-2},{"$f":"J32/F32","v":0.55423773235838258},{"$f":"K32/F32","v":2.0037751853537134},{"$f":"L32/F32","v":1.1532679807533848},{"$f":"M32/F32","v":0.59369418557306308},{"$f":"N32/($F32*1000)","v":6.5097348251255396E-3},{"$f":"O32/($F32*1000)","v":2.934554224297419E-3},1.760829442339882E-3,9.6827327988723462E-3,1.8216875165183684E-3,1.9484516782662324E-3,{"$f":"T32/$F32","v":1.106027002026253},{"$f":"U32/$F32","v":18.481543476345696},287.17949960355918,90.411197251343509,0.29912276451413966,55.248392212139898,0.67465223328341117,0.64995396881332046,{"$f":"AB32/$F32","v":1.7607882565412739E-2}]
[null,null,null,null,null,null,null,"Mcal/lb",{"$f":"I33/F32","v":8.1282716159922594E-2},null,{"$f":"K32/E32","v":0.90971393415058599},{"$f":"L32/E32","v":0.52358366326203676},{"$f":"M32/E32","v":0.26953716025017072},{"$f":"N33/1000/$F32","v":2.6341996299885473E-3},{"$f":"O33/1000/$F32","v":1.2492913296055803E-3},7.000000000000001E-4,6.0000000000000001E-3,1.1999999999999999E-3,1.5E-3]
[null,null,null,null,null,null,null,"As Fed Basis",{"$f":"I34*$E$33","v":7.3864509999999994E-2},{"$f":"J34*$E$33","v":0.50329219999999997},{"$f":"K34*$E$33*0.454","v":0.82609302932346396},{"$f":"L34*$E$33*0.454","v":0.47545585293499021},{"$f":"M34*$E$33*0.454","v":0.24476130447997493},{"$f":"N34*$E$33","v":5.9113599999999992E-3},2.6648100000000001E-3,1.5989739999999998E-3,8.7926959999999992E-3,1.6542379999999997E-3,1.76935E-3,1.0043609999999998,16.782719999999998,260.78195999999997,82.1006,0.27162739999999991,50.169959999999989,0.61263819999999991,0.59021020000000002,{"$f":"AB34*$E$33","v":1.5989365999999998E-2}]
[]
[null,null,null,null,null,null,null,null,null,"Partial efficiency coefficient, ME to Nem =",null,{"$f":"L32/K32","v":0.57554759095881602}]
[null,null,null,null,null,null,null,null,null,null,null,"Adjustment for Growing Cattle"]
[null,null,null,null,null,null,null,null,null,"Ionophore adjustment",{"$f":"Cattle!G15","v":"Rumensin"},{"$f":"VLOOKUP(K40,J41:K44,2,FALSE)","v":1}]
[null,null,null,null,null,null,null,null,null,"None",0.97699999999999998]
[null,null,null,null,null,null,null,null,null,"Rumensin",1]
[null,null,null,null,null,null,null,null,null,"Bovatec",0.98499999999999999]
[null,null,null,null,null,null,null,null,null,"Laidlomycin",0.98499999999999999]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Energy Balance Model"]
[null,null,null,null,null,null,null,null,null,null,null,"Cond. Score ",null,null,"Current Energy",null,null,null,"Desired Energy"]
[null,null,null,null,null,null,null,"Weight change per        condition score",null,7.1050000000000002E-2,null,"EBW5",{"$f":"Q65/M66","v":445.07980800000001},null,"EBW",null,{"$f":"0.851*J70","v":445.07980800000001},"kg","EBW",{"$f":" 0.851*J71","v":445.07980800000001},"kg"]
[null,null,null,null,null,null,null,"Current CS =",null,{"$f":"Cattle!H11","v":5},null,"WAFbcs (weight adjustment factor) Eq. 13-5",{"$f":"1-0.07105 *(5-J66)","v":1}]
[null,null,null,null,null,null,null,"Desired CS =",null,{"$f":"Cattle!I11","v":5},null,"EBWbcs",{"$f":"M65*M66","v":445.07980800000001},null,"AF",null,{"$f":"(0.037683*J66)*100","v":18.8415},"%","AF",{"$f":"(0.037683*J67)*100","v":18.8415},"%"]
[null,null,null,null,null,null,null,"Average CS =",null,{"$f":"(J67+J66)/2","v":5},null,"SBW",{"$f":"(Cattle!D11*0.454)*0.96","v":523.00800000000004},null,"AP",null,{"$f":"(0.200886-(0.0066762*J66))*100","v":16.750500000000002},"%","AP",{"$f":"(0.200886-(0.0066762*J67))*100","v":16.750500000000002},"%"]
[null,null,null,null,null,null,null,"Current SBW =",null,{"$f":"M68","v":523.00800000000004},"kg",null,null,null,"AW",null,{"$f":"(0.766637 - (0.034506 *J66))*100","v":59.410699999999991},"%","AW",{"$f":"(0.766637 - (0.034506 *J67))*100","v":59.410699999999991},"%"]
[null,null,null,null,null,null,null,"Current Adj Weight =",null,{"$f":"J69+J84","v":523.00800000000004},"kg","TF1",{"$f":"M65*0.037683","v":16.771942404863999},"kg","TF",null,{"$f":"(Q67/100)*Q65","v":83.859712024320004},"kg","TF",{"$f":"(T67/100)*T65","v":83.859712024320004},"kg"]
[null,null,null,null,null,null,null,"Desired Adj Weight =",null,{"$f":"J69+J85","v":523.00800000000004},"kg","TP1",{"$f":"M65*0.194208","v":86.438059352064002},"kg","TP",null,{"$f":"(Q68/100)*Q65","v":74.55309323904001},"kg","TP",{"$f":"(T68/100)*T65","v":74.55309323904001},"kg"]
[null,null,null,null,null,null,null,"CS 5 WT=",null,null,"kg",null,null,"Mcal","TE (total energy of reserves)",null,{"$f":"(9.4*Q70)+(5.7*Q71)","v":1213.2339244911361},"Mcal","TE",{"$f":"(9.4*T70)+(5.7*T71)","v":1213.2339244911361},"Mcal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gain or Lose"]
[null,null,null,null,null,null,null,"Wt change for each 1 unit BCS change",null,{"$f":"J69*J65","v":37.159718400000003},"kg",null,null,null,"Pos energy change =",null,null,{"$f":"T72-Q72","v":0},"Mcal",null,null,{"$f":"T72-Q72","v":0}]
[null,null,null,null,null,null,null,"Current Adj Weight =",null,{"$f":"J70/0.454","v":1152},"lb",null,null,null,"Neg energy change =",null,null,{"$f":"(T72-Q72)*0.8","v":0},"Mcal",null,"Days to Gain"]
[null,null,null,null,null,null,null,"Desired Adj Weight =",null,{"$f":"J71/0.454","v":1152},"lb",null,null,null,"Desired WT Change=",null,null,{"$f":"(J71-J70)","v":0},"kg",null,"Days to Lose"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mcal / kg gain =",null,{"$f":"VLOOKUP(Q79,V84:X94,2,)","v":6.38},{"$f":"IF(R74=0,Q77,R74/R76)","v":6.38},"Mcal/kg",null,"Decision",{"$f":"J74/R86","v":324.24022084842386}]
[null,null,null,null,null,null,null,null,null,null,null,"Average",null,null,"Mcal / kg loss =",null,{"$f":"VLOOKUP(Q79,V84:X94,3,)","v":5.84},{"$f":"IF(R75=0,Q78,R75/R76)","v":5.84},"Mcal/kg",null,null,{"$f":"(-1*J74)/R86","v":-324.24022084842386}]
[null,null,null,null,null,null,null,"Estimated weights",null,1147.8715520309604,"lb",{"$f":"(J79+J75)/2","v":1149.9357760154803},"lb",null,"Decision",null,{"$f":"J68","v":5},{"$f":"IF(R85<0,R78,R77)","v":6.38},"Mcal/kg",null,null,{"$f":"V77","v":324.24022084842386}]
[null,null,null,null,null,null,null,"(based on estimated weight change rather than \"desired\")",null,null,null,null,null,null,"Desired ADG = ",null,null,{"$f":"(J71-J70)/Cattle!E7","v":0},"kg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Desired ADG = ",null,null,{"$f":"R80/0.454","v":0},"lb."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maint Req =",null,null,{"$f":"VLOOKUP(Cattle!B7,'Requirement Calculator'!A8:BO73,50, FALSE)","v":8.4211610705124649},"Mcal Nem/day",null,null,"The Mcal required to gain 1 kg of EBW is different for each BCS."]
[null,null,null,null,null,null,null,null,"Adj factor","Adjustment","Adjusted weight",null,null,null,"Milk or pregnancy energy = ",null,null,{"$f":"VLOOKUP(Cattle!B7,'Requirement Calculator'!A8:BO73,53, FALSE)","v":3.292896128359919},"Mcal NEM/day",null,null,"BCS","Mcal/kg EBW gain","Mcal/kg EBW loss"]
[null,null,null,null,null,null,null,"Initial",{"$f":"J66-5","v":0},{"$f":"I84*J65*J69","v":0},{"$f":"J69+J84","v":523.00800000000004},null,null,null,"Nem Supplied =",null,null,{"$f":"L32","v":11.886396323374758},"Mcal Nem/day",null,null,3,5.3,4.76]
[null,null,null,null,null,null,null,"Desired",{"$f":"J67-5","v":0},{"$f":"I85*J65*J69","v":0},{"$f":"J69+J85","v":523.00800000000004},null,null,null,"Difference =",null,null,{"$f":"R84-R82-R83","v":0.17233912450237376},"Mcal Nem/day",null,null,3.5,{"$f":"AVERAGE(W84, W86)","v":5.57},{"$f":"AVERAGE(X84, X86)","v":5.0299999999999994}]
[null,null,null,null,null,null,null,"CS 5 WT",{"$f":"5-J66","v":0},{"$f":"J70*J65*I86","v":0},{"$f":"J86+J69","v":523.00800000000004},null,null,null,"Nem available for gain",null,null,{"$f":"R85*0.665","v":0.11460551779407856},null,null,null,4,5.84,5.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nem available for loss",null,null,{"$f":"R85*0.8","v":0.13787129960189901},null,null,null,4.5,{"$f":"AVERAGE(W86, W88)","v":6.1099999999999994},{"$f":"AVERAGE(X86, X88)","v":5.57}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kg/day gain",null,null,{"$f":"R86/R79","v":1.796324730314711E-2},null,null,null,5,6.38,5.84]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kg/day loss",null,null,{"$f":"R87/R79","v":2.160992156769577E-2},null,null,null,5.5,{"$f":"AVERAGE(W88, W90)","v":6.6449999999999996},{"$f":"AVERAGE(X88, X90)","v":6.1099999999999994}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Decision","ADG =",null,null,{"$f":"IF(R85<0,R89,R88)","v":1.796324730314711E-2},"kg",null,null,6,6.91,6.38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Conversion","ADG =",null,null,{"$f":"R90/0.454","v":3.9566624015742534E-2},"lb",null,null,6.5,{"$f":"AVERAGE(W90, W92)","v":7.18},{"$f":"AVERAGE(X90, X92)","v":6.6449999999999996}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Days to 1 CS change =",null,null,{"$f":"J74/R90","v":2068.6526090129441},"days",null,null,7,7.45,6.91]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CS change during feeding period =",null,null,{"$f":"Cattle!E7/'Nutrient and Energy Balance'!R92","v":4.3506579890638782E-2},"Units",{"$f":"IF(R93<0,\"Loss\",\"Gain\")","v":"Gain"},null,7.5,{"$f":"AVERAGE(W92, W94)","v":7.7200000000000006},{"$f":"AVERAGE(X92, X94)","v":7.18}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average period BCS (for adjusting maintenance)",null,null,{"$f":"(J66+(J66+R93))/2","v":5.0217532899453197},null,null,null,8,7.99,7.45]

{"sheet":"Requirement Calculator","index":8,"n_rows":86,"n_cols":72,"rows_kept":86,"cut":false,"hidden":true,"merged":[[3,43,3,53],[62,21,62,22],[4,21,4,22],[12,21,12,22],[20,21,20,22],[28,21,28,22],[36,21,36,22],[46,21,46,22],[54,21,54,22]]}
[null,"Requirement Calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nutrient Requirement Generator for Beef Cows",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,"Minimum"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oklahoma State University",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,"CP, lb/day"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72]
[null,"Gestating cow, middle 1/3 of pregnancy",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,"Calculations"]
[null,"Current",null,null,null,null,"Expected",null,"Current",null,null,null,null,"NEm","Gravid",null,"Predicted","Predicted",null,"NEm","NEm","Weight",null,"ME","ME","Neg","Actual","       Crude Protein",null,"Ca","Ca","Phos","Phos","Na","K","MG","S","CO","CU","FE","MN","SE","ZN",null,null,null,null,null,null,null,null,null,null,"Mid Gestation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Days to"]
[null,"Weight",null,null,"BW.75",null,"Calf",null,"BCS","NEm",null,"NEm","NEm2","sup/req","Uterus",null,"DM Intake","DM Intake","Nem Sup","Req","Req","Initial","Final","Req","Req","Req","DM Intake","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Maint MP",null,"Gest MP","Total MP","MP",null,"Nem maint",null,null,"Nem Gest","Energy",null,null,null,null,null,null,null,null,null,"Maternal","SWG","Fetal","Fetal","Total","Desired","gain or lose",null,"Number of"]
[null,"lb","Weight (kg)","SBW","MBW",null,"Birthweight",null,"(1-9)","Mcal/kg",null,"Mcal/lb","Mcal/kg","Ratio","ADG, lb",null,"lb/day","kg/day","Mcal/day","Mcal/day","Mcal/lb","lb","lb","Mcal/day","Mcal/kg","Mcal/kg","lb/day","lb/day","% of DM","g/day","% of DM","g/day","% of DM","% of DM","% of DM","% of DM","% of DM","ppm","ppm","ppm","ppm","ppm","ppm","g/day",null,"g/day","g/day","exponent",{"$f":"(AU8/0.67)/454","v":1.4233843827734036},"Mcal/day",null,null,"Mcal/day","exponent",null,null,null,null,null,null,null,null,null,"ADG, kg","lb","ADG, kg","ADG, lb","ADG,lb","ADG","one score",null,"Head"]
["Mid Gestation, Dry Cow",{"$f":"Cattle!C11","v":1200},{"$f":"B8*0.454","v":544.80000000000007},{"$f":"C8*0.96","v":523.00800000000004},{"$f":"D8^0.75","v":109.36572818847357},null,{"$f":"Cattle!E11","v":80},0,{"$f":"Cattle!H11","v":5},{"$f":"'Nutrient and Energy Balance'!L34","v":1.1532679807533848},null,{"$f":"J8*0.454","v":0.52358366326203665},{"$f":"J8^2","v":1.3300270354309895},{"$f":"S8/T8","v":1.3353578065869833},{"$f":"BQ8/0.454","v":0.65862095760178085},null,{"$f":"R8/0.454","v":22.509421268852456},{"$f":"(E8*(0.002263+(0.134788*J8)-(0.063407*J8^2)+(0.013081*J8^3)))","v":10.219277256059016},{"$f":"R8*J8","v":11.785565245854171},{"$f":"AX8+BA8","v":8.8257732779326634},{"$f":"T8/Q8","v":0.39209241199574413},{"$f":"Cattle!C$11","v":1200},{"$f":"V8+((BL8+BO8)*Cattle!E$7)","v":1228.5279445848921},{"$f":"T8/'Nutrient and Energy Balance'!L38","v":15.334567317412683},{"$f":"X8/R8","v":1.5005530169289427},null,{"$f":"Balancer!F22","v":22.701999999999998},{"$f":"IF(AW7 < AW8,AW8,AW7)","v":1.8007537015081965},{"$f":"(AB8/Q8)*100","v":8},{"$f":"((0.0154*D8)+(0.152*(G8*0.454)))/0.5","v":27.149926400000002},{"$f":"((AD8/454)/Q8)*100","v":0.2656736452071774},{"$f":"(0.016*D8)+(0.0844*((G8*0.454)))/0.68","v":12.876080941176472},{"$f":"((AF8/454)/Q8)*100","v":0.12599796070257549},7.0000000000000007E-2,0.6,0.12,0.15,0.15,10,50,40,0.1,30,{"$f":"3.8*E8","v":415.58976711619954},null,{"$f":"((G8*0.454)*(0.001669-(0.00000211*142))*EXP(AV8)*6.25)/0.65","v":17.375294435814329},{"$f":"AR8+AT8","v":432.96506155201388},{"$f":"(0.0278-(0.0000176*142))*142","v":3.5927135999999997},{"$f":"Q8*0.08","v":1.8007537015081965},{"$f":"E8*(Cattle!O19)*1*(0.8+(I16-1)*0.05)","v":8.4211610705124649},null,null,{"$f":"(($G8*0.454)*(0.576/0.13)*(0.05855-(0.0000996*142))*EXP(BB8))/1000","v":0.4046122074201986},{"$f":"(0.03233-(0.0000275*142))*(142)","v":4.0363499999999997},null,null,null,null,null,null,null,null,null,{"$f":"'Nutrient and Energy Balance'!R90","v":1.796324730314711E-2},{"$f":"BL8/0.454","v":3.9566624015742534E-2},{"$f":"(G8*0.454)*0.01828*(0.02-0.0000286*142)*EXP(0.02*142-0.0000143*142^2)","v":0.13575231729704867},{"$f":"BN8/0.454","v":0.29901391475120853},{"$f":"BM8+BO8","v":0.33858053876695104},{"$f":"'Nutrient and Energy Balance'!R81+BO8","v":0.29901391475120853},{"$f":"'Nutrient and Energy Balance'!$R$92","v":2068.6526090129441},null,{"$f":"Cattle!$B$11","v":10}]
[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,{"$f":"'Nutrient and Energy Balance'!K86^0.75*(Cattle!O19)*1*(0.8+(I16-1)*0.05)","v":8.4211610705124649}]
[]
[]
[null,"Gestating cow, last 1/3 of pregnancy"]
[null,"Current",null,null,null,null,"Expected",null,"Current",null,null,null,null,"NEm","Gravid",null,"Predicted","Predicted",null,"NEm","NEm","Weight",null,"ME","ME","Neg","Intake ","       Crude Protein",null,"Ca","Ca","Phos","Phos","Na","K","MG","S","CO","CU","FE","MN","SE","ZN",null,null,null,null,null,null,null,null,null,null,"Late Gestation"]
[null,"Weight","Average",null,"BW.75",null,"Calf",null,"BCS","NEm",null,"NEm","NEm2","sup/req","Uterus",null,"DM Intake","DM Intake","Nem Sup","Req","Req","Initial","Final","Req","Req","Req","Adjustment","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Maint MP",null,"Gest MP","Total MP","MP",null,"Nem maint",null,null,"Nem Gest","Energy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of"]
[null,"lb","Weight (kg)","SBW","MBW",null,"Birthweight",null,"(1-9)","Mcal/kg",null,"Mcal/lb","Mcal/kg","Ratio","ADG, lb",null,"lb/day","kg/day","Mcal/day","Mcal/day","Mcal/lb","lb","lb","Mcal/day","Mcal/kg","Mcal/kg","%","lb/day","% of DM","g/day","% of DM","g/day","% of DM","% of DM","% of DM","% of DM","% of DM","ppm","ppm","ppm","ppm","ppm","ppm","g/day",null,"g/day","g/day","exponent",{"$f":"(AU16/0.67)/454","v":1.8452802222625628},"Mcal/day",null,null,"Mcal/day","exponent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Head"]
["Late Gestation, Dry Cow",{"$f":"Cattle!C11","v":1200},{"$f":"B16*0.454","v":544.80000000000007},{"$f":"C16*0.96","v":523.00800000000004},{"$f":"D16^0.75","v":109.36572818847357},null,{"$f":"Cattle!E11","v":80},0,{"$f":"Cattle!H11","v":5},{"$f":"'Nutrient and Energy Balance'!L$34","v":1.1532679807533848},null,{"$f":"J16*0.454","v":0.52358366326203665},{"$f":"J16^2","v":1.3300270354309895},{"$f":"S16/T16","v":1.0061044645563684},{"$f":"BQ16/0.454","v":2.5942498535173537},null,{"$f":"R16/0.454","v":22.509421268852456},{"$f":"(E16*(0.002263+(0.134788*J16)-(0.063407*J16^2)+(0.013081*J16^3)))","v":10.219277256059016},{"$f":"R16*J16","v":11.785565245854171},{"$f":"AX16+BA16","v":11.714057198872384},{"$f":"T16/Q16","v":0.52040685804222697},{"$f":"Cattle!C$11","v":1200},{"$f":"V16+((BL16+BO16)*Cattle!E$7)","v":1307.6177412720024},{"$f":"T16/'Nutrient and Energy Balance'!L38","v":20.352890678176077},{"$f":"X16/R16","v":1.9916174273585576},null,null,{"$f":"IF(AW15 < AW16,AW16,AW15)","v":1.8452802222625628},{"$f":"(AB16/Q16)*100","v":8.1978128190082789},{"$f":"((0.0154*D16)+(0.152*(G16*0.454)))/0.5","v":27.149926400000002},{"$f":"((AD16/454)/Q16)*100","v":0.2656736452071774},{"$f":"(0.016*D16)+(0.0844*((G16*0.454)))/0.68","v":12.876080941176472},{"$f":"((AF16/454)/Q16)*100","v":0.12599796070257549},7.0000000000000007E-2,0.6,0.12,0.15,0.15,10,50,40,0.1,30,{"$f":"3.8*E16","v":415.58976711619954},null,{"$f":"(($G16*0.454)*(0.001669-(0.00000211*253))*EXP(AV16)*6.25)/0.65","v":145.70757089162686},{"$f":"AR16+AT16","v":561.2973380078264},{"$f":"(0.0278-(0.0000176*253))*253","v":5.9068415999999999},{"$f":"Q16*0.08","v":1.8007537015081965},{"$f":"E16*(Cattle!O19)*1*(0.8+(I16-1)*0.05)","v":8.4211610705124649},null,null,{"$f":"((G16*0.454)*(0.576/0.13)*(0.05855-(0.0000996*253))*EXP(BB16))/1000","v":3.292896128359919},{"$f":"(0.03233-(0.0000275*253))*(253)","v":6.4192425000000002},null,null,null,null,null,null,null,null,null,{"$f":"'Nutrient and Energy Balance'!R90","v":1.796324730314711E-2},{"$f":"BL16/0.454","v":3.9566624015742534E-2},{"$f":"(G16*0.454)*0.01828*(0.02-0.0000286*253)*EXP(0.02*253-0.0000143*253^2)","v":0.53471640280758292},{"$f":"BN16/0.454","v":1.1777894334968786},{"$f":"BM16+BO16","v":1.2173560575126212},{"$f":"'Nutrient and Energy Balance'!$R$81+BO16","v":1.1777894334968786},{"$f":"'Nutrient and Energy Balance'!$R$92","v":2068.6526090129441},null,{"$f":"Cattle!$B$11","v":10}]
[]
[]
[]
[null,"Lactating cow, first 90 days after calving"]
[null,"Current",null,null,null,null,"Expected",null,"Current",null,null,null,null,"NEm","Gravid",null,"Predicted","Predicted",null,"NEm","NEm","Weight",null,"ME","ME","Neg","Intake ","                Crude Protein",null,"Ca","Ca","Phos","Phos","Na","K","MG","S","CO","CU","FE","MN","SE","ZN"]
[null,"Weight",null,null,"BW.75",null,"Calf","Milk","BCS","NEm",null,"NEm","NEm2","sup/req","Uterus",null,"DM Intake","DM Intake","Supplied","Req","Req","Initial","Final","Req","Req","Req","Adjustment","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Maint MP",null,"Lact MP","Total MP",null,null,"Nem maint",null,null,"Nem lact",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of"]
[null,"lb","Weight (kg)","SBW","MBW",null,"Birthweight","kg/day","(1-9)","Mcal/kg",null,"Mcal/lb","Mcal/kg","Ratio","ADG, lb",null,"lb/day","kg/day","Mcal/day","Mcal/day","Mcal/lb","lb","lb","Mcal/day","Mcal/kg","Mcal/kg","%","lb/day","% of DM","g/day","% of DM","g/day","% of DM","% of DM","% of DM","% of DM","% of DM","ppm","ppm","ppm","ppm","ppm","ppm","g/day",null,"g/day","g/day",null,{"$f":"(AU24/0.67)/454","v":3.2578551597764971},"Mcal/day",null,null,"Mcal/day",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Head"]
["Early Lactation, Mature Cow",{"$f":"Cattle!C11","v":1200},{"$f":"B24*0.454","v":544.80000000000007},{"$f":"C24*0.96","v":523.00800000000004},{"$f":"D24^0.75","v":109.36572818847357},null,{"$f":"Cattle!E11","v":80},{"$f":"Cattle!G11*0.454","v":11},{"$f":"Cattle!H11","v":5},{"$f":"'Nutrient and Energy Balance'!L$34","v":1.1532679807533848},null,{"$f":"J24*0.454","v":0.52358366326203665},{"$f":"J24^2","v":1.3300270354309895},{"$f":"S24/T24","v":0.77870032071608863},{"$f":"BQ24/0.454","v":0},{"$f":"Q24/B24","v":2.4815119779844009E-2},{"$f":"R24/0.454","v":29.778143735812812},{"$f":"(E24*(0.002263+(0.134788*J24)-(0.063407*J24^2)+(0.013081*J24^3)))+H24*0.3","v":13.519277256059016},{"$f":"R24*J24","v":15.591349582340342},{"$f":"AX24+BA24","v":20.022271941537948},{"$f":"T24/Q24","v":0.67238146605686766},{"$f":"Cattle!C$11","v":1200},{"$f":"V24+((BL24)*Cattle!E$7)","v":1201.6166922572831},{"$f":"T24/'Nutrient and Energy Balance'!L38","v":34.788212575405716},{"$f":"X24/R24","v":2.5732302042858448},null,null,{"$f":"IF(AW23 < AW24,AW24,AW23)","v":3.2578551597764971},{"$f":"(AB24/'Nutrient and Energy Balance'!E32)*100","v":14.350520481792342},{"$f":"((0.0154*D24)+(1.23*H24))/0.5","v":43.1686464},{"$f":"((AD24/454)/Q24)*100","v":0.31931179146912492},{"$f":"((0.016*D24)+(H24*0.95)/0.68)","v":23.735775058823528},{"$f":"((AF24/454)/Q24)*100","v":0.17556985191782881},0.1,0.7,0.2,0.15,0.15,10,50,40,0.1,30,{"$f":"3.8*E24","v":415.58976711619954},null,{"$f":"((H24*0.034)/0.65)*1000","v":575.38461538461536},{"$f":"AR24+AT24","v":990.97438250081495},null,{"$f":"Q24*0.08","v":2.382251498865025},{"$f":"E24*(Cattle!P19)*1.2*(0.8+(I24-1)*0.05)","v":12.126471941537948},null,null,{"$f":"H24*0.7178","v":7.8957999999999995},null,null,null,null,null,null,null,null,null,null,{"$f":"'Nutrient and Energy Balance'!R90","v":1.796324730314711E-2},{"$f":"BL24/0.454","v":3.9566624015742534E-2},null,"N/A",{"$f":"BM24","v":3.9566624015742534E-2},{"$f":"'Nutrient and Energy Balance'!$R$81","v":0},{"$f":"'Nutrient and Energy Balance'!$R$92","v":2068.6526090129441},null,{"$f":"Cattle!$B$11","v":10}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M. Gross equation for lactating cows, October 2019: DMI= -4.336 + (0.086427 (BW^.75) + 0.30 (Milk yield) + 6.005785 (NEm, Mcal/kg)"]
[]
[null,"Lactating cow, last 120 days of lactation (day 91 to day 210 after calving)"]
[null,"Current",null,null,null,null,"Expected",null,"Current",null,null,null,null,"NEm","Gravid",null,"Predicted","Predicted ",null,"NEm","NEm","Weight",null,"ME","ME","Neg","Intake ","                Crude Protein",null,"Ca","Ca","Phos","Phos","Na","K","MG","S","CO","CU","FE","MN","SE","ZN",null,null,null,null,null,null,null,null,null,null,null,"Late Lactation (early gestation)"]
[null,"Weight",null,null,"BW.75",null,"Calf","Milk","BCS","NEm",null,"NEm","NEm2","sup/req","Uterus",null,"DM Intake","DM Intake","Supplied","Req","Req","Initial","Final","Req","Req","Req","Adjustment","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Maint MP","Gest MP","Lact MP","Total MP","MP",null,"Nem maint",null,null,"Nem lact","Nem Gest","Energy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of"]
[null,"lb","Weight (kg)","SBW","MBW",null,"Birthweight","kg/day","(1-9)","Mcal/kg",null,"Mcal/lb","Mcal/kg","Ratio","ADG, lb",null,"lb/day","kg/day","Mcal/day","Mcal/day","Mcal/lb","lb","lb","Mcal/day","Mcal/kg","Mcal/kg","%","lb/day","% of DM","g/day","% of DM","g/day","% of DM","% of DM","% of DM","% of DM","% of DM","ppm","ppm","ppm","ppm","ppm","ppm","g/day","g/day","g/day","g/day","exponent",{"$f":"(AU32/0.67)/454","v":2.5100299589935937},"Mcal/day",null,null,"Mcal/day","Mcal/day","exponent",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Head"]
["Late Lactation, Mature Cow",{"$f":"Cattle!C11","v":1200},{"$f":"B32*0.454","v":544.80000000000007},{"$f":"C32*0.96","v":523.00800000000004},{"$f":"D32^0.75","v":109.36572818847357},null,{"$f":"Cattle!E11","v":80},{"$f":"(Cattle!G11*0.6*0.454)","v":6.6000000000000005},{"$f":"Cattle!H11","v":5},{"$f":"'Nutrient and Energy Balance'!L$34","v":1.1532679807533848},null,{"$f":"J32*0.454","v":0.52358366326203665},{"$f":"J32^2","v":1.3300270354309895},{"$f":"S32/T32","v":0.82950039249426977},{"$f":"BQ32/0.454","v":0.18572802327290247},null,{"$f":"R32/0.454","v":26.87065474902867},{"$f":"(E32*(0.002263+(0.134788*J32)-(0.063407*J32^2)+(0.013081*J32^3)))+H32*0.3","v":12.199277256059016},{"$f":"R32*J32","v":14.069035847745875},{"$f":"AX32+BA32+BB32","v":16.960854961672684},{"$f":"T32/Q32","v":0.63120363534445656},{"$f":"Cattle!C$11","v":1200},{"$f":"V32+((BL32+BO32)*Cattle!E$7)","v":1209.2055392882141},{"$f":"T32/'Nutrient and Energy Balance'!L38","v":29.469074717899979},{"$f":"X32/R32","v":2.4156410334279084},null,null,{"$f":"IF(AW31 < AW32,AW32,AW31)","v":2.5100299589935937},{"$f":"(AB32/Q32)*100","v":9.3411566723521222},{"$f":"((0.0154*D32)+(1.23*H32))/0.5","v":32.344646400000002},{"$f":"((AD32/454)/Q32)*100","v":0.26513575944784257},{"$f":"((0.016*D32)+(0.0844*(G32*0.454))+(H32*0.95))/0.68","v":26.034611764705879},{"$f":"((AF32/454)/Q32)*100","v":0.21341109984015869},0.1,0.7,0.2,0.15,0.15,10,50,40,0.1,30,{"$f":"3.8*E32","v":415.58976711619954},{"$f":"(($G32*0.454)*(0.001669-(0.00000211*60))*EXP(AV32)*6.25)/0.65","v":2.6803765797025387},{"$f":"((H32*0.034)/0.65)*1000","v":345.23076923076928},{"$f":"AR32+AS32+AT32","v":763.50091292667139},{"$f":"(0.0278-(0.0000176*60))*60","v":1.6046399999999998},{"$f":"Q32*0.08","v":2.1496523799222937},{"$f":"E32*(Cattle!P19)*1.2*(0.8+(I24-1)*0.05)","v":12.126471941537948},null,null,{"$f":"H32*0.7178","v":4.7374800000000006},{"$f":"(($G32*0.454)*(0.576/0.13)*(0.05855-(0.0000996*60))*EXP(BC32))/1000","v":9.6903020134735812E-2},{"$f":"(0.03233-(0.0000275*81))*(81)","v":2.4383024999999998},null,null,null,null,null,null,null,null,{"$f":"'Nutrient and Energy Balance'!R90","v":1.796324730314711E-2},{"$f":"BL32/0.454","v":3.9566624015742534E-2},{"$f":"(G32*0.454)*0.01828*(0.02-0.0000286*60)*EXP(0.02*60-0.0000143*60^2)","v":3.8281517244917566E-2},{"$f":"BN32/0.454","v":8.4320522565897726E-2},{"$f":"BM32+BO32","v":0.12388714658164027},{"$f":"'Nutrient and Energy Balance'!$R$81+BO32","v":8.4320522565897726E-2},{"$f":"'Nutrient and Energy Balance'!$R$92","v":2068.6526090129441},null,{"$f":"Cattle!$B$11","v":10}]
[]
[]
[]
[null,"Gestating Bred Heifer, middle 1/3 of pregnancy"]
[null,"Current",null,null,null,"Mature","Expected",null,"Current",null,null,null,null,"NEm","Gravid","Maternal","Predicted","Predicted",null,"NEm","NEm","Weight",null,"ME","ME","Neg","Intake ","       Crude Protein",null,"Ca","Ca","Phos","Phos","Na","K","MG","S","CO","CU","FE","MN","SE","ZN","MP for","MP for","MP for",null,null,"NP req for",null,null,null,null,null,"Maintenance","Intake for","Diet RE",null,null,null,"Equiv Empty",null,"Empty body","Shrunk",null,null,null,null,null,null,"Gravid Uterus"]
[null,"Weight",null,null,"BW.75","Wt @","Calf","Milk","BCS","NEm","Neg","NEm","NEm2","sup/req","Uterus","Tissue","DM Intake","DM Intake","Nem Sup","Req","Req","Initial","Final","Req","Req","Req","Adjustment","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Maint.","Growth","Gest.","Total MP","MP","gain","NEm maint","NEm Growth","Ney","Nemgest","Energy","& Pregnancy","Growth","Available","Empty BW","Final SBW",null,"BW",null,"gain","Wt Gain",null,"ADGpreg","ADGpreg","Total","Desired ","Days to","Wt, kg","Number of"]
[null,"lb","Weight (kg)","SBW","MBW","BCS=5","Birthweight","kg/day","(1-9)","Mcal/kg","Mcal/kg","Mcal/lb","Mcal/kg","Ratio","ADG, lb","ADG, lb","lb/day","kg/day","Mcal/day","Mcal/day","Mcal/lb","lb","lb","Mcal/day","Mcal/kg","Mcal/kg","%","lb/day","% of DM","g/day","% of DM","g/day","% of DM","% of DM","% of DM","% of DM","% of DM","ppm","ppm","ppm","ppm","ppm","ppm","g/day","g/day","g/day","g/day","exponent","g/day","Mcal/day","Mcal/day","Mcal/day","Mcal/day","exponent","kg","kg","Mcal/d","EBW","FSBW","EQSBW","EQEBW","RE","EBG","SWG, kg","SWG, lb","kg/d","lb/day","Gain, lb","Gain, lb","1 CS Chng","CW","Head"]
["Mid Gestation, Bred Heifer",{"$f":"(V40+(V40+(1*Cattle!E7)))/2","v":1245},{"$f":"B40*0.454","v":565.23},{"$f":"C40*0.96","v":542.62080000000003},{"$f":"D40^0.75","v":112.42744160763056},{"$f":"Cattle!D11","v":1200},{"$f":"Cattle!E11","v":80},0,{"$f":"Cattle!H11","v":5},{"$f":"'Nutrient and Energy Balance'!L$34","v":1.1532679807533848},{"$f":"'Nutrient and Energy Balance'!M34","v":0.59369418557306308},{"$f":"J40*0.454","v":0.52358366326203665},{"$f":"J40^2","v":1.3300270354309895},{"$f":"S40/T40","v":1.247968193916996},{"$f":"BN40/0.454","v":0.29901391475120853},{"$f":"BL40/0.454","v":0.59592740911692466},{"$f":"R40/0.454","v":28.331373938303646},{"$f":"(E40)*((0.2435*J40)-(0.0466*J40^2)-0.0869)/J40","v":12.862443767989856},{"$f":"R40*J40","v":14.833844551863619},{"$f":"AX40+AY40+BA40","v":11.886396323374758},{"$f":"T40/Q40","v":0.41954888418964059},{"$f":"Cattle!C$11","v":1200},{"$f":"V40+((BM40+BO40)*Cattle!E$7)","v":1280.5447191481319},{"$f":"T40/'Nutrient and Energy Balance'!L38","v":20.652325733086602},{"$f":"X40/R40","v":1.6056300113422499},{"$f":"(1.42*Y40)-(0.174*Y40^2)+(0.0122*Y40^3)-1.65","v":0.23191487840562086},{"$f":"IF(I40 < 7,1,0.95)","v":1},{"$f":"IF(AU41 < AU42,AU42,AU41)","v":2.2665099150642916},{"$f":"(AB40/Q40)*100","v":8},{"$f":"((0.0154*D40)+((G40*0.454)*(13.7/90))+(AW40*0.071))/0.5","v":31.995140554303404},{"$f":"((AD40/454)/Q40)*100","v":0.2487485359036373},{"$f":"((0.016*D40)+(0.0844*G40)+(AW40*0.039))/0.68","v":24.403411014821522},{"$f":"((AF40/454)/Q40)*100","v":0.18972608514373543},7.0000000000000007E-2,0.6,0.12,0.15,0.15,10,50,40,0.1,30,{"$f":"3.8*E40","v":427.22427810899609},{"$f":"AW40/0.404","v":73.647289291611727},{"$f":"((G40*0.454)*(0.001669-(0.00000211*142))*EXP(AV40)*6.25)/0.65","v":17.375294435814329},{"$f":"AR40+AS40+AT40","v":518.24686183642211},{"$f":"(0.0278-(0.0000176*142))*142","v":3.5927135999999997},{"$f":"IF(BL40<0.25,34, BL40*(268-(29.4*(BJ40/BL40))))","v":29.753504873811142},{"$f":"E40*(Cattle!O19*1*(0.8+(I40-1)*0.05))","v":8.6569130037875528},{"$f":"IF(BD40<1.25,1.6,BD40*J40)","v":2.8248711121670063},{"$f":"((G40*0.454)*(0.05855-0.0000996*142)*EXP(BB40))/1000","v":9.1318727369141983E-2},{"$f":"((G40*0.454)*(0.576/0.13)*(0.05855-(0.0000996*142))*EXP(BB40))/1000","v":0.40461220742019827},{"$f":"(0.03233*142-0.0000275*142^2)","v":4.0363499999999988},{"$f":"(AX40+BA40)/J40","v":7.8572589913475372},{"$f":"'Nutrient and Energy Balance'!F32-BC40","v":2.4494490086524632},{"$f":"('Nutrient and Energy Balance'!F32-BC40)*K40","v":1.4542236342946708},{"$f":"D40*0.891","v":483.47513280000004},{"$f":"(F40*0.454)*0.96","v":523.00800000000004},{"$f":"D40*(478/BG40)","v":495.92499999999995},{"$f":"(0.891*BH40)-BS40","v":433.35207727011766},{"$f":"IF(BE40<0,0,BE40)","v":1.4542236342946708},{"$f":"(12.341*BI40^-0.6837)*(BJ40^0.9116)","v":0.27339894946265314},{"$f":"(BK40/0.96)*0.95","v":0.27055104373908379},{"$f":"BL40/0.454","v":0.59592740911692466},{"$f":"(G40*0.454)*0.01828*(0.02-0.0000286*142)*EXP(0.02*142-0.0000143*142^2)","v":0.13575231729704867},{"$f":"BN40/0.454","v":0.29901391475120853},{"$f":"BM40+BO40","v":0.89494132386813319},{"$f":"IF(BQ41<1,1,BQ41)+BO40","v":1.2990139147512085},{"$f":"'Nutrient and Energy Balance'!$R$92","v":2068.6526090129441},{"$f":"(G40*0.454)*0.01828*EXP(0.02*142-0.0000143*142^2)","v":8.5170977298823427},{"$f":"Cattle!$B$11","v":10}]
[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,{"$f":"(AU40/0.67)/454","v":1.7037506142298049},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Nutrient and Energy Balance'!R81","v":0}]
[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,{"$f":"Q40*0.08","v":2.2665099150642916}]
[]
[]
[]
[null,"Gestating  Heifer, last 1/3 of pregnancy"]
[null,"Current",null,null,null,"Mature","Expected",null,"Current",null,null,null,null,"NEm","Gravid","Maternal","Predicted","Predicted",null,"NEm","NEm","Weight",null,"ME","ME","Neg","Intake ","       Crude Protein",null,"Ca","Ca","Phos","Phos","Na","K","MG","S","CO","CU","FE","MN","SE","ZN","MP for","MP for","MP for",null,null,"NP req for",null,null,null,null,null,"Maintenance","Intake for","Diet RE",null,null,null,"Equiv Empty",null,"Empty body","Shrunk",null,null,null,null,null,null,"Gravid Uterus"]
[null,"Weight",null,null,"BW.75","Wt @","Calf","Milk","BCS","NEm","Neg","NEm","NEm2","sup/req","Uterus","Tissue","DM Intake","DM Intake","Nem Sup","Req","Req","Initial","Final","Req","Req","Req","Adjustment","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Maint.","Growth","Gest.","Total MP","MP","gain","NEm maint","NEm Growth","Ney","Nemgest","Energy","& Pregnancy","Growth","Available","Empty BW","Final SBW",null,"BW",null,"gain","Wt Gain",null,"ADGpreg","ADGpreg",null,null,null,"Wt, kg","Number of"]
[null,"lb","Weight (kg)","SBW","MBW","BCS=5","Birthweight","kg/day","(1-9)","Mcal/kg","Mcal/kg","Mcal/lb","Mcal/kg","Ratio","ADG, lb","ADG, lb","lb/day","kg/day","Mcal/day","Mcal/day","Mcal/lb","lb","lb","Mcal/day","Mcal/kg","Mcal/kg","%","lb/day","% of DM","g/day","% of DM","g/day","% of DM","% of DM","% of DM","% of DM","% of DM","ppm","ppm","ppm","ppm","ppm","ppm","g/day","g/day","g/day","g/day","exponent","g/day","Mcal/day","Mcal/day","Mcal/day","Mcal/day","exponent","kg","kg","Mcal/d","EBW","FSBW","EQSBW","EQEBW","RE","EBG","SWG, kg","SWG, lb","kg/d","lb/day",null,null,null,"CW","Head"]
["Late Gestation, Bred Heifer",{"$f":"(V50+(V50+(0.75*Cattle!E7)))/2","v":1233.75},{"$f":"B50*0.454","v":560.12250000000006},{"$f":"C50*0.96","v":537.71760000000006},{"$f":"D50^0.75","v":111.66464477103486},{"$f":"Cattle!D11","v":1200},{"$f":"Cattle!E11","v":80},0,{"$f":"Cattle!H11","v":5},{"$f":"'Nutrient and Energy Balance'!L$34","v":1.1532679807533848},{"$f":"'Nutrient and Energy Balance'!M34","v":0.59369418557306308},{"$f":"J50*0.454","v":0.52358366326203665},{"$f":"J50^2","v":1.3300270354309895},{"$f":"S50/T50","v":1.092070226799871},{"$f":"BN50/0.454","v":1.1777894334968786},{"$f":"BL50/0.454","v":0},{"$f":"R50/0.454","v":28.139151451448789},{"$f":"(E50)*((0.2435*J50)-(0.0466*J50^2)-0.0869)/J50","v":12.775174758957752},{"$f":"R50*J50","v":14.733199998034815},{"$f":"AX50+AY50+BA50","v":13.4910737757296},{"$f":"T50/Q50","v":0.47944138610601172},{"$f":"Cattle!C$11","v":1200},{"$f":"V50+((BM50+BO50)*Cattle!E$7)","v":1306.001049014719},{"$f":"T50/'Nutrient and Energy Balance'!L38","v":23.440413942580413},{"$f":"X50/R50","v":1.8348409618541119},{"$f":"(1.42*Y50)-(0.174*Y50^2)+(0.0122*Y50^3)-1.65","v":0.44504103785441673},{"$f":"IF(I50 < 7,1,0.95)","v":1},{"$f":"IF(AU51 < AU52,AU52,AU51)","v":2.2511321161159032},{"$f":"(AB50/Q50)*100","v":8},{"$f":"((0.0154*D50)+((G50*0.454)*(13.7/90))+(AW50*0.071))/0.5","v":32.447124302222221},{"$f":"((AD50/454)/Q50)*100","v":0.25398575686388014},{"$f":"((0.016*D50)+(0.0844*G50)+(AW50*0.039))/0.68","v":24.531590588235293},{"$f":"((AF50/454)/Q50)*100","v":0.1920254795030035},7.0000000000000007E-2,0.6,0.12,0.15,0.15,10,50,40,0.1,30,{"$f":"3.8*E50","v":424.32565012993246},{"$f":"AW50/0.404","v":84.158415841584159},{"$f":"((G50*0.454)*(0.001669-(0.00000211*253))*EXP(AV50)*6.25)/0.65","v":145.70757089162686},{"$f":"AR50+AS50+AT50","v":654.19163686314346},{"$f":"(0.0278-(0.0000176*253))*253","v":5.9068415999999999},{"$f":"IF(BL50<0.25,34, BL50*(268-(29.4*(BJ50/BL50))))","v":34},{"$f":"E50*(Cattle!O19*1*(0.8+(I50-1)*0.05))","v":8.5981776473696847},{"$f":"IF(BD50<1.25,1.6,BD50*J50)","v":1.6},{"$f":"((G50*0.454)*(0.05855-0.0000996*253)*EXP(BB50))/1000","v":0.74318836230345309},{"$f":"((G50*0.454)*(0.576/0.13)*(0.05855-(0.0000996*253))*EXP(BB50))/1000","v":3.2928961283599154},{"$f":"(0.03233*253-0.0000275*253^2)","v":6.4192424999999993},{"$f":"(AX50+BA50)/J50","v":10.310763824346903},{"$f":"'Nutrient and Energy Balance'!F32-BC50","v":-4.055824346902881E-3},{"$f":"('Nutrient and Energy Balance'!F32-BC50)*K50","v":-2.4079193324619062E-3},{"$f":"D50*0.891","v":479.10638160000008},{"$f":"(F50*0.454)*0.96","v":523.00800000000004},{"$f":"D50*(478/BG50)","v":491.44374999999997},{"$f":"(0.891*BH50)-BS50","v":395.98449591385798},{"$f":"IF(BE50<0,0,BE50)","v":0},{"$f":"(12.341*BI50^-0.6837)*(BJ50^0.9116)","v":0},{"$f":"(BK50/0.96)*0.95","v":0},{"$f":"BL50/0.454","v":0},{"$f":"(G50*0.454)*0.01828*(0.02-0.0000286*253)*EXP(0.02*253-0.0000143*253^2)","v":0.53471640280758292},{"$f":"BN50/0.454","v":1.1777894334968786},{"$f":"BM50+BO50","v":1.1777894334968786},{"$f":"IF(BQ51<0.75,0.75,BQ51)+BO50","v":1.9277894334968786},{"$f":"'Nutrient and Energy Balance'!$R$92","v":2068.6526090129441},{"$f":"(G50*0.454)*0.01828*EXP(0.02*253-0.0000143*253^2)","v":41.891885336141947},{"$f":"Cattle!$B$11","v":10}]
[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,{"$f":"(AU50/0.67)/454","v":2.1506727492377653},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Nutrient and Energy Balance'!R81","v":0}]
[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,{"$f":"Q50*0.08","v":2.2511321161159032}]
[]
[null,"Lactacting First Calf Heifer, first 90 dyas after calving",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,null,null,"Cow Model"]
[null,"Current",null,null,null,"Mature","Expected",null,"Current",null,null,null,null,"NEm","Gravid","Maternal","Predicted","Predicted",null,"NEm","NEm","Weight",null,"ME","ME","Neg","Intake ","                Crude Protein",null,"Ca","Ca","Phos","Phos","Na","K","MG","S","CO","CU","FE","MN","SE","ZN","MP for","MP for","MP for",null,null,"NP req for",null,null,null,null,null,"Maintenance","Intake for","Diet RE",null,null,null,"Equiv Empty",null,"Empty body","Shrunk"]
[null,"Weight",null,null,"BW.75","Wt @","Calf","Milk","BCS","NEm","NEG","NEm","NEm2","sup/req","Uterus","Tissue","DM Intake","DM Intake","Supplied","Req","Req","Initial","Final","Req","Req","Req","Adjustment","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Maint.","Growth","Lact.","Total MP","MP","gain","NEm maint","NEm Growth","Ney","Nemlact","Energy","& Lactation","Growth","Available","Empty BW","Final SBW",null,"BW",null,"gain","Wt Gain","Cow Model",null,"ADGpreg",null,null,null,null,"Number of"]
[null,"lb","Weight (kg)","SBW","MBW","BCS=5","Birthweight","kg/day","(1-9)","Mcal/kg","Mcal/kg","Mcal/lb","Mcal/kg","Ratio","ADG, lb","ADG, lb","lb/day","kg/day","Mcal/day","Mcal/day","Mcal/lb","lb","lb","Mcal/day","Mcal/kg","Mcal/kg","%","lb/day","% of DM","g/day","% of DM","g/day","% of DM","% of DM","% of DM","% of DM","% of DM","ppm","ppm","ppm","ppm","ppm","ppm","g/day","g/day","g/day","g/day","exponent","g/day","Mcal/day","Mcal/day","Mcal/day","Mcal/day","exponent","kg","kg","Mcal/d","EBW","FSBW","EQSBW","EQEBW","RE","EBG","SWG, kg","SWG, lb",null,"lb/day",null,null,null,null,"Head"]
["Early Lactation, First Calf Heifer",{"$f":"(V58+(V58+(0.5*Cattle!E7)))/2","v":1222.5},{"$f":"B58*0.454","v":555.01499999999999},{"$f":"C58*0.96","v":532.81439999999998},{"$f":"D58^0.75","v":110.90010702516861},{"$f":"Cattle!D11","v":1200},null,{"$f":"Cattle!G11*0.454*0.8","v":8.8000000000000007},{"$f":"Cattle!H11","v":5},{"$f":"'Nutrient and Energy Balance'!L$34","v":1.1532679807533848},{"$f":"'Nutrient and Energy Balance'!M34","v":0.59369418557306308},{"$f":"J58*0.454","v":0.52358366326203665},{"$f":"J58^2","v":1.3300270354309895},{"$f":"S58/T58","v":0.74186715837522543},{"$f":"BN58/0.454","v":0},{"$f":"BL58/0.454","v":3.9566624015742534E-2},{"$f":"R58/0.454","v":28.640201826953071},{"$f":"(E58*(0.002263+(0.134788*J58)-(0.063407*J58^2)+(0.013081*J58^3)))+H58*0.3","v":13.002651629436695},{"$f":"R58*J58","v":14.995541789120166},{"$f":"AX58+AY58+BA58","v":20.213243866950695},{"$f":"T58/Q58","v":0.70576471454639567},{"$f":"Cattle!C$11","v":1200},{"$f":"V58+((BM58+BO58)*Cattle!E$7)","v":1203.5609961614168},{"$f":"T58/'Nutrient and Energy Balance'!L38","v":35.120021670626848},{"$f":"X58/R58","v":2.7009892037035472},{"$f":"(1.42*Y58)-(0.174*Y58^2)+(0.0122*Y58^3)-1.65","v":1.1564116733025194},{"$f":"IF(I58 < 7,1,0.95)","v":1},{"$f":"IF(AU59 < AU60,AU60,AU59)","v":3.1753781144221089},{"$f":"(AB58/Q58)*100","v":11.087135955284314},{"$f":"((0.0154*D58)+(1.23*H58)+(AW58*0.039))/0.5","v":40.710683520000003},{"$f":"((AD58/454)/Q58)*100","v":0.31309524149547402},{"$f":"((0.016*D58)+(H58*0.95)+(AW58*0.039))/0.68","v":26.780927058823526},{"$f":"((AF58/454)/Q58)*100","v":0.20596512020820584},0.1,0.7,0.2,0.15,0.15,10,50,40,0.1,30,{"$f":"3.8*E58","v":421.42040669564068},{"$f":"AW58/0.404","v":84.158415841584159},{"$f":"((H58*0.034)/0.65)*1000","v":460.30769230769232},{"$f":"AR58+AS58+AT58","v":965.8865148449172},{"$f":"(0.0278-(0.0000176*145))*145","v":3.6609599999999998},{"$f":"IF(BL58<0.25,34, BL59*(268-(29.4*(BJ58/BL59))))","v":34},{"$f":"E58*(Cattle!P19*1.2*(0.8+(I58-1)*0.05))","v":12.296603866950694},{"$f":"IF(BD58<1.25,1.6,BD58*J58)","v":1.6},{"$f":"((G58*0.454)*(0.05855-0.0000996*145)*EXP(BB58))/1000","v":0},{"$f":"H58*0.7178","v":6.3166400000000005},null,{"$f":"(AX58+BA58)/J58","v":16.139565285417351},{"$f":"'Nutrient and Energy Balance'!F32-BC58","v":-5.8328572854173508},{"$f":"BD58*K58","v":-3.4629334556297615},{"$f":"D58*0.891","v":474.7376304},{"$f":"(F58*0.454)*0.96","v":523.00800000000004},{"$f":"D58*(478/BG58)","v":486.96249999999992},{"$f":"(0.891*BH58)-BO58","v":433.88358749999992},{"$f":"IF(BE58<0,0,BE58)","v":0},{"$f":"(12.341*BI58^-0.6837)*(BJ58^0.9116)","v":0},{"$f":"'Nutrient and Energy Balance'!R90","v":1.796324730314711E-2},{"$f":"BL58/0.454","v":3.9566624015742534E-2},null,{"$f":"BN58/0.454","v":0},{"$f":"BM58+BO58","v":3.9566624015742534E-2},{"$f":"IF(BQ59<0.5,0.5,BQ59)+BO58","v":0.5},{"$f":"'Nutrient and Energy Balance'!$R$92","v":2068.6526090129441},null,{"$f":"Cattle!$B$11","v":10}]
[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,{"$f":"(AU58/0.67)/454","v":3.1753781144221089},null,"from",null,null,null,null,null,null,null,null,null,null,null,null,"Using growth model:",null,{"$f":"BK58/0.96","v":0},{"$f":"BL59/0.454","v":0},null,null,null,{"$f":"'Nutrient and Energy Balance'!R81","v":0}]
[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,{"$f":"Q58*0.08","v":2.2912161461562457},null,"growth"]
[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,"model"]
[null,"Growing and Finishing Cattle",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,"Feed for"]
[null,"Average",null,null,null,null,"Expected",null,"Current",null,null,null,"Ionophore","Implant","Gravid","Maternal","Predicted","Predicted",null,"NEm","NEm","Body Weight",null,"ME","ME","Neg","Intake ","       Crude Protein",null,"Ca","Ca","Phos","Phos","Na","K","MG","S","CO","CU","FE","MN","SE","ZN","MP for","MP for",null,null,null,"NP req for","Required","RE",null,null,null,"Maintenance","Feed for","RE from",null,null,null,"Equiv Empty","RE","Empty body","Shrunk",null,null,null,null,null,null,"Gravid Uterus"]
[null,"Period Wt",null,null,"BW.75","Finish","Calf","Milk","BCS","NEm","NEG","NEm","Adjustment","Adjustment","Uterus","Tissue","DM Intake","DM Intake","Nem Sup","Req","Req","Initial","Final","Req","Req","Req","Adjustment","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Req","Maint.","Growth",null,"Total MP","MP","gain","NEm maint","Neg Growth","Ney","Nemgest","Energy",null,"Growth","Diet Energy","Empty BW",null,null,"BW","from","gain","Wt Gain",null,"ADGpreg",null,null,null,null,"Wt, kg","Number of"]
[null,"lb","Weight (kg)","SBW","MBW","Weight","Birthweight","kg/day","(1-9)","Mcal/kg","Mcal/kg","Mcal/lb","Factor","Factor","ADG, lb","ADG, lb","lb/day","kg/day","Mcal/day","Mcal/day","Mcal/lb","lb","lb","Mcal/day","Mcal/kg","Mcal/kg","%","lb/day","% of DM","g/day","% of DM","g/day","% of DM","% of DM","% of DM","% of DM","% of DM","ppm","ppm","ppm","ppm","ppm","ppm","g/day","g/day",null,"g/day","exponent","g/day","Mcal/day","Mcal/day","Mcal/day","Mcal/day","exponent","kg","kg","Avail, Mcal/d","EBW","MSBW","EQSBW","EQEBW","Wt Gain","EBG","SWG, kg","SWG, lb","kg/d",null,null,null,null,"CW","Head"]
["Growing and Finishing Cattle",{"$f":"(Cattle!C15+Cattle!D15)/2","v":1128},{"$f":"B66*0.454","v":512.11199999999997},{"$f":"C66*0.96","v":491.62751999999995},{"$f":"D66^0.75","v":104.40640430113889},{"$f":"Cattle!E15 + F67","v":1357},null,null,{"$f":"Cattle!I15","v":6},{"$f":"'Nutrient and Energy Balance'!L$34","v":1.1532679807533848},{"$f":"'Nutrient and Energy Balance'!M34","v":0.59369418557306308},{"$f":"J66*0.454","v":0.52358366326203665},{"$f":"IF(Cattle!G15 = \"Rumensin\", 1, 1.03)","v":1},{"$f":"IF(Cattle!H15 = \"Yes\", 1, 0.94)","v":1},{"$f":"BN66/0.454","v":0},{"$f":"BL66/0.454","v":0.83726268034831652},{"$f":"R66/0.454","v":25.668133252009277},{"$f":"(R67*((-0.0000003*V66^2)+(0.0007*V66)+0.6584))*(IF(BL67<0.95,0.985,1.05))","v":11.653332496412212},{"$f":"'Nutrient and Energy Balance'!F32*J66","v":11.886396323374758},{"$f":"AX66+AY66+BA66","v":10.214790697036468},{"$f":"T66/Q66","v":0.39795611923733737},{"$f":"Cattle!C15","v":818},{"$f":"(V66+(BM66*Cattle!E7))","v":893.35364123134855},null,null,null,{"$f":"IF(I66 < 7,1,0.975)","v":1},{"$f":"IF(AU67 < AU68,AU68,AU67)","v":2.0534506601607423},{"$f":"(AB66/Q66)*100","v":8},{"$f":"((0.0154*D66)+(AW66*0.071))/0.5","v":22.20469380939106},{"$f":"((AD66/454)/Q66)*100","v":0.19054372486348745},{"$f":"((0.016*D66)+(AW66*0.039))/0.68","v":14.420234123677002},{"$f":"((AF66/454)/Q66)*100","v":0.12374343672178455},7.0000000000000007E-2,0.6,0.1,0.15,0.15,10,50,20,0.1,30,{"$f":"3.8*E66","v":396.74433634432779},{"$f":"AW66/(IF($BL$67=0.875,$AZ$76,$AZ$77))","v":114.59995770414524},null,{"$f":"AR66+AS66+AT66","v":511.34429404847305},{"$f":"(0.0278-(0.0000176*145))*145","v":3.6609599999999998},{"$f":"IF(BL66=0,0,BL66*(268-(29.4*(BJ66/BL66))))","v":49.736381643599039},{"$f":"E66*(Cattle!O19*1*(0.8+(I66-1)*0.05))","v":8.4412577877470802},{"$f":"BD66*K66","v":1.7735329092893886},{"$f":"((G66*0.454)*(0.05855-0.0000996*253)*EXP(BB66))/1000","v":0},{"$f":"((G66*0.454)*(0.576/0.13)*(0.05855-(0.0000996*253))*EXP(BB66))/1000","v":0},{"$f":"(0.03233*253-0.0000275*253^2)","v":6.4192424999999993},{"$f":"AX66/J66","v":7.3194243910532721},{"$f":"'Nutrient and Energy Balance'!F32-BC66","v":2.9872836089467283},{"$f":"IF(BD66<0,0,BD66*K66)","v":1.7735329092893886},{"$f":"D66*0.891","v":438.04012031999997},{"$f":"(F66*0.454)*0.96","v":591.43487999999991},{"$f":"D66*(478/BG66)","v":397.33529845246875},{"$f":"(0.891*BH66)-BS66","v":354.02575092114967},{"$f":"(0.0635*BI66^0.75*BK66^1.097)","v":1.7733007891068477},{"$f":"12.341*(BI66^-0.6837)*(BE66^0.9116)","v":0.37619852227114459},{"$f":"(BK66/0.96)*BL67","v":0.38011725687813569},{"$f":"BL66/0.454","v":0.83726268034831652},{"$f":"(G66*0.454)*0.01825*(0.02-0.0000286*253)*EXP(0.02*253-0.0000143*253^2)","v":0},"N/A",{"$f":"BM66","v":0.83726268034831652},{"$f":"(Cattle!$D$15-Cattle!$C$15)/Cattle!$E$7","v":6.8888888888888893},"N/A",{"$f":"(G66*0.454)*0.01828*EXP(0.02*253-0.0000143*253^2)","v":0},{"$f":"Cattle!$B$15","v":100}]
[null,null,"Physiological wt adjustment",null,null,{"$f":"(Cattle!J15 - 135) * 0.6","v":-81},null,null,null,null,null,null,null,null,null,"Modified growing cattle equation",null,{"$f":"(((E66*(0.2435*J66-0.0466*J66^2-0.09985))/J66)*M66*N66*AA66)","v":10.772408652767977},"NASEM 2016 page 164 Eq. 10-1 with intercept averaged across both equations (this was better fit for cattle less than 750 pounds in 6 years of Hitch data)",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,{"$f":"(AU66/0.67)/454","v":1.6810582354147974},null,null,null,null,null,null,null,null,null,null,null,null,null,"Mcal/kg SWG",{"$f":"BJ66/BL66","v":4.6651414978388157},null,{"$f":"Cattle!U7","v":0.97},"Gain Adjustment based on Hitch Data (actual data indicated equation 12.7 overstimated gain by 8 to 12%)"]
[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,{"$f":"Q66*0.08","v":2.0534506601607423},null,null,null,null,null,null,null,null,null,null,null,null,null,"29.4*cal/gain",{"$f":"29.4*BJ67","v":137.15516003646118}]
["Mature Bulls",{"$f":"Cattle!C11","v":1200},{"$f":"B69*0.454","v":544.80000000000007},{"$f":"C69*0.96","v":523.00800000000004},{"$f":"D69^0.75","v":109.36572818847357},{"$f":"Cattle!D11*0.6","v":720},null,null,{"$f":"Cattle!H11","v":5},{"$f":"'Nutrient and Energy Balance'!L$34","v":1.1532679807533848},null,{"$f":"J69*0.454","v":0.52358366326203665},null,null,null,null,{"$f":"R69/0.454","v":22.509421268852456},{"$f":"(E69*(0.002263+(0.134788*J69)-(0.063407*J69^2)+(0.013081*J69^3)))","v":10.219277256059016},{"$f":"R69*J69","v":11.785565245854171},{"$f":"AX69+BA69","v":6.3158708028843487},{"$f":"T69/Q69","v":0.28058788040117105},{"$f":"Cattle!C$11","v":1200},{"$f":"V69+((BL69+BO69)*Cattle!E$7)","v":1201.6166922572831},{"$f":"T69/'Nutrient and Energy Balance'!L38","v":10.973672554797103},{"$f":"X69/R69","v":1.0738208074637379},null,null,{"$f":"IF(AU70 < AU71,AU71,AU70)","v":1.8007537015081965},{"$f":"(AB69/Q69)*100","v":8},{"$f":"(0.0154*D69)/0.5","v":16.108646400000001},{"$f":"((AD69/454)/Q69)*100","v":0.15762999668542288},{"$f":"(0.016*D69)/0.68","v":12.306070588235293},{"$f":"((AF69/454)/Q69)*100","v":0.12042016553508239},7.0000000000000007E-2,0.6,0.12,0.15,0.15,10,50,40,0.1,30,{"$f":"3.8*E69","v":415.58976711619954},null,null,{"$f":"AR69+AT69","v":415.58976711619954},{"$f":"(0.0278-(0.0000176*142))*142","v":3.5927135999999997},{"$f":"Q69*0.08","v":1.8007537015081965},{"$f":"E69*(Cattle!O19)*1*(0.8+(I77-1)*0.05)","v":6.3158708028843487},null,null,{"$f":"((G69*0.454)*(0.576/0.13)*(0.05855-(0.0000996*142))*EXP(BB69))/1000","v":0},{"$f":"(0.03233-(0.0000275*142))*(142)","v":4.0363499999999997},{"$f":"AX69/J69","v":5.4764988782212072},null,null,null,null,null,"Subtract 268",{"$f":"268-BJ68","v":130.84483996353882},null,{"$f":"'Nutrient and Energy Balance'!R90","v":1.796324730314711E-2},{"$f":"BL69/0.454","v":3.9566624015742534E-2},{"$f":"(G69*0.454)*0.01825*(0.02-0.0000286*142)*EXP(0.02*142-0.0000143*142^2)","v":0},{"$f":"BN69/0.454","v":0},{"$f":"BM69+BO69","v":3.9566624015742534E-2},{"$f":"'Nutrient and Energy Balance'!R81","v":0},{"$f":"'Nutrient and Energy Balance'!$R$92","v":2068.6526090129441},null,{"$f":"Cattle!$B$11","v":10}]
[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,{"$f":"(AU69/0.67)/454","v":1.366262631061212},null,null,null,null,null,null,null,null,null,null,null,null,null,"Times SWG",{"$f":"BJ69*BL66","v":49.736381643599039}]
[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,{"$f":"Q69*0.08","v":1.8007537015081965}]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Initial Wt, lb","Feed Intake Adjustment",null,null,"Equation to adjust modified NASEM equation to Hitch data:",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,"NP to MP efficiency calculation",null,null,null,null,null,null,null,null,null,null,"Mcal/kg gain","CP","Gain","Feed:Gain","DMI","DMI, % BW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"< 575",0.96869008195415796,null,null,"-3E-07X2 + 0.0007X + .6584 ",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,"Avg Wt, kg","Below","Avg","Above","Below","Avg","Above",null,null,null,"Steers",750,null,null,"Above",5.44,11.2,4.16,5.5,22.7,2.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"575 to 625",0.97242642698281934,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,100,{"$f":"0.734-(AU76*0.0012)","v":0.61399999999999999},{"$f":"0.764-(AU76*0.0012)","v":0.64400000000000002},{"$f":"0.794-(AU76*0.0012)","v":0.67400000000000004},{"$f":"MAX(((-0.0011*$BH$66)+0.734), AV78)","v":0.374},{"$f":"MAX(((-0.0012*$BH$66)+0.764), AW78)","v":0.40400000000000003},{"$f":"MAX(((-0.0012*$BH$66)+0.794), AX78)","v":0.43400000000000005},null,null,null,null,1417,null,null,"Average",5.9,10.199999999999999,3.59,6,21.6,1.99,"Revised"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"626 to 675",0.9945426248383944,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,200,{"$f":"0.734-(AU77*0.0012)","v":0.49399999999999999},{"$f":"0.764-(AU77*0.0012)","v":0.52400000000000002},{"$f":"0.794-(AU77*0.0012)","v":0.55400000000000005},"Decision",{"$f":"IF(BL67<0.875, AY76, BA76)","v":0.43400000000000005},null,null,null,null,null,"NE g = 0.69",null,null,"Below",6.46,null,3.25,6.6,21.6,1.99]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"676 to 725",1.0056001504302239,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,300,0.374,0.40400000000000003,0.43400000000000005,null,null,null,null,null,null,"Hitch",null,null,null,null,null,null,3.53,6.28,21.98,2.0299999999999998,173,1083]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"726 to 775",1.0240280646461839,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,400,0.254,0.28400000000000003,0.31400000000000006,null,null,null,null,null,null,"K-State",803,null,null,null,null,null,3.58,6.09,21.8,1.98,165,1101.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"776 to 825",1.0341576720309558,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,500,0.13400000000000001,0.16400000000000003,0.19400000000000006,null,null,null,null,null,null,null,1400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"826 to 875",1.0409918950567194,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,600,1.4000000000000012E-2,4.4000000000000039E-2,7.4000000000000066E-2,null,null,null,null,null,null,"Heifers",750,null,null,"Above",5.32,11.9,4.05,5.4,21.7,2.13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"> 875",1.044472832543244,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,700,-0.10599999999999998,-7.5999999999999956E-2,-4.599999999999993E-2,null,null,null,null,null,null,null,1285,null,null,"Average",5.88,10.6,3.43,6,20.7,2.0299999999999998]
[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,"NE g = 0.69",null,null,"Below",6.61,9.1999999999999993,3.04,6.8,20.6,2]
[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,"Hitch",null,null,null,null,null,null,3.22,6.66,21.34,2.1,155,1017.5]
[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,"K-State",741,null,null,null,null,null,3.24,6.36,20.6,2.0499999999999998,160,1005]
[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,1269]

{"sheet":"Feed Categories","index":9,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":true,"merged":[[10,11,10,14],[11,11,11,14],[12,11,12,14],[13,11,13,14]]}
[]
[]
[null,"FEED CATEGORIES","Grazed Forages","Harvested Forages","Concentrates","Commercial Feeds","Mineral and vitamins","Select Feed Ingredient"]
[null,"Select Feed Ingredient",{"$f":"'Feed List'!C6","v":"Alfalfa, fresh and greenchop"},{"$f":"'Feed List'!C32","v":"Alfalfa Hay,early bloom"},{"$f":"'Feed List'!C67","v":"Barley Malt pellets with hulls"},{"$f":"'Feed List'!C106","v":"Alfalfa Pellets"},{"$f":"'Feed List'!C129","v":"Calcium Carbonate"},null,{"$f":"ISNUMBER(SEARCH($I$2,A4))","v":false}]
[null,"Grazed forages",{"$f":"'Feed List'!C7","v":"Bermuda, vegetative"},{"$f":"'Feed List'!C33","v":"Alfalfa Hay, mid bloom"},{"$f":"'Feed List'!C68","v":"Corn Gluten Feed"},{"$f":"'Feed List'!C107","v":"Aalfala Cubes"},{"$f":"'Feed List'!C130","v":"Cobalt Carbonate"},null,{"$f":"ISNUMBER(SEARCH($I$2,A5:C53))","v":false}]
[null,"Harvested Forages",{"$f":"'Feed List'!C8","v":"Bermuda, boot stage"},{"$f":"'Feed List'!C34","v":"Alfalfa Hay, full bloom"},{"$f":"'Feed List'!C69","v":"Corn Grain, rolled"},{"$f":"'Feed List'!C108","v":"Alfalfa Dehydrated, 17% CP"},{"$f":"'Feed List'!C131","v":"Cobalt Sulfate"},null,false]
[null,"Concentrates",{"$f":"'Feed List'!C9","v":"Bermuda, fall, mature"},{"$f":"'Feed List'!C35","v":"Alfalfa Silage"},{"$f":"'Feed List'!C70","v":"Corn Grain, steam flaked"},{"$f":"'Feed List'!C109","v":"Cane molasses"},{"$f":"'Feed List'!C132","v":"Copper Sulfate"},null,false]
[null,"Commercial Feeds",{"$f":"'Feed List'!C10","v":"Bermuda, winter, mature"},{"$f":"'Feed List'!C36","v":"Bermuda Hay, vegetative"},{"$f":"'Feed List'!C71","v":"Corn Grain, whole"},{"$f":"'Feed List'!C110","v":"Liquid 20%"},{"$f":"'Feed List'!C133","v":"Dicalcium phosphate"},null,false]
[null,"Mineral and Vitamins",{"$f":"'Feed List'!C11","v":"Bermuda, stockpiled, Sep-Oct"},{"$f":"'Feed List'!C37","v":"Bermuda Hay, early bloom"},{"$f":"'Feed List'!C72","v":"Cotton Seed Hulls"},{"$f":"'Feed List'!C111","v":"Liquid 25%"},{"$f":"'Feed List'!C134","v":"Limestone 38%"},null,false]
[null,null,{"$f":"'Feed List'!C12","v":"Bermuda, stockpiled, Nov-Dec"},{"$f":"'Feed List'!C38","v":"Bermuda Hay, full bloom"},{"$f":"'Feed List'!C73","v":"Cottonseed meal, 41%"},{"$f":"'Feed List'!C112","v":"Liquid 30%"},{"$f":"'Feed List'!C135","v":"Magnesium Oxide"},null,false]
[null,null,{"$f":"'Feed List'!C13","v":"Bermuda, stockpiled, Jan-Feb"},{"$f":"'Feed List'!C39","v":"Brome Hay, early bloom"},{"$f":"'Feed List'!C74","v":"Cottonseed, whole"},{"$f":"'Feed List'!C113","v":"Protein block"},{"$f":"'Feed List'!C136","v":"Potassium chloride"},null,false]
[null,null,{"$f":"'Feed List'!C14","v":"Fescue, vegetative"},{"$f":"'Feed List'!C40","v":"Corn Silage"},{"$f":"'Feed List'!C75","v":"Distillers Grains with Solubles, corn"},{"$f":"'Feed List'!C114","v":"Range Cube, 20%"},{"$f":"'Feed List'!C137","v":"Selenium 600"},null,false]
[null,null,{"$f":"'Feed List'!C15","v":"Fescue, boot stage"},{"$f":"'Feed List'!C41","v":"Cotton Gin Trash"},{"$f":"'Feed List'!C76","v":"Distillers Grains with Solubles, sorghum"},{"$f":"'Feed List'!C115","v":"Range Cube, 25%"},{"$f":"'Feed List'!C138","v":"Sodium Chloride"},null,false]
[null,null,{"$f":"'Feed List'!C16","v":"Fescue, mature"},{"$f":"'Feed List'!C42","v":"Fescue Hay, early bloom"},{"$f":"'Feed List'!C77","v":"Grain Screenings"},{"$f":"'Feed List'!C116","v":"Range Cube, 32%"},{"$f":"'Feed List'!C139","v":"Zinc Oxide"},null,false]
[null,null,{"$f":"'Feed List'!C17","v":"Fescue, stockpiled, Jan-Feb"},{"$f":"'Feed List'!C43","v":"Fescue Hay, full bloom"},{"$f":"'Feed List'!C78","v":"Milo, ground"},{"$f":"'Feed List'!C117","v":"Range Cube, 38%"},{"$f":"'Feed List'!C140","v":"Zinc Sulfate"},null,false]
[null,null,{"$f":"'Feed List'!C18","v":"Fescue, stockpiled, Nov-Dec"},{"$f":"'Feed List'!C44","v":"Oat Hay"},{"$f":"'Feed List'!C79","v":"Milo, steam flaked"},{"$f":"'Feed List'!C118","v":"B-283 Oklahoma Gold Cube w Rumensin"},{"$f":"'Feed List'!C141","v":"Stillwater CTC 2.0 Beef Mineral"},null,false]
[null,null,{"$f":"'Feed List'!C19","v":"Native Range, April-June"},{"$f":"'Feed List'!C45","v":"Poultry Litter"},{"$f":"'Feed List'!C80","v":"Mung Beans"},{"$f":"'Feed List'!C119","v":"1925 Hfr Feed Intake TMR, R2"},{"$f":"'Feed List'!C142","v":"B-628 Dry TMR Supplement"},null,false]
[null,null,{"$f":"'Feed List'!C20","v":"Native Range, July-August"},{"$f":"'Feed List'!C46","v":"Prairie Hay, vegetative"},{"$f":"'Feed List'!C81","v":"Oats"},{"$f":"'Feed List'!C120","v":"1920 TMR, Creep Feed"},{"$f":"'Feed List'!C143","v":"Sweetlix Aureo FC C6000"},null,false]
[null,null,{"$f":"'Feed List'!C21","v":"Native Range, Sept Oct"},{"$f":"'Feed List'!C47","v":"Prairie Hay, mature"},{"$f":"'Feed List'!C82","v":"Peanut Hulls"},{"$f":"'Feed List'!C121","v":"OSU 25 Custom Liquid NPT 7294"},{"$f":"'Feed List'!C144","v":"Deccox, 6%"},null,false]
[null,null,{"$f":"'Feed List'!C22","v":"Native Range, Nov-Dec"},{"$f":"'Feed List'!C48","v":"Red Clover Hay"},{"$f":"'Feed List'!C83","v":"Peanut Meal, solvent"},{"$f":"'Feed List'!C122","v":"Added Feed"},{"$f":"'Feed List'!C145","v":"B-350 RCRC Mineral"},null,false]
[null,null,{"$f":"'Feed List'!C23","v":"Native Range, Jan-March"},{"$f":"'Feed List'!C49","v":"Sorghum Sudan Hay, early bloom"},{"$f":"'Feed List'!C84","v":"Milo, rolled or grnd"},{"$f":"'Feed List'!C123","v":"Added Feed"},{"$f":"'Feed List'!C146","v":"Added Feed"},null,false]
[null,null,{"$f":"'Feed List'!C24","v":"Wheat Forage, vegetative"},{"$f":"'Feed List'!C50","v":"Soybean Hay"},{"$f":"'Feed List'!C85","v":"Rice Bran, full fat"},{"$f":"'Feed List'!C124","v":"Added Feed"},{"$f":"'Feed List'!C147","v":"Added Feed"},null,false]
[null,null,{"$f":"'Feed List'!C25","v":"Added Feed"},{"$f":"'Feed List'!C51","v":"Sudan Hay, full bloom"},{"$f":"'Feed List'!C86","v":"Rice Grain"},{"$f":"'Feed List'!C125","v":"Added Feed"},{"$f":"'Feed List'!C148","v":"Added Feed"},null,false]
[null,null,{"$f":"'Feed List'!C26","v":"Added Feed"},{"$f":"'Feed List'!C52","v":"Sorghum Silage"},{"$f":"'Feed List'!C87","v":"Rice Hulls"},{"$f":"'Feed List'!C126","v":"Added Feed"},{"$f":"'Feed List'!C149","v":"Added Feed"},null,false]
[null,null,{"$f":"'Feed List'!C27","v":"Added Feed"},{"$f":"'Feed List'!C53","v":"Sorghum Sudan Silage"},{"$f":"'Feed List'!C88","v":"Rice Mill Byproduct"},{"$f":"'Feed List'!C127","v":"Added Feed"},{"$f":"'Feed List'!C150","v":"Added Feed"},null,false]
[null,null,{"$f":"'Feed List'!C28","v":"Added Feed"},{"$f":"'Feed List'!C54","v":"Triticale Hay"},{"$f":"'Feed List'!C89","v":"Soybean Hulls"},null,null,null,false]
[null,null,{"$f":"'Feed List'!C29","v":"Added Feed"},{"$f":"'Feed List'!C55","v":"Triticale Silage"},{"$f":"'Feed List'!C90","v":"Soybean meal, 48%"},null,null,null,false]
[null,null,{"$f":"'Feed List'!C30","v":"Added Feed"},{"$f":"'Feed List'!C56","v":"Wheat Hay"},{"$f":"'Feed List'!C91","v":"Soybeans, Whole"},null,null,null,false]
[null,null,null,{"$f":"'Feed List'!C57","v":"Wheat Silage"},{"$f":"'Feed List'!C92","v":"Sunflower Seed Hulls"},null,null,null,false]
[null,null,null,{"$f":"'Feed List'!C58","v":"Wheat Straw"},{"$f":"'Feed List'!C93","v":"Sunflower Seed Meal with hulls"},null,null,null,false]
[null,null,null,{"$f":"'Feed List'!C59","v":"Wheat Straw, Ammoniated"},{"$f":"'Feed List'!C94","v":"Wheat Grain, rolled"},null,null,null,false]
[null,null,null,{"$f":"'Feed List'!C60","v":"Added Feed"},{"$f":"'Feed List'!C95","v":"Wheat Bran"},null,null,null,false]
[null,null,null,{"$f":"'Feed List'!C61","v":"Added Feed"},{"$f":"'Feed List'!C96","v":"Wheat Middlings"},null,null,null,false]
[null,null,null,{"$f":"'Feed List'!C62","v":"Added Feed"},{"$f":"'Feed List'!C97","v":"Wheat Mill Run"},null,null,null,false]
[null,null,null,{"$f":"'Feed List'!C63","v":"Added Feed"},{"$f":"'Feed List'!C98","v":"Wheat Shorts"},null,null,null,false]
[null,null,null,{"$f":"'Feed List'!C64","v":"Added Feed"},{"$f":"'Feed List'!C99","v":"Finishing Ration"},null,null,null,false]
[null,null,null,{"$f":"'Feed List'!C65","v":"Added Feed"},{"$f":"'Feed List'!C100","v":"Added Feed"},null,null,null,false]
[null,null,null,null,{"$f":"'Feed List'!C101","v":"Added Feed"},null,null,null,false]
[null,null,null,null,{"$f":"'Feed List'!C102","v":"Added Feed"},null,null,null,false]
[null,null,null,null,{"$f":"'Feed List'!C103","v":"Added Feed"},null,null,null,false]
[null,null,null,null,{"$f":"'Feed List'!C104","v":"Added Feed"},null,null,null,false]
[null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,false]