{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calibration Template","Revision History","Lists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":37,"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":110,"n_cols":15,"rows_kept":110,"cut":false,"hidden":false,"merged":[[109,3,109,12],[101,0,101,12],[87,1,87,4],[88,2,88,4],[89,2,89,4],[90,2,90,4],[103,3,103,12],[86,7,87,9],[97,8,97,12],[93,0,93,3],[94,3,94,7],[94,8,94,12],[95,3,95,7],[105,3,105,12],[107,3,107,12],[98,3,98,7],[98,8,98,12],[95,8,95,12],[96,3,96,7],[109,0,109,2],[107,0,107,2],[105,0,105,2],[103,0,103,2],[98,0,98,2],[81,1,81,4],[82,2,82,4],[83,2,83,4],[84,2,84,4],[86,1,86,4],[96,8,96,12],[97,3,97,7],[82,7,82,9],[83,7,83,9],[84,7,84,9],[88,7,88,9],[89,7,89,9],[90,7,90,9],[97,0,97,2],[96,0,96,2],[95,0,95,2],[94,0,94,2],[80,7,81,9],[27,3,27,12],[25,3,25,12],[44,1,44,3],[45,1,45,3],[45,6,45,7],[45,8,45,9],[40,1,40,4],[47,6,47,7],[80,1,80,4],[32,1,32,2],[30,2,30,6],[32,3,32,6],[46,6,46,7],[46,1,46,3],[47,2,47,3],[60,2,60,4],[44,4,44,9],[15,3,15,12],[27,0,27,2],[25,0,25,2],[59,2,59,4],[51,1,51,4],[52,1,52,4],[53,2,53,4],[54,2,54,4],[55,2,55,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[37,1,37,4],[53,7,53,9],[54,7,54,9],[55,7,55,9],[61,2,61,4],[57,7,58,9],[57,1,57,4],[58,1,58,4],[51,7,52,9],[48,2,48,3],[49,1,49,3],[45,4,45,5],[46,4,46,5],[47,4,47,5],[48,4,48,5],[49,4,49,5],[48,6,48,7],[49,6,49,7],[48,8,48,9],[49,8,49,9],[60,7,60,9],[61,7,61,9],[59,7,59,9],[46,8,46,9],[47,8,47,9],[2,0,2,12],[17,3,17,12],[0,0,0,12],[1,0,1,12],[23,3,23,12],[19,3,19,12],[3,3,3,12],[23,0,23,2],[21,0,21,2],[17,0,17,2],[19,0,19,2],[13,0,13,2],[11,0,11,2],[9,0,9,2],[7,0,7,2],[5,0,5,2],[13,3,13,12],[11,3,11,12],[21,3,21,12],[5,3,5,12],[3,0,3,2],[15,0,15,2],[7,3,7,12],[9,3,9,12],[72,1,72,6],[73,1,73,2],[73,3,73,4],[73,5,73,6],[64,1,64,7],[65,1,65,7],[66,1,66,7],[68,1,68,2],[68,3,68,7],[69,1,69,2],[69,3,69,7]]}
["Texas Department of Transportation"]
["SHRP MOLD VERIFICATION"]
[{"$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),ISBLANK(Static_Calibration),AND(Static_Calibration=\"Yes\",ISBLANK(Static_Date))),\"***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,null,{"$f":"IF(A3=\"\",\"\",\"Instructions\")","v":"Instructions"}]
["Serial Number:",null,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,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,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,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,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,null,"Tex-237-F",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Calibration_Method),\"Select the calibration/verification/standardization procedure used.\",\"\")","v":""}]
[]
["Static Calibration:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Static_Calibration),\"Identify whether a static calibration date is used.\",\"\")","v":"Identify whether a static calibration date is used."}]
[]
["Static Date:",null,null,"2024-04-15",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Static_Date),\"Enter the static calibration date for the equipment.\",\"\")","v":""}]
[]
["Completed Date:",null,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.\",IF(OR(ISBLANK(Static_Date),ISBLANK(Static_Calibration),Static_Calibration=\"No\"),\"\",IF(Completed_Date>Static_Date,\"Completed Date cannot be after Static Date.\",IF(Completed_Date<(Static_Date-14),\"Completed Date cannot be more than 2 weeks earlier than Static Date.\",\"\"))))","v":"Enter the actual date the calibration/verification/standardization was performed."}]
[]
["Calibration Interval (months):",null,null,12]
[]
["Next Due Date:",null,null,{"$f":"IF(Overall_Status=\"Fail\",\"N/A\",IF(OR(ISBLANK(Static_Calibration),AND(Static_Calibration=\"Yes\",ISBLANK(Static_Date))),\"\",IF(AND(Static_Calibration=\"No\",ISBLANK(Completed_Date)),\"\",IF(Static_Calibration=\"Yes\",DATE(YEAR(D18),MONTH(D18)+D22,DAY(D18)),DATE(YEAR(D20),MONTH(D20)+D22,DAY(D20))))))","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Next_Due_Date=\"N/A\",\"\",IF(ISBLANK(Static_Calibration),\"This field will automatically populate based on dates entered.\",IF(Static_Calibration=\"Yes\",IF(ISBLANK(Static_Date),\"This field will automatically populate based on 'Static Date' entered.\",\"\"),IF(Static_Calibration=\"No\",IF(ISBLANK(Completed_Date),\"This field will automatically populate based on 'Completed Date' entered.\",\"\"),\"\"))))","v":"This field will automatically populate based on dates entered."}]
[]
["Overall Status:",null,null,null,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":"Select the appropriate status from the drop-down list. If equipment fails, the equipment record must be made inactive in APCM."}]
[]
["Action Recommended:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Action_Recommended),\"Select the appropriate action from the drop-down list.\",\"\")","v":"Select the appropriate action from the drop-down list."}]
[]
["Detailed Results:"]
[null,"SHRP Type:","SHRP Gyratory Troxler Compactor"]
[]
[null,"Measurement Type:",null,"Bore"]
[]
[null,"Mold free of gouges and extreme wear?"]
[null,"Mold plate free of gouges and extreme wear?"]
[null,"Mold plate plane?"]
[null,"Mold thickness greater than 7.5 mm?"]
[]
[null,"MOLD HEIGHT"]
[null,"Must be between 149.50 and 150.20 mm"]
[null,1,2,3,4,"Average"]
[null,null,null,null,null,{"$f":"IFERROR(AVERAGE(B43:E43),\"\")","v":""}]
[]
[null,"Minimum: 149.90  Maximum: 150.20",null,null,"MOLD DIAMETER VERIFICATION READINGS"]
[null,null,null,null,"BOTTOM",null,"MIDDLE",null,"TOP"]
[null,"Dial Gauge Reference:"]
[null,"149.90 mm"]
[null,"150.20 mm"]
[]
[]
[null,"Minimum: 149.50mm     Maximum:149.75mm",null,null,null,null,null,"TOP MOLD PLATE THICKNESS (mm)"]
[null,"TOP MOLD PLATE DIAMETER (mm)"]
[null,"A",null,null,null,null,"A"]
[null,"B",null,null,null,null,"B"]
[null,"Plate S/N",null,null,null,null,"C"]
[]
[null,"Minimum: 149.50mm     Maximum:149.75mm",null,null,null,null,null,"BOTTOM MOLD PLATE THICKNESS (mm)"]
[null,"BOTTOM MOLD PLATE DIAMETER (mm)"]
[null,"A",null,null,null,null,"A"]
[null,"B",null,null,null,null,"B"]
[null,"Plate S/N",null,null,null,null,"C"]
[]
[]
[null,"Standards:"]
[null,"Q-Cut Master 150.00 mm Z-ring, ID 15868"]
[null,"Mitutoyo HTD-6\"R, S/N 202063"]
[]
[null,"Master Ring Size:",null,"150 mm"]
[null,"Mold Diameter:",null,"Minimum = 149.90 mm  Maximum = 150.20 mm"]
[]
[]
[null,"MOLD DIAMETER VERIFICATION READINGS (mm)"]
[null,"1-a,b,c",null,"2-a,b,c",null,"3-a,b,c"]
[null,"Bore Reading","Diameter","Bore Reading","Diameter","Bore Reading","Diameter"]
[null,null,{"$f":"IF(ISBLANK(B76),\"\",B76+SUBSTITUTE($D$69,\"mm\",\"\"))","v":""},null,{"$f":"IF(ISBLANK(D76),\"\",D76+SUBSTITUTE($D$69,\"mm\",\"\"))","v":""},null,{"$f":"IF(ISBLANK(F76),\"\",F76+SUBSTITUTE($D$69,\"mm\",\"\"))","v":""}]
[null,null,{"$f":"IF(ISBLANK(B77),\"\",B77+SUBSTITUTE($D$69,\"mm\",\"\"))","v":""},null,{"$f":"IF(ISBLANK(D77),\"\",D77+SUBSTITUTE($D$69,\"mm\",\"\"))","v":""},null,{"$f":"IF(ISBLANK(F77),\"\",F77+SUBSTITUTE($D$69,\"mm\",\"\"))","v":""}]
[null,null,"",null,"",null,""]
[]
[]
[null,"Minimum: 149.50mm     Maximum:149.75mm",null,null,null,null,null,"TOP MOLD PLATE THICKNESS (mm)"]
[null,"TOP MOLD PLATE DIAMETER (mm)"]
[null,"A",null,null,null,null,"A"]
[null,"B",null,null,null,null,"B"]
[null,"Plate S/N",null,null,null,null,"C"]
[]
[null,"Minimum: 149.50mm     Maximum:149.75mm",null,null,null,null,null,"BOTTOM MOLD PLATE THICKNESS (mm)"]
[null,"BOTTOM MOLD PLATE DIAMETER (mm)"]
[null,"A",null,null,null,null,"A"]
[null,"B",null,null,null,null,"B"]
[null,"Plate S/N",null,null,null,null,"C"]
[]
[]
["Standard/Reference Equipment:"]
["Equipment",null,null,"Equipment ID",null,null,null,null,"Equipment Expiration"]
["Reference Equipment 1"]
["Reference Equipment 2"]
["Reference Equipment 3"]
["Reference Equipment 4"]
[]
["Remarks:"]
[null,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,"Materials and Tests Division - Metrology Lab"]
[]
["Performed By:",null,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,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,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":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Revision Date","Revision Description","Revised By"]
["2023-06-20","Updated to new template format, condensed to one sheet","ACD"]
["2023-06-23","Added new criteria to conform to AASHTO specifications","ACD"]
["2023-08-25","Mold height tolerance was removed","SJV"]
["2023-08-25","Conditional formating was added to C31 AND D33","SJV"]
["2023-10-23","Top plate and bottom plate thickness cells were merged and centered","SJV"]
["2024-03-21","Heading was updated, some of the protected cells were updated","SJV"]
["2024-03-21","Blank field forumula was updated","SJV"]

