Lynda - Process Modeling in Excel Using VBA

1. 01. Introduction/01_01-Welcome.mp47.74MB
2. 01. Introduction/01_02-What you should know before watching this course.mp44.33MB
3. 01. Introduction/01_03-Using the exercise files.mp41.13MB
4. 02. Defining Necessary VBA Constructs/02_01-Creating a class module.mp45.36MB
5. 02. Defining Necessary VBA Constructs/02_02-Defining class properties.mp49.64MB
6. 02. Defining Necessary VBA Constructs/02_03-Creating an instance of a class.mp410.45MB
7. 02. Defining Necessary VBA Constructs/02_04-Creating collections.mp414.76MB
8. 02. Defining Necessary VBA Constructs/02_05-Deleting objects to free up memory.mp45.86MB
9. 03. Developing Process Control Structures/03_01-Describing process flow and programming goals.mp41.88MB
10. 03. Developing Process Control Structures/03_02-Declaring variables used in the simulation.mp418MB
11. 03. Developing Process Control Structures/03_03-Defining the Customers class and adding a customer.mp46.56MB
12. 03. Developing Process Control Structures/03_04-Defining the Stations class and adding stations.mp423.07MB
13. 03. Developing Process Control Structures/03_05-Adding code to calculate and write out times.mp419.02MB
14. 03. Developing Process Control Structures/03_06-Deleting unneeded objects.mp45.37MB
15. 03. Developing Process Control Structures/03_07-Running the simulation.mp45.28MB
16. 03. Developing Process Control Structures/03_08-Adapting the code for multiple runs.mp415.37MB
17. 04. Adding a Ticker to Track Time/04_01-Describing process flow and programming goals.mp41.6MB
18. 04. Adding a Ticker to Track Time/04_02-Creating an outline of If and For Next statements.mp428.31MB
19. 04. Adding a Ticker to Track Time/04_03-Adding instructions within the framework.mp420.26MB
20. 04. Adding a Ticker to Track Time/04_04-Adding code to write out results.mp47.7MB
21. 04. Adding a Ticker to Track Time/04_05-Running the simulation.mp45.86MB
22. 05. Adding Customers During the Simulation/05_01-Describing process flow and programming goals.mp41.78MB
23. 05. Adding Customers During the Simulation/05_02-Calculating arrival times using the Poisson distribution.mp412.8MB
24. 05. Adding Customers During the Simulation/05_03-Adding customers to the simulation.mp413.55MB
25. 05. Adding Customers During the Simulation/05_04-Writing values to the Results worksheet.mp414MB
26. 05. Adding Customers During the Simulation/05_05-Running the simulation.mp421.47MB
27. 06. Recording Simulation State/06_01-Describing process flow and programming goals.mp41.67MB
28. 06. Recording Simulation State/06_02-Adding capacity to each station.mp414.94MB
29. 06. Recording Simulation State/06_03-Running the simulation with added station capacity.mp411.77MB
30. 06. Recording Simulation State/06_04-Adding more stations to the process.mp46.04MB
31. 06. Recording Simulation State/06_05-Running the simulation with additional stations.mp46.03MB
32. 06. Recording Simulation State/06_06-Adding rework loops to stations.mp424.48MB
33. 06. Recording Simulation State/06_07-Running the simulation with rework loops.mp410.88MB
34. 07. Analyzing Simulation Results/07_01-Reading the simulation results as written.mp48.88MB
35. 07. Analyzing Simulation Results/07_02-Manually resetting the results cells.mp44.83MB
36. 07. Analyzing Simulation Results/07_03-Converting simulation output to an Excel table.mp46.82MB
37. 07. Analyzing Simulation Results/07_04-Summarizing results using the Total row.mp48.93MB
38. 07. Analyzing Simulation Results/07_05-Sorting and filtering Excel table values.mp412.8MB
39. 08. Conclusion/08_01-Next steps.mp43.9MB