Facilitating drug-use evaluation with spreadsheet software.

Area of Science:

• Pharmacoeconomics
• Health Informatics
• Clinical Pharmacy

Background:

• Drug-use evaluation is crucial for optimizing patient outcomes and healthcare costs.
• Manual drug-use evaluations can be time-consuming, prone to errors, and inconsistent.
• Dipyridamole, a widely prescribed medication, was selected due to frequent use and potential for questionable indications.

Purpose of the Study:

• To describe the application of a personal computer spreadsheet program for drug-use evaluation.
• To assess the efficiency and accuracy of using spreadsheet software in determining appropriate drug use.
• To explore the potential for non-pharmacist personnel to conduct data entry for drug-use evaluations.

Main Methods:

• Utilized Lotus 1-2-3, a spreadsheet program, to automate drug-use evaluation.
• Developed criteria for appropriate drug use that were translated into conditional logic statements within the spreadsheet.
• Entered patient data into the spreadsheet, allowing for simultaneous assessment against predefined criteria.

Main Results:

• The spreadsheet program facilitated rapid and accurate drug-use evaluations.
• Automated data entry and criteria checking proved more consistent than manual methods.
• The system allowed for efficient data extraction for further analysis of drug-use patterns.
• Non-pharmacist personnel could perform data entry, freeing up pharmacist time.

Conclusions:

• Personal computer spreadsheet programs are effective tools for drug-use evaluation.
• Implementing spreadsheet software enhances the speed, accuracy, and consistency of medication appropriateness assessments.
• This technological approach can improve the efficiency of drug-use evaluation processes within healthcare settings.