• SOLUTIONS
    • Quality

      QUALITY

      Quality management solution

      Embed quality throughout your business processes by aligning and centralising all key functions to elevate your organisation to its full potential.

      Find out more

      CASE STUDY

      JAE Oregon take ownership of ISO 9001 and 14001 compliance activities.

      BUSINESS NEEDS

      • APQP
      • ISO & Certifications
      • CAPA management
      • First article inspection report
      • Product part approval process
      • Quality management
      • Supplier management
      • Document management
      • Quality control

      INDUSTRIES

      • Aerospace and defence
      • Life science
      • Manufacturing
      • Healthcare
      • Food and drink
      • Pharmaceuticals
    • Health, safety and environmental

      HEALTH, SAFETY AND ENVIRONMENTAL

      Health, safety and environmental management solutions

      Reduce risk, protect your people and drive sustainability, efficiently and effectively

      Find out more

      CASE STUDY

      News Corp streamline essential workplace training to suit everyone.

      BUSINESS NEEDS

      • Safety management
      • Incident management
      • Health and safety training solution
      • Enviromental

      INDUSTRIES

      • Food and drink
      • Energy
      • Transport and logistics
      • Aviation
    • Audit and risk

      AUDIT AND RISK

      Audit and risk management solutions

      Our powerful audit and risk management solutions help you protect your business, its customers and your corporate clients.

      Find out more

      CASE STUDY

      Cadence Bank integrate audit and risk to create a more powerful system.

      BUSINESS NEEDS

      • Internal audit
      • Risk management
      • External audit tools

      INDUSTRIES

      • Finance
      • Government
      • Education
    • Collaboration

      COLLABORATION

      Collaboration solution

      Bring your people, content and actions together with highly secure, cloud-based collaboration solutions.

      Find out more

      CASE STUDY

      Altera meet CMMI best practices with better control and efficiency.

      BUSINESS NEEDS

      • Bids and proposals
      • Document redaction
      • Document co-authoring and review

      INDUSTRIES

      • Aerospace and defence
      • Life Sciences and pharmaceuticals
      • AEC
    • PRODUCTS
    • Q-Pulse QMS
    • Q-Pulse PM
    • Q-Pulse WorkRite
    • Q-Pulse Law
    • Pentana Audit
    • Pentana Disclose
    • Pentana Risk
    • PleaseReview
    • Coruson
    • Ideagen Academy
    • Huddle
    • Qualtrax
    • InspectionXpert
    • Mi-Co
    • CompliSpace
    • OpsBase
    • Audit Analytics
    • Mail Manager
    • CompliancePath

    FEATURED RESOURCES

    CASE STUDY

    Q-Pulse enabled Anthony Nolan to meet a range of regulations and stay compliant.

    • INDUSTRIES
    • Aerospace and defence
    • Aviation
    • Energy
    • Financial services
    • Healthcare
    • Life science
    • Manufacturing
    • Pharmaceuticals
    • Transport & logistics
    • Food & drinks
    • AEC
    • Government

    FEATURED RESOURCES

    CASE STUDY

    Mettle Ops achieve AS9100 compliance with zero non-conformances.

    CASE STUDY

    NWDC drastically reduces time spent on creating documents.

    • RESOURCES
    • By Industry

      BY INDUSTRY

      • Aerospace and defence
      • Aviation
      • Energy
      • Financial services
      • Healthcare
      • Life science
      • Manufacturing
      • Rail

      FEATURED RESOURCES

      WHITEPAPER

      Manage anti-money laundering regulations in the UK and EU.

      CASE STUDY

      Nuffield Health establish a central database for pathology compliance activities.

    • By Solution

      BY SOLUTION

      • Quality
      • Safety
      • Environmental
      • Regulatory
      • Documents
      • Audit
      • Risk

      FEATURED RESOURCES

      WHITEPAPER

      Manage anti-money laundering regulations in the UK and EU.

      CASE STUDY

      Nuffield Health establish a central database for pathology compliance activities.

    • By Product

      BY PRODUCT

      • Q-Pulse QMS
      • Q-Pulse Law
      • Q-Pulse WorkRite
      • Q-Pulse PM
      • Pentana Audit
      • Pentana Disclose
      • Pentana Risk
      • Pleasereview
      • Coruson
      • Ideagen Academy

      FEATURED RESOURCES

      WHITEPAPER

      Manage anti-money laundering regulations in the UK and EU.

      CASE STUDY

      Nuffield Health establish a central database for pathology compliance activities.

    • By Resource Type

      BY RESOURCE TYPE

      • Brochures
      • Case studies
      • Flyers
      • Blog
      • White papers

      FEATURED RESOURCES

      WHITEPAPER

      Manage anti-money laundering regulations in the UK and EU.

      CASE STUDY

      Nuffield Health establish a central database for pathology compliance activities.

    View All Resources
    • COMPANY
    • About Us

      ABOUT US

      • Our company
      • Leadership team
      • Objectives
      • Strategy
      • Values
      • Our customer focus
      • Certifications
      • Investors

      FEATURED RESOURCES

      CAREERS

      We are recruiting! Take the next exciting step in your career

      VALUES

      We are ambitious - We are adventurous - We are community

    • Events and Updates

      EVENTS AND UPDATES

      • Events
      • News
      • Blogs

      FEATURED RESOURCES

      CAREERS

      We are recruiting! Take the next exciting step in your career

      VALUES

      We are ambitious - We are adventurous - We are community

    • Careers

      CAREERS

      • Careers overview
      • Current vacancies

        HIRING

      • Benefits
      • Apprenticeships
      • Meet our teams

      FEATURED RESOURCES

      CAREERS

      We are recruiting! Take the next exciting step in your career

      VALUES

      We are ambitious - We are adventurous - We are community

  • Contact Sales
