In the example shown below, the measure is 175 mL (about 6 oz).The drop down list limits the food item selections, based on the Category selected in each row.įinally, enter the number of servings that you ate, based on the single serving amount that appears in the Measure column. The drop down list was created with dependent data validation.In the Food Item column, click the drop down arrow, then select one of the foods from that list. Then, in the next column, use the drop down list to select a food category. Next, select the meal type (Breakfast/Lunch/Dinner/Snack)
EXCEL SOLVER EXAMPLES DIET PROFESSIONAL
One has green cells for data entry, and the other has orange cells for data entry.Įach day, enter the date, and the target calories that your medial professional recommends as your daily calorie intake.
EXCEL SOLVER EXAMPLES DIET FREE
(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 food product labels for accurate nutrition numbers. Target Calories: Check with your medical professional for advice on your target calories.įood Data: Most of the food data was obtained from Health Canada, so the ingredients and calorie counts might be different where you live. I am not a medical professional, so use this workbook for entertainment purposes only, or in consultation with a medical professional. Input all of the recipe ingredients, and Excel calculates the calories, carbs, protein, fibre and fat per serving.Īfter you calculate the recipe's nutrients, you can add that as an item in the workbook's food list. There is also an enhanced Calorie Counter workbook that contains a recipe calculator. Use the basic Calorie Counter spreadsheet to keep track of the food that you eat each day, and the nutrients that the food contains. Get the Calorie Counter Excel Calorie Counter Intro
0 kommentar(er)
