Operations Research mit Excel und VBA

In recent years, the advancing globalization, as well as the consequences of the economic and financial crisis, have posed increasing challenges for logistics. Optimized location and route planning is becoming increasingly relevant not only for large companies but especially for small and medium-sized enterprises. The high financial investment required for customized software solutions can be minimized by using the Microsoft Office software package, which already includes the programming language VBA. This tool is still rarely utilized by companies, despite its significant potential for cost savings. The author Christoph Wille guides the reader step by step from the basics to advanced techniques in location and route planning, as well as programming in VBA, while pointing out potential pitfalls.