Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted

How to export column formulae?

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

Re: How to export column formulae?

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!

View solution in original post

4 REPLIES 4
Highlighted

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
txnelson
Super User

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

Re: How to export column formulae?

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!

View solution in original post

Highlighted

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.


Article Labels

    There are no labels assigned to this post.