![](/images/graphics-bg.png)
Computer simulation using excel without programming
Dissertant
Abu Tayih, Ivon Muhammad Awdah
University
Arab Academy for Financial and Banking Sciences
Faculty
The Faculty of Information Systems and Technology
Department
Computer information systems
University Country
Jordan
Degree
Ph.D.
Degree Date
2005
English Abstract
Defining Simulation in its broadest aspect as embodying a certain model to represent the behavior of a system, whether that may be an economic or an engineering one, with which conducting experiments is attainable.
Such a technique enables the management, when studying models currently used, to take appropriate measures and make fitting decisions that would further complement today's growth sustainability efforts, apart from cost decrease, as well as service delivery assurance.
As such, the Computer Simulation technique contributed in cost decline; depicting the "cause & effect", pinpointing task-oriented needs or service delivery assurance, exploring possible alternatives, identifying problems, as well as, proposing streamlined measurable deliverable solutions, providing the platform for change strategy introduction, introducing potential prudent investment opportunities, and finally providing safety net when conducting training courses.
Yet, Simulation Development process is hindered due to many reasons.
Like a rose, Computer Simulation technique, does not exist without thorns ; of which the length, as well as, the communication during the development life cycle.
While Computer Simulation technique proves to be highly specialized, nevertheless, it is task-oriented.
Moreover, it reflects real life problems ; hence, it addresses numerous scenarios with handful of variables.
Not only is it costly, as well as, liable for human judgment, but also, the results are complicated and can be misinterpreted.
Within this context, the researcher attempts to employ a method, using spreadsheets as simulation environment while simplifying the program code, and thus surmounting the aforementioned problems.
The idea of this method is defined as follows; one procedure is defined for beginning any activity, one procedure is defined for ending any activity, and one procedure is defined for any activity process.
This is attainable by using each entity as a parameter being passed from one procedure to another utilizing the Object Oriented programming language Visual Basic.
Consequently, a computer simulation system, E3P-Sim, is realized.
E3P-Sim is programmed based on: Three-Phase Discrete event, Activity Cycle Diagram (ACD), Object Oriented Language, and Microsoft Excel.
E3P-Sim is a general-purpose package, and not a task-oriented package.
E3P-Sim accepts the model, built using interactive ACD on Excel spreadsheet.
As such, E3P-Sim is built using Three-Phase, to bypass the deadlock problems, Object Oriented Language during simulation package programming, in order to simplify the code and relieve the modeler from such chore.
Intentionally, this package uses Microsoft Excel as a reporting tool, since Excel is a popular reporting and analysis tool.
Main Subjects
Information Technology and Computer Science
No. of Pages
297
Table of Contents
Table of contents.
Abstract.
Chapter One : introduction.
Chapter Two : background of simulation.
Chapter Three : methodology.
Chapter Four : simulation packages review.
Chapter Five : computer simulation with enhanced three phases modelling using activity cycle digram : E3P-SIM.
Chapter Six : summary, conclusions and future research.
References.
American Psychological Association (APA)
Abu Tayih, Ivon Muhammad Awdah. (2005). Computer simulation using excel without programming. (Doctoral dissertations Theses and Dissertations Master). Arab Academy for Financial and Banking Sciences, Jordan
https://search.emarefa.net/detail/BIM-316179
Modern Language Association (MLA)
Abu Tayih, Ivon Muhammad Awdah. Computer simulation using excel without programming. (Doctoral dissertations Theses and Dissertations Master). Arab Academy for Financial and Banking Sciences. (2005).
https://search.emarefa.net/detail/BIM-316179
American Medical Association (AMA)
Abu Tayih, Ivon Muhammad Awdah. (2005). Computer simulation using excel without programming. (Doctoral dissertations Theses and Dissertations Master). Arab Academy for Financial and Banking Sciences, Jordan
https://search.emarefa.net/detail/BIM-316179
Language
English
Data Type
Arab Theses
Record ID
BIM-316179