It’s been quite awhile since I posted a chart.
I actually gave up keeping track for a couple of months at the beginning of the year. When I started, it never crossed my mind that I’d still be using them after 12 months. I just assumed I’d better by then, or at least so far along that I’d no longer need them. Didn’t turn out that way.
When I started the charts, I created them in Adobe Illustrator. It’s a graphic design program that I’m very familiar with from my day job as a Creative Director. They were relatively easy to update, but they still took a lot of time to manage and version out each month. I decided that after December 2008 it was just too much to keep up so I dropped them. However, after three months, I decided to pick ‘em up again, but with the goal of making them easier to manage even if that meant making them less pretty.
I started experimenting with organizing my data in Microsoft Excel. This is what I’ve ended up with.
I track a series of 10 different condition categories and within each category there are several symptoms — 33 as of right now. I based the categories and symptoms loosely on a questionnaire that my old LLMD gave. I rate each symptom every day on a scale of 0-10 everyday. I don’t really have a specific rating system for the scale (which I know skews the data), but, generally speaking, zero means it’s non-existent and 10 is severe enough to keep me in bed for the day. Luckily, I rarely get symptoms over seven. Generally, things seems to hover between four to six.
The beauty of Excel is that once I get the numbers in for each day, I can then cut it up any way I like. I have it set up to produce 14 different charts for me off of one table of data. If I was more adept at Excel I’d probably have more, but my knowledge of the application only goes so far. You can write complex formulas to run tasks for you automatically, but my scripting ability is poor.
Here are the different charts
1: Month to Month Comparison
This looks at averages across the categories and plots the results so that I can (hopefully) see a trends over months. As you can see, I’ve actually been using this format for four months now. Unfortunately, the trend seems to be going up instead of down. This is due in some part to a reshuffling of symptoms within the categories. I also swapped out some symptoms from my LLMD’s questionnaire that I’ve never had. With less numbers for the chart to average, some of the overall values went up.
2: Daily Symptoms
This is the chart I add my numbers into daily. It might look overwhelming, but the whole process of opening the file, adding in the data and closing it takes roughly three minutes. Sometimes I also just write them down and then enter them into the document a few days at a time. Pretty simple.
3: Daily Treatments & 4: Daily Exercise
The Daily Treatment chart has turned out to be a pretty valuable one. I use it to keep track if how well I follow my med and supplement regimen. A “Y” is for “yes” I took it that day, a “N” is for “no” I didn’t and and “S” is for I took “some” of it — basically I took it in the morning and not in the evening (or vice versa). As you can see from this chart, I haven’t been doing a very good job. A lot of the “N”s in July are because I took a break because I was herxing my ass off, and then later because my new LLMD told me to stop some meds and supps.
Daily Exercise is my favorite chart. Unfortunately, you can see that in July I was off running for a couple of weeks. I tweaked my Achilles Tendon in my left foot so I’ve been resting it and not running. You can see that I switched to the bike and have been putting in a lot miles there — though not as many as I’d like to.
I also keep track of my resting heart rate. This is something I’ll discuss in an upcoming post. It’s not as low as it use top be, but it’s still very healthy.
5: Daily Averages — Symptom Category
This is essentially the table in the second chart represented in a picture. It takes an average of each symptom category everyday and plots it in this line graph. Looking at it this way makes it easier to see trends and the over all experience I had that month.
6-15: Daily Totals — Symptom
The remaining 10 charts plot the daily results from each symptom and are organized by category.
Analyzing the results
A pretty shit month, July was. I write the overall upward trend of the month to two things. (1) stress and (2) going off my meds.
The stress comes from work and home life. I picked up a ton of freelance work in July and I’ve had a pretty tough time staying on top of it all. I had to pull a couple of late nights to meet deadlines and be really creative about how I scheduled things. Even if I had been perfectly healthy I would have had a hard time with all this, but being foggy and having trouble concentrating multiplied by the fact that I’m sometimes in a world of self-doubt about whether I can meet what’s expected of me really increases the challenge.
The home front has been a challenge too. My wife’s picked up a ton of work as well. This is all good for us as our bank account was starting to really spiral downwards, but it’s also tough on us as we deal with stress in almost the opposite manner. I get calm and she get’s frenetic and we become like magnets with matched polarities.
Our 4.5 year old daughter is also out of school and, because our schedules are so varied and crazy, she’s not in a camp or regular day-care set up. Every week we have to try and figure out what we’re doing to entertain her and who’s taking there, picking her up, watching her after wards etc. It’s insanely stressful on me and it makes it tough to manage my work, trying to be well and my over all energy level.
Hopefully, August will be better.
