Resource Guru - Capacity planning template .xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1		Project name:										My project
2
3	resourceguruapp.com
4
5	Project Manager	Sarah
6	Project Start Date	1/3/2023
7	Project End Date	12/20/2023
8
9
10	Resource name	Role	Jan 23	Feb 23	Mar 23	Apr 23	May 23	Jun 23	Jul 23	Aug 23	Sep 23	Oct 23	Nov 23	Dec 23	Total days 2023
11	Working days per month (available)		20	20	20	20	20	20	20	20	20	20	20	20	240
12	Michael	Designer	15	6	2										23
13	Sarah	Copywriter	12	8	3										23
14	Omar	Full Stack Developer	13	5	10										28
15	-	-													0
16	-	-													0
17	-	-													0
18	-	-													0
19	-	-													0
20	-	-													0
21	-	-													0
22	Working days per month (used)		40	19	15	0	0	0	0	0	0	0	0	0	74
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