Since the start of COVID19 and the opening of PKRC(Pusat Kuarantin dan Rawatan COVID19), the bilik gerakan has been coping manually and faced difficulty in managing the database of patients and bed update. This project was started to reduce the administrative burden of manually updating bed status and report data. The initial reporting used Microsoft Excel. Due to this, we created a system with readily available resources due to limitations of equipments in PKRC. This system requires the update of ONE masterlist data which automatically generates reports & automatically provides real time updates of bed status on a map with the exact floor plan. This has been used by the PKRC bilik gerakan and remarkably increased efficiency, reducing a work process from 5 hours to 5 minutes. With the same system, we also created a tool for autogenerated clerking, reviewing and discharging patients. This helps to ensure safety of healthcare worker by reducing exposure time to COVID patients.
Microsoft Excel using formulas and conditional formatting
Achievement: Reduce total work process of tallying data from 5 hours to 5 minutes Users: 3 PKRC (PKRC Gambang capacity of 1200+ patients, PKRC ILKKM capacity of 300+ patients, PKRCS Azzahra capacity of 188 patients)
Nama Kumpulan: Mizanventures
Ketua Projek: Dr Alia Nadhirah binti Hj Ahmad Fakhri
Jumlah Ahli Pasukan: 2
Ringkasan Kumpulan / Syarikat
Dr Alia Nadhirah is a medical doctor working in Infection Control Unit, Hospital Tengku Ampuan Afzan. She was recently deployed to work in Bilik Gerakan PKRC. During her deployment, she realized the administrative burden and limitation of PKRC due to manual system and no HIS (Hospital Information System) available. The inefficiencies of untallied data started this project. Dr Muhammad Izzad is a medical doctor working in Orthopaedic Department, Hospital Tengku Ampuan Afzan. He contributed to the formation of autogenerated clinical documentation for healthcare workers.