Application of the simulation with a spreadsheet to Queueing theory

  • Authors:
  • Juan Jesús Bernal García;Soledad María Martínez María Dolores;Juan Francisco Sánchez García

  • Affiliations:
  • Department of Quantitative and Computational Methods, Polytechnic University of Cartagena, Cartagena, Spain;Department of Quantitative and Computational Methods, Polytechnic University of Cartagena, Cartagena, Spain;Department of Quantitative and Computational Methods, Polytechnic University of Cartagena, Cartagena, Spain

  • Venue:
  • MATH'05 Proceedings of the 8th WSEAS International Conference on Applied Mathematics
  • Year:
  • 2005

Quantified Score

Hi-index 0.00

Visualization

Abstract

In the Queueing Theory, sometimes, it is precise to resort to the simulation of delay phenomena being generated values of entrance and exit in agreement with the different existing models. In order to make this simulation it is possible to resort to certain computer science applications specialized in this type of calculations or to make use of applications of general use like the spreadsheets. In the present work we proved the suitability of this simulation using the own statistical functions of version 2003 of the well-known application Microsoft® Excel. Besides to verify the operation of these functions, those others are being programmed by means of the use of Visual BASIC for Aplicaciones (VBA) that are necessary to have collections all the possibilities and that they are not incorporated by Excel, also proving that fulfills all the requirements that are indispensable for this type of calculations.