{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Tex-461-A","RX","Revisions","Grades"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":68,"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-461-A","index":0,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,1],[12,7,12,8],[11,3,11,4],[12,3,12,4],[7,7,7,8],[10,7,10,8],[7,3,7,4],[8,3,8,4],[8,7,8,8],[10,3,10,4],[11,7,11,8],[9,7,9,8],[9,3,9,4],[48,1,48,3],[44,6,44,8],[34,1,35,8],[42,2,42,4],[44,1,44,3],[37,1,37,8],[41,2,41,4],[36,1,36,8],[39,2,39,4],[40,2,40,4],[29,3,29,4],[22,3,22,4],[25,3,25,4],[26,3,26,4],[23,3,23,4],[24,3,24,4],[27,3,27,4],[14,3,14,8],[20,3,20,4],[13,3,13,4],[15,3,15,8],[13,7,13,8],[16,7,16,8],[16,3,16,4]]}
["TxDOT Manuals >",null,null,"Tex-461-A"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,"tx461.xlsm::45503.689884"]
[null,"DEGRADATION OF COARSE AGGREGATE BY MICRO-DEVAL ABRASION "]
[null,"Tex-461-A "]
[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: 07/30/24 16:33:26"}]
[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,null,"Material Type:"]
[]
[null,null,null,"Machine No."]
[null,null,null,"Tier No."]
[null,null,null,"Total No. of  Revolutions:"]
[null,null,null,"Average RPM:",null,{"$f":"IF(F25=\"\",\"\",IF(version=1,IF(type=\"concrete\",F25/120,F25/105),IF(LEN(Grade)=0,\"No Grade?\",F25/VLOOKUP(Grade,revolutions,2,FALSE))))","v":""},{"$f":"IF(SpecYear>=\"2004\",\"100 ± 5 Required\",\"100 ± 5 Required\")","v":"100 ± 5 Required"}]
[null,null,null,"Initial Weight:"]
[null,null,null,"Final Weight:"]
[]
[null,null,null,"Percent Loss (%):",null,{"$f":"IF(ISERROR((1-(F28/F27))*100),\"\",(1-(F28/F27))*100)","v":""}]
[]
[]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2024-07-30T16:33:26.160"}]
[]
[]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX400"]
[null,"Test Method:","Tested By:",null,null,"Tested Date:"]
[null,"TX461"]
[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:"]
[null,null,null,null,null,{"$f":"+IF(OR(AuthorizedDate>=42054,AuthorizedDate=0),2,1)","v":2}]

{"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-461-A'!$B$35=\"\",\"\",'Tex-461-A'!$B$35)","v":""},{"$f":"'Tex-461-A'!$B$34","v":"Remarks:"}]
[2,{"$f":"IF('Tex-461-A'!$D$19=\"\",\"\",'Tex-461-A'!$D$19)","v":""},{"$f":"IF('Tex-461-A'!$C$19=\"\",\"\",'Tex-461-A'!$C$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('Tex-461-A'!$C$43=\"\",\"\",'Tex-461-A'!$C$43)","v":""},"Tested By ",{"$f":"IF('Tex-461-A'!$B$43=\"\",\"\",'Tex-461-A'!$B$43)","v":"TX461"}]
[4,{"$f":"IF('Tex-461-A'!$F$43=\"\",\"\",'Tex-461-A'!$F$43)","v":""},"Tested Date ",{"$f":"IF('Tex-461-A'!$B$43=\"\",\"\",'Tex-461-A'!$B$43)","v":"TX461"}]
[5,{"$f":"IF('Tex-461-A'!$F$21=\"\",\"\",'Tex-461-A'!$F$21)","v":""},{"$f":"IF('Tex-461-A'!$B$6=\"\",\"\",'Tex-461-A'!$B$6)","v":"Tex-461-A "},{"$f":"IF('Tex-461-A'!$D$21=\"\",\"\",'Tex-461-A'!$D$21)","v":"Material Type:"}]
[6,{"$f":"IF('Tex-461-A'!$F$23=\"\",\"\",'Tex-461-A'!$F$23)","v":""},{"$f":"IF('Tex-461-A'!$B$6=\"\",\"\",'Tex-461-A'!$B$6)","v":"Tex-461-A "},{"$f":"IF('Tex-461-A'!$D$23=\"\",\"\",'Tex-461-A'!$D$23)","v":"Machine No."}]
[7,{"$f":"IF('Tex-461-A'!$F$24=\"\",\"\",'Tex-461-A'!$F$24)","v":""},{"$f":"IF('Tex-461-A'!$B$6=\"\",\"\",'Tex-461-A'!$B$6)","v":"Tex-461-A "},{"$f":"IF('Tex-461-A'!$D$24=\"\",\"\",'Tex-461-A'!$D$24)","v":"Tier No."}]
[8,{"$f":"IF('Tex-461-A'!$F$25=\"\",\"\",'Tex-461-A'!$F$25)","v":""},{"$f":"IF('Tex-461-A'!$B$6=\"\",\"\",'Tex-461-A'!$B$6)","v":"Tex-461-A "},{"$f":"IF('Tex-461-A'!$D$25=\"\",\"\",'Tex-461-A'!$D$25)","v":"Total No. of  Revolutions:"}]
[9,{"$f":"IF('Tex-461-A'!$F$26=\"\",\"\",'Tex-461-A'!$F$26)","v":""},{"$f":"IF('Tex-461-A'!$B$6=\"\",\"\",'Tex-461-A'!$B$6)","v":"Tex-461-A "},{"$f":"IF('Tex-461-A'!$D$26=\"\",\"\",'Tex-461-A'!$D$26)","v":"Average RPM:"}]
[10,{"$f":"IF('Tex-461-A'!$F$27=\"\",\"\",'Tex-461-A'!$F$27)","v":""},{"$f":"IF('Tex-461-A'!$B$6=\"\",\"\",'Tex-461-A'!$B$6)","v":"Tex-461-A "},{"$f":"IF('Tex-461-A'!$D$27=\"\",\"\",'Tex-461-A'!$D$27)","v":"Initial Weight:"}]
[11,{"$f":"IF('Tex-461-A'!$F$28=\"\",\"\",'Tex-461-A'!$F$28)","v":""},{"$f":"IF('Tex-461-A'!$B$6=\"\",\"\",'Tex-461-A'!$B$6)","v":"Tex-461-A "},{"$f":"IF('Tex-461-A'!$D$28=\"\",\"\",'Tex-461-A'!$D$28)","v":"Final Weight:"}]
[12,{"$f":"IF('Tex-461-A'!$F$30=\"\",\"\",'Tex-461-A'!$F$30)","v":""},{"$f":"IF('Tex-461-A'!$B$6=\"\",\"\",'Tex-461-A'!$B$6)","v":"Tex-461-A "},{"$f":"IF('Tex-461-A'!$D$30=\"\",\"\",'Tex-461-A'!$D$30)","v":"Percent Loss (%):"}]
[13]
[14]
[15]
[16,{"$f":"IF('Tex-461-A'!$C$41=\"\",\"\",'Tex-461-A'!$C$41)","v":""},"Sampled By ",{"$f":"IF('Tex-461-A'!$B$41=\"\",\"\",'Tex-461-A'!$B$41)","v":"TX400"}]
[17,{"$f":"IF('Tex-461-A'!$F$41=\"\",\"\",'Tex-461-A'!$F$41)","v":""},"Sampled Date ",{"$f":"IF('Tex-461-A'!$B$41=\"\",\"\",'Tex-461-A'!$B$41)","v":"TX400"}]

{"sheet":"Revisions","index":2,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Date","Changes","By"]
["2005-05-11","Add \"2004\" to SpecYear (Validation)","Joe Liu"]
["2005-05-12","Cell G25 change from [100 ± 2 Required]to [=IF(SpecYear=\"2004\",\"100 ± 5 Required\",\"100 ± 2 Required\")]","Joe Liu"]
["2013-08-07","Added the grades and grade revolutions chart.","Stewart"]

{"sheet":"Grades","index":3,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[null,"A",120]
[null,"B",105]
[null,"C",95]
[null,"Fine Aggregate",15]