Free 3-week look-ahead schedule template: A three-week look-ahead that draws its own bars.

A free Excel workbook for the weekly coordination meeting. Type each task’s start date and working days, and it works out the finish dates, draws the bars across fifteen weekdays and marks the holidays. There is no form to fill out.

Excel workbook (.xlsx) · 16 KB · No sign-up · No macros

The three-week look-ahead template open as a spreadsheet: tasks listed down the left, fifteen weekday columns with blue and red bars and one shaded holiday, and constraint and status columns on the right
The workbook as it opens, with a worked example to type over. The project shown is made up for illustration.

What is inside

Six things the workbook does for you.

Fifteen weekday columns

Enter the Monday your look-ahead starts and the three weeks date themselves, Monday to Friday.

Bars that draw themselves

Type a start date and a number of working days. The finish date is calculated and the bar appears, skipping weekends and the holidays you list.

Critical work in a second color

Mark a task with a Y and its bar changes color, so the work that cannot slip stands out in the meeting.

A constraint log on every row

What the task needs first, who is clearing it and the date it is needed by, right beside the task it holds up.

A column for the CPM activity ID

Tie each task to the activity it belongs to, so weekly progress can be carried into the monthly schedule update.

Laid out to print

Set up for one 11 × 17 sheet, landscape. A second sheet explains each column and holds the holiday list.

How to use it

From a blank sheet to the weekly meeting, in eight steps.

  1. Set the week

    Type the Monday your look-ahead starts. The fifteen weekday columns fill in by themselves.

  2. List the work

    One task per row, by area and trade: “Level 3 east: hang drywall,” not “Level 3 finishes.” Type over the example rows or clear them.

  3. Tie it to the CPM

    Put the CPM activity ID beside each task, so weekly progress can be carried into the monthly schedule update.

  4. Start and work days

    Type the start date and the number of working days. Finish is calculated, and the bar draws itself across the grid.

  5. Flag critical work

    Type Y in the Critical? column for work on the critical path. Those bars turn red.

  6. Screen constraints

    For each task, write what must be in place first (an RFI answer, a delivery, an inspection), who is clearing it, and the date it is needed by.

  7. Set the status

    Constrained while something under Needs first is still open. Ready when nothing is in the way. Then In progress, and Done.

  8. Run the meeting

    Issue it before the weekly coordination meeting. Review last week first, then walk the next three weeks and have each trade confirm its dates.

Column by column

What each column is for.

You type in the cream cells. The gray cells and the day grid, marked “Calculated” below, are worked out for you.

ColumnWhat goes in it
# CalculatedThe row number.
CPM activity IDThe activity in your CPM schedule that this task belongs to.
Task and locationThe work, by area and trade.
Trade / responsibleThe crew or person doing it.
Critical? (Y)A Y if the task is on the critical path.
StartThe date the work begins.
Work daysHow many working days it takes.
Finish CalculatedThe last working day, skipping weekends and the holidays you have listed.
Week 1 to week 3 CalculatedA bar on each working day of the task. Holidays are marked HOL and shaded.
Needs first (constraint)What must be in place before the task can start: an RFI answer, a delivery, an inspection.
Who clears itThe person responsible for clearing that constraint.
Need byThe date it has to be cleared.
StatusReady, Constrained, In progress or Done, picked from a list.

Free download

Three-week look-ahead template

Free to use and to adapt on your own projects.

Download the template

Excel workbook (.xlsx) · 16 KB · No sign-up

Beyond the template

When a spreadsheet stops being enough.

A template gives you the format. It cannot tell you whether the dates in it still agree with the contract schedule. On a busy job the two drift apart: the field works to the spreadsheet, the owner is shown the CPM schedule, and the monthly update stops describing the real project.

That is the part we do. We keep the look-ahead current each week from a short call with your superintendent, tie every task to its CPM activity, and carry the actual dates into the monthly update.

How our look-ahead service works

Common questions

Questions, answered.

Is the look-ahead template really free?

Yes. There is no form, no email address and no trial period. Download it, use it on your own projects and change it to suit them.

Does the template use macros?

No. It is a plain .xlsx workbook built with standard functions such as WORKDAY and COUNTIF, with conditional formatting drawing the bars. There are no macros to enable. Excel may ask you to click Enable Editing first, as it does with any downloaded file.

Will it work in Google Sheets?

It is built for Excel. We have not tested it in Google Sheets or Numbers, so we can’t promise the bars and the drop-down lists behave the same way there.

How do I add holidays?

List them on the “How to use” sheet. Each date you enter is marked HOL on the grid, shaded, and skipped when the finish dates are calculated. Weekends are always skipped.

Can it show more than three weeks?

The grid is fixed at fifteen working days. For a longer make-ready view, keep a second copy of the sheet that starts three weeks later.

Is a look-ahead the same as a CPM schedule?

No. The CPM schedule covers the whole project and calculates the critical path. The look-ahead is the next three weeks of it, broken into daily tasks for the crews. The template has a column for the CPM activity ID so the two stay tied together.

Free 30-minute consultation

Bring your schedule, your spec or just your questions.

Thirty minutes with a scheduler, no obligation. We will look at where your project stands and tell you plainly what would help.

Call Free consultation