|
Scientific paper ID 1604 : 2018/3
![]() APPROACH FOR SIMULATION THE EMPLOYMENT AND DISPATCHING OF AMBULANCE VEHICLES IN EMERGENCY MEDICAL SERVICES SYSTEM (EMS) BASED ON MS EXCEL (VBA)
Teodor Berov, Petya Stoyanova The report examines the problem of traffic simulation and consequently determining the employment of Emergency Medical Assistance vehicles in handling calls randomly distributed over a certain period of time. A new approach is proposed based on the MS EXCEL software program, with maximum use of the capabilities of the Microsoft Visual Basic® for Applications (VBA), object-oriented programming language that is based on the BASIC language for rapid development of applications (RAD) and uses Google Maps ™ for distance and travel data. The simulation model is applied for Sofia, as shown by the results for one working day (300 generated calls). The model features specific phases of movement and stay with certain time frames, according to the medical standard ”Emergency Medicine” for medical triage in making calls, at a number of base stations for outpatient emergency medical care and their area coverage. The strategy for defining variables relating to patient care, along with call origination, is implemented, which leads to greater clarity of the task being created. The main application of the developed computer simulation model is to valuate optimization solutions related to determination of the number of sanitary vehicles and emergency response teams attached to them.
транспорт автомобилен градски спешна медицинска помощtransport urban emergency medical aidTeodor Berov Petya Stoyanova BIBLIOGRAPHY [1] Ministerstvo na Zdraveopazvaneto Naredba № 12 ot 30 dekemvri 2015 g. za utvarzhdavane na meditsinski standart „Speshna meditsina“, obn. DV br.4 ot 15.01.2016 g.. ( [1] Mинистерство на Здравеопазването Наредба № 12 от 30 декември 2015 г. за утвърждаване на медицински стандарт „Спешна медицина“, обн. ДВ бр.4 от 15.01.2016 г.. ) [2] Trendafilov, Z. Analiz na metodi za opredelyane na fazite na svetofarni uredbi.// sp. Mehanika transport komunikatsii, 2017, Sofiya, ISSN 1312-3823. ( [2] Трендафилов, З. Анализ на методи за определяне на фазите на светофарни уредби.// сп. Механика транспорт комуникации, 2017, София, ISSN 1312-3823. ) [3] Berov T.. Implementing The Google Maps API to improve Vehicle Routing Problem: distance/traveltime matrix, XVII SCIentific-expert conference in Railways ‘Railcon’16’. 2016. 13-14.10.2016,Nis, SERBIA, ISBN 978-86-6055-086-8 [4] Lamine, Franck Fontanili, Maria di Mascolo, Hervé Pingaud: Improving the Management of an Emergency Call Service by Combining Process Mining and Discrete Event Simulation Approaches. PRO-VE 2015: 535-546 [5] Trendafilov, Z. Application of simulation and analytical models of recourse planning and locomotive scheduling.// 23 nd International Symposium, June 2015, Žilina, SK. [6] http://www.bernabe.dorronsoro.es/vrp/ |