i-nth logo

Authors

Paul Mireault

Abstract

The Structured Spreadsheet Modelling and Implementation (SSMI) methodology was developed using concepts from Computer Science, Software Engineering and Information Systems and has been taught to undergraduate and MBA students and in Executive training seminars.

In this paper, we describe the major characteristics of the spreadsheets developed using the methodology and show how they contribute to reduce many error causing factors.

Sample

Example of a transitive reference (formula view)
Example of a transitive reference (formula view)

A transitive reference is a reference to a location where a variable is used, not where it is defined.

Using the SSMI methodology, the developer simply cannot create a transitive reference since the references in the top portion of a calculation block use names that always refer to the definition of the variable.

Publication

2016, EuSpRIG

Full article

Characteristics of spreadsheets developed with the SSMI methodology