UC Food & Symptom Diary with automated bar chart

I've been using a food diary I designed on an Excel spreadsheet and thought others might find it useful.

When you enter numbers into the BMs section (the left side of the diary) , they will also show as a bar graph at the bottom. I've found using it helps me quickly spot any differences in BMs due to food change.

I've added a few example numbers in Jan - just delete these and add your own.


Below is a link to the UC Food Diary:

www.e-theorytest.co.uk/UC_Food_Diary_template.xls

It's fairly straight forward to use - hope it is of some use to you.

Nice work! I am currently trying to track what foods I can take so this will be very helpful.

No worries - just hope it's useful to some of you.

Given all the catagories, the colour coding is as straight forward as i could make it e.g. red = bad / green = good.

Forgot to say - there are some basic instructions to the right of the bar graph.

Also, I know it could be improved a lot, so if anyone has any ideas, let me know or change it yourself and add a link so we can use your improved version.

Thanks.