English
Related papers

Related papers: Enterprise Spreadsheet Management: A Necessary Goo…

200 papers

There has been a significant amount of research into spreadsheets over the last two decades. Errors in spreadsheets are well documented. Once used mainly for simple functions such as logging, tracking and totalling information, spreadsheets…

Computers and Society · Computer Science 2024-12-31 Mukul Madahar , Pat Cleary , David Ball

Spreadsheets are powerful tools which play a business-critical role in many organizations. However, many bad decisions taken due to faulty spreadsheets show that these tools need serious quality assurance. Furthermore, while collaboration…

Software Engineering · Computer Science 2017-12-01 Daniel Kulesz , Verena Käfer , Stefan Wagner

We present a pragmatic method for management of risks that arise due to spreadsheet use in large organizations. We combine peer-review, tool-assisted evaluation and other pre-existing approaches into a single organization-wide approach that…

Software Engineering · Computer Science 2012-12-03 Miguel A. Ferreira , Joost Visser

The first fully-documented study into the quantitative impact of errors in operational spreadsheets identified an interesting anomaly. One of the five participating organisations involved in the study contributed a set of five spreadsheets…

Software Engineering · Computer Science 2024-12-31 Grenville J. Croll

This paper presents a taxonomy for analytical spreadsheet models. It considers both the use case that a spreadsheet is meant to serve, and the engineering resources devoted to its development. We extend a previous three-type taxonomy, to…

Software Engineering · Computer Science 2023-09-04 Thomas A. Grossman , Vijay Mehrotra

Spreadsheet technology is a cornerstone of IT systems in most organisations. It is often the glue that binds more structured transaction-based systems together. Financial operations are a case in point where spreadsheets fill the gaps left…

Software Engineering · Computer Science 2011-11-30 Kevin McDaid , Ronan MacRuairi , Neil Clynch , Kevin Logue , Cian Clancy , Shane Hayes

We propose a research strategy for creating and deploying prescriptive recommendations for spreadsheet practice. Empirical data on usage can be used to create a taxonomy of spreadsheet classes. Within each class, existing practices and…

Human-Computer Interaction · Computer Science 2008-07-22 Thomas A. Grossman , Ozgur Ozluk

Many large financial planning models are written in a spreadsheet programming language (usually Microsoft Excel) and deployed as a spreadsheet application. Three groups, FAST Alliance, Operis Group, and BPM Analytics (under the name…

Software Engineering · Computer Science 2010-08-26 Thomas A. Grossman , Ozgur Ozluk

It is now widely accepted that errors in spreadsheets are both common and potentially dangerous. Further research has taken place to investigate how frequently these errors occur, what impact they have, how the risk of spreadsheet errors…

Software Engineering · Computer Science 2010-01-26 David Nixon , Mike O'Hara

Spreadsheets in financial markets are frequently used as database, calculator and reporting application combined. This paper describes an alternative approach in which spreadsheet design and database technology have been brought together in…

Software Engineering · Computer Science 2008-03-10 Brian Sentence

Spreadsheet users regularly deal with uncertainty in their data, for example due to errors and estimates. While an insight into data uncertainty can help in making better informed decisions, prior research suggests that people often use…

Human-Computer Interaction · Computer Science 2019-05-31 Judith Borghouts , Andrew D. Gordon , Advait Sarkar , Kenton P. O'Hara , Neil Toronto

Due to rapid changes in business dynamics, there is a growing demand to encourage social conversations/exchanges and the ability to connect and communicate with peers, partners, customers and other stakeholders anytime, anywhere which…

Other Computer Science · Computer Science 2012-09-24 Jitendra Maan

Spreadsheets are widely used within companies and often form the basis for business decisions. Numerous cases are known where incorrect information in spreadsheets has lead to incorrect decisions. Such cases underline the relevance of…

Software Engineering · Computer Science 2015-03-16 Bas Jansen

Spreadsheets provide many of the key links between information systems, closing the gap between business needs and the capability of central systems. Recent regulations have brought these vulnerable parts of information supply chains into…

Computers and Society · Computer Science 2024-12-31 Ralph Baxter

This paper presents the results of an empirical evaluation of the quality of a structured methodology for the development of spreadsheet models, proposed in numerous previous papers by Rajalingham K, Knight B and Chadwick D et al. This…

Computers and Society · Computer Science 2024-12-31 Kamalasen Rajalingham , David Chadwick , Brian Knight

Amongst the large number of write-and-throw-away spreadsheets developed for one-time use there is a rather neglected proportion of spreadsheets that are huge, periodically used, and submitted to regular update-cycles like any conventionally…

Human-Computer Interaction · Computer Science 2008-05-14 Markus Clermont , Christian Hanin , Roland T. Mittermeir

This paper presents the authors recommended practices for spreadsheet testing. Documented spreadsheet error rates are unacceptable in corporations today. Although improvements are needed throughout the systems development life cycle,…

Software Engineering · Computer Science 2024-12-31 Raymond R. Panko

There is an overlooked iceberg of problems in end user computing. Spreadsheets are developed by people who are very skilled in their main job function, be it finance, procurement, or production planning, but often have had no formal…

Human-Computer Interaction · Computer Science 2008-06-03 Pat Cleary , Dr David Ball , Mukul Madahar , Simon Thorne , Christopher Gosling , Karen Fernandez

This paper explores the impacts of spreadsheets on business operations in a water utility parastatal in Malawi, Sub-Saharan Africa. The organisation is a typical example of a semi-government body operating in a technologically…

Software Engineering · Computer Science 2022-01-20 Khwima Mckinley Mkamanga , Simon Thorne

This paper presents the findings of a case study of spreadsheet use in a higher education institution in the UK. The paper considers the use of spreadsheets in two units of the organisation, academic registry and finance. Spreadsheet use is…

Computers and Society · Computer Science 2019-09-18 Simon Thorne , Jamie Hancock