Computer Science – Human-Computer Interaction
Scientific paper
2008-03-03
Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2006 22-230 ISBN:1-905617-08-9
Computer Science
Human-Computer Interaction
10 Pages, 5 Tables
Scientific paper
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 occurrence and the recognition that this design defect may never result in a bottom-line error. The paper examines both the academic and practitioner view of such hard coding design flaws. The practitioner or industry viewpoint is gained indirectly through a review of commercial spreadsheet auditing software. The development of an automated (electronic) means for detecting such hard coding is described together with a discussion of some results obtained through analysis of a number of student and practitioner spreadsheet models.
No associations
LandOfFree
An Investigation of the Incidence and Effect of Spreadsheet Errors Caused by the Hard Coding of Input Data Values into Formulas does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.
If you have personal experience with An Investigation of the Incidence and Effect of Spreadsheet Errors Caused by the Hard Coding of Input Data Values into Formulas, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and An Investigation of the Incidence and Effect of Spreadsheet Errors Caused by the Hard Coding of Input Data Values into Formulas will most certainly appreciate the feedback.
Profile ID: LFWR-SCP-O-225004