Coffee dose and shot loss
Connect good shots, dial-in loss, and recipe dosage to bean cost.
Restaurant and Café Pack · Excel workbook in Turkish
Results from the sample workbook
- Satışa giren shot
- 209.56
- Fiili çekirdek (kg)
- 4.35
- Standart farkı (TL)
- 447.14
Who can use it, and for what?
Café owners and baristas
Connect good shots, dial-in loss, and recipe dosage to bean cost.
A worked example from the workbook
The first sample row in the baseline has the following results. Satışa giren shot 206, Fiili çekirdek (kg) 4,36, Standart farkı (TL) 506,22, Satılan shot maliyeti (TL) 16,5. The table shows per-record averages across 16 fictional records. In-workbook field names are shown in Turkish.
| Measure | Sample result |
|---|---|
| Satışa giren shot | 209.56 |
| Fiili çekirdek (kg) | 4.35 |
| Standart farkı (TL) | 447.14 |
| Satılan shot maliyeti (TL) | 16.16 |
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.
- Include discarded shots in total shots pulled. Weigh additional dial-in and cleaning loss separately. Compare actual dose with the standard recipe.
- Choose a date range and group on Ayarlar (Settings). Compare the three editable values for “Çekirdek fiyat çarpanı”. The sample settings are 1 / 0,88 / 1,18. 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.
- Hazırlanan shot
- Ayarda dökülen shot
- Doz gramı
- Ayar dışı kayıp gram
- Çekirdek TL/kg
- Standart doz gram
Sample assumptions
- Çekirdek fiyat çarpanı
- 1