Determine accuracy percentage between two dates

A

Annabelle

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
 
G

GS

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.
 
A

Annabelle

Annabelle explained on 4/5/2011 :









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.
 

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