{"sheet":"Lists","index":2,"n_rows":64,"n_cols":11,"rows_kept":64,"cut":false,"hidden":true,"merged":[]}
["Status List",null,"Pass",null,"Fail",null,"Calibration_Method",null,"Completed Date",null,"Static Date"]
["Pass",null,"None",null,"Repair",null,"Tex-198-E",null,"2000-01-01",null,"2000-01-01"]
["Fail",null,"Other (See Remarks)",null,"Replace",null,"Tex-237-F",null,"2100-01-01",null,"2100-01-01"]
[null,null,null,null,"Other (See Remarks)",null,"Tex-498-A"]
[null,null,null,null,null,null,"Tex-900-K"]
[null,null,null,null,null,null,"Tex-901-K"]
[null,null,null,null,null,null,"Tex-902-K"]
[null,null,null,null,null,null,"Tex-903-K"]
[null,null,null,null,null,null,"Tex-905-K"]
[null,null,null,null,null,null,"Tex-907-K"]
[null,null,null,null,null,null,"Tex-909-K"]
[null,null,null,null,null,null,"Tex-911-K"]
[null,null,null,null,null,null,"Tex-913-K"]
[null,null,null,null,null,null,"Tex-914-K"]
[null,null,null,null,null,null,"Tex-916-K"]
[null,null,null,null,null,null,"Tex-920-K"]
[null,null,null,null,null,null,"Tex-921-K"]
[null,null,null,null,null,null,"Tex-922-K"]
[null,null,null,null,null,null,"Tex-923-K"]
[null,null,null,null,null,null,"Tex-924-K"]
[null,null,null,null,null,null,"Tex-925-K"]
[null,null,null,null,null,null,"Tex-926-K"]
[null,null,null,null,null,null,"Tex-927-K"]
[null,null,null,null,null,null,"Tex-930-K"]
[null,null,null,null,null,null,"AASHTO R28"]
[null,null,null,null,null,null,"AASHTO T202"]
[null,null,null,null,null,null,"AASHTO T228"]
[null,null,null,null,null,null,"AASHTO T240"]
[null,null,null,null,null,null,"AASHTO T313"]
[null,null,null,null,null,null,"AASHTO T315"]
[null,null,null,null,null,null,"AASHTO T316"]
[null,null,null,null,null,null,"AASHTO T48"]
[null,null,null,null,null,null,"AASHTO T49"]
[null,null,null,null,null,null,"AASHTO T50"]
[null,null,null,null,null,null,"AASHTO T51"]
[null,null,null,null,null,null,"AASHTO T53"]
[null,null,null,null,null,null,"AASHTO T59"]
[null,null,null,null,null,null,"ASME B40"]
[null,null,null,null,null,null,"ASME B89"]
[null,null,null,null,null,null,"ASTM C109"]
[null,null,null,null,null,null,"ASTM C1231"]
[null,null,null,null,null,null,"ASTM C143"]
[null,null,null,null,null,null,"ASTM C151"]
[null,null,null,null,null,null,"ASTM C1702"]
[null,null,null,null,null,null,"ASTM C173"]
[null,null,null,null,null,null,"ASTM C174"]
[null,null,null,null,null,null,"ASTM C192"]
[null,null,null,null,null,null,"ASTM C204"]
[null,null,null,null,null,null,"ASTM C231"]
[null,null,null,null,null,null,"ASTM C430"]
[null,null,null,null,null,null,"ASTM C511"]
[null,null,null,null,null,null,"ASTM C604"]
[null,null,null,null,null,null,"ASTM C617"]
[null,null,null,null,null,null,"ASTM C78"]
[null,null,null,null,null,null,"ASTM D4237"]
[null,null,null,null,null,null,"ASTM C6084"]
[null,null,null,null,null,null,"ASTM E10"]
[null,null,null,null,null,null,"ASTM E18"]
[null,null,null,null,null,null,"ASTM E2309"]
[null,null,null,null,null,null,"ASTM E4"]
[null,null,null,null,null,null,"ASTM E83"]
[null,null,null,null,null,null,"EXT - External Calibration"]
[null,null,null,null,null,null,"NA - Not Applicable"]
[null,null,null,null,null,null,"SS - Supplier's Standard"]