Operations Research mit Excel und VBA

Globalization, which has advanced to an increasing extent in recent years, and also the consequences of the economic and financial crisis are presenting logistics with increasing challenges. Optimized location and route planning is becoming increasingly relevant, not only for large companies, but also for small and medium-sized enterprises. The high financial expenditure for customized software solutions can be minimized by using the software package Microsoft Office with the programming language VBA, which is included in it anyway. So far, this language has hardly been used by companies, even though it is a very powerful tool that offers great savings potential. The author Christoph Wille guides the reader step by step to the goal from the basics to advanced techniques of location and route planning as well as programming in VBA. In doing so, he points out pitfalls and.