topic Re: predcition formula into excel in Discussions

predcition formula into excel

Lu — Sat, 10 Jun 2023 23:35:56 GMT

Hello,

I want to use a predcition formula form a least square prediction model generated in JMPpro to be saved in and excel database so that non-JMP users would able to use the prediction formula. It seems that I can save the formula in several formats but not in excel format. Any suggestion?

regards

Re: predcition formula into excel

txnelson — Sun, 22 Aug 2021 15:38:26 GMT

You are correct. JMPPro does not have a built in JMP to Excel prediction formula translator. However, many of the generated least square prediction formulas can easily be translated into Excel. Not knowing the complexity of the formula you are generating, it is tough to be able to make any real definitive statement on how or if the formula can be converted.

Re: predcition formula into excel

P_Bartell — Mon, 23 Aug 2021 10:57:19 GMT

In addition to everything @txnelson has shared, since you are using JMP Pro, depending on the specific scoring code language used in the 'database', you may be able to write the prediction formula in that language as scoring code using the JMP Pro Formula Depot scoring code export utility? Here's a link to the online JMP Pro documentation with details...

Scoring Code in JMP Pro Formula Depot