Vacek, J. Diploma thesis. Brno: Mendel University in Brno, 2015. The diploma thesis deals with the economic evaluation of the investment into en-ergy- efficient concepts of buildings and with the economic evaluation of the op-timization of the current energic solutions. The aim of the diploma thesis is to create a general tool in MS Excel for the economic evalution mentioned above. And consequently is to execute the test of this program in terms of application on the real case study. The results are simulated in Crystal Ball based on Monte Carlo method to eliminate the risk of uncertainty.

The diploma thesis is focused on verifying the accuracy of web Analytics Adobe Analytics. Manual control is a time-consuming activity, therefore web analysts are looking for ways leading to its acceleration and automation. Selected problem was solved by writing VBA macro in MS Excel. Macro checks the reports that are uploaded into Excel from analytic database using Adobe Report Builder. The theoretical part is focused on explaining the role of web analytics in online marketing and related concepts. The practical part presents the requirements for macro in Excel and then interprets all functions and procedures created by the program. Thesis also includes the configuration of the ObservePoint system competitive environment, which will be the last part compared with created macro. Created solution in Excel allows to verify the accuracy of web analytics with clearly sorted results quickly, thereby replaces the previous manual control.

Hösten 2018 inrättas det en ny version av läroplanen från 2011 med mer fokus på programmering. Syftet med denna litteraturstudie är att sammanställa forskningslitteraturens resultat om olika programmeringsspråks lämplighet för högstadiets matematikundervisning, samt lämpliga matematikområden. Frågeställningarna jämför tre programmeringsspråk med avseende på deras lämplighet och för- och nackdelar i matematikundervisningen. Programmeringsspråken, som jämförs, är Scratch, Python och VBA (Visual Basics of Application, programmering i Microsofts kalkylprogram Excel). Litteraturstudiens resultat visar att Scratch och Python anses vara lämpliga för nybörjare och är utvecklade för att de ska vara lätta att lära sig och förstå medan VBA är det programmeringsspråk som är utvecklat för att utföra matematiska beräkningar med. Programmeringsspråken kan användas i matematikundervisningen på likvärdiga sätt och i de flesta matematikområdena beroende på elevernas kompetens och lärarens val av uppgifter och tillvägagångssätt. Vidare är det möjligt att eleverna kan bli mer motiverade till att lära sig matematik om de har tillgång till digitala hjälpmedel eller programmering inom matematikundervisningen

This master´s thesis deals with automation creating of reports. The theoretical part explains principle of programming, VBA, reporting and planning. The practical part is focused on development of application and her possible uses.

The path along which a high voltage cable needs to travel within the production facility is designed by a combination of straight and curved segments. As segments are available only in standard sizes, the path must be standardized. The transformation of an initial path into standardized path is a manual and time-consuming process. Tools are developed to automate this process using Knowledge-Based Engineering (KBE). The MOKA-methodology has been followed to capture and store the knowledge behind the standardization of the path. Designs of truss segments which are currently in use are studied and modified to make the models more efficient. Finite Element Analysis (FEA) is performed to evaluate the strength of segments of both old and new models which shows that new models are more efficient. To rapidly obtain segments of different dimensions, parametric models of segments are designed.

The aim of the thesis is the mathematical model, which is capable to divide participants of large summer camps into groups, according to specific limitations. The first part describes the economics model and all valid conditions. The second part is devoted to theoretical description. There are mentioned the basics of mathematical programming and the basic of working with Excel and VBA. The thesis describes only actually used methods. The following third part shows the final form of the model. So the reader doesn´t have to go through the whole process, described in the fourth part. There is a model testing in the fourth part, especially with the help of the Excel Solver. The problems are sold immediately. That is the reason why the fifth part can be used for implementation of working environment, which allows the end user to run the model without any significant knowledge of the issue. The app uses the wide possibilities of VBA. The sixth part briefly describes other add-ins, that are able to solve mathematical problem. The conclusion summarizes all the previous parts and offeres solution, that would be used in real application of the thesis.

The aim of this thesis is to create an application in MS Excel, which would have been able to count on basic stock models, and Markov decision processes with alternatives. This issue is devoted to the first part of the work. This is the theory needed to understand the basic principles and method of calculation tasks. The second part describes the developed application that can be solved one-product and multiproduct deterministic stock models, stochastic stock models and Markov decision processes with alternatives, and changing valuation of the transition. The description is supplemented with graphic images directly from the application, which makes using applications easier to understand. The part of work is also CD with created application.

The global industry is gradually moving towards automation nowadays. Thetool for design support is a required tool for auto companies and relatedcompanies. The tool for design support is a tool based on Microsoft Excel, the mainobjective is to build an Interactive Tool for analysis, outputting productparameters and generating reports through Case Based reasoning (CBR),Decision Tree and Programming in Excel VBA. Through Excel’s calculationand analysis generate intuitive report instead of time-consuming and labour-consuming measurement, towards calculation and analysis automation. Thus,it can reduce working time and decrease labour consumption.

My diploma thesis is dedicated to the issue of data mining, its part of predictive analysis and then process that is used in HP for different prediction. The introductory part describes the concept of data mining, its role and benefits. To one of its tasks fall predictive analysis, where I discussed the principles of its use. Then follows framework HP, which uses one of the tasks of predictive analysis. In the practical part, I applied the use VBA to automate one part of the process of converting text to numerical data, assuming different rules. The result is a set of macros support, system sheet and the new ribbon for data transformation.

The Capacitated Arc Routing Problem has many applications in real life. The aim of this problem is to minimize the total cost at fulfilment of the requirements of arcs. The Capacitated Arc Routing Problem is an extension of the Chinese Postman Problem, which is a special type of the Vehicle Routing Problems. In this thesis is explained the issue of the Chinese Postman Problem and its extensions at first. Subsequently the applications of mathematical models are illustrated on a model example. However these mathematical models, which are searching the optimal solution, do not use so much in reality. Therefore the randomized heuristic algorithm for solving these problems is suggested and programmed in this thesis. Subsequently this heuristic was applied to case study of garbage collection in Podebrady city.