End-users productivity in model-based spreadsheets: an empirical study

Lecture Notes in Computer Science Volume 6654, 2011Spreadsheets are widely used and studies show that most of the existing ones contain non-trivial errors. To improve end-users productivity, recent research proposes the use of a model-driven engineering approach to spreadsheets. In this paper we conduct the first empirical study to assess the effectiveness and efficiency of this approach. A set of spreadsheet end users worked with two different model-based spreadsheets. We present and analyze here the results achieved.(undefined

Towards a catalog of spreadsheet smells

Spreadsheets are considered to be the most widely used programming language in the world, and reports have shown that 90% of real-world spreadsheets contain errors. In this work, we try to identify spreadsheet smells, a concept adapted from software, which consists of a surface indication that usually corresponds to a deeper problem. Our smells have been integrated in a tool, and were computed for a large spreadsheet repository. Finally, the analysis of the results we obtained led to the refinement of our initial catalog

Efficacy and safety of cumaru syrup as complementary therapy in mild persistent asthma: a double-blind, randomized, placebo-controlled study

Amburana cearensis is a medicinal plant known as "cumaru". It is used in Northeast Brazil in the treatment of respiratory diseases. This was a randomized, double-blind, placebo-controlled study, with the aim of evaluating the efficacy and safety of cumaru syrup as complementary therapy in mild persistent asthma. The study consisted of 3 phases, pre-treatment, treatment and post-treatment. The primary efficacy outcome was comparison of the changes reported by patients of the cumaru and placebo groups after treatment, using the "Asthma Quality of Life Questionnaire" (AQLQ). The secondary outcome was the effect of cumaru syrup on lung function based on spirometry. The results showed that in the cumaru group, the proportion of patients who had global improvement in asthma symptoms was significantly greater (61.90%, P=0.0009) than in the placebo group (9.52%). Only the spirometric parameters Forced Vital Capacity (FVC) and Forced Expiratory Volume in 1 second (FEV1) showed significant intergroup differences in post-treatment (P0.05). Adverse events were reported by 3 patients (14.29%) in the cumaru group and 3 patients (14.29%) in the placebo group. All adverse events were considered non-serious and mild.Amburana cearensis é uma planta medicinal conhecida como "cumaru". No Nordeste do Brasil é usada no tratamento de doenças respiratórias. Este é um estudo randomizado, duplo-cego e controlado por placebo, com o objetivo de avaliar a eficácia e segurança do xarope de cumaru como terapia complementar da asma persistente leve. O estudo consistiu de três fases, pré-tratamento, tratamento e pós-tratamento. A variável primária para determinação da eficácia foi a comparação das mudanças referidas pelos pacientes dos grupos cumaru e placebo após o tratamento, usando o "Questionário sobre Qualidade de Vida na Asma" (QQVA). A variável secundária foi o efeito do xarope de cumaru na função pulmonar baseado na espirometria. Os resultados mostraram que no grupo cumaru, a proporção de pacientes com melhora global dos sintomas da asma foi significativamente maior (61,90%, P=0.0009) que no grupo placebo (9,52%). Somente os parâmetros espirométricos, capacidade vital forçada (CVF) e volume expiratório forçado no primeiro segundo (VEF1), mostraram diferença intergrupo significtivas no pós-tratamento (P0.05). Eventos adversos foram reportados por 3 pacientes (14,29%) no grupo cumaru e 3 (14,29%) no grupo placebo. Todos os eventos adversos foram não sérios e leves

Fitting the integrated Spectral Energy Distributions of Galaxies

Fitting the spectral energy distributions (SEDs) of galaxies is an almost universally used technique that has matured significantly in the last decade. Model predictions and fitting procedures have improved significantly over this time, attempting to keep up with the vastly increased volume and quality of available data. We review here the field of SED fitting, describing the modelling of ultraviolet to infrared galaxy SEDs, the creation of multiwavelength data sets, and the methods used to fit model SEDs to observed galaxy data sets. We touch upon the achievements and challenges in the major ingredients of SED fitting, with a special emphasis on describing the interplay between the quality of the available data, the quality of the available models, and the best fitting technique to use in order to obtain a realistic measurement as well as realistic uncertainties. We conclude that SED fitting can be used effectively to derive a range of physical properties of galaxies, such as redshift, stellar masses, star formation rates, dust masses, and metallicities, with care taken not to over-interpret the available data. Yet there still exist many issues such as estimating the age of the oldest stars in a galaxy, finer details ofdust properties and dust-star geometry, and the influences of poorly understood, luminous stellar types and phases. The challenge for the coming years will be to improve both the models and the observational data sets to resolve these uncertainties. The present review will be made available on an interactive, moderated web page (sedfitting.org), where the community can access and change the text. The intention is to expand the text and keep it up to date over the coming years.Comment: 54 pages, 26 figures, Accepted for publication in Astrophysics & Space Scienc

The ALMA Spectroscopic Survey in the Hubble Ultra Deep Field: Molecular Gas Reservoirs in High-redshift Galaxies

We study the molecular gas properties of high-z galaxies observed in the ALMA Spectroscopic Survey (ASPECS) that targets an ˜1 arcmin2 region in the Hubble Ultra Deep Field (UDF), a blind survey of CO emission (tracing molecular gas) in the 3 and 1 mm bands. Of a total of 1302 galaxies in the field, 56 have spectroscopic redshifts and correspondingly well-defined physical properties. Among these, 11 have infrared luminosities {L}{IR}\gt {10}11 {L}⊙ , i.e., a detection in CO emission was expected. Out of these, 7 are detected at various significance in CO, and 4 are undetected in CO emission. In the CO-detected sources, we find CO excitation conditions that are lower than those typically found in starburst/sub-mm galaxy/QSO environments. We use the CO luminosities (including limits for non-detections) to derive molecular gas masses. We discuss our findings in the context of previous molecular gas observations at high redshift (star formation law, gas depletion times, gas fractions): the CO-detected galaxies in the UDF tend to reside on the low-{L}{IR} envelope of the scatter in the {L}{IR}{--}{L}{CO}\prime relation, but exceptions exist. For the CO-detected sources, we find an average depletion time of ˜1 Gyr, with significant scatter. The average molecular-to-stellar mass ratio ({M}{{H}2}/M *) is consistent with earlier measurements of main-sequence galaxies at these redshifts, and again shows large variations among sources. In some cases, we also measure dust continuum emission. On average, the dust-based estimates of the molecular gas are a factor ˜2-5× smaller than those based on CO. When we account for detections as well as non-detections, we find large diversity in the molecular gas properties of the high-redshift galaxies covered by ASPECS

Vegetative development, fruits yield and optimization of pineapple cv. Pérola with different levels of irrigation

Apesar de ser uma planta com necessidades hídricas relativamente baixas, o abacaxizeiro tem demanda permanente de água, variável ao longo do ciclo e dependente do seu estádio de desenvolvimento. Assim, objetivou-se analisar volumes de irrigação no desenvolvimento vegetativo, no rendimento da fruta e na otimização do abacaxizeiro cv. Pérola. O experimento foi realizado na Universidade Federal de Sergipe, município de São Cristóvão (11°01'S, 37°12'W), no delineamento em blocos ao acaso, com quatro tratamentos (lâminas de água) (100% da evaporação do tanque Classe A (523,7mm ano-1); 75% da evaporação do tanque Classe A (392,8mm ano-1), 50% da evaporação do tanque Classe A (261,8mm ano-1) e 0% da evaporação do tanque Classe A, seis repetições e 12 plantas úteis por parcela. O sistema de irrigação foi por aspersão convencional disposto em linha, com pressão de 20mca e vazão de 1,33m3 h-1. A área foliar (cm2) mínima atingida de 4552,6cm2 foi observada no volume de água de 122,9mm ano-1, enquanto a massa seca das folhas (147,6g) foi constatada com 17mm ano-1. O máximo comprimento da folha D (88,9cm) foi estimado com 532,7 mm ano-1. Já o máximo comprimento do fruto (23cm) foi observado na lâmina de 296,9mm ano-1. A massa do fruto máxima estimado de 1.736g foi constatado na lâmina de 356,4mm ano-1. No contexto, a irrigação contribui de forma positiva no desenvolvimento vegetativo e rendimento da fruta do abacaxizeiro. Ressalta-se remuneração mensal líquida de R 1.161,17ha-1, quando se adota lâmina de irrigação de 356,4mm ano-1. _________________________________________________________________________________________ ABSTRACT: Regardless a relatively low water needs, pineapple fruit has a variable behavior related to water need throughout its biological cycle depending on the development stage. The objective of this work was to analyze irrigation on the vegetative development and fruits yield in pineapple cv. Pérola. The experiment was conducted at the Universidade Federal de Sergipe Experimental Station, at São Cristóvão - SE (11°01'S, 37°12'W), in a randomized block design, with four water level treatments as follow: 100% of Class-A (523.7mm ano-1) evaporation pan; 75% of Class-A (392.8mm ano-1) evaporation pan, 50% of Class-A (261.8mm ano-1) evaporation pan and 0% of Class-A evaporation pan, in six replications and twelve plants per plot. The splinkler watering system of irrigation was installed in a line, with an operating pression of 20 mca and a sprinkler dischrage of 1.33m3h-1. A minimum leaf area of 4552.6cm2 was observed, considering a water level of 122.9mm year-1, while a leaf dry matter was 147.6 g in 17mmyear-1. The maximum leaf length (D) of 88.9cm was estimated considering 532.7mmyear-1. The maximum fruit length of 23cm was observed, considering a water level of 296.9mmyear-1. The maximum estimated fruit weight was 1.736g in a water level of 356.4mm year-1. The irrigation seems to contribute in a positive way to the vegetative development in the pineapple fruit yield. It is important to mention that it could be observed a net profit of R 1,161.17 ha-1, when a water level of 356.4mm ano-1 of irrigation was adopted