{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Flakiness Index","RX","Sieves"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":65,"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":"Flakiness Index","index":0,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,1],[7,3,7,4],[7,7,7,8],[9,3,9,4],[10,7,10,8],[8,3,8,4],[8,7,8,8],[10,3,10,4],[9,7,9,8],[27,5,27,6],[29,3,29,4],[20,5,20,7],[27,2,27,3],[20,4,22,4],[21,2,22,2],[21,3,22,3],[20,2,20,3],[14,3,14,8],[16,7,16,8],[15,3,15,8],[16,3,16,4],[11,7,11,8],[13,3,13,4],[13,7,13,8],[12,7,12,8],[11,3,11,4],[12,3,12,4],[46,1,46,3],[42,6,42,8],[32,1,33,8],[40,2,40,4],[39,2,39,4],[35,1,35,8],[42,1,42,3],[34,1,34,8],[37,2,37,4],[38,2,38,4]]}
["TxDOT Manuals >",null,null,"Tex-224-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,2]
[null,null,null,null,null,null,null,null,null,null,"tx224.xlsm::45574.634155"]
[null,"DETERMINING FLAKINESS INDEX"]
[null,"Tex-224-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 15:13:11"}]
[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,"Particle Size Range",null,"Number of Particles","Number of Particles Passing"]
[null,null,"Passing","Retained",null,{"$f":"IF(SpecYear=\"\",\"\",IF($H$11=\"1995\",Sieves!$E7,Sieves!$B7))","v":""},{"$f":"IF(SpecYear=\"\",\"\",IF($H$11=\"1995\",Sieves!$E8,Sieves!$B8))","v":""},{"$f":"IF(SpecYear=\"\",\"\",IF($H$11=\"1995\",Sieves!$E9,Sieves!$B9))","v":""}]
[null,null,null,null,null,"slot","slot","slot"]
[null,null,{"$f":"IF(SpecYear=\"\",\"\",IF($H$11=\"1995\",Sieves!$E3,Sieves!$B3))","v":""},{"$f":"IF(SpecYear=\"\",\"\",IF($H$11=\"1995\",Sieves!$F3,Sieves!$C3))","v":""}]
[null,null,{"$f":"IF(SpecYear=\"\",\"\",IF($H$11=\"1995\",Sieves!$E4,Sieves!$B4))","v":""},{"$f":"IF(SpecYear=\"\",\"\",IF($H$11=\"1995\",Sieves!$F4,Sieves!$C4))","v":""}]
[null,null,{"$f":"IF(SpecYear=\"\",\"\",IF($H$11=\"1995\",Sieves!$E5,Sieves!$B5))","v":""},{"$f":"IF(SpecYear=\"\",\"\",IF($H$11=\"1995\",Sieves!$F5,Sieves!$C5))","v":""}]
[]
[null,null,"Total Particles:",null,{"$f":"IF(AND(Field7=\"\",Field9=\"\",Field11=\"\"),\"\",SUM(E24:E26))","v":""},"Total Passing Particles:",null,{"$f":"IF(AND(Field8=\"\",Field10=\"\",Field12=\"\"),\"\",SUM(F24,G25,H26))","v":""}]
[]
[null,null,null,"Flakiness Index:",null,{"$f":"IF(ISERROR(H28/E28*100),\"\",H28/E28*100)","v":""}]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2024-10-09T15:13:11.330"}]
[]
[]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX221"]
[null,"Test Method:","Tested By:",null,null,"Tested Date:"]
[null,"TX224"]
[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":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[15]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF('Flakiness Index'!$B$33=\"\",\"\",'Flakiness Index'!$B$33)","v":""},{"$f":"'Flakiness Index'!$B$32","v":"Remarks:"}]
[2,{"$f":"IF('Flakiness Index'!$D$19=\"\",\"\",'Flakiness Index'!$D$19)","v":""},{"$f":"IF('Flakiness Index'!$C$19=\"\",\"\",'Flakiness Index'!$C$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('Flakiness Index'!$C$41=\"\",\"\",'Flakiness Index'!$C$41)","v":""},"Tested By ",{"$f":"IF('Flakiness Index'!$B$41=\"\",\"\",'Flakiness Index'!$B$41)","v":"TX224"}]
[4,{"$f":"IF('Flakiness Index'!$F$41=\"\",\"\",'Flakiness Index'!$F$41)","v":""},"Tested Date ",{"$f":"IF('Flakiness Index'!$B$41=\"\",\"\",'Flakiness Index'!$B$41)","v":"TX224"}]
[5,{"$f":"IF('Flakiness Index'!$E$24=\"\",\"\",'Flakiness Index'!$E$24)","v":""},{"$f":"IF('Flakiness Index'!$B$6=\"\",\"\",'Flakiness Index'!$B$6)","v":"Tex-224-F "},{"$f":"IF('Flakiness Index'!$C$22=\"\",\"\",'Flakiness Index'!$C$22)","v":"Passing"},{"$f":"IF('Flakiness Index'!$C$24=\"\",\"\",'Flakiness Index'!$C$24)","v":""},{"$f":"IF('Flakiness Index'!$C$21=\"\",\"\",'Flakiness Index'!$C$21)","v":"Particle Size Range"},{"$f":"IF('Flakiness Index'!$D$22=\"\",\"\",'Flakiness Index'!$D$22)","v":"Retained"},{"$f":"IF('Flakiness Index'!$D$24=\"\",\"\",'Flakiness Index'!$D$24)","v":""},{"$f":"IF('Flakiness Index'!$E$21=\"\",\"\",'Flakiness Index'!$E$21)","v":"Number of Particles"}]
[6,{"$f":"IF('Flakiness Index'!$F$24=\"\",\"\",'Flakiness Index'!$F$24)","v":""},{"$f":"IF('Flakiness Index'!$B$6=\"\",\"\",'Flakiness Index'!$B$6)","v":"Tex-224-F "},{"$f":"IF('Flakiness Index'!$C$22=\"\",\"\",'Flakiness Index'!$C$22)","v":"Passing"},{"$f":"IF('Flakiness Index'!$C$24=\"\",\"\",'Flakiness Index'!$C$24)","v":""},{"$f":"IF('Flakiness Index'!$C$21=\"\",\"\",'Flakiness Index'!$C$21)","v":"Particle Size Range"},{"$f":"IF('Flakiness Index'!$D$22=\"\",\"\",'Flakiness Index'!$D$22)","v":"Retained"},{"$f":"IF('Flakiness Index'!$D$24=\"\",\"\",'Flakiness Index'!$D$24)","v":""},{"$f":"IF('Flakiness Index'!$F$21=\"\",\"\",'Flakiness Index'!$F$21)","v":"Number of Particles Passing"},{"$f":"'Flakiness Index'!$F$22","v":""},{"$f":"'Flakiness Index'!$F$23","v":"slot"}]
[7,{"$f":"IF('Flakiness Index'!$E$25=\"\",\"\",'Flakiness Index'!$E$25)","v":""},{"$f":"IF('Flakiness Index'!$B$6=\"\",\"\",'Flakiness Index'!$B$6)","v":"Tex-224-F "},{"$f":"IF('Flakiness Index'!$C$22=\"\",\"\",'Flakiness Index'!$C$22)","v":"Passing"},{"$f":"IF('Flakiness Index'!$C$25=\"\",\"\",'Flakiness Index'!$C$25)","v":""},{"$f":"IF('Flakiness Index'!$C$21=\"\",\"\",'Flakiness Index'!$C$21)","v":"Particle Size Range"},{"$f":"IF('Flakiness Index'!$D$22=\"\",\"\",'Flakiness Index'!$D$22)","v":"Retained"},{"$f":"IF('Flakiness Index'!$D$25=\"\",\"\",'Flakiness Index'!$D$25)","v":""},{"$f":"IF('Flakiness Index'!$E$21=\"\",\"\",'Flakiness Index'!$E$21)","v":"Number of Particles"}]
[8,{"$f":"IF('Flakiness Index'!$G$25=\"\",\"\",'Flakiness Index'!$G$25)","v":""},{"$f":"IF('Flakiness Index'!$B$6=\"\",\"\",'Flakiness Index'!$B$6)","v":"Tex-224-F "},{"$f":"IF('Flakiness Index'!$C$22=\"\",\"\",'Flakiness Index'!$C$22)","v":"Passing"},{"$f":"IF('Flakiness Index'!$C$25=\"\",\"\",'Flakiness Index'!$C$25)","v":""},{"$f":"IF('Flakiness Index'!$C$21=\"\",\"\",'Flakiness Index'!$C$21)","v":"Particle Size Range"},{"$f":"IF('Flakiness Index'!$D$22=\"\",\"\",'Flakiness Index'!$D$22)","v":"Retained"},{"$f":"IF('Flakiness Index'!$D$25=\"\",\"\",'Flakiness Index'!$D$25)","v":""},{"$f":"IF('Flakiness Index'!$F$21=\"\",\"\",'Flakiness Index'!$F$21)","v":"Number of Particles Passing"},{"$f":"'Flakiness Index'!$G$22","v":""},{"$f":"'Flakiness Index'!$G$23","v":"slot"}]
[9,{"$f":"IF('Flakiness Index'!$E$26=\"\",\"\",'Flakiness Index'!$E$26)","v":""},{"$f":"IF('Flakiness Index'!$B$6=\"\",\"\",'Flakiness Index'!$B$6)","v":"Tex-224-F "},{"$f":"IF('Flakiness Index'!$C$22=\"\",\"\",'Flakiness Index'!$C$22)","v":"Passing"},{"$f":"IF('Flakiness Index'!$C$26=\"\",\"\",'Flakiness Index'!$C$26)","v":""},{"$f":"IF('Flakiness Index'!$C$21=\"\",\"\",'Flakiness Index'!$C$21)","v":"Particle Size Range"},{"$f":"IF('Flakiness Index'!$D$22=\"\",\"\",'Flakiness Index'!$D$22)","v":"Retained"},{"$f":"IF('Flakiness Index'!$D$26=\"\",\"\",'Flakiness Index'!$D$26)","v":""},{"$f":"IF('Flakiness Index'!$E$21=\"\",\"\",'Flakiness Index'!$E$21)","v":"Number of Particles"}]
[10,{"$f":"IF('Flakiness Index'!$H$26=\"\",\"\",'Flakiness Index'!$H$26)","v":""},{"$f":"IF('Flakiness Index'!$B$6=\"\",\"\",'Flakiness Index'!$B$6)","v":"Tex-224-F "},{"$f":"IF('Flakiness Index'!$C$22=\"\",\"\",'Flakiness Index'!$C$22)","v":"Passing"},{"$f":"IF('Flakiness Index'!$C$26=\"\",\"\",'Flakiness Index'!$C$26)","v":""},{"$f":"IF('Flakiness Index'!$C$21=\"\",\"\",'Flakiness Index'!$C$21)","v":"Particle Size Range"},{"$f":"IF('Flakiness Index'!$D$22=\"\",\"\",'Flakiness Index'!$D$22)","v":"Retained"},{"$f":"IF('Flakiness Index'!$D$26=\"\",\"\",'Flakiness Index'!$D$26)","v":""},{"$f":"IF('Flakiness Index'!$F$21=\"\",\"\",'Flakiness Index'!$F$21)","v":"Number of Particles Passing"},{"$f":"'Flakiness Index'!$H$22","v":""},{"$f":"'Flakiness Index'!$H$23","v":"slot"}]
[11,{"$f":"IF('Flakiness Index'!$E$28=\"\",\"\",'Flakiness Index'!$E$28)","v":""},{"$f":"IF('Flakiness Index'!$B$6=\"\",\"\",'Flakiness Index'!$B$6)","v":"Tex-224-F "},{"$f":"IF('Flakiness Index'!$C$28=\"\",\"\",'Flakiness Index'!$C$28)","v":"Total Particles:"}]
[12,{"$f":"IF('Flakiness Index'!$H$28=\"\",\"\",'Flakiness Index'!$H$28)","v":""},{"$f":"IF('Flakiness Index'!$B$6=\"\",\"\",'Flakiness Index'!$B$6)","v":"Tex-224-F "},{"$f":"IF('Flakiness Index'!$F$28=\"\",\"\",'Flakiness Index'!$F$28)","v":"Total Passing Particles:"}]
[13,{"$f":"IF('Flakiness Index'!$F$30=\"\",\"\",'Flakiness Index'!$F$30)","v":""},{"$f":"IF('Flakiness Index'!$B$6=\"\",\"\",'Flakiness Index'!$B$6)","v":"Tex-224-F "},{"$f":"IF('Flakiness Index'!$D$30=\"\",\"\",'Flakiness Index'!$D$30)","v":"Flakiness Index:"}]
[14,{"$f":"IF('Flakiness Index'!$C$39=\"\",\"\",'Flakiness Index'!$C$39)","v":""},"Sampled By ",{"$f":"IF('Flakiness Index'!$B$39=\"\",\"\",'Flakiness Index'!$B$39)","v":"TX221"}]
[15,{"$f":"IF('Flakiness Index'!$F$39=\"\",\"\",'Flakiness Index'!$F$39)","v":""},"Sampled Date ",{"$f":"IF('Flakiness Index'!$B$39=\"\",\"\",'Flakiness Index'!$B$39)","v":"TX221"}]

{"sheet":"Sieves","index":2,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":true,"merged":[[0,6,1,6],[0,7,1,7]]}
[null,"English",null,null,"Metric"]
["Sieve Size","Passing Sieve","Retained Sieve","Sieve Size","Passing Sieve","Retained Sieve"]
["5/8\"","7/8\"","5/8\"","16.0 mm","22.4 mm","16.0 mm"]
["3/8\"","5/8\"","3/8\"","9.5 mm","16 mm","9.5 mm"]
["1/4\"","3/8\"","1/4\"","6.3 mm","9.5 mm","6.3 mm"]
[null,"Slots",null,null,"Slots"]
[null,"3/8\"",null,null,"9.5 mm"]
[null,"1/4\"",null,null,"6.3 mm"]
[null,"5/32\"",null,null,"4 mm"]