Discussion on the Application of Excel in Integrated Inpatient Pharmacy Inventory
The integration of inpatient pharmacy is a management mode of unified management of inpatient pharmacy and pharmacy intravenous admixture services(PIVAs).The inventory of the conventional integrated inpatient phar-macy is a linear process.It is usually necessary to perform a static inventory after the pharmacy system stops dispens-ing.However,there is a multi-bit storage of drugs during the inventory,the data needs to be manually calculated,and the inventory error rate is high.According to the characteristics of the integrated pharmacy workflow,Suzhou Hospital Affiliated to Nanjing University Medical College optimizes the process of inventory,flexibly uses Excel function and VBA function,reduces the labor cost of pharmacy,improves the work efficiency,and reduces the error caused by manual operation and statistics.
万方数据
维普
