{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tex-217-F","RX","Sieve Selection"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":97,"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-217-F","index":0,"n_rows":76,"n_cols":11,"rows_kept":76,"cut":false,"hidden":false,"merged":[[0,0,0,1],[15,3,15,8],[12,3,12,4],[12,7,12,8],[13,7,13,8],[7,7,7,8],[10,7,10,8],[11,7,11,8],[9,3,9,4],[8,7,8,8],[7,3,7,4],[11,3,11,4],[10,3,10,4],[8,3,8,4],[9,7,9,8],[13,3,13,4],[25,4,25,5],[16,3,16,4],[23,6,24,7],[16,7,16,8],[23,1,24,1],[23,2,24,3],[23,4,24,5],[14,3,14,8],[71,6,71,8],[32,4,32,5],[32,2,32,3],[32,6,32,7],[30,6,31,7],[25,6,25,7],[43,7,48,8],[25,2,25,3],[37,2,38,3],[37,4,38,5],[39,4,39,5],[39,2,39,3],[41,6,42,6],[54,1,54,8],[53,1,53,8],[30,1,31,1],[30,4,31,5],[30,2,31,3],[67,2,67,4],[41,7,42,8],[47,4,47,5],[48,4,48,5],[41,2,42,2],[41,3,42,3],[37,1,38,1],[75,1,75,3],[61,2,61,4],[41,1,42,1],[41,4,42,5],[71,1,71,3],[44,4,44,5],[43,4,43,5],[59,2,59,4],[56,2,56,4],[57,2,57,4],[45,4,45,5],[46,4,46,5],[63,2,63,4],[65,2,65,4],[60,2,60,4],[51,1,52,8]]}
["TxDOT Manuals >",null,null,"Tex-217-F"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,"tx217.xlsm::45574.627176"]
[null,"DELETERIOUS MATERIALS & DECANTATION FOR COARSE AGGR "]
[null,"Tex-217-F"]
[null,null,null,null,null,null,null,null,{"$f":"\"TX217 :: File Version: \" & TEXT(MID(sn,SEARCH(\"::\",sn,1)+2,20),\"mm/dd/yy hh:mm:ss\")","v":"TX217 :: File Version: 10/09/24 15:03:08"}]
[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,"DELETERIOUS MATERIAL"]
[null,"Tex-217-F Part I"]
[]
[null,"Sieve Size","Original Weight Retained (g)",null,"Weight of Deleterious Material (g)",null,"Percent of Deleterious Material"]
[]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(100*($E26/$C26)),\"\",100*($E26/$C26))","v":""}]
[]
[null,"DECANTATION"]
[null,"Tex-217-F Part II"]
[]
[null,"Sieve Size","Original Weight Retained (g)",null,"Dry Weight after Washing (g)",null,"Percent Loss by Decantation"]
[]
[null,null,null,null,null,null,{"$f":"IF(ISERROR(100*(($C33-$E33)/$C33)),\"\",100*(($C33-$E33)/$C33))","v":""}]
[]
[null,"DELETERIOUS MATERIAL IN RECYCLED ASPHALT SHINGLES"]
[null,"Tex-217-F Part III"]
[]
[null,"Initial Sample Weight (g)","Sample Weight After Magnet Test (g)",null,"Weight of Material Retained by Magnet (g)"]
[]
[null,null,null,null,{"$f":"IF(B40=\"\",\"\",B40-C40)","v":""}]
[]
[null,"Material","Weight of Sample Prior to Igniton (g)","Weight of Sample After Igniton (g)","Weight of Deleterious Material (g)",null,null,"Percent of Deleterious Material"]
[]
[null,"Retained on the No.30 Sieve",null,null,{"$f":"IF(C44=\"\",\"\",C44-D44)","v":""},null,null,{"$f":"IF(version>1,IF(ISERROR(((E40+E46+E47+E48+E49)/B40)*100),\"\",((E40+E46+E47+E48+E49)/B40)*100),IF(ISERROR((E40+E44+E45)/B40*100),\"\",(E40+E44+E45)/B40*100))","v":""}]
[null,"Passing the   No. 30 Sieve",null,null,{"$f":"IF(C45=\"\",\"\",C45-D45)","v":""}]
[null,"Retained on the 3/8 Sieve"]
[null,"Retained on the No. 4 Sieve"]
[null,"Retained on the No. 8 Sieve"]
[null,"Retained on the No. 30 Sieve"]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2024-10-09T15:03:08.710"}]
[]
[]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX221"]
[]
[null,"TX400"]
[null,"Test Method:","Tested By:",null,null,"Tested Date:"]
[null,"TX217"]
[]
[null,"TX217PI"]
[]
[null,"TX217PII"]
[]
[null,"TX217PIII"]
[]
[]
[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:"]
[null,null,null,null,null,{"$f":"IF(OR(AuthorizedDate>40819,AuthorizedDate=\"\"),2,1)","v":2}]

{"sheet":"RX","index":1,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[29]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF('Tex-217-F'!$B$52=\"\",\"\",'Tex-217-F'!$B$52)","v":""},{"$f":"'Tex-217-F'!$B$51","v":"Remarks:"}]
[2,{"$f":"IF('Tex-217-F'!$D$19=\"\",\"\",'Tex-217-F'!$D$19)","v":""},{"$f":"IF('Tex-217-F'!$C$19=\"\",\"\",'Tex-217-F'!$C$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('Tex-217-F'!$C$62=\"\",\"\",'Tex-217-F'!$C$62)","v":""},"Tested By ",{"$f":"IF('Tex-217-F'!$B$62=\"\",\"\",'Tex-217-F'!$B$62)","v":"TX217"}]
[4,{"$f":"IF('Tex-217-F'!$F$62=\"\",\"\",'Tex-217-F'!$F$62)","v":""},"Tested Date ",{"$f":"IF('Tex-217-F'!$B$62=\"\",\"\",'Tex-217-F'!$B$62)","v":"TX217"}]
[5,{"$f":"IF('Tex-217-F'!$B$26=\"\",\"\",'Tex-217-F'!$B$26)","v":""},{"$f":"IF('Tex-217-F'!$B$22=\"\",\"\",'Tex-217-F'!$B$22)","v":"Tex-217-F Part I"},{"$f":"IF('Tex-217-F'!$B$24=\"\",\"\",'Tex-217-F'!$B$24)","v":"Sieve Size"}]
[6,{"$f":"IF('Tex-217-F'!$C$26=\"\",\"\",'Tex-217-F'!$C$26)","v":""},{"$f":"IF('Tex-217-F'!$B$22=\"\",\"\",'Tex-217-F'!$B$22)","v":"Tex-217-F Part I"},{"$f":"IF('Tex-217-F'!$C$24=\"\",\"\",'Tex-217-F'!$C$24)","v":"Original Weight Retained (g)"}]
[7,{"$f":"IF('Tex-217-F'!$E$26=\"\",\"\",'Tex-217-F'!$E$26)","v":""},{"$f":"IF('Tex-217-F'!$B$22=\"\",\"\",'Tex-217-F'!$B$22)","v":"Tex-217-F Part I"},{"$f":"IF('Tex-217-F'!$E$24=\"\",\"\",'Tex-217-F'!$E$24)","v":"Weight of Deleterious Material (g)"}]
[8,{"$f":"IF('Tex-217-F'!$G$26=\"\",\"\",'Tex-217-F'!$G$26)","v":""},{"$f":"IF('Tex-217-F'!$B$22=\"\",\"\",'Tex-217-F'!$B$22)","v":"Tex-217-F Part I"},{"$f":"IF('Tex-217-F'!$G$24=\"\",\"\",'Tex-217-F'!$G$24)","v":"Percent of Deleterious Material"}]
[9,{"$f":"IF('Tex-217-F'!$B$33=\"\",\"\",'Tex-217-F'!$B$33)","v":""},{"$f":"IF('Tex-217-F'!$B$29=\"\",\"\",'Tex-217-F'!$B$29)","v":"Tex-217-F Part II"},{"$f":"IF('Tex-217-F'!$B$31=\"\",\"\",'Tex-217-F'!$B$31)","v":"Sieve Size"}]
[10,{"$f":"IF('Tex-217-F'!$C$33=\"\",\"\",'Tex-217-F'!$C$33)","v":""},{"$f":"IF('Tex-217-F'!$B$29=\"\",\"\",'Tex-217-F'!$B$29)","v":"Tex-217-F Part II"},{"$f":"IF('Tex-217-F'!$C$31=\"\",\"\",'Tex-217-F'!$C$31)","v":"Original Weight Retained (g)"}]
[11,{"$f":"IF('Tex-217-F'!$E$33=\"\",\"\",'Tex-217-F'!$E$33)","v":""},{"$f":"IF('Tex-217-F'!$B$29=\"\",\"\",'Tex-217-F'!$B$29)","v":"Tex-217-F Part II"},{"$f":"IF('Tex-217-F'!$E$31=\"\",\"\",'Tex-217-F'!$E$31)","v":"Dry Weight after Washing (g)"}]
[12,{"$f":"IF('Tex-217-F'!$G$33=\"\",\"\",'Tex-217-F'!$G$33)","v":""},{"$f":"IF('Tex-217-F'!$B$29=\"\",\"\",'Tex-217-F'!$B$29)","v":"Tex-217-F Part II"},{"$f":"IF('Tex-217-F'!$G$31=\"\",\"\",'Tex-217-F'!$G$31)","v":"Percent Loss by Decantation"}]
[13,{"$f":"IF(Field16=\"\",\"\",Field16)","v":""},{"$f":"IF('Tex-217-F'!B$36=\"\",\"\",'Tex-217-F'!B$36)","v":"Tex-217-F Part III"},{"$f":"IF('Tex-217-F'!B38=\"\",\"\",'Tex-217-F'!B38)","v":"Initial Sample Weight (g)"}]
[14,{"$f":"IF(Field17=\"\",\"\",Field17)","v":""},{"$f":"IF('Tex-217-F'!B$36=\"\",\"\",'Tex-217-F'!B$36)","v":"Tex-217-F Part III"},{"$f":"IF('Tex-217-F'!C38=\"\",\"\",'Tex-217-F'!C38)","v":"Sample Weight After Magnet Test (g)"}]
[15,{"$f":"IF(Field18=\"\",\"\",Field18)","v":""},{"$f":"IF('Tex-217-F'!B$36=\"\",\"\",'Tex-217-F'!B$36)","v":"Tex-217-F Part III"},{"$f":"'Tex-217-F'!B44","v":"Retained on the No.30 Sieve"},{"$f":"'Tex-217-F'!$C$42","v":"Weight of Sample Prior to Igniton (g)"}]
[16,{"$f":"IF(Field19=\"\",\"\",Field19)","v":""},{"$f":"IF('Tex-217-F'!B$36=\"\",\"\",'Tex-217-F'!B$36)","v":"Tex-217-F Part III"},{"$f":"'Tex-217-F'!B44","v":"Retained on the No.30 Sieve"},{"$f":"'Tex-217-F'!$D$42","v":"Weight of Sample After Igniton (g)"}]
[17,{"$f":"IF(Field20=\"\",\"\",Field20)","v":""},{"$f":"IF('Tex-217-F'!B$36=\"\",\"\",'Tex-217-F'!B$36)","v":"Tex-217-F Part III"},{"$f":"'Tex-217-F'!B45","v":"Passing the   No. 30 Sieve"},{"$f":"'Tex-217-F'!$C$42","v":"Weight of Sample Prior to Igniton (g)"}]
[18,{"$f":"IF(Field21=\"\",\"\",Field21)","v":""},{"$f":"IF('Tex-217-F'!B$36=\"\",\"\",'Tex-217-F'!B$36)","v":"Tex-217-F Part III"},{"$f":"'Tex-217-F'!B45","v":"Passing the   No. 30 Sieve"},{"$f":"'Tex-217-F'!$D$42","v":"Weight of Sample After Igniton (g)"}]
[19,{"$f":"'Tex-217-F'!H44","v":""},{"$f":"IF('Tex-217-F'!B$36=\"\",\"\",'Tex-217-F'!B$36)","v":"Tex-217-F Part III"},{"$f":"'Tex-217-F'!H42","v":"Percent of Deleterious Material"}]
[20,{"$f":"IF('Tex-217-F'!$C$64=\"\",\"\",'Tex-217-F'!$C$64)","v":""},"Tested By ",{"$f":"IF('Tex-217-F'!$B$64=\"\",\"\",'Tex-217-F'!$B$64)","v":"TX217PI"}]
[21,{"$f":"IF('Tex-217-F'!$F$64=\"\",\"\",'Tex-217-F'!$F$64)","v":""},"Tested Date ",{"$f":"IF('Tex-217-F'!$B$64=\"\",\"\",'Tex-217-F'!$B$64)","v":"TX217PI"}]
[22,{"$f":"IF('Tex-217-F'!$C$66=\"\",\"\",'Tex-217-F'!$C$66)","v":""},"Tested By ",{"$f":"IF('Tex-217-F'!$B$66=\"\",\"\",'Tex-217-F'!$B$66)","v":"TX217PII"}]
[23,{"$f":"IF('Tex-217-F'!$F$66=\"\",\"\",'Tex-217-F'!$F$66)","v":""},"Tested Date ",{"$f":"IF('Tex-217-F'!$B$66=\"\",\"\",'Tex-217-F'!$B$66)","v":"TX217PII"}]
[24,{"$f":"IF('Tex-217-F'!$C$68=\"\",\"\",'Tex-217-F'!$C$68)","v":""},"Tested By ",{"$f":"IF('Tex-217-F'!$B$68=\"\",\"\",'Tex-217-F'!$B$68)","v":"TX217PIII"}]
[25,{"$f":"IF('Tex-217-F'!$F$68=\"\",\"\",'Tex-217-F'!$F$68)","v":""},"Tested Date ",{"$f":"IF('Tex-217-F'!$B$68=\"\",\"\",'Tex-217-F'!$B$68)","v":"TX217PIII"}]
[26,{"$f":"IF('Tex-217-F'!$C$58=\"\",\"\",'Tex-217-F'!$C$58)","v":""},"Sampled By ",{"$f":"IF('Tex-217-F'!$B$58=\"\",\"\",'Tex-217-F'!$B$58)","v":"TX221"}]
[27,{"$f":"IF('Tex-217-F'!$F$58=\"\",\"\",'Tex-217-F'!$F$58)","v":""},"Sampled Date ",{"$f":"IF('Tex-217-F'!$B$58=\"\",\"\",'Tex-217-F'!$B$58)","v":"TX221"}]
[28,{"$f":"IF('Tex-217-F'!$C$60=\"\",\"\",'Tex-217-F'!$C$60)","v":""},"Sampled By ",{"$f":"IF('Tex-217-F'!$B$60=\"\",\"\",'Tex-217-F'!$B$60)","v":"TX400"}]
[29,{"$f":"IF('Tex-217-F'!$F$60=\"\",\"\",'Tex-217-F'!$F$60)","v":""},"Sampled Date ",{"$f":"IF('Tex-217-F'!$B$60=\"\",\"\",'Tex-217-F'!$B$60)","v":"TX400"}]

{"sheet":"Sieve Selection","index":2,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Sieve Size Inches","Sieve Size Metric","Sieve Size 2004","Selection"]
["No. 4","4.75 mm","No. 4",{"$f":"IF(SpecYear=\"\",\"Spec Year?\",IF(SpecYear=\"1995\",B2,IF(OR(SpecYear=\"2004\",SpecYear=\"2014\",SpecYear=\"2024\"),C2,A2)))","v":"Spec Year?"}]
["No. 10","2 mm","No. 8",{"$f":"IF(SpecYear=\"\",\"Spec Year?\",IF(SpecYear=\"1995\",B3,IF(OR(SpecYear=\"2004\",SpecYear=\"2014\",SpecYear=\"2024\"),C3,A3)))","v":"Spec Year?"}]