Modeling I
Publisher Summary
The objective of this chapter is to show how to layout a worksheet, which is difficult for many users. The chapter comprises many exercises that include population model, vapor pressure of ammonia, stress analysis, and circuit analysisIt observes how population model predicts the changing populations and examines the sensitivity of the model to the values of the parameters. Stress analysis exercise demonstrates a practical use of matrix algebra to solve a system of linear equations. In the exercise pertaining to centroid of a polygon, an example is shown of a UDF that solves a real world problem. It is wished to enter the coordinates of the vertices of a polygon into a worksheet and have the UDF return the ...
Get A Guide to Microsoft Excel 2007 for Scientists and Engineers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.