| Excel2007函数在矿产测试质量管理中的应用 |
| |
| 引用本文： | 廖丽荣.Excel2007函数在矿产测试质量管理中的应用[J].云南地质,2009,28(4):455-461. |
| |
| 作者姓名： | 廖丽荣 |
| |
| 作者单位： | 国土资源部昆明矿产资源监督检测中心,昆明,650218 |
| |
| 摘 要： | 利用Excel2007中的函数和图表功能编制一系列公式，适合DZ／T0130—2006规范要求，自动计算地质样品检测结果及其合格率、报出率、△LgC值、相对偏差RSD％和RE％值，自动实现“四舍六入”修约。
|
| 关 键 词： | Excel函数 质量监控公式 自定义内部函数 四舍六入五凑偶 |
THE APPLICATION OF EXCEL 2007 FUNCTION IN THE MANAGEMENT OF TESTING QUALITY OF MINERAL RESOURCES |
| |
| LIAO Li-rong.THE APPLICATION OF EXCEL 2007 FUNCTION IN THE MANAGEMENT OF TESTING QUALITY OF MINERAL RESOURCES[J].Yunnan Geology,2009,28(4):455-461. |
| |
| Authors: | LIAO Li-rong |
| |
| Institution: | LIAO Li-rong (Kunming Supervision ＆ Inspection Center of Mineral Resources, Ministry of Land Resources, Kunming 650218 ) |
| |
| Abstract: | A series of formulas have been set according to the function and diagram in Excel 2007, which can meet the requirement of DZ/T 0130 -2006 norm. In utilization of these formulas, the testing result of geological sample, qualicification rate, reportable rate, △ LgC, relative error RSD% and RE% can be automatically calculated and the ＂rounding off＂ will be automatically realized. |
| |
| Keywords: | Excel Function Formulas of Quality Control Self - Definition Analysis of Rock ＆ Mineral |
| 本文献已被 维普 万方数据 等数据库收录！ |
