{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Frac Faces","RX","Sieves"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":78,"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":"Frac Faces","index":0,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[38,2,38,4],[32,1,33,8],[14,3,14,8],[15,3,15,8],[40,2,40,4],[21,5,24,5],[21,4,24,4],[0,0,0,1],[13,3,13,4],[7,3,7,4],[7,7,7,8],[13,7,13,8],[10,7,10,8],[8,3,8,4],[8,7,8,8],[9,7,9,8],[10,3,10,4],[11,3,11,4],[11,7,11,8],[12,7,12,8],[12,3,12,4],[9,3,9,4],[51,1,51,3],[16,3,16,4],[29,3,29,5],[21,3,24,3],[35,1,35,8],[47,1,47,3],[16,7,16,8],[21,7,24,7],[42,2,42,4],[41,2,41,4],[21,6,24,6],[47,6,47,8],[21,2,24,2],[34,1,34,8],[37,2,37,4],[44,2,44,4]]}
["TxDOT Manuals >",null,null,"Tex-460-A"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,"tx460.xlsm::45503.687454"]
[null,"COURSE AGGREGATE ANGULARITY BY FRACTURED FACES COUNT"]
[null,"Tex-460-A "]
[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:29:56"}]
[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,"MIX TYPE / 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,"Sieve Size","Number of Particles w/ 2 or more FF","Number of Particles w/ one or no FF","Number of Questionable Particles","Total Number of Particles","Percent Crushed Particles"]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"IF(COUNTBLANK(C26:F26)=4,\"\",SUM(D26:F26))","v":""},{"$f":"IF(ISERROR(($D26+$F26/2)/SUM(D26:F26)),\"\",($D26+$F26/2)/SUM(D26:F26))","v":""}]
[]
[]
[]
[null,null,null,"Percent Crushed Particles:",null,null,{"$f":"+H26","v":""}]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2024-07-30T16:29:56.920"}]
[]
[]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX221"]
[]
[null,"TX400"]
[null,"Test Method:","Tested By:",null,null,"Tested Date:"]
[null,"TX460"]
[]
[null,"TX460PI"]
[]
[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":19,"n_cols":9,"rows_kept":19,"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('Frac Faces'!$B$33=\"\",\"\",'Frac Faces'!$B$33)","v":""},{"$f":"'Frac Faces'!$B$32","v":"Remarks:"}]
[2,{"$f":"IF('Frac Faces'!$D$19=\"\",\"\",'Frac Faces'!$D$19)","v":""},{"$f":"IF('Frac Faces'!$C$19=\"\",\"\",'Frac Faces'!$C$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('Frac Faces'!$C$43=\"\",\"\",'Frac Faces'!$C$43)","v":""},"Tested By ",{"$f":"IF('Frac Faces'!$B$43=\"\",\"\",'Frac Faces'!$B$43)","v":"TX460"}]
[4,{"$f":"IF('Frac Faces'!$F$43=\"\",\"\",'Frac Faces'!$F$43)","v":""},"Tested Date ",{"$f":"IF('Frac Faces'!$B$43=\"\",\"\",'Frac Faces'!$B$43)","v":"TX460"}]
[5,{"$f":"IF('Frac Faces'!$C$26=\"\",\"\",'Frac Faces'!$C$26)","v":""},{"$f":"IF('Frac Faces'!$B$6=\"\",\"\",'Frac Faces'!$B$6)","v":"Tex-460-A "},{"$f":"IF('Frac Faces'!$C$22=\"\",\"\",'Frac Faces'!$C$22)","v":"Sieve Size"}]
[6,{"$f":"IF('Frac Faces'!$D$26=\"\",\"\",'Frac Faces'!$D$26)","v":""},{"$f":"IF('Frac Faces'!$B$6=\"\",\"\",'Frac Faces'!$B$6)","v":"Tex-460-A "},{"$f":"IF('Frac Faces'!$D$22=\"\",\"\",'Frac Faces'!$D$22)","v":"Number of Particles w/ 2 or more FF"},{"$f":"IF('Frac Faces'!$C$22=\"\",\"\",'Frac Faces'!$C$22)","v":"Sieve Size"},{"$f":"IF('Frac Faces'!$C$26=\"\",\"\",'Frac Faces'!$C$26)","v":""}]
[7,{"$f":"IF('Frac Faces'!$E$26=\"\",\"\",'Frac Faces'!$E$26)","v":""},{"$f":"IF('Frac Faces'!$B$6=\"\",\"\",'Frac Faces'!$B$6)","v":"Tex-460-A "},{"$f":"IF('Frac Faces'!$E$22=\"\",\"\",'Frac Faces'!$E$22)","v":"Number of Particles w/ one or no FF"},{"$f":"IF('Frac Faces'!$C$22=\"\",\"\",'Frac Faces'!$C$22)","v":"Sieve Size"},{"$f":"IF('Frac Faces'!$C$26=\"\",\"\",'Frac Faces'!$C$26)","v":""}]
[8,{"$f":"IF('Frac Faces'!$F$26=\"\",\"\",'Frac Faces'!$F$26)","v":""},{"$f":"IF('Frac Faces'!$B$6=\"\",\"\",'Frac Faces'!$B$6)","v":"Tex-460-A "},{"$f":"IF('Frac Faces'!$F$22=\"\",\"\",'Frac Faces'!$F$22)","v":"Number of Questionable Particles"},{"$f":"IF('Frac Faces'!$C$22=\"\",\"\",'Frac Faces'!$C$22)","v":"Sieve Size"},{"$f":"IF('Frac Faces'!$C$26=\"\",\"\",'Frac Faces'!$C$26)","v":""}]
[9,{"$f":"IF('Frac Faces'!$G$26=\"\",\"\",'Frac Faces'!$G$26)","v":""},{"$f":"IF('Frac Faces'!$B$6=\"\",\"\",'Frac Faces'!$B$6)","v":"Tex-460-A "},{"$f":"IF('Frac Faces'!$G$22=\"\",\"\",'Frac Faces'!$G$22)","v":"Total Number of Particles"},{"$f":"IF('Frac Faces'!$C$22=\"\",\"\",'Frac Faces'!$C$22)","v":"Sieve Size"},{"$f":"IF('Frac Faces'!$C$26=\"\",\"\",'Frac Faces'!$C$26)","v":""}]
[10,{"$f":"IF('Frac Faces'!$H$26=\"\",\"\",'Frac Faces'!$H$26)","v":""},{"$f":"IF('Frac Faces'!$B$6=\"\",\"\",'Frac Faces'!$B$6)","v":"Tex-460-A "},{"$f":"IF('Frac Faces'!$H$22=\"\",\"\",'Frac Faces'!$H$22)","v":"Percent Crushed Particles"},{"$f":"IF('Frac Faces'!$C$22=\"\",\"\",'Frac Faces'!$C$22)","v":"Sieve Size"},{"$f":"IF('Frac Faces'!$C$26=\"\",\"\",'Frac Faces'!$C$26)","v":""}]
[11,{"$f":"IF('Frac Faces'!$G$30=\"\",\"\",'Frac Faces'!$G$30)","v":""},{"$f":"IF('Frac Faces'!$B$6=\"\",\"\",'Frac Faces'!$B$6)","v":"Tex-460-A "},{"$f":"IF('Frac Faces'!$D$30=\"\",\"\",'Frac Faces'!$D$30)","v":"Percent Crushed Particles:"}]
[12,{"$f":"IF('Frac Faces'!$C$39=\"\",\"\",'Frac Faces'!$C$39)","v":""},"Sampled By ",{"$f":"IF('Frac Faces'!$B$39=\"\",\"\",'Frac Faces'!$B$39)","v":"TX221"}]
[13,{"$f":"IF('Frac Faces'!$F$39=\"\",\"\",'Frac Faces'!$F$39)","v":""},"Sampled Date ",{"$f":"IF('Frac Faces'!$B$39=\"\",\"\",'Frac Faces'!$B$39)","v":"TX221"}]
[14,{"$f":"IF('Frac Faces'!$C$41=\"\",\"\",'Frac Faces'!$C$41)","v":""},"Sampled By ",{"$f":"IF('Frac Faces'!$B$41=\"\",\"\",'Frac Faces'!$B$41)","v":"TX400"}]
[15,{"$f":"IF('Frac Faces'!$F$41=\"\",\"\",'Frac Faces'!$F$41)","v":""},"Sampled Date ",{"$f":"IF('Frac Faces'!$B$41=\"\",\"\",'Frac Faces'!$B$41)","v":"TX400"}]
[16,{"$f":"IF('Frac Faces'!$C$45=\"\",\"\",'Frac Faces'!$C$45)","v":""},"Tested By ",{"$f":"IF('Frac Faces'!$B$45=\"\",\"\",'Frac Faces'!$B$45)","v":"TX460PI"}]
[17,{"$f":"IF('Frac Faces'!$F$45=\"\",\"\",'Frac Faces'!$F$45)","v":""},"Tested Date ",{"$f":"IF('Frac Faces'!$B$45=\"\",\"\",'Frac Faces'!$B$45)","v":"TX460PI"}]

{"sheet":"Sieves","index":2,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,3,1,3]]}
["\"1993\"","\"1995\"","DropDown"]
["Sieve Size","Sieve Size","SieveSize"]
["+No.4","+4.75 mm",{"$f":"IF(SpecYear=\"\",\"\",IF(SpecYear=\"1995\",+B3,+A3))","v":""}]
["+No.10","+2.00 mm",{"$f":"IF(SpecYear=\"\",\"\",IF(SpecYear=\"1995\",+B4,+A4))","v":""}]