Abdominal surgery process modeling frameworkfor simulation using spreadsheets

Mileva Boshkoska, BIljana, Damij, Talib, Jelenc, Franc and Damij, Nadja (2015) Abdominal surgery process modeling frameworkfor simulation using spreadsheets. Computer Methods and Programs in Biomedicine, 121 (1). pp. 1-13. ISSN 0169-2607

Abdominal Surgery process modelling framework.pdf - Published Version
Available under License Creative Commons Attribution Non-commercial No Derivatives 4.0.

Download (3MB) | Preview
Official URL: https://doi.org/10.1016/j.cmpb.2015.05.001


We provide a continuation of the existing Activity Table Modeling methodology with a modu-lar spreadsheets simulation. The simulation model developed is comprised of 28 modelingelements for the abdominal surgery cycle process. The simulation of a two-week patientflow in an abdominal clinic with 75 beds demonstrates the applicability of the methodol-ogy. The simulation does not include macros, thus programming experience is not essentialfor replication or upgrading the model. Unlike the existing methods, the proposed solu-tion employs a modular approach for modeling the activities that ensures better readability,the possibility of easily upgrading the model with other activities, and its easy extensionand connectives with other similar models. We propose a first-in-first-served approach forsimulation of servicing multiple patients. The uncertain time duration of the activities ismodeled using the function “rand()”. The patients movements from one activity to the nextone is tracked with nested “if()” functions, thus allowing easy re-creation of the processwithout the need of complex programming.

Item Type: Article
Uncontrolled Keywords: Business process management, spreadsheets, activity table modeling technique, Simulations
Subjects: G400 Computer Science
G500 Information Systems
Department: Faculties > Business and Law > Newcastle Business School
Depositing User: Dr Nadja Damij
Date Deposited: 23 Jan 2017 14:46
Last Modified: 31 Jul 2021 16:16
URI: http://nrl.northumbria.ac.uk/id/eprint/29272

Actions (login required)

View Item View Item


Downloads per month over past year

View more statistics