ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
INSTRUCTIONS
2
1)This sheet is designed to function with up to 15 resources and supports a maximum of 50 entries in the dates column.
3
2)Simply copy the required data from Primavera P6 and paste it into the "Raw Data from P6" sheet. (Make sure the formatting of copied data to be same as shown in video).
4
3)Go to the "Number of Resources" sheet and adjust the Working Hours per Day to reflect the actual conditions and calculate the correct number of resources.
5
4)In the Resource Histogram sheet, check the boxes corresponding to resources that exist. Leave unchecked any boxes for resources not in use.
6
5)Once you’ve completed the steps above, enjoy the automatic generation of your Resource Histogram with just one click!
7
6)NOTE: Be cautious when making changes to the formulas, as this may lead to discrepancies in the results.
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