ajeet kumar singh
New Member
if a hotel is occupied with room nos. 1,2, & 3 from 10-02-2015 to 15-02-2015 then i want to know about rest available room within period.
Excel Formula required
- Thread starter ajeet kumar singh
- Start date
Welcome to the forum ajeet.
For a previous look at a hotel planner, take a look at this thread:
http://forum.chandoo.org/threads/hotel-booking-engine-module-in-excel.11232/
For your data, I created a quick red light/green light table to show when rooms are available.
I setup the items as XL tables so the formuals can use structural references, meaning that you can keep adding entries to the Guest check-in table, (or dates to the vacancy table) and the formulas will automatically update.
For a previous look at a hotel planner, take a look at this thread:
http://forum.chandoo.org/threads/hotel-booking-engine-module-in-excel.11232/
For your data, I created a quick red light/green light table to show when rooms are available.
I setup the items as XL tables so the formuals can use structural references, meaning that you can keep adding entries to the Guest check-in table, (or dates to the vacancy table) and the formulas will automatically update.
ajeet kumar singh
New Member
Welcome to the forum ajeet.
For a previous look at a hotel planner, take a look at this thread:
http://forum.chandoo.org/threads/hotel-booking-engine-module-in-excel.11232/
For your data, I created a quick red light/green light table to show when rooms are available.
View attachment 15732
I setup the items as XL tables so the formuals can use structural references, meaning that you can keep adding entries to the Guest check-in table, (or dates to the vacancy table) and the formulas will automatically update.
Dear Sir,
The formula is good for me, but i want to know this from other way. i want to know about only vacant room within period. like, if room nos 2 & 3 is occupied from 10-feb to 15 feb then result should we 4,5 & 6. i attached a example. thanks for your help
Attachments
Hi ajeet,
I'm not sure I understand what's wrong. Looking at my file, I can quickly look at any time period in the table and see which room's are vacant (green lights) vs. which ones are occupied (red lights).
Your screen shot looks to be from some other workbook completely, one that is much more sophisticated than the one you originally posted. If you want us to work with a different layout, it would help to provide it. When you give a basic layout, we provide an answer, and then you say it didn't match what you were expecting because your real layout is very different, it's somewhat frustrating to us.
I'm not sure I understand what's wrong. Looking at my file, I can quickly look at any time period in the table and see which room's are vacant (green lights) vs. which ones are occupied (red lights).
Your screen shot looks to be from some other workbook completely, one that is much more sophisticated than the one you originally posted. If you want us to work with a different layout, it would help to provide it. When you give a basic layout, we provide an answer, and then you say it didn't match what you were expecting because your real layout is very different, it's somewhat frustrating to us.