prikaz prve stranice dokumenta PRIMJENA ALATA RJEŠAVAČ U MS EXCEL-U PRI OPTIMIRANJU
Access restricted to students and staff of home institution
undergraduate thesis
PRIMJENA ALATA RJEŠAVAČ U MS EXCEL-U PRI OPTIMIRANJU
Slavonski Brod: Josip Juraj Strossmayer University of Osijek, Mechanical Engineering Faculty in Slavonski Brod, 2018. urn:nbn:hr:153:111745
Sabljak, Veronika
Josip Juraj Strossmayer University of Osijek
Mechanical Engineering Faculty in Slavonski Brod

Institutional repository: Repository of Mechanical Engineering in Slavonski Brod

Cite this document

Sabljak, V. (2018). PRIMJENA ALATA RJEŠAVAČ U MS EXCEL-U PRI OPTIMIRANJU (Undergraduate thesis). Slavonski Brod: Josip Juraj Strossmayer University of Osijek, Mechanical Engineering Faculty in Slavonski Brod. Retrieved from https://urn.nsk.hr/urn:nbn:hr:153:111745

Sabljak, Veronika. "PRIMJENA ALATA RJEŠAVAČ U MS EXCEL-U PRI OPTIMIRANJU." Undergraduate thesis, Josip Juraj Strossmayer University of Osijek, Mechanical Engineering Faculty in Slavonski Brod, 2018. https://urn.nsk.hr/urn:nbn:hr:153:111745

Sabljak, Veronika. "PRIMJENA ALATA RJEŠAVAČ U MS EXCEL-U PRI OPTIMIRANJU." Undergraduate thesis, Josip Juraj Strossmayer University of Osijek, Mechanical Engineering Faculty in Slavonski Brod, 2018. https://urn.nsk.hr/urn:nbn:hr:153:111745

Sabljak, V. (2018). 'PRIMJENA ALATA RJEŠAVAČ U MS EXCEL-U PRI OPTIMIRANJU', Undergraduate thesis, Josip Juraj Strossmayer University of Osijek, Mechanical Engineering Faculty in Slavonski Brod, accessed 29 December 2024, https://urn.nsk.hr/urn:nbn:hr:153:111745

Sabljak V. PRIMJENA ALATA RJEŠAVAČ U MS EXCEL-U PRI OPTIMIRANJU [Undergraduate thesis]. Slavonski Brod: Josip Juraj Strossmayer University of Osijek, Mechanical Engineering Faculty in Slavonski Brod; 2018 [cited 2024 December 29] Available at: https://urn.nsk.hr/urn:nbn:hr:153:111745

V. Sabljak, "PRIMJENA ALATA RJEŠAVAČ U MS EXCEL-U PRI OPTIMIRANJU", Undergraduate thesis, Josip Juraj Strossmayer University of Osijek, Mechanical Engineering Faculty in Slavonski Brod, Slavonski Brod, 2018. Available at: https://urn.nsk.hr/urn:nbn:hr:153:111745

Metadata
TitlePRIMJENA ALATA RJEŠAVAČ U MS EXCEL-U PRI OPTIMIRANJU
Title (english)APPLICATION OF SOLVER IN MS EXCEL DURING OPTIMIZATION
AuthorVeronika Sabljak
MentorKatica Šimunović (mentor)
Committee memberKatica Šimunović (član povjerenstva)
Committee memberSara Havrlišan (član povjerenstva)
Committee memberIlija Svalina (član povjerenstva)
GranterJosip Juraj Strossmayer University of Osijek
Mechanical Engineering Faculty in Slavonski Brod
Slavonski Brod
Defense date and country2018-09-24, Croatia
Scientific / art field,
discipline and subdiscipline		TECHNICAL SCIENCES
Mechanical Engineering
Abstract
U ovom završnom radu opisan je alat Rješavač u MS Excel-u kojim se rješavaju linearni, nelinearni i cjelobrojni problemi te izvještaji odgovora, osjetljivosti i ograničenja te uvjeti binarnosti. U prvom poglavlju opisan je alat rješavač sa svim svojim mogućnostima. U drugom poglavlju definirana su dva problema linearnog programiranja. Nakon što su problemi definirani, u trećem poglavlju postavljeni su matematički modeli te su u četvrtom poglavlju prikazana optimalna rješenja. U zaključku su dani kratki uvidi u rješenja problema.
Abstract (english)
In this bachelor thesis, Solver tool in MS Excel for solving linear, nonlinear and integer problems is presented. Furthermore, Answer, Sensitivity and Limits Reports are described as well as binary constraints. In the first chapter, all the parameters and options of Solver tool are described. In the second chapter, two linear problems are defined. After the problems are defined, in the third chapter mathematical models are defined and in the fourth chapter optimal solutions are presented. In conclusion, a short insight into optimal solutions is given.
Keywords
Keywords (english)
Languagecroatian
URN:NBNurn:nbn:hr:153:111745
Study programmeTitle: Undergraduate Study in Mechanical Engineering
Study programme type: university
Study level: undergraduate
Academic / professional title: sveučilišni/a prvostupnik/ prvostupnica (baccalaureus/baccalaurea) inženjer/inženjerka strojarstva (sveučilišni/a prvostupnik/ prvostupnica (baccalaureus/baccalaurea) inženjer/inženjerka strojarstva)
Type of resourceText
File originBorn digital
Access conditionsAccess restricted to students and staff of home institution
Terms of useLicence In copyright icon
Created on2018-09-25 08:20:37