Tampa-Terry suggested I post a topic about my nutrition spreadsheet I made. So here goes…
I started a fat loss program about 2.5 months ago because one day I looked in the mirror and saw a fat bastard staring back at me. I have about a decade of training experience from my youth. So the excercise part of this whole fat loss equation has come pretty easy for me. But the stuff posted on T-Nation is a little above my head right now, but I am learning lots. So as part of my contribution to fellow T-Men and T-Vixens I am willing to send this spreadsheet to any who want it.
Now onto the workings of this thing.
The workbook is comprised of many sheets as follows;
===Tracking===
This is where I measure my progress, In my case its fat loss(this workbook will work for those bulking as well), so the first thing to do here is enter your start date. There is a colored cell where you enter the date. dd/mm/yy
Now you will notice that the Weekly actuals will have changed to indicate every seven days, for me this is when I do my weekly fat caliper measures, scale measure and enter the number from my accu-measure fat caliper. This is a pretty simple device that seems to be very consistent if you operate it properly. You enter the body fat %, Net body weight and then the sheet calculates Lean body mass, body fat mass. Body Fat Loss/Gain in % and lbs, lean body mass loss/gain in % and lbs. And for a ease of use in interpreting all this data and correlating it to your caloric intake it sums your weekly Caloric intake, Weekly protein, carb and fat intake.
I also added a table on this sheet to enter your goals, and a sum to date of fat loss, body weight loss or gain and lean body mass increase.
===Calculation Sheet===
This sheet is used to enter your personal information such as age, body weight, body fat %, Resting heart rate etc.
Calculations are made for Calorie predictions using Katch McArdel and Harris Benedict Method for Men or Women. Below this there is a place to enter the calculated caloric intake because these are just formulas and for those that know what they need in terms of calories you can simply enter this here or use one of the numbers generated by the formulas.
There is a table that calculates Heart Rate zones for those that do cardio using two methods, Karvonnen and Age Predicted.
On the right side of the sheet there is a place to enter your desired macro nutrient ratios. You will notice that there are two places to enter these. I do three days of low carb intake and one day of high carb intake, the macro ratios change on these which is why I made two places. If you are wanting the eat the same macro ratios all week then enter the same ratios in each spot.
===Shopping List===
I think this is pretty self explanatory…
===Weekly Tabs (sheets)===
These sheets are broken up so there is 7 days of meal menus in each sheet. There are 12 weeks worth of daily meals available. Enter your start date on the Week 1 Sunday and the rest of the weeks dates are calculated.
These weekly sheets are linked to the Master food table where you enter your foods including the macro nutrients.
Enter your time of each meal, now in the Type Column - click on this and it brings up your master food table food type, just scroll through the list till you find what you want and it enters the info, next enter the serving size or amount and it calculates the protein, carbs and fat grams and the calories. Fill in the foods for each meal and it calculates the daily totals, giving you a breakdown in grams, percentage of macro ratios and total calories of each meal, each day etc. You can plan your entire week with this.
===Recipies===
Here you can enter some simple recipies which calculates the totals for the recipie and serving size. You have to enter this into the food table once you are done.
Its not important but I found it handy if I want to make a new recipie and quickly find out how many grams of nutrients are in it.
===Food Table===
This is a list of all the foods one would normally eat, there are alot of things in there already but feel free to add on to it. The foods must be entered in alphabetical order or you simply enter the foods at the bottom of the table and do a sort in ascending order.
You can download it here.
http://table29.com/down/Nutrition_Planner.v.2.10.zip
[edit - this link is now correct]
-Dave