On-Line Analytical Processing of Inventory Turnover

Operatiivisen tiedon tuottaminen loppukäyttäjille analyyttistä tarkastelua silmällä pitäen aiheuttaa ongelmia useille yrityksille. Diplomityö pyrkii ratkaisemaan ko. ongelman Teleste Oyj:ssä. Työ on jaettu kolmeen pääkappaleeseen. Kappale 2 selkiyttää On-Line Analytical Processing (OLAP)- käsitteen. Kappale 3 esittelee muutamia OLAP-tuotteiden valmistajia ja heidän arkkitehtuurejaan sekä tyypillisten sovellusalueiden lisäksi huomioon otettavia asioita OLAP käyttöönoton yhteydessä. Kappale 4, tuo esille varsinaisen ratkaisun. Teknisellä arkkitehtuurilla on merkittävä asema ratkaisun rakenteen kannalta. Tässä on sovellettu Microsoft:n tietovarasto kehysrakennetta. Kappaleen 4 edetessä, tapahtumakäsittelytieto muutetaan informaatioksi ja edelleen loppukäyttäjien tiedoksi. Loppukäyttäjät varustetaan tehokkaalla ja tosiaikaisella analysointityökalulla moniulotteisessa ympäristössä. Vaikka kiertonopeus otetaan työssä sovellusesimerkiksi, työ ei pyri löytämään optimaalista tasoa Telesten varastoille. Siitä huolimatta eräitä parannusehdotuksia mainitaan.

On-line –jatkojalostuksen integrointi mäntysahan tuotantoprosessiin

Diplomityön tavoitteena oli selvittää erilaisia jatkojalostusmahdollisuuksia, joilla voidaan nostaa suuren mäntysahan tuotteiston arvoa. Lisäksi tuli tarkastella jalostuksen integrointia sahan tuotantoprosessiin. Työn taustalla on toisaalta puutuotemarkkinoiden muuttuminen ja toisaalta raaka-aineen laadullinen huononeminen. Molemmat seikat vaikuttavat negatiivisesti perinteisen mäntysahan kannattavuuteen .Jatkojalostuksen integroinnilla sahatavaraprosessiin saavutetaan säästöjä tuotantokustannuksissa, kun tarkastellaan koko prosessia tukista jatkojalosteeksi. Myös raaka-aineen tuottavuutta voidaan nostaa integraation avulla. Jatkojalostus voidaan integroida sahatavaraprosessiin raaka-aineen valikoinnilla sahatavaraprosessin eri osissa, on-line –jalostuksella sekä taloudellisesti. Sahatavaraprosessissa tapahtuva raaka-aineen valikointi voidaan suorittaa tukeista ja sahatavarasta. Valikointikriteerinä voi olla puun ominaisuudet, sahatavaran mitat ja laatu. Valikointiin voidaan nykyteknologiasta hyödyntää röntgentekniikkaa sekä konenäköä. On-line –jalostus tarkoittaa kiinteästi sahatavaraprosessiin liittyvää jalostusta, jolloin ns. turhia prosessivaiheita jää pois ja syntyy säästöjä. On-line –jalostuksen edellytys on raaka-aineen jonkin asteinen valikointi, esim. pituus. Taloudellisesti integroitu jalostus tarkoittaa, että jalostuslaitoksella pyritään nollatulokseen ja jalostuksen lisäarvo palautetaan sahan toimittamaan raaka-aineen hintaan. Tällainen toiminta yhtiön sisällä poistaa turhaa keskustelua raaka-aineen siirtohinnoista ja siten vapauttaa osaltaan resursseja tuottavampaan toimintaan. Erilaisten jatkojalostusmuotojen ja puun ominaisuuksien hyödyntämisen seulonnan perusteella löytyi yksi jalostusmuoto, jolla voidaan kohottaa mäntysahan tuotteiston arvoa. Työn tuloksena syntyi investointiehdotus aihiotankotuotannosta ikkunateollisuuden tarpeisiin. Raaka-aineen hyödynnettäviä ominaisuuksia ovat männyn sydänpuun luonnollinen kestävyys sekä keskimääräinen oksaväli. Valikointi tehdään välitukeista, joiden sahaamisen kannattavuus on männyn rungon osista heikoin. Aihiotankoprosessissa hyödynnetään konenäköä ja sormijatkostekniikkaa. Jatkojalostuksen integrointi sahatavaraprosessiin toteutetaan rakentamalla on-line –jalostuslaitos sekä soveltamalla röntgentekniikkaa raaka-aineen valinnassa.

