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!
New Tool - Diet Spreadsheet
Linear Mode
