In that case you I assumed that you are looking on resource assignment module. Click assignment icon or Select Project-> Resource Assignment. On this module you can use the same group & sort/ filter like tracking and activities module.
If you are looking for daily assignment level select View-> Select Usage Spreadsheet on your project menu. On the left panel right click and select group & sorted by-> Resources. That will group resources and activities. You can always go back to customise the group & sort option same as filter. On the spreadsheet display, you can show budgets, actual, remaining etc... by cumulative or by time interval. Right click then select Spreadsheet Fields-> Customized… then all the field you wanted to show.
If you don’t want spreadsheet option, just uncheck under View menu. To display budget, actual and remaining right click and select columns-> Units or customise to select all the fields that you wanted to show.
I have tried to sort by resource, or resource IDs or even resources but still cannot get what I am after.
If you have multi-resources assigned to a task when you group/sort by resource it only shows tasks with no resource allocation.
When you group/sort by resources or resources IDs it summarises to the different combination of allocations. This is not what I was after.
For example if I have fitters, cranes, tooling etc as resources I want ot be able to sort so I can only see the values for fitters only. Can this be done in P5?
Thanks,
Matt
Member for
19 years
Member for19 years
Submitted by Rodel Marasigan on Tue, 2007-05-08 19:25
Yes you can do the same as Suretrak. Actually P3e is more advance and more facilities to suit your requirements. I suggest that you use the activity module instead of tracking module. From there you can organise your activities by resources or any group & sort/ filter that you requires as long as the data is available. You can draw and show the profile, resource assignment/ usage by clicking the icons on the top that correspond to your needs. You can show the column like earn value, budget and actual etc… for comparison and analysis. Familiarise your self on the icons and their usage and you will able to get the result that you wanted. If you really need my assistance please explain in more detail of what you want to achieve so I can point you to a right direction.
Have managed to get the profile working thanks for the help!
Have another question regarding the group and sort/filter functions. In suretrak it is possible to organise by resource and then filter by activities that contain the resource which gives you budgeted and earned value data for just that resource.
I have tried to do a similar thing in P3e but can only filter by activity which contain the resources however the data given contains all resources asigned in the tasks. Is there a way of getting the same result from P3e that we currently get from Suretrak?
Thanks,
Matt
Member for
19 years
Member for19 years
Submitted by Rodel Marasigan on Tue, 2007-05-08 08:10
If you’re not familiar with group & sort or filter, the simpliest way is to highlight all the resources by selecting first resource and press shift key and click the last resources. If you need assistance on group & sort or filter please let me know so I can guide you.
Regards,
Rodel
Member for
18 years 6 months
Member for18 years6 months
Submitted by Oliver Melling on Tue, 2007-05-08 07:40
If you add an activity code to the activities that you want to know resource info for, then filter by that activity code, I think the resource usage profile will only show resource usage associated with the filtered activities.
Member for
19 years 1 monthRE: Resource Profile
hello
as a very new user of P6( ok just install it this morning), i cant find my way with the new interface my question is:
- how to make a resource usage profile filtered by cost account?( like in P3)
- how to make a spread sheet of resource usage, filtered by cost account
friendly
Member for
19 yearsRE: Resource Profile
Matt,
Unfortunately not, you can display earned value column in activity module or area only.
Rodel
Member for
18 years 8 monthsRE: Resource Profile
Rodel,
Thanks for the advice seems to work really well.
However is there a way to display Earned Value Units in the Resource Assignments Area?
Thanks,
Matt
Member for
19 yearsRE: Resource Profile
Matt,
In that case you I assumed that you are looking on resource assignment module. Click assignment icon or Select Project-> Resource Assignment. On this module you can use the same group & sort/ filter like tracking and activities module.
If you are looking for daily assignment level select View-> Select Usage Spreadsheet on your project menu. On the left panel right click and select group & sorted by-> Resources. That will group resources and activities. You can always go back to customise the group & sort option same as filter. On the spreadsheet display, you can show budgets, actual, remaining etc... by cumulative or by time interval. Right click then select Spreadsheet Fields-> Customized… then all the field you wanted to show.
If you don’t want spreadsheet option, just uncheck under View menu. To display budget, actual and remaining right click and select columns-> Units or customise to select all the fields that you wanted to show.
Hope this meet your requirements.
Regards,
Rodel
Member for
18 years 8 monthsRE: Resource Profile
Hi Rodel,
Thanks for the reply.
I have tried to sort by resource, or resource IDs or even resources but still cannot get what I am after.
If you have multi-resources assigned to a task when you group/sort by resource it only shows tasks with no resource allocation.
When you group/sort by resources or resources IDs it summarises to the different combination of allocations. This is not what I was after.
For example if I have fitters, cranes, tooling etc as resources I want ot be able to sort so I can only see the values for fitters only. Can this be done in P5?
Thanks,
Matt
Member for
19 yearsRE: Resource Profile
Hi Matt,
Yes you can do the same as Suretrak. Actually P3e is more advance and more facilities to suit your requirements. I suggest that you use the activity module instead of tracking module. From there you can organise your activities by resources or any group & sort/ filter that you requires as long as the data is available. You can draw and show the profile, resource assignment/ usage by clicking the icons on the top that correspond to your needs. You can show the column like earn value, budget and actual etc… for comparison and analysis. Familiarise your self on the icons and their usage and you will able to get the result that you wanted. If you really need my assistance please explain in more detail of what you want to achieve so I can point you to a right direction.
Regards,
Rodel
Member for
18 years 8 monthsRE: Resource Profile
Hi Rodel,
Have managed to get the profile working thanks for the help!
Have another question regarding the group and sort/filter functions. In suretrak it is possible to organise by resource and then filter by activities that contain the resource which gives you budgeted and earned value data for just that resource.
I have tried to do a similar thing in P3e but can only filter by activity which contain the resources however the data given contains all resources asigned in the tasks. Is there a way of getting the same result from P3e that we currently get from Suretrak?
Thanks,
Matt
Member for
19 yearsRE: Resource Profile
Matt,
Try this thread. I have some step by step guidance on how to organize resource using group & sort.
http://www.planningplanet.com/forum/forum_post.asp?fid=1&Cat=8&Top=32336
If you think that doesn’t help you, let me know what you are trying to achieve so I can assist you.
Rodel
Member for
18 years 8 monthsRE: Resource Profile
Thanks both for the replies.
Oliver funnily enough I was just trying the Activity Code method when your reply came through. Unfortunately this didnt seem to work either!
Rodel if you dont mind guiding me through the Group and Sort option if you think this is where I need assistance I would greatly appreciate it!
Regards,
Matt
Member for
19 yearsRE: Resource Profile
Hi Matt,
If you’re not familiar with group & sort or filter, the simpliest way is to highlight all the resources by selecting first resource and press shift key and click the last resources. If you need assistance on group & sort or filter please let me know so I can guide you.
Regards,
Rodel
Member for
18 years 6 monthsRE: Resource Profile
Hi,
If you add an activity code to the activities that you want to know resource info for, then filter by that activity code, I think the resource usage profile will only show resource usage associated with the filtered activities.
Hope this helps.