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
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
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
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
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)