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.
* Coder needs to be opened to at least 3 small changes by Buyer until project is fully completed/satisfied.
14 pekerja bebas membida secara purata $81 untuk pekerjaan ini
This can easily be done in vb6 as front end and msaccess as [url removed, login to view] reports can be generated in [url removed, login to view] completion of project demo version with all the functionality will be given to you. You can test it and su Lagi