Sustav automatskog generiranja izvještaja za brodove za prijevoz soka

master's thesis

• Title (english): Automatic report generation for juice transport ships
• Author: Marija Rozić
• Mentor: Igor Erceg (mentor)
• Committee member: Igor Erceg (predsjednik povjerenstva)
• Committee member: Damir Sumina (član povjerenstva)
• Committee member: Martina Kutija (član povjerenstva)
• Granter: University of Zagreb; Faculty of Electrical Engineering and Computing; Zagreb
• Defense date and country: 2024-07-03, Croatia

Abstract

U radu je potrebno dati analizu tehnološkog procesa prijevoza soka od naranče brodom, s naglaskom na upravljanje tankovima za skladištenje koncentriranog soka od naranče, Frozen Concentrate Orange Juice (FCOJ). Potrebno je dati tehnički opis upravljanja FCOJ-i tankovima, definirati način prikupljanja podataka o dnevnom statusu tankova (pritisak, temperatura, količina i drugo). Potrebno je izraditi program za prikupljanje relevantnih podataka u programirljivom logičkom kontroleru. Nadalje, u SQL bazi podataka potrebno je izraditi proceduru za prikupljanje podataka o dnevnom statusu tankova te strukturirati tablicu za dohvat podataka iz programirljivog logičkog kontrolera. Kao završni korak potrebno je izraditi izvještaj dohvaćanjem ranije pripremljenih podataka iz baze podataka koristeći MS Excel. Razvijene algoritme upravljanja potrebno je validirati na simulacijskom modelu.

Abstract (english)

Through this work, a complete analysis of the technological process of transporting orange juice by ship will be provided. The focus will be on managing the storage tanks for concentrated orange juice, known as Frozen Concentrate Orange Juice (FCOJ). The first step will be providing a technical description of the process, followed by defining a method for collecting daily statuses of the storage tanks, such as pressure, temperature, volume, etc. from programmable logic controller (PLC). Secondly, an SQL stored procedure will be created to collect and format data into a table that is easily manageable. The final step is to develop an automated report using MS Excel VBA, which will generate reports based on the previously defined stored procedures. The algorithm will then be validated using a simulation model of a ship.

• Keywords: SQL baza podataka; automatska izrada izvještaja; dohvat podataka iz PLC-a; MS Excel VBA; proces prijevoz soka od naranče brodom
• Keywords (english): SQL database; automatic report generation; data retrieval from PLC; MS Excel VBA; process of transporting orange juice by ship
• Language: croatian
• URN:NBN: urn:nbn:hr:168:443361
• Study programme: Title: Electrical Engineering and Information Technology; Study programme type: university; Study level: graduate; Academic / professional title: magistar/magistra inženjer/inženjerka elektrotehnike i informacijske tehnologije (magistar/magistra inženjer/inženjerka elektrotehnike i informacijske tehnologije)
• Type of resource: Text
• File origin: Born digital
• Access conditions: Closed access
• Created on: 2024-10-12 22:01:37