Skip to content
ProjectControls.com
Microsoft Project

Free float as duration automatically

In the Open Standard
Martin MMember for 11 years 6 months
Created
5
6
0

Hi,

I am new to Microsoft Project, but has much experience with Safran Project. Is it possible to get MS Project automatically set free float of a activity as the activity's duration? 

Ex. on follow-on activities.

I also miss the "planned progress" coloumn, but according to google that is impossible without using formulas which hardly works. Or is it a solution without using formulas?

Thank you in advance.

Regards

Save Follow Follow forum Report
Reply New topic

5 replies

Oldest first
  1. 0
    Evgeny Z. ·
    #1

    Martin,I assume, that under

    Martin,

    I assume, that under " set free float of a activity as the activity's duration" you mean to extend activitie's duration in such a way, that its free float would be 0.

    There is no standard way to do it, you would have to write Visual Basic script for it.

    But I wonder, why would you need it?

    Regards.

    Evgeny 

    Report
  2. 0
    Rafael Davila ·
    #2

    If you give them more time

    If you give them more time they will use it pretending to be busy as there is no hurry, it is the opposite of targeting a tight schedule in the hope you will make it, it is contrary to common sense.  

    It can be done using formulas, a user defined field to store remaining duration before the tweaking, then add current free float to remaining durations using formulas, recalculate and present the schedule with no free float, before updating restore schedule remaining durations to value before the tweaking, make the update, get new free float values and continue the cycle of deception. 

    Does Safran Project recommends such a deception strategy?

    Report
  3. 0
    Martin M ·
    #3

    Thank you for the answers,No

    Thank you for the answers,

    No I only want to use it on follow on activities, which will run from and to dates given by other parameters. This means that I have to change duration on the follow on activities when the other parameters changes, for example an installation date. I want it to have free float zero and not on critical path.

    Report
  4. 0
    Evgeny Z. ·
    #4

    Sub

    Sub ExtendTasksDurationToEliminateFreeSlack()

     

    Dim tsk As Task

    Dim amntTasksExtended As Integer

     

    amntTasksExtended = 0

     

     

    For Each tsk In ActiveProject.Tasks

     

    If tsk.FreeSlack > 0 Then

     

    tsk.Duration = tsk.Duration + tsk.FreeSlack

     

    amntTasksExtended = amntTasksExtended + 1

     

    End If

     

     

    Next tsk

     

    MsgBox (amntTasksExtended & " tasks have been extended to eliminate free slack")

     

     

    End Sub
    Report
  5. 0
    Evgeny Z. ·
    #5

    Martin, this is how VBA could

    Martin, this is how VBA could look like (see next post)

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?