{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tex-620-J","RX","spcyr"],"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-620-J","index":0,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[[33,1,33,3],[33,5,33,7],[49,1,49,3],[45,6,45,8],[36,1,37,8],[43,2,43,4],[42,2,42,4],[39,1,39,8],[45,1,45,3],[38,1,38,8],[40,2,40,4],[41,2,41,4],[24,1,24,3],[25,1,25,3],[24,5,24,7],[25,5,25,7],[0,0,0,1],[12,7,12,8],[12,3,12,4],[13,3,13,4],[13,7,13,8],[7,7,7,8],[10,7,10,8],[7,3,7,4],[8,3,8,4],[8,7,8,8],[29,1,29,3],[31,1,31,3],[31,5,31,7],[27,5,27,7],[9,7,9,8],[9,3,9,4],[11,7,11,8],[16,3,16,4],[11,3,11,4],[15,3,15,8],[16,7,16,8],[10,3,10,4],[14,3,14,8],[26,5,26,7],[26,1,26,3],[27,1,27,3]]}
["TxDOT Manuals >",null,"Tex-620-J"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,"tx620.xlsm::45170.492407"]
[null,"DETERMINING CHLORIDE AND SULFATE CONTENT IN SOILS"]
[null,"Tex-620-J"]
[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: 09/01/23 11:49:04"}]
[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,"CHLORIDE",null,null,null,"SULFATE"]
[]
[null,"Sample Weight, (g):",null,null,30,"Sample Weight, (g):",null,null,30]
[null,"Ending, (mL.):",null,null,null,"Crucible + Residue Weight, (g):"]
[null,"Starting, (mL.):",null,null,null,"Crucible Weight,(g):"]
[null,"Total, (mL.):",null,null,{"$f":"IF(COUNTBLANK(E26:E27)=2,\"\",E26-E27)","v":""},"Residue Weight, (g):",null,null,{"$f":"IF(COUNTBLANK(I26:I27)=2,\"\",I26-I27)","v":""}]
[]
[null,"Normality of AgNO3:"]
[]
[null,"Chloride (Cl), (PPM):",null,null,{"$f":"IF(ISERROR((E28*3.545*E30*10*10000)/E25),\"\",(E28*3.545*E30*10*10000)/E25)","v":""},"Sulfate (SO4), (PPM):",null,null,{"$f":"IF(ISERROR((41.15*I28*10*10000)/I25),\"\",(41.15*I28*10*10000)/I25)","v":""}]
[]
[null,"Chloride (Cl), (PPM):",null,null,null,"Sulfate (SO4), (PPM):"]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2023-09-01T11:49:04.380"}]
[]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX100"," ",null,null," "]
[null,"Test Method:","Tested By:",null,null,"Tested Date:"]
[null,"TX620"," ",null,null," "]
[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":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[19]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF('Tex-620-J'!$B$37=\"\",\"\",'Tex-620-J'!$B$37)","v":""},{"$f":"'Tex-620-J'!$B$36","v":"Remarks:"}]
[2,{"$f":"IF('Tex-620-J'!$D$19=\"\",\"\",'Tex-620-J'!$D$19)","v":""},{"$f":"IF('Tex-620-J'!$C$19=\"\",\"\",'Tex-620-J'!$C$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('Tex-620-J'!$C$44=\"\",\"\",'Tex-620-J'!$C$44)","v":" "},"Tested By ",{"$f":"IF('Tex-620-J'!$B$44=\"\",\"\",'Tex-620-J'!$B$44)","v":"TX620"}]
[4,{"$f":"IF('Tex-620-J'!$F$44=\"\",\"\",'Tex-620-J'!$F$44)","v":" "},"Tested Date ",{"$f":"IF('Tex-620-J'!$B$44=\"\",\"\",'Tex-620-J'!$B$44)","v":"TX620"}]
[5,{"$f":"IF('Tex-620-J'!$E$25=\"\",\"\",'Tex-620-J'!$E$25)","v":30},{"$f":"IF('Tex-620-J'!$B$23=\"\",\"\",'Tex-620-J'!$B$23)","v":"CHLORIDE"},{"$f":"IF('Tex-620-J'!$B$25=\"\",\"\",'Tex-620-J'!$B$25)","v":"Sample Weight, (g):"}]
[6,{"$f":"IF('Tex-620-J'!$E$26=\"\",\"\",'Tex-620-J'!$E$26)","v":""},{"$f":"IF('Tex-620-J'!$B$23=\"\",\"\",'Tex-620-J'!$B$23)","v":"CHLORIDE"},{"$f":"IF('Tex-620-J'!$B$26=\"\",\"\",'Tex-620-J'!$B$26)","v":"Ending, (mL.):"}]
[7,{"$f":"IF('Tex-620-J'!$E$27=\"\",\"\",'Tex-620-J'!$E$27)","v":""},{"$f":"IF('Tex-620-J'!$B$23=\"\",\"\",'Tex-620-J'!$B$23)","v":"CHLORIDE"},{"$f":"IF('Tex-620-J'!$B$27=\"\",\"\",'Tex-620-J'!$B$27)","v":"Starting, (mL.):"}]
[8,{"$f":"IF('Tex-620-J'!$E$28=\"\",\"\",'Tex-620-J'!$E$28)","v":""},{"$f":"IF('Tex-620-J'!$B$23=\"\",\"\",'Tex-620-J'!$B$23)","v":"CHLORIDE"},{"$f":"IF('Tex-620-J'!$B$28=\"\",\"\",'Tex-620-J'!$B$28)","v":"Total, (mL.):"}]
[9,{"$f":"IF('Tex-620-J'!$E$30=\"\",\"\",'Tex-620-J'!$E$30)","v":""},{"$f":"IF('Tex-620-J'!$B$23=\"\",\"\",'Tex-620-J'!$B$23)","v":"CHLORIDE"},{"$f":"IF('Tex-620-J'!$B$30=\"\",\"\",'Tex-620-J'!$B$30)","v":"Normality of AgNO3:"}]
[10,{"$f":"IF('Tex-620-J'!$E$32=\"\",\"\",'Tex-620-J'!$E$32)","v":""},{"$f":"IF('Tex-620-J'!$B$23=\"\",\"\",'Tex-620-J'!$B$23)","v":"CHLORIDE"},{"$f":"IF('Tex-620-J'!$B$32=\"\",\"\",'Tex-620-J'!$B$32)","v":"Chloride (Cl), (PPM):"}]
[11,{"$f":"IF('Tex-620-J'!$E$34=\"\",\"\",'Tex-620-J'!$E$34)","v":""},{"$f":"IF('Tex-620-J'!$B$23=\"\",\"\",'Tex-620-J'!$B$23)","v":"CHLORIDE"},{"$f":"IF('Tex-620-J'!$B$34=\"\",\"\",'Tex-620-J'!$B$34)","v":"Chloride (Cl), (PPM):"}]
[12,{"$f":"IF('Tex-620-J'!$I$25=\"\",\"\",'Tex-620-J'!$I$25)","v":30},{"$f":"IF('Tex-620-J'!$F$23=\"\",\"\",'Tex-620-J'!$F$23)","v":"SULFATE"},{"$f":"IF('Tex-620-J'!$F$25=\"\",\"\",'Tex-620-J'!$F$25)","v":"Sample Weight, (g):"}]
[13,{"$f":"IF('Tex-620-J'!$I$26=\"\",\"\",'Tex-620-J'!$I$26)","v":""},{"$f":"IF('Tex-620-J'!$F$23=\"\",\"\",'Tex-620-J'!$F$23)","v":"SULFATE"},{"$f":"IF('Tex-620-J'!$F$26=\"\",\"\",'Tex-620-J'!$F$26)","v":"Crucible + Residue Weight, (g):"}]
[14,{"$f":"IF('Tex-620-J'!$I$27=\"\",\"\",'Tex-620-J'!$I$27)","v":""},{"$f":"IF('Tex-620-J'!$F$23=\"\",\"\",'Tex-620-J'!$F$23)","v":"SULFATE"},{"$f":"IF('Tex-620-J'!$F$27=\"\",\"\",'Tex-620-J'!$F$27)","v":"Crucible Weight,(g):"}]
[15,{"$f":"IF('Tex-620-J'!$I$28=\"\",\"\",'Tex-620-J'!$I$28)","v":""},{"$f":"IF('Tex-620-J'!$F$23=\"\",\"\",'Tex-620-J'!$F$23)","v":"SULFATE"},{"$f":"IF('Tex-620-J'!$F$28=\"\",\"\",'Tex-620-J'!$F$28)","v":"Residue Weight, (g):"}]
[16,{"$f":"IF('Tex-620-J'!$I$32=\"\",\"\",'Tex-620-J'!$I$32)","v":""},{"$f":"IF('Tex-620-J'!$F$23=\"\",\"\",'Tex-620-J'!$F$23)","v":"SULFATE"},{"$f":"IF('Tex-620-J'!$F$32=\"\",\"\",'Tex-620-J'!$F$32)","v":"Sulfate (SO4), (PPM):"}]
[17,{"$f":"IF('Tex-620-J'!$I$34=\"\",\"\",'Tex-620-J'!$I$34)","v":""},{"$f":"IF('Tex-620-J'!$F$23=\"\",\"\",'Tex-620-J'!$F$23)","v":"SULFATE"},{"$f":"IF('Tex-620-J'!$F$34=\"\",\"\",'Tex-620-J'!$F$34)","v":"Sulfate (SO4), (PPM):"}]
[18,{"$f":"IF('Tex-620-J'!$C$42=\"\",\"\",'Tex-620-J'!$C$42)","v":" "},"Sampled By ",{"$f":"IF('Tex-620-J'!$B$42=\"\",\"\",'Tex-620-J'!$B$42)","v":"TX100"}]
[19,{"$f":"IF('Tex-620-J'!$F$42=\"\",\"\",'Tex-620-J'!$F$42)","v":" "},"Sampled Date ",{"$f":"IF('Tex-620-J'!$B$42=\"\",\"\",'Tex-620-J'!$B$42)","v":"TX100"}]

{"sheet":"spcyr","index":2,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["spec1993","spec1995","spec2004"]
["Volumetric","Volumetric","Volumetric"]
["IC","IC","IC"]