What you need and what it is for
An S-curve in Excel (or any spreadsheet) is built from a table of activities and a formula that spreads each activity's value over its days. Adding up by cut-off date gives the cumulative planned value, which is what the curve plots.
For each activity you need the planned value (its cost in the budget), the start date and the end date. To compare against reality you also need the physical progress measured at the cut-off date.
It is an easy sheet to maintain when one person keeps it. Its limit shows up when several people measure progress at the same time or when the plan changes often.
How the sheet is laid out
One row per activity and one column per cut-off date. These are the columns of the example sheet.
| Column | What it holds | Example cells |
|---|---|---|
| A | Activity name (A2 to A5) | A2:A5 |
| B | Planned value in pesos (B2 to B5) | B2:B5 |
| C | Planned start date (C2 to C5) | C2:C5 |
| D | Planned end date (D2 to D5) | D2:D5 |
| E onwards | One column per cut-off date: the date goes in row 1 and below it the cumulative planned value of each activity | E1, E2:K5 |
The formulas, step by step
- In row 1, starting at column E, type the cut-off dates (weekly or monthly, including the start and the end of the project).
- In the first cell of the table (E2) enter the formula below and drag it right and down. Each cell says how much of that activity should be done by that date.
- Add up each column in a totals row: that row is the cumulative planned value (PV) at each cut-off date.
- Divide each total by the total project value if you want the curve as a percentage, and insert a line chart with the dates on the horizontal axis.
Written with Excel's English function names; the same functions have localized names in other languages.
Worked example
The same project as the S-curve guide: COP 400,000,000 with four activities. The values, dates and progress figures are invented for the example; the figures in the tables come from the same code the platform uses and match what the sheet formula would give.
| Activity | Planned value | Start | End | Progress measured at March 31 |
|---|---|---|---|---|
| Foundations | COP 60,000,000 | 2026-01-01 | 2026-01-31 | 100% |
| Structure | COP 120,000,000 | 2026-02-01 | 2026-03-31 | 50% |
| Masonry and roof | COP 90,000,000 | 2026-03-01 | 2026-04-30 | 20% |
| Finishes and building services | COP 130,000,000 | 2026-04-01 | 2026-05-31 | 0% |
| Cut-off date | Cumulative planned value | % of total |
|---|---|---|
| 2026-01-01 | COP 1,935,484 | 0.5% |
| 2026-01-31 | COP 60,000,000 | 15% |
| 2026-03-02 | COP 123,967,769 | 31% |
| 2026-04-01 | COP 229,344,262 | 57.3% |
| 2026-05-01 | COP 336,065,574 | 84% |
| 2026-05-31 | COP 400,000,000 | 100% |
At March 31 the plan said COP 225,737,705 should have been completed (56.4% of the project). What has been measured equals COP 138,000,000 (34.5%). Dividing what was done by what was planned gives 0.61: the project is behind the plan.
Common mistakes in the sheet
- Dates typed as text: subtracting them gives an error or zero. Check that Excel right-aligns them.
- Forgetting the first day when counting days: the formula adds one so that whole days are counted.
- Overwriting a formula with a number without noticing: the curve is wrong and nothing warns you.
- Changing the baseline every month without keeping the previous one: the planned curve stops being a reference.
When the spreadsheet stops being enough
If several people measure progress, if the plan is changed every week, or if you need the actual curve month by month and not only today's point, the sheet forces you to reconcile versions by hand. That is when a system that stores each measurement with its date helps. Until then, a well-kept sheet does the job.
Limits of this guide
It describes the straight-line spread of each activity's value, the general-purpose method. It does not replace critical-path scheduling and it does not set a mandatory way to draw the curve: your contract or your supervisor may ask for another. This guide does not offer an Excel file to download.
Frequently asked questions
How do I make an S-curve in Excel?
Build a table with value, start and end per activity, use a formula to work out how much should be done at each cut-off date, add up each column and plot the totals with a line chart.
Which formula spreads an activity's value?
The value multiplied by the fraction of days elapsed: the value times the smaller of one and the days since the start (counting the first day) divided by the total days, and never below zero.
Curve in pesos or in percentage?
In pesos if you use it inside one project; in percentage if you want to compare projects of different size.
Where can I download a template?
This guide does not include a file to download. With the column table and the formula you can build your own in a few minutes.
Sources
- General-purpose method (planned value and earned value); it does not depend on a standard or on external data. The example figures are calculated by Renka's code and are invented for illustration.