Open XLS table that contains cell formula's
Hi, I have an excel sheet which contains cells with values, strings, and formula's. JMP imports the cells with values, strings, and simple formula's correctly. However, if the cell has a ...
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesHi, I have an excel sheet which contains cells with values, strings, and formula's. JMP imports the cells with values, strings, and simple formula's correctly. However, if the cell has a ...
Is it possible to add text to a cell that has already loaded images? Thanks!
I'm having an issue in my code where I press a button and it goes into another function in another file (using Include("filename.jsl"); Once the button is pressed the function from the other file run...
...xcel I would add a thick boarder around a group of columns, say all that come from one sheet to visually break apart the data. I have 150 columns and find myself getting lost on the page often....
Hi, I am trying to create a jsl script where the user can type the file name and save as csv. Here's what I tried. Save() doesn't work when I enter the variable exE. Any suggestions? ...
I'm having an issue in my code where I press a button and it goes into another function in another file (using Include("filename.jsl"); Once the button is pressed the function from the other file run...
I am trying to update and understand a very large old data set, some of the data comes from other workbooks and some of it is calculated from multiple columns. I would like a way to highlight or othe...
Hi, I am trying to create a jsl script where the user can type the file name and save as csv. Here's what I tried. Save() doesn't work when I enter the variable exE. Any suggestions? ...
Hello everyone, I have some questions on RSM: I finished my experiments and I want to generate the Response Surfaces now. For example, one looks like this: Q1: I wou...
I found that when a row is Hide and Excluded, the data is still being used by a formula in another column. Here is an example, Column2 formula is Col Maxium (:Coumn 1), row 4 is excluded and hidden,...
Dear All, I have been analysing a two factorial (3*4) RCBD repeated measures design by using the mixed model approach in JMP. Above is a section of the report I got. Why are the estimates zero. Othe...
Is there a better way rather than iteration of all the rows to validate values in column? Let's say before making something with the column I want to make sure that all values in column matc...
HI, How to find estimators of FGNLS and NLS (Seemingly Unrelated Regressions) Using JmpPro. # Note that it is present in SAS in the proc syslin and it is in stat in the nlsur command &nbs...
Hello, I am trying to do a matched sample analysis across three different factors. I wanted to: 1. Confirm that my sample would be what I pick for 'Block" when I do Fit Y by X when running Fr...
Hello everyone, I am trying to make a table with the OOT (out of Trend) batches with their respective "atypical" values. I used for that the "script alarm" function as I could found some exemples o...
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/jmp101-28aug2024.html ...
This webinar is in English, 2:00 p.m. US Eastern Time. Learn how to publish data, dashboards...
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/teaching-univar-11sep2024.htm...
https://www.jmp.com/en_us/events/users-groups/users-group-meetings/ph-jug-11sep24.html ...