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
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
INTRODUCTION TO VISUAL BASIC FOR APPLICATIONS (VBA)
This tutorial introduces you to Visual Basic for Applications (VBA), a version of Visual Basics which comes with Microsoft Excel. You will learn how to type in and run a simple program in the form of a Function block.
Read more