处方评价工作中Excel软件抽样方法探讨OACSCDCSTPCD
Exploration of Excel Sampling Method of Prescription Evaluation
目的:为减少处方抽样工作量提供参考.方法:以我院2010年3月16日门诊成人处方1 650张为例,根据医院信息系统(HIS)软件提供的门诊处方数据特点,演示利用Excel软件排序、自动筛选、填充等差序列和函数VLOOKUP等功能自动随机等距抽样100张处方的操作步骤.结果与结论:该操作在15分钟内完成了处方抽样,极大简化了处方数据的前期处理和随机抽样的工作量,具有推广和交流意义.
OBJECTIVE: To provide reference for decreasing workload of prescription sampling. METHODS: According to the characteristics of initial data from HIS software, the steps of equal interval sampling of 100 prescriptions from 1 650 adult outpatient prescriptions of our hospital in Mar. 16, 2010 with excel functions, such as sort, autofilter, arithmetic sequence, VLOOK-UP, were summarized and demonstrated. RESULTS & CONCLUSIONS: The exampling can be com…查看全部>>
方欢;曾宏辉;储德节
复旦大学附属金山医院,上海200540复旦大学附属金山医院,上海200540复旦大学附属金山医院,上海200540
医药卫生
Excel软件处方点评随机抽样数据处理
Excel software Prescription evaluation Randomized sampling Data processing
《中国药房》 2012 (5)
466-468,3
评论