环境与健康杂志
環境與健康雜誌
배경여건강잡지
JOURNAL OF ENVIRONMENT AND HEALTH
2001年
2期
113-114
,共2页
于明哲%杨惠芳%李丽涛%马永平
于明哲%楊惠芳%李麗濤%馬永平
우명철%양혜방%리려도%마영평
电子表格%粘贴函数%邮件合并
電子錶格%粘貼函數%郵件閤併
전자표격%점첩함수%유건합병
利用计算机应用软件Excel 97电子表格除可进行一些简单计算外,还可利用其“粘贴函数”功能进行“相关系数”、样品含量等比较复杂的运算。并可在电子表格中保存检验结果便于统计和总结。应用Word 97应用软件按照检验报告的规定格式制作“邮件合并”主文档,以相关电子表格作为数据源。利用“邮件合并”功能直接把电子表格中的数据填入固定的检验报告格式内,自动生成并打印出检验报告,以实现检验结果统计和报告的自动化。
利用計算機應用軟件Excel 97電子錶格除可進行一些簡單計算外,還可利用其“粘貼函數”功能進行“相關繫數”、樣品含量等比較複雜的運算。併可在電子錶格中保存檢驗結果便于統計和總結。應用Word 97應用軟件按照檢驗報告的規定格式製作“郵件閤併”主文檔,以相關電子錶格作為數據源。利用“郵件閤併”功能直接把電子錶格中的數據填入固定的檢驗報告格式內,自動生成併打印齣檢驗報告,以實現檢驗結果統計和報告的自動化。
이용계산궤응용연건Excel 97전자표격제가진행일사간단계산외,환가이용기“점첩함수”공능진행“상관계수”、양품함량등비교복잡적운산。병가재전자표격중보존검험결과편우통계화총결。응용Word 97응용연건안조검험보고적규정격식제작“유건합병”주문당,이상관전자표격작위수거원。이용“유건합병”공능직접파전자표격중적수거전입고정적검험보고격식내,자동생성병타인출검험보고,이실현검험결과통계화보고적자동화。
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.