Many errors in spreadsheet formulas can be avoided if spreadsheets are built automatically from higher-level models that can encode and enforce consistency constraints in the generated spreadsheets. Employing this strategy for legacy spreadsheets is difficult, because the model has to be reverse engineered from an existing spreadsheet and existing data must be transferred into the new model-generated spreadsheet. We have developed and implemented a technique that automatically infers relational schemas from spreadsheets. This technique uses particularities from the spreadsheet realm to create better schemas. We have evaluated this technique in two ways: First, we have demonstrated its applicability by using it on a set of real-world spreadsheets. Second, we have run an empirical study with users. The study has shown that the results produced by our technique are comparable to the ones developed by experts starting from the same (legacy) spreadsheet data. Although relational schemas are very useful to model data, they do not fit well spreadsheets as they do not allow to express layout. Thus, we have also introduced a mapping between relational schemas and ClassSheets. A ClassSheet controls further changes to the spreadsheet and safeguards it against a large class of formula errors. The developed tool is a contribution to spreadsheet (reverse) engineering, because it fills an important gap and allows a promising design method (ClassSheets) to be applied to a huge collection of legacy spreadsheets with minimal effort.

In Europe, the technology development of high-speed trains is increasingly exposed to societal needs, driven by ICT advancements, external to traditional design. Together with the liberalisation of the rail markets and increase pressures from other transport modes leads to an unprecedented situation where planers, operators and suppliers of high-speed have to take decision in this complex and competitive environment.
In such broadening of elements influencing design and, thus, product development process, from the survey here to be presented, it was not observed technology options assessment or strategic agenda setting from visions shifting in the same way.
For the high-speed train industry this new trend requires going beyond the visions of the past 15 to 20 years’ practices of “sector endogenous” and structurally closed strategic methods approaches to a broader interaction with the widening of societal actors now capable of being active contributors to innovation from digitalization.
This way to understand the European industry readiness for undertaking such supra systemic challenge, this paper presents the results from a survey conducted by the authors to 74 representatives of the high-speed train innovation chain regarding to which extent societal embedding is considered in the drafting of their visions and technology development projects.
This work becomes even more pertinent if considered that the debate is now open in the railway industry (not exclusive to high-speed trains) as they are launching the joint initiative SHIFT2RAIL, revise ERRAC (the European Rail Research Advisory Council) mandate and enter in a new research cycle with the European research framework Horizon 2020.

© 2016, Springer-Verlag Berlin Heidelberg.The glaze and in-glaze pigments of the historical nineteenth-century glazed tiles from the Pena National Palace (Sintra, Portugal) were characterized using a multi-analytical approach. Chemical composition and microstructural characterization were ascertained by µ-PIXE, µ-Raman, optical microscopy and VP-SEM–EDS. The manufacturing technique and colour palette in these tiles were found to be close to the ceramic pigments used in traditional majolica. The blue and purple colours derive from cobalt oxide and manganese oxide, respectively. A mixture of Pb–Sn–Sb yellow with cobalt oxide and iron oxide was used for green and dark yellow, respectively, while grey tonalities consist of a complex mixture of cobalt oxide, manganese oxide and Pb–Sn–Sb yellow in different proportions. Results obtained allowed the determination of the oxides and elements used in pigments as well as production techniques, resorting to traditional majolica manufacture, although the tiles were produced by the end of the nineteenth century.

n/a

Punching-shear capacity of slab-column connections in existing R/C structures may be inadequate to bear design loads, so strengthening works are required. The lack of punching resistance may be due to detailing, design or building errors; in other cases, such lack is due to a change of use, which requires an increase of resistance. Different techniques have been developed for strengthening R/C slabs against punching: enlargement of the support, gluing external fibre reinforced polymers or casting a bonded concrete overlay (BCO) on the slab's top surface, insertion of post-installed steel bolts, application of fibre reinforced polymers cords as shear reinforcement. In the paper, the authors apply the Critical Shear Crack Theory (CSCT) to all of these techniques and evaluate their efficacy with reference to a case study.

The work reported here addresses load matching improvement in Net Zero Energy Buildings (Net-ZEBs). The related relevant literature shows that currently research work is mainly focused on improving the load matching of individual buildings. In this paper the concept of a Cooperative Net Zero Energy Community (CNet-ZEC) is introduced, extending discussion to the enhancement of load matching at a wider community level. Both building and community levels are compared in order to assess the work proposed here, through the analysis of three distinct scenarios where five Net-ZEBs work individually or in community.

The results presented here were obtained through a detailed simulation based on 1-min resolution stochastic load profiles and recorded weather data. The results indicate that over the period of a year the CNet-ZEC has the potential to increase the electrical demand covered by onsite electricity generation up to 21% and the on-site generation that is used by the building up to 15%. The following elements are considered by the CNet-ZEC in order to produce those results: (i) demand heterogeneity of the buildings integrating the community; (ii) the higher number of controllable devices; and (iii) the potential higher amount of energy available to satisfy the community demand.

