{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Tex-116-E","RX","Revisions","Sieve"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":123,"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-116-E","index":0,"n_rows":67,"n_cols":11,"rows_kept":67,"cut":false,"hidden":false,"merged":[[54,2,54,4],[12,7,12,8],[20,5,20,6],[10,3,10,4],[9,7,9,8],[11,3,11,4],[12,3,12,4],[13,3,13,4],[13,7,13,8],[20,7,20,8],[14,3,14,8],[0,0,0,1],[21,1,22,1],[8,3,8,4],[9,3,9,4],[15,3,15,8],[20,1,20,4],[16,3,16,4],[16,7,16,8],[21,8,23,8],[21,3,22,3],[7,3,7,4],[7,7,7,8],[10,7,10,8],[11,7,11,8],[8,7,8,8],[21,4,22,4],[66,1,66,3],[37,4,38,4],[62,6,62,8],[56,2,56,4],[47,1,48,8],[37,2,38,2],[37,3,38,3],[44,3,44,5],[42,6,42,7],[50,1,50,8],[62,1,62,3],[55,2,55,4],[58,2,58,4],[60,2,60,4],[51,2,51,4],[52,2,52,4],[21,6,23,6],[49,1,49,8],[33,6,33,8],[33,2,33,4],[42,2,42,3],[37,7,38,7],[21,7,23,7],[37,6,38,6],[37,8,38,8],[21,5,23,5]]}
["TxDOT Manuals >",null,null,"Tex-116-E"]
[null,"TEXAS DEPARTMENT OF TRANSPORTATION",null,null,null,null,null,null,null,null,51]
[null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,"tx116.xlsm::45462.695"]
[null,"RESISTANCE TO DEGRADATION BY WET BALL MILL METHOD"]
[null,"Tex-116-E - Part I and II"]
[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-116-E - Part I and II - File Version: 06/19/24 16:40: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,"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,"Original Dry Screen Gradation",null,null,null,"Part I: 3500g Preparation",null,"Part II: 3000g Preparation"]
[null,"Sieve Size",null,"Individual Percent Retained","Cumulative Percent Retained","Individual Weight Retained (g)","Cumulative Weight Retained (g)","Individual Weight Retained (g)","Cumulative Weight Retained (g)"]
[null,null,{"$f":"IF(Field7=\"\",\"Individual\",Field7) & \" Weight Retained (g)\"","v":"Individual Weight Retained (g)"}]
[null,{"$f":"IF(SpecYear=\"\",\"\",IF(Field22=\"\",IF(SpecYear=\"1995\",Sieve!B2,Sieve!A2),IF(SpecYear=\"1995\",Sieve!D12,Sieve!C12)))","v":""},null,{"$f":"IF(ISERROR($C24/RetainedTotal*100),\"\",$C24/RetainedTotal*100)","v":""},{"$f":"IF(ISERROR(C24/RetainedTotal*100),\"\",C24/RetainedTotal*100)","v":""}]
[null,{"$f":"IF(SpecYear=\"\",\"\",IF(Field22=\"\",IF(SpecYear=\"1995\",Sieve!B3,Sieve!A3),IF(Field25=0,\"\",IF(SpecYear=\"1995\",Sieve!D13,Sieve!C13))))","v":""},null,{"$f":"IF(ISERROR(IF(RetainedMethod=\"cumulative\",C25-C24,$C25)/RetainedTotal*100),\"\",IF(RetainedMethod=\"cumulative\",C25-C24,$C25)/RetainedTotal*100)","v":""},{"$f":"IF(ISERROR(IF(RetainedMethod=\"cumulative\",C25,SUM($C$24:C25))/RetainedTotal*100),\"\",IF(RetainedMethod=\"cumulative\",C25,SUM($C$24:C25))/RetainedTotal*100)","v":""},{"$f":"IF(ISERROR(IF(RetainedMethod=\"cumulative\",$C25,$C25+$C24)/RetainedTotal*3500),\"\",IF(RetainedMethod=\"cumulative\",$C25,$C25+$C24)/RetainedTotal*3500)","v":""},{"$f":"IF(F25=\"\",\"\",SUM(F$24:F25))","v":""},{"$f":"IF(ISERROR(IF(RetainedMethod=\"Cumulative\",$C25,$C24+$C25)/RetainedTotal),\"\",IF(RetainedMethod=\"Cumulative\",$C25,$C24+$C25)/RetainedTotal*3000)","v":""},{"$f":"IF(H25=\"\",\"\",SUM(H$24:H25))","v":""}]
[null,{"$f":"IF(SpecYear=\"\",\"\",IF(Field22=\"\",IF(SpecYear=\"1995\",Sieve!B4,Sieve!A4),IF(Field28=0,\"\",IF(SpecYear=\"1995\",Sieve!D14,Sieve!C14))))","v":""},null,{"$f":"IF(ISERROR(IF(RetainedMethod=\"cumulative\",C26-C25,$C26)/RetainedTotal*100),\"\",IF(RetainedMethod=\"cumulative\",C26-C25,$C26)/RetainedTotal*100)","v":""},{"$f":"IF(ISERROR(IF(RetainedMethod=\"cumulative\",C26,SUM($C$24:C26))/RetainedTotal*100),\"\",IF(RetainedMethod=\"cumulative\",C26,SUM($C$24:C26))/RetainedTotal*100)","v":""},{"$f":"IF(ISERROR(IF(RetainedMethod=\"cumulative\",$C26-$C25,$C26)/RetainedTotal),\"\",IF(RetainedMethod=\"cumulative\",$C26-$C25,$C26)/RetainedTotal*3500)","v":""},{"$f":"IF(F26=\"\",\"\",SUM(F$24:F26))","v":""},{"$f":"IF(ISERROR(IF(RetainedMethod=\"Cumulative\",$C26-$C25,$C26)/RetainedTotal),\"\",IF(RetainedMethod=\"Cumulative\",$C26-$C25,$C26)/RetainedTotal*3000)","v":""},{"$f":"IF(H26=\"\",\"\",SUM(H$24:H26))","v":""}]
[null,{"$f":"IF(SpecYear=\"\",\"\",IF(Field22=\"\",IF(SpecYear=\"1995\",Sieve!B5,Sieve!A5),IF(Field31=0,\"\",IF(SpecYear=\"1995\",Sieve!D15,Sieve!C15))))","v":""},null,{"$f":"IF(ISERROR(IF(RetainedMethod=\"cumulative\",C27-C26,$C27)/RetainedTotal*100),\"\",IF(RetainedMethod=\"cumulative\",C27-C26,$C27)/RetainedTotal*100)","v":""},{"$f":"IF(ISERROR(IF(RetainedMethod=\"cumulative\",C27,SUM($C$24:C27))/RetainedTotal*100),\"\",IF(RetainedMethod=\"cumulative\",C27,SUM($C$24:C27))/RetainedTotal*100)","v":""},{"$f":"IF(ISERROR(IF(RetainedMethod=\"cumulative\",$C27-$C26,$C27)/RetainedTotal),\"\",IF(RetainedMethod=\"cumulative\",$C27-$C26,$C27)/RetainedTotal*3500)","v":""},{"$f":"IF(F27=\"\",\"\",SUM(F$24:F27))","v":""},{"$f":"IF(ISERROR(IF(RetainedMethod=\"Cumulative\",$C27-$C26,$C27)/RetainedTotal),\"\",IF(RetainedMethod=\"Cumulative\",$C27-$C26,$C27)/RetainedTotal*3000)","v":""},{"$f":"IF(H27=\"\",\"\",SUM(H$24:H27))","v":""}]
[null,{"$f":"IF(SpecYear=\"\",\"\",IF(Field22=\"\",IF(SpecYear=\"1995\",Sieve!B6,Sieve!A6),IF(Field34=0,\"\",IF(SpecYear=\"1995\",Sieve!D16,Sieve!C16))))","v":""},null,{"$f":"IF(ISERROR(IF(RetainedMethod=\"cumulative\",C28-C27,$C28)/RetainedTotal*100),\"\",IF(RetainedMethod=\"cumulative\",C28-C27,$C28)/RetainedTotal*100)","v":""},{"$f":"IF(ISERROR(IF(RetainedMethod=\"cumulative\",C28,SUM($C$24:C28))/RetainedTotal*100),\"\",IF(RetainedMethod=\"cumulative\",C28,SUM($C$24:C28))/RetainedTotal*100)","v":""},{"$f":"IF(ISERROR(IF(RetainedMethod=\"cumulative\",$C28-$C27,$C28)/RetainedTotal),\"\",IF(RetainedMethod=\"cumulative\",$C28-$C27,$C28)/RetainedTotal*3500)","v":""},{"$f":"IF(F28=\"\",\"\",SUM(F$24:F28))","v":""},{"$f":"IF(ISERROR(IF(RetainedMethod=\"Cumulative\",$C28-$C27,$C28)/RetainedTotal),\"\",IF(RetainedMethod=\"Cumulative\",$C28-$C27,$C28)/RetainedTotal*3000)","v":""},{"$f":"IF(H28=\"\",\"\",SUM(H$24:H28))","v":""}]
[null,{"$f":"IF(SpecYear=\"\",\"\",IF(Field22=\"\",IF(SpecYear=\"1995\",Sieve!B7,Sieve!A7),IF(Field37=0,\"\",IF(SpecYear=\"1995\",Sieve!D17,Sieve!C17))))","v":""},null,{"$f":"IF(ISERROR(IF(RetainedMethod=\"cumulative\",C29-C28,$C29)/RetainedTotal*100),\"\",IF(RetainedMethod=\"cumulative\",C29-C28,$C29)/RetainedTotal*100)","v":""},{"$f":"IF(ISERROR(IF(RetainedMethod=\"cumulative\",C29,SUM($C$24:C29))/RetainedTotal*100),\"\",IF(RetainedMethod=\"cumulative\",C29,SUM($C$24:C29))/RetainedTotal*100)","v":""},{"$f":"IF(ISERROR(IF(RetainedMethod=\"cumulative\",$C29-$C28,$C29)/RetainedTotal),\"\",IF(RetainedMethod=\"cumulative\",$C29-$C28,$C29)/RetainedTotal*3500)","v":""},{"$f":"IF(F29=\"\",\"\",SUM(F$24:F29))","v":""},{"$f":"IF(ISERROR(IF(RetainedMethod=\"Cumulative\",$C29-$C28,$C29)/RetainedTotal),\"\",IF(RetainedMethod=\"Cumulative\",$C29-$C28,$C29)/RetainedTotal*3000)","v":""},{"$f":"IF(H29=\"\",\"\",SUM(H$24:H29))","v":""}]
[null,{"$f":"IF(version=4,IF(SpecYear=\"\",\"\",IF(Field22=\"\",IF(SpecYear=\"1995\",Sieve!B9,Sieve!A9),IF(field41=0,\"\",IF(SpecYear=\"1995\",Sieve!D18,Sieve!C18)))),IF(version=\"3\",IF(RetainedMethod=\"Cumulative\",\"Total:\",\"-\"&OFFSET(B30,-(COUNTBLANK(SieveSize2)+0),0)),IF(RetainedMethod=\"Cumulative\",\"Total:\",\"-\"&OFFSET(B31,-(COUNTBLANK(SieveSize)+2),0))))","v":""},null,{"$f":"IF(version=4,IF(ISERROR(IF(RetainedMethod=\"cumulative\",C30-C29,$C30)/RetainedTotal*100),\"\",IF(RetainedMethod=\"cumulative\",C30-C29,$C30)/RetainedTotal*100),IF(version<\"3\",\"\",IF(ISERROR(IF(RetainedMethod=\"cumulative\",C30-C29,$C30)/RetainedTotal*100),\"\",IF(RetainedMethod=\"cumulative\",C30-C29,$C30)/RetainedTotal*100)))","v":""},{"$f":"IF(version=4, IF(ISERROR(IF(RetainedMethod=\"cumulative\",C30,SUM($C$24:C30))/RetainedTotal*100),\"\",IF(RetainedMethod=\"cumulative\",C30,SUM($C$24:C30))/RetainedTotal*100),IF(version<\"3\",\"\",IF(ISERROR(IF(RetainedMethod=\"cumulative\",C30,SUM($C$24:C30))/RetainedTotal*100),\"\",IF(RetainedMethod=\"cumulative\",C30,SUM($C$24:C30))/RetainedTotal*100)))","v":""},{"$f":"IF(version=4,IF(ISERROR(IF(RetainedMethod=\"Cumulative\",$C30-$C29,$C30)/RetainedTotal),\"\",IF(RetainedMethod=\"Cumulative\",$C30-$C29,$C30)/RetainedTotal*3500),IF(version<\"3\",\"\",IF(ISERROR(IF(RetainedMethod=\"Cumulative\",$C30-$C28,$C30)/RetainedTotal),\"\",IF(RetainedMethod=\"Cumulative\",$C30-$C28,$C30)/RetainedTotal*3500)))","v":""},{"$f":"IF(version=4,IF(F30=\"\",\"\",SUM(F$24:F30)),IF(version<\"3\",\"\",IF(F30=\"\",\"\",SUM(F$24:F30))))","v":""},{"$f":"IF(version=4,IF(ISERROR(IF(RetainedMethod=\"Cumulative\",$C30-$C29,$C30)/RetainedTotal),\"\",IF(RetainedMethod=\"Cumulative\",$C30-$C29,$C30)/RetainedTotal*3000),IF(version<\"3\",\"\",IF(ISERROR(IF(RetainedMethod=\"Cumulative\",$C30-$C28,$C30)/RetainedTotal),\"\",IF(RetainedMethod=\"Cumulative\",$C30-$C28,$C30)/RetainedTotal*3000)))","v":""},{"$f":"IF(version=4,IF(H30=\"\",\"\",SUM(H$24:H30)),IF(version<\"3\",\"\",IF(H30=\"\",\"\",SUM(H$24:H30))))","v":""}]
[null,{"$f":"IF(version=\"3\",IF(RetainedMethod=\"Cumulative\",\"Total:\",\"-\"&OFFSET(B30,-(COUNTBLANK(SieveSize2)+0),0)),IF(RetainedMethod=\"Cumulative\",\"Total:\",\"-\"&OFFSET(B31,-(COUNTBLANK(SieveSize)+1),0)))","v":"-"},null,{"$f":"IF(version<\"3\",IF(ISERROR(IF(RetainedMethod=\"cumulative\",C31-C29,$C31)/RetainedTotal*100),\"\",IF(RetainedMethod=\"cumulative\",C31-C29,$C31)/RetainedTotal*100),IF(ISERROR(IF(RetainedMethod=\"cumulative\",C31-C30,$C31)/RetainedTotal*100),\"\",IF(RetainedMethod=\"cumulative\",C31-C30,$C31)/RetainedTotal*100))","v":""},null,{"$f":"IF(ISERROR(IF(RetainedMethod=\"Cumulative\",IF(version=4,$C31-$C30,$C31-$C29),$C31)/RetainedTotal),\"\",IF(RetainedMethod=\"Cumulative\",IF(version=4,$C31-$C30,$C31-$C29),$C31)/RetainedTotal*3500)","v":""},{"$f":"IF(F31=\"\",\"\",SUM(F$24:F31))","v":""},{"$f":"IF(ISERROR(IF(RetainedMethod=\"Cumulative\",IF(version=4,$C31-$C30,$C31-$C29),$C31)/RetainedTotal),\"\",IF(RetainedMethod=\"Cumulative\",IF(version=4,$C31-$C30,$C31-$C29),$C31)/RetainedTotal*3000)","v":""},{"$f":"IF(H31=\"\",\"\",SUM(H$24:H31))","v":""}]
[null,"Total:",{"$f":"IF(COUNTBLANK(C24:C31)=7,\"\",IF(RetainedMethod=\"Cumulative\",Pan,SUM(C24:C31)))","v":0},null,null,{"$f":"IF(COUNTBLANK(C24:C31)=7,\"\",SUM(F25:F31))","v":0},null,{"$f":"IF(COUNTBLANK(C24:C31)=7,\"\",SUM(H24:H31))","v":0}]
[]
[null,null,"Part I: Wet Ball Mill",null,null,null,"Part II: Washed Sieve Analysis"]
[]
[null,null,"Initial Weight",null,null,null,"Initial Weight"]
[]
[null,null,"Sieve Size","Weight Retained (g)","Individual Percent Retained",null,"Sieve Size","Weight Retained (g)","Individual Percent Retained"]
[]
[null,null,{"$f":"IF(SpecYear=\"\",\"\",IF(SpecYear=\"1995\",\"425µm\",\"No.40\"))","v":""},null,{"$f":"IF(ISERROR($D$40/RetainedTotal3*100),\"\",$D$40/RetainedTotal3*100)","v":""},null,{"$f":"IF(SpecYear=\"\",\"\",IF(SpecYear=\"1995\",\"425µm\",\"No.40\"))","v":""},null,{"$f":"IF(ISERROR($H$40/Retainedtotal2*100),\"\",$H$40/Retainedtotal2*100)","v":""}]
[null,null,{"$f":"\"- \" &C40","v":"- "},{"$f":"IF(D40=\"\",\"\",RetainedTotal3-$D$40)","v":""},{"$f":"IF(ISERROR(_Pan3/RetainedTotal3*100),\"\",_Pan3/RetainedTotal3*100)","v":""},null,{"$f":"\"- \" &G40","v":"- "},{"$f":"IF(H40=\"\",\"\",Retainedtotal2-$H$40)","v":""},{"$f":"IF(ISERROR(_Pan2/Retainedtotal2*100),\"\",_Pan2/Retainedtotal2*100)","v":""}]
[]
[null,null,"Wet Ball Mill Value, %:",null,{"$f":"IF(ISERROR((_Pan3/RetainedTotal3)),\"\",(_Pan3/RetainedTotal3)*100)","v":""},null,"Percent Soil Binder, %:",null,{"$f":"IF(ISERROR((_Pan2/Retainedtotal2)),\"\",(_Pan2/Retainedtotal2)*100)","v":""}]
[]
[null,null,null,"% Soil Binder Increase:",null,null,{"$f":"IF(ISERROR(E43-I43),\"\",E43-I43)","v":""}]
[]
[null,"Remarks:",{"$f":"NOW()","v":"2024-06-19T16:40:48.520"}]
[]
[]
[]
[]
[null,"Sample Method:","Sampled By:",null,null,"Sampled Date:"]
[null,"TX100"]
[]
[null,"TX400"]
[null,"Test Method:","Tested By:",null,null,"Tested Date:"]
[null,"TX116"]
[]
[null,"TX116PI"]
[]
[null,"TX116PII"]
[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=\"\",AuthorizedDate>42037),4,IF(AuthorizedDate>40210,\"3\",IF(AuthorizedDate>38257,\"2\",\"1\")))","v":4}]

