GB "Report Generator" Tool
 

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

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.

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

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

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.

Cool! Good luck! ;)

OK. I've got it fixed (I think).

I've reattached it to the first message in this thread.

NOTE: I don't have much (if any) error trapping, so if your data is screwy or something, the app may abort. I'm still working on error correction and conflict resolution, as well as support for SNACKS and OTHER meals.

I plan to eventually add support for Activity, Weight and BP as well, and possibly some graphing capabilities.

The generation of the report is rather slow because of the routine I am using to format the cells. I plan to rewrite it to make it faster.

For now, please try it out and let me know what you think, as well as any suggestions you have.

I was able to play with your spreadsheet a little today. You are on the right track, but there are several things that it did not do for me. I take a split basal in the morning and at bedtime. The output did not show any of my carb values at meals. The A1c data was also incorrect. My testing may be much more in-depth than yours, you are welcome to the input files for bug testing if you like, just PM me your email address and I will send them to you.

PM Sent.

I can't squeeze any more information on an 8.5x11 sheet of paper. Perhaps I'll move it up to Legal. I'd like to figure out a way to get "snack" and "other" in there, as well as a way to include any notes that the user enters, since it may be important.

I'll look into why your values aren't showing up. It's probably some stupid bug, lol.

Before it populated the information, there was considerable error checking going on. :D

OK, everyone!

I plan to release version 1.1 tomorrow (Oct 26). I am in the final testing phase.

I'm waiting to hear from my beta testers to see that it's working properly. I hope you guys can make use of this! I've probably got 40 hours in it already!

2twisty;

Thanks for your time and trouble! :)

I am sure that many GB users will find that this "Report Generator" will make creating the "Doctors Report" a snap. :D

GlucoseBuddy Diabetes Tracking Report Generator v1.1
 

GlucoseBuddy Diabetes Tracking Report Generator v1.1 is ready for release!

GlucoseBuddy Diabetes Tracking Report Generator v1.1

I plan to make some changes in the next version (1.2) that should return the report back to being printed on letter sized paper. This should also improve compatibility with the UK users that print on A4. So bear with the Legal sized printout for a little bit and I'll get it back to a more compatible state.


1.1 (10/26/2012) Change log
-----------------------------

bug (fixed): Does not clear all data fields from report, which can lead to improper data in the report
bug (fixed): Does not display all header rows on new pages


added: Allow for split doses of long-acting insulin.
added: add columns to "Fasting" to allow additional data
added: Allow for fast insulin during "Fasting" and "BedTime"
added: Add columns to support "During Night" readings
added: Widen report from 11" to 14" and include overnight and after bed data, adjust font sizes as needed
added: add support for long-acting insulin in the morning
added: add verboseErrors variable so that conflicts and other non-critical errors can be suppressed.

changed: Change title from “Diabetic” to “Diabetes Tracking;” some people find the word Diabetic to be offensive.
changed: import additional data for new columns, and add to the report generation routine
changed: include AgencyFB font files and instructions for installation
changed: Make required user input more obvious - prevent clicking of the generate report button until requirements are met.
changed: Change headers to use the actual names of the long and short acting insulins for better clarity
changed: speed up report formatting steps to improve performance

2twisty;

Well Done! :)

I changed the title and made the thread a sticky, I hope that you don't mind.

Thanks again for the work that you have put into this project. It works and IT WORKS VERY WELL!

Overtime, the "Report Generator" will just keep getting better, as new programming code is added! :)

GlucoseBuddy Diabetes Report Generator v 1.2
 

V 1.2 is ready for release!

GlucoseBuddy Diabetes Tracking Report v1.20

I've added several new features. Check out the change log!

Bug (fixed): Fix report output when localized to UK or other country that changes date formats by changing the report format to dd-MMM-yy, for example, October 1, 2012 will display as 01-Oct-12.

