Author Archives: Daragh O Brien

About Daragh O Brien

Daragh O Brien is the Managing Director of Castlebridge Associates. This site has been one of his side projects for a decade. It needs some love and attention...

Schoolboy millionaire dreams

In a story that, in this reader’s view says as much about the lack of imagination of modern youth as it does about information quality management, comes news that a teenager in the UK has found himself stg£300 in debt after using an ATM card his bank sent him.

When the young man went to take some cash out, he was pleased to find that he could take out the maximum £300 and blew it all on the things teenagers blow their money on – iPods and such like. When he later checked his balance he found he had a bank balance of (apparently) stg£2 Million.

The boy had been waiting on payments due to him under the UK Government’s education maintenance allowance (EMA) scheme, under which students get 30 pounds a week to encourage them to stay on at school, so he didn’t initially question how he had sufficient funds in his account for the £300 withdrawal. He was, it seems, overjoyed to find the seven figure sum in his account, apparently as a result of his having gone to school when he should have (although one might suggest he should pay closer attention in maths classes so he can work out how many weeks he’d have to be in school to earn £2 million – the equivalent of 1282 years).

Subsequently the bank corrected its error and the young man found himself £300 over-drawn.
While the bank has suggested that the boy “should have known better” (and it is hard to argue with that), it is clear that the bank did make an error in the information associated to this boy’s account, and that is the IQ Trainwreck here. Some process within the bank erroneously put a large amount of money in the wrong account, resulting in a foolish teenager digging themselves into debt they could not afford (and the lad’s contribution to his own woes cannot be ignored).

Medication errors affect 1 in 25 in leading Irish Hospital (or does it?)

[UPDATE]: To carry home the challenges of managing and measuring the quality of information at times, Beaumont Hospital have issued the following press statement regarding the issue mentioned below (this statement is copied from the comment below).

STATEMENT BY BEAUMONT HOSPITAL RE OMBUDSMAN’S REPORT
The Office of the Ombudsman issued a report this morning which highlighted a complaint against Beaumont Hospital regarding the circumstances in which an unprescribed dosage of medication was given to a patient. In her press release, the Ombudsman made reference to an audit of the Kardex system at Beaumont. A figure of 4.3% was given for Kardex transcription errors.

For purposes of absolute clarity, Beaumont Hospital points out that this audit was of approximately 170 reported medication events over a period of two years. This showed there were seven reports of errors made in the transcription of information between Kardex. This is the 4.3% referred to by the Ombudsman and is not 4.3% of all medications administered. It should also be noted that the audit was not of the hospital’s full Kardex system.

There are approximately 500,000 prescriptions written in Beaumont each year and approximately 4.5 million administrations of medication under these prescriptions.

We thank Beaumont Hospital for the clarification presented and gladly publish it in full. The detail contained in the statement from Beaumont Hospital highlights another impact of poor quality information – the negative publicity and causes of concern that can arise from incomplete information made available to the media.

[/Update] 

The Irish Times website carries a story this afternoon of the report by the Ombudsman into medication errors in a leading Irish hospital.

According to the report, Beaumont hospital experienced medication errors in just over 1 in every 25 cases (4.3%) [Note – this figure is clarified by Beaumont Hospital in the update above]  The root cause of this error rate would seem to be the way in which medications and medication instructions are recorded, with key information being recorded manually on patient record cards and certain key data (such as frequency of dosage) occasionally being omitted for a variety of reasons. Furthermore, the transcription of information from patient record cards which have been filled up can lead to errors in transcription, resulting in errors in patient medication.[Beaumont Hospital clarification: “this audit was of approximately 170 reported medication events over a period of two years. This showed there were seven reports of errors made in the transcription of information between Kardex. This is the 4.3% referred to by the Ombudsman and is not 4.3% of all medications administered. It should also be noted that the audit was not of the hospital’s full Kardex system.”]

Given the implications of incorrect medication, both in terms of injury or death of patients or, at the very least, the increased duration of stay for a patient arising from treatment errors.

