In P3e you can open the project and in the project view you can display a column call Total man hrs - OTM and then run a global change in your activity view and store the OTM in a user defined field (CDI) that way not excel import or export at all
Dear Ravi, thanks for your prompt reply...Unfortunately, what I am looking for, is different than what you are thinking of. May be I just did not explain well what I need. You know, sometimes its different to communicate by correspondences and make everyone understands exactly what you need...
Anyway, what I am looking for is to link P3 on a temporary database which can be excel or access, get the required information on OTM from these softwares and use them in P3 to calculate WF.
I read interesting papers on this subject done by Paul E. Harris from Eastwood Harris. Hope that he read this thread and can offer me his help in this matter.
Since you have loaded manhrs as Resources same way you have to create the resources as Weight factor & budget quantity equal to manhrs of that activity divided by to tal manhrs .you can do this by Global change or export/emport function.
No need of Excle Sheet.
Still if you have problem. Send Prx File I will do for You.
Sorry Ravi, but as I explained, I dont want to read or use excel, graphical report or other.Im simply asking if there is a value like OTM where I can store it in P3e and use it to calculate WF or other, without reading it or showing on the screen or calculating it manually...
It is preferable to do the calculation one time but I dont think its possible. Think about the possibility of having these teams custom data itemized as follows:
TEAM1 for Concept Design having a total overall Mhrs of OTM1
TEAM2 for Draft Design with OTM2
TEAM3 for Draft Final Design with OTM3
TEAM4 for Final Design with OTM4
and consider having for each Design Department diffrent working teams,
If we want to have WF for each team in each department then for each team in all departments, think about the long process to do that in GC and in manually input each OTM...
Thats why I am asking about an easy way to do that...
In fact, I dont want to input mechanically the figure of OTM but I am hoping that there is a way in storing this value and use it. Think about the possibility of having "x" activity custom datas, in that case we need to do GC for each of the "x"?!
Thank you for your assistance...I am eager to have another suggestion...
If you dont want to use Excel, you would need to type the actual value for OTM in the GC equation. As you said, you can get this value from the screen. Use numeric custom item for WF and use the equations you specified WF=BQ/OTMs actual value and WF=100 * WF. If OTM changes, you need to change OTM value in your equation and rerun the global change. Perhaps someone has another way to do this, but this should work for you.
Dear Bill, OTM and WF are both values as OTM is the overall total manhours in the Project and WF is the weight factor of each activity (in %), so they have both same levels. Also, I dont want to make a separate calculation on excel or other or else I could simply see the OTM on the screen and identify its value then make the calculation of WF.
I dont see a way to do this calculation through global change, since WF is assignment level and OTM is activity level.
You could create resource assignment report grouped by activity ID, save as ASCII comma delimited, and then open in Excel to do your weighting calculations there.
RE: Weight Factor
Hi
In P3e you can open the project and in the project view you can display a column call Total man hrs - OTM and then run a global change in your activity view and store the OTM in a user defined field (CDI) that way not excel import or export at all
I am not sure is that what you are looking for?
Hope it helps,
Alex
RE: Weight Factor
Dear Ravi, thanks for your prompt reply...Unfortunately, what I am looking for, is different than what you are thinking of. May be I just did not explain well what I need. You know, sometimes its different to communicate by correspondences and make everyone understands exactly what you need...
Anyway, what I am looking for is to link P3 on a temporary database which can be excel or access, get the required information on OTM from these softwares and use them in P3 to calculate WF.
I read interesting papers on this subject done by Paul E. Harris from Eastwood Harris. Hope that he read this thread and can offer me his help in this matter.
Thanks and Regards,
J.S. Daniel
RE: Weight Factor
Mr Danial
No need of showing on Screen
Since you have loaded manhrs as Resources same way you have to create the resources as Weight factor & budget quantity equal to manhrs of that activity divided by to tal manhrs .you can do this by Global change or export/emport function.
No need of Excle Sheet.
Still if you have problem. Send Prx File I will do for You.
ravi@anes.ae
RE: Weight Factor
Sorry Ravi, but as I explained, I dont want to read or use excel, graphical report or other.Im simply asking if there is a value like OTM where I can store it in P3e and use it to calculate WF or other, without reading it or showing on the screen or calculating it manually...
Thank you for your cooperation...
Regards,
J. S. Daniel
RE: Weight Factor
In order to load the % weight factor you can do the following.
1)Create the resources as wt Factors
2) Assign to all activity with Global change
3) Assign the budget Quantity = Manhr/Total Manhrs*100%
4) Total of this Resources will be 100%.
5)By using the GraphiicalReports you can see the % (S curve)
Hope you understand.
Ravi
RE: Weight Factor
[Disrespectful (and non-helpful) answer deleted by Moderator.]
RE: Weight Factor
Steven,
It is preferable to do the calculation one time but I dont think its possible. Think about the possibility of having these teams custom data itemized as follows:
TEAM1 for Concept Design having a total overall Mhrs of OTM1
TEAM2 for Draft Design with OTM2
TEAM3 for Draft Final Design with OTM3
TEAM4 for Final Design with OTM4
and consider having for each Design Department diffrent working teams,
If we want to have WF for each team in each department then for each team in all departments, think about the long process to do that in GC and in manually input each OTM...
Thats why I am asking about an easy way to do that...
Regards,
J. Daniel
RE: Weight Factor
You would only need to do the Global Calc once.
RE: Weight Factor
Bill,
In fact, I dont want to input mechanically the figure of OTM but I am hoping that there is a way in storing this value and use it. Think about the possibility of having "x" activity custom datas, in that case we need to do GC for each of the "x"?!
Thank you for your assistance...I am eager to have another suggestion...
Regards,
J.S. Daniel
RE: Weight Factor
J.S.
If you dont want to use Excel, you would need to type the actual value for OTM in the GC equation. As you said, you can get this value from the screen. Use numeric custom item for WF and use the equations you specified WF=BQ/OTMs actual value and WF=100 * WF. If OTM changes, you need to change OTM value in your equation and rerun the global change. Perhaps someone has another way to do this, but this should work for you.
Regards,
Bill
RE: Weight Factor
Dear Alex, it is on P3e
Dear Bill, OTM and WF are both values as OTM is the overall total manhours in the Project and WF is the weight factor of each activity (in %), so they have both same levels. Also, I dont want to make a separate calculation on excel or other or else I could simply see the OTM on the screen and identify its value then make the calculation of WF.
Thanks for your immediate assistance...
Best Regards,
J. Daniel
RE: Weight Factor
J. Daniel,
I dont see a way to do this calculation through global change, since WF is assignment level and OTM is activity level.
You could create resource assignment report grouped by activity ID, save as ASCII comma delimited, and then open in Excel to do your weighting calculations there.
Regards,
Bill
RE: Weight Factor
Are u refer to P3 or P3e,
Please clarify
Cheers
Alex