{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Calibration Template","Lists","Revision History"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":99,"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":115,"n_cols":14,"rows_kept":115,"cut":false,"hidden":false,"merged":[[79,0,79,2],[79,3,79,4],[68,0,68,1],[69,0,69,1],[52,0,52,3],[53,0,53,3],[59,0,59,2],[89,0,89,1],[85,0,85,1],[86,0,86,1],[87,0,87,1],[88,0,88,1],[80,0,80,2],[80,3,80,4],[81,0,81,2],[81,3,81,4],[84,0,84,5],[32,4,32,5],[33,0,33,5],[34,0,34,1],[34,3,35,5],[35,0,35,1],[60,0,60,2],[61,0,61,2],[74,0,74,4],[75,0,75,2],[75,3,75,4],[46,0,46,1],[46,2,46,3],[48,0,48,1],[49,0,49,1],[51,0,51,3],[94,0,94,1],[93,0,93,1],[93,2,93,6],[94,2,94,6],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[70,0,70,3],[71,0,71,2],[71,3,71,4],[72,0,72,2],[72,3,72,4],[62,0,62,2],[63,0,63,2],[67,0,67,1],[78,0,78,2],[78,3,78,4],[76,0,76,2],[76,3,76,4],[77,0,77,2],[77,3,77,4],[85,6,85,8],[86,6,86,8],[114,2,114,11],[97,0,97,1],[114,0,114,1],[112,0,112,1],[110,0,110,1],[108,0,108,1],[106,0,106,1],[96,2,96,6],[95,7,95,11],[96,7,96,11],[96,0,96,1],[95,0,95,1],[25,0,25,1],[23,0,23,1],[21,0,21,1],[19,0,19,1],[92,0,92,1],[27,2,27,11],[102,2,102,11],[110,2,110,11],[112,2,112,11],[106,2,106,11],[108,2,108,11],[93,7,93,11],[94,7,94,11],[97,7,97,11],[104,2,104,11],[97,2,97,6],[100,0,100,11],[104,0,104,1],[102,0,102,1],[27,0,27,1],[95,2,95,6],[25,2,25,11],[29,0,29,1],[29,2,29,3],[13,2,13,11],[11,2,11,11],[21,2,21,11],[5,2,5,11],[7,2,7,11],[9,2,9,11],[0,1,0,11],[1,1,1,11],[23,2,23,11],[19,2,19,11],[3,2,3,11],[13,0,13,1],[11,0,11,1],[9,0,9,1],[7,0,7,1],[5,0,5,1],[3,0,3,1],[2,0,2,11],[15,0,15,1],[15,2,15,11],[17,0,17,1],[17,2,17,11]]}
[null,"Texas Department of Transportation"]
[null,"Compaction Mold and Unit Weight Bucket Standardization 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,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, corresponding with the physical piece of equipment in accordance with APCM SOP.\",\"\")","v":"Enter Serial Number exactly as it appears in APCM, corresponding with the physical piece of equipment in accordance with APCM SOP."}]
[]
["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,"Tex-905-K",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,{"$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,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."}]
[]
["Select Device:",null,null,null,"Nominal Diameter (in):",null,{"$f":"IF(device=\"Unit Weight 1/10 Cubic Feet\", 6,IF(device=\"Unit Weight 1/2 Cubic Feet\", 10,IF(device=\"Compaction Mold 4 in\", 4,IF(device=\"Compaction Mold 6 in\", 6,\"\"))))","v":""}]
[]
["Detailed Results:"]
[]
["Linear Measurement & Water Filling Method Comparison for Molds"]
["Linear Measurement",null,{"$f":"volume","v":""},{"$f":"IF(ISERROR((C35-C36)/A45),\"\",IF((ABS(C35-C36)/A45)*100<5,\"Pass\",\"Fail\"))","v":""}]
["Water Filling Method",null,{"$f":"D81","v":""}]
[]
["Unit Weight Minimum Wall & Bottom Specification"]
["Capacity, cubic feet:",null,{"$f":"IF(device=\"Unit Weight 1/10 Cubic Feet\", 0.1,IF(device=\"Unit Weight 1/2 Cubic Feet\", 0.5,IF(device=\"Compaction Mold 4 in\", \"-\",IF(device=\"Compaction Mold 6 in\", \"-\",\"\"))))","v":""},"As Found"]
["Minimum Wall Thickness",null,{"$f":"IF(device=\"Unit Weight 1/10 Cubic Feet\",0.1,IF(device=\"Unit Weight 1/2 Cubic Feet\",0.12,\"\"))","v":""}]
["Minimum Bottom Thickness",null,{"$f":"IF(device=\"Unit Weight 1/10 Cubic Feet\",0.2,IF(device=\"Unit Weight 1/2 Cubic Feet\",0.2,\"\"))","v":""}]
["Top Rim Thickness",null,{"$f":"IF(device=\"Unit Weight 1/10 Cubic Feet\",0.1,IF(device=\"Unit Weight 1/2 Cubic Feet\",0.2,\"\"))","v":""}]
[]
["Mold Nominal Specification"]
[{"$f":"IF(device=\"Unit Weight 1/10 Cubic Feet\", \"-\",IF(device=\"Unit Weight 1/2 Cubic Feet\", \"-\",IF(device=\"Compaction Mold 4 in\",(IF(B45=\"Tx-DOT Mold\",G30^2*PI()*0.25*6/1728,G30^2*PI()*0.25*4.584/1728)),IF(device=\"Compaction Mold 6 in\",(IF(B45=\"Tx-DOT Mold\",G30^2*PI()*0.25*8.5/1728,G30^2*PI()*0.25*4.584/1728)),\"\"))))","v":""}]
[]
["Volume, cubic feet:",null,{"$f":"IF(ISERROR(PI()*G60^2*C69/(4*1728)),\" \",PI()*G60^2*C69/(4*1728))","v":" "}]
[]
[]
[]
[]
["Weight - No Specification 0- For District Use Only",null,null,null,null,"lbs."]
[]
["Measurements - Inside Diameter (D):"]
[null,"Bottom","Middle","Top"]
[1]
[2]
[3]
[4]
["Average Diameter Reading:",null,null,{"$f":"IF(ISERROR(AVERAGE(B56:D59)),\"\",AVERAGE(B56:D59))","v":""},"Diameter (inches):",null,{"$f":"IF(D60=\"\",\"\",IF(D61=\"Dial Gauge\",IF(ISBLANK(D63),\"\",(D63-D60)+D62),D60))","v":""},{"$f":"IF(G60=\"\",\"\",IF(ABS(G60-G30)<I60, \"Pass\",\"Fail\"))","v":""},{"$f":"IF(device=\"Compaction Mold 4 in\",0.016, IF(B45=\"TxDOT Mold\",0.0156, 0.026))","v":2.5999999999999999E-2}]
["Measured by:",null,null,"Dial Gauge","4\" mold tolerances, 4.000 ± 0.016 in."]
["Nominal Diameter (inches)",null,null,{"$f":"G30","v":""},{"$f":"IF(B45=\"Tx-DOT Mold\", \"6in mold tolerances,  6.000 +0.0625/-0.0156 in.\", \"6 in. mold tolerances, 6.000 ± 0.026 in.\")","v":"6 in. mold tolerances, 6.000 ± 0.026 in."}]
["Dial gage reading at Noimnal Diameter:"]
[]
["Measurements - Inside Height (H) (in):"]
[1,2,3,4]
[]
["Average Height (in):",null,{"$f":"IF(ISERROR(AVERAGE(A67:D67)),\"\",AVERAGE(A67:D67))","v":""},{"$f":"IF(C68=\"\",\"\",IF(ABS(C68-C69)<F68,\"Pass\",\"Fail\"))","v":""},null,{"$f":"IF(B45=\"AASHTO Mold\",0.018,IF(device=\"Compaction Mold 4 in\", 0.026,0.0625))","v":6.25E-2}]
["Mold nominal Height (in) ",null,{"$f":"IF(G30=4,(IF(B45=\"Tx-DOT Mold\",6,4.584)),(IF(B45=\"Tx-DOT Mold\",8.5,4.584)))","v":4.5839999999999996}]
[]
["Volume (V) Cubic Feet/Linear inch:",null,null,null,{"$f":"IF(device=\"Compaction Mold 6 in\",IF(ISERROR(PI()*G60^2*1/(4*1728)),\"\",PI()*G60^2*1/(4*1728)),\" \")","v":" "}]
["Volume (V) Cubic Feet:",null,null,{"$f":"IF(ISERROR(PI()*G60^2*C68/(4*1728)),\"\",PI()*G60^2*C68/(4*1728))","v":""}]
["Factor F = 1 divided by V:",null,null,{"$f":"IF(ISERROR(1/volume),\"\",1/volume)","v":""}]
[]
["WATER WEIGHT METHOD"]
["Measure & Glass"]
["Measure, Glass, & Water"]
["Water",null,null,{"$f":"IF(ISBLANK(D77),\"\",D77-D76)","v":""}]
["Water Temperature"]
["Water Density",null,null,{"$f":"IF(ISBLANK(D79),\"\",ROUND(-0.00009924*D79*D79+0.0063887*D79+62.339956,3))","v":""},null,{"$f":"IF(D80=\"\",\"\",IF(OR(D81<0.95*G80,D81>1.05*G80),\"Fail\",\"Pass\"))","v":""},{"$f":"IF(device=\"Unit Weight 1/10 Cubic Feet\", 1/10, IF(device=\"Unit Weight 1/2 Cubic Feet\",1/2, A45))","v":""}]
["Measure Volume(ft³)",null,null,{"$f":"IF(ISERROR(D78/D80),\"\",D78/D80)","v":""}]
["Factor",null,null,{"$f":"IF(ISERROR(1/D81),\"\",1/D81)","v":""}]
[]
[]
["DIMENSIONAL MEASUREMENTS"]
[null,null,1,2,3,4,"Average bottom thickness",null,null,{"$f":"IF(ISBLANK(F88),\"\",AVERAGE(C88:F88)-AVERAGE(C87:F87))","v":""}]
["Internal Height",null,null,null,null,null,"Average wall thickness",null,null,{"$f":"IF(ISBLANK(F89),\"\",AVERAGE(C89:F89))","v":""}]
["External Height"]
["Wall Thickness"]
[]
[]
[]
["Standard/Reference Equipment:"]
["Equipment",null,"Equipment Serial Number",null,null,null,null,"Equipment Expiration"]
["Variable Length Measuring Device"]
["Reference Equipment 1"]
["Reference Equipment 2"]
["Reference Equipment 3"]
[]
["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,"Coatings, Calibration, & Traffic Materials",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(MTD_Section),\"Enter the MTD Section that performed the calibration/standardization/verification.\",\"\")","v":""}]
[]
["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/standardization/verification.\",\"\")","v":"Enter the name of the district lab or area office that performed the calibration/standardization/verification."}]
[]
["Non-TxDOT/Other Firm:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(C109),\"Enter the name of the third-party entity that performed the calibration/standardization/verification.\",\"\")","v":"Enter the name of the third-party entity that performed the calibration/standardization/verification."}]
[]
["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/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,{"$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,{"$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":"Lists","index":1,"n_rows":65,"n_cols":8,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
["Status","Pass","Fail","Authority","MTD Sections","Calibration_Method","Equipment","Date Range"]
["Pass","None","Repair","Materials and Tests Division","Rigid Pavements","Tex-198-E","Caliper","2000-01-01"]
["Fail","Other (See Remarks)","Replace","District Lab/Area Office","Flexible Pavements","Tex-237-F","Micrometer","2100-01-01"]
[null,null,"Other (See Remarks)","Non-TxDOT/Other","Soils & Aggregates","Tex-498-A","Dial Indicator"]
[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-928-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"]

{"sheet":"Revision History","index":2,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Revision Date","Revision Description","Authorized By"]
["2024-05-16","Changed the formating and formulas for pass and fail criteria","SJV"]
["2024-10-02","Updated the formula on cell D35"]