Kind of Lost Kind of Lost · Project Scheduler · Sheets add-on

Project Scheduler: a Google Sheets add-on

Resource-levelled project schedules, calculated inside your own Gantt sheet.

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

  1. Make a copy of the Gantt template. The add-on reads that layout, so start from the copy rather than from an empty sheet.
  2. Fill in the yellow cells on the tasks, resources and parameters tabs.
  3. Go to Extensions → Project Scheduler → Schedule project. In the sidebar pick a mode (it starts on the one in your parameters tab) and press Schedule project.

What it writes into your sheet

Limits

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.