Completion rate calculator
The correct team completion rate is total completed divided by total assigned, not the average of each project's percentage. Replace the example rows with your own projects, or paste them straight from a spreadsheet.
| Row | A | B | C | D | Remove |
|---|---|---|---|---|---|
| 1 | Project | Done | Total | Rate | |
| 2 | 100.0% | ||||
| 3 | 0.0% | ||||
| 4 | Team | 1 | 10 | 10.0% |
- Share of tasks actually done
- 10.0%
- What averaging the percentages says
- 50.0%
Why is averaging percentages wrong?
Averaging percentages gives a one-task project the same weight as a 500-task project. In the example rows, one project is 1 of 1 done and the other is 0 of 9. The average of those rates says 50 percent, yet only 1 of 10 tasks is finished, which is 10 percent.
Can I paste from Excel or Google Sheets?
Yes. Copy three columns (project, done, total) and paste into the first Project cell. A header row is skipped, and rows are added as needed, up to 200. Nothing is uploaded: the sums run in your browser, and your rows are kept in this browser so they're there next time. "Back to the example" clears them.
The SQL version is in Calculate a dashboard completion rate without averaging percentages.