139 resultados para Excel spreadsheets
Resumo:
This study evaluated a nonlinear programming excel workbook PPFR (http://www.fmva.unesp.br/ppfr) for determining the optimum nutrient density and maximize margins. Two experiments were conducted with 240 one-day-old female chicks and 240 one-day-old male chicks distributed in 48 pens (10 chicks per pen, 4 replicates) in a completely randomized design. The treatments include the average price history (2009s and 2010s) for broiler increased and decreased by 25% or 50% (5 treatments to nonlinear feed formulation) and 1 linear feed formulation. Body gain, feed intake, feed conversion were measured at 21, 42 and 56 d of age. Chicks had ad libitum access to feed and water in floor pens with wood shavings as litter. The bio-economic Energy Conversion [BEC= (Total energy intake*Feed weighted cost per kg)/ (Weight gain*kg live chicken cost)] was more sensitive for measuring the bio-economic performance for broilers, and especially with better magnitude. This allowed a better assessment of profitability, the rate of growth and not just energy consumption, the production of broilers, by incorporating energy consumption, allowing for more sensitivity to the new index (BEC). The BEC was demonstrated that the principle of nonlinear formulation minimizes losses significantly (P<0.05), especially under unfavorable conditions the price of chicken in the market. Thus, when considering that a diet of energy supply shows up as the most expensive item of a formulation, it should compose necessarily the formula proposed for a bio-economic index. Thus, there is need to evaluate more accurately, not only the ingredients of a ration, but the impact of nutrients on the stability of a solution, mainly due to the energy requirement. This strategy promotes better accuracy for decision making under conditions of uncertainty, to find alternative post-formulation. From the above, both weight gain and feed conversion, as traditional performance indicators, cannot finalize or predict a performance evaluation of an economic system creating increasingly intense and competitive. Thus, the energy concentration of the diet becomes more important definition to feed formulator, by directly impact profit activity by interactions with the density of nutrients. This allowed a better evaluation of profitability, the rate of energy performance for broilers, by incorporating the energy consumption formula, allowing more sensitivity to the new index (BEC). These data show that nonlinear feed formulation is a toll to offer new opportunities for poultry production to improved profitability.
Resumo:
Objective: To compare two forms of scheduling clinical dental care for the oral health teams (OHT) included in the strategy of family health, regarding productive aspects of assistance. Methods: Two OHT worked concurrently, using two methods of clinical care: the parameter recommended by the Ministry of Health Ordinance No. 1101, 2002, which establishes 03 dental visits per hour (c/h) per team, and a Testing model, with 02 c/h, being each method applied for a period of 615 hours. The quantitative data was collected in OHTs’ daily production spreadsheets, covering the following items: the number of dental visits (initial, for maintenance and for emergency procedures), procedures performed, consumption of material and sterilization cycles. Data was compared and statistically analyzed through the BioStat 5.0 by applying the paired t-test (p <0.05). Results: Under the Ministerial method and the Testing model, were performed, respectively, 288 and 365 first dental visits, 921 and 686 return dental visits, 167 and 172 emergency dental attendances, with 469 and 110 fouls, 212 and 327 treatments were finished and 2501 and 3046 dental procedures were realized. Among eleven analyzed consumables, five were consumed in smaller quantities in the Testing model: gloves (9%), anesthesia (38%), anesthetic needle (34%), suture material (24%) and aspirators (11%), while the six remaining items presented similar consumption rates between the two models. Conclusions: The testing model revealed to be more productive and economical.
Resumo:
Coordenação de Aperfeiçoamento de Pessoal de Nível Superior (CAPES)
Resumo:
Coordenação de Aperfeiçoamento de Pessoal de Nível Superior (CAPES)
Resumo:
Coordenação de Aperfeiçoamento de Pessoal de Nível Superior (CAPES)
Resumo:
The study of variability becomes increasingly important nowadays . Studying the behavior of rainfall before external events is of paramount importance. The region of Vale do Paraíba , it is important to study variability , since the region is influenced by the ocean and constant cold fronts that end causing precipitation during most months of the year . This study aims to analyze the variability in rain UGRHI - 2 by analyzing the interference of ENSO events / Southern Oscillation and the Convergence Zone South Atlantic (SACZ) in the amount and distribution of rainfall. The UGRHI helped were created for distribution and control of water in the state of São Paulo , divided watersheds were avoided so that problems such as poor distribution and water shortages in some areas of the state . To study variability , various software , including Excel , Variowin and R statistical package , the subroutine Climatol were used , with the goal of developing isolines showing the spatial distribution of rainfall anomalies in the years studied also the anomaly index was studied rain (IAC) , noting more effectively the years of positive and negative anomaly , with the purpose of studying the temporal variability of rainfall in the study area.
Resumo:
Conselho Nacional de Desenvolvimento Científico e Tecnológico (CNPq)
Resumo:
Technological resources and the media are contributing to socioeconomic development, including the education sector. Application of Digital Learning Objects support learning, serving as a tool for distance learning arrangements and classroom. The quality of design in instructional materials is one factor that implies the motivation of students and support their learning, within this context, the creation of educational interactive multimedia applications should excel the content and good usability, while facilitating user interaction. The aim of this paper was to establish parameters for the creation and management of Digital Learning Objects.
Resumo:
Background: Imbalance in bacterial species composition of the gut microbiota is one of the factors associated with the cause or complication of the symptoms of Crohn's disease (CD). This disequilibrium consists in the reduction of biodiversity, decrease of genus such as Bifidobacterium and elevation of species such as Escherichia coli. Human microbiota varies among subjects of a same population irrespective of their health condition and among individuals living in distinct geographic locations. In animal models, sex related differences could also be observed in gut bacterial species composition under some pathological conditions. Experiments conducted with mice have demonstrated that the manifestation of type 1 diabetes (T1D) could be under the influence of the animal sex and its serum level of testosterone, which in turn could be modulated by a particular gut microbiota. Considering the existence of similar features between T1D and CD, such as strong genetic component and malfunctioning of the immune system, we investigated whether differences could be observed in the gut microbiota dysbiosis of male and female CD patients. Methods: Fifty and 5 gut mucosal biopsies from 25 adult CD patients (11 males and 14 females) and 43 specimens of an equivalent clinical material from 22 control subjects (11 males and 11 females) were screened for bacterial biodiversity by analyzing sequences of 16SrDNA V6 region. A number of 2-3 samples each from distinct gut segments (from ileum to rectum) were taken from each subject. The 16SrDNA sequences were obtained by sequencing PCR amplicons of the corresponding gene in the Ion torrent PGM sequencer. Identification and classification of the bacterial groups followed the Ribosomal Database Project (RDP) website pipeline. The relationships of the bacterial taxa with each of the study parameters was performed by compiling the data in a MS Excel and the level of statistical significance determined by the Chi-square test. Results: A total of 3203 16SrDNA sequences were detected in the 98 biopsies samples, the majority of which matching Proteobacteria, Firmicutes, Bacterioidetes, and Actinobacteria. The percentage of DNA sequences for each of these phyla found in Male control subjects/Male CD patients was 40.5/33, 32.7/32.4, 20.8/24.5, and 4.4/4,4 for Proteobacteria, Firmicutes, Bacterioidetes, and Actinobacteria, respectively. In Female comparisons, these values were 35.6/42, 39.2/26.3, 19.8/23.3, 5.2/7. Both Male and Female CD patients presented higher numbers of sequences of Actinobacteria and Bacterioidetes than those of control subjects of the same gender. Case-control differences for Firmicutes could be observed only in female comparisons and, for Proteobacteria, although case-control differences were observed in both genders, the nature of difference was distinct, since while in CD female patients a higher number of sequences matching this phylum was detected, in males a reduced number was observed, in comparison with controls. The species responsible for the Proteobacteria variation in both gender was Escherichia coli. Conclusions: The data presented above suggest that any analysis of dysbiosis in CD must take in account the patient's gender, an observation particularly relevant for Escherichia coli, whose association with CD has been most intensively investigated and for which the present study shows a reverse quantitative variation regarding the patients' gender.
Resumo:
Studies with organic systems have shown the feasibility and ecological and social sustainability of these agroecosystems, unlike the systems agrochemicals (conventional) production. Some studies have concluded that for the model agrochemical exists less interaction between the flow of internal energy, basically the crop receives all inputs to production with no increase in "energy quality" within the system, while in the organic model of production has increased interaction between different resources in the system. The current economic and ecological crisis, exposed no sustainability of the production pattern of industrialized agriculture developed in a way, showing the dependence of developed countries on imports of agricultural commodities produced in the third world, among there coffee. Given these facts, developed a survey to identify problems in the Alta Paulista region, west of São Paulo State, in relation to coffee production systems. Actually, the fundamental problem, according to the research, farmers in this region, is to choose a viable production system correctly (environmental, social and economic); agrochemical or organic. The objectives of this study were to analyze the yield of production systems and agro-chemical and organic coffee in the period from 2003 to 2007, in 30 producing properties, located in this region, in order to point the production system to produce the highest yield. According to the methodology of CONAB, data collected were recorded on spreadsheets to be used as variables in statistical analysis models and mathematics. We performed a descriptive analysis of productivity data and were used for statistical analysis tests for parametric and nonparametric analysis of variance. The mathematical analyses of the curves were prepared with Origin for Windows 6.0 software, which uses numerical methods to fit the data supplied to a function of variable parameters. Unlike conventional systems of production, the organic system showed greater viability of the production model. Furthermore, with the quantitative modeling proposal, it is possible to perform the evaluation of these types of investments, providing more security to the farmer at the time of decision.
Resumo:
The present study aimed to analyze indicators of energy efficiency and economic production of piglets from family farmers in Paraná. We sought to determine possible differences in energy efficiencies and economic producers who manufactured rations on their property and those who bought rations Cooperative. The sample was obtained by accessibility (six producers who manufactured and six who bought rations) and not probabilistic, and the raw data were transformed into energy and economic units, and processed in electronic spreadsheets. The two production systems of piglets in the nursery phase, family farming, showed negative energy balance, with energy inputs higher than outputs. The two systems of rearing piglets showed no differences in energy efficiency, ie, they were not self-sufficient and needed to import energy sources from other systems. The indicators of economic efficiency of producers who buy rations as those who produce them in their properties were less than unity. Thus, most producers did not generate enough revenue to pay the costs in the short term and lost money.
Resumo:
The collection of prices for basic goods supply is very important for the population, based on the collection and processing of these data the CLI (Cost Living Index) is calculated among others, helping consumers to shop more rationally and with a clearer view of each product impact of each product on their household budget, not only food, but also cleaning products and personal hygiene ones. Nowadays, the project of collection of prices for basic goods supply is conducted weekly in Botucatu - SP through a spreadsheet. The aim of this work was to develop a software which utilized mobile devices in the data collection and storage phase, concerning the basic goods supply in Botucatu -SP. This was created in order to eliminate the need of taking notes in paper spreadsheets, increasing efficiency and accelerating the data processing. This work utilized the world of mobile technology and development tools, through the platform".NET" - Compact Framework and programming language Visual Basic".NET" was used in the handheld phase, enabling to develop a system using techniques of object oriented programming, with higher speed and reliability in the codes writing. A HP Pavilion dv3 personal computer and an Eten glofish x500+ handheld computer were used. At the end of the software development, collection, data storing and processing in a report, the phase of in loco paper spreadsheets were eliminated and it was possible to verify that the whole process was faster, more consistent, safer, more efficient and the data were more available.
Resumo:
Coordenação de Aperfeiçoamento de Pessoal de Nível Superior (CAPES)
Resumo:
This study aims to develop a computer program based on VBA programming language, using Microsoft Excel, for designing pumping systems of water. The program allows the user to determine the economical diameter, using the equation of Bresse, for a given installation, since the geometric elevation, the material of the tube, the accessories along the line and the volumetric flow are known. In addition, the program estimates the total annual cost of the installation for three different diameters, in order to compare which diameter is more advantageous from an economical perspective. The program interface is designed to be simple and intuitive with the intention of being didactic and offering to engineering students an advantageous tool to analyze this type of project. Microsoft Excel was chosen for this work because is present in virtually all personal computer, and is an indispensable tool for educational purposes
Resumo:
Stricter environmental policies are shown necessary to ensure an effective pollutant emission control. It is expected for the present year of 2015, that Brazil will assume, at the 21th United Nation's Climate Change Conference (COP21), implementation of commitment to a low carbon economy. This positioning affects the industrial environment, so that is deemed necessary to search for new technologies, less aggressive to the environment, so the adequacies to the new emission policies do not cause a negative effect on production. Almost all of the processes performed in the steel industry demand burning fuel and, therefore, flue gases are sent to the atmosphere. In this present work is discussed the utilization of heat exchangers so, by recovering part of the available heat from the flue gases of certain industrial process, the combustion air is preheated. The combustion air preheat results in less energy requirement, i.e., less need of fuel consumption and, in addition, minor amount of pollutants to be emitted. Due to better fitting to the process, it is studied the utilization of spiral plate heat exchangers. The heat exchanger dimensioning is made by an iterative method implemented in the software Microsoft Excel. Subsequently are analyzed the gains in terms of process's thermal efficiency improvement and the percentage of fuel saving. The latter implies in reduction of the same percentage of greenhouse gases emission