TRACE EACH SAMPLE

Sample Custody Timeline

Organize sample handling events chronologically and flag missing collection records or ambiguous timestamps.

Local calculationsEditable projectsCSV & reports
  1. 1Log your events
  2. 2Read the answer as you type
  3. 3Download or print it

Loading the worked example…

Assumptions

Results update as you type. Example figures are illustrative.

Your working data

Edit cells directly or import a CSV. Download “Input CSV” for the required column names. Up to 200 rows; scroll the table sideways for additional fields.

What this model includes

Local descriptive log, not a signed or tamper-proof chain of custody. All timestamps must share one time zone; daylight-saving changes are not modeled.

Import and save safely

CSV imports use your current assumptions. Project files restore assumptions, rows and saved scenarios. No automatic saving: download a project before closing this page. Imports are limited to 10 MiB and 200 rows. Calculations run in your browser; the site’s advertising and analytics follow its privacy policy.

Using Sample Custody Timeline

Organize sample handling events chronologically and flag missing collection records or ambiguous timestamps.

  1. Set gap to flag (hours).
  2. Add one row for each custody event in the table.
  3. Read the chronology beside your table, then download the result.

Example

The worked example includes S1, S1, S1.
Change the first gap to flag (hours) setting and compare the result with a saved baseline.

Questions & answers

What does Sample Custody Timeline calculate?

Organize sample handling events chronologically and flag missing collection records or ambiguous timestamps.

What are the important limitations?

Local descriptive log, not a signed or tamper-proof chain of custody. All timestamps must share one time zone; daylight-saving changes are not modeled.

Can I continue my work later?

Yes. Save a project JSON file and reopen it with Import CSV / project. It contains the working data, assumptions and up to four scenarios. Nothing is saved automatically.

What CSV columns do I need?

sample, date, minute, event, holder, location. Download Input CSV for a compatible example. CSV imports keep your current assumptions.

Are these example figures current industry benchmarks?

No. They are illustrative values to demonstrate the model. Replace them with figures appropriate to your situation.

Help improve this tool

Report a problem or suggest an improvement

Describe the issue without pasting private tool input. Feedback goes to our admin inbox.

Find another tool · Read practical guides