Informática para Engenharia Ambiental - Unidade 4: Planilhas eletrônicas

Parte 1: Introdução às planilhas eletrônicas Parte 2: O ambiente de trabalho do programa BrOffice.org Calc Parte 3: Primeiros passos Parte 4: Trabalhando com vetores e matrizes Parte 5: Construindo gráficos Parte 6: Resolvendo problemas Parte 07: “Travando” uma célula na planilha

Distribuições hiperbólicas generalizadas: aplicações ao mercado português

O objectivo desta tese é discutir o uso das distribuições hiperbólicas generalizadas como modelo para os retornos logarítmicos de 4 activos do mercado de capitais Português. Os activos em análise são o índice Português PSI 20 e as 3 maiores empresas pertencentes ao PSI 20: PT, EDP e BCP. Os dados são constituidos pelos valores de fecho diário durante mais de 8 anos. Utilizando o software R procederemos à estimação dos parâmetros das distribuições para ajustamento aos dados empíricos. Para medir o grau de ajustamento das distribuições aos dados empíricos usamos os gráficos QQ-plots e 4 distâncias: Kolmogorov-Smirnov, Kuiper, Anderson-Darling e Fajardo-Farias-Ornelas. Os resultados obtidos permitem concluir que o melhor ajustamento é feito pela hiperbólica generalizada e em seguida a distribuição normal inversa gaussiana. Todas as distribuições desta família ajustam-se muito melhor que a distribuição normal. Por último temos uma aplicação ao cálculo do preço de derivados financeiros, nomeadamente a fórmula de uma opção de compra Europeia no modelo discutido.

Sistema de replicação de circuitos integrados digitais baseado em análise comportamental

Nesta dissertação de mestrado é desenvolvido um sistema de replicação de circuitos integrados digitais (combinatórios e sequenciais), por observação do seu normal funcionamento. O sistema desenvolvido carateriza-se pela capacidade de extrair e descrever na linguagem VHDL o comportamento de um circuito integrado digital em funcionamento, utilizando técnicas não invasivas e automatizadas, suportado por um vasto conjunto de algoritmos de aquisição e análise de dados. O sistema desenvolvido assenta em dois módulos principais: um módulo de software que consiste numa plataforma de algoritmos de análise, controlo e gestão do sistema (alojada num computador) e um módulo de aquisição de dados (hardware) que consiste num circuito capaz de realizar as medições necessárias para o funcionamento do sistema, comandado pelo módulo de software. A comunicação entre os dois módulos é efetuada via porta série. Os algoritmos desenvolvidos realizam uma análise da correspondência entre entradas e saídas procurando aplicar uma aproximação a um circuito combinatório se possível, caso contrário são utilizados métodos heurísticos para efetuar uma aproximação a um circuito sequencial através de uma máquina de estados. Entradas ou saídas constantes são previamente identificados e excluídos do processo de análise, para efeitos de simplificação. Os resultados obtidos demonstram que é possível replicar o comportamento observado em circuitos digitais (combinatórios e sequenciais) desde que o número de amostras recolhidas seja adequado. Verifica-se ainda que o método desenvolvido replica a funcionalidade do circuito integrado nas condições onde o circuito está inserido.

Análise da sobre-reação e sub-reação nos ativos de primeira e segunda lina do mercado acionário brasileiro

