Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- JMP User Community
- :
- Discussions
- :
- How to export column formulae?

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

May 15, 2020 12:33 AM
(1722 views)

I have used the neural platform to create a model which a colleague of mine want to use with another software (abaqus in this case). The problem is that the final model is distributed over 6 columns in JMP (1 column for each of the nodes and 1 for the function relating the nodes to the predicted value).

The model works perfectly fine, but currently I'm "copy-pasting" all the model coefficients manually from the formula editor for each of the six columns.

Is there are better way of doing this and exporting the formulae directly to matlab, excel, an ASCII file...???

1 ACCEPTED SOLUTION

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

What @txnelson said. You mentioned Excel - it looks like one can define an Excel formula based on JavaScript, so you should be able to use the JMP neural network code, converted to JS, directly into your spreadsheet with no manual recoding (which you really want to avoid for such large models).

https://github.com/OfficeDev/Excel-Custom-Functions

https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-overview

I haven't tested it, but based on what I read I think it would work. Let's us know if you try it out!

4 REPLIES 4

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to export column formulae?

I've just seen that by using "Save Profile Formulas" instead of "Save Formulas" one gets the final equation in a single column rather than in several columns. Then copy-pasting it into matlab in a single operation is straight forward.

However, the variable names still need to be changed (because of the ":"). If there's a better solution, I'm still interested.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to export column formulae?

The Formula Depot in JMP Pro, will allow you to export your formula to C, Python, JavaScript, SAS or SQL

Jim

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

What @txnelson said. You mentioned Excel - it looks like one can define an Excel formula based on JavaScript, so you should be able to use the JMP neural network code, converted to JS, directly into your spreadsheet with no manual recoding (which you really want to avoid for such large models).

https://github.com/OfficeDev/Excel-Custom-Functions

https://docs.microsoft.com/en-us/office/dev/add-ins/excel/custom-functions-overview

I haven't tested it, but based on what I read I think it would work. Let's us know if you try it out!

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: How to export column formulae?

Thanks for the input.

Unfortunately I don’t have JMP Pro, so I’ll go on with copy/paste, I guess.

Unfortunately I don’t have JMP Pro, so I’ll go on with copy/paste, I guess.

Article Labels

There are no labels assigned to this post.