وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Excel VBA: Process Modeling

سرفصل های دوره

Excel power users: Learn how to use Excel and Visual Basic for Applications (VBA) to create and run simulations of business processes for customer flow, queuing, and manufacturing. VBA exponentially extends the power of Excel, allowing you to control process flow and logic and add custom classes and variables. In this course, Curt Frye demonstrates how to build simulations of increasing complexity, which model the flow of customers through a multistation process.


01 - Introduction
  • 01 - Analyze your business processes using Excel VBA
  • 02 - Gain insight into your business through simulation

  • 02 - 1. Defining Necessary VBA Constructs
  • 01 - Create a class module
  • 02 - Define class properties
  • 03 - Create an instance of a class
  • 04 - Create collections
  • 05 - Delete objects to free up memory

  • 03 - 2. Developing Process Control Structures
  • 01 - Describe process flow and programming goals
  • 02 - Declare variables used in the simulation
  • 03 - Define the Customers class and add a customer
  • 04 - Define the Stations class and add stations
  • 05 - Add code to calculate and write out times
  • 06 - Delete unneeded objects
  • 07 - Run the simulation
  • 08 - Adapt the code for multiple runs

  • 04 - 3. Adding a Ticker to Track Time
  • 01 - Define process flow and programming goals
  • 02 - Create an outline of IF and For Next statements
  • 03 - Add instructions within the framework
  • 04 - Add code to write out simulation results
  • 05 - Run the simulation

  • 05 - 4. Adding Customers during the Simulation
  • 01 - Describe process flow and programming goals
  • 02 - Use the Poisson distribution to calculate arrival times
  • 03 - Add customers to the simulation
  • 04 - Add code to write out simulation results
  • 05 - Run the simulation

  • 06 - 5. Modifying the Simulation
  • 01 - Describe process flow and programming goals
  • 02 - Add capacity to each station
  • 03 - Run the simulation with added station capacity
  • 04 - Add more stations to the simulation
  • 05 - Run the simulation with additional stations
  • 06 - Add rework loops to stations
  • 07 - Run the simulation with rework loops

  • 07 - 6. Allowing Conditional Processing
  • 01 - Describe process flow and programming goals
  • 02 - Allow conditional station paths
  • 03 - Run the simulation
  • 04 - Allow other employees to help the process
  • 05 - Run the simulation with helpers
  • 06 - Add time for customers to complete the process

  • 08 - 7. Analyzing Simulation Results
  • 01 - Read the simulation results as written
  • 02 - Manually reset the results cells
  • 03 - Summarize results using the Total row
  • 04 - Sort and filter Excel table values
  • 05 - Troubleshoot errors in your code

  • 09 - Conclusion
  • 01 - Further resources
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    افزودن به سبد خرید
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 45548
    حجم: 407 مگابایت
    مدت زمان: 183 دقیقه
    تاریخ انتشار: ۱۴ دی ۱۴۰۴
    دسته بندی محصول
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید