JMP Scripts

Latest Posts

• Error trapping for Oracle ODBC SQL

  The log_execute_sql utility executes Oracle SQL statements and looks in the log for any errors.  If errors are found they are displayed in a message box.  There is a debug flag that, when turned on, will display the SQL statement before execution.  For JMP 11 and above needs the log window open, settable via a preference (see comments below).Function Name: log_execute_sqlDescription:       Execute...

  pmroz

  JMP Scripts |

  Jul 2, 2015 6:41 AM

  3261 views | 0 replies

• Wireworld

  Goes with blog post which has a video.
  Wireworld Computer - the guys that made it.This JSL (attached, below) runs the Wireworld cellular automaton.  You'll need an external file too; instructions at the top of the JSL.  Update:  some browsers can't download the file without mangling it.  I've re-attached the JSL to always fetch the external file.

  Craige_Hales

  JMP Scripts |

  Jun 22, 2015 12:20 PM

  6052 views | 0 replies

• Data Table Support for Images in JMP 12 (Supporting Files)

  After unzipping the files, open the data table and run the script. A summary table will be created, with an expression column that houses a different graph in each row. Since the graph column has the label property turned on, hovering on a given row's point in a graph will display the row's image.NOTE: Requires JMP 12.

  brady_brady

  JMP Scripts |

  Jun 2, 2015 12:03 PM

  3288 views | 0 replies

• Barnsley Fern

  The JSL (attached, below) for this is deceptively simple.  It took me a long time to understand how the recursion happens.  It generates a million points--give it a minute or so.
  update: faster version attached.
  
  Barnsley fern - Wikipedia, the free encyclopedia
  
  If you are trying to understand the recursion, set the right-click->graph->marker-drawing-mode to fast, clear the row-states, and select the...

  Craige_Hales

  JMP Scripts |

  May 10, 2015 3:51 PM

  6920 views | 0 replies

• XY Function in JMP 12

  Script with examples of XFunction, YFunction, and XYFunction to go with blog post.

  Craige_Hales

  JMP Scripts |

  Apr 25, 2015 12:47 PM

  5809 views | 0 replies

• KDTable Spider

  KDTable spider example to go with blog post.  Try the creepy option.  Drag the small white square mouse handle around to move the 9-legged spider through the data.

  Craige_Hales

  JMP Scripts |

  Apr 10, 2015 7:58 AM

  6430 views | 0 replies

• KDTable Cloud

  Cloud example of KDTable to go with blog post.  The small white square is a mouse handle; drag it around to highlight the nearest points in the cloud.  Edit the script to change the cloud size from 20,000 to 2,000,000 points; the nearest neighbors (color points) are still found very fast, but showing the 2 million other gray points (check box) begins to get slow.

  Craige_Hales

  JMP Scripts |

  Apr 10, 2015 7:51 AM

  6496 views | 0 replies

• Demo Hough transform 2

  Demonstrate how the Hough transform accumulates hotspots at given angles and positions. You click in points in an x-y space and it accumulates the Hough transform for those points. Click points in a line, and it creates a hot spot.

  John_Sall

  JMP Scripts |

  Mar 26, 2015 12:59 PM

  2744 views | 0 replies

• Demo Hough Transform 1

  The script demonstrates the fixed points of a curve that is the Hough transform for points you click on. Cllick and drag around an x-y space, and it shows the Hough function. As you drag in staight lines, you understand that the function is fixed at a certain angle and position.

  John_Sall

  JMP Scripts |

  Mar 26, 2015 12:55 PM

  3053 views | 0 replies

• Interactive Valentine

  Duplicating this, but distorted and with color. If you size to isometric it will be a cardioid again. Interactive means there are two buttons to press. This is a small graphic script attached to a graph box; draws a bunch of circles in just the right places. The black outlines and transparent red fills conspire to make the edge and moire effects. Sin and Cos are swapped to get a traditional orient...

  Craige_Hales

  JMP Scripts |

  Feb 4, 2015 11:59 AM

  4803 views | 3 replies

• Column Formulas to CSV

  JSL to find the formulas in a JMP data table and write a CSV (comma separated value) file.  There is an open issue for exporting formulas to Excel; maybe this script can serve as a starting point to determine what is really needed. The code also demonstrates a simple use of Regex, user functions, and saving a file to the $TEMP directory.This code has only been tested on the included data table. wh...

  Craige_Hales

  JMP Scripts |

  Jan 15, 2015 7:00 AM

  4456 views | 2 replies

• JSON Parsing Functions

  This JSL file contains functions for converting JSON text into either a JSL data structure or a JMP data table. JSON represents a structure of nested "arrays" and "objects". JSON types/values are represented as follows in JSL:    JSON   JSLNotesarraylistsequence of valuesobjectassociative arrayset of named valuesnumbernumberstringstringtrue1.0false0.0null.missing valueWhen converted to a JMP data ...

  XanGregg

  JMP Scripts |

  Jan 5, 2015 11:05 AM

  12187 views | 2 replies

• Gauge Study Design

  Editors note: This script is now available as a JMP Add-in: Gauge Study Designer    This Gauge Study Design script creates an experimental design worksheet with randomization of columns within other columns.   Gauge studies are special designed experiments that support mixed models and require incomplete randomization. Random factors can not be randomized (days, repeats), but fixed factors should ...

  Di_Michelson

  JMP Scripts |

  Dec 5, 2014 6:08 AM

  7892 views | 0 replies

