Menu Planner

Do you experience difficulties when creating food menus?

Preparing food menus for restaurants, canteens, hotels, and special events is a challenging, time-consuming, and error-prone task, which can be facilitated using this Excel workbook.

This Excel workbook allows:

• Easily and quickly access a wide selection of dishes and foods.
• Easily add foods/dishes to the database.
• Add new categories of foods/dishes to the database.
• View information relating to repeated items in formulated food menus.
• Create food menus for a desired number of days of the week, lunches and/or dinners.
• Access to pre-formatted and ready-to-print sheets.

This Excel workbook includes 5 templates:

1. Lunch or Dinner: This sheet allows you to create a menu for a meal, which could be lunch or dinner, for up to 7 days.
2. Lunch And Dinner: This sheet allows you to create a menu for the lunch and dinner meals, for up to 7 days.
3. Lunch And Dinner - version 2: Like the previous option, this sheet allows you to create a menu for two meals, but with a noticeably different layout, with all the information presented in just 3 columns.
4. Varied Meals: This sheet allows you to create a menu for up to 7 meals and allows you to include up to 6 foods or drinks for each food category.
5. Varied Meals version 2: This sheet allows you to create a menu for up to 7 meals, and up to 7 days. It allows you to select from up to 20 food categories for each meal.
6. Database: This sheet contains tables relating to the types of existing meals, food categories, and the foods and drinks belonging to each category.

Another advantage of this Excel workbook is that it only uses simple Excel functions. It does not use macros, or VBA coding, which helps to minimize the probability of errors.

It includes a detailed guide (pdf file) with instructions for using the workbook.