What were you doing on July 27, 2013 or December 18, 2008? What was your heart rate? What did you eat? How did you feel? These are questions I'm answering using my Quantified Self dashboards: a series of dashboards covering finances, exercise, health, psychology and other things to keep track of me. A helpful way to notice trends in behaviour and to work on the machine that is me. I'm hoping to move all of this data into mongoDB or mySQL to make this into an app, but for now Excel serves as the project's data store.
Some visual coding done on Android using the Automate app, which allows you to create apps that respond to inputs on your phone. The applet I created below runs a daily review at a set time and collects all the information shown below and weather and air quality (both from APIs). This information is stored in a CSV and then sucked into the one of the dashboards mentioned in the Quantified Self section of the projects page.
Over the past 15 years I've been keeping managing my finances using various methods. In the last three years I switched to using Excel as one of my projects to do this, because an app I liked had stopped being maintained. I created a spreadsheet that records daily transactions, tracks investments, manages debt and has an asset register. All of this is summarised neatly in the dashboard. This gives me information to help manage my finances; right down to niche data like how much I'm paying for fruits and vegetables per kilogram for any period.
This website (and the other web apps I run) has existed in different forms for over a decade. The latest reformat happened in 2020 and involved more custom development: from a custom must-use plugin to deep customisation of WordPress, Woocommerce and Elementor. These projects are ongoing and I hope to keep this skin for at least a couple of years.