Cold Storage Temperature Excursion Log Worksheet
Every chiller and freezer has bad days: a door left open, a failed compressor, a power cut. This worksheet records each excursion with peak temperature and duration and calculates a degree-minute index so events can be compared and acted on.
| Date | Unit | Setpoint (C) | Upper limit (C) | Peak temperature (C) | Minutes above limit (min) | Degrees over limit (C) | Degree-minutes of abuse | Cause | Product action | |
|---|---|---|---|---|---|---|---|---|---|---|
2.5 | 62.5 | |||||||||
1.8 | 126 | |||||||||
0 | 0 | |||||||||
4 | 720 |
Degree-minutes is a simple severity index: degrees above the limit multiplied by minutes above it. It helps rank events but is not a shelf life or safety determination. Product decisions need an evaluation by a qualified person using time and temperature data for the product.
Connect cold storage alarms to lot holds
Optional review of linking monitoring alarms to ERP inventory status and lots.
Optional. The tool and every export work without this. No spam.
How to use it
Add a row for every event where a unit exceeded its upper limit, or where an alarm triggered. Enter the setpoint, the limit from your cold chain procedure, the peak reading, and the minutes spent above the limit from your data logger. The sheet calculates degrees over limit and degree-minutes. Choose the cause and the product action. Export to Excel to trend excursions by unit, season or shift.
- Use logger data, not memory, for peak and duration
- Record the limit that applies to the stored product
- Include events that returned to range quickly
- Link held product to the lot in your inventory system
Reading degree-minutes
Degree-minutes equals the number of degrees above the limit multiplied by the minutes above it. A freezer that peaks 2.5 degrees above its limit for 25 minutes scores 62.5. It is a quick severity index, useful for ranking and trending, not a replacement for a product-specific risk assessment. Frozen product that stayed hard frozen can often be assessed differently than chilled product that exceeded 5 C for hours.
Common mistakes
Only logging events that reach a product reject, which hides the near misses that predict the next failure. Also using an air temperature reading to judge product core temperature without checking. Review recurring causes: repeated door-open events point to dock procedures, repeated defrost peaks point to control settings, and sensor faults point to calibration and maintenance gaps.
Frequently Asked Questions
What temperature limits should I use?
Use the limits in your procedure and customer specification. Chilled food is commonly held at or below 5 C and frozen food at -18 C or colder, but regulations and contracts differ. Do not rely on this tool for limits.
Is a defrost peak an excursion?
It depends on your procedure. Some plants define a tolerance for defrost cycles in air temperature that does not reach product. If you exclude them, state it in the procedure and record the logic.
How do I decide what to do with affected product?
Evaluate product type, core temperature if measured, duration, packaging and microbiological risk, and make a documented decision. Involve a qualified person. When data is missing, the conservative decision is to reject or reprocess if possible.
How long should I keep excursion records?
Follow your regulation, customer and scheme requirements. Keep them at least as long as the shelf life of the product plus a margin, and often at least two years.
If your storage units already log to a monitoring system, we can help pull events into one view and tie them to lots held in your ERP.
Related Tools
CCP Monitoring Log Worksheet
Log every critical control point reading, calculate the margin to the lower and upper critical limit, and export the record to Excel.
Quality & InspectionFood Safety Corrective Action Report Template
A fill-in corrective action form for CCP deviations and food safety nonconformances, with product disposition, root cause and verification.
Industry TemplatesFood Product Specification Sheet Template
A fill-in specification sheet for finished food products or ingredients: composition, limits, allergens, shelf life, storage and packaging.
Quality & InspectionPasteurization and Sterilization Lethality F-Value Calculator
Calculate lethal rate, F-value, log reductions and the hold time needed to hit a target for a constant-temperature thermal process.
More Supply Chain & Inventory tools
See all- Oracle Fusion Inventory Turns and Carrying Cost Calculator
- Distribution ERP Fill Rate Calculator
- Distributor Rebate Tracking Worksheet
- Branch Transfer Planning Worksheet
- Distributor Slow-Moving Inventory Review Worksheet
- Distributor Vendor Performance Scorecard Worksheet
- Distributor GMROI Calculator
- Distributor Backorder Cost and Fill Rate Calculator
- EOQ with Vendor Minimum Order Calculator