Long Calculation Chain

Spreadsheet formulas can refer to each other, hence creating chains of calculation. To understand the meaning of such a formula, a spreadsheet user has to trace along multiple steps to find the origin of the data. To lower the number of steps of a calculation chain, steps of the chain could be merged into one cell.

Reference

F. Hermans, M. Pinzger, A. van Deursen. “Detecting Code Smells in Spreadsheet Formulas”. ICSM 2012, pp. 409–418.


Spreadsheet Smells

Home

All rights reserved (c) Tushar Sharma 2017-23.