Forum Discussion

Emy8820's avatar
Emy8820
Copper Contributor
Mar 08, 2020

Calculate percentage on staff’s proficiency Level

Hi, I am creating a skill matrix where staff’s proficiency level is measured from 0 to 4 (level
4 being the highest). Please can you let me know how to calculate the percentage of an individual’s proficiency as well as the whole team’s?
Thank you.

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    Emy8820 How would YOU define % proficiency? Is it that when a staff member is on level 3 that this represents 80% (being the 4th of five possible levels)?

    For the whole team you would want to calculate weighted averages. For instance, when you have 3 persons on 60% and one on 80%, the average for the team would be ((3 X 60) + (1 X 80)) / 4 = 65%

Resources