{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Part A)-Petrographic Number(PN)","GOOD","FAIR","POOR","DELETERIOUS","Full"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":2,"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":"Part A)-Petrographic Number(PN)","index":0,"n_rows":76,"n_cols":27,"rows_kept":76,"cut":false,"hidden":false,"merged":[[23,8,23,9],[31,8,31,9],[28,0,28,2],[31,0,31,2],[32,0,32,2],[43,0,43,2],[46,0,46,2],[34,8,34,9],[35,8,35,9],[37,8,37,9],[42,8,42,9],[32,8,32,9],[38,8,38,9],[39,8,39,9],[36,5,36,6],[38,0,38,2],[38,5,38,6],[39,0,39,2],[39,5,39,6],[42,5,42,6],[43,5,43,6],[27,0,27,2],[26,0,26,2],[25,0,25,2],[2,7,2,10],[2,11,2,12],[71,2,71,3],[71,10,71,11],[71,12,71,13],[73,15,73,16],[74,15,74,16],[69,14,70,14],[70,2,70,3],[64,14,68,14],[20,5,20,6],[21,5,21,6],[29,8,29,9],[30,8,30,9],[25,5,25,6],[26,5,26,6],[27,5,27,6],[28,5,28,6],[29,5,29,6],[33,5,33,6],[9,8,9,9],[10,5,10,6],[11,5,11,6],[8,0,9,2],[0,1,0,14],[7,7,7,10],[1,1,1,2],[1,7,1,10],[1,13,1,14],[5,1,5,2],[7,11,7,14],[1,11,1,12],[1,3,1,6],[5,3,5,6],[7,0,7,2],[4,1,4,2],[4,3,4,6],[4,11,4,12],[6,1,6,2],[6,3,6,6],[6,7,6,10],[6,11,6,12],[6,13,6,14],[5,7,5,14],[2,13,2,14],[3,1,3,2],[3,3,3,6],[3,11,3,12],[24,8,24,9],[22,0,22,2],[22,5,22,6],[22,8,22,9],[23,0,23,2],[23,5,23,6],[2,3,2,6],[2,1,2,2],[30,0,30,2],[8,7,8,9],[11,8,11,9],[12,8,12,9],[13,8,13,9],[14,8,14,9],[15,8,15,9],[19,5,19,6],[16,0,16,2],[17,0,17,2],[18,0,18,2],[12,5,12,6],[13,5,13,6],[14,5,14,6],[17,5,17,6],[18,5,18,6],[31,5,31,6],[8,3,9,3],[42,0,42,2],[41,0,41,2],[29,0,29,2],[19,0,19,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[20,0,20,2],[21,0,21,2],[24,0,24,2],[37,0,37,2],[40,0,40,2],[40,5,40,6],[35,0,35,2],[33,0,33,2],[34,0,34,2],[36,0,36,2],[15,0,15,2],[6,18,6,19],[9,5,9,6],[10,18,10,19],[11,18,11,19],[7,3,7,6],[37,5,37,6],[44,8,44,9],[7,18,7,19],[8,18,8,19],[9,18,9,19],[16,8,16,9],[17,8,17,9],[18,8,18,9],[25,8,25,9],[26,8,26,9],[10,8,10,9],[15,5,15,6],[16,5,16,6],[8,14,9,14],[8,10,8,11],[8,12,8,13],[40,8,40,9],[41,8,41,9],[41,5,41,6],[48,0,48,2],[47,0,47,2],[47,5,47,6],[48,5,48,6],[59,0,59,2],[44,0,44,2],[45,0,45,2],[50,5,50,6],[55,0,55,2],[54,0,54,2],[54,5,54,6],[53,0,53,2],[3,13,3,14],[70,7,70,9],[44,5,44,6],[72,10,72,11],[33,8,33,9],[28,8,28,9],[19,8,19,9],[20,8,20,9],[21,8,21,9],[30,5,30,6],[32,5,32,6],[27,8,27,9],[72,4,72,6],[72,7,72,9],[71,7,71,9],[70,4,70,6],[71,4,71,6],[34,5,34,6],[35,5,35,6],[3,7,3,10],[4,7,4,10],[4,13,4,14],[50,8,50,9],[24,5,24,6],[73,10,73,11],[73,12,73,13],[73,14,74,14],[74,10,74,11],[74,12,74,13],[66,5,66,6],[67,5,67,6],[64,8,64,9],[66,8,66,9],[55,8,55,9],[45,8,45,9],[46,8,46,9],[47,8,47,9],[63,5,63,6],[64,5,64,6],[65,5,65,6],[61,8,61,9],[63,8,63,9],[65,8,65,9],[56,8,56,9],[52,8,52,9],[57,8,57,9],[59,8,59,9],[53,5,53,6],[53,8,53,9],[58,8,58,9],[43,8,43,9],[36,8,36,9],[55,5,55,6],[75,12,75,13],[75,10,75,11],[75,7,75,9],[75,4,75,6],[76,12,76,13],[76,10,76,11],[76,7,76,9],[76,4,76,6],[73,7,73,9],[74,7,74,9],[73,0,73,6],[72,12,72,13],[68,12,68,13],[70,10,70,11],[70,12,70,13],[69,0,69,13],[68,4,68,6],[68,7,68,9],[68,10,68,11],[52,0,52,2],[52,5,52,6],[67,2,67,3],[66,0,67,1],[65,0,65,1],[64,2,64,3],[65,2,65,3],[63,0,63,2],[62,0,62,2],[56,5,56,6],[56,0,56,2],[57,5,57,6],[59,5,59,6],[58,0,58,2],[58,5,58,6],[72,2,72,3],[74,0,74,6],[49,8,49,9],[60,8,60,9],[51,0,51,2],[51,5,51,6],[51,8,51,9],[45,5,45,6],[48,8,48,9],[62,5,62,6],[62,8,62,9],[67,8,67,9],[46,5,46,6],[66,2,66,3],[68,0,68,3],[57,0,57,2],[61,0,61,2],[49,0,49,2],[50,0,50,2],[61,5,61,6],[49,5,49,6],[60,0,60,2],[60,5,60,6],[54,8,54,9]]}
[null,"LS-609 (Part A) - Coarse Aggregates Petrographic Analysis (Petrographic Number, P.N.)"]
["Sample #:",null,null,"Analyst:",null,null,null,null,null,null,null,"Date Tested:"]
["Testing Lab:",null,null,"Telephone #:",null,null,null,null,null,null,null,"Fax #:"]
["Sampled By:",null,null,"Date Sampled:",null,null,null,null,null,null,null,"Sample Type:"]
["Source Name:",null,null,"Source Location:",null,null,null,null,null,null,null,"MAIDB #:"]
["Aggregate Type:",null,null,"Aggregate Product:"]
["CONTRACT #:",null,null,"CONTRACT LOCATION/HWY.:",null,null,null,null,null,null,null,"CONTRACTOR:",null,null,null,null,null,null,"P9.5/R4.75=",null,{"$f":"M73","v":35}]
["LOT NUMBER:",null,null,null,null,null,null,"SUBLOT NUMBER:",null,null,null,null,null,null,null,null,null,null,"P13.2/R9.5=",null,{"$f":"K73","v":30}]
["TYPE ",null,null,"TYPE No.","P",null,{"$f":"\"/R19\"","v":"/R19"},"P19.0/R13.2",null,null,"P13.2 / R9.5",null,"P 9.5 / R4.75",null,"Weighted Composition (%)",null,"F7 = ","I7 = ","P19/R13.2=",null,{"$f":"H73","v":35},"Stockpile","Superpave 12.5 FC2 Course Aggregate"]
[null,null,null,null,"Mass    (g)","%    of Fraction",null,"Mass (g)","% of Fraction",null,"Mass (g)","% of Fraction","Mass (g)","% of Fraction",null,null,75,19,"P____/R19=",null,{"$f":"E72","v":0},"Channelled Face","Superpave 12.5 FC1 Course Aggregate"]
[null,null,null,{"$f":"IF(A11=\"\",\"\",VLOOKUP(A11,GOOD!C$4:G$83,5,FALSE))","v":""},null,{"$f":"IF($E$26=0,0,E11/$E$64*100)","v":0},null,null,{"$f":"IF($H$26=0,0,H11/$H$64*100)","v":0},null,null,{"$f":"IF($K$26=0,0,K11/$K$64*100)","v":0},null,{"$f":"IF($M$26=0,0,M11/$M$64*100)","v":0},{"$f":"(E11/$E$64*$U$10+H11/$H$64*$U$9+K11/$K$64*$U$8+M11/$M$64*$U$7)*100/$P$75","v":0},null,53,13.2,null,null,null,"Road","Superpave 12.5 Course Aggregate",null,"CARBONATE (hard; silty, hard)",null,"01"]
[null,null,null,{"$f":"IF(A12=\"\",\"\",VLOOKUP(A12,GOOD!C$4:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,37.5,null,null,null,null,"Belt","SMA 12.5 Course Aggregate",null,"CARBONATE (surface weathering; silty, surface weathering; medium hard; silty, medium hard)",null,"20"]
[null,null,null,{"$f":"IF(A13=\"\",\"\",VLOOKUP(A13,GOOD!C$4:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,26.5,null,null,null,null,"Truckbox","SMA 9.5 Course Aggregate",null,"CARBONATE (sandy, hard or medium hard)",null,"02"]
[null,null,null,{"$f":"IF(A14=\"\",\"\",VLOOKUP(A14,GOOD!C$4:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,"Combined Sample","37.5 mm Concrete Course Aggregate",null,"CARBONATE (slightly cherty: <5% chert)",null,"21"]
[null,null,null,{"$f":"IF(A15=\"\",\"\",VLOOKUP(A15,GOOD!C$4:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,"Drill Core","19.0 mm Concrete Course Aggregate",null,"MARBLE (hard or medium hard)",null,"23"]
[null,null,null,{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,GOOD!C$4:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,"16.0 mm Concrete Course Aggregate",null,"CONGLOMERATE – SANDSTONE – ARKOSE (hard)",null,"03"]
[null,null,null,{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,GOOD!C$4:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,"13.2 mm Concrete Course Aggregate",null,"CONGLOMERATE – SANDSTONE – ARKOSE (medium hard)",null,"22"]
[null,null,null,{"$f":"IF(A18=\"\",\"\",VLOOKUP(A18,GOOD!C$4:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,"9.5 mm Concrete Course Aggregate",null,"GREYWACKE – ARGILLITE (hard or medium hard)",null,"06"]
[null,null,null,{"$f":"IF(A19=\"\",\"\",VLOOKUP(A19,GOOD!C$4:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,"6.7 mm Concrete Course Aggregate",null,"GNEISS – AMPHIBOLITE – SCHIST (hard)",null,"04"]
[null,null,null,{"$f":"IF(A20=\"\",\"\",VLOOKUP(A20,GOOD!C$4:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"QUARTZITE",null,"05"]
[null,null,null,{"$f":"IF(A21=\"\",\"\",VLOOKUP(A21,GOOD!C$4:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"GRANITE – DIORITE – GABBRO (hard)",null,"08"]
[null,null,null,{"$f":"IF(A22=\"\",\"\",VLOOKUP(A22,GOOD!C$4:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"VOLCANIC (hard or medium hard)",null,"07"]
[null,null,null,{"$f":"IF(A23=\"\",\"\",VLOOKUP(A23,GOOD!C$4:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"VOLCANIC (hard or medium hard)",null,"07"]
[null,null,null,{"$f":"IF(A24=\"\",\"\",VLOOKUP(A24,GOOD!C$4:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"TRAP (hard)",null,"09"]
[null,null,null,{"$f":"IF(A25=\"\",\"\",VLOOKUP(A25,GOOD!C$4:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"TRAP (hard)",null,"09"]
["TOTAL GOOD AGGREGATE",null,null,"–",{"$f":"SUM(E11:E25)","v":0},{"$f":"IF(E26=0,0,E26/E64*100)","v":0},null,{"$f":"SUM(H11:H25)","v":0},{"$f":"IF(H26=0,0,H26/H64*100)","v":0},null,{"$f":"SUM(K11:K25)","v":0},{"$f":"IF(K26=0,0,K26/K64*100)","v":0},{"$f":"SUM(M11:M25)","v":0},{"$f":"IF(M26=0,0,M26/M64*100)","v":0},0]
[null,null,null,{"$f":"IF(A27=\"\",\"\",VLOOKUP(A27,FAIR!C$3:G$83,5,FALSE))","v":""},null,{"$f":"IF($E$41=0,0,E27/$E$64*100)","v":0},null,null,{"$f":"IF($H$41=0,0,H27/$H$64*100)","v":0},null,null,{"$f":"IF($K$41=0,0,K27/$K$64*100)","v":0},null,{"$f":"IF($M$41=0,0,M27/$M$64*100)","v":0},0,null,null,null,null,null,null,null,null,null,"CARBONATE (soft; silty, soft; slightly shaley)",null,"35"]
[null,null,null,{"$f":"IF(A28=\"\",\"\",VLOOKUP(A28,FAIR!C$3:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"CARBONATE (soft; pitted)",null,"41"]
[null,null,null,{"$f":"IF(A29=\"\",\"\",VLOOKUP(A29,FAIR!C$3:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"CARBONATE (deeply weathered; silty, deeply weathered)",null,"42"]
[null,null,null,{"$f":"IF(A30=\"\",\"\",VLOOKUP(A30,FAIR!C$3:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"CARBONATE (sandy, soft)",null,"40"]
[null,null,null,{"$f":"IF(A31=\"\",\"\",VLOOKUP(A31,FAIR!C$3:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"MARBLE (brittle)",null,"24"]
[null,null,null,{"$f":"IF(A32=\"\",\"\",VLOOKUP(A32,FAIR!C$3:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"CHERT – CHERTY CARBONATE (< 20% leached chert)",null,"26"]
[null,null,null,{"$f":"IF(A33=\"\",\"\",VLOOKUP(A33,FAIR!C$3:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"CONGLOMERATE – SANDSTONE – ARKOSE (brittle)",null,"30"]
[null,null,null,{"$f":"IF(A34=\"\",\"\",VLOOKUP(A34,FAIR!C$3:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"GREYWACKE (brittle)",null,"29"]
[null,null,null,{"$f":"IF(A35=\"\",\"\",VLOOKUP(A35,FAIR!C$3:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"ENCRUSTATION",null,"52"]
[null,null,null,{"$f":"IF(A36=\"\",\"\",VLOOKUP(A36,FAIR!C$3:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"GNEISS – AMPHIBOLITE – SCHIST (brittle)",null,"25"]
[null,null,null,{"$f":"IF(A37=\"\",\"\",VLOOKUP(A37,FAIR!C$3:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"ARGILLITE (medium soft)",null,"34"]
[null,null,null,{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,FAIR!C$3:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"ARGILLITE (medium soft)",null,"34"]
[null,null,null,{"$f":"IF(A39=\"\",\"\",VLOOKUP(A39,FAIR!C$3:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"GRANITE – DIORITE – GABBRO (brittle)",null,"27"]
[null,null,null,{"$f":"IF(A40=\"\",\"\",VLOOKUP(A40,FAIR!C$3:G$83,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"VOLCANIC (soft)",null,"28"]
["TOTAL FAIR AGGREGATE",null,null,"–",{"$f":"SUM(E27:E40)","v":0},{"$f":"IF(E41=0,0,E41/E64*100)","v":0},null,{"$f":"SUM(H27:H40)","v":0},{"$f":"IF(H41=0,0,H41/H64*100)","v":0},null,{"$f":"SUM(K27:K40)","v":0},{"$f":"IF(K41=0,0,K41/K64*100)","v":0},{"$f":"SUM(M27:M40)","v":0},{"$f":"IF(M41=0,0,M41/M64*100)","v":0},0]
[null,null,null,{"$f":"IF(A42=\"\",\"\",VLOOKUP(A42,POOR!C$3:G$81,5,FALSE))","v":""},null,{"$f":"IF($E$56=0,0,E42/$E$64*100)","v":0},null,null,{"$f":"IF($H$56=0,0,H42/$H$64*100)","v":0},null,null,{"$f":"IF($K$56=0,0,K42/$K$64*100)","v":0},null,{"$f":"IF($M$56=0,0,M42/$M$64*100)","v":0},0,null,null,null,null,null,null,null,null,null,"CARBONATE (shaley; clayey; silty, clayey)",null,"43"]
[null,null,null,{"$f":"IF(A43=\"\",\"\",VLOOKUP(A43,POOR!C$3:G$81,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,{"$f":"(E43/$E$64*$U$10+H43/$H$64*$U$9+K43/$K$64*$U$8+M43/$M$64*$U$7)*100/$P$75","v":0},null,null,null,null,null,null,null,null,null,"CARBONATE (ochreous; sandy, ochreous)",null,"44"]
[null,null,null,{"$f":"IF(A44=\"\",\"\",VLOOKUP(A44,POOR!C$3:G$81,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"MARBLE (friable)",null,"49"]
[null,null,null,{"$f":"IF(A45=\"\",\"\",VLOOKUP(A45,POOR!C$3:G$81,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"CHERT – CHERTY CARBONATE (≥ 20% leached chert)",null,"45"]
[null,null,null,{"$f":"IF(A46=\"\",\"\",VLOOKUP(A46,POOR!C$3:G$81,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"CONGLOMERATE – SANDSTONE – ARKOSE (friable)",null,"46"]
[null,null,null,{"$f":"IF(A47=\"\",\"\",VLOOKUP(A47,POOR!C$3:G$81,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"SILTSTONE",null,"56"]
[null,null,null,{"$f":"IF(A48=\"\",\"\",VLOOKUP(A48,POOR!C$3:G$81,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"CEMENTATION (partial)",null,"53"]
[null,null,null,{"$f":"IF(A49=\"\",\"\",VLOOKUP(A49,POOR!C$3:G$81,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"GNEISS – AMPHIBOLITE (friable)",null,"50"]
[null,null,null,{"$f":"IF(A50=\"\",\"\",VLOOKUP(A50,POOR!C$3:G$81,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"GNEISS – AMPHIBOLITE (friable)",null,"50"]
[null,null,null,{"$f":"IF(A51=\"\",\"\",VLOOKUP(A51,POOR!C$3:G$81,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"SCHIST (soft)",null,"55"]
[null,null,null,{"$f":"IF(A52=\"\",\"\",VLOOKUP(A52,POOR!C$3:G$81,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"VOLCANIC (very soft, porous)",null,"48"]
[null,null,null,{"$f":"IF(A53=\"\",\"\",VLOOKUP(A53,POOR!C$3:G$81,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"VOLCANIC (very soft, porous)",null,"48"]
[null,null,null,{"$f":"IF(A54=\"\",\"\",VLOOKUP(A54,POOR!C$3:G$81,5,FALSE))","v":""},null,{"$f":"IF($E$56=0,0,E54/$E$64*100)","v":0},null,null,{"$f":"IF($H$56=0,0,H54/$H$64*100)","v":0},null,null,{"$f":"IF($K$56=0,0,K54/$K$64*100)","v":0},null,{"$f":"IF($M$56=0,0,M54/$M$64*100)","v":0},{"$f":"(E54/$E$64*$U$10+H54/$H$64*$U$9+K54/$K$64*$U$8+M54/$M$64*$U$7)*100/$P$75","v":0},null,null,null,null,null,null,null,null,null,"VOLCANIC (very soft, porous)",null,"48"]
[null,null,null,{"$f":"IF(A55=\"\",\"\",VLOOKUP(A55,POOR!C$3:G$81,5,FALSE))","v":""},null,0,null,null,0,null,null,0,null,0,0,null,null,null,null,null,null,null,null,null,"VOLCANIC (very soft, porous)",null,"48"]
["TOTAL POOR AGGREGATE",null,null,"–",{"$f":"SUM(E42:E55)","v":0},{"$f":"IF(E56=0,0,E56/E64*100)","v":0},null,{"$f":"SUM(H42:H55)","v":0},{"$f":"IF(H56=0,0,H56/H64*100)","v":0},null,{"$f":"SUM(K42:K55)","v":0},{"$f":"IF(K56=0,0,K56/K64*100)","v":0},{"$f":"SUM(M42:M55)","v":0},{"$f":"IF(M56=0,0,M56/M64*100)","v":0},0,null,null,null,null,{"$f":"H72-E72","v":35}]
[null,null,null,{"$f":"IF(A57=\"\",\"\",VLOOKUP(A57,DELETERIOUS!C$3:G$83,5,FALSE))","v":""},null,{"$f":"IF($E$62=0,0,E57/$E$64*100)","v":0},null,null,{"$f":"IF($H$62=0,0,H57/$H$64*100)","v":0},null,null,{"$f":"IF($K$62=0,0,K57/$K$64*100)","v":0},null,{"$f":"IF($M$62=0,0,M57/$M$64*100)","v":0},0,null,null,null,null,null,null,null,null,null,"OCHRE",null,"60"]
[null,null,null,{"$f":"IF(A58=\"\",\"\",VLOOKUP(A58,DELETERIOUS!C$3:G$83,5,FALSE))","v":""},null,{"$f":"IF($E$62=0,0,E58/$E$64*100)","v":0},null,null,{"$f":"IF($H$62=0,0,H58/$H$64*100)","v":0},null,null,{"$f":"IF($K$62=0,0,K58/$K$64*100)","v":0},null,{"$f":"IF($M$62=0,0,M58/$M$64*100)","v":0},0,null,null,null,null,null,null,null,null,null,"SHALE",null,"61"]
[null,null,null,{"$f":"IF(A59=\"\",\"\",VLOOKUP(A59,DELETERIOUS!C$3:G$83,5,FALSE))","v":""},null,{"$f":"IF($E$62=0,0,E59/$E$64*100)","v":0},null,null,{"$f":"IF($H$62=0,0,H59/$H$64*100)","v":0},null,null,{"$f":"IF($K$62=0,0,K59/$K$64*100)","v":0},null,{"$f":"IF($M$62=0,0,M59/$M$64*100)","v":0},{"$f":"(E59/$E$64*$U$10+H59/$H$64*$U$9+K59/$K$64*$U$8+M59/$M$64*$U$7)*100/$P$75","v":0},null,null,null,null,null,null,null,null,null,"CLAY",null,"62"]
[null,null,null,{"$f":"IF(A60=\"\",\"\",VLOOKUP(A60,DELETERIOUS!C$3:G$83,5,FALSE))","v":""},null,{"$f":"IF($E$62=0,0,E60/$E$64*100)","v":0},null,null,{"$f":"IF($H$62=0,0,H60/$H$64*100)","v":0},null,null,{"$f":"IF($K$62=0,0,K60/$K$64*100)","v":0},null,{"$f":"IF($M$62=0,0,M60/$M$64*100)","v":0},0,null,null,null,null,null,null,null,null,null,"CLAY",null,"62"]
[null,null,null,{"$f":"IF(A61=\"\",\"\",VLOOKUP(A61,DELETERIOUS!C$3:G$83,5,FALSE))","v":""},null,{"$f":"IF($E$62=0,0,E61/$E$64*100)","v":0},null,null,{"$f":"IF($H$62=0,0,H61/$H$64*100)","v":0},null,null,{"$f":"IF($K$62=0,0,K61/$K$64*100)","v":0},null,{"$f":"IF($M$62=0,0,M61/$M$64*100)","v":0},0,null,null,null,null,null,null,null,null,null,"VOLCANIC – GNEISS – SCHIST (decomposed)",null,"63"]
["TOTAL DELETERIOUS AGGREGATE",null,null,"–",{"$f":"SUM(E57:E61)","v":0},{"$f":"IF(E62=0,0,E62/E64*100)","v":0},null,{"$f":"SUM(H57:H61)","v":0},{"$f":"IF(H62=0,0,H62/H64*100)","v":0},null,{"$f":"SUM(K57:K61)","v":0},{"$f":"IF(K62=0,0,K62/K64*100)","v":0},{"$f":"SUM(M57:M61)","v":0},{"$f":"IF(M62=0,0,M62/M64*100)","v":0},0]
["CONTAMINANTS (Not included in PN)",null,null,null,null,{"$f":"IF(E63=0,0,E63/E64*100)","v":0},null,null,{"$f":"IF(H63=0,0,H63/H64*100)","v":0},null,null,{"$f":"IF(K63=0,0,K63/K64*100)","v":0},null,{"$f":"IF(M63=0,0,M63/M64*100)","v":0},0]
["TOTALS (with contaminants):",null,null,null,{"$f":"IF(E26+E41+E56+E62+E63=0,0.0001,E26+E41+E56+E62+E63)","v":1E-4},{"$f":"IF(E64=0.0001,0,F26+F41+F56+F62+F63)","v":0},null,{"$f":"IF(H26+H41+H56+H62+H63=0,0.0001,H26+H41+H56+H62+H63)","v":1E-4},{"$f":"IF(H64=0.0001,0,I26+I41+I56+I62+I63)","v":0},null,{"$f":"IF(K26+K41+K56+K62+K63=0,0.0001,K26+K41+K56+K62+K63)","v":1E-4},{"$f":"IF(K64=0.0001,0,L26+L41+L56+L62+L63)","v":0},{"$f":"IF(M26+M41+M56+M62+M63=0,0.0001,M26+M41+M56+M62+M63)","v":1E-4},{"$f":"IF(M64=0.0001,0,N26+N41+N56+N62+N63)","v":0},{"$f":"O26+O41+O56+O62+O63","v":0}]
["% Crushed = ",null,"% GOOD",null," X 1 =",{"$f":"IF(E64=0,\"\",E26/(E64-E63)*100)","v":0},null," X 1 =",{"$f":"IF(H64=0,\"\",H26/(H64-H63)*100)","v":0},null," X 1 =",{"$f":"IF(K64=0,\"\",K26/(K64-K63)*100)","v":0}," X 1 =",{"$f":"IF(M64=0,\"\",M26/(M64-M63)*100)","v":0}]
["Additional Information Below",null,"% FAIR ",null,"X 3 =",{"$f":"IF(E64=0,\"\",E41/(E64-E63)*100*3)","v":0},null,"X 3 =",{"$f":"IF(H64=0,\"\",H41/(H64-H63)*100*3)","v":0},null,"X 3 =",{"$f":"IF(K64=0,\"\",K41/(K64-K63)*100*3)","v":0},"X 3 =",{"$f":"IF(M64=0,\"\",M41/(M64-M63)*100*3)","v":0}]
[null,null,"% POOR",null,"X 6 = ",{"$f":"IF(E64=0,\"\",E56/(E64-E63)*100*6)","v":0},null,"X 6 = ",{"$f":"IF(H64=0,\"\",H56/(H64-H63)*100*6)","v":0},null,"X 6 = ",{"$f":"IF(K64=0,\"\",K56/(K64-K63)*100*6)","v":0},"X 6 = ",{"$f":"IF(M64=0,\"\",M56/(M64-M63)*100*6)","v":0}]
[null,null,"% DELETERIOUS",null,"X 10 =",{"$f":"IF(E64=0,\"\",E62/(E64-E63)*100*10)","v":0},null,"X 10 =",{"$f":"IF(H64=0,\"\",H62/(H64-H63)*100*10)","v":0},null,"X 10 =",{"$f":"IF(K64=0,\"\",K62/(K64-K63)*100*10)","v":0},"X 10 =",{"$f":"IF(M64=0,\"\",M62/(M64-M63)*100*10)","v":0}]
["HOT MIX, CONCRETE & SURFACE TREATMENT PN = ",null,null,null,{"$f":"IF(AND(SUM(F65:G68)=0,E72>=10),\"MUST TEST\",SUM(F65:G68))","v":0},null,null,{"$f":"IF(AND(SUM(I65:J68)=0,OR(E72>=10,H72-E72>=10),H72-E72>0,E72<90),\"MUST TEST\",SUM(I65:J68))","v":"MUST TEST"},null,null,{"$f":"IF(AND(SUM(L65:L68)=0,H76+E76<90,K72>0,OR(K72-H72>=10,H72-E72>=10,E72>=10)),\"MUST TEST\",SUM(L65:L68))","v":"MUST TEST"},null,{"$f":"IF(AND(SUM(N65:N68)=0,E76+H76+K76<90,M72>0),\"MUST TEST\",SUM(N65:N68))","v":"MUST TEST"}]
["Fill in the Cumulative %'s Retained on Each Sieve in the Retained 4.75 mm Portion of the As-Received Sample (i.e. From LS-602)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Weighted Average PN"]
[{"$f":"IF(F9=75, \"R75.0\", \"R53.0\")","v":"R53.0"},"R37.5","R26.5",null,"R19.0",null,null,"R13.2",null,null,"R9.5",null,"R4.75"]
[null,null,null,null,null,null,null,35,null,null,65,null,100,null,{"$f":"(M75*U7+K75*U8+H75*U9+A75*U10)/100","v":{"$error":"#VALUE!"}}]
[{"$f":"0","v":0},{"$f":"B72-A72","v":0},{"$f":"C72-B72","v":0},null,{"$f":"E72-C72","v":0},null,null,{"$f":"H72-E72","v":35},null,null,{"$f":"K72-H72","v":30},null,{"$f":"M72-K72","v":35}]
["R19.0 ",null,null,null,null,null,null,"P19.0/R13.2",null,null,"P13.2/R9.5",null,"P9.5/R4.75",null," PN's Used for Calculations","% of Course Portion of As-Received Sample Tested"]
[{"$f":"IF(E72=0,0,IF(E69>0,E69,IF(H69>0,H69,IF(K69>0,K69,IF(M69>0,M69,0)))))","v":0},null,null,null,null,null,null,{"$f":"IF(H73=0,0,IF(H69>0,H69,IF(AND(E69>0,K69=0),E69,IF(AND(K69>0,E69=0),K69,IF(AND(E69>0,K69>0),(E72*E69+(K72-H72)*K69)/(E72+(K72-H72)),IF(M69>0,M69,0))))))","v":"MUST TEST"},null,null,{"$f":"IF(K73=0,0,IF(K69>0,K69,IF(AND(H69>0,M69=0),H69,IF(AND(M69>0,H69=0),M69,IF(AND(H69>0,M69>0),((M72-K72)*M69+(H72-E72)*H69)/((M72-K72)+(H72-E72)),IF(E69>0,E69,0))))))","v":"MUST TEST"},null,{"$f":"IF(M73=0,0,IF(M69>0,M69,IF(K69>0,K69,IF(H69>0,H69,IF(E69>0,E69,0)))))","v":"MUST TEST"},null,null,{"$f":"IF(SUM(A73:N73)=0,0.0001,IF(E69=0,0,SUM(A73:G73))+IF(H69=0,0,H73)+IF(K69=0,0,K73)+IF(M69=0,0,M73))","v":100}]
[null,null,null,null,{"$f":"IF(OR(E69>0,E69=\"MUST TEST\"),E72,0)","v":0},null,null,{"$f":"IF(OR(H69>0,H69=\"MUST TEST\"),H72-E72,0)","v":35},null,null,{"$f":"IF(OR(K69>0,K69=\"MUST TEST\"),K72-H72,0)","v":30},null,{"$f":"IF(OR(M69>0,M69=\"MUST TEST\"),M72-K72,0)","v":35}]

{"sheet":"GOOD","index":1,"n_rows":62,"n_cols":7,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[]
["GOOD"]
[null,"Rock Type No.","Rock Type Name"]
[null,"1a","CARBONATE (hard)",null,null,null,{"$f":"B4","v":"1a"}]
[null,"1b","CARBONATE (silty, hard)",null,null,null,{"$f":"B5","v":"1b"}]
[null,"20a","CARBONATE (medium hard)",null,null,null,"20a"]
[null,"20b","CARBONATE (silty, medium hard)",null,null,null,"20b"]
[null,"20c","CARBONATE (medium hard, minor shale)",null,null,null,"20c"]
[null,"20d","CARBONATE (surface weathered)",null,null,null,"20d"]
[null,"20e","CARBONATE (silty, surface weathered)",null,null,null,"20e"]
[null,2,"CARBONATE (sandy, hard or medium hard)",null,null,null,2]
[null,21,"CARBONATE (slightly cherty: <5 % chert)",null,null,null,21]
[null,77,"GYPSUM (< 10 % gypsum)",null,null,null,77]
[null,3,"ARENITE SANDSTONE (hard)",null,null,null,3]
[null,22,"ARENITE SANDSTONE (medium hard)",null,null,null,22]
[null,6,"WACKE (hard or medium hard)",null,null,null,6]
[null,16,"ARGILLITE (hard or medium hard)",null,null,null,16]
[null,23,"MARBLE (hard or medium hard)",null,null,null,23]
[null,5,"QUARTZITE",null,null,null,5]
[null,"4a","FELSIC GNEISS (hard)",null,null,null,"4a"]
[null,"4b","INTERMEDIATE GNEISS (hard)",null,null,null,"4b"]
[null,"4c","MAFIC GNEISS (hard)",null,null,null,"4c"]
[null,"14a","FELSIC SCHIST (hard)",null,null,null,"14a"]
[null,"14b","INTERMEDIATE SCHIST (hard)",null,null,null,"14b"]
[null,"14c","MAFIC SCHIST (hard)",null,null,null,"14c"]
[null,"14d","AMPHIBOLITE (hard)",null,null,null,"14d"]
[null,"8a","GRANITE (hard)",null,null,null,"8a"]
[null,"8b","DIORITE (hard)",null,null,null,"8b"]
[null,"8c","GABBRO (hard)",null,null,null,"8c"]
[null,9,"TRAP",null,null,null,9]
[null,"7a","FELSIC VOLCANIC (hard or medium hard)",null,null,null,"7a"]
[null,"7b","INTERMEDIATE VOLCANIC (hard or medium hard)",null,null,null,"7b"]
[null,"7c","MAFIC VOLCANIC (hard or medium hard)",null,null,null,"7c"]
[null,"7d","ULTRAMAFIC VOLCANIC (hard or medium hard)",null,null,null,"7d"]
[null,71,"IRON FORMATION (hard)",null,null,null,71]
[null,71,"IRON FORMATION (slightly weathered)",null,null,null,71]
[null,81,"FLINT/JASPER",null,null,null,81]
[null,80,"Sedimentary Rock:  Sibley Group (hard)",null,null,null,80]
[null,10,"QUARTZ (vein or pegmatitic)",null,null,null,10]
[null,11,"FELDSPAR (vein or pegmatitic)",null,null,null,11]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]

{"sheet":"FAIR","index":2,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
["FAIR","Rock Type No.","Rock Type Name"]
[null,"35a","CARBONATE (soft)",null,null,null,{"$f":"B3","v":"35a"}]
[null,"35b","CARBONATE (silty, soft)",null,null,null,{"$f":"B4","v":"35b"}]
[null,"35c","CARBONATE (slightly shaley)",null,null,null,"35c"]
[null,41,"CARBONATE (soft, pitted)",null,null,null,41]
[null,"42a","CARBONATE (deeply weathered)",null,null,null,"42a"]
[null,"42b","CARBONATE (silty, deeply weathered)",null,null,null,"42b"]
[null,40,"CARBONATE (sandy, soft)",null,null,null,40]
[null,"35c","CARBONATE (slightly shaley)",null,null,null,"35c"]
[null,26,"CHERT-CHERTY CARBONATE (<20 % leached CHERT)",null,null,null,26]
[null,30,"ARENITE SANDSTONE (brittle)",null,null,null,30]
[null,29,"WACKE (brittle)",null,null,null,29]
[null,34,"ARGILLITE (medium soft)",null,null,null,34]
[null,24,"MARBLE (brittle)",null,null,null,24]
[null,"25a","FELSIC GNEISS (brittle)",null,null,null,"25a"]
[null,"25b","INTERMEDIATE GNEISS (brittle)",null,null,null,"25b"]
[null,"25c","MAFIC GNEISS (brittle)",null,null,null,"25c"]
[null,"25a","FELSIC SCHIST (brittle)",null,null,null,"25a"]
[null,"25b","INTERMEDIATE SCHIST (brittle)",null,null,null,"25b"]
[null,"25c","MAFIC SCHIST (brittle)",null,null,null,"25c"]
[null,"25d","AMPHIBOLITE (brittle)",null,null,null,"25d"]
[null,"27a","GRANITE (brittle)",null,null,null,"27a"]
[null,"27b","DIORITE (brittle)",null,null,null,"27b"]
[null,"27c","GABBRO (brittle)",null,null,null,"27c"]
[null,"28a","FELSIC VOLCANIC (soft)",null,null,null,"28a"]
[null,"28b","INTERMEDIATE VOLCANIC (soft)",null,null,null,"28b"]
[null,"28c","MAFIC VOLCANIC (soft)",null,null,null,"28c"]
[null,"28d","ULTRAMAFIC VOLCANIC (soft)",null,null,null,"28d"]
[null,73,"VOLCANIC (glassy)",null,null,null,73]
[null,74,"VOLCANIC (ochreous)",null,null,null,74]
[null,"52a","ENCRUSTATION",null,null,null,"52a"]
[null,"52b","CEMENTATION (partial)",null,null,null,"52b"]
[null,82,"IRON FORMATION (moderately weathered)",null,null,null,82]
[null,83,"Sedimentary Rock:  Sibley Group (medium hard)",null,null,null,83]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]

{"sheet":"POOR","index":3,"n_rows":84,"n_cols":7,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
[]
["POOR","Rock Type No.","Rock Type Name"]
[null,"43a","CARBONATE (very soft)",null,null,null,{"$f":"B3","v":"43a"}]
[null,"43b","CARBONATE (silty, clayey)",null,null,null,{"$f":"B4","v":"43b"}]
[null,"43c","CARBONATE (shaley)",null,null,null,"43c"]
[null,"43d","CARBONATE (clayey)",null,null,null,"43d"]
[null,"43e","CARBONATE (very soft, deeply weathered)",null,null,null,"43e"]
[null,"44a","CARBONATE (ochreous)",null,null,null,"44a"]
[null,"44b","CARBONATE (sandy, ochreous)",null,null,null,"44b"]
[null,56,"SILTSTONE",null,null,null,56]
[null,"44a","CARBONATE (sandy)",null,null,null,"44a"]
[null,"44b","CARBONATE (sandy, ochreous)",null,null,null,"44b"]
[null,"43c","CARBONATE (shaley)",null,null,null,"43c"]
[null,45,"CHERT-CHERTY CARBONATE (≥20 % leached CHERT)",null,null,null,45]
[null,78,"GYPSUM (10-49 % gypsum)",null,null,null,78]
[null,46,"ARENITE SANDSTONE (friable)",null,null,null,46]
[null,97,"WACKE (friable)",null,null,null,97]
[null,86,"ARGILLITE-TUFFITE-SLATE (soft)",null,null,null,86]
[null,49,"MARBLE (friable)",null,null,null,49]
[null,"50a","FELSIC GNEISS (friable)",null,null,null,"50a"]
[null,"50b","INTERMEDIATE GNEISS (friable)",null,null,null,"50b"]
[null,"50c","MAFIC GNEISS (friable)",null,null,null,"50c"]
[null,"55a","FELSIC SCHIST (soft)",null,null,null,"55a"]
[null,"55b","INTERMEDIATE SCHIST (soft)",null,null,null,"55b"]
[null,"55c","MAFIC SCHIST (soft)",null,null,null,"55c"]
[null,90,"SLATE (soft)",null,null,null,90]
[null,"51a","GRANITE (friable)",null,null,null,"51a"]
[null,"51b","DIORITE (friable)",null,null,null,"51b"]
[null,"51c","GABBRO (friable)",null,null,null,"51c"]
[null,53,"CEMENTATION (partial)",null,null,null,53]
[null,54,"CEMENTATION (total)",null,null,null,54]
[null,84,"IRON FORMATION (highly weathered)",null,null,null,84]
[null,85,"Sedimentary Rock:  Sibley Group (soft)",null,null,null,85]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"B66","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]

{"sheet":"DELETERIOUS","index":4,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
["DELETERIOUS","Rock Type No.","Rock Type Name"]
[null,"61c","SHALE",null,null,null,{"$f":"B3","v":"61c"}]
[null,"62c","CLAY",null,null,null,{"$f":"B4","v":"62c"}]
[null,"64a","CARBONATE (very weak)",null,null,null,"64a"]
[null,"64b","CARBONATE (very weak, deeply weathered)",null,null,null,"64b"]
[null,79,"GYPSUM (> 49 % gypsum)",null,null,null,79]
[null,32,"Argillite-Tuffite-Slate (very soft)",null,null,null,32]
[null,59,"MARBLE (decomposed)",null,null,null,59]
[null,63,"GNEISS (decomposed)",null,null,null,63]
[null,65,"SCHIST (decomposed)",null,null,null,65]
[null,91,"SLATE (very soft)",null,null,null,91]
[null,"66a","GRANITE (decomposed)",null,null,null,"66a"]
[null,"66b","DIORITE (decomposed)",null,null,null,"66b"]
[null,"66c","GABBRO (decomposed)",null,null,null,"66c"]
[null,63,"VOLCANIC (decomposed)",null,null,null,63]
[null,87,"IRON FORMATION (decomposed)",null,null,null,87]
[null,60,"OCHRE",null,null,null,60]
[null,88,"Sedimentary Rock:  Sibley Group (very soft)",null,null,null,88]
[null,99,"TALC",null,null,null,99]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]

{"sheet":"Full","index":5,"n_rows":280,"n_cols":3,"rows_kept":280,"cut":false,"hidden":false,"merged":[]}
["Sorted by Geo Type and Quality"]
[]
["SEDIMENTARY ROCKS"]
[]
["CARBONATE, SHALEY CARBONATE, SILTY CARBONATE, SILTSTONE, AND CLAY"]
["GOOD"]
[null,"1a.","Carbonate (hard):  high strength; can be scratched (relatively thin scratch); typically unweathered. "]
[null,"1b.  ","Carbonate (silty, hard):  high strength; can be scratched; (relatively thin scratch); raspy sound when scratched; commonly greenish grey; typically unweathered "]
[null,"1c.","Carbonate (hard, minor shale): generally high strength; can be scratched (relatively thick scratch); see Good Category of Table 1 . Very slightly shaley."]
[null,"20a.","Carbonate (medium hard):  high strength; can be scratched (relatively thick scratch)"]
[null,"20b.","Carbonate (silty, medium hard):  high strength; can be scratched (relatively thick scratch); raspy sound when scratched; commonly greenish grey"]
[null,"20c.","Carbonate (medium hard, minor shale): generally high strength; can be scratched (relatively thick scratch); see Good Category of Table 1 "]
[null,"20d.","Carbonate (surface weathered):  mainly high strength; can be scratched; no more than 33 percent of particle consists of medium to low strength weathered material"]
[null,"20e.","Carbonate (silty, surface weathered):  mainly high strength; can be scratched; raspy sound when scratched; commonly greenish grey; no more than 33 percent of particle consists of medium to low strength weathered material"]
["FAIR"]
[null,"35a.","Carbonate (soft):  medium strength; uniform consistency; can be scratched and scraped with ease; can be peeled with difficulty "]
[null,"35b.","Carbonate (silty, soft):  medium strength; can be scratched with ease and scraped with some difficulty; may contain minor low strength zones which can be scraped with ease; raspy sound when scratched; commonly greenish grey "]
[null,"35c.","Carbonate (slightly shaley):  medium strength; can be scratched with ease and scraped with some difficulty; generally shows grey or brown (sometimes greasy) streak when scratched; see Fair Category of Table 1"]
[null,"41.","Carbonate (soft, pitted):  medium strength; can be scratched with ease and scraped with some difficulty; moderately pitted "]
[null,"42a.","Carbonate (deeply weathered):  more than 33 percent of particle consists of medium to low strength weathered material"]
[null,"42b.","Carbonate (silty, deeply weathered):  more than 33 percent of particle consists of medium to low strength weathered material; raspy sound when scratched; commonly greenish grey "]
["POOR"]
[null,"43a.","Carbonate (very soft): contains between 33 and 75 percent very low strength material; can be scraped and peeled with ease"]
[null,"43b.","Carbonate (silty, clayey):  contains between 33 and 75 percent very low strength material; can be scraped and peeled with ease; raspy sound when scratched"]
[null,"43c.","Carbonate (shaley): low strength; can be scraped with ease and peeled with some difficulty; generally shows grey, brown or black (sometimes greasy) streak when scratched. See Poor Category of Table1."]
[null,"43d.","Carbonate (clayey):  contains between 33 and 75 percent very low strength material; can be scraped and peeled with ease "]
[null,"43e.","Carbonate (very soft, deeply weathered):  contains between 33 and 75 percent very low strength deeply weathered material"]
[null,"44a.","Carbonate (ochreous):  contains between 33 and 75 percent ochreous material"]
[null,"44b.","Carbonate (sandy, ochreous): Carbonate (sandy, ochreous):  contains between 33 and 75 percent ochreous material; contains 5 to 49 percent sand-sized quartz grains"]
[null,"56.","Siltstone:  fissile (tends to separate readily along thin bedding planes on which mica flakes can commonly be seen); medium to low strength; poorly cemented; friable (many pieces can be plucked easily from particle) "]
["DELETERIOUS"]
[null,"61c.","Shale: low to very low strength; can be scraped and peeled with ease; sometimes greasy to touch. Carbonate rock association. See Deleterious Category of Table 1."]
[null,"62c.","Clay:  greater than 75 percent of particle consists of very low strength material; can be peeled with ease and at times can be broken with the fingers or cut completely through; includes kaolin "]
[null,"64a.","Carbonate (very weak): greater than 75 percent of particle consists of very low strength material; can be peeled with ease and at times can be broken with the fingers or cut completely through."]
[null,"64b.","Carbonate (very weak, deeply weathered): greater than 75 percent of particle consists of very low strength material; can be peeled with ease and at times can be broken with the fingers or cut completely through."]
[]
["SANDY CARBONATE"]
["GOOD"]
[null,"2.","Carbonate (sandy, hard or medium hard):  high strength (matrix material may be slightly weaker than quartz grains); can be scratched with some difficulty; raspy sound when scratched; ranges from no weathering to thin surface weathering; contains 5 to 49 percent sand-sized quartz grains "]
["FAIR"]
[null,"40.","Carbonate (sandy, soft):  medium strength; can be scratched with ease and scraped with some difficulty; may contain minor low strength zones which can be scraped with ease; raspy sound when scratched; contains 5 to 49 percent sand-sized quartz grains "]
["POOR"]
[null,"44a.","Carbonate (sandy): low strength; breaks apart when scratched; contains 5 to 49 percent sand-sized quartz grains"]
[null,"44b.","Carbonate (sandy, ochreous):  contains between 33 and 75 percent ochreous material; contains 5 to 49 percent sand-sized quartz grains "]
[]
[]
[]
["SHALEY CARBONATE AND SHALE (See Table 1 for petrographic classification, and Note 10) "]
["GOOD"]
[null,"20c.","Carbonate (medium hard):  high strength; can be scratched (relatively thick scratch)"]
["FAIR"]
[null,"35c.","Carbonate (slightly shaley):  medium strength; can be scratched with ease and scraped with some difficulty; generally shows grey or brown (sometimes greasy) streak when scratched"]
["POOR"]
[null,"43c.","Carbonate (shaley):  low strength; can be scraped with ease and peeled with some difficulty; generally shows grey, brown or black (sometimes greasy) streak when scratched"]
["DELETERIOUS"]
[null,"61c.","Shale:  low to very low strength; can be scraped and peeled with ease; sometimes greasy to touch"]
[null,"Note 10: Scratching the surface of shaley carbonates may produce a bitumen odour; shale seams or laminations may be discernable (see Table 1) or have a mottled appearance when wet, typically light and dark tones usually grey, but also grey brown."]
[]
["CHERT AND CHERTY CARBONATE"]
["GOOD"]
[null,21,"Carbonate (slightly cherty: <5 % chert):  high strength; hard and/or slightly weathered carbonate; particle contains less than 5 percent chert"]
["FAIR"]
[null,26,"Chert-Cherty Carbonate (<20 % leached chert):  particle contains 5 to 100 percent chert.  Of the chert that is present, the leached variety constitutes less than 20 percent of the particle.  Leached chert is absorptive and will generally stick to the tongue."]
["POOR"]
[null,45,"Chert-Cherty Carbonate (≥20 % leached chert):  particle contains 20 percent or more of the leached variety of chert.  Leached chert is absorptive and will generally stick to the tongue."]
[]
["GYPSUM AND ANHYDRITE"]
["GOOD "]
[null,77,"Gypsum (< 10 % gypsum):  less than 10 percent of particle consists of gypsum and/or anhydrite; host rock should be used for particle classification if it is not good aggregate"]
["POOR "]
[null,78,"Gypsum (10-49 % gypsum):  contains between 10 and 49 percent gypsum and/or anhydrite "]
["DELETERIOUS "]
[null,79,"Gypsum (> 49 % gypsum):  contains between 49 and 100 percent gypsum and/or anhydrite "]
[]
[]
["ARENITE SANDSTONES"]
["GOOD"]
[null,3,"Arenite Sandstone (hard):  high strength; cannot be scratched; intact (edges and corners cannot be plucked) "]
[null,22,"Arenite Sandstone (medium hard):  high strength; generally cannot be scratched, although cementing material may be scratched with some difficulty; some edges and corners can be plucked with difficulty "]
["FAIR"]
[null,30,"Arenite Sandstone (brittle):  medium to high strength; generally cannot be scratched, although cementing material may be scratched with moderate ease; brittle (edges and corners can be plucked) "]
["POOR"]
[null,46,"Arenite Sandstone (friable):  low strength; generally poorly cemented; friable (many pieces can be plucked easily from particle) to highly friable (particle crumbles totally when plucked) "]
[]
["WACKE SANDSTONES"]
["GOOD"]
[null,6,"Wacke (hard or medium hard): high strength; can be scratched with difficulty; some edges and corners can be plucked with difficulty"]
["FAIR"]
[null,29,"Wacke (brittle): medium to high strength; can be scratched with moderate ease and scraped with some difficulty; brittle (edges and corners can be plucked)"]
["POOR"]
[null,97,"Wacke (friable): low strength; friable (many pieces can be plucked easily from particle) to highly friable (particle crumbles when plucked)"]
[]
[]
[]
["ARGILLITE-TUFFITE-SLATE "]
["GOOD"]
[null,16,"Argillite (hard or medium hard):  high to very high strength; can be scratched with difficulty"]
["FAIR"]
[null,34,"Argillite (medium soft):  medium strength; can be scratched with moderate ease and scraped with some difficulty"]
["POOR "]
[null,86,"Argillite-Tuffite-Slate (soft):  low to medium strength; can be scratched and scraped with ease; fissile (particle breaks along closely spaced fractures, and shatters when struck by a hammer); generally characterized by length to thickness ratio less than 4 to 1 "]
["DELETERIOUS"]
[null,32,"Argillite-Tuffite-Slate (very soft):  low to very low strength; can be scraped and peeled with ease; very fissile (particle breaks readily along very closely spaced fractures, and shatters easily when struck by a hammer); rusty weathering stains penetrate into the particle; generally characterized by length to thickness ratio greater than 4 to 1"]
[]
[]
["METAMORPHIC ROCKS"]
[]
["NON-FOLIATED METAMORPHIC ROCKS"]
["MARBLE"]
["GOOD"]
[null,23,"Marble (hard or medium hard):  high strength; can be scratched; intact (edges and corners cannot be plucked) "]
["FAIR"]
[null,24,"Marble (brittle):  medium strength; can be scratched with ease and scraped with some difficulty; brittle (edges and corners can be plucked); may have partial to total thin surface weathering "]
["POOR"]
[null,49,"Marble (friable):  low strength; friable (many pieces can be plucked easily from particle) to highly friable (particle crumbles totally when plucked); includes cleavable calcite "]
[]
[null,49,"Marble (friable): low strength; friable (many pieces can be plucked easily from particle) to highly friable (particle crumbles totally when plucked); includes cleavable calcite"]
["DELETERIOUS"]
[null,59,"Marble (decomposed): "]
[]
["QUARTZITE"]
["GOOD"]
[null,5,"Quartzite:  very high strength; cannot be scratched"]
[]
["FOLIATED METAMORPHIC ROCKS - LAYERED"]
["GNEISS"]
["GOOD"]
["Gneiss (hard): mainly very high strength; generally cannot be scratched; minor medium to high strength (e.g., micaceous and chloritic) zones which can be scratched and scraped with some difficulty; may have partial thin surface weathering"]
[null,"4a.","Felsic Gneiss (hard)"]
[null,"4b.","Intermediate Gneiss (hard)"]
[null,"4c.","Mafic Gneiss (hard)"]
["FAIR"]
["Gneiss (brittle): mainly medium to high strength; generally cannot be scratched; brittle (edges and corners can be plucked); minor medium to low strength zones which can be plucked with ease; may have partial to total, thin, surface weathering"]
[null,"25a.","Felsic Gneiss (brittle)"]
[null,"25b.","Intermediate Gneiss (brittle)"]
[null,"25c.","Mafic Gneiss (brittle)"]
["POOR"]
["Gneiss (friable): low strength; friable (many pieces can be plucked easily from particle) to highly friable (particle crumbles when plucked)"]
[null,"50a. ","Felsic Gneiss (friable)"]
[null,"50b.","Intermediate Gneiss (friable)"]
[null,"50c.","Mafic Gneiss (friable)"]
["DELETERIOUS"]
[null,63,"Gneiss (decomposed): very low strength; can be crumbled with the fingers; high mica content; low quartz and feldspar content"]
[]
["FOLIATED METAMORPHIC ROCKS – NON-LAYERED"]
["SCHIST"]
["GOOD"]
["Schist (hard): mainly very high strength; generally cannot be scratched; minor medium to high strength (e.g., micaceous and chloritic) zones which can be scratched and scraped with some difficulty; may have partial thin surface weathering"]
[null,"14a.","Felsic Schist (hard): "]
[null,"14b.","Intermediate Schist (hard):"]
[null,"14c.","Mafic Schist (hard):"]
[null,"14d.","Amphibolite/Amphibolite Schist (hard): "]
["FAIR"]
["Schist (brittle): medium strength; can be scratched with moderate ease; brittle (edges and corners can be plucked); may contain minor more friable zones which can be plucked and scraped with ease"]
[null,"25a.","Felsic Schist (brittle)"]
[null,"25b.","Intermediate Schist (brittle)"]
[null,"25c.","Mafic Schist (brittle)"]
[null,"25d.","Amphibolite/Amphibolite Schist (brittle)"]
["POOR"]
["Schist (soft): low strength; can be scraped and plucked with ease; contains chloritic and/or micaceous zones which can be peeled with ease"]
[null,"55a.","Felsic Schist (soft)"]
[null,"55b.","Intermediate Schist (soft)"]
[null,"55c. Mafic Schist (soft)"]
["DELETERIOUS"]
[null,65,"Schist (decomposed):  very low strength; can be crumbled with the fingers; high mica or chlorite content; low quartz and feldspar content "]
["SLATE"]
["POOR"]
[null,90,"Slate (soft): low to medium strength; can be scratched and scraped with ease; fissile (particle breaks along closely spaced fractures, and shatters when struck by a hammer); generally characterized by length to thickness ratio less than 4 to 1"]
["DELETERIOUS"]
[null,91,"Slate (very soft): low to very low strength; can be scraped and peeled with ease; very fissile (particle breaks readily along very closely spaced fractures, and shatters easily when struck by a hammer); generally characterized by length to thickness ratio greater than 4 to 1"]
[]
[]
["IGNEOUS ROCKS"]
[]
["INTRUSIVE IGNEOUS ROCKS"]
["GOOD "]
["Intrusive Granitoid Textures (hard): mainly very high strength; generally cannot be scratched; minor medium strength (e.g., micaceous and chloritic) zones which can be scratched and scraped with some difficulty; may have partial thin surface weathering"]
[null,"8a.","Granite (hard)"]
[null,"8b.","Diorite (hard)"]
[null,"8c.","Gabbro (hard)"]
["FAIR "]
["Intrusive Granitoid Texture (brittle): mainly medium to high strength; generally cannot be scratched; brittle (edges and corners can be plucked); minor medium to low strength zones which can be plucked with ease; may have partial to total thin surface weathering"]
[null,"27a.","Granite (brittle)"]
[null,"27b.","Diorite (brittle)"]
[null,"27c.","Gabbro (brittle)"]
["POOR "]
["Intrusive Granitoid Texture (friable): low strength; friable (many pieces can be plucked easily from particle) to highly friable (particle crumbles when plucked)"]
[null,"51a.","Granite (friable)"]
[null,"51b.","Diorite (friable)"]
[null,"51c.","Gabbro (friable)"]
["DELETERIOUS"]
["Intrusive Granitoid Texture (decomposed): very low strength; can be crumbled with the fingers."]
[null,"66a.","Granite (decomposed)"]
[null,"66b.","Diorite (decomposed)"]
[null,"66c.","Gabbro (decomposed)"]
[]
["TRAP (INCLUDES VERY HARD BASALT AND FINE-GRAINED DIABASE/GABBRO)"]
["GOOD"]
[null,9,"Trap:  very high strength; faint scratch may be possible; fine grained; dark coloured; unweathered; may contain magnetite, hard epidote, garnet "]
[]
["EXTRUSIVE IGNEOUS ROCKS"]
["VOLCANIC AND METAVOLCANIC"]
["GOOD"]
["Volcanic and metavolcanic (hard or medium hard):  mainly very high strength; generally cannot be scratched; minor medium to high strength zones which can be scratched and scraped with some difficulty; may have partial, thin, surface weathering, non-foliated to weak schistosity; felsic, intermediate through mafic composition"]
[null,"7a.","Felsic Volcanic (hard or medium hard)"]
[null,"7b.","Intermediate Volcanic (hard or medium hard)"]
[null,"7c.","Mafic Volcanic (hard or medium hard): also Mafic Metavolcanic – Greenstone, generally fine grained to aphanitic, non-foliated to weak schistosity discernable; can be scratched with some difficulty (surficial or thin scratch only; deep scratch not possible); some difficulty in producing powder by scratching"]
[null,"7d","Ultramafic Volcanic (hard or medium hard): komatiite"]
["FAIR"]
["Volcanic and metavolcanic (soft): medium strength; can be scratched with moderate ease and scraped with some difficulty; may contain minor low strength zones which can be gouged, non-foliated to moderate schistosity; felsic, intermediate through mafic composition"]
[null,"28a.","Felsic Volcanic (soft)"]
[null,"28b.","Intermediate Volcanic (soft)"]
[null,"28c.","Mafic Volcanic (soft): also Mafic Metavolcanic – Greenstone, medium strength; can be scratched with moderate ease and scraped with some difficulty (deep scratch possible, powder produced by scratching); may contain minor medium to low strength zones; generally foliated with weak to moderate schistosity discernable"]
[null,"28d.","Ultramafic Volcanic (soft): typically weak to moderate levels of alteration, e.g., serpentine, chlorite"]
[null,73,"Volcanic (glassy):  cannot be scratched; conchoidal to semi-conchoidal fracture; includes obsidian"]
[null,74,"Volcanic (ochreous):  contains between 25 and 50 percent ochreous material "]
["POOR"]
[null,"48a.","Volcanic (very soft):  low strength; can be scraped with ease and peeled with some difficulty; may contain up to 75 percent ochre; felsic, intermediate through mafic composition"]
[null,"48b.","Volcanic (porous):  porous; low strength; can be scratched and scraped with ease; may contain up to 75 percent ochre; felsic, intermediate through mafic composition"]
["DELETERIOUS"]
[null,63,"Volcanic (decomposed):  very low strength; can be peeled with ease and crumbled with fingers; felsic, intermediate through mafic composition"]
[]
["TRAP (INCLUDES VERY HARD BASALT AND FINE-GRAINED DIABASE/GABBRO)"]
["GOOD"]
[null,9,"Trap:  very high strength; faint scratch may be possible; fine grained; dark coloured; unweathered; may contain magnetite, hard epidote, garnet "]
[]
[]
["UNIQUE TO SURFICIAL SAND AND GRAVEL DEPOSITS"]
["ENCRUSTATION AND CEMENTATION"]
["FAIR"]
[null,"52a.","Encrustation:  25 percent or more of particle is covered by a coating, usually calcium carbonate "]
[null,"52b.","Cementation (partial): cementations and encrustations form between 5 and 20% of the total particle surface area or total particle volume (whichever is exceeded first), where the host particle is judged to be of good to fair quality. See Table 3."]
[]
["CEMENTATION"]
["POOR"]
[null,53,"Cementation (partial):  a group of particles cemented together, usually by calcium carbonate; one dominant host particle. See Table 3."]
[null,54,"Cementation (total):  a group of particles cemented together, usually by calcium carbonate; no dominant host particle. See Table 3."]
[]
[]
["THUNDER BAY AREA SPECIFIC"]
["FLINT/JASPER AND IRON FORMATION "]
["GOOD"]
[null,71,"Iron Formation (hard):  high strength; cannot be scratched; unweathered "]
[null,71,"Iron Formation (slightly weathered):  mainly high strength; can be scratched with difficulty; less than 5 percent of particle consists of penetrating zones of low to medium strength weathered material which can be scraped or gouged; may have partial to total thin surface weathering (rusty stains)"]
[null,81,"Flint/Jasper:  high strength; cannot be scratched  "]
["FAIR"]
[null,82,"Iron Formation (moderately weathered):  mainly medium to high strength; can be scratched with difficulty; outer crust can be scraped and plucked with difficulty; contains between 5 and 25 percent penetrating zones of low to medium strength weathered material which can be scraped or gouged "]
["POOR"]
[null,84,"Iron Formation (highly weathered):  contains between 25 and 75 percent low strength weathered material which can be scraped or gouged with ease; outer crust containing medium to low strength zones can be scraped and plucked with moderate ease; inner core may have appearance of ochre or pumice "]
["DELETERIOUS"]
[null,87,"Iron Formation (decomposed):  low to very low strength; greater than 75 percent of particle consists of low strength weathered material which can be scraped, peeled or gouged with ease"]
[]
["OCHRE"]
["DELETERIOUS "]
[null,60,"Ochre:  greater than 75 percent of particle consists of ochre "]
[]
[]
["SIBLEY GROUP SEDIMENTARY ROCKS"]
["GOOD "]
[null,80,"Sedimentary Rock:  Sibley Group (hard):  high strength; very difficult to scratch; scratching does not produce powder "]
["FAIR "]
[null,83,"Sedimentary Rock:  Sibley Group (medium hard):  high strength; can be scratched (surficial scratch only; deep scratch not possible); powder produced by scratching "]
["POOR "]
[null,85,"Sedimentary Rock:  Sibley Group (soft):  medium strength; can be scratched with ease (deep scratch possible); powders easily; ranges from scraped with difficulty to scraped with ease "]
["DELETERIOUS "]
[null,88,"Sedimentary Rock:  Sibley Group (very soft):  low to very low strength; can be scraped and peeled with ease "]
[]
[]
["MINERALS"]
["QUARTZ"]
["GOOD "]
[null,10,"Quartz (vein or pegmatitic):  does not include quartzite "]
[]
["FELDSPAR"]
["GOOD"]
[null,11,"Feldspar (vein or pegmatitic):  "]
[]
["TALC "]
["DELETERIOUS "]
[null,99,"Talc:  sectile; greasy to touch "]