Project Scheduler: a Google Sheets add-on
Install from Google Workspace Marketplace
What it does
You list your tasks, how many days each one takes, what must finish before it can start and which crew it needs. The add-on works out when every task should start so that your crew limits are never broken and the project finishes as early as your people allow. It also shows the critical path: the tasks that decide the finish date once the crew limits are counted.
It has three modes: finish_sooner (work within the crew you have), smooth_load
(keep a deadline and find the smallest crew that can meet it) and crash (let tasks use the
faster methods you list on the alternatives tab). I built it on the same engine as
the web version (Google OR-Tools CP-SAT). It is free and there is no signup.
How to use it
- Make a copy of the Gantt template. The add-on reads that layout, so start from the copy rather than from an empty sheet.
- Fill in the yellow cells on the
tasks,resourcesandparameterstabs. - Go to Extensions → Project Scheduler → Schedule project. In the sidebar pick a mode (it starts
on the one in your
parameterstab) and press Schedule project.
What it writes into your sheet
- The
solutiontab: every task with its start, finish, float, whether it is critical, how far it moved and what it is waiting on. The run summary sits to the right (N1:P13). - The
Startcolumn (G) of thetaskstab, overwritten with the solved start dates. A task you want held on its date goes in thePincolumn (I); pins are read from that column, not from whether a start is typed or calculated. The Gantt bars redraw themselves. - The mode and deadline it used, in
parameters(B4andB5), so the sheet reproduces the answer it shows. - In crash mode only: the days, resource and crew of the tasks that switched to a faster
method (
C,E,Fon thetaskstab).
Limits
- Up to 100 tasks per run.
- The search stops after 25 seconds and gives the best schedule found, which it labels when it is not proved best. The web version searches longer.
- Working days only: a 5-day or a 7-day week (set in
parameters). No holidays.
What data leaves your spreadsheet
The add-on can only read the spreadsheet you open it in, and only sends it when you press
Schedule project. Then it sends the tasks, resources,
parameters and alternatives tabs over HTTPS to my server
(gantt.kindoflost.com), which solves the schedule and sends the answer back. Nothing goes to any
other company. Nothing from your spreadsheet is stored: it is held in memory only while the solve
runs and is discarded when the answer is sent. For each run I keep one anonymous log row (counts
and timings, no task names). Details in the privacy policy and the
terms of use.
Support
Email me at mario@kindoflost.com.
Kind of Lost