i-nth logo

Authors

Angus Dunn

Abstract

Few major commercial or economic decisions are made today which are not underpinned by analysis using spreadsheets.

It is virtually impossible to avoid making mistakes during their drafting and some of these errors remain, unseen and uncorrected, until something turns the spotlight on them. By then it may be too late.

The challenge is to find a way of creating spreadsheets which will preserve the benefit of their power and flexibility while making their creation more transparent and safer. Full documentation and documented version and quality control, section by section, of the eventual spreadsheet would be a bonus. And if the whole process could be made quicker, too, that would be a further bonus.

Sample

Advantages of RingtailXL.

RingtailXL is a Windows application which provides a framework for generating spreadsheets. The advantages of RingtailXL, in comparison with handcrafting spreadsheets directly, include:

  • Substantial saving of time.
  • A big increase in flexibility.
  • A big increase in transparency.
  • Radical improvements in quality control.
  • The ability to maintain complete documentation of all the constituents of final spreadsheets.
  • Enforcement of good practice in the separation of data, computation and output and enforcement of left to right consistency in formulae.

Publication

2009, EuSpRIG

Full article

Automated spreadsheet development