Implementation Strategies for Multidimensional Spreadsheets
Paul Mireault

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.
Peer Reviews
No public reviews on file for this paper yet. If you reviewed it on a platform where reviews are public (OpenReview, ICLR, NeurIPS, ICML), you can paste yours below so the community can read it here.
Videos
No videos yet. Explain this paper in a talk, walkthrough, or lecture? Add one.
Taxonomy
TopicsSpreadsheets and End-User Computing · Advanced Database Systems and Queries · Green IT and Sustainability
