Free download, scheduling

Free three-week look-ahead schedule template (Excel)

This free three-week look-ahead template is an Excel workbook for breaking the next 15 working days of the master schedule into crew-level tasks. Each task carries its constraint, an owner and a clear-by date, so the team commits only to work that is ready, and the sheet calculates percent plan complete each week. No email, no macros.

Download the template

No sign-up, no email. 3 sheets, no macros, 13 KB. Opens in Excel or Google Sheets. The example sheet uses illustrative Texas project data; the blank sheet is ready to use.

What is in the workbook?

SheetWhat it is for
InstructionsThe steps on this page and what each column means
Look-aheadThe blank working sheet: dropdowns for constraint type, ready, committed, done and reason missed; working days and percent plan complete calculate
Example (Texas)Eight tasks on an illustrative Travis County, TX school addition

What do the columns mean?

The columns follow the weekly cycle: plan the next three weeks, clear what blocks the work, commit, then learn from what slipped.

ColumnWhat to enterWhy it matters
Activity ID, Master schedule activityThe activity in your CPM schedule the task belongs toAIA A201-2017 Section 3.10 requires the contractor to keep the construction schedule current; the look-ahead is how the field does it week to week.
Task, Location, Crew, Crew sizeWhat a crew will do, where, with how many peopleDetail at the level a foreman can plan a day.
Start, Finish, Working daysDates; working days calculate Monday to FridayFifteen working days is the window.
Constraint, Detail, Owner, Clear byWhat could stop the task (RFI, submittal, material, inspection, predecessor, access), who clears it and by whenMost slips start as constraints nobody looked at three weeks out.
Ready?, Committed?Ready when every constraint is clear; commit only to ready workThe Last Planner System, from the Lean Construction Institute, only commits to work that can be done.
Done?, Reason missedAt week end: done or not, and whyPercent plan complete is the share of committed tasks finished; the reasons show which constraints to clear earlier.

What does the example look like?

Eight tasks on the Example sheet for the three weeks starting November 16, 2026. Illustrative data, not a real project.

TaskCrewDatesConstraintReadyCommittedDone
A1040 Vapor barrier and reinforcing, gymOur crewNov 16, 2026 to Nov 18, 2026NoneYYY
A1045 Pour and finish slab, gymOur crew + pumpNov 19, 2026 to Nov 19, 2026Inspection: Pre-pour inspectionYYN
A1210 Joists and deck, bays 5-8, gymLone Star Steel ErectorsNov 16, 2026 to Nov 20, 2026RFI: RFI-021 bearing plates at grid ENNN
A2110 Electrical rough-in, rooms 111-118, classroom wingCapitol ElectricNov 16, 2026 to Nov 20, 2026NoneYYY
A2130 Duct mains, corridor 110, classroom wingBluebonnet MechanicalNov 17, 2026 to Nov 20, 2026Material: Duct delivery Nov 16YYY
A2310 Metal stud walls, rooms 104-110, classroom wingTravis InteriorsNov 23, 2026 to Nov 25, 2026Material: Third pallet of studs short-shippedNNnext week
A2410 Above-ceiling MEP inspection, classroom wingTravis County inspectorDec 1, 2026 to Dec 1, 2026Predecessor: Rough-in completeNNnext week
A3010 Curtain wall anchors, north, north elevationHill Country GlazingNov 30, 2026 to Dec 4, 2026Submittal: Curtain wall resubmittal 08-004NNnext week

Illustrative4 tasks were committed for the first week and 3 were done: a percent plan complete of 75%. The slab pour slipped on its inspection; the roof joists were never committed because RFI-021 was still open.

How do you use the template?

  1. Pull the next three weeks. Take every activity in the master schedule that starts or runs in the next 15 working days.
  2. Break activities into tasks. One row per crew task, with location, crew and crew size, in the detail a foreman would plan a day.
  3. Screen every task for constraints. For each task, name what could stop it: an open RFI, a submittal not approved, material not delivered, an inspection not booked, a predecessor not done.
  4. Give each constraint an owner and a date. Who clears it, and by when; review the list daily.
  5. Commit only to ready work. Mark Ready Y when every constraint is clear, then Committed Y for next week.
  6. Close the week. Mark Done for each committed task and record the reason for every miss; check percent plan complete and its trend.

For the method and the mistakes to avoid, read how to build a three-week look-ahead schedule.

When does a spreadsheet stop being enough?

A look-ahead is only as good as the constraint check behind it, and that check means reading every open RFI, submittal and delivery against every task, every week. Patrick, BAU AI's project management agent, builds the look-ahead from the master schedule, checks each task against open RFIs, submittals and deliveries, and flags the constraints to clear; the superintendent and the trades adjust and commit. Patrick is offered to the founding cohort and is not part of the published plans.

Frequently asked questions

Is the look-ahead template free?

Yes. Download it without an email address and adapt it for your own projects. A credit line to BAU AI sits at the bottom of each sheet.

Does it work in Google Sheets?

Yes. The formulas use NETWORKDAYS, COUNTIF and COUNTIFS, which Google Sheets supports. There are no macros.

What is percent plan complete?

The share of the tasks committed for a week that were finished that week. It measures how reliable the plan is; the trend matters more than any single week.

Can I use a two-week or six-week window?

Yes. The sheet is not limited to three weeks; change the start and finish dates you plan with.

See Patrick check a look-ahead against your open RFIs

Bring your schedule and RFI log. In 15 minutes Patrick builds the look-ahead with you and flags every constraint.