# Restaurant Report

> Create report how many guests there where each day

- Skill: `majiayu000/restaurant-report` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds add majiayu000/restaurant-report`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/restaurant-report/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Docs & Writing
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/restaurant-report

---


# Restaurant report

## Instructions

### Google sheet
* Generate the report from the Google sheet specified in environment variable $LUNCH_GOOGLE_SHEET.
* Download the sheet as a CSV.

### Generate the report
* Summarize the number of guests per day for all dates that exist in the data.
* Make a list of dates and number of guests.

### Number of guests
* Count the number of guests, it is specified on the row marked "Total".

### Additional guests
* In the same column on the rows below there is freeform text about additional guests. These should be added to the total.

### Additional guests parsing rules
* If specified as "Person + n", it counts as n + 1.
* If specified as "n (Person)", it counts as n.

### Save the report to database
* Write the complete report in a database table in the chinook database.
* Connection info is specified in multiple environment variables on the format $CHINOOK*.
* If the table restaurant_report do not exist, then create it.