JMP Scripts

Latest Posts

• Batch Image Analyzer

  Recently I was contacted by a customer asking if there was an easy way to do image analysis in a batch mode. They were familiar with the Image Analyzer but that is an interactive GUI based way of analyzing images. This customer had hundreds of images to process and really just wanted to use JMP to calculate some statistic about each image. To do this in an interactive mode would take a lot of time...

  JohnPonte

  JMP Scripts |

  Jan 3, 2025 11:08 PM

  4546 views | 3 replies

• Code Breaker

  pick the right colors ... (view in My Videos) 

  hogi

  JMP Scripts |

  Nov 25, 2024 10:35 AM

  189 views | 0 replies

• Combine multiple excel files

  Hi,  Sometimes I have to combine a lot of excel files. But "Import multiple files" menu would not work for excel files properly. So I wrote a JSL for it and I would like to share it here. It starts with select an excel file and open it using excel import wizard. Then the script gets import settings and files list in the directory. Finally, open all excel files (.xls, xlsx, xlsm) in the directory a...

  MKawaguchi

  JMP Scripts |

  Nov 22, 2024 12:17 PM

  7755 views | 8 replies

• Single Cell RNASeq Workflow in JMP Pro

  In this post, there is a series of JMP Workflows that aid in analyzing Single Cell RNASeq data that replicate what use to be done in JMP Genomics Single Cell RNASeq Analysis Workflow. Included are sample data as well as a Word document that is provided as a tutorial and what you would need to do to make these JMP Workflows work on your data. Please leave comments below if you have questions or sug...

  Chris_Kirchberg

  JMP Scripts |

  Aug 30, 2024 10:12 AM

  939 views | 2 replies

• Comparative normality testing on many parameters or groups of data

  This script tests multiple data columns for normality using the Anderson-Darling method. Each column can be split into groups by a categorical column and each group tested individually if required. The output is an interactive report ranked by the A-squared statistic as a ratio of the critical value at a 5% confidence level (so data with different population sizes can be compared directly). The wo...

  matth1

  JMP Scripts |

  Aug 2, 2024 6:53 AM

  390 views | 0 replies

