{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Config","Kid Data","Doe Data","Buck Data","Summary","Tables","Kid Recording Sheet","User Guide"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":46,"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 Goat Records"]
["Configuration Sheet"]
[]
[]
["Farm Name:"]
["Owner:"]
["Lamb Year:"]

{"sheet":"Kid 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 Goat Records"}]
["Kid 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(Kid_Count=0,\"\",DCOUNT(Kid_Data_Table_2,12,Age_Group_60_Criteria))","v":""},{"$f":"IF(Kid_Count=0,\"\",DAVERAGE(Kid_Data_Table_2,17,Age_Group_60_Criteria))","v":""},{"$f":"IF(Kid_Count=0,\"\",DCOUNT(Kid_Data_Table_2,12,Age_Group_90_Criteria))","v":""},{"$f":"IF(Kid_Count=0,\"\",DAVERAGE(Kid_Data_Table_2,17,Age_Group_90_Criteria))","v":""},{"$f":"IF(Kid_Count=0,\"\",DCOUNT(Kid_Data_Table_2,12,Age_Group_120_Criteria))","v":""},{"$f":"IF(Kid_Count=0,\"\",DAVERAGE(Kid_Data_Table_2,17,Age_Group_120_Criteria))","v":""}]
["Kid Year:",null,{"$f":"IF(Kid_Year=\"\",\"\",Kid_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(Kid_Count=0,\"\",AVERAGE(K10:K209))","v":""},{"$f":"IF(Kid_Count=0,\"\",AVERAGE(L10:L209))","v":""},null,{"$f":"IF(Kid_Count=0,\"\",AVERAGE(N10:N209))","v":""},{"$f":"IF(Kid_Count=0,\"\",AVERAGE(O10:O209))","v":""},{"$f":"IF(Kid_Count=0,\"\",AVERAGE(P10:P209))","v":""},{"$f":"IF(Kid_Count=0,\"\",AVERAGE(Q10:Q209))","v":""},{"$f":"IF(Kid_Count=0,\"\",AVERAGE(R10:R209))","v":""}]
[]
["#","Kid ID","Doe ID","Doe Age","Buck ID","Kid Birth Date","Kid 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,Doe_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=\"\",\"\",$P10*VLOOKUP($G10,Sex_of_Kid_Adj_Factors_Table,2)*VLOOKUP($D10,Age_of_Dam_Adj_Factors_Table,2)*VLOOKUP($H10,Birth__Rearing_Type_Adj_Factors_Table,2))","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,Doe_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=\"\",\"\",$P42*VLOOKUP($G42,Sex_of_Kid_Adj_Factors_Table,2)*VLOOKUP($D42,Age_of_Dam_Adj_Factors_Table,2)*VLOOKUP($H42,Birth__Rearing_Type_Adj_Factors_Table,2))","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,Doe_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=\"\",\"\",$P74*VLOOKUP($G74,Sex_of_Kid_Adj_Factors_Table,2)*VLOOKUP($D74,Age_of_Dam_Adj_Factors_Table,2)*VLOOKUP($H74,Birth__Rearing_Type_Adj_Factors_Table,2))","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,Doe_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=\"\",\"\",$P106*VLOOKUP($G106,Sex_of_Kid_Adj_Factors_Table,2)*VLOOKUP($D106,Age_of_Dam_Adj_Factors_Table,2)*VLOOKUP($H106,Birth__Rearing_Type_Adj_Factors_Table,2))","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,Doe_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=\"\",\"\",$P138*VLOOKUP($G138,Sex_of_Kid_Adj_Factors_Table,2)*VLOOKUP($D138,Age_of_Dam_Adj_Factors_Table,2)*VLOOKUP($H138,Birth__Rearing_Type_Adj_Factors_Table,2))","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,Doe_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=\"\",\"\",$P170*VLOOKUP($G170,Sex_of_Kid_Adj_Factors_Table,2)*VLOOKUP($D170,Age_of_Dam_Adj_Factors_Table,2)*VLOOKUP($H170,Birth__Rearing_Type_Adj_Factors_Table,2))","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,Doe_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=\"\",\"\",$P202*VLOOKUP($G202,Sex_of_Kid_Adj_Factors_Table,2)*VLOOKUP($D202,Age_of_Dam_Adj_Factors_Table,2)*VLOOKUP($H202,Birth__Rearing_Type_Adj_Factors_Table,2))","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":"Doe Data","index":2,"n_rows":106,"n_cols":7,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Config!A1","v":"MSU Extension Service Goat Records"}]
["Doe Data Sheet"]
[null,null,null,null,null,null,"# Does"]
[null,null,null,null,null,null,{"$f":"IF(Doe_Count=0,\"\",Doe_Count)","v":""}]
[]
["#","Doe ID","Doe 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":"Buck Data","index":3,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Config!A1","v":"MSU Extension Service Goat Records"}]
["Buck Data Sheet"]
[null,null,null,null,null,null,"# Bucks"]
[null,null,null,null,null,null,{"$f":"IF(Buck_Count=0,\"\",Buck_Count)","v":""}]
[]
["#","Buck ID","Buck Name","Birth Date","Breed","Dam ID","Sire ID"]
[1]
[3]
[2]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]

{"sheet":"Summary","index":4,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[26,0,26,7]]}
[{"$f":"Config!A1","v":"MSU Extension Service Goat Records"}]
["Summary Sheet"]
[]
["Summary by Age Group (60 Day, 90 Day, 120 Day)"]
[]
[]
[null,"Data"]
["Wng Age Group","Ave Wng Age","Ave WW","Ave ADG","Ave WDA","Ave Age Corr WW","Ave Adj WW","Ave Adj WW Ratio"]
["Grand Total"]
[]
[]
[]
[]
[]
["Summary by Sex of Kid (1=Doe, 2=Buck, 3=Wether)"]
[]
[]
[null,"Data"]
[null,"Ave ADG","Ave WDA","Ave WW","Ave Age Corr WW","Ave Adj WW","Ave Adj WW Ratio"]
["Total",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
["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","Ave WW","Ave ADG","Ave WDA","Ave Age Corr WW","Ave Adj WW","Ave Adj WW Ratio"]
["Grand Total"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Summary by Buck ID"]
[]
[]
[null,"Data"]
[null,"Ave ADG","Ave WDA","Ave Age Corr WW","Ave WW","Ave Adj WW","Ave Adj WW Ratio"]
["Total",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Tables","index":5,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,12,5,14],[5,3,5,4],[5,0,5,1],[13,0,13,7],[5,8,5,10]]}
[{"$f":"Config!A1","v":"MSU Extension Service Goat Records"}]
["Lookup and Criteria Tables Sheet"]
["(Please DO NOT EDIT ANY VALUES on this sheet!)"]
[]
[]
["Kid Age Group Table",null,null,"Age of Dam Table",null,null,null,null,"Age Group Criteria",null,null,null,"N"]
["Kid Age","Age Group",null,"Age in Days","Age in Years",null,null,null,"Wng Age Group","Wng Age Group","Wng Age Group",null,"Kids","Does","Bucks"]
[0,60,null,0,1,null,null,null,60,90,120,null,{"$f":"COUNTA('Kid Data'!B10:B209)","v":0},{"$f":"COUNTA('Doe Data'!B7:B106)","v":0},{"$f":"COUNTA('Buck Data'!B7:B26)","v":0}]
[76,90,null,731,2]
[106,120,null,1096,3]
[null,null,null,2556,7]
[]
[]
[]
["Age of Dam Adj Factors Table"]
["Age of Dam","Adj\nFactor",null,"Sources for Adjustment Factors Tables:"]
[1,1.1000000000000001,null,"http://www.theikga.org/adjusting_performance_data_for_n.htm"]
[2,1.0900000000000001,null,"http://myotonicgoatregistry.net/ArticlesAndReferences/PerformanceRatio/MGRUnderstandingPerformanceRatios.html"]
[3,1]
[7,1]
[]
[]
["Birth/Rearing Type Adj Factors Table"]
["Birth/\nRearing Type","Adj\nFactor"]
[1,1]
[2,1.1399999999999999]
[3,1.04]
[4,1.18]
[5,1.08]
[6,1.23]
[7,1.23]
[]
["Sex of Kid Adj Factors Table"]
["Sex of Kid","Adj\nFactor"]
[1,1]
[2,0.9]
[3,0.97]

{"sheet":"Kid 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 Goat Records"}]
["Kid Data Entry Sheet"]
["Use this sheet to record lamb data in the field. Print as many copies as needed."]
[]
["Sex of Kid: = Doe, Buck, 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."]
[]
["Kid ID","Kid Birth Date","Sex of Kid","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 Goat Records"}]
["User Guide"]
[]
["     The Goat 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 Kids from 100 Does and 20 Bucks."]
["     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 Kid_Records_Master workbook to a new name. For example, 2015_MS_Sheep_Farm_Kid_Records. If you have already entered Doe data and Buck 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 Kid Year."]
["3.  Go to the Kid Data worksheet and clear the Kid data by clicking the gray \"Clear Kids\" button and answering \"Y\" to the question box that appears."]
["4.  Go to the Doe Data worksheet and enter data for the Does present. Only the Doe ID and the Doe Birth Date MUST be entered. The Doe Birth Date is required for determining the weight adjustment factors."]
["5.  Print the Doe Data sheet for entering Kid data. Click the gray \"Print Does\" button. Only the rows with Doe data will be printed."]
["6.  Go to the Buck Data worksheet and enter the Bucks present. Only the Buck ID is required. The Kid Data sheet can be sorted by Buck ID for selecting Kids if this data sheet is completed."]
["7.  Print the Buck Data sheet for entering Kid data. Click the gray \"Print Bucks\" button. Only the rows with Buck data will be printed."]
["8.  Save the workbook."]
[]
["Recording Kid Data"]
["     The best way to record data for Kids is as they are born. The purpose of the Kid 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 Kid Data"]
["1.  Go to the Kid Data worksheet."]
["2.  Type the Kid ID and press the Tab Key to move to the next field."]
["3.  Type the Doe ID from the Doe Data worksheet and press the Tab key. The Doe ID MUST be entered on the Doe Data worksheet."]
["4.  Type the Buck ID from the Buck Data worksheet and press the Tab key. The Buck ID MUST be entered on the Buck Data worksheet"]
["5.  Enter the Kid birth date and press the Tab key."]
["6.  Type the sex of the Kid and press the Tab key. Enter 1 for a Doe Kid, 2 for a Buck Kid, or 3 for a wether Kid."]
["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 Kid birth weight and press the Tab key. If you did not weigh the Kid, 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 Kid 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 Kid ID cell for the next Kid."]
["11.  Save the worksheet often as you are entering Kid data."]
["     As Kid data are entered, the various factors such as WDA, ADG, etc. will be calculated."]
[]
["Sorting/Printing Reports"]
["     After you enter all the Kid 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 Kids 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 Kid Data worksheet sorts the Kids the # column, A. This puts the Kids in the original order they were entered. The Sort by Kid ID button sorts by the Kid 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 Kids first by the sex of the Kid and then by the selected characteristic (ADG, WDA, Adj WW, or Adj WW Ratio)."]
["     The Sort by Buck/Adj WW and Sort by Buck/Adj WW Ratio buttons sort the Kids first by Buck ID, then by the sex of the Kid, and then by the selected characteristic (Adj WW or Adj WW Ratio)."]