Spreadsheet interface for transfer of drug-use data from a mainframe to a personal computer

Area of Science:

• Health Informatics
• Pharmacy Automation
• Data Management

Background:

• Manual data transfer from hospital mainframe systems to pharmacy databases is time-consuming and prone to errors.
• Efficient management of drug-use data is critical for inventory control, cost analysis, and patient safety.

Purpose of the Study:

• To describe the development of an automated system for transferring drug-use data from a hospital mainframe to a pharmacy computer.
• To evaluate the time-saving benefits of using spreadsheet macros for data import and processing.

Main Methods:

• Drug-use data were downloaded from the mainframe as an ASCII file on a floppy disk.
• Spreadsheet macros were developed to import, arrange, and process the data for drug use and cost calculations.
• Formulas were implemented to manage unused items and ensure data accuracy.

Main Results:

• The automated system successfully imported and processed drug-use data without manual input.
• The use of macros and formulas significantly reduced the time required for data handling.
• Pharmacists experienced substantial time savings due to the elimination of manual data entry.

Conclusions:

• Automated data transfer using spreadsheet macros is an effective method for managing hospital drug-use information.
• This approach enhances efficiency in pharmacy data management, allowing pharmacists to focus on other critical tasks.
• The developed system offers a practical solution for optimizing data workflows in healthcare settings.