Martin Demel's Blog

Latest Posts

• JMP and Excel - A never ending story? - Part 1 - cont.

  Spreadsheets are often used to gain better overview of the data. This leads to structures hard to do statistics with. Learn how to read non-trivial structured data from spreadsheets into JMP. This time when multiple worksheets as well spreadsheets have to be imported. Note: Though JMP can read spreadsheet files both on Mac and Windows, with different tools than Excel, I refer in my posts to a wind...

  martindemel

  Martin Demel's Blog |

  Dec 21, 2023 11:02 AM

  6173 views | 0 replies
  

• JSL:Selecting cols with Filter Col Selector and hot spot functionality Show Filter as "default"

    Almost all platforms in JMP have the same structure in the platform window, and selecting columns can be hard if you have many. Good thing you have a filter in the hot spot.Now you build your own application and you want to have this filter opened as default - how to do so?           

  martindemel

  Martin Demel's Blog |

  Dec 21, 2023 10:33 AM

  4559 views | 5 replies
  

• JMP and Excel - A Never ending story? - Part 0

    Excel sheets are still a common source of data. For analytical purpose JMP users know better tools, but how to make good use of JMP’s functionalities if the data is in a shape that is not easy to import. How to handle different structures, multiple sheets in one table, different date formats, localization challenges and similar?          

  martindemel

  Martin Demel's Blog |

  Dec 21, 2023 10:30 AM

  2463 views | 0 replies
  

• Updating a JMP data table from a spreadsheet made easy - Part 1

  Get your current JMP data table updated with new data from a (vertical structured) spreadsheet, preserving your made changes in the current data table.

  martindemel

  Martin Demel's Blog |

  Dec 21, 2023 10:22 AM

  4336 views | 6 replies
  

• JMP and Excel - A never ending story? - Part 1

  Data Structure and Data Import Spreadsheets are often used to gain better overview of the data. This leads to structures hard to do statistics with. Learn how to read non-trivial structured data from spreadsheets into JMP.

  martindemel

  Martin Demel's Blog |

  Dec 21, 2023 8:29 AM

  4446 views | 0 replies
  

• Come to the Attendee-driven DOE Q&A Sessions at Discovery Summit Europe Online!

  Join us on Monday 20 March, 13:00-16:00 CET, for this lightly structured discussions to share your ideas, ask your questions, get answers, and learn more about Design of Experiments in JMP. 

  martindemel

  Martin Demel's Blog |

  Mar 14, 2023 8:08 AM

  650 views | 0 replies
  

• Join our Viking Ship in our Predictive Modeling Unsession

  Submit your predictive modeling feedback here   Europe’s JMP 2021 Discovery Conference has gone virtual with that we are excited to announce the first European Predictive Modeling Unsession, which will take place on March 8! 

  martindemel

  Martin Demel's Blog |

  Feb 11, 2021 9:19 AM

  1486 views | 0 replies
  

• Updating a JMP data table from a spreadsheet made easy - Part 2

  Get your current JMP data table updated with new data from a (horizontal structured) spreadsheet, preserving your made changes in the current data table.

  martindemel

  Martin Demel's Blog |

  May 20, 2020 7:07 AM

  3337 views | 0 replies
  

• Keep watching for your golden batch

    Understanding early in a batch process if the yield fullfills your requirements is critical to avoid plenty of waste and lost time. Take a look how the Functional Data Explorer in JMP Pro (as of version 14) can help you!

  martindemel

  Martin Demel's Blog |

  Oct 30, 2018 9:56 AM

  1784 views | 0 replies
  

• JMP and Excel - A Never ending story? - Part 2 cont.

  The title probably better would have been "Dates - a never ending story". Read how you can avoid or work around challenging situations with date values.

  martindemel

  Martin Demel's Blog |

  Feb 16, 2017 4:50 PM

  2522 views | 1 replies
  

• JMP and Excel - A Never ending story? - Part 2

  Be aware of data issues making importing data a challenge, if not a nightmare. I will talk about typical issues, from two year digit rules to decimals and commas - a very common issue in non-US countries. 

  martindemel

  Martin Demel's Blog |

  Jan 31, 2017 8:38 AM

  3788 views | 0 replies