{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Tex-249-F","RX","Revisions","MixTypes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":73,"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-249-F","index":0,"n_rows":42,"n_cols":15,"rows_kept":42,"cut":false,"hidden":false,"merged":[[42,1,42,5],[18,3,18,4],[18,6,18,7],[24,6,24,10],[25,6,25,10],[26,6,26,10],[20,1,20,2],[20,3,20,4],[38,1,38,5],[40,2,40,3],[40,4,40,5],[22,1,23,1],[22,2,23,2],[22,3,23,3],[22,4,23,4],[22,5,23,5],[0,0,0,1],[38,8,38,12],[30,1,31,12],[36,2,36,6],[12,10,12,12],[11,4,11,6],[12,4,12,6],[7,10,7,12],[10,10,10,12],[7,4,7,6],[8,4,8,6],[8,10,8,12],[14,4,14,12],[27,1,27,2],[35,2,35,6],[18,10,18,12],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[18,8,18,9],[7,7,7,9],[8,7,8,9],[9,7,9,9],[10,7,10,9],[11,7,11,9],[33,2,33,6],[34,2,34,6],[15,4,15,12],[13,10,13,12],[9,4,9,6],[13,4,13,6],[22,6,23,10],[16,4,16,6],[11,10,11,12],[10,4,10,6],[16,10,16,12],[13,7,13,9],[16,7,16,9],[9,10,9,12],[12,7,12,9],[20,5,20,6]]}
["TxDOT Manuals >",null,null,"Tex-249-F"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tx249.xlsm::45574.650891"]
[null,"SHEAR TEST"]
[null,"Tex-249-F"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TestMethod & \" :: File Version: \" & TEXT(MID(sn,SEARCH(\"::\",sn,1)+2,20),\"mm/dd/yy hh:mm:ss\")","v":"Tex-249-F :: File Version: 10/09/24 15:37:17"}]
[null,"SAMPLE ID:",null,null,null,null,null,"SAMPLED DATE:"]
[null,"TEST NUMBER:",null,null,null,null,null,"LETTING DATE:"]
[null,"SAMPLE STATUS:",null,null,null,null,null,"CONTROLLING CSJ:"]
[null,"COUNTY:",null,null,null,null,null,"SPEC YEAR:"]
[null,"SAMPLED BY:",null,null,null,null,null,"SPEC ITEM:"]
[null,"SAMPLE LOCATION:",null,null,null,null,null,"SPECIAL PROVISION:"]
[null,"MATERIAL CODE:",null,null,null,null,null,"MIX TYPE:"]
[null,"MATERIAL NAME:"]
[null,"PRODUCER:"]
[null,"AREA ENGINEER:",null,null,null,null,null,"PROJECT MANAGER:"]
[]
[null,null,"COURSE\\LIFT:",null,null,"STATION:",null,null,"DIST. FROM CL:"]
[]
[null,"Tack/Underseal Technology:",null,null,null,"Application Rate, gal/SY:"]
[]
[null,"Test","Sample ID","Maximum Load, lbs","Sample Diameter, in","Shear Strength, psi","Comments"]
[]
[null,1,null,null,null,{"$f":"IF(ISERROR(4*D25/(3.1416*E25^2)),\"\",(4*D25/(3.1416*E25^2)))","v":""}]
[null,2,null,null,null,{"$f":"IF(ISERROR(4*D26/(3.1416*E26^2)),\"\",(4*D26/(3.1416*E26^2)))","v":""}]
[null,3,null,null,null,{"$f":"IF(ISERROR(4*D27/(3.1416*E27^2)),\"\",(4*D27/(3.1416*E27^2)))","v":""}]
[null,"AVERAGE: ",null,{"$f":"IF(ISERROR(AVERAGE(D25:D27)),\"\",AVERAGE(D25:D27))","v":""},{"$f":"IF(ISERROR(AVERAGE(E25:E27)),\"\",AVERAGE(E25:E27))","v":""},{"$f":"IF(ISERROR(AVERAGE(F25:F27)),\"\",AVERAGE(F25:F27))","v":""}]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2024-10-09T15:37:17.990"}]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,null,null,"Sampled Date:"]
[null,"TX251"]
[null,"Test Method:","Tested By:",null,null,null,null,"Tested Date:"]
[null,"TX249"]
[null,"Test Stamp Code:",null,null,null,null,"Omit Test:","Completed Date:","Reviewed By:"]
[]
[null,"Locked By:","TxDOT:",null,"District:",null,"Area:"]
[]
[null,"Authorized By:",null,null,null,null,"Authorized Date:"]

{"sheet":"RX","index":1,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[29]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF('Tex-249-F'!$B$31=\"\",\"\",'Tex-249-F'!$B$31)","v":""},{"$f":"'Tex-249-F'!B30","v":"Remarks:"}]
[2,{"$f":"IF('Tex-249-F'!$D$19=\"\",\"\",'Tex-249-F'!$D$19)","v":""},{"$f":"'Tex-249-F'!C19","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('Tex-249-F'!$C$37=\"\",\"\",'Tex-249-F'!$C$37)","v":""},"Tested By ","TX249"]
[4,{"$f":"IF('Tex-249-F'!$H$37=\"\",\"\",'Tex-249-F'!$H$37)","v":""},"Tested Date ","TX249"]
[5,{"$f":"IF(Field2=\"\",\"\",Field2)","v":""},{"$f":"'Tex-249-F'!D1","v":"Tex-249-F"},{"$f":"'Tex-249-F'!H11","v":"SPEC YEAR:"}]
[6,{"$f":"IF(Field3=\"\",\"\",Field3)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!H13","v":"SPECIAL PROVISION:"}]
[7,{"$f":"IF(Field4=\"\",\"\",Field4)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!H14","v":"MIX TYPE:"}]
[8,{"$f":"IF(Field6=\"\",\"\",Field6)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!B21","v":"Tack/Underseal Technology:"}]
[9,{"$f":"IF(Field7=\"\",\"\",Field7)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!F21","v":"Application Rate, gal/SY:"}]
[10,{"$f":"IF(Field8=\"\",\"\",Field8)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!C23","v":"Sample ID"},"Test",1]
[11,{"$f":"IF(Field12=\"\",\"\",Field12)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!C23","v":"Sample ID"},"Test",2]
[12,{"$f":"IF(Field16=\"\",\"\",Field16)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!C23","v":"Sample ID"},"Test",3]
[13,{"$f":"IF(Field9=\"\",\"\",Field9)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!D23","v":"Maximum Load, lbs"},"Test",1]
[14,{"$f":"IF(Field13=\"\",\"\",Field13)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!D23","v":"Maximum Load, lbs"},"Test",2]
[15,{"$f":"IF(Field17=\"\",\"\",Field17)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!D23","v":"Maximum Load, lbs"},"Test",3]
[16,{"$f":"IF(Field10=\"\",\"\",Field10)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!E23","v":"Sample Diameter, in"},"Test",1]
[17,{"$f":"IF(Field14=\"\",\"\",Field14)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!E23","v":"Sample Diameter, in"},"Test",2]
[18,{"$f":"IF(Field18=\"\",\"\",Field18)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!E23","v":"Sample Diameter, in"},"Test",3]
[19,{"$f":"IF(Field11=\"\",\"\",Field11)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!G23","v":"Comments"},"Test",1]
[20,{"$f":"IF(Field15=\"\",\"\",Field15)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!G23","v":"Comments"},"Test",2]
[21,{"$f":"IF(Field19=\"\",\"\",Field19)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!G23","v":"Comments"},"Test",3]
[22,{"$f":"IF('Tex-249-F'!F25=\"\",\"\",'Tex-249-F'!F25)","v":""},"Tex-249-F","Shear Strength, psi","Test",1]
[23,{"$f":"IF('Tex-249-F'!F26=\"\",\"\",'Tex-249-F'!F26)","v":""},"Tex-249-F","Shear Strength, psi","Test",2]
[24,{"$f":"IF('Tex-249-F'!F27=\"\",\"\",'Tex-249-F'!F27)","v":""},"Tex-249-F","Shear Strength, psi","Test",3]
[25,{"$f":"IF('Tex-249-F'!D28=\"\",\"\",'Tex-249-F'!D28)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!D23","v":"Maximum Load, lbs"},{"$f":"'Tex-249-F'!B28","v":"AVERAGE: "},{"$f":"'Tex-249-F'!D28","v":""}]
[26,{"$f":"IF('Tex-249-F'!E28=\"\",\"\",'Tex-249-F'!E28)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!E23","v":"Sample Diameter, in"},{"$f":"'Tex-249-F'!B28","v":"AVERAGE: "},{"$f":"'Tex-249-F'!E28","v":""}]
[27,{"$f":"IF('Tex-249-F'!F28=\"\",\"\",'Tex-249-F'!F28)","v":""},"Tex-249-F",{"$f":"'Tex-249-F'!F23","v":"Shear Strength, psi"},{"$f":"'Tex-249-F'!B28","v":"AVERAGE: "},{"$f":"'Tex-249-F'!F28","v":""}]
[28,{"$f":"IF('Tex-249-F'!$C$35=\"\",\"\",'Tex-249-F'!$C$35)","v":""},"Sampled By ","TX251"]
[29,{"$f":"IF('Tex-249-F'!$H$35=\"\",\"\",'Tex-249-F'!$H$35)","v":""},"Sampled Date ","TX251"]

{"sheet":"Revisions","index":2,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Date","Changes","By","Comments"]
["2024-08-02","Added 2024 spec items","Syeda Rahman"]

{"sheet":"MixTypes","index":3,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[]
["Spec2004","Spec2014","Spec2024"]
["341-DG-A","341-DG-A","341-DG-B"]
["341-DG-B","341-DG-B","341-DG-C"]
["341-DG-C","341-DG-C","341-DG-D"]
["341-DG-D","341-DG-D","341-DG-F"]
["341-DG-F","341-DG-F","342-PFC-C"]
["342-PFC-C","342-PFC-C","342-PFC-F"]
["342-PFC-F","342-PFC-F","342-PFCR-F"]
["342-PFCR-C","342-PFCR-C","344-SP-A"]
["342-PFCR-F","342-PFCR-F","344-SP-B"]
["344-SP-A","344-SP-A","344-SP-C"]
["344-SP-B","344-SP-B","344-SP-D"]
["344-SP-C","344-SP-C","346-SMA-C"]
["344-SP-D","344-SP-D","346-SMA-D"]
["346-SMA-C","346-SMA-C","346-SMA-F"]
["346-SMA-D","346-SMA-D","346-SMAR-F"]
["346-SMA-F","346-SMA-F","SS-CAM"]
["346-SMAR-C","346-SMAR-C"]
["346-SMAR-F","346-SMAR-F"]
["347-TOM-C","347-TOM-C"]
["347-TOM-F","347-TOM-F"]
["348-PFC-C","348-PFC-C"]
["348-PFC-F","348-PFC-F"]
["348-PFCR-C","348-PFCR-C"]
["348-TBWC-A","348-TBWC-A"]
["348-TBWC-B","348-TBWC-B"]
["348-TBWC-C","348-TBWC-C"]
["SS-CAM","SS-CAM"]