• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Shift distribution in a duty roster

R

Ram Mher

Member
Dear All

Please find the attached file to resolve my issue. Description is given in the file from cells A 31 to A 47.

Hope you will spare your precious time to sort out my issue.

Regards
Ram Mher
 

Attachments

i'm not far behind (i dont think/hope) but still dont know exactly what you're looking for... could you fill out the sheet with an example of desired resutls!?

- when someone has 'weekly off' are they getting the whole week off? (weekly off sounds awesome!!)
- do the shifts for others change day by day or per week? ie: first week, A is 1st shift, second week, A is on 2nd shift...?
- how are you handling weekends and holidays?
 
Last edited:
Dear Suril, Your attached files are not opening. Please send again.

Dear JSON , example is fillled in the sheet. I evalute the same. In cell no B7 figure is shown 7 it means that seven employees are needed in A shift. Therefore A is written from B2 to J2 it menas that employees D,E,F,G,H,I and J shall come in A shift.
2. Working remains for 24x7x365 days so 4 or 5 employees get weekly off on each day.
3. Shift change occurs per week not day by day. Your example is correct.
 
Thanks a lot Suril. Shiftwise Roster issue is solved due to your guideline.

Take review on the file "roster.ram" also and provide the guidline. File is attahced in this thread at the top.
 
Mr.Suril, thanku very much for the nice solution.Most of things you have covered in the attached document except shift rotation.
Please find the attached sheet to know my remarks for shift rotation.
 

Attachments

You must log in or register to reply here.
Back
Top