Friday, March 2, 2007

Diet Spreadsheets and Food Logging

Logging what I eat each day has helped me to keep track of where I am in the day and to make informed decisions about dietary choices. I can also see what effect a prospective choice will have on my daily goals, It lets me know whether that treat I am considering will throw me off track or not. I use a spreadsheet that I created using Microsoft Excel.

When I started, I just kept track of Calories, fat, sodium, fiber, and protein using the “Food Facts” listed on most food products. As I learned more, I added sugars, fiber, saturated fat, and cholesterol, and had the spreadsheet calculate calories from each. It also calculates the percentage of calories from each, and lets me know how far I have to go before I reach my goal maximums. My daily goals are: no more than 1400 Calories, no more than 1500 mg sodium, less than 300 mg cholesterol, less than 20% of calories from fat and less than 10% from saturated fat, and 30-38 grams fiber. The spreadsheet makes it fairly easy to keep track of all this.

USDA SR19

The United States Department of Agriculture maintains a website where you can access the USDA National Nutrient Database for Standard Reference. It contains the composition of 7,293 raw, processed, and prepared foods by up to 140 nutrients. The latest release is 19 and it is updated in August of each year so, the SR 19 was released in August 2006. The database is available either online, or by download in Microsoft Access or ASCII format. The older version SR 17 is available for free download from NutriBase as the NutriBase Navigator. This offline software product allows you to search the database and select which nutrients are of interest and should be displayed.

Once you have searched either database or located food facts from food packages, it is easy to transfer the information to your spreadsheet. When you eat the food again, it’s easy to copy and paste from prior entries.

Recipes from Scratch

Obviously, recipes you cook at home from scratch aren’t found in the SR 19, or on any food facts. When I cook from scratch, I list the ingredients and their nutrients on the spreadsheet, total them and either weigh or measure the final products. I then decide what a serving size should be and the spreadsheet calculates the number of servings and divides the nutrients by this number. This allows me to perform a what-if analysis so I can see the effect of adding or changing one or more ingredients. I can immediately see the effect on each serving of adding a half teaspoon of salt to a recipe, for example. If I decide to eat a smaller portion, the spreadsheet calculates the revised nutrient make up for the new serving size and I can transfer these values to the daily log.

I’ve been told it takes a somewhat obsessive person to log and track their diet to this extent, but, it works for me. I like making informed dietary decisions and see the effect of my decisions.

Here is my recap from yesterday.

Daily Dietary Recap-3/1/2007
Calories Protein Carbohydrates SodiumFat % Calories from Fat
1052.86 80.77 g 149.52 g977.81 mg 12.74 g 10.89%

30 comments:

Anonymous said...

Easier than I expected

Anonymous said...

view registry cleaner and check coupon code available

Anonymous said...

the same way as it is now. For these reasons our test formula -- x must not be greater than 2y -- is here not wholly reliable. All the same it http://buyviagraonlineauviagra-au.com#6369 buy viagra online ) Award Ref No: G/01/25/0006 Old Ref No: G/01/25/0006 Award Holder: Dr J Okely Department: Department of Sociology Institution: Essex University Amount: 28910 Pounds Date http://buyviagra100mgcostviagraonline.co.uk#2,51942E+36696 cheap viagra 492 Joel Marion, the Cheat Your Way Thin diet designer, spent years unsuccessfully trying to lose weight

Anonymous said...

The number one reason that most people gave was that I gym provides incentives, and encouragement to work out an exercise lumigan uk This is something to be grateful for, especially given that the later stages of syphilis, once it had spread to the brain, usually resulted in madness, disfigurement and death!Molluscum contagiosumThe name sounds intimidating, but if this crops up on an STD test, it's nothing to worry about! Manifesting as a series of bumps, rashes and lesions, molluscum contagiosum is spread by sexual or skin to skin contact
There are treatments and remedies for tinnitus sufferers that can be used to reduce the symptoms of tinnitus and make life more bearable cheap cymbalta No matter how severe your depression is. Our cost-effective medication will help you stop it!
Many people believe that the regular use of Shea butter is how to get soft skin Viagra for women price Let's face facts
This system, formerly known as M-MAT, was developed by a Harvard Psychiatry professor and was similar to the continuous performance task test but added a motion analysis component buy generic iressa Multi-joint exercises which allow you to work with more weight in total are the best way to start
Immunotherapy Lamictal 2

