RE: From % Complete to EVM

Tech-Archive recommends: Speed Up your PC by fixing your registry

I see the light bulb came on for you :)
Copy the %Complete/Start/Finish dates to spare columns Text1, Start1,
Finish1. Now you have something to remind you what the dates should be. If
you want, also store duration in a spare field, perhaps Duration1.

Clear the %Complete column, clear your baseline.
Add a resource with a $1/hr rate and assign that as appropriate so you can
set your work the way you need it.

You have to decide how to handle Actual Costs, to me, it is far better if
you do it rather than let Project calculate it. This can complicate things.
We have separate tasks as cost collectors only. We feed them Actual Cost
from the accounting/time keeping system. There is no way to break it down to
discrete tasks if you do it that way (manually), I tell you that so you go
into this "eyes open"

Once you have the schedule and work the way you want it, baseline. Just be
careful that your schedule logic remains good and you haven't created
artificial date constraints as you do this. Then set your status date and
plug in your progress. Next time you want to take status, remember to set a
new status date first. You can take your %Complete by copying from the spare
column you used to memorialize %Complete. Just watch the dates.

We use the Physical%Complete method and not the %Complete method. I am
writing a long rant about that to put on my blog but it is not done yet. I
do have a paper available to help you convert. It was written for 2003, but
the same rules apply... except at the very end you can use the Visual Report
in 2007. If you poke around on my blog enough, you can find my e-mail. I'd
be happy to send you the paper tonight (Los Angeles time).

In your instance, since you have one resource and it costs $1/hr this is the
same as using %Work Complete.
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com



"Rob" wrote:

Hi,

Project 2007 pro - No server yet though.

After much effort to do calculated fields to measure expected/planned %
complete to actual % complete I have realized how lame the idea is overall,
and my results have been less than par with summary tasks never working out
just right. I want to move into EVM reporting with a Gantt chart and S Curve.

My project has had three reporting cycles already. I crafted these nifty
TPS reports (Time Project *** - I like humor) for tracking task start, work
complete during cycle(1 week), est. remain work, and task finish that
everyone completes once a week for all of their tasks.

Here are the steps I think I need.

1. Enter costs for everyone. - I am going to use the $1 earned
schedule/effort idea.
2. Delete all progress. - Is there a known copy/paste method for removing
and adding work over time?
3. New Baseline.
4. Re-Apply progress. - Again... shortcut to this?

Let me know if these steps get me to where I can do the Gantt chart and S
Curve as if I had been doing EVM all along.

Thank you for all of your help ahead of time.
.

Quantcast