The Application of Excel based Dynamic Pivot Table for Data Statistics of Infectious Disease Surveillance

Jing YANG,Yurong QIU,Lu SU,Qiang ZHANG
2018-01-01
Abstract:Objective To establish an automatic statistical reporting system of infectious disease monitoring data based on Excel dynamic Pivot Table technology.Methods Based on the table processing,function and macros command and pivot table tools in Excel 2007,the automatic statistical reporting system was established for monitoring data import,logical discrimination,collection and automatic update.Results By using this automatic statistical reporting system,the dynamic statistical report of the epidemic monitoring data could be represented as the report form by the simple operation.Conclusion The statistical system is aeasy-to-use tool with the automatic inspection,summary and dynamic report generation,which can improve the efficiency and quality of data analysis.
What problem does this paper attempt to address?