Naming ranges in Excel

When working with functions in Excel you can reference a range of cells by simply selecting the cells. For instance if you wanted to sum all your first month sales located in the range B3:B16, the function would be =SUM(B3:B16).

Climate change impact assessment: Uncertainty modeling with imprecise probability

Hydrologic impacts of climate change are usually assessed by downscaling the General Circulation Model (GCM) output of large-scale climate variables to local-scale hydrologic variables. Such an assessment is characterized by uncertainty resulting from the ensembles of projections generated with multiple GCMs, which is known as intermodel or GCM uncertainty. Ensemble averaging with the assignment of weights to GCMs based on model evaluation is one of the methods to address such uncertainty and is used in the present study for regional-scale impact assessment. GCM outputs of large-scale climate variables are downscaled to subdivisional-scale monsoon rainfall. Weights are assigned to the GCMs on the basis of model performance and model convergence, which are evaluated with the Cumulative Distribution Functions (CDFs) generated from the downscaled GCM output (for both 20th Century [20C3M] and future scenarios) and observed data. Ensemble averaging approach, with the assignment of weights to GCMs, is characterized by the uncertainty caused by partial ignorance, which stems from nonavailability of the outputs of some of the GCMs for a few scenarios (in Intergovernmental Panel on Climate Change [IPCC] data distribution center for Assessment Report 4 [AR4]). This uncertainty is modeled with imprecise probability, i.e., the probability being represented as an interval gray number. Furthermore, the CDF generated with one GCM is entirely different from that with another and therefore the use of multiple GCMs results in a band of CDFs. Representing this band of CDFs with a single valued weighted mean CDF may be misleading. Such a band of CDFs can only be represented with an envelope that contains all the CDFs generated with a number of GCMs. Imprecise CDF represents such an envelope, which not only contains the CDFs generated with all the available GCMs but also to an extent accounts for the uncertainty resulting from the missing GCM output. This concept of imprecise probability is also validated in the present study. The imprecise CDFs of monsoon rainfall are derived for three 30-year time slices, 2020s, 2050s and 2080s, with A1B, A2 and B1 scenarios. The model is demonstrated with the prediction of monsoon rainfall in Orissa meteorological subdivision, which shows a possible decreasing trend in the future.

The range expansion of the European map butterfly in Finland

Climate change will influence the living conditions of all life on Earth. For some species the change in the environmental conditions that has occurred so far has already increased the risk of extinction, and the extinction risk is predicted to increase for large numbers of species in the future. Some species may have time to adapt to the changing environmental conditions, but the rate and magnitude of the change are too great to allow many species to survive via evolutionary changes. Species responses to climate change have been documented for some decades. Some groups of species, like many insects, respond readily to changes in temperature conditions and have shifted their distributions northwards to new climatically suitable regions. Such range shifts have been well documented especially in temperate zones. In this context, butterflies have been studied more than any other group of species, partly for the reason that their past geographical ranges are well documented, which facilitates species-climate modelling and other analyses. The aim of the modelling studies is to examine to what extent shifts in species distributions can be explained by climatic and other factors. Models can also be used to predict the future distributions of species. In this thesis, I have studied the response to climate change of one species of butterfly within one geographically restricted area. The study species, the European map butterfly (Araschnia levana), has expanded rapidly northwards in Finland during the last two decades. I used statistical and dynamic modelling approaches in combination with field studies to analyse the effects of climate warming and landscape structure on the expansion. I studied possible role of molecular variation in phosphoglucose isomerase (PGI), a glycolytic enzyme affecting flight metabolism and thereby flight performance, in the observed expansion of the map butterfly at two separate expansion fronts in Finland. The expansion rate of the map butterfly was shown to be correlated with the frequency of warmer than average summers during the study period. The result is in line with the greater probability of occurrence of the second generation during warm summers and previous results on this species showing greater mobility of the second than first generation individuals. The results of a field study in this thesis indicated low mobility of the first generation butterflies. Climatic variables alone were not sufficient to explain the observed expansion in Finland. There are also problems in transferring the climate model to new regions from the ones from which data were available to construct the model. The climate model predicted a wider distribution in the south-western part of Finland than what has been observed. Dynamic modelling of the expansion in response to landscape structure suggested that habitat and landscape structure influence the rate of expansion. In southern Finland the landscape structure may have slowed down the expansion rate. The results on PGI suggested that allelic variation in this enzyme may influence flight performance and thereby the rate of expansion. Genetic differences of the populations at the two expansion fronts may explain at least partly the observed differences in the rate of expansion. Individuals with the genotype associated with high flight metabolic rate were most frequent in eastern Finland, where the rate of range expansion has been highest.

