# The Construction Scheduler: companion files

Julian R. Sterling

## What is here

- **Construction_Scheduler_1_Calendar.xlsx** (Chapter 5; Calendar workbook of Appendix A): sheets Calendars, Working days, then Checks. The two case calendars and their holidays, the contract time of 360 calendar days ending on 30 December 2026, one activity landed on both calendars, and every day of the job with its working day number.
- **Construction_Scheduler_2_Network.xlsx** (Chapters 4, 6, 7 and 9; Network workbook): sheets Activities, Links, Holidays, then Checks. The baseline network, 63 activities and 98 links, with the forward and backward passes by live formula: early and late dates, total and free float, and substantial completion on 16 December 2026, working day 243.
- **Construction_Scheduler_3_Cost_Curve.xlsx** (Chapter 8; Cost curve workbook): sheets Activity values, Spread, Curves, Holidays, then Checks. The $29,470,000 of value spread over the workdays of each activity, and the early, late and as-built curves month by month.
- **Construction_Scheduler_4_Update.xlsx** (Chapters 10, 12 and 15; Update workbook): sheets Updates, Progress, Holidays, then Checks. The 10 monthly updates: value in place, percent complete, forecast, slip and the window changes, which add up to 6 workdays.
- **Construction_Scheduler_5_Recovery.xlsx** (Chapters 13 and 14; Recovery workbook): sheets Options, Saturdays, Holidays, then Checks. The options after the area B steel slip, the Saturdays worked, the cost per workday recovered, and the plan of 8 May 2026 ($56,000 for 9 workdays) against the exposure.
- **Construction_Scheduler_Toolkit.docx**: the 5 check-lists of Appendix B, editable (Contract schedule requirements (what to extract before building); Baseline review before submission; The monthly update; The three-week look-ahead; A recovery plan).

## How to use the workbooks

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. The first sheet of each workbook holds what the workbook is about and its results; the Holidays sheet (the Calendars sheet in the first workbook) holds the notice to proceed, the contract time and the ten case holidays every date is computed on. Change one input at a time, note the result, and set the input back before the next test: the Checks sheet of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK at the base case. Each of the 9 exercises of Appendix A is done in the workbook it names.

Day numbers count the start day and the finish day, with working day 1 on the notice to proceed of 5 January 2026. Dates use WORKDAY.INTL and NETWORKDAYS.INTL: weekend code "0000011" for the five-day calendar, "0000001" for the six-day calendar. There is no circular reference: in the Network workbook, each activity's early start reads the links into it and its late finish the links out of it.

Two inputs to try first:

1. In Construction_Scheduler_2_Network.xlsx, on Activities, set the duration of A123 (area B steel) from 15 to 35 workdays: the finish moves by 15 workdays, the slip chapter 13 describes.
2. In Construction_Scheduler_1_Calendar.xlsx, on Calendars, delete the holiday of 25 May 2026: the five-day finish of the exercise 1 activity comes back one workday.

The workbooks are separate files with no link between them.

## A word of caution

Halvercroft Constructors, Inc., Dunmarrow County, the Dunmarrow County Public Safety Building and every party in the case are fictional. Durations, values, premiums, general conditions rates and liquidated damages are teaching assumptions, not market norms or recommendations. Standard forms, federal clauses and guide specifications change: read them in their current text and in the contract as signed, with counsel. No scheduling software is described or recommended. Nothing here is legal or contractual advice.
