Type in the blue cells on the left. The right side reads your task list.
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.
Task
Owner
Due date
Status
Percent complete
Blocked?
Notes / what it is waiting on
Days to due
Flag
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.
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.
One email when a new free calculator or trade guide ships. No spam, unsubscribe anytime.
Done — you are on the list.
Something went wrong. Please try again.
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.