FileMood

Download Lynda - Process Modeling in Excel Using VBA

Lynda Process Modeling in Excel Using VBA

Name

Lynda - Process Modeling in Excel Using VBA

  DOWNLOAD Copy Link

Trouble downloading? see How To

Total Size

423.6 MB

Total Files

40

Hash

DC4A59D8D6FA708666BA1474BD839DDD3A31613F

/01. Introduction/

01_01-Welcome.mp4

8.1 MB

01_02-What you should know before watching this course.mp4

4.5 MB

01_03-Using the exercise files.mp4

1.2 MB

/02. Defining Necessary VBA Constructs/

02_01-Creating a class module.mp4

5.6 MB

02_02-Defining class properties.mp4

10.1 MB

02_03-Creating an instance of a class.mp4

11.0 MB

02_04-Creating collections.mp4

15.5 MB

02_05-Deleting objects to free up memory.mp4

6.1 MB

/03. Developing Process Control Structures/

03_01-Describing process flow and programming goals.mp4

2.0 MB

03_02-Declaring variables used in the simulation.mp4

18.9 MB

03_03-Defining the Customers class and adding a customer.mp4

6.9 MB

03_04-Defining the Stations class and adding stations.mp4

24.2 MB

03_05-Adding code to calculate and write out times.mp4

19.9 MB

03_06-Deleting unneeded objects.mp4

5.6 MB

03_07-Running the simulation.mp4

5.5 MB

03_08-Adapting the code for multiple runs.mp4

16.1 MB

/04. Adding a Ticker to Track Time/

04_01-Describing process flow and programming goals.mp4

1.7 MB

04_02-Creating an outline of If and For Next statements.mp4

29.7 MB

04_03-Adding instructions within the framework.mp4

21.2 MB

04_04-Adding code to write out results.mp4

8.1 MB

04_05-Running the simulation.mp4

6.1 MB

/05. Adding Customers During the Simulation/

05_01-Describing process flow and programming goals.mp4

1.9 MB

05_02-Calculating arrival times using the Poisson distribution.mp4

13.4 MB

05_03-Adding customers to the simulation.mp4

14.2 MB

05_04-Writing values to the Results worksheet.mp4

14.7 MB

05_05-Running the simulation.mp4

22.5 MB

/06. Recording Simulation State/

06_01-Describing process flow and programming goals.mp4

1.7 MB

06_02-Adding capacity to each station.mp4

15.7 MB

06_03-Running the simulation with added station capacity.mp4

12.3 MB

06_04-Adding more stations to the process.mp4

6.3 MB

06_05-Running the simulation with additional stations.mp4

6.3 MB

06_06-Adding rework loops to stations.mp4

25.7 MB

06_07-Running the simulation with rework loops.mp4

11.4 MB

/07. Analyzing Simulation Results/

07_01-Reading the simulation results as written.mp4

9.3 MB

07_02-Manually resetting the results cells.mp4

5.1 MB

07_03-Converting simulation output to an Excel table.mp4

7.1 MB

07_04-Summarizing results using the Total row.mp4

9.4 MB

07_05-Sorting and filtering Excel table values.mp4

13.4 MB

/08. Conclusion/

08_01-Next steps.mp4

4.1 MB

/Exercice Files/

Ex_Files_Process_Modeling.zip

896.9 KB

 

Total files 40


Copyright © 2025 FileMood.com