WB WorkbookBarn All workbooks

Free calculator · nothing to download

Project Task Tracker

Type in the blue cells on the left. The right side reads your task list.

THE TEAM — UP TO SIX PEOPLE
HOW YOU RUN THIS PROJECT

OPEN TASKS BY PERSON

Person 1
Person 2
Person 3
Person 4
Person 5
Person 6

WHERE THE PROJECT STANDS

Tasks in the plan
Finished
Still open
PERCENT COMPLETE
Average progress across all tasks
Ahead of or behind your target

WHAT NEEDS ATTENTION TODAY

Overdue right now
Due inside your due-soon window
Blocked and waiting on something
Open tasks with no due date
Open tasks with nobody on them
Marked done but under 100 percent

ROUGH EFFORT LEFT — AN ESTIMATE, NOT A QUOTE

Hours of work still to do
Weeks at your current pace
Carrying the most open work
Open tasks on their plate

Task List

One task per row. The last two columns fill themselves in.

TaskOwnerDue dateStatusPercent completeBlocked?Notes / what it is waiting onDays to dueFlag
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

Where that leaves you

Want it as a spreadsheet you own?

The full workbook adds the tabs this page cannot: a monthly log, a dashboard with charts, and your own copy that works offline in Google Sheets or Excel. One purchase, no subscription.

Get the workbook

Keep it

Project Task Tracker — the full workbook

Same formulas as this calculator, plus the tabs, the charts and a 12-month history that this page cannot hold. Google Sheets and Excel. One purchase, no subscription.

Buy on Etsy · $14.99What is inside →

Get the next free tool

One email when a new free calculator or trade guide ships. No spam, unsubscribe anytime.

Educational estimates only. These calculators and workbooks do the arithmetic on the figures you enter; they are general-purpose tools, not financial, investment, tax, legal, lending, insurance or construction advice, and no result is a quote, an offer, or a guarantee of any outcome. Results depend entirely on your inputs and assumptions. Verify anything you intend to rely on with a licensed professional — a CPA, attorney, lender, licensed contractor, or your own agent. WorkbookBarn and Marcos Gil accept no liability for decisions made using these tools. Marcos Gil is a licensed Kentucky real estate agent (License No. 296259) and is not a lender, CPA or attorney.

WorkbookBarn · All free calculators · Workbooks