I have been asked to create a spreadsheet for work for 12 staff who have 11 tasks. Some staff may be better at performing 50 simple tasks rather than 2 or 3 more difficult ones, i would like to build a system considers that, for example peter done 50 task a's and becky done 3 task b's and these both equate to a full days work; they equalled each other. I cant "unit cost" these tasks directly,no knowledge of role so i want to know how i can assign a tariff /unit value from data i collect.
PS. o'level maths only
I.Q around 130-140