{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tex-203-F","RX"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":68,"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-203-F","index":0,"n_rows":61,"n_cols":11,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,0,0,1],[40,2,40,4],[13,3,13,4],[15,3,15,8],[12,7,12,8],[13,7,13,8],[16,7,16,8],[32,3,32,4],[34,3,34,4],[12,3,12,4],[7,7,7,8],[7,3,7,4],[26,3,28,3],[8,7,8,8],[9,7,9,8],[9,3,9,4],[8,3,8,4],[10,7,10,8],[11,7,11,8],[10,3,10,4],[11,3,11,4],[61,1,61,3],[55,2,55,4],[57,6,57,8],[48,1,48,8],[57,1,57,3],[54,2,54,4],[50,2,50,4],[51,2,51,4],[53,2,53,4],[36,3,38,3],[41,2,41,7],[45,1,46,8],[47,1,47,8],[14,3,14,8],[30,3,30,5],[20,3,20,5],[22,3,22,4],[24,3,24,4],[16,3,16,4]]}
["TxDOT Manuals >",null,null,"Tex-203-F"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,3]
[null," ",null,null,null,null,null,null,null,null,"tx203.xlsm::45574.60831"]
[null,"SAND EQUIVALENT"]
[null,"Tex-203-F"]
[null,null,null,null,null,null,null,null,{"$f":"\"File Version: \" & TEXT(MID(sn,SEARCH(\"::\",sn,1)+2,20),\"mm/dd/yy hh:mm:ss\")","v":"File Version: 10/09/24 14:35:58"}]
[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,null,"PROJECT MANAGER:"]
[]
[null,null,"COURSE\\LIFT:",null,"STATION:",null,null,"DIST. FROM CL:"]
[]
[null,null,null,"Sand Equivalent No. 1"]
[]
[null,null,null,"Sand Reading:"]
[]
[null,null,null,"Clay Reading:"]
[]
[null,null,null,"Sand Equivalent","Calculated:",{"$f":"IF(ISERROR(F23/F25*100),\"\",F23/F25*100)","v":""}]
[]
[null,null,null,null,"Reported:",{"$f":"IF(F27=\"\",\"\",ROUNDUP(F27,0))","v":""}]
[]
[null,null,null,"Sand Equivalent No. 2"]
[]
[null,null,null,"Sand Reading:"]
[]
[null,null,null,"Clay Reading:"]
[]
[null,null,null,"Sand Equivalent","Calculated:",{"$f":"IF(ISERROR(F33/F35*100),\"\",F33/F35*100)","v":""}]
[]
[null,null,null,null,"Reported:",{"$f":"IF(+F37=\"\",\"\",ROUNDUP(F37,0))","v":""}]
[]
[null,null,"Average Sand Equivalent:",null,null,{"$f":"IF(ISERROR(ROUNDUP(AVERAGE(F29,F39),0)),\"\",ROUNDUP(AVERAGE(F29,F39),0))","v":""}]
[null,null,{"$f":"\"Difference of ( \"&SQRT(($F$29-$F$39)^2)&\" ) between No. 1 and No. 2 is greater than 4. Please retest.\"","v":{"$error":"#VALUE!"}}]
[]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2024-10-09T14:35:58.110"}]
[]
[]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX221"]
[]
[null,"TX400"]
[null,"Test Method:","Tested By:",null,null,"Tested Date:"]
[null,"TX203"]
[null,"Test Stamp Code:",null,null,"Omit Test:","Completed Date:","Reviewed By:"]
[]
[null,"Locked By:","TxDOT:","District:","Area:"]
[]
[null,"Authorized By:",null,null,"Authorized Date:"]

