Structured Spreadsheet Modelling and Implementation with Multiple Dimensions - Part 1: Modelling
This work tackles a practical problem for spreadsheet users by proposing structured modeling approaches, but it appears incremental as it builds on existing practices without introducing a new paradigm.
The paper addresses the challenge of modeling multiple dimensions in spreadsheets, which often leads to repetitive structures like formula blocks or multiple worksheets, but does not present specific results or numbers.
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.