Aplicació de gestió web per a la Fundació CIM

Mantenir la informació ordenada i accessible és essencial per qualsevol empresa avui en dia. Es desenvoluparà una aplicació en base web que serveixi per integrar la informació de l’empresa “Fundació CIM” respecte als clients, factures i ofertes (pressupostos). A més, el software permetrà també la creació i el manteniment de factures i albarans d’una manera ràpida i intuïtiva, millorant així el mètode actual basat en fulls de Microsoft Excel i Microsoft Access. S’establiran diferents rangs de permisos als diferents usuaris segons els seus rols.

Construcción y explotación de un almacén de datos de información cinematográfica

Este proyecto tiene como finalidad el diseño, el desarrollo y la puesta en marcha de un almacén de datos destinado, tanto al almacenamiento de la información que nuestro cliente la Academia de Cine Andorrana dispone de los diferentes premios de los Festivales cinematográficos más importantes, como al análisis y la explotación de los datos. El proyecto parte del conjunto de documentos en formato Microsoft Excel que la Academia de Cine Andorrana utiliza como repositorio de información cinematográfica, los cuales tras un proceso de análisis y diseño darán lugar a modelo conceptual, lógico y físico de un cubo multidimensional de procesamiento Analítico Relacional o ROLAP en esquema de copo de nieve. Así mismo, el proyecto incluye el diseño y desarrollo de los procesos necesarios de extracción, transformación y carga (ETL) de las fuentes operacionales de información, previamente exportadas a formato CSV, sobre la base de datos multidimensional. Por último, el proyecto contempla la construcción de un área de negocio que sirve como base y entorno de trabajo para el desarrollo de los informes de extracción y explotación de los datos requeridos por la Academia de Cine Andorrana.

CODAPACK3D. A new version of Compositional Data Package

The statistical analysis of compositional data should be treated using logratios of parts,which are difficult to use correctly in standard statistical packages. For this reason afreeware package, named CoDaPack was created. This software implements most of thebasic statistical methods suitable for compositional data.In this paper we describe the new version of the package that now is calledCoDaPack3D. It is developed in Visual Basic for applications (associated with Excel©),Visual Basic and Open GL, and it is oriented towards users with a minimum knowledgeof computers with the aim at being simple and easy to use.This new version includes new graphical output in 2D and 3D. These outputs could bezoomed and, in 3D, rotated. Also a customization menu is included and outputs couldbe saved in jpeg format. Also this new version includes an interactive help and alldialog windows have been improved in order to facilitate its use.To use CoDaPack one has to access Excel© and introduce the data in a standardspreadsheet. These should be organized as a matrix where Excel© rows correspond tothe observations and columns to the parts. The user executes macros that returnnumerical or graphical results. There are two kinds of numerical results: new variablesand descriptive statistics, and both appear on the same sheet. Graphical output appearsin independent windows. In the present version there are 8 menus, with a total of 38submenus which, after some dialogue, directly call the corresponding macro. Thedialogues ask the user to input variables and further parameters needed, as well aswhere to put these results. The web site http://ima.udg.es/CoDaPack contains thisfreeware package and only Microsoft Excel© under Microsoft Windows© is required torun the software.Kew words: Compositional data Analysis, Software

O Educador Físico e os valores que norteiam a actividade física nos Ginásios/Academias

Este estudo teve como objectivo averiguar, analisar e dar a conhecer a importância do educador físico frente aos valores que norteiam a actividade física no treino de musculação nos ginásios/academias da cidade da Praia. Contou com a ajuda de 100 voluntários praticantes activos de musculação de ambos os sexos, que responderam o Questionário de Análise da Influência/Importância do Educador Físico nos Ginásios/Academias, (QAI). Os dados numéricos foram analisados e tratados no Software informático SPSS versão 11,5 e Microsoft Excel versão 2003. Nos tópicos “Discussão e Conclusão dos resultados” demonstraram que existe uma necessidade urgente de Educador Físico - profissional formado, nos ginásios/academias da cidade da Praia e realçam de maneira geral essa importância. Esta constatação é fundamentada pela pesquisa de campo, onde 99% dos inquiridos enfatizam esse problema (essa necessidade) de haver Educador Físico nos ginásios/academias que frequentam. Espera-se ser este trabalho mais uma contribuição didática para os profissionais que actuam directamente na área de musculação.

Opportunistic screening actions for breast cancer performed by nurses working in primary health care

