{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Home screen","Summary","Feeds","calculations","Cow_req","Basis for calculations"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home screen","index":0,"n_rows":34,"n_cols":24,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"UF Hay Balancer"]
[]
[null,null,null,null,"Orange cells are input cells: enter your information here. These are the only cells that can be modified."]
[]
[]
["INPUT"]
["Type of animal",null,null,null,1,"1 = cow, 2  = growing heifer, 3 = bull",null,null,null,null,null,null,null,null,null,null,null,"adjusted month of lactation",null,null,null,null,"intake level"]
["Months of lactation (enter 0 for dry cows)",null,null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E9>12,0,E9)","v":5},null,null,null,null,1.7,"lactating"]
["Type of breed",null,null,null,1,"1  = For british breeds (Angus, Hereford, etc), 2  = Brangus or Braford, 3 = Brahman or Nellore",null,null,null,null,null,null,null,null,null,null,null,"rounded BW (hide later)",null,null,null,null,1.4,"dry"]
["Average body weight (BW) in lbs",null,null,null,1200,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E11<1000,1000,IF(E11>1600,1600,MROUND(E11,100)))","v":1200}]
["Number of animals",null,null,null,1]
["Number of days to supplement",null,null,null,90,null,null,null,null,null,null,null,null,null,null,null,null,"no waste (0%)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"low (10%)"]
["Type of hay",null,1,"1 = Bahiagrass, 2 = Tifton 85 bermudagrass, 3 = Coastal bermuda, 4 = other",null,null,null,null,null,null,null,null,null,null,null,null,null,"moderate (30%)"]
["Estimated hay cost ($ per ton as fed)",null,null,null,100,null,null,null,null,null,null,null,null,null,null,null,null,"high (50%)"]
["Average bale weight (lbs as is) ",null,null,null,900]
["Hay DM % (use 90 as default if unknown)",null,null,null,90,"%"]
["TDN in hay (%, DM)",null,null,null,55]
["Crude Protein (CP) in hay (%, DM)",null,null,null,10,null,null,null,null,null,null,null,null,null,"hay waste factor check cell (hide later)"]
["Estimated hay feeding waste",null,null,null,2,null,null,null,null,null,null,null,null,null,{"$f":"E22","v":0.1}]
[null,null,null,null,{"$f":"IF(E21=1,0,IF(E21=2,0.1,IF(E21=3,0.3,IF(E21=4,0.5))))","v":0.1}]
["OUTPUT"]
["Daily TDN requirements (lbs/hd/d)",null,null,null,{"$f":"IF(R11=1000,VLOOKUP(R9,Cow_req!M2:O14,2),IF(R11=1100,VLOOKUP(R9,Cow_req!S2:U14,2),IF(R11=1200,VLOOKUP(R9,Cow_req!Y2:AA14,2),IF(R11=1300,VLOOKUP(R9,Cow_req!AE2:AG14,2),IF(R11=1400,VLOOKUP(R9,Cow_req!AK2:AM14,2),IF(R11=1500,VLOOKUP(R9,Cow_req!AQ2:AS14,2),IF(R11=1600,VLOOKUP(R9,Cow_req!AW2:AY14,2),\"cow weight is out of the normal range\")))))))","v":13.08}]
["Daily CP requirements (lbs/hd/d)",null,null,null,{"$f":"IF(R11=1000,VLOOKUP(R9,Cow_req!M2:O14,3),IF(R11=1100,VLOOKUP(R9,Cow_req!S2:U14,3),IF(R11=1200,VLOOKUP(R9,Cow_req!Y2:AA14,3),IF(R11=1300,VLOOKUP(R9,Cow_req!AE2:AG14,3),IF(R11=1400,VLOOKUP(R9,Cow_req!AK2:AM14,3),IF(R11=1500,VLOOKUP(R9,Cow_req!AQ2:AS14,3),IF(R11=1600,VLOOKUP(R9,Cow_req!AW2:AY14,3),\"cow weight is out of the normal\")))))))","v":1.84}]
[]
["Hay dry matter intake (lbs/hd/day)",null,null,null,{"$f":"IF(R9=0,E11*W10/100,IF(R9>=7,E11*W10/100,E11*W9/100))","v":20.399999999999999},null,"Shortage/surplus of TDN from hay (lbs/hd/d) =",null,null,null,null,null,{"$f":"E28-E24","v":-1.8599999999999994},{"$f":"IF(M27>=0,S27,\"\")","v":""},{"$f":"IF(M27<0,T27,\"\")","v":"Need more TDN"},null,null,null,"P","Need more TDN"]
["Daily TDN intake from hay (lbs/hd/d)",null,null,null,{"$f":"E27*E19/100","v":11.22},null,"Shortage/surplus of CP from hay (lbs/hd/d) =",null,null,null,null,null,{"$f":"E29-E25","v":0.19999999999999996},{"$f":"IF(M28>=0,S28,\"\")","v":"P"},{"$f":"IF(M28<0,T28,\"\")","v":""},null,null,null,"P","Need more protein"]
["Daily CP intake from hay (lbs/hd/d)",null,null,null,{"$f":"E27*E20/100","v":2.04}]
[]
[]
["Total amount of hay needed (in lbs as is) not accounting for waste",null,null,null,null,null,null,{"$f":"E12*E13*(E27/(E18/100))","v":2039.9999999999998},"(for the entire feeding season)"]
["Total amount of hay needed (in lbs as is) accounting for waste",null,null,null,null,null,null,{"$f":"H32+H32*E22","v":2244}]
["Total hay bales needed accounting for waste",null,null,null,null,null,null,{"$f":"H33/E17","v":2.4933333333333332},"(for the entire feeding season)"]

{"sheet":"Summary","index":1,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"UF Hay Balancer"]
[]
[null,null,null,"Summary of diet balance and costs"]
[]
["Shortage/surplus of TDN from hay (lbs/hd/d) =",null,null,{"$f":"'Home screen'!M27","v":-1.8599999999999994},null,"Feed # lookup"]
["Shortage/surplus of CP from hay (lbs/hd/d) =",null,null,{"$f":"'Home screen'!M28","v":0.19999999999999996},null,"Feed number =",2]
[null,null,null,null,null,"Feed name =",{"$f":"VLOOKUP(G7,Feeds!A6:F205,2,FALSE)","v":"Corn gluten feed, pellets"}]
["Feed number","Feed name","Lb/cow/day to feed (as fed)","TDN supplied (lb/cow/d)","CP supplied (lb/cow/d)","Daily cost ($/hd/d)","Total feed needed (lbs)",null,"For a total of:",{"$f":"'Home screen'!E13","v":90},"day(s)"]
[0,"Free choice hay intake",{"$f":"'Home screen'!E27/('Home screen'!E18/100)","v":22.666666666666664},{"$f":"'Home screen'!E28","v":11.22},{"$f":"'Home screen'!E29","v":2.04},{"$f":"C10*('Home screen'!E16/2000)","v":1.1333333333333333},null,null,null,{"$f":"'Home screen'!E12","v":1},"cow(s)"]
[2,{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,Feeds!$A$6:$F$205,2,FALSE))","v":"Corn gluten feed, pellets"},0,{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,Feeds!$A$6:$F$205,4,FALSE)/100*C11*(VLOOKUP(A11,Feeds!$A$6:$F$205,3,FALSE)/100))","v":0},{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,Feeds!$A$6:$F$205,5,FALSE)/100*C11*(VLOOKUP(A11,Feeds!$A$6:$F$205,3,FALSE)/100))","v":0},{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,Feeds!$A$6:$F$205,6,FALSE)/2000*C11)","v":0},{"$f":"IF(A11=\"\",\"\",C11*$J$9*$J$10)","v":0}]
[3,{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,Feeds!$A$6:$F$205,2,FALSE))","v":"Soybean hulls, pellets"},3,{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,Feeds!$A$6:$F$205,4,FALSE)/100*C12*(VLOOKUP(A12,Feeds!$A$6:$F$205,3,FALSE)/100))","v":1.6092},{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,Feeds!$A$6:$F$205,5,FALSE)/100*C12*(VLOOKUP(A12,Feeds!$A$6:$F$205,3,FALSE)/100))","v":0.311112},{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,Feeds!$A$6:$F$205,6,FALSE)/2000*C12)","v":0.30000000000000004},{"$f":"IF(A12=\"\",\"\",C12*$J$9*$J$10)","v":270},null,"Average cow weight:"]
[null,{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,Feeds!$A$6:$F$205,2,FALSE))","v":""},null,{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,Feeds!$A$6:$F$205,4,FALSE)/100*C13*(VLOOKUP(A13,Feeds!$A$6:$F$205,3,FALSE)/100))","v":""},{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,Feeds!$A$6:$F$205,5,FALSE)/100*C13*(VLOOKUP(A13,Feeds!$A$6:$F$205,3,FALSE)/100))","v":""},{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,Feeds!$A$6:$F$205,6,FALSE)/2000*C13)","v":""},{"$f":"IF(A13=\"\",\"\",C13*$J$9*$J$10)","v":""},null,{"$f":"'Home screen'!E11","v":1200},"lbs"]
[null,{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,Feeds!$A$6:$F$205,2,FALSE))","v":""},null,{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,Feeds!$A$6:$F$205,4,FALSE)/100*C14*(VLOOKUP(A14,Feeds!$A$6:$F$205,3,FALSE)/100))","v":""},{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,Feeds!$A$6:$F$205,5,FALSE)/100*C14*(VLOOKUP(A14,Feeds!$A$6:$F$205,3,FALSE)/100))","v":""},{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,Feeds!$A$6:$F$205,6,FALSE)/2000*C14)","v":""},{"$f":"IF(A14=\"\",\"\",C14*$J$9*$J$10)","v":""}]
[null,{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,Feeds!$A$6:$F$205,2,FALSE))","v":""},null,{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,Feeds!$A$6:$F$205,4,FALSE)/100*C15*(VLOOKUP(A15,Feeds!$A$6:$F$205,3,FALSE)/100))","v":""},{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,Feeds!$A$6:$F$205,5,FALSE)/100*C15*(VLOOKUP(A15,Feeds!$A$6:$F$205,3,FALSE)/100))","v":""},{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,Feeds!$A$6:$F$205,6,FALSE)/2000*C15)","v":""},"",null,"Type of hay fed:"]
[null,{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,Feeds!$A$6:$F$205,2,FALSE))","v":""},null,{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,Feeds!$A$6:$F$205,4,FALSE)/100*C16*(VLOOKUP(A16,Feeds!$A$6:$F$205,3,FALSE)/100))","v":""},{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,Feeds!$A$6:$F$205,5,FALSE)/100*C16*(VLOOKUP(A16,Feeds!$A$6:$F$205,3,FALSE)/100))","v":""},{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,Feeds!$A$6:$F$205,6,FALSE)/2000*C16)","v":""},"",null,{"$f":"IF('Home screen'!C15=1, \"Bahiagrass\",IF('Home screen'!C15=2, \"Tifton 85 bermudagrass\", IF('Home screen'!C15=3, \"Coastal bermuda\", \"other\")))","v":"Bahiagrass"}]
[null,{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,Feeds!$A$6:$F$205,2,FALSE))","v":""},null,{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,Feeds!$A$6:$F$205,4,FALSE)/100*C17*(VLOOKUP(A17,Feeds!$A$6:$F$205,3,FALSE)/100))","v":""},{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,Feeds!$A$6:$F$205,5,FALSE)/100*C17*(VLOOKUP(A17,Feeds!$A$6:$F$205,3,FALSE)/100))","v":""},{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,Feeds!$A$6:$F$205,6,FALSE)/2000*C17)","v":""},"",null,{"$f":"'Home screen'!E19","v":55},"% TDN"]
[null,{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,Feeds!$A$6:$F$205,2,FALSE))","v":""},null,{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,Feeds!$A$6:$F$205,4,FALSE)/100*C18*(VLOOKUP(A18,Feeds!$A$6:$F$205,3,FALSE)/100))","v":""},{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,Feeds!$A$6:$F$205,5,FALSE)/100*C18*(VLOOKUP(A18,Feeds!$A$6:$F$205,3,FALSE)/100))","v":""},{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,Feeds!$A$6:$F$205,6,FALSE)/2000*C18)","v":""},"",null,{"$f":"'Home screen'!E20","v":10},"% CP"]
[null,"Toal supplemental feed =",{"$f":"SUM(C11:C18)","v":3},"lb/cow/d"]
[]
["Shortage/surplus of TDN in balanced diet (lbs/hd/d) =",null,null,null,{"$f":"D6+SUM(D11:D18)","v":-0.25079999999999947},{"$f":"IF(E21>=0,K21,\"\")","v":""},{"$f":"IF(E21<0,L21,\"\")","v":"Need more TDN"},null,null,null,"P","Need more TDN"]
["Shortage/surplus of CP in balanced diet (lbs/hd/d) =",null,null,null,{"$f":"D7+SUM(E11:E18)","v":0.51111200000000001},{"$f":"IF(E22>=0,K22,\"\")","v":"P"},{"$f":"IF(E22<0,L22,\"\")","v":""},null,null,null,"P","Need more protein"]
[]
["Total daily feed cost (supplement only) =",null,null,null,null,{"$f":"SUM(F11:F18)","v":0.30000000000000004},"$ per cow/day"]
[]
["Total daily feed cost (hay plus supplement) =",null,null,null,null,{"$f":"SUM(F10:F18)","v":1.4333333333333333},"$ per cow/day"]
[]
["Disclaimer: Balancing calculations do not take into account any changes in hay intake as a result of supplementation."]
[null,"Questions or feedback:","ndilorenzo@ufl.edu "]

