Skip to content
GeoEQ · Geotechnical software research lab · University of Utah

Documentation / Reference

GeoEQ SPT Logs tips and FAQ: refusal, water marker, N scale

Applies to 1.0 and later · current 1.2 2 min read

Short answer

Most questions come down to a few settings: the water marker follows the number in the Water RL header field, refusal is typed as 50/75 in the increment cell, and values past the N-value scale are capped at 50 by default until you change Values past the scale in Project settings.

50/75
refusal notation: 50 blows for 75 mm
0 to 70
default N-value graph scale
50
default cap for N past the scale

Why did my water marker not move?

The marker follows the number in the Water RL field of the Header tab. An entry such as (-) 5.0 places it 5.0 m below the ground surface (EGL). Edit that field and the sheet redraws. If the field has no number, the borehole’s stored groundwater depth is used. See Header and groundwater.

What happens when two samples share one depth?

When a split spoon sample (D) and a Shelby tube sample (UD) are taken at the same depth, the sheet shows a single merged row. It takes the UD identity, the SPT blows from the drive and the combined lab values, so the depth is not drawn twice.

How do I record refusal in cemented ground?

Type the driller’s notation straight into the 15 cm increment cell. 50/75 means 50 blows for 75 mm. The sheet prints 8-15-50/75, and the N column shows the notation instead of a number nobody measured. On the N-value graph, the profile breaks to a refusal marker at full scale rather than drawing a point as if the test finished.

How refusal reads in the N column (50/75, >50, Ref or R) is a project choice, under Refusal shown as in Project settings. Note that R is also the Rock stratum symbol, so it can read two ways on a sheet that contains rock. See SPT and samples.

Why is an N-value greater than the scale drawn at 50?

By default values past the N-value scale are capped at 50 on the graph, as in version 1.0. In Project settings, Values past the scale can change that to a refusal marker at the edge, or extend the scale to fit. The printed value always keeps the real number. The default scale runs 0 to 70, and you can set your own full scale or have it fit the data automatically.

Will files from an older version still open?

Yes. Project files from earlier versions open unchanged. They are upgraded in memory and saved in the new format. See Project file format.

Can I paste data from Excel?

Yes. The input tables accept Excel-style copy and paste, which suits a single block of rows. For a whole file of data, use Import Excel and CSV.

Is there a sample project to try?

Yes. Choose File, Open demo project for a complete borelog imported from a real field workbook. It includes BH-02, a shallower hole through a cemented layer that shows refusal at 50/75 and 50/50.

Where can I read more?

The glossary explains the terms used here: SPT, N60, RQD and USCS. To log a borehole from start to finish, follow the tutorial on creating a boring log.

Step-by-step tutorials

Frequently asked questions

Why did my water marker not move?

The marker follows the number in the Water RL header field. An entry such as (-) 5.0 places it 5.0 m below the ground surface (EGL). Edit that field and the sheet redraws.

How do I record refusal in cemented ground?

Type the driller's notation straight into the increment cell, for example 50/75 for 50 blows for 75 mm. The sheet prints 8-15-50/75, the N column shows the notation, and the profile breaks to a refusal marker at full scale.

Why is an N-value above 50 drawn at 50?

By default the graph caps values at 50, as in version 1.0. In Project settings, Values past the scale can instead mark a refusal or extend the scale. The printed value always keeps the real number.

Will files from an older version still open?

Yes. Project files from earlier versions open unchanged. They are upgraded in memory and saved in the new format.