Excel’s Sumif and Sumifs function

As accountants, we are all familiar with the SUM function, which calculates the sum in a range of numbers. However, there are instances where we might want to sum numbers in a given range based on a specified criteria. In this instance the SUM IF function can achieve this objective.

Ternary function and circuit design using ternary multiplexers

The recent trend towards minimizing the interconnections in large scale integration (LSI) circuits has led to intensive investigation in the development of ternary circuits and the improvement of their design. The ternary multiplexer is a convenient and useful logic module which can be used as a basic building block in the design of a ternary system. This paper discusses a systematic procedure for the simplification and realization of ternary functions using ternary multiplexers as building blocks. Both single level and multilevel multiplexing techniques are considered. The importance of the design procedure is highlighted by considering two specific applications, namely, the development of ternary adder/subtractor and TCD to ternary converter.

The effect of internal audit function quality and internal audit contribution to external audit on audit fees

Corporate governance mandates and listing rules identify internal audit functions (IAF) as a central internal control mechanism. External audits are expected to assess the quality of IAF before placing reliance on its work. We provide evidence on the effect of IAF quality and IAF contribution to external audit on audit fees. Using data from a matched survey of both external and internal audits, we extend prior research which is based mainly on internal audits' assessment and conducted predominantly in highly developed markets. We find a positive relationship between IAF quality and audit fees as well as a reduction in audit fees as a result of external auditors' reliance on IAF. The interaction between IAF quality and IAF contribution to external audit suggests that high quality IAF induces greater external auditor reliance on internal auditors' work and thus result in lower external audit fees.

Characterization of the molecular components and function of BARE-1, Hin-Mu and Mu transposition machineries

Transposable elements, transposons, are discrete DNA segments that are able to move or copy themselves from one locus to another within or between their host genome(s) without a requirement for DNA homology. They are abundant residents in virtually all the genomes studied, for instance, the genomic portion of TEs is approximately 3% in Saccharomyces cerevisiae, 45% in humans, and apparently more than 70% in some plant genomes such as maize and barley. Transposons plays essential role in genome evolution, in lateral transfer of antibiotic resistance genes among bacteria and in life cycle of certain viruses such as HIV-1 and bacteriophage Mu. Despite the diversity of transposable elements they all use a fundamentally similar mechanism called transpositional DNA recombination (transposition) for the movement within and between the genomes of their host organisms. The DNA breakage and joining reactions that underlie their transposition are chemically similar in virtually all known transposition systems. The similarity of the reactions is also reflected in the structure and function of the catalyzing enzymes, transposases and integrases. The transposition reactions take place within the context of a transposition machinery, which can be particularly complex, as in the case of the VLP (virus like particle) machinery of retroelements, which in vivo contains RNA or cDNA and a number of element encoded structural and catalytic proteins. Yet, the minimal core machinery required for transposition comprises a multimer of transposase or integrase proteins and their binding sites at the element DNA ends only. Although the chemistry of DNA transposition is fairly well characterized, the components and function of the transposition machinery have been investigated in detail for only a small group of elements. This work focuses on the identification, characterization, and functional studies of the molecular components of the transposition machineries of BARE-1, Hin-Mu and Mu. For BARE-1 and Hin-Mu transpositional activity has not been shown previously, whereas bacteriophage Mu is a general model of transposition. For BARE-1, which is a retroelement of barley (Hordeum vulgare), the protein and DNA components of the functional VLP machinery were identified from cell extracts. In the case of Hin-Mu, which is a Mu-like prophage in Haemophilus influenzae Rd genome, the components of the core machinery (transposase and its binding sites) were characterized and their functionality was studied by using an in vitro methodology developed for Mu. The function of Mu core machinery was studied for its ability to use various DNA substrates: Hin-Mu end specific DNA substrates and Mu end specific hairpin substrates. The hairpin processing reaction by MuA was characterized in detail. New information was gained of all three machineries. The components or their activity required for functional BARE-1 VLP machinery and retrotransposon life cycle were present in vivo and VLP-like structures could be detected. The Hin-Mu core machinery components were identified and shown to be functional. The components of the Mu and Hin-Mu core machineries were partially interchangeable, reflecting both evolutionary conservation and flexibility within the core machineries. The Mu core machinery displayed surprising flexibility in substrate usage, as it was able to utilize Hin-Mu end specific DNA substrates and to process Mu end DNA hairpin substrates. This flexibility may be evolutionarily and mechanistically important.

Find my office: Navigating real space from semantic descriptions

