Excel Templates | Excel Spreadsheets | Booking Calendar



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.
Booking Calendar 3
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.
Booking Calendar
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.
Booking Calendar 2
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 :

Tags: , , , , , , ,

Comments

13 Responses to “Booking Calendar”

  1. JAC on August 25th, 2009 5:34 am

    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!

  2. Kim on August 28th, 2009 6:18 pm

    Check out a program called TimeOff by Mycroft.
    I use it for a staff of 20 and it’s great.
    User friendly and cheap

  3. meredith davia on September 2nd, 2009 10:19 am

    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

  4. admin on September 7th, 2009 2:55 pm

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

  5. Tony Chaar on September 22nd, 2009 8:52 am

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

  6. Tony Chaar on September 24th, 2009 2:09 pm

    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

  7. Teri on September 30th, 2009 9:41 pm

    Do you have anything like these templates for multiple property bookings, for holiday lets?
    have been trying to find something.

    many thanks

  8. Joshua on October 8th, 2009 2:12 pm

    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

  9. Admin on October 16th, 2009 4:38 am

    @ 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

  10. richard on November 9th, 2009 4:24 pm

    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?

  11. Kevin on January 8th, 2010 3:07 pm

    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?

  12. ash on February 24th, 2010 12:32 am

    By any chance i can add more room and types in here.

  13. colin on March 5th, 2010 8:03 pm

    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

Leave a Reply