Hotel room capacity/contingent planning

Topic Labels: Formulas
1183 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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. image.png
In another table I have my capacity plan that applies for each day.
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.

0 Replies 0