• Robust statistics for interlaboratory comparison data processing

  This script was developed for the processing of interlaboratory comparison data by robust statistics.It calculates the robust mean, the robust standard deviation, the standard uncertainty of the robust mean and the statistics of performance according to ISO 13528 standard.

  cedric_rivier

  JMP Scripts |

  Nov 19, 2014 1:53 AM

  2686 views | 0 replies

• Quick Reference lines with text comments system

  Hi everyone,Here is  a fun script to simplify tedious work like attaching references lines with comments on overlay graphs.  Hope you will find it useful. It definitely cut down on the time it took to prepare management reports ...etc. Its very simple to use 1. Just run the system and a pop up will appear. Select your data table and click ok.2.Select the appropriate columns (make sure both parame...

  estherloo2008

  JMP Scripts |

  Nov 14, 2014 7:30 PM

  3388 views | 0 replies

• RGB Color Matching Script

  
  This script is a suggested solution for Re: RGB Values to Color Names in Data Table.It uses the values in the Red, Green, and Blue columns to look for a color name in a color table and put the name in the Color Name Column.The script also sets the cell color for the sample and the color name. Here's an example of the results of running the script:The rows near the bottom, are exact color matches f...

  John_Powell_JMP

  JMP Scripts |

  Oct 16, 2014 11:28 AM

  9505 views | 0 replies

• Response Screening Script from Don McCormack

  Script for creating a sample Response Screening Demo for a 1001 column, 30 row table.  Users can run the script, and then interact with the Summary and Details.   Response Screening automates the process of conducting tests across a large number of responses. Your test results and summary statistics are presented in data tables, rather than reports, to enable data exploration. A  False-Discovery R...

  gail_massari

  JMP Scripts |

  Oct 8, 2014 8:03 AM

  3255 views | 0 replies

• iTunes library xml parser

  This script parses the iTunes XML library file to create an analysis ready JMP table.  This is useful if you want to visualize your iTunes library with play counts.  Or, use this as an example of parsing XML into a JMP table for more general use.Please note that you may have to edit the second line of the JSL to set an appropriate path to the iTunes library file on your machine.iTunespath = "~/Mus...

  Jon_Weisz

  JMP Scripts |

  Aug 29, 2014 11:56 AM

  3791 views | 0 replies

• Custom JMP application example

  This is an example application created with the JMP Application Builder.  The file will open to the Application Builder editor.  Choose Run Application from the red-triangle menu to run the application.  This example demonstrates several features of applications:Data Tables can be embedded in the windows with reportsMultiple live reports with full brushing and interactivity are combined in a singl...

  danschikore

  JMP Scripts |

  Aug 21, 2014 8:24 AM

  6701 views | 0 replies

• Column Filling

  This script will fill missing values within a column based on other occurrences of data:In this illustrative data table, we might choose to forward-fill the Jan Ozone column or back-fill the Dec Ozone column.For example, forward-filling the Jan Ozone column would set the value of 2.63 for the whole of 1955; back-filling the Dec Ozone column would set the value to 3.83 for the whole of 1955.This ty...

  David_Burnham

  JMP Scripts |

  Aug 16, 2014 10:58 AM

  4308 views | 0 replies

• Scales Simulator

  This script provides an simulator for a pair of scales that can be used interactively to perform measurements.There are three unknown weights (red, green,blue).Step 1: drag one or more of the unknown weights onto the scales:Step 2: drag counter-weights onto the scalesStep 3: the goal is to determine the unknown weights by achieving balance.This simulator has been used in a DOE workshop setting to ...

  David_Burnham

  JMP Scripts |

  Aug 13, 2014 1:07 PM

  4268 views | 0 replies

• Confidence Intervals of mean, stdev, & CV - by Groups

  This script calculates the mean, Stdev, CV, and their associated confidence intervals of a numeric analysis column, based on a selected Alpha, tabulated by selected groups.

  dbartholomeusz

  JMP Scripts |

  Aug 12, 2014 9:51 AM

  4132 views | 0 replies

• Simple Script for Random Draw from 1 to n

  This script prompts the user to enter a value for a random draw from 1 to n. The resulting number is displayed in a second window. For instructional purposes this script utilizes two different methods for drawing a window, Dialog() and New Window(). Instructions: Run the script and enter a value. Click "OK" to draw a random number from 1 to the value entered.

  julian

  JMP Scripts |

  Jul 9, 2014 10:02 PM

  2768 views | 0 replies

• JMP Wrapper for Overlaying Densities using R and GGplot2

  This script utilizes the JMP connection to R to create smooth-curve density plots with GGplot2, broken apart by the levels of a grouping variable. Means for each group can be plotted along with density curves.  This wrapper can be modified to utilize other GGplot2 and R-graphing packages by changing the commands sent to R.   Instructions: Run the attached script and specify a response variable an...

  julian

  JMP Scripts |

  Jul 9, 2014 9:33 PM

  7202 views | 0 replies

• Solving a Problem with the JSL Debugger Demo Script

  This is a sample script used in a JMP blog post about the JSL Debugger (Solving a Problem with the JSL Debugger). Please read the blog post for more information. This script has no use outside of the blog post.

  Melanie_J_Drake

  JMP Scripts |

  May 30, 2014 1:17 PM

  2536 views | 0 replies