{"sheet":"RX","index":1,"n_rows":80,"n_cols":9,"rows_kept":80,"cut":false,"hidden":true,"merged":[]}
[{"$f":"SUBTOTAL(103,A3:A1048576)","v":78}]
["Fld_nbr","Value","Desc_1","Desc_2","Desc_3","Desc_4","Desc_5","Desc_6","Desc_7"]
[1,{"$f":"IF('Tex-116-E'!$B$48=\"\",\"\",'Tex-116-E'!$B$48)","v":""},{"$f":"'Tex-116-E'!$B$47","v":"Remarks:"}]
[2,{"$f":"IF('Tex-116-E'!$D$19=\"\",\"\",'Tex-116-E'!$D$19)","v":""},{"$f":"IF('Tex-116-E'!$C$19=\"\",\"\",'Tex-116-E'!$C$19)","v":"COURSE\\LIFT:"}]
[3,{"$f":"IF('Tex-116-E'!$C$57=\"\",\"\",'Tex-116-E'!$C$57)","v":""},"Tested By ",{"$f":"IF('Tex-116-E'!$B$57=\"\",\"\",'Tex-116-E'!$B$57)","v":"TX116"}]
[4,{"$f":"IF('Tex-116-E'!$F$57=\"\",\"\",'Tex-116-E'!$F$57)","v":""},"Tested Date ",{"$f":"IF('Tex-116-E'!$B$57=\"\",\"\",'Tex-116-E'!$B$57)","v":"TX116"}]
[5,{"$f":"IF('Tex-116-E'!$C$24=\"\",\"\",'Tex-116-E'!$C$24)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$C$23=\"\",\"\",'Tex-116-E'!$C$23)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$24=\"\",\"\",'Tex-116-E'!$B$24)","v":""}]
[6,{"$f":"IF('Tex-116-E'!$D$24=\"\",\"\",'Tex-116-E'!$D$24)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$D$22=\"\",\"\",'Tex-116-E'!$D$22)","v":"Individual Percent Retained"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$24=\"\",\"\",'Tex-116-E'!$B$24)","v":""}]
[7,{"$f":"IF('Tex-116-E'!$E$24=\"\",\"\",'Tex-116-E'!$E$24)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$E$22=\"\",\"\",'Tex-116-E'!$E$22)","v":"Cumulative Percent Retained"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$24=\"\",\"\",'Tex-116-E'!$B$24)","v":""}]
[8,{"$f":"IF('Tex-116-E'!$C$25=\"\",\"\",'Tex-116-E'!$C$25)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$C$23=\"\",\"\",'Tex-116-E'!$C$23)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$25=\"\",\"\",'Tex-116-E'!$B$25)","v":""}]
[9,{"$f":"IF('Tex-116-E'!$D$25=\"\",\"\",'Tex-116-E'!$D$25)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$D$22=\"\",\"\",'Tex-116-E'!$D$22)","v":"Individual Percent Retained"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$25=\"\",\"\",'Tex-116-E'!$B$25)","v":""}]
[10,{"$f":"IF('Tex-116-E'!$E$25=\"\",\"\",'Tex-116-E'!$E$25)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$E$22=\"\",\"\",'Tex-116-E'!$E$22)","v":"Cumulative Percent Retained"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$25=\"\",\"\",'Tex-116-E'!$B$25)","v":""}]
[11,{"$f":"IF('Tex-116-E'!$C$26=\"\",\"\",'Tex-116-E'!$C$26)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$C$23=\"\",\"\",'Tex-116-E'!$C$23)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$26=\"\",\"\",'Tex-116-E'!$B$26)","v":""}]
[12,{"$f":"IF('Tex-116-E'!$D$26=\"\",\"\",'Tex-116-E'!$D$26)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$D$22=\"\",\"\",'Tex-116-E'!$D$22)","v":"Individual Percent Retained"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$26=\"\",\"\",'Tex-116-E'!$B$26)","v":""}]
[13,{"$f":"IF('Tex-116-E'!$E$26=\"\",\"\",'Tex-116-E'!$E$26)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$E$22=\"\",\"\",'Tex-116-E'!$E$22)","v":"Cumulative Percent Retained"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$26=\"\",\"\",'Tex-116-E'!$B$26)","v":""}]
[14,{"$f":"IF('Tex-116-E'!$C$27=\"\",\"\",'Tex-116-E'!$C$27)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$C$23=\"\",\"\",'Tex-116-E'!$C$23)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$27=\"\",\"\",'Tex-116-E'!$B$27)","v":""}]
[15,{"$f":"IF('Tex-116-E'!$D$27=\"\",\"\",'Tex-116-E'!$D$27)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$D$22=\"\",\"\",'Tex-116-E'!$D$22)","v":"Individual Percent Retained"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$27=\"\",\"\",'Tex-116-E'!$B$27)","v":""}]
[16,{"$f":"IF('Tex-116-E'!$E$27=\"\",\"\",'Tex-116-E'!$E$27)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$E$22=\"\",\"\",'Tex-116-E'!$E$22)","v":"Cumulative Percent Retained"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$27=\"\",\"\",'Tex-116-E'!$B$27)","v":""}]
[17,{"$f":"IF('Tex-116-E'!$C$28=\"\",\"\",'Tex-116-E'!$C$28)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$C$23=\"\",\"\",'Tex-116-E'!$C$23)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$28=\"\",\"\",'Tex-116-E'!$B$28)","v":""}]
[18,{"$f":"IF('Tex-116-E'!$D$28=\"\",\"\",'Tex-116-E'!$D$28)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$D$22=\"\",\"\",'Tex-116-E'!$D$22)","v":"Individual Percent Retained"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$28=\"\",\"\",'Tex-116-E'!$B$28)","v":""}]
[19,{"$f":"IF('Tex-116-E'!$E$28=\"\",\"\",'Tex-116-E'!$E$28)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$E$22=\"\",\"\",'Tex-116-E'!$E$22)","v":"Cumulative Percent Retained"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$28=\"\",\"\",'Tex-116-E'!$B$28)","v":""}]
[20,{"$f":"IF('Tex-116-E'!$C$29=\"\",\"\",'Tex-116-E'!$C$29)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$C$23=\"\",\"\",'Tex-116-E'!$C$23)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$29=\"\",\"\",'Tex-116-E'!$B$29)","v":""}]
[21,{"$f":"IF('Tex-116-E'!$D$29=\"\",\"\",'Tex-116-E'!$D$29)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$D$22=\"\",\"\",'Tex-116-E'!$D$22)","v":"Individual Percent Retained"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$29=\"\",\"\",'Tex-116-E'!$B$29)","v":""}]
[22,{"$f":"IF('Tex-116-E'!$E$29=\"\",\"\",'Tex-116-E'!$E$29)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$E$22=\"\",\"\",'Tex-116-E'!$E$22)","v":"Cumulative Percent Retained"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$29=\"\",\"\",'Tex-116-E'!$B$29)","v":""}]
[23,{"$f":"IF('Tex-116-E'!$C$31=\"\",\"\",'Tex-116-E'!$C$31)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$C$23=\"\",\"\",'Tex-116-E'!$C$23)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$31=\"\",\"\",'Tex-116-E'!$B$31)","v":"-"}]
[24,{"$f":"IF('Tex-116-E'!$D$31=\"\",\"\",'Tex-116-E'!$D$31)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$D$22=\"\",\"\",'Tex-116-E'!$D$22)","v":"Individual Percent Retained"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$31=\"\",\"\",'Tex-116-E'!$B$31)","v":"-"}]
[25,{"$f":"IF('Tex-116-E'!$C$32=\"\",\"\",'Tex-116-E'!$C$32)","v":0},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$C$23=\"\",\"\",'Tex-116-E'!$C$23)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$32=\"\",\"\",'Tex-116-E'!$B$32)","v":"Total:"}]
[26,{"$f":"IF('Tex-116-E'!$F$25=\"\",\"\",'Tex-116-E'!$F$25)","v":""},{"$f":"IF('Tex-116-E'!$F$21=\"\",\"\",'Tex-116-E'!$F$21)","v":"Part I: 3500g Preparation"},{"$f":"IF('Tex-116-E'!$F$22=\"\",\"\",'Tex-116-E'!$F$22)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$25=\"\",\"\",'Tex-116-E'!$B$25)","v":""}]
[27,{"$f":"IF('Tex-116-E'!$G$25=\"\",\"\",'Tex-116-E'!$G$25)","v":""},{"$f":"IF('Tex-116-E'!$F$21=\"\",\"\",'Tex-116-E'!$F$21)","v":"Part I: 3500g Preparation"},{"$f":"IF('Tex-116-E'!$G$22=\"\",\"\",'Tex-116-E'!$G$22)","v":"Cumulative Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$25=\"\",\"\",'Tex-116-E'!$B$25)","v":""}]
[28,{"$f":"IF('Tex-116-E'!$H$25=\"\",\"\",'Tex-116-E'!$H$25)","v":""},{"$f":"IF('Tex-116-E'!$H$21=\"\",\"\",'Tex-116-E'!$H$21)","v":"Part II: 3000g Preparation"},{"$f":"IF('Tex-116-E'!$H$22=\"\",\"\",'Tex-116-E'!$H$22)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$25=\"\",\"\",'Tex-116-E'!$B$25)","v":""}]
[29,{"$f":"IF('Tex-116-E'!$I$25=\"\",\"\",'Tex-116-E'!$I$25)","v":""},{"$f":"IF('Tex-116-E'!$H$21=\"\",\"\",'Tex-116-E'!$H$21)","v":"Part II: 3000g Preparation"},{"$f":"IF('Tex-116-E'!$I$22=\"\",\"\",'Tex-116-E'!$I$22)","v":"Cumulative Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$25=\"\",\"\",'Tex-116-E'!$B$25)","v":""}]
[30,{"$f":"IF('Tex-116-E'!$F$26=\"\",\"\",'Tex-116-E'!$F$26)","v":""},{"$f":"IF('Tex-116-E'!$F$21=\"\",\"\",'Tex-116-E'!$F$21)","v":"Part I: 3500g Preparation"},{"$f":"IF('Tex-116-E'!$F$22=\"\",\"\",'Tex-116-E'!$F$22)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$26=\"\",\"\",'Tex-116-E'!$B$26)","v":""}]
[31,{"$f":"IF('Tex-116-E'!$G$26=\"\",\"\",'Tex-116-E'!$G$26)","v":""},{"$f":"IF('Tex-116-E'!$F$21=\"\",\"\",'Tex-116-E'!$F$21)","v":"Part I: 3500g Preparation"},{"$f":"IF('Tex-116-E'!$G$22=\"\",\"\",'Tex-116-E'!$G$22)","v":"Cumulative Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$26=\"\",\"\",'Tex-116-E'!$B$26)","v":""}]
[32,{"$f":"IF('Tex-116-E'!$H$26=\"\",\"\",'Tex-116-E'!$H$26)","v":""},{"$f":"IF('Tex-116-E'!$H$21=\"\",\"\",'Tex-116-E'!$H$21)","v":"Part II: 3000g Preparation"},{"$f":"IF('Tex-116-E'!$H$22=\"\",\"\",'Tex-116-E'!$H$22)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$26=\"\",\"\",'Tex-116-E'!$B$26)","v":""}]
[33,{"$f":"IF('Tex-116-E'!$I$26=\"\",\"\",'Tex-116-E'!$I$26)","v":""},{"$f":"IF('Tex-116-E'!$H$21=\"\",\"\",'Tex-116-E'!$H$21)","v":"Part II: 3000g Preparation"},{"$f":"IF('Tex-116-E'!$I$22=\"\",\"\",'Tex-116-E'!$I$22)","v":"Cumulative Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$26=\"\",\"\",'Tex-116-E'!$B$26)","v":""}]
[34,{"$f":"IF('Tex-116-E'!$F$27=\"\",\"\",'Tex-116-E'!$F$27)","v":""},{"$f":"IF('Tex-116-E'!$F$21=\"\",\"\",'Tex-116-E'!$F$21)","v":"Part I: 3500g Preparation"},{"$f":"IF('Tex-116-E'!$F$22=\"\",\"\",'Tex-116-E'!$F$22)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$27=\"\",\"\",'Tex-116-E'!$B$27)","v":""}]
[35,{"$f":"IF('Tex-116-E'!$G$27=\"\",\"\",'Tex-116-E'!$G$27)","v":""},{"$f":"IF('Tex-116-E'!$F$21=\"\",\"\",'Tex-116-E'!$F$21)","v":"Part I: 3500g Preparation"},{"$f":"IF('Tex-116-E'!$G$22=\"\",\"\",'Tex-116-E'!$G$22)","v":"Cumulative Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$27=\"\",\"\",'Tex-116-E'!$B$27)","v":""}]
[36,{"$f":"IF('Tex-116-E'!$H$27=\"\",\"\",'Tex-116-E'!$H$27)","v":""},{"$f":"IF('Tex-116-E'!$H$21=\"\",\"\",'Tex-116-E'!$H$21)","v":"Part II: 3000g Preparation"},{"$f":"IF('Tex-116-E'!$H$22=\"\",\"\",'Tex-116-E'!$H$22)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$27=\"\",\"\",'Tex-116-E'!$B$27)","v":""}]
[37,{"$f":"IF('Tex-116-E'!$I$27=\"\",\"\",'Tex-116-E'!$I$27)","v":""},{"$f":"IF('Tex-116-E'!$H$21=\"\",\"\",'Tex-116-E'!$H$21)","v":"Part II: 3000g Preparation"},{"$f":"IF('Tex-116-E'!$I$22=\"\",\"\",'Tex-116-E'!$I$22)","v":"Cumulative Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$27=\"\",\"\",'Tex-116-E'!$B$27)","v":""}]
[38,{"$f":"IF('Tex-116-E'!$F$28=\"\",\"\",'Tex-116-E'!$F$28)","v":""},{"$f":"IF('Tex-116-E'!$F$21=\"\",\"\",'Tex-116-E'!$F$21)","v":"Part I: 3500g Preparation"},{"$f":"IF('Tex-116-E'!$F$22=\"\",\"\",'Tex-116-E'!$F$22)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$28=\"\",\"\",'Tex-116-E'!$B$28)","v":""}]
[39,{"$f":"IF('Tex-116-E'!$G$28=\"\",\"\",'Tex-116-E'!$G$28)","v":""},{"$f":"IF('Tex-116-E'!$F$21=\"\",\"\",'Tex-116-E'!$F$21)","v":"Part I: 3500g Preparation"},{"$f":"IF('Tex-116-E'!$G$22=\"\",\"\",'Tex-116-E'!$G$22)","v":"Cumulative Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$28=\"\",\"\",'Tex-116-E'!$B$28)","v":""}]
[40,{"$f":"IF('Tex-116-E'!$H$28=\"\",\"\",'Tex-116-E'!$H$28)","v":""},{"$f":"IF('Tex-116-E'!$H$21=\"\",\"\",'Tex-116-E'!$H$21)","v":"Part II: 3000g Preparation"},{"$f":"IF('Tex-116-E'!$H$22=\"\",\"\",'Tex-116-E'!$H$22)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$28=\"\",\"\",'Tex-116-E'!$B$28)","v":""}]
[41,{"$f":"IF('Tex-116-E'!$I$28=\"\",\"\",'Tex-116-E'!$I$28)","v":""},{"$f":"IF('Tex-116-E'!$H$21=\"\",\"\",'Tex-116-E'!$H$21)","v":"Part II: 3000g Preparation"},{"$f":"IF('Tex-116-E'!$I$22=\"\",\"\",'Tex-116-E'!$I$22)","v":"Cumulative Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$28=\"\",\"\",'Tex-116-E'!$B$28)","v":""}]
[42,{"$f":"IF('Tex-116-E'!$F$29=\"\",\"\",'Tex-116-E'!$F$29)","v":""},{"$f":"IF('Tex-116-E'!$F$21=\"\",\"\",'Tex-116-E'!$F$21)","v":"Part I: 3500g Preparation"},{"$f":"IF('Tex-116-E'!$F$22=\"\",\"\",'Tex-116-E'!$F$22)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$29=\"\",\"\",'Tex-116-E'!$B$29)","v":""}]
[43,{"$f":"IF('Tex-116-E'!$G$29=\"\",\"\",'Tex-116-E'!$G$29)","v":""},{"$f":"IF('Tex-116-E'!$F$21=\"\",\"\",'Tex-116-E'!$F$21)","v":"Part I: 3500g Preparation"},{"$f":"IF('Tex-116-E'!$G$22=\"\",\"\",'Tex-116-E'!$G$22)","v":"Cumulative Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$29=\"\",\"\",'Tex-116-E'!$B$29)","v":""}]
[44,{"$f":"IF('Tex-116-E'!$H$29=\"\",\"\",'Tex-116-E'!$H$29)","v":""},{"$f":"IF('Tex-116-E'!$H$21=\"\",\"\",'Tex-116-E'!$H$21)","v":"Part II: 3000g Preparation"},{"$f":"IF('Tex-116-E'!$H$22=\"\",\"\",'Tex-116-E'!$H$22)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$29=\"\",\"\",'Tex-116-E'!$B$29)","v":""}]
[45,{"$f":"IF('Tex-116-E'!$I$29=\"\",\"\",'Tex-116-E'!$I$29)","v":""},{"$f":"IF('Tex-116-E'!$H$21=\"\",\"\",'Tex-116-E'!$H$21)","v":"Part II: 3000g Preparation"},{"$f":"IF('Tex-116-E'!$I$22=\"\",\"\",'Tex-116-E'!$I$22)","v":"Cumulative Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$29=\"\",\"\",'Tex-116-E'!$B$29)","v":""}]
[46,{"$f":"IF('Tex-116-E'!$F$31=\"\",\"\",'Tex-116-E'!$F$31)","v":""},{"$f":"IF('Tex-116-E'!$F$21=\"\",\"\",'Tex-116-E'!$F$21)","v":"Part I: 3500g Preparation"},{"$f":"IF('Tex-116-E'!$F$22=\"\",\"\",'Tex-116-E'!$F$22)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$31=\"\",\"\",'Tex-116-E'!$B$31)","v":"-"}]
[47,{"$f":"IF('Tex-116-E'!$G$31=\"\",\"\",'Tex-116-E'!$G$31)","v":""},{"$f":"IF('Tex-116-E'!$F$21=\"\",\"\",'Tex-116-E'!$F$21)","v":"Part I: 3500g Preparation"},{"$f":"IF('Tex-116-E'!$G$22=\"\",\"\",'Tex-116-E'!$G$22)","v":"Cumulative Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$31=\"\",\"\",'Tex-116-E'!$B$31)","v":"-"}]
[48,{"$f":"IF('Tex-116-E'!$H$31=\"\",\"\",'Tex-116-E'!$H$31)","v":""},{"$f":"IF('Tex-116-E'!$H$21=\"\",\"\",'Tex-116-E'!$H$21)","v":"Part II: 3000g Preparation"},{"$f":"IF('Tex-116-E'!$H$22=\"\",\"\",'Tex-116-E'!$H$22)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$31=\"\",\"\",'Tex-116-E'!$B$31)","v":"-"}]
[49,{"$f":"IF('Tex-116-E'!$I$31=\"\",\"\",'Tex-116-E'!$I$31)","v":""},{"$f":"IF('Tex-116-E'!$H$21=\"\",\"\",'Tex-116-E'!$H$21)","v":"Part II: 3000g Preparation"},{"$f":"IF('Tex-116-E'!$I$22=\"\",\"\",'Tex-116-E'!$I$22)","v":"Cumulative Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$31=\"\",\"\",'Tex-116-E'!$B$31)","v":"-"}]
[50,{"$f":"IF('Tex-116-E'!$F$32=\"\",\"\",'Tex-116-E'!$F$32)","v":0},{"$f":"IF('Tex-116-E'!$F$21=\"\",\"\",'Tex-116-E'!$F$21)","v":"Part I: 3500g Preparation"},{"$f":"IF('Tex-116-E'!$F$22=\"\",\"\",'Tex-116-E'!$F$22)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$32=\"\",\"\",'Tex-116-E'!$B$32)","v":"Total:"}]
[51,{"$f":"IF('Tex-116-E'!$H$32=\"\",\"\",'Tex-116-E'!$H$32)","v":0},{"$f":"IF('Tex-116-E'!$H$21=\"\",\"\",'Tex-116-E'!$H$21)","v":"Part II: 3000g Preparation"},{"$f":"IF('Tex-116-E'!$H$22=\"\",\"\",'Tex-116-E'!$H$22)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$32=\"\",\"\",'Tex-116-E'!$B$32)","v":"Total:"}]
[52,{"$f":"IF('Tex-116-E'!$D$36=\"\",\"\",'Tex-116-E'!$D$36)","v":""},{"$f":"IF('Tex-116-E'!$C$34=\"\",\"\",'Tex-116-E'!$C$34)","v":"Part I: Wet Ball Mill"},{"$f":"IF('Tex-116-E'!$C$36=\"\",\"\",'Tex-116-E'!$C$36)","v":"Initial Weight"}]
[53,{"$f":"IF('Tex-116-E'!$D$40=\"\",\"\",'Tex-116-E'!$D$40)","v":""},{"$f":"IF('Tex-116-E'!$C$34=\"\",\"\",'Tex-116-E'!$C$34)","v":"Part I: Wet Ball Mill"},{"$f":"IF('Tex-116-E'!$D$38=\"\",\"\",'Tex-116-E'!$D$38)","v":"Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$C$38=\"\",\"\",'Tex-116-E'!$C$38)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$C$40=\"\",\"\",'Tex-116-E'!$C$40)","v":""}]
[54,{"$f":"IF('Tex-116-E'!$E$40=\"\",\"\",'Tex-116-E'!$E$40)","v":""},{"$f":"IF('Tex-116-E'!$C$34=\"\",\"\",'Tex-116-E'!$C$34)","v":"Part I: Wet Ball Mill"},{"$f":"IF('Tex-116-E'!$E$38=\"\",\"\",'Tex-116-E'!$E$38)","v":"Individual Percent Retained"},{"$f":"IF('Tex-116-E'!$C$38=\"\",\"\",'Tex-116-E'!$C$38)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$C$40=\"\",\"\",'Tex-116-E'!$C$40)","v":""}]
[55,{"$f":"IF('Tex-116-E'!$D$41=\"\",\"\",'Tex-116-E'!$D$41)","v":""},{"$f":"IF('Tex-116-E'!$C$34=\"\",\"\",'Tex-116-E'!$C$34)","v":"Part I: Wet Ball Mill"},{"$f":"IF('Tex-116-E'!$D$38=\"\",\"\",'Tex-116-E'!$D$38)","v":"Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$C$38=\"\",\"\",'Tex-116-E'!$C$38)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$C$41=\"\",\"\",'Tex-116-E'!$C$41)","v":"- "}]
[56,{"$f":"IF('Tex-116-E'!$E$41=\"\",\"\",'Tex-116-E'!$E$41)","v":""},{"$f":"IF('Tex-116-E'!$C$34=\"\",\"\",'Tex-116-E'!$C$34)","v":"Part I: Wet Ball Mill"},{"$f":"IF('Tex-116-E'!$E$38=\"\",\"\",'Tex-116-E'!$E$38)","v":"Individual Percent Retained"},{"$f":"IF('Tex-116-E'!$C$38=\"\",\"\",'Tex-116-E'!$C$38)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$C$41=\"\",\"\",'Tex-116-E'!$C$41)","v":"- "}]
[57,{"$f":"IF('Tex-116-E'!$E$43=\"\",\"\",'Tex-116-E'!$E$43)","v":""},{"$f":"IF('Tex-116-E'!$C$34=\"\",\"\",'Tex-116-E'!$C$34)","v":"Part I: Wet Ball Mill"},{"$f":"IF('Tex-116-E'!$C$43=\"\",\"\",'Tex-116-E'!$C$43)","v":"Wet Ball Mill Value, %:"}]
[58,{"$f":"IF('Tex-116-E'!$H$40=\"\",\"\",'Tex-116-E'!$H$40)","v":""},{"$f":"IF('Tex-116-E'!$G$34=\"\",\"\",'Tex-116-E'!$G$34)","v":"Part II: Washed Sieve Analysis"},{"$f":"IF('Tex-116-E'!$H$38=\"\",\"\",'Tex-116-E'!$H$38)","v":"Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$G$38=\"\",\"\",'Tex-116-E'!$G$38)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$G$40=\"\",\"\",'Tex-116-E'!$G$40)","v":""}]
[59,{"$f":"IF('Tex-116-E'!$I$40=\"\",\"\",'Tex-116-E'!$I$40)","v":""},{"$f":"IF('Tex-116-E'!$G$34=\"\",\"\",'Tex-116-E'!$G$34)","v":"Part II: Washed Sieve Analysis"},{"$f":"IF('Tex-116-E'!$I$38=\"\",\"\",'Tex-116-E'!$I$38)","v":"Individual Percent Retained"},{"$f":"IF('Tex-116-E'!$G$38=\"\",\"\",'Tex-116-E'!$G$38)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$G$40=\"\",\"\",'Tex-116-E'!$G$40)","v":""}]
[60,{"$f":"IF('Tex-116-E'!$H$41=\"\",\"\",'Tex-116-E'!$H$41)","v":""},{"$f":"IF('Tex-116-E'!$G$34=\"\",\"\",'Tex-116-E'!$G$34)","v":"Part II: Washed Sieve Analysis"},{"$f":"IF('Tex-116-E'!$H$38=\"\",\"\",'Tex-116-E'!$H$38)","v":"Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$G$38=\"\",\"\",'Tex-116-E'!$G$38)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$G$41=\"\",\"\",'Tex-116-E'!$G$41)","v":"- "}]
[61,{"$f":"IF('Tex-116-E'!$I$41=\"\",\"\",'Tex-116-E'!$I$41)","v":""},{"$f":"IF('Tex-116-E'!$G$34=\"\",\"\",'Tex-116-E'!$G$34)","v":"Part II: Washed Sieve Analysis"},{"$f":"IF('Tex-116-E'!$I$38=\"\",\"\",'Tex-116-E'!$I$38)","v":"Individual Percent Retained"},{"$f":"IF('Tex-116-E'!$G$38=\"\",\"\",'Tex-116-E'!$G$38)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$G$41=\"\",\"\",'Tex-116-E'!$G$41)","v":"- "}]
[62,{"$f":"IF('Tex-116-E'!$I$43=\"\",\"\",'Tex-116-E'!$I$43)","v":""},{"$f":"IF('Tex-116-E'!$G$34=\"\",\"\",'Tex-116-E'!$G$34)","v":"Part II: Washed Sieve Analysis"},{"$f":"IF('Tex-116-E'!$G$43=\"\",\"\",'Tex-116-E'!$G$43)","v":"Percent Soil Binder, %:"}]
[63,{"$f":"IF('Tex-116-E'!$G$45=\"\",\"\",'Tex-116-E'!$G$45)","v":""},{"$f":"IF('Tex-116-E'!$B$6=\"\",\"\",'Tex-116-E'!$B$6)","v":"Tex-116-E - Part I and II"},{"$f":"IF('Tex-116-E'!$D$45=\"\",\"\",'Tex-116-E'!$D$45)","v":"% Soil Binder Increase:"}]
[64,{"$f":"IF('Tex-116-E'!$C$30=\"\",\"\",'Tex-116-E'!$C$30)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$C$23=\"\",\"\",'Tex-116-E'!$C$23)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$30=\"\",\"\",'Tex-116-E'!$B$30)","v":""}]
[65,{"$f":"IF('Tex-116-E'!$D$30=\"\",\"\",'Tex-116-E'!$D$30)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$D$22=\"\",\"\",'Tex-116-E'!$D$22)","v":"Individual Percent Retained"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$30=\"\",\"\",'Tex-116-E'!$B$30)","v":""}]
[66,{"$f":"IF('Tex-116-E'!$E$30=\"\",\"\",'Tex-116-E'!$E$30)","v":""},{"$f":"IF('Tex-116-E'!$B$21=\"\",\"\",'Tex-116-E'!$B$21)","v":"Original Dry Screen Gradation"},{"$f":"IF('Tex-116-E'!$E$22=\"\",\"\",'Tex-116-E'!$E$22)","v":"Cumulative Percent Retained"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$30=\"\",\"\",'Tex-116-E'!$B$30)","v":""}]
[67,{"$f":"IF('Tex-116-E'!$F$30=\"\",\"\",'Tex-116-E'!$F$30)","v":""},{"$f":"IF('Tex-116-E'!$F$21=\"\",\"\",'Tex-116-E'!$F$21)","v":"Part I: 3500g Preparation"},{"$f":"IF('Tex-116-E'!$F$22=\"\",\"\",'Tex-116-E'!$F$22)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$30=\"\",\"\",'Tex-116-E'!$B$30)","v":""}]
[68,{"$f":"IF('Tex-116-E'!$G$30=\"\",\"\",'Tex-116-E'!$G$30)","v":""},{"$f":"IF('Tex-116-E'!$F$21=\"\",\"\",'Tex-116-E'!$F$21)","v":"Part I: 3500g Preparation"},{"$f":"IF('Tex-116-E'!$G$22=\"\",\"\",'Tex-116-E'!$G$22)","v":"Cumulative Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$30=\"\",\"\",'Tex-116-E'!$B$30)","v":""}]
[69,{"$f":"IF('Tex-116-E'!$H$30=\"\",\"\",'Tex-116-E'!$H$30)","v":""},{"$f":"IF('Tex-116-E'!$H$21=\"\",\"\",'Tex-116-E'!$H$21)","v":"Part II: 3000g Preparation"},{"$f":"IF('Tex-116-E'!$H$22=\"\",\"\",'Tex-116-E'!$H$22)","v":"Individual Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$30=\"\",\"\",'Tex-116-E'!$B$30)","v":""}]
[70,{"$f":"IF('Tex-116-E'!$I$30=\"\",\"\",'Tex-116-E'!$I$30)","v":""},{"$f":"IF('Tex-116-E'!$H$21=\"\",\"\",'Tex-116-E'!$H$21)","v":"Part II: 3000g Preparation"},{"$f":"IF('Tex-116-E'!$I$22=\"\",\"\",'Tex-116-E'!$I$22)","v":"Cumulative Weight Retained (g)"},{"$f":"IF('Tex-116-E'!$B$22=\"\",\"\",'Tex-116-E'!$B$22)","v":"Sieve Size"},{"$f":"IF('Tex-116-E'!$B$30=\"\",\"\",'Tex-116-E'!$B$30)","v":""}]
[71,{"$f":"IF(Field44=\"\",\"\",Field44)","v":""},"Tested By ",{"$f":"Test2","v":"TX116PI"}]
[72,{"$f":"IF(Field45=\"\",\"\",Field45)","v":""},"Tested Date ",{"$f":"Test2","v":"TX116PI"}]
[73,{"$f":"IF(Field46=\"\",\"\",Field46)","v":""},"Tested By ",{"$f":"Test3","v":"TX116PII"}]
[74,{"$f":"IF(Field47=\"\",\"\",Field47)","v":""},"Tested Date ",{"$f":"Test3","v":"TX116PII"}]
[75,{"$f":"IF(Field48=\"\",\"\",Field48)","v":""},"Sampled By ",{"$f":"Test4","v":"TX100"}]
[76,{"$f":"IF(Field49=\"\",\"\",Field49)","v":""},"Sampled Date ",{"$f":"Test4","v":"TX100"}]
[77,{"$f":"IF(Field50=\"\",\"\",Field50)","v":""},"Sampled By ",{"$f":"Test5","v":"TX400"}]
[78,{"$f":"IF(Field51=\"\",\"\",Field51)","v":""},"Sampled Date ",{"$f":"Test5","v":"TX400"}]

