Home / Videos / How to calculate a temperature excursion from a data logger (time out of range and degree-hours)
Video · 1:13
How to calculate a temperature excursion from a data logger (time out of range and degree-hours)
Paste a temperature logger export into Cargovate's free cold-chain excursion calculator and get the time out of range, every excursion, the furthest reading and the degree-hours, with the counting method shown so you can check it.
In this video
- 0:00How long, and how far?
- 0:06Paste the logger export
- 0:16The allowed range
- 0:26Time out of range
- 0:35Degree-hours
- 0:49How it counts
More videos
- How to book a multi-leg shipment from China to the UK
- How to track a chilled container and act on a temperature alert
- How your customers send orders and accept quotes in their own portal
- Cargovate in 70 seconds
- Cargovate for freight forwarders
- Cloud, on-premises or air-gapped: choosing how to run Cargovate
- Cargovate for warehouse operators
- Cargovate for fleet operators
- Cargovate for manufacturers
- How to trace a recalled material lot to every unit and shipment
- Incoterms 2020 explained: where risk passes under FOB, CIF, DAP and DDP
- Lot and serial traceability records: could you trace one serial today?
- Preventive maintenance schedule for a fleet: by miles, engine hours or months, whichever comes first
Transcript
The logger shows the load went above its limit. The next questions are how long for, and how far.
Paste the logger export, one reading per line with a time and a temperature, or open the CSV. It runs in your browser. Nothing you paste is uploaded.
Pick the allowed range. Use the one on your product label or contract. The list offers common ranges as a starting point, not as advice.
Calculate, and you get the total time out of range, and every excursion: when it started, how long it lasted, and the furthest reading.
And degree-hours: how far a reading was outside the limit, multiplied by how long it lasted. One hour at two degrees over is two degree-hours. They tell a short, deep spike from a long, shallow drift.
The method is on the page, so you can check the answer. Each reading holds until the next one. A reading exactly on the limit is in range. And a gap longer than three times the usual interval is reported as unknown time, never guessed.
Print it, save it as a PDF, or copy the summary. The link is in the description.