Muscle & Strength Forum - View Single Post - New Tool

Saurus · 01-15-2007, 05:00 AM

Hi guys

I wrote a little calorie counting spreadsheet which I've been using and have found very useful.

Since most people eat roughly the same foods most of the time, the spreadsheet allows you to enter calorie, protein, carbs and fibre data once, and then all you need to do is enter the number of portions each day, and the spreadsheet will calculate the following for you automatically:

Calories for the day
Calories from protein and percentage protein
Calories from carbs and percentage carbs
Calories from fats and percentage fats
Total fibre

So, here it is:

http://www.muscleandstrength.com/fil...preadsheet.xls

I've left my diet in as an example, but here's a few instructions anyway:

Instructions:

1. Click on the page called "Tables." Here, you should enter the calories, protein, carb, fat and fibre values of the various foods that you eat in a day (you only need to enter this once.) Use a good calorie counting book or an internet website to obtain the values.

2. Click on the "diet" page. Here, you should enter the number of portions that you ate on a particular day (portion size defined by you on the "Tables" Page.) You cannot enter anything on this page except number of portions.
Scroll left if the name of the foods doesn't appear on the page.

3. Click on the summary page to get your results.

4. Send me a private message if there is anything you would like to know or do not understand.

Enjoy!

01-15-2007, 05:00 AM	#1 (permalink)
Saurus Stealth Mod Join Date: Jul 2006 Location: Pretoria, South Africa Gender: Male Training Exp: 5-10 Years Current Goal: Build Muscle Photos: Saurus's Gallery Posts: 2,748 Rep Power: 70	New Tool - Diet Spreadsheet Hi guys I wrote a little calorie counting spreadsheet which I've been using and have found very useful. Since most people eat roughly the same foods most of the time, the spreadsheet allows you to enter calorie, protein, carbs and fibre data once, and then all you need to do is enter the number of portions each day, and the spreadsheet will calculate the following for you automatically: Calories for the day Calories from protein and percentage protein Calories from carbs and percentage carbs Calories from fats and percentage fats Total fibre So, here it is: http://www.muscleandstrength.com/fil...preadsheet.xls I've left my diet in as an example, but here's a few instructions anyway: Instructions: 1. Click on the page called "Tables." Here, you should enter the calories, protein, carb, fat and fibre values of the various foods that you eat in a day (you only need to enter this once.) Use a good calorie counting book or an internet website to obtain the values. 2. Click on the "diet" page. Here, you should enter the number of portions that you ate on a particular day (portion size defined by you on the "Tables" Page.) You cannot enter anything on this page except number of portions. Scroll left if the name of the foods doesn't appear on the page. 3. Click on the summary page to get your results. 4. Send me a private message if there is anything you would like to know or do not understand. Enjoy! __________________ A person is only as big as the dream they dare to live.