{"sheet":"Revisions","index":2,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Date","Changes","Changed by","Comments"]
["2005-07-07","Add [Enter Specifiction] routine and change formula (B23-B29) from  =IF(SpecYear=\"\",\"\",IF(SpecYear=\"1995\",Sieve!B7,Sieve!A7)     to =IF(SpecYear=\"\",\"\",IF(Field22=\"\",IF(SpecYear=\"1995\",Sieve!B7,Sieve!A7),IF(SpecYear=\"1995\",Sieve!D17,Sieve!C17)))  ULPC from 21 to 39","Joe Liu","Requested by Jerry Reed from Amarillo District Laboratory"]

{"sheet":"Sieve","index":3,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":true,"merged":[[11,0,17,0]]}
["English","Metric"]
["1-3/4\"","45 mm"]
["1-1/4\"","31.5 mm"]
["7/8\"","22.4 mm"]
["5/8\"","16.0 mm"]
["3/8\"","9.5 mm"]
["No. 4","4.75 mm"]
["No. 10","2.00 mm"]
["No. 40","425 µm"]
[]
[null,"Size","English","Metric"]
["Grade 6 User Input"]
[]
[]
[]
[]
[]
[]
[]
[]
["Size","English","Metric","Selection"]
[152,"6\"","152 mm",{"$f":"IF(SpecYear=\"\",\"\",IF(SpecYear=\"1995\",C22,B22))","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",""]
[null,null,null,{"$f":"IF(SpecYear=\"\",\"\",\"None\")","v":""}]