Free Excel template · for Excel lovers

Your weekly report, in one second.

A team tracker that writes the status email and the screenshot for you. You type one date when a task is done. The file does the rest.

Download free Excel, 248 KBSee what’s insidePlay: find the 12 mistakes
Team-Task-Tracker-Darwish-Qannan.xlsx
The Overview sheet: progress, late work, team load and the tasks that need attention
‹›OverviewTasksTeamWeekly EmailSettings+

The email is already written.

Type the date. The numbers update. The email and the snapshot are ready.

The Weekly Email sheet: the email text on the left and the live snapshot of the Overview on the right
Weekly Email. The text on the left, written from the Tasks sheet: done this week, late and why, blocked, coming up. The live snapshot of the Overview on the right: click it, Ctrl + C, and paste it under the text.

What’s inside

Set it up once on Settings. After that, you only type on Tasks.

Overview

Five numbers, progress by effort, a donut, load by person, and the five tasks that need attention now.

Tasks

A real Excel table ready for 1,000 tasks. Formulas stay out of sight until you type a task.

Team

Open work per person against capacity: OK, Busy or Overloaded, and the next task each one has to deliver.

Weekly Email

The status email, already written: done this week, running late and why, blocked, and what is coming up.

Settings

Team name, your weekend (Friday and Saturday, or Saturday and Sunday), weights, members and public holidays.

The Tasks sheet: done rows struck through, status and days left filled in
Tasks. Put the date in Completed and the row strikes through. Status and days left fill themselves.
The Team sheet: open work per person against capacity
Team. Who is over capacity, who has room, and the next task each person has to deliver.
Tasks done
38%
Work done
22%

It won’t flatter your progress.

Most trackers count tasks. This one also weighs them by effort, so when the big tasks are still open, the Overview says so in plain words.

How it works

Set it up once. After that, one date per task.

  1. 01

    Add your team

    Names, your weekend and your holidays, once, on Settings.

  2. 02

    List the tasks

    Owner, effort, start and due date. New rows fill themselves.

  3. 03

    Type one date

    When a task is done, put the date in Completed. Ctrl + ; types today.

  4. 04

    Send the report

    Open Weekly Email, copy the text and the snapshot, paste, send.

Free. No sign-up. No macros.

Want it set up around how your team works? Let’s talk →

Download free Excel, 248 KB