Checks and limits
The sample checks missing or invalid entries, duplicates, and overlapping shifts for the same name. It supports up to twelve same-day entries; it does not plan breaks, overnight shifts, or staffing requirements.
Operations and process improvement
Zone Chart Builder
Less time preparing the floor chart. More time for leaders to decide where people are needed.
Try the independent demoFrom schedule data to a usable starting point.
- The problem
- Daily floor planning required organizing schedule exports, matching roster information, and checking errors before assigning people.
- What I built
- An Excel and Office Scripts workflow that prepares the information and flags roster issues. Leaders retain responsibility for placement decisions.
- In use
- Used daily in-store. Based on my estimate, the tool reduced preparation time by roughly half.
Working sample
Review a sample schedule
Edit the sample, then prepare a draft. Everything runs in this browser; edits are not uploaded or saved.
Try this: Mina’s end time is missing. Prepare the draft to see the issue, then add 18:00 and prepare it again.
Sample schedule
Same day, 24-hour timePrepared for review
Only entries without detected issues appear in this view. A leader still confirms the schedule, breaks, coverage needs, and final assignments. This demo does not calculate staffing requirements.
What to know
Leader review
A leader confirms the source schedule, resolves flagged entries, and decides coverage and assignments. People with the same name need distinct fictional identifiers.
Discuss an opportunity
I’m interested in corporate operations and training roles where practical problem-solving matters.
Contact me on LinkedIn