The Behavioral Finance develop as it is perceived anomalies in these markets efficient. This fields of study can be grouped into three major groups: heuristic bias, tying the shape and inefficient markets. The present study focuses on issues concerning the heuristics of representativeness and anchoring. This study aimed to identify the then under-reaction and over-reaction, as well as the existence of symmetry in the active first and second line of the Brazilian stock market. For this, it will be use the Fuzzy Logic and the indicators that classify groups studied from the Discriminant Analysis. The highest present, indicator in the period studied, was the Liabilities / Equity, demonstrating the importance of the moment to discriminate the assets to be considered "winners" and "losers." Note that in the MLCX biases over-reaction is concentrated in the period of financial crisis, and in the remaining periods of statistically significant biases, are obtained by sub-reactions. The latter would be in times of moderate levels of uncertainty. In the Small Caps the behavioral responses in 2005 and 2007 occur in reverse to those observed in the Mid-Large Cap. Now in times of crisis would have a marked conservatism while near the end of trading on the Bovespa speaker, accompanied by an increase of negotiations, there is an overreaction by investors. The other heuristics in SMLL occurred at the end of the period studied, this being a under-reaction and the other a over-reaction and the second occurring in a period of financial-economic more positive than the first. As regards the under / over-reactivity in both types, there is detected a predominance of either, which probably be different in the context in MLCX without crisis. For the period in which such phenomena occur in a statistically significant to note that, in most cases, such phenomena occur during the periods for MLCX while in SMLL not only biases are less present as there is no concentration of these at any time . Given the above, it is believed that while detecting the presence of bias behavior at certain times, these do not tend to appear to a specific type or heuristics and while there were some indications of a seasonal pattern in Mid- Large Caps, the same behavior does not seem to be repeated in Small Caps. The tests would then suggest that momentary failures in the Efficient Market Hypothesis when tested in semistrong form as stated by Behavioral Finance. This result confirms the theory by stating that not only rationality, but also human irrationality, is limited because it would act rationally in many circumstances

Ecologia reprodutiva do peixe-donzela, Stegastes fuscus cuvier, 1830 (osteichthyes: pomacentridae) em arrecifes rochosos da praia de Búzios, Rio Grande do Norte, Brasil

The reproductive ecology of fish plays a key role both for rational exploitation methods and for protective measures of natural stocks. The purpose of this study was to analyze the reproductive aspects of the damsel-fish, Stegastes fuscus, during October 2004 to September 2005, in the coastal rocky reefs of Búzios Beach, Nísia Floresta, RN. Fish were captured using hooks and hand nets, during low tide. Reproduction was determined using sexual ratio, mean length of first maturation (L50), absolute fecundity and macroscopic characteristics of gonads. The following parameters were related to gonadosomatic index (GSI): condition factor (CF), hepatosomatic index (HSI), rain fall and temperature. In relation to sex distribution, it was observed that 78% were females and 22% were males. The L50 was 6.2 cm for females and 7.0 for males. Average fecundity was 6832 oocytes. Results showed that S. fuscus had better body condition in the months prior to spawning, particularly during initial and intermediate stages of maturation. Five stages of gonadal maturation were identified through macroscopic analysis: immature, in maturation, mature, spent and resting. The HSI was inversely related to the GSI. This was possibly due to the reproductive cycle of this species which was associated to the dry period of this region. During this period, low rain fall and high temperatures provide an propitious reproductive condition for the study species

Efeito do estado nutricional bioquímico de retinol e alfatocoferol sobre seus níveis em lactantes

Vitamins A and E are essential nutrients in many biological processes, so that their adequate supply to the neonate is crucial. However, the bioavailability of vitamins may be limited by factors such as maternal nutritional status and the interaction between nutrients. This study aimed to investigate the effect of biochemical nutritional status of retinol and alpha-tocopherol levels in serum and colostrum. The study included 103 healthy puerperal women treated at the reference state maternity hospital (Natal-RN). Colostrum and serum samples were collected fasting in the immediate postpartum period and the analysis of retinol and alpha-tocopherol were determined by high-performance liquid chromatography. Specific cutoff points were adopted to characterize the biochemical status of vitamins A and E. For the total group of lactanting women the average concentration of retinol in serum (1.49 ± 0.4 μmol/L-1) and colostrum (2.18 ± 0.8 μmol/L-1), as well as alpha-tocopherol in serum (26.4 ± 8.0 μmol/L-1) and colostrum (26.1 ± 12.8 μmol/L-1), indicated adequate biochemical state. However, when evaluating the individual, was found a high prevalence of deficient serum (15%) and colostrum retinol (50%), and also alphatocopherol in serum (16%) and colostrum (61%). In women with serum retinol ≥ 1.05 μmol/L-1, found an inverse correlation between serum retinol and alpha-tocopherol in colostrum (p = 0.008, r = -0.28). This association was not observed in women with serum retinol <1.05 μmol/L-1. This situation demonstrates for the first time in humans that high physiological levels of serum retinol, without supplementation, can negatively influence the transfer of alpha-tocopherol in breast milk. Although the diagnosis of satisfactory nutritional status lactanting women showed high risk of subclinical deficiency of vitamins A and E from measurements made in the colostrum

