A Primer on Spreadsheet Analytics

This paper provides guidance to an analyst who wants to extract insight from a spreadsheet model. It discusses the terminology of spreadsheet analytics, how to prepare a spreadsheet model for analysis, and a hierarchy of analytical techniques. These techniques include sensitivity analysis, tornado charts,and backsolving (or goal-seeking). This paper presents native-Excel approaches for automating these techniques, and discusses add-ins that are even more efficient. Spreadsheet optimization and spreadsheet Monte Carlo simulation are briefly discussed. The paper concludes by calling for empirical research, and describing desired features spreadsheet sensitivity analysis and spreadsheet optimization add-ins.Comment: 12 Pages, 8 Colour Figure

The influence of line shape and band structure on temperatures in planetary atmospheres

Numerical experiments are performed to examine the effects of line shape and band structure on the radiative equilibrium temperature profile in planetary atmospheres. In order to accurately determine these effects, a method for calculating radiative terms is developed which avoids the usual approximations. It differs from the more commonly used methods in that it allows arbitrary dependence of the absorption coefficient on wave number, without requiring tedious line by line integration and without the constraints of band models. The present formulation is restricted to homogeneous atmospheres but the concept can be extended to the more general case. The numerical experiments reveal that the line shape and band structure of the absorbing gases have a large effect on temperatures in the higher layers of the atmosphere (corresponding to the stratosphere and mesosphere). The more nongrey the spectrum (that is, the higher the peaks and the deeper the troughs in the spectrum), the lower the temperature

The trusted mediator: developing an ethical framework for the professionalisation of commercial mediation.

This paper is written from the Standpoint of a participant observer and forms an exploratory case study examining the ethical dimension of commercial mediation in the context of its professionalisation. It brings together a series of papers written between April 2001 and June 2002. They are presented here in a revised form and different order as chapters oscillating between the changing context of commercial mediation and a discussion of particular sociological and ethical concepts. The paper attempts to identify the theoretical territory of the study of professions and professionalisation and the ethical perspectives and moral categories which describe the territory. It addresses the problems encountered in attempts to develop an abstract theory of professions which has generally been polarised between attribute and processual approaches. Issues which emerge include conflicts of professional roles arising from different understandings of what a profession is for, the duty of a profession to serve the public good, the legitimacy of professional authority and the accountability of Professionals. These issues are often expressed as a tension between the ideal of autonomy of a profession and consumer demand for accountability; a tension between the principles of service on which a profession is said to be ethically based and an ethics of responsibility demanded by the market. At the same time, the economic context in which professions emerge and develop gives rise to ethical considerations about the effects of the dominant economic System and the function of trust as an element of social capital. The approach in this paper is to take professionalisation as a dynamic and historical concept which involves both an ideological and ethical strategy in the development of an occupational group. It suggests that ethical perception in Professionals could develop more practically by freeing the conceptualisation of professions from making distinctions in ethical roles between professions and business based on the oppositions of shared and self interest. The relevant emphasis rests not in what Professionals do and how long they take to learn to do it but who Professionals are as persons; that is, the difference between being a professional and being professional. But clearly professional work does not lie in just 'being'. The degree to which a professional is required in commercial mediation is one that the concept of the trusted mediator must account for. Using this concept to develop an ethical framework, the paper finally discusses policy implications regarding the professionalisation of commercial mediation

Comparative study of heat rejection systems for portable life support equipment Final report

Comparsion of heat rejection systems for portable life support equipment for earth orbital or lunar surface EV

The simultaneous integration of many trajectories using nilpotent normal forms

Taylor's formula shows how to approximate a certain class of functions by polynomials. The approximations are arbitrarily good in some neighborhood whenever the function is analytic and they are easy to compute. The main goal is to give an efficient algorithm to approximate a neighborhood of the configuration space of a dynamical system by a nilpotent, explicitly integrable dynamical system. The major areas covered include: an approximating map; the generalized Baker-Campbell-Hausdorff formula; the Picard-Taylor method; the main theorem; simultaneous integration of trajectories; and examples

Bs0−Bˉs0B_s^0 - \bar B_s^0 mixing and b→sb \to s transitions in isosinglet down quark model

The recent observation of the mass difference in $B_s$ system seems to be not in complete agreement with the corresponding standard model value. We consider the model with an extra vector like down quark to explain this discrepancy and obtain the constraints on the new physics parameters. Thereafter, we show that with these new constraints this model can successfully explain other observed deviations associated with $b \to s$ transitions, namely, $B_s \to \psi \phi$, $B\to K \pi$ and $B\to \phi K_s$.Comment: 19 pages, 6 figure