What the agent did
Phinyaphat Junsoton, known as Khun Nui, is a Data Entry Officer and PR representative at Phichit Drinking Co., Ltd. She handles scheduling and employee data for more than 200 staff across two shifts and six production lines. Instead of searching for and testing Excel formulas by trial and error, she explains the rules of the monthly schedule to Microsoft Copilot and asks it to build the formulas she needs. She also uses Copilot for market research and planning toward a hydroponic farming side income.
Result, as claimed
Microsoft reports that the monthly shift schedule took "at least three full days" before, and "could now be done in about 30 minutes."
This is the result as claimed in the public source linked below. It has not been checked and is not a typical outcome.
Proof
Try it yourself
Describe your roster rules in plain words and let an AI write the spreadsheet formulas.
Prompt
I build a monthly shift roster in Excel. Columns: [list]. Rules: [for example, two shifts, six lines, no one works more than X nights in a row, each line needs Y people per shift, leave days in sheet Z]. Write the formulas I need, tell me exactly which cell each goes in, and explain each one in one line. Then give me three test cases to check the roster breaks no rule.
Tools
- Microsoft Copilot Named in the story. She explains the schedule rules and asks it to build the formulas
Steps
- Write down every rule your roster has to follow, including leave and minimum staffing.
- Run the prompt on a copy of last month's sheet.
- Test it with the three cases and a month you already know is correct.
- Save the finished sheet as a template and reuse it each month.
Watch out: A formula that looks right can miss an edge case such as public holidays or overnight shifts. Test it against a known month before you publish the roster.
Starter version by Solopreneur Code
Skill: Scheduling
Add this skill
Shift roster formula builder
Describe your roster rules in plain words and get the spreadsheet formulas, where they go and tests to check them.
- Works with
- Microsoft Copilot, Claude, ChatGPT, Gemini, Any AI chat The story used Microsoft Copilot with Excel. Any AI chat can write the formulas for you to paste in. Say whether you use Excel or Google Sheets.
- Tools in the story
- Microsoft Copilot
- Country
- Thailand
How to use this: Copy the skill, paste it into Claude, ChatGPT or Gemini, and ask it to save it as a skill. If it cannot, it will still follow the steps.
Show skill
If the Copy button does not work, select this text and copy it.
Job: plan staff and technician schedules
Other tools for this job
Tools used
- Microsoft CopilotMicrosoft 365 Copilot Business add-on $18 per user a month paid yearly (offer price, normally $21). Business Standard with Copilot $23.50 per user a month
- ExcelSee official pricing
Could also do this
- Jobber Not tested in a storyField service scheduling software. Says you can schedule and dispatch crews, fix conflicts with drag and drop, and generate faster daily routes.
- Deputy Not tested in a storySays its auto-scheduling builds staff schedules in one click, using availability, training and hours.