Estimação e compensação de não linearidades inerentes aos atuadores dos processos industriais

The oscillations presents in control loops can cause damages in petrochemical industry. Canceling, or even preventing such oscillations, would save up to large amount of dollars. Studies have identified that one of the causes of these oscillations are the nonlinearities present on industrial process actuators. This study has the objective to develop a methodology for removal of the harmful effects of nonlinearities. Will be proposed an parameter estimation method to Hammerstein model, whose nonlinearity is represented by dead-zone or backlash. The estimated parameters will be used to construct inverse models of compensation. A simulated level system was used as a test platform. The valve that controls inflow has a nonlinearity. Results and describing function analysis show an improvement on system response

Análise do óxido nítrico, perfil lipídico, resistência arterial e capacidade funcional de idosas submetidas a um treinamento aquático

A prática regular de exercício físico possibilita redução dos efeitos das disfunções hormonais e envelhecimento biológico natural que promovem desajustes hemodinâmicos, vasculares e músculo-esqueléticos, principalmente na população feminina no período pós-menopausa. Nesta fase da vida, o exercício aquático representa mais do que uma forma de ajuste funcional, é uma forma de manutenção de independência para as atividades da vida diária (AVD s) e melhoria na qualidade de vida. Este estudo teve como objetivo avaliar as modificações adquiridas pela prática regular de um programa de exercício aquático concorrente de intensidade moderada no nível de óxido nítrico (ON), no índice de resistividade arterial (IR), no perfil lipídico, na capacidade funcional e na qualidade de vida de idosas. A amostra foi formada por idosas (60 a 80 anos) selecionadas por randomização, por sorteio simples divididas em grupo controle e grupo de intervenção as quais foram submetidas a um programa de exercícios aquáticos proposto inicialmente em projeto piloto, por 12 semanas (n=34) e o ensaio clínico teve duração de 16 semanas (n=40). Foi coletada amostra sanguínea das idosas e avaliado o perfil lipídico pelo método enzimático com kit Labtest e o ON por medida indireta a partir da concentração de nitrito no sobrenadante das células em cultura em leitor de ELISA. A avaliação das artérias carótidas e vertebrais foi feita utilizando o método de ultra-som Doopler. A capacidade funcional foi avaliada por quatro testes que simulam atividades da vida diária que são: caminhar 10 metros (C10m), levantar da posição sentada (LPS), levantar da cadeira e locomover-se pela casa (LCLC) e o de levantar-se da posição decúbito ventral (LPDV). No estudo piloto foi avaliado o índice geral de autonomia funcional (IG) e a qualidade de vida através do questionário WHOQOL-100. Empregou-se a análise de variância (ANOVA) com medidas repetidas nos fatores grupo (GH e GC) e tempo (pré e pós-teste) para as comparações intra e intergrupos nas variáveis seguida do post hoc de Scheffé. Utilizou-se o teste de correlação de Pearson e adotado o valor de p<0,05 para a significância estatística. Houve aumento do ON circulante, redução nos índices de resistividade arterial, melhoria significativa nos níveis de colesterol e triglicérides e ganho na capacidade funcional das idosas após a intervenção. Existiu correlação inversa entre a resistividade da artéria vertebral direita (VERTD) e níveis de ON e entre a VERTD e os níveis plasmáticos de HDL, assim como entre estes e o teste C10m nas idosas em estudo. Não houve modificações significativas na qualidade de vida das idosas. Em conclusão, o programa de exercício proposto foi capaz de oferecer melhorias funcionais, aumentar o nível de óxido nítrico circulante, diminuindo a resistência arterial promovendo modificações no perfil lipídico de idosas

Medidas de parâmetros morfológicos e funcionais do Coração em brasileiros: um subestudo do primeiro registro multicêntricos latino-americano em ressonância magnética cardiáca

