Smelling faults in spreadsheets

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 wellknown 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

Effects of respiratory muscle training on respiratory efficiency and health-related quality of life in sedentary women with fibromyalgia: a randomised controlled trial

Objectives: Fibromyalgia syndrome (FM) is a complex disease that is mainly characterised by chronic pain, fatigue, and sleep disturbances and may be precipitated or worsened by many stressors. The aim of this study was to examine the effects of respiratory muscle training (RMT) on respiratory efficiency and health-related quality of life (HRQoL) in women with FM. Methods: A total of 30 women with FM were included in the intention to treat analyses: 15 were assigned to the RMT group and 15 to the control group. The intervention consisted of 12 weeks of RMT. The primary outcome was the change in pulmonary function assessed by global body plethysmography at 12 weeks compared with baseline. Secondary outcomes included changes of scores in HRQoL assessed by the Short Form 36 Health Survey-Portuguese version. Results: The maximal inspiratory pressure (MIP) improved by 17.5% (p-value = .033), maximal expiratory pressure (MEP) improved 21.6% (p-value = 0.045) and maximum occlusion pressure (P0.1 max) increased 27.7% (p-value = 0.007). HRQoL improved in the dimensions of physical function, physical role, bodily pain and vitality (p-value <0.05). Conclusions: RMT results in a significant improvement of respiratory efficiency and HRQoL after 12 weeks. RMT could be an effective therapy to enhance respiratory function and quality of life in women with FM

EQ-5D-Y-5L: developing a revised EQ-5D-Y with increased response categories.

Kreimeier S, Astrom M, Burstrom K, et al. EQ-5D-Y-5L: developing a revised EQ-5D-Y with increased response categories. Quality of life research : an international journal of quality of life aspects of treatment, care and rehabilitation. 2019;28(7):1951-1961.PURPOSE: EQ-5D-Y is a generic measure of health status for children and adolescents aged 8-15 years. Originally, it has three levels of severity in each dimension (3L). This study aimed to develop a descriptive system of EQ-5D-Y with an increased number of severity levels and to test comprehensibility and feasibility. METHODS: The study was conducted in Germany, Spain, Sweden and the UK. In Phase 1, a review of existing instruments and focus group interviews were carried out to create a pool of possible labels for a modified severity classification. Participants aged 8-15 rated the severity of the identified labels in individual sorting and response scaling interviews. In Phase 2, preliminary 4L and 5L versions were constructed for further testing in cognitive interviews with healthy participants aged 8-15 years and children receiving treatment for a health condition. RESULTS: In Phase 1, a total of 233 labels was generated, ranging from 37 (UK) to 79 labels (Germany). Out of these, 7 to 16 possible labels for each dimension in the different languages were rated in 255 sorting and response scaling interviews. Labels covered an appropriate range of severity on the health continuum in all countries. In Phase 2, the 5L version was generally preferred (by 68-88% of the participants per country) over the 4L version. CONCLUSIONS: This multinational study has provided a version of the EQ-5D-Y with 5 severity levels in each dimension. This extended version (EQ-5D-Y-5L) requires testing its psychometric properties and its performance compared to that of the original EQ-5D-Y-3L

Assessing, quantifying and valuing the ecosystem services of coastal lagoons

The natural conservation of coastal lagoons is important not only for their ecological importance, but also because of the valuable ecosystem services they provide for human welfare and wellbeing. Coastal lagoons are shallow semi-enclosed systems that support important habitats such as wetlands, mangroves, salt-marshes and seagrass meadows, as well as a rich biodiversity. Coastal lagoons are also complex social-ecological systems with ecosystem services that provide livelihoods, wellbeing and welfare to humans. This study assessed, quantified and valued the ecosystem services of 32 coastal lagoons. The main findings of the study are: (i) the definitions of ecosystem services are still not generally accepted; (ii) the quantification of ecosystem services is made in many different ways, using different units; (iii) the evaluation in monetary terms of some ecosystem service is problematic, often relying on non-monetary evaluation methods; (iv) when ecosystem services are valued in monetary terms, this may represent very different human benefits; and, (v) different aspects of climate change, including increasing temperature, sea-level rise and changes in rainfall patterns threaten the valuable ecosystem services of coastal lagoons.DEVOTES project, from the European Union's Seventh Framework Programme for research, technological development and demonstration [308392]; networks and communities of Eurolag; Future Earth Coasts; SCOR; Fundacao para a Ciencia e a Tecnologia (FCT) Investigador Programme [IF/00331/2013]; Fundacao para a Ciencia e a Tecnologia [UID/MAR/04292/2013]; CESAM by FCT/MEC national funds (PIDDAC) [UID/AMB/50017/2013 - POCI-01-0145-FEDER-007638]; FEDER; European Commission, under the 7th Framework Programme through the collaborative research project LAGOONS [283157]; FCT [SFRH/BPD/107823/2015, SFRH/BPD/91494/2012

