Re: Percentage

anonymous_at_discussions.microsoft.com
Date: 05/08/04 

Date: Sat, 8 May 2004 03:29:34 -0700

Hello Gerard

Sorry to say but I'm still having problems!

Firstly, in the column "Should be %" milestones with zero
duration shows #ERROR, I guess due to trying to divide by
0.

Secondly, I only get a `0' in the sub-project line and not
an overall "Should be %" for the sub-project. Possibly
because I haven't interpreted your advice correctly with
respect to Tools/Organiser/Fields...?

And thirdly, the "Should be %" is calulating to 8 decimal
places and I can't figure out how to get only integers?

Can you put me on the right lines?

Regards
David

>-----Original Message-----
>Hello David,
>You can use the Earned value method, whilst you don't
manage resources load.
>In the Resource *** view, create a "Fake resource",
it's Standard rate
>would be $1/d.
>In the Gantt Chart, assign this Fake resource on every
elementary task.
>Save the Baseline : Tolls / Tracking / Save baseline / OK
>Set the Status Date to the appropriate date : Project /
Project Information
>/ Status date...
>In a table of your choice, insert a Text field : Text1
for ex. : Insert /
>Column...
>Right Click the field caption : select Customize Fields...
>Rename : "Should be %"
>Formula : ([BCWS]/[Baseline Cost])*100 & " %"
>
>NB : You have to copy this field in each of your 24 sub-
projects and in the
>Master project too.
>Tools / Organizer / Fields...
>
>Tell us if it works for you,
>
>Gérard Ducouret
>
>"David Moss" <anonymous@discussions.microsoft.com> a
écrit dans le message
>de news:083801c42531$774803d0$a301280a@phx.gbl...
>> Very recently I have inherited a project which has over
>> 2700 activities spread across 24 sub-projects. None of
the
>> activities have any resources or costs attached to them,
>> only time. I have been told that each month, by a given
>> date, I need to update the progress on each activity so
>> that I can report to the project manager the percentage
>> complete for any given activity, sub-project or the
>> project overall. This isn't a problem but in addition
I've
>> been asked to provide the percentage that should have
been
>> completed for each activity, sub-project and project
>> overall i.e. 25% complete should be 35% etc.
>>
>> Despite spending many hours trying to find out how this
>> can be done relatively easily, I haven't found a way and
>> now I'm afraid that I'm going to have to do this
manually
>> for each activity.
>>
>> If somebody could help me I would be truly grateful.
>>
>> Regards
>> David Moss
>>
>
>
>.
>

Loading