MSP2007 makes this easier than in the past.
First, you will need to establish your scehdule with appropriate timelines,
duration, work, etc. Assign resources to the tasks. To properly generate an
"S" curve, it is important the resources be properly costed. If this is not
possible, use a generic resource such as Worker1 with a work rate of $1/hr.
Save a baseline. (Tools/Tracking/Set Baseline)
Set the status date equal to the last day of your project (this is because
Project does not generate data past the status date). To do that:
Project/Project Information.... then set the status date.
Reports/Visual Reports... select Earned Value Over Time. You need to select
a level of granularity for your data. We usually select "weeks" since we
take Earned Value weekly. Click View and the Planned Value Curve (also
known as Budgeted Cost of Work Scheduled) will appear in Excel.
It may be necessary to adjust the data display to obtain the units you wish.
In Excel, pull the tab that says "assignment usage with EV". This is the
tab that contains the raw data to support Chart1. You can "open" the data to
the level you desiire and the Chart1 will automatically adjust.
Remember to set your status date back to something more reasonable before
you start claiming any %Complete.
--
If this post was helpful, please consider rating it.
Jim
Visit
http://project.mvps.org/ for FAQs and more information
about Microsoft Project
