SSMI
Creating Effective Spreadsheets

Hall of Fame

First Multi-Dimensional Spreadsheet Challenge Hall of Fame

There were 109 kit requests and 17 submissions. This represents a 16% submission rate. While it may seem low, you have to realize that modelling a multi-dimensional problem is hard. Self-reported times to do the challenge ranged from 23 minutes to 14 hours, with an average of just under 5 hours. You can read my analysis in the paper I presented at the 2019 EuSpRIG conference, Implementation Strategies for Multidimensional Spreadsheets. (The download links are in the Publications page.)

You can read about my methodology in the two papers I presented at the EuSpRIG conferences of 2017 and 2018:

  • Structured Spreadsheet Modelling and Implementation with Multiple Dimensions - Part 1: Modelling

  • Structured Spreadsheet Modelling and Implementation with Multiple Dimensions - Part 2: Implementation

You can download my solution here: Acme TechnoWidget - SSMI version.xlsx

Here is the list of the 17 Challenge participants who submitted their solution by the deadline:

 

First Multi-Dimensional Spreadsheet Challenge

Hall of Fame