->
Lynda - Excel VBA: Process Modeling (2016) - 431059
Lynda - Excel VBA: Process Modeling (2016)
Excel power users: 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 exercise-centered 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.


Table of Contents

  • Introduction
  • 1. Defining Necessary VBA Constructs
  • 2. Developing Process Control Structures
  • 3. Adding a Ticker to Track Time
  • 4. Adding Customers During the Simulation
  • 5. Recording Simulation State
  • 6. Analyzing Simulation Results
  • Conclusion
  • Lynda - Excel VBA: Process Modeling (2016)


     TO MAC USERS: If RAR password doesn't work, use this archive program: 

    RAR Expander 0.8.5 Beta 4  and extract password protected files without error.


     TO WIN USERS: If RAR password doesn't work, use this archive program: 

    Latest Winrar  and extract password protected files without error.


     Coktum   |  

    Information
    Members of Guests cannot leave comments.




    rss