UncertaintyToolbox™Addin for Microsoft® Excel® 32Bit 2010, 2013 & 2016
Current Version 4.1 Released 1-Feb-2018
Hello, my name is James Jenkins, and when it comes to UncertaintyToolbox™, simply put, I built it and continue to improve it and most importantly, I use it. As an analyst, I have probably used it more than anyone else. From my work at NASA, to assisting hundreds of laboratories world-wide, I have put this software to the test over and over again. The more I used it, the more time saving features I added. You could say, this software evolved while on the job.
Here is where I am supposed to tell you about the software, features, comparisons to others, etc. But the first thing people notice about UncertaintyToolbox™ is that it is different in many ways. It's nothing like traditional packaged commercial software, and once you discover the benefits of these "differences", you will be glad it's different.
HOW & WHY IS IT SO DIFFERENT?
To begin with, we don't consider ourselves to actually be in the “Software Business”, but rather, in the business of developing “Software Based Solutions” for modern laboratories to use in meeting the laboratory competency requirements as put forth via ISO/IEC17025 Laboratory Accreditation. It could be because I am a Metrologist, a consultant in measurement science, programming is just a means to an end for me, so I built what I wanted, ignoring the typical "Software Business" product model.
THE "SHOW YOUR WORK" DIFFERENCE
One of the major differences is that all the math used in our Templates is deliberately kept in the worksheets and viewable for appropriate assessment, eliminating the need for elaborate "validation". In any practical science application, “show your work” is a fundamental practice, which is often hindered by math based software that treats the applied math as “proprietary”. We refer to these products that come with a "Trust Me" requirement as “Black Box Software”.
In the case of measurement uncertainty analysis, according to a defined method (ISO GUM Method), of which the result and process of arriving at the result, is to be assessed by an independent auditor (as per Laboratory Accreditation Requirements), “Show your Work” matters. In fact, showing your work is required for all values presented on the laboratories "Scope of Accreditation"! With UncertaintyToolbox™, ALL applied math is deliberately put into the Template worksheets and made visible for evaluation as well as understanding of the applied process.
RELIABLE MATH ENGINE
Besides, exposing all of our math for review, another major difference, is instead of using some economical, remote 3rd party math engine, we choose the math engine used by many National Metrology Institutes; Microsoft® Excel®. And by designing our product in Excel®, we gain the advantage of allowing users to expand the product, such as, with use of Custom Industry Specific Templates.
All of this explains why UncertaintyToolbox™ is often given as the example of what type of analysis report is required for Laboratory Accreditation to ISO/IEC17025. Plus, we do not place restrictions in the provision of the resulting analyses, built with our templates in Microsoft® Excel®, to your assessor or any other reviewers. UncertaintyToolbox™ reports consist of an Excel® Workbook containing all the math applied in arriving at the given result, as it should be.
Quametec's Measurement Uncertainty Class, is deemed by many in the industry to be the best training available for those needing to compute measurement uncertainties on a regular basis. Unfortunately, it is also one of the most expensive courses, but that is due to several good reasons;
- Class size is limited to ensure each and every attendee successfully learns how to analyze the uncertainty of measurement results.
- The class is three days long, instead of the typical one or two day "Basic Training" offered by AB's and others.
- Tuition includes After-Class Private Tutoring with the Instructor.
NO JOB TOO BIG
With the mathematical power of Microsoft® Excel® combined with our custom designed template tools and interface that provide automatic linking from one budget to up to 25 sub-budgets, each with up to 25 entries and the ability to auto-link from each of those to 25 other sub-budgets, etc. ...well, you get the picture. UncertaintyToolbox™ has been designed to be able to compute the measurement uncertainty for any measurement process in known existence. Should we find that this software is unable to compute a measurement process due to any limitation in the design of the software, we will initiate corrective action immediately.
USE WITH CONFIDENCE
With "Black Box" type software, one can only put in numbers that produce known calculated results in an effort to "validate" the software calculations. UncertaintyToolbox™ is unique in several ways which affect the traditional approach to validation. The software is designed to allow the user to view all the formulas being used and calculated by the Excel® math engine. Microsoft® Excel® is used by millions of businesses, as well as many universities worldwide and its math engine is considered suitably validated for use at National Laboratories and Government Institutions. This leaves only the correctness of the formulas used in the "Master Templates", which are viewable in any output analysis.
Currently, UncertaintyToolbox™ is accepted for use in legal metrology in North America and is recognized by numerous Accrediting Bodies as being suitably validated and acceptable for use in meeting the requirements of ISO/IEC17025. Therefore, no user validation of the calculations are needed per ISO/IEC17025, due to its' unique viewable-formulas design and being widely used in the metrology industry.
FUNCTIONAL DESIGN OVERVIEW
UncertaintyToolbox™ is an add-in for Microsoft® Excel®, providing User Forms, Wizards and Templates, designed to assist the measurement uncertainty analyst in modeling any measurement performed by mankind, in accordance with the ISO “Guide to the expression of Uncertainty in Measurement” Analysis Method. Some of the most complex measurements on earth have been modeled in UncertaintyToolbox™.
Its design includes a standard set of Excel® Templates along with the capability to incorporate “Custom Templates” for specific industry applications. UncertaintyToolbox™ adds the power, compatibility and reliability of Microsoft® Excel® ensuring that the resulting reports can be reviewed by anyone using Microsoft® Excel®.
While UncertaintyToolbox™ employs several “Templates”, each of these templates are automatically linked together using one of several Wizard's. Any value changed/updated anywhere in the workbook reflects into the final value, as it should. In other words, all the calculations on each page, and each page with respect to the overall analysis, is linked together into one giant formula.
The templates that come with UncertaintyToolbox™ consist of Standard Templates and Custom Templates. Standard Templates are the basic building blocks of any analysis, while the Custom Templates make easy work of common industry measurements that involve uncommon complex math solutions, specific to the given measurement type.
Our Standard Template set is expected to remain consistent in scope, however, our Custom Templates list continues to grow. And with the NEW expanded Custom Template handling abilities found in UncertaintyToolbox™ 3.x, we will be redesigning many of our Custom Templates to work with this new feature so that users can enjoy the same control over them, as they do with the use of our Standard Templates.
MAIN USER INTERFACE
The first tool one uses in building an analysis with UncertaintyToolbox™, is the Main User Interface. This interface makes easy work of importing templates, along with copying and editing them. It also provides system security and contains the User Settings, Preferences and Default Information to be inserted into the analysis.
Most of the templates contain a Wizard. Which is designed to make easy work out of filling in all the specifics.
One of the best features of UncertaintyToolbox™, is that the final report is basically just an Excel® Workbook. It stands alone, with no need for the add-in to be installed on any reviewers computer. Once the analysis is constructed, the only thing needed to review and/or edit entries in the Uncertainty Analysis is Microsoft® Excel®. This difference alone, makes UncertaintyToolbox™ the hassle free solution in addressing the computation of measurement uncertainty under the requirements of Laboratory Accreditation to ISO/IEC17025.
FLEXIBLE TRAINING PROGRAMS
To create an uncertainty analysis in UncertaintyToolbox™ requires knowledge of the ISO GUM Method, as well as knowledge pertaining to the physics associated with the measurement method and the equipment utilized in the process. Training, samples and guidance from Quametec are available to help the analyst quickly get up to speed in completing their required analyses correctly.
Quametec offers various avenues to get your staff the necessary training and assistance required to become a competent measurement uncertainty analyst for their organization.
TYPES OF AVAILABLE TRAINING
1. Formal Public Classes: Includes hands-on training with after class support and a unique learning guarantee.
2. Online Self-Paced Training: The Quametec Institute of Measurement Technology, provides a truly “Self-Paced” online learning experience. Participants receive 120 days access, with extensions provided at no additional charge. Tuition includes private online GoToMeeting® tutoring sessions, as needed, to ensure the student has correctly learned the process of performing a measurement uncertainty analysis.
3. Private Tutoring/Assistance via Online GoToMeeting® Sessions: For those needing quick, economical assistance and/or advanced training in Measurement Uncertainty Analysis, Quametec offers tutoring, group training and technical assistance via online GoToMeeting® Sessions with flexible scheduling and NO cancellation fees.
The differences with UncertaintyToolbox™ don’t end with software design, our support is also very different from the standard model. Our users interact with us and other users in an online User Group, open to all licensed users of the software. If they encounter a problem running our software, they receive email, telephone and desktop support at no additional charge.
The User Group facilitates sharing of analyses and forum discussions where they can get questions pertaining to uncertainty, accreditation, and metrology answered, along with various other neat features.
ACCEPTABILITY: The "Traditional Budget" Difference!
Pricing for UncertaintyToolbox™ User License
|Number of Users
|Annual Pro-Support with Free Upgrades
||* Software Upgrade Fee
| 1 user license
||$ 895 per user
||$ 225 per user/year
||$ 695 *per user
|2 or more
||$ 845 per user
||$ 225 per user/year||$ 695 *per user
Software and User Group Membership is transferable to any other employee at your company, upon request at no charge. Software comes with a 30 day money back satisfaction guarantee!
*UPGRADE FEE: If you have a license for a older version of UncertaintyToolbox™ and you have not maintained an ongoing "Upgrade Protection" subscription, you can upgrade to the newest version at the given upgrade price, which includes one year of "Upgrade Protection".
User licenses comes with one year free "Upgrade Protection", which includes software updates and upgrades to any new version released during that period. The "Upgrade Protection" service is optionally available on a continuing basis at a cost of $225 per license per year. Software updates addressing fixes are always provided free. Upgrades and updates are made available as a download from this website in the "UncertaintyToolbox™ Users Group" section. We update the software frequently as we continue to improve the functionality of the software for even greater efficiency of use with new time saving features.
After your free year of the "Upgrade Protection" program expires, you will be contacted and notified with an option to renew your "Upgrade Protection Subscription", which will provide you with continued upgrades to new versions as they occur without any additional charge.
NOTICE: Uncertainty Toolbox™ software use REQUIRES Microsoft® Excel® 2007, 2010, 2013, or Office365® (Desktop Version). Which is NOT included!
Orders placed from Michigan will have a 6% sales tax added.
Call 1-810-225-8588 (9am to 4pm EST) to purchase UncertaintyToolbox™ and/or discuss available training options with your software purchase.
We accept PayPal, PayPal Credit, Visa, Master Card, Discover, American Express, Checks or Purchase Orders (NET 10 Day Agreement).
Once your order has been processed you will receive a license number and an access code that will give you access into the "UncertaintyToolbox™ User Group" found on this site. You will need to create your free User Account, then use the access code provided by Quametec to get into the User Group area. There you can download the software by clicking on the link at the bottom of the page, you will need your license number as provided from Quametec to install the software.
UncertaintyToolbox™ is one of many products developed by James D Jenkins; the President of Quametec and a recognized trainer of assessors and laboratory personnel world-wide in the practical application of the ISO GUM Method in meeting the measurement uncertainty analysis requirements per ISO/IEC17025.Copyright © 2009-2015 Quametec Corporation. All rights reserved.