cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar

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
nascif_jmp
Level VI

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

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.

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
nascif_jmp
Level VI

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!

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.