Create a "Custom" Field

How can I create a custom field that will show the "Projected % Complete"
based on the current status date. I want to be able to compare the actual %
complete with where it should be. I would also like to be able to show in a
custom field the "current complete through date" for a task. This would be
very useful in understanding a Late Task. This will be a visual aid for my
customers that greatly speeds our project reviews. Your help will be greatly
appreciated.

I'm looking for a way to show where a
% complete should be on the status date. If the task is late, and shows 33%
complete, but on the status date it should be 41% complete I want to be able
to show that as well as the "Complete Through Date" this will give a visual
reference. Hypothetically - a task is 33% complete with a complete through
date od 12/30/05, but on 1/10/06 the status date, it should have been 41%
complete. I want to show in 2 separate columns 41% and 12/30/05.

John
Wed Jan 11 10:23:36 CST 2006

In article <798C849D-1587-49A2-8EAC-84775EC7EB50@microsoft.com>,
"(Charles Ray) cray@spiritconstruction.co"
<CharlesRaycrayspiritconstructionco@discussions.microsoft.com> wrote:

> How can I create a custom field that will show the "Projected % Complete"
> based on the current status date. I want to be able to compare the actual %
> complete with where it should be. I would also like to be able to show in a
> custom field the "current complete through date" for a task. This would be
> very useful in understanding a Late Task. This will be a visual aid for my
> customers that greatly speeds our project reviews. Your help will be greatly
> appreciated.
>
> I'm looking for a way to show where a
> % complete should be on the status date. If the task is late, and shows 33%
> complete, but on the status date it should be 41% complete I want to be able
> to show that as well as the "Complete Through Date" this will give a visual
> reference. Hypothetically - a task is 33% complete with a complete through
> date od 12/30/05, but on 1/10/06 the status date, it should have been 41%
> complete. I want to show in 2 separate columns 41% and 12/30/05.

Charles,
In your original post on the developer newsgroup I suggested you
consider using standard classical earned value metrics. You never
indicated why that approach would not work.

It is possible to pretty much generate any custom data desired either
through formulas in custom fields or if that doesn't work, definitely
with VBA. In the case of what you want, I can envision a formula in a
custom field that calculates the "projected % complete" value. The
formula might look something like:
Proj % Comp = ProjDateDiff([start],[status date])/[duration] x 100%

It's not real clear what you mean by, "complete through date". If I
assume that is the equivalent date for the "normal" progress based on
the entered % complete value, then a similar formula (using ProjDateAdd)
to generate a date based on the % complete be used.

John
Project MVP

CharlesRaycrayspiritconstructionco
Sun Jan 15 17:35:11 CST 2006

John,

Thanks so much for your help. I have been out of town on business and just
noticed your reply.

Thanks again,

Charles

"John" wrote:

> In article <798C849D-1587-49A2-8EAC-84775EC7EB50@microsoft.com>,
> "(Charles Ray) cray@spiritconstruction.co"
> <CharlesRaycrayspiritconstructionco@discussions.microsoft.com> wrote:
>
> > How can I create a custom field that will show the "Projected % Complete"
> > based on the current status date. I want to be able to compare the actual %
> > complete with where it should be. I would also like to be able to show in a
> > custom field the "current complete through date" for a task. This would be
> > very useful in understanding a Late Task. This will be a visual aid for my
> > customers that greatly speeds our project reviews. Your help will be greatly
> > appreciated.
> >
> > I'm looking for a way to show where a
> > % complete should be on the status date. If the task is late, and shows 33%
> > complete, but on the status date it should be 41% complete I want to be able
> > to show that as well as the "Complete Through Date" this will give a visual
> > reference. Hypothetically - a task is 33% complete with a complete through
> > date od 12/30/05, but on 1/10/06 the status date, it should have been 41%
> > complete. I want to show in 2 separate columns 41% and 12/30/05.
>
> Charles,
> In your original post on the developer newsgroup I suggested you
> consider using standard classical earned value metrics. You never
> indicated why that approach would not work.
>
> It is possible to pretty much generate any custom data desired either
> through formulas in custom fields or if that doesn't work, definitely
> with VBA. In the case of what you want, I can envision a formula in a
> custom field that calculates the "projected % complete" value. The
> formula might look something like:
> Proj % Comp = ProjDateDiff([start],[status date])/[duration] x 100%
>
> It's not real clear what you mean by, "complete through date". If I
> assume that is the equivalent date for the "normal" progress based on
> the entered % complete value, then a similar formula (using ProjDateAdd)
> to generate a date based on the % complete be used.
>
> John
> Project MVP
>

John
Mon Jan 16 10:56:32 CST 2006

In article <D6A11EA1-54BE-4369-B488-346DCCA4B6D3@microsoft.com>,
"(Charles Ray) cray@spiritconstruction.co"
<CharlesRaycrayspiritconstructionco@discussions.microsoft.com> wrote:

> John,
>
> Thanks so much for your help. I have been out of town on business and just
> noticed your reply.
>
> Thanks again,
>
> Charles

Charles,
Yeah, I wondered what happened to you. Glad we could be of help.

John
>
> "John" wrote:
>
> > In article <798C849D-1587-49A2-8EAC-84775EC7EB50@microsoft.com>,
> > "(Charles Ray) cray@spiritconstruction.co"
> > <CharlesRaycrayspiritconstructionco@discussions.microsoft.com> wrote:
> >
> > > How can I create a custom field that will show the "Projected % Complete"
> > > based on the current status date. I want to be able to compare the
> > > actual %
> > > complete with where it should be. I would also like to be able to show
> > > in a
> > > custom field the "current complete through date" for a task. This would
> > > be
> > > very useful in understanding a Late Task. This will be a visual aid for
> > > my
> > > customers that greatly speeds our project reviews. Your help will be
> > > greatly
> > > appreciated.
> > >
> > > I'm looking for a way to show where a
> > > % complete should be on the status date. If the task is late, and shows
> > > 33%
> > > complete, but on the status date it should be 41% complete I want to be
> > > able
> > > to show that as well as the "Complete Through Date" this will give a
> > > visual
> > > reference. Hypothetically - a task is 33% complete with a complete
> > > through
> > > date od 12/30/05, but on 1/10/06 the status date, it should have been 41%
> > > complete. I want to show in 2 separate columns 41% and 12/30/05.
> >
> > Charles,
> > In your original post on the developer newsgroup I suggested you
> > consider using standard classical earned value metrics. You never
> > indicated why that approach would not work.
> >
> > It is possible to pretty much generate any custom data desired either
> > through formulas in custom fields or if that doesn't work, definitely
> > with VBA. In the case of what you want, I can envision a formula in a
> > custom field that calculates the "projected % complete" value. The
> > formula might look something like:
> > Proj % Comp = ProjDateDiff([start],[status date])/[duration] x 100%
> >
> > It's not real clear what you mean by, "complete through date". If I
> > assume that is the equivalent date for the "normal" progress based on
> > the entered % complete value, then a similar formula (using ProjDateAdd)
> > to generate a date based on the % complete be used.
> >
> > John
> > Project MVP
> >