Calculating Productivity Percentage

[rsharma017]

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:

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>

 

[GR00007]

Give this a try:

=IF(A2=10,1,IF(A2 < 10,(10 -(10 -A2)) / 10,((10 +A2) / (10 +MAX(A:A))) * 2))

If you want a percentage rated from low to high without 100% being on 10 days, you could try this:

=PERCENTRANK.INC(A:A,A2,2) * 2