Hotel room capacity/contingent planning

Hey everyone,
I’m trying to create a hotel room capacity plan so I can see if we have enough rooms of a category left or if we’re overbooked.
I have one table where I create rows for each speaker who needs a hotel room from arrival to departure date.


In another table I have my capacity plan that applies for each day.
image
Now I’m trying to make a capacity plan for each day for each room to see if we’re overbooked or have spare rooms. I know how to do it in Excel but am not quite sure how to continue here. I started with another table that has all dates and booked and available rooms but don’t know how to get all booked rooms within in the date ranges.
Appreciate your feedback.
Isabelle

1 Like