cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
] />

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
jtessom
Level I

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

1 REPLY 1
txnelson
Super User

Re: 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. 

Jim

Recommended Articles