leftwifi.blogg.se - Calorie tracker spreadsheet

Calorie tracker spreadsheet pdf#

For example, if the measurement is 125mL, and you ate 250mL, type 2 as the quantity. Otherwise, the wrong items might appear in the Food Item drop down list.Īfter you select a food item, its measurement appears, and you can enter the quantity that you ate, based on that measurement. This list comes from the FoodList sheet, so it’s important to keep the FoodList sheet sorted by category. There’s a dependent data validation drop down list in the Food Item column, based on the Category that you select. The Meal/Snack and Category source lists are stored in named ranges on the Lists sheet. In the green data entry cells, there are drop down lists, created with Excel’s data validation. There are only 22 rows for data entry, so that should help limit your food intake! In the main sheet, named FoodEntry, you can enter the date, your target calorie count, and all the foods that you eat.

Click the check mark at the left, to confirm the change, and click CloseĪlso, see below, for adding more columns to the Daily Calorie Counter The Daily Calorie Counter.

In the Refers To box, at the bottom, change the number of columns, from 3, to the number of columns in your revised table.

In the list of names, click on FoodLookup.

In Excel 2007, click the Formulas tab, and click Name Manager (In Excel 2003, click Insert | Name | Define).

If you want to add more columns to the lookup table, such as fat or carbs, you’ll also need to change the named range for the lookup table. The food lookup table in the sample file only has calories list. The CONVERT function calculates the amount in the adjacent white cell.Īdd More Columns to the Food Lookup Table There’s also a table where you can do your own conversions, by typing a number in the green cells. The measurements are metric, so I added an approximate conversion list too, in case you don’t speak metric. You can add items to the list, and sort the list by category when you’re finished adding food items. I created a list of foods in an Excel workbook, with categories, food items, measurements and calorie counts. To start, I copied some food data from the Health Canada website. As soon as Bill sends me something better, I’ll let you know.

Can’t Microsoft invent something to make weight loss easier? I don’t even care if it has menus or a Ribbon! Excel Calorie Counter Food Dataīill Gates isn’t answering my phone calls, so I created an Excel Calorie Counter that I can use in the meantime. Apparently it takes a bit of effort, including dietary changes and maybe some exercise. Now, here is an Excel Calorie Counter to add to your tool kit.Īs Dick Kusleika pointed out in the comments for the Weight Loss Tracker, simply downloading the workbook doesn’t have any effect on your weight. Record sets/reps/weight.On Monday I described the horrible side effects of Christmas cookies, and posted an Excel Weight Loss Tracker workbook.

Strength Training Workout Log at - Lists the common strength exercises by muscle group.

Calorie tracker spreadsheet pdf#

Print a Workout Log - After creating your workout log online, you can save it as a PDF or an Excel file.

Definitely one of the best workout logs I've seen.

Comprehensive Workout Log - A very holistic workout log, including cardio and strength exercises as well as diet and nutrition.

This will help you identify the right metabolic equivalent value to use if you are using a calories burned calculator. Intensity: For the cardio exercises, in addition to listing the amount of time or distance, you should enter the intensity as Light/Moderate/Vigorous (see the info on the exercise log page for guidelines) or Easy/Medium/Hard.

To calculate your One-Rep Max, see the information in our Workout Chart template. This is mainly for reference because many weight training programs have you do a certain number of sets/reps at a weight that is a percentage of your 1RM. One Rep Max: The workout log has a place to record your 1RM (One-Rep Max).