I'm searching for a FLOSS tool (for GNU/Linux) for the following job:
I have written a diary for some years. For each day, I noted what I did resp. what happened. Now I want to formalize/record some of these things. In the end, I want to be able to create statistics.
2012-11-23: watched a DVD; jogged; cooked 2 times
2012-11-24: cinema; cooked 1 time
I have only a handful of categories (DVD, cinema, jogging, cooking, …). I want to record a) what and b) how often something happened each day.
DVD Cinema Cooking Jogging … 2012-11-23 1 0 2 1 2012-11-24 0 1 1 0 …
Then I want answers to questions like:
- How many movies did I watch in 2012? (→ count all "DVD" and "Cinema" entries for that year)
- On how many days did I cook in 2011 and 2012? (→ count all days, where I cooked 1 or mor times)
- On which month did I jog the most in the last 3 years?
- Is there a correlation between movies watched and holidays?
- Did I watch more movies on sundays than on other days (on average)?
It would be fantastic if some actions could have attributes. E.g. so that I can mark if I watched a DVD alone or together with friends. Or to mark if I cooked for dinner or for lunch etc. Then I'd ask questions like:
- Did I watch more movies alone or with friends?
- Did I cook lunch more often in the summer or in the winter?
- How often did I cook in 2010, and what is the lunch/dinner ratio? (→ create a bar chart for the cook count and color each bar in red (lunch) and blue (dinner))
My main concern is how to record all the data. It should be easy/fast to do, because it's a huge load of work. The statistics part is only my secondary concern at the moment.
Would OpenOffice/LibreOffice Calc be the right tool? (Can it create a calendar, so that I don't have to enter all dates manually?) Or should I look into R or similar? (have no experience with statistics) Or should I create a SQLite database? (but how to create a form to enter the data?) Or something totally different?