The Institute of Medicine in the US has published figures which show that the cost to the Healthcare system (in 2006 dollars) per incident of medication error was around $8750 per hospital stay. An article on the website FutureHealthCareUS.com quotes other studies which put the cost at just under $6000 per event.

Given the impact on human health and welfare (up to and including risk of death) and the financial impact on already overstretched healthcare systems, avoidable medication errors count as a definite IQ Trainwreck.

Tracker mortgage off target

RTE news today reports that AIB Bank (one of the largest banks in Ireland) has admitted an error in applying interest rate changes over a 12 month period to so-called ‘tracker’ mortgages.

This has resulted in customers having underpaid their loans in recent months. The bank is, kindly, offering the affected customers the option of paying the shortfall in one go or spread over the remaining period of their mortgage.

‘Manual Error’ is blamed for the problem, which (according to RTE) affects 500 customers.

Tracker mortgages track the base rate of a specific Central Bank (in Ireland this is the European Central Bank), with a fixed margin payable on top of the base rate.

[Update] The Irish Times this morning reports that the Irish Financial Services Regulator is to examine the Bank’s approach to recouping the under-paid mortgage amounts. Quoting a spokesperson for the Regulator:

“In instances where an institution is seeking to recoup money as a result of the failure of its own internal systems we would expect it to be flexible in terms of the arrangements it comes to with consumers”

This story is also carried in the Irish Examiner news paper today

The Butterfly Effect

I’m sure most of you are familiar with the concept of the “Butterfly Effect“, that part of Chaos theory that tells us that the small disturbances of the air by a butterfly’s wings in Cleveland can cause a natural disaster on the far side of the world.

A popular myth is that the term ‘bug’ as applied to software glitches was coined by Admiral Grace Hopper after moths (and perhaps butterflies) were removed from the machinery of a Mark II Univac computer which had stopped working.

These two tidbits are related by a recent story in the Financial Times about how ‘coding errors’ (bugs) in computer models has resulted in a debt rating agency having to acknowledge they’d ranked investment vehicles wrongly and as a result increased the risk exposure of investors in those funds.

From the FT:

Moody’s is moving to re-examine the accuracy of all its computer models and place them under a centralised monitoring system after it formally acknowledged earlier this week that a glitch had appeared in one such mathematical model used to rate complex products.

Later in the article:

The moves come after the agency admitted on Tuesday that a “coding bug” had led the agency to incorrectly award top notch triple-A ratings to about $1bn of complex instruments known as constant proportion debt obligations (CPDOs) in 2006. This bug was first revealed in an FT investigation in May.

So, the bugs were found by a newspaper investigation in May 2008.. embarassing. The bugs affected the ratings applied to these CPDOs, and may have distorted the investment strategies of institutional investors. The Financial Times article in May tells us that:

The products were designed for institutional investors. In the recent credit market turmoil, those who still hold the products will have suffered some paper losses while others who have bailed out have lost up to 60 per cent of their investment.

Sheesh… up to 60% losses on investments. And it hit the papers.

The FT (28th April 2008) reports that Ratings agencies are coming under increased pressure to assure the quality of the information used in assigning credit ratings. Ratings agencies are reported to have told Regulators that:

Guaranteeing the quality of information used to assign credit ratings on structured finance securities would be “overly burdensome and redundant”

However, the burden and cost of avoiding bugs in software, processes and controls that impact on the quality of key information used in the Financial markets should be weighed against the risk of financial ‘natural disasters’ where decisions are made on foot of inaccurate information.

[Update] It would seem that the SEC and the European Commission (the civil service of the EU)  are intending to take action to regulate and regularise the dealings of these ratings agencies…[/Update]

Leap Year problem hits Irish bank

