Visualizing Solutions in Network Analysis with Visual Basic for Applications

Larry J. LeBlanc

《Asia Pacific Management Review》 8卷4期 (2003/12) Pp. 523-543

https://doi.org/10.6126/APMR.2003.8.4.06

並列摘要

Network models have been very useful for analyzing problems involving telecommunications, supply chains, vehicle routing, and other areas. In this paper I discuss the importance of visualization for network optimization. Reasons include explaining the model to non-technical managers and obtaining better solutions for the network model. Better solutions can be a direct result of visualization (when human intuition identifies a solution from the network picture) or an indirect result (when human intuition identifies improved procedures in algorithmic design, which then result in superior solutions). I discuss the importance of Visual Basic for Applications (VBA) for drawing networks directly within Microsoft Excel. I show how to use VBA efficiently to draw these networks using various Excel drawing objects.

並列關鍵字

Visual interactive optimization ； Network optimization ； Network graphing ； Supply chains ； Visual Basic for Applications

參考文獻

Albright, S.(2001).VBA for Modelers: Developing Decision Support Systems with Microsoft Excel.Pacific Grove:Duxbury/ Thomson Learning.

Boyce, D., Ran, Bin, Leblanc, L.(1995).Solving an instantaneous dynamic user-optimal route choice model.Transportation Science.29(2)

Cohen, M., Huchzermeier, A.(1999).Quantitative Models for Supply Chain Management.

Copacino, W. C.(1997).Supply Chain Management: The Basics and Beyond.Falls Creek:St. Lucie Press.

Cummings, S.(1999).VBA for Dummies.Foster City, CA:IDG Books Worldwide.