On-line determination of residual collector concentration in flotation process

Valuable minerals can be recovered by using froth flotation. This is a widely used separation technique in mineral processing. In a flotation cell hydrophobic particles attach on air bubbles dispersed in the slurry and rise on the top of the cell. Valuable particles are made hydrophobic by adding collector chemicals in the slurry. With the help of a frother reagent a stable froth forms on the top of the cell and the froth with valuable minerals, i.e. the concentrate, can be removed for further processing. Normally the collector is dosed on the basis of the feed rate of the flotation circuit and the head grade of the valuable metal. However, also the mineral composition of the ore affects the consumption of the collector, i.e. how much is adsorbed on the mineral surfaces. Therefore it is worth monitoring the residual collector concentration in the flotation tailings. Excess usage of collector causes unnecessary costs and may even disturb the process. In the literature part of the Master’s thesis the basics of flotation process and collector chemicals are introduced. Capillary electrophoresis (CE), an analytical technique suitable for detecting collector chemicals, is also reviewed. In the experimental part of the thesis the development of an on-line CE method for monitoring the concentration of collector chemicals in a flotation process and the results of a measurement campaign are presented. It was possible to determine the quality and quantity of collector chemicals in nickel flotation tailings at a concentrator plant with the developed on-line CE method. Sodium ethyl xanthate and sodium isopropyl xanthate residuals were found in the tailings and slight correlation between the measured concentrations and the dosage amounts could be seen.

Uuteaineiden on-line-mittaus koivusulfaattisellutehtaalla

Tämän työn tarkoituksena oli tutkia pihkanhallintaa sulfaattisellutehtaalla ja uuteaineiden analysointimenetelmiä massasta ja suodoksesta. Tavoitteena oli kehittää uuteaineiden on-line mittausmenetelmä sulfaattisellutehtaalle. Kirjallisuusosassa esitettiin sulfaattisellun valmistusprosessi ja uuteaineiden käyttäytyminen prosessissa. Lisäksi työssä käsiteltiin tärkeimpiä pihkanhallintamenetelmiä ja uuteaineiden analysointia. Kokeellisessa osassa määritettiin uuteainepitoisuudet 29:stä massa- ja pesusuodosnäytteestä. Lisäksi suodosnäytteiden sameus ja kemiallinen hapenkulutus määritettiin laboratoriossa. On-line mittaukset tehtiin DD-pesurin paluusuodoksesta, josta mitattiin johtokyky, lämpötila, taitekerroin ja pH. Sameutta yritettiin mitata on-line nefelometrillä, mutta käytössä ollut laite ei soveltunut tumman suodoksen mittaamiseen. Työssä saatujen tulosten perusteella voidaan todeta, että pesusuodoksen ominaisuuksia mittaamalla ei voida arvioida massan uutepitoisuutta luotettavasti. Suodoksen ja massan uutepitoisuuksien välinen selitysaste oli 54%. Saippuoitumattomien uuteaineiden pitoisuuden ollessa erityisen suuri, suodoksen uutepitoisuus ei korreloi massassa olevan uutteen määrän kanssa. Täten kyseinen mittausmenetelmä ei ole sopiva, sillä se ei toimi silloin, kun olisi tärkeintä tietää oikea uuteainepitoisuus pihkanhallintakemikaalien annosten määrittämiseksi. Suodoksen sameus riippui sen uutepitoisuudesta 80% selitysasteella. Sameusmittaus on nopea ja suhteellisen luotettava menetelmä suodosten uutepitoisuuksien arviointiin, mutta se vaatii mittalaitteen joka käyttää usean ilmaisimen tekniikkaa. On-line-mittauksissa laitteisto tulisi varustaa automaattisella pesulaitteella, sillä mittarin linssit likaantuvat helposti prosessivirrassa.

Direct-on-line axial flux permanent magnet synchronous generator static and dynamic performance

