4 citations · 5 across the 7 of their papers we have counts for
7 papers
Implementation Strategies for Multidimensional Spreadsheets
Paul Mireault
Seasoned Excel developers were invited to participate in a challenge to implement a spreadsheet with multi-dimensional variables. We analyzed their spreadsheet to see the different…
Structured Spreadsheet Modelling and Implementation with Multiple Dimensions -- Part 2: Implementation
Paul Mireault
In Part 1, we showed how to develop a conceptual model of a problem involving variables of multiple dimensions, like Products, Regions, Sectors and Months. The conceptual model is…
Implementing WHERE and ORDER BY as spreadsheet formulas
Paul Mireault
The WHERE and ORDER BY clauses of the SQL SELECT statement select a subset of rows in the result of a database query and present the result in the specified order. In a spreadsheet…
Structured Spreadsheet Modelling and Implementation with Multiple Dimensions - Part 1: Modelling
Paul Mireault
Dimensions are an integral part of many models we use every day. Without thinking about it, we frequently use the time dimension: many financial and accounting spreadsheets have co…
Characteristics of Spreadsheets Developed with the SSMI Methodology
Paul Mireault
The 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 E…
Developing a Repeating Model Using the Structured Spreadsheet Modelling and Implementation Methodology
Paul Mireault
Spreadsheets often have variables and formulas that are similar, differing only by the fact that they refer to different instances of an entity. For example, the calculation of the…