RESEARCH & CITIZEN SCIENCE · PLAN, COMPARE, EXPORT

Sample Custody Timeline

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

Local calculationsEditable projectsCSV & reports
  1. 1Explore the example
  2. 2Edit your assumptions
  3. 3Compare & export

Loading the worked example…

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. Review the preloaded example and the model limits before entering real data.
  2. Adjust gap to flag (hours).
  3. Edit the sample id rows or import a CSV using the Input CSV column template.
  4. Open Results & chart to inspect details, sort columns and filter rows.
  5. Capture alternative scenarios, then download a project, result CSV or printable report.

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