{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tex-112-E","RX"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":85,"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-112-E","index":0,"n_rows":79,"n_cols":14,"rows_kept":79,"cut":false,"hidden":false,"merged":[[14,3,14,11],[18,9,18,11],[79,1,79,3],[75,6,75,10],[65,1,66,11],[73,2,73,4],[68,2,68,4],[69,2,69,4],[71,2,71,4],[0,0,0,1],[12,8,12,11],[75,1,75,3],[72,2,72,4],[9,8,9,11],[9,3,9,4],[16,3,16,4],[11,8,11,11],[18,5,18,6],[13,3,13,4],[11,3,11,4],[12,3,12,4],[20,3,20,7],[15,3,15,11],[13,8,13,11],[16,8,16,11],[7,8,7,11],[10,8,10,11],[7,3,7,4],[8,3,8,4],[8,8,8,11],[10,3,10,4]]}
["TxDOT Manuals >",null,null,"Tex-112-E"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,null,null,null,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"tx112.xlsm::45448.655602"]
[null,"Admixing Lime To Reduce Plasticity Index of Soils"]
[null,"Tex-112-E"]
[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: 06/05/24 15:44:04"}]
[null,null,"SAMPLE ID:",null,null,null,null,"SAMPLED DATE:"]
[null,null,"TEST NUMBER:",null,null,null,null,"LETTING DATE:"]
[null,null,"SAMPLE STATUS:",null,null,null,null,"CONTROLLING CSJ:"]
[null,null,"COUNTY:",null,null,null,null,"SPEC YEAR:"]
[null,null,"SAMPLED BY:",null,null,null,null,"SPEC ITEM:"]
[null,null,"SAMPLE LOCATION:",null,null,null,null,"SPECIAL PROVISION:"]
[null,null,"MATERIAL CODE:",null,null,null,null,"GRADE:"]
[null,null,"MATERIAL NAME:"]
[null,null,"PRODUCER:"]
[null,null,"AREA ENGINEER:",null,null,null,null,"PROJECT MANAGER:"]
[]
[null,null,"COURSE\\LIFT:",null,"STATION:",null,null,null,"DIST. FROM CL:"]
[]
[null,null,null,"Soil = 30 grams"]
[null,null,null,"Series","% Lime by Weight","Lime Weight (g)","LL","PI"]
[null,null,null,1,0,0,null,null,null,{"$f":"IF($D$33=H23,E23,\"\")","v":0}]
[null,null,null,2,2,0.6,null,null,null,2]
[null,null,null,3,4,1.2,null,null,null,4]
[null,null,null,4,6,1.8,null,null,null,6]
[null,null,null,5,8,2.4,null,null,null,8]
[null,null,null,6,10,3,null,null,null,10]
[null,null,null,7,null,null,null,null,null,0,null,null,"% Lime","pH"]
[null,null,null,8,null,null,null,null,null,0,null,null,0,12.4]
[]
[]
[null,null,"Minimum PI: ",{"$f":"IF(COUNTBLANK(H23:H30)=8,\"\",MIN(H23,H24,H25,H26,H27,H28,H29,H30))","v":""},null,null,null,null,null,null,null,null,14,12.4]
[null,null,"Optimum Lime, %: ",{"$f":"IF(COUNTBLANK(J23:J30)=7,MAX(J23:J29),\"\")","v":""}]
[]
[null,null,"Recommended Lime, %:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2024-06-05T15:44:04.960"}]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX100"," ",null,null," "]
[]
[null,"TX400"," ",null,null," "]
[null,"Test Method:","Tested By:",null,null,"Tested Date:"]
[null,"TX112"," ",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":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[19]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF('Tex-112-E'!$B$66=\"\",\"\",'Tex-112-E'!$B$66)","v":""},{"$f":"'Tex-112-E'!$B$65","v":"Remarks:"}]
[2,{"$f":"IF('Tex-112-E'!$D$19=\"\",\"\",'Tex-112-E'!$D$19)","v":""},{"$f":"IF('Tex-112-E'!$C$19=\"\",\"\",'Tex-112-E'!$C$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('Tex-112-E'!$C$74=\"\",\"\",'Tex-112-E'!$C$74)","v":" "},"Tested By ",{"$f":"IF('Tex-112-E'!$B$74=\"\",\"\",'Tex-112-E'!$B$74)","v":"TX112"}]
[4,{"$f":"IF('Tex-112-E'!$F$74=\"\",\"\",'Tex-112-E'!$F$74)","v":" "},"Tested Date ",{"$f":"IF('Tex-112-E'!$B$74=\"\",\"\",'Tex-112-E'!$B$74)","v":"TX112"}]
[5,{"$f":"IF('Tex-112-E'!$H$23=\"\",\"\",'Tex-112-E'!$H$23)","v":""},{"$f":"IF('Tex-112-E'!$B$6=\"\",\"\",'Tex-112-E'!$B$6)","v":"Tex-112-E"},{"$f":"IF('Tex-112-E'!$D$22=\"\",\"\",'Tex-112-E'!$D$22)","v":"Series"},{"$f":"IF('Tex-112-E'!$D$23=\"\",\"\",'Tex-112-E'!$D$23)","v":1},{"$f":"IF('Tex-112-E'!$E$22=\"\",\"\",'Tex-112-E'!$E$22)","v":"% Lime by Weight"},{"$f":"IF('Tex-112-E'!$E$23=\"\",\"\",'Tex-112-E'!$E$23)","v":0},{"$f":"IF('Tex-112-E'!$H$22=\"\",\"\",'Tex-112-E'!$H$22)","v":"PI"}]
[6,{"$f":"IF('Tex-112-E'!$H$24=\"\",\"\",'Tex-112-E'!$H$24)","v":""},{"$f":"IF('Tex-112-E'!$B$6=\"\",\"\",'Tex-112-E'!$B$6)","v":"Tex-112-E"},{"$f":"IF('Tex-112-E'!$D$22=\"\",\"\",'Tex-112-E'!$D$22)","v":"Series"},{"$f":"IF('Tex-112-E'!$D$23=\"\",\"\",'Tex-112-E'!$D$24)","v":2},{"$f":"IF('Tex-112-E'!$E$22=\"\",\"\",'Tex-112-E'!$E$22)","v":"% Lime by Weight"},{"$f":"IF('Tex-112-E'!$E$24=\"\",\"\",'Tex-112-E'!$E$24)","v":2},{"$f":"IF('Tex-112-E'!$H$22=\"\",\"\",'Tex-112-E'!$H$22)","v":"PI"}]
[7,{"$f":"IF('Tex-112-E'!$H$25=\"\",\"\",'Tex-112-E'!$H$25)","v":""},{"$f":"IF('Tex-112-E'!$B$6=\"\",\"\",'Tex-112-E'!$B$6)","v":"Tex-112-E"},{"$f":"IF('Tex-112-E'!$D$22=\"\",\"\",'Tex-112-E'!$D$22)","v":"Series"},{"$f":"IF('Tex-112-E'!$D$25=\"\",\"\",'Tex-112-E'!$D$25)","v":3},{"$f":"IF('Tex-112-E'!$E$22=\"\",\"\",'Tex-112-E'!$E$22)","v":"% Lime by Weight"},{"$f":"IF('Tex-112-E'!$E$25=\"\",\"\",'Tex-112-E'!$E$25)","v":4},{"$f":"IF('Tex-112-E'!$H$22=\"\",\"\",'Tex-112-E'!$H$22)","v":"PI"}]
[8,{"$f":"IF('Tex-112-E'!$H$26=\"\",\"\",'Tex-112-E'!$H$26)","v":""},{"$f":"IF('Tex-112-E'!$B$6=\"\",\"\",'Tex-112-E'!$B$6)","v":"Tex-112-E"},{"$f":"IF('Tex-112-E'!$D$22=\"\",\"\",'Tex-112-E'!$D$22)","v":"Series"},{"$f":"IF('Tex-112-E'!$D$26=\"\",\"\",'Tex-112-E'!$D$26)","v":4},{"$f":"IF('Tex-112-E'!$E$22=\"\",\"\",'Tex-112-E'!$E$22)","v":"% Lime by Weight"},{"$f":"IF('Tex-112-E'!$E$26=\"\",\"\",'Tex-112-E'!$E$26)","v":6},{"$f":"IF('Tex-112-E'!$H$22=\"\",\"\",'Tex-112-E'!$H$22)","v":"PI"}]
[9,{"$f":"IF('Tex-112-E'!$H$27=\"\",\"\",'Tex-112-E'!$H$27)","v":""},{"$f":"IF('Tex-112-E'!$B$6=\"\",\"\",'Tex-112-E'!$B$6)","v":"Tex-112-E"},{"$f":"IF('Tex-112-E'!$D$22=\"\",\"\",'Tex-112-E'!$D$22)","v":"Series"},{"$f":"IF('Tex-112-E'!$D$27=\"\",\"\",'Tex-112-E'!$D$27)","v":5},{"$f":"IF('Tex-112-E'!$E$22=\"\",\"\",'Tex-112-E'!$E$22)","v":"% Lime by Weight"},{"$f":"IF('Tex-112-E'!$E$27=\"\",\"\",'Tex-112-E'!$E$27)","v":8},{"$f":"IF('Tex-112-E'!$H$22=\"\",\"\",'Tex-112-E'!$H$22)","v":"PI"}]
[10,{"$f":"IF('Tex-112-E'!$H$28=\"\",\"\",'Tex-112-E'!$H$28)","v":""},{"$f":"IF('Tex-112-E'!$B$6=\"\",\"\",'Tex-112-E'!$B$6)","v":"Tex-112-E"},{"$f":"IF('Tex-112-E'!$D$22=\"\",\"\",'Tex-112-E'!$D$22)","v":"Series"},{"$f":"IF('Tex-112-E'!$D$28=\"\",\"\",'Tex-112-E'!$D$28)","v":6},{"$f":"IF('Tex-112-E'!$E$22=\"\",\"\",'Tex-112-E'!$E$22)","v":"% Lime by Weight"},{"$f":"IF('Tex-112-E'!$E$28=\"\",\"\",'Tex-112-E'!$E$28)","v":10},{"$f":"IF('Tex-112-E'!$H$22=\"\",\"\",'Tex-112-E'!$H$22)","v":"PI"}]
[11,{"$f":"IF('Tex-112-E'!$H$29=\"\",\"\",'Tex-112-E'!$H$29)","v":""},{"$f":"IF('Tex-112-E'!$B$6=\"\",\"\",'Tex-112-E'!$B$6)","v":"Tex-112-E"},{"$f":"IF('Tex-112-E'!$D$22=\"\",\"\",'Tex-112-E'!$D$22)","v":"Series"},{"$f":"IF('Tex-112-E'!$D$29=\"\",\"\",'Tex-112-E'!$D$29)","v":7},{"$f":"IF('Tex-112-E'!$E$22=\"\",\"\",'Tex-112-E'!$E$22)","v":"% Lime by Weight"},{"$f":"IF('Tex-112-E'!$E$29=\"\",\"\",'Tex-112-E'!$E$29)","v":""},{"$f":"IF('Tex-112-E'!$H$22=\"\",\"\",'Tex-112-E'!$H$22)","v":"PI"}]
[12,{"$f":"IF('Tex-112-E'!$H$30=\"\",\"\",'Tex-112-E'!$H$30)","v":""},{"$f":"IF('Tex-112-E'!$B$6=\"\",\"\",'Tex-112-E'!$B$6)","v":"Tex-112-E"},{"$f":"IF('Tex-112-E'!$D$22=\"\",\"\",'Tex-112-E'!$D$22)","v":"Series"},{"$f":"IF('Tex-112-E'!$D$30=\"\",\"\",'Tex-112-E'!$D$30)","v":8},{"$f":"IF('Tex-112-E'!$E$22=\"\",\"\",'Tex-112-E'!$E$22)","v":"% Lime by Weight"},{"$f":"IF('Tex-112-E'!$E$30=\"\",\"\",'Tex-112-E'!$E$30)","v":""},{"$f":"IF('Tex-112-E'!$H$22=\"\",\"\",'Tex-112-E'!$H$22)","v":"PI"}]
[13,{"$f":"IF('Tex-112-E'!D33=\"\",\"\",'Tex-112-E'!D33)","v":""},{"$f":"IF('Tex-112-E'!$B$6=\"\",\"\",'Tex-112-E'!$B$6)","v":"Tex-112-E"},{"$f":"IF('Tex-112-E'!C33=\"\",\"\",'Tex-112-E'!C33)","v":"Minimum PI: "}]
[14,{"$f":"IF('Tex-112-E'!D34=\"\",\"\",'Tex-112-E'!D34)","v":""},{"$f":"IF('Tex-112-E'!$B$6=\"\",\"\",'Tex-112-E'!$B$6)","v":"Tex-112-E"},{"$f":"IF('Tex-112-E'!C34=\"\",\"\",'Tex-112-E'!C34)","v":"Optimum Lime, %: "}]
[15,{"$f":"IF('Tex-112-E'!D36=\"\",\"\",'Tex-112-E'!D36)","v":""},{"$f":"IF('Tex-112-E'!$B$6=\"\",\"\",'Tex-112-E'!$B$6)","v":"Tex-112-E"},{"$f":"IF('Tex-112-E'!C36=\"\",\"\",'Tex-112-E'!C36)","v":"Recommended Lime, %:"}]
[16,{"$f":"IF('Tex-112-E'!$C$70=\"\",\"\",'Tex-112-E'!$C$70)","v":" "},"Sampled By ",{"$f":"IF('Tex-112-E'!$B$70=\"\",\"\",'Tex-112-E'!$B$70)","v":"TX100"}]
[17,{"$f":"IF('Tex-112-E'!$F$70=\"\",\"\",'Tex-112-E'!$F$70)","v":" "},"Sampled Date ",{"$f":"IF('Tex-112-E'!$B$70=\"\",\"\",'Tex-112-E'!$B$70)","v":"TX100"}]
[18,{"$f":"IF('Tex-112-E'!$C$72=\"\",\"\",'Tex-112-E'!$C$72)","v":" "},"Sampled By ",{"$f":"IF('Tex-112-E'!$B$72=\"\",\"\",'Tex-112-E'!$B$72)","v":"TX400"}]
[19,{"$f":"IF('Tex-112-E'!$F$72=\"\",\"\",'Tex-112-E'!$F$72)","v":" "},"Sampled Date ",{"$f":"IF('Tex-112-E'!$B$72=\"\",\"\",'Tex-112-E'!$B$72)","v":"TX400"}]