Advance curve by physical length in Project 2010 RRS feed

  • Question

  • I know that is not the correct way to measure progress but would like to help me in a better applicability in the subject.

    I elaborated on the timeline, without resources, set the duration for their activities;

    Gave 100% increase of the activities and saved to baseline.

    I did an export tool for data analysis (cumulative% completed) and saved the Excel data.

    Zero all advances, determined a status date;

    Display the control table and updated all the activities to date status and repeat the export process to confront the values ​​on a graph.

    The issues are:

    how to generate values ​​close to the percentage (100%) from the date of status?

    How to generate a trend line?

    And if not too much to ask, send me a more efficient procedure for this case. It could be through formulas, VBA ...

    I hope that was clear.

    Thank you.

    Hezequias Vasconcelos

    Friday, April 27, 2012 11:23 AM


  • Hello all.

    I found an option in Project 2010 that solves my problem.

    Let the steps:

    1 - With the click Open Project 2010 Project - Reports - Visual Reports.

    2 - Select All - Earned Value Over Time Report.

    3 - Click on View.

    Example of the configuration screen:

    4 - Results obtained.

    Hope this helps others

    Hezequias Vasconcelos

    Friday, April 27, 2012 8:25 PM