← Back to Project Management Tools
✓ No login required · ✓ No data upload · ✓ Print-ready

Schedule Delay Analysis Tool

Free schedule delay analysis tool for construction projects. Compare planned vs. actual dates, flag critical activities, and log delay causes and impacts.

Sample Project
Analyse planned vs. actual dates, delays, critical activities and potential schedule impacts — summarised automatically and ready to print or generate as a full detail report.
by Shahid Pervaiz: pervaiz.shahid@gmail.com
Analysis No.SDA-001
Data Date—
Activities0
Rev.A
Not saved to a file yet 📄 See Sample Report

Analysis Setup

Project Schedule Overview

Schedule Summary

Activities — Planned vs. Actual

Delay (Days) and Delay Status are calculated automatically from baseline vs. actual/forecast dates
No. Activity / Task WBS / Zone Critical Baseline Start Baseline Finish Actual / Forecast Finish Delay Status % Complete Status Delay Cause Remarks

Delay Log & Impact Register

All fields are editable
No. Delay / Event Description Related Activity Category Days Impact Critical Path Responsibility Status Remarks Scan
Method & practical use

Understand the result.

Free schedule delay analysis tool for construction projects. Compare planned vs. actual dates, flag critical activities, and log delay causes and impacts.

How to use this tool

  1. Enter the project details and reporting date; replace any sample records.
  2. Add or import your records, then review the summaries and outstanding actions.
  3. Save the project and use the available export or print controls to share the current report.

Units & method

Use the dates, quantities and currency shown in the workspace. Keep one currency and a consistent reporting cut-off.

Compare activity planned and actual dates and record delay events. A variance log does not establish critical-path causation or contractual entitlement.

Method: the owner’s supplied worksheet and the arithmetic described above.

Worked examples

Illustrative inputs for checking the method; these are not project records.

Worked scenario

Example: a planned finish on 10 October and actual finish on 15 October has a five-calendar-day variance; attribution needs separate analysis.

Frequently asked questions

What does this tool calculate or track?

Free schedule delay analysis tool for construction projects. Compare planned vs. actual dates, flag critical activities, and log delay causes and impacts.

Which units and assumptions should I use?

Use the dates, quantities and currency shown in the workspace. Keep one currency and a consistent reporting cut-off. Compare activity planned and actual dates and record delay events. A variance log does not establish critical-path causation or contractual entitlement.

Can I save or share the result?

Use the save, export and print controls shown in this workspace. Where CSV export is available, the exported data can be opened in a spreadsheet. Browser print can save a PDF.

Continue your workflow

How to use the Schedule Delay Analysis Tool

Everything runs in your browser — nothing is uploaded. If you are new to the tool, follow these steps in order.

1

See what the tool can do

Press Load Sample Data to fill the tool with a sample analysis. Then scroll down the page:

  • Analysis Setup — project, client, contractor, location, analysis number and date, and contract reference.
  • Project Schedule Overview — contract start, baseline completion, data date, forecast completion, original duration and EOT granted.
  • Schedule Summary — forecast delay, critical delays and responsibility split.
  • Activities — Planned vs. Actual — baseline and actual/forecast dates for each activity.
  • Delay Log & Impact Register — one row per delay event with days of impact and responsibility.

The first time you open the tool (when there is no data of yours in this browser) the sample is loaded for you, so you can see how it works straight away. Replace it with your own entries, press + New Project / Clear All to start empty, or load your saved project.

Load Sample Data replaces the data in the tool. Save your own work first.

2

See how the data file looks

Press ⬇ Export Data (.csv). It downloads the whole analysis as one CSV file that opens in Excel. The file is split into blocks, each starting with a title line and a heading row:

ColumnWhat to enterExample
Analysis InfoProject, Client, Contractor, Location, Analysis No., Analysis Date, Prepared By, Contract/Ref No.
Schedule OverviewContract Start, Baseline Completion, Data Date, Revised Forecast Completion, Original Duration (Days), EOT Granted (Days), Notes
ActivitiesNo., Activity / Task, WBS/Zone, Critical, Baseline Start, Baseline Finish, Actual/Forecast Finish, % Complete, Status, Delay Cause, Remarks
Delay LogNo., Delay / Event Description, Related Activity, Category, Days Impact, Critical Path, Responsibility, Status, Remarks
3

