Get tasks doneBusiness size: Company

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

Phinyaphat Junsoton (Khun Nui) · Thailand · Microsoft Copilot, Excel

Go to the skill

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

Read Phinyaphat Junsoton's story on Microsoft Source Asia

Try it yourself

Describe your roster rules in plain words and let an AI write the spreadsheet formulas.

Difficulty: Beginner

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

  1. Write down every rule your roster has to follow, including leave and minimum staffing.
  2. Run the prompt on a copy of last month's sheet.
  3. Test it with the three cases and a month you already know is correct.
  4. 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

SchedulingDifficulty: Beginner

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 monthChecked 2 November 2026. Price source: Microsoft Copilot, opens in a new tab
  • 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.Page checked 2 November 2026. Vendor page: Jobber, opens in a new tab
  • Deputy Not tested in a storySays its auto-scheduling builds staff schedules in one click, using availability, training and hours.Page checked 2 November 2026. Vendor page: Deputy, opens in a new tab

Sign up for the newsletter

Get the next story from Solopreneur Code in your inbox.

Form not loading? Subscribe on Substack

Back to all stories

More like this

Browse all stories
Get tasks doneBusiness size: Small teamIncludes prompt

A marketplace CEO says Claude cut his company's monthly close from 2 weeks to 2 days and builds a 70-slide board deck with one click

Brendan Candon @brendancandon · Country unknown · Claude, Claude artifacts, Claude Tag (Slack), Jira, Amplitude, Metabase, SigNoz, GitHub, Iterable, Google Drive, Excel, PowerPoint

Claude, connected to the company's systems, pulls data for board meeting prep, the monthly close and weekly leadership dashboards and presents it. Custom apps built with Claude replaced Monday, ClickUp and Airtable.

Result, as claimed

For the last two quarters Claude has built a 70-slide board deck with one click, and the monthly close went from 2 weeks to 2 days.

Once a week it reads his spam and archived email, groups it by sender and looks for events and articles that fit his goals for the year. For each useful sender it gives up to 5 action points and suggests pulling it out of spam or unsubscribing. It now checks his calendar and working hours before it shortlists events. Claude also names new files and chats to one convention and drafts unusual workshop formats for him to pick from.

Result, as claimed

The first run went through 718 emails and it now handles about 30 a week. He says AI gives him back 3 to 4 hours a week, and one webinar it flagged put him on a path to new work.

Get tasks doneBusiness size: SoloIncludes prompt

A marketing educator has Claude route her inbox into CRM deals, tasks and draft replies, and says agents save her 3 to 4 hours a week

Cristina Peñaloza Morales · Country unknown · Claude, Gmail, HubSpot, Todoist, Notion, Riverside, Gamma

Reads new email and routes each one. Training enquiries become a HubSpot contact and deal with a drafted reply. Community messages get a draft reply. Possible collaborations become a Todoist task. Invoices and admin get a label. Also runs a scheduled Monday AI news digest.

Result, as claimed

She says agents save her between 3 and 4 hours a week.