Menu Planner

	A	B
1	Introduction	I created this spreadsheet to help create a meal plan for a four week period. I found the recipe books written as part of the 8 week blood sugar diet and the Fast 800 diet very good and contain all the nutritional content I needed but pulling them together in a plan which balanced the nutrition I wanted was very laborious
2
3	Overview	This menu planner has three sheets
4		The Books sheet holds the full names of the recipe books used with their three letter short code. The code needs to be only three letters for the formulae to work.
5		The Recipes sheets holds all of the recipes with their nutritional content. Each recipe is given a short code which will identify the recipe book and page. Where there are multiple recipes on a single page additional numbers are added. The maximum number of character for the page reference is five. Every recipe must have an unique ID code. The Recipes sheet has an auto-color setting on the nutrition data to highlight 'good' and 'bad'. This is set for a Low Carb style diet, so Carbs and Calories bad, Fat, Protein and Fibre good.
6		The Planner sheet which allows you to create a four week plan of recipes and review the nutritional content of the day. I have locked the cells in this sheet to stop inadvertent changes to cells that are calculated. If you want to change these cells you will need to remove the protection.
7
8	Instructions	In the Recipes sheet use the filters next to the column titles to find the Meal Type you are looking for (Breakfast, Lunch, Main Meal). You can also filter by Subtype and also nutritional content. For instance use this to find recipes with less than 10g of carbs.
9		From the reduced filtered list browse and choose the recipes you like. Copy the ID of the recipe you want into the correct ID field on the Planner Sheet
10		The Planner sheet will expand your selection to a more readable form with a reference to the book and the page you need to look up to make the recipe.
11		Once you have a day complete you may need to re-adjust your selections if the day does not match your goal for calories and carbs.
12		Once you are complete use the - and + filters on the left of the Planner sheet to hide the nutritional details when you are finished to be able to print a single sheet
13		In the selections current set in my Menu Plan I focused on reducing Carbs and Cals, and was less worried about Fibre and Fat. Your criteria may be different.
14
15	Maintenance	Feel free to add further recipes from other books or your own. You will need to make a copy of this workbook to your local Google drive (File-> Make a Copy) in order to make any changes. If you do add some good stuff and want it adding back into this master please let me know at diet@harveyweb.co.uk, thanks.
16
17	Books
18	Fast 800 diet	The Fast 800: How to combine rapid weight loss and intermittent fasting for long-term health
19	Fast 800 recipe	The Fast 800 Recipe Book: Low-carb, Mediterranean style recipes for intermittent fasting and long-term health
20	8-week diet	The 8-Week Blood Sugar Diet: Lose weight fast and reprogramme your body
21	8-week recipe	The 8-week Blood Sugar Diet Recipe Book: Simple delicious meals for fast, healthy weight loss
22	Fast 5:2 diet	The Fast Diet: Lose Weight, Stay Healthy, Live Longer - Revised and Updated
23	Fast 5:2 recipe	The Fast Diet Recipe Book: 150 Delicious, Calorie-controlled Meals to Make Your Fasting Days Easy
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100