Scribd
Upload
91 views6 pages

Capacity Planner Excel

The document is a resource planning sheet that assigns projects and work hours to 7 resources over several dates, with many dates showing 0 hours allocated for most resources.

Uploaded by

Geetha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
91 views6 pages

Capacity Planner Excel

The document is a resource planning sheet that assigns projects and work hours to 7 resources over several dates, with many dates showing 0 hours allocated for most resources.

Uploaded by

Geetha
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 6

13-Mar

20-Mar

27-Mar
14-Feb

21-Feb

28-Feb
Project Resource Name Effort(Hr)

10-Jan

17-Jan

24-Jan

31-Jan

6-Mar
7-Feb
3-Jan
Project No 20 5 5 5 5

50 10 10 10 10 10

25 5 5 5 5

25
20 5 5 5 5

30 5 5 5 5 5 5

55 5 5 5

30 5 5 5 5 5 5

35 5 5 5

58 2 2 2 2 2 2 2 2 2 2 2 2 2

40 5
10 10 10 10 10
15 15 15 15 15 15 15
10
5 5 5 5
5 5 5 5 5
5 5 5
5
5
5
2
5
5
5

10
3-Apr

5
5
5
2
5
5
5

10
10-Apr

5
5
2
5
5
5
17-Apr

5
5
2
5
5
5
24-Apr

5
5
2
5
5 1-May

5
5
2
5
5

8-May

5
5
2
5 15-May

5
2
5

22-May

5
2
29-May

5
2
5-Jun

5
2

12-Jun

5
2

19-Jun

5
2

26-Jun

5
2

3-Jul

5
2

10-Jul
5
2

17-Jul
5

24-Jul

31-Jul

7-Aug

14-Aug

21-Aug

28-Aug

4-Sep

11-Sep
18-Sep

25-Sep

2-Oct

9-Oct

16-Oct

23-Oct

30-Oct

6-Nov

13-Nov

20-Nov

27-Nov

4-Dec

11-Dec

18-Dec

25-Dec
Planner

13-Mar
20-Mar
27-Mar
14-Feb
21-Feb
28-Feb

10-Apr
17-Apr
24-Apr
Capacity

10-Jan
17-Jan
24-Jan
31-Jan
Resource Type

1-May
8-May
6-Mar
7-Feb

3-Apr
3-Jan
1 Gajanan A 2340 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
2 Rahul J 2340 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
3 Manoj S 2340 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
4 Vikas P 2340 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
5 Sundar S 2340 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
6 Jagan G 2340 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
7 Akbar 2340 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
8 Hanaa AL-Kiyumi 2340 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9 Basma 2340 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 Amina Ebrahem 2340 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
11 Zainub Mahruqi 2340
Resource Pool
1 Gajanan A 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
2 Rahul J 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
3 Manoj S 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
4 Vikas P 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
5 Sundar S 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
6 Jagan G 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
7 Akbar 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
8 Hanaa AL-Kiyumi 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
9 Basma 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
10 Amina Ebrahem 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
11 Zainub Mahruqi 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
Planner
15-May
22-May
29-May

13-Nov
20-Nov
27-Nov
14-Aug
21-Aug
28-Aug

11-Dec
11-Sep
18-Sep
25-Sep

16-Oct
23-Oct
30-Oct
12-Jun
19-Jun
26-Jun

6-Nov
10-Jul
17-Jul
24-Jul
31-Jul
7-Aug

4-Dec
4-Sep

2-Oct
9-Oct
5-Jun

3-Jul
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Resource Pool
45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45 45
18-Dec
25-Dec

Total
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0
0 0 0

45 45 2340
45 45 2340
45 45 2340
45 45 2340
45 45 2340
45 45 2340
45 45 2340
45 45 2340
45 45 2340
45 45 2340
45 45 2340

You might also like