O
Ofc. Williams
Im trying to create a shift Schedule that seperates officers into there
working shifts by criteria of Seniorty and Rank.
There are 5 shifts... Days
6am-2pm, 7am-3pm), Afternoons(2-10,4-12),
Mids11-7)
Officer places a bid of the 5 shifts they wish to work to the least
wanted....
Example: Ofc. Example
Choice#1 2pm-10pm, Choice#2, 7am-3pm, Choice#3 4pm-12am .... and so on
Senoirty is based off of Date of Hire, and if Officers have the same Date of
hire, then the officers are ranked... 1, 2, 3
*Not all Officers are ranked*
Im trying to make a database where you place officers name, Date of Hire,
Rank (if applicable) and then choices
compile up the date and place into the 5 shifts and have about roughly 30
Officers for each shift....
Once the spots are filled, then choice two comes into play... and once the
next shift spots are filled...then choice 3 comes into play....
Im kind of at a loss where to start, and this is something I been trying to
work at instead of doing it all by hand... if anyone can help, I would be
grateful...
Thanks..
Officer begging for an afternoon spot
working shifts by criteria of Seniorty and Rank.
There are 5 shifts... Days
6am-2pm, 7am-3pm), Afternoons(2-10,4-12),Mids
11-7)Officer places a bid of the 5 shifts they wish to work to the least
wanted....
Example: Ofc. Example
Choice#1 2pm-10pm, Choice#2, 7am-3pm, Choice#3 4pm-12am .... and so on
Senoirty is based off of Date of Hire, and if Officers have the same Date of
hire, then the officers are ranked... 1, 2, 3
*Not all Officers are ranked*
Im trying to make a database where you place officers name, Date of Hire,
Rank (if applicable) and then choices
compile up the date and place into the 5 shifts and have about roughly 30
Officers for each shift....
Once the spots are filled, then choice two comes into play... and once the
next shift spots are filled...then choice 3 comes into play....
Im kind of at a loss where to start, and this is something I been trying to
work at instead of doing it all by hand... if anyone can help, I would be
grateful...
Thanks..
Officer begging for an afternoon spot