巧用Excel VBA开发体温检测统计报表软件  

Use Excel VBA to Develop Statistical Reporting Software for Temperature Detection

作　　者：马致明[1] 陈兴 林雨萌 MA Zhi-ming;CHEN Xing;LIN Yu-meng(School of Computer Science and Technology of Xinjiang Normal University,Urumqi 830054,China)

机构地区：[1]新疆师范大学计算机科学技术学院,新疆乌鲁木齐830054

出　　处：《电脑知识与技术》2020年第33期209-211,共3页Computer Knowledge and Technology

基　　金：新疆维吾尔自治区教学改革与研究项目“基于大数据的高校学生学业成绩预警分析”(ZJG2019-11)。

摘　　要：为了有效地检索体温测温系统产生的大量数据,方便每日统计和分析,更好地做好学校新冠肺炎防疫工作,利用Ex⁃cel VBA开发了体温检测统计报表软件并投入使用,可统计所需的各种数据,并生成体温检测排行榜报表和体温检测报告单,相关设计思路及制作技术做了详细的介绍。In order to effectively retrieve a large number of data from the temperature measurement system,facilitate daily statistics and analysis,and do a better job in school epidemic prevention of Covid 19,a statistical report software for body temperature detection was developed and put into use by using Excel VBA software development technology.The software can make statistics of all kinds of data required,and generate the ranking report of temperature detection and the report sheet of temperature detection.Related design ideas and techniques are introduced in detail.

关 键 词：体测检测 统计报表 EXCEL VBA编程 数据库 检索 

分 类 号：TP311[自动化与计算机技术—计算机软件与理论]