NiVZ
DAFNE Graduate
NHS Grampian
82 posts

Hello,
I've made a DAFNE Diary Excel spreadsheet that produces graphs (see screenshot below):
http://www.freewebs.com/nivz78/BG_Graph.jpg
I wondered if you could implement something similar for the Blood Glucose Diaries on the site?
Thanks,
NiVZ

Alzibiff
DAFNE Graduate
Pennine Acute Hospitals
21 posts

Having played around with various spreadsheet functions and used a number of meter manufacturers' software over many years, I am a great fan of what I think are described as "time of day modal" graphs. Hope the following makes sense  but please come back at me if not ...
Divide the day into DAFNE type periods: before breakfast, before dinner, before evening meal and then before bed. Now take BG readings over say two weeks for each period and find the modal value for each period  the value which has as many readings above and below it for a particular period  not the average  as the odd very low or very high can make averages meaningless. The modal point of each period is then plotted on the graph and this point is marked with vertical line  representing the range of values associated with it. (Gee  I wish I had an image file to post up at this point).
The idea is that with a graph which shows a time period of one day along the xaxis, you can see how consistent or otherwise the BG readings are at a specific time of the day and also whether there is an underlying trend which will or should enable you to adjust your individual meal or background insulin dose.
The ideal will be a horizonal line (rising slightly at bedtime according to DAFNE rules) and with the vertical lines discussed earlier, nonexistent.
Make sense?
Alan

Simon
Site Administrator
Sheffield Teaching Hospitals
559 posts

Hi, sorry for the delay in replying to this guys  I've been out of the country for the past week.
NiVZ  Have you seen our Diary Graphs, which are accessible from the BG Diary view (underneath the actual table of entries)? If not, you may find what you are looking for there. If not then what type of graph would you like to see above and beyond what we already have?
Alan  I have implemented both 'mean' and 'modal' versions of this graph, and you can find links to them as 'Daily Trend Charts' in the BG Diary section  is this the kind of thing you are after? If not then let me know and I'll modify it for you.
As always  feedback by all members is encouraged.
Simon

NiVZ
DAFNE Graduate
NHS Grampian
82 posts

Hi Simon,
I remember the very old diaries I used to use when first diagnosed where you put the reading on one half of the page and plotted a line graph on the opposite page. It's probably just familiarity that I like the line graph and made mine as shown in the picture.
I do like the graphs in the Blood Glucose Diary as I can see the benefit of showing readings grouped by time of day to help identify if theres a certain mealtime where you are high low, and it's also easy to see how much you change from bedtime to morning to keep an eye on the basal.
Thanks,
NiVZ

Simon
Site Administrator
Sheffield Teaching Hospitals
559 posts

We've just rolled out a major update to the graphs, so they all have a consistent look and feel. Check it out. They require the Flash player (if you can see the graphs on the diary graphs page, then you have it)  if you don't have it then there is a link to install it on the same page. If you aren't able to install it and want to be able to access the graphs then let us know and we will work on a solution.
Let us know what you think of the new graph features.
Also  still working on your request NiVZ, hope to have it done soon.
Thanks,
Simon

Simon
Site Administrator
Sheffield Teaching Hospitals
559 posts

Just added a 'Seven Day' graph to the list of available graphs. It shows you 7 days worth of diary results in a similar way to NiVZ's example above. If you have opted to show graphs for all entries, you will be limited to the last 7 days for this graph type. If you are showing graphs for a specified date range, the 7 days will start from the first date in the date range selection boxes  I hope this makes sense.
Let me know if this is useful, and any updates you would like to it, or indeed any new graph types.
Thanks,
Simon

NiVZ
DAFNE Graduate
NHS Grampian
82 posts

Hi Simon,
Graphs look really good. Very impressed with how quickly you implement all the features. This site is proving to be so useful.
I did notice, I sometimes get an "error in data file" when doing the 7 day trend graph. Seems to be on entries where I've put in a 1CP snack without testing my BG.
NiVZ

Simon
Site Administrator
Sheffield Teaching Hospitals
559 posts

Hi NiVZ,
I've updated the graphs  it now says "No data for selected period" instead of the more obscure error if there are no BG results for the specified time period  I'm assuming there were no BG results in the set of data you were trying to graph when you got this error. If this is not the case then let me know.
Thanks,
Simon

NiVZ
DAFNE Graduate
NHS Grampian
82 posts

Hi Simon,
Looks fine now. Can't believe how quickly you guys fix and implement things!!
Thanks again for all your hard work on this site
NiVZ
