English (United Kingdom)

https://curated-unify.zendy.io/wp-json/zendy-region/v1/featured_content/oa?rat=en

https://curated-unify.zendy.io/wp-json/zendy-region/v1/highlighted_journal/

Global: Zendy Plus annual

Presents the access of premium content as premium feature

Premium Content

Presents the keyphrase highlighting as premium feature

Keyphrase Highlighting

Presents the summarisation as premium feature

Summarisation

Insights

Presents the pdf analysis as premium feature

PDF Analysis

Presents the zaia usage as premium feature

ZAIA

Global: Zendy Plus monthly

Global: Zendy Tools annual

Global: Zendy Tools monthly

Global: Zendy Free Plan

The hard coding of input data or constants into spreadsheet formulas iswidely recognised as poor spreadsheet model design. However, the importance ofavoiding such practice appears to be underestimated perhaps in light of thelack of quantitative error at the time of occurrence and the recognition thatthis design defect may never result in a bottom-line error. The paper examinesboth the academic and practitioner view of such hard coding design flaws. Thepractitioner or industry viewpoint is gained indirectly through a review ofcommercial spreadsheet auditing software. The development of an automated(electronic) means for detecting such hard coding is described together with adiscussion of some results obtained through analysis of a number of student andpractitioner spreadsheet models.

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