Schedule Designer
Build each person's week on a grid and watch the appointment counts and hours add up as you go. When it looks right, save it as an Excel workbook that this page can open again.
- Runs in your browser
- Opens no connection
- Keeps nothing unless you choose otherwise
This tool works in your browser, so it needs scripts turned on. The article explains what it does.
Start
Choose how to begin. The sample clinic is a quick way to see what the tool does.
Open the sample clinic
An invented clinic with two sites, eight providers and three support staff. Its week is already filled in, so you can try everything.
Start a new schedule
An empty week with one site and a few kinds of time. You add your own places and people next.
Open a saved schedule
Choose a workbook this page saved earlier, or drop it on this card.
Good to know
- This is a template week. It holds no patients and no real appointments.
- The schedule lives in this tab until you save it. Save the workbook before you close the page.
- Each person's week snaps to a grid of 15 or 20 minutes. You can switch the grid at any time and the blocks keep their true times.
Set up
Name the places, the kinds of time and the people. You can come back and change any of it later.
Design
Check and save
The page has read the whole week.
What you can do with it
Mock up a template week
Lay out each person's appointments and other time, and see whether the hours meet their contract before anyone rebuilds it in the scheduling system. Enter a person's working hours and their week shows when they are at work.
See rooms beside the schedule
A block of time can name a room. The page shows when two people are in one room and which rooms are free.
Plan support staff beside providers
Support staff, such as medical assistants, have weeks of their own. A week can be filled from the patient time of the providers a person works with, and each provider's week shows when somebody is with them.
Keep it as a workbook
The saved file is an ordinary Excel workbook with a sheet for each person. This page opens it again when the week needs to change.
Picking up where you left off
The workbook holds your work
The workbook you save holds the whole set-up and the week. Open it here again and carry on from where you stopped.
Remembering your file in Edge
In Edge the page can remember where your file is and save changes back into it. Turn on Remember this file on this computer to use it. Edge asks you before the page opens the file again.
A new season from the last one
On the Start step, choose Use a saved schedule's set-up to begin an empty week with the set-up from an earlier workbook. That workbook stays as it was.
Other browsers
In other browsers you open and save the workbook by hand. You choose it each time, and saving puts a copy with your downloads. The page offers to remember your file wherever the browser supports it.
Keep your own copy
The whole tool also comes as one file. Save it on your computer and open it in your browser whenever you need it. It loads nothing from anywhere and opens no connection.
The copy does not update itself, so come back to this page for the current one. The checksum file beside it holds the SHA-256 of the copy, for checking that the file you have is the one published here.