{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tex-146-E,Tex-145-E Part I","RX"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":86,"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-146-E,Tex-145-E Part I","index":0,"n_rows":67,"n_cols":11,"rows_kept":67,"cut":false,"hidden":false,"merged":[[67,1,67,3],[34,1,34,2],[36,3,36,6],[29,3,29,6],[37,3,37,6],[30,3,30,6],[63,6,63,8],[48,1,49,8],[59,2,59,4],[51,1,51,8],[63,1,63,3],[61,2,61,4],[58,2,58,4],[50,1,50,8],[53,2,53,4],[54,2,54,4],[27,1,27,4],[16,3,16,4],[14,3,14,8],[13,3,13,4],[23,2,23,5],[24,2,24,5],[15,3,15,8],[13,7,13,8],[16,7,16,8],[56,2,56,4],[10,3,10,4],[0,0,0,1],[12,7,12,8],[11,3,11,4],[12,3,12,4],[9,3,9,4],[7,7,7,8],[10,7,10,8],[7,3,7,4],[8,3,8,4],[9,7,9,8],[8,7,8,8],[22,2,22,5],[11,7,11,8],[20,1,20,3]]}
["TxDOT Manuals >",null,null,"Tex-145-E","Tex-146-E"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,"tx145,146.xlsm::45454.666528"]
[null,"Soil and Base Material",null,null,null,null,null,null,null,null,1]
[null,"Tex-146-E,Tex-145-E Part I"]
[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: 06/11/24 15:59:48"}]
[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,"Conductivity Field Test, Tx-146-E"]
[null,null,null,null,null,null,"Initial","Final"]
[null,null,"Conductivity of the solution (soil & water), µS:"]
[null,null,"Conductivity of the deionized water, µS:",null,null,null,null,{"$f":"IF($G$24=\"\",\"\",$G$24)","v":""}]
[null,null,"Conductivity readings, µS:",null,null,null,{"$f":"IF(SUM(G23:G24)=0,\"\",G23-G24)","v":""},{"$f":"IF(ISERROR(H23-H24),\"\",H23-H24)","v":""}]
[]
[]
[null,"Colorimetric Field Test, Tx-145-E, Part I"]
[]
[null,null,null,"Initial Dilution Ratio, 1:20  "]
[null,null,null,"Readings"]
[null,null,null,"1.","2.","3.","Average"]
[null,null,null,null,null,null,{"$f":"IF(AND($D$33=\"\",$E$33=\"\",$F$33=\"\"),\"\",SUM(D33:F33)/3)","v":""}]
[]
[null,"Error Messages:"]
[]
[null,null,null,"The Dilution Ratio is now, 1:40"]
[null,null,null,"Readings"]
[null,null,null,"1.","2.","3.","Average"]
[null,null,null,null,null,null,{"$f":"IF(AND($D$40=\"\",$E$40=\"\",$F$40=\"\"),\"\",SUM(D40:F40)/3)","v":""}]
[]
[]
[null,null,null,null,"Sulfate Content, PPM:",{"$f":"IF(ISERROR(IF(ErrDisp=\"\",20*G33,IF(ErrDisp=\"÷\",40*G40,IF(ErrDisp=\"-\",\"<100\",\">8000\")))),\"\",IF(ErrDisp=\"\",20*G33,IF(ErrDisp=\"÷\",40*G40,IF(ErrDisp=\"-\",\"<100\",\">8000\"))))","v":""}]
[]
[]
[]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2024-06-11T15:59:48.340"}]
[]
[]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX100"]
[]
[null,"TX400"]
[]
[null,"Test Method:","Tested By:",null,null,"Tested Date:"]
[null,"TX145"]
[]
[null,"TX146"]
[null,"Test Stamp Code:",null,null,"Omit Test:","Completed Date:","Reviewed By:"]
[]
[null,"Locked By:","TxDOT:","District:","Area:"]
[null,"","","",""]
[null,"Authorized By:",null,null,"Authorized Date:"]

{"sheet":"RX","index":1,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[26]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$49=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$49)","v":""},{"$f":"'Tex-146-E,Tex-145-E Part I'!$B$48","v":"Remarks:"}]
[2,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$19=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$19)","v":""},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$C$19=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$C$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$C$60=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$C$60)","v":""},"Tested By ",{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$60=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$60)","v":"TX145"}]
[4,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$F$60=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$F$60)","v":""},"Tested Date ",{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$60=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$60)","v":"TX145"}]
[5,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$C$62=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$C$62)","v":""},"Tested By ",{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$62=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$62)","v":"TX146"}]
[6,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$F$62=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$F$62)","v":""},"Tested Date ",{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$62=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$62)","v":"TX146"}]
[7,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$G$23=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$G$23)","v":""},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$21=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$21)","v":"Conductivity Field Test, Tx-146-E"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$C$23=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$C$23)","v":"Conductivity of the solution (soil & water), µS:"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$G$22=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$G$22)","v":"Initial"}]
[8,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$H$23=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$H$23)","v":""},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$21=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$21)","v":"Conductivity Field Test, Tx-146-E"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$C$23=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$C$23)","v":"Conductivity of the solution (soil & water), µS:"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$H$22=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$H$22)","v":"Final"}]
[9,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$G$24=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$G$24)","v":""},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$21=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$21)","v":"Conductivity Field Test, Tx-146-E"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$C$24=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$C$24)","v":"Conductivity of the deionized water, µS:"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$G$22=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$G$22)","v":"Initial"}]
[10,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$H$24=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$H$24)","v":""},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$21=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$21)","v":"Conductivity Field Test, Tx-146-E"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$C$24=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$C$24)","v":"Conductivity of the deionized water, µS:"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$H$22=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$H$22)","v":"Final"}]
[11,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$G$25=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$G$25)","v":""},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$21=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$21)","v":"Conductivity Field Test, Tx-146-E"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$C$25=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$C$25)","v":"Conductivity readings, µS:"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$G$22=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$G$22)","v":"Initial"}]
[12,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$H$25=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$H$25)","v":""},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$21=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$21)","v":"Conductivity Field Test, Tx-146-E"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$C$25=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$C$25)","v":"Conductivity readings, µS:"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$H$22=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$H$22)","v":"Final"}]
[13,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$33=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$33)","v":""},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$28=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$28)","v":"Colorimetric Field Test, Tx-145-E, Part I"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$30=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$30)","v":"Initial Dilution Ratio, 1:20  "},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$31=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$31)","v":"Readings"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$32=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$32)","v":"1."}]
[14,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$E$33=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$E$33)","v":""},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$28=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$28)","v":"Colorimetric Field Test, Tx-145-E, Part I"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$30=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$30)","v":"Initial Dilution Ratio, 1:20  "},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$31=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$31)","v":"Readings"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$E$32=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$E$32)","v":"2."}]
[15,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$F$33=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$F$33)","v":""},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$28=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$28)","v":"Colorimetric Field Test, Tx-145-E, Part I"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$30=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$30)","v":"Initial Dilution Ratio, 1:20  "},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$31=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$31)","v":"Readings"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$F$32=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$F$32)","v":"3."}]
[16,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$G$33=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$G$33)","v":""},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$28=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$28)","v":"Colorimetric Field Test, Tx-145-E, Part I"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$30=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$30)","v":"Initial Dilution Ratio, 1:20  "},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$31=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$31)","v":"Readings"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$G$32=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$G$32)","v":"Average"}]
[17,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$35=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$35)","v":""},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$28=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$28)","v":"Colorimetric Field Test, Tx-145-E, Part I"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$35=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$35)","v":"Error Messages:"}]
[18,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$40=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$40)","v":""},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$28=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$28)","v":"Colorimetric Field Test, Tx-145-E, Part I"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$37=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$37)","v":"The Dilution Ratio is now, 1:40"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$38=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$38)","v":"Readings"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$39=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$39)","v":"1."}]
[19,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$E$40=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$E$40)","v":""},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$28=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$28)","v":"Colorimetric Field Test, Tx-145-E, Part I"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$37=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$37)","v":"The Dilution Ratio is now, 1:40"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$38=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$38)","v":"Readings"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$E$39=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$E$39)","v":"2."}]
[20,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$F$40=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$F$40)","v":""},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$28=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$28)","v":"Colorimetric Field Test, Tx-145-E, Part I"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$37=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$37)","v":"The Dilution Ratio is now, 1:40"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$38=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$38)","v":"Readings"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$F$39=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$F$39)","v":"3."}]
[21,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$G$40=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$G$40)","v":""},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$28=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$28)","v":"Colorimetric Field Test, Tx-145-E, Part I"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$37=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$37)","v":"The Dilution Ratio is now, 1:40"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$D$38=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$D$38)","v":"Readings"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$G$39=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$G$39)","v":"Average"}]
[22,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$F$43=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$F$43)","v":""},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$28=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$28)","v":"Colorimetric Field Test, Tx-145-E, Part I"},{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$E$43=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$E$43)","v":"Sulfate Content, PPM:"}]
[23,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$C$55=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$C$55)","v":""},"Sampled By ",{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$55=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$55)","v":"TX100"}]
[24,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$F$55=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$F$55)","v":""},"Sampled Date ",{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$55=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$55)","v":"TX100"}]
[25,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$C$57=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$C$57)","v":""},"Sampled By ",{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$57=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$57)","v":"TX400"}]
[26,{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$F$57=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$F$57)","v":""},"Sampled Date ",{"$f":"IF('Tex-146-E,Tex-145-E Part I'!$B$57=\"\",\"\",'Tex-146-E,Tex-145-E Part I'!$B$57)","v":"TX400"}]