An Innovative Spreadsheet Authoring Environment

Richard J. Petti () and Howard I. Cannon ()
Additional contact information
Richard J. Petti: ModelSheet Software LLC
Howard I. Cannon: ModelSheet Software LLC

Journal of Internet Banking and Commerce, 2008, vol. 13, issue 2, 01-11

Abstract: Spreadsheets are problematic components in enterprise information systems, due to reliability and other problems. The root problem is that the greatest strength of spreadsheets – enabling authors to work with visual layouts of models instead of program code – is a double-edged sword, especially in more complex applications. Spreadsheets are simple in the sense that the set of primitive operations is small; yet they are not simple in the sense of having a sufficiently rich set of primitives for building complex models. What is needed in spreadsheet land is a new synthesis of visual layout and program structures that preserves the virtues of spreadsheets while introducing the missing structures – time series, dimensions, variables, data types – in a way that does not render business analysts dependent on programmers, as BI and ERP systems often do. This paper compares these design criteria against the new ModelSheet authoring environment, which is based on a new symbiosis of visual layout and program structures. ModelSheet retains the key strengths of spreadsheets – supporting decentralized innovation by domain experts who may not be programmers – while it improves model reliability, model expressiveness, team collaboration, and modeler productivity.

Keywords: Business Analytics; Business intelligence; Information technology (IT); Spreadsheet authoring; ModelSheet (search for similar items in EconPapers)
JEL-codes: F23 (search for similar items in EconPapers)
Date: 2008
References: Add references at CitEc
Citations:

There are no downloads for this item, see the EconPapers FAQ for hints about obtaining it.

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:ris:joibac:0507

Access Statistics for this article

Journal of Internet Banking and Commerce is currently edited by Vijaya Lakshmi, Nahum Goldmann and Dale Pinto

More articles in Journal of Internet Banking and Commerce
Bibliographic data for series maintained by Dale Pinto ().