Software refactoring is a well-known technique that provides transformations on software artifacts with the aim of improving their overall quality. In this paper we present a set of refactorings for ClassSheets, a modeling language that allows to specify the business logic of a spreadsheet in an object-oriented fashion. The set of refactorings that we propose allows us to improve the quality of these spreadsheet models. Moreover, it is implemented in a setting that guarantees that all model refactorings are automatically carried to all the corresponding (spreadsheet) instances, thus providing an automatic evolution of the data so it is always synchronized with the model.

Despite being staggeringly error prone, spreadsheets are a highly flexible programming environment that is widely used in industry. In fact, spreadsheets are widely adopted for decision making, and decisions taken upon wrong (spreadsheet-based) assumptions may have serious economical impacts on businesses, among other consequences. This paper proposes a technique to automatically pinpoint potential faults in spreadsheets. It combines a catalog of spreadsheet smells that provide a first indication of a potential fault, with a generic spectrum-based fault localization strategy in order to improve (in terms of accuracy and false positive rate) on these initial results. Our technique has been implemented in a tool which helps users detecting faults. To validate the proposed technique, we consider a well-known and well-documented catalog of faulty spreadsheets. Our experiments yield two main results: we were able to distinguish between smells that can point to faulty cells from smells and those that are not capable of doing so; and we provide a technique capable of detecting a significant number of errors: two thirds of the cells labeled as faulty are in fact (documented) errors.

This technical report describes the research goals and results of the SpreadSheet as a Programming Paradigm research project. This was a project funded by Funda{\c c}ão para a Ciencia e Tecnologia – FCT: the Portuguese research foundation, under reference FCOMP-01-0124-FEDER-010048, that ran from May 2010 till July 2013. This report includes the complete document reporting the results achieved during the project execution, which was submitted to FCT for evaluation on October 2013. It describes the goals of the project, and the different research tasks presenting the deliver- ables of each of them. It also presents the management and result dissemination work performed during the project's execution. The document includes also a self assess- ment of the achieved results, and a complete list of scientific publications describing the contributions of the project. Finally, this document includes the FCT evaluation report.

Two new Late Jurassic (uppermost Late Kimmeridgian) dinosaur eggshell sites are described, Casal da Rola and Porto das Barcas, both near Lourinha˜, central-west Portugal. Casal da Rola yields eggshells with an obliquiprismatic morphotype comparable to those from a nest with the associated fossil embryos from Paimogo, tentatively assigned to the theropod Lourinhanosaurus antunesi. The Porto das Barcas eggshells have a dendrospherulitic morphotype with a prolatocanaliculate pore system. This morphotype was also recognised in eggshells from a clutch with associated Torvosaurus embryos at the Porto das Barcas locality. A preliminary cladistic analysis of eggshell morphology suggests theropod affinities for the Casal da Rola eggs, but is unable to resolve the phylogenetic position of the Porto das Barcas eggs. The eggshells at both sites are preserved in distal flood plain mudstones and siltstones. Carbonate concretions within the deposits indicate paleosol development.

In the face of growing global game production competition, the ability to come out with new ideas to create computer games is widely recognized today as important. In this context, the chance to resort - in a practical way - to known creativity techniques or adaptations of these to help innovation in this field is a promising challenge, both in the field of entertainment games and the so called serious games. In this article we present the development of a research work in this area and the result proposal method for the introduction of creativity in Games Design. The main objective is the construction of innovative Games that have not been identified by the normal methods used in the analysis of games proposals. We present a case study of the method implemented for the identification of new games design opportunities in an MSc Games course.

The color sensing ability of a data acquisition prototype system integrating a 32 linear array of 1D amorphous silicon position sensitive detectors (PSD) was analyzed. Besides being used to reproduce a 3D profile of highly reflective surfaces, here we show that it can also differentiate primary red, green, blue (RGB) and derived colors. This was realized by using an incident beam with a RGB color combination and adequate integration times taking into account that a color surface mostly reflects its corresponding color. A mean colorimetric error of 25.7 was obtained. Overall, we show that color detection is possible via the use of this sensor array system, composed by a simpler amorphous silicon pin junction. © 2013 Elsevier B.V. All rights reserved.

... Title Elemental characterization of plants and soils in Panasqueira tungsten mining region Journal Journal of Soils and Sediments Volume 14, Issue 4 , pp 778-784 Cover Date 2014-04-01 DOI 10.1007 / s11368 - 013 - 0788 - x Print ISSN 1439-0108 Online ISSN 1614-7480 ...