{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Oven Record","Lists","Revision History"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":27,"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":"Oven Record","index":0,"n_rows":177,"n_cols":15,"rows_kept":177,"cut":false,"hidden":false,"merged":[[0,1,0,11],[1,1,1,11],[19,2,19,11],[15,2,15,11],[3,2,3,11],[13,0,13,1],[11,0,11,1],[9,0,9,1],[7,0,7,1],[5,0,5,1],[3,0,3,1],[2,0,2,11],[19,0,19,1],[17,0,17,1],[15,0,15,1],[13,2,13,11],[11,2,11,11],[17,2,17,11],[5,2,5,11],[7,2,7,11],[9,2,9,11],[166,2,166,11],[38,1,38,3],[162,0,162,11],[159,0,159,1],[157,0,157,1],[46,0,46,1],[46,2,46,3],[157,2,157,6],[159,2,159,6],[158,0,158,1],[158,2,158,6],[158,7,158,11],[47,0,47,1],[47,2,47,3],[42,1,42,3],[42,4,42,6],[42,7,42,8],[42,9,42,10],[43,1,43,3],[43,4,43,6],[43,7,43,8],[43,9,43,10],[40,1,40,3],[176,0,176,1],[174,0,174,1],[172,0,172,1],[170,0,170,1],[168,0,168,1],[166,0,166,1],[164,0,164,1],[176,2,176,11],[33,0,34,0],[33,1,33,6],[33,7,34,8],[33,9,34,10],[33,11,34,12],[34,1,34,3],[34,4,34,6],[35,11,43,12],[36,7,36,8],[164,2,164,11],[172,2,172,11],[174,2,174,11],[168,2,168,11],[170,2,170,11],[157,7,157,11],[159,7,159,11],[21,0,21,1],[39,4,39,6],[38,4,38,6],[37,4,37,6],[36,4,36,6],[35,1,35,3],[39,1,39,3],[23,2,23,11],[37,1,37,3],[36,1,36,3],[29,0,29,3],[30,9,30,10],[30,11,30,12],[31,0,31,1],[31,4,31,5],[31,9,31,10],[31,11,31,12],[35,7,35,8],[21,2,21,11],[35,4,35,6],[23,0,23,1],[35,9,35,10],[25,0,25,1],[25,2,25,11],[50,0,50,3],[51,9,51,10],[51,11,51,12],[52,0,52,1],[52,4,52,5],[52,9,52,10],[52,11,52,12],[40,4,40,6],[40,7,40,8],[40,9,40,10],[41,1,41,3],[41,4,41,6],[41,7,41,8],[41,9,41,10],[36,9,36,10],[37,7,37,8],[37,9,37,10],[38,7,38,8],[38,9,38,10],[39,7,39,8],[39,9,39,10],[54,0,55,0],[54,1,54,6],[54,7,55,8],[54,9,55,10],[54,11,55,12],[55,1,55,3],[55,4,55,6],[56,1,56,3],[56,4,56,6],[56,7,56,8],[56,9,56,10],[56,11,64,12],[57,1,57,3],[57,4,57,6],[57,7,57,8],[57,9,57,10],[58,1,58,3],[58,4,58,6],[58,7,58,8],[58,9,58,10],[59,1,59,3],[59,4,59,6],[59,7,59,8],[59,9,59,10],[60,1,60,3],[60,4,60,6],[60,7,60,8],[60,9,60,10],[61,1,61,3],[61,4,61,6],[61,7,61,8],[61,9,61,10],[62,1,62,3],[62,4,62,6],[62,7,62,8],[62,9,62,10],[71,0,71,3],[72,9,72,10],[72,11,72,12],[73,0,73,1],[73,4,73,5],[73,9,73,10],[73,11,73,12],[63,1,63,3],[63,4,63,6],[63,7,63,8],[63,9,63,10],[64,1,64,3],[64,4,64,6],[64,7,64,8],[64,9,64,10],[67,0,67,1],[67,2,67,3],[75,7,76,8],[75,9,76,10],[75,11,76,12],[76,1,76,3],[76,4,76,6],[77,1,77,3],[77,4,77,6],[77,7,77,8],[77,9,77,10],[77,11,85,12],[78,1,78,3],[78,4,78,6],[78,7,78,8],[78,9,78,10],[79,1,79,3],[79,4,79,6],[79,7,79,8],[79,9,79,10],[80,1,80,3],[80,4,80,6],[80,7,80,8],[80,9,80,10],[81,7,81,8],[81,9,81,10],[82,1,82,3],[82,4,82,6],[82,7,82,8],[82,9,82,10],[83,1,83,3],[83,4,83,6],[83,7,83,8],[83,9,83,10],[93,9,93,10],[93,11,93,12],[94,0,94,1],[94,4,94,5],[94,9,94,10],[94,11,94,12],[84,1,84,3],[84,4,84,6],[84,7,84,8],[84,9,84,10],[85,1,85,3],[85,4,85,6],[85,7,85,8],[85,9,85,10],[88,0,88,1],[88,2,88,3],[96,7,97,8],[96,9,97,10],[96,11,97,12],[97,1,97,3],[97,4,97,6],[98,1,98,3],[98,4,98,6],[98,7,98,8],[98,9,98,10],[98,11,106,12],[99,1,99,3],[99,4,99,6],[99,7,99,8],[99,9,99,10],[100,1,100,3],[100,4,100,6],[100,7,100,8],[100,9,100,10],[101,1,101,3],[101,4,101,6],[101,7,101,8],[101,9,101,10],[105,7,105,8],[105,9,105,10],[106,1,106,3],[106,4,106,6],[106,7,106,8],[106,9,106,10],[109,0,109,1],[109,2,109,3],[102,1,102,3],[102,4,102,6],[102,7,102,8],[102,9,102,10],[103,1,103,3],[103,4,103,6],[103,7,103,8],[103,9,103,10],[104,1,104,3],[104,4,104,6],[104,7,104,8],[104,9,104,10],[110,0,110,1],[110,2,110,3],[113,0,113,3],[114,9,114,10],[114,11,114,12],[115,0,115,1],[115,4,115,5],[115,9,115,10],[115,11,115,12],[111,0,111,5],[117,0,118,0],[117,1,117,6],[117,7,118,8],[117,9,118,10],[117,11,118,12],[118,1,118,3],[118,4,118,6],[119,1,119,3],[119,4,119,6],[119,7,119,8],[119,9,119,10],[119,11,127,12],[120,1,120,3],[120,4,120,6],[120,7,120,8],[120,9,120,10],[121,1,121,3],[121,4,121,6],[121,7,121,8],[121,9,121,10],[122,1,122,3],[122,4,122,6],[122,7,122,8],[122,9,122,10],[123,1,123,3],[123,4,123,6],[123,7,123,8],[123,9,123,10],[124,1,124,3],[124,4,124,6],[124,7,124,8],[124,9,124,10],[125,1,125,3],[125,4,125,6],[125,7,125,8],[125,9,125,10],[126,1,126,3],[126,4,126,6],[126,7,126,8],[126,9,126,10],[127,1,127,3],[127,4,127,6],[127,7,127,8],[127,9,127,10],[130,0,130,1],[130,2,130,3],[129,1,129,3],[129,4,129,6],[131,0,131,1],[131,2,131,3],[134,0,134,3],[135,9,135,10],[135,11,135,12],[136,0,136,1],[136,4,136,5],[136,9,136,10],[136,11,136,12],[132,0,132,5],[138,0,139,0],[138,1,138,6],[138,7,139,8],[138,9,139,10],[138,11,139,12],[139,1,139,3],[139,4,139,6],[140,1,140,3],[140,4,140,6],[140,7,140,8],[140,9,140,10],[140,11,148,12],[141,1,141,3],[141,4,141,6],[141,7,141,8],[141,9,141,10],[142,1,142,3],[142,4,142,6],[142,7,142,8],[142,9,142,10],[143,1,143,3],[143,4,143,6],[143,7,143,8],[143,9,143,10],[153,0,153,5],[144,1,144,3],[144,4,144,6],[144,7,144,8],[144,9,144,10],[145,1,145,3],[145,4,145,6],[145,7,145,8],[145,9,145,10],[146,1,146,3],[146,4,146,6],[146,7,146,8],[146,9,146,10],[152,0,152,1],[152,2,152,3],[147,1,147,3],[147,4,147,6],[147,7,147,8],[147,9,147,10],[148,1,148,3],[148,4,148,6],[148,7,148,8],[148,9,148,10],[151,0,151,1],[151,2,151,3],[150,1,150,3],[150,4,150,6],[45,1,45,3],[45,4,45,6],[48,0,48,5],[69,0,69,5],[66,1,66,3],[66,4,66,6],[87,1,87,3],[87,4,87,6],[108,1,108,3],[108,4,108,6],[90,0,90,5],[105,1,105,3],[105,4,105,6],[96,0,97,0],[96,1,96,6],[89,0,89,1],[89,2,89,3],[92,0,92,3],[81,1,81,3],[81,4,81,6],[75,0,76,0],[75,1,75,6],[68,0,68,1],[68,2,68,3]]}
[null,"Texas Department of Transportation"]
[null,"Oven Verification Record"]
[{"$f":"IF(OR(ISBLANK(Serial_Number),ISBLANK(Model_Number),ISBLANK(Description),ISBLANK(Manufacturer_Name),ISBLANK(Lab_Unit),ISBLANK(Calibration_Method),ISBLANK(Completed_Date),ISBLANK(Action_Recommended),ISBLANK(Overall_Status),ISBLANK(Remarks),ISBLANK(Authority),ISBLANK(Performed_By),ISBLANK(Reviewed_By),ISBLANK(Reviewed_Date),AND(ISBLANK(NonTxDOT_Other),Authority=\"Non-TxDOT/Other\"),AND(ISBLANK(District_Lab_Area_Office),Authority=\"District Lab/Area Office\"),AND(ISBLANK(MTD_Section),Authority=\"Materials and Tests Division\")),\"***ALL BLANK FIELDS MUST BE ADDRESSED.***\",\"\")","v":"***ALL BLANK FIELDS MUST BE ADDRESSED.***"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A3=\"\",\"\",\"Instructions\")","v":"Instructions"}]
["Serial Number:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Serial_Number),\"Enter Serial Number exactly as it appears in APCM, corresponding with the physical piece of equipment in accordance with APCM SOP.\",\"\")","v":"Enter Serial Number exactly as it appears in APCM, corresponding with the physical piece of equipment in accordance with APCM SOP."}]
[]
["Model Number:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Model_Number),\"Enter Model Number exactly as it appears in APCM.\",\"\")","v":"Enter Model Number exactly as it appears in APCM."}]
[]
["Description:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Description),\"Enter Description exactly as it appears in APCM.\",\"\")","v":"Enter Description exactly as it appears in APCM."}]
[]
["Manufacturer Name:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Manufacturer_Name),\"Enter Manufacturer exactly as it appears in APCM. If no manufacturer exists, enter 'Not Available'.\",\"\")","v":"Enter Manufacturer exactly as it appears in APCM. If no manufacturer exists, enter 'Not Available'."}]
[]
["Lab Unit:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Lab_Unit),\"Enter the Lab Unit exactly as it appears in APCM.\",\"\")","v":"Enter the Lab Unit exactly as it appears in APCM."}]
[]
["Calibration Method:",null,"Tex-927-K",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Calibration_Method),\"Select the calibration/verification/standardization procedure used.\",\"\")","v":""}]
[]
["Completed Date:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Completed_Date),\"Enter the actual date the calibration/verification/standardization was performed.\",\"\")","v":"Enter the actual date the calibration/verification/standardization was performed."}]
[]
["Calibration Interval (months):",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Calibration_Interval),\"Enter the interval as per test requirement.\",\"\")","v":"Enter the interval as per test requirement."}]
[]
["Next Due Date:",null,{"$f":"IF(Overall_Status=\"FAIL\",\"N/A\",IF(OR(C16=\"\",C18=\"\"),\"\",(DATE(YEAR(C16),MONTH(C16)+C18,DAY(C16)))))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Next_Due_Date=\"\",\"This field will automatically populate when 'Completed Date' and 'Calibration Interval' have been entered.\",\"\")","v":"This field will automatically populate when 'Completed Date' and 'Calibration Interval' have been entered."}]
[]
["Overall Status:",null,{"$f":"IF(COUNTIF(O38:O43,\"\")=6,\"\", IF(COUNTIF(O38:O43, \"Fail\"), \"Fail\", \"Pass\"))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Overall_Status=\"\",\"This field will automatically populate when filling in values.\",IF(AND(Overall_Status=\"Pass\",Action_Recommended=\"\"),\"No action should be needed at this time.\",IF(AND(Overall_Status=\"Fail\",Action_Recommended=\"\"),\"If equipment fails, the calibration record must be made inactive in APCM.\",\"\")))","v":"This field will automatically populate when filling in values."}]
[]
["Action Recommended:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Overall_Status=\"\",\"'Action Recommended' drop-down menu will become available when 'Overall Status' has been populated.\",IF(Action_Recommended=\"\",\"Please choose a course of action from the drop-down menu.\",\"\"))","v":"'Action Recommended' drop-down menu will become available when 'Overall Status' has been populated."}]
[]
["# of Test temperatures:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Reading),\"Pick the number of test temperatures (from 1 to 6 readings) needed to test.\",\"\")","v":"Pick the number of test temperatures (from 1 to 6 readings) needed to test."}]
[]
["Detailed Results:"]
[]
["Temperature Verification 1:"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(C32= \"˚F\", \"Oven Uniformity,˚F\",\"Oven Uniformity,˚C\")","v":"Oven Uniformity,˚C"},null,null,null,{"$f":"IF(ISBLANK(L31),\"Default ±5 degrees Celcius & ±9 degrees Fahrenheit\",\"\")","v":"Default ±5 degrees Celcius & ±9 degrees Fahrenheit"}]
["Temperature Unit",null,null,null,{"$f":"IF(C32= \"˚F\", \"Oven Set Temperature,˚F\",\"Oven Set Temperature,˚C\")","v":"Oven Set Temperature,˚C"},null,null,null,null,{"$f":"IF(C32= \"˚F\", \"Oven Stability,˚F\",\"Oven Stability,˚C\")","v":"Oven Stability,˚C"},null,null,null,{"$f":"IF(ISBLANK(L32),\"Default ±5 degrees Celcius & ±9 degrees Fahrenheit\",\"\")","v":"Default ±5 degrees Celcius & ±9 degrees Fahrenheit"}]
[]
["Location",{"$f":"IF(C32= \"˚F\", \"Thermometer Reading,˚F\",\"Thermometer Reading,˚C\")","v":"Thermometer Reading,˚C"},null,null,null,null,null,{"$f":"IF(C32= \"˚F\", \"Readings Average,˚F\",\"Readings Average˚C\")","v":"Readings Average˚C"},null,{"$f":"IF(C32= \"˚F\", \"Difference after 20 minutes,˚F\",\"Difference after 20 minutes,˚C\")","v":"Difference after 20 minutes,˚C"},null,{"$f":"IF(C32= \"˚F\", \"Overall Average Temperature,˚F\",\"Overall Average Temperature,˚C\")","v":"Overall Average Temperature,˚C"}]
[null,"Reading 1 ",null,null,"Reading 2 (After 20 minutes)"]
[1,null,null,null,null,null,null,{"$f":"IF(OR(B36=\"\",E36=\"\"),\"\",AVERAGE(B36,E36))","v":""},null,{"$f":"IF(OR(B36=\"\",E36=\"\"),\"\",ABS(E36-B36))","v":""},null,{"$f":"IF(OR(H36=\"\"),\"\",AVERAGE(H36:I44))","v":""}]
[2,null,null,null,null,null,null,{"$f":"IF(OR(B37=\"\",E37=\"\"),\"\",AVERAGE(B37,E37))","v":""},null,{"$f":"IF(OR(B37=\"\",E37=\"\"),\"\",ABS(E37-B37))","v":""},null,null,null,null,"Status"]
[3,null,null,null,null,null,null,{"$f":"IF(OR(B38=\"\",E38=\"\"),\"\",AVERAGE(B38,E38))","v":""},null,{"$f":"IF(OR(B38=\"\",E38=\"\"),\"\",ABS(E38-B38))","v":""},null,null,null,null,{"$f":"IF((COUNTBLANK(B36:B44)+COUNTBLANK(E36:E44))>0,\"\",C47)","v":""}]
[4,null,null,null,null,null,null,"",null,"",null,null,null,null,{"$f":"IF((COUNTBLANK(B57:B65)+COUNTBLANK(E57:E65))>0,\"\",C68)","v":""}]
[5,null,null,null,null,null,null,{"$f":"IF(OR(B40=\"\",E40=\"\"),\"\",AVERAGE(B40,E40))","v":""},null,{"$f":"IF(OR(B40=\"\",E40=\"\"),\"\",ABS(E40-B40))","v":""},null,null,null,null,{"$f":"IF((COUNTBLANK(B78:B86)+COUNTBLANK(E78:E86))>0,\"\",C89)","v":""}]
[6,null,null,null,null,null,null,"",null,"",null,null,null,null,{"$f":"IF((COUNTBLANK(B99:B107)+COUNTBLANK(E99:E107))>0,\"\",C110)","v":""}]
[7,null,null,null,null,null,null,{"$f":"IF(OR(B42=\"\",E42=\"\"),\"\",AVERAGE(B42,E42))","v":""},null,"",null,null,null,null,{"$f":"IF((COUNTBLANK(B120:B128)+COUNTBLANK(E120:E128))>0,\"\",C131)","v":""}]
[8,null,null,null,null,null,null,"",null,"",null,null,null,null,{"$f":"IF((COUNTBLANK(B141:B149)+COUNTBLANK(E141:E149))>0,\"\",C152)","v":""}]
[9,null,null,null,null,null,null,"",null,""]
[null,{"$f":"AVERAGE(B36:D44)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AVERAGE(E36:G44)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AVERAGE(B45,E45)","v":{"$error":"#DIV/0!"}}]
["Average",{"$f":"IFERROR(B45,\"\")","v":""},null,null,{"$f":"IFERROR(E45,\"\")","v":""}]
["Current Pass/Fail",null,{"$f":"_xlfn.IFS(\nOR(AND(COUNTIF(J36:K44, \">\"&L32*2)> 0, L32 > 0),AND(COUNTIF(J36:K44, \"> 10\") > 0, AND(J32 = \"Oven Stability,˚C\",L32 = 0)), AND(COUNTIF(J36:K44, \"> 18\") > 0, AND( J32 = \"Oven Stability,˚F\", L32 = 0))),\"Fail\",\n\nOR(AND(OR(MAX(B36:D44) - MIN(B36:D44) > (L31*2), MAX(E36:G44) - MIN(E36:G44) > (L31*2)), L31 >0 ),AND(OR(MAX(B36:D44) - MIN(B36:D44) > 10, MAX(E36:G44) - MIN(E36:G44) > 10), AND(J31 = \"Oven Uniformity,˚C\",L31 = 0)),AND(OR(MAX(B36:D44) - MIN(B36:D44) > 18, MAX(E36:G44) - MIN(E36:G44) > 18), AND(J31 = \"Oven Uniformity,˚F\",L31 = 0))), \"Fail\", TRUE,\"Pass\")","v":"Pass"},null,{"$f":"_xlfn.IFS(C47=\"Pass\",\"No action should be needed at this time.\",TRUE,\"Please select an action recommended from the drop-down menu.\")","v":"No action should be needed at this time."}]
[{"$f":"IF(C32=\"˚F\",\"Correction ˚F\",\"Correction ˚C\")","v":"Correction ˚C"},null,{"$f":"IFERROR(H45-G32,\"\")","v":""}]
["Based on this reading above (Oven Set Temperature), the oven should be set at:",null,null,null,null,null,{"$f":"IFERROR(G32+(C48*-1),\"\")","v":""}]
[]
["Temperature Verification 2:"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(C53= \"˚F\", \"Oven Uniformity,˚F\",\"Oven Uniformity,˚C\")","v":"Oven Uniformity,˚C"}]
["Temperature Unit",null,null,null,{"$f":"IF(C53= \"˚F\", \"Oven Set Temperature,˚F\",\"Oven Set Temperature,˚C\")","v":"Oven Set Temperature,˚C"},null,null,null,null,{"$f":"IF(C53= \"˚F\", \"Oven Stability,˚F\",\"Oven Stability,˚C\")","v":"Oven Stability,˚C"}]
[]
["Location",{"$f":"IF(C53= \"˚F\", \"Thermometer Reading,˚F\",\"Thermometer Reading,˚C\")","v":"Thermometer Reading,˚C"},null,null,null,null,null,{"$f":"IF(C53= \"˚F\", \"Readings Average,˚F\",\"Readings Average˚C\")","v":"Readings Average˚C"},null,{"$f":"IF(C53= \"˚F\", \"Difference after 20 minutes,˚F\",\"Difference after 20 minutes,˚C\")","v":"Difference after 20 minutes,˚C"},null,{"$f":"IF(C53= \"˚F\", \"Overall Average Temperature,˚F\",\"Overall Average Temperature,˚C\")","v":"Overall Average Temperature,˚C"}]
[null,"Reading 1 ",null,null,"Reading 2 (After 20 minutes)"]
[1,null,null,null,null,null,null,{"$f":"IF(OR(B57=\"\",E57=\"\"),\"\",AVERAGE(B57,E57))","v":""},null,{"$f":"IF(OR(B57=\"\",E57=\"\"),\"\",ABS(E57-B57))","v":""},null,{"$f":"IF(OR(H57=\"\"),\"\",AVERAGE(H57:I65))","v":""}]
[2,null,null,null,null,null,null,{"$f":"IF(OR(B58=\"\",E58=\"\"),\"\",AVERAGE(B58,E58))","v":""},null,{"$f":"IF(OR(B58=\"\",E58=\"\"),\"\",ABS(E58-B58))","v":""}]
[3,null,null,null,null,null,null,{"$f":"IF(OR(B59=\"\",E59=\"\"),\"\",AVERAGE(B59,E59))","v":""},null,{"$f":"IF(OR(B59=\"\",E59=\"\"),\"\",ABS(E59-B59))","v":""}]
[4,null,null,null,null,null,null,"",null,""]
[5,null,null,null,null,null,null,{"$f":"IF(OR(B61=\"\",E61=\"\"),\"\",AVERAGE(B61,E61))","v":""},null,{"$f":"IF(OR(B61=\"\",E61=\"\"),\"\",ABS(E61-B61))","v":""}]
[6,null,null,null,null,null,null,{"$f":"IF(OR(B62=\"\",E62=\"\"),\"\",AVERAGE(B62,E62))","v":""},null,{"$f":"IF(OR(B62=\"\",E62=\"\"),\"\",ABS(E62-B62))","v":""}]
[7,null,null,null,null,null,null,{"$f":"IF(OR(B63=\"\",E63=\"\"),\"\",AVERAGE(B63,E63))","v":""},null,""]
[8,null,null,null,null,null,null,{"$f":"IF(OR(B64=\"\",E64=\"\"),\"\",AVERAGE(B64,E64))","v":""},null,""]
[9,null,null,null,null,null,null,"",null,""]
[null,{"$f":"AVERAGE(B57:D65)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AVERAGE(E57:G65)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AVERAGE(B66,E66)","v":{"$error":"#DIV/0!"}}]
["Average",{"$f":"IFERROR(B66,\"\")","v":""},null,null,{"$f":"IFERROR(E66,\"\")","v":""}]
["Current Pass/Fail",null,{"$f":"_xlfn.IFS(\nOR(AND(COUNTIF(J57:K65, \">\"&L53*2)> 0, L53 > 0),AND(COUNTIF(J57:K65, \"> 10\") > 0, AND(J53 = \"Oven Stability,˚C\",L53 = 0)), AND(COUNTIF(J57:K65, \"> 18\") > 0, AND( J53 = \"Oven Stability,˚F\", L53 = 0))),\"Fail\",\n\nOR(AND(OR(MAX(B57:D65) - MIN(B57:D65) > (L52*2), MAX(E57:G65) - MIN(E57:G65) > (L52*2)), L52 >0 ),AND(OR(MAX(B57:D65) - MIN(B57:D65) > 10, MAX(E57:G65) - MIN(E57:G65) > 10), AND(J52 = \"Oven Uniformity,˚C\",L52 = 0)),AND(OR(MAX(B57:D65) - MIN(B57:D65) > 18, MAX(E57:G65) - MIN(E57:G65) > 18), AND(J52 = \"Oven Uniformity,˚F\",L52 = 0))), \"Fail\", TRUE,\"Pass\")","v":"Pass"},null,{"$f":"_xlfn.IFS(C68=\"Pass\",\"No action should be needed at this time.\",TRUE,\"Please select an action recommended from the drop-down menu.\")","v":"No action should be needed at this time."}]
[{"$f":"IF(C53=\"˚F\",\"Correction ˚F\",\"Correction ˚C\")","v":"Correction ˚C"},null,{"$f":"IFERROR(H66-G53,\"\")","v":""}]
["Based on this reading above (Oven Set Temperature), the oven should be set at:",null,null,null,null,null,{"$f":"IFERROR(G53+(C69*-1),\"\")","v":""}]
[]
["Temperature Verification 3:"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(C74= \"˚F\", \"Oven Uniformity,˚F\",\"Oven Uniformity,˚C\")","v":"Oven Uniformity,˚C"}]
["Temperature Unit",null,null,null,{"$f":"IF(C74= \"˚F\", \"Oven Set Temperature,˚F\",\"Oven Set Temperature,˚C\")","v":"Oven Set Temperature,˚C"},null,null,null,null,{"$f":"IF(C74= \"˚F\", \"Oven Stability,˚F\",\"Oven Stability,˚C\")","v":"Oven Stability,˚C"}]
[]
["Location",{"$f":"IF(C74= \"˚F\", \"Thermometer Reading,˚F\",\"Thermometer Reading,˚C\")","v":"Thermometer Reading,˚C"},null,null,null,null,null,{"$f":"IF(C74= \"˚F\", \"Readings Average,˚F\",\"Readings Average˚C\")","v":"Readings Average˚C"},null,{"$f":"IF(C74= \"˚F\", \"Difference after 20 minutes,˚F\",\"Difference after 20 minutes,˚C\")","v":"Difference after 20 minutes,˚C"},null,{"$f":"IF(C74= \"˚F\", \"Overall Average Temperature,˚F\",\"Overall Average Temperature,˚C\")","v":"Overall Average Temperature,˚C"}]
[null,"Reading 1 ",null,null,"Reading 2 (After 20 minutes)"]
[1,null,null,null,null,null,null,{"$f":"IF(OR(B78=\"\",E78=\"\"),\"\",AVERAGE(B78,E78))","v":""},null,{"$f":"IF(OR(B78=\"\",E78=\"\"),\"\",ABS(E78-B78))","v":""},null,{"$f":"IF(OR(H78=\"\"),\"\",AVERAGE(H78:I86))","v":""}]
[2,null,null,null,null,null,null,{"$f":"IF(OR(B79=\"\",E79=\"\"),\"\",AVERAGE(B79,E79))","v":""},null,{"$f":"IF(OR(B79=\"\",E79=\"\"),\"\",ABS(E79-B79))","v":""}]
[3,null,null,null,null,null,null,{"$f":"IF(OR(B80=\"\",E80=\"\"),\"\",AVERAGE(B80,E80))","v":""},null,{"$f":"IF(OR(B80=\"\",E80=\"\"),\"\",ABS(E80-B80))","v":""}]
[4,null,null,null,null,null,null,"",null,""]
[5,null,null,null,null,null,null,{"$f":"IF(OR(B82=\"\",E82=\"\"),\"\",AVERAGE(B82,E82))","v":""},null,{"$f":"IF(OR(B82=\"\",E82=\"\"),\"\",ABS(E82-B82))","v":""}]
[6,null,null,null,null,null,null,{"$f":"IF(OR(B83=\"\",E83=\"\"),\"\",AVERAGE(B83,E83))","v":""},null,{"$f":"IF(OR(B83=\"\",E83=\"\"),\"\",ABS(E83-B83))","v":""}]
[7,null,null,null,null,null,null,{"$f":"IF(OR(B84=\"\",E84=\"\"),\"\",AVERAGE(B84,E84))","v":""},null,""]
[8,null,null,null,null,null,null,{"$f":"IF(OR(B85=\"\",E85=\"\"),\"\",AVERAGE(B85,E85))","v":""},null,""]
[9,null,null,null,null,null,null,"",null,""]
[null,{"$f":"AVERAGE(B78:D86)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AVERAGE(E78:G86)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AVERAGE(B87,E87)","v":{"$error":"#DIV/0!"}}]
["Average",{"$f":"IFERROR(B87,\"\")","v":""},null,null,{"$f":"IFERROR(E87,\"\")","v":""}]
["Current Pass/Fail",null,{"$f":"_xlfn.IFS(\nOR(AND(COUNTIF(J78:K86, \">\"&L74*2)> 0, L74 > 0),AND(COUNTIF(J78:K86, \"> 10\") > 0, AND(J74 = \"Oven Stability,˚C\",L74 = 0)), AND(COUNTIF(J78:K86, \"> 18\") > 0, AND( J74 = \"Oven Stability,˚F\", L74 = 0))),\"Fail\",\n\nOR(AND(OR(MAX(B78:D86) - MIN(B78:D86) > (L73*2), MAX(E78:G86) - MIN(E78:G86) > (L73*2)), L73 >0 ),AND(OR(MAX(B78:D86) - MIN(B78:D86) > 10, MAX(E78:G86) - MIN(E78:G86) > 10), AND(J73 = \"Oven Uniformity,˚C\",L73 = 0)),AND(OR(MAX(B78:D86) - MIN(B78:D86) > 18, MAX(E78:G86) - MIN(E78:G86) > 18), AND(J73 = \"Oven Uniformity,˚F\",L73 = 0))), \"Fail\", TRUE,\"Pass\")","v":"Pass"},null,{"$f":"_xlfn.IFS(C89=\"Pass\",\"No action should be needed at this time.\",TRUE,\"Please select an action recommended from the drop-down menu.\")","v":"No action should be needed at this time."}]
[{"$f":"IF(C74=\"˚F\",\"Correction ˚F\",\"Correction ˚C\")","v":"Correction ˚C"},null,{"$f":"IFERROR(H87-G74,\"\")","v":""}]
["Based on this reading above (Oven Set Temperature), the oven should be set at:",null,null,null,null,null,{"$f":"IFERROR(G74+(C90*-1),\"\")","v":""}]
[]
["Temperature Verification 4:"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(C95= \"˚F\", \"Oven Uniformity,˚F\",\"Oven Uniformity,˚C\")","v":"Oven Uniformity,˚C"}]
["Temperature Unit",null,null,null,{"$f":"IF(C95= \"˚F\", \"Oven Set Temperature,˚F\",\"Oven Set Temperature,˚C\")","v":"Oven Set Temperature,˚C"},null,null,null,null,{"$f":"IF(C95= \"˚F\", \"Oven Stability,˚F\",\"Oven Stability,˚C\")","v":"Oven Stability,˚C"}]
[]
["Location",{"$f":"IF(C95= \"˚F\", \"Thermometer Reading,˚F\",\"Thermometer Reading,˚C\")","v":"Thermometer Reading,˚C"},null,null,null,null,null,{"$f":"IF(C95= \"˚F\", \"Readings Average,˚F\",\"Readings Average˚C\")","v":"Readings Average˚C"},null,{"$f":"IF(C95= \"˚F\", \"Difference after 20 minutes,˚F\",\"Difference after 20 minutes,˚C\")","v":"Difference after 20 minutes,˚C"},null,{"$f":"IF(C95= \"˚F\", \"Overall Average Temperature,˚F\",\"Overall Average Temperature,˚C\")","v":"Overall Average Temperature,˚C"}]
[null,"Reading 1 ",null,null,"Reading 2 (After 20 minutes)"]
[1,null,null,null,null,null,null,{"$f":"IF(OR(B99=\"\",E99=\"\"),\"\",AVERAGE(B99,E99))","v":""},null,{"$f":"IF(OR(B99=\"\",E99=\"\"),\"\",ABS(E99-B99))","v":""},null,{"$f":"IF(OR(H99=\"\"),\"\",AVERAGE(H99:I107))","v":""}]
[2,null,null,null,null,null,null,{"$f":"IF(OR(B100=\"\",E100=\"\"),\"\",AVERAGE(B100,E100))","v":""},null,{"$f":"IF(OR(B100=\"\",E100=\"\"),\"\",ABS(E100-B100))","v":""}]
[3,null,null,null,null,null,null,{"$f":"IF(OR(B101=\"\",E101=\"\"),\"\",AVERAGE(B101,E101))","v":""},null,{"$f":"IF(OR(B101=\"\",E101=\"\"),\"\",ABS(E101-B101))","v":""}]
[4,null,null,null,null,null,null,"",null,""]
[5,null,null,null,null,null,null,{"$f":"IF(OR(B103=\"\",E103=\"\"),\"\",AVERAGE(B103,E103))","v":""},null,{"$f":"IF(OR(B103=\"\",E103=\"\"),\"\",ABS(E103-B103))","v":""}]
[6,null,null,null,null,null,null,{"$f":"IF(OR(B104=\"\",E104=\"\"),\"\",AVERAGE(B104,E104))","v":""},null,{"$f":"IF(OR(B104=\"\",E104=\"\"),\"\",ABS(E104-B104))","v":""}]
[7,null,null,null,null,null,null,{"$f":"IF(OR(B105=\"\",E105=\"\"),\"\",AVERAGE(B105,E105))","v":""},null,""]
[8,null,null,null,null,null,null,{"$f":"IF(OR(B106=\"\",E106=\"\"),\"\",AVERAGE(B106,E106))","v":""},null,""]
[9,null,null,null,null,null,null,"",null,""]
[null,{"$f":"AVERAGE(B99:D107)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AVERAGE(E99:G107)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AVERAGE(B108,E108)","v":{"$error":"#DIV/0!"}}]
["Average",{"$f":"IFERROR(B108,\"\")","v":""},null,null,{"$f":"IFERROR(E108,\"\")","v":""}]
["Current Pass/Fail",null,{"$f":"_xlfn.IFS(\nOR(AND(COUNTIF(J99:K107, \">\"&L95*2)> 0, L95 > 0),AND(COUNTIF(J99:K107, \"> 10\") > 0, AND(J95 = \"Oven Stability,˚C\",L95 = 0)), AND(COUNTIF(J99:K107, \"> 18\") > 0, AND( J95 = \"Oven Stability,˚F\", L95 = 0))),\"Fail\",\n\nOR(AND(OR(MAX(B99:D107) - MIN(B99:D107) > (L94*2), MAX(E99:G107) - MIN(E99:G107) > (L94*2)), L94 >0 ),AND(OR(MAX(B99:D107) - MIN(B99:D107) > 10, MAX(E99:G107) - MIN(E99:G107) > 10), AND(J94 = \"Oven Uniformity,˚C\",L94 = 0)),AND(OR(MAX(B99:D107) - MIN(B99:D107) > 18, MAX(E99:G107) - MIN(E99:G107) > 18), AND(J94 = \"Oven Uniformity,˚F\",L94 = 0))), \"Fail\", TRUE,\"Pass\")","v":"Pass"},null,{"$f":"_xlfn.IFS(C110=\"Pass\",\"No action should be needed at this time.\",TRUE,\"Please select an action recommended from the drop-down menu.\")","v":"No action should be needed at this time."}]
[{"$f":"IF(C95=\"˚F\",\"Correction ˚F\",\"Correction ˚C\")","v":"Correction ˚C"},null,{"$f":"IFERROR(H108-G95,\"\")","v":""}]
["Based on this reading above (Oven Set Temperature), the oven should be set at:",null,null,null,null,null,{"$f":"IFERROR(G95+(C111*-1),\"\")","v":""}]
[]
["Temperature Verification 5:"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(C116= \"˚F\", \"Oven Uniformity,˚F\",\"Oven Uniformity,˚C\")","v":"Oven Uniformity,˚C"}]
["Temperature Unit",null,null,null,{"$f":"IF(C116= \"˚F\", \"Oven Set Temperature,˚F\",\"Oven Set Temperature,˚C\")","v":"Oven Set Temperature,˚C"},null,null,null,null,{"$f":"IF(C116= \"˚F\", \"Oven Stability,˚F\",\"Oven Stability,˚C\")","v":"Oven Stability,˚C"}]
[]
["Location",{"$f":"IF(C116= \"˚F\", \"Thermometer Reading,˚F\",\"Thermometer Reading,˚C\")","v":"Thermometer Reading,˚C"},null,null,null,null,null,{"$f":"IF(C116= \"˚F\", \"Readings Average,˚F\",\"Readings Average˚C\")","v":"Readings Average˚C"},null,{"$f":"IF(C116= \"˚F\", \"Difference after 20 minutes,˚F\",\"Difference after 20 minutes,˚C\")","v":"Difference after 20 minutes,˚C"},null,{"$f":"IF(C116= \"˚F\", \"Overall Average Temperature,˚F\",\"Overall Average Temperature,˚C\")","v":"Overall Average Temperature,˚C"}]
[null,"Reading 1 ",null,null,"Reading 2 (After 20 minutes)"]
[1,null,null,null,null,null,null,{"$f":"IF(OR(B120=\"\",E120=\"\"),\"\",AVERAGE(B120,E120))","v":""},null,{"$f":"IF(OR(B120=\"\",E120=\"\"),\"\",ABS(E120-B120))","v":""},null,{"$f":"IF(OR(H120=\"\"),\"\",AVERAGE(H120:I128))","v":""}]
[2,null,null,null,null,null,null,{"$f":"IF(OR(B121=\"\",E121=\"\"),\"\",AVERAGE(B121,E121))","v":""},null,{"$f":"IF(OR(B121=\"\",E121=\"\"),\"\",ABS(E121-B121))","v":""}]
[3,null,null,null,null,null,null,{"$f":"IF(OR(B122=\"\",E122=\"\"),\"\",AVERAGE(B122,E122))","v":""},null,{"$f":"IF(OR(B122=\"\",E122=\"\"),\"\",ABS(E122-B122))","v":""}]
[4,null,null,null,null,null,null,"",null,""]
[5,null,null,null,null,null,null,{"$f":"IF(OR(B124=\"\",E124=\"\"),\"\",AVERAGE(B124,E124))","v":""},null,{"$f":"IF(OR(B124=\"\",E124=\"\"),\"\",ABS(E124-B124))","v":""}]
[6,null,null,null,null,null,null,{"$f":"IF(OR(B125=\"\",E125=\"\"),\"\",AVERAGE(B125,E125))","v":""},null,{"$f":"IF(OR(B125=\"\",E125=\"\"),\"\",ABS(E125-B125))","v":""}]
[7,null,null,null,null,null,null,{"$f":"IF(OR(B126=\"\",E126=\"\"),\"\",AVERAGE(B126,E126))","v":""},null,""]
[8,null,null,null,null,null,null,{"$f":"IF(OR(B127=\"\",E127=\"\"),\"\",AVERAGE(B127,E127))","v":""},null,""]
[9,null,null,null,null,null,null,"",null,""]
[null,{"$f":"AVERAGE(B120:D128)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AVERAGE(E120:G128)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AVERAGE(B129,E129)","v":{"$error":"#DIV/0!"}}]
["Average",{"$f":"IFERROR(B129,\"\")","v":""},null,null,{"$f":"IFERROR(E129,\"\")","v":""}]
["Current Pass/Fail",null,{"$f":"_xlfn.IFS(\nOR(AND(COUNTIF(J120:K128, \">\"&L116*2)> 0, L116 > 0),AND(COUNTIF(J120:K128, \"> 10\") > 0, AND(J116 = \"Oven Stability,˚C\",L116 = 0)), AND(COUNTIF(J120:K128, \"> 18\") > 0, AND( J116 = \"Oven Stability,˚F\", L116 = 0))),\"Fail\",\n\nOR(AND(OR(MAX(B120:D128) - MIN(B120:D128) > (L115*2), MAX(E120:G128) - MIN(E120:G128) > (L115*2)), L115 >0 ),AND(OR(MAX(B120:D128) - MIN(B120:D128) > 10, MAX(E120:G128) - MIN(E120:G128) > 10), AND(J115 = \"Oven Uniformity,˚C\",L115 = 0)),AND(OR(MAX(B120:D128) - MIN(B120:D128) > 18, MAX(E120:G128) - MIN(E120:G128) > 18), AND(J115 = \"Oven Uniformity,˚F\",L115 = 0))), \"Fail\", TRUE,\"Pass\")","v":"Pass"},null,{"$f":"_xlfn.IFS(C131=\"Pass\",\"No action should be needed at this time.\",TRUE,\"Please select an action recommended from the drop-down menu.\")","v":"No action should be needed at this time."}]
[{"$f":"IF(C116=\"˚F\",\"Correction ˚F\",\"Correction ˚C\")","v":"Correction ˚C"},null,{"$f":"IFERROR(H129-G116,\"\")","v":""}]
["Based on this reading above (Oven Set Temperature), the oven should be set at:",null,null,null,null,null,{"$f":"IFERROR(G116+(C132*-1),\"\")","v":""}]
[]
["Temperature Verification 6:"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(C137= \"˚F\", \"Oven Uniformity,˚F\",\"Oven Uniformity,˚C\")","v":"Oven Uniformity,˚C"}]
["Temperature Unit",null,null,null,{"$f":"IF(C137= \"˚F\", \"Oven Set Temperature,˚F\",\"Oven Set Temperature,˚C\")","v":"Oven Set Temperature,˚C"},null,null,null,null,{"$f":"IF(C137= \"˚F\", \"Oven Stability,˚F\",\"Oven Stability,˚C\")","v":"Oven Stability,˚C"}]
[]
["Location",{"$f":"IF(C137= \"˚F\", \"Thermometer Reading,˚F\",\"Thermometer Reading,˚C\")","v":"Thermometer Reading,˚C"},null,null,null,null,null,{"$f":"IF(C137= \"˚F\", \"Readings Average,˚F\",\"Readings Average˚C\")","v":"Readings Average˚C"},null,{"$f":"IF(C137= \"˚F\", \"Difference after 20 minutes,˚F\",\"Difference after 20 minutes,˚C\")","v":"Difference after 20 minutes,˚C"},null,{"$f":"IF(C137= \"˚F\", \"Overall Average Temperature,˚F\",\"Overall Average Temperature,˚C\")","v":"Overall Average Temperature,˚C"}]
[null,"Reading 1 ",null,null,"Reading 2 (After 20 minutes)"]
[1,null,null,null,null,null,null,{"$f":"IF(OR(B141=\"\",E141=\"\"),\"\",AVERAGE(B141,E141))","v":""},null,{"$f":"IF(OR(B141=\"\",E141=\"\"),\"\",ABS(E141-B141))","v":""},null,{"$f":"IF(OR(H141=\"\"),\"\",AVERAGE(H141:I149))","v":""}]
[2,null,null,null,null,null,null,{"$f":"IF(OR(B142=\"\",E142=\"\"),\"\",AVERAGE(B142,E142))","v":""},null,{"$f":"IF(OR(B142=\"\",E142=\"\"),\"\",ABS(E142-B142))","v":""}]
[3,null,null,null,null,null,null,{"$f":"IF(OR(B143=\"\",E143=\"\"),\"\",AVERAGE(B143,E143))","v":""},null,{"$f":"IF(OR(B143=\"\",E143=\"\"),\"\",ABS(E143-B143))","v":""}]
[4,null,null,null,null,null,null,"",null,""]
[5,null,null,null,null,null,null,{"$f":"IF(OR(B145=\"\",E145=\"\"),\"\",AVERAGE(B145,E145))","v":""},null,{"$f":"IF(OR(B145=\"\",E145=\"\"),\"\",ABS(E145-B145))","v":""}]
[6,null,null,null,null,null,null,{"$f":"IF(OR(B146=\"\",E146=\"\"),\"\",AVERAGE(B146,E146))","v":""},null,{"$f":"IF(OR(B146=\"\",E146=\"\"),\"\",ABS(E146-B146))","v":""}]
[7,null,null,null,null,null,null,{"$f":"IF(OR(B147=\"\",E147=\"\"),\"\",AVERAGE(B147,E147))","v":""},null,""]
[8,null,null,null,null,null,null,{"$f":"IF(OR(B148=\"\",E148=\"\"),\"\",AVERAGE(B148,E148))","v":""},null,""]
[9,null,null,null,null,null,null,"",null,""]
[null,{"$f":"AVERAGE(B141:D149)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AVERAGE(E141:G149)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AVERAGE(B150,E150)","v":{"$error":"#DIV/0!"}}]
["Average",{"$f":"IFERROR(B150,\"\")","v":""},null,null,{"$f":"IFERROR(E150,\"\")","v":""}]
["Current Pass/Fail",null,{"$f":"_xlfn.IFS(\nOR(AND(COUNTIF(J141:K149, \">\"&L137*2)> 0, L137 > 0),AND(COUNTIF(J141:K149, \"> 10\") > 0, AND(J137 = \"Oven Stability,˚C\",L137 = 0)), AND(COUNTIF(J141:K149, \"> 18\") > 0, AND( J137 = \"Oven Stability,˚F\", L137 = 0))),\"Fail\",\n\nOR(AND(OR(MAX(B141:D149) - MIN(B141:D149) > (L136*2), MAX(E141:G149) - MIN(E141:G149) > (L136*2)), L136 >0 ),AND(OR(MAX(B141:D149) - MIN(B141:D149) > 10, MAX(E141:G149) - MIN(E141:G149) > 10), AND(J136 = \"Oven Uniformity,˚C\",L136 = 0)),AND(OR(MAX(B141:D149) - MIN(B141:D149) > 18, MAX(E141:G149) - MIN(E141:G149) > 18), AND(J136 = \"Oven Uniformity,˚F\",L136 = 0))), \"Fail\", TRUE,\"Pass\")","v":"Pass"},null,{"$f":"_xlfn.IFS(C152=\"Pass\",\"No action should be needed at this time.\",TRUE,\"Please select an action recommended from the drop-down menu.\")","v":"No action should be needed at this time."}]
[{"$f":"IF(C137=\"˚F\",\"Correction ˚F\",\"Correction ˚C\")","v":"Correction ˚C"},null,{"$f":"IFERROR(H150-G137,\"\")","v":""}]
["Based on this reading above (Oven Set Temperature), the oven should be set at:",null,null,null,null,null,{"$f":"IFERROR(G137+(C153*-1),\"\")","v":""}]
[]
[]
["Standard/Reference Equipment:"]
["Equipment",null,"Equipment S/N",null,null,null,null,"Equipment Expiration Date"]
["Thermometer"]
["Timer"]
[]
["Remarks:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Remarks),\"Enter any comments regarding the equipment calibration/verification/standardization. \nComments must be entered for Action Recommended of 'Other' and/or Overall Status of 'Fail'. \nIf no comments are needed, enter 'None'.\",\"\")","v":"Enter any comments regarding the equipment calibration/verification/standardization. \nComments must be entered for Action Recommended of 'Other' and/or Overall Status of 'Fail'. \nIf no comments are needed, enter 'None'."}]
[]
["Authority:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Authority),\"Select the appropriate calibrating authority from the drop-down list.\",\"\")","v":"Select the appropriate calibrating authority from the drop-down list."}]
[]
["MTD Section:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(MTD_Section),\"Enter the MTD Section that performed the calibration/standardization/verification.\",\"\")","v":"Enter the MTD Section that performed the calibration/standardization/verification."}]
[]
["District Lab/Area Office:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(District_Lab_Area_Office),\"Enter the name of the district lab or area office that performed the calibration/standardization/verification.\",\"\")","v":"Enter the name of the district lab or area office that performed the calibration/standardization/verification."}]
[]
["Non-TxDOT/Other Firm:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(C171),\"Enter the name of the third-party entity that performed the calibration/standardization/verification.\",\"\")","v":"Enter the name of the third-party entity that performed the calibration/standardization/verification."}]
[]
["Performed By:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Performed_By),\"Enter the name of the individual who performed the calibration/standardization/verification.\",\"\")","v":"Enter the name of the individual who performed the calibration/standardization/verification."}]
[]
["Reviewed By:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Reviewed_By),\"Enter the name of the individual who reviewed the calibration/standardization/verification record for completeness and accuracy.\",\"\")","v":"Enter the name of the individual who reviewed the calibration/standardization/verification record for completeness and accuracy."}]
[]
["Reviewed Date:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Reviewed_Date),\"Enter the actual date the record was reviewed.\",IF(Reviewed_Date<Completed_Date,\"Reviewed Date must be after Completed Date.\",\"\"))","v":"Enter the actual date the record was reviewed."}]