This paper shows that by using only symbolic language phrases, a mobile robot can purposefully navigate to specified rooms in previously unexplored environments. The robot intelligently organises a symbolic language description of the unseen environment and “imagines” a representative map, called the abstract map. The abstract map is an internal representation of the topological structure and spatial layout of symbolically defined locations. To perform goal-directed exploration, the abstract map creates a high-level semantic plan to reason about spaces beyond the robot’s known world. While completing the plan, the robot uses the metric guidance provided by a spatial layout, and grounded observations of door labels, to efficiently guide its navigation. The system is shown to complete exploration in unexplored spaces by travelling only 13.3% further than the optimal path.

Structure-Function Studies of GDNF Family Ligand-RET signalling

Glial cell line-derived neurotrophic factor (GDNF) and its family members neurturin (NRTN), artemin (ARTN) and persephin (PSPN) are growth factors, which are involved in the development, differentiation and maintenance of many neuron types. In addition, they function outside of the nervous system, e.g. in the development of kidney, testis and liver. GDNF family ligand (GFL) signalling happens through a tetrameric receptor complex, which includes two glycosylphosphatidylinositol (GPI)-anchored GDNF family receptor (GFRα) molecules and two RET (rearranged during transfection) receptor tyrosine kinases. Each of the ligands binds preferentially one of the four GFRα receptors: GDNF binds to GFRα1, NRTN to GFRα2, ARTN to GFRα3 and PSPN to GFRα4. The signal is then delivered by RET, which cannot bind the GFLs on its own, but can bind the GFL-GFRα complex. Under normal cellular conditions, RET is only phosphorylated on the cell surface after ligand binding. At least the GDNF-GFRα1 complex is believed to recruit RET to lipid rafts, where downstream signalling occurs. In general, GFRαs consist of three cysteine-rich domains, but all GFRα4s except for chicken GFRα4 lack domain 1 (D1). We characterised the biochemical and cell biological properties of mouse PSPN receptor GFRα4 and showed that it has a significantly weaker capacity than GFRα1 to recruit RET to the lipid rafts. In spite of that, it can phosphorylate RET in the presence of PSPN and contribute to neuronal differentiation and survival. Therefore, the recruitment of RET to the lipid rafts does not seem to be crucial for the biological activity of all GFRα receptors. Secondly, we demonstrated that GFRα1 D1 stabilises the GDNF-GFRα1 complex and thus affects the phosphorylation of RET and contributes to the biological activity. This may be important in physiological conditions, where the concentration of the ligand or the soluble GFRα1 receptor is low. Our results also suggest a role for D1 in heparin binding and, consequently, in the biodistribution of released GFRα1 or in the formation of the GFL-GFRα-RET complex. We also presented the crystallographic structure of GDNF in the complex with GFRα1 domains 2 and 3. The structure differs from the previously published ARTN-GFRα3 structure in three significant ways. The biochemical data verify the structure and reveal residues participating in the interactions between GFRα1 and GDNF, and preliminarily also between GFRα1 and RET and heparin. Finally, we showed that, the precursor of the oncogenic MEN 2B (multiple endocrine neoplasia type 2) form of RET gets phosphorylated already during its synthesis in the endoplasmic reticulum (ER). We also demonstrated that it associates with Src homology 2 domain-containing protein (SHC) and growth factor receptor-bound protein (GRB2) in the ER, and has the capacity to activate several downstream signalling molecules.

Relation between Chandrasekhar's X-function and the eigenvalues of integral operators with difference kernels

Abstract is not available.

Causes and consequences of variation in nestling immune function

Defence against pathogens is a vital need of all living organisms that has led to the evolution of complex immune mechanisms. However, although immunocompetence the ability to resist pathogens and control infection has in recent decades become a focus for research in evolutionary ecology, the variation in immune function observed in natural populations is relatively little understood. This thesis examines sources of this variation (environmental, genetic and maternal effects) during the nestling stage and its fitness consequences in wild populations of passerines: the blue tit (Cyanistes caeruleus) and the collared flycatcher (Ficedula albicollis). A developing organism may face a dilemma as to whether to allocate limited resources to growth or to immune defences. The optimal level of investment in immunity is shaped inherently by specific requirements of the environment. If the probability of contracting infection is low, maintaining high growth rates even at the expense of immune function may be advantageous for nestlings, as body mass is usually a good predictor of post-fledging survival. In experiments with blue tits and haematophagous hen fleas (Ceratophyllus gallinae) using two methods, methionine supplementation (to manipulate nestlings resource allocation to cellular immune function) and food supplementation (to increase resource availability), I confirmed that there is a trade-off between growth and immunity and that the abundance of ectoparasites is an environmental factor affecting allocation of resources to immune function. A cross-fostering experiment also revealed that environmental heterogeneity in terms of abundance of ectoparasites may contribute to maintaining additive genetic variation in immunity and other traits. Animal model analysis of extensive data collected from the population of collared flycatchers on Gotland (Sweden) allowed examination of the narrow-sense heritability of PHA-response the most commonly used index of cellular immunocompetence in avian studies. PHA-response is not heritable in this population, but is subject to a non-heritable origin (presumably maternal) effect. However, experimental manipulation of yolk androgen levels indicates that the mechanism of the maternal effect in PHA-response is not in ovo deposition of androgens. The relationship between PHA-response and recruitment was studied for over 1300 collared flycatcher nestlings. Multivariate selection analysis shows that it is body mass, not PHA-response, that is under direct selection. PHA-response appears to be related to recruitment because of its positive relationship with body mass. These results imply that either PHA-response fails to capture the immune mechanisms that are relevant for defence against pathogens encountered by fledglings or that the selection pressure from parasites is not as strong as commonly assumed.

