Personal statistics app
A daily log of mood, who you saw and what you did — with a month view that makes a bad stretch obvious at a glance.
What it is
A daily log, and then something to look at afterwards.
Each day answers a few questions: a mood from one to five, who you saw (friends, family, a date, an acquaintance, nobody), what you did online (chat, game, call), and what else happened (arguments, crying, illness) — plus hobbies.
What it does with that
- **A month view** where every day is a face coloured by its mood, so a bad stretch is obvious at a glance
- **Statistics** over what was logged, which is the part it was actually built for
The stack
Three tiers, which is the unusual part:
- **Google Sheets** as the database
- **Google Apps Script** as the backend
- **Android, in Java**, as the interface
APIs between them to handle the communication, and the algorithms that compute and update the statistics once the data has landed.