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.
Monteiro, Rui, João Araújo, Vasco Amaral, Miguel Goulão, and Pedro Patrício. "
Model-Driven Development for Requirements Engineering: The Case of Goal-Oriented Approaches."
8th International Conference on the Quality of Information and Communications Technology (QUATIC 2012). Eds. João Pascoal Faria, Ana Paiva, and Ricardo Machado. Lisbon, Portugal: IEEE CPS, 2012.
AbstractGoal-Oriented Requirements Engineering (GORE) has received increasing attention over the past few years.
There are several goal-oriented approaches, each one using different kinds of models. We argue that it would be useful to relate them or even perform transformations among them automatically, in order to understand their similarities and differences, their advantages and disadvantages, allowing a possible migration or comparison between approaches. This is something that has not received enough attention. In this paper
we propose the definition and implementation of goal model transformations between i* and KAOS. As an immediate contribution, the approach can be used to migrate from one goal model to another through automatic model transformations. This approach also contributes to relate the concepts of i* and KAOS models and will help, for example, a development team in making the decision on which approach to follow, according to the nature of the project and the expressiveness of an approach to represent certain concepts
(e.g., obstacles are represented explicitly in KAOS, but not in i*). Another contribution is to facilitate communication among members of the same team, if they are specialized in different approaches.
Mateus, O. "
New dinosaur and pterosaur tracksites from the Late Jurassic of Portugal." Chongqing, China: 2012 Abstract Book of Qijiang International Dinosaur Tracks Symposium, 2012.
AbstractPortugal is rich on dinosaur remains (bones, eggs, and tracks) from Early Jurassic to Late
Cretaceous ages, but mainly from the Late Jurassic, in which dozen of tracksites have been reported.
Here are reported new or poorly known track localities:
1) Five tracksites share the preservation substrate (marine carbonated limestone), age (late Jurassic), geographic area (Leiria district of Portugal), kind of preservation (true tracks), and completeness (trackways of multiple individuals):
i) Praia dos Salgados includes eight trackways, mostly ornithopods and theropods, and one wide gauge sauropod, made in very soft sediment; some preserve the hallux impression.
ii) Serra de Mangues is mostly covered with vegetation but seems to include dozens of tracks comprising theropods, thyreophorans, ornithopods and sauropods.
iii) Sobral da Lagoa (Pedreira do Rio Real) include six trackways but poorly preserved;
and
iv) Serra de Bouro that preserves four sauropod trackways in one single layer.
v) Pedrógão, preserved, at least, one theropod trackway and several isolated tracks of
theropods and ornithopods were found in different layers in the Early Oxfordian.
2) The locality in Praia de Porto das Barcas yielded natural casts of stegosaur tracks
(including pes print with skin impression) and a very large sauropod pes print with about
1.2 m long pes.
3) A new pterosaur tracksite was found in the Late Jurassic of Peralta, Lourinhã (Sobral Member, Lourinhã Fm.; Late Kimmeridgian/Early Tithonian). More than 220 manus and pes tracks have been collected in about five square meters, all ascribed to pterosaurs. The tracks were produced in a thin mud layer that has been covered by sand which preserved them as sandstone mould infill (natural casts). The manus of the largest specimens is 13 cm wide and 5.5 cm long and the pes measures 14.5 cm in length and 9 cm in width. This shows the occurrence of very large pterosaurs in the Late Jurassic. Other pterosaur tracksites in the Late Jurassic of Portugal are: Porto das Barcas (Lourinhã Municipality), South of Consolação (Peniche Municipality), and Zambujal de Baixo (Sesimbra Municipality).
Hendrickx, C., R. Araújo, and O. Mateus. "
The nonavian theropod quadrate: systematics usefulness, major trends and phylogenetic morphometrics analysis." Journal of Vertebrate Paleontology, Program and Abstracts, 2012, p.110. ISSN 1937-2809 , 2012.
Abstract
The quadrate in nonavian theropods is incredibly diverse morphologically; however this morphological disparity has been underestimated for taxonomic purposes. The quadrate topological homologies and anatomy, as well as the terminology, among nonavian theropod clades are reviewed. In order to evaluate the phylogenetic potential and investigate the evolutionary transformations of the quadrate, we conducted a Catalano-Goloboff phylogenetic morphometric analysis using 3 morphometric characters, a total of 28 landmarks coded for 23 taxa, as well as a cladistic analysis using 115 discrete quadrate-related characters coded for 43 taxa. The cladistic analysis provides a fully resolved tree mirroring the current classification of nonavian theropods. The quadrate morphology by its own provides a wealth of data with strong phylogenetic signal. Several unambiguous synapomorphies support nonavian theropod relationships and the resulting consensus tree allows inference of major trends in the evolution of this bone. Important synapomorphies include: for Abelisauridae, a lateral ramus extending to the ectocondyle; for Tetanurae, the absence of the lateral process; for Spinosauridae, a medial curvature of the ventral part of the pterygoid ramus occurring just above the mandibular articulation; for Neotetanurae, an anterior margin of the pterygoid flange formed by a roughly parabolic margin; and for Tyrannosauroidea, a semi-oval pterygoid flange shape in medial view. The Catalano-Goloboff phylogenetic morphometric analysis reveals two main morphotypes of the mandibular articulation of the quadrate linked to function. The first morphotype, characterized by an anteroposteriorly broad mandibular articulation with two ovoid/subcircular condyles roughly subequal in size, is found in Ceratosauria, Tyrannosauroidea and Oviraptorosauria. This morphotype allows a very weak displacement of the mandible laterally. The second morphotype is characterized by an elongate and anteroposteriorly narrow mandibular articulation and a long and parabolic/sigmoid ectocondyle. Present in Megalosauroidea, Allosauroidea and Dromaeosauridae, this morphotype permits the lower jaw rami to be displaced laterally when the mouth opened.
Vicente da Silva, M., and A. N. Antão. "
A novel augmented Lagrangian based formulation for upper bound limit analysis."
International Journal for Numerical Methods in Engineering. vol. 89.nº 12 (2012): pp. 1471-1496.
AbstractThis paper describes a novel upper-bound formulation of limit analysis. This formulation is an innovative variant of an existing two-field mixed formulation based on the augmented Lagrangian method also developed by the authors. A natural approach is used to describe the deformation of each finite element. Furthermore, and in contrast to the previous formulation, two independent field approximations are now both used to define the velocity field, defined globally and at element level. It is shown that this feature allows a governing system of uncoupled linear equations to be obtained. Some numerical examples in plane strain conditions are presented in order to illustrate the current model performance. In conclusion, the potential and advantages of this new approach are discussed.
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.
Zeballos, L. J., M. I. Gomes, A. P. Barbosa-Povoa, and A. Q. Novais. "
Optimum Design and Planning of Resilient and Uncertain Closed-Loop Supply Chains."
22nd European Symposium on Computer Aided Process Engineering. Eds. Ian David Lockhart Bogle, and Michael Fairweather. Vol. 30. Computer Aided Chemical Engineering, 30. London: Elsevier, 2012. 407-411.
AbstractThe design and planning of efficient supply chains (SC) is a major challenge that increases when the return of products has to be accounted for, the so-called closed-loop supply chains (CLSC). In the present work the effect of disruptions and modifications in the operating conditions of CLSCs are investigated on the basis of a 2-stage scenario based model previously developed by the authors. Metrics derived from graph theory are used, along with more conventional economic and operational indices. A discussion on the results obtained is presented to assess how the design and planning of the CLSC respond to these challenges and how these metrics may contribute to this objective.