{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tex-406-A","RX","Revisions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":90,"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-406-A","index":0,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":false,"merged":[[31,7,32,9],[45,4,45,6],[51,4,51,5],[69,1,69,3],[73,1,73,3],[69,6,69,8],[62,2,62,4],[55,1,56,8],[58,1,58,8],[57,1,57,8],[63,2,63,4],[65,2,65,4],[67,2,67,4],[59,2,59,4],[60,2,60,4],[23,2,23,7],[49,4,49,5],[35,1,35,6],[29,3,29,5],[33,1,33,7],[36,1,36,6],[37,1,37,6],[41,2,41,7],[38,5,38,6],[39,5,39,6],[28,3,28,5],[24,3,24,4],[31,4,31,5],[26,3,26,6],[43,4,43,5],[25,4,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],[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-406-A"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,"tx406.xlsm::45820.290683"]
[null,"DECANTATION TEST FOR CONCRETE AGGREGATES"]
[null,"Tex-406-A "]
[null,null,null,null,null,null,null,null,{"$f":"\"TX406 :: File Version: \" & TEXT(MID(sn,SEARCH(\"::\",sn,1)+2,20),\"mm/dd/yy hh:mm:ss\")","v":"TX406 :: File Version: 06/12/25 06:58:35"}]
[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,null,"Decantation Test for Concrete Aggregates"]
[null,null,"by:",null,null,{"$f":"IF(SpecYear=\"2014\", \"Class A, B or P?\", \"Item 0360?\")","v":"Item 0360?"},null,{"$f":"IF(version<1, IF(item0360=\"Yes\",3,IF($G$26=\"\",1.5,G26)), IF(Field20=\"Yes\",IF(AND(G52<>\"\",G52>=85),5,1.5),IF(AND(G52<>\"\",G52>=85),3,1.5)))","v":1.5}]
[null,null,null,null,"Specify Decant Limit:"]
[null,null,null,"Tex-406-A:Part I - Lab Method",null,null,null,"*Data must be removed for Part I."]
[]
[null,null,null,"Original Dry Mass of Sample (g)"]
[null,null,null,"Dry Mass After Washing (g)"]
[null,null,null,null,null,"% Loss :",{"$f":"IF(ISERROR((100*(G29-G30))/G29),\"\",(100*(G29-G30))/G29)","v":""},"ü"]
[null,null,null,null,{"$f":"\"Loss <= \"&SPEC&\"%\"","v":"Loss <= 1.5%"},null,{"$f":"IF(G31=\"\",\"\",IF($G$31<=SPEC,\"Yes\",\"*Fail\"))","v":""},{"$f":"IF(OR(AND(Field2=\"2014\",G31>1.5,G31<=5),AND(Field2=\"2004\",Field20=\"Yes\",G31>1,G31<=3)),\"Decant may be increased with Tex-406-A, Part III testing for crushed stone\", \"\")","v":""}]
[]
[null,"Tex-406-A:Part II - Field Method",null,null,null,null,null,null,"*Data must be removed for Part II."]
[]
[null,{"$f":"\"Mass of Pycnometer Containing Sample and Water To Fill Before Washing \"&IF(SpecYear=\"\",\"()\",IF(SpecYear=\"1995\",\"(kg)\",\"(lbs.)\"))&\":\"","v":"Mass of Pycnometer Containing Sample and Water To Fill Before Washing ():"}]
[null,{"$f":"\"Mass of Pycnometer Containing Sample and Water To Fill After Washing \"&IF(SpecYear=\"\",\"()\",IF(SpecYear=\"1995\",\"(kg)\",\"(lbs.)\"))&\":\"","v":"Mass of Pycnometer Containing Sample and Water To Fill After Washing ():"}]
[null,"Mass of Pycnometer Filled With Water at Approx. Same Temperature as above (g):"]
[null,null,null,null,null,"Percent Loss:",null,{"$f":"IF(ISERROR(100*((H36-H37)/(H36-H38))),\"\",100*((H36-H37)/(H36-H38)))","v":""},"ü"]
[null,null,null,null,null,{"$f":"IF($G$26=\"\",\"Loss <= \"&SPEC&\"%\",IF($G$25=\"Yes\",\"Loss <= \"&SPEC&\"%\",IF($G$25=\"No\",\"Loss <= \"&$G$26&\"%\",\"\")))","v":"Loss <= 1.5%"},null,{"$f":"IF(H39=\"\",\"\",IF(H39<=SPEC,\"Yes\",\"*Fail\"))","v":""},{"$f":"IF(OR(AND(Field2=\"2014\",H39>1.5,H39<=SPEC),AND(Field2=\"2004\",H39>1, H39<=SPEC)),\"*Requires Tex-406-A, Part III testing\", \"\")","v":""}]
[]
[null,null,"Tex-406-A:Part III - Percent of Limestone in Decantation Material"]
[]
[null,null,null,null,"Normality of HCL Used"]
[]
[null,null,null,null,"Volume of HCL Used in Titration mL "]
[null,null,null,null,null,"Starting mL:"]
[null,null,null,null,null,"Ending mL:"]
[]
[null,null,null,null,"Sample Weight (g)"]
[]
[null,null,null,null,"Percent of Limestone:",null,{"$f":"IF(ISERROR(5*(G44*(G48-G47)/G50)),\"\",5*(G44*(G48-G47)/G50))","v":""},"ü"]
[]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2025-06-12T06:58:35.690"}]
[]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX400"]
[]
[null,"Test Method:","Tested By:",null,null,"Tested Date:"]
[null,"TX406"]
[]
[null,"TX406PI"]
[]
[null,"TX406PII"]
[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":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[{"$f":"COUNT(A2:A2002)","v":27}]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF('Tex-406-A'!$B$56=\"\",\"\",'Tex-406-A'!$B$56)","v":""},{"$f":"'Tex-406-A'!$B$55","v":"Remarks:"}]
[2,{"$f":"IF('Tex-406-A'!$D$19=\"\",\"\",'Tex-406-A'!$D$19)","v":""},{"$f":"IF('Tex-406-A'!$C$19=\"\",\"\",'Tex-406-A'!$C$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('Tex-406-A'!$C$64=\"\",\"\",'Tex-406-A'!$C$64)","v":""},"Tested By ",{"$f":"IF('Tex-406-A'!$B$64=\"\",\"\",'Tex-406-A'!$B$64)","v":"TX406"}]
[4,{"$f":"IF('Tex-406-A'!$F$64=\"\",\"\",'Tex-406-A'!$F$64)","v":""},"Tested Date ",{"$f":"IF('Tex-406-A'!$B$64=\"\",\"\",'Tex-406-A'!$B$64)","v":"TX406"}]
[5,{"$f":"IF('Tex-406-A'!$D$25=\"\",\"\",'Tex-406-A'!$D$25)","v":""},{"$f":"IF('Tex-406-A'!$B$6=\"\",\"\",'Tex-406-A'!$B$6)","v":"Tex-406-A "},{"$f":"IF('Tex-406-A'!$C$24=\"\",\"\",'Tex-406-A'!$C$24)","v":"Decantation Test for Concrete Aggregates"}]
[6,{"$f":"IF('Tex-406-A'!$G$29=\"\",\"\",'Tex-406-A'!$G$29)","v":""},{"$f":"IF('Tex-406-A'!$D$27=\"\",\"\",'Tex-406-A'!$D$27)","v":"Tex-406-A:Part I - Lab Method"},{"$f":"IF('Tex-406-A'!$D$29=\"\",\"\",'Tex-406-A'!$D$29)","v":"Original Dry Mass of Sample (g)"}]
[7,{"$f":"IF('Tex-406-A'!$G$30=\"\",\"\",'Tex-406-A'!$G$30)","v":""},{"$f":"IF('Tex-406-A'!$D$27=\"\",\"\",'Tex-406-A'!$D$27)","v":"Tex-406-A:Part I - Lab Method"},{"$f":"IF('Tex-406-A'!$D$30=\"\",\"\",'Tex-406-A'!$D$30)","v":"Dry Mass After Washing (g)"}]
[8,{"$f":"IF('Tex-406-A'!$G$31=\"\",\"\",'Tex-406-A'!$G$31)","v":""},{"$f":"IF('Tex-406-A'!$D$27=\"\",\"\",'Tex-406-A'!$D$27)","v":"Tex-406-A:Part I - Lab Method"},{"$f":"IF('Tex-406-A'!$F$31=\"\",\"\",'Tex-406-A'!$F$31)","v":"% Loss :"}]
[9,{"$f":"IF('Tex-406-A'!$G$32=\"\",\"\",'Tex-406-A'!$G$32)","v":""},{"$f":"IF('Tex-406-A'!$D$27=\"\",\"\",'Tex-406-A'!$D$27)","v":"Tex-406-A:Part I - Lab Method"},{"$f":"IF('Tex-406-A'!$E$32=\"\",\"\",'Tex-406-A'!$E$32)","v":"Loss <= 1.5%"}]
[10,{"$f":"IF('Tex-406-A'!$H$36=\"\",\"\",'Tex-406-A'!$H$36)","v":""},{"$f":"IF('Tex-406-A'!$B$34=\"\",\"\",'Tex-406-A'!$B$34)","v":"Tex-406-A:Part II - Field Method"},{"$f":"IF('Tex-406-A'!$B$36=\"\",\"\",'Tex-406-A'!$B$36)","v":"Mass of Pycnometer Containing Sample and Water To Fill Before Washing ():"}]
[11,{"$f":"IF('Tex-406-A'!$H$37=\"\",\"\",'Tex-406-A'!$H$37)","v":""},{"$f":"IF('Tex-406-A'!$B$34=\"\",\"\",'Tex-406-A'!$B$34)","v":"Tex-406-A:Part II - Field Method"},{"$f":"IF('Tex-406-A'!$B$37=\"\",\"\",'Tex-406-A'!$B$37)","v":"Mass of Pycnometer Containing Sample and Water To Fill After Washing ():"}]
[12,{"$f":"IF('Tex-406-A'!$H$38=\"\",\"\",'Tex-406-A'!$H$38)","v":""},{"$f":"IF('Tex-406-A'!$B$34=\"\",\"\",'Tex-406-A'!$B$34)","v":"Tex-406-A:Part II - Field Method"},{"$f":"IF('Tex-406-A'!$B$38=\"\",\"\",'Tex-406-A'!$B$38)","v":"Mass of Pycnometer Filled With Water at Approx. Same Temperature as above (g):"}]
[13,{"$f":"IF('Tex-406-A'!$H$39=\"\",\"\",'Tex-406-A'!$H$39)","v":""},{"$f":"IF('Tex-406-A'!$B$34=\"\",\"\",'Tex-406-A'!$B$34)","v":"Tex-406-A:Part II - Field Method"},{"$f":"IF('Tex-406-A'!$F$39=\"\",\"\",'Tex-406-A'!$F$39)","v":"Percent Loss:"}]
[14,{"$f":"IF('Tex-406-A'!$H$40=\"\",\"\",'Tex-406-A'!$H$40)","v":""},{"$f":"IF('Tex-406-A'!$B$34=\"\",\"\",'Tex-406-A'!$B$34)","v":"Tex-406-A:Part II - Field Method"},{"$f":"IF('Tex-406-A'!$F$40=\"\",\"\",'Tex-406-A'!$F$40)","v":"Loss <= 1.5%"}]
[15,{"$f":"IF('Tex-406-A'!$G$44=\"\",\"\",'Tex-406-A'!$G$44)","v":""},{"$f":"IF('Tex-406-A'!$C$42=\"\",\"\",'Tex-406-A'!$C$42)","v":"Tex-406-A:Part III - Percent of Limestone in Decantation Material"},{"$f":"IF('Tex-406-A'!$E$44=\"\",\"\",'Tex-406-A'!$E$44)","v":"Normality of HCL Used"}]
[16,{"$f":"IF('Tex-406-A'!$G$47=\"\",\"\",'Tex-406-A'!$G$47)","v":""},{"$f":"IF('Tex-406-A'!$C$42=\"\",\"\",'Tex-406-A'!$C$42)","v":"Tex-406-A:Part III - Percent of Limestone in Decantation Material"},{"$f":"IF('Tex-406-A'!$E$46=\"\",\"\",'Tex-406-A'!$E$46)","v":"Volume of HCL Used in Titration mL "},{"$f":"IF('Tex-406-A'!$F$47=\"\",\"\",'Tex-406-A'!$F$47)","v":"Starting mL:"}]
[17,{"$f":"IF('Tex-406-A'!$G$48=\"\",\"\",'Tex-406-A'!$G$48)","v":""},{"$f":"IF('Tex-406-A'!$C$42=\"\",\"\",'Tex-406-A'!$C$42)","v":"Tex-406-A:Part III - Percent of Limestone in Decantation Material"},{"$f":"IF('Tex-406-A'!$E$46=\"\",\"\",'Tex-406-A'!$E$46)","v":"Volume of HCL Used in Titration mL "},{"$f":"IF('Tex-406-A'!$F$48=\"\",\"\",'Tex-406-A'!$F$48)","v":"Ending mL:"}]
[18,{"$f":"IF('Tex-406-A'!$G$50=\"\",\"\",'Tex-406-A'!$G$50)","v":""},{"$f":"IF('Tex-406-A'!$C$42=\"\",\"\",'Tex-406-A'!$C$42)","v":"Tex-406-A:Part III - Percent of Limestone in Decantation Material"},{"$f":"IF('Tex-406-A'!$E$50=\"\",\"\",'Tex-406-A'!$E$50)","v":"Sample Weight (g)"}]
[19,{"$f":"IF('Tex-406-A'!$G$52=\"\",\"\",'Tex-406-A'!$G$52)","v":""},{"$f":"IF('Tex-406-A'!$C$42=\"\",\"\",'Tex-406-A'!$C$42)","v":"Tex-406-A:Part III - Percent of Limestone in Decantation Material"},{"$f":"IF('Tex-406-A'!$E$52=\"\",\"\",'Tex-406-A'!$E$52)","v":"Percent of Limestone:"}]
[20,{"$f":"IF('Tex-406-A'!$G$25=\"\",\"\",'Tex-406-A'!$G$25)","v":""},{"$f":"IF('Tex-406-A'!$B$6=\"\",\"\",'Tex-406-A'!$B$6)","v":"Tex-406-A "},{"$f":"IF('Tex-406-A'!F25=\"\",\"\",'Tex-406-A'!F25)","v":"Item 0360?"}]
[21,{"$f":"IF('Tex-406-A'!$G$26=\"\",\"\",'Tex-406-A'!$G$26)","v":""},{"$f":"IF('Tex-406-A'!$B$6=\"\",\"\",'Tex-406-A'!$B$6)","v":"Tex-406-A "},{"$f":"IF('Tex-406-A'!E26=\"\",\"\",'Tex-406-A'!E26)","v":"Specify Decant Limit:"}]
[22,{"$f":"IF('Tex-406-A'!$C$66=\"\",\"\",'Tex-406-A'!$C$66)","v":""},"Tested By ",{"$f":"IF('Tex-406-A'!$B$66=\"\",\"\",'Tex-406-A'!$B$66)","v":"TX406PI"}]
[23,{"$f":"IF('Tex-406-A'!$F$66=\"\",\"\",'Tex-406-A'!$F$66)","v":""},"Tested Date ",{"$f":"IF('Tex-406-A'!$B$66=\"\",\"\",'Tex-406-A'!$B$66)","v":"TX406PI"}]
[24,{"$f":"IF('Tex-406-A'!$C$68=\"\",\"\",'Tex-406-A'!$C$68)","v":""},"Tested By ",{"$f":"IF('Tex-406-A'!$B$68=\"\",\"\",'Tex-406-A'!$B$68)","v":"TX406PII"}]
[25,{"$f":"IF('Tex-406-A'!$F$68=\"\",\"\",'Tex-406-A'!$F$68)","v":""},"Tested Date ",{"$f":"IF('Tex-406-A'!$B$68=\"\",\"\",'Tex-406-A'!$B$68)","v":"TX406PII"}]
[26,{"$f":"IF('Tex-406-A'!$C$61=\"\",\"\",'Tex-406-A'!$C$61)","v":""},"Sampled By ",{"$f":"IF('Tex-406-A'!$B$61=\"\",\"\",'Tex-406-A'!$B$61)","v":"TX400"}]
[27,{"$f":"IF('Tex-406-A'!$F$61=\"\",\"\",'Tex-406-A'!$F$61)","v":""},"Sampled Date ",{"$f":"IF('Tex-406-A'!$B$61=\"\",\"\",'Tex-406-A'!$B$61)","v":"TX400"}]

{"sheet":"Revisions","index":2,"n_rows":5,"n_cols":3,"rows_kept":5,"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"]
["2025-06-10","Added 2024 in the SPEC YEAR dropdown list","S. Rahman"]