02-25-2005, 03:03 PM #1
My little diet helping spreadsheet, for you.
****Ok, i cannot attach the file because it is not a picture. If you would like it you can pm me an email address and ill send it, or if someone would like to host it, that would be cool too ^_^***
If anyone is like my and suffers from laziness when it comes to keeping track of food intake, this may help out. It is a little excell spread sheet that should make keeping track of your dieting easier. You can download some online but in my opinion they are all just...wierd. I just slapped this thing together and here is what it does....
Well, simply what it does is reduces keeping track of everything you eat and its nutritional value to a few cut and paste manuevers. Im sure when you see it it is obvious how to use it and what is does, but if you want the gory deatails read on.
Three pages...on one page you have a list of foods you eat, i left the foods i eat in the file so things like Oatmeal, chicken breasts, turkey breasts and sirloin steak is all in there...when you eat something not on the list just add it, along with the serving size and calories fat carb and protien per serving size. It looks like this, but in a neat table.
Eggs w/yolk 1 Egg 70 5 0 5
Eggs -Yolk 1 Egg 20 0 0 5
The second page is where you track what you actually ate during the day. And this is where the funcionalitly that makes the spreadsheet a time saver is. Formulas built into the chart will add up the values for each meal and also for the enitre day. Under "Meal 1" for instance, you would copy the serving info for a whole egg and an egg white...and then in the box labeled "X-multipier" put how many you had, so 4 next to egg whites and 2 next to whole eggs, for instance. it will multiply the serving info by that factor. Then it will display the total meals info under the meal, and also as you fill in meals 2,3 etc is you add up the grand total for the day, broken into total cal, fat carb and pro.
Finaly on the last page you can copy the values for the day into a chart that keeps track of the total calories deficiency (or surplus) you can enter your BMR into the page, and also the calories burned by cardio to see where you stand relative to your bmr.
Well this took longer to type than the spreadsheet did to make ><
PS. i made it using Open Office, Sun Microsystems totaly free response to Windows Office. I know Open office will open Windows Office files, but in not 100% sure of the reverse. In any case, if you use Excell and this doesnt work, Download Open Office from SunMicrosystems and you will not be disapointed.
02-27-2005, 01:45 PM #2
nice bro, thanks, could you pm it to me?
02-27-2005, 02:00 PM #3
I'd like to check it out also...
02-27-2005, 02:58 PM #4
My gmail account is giveing me greif atm, Ill email it later today or tommorow guys. And I cant PM it, so please send an email addy if you havnt yet ^_^
08-19-2005, 04:44 AM #52/3 Deca 1/3 Test
- Join Date
- Apr 2005
can u pm it to me?
08-19-2005, 10:16 AM #6
can u pm me to
08-19-2005, 10:39 AM #7
08-19-2005, 10:48 AM #8
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)