999 resultados para MS-Excel
Resumo:
Background: Health care literature supports the development of accessible interventions that integrate behavioral economics, wearable devices, principles of evidence-based behavior change, and community support. However, there are limited real-world examples of large scale, population-based, member-driven reward platforms. Subsequently, a paucity of outcome data exists and health economic effects remain largely theoretical. To complicate matters, an emerging area of research is defining the role of Superusers, the small percentage of unusually engaged digital health participants who may influence other members. Objective: The objective of this preliminary study is to analyze descriptive data from GOODcoins, a self-guided, free-to-consumer engagement and rewards platform incentivizing walking, running and cycling. Registered members accessed the GOODcoins platform through PCs, tablets or mobile devices, and had the opportunity to sync wearables to track activity. Following registration, members were encouraged to join gamified group challenges and compare their progress with that of others. As members met challenge targets, they were rewarded with GOODcoins, which could be redeemed for planet- or people-friendly products. Methods: Outcome data were obtained from the GOODcoins custom SQL database. The reporting period was December 1, 2014 to May 1, 2015. Descriptive self-report data were analyzed using MySQL and MS Excel. Results: The study period includes data from 1298 users who were connected to an exercise tracking device. Females consisted of 52.6% (n=683) of the study population, 33.7% (n=438) were between the ages of 20-29, and 24.8% (n=322) were between the ages of 30-39. 77.5% (n=1006) of connected and active members met daily-recommended physical activity guidelines of 30 minutes, with a total daily average activity of 107 minutes (95% CI 90, 124). Of all connected and active users, 96.1% (n=1248) listed walking as their primary activity. For members who exchanged GOODcoins, the mean balance was 4,000 (95% CI 3850, 4150) at time of redemption, and 50.4% (n=61) of exchanges were for fitness or outdoor products, while 4.1% (n=5) were for food-related items. Participants were most likely to complete challenges when rewards were between 201-300 GOODcoins. Conclusions: The purpose of this study is to form a baseline for future research. Overall, results indicate that challenges and incentives may be effective for connected and active members, and may play a role in achieving daily-recommended activity guidelines. Registrants were typically younger, walking was the primary activity, and rewards were mainly exchanged for fitness or outdoor products. Remaining to be determined is whether members were already physically active at time of registration and are representative of healthy adherers, or were previously inactive and were incentivized to change their behavior. As challenges are gamified, there is an opportunity to investigate the role of superusers and healthy adherers, impacts on behavioral norms, and how cooperative games and incentives can be leveraged across stratified populations. Study limitations and future research agendas are discussed.
Resumo:
The work presented in this thesis concerns the dimensioning of an Energy Storage System (ESS) which will be used as an energy buffer for a grid-connected PV plant. This ESS should help managing the PV plant to inject electricity into the grid according to the requirements of the grid System Operator. It is desired to obtain a final production not below 1300kWh/kWp with a maximum ESS budget of 0.9€/Wp. The PV plant will be sited in Martinique Island and connected to the main grid. This grid is a small one where the perturbations due clouds in the PV generation are not negligible anymore. A software simulation tool, incorporating a model for the PV-plant production, the ESS and the required injection pattern of electricity into the grid has been developed in MS Excel. This tool has been used to optimize the relevant parameters defining the ESS so that the feed-in of electricity into the grid can be controlled to fulfill the conditions given by the System Operator. The inputs used for this simulation tool are, besides the conditions given by the System Operator on the allowed injection pattern, the production data from a similar PV-plant in a close-by location, and variables for defining the ESS. The PV production data used is from a site with similar climate and weather conditions as for the site on the Martinique Island and hence gives information on the short term insolation variations as well as expected annual electricity production. The ESS capacity and the injected electric energy will be the main figures to compare while doing an economic study of the whole plant. Hence, the Net Present Value, Benefit to Cost method and Pay-back period studies are carried on as dependent of the ESS capacity. The conclusion of this work is that it is possible to obtain the requested injection pattern by using an ESS. The design of the ESS can be made within an acceptable budget. The capacity of ESS to link with the PV system depends on the priorities of the final output characteristics, and it also depends on which economic parameter that is chosen as a priority.
Resumo:
Este trabalho tem por objetivo apresentar a fundamentação teórica e efetuar uma aplicação prática de uma das mais importantes descobertas no campo das finanças: o modelo de precificação de ativos de capital padrão, denominado de Capital Asset Price Model (CAPM). Na realização da aplicação prática, comparou-se a performance entre os retornos dos investimentos exigidos pelo referido modelo e os realmente obtidos. Foram analisadas cinco ações com a maior participação relativa na carteira teórica do Ibovespa e com retornos publicados de junho de 1998 a maio de 2001. Os dados foram obtidos da Economática da UFRGS e testados utilizando-se o Teste-t (duas amostras em par para médias) na ferramenta MS Excel. Os resultados foram tabelados e analisados, de onde se concluiu que, estatisticamente, com índice de confiança de 95%, não houve diferença de performance entre os retornos esperados e os realmente obtidos dos ativos objeto desta dissertação, no período estudado.
Resumo:
O entendimento da manufatura celular passa pelo estudo das rotas de fabricação e pelos métodos de agrupamento de máquinas e de peças. Neste contexto, o objetivo principal deste trabalho é a implemetação de uma ferramenta de auxílio ao projeto de células de manufatura, abordando uma metodologia fundamentada na Tecnologia de Grupo para agrupamento de máquinas em células de manufatura com as respectivas famílias de peças. A base de dados com as informações das peças, das máquinas e das rotas que compõe o fluxo de produção é implementada em um banco de dados relacional. A matriz incidência peça-máquina é montada a partir das rotas armazenadas no banco de dados através de um aplicativo desenvolvido em Visual Basic. Os agrupamentos em famílias de peças e células de manufatura são gerados por três diferentes algoritmos: o Rank Order Clustering (ROC), o Close Neighbor Algorithm (CNA) e um algoritmo heurístico (HEU). São aplicadas restrições referentes a limite de carregamento, tamanho de célula e resolução de situações de “gargalo”. Processados os algoritmos de agrupamento, são analisados os resultados em função da densidade e da eficiência do agrupamento. O sistema apresenta o resultado final em planilhas no formato MS Excel. A primeira planilha, chamada resultados, exibe os valores das restrições de projeto das células (número de máquinas por célula, tempo limite de carregamento e tempo limite para duplicação da máquina), o número de peças (colunas) e de máquinas (linhas) da matriz incidência, os valores de eficiência do agrupamento de peças, do agrupamento de máquinas e do aproveitamento dos recursos, bem como o número de células independentes e a quantidade de máquinas duplicadas, obtidos por cada algoritmo no sistema, destacando os melhores resultados. A segunda planilha mostra a matriz incidência peça-máquina. As demais planilhas apresentam, respectivamente, a matriz diagonalizada com o algoritmo original (ROC e CNA), a matriz diagonalizada levando-se em consideração as restrições de projeto das células (análise ROC, análise CNA e HEU) e por fim, uma planilha relatório. A planilha relatório tabula os mesmos valores citados na primeira planilha e lista as peças associadas a cada família, as máquinas associadas a cada célula, as peças rejeitadas, por não se enquadrarem nos agrupamentos, e que devem ser tratadas fora do ambiente celular e as máquinas duplicadas. A comparação dos resultados é efetuada considerando as características adicionadas aos algoritmos originais. Dos três estudados, as restrições de projeto são tratadas na implementação do HEU. Os demais, ROC e CNA, têm incorporado um pós processamento. Em análises comparativas observa-se a superioridade dos algoritmos ROC e HEU em relação ao CNA e os resultados do ROC são melhores ou iguais aos demais, dificilmente inferiores.
Resumo:
Hoje em dia onde o mercado da construção civil é cada vez mais competitivo e as empresas de construção civil tendem em apresentar orçamentos com os custos cada vez mais inferiores, diminuindo as margens de lucro por forma a garantir trabalho para alimentar a sua massa. Deste modo, é fulcral apostar em ferramentas ou em métodos que apoiem a equipa de direcção de obra de forma a garantir as margens previstas antes do início dos trabalhos. É neste contexto que este trabalho foi desenvolvido, garantindo uma aplicação informática numa folha de cálculo MS Excel e com recurso ao programa de planeamento MS Project, que aplica um método de controlo de custos de uma forma simples e funcional sem grandes encargos de aquisição de softwares ou de formação específica.
Resumo:
The simulation of SES-Natal Ponta Negra: mitigation of environmental risks and predictive maintenance strategy was developed in the context of several operational irregularities in the pumping stations and sewage systems in the system Ponta Negra. Thus, the environmental risks and complaints against the company due to overflows of sewage into the public thoroughfare became common. This neighborhood has shown in recent years an increase of resident higher than the initial expectation of growth. In this sense presumed the large population growth and generation of sewers higher than expected, associated to the use of corrective maintenance and misuse of the system may be the main causes of operational failures occurring in the SES. This study aimed at analyzing the hydraulic behavior of SES Ponta Negrathrough numerical simulation of its operation associated to future scenarios of occupation. The SES Ponta Negra has a long lengthof collection networks and 6 pumping stations interconnected, being EE 1, 2, 4 coastal way, and beach Shopping interconnected EE3 to receives all sewers pumped from the rest pumping station and pumped to the sewage treatment station of neighborhood which consists of a facultative pond followed by three maturation ponds with disposal of treated effluent into infiltration ditches. Oncethey are connected with each other, the study was conducted considering the days and times of higher inflow for all lifts. Furthermore, with the aim of measuring the gatherer network failures were conducted data survey of on the networks. Thephysical and operational survey data was conducted between January/2011 and janeiro/2012. The simulation of the SES was developed with the aim ofdemonstrating its functioning, eithercurrently and in the coming years, based in population estimates and sewage flow. The collected data represents the current framework of the pumping stations of the SES Ponta Negra and served as input to the model developed in MS Excel ® spreadsheet which allowed simulating the behavior of SES in future scenarios. The results of this study show thatBeach Shopping Pumping Station is actually undersized and presents serious functioning problemsthatmay compromise the environmental quality of surrounding area. The other pumping stations of the system will reach itsmaximum capacity between 2013 and 2015, although the EE1 and EE3 demonstrateoperation capacity, even precariously, until 2017. Moreover, it was observed that the misuse of the network system, due to the input of both garbage and stormwater, are major factors of failures that occur in the SES. Finally, it was found that the corrective maintenance appliance, rather than predictive,has proven to beinefficient because of the serious failuresin the system, causing damage to the environment and health risks to users
Resumo:
O jogo de empresas Mercado Virtual foi desenvolvido para mediar o processo ensino-aprendizagem na área de tomada decisão e gestão de empresas e tem um banco de dados que armazena as decisões dos alunos. Os dados nele armazenados foram analisados em relação ao balanceamento de capacidade, objetivo de lucro e uso de recursos financeiros da empresa e foram encontradas incoerências entre os conteúdos pertinentes ao modelo e as decisões dos alunos. Elas foram classificadas como lacunas de aprendizado. Com o objetivo de analisar se as mesmas se repetem entre alunos do Programa de Mestrado Engenharia de Produção da UNESP de Bauru e Mestrado Integrado em Engenharia Industrial e Gestão da Uminho de Guimarães, Portugal, foram realizados dois experimentos, um em cada grupo. Para realizá-los utilizou-se o jogo Mercado Virtual e uma planilha de dimensionamento da empresa nos dois locais. A Sala de Estudos, os indicadores e o questionário de pesquisa da opinião foram utilizados somente em Portugal. Os resultados mostraram que o jogo é capaz de evidenciar as diferenças de domínio de conteúdo nos dois grupos e, também, que estas diferenças estão associadas aos projetos dos cursos. Sendo uma pesquisa exploratória, os experimentos foram realizados considerando-se somente os controles do jogo. Por isso, propõe-se a realização de pesquisas adicionais combinando controle sobre algumas das variáveis relacionadas do uso do jogo e atuação sobre aprendizagem dos alunos na forma de entrevistas e pesquisas não estruturadas. Conforme previsto, a pesquisa mostrou que os jogos podem ser utilizados com objetivos de aprendizagem mais amplos, considerando-se a avaliação indireta e cruzada sobre as decisões tomadas pelos alunos, como é o caso dos indicadores. Outra contribuição importante da pesquisa refere-se ao uso de jogos de empresas sob condições pouco controladas, ou seja, não houve...
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:
Modulo 2. NAM SEC riempita don i dati dei conti nazionali
Resumo:
Modulo 2. Esempio di modello input output di complemento ai lucidi sulle TIO