Late Quaternary vegetational and climatic changes from tropical peats in southern India - An extended record up to 40,000 years BP

Stable carbon isotope ratios of peats dated (by C-14) back to 40 kyr BP from the montane region (> 1800 m asl) of the Nilgiris, southern India, reflect changes in the relative proportions of C3 and C4 plant types, which are influenced by soil moisture (and hence monsoonal precipitation), From prior to 40 kyr BP until 28 kyr BP, a general decline in delta(13)C values from about - 14 per mil to - 19 per mil suggests increased dominance of C3 plants concurrent with increasingly moist conditions, During 28-18 kyr BP there seems relatively little change with delta(13) C of - 19 to - 18 per mil, At about 16 kyr BP a sharp reversal in delta(13)C to a peak of - 14.7 per mil indicates a clear predominance of C4 vegetation associated with arid conditions, possibly during or just after the Last Glacial Maximum, A moist phase at about 9 kyr BP (the Holocene Optimum) with dominance of C3 vegetation type is observed, while arid conditions are re-established during 5-2 kyr BP with an overall dominance of C4 vegetation, New data do not support the occurrence of a moist phase coinciding with the Mediaeval Warm Period (at 0.6 kyr BP) as suggested earlier, Overall, the climate and vegetation in the high altitude regions of the southern Indian tropics seem to have responded to past global climatic changes, and this is consistent with other evidences from India and other tropical regions.

Rapid quenching and glass formation in chalcogenide glasses: Preparation and properties of Ge-As-Te glasses over an extended composition ranges

In Ge-As-Te system, the glass forming region determined by normal melt quenching method has two regions (GFR I and GFR II) separated by few compositions gap. With a simple laboratory built twin roller apparatus, we have succeeded in preparing Ge7.5AsxTe92.5-x glasses over extended composition ranges. A distinct change in T-g is observed at x = 40, exactly at which the separation of the glass forming regions occur indicating the changes in the connectivity and the rigidity of the structural network. The maximum observed in glass transition (T-g) at x = 55 corresponding to the average coordination number (Z(av)) = 2.70 is an evidence for the shift of the rigidity percolation threshold (RPT) from Z(av) = 2.40 as predicted by the recent theories. The glass forming tendency (K-gl) and Delta T (=T-c-T-g) is low for the glasses in the GFR I and high for the glasses in the GFR II.

Supersolid and solitonic phases in the one-dimensional extended Bose-Hubbard model

We report our findings on the quantum phase transitions in cold bosonic atoms in a one-dimensional optical lattice using the finite-size density-matrix renormalization-group method in the framework of the extended Bose-Hubbard model. We consider wide ranges of values for the filling factors and the nearest-neighbor interactions. At commensurate fillings, we obtain two different types of charge-density wave phases and a Mott insulator phase. However, departure from commensurate fillings yields the exotic supersolid phase where both the crystalline and the superfluid orders coexist. In addition, we obtain the signatures for the solitary waves and the superfluid phase.

Improving diagnosis of tumor-induced osteomalacia with gallium-68 DOTATATE PET/CT

Context: Tumor-induced osteomalacia (TIO) is a rarely diagnosed disorder presenting with bone pain, fractures, muscle weakness, and moderate-to-severe hypophosphatemia resulting from fibroblast growth factor 23-mediated renal phosphate wasting. Tumors secreting fibroblast growth factor 23 are often small and difficult to find with conventional imaging. Objective: We studied the utility of 68Ga-DOTA-octreotate (DOTATATE) somatostatin receptor positron emission tomography (PET)/computed tomography (CT) imaging in the diagnosis of TIO. Design and Setting: A multicenter case series was conducted at tertiary referral hospitals. Patients and Methods: Six patients with TIO diagnosed between 2003 and 2012 in Australia were referred for DOTATATE PET imaging. We reviewed the clinical history, biochemistry, imaging characteristics, histopathology, and clinical outcome of each patient. Results: Each case demonstrated delayed diagnosis despite severe symptoms. DOTATATE PET/CT imaging demonstrated high uptake and localized the tumor with confidence in each case. After surgical excision, there was resolution of clinical symptoms and serum phosphate, except in one patient who demonstrated residual disease on PET/CT. All tumors demonstrated high somatostatin receptor subtype 2 cell surface receptor expression using immunohistochemistry. Conclusions: In patients with TIO, DOTATATE PET/CT can successfully localize phosphaturic mesenchymal tumors and may be a practical first step in functional imaging for this disorder. Serum phosphate should be measured routinely in patients with unexplained muscle weakness, bone pain, or stress fractures to allow earlier diagnosis of TIO. - See more at: http://press.endocrine.org/doi/abs/10.1210/jc.2012-3642#sthash.eXD0CopL.dpuf

