As part of my project to correlate exercise and insulin usage in type 1 diabetes I need to get hold of my blood glucose and insulin usage data. I use an insulin pump with an embedded continuous glucose monitoring (CGM) sensor. Periodically I upload all the data from the pump to Diasend. Diasend is quite a nice site – it allows me to upload all my diabetes data and share it with my clinician at Guys Hospital. I can extract all sorts of reports from the site too, making it possible to review my glucose levels and insulin usage.
You can download all data as an Excel file, but for further processing it would be most convenient in CSV format. So I used Apache POI to write a Java utility to turn the Excel documents into CSV files. I’ll upload the code to GITHub later. Apparently Diasend are bringing out API access later this year – this will make data access a bit more straightforward.
Combined with the heart rate data, I now have everything I need to start looking for correlations between exercise and insulin usage/blood glucose levels. More soon!
[…] file was processed into CSV files containing the insulin data. Details of this process are provided elsewhere. The total basal insulin dose was […]