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

TL;DR

This paper discusses the importance of multiple dimensions in spreadsheet modeling, focusing on how to effectively represent and implement them, particularly emphasizing the modeling aspect.

Contribution

It introduces a structured approach to modeling spreadsheets with multiple dimensions, enhancing clarity and efficiency in complex spreadsheet design.

Findings

Highlights the common use of dimensions like time in spreadsheets

Proposes a structured modeling approach for multiple dimensions

Aims to improve spreadsheet clarity and reduce errors

Abstract

Dimensions are an integral part of many models we use every day. Without thinking about it, we frequently use the time dimension: many financial and accounting spreadsheets have columns representing months or years. Representing a second dimension is often done by repeating blocs of formulas in a worksheet or creating multiple worksheets with the same structure.