3 Replies Latest reply on Apr 16, 2018 10:54 AM by Shinichiro Murakami

# How to calculate room usage based on date?

Good Afternoon:

Here's the issue I'm trying to resolve. I have a list of rooms (total of 6), and the list of dates when the rooms are scheduled. What I'm trying to do is the following:

- calculate room usage: for example I want to know that on April 7 only 2 rooms were booked out of 6 (which represents a 33.3% usage)

- I also want to know which room were not used (the other 4) and list them as available.

- also, if at all possible, i would also like to do the same for a range date (say between April 6-7), how many were booked vs how many were available, and which ones were available?

I'm attaching a sample workbook.

I appreciate your help and guidance.

• ###### 1. Re: How to calculate room usage based on date?

Hi Virginie,

You can create this ind of view with some calculations.

I understand your general purpose of date range avail, but it's difficult to understand exact logic to understand avail or not.

ie. 4/4 avail, 4/5 occupied, 4/6 avail, 4/7 occupied ==> What do you want to show?

Thanks,

Shin

• ###### 2. Re: How to calculate room usage based on date?

Hi Shinichiro:  Thank you for this.

Ideally, I would like to see something similar to this:

If I pick a date (via filter) say April 7, I would to be able to show

Total of rooms Available = 4  with the list of the room available

I 4-301

MC 3-200

MC 7-150

MC 9-500

Total of room Used = 2

MC 4-301

I 5-105

Which means a percentage of usage of 33%

Does it make sense?

• ###### 3. Re: How to calculate room usage based on date?

Not quite, but I try to create different workbook.

To eliminate non-existing value, I created scaffold table.

Thanks,

Shin