{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Tex-101-E","RX","GRADATIONS","spcyr"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":99,"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-101-E","index":0,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[16,3,16,4],[9,3,9,4],[10,7,10,8],[11,7,11,8],[35,1,35,8],[16,7,16,8],[14,3,14,8],[23,5,25,5],[0,0,0,1],[8,3,8,4],[7,3,7,4],[11,3,11,4],[7,7,7,8],[10,3,10,4],[9,7,9,8],[8,7,8,8],[42,2,42,4],[15,3,15,8],[12,3,12,4],[13,3,13,4],[13,7,13,8],[12,7,12,8],[33,1,34,8],[38,2,38,4],[23,1,25,1],[23,3,25,3],[23,4,25,4],[36,1,36,8],[23,6,25,6],[23,7,25,7],[37,2,37,4],[40,2,40,4],[47,1,47,3],[47,6,47,8],[51,1,51,3],[45,2,45,4],[43,2,43,4]]}
["TxDOT Manuals >",null,null,"Tex-101-E"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,"tx101p3.xlsm::45504.352465"]
[null,"SIEVE ANALYSIS OF ROAD-MIX STABILIZED MATERIAL"]
[null,"Tex-101-E, Part III"]
[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/31/24 08:27:33"}]
[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 / MATERIAL TYPE:",null,null,null," "]
[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,"Particle Size Analysis - Tex-101, Part III"]
[]
[null,"Sieve Size","Individual",{"$f":"IF(C24=\"Cumulative\",\"Individual\",\"Cumulative\") & \" Weight Retained\"","v":"Cumulative Weight Retained"},"Cumulative Percent Retained","Cummulative Percent Passing","Minimum Percent Passing (Cumulative) Required","Above or At Minimum Specified"]
[null,null,{"$f":"RetainedMethod &\" Weight Retained \" & Field8","v":"Individual Weight Retained "}]
[]
[null,{"$f":"IF(ISERROR(INDEX(INDIRECT(MType),1,2)),\"\",INDEX(INDIRECT(MType),1,2))","v":""},null,{"$f":"IF($C27=\"\",\"\",$C27)","v":""},{"$f":"IF($C27=\"\",\"\",IF(RetainedMethod=\"Cumulative\",C27/Total*100,D27/Total*100))","v":""},{"$f":"IF(ISERROR(100-$E27),\"\",100-$E27)","v":""},{"$f":"IF(ISERROR(INDEX(INDIRECT(MType),1,3)),\"\",INDEX(INDIRECT(MType),1,3))","v":""},{"$f":"IF($E27=\"\",\"\",IF($F27>=$G27,\"Yes\",\"No\"))","v":""}]
[null,{"$f":"IF(ISERROR(INDEX(INDIRECT(MType),2,2)),\"\",INDEX(INDIRECT(MType),2,2))","v":""},null,{"$f":"IF(C28=\"\",\"\",IF(RetainedMethod=\"Cumulative\",($C28-$C26),SUM($C$27:$C28)))","v":""},{"$f":"IF($C28=\"\",\"\",IF(RetainedMethod=\"Cumulative\",C28/Total*100,D28/Total*100))","v":""},{"$f":"IF(ISERROR(100-$E28),\"\",100-$E28)","v":""},{"$f":"IF(ISERROR(INDEX(INDIRECT(MType),2,3)),\"\",INDEX(INDIRECT(MType),2,3))","v":""},{"$f":"IF($E28=\"\",\"\",IF($F28>=$G28,\"Yes\",\"No\"))","v":""}]
[null,{"$f":"IF(ISERROR(INDEX(INDIRECT(MType),3,2)),\"\",INDEX(INDIRECT(MType),3,2))","v":""},null,{"$f":"IF(C29=\"\",\"\",IF(RetainedMethod=\"Cumulative\",($C29-$C27),SUM($C$27:$C29)))","v":""},{"$f":"IF($C29=\"\",\"\",IF(RetainedMethod=\"Cumulative\",C29/Total*100,D29/Total*100))","v":""},{"$f":"IF(ISERROR(100-$E29),\"\",100-$E29)","v":""},{"$f":"IF(ISERROR(INDEX(INDIRECT(MType),3,3)),\"\",INDEX(INDIRECT(MType),3,3))","v":""},{"$f":"IF($E29=\"\",\"\",IF($F29>=$G29,\"Yes\",\"No\"))","v":""}]
[null,{"$f":"IF(RetainedMethod=\"cumulative\",\"Total:\",\"-\" & OFFSET(B30,-(COUNTBLANK(SieveSize)+1),0))","v":"-"},{"$f":"IF(SUM(C27:C29)=0,\"\",Total-Field9-Field10-Field11)","v":""}]
[null,"Total:"]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2024-07-31T08:27:33.240"}]
[]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX100"]
[]
[null,"TX400"]
[]
[null,"Test Method:","Tested By:",null,null,"Tested Date:"]
[null,"TX101"]
[]
[null,"TX101P3"]
[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":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[30]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF('Tex-101-E'!$B$34=\"\",\"\",'Tex-101-E'!$B$34)","v":""},{"$f":"'Tex-101-E'!$B$33","v":"Remarks:"}]
[2,{"$f":"IF('Tex-101-E'!$D$19=\"\",\"\",'Tex-101-E'!$D$19)","v":""},{"$f":"IF('Tex-101-E'!$C$19=\"\",\"\",'Tex-101-E'!$C$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('Tex-101-E'!$C$44=\"\",\"\",'Tex-101-E'!$C$44)","v":""},"Tested By ",{"$f":"IF('Tex-101-E'!$B$44=\"\",\"\",'Tex-101-E'!$B$44)","v":"TX101"}]
[4,{"$f":"IF('Tex-101-E'!$F$44=\"\",\"\",'Tex-101-E'!$F$44)","v":""},"Tested Date ",{"$f":"IF('Tex-101-E'!$B$44=\"\",\"\",'Tex-101-E'!$B$44)","v":"TX101"}]
[5,{"$f":"IF('Tex-101-E'!$C$27=\"\",\"\",'Tex-101-E'!$C$27)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$C$25=\"\",\"\",'Tex-101-E'!$C$25)","v":"Individual Weight Retained "},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$27=\"\",\"\",'Tex-101-E'!$B$27)","v":""}]
[6,{"$f":"IF('Tex-101-E'!$D$27=\"\",\"\",'Tex-101-E'!$D$27)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$D$24=\"\",\"\",'Tex-101-E'!$D$24)","v":"Cumulative Weight Retained"},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$27=\"\",\"\",'Tex-101-E'!$B$27)","v":""}]
[7,{"$f":"IF('Tex-101-E'!$E$27=\"\",\"\",'Tex-101-E'!$E$27)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$E$24=\"\",\"\",'Tex-101-E'!$E$24)","v":"Cumulative Percent Retained"},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$27=\"\",\"\",'Tex-101-E'!$B$27)","v":""}]
[8,{"$f":"IF('Tex-101-E'!$F$27=\"\",\"\",'Tex-101-E'!$F$27)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$F$24=\"\",\"\",'Tex-101-E'!$F$24)","v":"Cummulative Percent Passing"},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$27=\"\",\"\",'Tex-101-E'!$B$27)","v":""}]
[9,{"$f":"IF('Tex-101-E'!$G$27=\"\",\"\",'Tex-101-E'!$G$27)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$G$24=\"\",\"\",'Tex-101-E'!$G$24)","v":"Minimum Percent Passing (Cumulative) Required"},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$27=\"\",\"\",'Tex-101-E'!$B$27)","v":""}]
[10,{"$f":"IF('Tex-101-E'!$H$27=\"\",\"\",'Tex-101-E'!$H$27)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$H$24=\"\",\"\",'Tex-101-E'!$H$24)","v":"Above or At Minimum Specified"},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$27=\"\",\"\",'Tex-101-E'!$B$27)","v":""}]
[11,{"$f":"IF('Tex-101-E'!$C$28=\"\",\"\",'Tex-101-E'!$C$28)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$C$25=\"\",\"\",'Tex-101-E'!$C$25)","v":"Individual Weight Retained "},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$28=\"\",\"\",'Tex-101-E'!$B$28)","v":""}]
[12,{"$f":"IF('Tex-101-E'!$D$28=\"\",\"\",'Tex-101-E'!$D$28)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$D$24=\"\",\"\",'Tex-101-E'!$D$24)","v":"Cumulative Weight Retained"},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$28=\"\",\"\",'Tex-101-E'!$B$28)","v":""}]
[13,{"$f":"IF('Tex-101-E'!$E$28=\"\",\"\",'Tex-101-E'!$E$28)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$E$24=\"\",\"\",'Tex-101-E'!$E$24)","v":"Cumulative Percent Retained"},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$28=\"\",\"\",'Tex-101-E'!$B$28)","v":""}]
[14,{"$f":"IF('Tex-101-E'!$F$28=\"\",\"\",'Tex-101-E'!$F$28)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$F$24=\"\",\"\",'Tex-101-E'!$F$24)","v":"Cummulative Percent Passing"},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$28=\"\",\"\",'Tex-101-E'!$B$28)","v":""}]
[15,{"$f":"IF('Tex-101-E'!$G$28=\"\",\"\",'Tex-101-E'!$G$28)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$G$24=\"\",\"\",'Tex-101-E'!$G$24)","v":"Minimum Percent Passing (Cumulative) Required"},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$28=\"\",\"\",'Tex-101-E'!$B$28)","v":""}]
[16,{"$f":"IF('Tex-101-E'!$H$28=\"\",\"\",'Tex-101-E'!$H$28)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$H$24=\"\",\"\",'Tex-101-E'!$H$24)","v":"Above or At Minimum Specified"},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$28=\"\",\"\",'Tex-101-E'!$B$28)","v":""}]
[17,{"$f":"IF('Tex-101-E'!$C$29=\"\",\"\",'Tex-101-E'!$C$29)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$C$25=\"\",\"\",'Tex-101-E'!$C$25)","v":"Individual Weight Retained "},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$29=\"\",\"\",'Tex-101-E'!$B$29)","v":""}]
[18,{"$f":"IF('Tex-101-E'!$D$29=\"\",\"\",'Tex-101-E'!$D$29)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$D$24=\"\",\"\",'Tex-101-E'!$D$24)","v":"Cumulative Weight Retained"},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$29=\"\",\"\",'Tex-101-E'!$B$29)","v":""}]
[19,{"$f":"IF('Tex-101-E'!$E$29=\"\",\"\",'Tex-101-E'!$E$29)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$E$24=\"\",\"\",'Tex-101-E'!$E$24)","v":"Cumulative Percent Retained"},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$29=\"\",\"\",'Tex-101-E'!$B$29)","v":""}]
[20,{"$f":"IF('Tex-101-E'!$F$29=\"\",\"\",'Tex-101-E'!$F$29)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$F$24=\"\",\"\",'Tex-101-E'!$F$24)","v":"Cummulative Percent Passing"},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$29=\"\",\"\",'Tex-101-E'!$B$29)","v":""}]
[21,{"$f":"IF('Tex-101-E'!$G$29=\"\",\"\",'Tex-101-E'!$G$29)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$G$24=\"\",\"\",'Tex-101-E'!$G$24)","v":"Minimum Percent Passing (Cumulative) Required"},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$29=\"\",\"\",'Tex-101-E'!$B$29)","v":""}]
[22,{"$f":"IF('Tex-101-E'!$H$29=\"\",\"\",'Tex-101-E'!$H$29)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$H$24=\"\",\"\",'Tex-101-E'!$H$24)","v":"Above or At Minimum Specified"},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$29=\"\",\"\",'Tex-101-E'!$B$29)","v":""}]
[23,{"$f":"IF('Tex-101-E'!$C$30=\"\",\"\",'Tex-101-E'!$C$30)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$C$25=\"\",\"\",'Tex-101-E'!$C$25)","v":"Individual Weight Retained "},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$30=\"\",\"\",'Tex-101-E'!$B$30)","v":"-"}]
[24,{"$f":"IF('Tex-101-E'!$C$31=\"\",\"\",'Tex-101-E'!$C$31)","v":""},{"$f":"IF('Tex-101-E'!$B$6=\"\",\"\",'Tex-101-E'!$B$6)","v":"Tex-101-E, Part III"},{"$f":"IF('Tex-101-E'!$C$25=\"\",\"\",'Tex-101-E'!$C$25)","v":"Individual Weight Retained "},{"$f":"IF('Tex-101-E'!$B$24=\"\",\"\",'Tex-101-E'!$B$24)","v":"Sieve Size"},{"$f":"IF('Tex-101-E'!$B$31=\"\",\"\",'Tex-101-E'!$B$31)","v":"Total:"}]
[25,{"$f":"IF('Tex-101-E'!$C$46=\"\",\"\",'Tex-101-E'!$C$46)","v":""},"Tested By ",{"$f":"IF('Tex-101-E'!$B$46=\"\",\"\",'Tex-101-E'!$B$46)","v":"TX101P3"}]
[26,{"$f":"IF('Tex-101-E'!$F$46=\"\",\"\",'Tex-101-E'!$F$46)","v":""},"Tested Date ",{"$f":"IF('Tex-101-E'!$B$46=\"\",\"\",'Tex-101-E'!$B$46)","v":"TX101P3"}]
[27,{"$f":"IF('Tex-101-E'!$C$39=\"\",\"\",'Tex-101-E'!$C$39)","v":""},"Sampled By",{"$f":"IF('Tex-101-E'!$B$39=\"\",\"\",'Tex-101-E'!$B$39)","v":"TX100"}]
[28,{"$f":"IF('Tex-101-E'!$F$39=\"\",\"\",'Tex-101-E'!$F$39)","v":""},"Sampled Date",{"$f":"IF('Tex-101-E'!$B$39=\"\",\"\",'Tex-101-E'!$B$39)","v":"TX100"}]
[29,{"$f":"IF('Tex-101-E'!$C$41=\"\",\"\",'Tex-101-E'!$C$41)","v":""},"Sampled By",{"$f":"IF('Tex-101-E'!$B$41=\"\",\"\",'Tex-101-E'!$B$41)","v":"TX400"}]
[30,{"$f":"IF('Tex-101-E'!$F$41=\"\",\"\",'Tex-101-E'!$F$41)","v":""},"Sampled Date",{"$f":"IF('Tex-101-E'!$B$41=\"\",\"\",'Tex-101-E'!$B$41)","v":"TX400"}]

