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.