Writing BG Management App

[andcol]

Hi all,

I have started to write an app to manage all of my blood glucose readings and to give me graphs and different stats. Here are some screen shots of where I have got to today:

Main display showing all entries

The graph is zoomable with the mouse (also showing the fasting settings)

The next screen shot shows my pre and post prandials

The pane on the bottom right shows the average for the last 90 days (since last sample) and an estimate of the HbA1c some statistics on the fasting and 2 hour post-prandials (upper percentile is the 75th)

 

[andcol]

Things to do
1. Add data points (current loaded from a file on start up)
2. Implement a database
3. Implement average graphs of various types
4. Implement distribution graphs.
5. Edit points
6. Scrolling for zoomed graph
7. Improve import from file so you can define format of csv


If you have any ideas or want a copy then please post below

 

[mo1905]

wow ! I'm not sure I would know how to use it but I'd love a copy !

 

[andcol]

That is my plan will put it on my web site with instructions on loading the data and add a link here. It is written in java and all the libraries are packaged in the jar so should run anywhere

 

[Bluetit1802]

Blimey!

 

[andcol]

To run the app execute java -jar <path-to-jar> -f <path to csv>

csv file is of the following format:
Date,reading,boolean

Date must be in this format dd/MM/YY HH:mm eg 01/02/14 08:00 (24 hour clock
reading is in mmol/L
boolean is TRUE if pre-prandial (fastings are calculated)

 

[andcol]

Blimey!

lol got to do something on a bank holiday

 

[andcol]

I have uploaded a the jar and a file of data for you to play with to google drive at this url https://googledrive.com/host/0B-z_UPs-Jl8aMTNrd0pMemd6Q2c/

 

[Andy12345]

excuse me for my dumbness, i think my bg monitor software does something like this

 

[andcol]

very possibly but you are stuck with what they give you lol and that is also ok if you use an OS that they decide to support

 

[Andy12345]

yes.....or not, i dont hardly test my bloods and never look at the software anymore, so im stuck with facebook or doctor who repeats at the moment due to an obsessed 13 year old lol

 

[mo1905]

To run the app execute java -jar <path-to-jar> -f <path to csv>

csv file is of the following format:
Date,reading,boolean

Date must be in this format dd/MM/YY HH:mm eg 01/02/14 08:00 (24 hour clock
reading is in mmol/L
boolean is TRUE if pre-prandial (fastings are calculated)

This is where my problem lies lol ! I have no clue what this means. Thanks anyway


Sent from the Diabetes Forum App

 

[andcol]

This is where my problem lies lol ! I have no clue what this means. Thanks anyway


Sent from the Diabetes Forum App

ok i will add a file load menu so you can select it - will be done after I watch this film so then you can just double click and load the file

 

[mo1905]

Thanks Andrew. No rush. Sorry but I am not great with computers. I use a Mac, is that OK ? I have Word on it.

 

[sanguine]

Looks good Andrew, but I think I'll stick to Excel on my PC - I tend not to use tablets or smartphones for databases, even though I know you can.

I note your first reading is ticked as both a fasting and a preprandial reading - is that deliberate? (I.e. Testing before breakfast).

Do you intend including blood pressure, weight etc as well?

 

[andcol]

yes and food and exercise. I always test when I get up and if i dont exercise and just have breakfast it is a pre-prandial. The fastings are calculated as the first entry on the day. You can mark an entry in the underlying model as a fasting reading and that will over ride any calculated entry

 

[andcol]

Have uploaded version 0.0.2 to my google drive location https://drive.google.com/folderview?id=0B-z_UPs-Jl8aMTNrd0pMemd6Q2c&usp=sharing
This now has a file menu and a load option. Select your file in the chooser - same format as above.

 

[mo1905]

What do you mean by select your file in a chooser Andrew ? Thanks BTW


Sent from the Diabetes Forum App

 

[andcol]

file dialog that comes up - like file open in word
load the csv file I have uploaded as it has some sample data (actually has my real data)

download both files and double click the .jar file when it has started select "File | Load"

 

[mo1905]

Just got above message ? Is it cos it's a Macbook ?


Sent from the Diabetes Forum App