Research article · 11 Apr 2022
Research articlePublished 2008
An Innovative Spreadsheet Authoring Environment
Abstract
Select any words in the title or abstract, or press this and choose a sentence.
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
Subjects
Business & ManagementAsk about this article
Answers come only from this article's title, abstract and keywords, each sentence pointing to where it comes from. Your question is sent to OpenAI to write the answer. Scholars Central does not store it.
Similar by topic
Research article · 2011
Corporate Sustainability of Green Technology And Assessment of The Environment And Challenges Faced by Regulatory Authorities in Uganda: A Case of The Electricity Regulatory Authority (ERA)
Editorial · 31 Jul 2020
Journal of Clinical Anesthesiology: Open Access Acknowledgement to the Authors and Reviewers
Editorial · 2012
Promoting New Research Results by an Open Access Journals- Faster Dissemination of Research Results and More Chance for Feedback to their Authors
Editorial · 22 Jan 2012
Welcome to the Journal of Novel Physiotherapies: An Open Access Category from the OMICS Publishing Group
More from this journal
The newest in Journal of Internet Banking and Commerce.
Article · 19 Dec 2024
Debt Repayment: Prioritizing and Consolidating for Stability
Article · 25 Nov 2024
Enhancing Accuracy and Efficiency with Smart Inventory Solutions
Article · 25 Nov 2024
Sustainable Growth: Integrating Eco-Friendly Solutions in E-Commerce
Conferences in this field
Upcoming conferences in this field.
Follow
New articles from what you follow go into your email digest, once you agree to alert emails.
- JournalJournal of Internet Banking and Commerce
- SubjectBusiness & Management
- BylineArticles whose byline prints “Richard J. Petti”
- BylineArticles whose byline prints “Howard I. Cannon”
