Towards Evaluating the Quality of a Spreadsheet: The Case of the Analytical Spreadsheet Model

We consider the challenge of creating guidelines to evaluate the quality of a spreadsheet model. We suggest four principles. First, state the domain-the spreadsheets to which the guidelines apply. Second, distinguish between the process by which a spreadsheet is constructed from the resulting spreadsheet artifact. Third, guidelines should be written in terms of the artifact, independent of the process. Fourth, the meaning of "quality" must be defined. We illustrate these principles with an example. We define the domain of "analytical spreadsheet models", which are used in business, finance, engineering, and science. We propose for discussion a framework and terminology for evaluating the quality of analytical spreadsheet models. This framework categorizes and generalizes the findings of previous work on the more narrow domain of financial spreadsheet models. We suggest that the ultimate goal is a set of guidelines for an evaluator, and a checklist for a developer.Comment: Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2011 ISBN 978-0-9566256-9-

Online Selection of CMA-ES Variants

In the field of evolutionary computation, one of the most challenging topics is algorithm selection. Knowing which heuristics to use for which optimization problem is key to obtaining high-quality solutions. We aim to extend this research topic by taking a first step towards a selection method for adaptive CMA-ES algorithms. We build upon the theoretical work done by van Rijn \textit{et al.} [PPSN'18], in which the potential of switching between different CMA-ES variants was quantified in the context of a modular CMA-ES framework. We demonstrate in this work that their proposed approach is not very reliable, in that implementing the suggested adaptive configurations does not yield the predicted performance gains. We propose a revised approach, which results in a more robust fit between predicted and actual performance. The adaptive CMA-ES approach obtains performance gains on 18 out of 24 tested functions of the BBOB benchmark, with stable advantages of up to 23\%. An analysis of module activation indicates which modules are most crucial for the different phases of optimizing each of the 24 benchmark problems. The module activation also suggests that additional gains are possible when including the (B)IPOP modules, which we have excluded for this present work.Comment: To appear at Genetic and Evolutionary Computation Conference (GECCO'19) Appendix will be added in due tim

A stochastic model for wound healing

We present a discrete stochastic model which represents many of the salient features of the biological process of wound healing. The model describes fronts of cells invading a wound. We have numerical results in one and two dimensions. In one dimension we can give analytic results for the front speed as a power series expansion in a parameter, p, that gives the relative size of proliferation and diffusion processes for the invading cells. In two dimensions the model becomes the Eden model for p near 1. In both one and two dimensions for small p, front propagation for this model should approach that of the Fisher-Kolmogorov equation. However, as in other cases, this discrete model approaches Fisher-Kolmogorov behavior slowly.Comment: 16 pages, 7 figure

Localized ultraviolet laser microbeam irradiation of early Drosophila embryos: Fate maps based on location and frequency of adult defects

Drosophila embryos were locally irradiated with a 257-nm laser microbeam during blastoderm and germ band stages. Depending on stage and beam diameter (10–30 μm), from 0 to 45 nuclei were exposed to the uv radiation. The doses used, 5 or 10 erg, did not eliminate nuclei or cells at once, but up to 50% of the adult survivors from irradiated eggs carried defects in the thorax. These were scored with reference to the imaginal discs from which the affected structures derive. For each thoracic disc a “target center” was calculated as the weighted mean value of all beam locations affecting the respective adult derivatives. The target centers for the germ band stage map within the respective germ band segments. The pattern of target centers for the blastoderm stage is comparable to the thoracic region of published fate maps, and the distances between adjacent leg centers (approximately three cell diameters) agree with recent evidence based on mosaic flies. We discuss the question whether the target centers mark the position of the respective disc progenitor cells at the stages of irradiation and conclude that these positions are rendered rather correctly at least with reference to the longitudinal egg axis

Application of processed organic municipal solid waste on agricultural land - a scenario analysis

Source separation, composting and anaerobic digestion, with associated land application, are increasingly being considered as alternative waste management strategies to landfilling and incineration of municipal solid waste (MSW). Environmental life cycle assessments are a useful tool in political decision-making about waste management strategies. However, due to the diversity of processed organic MSW and the situations in which it can be applied, the environmental impacts of land application are very hard to determine by experimental means. In the current study, we used the agroecosystem model Daisy to simulate a range of different scenarios representing different geographical areas, farm and soil types under Danish conditions and legislation. Generally, the application of processed organic MSW resulted in increased emissions compared with the corresponding standard scenarios, but with large differences between scenarios. Emission coefficients for nitrogen leaching to the groundwater ranged from 0.03 to 0.87, while those for nitrogen lost to surface waters through tile drains ranged from 0 to 0.30. Emission coefficients for N2O formation ranged from 0.013 to 0.022 and for ammonia volatilization from 0.016 to 0.11. These estimates are within reasonable range of observed values under similar conditions. Furthermore, a sensitivity analysis showed that the estimates were not very sensitive to the mineralization dynamics of the processed organic MSW. The results show that agroecosystem models can be powerful tools to estimate the environmental impacts of land application of processed MSW under different conditions. Despite this, agroecosystem models have only been used to a very limited degree for this purpose

Still Bowling Alone? The Post-9/11 Split

The crisis of the 9/11 terrorist attacks has sparked a surge of increased civic engagement by young people in the United States, but there is also evidence of a growing divide along class lines

Trip distribution for limited destinations: a case study for grocery shopping trips in the Netherlands

In this paper, we introduce a new trip distribution model for destinations that are not homogeneously distributed. The model is a gravity model in which the spatial configuration of destinations is incorporated in the modeling process. The performance was tested on a survey with reported grocery shopping trips in the Dutch city of Almelo. The results show that the new model outperforms the traditional gravity model. It is also superior to the intervening opportunities model, because the distribution can be described as a function of travel costs, without increasing the computational time. In this study, the distribution was described by a simple function of Euclidean distance, which provides a good fit to the survey data. The slope of the distribution is quite steep. This shows that most trips are made to nearby supermarkets. However, a significant fraction of trips, mainly made by car, still goes to supermarkets further away. We argue that modeling of these trips by the new method will improve traffic flow predictions