Spreadsheets are widely used for data exploration. Since spreadsheet systems have limited capabilities, users often need to load spreadsheets other science environments perform advanced analytics. However, current approaches loading suffer from either high runtime or memory usage, which hinders exploration on commodity systems. To make practical systems, we introduce a novel parser that minimiz...

This paper proposes a set of metrics for the assessment of the complexity of models defining the business logic of spreadsheets. This set can be considered the first step in the direction of building a quality standard for spreadsheet models, that is still to be defined. The computation of concrete metric values has further been integrated under a well-established model-driven spreadsheet devel...

Research on spreadsheet errors began over fifteen years ago. During that time, there has been ample evidence demonstrating that spreadsheet errors are common and nontrivial. Quite simply, spreadsheet error rates are comparable to error rates in other human cognitive activities and are caused by fundamental limitations in human cognition, not mere sloppiness. Nor does ordinary "being careful" el...

Spreadsheets play an important role in software organizations. Indeed, in large software organizations, spreadsheets are not only used to define sheets containing data and formulas, but also to collect information from different systems, to adapt data coming from one system to the format required by another, to perform operations to enrich or simplify data, etc. In fact, over time many spreadsh...

In this paper, we report some on-going focused research, but are further keen to set it in the context of a proposed bigger picture, as follows. There is a certain depressing pattern about the attitude of industry to spreadsheet error research and a certain pattern about conferences highlighting these issues. Is it not high time to move on from measuring spreadsheet errors to developing an armo...

PURPOSE The multiplier method is a technique to predict limb length discrepancy (LLD) at maturity in pediatric patients. Various tools have been developed for performing the multiplier calculations to predict LLD and timing of epiphysiodesis. These include multiplier/growth applications (apps) and a spreadsheet which have helped to facilitate LLC calculations in an efficient and easy manner. We...

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...

Spreadsheets are omnipresent in today’s enterprises, in particular for supporting business users in their decision-making. Thereby, they are used in various ways to support business processes, i.a., in the areas of financial reporting, resource management, and project management. However, shortcomings of prevalent spreadsheet software (e.g., limited collaboration support) have negative impacts ...

This paper reviews work on using interval arithmetic as the basis for next generation spreadsheet programs capable of dealing with rounding errors, imprecise data, and numerical constraints. A series of ever more versatile computational models for spreadsheets are presented beginning from classical interval arithmetic and ending up with interval constraint satisfaction. In order to demonstrate ...