Inclusion analysis is the name given by Operis to a black box testing technique that it has found to make the checking of key financial ratios calculated by spreadsheet models quicker, easier and more likely to find omission errors than code inspection. 1 CALCULATE MORE THAN ONCE One approach among many [Pryor, 2004] [Panko, 2006] for improving the chance that a spreadsheet delivers the results...

We exploit the spreadsheet metaphor to make deductive problem-solving methods available to the vast population of spreadsheet end users. In particular, we show how the function-based problem-solving capabilities of spreadsheets can be extended to include logical deductive methods in a way that is consistent with the existing spreadsheet “look and feel.” The foundation of our approach is the int...

We outline a spreadsheet-based system for visualization of real-time financial information. Our system permits the user to define arithmetic and presentation relationships amongst the various cells of the spreadsheet. The cells contain primitives that can be numbers, text, images, functions, and graphics. Presenting financial information in this format allows its intended clients, the financial...

Spreadsheets have become very popular tools for analyzing and visualizing data from business and science. To better understand human-spreadsheet interaction, we explore readers’ information models, but in contrast to most studies we focus on spreadsheet readers rather than spreadsheet authors. We conducted a study using the repertory grid technique and analyzed the result with the help of a Gen...

We intend to demonstrate the innate problems with existing spreadsheet products and to show how to tackle these issues using a new type of spreadsheet program – Resolver. It addresses the issues head-on and thereby moves the 1980’s “VisiCalc paradigm” on to match the advances in computer languages and user requirements. Continuous display of the spreadsheet grid and the equivalent computer prog...

EuSpRIG concerns direct researchers to revisit spreadsheet education, taking into account error auditing tools, checklists, and good practices. This paper aims at elaborating principles to design a spreadsheet curriculum. It mainly focuses on two important issues. Firstly, it is necessary to establish the spreadsheet invariants to be taught, especially those concerning errors and good practices...

Spreadsheets are among the most widely used programming systems in the world. Individuals and businesses use spreadsheets for a wide variety of applications, ranging from performing simple calculations to building complex financial models. In this article, we first discuss how spreadsheet programs are actually functional programs. We then describe concepts in spreadsheet programming, followed b...

Process-driven spreadsheet queuing simulation is a better vehicle for understanding queue behavior than queuing theory or dedicated simulation software. Spreadsheet queuing simulation has many pedagogical benefits in a business school end-user modeling course, including developing students' intuition , giving them experience with active modeling skills, and providing access to tools. Spreadshee...

Visualizing spreadsheet content provides analytic insight and visual validation of large amounts of spreadsheet data. Oculus Excel Visualizer is a point and click data visualization experiment which directly visualizes Excel data and re-users the layout and formatting already present in the spreadsheet.

In addition to this report, the website contains the following documents relating to the survey: • a copy of the questionnaire • a spreadsheet containing detailed data • a text file titled "Notes on the Spreadsheet Data," explaining the spreadsheet format and summarizing the findings for the individual questions • the PowerPoint presentation of May 25 (slides of that presentation will be refere...