{"sheet":"RX","index":1,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[17]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF('Tex-203-F'!$B$46=\"\",\"\",'Tex-203-F'!$B$46)","v":""},{"$f":"'Tex-203-F'!$B$45","v":"Remarks:"}]
[2,{"$f":"IF('Tex-203-F'!$D$19=\"\",\"\",'Tex-203-F'!$D$19)","v":""},{"$f":"IF('Tex-203-F'!$C$19=\"\",\"\",'Tex-203-F'!$C$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('Tex-203-F'!$C$56=\"\",\"\",'Tex-203-F'!$C$56)","v":""},"Tested By ",{"$f":"IF('Tex-203-F'!$B$56=\"\",\"\",'Tex-203-F'!$B$56)","v":"TX203"}]
[4,{"$f":"IF('Tex-203-F'!$F$56=\"\",\"\",'Tex-203-F'!$F$56)","v":""},"Tested Date ",{"$f":"IF('Tex-203-F'!$B$56=\"\",\"\",'Tex-203-F'!$B$56)","v":"TX203"}]
[5,{"$f":"IF('Tex-203-F'!$F$23=\"\",\"\",'Tex-203-F'!$F$23)","v":""},{"$f":"IF('Tex-203-F'!$B$6=\"\",\"\",'Tex-203-F'!$B$6)","v":"Tex-203-F"},{"$f":"IF('Tex-203-F'!$D$21=\"\",\"\",'Tex-203-F'!$D$21)","v":"Sand Equivalent No. 1"},{"$f":"IF('Tex-203-F'!$D$23=\"\",\"\",'Tex-203-F'!$D$23)","v":"Sand Reading:"}]
[6,{"$f":"IF('Tex-203-F'!$F$25=\"\",\"\",'Tex-203-F'!$F$25)","v":""},{"$f":"IF('Tex-203-F'!$B$6=\"\",\"\",'Tex-203-F'!$B$6)","v":"Tex-203-F"},{"$f":"IF('Tex-203-F'!$D$21=\"\",\"\",'Tex-203-F'!$D$21)","v":"Sand Equivalent No. 1"},{"$f":"IF('Tex-203-F'!$D$25=\"\",\"\",'Tex-203-F'!$D$25)","v":"Clay Reading:"}]
[7,{"$f":"IF('Tex-203-F'!$F$27=\"\",\"\",'Tex-203-F'!$F$27)","v":""},{"$f":"IF('Tex-203-F'!$B$6=\"\",\"\",'Tex-203-F'!$B$6)","v":"Tex-203-F"},{"$f":"IF('Tex-203-F'!$D$21=\"\",\"\",'Tex-203-F'!$D$21)","v":"Sand Equivalent No. 1"},{"$f":"IF('Tex-203-F'!$D$27=\"\",\"\",'Tex-203-F'!$D$27)","v":"Sand Equivalent"},{"$f":"IF('Tex-203-F'!$E$27=\"\",\"\",'Tex-203-F'!$E$27)","v":"Calculated:"}]
[8,{"$f":"IF('Tex-203-F'!$F$29=\"\",\"\",'Tex-203-F'!$F$29)","v":""},{"$f":"IF('Tex-203-F'!$B$6=\"\",\"\",'Tex-203-F'!$B$6)","v":"Tex-203-F"},{"$f":"IF('Tex-203-F'!$D$21=\"\",\"\",'Tex-203-F'!$D$21)","v":"Sand Equivalent No. 1"},{"$f":"IF('Tex-203-F'!$D$27=\"\",\"\",'Tex-203-F'!$D$27)","v":"Sand Equivalent"},{"$f":"IF('Tex-203-F'!$E$29=\"\",\"\",'Tex-203-F'!$E$29)","v":"Reported:"}]
[9,{"$f":"IF('Tex-203-F'!$F$33=\"\",\"\",'Tex-203-F'!$F$33)","v":""},{"$f":"IF('Tex-203-F'!$B$6=\"\",\"\",'Tex-203-F'!$B$6)","v":"Tex-203-F"},{"$f":"IF('Tex-203-F'!$D$31=\"\",\"\",'Tex-203-F'!$D$31)","v":"Sand Equivalent No. 2"},{"$f":"IF('Tex-203-F'!$D$33=\"\",\"\",'Tex-203-F'!$D$33)","v":"Sand Reading:"}]
[10,{"$f":"IF('Tex-203-F'!$F$35=\"\",\"\",'Tex-203-F'!$F$35)","v":""},{"$f":"IF('Tex-203-F'!$B$6=\"\",\"\",'Tex-203-F'!$B$6)","v":"Tex-203-F"},{"$f":"IF('Tex-203-F'!$D$31=\"\",\"\",'Tex-203-F'!$D$31)","v":"Sand Equivalent No. 2"},{"$f":"IF('Tex-203-F'!$D$35=\"\",\"\",'Tex-203-F'!$D$35)","v":"Clay Reading:"}]
[11,{"$f":"IF('Tex-203-F'!$F$37=\"\",\"\",'Tex-203-F'!$F$37)","v":""},{"$f":"IF('Tex-203-F'!$B$6=\"\",\"\",'Tex-203-F'!$B$6)","v":"Tex-203-F"},{"$f":"IF('Tex-203-F'!$D$31=\"\",\"\",'Tex-203-F'!$D$31)","v":"Sand Equivalent No. 2"},{"$f":"IF('Tex-203-F'!$D$37=\"\",\"\",'Tex-203-F'!$D$37)","v":"Sand Equivalent"},{"$f":"IF('Tex-203-F'!$E$37=\"\",\"\",'Tex-203-F'!$E$37)","v":"Calculated:"}]
[12,{"$f":"IF('Tex-203-F'!$F$39=\"\",\"\",'Tex-203-F'!$F$39)","v":""},{"$f":"IF('Tex-203-F'!$B$6=\"\",\"\",'Tex-203-F'!$B$6)","v":"Tex-203-F"},{"$f":"IF('Tex-203-F'!$D$31=\"\",\"\",'Tex-203-F'!$D$31)","v":"Sand Equivalent No. 2"},{"$f":"IF('Tex-203-F'!$D$37=\"\",\"\",'Tex-203-F'!$D$37)","v":"Sand Equivalent"},{"$f":"IF('Tex-203-F'!$E$39=\"\",\"\",'Tex-203-F'!$E$39)","v":"Reported:"}]
[13,{"$f":"IF('Tex-203-F'!$F$41=\"\",\"\",'Tex-203-F'!$F$41)","v":""},{"$f":"IF('Tex-203-F'!$B$6=\"\",\"\",'Tex-203-F'!$B$6)","v":"Tex-203-F"},{"$f":"IF('Tex-203-F'!$C$41=\"\",\"\",'Tex-203-F'!$C$41)","v":"Average Sand Equivalent:"}]
[14,{"$f":"IF('Tex-203-F'!$C$52=\"\",\"\",'Tex-203-F'!$C$52)","v":""},"Sampled By ",{"$f":"IF('Tex-203-F'!$B$52=\"\",\"\",'Tex-203-F'!$B$52)","v":"TX221"}]
[15,{"$f":"IF('Tex-203-F'!$F$52=\"\",\"\",'Tex-203-F'!$F$52)","v":""},"Sampled Date ",{"$f":"IF('Tex-203-F'!$B$52=\"\",\"\",'Tex-203-F'!$B$52)","v":"TX221"}]
[16,{"$f":"IF('Tex-203-F'!$C$54=\"\",\"\",'Tex-203-F'!$C$54)","v":""},"Sampled By ",{"$f":"IF('Tex-203-F'!$B$54=\"\",\"\",'Tex-203-F'!$B$54)","v":"TX400"}]
[17,{"$f":"IF('Tex-203-F'!$F$54=\"\",\"\",'Tex-203-F'!$F$54)","v":""},"Sampled Date ",{"$f":"IF('Tex-203-F'!$B$54=\"\",\"\",'Tex-203-F'!$B$54)","v":"TX400"}]