Cold-chain exceptions and follow-up
Track measurement exceptions and open actions against the site’s own limits.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Alt limit farkı
- 0
- Üst limit farkı
- 2.53
- Açık süre aşımı (dk)
- 4.19
Who can use it, and for what?
Quality and shift teams
Track measurement exceptions and open actions against the site’s own limits.
A worked example from the workbook
The first sample row in the baseline has the following results. Alt limit farkı 0, Üst limit farkı 2,4, Açık süre aşımı (dk) 8, Aksiyon süresi farkı (dk) -6. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Alt limit farkı | 0 |
| Üst limit farkı | 2.53 |
| Açık süre aşımı (dk) | 4.19 |
| Aksiyon süresi farkı (dk) | -6.06 |
How do you start with your own data?
- Start with Kılavuz (Guide). Replace the 16 fictional entries in the yellow cells on Veri (Data). Use an Excel date, a unique record ID and a branch or category. There are 64 ready-to-use input rows.
- Enter limits from your own facility procedure. Authorised staff confirm action closure. The workbook records exceptions and follow-up, with release decisions handled by the facility.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Takip süresi (dk)”. The sample settings are 30 / 15 / 60. Changing the scenario preserves source records.
- Panel shows the three cases and the group breakdown for the selected case. On Hesap (Calculations), check input flags and row-level decisions. To rename a group, use the same name on Settings and Data.
Workbook input fields
Labels appear in Turkish in the workbook.
- Ölçüm sıcaklığı
- Yerel alt limit
- Yerel üst limit
- İstisna dk
- Aksiyon dk
- Aksiyon kapalı 0/1
Sample assumptions
- Takip süresi (dk)
- 30