Books and journals Case studies Expert Briefings Open Access
Advanced search

Search results

1 – 10 of over 7000
To view the access options for this content please click here
Article
Publication date: 1 October 1995

The spreadsheet – just another filing cabinet?

Jonathan Pemberton and Andrew Robson

As a business tool, the spreadsheet is cited as a valuabledecision‐making aid, but despite its apparent widespread use, its scopeand potential, both with respect to areas…

HTML
PDF (37 KB)

Abstract

As a business tool, the spreadsheet is cited as a valuable decision‐making aid, but despite its apparent widespread use, its scope and potential, both with respect to areas of application and features offered, are barely exploited by the general user. Discusses and investigates these issues by examining the level of skills present amongst a group of spreadsheet users and the vehicles used in acquiring them. Argues that, in a general business environment, a lack of training in this area is, in many cases, confining the spreadsheet to little more than an electronic filing cabinet.

Details

Management Decision, vol. 33 no. 8
Type: Research Article
DOI: https://doi.org/10.1108/00251749510093914
ISSN: 0025-1747

Keywords

  • Competences
  • Computer training
  • Information technology
  • Skills
  • Spreadsheets

To view the access options for this content please click here
Article
Publication date: 1 February 1990

Spreadsheet Design: Role of Introductory Documentation in Creating Spreadsheets

Glenn R. Wittig

“Documentation”—that which is incorporated into the spreadsheet file, in contrast to manuals that come with the software per se—seems to be acknowledged more in theory…

HTML
PDF (478 KB)

Abstract

“Documentation”—that which is incorporated into the spreadsheet file, in contrast to manuals that come with the software per se—seems to be acknowledged more in theory than in practice. Documentation appears in the first section of the spreadsheet, for it introduces the reader to the model and enables the reader to “get his/her bearings.” Necessary elements include a title line, a purpose statement, directions on how the model is to be used, references to sources and ideas, and a table of contents.

Details

Library Hi Tech, vol. 8 no. 2
Type: Research Article
DOI: https://doi.org/10.1108/eb047789
ISSN: 0737-8831

To view the access options for this content please click here
Article
Publication date: 1 June 1996

Spreadsheet selection: good luck or good management?

Andrew Robson and Jonathan Pemberton

Reports on the rationale used in the selection of a spreadsheet for use in information management and planning operations. Surveys business users and software suppliers to…

HTML
PDF (46 KB)

Abstract

Reports on the rationale used in the selection of a spreadsheet for use in information management and planning operations. Surveys business users and software suppliers to shed light on the criteria adopted in the selection process. Suggests that perceived market leaders and the procurement behaviour of competing organizations have greater influence than a rigorous IT selection strategy.

Details

Logistics Information Management, vol. 9 no. 3
Type: Research Article
DOI: https://doi.org/10.1108/09576059610116716
ISSN: 0957-6053

Keywords

  • Decision making
  • Information technology
  • Purchasing
  • Spreadsheets

To view the access options for this content please click here
Article
Publication date: 15 July 2019

Exploring the use of Gestalt’s principles in improving the visualization, user experience and comprehension of COBie data extension

Mehmet Yalcinkaya and Vishal Singh

Until now, the usage and usability factors associated with AEC–FM standards have remained largely overlooked. This oversight could be a potentially significant factor in…

HTML
PDF (839 KB)

Abstract

Purpose

Until now, the usage and usability factors associated with AEC–FM standards have remained largely overlooked. This oversight could be a potentially significant factor in the adoption rates as well as effective utilization of such advanced solutions in the AEC–FM industry. Therefore, from a conceptual and theoretical viewpoint, the purpose of this paper is to address this gap in understanding and enhancing the usability aspects of standards such as construction operations building information exchange (COBie) over its spreadsheet representation. Besides, findings from this study and the proposed theoretical fundamentals to enhance the usability and functionality of COBie spreadsheet representation could potentially lay the foundation for a VisualCOBie approach.

Design/methodology/approach

The iterative steps of design thinking and agile development are harmonized to form the main research methodology. Design thinking is useful in problem (re)formulation, and agile development is useful in iterative software development. The approach aims to identify and understand the needs and requirements of the AEC–FM users from the standardized approaches and associated IT solutions; and formulate the main features and functionalities of the proposed solution. The methodology supports the aim of generating a broad range of possible solutions instead of coming up with the “right” solution.

Findings

Despite the standards and associated IT developments, the AEC–FM industry still suffers from inefficient information management. To date, most initiatives have focused on utilization of the outputs from different IT solutions in terms of accuracy and completeness of the data defined in the standards. This research found that well-established standards such as COBie and corresponding IT solutions are not merely technical issues, but it is equally important to understand how the end-users cognitively perceive and process them. The developed solutions need to address user point of view to facilitate wider utilization of these standards in practice.

Research limitations/implications

In this research, Gestalt’s visual perception principles have been used to evaluate the usability issues of COBie spreadsheet. Although Gestalt principles provide a valid and proven viewpoint, there can be other cognitive principles that could also be taken into consideration.

Originality/value

