Solving Linear Programming Problems Using Excel
Software that solves moderately large linear programming problems is readily available. You can find programs on the internet. Software comes with many textbooks. Standard spreadsheet programs often can solve linear programming problems. In this course, we will use the solver tool found on Excel to solve problems. I request that you use this program. If you would strongly prefer to use other software, then talk to me.
Read more
Computer Simulation Using Excel without Programming
Defining Simulation in its broadest aspects as embodying a certain model to represent the behavior of a system, whether that may be an economic or an engineering one, with which conducting experiments is attainable. Such a technique enables the management, when studying models currently used, to take appropriate measures and make fitting decisions that would further complement today’’s growth sustainability efforts, apart from cost decrease, as well as service delivery assurance.
Read more
An Excel/Visual Basic for Applications (VBA) Programming Primer
In the past, even mildly complicated engineering calculations have not mixed well with spreadsheets because of the very strong tendency to wind up with nearly-impossible-to-debug “spaghetti code”. While most students seem to enjoy using spreadsheets, instructors recognize that other than by finding the “correct” answer printed somewhere, it is next to impossible to grade assignments or to help the occasional student debug them. However, by using Visual Basic for Applications (VBA) in conjunction with the Excel spreadsheet, the user has the convenience of a spreadsheet for neatly-formatted input/output and for graphical display of results, i.e., to function as a graphical user interface (GUI).
Read more
Microsoft Excel Programming - Why and How
Most people think of Excel as merely a spreadsheet program, and with good reason— Excel is a spreadsheet program. As a spreadsheet program, Excel is a powerful application that provides a wide range of tools for the manipulation, analysis, and display of data. The majority of users never go beyond using Excel in this way—truth be told, many users have no need.
Read more
What Is VBA
This chapter is completely devoid of any hands-on training material. It does, however, contain some essential background information that assists you in becoming an Excel programmer. In other words, this chapter paves the way for everything else that follows and gives you a feel for how Excel programming fits into the overall scheme of the universe.
Read more