{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Calibration Template","Revision History ","Revision History","Lists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":92,"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":"Calibration Template","index":0,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[44,1,46,3],[44,4,46,7],[44,8,46,9],[47,1,49,3],[47,4,49,7],[47,8,49,9],[42,1,42,9],[43,1,43,3],[43,4,43,7],[43,8,43,9],[13,0,13,1],[37,1,39,3],[37,4,39,7],[37,8,39,9],[27,1,27,9],[33,1,33,3],[33,4,33,7],[33,8,33,9],[34,1,36,3],[34,4,36,7],[34,8,36,9],[28,1,28,3],[11,0,11,1],[9,0,9,1],[23,2,23,11],[21,0,21,1],[19,0,19,1],[17,0,17,1],[9,2,9,11],[19,2,19,11],[15,2,15,11],[15,0,15,1],[21,2,21,11],[13,2,13,11],[11,2,11,11],[17,2,17,11],[23,0,23,1],[0,0,0,11],[1,0,1,11],[3,2,3,11],[7,0,7,1],[5,0,5,1],[5,2,5,11],[7,2,7,11],[3,0,3,1],[2,0,2,11],[29,1,29,3],[28,4,28,7],[29,4,29,7],[31,1,31,9],[64,0,64,1],[52,0,52,1],[53,2,53,6],[54,2,54,6],[64,2,64,11],[53,7,53,11],[54,7,54,11],[62,2,62,11],[58,0,58,11],[62,0,62,1],[60,0,60,1],[60,2,60,11],[54,0,54,1],[53,0,53,1],[61,0,61,11],[72,2,72,11],[72,0,72,1],[70,0,70,1],[68,0,68,1],[66,0,66,1],[68,2,68,11],[70,2,70,11],[66,2,66,11]]}
["Texas Department of Transportation"]
["Standardization of Concrete Dial Thermometer"]
[{"$f":"IF(OR(ISBLANK(_xlfn.SINGLE(Ref_Resolution)),ISBLANK(Test_Resolution),ISBLANK(Ref_Ther_Reading_1),ISBLANK(Test_Ther_Reading_1),ISBLANK(Ref_Ther_Reading_2),ISBLANK(Test_Ther_Reading_2),ISBLANK(APCM_Serial_Number),ISBLANK(Equipment_Expiration),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. SN must correspond to the physical piece of equipment.\",\"\")","v":"Enter Serial Number exactly as it appears in APCM. SN must correspond to the physical piece of equipment."}]
[]
["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,"ASTM C1064",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,12]
[]
["Next Due Date:",null,{"$f":"IF(Overall_Status=\"FAIL\",\"N/A\",IF(C16=\"\",\"\",(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' has been entered.\",\"\")","v":"This field will automatically populate when 'Completed Date' has been entered."}]
[]
["Overall Status:",null,{"$f":"IF(OR(As_Left_Error_1 <= -1.0999999999, As_Left_Error_1 >= 1.0999999999, As_Left_Error_2 <= -1.0999999999, As_Left_Error_2 >= 1.0999999999, Test_Resolution > 1), \"Fail\", IF(AND(As_Left_Error_1 > -1.0999999999, As_Left_Error_1 < 1.0999999999, As_Left_Error_2 > -1.0999999999, As_Left_Error_2 < 1.0999999999), \"Pass\", \"\"))","v":"Pass"},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Overall_Status),\"Select the appropriate status from the drop-down list. If equipment fails, the equipment record must be made inactive in APCM.\",\"\")","v":""}]
[]
["Action Recommended:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Action_Recommended),\"Ensure that 'Overall Status' has been selected, then select the appropriate action from the drop-down list.\",\"\")","v":"Ensure that 'Overall Status' has been selected, then select the appropriate action from the drop-down list."}]
[]
["Detailed Results:"]
[]
[null,"The two temperature points must be atleast 30°F apart. The max tolerance is +/- 1°F."]
[null,"Reference Thermometer Resolution",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Ref_Resolution),\"Reference Thermometer Resolution must be greater than 0 and less than or equal to 0.5\",\"\")","v":"Reference Thermometer Resolution must be greater than 0 and less than or equal to 0.5"}]
[null,"Test Thermometer Resolution",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Test_Resolution),\"Test Thermometer Resolution must be greater than 0 and less than or equal to 1.0\",\"\")","v":"Test Thermometer Resolution must be greater than 0 and less than or equal to 1.0"}]
[]
[null,"As Found"]
[]
[null,"Reference Thermometer Reading (°F)",null,null,"Test Thermometer Reading (°F)",null,null,null,"Error (°F)"]
[null,null,null,null,null,null,null,null,{"$f":"E35-B35","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"E38-B38","v":0}]
[]
[]
[]
[]
[null,"As Left"]
[null,"Reference Thermometer Reading (°F)",null,null,"Test Thermometer Reading (°F)",null,null,null,"Error (°F)"]
[null,null,null,null,null,null,null,null,{"$f":"E45-B45","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"E48-B48","v":0}]
[]
[]
[]
[]
["Standard/Reference Equipment:"]
["Equipment",null,"APCM Serial Number",null,null,null,null,"Equipment Expiration"]
["Reference Equipment 1"]
[]
[]
["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/verification/standardization.\",\"\")","v":"Enter the MTD Section that performed the calibration/verification/standardization."}]
[]
["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/verification/standardization.\",\"\")","v":"Enter the name of the district lab or area office that performed the calibration/verification/standardization."}]
[]
["Non-TxDOT/Other Firm:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(C67),\"Enter the name of the third-party entity that performed the calibration/verification/standardization.\",\"\")","v":"Enter the name of the third-party entity that performed the calibration/verification/standardization."}]
[]
["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/verification/standardization.\",\"\")","v":"Enter the name of the individual who performed the calibration/verification/standardization."}]
[]
["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 record for completeness and accuracy.\",\"\")","v":"Enter the name of the individual who reviewed the 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":"Revision History ","index":1,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Revision Date","Revision Description","Authorized By"]
["2024-07-09","Template was created","SJV"]
["2025-03-24","Macros were updated","SJV"]
["2025-04-29","Revision history sheet was added ","SJV"]
["2025-05-23","Title was updated","SJV"]

{"sheet":"Revision History","index":2,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Revision Date","Revision Description","Revised By"]
["2024-04-08","Template Creation","SIMON"]

{"sheet":"Lists","index":3,"n_rows":65,"n_cols":8,"rows_kept":65,"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 C1064"]
[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"]