The video below gives a tutorial on how to add formulas to make your Excel recipes scalable. If you know how to do some Excel formulas then this is a big help for scaling your recipes. If a 1 times batch yields 20 servings and you need a 5 times batch for a total of 100 servings, all you need to do is put “5” in the “scale” box and your entire recipe is recalculated to make a 5 times batch. This will overwrite your blank template with all the content from your new recipe.Įach Excel recipe template below has a “scale” feature in the header.
Do not open your template, add all the content for your new recipe, and simply click “save”. This will keep your template blank and clear so it will be easy to use repeatedly. Then add all of the content for your new recipe. When you want to create a new recipe, open the “Recipe Template” file and immediately “save as” the name of your new recipe. The best way to use a recipe template is to set it up with all the basic info you want to appear on all your recipes, such as restaurant name, chef’s name, etc.
0 kommentar(er)
