S-Curve Generator
Generate a cumulative planned budget profile over a bounded number of periods with balanced, front-loaded or back-loaded shapes. Optional incremental actual amounts create an overlay without pretending that a smooth mathematical curve is a resource-loaded construction schedule.
By Dr. Hassan Khames EliwaLast updated
Result
Illustrative normalized profile, not a resource-loaded baseline. Actual rows are incremental; omitted periods mean zero within the reported range; no extrapolation after the last entry.
- Actual recorded
- 0.000 currency units
- Planned
Planned profile
| Period | Increment | Cumulative |
|---|---|---|
| 1 | 156.250 | 156.250 |
| 2 | 343.750 | 500.000 |
| 3 | 343.750 | 843.750 |
| 4 | 156.250 | 1,000.000 |
How it works
Start with the intended reporting basis
The duration is a whole number of equal reporting periods from one to 360. Decide whether a period means a week, month or another consistent interval before interpreting the result. Budget is a nonnegative total in one currency basis. The model allocates that total mathematically rather than reading quantities, crews, procurement commitments or payment terms. Use it for an initial conversation about profile shape, not as a substitute for an approved time-phased estimate.
See exactly how loading is generated
Normalized time t is elapsed periods divided by total periods. Balanced cumulative share is 3t² − 2t³, giving slow initial and final growth with a steeper middle. Front-loaded share is 1 − (1 − t)³. Back-loaded share is t³. Multiplying share by budget gives cumulative planned value. Only the balanced option has the familiar smooth S shape; the other options are explicit early- or late-loaded alternatives with the same starting and ending totals.
Use the increments as a reasonableness check
Planned period increment equals current cumulative value minus the preceding cumulative value. The table includes both figures because cumulative charts can hide an implausible monthly workload behind an attractive smooth line. All planned increments are nonnegative and their unrounded sum equals the entered budget. A zero budget is valid, but it is not evidence of a workable delivery plan. Compare peak period requirements against feasible crews, equipment, access and procurement availability.
Enter actuals as transactions for periods
Each actual row contains a period number and an incremental amount, not a cumulative balance. Periods must be unique integers inside the duration, with at most 40 rows. Rows can be entered out of order because the calculator sorts them. Amounts must be nonnegative. Missing periods within the observed range contribute zero; the actual series stops at the last entered period rather than extending a flat line into unreported future periods.
Do not infer progress from cash alone
The overlay compares amounts on the basis you selected. If planned value represents installed work but actuals represent supplier payments, the visual gap combines two different concepts. Deposits, retention, invoicing lag and material stored off site can all separate cash flow from physical delivery. Label the basis clearly and maintain a separate physical-progress or earned-value view when needed. This generator neither calculates earned value nor establishes that a project is ahead merely because actual expenditure exceeds the planned curve.
Worked example
Two checked profiles
With four periods, budget 1,000 and balanced shape, cumulative planned values are 0, 156.250, 500.000, 843.750 and 1,000.000. Increments are 156.250, 343.750, 343.750 and 156.250. Actual rows 1,100 and 3,250 produce cumulative actual points 100 at period one and 350 at period three.
For four periods and budget 1,000, front loading gives period-one cumulative value 578.125; back loading gives 15.625. Both finish at 1,000.000. The difference is allocation timing, not a change in total budget.
Expert tips
Common mistakes
- Entering cumulative actual balances instead of period increments.
- Comparing supplier payments with planned installed value without explanation.
- Treating a smooth cubic profile as an approved resource-loaded baseline.
Frequently asked questions
Is every option technically an S curve?
No. Balanced uses a smoothstep S profile. Front and back options are monotone cubic loading curves included to make early and late allocation assumptions explicit.
Can actuals exceed the budget?
Yes. Actual amounts are observations and are not clipped to the planned total. A higher cumulative amount needs interpretation against the chosen cost or value basis.
Why are duplicate actual periods rejected?
A single amount per period avoids accidental double counting. Sum multiple transactions for the same period before entering that period’s incremental total.
What does a missing actual period mean?
Within the reported range it contributes zero in the cumulative calculation. It does not mean that missing data were independently verified; resolve incomplete reporting before interpreting the overlay.
Can I show negative corrections?
Not in this version. Actual amounts must be nonnegative. Restatements, refunds and accrual reversals need a reconciled external ledger before entering a corrected period total.
Does the curve forecast completion?
No. It allocates a fixed total over a selected duration. It does not calculate remaining scope, critical-path logic or a statistically likely finish date from observed performance.
Related calculators
Related guides
Construction & ProjectReading an S-curve: planned, earned and actual on one chartA practical way to separate planned accomplishment, earned value and actual cost before interpreting the gaps.15 November 2026 · 8 min read
Construction & ProjectMeasuring physical progress: weighted milestones versus percent completeUse evidence-based milestones and stable weights to report completed work without confusing expenditure with physical progress.15 November 2026 · 8 min readSources and standards
About the author
Dr. Hassan Khames Eliwa holds a PhD in Construction & Built Environment and has more than 20 years of international project controls experience. He is Director of Eliwa Project Controls Limited in Auckland and founder of PMMilestone.org and PMMilestone.com.
Buy me a coffee