This terminal dock appointment spreadsheet is a free Excel template for coordinating scheduled arrivals, dock-door assignments, carriers, drivers, freight references, and actual terminal timestamps. Formula-based columns calculate planned end times, timing results, schedule conflicts, and estimated detention costs from the information entered by the user.
The file contains three sheets: Dashboard, Appointments, and Settings. The Appointments sheet provides 200 prepared record rows, while the Dashboard summarizes a selected date and terminal. Settings control appointment durations, timing assumptions, terminal capacity, statuses, and dropdown values.
In practice
What this workbook helps you do
- ✓Keeps scheduled arrivals, dock doors, carrier details, freight references, statuses, and actual event times in one appointment register.
- ✓Flags overlapping appointments scheduled for the same terminal and dock door.
- ✓Calculates arrival variance, wait time, service time, turnaround time, detention minutes, and estimated detention cost.
- ✓Summarizes appointment activity by date, terminal, status, lateness, conflicts, and scheduled dock capacity.
Instructions
How to use the file
Set the operating assumptions
Start on Settings and review the yellow Settings inputs. The sample assumptions are a 15-minute on-time grace period, 120 free detention minutes, and a $75 hourly detention rate. Cells B8 and B9 set the accepted date range, initially January 1, 2020 through December 31, 2035.
This sheet also holds appointment types and planned durations, status options, three terminals, active dock doors, daily operating hours, six dock-door options, and Dashboard terminal choices. Daily dock capacity is calculated as active doors multiplied by operating hours.
Replace samples and enter appointments
The Appointments table covers rows 5 through 204. Populated records, including rows 5 and 6, are samples. Replace their input values when preparing the file for operations; unpopulated rows in the prepared range are blank operating rows.
Use the appointment entry cells in columns A through G, J through R, and AB. These include appointment ID, terminal, dock door, carrier, driver, scheduled arrival, type, references, trailer, commodity, pallets, status, actual timestamps, and notes. Dropdowns are provided for terminals, doors, appointment types, and statuses. Pallets accept whole numbers from 0 through 999.
Preserve and review formula columns
Do not paste over the blue calculated outputs in H, I, and S through AA. Planned Duration comes from the appointment type. Scheduled End adds that duration to Scheduled Arrival. Other formulas calculate arrival variance, wait, service, turnaround, detention minutes, estimated detention cost, on-time status, schedule conflict, and data-quality results.
Filter the daily dashboard
On Dashboard, set the Dashboard controls in B3 for Selected Date and E3 for Terminal Filter. Choose All Terminals or one configured terminal. Review total and completed appointments, late arrivals, conflicts, records needing review, active dock activity, no-shows, average wait, average turnaround, and estimated detention cost. A status chart shows appointment counts for the selected view.
Inside the file
Included features
Build a daily terminal dock schedule
Each operating row can identify the terminal, dock door, carrier, driver, trailer, reference number, commodity, pallet quantity, and appointment type. Scheduled Arrival establishes the start of the slot. The selected appointment type supplies its configured planned duration, and Excel calculates Scheduled End.
Status options include Scheduled, Checked In, At Dock, Completed, Canceled, and No Show. Actual Check-In, Dock Start, Dock Complete, and Actual Departure can be added as events occur, allowing the same row to carry the appointment from planning through departure.
Review dock-door overlaps before confirming assignments
The Schedule Conflict result compares scheduled time ranges for appointments using the same terminal and dock door. If another non-canceled appointment overlaps the interval between Scheduled Arrival and Scheduled End, the row returns Conflict; otherwise, it returns Clear. Canceled records return Not Applicable.
This warning identifies an overlap but does not assign a different door, prevent entry, or enforce a booking decision. Dispatchers or terminal staff must review the affected rows and adjust the door, arrival time, appointment type, or status as appropriate.
Measure terminal wait and turnaround
Arrival Variance measures the difference between Scheduled Arrival and Actual Check-In in minutes. Wait Time runs from check-in to dock start, Service Time from dock start to dock completion, and Turnaround Time from check-in to actual departure. Wait, service, and turnaround outputs do not fall below zero.
After turnaround exceeds the configured free period, the sheet calculates detention minutes. Estimated Detention Cost converts those minutes to hours and applies the rate stored in Settings. This is an operating estimate rather than an invoice or accounting entry.
Compare scheduled hours with dock capacity
The Dashboard includes a terminal summary for Atlanta, Dallas, and Chicago. For the selected date, it reports appointments, completed records, late arrivals, conflicts, and scheduled dock hours. Scheduled hours are the sum of planned appointment durations divided by 60.
Capacity Use divides scheduled dock hours by the daily capacity calculated in Settings. Capacity is based on active dock doors multiplied by daily operating hours. This percentage is a planning comparison; it does not account for staffing, breaks, door restrictions, commodity handling requirements, or unscheduled terminal activity unless those factors are reflected in the entered assumptions and records.
Common questions
About this workbook
The Appointments sheet has 200 prepared rows, from row 5 through row 204. Formula columns are already present across the full range. Populated rows are sample records, while unpopulated prepared rows are available for operating entries.
A record is On Time when Actual Check-In is no later than Scheduled Arrival plus the grace period in Settings. With the sample 15-minute grace period, a check-in more than 15 minutes after the scheduled time is marked Late.
The Data Quality Check can identify duplicate appointment IDs, missing required fields, and incomplete actual-time sequences. The Dashboard counts nonblank results that are not OK as records needing review. Users still need to verify the underlying information.
Yes. Settings cells B8 and B9 define the earliest and latest accepted dates. The selected Dashboard date, Scheduled Arrival, and actual event timestamps are validated against that range. The earliest date must remain before the latest date.
No. The file organizes dock appointment information and produces planning calculations only. It does not replace accounting, invoicing, legal, tax, DOT or FMCSA, safety, or other compliance advice and systems.
Editorial team
Prepared and checked with care
Casey Morgan
Fleet operations editorCasey turns dispatch, driver, vehicle, and delivery workflows into clear workbook guides.
About the editorial identities
Jordan Lee
Workbook quality editorJordan documents the automated formula, recalculation, download, and usability checks applied before publication.
About the editorial identities