Minitab Help with Empty Cell

L

Lmontoya

#1
Hello,
Problem 1:
I have a macro to make a repetitive GageRR (for different measurements, normally more than 200).
to do this I'm manually pasting all data into mainitab and split using Data/Split Worksheet.
after that I just Run my macro and make the GageRR graphs, but some cases I have no data into some columns (that is the limits columns and some times has no Minimum or maximum), so is EMPTY cell or column

in that cases, I'm getting the next error:
------------------------------------------------------
LET K1 = C7[1]
S
* ERROR * Empty column, undefined or illegal stored constant at S
* ERROR * Completion of computation impossible.
--------------------------------------------------------

How I can mange this error before happen? how Can I verify that that cell is empty before?

Problem 2:
If all data is in place, I'm getting the GageRR result into graphs, but the is no a numerical sign of the results, just BARS. I been trying to put that labels directly into graphs, but no results, how can I get data from "Session" screen? I can see than the data is into that window, or any other way to get the GageRR result as text?

:thanks:
 
Last edited by a moderator:
Elsmar Forum Sponsor

Miner

Forum Moderator
Staff member
Admin
#3
Try adding control statements such as IF and GOTO to check for data in the cells prior to the LET statement.
 
Thread starter Similar threads Forum Replies Date
S Need help with analysing a survey on minitab Using Minitab Software 1
P Basic Minitab Help - It's about Linear Regression Using Minitab Software 1
Y Please help me solve a DOE problem - New Minitab User Using Minitab Software 36
M Please help to analyze Response Surface Methodology by using Minitab 16 Using Minitab Software 6
M Can I get a Cpk out of my data? Minitab help Using Minitab Software 1
K Flow of Descriptive Stats Analysis and Unequal Variances Help (Minitab) Using Minitab Software 3
R Minitab Fractional Factorial Data Entry Help Using Minitab Software 5
J Minitab or Gage R & R Specialist help wanted Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
S Cool Minitab Document 'Sample' - Help with FULL Version location/access? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
L Capability Analysis - Help with Minitab results Using Minitab Software 15
R Minitab Multiple Regressions Script Help Using Minitab Software 1
K New to Minitab but figuring it out on my own.........HELP Using Minitab Software 2
L Gage Linearity and Bias Study Analysis - Minitab help needed Using Minitab Software 4
E Intreprating a Data Set with Minitab - Help wanted Using Minitab Software 2
Q DOE (Design of Experiments) for Accounting - New to Minitab need help Using Minitab Software 5
N I have 2 groups to compare - Minitab and stats newbie - Please help Using Minitab Software 18
F Differences among three locations with respect to mean selling price - Minitab help Using Minitab Software 2
P Taguchi method using Minitab - DOE (Design of Experiments) Help Quality Tools, Improvement and Analysis 7
S I am asked to fit 2 lines - Basic Minitab Question - Quick Help needed Using Minitab Software 1
P Help With Basic Minitab Questions! Using Minitab Software 6
M Macro to connect to Access Database to get to data - Minitab Macro help Using Minitab Software 1
D Minitab DOE - 4-factor, 2-level, 8 trial, level IV fractional DOE help needed Using Minitab Software 5
M Macro that will perform a normality test and capability analysis - Minitab help Using Minitab Software 1
Ron Rompen Need help with MSA/Gage R&R - Seeking Minitab template file/sample GR&R study Using Minitab Software 7
F Minitab 19 Anova or X bar # of distinct catagories Using Minitab Software 1
P Pooled Standard Error - Minitab Statistical Analysis Tools, Techniques and SPC 0
S Asterisk in DOE minitab software Using Minitab Software 23
B Does anybody know how to get older versions of Minitab to work in Windows 10? Quality Tools, Improvement and Analysis 9
M Minitab Capability of the Population (no sampling) Using Minitab Software 11
Z Minitab - Updating Graph with specific data points Using Minitab Software 2
M Minitab assistant: 1-Sample % Defective Test Using Minitab Software 1
0 Interesting Discussion Analysis of half normal distribution in minitab Using Minitab Software 11
G Batch printing reports in Minitab Using Minitab Software 3
B Minitab Type 1 Gage Study on True Position Question Measurement Uncertainty (MU) 1
V Minitab GRR crossed Xbar and r method macro needed Using Minitab Software 9
I Number of decimals in equation calculated by MiniTab Using Minitab Software 0
A Acceptance p-value for linearity and bias analysis in minitab results Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
M How to change the display of optimization plot in Minitab 18 Using Minitab Software 2
M Minitab tool to evaluate PM (Preventive Maintenance) process Using Minitab Software 6
E Input to ANOVA 1-WAY - How can I perform this analysis in minitab? Using Minitab Software 2
N Tolerance Interval plots in Minitab Statistical Analysis Tools, Techniques and SPC 0
J Including Repeats in DoE using Minitab Using Minitab Software 5
A Minitab 18: How to automate GRR Summary Table save Reliability Analysis - Predictions, Testing and Standards 1
N What subcommands can be used with "Stop" in Minitab 18? Using Minitab Software 8
S Minitab - Factor Analysis: Label on second series of data for Biplot Using Minitab Software 4
J Which Anova dropdown to use for R&R in Minitab? Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 1
J DoE - Number of runs in Plackett-Burman (Minitab) Using Minitab Software 2
D Asterix when pasting a column of values from Excel into Minitab (V17) Using Minitab Software 5
A Generating samples from a population in Minitab Using Minitab Software 0
Ron Rompen Random data generation in Minitab Statistical Analysis Tools, Techniques and SPC 2

Similar threads

Top Bottom