摘要
利用EXCEL VBA自动控制数据透视表结合SpreadSheet法差分建模技术,从科学、高效、实用的角度出发判别分析医院统计数据的性态,既弥补了现行HIS在统计预测分析等方面的不足,又能快速有效的提高医院统计工作质量。
Microsoft EXCEL has already been applied in hospital accounting, but most of them are manual-operated simply applications. This paper presents a method to estimate and analyses the statistics data of the hospital with EXCEL VBA auto-controlled dynamic PivotTable integrated the difference modeling technology. It provides not only a scientific and effective way to improve the quality of hospital statistic, but also supplements the insufficiency of statistical forecast analysis in HIS.
出处
《中国数字医学》
2007年第6期39-40,共2页
China Digital Medicine
基金
安徽省教委自然科学基金资助课题(项目批号:2006KJ133C)