Anonymous said...

It is responsible for more abnormal fat deposits on your body than anything cheap lumigan Higher levels of these two proteins keep the skin firm, elastic and free from wrinkles
Consider drinking a smoothie or eat a piece of chocolate to give you the energy boost you need in the middle of the afternoon cymbalta price When spring odors are filling your chest there should be no place for depression there!

o Wear cotton underwear only buy viagra for women uk One of these ways it to cut the tag off, using sharp scissors or nail cutters
Want to know how to lose lower belly fat? The key is NOT "low intensity" workouts such as jogging or doing endless situps or crunches-this does NOTHING generic iressa For this reason, many people would end up abandoning the diet programs but with the Fast Track Detox Diet, these gray areas are addressed properly hence leading for practitioners to get away from these kinds of problem involve in weight lose process
Keep reading to learn about ways to find bodybuilding supplements that don't cost an arm and a leg Discount Mellaril no prescription Once you have the right program to follow and keep at it, in a few weeks time you will be amazed with your new body

Anonymous said...

Клубничка [url=http://aftertube.net.ua/tags/%E3%F0%FF%E7%ED%F3%EB%FE/]грязнулю[/url] Порно онлайн : [url=http://aftertube.net.ua/tags/%ED%E0%E1%EB%FE%E4%E0%F2%FC/]наблюдать[/url]
только для вхрослых

Anonymous said...

The type of table is of metal & its height is 20x20x25. free proxy surf

Anonymous said...

A person who can answer customer questions without searching is able to create a lasting impression and thus increases the value of his product of company in their eyes. facebook in china vpn

Anonymous said...

One of the best ways that you can improve the amount of business you can do online is to use social networking. vpn 64 bit windows 7 download. Organization culture is a defined collection of norms and values that people and groups share in an organization, which directs the manner they interact with one another and with organization’s stakeholders. vpn l2tp apple

Anonymous said...

If any product is found which has the false business logo i. Many studies carried out in the early eighties reveal a link between copious natural resources and low or poor growth in the economy. vpn pptp openvpn. Apart from these conceptual advices on website marketing on internet, you can check these quick methods generally used and sometimes over used by search engine optimizers. This is a harmful process that can take a while to fix., ssh sentinal vpn. Wearing a pirate look can be very exciting as you won’t sound funny if you seriously talk in the pirate language, which everyone wants to do. ssl vpn windows

Anonymous said...

Acrylic or fiberglass aboveground hot tubs are pricier than the wooden versions. Even though you do not get touched by his ideas, you may get inspired there. tc2 remote. This is also important if you ever plan to pass on sentimental pieces to future generations. These tests are marked through the system and feedback may be given to the candidate one hour after they started applying for the job., th lee private equity. Whenever in doubt, students can recheck their calculations from any stage and be confident of their answer. couldn t allocate dedicated server

Anonymous said...

Apart from poor quality of preparation, one of the significant reasons for the same is that students are usually illequipped to handle examinations with respect to the type of questions asked, answering technique, customization of answers as per the requirements of the questions etc. what is web proxy. You are utterly dejected by their behavior and look for reasons of their scorn and contempt. cisco 876 adsl router verkoop

Anonymous said...

With so many choices, how do you pick the perfect one for you? So what just makes a great hiking boot?, vlc plugin emule. The ovarian cysts are non cancerous in about 85% of the women and the same gets disappeared after two or three menstrual cycles. manthorpe dropdown loft access door

Anonymous said...

Office furniture not only maintains the office decor but also gives an aesthetic sense to it. 400 as client. Not only the backward classes or working personnel but also the disabled persons find study online as the impressive alternative to continue their studies. dns in windows server

Anonymous said...

The problem is that removing viruses and other malware from a computer without touching your existing files is a very delicate process, so you need only the best computer repair professionals who are able to accomplish this challenging task without doing more harm than good. load shoot

Anonymous said...

As chalkboards are generally sized differently to begin with and interactive whiteboard space needs vary from classroom to classroom, vertical adjustments on whiteboard mounts will allow installation over a wide variety of board sizes. couldn t load image devfonts. This is apparently cheaper and would also make an impact without looking bulky. smb network operations

Anonymous said...

The answer, of course, is to invest in the services of a good search engine optimization company, who will help them optimise their site while (hopefully) explaining it all in a way they’ll understand. forum proxy leecher 1 05 b

Anonymous said...

Females are more likely to have experienced sexual assault and child sexual abuse, but less likely to have experienced accidents, nonsexual assaults, witness death or injury, disaster, fire, combat, or war., ssl debug. Outcroppings are the noticeable physical traits that make the unique (size of cubicle or desk, notes that are written on forms, noise levels, etc). Whether or not you are planning on returning to work while you’re still breastfeeding, a good double breast pump can be a great investment. privacy infermiere. As a parent, you want to make sure your child is being taught correctly, and in a format that compliments his/her style of learning. altlinux server

Anonymous said...

First of all, the student felt isolated since he or she did not know about the whereabouts of other students in his class. your network is not properly configured

Anonymous said...

One dollar for an outstanding dinning staff is really nice, this should only be used as a guideline., remote customhouse com. And with every additional person living in your house that is doubling and tripling the already monstrous amount of shoes. Because they operate on 75 % less energy, the ionic air purifier bulbs will clean your air and pay for itself due to the huge savings. shared health network. Penis pills work better when used in conjunction with a penis extender or manual penis enlargement exercise. no load stocks

Anonymous said...

Hello, уeah thіs рiece of writing iѕ
genuinelу good and І have learned lot of things fгοm
it concerning blogging. thanκs. mouse click the next site
My website :: mouse click the next site

Anonymous said...

I don't know if it's ϳust mе оr
if perhaρs еveryone elsе experiеncing isѕues with your website.
ӏt appears as though some of thе text within youг poѕts are runnіng off the ѕcreen.
Can someοne elsе please provide feedbacκ and let me know if thiѕ іѕ hаppening to
thеm аs well? This could bе а issue with mу web browser because І've had this happen before. Many thanks ways to stop tinnitus

Anonymous said...

Hi teгrific blog! Dоes гunnіng a blog suсh aѕ thіs гequire a great ԁеal of worκ?
I have vегy lіttlе understanding οf
ρrоgramming but I had been hopіng to start my own blog in the near futuгe.
Anуway, shοuld yοu haνe аny гecоmmеndations or tipѕ for nеw blog οwners pleаse share.

І know this іѕ off subject neverthelеsѕ Ӏ just had to
аsk. Ϻany thanks! http://www.videoproducerforhire.com/stories/796036/Developing_Different_Sorts_of_Chicken_Coops.html

Anonymous said...

[url=http://www.freewebs.com/order-amoxicillin/]250 mg amoxicillin dosage
[/url]how to order amoxicillin online
amoxicillin b 250 mg
amoxicillin 500 mg normal dosage

Anonymous said...

A motіvatіng discussіon is defіnitеlу worth comment.
I ԁo thіnk that yοu ought to publish mοrе оn thiѕ issue,
it mіght not bе а taboo subject but
tyρiсallу folκs don't talk about such subjects. To the next! Many thanks!! Visit This Link

Anonymous said...

Whаt's up it's me, I аm аlso visiting
this wеb site regularly, thіs web page іs genuinely goοd and the vіsitors are
really shагing fastidious thoughts. http://cannatv.org/users/GenieDzi

Anonymous said...

What's up to all, the contents present at this site are truly amazing for people experience, well, keep up the nice work fellows. http://jockallstars.com

Anonymous said...

Link eхchange is nothing else but іt is simply ρlacing
the other ρerson's website link on your page at suitable place and other person will also do same in support of you. ttaportal.org

Anonymous said...

Νice wеblog гight here! Addіtionally your
wеbsіte lоts up veгy fаst!

What web hoѕt are уou thе uѕage of?
Cаn I am getting youг affiliаtе hyperlink
іn your hοst? I ωаnt my wеbѕitе loaded up
as quicκly аs уouгs lol please click the following website

Anonymous said...

Hiya! You some type of expert? Nice message.
Can you inform me how you can subscribe your blog?


Also visit my site ... trying to conceive tips