How to export column formulae?

[#1]

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...???

[#2]

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.

[#3]

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

[#4 · Accepted solution]

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!

[#5]

Thanks for the input.

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