Project Timeline · Free · No account
A construction schedule by month, from planning to finishing.
The monthly setup draws a year by default, or up to 24 months, one column a month. Planning, design, approvals, the build and finishing are phases in their own colours, with each trade as an owner and approvals marked as milestones.
- Excel 2016 and later
- Calculations checked in LibreOffice
- Choose the viewPick one column per day, week or month, how many to show, and which day your weeks start on.
- Name the phasesType the phases in order, one per line. Each gets its own bar colour. Switch on owners, % complete and milestones if you want them.
- Type the datesDownload the workbook and type each task with its start and finish dates. The bars appear on the Timeline sheet as you type.
Build your workbook
Preview: Construction schedule by month. Change the selected dates, categories or layout to update the preview.
JavaScript is required to use the builder. The workbook is made in your browser.
What you get
What is different in this setup
Home renovators and small builders running a project over many months, who need to see each stage and how they overlap.
- One column per month, 6, 12 or 24 months.
- The year shown above the months.
- Owners for the architect, builder and electrician.
Sheets included (5)
- Start HereHow the workbook works, what each sheet is for and the settings used.
- TasksOne row per task, with its start and finish dates. Start typing in row 6.
- TimelineEach of the first 200 tasks as a bar across 12 months, coloured by phase, with progress, milestones and today marked.
- ListsEdit the white lists to change dropdown choices. Shaded lists are fixed because formulas use those names.
- SettingsValues used by the workbook, such as reminder windows. Change them here.
File details
- Made for
- Excel 2016 and laterThe download is an .xlsx workbook.
- LibreOffice
- No calculation errors in our testLibreOffice recalculated every formula in the workbook with no error values, such as #VALUE! or #N/A.
- Calculations
- The Start Here sheet lists the calculations used in this workbook. Results update from the entries you add.
- Builder privacy
- The builder runs in your browser. The entries used to make the workbook stay on your device. How the utilities work
Questions
Are my builder entries sent to Due Form?
No. The builder uses them in your browser to make the workbook on your device.
Information is sent to Due Form when you submit a form or use another service described on the How it works page.
How are partly filled months drawn?
A month is part of a bar when the task runs at any time in that month, so a task from 20 March to 5 April fills both March and April.
Can I see weeks as well?
Not in the same file. Make a second workbook with the weekly view for the busiest months, using the same task list.
Request a tool or send feedback
Request a tool or report a problem
Tell us what you would like to add, change or fix in the Project Timeline builder.