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

From Social Data Mining to Forecasting Socio-Economic Crisis

Socio-economic data mining has a great potential in terms of gaining a better understanding of problems that our economy and society are facing, such as financial instability, shortages of resources, or conflicts. Without large-scale data mining, progress in these areas seems hard or impossible. Therefore, a suitable, distributed data mining infrastructure and research centers should be built in Europe. It also appears appropriate to build a network of Crisis Observatories. They can be imagined as laboratories devoted to the gathering and processing of enormous volumes of data on both natural systems such as the Earth and its ecosystem, as well as on human techno-socio-economic systems, so as to gain early warnings of impending events. Reality mining provides the chance to adapt more quickly and more accurately to changing situations. Further opportunities arise by individually customized services, which however should be provided in a privacy-respecting way. This requires the development of novel ICT (such as a self- organizing Web), but most likely new legal regulations and suitable institutions as well. As long as such regulations are lacking on a world-wide scale, it is in the public interest that scientists explore what can be done with the huge data available. Big data do have the potential to change or even threaten democratic societies. The same applies to sudden and large-scale failures of ICT systems. Therefore, dealing with data must be done with a large degree of responsibility and care. Self-interests of individuals, companies or institutions have limits, where the public interest is affected, and public interest is not a sufficient justification to violate human rights of individuals. Privacy is a high good, as confidentiality is, and damaging it would have serious side effects for society.Comment: 65 pages, 1 figure, Visioneer White Paper, see http://www.visioneer.ethz.c

Global differences in the management of Staphylococcus aureus bacteremia: no international standard of care