Structural and Functional Studies on Trimeric Autotransporters

Trimeric autotransporters are a family of secreted outer membrane proteins in Gram-negative bacteria. These obligate homotrimeric proteins share a conserved C-terminal region, termed the translocation unit. This domain consists of an integral membrane β-barrel anchor and associated α-helices which pass through the pore of the barrel. The α-helices link to the extracellular portion of the protein, the passenger domain. Autotransportation refers to the way in which the passenger domain is secreted into the extracellular space. It appears that the translocation unit mediates the transport of the passenger domain across the outer membrane, and no external factors, such as ATP, ion gradients nor other proteins, are required. The passenger domain of autotransporters contains the specific activities of each protein. These are usually related to virulence. In trimeric autotransporters, the main function of the proteins is to act as adhesins. One such protein is the Yersinia adhesin YadA, found in enteropathogenic species of Yersinia. The main activity of YadA from Y. enterocolitica is to bind collagen, and it also mediates adhesion to other molecules of the extracellular matrix. In addition, YadA is involved in serum resistance, phagocytosis resistance, binding to epithelial cells and autoagglutination. YadA is an essential virulence factor of Y. enterocolitica, and removal of this protein from the bacteria leads to avirulence. In this study, I investigated the YadA-collagen interaction by studying the binding of YadA to collagen-mimicking peptides by several biochemical and biophysical methods. YadA bound as tightly to the triple-helical model peptide (Pro-Hyp-Gly)10 as to native collagen type I. However, YadA failed to bind a similar peptide that does not form a collagenous triple helix. As (Pro-Hyp-Gly)10 does not contain a specific sequence, we concluded that a triple-helical conformation is necessary for YadA binding, but no specific sequence is required. To further investigate binding determinants for YadA in collagens, I examined the binding of YadA to a library of collagen-mimicking peptides that span the entire triple-helical sequences of human collagens type II and type III. YadA bound promiscuously to many but not all peptides, indicating that a triple-helical conformation alone is not sufficient for binding. The high-binding peptides did not share a clear binding motif, but these peptides were rich in hydroxyproline residues and contained a low number of charged residues. YadA thus binds collagens without sequence specificity. This strategy of promiscuous binding may be advantageous for pathogenic bacteria. The Eib proteins from Escherichia coli are immunoglobulin (Ig)-binding homologues of YadA. I showed conclusively that recombinant EibA, EibC, EibD and EibF bind to IgG Fc. I crystallised a fragment of the passenger domain of EibD, which binds IgA in addition to IgG. The structure has a YadA-like head domain and an extended coiled-coil stalk. The top half of the coiled-coil is right-handed with hendecad periodicity, whereas the lower half is a canonical left-handed coiled-coil. At the transition from right- to left-handedness, a small β-sheet protrudes from each monomer. I was able to map the binding regions for IgG and IgA using truncations and site-directed mutagenesis to the coiled-coil stalk and identified residues critical for Ig binding.

Use of protein A gene fusions for the analysis of structure-function relationship of the transactivator protein C of bacteriophage Mu

A sensitive dimerization assay for DNA binding proteins has been developed using gene fusion technology. For this purpose, we have engineered a gene fusion using protein A gene of Staphylococcus aureus and C gene, the late gene transactivator of bacteriophage Mu. The C gene was fused to the 3' end of the gene for protein A to generate an A- C fusion. The overexpressed fusion protein was purified in a single step using immunoglobulin affinity chromatography. Purified fusion protein exhibits DNA binding activity as demonstrated by electrophoretic mobility shift assays. When the fusion protein A-C was mixed with C and analyzed for DNA binding, in addition to C and A-C specific complexes, a single intermediate complex comprising of a heterodimer of C and A-C fusion proteins was observed. Further, the protein A moiety in the fusion protein A-C does not contribute to DNA binding as demonstrated by proteolytic cleavage and circular dichroism (CD) analysis. The assay has also been applied to analyze the DNA binding domain of C protein by generating fusions between protein A and N- and C-terminal deletion mutants of C. The results indicate a role for the region towards the carboxy terminal of the protein in DNA binding. The general applicability of this method is discussed.