An Investigation of the Incidence and Effect of Spreadsheet Errors Caused by the Hard Coding of Input Data Values into Formulas

Preprint English OPEN
Blayney, Paul J.;
(2008)
  • Subject: Computer Science - Human-Computer Interaction | D.2.4 | D.2.5 | H.4.1 | K.6.4 | K.8.1

The hard coding of input data or constants into spreadsheet formulas is widely recognised as poor spreadsheet model design. However, the importance of avoiding such practice appears to be underestimated perhaps in light of the lack of quantitative error at the time of o... View more
Share - Bookmark