利用Visual Basic自动编制分析测试报告

傅泽华; 王如海; 孙玉芳; 唐昊冶

doi:10.16495/j.1006-3757.2023.02.009

利用Visual Basic自动编制分析测试报告

doi: 10.16495/j.1006-3757.2023.02.009

中国科学院南京土壤研究所，江苏南京　210008

基金项目: 中国科学院仪器设备功能开发技术创新项目（2018g0024）

详细信息

作者简介:
傅泽华（1994−），女，助理工程师，主要从事土壤与环境分析测试，E-mail：zhfu@issas.ac.cn

通讯作者:
王如海（1980−），男，高级工程师，主要从事土壤与环境分析测试，E-mail：rhwang@issas.ac.cn

中图分类号: O65; TP31
计量
- 文章访问数: 54
- HTML全文浏览量: 6
- PDF下载量: 8
- 被引次数: 0
出版历程
- 收稿日期: 2023-02-27
- 录用日期: 2023-04-12
- 修回日期: 2023-04-12
- 刊出日期: 2023-06-30

Automatic Generating Test Report Based on Visual Basic

Institute of Soil Science, Chinese Academy of Sciences, Nanjing 210008, China

Funds: Technology Innovation Project of Instrument and Equipment Function Development of Chinese Academy of Sciences (2018g0024)

摘要

摘要: 实验室通常以检测报告、校准证书或抽样报告的形式提供测试结果. 实验室应准确、清晰、明确和客观地出具测试结果，并且所有出具的报告应作为技术记录予以保存. 为减轻检测人员因出具检测报告过程繁琐所带来的压力，以Microsoft Visual Basic 6.0为开发工具，通过Visual Basic（VB）对Excel数据进行操作，构建了一个分析测试报告自动编制的软件，能快速、准确的编制分析测试报告. 对仪器设备得到的数据，在Excel中进行复制和粘贴，不需要通过数据库转存，保证了报告编制程序运行的可靠性. 程序提高了报告生成的工作效率，使得分析报告格式标准化，便于归档留存，保证其具有可追溯性.
- 分析测试报告 /
- Visual Basic /
- 自动化编制
Abstract: The Laboratories play a crucial role in providing accurate, unambiguous, and objective results in the form of test reports, calibration certificates, or sampling reports. It is imperative that all reports are maintained as technical records. In order to alleviate the stress of testers due to the cumbersome process of issuing test reports, Microsoft Visual Basic 6.0 was used as a development tool to build a software for the automatic preparation of analysis and test reports through Visual Basic (VB) manipulation of Excel data, which can quickly and accurately prepare analysis and test reports. The data obtained from the instrumentation is copied and pasted in Excel, without the need to dump it through the database, ensured the reliability of the report preparation program operation. The program significantly improves the efficiency of report generation, standardizes the analysis report format, and facilitates archiving and retention to ensure its traceability.
- analysis test reports /
- VB /
- automatically generated

HTML全文

图 1 生成分析测试报告软件的设计流程图

Figure 1. Flow chart of software for automatic generating test report

下载: 全尺寸图片幻灯片

图 2 分析测试报告软件界面

Figure 2. Software interface of automatic generating test report

下载: 全尺寸图片幻灯片

图 3 测试报告的原始数据的示例

Figure 3. Example of original data for test report

下载: 全尺寸图片幻灯片

图 4 生成的测试报告的示例

Figure 4. Example of generated test report

下载: 全尺寸图片幻灯片

参考文献(15)

