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

01/29/2018

∙

by   Paul Mireault, et al.

∙

0

∙

share

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.