Hi Guys
Just a Quick One am having trouble with the rating of percentage for performance of Task Time Weekly i was able to get all time and average
so the idea is to rate the percentage if the time is High the percentage should be low and if time is Low Percentage should be High
Column C 6 Time 20.49 Percentage should be low 25
Column D 6 Time 13:14 Percentage should be Mid 50%
Column E 6 Time 10:06 Percentage should be High 70%
Above is the sample of what and i want the rating of percentage
Appreciate with a solution
Just a Quick One am having trouble with the rating of percentage for performance of Task Time Weekly i was able to get all time and average
so the idea is to rate the percentage if the time is High the percentage should be low and if time is Low Percentage should be High
Column C 6 Time 20.49 Percentage should be low 25
Column D 6 Time 13:14 Percentage should be Mid 50%
Column E 6 Time 10:06 Percentage should be High 70%
Above is the sample of what and i want the rating of percentage
Appreciate with a solution
ILSP operational Vessel Activity Performance 2021.xlsx | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
5 | Average Exceeded Hours Offload / Load ( Time in Days) | 0.71 | 0.77 | 0.84 | ||
6 | Actual Weekly Hours ( Time In Days ) | 20.49 | 13.14 | 10.06 | ||
7 | Weekly Performace rating to port operation | 46.9% | 30.1% | 23.0% | ||
8 | Average Hours Completing Offload/ Load Meet Target | 0.36 | 0.41 | 0.41 | ||
9 | Actual Weekly Hours ( Time In Days ) Meet Target | 4.35 | 7.34 | 6.58 | ||
10 | Weekly Performace rating to port operation | |||||
Sheet1 |