The Sunday Business Post newspaper (Ireland’s leading weekly paper dedicated to business news) carried a story this week about errors in calculating mortgage interest due to the 2008 Leap Year which have affected at least one Irish bank. This is an information quality problem we discussed previously on this blog.Of course, the bank’s are simply going to apply the interest missed out to the customer’s accounts retrospectively, with the average additional charge to customers being around €28.50, according to reports. However, the fact that this error has appeared in the national media, and the Halifax’s competitors are all stating that they have had no such problems, suggests that the cost to the bank may be greater in terms of negative PR. In this case the bank made a gross error in defining its information architecture and the core business rules for interest calculations (such as assuming 2008 was not a leap year), and it would seem their systems testing failed to catch the problem until after the event. However, as is often the case, the cost of non-quality information is being passed to the customer, making the immediate ‘problem’ go away (a shortfall in interest payments and profits) while masking the underlying root cause (failure to properly define and test information processing rules for core processes resulting in poor quality information). 

An electric (bill) shock

Courtesy of Cambridge News comes this story of a shocking electricity bill.

British Electricity provider N-Power sent a Cambridge woman a bill recently for just over stg£90million (US$ 177million). This was bemusing to her because she has availed of a pre-paid electricity meter. It would seem that for the woman to have run up such a bill would have taken over 1900 years.

As an aside, the Cambridge News article also higlights a recent survey from British website www.moneysupermarket.com:

 A survey last month showed 34 per cent of people have spotted an error in a utility or credit card bill in the past 12 months, while 17 per cent were overcharged during the past quarter.

The survey by financial website moneysupermarket.com reveals half of us don’t bother to check bills.

British Gas Billing leaves explosive whiff in the air….

The Register today reports that British Gas (aka Centrica) is taking legal action against international consulting firm Accenture after a total overhaul of their billing systems costing stg£300m resulted in customers being incorrectly billed (in some instances on multiple accounts – for one customer at the same address). British Gas claims that it has had to hire 2500 extra staff to work on fixing the problems. According to The Register, GB has already written off £200m resulting from customer complaints. This means that the minimum you should estimate for the total cost of non-quality here is a figure to the north of £500m sterling (Cost of implementation + costs of scrap and rework  = ‘First cut Cost of Non-Quality). For readers in the US, that is nearly US$1bn.

And that is BEFORE the lawyers get involved. And before you take into account the cost to British Gas of lost customer revenues when customers switch to a rival supplier to get away from the problems.

British Gas claim that Accenture are responsible for implementing  a system which didn’t work and which had “fundamental errors” in its design and implementation. Accenture, for its part, rejects the British Gas claims saying that:

“Centrica directed the design, build and implementation of the Jupiter system and insisted on many of the features they now find problematic. At their own choice, after extensive testing, in March 2006 Centrica took over total control over all aspects of the system about which they now complain and has operated the system themselves for over two years.”

Accenture will be ‘vigourously defending’ the High Court action. To translate this:

  1. It’s in the English High Court (“ka-ching” says the lawyer’s cash register)
  2. It will be an aggressive case (meaning lots of lawyers with cash registers going “ka-ching”).
  3. Customers (of Accenture and/or British Gas) will wind up paying the price in the end (the ‘Lawyers who like to say “Ka-Ching”‘ will require paying).

So, is this an IQ Trainwreck?

Yes it is. There is a significant cost to British Gas already incurred, with further costs to arise for both British Gas and Accenture. However the real impact has been on British Gas customers, who have wrestled with incorrect billing issues and related frustrations since the system went live.

Andrew Brooks, (one of our IAIDQ members in the UK and a man with some experience in these types of projects it would seem) has a nice post on his blog about the real root cause here. He makes some very valid points about who was (or should have been) driving this particular train when it went off the rails. His short post is well worth a read.

Continue reading

A salutory tale of poor IQ

Gizmodo.com occasionally features ‘localisation’ problems (they spell it with a ‘z’, yet another localisation problem). As localisation raises challenges of customer expectation, information design, information presentation and a whole heap of other potential tripwires for Information Quality disasters, this is sometimes a good source of quick examples of how poor quality information can screw up processes.

Sometimes, however, there are stories that take it to such an extreme that they move out of the realm of ‘localisation problem’ and into the domain of ‘Information Quality trainwreck’. This following story is just such a tale. (the full Gizmodo article can be found at this link) Continue reading

Aer Lingus pricing blunder brings everyone back down to earth (and now the lawyers are involved!)

The IAIDQ is holding its annual US conference (the IDQ Conference) in San Antonio this September. As a Director of the Association and a potential speaker at the event I’ve been researching my options for flying to the US as cheaply (but comfortably) as possible.

Imagine my dismay when I spotted that I’d missed an opportunity to take advantage of an IQ Trainwreck to get myself to the US on Business class for less than it costs me to get home from work!

Ireland’s RTE news is today reporting that Aer Lingus has cancelled the bookings made by passengers who tried to avail of a €5 (US$8.00 approx) Business Class fare from Dublin to the US, a flight that normally costs €1,775 (just under US$3,000). [update 2008-04-18]Patrick O’Beirne of Systems Modelling Ltd in Gorey has pointed out to me in an email that the <u>actual</u> cost of the flights was a bit higher when taxes, charges and the relative position of the sun are taken into account[/update]

This fare was available on the aerlingus.com website between 7:30am and 9:00am yesterday after (apparently) ‘promotional’ fares were loaded to the website in error. Around 100 people (some sources have it at 300 people, so I can’t vouch for the accuracy of this figure) managed to book the €5 fare, resulting in a potential loss to the airline of at least€177,700 (just under US$280,000).

The airline sent emails to the customers informing them that they had cancelled the bookings as the price was in error, however the Consumer Association has pointed out that the 100 people had valid contracts. The CEO of the National Consumer Agency has sought a meeting with the airline to discuss the situation.

The airline has argued that the fact that ‘economy class’ seats were advertised on the website at €249 should have suggested that there was an error in the €5.00 price.

However, the Press Release from the National Consumer Agency is quite clear that Aer Lingus would be in breach of contract in cancelling the flights and that “blaming a technical error in their booking system is not good enough”.

[update 2008-04-18] It has been reported this morning that a group of 50 property developers who had booked flights at the €5.00 price are starting legal proceedings to force Aer Lingus to honour their contracts. As we don’t have the concept of a class action suit here in Ireland, unless these property developers are part of a consortium that is a legal entity in its own right, that means that Aer Lingus is potentially facing 50 court cases, each requiring legal representation that will cost a lot more than the €17770 shortfall in the ticket price.

Ah… you just have to love lawyers.

Why is this an IQTrainwreck?

Cost to Aer Lingus of honouring the contracts will be €177700. The cost to the airline of the PR fall out from cancelling the contracts would also be significant. The legal costs that will arise now are also likely to be significant.

It’s the end of the world as we know it… or is it?

Yahoo is today carrying a story from AFP about a 13 year old German school boy who has corrected NASA’s calculations on the probability of ‘planet killer’ asteroid Apophis crashing into earth and causing a global catastrophe. The wunder-kind in question did his analysis as part of a regional science competition.

It seems that NASA forgot to factor in the affect of Apophis hitting one or more of the numerous satellites that orbit the earth in close proximity to the path the Asteroid will take on its next pass past the Earth in 2029. Apparently, if it hits a satellite the odds of Apophis hitting the earth in 2036 drop from a lottery-like 1 in 45,000 to a more troubling 1 in 450.

The IQ issue here is completeness of information. NASA failed to take into account the satellites in its risk model, resulting in a whopping understatement of the risk to the planet.

The short-term IQ Trainwreck comes about because the NASA scientists were corrected by a 13 year old. The long term IQ Trainwreck comes about because the 1 in 45,000 odds are probably firmly fixed in the minds of disaster recover planners around the world giving rise to degree of complacency, whereas a 1 in 450 risk might prompt some consolidated efforts to figure out how to properly manage the risk of Apophis hitting the earth or handling the ensuing global catastrophe.

However, more recent reports this afternoon suggest that the wunderkind may be a blunder-kind and may have based his model on some incorrect assumptions about the path of the asteroid. Oh dear.

In any event, the fact that a teenager is interested in this and that he researched the possiblity of the risks is commendable. Hopefully someone will take the time to reassess his work and determine if he is wrong or just not as right as he thought, improving the accuracy of the prediction models for Apophis.

Good quality information can help save the planet.  Poor quality information can send people unnecessarily into a panic.