Performance evalution of industrial systems: discrete event simulation in using excel /VBA
Elizandro, David
Performance evalution of industrial systems: discrete event simulation in using excel /VBA - 2nd - Boco Ratan CRC Press 2012 - xix, 483 p.
Table of Contents
SIMULATION FUNDAMENTALS
Simulation Modeling
Why Simulate
Types of Simulation
The Simulation Clock
Randomness in Simulation
Discrete Simulation Languages
Design Environment for Event Driven Simulation (DEEDS)
The Two Sides of Simulation
Organization of this Book
Selected References
Problems
Probability and Statistics In Simulation
Role of Probability and Statistics in Simulation
Characterization of Common Distributions in Simulation
Statistical Output Analysis
Summary
Selected References
Problems
Elements of Discrete Simulation
Concept of Events in Simulation
Common Simulation Approaches
Computations of Random Deviates
Collecting Data in Simulation
Summary
Selected References
Problems
Gathering Statistical Observations in Simulation
Introduction
Peculiarities of the Simulation Experiment
Accounting for the Peculiarities of the Simulation Experiment
Methods of Gathering Simulation Observations
Variance Reduction Technique
Summary
Selected References
Problems
Overview of Deeds
Introduction
Modeling Philosophy
Basic Elements
Basic Features
Develop and Execute a Model
Summary
Network Representation
Components of the Model
Program Initial Conditions
Summary
Problems
ExcelNBA and Design Environment for Discrete Event Simulation
VBA
Introduction
Visual Basic Names
VBA Data Types
Variable Definitions
Constants
Expressions
Assignment Statements
Control Structures
Procedures
Arrays
Summary
Selected References
Problems
User Interface
Introduction
Overview of Program Manager
Source Nodes
Queue Nodes
Facility Nodes
Initial Model
Delay Nodes
Statistical Variables
User Defined Probability Distribution Functions
User Defined Tables
Program Execution Expanded
Summary
Problems
Modeling Procedures
Introduction
VIBA Procedures
Simulator Procedures
DEEDS Classes
Distribution Functions
Visual Basic Functions
Excel WorkSheetFunctions
Summary
Problems
Simulation Output
Introduction
Gathering Observations
Simulation Messages
Monitoring Simulation During Execution
Forced Model Tennination
Standard Output
Model Verification
Interactive Debugger
Summary
Selected References
Problems
Analysis of Simulation Results
Introduction
Effect of Transient State
Gathering Statistical Observations
Establish Confidence Intervals
Hypothesis Testing in Simulation Experiments
Summary
Model Visualization
Introduction
Visualization Philosophy
Basic Features
Develop and Execute Models
Summary
Modeling Special Effects
Introduction
A Multi-server Facility to Represent Indepeudent Facilities
Facility Preemption Operation
Limit on Waiting Time in Queues
Time-Dependent Inter-Creation Time at a Source
Network Logic Change Using Queue Nodes
Controlled Blockage of a Facility
Assemble and Match Sets with Common Queues
Jackson Networks
Sampling Without Replacement
Summary
Advanced Routing Techniques
Introduction
Routing Transactions
Synchronized Queues
Assemble Transactions
Summary
Selected References
Problems
APPLICATIONS
Model Design and Development
Introduction
System Specification
Simulation Constants, Decision Variables, and Constraints
Data Specifications
Project Management
Summary
Facilities Layout Models
Introduction
Facilities Management
Line Balancing Model
AGVS and Flexible Manufacturing
Material Handling Models
Introduction
Transporter Car
Overhead Crane
Carousel Conveyor
Belt Conveyor Plywood Mill Operation
Summary
Inventory Control Models
Introduction
Discount Store Model
Periodic Review Model
Continuous Review Model
Summary
Scheduling Models
Introduction
Job Shop Scheduling
PERT Project Scheduling
Daily Manpower Allocation
Summary
Maintenance Models
Introduction
General Reliability Model
Maintenance Planning Model
Summary
Quality Control Models
Introduction
Inspection Process Model
Control Chart Model
Summary
Supply Chain Logistics Models
Introduction
POIt Operation Model
Automatic Warehouse Operation
Cross Dock Model
Summary
ANALYSIS OF LARGE SCALE MODELS
Introduction
Evaluation of Alternatives
Design of Experiments
Genetic Algorithms
Summary
Appendix A: DEEDS AddIn Installation
Appendix B: Simulator Quick Guide
Appendix C: Histograms with Excel
Book Description
Basic approaches to discrete simulation have been process simulation languages (e.g., GPSS) and event-scheduling type (e.g., SIMSCRIPT). The trade-offs are that event-scheduling languages offer more modeling flexibility and process-oriented languages are more intuitive to the user. With these considerations in mind, authors David Elizandro and Hamdy Taha embarked on the development of a new discrete simulation environment that is easy to use, yet flexible enough to model complex production systems. They introduced this environment, Design Environment for Event Driven Simulation (DEEDS), in Simulation of Industrial Systems: Discrete Event Simulation in Using Excel/VBA. The DEEDS environment is itself an Excel/VBA add-in.
Based on this foundation, the second edition, now titled Performance Evaluation of Industrial Systems: Discrete Event Simulation in Using Excel/VBA incorporates the use of discrete simulation to statistically analyze a system and render the most efficient time sequences, designs, upgrades, and operations. This updated edition includes new visualization graphics for DEEDS software, improvements in the optimization of the simulation algorithms, a new chapter on queuing models, and an Excel 2007 version of the DEEDS software. Organized into three parts, the book presents concepts of discrete simulation, covers DEEDS, and discusses a variety of applications using DEEDS.
The flexibility of DEEDS makes it a great tool for students or novices to learn concepts of discrete simulation and this book can form the basis of an introductory undergraduate course on simulation. The expanded depth of coverage in the second edition gives it a richness other introductory texts do not have and provides practitioners a reference for their simulation projects. It may also be used as a research tool by faculty and graduate students who are interested in "optimizing" production systems.
9781439871348
Operations research--Data processing
Microsoft Excel (Computer file)
Visual Basic (Computer program language)
658.40352 / ELI
Performance evalution of industrial systems: discrete event simulation in using excel /VBA - 2nd - Boco Ratan CRC Press 2012 - xix, 483 p.
Table of Contents
SIMULATION FUNDAMENTALS
Simulation Modeling
Why Simulate
Types of Simulation
The Simulation Clock
Randomness in Simulation
Discrete Simulation Languages
Design Environment for Event Driven Simulation (DEEDS)
The Two Sides of Simulation
Organization of this Book
Selected References
Problems
Probability and Statistics In Simulation
Role of Probability and Statistics in Simulation
Characterization of Common Distributions in Simulation
Statistical Output Analysis
Summary
Selected References
Problems
Elements of Discrete Simulation
Concept of Events in Simulation
Common Simulation Approaches
Computations of Random Deviates
Collecting Data in Simulation
Summary
Selected References
Problems
Gathering Statistical Observations in Simulation
Introduction
Peculiarities of the Simulation Experiment
Accounting for the Peculiarities of the Simulation Experiment
Methods of Gathering Simulation Observations
Variance Reduction Technique
Summary
Selected References
Problems
Overview of Deeds
Introduction
Modeling Philosophy
Basic Elements
Basic Features
Develop and Execute a Model
Summary
Network Representation
Components of the Model
Program Initial Conditions
Summary
Problems
ExcelNBA and Design Environment for Discrete Event Simulation
VBA
Introduction
Visual Basic Names
VBA Data Types
Variable Definitions
Constants
Expressions
Assignment Statements
Control Structures
Procedures
Arrays
Summary
Selected References
Problems
User Interface
Introduction
Overview of Program Manager
Source Nodes
Queue Nodes
Facility Nodes
Initial Model
Delay Nodes
Statistical Variables
User Defined Probability Distribution Functions
User Defined Tables
Program Execution Expanded
Summary
Problems
Modeling Procedures
Introduction
VIBA Procedures
Simulator Procedures
DEEDS Classes
Distribution Functions
Visual Basic Functions
Excel WorkSheetFunctions
Summary
Problems
Simulation Output
Introduction
Gathering Observations
Simulation Messages
Monitoring Simulation During Execution
Forced Model Tennination
Standard Output
Model Verification
Interactive Debugger
Summary
Selected References
Problems
Analysis of Simulation Results
Introduction
Effect of Transient State
Gathering Statistical Observations
Establish Confidence Intervals
Hypothesis Testing in Simulation Experiments
Summary
Model Visualization
Introduction
Visualization Philosophy
Basic Features
Develop and Execute Models
Summary
Modeling Special Effects
Introduction
A Multi-server Facility to Represent Indepeudent Facilities
Facility Preemption Operation
Limit on Waiting Time in Queues
Time-Dependent Inter-Creation Time at a Source
Network Logic Change Using Queue Nodes
Controlled Blockage of a Facility
Assemble and Match Sets with Common Queues
Jackson Networks
Sampling Without Replacement
Summary
Advanced Routing Techniques
Introduction
Routing Transactions
Synchronized Queues
Assemble Transactions
Summary
Selected References
Problems
APPLICATIONS
Model Design and Development
Introduction
System Specification
Simulation Constants, Decision Variables, and Constraints
Data Specifications
Project Management
Summary
Facilities Layout Models
Introduction
Facilities Management
Line Balancing Model
AGVS and Flexible Manufacturing
Material Handling Models
Introduction
Transporter Car
Overhead Crane
Carousel Conveyor
Belt Conveyor Plywood Mill Operation
Summary
Inventory Control Models
Introduction
Discount Store Model
Periodic Review Model
Continuous Review Model
Summary
Scheduling Models
Introduction
Job Shop Scheduling
PERT Project Scheduling
Daily Manpower Allocation
Summary
Maintenance Models
Introduction
General Reliability Model
Maintenance Planning Model
Summary
Quality Control Models
Introduction
Inspection Process Model
Control Chart Model
Summary
Supply Chain Logistics Models
Introduction
POIt Operation Model
Automatic Warehouse Operation
Cross Dock Model
Summary
ANALYSIS OF LARGE SCALE MODELS
Introduction
Evaluation of Alternatives
Design of Experiments
Genetic Algorithms
Summary
Appendix A: DEEDS AddIn Installation
Appendix B: Simulator Quick Guide
Appendix C: Histograms with Excel
Book Description
Basic approaches to discrete simulation have been process simulation languages (e.g., GPSS) and event-scheduling type (e.g., SIMSCRIPT). The trade-offs are that event-scheduling languages offer more modeling flexibility and process-oriented languages are more intuitive to the user. With these considerations in mind, authors David Elizandro and Hamdy Taha embarked on the development of a new discrete simulation environment that is easy to use, yet flexible enough to model complex production systems. They introduced this environment, Design Environment for Event Driven Simulation (DEEDS), in Simulation of Industrial Systems: Discrete Event Simulation in Using Excel/VBA. The DEEDS environment is itself an Excel/VBA add-in.
Based on this foundation, the second edition, now titled Performance Evaluation of Industrial Systems: Discrete Event Simulation in Using Excel/VBA incorporates the use of discrete simulation to statistically analyze a system and render the most efficient time sequences, designs, upgrades, and operations. This updated edition includes new visualization graphics for DEEDS software, improvements in the optimization of the simulation algorithms, a new chapter on queuing models, and an Excel 2007 version of the DEEDS software. Organized into three parts, the book presents concepts of discrete simulation, covers DEEDS, and discusses a variety of applications using DEEDS.
The flexibility of DEEDS makes it a great tool for students or novices to learn concepts of discrete simulation and this book can form the basis of an introductory undergraduate course on simulation. The expanded depth of coverage in the second edition gives it a richness other introductory texts do not have and provides practitioners a reference for their simulation projects. It may also be used as a research tool by faculty and graduate students who are interested in "optimizing" production systems.
9781439871348
Operations research--Data processing
Microsoft Excel (Computer file)
Visual Basic (Computer program language)
658.40352 / ELI