Excel Templates | Excel Spreadsheets | Restaurant Reservations


Free Excel Templates

Restaurant Reservations

Posted on September 12, 2009
Filed Under Calendar | 7 Comments



Share

Following my reservation spreadsheets on hotel, car, and banquet hall which based on day reservations, this reservation spreadsheet is based on hour reservation. The basic reservation scheme is the same, but I put tables number, smoking and non-smoking preferences, and table capacities as parameters in this spreadsheet. But, the formula will work only on the table number.

Restaurant Reservations

This spreadsheet consists of two worksheets. To customize this spreadsheet, go into availability worksheet and put your tables information in table type, capacity, and table number columns. And you can custom the display of reservation time here, by change the time step value (in minutes). After you finished entering all information, you can go to restaurant reservation worksheet to start your reservation log. You can custom the column in this worksheet except the table number because this is the reference of the formula. Once you fill the reservation or you want to see the reservation information, go back to the availability worksheet and slide the date to the date of reservation.

OK. That’s all guys. Feel free to give me some feedback about real situation, since I don’t have a restaurant :-) . You can download the file here.




You can read and download my other templates below :

Tags: , , , , , ,

Comments

7 Responses to “Restaurant Reservations”

  1. Naveed on November 19th, 2009 2:25 pm

    Dear Friend,
    Thanks for such a usefull upload, it can be more enhanced if you add few more formulas i.e
    You can use validation and creat a drop down list for tables and when someone reserved a table for some time period on specific date it should say table not available for this time or just remove from the list for that specific time so there will be no duplication.
    Thanks

  2. Manjunath.V on January 2nd, 2010 1:44 pm

    Thanks for your templates ,it was very usefull,

    Could you provide me conference room booking template, our office has one conference room and the staff could book in 8hrs either all the time or in breakup of 2hrs excluding lunch break between 1 P.M to 1.30 P.M.

    Thanks in advance

  3. Jack Best on January 19th, 2010 7:10 pm

    Hi there i wish to thank you for all your useful uploads but i was wondering if it would be possible for you to either show me step by step how to do this or point me to a website where I can cheers thank you very much

  4. Noelle on February 17th, 2010 6:10 pm

    Hey this template is great- but is there anyway to not only pull a color box but to actually pull the table number? So if its available it will still be blue but if its not available it would turn red with the table number booked in it?

  5. Jenny Hepburn on November 26th, 2010 8:58 am

    Good day this template is great- but is there anyway to not only pull a color box but to also pull the the guest name in text format? So if its available it will still be blue but if its not available it would turn red with the guest name booked in it?t

    Thank you so much. i have tried to copy some of your formulas but with a little change to insert taxt but to no avail. Please get back to me as soon as possible.

    Take Care

    Jenny

  6. Jennifer on February 1st, 2011 8:15 am

    Hi, we’re a theatre and an arts centre and we have a couple of rehearsal rooms for hire on an hourly basis. I tried to use some of your templates and I don’t know how to modify the formulas according to our needs. I hope you can help us because we’re stuggling using the old excel file and it’s taking us hours just to ensure that we don’t do double booking. I would really appreciate if you can help us.

  7. Mariken on April 2nd, 2012 12:47 pm

    Hi,
    thanks for this spreadsheet. I will get back to you soon. try to inplement this in a google doc.

Leave a Reply