# The Construction Superintendent: companion files

Julian R. Sterling

## What is here

- **Construction_Superintendent_1_Crew.xlsx** (Chapters 4 and 7; Crew workbook of Appendix A): sheets Activities, Production, then Checks. The activity list with quantities, outputs per crew-day, crews and crew sizes, durations rounded up and worker-hours, and the four weekly production checks of the case.
- **Construction_Superintendent_2_Logistics.xlsx** (Chapter 3; Logistics workbook): sheets Site plan, Toilets, then Checks. Site and footprint, 1,392 linear feet of fence panels, 67 parking spaces, a farthest crane pick of 163.2 feet, and the toilet table as the case reads it.
- **Construction_Superintendent_3_Field_Cost.xlsx** (Chapter 13; Field cost workbook): sheets Lines, Months, then Checks. The field general conditions line by line, budget $525,022 against actual $547,985, month by month, and the daily cost of delay of $5,140.
- **Construction_Superintendent_4_Delay.xlsx** (Chapters 8, 14 and 15; Delay workbook): sheets Weather, Options, Holidays, then Checks. Rain days against the allowance, 9 calendar days granted, the windows 40 workdays late, an exposure of $125,941 if nothing is done, and the recovery options per workday recovered.
- **Construction_Superintendent_5_Safety.xlsx** (Chapters 11 and 12; Safety workbook): sheets Cases, Hours, then Checks. The three recordable cases, 78,216 hours worked on the site, and the rates by the published formula.
- **Construction_Superintendent_6_Punch.xlsx** (Chapter 16; Punch workbook): sheets Zones, Closing, Holidays, then Checks. 742 punch items closed workday by workday, by zone and with one walk at the end, and final completion on 17 August 2026.
- **Construction_Superintendent_Toolkit.docx**: the 5 check-lists of Appendix B, editable (Site start-up (before and during mobilization); The weekly foremen's meeting; The daily report; The weekly site safety inspection; Punch and closeout).

## 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. 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 7 exercises of Appendix A is done in the workbook it names.

The Delay and Punch workbooks compute dates on the case calendar: Monday to Friday, less the 11 holidays listed on their Holidays sheet, with WORKDAY and NETWORKDAYS. The start day and the finish day both count. Durations in workdays are rounded up.

Two inputs to try first:

1. In Construction_Superintendent_1_Crew.xlsx, on Activities, set the masonry crews (A430) from 2 to 1: the duration goes from 38 to 75 workdays.
2. In Construction_Superintendent_6_Punch.xlsx, on Zones, set the walk of level 3 to substantial completion: more items are still open on the day the building is handed over.

The workbooks are separate files with no link between them.

## A word of caution

Carrowdane Builders, Inc., Ludgrave County, the Ludgrave County Health Services Center and every party in the case are fictional. Quantities, outputs, prices, field costs, injury cases and liquidated damages are teaching assumptions, not market norms or recommendations. Standard forms and OSHA regulations change, and a state plan may add rules: read them in their current text and in the contract as signed, with your safety director and counsel. No software is described or recommended. Nothing here is legal or safety advice.
