This suggestion has several requests.
1. Make a Mac version of the JMP add-in for Excel.
The current JMP add-in for excel has a lot of nice features. The primary feature necessary for data import are the preference tab, and the Import Table feature.
2. Update the preference tab: Add an "advanced" drop down that includes the relevant Excel import Wizard options. For example Start and Stop columns and row options can be excluded since the data range is defined. Including the "treat hierarcheal..." would specifically be nice to add.
3. Add a source script to the data imported from the data table button in the add-in.
Note on the Mac Excel add-in
Its been 5 or 6 years (7 maybe) since the Excel JMP Add-In was a bright shiny new feature for Windows only.
Several times a week I demo Getting Started with JMP which always includes importing data from Excel into JMP. On a Mac you can't get there from here.
The Microsoft copy and paste only copies visible data from the excel sheet to the clipboard, where the add-in gets the unformatted data. Rounded data are WYSIWYG copied, the actual values are imported from the add-in, which makes the copy and paste option potentially dangerous.
The reasons why Johns Mackintosh Product doesn't have the Excel JMP add-in for Mac are included in a nice post from Jeff P from 2017. It seems like technology or expertise may have progressed enough since then to advance this less-than-sexy utility feature that Mac customers would use every day when they bring data into JMP?
