Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
Please find the below sample data. This is a daily work report (DWR) for employees from different departments. I have taken 11 days sample data from 01/21/2020 to 31/01/2020. This is really important to fill DWR on daily basis however few employee don't fill it timely and missed days.
First wanted to get the percentage of compliant and non compliant employees whether they are filling the DWR on daily basis or not.
Second there is a required hours column which has 8.5 and 8 hours depending on departments along with that there is a another column of worked hours, so on the basis on that I want to calculate the men hours utilization.
Please advise...
Employee_Name | Date | Department | Required Hours | Hours Given |
Henry | 01/21/2020 | HR | 8 | 8 |
Catherine | 01/23/2020 | R&D | 8.5 | 7 |
Karen | 01/24/2020 | Sales | 8.5 | 8 |
William | 01/23/2020 | R&D | 8.5 | 8 |
Mathew | 01/21/2020 | Sales | 8.5 | 7 |
Catherine | 01/25/2020 | R&D | 8.5 | 7 |
William | 01/26/2020 | R&D | 8.5 | 8 |
Mathew | 01/22/2020 | Sales | 8.5 | 8 |
Karen | 01/25/2020 | Sales | 8.5 | 9 |
William | 01/28/2020 | R&D | 8.5 | 7 |
Catherine | 01/27/2020 | R&D | 8.5 | 7 |
Henry | 01/27/2020 | HR | 8 | 8 |
William | 01/30/2020 | R&D | 8.5 | 9 |
Mathew | 01/23/2020 | Sales | 8.5 | 7 |
Henry | 01/25/2020 | HR | 8 | 7 |
Catherine | 01/28/2020 | R&D | 8.5 | 7 |
Mathew | 01/24/2020 | Sales | 8.5 | 8 |
Catherine | 01/29/2020 | R&D | 8.5 | 8 |
Henry | 01/31/2020 | HR | 8 | 8 |
Catherine | 01/30/2020 | R&D | 8.5 | 7 |
Mathew | 01/25/2020 | Sales | 8.5 | 7 |
Karen | 01/29/2020 | Sales | 8.5 | 9 |
Karen | 01/27/2020 | Sales | 8.5 | 7 |
Karen | 01/31/2020 | Sales | 8.5 | 9 |
Mathew | 01/26/2020 | Sales | 8.5 | 7 |
Mathew | 01/27/2020 | Sales | 8.5 | 9 |
Mathew | 01/28/2020 | Sales | 8.5 | 9 |
Mathew | 01/29/2020 | Sales | 8.5 | 9 |
Mathew | 01/30/2020 | Sales | 8.5 | 9 |
Mathew | 01/31/2020 | Sales | 8.5 | 9 |
Can anyone please help on this?