Create employee wise Effort Utilisation Report

Assume a “Labour utilisation” report which shows day wise tasks performed by different employees (row labels are task names, column labels are days and data in the matrix shows employee names).  Each employee can perform multiple tasks on the same day and same task on multiple days.

Given a list of all employees, one may want to answer the following questions:

1. Days worked for each employee – If an employee performs multiple tasks on the same day, then that shall be counted as only 1 day of work

2. Tasks performed across all days – If an employee performs the same task across multiple days, that that shall be counted as only 1 task across all days

You may refer to my solution in this workbook.

You may refer to a similar problem at the following link – “Analysing customer walkin data by date and service taken”