Setup Menus in Admin Panel

Course Curriculum

Introduction
Build effective simulations using Excel VBA_Excel 00:00:00
What you should know_Excel 00:00:00
Define Necessary VBA Constructs
Create a class module_Excel 00:00:00
Define class properties_Excel 00:00:00
Create an instance of a class_Excel 00:00:00
Create collections_Excel 00:00:00
Delete objects to free up memory_Excel 00:00:00
Develop Process Control Structures
Define process flow and programming goals_Excel 00:00:00
Declare variables used in the simulation_Excel 00:00:00
Define the Customers class and add a customer_Excel 00:00:00
Define the Stations class and add a station_Excel 00:00:00
Add code to calculate and write out times_Excel 00:00:00
Delete unneeded objects_Excel 00:00:00
Run the simulation_Excel 00:00:00
Adapt the code for multiple runs_Excel 00:00:00
Add a Ticker to Track Time
Define process flow and programming goals_Excel 00:00:00
Create an outline of If and For Next statements_Excel 00:00:00
Add instructions within the framework_Excel 00:00:00
Add code to write out simulation results_Excel 00:00:00
Run the simulation_Excel 00:00:00
Add Customers during the Simulation
Define process flow and programming goals_Excel 00:00:00
Use the Poisson distribution to calculate arrival times_Excel 00:00:00
Add customers to the simulation_Excel 00:00:00
Add code to write out simulation results_Excel 00:00:00
Run the simulation_Excel 00:00:00
Modify the Simulation
Define process flow and programming goals_Excel 00:00:00
Add capacity to each station_Excel 00:00:00
Run the simulation with added station capacity_Excel 00:00:00
Add more stations to the simulation_Excel 00:00:00
Run the simulation with additional stations_Excel 00:00:00
Add rework loops to stations_Excel 00:00:00
Run the simulation with rework loops_Excel 00:00:00
Allow Conditional Processing
Define process flow and programming goals_Excel 00:00:00
Enable conditional station paths_Excel 00:00:00
Run the simulation_Excel 00:00:00
Analyze Simulation Results
Read the simulation results as written_Excel 00:00:00
Manually reset the results cells_Excel 00:00:00
Summarize results using the Total row_Excel 00:00:00
Sort and filter Excel table values_Excel 00:00:00
Troubleshoot errors in your code_Excel 00:00:00
Conclusion
Next Steps_Excel 00:00:00

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

PRIVATE COURSE
  • PRIVATE
  • 1 week, 3 days
0 STUDENTS ENROLLED
    Copyright @2019