Skip to content
Task Tracking with Dependencies
Share
Explore

Tracker

Plan your budgeted task timeline. Then, track how you're progressing towards your deadlines and visualize your tasks on a gantt chart.

Instructions

Start by filling out your tasks in
, and budget start and end dates.
As you begin working on your tasks, adjust the actual days to complete in
.
Visualize your progress in
.
Want to supercharge this doc? Turn on
when tasks are completed.

Two rules to avoid circular references

The first task can't have a dependency
A task can't be dependent on itself

Step 1: Plan

This view shows the tasks during the planning stages. For each task (except the first one), ask yourself -
what task needs to be completed before I can begin working on this task?
Input that task into the
dependency
column.

Also input the budgeted start dates and end dates for each task.

Total budgeted days:
124 days
Name
Dependency
Budgeted start date
Budgeted end date
Budgeted days
1
Write script
1/7/2019
1/15/2019
8 days
2
Find actors
Write script
1/15/2019
1/26/2019
11 days
3
Reserve stage
Find actors
1/26/2019
2/28/2019
33 days
4
Build set
Find actors
1/26/2019
2/11/2019
16 days
5
Rehearse 1
Find actors
1/26/2019
2/19/2019
24 days
6
Rehearse 2
Build set
2/11/2019
2/21/2019
10 days
7
Rehearse 3
Rehearse 2
2/21/2019
2/24/2019
3 days
8
Sell tickets
Reserve stage
2/28/2019
3/4/2019
4 days
9
Promote
Reserve stage
2/28/2019
3/8/2019
8 days
10
Perform it live
Promote
3/8/2019
3/15/2019
7 days
There are no rows in this table
124 days
Sum


Step 2: Actual

This view shows the tasks during the execution, or actual, phase. As you start to work on your tasks, you'll have a better idea of how long it will take to complete each task.

Adjust the sliders below and notice how it affects all the tasks downstream.

Summary: We are currently
7
days
over
budget
🙁

✔️
Name
Dependency
Actual Duration (days)
Diff from budget
Reset to budget
Start date based on dependency
End date based on dependency
1
Write script
00
21
13
Reset
1/7/2019
1/28/2019
2
Find actors
Write script
00
11
13
Reset
1/28/2019
2/8/2019
3
Reserve stage
Find actors
00
20
0
Reset
2/8/2019
2/28/2019
4
Build set
Find actors
00
16
13
Reset
2/8/2019
2/24/2019
5
Rehearse 1
Find actors
00
28
17
Reset
2/8/2019
3/8/2019
6
Rehearse 2
Build set
00
10
13
Reset
2/24/2019
3/6/2019
7
Rehearse 3
Rehearse 2
00
10
20
Reset
3/6/2019
3/16/2019
8
Sell tickets
Reserve stage
00
4
0
Reset
2/28/2019
3/4/2019
9
Promote
Reserve stage
00
4
-4
Reset
2/28/2019
3/4/2019
10
Perform it live
Promote
00
7
-4
Reset
3/4/2019
3/11/2019
There are no rows in this table

Reset all tasks to budget


Step 3: Gantt

This view shows all the tasks in a Gantt chart view.

Key

On schedule
Behind schedule
Write script
Find actors
Reserve stage
Build set
Rehearse 1
Rehearse 2
Rehearse 3
Sell tickets
Promote
Perform it live
Jan 7
Jan 21
Feb 4
Feb 18
Mar 4
Mar 18
Write script
Find actors
Reserve stage
Build set
Rehearse 1
Rehearse 2
Rehearse 3
Sell tickets
Promote
Perform it live


Want to supercharge this doc?

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.