The usage and usability factors associated with AEC–FM standards have remained largely overlooked, indicating a gap in the literature. This gap was considered as a potentially significant factor in the adoption as well as effective utilization of such standards and advanced solutions in the AEC–FM industry. By grounding the research in cognitive and usability perspectives of information exchange standards, the authors demonstrate how such theoretical underpinning can lead to innovative solutions.

Details

Engineering, Construction and Architectural Management, vol. 26 no. 6
Type: Research Article
DOI: https://doi.org/10.1108/ECAM-10-2017-0226
ISSN: 0969-9988

Keywords

  • Knowledge management
  • Information systems
  • Building information modelling
  • Approach

To view the access options for this content please click here
Article
Publication date: 1 April 1994

Statistical Analysis with a Spreadsheet: A Comparison of Software

Andrew Robson

Undertakes a comparative study of the statistical capability of threespreadsheets which are commonly used in the business sector. Thespreadsheets considered are Lotus…

HTML
PDF (37 KB)

Abstract

Undertakes a comparative study of the statistical capability of three spreadsheets which are commonly used in the business sector. The spreadsheets considered are Lotus 1‐2‐3, Microsoft Excel and Quattro Pro. Considers five areas of statistical analysis regularly used by business decision makers (rather than specialist personnel). In order to obtain an objective measure of the statistical provision of each spreadsheet, comparison has also been made with dedicated statistical software regularly used by business decision makers, namely MINITAB. By making this comparison, argues that the spreadsheet is not only a tool for analysis, but also for presentation. Moreover, considers that two spreadsheets in particular, namely Excel and Quattro Pro, offer a user‐friendly statistical provision which should be sufficient for most business decision makers.

Details

Logistics Information Management, vol. 7 no. 2
Type: Research Article
DOI: https://doi.org/10.1108/09576059410057156
ISSN: 0957-6053

Keywords

  • Decision making
  • Lotus 1‐2‐3
  • Microsoft Excel
  • MINITAB
  • Quattro Pro
  • Spreadsheets
  • Statistics

Content available
Article
Publication date: 2 February 2018

Spreadsheets for business process management: Using process mining to deal with “events” rather than “numbers”?

Wil van der Aalst

Process mining provides a generic collection of techniques to turn event data into valuable insights, improvement ideas, predictions, and recommendations. This paper uses…

Open Access
HTML
PDF (1.4 MB)

Abstract

Purpose

Process mining provides a generic collection of techniques to turn event data into valuable insights, improvement ideas, predictions, and recommendations. This paper uses spreadsheets as a metaphor to introduce process mining as an essential tool for data scientists and business analysts. The purpose of this paper is to illustrate that process mining can do with events what spreadsheets can do with numbers.

Design/methodology/approach

The paper discusses the main concepts in both spreadsheets and process mining. Using a concrete data set as a running example, the different types of process mining are explained. Where spreadsheets work with numbers, process mining starts from event data with the aim to analyze processes.

Findings

Differences and commonalities between spreadsheets and process mining are described. Unlike process mining tools like ProM, spreadsheets programs cannot be used to discover processes, check compliance, analyze bottlenecks, animate event data, and provide operational process support. Pointers to existing process mining tools and their functionality are given.

Practical implications

Event logs and operational processes can be found everywhere and process mining techniques are not limited to specific application domains. Comparable to spreadsheet software widely used in finance, production, sales, education, and sports, process mining software can be used in a broad range of organizations.

Originality/value

The paper provides an original view on process mining by relating it to the spreadsheets. The value of spreadsheet-like technology tailored toward the analysis of behavior rather than numbers is illustrated by the over 20 commercial process mining tools available today and the growing adoption in a variety of application domains.

Details

Business Process Management Journal, vol. 24 no. 1
Type: Research Article
DOI: https://doi.org/10.1108/BPMJ-10-2016-0190
ISSN: 1463-7154

Keywords

  • Process mining
  • Business process management (BPM)
  • Spreadsheets
  • Data science

To view the access options for this content please click here
Article
Publication date: 1 March 1988

The Electronic Spreadsheet

Donald D. Dennis and Mark C. Paster

Except for word processing, the electronic spreadsheet is probably the most useful general purpose software for the microcomputer user. Almost all spreadsheets are now…

HTML
PDF (705 KB)

Abstract

Except for word processing, the electronic spreadsheet is probably the most useful general purpose software for the microcomputer user. Almost all spreadsheets are now packaged in combination with other applications, such as database systems and graphic capabilities. To become proficient in the development of spreadsheet applications, one must be prepared to invest a certain amount of time and effort, but the user will be rewarded by the results. In addition to a general discussion of spreadsheets, the authors critically review Microsoft Excel, version 2.0 (for the IBM PS/2, PC‐AT, or compatibles), noting enhancements over earlier spreadsheets. A sidebar presents spreadsheet templets that can be used to manage a library retrospective conversion project.

Details

Library Hi Tech, vol. 6 no. 3
Type: Research Article
DOI: https://doi.org/10.1108/eb047730
ISSN: 0737-8831

