TorBT - Torrents and Magnet Links Search Engine
Lynda - Process Modeling in Excel Using VBA
- Date: 2026-09-13
- Size: 404 MB
- Files: 40
File Name
Size
01. Introduction/01_01-Welcome.mp4
7.7 MB
01. Introduction/01_02-What you should know before watching this course.mp4
4.3 MB
01. Introduction/01_03-Using the exercise files.mp4
1.1 MB
02. Defining Necessary VBA Constructs/02_01-Creating a class module.mp4
5.4 MB
02. Defining Necessary VBA Constructs/02_02-Defining class properties.mp4
9.6 MB
02. Defining Necessary VBA Constructs/02_03-Creating an instance of a class.mp4
10 MB
02. Defining Necessary VBA Constructs/02_04-Creating collections.mp4
15 MB
02. Defining Necessary VBA Constructs/02_05-Deleting objects to free up memory.mp4
5.9 MB
03. Developing Process Control Structures/03_01-Describing process flow and programming goals.mp4
1.9 MB
03. Developing Process Control Structures/03_02-Declaring variables used in the simulation.mp4
18 MB
03. Developing Process Control Structures/03_03-Defining the Customers class and adding a customer.mp4
6.6 MB
03. Developing Process Control Structures/03_04-Defining the Stations class and adding stations.mp4
23 MB
03. Developing Process Control Structures/03_05-Adding code to calculate and write out times.mp4
19 MB
03. Developing Process Control Structures/03_06-Deleting unneeded objects.mp4
5.4 MB
03. Developing Process Control Structures/03_07-Running the simulation.mp4
5.3 MB
03. Developing Process Control Structures/03_08-Adapting the code for multiple runs.mp4
15 MB
04. Adding a Ticker to Track Time/04_01-Describing process flow and programming goals.mp4
1.6 MB
04. Adding a Ticker to Track Time/04_02-Creating an outline of If and For Next statements.mp4
28 MB
04. Adding a Ticker to Track Time/04_03-Adding instructions within the framework.mp4
20 MB
04. Adding a Ticker to Track Time/04_04-Adding code to write out results.mp4
7.7 MB
04. Adding a Ticker to Track Time/04_05-Running the simulation.mp4
5.9 MB
05. Adding Customers During the Simulation/05_01-Describing process flow and programming goals.mp4
1.8 MB
05. Adding Customers During the Simulation/05_02-Calculating arrival times using the Poisson distribution.mp4
13 MB
05. Adding Customers During the Simulation/05_03-Adding customers to the simulation.mp4
14 MB
05. Adding Customers During the Simulation/05_04-Writing values to the Results worksheet.mp4
14 MB
05. Adding Customers During the Simulation/05_05-Running the simulation.mp4
22 MB
06. Recording Simulation State/06_01-Describing process flow and programming goals.mp4
1.7 MB
06. Recording Simulation State/06_02-Adding capacity to each station.mp4
15 MB
06. Recording Simulation State/06_03-Running the simulation with added station capacity.mp4
12 MB
06. Recording Simulation State/06_04-Adding more stations to the process.mp4
6.0 MB
06. Recording Simulation State/06_05-Running the simulation with additional stations.mp4
6.0 MB
06. Recording Simulation State/06_06-Adding rework loops to stations.mp4
24 MB
06. Recording Simulation State/06_07-Running the simulation with rework loops.mp4
11 MB
07. Analyzing Simulation Results/07_01-Reading the simulation results as written.mp4
8.9 MB
07. Analyzing Simulation Results/07_02-Manually resetting the results cells.mp4
4.8 MB
07. Analyzing Simulation Results/07_03-Converting simulation output to an Excel table.mp4
6.8 MB
07. Analyzing Simulation Results/07_04-Summarizing results using the Total row.mp4
8.9 MB
07. Analyzing Simulation Results/07_05-Sorting and filtering Excel table values.mp4
13 MB
08. Conclusion/08_01-Next steps.mp4
3.9 MB
Exercice Files/Ex_Files_Process_Modeling.zip
876 kB