Work Break calculator

[Rob-UK]

Hi gurus !

I would like to create a sheet that auto populates staff breaks in a working day.

I have 2 choices for breaks on an early shift, 2 choices for breaks on a late shift, and 2 choices for breaks on a night shift.

I have a table that shows each person's name and their preferred choices for each shift.

I am hoping that in a new table I can select if its an early, late or night shift, and then using data validation select a list of names that are working. Then a magic button or something that will look at the preferred times for each person working, and populate their break time with one of their choices.
Obviously I do not want everyone to have the same break so need to factor in a max number of times a break can be allocated depending on the day in question!
It sounds complicated to me but hopingnits not, as will save soo much time every day trying to work it all out.

The staff working any one shift change regularly so it's not like I can create a template were I to have the same team every day. There are 25-50 people I need to allocate breaks to each day!!!

Thanks in advance. Rob

 

[Rob-UK]

To clarify, each staff member gives their 2 preferred times out of around 6 options. Those 2 options will always be their options hence why a spreadsheet could work I think!

 

[Rob-UK]

I take it from the unusual lack of responses that this is not at all straight forward, and would require some VB programming etc ?

Equally, if I'm not giving enough information, let me know!

Continued appreciation for any help.

Rob

 

[Rob-UK]

Link to sample data- Data

cells e217 show data. Cells a2 and b2 will be selected by user, and names of those working, and whether dropback shift will be selected from list in cells a4:b18.

Column c4:c18 would show the time selected by the program based on the times available and noting the 2 preferences given.

One additional bit of info will be the maximum number of people on a particular time if that is something I can select. Annoyingly that is likely to change based on the day and how many people are in !!

I will then aim to produce a sheet with the times for each day which this sheet data would populate.

Hope that helps.


Rob

 

[Logit]

The link provided requires permission to access. Even then, you are only providing an image. Pics are nice but do not provide the actual file to work with.

For best results, create a sample file showing a BEFORE and AFTER sample of what you are attempting to accomplish. Mock up the actual data showing
the before and after.

Post the file to a CLOUD site where it can be easily downloaded for review, then provide the link to the download here. The link should NOT require the
use of passwords or special permission. That will make it a simple process of accessing and downloading.

 

[Rob-UK]

The link provided requires permission to access. Even then, you are only providing an image. Pics are nice but do not provide the actual file to work with.

For best results, create a sample file showing a BEFORE and AFTER sample of what you are attempting to accomplish. Mock up the actual data showing
the before and after.

Post the file to a CLOUD site where it can be easily downloaded for review, then provide the link to the download here. The link should NOT require the
use of passwords or special permission. That will make it a simple process of accessing and downloading.

Thanks for this. Apologies. I thought the link was an accessible one. Have now put up basic spreadsheet and made accessible to anyone with this link

Break Spreadsheet basic.xlsx

drive.google.com

Thanks.