Disclaimer: This is a very very difficult question about mathematics and algorithms (in my opinion) – so respect to anyone who makes this. I admire you.
I would like to evaluate the performance of my employees. I would like to do this by measuring the following parameters as percentages of the amount of time they spend working:
1. % of Time spent working 2. % of Time spent in meetings 3. % of Time spent travelling
I have a “preferred” set of percentages for each of these. This represents the ideal time that I would LIKE my employees to spend their time.
% Time spent in Meetings -> 30% % Time spent Travelling -> 10% % Time Spent Working -> 60% total time spent on activities: 100%
So in words, I would like my employees to spend 30% of their time in meetings, 10% time travelling and 60% on a desk working.
I would ALSO like to add weights to these different percentages. The weight would represent how “lenient” I am with each percentage being different to what I desire. In other words, how important I find it for each variable to be closest to the desired percentages (30, 10, 60). I would like to apply the weights on a scale of.1 to 10, 10 being most important, 1 being least important.
Meetings -> 3 Travelling -> 9 Working -> 5
So given the percentage of time spent by an employee, and the weight of the importance of the time spent being close to the desired time spent, I would like to generate an index between 0 and 100 where 100 is the perfect time percentages and 0 is the worst. So a score of 100 would give the “preferred” percentages:
% Time spent in Meetings -> 30% % Time spent Travelling -> 10% % Time Spent Working -> 60%
How I would try to approach this:
I think you’re trying something which is kinda like the H-score. H-score is a scored we use in digital pathology to measure tumor positivity for a maker and it is meant to weight the number of positive cells by their intensity. It’s:
1* (% of positive cells with score 1) + 2*(% of positive cells with score 2) + 3*(% of positive cells with score 3)
You could calculate the same as:
3*(1-% of difference between actual worked hourse and planned ones) 9*(1-% of difference between actual worked hourse and planned ones) 5*(1-% of difference between actual worked hourse and planned ones)
Don’t forget to use absolute value when you compute the difference. I used 1-% so that a difference of 0.8 (as planned 0.ì and worked 0.9) will result in a score of 0.2. This will work for the opposite situation too (planned 0.9 and worked 0.1). In this way, who perfectly matches the planned hourse will have a score of 1700%. Then just:
Score/Total weights = score between 0-100%.