Dokumentation i form av tekniska ritningar och kretsscheman av olika slag är en viktig del av de flesta projekt. Många företag använder sig av olika CAD-program så som AutoCAD för att ta fram och bearbeta ritningar och kretsscheman. Ritningar brukar byggas upp av blockelement som innehåller attribut. Attribut är yttre beskrivande information av blocket, exempelvis fotnoter eller annan text av något slag. Det är inte ovanligt att en installation omfattar flera hundra tekniska ritningar, vilket medför att arbete med attribut kan vara mycket tidskrävande. Användaren måste gå in i varje ritning markera önskade attribut och utföra ändringar.  Företaget AFRY har uttryckt behovet av att automatisera en del av denna process till vilket detta examensarbete förfogas. Genom att författa script i programmet AutoLISP extraheras önskade blockinformationen ur varje ritning och sparas till en textfil i formatet tsv. Med hjälp av Microsofts Visual Basic for Applications utvecklas ett användarvänligt gränssnitt i Microsoft Excel.  Programmet avses för att importera stora mängder tsv filer innehållande data för redigering. Data kan redigeras på ett tidseffektivt sätt för att senare exporteras tillbaka till sitt ursprungliga textfilsformat. När färdigredigerade textfiler lämnar Excel återstår återinförande av integrerad blockinformation till ritningarna. Detta möjliggörs av ett annat program i AutoLISP som baseras på AutoCADs egna ATTIN funktion.  Efter utfört projekt kan det konstateras att verktyget som utvecklades automatiserar en del av redigeringsarbetet med tekniska ritningar. Detta i sin tur kan medföra tidseffektivisering, minskad risk för mänskliga fel och beroendet av tredjeparts mjukvaror vid processen. Givetvis finns det utrymme för vidare utveckling av verktyget i framtiden, förslagsvis utökad funktionalitet hos gränssnittet i Excel och en robust metod för batchning i AutoCAD. / On everyday basis engineering companies work with technical drawings and diagrams. To create and work with these drawings it is common to use software such as AutoCAD. Drawings in AutoCAD are built up with blocks, these blocks can often contain external information stored as attributes. A project can contain up to several hundred drawings. In that case the process of searching for blocks to change specific attributes can be very time consuming and increase risk of human error. The engineering company AFRY has expressed an interest in partial automation of this process. Following thesis aims to present a possible solution. By writing scripts in AutoLISP, desired block information can be extracted to tsv text files. These text files can be imported to a user-friendly interface in Microsoft Excel. The interface is developed in Microsoft's Visual Basic for Applications. Data imported in the interface can be filtered so that the editing can be done in a time efficient manner. After finished editing the data is once again organized into tsv text files for a further integration to the CAD drawings. That is made possible by a AutoLISP script based on the ATTIN function. The thesis aims to discuss how this presented method would lead to a partial automation in the editing of AutoCAD drawings. A process that could possibly reduce risk of error, increase time efficiency as well as decrease dependency of third-party software. The discussion also presents some thoughts for further development of the program where, increased amount functions in Excel and a possible method for batching in AutoCAD could be added in the future.

The orienteering problem is one of the newer problems in the field of discrete programming. The formulation of this problem originates from a sport discipline, called orienteering. In the beginning of this thesis a formulation and mathematical model for this problem are introduced. The extension of the problem is the team orienteering problem, described in the next chapters of theoretical part. Many heuristics were published for this problem. While the heuristic of Chao et al. and a path relinking approach are described in detail in this thesis. Practical part deals with the team orienteering problem applied to a real task, specifically a visiting of 23 attractions in the New York in different number of days. The solution is found by optimization program Lingo 90 and by heuristic of Chao el al. Heuristic algorithm was implemented in programming language Visual Basic for Application. A comparison of the results is described at the end of the practical part.

This thesis focuses on the support of software applications development using mathematical and statistical methods. One of the topics related to this issue is inventory management. The thesis deals with inventory management in the pizzeria, which I have thoroughly analyzed and based on the data and methods needed to design a software application to simplify and accelerate the supply of raw materials.

The master's thesis focuses on supporting the development of applications using mathematical and statistical methods. This is used in the thesis to effective management of inventory for the store and e-shop. For this purpose, an application in VBA programming language has been developed to help the company to keep track of the inventory and find the optimum insurance stock level for ordering new goods.

This graduation thesis deals with evaluation of power and coolant flow in reactor core. The first part is a description of nuclear power plant VVER 440. It is focused on parts important for transfer and utilize energy in regular operating of generating block. In the second part, the equations for calculation of power and coolant flow in reactor core are deduced. The last part is about designing the program for calculation of published values. There are specified requirements for the program and on the basis of this the source code is written. The parts of code are described. In conclusion of this part, the user's manual is work out. The program is on CD in the annexe.

Theme of this master’s thesis is design of software support for business intelligence. Design is realized in cooperation with corporation ZZN Pelhřimov a.s. Introduction is focused on theoretical description of business intelligence and datamining and also on development environment in which is project designed. Corporation is characterised also in introduction. Main part contains data collecting and definition of individual modules. In conclusion of this thesis will be several types of analysis from collected data and then according to these analysis, we can draw measures to improve current state of corporation.

The task of the diploma thesis named VBA and Maple Application on Process Engineering Problems is to show the possibilities of using these programming languages for various engineering tasks. Particularly the programming language Visual Basic for Application (VBA), which is a part of MS Office package, is very little used in practise. That´s why this thesis solves the complex task of a furnaces design process; the topic was reccomended by the supervisor prof. Ing. Josef Kohoutek, CSc. Specifically, the thesis deals with calculations of heat transfer and optimization of the height of extended surfaces of tubes in the convection section of process furnaces. The entire task is elaborated in VBA and runs in Excel. After entering the input information, the created program first calculates the size and heat output of the convection section, but it can also optimize the height of extended surfaces in different parts of the convection section and thus minimize investment costs.