4 citations · 4 across the 2 of their papers we have counts for
6 papers · 1 filter
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…
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…
Structured Spreadsheet Modeling and Implementation
Paul Mireault
Developing an error-free spreadsheet has been a problem since the beginning of end-user computing. In this paper, we present a methodology that separates the modeling from the impl…