Conclusion We compared the approach of developing decision support models using a spreadsheet, for design and costing, to the approach of User Driven Modelling, with open standards languages, and a web interface for this purpose.
We conclude that the use of spreadsheets for this purpose is beset by problems.
These relate to Maintenance, Extensibility, Ease of Use, and Sharing of Information.
But an alternative is required so modellers can continue their work without having to rely on software developers.
The alternative approach involves development of a system, where a model builder, via visual editing of library taxonomies can undertake maintenance and extension of information.
As yet a prototype only has been created for this, and a great deal more work is required to finalise the structure for the holding of this information, and agree standards for terminology.
Also we need to provide more validation of user input.
However dealing with this proof of concept has indicated to us that it is far easier to maintain, search and share information using this approach than it is using spreadsheets.
The ability to visualise, search and share the information using structured languages and web-pages, is a huge advantage, and allows us to create dynamic image views and decision support models over the web.