Hi guys i know i started to annoy everybody but sorry its me again and again well lets go for it i have a project and i have lets say 30 workers and i want to divide them in 5 teams every team is 6 workers like this team1 and team2 and team3 and so on and i want to make like this team1 is for example: mike,robert,samual,alex,dan,.. and so on how can i make this in p6 can somebody illustrat it for me by a short example?? in order when i assign team1 to a task this mean the memeber of this team all of them are assigned to that task and so on thanks and sorry but im begginer in this
Resources groups in P6
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Hi Mohammad
I respond to your question about extracting resources assignments from P6 to excel. There are several ways to do this.
I prefer the following options
Option 1
Go to Assignments, on the left and menu of you screen. Make the appropriate, group & sort and also a filter to identify the required resources. Copy and paste this in a spreadsheet.
Option 2
Go to reports under the tab tools.
Select one of the standard reports, "resource loading"
Apply the filters you are requiring for the resources you want.
Run the report. This report is in csv format
Open this report in excel
Transform the csv to a excel file
Tailor the report to suit your needs.
We use this report to make manpower histograms for our portfolio management.
Regard Johannes
hi guys,
can anybody tell me how to extract resources from p6 to excel. I want all detailed report of total number of resources. i.e carpenter, mason, steel fixer etc for the whole project. please tel me how can I get this in monthwise format.
thanks in advance. waiting for answers.
Hi,
Can you please tell me that how can i calculate Baseline in excel sheet? what are the steps or formula?
I have an excel sheet that have baseline, then catch-up, then Actual Progress so i am making new sheet so want to know how can i calculate BASELINE?
Kindly share at [email protected]
Thanks,
Hi Mohamed,
it is a pity that you don't use Spider Project.
In Spider Project these teams are called multiresources and assigning multiresource you assign all multiresource members.
More than that - at any moment you can change resources in the multiresource and all futire assignments will be automatically updated.
Let's wait what practical advise will be given by P6 gurus.
Hi Mohammed,
why don't you simply create 5 teams and use the "Notes" tab in the Resource Details to indicate that Team1 is staffed with mike,robert,samual,alex,dan?
If you really need to individualize resources, give a try to Global Change:
"if resource name is Team1, then resource name is Mike AND Robert AND Samuel..."
Alexandre