As I’ve said before, I like working with data. In fact, that’s what I do for a living, and from time to time, that's what I do for fun, too. I’ve tracked gas mileage based on receipts for several years, for fun. I’ve gathered scoresheets from my sons’ hockey games and tallied up points per player at season's end, for fun. Well, as my ordeal unfolded, I found myself needing to keep track of two sets of information on a daily basis: symptoms and protocol.
Recall that Dr Lyme#3 based diagnosis and treatment very heavily on my symptoms. In fact, I had to provide a rather lengthy and detailed history of symptoms before he took me on as a patient. He made it clear that I would need to maintain a log of symptoms - what they were, when they happened, and how intense they were - so that he could evaluate progress and adjust my protocol accordingly. My symptoms would come and go and return again, so I needed to keep track of those symptoms daily in a way that was pretty flexible on entry and easy to review at a glance.
Protocol, the schedule for taking treatments including dosage, was going to be fairly complicated. My treatments included antibiotics, probiotics, vitamins, minerals, anti-inflammatories, sleeping aids, and detoxification and the schedule for taking those treatments would be all over the place. Some treatments would be taken intermittently over a three to four week cycle while other treatments would be taken daily. Fortunately, the protocol would usually be set for several cycles into the future during my appointments with Dr Lyme#3. So, I didn’t need flexibility on daily entry. No, instead I needed to be able to set the protocol up front, then refer to it daily to see what I needed to take.
I first tried to keep track of symptoms and protocol separately. I tracked my symptoms as a document on my iPhone, but it became clear after about two days that that approach was going to be terrible if I kept at it much longer because it wasn’t easy for me to see several days worth of symptoms at a glance. And as for my protocol, Dr Lyme#3 had provided a color-coded document that described treatments over multiple cycles, but I had to perform non-trivial calculations to determine what I needed to take on a given day. So, I pondered options.
I know that there must be apps out there that I could use for keeping track of symptoms and protocol, but I suspected that each would require a bit of fiddling to get symptoms with severity and protocol into the app. Inevitably there would be some sort of glitch on some update down the road, too. Quite frankly, I didn’t want to deal with an app if I didn’t need to, and I had a feeling that there was indeed a better way to record keeping somewhere.
I thought about transforming the color-coded document from Dr Lyme#3 into something else, something that would show protocol very clearly for each day in the cycle. A spreadsheet would work. I set up the treatment with dosage as columns and dates in the cycle as rows, then I greyed out cells where treatment wasn’t called for. That looked better - it was clearer to me what I needed to take each day. After I created the spreadsheet, I realized that I could write my symptoms across the row for the day, too. I could use similar short-hand as I liked to make that happen more easily. And as an added bonus, I could color-code the day for my scheduled labs in the spreadsheet, too! So that's what I did.
Nowadays, I enter my protocol from Dr Lyme#3 using my laptop and Google Sheets available via Google Drive as a single cycle per spreadsheet. I try to get treatments that are on the same schedule listed next to each other in the spreadsheet - it's easier for me to read it that way. I print off the current spreadsheet in landscape to fit on a single page and provide as much room as possible to enter symptoms in each day's row. Thereafter, I enter my symptoms in pen daily into the printed off spreadsheet. I hold onto the completed spreadsheets and I usually provide copies at my subsequent appointment with Dr Lyme#3. I should scan the completed spreadsheets, just in case the originals become lost, but I just haven’t gotten around to doing that, yet.
I have found this approach to be a low cost and relatively low effort way to keep track of very important information regarding my symptoms and protocol and I have made available a sample spreadsheet for you to review, download and use, however you like. Please let me know if you recommend another approach.
