nutrition log – doing it my way (MS excel)

I give up on and, they’re both crap as far as I’m concerned.
I just entered broccoli for lunch on and its coming up with different values for different meals. no deal. So I went back to the Excel sheet I downloaded from some apparent Australian nutrition authority, and made my own Nutrition Calculator in Excel.. This required learning the INDIRECT function in excel, which was a fruitful exercise in MS Excel. It’s pretty handy in that regard.

excel-imageSo this should be fine, looks like it’s working just fine 😀
I’ve checked the function values and yer seems all good.

All I have to do is search for a food in the database, and enter it’s row number into my foods sheet, then add that to any day. The file is here for any use requirements:

My nutrition plan-Excel template

One thought on “nutrition log – doing it my way (MS excel)”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.