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

TL;DR

This paper details a step-by-step method for implementing multi-dimensional spreadsheet models, building on a conceptual framework to create maintainable and clear spreadsheets.

Contribution

It introduces a systematic approach to translate multi-dimensional conceptual models into practical, maintainable spreadsheet implementations.

Findings

Provides a detailed implementation methodology

Enhances clarity and maintainability of complex spreadsheets

Builds on conceptual models from Part 1

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