{"sheet":"GRADATIONS","index":2,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":true,"merged":[[1,0,3,0],[4,0,5,0]]}
["Grade","\"2004\" Sieve Size","Minimum % Passing",null,"size","Cumulative Percent Retained","Cumulative Percent Passing"]
["SUBGRADE","1-3/4\"",100,null,{"$f":"IF(ISERROR(INDEX(INDIRECT(\"grade\"&Grade&SpecYear),1,2)),\"\",INDEX(INDIRECT(\"grade\"&Grade&SpecYear),1,2))","v":""},{"$f":"'Tex-101-E'!E27","v":""},{"$f":"IF(F2=\"\",\"\",100-F2)","v":""}]
[null,"3/4\"",85,null,{"$f":"IF(ISERROR(INDEX(INDIRECT(\"grade\"&Grade&SpecYear),2,2)),\"\",INDEX(INDIRECT(\"grade\"&Grade&SpecYear),2,2))","v":""},{"$f":"'Tex-101-E'!E29","v":""},{"$f":"IF(F3=\"\",\"\",100-F3)","v":""}]
[null,"No. 4",60,null,{"$f":"IF(ISERROR(INDEX(INDIRECT(\"grade\"&Grade&SpecYear),4,2)),\"\",INDEX(INDIRECT(\"grade\"&Grade&SpecYear),4,2))","v":""},{"$f":"'Tex-101-E'!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(F4=\"\",\"\",100-F4)","v":{"$error":"#REF!"}}]
["BASE","1-3/4\"",100,null,{"$f":"IF(ISERROR(INDEX(INDIRECT(\"grade\"&Grade&SpecYear),6,2)),\"\",INDEX(INDIRECT(\"grade\"&Grade&SpecYear),6,2))","v":""},{"$f":"'Tex-101-E'!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(F5=\"\",\"\",100-F5)","v":{"$error":"#REF!"}}]
[null,"3/4\"",85,null,{"$f":"IF(ISERROR(INDEX(INDIRECT(\"grade\"&Grade&SpecYear),7,2)),\"\",INDEX(INDIRECT(\"grade\"&Grade&SpecYear),7,2))","v":""},{"$f":"'Tex-101-E'!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(F6=\"\",\"\",100-F6)","v":{"$error":"#REF!"}}]
[]
[]
[]
["Size","English","Metric","Selection"]
[152,"6\"","152 mm",{"$f":"IF(SpecYear=\"\",\"\",IF(SpecYear=\"1995\",C11,B11))","v":""}]
[76,"3\"","76 mm",""]
[63,"2-1/2\"","63 mm",""]
[50,"2\"","50 mm",""]
[45,"1-3/4\"","45 mm",""]
[37.5,"1-1/2\"","37.5 mm",""]
[31.5,"1-1/4\"","31.5 mm",""]
[25,"1\"","25 mm",""]
[22.4,"7/8\"","22.4 mm",""]
[19,"3/4\"","19 mm",""]
[16,"5/8\"","16 mm",""]
[12.5,"1/2\"","12.5 mm",""]
[11.2,"7/16\"","11.2 mm",""]
[9.5,"3/8\"","9.5 mm",""]
[8,"5/16\"","8 mm",""]
[6.3,"1/4\"","6.3 mm",""]
[4.75,"No. 4","4.75 mm",""]
[3.35,"No. 6","3.35 mm",""]
[2.36,"No. 8","2.36 mm",""]
[2,"No. 10","2 mm",""]
[1.4,"No. 14","1.4 mm",""]
[1.18,"No. 16","1.18 mm",""]
[0.85,"No. 20",".85 µm",""]
[0.6,"No. 30",".6 µm",""]
[0.42499999999999999,"No. 40",".425 µm",""]
[0.3,"No. 50",".3 µm",""]
[0.18,"No. 80",".18 µm",""]
[0.15,"No. 100",".15 µm",""]
[7.4999999999999997E-2,"No. 200",".075 µm",""]

{"sheet":"spcyr","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["spec1993","spec1995","spec2004"]
["1","1","1"]
["2","2","2"]
[3,3,3]
[4,4,"Shown_On_Plans"]
[5,5]
["Shown_On_Plans","Shown_On_Plans"]