Cunha, Jácome, João Paulo Fernandes, and João Saraiva. "
Spreadsheet Engineering."
Central European Functional Programming School - 5th Summer School, CEFP 2013, Revised Selected Papers. Eds. Viktória Zsók, and et al. Lecture Notes in Computer Science. Springer, Heidelberg 2014.
AbstractThese tutorial notes present a methodology for spreadsheet engineering. First, we present data mining and database techniques to reason about spreadsheet data. These techniques are used to compute relationships between spreadsheet elements (cells/columns/rows). These relations are then used to infer a model defining the business logic of the spreadsheet. Such a model of a spreadsheet data is a visual domain specific language that we embed in a well-known spreadsheet system. The embedded model is the building block to define techniques for model-driven spreadsheet development, where advanced techniques are used to guarantee the model-instance synchronization. In this model-driven environment, any user data update as to follow the the model-instance conformance relation, thus, guiding spreadsheet users to introduce correct data. Data refinement techniques are used to synchronize models and instances after users update/evolve the model. These notes briefly describe our model-driven spreadsheet environment, the MDSheet environment, that implements the presented methodology. To evaluate both proposed techniques and the MDSheet tool, we have conducted, in laboratory sessions, an empirical study with the summer school participants. The results of this study are presented in these notes.
Chastre, C., M. Ludovico-Marques, J. Saumell, M. Guerrero, and M. Delgado. "
Surveying of Sandstone Monuments: New and Traditional Methodologies to Assess Viability of Conservation Actions."
40th IAHS Word Congress of Housing. Sustainable Housing Construction. Funchal, Portugal 2014. ID 307 (10p).
AbstractSandstone building stones are important in the building elements of Portuguese monuments, particularly in the western and southern regions. Alveolization due to salt crystallization was the most important degradation pattern found in the old sandstone façades of St. Leonardo’s Church, a Portuguese monument built in Atouguia da Baleia village in the Middle Age. Its sandstone façades have a widespread distribution of deep and large alveolization patterns mainly on portals and vaults that appeared as a result of the past and present vicinity of seashore. In this paper a summary of conservation interventions carried out in the past century in St. Leonardo’s Church is presented, as well as a summary of the studies carried out in the last decade. Then the degradation patterns on the sandstone walls of St. Leonard’s Church are shown and finally the evolution of the alveolization occurred on the sandstone walls over the last sixty to seventy years is analysed. Visual inspection of sandstone walls is compared with a survey performed by laser scanning, which seems to be a powerful technology to carry out 3D geometric modelling of the building elements of stone monuments and also the 3D mapping of stone degradation patterns.
Mota, Bruna, Maria Isabel Gomes, and Ana P. Barbosa-Povoa. "
Supply Chain Design towards sustainability: accounting for growth and jobs."
Proceedings of the 8th International Conference on Foundations of Computer-Aided Process Design – FOCAPD 2014. Washington, USA 2014. 789-794.
AbstractSustainable supply chain design is nowadays an important topic where not only economic and environmental aspects should be accounted for, but also social aspects are to be considered. A mathematical programming model was developed and a case-study was performed considering two different social indicators: one that prefers facility location in regions of lower GDP and the other in regions of higher unemployment rate. Results show that the outcome depends on the indicator used. However, for the case presented, minimum cost solution also corresponds to a good social solution regarding GDP, which could translate into economic incentives for the company.