This new construction schedule template was designed to provide a very simple way to create a professional-looking road-map for multi-year projects. It is meant to be used for putting together an overview-type schedule for a project plan document rather than for ongoing project management. Check out Gantt Chart Template Pro for a more feature-packed Gantt chart tool (it also comes with an example home construction schedule).

Advertisement

Construction Schedule

for Excel
Construction Schedule Template for Excel
Download
For: Excel 2007 or later & Excel for iPad/iPhone

Template Details

License: Private Use
(not for distribution or resale)

 

"No installation, no macros - just a simple spreadsheet" - by

Advertisement

Description

This template was designed to provide a very simple way to create a professional-looking road-map for multi-year projects. The bars in the schedule are created automatically using conditional formatting, and you can choose a color by entering a color-code in the Type column. Other formatting is up to you.

Weekly Construction Schedule

Weekly Construction Schedule Template
Download
For: Excel 2007 or later & Excel for iPad/iPhone
License: Private Use
(not for distribution or resale)

Description

This version is basically the same as the one above except that it uses a weekly time period in the gantt chart area, and includes a scroll bar to adjust the range of dates displayed.

Using the Construction Schedule Template

Adding More Rows

When you insert new tasks, you should insert a blank row between rows that have the formatting you want. If you do that, the formatting will be copied automatically.

Enter Text Within the Gantt Chart

I designed this template specifically to allow you to enter text within the gantt chart area, and you can see an example of that in the screenshot above. The problem is that text does not move if you adjust the start/end dates. However, if you are just wanting something simple for a project plan you are putting together, this template can work great.

Text-based arrows or triangles such as ◀, ▶, ▲ and ▼ can be useful if you are adding text within the gantt chart area. Hint: If you want to use these characters frequently, you could add Auto-correct options via File > Options > Proofing to automatically convert "(<<-)" into ◀ and "(->>)" into ▶. Or, you can just copy/paste these characters from the text within the Help worksheet.

You can add shape objects and text boxes in Excel by going to Insert > Shapes, so what you can do to label your construction schedule is almost limitless. However, adding text boxes and shapes is a manual process and the objects won't move if you adjust the start/end dates.

Adding More Columns to the Gantt Chart

If you want a construction schedule that can span a time longer than 5 years, you can copy the last 12 columns in the gantt chart and then paste the copied columns to the right of the gantt chart.

Changing the Bar Colors

The TYPE column can be used to choose a color for the bars in the schedule. If you want to change how this columns works, you will need to edit the conditional formatting rules.

Conditional Formatting

If you want to edit the colors used in the gantt chart, you will need to edit the conditional formatting rules.

To edit conditional formatting rules, go to Conditional Formatting > Manage Rules and select "This Worksheet" to see and edit all the rules.

Creating Dependent Tasks

When creating a project schedule, you often want to start one task when another task ends, and when you are creating your construction schedule, you probably want to set things up so that you can change a single start date and have all the other dates automatically update.

The simplest way to create a dependent task in this construction schedule is to use a formula for the start task such as =end_date+1 where "end_date" is a reference to the end_date of the predecessor task (so the formula might look like =C9+1.

Entering the Task Duration Instead of the End Date

Gantt Chart Template Pro is designed to make creating dependent tasks easier and to allow you to use either calendar days or work days to define a task duration. But with a few Excel formulas, you can add some advanced functionality to even this simple construction schedule template.

Here are a few formulas that you could use in this template to define an End date. You can look up the WORKDAY and WORKDAY.INTL functions in Excel help to learn more about how to use them.

1. End date 50 days after start date

=start_date + 50

2. End date 50 work days after start date (excludes Sat & Sun)

=WORKDAY(start_date,50)

3. End date 50 work days after start date using a custom work week and holiday list

=WORKDAY.INTL(start_date,50,weekend,holiday)

4. End date 3 months after a start date

=EDATE(start_date,3)

5. End date 12 weeks after a start date

=start_date + 12 * 7

Related Content

 

LIKE THIS TEMPLATE?

Follow Us On ...

FB  G+  PIN  TWEET  LI 
Business Templates by Vertex42.com

Related Templates


Sponsored Listings