Subscribe to Anarion's Blog        RSS Feed
-----

Time Series Data Forecasting

Icon Leave Comment
One of my courses this semester is Production Management and a key part of it is forecasting methods. Given the headaches of doing all those repetitive calculations by hand, I soon got the habit of doing my homework in MS Excel. It's a great software I have to say...
But I thought why not make a customized software for it myself? Which does exactly the needed job, outputs the right information and all that stuff by just giving it the input data and everything else happens automatically.
Well, this is also possible in MS Excel if I could write an add-in or something similar but then again, I'm kinda a do-it-all-yourself man. So, here's what I've done:

Attached Image

Still not a complete package, right now it only takes care of Moving Average and Double Exponential Smoothing methods. Exponential Moving Average, Exponential Smoothing and Triple Exponential Smoothing, which is used for trend-based data with a seasonal factor, have to be implemented as well.

On top of them all, a graphical user interface should do the magic!

0 Comments On This Entry

 

September 2014

S M T W T F S
 123456
78910111213
14151617 18 1920
21222324252627
282930    

Tags

    Recent Entries

    Recent Comments

    Search My Blog

    0 user(s) viewing

    0 Guests
    0 member(s)
    0 anonymous member(s)