Welcome to the JMP User Community!

Latest Discussions

• Jsl error when reading excel file that is open by excel :: There was an error opening the file.

  Hi, I was wondering any work around this. The case is I have my windows and excel file is open that I edit and save. Meanwhile, I try to open that excel file with jsl for further data processing (the *.xlsx still open with Excel while I'm doing this.) When I try to open that file I get this error              "There was an error opening the file." Is there any work around this ? This excel file is...

  joshua

  Discussions |

  Aug 6, 2023 5:00 AM

  1757 views | 3 replies

• Talking to Display boxes

  The auto-generated script to generate this plot is Graph Builder( Variables( X( :height ), Y( :weight ), Overlay( :sex ) ), Elements( Points( X, Y, Legend( 1 ) ), Smoother( X, Y, Legend( 2 ) ) ), SendToReport( Dispatch( {}, "X title", TextEditBox, {Set Text( "xxx" )} ) ) ) - Why "X title"? - What is a robust way to talk later with the X axis title. current Report()[TextEditBox(3)]seems to work ...

  hogi

  Discussions |

  Aug 4, 2023 11:39 AM

  1233 views | 2 replies

• How do I Import data from a large number (>100) of excel files, each containing a number of worksheets/tabs, into one JMP file.

  I need to import (into JMP) specific Excel worksheets from a number of excel files and the data in the JMP file must be stacked with a ID column specifying the file origin.The Excel import wizard makes it relatively easy to import and stack two or more selected worksheets from a single file (see script below). The data is structured similarly in the different worksheets.If possible I need to impor...

  hhi

  Discussions |

  Aug 4, 2023 3:04 AM

  2621 views | 5 replies

• Rolling and Expanding window forecast in 17

  Is there a function in J17 to automate multiple rolling window forecasts for time series and include forecast errors MSE,MAE,etc.

  ParametricSteer

  Discussions |

  Aug 4, 2023 1:05 AM

  712 views | 0 replies

• Using Graph Builder is it possible to manually move reported Means and St Devs?

  Using Graph builder I'm struggling to make graphs that list the mean and standard deviations of box plots. I discovered I could use the boxplot & Line of Fit to report the means and stardard devs next to each factor, but the reported numbers are oddly positioned. I was hoping there would be a way to simply manually move these values on the graph so that the overall graph looks better. Is there a w...

  ndowidar

  Discussions |

  Aug 3, 2023 5:31 PM

  1052 views | 1 replies