{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["PGE - TTF 001"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":1,"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":"PGE - TTF 001","index":0,"n_rows":51,"n_cols":17,"rows_kept":51,"cut":false,"hidden":false,"merged":[[34,5,35,5],[34,6,35,6],[4,2,4,3],[5,2,5,3],[10,6,10,10],[12,2,14,2],[34,2,36,2],[34,3,35,3],[34,4,35,4],[2,2,2,14],[1,2,1,5],[7,9,7,10],[4,13,4,14],[5,13,5,14],[6,13,6,14],[1,13,1,14],[7,4,7,5],[6,4,6,5],[5,4,5,5],[4,4,4,5],[4,9,4,10],[5,9,5,10],[6,2,6,3],[7,2,7,3],[6,9,6,10],[12,14,14,14],[12,11,13,11],[12,12,13,13],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6],[12,7,14,7],[47,6,47,14],[48,6,48,14],[50,10,50,14],[34,7,36,7],[34,12,35,13],[34,14,36,14],[34,11,35,11],[46,6,46,14]]}
[]
[null,null,"TOLLWAY TESTING FORM (TTF) 001",null,null,null,null,null,null,null,null,null,null,"REV 04/23/2020"]
[null,null,"GRADATION WORKSHEET FOR POROUS GRANULAR EMBANKMENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"QC"]
[null,null,"EQUIPMENT NAME",null,null,null,null,null,"SAMPLE",null,null,null,"LAB",null,null,null,"QA"]
[null,null,"EQUIPMENT #",null,null,null,null,null,"LOCATION",null,null,null,"INSP. TYPE",null,null,null,"IA"]
[null,null,"CONTRACT #",null,null,null,null,null,"MATL CODE",null,null,null,"SEQ #",null,null,null,"INV"]
[null,null,"DATE SAMPLED",null,null,null,null,null,"DATE TESTED"]
[]
[]
[null,null,null,null,null,null,"GRADATION GRIDSHEET OF COARSE MATERIAL (+3/8\")"]
[]
[null,null,"SIEVE\nSIZE","RET. WT.\nLBS OR KG","RET. WT.\nLBS OR KG","RET. WT.\nLBS OR KG","RET. WT.\nLBS OR KG",null,"COMBINE","ACCUM","ACCUM","% PASS","GRADATION RANGE",null,"RESULTS"]
[null,null,null,null,null,null,null,null,"TOT.RET WEIGHT","ST. WEIGHT","% RET"]
[null,null,null,"R-1","R-2","R-3","R-4",null,"(R-1+R-2+R-3+R-4)","S","T=(S/C/100)","T-100","MIN","MAX"]
[null,null,"8\"",null,null,null,null,"=",{"$f":"IF($D$25=\"\",\"\",SUM($D16:$G16))","v":""},{"$f":"IF($I16=\"\",\"\",SUM($I$16:$I16))","v":""},{"$f":"IF(J16=\"\",\"\",J16/$I$30*100)","v":""},{"$f":"IF($K16=\"\",\"\",100-$K16)","v":""},null,null,{"$f":"IF($I16=\"\",\"\",IF($M16=\"\",\"\",IF($N16=\"\",\"\",IF(OR($L16<$M16-0.5,$L16>$N16+0.4),\"FAIL\",\"\"))))","v":""}]
[null,null,"6\"",null,null,null,null,"=",{"$f":"IF($D$25=\"\",\"\",SUM($D17:$G17))","v":""},{"$f":"IF($I17=\"\",\"\",SUM($I$16:$I17))","v":""},{"$f":"IF(J17=\"\",\"\",J17/$I$30*100)","v":""},{"$f":"IF($K17=\"\",\"\",100-$K17)","v":""},null,null,{"$f":"IF($I17=\"\",\"\",IF($M17=\"\",\"\",IF($N17=\"\",\"\",IF(OR($L17<$M17-0.5,$L17>$N17+0.4),\"FAIL\",\"\"))))","v":""}]
[null,null,"5\"",null,null,null,null,"=","",{"$f":"IF($I18=\"\",\"\",SUM($I$16:$I18))","v":""},"","",null,null,""]
[null,null,"4\"",null,null,null,null,"=","",{"$f":"IF($I19=\"\",\"\",SUM($I$16:$I19))","v":""},"","",null,null,""]
[null,null,"3\"",null,null,null,null,"=","",{"$f":"IF($I20=\"\",\"\",SUM($I$16:$I20))","v":""},"","",null,null,""]
[null,null,"2 1/2\"",null,null,null,null,"=","",{"$f":"IF($I21=\"\",\"\",SUM($I$16:$I21))","v":""},"","",null,null,""]
[null,null,"2\"",null,null,null,null,"=","",{"$f":"IF($I22=\"\",\"\",SUM($I$16:$I22))","v":""},"","",null,null,""]
[null,null,"1.5\"",null,null,null,null,"=","",{"$f":"IF($I23=\"\",\"\",SUM($I$16:$I23))","v":""},"","",null,null,""]
[null,null,"1\"",null,null,null,null,"=","",{"$f":"IF($I24=\"\",\"\",SUM($I$16:$I24))","v":""},"","",null,null,""]
[null,null,"3/8\"",null,null,null,null,"=","",{"$f":"IF($I25=\"\",\"\",SUM($I$16:$I25))","v":""},"","",null,null,""]
[]
[]
[null,null,"AGG. WT.",{"$f":"IF(D$25=\"\",\"\",SUM(D$16:D$25))","v":""},{"$f":"IF(E$25=\"\",\"\",SUM(E$16:E$25))","v":""},{"$f":"IF(F$25=\"\",\"\",SUM(F$16:F$25))","v":""},{"$f":"IF(G$25=\"\",\"\",SUM(G$16:G$25))","v":""},"=",{"$f":"IF($D28=\"\",\"\",SUM($D28:$G28))","v":""},"A","R 3/8\"",{"$f":"IF($I28=\"\",\"\",$I28/$I$30)","v":""},"D"]
[null,null,"PAN WT./ -3/8",null,null,null,null,"=",{"$f":"IF($D29=\"\",\"\",SUM($D29:$G29))","v":""},"B","P 3/8\"",{"$f":"IF($I29=\"\",\"\",IF($I$30=\"\",\"\",$I29/$I$30))","v":""},"E"]
[null,null,"TOT. WT.",{"$f":"IF(D$28=\"\",\"\",SUM(D$28:D$29))","v":""},{"$f":"IF(E$28=\"\",\"\",SUM(E$28:E$29))","v":""},{"$f":"IF(F$28=\"\",\"\",SUM(F$28:F$29))","v":""},{"$f":"IF(G$28=\"\",\"\",SUM(G$28:G$29))","v":""},"=",{"$f":"IF($D30=\"\",\"\",SUM($D30:$G30))","v":""},"C"]
[]
[]
[null,null,null,null,null,null,"GRADATION GRIDSHEET OF FINE MATERIAL (-3/8\")"]
[]
[null,null,"SIEVE\nSIZE","RET. WT.\nGRAMS","% RET. WT.","% PASS #3/8\"","% RET.WT. \n% PASS 3/8\"",null,"% RET. WT. (X)","ACCUM.","ACCUM","% PASS","GRADATION RANGE",null,"RESULTS"]
[null,null,null,null,null,null,null,null,"COMB. WT.","RET. WT. +A","% RET. WT."]
[null,null,null,"U","V=(U/F)","(E)","W=(V*E)",null,"X=(W*C/100)","Y","Z=(Y/C*100)","(Z-100)","MIN","MAX"]
[null,null,"#4",null,{"$f":"IF($D38=\"\",\"\",IF($D$47=\"\",\"\",$D38/$D$47*100))","v":""},{"$f":"IF($L$29=\"\",\"\",$L$29)","v":""},{"$f":"IF($E38=\"\",\"\",IF($L$29=\"\",\"\",$F38*$E38))","v":""},null,{"$f":"IF($G38=\"\",\"\",$I$30*$G38/100)","v":""},{"$f":"IF($I38=\"\",$I$28,$I38+$I$28)","v":""},{"$f":"IF($J38=\"\",\"\",$J38/$I$30*100)","v":""},{"$f":"IF($K38=\"\",\"\",100-$K38)","v":""},null,null,{"$f":"IF($I38=\"\",\"\",IF($M38=\"\",\"\",IF($N38=\"\",\"\",IF(OR($L38<$M38-0.5,$L38>$N38+0.4),\"FAIL\",\"\"))))","v":""}]
[null,null,"#8",null,{"$f":"IF($D39=\"\",\"\",IF($D$47=\"\",\"\",$D39/$D$47*100))","v":""},"",{"$f":"IF($E39=\"\",\"\",IF($L$29=\"\",\"\",$F39*$E39))","v":""},null,"",{"$f":"IF($I39=\"\",$J$38,$I39+$J$38)","v":""},"",{"$f":"IF($K39=\"\",\"\",100-$K39)","v":""},null,null,{"$f":"IF($I39=\"\",\"\",IF($M39=\"\",\"\",IF($N39=\"\",\"\",IF(OR($L39<$M39-0.5,$L39>$N39+0.4),\"FAIL\",\"\"))))","v":""}]
[null,null,"#16",null,"","","",null,"",{"$f":"IF($I40=\"\",$J$39,$I40+$J$39)","v":""},"",{"$f":"IF($K40=\"\",\"\",100-$K40)","v":""},null,null,""]
[null,null,"#30",null,"","","",null,"",{"$f":"IF($I41=\"\",$J$40,$I41+$J$40)","v":""},"",{"$f":"IF($K41=\"\",\"\",100-$K41)","v":""},null,null,""]
[null,null,"#200",null,"","","",null,"",{"$f":"IF($I42=\"\",$J$41,$I42+$J$41)","v":""},"",{"$f":"IF($K42=\"\",\"\",100-$K42)","v":""},null,null,""]
[null,null,"PAN",null,"","","",null,"",{"$f":"IF($I43=\"\",$J$42,$I43+$J$42)","v":""},""]
[null,null,"DIFF. (-200)",null,""]
[null,null,null,"TOTAL % RET",{"$f":"IF($E$44=\"\",\"\",SUM($E$38:$E$44))","v":""}]
[]
[null,null,"DRY WT.",{"$f":"IF(D42=\"\",\"\",ROUND(SUM(D38:D44),0))","v":""},"F","REMARKS:"]
[null,null,"WASH WT.",null,"G"]
[null,null,"DIFF.(-200)",{"$f":"IF($D$48=\"\",\"\",IF($D$47=\"\",\"\",$D$47-$D$48))","v":""},"H"]
[]
[null,null,null,null,null,null,null,null,null,"TESTED BY:"]