Full Night Scout Rig
Full Night Scout Rig and online Mongo database through azure site
So I got the new phone (samsung galaxy 3)… and it worked. So excited. Like I said before, I won’t necessarily be using this all the time, but it was cool to see how it worked — and if I were a parent rather than the type 1, I’m sure I would be more keen to use it everyday. The next project I’m looking at is the xdrip (formerly DexDrip) that was — you can find an intro here. The xDrip is a project put together by Stephen Black () that is so cool — find the git info here — basically taking NightScout and getting rid of the cable, Dexcom G4 to android without dexcom share — and then on top of that there is NightWatch that takes the information from xDrip, NightScout, or DexShare, and transmits to an android wear device.
I know that I will have this Dex-to-wrist capability once I get my new DexShare receiver and Apple Watch (both pending arrival), but until they arrive, and also because I think it will be fun to see how it works, I will be starting on this project.
I fell like I have just opened my eyes to trying to live a better life instead of just knowing there is a way and being stuck in fear that nothing will work and I’ll still be stuck where I am… if I don’t try I’ll still be here anyway, at least if I do try I get to keep working on really cool projects… next up, wireless xDrip bridge…
my numbers have been shit, I know this, also I was traveling which rained crap all over my routine… nevertheless I am determined to keep the travel in my routine, so I’m adjusting my diabetes around my life and not the other way around. That being said… my numbers really were shit and I did really say “fuck it” a couple times… I mean I was 300+ or under 70 pretty much the whole time I was in NYC, in Denver I mistook a sugar drop as altitude adjustment and very nearly passed out (40)… there were some learning opportunities… on the whole it was an amazing trip, a testament to the fact that I can be away if and when I need to be… that it’s okay to ask for help, and there are creative solutions for when living on my own is sub-optimal, other than hiring a nanny for myself… go me! But really my numbers are shit, so I’m getting back on that now… back to paleo light… and “remember to eat” alarms, if that’s what it takes, then there it is… today is a positive day, there was a lot of swearing about this yesterday, my lap time to sanity is getting shorter — big improvement, xo
meh, not so much…. Mystery and Danger of Type 1 Diabetes, an NYT article found here
so far as I understand the article it breaks down to
stress > destabilization of immune system > Type 1 diabetes
while I agree with the premise, it’s basically republishing of really simple information — Type 1 is an autoimmune disease, it is different than Type 2 and it’s annoying to have to explain the difference to everyone who’s grandmother/uncle/sister had diabetes and was able to get rid of it by working out more, or still has it because they exist off of mountain dew and cheetos… no, I’m not bitter or angry and all… working through it… anyway, while nice for Type 1 and the difference between Type 1 and Type 2 to get some press, it’s not exactly ground breaking, or all that interesting if you have a basic understanding of autoimmune disorders.
so here’s the deal… I feel better when I do the shit that I know I should be doing (go figure)… get enough sleep, wake up at the same time, eat at the same times and on a regular schedule… walk in the am… and like magic my body needs less insulin, I feel better… and then I stop jacking up on caffeine and my anxiety totally levels out… I know it’s rocket science-y level shit. But here’s the thing, sometimes I still don’t do this stuff… I’m getting better. I’ve started a nutrition program through a friend and my sugars have become stable… like stupid ridiculous stable. I’ve upped my protein level, taken gluten out (again)… and I feel so much better, it’s like everything in my body is moving again. I’ve been walking in the morning too… that has made a big difference in the rest of my day, both with my sugars and with my mood, outlook… a lot of the time I walk down to the beach, I am always insight of the water, something to be grateful for — so many things to be grateful for… like being in a grateful mood right now, so next time I’m in a shit mood I can look back at this and remember that shit moods always end.
Yesterday I had to eat a bed time snack… I resent having to eat at night because it doesn’t match up with my health/fitness goals… but I was a bit low (80), too low to go to sleep without an assured dexcom wakeup 2 hours later… so I ate a rice cake with almond butter… and then another one, and then I ate almond butter out of the jar… because I triggered the hunger monster… and because deep down (sometimes not so deep down at all) I am SUPER resentful at Diabetes. Why should I have to eat when I don’t want to — it sucks. This morning I woke up in the 200s, a carb “hangover” if you will…I had two choices, I could say fuck it, skip breakfast like I prefer to, skip my walk because it’s “inconvenient” today, and sit right down to “work”… or I could do what I know works… go for a walk, down a protein shake, and start over today, at that moment… so that’s what I did… 12-ish hours later I’m back in the 140s and dropping down a bit… still fighting the fishtail effect from being so high… I should test and eat… so I think I will. I’m choosing me, my health, and trying to get out of my own way in the process. Life is good, the guidance is there… now I just have to put one foot in front of the other… xo
The tool I have been using to create the visualizations of my numbers is called Tableau — as I was looking through Tableau Viz of the Day Gallery, I found this great viz on the Prevalence of Diabetes in adults (20-79 yo) by Ramon Martinez. Ramon publishes a blog focused on analyzing health data at the population level — the post accompanying this viz has some additional insight on the data presented.
Creating dashboards to answer questions — my question is how am I doing now, as opposed to then? and I want to be able to change both of those time frames… comparing this week to last year, this week to last week, this month to last month, to the last three months… and so I created this dashboard. Above is just an image, I’ve started using a bit more technical solutions, so I’m going to be posting image files for a bit until I get a better process in place to use the publicly available/postable versions again.
[Data Dork Stuff] I figured out that the export file I was creating was cutting off at 65,536… does that number ring a bell? Yup, that’s right — the export file was .xls and not .xlsx — I can’t believe that I missed that #dorkfail — so this explained why my data was cutting off in December, in order to resolve this issue I had to export the data from the data blending tool into a Tableau Extract rather than and Excel file, since .xlsx isn’t an export option (#softwarefail #upgraderequest). Building visualizations from a Tableau extract requires using Tableau Desktop, rather than Tableau Public — like I said, I’m working on finding a way back onto public with this data, so that the dynamic versions can be shared here… and elsewhere without the need to use the desktop software. [Other tools] Looking at bringing together data from my OmniPod and my Dexcom — I used Diasense to get a sense (womp womp) for what I’m bringing together. I love their idea, and the tool — but I hate the interface. Okay, hate is a strong word (and I did just say I love the tool <3), but I love data, and I know that it can be displayed in a way that not only looks better, but is more conducive to helping diabetics understand their own bodies and support actionable decisions in their/my daily life. Next Steps… OmniPod data…
In other news, I’m really struggling staying on a diabetic diet — I eat breakfast, I snack smart, I get all the way to the evening and then I get a case of the fuck-its, except while still hearing reason in my head… it’s maddening. Hoping look at all this data will help me see what I need to see clearly… and help me to make the right decisions, or at least the right next step.
People ask “How are you doing?” all the time, usually I answer with “fine”… well here’s a more comprehensive and Illustrative answer…
This is my latest take on something that could help me to better understand my diabetes and how to manage it. For right now I’m really just reporting findings, but as I get a better sense as to what I can pull out of my devices, I will switch gears into focusing on insights that I can pull out of the information.
Let me start by saying that I used professional tools to get to this point — I could have stuck to excel, but it would have taken me a lot longer and wouldn’t have been a repeatable process. My goal is to hone this process, so I can get as close to real time as possible — based on the level of effort required, I think that the most practical estimate for this is probably a weekly report, but the process is going to need work to even get to that point.
How did I get here? [the geeky stuff] Dexcom reports out two sets of numbers — the meter values that you input to the receiver (calibrating it), and the reported values that show on the screen every five minutes, these two sets of data are reported separately, but in the same worksheet. To add to this, when I updated the software on my Dexcom receiver it archived my file to date and created a new file, so I have to files one from when I started with the Dexcom to the software update, and then one from the software update to present day. What I needed to do was split and clean two data files, and then add together the corresponding parts, from there, I added an additional field identifying each of the data points as either being a “Meter Value” or a “Dexcom Reading” — which then enabled me to join the two tables back together as a single table with the fields of Time, Blood Glucose, and Type. This is the data set that I pulled into TableauPublic to build the visualization below. There were around 65k records, so we have a good bit of time in TableauPublic before we will have to think about filtering the data set down in anyway.
Looking at the same numbers, but cleaning it up and adding some detail to be able to zoom in on parts of the time frame… let the iterations begin…
A temporary tattoo that would replace finger sticks… Yes. Just Yes. Check this out!
I’ve written about this amidst rants over the past week or so, but I wanted to address it clearly because I feel that it’s worth the time. When I went to the doctor, she took my PDM, and with very little, hurried explanation, she messed with the settings and then handed it back to me and walked out — this is what happened from my perspective, objectively I know that this is probably not exactly what went down. As soon as she took my PDM, something about the way she took it triggered something in me, and I went into a fog, all I knew was that she had something that was mine and she was messing with it, and I couldn’t or didn’t do anything to stop her. I felt exposed, but paralyzed in the chair, like I was observing the scene standing behind my chair, rather than being there myself. I could have spoken up, asked questions, asked for my PDM back, asked to be shown what she was changing or doing, and why — I am usually a proactive patient, coming prepared with questions, participating my own care. This time I was apathetic and shutdown, I was pissed off when she wanted me to come in earlier than usual, irritated to be judged solely on my numbers without being given the chance to explain, or asked if there was anything else going on — just the assumption of non-compliance, I was insulted. I didn’t feel like her assumptions warranted polite reply — instead, I stayed as I was, quiet, still, in my chair. Not asking any questions, no protests, just waiting for her to leave. and she did leave, and then I was just there, wondering what had just happened, what I was supposed to do — she said something about following up with the nurses to make appointments, like hell was I going to do that. A better voice in my head told me that I probably should actually do that, but then, I know what I’m supposed to do in a lot of situations, and that definitely doesn’t mean that it necessarily happens…