Implementation Strategies for Multidimensional Spreadsheets

TL;DR

This paper analyzes how experienced Excel developers implement multi-dimensional variables, revealing common projection strategies and a database approach that simplifies formulas.

Contribution

It identifies and compares two main implementation strategies for multidimensional spreadsheets in Excel, highlighting their differences and implications.

Findings

Most participants used projection of multi-dimensional variables onto 2D

A few used a database approach with dataset tables

The database approach results in simpler formulas

Abstract

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 implement strategies employed. We identified two strategies: most participants used a projection of three or four-dimensional variables on the two-dimensional plane used by Excel. A few participants used a database approach where the multi-dimensional variables are presented in the form of a dataset table with the appropriate primary key. This approach leads to simpler formulas.