Viral genetic clustering and transmission dynamics of the 2022 mpox outbreak in Portugal

Pathogen genome sequencing during epidemics enhances our ability to identify and understand suspected clusters and investigate their relationships. Here, we combine genomic and epidemiological data of the 2022 mpox outbreak to better understand early viral spread, diversification and transmission dynamics. By sequencing 52% of the confirmed cases in Portugal, we identified the mpox virus sublineages with the highest impact on case numbers and fitted them into a global context, finding evidence that several international sublineages probably emerged or spread early in Portugal. We estimated a 62% infection reporting rate and that 1.3% of the population of men who have sex with men in Portugal were infected. We infer the critical role played by sexual networks and superspreader gatherings, such as sauna attendance, in the dissemination of mpox virus. Overall, our findings highlight genomic epidemiology as a tool for the real-time monitoring and control of mpox epidemics, and can guide future vaccine policy in a highly susceptible population.info:eu-repo/semantics/publishedVersio

Impact of the first wave of the SARS-CoV-2 pandemic on the outcome of neurosurgical patients: A nationwide study in Spain

Objective To assess the effect of the first wave of the SARS-CoV-2 pandemic on the outcome of neurosurgical patients in Spain. Settings The initial flood of COVID-19 patients overwhelmed an unprepared healthcare system. Different measures were taken to deal with this overburden. The effect of these measures on neurosurgical patients, as well as the effect of COVID-19 itself, has not been thoroughly studied. Participants This was a multicentre, nationwide, observational retrospective study of patients who underwent any neurosurgical operation from March to July 2020. Interventions An exploratory factorial analysis was performed to select the most relevant variables of the sample. Primary and secondary outcome measures Univariate and multivariate analyses were performed to identify independent predictors of mortality and postoperative SARS-CoV-2 infection. Results Sixteen hospitals registered 1677 operated patients. The overall mortality was 6.4%, and 2.9% (44 patients) suffered a perioperative SARS-CoV-2 infection. Of those infections, 24 were diagnosed postoperatively. Age (OR 1.05), perioperative SARS-CoV-2 infection (OR 4.7), community COVID-19 incidence (cases/10 5 people/week) (OR 1.006), postoperative neurological worsening (OR 5.9), postoperative need for airway support (OR 5.38), ASA grade =3 (OR 2.5) and preoperative GCS 3-8 (OR 2.82) were independently associated with mortality. For SARS-CoV-2 postoperative infection, screening swab test <72 hours preoperatively (OR 0.76), community COVID-19 incidence (cases/10 5 people/week) (OR 1.011), preoperative cognitive impairment (OR 2.784), postoperative sepsis (OR 3.807) and an absence of postoperative complications (OR 0.188) were independently associated. Conclusions Perioperative SARS-CoV-2 infection in neurosurgical patients was associated with an increase in mortality by almost fivefold. Community COVID-19 incidence (cases/10 5 people/week) was a statistically independent predictor of mortality. Trial registration number CEIM 20/217

Standardization of in vitro digestibility and DIAAS method based on the static INFOGEST protocol

Background: The FAO recommends the digestible indispensable amino acid score (DIAAS) as the measure for protein quality, for which the true ileal digestibility needs to be assessed in humans or pigs. However, due to high costs and ethical concerns, the FAO strongly encourages as well the development of validated in vitro methods, which complement the in vivo experiments. Method: Recently, an in vitro workflow, based on the validated static INFOGEST protocol, was developed and compared towards in vivo data. In parallel to the validation with in vivo data, the repeatability and reproducibility of the in vitro protocol were tested in an international ring trial (RT) with the aim to establish an international ISO standard method within the International Dairy Federation (IDF). Five different dairy products (skim milk powder, whole milk powder, whey protein isolate, yoghurt, and cheese) were analyzed in 32 different laboratories from 18 different countries, across 4 continents. Results: in vitro protein digestibilities based on Nitrogen, free R-NH2, and total amino acids as well as DIAAS values were calculated and compared to in vivo data, where available. Conclusion: The in vitro method is suited for quantification of digestibility and will be further implemented to other food matricesinfo:eu-repo/semantics/publishedVersio