{"sheet":"Feeds","index":2,"n_rows":205,"n_cols":6,"rows_kept":205,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Feeds library"]
["Feed number","Feed name","DM, %","TDN, % DM basis","CP, % DM basis","Cost ($ per ton as is)"]
[1,"Perennial peanut hay",88,61,14.7,280]
[2,"Corn gluten feed, pellets",87.2,74,18,180]
[3,"Soybean hulls, pellets",89.4,60,11.6,200]
[4,"Molasses, cane",78.2,78,8.1999999999999993,120]
[5,"Citrus pulp, pellets",90,78,6.5,265]
[6,"Peanut hay",90,52,10,100]
[7,"Cracked corn",88,88,9,199]
[8,"Carinata meal, pellets",89.8,80,43.3,300]
[9,"Fiber pellets, AFG Feeds",90,50,10,100]
[10,"Urea",99,0,288,250]
[11,"Dry Distillers grains plus solubles (DDGS)",86.3,83,32.799999999999997,190]
[12,"Cottonseed meal",88.9,67,49.2,359]
[13,"Whole cottonseed",90,90,28,237]
[14,"Soybean meal",90.7,84,49,385]
[15,"Ryegrass baleage",51.2,69.099999999999994,11.9,65]
[16,"Cotton gin trash",92,40,{"$f":"12.2-6.5","v":5.6999999999999993},30]
[17,"Canola meal",90,71,41,280]
[18,"BLANK"]
[19,"BLANK"]
[20,"BLANK"]
[21,"BLANK"]
[22,"BLANK"]
[23,"BLANK"]
[24,"BLANK"]
[25,"BLANK"]
[26,"BLANK"]
[27,"BLANK"]
[28,"BLANK"]
[29,"BLANK"]
[30,"BLANK"]
[31,"BLANK"]
[32,"BLANK"]
[33,"BLANK"]
[34,"BLANK"]
[35,"BLANK"]
[36,"BLANK"]
[37,"BLANK"]
[38,"BLANK"]
[39,"BLANK"]
[40,"BLANK"]
[41,"BLANK"]
[42,"BLANK"]
[43,"BLANK"]
[44,"BLANK"]
[45,"BLANK"]
[46,"BLANK"]
[47,"BLANK"]
[48,"BLANK"]
[49,"BLANK"]
[50,"BLANK"]
[51,"BLANK"]
[52,"BLANK"]
[53,"BLANK"]
[54,"BLANK"]
[55,"BLANK"]
[56,"BLANK"]
[57,"BLANK"]
[58,"BLANK"]
[59,"BLANK"]
[60,"BLANK"]
[61,"BLANK"]
[62,"BLANK"]
[63,"BLANK"]
[64,"BLANK"]
[65,"BLANK"]
[66,"BLANK"]
[67,"BLANK"]
[68,"BLANK"]
[69,"BLANK"]
[70,"BLANK"]
[71,"BLANK"]
[72,"BLANK"]
[73,"BLANK"]
[74,"BLANK"]
[75,"BLANK"]
[76,"BLANK"]
[77,"BLANK"]
[78,"BLANK"]
[79,"BLANK"]
[80,"BLANK"]
[81,"BLANK"]
[82,"BLANK"]
[83,"BLANK"]
[84,"BLANK"]
[85,"BLANK"]
[86,"BLANK"]
[87,"BLANK"]
[88,"BLANK"]
[89,"BLANK"]
[90,"BLANK"]
[91,"BLANK"]
[92,"BLANK"]
[93,"BLANK"]
[94,"BLANK"]
[95,"BLANK"]
[96,"BLANK"]
[97,"BLANK"]
[98,"BLANK"]
[99,"BLANK"]
[100,"BLANK"]
[101,"BLANK"]
[102,"BLANK"]
[103,"BLANK"]
[104,"BLANK"]
[105,"BLANK"]
[106,"BLANK"]
[107,"BLANK"]
[108,"BLANK"]
[109,"BLANK"]
[110,"BLANK"]
[111,"BLANK"]
[112,"BLANK"]
[113,"BLANK"]
[114,"BLANK"]
[115,"BLANK"]
[116,"BLANK"]
[117,"BLANK"]
[118,"BLANK"]
[119,"BLANK"]
[120,"BLANK"]
[121,"BLANK"]
[122,"BLANK"]
[123,"BLANK"]
[124,"BLANK"]
[125,"BLANK"]
[126,"BLANK"]
[127,"BLANK"]
[128,"BLANK"]
[129,"BLANK"]
[130,"BLANK"]
[131,"BLANK"]
[132,"BLANK"]
[133,"BLANK"]
[134,"BLANK"]
[135,"BLANK"]
[136,"BLANK"]
[137,"BLANK"]
[138,"BLANK"]
[139,"BLANK"]
[140,"BLANK"]
[141,"BLANK"]
[142,"BLANK"]
[143,"BLANK"]
[144,"BLANK"]
[145,"BLANK"]
[146,"BLANK"]
[147,"BLANK"]
[148,"BLANK"]
[149,"BLANK"]
[150,"BLANK"]
[151,"BLANK"]
[152,"BLANK"]
[153,"BLANK"]
[154,"BLANK"]
[155,"BLANK"]
[156,"BLANK"]
[157,"BLANK"]
[158,"BLANK"]
[159,"BLANK"]
[160,"BLANK"]
[161,"BLANK"]
[162,"BLANK"]
[163,"BLANK"]
[164,"BLANK"]
[165,"BLANK"]
[166,"BLANK"]
[167,"BLANK"]
[168,"BLANK"]
[169,"BLANK"]
[170,"BLANK"]
[171,"BLANK"]
[172,"BLANK"]
[173,"BLANK"]
[174,"BLANK"]
[175,"BLANK"]
[176,"BLANK"]
[177,"BLANK"]
[178,"BLANK"]
[179,"BLANK"]
[180,"BLANK"]
[181,"BLANK"]
[182,"BLANK"]
[183,"BLANK"]
[184,"BLANK"]
[185,"BLANK"]
[186,"BLANK"]
[187,"BLANK"]
[188,"BLANK"]
[189,"BLANK"]
[190,"BLANK"]
[191,"BLANK"]
[192,"BLANK"]
[193,"BLANK"]
[194,"BLANK"]
[195,"BLANK"]
[196,"BLANK"]
[197,"BLANK"]
[198,"BLANK"]
[199,"BLANK"]
[200,"BLANK"]

{"sheet":"calculations","index":3,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,1000,1200,1400]
[null,null,null,1.8,1.8,1.8]
[null,null,"hay DMI",{"$f":"D3*D2/100","v":18},{"$f":"E3*E2/100","v":21.6},25.2]
[null,null,"CP",7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2]
[null,null,"TDN",0.52,0.52,0.52]
[null,null,"CP supplied",{"$f":"D4*D5","v":1.2600000000000002},{"$f":"E4*E5","v":1.5120000000000002},1.764]
[null,null,"TDN supplied",{"$f":"D4*D6","v":9.36},{"$f":"E4*E6","v":11.232000000000001},13.103999999999999]
[null,null,null,null,null,null,null,"CP req.","TDN req."]
[null,null,null,null,null,null,null,0.45,2.41]
[null,null,null,null,null,"CP","TDN","CP suppl","TDN suppl"]
[null,null,null,2.1180555555555558,3,17.5,78.5,{"$f":"E12*F12/100","v":0.52500000000000002},{"$f":"E12*G12/100","v":2.355}]
[null,null,null,"DDGS",3,29,98,{"$f":"E13*F13/100","v":0.87},{"$f":"E13*G13/100","v":2.94}]
[null,null,null,"A",4,10.9,67,0.436,2.68]
[null,null,null,"B",4,12.5,70,0.5,2.8]
[null,null,null,"C",3,21.9,73,0.65699999999999992,2.19]

{"sheet":"Cow_req","index":4,"n_rows":85,"n_cols":51,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["Mature cow BW","Milk production at peak (lbs)","Months since calving","TDN required (lb/d)","CP required (lb/d)",null,null,null,null,null,"Mature cow BW","Milk production at peak (lbs)","Month of lactation","TDN required (lb/d)","CP required (lb/d)",null,"Mature cow BW","Milk production at peak (lbs)","Month of lactation","TDN required (lb/d)","CP required (lb/d)",null,"Mature cow BW","Milk production at peak (lbs)","Month of lactation","TDN required (lb/d)","CP required (lb/d)",null,"Mature cow BW","Milk production at peak (lbs)","Month of lactation","TDN required (lb/d)","CP required (lb/d)",null,"Mature cow BW","Milk production at peak (lbs)","Month of lactation","TDN required (lb/d)","CP required (lb/d)",null,"Mature cow BW","Milk production at peak (lbs)","Month of lactation","TDN required (lb/d)","CP required (lb/d)",null,"Mature cow BW","Milk production at peak (lbs)","Months since calving","TDN required (lb/d)","CP required (lb/d)"]
[1000,10,1,12.05,1.88,null,null,null,null,null,1000,10,0,9.4700000000000006,1.26,null,1100,10,0,10.17,1.355,null,1200,10,0,10.87,1.45,null,1300,10,0,11.555,1.54,null,1400,10,0,12.24,1.63,null,1500,10,0,12.914999999999999,1.7250000000000001,null,1600,10,0,13.59,1.82]
[1000,10,2,12.51,2.0099999999999998,null,null,null,null,null,1000,10,1,12.05,1.88,null,1100,10,1,12.77,1.97,null,1200,10,1,13.49,2.06,null,1300,10,1,14.185,2.145,null,1400,10,1,14.88,2.23,null,1500,10,1,15.559999999999999,2.31,null,1600,10,1,16.239999999999998,2.39]
[1000,10,3,12.49,1.93,null,null,null,null,null,1000,10,2,12.51,2.0099999999999998,null,1100,10,2,13.225,2.0999999999999996,null,1200,10,2,13.94,2.19,null,1300,10,2,14.629999999999999,2.2749999999999999,null,1400,10,2,15.32,2.36,null,1500,10,2,15.995000000000001,2.44,null,1600,10,2,16.670000000000002,2.52]
[1000,10,4,12.02,1.79,null,null,null,null,null,1000,10,3,12.49,1.93,null,1100,10,3,13.225000000000001,2.02,null,1200,10,3,13.96,2.11,null,1300,10,3,14.68,2.2000000000000002,null,1400,10,3,15.4,2.29,null,1500,10,3,16.11,2.37,null,1600,10,3,16.82,2.4500000000000002]
[1000,10,5,11.6,1.66,null,null,null,null,null,1000,10,4,12.02,1.79,null,1100,10,4,12.78,1.885,null,1200,10,4,13.54,1.98,null,1300,10,4,14.25,2.0649999999999999,null,1400,10,4,14.96,2.15,null,1500,10,4,15.66,2.2199999999999998,null,1600,10,4,16.36,2.29]
[1000,10,6,10.88,1.5,null,null,null,null,null,1000,10,5,11.6,1.66,null,1100,10,5,12.34,1.75,null,1200,10,5,13.08,1.84,null,1300,10,5,13.79,1.9249999999999998,null,1400,10,5,14.5,2.0099999999999998,null,1500,10,5,15.245000000000001,2.0999999999999996,null,1600,10,5,15.99,2.19]
[1000,10,7,9.4700000000000006,1.26,null,null,null,null,null,1000,10,6,10.88,1.5,null,1100,10,6,11.824999999999999,1.62,null,1200,10,6,12.77,1.74,null,1300,10,6,13.475,1.825,null,1400,10,6,14.18,1.91,null,1500,10,6,14.895,1.9950000000000001,null,1600,10,6,15.61,2.08]
[1000,10,8,9.6,1.29,null,null,null,null,null,1000,10,7,9.4700000000000006,1.26,null,1100,10,7,10.17,1.355,null,1200,10,7,10.87,1.45,null,1300,10,7,11.555,1.54,null,1400,10,7,12.24,1.63,null,1500,10,7,12.914999999999999,1.7250000000000001,null,1600,10,7,13.59,1.82]
[1000,10,9,9.82,1.35,null,null,null,null,null,1000,10,8,9.6,1.29,null,1100,10,8,10.32,1.3900000000000001,null,1200,10,8,11.04,1.49,null,1300,10,8,11.704999999999998,1.58,null,1400,10,8,12.37,1.67,null,1500,10,8,13.055,1.77,null,1600,10,8,13.74,1.87]
[1000,10,10,10.210000000000001,1.45,null,null,null,null,null,1000,10,9,9.82,1.35,null,1100,10,9,10.56,1.4550000000000001,null,1200,10,9,11.3,1.56,null,1300,10,9,12.010000000000002,1.6600000000000001,null,1400,10,9,12.72,1.76,null,1500,10,9,12.75,1.76,null,1600,10,9,12.78,1.76]
[1000,10,11,10.92,1.61,null,null,null,null,null,1000,10,10,10.210000000000001,1.45,null,1100,10,10,10.995000000000001,1.56,null,1200,10,10,11.78,1.67,null,1300,10,10,12.524999999999999,1.7799999999999998,null,1400,10,10,13.27,1.89,null,1500,10,10,14.015000000000001,2,null,1600,10,10,14.76,2.11]
[1000,10,12,11.92,1.86,null,null,null,null,null,1000,10,11,10.92,1.61,null,1100,10,11,11.055,1.63,null,1200,10,11,11.19,1.65,null,1300,10,11,12.695,1.88,null,1400,10,11,14.2,2.11,null,1500,10,11,15.01,2.23,null,1600,10,11,15.82,2.35]
[1100,10,1,{"$f":"AVERAGE(D2,D26)","v":12.77},{"$f":"AVERAGE(E2,E26)","v":1.97},null,null,null,null,null,1000,10,12,11.92,1.86,null,1100,10,12,12.875,2.0100000000000002,null,1200,10,12,13.83,2.16,null,1300,10,12,14.725,2.3050000000000002,null,1400,10,12,15.62,2.4500000000000002,null,1500,10,12,16.515000000000001,2.6,null,1600,10,12,17.41,2.75]
[1100,10,2,{"$f":"AVERAGE(D3,D27)","v":13.225},2.0999999999999996]
[1100,10,3,13.225000000000001,2.02]
[1100,10,4,12.78,1.885]
[1100,10,5,12.34,1.75]
[1100,10,6,11.824999999999999,1.62]
[1100,10,7,10.17,1.355]
[1100,10,8,10.32,1.3900000000000001]
[1100,10,9,10.56,1.4550000000000001]
[1100,10,10,10.995000000000001,1.56]
[1100,10,11,11.055,1.63]
[1100,10,12,12.875,2.0100000000000002]
[1200,10,1,13.49,2.06]
[1200,10,2,13.94,2.19]
[1200,10,3,13.96,2.11]
[1200,10,4,13.54,1.98]
[1200,10,5,13.08,1.84]
[1200,10,6,12.77,1.74]
[1200,10,7,10.87,1.45]
[1200,10,8,11.04,1.49]
[1200,10,9,11.3,1.56]
[1200,10,10,11.78,1.67]
[1200,10,11,11.19,1.65]
[1200,10,12,13.83,2.16]
[1300,10,1,{"$f":"AVERAGE(D26,D50)","v":14.185},{"$f":"AVERAGE(E26,E50)","v":2.145}]
[1300,10,2,{"$f":"AVERAGE(D27,D51)","v":14.629999999999999},2.2749999999999999]
[1300,10,3,{"$f":"AVERAGE(D28,D52)","v":14.68},2.2000000000000002]
[1300,10,4,{"$f":"AVERAGE(D29,D53)","v":14.25},2.0649999999999999]
[1300,10,5,{"$f":"AVERAGE(D30,D54)","v":13.79},1.9249999999999998]
[1300,10,6,{"$f":"AVERAGE(D31,D55)","v":13.475},1.825]
[1300,10,7,{"$f":"AVERAGE(D32,D56)","v":11.555},1.54]
[1300,10,8,{"$f":"AVERAGE(D33,D57)","v":11.704999999999998},1.58]
[1300,10,9,{"$f":"AVERAGE(D34,D58)","v":12.010000000000002},1.6600000000000001]
[1300,10,10,{"$f":"AVERAGE(D35,D59)","v":12.524999999999999},1.7799999999999998]
[1300,10,11,{"$f":"AVERAGE(D36,D60)","v":12.695},1.88]
[1300,10,12,{"$f":"AVERAGE(D37,D61)","v":14.725},2.3050000000000002]
[1400,10,1,14.88,2.23]
[1400,10,2,15.32,2.36]
[1400,10,3,15.4,2.29]
[1400,10,4,14.96,2.15]
[1400,10,5,14.5,2.0099999999999998]
[1400,10,6,14.18,1.91]
[1400,10,7,12.24,1.63]
[1400,10,8,12.37,1.67]
[1400,10,9,12.72,1.76]
[1400,10,10,13.27,1.89]
[1400,10,11,14.2,2.11]
[1400,10,12,15.62,2.4500000000000002]
[1500,10,1,{"$f":"AVERAGE(D50,D74)","v":15.559999999999999},{"$f":"AVERAGE(E50,E74)","v":2.31}]
[1500,10,2,{"$f":"AVERAGE(D51,D75)","v":15.995000000000001},2.44]
[1500,10,3,{"$f":"AVERAGE(D52,D76)","v":16.11},2.37]
[1500,10,4,{"$f":"AVERAGE(D53,D77)","v":15.66},2.2199999999999998]
[1500,10,5,{"$f":"AVERAGE(D54,D78)","v":15.245000000000001},2.0999999999999996]
[1500,10,6,{"$f":"AVERAGE(D55,D79)","v":14.895},1.9950000000000001]
[1500,10,7,{"$f":"AVERAGE(D56,D80)","v":12.914999999999999},1.7250000000000001]
[1500,10,8,{"$f":"AVERAGE(D57,D81)","v":13.055},1.77]
[1500,10,9,{"$f":"AVERAGE(D58,D82)","v":12.75},1.76]
[1500,10,10,{"$f":"AVERAGE(D59,D83)","v":14.015000000000001},2]
[1500,10,11,{"$f":"AVERAGE(D60,D84)","v":15.01},2.23]
[1500,10,12,{"$f":"AVERAGE(D61,D85)","v":16.515000000000001},2.6]
[1600,10,1,16.239999999999998,2.39]
[1600,10,2,16.670000000000002,2.52]
[1600,10,3,16.82,2.4500000000000002]
[1600,10,4,16.36,2.29]
[1600,10,5,15.99,2.19]
[1600,10,6,15.61,2.08]
[1600,10,7,13.59,1.82]
[1600,10,8,13.74,1.87]
[1600,10,9,12.78,1.76]
[1600,10,10,14.76,2.11]
[1600,10,11,15.82,2.35]
[1600,10,12,17.41,2.75]

{"sheet":"Basis for calculations","index":5,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
["Daily DMI taken from DiLorenzo et al. (2013) unpublished. FEF intake data on weaned and lactating beef cows consuming bermudagrass hay"]
["Beef cow requirements obtained from: Hersom, M. 2017. Basic Nutrient Requirements of Beef Cows. University of Florida, IFAS, Florida Coop. Ext. Serv., Animal Science Dept., EDIS Publication AN190. http://edis.ifas.ufl.edu/an190  "]