Disclaimer

BEFORE YOU START: Please note that although I currently volunteer for both the Stroke Association and Age UK, the views expressed in this blog are strictly my own. I am not a spokesperson for either (or, indeed, for any) organisation, and I accept complete responsibility for the views expressed herein. I've tried to use the Glossary to explain any ambiguous terms, but if you think there is anything I've missed, please message me.

Tuesday, 19 February 2019

Information Exchange

Developing sortware, you'd often come up with a problem and think "how do I solve that?" There is documentation available online, of course, but often it doesn't hit the mark, People have written blog posts, too, but often they are very simplistic, I suppose to help convey their main point.

There was another type of site, one which used the community's collective knowledge to help solve a problem. Once one person has accomplished something, they can teach somebody else to solve that problem, and pretty soon the "thing" isn't a problem any more.

One such site was Experts Exchange. They would tantalise you with the same question you had but, oops, before you were allowed to see it, they just wanted you to subscribe to their site. The idea of knowledge being so directly associated with money really used to put me off, although when you think about it, it is everywhere these days. But, in my book, why would you not share knowledge, especially in a niche subject with a willing pupil?

So I never went near Experts' Exchange.

One other site was Stack Exchange. This site, at least, was free to both request and contribute. In fact, for several years I was actively involved in the Bicycles version of the board, until shortly before the stroke. They also have a board on the subject of software development, in which I've dabbled but was never a serious participant. Of course, all these boards are the same thing - it is just the subject matter of each which is different. In theory, you join the site for free and post your question for everyone to see, and people can try to help, normally with a partial answer. You end up with several of these answers, and hopefully by aggregating them together you get a decent idea. The site has nuances, such as the duplication of information. If you ask the same question as somebody else, people will close your question and point you to the other question/answers instead. If people like your question, you earn some points, known as your reputation. If people like your answer, you get more points. In that way, the helpful people, and those who ask the most meaningful questions, float to the top.

This sounds like a great site, but it has its own drawbacks.

Because of these points, people who are naturally competitive will follow the site in minute detail, and will put forward anything that they can possibly think of, in the hope that somebody gives them points. Sometimes it is useful, but often not. So it degenerates into a pissing contest, and in fact you do see rivalries played out there, and the primary aim of helping people soon becomes no more than a by-product - the casual visitor won't notice this, but I found it surprising how personal things could get. And very often, this translates into voting patterns, too, and I'm afraid I sometimes fell into this trap. So-and-so thinks a contribution is good/bad, you trust their judgement so you vote that way too, possibly not paying as much attention to the actual contribution as you might. In the bicycles forum, a group of us would also go to a bolted-on chatroom quite frequently, so we became friends with each other, as well as participants in the forum. And it is certainly easier to be kind to someone when you know and like them.

Similarly, in a zealous attempt to avoid duplication of data, somebody will spend two seconds looking at a question, pick out a few keywords, see that those keywords appear in another question, and close the question because it is a duplicate. Of course it very often isn't a duplicate, but a totally different question which is unfortunate enough to be in the same area. If people read the question, they'd know that, but they don't. And that there is somebody out there asking for help, who might have spent an hour or more just writing their question, counts for nothing.And again, people tend to vote with them, although in some cases they have the power to act unilaterally.

I mean, this was primarily the reason why I disengaged from the Bicycle site. The whole ethos of the site is that someone is out there asking for help. But some people decide not to give that help fro the most arbitrary of reasons.

I suppose it is a fine line. On the bicycles site, we often used to get questions like "I found this bike in a dumpster, how much is it worth?". And you'd straight away think, "its previous owner put it out in the trash, so how much do you think it's worth?" So a question like that, I suppose it is reasonable to conclude that it is time wasting. One man's meat is another man's poison I guess.

Monday, 18 February 2019

Food For Thought

A guy came around last week. We met in a technical environment (IBM) so it was good to talk vaguely technical to somebody, and of course I told him about the application that I am currently up to.

I only worked with him for a few months, the role at IBM was my first contract so the priority was simply to prove that I was good enough to do the job, rather than worrying exactly how interesting the project was. As it happened the IBM role was not-at-all challenging, I got out as soon as the contract finished, and I went on to do many more interesting roles both locally and in London. His job was to support, rather than develop, one of IBM's flagship products, MQ Series. I make the point about "support" because IBM had a definite structure where developers developed, they (we) were the glory boys, and supporters supported - there was limited crossover between the two. But this guy obviously got very intimate with that one product, and eventually he himself became a consultant. I know myself that there is a small but well-paid market for MQ consultants, where my skills included a lower level of M, but lots of other things too. By the sounds of things, the chap spent a lot of time not working, but when he did, he was well paid.

