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.

Average Float figure for the project

5 replies [Last post]
Wed, 2007-12-19 19:58
Kevin Matthews
User offline. Last seen 14 years 30 weeks ago. Offline
Joined: 21 Jun 2006
Posts: 57
Groups: Petro-Chem / Oil & Gas
G’day,

We need the average activity float for the project as we can then track this figure on a weekly basis and show slippage etc..

I have had a quick look for any report that gives me this figure but couldn’t see anything.

I am probably going to export the activities and float for each activity to an excel spreadsheet and then work it out from there (I’m assuming I can do this?)

Is there a quicker and easeir way using P5 ?

Keep Planning (and Happy Christmas)

Kevin.
Top

Replies

Wed, 2008-01-09 02:38
#1
Kevin Matthews
User offline. Last seen 14 years 30 weeks ago. Offline
Joined: 21 Jun 2006
Posts: 57
Groups: Petro-Chem / Oil & Gas
Thanks David, I’ll try your method.

Keep Planning,

Kevin.
Top
Fri, 2007-12-21 06:08
#2
David Kelly
User offline. Last seen 2 years 2 weeks ago. Offline
Joined: 19 Oct 2004
Posts: 630
Groups: Petro-Chem / Oil & Gas
Once upon a time, back in the days of manual forward/backward pass when ships were built on the River Clyde, the "Float Trend" chart was a big document.

We kept track of the change of float each week on some activities. All activities would have been nice, but computers were precious commodities in those days and not freely avaialble for imagineering.

If you copied the Total and or Free float to a user defined field after each progress run you have a value for float that rolls up, an indication of each activity’s change AND "Group and Sort" would also give you interesting sub-totals
Top
Thu, 2007-12-20 18:34
#3
Kevin Matthews
User offline. Last seen 14 years 30 weeks ago. Offline
Joined: 21 Jun 2006
Posts: 57
Groups: Petro-Chem / Oil & Gas
All,

Average float to me means adding up the total float for all activties and then dividing by the no. of activities. This is then calculated on a weekly basis and inthe weekly project report this number is used as one of many indicators on the project progress. As the average float number decreases this would show the project is becoming more critical (the norm!) ; if the average float figure increases (never seen this!) this will show that progress is good and probably ahead of schedule.

Keep Planning,

Kevin.
Top
Thu, 2007-12-20 14:40
#4
Wai Chan
User offline. Last seen 13 years 12 weeks ago. Offline
Joined: 20 Dec 2007
Posts: 4
Groups: Civil Engineering
I am a new member and just trying to help, maybe this is not the right answer. But I would suggest doing a filter with a range of the float that you want. you probably have to figure out the average float yourself.
Top
Thu, 2007-12-20 13:19
#5
Johny Kesserwany
User offline. Last seen 7 years 30 weeks ago. Offline
Joined: 18 Sep 2007
Posts: 118
Groups: Civil Engineering
what do you mean by ’average activity float’?

JK
Top