Enter Project Data
This page keeps a single-column flow. The calculator fields use a responsive 3-column, 2-column, and 1-column arrangement for large, medium, and mobile screens.
Example Data Table
Use this sample to understand how weekly tracking can be structured before entering your own values.
| Week | Total Tasks | Completed | In Progress | Blocked | Overdue | Actual Hours |
|---|---|---|---|---|---|---|
| Week 1 | 120 | 12 | 26 | 8 | 4 | 42 |
| Week 2 | 120 | 24 | 25 | 7 | 6 | 81 |
| Week 3 | 120 | 38 | 24 | 6 | 8 | 118 |
| Week 4 | 120 | 54 | 22 | 6 | 9 | 156 |
| Week 5 | 120 | 70 | 18 | 4 | 7 | 198 |
Formula Used
Completion Rate (%) = (Completed Tasks / Total Tasks) × 100
Schedule Progress (%) = (Elapsed Days / Planned Project Days) × 100
Expected Completed = Total Tasks × (Schedule Progress / 100)
Task Gap = Completed Tasks − Expected Completed
Schedule Variance = Completion Rate − Schedule Progress
Critical Completion (%) = (Completed Critical Tasks / Critical Tasks) × 100
Planned Hours to Date = Total Planned Hours × (Elapsed Days / Planned Project Days)
Hours Efficiency (%) = (Planned Hours to Date / Actual Hours Spent) × 100
Velocity = Completed Tasks / Elapsed Days
Forecast Total Days = Total Tasks / Velocity
Health Score = Weighted blend of schedule, critical completion, efficiency, blocked share, and overdue share
Blocked and overdue counts can overlap with active tasks. That allows the model to track execution risk without forcing every status into a single bucket.
How to Use This Calculator
- Enter a project name so exported files stay clearly labeled.
- Provide total tasks, completed tasks, and in-progress tasks.
- Add blocked and overdue counts to show execution risk.
- Enter critical tasks and completed critical tasks for priority tracking.
- Fill in elapsed days, total planned days, and optional buffer days.
- Enter total planned hours, actual hours spent, and team size.
- Press Calculate Completion to display the summary above the form.
- Review the metrics table, chart, and forecast before exporting the results to CSV or PDF.
Frequently Asked Questions
1. What does completion rate show?
Completion rate shows the percentage of total tasks already finished. It is the simplest progress indicator, but it should be read together with schedule progress, blocked work, and critical task completion for a fuller picture.
2. Why compare completion rate with schedule progress?
This comparison reveals whether the project is moving faster or slower than planned. A lower completion rate than schedule progress usually means the project is behind pace and may need resource or scope adjustments.
3. What is task gap?
Task gap is the difference between actual completed tasks and the number that should be finished by this point in the timeline. Positive values indicate a lead, while negative values indicate a shortfall.
4. How should blocked tasks be interpreted?
Blocked tasks represent work that cannot move because of approvals, dependencies, missing information, or technical obstacles. A rising blocked share often weakens forecast reliability and reduces overall project health.
5. What does hours efficiency mean here?
Hours efficiency compares planned hours to date against actual hours spent. Values near or above 100% suggest stronger efficiency. Lower values can indicate rework, poor sequencing, or underestimated effort.
6. Why track critical task completion separately?
Not every task carries the same delivery risk. Critical task completion highlights whether the high-impact work is advancing. A project can show decent overall completion while still missing crucial milestones.
7. How is forecast total duration estimated?
The forecast divides total tasks by current task velocity. It assumes recent productivity continues. That makes it useful for quick planning, though it should be reviewed when staffing, scope, or task complexity changes.
8. What does the health score summarize?
The health score combines schedule variance, critical completion, hours efficiency, blocked share, and overdue share into one signal. It helps managers spot overall condition quickly before investigating the detailed metrics.