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.
Spider Project is most functional and powerful professional project management software.
The first SP version was launched in 1993 and since then it has been constantly improved. Today is used in 34 countries though most Spider Project customers are in Russia. Spider Project offers numerous unique functional features and is the only PM software that optimizes resource, cost, and material constrained schedules and budgets for projects and portfolios.
The unique features of Spider Project include Quantity Based Scheduling, Conditional Scheduling, Skill Scheduling, Optimal Resource, Cost and Material Leveling, Resource Critical Path Calculation, Cash and Material Flows Calculation and Management, Trend Analysis, Advanced Risk Simulation and Analysis, Calculation of Success Probability Trends, Calculation and Management of required Project Time and Cost Buffers, Application of Corporate Norms, Management of many Parallel Budgets, Multiple WBS and many others.
Spider Project was and is used for management of many large scale programs in Russia, including $51bln construction program for 2014 Winter Olympic Games preparation.
The application areas where Spider Project is successfully used include Aerospace, Banking, Construction, Defense, Energy, Engineering, Infrastructure, Manufacturing, Metallurgy, Mining, Oil & Gas, Railways, Retail, Shipbuilding, Software Development, Telecommunications, Utilities, etc.
P6-Auditor - Display information from Primavera P6 audit tables in a user-friendly format
Unifier-Archiver - Extract and archive important documents and attachments from Primavera Unifier
Unifier-Loader - Load data into and out of Unifier via Excel
PCM-Loader - Import data into Primavera Contract Management with flexible and secure, template-driven Excel spreadsheets
PCM-Archiver - Extract and archive important documents and attachments from Primavera Contract Management
PCM-Unifier Migrator - Automatically transfer live and historical data from Primavera Contract Management to Primavera Unifier with ease
Create Radically Better Construction Schedules with ALICE Technologies
Use the power of AI to create construction schedules that reduce risk while cutting costs and build time. With ALICE, develop the ideal schedule during preconstruction -- or recover projects that are off schedule and over budget.
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
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
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.
[email protected]
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
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
[Disrespectful (and non-helpful) answer deleted by Moderator.]
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
You would only need to do the Global Calc once.
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
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
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
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
Are u refer to P3 or P3e,
Please clarify
Cheers
Alex