Cunha, Jácome, João Paulo Fernandes, Jorge Mendes, and João Saraiva. "
MDSheet: A Framework for Model-driven Spreadsheet Engineering."
Proceedings of the 34rd International Conference on Software Engineering. ICSE'12. ACM, 2012. 1395-1398.
Abstractn this paper, we present MDSHEET, a framework for the embedding, evolution and inference of spreadsheet models. This framework offers a model-driven software development mechanism for spreadsheet users.
Cunha, Jácome, João Saraiva, and Joost Visser. "
Model-Based Programming Environments for Spreadsheets."
Programming Languages. Eds. Francisco de Carvalho Junior, and Luis Barbosa. Vol. 7554. Lecture Notes in Computer Science, 7554. Springer Berlin / Heidelberg, 2012. 117-133.
AbstractAlthough spreadsheets can be seen as a flexible programming environment, they lack some of the concepts of regular programming languages, such as structured data types. This can lead the user to edit the spreadsheet in a wrong way and perhaps cause corrupt or redundant data. We devised a method for extraction of a relational model from a spreadsheet and the subsequent embedding of the model back into the spreadsheet to create a model-based spreadsheet programming environment. The extraction algorithm is specific for spreadsheets since it considers particularities such as layout and column arrangement. The extracted model is used to generate formulas and visual elements that are then embedded in the spreadsheet helping the user to edit data in a correct way. We present preliminary experimental results from applying our approach to a sample of spreadsheets from the EUSES Spreadsheet Corpus.
Cunha, Jácome Model-based Spreadsheet Engineering: Using Relational Models to Improve Spreadsheets. Eds. Shahanaz Soogah. LAP LAMBERT Academic Publishing, 2012.
AbstractSpreadsheets can be viewed as programming languages for non-professional programmers. These so-called ``end-user'' programmers vastly outnumber professional programmers creating millions of new spreadsheets every year. As a programming language, spreadsheets lack support for abstraction, testing, encapsulation, or structured programming. As a result, and as numerous studies have shown, the high rate of production is accompanied by an alarming high rate of errors. Some studies report that up to 90% of real-world spreadsheets contain errors. After their initial creation, many spreadsheets turn out to be used for storing and processing increasing amounts of data and supporting increasing numbers of users over long periods of time, making them complicated systems. An emerging solution to handle the complex and evolving software systems is Model-driven Engineering (MDE). To consider models as first class entities and any software artifact as a model or a model element is one of the basic principles of MDE. We adopted some techniques from MDE to solve spreadsheet problems. Most spreadsheets (if not all) lack a proper specification or a model. Using reverse engineering techniques we are able to derive various models from legacy spreadsheets. We use functional dependencies (a formalism that allow us to define how some column values depend on other column values) as building blocks for these models. Models can be used for several spreadsheet improvements, namely refactoring, safe evolution, migration or even generation of edit assistance. The techniques presented in this work are available under the framework HAEXCEL that we developed. It is composed of online and batch tools, reusable HASKELL libraries and OpenOffice.org extensions. A study with several end-users was organized to survey the impact of the techniques we designed. The results of this study indicate that the models can bring great benefits to spreadsheet engineering helping users to commit fewer errors and to work faster.
Pereira, Pedro, Helena Fino, Fernando Coito, and M. Ventim-Neves. "
Optimization-Based Design of Nano-CMOS LC-VCOs."
Doctoral Conference on Computing, Electrical and Industrial Systems, DoCEIS 2012. Eds. Luis Camarinha-Matos, Ehsan Shahamatnia, and Gonçalo Nunes. Vol. 372. IFIP Advances in Information and Communication Technology, 372. Costa de Caparica - Portugal: Springer Boston, 2012. 453-464.
AbstractThis paper introduces a variability-aware methodology for the design of LC-VCOs in Nano-CMOS technologies. The complexity of the design as well as the necessity for having an environment offering the possibility for exploring design trade-offs has led to the development of design methodologies based multi-objective optimization procedures yielding the generation of Pareto-optimal surfaces. The efficiency of the process is granted by using analytical models for both passive and active devices. Although physics-based analytical expressions have been proposed for the evaluation of the lumped elements, the variability of the process parameters is usually ignored due to the difficulty to formalize it into an optimization performance index. The usually adopted methodology of considering only optimum solutions for the Pareto surface, may lead to pruning quasi-optimal solutions that may prove to be better, should their sensitivity to process parameter variation be accounted for. In this work we propose starting by generating an extended Pareto surface where both optimum and quasi-optimum solutions are considered. Finally information on the sensitivity to process parameter variations, is used for electing the best design solution.
Pereira, Pedro, Fernando Coito, and Helena Fino. "
PSO-Based Design of RF Integrated Inductor."
Doctoral Conference on Computing, Electrical and Industrial Systems, DoCEIS 2012. Eds. Luis Camarinha-Matos, Ehsan Shahamatnia, and Gonçalo Nunes. Vol. 372. IFIP Advances in Information and Communication Technology, 372. Costa de Caparica - Portugal: Springer Boston, 2012. 475-482.
AbstractThis paper addresses an optimization-based approach for the design of RF integrated inductors. The methodology presented deals with the complexity of the design problem by formulating it as a multi-objective optimization. The multi-modal nature of the underlying functions combined with the need to be able to explore design trade-offs leads to the use of niching methods. This allows exploring not only the best trade-off solutions lying on the Pareto-optimum surface but also the quasi-optimum solutions that would be otherwise discarded. In this paper we take advantage of the niching properties of lbest PSO algorithm using ring topology to devise a simple optimizer able to find the local-optima. For the efficiency of the process analytical models are used for the passive/active devices. In spite the use of physics-based analytical expressions for the evaluation of the lumped elements, the variability of the process parameters is ignored in the optimization stage due to the significant computational burden it involves. Thus in the final stage both the Pareto-optimum solutions and the quasi-optimum solutions are evaluated with respect to the sensitivity to process parameter variations.
Cunha, Jácome, João Paulo Fernandes, Jorge Mendes, Pedro Martins, and João Saraiva. "
SmellSheet Detective: A Tool for Detecting Bad Smells in Spreadsheets."
Proceedings of the 2012 IEEE Symposium on Visual Languages and Human-Centric Computing. VLHCC '12. Washington, DC, USA: IEEE Computer Society, 2012. 243-244.
AbstractThis tool demo paper presents SmellSheet Detective: a tool for automatically detecting bad smells in spreadsheets. We have defined a catalog of bad smells in spreadsheet data which was fully implemented in a reusable library for the manipulation of spreadsheets. This library is the building block of the SmellSheet Detective tool, that has been used to detect smells in large, real-world spreadsheet within the EUSES corpus, in order to validate and evolve our bad smells catalog.