WBS Weighted Progress & EVM Rollup
Paste the WBS. Weights roll up the hierarchy, late tasks surface, the weekly report table copies out.
Plan % and PV are measured at this date. Defaults to today, so you can leave it alone.
Advanced settings
Column mapping
Guessed from your header row — confirm or change it. WBS code and task name are required.
First rows as read
Paste a WBS above (or drop a CSV) and the weighted rollup appears here. Nothing is uploaded — the numbers never leave this tab.
Frequently asked questions
Weighted progress or EVM — which one should I report?
Both tabs run on the same rollup, so pick the one your reader expects. Weighted percent complete answers "how far along is the project" in one number and is what most weekly status reports lead with. EVM (PV, EV, AC, SV, CV, SPI, CPI, EAC) follows the PMI / ANSI EIA-748 standard and answers "are we behind, and is it costing more than planned" — it needs cost columns, so if your WBS has no budget data, stay on the weighted progress tab.
What if my WBS has no weight column, or the weights don't add up to 100?
This percent complete rollup calculator picks a weight source in order: the weight column, then planned effort, then equal weights across sibling tasks — and it always shows on screen which one it used, because a silently swapped weight changes every number above it. Weights never have to total 100: siblings under the same parent are normalized against their own sum, so 40 + 20 + 30 man-days behave exactly like 44.4% + 22.2% + 33.3%. When a raw sum isn't 100, a badge tells you it was normalized rather than hiding it.
Why does this weighted progress calculator ask for a data date?
Actual progress is whatever your sheet says, but planned progress only exists relative to a date. The data date straight-line interpolates each task between its plan start and plan end — before the start it is 0%, after the end it is 100% — and that plan number is what drives the difference column and PV in the earned value calculation. Change the data date and the plan side moves while your actuals stay put, which is exactly how you check "were we behind last Friday too?". It defaults to today, so you can ignore it.
Why do SPI and CPI show a dash instead of a number?
Because dividing by zero isn't a schedule index. SPI is EV / PV, so if PV is zero — no plan dates mapped, or nothing was scheduled to start by your data date — SPI is undefined and shows an em dash. CPI is EV / AC and EAC is BAC / CPI, so both go blank when there is no actual cost column, or when the actual cost so far is zero. Filling those cells with 0 or 1 would put a made-up number in your weekly report, so the dash stays until the input exists.
Does my cost and schedule data get uploaded anywhere?
No. The parsing, the WBS weighted progress rollup and the EVM math all run in JavaScript inside this tab — there is no server to send a project plan to, and no account to create. You can verify it instead of trusting it: open your browser's developer tools (F12), select the Network tab, then paste your WBS and roll it up. No request appears. Turn on airplane mode and it still works, and only your column mapping and format settings are kept in this browser's local storage — never the tasks, costs or dates.