A large collection of vertebrate coprolites from black lacustrine shales in the Late Triassic (Rhaetian–Sinemurian) Kap Stewart Formation, East Greenland is examined with regard to internal and external morphology, prey inclusions, and possible relationships to the contemporary vertebrate fauna. A number of the coprolites were mineralogically examined by X-ray diffraction (XRD), showing the primary mineral composition to be apatite, clay minerals, carbonates and, occasionally, quartz in the form of secondary mineral grains. The coprolite assemblage shows multiple sizes and morphotypes of coprolites, and different types of prey inclusions, demonstrating that the coprolite assemblage originates from a variety of different producers.Supplementary material: A description of the size, shape, structure, texture, contents and preservation of the 328 specimens is available at https://doi.org/10.6084/m9.figshare.c.2134335

http://docentes.fct.unl.pt/lblm/files/methodsmolbiol-2016-1424-81.pdf

The purpose of this application, under Articles 78.1 and 81.1 of the Code, is to replace Diplodocus longus Marsh, 1878 as the type species of the sauropod dinosaur genus Diplodocus by the much better represented D. carnegii Hatcher, 1901, due to the undiagnosable state of the holotype of D. longus (YPM 1920, a partial tail and a chevron). The holotype of D. carnegii, CM 84, is a well-preserved and mostly articulated specimen. Casts of it are on display in various museums around the world, and the species has generally been used as the main reference for studies of comparative anatomy or phylogeny of the genus. Both species are known from the Upper Jurassic Morrison Formation of the western United States. The genus Diplodocus is the basis for the family-level taxa diplodocinae Marsh, 1884, diplodocidae Marsh, 1884, diplodocimorpha Marsh, 1884 (Calvo & Salgado, 1995) and diplodocoidea Marsh, 1884 (Upchurch, 1995). It is also a specifier of at least 10 phylogenetic clades. With the replacement of D. longus by D. carnegii as type species, Diplodocus could be preserved as a taxonomic name with generally accepted content. Taxonomic stability of the entire clade diplodocoidea, and the proposed definitions of several clades within Sauropoda, could be maintained.

n/a

Software refactoring is a well-known technique that provides transformations on software artifacts with the aim of improving their overall quality.

In the past, we have proposed a catalog of refactoring for spreadsheet models expressed in the ClassSheets modeling language, which allows us to specify the business logic of a spreadsheet in an object-oriented fashion.

Reasoning about spreadsheets at the model level enhances a model-driven spreadsheet environment where a ClassSheet model and its conforming instance (the spreadsheet data) automatically co-evolves after a refactoring is applied at the model level. Our motivation for such research was to improve the model and its conforming instance: the spreadsheet data.

In this paper we define such refactorings using previously proposed evolution steps for models and instances.

We also present an empirical study we designed and conducted in order to confirm our original intuition that these refactorings have a positive impact on end-user productivity, both in terms of effectiveness and efficiency.

The results are presented not only in terms of productivity changes between refactored and non-refactored scenarios, but also in terms of overall user satisfaction, relevance, and experience.

In almost all cases the refactorings indeed improved end-users productivity. Moreover, in most cases users were more engaged with the refactored version of the spreadsheets they worked with.

n/a

© 2016 Elsevier B.V. All rights reserved.Different glasses based on the ZnO-B2O3-SiO2 system, with a ZnO content ≥ 60 mol{%} and a fixed SiO2 content (20 mol{%}), were synthesised using a melt-quenching method. Glass samples with zinc oxide concentrations as high as 65 mol{%} were prepared successfully without deteriorating the glass-forming ability. The glass samples were submitted to controlled heat-treatments, and the effect of the ZnO/B2O3 molar ratio on the formation of crystalline phases within the glass matrix was investigated by means of differential thermal analysis (DTA), X-ray diffraction (XRD) and scanning electron microscopy (SEM). DTA results indicated that the glass transition and the onset crystallization temperatures of the studied glasses tended to increase with the increment on the ZnO/B2O3 ratio. XRD data showed that the zinc binary crystalline phases, willemite (Zn2SiO4), a zinc orthosilicate, and zinc borate (Zn3B2O6) could be present in the crystallized glasses, depending on the heat-treatment conditions. The formation of willemite was promoted by an increasing ZnO/B2O3 ratio. Microstructural observations performed by SEM indicated that under controlled experimental parameters (glass composition, heat-treatment temperature and time) the precipitation of nanocrystals within the glass matrix can be achieved, resulting in transparent and translucent willemite glass-ceramics.

