SBS - The Best Value in QMS software

Automate GR&R using Minitab on complex, multi-measurement assemblies

L

Lmontoya

#1
Hi Guys,

I have some Test Systems than I need to do the GR&R study,

but the systems it's getting a lot of measurements (more than 200 different: voltage, freq, Current, Timing, etc, etc, etc).

10 boards, 3 times each, in 2 or more sockets (the most of Test equipment has more than one position, normally 2 or 3)

We are in process to development and install in production many of these test equipment.

I been working with the GR&R for one but I'm using many days to complete due the number of different measurements,

It's any way to put all data into MINITAB and get the individual GR&R report for every Measurement? now I'm filtering the data and making one by one

Thank you!
:thanks:
 
Elsmar Forum Sponsor

Miner

Forum Moderator
Staff member
Admin
#2
Yes, you can. You would have to write a Minitab macro to cycle through all of the columns of data, but it is possible. You might also consider grouping similar measurements into families. See my blog for more details.
 
L

Lmontoya

#3
:rolleyes:

Thank you for your reply.

I never use macros into Minitab, but I can Try.

The Idea than I have is to get all data from data base (or I can paste the all data directly into minitab) (>200 steps, 10 boards, 2 sockets, tested 3 times on each socket = 12,000 data rows) and let minitab make the job to separate by step (>200 steps), get Specs from columns, and result, and make Gage R&R study (Crossed) for all steps (<200)

I'm asking here because maybe somebody did that macro on the past
:thanx:
 

Miner

Forum Moderator
Staff member
Admin
#4
This is part of the command for the macro:

GageRR;
Parts 'Part';
Opers 'Operator';
Response 'Measurement';
Studyvar 6;
LSL -1;
USL 1.

You would need to add a loop to change the column numbers and specs for each.
 
L

Lmontoya

#5
I had the same list of commands,

But I need something to get the Specs from data (not manual), Title, etc.

I have the next sample of data (just two Step Names):

please see annexed file.
 

Attachments

Miner

Forum Moderator
Staff member
Admin
#6
Looking at your file structure, you will also have to subset your worksheet as each column can only have one measurement type. That is, 2.15 and 49225.438 must either be in separate columns or in separate worksheets.
 
L

Lmontoya

#7
yes!
I just put that example, that why I need to automate and make something (macro) so Minitab can separate, get columns, specs, titles, etc., and execute individually GR&R

I can do it manually (without use macros), but I'm spending lot of time,
 
L

Lmontoya

#8
I'm close to get what I need,
Now I'm trying to add Labels to graphs.

after I run this macro, I'm getting the data, specs, and others from row/columns, and getting the GageR&R graph (Crossed), now I need to add Result Labels (by Example into "Components of Variation" sub-graph (please see picture with labels already, I put that labels manually with menu: Editor>Add>Data Lables>Use y-value labels)


Still this is just for ONE step, and still need to automate for more than one step.

my actual Macro:

=====================
GMACRO
MYMACRO


#GSAVE "C:\GageRR.JPG";
#JPEG;
#WTITLE "Gage 1".
LET K90 = C7[1] # To get Low Limit
LET K91 = C8[1] # To get High Limit
LET K92 = C5[1] # To Choose "StepName" Column
LET K93 = concatenate (C7[1]," to ",C8[1]," @5.15")

GageRR;
Parts 'serial';
Opers 'Socket';
Response 'Result';
Studyvar 5.15;
LSL K90;
USL K91;
GAGE K92; #Choose "StepName" Column
DATE "JUL-28-2014";
USER "Luis Montoya";
GTOLERANCE K93.

ENDMACRO.
===============
 

Attachments

Last edited by a moderator:

Miner

Forum Moderator
Staff member
Admin
#9
If I understand you correctly regarding the labels, the graph pulls the labels from the column titles. You should be able to name the column whatever you want on the graph label.

Did you mean something else?
 
L

Lmontoya

#10
I need to add the BAR results, not the labels, to do that manually, just need to go menu a choose the "Use y-value labels", but need to change the Alignment to 90 degrees...

how I can do that using macros?
 
