{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tex-414,16","RX"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":81,"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-414,16","index":0,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[49,1,49,3],[0,0,0,1],[42,2,42,4],[53,1,53,3],[7,3,7,4],[21,4,21,5],[16,3,16,4],[11,3,11,4],[38,1,38,8],[49,6,49,8],[45,2,45,4],[47,2,47,4],[10,3,10,4],[35,1,36,8],[43,2,43,4],[13,7,13,8],[7,7,7,8],[8,3,8,4],[8,7,8,8],[12,3,12,4],[11,7,11,8],[9,7,9,8],[9,3,9,4],[10,7,10,8],[12,7,12,8],[16,7,16,8],[29,2,29,4],[30,2,30,4],[22,4,22,5],[13,3,13,4],[15,3,15,8],[14,3,14,8],[40,2,40,4],[41,2,41,4],[37,1,37,8],[23,4,23,5],[24,4,24,5],[27,4,27,5],[31,2,31,4]]}
["TxDOT Manuals >",null,null,"Tex-414-A","Tex-415-A","Tex-416-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,3]
[null,null,null,null,null,null,null,null,null,null,"tx414,6.xlsm::45506.432465"]
[null,"PORTLAND CEMENT CONCRETE REPORT "]
[null,"Tex-414,15,16-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: 08/02/24 10:22:45"}]
[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,null,null,"SLUMP"]
[null,null,null,null,"Tex-415-A"]
[null,null,null,null,{"$f":"\"Slump \" & IF(SpecYear=\"\",\"\",IF(SpecYear=\"1995\",\"(millimeters)\",\"(inches)\"))","v":"Slump "}]
[]
[]
[]
[null,null,null,null,"AIR CONTENT"]
[null,null,null,"by:","Test Method:"]
[null,null,{"$f":"IF(AirMethod=\"Tex 414-A\",\"Water Level Reading\",\"Uncorrected Air Content\") &\", %:\"","v":"Uncorrected Air Content, %:"}]
[null,null,{"$f":"IF(AirMethod=\"Tex 414-A\",\"Cups of Alcohol\",\"Aggr. Correction Factor\") & \", \" & IF(AirMethod=\"Tex 414-A\",\"Cups:\",\"%:\")","v":"Aggr. Correction Factor, %:"}]
[null,null,{"$f":"IF(AirMethod=\"Tex 414-A\",\"Air Content\",\"Corrected Air Content\") & \", %:\"","v":"Corrected Air Content, %:"},null,null,{"$f":"IF(COUNTBLANK(F30:F31)=2,\"\",IF(AirMethod=\"Tex 414-A\",ROUND((F30+F31),2),ROUND(F30-F31,1)))","v":""}]
[]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2024-08-02T10:22:45.640"}]
[]
[]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX407"," ",null,null," "]
[null,"Test Method:","Tested By:",null,null,"Tested Date:"]
[null,"TX414"," ",null,null," "]
[]
[null,"TX415"," ",null,null," "]
[]
[null,"TX416"," ",null,null," "]
[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":9,"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('Tex-414,16'!$B$36=\"\",\"\",'Tex-414,16'!$B$36)","v":""},{"$f":"'Tex-414,16'!$B$35","v":"Remarks:"}]
[2,{"$f":"IF('Tex-414,16'!$D$19=\"\",\"\",'Tex-414,16'!$D$19)","v":""},{"$f":"IF('Tex-414,16'!$C$19=\"\",\"\",'Tex-414,16'!$C$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('Tex-414,16'!$C$44=\"\",\"\",'Tex-414,16'!$C$44)","v":" "},"Tested By ",{"$f":"IF('Tex-414,16'!$B$44=\"\",\"\",'Tex-414,16'!$B$44)","v":"TX414"}]
[4,{"$f":"IF('Tex-414,16'!$F$44=\"\",\"\",'Tex-414,16'!$F$44)","v":" "},"Tested Date ",{"$f":"IF('Tex-414,16'!$B$44=\"\",\"\",'Tex-414,16'!$B$44)","v":"TX414"}]
[5,{"$f":"IF('Tex-414,16'!$C$46=\"\",\"\",'Tex-414,16'!$C$46)","v":" "},"Tested By ",{"$f":"IF('Tex-414,16'!$B$46=\"\",\"\",'Tex-414,16'!$B$46)","v":"TX415"}]
[6,{"$f":"IF('Tex-414,16'!$F$46=\"\",\"\",'Tex-414,16'!$F$46)","v":" "},"Tested Date ",{"$f":"IF('Tex-414,16'!$B$46=\"\",\"\",'Tex-414,16'!$B$46)","v":"TX415"}]
[7,{"$f":"IF('Tex-414,16'!$C$48=\"\",\"\",'Tex-414,16'!$C$48)","v":" "},"Tested By ",{"$f":"IF('Tex-414,16'!$B$48=\"\",\"\",'Tex-414,16'!$B$48)","v":"TX416"}]
[8,{"$f":"IF('Tex-414,16'!$F$48=\"\",\"\",'Tex-414,16'!$F$48)","v":" "},"Tested Date ",{"$f":"IF('Tex-414,16'!$B$48=\"\",\"\",'Tex-414,16'!$B$48)","v":"TX416"}]
[9,{"$f":"IF('Tex-414,16'!$E$25=\"\",\"\",'Tex-414,16'!$E$25)","v":""},{"$f":"IF('Tex-414,16'!$E$23=\"\",\"\",'Tex-414,16'!$E$23)","v":"Tex-415-A"},{"$f":"IF('Tex-414,16'!$E$24=\"\",\"\",'Tex-414,16'!$E$24)","v":"Slump "}]
[10,{"$f":"IF('Tex-414,16'!$F$29=\"\",\"\",'Tex-414,16'!$F$29)","v":""},{"$f":"IF('Tex-414,16'!$E$28=\"\",\"\",'Tex-414,16'!$E$28)","v":"AIR CONTENT"},{"$f":"IF('Tex-414,16'!$E$29=\"\",\"\",'Tex-414,16'!$E$29)","v":"Test Method:"}]
[11,{"$f":"IF('Tex-414,16'!$F$30=\"\",\"\",'Tex-414,16'!$F$30)","v":""},{"$f":"IF('Tex-414,16'!$F$29=\"\",\"\",'Tex-414,16'!$F$29)","v":""},{"$f":"IF('Tex-414,16'!$C$30=\"\",\"\",'Tex-414,16'!$C$30)","v":"Uncorrected Air Content, %:"}]
[12,{"$f":"IF('Tex-414,16'!$F$31=\"\",\"\",'Tex-414,16'!$F$31)","v":""},{"$f":"IF('Tex-414,16'!$F$29=\"\",\"\",'Tex-414,16'!$F$29)","v":""},{"$f":"IF('Tex-414,16'!$C$31=\"\",\"\",'Tex-414,16'!$C$31)","v":"Aggr. Correction Factor, %:"}]
[13,{"$f":"IF('Tex-414,16'!$F$32=\"\",\"\",'Tex-414,16'!$F$32)","v":""},{"$f":"IF('Tex-414,16'!$F$29=\"\",\"\",'Tex-414,16'!$F$29)","v":""},{"$f":"IF('Tex-414,16'!$C$32=\"\",\"\",'Tex-414,16'!$C$32)","v":"Corrected Air Content, %:"}]
[14,{"$f":"IF('Tex-414,16'!$C$42=\"\",\"\",'Tex-414,16'!$C$42)","v":" "},"Sampled By ",{"$f":"IF('Tex-414,16'!$B$42=\"\",\"\",'Tex-414,16'!$B$42)","v":"TX407"}]
[15,{"$f":"IF('Tex-414,16'!$F$42=\"\",\"\",'Tex-414,16'!$F$42)","v":" "},"Sampled Date ",{"$f":"IF('Tex-414,16'!$B$42=\"\",\"\",'Tex-414,16'!$B$42)","v":"TX407"}]