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.
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.