Table of Contents
Overview
The IWP Progress Curve is a dashboard widget that plots planned vs. actual progress over time for a set of Installation Work Packages (IWPs). It is the classic construction “S-curve”: a combination chart that overlays period-by-period activity (vertical bars) with cumulative running totals (smooth curves), letting you see at a glance whether work is tracking ahead of, on, or behind plan.
The chart can measure progress in hours (the default) or in quantity (units of measure), and it can be grouped by day, week, month, or year.
What The Chart Shows
The chart uses two value axes:
Left axis – Bars (per-period values): how much was estimated, earned, or actually worked during each individual period.
Right axis – Curves (cumulative totals): the running total from the start of the chart through each period. These are the S-curves.
You can turn each series on or off independently:
Series | Type | Meaning |
Estimated | Bar | Planned hours/quantity scheduled to be completed in that period |
Earned | Bar | Hours/quantity credited as complete in that period |
Developed | Bar (optional) | Planned development progress, weighted by each IWP’s % developed |
Actual Hours | Bar (optional, IWP only) | Hours actually charged to the IWP from approved timesheets |
Cumulative Estimated | Curve | Running total of planned progress — the planned S-curve |
Cumulative Earned | Curve | Running total of earned progress — the actual/earned S-curve |
Cumulative Actual Hours | Curve (optional, IWP only) | Running total of timesheet hours charged |
Reading the chart: where the Cumulative Earned curve sits relative to the Cumulative Estimated curve tells you schedule performance — above the planned curve means ahead of plan, below means behind. The Cumulative Actual Hours curve compared against earned shows productivity (are we burning more hours than we’re earning?).
How The Numbers Are Calculated
The chart is built from the IWPs that match the dashboard’s filters. For each reporting period (e.g., each week), the system computes a cumulative value for each series, and the per-period bars are simply the difference between one period’s cumulative total and the previous one.
Estimated / Planned curve
Planned progress is spread across each IWP’s scheduled duration using straight-line (linear) interpolation. For every IWP, at the end of each period:
If the period end is on or after the IWP’s finish date → the IWP contributes 100% of its estimated hours.
If the period end falls within the IWP’s scheduled window → it contributes a proportional share:
Estimated Hours × (days elapsed from start to period end ÷ total scheduled duration)
If the IWP hasn’t started yet → it contributes nothing.
These partial values are summed across all IWPs in scope to produce the cumulative planned curve. The schedule dates used are controlled by the Group By Date setting (Planned or Forecast).
Earned curve
Earned progress reflects work actually credited as complete. There are two calculation bases (set by Earned Hours Basis):
Progress Entered Date (default): Uses the progress history recorded against each IWP. For each period, it takes the most recent earned-hours entry for each IWP dated before the period end, and sums them. This reflects when progress was recorded in the system.
Step Completion Date: Sums the earned hours of each individual execution step that was marked complete (and not excluded) before the period end. This reflects when the work was actually finished, which can differ from when it was entered.
Actual Hours (IWP only)
Actual hours come exclusively from approved timesheets charged to the IWP. Hours from un-approved timesheets are not counted. Hours are attributed to the day they were worked (with special half-credit handling when the chart is grouped in half-day intervals).
Quantity mode
When the chart’s value is set to Quantity instead of Hours, earned and estimated values are weighted by each IWP’s key quantity relative to its estimated hours, so the curve reflects installed units rather than labor hours. (Actual Hours is not available in Quantity mode.)
Settings Reference
Setting | Default | Description |
Value | Hours | Measure progress in Hours or Quantity |
Reporting Time Interval | Week | Period grouping: Half-Day, Day, Week, Month, or Year |
Intervals Previous | 6 | Number of past periods to show (max 18 for week/month/year, 30 for day/half-day) |
Intervals Future | 6 | Number of future periods to project (max 30) |
Show Estimated / Estimated Cumulative | On | Planned bars and planned S-curve |
Show Earned / Earned Cumulative | On | Earned bars and earned S-curve |
Show Development | Off | Adds a planned-development bar series |
Show Actual / Actual Cumulative | Off | Timesheet-based actual hours (IWP only) |
Group By Date | Planned | Use Planned or Forecast schedule dates for the estimated curve |
Earned Hours Basis | Progress Entered Date | Whether earned values follow entry date or step completion date |
Show Cumulative Hours as % of Target | Off | Plots cumulative curves as a percentage of a target value instead of raw hours |
Target Hours | 0 | The target used for the % calculation above |
Start with Project Cumulative Hours | Off | Starts cumulative totals from the project’s full history rather than resetting at the first visible period |
Shift Start | 0:00 | Time of day the working day/shift begins (affects period boundaries) |
Reporting Cutoff Offset Minutes | 0 | Fine-tunes the daily reporting cutoff for half-day reporting |
The chart also honors the project’s time zone and reporting cutoff hour, so period boundaries align with the project’s local working calendar.
Required Fields
An IWP must have both a start and finish date for the selected schedule type (Planned or Forecast) to appear on the chart at all. IWPs missing either date are excluded from the dataset entirely — they contribute to none of the series (estimated, earned, or actual hours), even if they have recorded progress or charged timesheet hours. Beyond that baseline requirement, each series needs:
Planned S-curve: Estimated Hours on each IWP (for Quantity mode, a Key Quantity greater than zero is also required).
Earned S-curve: Recorded progress history (earned-hours entries) on the IWP, or completed execution steps with earned hours — depending on the Earned Hours Basis selected.
Actual Hours: Approved timesheet entries charged to the IWP.
Practical Notes
Progress is rolled up from the bottom: execution steps carry weights, and an IWP’s percent complete and earned hours are derived from the weighted completion of its steps. The curve reflects those rolled-up earned values.
Because the estimated curve uses straight-line interpolation, it assumes work is planned to accrue evenly across each IWP’s duration; it does not follow a manually entered planned distribution.
The earned curve is “as-of” accurate — it always reflects the latest known earned value for each IWP up to each period, so historical periods stay consistent with the most current progress data.
