SLIDE 1
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 - - 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
SLIDE 2
SLIDE 3
One month later….
SLIDE 4
SLIDE 5
Doctors…
SLIDE 6
Started Tracking…
SLIDE 7
SLIDE 8
The internet provided many theories…
SLIDE 9
SLIDE 10
What did I do?
55 “Meh” days Attack 3-6
37%
45 “Terrible” days Attack 7+
31%
From September 2011 to March 2012: Tracked 147 days of meals and aDacks over 7 months
47 “Good” days Attack 0-2
32%
SLIDE 11
Measured Individual Foods using excel formulas
SLIDE 12
Categorized Diet by Broad Categories
SLIDE 13
What is my data telling me?
SLIDE 14
The good, the bad, the ugly
- 10%
- 5%
0% 5% 10% 15% 20% 25%
Bad Day Correla@on
- 25%
- 20%
- 15%
- 10%
- 5%
0% 5% 10% 15% 20% 25%
Good Day Correla@on
- 50%
- 40%
- 30%
- 20%
- 10%
0% 10% 20% 30% Dairy coffee gluten fried foods beer chocolate Good Days Bad Days Good Days Bad Days
SLIDE 15
ASer diet adjustments to reduce dairy (especially cheese)
From April 2012 unWl September 2012: Tracked 94 Days of meals and aDacks
33 “Meh” days Attack 3-6
35%
13 “Terrible” days
14%
48 “Good” days Attack 0-2
51%
SLIDE 16
ADack Severity 2011-2012
7 Day Average ADack Severity ADack Severity = symptom severity*aDack duraWon
A T T A C K S E V E R I T Y
SLIDE 17
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
SLIDE 18
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
SLIDE 19
So am I cured??
Meringue Schaum Torte Birthday Cake Dec 2012
SLIDE 20
Case Reopened in 2013
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
SLIDE 21
2013
7 Day Average ADack Severity ADack Severity = symptom severity*aDack duraWon
SLIDE 22
2013
7 Day Average ADack Severity ADack Severity = symptom severity*aDack duraWon
SLIDE 23
2013
7 Day Average ADack Severity ADack Severity = symptom severity*aDack duraWon
SLIDE 24
+ = ? Why was this such a hard case? + = ? + + = ?
SLIDE 25
Track all the things!
SLIDE 26
What else did I learn?
Excel is great! Fast data entry No more no less than what I needed The data is all MINE!
SLIDE 27
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)
SLIDE 28
Where’s the app for this?
SLIDE 29
www.linkedin.com/in/suelueder facebook.com/suelue