personnel performance scorecard

I suggest using a table like the enclosed that you can fill in on a regular basis whether daily, weekly or monthly and this will allow you to filter for the employee by name and date. You can also do group analysis by filtering on any of the columns to get statistics for that particular subject. I have included a TOTALS row at the bottom of the table. You can change what kind of calculation is made for each column. The totals are adjusted according to what filter has been applied. If you select one employee, the totals are for that employee.