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%59% util!0 OT wk2 wk span
Workload grid · projects × days
target 26.7h / 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
7.0
9.0
·
·
·
·
4.0
20.0
Day total
7.0
9.0
6.0
8.0
8.0
9.0
47.0
0w
Over target (> 115%)On targetUnder target (< 65%)OTOver 40h × weeks
Totalhours logged
47.0h
Utilization2 wk · 40h cap
59%
Overtime wksweeks above 40h
0
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-W1931.0h
2026-W2016.0h
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 × 2wk. ISO-week overtime uses the standard 40h threshold per week.