Workbook Structure Analysis - "Coping with the Imperfect"
Software Engineering
2011-11-30 v1
Abstract
This Paper summarises the operation of software developed for the analysis of workbook structure. This comprises: the identification of layout in terms of filled areas formed into "Stripes", the identification of all the Formula Blocks/Cells and the identification of Data Blocks/Cells referenced by those formulas. This development forms part of our FormulaDataSleuth toolset. It is essential for the initial "Watching" of an existing workbook and enables the workbook to be subsequently managed and protected from damage.
Cite
@article{arxiv.1111.6858,
title = {Workbook Structure Analysis - "Coping with the Imperfect"},
author = {Bill Bekenn and Ray Hooper},
journal= {arXiv preprint arXiv:1111.6858},
year = {2011}
}
Comments
12 Pages, 7 Figures; Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2011 ISBN 978-0-9566256-9-4