• Privacy policy
  • T&C’s
  • About Us
    • FAQ
    • Meet the Team
  • Contact us
TLE ONLINE SHOP!
  • TLE
  • News
  • Politics
  • Business
  • Sport
  • Opinion
  • Elevenses
  • Entertainment
    • All Entertainment
    • Film
    • Lifestyle
      • Horoscopes
    • Lottery Results
      • Lotto
      • Thunderball
      • Set For Life
      • EuroMillions
  • Food
    • All Food
    • Recipes
  • Property
  • Travel
  • Tech/Auto
No Result
View All Result
The London Economic
SUPPORT THE LONDON ECONOMIC
NEWSLETTER
  • TLE
  • News
  • Politics
  • Business
  • Sport
  • Opinion
  • Elevenses
  • Entertainment
    • All Entertainment
    • Film
    • Lifestyle
      • Horoscopes
    • Lottery Results
      • Lotto
      • Thunderball
      • Set For Life
      • EuroMillions
  • Food
    • All Food
    • Recipes
  • Property
  • Travel
  • Tech/Auto
No Result
View All Result
The London Economic
No Result
View All Result
Home News

IT experts react with disbelief following Test and Trace blunder

Limitations of commercial off-the-shelf products such as Excel for medical uses are "well-known".

Jack Peat by Jack Peat
2020-10-05 16:30
in News
FacebookTwitterLinkedinEmailWhatsapp

IT experts have questioned why Public Health England used Excel for a scheme as large as NHS Test and Trace after a technical error led to nearly 16,000 cases going unreported.

The issue occurred when people who tested positive were not recorded once an Excel spreadsheet reached its maximum size, a spokesman for Public Health England (PHE) told the PA news agency on Monday morning.

This resulted in 15,841 cases between September 25 and October 2 being left out of the reported daily coronavirus cases, causing a delay in efforts by NHS Test and Trace to find the contacts of those who tested positive for the virus.

Computing experts and academics told PA it is “very surprising” that Excel was used for something of this scale and said such a system should have been adequately tested.

“It is surprising that an enterprise scale system is expected to run on Excel”

“It is very surprising to hear that an enterprise scale system, presumably developed by professional technologists, is expected to run on Excel,” said Adam Leon Smith, fellow of BCS, The Chartered Institute for IT, and chair of BCS’s special interest group in software testing.

“Many large organisations refer disparagingly to Excel-based applications as ‘end-user driven architectures’ and spend lots of time trying to decommission them for reasons relating to security, control and stability.

“This is mostly because Excel is designed for end-users not complex systems, has well-known scalability limits, and will not handle unexpected situations in a way that interacting systems will be able to recognise.

RelatedPosts

Stunned response as Linda Robson tells Loose Women panel she thinks Boris Johnson is a ‘decent man’

Laurence Fox told to pay £36k legal fees for drag artist and Stonewall executive

Guns banned at Trump’s NRA address

‘Is that it?’: PM’s lapdog newspapers tell Brits to move on over Partygate

“It sounds like these limitations have manifested in real problems in this case, and this is exactly why databases are normally used in enterprise applications.

“Even if presented with a system that did rely on Excel, one of the first things that should have been identified through a testing process was a limit to the data volume it could process.”

Dr Peter Bannister, executive chair for the Institution of Engineering and Technology Healthcare Sector, said limitations of commercial off-the-shelf products such as Excel for medical uses are well-known.

“It’s disappointing to read that a lack of awareness around the limitations of a consumer software product has led to such a negative impact for all those who are relying on the Covid testing programme,” he said.

Off-the-shelf products require additional testing

“It’s widely known within medical device development that the use of commercial off-the-shelf products, such as Excel, requires additional testing to ensure that they are able to meet the stringent requirements of use in a healthcare setting.”

The Excel spreadsheet reached its maximum file size, which stopped new names being added in an automated process, PA was told.

The files have now been split into smaller multiple files to prevent the issue happening again.

Jon Crowcroft, Marconi Professor of communications systems from the University of Cambridge, said file size is a “basic consideration”.

“One would think that a software engineer would have considered a worst-case test scenario for any system design – on paper before you even get to writing code – just to make sure it wouldn’t blow up in any way like this,” he explained.

“The limitations of Excel in terms of big data, which is generally a very decent piece of software, are well-known – if you look at how many people are expressing astonishment at this online, you can see that.”

He continued: “There are many big systems in Government (eg DVLA’s or HMRC’s) that work at this scale so there’s no excuse.

“Also, a simple sanity check on the data or error checks in the system might have told them when they hit this limit instead of discovering it after the event.

“This sort of thing is standard in sixth form or undergraduate computer science training too.”

Related: Pope Francis laments ‘unhealthy populism’ as he outlines blueprint for post-Covid world

Since you are here

Since you are here, we wanted to ask for your help.

Journalism in Britain is under threat. The government is becoming increasingly authoritarian and our media is run by a handful of billionaires, most of whom reside overseas and all of them have strong political allegiances and financial motivations.

Our mission is to hold the powerful to account. It is vital that free media is allowed to exist to expose hypocrisy, corruption, wrongdoing and abuse of power. But we can't do it without you.

If you can afford to contribute a small donation to the site it will help us to continue our work in the best interests of the public. We only ask you to donate what you can afford, with an option to cancel your subscription at any point.

To donate or subscribe to The London Economic, click here.

The TLE shop is also now open, with all profits going to supporting our work.

The shop can be found here.

You can also SUBSCRIBE TO OUR NEWSLETTER .

Subscribe to our Newsletter

View our  Privacy Policy and Terms & Conditions

Trending on TLE

  • All
  • trending
Abdollah

‘Rescue us’: Afghan teacher begs UK to help him escape Taliban

CHOMSKY: “If Corbyn had been elected, Britain would be pursuing a much more sane course”

What If We Got Rid Of Prisons?

More from TLE

Labour ruling body release timetable for leadership battle to replace Corbyn

Funniest Tweets after it was revealed Stonehenge builders were “Turkish”

Better service could boost consumer spending by £64.6 billion a year

Restaurant Review – Bob Bob Ricard

Watch – Teenager hoping to become first professional footballer with cystic fibrosis attending Manchester City training camp

Aberdeen Frontier Markets – Incentivised to perform

Watch: Farage gets off to a bumpy start on GB News

The Lions Debacle

Carjackers who used a “grotesque level of violence” to steal luxury motors are jailed

Trump drive-by dubbed “insanity” by Walter Reed physician

About Us

TheLondonEconomic.com – Open, accessible and accountable news, sport, culture and lifestyle.

Read more

© 2019 thelondoneconomic.com - TLE, International House, 24 Holborn Viaduct, London EC1A 2BN. All Rights Reserved.




No Result
View All Result
  • Home
  • News
  • Politics
  • Business
  • Sport
  • Entertainment
  • Lifestyle
  • Food
  • Travel
  • More…
    • Elevenses
    • Opinion
    • Property
    • Tech & Auto
  • About Us
    • Meet the Team
    • Privacy policy
  • Contact us

© 2019 thelondoneconomic.com - TLE, International House, 24 Holborn Viaduct, London EC1A 2BN. All Rights Reserved.