Spreadsheet Structure Discovery with Logic Programming

Jocelyn Paine
<span title="2008-02-27">2008</span> <i > arXiv </i> &nbsp; <span class="release-stage" >pre-print</span>
Our term "structure discovery" denotes the recovery of structure, such as the grouping of cells, that was intended by a spreadsheet's author but is not explicit in the spreadsheet. We are implementing structure discovery tools in the logic-programming language Prolog for our spreadsheet analysis program Model Master, by writing grammars for spreadsheet structures. The objective is an "intelligent structure monitor" to run beside Excel, allowing users to reconfigure spreadsheets to the
more &raquo; ... tional needs of the task at hand. This could revolutionise spreadsheet "best practice". We also describe a formulation of spreadsheet reverse-engineering based on "arrows".
<span class="external-identifiers"> <a target="_blank" rel="external noopener" href="https://arxiv.org/abs/0802.3940v1">arXiv:0802.3940v1</a> <a target="_blank" rel="external noopener" href="https://fatcat.wiki/release/afio6gurffd4jb2jibtqkzpkka">fatcat:afio6gurffd4jb2jibtqkzpkka</a> </span>
<a target="_blank" rel="noopener" href="https://web.archive.org/web/20191026185857/https://arxiv.org/pdf/0802.3940v1.pdf" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="https://blobs.fatcat.wiki/thumbnail/pdf/7b/be/7bbe469ac7c99aee0b6c17ed8471073d11681f71.180px.jpg" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener" href="https://arxiv.org/abs/0802.3940v1" title="arxiv.org access"> <button class="ui compact blue labeled icon button serp-button"> <i class="file alternate outline icon"></i> arxiv.org </button> </a>