In distributed energy production, permanent magnet synchronous generators (PMSG) are often connected to the grid via frequency converters, such as voltage source line converters. The price of the converter may constitute a large part of the costs of a generating set. Some of the permanent magnet synchronous generators with converters and traditional separately excited synchronous generators couldbe replaced by direct-on-line (DOL) non-controlled PMSGs. Small directly networkconnected generators are likely to have large markets in the area of distributed electric energy generation. Typical prime movers could be windmills, watermills and internal combustion engines. DOL PMSGs could also be applied in island networks, such as ships and oil platforms. Also various back-up power generating systems could be carried out with DOL PMSGs. The benefits would be a lower priceof the generating set and the robustness and easy use of the system. The performance of DOL PMSGs is analyzed. The electricity distribution companies have regulations that constrain the design of the generators being connected to the grid. The general guidelines and recommendations are applied in the analysis. By analyzing the results produced by the simulation model for the permanent magnet machine, the guidelines for efficient damper winding parameters for DOL PMSGs are presented. The simulation model is used to simulate grid connections and load transients. The damper winding parameters are calculated by the finite element method (FEM) and determined from experimental measurements. Three-dimensional finite element analysis (3D FEA) is carried out. The results from the simulation model and 3D FEA are compared with practical measurements from two prototype axial flux permanent magnet generators provided with damper windings. The dimensioning of the damper winding parameters is case specific. The damper winding should be dimensioned based on the moment of inertia of the generating set. It is shown that the damper winding has optimal values to reach synchronous operation in the shortest period of time after transient operation. With optimal dimensioning, interferenceon the grid is minimized.

Applicability of Power-Line Communications to Data Transfer of On-line Condition Monitoring of Electrical Drives

The research of power-line communications has been concentrated on home automation, broadband indoor communications and broadband data transfer in a low voltage distribution network between home andtransformer station. There has not been carried out much research work that is focused on the high frequency characteristics of industrial low voltage distribution networks. The industrial low voltage distribution network may be utilised as a communication channel to data transfer required by the on-line condition monitoring of electric motors. The advantage of using power-line data transfer is that it does not require the installing of new cables. In the first part of this work, the characteristics of industrial low voltage distribution network components and the pilot distribution network are measured and modelled with respect topower-line communications frequencies up to 30 MHz. The distributed inductances, capacitances and attenuation of MCMK type low voltage power cables are measured in the frequency band 100 kHz - 30 MHz and an attenuation formula for the cables is formed based on the measurements. The input impedances of electric motors (15-250 kW) are measured using several signal couplings and measurement based input impedance model for electric motor with a slotted stator is formed. The model is designed for the frequency band 10 kHz - 30 MHz. Next, the effect of DC (direct current) voltage link inverter on power line data transfer is briefly analysed. Finally, a pilot distribution network is formed and signal attenuation in communication channels in the pilot environment is measured. The results are compared with the simulations that are carried out utilising the developed models and measured parameters for cables and motors. In the second part of this work, a narrowband power-line data transfer system is developed for the data transfer ofon-line condition monitoring of electric motors. It is developed using standardintegrated circuits. The system is tested in the pilot environment and the applicability of the system for the data transfer required by the on-line condition monitoring of electric motors is analysed.

Techno-Economic Feasibility of Novel On-Line Condition Monitoring Methods in Low Voltage Distribution Networks

The focus in this thesis is to study both technical and economical possibilities of novel on-line condition monitoring techniques in underground low voltage distribution cable networks. This thesis consists of literature study about fault progression mechanisms in modern low voltage cables, laboratory measurements to determine the base and restrictions of novel on-line condition monitoring methods, and economic evaluation, based on fault statistics and information gathered from Finnish distribution system operators. This thesis is closely related to master’s thesis “Channel Estimation and On-line Diagnosis of LV Distribution Cabling”, which focuses more on the actual condition monitoring methods and signal theory behind them.

Data management as a part of performance management: Case study about production reporting development project

Because of the increased availability of different kind of business intelligence technologies and tools it can be easy to fall in illusion that new technologies will automatically solve the problems of data management and reporting of the company. The management is not only about management of technology but also the management of processes and people. This thesis is focusing more into traditional data management and performance management of production processes which both can be seen as a requirement for long lasting development. Also some of the operative BI solutions are considered in the ideal state of reporting system. The objectives of this study are to examine what requirements effective performance management of production processes have for data management and reporting of the company and to see how they are effecting on the efficiency of it. The research is executed as a theoretical literary research about the subjects and as a qualitative case study about reporting development project of Finnsugar Ltd. The case study is examined through theoretical frameworks and by the active participant observation. To get a better picture about the ideal state of reporting system simple investment calculations are performed. According to the results of the research, requirements for effective performance management of production processes are automation in the collection of data, integration of operative databases, usage of efficient data management technologies like ETL (Extract, Transform, Load) processes, data warehouse (DW) and Online Analytical Processing (OLAP) and efficient management of processes, data and roles.

The consequences of e-HRM on line managers

