Last Updated: 9/20/05
Excel/VBA Spreadsheet for Elliptic Grid Generation
If you click on the title below, a Microsoft Excel workbook
will be downloaded to your computer. This workbook uses a module written in
Visual Basic for Applications (VBA), Excel's macro language. It was written
under Windows, but should work under MS Office running on a Macintosh. Earlier
versions of MS Office on both platforms may not support all features used in
this workbook.
Disclaimer
No warranties, expressed or implied, are made that this
program is free from error, or is consistent with any particular standard of
merchantability, or will meet your requirements for any particular application.
This program should not be relied on for solving problems whose incorrect
solution could result in injury or lost property. If you use this program in
such a manner, it is at own risk. The author disclaims all liability for direct
or consequential damages resulting from your use of this program, i.e.,
SOFTWARE THAT IS FREE HAS NO GUARANTEE!
This Excel workbook contains macros written in Visual Basic
for Applications, so that when you open it you will probably see a warning
like, "[filename] contains macros. Macros may contain viruses. It is
always safe to disable macros, but if the macros are legitimate, you might lose
some functionality." Then you are given the choices: "Disable
Macros", "Enable Macros" and "More Info". In the case
of this spreadsheet, you must select "Enable Macros" or it will not
work at all! (If you not even offered this choice, then your security is
probably set at "High." You must have your security level in Excel
set at "Medium," which allows you to "choose whether or not to
run potentially unsafe macros.") My virus checker is set to update
automatically every day (yours should be too!). You might scan these materials
(and anything else containing macros you might download from the Internet)
before opening them, but then you MUST enable macros!
Grid Generation (Updated: 9/20/05)
This workbook
implements elliptic grid generation for a converging-diverging nozzle. Scrollbars allow the user to input the
nozzle contour of his or her choice.
The VBA coding implements a well-known scheme for elliptic grid
generation. The user can select
either a pair of Laplace or Poisson equations. In the latter case there is some control
given over the magnitude of the Poisson terms, which may be used to attract or
repel grid lines from the boundaries and to affect the angles at which lines
intersect the boundaries. The case
seen in the figure uses both.
Back to Heat Transfer Tools
Main Page