Worldscale Data Freshness: Check Two Different Clocks

Key takeaways

• Keep the observation date separate from reference applicability.
• Preserve the reference that belongs to a historical indication.
• Reassess applicability when the voyage description or relevant timing changes.
• Use authorised current material for live calculations.
• Identify which part of the calculation is stale rather than replacing every input indiscriminately.

Separate the commercial clock from the reference clock

The commercial clock concerns when an indication was observed and whether its associated offer or market context remains relevant. The reference clock concerns which material applies to the calculation being made.

Neither clock can stand in for the other. A newly received message does not confirm that the analyst selected the right reference. A current reference does not turn an old commercial observation into terms available today.

Record both explicitly. The desk should know the status of the indication and the applicable reference basis before presenting the monetary output as a current comparison.

This is also why a single spreadsheet refresh date is insufficient. It may show when the file was saved without showing whether either underlying basis was checked.

Apply the reference's actual timing rules

Worldscale's Part B provides effective-date treatment for its edition and separately notified amendments. Use the applicable text for the actual voyage. Worldscale Preamble Part B

The analyst should not invent a simple rule that the latest file always applies. Nor should it retain an old reference merely because the commercial discussion began earlier. Establish the correct basis through the relevant material and agreed terms.

If the voyage timing changes, ask whether that affects reference applicability. The answer needs to come from the actual rules and circumstances, not from an assumption that every date change matters or that none does.

Retain the evidence of the determination in the authorised record. The purpose is reproducibility: another qualified reviewer should be able to understand why the selected reference was used.

Keep a refreshable dual-basis record

For a current transaction, the current commercial indication and its status are not provided; obtain current verified information. The confirmed reference applicability is not provided; obtain current verified information. The unresolved update or timing question is not provided; obtain current verified information. Authorised licensed material and actual counterparty records should supply these fields; unavailable public data is a transparent valid status.

The record should distinguish a missing input from a confirmed absence of an item. Leaving an adjustment unresolved is different from establishing that it does not apply.

Do not modernise history accidentally

A historical indication should retain the basis that explains what it meant at the time. Replacing its reference with a current value can change the monetary interpretation without changing the original commercial observation.

A restated comparison can be useful if the desk wants to apply several observations to one chosen basis. Label it clearly as an analytical exercise and preserve the original view alongside it.

Do not present the restated result as the amount that was actually quoted or paid historically. The purpose and assumptions differ.

This distinction matters when explaining a trend. The desk should identify whether a movement comes from the commercial indication, the reference basis or the method of restatement. Otherwise a reader may attribute a calculation change to the market.

Fictional case: the historical tab changes after an update

A fictional analyst updates a shared reference input used by both a current enquiry and an archived comparison. The current calculation may need the new input, but the historical tab also changes because both worksheets point to the same cell.

The report now shows a different monetary amount for the earlier observation. The desk initially describes the difference as a correction to the historical rate record.

A review finds that the original observation was not wrong. Its reference context had been overwritten. The team restores the historical basis, preserves the current calculation separately and labels any common-basis restatement as a new analytical view.

The lesson is that updating a source can create stale meaning elsewhere in a workbook. Freshness is not achieved by making every sheet use the newest input; each calculation needs the basis appropriate to its purpose.

Recheck applicability after a voyage change

The proposed movement can evolve after the first indication. A port alternative may be selected, the relevant timing may shift, or the parcel basis may be revised. Each change should be assessed for its effect on the calculation.

Ask which inputs remain valid and which require confirmation. Avoid restarting every check after an immaterial update, but do not assume a familiar route label makes the previous reference automatically applicable to the revised movement.

If the change affects the commercial offer as well as the reference, keep both revisions visible. A new indication and a new reference can move the monetary result together. The desk should not report only one of those changes.

The completed update should describe one coherent proposal. Do not combine the earlier indication's favourable conditions with the revised movement's reference unless that combination is actually supported.

State what the current number can support

A current observation can provide market context without being a firm offer. A confirmed reference can support arithmetic without establishing the commercial status of the indication. A completed freight calculation can still be insufficient for vessel earnings analysis.

State the output's purpose in the report. Is it a historical explanation, an indicative comparison or an assessment of available terms? The evidence requirements follow from that purpose.

Where an input remains unresolved, show the limitation precisely. For example, the monetary result may be provisional pending reference confirmation, while the original commercial observation remains valid as recorded.

Do not use a broad disclaimer to conceal which fact is missing. Identifying the actual gap allows the desk to obtain the needed evidence and continue work that does not depend on it.

Make refresh responsibility specific

Assign the commercial indication to the role that can confirm its status and the reference question to a person with the appropriate authorised access and competence. A single coordinator can assemble the result without pretending to originate every input.

Record the confirmation date and the scope of what was checked. A reviewer should not infer that a full calculation was revalidated when only one item was updated.

Once the current basis is established, preserve it with the decision record. That supports later explanation without requiring the team to recreate the calculation from whichever reference happens to be current then.

Common mistakes

One mistake is using the latest reference for every historical observation. Another is treating a recent indication as proof that all calculation inputs remain applicable.

A third error is overwriting a shared reference cell and unintentionally changing archived results. Finally, do not describe a provisional conversion as an executable quote when the underlying commercial status remains uncertain.

Where Zeaclub fits

Zeaclub provides a multi-party shared workspace for owners, charterers, brokers and port agents.

Zeaclub offers digitalised procedures across the voyage workflow.

Explore Zeaclub

Explore Zeaclub