Project Scheduler turns your Gantt sheet into a resource-aware schedule. List your tasks, how many days each takes, what must finish first and which crew each needs. One click 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. A real solver (Google OR-Tools™), not a guess. What you get - Start dates written into your Gantt sheet, so the bars redraw themselves - The earliest finish your crew can really do, next to the finish with unlimited people, so you see what the crew limit costs - The critical path once crew limits are counted, and the float of every other task - A solution tab: start, finish, float, what each task is waiting on (a predecessor or the crew) Three modes - Work within my crew: when does it finish? - Keep my date: how many people would it take? - Crash the schedule: let tasks use the faster methods you list, and see how much sooner it can finish How to use it 1. Make a copy of the template: https://docs.google.com/spreadsheets/d/1xHz780ODS_s9paqHsqG3SaPaiY2totdq5xcIoriQtVY/copy 2. Fill in the yellow cells on the tasks, resources and parameters tabs. 3. Extensions → Project Scheduler → Schedule project. Your data The add-on only sees the spreadsheet you open it in, and only when you press the button. The tabs are sent over HTTPS to gantt.kindoflost.com, solved, and discarded: nothing is stored and nothing goes to any other company. Privacy policy: https://gantt.kindoflost.com/privacy Limits: up to 100 tasks per run; the search stops after 25 seconds; 5- or 7-day working weeks, no holidays. Free, no signup. Support: mario@kindoflost.com. More: https://gantt.kindoflost.com/sheets-addon Google Sheets™ is a trademark of Google LLC.