Prescription Auditing and Medication Record Support System for Clinical Pathways Using Microsoft Excel VBA and Google Apps Script

Abstract

The increasing sophistication of medical care demands a reduction in the workload of physicians and an expansion of the roles of pharmacists in ward-based duties. However, advanced pharmacotherapy often relies on pharmacists’ individual knowledge and experience, posing challenges for standardizing operations and ensuring quality. To address these issues, a ward-duty support system was developed using Microsoft Excel VBA and Google Apps Script, incorporating practical audit items based on major clinical pathways in cardiology and urology. The developed system features prescription audit support and medication guidance record functions. A questionnaire survey revealed high utility, particularly in “homogenizing the quality of medication-guidance records.” This suggests that the system’s built-in audit items and record-creation functions can standardize the quality of work, regardless of a pharmacist’s years of experience. This system is expected to reduce the reliance on individual pharmacists’ knowledge and experience, thereby supporting consistent and high-quality prescription audits.