scholarly journals Refactoring Smelly Spreadsheet Models

2014 ◽  
pp. 556-571 ◽  
Author(s):  
Pedro Martins ◽  
Rui Pereira
Keyword(s):  
Spreadsheet Models

DSS and Multiple Perspectives of Complex Problems

2011 ◽  
pp. 286-295 ◽  
Author(s):  
David Paradice ◽  
Robert A. Davis
Keyword(s):  
Decision Support ◽  
Information Systems ◽  
Decision Support Systems ◽  
Support Systems ◽  
Collaborative Work ◽  
Vantage Point ◽  
Decision Makers ◽  
Complex Problems ◽  
Knowledge Based ◽  
Spreadsheet Models

Decision support systems have always had a goal of supporting decision-makers. Over time, DSS have taken many forms, or many forms of computer-based support have been considered in the context of DSS, depending on one’s particular perspective. Regardless, there have been decision support systems (DSS), expert systems, executive information systems, group DSS (GDSS), group support systems (GSS), collaborative systems (or computer-supported collaborative work (CSCW) environments), knowledge-based systems, and inquiring systems, all of which are described elsewhere in this encyclopedia. The progression of decision support system types that have emerged follows to some degree the increasing complexity of the problems being addressed. Some of the early DSS involved single decision-makers utilizing spreadsheet models to solve problems. Such an approach would be inadequate in addressing complex problems because one aspect of problem complexity is that multiple stakeholders typically exist. Baldwin (1993) examined the need for supporting multiple views and provides the only attempt found in the information systems literature to operationalize the concept of a perspective. In his work, a view is defined as a set of beliefs that partially describe a general subject of discourse. He identified three major components of a view: the belief or notion to convey, a language to represent the notion, and a subject of discourse. He further described notions as comprising aspects and a vantage point. Aspects are the characteristics or attributes of a subject or situation that a particular notion emphasizes. A vantage point is described by the level of detail (i.e., overview or detailed analysis). Assuming the subject of discourse can be identified with the notion, Baldwin described how differences in views may occur via differences in the notion, the language, or both.

Computerised irrigation scheduling using spreadsheet models

1988 ◽  
Vol 2 (2) ◽  
pp. 211-227 ◽  
Author(s):  
H. Goldsmith ◽  
J. D. Bird ◽  
S. E. Howarth
Keyword(s):  
Irrigation Scheduling ◽  
Spreadsheet Models

scholarly journals Implementing parallel spreadsheet models for health policy decisions: The impact of unintentional errors on model projections

PLoS ONE ◽  
2018 ◽  
Vol 13 (3) ◽  
pp. e0194916
Author(s):  
Stephanie L. Bailey ◽  
Rose S. Bono ◽  
Denis Nash ◽  
April D. Kimmel
Keyword(s):  
Health Policy ◽  
Policy Decisions ◽  
Spreadsheet Models ◽  
The Impact

Anomalies in the transformation of 3-chlorobenzoate in percolation columns with Pseudomonas sp. strain b13

1998 ◽  
Vol 37 (8) ◽  
pp. 89-96 ◽  
Author(s):  
Marijke E. Tros ◽  
Gosse Schraa ◽  
Alexander J.B. Zehnder ◽  
Tom N.P. Bosma
Keyword(s):  
Mass Transfer ◽  
Steady State ◽  
Diffusion Processes ◽  
Critical Ratio ◽  
Pseudomonas Sp ◽  
Flow Rates ◽  
Convection Diffusion ◽  
Mass Transfer Kinetics ◽  
Spreadsheet Models ◽  
Combined Action

The biotransformation of 3-chlorobenzoate (3CB) by attached cells of Pseudomonas sp. strain B13 was studied in percolation columns operated at various flow rates and biomass contents. Steady-state residual effluent concentrations were compared with predictions from spreadsheet models describing the combined action of microbial and mass transfer kinetics. The effluent concentrations were successfully predicted above a critical ratio of flow rate and biomass. Below this critical point the steady-state residual effluent concentrations were higher than predicted and this deviation increased with decreasing flow rate:biomass ratios. The results are discussed in the light of convection-diffusion processes limiting the transport of both substrate and oxygen to the attached cells.

A Framework for Cognitive Skill Acquisition and Spreadsheet Training

2011 ◽  
pp. 212-233 ◽  
Author(s):  
S. E. Kruck ◽  
John J. Maher ◽  
Reza Barkhi
Keyword(s):  
Skill Acquisition ◽  
Cognitive Skills ◽  
Cognitive Skill ◽  
Logical Reasoning ◽  
Problem Area ◽  
Training Methods ◽  
Negative Effects ◽  
Cognitive Changes ◽  
Spreadsheet Model ◽  
Spreadsheet Models

It is well documented that electronic spreadsheet models utilized in many professions to enhance decision-making frequently contain errors that have negative effects on the ultimate quality of decisions. Limited research has been published that systematically identifies potential reasons for the causes of these errors, and what procedures can be taken to minimize or eliminate them. Our research provides initial evidence concerning this problem area by investigating how several important cognitive skills are affected by formalized spreadsheet training. Results indicate that one cognitive skill, logical reasoning, significantly increases after a six-week training period. Importantly, the greater the increase in logical reasoning skill, the more effectively the subject performed developing competent spreadsheet models. These findings provide a meaningful step in more perceptibly understanding and defining important cognitive changes that occur in individuals as they undergo formalized spreadsheet development training. Further extensions of this research should more clearly refine our understanding of the cognitive changes that occur in spreadsheet developers and eventually cultivate the development of more efficient and effective training methods for spreadsheet model designers.

Sign in / Sign up

Export Citation Format

Share Document