JMP User Community

Latest Discussions

Script to find and replace

I use a GCMS program which adds "saturated (####)" when a peak area count is saturated. After I export these results from excel into a JMP data table, I would like to run a script which finds these occurrences and removes the "saturated ()" but leaves the number in numeric, continuous 12,0 format.
KRT

Discussions |
Dec 24, 2020 4:25 AM

3563 views | 7 replies
Technical Details of Variable Importance Calculations

I am looking for more technical details (beyond what is stated in the JMP documentation) about how Variable Importance is calculated (available under the Prediction Profiler options). I have read the two reference papers listed in the documentation (Sobol (2001) and Saltelli (2002)). I think I get the general idea, but I what I want to know is more of the gritty details on how the monte carlo sim...
MathStatChem

Discussions |
Dec 23, 2020 3:50 PM

1369 views | 1 replies
Unable to save file to Sharepoint

Hi all. At the end of what has been (to me) a complex script to extract specific data from an Excel file stored on Sharepoint, then perform necessary analysis, and save as an interactive HTML file, I seem to be struggling with what should be a very basic step. I can no longer see the wood for the trees. Am I missing something here? This format works for saving to my desktop or any drive on my PC...
kom

Discussions |
Dec 23, 2020 7:31 AM

3964 views | 4 replies
How to retrieve tabulated values by script

Dear Community, Based on the Tabulated output below, please how can I retrieve the amounts for categories 1, 2, 3 by script? Based on another working script I`m currently there in my tries: r = TabulateQuantiles << report; tb_TabQuant = r[Table Box( 1 )]; tb_TabQuant << GetText; QuantAmount1 = tb_TabQuant[2][1]; QuantAmount2 = tb_TabQuant[2][2]; QuantAmount3 = tb_TabQuant[2][2]; Show(QuantA...
HubP_SDe

Discussions |
Dec 23, 2020 3:14 AM

2875 views | 6 replies
How to convert timestamp data to duration time for each batch using jsl script

Hi all, I have started using JSL and is currently on a beginner level. My data consists of time-series batch data for different process variables. Each batch has a different time series range/ processing time. Data resolution is 1 hr. First, I want to convert the batch start time (Real-time) into duration time starting at time point zero (0) and then accumulate to the end Real-time. I think...
MK1985

Discussions |
Dec 23, 2020 1:28 AM

2774 views | 3 replies

Previous
Next

Latest Discussions

Technical Details of Variable Importance Calculations

I am looking for more technical details (beyond what is stated in the JMP documentation) about how Variable Importance is calculated (available under the Prediction Profiler options). I have read the two reference papers listed in the documentation (Sobol (2001) and Saltelli (2002)). I think I get the general idea, but I what I want to know is more of the gritty details on how the monte carlo sim...
MathStatChem

Discussions |
Dec 23, 2020 3:50 PM

1369 views | 1 replies
Unable to save file to Sharepoint

Hi all. At the end of what has been (to me) a complex script to extract specific data from an Excel file stored on Sharepoint, then perform necessary analysis, and save as an interactive HTML file, I seem to be struggling with what should be a very basic step. I can no longer see the wood for the trees. Am I missing something here? This format works for saving to my desktop or any drive on my PC...
kom

Discussions |
Dec 23, 2020 7:31 AM

3964 views | 4 replies
Unlock column created with a formula and modify its content

Hello JMP team,i have a set of data that I obtained from a temp sensor. Column 8 below has the time in the following format: hh:mm:ss:ms, the ms has three digits. I tired converting the column format to a time (only available option is h:m:s) but it is not working for some reason.I have also used the Munger in the formula and deleted the ms portion in column 8, obtained data is in the 1st column (...
AFaiz

Discussions |
Dec 22, 2020 5:08 PM

2336 views | 4 replies
When there is no interaction, can I use multiple comparison such as LSD or Tukey test?

I have three factors - Genotype (5 levels), Nitrogen (2 levels), and manipulation (2 levels). I'm interested in the combination of three factors. I'd like to check how average grain weight responds to defoliation under the different nitrogen conditions. When I analyze it as the full factorial, there was no interaction among genotype x nitrogen x manipulation. However, I want to indicate the diffe...
JK

Discussions |
Dec 22, 2020 9:25 AM

1798 views | 1 replies
Why does the Default DoE Custom Design have so little sampling of middle levels?

When doing a Custom Design, sometimes middle levels (other than the highest and lowest) are specified, so it is more than 2 levels. However, Custom Design Default design tends to suppress sampling of these middle levels, putting most weight on the highest and lowest of each parameter. How is this determined? Can we specify to add more in the middle?
FredChen

Discussions |
Dec 19, 2020 7:46 AM

1596 views | 2 replies

Previous
Next

Latest Discussions

Graph Builder - Remove Combine Scales?

In graph builder I am interested in plotting a simple Y vs X for multiple X variables. By default graph builder combines all the different X variables on the same X axis and scale. Is there a simple way to change the X axis to have separate scales on the X axis for each variable? Default graph builder (script1, graph1)Plot 1 variable on Y axis vs 8 variables on X axisAll 8 variables on same x-axis...
ehorne

Discussions |
Oct 29, 2020 9:11 AM

1519 views | 0 replies
SharePoint Online

My company recently began the migration from SharePoint 2010 to SharePoint Online. I have found that my JSL scripts are now no longer able to open or save files to the new SPO site. Anyone have the correct updated syntax for this. Example 1 (SP 2010): This worked. TablePath4 = "\\sharepoint.amr.ith.company.com@ssl\sites\rpt\documents\JMP_tables\"; //set variable TablePath path location Tabl...
Outdoorsman1963

Discussions |
Oct 23, 2020 4:06 PM

1325 views | 0 replies
How to run a Post hoc for Chi Square results in JMP?

I was wondering if someone can help me. I want to run a post hoc analysis for the chi square results in JMP. Thanks
vmendez17

Discussions |
Oct 22, 2020 7:33 PM

830 views | 0 replies
Problem specifying model for a partly nested ANOVA design

My study design is mixed-model with one fixed between-plot fixed factor (A), a random plot factor (B), nested in A (B[A]), and two crossed within-plot fixed factors (C and D). I'm able to enter a full factorial model that includes the 3 fixed factors and all their interactions, using either the Least Squares or Mixed-Model Personality. I'm also able to add the random factor (B[A]), but things go...
wpsousa

Discussions |
Oct 19, 2020 10:39 PM

1039 views | 0 replies
Default encoding on JMP - EUC-KR

Hi,I have JMP 14.2, 15.1, and also 16.0EA at the moment.All versions here don't include EUC-KR encoding system; so this can cause importing problems in many cases since a lot of Korean data or pages are made with EUC-KR. I have charsets that are all broken. So I had to import it with other programs and save as to fit into UTF-8 or match/join columns with other matching codes.It seems like JMP is a...
joelahn

Discussions |
Sep 10, 2020 1:26 AM

1268 views | 0 replies