<?xml version="1.0" encoding="UTF-8"?><xml><records><record><source-app name="Biblio" version="6.x">Drupal-Biblio</source-app><ref-type>47</ref-type><contributors><authors><author><style face="normal" font="default" size="100%">Jácome Cunha</style></author><author><style face="normal" font="default" size="100%">Martin Erwig</style></author><author><style face="normal" font="default" size="100%">João Alexandre Saraiva</style></author></authors></contributors><titles><title><style face="normal" font="default" size="100%">Automatically Inferring ClassSheet Models from Spreadsheets</style></title><secondary-title><style face="normal" font="default" size="100%">Proceedings of the Symposium on Visual Languages and Human-Centric Computing - VL/HCC</style></secondary-title><tertiary-title><style face="normal" font="default" size="100%">VLHCC '10</style></tertiary-title></titles><keywords><keyword><style  face="normal" font="default" size="100%">ClassSheets inference</style></keyword><keyword><style  face="normal" font="default" size="100%">Spreadsheets</style></keyword></keywords><dates><year><style  face="normal" font="default" size="100%">2010</style></year><pub-dates><date><style  face="normal" font="default" size="100%">September</style></date></pub-dates></dates><urls><web-urls><url><style face="normal" font="default" size="100%">http://dx.doi.org/10.1109/VLHCC.2010.22</style></url></web-urls><related-urls><url><style face="normal" font="default" size="100%">https://haslab.uminho.pt/sites/default/files/jacome/files/vl-hcc10.pdf</style></url></related-urls></urls><publisher><style face="normal" font="default" size="100%">IEEE Computer Society</style></publisher><pub-location><style face="normal" font="default" size="100%">Madrid, Spain</style></pub-location><pages><style face="normal" font="default" size="100%">93–100</style></pages><isbn><style face="normal" font="default" size="100%">978-0-7695-4206-5</style></isbn><language><style face="normal" font="default" size="100%">eng</style></language><abstract><style face="normal" font="default" size="100%">&lt;p&gt;Many errors in spreadsheet formulas can be avoided if spreadsheets are built automatically from higher-level models that can encode and enforce consistency constraints.&lt;br /&gt;
However, designing such models is time consuming and requires expertise beyond the knowledge to work with spreadsheets. Legacy spreadsheets pose a particular challenge to the approach of controlling spreadsheet evolution through higher-level models, because the need for a model might be overshadowed by two problems: (A) The benefit of creating a spreadsheet is lacking since the legacy spreadsheet already exists, and (B) existing data must be transferred into the new model-generated spreadsheet.To address these problems and to support the modeldriven spreadsheet engineering approach, we have developed a tool that can automatically infer ClassSheet models from spreadsheets. To this end, we have adapted a method to infer entity/relationship models from relational database to the spreadsheets/ClassSheets realm. We have implemented our techniques in the HAEXCEL framework and integrated it with the ViTSL/Gencel spreadsheet generator, which allows the automatic generation of refactored spreadsheets from the inferred ClassSheet model. The resulting spreadsheet guides further changes and provably safeguards the spreadsheet against a large class of formula errors. The developed tool is a significant contribution to spreadsheet (reverse) engineering, because it fills an important gap and allows a promising design method (ClassSheets) to be applied to a huge collection of legacy spreadsheets with minimal effort.&lt;/p&gt;
</style></abstract></record></records></xml>