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?
| Sheet | What it is for |
|---|---|
| Instructions | The steps on this page and what each column means |
| Look-ahead | The 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.
| Column | What to enter | Why it matters |
|---|---|---|
| Activity ID, Master schedule activity | The activity in your CPM schedule the task belongs to | AIA 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 size | What a crew will do, where, with how many people | Detail at the level a foreman can plan a day. |
| Start, Finish, Working days | Dates; working days calculate Monday to Friday | Fifteen working days is the window. |
| Constraint, Detail, Owner, Clear by | What could stop the task (RFI, submittal, material, inspection, predecessor, access), who clears it and by when | Most slips start as constraints nobody looked at three weeks out. |
| Ready?, Committed? | Ready when every constraint is clear; commit only to ready work | The Last Planner System, from the Lean Construction Institute, only commits to work that can be done. |
| Done?, Reason missed | At week end: done or not, and why | Percent 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.
| Task | Crew | Dates | Constraint | Ready | Committed | Done |
|---|---|---|---|---|---|---|
| A1040 Vapor barrier and reinforcing, gym | Our crew | Nov 16, 2026 to Nov 18, 2026 | None | Y | Y | Y |
| A1045 Pour and finish slab, gym | Our crew + pump | Nov 19, 2026 to Nov 19, 2026 | Inspection: Pre-pour inspection | Y | Y | N |
| A1210 Joists and deck, bays 5-8, gym | Lone Star Steel Erectors | Nov 16, 2026 to Nov 20, 2026 | RFI: RFI-021 bearing plates at grid E | N | N | N |
| A2110 Electrical rough-in, rooms 111-118, classroom wing | Capitol Electric | Nov 16, 2026 to Nov 20, 2026 | None | Y | Y | Y |
| A2130 Duct mains, corridor 110, classroom wing | Bluebonnet Mechanical | Nov 17, 2026 to Nov 20, 2026 | Material: Duct delivery Nov 16 | Y | Y | Y |
| A2310 Metal stud walls, rooms 104-110, classroom wing | Travis Interiors | Nov 23, 2026 to Nov 25, 2026 | Material: Third pallet of studs short-shipped | N | N | next week |
| A2410 Above-ceiling MEP inspection, classroom wing | Travis County inspector | Dec 1, 2026 to Dec 1, 2026 | Predecessor: Rough-in complete | N | N | next week |
| A3010 Curtain wall anchors, north, north elevation | Hill Country Glazing | Nov 30, 2026 to Dec 4, 2026 | Submittal: Curtain wall resubmittal 08-004 | N | N | next 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?
- Pull the next three weeks. Take every activity in the master schedule that starts or runs in the next 15 working days.
- Break activities into tasks. One row per crew task, with location, crew and crew size, in the detail a foreman would plan a day.
- 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.
- Give each constraint an owner and a date. Who clears it, and by when; review the list daily.
- Commit only to ready work. Mark Ready Y when every constraint is clear, then Committed Y for next week.
- 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.