Anyway I talked to this guy about my application. He had a few thoughts. Some were off the planet (the environment in which I'm writing is very different to the environment in which he wrote), some were things I'd already thought of, but some did force me to think. I mean, most of my application is developed now but there are a few bits and bobs to complete. In software development, you start off with a vague notion about how you'll go about something, then put flesh on the bones as you make progress. For that reason it is difficult to cost projects up-front, but experience, where you've seen such-and-such a problem before, is invaluable.

One such area was the multi-user aspect of my application. I had a vague notion that the application would be written for one user, the currently-logged-on user But would be usable by other people just by virtue of different users having different Windows logons, different file areas etc. Certainly my app is all files, so I'd always thought that it would be possible to have many different DIEM data files, in many different locations. But I got to thinking over the weekend, how exactly would I make it happen?

I didn't do anything until this morning, when I decided to check that the application would work for mutiple users. In the end it was easy, just because the application is pretty modular already so I only had to change a couple of tiny things.

But of course the big win is knowing not just that I want to do it, and knowing vaguely how I would do it, but having actually implemented it, I know exactly what steps I had to take to accomplish it.

At one extreme, I could have had my own database of users, passwords, data etc. but I decided that was too much overhead, and that the data here is not critical enough, plus I want the application to be as open as possible At the other extreme, I could have had no security whatsoever, just to keep the database in a single place, but the knock-on implication of that would be that I could only support a single user. So I'm in a halfway house, using Windows' inbuilt security features to separate users. I  wouldn't claim that it is 100% foolproof - I am an administrator on the machine and I can see everyone's area (I happen to be the only person who uses it) - but the application is as secure as you make Windows itself, and that seems fair enough to me.

Thursday, 14 February 2019

Getting Started

Tekkie post - I'll make it brief.


When I used to work commercially, the last phase of any project was creating an installer for whatever we happened to be writing, and I always used to underestimate just how long it would take. You'd be clapping each other on the back because you'd finished the application, but there was still one significant hurdle left to jump. In the early days I mainly worked on web stuff - it'd not only be installing the files to the required folder, but stuff like creating web sites, virtual directories etc. plus capturing and sorting the account credentials to make sure it had the necessary permissions. All of which I did by setup program, just because it was 100% repeatable if there was a problem - I wasn't reliant on some operations guy typing the wrong thing in.

In later years it was mainly desktop applications. I designed a lot of stuff (tek alert!) late bound if I could so there were always config files which needed updating. Late bound is: an application would need to use such-and-such a technology, but rather than just lump the technology in with the application, you'd keep the two parts separate. This allowed you to move from Technology A to Technology B, say, without impacting the application itself. At run-time, the application just used to look inside a configuration file to find out which approach it had to use. There were also things like database usernames and passwords - I never knew these for the "live" systems, so the Operations guy would type them in during install. And I wrote simple credentials-checking things to check that the operator himself hadn't mistyped things. Over the years I learned to leave as liyyle as possible to chance But again, it took time and effort.

But I have just had a wonderful experience with Microsoft's Setup program creator tool. I'd budgeted a month to do the setup program for my app, but it has only taken me a day! In fact, most of it was already done for me, I mainly just entered product-specific stuff. 'Course, it helps that this installer doesn't do anything complicated (one of my goals here was to avoid complication), but still, I'm pleasantly surprised. So, task number next!

Encouragement

Tony Benn used to say that the role of senior people in society was to encourage. I don't think there as a truer phrase, but I think it's true for all of us.

A kind word here, a compliment there, I think it all goes some way to telling somebody that, whatever effort they just made, it is appreciated.

That's all. I've got no parable behind this, it's just a mantra I try to live by.

Wednesday, 13 February 2019

Busy Bee

I'm sure I must have mentioned this before, but before the stroke I worked in IT. Well, immediately before the stroke I'd decided to have a career break and had followed my passion to become a bicycle mechanic, but, prior to that, I'd spent 25-odd years in IT, at quite a high level, amongst other things designing multimillion systems for banks. I worked at the high-net-worth end, with asset managers as clients. One of the clients was also Coutts.

I decided quite early on in my career that I wanted to stay as technical as I could, rather than becoming managerial, although in later years there was lots of cross-pollination.

Ironically, I had already decided to go back into IT by the time of the stroke - bicycle mechanics live on minimum wage. Then the stroke happened which was, to put it mildly, a setback.

Anyway for the last year and a bit I have had a goal of returning back to work. Everything is a bit slower one-handed (i.e. one-fingered!) and I make plenty of misspellings. Fortunately I correct most of them before they ever get published, plus with the tools I use, something called a compiler will insist that I type things properly. But whilst I felt I'd had enough of IT back in 2013, I've regained a lot of the passion I used to have in those early years. Plus I'm more experienced in a great many ways, and I make better decisions. But time marches on, and I needed to resharpen my IT skills back to full speed. So I've been doing little projects, just aimed at getting myself back up to speed with things. Little web sites, spreadsheet macros, writing my own applications. I mean, I used to run my own business so I was used to thinking at an entrepreneurial level, and there are plenty of ideas. Plus, as I've said I performed a niche job at a niche level. The current project - I started it getting on for 6 months ago, with just me working on it, albeit part-time alongside other commitments - is a Diabetes Tracking application. As you'll know from past posts, diabetes is significant for me.

It is funny, working on these things, how most of the time life just rolls along, the functionality of the application just increases at a pretty-much constant rate - that comes with the familiarity of a particular technology, and the experience of knowing where and how to find information when needed. I used to find the same with my big clients. But every now and again, something tiny comes along which really throws a spanner into the works.

One of the perks of doing my own stuff is that I don't have any formal deadlines, unlike when I consulted for other people. So I can prioritise "properly" over "quickly". One such area was the usability of a small part of the application. It might be small but it was critical - it is how someone would enter one of their glucometer readings. The control to capture the timestamp of a reading - its date and time - just wasn't usable. So, I took the wheels off, and set about re-working the screen. The "date" aspect was no problem, as there was something perfectly good that I could use out-of-the-box. But the "time"...well, I've probably spent most of the last fortnight trying to find something that looks good and is usable. I must have evaluated many people's efforts at a TimePicker, to see if I could either use it or extend it so I could use it.

Anyway, in the end I've come up with:




(Sorry, the screen capture program in Windows has cropped the lowest part of the image.) But I quite liked the idea first of some kind of pop up clock, which appears and disappears as the user works with it, and secondly of an analogue clock face. In terms of usability, the user just drags the hours and minute hands around the face, so pretty easy. The control is extended from somebody else's work - if I'd have done it from scratch, it would have been two lists, one 0-23 hours, and the other 0-59 minutes.

Two weeks' effort. Was it worth it?

You can see some more screenshots of my application, its pre-release name is DIEM, at http://www.diemware.com. For now it runs on Windows, just because that's where my expertise lies. But already I'm thinking of tablet versions to run on Apple or Android (maybe next version!) One of my thoughts with the project is that I want to try and help people rather than try to make money out of them, so when it is complete I want to distribute it for free. But to that end, one of my own drivers is that I don't want to be spending megabucks myself to buy suites of fancy controls, when I don't really hope to gain any revenue from it. So lots of my decisions have been based around the cost implications of using a particular approach.


Friday, 8 February 2019

Veteran

I had to chuckle - the co-ordinator at the stroke charity told me the other day that I'd clocked up 100 hours of volunteering. My first thought was, "how on earth did they calculate that?", which made me smile.

I mean, I volunteer for the stroke charity only once a fortnight, just going around the ward at the local hospital, the ward where I was once a patient. So that's 26 visits per year. I've been volunteering just over 2 years, so, I suppose, 60 visits. 100 hours? That's about 1½ hours per visit. About right. I mean, I used to have a 2hr slot on the hospital site - buses. Like it or not, I was there 2 hours. Sometimes the drop-ins took that whole 2 hours, other times I was in and out in 30 miutes. These last 6 months, they've cut the buses even further, so I'm 1½ hours on site. But certainly in the early days, I often went around the ward on my own, and nobody ever asked me how long it took, although the two most recent co-ordinators usually asked me.

The other thought is that 100 hours is not exactly a lot, is it? Somebody working full-time would do that in a few weeks, although of course, they're not recovering from a stroke. On the one hand it'd be nice if there was a bit more I could do, but on the other I'm aware that every time I do a drop-in, I'm out of the house for 4 hours, even though the drop-in might take only a fraction of that. So, to the Stroke Association, it might be 100 hours, to me it is more like 300-400. But, not that I begrudge giving the time, far from it, it's just a shame that such a vast proportion is spent either waiting for, or using, the bus.

It actually works out, quite accidentally, that I'm doing more voluntary work for the Age charity at the moment. I spend about 3 hours doing that every week, so that's about 150 hours per year (I've only been doing it about 5 months so far). I started with the Stroke Association first, but the drop-ins take as long as they take - I can't bug people into talking to me.

So...the gold watch is in the post, I presume.

Tuesday, 29 January 2019

Out of Stock

I'm a bit concerned about the state of my meds. I order these electronically. I mean, it is all done through the NHS, through one of their approved pharmacies' web sites.

In theory, I fire off an electronic request to the pharmacy, who then contact my doctor's surgery for an authorisation. All of this is electronic. Lastly, the pharmacy pops my meds in the post, and they arrive through my letterbox a few days later. In terms of timescale, my pharmacy recommend you trigger the request 7-10 days before you want the meds to arrive.

Well, I sent a request last Monday, 21st January, 2 weeks before I'm due to run out. Apparently, this was approved by my doctor's surgery on 25th January, but it has not yet been dispatched to me. Apparently, some of the items are proving difficult to get hold of. I wonder if this has anything to do with Brexit? Although I note that we are still in the EU for another two months, so right now, absolutely nothing has changed from. say, 10 years ago! All rules and regulations are the same. The pharmacy told me that they are waiting on three meds, one of which is branded Bayer, one from Boehringer Ingelheim (which I presume are both German pharmas), but the third is generic, the only address I can see on my existing packet is Eastbourne, well and trulty in the UK and actually not too far from here.

I'm kinda concerned because the upshot is that next month, I will order 3 weeks in advance, to try and make sure the meds arrive on time. And, maybe I need to stockpile a supply of meds, just in case? A friend of mine published details of a campaign by his local doctors and pharmacists, aimed at discouraging people from stockpiling meds, but really, when the supply chain lets you down, what choice do patients have?

Hot Dog

For the last few days my sugar has been really high. I say "really high" - it was 11 mmol/l (200 mg/dl) this morning. OK, not really high but I'm used to single digits these days.

The culprit? Well, I did get myself a little treat at the weekend. One of those multipacks containing 4 x 4-finger Kit-Kats. That's English candy, a chocolate and wafer thing. I kind-of think that anything around these days must be internationally available, but I could be wrong.

I had my last one of these bars yesterday. But the whole bar is, like, 50g, I've had 50g bars of candy before and it is never even noticeable in my sugar readings. maybe  it's because I had one the day before too, and the day before that? I've observed that after some "bad" foods, it takes my body a good 2 or 3 days to get back to normal sugar levels (not "normal" - average for me).

The other thing I bought at the weekend was a packet of Bratwurst, plus some hot dog rolls to go with them. I had 3 Bratwursts - half the pack - on Sunday for lunch, plus another 2 yesterday for lunch. It is difficult to see the Bratwursts themselves putting my sugar up, although god knows what has been added to them in the factory. but those white bread rolls...

I'm normally very careful with my bread consumption. It is difficult to avoid it completely, especially as I rely on sandwiches for lunch. But usually it is, at least, wholemeal bread. The way it was explained to me, white bread is easier to digest (i.e. your body doesn't have to do as much work). wholemeal makes your body work a bit harder, so you end up using more energy to digest it, and therefore your sugar goes up less. A bit, anyway. I've never looked at this in detail but that's what I was told by a diabetes nurse and it makes sense.

I can't imagine white vs. brown makes that much of a difference, so my main "tool" in terms of controlling my sugar is simply to eat as little bread as I can, full stop. So the hot dog buns were a treat, I knew that. Plus, in one of those buns, you're eating far more bread than you would in, say, a slice of toast. But when I think of my diabetic diet, there are very few foods that I totally ban - most stuff, even chocolate, I just make sure my intake is sufficiently small - a bar per month, say - that I don't notice it when I test my sugar. But perhaps I just need to think of these rolls as totally off-limits?

As things stand, there is one Bratwurst left and one roll (I started off with 6 of each). I plan to have the last Bratwurst for lunch, but I can't risk the roll. I'm gonna do that and measure myself again come tea time.

This diabetes - having to worry about this stuff - is a real pita, although I must admit that I do find it fascinating to know that such-and-such a food will do such-and-such to my sugar. I guess I'm lucky in that I can test all this stuff on myself, it is all empirical. A lot of peope can live in ignorance of this, but for me, that knowledge is literally life or death.

I did take a little extra insulin this morning, just when I saw the high reading. I'm out this afternoon so I'll need to make sure I have my jelly beans with me, just in case. Although I'm in the centre of Salisbury so finding some food or other to put my sugar up a bit shouldn't be a problem.

Friday, 25 January 2019

Deal or no deal?

Sorry, UK politics again. Our current affairs at the moment seems totally dominated by the question of deal / no deal with the EU. I just wanted to put my thoughts down.

For my money, Day #1 after the referendum, there should have been an announcement that there *would* be a deal with the EU, or, at least, an attempt to strike one come what may. Exactly how much of life was encompassed by this deal would be subject to later negotiation. I'd see the deal having two or three parts.

Part I would be the amount of money the UK needed to hand over in order to honour its existing commitments. For this reason, it might have been better to leave at the end of a budget cycle, which I think is seven years. In theory, that commitment would then be zero, although I expect there must be a few things which span multiple cycles, so would probably be greater. The UK parliament (ultimately) could then argue with the EU about what that actual number was.

Part II would be to settle the things you would do going forward, in every circumstance. There must be several areas like this, where both the EU and UK gain pretty much equally. I'd suggest that something like guaranteeing the healthcare and security of ex-patriots falls into this category. Again there might be a cost, again it is open for barter, but the point is, you remove a lot of uncertainty from the equation.

Part III would be the optional things. Like, "we want unhindered, tariff-free, access to your markets, how much will it cost?" Again, you come up with a number (actually, numeric cost is just one of the factors here), then you decide whether the terms are acceptable or not. In that way, you kind-of cherry pick how the future relationship will look. The EU has said that "there will be no cherry-picking", but frankly this was a dumb thing to say, especially when they ultimately proposed a deal which included both free trade, and the UK government's wish to control immigration. If that isn't cherry picking, what is? But again, the precise numbers tbd. This is where is might get a little contentious, in that you argue whether you want a WTO relationship, or something more. Indeed if you want to ride piggyback onto something like Galileo or the Medicines Agency, it is difficult to see where WTO is relevant - the relationship we have with the EU currently is far wider.

So I think you come up with two numbers. The first is a number (not necessarily an agreed number, but a requested number) just to honour existing commitments and to guarantee some basics going forward.

The second number would take a bit longer to come up with, but would basically be what "the best" relationship would cost going forward. And the UK and EU could each decide what "the best" relationship looks like, or whether the price the other side wants is worth paying. Again I realise a lot of stuff is intertwined so I'm not just talking about money here.

In terms of making (the UK) parliament (and therefore the public) aware of where we are in the process, I think the UK government acts almost as a broker. "The EU wants us to pay £xbn/year for access to y", and let (the UK) parliament decide whether to agree or not. In that way, you don't need to rely upon any skill in negotiations - the UK government, or some appointee, simply relays what the EU is asking for, and the UK parliament decides whether this is acceptable or not. And, if the EU asks for £10bn for access to something which the UK parliament judges is only worth £5bn, then the UK walks away and everybody loses. So it is in the EU's interests to be reasonable. In any case, if all this is made public, then when people say "the EU wants to punish us to stop other countries leaving", this is something that we can all judge for ourselves. Possibly one reason for trying to obfuscate the process (as I think the UK government has done) is that they wanted a bigger role in the process. But I don't think, with the highest turnout this century in the 2016 poll, that the people of the UK (and, by implication, parliament) were ever prepared to accept opacity. Plus, of course, this has dogged the UK government all the way.

I must admit I was very surprised when, early on in the negotiations, the sum of £39bn (which the UK would pay to the EU) was mentioned, before any detail was made public. I thought, if this is just the price to honour existing commitments, then we will have another bill, an ongoing cost, to cover the future relationship. But as time has gone on, nobody has talked about this, even to say "this bill is zero". If the £39bn was intended to cover the cost of the future relationship as well, then how could anybody possibly know that number without also knowing what the details of the future relationship would be?

Sunday, 20 January 2019

Musical Tastes

I mentioned in a post a few weeks ago that I liked The Beatles. They entertain me, which I suppose is as much as you can ask from any band.

But, as I think about it, they're a league apart from the music that really makes me tick. I remember discovering Bob Marley when I was 18, unfortunately he'd already died. But he sang very politically-charged songs. The injustice of this, the unfairness of that. Quite rapidly, I got everything he'd ever released - on Island anyway. I mean, he saw a problem of black vs. white, whereas I've concluded that the problem is more rich vs. poor, an economic one, but then I've seen more of life than he did, and he lived in a very different world to the one I do. I mean, it helped that I took to the reggae music he sang - that led me to several black English bands like Aswad, who were quite happy to sing about the injustices they felt in the London ghettos, at least in their early days. Even anti-apartheid stuff from UB40 and Eddy Grant, although with these it was very much individual songs rather than following everything the band produced. So, there was a distinct "political" link.

Very different music, but the same political link, I listened to an album by the Grimethorpe Colliery Band this morning, and I'm a silly old sod these days so it brought a tear to my eye. To me, and probably anyone older, brass band music just evokes the coal mines, and of course the Miners' Strike of 1984, how an industry was destroyed by a few politicians to make a point. And, of course, the desolation that subsequently followed in pit areas. A brass band is a real working-man's thing, we even have one in Downton which of course is nothing to do with mining, but to me they evoke the miners nevertheless. Tony Benn used to say that his favourite film was "Brassed Off", a fictionalised story based, I think, on Grimethorpe Colliery Band. And I can see why, it evokes all those things that are good abour the labour movement. It is one of my regrets that I never got to one of the miners' galas up north. We have an annual festival not too far from here, commemorating the Tolpuddle Martyrs. I've cycled out to Tolpuddle but it is unreachable these days. Another regret. But I do think it is important to have these galas, and to keep the link there to remind us all of the struggle we still face.

Wednesday, 16 January 2019

The Way Forward

Gonna talk about a bit of news next. Last night, the UK Parliament chose to reject the proposed deal between the UK and the EU. It's difficult to see how it could have been otherwise.

For my money, the day after she was elected, Theresa May should have reached out and formed a Government of National Unity, suspending party politics, just like in the war. I'd have had people like Nigel Farage around, as an example of somebody who's been really vocal in his opposition to the EU. And, of course, not just Farage but vocal "remain" supporters, too. The problem there is that many people with the loudest voices, Soubry or Rees-Mogg, say, have risen to prominence since the referendum. But there were certainly some of the big players around before, Farage as I say. Maybe someone could have persuaded Cameron to stay involved in some way?

Even that could still have gone pear-shaped, but the chief goal should have been to deliver Brexit such that we exploited the opportunities, and avoided the pitfalls. The reason that the goal is to deliver Brexit is simply because that is how we voted in 2016. The reason that it might have gone pear-shaped is because I think a lot of people, even senior politicians, just want to ignore the 2016 vote in favour of not delivering Brexit. There's not a lot of "respecting the result" going on. Perhaps Cameron saw this, that's why he got out immediately? So maybe we'd have ended up in the same place, but I think it was our only chance.

Perhaps May would argue that she *had* tried to arrange a variety of Brexit positions around her? but all of these people were within her own party. In 2016, Labour was weaker, and May could have tried to build a consensus around something. After the 2017 election, they sniff hr blood. Party politics is well and truly alive and kicking, and, really, everyone is as bad as each other. When somebody talks about doing something "in the national interest", most probably it is a lie.

So, what is the way forward? Clearly the clock is ticking toward our exit on March 29, and much as the UK Parliament does not want to leave without a deal on the table, it is difficult to see how that will happen. Possibly the only option, they feel, is to pause the process? But, of course, many Brexiters want to get out as soon as possible, so they wouldn't be happy for a pause.

It looks to me as though (a) there'll be no agreement to pause A50, and (b) it is unlikely they will coalesce around any deal, especially one to which the rest of the EU will agree, before 29th March. So I think, unfortunately, that the UK will leave the EU without a deal.

Of course, just because there is no deal on that date does not mean "no deal" forever. Indeed, if things stop working, I'm pretty sure that there will be lots of haste to put something in place? The main reason that I wanted to see a deal was because the people who'll be affected more than me, the heads of retailers etc., all say they want something in place. I'm sure, if some of them start going to the wall (either here or in the EU, it cuts both ways), if any of these horror scenarios come to pass, that people will move pretty quickly. So, I think "no deal" is a temporary thing, but as experience tells us, it takes years to negotiate to some kind of arrangement from nothing. So, this issue isn't going away anytime soon...

Monday, 14 January 2019

Decreasing Sugars

I was happy last week because my spot-sugar was a "normal" (i.e. non-diabetic) value, about 5½ mmol/l (100 mg/dl). (After the last post, I'm going to try to quote both units.) But I observed at the time that a one-off value is just that, and not particularly important except in the context of all my other values.

Today, my average sugar - all the readings over the last month - dipped below 9 mmol/l (160 mg/dl), for the first time since I started calculating averages. This is not a particularly significant number in diabetes terms, so again this is mainly me playing with numbers rather than anything significant, but nice to see my average getting lower. I note once again that it takes two insulin injections per day to get to this level.

I also measure a statistical property called the standard deviation. It's quite straightforward to calculate, but not trivial. An application like Excel will calculate it for you. It is basically a measure of how much your sugar varies with each measurement. Obviously, if you take one measurement and you're at "really low", and the next measurement at "really high", then you have an average which probably isn't very remarkable, but it'll hide these extreme values.

So possibly of a greater cause for note is that I've got this variance down to about 1.4 mmol/l (25 mg/dl). So my average is 8.9 ± 1.4 mmol/l (160 ± 25 mg/dl). In a healthy person, your pancreas produces sufficient insulin that your body's sugar is pretty constant, so the smaller the it varies, the better. For me, whose pancreas doesn't produce enough insulin, 1.4 represents the smallest variance since I started taking measurements back in 2016. Because I take readings every day, I end up with 30 or so per month, so typically the standard deviation will only change by a tiny fraction per day, so it takes a while to notice much difference in the numbers.

International Readers

Side-by-side from my blogging, I am developing a Diabetes Management application. There are basically two different units in use (for glucometer readings) worldwide. This is not exhaustive but the UK, Australia, China use the units mmol/l. Most of the rest of the world uses the units mg/dl, including mainland Europe and the USA.

I'm developing this app, which I want to support both units, so I've read up on both units. But I got to thinking, and my wife confirmed this, that many people, even health professionals, are intimate with the one unit but know nothing about the other.

Starting from basics, both units are used to measure the same thing. This is like miles and kilometers. HBA1C is measuring something different. So there is a relationship between the two units, which is basically:

1 mmol/l = 18 mg/dl

So, to give an example, I've talked about blood sugars of 15 mmol/l in the past (I'm almost half that now!) - this is 270 mg / dl. My current average is 8.9 ± 1.4 mmol/l - I might say more about that in a later post - which is 160 ± 25 mg/dl. So clearly, above that of a non-diabetic, but getting better. As I'm starting to work with this new unit, I'm finding it quite convenient, and in fact I've changed my app to store the numbers, internally, as mg/dl. although, of course, it is just a number. Each number in the database carries with it some crazy-silly precision, so 10 or 200 doesn't make any difference to it.


Saturday, 12 January 2019

My Tiny Beatles Connection

I think I might mention it in one of my Bio entries, but I come from Liverpool, the same place as the Beatles. I don't make a big thing of it - I left at 18, I'm 51 now, so most of my life has been spent away from there. Keen listeners can detect a faint Scouse accent, but that's about it. In truth, as a teenager, Liverpool was a very depressed place, lots of unemployment, and I couldn't wait to start living life elsewhere.

As well as coming from Liverpool, I also like the Beatles. Again, nothing special in that, and many of us feel that particular music is directed at us, personally. If anything, my main love of music was Bob Marley, who sparked my love of reggae and of UK reggae bands such as Aswad. I still love that to this day.

But getting back to the Beatles, there is a vague family connection. When she was a child, my mum lived at 18 Arnold Grove, a small cobbled street of terrace houses in the suburb of Wavertree. At the same time time, George Harrison lived at 10 or 12 Arnold Grove. This would have been during the Forties and Fifties, before the Harrisons moved to the new estate in Speke. My mum's main memory was that Harrison's mum hardly ever let him out to play! I later read that Harrison often used the pseudonym Arnold Grove in order to travel the world anonymously.

In later life, when I was around, my parents moved to the south-Liverpool suburb of Hunts Cross (so, if anything, this is more of my mum's connection than mine) . This was near to Harrison's "new" home is Speke (though this was now the Eighties, when he'd long-since gone), and also not far from one of his later homes in Halewood. It was also not far from Menlove Avenue (Lennon's aunt's home) from Forthlin Road (Paul McCartney's childhood home and a street I had to walk past in order to sign on during the summer!), walkable to Strawberry Field and to St Peter's Church in Woolton. These places are all quite close to each other in south Liverpool. I walked past them all when I went back to Liverpool as a student - I had the time to walk places and besides, couldn't afford much other transport.

I don't pretend that these connections are in any way significant, they're no stronger than anybody else from Liverpool. But certainly anybody growing up in Liverpool was taught that the Beatles were gods, so it is not surprising that I like their music. And George, especially.

Monday, 7 January 2019

Sugar Success

Yay! For the first time in what must be many years, I measured my sugar this morning and it was a "normal" value - 5.5 mmol/l. It's a cause for limited celebration, as obviously the number is good, but I still need to take insulin to get to that level. But whilst I've always had the attitude "it runs a little bit high, but let's make sure it's not too high", this is the first time for many years that somebody could look at my finger-prick result, and not immediately realise that I'm diabetic. So whilst I've automatically conceded, I suppose, that I can't have "normal" sugar levels, actually, I can!

I mean, I measure my sugar every day so I know how much it can fluctuate. So I am just applying logic to it and saying that, in the grand scheme of things, this is just an abnormally low reading in the same vein as the abnormally high reading I got last Saturday (say), so the important thing to watch is my average, not a one-off value.

Of course, it also increases the possibility of hypos, just in terms of my sugar going too low. I've tended to avoid them mostly because I do let my sugar run slightly high, but if I'm down in the realms of the 5s and 6s, there is absolutely no reason why it can't go just little bit further, and go dangerously low. I need to watch out for that, although I do know what a hypo feels like so I should be able to notice if one comes on.

It does make me think, though. Just in terms of the sugar, the stroke, etc. I face this monumental battle each day, counting pretty much every scrap of food that I eat, whereas other people can just get away with eating whatever rubbish takes their fancy. You can't go through life moping "why me?" but you can't help wondering sometimes at what might have been.

I've tried to guard against hypos by immediately reducing my insulin dose, only by 5%. Let's see what my sugar is doing when I'm next fasting. Even if it does go high again, that small amount of difference in insulin must mean that it can't go too high.

Wednesday, 2 January 2019

Drama

We were used to drama over Christmas when daughter lived at home. These ranged from visits to A&E - for example, she would claim to be in agony yet the medical people could find nothing wrong, so you never knew what to think - to visits from the Police, either when she was thought to have done something, or when she'd decided to stay out all night.

Even though she has now left home, the crises haven't totally gone away. I mean, it is better now since we (the parents) are not directly involved, so ultimately we can shrug our shoulders, but it is nevertheless exasperating - my wife and I have over a century of life experience between us, yet daughter insists on making every mistake for herself.

This time, it is her motorbike. A brief history - daughter couldn't wait to get a bike and bought her first off a private ad on gumtree or somewhere. The bike duly turned out to be a dud. A potential lesson there? My own feeling is that you buy from somebody who works for a business servicing bikes for a living. Because it is highly probable that they don't want an angry punter banging on their door a few days later, so it has likely been serviced before it was sold. Plus, if this guy does a good job, they have automatic repeat business. With a private sale, there's none of that, everything is "as seen" so if you're unable to see that the bike has a problem..... Sure, you'll pay more through a dealer, but that's because a lot of the risk shifts their way. Plus, of course, I never had any idea how motor cars worked, but I found people who could be trusted to do a good job.

So, daughter buys a duff bike privately. Does she learn? No. She now had a second bike, also bought privately. She has only just got the thing back onto the road after some other problem, but she rode to our place just before New Year's - the thing kept slipping out of gear and was losing gearbox fluid. Daughter has said to me that even an expert in bikes (she's far from that) wouldn't have spotted this problem without getting dirty with the engine,  and that despite this, the seller was a good guy. So she poo-poo'd my suggestion that this guy had seen her coming. In any case, it misses the point, because a reputable seller would not have allowed this to happen - they'd have their reputation to worry about.

So at the last count, daughter is facing some time off the bike because she can't afford to get it fixed yet. The immediate effect was that she had to use public transport to go to Bournemouth on New Year's, and I know myself how much more inconvenient that is.

As I said at the top, I can afford just to shrug my shoulders here (mostly, although I think the money for this bike came out of my wife's pocket and I worry that she isn't getting a good deal). I'm past the stage of getting upset when I mentioned that the seller probably saw her coming, past getting upset that she assumes he's a stand-up guy, and I'm the idiot for even making the suggestion. It is a shame that whatever I say counts for nought, but I've had this since early teens, so I'm used to it.

Tuesday, 1 January 2019

Happy New Year

I'd like to wish everybody who reads this nonsense all the very best for 2019.

Life is fleeting so, please, don't take it too seriously.