rsharma017
New Member
- Joined
- Aug 7, 2017
- Messages
- 7
I am not sure if this would be a place to seek assistance but I thought I would try.
I am assisting a team to calculate their productivity percentage (score tied to bonus).
Its a little complicated then just regular productivity. The team has 10 days to complete a task. I would like to assign a productivity percentage based on how many days it took them to complete it. For example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]DAYS TOOK TO COMPLETE
[/TD]
[TD]PRODUCTIVITY %
[/TD]
[/TR]
[TR]
[TD]15
[/TD]
[TD]LOWEST % SCORE
[/TD]
[/TR]
[TR]
[TD]14
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD] 100% SINCE 10 DAYS IS THE GOAL
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]HIGHEST % SCORE
[/TD]
[/TR]
</tbody>[/TABLE]
I am assisting a team to calculate their productivity percentage (score tied to bonus).
Its a little complicated then just regular productivity. The team has 10 days to complete a task. I would like to assign a productivity percentage based on how many days it took them to complete it. For example:
[TABLE="width: 500"]
<tbody>[TR]
[TD]DAYS TOOK TO COMPLETE
[/TD]
[TD]PRODUCTIVITY %
[/TD]
[/TR]
[TR]
[TD]15
[/TD]
[TD]LOWEST % SCORE
[/TD]
[/TR]
[TR]
[TD]14
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD] 100% SINCE 10 DAYS IS THE GOAL
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]HIGHEST % SCORE
[/TD]
[/TR]
</tbody>[/TABLE]