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:

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!
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:

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
← January 2021 →
S | M | T | W | T | F | S |
---|---|---|---|---|---|---|
1 | 2 | |||||
3 | 4 | 5 | 6 | 7 | 8 | 9 |
10 | 11 | 12 | 13 | 14 | 15 | 16 |
17 | 18 | 19 | 20 | 21 | 22 | 23 |
24 | 25 | 26 | 27 | 28 | 29 | 30 |
31 |
Tags
Recent Entries
My Blog Links
Recent Comments
Search My Blog
0 user(s) viewing
0 Guests
0 member(s)
0 anonymous member(s)
0 member(s)
0 anonymous member(s)