A lower bound to the survival probability and an approximate first passage time distribution for Markovian and non-Markovian dynamics in phase space

We derive a very general expression of the survival probability and the first passage time distribution for a particle executing Brownian motion in full phase space with an absorbing boundary condition at a point in the position space, which is valid irrespective of the statistical nature of the dynamics. The expression, together with the Jensen's inequality, naturally leads to a lower bound to the actual survival probability and an approximate first passage time distribution. These are expressed in terms of the position-position, velocity-velocity, and position-velocity variances. Knowledge of these variances enables one to compute a lower bound to the survival probability and consequently the first passage distribution function. As examples, we compute these for a Gaussian Markovian process and, in the case of non-Markovian process, with an exponentially decaying friction kernel and also with a power law friction kernel. Our analysis shows that the survival probability decays exponentially at the long time irrespective of the nature of the dynamics with an exponent equal to the transition state rate constant.

Conditional Probability-Based Significance Tests for Sequential Patterns in Multineuronal Spike Trains

We consider the problem of detecting statistically significant sequential patterns in multineuronal spike trains. These patterns are characterized by ordered sequences of spikes from different neurons with specific delays between spikes. We have previously proposed a data-mining scheme to efficiently discover such patterns, which occur often enough in the data. Here we propose a method to determine the statistical significance of such repeating patterns. The novelty of our approach is that we use a compound null hypothesis that not only includes models of independent neurons but also models where neurons have weak dependencies. The strength of interaction among the neurons is represented in terms of certain pair-wise conditional probabilities. We specify our null hypothesis by putting an upper bound on all such conditional probabilities. We construct a probabilistic model that captures the counting process and use this to derive a test of significance for rejecting such a compound null hypothesis. The structure of our null hypothesis also allows us to rank-order different significant patterns. We illustrate the effectiveness of our approach using spike trains generated with a simulator.

Formation ranges of icosahedral, amorphous and crystalline phases in rapidly solidified Ti-Zr-Hf-Ni alloys

From the quaternary Ti-Zr-Hf-Ni phase diagram. the cross-section at 20 at % Ni was selected for investigation. The icosahedral quasicrystalline, crystalline and amorphous phases were observed to form in nine kinds of rapidly solidified (TixZryHfz)(80)Ni-20 (x + y + z = 1) alloys at different compositions. The quasilattice constants of 0.519 and 0.531 nm were obtained for the icosahedral phase formed in the melt-spun Ti40Zr20Hf20Ni20 and Ti20Zr40Hf20Ni20 alloys. respectively. The icosahedral phase formed in the melt-spun Ti40Zr20Hf20Ni20 alloy especially is thermodynamically stable. The supercooled liquid region of the Ti20Zr20Hf40Ni20 glassy alloy reached 64 K. From these results a comparison of quasicrystal-forming and glass-forming abilities, was carried out. The quasicrystal-forming ability was reduced and glass-forming ability was improved with an increase in Hf and Zr contents in the (TixZryHfz)(80)Ni-20 alloys. On the other hand. an increase in Ti content caused an improvement in quasicrystal-forming ability.

Indoleacetaldoxime hydro-lyase : II. Purification and properties

