This is maybe boiling down to the way MS Project can produce data against the way another planning tool such as PowerProject. I must also consider my knowledge(or lack off) using MS Project, not used it in anger for a long time, have been using PowerProject.
The abreviations are
O/D - original duration
R/D - remaining duration
A/D - actual duration
e/s - early start
e/f - early finish
a/c - actual cost
r/c - remaining cost
If it cant be done using custom fields and formula then it cant be done. Will just have to hand ball it
Many thanks your replies, its good to get thoughts from others when drawings complete blank !
Cheers
Member for
19 years 11 months
Member for19 years11 months
Submitted by Trevor Rabey on Thu, 2009-05-14 05:19
Before even thinking about the problem, or rather the more exotic and demanding version of the problem, the short answer is that maybe it is possible and maybe it isnt. Maybe it is easy and maybe it is hard.
But what is the point of spending time and effort trying to do something which is mainly cosmetic, and largely based on a whim, and adds not one $ of value, when the time and effort could be much better spent doing something which is more important and productive?
The Gantt Chart is primarily about Tasks, and all of the fields are Task fields. You could tag the Tasks manually as PM or Design and then group and sub-total on that, and then think about tagging with a formula
I can figure out what some of the abbreviations are, but can you tell me anyway, just to be sure.
Member for
24 years 2 months
Member for24 years2 months
Submitted by Mal Leadbetter on Thu, 2009-05-14 04:11
On face value, it would appear MSP needs to produce 2 reports to do this, hence asking if via the use of custom fields and formula it was not possible to extract the cost information from the task for each reasource into the custom cost fields.
Member for
19 years 11 months
Member for19 years11 months
Submitted by Trevor Rabey on Wed, 2009-05-13 21:37
Actual Cost and Remaining Cost (of Resources) are Resource fields so the Actual Cost and Remaining Cost data is available for each Resource so the problem is only about extracting the data and arranging it.
If you "tag" each Resource with the department they are in by using a spare resource field, that is a text field, or the built-in Group field will do, then you will be able to sort, filter and group on that field.
fred, PM Department
bob, Design Services
carol, PM Department
ted, Design Services
alice, Design Services
Make a new Group (Project, Grouped By, More Groups etc) and group on the "tag" field.
Then in the Resource Sheet View, show the Cost Table, then run the Group that you just made
How about slightly re-phrasing the question so that we are asking to see:
Actual Cost For Tasks with PM Group resources assigned.
Remaining Cost for Tasks with PM Group resources assigned.
In the Gantt Chart View, and showing the Cost Table, Group by Resource Name.
This is not one of the built-in Groups so you will have to make one (Project, Group By, More Groups)
Member for
24 years 2 monthsRE: Custom Fields
Trevor
Totally agree with your first 2 paragraphs.
This is maybe boiling down to the way MS Project can produce data against the way another planning tool such as PowerProject. I must also consider my knowledge(or lack off) using MS Project, not used it in anger for a long time, have been using PowerProject.
The abreviations are
O/D - original duration
R/D - remaining duration
A/D - actual duration
e/s - early start
e/f - early finish
a/c - actual cost
r/c - remaining cost
If it cant be done using custom fields and formula then it cant be done. Will just have to hand ball it
Many thanks your replies, its good to get thoughts from others when drawings complete blank !
Cheers
Member for
19 years 11 monthsRE: Custom Fields
Before even thinking about the problem, or rather the more exotic and demanding version of the problem, the short answer is that maybe it is possible and maybe it isnt. Maybe it is easy and maybe it is hard.
But what is the point of spending time and effort trying to do something which is mainly cosmetic, and largely based on a whim, and adds not one $ of value, when the time and effort could be much better spent doing something which is more important and productive?
The Gantt Chart is primarily about Tasks, and all of the fields are Task fields. You could tag the Tasks manually as PM or Design and then group and sub-total on that, and then think about tagging with a formula
I can figure out what some of the abbreviations are, but can you tell me anyway, just to be sure.
Member for
24 years 2 monthsRE: Custom Fields
Trevor
Thanks for the reply. A possible solution that I will need to put forward.
Basically the client had seen some example reports done in PowerProject. One of which showed the gantt chart and the spreadsheet side detailing
ID, Name, O/D, E/S, A/D, R/D, E/F, E/F Variance, A/C PM Services, R/C PM Services, A/C Design Services, R/C Design Services.
On face value, it would appear MSP needs to produce 2 reports to do this, hence asking if via the use of custom fields and formula it was not possible to extract the cost information from the task for each reasource into the custom cost fields.
Member for
19 years 11 monthsRE: Custom Fields
Actual Cost and Remaining Cost (of Resources) are Resource fields so the Actual Cost and Remaining Cost data is available for each Resource so the problem is only about extracting the data and arranging it.
If you "tag" each Resource with the department they are in by using a spare resource field, that is a text field, or the built-in Group field will do, then you will be able to sort, filter and group on that field.
fred, PM Department
bob, Design Services
carol, PM Department
ted, Design Services
alice, Design Services
Make a new Group (Project, Grouped By, More Groups etc) and group on the "tag" field.
Then in the Resource Sheet View, show the Cost Table, then run the Group that you just made
How about slightly re-phrasing the question so that we are asking to see:
Actual Cost For Tasks with PM Group resources assigned.
Remaining Cost for Tasks with PM Group resources assigned.
In the Gantt Chart View, and showing the Cost Table, Group by Resource Name.
This is not one of the built-in Groups so you will have to make one (Project, Group By, More Groups)