{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Overview","Feed Uniformity Test","Testing History","Formulas","Feed Uniformity Test (Example)"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":34,"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":"Overview","index":0,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,3,6,13]]}
[]
[null,null,null,"Iowa Pork Industry Center"]
[null,null,null,"Feed Uniformity Test Tracker TM"]
[null,null,null,null,"Version ",1]
[]
[null,null,null,"A feed mixing uniformity test evaluates the uniformity of ingredient dispersion in a batch of feed. Testing procedure will include: establish feed sample collection process, identify trace substance or micronutrient, establish testing protocol for trace substance, data analysis and interpretation of results."]
[]
[]
[null,null,null,"Overview of this template"]
[null,null,null,null," Feed Uniformity Test Tracker requires 8 to 10 sample results for calculations."]
[]
[null,null,null,null,"Upon downloading or receiving this Excel template, save the file to a known location on your computer."]
[null,null,null,null,null,"    Note: You may rename this file to reflect your company or location uniformity test tracker."]
[]
[null,null,null,null,"This Excel template contains macros  (Print Report, Transfer Test Results to Testing History, Save File, Clear All, Clear Last Sample)"]
[null,null,null,null,null,"    Note: You may need to \"enable\" macros within Excel. Search \"Macro Settings\"."]
[]
[null,null,null,"Feed Uniformity Test tab:"]
[null,null,null,null,"Sample Data Entry (Input)"]
[null,null,null,null,"1)","Enter data in white fields (Mixer, Sampling, Trace Substance, Lab Results)"]
[null,null,null,null,null,"    Note: Enter sample results consecutively (1 to 10, 1 to 9, or 1 to 8)"]
[]
[null,null,null,null,"Test Result (output) is automatically calculated"]
[null,null,null,null,"2)"," Print the page, if desired.   Use the macro button or Excel menu."]
[null,null,null,null,"3)"," Transfer Results to \"Testing History\" tab.   Use the macro button."]
[null,null,null,null,"4)"," Save the file.   If the file is closed without saving, the results will not be saved in Testing History.  Use the macro button or Excel menu."]
[]
[]
[null,null,null,"Testing History tab:"]
[null,null,null,null,"History is built over time as analyses are completed."]
[null,null,null,null,"No formulas - text and values are static.    Sheet is unprotectected - column width can be changed as needed."]
[null,null,null,null,"Ability to track or compare any data input elements.   Select all data (Columns A to AZ), then Sort by item of interest (tracer, mixer, etc.)"]
[]
[]
[null,"Questions may be directed to:"]
[null,null,"Iowa Pork Industry Center   800-808-7675 or ipic@iastate.edu"]
[null,null,"Mark Storlie, ISU Extension Swine Field Specialist,   563-425-3331 or mstorlie@iastate.edu"]

