Chapter7_readme.pdf

Digital datasets for Chapter 7 IN-SITU TESTING J. A. Knappett (2010)

This document and its associated spreadsheet (‘Chapter7_DigitalData.xls’) accompanies Craig’s Soil Mechnics, 8th Edition (J.A. Knappett & R.F. Craig).

The spreadsheet Chapter7_DigitalData.xls consists of five worksheets supporting the worked examples in the Main text (including both the digital data and interpretation) and a further five worksheets containing the digital data required for the problems at the end of the chapter (no interpretation). •

Example 7.1: data from FVT tests in soft sensitive clay (cu, St, OCR).

•

Example 7.2: data from SBPM test in stiff overconsolidated clay (σh0, cu, G).

•

Example 7.3: data from SBPM test in sand (σh0, u0, σ′h0, φ′max, ψ).

•

Example 7.4: data from CPTU test in soft normally consolidated clay (Nkt, cu, OCR).

•

Example 7.4: data from CPTU test and SPT tests in layered soil, sand over clay (ID, φ′max, cu).

In each of the worksheets, the raw data from the test is shown in black type, while calculations which have been entered into the spreadsheet to process the data are shown in red type. Charts plotted using the processed data and necessary for test interpretation are also shown in the worksheets. In the instructor version of the spreadsheet, the problem worksheets include fully-worked digital solutions implemented within the worksheets. The inclusion of these digital datasets extends the basic theoretical material in the text by demonstrating how spreadsheets may be effectively used in engineering practice to analyse the large volumes of data from real sites. It should be noted that all of the worked examples and problems are based on real site data reported in the literature, and is therefore as close to engineering practice as possible. Other benefits include: •

For direct learning: Users may investigate the spreadsheets freely to determine how the analytical approaches described in the main text may be implemented for large datasets.

•

For teaching support: instructors may provide students with their own real datasets – the data can then be processed using these worksheets as a guide. Based on the author’s personal experience, this can considerably enrich coursework exercises and better prepares students for their subsequent careers.

The sheets are protected to prevent accidental over-typing of formulae which may affect the functionality of the spreadsheet. However, the protection is not password protected and may be removed (Tools > Protection > Unprotect Sheet… in Microsoft Excel) if users wish to modify the worksheets.