摘要
目的 :提取医院信息管理系统中的相关数据,利用Excel快速便捷的制定药品计划。方法 :从医院信息管理系统中导出各部门的销售数据,设置Excel表格中公式,使之能够快速的提取数据,从而快速、便捷的计算出应采购量、部门发放量、库房留存量。通过对改进前、后相关指标进行比较,评价改进效果。结果 :Excel表格能够根据要求快速准确的对于目标药品生成采购计划。结论 :利用基于Excel表格的药品计划自动生成设计,可有效的节约计划出具时间,在控制库存量、提高周转率方面具有重大意义。
Objective: To extract relevant data from the hospital information management system and use Excel to formulate drug plans quickly and conveniently. Methods: The sales data of various departments were derived from the hospital information management system, and the formulas in Excel table were set up to extract the data quickly and conveniently, so as to calculate the amount purchased, department distribution amount and warehouse reserve amount quickly and conveniently. The improvement effect was evaluated by comparing the relevant indexes before and after improvement. Results: Excel spreadsheets can quickly and accurately generate purchasing plans for targeted drugs as required. Conclusion: The use of Excel spreadsheets-based drug plans to automatically generate designs can effectively save time for planning, and is of great significance in controlling inventories and improving turnover rates.
引文
[1]吴颖坤,张健,沈烽,等.我院药品采购管理模块的改进与应用[J].中国药房,2016,27(22):3099-3101
[2]国务院办公厅.国务院办公厅关于城市公立医院综合改革试点的指导意见[S].国办发[2015]38号.2015-05-17.
[3]曹吉龙.医院HIS药品采购过程管理系统的设计与实现[D].沈阳:东北大学,2012.
[4]彭必新,张玉星,黄芳.对医院药品采购上实施零库存的探讨[J].中国医药指南,2012,10(12):382-383.
[5]徐志霞,刘玲,杨西涛. Excel自动核对同步预警管理急救药品物品的设计在神经内科病区中的应用[J].中国实用神经疾病杂志,2015,18(22):112-113
[6]宋毅斐,鹿岩,孙世光.基于库存模型法的药品采购与库存控制策略[J].中国药房,2016,27(1):70-73.
[7]杨艳,陈勇.药库零库存信息化管理模式建设与实践[J].中国医疗设备,2016,31(9):163-164.
[8]谢沂伯.医院数字化药库管理系统模型研究[J].中国数字医学,2014,9(2):2-4