CFD In Excel Essay Example

circular reference (sometimes referred to as the iteration') feature of the spreadsheet package. The voracity-stream function formulation requires post-processing to obtain velocities procedure that can be automated in the spreadsheets solution of a Poisson equation for pressure. Moratoria et al.

[7] show how various aeronautical problems can be solved using the matrix inversion and circular reference solution functions.

Although the numbers of changing cells and constraints are limited by Solver, its use provides a straightforward way to solve the discredited heat rancher and fluid flow equations. In this paper we show how Solver can be used to solve a relatively simple but nonlinear heat conduction problem and the incompressible Navies-Stokes equations in primitive variable form on a staggered grid. An INTRODUCTION THE SEE OF spreadsheets for solving the finite difference equations resulting from discrimination of the governing differential equations for heat conduction is well documented.

Moniker and Anta [1 , 2] describe how the iteration capability of spreadsheets can be used to solve multidimensional steady and transient conduction problems.

They also discuss how the contour plot feature can be used to easily visualize results (contour plots in Excel are, however, limited to plotting results in relatively simple geometries). Schuman [3] describes how the Solver tool in Excel can be used to solve two-dimensional steady conduction problems.