More Data

More Data

Oh I do love fiddling with data.  I’m not an academic, but I find a certain level of satisfaction in problem solving. After my previous post I was feeling peeved that to get what I really wanted (total control over the data) I would have to buy a premium plugin.

No longer!

The charts below are generated using a lightweight (and free!) plugin, Inline Google Spreadsheet Viewer.  Everything is controlled in one shortcode, edited manually using  a slew of attributes available from the Google API. And the best part? All the data is being pulled on the fly from the spreadsheets on Google Docs, so if I want to edit them I just go into the spreadsheet in question and change the values. Job done.

The food pie chart is a little misleading as it reads as if I’ve been stuffing carbs all day. The actual carb content overall came to 182g which is clearly not a days worth of food. I’m not sure how to best represent this, as there isn’t a ‘total grams consumed’ option in MyFitness Pal, and their exports require a premium subscription. No thanks. Also there are no calories in there, as they aren’t the same unit of measurement, so have to be mutually exclusive.

In truth, I would rather have used Chart.js as it’s charts are absolutely gorgeous. But this gives me the tools I want, with the added bonus of on-the-fly editing and data fed from a dynamic, external source. And no forking out for a one-off or recurring fee.


Here we go again…

Here we go again...

My blood sugar levels are bloody awful at the moment. I won’t lie, some of it is probably my fault. But I was a bit gobsmacked that my Hba1C has doubled in the last three months.  Currently it’s as bad as it was when I was first diagnosed. If I can’t get it down in the next couple of weeks I’ll have to add a glicazide tablet to the Metformin SR and Lisinopril I’m already on.  I have been very run down, but there’s more I can do. I lost 7lbs in the last fortnight, so that’s a start. I’m currently trying a new tracker app called MySugr, as the old Ontrack Diabetes app seems to be in a weird place right now.  There was an update that apparently wrecked it, and then another update.. but my version doesn’t seem to have changed at all.

Hungry Whippet cartoon

The free version of MySugr doesn’t support PDF export, and there is no HTML export at all. What there is though, is CSV export, which I can then feed into a Chart plugin. Which I’ve been playing with today.

Public humiliation is my latest tactic. If I upload these charts, people can see how badly I’m doing. Hopefully it’ll stir me into doing better.

Below is the chart I’ve created using the CSV export from MySugr with the plugin Visualizer Lite. I don’t really need all the pro elements, as none of the things I’m tracking can be measured together. My plan is to do a BS chart, a steps chart and possibly a carbs or calories chart. The world doesn’t need to see my weight progress.

Stitch is happy

So.. for context. The guidelines for diabetic blood sugar is between 4 and 7 mmol/L.  You can hover over my results to see just how much shit I’m in right now.

MySugr records a lot more than the below, but I have to edit the data manually in the CSV file. The pro version allows pdf export, but where’s the fun in that?

The Chart (ulp)

This is now a screenshot of the chart, as I found a plugin I liked a lot better.  You can read about it here.

Visualizer Chart


Ontrack – February

I haven’t done this for a while.

Ontrack chart for February, minus the weight and calories as I’ve not been terribly good at keeping a record of it. I’ll try and rectify that for March… uneasy