Results 1 to 10 of 10

Thread: How to make a visual report on a s curve

  1. #1
    Join Date
    Jan 2012
    Location
    South Africa
    Posts
    5

    How to make a visual report on a s curve

    is there a way that I can make a visual report on a s curve that shows current progress vs baseline progress per day

  2. #2
    Join Date
    Dec 2006
    Posts
    489

    Re: How to make a visual report on a s curve

    Try the earned value over time report. Change the usage data to day.

    I hope this helps.

    Julie

  3. #3
    Join Date
    Jan 2012
    Location
    South Africa
    Posts
    5

    Re: How to make a visual report on a s curve

    Thank you for that but I cant seem to get what I'm looking for
    I need to show on a per day graft on what persentige the work should of been on each day and on what persentige it is should of been that every body can see the whole project thus far. have we been running behind where have we lost hours and so forth or is there some other way of showing that. I hope I've explaind it correctly.

  4. #4
    Join Date
    Dec 2006
    Posts
    489

    Re: How to make a visual report on a s curve

    I'm afraid earned value is the only way to get what I think you are asking for. You can show Baseline work and actual work per day -- but not percentages.

    In order for earned value to work you must have resources with standard cost rates assigned to tasks, a baseline saved, an accurate status date, and accurate tracking.

    For a simpler Baseline vs actual work -- you'll need resources assigned (costs not necessary) plus a baseline.

    Do you have any or all of the above?
    What version of Project are you using?

  5. #5
    Join Date
    Jan 2012
    Location
    South Africa
    Posts
    5

    Re: How to make a visual report on a s curve

    I'm using MS Projects 2010
    I have resources on some tasks and have a baseline saved I update the schedule on a daily basis unfortunately we have no costs connected to our schedules

  6. #6
    Join Date
    Dec 2006
    Posts
    489

    Re: How to make a visual report on a s curve

    Without costs, earned value data will not calculate, and with resource only on some tasks, comparing Baseline work to Work won't do either.

    The best I can suggest is to compare Baseline Start, Baseline Finish, Baseline Duration against Actual Start, Actual Finish, and Actual Duration.

    Through some custom fields, you should be able to calculate things like Duration Variance percentage by comparing Duration Variance against Duration.

    But I'm afraid there isn't anything that is built in given what you have for data.

  7. #7
    Join Date
    Jan 2012
    Location
    South Africa
    Posts
    5

    Re: How to make a visual report on a s curve

    Thank u for that feed back I found a formula that gives me the % that it should have been on on current date so now I just go and manualy put that values in excell from a day to day basis
    thanks again

  8. #8
    Join Date
    Dec 2006
    Posts
    489

    Re: How to make a visual report on a s curve

    You're welcome.

  9. #9
    Join Date
    Jan 2012
    Location
    South Africa
    Posts
    5

    Re: How to make a visual report on a s curve

    I've gone thru some of the other threads and realized that I don't know anything I've completed the advanced training on MS projects 2010 but did not help with the stuff that I read here
    is there some EBook that I can download that is the complete manual or something that can teach me more on this program

  10. #10
    Join Date
    Dec 2006
    Posts
    489

    Re: How to make a visual report on a s curve

    Sorry, I don't know of any free resources. The MSExperts books are quite good but I believe they are only in print version -- I don't think they have e-books.

Similar Threads

  1. Visual Report - Budget cost report without baseline cost
    By clauz in forum Microsoft Project
    Replies: 4
    Last Post: 04-02-2012, 02:09 AM
  2. How to make stock taking report sheet in Excel
    By hanni ball in forum MS Office Support
    Replies: 2
    Last Post: 03-02-2012, 07:20 PM
  3. 2010 visual report not working with excel 2010
    By skier9er in forum Microsoft Project
    Replies: 5
    Last Post: 27-03-2011, 06:41 AM
  4. Replies: 5
    Last Post: 02-02-2010, 02:16 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,713,868,829.96971 seconds with 17 queries