The survival of a business is nowadays more than ever a matter of utmost importance. The process of globalization and current economic crisis are the two main reasons that caused the situation of uncertainty and instability on the world market. In this paper we made a theoretical approach and...

We discuss the importance of spreadsheets for optimization modeling, including a description of their limitations for large-scale problems. We then describe efficient ways to overcome these limits. Our approach makes use of Excel's standard functionality but augments Excel with its programming...