ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Description: This capacity planning template can be used by any project manager who doesn't have complex scheduling tools like MS Project. It provides a calendar-like spreadsheet where development tasks can be assigned to different resources, to easily distribute the work and calculate the available man days per period (release, sprint..)

Instructions:

The template has two tabs: 'Cap planning', which contains the resource calendar and 'Resources', which contains all the project resources.
Cells A6-A9 shows the available resources. This is a reference to tab 'Resources'
Cells C6-L9 contain the resource calendar
Cell B1 shows the calculated amount of man-days available per sprint. The total number of available man days is calculated summing the days where resources are either assigned to a task or still unassigned.
Calendar days assigned to 'Bug fixing' or 'OFF' are not taken into account for this calculation, and are highlighted using conditional formatting, but the formula in cell B1 can easily be changed to accommodate other values.

,
2
3
4
5
6
7
8
9
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