Since the pandemic, quarantining positive patients is a means to reduce the transmission of virus. However, the mass volume of admissions requires an efficient data management. The Operations Room (Bilik Gerakan) in COVID-19 Quarantine centres use Microsoft Excel but updating is still being done manually, which requires copying and pasting into bed status spreadsheets and census spreadsheets. This method has contributed to a lot of errors.

We love developing administrative solutions for hospitals and healthcare centres which can be easily used and implemented. Our project for data management is the development of IBEDS: Integrated Bed Entry & Database System.

We developed an Excel spreadsheet template with formulas and conditional formattings. It requires the update of ONE masterlist which will subsequently automatically update the bed status and autogenerate the census.

Our aim is to:

(1) Reduce administrative burden and increase efficiency
(proven to reduce work of 5 hours to 5 minutes!)

(2) Ease persons-in-charge to instantly see bed occupancy and availability

(3) Ensure patient safety with swifter bed assignment

(4) Allow anyone to use it whether IT or non-IT based centre as Microsoft Excel can be readily used.