| | SLO | ENG | Cookies and privacy

Bigger font | Smaller font

Show document Help

Title:PROGRAMIRANJE V EXCELU VBA IN UPORABA V KEMIJSKI TEHNIKI
Authors:ID Koprivc, Špela (Author)
ID Novak Pintarič, Zorka (Mentor) More about this mentor... New window
ID Bogataj, Miloš (Comentor)
Files:.pdf VS_Koprivc_Spela_2017.pdf (2,55 MB)
MD5: 14F411832BB2B75A22074AE58A21B2AE
 
Language:Slovenian
Work type:Bachelor thesis/paper
Typology:2.11 - Undergraduate Thesis
Organization:FKKT - Faculty of Chemistry and Chemical Engineering
Abstract:Diplomsko delo obravnava osnovne elemente programskega jezika VBA v okviru programa Excel. Cilji diplomskega dela so spoznavanje programiranja v jeziku VBA, kreiranje makrov, definiranje funkcij v kemijsko-tehniških izračunih in prenos informacij med preglednico in okoljem VBA. V diplomski nalogi smo prikazali, da lahko z uporabo VBA rešujemo različne primere na področju kemijske tehnike. Omejili smo se na štiri preprostejše primere: kreiranje makrov, računanje tlaka z enačbami stanja, izračunavanje ničel funkcije in numerično integracijo. Za vsak primer smo prikazali matematični model, narisali diagram poteka, napisali kodo programa in prikazali rezultate. Diplomsko delo je osnova za spoznavanje in uporabo programskega jezika VBA pri študiju kemije in kemijske tehnologije.
Keywords:program VBA, programiranje, kemijska tehnika, koda programa, diagram poteka
Place of publishing:Maribor
Publisher:[Š. Koprivc]
Year of publishing:2016
PID:20.500.12556/DKUM-64788 New window
UDC:66.02:[004.434:5](043.2)
COBISS.SI-ID:20373014 New window
NUK URN:URN:SI:UM:DK:WW4PYTND
Publication date in DKUM:05.01.2017
Views:5085
Downloads:425
Metadata:XML DC-XML DC-RDF
Categories:KTFMB - FKKT
:
Copy citation
  
Average score:(0 votes)
Your score:Voting is allowed only for logged in users.
Share:Bookmark and Share



Hover the mouse pointer over a document title to show the abstract or click on the title to get all document metadata.

Secondary language

Language:English
Title:EXCEL VBA PROGRAMMING AND ITS APPLICATIONS IN CHEMICAL ENGINEERING
Abstract:This diploma thesis deals with basic elements of VBA programming language within Excel environment. The goals of the thesis are: introduction of VBA programming, creation of macros, definitions of functions in chemical and technical calculations as well as the transfer of information between a spreadsheets and VBA environment. The thesis demonstrates how different problems in the field of chemical engineering can be solved by using VBA. The process of solving is presented through four basic cases: creation of macros, calculating a pressure by using equations of state, calculation of functions roots, and numerical integration. Each problem was presented by its mathematical model, a flowchart, a programme code, and the results. This diploma thesis could serve as a basis for learning and using VBA programming language during the studies of Chemistry and Chemical Engineering.
Keywords:programme VBA, programming, chemical engineering, programme code, flowchart


Comments

Leave comment

You must log in to leave a comment.

Comments (0)
0 - 0 / 0
 
There are no comments!

Back
Logos of partners University of Maribor University of Ljubljana University of Primorska University of Nova Gorica