{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["TEX-107-E","RX","Revisions","GRADATIONS"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":80,"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-107-E","index":0,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[[22,2,23,2],[22,3,23,3],[37,1,37,8],[45,6,45,8],[15,3,15,8],[22,6,23,6],[21,1,21,8],[22,5,23,5],[22,7,23,7],[22,8,23,8],[38,2,38,4],[39,2,39,4],[41,2,41,4],[0,0,0,1],[13,3,13,4],[12,3,12,4],[11,3,11,4],[7,7,7,8],[9,7,9,8],[7,3,7,4],[8,3,8,4],[8,7,8,8],[11,7,11,8],[12,7,12,8],[49,1,49,3],[9,3,9,4],[43,2,43,4],[34,1,35,8],[13,7,13,8],[22,1,23,1],[36,1,36,8],[10,3,10,4],[22,4,23,4],[42,2,42,4],[10,7,10,8],[14,3,14,8],[16,7,16,8],[16,3,16,4],[45,1,45,3],[28,2,28,5]]}
["TxDOT Manuals >",null,null,"Tex-107-E"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,"tx107.xlsm::45462.670694"]
[null,"BAR LINEAR SHRINKAGE"]
[null,"TEX-107-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: 06/19/24 16:05: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,"MIX TYPE / 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,"Bar Linear Shrinkage - Tex-107-E"]
[null,"Unit",{"$f":"\"Initial Length (\" & Unit & \")\"","v":"Initial Length ()"},{"$f":"\"Final Length (\" & +Unit & \")\"","v":"Final Length ()"},"Linear Shrinkage","Minimum by Specification","Meets Specification","Maximum by Specification","Meets Specification"]
[]
[null,null,{"$f":"IF(Unit=\"\",\"\",IF(Unit=\"percent\",100,IF(Unit=\"Inches\",5,127)))","v":""},null,{"$f":"IF(ISERROR(IF(B25=\"percent\",$C25-$D25,100*($C25-$D25)/$C25)),\"\",IF(B25=\"percent\",$C25-$D25,100*($C25-$D25)/$C25))","v":""},{"$f":"IF(OR(LEFT(Material,3)=\"034\",SpecYear>=\"2004\"),\"\",IF(ISERROR(INDEX(INDIRECT(\"grade\"&Grade),1,2)),\"\",INDEX(INDIRECT(\"grade\"&Grade),1,2)))","v":""},{"$f":"IF(OR(LEFT(Material,3)=\"034\",SpecYear>=\"2004\"),\"\",IF(OR(LEFT(Material,3)=\"034\",SUM(C25:D25)=0),\"\",IF(LinearShrink<LinearShrinkSpec,\"No\",\"Yes\")))","v":""},{"$f":"IF(LEFT(Material,3)<>\"034\",\"\",IF(ISERROR(INDEX(INDIRECT(\"grade\"&Grade),1,3)),\"\",INDEX(INDIRECT(\"grade\"&Grade),1,3)))","v":""},{"$f":"IF(LEFT(Material,3)<>\"034\",\"\",IF(OR(LEFT(Material,3)<>\"034\",SUM(C25:D25)=0),\"\",IF($H$25<$E$25,\"No\",\"Yes\")))","v":""}]
[]
[null,null,null,null,null,"Calculate Plasticity Index from Bar Linear Shrinkage?"]
[]
[null,null,"Plasticity Index Calculated from Linear Shrinkage:",null,null,null,{"$f":"IF(ISERROR(IF(CheckBox4BLS=\"Yes\",LinearShrink*1.6,\"\")),\"\",IF(CheckBox4BLS=\"Yes\",LinearShrink*1.6,\"\"))","v":""}]
[]
[]
[]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2024-06-19T16:05:48.080"}]
[]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX100"]
[]
[null,"TX400"]
[null,"Test Method:","Tested By:",null,null,"Tested Date:"]
[null,"TX107"]
[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":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[18]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF('TEX-107-E'!$B$35=\"\",\"\",'TEX-107-E'!$B$35)","v":""},{"$f":"'TEX-107-E'!$B$34","v":"Remarks:"}]
[2,{"$f":"IF('TEX-107-E'!$D$19=\"\",\"\",'TEX-107-E'!$D$19)","v":""},{"$f":"IF('TEX-107-E'!$C$19=\"\",\"\",'TEX-107-E'!$C$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('TEX-107-E'!$C$44=\"\",\"\",'TEX-107-E'!$C$44)","v":""},"Tested By ",{"$f":"IF('TEX-107-E'!$B$44=\"\",\"\",'TEX-107-E'!$B$44)","v":"TX107"}]
[4,{"$f":"IF('TEX-107-E'!$F$44=\"\",\"\",'TEX-107-E'!$F$44)","v":""},"Tested Date ",{"$f":"IF('TEX-107-E'!$B$44=\"\",\"\",'TEX-107-E'!$B$44)","v":"TX107"}]
[5,{"$f":"IF('TEX-107-E'!$B$25=\"\",\"\",'TEX-107-E'!$B$25)","v":""},{"$f":"IF('TEX-107-E'!$B$22=\"\",\"\",'TEX-107-E'!$B$22)","v":"Bar Linear Shrinkage - Tex-107-E"},{"$f":"IF('TEX-107-E'!$B$23=\"\",\"\",'TEX-107-E'!$B$23)","v":"Unit"}]
[6,{"$f":"IF('TEX-107-E'!$C$25=\"\",\"\",'TEX-107-E'!$C$25)","v":""},{"$f":"IF('TEX-107-E'!$B$22=\"\",\"\",'TEX-107-E'!$B$22)","v":"Bar Linear Shrinkage - Tex-107-E"},{"$f":"IF('TEX-107-E'!$C$23=\"\",\"\",'TEX-107-E'!$C$23)","v":"Initial Length ()"}]
[7,{"$f":"IF('TEX-107-E'!$D$25=\"\",\"\",'TEX-107-E'!$D$25)","v":""},{"$f":"IF('TEX-107-E'!$B$22=\"\",\"\",'TEX-107-E'!$B$22)","v":"Bar Linear Shrinkage - Tex-107-E"},{"$f":"IF('TEX-107-E'!$D$23=\"\",\"\",'TEX-107-E'!$D$23)","v":"Final Length ()"}]
[8,{"$f":"IF('TEX-107-E'!$E$25=\"\",\"\",'TEX-107-E'!$E$25)","v":""},{"$f":"IF('TEX-107-E'!$B$22=\"\",\"\",'TEX-107-E'!$B$22)","v":"Bar Linear Shrinkage - Tex-107-E"},{"$f":"IF('TEX-107-E'!$E$23=\"\",\"\",'TEX-107-E'!$E$23)","v":"Linear Shrinkage"}]
[9,{"$f":"IF('TEX-107-E'!$F$25=\"\",\"\",'TEX-107-E'!$F$25)","v":""},{"$f":"IF('TEX-107-E'!$B$22=\"\",\"\",'TEX-107-E'!$B$22)","v":"Bar Linear Shrinkage - Tex-107-E"},{"$f":"IF('TEX-107-E'!$F$23=\"\",\"\",'TEX-107-E'!$F$23)","v":"Minimum by Specification"}]
[10,{"$f":"IF('TEX-107-E'!$G$25=\"\",\"\",'TEX-107-E'!$G$25)","v":""},{"$f":"IF('TEX-107-E'!$B$22=\"\",\"\",'TEX-107-E'!$B$22)","v":"Bar Linear Shrinkage - Tex-107-E"},{"$f":"IF('TEX-107-E'!$G$23=\"\",\"\",'TEX-107-E'!$G$23)","v":"Meets Specification"}]
[11,{"$f":"IF('TEX-107-E'!$H$25=\"\",\"\",'TEX-107-E'!$H$25)","v":""},{"$f":"IF('TEX-107-E'!$B$22=\"\",\"\",'TEX-107-E'!$B$22)","v":"Bar Linear Shrinkage - Tex-107-E"},{"$f":"IF('TEX-107-E'!$H$23=\"\",\"\",'TEX-107-E'!$H$23)","v":"Maximum by Specification"}]
[12,{"$f":"IF('TEX-107-E'!$I$25=\"\",\"\",'TEX-107-E'!$I$25)","v":""},{"$f":"IF('TEX-107-E'!$B$22=\"\",\"\",'TEX-107-E'!$B$22)","v":"Bar Linear Shrinkage - Tex-107-E"},{"$f":"IF('TEX-107-E'!$I$23=\"\",\"\",'TEX-107-E'!$I$23)","v":"Meets Specification"}]
[13,{"$f":"IF('TEX-107-E'!$G$27=\"\",\"\",'TEX-107-E'!$G$27)","v":""},{"$f":"IF('TEX-107-E'!$B$22=\"\",\"\",'TEX-107-E'!$B$22)","v":"Bar Linear Shrinkage - Tex-107-E"},{"$f":"IF('TEX-107-E'!$F$27=\"\",\"\",'TEX-107-E'!$F$27)","v":"Calculate Plasticity Index from Bar Linear Shrinkage?"}]
[14,{"$f":"IF('TEX-107-E'!$G$29=\"\",\"\",'TEX-107-E'!$G$29)","v":""},{"$f":"IF('TEX-107-E'!$B$22=\"\",\"\",'TEX-107-E'!$B$22)","v":"Bar Linear Shrinkage - Tex-107-E"},{"$f":"IF('TEX-107-E'!$C$29=\"\",\"\",'TEX-107-E'!$C$29)","v":"Plasticity Index Calculated from Linear Shrinkage:"}]
[15,{"$f":"IF('TEX-107-E'!$C$40=\"\",\"\",'TEX-107-E'!$C$40)","v":""},"Sampled By","TX100"]
[16,{"$f":"IF('TEX-107-E'!$F$40=\"\",\"\",'TEX-107-E'!$F$40)","v":""},"Sampled Date","TX100"]
[17,{"$f":"IF('TEX-107-E'!$C$42=\"\",\"\",'TEX-107-E'!$C$42)","v":""},"Sampled By","TX400"]
[18,{"$f":"IF('TEX-107-E'!$F$42=\"\",\"\",'TEX-107-E'!$F$42)","v":""},"Sampled Date","TX400"]

{"sheet":"Revisions","index":2,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Date","Changes","By"]
["2005-05-03","G22- Modify condition format from =LEFT(Material,3)=\"034\" to =OR(LEFT(Material,3)=\"034\",SpecYear=\"2004\")","Joe Liu"]

{"sheet":"GRADATIONS","index":3,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":true,"merged":[[17,0,18,0],[17,1,18,1],[19,0,25,0],[19,1,25,1],[1,0,5,0],[14,0,16,0],[1,1,5,1],[6,1,9,1],[10,1,13,1],[14,1,16,1],[10,0,13,0],[6,0,9,0],[17,2,18,2],[19,2,25,2],[1,2,5,2],[6,2,9,2],[10,2,13,2],[14,2,16,2]]}
["Grade","Bar Linear Shrinkage (min)","Bar Linear Shrinkage (max) HMAC"]
["GRADE 1",2,3]
[]
[]
[]
[]
["GRADE 2",2,3]
[]
[]
[]
["GRADE 3",2,3]
[]
[]
[]
["GRADE 4",2,3]
[]
[]
["GRADE 5",2,3]
[]
["Grade 6 User Input"]