Abstract OBJECTIVE To identify opportunistic screening actions for breast cancer performed by nurses working in primary health care units in Ribeirão Preto, São Paulo. METHOD Cross-sectional study with 60 nurses from 28 units, who had been working for at least one year in the public municipal health care network. Data were collected between December 2013 and March 2014, by means of a questionnaire, using descriptive analysis and the software IBM SPSS version 20 and Microsoft Excel 2010. RESULTS The results showed that 71.7% of the participants questioned their female patients as for risk factors for breast cancer, mainly during nursing consultation; 70.0% oriented users about the age to perform clinical breast exam, whereas 30.0% did not due to lack of knowledge and time; 60.0% explained about the age to perform mammogram; 73.3% did not refer patients with suspicious breast exam results to the referral department, citing scheduling as the main obstacle to referral. Educational activities were not performed by 78.3% of participants. CONCLUSION Investment is needed in professional training and management of breast cancer screening.

Lean IT Application of 5S/6S Technique in a SME

O Lean não é apenas uma prática. É uma revolução nas Tecnologias de Informação (TI) proporcionando uma maior e melhor utilização dos recursos e procurando alcançar custos mais baixos dos que existem atualmente. É muito mais do que uma lista de ferramentas e metodologias e para que seja estabelecido é necessário mudar comportamentos culturais e incentivar todas as organizações a pensarem de forma diferente sobre o poder da informação versus o valor do negócio. Normalmente associa-se o Lean à criação de valor para a organização. Mas o valor é significativo quando é trazido com eficiência e resultando na eliminação de processos que consomem tempo, recursos e espaço desnecessário. Os princípios Lean podem ajudar as organizações na melhoria da qualidade, redução de custos e no alcance da eficiência através de uma melhor produtividade. Existem vários conceitos Lean que podem ser associados a diferentes objetivos de resolução de problemas. Em particular, este trabalho é uma dissertação programada para analisar um novo paradigma sobre o Lean que surgiu recentemente - Lean para Tecnologias de Informação (Lean IT). Esta dissertação apresenta uma abordagem para o Lean IT (enquadramento, objetivos e metodologia) para realizar o trabalho e utiliza um único estudo de caso, com abordagem à técnica 5S/6S (até o terceiro nível de avaliação), numa Pequena, Média Empresa (PME), de forma a demonstrar a agregação de valor e as vantagens na eliminação de resíduos/desperdícios nos seus processos. A técnica também mostra a evolução da avaliação antes e depois da sua aplicação. Este estudo de caso individual avalia um Departamento de TI (com uma equipe de cinco colaboradores e um chefe de Departamento) através da observação direta, documentação e arquivos de registos e os equipamentos analisados são computadores, postos de trabalho e projetos (código desenvolvido, portais e outros serviços de TI). x Como guia, a metodologia inclui a preparação da avaliação em conjunto com o responsável/chefe do Departamento de TI, o desenrolar das operações, a identificação do fluxo de valor para cada atividade, o desenvolvimento de um plano de comunicação e a análise de cada passo da avaliação do fluxo de processamento. Os principais resultados estão refletidos nas novas ferramentas de trabalho (Microsoft SharePoint e Microsoft Project em detrimento do Microsoft Excel) que fornecem comunicação remota e controlo de projetos para todos os stakeholders, tais como, a gestão de topo, parceiros e clientes (algumas organizações incluem o Outsourcing no desenvolvimento de funcionalidades específicas). Os resultados também refletem-se na qualidade do trabalho, no cumprimento de prazos, na segurança física e lógica, na motivação dos colaboradores e na satisfação dos clientes. A técnica 5S/6S ajuda a esclarecer os conceitos e princípios Lean, exequibilidade e aumenta a curiosidade sobre a implementação da técnica noutros departamentos tais como o Financeiro e ou o de Recursos Humanos. Como forma de consolidação do trabalho tornou-se possível organizar a avaliação para que a organização possa candidatar-se a uma certificação na norma ISO/IEC 25010:2011, no modelo de qualidade de software (software é o core business desta PME). Mas tal só será possível se toda a organização atingir a padronização dos seus processos. Este estudo de caso mostra que os conceitos Lean e a aplicação de uma ou mais das suas técnicas (neste caso particular a técnica 5S/6S) ajuda a obter melhores resultados através da gestão e melhoria dos seus principais serviços.

Service Quality Analysis in the Five Stars Resort Hotels of Cape Verde

