Kind of Lost Kind of Lost ·OR Tools ·Project Scheduler ·Construction scheduling ·Support

Construction planning and scheduling for small contractors — free, and it counts your crew

On a building or renovation job, planning means deciding what work happens, in what order, and which trade does it. Scheduling turns that plan into dates your people can actually show up for. Most free tools do the date arithmetic and stop there, as if you could put any number of carpenters on site the morning the chart asks for them. This one takes your task list and the size of each crew, finds the critical path, and then builds a schedule that never books more people than you employ.

Plan a job in the scheduler

Free, no signup. Run the renovation sample first, or upload your own spreadsheet.

Planning first, then scheduling

The two words get used as one, but they are separate jobs and it pays to keep them apart. The plan is a list: break the work into pieces that one trade can finish without leaving, say how many working days each piece takes, and write down what has to be done before it can begin. Foundations before the slab, framing before the roof, rough-in before insulation. Nothing in that list has a date on it yet.

The schedule is what you get when that list meets a calendar and a payroll. Weekends drop out, every dependency is respected, and on any given day the work in progress needs no more electricians, plumbers or labourers than you have. That last condition is the one that wrecks paper schedules, and it is the one this tool is built around.

What you enter for a construction job

Pick a five-day week or a seven-day week on the parameters sheet. The Excel template holds up to 60 tasks across 95 days and already contains a finished example in exactly this format.

Worked example: a 21-task house renovation

The sample job runs from site setup and fencing, through demolition, excavation, foundations, slab, framing and roofing, to finishes and a punch list. It has five resources: a general crew of three, two electricians, two plumbers, two painters and one excavator.

Ignore the crew limit and the critical path finishes on 25 November 2026. But that version quietly needs five general labourers on some days when the company has three, and it is overbooked on 14 working days. Fitted to the three people who exist, the job finishes on 2 December 2026: five working days later, and the solver proves no ordering of the work does better with that crew.

The detail is where it earns its keep. Roofing cannot start the day framing ends, because the same crew is still fitting windows and exterior doors; it waits for that hand-off. The driveway slides 14 working days into a gap where people are free. The tool also prices the alternative: a fourth labourer brings the finish to 30 November, a fifth gets you back to 25 November.

The sample also lists faster ways to do some tasks — prefabricated wall panels, a roofing subcontractor, a drywall subcontractor. In crash mode the solver uses three of them and the finish moves from 2 December to 17 November, eleven working days sooner. The project crashing page explains how that choice is made.

Why the crew limit changes which tasks are critical

A chart drawn with unlimited people marks the tasks that are critical because of logic. On a real site, a task with a week of float on paper can still hold up the handover because the only two plumbers are busy elsewhere that week. The scheduler colours tasks by float measured against your actual crew, and hovering a bar says what it is waiting on: a predecessor, or a crew finishing somewhere else. The critical path calculator page covers the forward and backward pass behind those numbers.

Keeping it current once the job starts

What it is not

It is a scheduling engine, not construction management software. There is no budget tracking, no RFIs or submittals, no daily log and no holiday calendar. Each task draws on one resource, and crews are counted in whole people per day. If you need those things, use this to get the sequence and dates right, then carry them into whatever system runs the rest of the job.

Common questions

Can two jobs share one crew? Yes, as long as together they fit in 60 tasks. Put both jobs in the same task list with no links between them, list the crew once on the resources sheet, and pin the first task of the later job to its start date. The solver then shares the people between the two.

How do I enter a subcontractor? Leave the resource blank, or give the sub its own line on the resources sheet if their availability is limited too. A blank resource ties up none of your own people.

Is the schedule actually the best one? It is solved with Google OR-Tools CP-SAT, and the result says plainly whether optimality was proved or the solver ran out of time first. Small jobs like the sample solve in well under a second.

Do I need to install anything? No. The scheduler runs in the browser, and the workbook is a normal .xlsx file.