A Developmental Coordination Disorder can be identified when children show motor skills either below the expected levels considered adequate to their physical age or the opportunities provided for their learning. This problem affects four to six percent of school-age children, meaning that, from a very early stage of their life, they have several difficulties to adapt to the daily needs. In order to reduce the impact caused by this disorder, a team of therapists from “ – collected a wide range of exercises that allow the stimulus of several motor areas, including both the Gross and Fine Motor Skills. However, the application of this therapeutics is restricted to regular appointments. Since the motor stimulus, in order to be effective, need continuous application, it was found to be necessary to have a tool that in a practical and affordable way, fulfill this need. Therefore, the proposal presented in this article describes the creation of a systematic collection of such exercises in a friendly user manner for the children to be able to exercise elsewhere.

© 2016 Taylor {&} Francis.A laboratory-based methodology was designed to assess the bioreceptivity of glazed tiles. The experimental set-up consisted of multiple steps: manufacturing of pristine and artificially aged glazed tiles, enrichment of phototrophic microorganisms, inoculation of phototrophs on glazed tiles, incubation under optimal conditions and quantification of biomass. In addition, tile intrinsic properties were assessed to determine which material properties contributed to tile bioreceptivity. Biofilm growth and biomass were appraised by digital image analysis, colorimetry and chlorophyll a analysis. SEM, micro-Raman and micro-particle induced X-ray emission analyses were carried out to investigate the biodeteriorating potential of phototrophic microorganisms on the glazed tiles. This practical and multidisciplinary approach showed that the accelerated colonization conditions allowed different types of tile bioreceptivity to be distinguished and to be related to precise characteristics of the material. Aged tiles showed higher bioreceptivity than pristine tiles due to their higher capillarity and permeability. Moreover, biophysical deterioration caused by chasmoendolithic growth was observed on colonized tile surfaces.

The precursor of the North Atlantic existed between the North American and Iberian blocks from the earliest Jurassic Hettangian and has been ever expanding since. By the Kimmeridgian and Tithonian, when much of the Morrison Fm rocks were deposited, the proto-Atlantic was more than 300 km wide at 27° paleolatitude between North America and Iberia. Macrovertebrate paleontology reveals a unique story to the isolation of Iberia and instead suggest a paleogeographic land connection between North American and Iberia. Torvosaurus, Allosaurus, Ceratosaurus, Stegosaurus, Supersaurus and others have a distribution restricted to Morrison Formation in North America and Lourinhã Formation in Portugal. A novel paleogeographic model is here suggested: (1) around the Middle–Late Jurassic transition there is a major palaeoceanographic and palaeoclimatic reorganization, coincidental to a major eustatic sea-level drop and uplift associated with the Callovian– Oxfordian Atlantic Regressive Event; (2) creating an ephemeral land bridge presenting a temporary opportunity for terrestrial gateways likely across the Flemish Cap and Galician Bank land masses, allowing large dinosaurian taxa to cross the northern proto-Atlantic in both directions; (3) finally, a Callovian–Oxfordian faunal exchange around the 163 Ma, through latest Kimmeridgian at 152 Ma (the age of equivalent genera in both Morrison and Portugal), is was an interval that allowed speciation, but retaining generic similarity of vertebrates. This model is consistent with the chronology and taxonomy required for speciation of the Iberian and American forms, exemplified by the coeval sister-taxa pairs Torvosaurus tanneri and T. gurneyi, Allosaurus fragilis and A. europaeus, or Supersaurus vivianae and S. lourinhanensis. While some of the smaller animals in the fauna show Morrison/Portugal affinities, most from Iberia have European or even Asian affinities. The larger-bodied fauna are more closely related to Morrison than to mainland Europe (except for dacentrurine stegosaurs). The body size differences and affinities of taxa across paleogeography is comparable to what is observed today across the Wallace Line. Migration may have also occurred in both directions. The closest relative of Torvosaurus is likely the European Bathonian Megalosaurus, thus the presence of the genus in North America represents a European migration. On other hand, Allosaurus and Supersaurus origins are consistent with a North American origin, representing an westto-east migration.

This study focuses on the assessment of the degradation processes occurring in three sandstone infills of fossilized Late Jurassic ornithopod tridactyl footprints, found in 2001 in a coastline cliff in Porto das Barcas (Lourinhã, Portugal) and exhibited in a museum display since 2004. These dinosaur footprints present nowadays severe decay phenomena compromising their physical integrity and are leading gradually to their loss of value. The deterioration patterns were recorded, a map of their distribution was prepared and several samples were collected both in the dinosaur footprints and in the coastline cliff. Different analytical procedures were applied such as XRD, FTIR, FESEM and Ion Chromatography. A microclimatic survey was also performed and air temperature and relative humidity was measured during eight months both indoor and also outdoor. The decay patterns observed are a combination intrinsic and extrinsic factors the stone material, namely swelling of clay minerals in the rock matrix (smectite and chlorite-smectite mixed-layer), presence of salts (mainly chlorides), application of past conservation treatments (poly(vinyl) acetate and epoxy resins) and with the museum's indoor thermohygrometric conditions (mainly non-stable hygrometric conditions). This scientific knowledge is therefore essential to the sustainable preservation of this paleontological heritage.