Using VBA to Construct a Operation Room Nurse Scheduling System

• Main Authors: Hsin-Hua Chen, 陳信樺
• Other Authors: Chih-Hung Lin
• Format: Others
• Language: zh-TW
• Published: 102
• Online Access: http://ndltd.ncl.edu.tw/handle/69196180568571573351

碩士 === 南台科技大學 === 行銷與流通管理系 === 101 === Technology evolves as time goes by, and so does medical resources that are significantly crucial to human beings, including medical environment, equipment and skills. In hospitals, the one who interacts with patients most frequently and who has a great effect on their emotion as well as illness condition is the nursing staff. Moreover, reasons like working overtime, dealing with trivial job content, meeting complex scheduling problems, being on duty even in holidays, and getting unhealthier and more pressure on account of work are recognized as factors that lead to nurses’ poorer working performance. Scheduling issues have greater impact on the staff working quality among the elements above. Nurses would be in better mood once they are satisfied with the shifting outcome and could rest enough, then they could deliver patients the better service. The majority of hospitals adopt manual scheduling, yet, such approach takes managers too much time and might bring about argument as staff is not content with the shifting result. In order to improve the concern, technology should be taken advantages of. As a result, the research conducts a case study on the scheduling issue of nurses in an operation room, developing a system with VBA of Excel. A hospital in Tainan would be chosen as a research background. Furthermore, interviews in person with the nurses would be held so as to help analyze the factors that might influence the shifting result and help managers deal with scheduling problems more efficiently and accurately. Meanwhile, tests and adaptations will be carried out for decreasing the mistakes and errors that might happen.