In order to cultivate excellent clinical medical talents with a solid foundation, strong literacy, refined skills, excellent communication abilities, innovative thinking, and a strong focus on practicality, functional...In order to cultivate excellent clinical medical talents with a solid foundation, strong literacy, refined skills, excellent communication abilities, innovative thinking, and a strong focus on practicality, functional experiments have undergone a series of reforms in areas such as constructing new curriculum systems, improving teaching content, updating teaching equipment, introducing new teaching models, and enhancing teaching evaluation systems.展开更多
目的:探讨采用Excel软件快速计算住院患者抗菌药物使用强度的技巧。方法:通过Vlookup函数,查找药品的限定日剂量,计算药品累计用药频度;采用分类汇总的方法自动计算各科室住院患者所有使用抗菌药物的用药频度,进一步得出各科室及全院住...目的:探讨采用Excel软件快速计算住院患者抗菌药物使用强度的技巧。方法:通过Vlookup函数,查找药品的限定日剂量,计算药品累计用药频度;采用分类汇总的方法自动计算各科室住院患者所有使用抗菌药物的用药频度,进一步得出各科室及全院住院患者的抗菌药物使用强度(antibiotics use density,AUD)。结果:Excel软件的Vlookup函数和分类汇总功能大大提高了计算AUD的效率。结论:利用Excel软件相关技巧,可以快速统计各科室及全院住院患者AUD,值得在大型医院推广使用。展开更多
文摘In order to cultivate excellent clinical medical talents with a solid foundation, strong literacy, refined skills, excellent communication abilities, innovative thinking, and a strong focus on practicality, functional experiments have undergone a series of reforms in areas such as constructing new curriculum systems, improving teaching content, updating teaching equipment, introducing new teaching models, and enhancing teaching evaluation systems.
文摘目的:探讨采用Excel软件快速计算住院患者抗菌药物使用强度的技巧。方法:通过Vlookup函数,查找药品的限定日剂量,计算药品累计用药频度;采用分类汇总的方法自动计算各科室住院患者所有使用抗菌药物的用药频度,进一步得出各科室及全院住院患者的抗菌药物使用强度(antibiotics use density,AUD)。结果:Excel软件的Vlookup函数和分类汇总功能大大提高了计算AUD的效率。结论:利用Excel软件相关技巧,可以快速统计各科室及全院住院患者AUD,值得在大型医院推广使用。
