JMP User Community

Latest Discussions

Scripting: open all sheets from an Excel file

What is the syntax to open all sheets from an excel file without naming all the sheets? This is the script log I got after clicking "Select all" in Excel Wizard. The specific excel file had 2 sheets name "Sheet1" and "Sheet2".Worksheets( {"Sheet1", "Sheet2"} ),I could not find help from Scripting Index either Open( excelFilePath, <Worksheets( "sheet name" | {"sheet name", "sheet name", ...} |...
GroupSquareWolf

Discussions |
Oct 3, 2022 10:50 AM

1353 views | 1 replies
extract information from a column in jmp

Hello JMP User, I want to write a script to extract some particular information such Alc%, VA, RS% from :merge and put them in a separate columns. Alc, VA and gravity values are randomly distributed, therefore Recode column would worked iin this case Any suggestions will be highly appreciated,Regards,
chandankishor66

Discussions |
Oct 3, 2022 9:30 AM

1244 views | 2 replies
Screen scrolling/update

I have JMP 16 installed on a surface pro 8. Granted not the best for data analysis, but very portable. A strange glitch occurs where I can only apply one action that shows on the screen... i.e. scroll to the left or down, use arrows to select columns, etc. If I give focus to another application and back to JMP, magically my cursor or highlighted cell is where it should be. So for instance if I...
degreen

Discussions |
Oct 3, 2022 8:31 AM

1938 views | 3 replies
Dealing with two type of date format

Hello JMP users,I have a Date column with have two types of format .1. Numeric format 2. DD:MM:YY format.How to convert the whole colum into DD:MM:YYWhenever I tried to change the data type and modeling type of this column, it could not change the format for whole column. Any suggestions would be highly appreciated.Regards.
chandankishor66

Discussions |
Oct 3, 2022 5:51 AM

739 views | 1 replies
How to simulate process data with some degree of autocorrelation?

I work in a manufacturing environment and often see data that is relatively normally distributed, but is not necessarily randomly distributed. The Overall Sigma (standard deviation) is often larger than the Within Sigma (control chart sigma) with regard to process capability calculations. This can occur for a variety of reasons like raw material lot switches and periodic instrument calibrations...
gwenhallberg

Discussions |
Oct 3, 2022 4:50 AM

5474 views | 10 replies

Previous
Next

Latest Discussions

Dealing with two type of date format

Hello JMP users,I have a Date column with have two types of format .1. Numeric format 2. DD:MM:YY format.How to convert the whole colum into DD:MM:YYWhenever I tried to change the data type and modeling type of this column, it could not change the format for whole column. Any suggestions would be highly appreciated.Regards.
chandankishor66

Discussions |
Oct 3, 2022 5:51 AM

739 views | 1 replies
How to simulate process data with some degree of autocorrelation?

I work in a manufacturing environment and often see data that is relatively normally distributed, but is not necessarily randomly distributed. The Overall Sigma (standard deviation) is often larger than the Within Sigma (control chart sigma) with regard to process capability calculations. This can occur for a variety of reasons like raw material lot switches and periodic instrument calibrations...
gwenhallberg

Discussions |
Oct 3, 2022 4:50 AM

5474 views | 10 replies
How to remove graph builder label

Hi, I want to append a report file with a graph. When I save it as a pdf it has the graph but the grey box saying graph builder. I want to change this to a different label - for example "graph of area 1". Is it possible to do this? I know you can do it from the report and save it but I can't seem to find jsl code that does this.
conroyco

Discussions |
Oct 1, 2022 12:52 PM

5871 views | 3 replies
Convert into nearest hours from duration ( hour:min:sec) format

Hi JMP User. how to extract hours from the duration ( hr.min) format and round the min into the hours example:20.45 : I want 21:00:0023.4 : I want 00:00:004.5 : I want 05:00:00Regards
chandankishor66

Discussions |
Oct 1, 2022 5:36 AM

1027 views | 1 replies
How to denote letters to mark significant differences in a boxplot?

Hi! I have JMP Pro 14. I´m creating several boxplots where I want to show the significant differences between categories with letters above the Q3 like in this graph:How can I put the letters a and b above the boxes? My plot is this one: Mi Graph Builder code is: Graph Builder( Size( 571, 448 ), Show Control Panel( 0 ), Show Legend( 0 ), Show Title( 0 ), Show Footer( 0 ), Variables( X( :Cat...
MagaSganga

Discussions |
Oct 1, 2022 3:23 AM

4083 views | 1 replies

Previous
Next

Latest Discussions

Model classification thresholds add-in display "negative" probability

Hi, I've been looking at this add-in which is very useful.https://community.jmp.com/t5/JMP-Add-Ins/Exploring-Model-Classification-Thresholds/ta-p/66964 In our case we don't have a probability but instead we have a status and a measurement that ranges between -10 and 10.I want to adapt the script so that the slider can move between -10 and 10 (I've already done it and it works). However the "Probab...
Agustin

Discussions |
Sep 13, 2022 6:43 AM

591 views | 0 replies
wrap: hide sub-titles?

In GRaph Builder, "wrap" is a nice option to split a data set into small pieces and generate many sub-plots.
But sometimes, the window is just filles with the "titles" of the sub-plots an there is no space left for the plots.
Is there an option to hide the titles of the subplots?
In the "wrap" context menu, there is an option to remove the "title" (here: "data"), but not the sub-titles.
And in the red...
hogi

Discussions |
Sep 11, 2022 8:53 AM

629 views | 0 replies
How to transform least square means from Turkey table after box cox transformation

Hello Everyone, I am running a three-way ANOVA with data expressed in percentage, but the data set is not normal. Since I have zeros, I first add a constant 0.00001, then I fit the model, and in the least square fit window, I used the box cox transformation to do a better fit. I know if I ask to save the predicted values, it will save the back-transformed data, but is there an option for JMP to sa...
Viniaze

Discussions |
Aug 27, 2022 9:14 AM

669 views | 0 replies
XGBoost Add-In for JMP Pro no test set result in model screening

I'm using model screening and include XGBoost as a method. However the result from XGBoost are only shown in Train set and Validation set.Why the result of XGBoost for test set is not shown?
TasapornV

Discussions |
Aug 25, 2022 12:45 AM

737 views | 0 replies
JMP Pro, Dantzig selector: how do I improve computational time

Hello JMP community members. Concerning the use of the Dantzig selector on big and sparse datasets.I wondered what features would be at disposal to tune the computational time.Right now it takes about 40 minutes to get a result back for a problem with 380 rows and 149 non-singular parameters. This makes me wonder about the options available to tweak the computation time. I was thinking about redu...
Not_A_Student

Discussions |
Aug 12, 2022 7:49 AM

736 views | 0 replies