27. dubna 2012 11:28I 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.
27. dubna 2012 20:22
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