Excel & VBA Examples
← ChE 555: Applied Mathematics & Modeling for Chemical Engineers
- ChE 555 Excel & VBA Examples Page A Basic Tutorial of EXCEL EXCEL - VBA Links Anthony's framed page Chemical Process Modeling PC Software Excel a la Carte Excel - Chip Pearson's Excel Pages Excel - Essential Regression and Experimental Design Excel Toolbox Excel Tutorials Excel VBA Examples Excel for Windows Creating Visual Basic Macros that Use Microsoft Excel Solver Help for Microsoft Excel Solver Users Interval Solver Land-Grant Training Alliance Online Lessons Macro Systems - Productivity Products for Microsoft Excel Mathtools.net - Excel Microsoft® Excel 97 Quick Reference Microsoft Office Developer Forum - Excel - Advanced Spreadsheet Programming Microsoft Office Developer Forum - Microsoft Excel Articles and Sample Applications Microsoft Office Developer Forum - Office 97 Programmer's Guide - Contents Microsoft Office & VBA Developer - File Archives Microsoft Office 2000 Developer Technical Articles Ole P.'s Excel & VBA Tips Sam Raheb's Web Site SOFTSEEK.COM - Microsoft Excel Add-Ons, Tools, Utilities Spreadsheets Spreadsheets in Education Stephen Bullen's Excel Page The Spreadsheet Page VBA and Macro Function Reference Visual Basic for Applications - Visual Basic - Net Links Visual Basic Bookmark - VBA Tutorials VBA Code Examples Frontline Systems Inc.: Developers of Your Spreadsheet's Solver Help for Microsoft Excel Solver Users Help with specific Solver messages Elements of Solver models How the Solver handles constraints Linear and nonlinear functions Discontinuous and non-smooth functions Understanding the Solver Reports Interpreting the Reports An Example Model The Answer Report The Sensitivity Report The Limits Report Understanding the Solver Options Solver Options Max Time and Iterations Precision and Tolerance Assume Linear Model Show Iteration Results Use Automatic Scaling Estimates, Derivatives and Search Controlling the Solver with macros and VBA Algorithmic methods used by the Solver Solver Algorithms Linear Programming Quadratic Programming Nonlinear Programming Mixed-Integer Programming Hints for building readable, manageable models
- Frontline Systems Inc.: Developers of Your Spreadsheet's Solver Help for Microsoft Excel Solver Users Help with specific Solver messages Elements of Solver models How the Solver handles constraints Linear and nonlinear functions Discontinuous and non-smooth functions Understanding the Solver Reports Interpreting the Reports An Example Model The Answer Report The Sensitivity Report The Limits Report Understanding the Solver Options Solver Options Max Time and Iterations Precision and Tolerance Assume Linear Model Show Iteration Results Use Automatic Scaling Estimates, Derivatives and Search Controlling the Solver with macros and VBA Algorithmic methods used by the Solver Solver Algorithms Linear Programming Quadratic Programming Nonlinear Programming Mixed-Integer Programming Hints for building readable, manageable models