{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sieve Record","ASTM E11 Table ","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":"Sieve Record","index":0,"n_rows":71,"n_cols":10,"rows_kept":71,"cut":false,"hidden":false,"merged":[[21,3,21,7],[23,0,23,2],[21,0,21,2],[19,0,19,2],[33,1,33,2],[34,1,34,2],[60,3,60,7],[60,0,60,2],[36,1,36,2],[30,1,30,2],[28,1,28,2],[58,0,58,2],[58,3,58,7],[35,1,35,2],[62,0,62,2],[66,3,66,7],[68,3,68,7],[62,3,62,7],[64,3,64,7],[70,3,70,7],[70,0,70,2],[68,0,68,2],[66,0,66,2],[64,0,64,2],[17,3,17,7],[56,0,56,7],[9,3,9,7],[19,3,19,7],[15,3,15,7],[9,0,9,2],[23,3,23,7],[15,0,15,2],[13,3,13,7],[11,3,11,7],[50,1,50,3],[39,1,39,2],[42,1,42,2],[13,0,13,2],[11,0,11,2],[17,0,17,2],[7,0,7,2],[5,0,5,2],[3,0,3,2],[2,0,2,7],[0,0,0,7],[1,0,1,7],[3,3,3,7],[5,3,5,7],[7,3,7,7]]}
["Texas Department of Transportation"]
["Sieve 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,{"$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,"Tex-907-K",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,"Select Sieve Size:",null,null,null,"Opening Number","Warp, mm","Shute, mm"]
[null,"Sieve Size",null,null,null,{"$f":"IF(OR(D40=\"\",D40=0),\"\",1)","v":""}]
[null,null,null,null,null,{"$f":"IF(OR(F29=$D$40,,F29=\"\"),\"\",F29+1)","v":""}]
[null,"Inspection Required",null,{"$f":"IF(D29=\"\",\"\",IF(D29='ASTM E11 Table '!B21, \"Visual Only\", \"Visual and Dimensional\"))","v":""},null,""]
[null,null,null,null,null,""]
[null,"Visual Inspection:",null,null,null,""]
[null,"Cloth Condition",null,null,null,""]
[null,"Frame Condition",null,null,null,""]
[null,"Joint Condition",null,null,null,""]
[null,"Appropriate Sieve Label",null,null,null,""]
[null,null,null,null,null,""]
[null,"Dimensional Verification:",null,null,null,""]
[null,"Number of Openings to be Verified",null,null,null,""]
[null,null,null,null,null,""]
[null,"Requirements for Opening Dimension, mm:",null,null,null,""]
[null,"Average ",null,"Individual",null,""]
[null,"Min","Max","Max",null,""]
[null,{"$f":"IF(OR(D29=\"\",D29='ASTM E11 Table '!B21),\"\",VLOOKUP(D29,'ASTM E11 Table '!B6:F21,3,FALSE))","v":""},{"$f":"IF(OR(D29=\"\",D29='ASTM E11 Table '!B21),\"\",VLOOKUP(D29,'ASTM E11 Table '!B6:F21,4,FALSE))","v":""},{"$f":"IF(OR(D29=\"\",D29='ASTM E11 Table '!B21),\"\",VLOOKUP(D29,'ASTM E11 Table '!B6:F21,5,FALSE))","v":""},null,""]
[null,null,null,null,null,""]
[null,"Average Warp and Shute Measurements:",null,null,null,""]
[null,"Warp, mm","Shute, mm",null,null,""]
[null,{"$f":"IF(OR(D31=\"Visual Only\",COUNT(G29:G53)=0,COUNT(H29:H53=0)),\"\",AVERAGE(G29:G53))","v":""},{"$f":"IF(OR(D31=\"Visual Only\",COUNT(G29:G53)=0,COUNT(H29:H53=0)),\"\",AVERAGE(H29:H53))","v":""},null,null,""]
[null,null,null,null,null,""]
[null,"Standard/Reference Equipment:",null,null,null,""]
[null,"Equipment","Equipment SN","Equipment Expiration",null,""]
[null,"Calipers",null,null,null,""]
[]
[]
["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(D65),\"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":"ASTM E11 Table ","index":1,"n_rows":30,"n_cols":12,"rows_kept":30,"cut":false,"hidden":true,"merged":[[3,1,4,1],[3,2,4,2],[3,3,3,4],[3,5,4,5],[3,8,3,9]]}
[]
[]
[]
[null,"Sieve Size","Nominal Opening (mm)"," Average Opening (mm)",null,"Maximum Individual Opening (mm)",null,null,"ASTM Column"]
[null,null,null,"Min","Max",null,null,null,4,5,null,"#Opening"]
[null,"3 in.",75,{"$f":"C6-I6","v":73},{"$f":"C6+I6","v":77},{"$f":"C6+J6","v":77.78},null,null,2,2.78,null,1]
[null,"2-1/2 in.",63,61.31,64.69,65.44,null,null,1.69,2.44,null,2]
[null,"2 in.",50,48.66,51.34,52.06,null,null,1.34,2.06,null,3]
[null,"1-3/4 in.",45,43.79,46.21,46.91,null,null,1.21,1.91,null,4]
[null,"1-1/2 in.",37.5,36.49,38.51,39.17,null,null,1.01,1.67,null,5]
[null,"1-1/4 in.",31.5,30.645,32.354999999999997,32.97,null,null,0.85499999999999998,1.47,null,6]
[null,"1 in.",25,24.318000000000001,25.681999999999999,26.24,null,null,0.68200000000000005,1.24,null,7]
[null,"7/8 in.",22.4,21.786999999999999,23.012999999999998,23.54,null,null,0.61299999999999999,1.1399999999999999,null,8]
[null,"3/4 in.",19,18.478000000000002,19.521999999999998,20.010000000000002,null,null,0.52200000000000002,1.01,null,9]
[null,"5/8 in.",16,15.558999999999999,16.440999999999999,16.89,null,null,0.441,0.89,null,10]
[null,"1/2 in.",12.5,12.154,12.846,13.25,null,null,0.34599999999999997,0.75,null,11]
[null,"3/8 in.",9.5,9.2349999999999994,9.7650000000000006,10.11,null,null,0.26500000000000001,0.61,null,12]
[null,"5/16 in.",8,{"$f":"C18-I18","v":7.7759999999999998},{"$f":"C18+I18","v":8.2240000000000002},{"$f":"C18+J18","v":8.5399999999999991},null,null,0.224,0.54,null,13]
[null,"1/4 in.",6.3,6.1219999999999999,6.4779999999999998,6.76,null,null,0.17799999999999999,0.46,null,14]
[null,"No. 4",4.75,4.6150000000000002,4.8849999999999998,5.12,null,null,0.13500000000000001,0.37,null,15]
[null,"Finer than No. 4","NA","NA","`NA","NA",null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,25]

{"sheet":"Revision History","index":2,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Revision Date","Revision Description","Revised By"]
["2023-02-03","Updated to new template format.","A. Melton"]

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