Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Location
    Colorado
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Variances Converted to Percentages (Project 2000)

    Help!

    My boss has a strange request. He wants to be able to view variances in percentage format. This is related to his desire to see the % of work complete in comparison to the % of work that should be complete according to the baseline. Anyone have any ideas how this might be achieved? I've been wrestling with this for weeks and I seem to be pinned!

    GEE

    <img src=/S/surrender.gif border=0 alt=surrender width=31 height=23>

  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: Variances Converted to Percentages (Project 2000)

    Have you tried the Tracking Gantt view after setting your project baseline?

    If so, was there a particular view that your boss wants - ie does he want numbers or a chart style view?

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    New Lounger
    Join Date
    Apr 2002
    Location
    Colorado
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Variances Converted to Percentages (Project 2000)

    Ah yes, I forgot to mention, my boss doesn't like the Gantt charts. He ignores them completely. I tried to show him the Tracking Gantt and the use of the Progress Line, etc. But he just wants a Variance percentage to show up on the table, since he only looks at the table. I think he's being a bit difficult personally. But, hey, I'm not the boss...

    <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

    Gee

  4. #4
    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: Variances Converted to Percentages (Project 2000)

    Well, I'd move into Task Usage view and apply the Variance table.
    Then I'd add the % Complete column to the view.

    I think I'd need more information to calculate the %complete of baseline or at any rate the formula keeps slipping away from me today (I'll blame it on the time change!)

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  5. #5
    New Lounger
    Join Date
    Apr 2002
    Location
    Colorado
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Variances Converted to Percentages (Project 2000)

    I tried your suggestion and still don't have what my boss wants! I really appreciate your trying to help out, by the way. I have written so many formulas I've lost track of them and still cannot get the percentage I need. Rather than seeing the variances displayed as + or - hours, my boss wants it to display as a percentage of time ahead or behind. Perhaps if I could come up with a formula that shows the percentage of work that should be complete by a given time so he could compare it to the percentage of work actually complete. He wants numbers to benchmark progress or late of. What a pain! Anyway, thanks again. I'm still working at it...

    <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

    GEE

  6. #6
    Star Lounger
    Join Date
    Nov 2001
    Location
    Houston, Texas
    Posts
    66
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Variances Converted to Percentages (Project 2000)

    Did you ever figure out how to do this? I need to do the same thing and would appreciate any help.

    Thanks,
    Caroline

  7. #7
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Variances Converted to Percentages (Project 2000)

    Have you tried looking at the % Complete, and % Work Complete fields. I am not sure if this is what you want but may work. If you provide a little more information we may be able to solve this for you.
    Regards,

    Gary
    (It's been a while!)

  8. #8
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Variances Converted to Percentages (Project 2000)

    Please clarify the following. Whey you say % Work complete do you want to include resources hours worked or are you only looking at Task Durations and excluding the work complete by resources?

    You may also look at <post#=222105>post 222105</post#> for some ideas
    Regards,

    Gary
    (It's been a while!)

  9. #9
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Variances Converted to Percentages (Project 2000)

    See <post#=222245>post 222245</post#> for a reference to a macro that does this.
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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