Organizing Uncertainty Budgets for different Measurement Equipment

ScottBP

Involved In Discussions
#1
I know there's plenty of uncertainty calculator programs and spreadsheets out there, but when it comes to things with many, many individual uncertainty analyses (like gage block sets or multifunction calibrators), it usually means making umpteen dozen (or even hundreds) of copies of the spreadsheet (one for each reading), then saving them along with other associated calculations (e.g. control charts for Type A repeatability analysis) somewhere.

I know that some software (such as Fluke MET/CAL) can calculate uncertainties automatically as an instrument is being calibrated, but what I'm talking about is linking together the uncertainty budgets, control charts, etc. for the parameters that we list on our 17025 scope of accreditation, in some sort of logical fashion that can be easily understood.

I've been doing it on spreadsheets and saving them to a networked drive, but as the company I work for grows and has more equipment added to our capabilities list, this task has become overwhelming. To top it off, now we have auditors from regulated industries (e.g. nuclear) telling us all those spreadsheets have to be validated, approved, revisions counted and archived, etc., but none of them tell us how to go about doing it. So my question to everybody is how do you do it? How do you keep up with everything?
 
Elsmar Forum Sponsor

Marc

Hunkered Down for the Duration with a Mask on...
Staff member
Admin
#2
A quick "Bump". My Thanks in advance to anyone who can help with this one.
 

Hershal

Metrologist-Auditor
Staff member
Super Moderator
#3
Some good tough questions there.

First, the validation. Some of the regulators may require all kinds of validation that an AB may not. For example, using Excel and its built-in capabilities is often considered validated and the only thing you need to do is validate that specific application. So, an uncertainty budget done in Excel that is sufficiently generic would only need to be validated once.

As for the number, I suspect a better move for control is to match your uncertainty studies to the accredited scope assuming you are a test lab. Gage blocks for example, may then need only 4 or 5 uncertainties, rather than 81.

Of course, if you are a cal lab then you may be stuck, as you have to provide uncertainties to your customers for calibrations performed.
 

ScottBP

Involved In Discussions
#4
One auditor told us to simply work out the calculations on paper with a calculator and see if the results agree... Really? :mg: Instead I managed to distill it down to a basic budget with the minimum contributors, and then I'll do what I found out one of our consultants did- I'll take a screenshot of the most critical calculations showing in the formula bar. If the auditor doesn't realize the amount of scruitiny Excel has gotten over the years, then maybe we need a new auditor.

As far as keeping track of changes, I've heard of people using something like Microsoft Sharepoint or some other collaboration software that has built in revision control, but how would I set something like that up? The devil is in the details, and believe me, I'm on a first name basis with the devil right about now...
 

blueicecube2

Involved In Discussions
#5
what we did validating the MU spreadsheet by calculating step by step using scientific calculator and the student t-table as reference.

this is an accepted validation method - and we realize that Excel retains too much decimal point that we have to either set the number of digit retained or set a accepted tolerance i.e 1% of difference between manual calculation and Excel

as for revision, we track it the same way we track changes in document - give the MU spreadsheet a number and keep the revision number at the end with a history page of changes made for each budgets (which is made for each UUT type)
 
