If you download the file, and test it, please let me know if you have any suggestions for making it easier to use. This is a beta version of the Recipe Calculator, and I have a few ideas for improving it. (pdf files with restaurant foods at bottom of page).(sign-up is required, free membership available).(type a food in the search box at top right).If you’re looking for more nutrient information, to add items to the food list, you can try these websites: Check the product labels for accurate numbers. The calorie counts are from Health Canada, so the ingredients and calorie counts might be different where you live. In the download section, look for “Excel Calorie Counter With Recipe Calculator”Īs I mentioned when posting the original Calorie Counter, I’m not a medical professional, so use this workbook for entertainment purposes only. The file is in Excel 2007 format, and contains a macro. You can download a zipped copy of the Excel Calorie Counter with Recipe Calculator on the Contextures website. Once your recipes are added to the list, you can select them in the FoodEntry worksheet, where you enter your daily food choices.ĭownload the Excel Calorie Counter with Recipe Calculator I used the category _MY RECIPES, but you could use one of the standard categories, if you prefer. The Food List has the nutrient information for 100 grams of chicken.Īfter you calculate the recipe’s nutrients per serving, you can copy the total amounts, and paste as values in the FoodList sheet.In the first row shown below, the recipe calls for 1.25 pounds of chicken.This feature uses the Excel CONVERT function. Then, enter the ingredients and their categories, along with the required amounts.Īlso enter the amount shown in the Food List measurement, and the worksheet calculates a multiplier. WARNING: The Excel calorie burn calculator workbook does not provide medical advice or information. Select a weight range, choose a food item and an activity, and the calculator will show you the estimated time, in minutes or hours. On the new RecipeCalc sheet, you can enter a Recipe Name and category, and the number of servings. Use the Excel calorie burn calculator workbook to see how long it takes to burn calories.k. If you download the workbook, please let me know what you think of the changes. The new version also has protein, carbohydrates, fat and fibre data. Thanks Autumn, for the suggestion and the reminder. “I’m also looking to add a sheet within the workbook, that would work similarly to the Daily Entry sheet, where I can input a recipe to calculate the nutritional info for 1 serving of said recipe.”Īnd in the latest version, that Recipe Calculator has been added. In one of the comments, Autumn suggested that I add a recipe calculator to the file. A couple of years ago, I posted an Excel Calorie Counter workbook, which has been very popular.
0 Comments
Leave a Reply. |