{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tex-111-E","RX","Revisions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":67,"comments":1,"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":"Tex-111-E","index":0,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[[27,4,27,5],[28,4,28,5],[28,7,28,9],[45,1,45,3],[49,1,49,3],[45,6,45,8],[41,2,41,4],[34,1,35,8],[42,2,42,4],[38,2,38,4],[39,2,39,4],[26,3,26,5],[25,3,25,5],[11,7,11,8],[12,7,12,8],[15,3,15,8],[16,3,16,4],[16,7,16,8],[13,3,13,4],[13,7,13,8],[12,3,12,4],[11,3,11,4],[14,3,14,8],[23,3,23,5],[21,1,21,8],[10,7,10,8],[10,3,10,4],[9,7,9,8],[9,3,9,4],[0,0,0,1],[7,7,7,8],[8,3,8,4],[8,7,8,8],[7,3,7,4]]}
["TxDOT Manuals >",null,null,"Tex-111-E"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,"tx111.xlsm::45408.599051"]
[null,"DETERMINING THE AMOUNT OF MATERIAL IN SOILS FINER THAN 75 µm (NO. 200 SIEVE)"]
[null,"Tex-111-E "]
[null,null,null,null,null,null,null,null,{"$f":"\"TX111 :: File Version: \" & TEXT(MID(sn,SEARCH(\"::\",sn,1)+2,20),\"mm/dd/yy hh:mm:ss\")","v":"TX111 :: File Version: 04/26/24 14:22:38"}]
[null,null,"SAMPLE ID:",null,null,null,"SAMPLED DATE:"]
[null,null,"TEST NUMBER:",null,null,null,"LETTING DATE:"]
[null,null,"SAMPLE STATUS:",null,null,null,"CONTROLLING CSJ:",""]
[null,null,"COUNTY:",null,null,null,"SPEC YEAR:"]
[null,null,"SAMPLED BY:",null,null,null,"SPEC ITEM:",""]
[null,null,"SAMPLE LOCATION:",null,null,null,"SPECIAL PROVISION:"]
[null,null,"MATERIAL CODE:",null,null,null,"GRADE:"]
[null,null,"MATERIAL NAME:"]
[null,null,"PRODUCER:",""]
[null,null,"AREA ENGINEER:","",null,null,"PROJECT MANAGER:"]
[]
[null,null,"COURSE\\LIFT:",null,"STATION:",null,null,"DIST. FROM CL:"]
[]
[]
[null,"Determining the Amount of Material in Soils Finer Than 75 µm (No. 200) Sieve - Tex-111-E"]
[]
[null,null,null,"Unit"]
[]
[null,null,null,{"$f":"\"Initial Oven-Dry Mass of Sample (\" & unit & \"): WT\"","v":"Initial Oven-Dry Mass of Sample (): WT"}]
[null,null,null,{"$f":"\"Retained Oven-Dry Mass After Washing (\" & unit & \"): WR\"","v":"Retained Oven-Dry Mass After Washing (): WR"}]
[null,null,null,null,"% Retained on the 75 µm (#200)",null,{"$f":"IF(ISERROR(100-((100*(G26-G27))/G26)),\"\",(100-(100*(G26-G27))/G26))","v":""}]
[null,null,null,null,"% Passing the 75 µm (#200)",null,{"$f":"IF(ISERROR((100*(G26-G27))/G26),\"\",(100*(G26-G27))/G26)","v":""}]
[]
[]
[]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2024-04-26T14:22:38.620"}]
[]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX100"]
[]
[null,"Test Method:","Tested By:",null,null,"Tested Date:"]
[null,"TX111"]
[]
[null,"Test Stamp Code:",null,null,"Omit Test:","Completed Date:","Reviewed By:"]
[]
[null,"Locked By:","TxDOT:","District:","Area:"]
[null,"","","",""]
[null,"Authorized By:",null,null,"Authorized Date:"]
[null,null,null,null,null,{"$f":"IF(OR(ISBLANK(authorizeddate), authorizeddate>=42968), 1, 0)","v":1}]

{"sheet":"RX","index":1,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[{"$f":"COUNT(A2:A1982)","v":11}]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF('Tex-111-E'!$B$35=\"\",\"\",'Tex-111-E'!$B$35)","v":""},{"$f":"'Tex-111-E'!$B$34","v":"Remarks:"}]
[2,{"$f":"IF('Tex-111-E'!$D$19=\"\",\"\",'Tex-111-E'!$D$19)","v":""},{"$f":"IF('Tex-111-E'!$C$19=\"\",\"\",'Tex-111-E'!$C$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('Tex-111-E'!$C$43=\"\",\"\",'Tex-111-E'!$C$43)","v":""},"Tested By ",{"$f":"IF('Tex-111-E'!$B$43=\"\",\"\",'Tex-111-E'!$B$43)","v":"TX111"}]
[4,{"$f":"IF('Tex-111-E'!$F$43=\"\",\"\",'Tex-111-E'!$F$43)","v":""},"Tested Date ",{"$f":"IF('Tex-111-E'!$B$43=\"\",\"\",'Tex-111-E'!$B$43)","v":"TX111"}]
[5,{"$f":"IF('Tex-111-E'!$G$24=\"\",\"\",'Tex-111-E'!$G$24)","v":""},{"$f":"IF('Tex-111-E'!$B$6=\"\",\"\",'Tex-111-E'!$B$6)","v":"Tex-111-E "},{"$f":"IF('Tex-111-E'!$D$24=\"\",\"\",'Tex-111-E'!$D$24)","v":"Unit"}]
[6,{"$f":"IF('Tex-111-E'!$G$26=\"\",\"\",'Tex-111-E'!$G$26)","v":""},{"$f":"IF('Tex-111-E'!$B$6=\"\",\"\",'Tex-111-E'!$B$6)","v":"Tex-111-E "},{"$f":"IF('Tex-111-E'!$D$26=\"\",\"\",'Tex-111-E'!$D$26)","v":"Initial Oven-Dry Mass of Sample (): WT"}]
[7,{"$f":"IF('Tex-111-E'!$G$27=\"\",\"\",'Tex-111-E'!$G$27)","v":""},{"$f":"IF('Tex-111-E'!$B$6=\"\",\"\",'Tex-111-E'!$B$6)","v":"Tex-111-E "},{"$f":"IF('Tex-111-E'!$D$27=\"\",\"\",'Tex-111-E'!$D$27)","v":"Retained Oven-Dry Mass After Washing (): WR"}]
[8,{"$f":"IF('Tex-111-E'!$G$28=\"\",\"\",'Tex-111-E'!$G$28)","v":""},{"$f":"IF('Tex-111-E'!$B$6=\"\",\"\",'Tex-111-E'!$B$6)","v":"Tex-111-E "},{"$f":"IF('Tex-111-E'!$E$28=\"\",\"\",'Tex-111-E'!$E$28)","v":"% Retained on the 75 µm (#200)"}]
[9,{"$f":"IF('Tex-111-E'!$G$29=\"\",\"\",'Tex-111-E'!$G$29)","v":""},{"$f":"IF('Tex-111-E'!$B$6=\"\",\"\",'Tex-111-E'!$B$6)","v":"Tex-111-E "},{"$f":"IF('Tex-111-E'!$E$29=\"\",\"\",'Tex-111-E'!$E$29)","v":"% Passing the 75 µm (#200)"}]
[10,{"$f":"IF('Tex-111-E'!$C$40=\"\",\"\",'Tex-111-E'!$C$40)","v":""},"Sampled By",{"$f":"IF('Tex-111-E'!$B$40=\"\",\"\",'Tex-111-E'!$B$40)","v":"TX100"}]
[11,{"$f":"IF('Tex-111-E'!$F$40=\"\",\"\",'Tex-111-E'!$F$40)","v":""},"Sampled Date",{"$f":"IF('Tex-111-E'!$B$40=\"\",\"\",'Tex-111-E'!$B$40)","v":"TX100"}]

{"sheet":"Revisions","index":2,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Date","Description","User"]
["2016-12-14","Revised cell F25 to change to \"Class A, B, or P?\" when SpecYear = 2014","R. Cano"]
["2016-12-14","Revised cell H25 to change default criteria depending on SpecYear","R. Cano"]
["2017-08-21","added version comparison","R. Cano"]