[1]	任子龙, 刘杰. 基于Visual Basic 6.0的信号发生器自动测试系统[J]. 计测技术,2007,27(5):46-48 doi: 10.3969/j.issn.1674-5795.2007.05.016 REN Zilong, LIU Jie. Automatic testing system of signal generator based on Visual Basic 6.0[J]. Metrology & Measurement Technology,2007,27 (5):46-48. doi: 10.3969/j.issn.1674-5795.2007.05.016
[2]	王俭朴. 基于Visual Basic 6.0的数据采集处理系统及应用[J]. 工业控制计算机,2005,18(7):3-4 doi: 10.3969/j.issn.1001-182X.2005.07.002 WANG Jianpu. Data acquisition and disposal system based on Visual Basic 6.0 and its application[J]. Industrial Control Computer,2005,18 (7):3-4. doi: 10.3969/j.issn.1001-182X.2005.07.002
[3]	向明, 罗贤海. 基于Visual Basic的优化设计软件开发[J]. 机械研究与应用,2012,25(1):131-133 doi: 10.3969/j.issn.1007-4414.2012.01.050 XIANG Ming, LUO Xianhai. Development of optimization design software based on Visual Basic[J]. Mechanical Research & Application,2012,25 (1):131-133. doi: 10.3969/j.issn.1007-4414.2012.01.050
[4]	杨桂华. 可视化编程语言Visual Basic程序设计的特点及教学方法[J]. 内蒙古民族大学学报,2008,14(4):32-33 YANG Guihua. Characteristics and teaching methods of Visual Basic programming language[J]. Journal of Inner Mongolia University for Nationalities,2008,14 (4):32-33.
[5]	Al-Juboori A M, Guven A. Hydropower plant site assessment by integrated hydrological modeling, gene expression programming and Visual Basic programming[J]. Water Resources Management,2016,30 (7):2517-2530. doi: 10.1007/s11269-016-1300-3
[6]	Rossato S L, Fung T T, Rodrigues M P. A data entry system for dietary surveys based on Visual Basic for applications programming[J]. Journal of the Academy of Nutrition and Dietetics,2017,117 (8):1165-1170. doi: 10.1016/j.jand.2016.08.004
[7]	Dinesh A C, Markose V J, Jayappa K S. Linfo-a Visual Basic program for lineament density, frequency and intersection density analysis[J]. Earth Science Informatics,2014,7 (3):197-203. doi: 10.1007/s12145-013-0134-2
[8]	Escobar R, Pérez-Herrera C A. Low-cost USB interface for operant research using Arduino and Visual Basic[J]. Journal of the Experimental Analysis of Behavior,2015,103 (2):427-435. doi: 10.1002/jeab.135
[9]	Kumar N, Pandey K P. A Visual Basic program for predicting optimum gear and throttle position for best fuel economy for 32kW tractor[J]. Computers and Electronics in Agriculture,2015,119 :217-227. doi: 10.1016/j.compag.2015.10.024
[10]	Duy N N. Potential of Visual Basic 6.0 in teaching and studying physics[J]. New Physics:Sae Mulli,2022,72 (7):512-524. doi: 10.3938/NPSM.72.512
[11]	Ismail Ozkaya S. SUPERPOSE-An excel Visual Basic program for fracture modeling based on the stress superposition method[J]. Computers & Geosciences,2014,64 :41-51.
[12]	Suarez-Navarro J A, Pujol L, Suarez-Navarro M J, et al. A method for gamma background subtraction using Visual Basic for applications code with Microsoft Excel[J]. Journal of Radioanalytical and Nuclear Chemistry,2019,319 (3):1159-1163. doi: 10.1007/s10967-018-06411-7
[13]	Torlapati J, Prabhakar Clement T. Benchmarking a Visual-Basic based multi-component one-dimensional reactive transport modeling tool[J]. Computers & Geosciences,2013,50 :72-83.
[14]	Wakita Y, Yamanaga T, Katayama Y, et al. Development of dose management software using Visual Basic for applications and dose evaluation in the field of nuclear medicine[J]. Nihon Hoshasen Gijutsu Gakkai Zasshi,2022,78 (11):1273-1281. doi: 10.6009/jjrt.2022-1298
[15]	张海涛, 许光泉. 基于Visual Basic 6.0的含水层水文地质参数求取软件的开发及应用[J]. 煤田地质与勘探,2018,46(2):105-110 doi: 10.3969/j.issn.1001-1986.2018.02.016 ZHANG Haitao, XU Guangquan. The development and application of aquifer hydrogeolgical parameter calculation software based on Visual Basic 6.0[J]. Coal Geology & Exploration,2018,46 (2):105-110. doi: 10.3969/j.issn.1001-1986.2018.02.016