Thread starter Similar threads Forum Replies Date
B AS9100 Rev D Quality Manual - How are you organizing? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 9
S Organizing Risk Analysis and Controls for a New Medical Device (ISO 14971) ISO 14971 - Medical Device Risk Management 4
S Clarification in organizing required documents for ISO 27001 IEC 27001 - Information Security Management Systems (ISMS) 6
Proud Liberal Minitab - Organizing a large number of graphs using file details Using Minitab Software 5
M How to handle the task of Organizing a Regulatory File Room Document Control Systems, Procedures, Forms and Templates 2
K Global Quality Department Organizing and Planning Quality Manager and Management Related Issues 3
E Quality Assurance on Event Organizing (Medical Conferences, Yearly Festivals, etc.) Service Industry Specific Topics 0
V Suggestions on Organizing Documents using SharePoint 2010 Document Control Systems, Procedures, Forms and Templates 13
B Newbie, easy to follow guide for organizing/assembling very first PPAP booklet APQP and PPAP 3
B Organizing data to run simple regresson Using Minitab Software 4
T Organizing Medical Device Requirements - How you carried out yours? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 2
GStough Looking for Options in Organizing Internal Audit Paperwork - Any ideas? Internal Auditing 20
M Measurement Uncertainty in Optical Microscopy Measurement Uncertainty (MU) 1
L Uncertainty calculation for an average Measurement Uncertainty (MU) 1
R Determining Uncertainty from Gage R&R Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
B IEC 60601-2-10 - Accuracy of Pulse Parameters - Required Measurement Uncertainty IEC 60601 - Medical Electrical Equipment Safety Standards Series 3
F Missing value of Uncertainty B Measurement Uncertainty (MU) 10
F Issues in Uncertainty Estimation Measurement Uncertainty (MU) 5
F Operator Manual and Type B Uncertainty Measurement Uncertainty (MU) 3
F Learning Uncertainty Budget for Novice - Fluke 5520A Measurement Uncertainty (MU) 1
G Does pitch/increment/resolution of a ruled scale apply to measurement uncertainty as line item? Measurement Uncertainty (MU) 10
R Uncertainty in measurement larger than tolerance Measurement Uncertainty (MU) 2
S Uncertainty Budgets - Phase Noise (SSB), Harmonics Measurement Uncertainty (MU) 2
K ISO 17025:2017 clause 7.6.2 - Performing calibration of its own equipment shall evaluate the measurement uncertainty ISO 17025 related Discussions 6
M Informational US FDA Final Guidance – Consideration of Uncertainty in Making Benefit-Risk Determinations in Medical Device Premarket Approvals, De Novo Classificati Medical Device and FDA Regulations and Standards News 0
A Uncertainty Budget - Externally produced sensor module Measurement Uncertainty (MU) 1
E Discussion between co-worker on tolerance and uncertainty and how to apply it. Thoughts? 17025 ISO 17025 related Discussions 1
G Assigning a calibration tolerance - An x-y coordinate machine - Uncertainty as my verification tolerance General Measurement Device and Calibration Topics 4
G 3 Operator Std. Dev. and uncertainty calculation Measurement Uncertainty (MU) 2
G Reporting measurement uncertainty for custom items Measurement Uncertainty (MU) 2
L Gage R&R for test precision or uncertainty prediction? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 2
G Uncertainty of staging a short line scale standard on longer measuring machine? Measurement Uncertainty (MU) 4
K Measurement Uncertainty Budget (MU) of for Ultrasonic Thickness gauge Measurement Uncertainty (MU) 1
G NIST SOP 29 - Assignment of Uncertainty - Question General Measurement Device and Calibration Topics 0
M Medical Device News FDA news - 05-09-18 - Draft - Uncertainty in Benefit-Risk Determinations Other US Medical Device Regulations 0
G Can Measurement Machine Bias be part of Uncertainty? General Measurement Device and Calibration Topics 1
G How to include machine error in uncertainty calculations? Measurement Uncertainty (MU) 5
D Difference between uncertainty and expanded uncertainty of measurement General Measurement Device and Calibration Topics 1
M Calibration certificates avowing accuracy beyond the uncertainty limits? Measurement Uncertainty (MU) 7
G ANAB ISO 17025 Accreditation - Uncertainty and systematic error? ISO 17025 related Discussions 6
G How many Uncertainty Measurements for Micrometers and Calipers? Measurement Uncertainty (MU) 3
G What degrees of freedom means in uncertainty budget and how do I set the value Measurement Uncertainty (MU) 2
G Uncertainty Experts - ISO 17025 - If the Distribution is Rectangular Measurement Uncertainty (MU) 2
G Uncertainty Budget Examples for Caliper, Micrometer and Dial Gauge Measurement Uncertainty (MU) 3
P Uncertainty and Significantly Different Means - Buffer Solutions Measurement Uncertainty (MU) 4
S Pressure Gauge Calibration Uncertainty Calibration and Metrology Software and Hardware 5
E Uncertainty of Mean - Test rig that measures water temperatures Measurement Uncertainty (MU) 3
J Internal Laboratory Scope and Measurement Uncertainty (MU) IATF 16949 - Automotive Quality Systems Standard 1
G Manual Procedure with Uncertainty Budgeting for either a Caliper or Micrometer General Measurement Device and Calibration Topics 6
C MU (Measurement Uncertainty) in an Internal Calibration Laboratory Measurement Uncertainty (MU) 1

Similar threads

Top Bottom