To view the access options for this content please click here
Article
Publication date: 28 October 2014

How can non-technical end users effectively test their spreadsheets?

Pak-Lok Poon, Fei-Ching Kuo, Huai Liu and Tsong Yueh Chen

An alarming number of spreadsheet faults have been reported in the literature, indicating that effective and easy-to-apply spreadsheet testing techniques are not available…

HTML
PDF (202 KB)

Abstract

Purpose

An alarming number of spreadsheet faults have been reported in the literature, indicating that effective and easy-to-apply spreadsheet testing techniques are not available for “non-technical,” end-user programmers. The purpose of this paper is to alleviate the problem by introducing a metamorphic testing (MT) technique for spreadsheets.

Design/methodology/approach

The paper discussed four common challenges encountered by end-user programmers when testing a spreadsheet. The MT technique was then discussed and how it could be used to solve the common challenges was explained. An experiment involving several “real-world” spreadsheets was performed to determine the viability and effectiveness of MT.

Findings

The experiment confirmed that MT is highly effective in spreadsheet fault detection, and yet MT is a general technique that can be easily used by end-user programmers to test a large variety of spreadsheet applications.

Originality/value

The paper provides a detailed discussion of some common challenges of spreadsheet testing encountered by end-user programmers. To the best of the authors knowledge, the paper is the first that includes an empirical study of how effective MT is in spreadsheet fault detection from an end-user programmer's perspective.

Details

Information Technology & People, vol. 27 no. 4
Type: Research Article
DOI: https://doi.org/10.1108/ITP-01-2013-0004
ISSN: 0959-3845

Keywords

  • Decision support systems
  • User participation
  • End user
  • Information Systems Development (ISD)
  • Quality

To view the access options for this content please click here
Article
Publication date: 1 March 1990

Using Excel at Aston University Library and Information Services: the application of spreadsheets to library stock management

Christine Abbott

Although spreadsheets are now widely used in libraries, there is little evidence that their application to practical problems of library stock management has been…

HTML
PDF (466 KB)

Abstract

Although spreadsheets are now widely used in libraries, there is little evidence that their application to practical problems of library stock management has been recognised. This paper describes a project undertaken at Aston University Library and Information Services to use the spreadsheet package Excel to assist in planning the respacing of the periodical stock. After briefly outlining the background to the project, the paper describes in detail the construction of the spreadsheet and its implementation. Use of the Excel model demonstrated how the capacity of spreadsheets to perform complex calculations can be successfully applied to practical library problems.

Details

Program, vol. 24 no. 3
Type: Research Article
DOI: https://doi.org/10.1108/eb047062
ISSN: 0033-0337

To view the access options for this content please click here
Article
Publication date: 1 August 1995

The use of spreadsheet software in China

Rodney Turner

Spreadsheet software packages find ready applications in Westernnations with a high proportion of PCs having a spreadsheet packageinstalled. In Taiwan there is a high…

HTML
PDF (25 KB)

Abstract

Spreadsheet software packages find ready applications in Western nations with a high proportion of PCs having a spreadsheet package installed. In Taiwan there is a high degree of acceptance of this class of software. In the People′s Republic of China, however, there is not the same degree of acceptance with only a very small proportion of end users utilizing this important class of software. Discusses the present situation with respect to the use of spreadsheet software in China and presents several reasons why the level is low.

Details

Industrial Management & Data Systems, vol. 95 no. 6
Type: Research Article
DOI: https://doi.org/10.1108/02635579510091287
ISSN: 0263-5577

Keywords

  • China
  • Computer software
  • End‐user computing
  • Spreadsheets

Access
Only content I have access to
Only Open Access
Year
  • Last week (15)
  • Last month (45)
  • Last 3 months (146)
  • Last 6 months (278)
  • Last 12 months (496)
  • All dates (7693)
Content type
  • Article (6200)
  • Case study (658)
  • Book part (641)
  • Earlycite article (189)
  • Expert briefing (5)
1 – 10 of over 7000
Emerald Publishing
  • Opens in new window
  • Opens in new window
  • Opens in new window
  • Opens in new window
© 2021 Emerald Publishing Limited

Services

  • Authors Opens in new window
  • Editors Opens in new window
  • Librarians Opens in new window
  • Researchers Opens in new window
  • Reviewers Opens in new window

About

  • About Emerald Opens in new window
  • Working for Emerald Opens in new window
  • Contact us Opens in new window
  • Publication sitemap

Policies and information

  • Privacy notice
  • Site policies
  • Modern Slavery Act Opens in new window
  • Chair of Trustees governance statement Opens in new window
  • COVID-19 policy Opens in new window
Manage cookies

We’re listening — tell us what you think

  • Something didn’t work…

    Report bugs here

  • All feedback is valuable

    Please share your general feedback

  • Member of Emerald Engage?

    You can join in the discussion by joining the community or logging in here.
    You can also find out more about Emerald Engage.

Join us on our journey

  • Platform update page

    Visit emeraldpublishing.com/platformupdate to discover the latest news and updates

  • Questions & More Information

    Answers to the most commonly asked questions here