The purpose of this research was to provide a deeper insight into the consequences of electronic human resource management (e-HRM) for line managers. The consequences are viewed as used information system (IS) potentials pertaining to the moderate voluntaristic category of consequences. Due to the need to contextualize the research and draw on line managers’ personal experiences, a qualitative approach in a case study setting was selected. The empirical part of the research is loosely based on literature on HRM and e-HRM and it was conducted in an industrial private sector company. In this thesis, method triangulation was utilized, as nine semi-structured interviews, conducted in a European setting, created the main method for data collection and analysis. Other complementary data such as HRM documentation and statistics of e-HRM system usage were utilized as background information to help to put the results into context. E-HRM has partly been taken into use in the case study company. Line managers tend to use e-HRM when a particular task requires it, but they are not familiar with all the features and possibilities which e-HRM has to offer. The advantages of e-HRM are in line with the company’s goals. The advantages are e.g. an transparency of data, process consistency, and having an efficient and easy-to-use tool at one’s disposal. However, several unintended, even contradictory, and mainly negative outcomes can also be identified, such as over-complicated processes, in-security in use of the tool, and the lack of co-operation with HR professionals. The use of e-HRM and managers’ perceptions regarding e-HRM affect the way in which managers perceive the consequences of e-HRM on their work. Overall, the consequences of e-HRM are divergent, even contradictory. The managers who considered e-HRM mostly beneficial to their work found that e-HRM affects their work by providing information and increasing efficiency. Those managers who mostly perceived challenges in e-HRM did not think that e-HRM had affected their role or their work. Even though the perceptions regarding e-HRM and its consequences might reflect the strategies, the distribution of work, and the ways of working in all HRM in general and can’t be generalized as such, this research contributed to the field of e-HRM and it provides new perspectives to e-HRM in the case study organization and in the academic field in general.

Biopolttoaineiden on-line -laadunmittauksen hyödyt energiantuotannossa

Biopolttoaineet ovat tärkeä energianlähde suomalaisessa energiantuotannossa. Biopoltto- aineille on kuitenkin ominaista laadun vaihtelevuus. Yksi tärkeimmistä laatutekijöistä on kosteus, joka vaikuttaa myös polttoaineen energiasisältöön. Laatutekijät puolestaan vai- kuttavat polttoainekäsittelyyn, polttoprosessiin ja koko laitoksen hyötysuhteeseen. Tämän työn tarkoituksena oli tutkia voisiko biopolttoaineiden online-laadunmittaus tuoda lisäarvoa energiantuotantolaitokselle. Esimerkkinä käytettiin yhtä online-laadunmittaus- sovellusta, InrayFuel-röntgenmittausjärjestelmää. Sillä voidaan seurata biopolttoaineiden kosteutta ja polttoaineen sisältämiä vierasaineita. Työssä on laadittu kustannusanalyysi, jolla pyritään selvittämään, onko nykyisen kertaluontoisen mittausmenetelmän korvaami- nen jatkuvatoimisella kannattavaa. Esimerkkilaitoksena on Etelä-Savon Energian Pur- sialan voimalaitos, jossa röntgenmittausjärjestelmään on testattu. Saatujen tulosten mukaan investoiminen esimerkkimittausjärjestelmään maksaisi itsensä takaisin alle vuodessa. Kun laitoksella pystytään seuraamaan polttoaineen laatua jatkuva- toimisesti, laadunhallinta paranee ja sitä kautta voidaan saavuttaa kustannussäästöjä. Polt- toaineesta johtuvat häiriötilanteet vähenevät, polttoaine on mahdollista optimoida edulli- semmaksi polton kannalta ja poltto-olosuhteita voidaan säätää paremmin, jolloin päästöt vähenevät ja hyötysuhde kasvaa. Työssä käytetty laskenta analysoi kuitenkin hyvin ylei- sellä tasolla, sillä käytössä ei ollut laitoksen omaa taselaskentajärjestelmää. Laskenta siis sisältää paljon oletuksia. Tämän ja rohkaisevien tulosten vuoksi tutkimusta jatkuvatoimi- sen laadunmittauksen hyödyistä kannattaa tehdä enemmän.

Customer knowledge processing in maintenance business: case study

The purpose of the study is to examine and increase knowledge on customer knowledge processing in B2B context from sales perspective. Further objectives include identifying possible inhibiting and enabling factors in each phase of the process. The theoretical framework is based on customer knowledge management literature. The study is a qualitative study, in which the research method utilized is a case study. The empirical part was implemented in a case company by conducting in-depth interviews with the company’s value-selling champions located internationally. Context was maintenance business. Altogether 17 interviews were conducted. The empirical findings indicate that customer knowledge processing has not been clearly defined within the maintenance business line. Main inhibiting factors in acquiring customer knowledge are lack of time and vast amount of customer knowledge received. Enabling factors recognized are good customer relationships and sales representatives’ communication skills. Internal dissemination of knowledge is mainly inhibited by lack of time and restrictions in customer relationship management systems. Enabling factors are composition of the sales team and updated customer knowledge. Inhibiting utilization is lack of goals to utilize the customer knowledge and a low quality of the knowledge. Moreover, customer knowledge is not systematically updated nor analysed. Management of customer knowledge is based on the CRM system. As implications of the study, it is suggested for the case company to define customer knowledge processing in order to support maintenance business process.

