ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
TEMPLATE INSTRUCTIONS
2
3
Input the project completion date in cell D3. All other dates will then adjust based on that. All dates are based on weeks
4
Input the tasks in column A in reverse order of completion, with the last items at the top and the first items at the bottom
5
Input the name of the resource in column B for each task
6
Working back from the last task shade in the cells for the time it will take to complete that task.
7
Then shade the cells for the preceding tasks and repeat for all tasks.
8
For tasks with predecessors, make sure the precedcessors are due for completion before the successor.
9
For tasks with no dependencies, these can be shaded concurrently with other tasks.
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100