Process Modeling in Excel Using VBA
MP4 | Video: AVC 1280x720 | Audio: AAC 48KHz 2ch | Duration: 3h 14m | 404 MB
Genre: eLearning | Language: English
Learn how to use Excel and VBA to create and run simulations on business processes for customer flow, queuing, and manufacturing. Visual Basics for Applications exponentially extends Excel's power, allowing you to control process flow and logic and add custom classes and variables. In these tutorials, Curt Frye builds simulations of increasing complexity, which model the flow of customers through checkout stations. You'll learn how to calculate arrival and transaction times, add customers, and increase individual station capacity, and find out when you need to add more stations. At the end of the course, Curt shows how to convert output to an Excel table and analyze the results of your simulation.
链接: http://pan.baidu.com/s/1bnSAtUv 密码: 5kmd