Customized 24/7 Shift Scheduler using Microsoft Excel

Estado: Closed
Premio: $250
Propuestas recibidas: 19
Ganador: nadimvicky

Winner

Resumen del concurso

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

Habilidades recomendadas

Winner

Publica un concurso similar

Comentarios del empleador

“Excellent work done by the freelancer. I would certainly hire again. His communication with me was first rate. ”

calcardiff, United States.

Tablero de aclaración pública

cziner
- 7 años atrás
Sir, have you checked my proposal, entry #19 ?
- 7 años atrás
srjayathilaka94
- 7 años atrás
Hello sir. Please check my entry. Entry No #18
- 7 años atrás
l554446l
- 7 años atrás
Also, where do we put the remainder of the employees after dividing them into 3 shifts? And what do you mean by DCM Shift? Thanks.
- 7 años atrás
srjayathilaka94
- 7 años atrás
Hello sir. Please check my entry. Entry No #17
- 7 años atrás
nadimvicky
- 7 años atrás
Please check entry# 14.
- 7 años atrás
phoenix1691
- 7 años atrás
sir pls check #10 and also pls read my full description thanks CH as my entry will be elaborated in the description thanks CH
- 7 años atrás
Organizador del concurso
- 7 años atrás
Hi Clairflan55. Yes, these are not extra days off, as you correctly said. They are just the regular 2 days off, but arranged across 2 weeks back to back for a long weekend. -- Yes, I'll keep the competition open for at least another day.
- 7 años atrás
claireflan55
- 7 años atrás
Hi - will you be keeping this competition open for at least another day, please?
- 7 años atrás
claireflan55
- 7 años atrás
Another question: the four consecutive days off once a month (Fri-Sat-Sun-Mon) don't involve extra days off, do they? They are the regular 2-days-per-week off, but just re-organised to give them a long weekend?
- 7 años atrás
Nightwolf86
- 7 años atrás
I have a question Sir ... The rotation between shifts occurs for the whole shift at the end of the week, or for each worker after his off days?
- 7 años atrás
1. Organizador del concurso
  - 7 años atrás
  The rotations between shifts occurs at the end of each week. For example, week 1 a driver works, say morning shift for the entire week. Week 2 he may rotate into an afternoon or night shift for the entire week. Does that help?
  - 7 años atrás
claireflan55
- 7 años atrás
Please confirm: "arrange each employee's 48 hour work week shift in which they work 4 - 10 hour days and then 1 - 8 hour day" - first they work all their 10hr shifts, then their last shift of the week is an 8hr shift? Or, randomly mix them, so you don't end up short-staffed near the end of every week? Thanks
- 7 años atrás
Ver 1 mensaje mas
1. Organizador del concurso
  - 7 años atrás
  BTW if you want to see the hand-made pdf file showing how I do the shifts now, click on this link: https://drive.google.com/open?id=0B6LFsnmGwQ9HR0EwQTdsRE1Nakk
  - 7 años atrás
2. claireflan55
  - 7 años atrás
  Thanks - got the sample, it is useful.
  - 7 años atrás
phoenix1691
- 7 años atrás
pls wait for my entry i will be working on this tomorrow thanks CH
- 7 años atrás
andryod
- 7 años atrás
Where's attachment??
- 7 años atrás
1. Organizador del concurso
  - 7 años atrás
  Hi Andryod: Here is the attachment link: https://drive.google.com/open?id=0B6LFsnmGwQ9HR0EwQTdsRE1Nakk
  - 7 años atrás
claireflan55
- 7 años atrás
Hi, please send / post attachment
- 7 años atrás
1. Organizador del concurso
  - 7 años atrás
  OK. However, Freelanceer will not let me post this on the main page, however, once you submit a project proposal I can attach it. -- It is basically a pdf file showing what our complete current hand-made schedule looks like.
  - 7 años atrás
claireflan55
- 7 años atrás
Hi, please could you keep this open until tomorrow at least, working on it.
- 7 años atrás
1. Organizador del concurso
  - 7 años atrás
  Yes. I can hold it open until tomorrow.
  - 7 años atrás
maverick44000
- 7 años atrás
Hi. Please share the attachment.
- 7 años atrás
Organizador del concurso
- 7 años atrás
If you need a copy of the attachment, please let me know in the chat room, and I'll attach it there. For some reason, I am unable to attach the document to the contest page. (or at least, i do not see how I am able to do this).
- 7 años atrás
1. superInnova
  - 7 años atrás
  put your files on dropbox, google drive or 4shared etc and put link here.
  - 7 años atrás
2. SShtv
  - 7 años atrás
  Hi. Please send me attachments
  - 7 años atrás