Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determine accuracy percentage between two dates
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determine accuracy percentage between two dates
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Determine accuracy percentage between two dates
On Apr 5, 4:35*pm, GS 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
determine formula for percentage | Excel Worksheet Functions | |||
Show forecast accuracy of customer schedules as a percentage | Excel Worksheet Functions | |||
Calculating forecast accuracy as a percentage | Excel Discussion (Misc queries) | |||
Determine years betwen 2 dates | Excel Worksheet Functions | |||
determine percentage of growth | Excel Discussion (Misc queries) |