Customized 24/7 Shift Scheduler using Microsoft Excel
- Status: Closed
- Prize: $250
- Entries Received: 19
- Winner: nadimvicky
Contest Brief
This contest will build a customized excel spreadsheet for my operation. Once completed, it will:
-- list the days of the year horizontally, and the employees vertically.
-- arrange each employee's 48 hour work week shift in which they work 4 - 10 hour days and then 1 - 8 hour day
-- the work week starts on Sunday and ends on Saturday
-- each week each employee receives 2 consecutive days off (5 day work week)
-- there are three shifts: Night 10 pm - 8 am (or 12 am to 8 am), Morning 7am to 5 pm (or 7am to 3 pm) Afternoon 1:00 pm to 11 pm (or 1:00 pm to 9:00 pm)
-- the number of employees working each shift will depend upon the total number of employees divided by 3. For example, if there are 30 employees, each shift will have 10 people.
-- at the conclusion of each week, all three shifts rotate. All employees on the night shift move to morning shift, the morning shift employees move to afternoon shift, and the afternoon employees move to the night shift.
--one time per month, employees receive 4 consecutive days off. In other works, they will have back-to-back weeks in which they have Friday-Saturday off the first week, and then Sunday-Monday the next week--when the shifts rotate.
-- for the report, the excel spreadsheet should differentiate between the 10 hour shift and the 8 hour shift (see attached). Also, if possible, there should be a way to add up the hours to the far left (48 hours per employee per week)
--
--at some point later, I would like to convert this customized shift Excel schedule into an app, but this is a bit down the road.
Link for pdf file showing my hand made custom shift document: https://drive.google.com/open?id=0B6LFsnmGwQ9HR0EwQTdsRE1Nakk
Recommended Skills
Employer Feedback
“Excellent work done by the freelancer. I would certainly hire again. His communication with me was first rate. ”
calcardiff, United States.
Public Clarification Board
How to get started with contests
-
Post Your Contest Quick and easy
-
Get Tons of Entries From around the world
-
Award the best entry Download the files - Easy!