Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Colorado, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Projected completion dates (10.0.2002.0502)

    I need to get the projected completion dates for a collection of tasks. In other words, The Remaining Duration column shows the number of days left to complete the task based on the percent complete and the task duration. What I want to know is what the completion date would be if the balance of the task work were to be started on the current day. This is to determine how late an unfinished task is.

    It seemed like the finish variance should have given me the number of days late, but it only seems to work for tasks that have already been completed. For those that are still open, it shows the variance as 0.

    Any help would be greatly appreciated.

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Projected completion dates (10.0.2002.0502)

    Have you set a baseline?
    From the help files:
    <font color=blue>
    How Calculated The Finish Variance field contains "0 days" until the finish date varies from the baseline finish date. Microsoft Office Project then calculates finish variance as follows:

    Finish Variance = Finish - Baseline Finish</font color=blue>
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    4 Star Lounger
    Join Date
    Sep 2004
    Location
    Sacramento, California, USA
    Posts
    432
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Projected completion dates (10.0.2002.0502)

    If you want to move all uncompleted work to be rescheduled to start from the current date forward then go to Tools, Tracking, Update Project and reschedule all uncompleted work to start after the current date. Remember that when you type a date manually into Project it will interpret that to be close of business on that date. If you want the start of business on the current date you would enter ex. 8/22/06 8:00 AM.
    Finish Varience does not look at Actual Finish it looks a the Finish date in the current project so if a task has an actual start and does not yet have an actual finish if the finish of the task has slipped from the baseline date that amount would show in Finish Variance.

    Carla

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •