How can a notebook support a later data table?

Structure entries for transfer

Write one measurement per line and keep the same labels across visits. A useful line can include date, site, station, time, variable, value, unit, and instrument ID. Not every project needs every field, but the chosen set should remain stable enough that values can be compared and transcribed without guesswork.

For example: “2026-10-28 | CW03 | P2 | 09:14 | water temperature | 12.4 | °C | TP-2.” This compact format keeps the value beside its meaning. If a measurement has extra context, add a separate note linked by an entry code rather than crowding the data line.

Keep categories consistent

Use the same variable names, site codes, and unit conventions throughout the notebook. If terminology must change, record a mapping, such as “pool temperature” renamed “water temperature” in the later table. Avoid using one label for different methods; a surface reading and a reading at depth may need distinct fields or a depth column.

Mark missing and failed values with defined terms. A dash could mean not measured, unavailable, or not applicable, so spell out the status or use a project code with a key. This prevents a blank or symbol from being interpreted differently by the person building the table.

Retain the source pointer

When transcribing, include a stable link back to the original entry: notebook identifier, page, and line or observation code. For example, the table can carry “CW-12, p. 8, line 4.” If a value later looks unusual, the pointer lets someone check the original wording, units, and surrounding context.

Preserve raw observations separately from calculated fields. If a table contains a converted value or average, label it as derived and retain the original reading and calculation method. This makes the table useful for analysis while keeping its lineage visible.

Check the transfer

After entering a page, compare the table with the notebook, paying attention to decimal points, signs, units, and site labels. Recheck unusual values and any corrected entries. If a correction is made, document it so the history does not vanish.

A table-ready notebook is not necessarily a rigid form. It is a record whose labels and links make each value understandable, traceable, and ready to reuse.

Have a correction or a source to suggest? Send a note →