963 resultados para Excel spreadsheets
Resumo:
The data describe the flows of nitrogen between different pools and economic sectors within Denmark. The data are stored in an Excel spreadsheet that is divided into a number of worksheets. The National worksheet contains the national flows of nitrogen for the years 1990 to 2010 (note that for some flows, the data series is not complete for all years). These data underlie the national nitrogen flow figures in the main text of the paper. The remaining worksheets contain the data that underlie the figures presented in the detailed description of nitrogen flows between pools/sectors, that is in the Supplementary Material associated with the paper.
Resumo:
The goals of this study were (1) to investigate whether Fucus vesiculosus regulates the production of its antifouling defence chemicals against microfoulers in response to light limitation and temperature shifts and (2) to investigate if different surface concentrations of defence compounds shape epibacterial communities. F. vesiculosus was incubated in indoor mesocosms at five different temperature conditions (5 to 25°C) and in outdoor mesocosms under six differently reduced sunlight conditions (0 to 100%), respectively. Algal surface concentrations of previously identified antifouling compounds - dimethylsulphopropionate (DMSP), fucoxanthin and proline - were determined and the bacterial community composition was characterized by in-depth sequencing of the 16S-rRNA gene. Altogether, the effect of different treatment levels upon defence compound concentrations was limited. Under all conditions DMSP alone appeared to be sufficiently concentrated to warrant for at least a partial inhibitory action against epibiotic bacteria of F. vesiculosus. In contrast, proline and fucoxanthin rarely reached the necessary concentration ranges for self-contained inhibition. Nonetheless, in both experiments along with the direct influence of temperature and light, all three compounds apparently affected (and thereby shaped) the overall bacterial community composition associated with F. vesiculosus since tendencies for insensitivity towards all three compounds were observed among bacterial taxa that typically dominate those communities. Given that the concentrations of at least one of the compounds (in most cases DMSP) were always high enough to inhibit bacterial settlement, we conclude that the capacity of F. vesiculosus for such defence will hardly be compromised by shading or warming to temperatures up to 25°C.
Resumo:
El Trabajo Fin de Grado ha consistido en el diseño e implementación de una herramienta para la gestión y administración de los entrenamientos de atletas de deportes individuales. Hasta ahora los deportistas debían gestionar sus entrenamientos a través de hojas de cálculo, teniendo que dedicar tiempo al aprendizaje de herramientas como Microsoft Excel u OpenOffice Excel para personalizar las plantillas y guardar los datos, utilizar otras herramientas como Google Calendar para obtener una visión de un calendario con los entrenamientos realizados o bien utilizar programas hechos a medida para un deporte e incluso para un deportista. El objetivo principal consistía en desarrollar una herramienta que unificara todas las tareas para ofrecer al deportista las funciones de configuración de plantillas, registro y generación de gráficas de los datos registrados y visionado del calendario de entrenamientos de una forma ágil, sencilla e intuitiva, adaptándose a las necesidades de cualquier deporte o deportista. Para alcanzar el objetivo principal realizamos encuestas a atletas de una gran diversidad de deportes individuales, detectando las particularidades de cada deporte y analizando los datos que nos ofrecían para alcanzar el objetivo de diseñar una herramienta versátil que permitiera su uso independientemente de los parámetros que se quisiera registrar de cada entrenamiento. La herramienta generada es una herramienta programada en Java, que ofrece portabilidad a cualquier sistema operativo que lo soporte, sin ser necesario realizar una instalación previa. Es una aplicación plug and play en la que solo se necesita del fichero ejecutable para su funcionamiento; de esta forma facilitamos que el deportista guarde toda la información en muy poco espacio, 6 megabytes aproximadamente, y pueda llevarla a cualquier lado en un pen drive o en sistemas de almacenamiento en la nube. Además, los ficheros en los que se registran los datos son ficheros CSV (valores separados por comas) con un formato estandarizado que permite la exportación a otras herramientas. Como conclusión el atleta ahorra tiempo y esfuerzo en tareas ajenas a la práctica del deporte y disfruta de una herramienta que le permite analizar de diferentes maneras cada uno de los parámetros registrados para ver su evolución y ayudarle a mejorar aquellos aspectos que sean deficientes. ---ABSTRACT---The Final Project consists in the design and implementation of a tool for the management and administration of training logs for individual athletes. Until now athletes had to manage their workouts through spreadsheets, having to spend time in learning tools such as Microsoft Excel or OpenOffice in order to save the data, others tools like Google Calendar to check their training plan or buy specifics programs designed for a specific sport or even for an athlete. The main purpose of this project is to develop an intuitive and straightforward tool that unifies all tasks offering setup functions, data recording, graph generation and training schedule to the athletes. Whit this in mind, we have interviewed athletes from a wide range of individual sports, identifying their specifications and analyzing the data provided to design a flexible tool that registers multitude of training parameters. This tool has been coded in Java, providing portability to any operating system that supports it, without installation being required. It is a plug and play application, that only requires the executable file to start working. Accordingly, athletes can keep all the information in a relative reduced space (aprox 6 megabytes) and save it in a pen drive or in the cloud. In addition, the files whit the stored data are CSV (comma separated value) files whit a standardized format that allows exporting to other tools. Consequently athletes will save time and effort on tasks unrelated to the practice of sports. The new tool will enable them to analyze in detail all the existing data and improve in those areas with development opportunities.
Resumo:
El presente proyecto, consiste en el diseño básico de una hoja Excel para un tanque de almacenamiento de gasóleo de automoción (gasóleo A). El presente tanque se ha situado en el parque de almacenamiento de Loeches (Comunidad de Madrid). Se han realizado los cálculos necesarios para el diseño de todas las partes de dicho tanque, la envolvente, el fondo de tanque y el techo. Al igual que el cálculo de peso de éste, y un listado de accesorios adicionales necesarios para su puesta en marcha. Se ha desarrollado la programación en Excel, de una ficha para calcular los parámetros principales del tanque diseñado. Se ha llevado a cabo el diseño y fabricación de un tanque de acero, vertical, cilíndrico, de fondo plano, no enterrado, soldados, para el almacenamiento de líquidos a temperatura ambiente. La capacidad del tanque es de un volumen nominal de 25.000 m3 y una altura de 20 metros, se almacenará gasóleo de automoción, con una densidad de 835 kg/m3. Este tipo de gasóleo es el producto derivado del petróleo más consumido en España.This project consists of the basic design of an Excel spreadsheet to a storage tank of diesel fuel (oil A). This tank is located in the storage yard Loeches (Madrid). It have been made the necessary calculations for the design of all parts of the tank, the envelope, the tank bottom and roof. As the weight calculation thereof, and a list of additional accessories required for its implementation and location. It has been developed programming Excel, a record key parameters to calculate tank designed. It has been carried out the design and manufacture of a steel tank, vertical, cylindrical, flat bottom, not buried, soldiers, for storing liquids at room temperature. The tank capacity is of a nominal capacity of 25,000 m3 and a height of 20 meters, diesel fuel is stored, with a density of 835 kg/m3. This type of oil is the oil product most consumed in Spain.
Resumo:
Marca tip. en port. y colofón en h. [27]
Resumo:
The Relative Age Effect (RAE) has been analyzed in a population of Spanish international handball players (n=161) divided into four different levels: Senior, Junior, Juvenile and Promising Talents. The variables registered were quarter, half year and year of birth using the initial information of their date of birth. The data were collected from the Royal Spanish Handball Federation on-line data base. The statistical method used was the χ2 and the minimum level of significance was set at p<0.05. The total results on distribution by quarter show a significant difference (χ2= 21.68; p<0.01) with a greater frequency of players born in the first quarter (40.37%) compared to those born in the second (22.36%), third (16.15%) and fourth quarter (21.12%). The total results on the distribution of birth date by half year show a significant difference (χ2= 10.44; p<0.01) with a greater frequency of players born in the first half of the year (62.73%). With regard to the rate of births registered in an even numbered or odd numbered year there are significant differences when the rates for an even numbered year (64.60%) and an odd numbered year (35.40%) are compared with those of the general population (χ2= 13.72; p<0.001). Based on the data collected and analyzed it can be concluded that there is a RAE in the basic categories of the Spanish national men’s handball teams according to quarter, half year and year of birth (even or odd numbered), but there exists little knowledge about the causes and consequence which may be produced by, or derive from, this effect.
Estimation of pharmacokinetic parameters from non-compartmental variables using Microsoft Excel((R))
Resumo:
This study was conducted to develop a method, termed 'back analysis (BA)', for converting non-compartmental variables to compartment model dependent pharmacokinetic parameters for both one- and two-compartment models. A Microsoft Excel((R)) spreadsheet was implemented with the use of Solver((R)) and visual basic functions. The performance of the BA method in estimating pharmacokinetic parameter values was evaluated by comparing the parameter values obtained to a standard modelling software program, NONMEM, using simulated data. The results show that the BA method was reasonably precise and provided low bias in estimating fixed and random effect parameters for both one- and two-compartment models. The pharmacokinetic parameters estimated from the BA method were similar to those of NONMEM estimation.
Resumo:
'Takes the challenging and makes it understandable. The book contains useful advice on the application of statistics to a variety of contexts and shows how statistics can be used by managers in their work.' - Dr Terri Byers, Assistant Professor, University Of New Brunswick, Canada A book about introductory quantitative analysis for business students designed to be read by first- and second-year students on a business studies degree course that assumes little or no background in mathematics or statistics. Based on extensive knowledge and experience in how people learn and in particular how people learn mathematics, the authors show both how and why quantitative analysis is useful in the context of business and management studies, encouraging readers to not only memorise the content but to apply learning to typical problems. Fully up-to-date with comprehensive coverage of IBM SPSS and Microsoft Excel software, the tailored examples illustrate how the programmes can be used, and include step-by-step figures and tables throughout. A range of ‘real world’ and fictional examples, including "The Ballad of Eddie the Easily Distracted" and "Esha's Story" help bring the study of statistics alive. A number of in-text boxouts can be found throughout the book aimed at readers at varying levels of study and understanding •Back to Basics for those struggling to understand, explain concepts in the most basic way possible - often relating to interesting or humorous examples •Above and Beyond for those racing ahead and who want to be introduced to more interesting or advanced concepts that are a little bit outside of what they may need to know •Think it over get students to stop, engage and reflect upon the different connections between topics A range of online resources including a set of data files and templates for the reader following in-text examples, downloadable worksheets and instructor materials, answers to in-text exercises and video content compliment the book.
Resumo:
The city of Natal has a significant daylight availability, although it use isn’t systematically explored in schools architecture. In this context, this research aims to determine procedures for the analysis of the daylight performance in school design in Natal-RN. The method of analysis is divided in Visible Sky Factor (VSF), simulating and analyzing the results. The annual variation of the daylight behavior requires the adoption of dynamic simulation as data procedure. The classrooms were modelled in SketchUp, simulated in Daysim program and the results were assessed by means of spreadsheets in Microsoft Excel. The classrooms dimensions are 7.20mx 7.20m, with windows-to-wall-ratio (WWR) of 20%, 40% and 50%, and with different shading devices, such as standard horizontal overhang, sloped overhang, standard horizontal overhang with side view protection, standard horizontal overhang with a dropped edge, standard horizontal overhang with three horizontal louvers, double standard horizontal overhang, double standard horizontal overhang with three horizontal louvers, plus the use of shelf light in half the models with WWR of 40% and 50%. The data was organized in spreadsheets, with two intervals of UDI: between 300lux and 2000 lux and between 300lux and 3000lux. The simulation was performed with the weather file of 2009 to the city of NatalRN. The graphical outputs are illuminance curves, isolines of UDI among 300lux and 2000 lux and tables with index of occurrences of glare and to an UDI among 300lux 3000lux. The best UDI300-2000lux performance was evidenced to: Phase 1 (models with WWR of 20%), Phase 2 (models with WWR of 40% and 50% with light shelf). The best UDI300-3000lux performance was evidenced to: Phase 1 (models with WWR of 20% and 40% with light shelf) and Phase 2 (models with WWR of 40% and 50% with light shelf). The outputs prove that the daylight quality mainly depends on the shading system efficacy to avoid the glare occurrence, which determines the daylight discomfort. The bioclimatic recommendations of big openings with partial shading (with an opening with direct sunlight) resulted in illuminances level higher than the acceptable upper threshold. The improvement of the shading system percentage (from 73% to 91%) in medium-size of openings (WWR 40% and 50%) reduced or eliminate the glare occurrence without compromising the daylight zone depth (7.20m). The passive zone was determined for classrooms with satisfactory daylight performance, it was calculated the daylight zone depth rule-of-thumb with the ratio between daylight zone depth and the height of the window for different size of openings. The ratio ranged from 1.54 to 2.57 for WWR of 20%, 40% and 50% respectively. There was a reduction or elimination of glare in the passive area with light shelf, or with awning window shading.
Resumo:
The heavy part of the oil can be used for numerous purposes, e.g. to obtain lubricating oils. In this context, many researchers have been studying alternatives such separation of crude oil components, among which may be mentioned molecular distillation. Molecular distillation is a forced evaporation technique different from other conventional processes in the literature. This process can be classified as a special distillation case under high vacuum with pressures that reach extremely low ranges of the order of 0.1 Pascal. The evaporation and condensation surfaces must have a distance from each other of the magnitude order of mean free path of the evaporated molecules, that is, molecules evaporated easily reach the condenser, because they find a route without obstacles, what is desirable. Thus, the main contribution of this work is the simulation of the falling-film molecular distillation for crude oil mixtures. The crude oil was characterized using UniSim® Design and R430 Aspen HYSYS® V8.5. The results of this characterization were performed in spreadsheets of Microsoft® Excel®, calculations of the physicochemical properties of the waste of an oil sample, i.e., thermodynamic and transport. Based on this estimated properties and boundary conditions suggested by the literature, equations of temperature and concentration profiles were resolved through the implicit finite difference method using the programming language Visual Basic® (VBA) for Excel®. The result of the temperature profile showed consistent with the reproduced by literature, having in their initial values a slight distortion as a result of the nature of the studied oil is lighter than the literature, since the results of the concentration profiles were effective allowing realize that the concentration of the more volatile decreases and of the less volatile increases due to the length of the evaporator. According to the transport phenomena present in the process, the velocity profile tends to increase to a peak and then decreases, and the film thickness decreases, both as a function of the evaporator length. It is concluded that the simulation code in Visual Basic® language (VBA) is a final product of the work that allows application to molecular distillation of petroleum and other similar mixtures.