Transformation of routine Work processes with MS Visual Basic for Application (VBA)
Technology
National Healthcare Innovation and Productivity Medals
Agency for Integrated Care - Intermediate and Long Term Care
31 December 2023
To reduce time taken to generate and verify complex Excel reports for ILTC quarterly subvention reports. Automation streamlines processes and enhances productivity, saving time and reducing errors.
Year Submitted: 2023
Published Date: 31 December 2023
Tags: Technology, Digitalisation, Automation
About this Content
Aims
To reduce time taken to generate and verify complex Excel reports for ILTC quarterly subvention reports.
Background
Manual processes for report preparation were time-consuming and error-prone.
Methods
Mapped wasteful steps, implemented VBA for automation, and conducted trials.
Results
Saved $1,527 annually; preparation time reduced from 1,920 to 480 minutes quarterly.
Conclusion
Automation streamlines processes and enhances productivity, saving time and reducing errors.
Lessons Learnt
Engaging users early and iterative development ensure successful adoption.
Keywords
Digitalisation, Automation, Excel VBA
Innovators' Details
Innovators' Details
Healthcare Cluster(s) | Agency for Integrated Care - Intermediate and Long Term Care |
Organization(s) Involved | Ren Ci Hospital |
Platform(s) | National Healthcare Innovation and Productivity Medals |
Healthcare Professional Group(s) | Healthcare Administration |
Applicable Specialty or Discipline | Healthcare Administrators |
Project Lead(s) | Teo Kok Leng |
Project Member(s) | Hoo Hui Chyn |
Connect with this contributor!
Mr. Teo Kok Leng - Dennis_teo@renci.org.sg