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 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, g...

Full description

Saved in:
Bibliographic Details
Published in:arXiv.org 2019-09
Main Author: Mireault, Paul
Format: Article
Language:English
Subjects:
Spreadsheets
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary: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
ISSN:2331-8422