The objective of this study was the identification of the attributes and dimensions of service quality affecting the service performance of the five stars resort hotels located in the Cape Verde Islands. The reason boosting the initiative to do this research was the paramount role of the resort hotels in the development of the travel and tourism sector in Cape Verde, and the impact that today this sector has had in the economy of that country. The research opens with a literature review on the service quality theory in the hotel industry, starting from the middle of the 1980s with the classic model of service quality and SERVQUAL instrument to the analysis of recent models of service quality measurement in the hotel industry, as it is an example the scale of items developed in 2003 in the Lodging Quality Index (LQI). Furthermore, the study elaborates an analysis on the importance of the travel and tourism activities in the Cape Verde Islands, and it evidences the enormous importance of those activities in the performance of the Cape Verdean hotel industry. In sequence the study analyzes in details the hotel industry of Cape Verde and it identifies the market size of the five stars resort hotels and their current operators in that market. Moreover, the research develops with an online questionnaire elaborated and sent through the platforms of travel websites and communities to the guests whom have experienced the service of the five stars resort hotels located in the Cape Verde Islands. The scope of the questionnaire was to assess the attributes and dimensions of service quality in the five stars resort hotels of Cape Verde. The results of the questionnaire were in sequence analyzed through descriptive and applied statistics, using Microsoft Excel and the Statistical Package for Social Science (SPSS). Content validity analysis, factor analysis, and reliability analysis of the factors were made to purify an initial scale of 47 items of service quality. An instrument with three dimensions covering twenty four attributes of service quality assessment in the five stars resort hotels of Cape Verde was finally created. The three dimensions found were: staff competence; food and entertainment; and physical facilities. This study on the service in the five stars resort hotels of Cape Verde ends with brief comments on the status of service quality according to the identified dimensions and their attributes. In the conclusion, the study summarizes the whole work and gives some directions for future research.

Control de 6 respiròmetres i anàlisi de les dades

L’aplicació de tècniques respiromètriques és de recent innovació dins l’estudi dels tractaments d’aigües residuals. Aquest conjunt de tècniques ens permeten analitzar dos processos importants dins una planta de tractament biològic: el creixement de la biomassa i el consum del substrat. Això fa que siguin una eina amb gran potencial en l’avaluació dels sistemes de tractament biològic d’aigües residuals. L’objectiu principal d’aquest treball es la realització d’una aplicació capaç de controlar el funcionament de 6 respiròmetres, gestionant el procés del mostreig de les respirometries i l’anàlisi de les dades obtingudes, per obtenir el substrat ràpidament biodegradable (Ss) per a mostres d’aigua residual, i la taxa màxima de creixement específic per a mostres de compost. L’aplicació s’ha desenvolupat sobre l’entorn Microsoft Access, on s’integren la base de dades amb les mostres i els resultats de les respirometries, i els formularis de control que ens permeten gestionar i controlar els processos de mostreig i anàlisi. L’aplicació es comunica amb els sensors i actuadors dels respiròmetres a través del control ActiveX, ADS-OCX, subministrat per TwinCAT, que ens permet capturar les lectures dels sensors i controlar el funcionament dels actuadors. Aquests elements estan connectats a mòduls descentralitzats d’entrades i sortides, comunicats mitjançant el bus Ethernet amb el PC-Industrial, on s’executa l’aplicació. Un cop finalitzada l’aplicació, aquesta controla correctament el mostreig de les respirometries, registrant les lectures de les sondes a la base de dades i controlant l’activació de les vàlvules del respiròmetre. Partint de les mostres obtingudes, o de respirometries externes, importades des de Microsoft Excel, s’ha comprovat el correcte funcionament en el càlcul del substrat ràpidament biodegradable (Ss) i la taxa màxima de creixement específic. Amb l’aplicació desenvolupada, s’ha comprovat el funcionament i les possibilitats que ens ofereix TwinCAT alhora de controlar mòduls d’entrades i sortides, així com la seva comunicació amb aplicacions com Microsoft Access. Això pot afavorir a la utilització d’aquest tipus de tecnologia, per aplicacions futures.

Broadening the horizon--level 2.5 of the HUPO-PSI format for molecular interactions.