Added: Figure out where page breaks are in report and put proper heavy line on bottom of cells to improve appearance of the report, adjust these in the event of A4 paper
added: drop downs for report run selection (7,14,30,60,90,all days), and have custom date range option
added: Improve conflict resolution. Create error report so user can fix GB data.
added: allow user to choose to display mg/dl or mmol/L. Perform mg/dL <-> mmol/L conversions (http://www.soc-bdr.org/rds/authors/u.../index_en.html )

changed: Set footer start and end dates to the first and last displayable dates in the report, instead of the report run dates
changed: set Excel to print all columns on the page and allow the user to select Letter, Legal, A4 or B4 paper size

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.

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.

Yea it imports the data and creates the new worksheet with the logs but the the error pops

Thanks, I will email him

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

MY EMAIL TO CHAD:

Chad,
Don't know if you still need this or not since your post was dated 10/2012, but here is my exported CSV file. When I try to run the generator, opening this file I get a Run-Time Error "3021" Either EOF or BOF is true, or the current record has been deleted. Requested operation requires a current record. When I try to run the HELP file I get: Cannot open file at MK:@MSITstore:AD0270.CHM. Any help with this would be appreciated. Thank you.
Gary

CHAD'S REPLY:

Let me look into this. It's been a while since I had the source code open, so I won't make any promises.

It might take a while for me to get to this, too, with my work and class load.

Has the android app been updated lately?

---------------
Chad Douglas

MY REPLY:

Sadly. No. They have not released any further updates. I contacted them today and I'm waiting on a reply, but I'm not going to hold my breath. I'm thankful for anything you are able to do whenever you are able to. I completely understand. And Thanks.
Gary

Update
 

Still no further response from Chad on the Report Generator error. :confused:

Hang in there, Chad is a very busy guy. He just plays with the programming in his spare time. He did say that he would get back to you and I am sure that he will.

Add me to the list looking for an answer to the above errors!

Mac support?
 

Thanks very much for the work you've put into this report generator. I attempted to run it on Excel 2011 on a Mac, but it failed due to ActiveX content. Is there any chance you could easily rework this to not depend on ActiveX?

- Bill

Yes, as you found out it is not compatible with the Mac. If you know someone or have access to a windows based machine it works very well.

Excel Sheet Helpful but having issues
 

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.

I'm getting a Run-time error 3706

Provider cannot be found. It may not be properly installed


Any ideas?

crashed app
 

Well, your app doesn't work with my Excel 2007. First thing that happens is it jumps to the debug screen, then the it won't let me enter the insulin type.

You can't enter anything in the Report Generator, as it only generates the report from your downloaded CSV file.

Snack/Other Carb Inclusion
 

First, I am a new (< month) user of GB Pro and am very impressed. I use Fat Secret in conjunction with GB as I like to use the bar code scanner to accumulate meal components. [Though it is pretty easy to manually transfer each day the carb data by meal to GB, it would be wonderful if there were an interface or if GB had a similar bar code scanner]. I'm a senior citizen+ and have had Type II for years but didn't pay all that much attention to my diet. With some recent development with my sight, I've gotten serious and started using a paper logs etc. - a PITA as far as I am concerned. Using GB on my iPhone actually, to me, makes tracking all the data quite fun (and much more enlightening). Anyway, to my question.

Though elderly, I wanted to try this Report Generator Tool and found that it doesn't work, or I couldn't make it work :confused:, on Open Office. So this morning I bought and installed MS Office and ran the report. [Very good instructions and generating the report was a snap]. However, all my carbs do not show up, specifically my mid day and evening snack so my daily carbs are understated. I want to use the report for my doctor's visits but I think that having to explain that snack carbs are excluded or providing some other handwritten 'snack log' will undermine the confidence in the GB Report.

Reading through the thread entries, I see that Twisty was planning to address the snack/other/note issue. I realize that Twisty has other things that occupy his time and that this report is a donation of his time and talents (and both are, I sure, considerable) but I'm wondering if any new release is release is planned/timing or if anyone has some work around to include the snack carbs?

Thanks

Hi asvan1w. I am glad that you got the "Report Generator" to work for you.

Only 2twisty (Chad) can answer your question. Send him an email and ask him about the snack/other/note issue. His email address is at the top of the ReadMe.rtf file in the zip file that you previously downloaded.

Adding the snack/notes/other information has proved to be very difficult. It was very hard to get all the information to fit on a single page, since being able to get a readable report on 8.5x11 paper is an absolute must. Also, since it is possible to have snacks at all times of day, it's impossible to put the snack data inline with the rest of the data.

The best possible result would be to have a separate report for snacks/other.

Honestly, I have not touched the code of the report generator in months, so I'd have to review the entire project to see what can be done about it.

I am looking at making some changes to the code. AGain, the snacks and other data will be the most challenging piece. I may have to rework the layout of the entire report to make some additional changes.

I will work on this as I am able.

Twisty - Thanx so much for your response. I did find that it is not that big of a deal to manually enter my total snack carbs in the space provided and to manually add footnote numbers in the column with corresponding notations at the end of the report - for those items that I think I want to have part of my med record with the doctor.

As to legal size vs letter size. I did produce my report on legal size paper as my eyes are too old to read the fine print on letter sized. I suppose, for filing purposes, the doctor would prefer an 8.5X11 sheet but for that, my age is an advantage. I don't care what he likes or doesn't like. It is my experienced view that 95% of docs now days look at patients as billing opportunities and, frankly, resent informed patients as an affront to their god like egos. If he doesn't like, he can file 13 it for all I care, just so long as he provides my prescriptions. What does matter to me is that the combination of GB, Fat Secret and your report fairly seamlessly provide me with the platform I need for ME to manage this part of my health.

Anyway, thank you for all the work you've done in making this report available.:cool:

I downloaded the excel file, installed the fonts & opened the program. Step 1 says "Import Glocosebuddy Data". OK- HOW?
I am using the Galaxy S4 not the web log.

The Report Generator uses the CSV file that is downloaded from the website.

cant general excel report
 

I followed the "readme" and I can not generate a report.

when I import the info I am not getting the generate report button to become available.

I need help please.

trying to figure this out...
 

I'm having the same problem as a previous poster... I can't figure out how to import the Glucose buddy data... I don't think the macros are working.

I am using Open Office, and I think I have enabled the macros, but no luck. I can get to an "assign macro" command... Which macro should be assigned for "Import the data" and which for "Generate the report"? :confused:

Also I couldn't get the second font (AgencyR) to import - it had a "small error" but failed. AgencyB installed just fine. I'm on a MacBook.

Hoping it's possible to use this macro on this platform! Thanks!

Grace's Mom

The Mac is the problem. I can't run the software at home on my MacBook, but it works fine on my work computer, which runs Windows XP. The GB Report Generator Tool was written for a Windows based machine. Try to find a Windows computer, to borrow or use, it should work fine on it. :)