Need to add some back end functionality to simply staffing procedures. I've attached current schedule.
Need to be able to select employee from drop down it should auto populate title etc.
Need to auto populate the names and titles in the daily schedule.
Formulas are currently not functional
Also need to integrate a budget worksheet to help staffer ensure compliance with budgets.
Form is pretty much designed just need to format it and improve it.
Work Week = Sunday - Saturday (11:00pm cutoff) ... should be able to change this parameter
5+ days in a work week should display alert ... Overtime!
8+ hours in a day...should display alert ... Overtime!
4 on 2 off
Special rule - Custom defined schedule
Cart # 1-4 (Assignments)
etc. (See key in file attached)
6:30 am - 3:00 pm
2:30 am - 11:00 pm
10:30 pm - 7:00 am