论文部分内容阅读
目的将现有的门诊科室转换为所需要的科室分类。方法取某医院2009年门诊工作报表,用EXCEL中的LOOKUP函数将报表中的门诊科室名称转换为按专科分类的门诊科室名称,再进行门诊人次汇总。结果设置好科室分类的对应关系后,LOOKUP函数快速地将现有报表的科室设置转换为专科科室分类。结论 EXCEL中的LOOKUP函数可以方便地实现科室转换,结合数据透视表能将大量数据按需要进行复杂的分类统计,适应不同的分析要求。
Objective To convert the existing department of outpatient department into the required department classification. Methods Take the outpatient work report of a hospital in 2009, and use the LOOKUP function in EXCEL to convert the name of outpatient department in the report to the outpatient department name classified by specialty, and then make a summary of outpatient attendance. Results Set the correspondence between departmental classification, LOOKUP function quickly convert the existing report of the department settings to the specialist section classification. Conclusion The LOOKUP function in EXCEL can be easily converted into departments, combined with the PivotTable can be a large amount of data required for complex classification statistics to meet different analysis requirements.