On the Condition Monitoring of Induction machines

The research of condition monitoring of electric motors has been wide for several decades. The research and development at universities and in industry has provided means for the predictive condition monitoring. Many different devices and systems are developed and are widely used in industry, transportation and in civil engineering. In addition, many methods are developed and reported in scientific arenas in order to improve existing methods for the automatic analysis of faults. The methods, however, are not widely used as a part of condition monitoring systems. The main reasons are, firstly, that many methods are presented in scientific papers but their performance in different conditions is not evaluated, secondly, the methods include parameters that are so case specific that the implementation of a systemusing such methods would be far from straightforward. In this thesis, some of these methods are evaluated theoretically and tested with simulations and with a drive in a laboratory. A new automatic analysis method for the bearing fault detection is introduced. In the first part of this work the generation of the bearing fault originating signal is explained and its influence into the stator current is concerned with qualitative and quantitative estimation. The verification of the feasibility of the stator current measurement as a bearing fault indicatoris experimentally tested with the running 15 kW induction motor. The second part of this work concentrates on the bearing fault analysis using the vibration measurement signal. The performance of the micromachined silicon accelerometer chip in conjunction with the envelope spectrum analysis of the cyclic bearing faultis experimentally tested. Furthermore, different methods for the creation of feature extractors for the bearing fault classification are researched and an automatic fault classifier using multivariate statistical discrimination and fuzzy logic is introduced. It is often important that the on-line condition monitoring system is integrated with the industrial communications infrastructure. Two types of a sensor solutions are tested in the thesis: the first one is a sensor withcalculation capacity for example for the production of the envelope spectra; the other one can collect the measurement data in memory and another device can read the data via field bus. The data communications requirements highly depend onthe type of the sensor solution selected. If the data is already analysed in the sensor the data communications are needed only for the results but in the other case, all measurement data need to be transferred. The complexity of the classification method can be great if the data is analysed at the management level computer, but if the analysis is made in sensor itself, the analyses must be simple due to the restricted calculation and memory capacity.

Towards desired crystalline product properties: In-situ monitoring of batch crystallization

The objective of industrial crystallization is to obtain a crystalline product which has the desired crystal size distribution, mean crystal size, crystal shape, purity, polymorphic and pseudopolymorphic form. Effective control of the product quality requires an understanding of the thermodynamics of the crystallizing system and the effects of operation parameters on the crystalline product properties. Therefore, obtaining reliable in-line information about crystal properties and supersaturation, which is the driving force of crystallization, would be very advantageous. Advanced techniques, such asRaman spectroscopy, attenuated total reflection Fourier transform infrared (ATR FTIR) spectroscopy, and in-line imaging techniques, offer great potential for obtaining reliable information during crystallization, and thus giving a better understanding of the fundamental mechanisms (nucleation and crystal growth) involved. In the present work, the relative stability of anhydrate and dihydrate carbamazepine in mixed solvents containing water and ethanol were investigated. The kinetics of the solvent mediated phase transformation of the anhydrate to hydrate in the mixed solvents was studied using an in-line Raman immersion probe. The effects of the operation parameters in terms of solvent composition, temperature and the use of certain additives on the phase transformation kineticswere explored. Comparison of the off-line measured solute concentration and the solid-phase composition measured by in-line Raman spectroscopy allowedthe identification of the fundamental processes during the phase transformation. The effects of thermodynamic and kinetic factors on the anhydrate/hydrate phase of carbamazepine crystals during cooling crystallization were also investigated. The effect of certain additives on the batch cooling crystallization of potassium dihydrogen phosphate (KDP) wasinvestigated. The crystal growth rate of a certain crystal face was determined from images taken with an in-line video microscope. An in-line image processing method was developed to characterize the size and shape of thecrystals. An ATR FTIR and a laser reflection particle size analyzer were used to study the effects of cooling modes and seeding parameters onthe final crystal size distribution of an organic compound C15. Based on the obtained results, an operation condition was proposed which gives improved product property in terms of increased mean crystal size and narrowersize distribution.