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.

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.

ArticleThe workbook is the saved scheduleWhat the page writes into the workbook, what it reads back, and what to know before you rely on it.

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.