BackgroundDespite being the leading cause of mortality from bloodstream infections worldwide, little is known about regional variation in treatment practices for Staphylococcus aureus bacteremia (SAB). The aim of this study was to identify global variation in management, diagnostics, and definitions of SAB.MethodsDuring a 20-day period in 2022, physicians throughout the world were surveyed on SAB treatment practices. The survey was distributed through listservs, e-mails, and social media.ResultsIn total, 2031 physicians from 71 different countries on 6 continents (North America [701, 35%], Europe [573, 28%], Asia [409, 20%], Oceania [182, 9%], South America [124, 6%], and Africa [42, 2%]) completed the survey. Management-based responses differed significantly by continent for preferred treatment of methicillin-susceptible S. aureus (MSSA) and methicillin-resistant S. aureus (MRSA) bacteremia, use of adjunctive rifampin for prosthetic material infection, and use of oral antibiotics (P P –4 days of positive blood cultures, responses ranged from 2 days in 31% of European respondents to 7 days in 38% of Asian respondents (P ConclusionsLarge practice variations for SAB exist throughout the world, reflecting the paucity of high-quality data and the absence of an international standard of care for the management of SAB.Immunogenetics and cellular immunology of bacterial infectious disease

The association of female sex with management and mortality in patients with Staphylococcus aureus bacteraemia

Objectives: The association of biological female sex with outcome in patients with Staphylococcus aureus bacteraemia remains unresolved. The aim of this study was to determine the independent association of female sex with management and mortality in patients with S. aureus bacteraemia.Methods: This is a post hoc analysis of prospectively collected data from the S. aureus Bacteraemia Group Prospective Cohort Study. Adult patients with monomicrobial S. aureus bacteraemia at Duke University Medical Center were enrolled from 1994 to 2020. Univariable and multivariable Cox regression analyses were performed to assess differences in management and mortality between females and males.Results: Among 3384 patients with S. aureus bacteraemia, 1431 (42%) were women. Women were, as compared with men, more often Black (581/1431 [41%] vs. 620/1953 [32%], p < 0.001), haemodialysis dependent (309/1424 [22%] vs. 334/1940 [17%], p 0.001) and more likely to be infected with methicillinresistant S. aureus (MRSA) (697/1410 [49%] MRSA in women vs. 840/1925 [44%] MRSA in men, p 0.001). Women received shorter durations of antimicrobial treatment (median 24 [interquartile range 14-42] vs. 28 [interquartile range 14-45] days, p 0.005), and were less likely to undergo transesophageal echocardiography as compared with men (495/1430 [35%] vs. 802/1952 [41%], p < 0.001). Despite these differences, female sex was not associated with 90-day mortality in either univariable (388/1431 [27%] in women vs. 491/1953 [25%] in men, p 0.204) or multivariable analysis (adjusted hazard ratio for women 0.98 [95% CI, 0.85-1.13]).Discussion: Despite significant differences in patient characteristics, disease characteristics, and management, women and men with S. aureus bacteraemia have a similar mortality risk. Annette C. Westgeest, Clin Microbiol Infect 2023;29:1182Immunogenetics and cellular immunology of bacterial infectious disease

Whole-genome sequencing reveals host factors underlying critical COVID-19

Critical COVID-19 is caused by immune-mediated inflammatory lung injury. Host genetic variation influences the development of illness requiring critical care1 or hospitalization2,3,4 after infection with SARS-CoV-2. The GenOMICC (Genetics of Mortality in Critical Care) study enables the comparison of genomes from individuals who are critically ill with those of population controls to find underlying disease mechanisms. Here we use whole-genome sequencing in 7,491 critically ill individuals compared with 48,400 controls to discover and replicate 23 independent variants that significantly predispose to critical COVID-19. We identify 16 new independent associations, including variants within genes that are involved in interferon signalling (IL10RB and PLSCR1), leucocyte differentiation (BCL11A) and blood-type antigen secretor status (FUT2). Using transcriptome-wide association and colocalization to infer the effect of gene expression on disease severity, we find evidence that implicates multiple genes—including reduced expression of a membrane flippase (ATP11A), and increased expression of a mucin (MUC1)—in critical disease. Mendelian randomization provides evidence in support of causal roles for myeloid cell adhesion molecules (SELE, ICAM5 and CD209) and the coagulation factor F8, all of which are potentially druggable targets. Our results are broadly consistent with a multi-component model of COVID-19 pathophysiology, in which at least two distinct mechanisms can predispose to life-threatening disease: failure to control viral replication; or an enhanced tendency towards pulmonary inflammation and intravascular coagulation. We show that comparison between cases of critical illness and population controls is highly efficient for the detection of therapeutically relevant mechanisms of disease

Reducing the environmental impact of surgery on a global scale: systematic review and co-prioritization with healthcare workers in 132 countries

Background Healthcare cannot achieve net-zero carbon without addressing operating theatres. The aim of this study was to prioritize feasible interventions to reduce the environmental impact of operating theatres. Methods This study adopted a four-phase Delphi consensus co-prioritization methodology. In phase 1, a systematic review of published interventions and global consultation of perioperative healthcare professionals were used to longlist interventions. In phase 2, iterative thematic analysis consolidated comparable interventions into a shortlist. In phase 3, the shortlist was co-prioritized based on patient and clinician views on acceptability, feasibility, and safety. In phase 4, ranked lists of interventions were presented by their relevance to high-income countries and low–middle-income countries. Results In phase 1, 43 interventions were identified, which had low uptake in practice according to 3042 professionals globally. In phase 2, a shortlist of 15 intervention domains was generated. In phase 3, interventions were deemed acceptable for more than 90 per cent of patients except for reducing general anaesthesia (84 per cent) and re-sterilization of ‘single-use’ consumables (86 per cent). In phase 4, the top three shortlisted interventions for high-income countries were: introducing recycling; reducing use of anaesthetic gases; and appropriate clinical waste processing. In phase 4, the top three shortlisted interventions for low–middle-income countries were: introducing reusable surgical devices; reducing use of consumables; and reducing the use of general anaesthesia. Conclusion This is a step toward environmentally sustainable operating environments with actionable interventions applicable to both high– and low–middle–income countries

Revisão do gênero Potnia Stål (Homoptera, Membracidae, Membracinae, Hoplophorionini) Revision of the genus Potnia Stål (Homoptera, Membracidae, Membracinae, Hoplophorionini)

<abstract language="eng">Fifteen species of Potnia Stål, 1866 are presented with descriptions, illustrations and a key for identification. The following nomenclatural changes are introduced: P. knightae sp.n. (from Guiana), P. miracyae sp.n. (from Costa Rica), P. diringshofeni sp.n. (from Brasil), P. webbi sp.n. (from Brazil), P. turrialbensis sp.n. (from Costa Rica), P. pinheiroi sp.n. (from Brazil), P. tapuruquarensis sp.n. (from Brasil), P. cornigera sp.n. (from Brazil) and P. inca sp.n. (from Peru). Potnia venosa (Germar, 1821) = Aconophora nigrivittata Walker, 1851, syn.n. = Potnia perobtusa Fowler, 1894, syn.n.. Potnia brevicornis Fowler, 1894, sp. reval. = Potnia brunneifrontis Funkhouser, 1943, syn.n. = Potnia maculata Funkhouser, 1943, syn.n.. Potnia jacula (Fabricius, 1803) = Potnia orthosoma Fonseca & Diringshofen, 1974, syn.n