{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tex-129-E","RX"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":71,"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-129-E","index":0,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,0,0,1],[57,1,57,3],[7,3,7,4],[8,3,8,4],[53,6,53,8],[41,1,42,8],[51,2,51,4],[12,7,12,8],[29,2,29,5],[43,1,43,8],[28,2,28,5],[46,2,46,4],[47,2,47,4],[49,2,49,4],[7,7,7,8],[53,1,53,3],[50,2,50,4],[13,7,13,8],[16,7,16,8],[31,2,31,5],[34,2,34,5],[36,2,36,5],[11,3,11,4],[12,3,12,4],[44,1,44,8],[15,3,15,8],[11,7,11,8],[13,3,13,4],[14,3,14,8],[16,3,16,4],[8,7,8,8],[10,3,10,4],[9,7,9,8],[9,3,9,4],[10,7,10,8]]}
["TxDOT Manuals >",null,null,"Tex-129-E"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,"tx129.xlsm::45544.884884"]
[null,"Measuring the Resistivity of Soil Materials"]
[null,"Tex-129-E"]
[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: 09/09/24 21:14:14"}]
[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,"Verification of Resistivity Meter"]
[null,null,"Resistor","Min,ohm","Max,ohm","Results,ohm"]
[null,null,"100-ohm",{"$f":"0.95*100","v":95},{"$f":"1.05*100","v":105}]
[null,null,"200-ohm",{"$f":"0.95*200","v":190},{"$f":"1.05*200","v":210}]
[null,null,"500-ohm",{"$f":"0.95*500","v":475},{"$f":"1.05*500","v":525}]
[null,null,"900-ohm",{"$f":"0.95*900","v":855},{"$f":"1.05*900","v":945}]
[]
[null,null,"Calculate the Soil Box Factor (SBF):"]
[null,null,"A = Area of one electrode, (cm2):"]
[null,null,"D = Distance between electrodes, (cm):"]
[null,null,null,null,null,null,null,null,null,"    · "]
[null,null,"Soil Box Factor (SBF) = A / D:",null,null,null,{"$f":"IF(ISERROR(G29/G30),\"\",G29/G30)","v":""}]
[]
[null,null,"Calculate the Resistivity:"]
[null,null,"Resistance using resistivity meter, (ohms):"]
[]
[null,null,"Resistivity = SBF x Resistance, (ohm-cm):",null,null,null,{"$f":"IF(ISERROR(G32*G35),\"\",G32*G35)","v":""}]
[]
[]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2024-09-09T21:14:14.400"},null,null,null,null,null,null,"    · "]
[]
[]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX100"]
[]
[null,"TX400"]
[null,"Test Method:","Tested By:",null,null,"Tested Date:",null,null,null," ¨ "]
[null,"TX129"]
[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":[]}
[17]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF('Tex-129-E'!$B$42=\"\",\"\",'Tex-129-E'!$B$42)","v":""},{"$f":"'Tex-129-E'!$B$41","v":"Remarks:"}]
[2,{"$f":"IF('Tex-129-E'!$D$19=\"\",\"\",'Tex-129-E'!$D$19)","v":""},{"$f":"IF('Tex-129-E'!$C$19=\"\",\"\",'Tex-129-E'!$C$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('Tex-129-E'!$C$52=\"\",\"\",'Tex-129-E'!$C$52)","v":""},"Tested By ",{"$f":"IF('Tex-129-E'!$B$52=\"\",\"\",'Tex-129-E'!$B$52)","v":"TX129"}]
[4,{"$f":"IF('Tex-129-E'!$F$52=\"\",\"\",'Tex-129-E'!$F$52)","v":""},"Tested Date ",{"$f":"IF('Tex-129-E'!$B$52=\"\",\"\",'Tex-129-E'!$B$52)","v":"TX129"}]
[5,{"$f":"IF('Tex-129-E'!$G$29=\"\",\"\",'Tex-129-E'!$G$29)","v":""},{"$f":"IF('Tex-129-E'!$B$6=\"\",\"\",'Tex-129-E'!$B$6)","v":"Tex-129-E"},{"$f":"IF('Tex-129-E'!$C$29=\"\",\"\",'Tex-129-E'!$C$29)","v":"A = Area of one electrode, (cm2):"}]
[6,{"$f":"IF('Tex-129-E'!$G$30=\"\",\"\",'Tex-129-E'!$G$30)","v":""},{"$f":"IF('Tex-129-E'!$B$6=\"\",\"\",'Tex-129-E'!$B$6)","v":"Tex-129-E"},{"$f":"IF('Tex-129-E'!$C$30=\"\",\"\",'Tex-129-E'!$C$30)","v":"D = Distance between electrodes, (cm):"}]
[7,{"$f":"IF('Tex-129-E'!$G$32=\"\",\"\",'Tex-129-E'!$G$32)","v":""},{"$f":"IF('Tex-129-E'!$B$6=\"\",\"\",'Tex-129-E'!$B$6)","v":"Tex-129-E"},{"$f":"IF('Tex-129-E'!$C$32=\"\",\"\",'Tex-129-E'!$C$32)","v":"Soil Box Factor (SBF) = A / D:"}]
[8,{"$f":"IF('Tex-129-E'!$G$35=\"\",\"\",'Tex-129-E'!$G$35)","v":""},{"$f":"IF('Tex-129-E'!$B$6=\"\",\"\",'Tex-129-E'!$B$6)","v":"Tex-129-E"},{"$f":"IF('Tex-129-E'!$C$35=\"\",\"\",'Tex-129-E'!$C$35)","v":"Resistance using resistivity meter, (ohms):"}]
[9,{"$f":"IF('Tex-129-E'!$G$37=\"\",\"\",'Tex-129-E'!$G$37)","v":""},{"$f":"IF('Tex-129-E'!$B$6=\"\",\"\",'Tex-129-E'!$B$6)","v":"Tex-129-E"},{"$f":"IF('Tex-129-E'!$C$37=\"\",\"\",'Tex-129-E'!$C$37)","v":"Resistivity = SBF x Resistance, (ohm-cm):"}]
[10,{"$f":"IF('Tex-129-E'!$C$48=\"\",\"\",'Tex-129-E'!$C$48)","v":""},"Sampled By ",{"$f":"IF('Tex-129-E'!$B$48=\"\",\"\",'Tex-129-E'!$B$48)","v":"TX100"}]
[11,{"$f":"IF('Tex-129-E'!$F$48=\"\",\"\",'Tex-129-E'!$F$48)","v":""},"Sampled Date ",{"$f":"IF('Tex-129-E'!$B$48=\"\",\"\",'Tex-129-E'!$B$48)","v":"TX100"}]
[12,{"$f":"IF('Tex-129-E'!$C$50=\"\",\"\",'Tex-129-E'!$C$50)","v":""},"Sampled By ",{"$f":"IF('Tex-129-E'!$B$50=\"\",\"\",'Tex-129-E'!$B$50)","v":"TX400"}]
[13,{"$f":"IF('Tex-129-E'!$F$50=\"\",\"\",'Tex-129-E'!$F$50)","v":""},"Sampled Date ",{"$f":"IF('Tex-129-E'!$B$50=\"\",\"\",'Tex-129-E'!$B$50)","v":"TX400"}]
[14,{"$f":"IF([0]!Field17=\"\",\"\",Field17)","v":""},"Tex-129-E",{"$f":"IF('Tex-129-E'!$C$23=\"\",\"\",'Tex-129-E'!$C$23)","v":"100-ohm"}]
[15,{"$f":"IF([0]!Field18=\"\",\"\",Field18)","v":""},"Tex-129-E",{"$f":"IF('Tex-129-E'!$C$24=\"\",\"\",'Tex-129-E'!$C$24)","v":"200-ohm"}]
[16,{"$f":"IF([0]!Field19=\"\",\"\",Field19)","v":""},"Tex-129-E",{"$f":"IF('Tex-129-E'!$C$25=\"\",\"\",'Tex-129-E'!$C$25)","v":"500-ohm"}]
[17,{"$f":"IF([0]!Field20=\"\",\"\",Field20)","v":""},"Tex-129-E",{"$f":"IF('Tex-129-E'!$C$26=\"\",\"\",'Tex-129-E'!$C$26)","v":"900-ohm"}]