Title:Model-Driven Spreadsheets
By:Jácome Cunha (DI-FCT-UNL)
More info:http://citi.di.fct.unl.pt/seminar/seminar.php?id=238
Abstract:
Spreadsheets play a pivotal role in modern society as they are inherently multi-purpose and widely used both by individuals to cope with simple needs as well as large companies as integrators of complex systems and as support for informing business decisions. Spreadsheets have probably passed the point of no return in terms of importance: it is estimated that 95% of all U.S. firms use them for financial reporting, and 90% of all analysts in industry perform calculations in spreadsheets. This importance, however, has not been achieved together with effective mechanisms for error prevention. In this talk we will present our approach to solve this problem. In particular, we will present model-driven spreadsheets. We will start by defining a modeling approach for spreadsheets and how such models can be embedded in spreadsheet systems. We will then show how this models can automatically be inferred from existing spreadsheets. Since spreadsheets may change over time, we will present techniques for their automatic evolution, based on model changes, and vice-versa.
Short bio:
Currently, I'm an Assistant Professor at Universidade Nova de Lisboa, Department of Informatics, and a member of the research center HASLab/INESC Tec. My research is mainly focused on Programming Languages (PLs) and Software Engineering (SE), where I try to improve the effectiveness, efficiency, and usability of software. I have contributed with such techniques for spreadsheets, and for improving software energy consumption. I obtained my PhD degree in Computer Science from Universidade do Minho in 2011. I was then a post-doctoral fellow at Universidade do Minho and Oregon State University. I was also an Invited Professor at Escola Superior de Tecnologia e Gestão de Felgueiras - Instituto Politécnico do Porto.