On an Application of Microsoft Excel’s Evolutionary Solver to the Resource-Constrained Project Scheduling Problem RCPSP

The Solver Add-in of Microsoft Excel is widely used in courses on Operations Research and in industrial applications. Since the 2010 version of Microsoft Excel, the Solver Add-in comprises a so-called evolutionary solver. We analyze how this metaheuristic can be applied to the resource-constrained project scheduling problem (RCPSP). We present an implementation of a schedule-generation scheme in a spreadsheet, which combined with the evolutionary solver can be used for devising good feasible schedules. Our computational results indicate that using this approach, non-trivial instances of the RCPSP can be (approximately) solved to optimality.

Mast fruiting of large ectomycorrhizal African rain forest trees: importance of dry season intensity, and the resource limitation hypothesis

Mast fruiting is a distinctive reproductive trait in trees. This rain forest study, at a nutrient-poor site with a seasonal climate in tropical Africa, provides new insights into the causes of this mode of phenological patterning. •  At Korup, Cameroon, 150 trees of the large, ectomycorrhizal caesalp, Microberlinia bisulcata, were recorded almost monthly for leafing, flowering and fruiting during 1995–2000. The series was extended to 1988–2004 with less detailed data. Individual transitions in phenology were analysed. •  Masting occurred when the dry season before fruiting was drier, and the one before that was wetter, than average. Intervals between events were usually 2 or 3 yr. Masting was associated with early leaf exchange, followed by mass flowering, and was highly synchronous in the population. Trees at higher elevation showed more fruiting. Output declined between 1995 and 2000. •  Mast fruiting in M. bisulcata appears to be driven by climate variation and is regulated by internal tree processes. The resource-limitation hypothesis was supported. An ‘alternative bearing’ system seems to underlie masting. That ectomycorrhizal habit facilitates masting in trees is strongly implied.

Does ‘better’ discounting lead to ‘worse’ outcomes in long-run decisions? The dilemma of hyperbolic discounting

The shortcomings of conventional discounting, especially in the context of long-run environmental problems, have been extensively discussed in the literature. Recently, hyperbolic discounting, i. e. discounting at declining instead of constant discount rates, has attracted a lot of interest among both scientists and politicians. Although there are compelling arguments for employing hyperbolic discounting, there are also pitfalls, which have to be pointed out. In this paper I show that the problem of time-inconsistency, an inherent characteristics of hyperbolic discounting, leads to a potential clash between economic efficiency and intergenerational equity. As an example, I refer to the weak progress in the controlling of greenhouse gas emissions under the Kyoto protocol. As the problem of time-inconsistency cannot be solved on economic grounds alone, there is a need for an intergenerational moral commitment.

Gender differences at the transition to higher education between migrants and non-migrants: A comparison between Switzerland and France

Within Western societies women or girls meanwhile outperform men or boys with regard to attainments in primary and secondary education. For example concerning upper secondary degrees the share of females attaining the Matura approaches two thirds in Switzerland, while the share of females attaining the Baccalaureate exceeds fifty per cent in France. However, if transitions to higher education are regarded, the share of entitled females entering such institutions is significantly lower than among men in Switzerland. An opposite pattern is observed in France where females outperform men at this educational stage, too. With regard to migrant background, it has been shown by previous research focussing on secondary effects of ethnic origin that such youths enter the more demanding educational tracks (e.g. higher education) more often than their non-migrant peers if controlled for eligibility, their lower socioeconomic status and performances. However, so far only a few studies refer to the question of a possible gender gap regarding secondary effects of ethnic origin (e.g. Fleischmann et al., mimeo). Thus, with regard to a possible interaction of a migrant background and - for example - a female gender, it is important to note that in both countries many migrant groups have their origins in countries and regions where male advantage remains very strong. This is in particular the case for migrant groups from non-Western countries, e.g. Turkey, Algeria, Marocco or Tunisie, where gender gaps in the literacy rates of up to 18 per cent are still observed. In order to investigate the question of a possible disadvantages of women with a migrant background stemming from such countries when compared to non-migrant females two panel studies - the Tree data in Switzerland and the Panel d’élèves 1995 in France -, are analysed.

The application of medical informatics to the veterinary management programs at companion animal practices in Alberta, Canada: a case study.

Companion animals closely share their domestic environment with people and have the potential to, act as sources of zoonotic diseases. They also have the potential to be sentinels of infectious and noninfectious, diseases. With the exception of rabies, there has been minimal ongoing surveillance of, companion animals in Canada. We developed customized data extraction software, the University of, Calgary Data Extraction Program (UCDEP), to automatically extract and warehouse the electronic, medical records (EMR) from participating private veterinary practices to make them available for, disease surveillance and knowledge creation for evidence-based practice. It was not possible to build, generic data extraction software; the UCDEP required customization to meet the specific software, capabilities of the veterinary practices. The UCDEP, tailored to the participating veterinary practices', management software, was capable of extracting data from the EMR with greater than 99%, completeness and accuracy. The experiences of the people developing and using the UCDEP and the, quality of the extracted data were evaluated. The electronic medical record data stored in the data, warehouse may be a valuable resource for surveillance and evidence-based medical research.

The Resource-Constrained Project Scheduling Problem with Work-Content Constraints

For executing the activities of a project, one or several resources are required, which are in general scarce. Many resource-allocation methods assume that the usage of these resources by an activity is constant during execution; in practice, however, the project manager may vary resource usage by individual activities over time within prescribed bounds. This variation gives rise to the project scheduling problem which consists in allocating the scarce resources to the project activities over time such that the project duration is minimized, the total number of resource units allocated equals the prescribed work content of each activity, and precedence and various work-content-related constraints are met.