Calculating planned percentage Complete

I need to calaculate the planned % complete for project and tasks inside the
project.

I have cost and resources assigned to each task.

any help

John
Wed Feb 21 10:50:01 CST 2007

In article <E0242D82-97E4-4C77-97D7-2F05B9FB7FFE@microsoft.com>,
Adel <Adel@discussions.microsoft.com> wrote:

> I need to calaculate the planned % complete for project and tasks inside the
> project.
>
> I have cost and resources assigned to each task.
>
> any help

Adel,
I guess the closest thing to "planned % complete" is the earned value
metric BCWS (budgeted cost of the work scheduled). However to get that
you will need to have a baseline set and also need to provide a status
date.

By the way, unless you have fixed costs associated with a given task,
costs are not "assigned", resources are. The resource rate then
determines the cost, which is calculated by Project.

John
Project MVP

Mike
Wed Feb 21 10:50:48 CST 2007

Hi Adel,

Welcome to this Microsoft Project newsgroup :)

Project will calculate this for you when you enter Actual Work and Remaining
Work for each task.

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on :)

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials


Adel wrote:
> I need to calaculate the planned % complete for project and tasks
> inside the project.
>
> I have cost and resources assigned to each task.
>
> any help

Adel
Fri Feb 23 15:35:05 CST 2007

thank you for your reply

sorry, I may miss typed what I want !

I need to calculate the planned % complete for project ,summary tasks and
tasks in project.

I have neither cost or resources assigned to each task.


"Mike Glen" wrote:

> Hi Adel,
>
> Welcome to this Microsoft Project newsgroup :)
>
> Project will calculate this for you when you enter Actual Work and Remaining
> Work for each task.
>
> FAQs, companion products and other useful Project information can be seen at
> this web address: http://project.mvps.org/faqs.htm
>
> Hope this helps - please let us know how you get on :)
>
> Mike Glen
> MS Project MVP
> See http://tinyurl.com/2xbhc for Project Tutorials
>
>
> Adel wrote:
> > I need to calaculate the planned % complete for project and tasks
> > inside the project.
> >
> > I have cost and resources assigned to each task.
> >
> > any help
>
>
>
>

John
Sat Feb 24 09:59:17 CST 2007

In article <3131869A-23AD-45C3-A902-116B1F395FE1@microsoft.com>,
Adel <Adel@discussions.microsoft.com> wrote:

> thank you for your reply
>
> sorry, I may miss typed what I want !
>
> I need to calculate the planned % complete for project ,summary tasks and
> tasks in project.
>
> I have neither cost or resources assigned to each task.

Adel,
This may seem like a dumb question but how can you have a "planned" %
complete if there are no resources working on the tasks?

John
Project MVP
>
>
> "Mike Glen" wrote:
>
> > Hi Adel,
> >
> > Welcome to this Microsoft Project newsgroup :)
> >
> > Project will calculate this for you when you enter Actual Work and
> > Remaining
> > Work for each task.
> >
> > FAQs, companion products and other useful Project information can be seen
> > at
> > this web address: http://project.mvps.org/faqs.htm
> >
> > Hope this helps - please let us know how you get on :)
> >
> > Mike Glen
> > MS Project MVP
> > See http://tinyurl.com/2xbhc for Project Tutorials
> >
> >
> > Adel wrote:
> > > I need to calaculate the planned % complete for project and tasks
> > > inside the project.
> > >
> > > I have cost and resources assigned to each task.
> > >
> > > any help
> >
> >
> >
> >

JimP
Mon Feb 26 17:25:07 CST 2007

Adel,
First, the hints from others to look at things like baselines and the earned
value are good. My assumption is that the Percent Complete field is not
working for you and that you are looking for something simple.

The following method is not simple to set up, but it makes entering the data
very simple.

Since you are not entering costs or resource assignments, I assume you are
entering a duration (your planned value) and either a % complete or an Actual
Duration to provide the status. The summary "% Complete" field calculates
based on [Actual Duration]/[Duration]*100. When you enter the Percent
complete at the task level this rolls up. Since this number is not what you
expect or desire, I assume that your planned completion is not really based
on the actual duration but instead based on some other criteria.

If the "% Complete" is a value that does not correlate to the duration (for
example after 2 days of a 5 day task you are 73% done with the task), then
the "Physical % Complete" may be used to capture this. But unfortunately the
"Physical % Complete" field does not roll up to the summary levels. But you
can use custom fields with formulas to summarize the percent complete based
on the physical percent complete at the summary or project levels.

An example of formulas that work, but are not necessarily elegant are shown
below. The fields I used first convert the durations to numeric values, roll
these up to the summary levels and then use a formula to calculate the the
physical percent complete at the Summary and Project levels. The third field
is the only one you need to display as it contains the value I think you may
be looking for. The name I gave the field, the Project custom field used, and
the formula for each are shown below.

Number of Days (Number 1): [Duration]/480
- This converts the task duration to an integer value assuming you have a
standard 8 hour day. This value can then be rolled up using the Sum roll-up
option when defining the field.
Portion Completed (Number 2): ([Duration]*[Physical % Complete])/48000
- This uses the entered value for Physical % Complete you enter at the task
level to calculate the portion of the duration that has been completed in a
format that can be rolled up. Again the roll-up for this custom field must be
defined as Sum.
Physical Percent Complete Summary (Number 3): [Number2]/[Number1]*100
- This calculates a new percent complete that is the same as the Physical
Percent complete at the task level. Setting the roll-up for this field as
"Formula" will then give you the desired percent complete at the summary or
project level.

If you add the Physical Percent Complete and the last field we created,
Physical Percent Complete Summary, to a task view, and then enter a task
level Physical Percent complete you will see that it is summarized in a
logical way.

Hope this helps,
Jim P