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:
<tbody>
</tbody>
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:
DAYS TOOK TO COMPLETE | PRODUCTIVITY % |
15 | LOWEST % SCORE |
14 | |
13 | |
12 | |
11 | |
10 | 100% SINCE 10 DAYS IS THE GOAL |
9 | |
8 | |
7 | |
6 | |
5 | |
4 | |
3 | |
2 | |
1 | HIGHEST % SCORE |
<tbody>
</tbody>