摘要
利用Excel2007中的函数和图表功能编制一系列公式,适合DZ/T0 130-2006规范要求,自动计算地质样品检测结果及其合格率、报出率、ΔLgC值、相对偏差RSD%和RE%值,自动实现"四舍六入"修约。
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.
出处
《云南地质》
2009年第4期455-461,共7页
Yunnan Geology