BACKGROUND: Molecular interaction Information is a key resource in modern biomedical research. Publicly available data have previously been provided in a broad array of diverse formats, making access to this very difficult. The publication and wide implementation of the Human Proteome Organisation Proteomics Standards Initiative Molecular Interactions (HUPO PSI-MI) format in 2004 was a major step towards the establishment of a single, unified format by which molecular interactions should be presented, but focused purely on protein-protein interactions. RESULTS: The HUPO-PSI has further developed the PSI-MI XML schema to enable the description of interactions between a wider range of molecular types, for example nucleic acids, chemical entities, and molecular complexes. Extensive details about each supported molecular interaction can now be captured, including the biological role of each molecule within that interaction, detailed description of interacting domains, and the kinetic parameters of the interaction. The format is supported by data management and analysis tools and has been adopted by major interaction data providers. Additionally, a simpler, tab-delimited format MITAB2.5 has been developed for the benefit of users who require only minimal information in an easy to access configuration. CONCLUSION: The PSI-MI XML2.5 and MITAB2.5 formats have been jointly developed by interaction data producers and providers from both the academic and commercial sector, and are already widely implemented and well supported by an active development community. PSI-MI XML2.5 enables the description of highly detailed molecular interaction data and facilitates data exchange between databases and users without loss of information. MITAB2.5 is a simpler format appropriate for fast Perl parsing or loading into Microsoft Excel.

Development of Railroad Highway Grade Crossing Consolidation Rating Formula, 2015

The goal of this project was to provide an objective methodology to support public agencies and railroads in making decisions related to consolidation of at-grade rail-highway crossings. The project team developed a weighted-index method and accompanying Microsoft Excel spreadsheet based tool to help evaluate and prioritize all public highway-rail grade crossings systematically from a possible consolidation impact perspective. Factors identified by stakeholders as critical were traffic volume, heavy-truck traffic volume, proximity to emergency medical services, proximity to schools, road system, and out-of-distance travel. Given the inherent differences between urban and rural locations, factors were considered, and weighted, differently, based on crossing location. Application of a weighted-index method allowed for all factors of interest to be included and for these factors to be ranked independently, as well as weighted according to stakeholder priorities, to create a single index. If priorities change, this approach also allows for factors and weights to be adjusted. The prioritization generated by this approach may be used to convey the need and opportunity for crossing consolidation to decision makers and stakeholders. It may also be used to quickly investigate the feasibility of a possible consolidation. Independently computed crossing risk and relative impact of consolidation may be integrated and compared to develop the most appropriate treatment strategies or alternatives for a highway-rail grade crossing. A crossing with limited- or low-consolidation impact but a high safety risk may be a prime candidate for consolidation. Similarly, a crossing with potentially high-consolidation impact as well as high risk may be an excellent candidate for crossing improvements or grade separation. The results of the highway-rail grade crossing prioritization represent a consistent and quantitative, yet preliminary, assessment. The results may serve as the foundation for more rigorous or detailed analysis and feasibility studies. Other pertinent site-specific factors, such as safety, maintenance costs, economic impacts, and location-specific access and characteristics should be considered.

Optimisation of data analysis method for a fluidized bed combustion test rig

Nowadays the used fuel variety in power boilers is widening and new boiler constructions and running models have to be developed. This research and development is done in small pilot plants where more faster analyse about the boiler mass and heat balance is needed to be able to find and do the right decisions already during the test run. The barrier on determining boiler balance during test runs is the long process of chemical analyses of collected input and outputmatter samples. The present work is concentrating on finding a way to determinethe boiler balance without chemical analyses and optimise the test rig to get the best possible accuracy for heat and mass balance of the boiler. The purpose of this work was to create an automatic boiler balance calculation method for 4 MW CFB/BFB pilot boiler of Kvaerner Pulping Oy located in Messukylä in Tampere. The calculation was created in the data management computer of pilot plants automation system. The calculation is made in Microsoft Excel environment, which gives a good base and functions for handling large databases and calculations without any delicate programming. The automation system in pilot plant was reconstructed und updated by Metso Automation Oy during year 2001 and the new system MetsoDNA has good data management properties, which is necessary for big calculations as boiler balance calculation. Two possible methods for calculating boiler balance during test run were found. Either the fuel flow is determined, which is usedto calculate the boiler's mass balance, or the unburned carbon loss is estimated and the mass balance of the boiler is calculated on the basis of boiler's heat balance. Both of the methods have their own weaknesses, so they were constructed parallel in the calculation and the decision of the used method was left to user. User also needs to define the used fuels and some solid mass flowsthat aren't measured automatically by the automation system. With sensitivity analysis was found that the most essential values for accurate boiler balance determination are flue gas oxygen content, the boiler's measured heat output and lower heating value of the fuel. The theoretical part of this work concentrates in the error management of these measurements and analyses and on measurement accuracy and boiler balance calculation in theory. The empirical part of this work concentrates on the creation of the balance calculation for the boiler in issue and on describing the work environment.

