{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["MTD-GSA Test Results","RX"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":54,"comments":0,"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":"MTD-GSA Test Results","index":0,"n_rows":42,"n_cols":15,"rows_kept":42,"cut":false,"hidden":false,"merged":[[27,5,27,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[26,5,26,6],[20,5,20,6],[18,4,18,8],[5,4,5,5],[5,8,5,11],[6,4,6,5],[6,8,6,11],[7,4,7,5],[7,8,7,11],[8,4,8,5],[8,8,8,11],[9,4,9,5],[9,8,9,11],[10,4,10,5],[10,8,10,11],[11,4,11,5],[11,8,11,11],[12,4,12,11],[13,4,13,11],[14,4,14,5],[14,8,14,11],[16,6,16,7],[40,1,40,2],[42,1,42,4],[36,2,36,4],[35,2,35,4],[31,1,32,11],[38,1,38,4],[38,7,38,11],[33,2,33,4],[34,2,34,4]]}
[null,"TEXAS DEPARTMENT OF TRANSPORTATION"]
[null,"DETERMINING THE PRESENCE OF HARMFUL CLAYS USING METHYLENE BLUE",null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"Tex-252-F",null,null,null,null,null,null,null,null,null,null,null,null,"tx252.xlsm::45680.7064"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"TX252 - File Version: \" & TEXT(MID(sn,SEARCH(\"::\",sn,1)+2,20),\"mm/dd/yy hh:mm:ss\")","v":"TX252 - File Version: 01/23/25 16:57:13"}]
[null,null,null,"SAMPLE ID:",null,null,null,"SAMPLED DATE:"]
[null,null,null,"TEST NUMBER:",null,null,null,"LETTING DATE:"]
[null,null,null,"SAMPLE STATUS:",null,null,null,"CONTROLLING CSJ:"]
[null,null,null,"COUNTY:",null,null,null,"SPEC YEAR:"]
[null,null,null,"SAMPLED BY:",null,null,null,"SPEC ITEM:"]
[null,null,null,"SAMPLE LOCATION:",null,null,null,"SPECIAL PROVISION:"]
[null,null,null,"MATERIAL CODE:",null,null,null,"TYPE:"]
[null,null,null,"MATERIAL NAME:"]
[null,null,null,"PRODUCER:"]
[null,null,null,"AREA ENGINEER:",null,null,null,"PROJECT MANAGER:"]
[]
[null,null,null,"COURSE\\LIFT:",null,"STATION:",null,null,null,null,"DIST. FROM CL:"]
[]
[null,null,null,null,"Tex-252-F: Methylene Blue Value"]
[null,null,null,null,"Volume Used:",null,"ml"]
[null,null,null,null,"MBV (mg/g)","= [(5 x V) / 10 ]"]
[null,null,null,null,{"$f":"((5*F20)/10)","v":0}]
[]
[null,null,null,null,"Methylene Blue (mg/g)","Expected Performance"]
[null,null,null,null,"≤6","Excellent"]
[null,null,null,null,"7 − 12","Marginally Acceptable"]
[null,null,null,null,"13 − 19","Problems/possible failures"]
[null,null,null,null,"≥20","Failure"]
[]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2025-01-23T16:57:13.230"}]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX221"]
[null,"Test Method:","Tested By:",null,null,"Tested Date:"]
[null,"TX252"]
[null,"Test Stamp Code:",null,null,null,"Omit Test:","Completed Date:","Reviewed By:"]
[]
[null,"Locked By:",null,"TxDOT:","District:","Area:"]
[]
[null,"Authorized By:",null,null,null,"Authorized Date:"]

{"sheet":"RX","index":1,"n_rows":9,"n_cols":17,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[{"$f":"COUNTA(A3:A40)","v":7}]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF(field1=\"\",\"\",field1)","v":""},"Remarks:",null,null,null,null,null,null,null,null,null,null,null,null,"35- yes","light blue"]
[2,{"$f":"IF(Field7=\"\",\"\",Field7)","v":""},"Tested By:","TX252",null,null,null,null,null,null,null,null,null,null,null,"36- yes","yellow"]
[3,{"$f":"IF(Field8=\"\",\"\",Field8)","v":""},"Tested Date:","TX252",null,null,null,null,null,null,null,null,null,null,null,"37- no","dark blue"]
[4,{"$f":"IF(Field6=\"\",\"\",Field6)","v":""},"MTD-GSA Test Results",{"$f":"'MTD-GSA Test Results'!E19","v":"Tex-252-F: Methylene Blue Value"},{"$f":"'MTD-GSA Test Results'!E20","v":"Volume Used:"},{"$f":"'MTD-GSA Test Results'!G20","v":"ml"},null,null,null,null,null,null,null,null,null,"38- no","red"]
[5,{"$f":"IF('MTD-GSA Test Results'!E22=\"\",\"\",'MTD-GSA Test Results'!E22)","v":0},"MTD-GSA Test Results",{"$f":"'MTD-GSA Test Results'!E19","v":"Tex-252-F: Methylene Blue Value"},{"$f":"'MTD-GSA Test Results'!E21","v":"MBV (mg/g)"}]
[6,{"$f":"IF(Field9=\"\",\"\",Field9)","v":""},"Sampled By:","TX221"]
[7,{"$f":"IF(Field10=\"\",\"\",Field10)","v":""},"Sampled Date:","TX221"]