{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":[" ","Atterberg Limits","Lab Results"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":" ","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Atterberg Limits","index":1,"n_rows":69,"n_cols":10,"rows_kept":69,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Atterberg Limits Test Data"]
[]
[]
["Within this spread sheet are a typical set of measurements for Plastic Limit. Note that because three of the soils will not roll into the standard"]
["three millimeter thread, they fail to demonstrate plastic behavior and no further measurements of liquid limit and swell potential are needed."]
["The Plastic Limit test is performed in duplicate and the mean of two determinations is reported with no decimal places."]
[]
["One set of Liquid Limit measurements are included for the Table Mountain Soil.  Liquid limits for the remaining soils were obtained from the literature."]
[]
[]
[]
["Golden Area Soils - Plastic Limit Data"]
[]
[]
[]
[null,"Table Mt",null,"Laramie",null,"Denver",null,"Crawford Gulch","Lookout Mt","Fountain/Lyons"]
[null,"#1","#2","#1","#2","#1","#2"]
[]
["beaker (g)",1.8177,1.7931,1.7578,1.7969,1.809,1.8161,"will not roll","will not roll","will not roll"]
[{"$nulls":7},"no further tests","no further tests","no further tests"]
["wet soil + beaker",8.3861,8.9548,8.2391,9.757,7.9454,7.7094]
[]
["dry soil + beaker",7.289,7.74,7.1907,8.4873,6.9527,6.7288]
[]
[]
["wt soil (g)",5.471299999999999,5.9469,5.4329,6.6903999999999995,5.1437,4.912699999999999]
[]
["wt water (g) ",1.097100000000001,1.2148000000000003,1.0484000000000009,1.2697000000000003,0.9927000000000001,0.9805999999999999]
[]
["%water at plastic limit",20.051907224973977,20.42744959558762,19.29724456551751,18.977938538801872,19.299337053094078,19.960510513566877]
[]
[]
["North Table Mountain - Liquid Limit Data"]
[]
[]
[null,"Table Mt"]
[null,"#1","#2","#3","#4","#5"]
[]
["beaker (g)",1.7877,1.7598,1.7452,1.8451,1.7856]
[]
["wet soil + beaker",3.6241,3.7916,4.4752,4.7776,3.3629]
[]
["dry soil + beaker",3.2062,3.1878,3.5793,3.733,2.7441]
[]
[]
["wt soil (g)",1.4184999999999999,1.4280000000000002,1.8340999999999998,1.8879000000000001,0.9584999999999999]
[]
["wt water (g) ",0.41789999999999994,0.6037999999999997,0.8959000000000001,1.0445999999999995,0.6187999999999998]
[]
["%water",29.460697920338387,42.28291316526608,48.8468458644567,55.33132051485775,64.55920709441834]
[]
["Number of Device Blows",90,60,45,35,20]
[]
[null,"Liquid Limit read from graph at 25 blows = 60%"]
[]
["Plasticity Index and Swell Potential"]
[]
[null,"Table Mt",null,"Laramie",null,"Denver"]
[]
["Plastic Limit (%)",20,null,20,null,19]
[]
["Liquid Limit (%) ",60,null,"80*",null,"70*"]
[]
["PI (LL-PL)",40,null,60,null,51]
[]
["Swell Potential","High",null,"High",null,"High"]
[]
[]
["* From Noe and Dodson (1999)"]

{"sheet":"Lab Results","index":2,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[null,"Mineralogy and Engineering Properties of Soils in the Golden Area"]
[]
[]
[]
["Unit","Rock Type","Development Site","Bulk Mineralogy","Clay Suite","Plasticity Index","Swelling Potential","Lime Need"]
[]
["Pre-Cambrian","Gneiss","Lookout Mt","Qz, plag, mica","S, I, K","NA ","No - insufficient smectite","NO"]
[{"$nulls":6},"cannot determine plastic limit"]
[]
["Pre-Cambrian","Schist","Crawford Gulch","Qz, plag, mica","K, mica","NA","No - no smectite","NO"]
[{"$nulls":6},"cannot determine plastic limit"]
[]
["Fountain/Lyons (Pfl)","Feldspathic SS &","Canyon Pt and","Qz, Kspar, mica","K, I","NA","No - no smectite","NO"]
[null,"Quartzoze SS","Beverley Heights",null,null,null,"cannot determine plastic limit"]
[]
["Laramie (Kl)","Volcaniclastics &","Rooney Rd","Qz, clays","S, I, K",60,"High","YES"]
[null,"Mudrocks","Green Mt"]
[]
["Denver (Kd, Td)","Matrix-rich SS","Rooney Rd","Qz, plag, Kspar, mica","S, I, K",51,"High","YES"]
[null,null,"Green Mt"]
[]
["Table Mt (Ti)","Basalt (63my)","North Table Mt.","Plag, pyx, mica","S, I (tr.), K (tr.)",40,"High","YES"]
[]
[]
["S - smectite group clay",null,null,null,"NA - cannot complete tests, see notes in Atterberg Limits File"]
["I - Illite (polytype not distinguished)"]
["K-Kaolinite"]