Excel Spreadsheet Macro Application to monitor BG levels

By rcmodelr Latest Reply 2012-09-30 15:11:56 -0500
Started 2012-09-28 02:17:54 -0500

If you use a Medtronic's Insulin Pump and Medtronic's CareLink software, here's an Excel Application I designed and programmed to use data exported from Medtronic's CareLink software, as CSV file. Load my application workbook, and ENABLE MACRO'S. After this application is loaded, open the CSV file from CareLink, then simply run the macro from my workbook. It will create an hourly logbook report for every day contained in the CareLink file. All three of my doctors have commented that they like the output of my logbook reports more than the output from any glucometer manufacturer's software including the pump and meter software they use in the Doctor's office to download data from patient's glucometers.

My Excel application can be found at THIS url for the next 90 days.

[URL=http://wikisend.com/download/424044/Create Glucometer Logbook.xls]Create Glucometer Logbook.xls[/URL]

If link doesn't show as link, copy entire line and paste in browser address bar.

I last edited it in Excel 2010, and although I saved it to supposedly be compatible with Excel 97 - 2003, I haven't tried it on an earlier version, so can't say for sure that it will. But it worked under Excel 2000 when I first started creating it.

16 replies

rcmodelr 2012-09-28 09:34:39 -0500 Report

No idea why it would. Unless either your system thinks any spreadsheet with a Macro has a virus, or there's something on Wikishare that may be infecting files uploaded there…

I just downloaded and it downloaded clean. If you mean Excel gave warning message, different versions of Excel give differently worded warnings when opening files with Macro's. You may have miss-read the Excel Macro warning. I know the version of Excel 2000 that was on computers at my last job gave danger warning giving option to enable macro's, disable macro's on file, or exit immediately. Excel 2000's Macro warning message reads as what could be taken as a DANGER warning just trying to warn you that not all macro's are harmless so don't blame Microsoft if you enabled macro's on a file you opened and later found out the file did things you didn't want to be done.

The spreadsheet file provided here needs to be opened with Macro's ENABLED since the Macro's in the file are what processes the data and creates the logbook report. It processes and modifies the source data file and ends up with the Logbook report on a new sheet 1 on the source file, and the used report data on a second sheet of the original Carelink Export (source) file.

Hopefully this site won't ban me… I noticed after uploading and providing link here that I forgot to remove my "shareware" wording in the file as I had intended to do… After I noticed that, I tried removing the post and this site seems willing to allow me to delete or edit my replies, but once I've made the initial post, it's set in stone… This site won't even let me edit much-less try deleting the original post.

jayabee52 2012-09-28 09:45:46 -0500 Report

if you want to remove the entire posting all you need do is click the red flag below the original post and ask it be removed. Or click on the feedback link at the bottom and ask the techs to change the original post to what you had intended.

rcmodelr 2012-09-28 10:10:23 -0500 Report

It just seems a bit illogical that a site will allow somebody to edit or delete a reply he just made to a post, but the site won't allow anybody except their administrators to either edit or remove an original post.

rcmodelr 2012-09-28 10:07:05 -0500 Report

Actually, what I'd like to be able to do is EDIT the original post, and replace the original link with a link to the intended file, which is a version of the same file only with the shareware wording removed… But would this site frown as much on a file saying it's a FREE FILE, but still containing instructions if somebody insists they want to pay something??? Last time I provided a Logbook Spreadsheed on Insulinpumpers, I had it provided for free and ended up wishing I'd given optional payment instructions after several who used that logbook contacted me saying "How can I pay you? I INSIST you let me pay you something."

Since the site wouldn't allow me to edit the original post, I have the re-worded file stored on my computer, but haven't uploaded it yet.

jayabee52 2012-09-28 10:42:33 -0500 Report

then use the feedback link and tell them what you would want to be placed as the original post. However if you want to try to sell your spreadsheet you may be violating the Terms of Use.

Just trying to be helpful.

rcmodelr 2012-09-28 10:54:58 -0500 Report

That's the thing… I'm NOT trying to sell the spreadsheet, I'd just like to be able to provide instructions for any users like the ones I encountered on the other site that insisted that I tell them how they could pay me since they insisted what I gave them was of enough value to them that they insisted I accept some payment. In my file provided above, the instruction page says it's sharewhere, but nowhere did I ever say anything other than "contribute what you feel it's worth to you." I'm NOT trying to sell it, just wanted to provide instructions to any insisting I let them pay something.

If this site says I can't even say that much, then I'll remove the info for those insisting on paying also before uploading the intended file. But if this site says it's OK since I don't have any price specified, then the file can remain as originally posted.

Anonymous 2012-09-30 15:11:56 -0500 Report

I had a post removed for posting an online coupon for a product that had already been discussed and rated in this forum…was not trying to sell anything

John Crowley
John Crowley 2012-09-28 15:00:21 -0500 Report

Hey, this looks like a great thing to share. I'd be happy to replace a link in the original post for you. You can post the link here or private message it to me. Either way.

rcmodelr 2012-09-28 15:20:57 -0500 Report

OK, but please look at the file as-is, read what the instruction worksheet says, and let me know for sure what needs removing, if anything.

Sheet 1 of workbook should show immediately when file is opened. The working part of the file is the Macro's in the file. Sheet 1 is just the instructions, and part I'd removed was part from "If you find this useful" to bottom. But if some or all of that can stay, so much better.

On Insulinpumpers, about 5 years ago when I provided similar logbook to work with Animas pump & UltraSmart meter, I received several emails from people actually getting mad at me because I hadn't provided them any way to contribute or anything, which is the exclusive reason I provided the bottom portion of the instruction sheet text.

JSJB 2012-09-28 03:43:21 -0500 Report

your link came up as a danger and to exit immediately

rcmodelr 2012-09-28 11:25:51 -0500 Report

If you mean Excel gave a danger warning telling you to exit immediately, it means you have security setting set to Medium so ANY spreadsheet file with any Macro coding will give that same danger message since it is possible to code Excel Macro's to do things even as damaging as reformatting a disk drive. The Excel danger message is just Microsoft's way of telling you "If you enable Macro's on this workbook even though you don't trust the creator, then don't blame Microsoft if the file screws up your entire computer system."

This file will not function at all if the macro's are disabled.

And when it works, it WILL modify the file you exported from CareLink. It will process the data, re-organize the data, then create a new sheet 1 containing the logbook report.

The way I do it is first open the Create Logbook file, then open the file exported from CareLink. After opening the CareLink file, if I want the original file retained, I'll immediately save it as a Microsoft Workbook file before running the macro to create the logbook. Then, if I only want to print the logbook report, I'll print the logbook report, then close the file without saving it again. If I want to save the Logbook, I can save it either with a new name to retain the original file, or save it with the same name to over-write the original file.

However, the logbook can only be saved as a Workbook file if you want it in usable format. So if you left the original file as the CSV format saved by CareLink, you can still over-write the original file, but the logbook won't look the same next time it's opened and the source data will also be no longer usable.

I usually either retain the original source file and print the logbook report and close without saving, or create the logbook and over-write the original file with the resulting Logbook file figuring I only need ONE format of the file.

rcmodelr 2012-09-28 11:05:58 -0500 Report

What brought up the danger message? Your system when you tried downloading it? Or Excel when you tried opening it? If you have Excel Security settings set at Minimum, it will automatically enable ALL Macro's in files opened with no messages or warnings. If you use "recommended" or "Medium" security setting, Excel will give a DANGER message any time you try opening a file that contains Macro's, and you'll have to manually select to "Enable Macro's." If you have your Excel security setting set to "High," Excel will not allow ANY Macro's to be enabled.

The part that does the work in this file is the Macro's. You'll get a warning message from Excel any time you try opening it, and you'll have to manually enable the Macro's for this workbook if you want to use it to create the logbook report

JSJB 2012-09-28 14:10:03 -0500 Report

Just clicking on the link brought up the warning. no downloading or opening it. will check the security level

rcmodelr 2012-09-28 15:30:07 -0500 Report

Did clicking the link open a Wikisend: free file sharing web page? It should open a Wikisend web page with a Download button to click on to download the actual file.

rcmodelr 2012-09-28 14:20:04 -0500 Report

Excel security setting shouldn't affect whether you get any message when just clicking link to try downloading.

Next Discussion: The Pumper Song »