{"sheet":"Lists","index":1,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
["Status","Pass","Fail","Authority","MTD Sections","Calibration_Method",null,"Date Range"]
["Pass","None","Repair","Materials and Tests Division","Rigid Pavements","Tex-198-E",null,"2000-01-01"]
["Fail","Other (See Remarks)","Replace","District Lab/Area Office","Flexible Pavements","Tex-237-F",null,"2100-01-01"]
[null,null,"Other (See Remarks)","Non-TxDOT/Other","Soils & Aggregates","Tex-498-A"]
[null,null,null,null,"Coatings, Calibration, & Traffic Materials","Tex-900-K"]
[null,null,null,null,null,"Tex-901-K"]
[null,null,null,null,null,"Tex-902-K"]
[null,null,null,null,null,"Tex-903-K"]
[null,null,null,null,null,"Tex-905-K"]
[null,null,null,null,null,"Tex-907-K"]
[null,null,null,null,null,"Tex-909-K"]
[null,null,null,null,null,"Tex-911-K"]
[null,null,null,null,null,"Tex-913-K"]
[null,null,null,null,null,"Tex-914-K"]
[null,null,null,null,null,"Tex-916-K"]
[null,null,null,null,null,"Tex-920-K"]
[null,null,null,null,null,"Tex-921-K"]
[null,null,null,null,null,"Tex-922-K"]
[null,null,null,null,null,"Tex-923-K"]
[null,null,null,null,null,"Tex-924-K"]
[null,null,null,null,null,"Tex-925-K"]
[null,null,null,null,null,"Tex-926-K"]
[null,null,null,null,null,"Tex-927-K"]
[null,null,null,null,null,"Tex-930-K"]
[null,null,null,null,null,"AASHTO R28"]
[null,null,null,null,null,"AASHTO T202"]
[null,null,null,null,null,"AASHTO T228"]
[null,null,null,null,null,"AASHTO T240"]
[null,null,null,null,null,"AASHTO T313"]
[null,null,null,null,null,"AASHTO T315"]
[null,null,null,null,null,"AASHTO T316"]
[null,null,null,null,null,"AASHTO T48"]
[null,null,null,null,null,"AASHTO T49"]
[null,null,null,null,null,"AASHTO T50"]
[null,null,null,null,null,"AASHTO T51"]
[null,null,null,null,null,"AASHTO T53"]
[null,null,null,null,null,"AASHTO T59"]
[null,null,null,null,null,"ASME B40"]
[null,null,null,null,null,"ASME B89"]
[null,null,null,null,null,"ASTM C109"]
[null,null,null,null,null,"ASTM C1231"]
[null,null,null,null,null,"ASTM C143"]
[null,null,null,null,null,"ASTM C151"]
[null,null,null,null,null,"ASTM C1702"]
[null,null,null,null,null,"ASTM C173"]
[null,null,null,null,null,"ASTM C174"]
[null,null,null,null,null,"ASTM C192"]
[null,null,null,null,null,"ASTM C204"]
[null,null,null,null,null,"ASTM C231"]
[null,null,null,null,null,"ASTM C430"]
[null,null,null,null,null,"ASTM C511"]
[null,null,null,null,null,"ASTM C604"]
[null,null,null,null,null,"ASTM C617"]
[null,null,null,null,null,"ASTM C78"]
[null,null,null,null,null,"ASTM D4237"]
[null,null,null,null,null,"ASTM C6084"]
[null,null,null,null,null,"ASTM E10"]
[null,null,null,null,null,"ASTM E18"]
[null,null,null,null,null,"ASTM E2309"]
[null,null,null,null,null,"ASTM E4"]
[null,null,null,null,null,"ASTM E83"]
[null,null,null,null,null,"EXT - External Calibration"]
[null,null,null,null,null,"NA - Not Applicable"]
[null,null,null,null,null,"SS - Supplier's Standard"]

{"sheet":"Revision History","index":2,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Revision Date","Revision Description","Authorized By"]
["2023-03-02","Added a correction temperature value. ","Vincent L."]
["2023-03-28","Revised format and functionality.","A. Melton"]