Love this excel sheet, however, I need to clean up the results after i import data as I do not currently track carb intake with GB nor do I take fast acting insulin. I typically hide the columns I do not want and copy/paste into a new workbook to get around the clutter. When I do this, however, all the dates export as 2009 instead of 2013 as stated after the import. Also, if I try to only export the last 7 days of data, the sheet tells me there is no data in that range. I have to export 30 days and copy/paste just what I need.
As for it wanting me to track meals and short-acting insulin, I have figured out to add a "dummy" entry for each of the log types for a date far in the past and label it "N/A". A single entry with a value of 1 does the trick without messing with actual log data now
.
As a suggestion, I would take the data being imported (specifically dates) and import them as excel based date values (the 5 digit number behind a formatted date in excel) this way if the data is copy/pasted, a simple date format will propery translate the dates.
Are there any plans for further updates to this workbook. It is awesome for all my healthcare professionals to see how I am doing with my readings.