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

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.