ms project , planned % column , is there one ?

B

Buffalo

pls advise if ms project has a planned % column, % actual progress is logged,
but to compare against.
The planned period is devined so should be able to be tracked, but no option
i can find in new columns??

Pls assist
 
J

Jim Aksel

This seems to be a common question, the answer can be devined in two ways.

First: Project/Project Information and set the correct Status Date.

1. Use the Schedule Performance Index (SPI) which assumes a properly costed,
resource loaded schedule. An on schdeule condition is SPI=1. Less than 1.0
you are behind schedule, over 1 and you are ahead. SPI is a meaure of the
value of the $ value of work you really did perform divided by the $ value of
the amount of work you planned to perform.

If you are not resouce loaded, enter a single resource "Workeer1" at a cost
of $1/hr and load him against all non-summary tasks. That will allow you to
make the calculations.

2. Insert the Status column. It will tell you if a task is on schedule,
late, complete, or a future task.

OR

There is a brute force method which is rather simple. Copy your actual %
Complete to a spare column such as Text1. Then, update your entire project
as if everyone were on schedule: Tools/Tracking/Update Project. Update the
entire project. You can now compare %Complete to Text1. Remember to put
everything back when you are done .... copy Text1 back to %Complete.

The formal method is (1) from above.
--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project
 
J

Jim Aksel

I forgot one thing (it's 5:30AM here, I need coffee). .... Remember to save a
baseline.
--
If this post was helpful, please consider rating it.

Jim

Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top