DeepAI AI Chat
Log In Sign Up

Implementation Strategies for Multidimensional Spreadsheets

by   Paul Mireault, et al.

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.


page 1

page 2

page 3

page 4


Multi-dimensional Skyline Query to Find Best Shopping Mall for Customers

This paper presents a new application for multi-dimensional Skyline quer...

Structured Spreadsheet Modelling and Implementation with Multiple Dimensions – Part 2: Implementation

In Part 1, we showed how to develop a conceptual model of a problem invo...

Multi-dimensional Short Blocklength Probabilistic Shaping for Digital Subcarrier Multiplexing Systems

We propose multi-dimensional short blocklength probabilistic shaping to ...

A multi-dimensional extension of the Lightweight Temporal Compression method

Lightweight Temporal Compression (LTC) is among the lossy stream compres...

Local biplots for multi-dimensional scaling, with application to the microbiome

We present local biplots, a an extension of the classic principal compon...

Table2Charts: Learning Shared Representations for Recommending Charts on Multi-dimensional Data

It is common for people to create different types of charts to explore a...

Three Orthogonal Dimensions for Psychoacoustic Sonification

Objective: Three perceptually orthogonal auditory dimensions for multidi...