Excel软件快速计算住院患者抗菌药物使用强度的技巧探讨  

Investigation on Skills of Rapid Calculation of Antibiotics Use Density in Inpatients by EXCEL

作　　者：张宏亮[1] 黄振光[1] 蒋霞[1] 唐双意[1] 杨玉芳[1] 刘滔滔[1] ZHANG Hongliang HUANG Zhenguang JIANG Xia TANG Shuangyi YANG Yufang LIU Taotao(Dept. of Pharmacy, the First Affiliated Hospital of Guangxi Medical University, Guangxi Nanning 530021, China)

机构地区：[1]广西医科大学第一附属医院药学部,广西南宁530021

出　　处：《中国医院用药评价与分析》2017年第4期445-448,共4页Evaluation and Analysis of Drug-use in Hospitals of China

基　　金：国家自然科学基金项目(No.81460569);广西卫生厅中医药科技专项(No.GZZJ13-17);广西高校中青年教师基础能力提升项目(No.KY2016YB098);广西壮族自治区卫生与计划生育委员会课题(No.Z2012112)

摘　　要：目的:探讨采用Excel软件快速计算住院患者抗菌药物使用强度的技巧。方法:通过Vlookup函数,查找药品的限定日剂量,计算药品累计用药频度;采用分类汇总的方法自动计算各科室住院患者所有使用抗菌药物的用药频度,进一步得出各科室及全院住院患者的抗菌药物使用强度(antibiotics use density,AUD)。结果:Excel软件的Vlookup函数和分类汇总功能大大提高了计算AUD的效率。结论:利用Excel软件相关技巧,可以快速统计各科室及全院住院患者AUD,值得在大型医院推广使用。OBJECTIVE ： To probe into the skills of rapid calculation of antibiotics use density （AUD） in inpatients by EXCEL. METHODS： The defined daily dose system （DDDs） were searched and use density was calculated by Vlookup function. The use density of antibiotics in inpatients of each departments were automatically calculated by classification and collection, furthermore, AUD of various departments and the entire hospitalwas obtained. RESULTS： The application of Vlookup and classification and collection in EXCEL greatly improved the calculation efficiency for AUD. CONCLUSIONS ： Skills in EXCEL can rapidly calculate the AUD of various departments and the entire hospital, which is worthy of promotion in large hospitals.

关 键 词：EXCEL软件 VLOOKUP函数 分类汇总 抗菌药物使用强度 

分 类 号：R978.1[医药卫生—药品]