Firstly apologises if I have broken any forum rules. I need to setup an employee tracking system on Excel and was just wondering if someone has done this before? We are looking to monitor our employees due to the current climate with the Corona Virus.
I can work around Excel I just need a starting point, we have around 400 employees over four departments and six type of job descriptions. I already know how many employees we need to run the service but we need to monitor
• Sickness
• Holidays
• Corona Virus
For instant if we 50 employees to run the service or section, we can allow 20% before we need to act that’s 10 employees, theses 10 could be made up of sickness, Holidays or Corona. We may also need to use people from the other departments.
A front dashboard who show an overall view.
Has someone come across a monitoring / tracking system with a front dashboard before?
Thank you in anticipation