I am trying to automate filling open overtime slots based on a couple criteria. Employees are sorted based on their current month overtime hours worked, then their previous month overtime hours worked. Employees also put in weekly requests for overtime shifts for Mid, Day, or Eve shift. The employee with the lowest hours gets their first choice, then the hours are updated. Then the new employee with the lowest hours gets their first choice, and so on. If an employee has the lowest hours worked but didn't request any overtime, then they get skipped and the next in line gets their first choice. If an employee requested overtime for a shift that doesn't need any more workers, that employee gets their second choice of shift.
The file "Employee List" shows the overtime hours list next to the overtime request list. The file "Roster" shows the overtime "OT" slots that need to be filled.
The current system uses a printed form from an Access database to show each employee's current and previous overtime hours worked. Then a google form is used to record the overtime shift requests. And a shared Excel workbook contains a sheet for each day of the week that needs to be populated with the winners of overtime requests. Any help on automating this process would be greatly appreciated.
The file "Employee List" shows the overtime hours list next to the overtime request list. The file "Roster" shows the overtime "OT" slots that need to be filled.
The current system uses a printed form from an Access database to show each employee's current and previous overtime hours worked. Then a google form is used to record the overtime shift requests. And a shared Excel workbook contains a sheet for each day of the week that needs to be populated with the winners of overtime requests. Any help on automating this process would be greatly appreciated.