---
title: "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"
person: "Phinyaphat Junsoton (Khun Nui)"
tools:
  - "Microsoft Copilot"
  - "Excel"
country: "Thailand"
category: "Get tasks done"
category_slug: get-tasks-done
proof:
  - label: "Read Phinyaphat Junsoton's story on Microsoft Source Asia"
    url: "https://news.microsoft.com/source/asia/2026/06/12/breaking-barriers-building-the-future-phinyaphat-junsotons-journey-with-ai/"
date: 2026-10-31
date_posted: 2026-06-12
as_claimed: "The result is shown as claimed in the public source linked here. It has not been checked and is not a typical outcome."
url: "https://agentstories.org/stories/phinyaphat-junsoton-copilot-shift-schedule.html"
markdown_url: "https://agentstories.org/stories/phinyaphat-junsoton-copilot-shift-schedule.md"
site: "Agent Stories by Solopreneur Code"
---

# 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

## 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."

> The result is shown as claimed in the public source linked here. It has not been checked and is not a typical outcome.

## Proof

- [Read Phinyaphat Junsoton's story on Microsoft Source Asia](https://news.microsoft.com/source/asia/2026/06/12/breaking-barriers-building-the-future-phinyaphat-junsotons-journey-with-ai/)

## Try it yourself

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

Prompt:

```text
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](https://copilot.microsoft.com): 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.

## More

- [This story as a web page](https://agentstories.org/stories/phinyaphat-junsoton-copilot-shift-schedule.html)
- [More stories: Get tasks done](https://agentstories.org/categories/get-tasks-done.html)
- [More stories from Thailand](https://agentstories.org/countries/thailand.html)
- [More stories that use Excel](https://agentstories.org/tools/excel.html)
- [Every story, indexed for AI assistants](https://agentstories.org/llms.txt)
