This construction schedule template is design to provide a very simple way to create a professional-looking road-map for multi-year projects. It is meant for putting together an overview-type schedule for a project plan document rather than for ongoing project management.
Schedules for values construction
This template is design to provide a very simple way to create a professional road-map for multi-year projects. The bars in the schedule are create automatically using conditional formatting, and you can choose any color by entering a color-code in the Type column. This template includes a Materials worksheet for listing costs and quantities of materials allowing you to estimate the total cost of a remodel project.
Construction Project Planning and Scheduling
Adding More Rows
When you insert new tasks, you must insert a blank row between rows that have the formatting you want. If you do the same, the formatting will be copied automatically.
Enter Text Within the Gantt Chart
I designed this template specifically for you to enter text within the gantt chart area. The problem is that text does not move if you start adjusting the start/end dates. However, if you are just wanting something simple for a project plan this template can work great.
Text-based arrows or triangles such as ◀, ▶, ▲ and ▼ can be useful if you add text within the gantt chart area. Hint: If you want to use these characters frequently, you can add Auto-correct options via File > Options > Proofing to automatically convert “(<<-)” into ◀ and “(->>)” into ▶. Or, just copy/paste these characters from the text within the worksheet.
You can add shape objects and text boxes in Excel by Insert > Shapes, so what you can do is label your construction schedule is almost limitless. However, adding text boxes and shapes is a manual process and the objects don’t move if you adjust the start/end dates.