OK, so I have these pretty awfully designed charts which I fax in to my Diabetes Educator once a week or so to go over my numbers. We are still making minor tweaks to my basal rates (on a minimed 722), but am almost there by now (started in February on the pump)…
Throughout this time, I have been looking for a better way, but this has been my system: I have been keeping track of my meals by hand on the charts I fax in, and then once a week write in the glucose numbers, basal rates, bolus wizard details, activity, etc. after collecting all of this info from the data uploaded from my pump to the carelink site, and off of the meter. Now, I am keeping track of the food, activity data using the glucose buddy app on my ipod touch, and transcribe it from there onto the charts once a week. I know there must be a way to consolidate this info without writing everything out every time, via a spreadsheet or database or something, but have not managed to do it in such a way that I can manipulate it as a close approximation of the forms I fax in - I have much more experience with databases, particularly filemaker pro on mac, then with spreadsheets - on a simple level, i do not seem to be able to import any of this info (via .csv file or other) into the existing spreadsheets i have found out there…
Does anyone have any advice on the nitty gritty of importing the csv info exported from the carelink site into a useable spreadsheet? Whenever I go back to this, I spend hours fiddling with trying to configure a database or playing with open office calc, with little to show for it, so I go back to paper after all. A link to a pdf of the current form can be seen here,
http://longesturinal.com/diabetes/halletMay17PRIVATE.pdf
Any thoughts? I know as soon a I work it out, I will no longer be needing to fax in the numbers every week, so am particularly determined on the final stretch…