Scribd
Upload
4 views11 pages

Simulating Random Arrival Times in VBA

This document discusses how to simulate random arrival times using discrete uniform distribution in a dynamic discrete-event simulation context. It emphasizes the importance of interarrival times and the simulation clock for tracking events over time. The module demonstrates the use of Excel VBA functions to generate these random times effectively.

Uploaded by

homeimran0335
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
4 views11 pages

Simulating Random Arrival Times in VBA

This document discusses how to simulate random arrival times using discrete uniform distribution in a dynamic discrete-event simulation context. It emphasizes the importance of interarrival times and the simulation clock for tracking events over time. The module demonstrates the use of Excel VBA functions to generate these random times effectively.

Uploaded by

homeimran0335
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

Modeling and Simulation

Simulating a Random
Arrival Time

1
Simulating a Random Arrival Time
• In this module, we shall
see how we can
simulate a Random
Arrival time

2
The Problem
• We want to simulate a
random interarrival time
(Time between successive
arrivals) and compute
arrival times of customers
or other entities

3
Interarrival Time
• Interarrival times and
service times are
examples of simulation-
generated time durations
• These are called activity
times or activities

4
Simulation Clock
• Simulation clock is a key
component in a dynamic
discrete-event simulation.
• Clock times represent the
time of occurrence of an
event
• E.g. arrival, service
beginning, completion
etc.

5
Simulating a Random Arrival Time
• Telephone calls to a
Telephone Info service
occur at random times
• These are defined by a
discrete distribution with
values 1, 2, 3, or 4 min –
all equal probability.
• Goal is to generate both
interarrival times and
arrival times

6
Simulating a Random Arrival Time
• Dynamic here means time-
based – with system state
changing over time
• Dynamic event-based
means model tracks
progression of event
occurrences over time

7
Simulation Details
• Simulation is based on the
“Uniform” discrete
distribution
• Uniform means all events
have equal probabilities
• VBA Function Discrete
Uniform()
• The function takes 2
arguments – minimum
and maximum values

8
Simulation Clock
• Simulation clock is a key
component in a dynamic
discrete-event simulation.
• Clock times represent the
time of occurrence of an
event
• E.g. arrival, service
beginning, completion
etc.

9
[Link]

10
Summary
• In this module, we have
examined how we can use
Excel VBA functions to
simulate events such as
interarrival times and
arrival times.
• The key idea is to use a
discrete uniform
distribution

11

You might also like