Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Wt. Factor in P3??

4 replies [Last post]
Tue, 2006-12-12 09:16
Ronaldo Quilao
User offline. Last seen 10 years 17 weeks ago. Offline
Joined: 11 Aug 2003
Posts: 34
Groups: GPC Qatar
Hello Fellow,

Here I do have (shall I say problem) on how to reflect the weight factor of each activity in my programme in P3. I did created a column named Wt. Factor but experienced difficulties on how to set - up the calculation automatically. (Budget MH per activity divided by Total MH times 100)

Is there anybody experience this? May I know the key on how to do it. Well we can actually do this in excel format but its the client required so I am trying to manipulate my programme but to no avail.

Thanks.

Ronald
Top

Replies

Thu, 2007-03-22 06:09
#1
Amit Jog
User offline. Last seen 5 years 2 days ago. Offline
Joined: 28 Sep 2004
Posts: 7
Groups: None
Hello Mr. Ronald Quilao,
Well you can do one thing for weightage factor Follow this method.

Suppose you have resource loaded programme and you know the budgeted quantity of the resource manhours.

If you want to do it automatically, Insert a new resource Manhours and insert the total manhours for the activity.

Once you get total manhours. remove the rest of the resources from the programme and just keep MHRS as the resource. Of make a copy of the resource loaded programme.
This will create a new schedule with only resource manhours. U can set it up as target to the complete resource loaded programme and then update it automatically of actuals to get the spended value against the expected value.
You can summarize the programme using summarization rule of resource units.

Regards,

Amit
Top
Thu, 2006-12-14 06:30
#2
Ronaldo Quilao
User offline. Last seen 10 years 17 weeks ago. Offline
Joined: 11 Aug 2003
Posts: 34
Groups: GPC Qatar
Thank you guys!

Actually I already did those...in excel format...that was easy...but the client don’t want that method either.

I did tried also the Global Change but to no avail...maybe because the system has a difficulty in analysing or calculating my detailed entries (Multiple or rather complete (discipline) manpower)

Thanks once again.

Ronald
Top
Tue, 2006-12-12 19:25
#3
Alex Wong
User offline. Last seen 12 years 13 weeks ago. Offline
Joined: 12 Feb 2003
Posts: 874
Groups: TILOS
Ronald

What you need is a CDI to calculate your Weighted Man hr

However the system will not able to roll up to the format of your Layout grouping.

so what I normally do is export to excel and then calculate and display the weighting summary with the format I like

HTH

Alex
Top
Tue, 2006-12-12 10:05
#4
Ronald Winter
User offline. Last seen 4 years 15 weeks ago. Offline
Joined: 4 Jan 2003
Posts: 928
Groups: None
I believe that you could define a Global Change to do that. Then just execute that GC after calculating the CPM.
Top