Looking for ideas on how to make certain cells interact within another and be able to reference it as well
I hope this doesnt get taken down, as I am not super knowledgable within excel but learning as i go. This is niche IMO and have tried looking up different solutions in many different ways and I got about half of this project done. I am a restaurant manager and we are looking to redo our reservation layout system. This is hyper specific to when we are open on holidays as we are reservation only and just about double our volume. In the past, we have done everything by paper and that has proved itself to be ineffective. I have created a sheet where 15 minute increments are on the y-axis and table numbers are the x-axis with the minimum and maximum for that party can be sat at. parties of 1-4 have time increments of 1.5 hours, 5-6 are 1 hour and 45 minutes, and 7+ is 2 hours. Currently I have if you input the party size into a time block, it will automatically block out the time slot allotted for that party size. The idea is to get as many rotations as possible for tables without too many guests coming into the building at once. I will attach screenshots of what i currently have. The issue Im having now, is in order to take the reservations, we will needs a guests, name, phone number, email, and credit card while also being able to reference where and what time their reservation is at. Im thinking a second sheet that interacts with the first.
The formula i used to complete the time blocking =OR(AND(OFFSET($ROW$#,-1,0)>=(MINIMUM PARTY SIZE),OFFSET($ROW$#,-1,0)<=(MAXIMUM PARTY SIZE))
in the screenshots, you can see, if you enter a party size that fits within that table, it will turn green and then the cells beneath will turn red in accordance to how long the party size is allowed. I am not completely finished as there are few formulas i need to tweak but I am aware on how to do so. Then the part that is separated by party size, I will have that follow the same formulas, this is for my colleagues, so it is easier for them to follow. As you can see this only gives us information on how many guests could be sat and what time, but there needs to be an area that takes down guests information with everything previously stated included, and being able to easily reference what table they would be sat at and what time.
[link] [comments]
Want to read more?
Check out the full article on the original site