Workbook Structure Analysis - "Coping with the Imperfect"
Bill Bekenn, Ray Hooper
TL;DR
This paper presents a software tool for analyzing workbook structures by identifying layout, formula blocks, and data references, aiding in workbook management and protection.
Contribution
It introduces a novel method for analyzing workbook layouts and data references, integrated into the FormulaDataSleuth toolset, enhancing workbook management capabilities.
Findings
Effective identification of layout and data blocks
Supports initial analysis and protection of workbooks
Part of the FormulaDataSleuth toolset
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.
Peer Reviews
No public reviews on file for this paper yet. If you reviewed it on a platform where reviews are public (OpenReview, ICLR, NeurIPS, ICML), you can paste yours below so the community can read it here.
Videos
No videos yet. Explain this paper in a talk, walkthrough, or lecture? Add one.
Taxonomy
TopicsSpreadsheets and End-User Computing · Engineering Education and Pedagogy · Teaching and Learning Programming