Enter your own data and import it

Edit the rows inside each block and save the file as CSV (Comma delimited). Then press ⬆ Import Data (.csv) and choose the file.

  • Keep each block's title line (e.g. Activities) and its heading row exactly as exported, and keep one empty line between blocks.
  • Inside a block, columns are read by position, so don't add, remove or reorder columns.
  • Enter dates as YYYY-MM-DD.
  • Import replaces the analysis with the blocks in the file.

Excel often changes dates to your local format when it opens a CSV. Before saving, set the date columns to the custom format yyyy-mm-dd, or those dates may be left blank on import.

4

Add, edit and delete rows

You can also work straight in the table on the page at any time, with or without a CSV:

  • + Add Activity and + Add Delay Entry add a blank row to their table. Click any cell to change it.
  • The ✕ at the end of a row deletes it straight away. There is no undo, so save your project first.
5

Attach the scanned delay evidence

Each row of the Delay Log & Impact Register has a Scan column for one scanned copy or photo — for example the instruction letter, notice or site diary page that proves the delay. It can be a PDF (all its pages) or an image (JPG, PNG):

  • 📎 (faint) — nothing attached yet. Click it and choose the file.
  • 📄 (highlighted) — a file is attached. Click it to see it in a pop-up, where you can Replace, Remove or Download it.
  • Large photos and scanned images are reduced automatically to keep the project file small; a PDF must be under 5 MB.
  • The file is kept in the project file when you save the project, and comes back when you load it. It is not uploaded anywhere.

Autosave in this browser keeps the details but not the attached files (the browser has too little room). Save the project to keep them.

6

Save your project and open it later

💾 Save Project (.json) saves the setup, schedule overview, activities and delay log in one .json project file. 📂 Load Project opens that file again, on any computer.

The note beside the Save button tells you whether you have unsaved changes or when you last saved. If you try to close or leave the page with unsaved changes, the browser asks you to confirm first (not needed when Autosave is ticked, because your work is kept in this browser).

Use the project file for backups and for sharing with colleagues. Don't edit it by hand.

7

Print, PDF and report

  • 🖶 Print / Save as PDF prints the page as you see it, in print-friendly colours. To get a PDF, choose Save as PDF as the printer in the print dialog.
  • 📄 Generate Report opens a formatted delay analysis report in a new tab, with its own Print / Save as PDF button. If nothing opens, allow pop-ups for this site. To see a report the tool makes from its sample project (5 pages, PDF), press 📄 See Sample Report beside How to use.
8

Other buttons and options

  • Autosave in this browser (tick box) — while ticked, your work is kept automatically in this browser and comes back the next time you open the page. It stays only on this computer and browser. It is not a backup; use Save Project for that.
  • 👁 View Current Data jumps down to the tables.
  • ↻ New Analysis starts the next analysis: project setup is kept, the schedule dates, activities and delays are cleared, and the analysis number moves on (it asks first).
  • + New Project clears everything (it asks first).
  • Clear All empties the activity and delay tables (it asks first).
9

Choose the date format

Press 📅 Date format in the toolbar and choose how dates are shown and typed in every date box: DD/MM/YYYY, MM/DD/YYYY, YYYY-MM-DD, DD-MM-YYYY, DD.MM.YYYY or DD-Mon-YYYY. Type a date in that format, or click the 📅 in a date box to pick it from a calendar. A date that doesn't fit the format is outlined in red and not accepted.

The same format is used in the printout and in the generated report and its PDF. It changes only how dates look — your saved project and CSV files are not affected. Your choice is remembered in this browser for every tool on this site.

10

Explore the other tools

Press ☰ All Tools at the top of the page to see every engineering, project management and AI tool on this site, in the same order as the homepage. Type in the search box to find one quickly, then click it to open it. The tool you are using is marked you are here.

The Related tools links at the bottom of this page lead to tools that are often used together with this one.

All Tools

← Homepage