Excel自动化模板文件在室间质量评价显示中的应用

Use Excel Automatic Template File to Make the Analysis of External Quality Assessment Results More Easier

利用Excel的数据和图表处理功能,结合其所提供的VBA编程语言,设计一套通用性很强的Excel自动化模板文件,实现室间质量评价(EQA)回报数据的自动化分析,检验项目的个性化排序,并自动制作更易于分析的综合分析图。用Excel自动化模板文件处理EQA回报结果数据,运算准确而迅速,能够实现检验项目的个性化排序,所绘制的EQA回报结果综合分析图更能直观地反映各项目的偏离趋势,系统对硬件的要求较低,适宜在各级医院应用。

Using the powerful data and charts processing capabilities of Excel and the VBA to design a general Excel automatic template file,which can automatic analysis the return data of external quality assessment（ EQA）,and personalize sort the test items,and automatic generate a composite graphic which are more easier to analysis. The Excel automatic template file can automatic process EQA data. It＇ s can also personalize sort the test items. The graphic can directly reflect the project＇s deviation from the trend. The Excel automatic template file is suitable for application at any hospital.