{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Config","Lamb Data","Ewe Data","Ram Data","Summary","Tables","Lamb Recording Sheet","User Guide"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":42,"comments":0,"pivot_tables":4},"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":"Config","index":0,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[[4,1,4,4],[5,1,5,4]]}
["MSU Extension Service Lamb Records"]
["Configuration Sheet"]
[]
[]
["Farm Name:"]
["Owner:"]
["Lamb Year:"]

{"sheet":"Lamb Data","index":1,"n_rows":209,"n_cols":18,"rows_kept":209,"cut":false,"hidden":false,"merged":[[4,0,4,1],[4,2,4,5],[5,0,5,1],[1,12,1,17],[2,16,2,17],[2,12,2,13],[2,14,2,15],[3,0,3,1],[3,2,3,5]]}
[{"$f":"Config!A1","v":"MSU Extension Service Lamb Records"}]
["Lamb Data Sheet",null,null,null,null,null,null,null,null,null,null,null,"Age Group Data"]
[null,null,null,null,null,null,null,null,null,null,null,null,"60 Day",null,"90 Day",null,"120 Day"]
["Farm Name:",null,{"$f":"IF(Farm_Name=\"\",\"\",Farm_Name)","v":""},null,null,null,null,null,null,null,null,null,"N","Ave Adj WW","N","Ave Adj WW","N","Ave Adj WW"]
["Owner:",null,{"$f":"IF(Farm_Owner=\"\",\"\",Farm_Owner)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Lamb_Count=0,\"\",DCOUNT(Lamb_Data_Table_2,12,Age_Group_60_Criteria))","v":""},{"$f":"IF(Lamb_Count=0,\"\",DAVERAGE(Lamb_Data_Table_2,17,Age_Group_60_Criteria))","v":""},{"$f":"IF(Lamb_Count=0,\"\",DCOUNT(Lamb_Data_Table_2,12,Age_Group_90_Criteria))","v":""},{"$f":"IF(Lamb_Count=0,\"\",DAVERAGE(Lamb_Data_Table_2,17,Age_Group_90_Criteria))","v":""},{"$f":"IF(Lamb_Count=0,\"\",DCOUNT(Lamb_Data_Table_2,12,Age_Group_120_Criteria))","v":""},{"$f":"IF(Lamb_Count=0,\"\",DAVERAGE(Lamb_Data_Table_2,17,Age_Group_120_Criteria))","v":""}]
["Lamb Year:",null,{"$f":"IF(Lamb_Year=\"\",\"\",Lamb_Year)","v":""},null,null,null,null,null,null,null,"Ave.","Ave.",null,"Ave.","Ave.","Ave.","Ave.","Ave."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Lamb_Count=0,\"\",AVERAGE(K10:K209))","v":""},{"$f":"IF(Lamb_Count=0,\"\",AVERAGE(L10:L209))","v":""},null,{"$f":"IF(Lamb_Count=0,\"\",AVERAGE(N10:N209))","v":""},{"$f":"IF(Lamb_Count=0,\"\",AVERAGE(O10:O209))","v":""},{"$f":"IF(Lamb_Count=0,\"\",AVERAGE(P10:P209))","v":""},{"$f":"IF(Lamb_Count=0,\"\",AVERAGE(Q10:Q209))","v":""},{"$f":"IF(Lamb_Count=0,\"\",AVERAGE(R10:R209))","v":""}]
[]
["#","Lamb ID","Ewe ID","Ewe Age","Ram ID","Lamb Birth Date","Lamb Sex","Birth/\nRrng Type","Birth Wt","Weaning Date","Wng Wt (WW)","Wng Age (Days)","Wng Age Group","WDA","ADG","Age Corr WW","Adj WW","Adj WW Ratio"]
[1,null,null,{"$f":"IF(C10=\"\",\"\",VLOOKUP(F10-VLOOKUP(C10,Ewe_Data_Table,3,FALSE),Age_Of_Dam_Table,2))","v":""},null,null,null,null,null,null,null,{"$f":"IF(OR(F10=\"\",J10=\"\"),\"\",J10-F10)","v":""},{"$f":"IF(L10=\"\",\"\",VLOOKUP(L10,Age_Group_Table,2))","v":""},{"$f":"IF(K10=\"\",\"\",K10/L10)","v":""},{"$f":"IF(OR(I10=\"\",K10=\"\",L10=\"\"),\"\",(K10-I10)/L10)","v":""},{"$f":"IF(K10=\"\",\"\",IF(I10=\"\",N10*M10,O10*M10+I10))","v":""},{"$f":"IF(P10=\"\",\"\",CHOOSE(G10,VLOOKUP(D10,Ewe_Lamb_Adj_Factors_Table,H10+1)*P10,VLOOKUP(D10,Ram_Lamb_Adj_Factors_Table,H10+1)*P10,VLOOKUP(D10,Wether_Lamb_Adj_Factors_Table,H10+1)*P10))","v":""},{"$f":"IF(K10=\"\",\"\",IF(M10=60,Q10/Age_Group_60_Ave_Adj_WW*100,IF(M10=90,Q10/Age_Group_90_Ave_Adj_WW*100,Q10/Age_Group_120_Ave_Adj_WW*100)))","v":""}]
[2,null,null,"",null,null,null,null,null,null,null,"","","","","","",{"$f":"IF(K11=\"\",\"\",IF(M11=60,Q11/Age_Group_60_Ave_Adj_WW*100,Q11/Age_Group_90_Ave_Adj_WW*100))","v":""}]
[3,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[4,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[5,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[6,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[7,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[8,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[9,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[10,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[11,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[12,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[13,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[14,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[15,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[16,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[17,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[18,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[19,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[20,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[21,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[22,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[23,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[24,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[25,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[26,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[27,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[28,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[29,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[30,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[31,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[32,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[33,null,null,{"$f":"IF(C42=\"\",\"\",VLOOKUP(F42-VLOOKUP(C42,Ewe_Data_Table,3,FALSE),Age_Of_Dam_Table,2))","v":""},null,null,null,null,null,null,null,{"$f":"IF(OR(F42=\"\",J42=\"\"),\"\",J42-F42)","v":""},{"$f":"IF(L42=\"\",\"\",VLOOKUP(L42,Age_Group_Table,2))","v":""},{"$f":"IF(K42=\"\",\"\",K42/L42)","v":""},{"$f":"IF(OR(I42=\"\",K42=\"\",L42=\"\"),\"\",(K42-I42)/L42)","v":""},{"$f":"IF(K42=\"\",\"\",IF(I42=\"\",N42*M42,O42*M42+I42))","v":""},{"$f":"IF(P42=\"\",\"\",CHOOSE(G42,VLOOKUP(D42,Ewe_Lamb_Adj_Factors_Table,H42+1)*P42,VLOOKUP(D42,Ram_Lamb_Adj_Factors_Table,H42+1)*P42,VLOOKUP(D42,Wether_Lamb_Adj_Factors_Table,H42+1)*P42))","v":""},""]
[34,null,null,"",null,null,null,null,null,null,null,"","","","","","",{"$f":"IF(K43=\"\",\"\",IF(M43=60,Q43/Age_Group_60_Ave_Adj_WW*100,Q43/Age_Group_90_Ave_Adj_WW*100))","v":""}]
[35,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[36,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[37,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[38,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[39,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[40,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[41,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[42,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[43,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[44,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[45,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[46,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[47,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[48,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[49,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[50,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[51,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[52,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[53,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[54,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[55,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[56,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[57,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[58,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[59,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[60,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[61,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[62,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[63,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[64,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[65,null,null,{"$f":"IF(C74=\"\",\"\",VLOOKUP(F74-VLOOKUP(C74,Ewe_Data_Table,3,FALSE),Age_Of_Dam_Table,2))","v":""},null,null,null,null,null,null,null,{"$f":"IF(OR(F74=\"\",J74=\"\"),\"\",J74-F74)","v":""},{"$f":"IF(L74=\"\",\"\",VLOOKUP(L74,Age_Group_Table,2))","v":""},{"$f":"IF(K74=\"\",\"\",K74/L74)","v":""},{"$f":"IF(OR(I74=\"\",K74=\"\",L74=\"\"),\"\",(K74-I74)/L74)","v":""},{"$f":"IF(K74=\"\",\"\",IF(I74=\"\",N74*M74,O74*M74+I74))","v":""},{"$f":"IF(P74=\"\",\"\",CHOOSE(G74,VLOOKUP(D74,Ewe_Lamb_Adj_Factors_Table,H74+1)*P74,VLOOKUP(D74,Ram_Lamb_Adj_Factors_Table,H74+1)*P74,VLOOKUP(D74,Wether_Lamb_Adj_Factors_Table,H74+1)*P74))","v":""},""]
[66,null,null,"",null,null,null,null,null,null,null,"","","","","","",{"$f":"IF(K75=\"\",\"\",IF(M75=60,Q75/Age_Group_60_Ave_Adj_WW*100,Q75/Age_Group_90_Ave_Adj_WW*100))","v":""}]
[67,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[68,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[69,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[70,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[71,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[72,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[73,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[74,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[75,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[76,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[77,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[78,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[79,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[80,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[81,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[82,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[83,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[84,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[85,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[86,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[87,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[88,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[89,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[90,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[91,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[92,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[93,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[94,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[95,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[96,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[97,null,null,{"$f":"IF(C106=\"\",\"\",VLOOKUP(F106-VLOOKUP(C106,Ewe_Data_Table,3,FALSE),Age_Of_Dam_Table,2))","v":""},null,null,null,null,null,null,null,{"$f":"IF(OR(F106=\"\",J106=\"\"),\"\",J106-F106)","v":""},{"$f":"IF(L106=\"\",\"\",VLOOKUP(L106,Age_Group_Table,2))","v":""},{"$f":"IF(K106=\"\",\"\",K106/L106)","v":""},{"$f":"IF(OR(I106=\"\",K106=\"\",L106=\"\"),\"\",(K106-I106)/L106)","v":""},{"$f":"IF(K106=\"\",\"\",IF(I106=\"\",N106*M106,O106*M106+I106))","v":""},{"$f":"IF(P106=\"\",\"\",CHOOSE(G106,VLOOKUP(D106,Ewe_Lamb_Adj_Factors_Table,H106+1)*P106,VLOOKUP(D106,Ram_Lamb_Adj_Factors_Table,H106+1)*P106,VLOOKUP(D106,Wether_Lamb_Adj_Factors_Table,H106+1)*P106))","v":""},""]
[98,null,null,"",null,null,null,null,null,null,null,"","","","","","",{"$f":"IF(K107=\"\",\"\",IF(M107=60,Q107/Age_Group_60_Ave_Adj_WW*100,Q107/Age_Group_90_Ave_Adj_WW*100))","v":""}]
[99,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[100,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[101,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[102,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[103,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[104,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[105,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[106,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[107,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[108,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[109,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[110,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[111,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[112,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[113,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[114,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[115,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[116,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[117,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[118,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[119,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[120,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[121,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[122,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[123,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[124,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[125,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[126,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[127,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[128,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[129,null,null,{"$f":"IF(C138=\"\",\"\",VLOOKUP(F138-VLOOKUP(C138,Ewe_Data_Table,3,FALSE),Age_Of_Dam_Table,2))","v":""},null,null,null,null,null,null,null,{"$f":"IF(OR(F138=\"\",J138=\"\"),\"\",J138-F138)","v":""},{"$f":"IF(L138=\"\",\"\",VLOOKUP(L138,Age_Group_Table,2))","v":""},{"$f":"IF(K138=\"\",\"\",K138/L138)","v":""},{"$f":"IF(OR(I138=\"\",K138=\"\",L138=\"\"),\"\",(K138-I138)/L138)","v":""},{"$f":"IF(K138=\"\",\"\",IF(I138=\"\",N138*M138,O138*M138+I138))","v":""},{"$f":"IF(P138=\"\",\"\",CHOOSE(G138,VLOOKUP(D138,Ewe_Lamb_Adj_Factors_Table,H138+1)*P138,VLOOKUP(D138,Ram_Lamb_Adj_Factors_Table,H138+1)*P138,VLOOKUP(D138,Wether_Lamb_Adj_Factors_Table,H138+1)*P138))","v":""},""]
[130,null,null,"",null,null,null,null,null,null,null,"","","","","","",{"$f":"IF(K139=\"\",\"\",IF(M139=60,Q139/Age_Group_60_Ave_Adj_WW*100,Q139/Age_Group_90_Ave_Adj_WW*100))","v":""}]
[131,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[132,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[133,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[134,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[135,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[136,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[137,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[138,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[139,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[140,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[141,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[142,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[143,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[144,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[145,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[146,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[147,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[148,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[149,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[150,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[151,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[152,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[153,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[154,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[155,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[156,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[157,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[158,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[159,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[160,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[161,null,null,{"$f":"IF(C170=\"\",\"\",VLOOKUP(F170-VLOOKUP(C170,Ewe_Data_Table,3,FALSE),Age_Of_Dam_Table,2))","v":""},null,null,null,null,null,null,null,{"$f":"IF(OR(F170=\"\",J170=\"\"),\"\",J170-F170)","v":""},{"$f":"IF(L170=\"\",\"\",VLOOKUP(L170,Age_Group_Table,2))","v":""},{"$f":"IF(K170=\"\",\"\",K170/L170)","v":""},{"$f":"IF(OR(I170=\"\",K170=\"\",L170=\"\"),\"\",(K170-I170)/L170)","v":""},{"$f":"IF(K170=\"\",\"\",IF(I170=\"\",N170*M170,O170*M170+I170))","v":""},{"$f":"IF(P170=\"\",\"\",CHOOSE(G170,VLOOKUP(D170,Ewe_Lamb_Adj_Factors_Table,H170+1)*P170,VLOOKUP(D170,Ram_Lamb_Adj_Factors_Table,H170+1)*P170,VLOOKUP(D170,Wether_Lamb_Adj_Factors_Table,H170+1)*P170))","v":""},""]
[162,null,null,"",null,null,null,null,null,null,null,"","","","","","",{"$f":"IF(K171=\"\",\"\",IF(M171=60,Q171/Age_Group_60_Ave_Adj_WW*100,Q171/Age_Group_90_Ave_Adj_WW*100))","v":""}]
[163,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[164,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[165,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[166,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[167,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[168,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[169,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[170,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[171,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[172,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[173,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[174,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[175,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[176,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[177,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[178,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[179,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[180,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[181,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[182,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[183,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[184,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[185,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[186,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[187,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[188,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[189,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[190,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[191,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[192,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[193,null,null,{"$f":"IF(C202=\"\",\"\",VLOOKUP(F202-VLOOKUP(C202,Ewe_Data_Table,3,FALSE),Age_Of_Dam_Table,2))","v":""},null,null,null,null,null,null,null,{"$f":"IF(OR(F202=\"\",J202=\"\"),\"\",J202-F202)","v":""},{"$f":"IF(L202=\"\",\"\",VLOOKUP(L202,Age_Group_Table,2))","v":""},{"$f":"IF(K202=\"\",\"\",K202/L202)","v":""},{"$f":"IF(OR(I202=\"\",K202=\"\",L202=\"\"),\"\",(K202-I202)/L202)","v":""},{"$f":"IF(K202=\"\",\"\",IF(I202=\"\",N202*M202,O202*M202+I202))","v":""},{"$f":"IF(P202=\"\",\"\",CHOOSE(G202,VLOOKUP(D202,Ewe_Lamb_Adj_Factors_Table,H202+1)*P202,VLOOKUP(D202,Ram_Lamb_Adj_Factors_Table,H202+1)*P202,VLOOKUP(D202,Wether_Lamb_Adj_Factors_Table,H202+1)*P202))","v":""},""]
[194,null,null,"",null,null,null,null,null,null,null,"","","","","","",{"$f":"IF(K203=\"\",\"\",IF(M203=60,Q203/Age_Group_60_Ave_Adj_WW*100,Q203/Age_Group_90_Ave_Adj_WW*100))","v":""}]
[195,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[196,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[197,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[198,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[199,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]
[200,null,null,"",null,null,null,null,null,null,null,"","","","","","",""]

{"sheet":"Ewe Data","index":2,"n_rows":106,"n_cols":7,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Config!A1","v":"MSU Extension Service Lamb Records"}]
["Ewe Data Sheet"]
[null,null,null,null,null,null,"# Ewes"]
[null,null,null,null,null,null,{"$f":"IF(Ewe_Count=0,\"\",Ewe_Count)","v":""}]
[]
["#","Ewe ID","Ewe Name","Birth Date","Breed","Dam ID","Sire ID"]
[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]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]

{"sheet":"Ram Data","index":3,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Config!A1","v":"MSU Extension Service Lamb Records"}]
["Ram Data Sheet"]
[null,null,null,null,null,null,"# Rams"]
[null,null,null,null,null,null,{"$f":"IF(Ram_Count=0,\"\",Ram_Count)","v":""}]
[]
["#","Ram ID","Ram Name","Birth Date","Breed","Dam ID","Sire ID"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]

{"sheet":"Summary","index":4,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[26,0,26,7]]}
[{"$f":"Config!A1","v":"MSU Extension Service Lamb Records"}]
["Summary Sheet"]
[]
["Summary by Age Group (60 Day, 90 Day, 120 Day)"]
[]
[]
[null,"Data"]
["Wng Age Group","N","Ave Wng Age","Ave WW","Ave ADG","Ave WDA","Ave Age Corr WW","Ave Adj WW","Ave Adj WW Ratio"]
[60,18,60.444444444444443,52.777777777777779,0.7230836556680944,0.89670907597092786,53.55168600675232,62.855144621154373,117.37285846281104]
[90,20,92.3,55,0.49067704769935272,0.60165142673332328,54.310934292941738,63.422991080211844,116.77757325646728]
[120,12,113.83333333333333,48.333333333333336,0.34317410357312533,0.42686857537071426,50.680892428775046,58.803654073574741,108.83426638821722]
["Grand Total",50,86,52.6,0.53894271997780496,0.66592429613183468,53.166394862513535,62.109925473358246,115.08548228237096]
[]
[]
["Summary by Sex of Lamb (1=Ewe, 2=Ram, 3=Wether)"]
[]
[]
[null,"Data"]
["Lamb Sex","N","Ave ADG","Ave WDA","Ave WW","Ave Age Corr WW","Ave Adj WW","Ave Adj WW Ratio"]
[1,17,0.53952931079647415,0.66646829466505841,52.941176470588232,53.946692561139145,65.95420011870624,122.48559754033174]
[2,17,0.48527784086731751,0.59908178651905453,52.647058823529413,51.977400602894306,57.119724137701311,105.52885146230126]
[3,16,0.59533840128786242,0.73636646415386409,52.1875,53.60063495856928,63.327472581811506,117.37678006711188]
["Grand Total",50,0.53894271997780518,0.66592429613183513,52.6,53.166394862513556,62.109925473358217,115.08548228237099]
[]
[]
["Summary by Birth/Rearing Type"]
["(1=Single, 2=Single Raised as Twin, 3=Twin Raised as Single, \n4=Twin Raised as Twin, 5=Triplet Raised as Single, 6=Triplet Raised as Twin, 7=Triplet Raised as Triplet)"]
[]
[]
[null,"Data"]
["Birth/\nRrng Type","N","Ave WW","Ave ADG","Ave WDA","Ave Age Corr WW","Ave Adj WW","Ave Adj WW Ratio"]
[1,8,48.75,0.52724450509470833,0.66084508967031819,48.628878565909673,47.617044049494403,88.327921873357496]
[2,7,55.714285714285715,0.5942846907694711,0.72741480818270865,55.667045971438903,63.574817176366814,117.75443256028991]
[3,7,54.285714285714285,0.57025113174151187,0.70890689924754435,57.175961411949892,62.042013916467397,114.91701650377628]
[4,7,50.714285714285715,0.4674505230027014,0.58119915242419007,53.378860660066586,63.454981969528362,118.04160541943513]
[5,7,51.428571428571431,0.48698902588784143,0.61030904933709906,53.795732305847089,63.427754562150611,117.0445940057016]
[6,7,55,0.56479381478972546,0.68310679200695079,52.734099889599499,67.413880539547193,124.87353957743883]
[7,7,52.857142857142854,0.56325652211340449,0.69041388297710715,51.432401846583737,69.309397731933529,128.46177466645688]
["Grand Total",50,52.6,0.53894271997780496,0.66592429613183479,53.166394862513556,62.109925473358246,115.08548228237096]
[]
[]
["Summary by Ram ID"]
[null,"Data"]
["Ram ID","N","Ave ADG","Ave WDA","Ave Age Corr WW","Ave WW","Ave Adj WW","Ave Adj WW Ratio"]
[201,10,0.51544350723967369,0.62980553210993107,52.526851817823776,53,62.979223842987743,117.16261608745387]
[202,10,0.4588121785388618,0.57378385906419149,49.963149544433392,51,58.735254063102957,108.44983162095696]
[203,10,0.4982328898376765,0.62754968618705509,50.865199033584801,51,60.117315928242434,111.19335449217847]
[204,10,0.58317503654221337,0.71824182359952782,54.237966421169652,52,62.88504299204353,116.57581342539359]
[205,10,0.63904998773060018,0.78024057969846916,58.238807495556117,56,65.832790540414592,122.04579578587213]
["Grand Total",50,0.53894271997780496,0.66592429613183501,53.166394862513542,52.6,62.109925473358231,115.08548228237099]

{"sheet":"Tables","index":5,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[30,1,30,7],[29,0,29,7],[22,1,22,7],[21,0,21,7],[5,12,5,14],[5,3,5,4],[5,0,5,1],[14,1,14,7],[13,0,13,7],[5,8,5,10]]}
[{"$f":"Config!A1","v":"MSU Extension Service Lamb Records"}]
["Lookup and Criteria Tables Sheet"]
["(Please DO NOT EDIT ANY VALUES on this sheet!)"]
[]
[]
["Lamb Age Group Table",null,null,"Age of Dam Table",null,null,null,null,"Age Group Criteria",null,null,null,"N"]
["Lamb Age","Age Group",null,"Age in Days","Age in Years",null,null,null,"Wng Age Group","Wng Age Group","Wng Age Group",null,"Lambs","Ewes","Rams"]
[0,60,null,0,1,null,null,null,60,90,120,null,{"$f":"COUNTA('Lamb Data'!B10:B209)","v":0},{"$f":"COUNTA('Ewe Data'!B7:B106)","v":0},{"$f":"COUNTA('Ram Data'!B7:B26)","v":0}]
[76,90,null,731,2]
[106,120,null,1096,3]
[null,null,null,2556,7]
[]
[]
["Ewe Lamb Adjustment Factors Table",null,null,null,null,null,null,null,null,"Source for Adjustment Factors Tables:"]
[null,"Type of Birth/Rearing",null,null,null,null,null,null,null,"http://www.sheep101.info/201/adjweanwts.html"]
["Age of Dam","1,1","1,2","2,1","2,2","3,1","3,2","3,3",null,"Sheep Production Handbook, 2002."]
[1,1.1399999999999999,1.3,1.27,1.37,1.36,1.46,1.56]
[2,1.06,1.21,1.18,1.27,1.26,1.36,1.45]
[3,1,1.1399999999999999,1.1100000000000001,1.2,1.19,1.28,1.37]
[7,1.04,1.19,1.1499999999999999,1.25,1.24,1.33,1.42]
[]
["Ram Lamb Adjustment Factors"]
[null,"Type of Birth/Rearing"]
["Age of Dam","1,1","1,2","2,1","2,2","3,1","3,2","3,3"]
[1,1.04,1.18,1.1499999999999999,1.24,1.23,1.33,1.42]
[2,0.96,1.1000000000000001,1.07,1.1599999999999999,1.1499999999999999,1.23,1.32]
[3,0.91,1.04,1.01,1.0900000000000001,1.08,1.1599999999999999,1.25]
[7,0.95,1.08,1.05,1.1399999999999999,1.1299999999999999,1.21,1.3]
[]
["Wether Lamb Adjustment Factors"]
[null,"Type of Birth/Rearing"]
["Age of Dam","1,1","1,2","2,1","2,2","3,1","3,2","3,3"]
[1,1.1100000000000001,1.26,1.23,1.33,1.32,1.42,1.51]
[2,1.03,1.21,1.1399999999999999,1.23,1.22,1.32,1.41]
[3,0.97,1.1100000000000001,1.08,1.1599999999999999,1.1499999999999999,1.24,1.33]
[7,1.01,1.1499999999999999,1.1200000000000001,1.21,1.2,1.29,1.38]

{"sheet":"Lamb Recording Sheet","index":6,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,0,5,8]]}
[{"$f":"Config!A1","v":"MSU Extension Service Lamb Records"}]
["Lamb Data Entry Sheet"]
["Use this sheet to record lamb data in the field. Print as many copies as needed."]
[]
["Sex of Lamb = Ewe, Ram, or Wether"]
["Birth/Rearing Type: 1=Single raised as Single, 2=Single raised as Twin, 3=Twin Raised as Single,\n4=Twin raised as Twin, 5=Triplet raised as Single, 6=Triplet raised as Twin, 7=Triplet raised as Triplet."]
[]
["Lamb ID","Lamb Birth Date","Sex of Lamb","Birth Weight","Ewe ID","Ram ID","Birth/\nRrng Type","Weaning Date","Weaning Weight"]

{"sheet":"User Guide","index":7,"n_rows":44,"n_cols":1,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Config!A1","v":"MSU Extension Service Lamb Records"}]
["User Guide"]
[]
["     The Lamb Records workbook is designed to calculate weaning age, Average Daily Gain (ADG), Weight per Day of Age (WDA), Adjusted Weaning Weight (Adj WW), and Adjusted WW Weight Ratio (Adj WW Ratio). The workbook can calculate results for 200 lambs from 100 ewes and 20 rams."]
["     Weaning Age is simply Weaning Date - Birth Date. Age Group is calculated as either 60, 90, or 120 days. Up to 75 days is considered the 60 Day group, 76 to 105 days is considered the 90 Day group, and over 105 days is in the 120 Day group. Weight per Day of Age (WDA) is calculated as Weaning Weight/Age at Weaning in days. Average Daily Gain (ADG) is calculated as (Weaning Weight - Birthweight)/Age at Weaning in Days. Age Corrected Weaning Weight is calculated as ADG * Age Group Days (60/90/120) + Birth Weight (BW). If ADG is not calculated due to missing birth weight, Age Corrected Weaning Weight is calculated as WDA * Age Group Days (60/90/120). Adjusted Weaning Weight (Adj WW) is calculated as Age Corr WW * Weight Adjustment Factor. Weights are adjusted for Sex, Age of Dam, and Birth/Rearing Type. The adjustment factors tables can be found on the Tables worksheet."]
[]
["Basic Tips for Using Excel"]
["1.  When you open the workbook, you must always enable the macros or the buttons will not work."]
["2.  Generally, to move across the rows you type the data and press the Tab key to move to the next cell; to move down a column you type the data and press the Enter key. In the \"Category\" column, either click the down-arrow block at the end of the cell or press Alt-DownArrow to drop down a list of items to select from."]
["3.  Remember to SAVE OFTEN as you enter data."]
[]
["Starting A New Year"]
["     When you want to start a new year, there are a few things you need to do. Follow these steps to get ready for a new year."]
["1.  Save the Lamb_Records_Master workbook to a new name. For example, 2015_MS_Sheep_Farm_Lamb_Records. If you have already entered ewe data and ram data, save the current year file to a new name instead of the master workbook."]
["2.  Go to the Config worksheet and enter the Farm Name, Producer, and Lamb Year."]
["3.  Go to the Lamb Data worksheet and clear the Lamb data by clicking the gray \"Clear Lambs\" button and answering \"Y\" to the question box that appears."]
["4.  Go to the Ewe Data worksheet and enter data for the ewes present. Only the Ewe ID and the Ewe Birth Date MUST be entered. The Ewe Birth Date is required for determining the weight adjustment factors."]
["5.  Print the Ewe Data sheet for entering lamb data. Click the gray \"Print Ewes\" button. Only the rows with ewe data will be printed."]
["6.  Go to the Ram Data worksheet and enter the rams present. Only the Ram ID is required. The Lamb Data sheet can be sorted by Ram ID for selecting lambs if this data sheet is completed."]
["7.  Print the Ram Data sheet for entering lamb data. Click the gray \"Print Rams\" button. Only the rows with Ram data will be printed."]
["8.  Save the workbook."]
[]
["Recording Lamb Data"]
["     The best way to record data for lambs is as they are born. The purpose of the Lamb Recording Sheet is to allow you to easily record data in the field. Print copies of this sheet so you can record the data in the field."]
[]
["Entering Lamb Data"]
["1.  Go to the Lamb Data worksheet."]
["2.  Type the Lamb ID and press the Tab Key to move to the next field."]
["3.  Type the Ewe ID from the Ewe Data worksheet and press the Tab key. The Ewe ID MUST be entered on the Ewe Data worksheet."]
["4.  Type the Ram ID from the Ram Data worksheet and press the Tab key. The Ram ID MUST be entered on the Ram Data worksheet"]
["5.  Enter the lamb birth date and press the Tab key."]
["6.  Type the sex of the lamb and press the Tab key. Enter 1 for a ewe lamb, 2 for a ram lamb, or 3 for a wether lamb."]
["7.  Type the number for the Birth/Rearing Type and press the Tab key. The numbers for the different Birth/Rearing Type combinations will be listed in the message box."]
["8.  Type the lamb birth weight and press the Tab key. If you did not weigh the lamb, you may estimate the birth weight or leave it blank. If the birth weight is not entered, the WDA will be used in calculating the Age Corrected Weaning Weight (Age Corr WW)."]
["9.  Enter the lamb weaning weight and press the Tab key."]
["10.  Type the Weaning Weight and press the Tab key. Pressing the Tab key after entering the Weaning Wt will move the cursor back to the Lamb ID cell for the next lamb."]
["11.  Save the worksheet often as you are entering lamb data."]
["     As Lamb data are entered, the various factors such as WDA, ADG, etc. will be calculated."]
[]
["Sorting/Printing Reports"]
["     After you enter all the lamb data and the values are calculated, you are ready to sort the sheet and print it for making keep/cull decisions. The basic process is to click the appropriate sort method button on the Lmab Data sheet and then click the Print Lambs button. The print button will determine which rows have data and print only those rows with data. The report will be printed in the order they are sorted."]
["     The Sort by # button on the Lamb Data worksheet sorts the lambs the # column, A. This puts the lambs in the original order they were entered. The Sort by Lamb ID button sorts by the Lamb ID column. This makes it easier to enter data such as weaning weight and date."]
["     The Sort by ADG, Sort by WDA, Sort by Adj WW, and the Sort by Adj WW Ratio button all sort the lambs first by the sex of the lamb and then by the selected characteristic (ADG, WDA, Adj WW, or Adj WW Ratio)."]
["     The Sort by Ram/Adj WW and Sort by Ram/Adj WW Ratio buttons sort the lambs first by Ram ID, then by the sex of the lamb, and then by the selected characteristic (Adj WW or Adj WW Ratio)."]