Keep the plan and the result distinguishable
A formula describes what you intended to make. A batch record describes what you actually made on a particular occasion. An evaluation record describes what you noticed afterwards. Connecting all three lets you investigate a difference without guessing which version, bottle or preparation was involved.
The format can be a notebook, spreadsheet or a suitable tool. The essential feature is a clear link between records. A beautifully formatted formula is not a complete batch record if you cannot tell whether the recorded amounts were targets or actual measurements.
Records support a workflow; they do not validate a product
A complete record helps you repeat and review your work. It does not, by itself, demonstrate safety, regulatory compliance or fitness for a finished use.
Give each formula version a distinct identifier and each physical preparation its own batch or sample identifier. A small change still deserves a new version when you want to compare it later. Keep the previous version available instead of overwriting it.
Write the identity fields before starting
Begin with a short purpose statement: what is this batch meant to answer? Then copy the exact material identities into the record. Include the supplied strength or grade where relevant, and link any prepared dilution to its own preparation record. A product name without that context may not describe the material that was actually used.
- Name the formula version and the batch.Use two fields. For example, Study-W01-v2 identifies the plan and W01-v2-B03 identifies this particular preparation.
- State the basis and units.Keep the same measurement basis throughout the planned formula and the actuals. Do not mix percentages, mass and volume without an explicit, reviewed conversion method.
- Record the materials selected.Capture the full product name, supplier and bottle or lot reference where available. Record a substitution as a change, not as the original ingredient.
- Record the context.Add the date, person preparing it, relevant equipment identifier and any process details needed to understand the preparation.
Identifiers in this article are illustrative. They are not a required numbering system. Choose a system that remains readable in your own records and does not rely on a filename that changes whenever it is edited.
Record what happened, not what you hoped happened
Keep target and actual amounts in separate columns. Enter actual values as you work using your established measurement procedure. If something deviates, record the deviation and the decision you made. Do not quietly replace an actual value with the target to make the sheet look tidy.
Scroll sideways to see every column when needed.
| Material identity | Target | Actual | Reference / comment |
|---|---|---|---|
| Exact supplied product + strength | Planned amount | Measured amount | Bottle ID and any deviation |
| Prepared sample, if used | Planned amount | Measured amount | Linked preparation record |
| Total | Planned total | Recorded total | Explain unresolved difference |
If an unexpected result makes the identity or composition uncertain, flag the batch. A later note should distinguish “known deviation” from “unknown cause”. That difference matters when deciding whether a comparison is still useful.
When working digitally, make the final batch record a separate dated record rather than leaving it as an editable copy of the formula master. If you correct a transcription mistake, retain a dated note of the correction and why it was made.
Close the record before judging the scent
At the end of preparation, check that the physical sample identifier matches the record and that every selected material has an entry. Note unresolved questions before they become assumptions. Then connect the batch to a separate observation page.
A useful closing note
Link the version to the question
“W01-v2-B03 prepared for a side-by-side comparison with W01-v1-B02. One recorded deviation needs review before interpreting the comparison. Observation page: OBS-014.”
This example shows traceability, not a recommended formulation or a technical approval.
When you create the next formula version, write why. “Changed after observation OBS-014” is more useful than “improved”. Keep the observation, the decision and the new plan linked, even if the next version does not perform as you expected.
Before the next session, try a simple reconstruction check: could you identify the exact version and materials from the record alone? If not, improve that field now. The best batch record is one that removes avoidable ambiguity when you return to the work.