The purification and some properties of the enzyme indoleacetaldoxime hydrolyase (EC 4.2.1.29) from the fungus Gibberella fujikuroi, which dehydrates indoleacetaldoxime (IAOX) to indoleacetonitrile (IAN), are described. The enzyme activity in the fungus is present only under certain culture conditions. It is a soluble enzyme, has an optimum pH at 7, shows an energy of activation of —15,670 cal/mole, and has a Michaelis constant of 1.7 × 10−4 Image at 30 °. It appears to be specific for IAOX, and 1 mole of IAN is produced per mole of IAOX utilized. The enzyme is inhibited by a number of aldoximes of which phenylacetaldoxime (PAOX) is the most potent inhibitor. Inhibition by PAOX is competitive (Ki = 2.2 × 10−8 Image ). The enzyme is inhibited by SH reagents such as p-hydroxymercuribenzoate and N-ethylmaleimide, and by a number of SH compounds such as cysteine, β-mercaptoethanol, and 2,3-dimercaptopropanol (BAL). However, glutathione activates the enzyme. Metal chelating agents such as 8-OH-quinoline and diethyl dithiocarbamate inhibit the enzyme; the inhibition is partly reversed by ferric citrate. Ascorbic acid, and particularly dehydroascorbic acid (DHA), are good activators of the enzyme. Several other biological oxidants had either no action or had a slight effect. Potassium cyanide activates the enzyme at low concentration but inhibits at higher concentrations. Reduction of the enzyme with NaBH4 reduces activity, and the effect is partly reversed by pyridoxal phosphate and also by DHA. The above properties indicate that both an SH function and an oxidized function are required for activity.

First passage probability during random vibration

The probability that a random process crosses an arbitrary level for the first time is expressed as a Gram—Charlier series, the leading term of which is the Poisson approximation. The coefficients of this series are related to the moments of the number of level crossings. The results are applicable to both stationary and non-stationary processes. Some numerical results are presented for the response process of a linear single-degree-of-freedom oscillator under Gaussian white noise excitation.

Primary Structural Documentation of the Major Urinary Protein of the Indian Commensal Rat (Rattus rattus) Using a Proteomics Platform

Purpose: A number of proteome studies have been performed recently to identify pheromone-related protein expression and their molecular function using genetically modified rodents' urine. However, no such studies have used Indian commensal rodents; interestingly, in a previous investigation, we confirmed the presence of volatile molecules in commensal rodents urine and these molecules seem to be actively involved in pheromonal communication. Therefore, the present study aims to identify the major urinary protein [MUP] present in commensal rat urine, which will help us to understand the protein's expression pattern and intrinsic properties among the rodents globally. Experimental Design: Initially, the total urinary proteins were separated by 1-D and 2-D electrophoresis and then subsequently analyzed by Matrix Assisted Laser Desorption Ionization-Time of Flight and Mass Spectrometer (MALDI-TOF/MS). Furthermore, they were then fragmented with the aid of a Tandem Mass Spectrometer (TOF/TOF) and the identified sequences aligned and confirmed using similarity with the deduced primary structures of members of the lipocalin superfamily.Results: The SDS-PAGE protein profiles showed distinct proteins with molecular masses of 15, 22.4, 25, 28, 42, 50, 55, 68, and 91 kDa. Of these proteins, the 22.4 kDa protein was considered to be target candidate. When 2D electrophoresis was carried out, about similar to 50 spots were detected with different masses and various pI ranges. The 22.4 kDa protein was found to have a pI of about 4.9. This 22.4 kDa protein spot was digested and subjected to mass spectrometry; it was identified as rat MUP. The fragmented peptides from the rat MUP at 935, 1026, 1192, and 1303 m/z were further fragmented with the aid of MS/MS and generated de novo sequence and this confirmed this protein to be the MUP present in the urine of commensal rats.Conclusion: The present investigation confirms the presence of MUP with a molecular mass of 22.4 kDa in the urine of commensal rats. This protein may be involved in the binding of volatile molecules and opens up a discussion about how volatile and non-volatile molecules in the commensal rats' urine may contribute chemo-communication.

Spatial survival probability for one-dimensional fluctuating interfaces in the steady state

We report numerical and analytic results for the spatial survival probability for fluctuating one-dimensional interfaces with Edwards-Wilkinson or Kardar-Parisi-Zhang dynamics in the steady state. Our numerical results are obtained from analysis of steady-state profiles generated by integrating a spatially discretized form of the Edwards-Wilkinson equation to long times. We show that the survival probability exhibits scaling behavior in its dependence on the system size and the "sampling interval" used in the measurement for both "steady-state" and "finite" initial conditions. Analytic results for the scaling functions are obtained from a path-integral treatment of a formulation of the problem in terms of one-dimensional Brownian motion. A "deterministic approximation" is used to obtain closed-form expressions for survival probabilities from the formally exact analytic treatment. The resulting approximate analytic results provide a fairly good description of the numerical data.