ABSTRACT
OBJECTIVE:To improve the automation of hospital pharmaceutical warehouse management by using Visual Basic for Applications (VBA) language so as to improve work efficiency. METHODS:Through editing VBA language of Microsoft of-fice software,the experience of our hospital was swmmarized,such as letting the computer automatically sort,split and encrypt, pharmaceutical email and track purehase plan. RESULTS & CONCLUSIONS:By adopting VBA programming,our hospital has re-alized automatic splitting of the pharmaceutical purchase plan,sending pharmaceutical shortage warning and automatic warning doc-ument management. Pharmaceutical purchase plans are sent faster and drug distribution to our hospital is becoming more timely. The management of document that have a period of validity is becoming more intelligent. Massive manpower and resoure are saved,and the work efficiency is greatly improved. New ideas and methods for smart warehouse management are provided.
ABSTRACT
OBJECTIVE:To provide reference for promoting the further development of pharmaceutical service in chain phar-macies and the regulation of related departments. METHODS:Field investigation and questionnaire survey were used to investigate the basic situation of pharmaceutical care in 5 chain pharmacies in Chengdu city and analyze the results. RESULTS:In terms of core service,it showed that 2 pharmacies had no suspension of pharmacists license and the pharmacist was not on-the-job;there was significant difference in the medication guidance frequency of pharmacists in those pharmacies(P<0.05);more than 50% sur-veyed consumers received medication guidance when buying drugs in pharmacy B,C and E. In terms of perceived service,3 phar-macies existed illegal drug advertising and 3 existed illegal promotion;drug partitions of all pharmacies were good;service archive material showed best in pharmacy C and worst in pharmacy D;in service advisory zone setting,setting of independent advisory zone was worse. In terms of extended service,5 pharmacies had different preferential ways for memberships except for the prefer-ence in membership day;the unbundling service in those pharmacies was worse,and no pharmacies had no less than 10 unbun-dling varieties. CONCLUSIONS:Pharmaceutical service in chain pharmacies in Chengdu city is barely satisfactory. Pharmacy should strengthen the assessment and management of pharmacists and improve pharmaceutical service,and regulatory authorities strengthen the supervision of advertising and promotion of drugs. What’s more,it is suggested to establish cloud supervision plat-form with the internet information technology,carry out remote service and cloud service and strengthen brand marketing service on the internet to improve the pharmaceutical service levels in chain pharmacies.