Import hidden Excel worksheet
How can I import data from a hidden Excel worksheet? If I use Open() with the option Worksheets("TechnicalData"), then it fails as long as the workshe...
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHow can I import data from a hidden Excel worksheet? If I use Open() with the option Worksheets("TechnicalData"), then it fails as long as the workshe...
Hello! Can any one help? I am collecting data through an online survey. My survey includes ranking questions. For analysis, the answers to the ranking...
Hi All, I want to create a dialog box which show all the column names available to the data. It will allow to select the required column and save colu...
I want to create a base line control chart and then apply those control limits to new data to see if a change in the manufacturing process results in ...
how can i save big class.jmp as a name with time string? Thankse.g. dt = Open("$SAMPLE_DATA/big class.jmp"); Hope the script can identify the work we...
How can I import data from a hidden Excel worksheet? If I use Open() with the option Worksheets("TechnicalData"), then it fails as long as the workshe...
I have a JMP table with a column called Order that contains letter values like A, B, C, D, E, etc., and another column called Number that contains num...
This is a very simple question. I have a given column in a JMP table, and I want a JMP scripting command that will find and replace all instances of ...
Hi,I have run into a problem all of a sudden. I wish to copy files and directories and I am not able to do that anymore.I use Copy File() and Copy Dir...
Hi everyone !
Here's my situation: I have a dataset of 58 batches in line, and 213 columns corresponding to my parameters Xs (ex: Glucose at culture da...
Hello, How do I use JSL to calculate Z-scores at different levels of aggregation? I am working with cancer mortality data (1999 - 2015) at the county...
I am working with a very large database of image files and want to be able to display the file for the user for visual inspection from a script. I hav...
Not a mac person. Does anyone know how to run a jsl script from command line on a mac? I specifically mean WITHOUT "//!" at the top of it. I hav...
I am working with a multi level data. Data is attached.In this dataset, I have 8- X variable: cumulative risk (continuous), all other risk (dichotomou...
I am running mixed effects models and have noticed that the standard error for an effect in the "Parameter Estimates" table is different from the stan...
https://www.jmp.com/en_us/events/users-groups/users-group-meetings/austin-semi-jug-12sep24.html ...
https://www.jmp.com/en_us/events/users-groups/users-group-meetings/ba-jug-12sep24.html ...
This webinar is in English, 2:00 p.m. US Eastern Time. See how to assesses the precision, con...
Topic: JSL in Graph Builder Registration link: https://www.jmp.com/en_gb/even...