{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tex-424-A, II","RX"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":66,"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-424-A, II","index":0,"n_rows":45,"n_cols":20,"rows_kept":45,"cut":false,"hidden":false,"merged":[[13,1,13,4],[15,1,15,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[14,1,14,4],[10,9,10,12],[11,9,11,12],[12,9,12,12],[13,9,13,12],[16,9,16,12],[8,5,8,8],[9,5,9,8],[7,9,7,12],[8,9,8,12],[9,9,9,12],[12,13,12,16],[13,13,13,16],[15,5,15,16],[13,5,13,8],[0,0,0,2],[0,4,0,5],[11,13,11,16],[11,5,11,8],[12,5,12,8],[14,5,14,16],[10,5,10,8],[7,13,7,16],[8,13,8,16],[9,13,9,16],[10,13,10,16],[7,5,7,8],[38,3,38,7],[39,9,39,10],[39,3,39,8],[16,13,16,16],[18,1,18,4],[18,5,18,6],[18,7,18,8],[18,9,18,10],[18,14,18,16],[16,1,16,4],[16,5,16,8],[45,1,45,6],[45,7,45,8],[43,1,43,2],[21,1,21,3],[41,7,41,8],[41,1,41,6],[36,1,36,15],[23,6,23,14],[25,15,25,16],[21,4,21,5],[23,15,23,16],[24,15,24,16],[37,1,37,15],[34,1,35,15],[25,1,25,5],[23,1,24,5],[41,9,41,10],[41,11,41,16],[39,1,39,2],[43,3,43,4],[43,5,43,6],[43,7,43,8]]}
["TxDOT Manuals >",null,null,null,"Tex-424-A"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tx424.xlsm::45475.642315"]
[null,"MEASURING LENGTH OF DRILLED CONCRETE CORES"]
[null,"Tex-424-A, Part II"]
[null,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/02/24 15:24:56"}]
[null,"SAMPLE ID:",null,null,null,null,null,null,null,"SAMPLED DATE:"]
[null,"TEST NUMBER:",null,null,null,null,null,null,null,"LETTING DATE:"]
[null,"SAMPLE STATUS:",null,null,null,null,null,null,null,"CONTROLLING CSJ:"]
[null,"COUNTY:",null,null,null,null,null,null,null,"SPEC YEAR:"]
[null,"SAMPLED BY:",null,null,null,null,null,null,null,"SPEC ITEM:"]
[null,"SAMPLE LOCATION:",null,null,null,null,null,null,null,"SPECIAL PROVISION:"]
[null,"MATERIAL CODE:",null,null,null,null,null,null,null,"GRADE:"]
[null,"MATERIAL NAME:"]
[null,"PRODUCER:"]
[null,"AREA ENGINEER:",null,null,null,null,null,null,null,"PROJECT MANAGER:"]
[]
[null,"COURSE\\LIFT:",null,null,null,null,null,"STATION:",null,null,null,null,null,"DIST. FROM CL:"]
[]
[]
[null,"Measure Unit:"]
[]
[null,"Core Identification / Location",null,null,null,null,{"$f":"\"Measurements \" & IF(Measuredby=\"Millimeters\", \"to the nearest 1.0 (mm)\",\"to the nearest 0.05 (in.)\")","v":"Measurements to the nearest 0.05 (in.)"},null,null,null,null,null,null,null,null,"Average "]
[null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,{"$f":" IF(Measuredby=\"Millimeters\", IF(SpecYear<2024, \"nearest 3.0 (mm)\", \"nearest 1.0 (mm)\"), \"nearest 0.1 (in.)\")","v":"nearest 0.1 (in.)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(OR(ISBLANK(Measuredby), Measuredby=\"inches\"),ROUND(AVERAGE(G26:O26),1),IF(SpecYear<2024, ROUND(AVERAGE(G26:O26)/3,0)*3, ROUND(AVERAGE(G26:O26), 1)))),\"\",IF(OR(ISBLANK(Measuredby), Measuredby=\"inches\"),ROUND(AVERAGE(G26:O26),1),IF(SpecYear<2024, ROUND(AVERAGE(G26:O26)/3,0)*3, ROUND(AVERAGE(G26:O26), 1))))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[null,"Remarks:",null,{"$f":"NOW()","v":"2024-07-02T15:24:56.860"}]
[]
[]
[]
[]
[null,"Test Method:",null,"Tested By:",null,null,null,null,null,"Tested Date:"]
[null,"TX424"]
[null,"Test Stamp Code:",null,null,null,null,null,"Omit Test:",null,"Completed Date:",null,"Reviewed By:"]
[]
[null,"Locked By:",null,"TxDOT:",null,"District:",null,"Area:"]
[]
[null,"Authorized By:",null,null,null,null,null,"Authorized Date:"]

{"sheet":"RX","index":1,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[16]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF('Tex-424-A, II'!$B$35=\"\",\"\",'Tex-424-A, II'!$B$35)","v":""},{"$f":"'Tex-424-A, II'!$B$34","v":"Remarks:"}]
[2,{"$f":"IF('Tex-424-A, II'!$F$19=\"\",\"\",'Tex-424-A, II'!$F$19)","v":""},{"$f":"IF('Tex-424-A, II'!$B$19=\"\",\"\",'Tex-424-A, II'!$B$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('Tex-424-A, II'!$D$40=\"\",\"\",'Tex-424-A, II'!$D$40)","v":""},"Tested By ",{"$f":"IF('Tex-424-A, II'!$B$40=\"\",\"\",'Tex-424-A, II'!$B$40)","v":"TX424"}]
[4,{"$f":"IF('Tex-424-A, II'!$J$40=\"\",\"\",'Tex-424-A, II'!$J$40)","v":""},"Tested Date ",{"$f":"IF('Tex-424-A, II'!$B$40=\"\",\"\",'Tex-424-A, II'!$B$40)","v":"TX424"}]
[5,{"$f":"IF('Tex-424-A, II'!$E$22=\"\",\"\",'Tex-424-A, II'!$E$22)","v":""},{"$f":"IF('Tex-424-A, II'!$B$6=\"\",\"\",'Tex-424-A, II'!$B$6)","v":"Tex-424-A, Part II"},{"$f":"IF('Tex-424-A, II'!$B$22=\"\",\"\",'Tex-424-A, II'!$B$22)","v":"Measure Unit:"}]
[6,{"$f":"IF('Tex-424-A, II'!$B$26=\"\",\"\",'Tex-424-A, II'!$B$26)","v":""},{"$f":"IF('Tex-424-A, II'!$B$6=\"\",\"\",'Tex-424-A, II'!$B$6)","v":"Tex-424-A, Part II"},{"$f":"IF('Tex-424-A, II'!$B$24=\"\",\"\",'Tex-424-A, II'!$B$24)","v":"Core Identification / Location"}]
[7,{"$f":"IF('Tex-424-A, II'!$G$26=\"\",\"\",'Tex-424-A, II'!$G$26)","v":""},{"$f":"IF('Tex-424-A, II'!$B$6=\"\",\"\",'Tex-424-A, II'!$B$6)","v":"Tex-424-A, Part II"},{"$f":"IF('Tex-424-A, II'!$G$24=\"\",\"\",'Tex-424-A, II'!$G$24)","v":"Measurements to the nearest 0.05 (in.)"},{"$f":"IF('Tex-424-A, II'!$G$25=\"\",\"\",'Tex-424-A, II'!$G$25)","v":1}]
[8,{"$f":"IF('Tex-424-A, II'!$H$26=\"\",\"\",'Tex-424-A, II'!$H$26)","v":""},{"$f":"IF('Tex-424-A, II'!$B$6=\"\",\"\",'Tex-424-A, II'!$B$6)","v":"Tex-424-A, Part II"},{"$f":"IF('Tex-424-A, II'!$G$24=\"\",\"\",'Tex-424-A, II'!$G$24)","v":"Measurements to the nearest 0.05 (in.)"},{"$f":"IF('Tex-424-A, II'!$H$25=\"\",\"\",'Tex-424-A, II'!$H$25)","v":2}]
[9,{"$f":"IF('Tex-424-A, II'!$I$26=\"\",\"\",'Tex-424-A, II'!$I$26)","v":""},{"$f":"IF('Tex-424-A, II'!$B$6=\"\",\"\",'Tex-424-A, II'!$B$6)","v":"Tex-424-A, Part II"},{"$f":"IF('Tex-424-A, II'!$G$24=\"\",\"\",'Tex-424-A, II'!$G$24)","v":"Measurements to the nearest 0.05 (in.)"},{"$f":"IF('Tex-424-A, II'!$I$25=\"\",\"\",'Tex-424-A, II'!$I$25)","v":3}]
[10,{"$f":"IF('Tex-424-A, II'!$J$26=\"\",\"\",'Tex-424-A, II'!$J$26)","v":""},{"$f":"IF('Tex-424-A, II'!$B$6=\"\",\"\",'Tex-424-A, II'!$B$6)","v":"Tex-424-A, Part II"},{"$f":"IF('Tex-424-A, II'!$G$24=\"\",\"\",'Tex-424-A, II'!$G$24)","v":"Measurements to the nearest 0.05 (in.)"},{"$f":"IF('Tex-424-A, II'!$J$25=\"\",\"\",'Tex-424-A, II'!$J$25)","v":4}]
[11,{"$f":"IF('Tex-424-A, II'!$K$26=\"\",\"\",'Tex-424-A, II'!$K$26)","v":""},{"$f":"IF('Tex-424-A, II'!$B$6=\"\",\"\",'Tex-424-A, II'!$B$6)","v":"Tex-424-A, Part II"},{"$f":"IF('Tex-424-A, II'!$G$24=\"\",\"\",'Tex-424-A, II'!$G$24)","v":"Measurements to the nearest 0.05 (in.)"},{"$f":"IF('Tex-424-A, II'!$K$25=\"\",\"\",'Tex-424-A, II'!$K$25)","v":5}]
[12,{"$f":"IF('Tex-424-A, II'!$L$26=\"\",\"\",'Tex-424-A, II'!$L$26)","v":""},{"$f":"IF('Tex-424-A, II'!$B$6=\"\",\"\",'Tex-424-A, II'!$B$6)","v":"Tex-424-A, Part II"},{"$f":"IF('Tex-424-A, II'!$G$24=\"\",\"\",'Tex-424-A, II'!$G$24)","v":"Measurements to the nearest 0.05 (in.)"},{"$f":"IF('Tex-424-A, II'!$L$25=\"\",\"\",'Tex-424-A, II'!$L$25)","v":6}]
[13,{"$f":"IF('Tex-424-A, II'!$M$26=\"\",\"\",'Tex-424-A, II'!$M$26)","v":""},{"$f":"IF('Tex-424-A, II'!$B$6=\"\",\"\",'Tex-424-A, II'!$B$6)","v":"Tex-424-A, Part II"},{"$f":"IF('Tex-424-A, II'!$G$24=\"\",\"\",'Tex-424-A, II'!$G$24)","v":"Measurements to the nearest 0.05 (in.)"},{"$f":"IF('Tex-424-A, II'!$M$25=\"\",\"\",'Tex-424-A, II'!$M$25)","v":7}]
[14,{"$f":"IF('Tex-424-A, II'!$N$26=\"\",\"\",'Tex-424-A, II'!$N$26)","v":""},{"$f":"IF('Tex-424-A, II'!$B$6=\"\",\"\",'Tex-424-A, II'!$B$6)","v":"Tex-424-A, Part II"},{"$f":"IF('Tex-424-A, II'!$G$24=\"\",\"\",'Tex-424-A, II'!$G$24)","v":"Measurements to the nearest 0.05 (in.)"},{"$f":"IF('Tex-424-A, II'!$N$25=\"\",\"\",'Tex-424-A, II'!$N$25)","v":8}]
[15,{"$f":"IF('Tex-424-A, II'!$O$26=\"\",\"\",'Tex-424-A, II'!$O$26)","v":""},{"$f":"IF('Tex-424-A, II'!$B$6=\"\",\"\",'Tex-424-A, II'!$B$6)","v":"Tex-424-A, Part II"},{"$f":"IF('Tex-424-A, II'!$G$24=\"\",\"\",'Tex-424-A, II'!$G$24)","v":"Measurements to the nearest 0.05 (in.)"},{"$f":"IF('Tex-424-A, II'!$O$25=\"\",\"\",'Tex-424-A, II'!$O$25)","v":9}]
[16,{"$f":"IF('Tex-424-A, II'!$P$26=\"\",\"\",'Tex-424-A, II'!$P$26)","v":""},{"$f":"IF('Tex-424-A, II'!$B$6=\"\",\"\",'Tex-424-A, II'!$B$6)","v":"Tex-424-A, Part II"},{"$f":"IF('Tex-424-A, II'!$P$24=\"\",\"\",'Tex-424-A, II'!$P$24)","v":"Average "},{"$f":"IF('Tex-424-A, II'!$P$25=\"\",\"\",'Tex-424-A, II'!$P$25)","v":"nearest 0.1 (in.)"}]