Task Efficiency Report

What it's for: comparing estimated vs actual time on tasks to see where work runs over or under.

KPI cards: Total Tasks, Completion Rate (% completed), Avg Efficiency (estimated ÷ actual — green ≥100%, amber ≥80%, red below), and Time Variance ((actual − estimate) ÷ estimate).

Table columns: Task Name, Project, Employee, Estimated, Actual, Efficiency (a pill = est ÷ actual × 100), Start Date, End Date, Status, and Priority. Everything sorts; default is most efficient first.

Filters: Project, Employee, Status (All / Completed / In Progress), Priority (All / High / Medium / Low), and search.

Where the data comes from: your tasks across all projects and phases. Estimated and actual come from each task's estimated hours and logged hours; the assignee is the task's first assigned person; a task counts as Completed at 100% completion or when its status reads done/closed/finished.

What to understand: Efficiency above 100% means the task beat its estimate (took less time than planned); below 100% means it ran over. Tasks need both an estimate and logged time to be meaningful here.