Additive effects of LPL, APOA5 and APOE variant combinations on triglyceride levels and hypertriglyceridemia: results of the ICARIA genetic sub-study

<p>Abstract</p> <p>Background</p> <p>Hypertriglyceridemia (HTG) is a well-established independent risk factor for cardiovascular disease and the influence of several genetic variants in genes related with triglyceride (TG) metabolism has been described, including <it>LPL</it>, <it>APOA5 </it>and <it>APOE</it>. The combined analysis of these polymorphisms could produce clinically meaningful complementary information.</p> <p>Methods</p> <p>A subgroup of the ICARIA study comprising 1825 Spanish subjects (80% men, mean age 36 years) was genotyped for the <it>LPL</it>-HindIII (rs320), S447X (rs328), D9N (rs1801177) and N291S (rs268) polymorphisms, the <it>APOA5</it>-S19W (rs3135506) and -1131T/C (rs662799) variants, and the <it>APOE </it>polymorphism (rs429358; rs7412) using PCR and restriction analysis and TaqMan assays. We used regression analyses to examine their combined effects on TG levels (with the log-transformed variable) and the association of variant combinations with TG levels and hypertriglyceridemia (TG ≥ 1.69 mmol/L), including the covariates: gender, age, waist circumference, blood glucose, blood pressure, smoking and alcohol consumption.</p> <p>Results</p> <p>We found a significant lowering effect of the <it>LPL</it>-HindIII and S447X polymorphisms (<it>p </it>< 0.0001). In addition, the D9N, N291S, S19W and -1131T/C variants and the <it>APOE</it>-ε4 allele were significantly associated with an independent additive TG-raising effect (<it>p </it>< 0.05, <it>p </it>< 0.01, <it>p </it>< 0.001, <it>p </it>< 0.0001 and <it>p </it>< 0.001, respectively). Grouping individuals according to the presence of TG-lowering or TG-raising polymorphisms showed significant differences in TG levels (<it>p </it>< 0.0001), with the lowest levels exhibited by carriers of two lowering variants (10.2% reduction in TG geometric mean with respect to individuals who were homozygous for the frequent alleles of all the variants), and the highest levels in carriers of raising combinations (25.1% mean TG increase). Thus, carrying two lowering variants was protective against HTG (OR = 0.62; 95% CI, 0.39-0.98; <it>p </it>= 0.042) and having one single raising polymorphism (OR = 1.20; 95% CI, 1.39-2.87; <it>p </it>< 0.001) or more (2 or 3 raising variants; OR = 2.90; 95% CI, 1.56-5.41; <it>p </it>< 0.001) were associated with HTG.</p> <p>Conclusion</p> <p>Our results showed a significant independent additive effect on TG levels of the <it>LPL </it>polymorphisms HindIII, S447X, D9N and N291S; the S19W and -1131T/C variants of <it>APOA5</it>, and the ε4 allele of <it>APOE </it>in our study population. Moreover, some of the variant combinations studied were significantly associated with the absence or the presence of hypertriglyceridemia.</p

Unusual circulation patterns of the rias baixas induced by minho freshwater intrusion (NW of the Iberian Peninsula)

The Minho River, situated 30 km south of the Rias Baixas, is the most important freshwater source flowing into the Western Galician coast (NW of the Iberian Peninsula). The buoyancy generated by the Minho estuarine plume can reverse the normal circulation pattern inside the Rias Baixas affecting the exchange between the Rias and the ocean, changing the input of nutrients. Nevertheless, this inversion of the circulation patterns is not a well-monitored phenomenon. The only published results based on in situ data related to the presence of the Minho River plume inside the Rias de Vigo and Pontevedra correspond to an event measured on spring 1998. In this case unexpectedly higher inflow surface current velocities were found at the Ria de Pontevedra, located further away from Minho River. Thus, the main aim of this study is to research the main factors inducing this unusual pattern on the circulation of the Rias de Vigo and Pontevedra. A numerical model implementation of MOHID previously developed, calibrated, and validated for this coastal area was used. Several scenarios were performed in order to explain the individual effect of the Minho River, rivers discharging into each Rias, and estuarine morphology changes. According to the model results, the Minho River discharge is a key factor in the establishment of the negative circulation, while small rivers inside the Rias slightly attenuate this circulation. The negative circulation was stronger in Ria de Pontevedra independently of the distance of this coastal system from the Minho River mouth, showing that morphologic estuarine features are the main factor justifying the different local circulation patterns