• Range Slider Box with Connected Number Edit Boxes

  Just figured out a nice solution to control a range slider box with both the slider controls and number entries and I wanted to share.  This is similar to Combined and Connected Number Edit Box and Slider Box - JMP User Community.  Here is an example: (view in My Videos) Names Default To Here( 1 ); minrange = 0; ll = 60; ul = 90; maxrange = 100; New Window( "Range Slider Box with Number Edit Boxes...

  MathStatChem

  JMP Scripts |

  Jul 25, 2024 8:11 AM

  267 views | 0 replies

• Wafer maps in Graph Builder using Map Shapes

  I've been creating semiconductor wafer maps using points or heatmaps for a long time and adding graphics scripts to show the die outlines, but it's cumbersome and prone to looking ugly if you have missing data (alternatively you need to add dummy rows to avoid this, which is even more cumbersome).   At the recent European Discovery summit, there was a discussion about using map shapes in Graph Bui...

  matth1

  JMP Scripts |

  Jun 13, 2024 9:26 PM

  1115 views | 2 replies

• Open JMP Scatterplot 3D from a copy of JMP opened within a remote desktop session

  Prevent JMP from crashing when opening a scatterplot 3D from a windows session that was started via remote desktop.

  ih

  JMP Scripts |

  Jun 13, 2024 6:48 AM

  280 views | 0 replies

• Update the open source table script to multiple file import

  When importing non-jsl file like a .txt or .csv file a "source" table script is automatically added but with a fix file path.To make it more dynamic, the script replaces the path with a multiple file import functionality.All the files get concatenated automatically with an additional column containing the file name. There is an option to save it as a new table script or as a stand-alone file. It c...

  Mauro_Gerber

  JMP Scripts |

  Jun 13, 2024 6:45 AM

  306 views | 0 replies

• Times Tables Patterns with JSL

  (view in My Videos)

  Franco

  JMP Scripts |

  Jun 13, 2024 6:35 AM

  227 views | 0 replies

• Diagram for deeply stacked lists and arrays

  JSL allows to stack lists and associative arrays. Parse JSON() command converts JSON texts into potentially large collections with stacked elements. These structures can become very deep and difficult to understand. This script analyzes lists and associative arrays and displays their design and content in form of a hierarchical tree.

  Bernd2Heinen

  JMP Scripts |

  Jun 13, 2024 6:28 AM

  238 views | 0 replies

• Sqlite3 to JMP Data table through Python Integration

  The attached JSL uses JMP's Python integration to create a sqlite3 database file by recursively descending a directory of files.  The directory is chosen using JSL's Pick Directory().  The path is passed through to the Python environment.   A MD5 checksum is computed for each file and that along with the path is inserted into the sqlite3 database, then the sqlite3 table is imported into JMP as a ...

  Paul_Nelson

  JMP Scripts |

  May 22, 2024 10:53 AM

  1111 views | 1 replies

• Python parallel processing from JMP JSL

  Over the Holiday break, I had time to tinker with Python.  The issue we have run into with parallel processing from the Python/JSL interface is Python typically launches multiple copies of JMP, not Python.  The reason for this is we embed Python in JMP, so the executable is JMP instead of Python.  I discovered the multiprocessing package allows setting the executable to launch when running the par...

  Paul_Nelson

  JMP Scripts |

  Mar 29, 2024 10:47 PM

  2970 views | 6 replies

• Basic Expression Analysis Workflow in JMP Pro Workflow and Project

  The attachment to this post is set of JMP Workflows that replicate the analysis and output of what use to be performed in JMP Genomics Basic Expression Analysis Workflow.  There is example data and JMP Projects that can assist in running these workflows. A Word document is included describing each workflow and what you need to do in order make the JMP Workflows work for your data set. Please leave...

  Chris_Kirchberg

  JMP Scripts |

  Mar 20, 2024 8:42 AM

  473 views | 0 replies

• GxE Interaction: AMMI Model Script and Project with Workflow Builder

  GxE Interaction analysis on genetic and environmental data use to be available in JMP Genomics. Now, the AMMI model and various graphs and tables can be produced within JMP using the attached script or JMP Workflow (put inside a JMP Project).   There are also two example data sets included to see how the JSL script and JMP Workflow works.  The Workflow contains notes in the script section to descr...

  Chris_Kirchberg

  JMP Scripts |

  Mar 19, 2024 12:28 PM

  441 views | 0 replies

• WikiReader: Augmenting Hover Labels with web data and images

  In JMP 15.0 hover labels got extensions that provide the ability to the display images and rich text inside hover labels. The image displayed and what happens when you click on it are completely under the control of the user. One can retrieve an image from a column, a file or a URL built dynamically based on the graph context (e.g. X and Y values of your graph).   To showcase this feature, this ex...

  nascif_jmp

  JMP Scripts |

  Feb 21, 2024 1:19 AM

  2841 views | 2 replies

• Activity Status Class

  This class can be used to display an activity status window.  It is designed to show progress when stepping through a sequence of time consuming steps:       Example Usage: // reference to the ActivityStatusClass include("ActivityStatusClass.jsl"); // list of notification messages for each activity lst = { "Linear Kinetic Model", "Accelerating Kinetic Model", "Decelerating Kinetic Model", ...

  David_Burnham

  JMP Scripts |

  Feb 20, 2024 11:40 PM

  3230 views | 2 replies

• MFR: a JSL Functional Programming Library for List/Associative Arrays Manipulation

  MFR (from Map-Filter-Reduce) is a library of functional programming primitives for JSL. Includes basic tests. Inspired by http://book.pythontips.com/en/latest/map_filter.html

  nascif_jmp

  JMP Scripts |

  Feb 8, 2024 6:54 AM

  6144 views | 4 replies

• Animated GIF Player in JMP

  In JMP 14 we began adding support for multi-frame images in JMP. On Windows, JMP can read in and display multi-frame TIFF files as well as animated GIF files. Since doing that I've heard requests for "playing" an animated GIF in a JMP window, with some user control. If you drag and drop your animated GIF into a browser window the animation will play automatically and continuously. But some users h...

  JohnPonte

  JMP Scripts |

  Jan 4, 2024 8:01 PM

  4773 views | 3 replies

• MouseBox ListBox Drag and Drop

  question that prompted this script:Trouble with mousebox behavior?

  Craige_Hales

  JMP Scripts |

  Nov 13, 2023 12:02 PM

  9935 views | 8 replies

• "Fuzzymerge" - join tables with slightly different timestamps

  I often have data files from different sources that I want to join by time, but as they come from different systems their time stamps are just slightly different.  We solved this by using JMPs KDTable object which allows for crazy fast nearest neighbor searching.  This "fuzzymerge" will find the closest row in time in a second table for each row in the main table and join those rows into the resul...

  klk

  JMP Scripts |

  Jun 21, 2023 9:18 AM

  5240 views | 9 replies

• Integrating InfluxDB with JMP using HTTP Request

  There are many OpenSource data sources that emerge everyday. One such data source is InfluxDB  Their tag line is “We build cool stuff for developers who build cool stuff”. I happen to think that JMP is “cool stuff” but the question remains, “How can you integrate JMP’s ‘cool stuff’ with InfluxDB’s ‘cool stuff’”.   Luckily, there are 2 specific cool stuffs that can make this happen. The first is th...

  bryan_boone

  JMP Scripts |

  Feb 7, 2023 9:22 PM

  1567 views | 1 replies

• Scripts and images for closing data tables on personal menu

  Note that the “close table” scripts will close the data tables without prompting you to save them.  Use with caution!    Go to View -> Customize -> Menus and Toolbars     Then under toolbars, right click on the last of the list and select “New Toolbar”                       JMP will create a new toolbar called “Untitled”.  Click on it to edit the name.       Input the location of the script to ...

  charlie_whitman

  JMP Scripts |

  Jan 27, 2023 12:58 PM

  1519 views | 0 replies

• Dixon Q Test for Outliers (Updated)

  (Please note that a problem was discovered with the original version of the script that was made available before 09Oct2014. The problem occurred when the sample size was greater than 30. has been corrected and the updated of the version replaced. The available tables of critical values only go to a sample size of 30, so the critical value for sample size 30 is used for all sample sizes greater t...

  Mark_Bailey

  JMP Scripts |

  Dec 7, 2022 10:41 AM

  17158 views | 6 replies

• Tab structured layout in a Journal

  JMP Journal files are very handy for presentations  and that is what I’m using for each of my seminars. Sometimes they can be very long and overwhelming.  An idea would be to have a tab structured layout. I mean by that to have several Tabs in a Journal file so that the presentation can be separated in different sections. Here an example. This is simple to do: 1. Write a script as you would do a ...

  Valerie_Nedbal

  JMP Scripts |

  Oct 20, 2022 5:01 AM

  1976 views | 1 replies