An approach for the automated risk assessment of structural differences between spreadsheets DiffXL - Computer Science > Human-Computer InteractionReport as inadecuate




An approach for the automated risk assessment of structural differences between spreadsheets DiffXL - Computer Science > Human-Computer Interaction - Download this document for free, or read online. Document in PDF available to download.

Abstract: This paper outlines an approach to manage and quantify the risks associatedwith changes made to spreadsheets. The methodology focuses on structuraldifferences between spreadsheets and suggests a technique by which a riskanalysis can be achieved in an automated environment. The paper offers anexample that demonstrates how contiguous ranges of data can be mapped into ageneric list of formulae, data and metadata. The example then shows thatcomparison of these generic lists can establish the structural differencesbetween spreadsheets and quantify the level of risk that each change hasintroduced. Lastly the benefits, drawbacks and limitations of the technique arediscussed in a commercial context.



Author: John Hunt

Source: https://arxiv.org/



DOWNLOAD PDF




Related documents