PDA

View Full Version : I made a good database for counting daily/monthly nutritional data.



Hoplite11B
02-01-2004, 01:51 PM
Please download it and tell me what you think.

I made this monthly nutrition data table with Excel for a 31 day month since I couldnt find one out there on the net. I have been recording this in notebooks but I think this is a lot easier and i also added a page which totals all the stuff up for the entire month. All you do is input what you ate in the item column and plug in the nutritional data in the boxes next to it. The bottom right box totals everything you entered. and you just click on the dates on the bottom to switch days. The worksheet entitled monthly total adds up whatever is in the totals box on each page.
what i wouldl suggest if you use this is to save this then save it again as the file name for each month. Each month open the original and then immediately save it as the current month. this will save a lot of time so you dont delete everything from each month to make room.

I hope this is useful to whoever downloads it.


monthly nutrition data (http://216.91.19.105/monthlynutritionaldata.xls)

chops
02-01-2004, 01:54 PM
have you tried www.fitday.com ? online diet organizer

Hoplite11B
02-01-2004, 01:58 PM
have you tried www.fitday.com ? online diet organizer
That wouldnt have been as fun as making this one. Looks pretty good though and I can probably add most of that stuff right into excel with time. Once I figure Out MS access I can probably make it a more streamlined database.


Edit: Been fooling around with the web version and its pretty impressive.

harryhoudini66
02-01-2004, 03:45 PM
No excel. Fitday is good though.

Joe Black
02-01-2004, 04:01 PM
I put together a simple excel.

if anyone finds it useful and needs help with it let me know. Its kinda simple though.

http://www.wannabebig.com/mydietatlarge.xls

Joe Black
02-01-2004, 04:01 PM
make sure you click on the daily diet tab..

Hoplite11B
02-01-2004, 04:13 PM
make sure you click on the daily diet tab..
Looks good. You made me realize I need to add a pie chart. I also got some other plans for a revision of mine as Im using it as a working document.

Joe Black
02-02-2004, 06:00 AM
Cool...

I actually quite enjoy working with excel so if you need any help or anyone wants any additions to the excel I posted just shout.

geoffgarcia
02-02-2004, 08:01 AM
dietOrganizer trumps