| 引用本文： |
-
吴月强,杨英梅,廖海燕.Excel VBA在岩石矿物分析质量管理中的应用[J].广西科学院学报,2006,22(S1):494-496. [点击复制]
- WU Yue-qiang,YANG Ying-mei,LIAO Hai-yan.Application of Excel VBA in Quality Control of Rock and Mineral Analysis[J].Journal of Guangxi Academy of Sciences,2006,22(S1):494-496. [点击复制]
|
|
| 摘要: |
| 利用Excel VBA强大的数据处理功能,设计一个实验室岩石矿物分析质量管理系统。该系统依据样品测定结果的相对双差与允许相对双差的对比,采用修正系数选择法及含量单位选择法,不但能适用不同的矿种、不同的测试项目测定结果的质量评价,而且适用不同含量级别的测定结果的质量评价。同时,系统还实现了检测结果合格率的自动统计。 |
| 关键词: 岩矿分析 质量管理 计算机 电子表格宏 |
| DOI： |
| 投稿时间：2006-07-26 |
| 基金项目: |
|
| Application of Excel VBA in Quality Control of Rock and Mineral Analysis |
|
WU Yue-qiang, YANG Ying-mei, LIAO Hai-yan
|
| (Guangxi Research Center of Geoanalysis, Nanning, Guangxi, 530023, China) |
| Abstract: |
| The powerful data processing functions of Microsoft Excel VBA were used to design a quality control system for laboratory rock and mineral analysis.In contrast with Relative-difference and Limit Relative-difference,by means of selection of Modified,Different Grade of Concentration,the system can not only determine the quality of Analytical result for different elements in different mineral,but also for different content levels.It realizes automatic accumulating of the Analytical result eligible-rate at the same time. |
| Key words: rock and mineral analysis quality control computer Excel VBA |