Thread starter Similar threads Forum Replies Date
P Trying to automate analyses of data from production process using Quality Analyst Quality Assurance and Compliance Software Tools and Solutions 1
M MS Power Automate/Sharepoint Files Document Control Systems, Procedures, Forms and Templates 1
A Minitab 18: How to automate GRR Summary Table save Reliability Analysis - Predictions, Testing and Standards 1
S How to Automate SPC Tracking Statistical Analysis Tools, Techniques and SPC 9
P Software to automate the completion of FAA documents 8130-9 or -3 automation Federal Aviation Administration (FAA) Standards and Requirements 6
M MSA angle issue - Nylon parts using Aberlink 3D Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
D Question on using audit checklist ISO 13485:2016 ISO 13485:2016 - Medical Device Quality Management Systems 12
J Using of CE marking - Two CE markings on the product CE Marking (Conformité Européene) / CB Scheme 5
R Using R package to implement Bayesian phase I/II dose-finding design for three outcomes ISO 13485:2016 - Medical Device Quality Management Systems 6
S Defibrillator Protection applicability When using Multiple applied parts IEC 60601 - Medical Electrical Equipment Safety Standards Series 0
P Using Zinc Plated Steel in a Cleanroom Other Medical Device Related Standards 3
J Incoming Inspection Records using Excel File ISO 13485:2016 - Medical Device Quality Management Systems 2
J Using ring gauges General Measurement Device and Calibration Topics 2
M Load Cell Calibration using a totalizer on a flow meter General Measurement Device and Calibration Topics 0
P Can Neoprene be Cleaned Using Isopropyl Alcohol (IPA) Manufacturing and Related Processes 4
GreatNate Anyone using the Intellect QMS software? Quality Assurance and Compliance Software Tools and Solutions 1
chris1price Sterilization using beta radiation Other Medical Device Related Standards 2
M Using the phrase "herein referred to" Document Control Systems, Procedures, Forms and Templates 8
B Struggling with using the 5.6 version Ford Capacity Analysis Report APQP and PPAP 5
cnbrosa Study Type 1 on a CMM using a measuring support Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
rerusk1 MRB (Material Review Board) Process using MS Sharepoint or MS Teams Manufacturing and Related Processes 2
K 510k FDA review, will they accept Biocompatibility result generated using feasibility product lots? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 8
B AS9100D 7.1.5.2 Calibration or Verification Method using outside cal lab AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 1
U Medical Device CE Marking - Using a disposable bearing CE Marking (Conformité Européene) / CB Scheme 3
D Calibration tolerance question using Pipettes Medical Device and FDA Regulations and Standards News 3
D Risk Analysis using Monte Carlo Simulation instead of Scoring and Heat Map Risk Management Principles and Generic Guidelines 2
W Using tailoring guidelines to tailor a QMS procedure ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
Y We found out we have been using a equipment without validation for past 4 years Quality Manager and Management Related Issues 6
D Using Laboratory Notebooks in R&D and Design and Development ISO 13485:2016 - Medical Device Quality Management Systems 3
C Importer shell game - Using a third party logistics provider (3PL) in the EU EU Medical Device Regulations 5
S Work performed in Canada on US patients using US device Canada Medical Device Regulations 1
S Is using ANSI/ASQ Z1.4-2008 the correct sampling plan to determine Pass/Fail of Apparel measurements? AQL - Acceptable Quality Level 4
A What are the pros and cons of using an audit software for internal auditing? General Auditing Discussions 7
Tagin Evaluating nonconformances for escalation using Bayesian methods? Statistical Analysis Tools, Techniques and SPC 2
D Using non-conforming components even though the final assembly is conforming? Manufacturing and Related Processes 5
B Using Unreleased Documents & Process Maps for Internal Audit purposes ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 12
R Clause 7.7 Replicate, Recalibration and Intermediate checks using Artifact ISO 17025 related Discussions 1
Stoic Are any medical device companies using the 2011 FDA process validation guidance instead of GHTF/SG3/N99-10:2004? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1
B Unit of Use DI (Device Identifier) - Products using the same device US Food and Drug Administration (FDA) 0
A Using Arduino based sensors for Poke-Yoke Manufacturing and Related Processes 6
M Using your Manufacturer's ISO certification ISO 13485:2016 - Medical Device Quality Management Systems 5
Ed Panek Adverse Event Clinical Trial using a 510K approved Device Other US Medical Device Regulations 6
B Using non CE parts in a machine CE Marking (Conformité Européene) / CB Scheme 1
G Gauge R&R on multiple dimensions using 3D measurement system Capability, Accuracy and Stability - Processes, Machines, etc. 6
A Hospital IT expectations for connected medical device using WIFI Medical Information Technology, Medical Software and Health Informatics 0
Proud Liberal Cp / Cpk on position using multiple MMC bonuses Capability, Accuracy and Stability - Processes, Machines, etc. 2
B Using external FDA and ISO 13485 audit as internal audit Internal Auditing 6
D Using "Particle Size Standard" templates as gauges - How to avoid giving a gauge # while using for process control? General Measurement Device and Calibration Topics 2
J Class 1 Medical Device - Using a UPC over the UDI? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 0
I Reducing CE marking cost using manufacturer test reports CE Marking (Conformité Européene) / CB Scheme 5

Similar threads

Top Bottom