Selection	Action
Open	Default - user input expected, but not required.
Open	“Data Not Supplied” reported as value.
Open	Default - user input expected, but not required.
Open	“Data Not Supplied” reported as value.
Open	Default - No action required
Open	User input is required to satisfy a reporting requirement.

• The full list of equipment items used on the worksheet can be found below.

• Data entry requirements for equipment are as follows.

Selection	Action
Open	Default - only one Plate equipment item available on worksheet.
Open	Adds an additional Plate equipment item to worksheet.

• A checkbox is provided to allow the use of a second plate.

• This second plate is sometimes used on top of the test plate to ensure stiffness of the plate. E.g. a 600mm plate could have a 450mm plate on top.

Open

• The diameter and mass of the plate used can be imported from the selected equipment item or entered manually.

• Area is automatically calculated from the diameter.

Open

• The mass of the jack used can be imported from the selected equipment item or entered manually.

Open

A load cell can either provide a direct reading in units of force (e.g. kN), or an indirect reading (e.g. gauge divisions or volts) that requires a conversion factor to convert the reading into force units.

The worksheet provides for the following options:

• A load cell is expected to be selected from the equipment list but can be left without making a selection.

• If a load cell is not selected, Factor is available for numeric data entry.

• If a load cell is selected, a value for Factor will be imported, if available.

• If a load cell is selected and Factor is blank, the readings will be assumed to be direct readings in kN.

• If not a direct reading, Factor is still available for numeric data entry.

• A value of 1 for Factor will also provide the direct reading result.

Open

This is the combined mass of any additional equipment used that should be considered as part of an initial load. This may include all spacers used as well as the load cells and/or displacement gauges (if desired).

Open

The worksheet provides data recording for three displacement gauges for recording the deformation of soil during testing.

A displacement gauge can either provide a direct reading in mm, or an indirect reading (gauge divisions) that requires a conversion factor to convert the reading into mm.

The worksheet supports the following options:

• A displacement gauge is expected to be selected from the equipment list but can be left without making a selection.

• If a displacement gauge is not selected, Factor is available for numeric data entry.

• If a displacement gauge is selected, a value for Factor will be imported, if available.

• If a displacement gauge is selected and Factor is blank, the readings will be assumed to be direct readings in mm.

• If not a direct reading, Factor is still available for numeric data entry.

• A value of 1 for Factor will also provide the direct reading result.

Open

If the average initial seating reading is not zero, a checkbox is provided to allow the initial reading to be automatically subtracted from the various settlement readings.

Selection	Action
Open	Default - No action required
Open	The average initial seating reading will be subtracted from settlement readings.

Open

• Each load increment is required to have at least two rows of measurements for settlements.

• The worksheet initially provides three rows at one minute intervals, with the first row’s Elapsed Time set at “0”.

• Additional rows may be added through the use of the plus button under the final row of measurements.

• Any newly added row will get an automatically populated time of one minute more than the previous row.

• It is possible to modify the Elapsed Time of any row after the first row. New values must be whole numbers.

• Any row, after the second row, may be deleted through the use of a delete button next to each row.

The following equipment items can be selected on the worksheet: