Category Archives: Utilities IQ Trainwrecks

Gas by-products give a pain in the gut

Courtesy of Lwanga Yonke comes this great story about how the choice of unit of measure for reporting, particularly for regulatory reporting or Corporate Social Responsibility reports can be very important.

The natural gas industry’s claim that it is making great strides in reducing the polluted wastewater it discharges to rivers is proving difficult to assess because of inconsistent reporting and a big data entry error in the system for tracking contaminated fluids.

The issue:

Back in February the Natural Gas industry in the US released statistics which appeared to show that they had managed to recycle at least 65% of the toxic waste brine that is a by-product of natural gas production. Unfortunately they had their data input a little bit askew, thanks to one company who had reported data back to the State of Pennsylvania using the wrong unit of measure – confusing barrels with gallons.

For those of us who aren’t into the minutiae of natural gas extraction, the Wall Street Journal helpfully points out that there are 42 gallons in a barrel. So, by reporting 5.2 million barrels of wastewater recycled instead of the 5.2 million gallons that were actually recycled, the helpful data entry error overstated the recycling success by a factor of 42.

Which is, co-incidentally, the answer to Life the Universe and Everything.

According to the Wall Street Journal, it may be impossible to accurately identify the rate of waste water recycling in the natural gas industry in the US.

Not counting Seneca’s bad numbers — and assuming that the rest of the state’s data is accurate — drillers reported that they generated about 5.4 million barrels of wastewater in the second half of 2010. Of that, DEP lists about 2.8 million barrels going to treatment plants that discharge into rivers and streams, about 460,000 barrels being sent to underground disposal wells, and about 2 million barrels being recycled or treated at plants with no river discharge.

That would suggest a recycling rate of around 38 percent, a number that stands in stark contrast to the 90 percent recycling rate claimed by some industry representatives. But Kathryn Klaber, president of the Marcellus Shale Coalition, an industry group, stood by the 90 percent figure this week after it was questioned by The Associated Press, The New York Times and other news organizations.

The WSJ article goes on to point out that there is a lack of clarity about what should actually be reported as recycled waste water and issues with the tracking of and reporting of discharges of waste water from gas extraction.

At least one company, Range Resources of Fort Worth, Texas, said it hadn’t been reporting much of its recycled wastewater at all, because it believed the DEP’s tracking system only covered water that the company sent out for treatment or disposal, not fluids it reused on the spot.

Another company that had boasted of a near 100 percent recycling rate, Cabot Oil & Gas, also Houston-based, told The AP that the figure only included fluids that gush from a well once it is opened for production by a process known as hydraulic fracturing. Company spokesman George Stark said it didn’t include different types of wastewater unrelated to fracturing, like groundwater or rainwater contaminated during the drilling process by chemically tainted drilling muds.

So, a finger flub on data entry, combined with lack of agreement on meaning and usage of data in the industry, and gaps in regulation and enforcement of standards means that there is, as of now, no definitive right answer to the question “how much waste water is recycled from gas production in Pennsylvania?”.

What does your gut tell you?

 

Smart Grid, Dumb Data

In September 2010 a massive gas explosion ripped through the San Francisco suburb of San Bruno, not too far from San Francisco International Airport. The explosion was so powerful it was registered as a magnitude 1.1 earthquake.

Subsequent investigations have identified that poor quality data was a contributory factor in the disaster. According to Fresnobee.com

The cause of the deadly rupture has not yet been determined, but the PUC said it is moving ahead with the penalty phase after the National Transportation Safety Board recently determined that PG&E incorrectly described the pipe as seamless when in fact it was seamed and welded, making it weaker than a seamless pipe.

Read more: http://www.fresnobee.com/2011/02/25/2285689/pge-faces-big-fine-over-gas-pipeline.html#

According to the San Francisco Chronicle the problems with PG&E’s data were nothing new, with problems stretching back almost 20 years.

Omissions or data-entry errors made when the system was developed – and left uncorrected – may explain why PG&E was unaware that the 1956-vintage pipeline that exploded in San Bruno on Sept. 9, killing eight people, had been built with a seam, according to records and interviews. Federal investigators have found that the explosion started at a poorly installed weld on the seam.

Continue reading

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