The Case of the Upset Stomach A Mystery only Quantified Self could - PowerPoint PPT Presentation

The Case of the Upset Stomach A Mystery only Quantified Self could solve!

June 2011 Why??? Madrid, Spain

One month later….

Doctors…

Started Tracking…

The internet provided many theories…

What did I do? From September 2011 to March 2012: Tracked 147 days of meals and aDacks over 7 months 47 “Good” days Attack 0-2 55 “Meh” days 32% Attack 3-6 45 “Terrible” days 37% Attack 7+ 31%

Measured Individual Foods using excel formulas

Categorized Diet by Broad Categories

What is my data telling me?

The good, the bad, the ugly Bad Day Correla@on Good Day Correla@on 25% 25% 20% 20% 15% 15% 10% 5% 10% 0% 5% -5% -10% 0% -15% -5% -20% -10% -25% 30% Good 20% Days 10% Bad Days 0% -10% -20% Good -30% Days -40% Bad Days -50% Dairy coffee gluten fried foods beer chocolate

ASer diet adjustments to reduce dairy (especially cheese) From April 2012 unWl September 2012: Tracked 94 Days of meals and aDacks 33 “Meh” days 13 48 “Good” days Attack 3-6 “Terrible” Attack 0-2 35% days 51% 14%

ADack Severity 2011-2012 A T T A C K S E V E R I T Y 7 Day Average ADack Severity ADack Severity = symptom severity*aDack duraWon

ADack Severity 2011-2012 A T T A C K S E V E R I T Y 7 Day Average ADack Severity ADack Severity = symptom severity*aDack duraWon

ADack Severity 2011-2012 A T T A C K S E V E R I T Y 7 Day Average ADack Severity ADack Severity = symptom severity*aDack duraWon

So am I cured?? Meringue Schaum Torte Birthday Cake Dec 2012

Case Reopened in 2013 A T T A C K S E V E R I T 7 Day Average ADack Severity ADack Severity = symptom severity*aDack duraWon Y

2013 7 Day Average ADack Severity ADack Severity = symptom severity*aDack duraWon

2013 7 Day Average ADack Severity ADack Severity = symptom severity*aDack duraWon

2013 7 Day Average ADack Severity ADack Severity = symptom severity*aDack duraWon

Why was this such a hard case? + = ? + + = ? + = ?

Track all the things!

What else did I learn? Excel is great! Fast data entry No more no less than what I needed The data is all MINE!

What else did I learn? Excel is great! Fast data entry No more no less than what I needed The data is all MINE! But I really want to do more advanced correlations, and my formulas are already getting a little crazy! =COUNTIFS(dairycol,"<>",data_merge!$C:$C,">=" & $G$3,data_merge!$C:$C,"<=" & $H$3) =COUNTIFS(dairycol,"<>",data_merge!$AF:$AF,">=" & $B$15,data_merge!$C:$C,">=" & $G$3,data_merge!$C:$C,"<=" & $H$3)

Where’s the app for this?

“Good” days Attack 0-2 100% www.linkedin.com/in/suelueder facebook.com/suelue