Skill · Kitchen and F&B

Open buffet leftovers

At which meal did more food per guest come back from the buffet?

Type
Skill
Department
Kitchen and F&B
Input
End-of-service weights by item and cover counts for each meal
Output
Formula-based Excel analysis and a one-page Word summary
License
CC BY 4.0
Raw text
SKILL.md

Download skill package

acik-bufe-artigi/
├─ SKILL.md
├─ assets/
│  └─ ornek-girdi.xlsx
└─ ornekler/
   ├─ analiz.xlsx
   └─ yonetim-ozeti.docx
Download skill package .zip

SKILL.md instructions and sample files in one package

How to use

  1. Download the package.
  2. 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.
  3. 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:

message
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.
Expected result on the sample data

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

The sample files are in Turkish.

Instructions (SKILL.md)

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.

  1. 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.
  2. 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.
  3. 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.
  4. 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.

Let Talkwo run this work for you

Talkwo brings your PMS, messaging and review data into one place and prepares these reports for you every morning.

Meet Talkwo

License: The prompts and skills in this library are licensed under CC BY 4.0. You may copy, adapt and use them freely, including commercially, as long as you credit Talkwo. CC BY 4.0

Sample files use fictional hotel data.

© 2026 Talkwo Contact Privacy Terms