I need a Microsoft Excel Monthly Staff Roster program that will randomly generate staff roster based on conditions specified below:
1) There are two group of staffs:
- Staff working on shifts (Shift Staff) - 6 staff
- Staff working office hours (Floaters) - 2 staff
2) There are 3 shifts to be allocated to Shift Staff -
1st shift: 0830 - 1700
2nd shift: 1400 - 2230
3rd shift: 2230 - 0830
Staffs who have worked the 3rd shift on a particular day are given 1 day off after which.
If a particular Shift Staff happened to be on leave/on course, any one of the available Floaters will take over.
3) Other requirements:
* There needs to be a way to indicate all existing staff (Shift & Floaters staffs).
* There needs to be a way to indicate staff working as Shift Staffs for the month
* There needs to be a way to indicate staff working as Floaters for the month.
* There needs to be a way to indicate days which staffs are on leave/on course.
* Coder needs to be opened to unlimited changes by Buyer until project is fully completed/satisfied.