Skill · Kitchen and F&B
Open buffet leftovers
At which meal did more food per guest come back from the buffet?
Download skill package
acik-bufe-artigi/ ├─ SKILL.md ├─ assets/ │ └─ ornek-girdi.xlsx └─ ornekler/ ├─ analiz.xlsx └─ yonetim-ozeti.docx
SKILL.md instructions and sample files in one package
How to use
- Download the package.
- In an assistant that supports skills (e.g. Claude), upload the package as a skill. In other assistants, paste the SKILL.md text into the chat.
- Attach your own Excel export and send the message below. The assistant prepares the formula-based workbook and the Word summary.
Try it with the sample
Before using your own data you can try the sample input in the package. Send this message to the assistant together with the file:
Match the weights of items returned from the buffet with the service covers. Prepare grams per cover by meal and the item with the most leftovers in Excel, and a summary for the kitchen meeting in Word.
19 kg of buffet leftovers were measured for a total of 570 covers across three services. The weighted average is 33.3 grams per cover.
Sample files
- Sample input
ornek-girdi.xlsx - Expected Excel analysis
analiz.xlsx - Expected Word summary
yonetim-ozeti.docx
The sample files are in Turkish.
Instructions (SKILL.md)
Read the attached Excel files and work on a copy of the workbook. If there are multiple tabs, different headers or separate files, map the fields whose meaning can be verified. Note the source file, tab, field, scope and excluded records. Check date and number formats. Reconcile with the source total. If an ambiguity affects the result, ask one concrete question. Keep the metrics that can still be produced. Deliver analiz.xlsx and yonetim-ozeti.docx to the user. The Excel file should contain Analysis, Checks and the required anonymised source fields. Use traceable formulas for derived numbers. The Word file should include the period, the main result, at most three evidence-backed findings and the follow-up the team will check. Reopen the files, check for formula errors and compare the figures in Word with Excel. Use the sample inputs only when the user wants to work with the sample.
- Define each service by hotel, date, outlet and meal. Select the measured leftovers returned from the buffet. Keep preparation waste, plate waste and measured buffet returns separate. Convert kilograms and grams to a common weight unit. If there is no verified conversion for pieces or litres, show the quantity separately.
- Use a single cover count per service. Count the same cover count repeated on item rows only once. Flag conflicting cover counts within the same service for checking. Sum the weights by item and service. Distinguish a missing weight record from an explicitly recorded zero.
- Leftover grams per cover = total leftovers in kg × 1,000 / service covers. Period average = total grams of services with a computable ratio / total covers of the same services. Leave the ratio blank when covers are zero or missing. Rank the items with the most leftovers by kg, and list all items in case of a tie.
- In Excel, show the service, covers, leftover kg, grams per cover, the item with the most leftovers and the reason for any exclusion. In Word, write the service with the highest per-guest leftovers, the item with the most leftovers and the one topic the chef should review. Do not produce cost or savings figures without a verified unit cost.
Try it with the sample
Match the weights of items returned from the buffet with the service covers. Prepare grams per cover by meal and the item with the most leftovers in Excel, and a summary for the kitchen meeting in Word.
The sample file is assets/ornek-girdi.xlsx. The expected Excel and Word outputs are in the ornekler/ folder.