935265_en-US

liliconcom

Seasonal Exponential Smoothing

Have determined data best fits seasonal exponential smoothing forecast model.  Doing my yearly forecasting but have hundreds of materials numbers to do my forecast. This is an extremely long and tedious process to do a forecast for each material number. 

Steps

Set up actual data in excel JMP format.

First column month YR

Next 100 columns actual sales data for each material number .

import data into JMP

Analyze \ Specialized Modeling \ Time Series

Add Month YR to X, Time ID

Add material numbers to Y, Time Series

Click OK

Predictive Modeling and Machine LearningRe: Seasonal Exponential Smoothing

I don't see an actual question.  My assumption is that your question is, how do something in JMP that can reduce the time/effort it takes to do the steps you specified.

Most of the steps you mentioned can be handled by setting up a Workflow in JMP, or in just running the steps you indicate, and capturing the scripts that JMP uses for those steps, and then putting it all together in a script.

However your 

     Analyze \ Specialized Modeling \ Time Series

seems to ambiguous to treat in the same way, and too nonspecific to give any advice on how to handle it.  Detailing all of the steps you do in the Analyze \ Specialized Modeling \ Time Series steps, along with any diversions you need within the steps would something that needs to be done to allow the Community to evaluate how to automate this.