{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calibration Template","Revision History","Lists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":36,"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":134,"n_cols":14,"rows_kept":134,"cut":false,"hidden":false,"merged":[[13,2,13,11],[11,2,11,11],[21,2,21,11],[32,0,32,7],[33,0,33,3],[33,4,34,5],[33,6,34,6],[34,0,34,3],[13,0,13,1],[11,0,11,1],[29,1,29,2],[15,0,15,1],[17,0,17,1],[15,2,15,11],[17,2,17,11],[7,0,7,1],[5,0,5,1],[3,0,3,1],[2,0,2,11],[0,0,0,11],[1,0,1,11],[3,2,3,11],[5,2,5,11],[7,2,7,11],[9,0,9,1],[27,2,27,11],[121,2,121,11],[116,0,116,1],[115,0,115,1],[114,0,114,1],[113,0,113,1],[112,0,112,1],[27,0,27,1],[25,0,25,1],[23,0,23,1],[21,0,21,1],[9,2,9,11],[23,2,23,11],[19,2,19,11],[19,0,19,1],[133,2,133,11],[133,0,133,1],[131,0,131,1],[129,0,129,1],[129,2,129,11],[131,2,131,11],[121,0,121,1],[62,7,63,7],[25,2,25,11],[111,0,111,1],[114,2,114,6],[115,2,115,6],[114,7,114,11],[115,7,115,11],[112,2,112,6],[113,2,113,6],[112,7,112,11],[106,0,106,1],[62,2,63,3],[62,4,63,4],[62,5,63,5],[113,7,113,11],[116,7,116,11],[116,2,116,6],[62,6,63,6],[119,0,119,11],[47,0,47,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[53,0,53,1],[43,0,45,1],[37,6,38,6],[39,4,39,5],[39,6,42,6],[40,2,41,2],[40,3,41,3],[40,4,41,5],[42,4,42,5],[43,4,44,4],[37,2,38,2],[37,3,38,3],[37,4,38,5],[43,2,45,3],[123,0,123,1],[123,2,123,11],[125,0,125,1],[125,2,125,11],[127,0,127,1],[127,2,127,11]]}
["Texas Department of Transportation"]
["Calibration Record of Superpave Gyratory Compactor"]
[{"$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. 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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Calibration_Method),\"Select the calibration/verification/standardization procedure used.\",\"\")","v":"Select the calibration/verification/standardization procedure used."}]
[]
["Static Calibration:",null,"Yes",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Static_Calibration),\"Identify whether a static calibration date is used.\",\"\")","v":""}]
[]
["Static Date:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(Static_Date),\"Enter the static calibration date for the equipment.\",\"\")","v":"Enter the static calibration date for the equipment."}]
[]
["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(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(C18),MONTH(C18)+C22,DAY(C18)),DATE(YEAR(C20),MONTH(C20)+C22,DAY(C20))))))","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,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,{"$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."}]
[]
["SHRP Type:","SHRP Gyratory Troxler Compactor"]
[]
["Detailed Results:"]
[]
["Speed of Gyration:",null,null,null,"30 ± 0.5 Gyrations in 1 minute"]
["Number of Gyrations in 1 Minute:"]
[]
["Internal Angle Verification:"]
["Top Plate Mold",null,"Run 1 Reading","Run 2 Reading","Average Value",null,"AVG. of Top & Bottom"]
["10 Gyrations At"]
["600 Kpa Pressure",null,null,null,{"$f":"IF(ISERROR(AVERAGE(C40:D40)),\"\",AVERAGE(C40:D40))","v":""},null,{"$f":"IF(ISERROR(AVERAGE(E40,E43)),\"\",AVERAGE(E40,E43))","v":""}]
["Bottom Plate Mold",null,"Run 1 Reading","Run 2 Reading","Average Value"]
["10 Gyrations At"]
["600 Kpa Pressure",null,null,null,{"$f":"IF(ISERROR(AVERAGE(C43:D43)),\"\",AVERAGE(C43:D43))","v":""}]
["Expected Nominal Value",null,{"$f":"IF(Type=\"SHRP Gyratory Brovold Compactor\",\"1.19°±  0.02°\",\"1.16°± 0.02°\")","v":"1.16°± 0.02°"}]
[null,null,null,null,null,null,""]
[]
[]
["Height Verification:",null,null,null,"Place the gauge block into the chamber, oriented for 6 in (152.4 mm)."]
["Target Height (in)",null,"Ht. Displayed","DIFF. (in)"]
[3,null,null,{"$f":"IF(C50=\"\",\"\",ABS(C50-A50))","v":""}]
[4,null,null,""]
[5,null,null,""]
[6,null,null,""]
[7,null,null,""]
[8,null,null,""]
[9,null,null,""]
[10,null,null,""]
[]
["Note: Calibrate if height differs by ±0.004 in (0.1 mm)"]
[]
["Load Calibration: (* Dead load calibration points.)"]
[]
["True Load","Readout","1% of Readout",null,"Run","Run","Average Values","Percent Error"]
["Newtons","Value"]
[null,null,"Minimum","Maximum",1,2]
["*1,500",null,{"$f":"B66*0.99","v":0},{"$f":"B66*1.01","v":0},null,null,{"$f":"IF(ISERROR(AVERAGE(E66:F66)),\"\",AVERAGE(E66:F66))","v":""},{"$f":"IF(ISERROR(100*((B66-G66)/B66)),\"\",100*((B66-G66)/B66))","v":""}]
[2000,null,0,0,null,null,"",""]
[2500,null,0,0,null,null,"",""]
["*3,000",null,0,0,null,null,"",""]
[3500,null,0,0,null,null,"",""]
[4000,null,0,0,null,null,"",""]
[4500,null,0,0,null,null,"",""]
["*5,000",null,0,0,null,null,"",""]
[5500,null,0,0,null,null,"",""]
["*6,000",null,0,0,null,null,"",""]
[6500,null,0,0,null,null,"",""]
[7000,null,0,0,null,null,"",""]
["*7,500",null,0,0,null,null,"",""]
[8000,null,0,0,null,null,"",""]
[8500,null,0,0,null,null,"",""]
["*9,000",null,0,0,null,null,"",""]
[9500,null,0,0,null,null,"",""]
[10000,null,0,0,null,null,"",""]
["*10,500",null,0,0,null,null,"",""]
[11000,null,0,0,null,null,"",""]
[11500,null,0,0,null,null,"",""]
["*12,000",null,0,0,null,null,"",""]
[12500,null,0,0,null,null,"",""]
[13000,null,0,0,null,null,"",""]
["*13,500",null,0,0,null,null,"",""]
[14000,null,0,0,null,null,"",""]
["*14,500",null,0,0,null,null,"",""]
[15000,null,0,0,null,null,"",""]
[15500,null,0,0,null,null,"",""]
[16000,null,0,0,null,null,"",""]
["*16,500",null,0,0,null,null,"",""]
[17000,null,0,0,null,null,"",""]
[17500,null,0,0,null,null,"",""]
["*18,000",null,0,0,null,null,"",""]
[null,null,null,null,null,null,"",""]
["Height Verification:"]
["Target Height","Height Displayed","Diff (in.)"]
[null,null,{"$f":"IF(ISBLANK(B103),\"\",ABS(A103-B103))","v":""}]
[]
["Note: Calibrate if height differs by ±0.004 in (0.1 mm)"]
[]
["Pressure Calibration:",null,"Recalibrate if pressure exceeds 600±6 kPa"]
[null,"Pressure Readout","Calibration Cell"]
["Run 1"]
["Run 2"]
[]
["Standard/Reference Equipment:"]
["Equipment",null,"Serial Number",null,null,null,null,"Expiration Date"]
["Pine RAM Validator"]
["Reference Equipment "]
["Reference Equipment "]
["Reference Equipment "]
[]
["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(Authority),\"Select the appropriate calibrating authority from the drop-down list.\",\"\")","v":"Select the appropriate calibrating authority from the drop-down list."}]
[]
["District Lab/Area Office:",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."}]
[]
["Non-TXDOT/Other Firm:",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."}]
[]
["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","Revised By"]
["2023-06-14","Updated to new metrology template","A. Dixon"]
["2023-06-23","Edited to keep measured parameters in line with AASHTO requirements. Removed mold verification sections and unnecessary load verification section.","A. Dixon"]
["2023-08-18","Expeceted Nominal value was changed for Brovold Compactor","SJV"]
["2024-07-22","Refactored existing code to be scalable (no longer hardcoded to cells).\nAdded functionality for multiple Authority options.","SJV"]

{"sheet":"Lists","index":2,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Status","Pass","Fail","Authority","MTD Sections","Calibration_Method","SHRP Type","Date Range"]
["Pass","None","Repair","Materials and Tests Division","Rigid Pavements","Tex-198-E","SHRP Gyratory Compaction 9Pine","2000-01-01"]
["Fail","Other (See Remarks)","Replace","District Lab/Area Office","Flexible Pavements","Tex-237-F","SHRP Gyratory Brovold Compactor","2100-01-01"]
[null,null,"Other (See Remarks)","Non-TxDOT/Other","Soils & Aggregates","Tex-498-A","SHRP Gyratory Troxler Compactor"]
[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"]