Structured Spreadsheet Modelling and Implementation with Multiple Dimensions -- Part 2: Implementation
Software Engineering
2019-09-04 v1
Abstract
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
Cite
@article{arxiv.1909.00891,
title = {Structured Spreadsheet Modelling and Implementation with Multiple Dimensions -- Part 2: Implementation},
author = {Paul Mireault},
journal= {arXiv preprint arXiv:1909.00891},
year = {2019}
}
Comments
14 Pages, 12 Colour Figures, 3 Tables. First presented at EuSpRIG 2018, Imperial College, London