Development and Application of Information System for Rational Drug Use Indexes Based on Excel VBA Technology under the Background of Per-formance Appraisal of National Tertiary Public Hospitals
OBJECTIVE To construct an information system for performance appraisal of rational drug use indi-cators in national tertiary public hospitals,improve the statistical efficiency of appraisal data,and ensure the integrity and accuracy of important data in the statistical process.METHODS Information pharmacist analyzed the defini-tion,calculation method,significance and connotation of evaluation indexes of rational drug use in the performance appraisal of national tertiary public hospitals.And then,Information pharmacist wrote self-developed calculator of ap-praisal indexes based on Excel VBA programming technology,and established an information system of related indica-tors of rational drug use through the comparison and verification of data over the years.The time and accuracy of con-ventional statistical method and self-developed statistical method were compared for 6 months.RESULTS After the application of Excel VBA programming technology,the accuracy of data reporting was improved to 100％,and the time of data statistics was reduced to 10 minutes.CONCLUSION The information system for performance appraisal of rational drug use indexes of national tertiary public hospitals built by using Excel VBA technology has high work efficiency and data accuracy,which can greatly reduce the workload and work intensity of staff.VBA language is a supplement to the hospital information management system,also can provide more practical data decision-making ref-erence for the refinement level of pharmacy administration.
Excel VBARational drug use indexpharmacy administrationPerformance appraisal of national tertiary public hospi-talsInformation pharmacist
万方数据
维普
