{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Deleterious Material","RX"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":80,"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":"Deleterious Material","index":0,"n_rows":47,"n_cols":18,"rows_kept":47,"cut":false,"hidden":false,"merged":[[33,1,34,15],[25,12,25,13],[35,1,35,9],[14,5,14,15],[7,12,7,15],[7,5,7,8],[22,10,22,14],[11,12,11,15],[11,5,11,8],[16,5,16,8],[16,12,16,15],[24,1,26,1],[25,10,25,11],[18,5,18,6],[18,7,18,8],[18,13,18,15],[47,1,47,5],[42,7,42,8],[43,7,43,8],[41,1,41,2],[41,3,41,6],[36,1,36,9],[41,7,41,8],[45,1,45,2],[43,1,43,5],[43,9,43,13],[40,7,40,8],[40,4,40,6],[38,4,38,6],[38,7,38,8],[39,1,39,2],[39,3,39,6],[39,7,39,8],[0,0,0,1],[15,5,15,15],[8,12,8,15],[12,5,12,8],[13,5,13,8],[12,12,12,15],[10,12,10,15],[8,5,8,8],[10,5,10,8],[9,12,9,15],[9,5,9,8],[13,12,13,15],[27,2,27,3],[24,2,26,3],[30,2,30,10],[30,11,30,12],[24,4,24,15],[25,14,25,15],[25,4,25,5],[25,6,25,7],[25,8,25,9]]}
["TxDOT Manuals >",null,null,null,null,"Tex-413-A"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tx413.xlsm::45503.678322"]
[null,"DELETERIOUS MATERIALS"]
[null,"Tex-413-A"]
[null,null,null,null,null,null,null,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: 07/30/24 16:16:47"}]
[null,null,null,null,"SAMPLE ID:",null,null,null,null,null,null,"SAMPLED DATE:"]
[null,null,null,null,"TEST NUMBER:",null,null,null,null,null,null,"LETTING DATE:"]
[null,null,null,null,"SAMPLE STATUS:",null,null,null,null,null,null,"CONTROLLING CSJ:",""]
[null,null,null,null,"COUNTY:",null,null,null,null,null,null,"SPEC YEAR:"]
[null,null,null,null,"SAMPLED BY:",null,null,null,null,null,null,"SPEC ITEM:",""]
[null,null,null,null,"SAMPLE LOCATION:","",null,null,null,null,null,"SPECIAL PROVISION:"]
[null,null,null,null,"MATERIAL CODE:",null,null,null,null,null,null,"GRADE:"]
[null,null,null,null,"MATERIAL NAME:"]
[null,null,null,null,"PRODUCER:"]
[null,null,null,null,"AREA ENGINEER:","",null,null,null,null,null,"PROJECT MANAGER:"]
[]
[null,null,null,null,"COURSE\\LIFT:",null,null,"STATION:",null,null,null,null,"DIST. FROM CL:"]
[]
[null,"DELETERIOUS MATERIAL"]
[null,"Tex-413-A"]
[null,null,null,null,null,null,null,null,null,null,"Optional Test Method ASTM C142 used:"]
[]
[null,"Sieve Size","Total Weight of Sample (g)",null,"Deleterious Material"]
[null,null,null,null,"Clay",null,"Shale",null,"Friable",null,"Laminated",null,"Other",null,"Total"]
[null,null,null,null,"(g)","%","(g)","%","(g)","%","(g)","%","(g)","%","(g)","%"]
[null,{"$f":"IF(SpecYear=\"\",\"\",IF(Grade=\"FA\",\"+No.16\",IF(SpecYear=\"1995\",\"+4.75 mm\",\"+No.4\")))","v":""},null,null,null,{"$f":"IF(ISERROR(+E28/(RetainedTotal)),\"\",E28/(RetainedTotal)*100)","v":""},null,{"$f":"IF(ISERROR(+G28/(RetainedTotal)),\"\",G28/(RetainedTotal)*100)","v":""},null,{"$f":"IF(ISERROR(+I28/(RetainedTotal)),\"\",I28/(RetainedTotal)*100)","v":""},null,{"$f":"IF(ISERROR(+K28/(RetainedTotal)),\"\",K28/(RetainedTotal)*100)","v":""},null,{"$f":"IF(ISERROR(+M28/(RetainedTotal)),\"\",M28/(RetainedTotal)*100)","v":""},{"$f":"IF(COUNTBLANK(E28:N28)=10,\"\",SUM(E28,G28,I28,K28,M28))","v":""},{"$f":"IF(O28=\"\",\"\",SUM(F28,H28,J28,L28,N28))","v":""}]
[null,{"$f":"IF(Field4=\"\",\"NO GRADE SELECTED\",\"\")","v":"NO GRADE SELECTED"},null,null,{"$f":"IF(AND($M$14=\"FA\",E28 <>0),\"Clear value\",\"\")","v":""},{"$f":"+IF(AND(Grade=\"CA\",F28>0.25,Field7>0),\"OUT\",\"\")","v":""},{"$f":"IF(AND($M$14=\"FA\",G28 <>0),\"Clear value\",\"\")","v":""},{"$f":"IF(AND(Grade=\"CA\",H28>1,Field7>0),\"OUT\",\"\")","v":""},{"$f":"IF(AND($M$14=\"FA\",I28 <>0),\"Clear value\",\"\")","v":""},{"$f":"+IF(AND(Grade=\"CA\",J28>5,Field7>0),\"OUT\",\"\")","v":""},{"$f":"IF(AND($M$14=\"FA\",K28 <>0),\"Clear value\",\"\")","v":""},{"$f":"+IF(AND(Grade=\"CA\",L28>5,Field7>0),\"OUT\",\"\")","v":""},null,{"$f":"+IF(AND(Grade=\"FA\",N28>0.5,Field7>0),\"OUT\",\"\")","v":""}]
[]
[null,null,{"$f":"\"Percent Deleterious Material Retained on the \" & +B28 & \" Sieve, %:\"","v":"Percent Deleterious Material Retained on the  Sieve, %:"},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(+O28/(RetainedTotal)),\"\",+O28/(RetainedTotal)*100)","v":""}]
[]
[null,"Remarks:",null,null,{"$f":"NOW()","v":"2024-07-30T16:16:47.050"}]
[]
[]
[]
[]
[]
[null,"Sample Method:",null,null,"Sampled By:",null,null,"Sampled Date:"]
[null,"TX400"]
[null,"Test Method:",null,null,"Tested By:",null,null,"Tested Date:"]
[null,"TX413"]
[null,"Test Stamp Code:",null,null,null,null,"Omit Test:","Completed Date:",null,"Reviewed By:"]
[]
[null,"Locked By:",null,"TxDOT:","District:","Area:"]
[null,"",null,"","",""]
[null,"Authorized By:",null,null,null,null,"Authorized Date:"]

{"sheet":"RX","index":1,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[22]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF('Deleterious Material'!$B$34=\"\",\"\",'Deleterious Material'!$B$34)","v":""},{"$f":"'Deleterious Material'!$B$33","v":"Remarks:"}]
[2,{"$f":"IF('Deleterious Material'!$F$19=\"\",\"\",'Deleterious Material'!$F$19)","v":""},{"$f":"IF('Deleterious Material'!$E$19=\"\",\"\",'Deleterious Material'!$E$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('Deleterious Material'!$D$42=\"\",\"\",'Deleterious Material'!$D$42)","v":""},"Tested By ",{"$f":"IF('Deleterious Material'!$B$42=\"\",\"\",'Deleterious Material'!$B$42)","v":"TX413"}]
[4,{"$f":"IF('Deleterious Material'!$H$42=\"\",\"\",'Deleterious Material'!$H$42)","v":""},"Tested Date ",{"$f":"IF('Deleterious Material'!$B$42=\"\",\"\",'Deleterious Material'!$B$42)","v":"TX413"}]
[5,{"$f":"IF('Deleterious Material'!$B$28=\"\",\"\",'Deleterious Material'!$B$28)","v":""},{"$f":"IF('Deleterious Material'!$B$6=\"\",\"\",'Deleterious Material'!$B$6)","v":"Tex-413-A"},{"$f":"IF('Deleterious Material'!$B$25=\"\",\"\",'Deleterious Material'!$B$25)","v":"Sieve Size"}]
[6,{"$f":"IF('Deleterious Material'!$C$28=\"\",\"\",'Deleterious Material'!$C$28)","v":""},{"$f":"IF('Deleterious Material'!$B$6=\"\",\"\",'Deleterious Material'!$B$6)","v":"Tex-413-A"},{"$f":"IF('Deleterious Material'!$C$25=\"\",\"\",'Deleterious Material'!$C$25)","v":"Total Weight of Sample (g)"}]
[7,{"$f":"IF('Deleterious Material'!$E$28=\"\",\"\",'Deleterious Material'!$E$28)","v":""},{"$f":"IF('Deleterious Material'!$B$6=\"\",\"\",'Deleterious Material'!$B$6)","v":"Tex-413-A"},{"$f":"IF('Deleterious Material'!$E$26=\"\",\"\",'Deleterious Material'!$E$26)","v":"Clay"},{"$f":"IF('Deleterious Material'!$E$27=\"\",\"\",'Deleterious Material'!$E$27)","v":"(g)"}]
[8,{"$f":"IF('Deleterious Material'!$F$28=\"\",\"\",'Deleterious Material'!$F$28)","v":""},{"$f":"IF('Deleterious Material'!$B$6=\"\",\"\",'Deleterious Material'!$B$6)","v":"Tex-413-A"},{"$f":"IF('Deleterious Material'!$E$26=\"\",\"\",'Deleterious Material'!$E$26)","v":"Clay"},{"$f":"IF('Deleterious Material'!$F$27=\"\",\"\",'Deleterious Material'!$F$27)","v":"%"}]
[9,{"$f":"IF('Deleterious Material'!$G$28=\"\",\"\",'Deleterious Material'!$G$28)","v":""},{"$f":"IF('Deleterious Material'!$B$6=\"\",\"\",'Deleterious Material'!$B$6)","v":"Tex-413-A"},{"$f":"IF('Deleterious Material'!$G$26=\"\",\"\",'Deleterious Material'!$G$26)","v":"Shale"},{"$f":"IF('Deleterious Material'!$G$27=\"\",\"\",'Deleterious Material'!$G$27)","v":"(g)"}]
[10,{"$f":"IF('Deleterious Material'!$H$28=\"\",\"\",'Deleterious Material'!$H$28)","v":""},{"$f":"IF('Deleterious Material'!$B$6=\"\",\"\",'Deleterious Material'!$B$6)","v":"Tex-413-A"},{"$f":"IF('Deleterious Material'!$G$26=\"\",\"\",'Deleterious Material'!$G$26)","v":"Shale"},{"$f":"IF('Deleterious Material'!$H$27=\"\",\"\",'Deleterious Material'!$H$27)","v":"%"}]
[11,{"$f":"IF('Deleterious Material'!$I$28=\"\",\"\",'Deleterious Material'!$I$28)","v":""},{"$f":"IF('Deleterious Material'!$B$6=\"\",\"\",'Deleterious Material'!$B$6)","v":"Tex-413-A"},{"$f":"IF('Deleterious Material'!$I$26=\"\",\"\",'Deleterious Material'!$I$26)","v":"Friable"},{"$f":"IF('Deleterious Material'!$I$27=\"\",\"\",'Deleterious Material'!$I$27)","v":"(g)"}]
[12,{"$f":"IF('Deleterious Material'!$J$28=\"\",\"\",'Deleterious Material'!$J$28)","v":""},{"$f":"IF('Deleterious Material'!$B$6=\"\",\"\",'Deleterious Material'!$B$6)","v":"Tex-413-A"},{"$f":"IF('Deleterious Material'!$I$26=\"\",\"\",'Deleterious Material'!$I$26)","v":"Friable"},{"$f":"IF('Deleterious Material'!$J$27=\"\",\"\",'Deleterious Material'!$J$27)","v":"%"}]
[13,{"$f":"IF('Deleterious Material'!$K$28=\"\",\"\",'Deleterious Material'!$K$28)","v":""},{"$f":"IF('Deleterious Material'!$B$6=\"\",\"\",'Deleterious Material'!$B$6)","v":"Tex-413-A"},{"$f":"IF('Deleterious Material'!$K$26=\"\",\"\",'Deleterious Material'!$K$26)","v":"Laminated"},{"$f":"IF('Deleterious Material'!$K$27=\"\",\"\",'Deleterious Material'!$K$27)","v":"(g)"}]
[14,{"$f":"IF('Deleterious Material'!$L$28=\"\",\"\",'Deleterious Material'!$L$28)","v":""},{"$f":"IF('Deleterious Material'!$B$6=\"\",\"\",'Deleterious Material'!$B$6)","v":"Tex-413-A"},{"$f":"IF('Deleterious Material'!$K$26=\"\",\"\",'Deleterious Material'!$K$26)","v":"Laminated"},{"$f":"IF('Deleterious Material'!$L$27=\"\",\"\",'Deleterious Material'!$L$27)","v":"%"}]
[15,{"$f":"IF('Deleterious Material'!$M$28=\"\",\"\",'Deleterious Material'!$M$28)","v":""},{"$f":"IF('Deleterious Material'!$B$6=\"\",\"\",'Deleterious Material'!$B$6)","v":"Tex-413-A"},{"$f":"IF('Deleterious Material'!$M$26=\"\",\"\",'Deleterious Material'!$M$26)","v":"Other"},{"$f":"IF('Deleterious Material'!$M$27=\"\",\"\",'Deleterious Material'!$M$27)","v":"(g)"}]
[16,{"$f":"IF('Deleterious Material'!$N$28=\"\",\"\",'Deleterious Material'!$N$28)","v":""},{"$f":"IF('Deleterious Material'!$B$6=\"\",\"\",'Deleterious Material'!$B$6)","v":"Tex-413-A"},{"$f":"IF('Deleterious Material'!$M$26=\"\",\"\",'Deleterious Material'!$M$26)","v":"Other"},{"$f":"IF('Deleterious Material'!$N$27=\"\",\"\",'Deleterious Material'!$N$27)","v":"%"}]
[17,{"$f":"IF('Deleterious Material'!$O$28=\"\",\"\",'Deleterious Material'!$O$28)","v":""},{"$f":"IF('Deleterious Material'!$B$6=\"\",\"\",'Deleterious Material'!$B$6)","v":"Tex-413-A"},{"$f":"IF('Deleterious Material'!$O$26=\"\",\"\",'Deleterious Material'!$O$26)","v":"Total"},{"$f":"IF('Deleterious Material'!$O$27=\"\",\"\",'Deleterious Material'!$O$27)","v":"(g)"}]
[18,{"$f":"IF('Deleterious Material'!$P$28=\"\",\"\",'Deleterious Material'!$P$28)","v":""},{"$f":"IF('Deleterious Material'!$B$6=\"\",\"\",'Deleterious Material'!$B$6)","v":"Tex-413-A"},{"$f":"IF('Deleterious Material'!$O$26=\"\",\"\",'Deleterious Material'!$O$26)","v":"Total"},{"$f":"IF('Deleterious Material'!$P$27=\"\",\"\",'Deleterious Material'!$P$27)","v":"%"}]
[19,{"$f":"IF('Deleterious Material'!$L$31=\"\",\"\",'Deleterious Material'!$L$31)","v":""},{"$f":"IF('Deleterious Material'!$B$6=\"\",\"\",'Deleterious Material'!$B$6)","v":"Tex-413-A"},{"$f":"IF('Deleterious Material'!$C$31=\"\",\"\",'Deleterious Material'!$C$31)","v":"Percent Deleterious Material Retained on the  Sieve, %:"}]
[20,{"$f":"IF('Deleterious Material'!$P$23=\"\",\"\",'Deleterious Material'!$P$23)","v":""},{"$f":"IF('Deleterious Material'!$B$6=\"\",\"\",'Deleterious Material'!$B$6)","v":"Tex-413-A"},{"$f":"IF('Deleterious Material'!$K$23=\"\",\"\",'Deleterious Material'!$K$23)","v":"Optional Test Method ASTM C142 used:"}]
[21,{"$f":"IF('Deleterious Material'!$D$40=\"\",\"\",'Deleterious Material'!$D$40)","v":""},"Sampled By ",{"$f":"IF('Deleterious Material'!$B$40=\"\",\"\",'Deleterious Material'!$B$40)","v":"TX400"}]
[22,{"$f":"IF('Deleterious Material'!$H$40=\"\",\"\",'Deleterious Material'!$H$40)","v":""},"Sampled Date ",{"$f":"IF('Deleterious Material'!$B$40=\"\",\"\",'Deleterious Material'!$B$40)","v":"TX400"}]