I'm trying to track a metric regarding meeting our artifact delivery
committments and need assistance in calculating the percentage between
two dates.

For example, if the Target column date was 03/31/11 and the Complete
column date 03/31/11, then the Metric column would read as "1.00". If
the Complete column was any date sooner than the Target date, the
Metric would be higher than "1.00"; for a Complete date later than the
Target date, such as 04/06/2011, then the Metric would be under than
"1.00"

Target = K4 (mm/dd/yy)
Complete = L4 (mm/dd/yy)
Metric = M4 (0.00%)

My metric targets may assist in articulating my request:
Marginal : metric less than .90
Review : metric between .90 - .93
Effective : metric between .94 - .97
Good : metric between .98 and 1.00
Outstanding : 1.00 plus 10% of commitments delivered ahead of
schedule

Annabelle explained on 4/5/2011 :
> I'm trying to track a metric regarding meeting our artifact delivery
> committments and need assistance in calculating the percentage between
> two dates.
>
> For example, if the Target column date was 03/31/11 and the Complete
> column date 03/31/11, then the Metric column would read as "1.00". If
> the Complete column was any date sooner than the Target date, the
> Metric would be higher than "1.00"; for a Complete date later than the
> Target date, such as 04/06/2011, then the Metric would be under than
> "1.00"
>
> Target = K4 (mm/dd/yy)
> Complete = L4 (mm/dd/yy)
> Metric = M4 (0.00%)
>
> My metric targets may assist in articulating my request:
> Marginal : metric less than .90
> Review : metric between .90 - .93
> Effective : metric between .94 - .97
> Good : metric between .98 and 1.00
> Outstanding : 1.00 plus 10% of commitments delivered ahead of
> schedule

The math is simple: 'Target/Complete'. According to your logic, a
target date of 3/31/11 with a complete date of 5/31/13 scores 'Good'
(returns 0.980881). Don't you think completing a project 26 months
behind target is a bit rediculous? I think you want to re-examine how
your grade scale works. Maybe use the number of days and prorate that
to a predefined table such as would be used for student grades.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

On Apr 5, 4:35*pm, GS <g...@somewhere.net> wrote:
> Annabelle explained on 4/5/2011 :
>
>
>
>
>
> > I'm trying to track a metric regarding meeting our artifact delivery
> > committments and need assistance in calculating the percentage between
> > two dates.
>
> > For example, if the Target column date was 03/31/11 and the Complete
> > column date 03/31/11, then the Metric column would read as "1.00". If
> > the Complete column was any date sooner than the Target date, the
> > Metric would be higher than "1.00"; for a Complete date later than the
> > Target date, such as 04/06/2011, then the Metric would be under than
> > "1.00"
>
> > Target = K4 (mm/dd/yy)
> > Complete = L4 (mm/dd/yy)
> > Metric = M4 (0.00%)
>
> > My metric targets may assist in articulating my request:
> > * * * Marginal : metric less than .90
> > * * * Review : metric between .90 - .93
> > * * * Effective : metric between .94 - .97
> > * * * Good : metric between .98 and 1.00
> > * * * Outstanding : 1.00 plus 10% of commitments delivered ahead of
> > schedule
>
> The math is simple: 'Target/Complete'. According to your logic, a
> target date of 3/31/11 with a complete date of 5/31/13 scores 'Good'
> (returns 0.980881). Don't you think completing a project 26 months
> behind target is a bit rediculous? I think you want to re-examine how
> your grade scale works. Maybe use the number of days and prorate that
> to a predefined table such as would be used for student grades.
>
> --
> Garry
>
> Free usenet access athttp://www.eternal-september.org
> ClassicVB Users Regroup! comp.lang.basic.visual.misc- Hide quoted text -
>
> - Show quoted text -

Then my ask is wrong. I'll review my approach to get to the accurate
percentage I'm after. Thanks for your help.