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

 

April 2014

S M T W T F S
  12345
6789101112
131415 16 171819
20212223242526
27282930   

Tags

    Recent Entries

    Recent Comments

    Search My Blog

    0 user(s) viewing

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