{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Inactive Record","Revision History","Lists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":18,"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":"Inactive Record","index":0,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":false,"merged":[[16,0,16,11],[30,0,30,1],[28,0,28,1],[26,0,26,1],[24,0,24,1],[22,0,22,1],[20,0,20,1],[18,0,18,1],[30,2,30,11],[18,2,18,11],[26,2,26,11],[28,2,28,11],[22,2,22,11],[24,2,24,11],[20,2,20,11],[2,0,2,11],[0,0,0,11],[1,0,1,11],[11,2,11,11],[5,2,5,11],[7,2,7,11],[9,2,9,11],[13,2,13,11],[3,2,3,11],[11,0,11,1],[9,0,9,1],[7,0,7,1],[5,0,5,1],[3,0,3,1],[13,0,13,1]]}
["Texas Department of Transportation"]
["Inactive Equipment Record"]
[{"$f":"IF(OR(ISBLANK(Serial_Number),ISBLANK(Model_Number),ISBLANK(Description),ISBLANK(Manufacturer_Name),ISBLANK(Lab_Unit),ISBLANK(Inactive_Date),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."}]
[]
["Inactive Date:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Inactive_Date),\"Enter the date that the equipment was made inactive.\",\"\")","v":"Enter the date that the equipment was made inactive."}]
[]
["Remarks:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Remarks),\"Enter comments explaining the reason that the equipment was made inactive. If known, include the anticipated timerame for placing the equipment back into active status.\",\"\")","v":"Enter comments explaining the reason that the equipment was made inactive. If known, include the anticipated timerame for placing the equipment back into active status."}]
[]
["Authority:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Authority),\"Select the appropriate authority from the drop-down list.\",\"\")","v":"Select the appropriate 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 completed the inactive record.\",\"\")","v":"Enter the MTD Section that completed the inactive record."}]
[]
["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 completed the inactive record.\",\"\")","v":"Enter the name of the district lab or area office that completed the inactive record."}]
[]
["Non-TxDOT/Other Firm:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(C25),\"Enter the name of the third-party entity that completed the inactive record.\",\"\")","v":"Enter the name of the third-party entity that completed the inactive record."}]
[]
["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 completed the inactive record.\",\"\")","v":"Enter the name of the individual who completed the inactive record."}]
[]
["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 inactive record for completeness and accuracy.\",\"\")","v":"Enter the name of the individual who reviewed the inactive 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<Inactive_Date,\"Reviewed Date must be after Inactive Date.\",\"\"))","v":"Enter the actual date the record was reviewed."}]

{"sheet":"Revision History","index":1,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Revision Date","Revision Description","Revised By"]
["2023-02-05","Updated to new template format.","A. Melton"]

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