Page Tools

Spreadsheet Spaghetti

Our Speciality

Trigger Software specialise in highly innovative programs that release critical business information imprisoned in unmanageable spreadsheets. Many of our projects involve converting workgroup spreadsheets into enterprise-strength solutions that allow you to access, calculate and control your data, unlocking its potential for your business.

If you are capturing original data into spreadsheets as the first entry point into your core business processes then you may be risking your business on the integrity of those spreadsheets and the fragility of manual inputs.

The penetration of spreadsheets within today’s business environment has brought both great advances and great problems to enterprise. The flexible but unstructured spreadsheet approach, often without house guidelines or rules can lead to information constriction on a grand scale.  

The enterprise has different needs to the lone spreadsheet architect, and it is here that the spreadsheet becomes a problem, siphoning off corporate data and processing logic to the workstation, making the implementation of business rules impossible. The cost of this flexibility is loss of control.

We prefer to automate the regular and facilitate the irregular so you use the time saved to put your spreadsheet licenses to work doing what they do best, flexible analysis, trend spotting, charting and ad hoc reporting.

Costings, models, budgets, workbooks, whatever you want to call them we've carried out post mortems on hundreds of them and found that there is often a common anatomy.

25% original data, 25% replicated data just for the purpose of viewing or printing. 30% links to other sheets or lookup functions, 10% errors, 10% usage notes.

Trigger Software has over a decade of experience in converting spreadsheet applications to enterprise database systems.  We have devised a number of techniques and calculation engines along the way and you will be amazed how lateral thinking can unchain you from your spreadsheet hell.   

 

 
 

Elegant Solutions

The solutions we provide are always unique but share a common foundation. All our spreadsheet applications divide the business logic from the data and from the user's interface. Data is changed through a process, not just through an input field so you're guaranteed control and accountability.

Often we make the server do the number crunching, freeing the user to view, digest and model the resulting information. We make the client light but friendly, real-time and secure.

We have some clever tricks up our sleeves that could mean you can reduce your risks sooner and more cost effectively than you think. For example, we have developed solutions that load existing spreadsheets from a web server, present the sheets to the user in a familiar and yet controlled way and then save their changes back to the server. Post processing can then be carried out on the server if required. The user is shielded from the spreadsheet but works in a completely familiar, safe and intuitive way.

 

Return On Investment

A single manifest error in a spreadsheet that you run your core business on could cost you heavily in pounds, labour or embarrassment. We can help you to carry out a return on investment study that can identify areas where a database could save you money, and massively improve your business.

For example, when evaluating the cost of implementing an alternative solution it is common to overlook the cost of maintaining the existing spreadsheets. How much of your analysts time is taken up crafting new workbooks, fixing broken links or copying files around the network?

We believe that every project should be able to justify it's cost through an ROI evaluation. If you cannot see how the project will save or possibly make the business money, you should not be doing it, it's that simple.

Contact us today to find out if we can help you with your spreadsheet spaghetti problems.

Contact Us

Call a Trigger Consultant:
01242 256 990

Common Symptoms

  • workbooks over 5 MB
  • cannot consolidate data
  • cannot change anything
  • no audit trail
  • literal values in formulae
  • bodged reporting process
  • horrendous duplication
  • can't find anything
  • #value or #Div/0 errors
  • spreadsheet author away

Solution Benefits

  • auditable compliance
  • reduced keying of data
  • automated reporting
  • eradication of errors
  • analysts time saving
  • 3rd party integration
  • lowered comms costs
  • reduced labour costs
  • realtime monitoring
  • buy to budget control