Lämmöntalteenotto kosteasta poistoilmasta prosessiteollisuudessa

Tämän diplomityön päämääränä on tehdä prosessiteollisuuden tarpeisiin Excel-taulukkolaskentaohjelmassa toimiva putkilämmönsiirtimen mitoitusohjelma. Prosessiteollisuudessa lämmönvaihtimien toimintaympäristöt ja olosuhteet vaihtelevat merkittävästi ja niinpä jokaisen vaihtimen suunnittelu ja mitoitus on toteutettava tapauskohtaisesti. Työssä käsitellään rekuperatiivisen ristivirtaputkilämmönvaihtimen yleinen lämpötekninen mitoitus sisältäen putken sisäpinnalle tapahtuvan mahdollisen lauhtumisen. Mitoitettava vaihdinkoostuu pystysuorista putkista, joissa lämmin ja kostea ilma virtaa putkien sisäpuolella ja kylmä kuiva ilma vaippapuolella vaakasuoraan. Vaihdinmateriaalina käytetään ruostumatonta AISI 304 -tai haponkestävää AISI 316 terästä. Kuuman ilman tila vaihtelee tarkasteltavan kohteen mukaan. Paperiteollisuuden kuivausyksiköiltä poistuva ilma on usein lämmintä ja kosteaa, ja infrakuivaimilta poistuva ilma on kuumaa. Mitoitettavalle lämmönvaihtimelle tulevan kuuman ilman lämpötila tapauksesta riippuen voi vaihdella 30°C, maksimissaan +300°C:een saakka, vesisisällön ollessa välillä 0,010...0,200 kg/kg ki tai jopa tämän ylikin. Vaihtimen mitoitus perustuu energiataseyhtälöiden käyttöön. Laskennassa määritetään vaihtimen pintalämpötila sekä mahdollinen kostean ilman lauhtuminen putken sisäpinnalle. Lisäksi teoria käsittää molempien virtausten tilanmuutosten laskennan. Työssä on esitetty esimerkkilaskelma, jossa on laskettu ilma- kostea ilma lämmönsiirrinkonstruktio. Esimerkissä on tarkasteltu vaihtimen hyötysuhdetta, virtausten lämpö- ja kosteuskäyttäytymistä ulkoilman lämpötilan funktiona. Ohjelmasta saadaan tulostettua mitoitettavanvaihtimen dimensiot; putkien lukumäärät syvyys- ja pituussuunnassa sekä kokonaisputkilukumäärä, putkien väliset etäisyydet toisiinsa nähden sekä syvyys, että pituussuunnassa, putkipituus ja putken sisä- ja ulkohalkaisijat. Nämä tiedot suunnittelija itse syöttää ohjelmalle alkuarvoina. Laskettuna tietona ohjelma antaa molempien virtausten poistolämpötilat, kuuman ilman poistuvan absoluuttisen kosteuden, kondenssivesimäärän, vaihtimen tehon ja painehäviöt vaippa- ja putkipuolelle. Lisäksi ohjelma laskee kuuman ilman ominaisentalpiat vaihtimen sisään- ja ulostulossa. Tämä mahdollistaa ilman tilapisteiden piirtämisen Mollier-piirrokseen.

Sähkön omatuotannon kannattavuustarkastelu

Tässä diplomityössä tutkitaan sähkön omatuotannon kannattavuutta M-realin Simpeleen tehtaiden voimalaitoksella. Erityisesti työssä arvioidaan lauhdesähköntuotannon kannattavuutta polttoaine- ja päästökustannuksista muodostuvien marginaalikustannusten osalta. Koska voimalaitoksen rakennusaste on varsin alhainen,sähköntuotannon kannattavuutta on tarkasteltu arvioimalla sähkön ja lämmön yhteistuotannon kustannuksia ja jakamalla syntyneet kustannukset suhdemenetelmän avulla eri tuotteille. Diplomityössä etsitään kustannustehokkain seospolttosuhde annettujen reunaehtojen puitteissa muodostamalla polttoaineista aiheutuvista kustannuksista laskentamalli, jota optimoidaan Microsoft Excelin Solver-toiminnolla. Lauhdesähköntuotannon marginaalikustannuksia verrataan Nord Poolin SPOT-tuntihintaan. Lauhdesähköntuotanto voimalaitoksella on kannattavaa, mikäli SPOT-tuntihinnan vuorokautinen keskiarvo ylittää lauhdesähköntuotannon marginaalikustannukset.

