{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["SGC Height & Pressure Record","Revision History","Lists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":26,"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":"SGC Height & Pressure Record","index":0,"n_rows":136,"n_cols":11,"rows_kept":136,"cut":false,"hidden":false,"merged":[[116,2,116,3],[116,4,116,5],[116,6,116,7],[117,2,117,3],[117,4,117,5],[117,6,117,7],[110,1,110,2],[115,2,115,3],[115,4,115,5],[115,6,115,7],[108,1,108,2],[108,3,108,4],[109,1,109,2],[109,3,109,4],[110,3,110,4],[101,6,101,7],[102,2,102,3],[102,4,102,5],[102,6,102,7],[103,2,103,3],[103,4,103,5],[103,6,103,7],[95,1,95,2],[95,3,95,4],[96,3,96,4],[101,2,101,3],[101,4,101,5],[49,1,49,2],[49,3,49,4],[94,1,94,2],[94,3,94,4],[96,1,96,2],[42,5,42,6],[43,5,43,6],[35,7,35,8],[36,7,36,8],[37,7,37,8],[38,7,38,8],[40,7,40,8],[41,7,41,8],[42,7,42,8],[43,7,43,8],[39,7,39,8],[36,5,36,6],[37,5,37,6],[38,5,38,6],[39,5,39,6],[40,5,40,6],[41,5,41,6],[42,1,42,2],[43,1,43,2],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[39,3,39,4],[40,1,40,2],[38,1,38,2],[39,1,39,2],[36,1,36,2],[37,1,37,2],[41,1,41,2],[17,3,17,8],[13,0,13,2],[11,0,11,2],[9,0,9,2],[23,3,23,8],[33,1,33,2],[35,1,35,2],[30,1,30,8],[31,1,31,8],[35,5,35,6],[7,0,7,2],[5,0,5,2],[3,0,3,2],[2,0,2,8],[0,0,0,8],[1,0,1,8],[3,3,3,8],[5,3,5,8],[7,3,7,8],[123,3,123,8],[23,0,23,2],[21,0,21,2],[19,0,19,2],[17,0,17,2],[9,3,9,8],[19,3,19,8],[125,3,125,8],[121,0,121,8],[125,0,125,2],[123,0,123,2],[27,1,27,2],[53,7,54,7],[53,8,54,8],[53,3,53,4],[53,5,53,6],[53,1,54,1],[53,2,54,2],[27,3,27,4],[15,3,15,8],[15,0,15,2],[21,3,21,8],[13,3,13,8],[11,3,11,8],[135,3,135,8],[135,0,135,2],[133,0,133,2],[131,0,131,2],[129,0,129,2],[131,3,131,8],[133,3,133,8],[129,3,129,8],[127,0,127,2],[127,3,127,8]]}
["Texas Department of Transportation"]
["SHRP Gyratory Compactor - Height & Pressure 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,{"$f":"IF(A3=\"\",\"\",\"Instructions\")","v":"Instructions"}]
["Serial Number:",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,{"$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,{"$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,{"$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,{"$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,{"$f":"IF(ISBLANK(Calibration_Method),\"Select the calibration/verification/standardization procedure used.\",\"\")","v":""}]
[]
["Completed Date:",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,3]
[]
["Next Due Date:",null,null,{"$f":"IF(Overall_Status=\"FAIL\",\"N/A\",IF(D16=\"\",\"\",(DATE(YEAR(D16),MONTH(D16)+D18,DAY(D16)))))","v":""},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,{"$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,{"$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,"Select SHRP Type:"]
[]
[null,"Pine Height Verification:"]
[null,"Place the gauge block into the chamber, oriented for 152.4 mm (6 in.). Traceable to Report Houston Precision No. 85690"]
[null,"Calibrate if height exceeds ±0.1 mm (±0.004 in)."]
[]
[null,"Select (mm) or (in.):"]
[]
[null,{"$f":"IF(D34=\"mm\",\"Target Height (mm)\",\"Target Height (in.)\")","v":"Target Height (in.)"},null,{"$f":"IF(D34=\"mm\",\"Height Displayed (mm)\",\"Height Displayed (in.)\")","v":"Height Displayed (in.)"},null,{"$f":"IF(D34=\"mm\",\"Difference (mm)\",\"Difference (in.)\")","v":"Difference (in.)"},null,"Calibration Required"]
[null,{"$f":"IF(D34=\"mm\",76.2,3)","v":3},null,null,null,{"$f":"IF(D37=\"\",\"\",D37-B37)","v":""},null,{"$f":"IF(F37=\"\",\"\",IF($D$34=\"mm\",IF(ABS(F37)>0.1,\"Required\",\"Not Required\"),IF(OR(ABS(F37)>0.004,ABS(F37)<-0.004),\"Required\",\"Not Required\")))","v":""}]
[null,{"$f":"IF(D34=\"mm\",101.6,4)","v":4},null,null,null,{"$f":"IF(D38=\"\",\"\",D38-B38)","v":""},null,{"$f":"IF(F38=\"\",\"\",IF($D$34=\"mm\",IF(ABS(F38)>0.1,\"Required\",\"Not Required\"),IF(OR(ABS(F38)>0.004,ABS(F38)<-0.004),\"Required\",\"Not Required\")))","v":""}]
[null,{"$f":"IF(D34=\"mm\",127,5)","v":5},null,null,null,"",null,""]
[null,{"$f":"IF(D34=\"mm\",152.4,6)","v":6},null,null,null,"",null,""]
[null,{"$f":"IF(D34=\"mm\",177.8,7)","v":7},null,null,null,"",null,""]
[null,{"$f":"IF(D34=\"mm\",203.2,8)","v":8},null,null,null,"",null,""]
[null,{"$f":"IF(D34=\"mm\",228.6,9)","v":9},null,null,null,"",null,""]
[null,{"$f":"IF(D34=\"mm\",254,10)","v":10},null,null,null,"",null,""]
[]
[null,"Pine Pressure Verification:"]
[null,"Select VERIFY CALIBRATION from the OTHER OPTIONS menu and press the ENTER key."]
[null,"If pressure exceeds ± 3%, calibration is required. If pressure exceeds ± 1%, calibration is recommended."]
[]
[null,"Using Pine Ring S/N: ",null,null,null,"Traceable to Revere Load Cell S/N 733108, ID 15872."]
[]
[null,"From pine ring worksheet included inside of the calibration kit, enter the dial readings for the corresponding Newtons in the table below."]
[]
[null,"True Load (Newtons)","Dial Reading","3% of Readout",null,"Run",null,"Average Value","Calibration Required"]
[null,null,null,"Minimum","Maximum",1,2]
[null,"*1,500",null,{"$f":"IF(C56=\"\",\"\",C56*0.97)","v":""},{"$f":"IF(C56=\"\",\"\",C56*1.03)","v":""},null,null,{"$f":"IF(ISERROR(AVERAGE(F56:G56)),\"\",AVERAGE(F56:G56))","v":""},{"$f":"IF(H56=\"\",\"\",IF(OR(H56>E56,H56<D56),\"Required\",IF(OR(H56>(C56*1.01),H56<(C56*0.99)),\"Recommended\",\"Not Required\")))","v":""}]
[null,2000,null,{"$f":"IF(C57=\"\",\"\",C57*0.97)","v":""},{"$f":"IF(C57=\"\",\"\",C57*1.03)","v":""},null,null,{"$f":"IF(ISERROR(AVERAGE(F57:G57)),\"\",AVERAGE(F57:G57))","v":""},{"$f":"IF(H57=\"\",\"\",IF(OR(H57>E57,H57<D57),\"Required\",IF(OR(H57>(C57*1.01),H57<(C57*0.99)),\"Recommended\",\"Not Required\")))","v":""}]
[null,2500,null,"","",null,null,"",""]
[null,"*3,000",null,"","",null,null,"",""]
[null,3500,null,"","",null,null,"",""]
[null,4000,null,"","",null,null,"",""]
[null,4500,null,"","",null,null,"",""]
[null,"*5,000",null,"","",null,null,"",""]
[null,5500,null,"","",null,null,"",""]
[null,"*6,000",null,"","",null,null,"",""]
[null,6500,null,"","",null,null,"",""]
[null,7000,null,"","",null,null,"",""]
[null,"*7,500",null,"","",null,null,"",""]
[null,8000,null,"","",null,null,"",""]
[null,8500,null,"","",null,null,"",""]
[null,"*9,000",null,"","",null,null,"",""]
[null,9500,null,"","",null,null,"",""]
[null,10000,null,"","",null,null,"",""]
[null,"*10,500",null,"","",null,null,"",""]
[null,11000,null,"","",null,null,"",""]
[null,11500,null,"","",null,null,"",""]
[null,"*12,000",null,"","",null,null,"",""]
[null,12500,null,"","",null,null,"",""]
[null,13000,null,"","",null,null,"",""]
[null,"*13,500",null,"","",null,null,"",""]
[null,14000,null,"","",null,null,"",""]
[null,"*14,500",null,"","",null,null,"",""]
[null,15000,null,"","",null,null,"",""]
[null,15500,null,"","",null,null,"",""]
[null,16000,null,"","",null,null,"",""]
[null,"*16,500",null,"","",null,null,"",""]
[null,17000,null,"","",null,null,"",""]
[null,17500,null,"","",null,null,"",""]
[null,"*18,000",null,"","",null,null,"",""]
[null,"*20,000",null,"","",null,null,"",""]
[]
[null,"Brovold Height Verification:"]
[null,"Calibrate if height exceeds ± 0.1 mm."]
[]
[null,"Target Height (mm):"]
[null,"Height Displayed (mm):"]
[null,"Calibration Required:",null,{"$f":"IF($D$96=\"\",\"\",IF(OR($D$96>$D$95+0.1,$D$96<$D$95-0.1),\"Required\",\"Not Required\"))","v":""}]
[]
[null,"Brovold Pressure Verification: 600 kPa"]
[null,"If pressure exceeds ± 18 kPa, calibration is required. If pressure exceeds ± 6 kPa, calibration is recommended."]
[]
[null,"Run","Gyratory Cell",null,"Calibration Cell",null,"Calibration Required"]
[null,"RUN 1",null,null,null,null,{"$f":"IF(E103=\"\",\"\",IF(OR(E103>(C103*1.03),E103<(C103*0.97)),\"Required\",IF(OR(E103>(C103*1.01),E103<(C103*0.99)),\"Recommended\",\"Not Required\")))","v":""}]
[null,"RUN 2",null,null,null,null,{"$f":"IF(E104=\"\",\"\",IF(OR(E104>(C104*1.03),E104<(C104*0.97)),\"Required\",IF(OR(E104>(C104*1.01),E104<(C104*0.99)),\"Recommended\",\"Not Required\")))","v":""}]
[]
[null,"Troxler Height Verification:"]
[null,"Calibrate if height exceeds ± 0.1 mm."]
[]
[null,"Target Height (mm):"]
[null,"Height Displayed (mm):"]
[null,"Calibration Required:",null,{"$f":"IF($D$110=\"\",\"\",IF(OR($D$110>$D$109+0.1,$D$110<$D$109-0.1),\"Required\",\"Not Required\"))","v":""}]
[]
[null,"Troxler Pressure Verification: 600 kPa"]
[null,"If pressure exceeds ± 18 kPa, calibration is required. If pressure exceeds ± 6 kPa, calibration is recommended."]
[]
[null,"Run","Gyratory Cell",null,"Calibration Cell",null,"Calibration Required"]
[null,"RUN 1",null,null,null,null,{"$f":"IF(E117=\"\",\"\",IF(OR(E117>(C117*1.03),E117<(C117*0.97)),\"Required\",IF(OR(E117>(C117*1.01),E117<(C117*0.99)),\"Recommended\",\"Not Required\")))","v":""}]
[null,"RUN 2",null,null,null,null,{"$f":"IF(E118=\"\",\"\",IF(OR(E118>(C118*1.03),E118<(C118*0.97)),\"Required\",IF(OR(E118>(C118*1.01),E118<(C118*0.99)),\"Recommended\",\"Not Required\")))","v":""}]
[]
[]
["Remarks:"]
[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,{"$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,{"$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,{"$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,{"$f":"IF(ISBLANK(D130),\"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,{"$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,{"$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,{"$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":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Revision Date","Revision Description","Revised By"]
["2023-02-11","Updated to new template format.","A. Melton"]

{"sheet":"Lists","index":2,"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"]