Duplicated Formulas

This smell occurs where some formulas are partly the same as others. Consider, for example, a worksheet that contains a cell with formula SUM(A1:A6)+10% and a second formula SUM(A1:A6)+20%. This formula exhibits duplication; the part SUM(A1:A6) is contained in more than one formula. Such a duplication impacts maintainainability and readability.

Reference

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


Spreadsheet Smells

Home