Data collection analysis and management system
Racasag-Jaatinen, Mercy (2011)
Racasag-Jaatinen, Mercy
Vaasan ammattikorkeakoulu
2011
All rights reserved
Julkaisun pysyvä osoite on
https://urn.fi/URN:NBN:fi:amk-2011062012341
https://urn.fi/URN:NBN:fi:amk-2011062012341
Tiivistelmä
Wärtsilä Power Plant Technology Fuel Laboratory is the place where the PPT team tests their samples of different fuel types such as Heavy Fuel Oil, Light Fuel Oil, Crude Oil, Straight Bio Fuel Oil among others. These samples are measured to define their characteristics and properties using different devices.
Data Collection Analysis and Management System were developed to collect and analyse measured data from the laboratory devices. Every device has own database in MS Excel format and Visual basic for application (VBA) is the programming language used to develop this project. Main functions consist of searching and importing files. Import function can import data from same excel file format (.xls), text format (.txt), comma separated variable (.csv) or portable document format (.pdf).
Main Search File was done after the application for the entire device was ready. This last file is used for searching the seven database files. Results display the list of all properties of the sample from different devices into one worksheet. Laboratorian can compare how the samples properties change depending on the time interval or see how one samples properties within different device. This makes it easier for them to see if the sample has a very high or very low value in specific properties that may cause/had caused problem to specific power plants.
The main target of this project is the fuel laboratory team but this project is saved in IDM so that can be accessed by everyone inside the company using a LAN connection or VPN connection.
Data Collection Analysis and Management System were developed to collect and analyse measured data from the laboratory devices. Every device has own database in MS Excel format and Visual basic for application (VBA) is the programming language used to develop this project. Main functions consist of searching and importing files. Import function can import data from same excel file format (.xls), text format (.txt), comma separated variable (.csv) or portable document format (.pdf).
Main Search File was done after the application for the entire device was ready. This last file is used for searching the seven database files. Results display the list of all properties of the sample from different devices into one worksheet. Laboratorian can compare how the samples properties change depending on the time interval or see how one samples properties within different device. This makes it easier for them to see if the sample has a very high or very low value in specific properties that may cause/had caused problem to specific power plants.
The main target of this project is the fuel laboratory team but this project is saved in IDM so that can be accessed by everyone inside the company using a LAN connection or VPN connection.