Tag Archives: excel
The days I use my time wisely are the days when I feel most fuliflled and therefore happy.
Ian Billett stumbled upon our Quantified Self website here and instantly became fascinated by our community of individuals who were learning about themselves through different technology. With his interest piqued, he began to investigate how he could understand himself. He started with a self-designed Excel spreadsheet where he manually tracked every five minutes using his own tagging system. He’s since switched to even more fine-grained tracking, tagging every minute of his life to describe what he was doing and who he was with. In this talk, presented at the London QS meetup group, Ian describes his process and some of his recent findings.
Slides are also available here.
Special thank you to Ken Snyder for his valuable work documenting the talks at QS London.
Sue Lueder had a mystery stomach ailment that started after a vacation to Spain in 2011. When she returned from her trip she was beset by consistent and frequent burping attacks. After visiting her physician and receiving a diagnosis for heart burn, which she didn’t trust. she began to track her attacks and her diet. In this talk, presented at our 2013 Global Conference, Sue how she tracked he symptoms and used the data to make sense of this mystery food allergy.
What Did She Do?
Sue tracked her diet and the frequency and severity of her attacks.
How Did She Do It?
Sue was able to explore the data she was entering in to her self-designed spreadsheet tracking system. She used a few of the analytical tools and visualizations built into Excel to explore her data.
What Did She Learn?
Her analysis was able to pinpoint that dairy was probably the main culprit responsible for her attacks. Sue found out that she was able to improve her “good” days from 32% to 51% of the days she was tracking when she reduce dairy in her diet. When she experimented with adding dairy her findings were confirmed.