Nursing Employee Monthly / Daily Schedule

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. Triggers 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! Schedule 4 on 2 off Special rule - Custom defined schedule Cart # 1-4 (Assignments) Treatment Desk etc. (See key in file attached) Attendance Trending Call offs Vacation Sickr Switch Shifts... Nurses 6:30 am - 3:00 pm 2:30 am - 11:00 pm 10:30 pm - 7:00 am CNA's...