Gleim Atp Book And Computer Program. Preparing Your Spreadsheet. After scouring the web, we found the best pre-made Excel spreadsheet that can be used with the IIFYM calculator is the Excel Calorie. Following my previous post and excel tool to calculate BMR, this is a calorie intake calculator that will calculate how many calories you need when you do several.

Flowers Images Roses. Excel Calorie Counter Intro Use the basic Calorie Counter workbook to keep track of the food that you eat, and the nutrients that it contains. There is also an advanced Calorie Counter workbook that contains a recipe calculator. Input all of the recipe ingredients, and Excel calculates the calories, carbs, protien, fibre and fat per serving. After you calculate the recipe's nutrients, you can add that as an item in the workbook's food list.

Daily Food The main sheet is named FoodEntry. Each day, enter the date, and your target calories. Then, select the time (Breakfast/Lunch/Dinner/Snack) and the food category.

In the Food Item column, select one of the foods from that category. Is used here, to limit the selections, based on the choice in Category column. Finally, enter the quantity that you are eating, based on the amount that appears in the Measure column. In this example, the amount is 175 mL (about 6 oz). Type a 1 in the Qty column, if you are eating a serving of that size. Or, type a different number, such as 0.5 or 1.5, if you are eating more or less than that.

After you enter a quantity, the Calories column will show the total calories in your serving. Save the Food Data At the end of each day, click the 'Save Daily Data and Clear' button, at the top of the FoodEntry sheet. That clears the green cells on the FoodEntry sheet, so you can start fresh the next day. All the food data is pasted onto the DailyRecord sheet, below any previous entries. The Food List To see the stored list of foods and their calories, go to the FoodList sheet. You can add new foods, or edit the existing foods.

IMPORTANT: After you make changes, be sure to sort the list again, by Category and Food Item. The list must be sorted, or the dependent drop down list on the FoodEntry sheet will not work correctly. Food Summary On the FoodPivot sheet, you can that summarizes the stored food data. Choose different ways to summarize the data,. Or, use different, such as% of Column, as in the screen shot below.

Download the Excel Calorie Counter Excel Calorie Counter -- Download the basic Excel Calorie Counter workbook. The zipped file is in xlsm format and contains macros. Enable macros when you open the file, so the Save Data button will work correctly. Excel Calorie Counter With Recipe Calculator: Same features as basic Excel Calorie Counter, plus a Recipe Calculator --calculate nutrients per serving in your favourite recipes, and add those to the Food List. The zipped file is in xlsm format and contains macros.