Spreadsheets are generally the first step an organisation will make towards automation and in many ways can revolutionise the way they work. However, as the organisation grows, the number of spreadsheets tends to grow with it, leading to countless spreadsheets developed for a multitude of business functions. This is what we call "spreadsheet hell".

What are the limitations of spreadsheets?

  • They do not lend themselves well to multi-user access
  • They can be difficult to manage across multiple offices
  • Can you be confident that another user hasn't deleted something they shouldn't, or placed incorrect data into a cell?
  • As they grow, they can experience data corruption issues

What can we do to help?

We have worked with a number of organisations to help move them from spreadsheets to a consolidated database, providing a more stable foundation for future growth. Our defined process involves taking the time to understand the function of each spreadsheet, and in turn design a process driven database to replace its functionality. This leads to a far more structured system that can scale well across multiple offices and accommodate simultaneous multi-user access.

If you are currently in"spreadsheet hell", call us today on 01634 299800 and we'll be more than happy to discuss how we can help you.

Related case study

Puchase order database

Special Purpose Equipment (SPE)

Medway, Kent

Manufacturing

Overview

Special Purpose Equipment (SPE), are a Medway based designer and manufacturer of innovative special purpose assembly and test equipment. Their manufacturing process requires hundreds of purchase orders to be generated on a monthly basis. The process of creating and maintaining the PO process had been historically managed using Excel spreadsheets. As with any spreadsheet solution, it starts out as a great way to manage a process, but can soon become unmanageable as the spreadsheets and complexity requirements grow.

SPE asked if Impreza could develop a database to streamline this process and provide a simple but more robust method for managing this time consuming part of the business.

Database design and build

ASP.net, C#, MS SQL, Crystal reports