There is no data about cardiac measurements em Brazilians obtained by CMR. This a muldisciplinary study with the objective of obtaining measurements of the left ventricle (LV) and right ventricle (RV) diastolic diameter (Dd), systolic diameter (Ds), diastolic volume (Dv), systolic volume (Sv), ejection fraction (EF) and myocardial mass in Brazilians. One hundred and seven (54 men and 53 women, mean age of 43.4 ± 13.1 years) asymptomatic individuals without heart disease were submitted to cardiac magnetic resonance (cMR) studies using steady state free precession technique. The means and standard deviations of the parameters of the LV and RV were respectively: LVDD = 4,8 ± 0,5 cm; LVSD = 3,0±0,6 cm; LVDV = 128,4±29,6 ml; LVSV = 45,2±16,6 ml; LVEF = 65,5±6,3%; LV mass = 95,2±30,8.1 g; RVDD = 3,9±1,3 cm; RVSD = 2,5±0,5 cm; RVDV = 126,5±30,7 ml; RVSV = 53.6±18,4 ml; RVEF = 58.3±8,0.0% and RV mass = 26,1±6,1 g. The masses and volumes were significantly higher in men, except for the LVSV. The RV EF was significantly higher in women. There was inverse correlation between RV systolic volume and with age, being more significant in men. This study describes for the first time benchmarks for cardiac measurements obtained by CMR among asymptomatic Brazilians individuals without heart disease and demonstrated differences according to sex and age

Afinal, quantos éramos? Um estudo da mortalidade pretérita na freguesia da gloriosa Sant Anna

Search mortality in the glorious St. Anna Parish, hinterland of Rio Grande do Norte in the time frame 1788-1838 is the main objective of this research. Questions that the research aims to answer are: how many were after? Data parish deaths allow us to study mortality in Town? To conduct the research, first appealed to the population maps of the years 1777, 1810, 1811, 1824, 1844, 1853; censuses of 1872 and 1890. As well, the first two books of burials / deaths of the Parish, the first dating from 1788 to 1811 and the second from 1812 to 1838 and a book of baptism 1803-1806. Among the findings it was realized that, for now, the question of knowing, "After all, how many were?" Still cannot be answered, because during the analysis we noticed a high rate of underreporting, demonstrated through a study of the first infant mortality, in which the records we have was very high, which goes against the pre-transitional period, but with the exercise of inverse projection found the opposite, a population that would have a life expectancy higher. Demonstrating the problem of underreporting. Infant deaths occur mainly with the male children in the first months of the year due to infectious causes, and in the early days and weeks, we raised a hypothesis is that these deaths have as a backdrop the poor condition of the mother leading to poor training child, thus leading to his early death

Rotavírus bovino: fatores de risco, prevalência e caracterização antigênica de amostras em rebanhos leiteiros no estado de São Paulo

Fundação de Amparo à Pesquisa do Estado de São Paulo (FAPESP)

Comparação de alguns modelos matemáticos para ajuste à curva de lactação média de um rebanho da raça Caracu

Conselho Nacional de Desenvolvimento Científico e Tecnológico (CNPq)

Comparação de alguns modelos matemáticos para o ajuste às curvas de lactação individuais de vacas da raça Caracu

Foram ajustadas 7239 curvas de lactação de vacas Caracu, controladas semanalmente entre os anos de 1978 a 1988, pertencentes à Fazenda Chiqueirão, Poços de Caldas, MG. As funções utilizadas foram a linear hiperbólica (FLH), a quadrática logarítmica (FQL), a gama incompleta (FGI) e a polinomial inversa (FPI). Os parâmetros foram estimados por meio de regressões não lineares, usando-se processos iterativos. A verificação da qualidade do ajuste baseou-se no coeficiente de determinação ajustado (R²A), no teste de Durbin-Watson (DW) e nas médias e desvios-padrão estimados para os parâmetros e funções dos parâmetros dos modelos. Para a curva média, os R²A foram superiores a 0,90 para todas as funções. Bons ajustes, baseados nos R²A>0,80 foram obtidos, respectivamente, por 25,2%, 39,1%, 31,1% e 28,4% das lactações ajustadas pelas funções FLH, FQL, FGI e FPI. de acordo com o teste de DW, bons ajustes foram proporcionados para 29,4% das lactações ajustadas pela FLH, 54,9% pela FQL, 34,9% pela FGI e 29,6% pela FPI. Para ambos os critérios, a FQL foi superior às demais funções, indicando grande variação nas formas das curvas de lactação geradas pelos ajustes individuais. Curvas atípicas foram estimadas pelas funções, com picos ocorrendo antes do parto e algumas vezes após o término da lactação. Todas as funções apresentaram problemas quando ajustaram dados individuais.

