Towards the design and implementation of aspect-oriented programming for spreadsheets

A spreadsheet usually starts as a simple and singleuser software artifact, but, as frequent as in other software systems, quickly evolves into a complex system developed by many actors. Often, different users work on different aspects of the same spreadsheet: while a secretary may be only involved in adding plain data to the spreadsheet, an accountant may define new business rules, while an engineer may need to adapt the spreadsheet content so it can be used by other software systems.Unfortunately,spreadsheetsystemsdonotoffermodular mechanisms, and as a consequence, some of the previous tasks may be defined by adding intrusive “code” to the spreadsheet. In this paper we go through the design and implementation of an aspect-oriented language for spreadsheets so that users can work on different aspects of a spreadsheet in a modular way. For example, aspects can be defined in order to introduce new business rules to an existing spreadsheet, or to manipulate the spreadsheet data to be ported to another system. Aspects are defined as aspect-oriented program specifications that are dynamically woven into the underlying spreadsheet by an aspect weaver. In this aspect-oriented style of spreadsheet development, differentusers develop,orreuse,aspects withoutaddingintrusive code to the original spreadsheet. Such code is added/executed by the spreadsheet weaving mechanism proposed in this paper.

Embedding, evolution, and validation of model-driven spreadsheets

This paper proposes and validates a model-driven software engineering technique for spreadsheets. The technique that we envision builds on the embedding of spreadsheet models under a widely used spreadsheet system. This means that we enable the creation and evolution of spreadsheet models under a spreadsheet system. More precisely, we embed ClassSheets, a visual language with a syntax similar to the one offered by common spreadsheets, that was created with the aim of specifying spreadsheets. Our embedding allows models and their conforming instances to be developed under the same environment. In practice, this convenient environment enhances evolution steps at the model level while the corresponding instance is automatically co-evolved.Finally,wehave designed and conducted an empirical study with human users in order to assess our technique in production environments. The results of this study are promising and suggest that productivity gains are realizable under our model-driven spreadsheet development setting.

A novel approach for honey pollen profile assessment using an electronic tongue and chemometric tools

Nowadays the main honey producing countries require accurate labeling of honey before commercialization, including floral classification. Traditionally, this classification is made by melissopalynology analysis, an accurate but time-consuming task requiring laborious sample pre-treatment and high-skilled technicians. In this work the potential use of a potentiometric electronic tongue for pollinic assessment is evaluated, using monofloral and polyfloral honeys. The results showed that after splitting honeys according to color (white, amber and dark), the novel methodology enabled quantifying the relative percentage of the main pollens (Castanea sp., Echium sp., Erica sp., Eucaliptus sp., Lavandula sp., Prunus sp., Rubus sp. and Trifolium sp.). Multiple linear regression models were established for each type of pollen, based on the best sensors sub-sets selected using the simulated annealing algorithm. To minimize the overfitting risk, a repeated K-fold cross-validation procedure was implemented, ensuring that at least 10-20% of the honeys were used for internal validation. With this approach, a minimum average determination coefficient of 0.91 ± 0.15 was obtained. Also, the proposed technique enabled the correct classification of 92% and 100% of monofloral and polyfloral honeys, respectively. The quite satisfactory performance of the novel procedure for quantifying the relative pollen frequency may envisage its applicability for honey labeling and geographical origin identification. Nevertheless, this approach is not a full alternative to the traditional melissopalynologic analysis; it may be seen as a practical complementary tool for preliminary honey floral classification, leaving only problematic cases for pollinic evaluation.

HEP-Frame: A software engineered framework to aid the development and efficient multicore execution of scientific code

This work was supported by FCT (Fundação para a Ciência e Tecnologia) within Project Scope (UID/CEC/00319/2013), by LIP (Laboratório de Instrumentação e Física Experimental de Partículas) and by Project Search-ON2 (NORTE-07-0162- FEDER-000086), co-funded by the North Portugal Regional Operational Programme (ON.2 - O Novo Norte), under the National Strategic Reference Framework, through the European Regional Development Fund.

Improving quality of medical service with mobile health software

An increasing number of m-Health applications are being developed benefiting health service delivery. In this paper, a new methodology based on the principle of calm computing applied to diagnostic and therapeutic procedure reporting is proposed. A mobile application was designed for the physicians of one of the Portuguese major hospitals, which takes advantage of a multi-agent interoperability platform, the Agency for the Integration, Diffusion and Archive (AIDA). This application allows the visualization of inpatients and outpatients medical reports in a quicker and safer manner, in addition to offer a remote access to information. This project shows the advantages in the use of mobile software in a medical environment but the first step is always to build or use an interoperability platform, flexible, adaptable and pervasive. The platform offers a comprehensive set of services that restricts the development of mobile software almost exclusively to the mobile user interface design. The technology was tested and assessed in a real context by intensivists.

