personnel performance scorecard

Gave it a try with a pivot.
Cannot say I'm convinced yet.
It's an awful lot of work making a datasheet fit for use with a pivot table. See sheet "Data".
I think that format will not make data entry any easier.
Created a pivot table on sheet "Pivot" showing the result so far.

Then again, like I mentioned before, pivot tables are not my cup-of-tea, so probably I haven't discovered all the features yet or (also likely) I'm using a wrong approach.
See what you find of it.