Putkilämmönsiirtimien mitoitustyökalujen kehittäminen

Diplomityön tarkoituksena on kehittää tietokoneohjelma putkilämmönsiirtimen vaippapuolen painehäviön laskemiseksi. Ohjelmalla voidaan varmistaa lämmönsiirtimen mitoitusvaiheessa, että vaippapuolen painehäviö ei ylitä sallittuja rajoja. Ohjelmatäydentää olemassa olevia mitoitusohjelmia. Tässä diplomityössä käsitellään ainoastaan höyryvoimalaitosprosesseissa käytettäviä putkilämmönsiirtimiä. Työn kirjallisessa osassa on selvitetty periaate höyryvoimalaitosprosessista ja siinä käytettävistä putkilämmönsiirtimistä sekä esitetty putkilämmönsiirtimien rakenne, yleinen suunnittelu ja lämpö- ja virtaustekninen mitoitus. Painehäviön laskennassa käytetyt ja lämpö- ja virtausteknistä mitoitusta käsittelevässä kappaleessa esitetyt yhtälöt perustuvat Bell-Delawaren menetelmään. Painehäviönlaskentaohjelma on toteutettu hyväksikäyttäen Microsoft Excel taulukkolaskentaa ja Visual Basic -ohjelmointikieltä. Painehäviön laskenta perustuu segmenttivälilevyillä varustetun putkilämmönsiirtimen vaippapuolen yksifaasivirtaukseen. Lämmönsiirtimen lauhdutinosan painehäviö oletetaan merkityksettömäksi, joten kokonaispainehäviö muodostuu höyryn- ja lauhteenjäähdyttimessä. Kehitetty ohjelma on suunniteltu erityisesti lauhteenjäähdyttimessä muodostuvan painehäviön laskentaan. Ohjelmalla laskettuja painehäviön arvoja on verrattu todellisesta lämmönsiirtimestä mitattuihin arvoihin. Lasketut arvotvastaavat hyvin mittaamalla saatuja, eikä tuloksissa ilmene mitään systemaattista virhettä. Ohjelma on valmis käytettäväksi putkilämmönsiirtimien mitoitustyökaluna. Diplomityön pohjalta on tehty ehdotukset ohjelman edelleen kehittämiseksi.

Arvonmääritysmallin kehittäminen sijoittajan näkökulmasta: Case F-secure

Työn tavoitteena on kehittää Microsoft Excel -taulukkolaskentaohjelmaan pohjautuva arvonmääritysmalli. Mallin avulla osaketutkimusta tekevät analyytikot ja sijoittajat voivat määrittää osakkeen fundamenttiarvon. Malli kehitetään erityisesti piensijoittajien työkaluksi. Työn toisena tavoitteena on soveltaa kehitettyä arvonmääritysmallia case-yrityksenä toimivan F-Securen arvonmäärityksessä ja selvittää mallin avulla onko F-Securen osake pörssissä fundamentteihin nähden oikein hinnoiteltu. Työn teoriaosassa esitellään arvonmäärityksen käyttökohteet ja historia, arvonmääritysprosessin vaiheet (strateginen analyysi, tilinpäätösanalyysi, tulevaisuuden ennakointi, yrityksen arvon laskeminen), pääoman kustannuksen määrittäminen ja sijoittajan eri arvonmääritysmenetelmät, joita ovat diskontattuun kassavirtaan perustuvassa arvonmäärityksessä käytettävät mallit sekä suhteellisen arvonmäärityksentunnusluvut. Empiirinen osa käsittää arvonmääritysmallin kehittämisen ja rakenteen kuvauksen sekä F-Securen arvonmääritysprosessin. Vaikka F-Securen tulevaisuus näyttää varsin valoisalta, osake on hinnoiteltu markkinoilla tällä hetkellä(23.02.2006) korkeammalle kuin näihin odotuksiin nähden olisi järkevää. Eri menetelmät antavat osakkeelle arvoja 2,25 euron ja 2,97 euron väliltä. Kehitetty Excel -malli määrittää F-Securen osakkeen tavoitehinnaksi eri menetelmien mediaanina 2,29 euroa. Tutkimuksen tuloksena F-Securen osaketta voidaan pitää yliarvostettuna, sillä sen hinta pörssissä on 3,05 euroa.