# Shift roster formula builder

A skill based on a story on Agent Stories.

Describe your roster rules in plain words and get the spreadsheet formulas, where they go and tests to check them.

Task: Scheduling
Works with: Microsoft Copilot, Claude, ChatGPT, Gemini, Any AI chat
Tools: Microsoft Copilot
Difficulty: Beginner
Country: Thailand

Use this when you build a shift roster in a spreadsheet and need formulas that follow your rules, instead of testing formulas by trial and error.
Skip this if you want formulas written straight into your live sheet, or you will not test them first.

Credit: From the story of Phinyaphat Junsoton (Khun Nui). A Thai data entry officer used Copilot to build the formulas for a 200 person shift roster and cut three days of work to 30 minutes
Source: https://agentstories.org/stories/phinyaphat-junsoton-copilot-shift-schedule.html

## Skill text

Please turn the text below into a reusable skill. If you are Claude, save it as a skill. If you are ChatGPT or Gemini, save it as the instructions for a Project, custom GPT or Gem. If you cannot save skills, just follow these instructions now.

Name: Shift roster formula builder

Description: Use this when I build a shift roster in a spreadsheet and need formulas that follow my rules, instead of testing formulas by trial and error.

Ask me for:
1. Whether I use Excel or Google Sheets.
2. My columns and which sheet holds what.
3. Every roster rule, for example the number of shifts and lines, people needed per line per shift, the most nights in a row anyone can work, and where leave days are kept.

Steps:
1. Repeat my rules back as a numbered list and ask about anything unclear, such as public holidays or overnight shifts.
2. Write the formulas I need.
3. Say exactly which cell or column each formula goes in.
4. Explain each formula in one plain line.
5. Give me three test cases that check the roster breaks no rule.

Output:
1. A table with Cell, Formula and What it does.
2. The three test cases with the result I should expect.

Rules: Tell me to work on a copy of my sheet. Remind me to test against a month I already know is correct before I publish the roster.

## More

- [This skill as a web page](https://agentstories.org/skills/roster-formula-builder.html)
- [All skills, as a Markdown list](https://agentstories.org/skills.md)
- [Skills directory](https://agentstories.org/skills/)
