GB "Report Generator" Tool

2twisty · #1 10-22-2012, 01:45 PM

I have created an Excel Application that takes exported GB log data (as CSV) from the web site and formats it into a report that most doctors want to see.

I wrote this in Excel 2010, but it should work just fine in Excel 2007.

TO USE:

Export ALL LOGS from the GB web site to a CSV file.

Load the XLSM file. You will need to enable Macros for this to work.

Follow the steps on the "Main" sheet.

When you click on the "Generate Report" button, you may receive a warning about duplicate data on a given date. This is usually caused by a data entry error in your log data. Examine the Event Log to see where the conflicts are and then return to the GB web site and review the data for that event, and correct it. Then re-export and start fresh.

This report does not include any information about SNACKS. I am still trying to figure out the best logic for that, so there will likely be upgrades over time.

This is being released under the GNU Public License. Please see the file COPYING.RTF in the Zip file for license details. The simple version is: This program is free; if you modify it, you must also include the source code for the modifications. This way, the program will ALWAYS be free.

As I release new versions, you can see the change log at the end of this thread, but I will update this post with a link to the most recent version. There is also a copy of the change log in the README.RTF file included in the Zip. Make sure you follow the instructions for installing the additional fonts if you are using Excel 2007.

Newest Version:

GlucoseBuddy Diabetes Tracking Report Generator v1.2

Old Versions:

GlucoseBuddy Diabetes Tracking Report Generator v1.1

2Twisty's GlucoseBuddy Diabetic Tracking Log Report Generator v1.0

2twisty · #2 10-22-2012, 01:46 PM

Also, this assumes that you take long-acting insulin once a day at bedtime, but it will display the TIME of the injection whenever it occurs. It's just that it will be in the "bedtime" heading.

2twisty · #3 10-22-2012, 01:50 PM

Lol. Looks like I found a bug. I'll repost it when it's fixed.

dano · #4 10-22-2012, 01:54 PM

Let us know how it works out and if it is available.

2twisty · #5 10-22-2012, 02:22 PM

Oh, I'll get it working. I need it to work right so my doctor can get my data! Might be tomorrow though since I have class tonight.

dano · #6 10-22-2012, 02:26 PM

Cool! Good luck!

jazzsushi · #7 12-10-2012, 07:13 PM

Great work!! I stopped using Glucose Buddy a few years back because I didn't like how it ouputted data for my physician. I'm back now since my doctor asked my to write my bg's on paper (NOT!!). Looks like Glucose Buddy's interface has improved and it looks like I'm excited that more people are caring about the DISPLAY aspect to glucose monitoring. It is so important and if your doctors can't make sense of your #'s....you might as well stop going. I will be using your Excel add-on "patch" to generate my output. Keep up the good work.

donnavon · #8 01-31-2013, 09:42 PM

when I click the import glucose buddy data button I get an error

Runtime error '3021'
Either the BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record

am I doing something wrong? macros are allowed

dano · #9 02-01-2013, 06:26 PM

Quote:

Originally Posted by donnavon

when I click the import glucose buddy data button I get an error

Runtime error '3021'
Either the BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record

am I doing something wrong? macros are allowed

When you downloaded the CSV file, did you put it in a directory where you could find it easily? When you click on the import glucose buddy file, you have to manually find the CSV file. I don't know much about the error codes; so if this information doesn't help, you can try emailing Chad, his email address is at the top of the ReadMe.rtf file inside the zip file packet.

tlsg · #10 02-06-2013, 01:17 AM

Quote:

Originally Posted by donnavon

when I click the import glucose buddy data button I get an error

Runtime error '3021'
Either the BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record

am I doing something wrong? macros are allowed

I'm getting the same error. I emailed him as well. I'll post when I get an answer. Please do the same. Thanks.