Refinement and variability techniques in model transformation of software requirements

Tese de Doutoramento em Tecnologias e Sistemas de Informação

Electronic transport across linear defects in graphene

We investigate the low-energy electronic transport across grain boundaries in graphene ribbons and infinite flakes. Using the recursive Green’s function method, we calculate the electronic transmission across different types of grain boundaries in graphene ribbons. We show results for the charge density distribution and the current flow along the ribbon. We study linear defects at various angles with the ribbon direction, as well as overlaps of two monolayer ribbon domains forming a bilayer region. For a class of extended defect lines with periodicity 3, an analytic approach is developed to study transport in infinite flakes. This class of extended grain boundaries is particularly interesting, since the K and K0 Dirac points are superposed.

Sensory intensity assessment of olive oils using an electronic tongue

Olive oils may be commercialized as intense, medium or light, according to the intensity perception of fruitiness, bitterness and pungency attributes, assessed by a sensory panel. In this work, the capability of an electronic tongue to correctly classify olive oils according to the sensory intensity perception levels was evaluated. Cross-sensitivity and non-specific lipid polymeric membranes were used as sensors. The sensor device was firstly tested using quinine monohydrochloride standard solutions. Mean sensitivities of 14±2 to 25±6 mV/decade, depending on the type of plasticizer used in the lipid membranes, were obtained showing the device capability for evaluating bitterness. Then, linear discriminant models based on sub-sets of sensors, selected by a meta-heuristic simulated annealing algorithm, were established enabling to correctly classify 91% of olive oils according to their intensity sensory grade (leave-one-out cross-validation procedure). This capability was further evaluated using a repeated K-fold cross-validation procedure, showing that the electronic tongue allowed an average correct classification of 80% of the olive oils used for internal-validation. So, the electronic tongue can be seen as a taste sensor, allowing differentiating olive oils with different sensory intensities, and could be used as a preliminary, complementary and practical tool for panelists during olive oil sensory analysis.

Desenvolvimento e otimização do projeto mecatrónico para um Tribómetro Linear

Dissertação de mestrado integrado em Engenharia Mecânica

Monovarietal extra-virgin olive oil classification: a fusion of human sensory attributes and an electronic tongue

Olive oil quality grading is traditionally assessed by human sensory evaluation of positive and negative attributes (olfactory, gustatory, and final olfactorygustatory sensations). However, it is not guaranteed that trained panelist can correctly classify monovarietal extra-virgin olive oils according to olive cultivar. In this work, the potential application of human (sensory panelists) and artificial (electronic tongue) sensory evaluation of olive oils was studied aiming to discriminate eight single-cultivar extra-virgin olive oils. Linear discriminant, partial least square discriminant, and sparse partial least square discriminant analyses were evaluated. The best predictive classification was obtained using linear discriminant analysis with simulated annealing selection algorithm. A low-level data fusion approach (18 electronic tongue signals and nine sensory attributes) enabled 100 % leave-one-out cross-validation correct classification, improving the discrimination capability of the individual use of sensor profiles or sensory attributes (70 and 57 % leave-one-out correct classifications, respectively). So, human sensory evaluation and electronic tongue analysis may be used as complementary tools allowing successful monovarietal olive oil discrimination.

Electronic structure and optical signatures of semiconducting transition metal dichalcogenide nanosheets

