{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sand Patch Kit Record","Revision History","Lists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":35,"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":"Sand Patch Kit Record","index":0,"n_rows":126,"n_cols":10,"rows_kept":126,"cut":false,"hidden":false,"merged":[[105,6,105,7],[106,6,106,7],[107,6,107,7],[105,1,105,3],[106,1,106,3],[107,1,107,3],[105,4,105,5],[106,4,106,5],[107,4,107,5],[102,1,102,2],[99,1,99,2],[99,4,99,5],[100,1,100,2],[100,4,100,5],[101,1,101,2],[101,4,101,5],[96,1,96,2],[96,4,96,5],[97,1,97,2],[97,4,97,5],[98,1,98,2],[98,4,98,5],[93,1,93,2],[93,4,93,5],[94,1,94,2],[94,4,94,5],[95,1,95,2],[95,4,95,5],[90,1,90,2],[90,4,90,5],[91,1,91,2],[91,4,91,5],[92,1,92,2],[92,4,92,5],[87,1,87,2],[87,4,87,5],[88,1,88,2],[88,4,88,5],[89,1,89,2],[89,4,89,5],[84,1,84,2],[84,4,84,5],[85,1,85,2],[85,4,85,5],[86,1,86,2],[86,4,86,5],[81,1,81,6],[82,1,82,2],[82,4,82,5],[83,1,83,2],[83,4,83,5],[77,2,77,3],[77,5,77,6],[78,2,78,3],[78,5,78,6],[79,2,79,3],[74,2,74,3],[74,5,74,6],[75,2,75,3],[75,5,75,6],[76,2,76,3],[76,5,76,6],[71,2,71,3],[71,5,71,6],[72,2,72,3],[72,5,72,6],[73,2,73,3],[73,5,73,6],[68,2,68,3],[68,5,68,6],[69,2,69,3],[69,5,69,6],[70,2,70,3],[70,5,70,6],[65,2,65,3],[65,5,65,6],[66,2,66,3],[66,5,66,6],[67,2,67,3],[67,5,67,6],[62,2,62,3],[62,5,62,6],[63,2,63,3],[63,5,63,6],[64,2,64,3],[64,5,64,6],[59,2,59,3],[59,5,59,6],[60,2,60,3],[60,5,60,6],[61,2,61,3],[61,5,61,6],[56,2,56,3],[56,5,56,6],[57,2,57,3],[57,5,57,6],[58,2,58,3],[58,5,58,6],[53,2,53,3],[53,5,53,6],[54,2,54,3],[54,5,54,6],[55,2,55,3],[55,5,55,6],[50,2,50,3],[50,5,50,6],[51,2,51,3],[51,5,51,6],[52,2,52,3],[52,5,52,6],[47,2,47,3],[47,5,47,6],[48,2,48,3],[48,5,48,6],[49,2,49,3],[49,5,49,6],[44,5,44,6],[45,2,45,3],[45,5,45,6],[46,2,46,3],[46,5,46,6],[41,2,41,3],[41,5,41,6],[42,2,42,3],[42,5,42,6],[43,2,43,3],[43,5,43,6],[0,0,0,7],[1,0,1,7],[3,3,3,7],[5,3,5,7],[7,3,7,7],[9,3,9,7],[19,3,19,7],[15,3,15,7],[15,0,15,2],[13,3,13,7],[11,3,11,7],[17,3,17,7],[7,0,7,2],[5,0,5,2],[3,0,3,2],[2,0,2,7],[13,0,13,2],[11,0,11,2],[9,0,9,2],[23,3,23,7],[113,3,113,7],[23,0,23,2],[21,0,21,2],[19,0,19,2],[17,0,17,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[21,3,21,7],[38,2,38,3],[38,5,38,6],[39,2,39,3],[39,5,39,6],[40,2,40,3],[40,5,40,6],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[44,2,44,3],[117,0,117,2],[117,3,117,7],[115,3,115,7],[111,0,111,7],[115,0,115,2],[125,3,125,7],[125,0,125,2],[123,0,123,2],[121,0,121,2],[119,0,119,2],[121,3,121,7],[123,3,123,7],[119,3,119,7],[113,0,113,2]]}
["Texas Department of Transportation"]
["Sand Patch Kit Calibration 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,{"$f":"IF(A3=\"\",\"\",\"Instructions\")","v":"Instructions"}]
["Serial Number:",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,{"$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,{"$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,{"$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,{"$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,"ASTM E965",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,{"$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,12]
[]
["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,{"$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,{"$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,{"$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,"Cup & Cover weight, g:"]
[null,"Cup & Cover weight, lb.:",null,{"$f":"IF(ISBLANK(Cup_Cover_Weight),\"\",+Cup_Cover_Weight/453.6)","v":""}]
[null,"Cup, Cover & Water weight, g:"]
[null,"Cup, Cover & Water weight, lb.:",null,{"$f":"IF(ISBLANK(Cup_Cover_Water_Weight),\"\",Cup_Cover_Water_Weight/453.6)","v":""}]
[null,"Volume, mL:",null,{"$f":"IF(ISBLANK(Field10),\"\", (Cup_Cover_Water_Weight-Cup_Cover_Weight)/Density)","v":""}]
[null,"Volume, in3:",null,{"$f":"IF(ISBLANK(Field10), \"\", Volume/16.387064)","v":""}]
[null,"Water Temperature, °C:",null,{"$f":"5/9*(Water_Temperature-32)","v":-17.777999999999999}]
[null,"Water Temperature, °F:"]
[null,"Density of Water, lb./ft3:",null,{"$f":"IF(ISBLANK(Water_Temperature),\"\",ROUND(-0.00009924*Water_Temperature*Water_Temperature+0.0063887*Water_Temperature+62.339956,3))","v":""}]
[null,"Density of Water, g/mL:",null,{"$f":"IF(D36=\"\", \"\", D36*0.0160185)","v":""}]
[]
[null,"Diameter in.","Texture Depth in.",null,"Diameter in.","Texture Depth in."]
[null,4,{"$f":"IF(Volume_2=\"\", \"\", ROUND((4*Volume_2)/(3.141592654*B40*B40), 5))","v":""},null,8.1,{"$f":"IF(Volume_2=\"\", \"\", ROUND((4*Volume_2)/(3.141592654*E40*E40), 5))","v":""}]
[null,4.0999999999999996,"",null,8.1999999999999993,""]
[null,4.2,"",null,8.3000000000000007,""]
[null,4.3,"",null,8.4,""]
[null,4.4000000000000004,"",null,8.5,""]
[null,4.5,"",null,8.6,""]
[null,4.5999999999999996,"",null,8.6999999999999993,""]
[null,4.7,"",null,8.8000000000000007,""]
[null,4.8,"",null,8.9,""]
[null,4.9000000000000004,"",null,9,""]
[null,5,"",null,9.1,""]
[null,5.0999999999999996,"",null,9.1999999999999993,""]
[null,5.2,"",null,9.3000000000000007,""]
[null,5.3,"",null,9.4,""]
[null,5.4,"",null,9.5,""]
[null,5.5,"",null,9.6,""]
[null,5.6,"",null,9.6999999999999993,""]
[null,5.7,"",null,9.8000000000000007,""]
[null,5.8,"",null,9.9,""]
[null,5.9,"",null,10,""]
[null,6,"",null,10.1,""]
[null,6.1,"",null,10.199999999999999,""]
[null,6.2,"",null,10.3,""]
[null,6.3,"",null,10.4,""]
[null,6.4,"",null,10.5,""]
[null,6.5,"",null,10.6,""]
[null,6.6,"",null,10.7,""]
[null,6.7,"",null,10.8,""]
[null,6.8,"",null,10.9,""]
[null,6.9,"",null,11,""]
[null,7,"",null,11.1,""]
[null,7.1,"",null,11.2,""]
[null,7.2,"",null,11.3,""]
[null,7.3,"",null,11.4,""]
[null,7.4,"",null,11.5,""]
[null,7.5,"",null,11.6,""]
[null,7.6,"",null,11.7,""]
[null,7.7,"",null,11.8,""]
[null,7.8,"",null,11.9,""]
[null,7.9,"",null,12,""]
[null,8,""]
[]
[null,"Density of Distilled Water in Grams per Milliliter versus Celsius Temperatures"]
[null,"Temperature, C",null,"Density","Temperature, C",null,"Density"]
[null,0,null,0.99987000000000004,20,null,0.99822999999999995]
[null,1,null,0.99992999999999999,21,null,0.99802000000000002]
[null,2,null,0.99997000000000003,22,null,0.99780000000000002]
[null,3,null,0.99999000000000005,23,null,0.99756]
[null,4,null,1,24,null,0.99731999999999998]
[null,5,null,0.99999000000000005,25,null,0.99707000000000001]
[null,6,null,0.99997000000000003,26,null,0.99680999999999997]
[null,7,null,0.99992999999999999,27,null,0.99653999999999998]
[null,8,null,0.99987999999999999,28,null,0.99626000000000003]
[null,9,null,0.99980999999999998,29,null,0.99597000000000002]
[null,10,null,0.99973000000000001,30,null,0.99567000000000005]
[null,11,null,0.99963000000000002,31,null,0.99536999999999998]
[null,12,null,0.99951999999999996,32,null,0.99504999999999999]
[null,13,null,0.99939999999999996,33,null,0.99473]
[null,14,null,0.99926999999999999,34,null,0.99439999999999995]
[null,15,null,0.99912999999999996,35,null,0.99406000000000005]
[null,16,null,0.99897000000000002,36,null,0.99370999999999998]
[null,17,null,0.99880000000000002,37,null,0.99336000000000002]
[null,18,null,0.99863000000000002,38,null,0.99299000000000004]
[null,19,null,0.99843000000000004]
[]
[null,"Standard/Reference Equipment:"]
[null,"Equipment",null,null,"Equipment ID",null,"Equipment Expiration"]
[null,"Balance, accurate to 0.1% of the cup weight"]
[null,"Thermometer"]
[]
[]
["Remarks:"]
[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,{"$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,{"$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,{"$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,{"$f":"IF(ISBLANK(D120),\"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,{"$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,{"$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,{"$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":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Revision Date","Revision Description","Revised By"]
["2021-08-11","Added fields to enter calibration equipment ID and expiration date.","R. Cano"]
["2023-02-04","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","Repair","Replace","District Lab/Area Office","Flexible Pavements","Tex-237-F",null,"2100-01-01"]
[null,"Replace","Other (See Remarks)","Non-TxDOT/Other","Soils & Aggregates","Tex-498-A"]
[null,"Other (See Remarks)",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"]