Automate·Intermediate·Playground·15 min·Updated Sep 30, 2026

Spot the overallocated teammate

Scenario

A team lead suspects someone is overcommitted this week.

Mission

Find who's allocated past a 40-hour week across their projects.

Start Files

PersonProjectHours
Jess OkoroWebsite Redesign18
Jess OkoroQ4 Campaign14
Jess OkoroInternal Tools12
Theo LindqvistMobile App22
Theo LindqvistAPI Migration16
Preview — first 5 rows of weekly-task-hours.csv

Your task

  1. Sum the hours allocated to each person across all of their project rows.
  2. Compare each person's total to a standard 40-hour week.
  3. Identify who's over, and by how much, so work can be reassigned.

Prompt idea:

Here is a weekly task allocation sheet with hours per person per project. Sum each person's total hours and tell me who's allocated over 40 hours this week, and by how much.

Check Your Result

Which person is allocated more than 40 hours total across their projects this week?

Need a hint?

Sum hours per person across all their project rows, then compare each total to a 40-hour week.

Reveal Solution

The solution files contain the completed challenge. Review the approach to see if you missed any edge cases.

Related Workflows

WORK WITH LIMINALS

Make AI useful for your team.

Get practical help with AI consulting or ask about training courses for your team.