Zone Chart Builder · Operations tool for a retail store

Less prep. Clearer floor planning.

I built a tool that turns schedule and roster data into a daily floor plan, with checks that flag missing information for review. I designed it, built it, and used it every day.

Role
Designed, built, used it
Built with
Excel · Office Scripts
Used by
2–3 leaders, daily
Result
~60 → ~30 min a day, my estimate
The planning demo: one entry needs attention because an end time is missing, and two shifts are ready for planning on a timeline.

The independent demo, with fictional names and shifts. You can try it below. The real sheets stay inside the store.

Where it started

I made the floor chart myself, every day.

Before I could assign anyone, I had to organize the schedule export, match it against the roster, and check it for errors. That prep took the time that should have gone to deciding where people were needed.

Build where the work already happens

Store leaders already work in Excel, and it’s a tool their devices allow.

So the tool lives there too, written in Excel and Office Scripts. Nothing new to install and nothing new to learn.

From schedule data to a starting point

The tool prepares the information. The leader still makes every placement.

It pulls in the schedule and the roster, matches them, and flags anything that doesn’t add up. What comes out is a draft floor plan and a short list of issues to fix.

The checks came second

The first version just built the chart. The checks were the biggest change after it.

The tool now flags missing information for review before anything reaches the plan. Try the idea yourself below: 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 time

Sample loaded. Ready for you to explore.

Checks and limitsThe 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.
Leader reviewA leader confirms the source schedule, resolves flagged entries, and decides coverage and assignments. People with the same name need distinct fictional identifiers.

Colour has one job per hue

A leader scans the sheet for problems under time pressure. So every colour has to mean something.

  • Black is structure.Titles, headers and section bands.
  • Orange is where you act.The cell to type in, the dropdown to pick, the next step.
  • Signal colour is status only.Red is the only solid fill on a sheet, and it belongs to the gap. Everything else is a tint.
  • The same thing looks the same everywhere.A break is the same yellow on every sheet, so nobody re-learns it between tabs.
Recreated with sample data to show the rules. The eye lands on the one red cell first.

The tool prepares. People decide.

It never places anyone on its own.

A leader still confirms the schedule, the breaks, the coverage needs and the final assignments. Leaving the call to people is the part I’d tell another designer to keep.

Outcome

Used daily in-store since August 2026 by two or three leaders, me included. Daily prep went from about an hour to about half an hour.

Daily prep
~60 → ~30 min
Leaders using it
2–3
In daily use since
Aug 2026

The time figures are my estimate, not a measured study.

What I’d tell another designer

Leave the call to people.