# Construction schedule (Gantt) template

Excel workbook with live formulas: https://os.construction/templates/construction-schedule-gantt-template.xlsx

**Project:** ______________________  
**Project start:** ______________________  
**Finish:** ______________________  
**Prepared by:** ______________________  

## Schedule (sample activities)

| ID | Activity | Duration (workdays) | Predecessor 1 | Lag 1 (days) | Start | Finish | Total float (days) | Critical |
| --- | --- | --- | --- | --- | --- | --- | --- | --- |
| A1000 | Mobilize and site setup | 5 |   |   | 3/2/2026 | 3/6/2026 | 0 | Yes |
| A1010 | Clearing and erosion control | 5 | A1000 |   | 3/9/2026 | 3/13/2026 | 0 | Yes |
| A1020 | Excavation and footings | 15 | A1010 |   | 3/16/2026 | 4/3/2026 | 0 | Yes |
| A1030 | Underslab plumbing and electrical | 8 | A1020 |   | 4/6/2026 | 4/15/2026 | 0 | Yes |
|   |   |   |   |   |   |   |   |   |
|   |   |   |   |   |   |   |   |   |
|   |   |   |   |   |   |   |   |   |
|   |   |   |   |   |   |   |   |   |
|   |   |   |   |   |   |   |   |   |

## How to use it

1. Set the project start to a working day. Dates count Monday to Friday; holidays are not excluded, so add them to durations.
2. List activities in the order the work happens, one row each, with a unique ID and a duration in working days. Use a duration of 0 for milestones such as dry-in or substantial completion.
3. Link each activity to up to two predecessors from the drop-down, with a lag where the successor has to wait (cure time, review time). A predecessor must be listed above its successor.
4. Read the result: orange bars are critical (zero total float) and drive the finish date; blue bars have float. Update % complete each week and the bar fills in green.
5. Use it to plan a small job, show a bid schedule or test a sequence. A contract schedule with calendars, start-to-start logic and resources belongs in a CPM tool.

Template by os.construction: https://os.construction/resources/templates/construction-schedule-gantt. Sample rows are illustrative; your contract and specifications govern.