CONSPECTUS: Two-dimensional (2D) crystals derived from transition metal dichalcogenides (TMDs) are intriguing materials that offer a unique platform to study fundamental physical phenomena as well as to explore development of novel devices. Semiconducting group 6 TMDs such as MoS2 and WSe2 are known for their large optical absorption coefficient and their potential for high efficiency photovoltaics and photodetectors. Monolayer sheets of these compounds are flexible, stretchable, and soft semiconductors with a direct band gap in contrast to their well-known bulk crystals that are rigid and hard indirect gap semiconductors. Recent intense research has been motivated by the distinct electrical, optical, and mechanical properties of these TMD crystals in the ultimate thickness regime. As a semiconductor with a band gap in the visible to near-IR frequencies, these 2D MX2 materials (M = Mo, W; X = S, Se) exhibit distinct excitonic absorption and emission features. In this Account, we discuss how optical spectroscopy of these materials allows investigation of their electronic properties and the relaxation dynamics of excitons. We first discuss the basic electronic structure of 2D TMDs highlighting the key features of the dispersion relation. With the help of theoretical calculations, we further discuss how photoluminescence energy of direct and indirect excitons provide a guide to understanding the evolution of the electronic structure as a function of the number of layers. We also highlight the behavior of the two competing conduction valleys and their role in the optical processes. Intercalation of group 6 TMDs by alkali metals results in the structural phase transformation with corresponding semiconductor-to-metal transition. Monolayer TMDs obtained by intercalation-assisted exfoliation retains the metastable metallic phase. Mild annealing, however, destabilizes the metastable phase and gradually restores the original semiconducting phase. Interestingly, the semiconducting 2H phase, metallic 1T phase, and a charge-density-wave-like 1T' phase can coexist within a single crystalline monolayer sheet. We further discuss the electronic properties of the restacked films of chemically exfoliated MoS2. Finally, we focus on the strong optical absorption and related exciton relaxation in monolayer and bilayer MX2. Monolayer MX2 absorbs as much as 30% of incident photons in the blue region of the visible light despite being atomically thin. This giant absorption is attributed to nesting of the conduction and valence bands, which leads to diversion of optical conductivity. We describe how the relaxation pathway of excitons depends strongly on the excitation energy. Excitation at the band nesting region is of unique significance because it leads to relaxation of electrons and holes with opposite momentum and spontaneous formation of indirect excitons.

Flexible organic–inorganic hybrid layer encapsulation for organic opto-electronic devices

In this work we produce and study the flexible organic–inorganic hybrid moisture barrier layers for the protection of air sensitive organic opto-electronic devices. The inorganic amorphous silicon nitride layer (SiNx:H) and the organic PMMA [poly (methyl methacrylate)] layer are deposited alternatingly by using hot wire chemical vapor deposition (HW-CVD) and spin-coating techniques, respectively. The effect of organic–inorganic hybrid interfaces is analyzed for increasing number of interfaces. We produce highly transparent (∼80% in the visible region) hybrid structures. The morphological properties are analysed providing a good basis for understanding the variation of the water vapor transmission rate (WVTR) values. A minimum WVTR of 4.5 × 10−5g/m2day is reported at the ambient atmospheric conditions for 7 organic/inorganic interfaces. The hybrid barriers show superb mechanical flexibility which confirms their high potential for flexible applications.

Optical properties of zirconium oxynitride films: the effect of composition, electronic and crystalline structures

tThis work is devoted to the investigation of zirconium oxynitride (ZrOxNy) films with varied opticalresponses prompted by the variations in their compositional and structural properties. The films wereprepared by dc reactive magnetron sputtering of Zr, using Ar and a reactive gas mixture of N2+ O2(17:3).The colour of the films changed from metallic-like, very bright yellow-pale and golden yellow, for low gasflows to red-brownish for intermediate gas flows. Associated to this colour change there was a significantdecrease of brightness. With further increase of the reactive gas flow, the colour of the samples changedfrom red-brownish to dark blue or even to interference colourations. The variations in composition dis-closed the existence of four different zones, which were found to be closely related with the variationsin the crystalline structure. XRD analysis revealed the change from a B1 NaCl face-centred cubic zirco-nium nitride-type phase for films prepared with low reactive gas flows, towards a poorly crystallizedover-stoichiometric nitride phase, which may be similar to that of Zr3N4with some probable oxygeninclusions within nitrogen positions, for films prepared with intermediate reactive gas flows. For highreactive gas flows, the films developed an oxynitride-type phase, similar to that of -Zr2ON2with someoxygen atoms occupying some of the nitrogen positions, evolving to a ZrO2monoclinic type structurewithin the zone where films were prepared with relatively high reactive gas flows. The analysis carriedout by reflected electron energy loss spectroscopy (REELS) revealed a continuous depopulation of thed-band and an opening of an energy gap between the valence band (2p) and the Fermi level close to 5 eV.The ZrN-based coatings (zone I and II) presented intrinsic colourations, with a decrease in brightness anda colour change from bright yellow to golden yellow, red brownish and dark blue. Associated to thesechanges, there was also a shift of the reflectivity minimum to lower energies, with the increase of thenon-metallic content. The samples lying in the two last zones (zone III, oxynitride and zone IV, oxide films)revealed a typical semi-transparent-optical behaviour showing interference-like colourations only dueto the complete depopulation of the d band at the Fermi level. The samples lying in these zones presentedalso an increase of the optical bandgap from 2 to 3.6 eV.

Requalificação de uma máquina-ferramenta

Dissertação de mestrado integrado em Engenharia Mecânica

Estudo e implementação de testes de software em desenvolvimento ágil

Dissertação de mestrado em Engenharia de Sistemas