Booking Calendar
Posted on August 10, 2009
Filed Under Calendar |
Compare with previous reservation templates I posted, this booking calendar is created with relatively different approach. This reservation template is having month layout, like monthly calendar layout. So, you can check or manage your booking by viewing the availability month by month.
And I created this booking calendar for hotel booking purposes. If you already downloaded my previous hotel booking template, you will see the different. You can put all room information down along the column because the period layout is column based. But, this one has a calendar layout which mean you cannot put your room information down along the column. So, you have to put your room information in room booking worksheet.
In this worksheet, you can put type of the room and room detail. For example, you have 4 Standard Rooms, 3 Deluxe Rooms, 2 Superior Rooms and 1 Suite Room. Put that information in corresponding table. After that you can break down each room in the table below room type column.
You can see how the room displayed in Calendar worksheet. You can set your booking period by selecting the month and fill the year. And you can select whether you want to see room availability based on room type or room detail. If you select “room type”, you will see numbers inside the calendar that represent the availability of rooms with that type. If the cells turn red, it means the rooms are not available. If you select “room number”, the calendar will display the availability of that room where if the room is available it will show you number 1 (not blue color due to conditional formatting limitation). If the cell is red, it means the room is not available. If the cell is yellow, it means the room is double booking.
There is a scroll bar to scroll between rooms, since the maximum room availability that can be displayed is four. And the same with the previous hotel reservation template, once your customer agreed with the time, you can go back to “room booking” worksheet to fill your customer detail information.
You can read my previous hotel reservations spreadsheet. And if you are clear enough with above short explanation :-)… you download the file here.
You can read and download my other templates below :
- Hotel Reservations
- Banquet Halls Reservation
- Restaurant Reservations
- Car Rental Reservations
- Monthly Calendar
- Bill Payment Calendar
- Monthly Planner
- Excel Calendar 2009
Comments
17 Responses to “Booking Calendar”
Leave a Reply
Any chance you could do a spreadsheet like this but have it be for Employee Vacations. I have a business and need to be able to schedule vacation times rather than room bookings. Thanks!
Check out a program called TimeOff by Mycroft.
I use it for a staff of 20 and it’s great.
User friendly and cheap
i need to add columns for number of people in a room and whether they are half board or not. easy to add the columns in the booking worksheet, but where and what code do i add so it shows
this information and customer name on the calendar without loosing the red blocked out colour?
thanks md
@ Meredith : I’ve add additional column in the latest version, and I have fixed the checkout date issue, where in the previous version it still occupy the room. If you still need more columns, use insertion column command instead of copy and paste command. Cheers.
I just want to thank you for these templates and for helping people arround the globe to make their work easy.
I have downloaded the hotel reservation which i was working on creating one to run my small hotel, and i found yours more reliable.
Thank You…..
Hi again,
In the room booking sheet we have 48 room type and number, i have added another 20 and i have modified the formula in the calendar to appear and it works, but in the combo box where you have to choose room number for your reservation it did not showed me the added room numbers.
Can you help with this?
Thank You
Do you have anything like these templates for multiple property bookings, for holiday lets?
have been trying to find something.
many thanks
Am a college tutor in hospitality and find your templates helpful.But have a problem in updating the availability from available to not available.How to i change the colours.Please help.
Thank you
@ Tony : Go to menu data > validation and extend the max row number to your max row number, and your additional room number will be revealed
@ Teri : Try my other model for reservation in this site, you can modify the layout and formula to suit your needs
@ Joshua : Go to menu format > conditional formatting, you will see the format setting for color.
Regards
Great stuff, but like Meredith I need to get the the guest name to display over the red booked colour? How do I do this?
I like how this operates and want to use it for our picnic shelter reservations, how do I change it to only have 4 possible rooms available?
By any chance i can add more room and types in here.
This looks realy great. I am looking for something very similar but for a car. where i can put down booking details and it will mark on the calander when it is booked out
Just downloaded the booking template from 2009 but cannot get it to work. Is there a problem with color or are there any tutorials that \i can troubleshoot I am using using windows 7 with office excel2007
Template is very useful but have a problem when trying to insert comments to say if guests have paid etc. When I use the comments box it stays in the one place and moves along with the dates.
How can I insert a comment which stays with the relevant room and date only?
I have this same problems. Downloaded the booking template from 2009 but cannot get it to work. Is there a problem with color or are there any tutorials that \i can troubleshoot I am using using windows 7 with office excel 2007. Spend all afternoon, changed dates, rooms, put information about new reservation and it does not shows on availability calendar. When I closed program and try to save it I had compatibility problem. Please help!
Thanks for the great template, how can I get the occupant name on the RED shading for easy identification.