Skip to content

Slip / Delay Column

Charles GibbonsMember for 22 years
Created
4
3
0

Hi there

Still learning this MS software

Is there a formula for calculating the slip/delay to tasks behind schedule?

Ive baselined and created a planned % complete and have manually marked up progress in the % complete column

is there a formula that looks at both and generates a duration?

 

Thanks Charlie

4 replies

Oldest first
  1. 0
    Charles Gibbons ·

    anyone? is it possible?

    anyone? is it possible?

  2. 0
    Rafael Davila ·

    Long time I have not used

    Long time I have not used MSP, do not even have a license but maybe this can help:

    http://www.projectlearning.net/pdf/I1.1.pdf

    http://office.microsoft.com/en-001/project-help/start-variance-fields-HP001025920.aspx

    http://www.textndata.com/forums/baseline-finish-finish-variance-206769.html

    http://pm.stackexchange.com/questions/7942/how-to-calculate-execution-variance

    Be careful with formulas and the difference between varanace calculated considering only workdays versus variance that also include non-work days.

    Good Luck

  3. 0
    Charles Gibbons ·

    Hi thanks for the reply these

    Hi thanks for the reply

     

    these links seem to deal with the varience from baseline to resheduled position

    What Im actually trying to achieve is the traditional slip column you would get in ASTA

    i.e. 10 day activity is due to complete on the report date but is only 80%

    so the 3 columns would look like

    Planned 100 (Pasted into this column from updating project and then undoing)

    Actual 80 (manually typed)

    Slip -2 days

    All without reshedulling

    Any ideas?

     

    Charlie

  4. 0
    Rafael Davila ·

    Suggest using Excel to help

    Suggest using Excel to help communicate and develop the formulas.

    Slip Formula photo Slipformula_zps2fdff6ee.jpg

    It might be you need an additional UDF and formula to calculate Planned Duration depending on the MSP available fields.

    Good Luck,

    Rafael

Log in or join to reply

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

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