Menu
  • Solutions
    • « Back
    • Solutions
    • Quality
      • « Back
      • Quality
      • Quality management solution

        Embed quality throughout your business processes by aligning and centralising all key functions to elevate your organisation to its full potential.

      • Find Out More

      APQP

      CAPA management

      ISO & Certifications

      First article inspection report

      Product part approval process

      Supplier management

      Quality Control

      Quality management

      Document management

      Aerospace and defence

      Life science

      Manufacturing

      Healthcare

      Food and drink

      Pharmaceuticals

      Contact us
    • Health, safety and environmental
      • « Back
      • Health, safety and environmental
      • Health, safety and environmental management solutions

        Reduce risk, protect your people and drive sustainability, efficiently and effectively

      • Find Out More

      Safety management

      Incident management

      Health and safety training solution

      Enviromental

      Food and drink

      Energy

      Transport and logistics

      Aviation

      Contact us
    • Audit & Risk
      • « Back
      • Audit & Risk
      • Audit and risk management solutions

        Our powerful audit and risk management solutions help you protect your business, its customers and your corporate clients.

      • Find out more

      Internal audit

      Risk software

      External audit software

      Finance

      Government

      Education

      Contact us
    • Collaboration
      • « Back
      • Collaboration
      • Collaboration solution

        Bring your people, content and actions together with highly secure, cloud-based collaboration solutions.

      • Find Out More

      Bids and proposals

      Document redaction

      Document co-authoring and review

      Aerospace and defence

      Life Science and Pharmaceuticals

      AEC

      Contact Us
    Contact us
  • Products
    • « Back
    • Products
    • Q-Pulse QMS

      Q-Pulse PM

      Q-Pulse WorkRite

      Q-Pulse Law

      Pentana Audit

      Pentana Disclose

      Pentana Risk

      PleaseReview

      Coruson

      Ideagen Academy

      Audit Analytics

      Mail Manager

      CompliancePath

      Huddle

      Qualtrax

      InspectionXpert

      Mi-Co

      CompliSpace

      OpsBase

    Contact Us
  • Industries
    • « Back
    • Industries
    • Aerospace and defence

      Aviation

      Energy

      Finance

      Healthcare

      Life science

      Manufacturing

      Pharmaceuticals

      Transport & logistics

      Food & drinks

      AEC

      Government

    Contact Us
  • Resources
    • « Back
    • Resources
    • By Industry
      • « Back
      • By Industry
      • Aerospace and defence

        Aviation

        Energy

        Financial services

        Healthcare

        Life science

        Manufacturing

        Rail

      • View all resources
      Contact us
    • By Solution
      • « Back
      • By Solution
      • Quality

        Safety

        Environmental

        Regulatory

        Documents

        Audit

        Risk

      • View all resources
      Contact us
    • By Product
      • « Back
      • By Product
      • Q-Pulse QMS

        Q-Pulse Law

        Q-Pulse WorkRite

        Q-Pulse PM

        Pentana Audit

        Pentana Disclose

        Pentana Risk

        Pleasereview

        Coruson

        Ideagen Academy

      • View all resources
      Contact us
    • By Resource Type
      • « Back
      • By Resource Type
      • Brochures

        Case studies

        Flyers

        Blog

        White papers

      • View all resources
      Contact us
    Contact us
  • Company
    • « Back
    • Company
    • About us
      • « Back
      • About us
      • Our company

        Leadership team

        Objectives

        Strategy

        Values

        Our customer focus

        Certifications

        Investors

      Contact us
    • Events and updates
      • « Back
      • Events and updates
      • Events

        News

        Blogs

      Contact us
    • Careers
      • « Back
      • Careers
      • Careers overview

        Current vacancies

        Benefits

        Apprenticeships

        Meet our teams

      Contact us
    Contact us
Contact Us
  • Home
  • Thought Leadership
  • Blog
  • The Problem with Spreadsheets

The Problem with Spreadsheets

11 April 2019

illustration showing piles of spreadsheets
The Problem with Spreadsheets

Share this

For decades, spreadsheets have been seen as being a necessary evil in the management of various business tasks and analysis. There are a number of reasons why companies in a range of sectors are moving away from these error-prone methods of logging quality and safety incidents and analysing key performance indicators (KPIs).

