| 利用计算机对卫生检验结果进行统计和报告 |
| |
| 引用本文： | 于明哲,杨惠芳,李丽涛,马永平. 利用计算机对卫生检验结果进行统计和报告[J]. 环境与健康杂志, 2001, 18(2): 113-114 |
| |
| 作者姓名： | 于明哲 杨惠芳 李丽涛 马永平 |
| |
| 作者单位： | 宁夏银川市卫生防疫站 |
| |
| 摘 要： | 利用计算机应用软件Excel97电子表格除可进行一些简单计算外， 可利用其“粘贴函数”功能进行“相关系数”、样品含量等比较复杂的运算。并可在电子表格中保存检验结果便于统计和总结。应用WORD97应用软件按照检验报告的规定格式制作“邮件合并”主文档，以相关电子表格作为数据源。利用“邮件合并”功能直接把电子表格中的数据填入固定的检验报告格式内，自动生成并打印出检验报告，以实现检验结果统计和报告的自动化。
|
| 关 键 词： | 电子表格 粘贴函数 邮件合并 卫生检验 检验结果统计 检验报告 数据处理 |
| 文章编号： | 1001-5914(2001)02-0113-02 |
| 修稿时间： | 2000-06-20 |
Application of Computer in Statistics and Reports of Results of Hygienic Detection |
| |
| YU Ming zhe,YANG Hui fang,LI Li tao,et al Yinchuan Sanitation and Anti epidemic Station. Application of Computer in Statistics and Reports of Results of Hygienic Detection[J]. Journal of Environment and Health, 2001, 18(2): 113-114 |
| |
| Authors: | YU Ming zhe YANG Hui fang LI Li tao et al Yinchuan Sanitation Anti epidemic Station |
| |
| Affiliation: | YU Ming zhe,YANG Hui fang,LI Li tao,et al Yinchuan Sanitation and Anti epidemic Station,750001 |
| |
| Abstract: | The Microsoft Excel 97 electronic table could be used not only for simple calculation,but also for some more complicated calculation,such as correlation coefficient and content of a certain material in detected samples etc.by its paste function The detection data could be saved in electronic tables for statistics and reports The main documents of mail combination were made by Word97 software according to the pattens of detection reports and based on the data of related electronic tables as imformation sources The technicians could fill in fixed detection reports directly with the data saved in related electronic tables by means of the function of mail combination,and then the terminal detection reports could be completed and printed automatically So the automation of statistics and reports in laboratories was realized |
| |
| Keywords: | Electronic table Paste function Mail combination |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
