How to track and manage all uncertainty budgets - Database?

ScottBP

Involved In Discussions
#1
I use Excel to draft up all the uncertainty budgets that go into our 17025 Scope of Accreditation. The problem is that we have many instruments, some with hundreds of ranges each (e.g. gage block sets, pin gages, Fluke calibrators, Agilent/HP multimeters, etc.) This means thousands of uncertainty budgets, some with control charts, spread out over hundreds of spreadsheets.

Now we're under the gun to implement software version tracking, to include Excel spreadsheets. The idea of version tracking all these (mostly ad-hoc) uncertainty spreadsheets makes my stomach rumble.

My question is: Does anybody use some sort of database instead of Excel sheets to manage all their uncertainty budgets? Can off-the-shelf gage R&R software (e.g. Minitab) be configured for tracking uncertainty budgets?
 
Elsmar Forum Sponsor

Steve Prevette

Deming Disciple
Staff member
Super Moderator
#3
You could set up a central fileserver with a folder to store all of the "official" spreadsheets. Only have a few people with write access approved. Then you can make a central spreadsheet (or access database) with the URL addresses for opening up the appropriate spreadsheet. If all of the spreadsheets are set up similarly, you could link the appropriate cell values in the individual spreadsheets to the central file and display results.
 
J

JayWarner

#4
You are right - a database is where you (probably) need to go. I have a smaller situation from yours, with one (humongous) spread sheet, and it _will_ be a real db soon enough. The trick is to figure out the data structure - flow and category/grouping - first, then write the db. I've no idea who has done this already. Perhaps you are big enough to justify a serious general package; I'm not. IF you understand the data structure, THEN you can evaluate a commercial package. Otherwise, you are taking their word for it.
 
Thread starter Similar threads Forum Replies Date
D Engineering Change Order (ECO) metrics to track ISO 13485:2016 - Medical Device Quality Management Systems 6
Ajit Basrur Track audit findings on Excel tracker Excel .xls Spreadsheet Templates and Tools 9
R How to keep track of employee read-only training ISO 13485:2016 - Medical Device Quality Management Systems 13
D What are the important things to keep track of in product audit checklist? Software Quality Assurance 3
Ed Panek Requirement to track and trend positive feedback from customers ISO 13485:2016 - Medical Device Quality Management Systems 12
R How to keep track of all FDA rules and regulations for medical device companies 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 2
Sam Lazzara Expedited, fast-track Notified Body Technical File reviews EU Medical Device Regulations 3
S Employee Training Matrix - Keeping track of employee training on various SOPs ISO 13485:2016 - Medical Device Quality Management Systems 4
S Keeping track of the changing Medical Device Standards Other Medical Device Related Standards 3
S Track Cpk trend Statistical Analysis Tools, Techniques and SPC 5
L Creating a xlsx Customer Complaint file to track Complaints Excel .xls Spreadsheet Templates and Tools 2
F Fast Track Registration in Costa Rica for Medical Devices registered in Canada Canada Medical Device Regulations 3
O Creating a Tool to Track & Verify Mistake Proofing Devices Document Control Systems, Procedures, Forms and Templates 5
Marc Retail stores plan elaborate ways to track you After Work and Weekend Discussion Topics 0
S Does anyone use a FRACAS system to track lab equipment issues? Calibration and Metrology Software and Hardware 1
M Developing a new Plating Vendor - What software to track certifications Software Quality Assurance 2
F Software or form/templates program to track Internal Audits and Corrective Actions ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 9
K Is my Internal Audit Plan on the right track? Internal Auditing 0
L "Morale" as an indicator - How to track "morale"? Misc. Quality Assurance and Business Systems Related Topics 16
V What is best practice to track Quality Teams Effectiveness & Efficiency. Quality Manager and Management Related Issues 4
AnaMariaVR2 9 Trends to Track in the Medical Device Industry 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 0
L How to track the NCR (Quality Notification, Services Notification) Nonconformance and Corrective Action 2
G Document Revisions - How do I track the Form Revision History/Approvals? Document Control Systems, Procedures, Forms and Templates 5
N Best Custom Software (To Track QMS & Processes) Provider Quality Assurance and Compliance Software Tools and Solutions 9
A Does anyone know of a WHO fast-track program for Medical Devices? Other Medical Device Regulations World-Wide 3
M Bottom-Up Methodology to Track Root Cause? Problem Solving, Root Cause Fault and Failure Analysis 4
K Looking for Ideas to Track Customer Requests and PPAP Data Packages APQP and PPAP 4
T Deviation Tracker - Anyone have a template that can efficiently track 4 days of data? Customer Complaints 2
N Fast Track for Medical Devices Registration in Mexico that are already CE Marked Other Medical Device Regulations World-Wide 11
L Looking for 5S database to track findings Lean in Manufacturing and Service Industries 6
N Is there a standard length of time to track down non-responding customers w recalls? Misc. Quality Assurance and Business Systems Related Topics 2
M AS9100C - On track to IAQG timeline? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
T Keeping Track of Procedure Implementation Training Activities ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
AnaMariaVR2 FDA's Transparency + Basics for Industry + FDA Track US Food and Drug Administration (FDA) 3
A Corrective Action Tracking - What Measureables and How to Track Status ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 11
A Document Relationship Matrix - Keeping Track of References to Related Documents ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
Mr.Happy Dbase or Excel file to keep track on our internal failures (Non conform products) Document Control Systems, Procedures, Forms and Templates 8
Wes Bucey What to think when a major manufacturer goes off the Quality track? US Food and Drug Administration (FDA) 3
L When a tool fails calibration how do you track what product was checked with it? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 31
C A form to track Action Items needed attached Document Control Systems, Procedures, Forms and Templates 7
R Documentation Review Matrix to track all documents written by my QA engineers Document Control Systems, Procedures, Forms and Templates 4
A Control Chart to Track Effectiveness of Actions to Reduce Scrap Rate Six Sigma 7
A Analyzing Corrective/Preventive Actions and How to Track Due Dates Preventive Action and Continuous Improvement 16
J Coming up with initial policies sufficient to get everyone headed on the right track ISO 13485:2016 - Medical Device Quality Management Systems 3
G Track bugs, corrections, reports and progress - Test Management Tools suggestions Software Quality Assurance 4
C Archiving Systems to Track Documents - Pharmaceutical Company Document Control Systems, Procedures, Forms and Templates 5
A How to Track Objectives and What do to after objectives had been met? Internal Auditing 7
L Supply Chain World conference and expo question - taking an educational track? Supplier Quality Assurance and other Supplier Issues 3
Ajit Basrur How do you keep track of various passwords ? Coffee Break and Water Cooler Discussions 24
J Access Database to Track Non-Conforming Material Quality Assurance and Compliance Software Tools and Solutions 8

Similar threads

Top Bottom