Data-related incidents continue to dominate the airwaves - whether it's data breaches or data errors ("we forgot to add the extra 0"), with flaws here often impacting negatively upon share prices and reputations. The aerospace and defence sector is one industry which is making a positive step towards more robust and reliable methods of managing company-wide quality, but some companies are only just recognising the need to make this step change.

I have compiled the list of top 7 reasons why this is being done now with urgency:

  1. Ambiguity and Uncertainty on the Master Document - "we've gone onto the Q:// Drive and opened the file, but is it the current version? Also, department X has the original checked out, so I can only open a read-only version - I'll get round to it later..." Yeah right, you'll forget about it - this is a substantial risk!

  2. No single source of the truth - "management reports need to be pulled together from multiple departments and systems for this months quality and safety reports"- when is the "data date"? - an incident could happen that very morning and not be logged. Providing management with an overview of all business risks, quality and safety management at the click of a button not only saves time, but it is also proven to capture business information more easily and accurately.

  3. Manual effort and re-keying of data - many people use spreadsheets every single day, with degrees in quality management and years' of experience - not degrees in using Microsoft Excel or Access. Even with this experience, there is a risk of re-keying data incorrectly. Quality and safety managers can bring much more to the table, instead of spending hours worth of time in spreadsheets and databases and setting up pivot tables.

  4. Analysis of data - chasing for accurate information is a challenge and frustration. Our background in the aerospace and defence industry software typically shows that experienced quality managers using Excel are often spending most of their week chasing colleagues and peers for material, reports and the most up-to-date information - instead of streamlining processes and taking a birds-eye view of supplier non-conformances, audits, the cost of poor quality and safety and putting plans in place to reduce the chance of incidents happening again.

  5. A single point of failure - "why won't the links in sheet 5, open properly?", "Oh yeah, Jim set up those links and Macros a while ago" (Jim left 3 months ago...). Spreadsheets that link to documents within complex file structures can very easily end up being broken or dead if not managed strictly and every minute of the day. In the event of Macros being set up and formulas, this risk is heightened and repeated across business units, locations and countries.

  6. Growth pains - "these spreadsheets and databases are getting out of hand, we're going to need more people to keep pace with demand!" Doing things 'the way they've always been done' seems like an easy option, but it can often be counter-productive. Overall the costs involved in recruiting even one or two more people can soon offset the cost of investing in a quality management tool.

  7. Business continuity and inflexibility - "I'm working on a client site this week, can we perform this audit on our mobile phones?" Inflexible quality management in Excel spreadsheets or Access Databases means that data may need to be captured on paper and re-typed (a risk we've already looked at) or may involve laptops being taken externally. We're all using mobile phones and tablets for hours each day (maybe you're reading this on one) - there is a trend towards this method of working and performing whilst on the move.

There are obviously many more points we could add onto this list, but these are the main frustrations and pains that can be automated and eased with the use of a more centralised and consistent quality management software package. In the words of former US president, Jimmy Carter, "War may sometimes be a necessary evil. But no matter how necessary, it is always an evil, never a good". Albeit he was speaking on war, but the everyday battles with spreadsheets are much the same theme.

Ideagen works with a number of the world's leading maintenance, repair and overhaul (MRO) companies, aerospace and defence firms and top airlines to increase efficiency in quality and safety management.

Learn more about modernising your quality management. 

Ideagen's Greig Duncan
Written by

Greig Duncan

Within his role at Ideagen, Greig works as part of the aviation, aerospace and defence team – responsible for industry-leading software tools that help to boost safety, quality and proactive risk management within the world's largest organisations.

Greig’s career to date has been dominated by safety, risk and technology-driven roles within the offshore emergency response, training, reputation management and HSE sectors.

Find the best product for you

Use our product assistance tool and get recommendations based on your business needs.

My Business Need

This will help us identify the best software product for you.

Please select at least one business need

Tell Us More

Please share some further detail so we can refine your product recommendations.

Please select a type of risk
Previous
Solutions Quality Health, Safety & Environmental Audit & Risk Documents & Collaboration Company Leadership team Our objectives Strategy Investors Careers Vacancies We're hiring
Ideagen products Q-Pulse QMS Q-Pulse WorkRite Q-Pulse PM Q-Pulse Law Pentana Audit Pentana Disclose Pentana Risk PleaseReview Coruson Ideagen Academy Ideagen Academy CompliancePath Huddle Qualtrax Mi-Co InspectionXpert CompliSpace OpsBase Mail Manager Audit Analytics
Pentana Disclose Pentana Risk PleaseReview Coruson Ideagen Academy CompliancePath Huddle Qualtrax Mi-Co InspectionXpert CompliSpace OpsBase Mail Manager Audit Analytics
Company Leadership team Our objectives Strategy Investors Careers Vacancies We're hiring
Connect with us
© Ideagen Plc.
Privacy Policy Terms and conditions GDPR commitment Environmental policy Slavery and human traficking statement Sitemap