Users Guide to the QDE Toolkit Pro

1
Users Guide to the QDE Toolkit Pro
Ch 15 193
May 2, 2002
National Research Conseil national Council
Canada de recherches
Excel Tools for Presenting Metrological
Comparisons byB.M. Wood, R.J. Douglas A.G.
Steele
Chapter 15. Afterthoughts
Final thoughts on balancing rigor and
simplicity...
2
Ch 15 194
Multiple Tables on a Single Page
Running each type of Toolkit Pro macro on a
single worksheet provides a lot of information
regarding your data set. Impressive!
3
Ch 15 195
Multiple Graphs in a Single Workbook
Each NMI in a Key Comparison would like to have
its own Lab View of the Comparison. Heres one
easy way for a Pilot to give it to them... These
files grow to 10s of MB...
With tk_RV0isLab_NewWorksheet, you can quickly
set up an Excel Workbook that has one worksheet
for each Labs View, and its Exclusive
Statistics or pooling distributions.For this
job, you may prefer to plot pair uncertainties
with tk_RVisLab_NewWorksheet...
4
Ch 15 196
Multiple Graphs in a Single Workbook
Each NMI in a Key Comparison would like to have
its own Lab View of the Comparison. Heres
another easy way for a Pilot to give it to
them... These files grow to 10s of MB...
With tk_RVisLab_NewWorksheet, you can quickly set
up an Excel Workbook that has one worksheet for
each Labs View, and its Exclusive Statistics
or pooling distributions.Here, the reference
Labs uncertainty is attributed to the pair
uncertainties. This correctly accounts for
correlations and degrees of freedom
(Welch-Satterthwaite approximation).
5
Ch 15 197
Multiple Graphs on a Single Page
Each NMI in a Key Comparison would like to have
its own Lab View of the Comparison. In
addition, amaster slide can be prepared with
the graphs as Windows enhanced metafiles, so each
graph is frozen although it can be enlarged a
bit. This is about 2.5 MB.
6
Ch 15 198
Multiple Graphs on a Single Page
Each NMI in a Key Comparison would like to have
its own Lab View of the Comparison. Here, each
reference Labs uncertainty is attributed in it
turn to the pair uncertainty, rigorously
including the effects of correlation and degrees
of freedom. In addition, amaster slide can be
prepared with the graphs as Windows enhanced
metafiles, so each graph is frozen although it
can be enlarged a bit.
7
Ch 15 199
Rigor and Simplicity
q The QDE Toolkit Pro can easily create an
impressive worksheet packed with rigorous
information Dedicated experts can use the output
to help shape and justify their conclusions about
a Comparison to other experts q With the
output, you can express conclusions rigorously in
simple terms for a much wider audience On the
basis of this comparison, similar measurements
made by Labi can be expected to agree with those
made by (Labj or a similarly determined KCRV
or...) within QDE, 19 times out of 20.
Important!
8
Ch 15 200
Rigor, Simplicity and MRA Appendix-C CMCs
Using the QDE Toolkit Pro macro
tk_mraQDC_TableBuilder q With its output table,
you can express rigorous advice for your Labs
vote on accepting other Labs CMCs On the
basis of this comparison, for similar
measurements made by Labi, the confidence is XX
for them to agree with our value within their
CMC (yy). q With its output table, you can
also defend your own CMCs.
9
Ch 15 201
Numerical Probability Calculations
The QDE Toolkit Pro Version 2.05 uses numerical
integration for determining some coverage
factors, partly for convenience and partly to be
ready for the possible use of explicit scaled
convolution for combining uncertainty budget
terms numerically. Key comparisons treating all
uncertainty components and covariances
numerically could just fit within the constraints
of Excel but would need modules written in faster
languages to do some operations such as the
numerical deconvolution that would likely be used
to deal with covariances of differences.
10
Ch 15 202
Need More Information?
For more information please do not hesitate to
contact us. QDE Mailing List qde_at_nrc-cnrc.gc.ca
Barry Wood barry.wood_at_nrc-cnrc.gc.ca Rob
Douglas rob.douglas_at_nrc-cnrc.gc.ca Alan
Steele alan.steele_at_nrc-cnrc.gc.ca We intend to
maintain a single distribution list of people
using the Toolkit. Send us your email address
and we will be able to make sure you are updated
with corrections, enhancements, and supporting
documentation. QDE Website for some tutorial
material, FAQs, and for downloading reprints,
the QDE Toolkit and Users Guide files
http//inms-ienm.nrc-cnrc.gc.ca/qde/