EPIC-MAP – Excel based Productivity & Improved Cybersecurity Macro Automation Program
Care Process & Redesign
Singapore Healthcare Management Congress
SingHealth
31 December 2023
To improve productivity by 100% through macro automation in Excel. Macro-based automation significantly enhances efficiency and improves cybersecurity for sensitive data handling.
Year Submitted: 2023
Published Date: 31 December 2023
Tags: Care Process ＆ Redesign, Productivity, Time Saving, Quality Improvement, Workflow Redesign
About this Content
Aims
To improve productivity by 100% through macro automation in Excel.
Background
Manual Excel processes during COVID-19 led to inefficiencies and high workload.
Methods
Developed and implemented three macro scripts for data consolidation, segregation, and file security.
Results
Achieved significant time savings, reducing manual workload by 80%, with financial savings of $124,000 annually.
Conclusion
Macro-based automation significantly enhances efficiency and improves cybersecurity for sensitive data handling.
Lessons Learnt
Automation simplifies repetitive tasks, enhances productivity, and reduces human error.
Additional Information
Singapore Healthcare Management Congress 2023 – 2nd Prize (Human Resource category)
Keywords
Excel Macro Script
Innovators' Details
Innovators' Details
Healthcare Cluster(s) | SingHealth |
Organization(s) Involved | SingHealth Headquarter |
Platform(s) | Singapore Healthcare Management Congress |
Healthcare Professional Group(s) | Healthcare Administration |
Applicable Specialty or Discipline | Healthcare Administrators |
Project Lead(s) | Calvin Lee Kang Rui |
Project Member(s) | John Teo Cheng Su |
Connect with this contributor!
Calvin Lee Kang Rui - singaporehealthcaremanagement@singhealth.com.sg
Project Attachment
C_866_SHHQ_SHM_2023_Excel_based_Productivity_and_Improved_Cybersecurity.pdf