Productivity

Timesheet Summarizer

Paste a CSV or edit the table directly. Get totals by project, day, and week, plus utilization and overtime flags. All local.

Timesheet Summarizer — Weekly Workload Grid
v2026.Q2
Week-over-week

Hours by project · day grid

Σ47.0h total%118% util!1 OT wk1 wk span
Workload grid · projects × days
target 13.3h / row
Project
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Total
OT
Acme redesign
·
6.0
8.0
6.0
5.0
·
·
25.0
Internal
·
·
·
2.0
·
·
·
2.0
Beta discovery
·
·
·
·
4.0
7.0
9.0
20.0
Day total
6.0
8.0
8.0
9.0
7.0
9.0
47.0
1w
Over target (> 115%)On targetUnder target (< 65%)OTOver 40h × weeks
Totalhours logged
47.0h
Utilization1 wk · 40h cap
118%
Overtime wksweeks above 40h
1
Projectsdistinct rows
3
By project share

Mix of total hours

Acme redesign25.0h · 53%
Beta discovery20.0h · 43%
Internal2.0h · 4%
By ISO week

Overtime detection · 40h threshold

2026-W3047.0h · OT
Methodology

Day-of-week buckets aggregate hours per project across the entire entry range (Mon–Sun, UTC). Row target is total capacity (hrs/wk × weeks) divided evenly across projects — over-target rows tint rose, under-target tint amber. OT chip = hours beyond 40h × 1wk. ISO-week overtime uses the standard 40h threshold per week.