Create a reusable workplace lunch-club rotation and contribution planner

A workplace packed lunch club works best when everyone can see one schedule that answers four questions: who is eating, who is bringing what, how many portions are needed, and what still has to be confirmed. A rotation and contribution planner is that schedule. It combines the club's setup decisions, a date-by-date rotation, a portion tally and a check-off column in a single template you can keep digital and print for the break room.

What the planner is for

The planner organizes shared packed lunches among coworkers: who hosts or contributes on each date, what each person is bringing, and whether the portions committed match the people who confirmed. It is an organizing tool, not a food-safety or nutrition tool. It records dietary requirements and open ingredient questions so they get answered, but it does not decide whether a dish is suitable for anyone. Build it once, then reuse it for every cycle by clearing the schedule rows and keeping the setup fields.

Step 1: Agree on how the club works

Before you draw a single row, the group needs to settle the basic model. Either one host supplies the whole lunch on their date, or several contributors each supply a component, such as a main, a side and a dessert. The choice changes the template: a single-host club needs one name per date, while a contributor club needs a row per contribution under each date.

Decide the model: single host per date, or multiple contributors per date.
Name a coordinator who maintains the planner and confirms workplace arrangements.
Write down the contribution agreement, such as whether people take turns hosting, split costs, or simply bring their share. Do not assume anyone's participation or spending; record only what the group agrees.
Set an attendance deadline, for example a fixed number of working days before each lunch, so portion counts can be finalized.
Agree a participant order to use for breaking ties in the rotation.

Step 2: Collect participant details carefully

Gather each person's availability, requested portions and dietary requirements. Dietary and health-related details are personal, so collect them privately, for example through a direct message or a form only the coordinator sees, and put on the shared schedule only what contributors need to plan, such as 'no nuts in this dish' rather than the reason behind it. If someone prefers not to share a requirement publicly, the coordinator can flag the affected contribution as needing a private check instead.

Step 3: Set up the reusable table

Keep the setup fields, the schedule and the check-off column in one template. A spreadsheet works well because it can recalculate totals, but the same layout prints cleanly on a single landscape page. Use these columns:

Column	What to record
Date	The lunch date
Confirmed eaters and requested portions	Names or a count, plus total portions requested
Host	The person responsible for that date
Contributor	Who is bringing each component (repeat rows for multiple contributors)
Dish or contribution	What is being brought
Declared ingredients and requirements awaiting confirmation	Ingredients the contributor has listed and any participant requirements still to be checked against them
Portions committed	How many portions this contribution covers
Facility and equipment needs	Fridge space, reheating, serving dishes, utensils
Confirmation status	Pending, confirmed, or changed, plus a check-off box

Above the schedule, add a setup block that rarely changes: the club model, coordinator, contribution agreement, attendance deadline, tie-break order, and the food-handling guidance the group has agreed to follow. For a printable version, a layout like this keeps everything on one sheet:

LUNCH CLUB PLANNER                     Cycle: ____________
Coordinator: ____________   Model: [ ] Single host  [ ] Contributors
Attendance deadline: ____________   Tie-break order: ____________
Food-handling guidance followed: ______________________________

Date   | Eaters/Portions | Host | Contributor | Dish | Ingredients/Open questions | Portions | Facilities | Status | [x]
-------+-----------------+------+-------------+------+----------------------------+----------+------------+--------+----
       |                 |      |             |      |                            |          |            |        | [ ]
       |                 |      |             |      |                            |          |            |        | [ ]

Swaps:  Date ______  From ______  To ______  Agreed by ______

Step 4: Build the rotation fairly

Use one simple rule so nobody has to argue about whose turn it is: assign each date to the available participant with the fewest confirmed turns so far, and if several people are tied, pick whoever comes first in the agreed participant order. This keeps turns balanced even when people miss dates.

Illustrative example with four participants, A, B, C and D, in that agreed order. Date 1: everyone is available and has zero turns, so A hosts. Date 2: B is unavailable; C and D both have zero turns, so C hosts. Date 3: everyone is available; B and D are tied at zero, so B hosts. Date 4: D is the only person with zero turns, so D hosts. After four dates, each person has hosted once.

When two people trade dates, record the swap explicitly in the swaps section rather than just overwriting names. That keeps the turn counts accurate for the next cycle and avoids confusion about who actually hosted.

Step 5: Match portions to attendance

Total the requested portions from confirmed eaters, then total the portions committed by contributors. The gap between the two is what still needs to be assigned. Recalculate whenever attendance changes, and ask contributors to reconfirm their quantities instead of assuming they will adjust.

Illustrative calculation: six confirmed participants each request one portion, so the lunch needs six portions. One contributor commits four portions and another commits two, which covers all six. If a seventh participant joins, the requirement becomes seven and one portion is unassigned until someone agrees to cover it. Note that balancing the numbers says nothing about whether a dish suits any participant's dietary needs; that is a separate check.

Step 6: Confirm workplace facilities and food handling

Shared food at work depends on arrangements the club does not control, so the coordinator should confirm them before the first date and note them in the setup block.

Permission: check that the workplace allows a shared lunch and whether there are rules about where food can be served.
Storage and serving space: confirm there is room to store contributions and set them out.
Refrigeration and heating: confirm access to a fridge, microwave or other equipment, and whether the club needs to reserve it.
Utensils and serving dishes: decide who supplies them.
Cleanup: assign responsibility for each date, often the host.
Food handling: record which food-handling guidance the group is following and who will check the actual preparation and transport arrangements, since chilled or hot items may need specific handling.

Handle dietary requirements as open questions

In the ingredients column, list what each contributor declares the dish contains and mark any participant requirement that has not been checked as awaiting an answer. Avoid labeling a dish 'safe' or 'suitable' on the schedule. Instead, change the status to confirmed only when the contributor and the affected participant, or the coordinator acting privately for them, have both agreed. If a question cannot be resolved, the participant can bring their own portion that day, and the portion tally should be adjusted accordingly.

Running the planner each cycle

Before the cycle: update participant availability and requested portions, and refresh the tie-break order if the group changes.
Assign dates using the fewest-turns rule and share the draft schedule.
At the attendance deadline: lock the eater count, recalculate portions and ask contributors to reconfirm quantities.
Resolve open ingredient and dietary questions and update confirmation status.
Print the final schedule for the break room if the group uses a paper copy.
After each lunch: tick the check-off column and log any swaps.
At the end of the cycle: carry turn counts forward, clear the schedule rows and keep the setup block for the next round.