Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

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.

Slippage Calculation using Total Float

5 replies [Last post]
Mon, 2007-10-22 00:54
Jeff Limpin
User offline. Last seen 11 years 48 weeks ago. Offline
Joined: 24 Sep 2007
Posts: 6
Groups: None
Guys,

In P3 3.1 is that possible to calculate the current total minus the target total float and put the answer in the column. The reason I’m using this option because if I use the varaiance target finish only give me the change of duration comparison not the slippage impact of the project.

Regards,
jeff
Top

Replies

Tue, 2007-10-30 13:32
#1
Ashok Kamath
User offline. Last seen 15 years 46 weeks ago. Offline
Joined: 30 Oct 2007
Posts: 5
Groups: None
Can you not establish your Target Project in the Project Overview dialog box (Targets tab)and have a column in your graphical view that shows Variance Target - Early Finish

Have your Baseline schedule as the first Target Variance column to compare with current.

This should show you a running tally for slippage.
Top
Mon, 2007-10-29 00:01
#2
Ashraf Jahangeer
User offline. Last seen 8 years 6 weeks ago. Offline
Joined: 8 May 2007
Posts: 144
Groups: Petro-Chem / Oil & Gas
Hi There,

The question is how to copy?

Global change is not possible.

Regards,

Ashraf
Top
Sun, 2007-10-28 18:11
#3
Scott Sando
User offline. Last seen 16 years 19 weeks ago. Offline
Joined: 7 Oct 2007
Posts: 24
Groups: None
How about:

Copy the target float figures into a custom field, then create a second custom field subtracting current float from the figure in the first custom field?
Top
Sat, 2007-10-27 20:50
#4
Larry Rino
User offline. Last seen 50 weeks 3 days ago. Offline
Joined: 25 Oct 2007
Posts: 64
Groups: Petro-Chem / Oil & Gas
Is it really necessary to show the difference (current total float minus the target total float) in P3, if not I suggest to export your P3 data in Ms Excel and put formula in the difference column (present it in Ms Excel).

I hope these helps.
Top
Tue, 2007-10-23 09:55
#5
Ashraf Jahangeer
User offline. Last seen 8 years 6 weeks ago. Offline
Joined: 8 May 2007
Posts: 144
Groups: Petro-Chem / Oil & Gas
I broke my head over it but could not do it through global change.

There is a more crude method of exporting the Target Float and Current Float and importing the difference in a Cutom data column.


Regards,

Ashraf
Top