Formulas for a project for a kids camp

[andrewoneill3]

Hello, I am reaching out to all the wonderfully helpful people on this site with another request. I have already received some excellent help with one of the formulas I needed. Here is another problem I have here:

Essentially I am trying to make a smart chart with formulas to automatically fill out a camper chore chart that otherwise can take hours to create correctly.

Here is my attempt at explaining what I need.

On one page, I have a few different lists of names of campers:
[TABLE="width: 300"]
<tbody>[TR]
[TD]Amanda[/TD]
[TD]Andrew[/TD]
[TD]Luisa[/TD]
[/TR]
[TR]
[TD]Tom[/TD]
[TD]Tristan[/TD]
[TD]Margaux[/TD]
[/TR]
[TR]
[TD]Lily[/TD]
[TD]Emily[/TD]
[TD]Huxley[/TD]
[/TR]
[TR]
[TD]Quinn[/TD]
[TD]Annabel[/TD]
[TD]Paul[/TD]
[/TR]
[TR]
[TD]Johanna[/TD]
[TD]George[/TD]
[TD]Talia[/TD]
[/TR]
[TR]
[TD]William[/TD]
[TD]Rebecca[/TD]
[TD]Cody[/TD]
[/TR]
</tbody>[/TABLE]

Below is what our chore chart looks like. Here is what I am looking for formulas for.

• I am hoping to fill all of the cells randomly with equal use of all names

With the following exceptions:

*Number of waiters at each table needs to change depending on the number of campers:

• If there are between 8-14 campers total (referring to the table above), I would only want the first 2 cells of the breakfast lunch and dinner waiter chore cells to be randomly equally filled.
• If there are between 15-21 campers total (referring to the table above), I would only want the first 3 cells of the breakfast lunch and dinner waiter chore cells to be randomly equally filled.
• If there are between 22-28 campers total (referring to the table above), I would only want the first 4 cells of the breakfast lunch and dinner waiter chore cells to be randomly equally filled.
• If there are between 29-35 campers total (referring to the table above), I would only want the first 5 cells of the breakfast lunch and dinner waiter chore cells to be randomly equally filled.
• If a camper is a morning animal feeder, they cannot be a breakfast waiter or a lunch waiter.
• Each camper needs to go animal feeding once, no one goes twice.
• If a camper is a breakfast, lunch, or dinner waiter, the camper cannot also be a dishwasher for that meal. For example, if they are a breakfast waiter, they cannot be a breakfast dishwasher for that same meal.
• If we go on a hike on one of the days and I don't need waiters or dishwashers, I need to be able to hide the contents of that specific range of cells.
• One camper should not be a waiter for more than two meals per day.

Ideally, with this all working, you would be able to type in random names into the cells like in the table above and have those names randomly fill the cells with the names with all of the exceptions mentioned.

I understand I am asking many questions here. Any help would be awesome! I am just not sure how to approach this and am looking for some help and guidance.

Thank you.