The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Making schedules? Is there an easier way? [Work]
1ddqd
Registered User regular
Registered User regular
My boss had me come up with some ideas for scheduling our 3 person department for next month... kinda short notice, but w/e.
I've been using Excel to visualize the shifts and make it easy to shift things, but it's still not easy enough. Are there any free programs I can use (besides Google Calender, don't ask...) that would make my life easier?
Goal: Getting 3 people to cover 5am-11pm with 2 consecutive days off each. Mon-Fri coverage = 5am-11pm, Sat/Sun = 5am-7pm
I've been using Excel to visualize the shifts and make it easy to shift things, but it's still not easy enough. Are there any free programs I can use (besides Google Calender, don't ask...) that would make my life easier?
Goal: Getting 3 people to cover 5am-11pm with 2 consecutive days off each. Mon-Fri coverage = 5am-11pm, Sat/Sun = 5am-7pm
1ddqd on
0
Posts
That would be an awesome idea, except that we use Lotus notes at work.
Here's the thing. We have 5am-11pm coverage - that means that for 18 hours, a day, someone has to be here. I made a schedule that would work, but we'd only get 1 day off at a time. Management said no, to make it 2 days off at a time. No problem, right? Just schedule everyone mon-fri for 5 8-hour shifts. No, wait, have to cover 5am-6pm on Saturday and Sunday, too.
The only thing I can come up with are 4 9 hour shifts and a half day on weekends.
ok, 5am to 11pm is 18 hours, 5am to 7pm is 14 hours. you have a total of 118 hours in a week. each person needs to work 39.3 hours but lets just say that 1 person works 40 hours and the other 2 work 39.
person 1: M,T,W,Th: 5am-1pm (8hr shift) Su: 5am-12pm (7hr shift). total:39
person 2: F,S: 5am-12pm (7 hr shift) W,Th: 1pm-11pm (10hr shift) T: 1pm-6pm (5hr shift). total:40
person 3: S,Su: 12pm-7pm (7hr shift) M,F: 1pm-11pm (10hr shift) T: 6pm-11pm (5hr shift). total: 39
person 1: F,S off
Person 2: Su,M off
person 3: W,Th off
thats about as neat as you can make it. tuesday is the only really weird day.