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

09/02/2019
by   Paul Mireault, et al.
0

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 presented as a Formula Diagram, giving a global view of the interaction between all the variables, and a Formula List, giving a precise view of the interaction between the variables. In this paper, we present precise steps to implement a multi-dimensional problem in a way that will produce a spreadsheet that is easy to maintain

READ FULL TEXT
research
06/04/2020

Implementation Strategies for Multidimensional Spreadsheets

Seasoned Excel developers were invited to participate in a challenge to ...
research
07/04/2017

The Size of a Hyperball in a Conceptual Space

The cognitive framework of conceptual spaces [3] provides geometric mean...
research
11/04/2021

Ten Conceptual Dimensions of Context

This paper attempts to synthesize various conceptualizations of the term...
research
01/29/2018

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

Dimensions are an integral part of many models we use every day. Without...
research
04/02/2018

A Note on Kaldi's PLDA Implementation

Some explanations to Kaldi's PLDA implementation to make formula derivat...
research
07/29/2019

Road Accidents in the UK (Analysis and Visualization)

Analysis of road accidents is crucial to understand the factors involved...
research
02/02/2023

Analysis of view aliasing for the generalized Radon transform in ℝ^2

In this paper we consider the generalized Radon transform ℛ in the plane...

Please sign up or login with your details

Forgot password? Click here to reset