{"sheet":"Feed Uniformity Test","index":1,"n_rows":71,"n_cols":66,"rows_kept":71,"cut":false,"hidden":false,"merged":[[31,3,33,6],[21,9,21,10],[22,2,22,6],[22,9,22,10],[23,2,23,6],[23,9,23,10],[24,2,24,6],[24,9,24,10],[25,2,25,6],[25,9,25,10],[26,2,26,6],[26,9,26,10],[27,2,27,6],[18,4,18,6],[18,9,18,10],[19,4,19,6],[19,9,19,10],[20,4,20,6],[20,9,20,10],[17,4,17,6],[17,9,17,10],[11,4,11,6],[11,11,11,13],[12,4,12,6],[12,11,12,13],[13,4,13,6],[13,11,13,13],[14,4,14,6],[15,4,15,6],[15,9,15,10],[16,4,16,6],[16,9,16,10],[8,4,8,6],[8,11,8,13],[9,4,9,6],[9,11,9,13],[10,4,10,6],[10,11,10,13]]}
[]
[null,"    Feed Uniformity Test ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: Columns  S to BL  will be hidden"]
[null,null,"Version ",{"$f":"Overview!F4","v":1}]
[]
[]
[]
[]
[]
[null,null,"Company",null,null,null,null,null,null,"Lab Analysis Company",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sample #",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sample #/ Mixer location  (Description of mixer location for predetermined sample collection)"]
[null,null,"Location",null,null,null,null,null,null,"Sample Test Name",null,null,null,null,null,null,null,null,null,"Date analyzed","Batch Name or Lot#","Batch Size (lbs.)","Mix Time (minutes)","Sample Interval (seconds)","Tracer/ Micro Nutrient","Mean","SD","CV","Total Samples",1,2,3,4,5,6,7,8,9,10,"Lab Analysis Company","Sample Test Name","Tracer/ Micro Nutrient","Tracer/ Nutrient Units","AAFCO chemistry Method",null,"Company","Location","Mixer ID/Name","Mixer Type","Sample Date",{"$f":"C14","v":"Sampler (who) Initials"},"Sample Type","Feed Type",null,1,2,3,4,5,6,7,8,9,10,null,"Notes, Comments, Corrective Actions:"]
[null,null,"Mixer ID/Name",null,null,null,null,null,null,"Tracer/ Micro Nutrient",null,null,null,null,null,null,null,null,null,{"$f":"L14","v":"00:00:00"},{"$f":"E16","v":0},{"$f":"E18","v":0},{"$f":"E19","v":0},{"$f":"E21","v":0},{"$f":"M17","v":", "},{"$f":"ROUND(M32,4)","v":{"$error":"#VALUE!"}},{"$f":"M33","v":" "},{"$f":"M34","v":" "},{"$f":"W28","v":0},{"$f":"M18","v":0},{"$f":"M19","v":0},{"$f":"M20","v":0},{"$f":"M21","v":0},{"$f":"M22","v":0},{"$f":"M23","v":0},{"$f":"M24","v":0},{"$f":"M25","v":0},{"$f":"M26","v":0},{"$f":"M27","v":0},{"$f":"L9","v":0},{"$f":"L10","v":0},{"$f":"L11","v":0},{"$f":"L12","v":0},{"$f":"L13","v":0},null,{"$f":"E9","v":0},{"$f":"E10","v":0},{"$f":"E11","v":0},{"$f":"E12","v":0},{"$f":"E13","v":"00:00:00"},{"$f":"E14","v":0},{"$f":"E15","v":0},{"$f":"E17","v":0},null,{"$f":"IF(J18=0,\" \",J18)","v":" "},{"$f":"IF(J19=0,\" \",J19)","v":" "},{"$f":"IF(J20=0,\" \",J20)","v":" "},{"$f":"IF(J21=0,\" \",J21)","v":" "},{"$f":"IF(J22=0,\" \",J22)","v":" "},{"$f":"IF(J23=0,\" \",J23)","v":" "},{"$f":"IF(J24=0,\" \",J24)","v":" "},{"$f":"IF(J25=0,\" \",J25)","v":" "},{"$f":"IF(J26=0,\" \",J26)","v":" "},{"$f":"IF(J27=0,\" \",J27)","v":" "},null,{"$f":"C24&\": \"&C25&\": \"&C26&\": \"&C27&\": \"&C28","v":": : : : "}]
[null,null,"Mixer Type",null,null,null,null,null,null,"Tracer/Nutrient Units"]
[null,null,"Sample Date",null,null,null,null,null,null,"AAFCO Chemistry Method"]
[null,null,"Sampler (who) Initials",null,null,null,null,null,null,"Date analyzed"]
[null,null,"Sample Type"]
[null,null,"Batch Name or Lot#",null,null,null,null,null,null,"If Predetermined locations"]
[null,null,"Feed Type",null,null,null,null,null,null,"Describe mixer locations (optional):",null,"Sample #",{"$f":"L11&\", \"&L12","v":", "},null,null,null,"Example Sampling Pattern for predetermined locations"]
[null,null,"Batch Size (pounds)",null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,{"$f":"IF($M18>0.00000001,\"1\",\"0\")/1","v":0},{"$f":"IF($M18>0.00000001,\"1\",\"0\")/1","v":0},{"$f":"IF($M18>0.00000001,\"1\",\"0\")/1","v":0},{"$f":"IF($M18>0.00000001,\"1\",\"0\")/1","v":0}]
[null,null,"Mix Time (minutes)",null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,{"$f":"IF($M19>0.00000001,\"1\",\"0\")/1","v":0},0,0,0]
[null,null,"If Sample Collection is timed interval:",null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,0,0,0,0]
[null,null,"Sample Interval (seconds)",null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,null,null,null,0,0,0,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,{"$f":"IF(J29=0,\" \",J29)","v":"Minimum of 8 Sample Results must be entered for calculations."}]
[null,null,"Notes, Comments, Corrective Actions:",null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,9,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,10,null,null,null,null,null,null,null,{"$f":"SUM($T$18:$T$25)","v":0},{"$f":"IF($M27>0.00000001,\"1\",\"0\")/1","v":0},{"$f":"IF($M27>0.00000001,\"1\",\"0\")/1","v":0},{"$f":"IF($M27>0.00000001,\"1\",\"0\")/1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($T$18:$T$25)+W26+W27","v":0},{"$f":"SUM(U18:U26)-W27","v":0},{"$f":"SUM(V18:V27)","v":0},{"$f":"SUM(W18:W27)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(T27<8,\"Minimum of 8 Sample Results must be entered for calculations.\",\" \")","v":"Minimum of 8 Sample Results must be entered for calculations."}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(M32=\" \",\"Enter sample results consecutive (1 to 10, 1 to 9, or 1 to 8).\",\" \")","v":"Enter sample results consecutive (1 to 10, 1 to 9, or 1 to 8)."}]
[null,null,null,null,null,null,null,null,null,null,"Results:","Samples",{"$f":"W28","v":0},null,null,null,null,null,null,8,9,10]
[null,null,null,"Herrman and Behnke (1994) categorized a CV of less than 10% as excellent, 10 to 15% as good, 15 to 20% as fair, and greater than 20% as poor.",null,null,null,null,null,null,null,"Mean",{"$f":"V36","v":" "},null,null,null,null,null,null,{"$f":"AVERAGE($M$18:$M$25)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE($M$18:$M$26)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE($M$18:$M$27)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"SD",{"$f":"V37","v":" "},null,null,null,null,null,null,{"$f":"STDEV($M$18:$M$25)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV($M$18:$M$26)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV($M$18:$M$27)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"CV",{"$f":"V38","v":" "},null,null,null,null,null,null,{"$f":"(T33/T32)","v":{"$error":"#DIV/0!"}},{"$f":"(U33/U32)","v":{"$error":"#DIV/0!"}},{"$f":"(V33/V32)","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,{"$f":"IF($T$27<8,\" \",IF($V$31=$V$28,$V32,IF($U$31=$U$28,$U32,IF($T$31=$T$28,$T32,\" \"))))","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($T$27<8,\" \",IF($V$31=$V$28,$V33,IF($U$31=$U$28,$U33,IF($T$31=$T$28,$T33,\" \"))))","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($T$27<8,\" \",IF($V$31=$V$28,$V34,IF($U$31=$U$28,$U34,IF($T$31=$T$28,$T34,\" \"))))","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Mixer Type"]
[null,null,"Horizontal"]
[null,null,"Vertical"]
[null,null,"Continuous Proportioning "]
[]
[]
[null,null,"Sample Type"]
[null,null,"Predetermined Location"]
[null,null,"Timed Interval"]
[null,null,"Other"]
[]
[]
[]
[null,null,"Feed Type"]
[null,null,"Complete"]
[null,null,"Supplement"]
[null,null,"Premix"]
[null,null,"Other"]
[]
[null,null,"Tracer/Nutrient Units"]
[null,null,"%"]
[null,null,"ppm"]

{"sheet":"Testing History","index":2,"n_rows":257,"n_cols":49,"rows_kept":257,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"    Feed Uniformity Test Tracker TM",null,null,"Testing History"]
[null,null,"Version ",{"$f":"Overview!$F$4","v":1}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Sample #",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sample #/ Mixer location  (Description of mixer location for predetermined sample collection)"]
[null,null,"Date analyzed","Batch Name or Lot#","Batch Size (pounds)","Mix Time (minutes)","Sample Interval (seconds)","Tracer/ Micro Nutrient","Mean","SD","CV","Total No. of Samples",1,2,3,4,5,6,7,8,9,10,"Lab Analysis Company","Sample Test Name","Tracer/ Micro Nutrient","Tracer/ Nutrient Units","AAFCO chemistry Method",null,"Company","Location","Mixer ID/Name","Mixer Type","Sample Date","Sampler (who) initials","Sample Type","Feed Type",null,1,2,3,4,5,6,7,8,9,10,null,"Notes, Comments, Corrective Actions:"]
[]
[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]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]

{"sheet":"Formulas","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Feed Uniformity Test (Example)","index":4,"n_rows":71,"n_cols":66,"rows_kept":71,"cut":false,"hidden":false,"merged":[[23,2,23,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[31,3,33,6],[27,2,27,6],[19,4,19,6],[19,9,19,10],[20,4,20,6],[20,9,20,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[25,9,25,10],[26,9,26,10],[22,2,22,6],[18,4,18,6],[11,4,11,6],[11,11,11,13],[12,4,12,6],[12,11,12,13],[13,4,13,6],[13,11,13,13],[14,4,14,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[16,9,16,10],[17,9,17,10],[18,9,18,10],[15,9,15,10],[8,4,8,6],[8,11,8,13],[9,4,9,6],[9,11,9,13],[10,4,10,6],[10,11,10,13]]}
[]
[null,"    Feed Uniformity Test ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: Columns  S to BL  will be hidden"]
[null,null,"Version ",{"$f":"Overview!F4","v":1}]
[]
[]
[]
[]
[]
[null,null,"Company",null,"ISU Kent Feed Mill",null,null,null,null,"Lab Analysis Company",null,"ABC Labs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sample #",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sample #/ Mixer location  (Description of mixer location for predetermined sample collection)"]
[null,null,"Location",null,"Ames",null,null,null,null,"Sample Test Name",null,"ABC Macro Minerals",null,null,null,null,null,null,null,"Date analyzed","Batch Name or Lot#","Batch Size (lbs.)","Mix Time (minutes)","Sample Interval (seconds)","Tracer/ Micro Nutrient","Mean","SD","CV","Total Samples",1,2,3,4,5,6,7,8,9,10,"Lab Analysis Company","Sample Test Name","Tracer/ Micro Nutrient","Tracer/ Nutrient Units","AAFCO chemistry Method",null,"Company","Location","Mixer ID/Name","Mixer Type","Sample Date",{"$f":"C14","v":"Sampler (who) Initials"},"Sample Type","Feed Type",null,1,2,3,4,5,6,7,8,9,10,null,"Notes, Comments, Corrective Actions:"]
[null,null,"Mixer ID/Name",null,"Main Mixer",null,null,null,null,"Tracer/ Micro Nutrient",null,"Sodium",null,null,null,null,null,null,null,{"$f":"L14","v":"2025-01-14"},{"$f":"E16","v":"Grower 2"},{"$f":"E18","v":6000},{"$f":"E19","v":7},{"$f":"E21","v":30},{"$f":"M17","v":"Sodium, %"},{"$f":"ROUND(M32,4)","v":0.17399999999999999},{"$f":"M33","v":1.7126976771553507E-2},{"$f":"M34","v":9.843090098593972E-2},{"$f":"W28","v":10},{"$f":"M18","v":0.17},{"$f":"M19","v":0.18},{"$f":"M20","v":0.19},{"$f":"M21","v":0.19},{"$f":"M22","v":0.2},{"$f":"M23","v":0.18},{"$f":"M24","v":0.17},{"$f":"M25","v":0.16},{"$f":"M26","v":0.15},{"$f":"M27","v":0.15},{"$f":"L9","v":"ABC Labs"},{"$f":"L10","v":"ABC Macro Minerals"},{"$f":"L11","v":"Sodium"},{"$f":"L12","v":"%"},{"$f":"L13","v":0},null,{"$f":"E9","v":"ISU Kent Feed Mill"},{"$f":"E10","v":"Ames"},{"$f":"E11","v":"Main Mixer"},{"$f":"E12","v":"Horizontal"},{"$f":"E13","v":"2025-01-03"},{"$f":"E14","v":"MPS"},{"$f":"E15","v":"Timed Interval"},{"$f":"E17","v":"Complete"},null,{"$f":"IF(J18=0,\" \",J18)","v":"NW"},{"$f":"IF(J19=0,\" \",J19)","v":" "},{"$f":"IF(J20=0,\" \",J20)","v":" "},{"$f":"IF(J21=0,\" \",J21)","v":"NE"},{"$f":"IF(J22=0,\" \",J22)","v":"Middle W"},{"$f":"IF(J23=0,\" \",J23)","v":"Middle E"},{"$f":"IF(J24=0,\" \",J24)","v":"SW"},{"$f":"IF(J25=0,\" \",J25)","v":" "},{"$f":"IF(J26=0,\" \",J26)","v":" "},{"$f":"IF(J27=0,\" \",J27)","v":"SE"},null,{"$f":"C24&\": \"&C25&\": \"&C26&\": \"&C27&\": \"&C28","v":"Inspect mixer paddles in middle zone: : : : "}]
[null,null,"Mixer Type",null,"Horizontal",null,null,null,null,"Tracer/Nutrient Units",null,"%"]
[null,null,"Sample Date",null,"2025-01-03",null,null,null,null,"AAFCO Chemistry Method"]
[null,null,"Sampler (who) Initials",null,"MPS",null,null,null,null,"Date analyzed",null,"2025-01-14"]
[null,null,"Sample Type",null,"Timed Interval"]
[null,null,"Batch Name or Lot#",null,"Grower 2",null,null,null,null,"If Predetermined locations"]
[null,null,"Feed Type",null,"Complete",null,null,null,null,"Describe mixer locations (optional):",null,"Sample #",{"$f":"L11&\", \"&L12","v":"Sodium, %"},null,null,null,"Example Sampling Pattern for predetermined locations"]
[null,null,"Batch Size (pounds)",null,6000,null,null,null,null,"NW",null,1,0.17,null,null,null,null,null,null,{"$f":"IF($M18>0.00000001,\"1\",\"0\")/1","v":1},{"$f":"IF($M18>0.00000001,\"1\",\"0\")/1","v":1},{"$f":"IF($M18>0.00000001,\"1\",\"0\")/1","v":1},{"$f":"IF($M18>0.00000001,\"1\",\"0\")/1","v":1}]
[null,null,"Mix Time (minutes)",null,7,null,null,null,null,null,null,2,0.18,null,null,null,null,null,null,{"$f":"IF($M19>0.00000001,\"1\",\"0\")/1","v":1},1,1,1]
[null,null,"If Sample Collection is timed interval:",null,null,null,null,null,null,null,null,3,0.19,null,null,null,null,null,null,1,1,1,1]
[null,null,"Sample Interval (seconds)",null,30,null,null,null,null,"NE",null,4,0.19,null,null,null,null,null,null,1,1,1,1]
[null,null,null,null,null,null,null,null,null,"Middle W",null,5,0.2,null,null,null,null,null,null,1,1,1,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J29=0,\" \",J29)","v":" "}]
[null,null,"Notes, Comments, Corrective Actions:",null,null,null,null,null,null,"Middle E",null,6,0.18,null,null,null,null,null,null,1,1,1,1]
[null,null,"Inspect mixer paddles in middle zone",null,null,null,null,null,null,"SW",null,7,0.17,null,null,null,null,null,null,{"$f":"IF($M24>0.00000001,\"1\",\"0\")/1","v":1},1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,8,0.16,null,null,null,null,null,null,1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,9,0.15,null,null,null,null,null,null,1,1,1,1]
[null,null,null,null,null,null,null,null,null,"SE",null,10,0.15,null,null,null,null,null,null,{"$f":"SUM($T$18:$T$25)","v":8},{"$f":"IF($M27>0.00000001,\"1\",\"0\")/1","v":1},{"$f":"IF($M27>0.00000001,\"1\",\"0\")/1","v":1},{"$f":"IF($M27>0.00000001,\"1\",\"0\")/1","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($T$18:$T$25)+W26+W27","v":10},{"$f":"SUM(U18:U26)-W27","v":8},{"$f":"SUM(V18:V27)","v":10},{"$f":"SUM(W18:W27)","v":10}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(T27<8,\"Minimum of 8 Sample Results must be entered for calculations.\",\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(M32=\" \",\"Enter sample results consecutive (1 to 10, 1 to 9, or 1 to 8).\",\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,"Results:","Samples",{"$f":"W28","v":10},null,null,null,null,null,null,8,9,10]
[null,null,null,"Herrman and Behnke (1994) categorized a CV of less than 10% as excellent, 10 to 15% as good, 15 to 20% as fair, and greater than 20% as poor.",null,null,null,null,null,null,null,"Mean",{"$f":"V36","v":0.17399999999999996},null,null,null,null,null,null,{"$f":"AVERAGE($M$18:$M$25)","v":0.17999999999999997},{"$f":"AVERAGE($M$18:$M$26)","v":0.17666666666666664},{"$f":"AVERAGE($M$18:$M$27)","v":0.17399999999999996}]
[null,null,null,null,null,null,null,null,null,null,null,"SD",{"$f":"V37","v":1.7126976771553507E-2},null,null,null,null,null,null,{"$f":"STDEV($M$18:$M$25)","v":1.3093073414159542E-2},{"$f":"STDEV($M$18:$M$26)","v":1.5811388300841899E-2},{"$f":"STDEV($M$18:$M$27)","v":1.7126976771553507E-2}]
[null,null,null,null,null,null,null,null,null,null,null,"CV",{"$f":"V38","v":9.843090098593972E-2},null,null,null,null,null,null,{"$f":"(T33/T32)","v":7.2739296745330806E-2},{"$f":"(U33/U32)","v":8.9498424344388122E-2},{"$f":"(V33/V32)","v":9.843090098593972E-2}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($T$27<8,\" \",IF($V$31=$V$28,$V32,IF($U$31=$U$28,$U32,IF($T$31=$T$28,$T32,\" \"))))","v":0.17399999999999996}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($T$27<8,\" \",IF($V$31=$V$28,$V33,IF($U$31=$U$28,$U33,IF($T$31=$T$28,$T33,\" \"))))","v":1.7126976771553507E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($T$27<8,\" \",IF($V$31=$V$28,$V34,IF($U$31=$U$28,$U34,IF($T$31=$T$28,$T34,\" \"))))","v":9.843090098593972E-2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Mixer Type"]
[null,null,"Horizontal"]
[null,null,"Vertical"]
[null,null,"Continuous Proportioning "]
[]
[]
[null,null,"Sample Type"]
[null,null,"Predetermined Location"]
[null,null,"Timed Interval"]
[null,null,"Other"]
[]
[]
[]
[null,null,"Feed Type"]
[null,null,"Complete"]
[null,null,"Supplement"]
[null,null,"Premix"]
[null,null,"Other"]
[]
[null,null,"Tracer/Nutrient Units"]
[null,null,"%"]
[null,null,"ppm"]