Estudo das interações polifenol-proteína e das reações de escurecimento não-enzimático para o processamento de cajuína

The cashew, a fruit from Brazilian Northeast is used to produce juice due to its flavor and vitamin C richness. However, its acceptance is limited due to its astringency. Cajuína is a derivate product appreciated by its characteristic flavor, freshness and lack of astringency, due to tannin removal. Cajuína is a light yellow beverage made from clarified cashew juice and sterilized after bottling. It differs from the integral and concentrated juice by the clarification and thermal treatment steps. Many problems such as haze and excessive browning could appear if these steps are not controlled. The objective of this work was divided into two stages with the aim to supply process information in order to obtain a good quality product with uniform characteristics (sensory and nutritional). Polyphenol-protein interaction was studied at the clarification step, which is an empirical process, to provide values on the amount of clarifying solution (gelatin) that must be added to achieve a complete juice clarification. Clarification essays were performed with juice dilutions of 1:2 and 1:10 and the effect of metabissulfite and tannic acid addition was evaluated. It was not possible to establish a clarification point. Metabissulfite did not influenced the clarification process however tannic acid addition displaced the clarification point, showing the difficulty visual monitoring of the process. Thermal treatment of clarified juice was studied at 88, 100, 111 e 121 °C. To evaluate the non-enzymatic browning, vitamin C, 5-hidroximetilfurfural (5-HMF) and sugar variation were correlated with color parameters (reflectance spectra, color difference and CIELAB). Kinetic models were obtained for reflectance spectra, ascorbic acid and 5-HMF. It was observed that 5-HMF introduction followed a first order kinetic rate at the beginning of the thermal treatment and a zero order kinetic at later process stages. An inverse correlation was observed between absorbance at 420 nm and ascorbic acid degradation, which indicates that ascorbic acid might be the principal factor on cajuína non-enzymatic browning. Constant sugar concentration showed that this parameter did not contribute directly to the nonenzymatic browning. Optimization techniques showed showed that to obtain a high vitamin C and a low 5-HMF content, the process must be done at 120 ºC. With the water-bath thermal treatment, the 90 °C temperature promoted a lower ascorbic acid degradation at the expense of a higher 5-HMF level

Funcionalidade dos extratos fenólicos obtidos pelo cultivo semi-sólido de resíduos de abacaxi (Ananas comusus L.) e goiaba (Psidium guajava L.)

Solid substrate cultivation (SSC) has become an efficient alternative towards rational use of agro industrial wastes and production of value-added products, mainly in developing countries. This work presents the production and functional application results of phenolic extracts obtained by solid substrate cultivation of pineapple (Ananas comosus L.) and guava (Psidium guajava L.) residues associated to soy flour and bioprocessed by Rhizopus oligosporus fungus. Two experimental groups were tested: (1) 9g of fruit residue and 1g of soy flour (A9 or G9); (2) 5g of fruit residue and 5g of soy flour (A5 or G5). After SSC, 100ml of distilled water was added to each Erlenmeyer flask containing 10g of bioprocessed material in order to obtain the phenolic extracts. Samples were taken every two days for total phenolic concentration (TPC) and antioxidant capacity evaluation by DPPH test during 12-day cultivation. The 2-day and 10-d ay extracts were selected and concentrated by ebullition until 1/10 of original volume was reached. After that, both non-concentrated and concentrated extracts were evaluated for their antimicrobial activity against Staphylococcus aureus and Salmonella enterica and a-amylase inhibitory capacity. It was observed an inverse relationship between total phenolic concentration (TPC) and antioxidant capacity during the cultivation. Besides that, the concentrated pineapple samples after two days were able to inhibit both pathogens tested, especially S. aureus. Guava concentrated extracts after 2 days showed expressive inhibition against S. enterica, but negative results against S. aureus growth. When it comes to a-amylase inhibition, A9 extracts after 2 days, both concentrated or not, completely inhibited enzyme activity. Similar behavior was observed for G9 samples, but only for concentrated samples. It was shown that concentration by ebullition positively affected the enzymatic inhibition of G9 and A9 samples, but on the other side, decreased antiamylase activity of A5 and G5 samples