View Full Version : Creating employee schedules using preferences
dvenn
11-01-2007, 02:55 PM
I am looking for a way to generate employee schedule for a month based on schedule preferences.
here is what I have
ID | Sun | Mon | Tues | Wed | Thu | Fri | Sat
12 8am 8am 8am 8am 8am
14 9am 9am 9am 9am 9am
so lets say I want to schedule these two for the November..
I want a macro that will schedule them accordingly by date based on the day of week preference.
so the output would look like this..
11/1/07 12 8am
11/1/07 14 9am
11/2/07 12 8am
11/2/07 14 9am
11/4/07 14 9am
etc
etc
any help would be appreciated.
Bob Phillips
11-01-2007, 03:17 PM
where do the dates come from, and what happened to the 3rd?
dvenn
11-01-2007, 03:20 PM
the third would be a Saturday which neither employee has a preference for..
The dates could be listed somewhere or determined by the routine (since all dates would need to be evaluated)
Does that make sense?
Bob Phillips
11-01-2007, 03:48 PM
Surely, if the 3rd is a Sat, 2nd is a Fri, and nobody opted for that either.
But I still don't see where the start date is preseneted.
dvenn
11-01-2007, 04:25 PM
the formatting was lost a bit..
12 works M, T, W, Th, F at 8am
14 works Su, M, T, Th, F 9am
which is why they both worked on 11/2, neither worked 11/3, and 14 works on 11/4
currently the date is not presented anywhere (as I did not know the best way to do that portion)....
I can list the dates in a cloumn then have a macro look at the date, determine the day of week for the date... then determine if employee has a pref to work on that day of the week..
but then I didn't know of excel and/or VBA was smart enough to just run 11/1/07 as a date then incrementally add one til end of month...
So to cause confusion wiht this request.. but honestly I don't know the best way to produce the results.. I know the end product and the preferences :(
Bob Phillips
11-01-2007, 04:57 PM
I basically get it, bur I fail to see how the first Sun can be 4/11 and the Fri following can be 2/11.
You have to have logical data or you can't even start.
dvenn
11-01-2007, 05:01 PM
the dow week for 11/4/2007 (m/d/yy) is sun.. 11/2/07 is fri
Sorry I need to remember where people are when posting dates like that..
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.