Excel Templates | Excel Spreadsheets | Booking Calendar


Free Excel Templates

Booking Calendar

Posted on August 10, 2009
Filed Under Calendar | 24 Comments



Share

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

24 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

  14. pat on April 2nd, 2010 2:34 pm

    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

  15. Sheila on May 5th, 2010 10:36 am

    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?

  16. Janina Weghorn on May 10th, 2010 11:18 pm

    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!

  17. Nagaraj on June 29th, 2010 1:56 pm

    Thanks for the great template, how can I get the occupant name on the RED shading for easy identification.

  18. princess deje on December 14th, 2010 3:55 pm

    I think you have a good way of making templates. great job, well done. Can you improve on what you’ve done soo far? It will be really nice.

  19. Janina Weghorn on December 20th, 2010 8:39 pm

    I had your wonderful booking system working. Aded several rows payment calculation and so on, thanks to my great friend who is EXCEL teacher. But it was not enough for me,I need communication with over people making reservation, so I upload it to Google documents. Since then my availability sheet does not work. My friend told me that your program is very sophisticated one, and what Google is providing is not good enough to run your program. Any help or idea what to do? If I knew you e-mail I could send to you my form to look at it. Please help.

  20. Brooke on January 16th, 2011 2:46 pm

    Do you have any templates for creating an event planning handbook? Our organization has an annual conference that moves around the country for its locale. Every new host has to reinvent the wheel when they organize it so, we’d like to document our planning…6 months out…three months out…etc. (similar to a blank wedding planner). Thanks for any help you could provide.

  21. Ella on August 25th, 2011 8:34 am

    I really find your website very useful. I hope you can find a time to make an addition to your compilation… billing (printable version). So the list in the customers name in this booking reservation will also be automatic when we choose a certain customer.

  22. Dorothy Owen on September 12th, 2011 4:12 am

    I like your templates for my use to guest room reservations, My problem is I did down load but to open and edit in the word document and to use this same template by changing to my worksheet does not work, I’ve tried several times and I could not open save and edit to use.

    Please assist and thank you for your assistance to this request.

    cheers
    Dorothy

  23. Sumar on November 5th, 2011 3:59 am

    Hi Mr. Rusadya,

    Glad to find your site very helpful.

    I would like to change color criteria but it doesn’t work out;ex.available = green iso blue but the result still blue. I need more than 3 color criteria, how to add it?

    Tks

  24. Kevin on December 19th, 2011 11:32 pm

    Great template thank you very much.
    Would it be possible to have hours added to reservations so i could reserve a room for 1 hour at a time as well as for a night?

Leave a Reply