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

 

November 2014

S M T W T F S
      1
2345678
9101112131415
16171819202122
232425262728 29
30      

Tags

    Recent Entries

    Recent Comments

    Search My Blog

    0 user(s) viewing

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