English

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

Software Engineering 2018-02-09 v2

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.

Keywords

Cite

@article{arxiv.1801.09777,
  title  = {Structured Spreadsheet Modelling and Implementation with Multiple Dimensions - Part 1: Modelling},
  author = {Paul Mireault},
  journal= {arXiv preprint arXiv:1801.09777},
  year   = {2018}
}

Comments

13 Pages, 17 Tables and Figures

R2 v1 2026-06-23T00:02:30.612Z