{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Individual Group Inputs","All Groups Report","Instructions"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Individual Group Inputs","index":0,"n_rows":164,"n_cols":64,"rows_kept":164,"cut":false,"hidden":false,"merged":[[81,24,81,25],[81,13,81,14],[81,2,81,3],[5,2,5,3],[5,13,5,14],[5,24,5,25],[43,2,43,3],[43,13,43,14],[43,24,43,25]]}
[]
[]
["Group 1 Data Entry",null,null,null,null,null,null,null,null,null,null,"Group 4 Data Entry",null,null,null,null,null,null,null,null,null,null,"Group 7 Data Entry"]
[null,null,null,"Daily Feed Cost Calculator",null,null,null,null,null,null,null,null,null,null,"Daily Feed Cost Calculator",null,null,null,null,null,null,null,null,null,null,"Daily Feed Cost Calculator"]
[]
[null,"                            Group",null,null,"            Number of Heifers in Group",null,null,null,null,null,null,null,"                            Group",null,null,"            Number of Heifers in Group",null,null,null,0,null,null,null,"                            Group",null,null,"            Number of Heifers in Group",null,null,null,0]
[]
[null,"Age Entering Group, Weeks",0,null,"            Age Leaving Group, Weeks",null,null,null,0,null,null,null,"Age Entering Group, Weeks",{"$f":"IF(T6=0,0,I84)","v":0},null,"            Age Leaving Group, Weeks",null,null,null,0,null,null,null,"Age Entering Group, Weeks",{"$f":"IF(AE6=0,0,T84)","v":0},null,"            Age Leaving Group, Weeks",null,null,null,0,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of animals",null,{"$f":"+I6","v":0},{"$f":"+I44","v":0},{"$f":"+I82","v":0},{"$f":"+T6","v":0},{"$f":"+T44","v":0},{"$f":"+T82","v":0},{"$f":"+AE6","v":0},{"$f":"+AE44","v":0},{"$f":"+AE82","v":0}]
[null,"Weight Entering Group",0,null,"            Weight Leaving Group",null,null,null,0,null,null,null,"Weight Entering Group",{"$f":"IF(T6=0,0,I86)","v":0},null,"            Weight Leaving Group",null,null,null,0,null,null,null,"Weight Entering Group",{"$f":"IF(AE6=0,0,T86)","v":0},null,"            Weight Leaving Group",null,null,null,0,null,null,null,null,"Grown",null,{"$f":"SUM(J15:J20)","v":0},{"$f":"SUM(J53:J58)","v":0},{"$f":"SUM(J91:J96)","v":0},{"$f":"SUM(U15:U20)","v":0},{"$f":"SUM(U53:U58)","v":0},{"$f":"SUM(U91:U96)","v":0},{"$f":"SUM(AF15:AF20)","v":0},{"$f":"SUM(AF53:AF58)","v":0},{"$f":"SUM(AF91:AF96)","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,"Purchased",null,{"$f":"SUM(J21:J27)","v":0},{"$f":"SUM(J60:J65)","v":0},{"$f":"SUM(J98:J103)","v":0},{"$f":"SUM(U21:U27)","v":0},{"$f":"SUM(U60:U65)","v":0},{"$f":"SUM(U98:U103)","v":0},{"$f":"SUM(AF21:AF27)","v":0},{"$f":"SUM(AF60:AF65)","v":0},{"$f":"SUM(AF98:AF103)","v":0}]
[null,"Feed",null,"Total Lbs. Fed","Or","Pounds per",null,"Price per",null,"Cost/Animal",null,null,"Feed",null,"Total Lbs. Fed","Or","Pounds per",null,"Price per",null,"Cost/Animal",null,null,"Feed",null,"Total Lbs. Fed","Or","Pounds per",null,"Price per",null,"Cost/Animal",null,null,null,"Weight Gain",null,{"$f":"+I31","v":0},{"$f":"+I69","v":0},{"$f":"+I107","v":0},{"$f":"+T31","v":0},{"$f":"+T69","v":0},{"$f":"+T107","v":0},{"$f":"+AE31","v":0},{"$f":"+AE69","v":0},{"$f":"+AE107","v":0},{"$f":"SUM(AL12:AT12)","v":0}]
[null,"Ingredient",null,"To group per Day",null,"Animal per Day",null,"Ton",null,"Per Day",null,null,"Ingredient",null,"To group per Day",null,"Animal per Day",null,"Ton",null,"Per Day",null,null,"Ingredient",null,"To group per Day",null,"Animal per Day",null,"Ton",null,"Per Day",null,null,null,"Number of Days in Group",null,{"$f":"+E31","v":0},{"$f":"+E69","v":0},{"$f":"+E107","v":0},{"$f":"+P31","v":0},{"$f":"+P69","v":0},{"$f":"+P107","v":0},{"$f":"+AA31","v":0},{"$f":"+AA69","v":0},{"$f":"+AA107","v":0},{"$f":"SUM(AL13:AT13)","v":0}]
["Grown Feeds",null,"% DM",null,null,null,null,null,null,null,null,"Grown Feeds",null,"% DM",null,null,null,null,null,null,null,null,"Grown Feeds",null,"% DM"]
[1,null,0,0,null,0,null,0,null,{"$f":"IF(D15=0,IF(F15=0,0,F15*(H15/2000)),(D15/$I$6)*H15/2000)","v":0},null,1,null,0,0,null,0,null,0,null,{"$f":"IF(O15=0,IF(Q15=0,0,Q15*(S15/2000)),(O15/T$6)*S15/2000)","v":0},null,1,null,0,0,null,0,null,0,null,{"$f":"IF(Z15=0,IF(AB15=0,0,AB15*(AD15/2000)),(Z15/2000)*AD15/$AE$6)","v":0},null,null,null,"Feed Dry Matters",null,{"$f":"IF(D15=0,F15*C15,D15/I$6*C15)","v":0},{"$f":"IF(D53=0,F53*C53,D53/I$44*C53)","v":0},{"$f":"IF(D91=0,F91*C91,D91/I$82*C91)","v":0},{"$f":"IF(O15=0,Q15*N15,O15/T$6*N15)","v":0},{"$f":"IF(O53=0,Q53*N53,O53/T$44*N53)","v":0},{"$f":"IF(O91=0,Q91*N91,O91/T$82*N91)","v":0},{"$f":"IF(Z15=0,AB15*Y15,Z15/AE$6*Y15)","v":0},{"$f":"IF(Z53=0,AB53*Y53,Z53/AE$44*Y53)","v":0},{"$f":"IF(Z91=0,AB91*Y91,Z91/AE$82*Y91)","v":0}]
[2,null,0,0,null,0,null,0,null,{"$f":"IF(D16=0,IF(F16=0,0,F16*(H16/2000)),(D16/$I$6)*H16/2000)","v":0},null,2,null,0,0,null,0,null,0,null,0,null,2,null,0,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[3,null,0,0,null,0,null,0,null,{"$f":"IF(D17=0,IF(F17=0,0,F17*(H17/2000)),(D17/2000)*H17/$I$6)","v":0},null,3,null,0,0,null,0,null,0,null,0,null,3,null,0,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[4,null,0,0,null,0,null,0,null,{"$f":"IF(D18=0,IF(F18=0,0,F18*(H18/2000)),(D18/$I$6)*H18/2000)","v":0},null,4,null,0,0,null,0,null,0,null,0,null,4,null,0,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[5,null,0,0,null,0,null,0,null,{"$f":"IF(D19=0,IF(F19=0,0,F19*(H19/2000)),(D19/$I$6)*H19/2000)","v":0},null,5,null,0,0,null,0,null,0,null,0,null,5,null,0,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[6,null,0,0,null,0,null,0,null,{"$f":"IF(D20=0,IF(F20=0,0,F20*(H20/2000)),(D20/$I$6)*H20/2000)","v":0},null,6,null,0,0,null,0,null,0,null,0,null,6,null,0,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
["Purchased Feeds",null,null,null,null,null,null,null,null,null,null,"Purchased Feeds",null,null,null,null,null,null,null,null,null,null,"Purchased Feeds"]
[7,null,0,0,null,0,null,0,null,{"$f":"IF(D22=0,IF(F22=0,0,F22*(H22/2000)),(D22/$I$6)*H22/2000)","v":0},null,7,null,0,0,null,0,null,0,null,{"$f":"IF(O22=0,IF(Q22=0,0,Q22*(S22/2000)),(O22/T$6)*S22/2000)","v":0},null,7,null,0,0,null,0,null,0,null,{"$f":"IF(Z22=0,IF(AB22=0,0,AB22*(AD22/2000)),(Z22/2000)*AD22/$AE$6)","v":0},null,null,null,null,null,{"$f":"IF(D22=0,F22*C22,D22/I$6*C22)","v":0},{"$f":"IF(D60=0,F60*C60,D60/I$44*C60)","v":0},{"$f":"IF(D98=0,F98*C98,D98/I$82*C98)","v":0},{"$f":"IF(O22=0,Q22*N22,O22/T$6*N22)","v":0},{"$f":"IF(O60=0,Q60*N60,O60/T$44*N60)","v":0},{"$f":"IF(O98=0,Q98*N98,O98/T$82*N98)","v":0},{"$f":"IF(Z22=0,AB22*Y22,Z22/AE$6*Y22)","v":0},{"$f":"IF(Z60=0,AB60*Y60,Z60/AE$44*Y60)","v":0},{"$f":"IF(Z98=0,AB98*Y98,Z98/AE$82*Y98)","v":0}]
[8,null,0,0,null,0,null,0,null,0,null,8,null,0,0,null,0,null,0,null,0,null,8,null,0,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[9,null,0,0,null,0,null,0,null,0,null,9,null,0,0,null,0,null,0,null,0,null,9,null,0,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,"Average Daily Feed Costs, All groups"]
[10,null,0,0,null,0,null,0,null,0,null,10,null,0,0,null,0,null,0,null,0,null,10,null,0,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Per Day per Animal",null,null,"Per Pound of Gain"]
[11,null,0,0,null,0,null,0,null,0,null,11,null,0,0,null,0,null,0,null,0,null,11,null,0,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0]
[12,null,0,0,null,0,null,0,null,0,null,12,null,0,0,null,0,null,0,null,0,null,12,null,0,0,null,0,null,0,null,0,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,"Grown Feeds",null,null,null,null,{"$f":"+((AL10*AL13)+(AM10*AM13)+(AN10*AN13)+(AO10*AO13)+(AP10*AP13)+(AQ10*AQ13)+(AR10*AR13)+(AS10*AS13)+(AT10*AT13))/AU13","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+((AL10*AL13)+(AM10*AM13)+(AN10*AN13)+(AO10*AO13)+(AP10*AP13)+(AQ10*AQ13)+(AR10*AR13)+(AS10*AS13)+(AT10*AT13))/AU12","v":{"$error":"#DIV/0!"}}]
[null,null,"As Fed Pounds per Animal per Day",null,null,null,{"$f":"IF(I6=0,0,SUM(F15:F27)+(SUM(D15:D27)/I6))","v":0},null,null,null,null,null,null,"As Fed Pounds per Animal per Day",null,null,null,{"$f":"IF(T6=0,0,SUM(Q15:Q27)+(SUM(O15:O27)/T6))","v":0},null,null,null,null,null,null,"As Fed Pounds per Animal per Day",null,null,null,{"$f":"IF(AE6=0,0,SUM(AB15:AB27)+(SUM(Z15:Z27)/AE6))","v":0},null,null,null,null,null,null,"Total dm/animal",null,{"$f":"SUM(AL15:AL27)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(AL28:AT28)","v":0}]
[null,null,"Pounds of Dry Matter per Animal per Day",null,null,null,{"$f":"SUM(AL15:AL27)","v":0},null,null,null,null,null,null,"Pounds of Dry Matter per Animal per Day",null,null,null,{"$f":"SUM(AO15:AO27)","v":0},null,null,null,null,null,null,"Pounds of Dry Matter per Animal per Day",null,null,null,{"$f":"SUM(AR15:AR27)","v":0},null,null,null,null,null,null,"Total dm while in group",null,{"$f":"+AL28*AL13","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(AL29:AT29)","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,"Lbs. Dm/Lb. of Gain",null,{"$f":"+AL29/AL12","v":{"$error":"#DIV/0!"}},{"$f":"+AM29/AM12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+AU29/AU12","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Purchased Feeds",null,null,null,null,{"$f":"+((AL11*AL13)+(AM11*AM13)+(AN11*AN13)+(AO11*AO13)+(AP11*AP13)+(AQ11*AQ13)+(AR11*AR13)+(AS11*AS13)+(AT11*AT13))/AU13","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+((AL11*AL13)+(AM11*AM13)+(AN11*AN13)+(AO11*AO13)+(AP11*AP13)+(AQ11*AQ13)+(AR11*AR13)+(AS11*AS13)+(AT11*AT13))/AU13","v":{"$error":"#DIV/0!"}}]
[null,null,"Days in Group",null,{"$f":"IF(I6=0,0,+(I8-C8)*7)","v":0},"        Weight Gained in Group",null,null,{"$f":"IF(I6=0,0,+I10-C10)","v":0},null,null,null,null,"Days in Group",null,{"$f":"IF(T6=0,0,+(T8-N8)*7)","v":0},"        Weight Gained in Group",null,null,{"$f":"IF(T6=0,0,+T10-N10)","v":0},null,null,null,null,"Days in Group",null,{"$f":"IF(AE6=0,0,+(AE8-Y8)*7)","v":0},"        Weight Gained in Group",null,null,{"$f":"IF(AE6=0,0,+AE10-Y10)","v":0},null,null,null,null,"Lbs. of Gain/Lbs. of Dry Matter",null,{"$f":"+AL12/AL29","v":{"$error":"#DIV/0!"}},{"$f":"+AM12/AM29","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+AU12/AU29","v":{"$error":"#DIV/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,null,null,null,null,null,null,null,null,null,"Total Feed Costs per Day per Animal"]
[null,null,"Average Daily Rate of Gain, Pounds",null,null,null,null,null,{"$f":"IF(E31=0,0,I31/E31)","v":0},null,null,null,null,"Average Daily Rate of Gain, Pounds",null,null,null,null,null,{"$f":"IF(P31=0,0,T31/P31)","v":0},null,null,null,null,"Average Daily Rate of Gain, Pounds",null,null,null,null,null,{"$f":"IF(AA31=0,0,AE31/AA31)","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,null,null,null,null,null,null,null,null,null,"Average Daily Rate of Gain",null,null,null,null,{"$f":"+AU12/AU13","v":{"$error":"#DIV/0!"}}]
[null,null,"Total Feed Cost per day per Animal",null,null,null,null,null,{"$f":"SUM(J15:J27)","v":0},null,null,null,null,"Total Feed Cost per day per Animal",null,null,null,null,null,{"$f":"SUM(U15:U27)","v":0},null,null,null,null,"Total Feed Cost per day per Animal",null,null,null,null,null,{"$f":"SUM(AF15:AF27)","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,null,null,null,null,null,null,null,null,null,"Total Feed Costs per Pound of Gain",null,null,null,null,null,null,null,{"$f":"+#REF!+BL30","v":{"$error":"#REF!"}}]
[null,null,"Total Feed Cost per Pound of Gain",null,null,null,null,null,{"$f":"IF(I35=0,0,I35/I33)","v":0},null,null,null,null,"Total Feed Cost per Pound of Gain",null,null,null,null,null,{"$f":"IF(T35=0,0,T35/T33)","v":0},null,null,null,null,"Total Feed Cost per Pound of Gain",null,null,null,null,null,{"$f":"IF(AE35=0,0,AE35/AE33)","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,null,null,null,null,null,null,null,null,null,"Total Feed Cost per day Per Animal"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Feed Cost per Pound of Gain"]
["Group 2 Data Entry",null,null,null,null,null,null,null,null,null,null,"Group 5 Data Entry",null,null,null,null,null,null,null,null,null,null,"Group 8 Data Entry"]
[null,null,null,"Daily Feed Cost Calculator",null,null,null,null,null,null,null,null,null,null,"Daily Feed Cost Calculator",null,null,null,null,null,null,null,null,null,null,"Daily Feed Cost Calculator"]
[]
[null,"                            Group",null,null,"            Number of Heifers in Group",null,null,null,0,null,null,null,"                            Group",null,null,"            Number of Heifers in Group",null,null,null,0,null,null,null,"                            Group",null,null,"            Number of Heifers in Group",null,null,null,0]
[]
[null,"Age Entering Group, Weeks",{"$f":"IF(I44=0,0,I8)","v":0},null,"            Age Leaving Group, Weeks",null,null,null,0,null,null,null,"Age Entering Group, Weeks",{"$f":"IF(T44=0,0,T8)","v":0},null,"            Age Leaving Group, Weeks",null,null,null,0,null,null,null,"Age Entering Group, Weeks",{"$f":"IF(AE44=0,0,AE8)","v":0},null,"            Age Leaving Group, Weeks",null,null,null,0]
[]
[null,"Weight Entering Group",{"$f":"IF(I44=0,0,+I10)","v":0},null,"            Weight Leaving Group",null,null,null,0,null,null,null,"Weight Entering Group",{"$f":"IF(T44=0,0,+T10)","v":0},null,"            Weight Leaving Group",null,null,null,0,null,null,null,"Weight Entering Group",{"$f":"IF(AE44=0,0,+AE10)","v":0},null,"            Weight Leaving Group",null,null,null,0]
[]
[null,"Feed",null,"Total Lbs. Fed","Or","Pounds per",null,"Price per",null,"Cost/Animal",null,null,"Feed",null,"Total Lbs. Fed","Or","Pounds per",null,"Price per",null,"Cost/Animal",null,null,"Feed",null,"Total Lbs. Fed","Or","Pounds per",null,"Price per",null,"Cost/Animal"]
[null,"Ingredient",null,"To group per Day",null,"Animal per Day",null,"Ton",null,"Per Day",null,null,"Ingredient",null,"To group per Day",null,"Animal per Day",null,"Ton",null,"Per Day",null,null,"Ingredient",null,"To group per Day",null,"Animal per Day",null,"Ton",null,"Per Day"]
["Grown Feeds",null,"% DM",null,null,null,null,null,null,null,null,"Grown Feeds",null,"% DM",null,null,null,null,null,null,null,null,"Grown Feeds",null,"% DM"]
[1,null,0,0,null,0,null,0,null,{"$f":"IF(D53=0,IF(F53=0,0,F53*(H53/2000)),(D53/$I$44)*H53/2000)","v":0},null,1,null,0,0,null,0,null,0,null,{"$f":"IF(O53=0,IF(Q53=0,0,Q53*(S53/2000)),(O53/T$44)*S53/2000)","v":0},null,1,null,0,0,null,0,null,0,null,{"$f":"IF(Z53=0,IF(AB53=0,0,AB53*(AD53/2000)),(Z53/2000)*AD53/$AE$44)","v":0}]
[2,null,0,0,null,0,null,0,null,0,null,2,null,0,0,null,0,null,0,null,0,null,2,null,0,0,null,0,null,0,null,0]
[3,null,0,0,null,0,null,0,null,0,null,3,null,0,0,null,0,null,0,null,0,null,3,null,0,0,null,0,null,0,null,0]
[4,null,0,0,null,0,null,0,null,0,null,4,null,0,0,null,0,null,0,null,0,null,4,null,0,0,null,0,null,0,null,0]
[5,null,0,0,null,0,null,0,null,0,null,5,null,0,0,null,0,null,0,null,0,null,5,null,0,0,null,0,null,0,null,0]
[6,null,0,0,null,0,null,0,null,0,null,6,null,0,0,null,0,null,0,null,0,null,6,null,0,0,null,0,null,0,null,0]
["Purchased Feeds",null,null,null,null,null,null,null,null,null,null,"Purchased Feeds",null,null,null,null,null,null,null,null,null,null,"Purchased Feeds"]
[7,null,0,0,null,0,null,0,null,{"$f":"IF(D60=0,IF(F60=0,0,F60*(H60/2000)),(D60/$I$44)*H60/2000)","v":0},null,7,null,0,0,null,0,null,0,null,{"$f":"IF(O60=0,IF(Q60=0,0,Q60*(S60/2000)),(O60/T$44)*S60/2000)","v":0},null,7,null,0,0,null,0,null,0,null,{"$f":"IF(Z60=0,IF(AB60=0,0,AB60*(AD60/2000)),(Z60/2000)*AD60/$AE$44)","v":0}]
[8,null,0,0,null,0,null,0,null,0,null,8,null,0,0,null,0,null,0,null,0,null,8,null,0,0,null,0,null,0,null,0]
[9,null,0,0,null,0,null,0,null,0,null,9,null,0,0,null,0,null,0,null,0,null,9,null,0,0,null,0,null,0,null,0]
[10,null,0,0,null,0,null,0,null,0,null,10,null,0,0,null,0,null,0,null,0,null,10,null,0,0,null,0,null,0,null,0]
[11,null,0,0,null,0,null,0,null,0,null,11,null,0,0,null,0,null,0,null,0,null,11,null,0,0,null,0,null,0,null,0]
[12,null,0,0,null,0,null,0,null,0,null,12,null,0,0,null,0,null,0,null,0,null,12,null,0,0,null,0,null,0,null,0]
[null,null,"As Fed Pounds per Animal per Day",null,null,null,{"$f":"IF(I44=0,0,SUM(F53:F65)+(SUM(D53:D65)/I44))","v":0},null,null,null,null,null,null,"As Fed Pounds per Animal per Day",null,null,null,{"$f":"IF(T44=0,0,SUM(Q53:Q65)+(SUM(O53:O65)/T44))","v":0},null,null,null,null,null,null,"As Fed Pounds per Animal per Day",null,null,null,{"$f":"IF(AE44=0,0,SUM(AB53:AB65)+(SUM(Z53:Z65)/AE44))","v":0}]
[null,null,"Pounds of Dry Matter per Animal per Day",null,null,null,{"$f":"SUM(AM15:AM27)","v":0},null,null,null,null,null,null,"Pounds of Dry Matter per Animal per Day",null,null,null,{"$f":"SUM(AP15:AP27)","v":0},null,null,null,null,null,null,"Pounds of Dry Matter per Animal per Day",null,null,null,{"$f":"SUM(AS15:AS27)","v":0}]
[]
[null,null,"Days in Group",null,{"$f":"IF(I44=0,0,+(I46-C46)*7)","v":0},"        Weight Gained in Group",null,null,{"$f":"IF(I44=0,0,+I48-C48)","v":0},null,null,null,null,"Days in Group",null,{"$f":"IF(T44=0,0,+(T46-N46)*7)","v":0},"        Weight Gained in Group",null,null,{"$f":"IF(T44=0,0,+T48-N48)","v":0},null,null,null,null,"Days in Group",null,{"$f":"IF(AE44=0,0,+(AE46-Y46)*7)","v":0},"        Weight Gained in Group",null,null,{"$f":"IF(AE44=0,0,+AE48-Y48)","v":0}]
[]
[null,null,"Average Daily Rate of Gain, Pounds",null,null,null,null,null,{"$f":"IF(E69=0,0,I69/E69)","v":0},null,null,null,null,"Average Daily Rate of Gain, Pounds",null,null,null,null,null,{"$f":"IF(P69=0,0,T69/P69)","v":0},null,null,null,null,"Average Daily Rate of Gain, Pounds",null,null,null,null,null,{"$f":"IF(AA69=0,0,AE69/AA69)","v":0}]
[]
[null,null,"Total Feed Cost per day per Animal",null,null,null,null,null,{"$f":"SUM(J53:J65)","v":0},null,null,null,null,"Total Feed Cost per day per Animal",null,null,null,null,null,{"$f":"SUM(U53:U65)","v":0},null,null,null,null,"Total Feed Cost per day per Animal",null,null,null,null,null,{"$f":"SUM(AF53:AF65)","v":0}]
[]
[null,null,"Total Feed Cost per Pound of Gain",null,null,null,null,null,{"$f":"IF(I73=0,0,I73/I71)","v":0},null,null,null,null,"Total Feed Cost per Pound of Gain",null,null,null,null,null,{"$f":"IF(T73=0,0,T73/T71)","v":0},null,null,null,null,"Total Feed Cost per Pound of Gain",null,null,null,null,null,{"$f":"IF(AE73=0,0,AE73/AE71)","v":0}]
[]
[]
[]
["Group 3 Data Entry",null,null,null,null,null,null,null,null,null,null,"Group 6 Data Entry",null,null,null,null,null,null,null,null,null,null,"Group 9 Data Entry"]
[null,null,null,"Daily Feed Cost Calculator",null,null,null,null,null,null,null,null,null,null,"Daily Feed Cost Calculator",null,null,null,null,null,null,null,null,null,null,"Daily Feed Cost Calculator"]
[]
[null,"                            Group",null,null,"            Number of Heifers in Group",null,null,null,0,null,null,null,"                            Group",null,null,"            Number of Heifers in Group",null,null,null,0,null,null,null,"                            Group",null,null,"            Number of Heifers in Group",null,null,null,0]
[]
[null,"Age Entering Group, Weeks",{"$f":"IF(I82=0,0,I46)","v":0},null,"            Age Leaving Group, Weeks",null,null,null,0,null,null,null,"Age Entering Group, Weeks",{"$f":"IF(T82=0,0,T46)","v":0},null,"            Age Leaving Group, Weeks",null,null,null,0,null,null,null,"Age Entering Group, Weeks",{"$f":"IF(AE82=0,0,AE46)","v":0},null,"            Age Leaving Group, Weeks",null,null,null,0]
[]
[null,"Weight Entering Group",{"$f":"IF(I82=0,0,+I48)","v":0},null,"            Weight Leaving Group",null,null,null,0,null,null,null,"Weight Entering Group",{"$f":"IF(T82=0,0,+T48)","v":0},null,"            Weight Leaving Group",null,null,null,0,null,null,null,"Weight Entering Group",{"$f":"IF(AE82=0,0,+AE48)","v":0},null,"            Weight Leaving Group",null,null,null,0]
[]
[null,"Feed",null,"Total Lbs. Fed","Or","Pounds per",null,"Price per",null,"Cost/Animal",null,null,"Feed",null,"Total Lbs. Fed","Or","Pounds per",null,"Price per",null,"Cost/Animal",null,null,"Feed",null,"Total Lbs. Fed","Or","Pounds per",null,"Price per",null,"Cost/Animal"]
[null,"Ingredient",null,"To group per Day",null,"Animal per Day",null,"Ton",null,"Per Day",null,null,"Ingredient",null,"To group per Day",null,"Animal per Day",null,"Ton",null,"Per Day",null,null,"Ingredient",null,"To group per Day",null,"Animal per Day",null,"Ton",null,"Per Day"]
["Grown Feeds",null,"% DM",null,null,null,null,null,null,null,null,"Grown Feeds",null,"% DM",null,null,null,null,null,null,null,null,"Grown Feeds",null,"% DM"]
[1,null,0,0,null,0,null,0,null,{"$f":"IF(D91=0,IF(F91=0,0,F91*(H91/2000)),(D91/I$82)*H91/2000)","v":0},null,1,null,0,0,null,0,null,0,null,{"$f":"IF(O91=0,IF(Q91=0,0,Q91*(S91/2000)),(O91/T$82)*S91/2000)","v":0},null,1,null,0,0,null,0,null,0,null,{"$f":"IF(Z91=0,IF(AB91=0,0,AB91*(AD91/2000)),(Z91/2000)*AD91/$AE$82)","v":0}]
[2,null,0,0,null,0,null,0,null,0,null,2,null,0,0,null,0,null,0,null,0,null,2,null,0,0,null,0,null,0,null,0]
[3,null,0,0,null,0,null,0,null,0,null,3,null,0,0,null,0,null,0,null,0,null,3,null,0,0,null,0,null,0,null,0]
[4,null,0,0,null,0,null,0,null,0,null,4,null,0,0,null,0,null,0,null,0,null,4,null,0,0,null,0,null,0,null,0]
[5,null,0,0,null,0,null,0,null,0,null,5,null,0,0,null,0,null,0,null,0,null,5,null,0,0,null,0,null,0,null,0]
[6,null,0,0,null,0,null,0,null,0,null,6,null,0,0,null,0,null,0,null,0,null,6,null,0,0,null,0,null,0,null,0]
["Purchased Feeds",null,null,null,null,null,null,null,null,null,null,"Purchased Feeds",null,null,null,null,null,null,null,null,null,null,"Purchased Feeds"]
[7,null,0,0,null,0,null,0,null,{"$f":"IF(D98=0,IF(F98=0,0,F98*(H98/2000)),(D98/I$82)*H98/2000)","v":0},null,7,null,0,0,null,0,null,0,null,{"$f":"IF(O98=0,IF(Q98=0,0,Q98*(S98/2000)),(O98/T$82)*S98/2000)","v":0},null,7,null,0,0,null,0,null,0,null,{"$f":"IF(Z98=0,IF(AB98=0,0,AB98*(AD98/2000)),(Z98/2000)*AD98/$AE$82)","v":0}]
[8,null,0,0,null,0,null,0,null,0,null,8,null,0,0,null,0,null,0,null,0,null,8,null,0,0,null,0,null,0,null,0]
[9,null,0,0,null,0,null,0,null,0,null,9,null,0,0,null,0,null,0,null,0,null,9,null,0,0,null,0,null,0,null,0]
[10,null,0,0,null,0,null,0,null,0,null,10,null,0,0,null,0,null,0,null,0,null,10,null,0,0,null,0,null,0,null,0]
[11,null,0,0,null,0,null,0,null,0,null,11,null,0,0,null,0,null,0,null,0,null,11,null,0,0,null,0,null,0,null,0]
[12,null,0,0,null,0,null,0,null,0,null,12,null,0,0,null,0,null,0,null,0,null,12,null,0,0,null,0,null,0,null,0]
[null,null,"As Fed Pounds per Animal per Day",null,null,null,{"$f":"IF(I82=0,0,SUM(F91:F103)+(SUM(D91:D103)/I82))","v":0},null,null,null,null,null,null,"As Fed Pounds per Animal per Day",null,null,null,{"$f":"IF(T82=0,0,SUM(Q91:Q103)+(SUM(O91:O103)/T82))","v":0},null,null,null,null,null,null,"As Fed Pounds per Animal per Day",null,null,null,{"$f":"IF(AE82=0,0,SUM(AB91:AB103)+(SUM(Z91:Z103)/AE82))","v":0}]
[null,null,"Pounds of Dry Matter per Animal per Day",null,null,null,{"$f":"SUM(AN15:AN27)","v":0},null,null,null,null,null,null,"Pounds of Dry Matter per Animal per Day",null,null,null,{"$f":"SUM(AQ15:AQ27)","v":0},null,null,null,null,null,null,"Pounds of Dry Matter per Animal per Day",null,null,null,{"$f":"SUM(AT15:AT27)","v":0}]
[]
[null,null,"Days in Group",null,{"$f":"IF(I82=0,0,+(I84-C84)*7)","v":0},"        Weight Gained in Group",null,null,{"$f":"IF(I82=0,0,+I86-C86)","v":0},null,null,null,null,"Days in Group",null,{"$f":"IF(T82=0,0,+(T84-N84)*7)","v":0},"        Weight Gained in Group",null,null,{"$f":"IF(T82=0,0,+T86-N86)","v":0},null,null,null,null,"Days in Group",null,{"$f":"IF(AE82=0,0,+(AE84-Y84)*7)","v":0},"        Weight Gained in Group",null,null,{"$f":"IF(AE82=0,0,+AE86-Y86)","v":0}]
[]
[null,null,"Average Daily Rate of Gain, Pounds",null,null,null,null,null,{"$f":"IF(E107=0,0,I107/E107)","v":0},null,null,null,null,"Average Daily Rate of Gain, Pounds",null,null,null,null,null,{"$f":"IF(P107=0,0,T107/P107)","v":0},null,null,null,null,"Average Daily Rate of Gain, Pounds",null,null,null,null,null,{"$f":"IF(AA107=0,0,AE107/AA107)","v":0}]
[]
[null,null,"Total Feed Cost per day per Animal",null,null,null,null,null,{"$f":"SUM(J91:J103)","v":0},null,null,null,null,"Total Feed Cost per day per Animal",null,null,null,null,null,{"$f":"SUM(U91:U103)","v":0},null,null,null,null,"Total Feed Cost per day per Animal",null,null,null,null,null,{"$f":"SUM(AF91:AF103)","v":0}]
[]
[null,null,"Total Feed Cost per Pound of Gain",null,null,null,null,null,{"$f":"IF(I111=0,0,I111/I109)","v":0},null,null,null,null,"Total Feed Cost per Pound of Gain",null,null,null,null,null,{"$f":"IF(T111=0,0,T111/T109)","v":0},null,null,null,null,"Total Feed Cost per Pound of Gain",null,null,null,null,null,{"$f":"IF(AE111=0,0,AE111/AE109)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daily Heifer Feed Cost Calculator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"To return to menu, click menu button or Ctrl-m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Feed Cost per",null,"As Fed Pounds ",null,"Data Entry"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Name of Group",null,"Heifer per Day",null,"Per Heifer per Day",null,"Click on Button"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Group 1",{"$f":"C6","v":0},null,{"$f":"I35","v":0},null,{"$f":"G28","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Group 2",{"$f":"C44","v":0},null,{"$f":"I73","v":0},null,{"$f":"G66","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Group 3",{"$f":"C82","v":0},null,{"$f":"I111","v":0},null,{"$f":"G104","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Group 4",{"$f":"N6","v":0},null,{"$f":"T35","v":0},null,{"$f":"R28","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Group 5",{"$f":"N44","v":0},null,{"$f":"T73","v":0},null,{"$f":"R66","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Group 6",{"$f":"N82","v":0},null,{"$f":"T111","v":0},null,{"$f":"R104","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Group 7",{"$f":"Y6","v":0},null,{"$f":"AE35","v":0},null,{"$f":"AC28","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Group 8",{"$f":"Y44","v":0},null,{"$f":"AE73","v":0},null,{"$f":"AC66","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Group 9",{"$f":"Y82","v":0},null,{"$f":"AE111","v":0},null,{"$f":"AC104","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"By Jason Karszes"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Farm Management Specialist"]
[null,null,null,null,null,null,null,null,null,null,null,null,"PRO-DAIRY"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Department of Animal Science"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cornell University"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Program Date",null,"2021-04-24"]

{"sheet":"All Groups Report","index":1,"n_rows":52,"n_cols":19,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null," ","               Feed Cost Report, All Groups"]
[]
[]
[null,null,null,"    Per Day per Animal",null,null,"Daily  ","DMI","Feed",null,"           Total Cost"]
[null,null,null,"Grown ","Purchased","Days in","Weight","Per","Conversion",null,"Per Day ","Per Pound","Number of",null,null,null,null,"Totals","Purchased"]
[null,null,null,"Feed","Feed","Group","Gain","Animal","Ratio",null,"Per Animal","Of Gain","Animals",null,null,null,null,"Grown","Purchased"]
[]
[null,{"$f":"+'Individual Group Inputs'!C6","v":0},null,{"$f":"+'Individual Group Inputs'!AL10","v":0},{"$f":"+'Individual Group Inputs'!AL11","v":0},{"$f":"+'Individual Group Inputs'!AL13","v":0},{"$f":"IF('Individual Group Inputs'!AL13=0,0,+'Individual Group Inputs'!AL12/'Individual Group Inputs'!AL13)","v":0},{"$f":"+'Individual Group Inputs'!G29","v":0},{"$f":"IF(F13=0,0,'Individual Group Inputs'!AL31)","v":0},null,{"$f":"+D13+E13","v":0},{"$f":"IF(K13=0,0,+K13/G13)","v":0},{"$f":"+'Individual Group Inputs'!AL9","v":0},null,null,null,null,{"$f":"+D13*F13","v":0},{"$f":"+E13*F13","v":0}]
[]
[null,{"$f":"+'Individual Group Inputs'!C44","v":0},null,{"$f":"+'Individual Group Inputs'!AM10","v":0},{"$f":"+'Individual Group Inputs'!AM11","v":0},{"$f":"+'Individual Group Inputs'!AM13","v":0},{"$f":"IF('Individual Group Inputs'!AM13=0,0,+'Individual Group Inputs'!AM12/'Individual Group Inputs'!AM13)","v":0},{"$f":"+'Individual Group Inputs'!G67","v":0},{"$f":"IF(F15=0,0,'Individual Group Inputs'!AM31)","v":0},null,{"$f":"+D15+E15","v":0},{"$f":"IF(K15=0,0,+K15/G15)","v":0},{"$f":"+'Individual Group Inputs'!AM9","v":0},null,null,null,null,{"$f":"+D15*F15","v":0},{"$f":"+E15*F15","v":0}]
[]
[null,{"$f":"+'Individual Group Inputs'!C82","v":0},null,{"$f":"+'Individual Group Inputs'!AN10","v":0},{"$f":"+'Individual Group Inputs'!AN11","v":0},{"$f":"+'Individual Group Inputs'!AN13","v":0},{"$f":"IF('Individual Group Inputs'!AN13=0,0,+'Individual Group Inputs'!AN12/'Individual Group Inputs'!AN13)","v":0},{"$f":"+'Individual Group Inputs'!G105","v":0},{"$f":"IF(F17=0,0,'Individual Group Inputs'!AN31)","v":0},null,{"$f":"+D17+E17","v":0},{"$f":"IF(K17=0,0,K17/G17)","v":0},{"$f":"+'Individual Group Inputs'!AN9","v":0},null,null,null,null,{"$f":"+D17*F17","v":0},{"$f":"+E17*F17","v":0}]
[]
[null,{"$f":"+'Individual Group Inputs'!N6","v":0},null,{"$f":"+'Individual Group Inputs'!AO10","v":0},{"$f":"+'Individual Group Inputs'!AO11","v":0},{"$f":"+'Individual Group Inputs'!AO13","v":0},{"$f":"IF('Individual Group Inputs'!AO13=0,0,+'Individual Group Inputs'!AO12/'Individual Group Inputs'!AO13)","v":0},{"$f":"+'Individual Group Inputs'!R29","v":0},{"$f":"IF(F19=0,0,'Individual Group Inputs'!AO31)","v":0},null,{"$f":"+D19+E19","v":0},{"$f":"IF(K19=0,0,K19/G19)","v":0},{"$f":"+'Individual Group Inputs'!AO9","v":0},null,null,null,null,{"$f":"+D19*F19","v":0},{"$f":"+E19*F19","v":0}]
[]
[null,{"$f":"+'Individual Group Inputs'!N44","v":0},null,{"$f":"+'Individual Group Inputs'!AP10","v":0},{"$f":"+'Individual Group Inputs'!AP11","v":0},{"$f":"+'Individual Group Inputs'!AP13","v":0},{"$f":"IF('Individual Group Inputs'!AP13=0,0,'Individual Group Inputs'!AP12/'Individual Group Inputs'!AP13)","v":0},{"$f":"+'Individual Group Inputs'!R67","v":0},{"$f":"IF(F21=0,0,'Individual Group Inputs'!AP31)","v":0},null,{"$f":"+D21+E21","v":0},{"$f":"IF(K21=0,0,K21/G21)","v":0},{"$f":"+'Individual Group Inputs'!AP9","v":0},null,null,null,null,{"$f":"+D21*F21","v":0},{"$f":"+E21*F21","v":0}]
[]
[null,{"$f":"+'Individual Group Inputs'!N82","v":0},null,{"$f":"+'Individual Group Inputs'!AQ10","v":0},{"$f":"+'Individual Group Inputs'!AQ11","v":0},{"$f":"+'Individual Group Inputs'!AQ13","v":0},{"$f":"IF('Individual Group Inputs'!AQ13=0,0,'Individual Group Inputs'!AQ12/'Individual Group Inputs'!AQ13)","v":0},{"$f":"+'Individual Group Inputs'!R105","v":0},{"$f":"IF(F23=0,0,'Individual Group Inputs'!AQ31)","v":0},null,{"$f":"+D23+E23","v":0},{"$f":"IF(K23=0,0,K23/G23)","v":0},{"$f":"+'Individual Group Inputs'!AQ9","v":0},null,null,null,null,{"$f":"+D23*F23","v":0},{"$f":"+E23*F23","v":0}]
[]
[null,{"$f":"+'Individual Group Inputs'!Y6","v":0},null,{"$f":"+'Individual Group Inputs'!AR10","v":0},{"$f":"+'Individual Group Inputs'!AR11","v":0},{"$f":"+'Individual Group Inputs'!AR13","v":0},{"$f":"IF('Individual Group Inputs'!AR13=0,0,'Individual Group Inputs'!AR12/'Individual Group Inputs'!AR13)","v":0},{"$f":"+'Individual Group Inputs'!AC29","v":0},{"$f":"IF(F25=0,0,'Individual Group Inputs'!AR31)","v":0},null,{"$f":"+D25+E25","v":0},{"$f":"IF(K25=0,0,K25/G25)","v":0},{"$f":"+'Individual Group Inputs'!AR9","v":0},null,null,null,null,{"$f":"+D25*F25","v":0},{"$f":"+E25*F25","v":0}]
[]
[null,{"$f":"+'Individual Group Inputs'!Y44","v":0},null,{"$f":"+'Individual Group Inputs'!AS10","v":0},{"$f":"+'Individual Group Inputs'!AS11","v":0},{"$f":"+'Individual Group Inputs'!AS13","v":0},{"$f":"IF('Individual Group Inputs'!AS13=0,0,'Individual Group Inputs'!AS12/'Individual Group Inputs'!AS13)","v":0},{"$f":"+'Individual Group Inputs'!AC67","v":0},{"$f":"IF(F27=0,0,'Individual Group Inputs'!AS31)","v":0},null,{"$f":"+D27+E27","v":0},{"$f":"IF(K27=0,0,K27/G27)","v":0},{"$f":"+'Individual Group Inputs'!AS9","v":0},null,null,null,null,{"$f":"+D27*F27","v":0},{"$f":"+E27*F27","v":0}]
[]
[null,{"$f":"+'Individual Group Inputs'!Y82","v":0},null,{"$f":"+'Individual Group Inputs'!AT10","v":0},{"$f":"+'Individual Group Inputs'!AT11","v":0},{"$f":"+'Individual Group Inputs'!AT13","v":0},{"$f":"IF('Individual Group Inputs'!AT13=0,0,'Individual Group Inputs'!AT12/'Individual Group Inputs'!AT13)","v":0},{"$f":"+'Individual Group Inputs'!AC105","v":0},{"$f":"IF(F29=0,0,'Individual Group Inputs'!AT31)","v":0},null,{"$f":"+D29+E29","v":0},{"$f":"IF(K29=0,0,K29/G29)","v":0},{"$f":"+'Individual Group Inputs'!AT9","v":0},null,null,null,null,{"$f":"+D29*F29","v":0},{"$f":"+E29*F29","v":0}]
[]
[]
[null,null,"Daily Weight of Gain, All Groups",null,null,null,null,null,null,null,{"$f":"IF(K42=0,0,+'Individual Group Inputs'!AU12/'Individual Group Inputs'!AU13)","v":0}]
[]
[null,null,"Feed Conversion Ratio( Lbs. Gained per Dry Matter Lb.) , All Groups",null,null,null,null,null,null,null,{"$f":"IF(K32=0,0,'Individual Group Inputs'!AU31)","v":0}]
[]
[null,null,"Average Dry Matter Intake per Animal",null,null,null,null,null,null,null,{"$f":"IF(K42=0,0,+K32/K34)","v":0}]
[]
[null,null,"Feed Cost per Day per Animal, All Groups",null,null,null,null,null,null,null,{"$f":"+IF(K42=0,0,((F13*K13)+(F15*K15)+(F17*K17)+(F19*K19)+(F21*K21)+(F23*K23)+(F25*K25)+(F27*K27)+(F29*K29))/'Individual Group Inputs'!AU13)","v":0}]
[]
[null,null,"Feed Cost per Pound of Gain, All Groups",null,null,null,null,null,null,null,{"$f":"IF(K42=0,0,+K38*'Individual Group Inputs'!AU13/'Individual Group Inputs'!AU12)","v":0}]
[]
[null,null,"Total Days Analyzed",null,null,null,null,null,null,null,{"$f":"SUM(F13:F29)","v":0}]
[]
[null,null,"Total Feed Costs Per Animal Completing System",null,null,null,null,null,"Per Day",null,{"$f":"+K42*K38","v":0}]
[null,null,null,"Grown Feeds",null,{"$f":"IF(K42=0,0,SUM(R13:R29)/K44)","v":0},{"$f":"SUM(R13:R29)","v":0},null,{"$f":"+K38*F45","v":0}]
[null,null,null,"Purchased Feeds",null,{"$f":"IF(K42=0,0,SUM(S13:S29)/K44)","v":0},{"$f":"SUM(S13:S29)","v":0},null,{"$f":"K38*F46","v":0}]
[]
[null,null,"Number of Heifers In System",null,null,null,null,null,null,null,{"$f":"SUM(M13:M29)","v":0}]
[]
[null,null,"Weight Gained in System, Pounds",null,null,null,null,null,null,null,{"$f":"+'Individual Group Inputs'!AU12","v":0}]
[]
[null,null,"Weight Leaving System, Pounds",null,null,null,null,null,null,null,{"$f":"+K50+'Individual Group Inputs'!C10","v":0}]

{"sheet":"Instructions","index":2,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"To Return to the Input Menu, Click on Button or hit CTRL-M at any time"]