Website Upgrade Incoming - we're working on a new look (and speed!) standby while we finalise 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.

Weighting factors incorporation

7 replies [Last post]
Mon, 2002-11-11 02:00
Nishikant Choudhary
User offline. Last seen 20 years 31 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 25
Groups: None
Could anybody please explain to me the method of incoporation of weighting factors into P3 programme .
add to it , if i also need to display planned quantities upto say 31DEC02 to be displayed in my schedule.
i have tried doing it with CDI,GLobal Change but nothing seems to work.
The weight factors i presumed were derived from cost and quantities at each section of work and each phase of the work scheduled.

Could anyone help me in this context as i have been trying this for quite some time and running short of time.

Thanks in Advance.
Nishikant
Top

Replies

Mon, 2002-11-18 07:32
#1
Forum Guest
User offline. Last seen 14 weeks 5 days ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
Thanks George !Thats the kind of thing that i was looking for to assess the actual progress .

anyway i would be more than happy to work with your files in the way u explained to me.


Thanks

U can mail me at N.Choudhary@LNGHazira.com
Top
Mon, 2002-11-18 06:55
#2
George Hislop
User offline. Last seen 21 years 49 weeks ago. Offline
Joined: 7 Nov 2002
Posts: 9
Groups: None
Nishikant,

I have applied weighting factors in the past using Excel. You need to export the resource and code data in WKS format then open in Excel. Add a new sheet where you cteate a vertical list of the code values which are to used for setting WFs. Next to each value you add the WF to apply.
The Excel VLOOKUP function can then be used to calculate a new budget quantity for each resource. This can then be copied and the VALUE pasted over the original BQ. Finally import the data file back into P3.
Note - it is a good idea to keep a copy of your original export in case you want to reinstate the original values.
I can email you a sample file if you wish.
I hope this helps.
Top
Fri, 2002-11-15 05:58
#3
Nishikant Choudhary
User offline. Last seen 20 years 31 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 25
Groups: None
Thanks George for your CLue on the Quantities at Cut-off Dates .
I checked the Tabular reports- Productivity and Found an Inbuilt report.


Again May i ask you to fill me in on the Issue of weighting factors and Quantities.
Your Understanding of what i want is correct .I will much appreciate if you can reply me on those lines.

Thanks in Advance George.
Top
Thu, 2002-11-14 03:37
#4
George Hislop
User offline. Last seen 21 years 49 weeks ago. Offline
Joined: 7 Nov 2002
Posts: 9
Groups: None
Nishikant,
I am not clear on exactly what you are trying to do. I assume you are trying to assign resources and quantities then use the code fields to determine which weighting factor to apply. If this is correct let me know and I can advise further.
On the subject of estimated planned quantities at cut off dates, why not use the Tabular Resource Loading report built into P3. If you get the result you require you can then export it to a CSV file (use the Format tab on the report modification screen) which is easily read into Excel for analysis / graphic reports. Hope this helps...
Top
Wed, 2002-11-13 06:16
#5
Nishikant Choudhary
User offline. Last seen 20 years 31 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 25
Groups: None
Thanks , The Project Team,


Could you be more specific in the incorporation of the weighted values in the schedule.

I am very weak in CDI and GlobaL Change.
So,please,could you inform about this in more detail.

I also need information on the calculation of Estimated planned quantities that can be at any cut off date within the planned period.
like if i have to put a cut off date say 31dec02 as a milestone and need to know how much work i have to perform till 31dec02.

can you please explain me this , cos i tried filters and global change but that cannot work.

Please advise me you all specialists.

Thanks and Best regards.


Nishikant
Top
Tue, 2002-11-12 23:18
#6
Forum Guest
User offline. Last seen 14 weeks 5 days ago. Offline
Joined: 28 Jan 2009
Posts: 2
Groups: None
Hi there Nishikant,

I have mailed around the guys here, and this is our preferred / most common way of weighting a programme.

Im sure there is a better method - but nonetheless, this is our simple way !!

We create an activity resource called "weight" (good name!?!) and using the global change facility, assign it a value. This is most often done by copying over the activity duration. Then we go in in and manually edit some of the entries where the duration is not directly proportional to the effort required.

Other weighings are the man-hour resource.

By using a simple resource in this way, you can get "weighted" progress curves etc that reflect the work done as a reflection of the percentage complete.

Does this brief description assist you at all - or have we missed the point ??

Keep on Planning !
Top
Tue, 2002-11-12 22:05
#7
Nishikant Choudhary
User offline. Last seen 20 years 31 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 25
Groups: None
Probably the weightages are given baseed on product of the cost and quantity to get uniformity and then getting the actual weightages.

But my predicament is as o how i should allocate these into P3 . I am waiting for an answer from you all specialists since the past 3 days and could find none .
i must say i did try importing the data to excel and exporting the same oto P3 , but to no avail.

can anybody please help me.

Thanks in advance .

Nishikant

Top