VBA Excel Functions for Compressible Flow. Houghton and Brock Tables

Click For Summary
SUMMARY

This discussion presents a comprehensive set of VBA Excel functions designed for solving compressible flow problems, specifically based on the equations from 'Tables for the Compressible Flow of Dry Air 3rd Ed' by E.L. Houghton and A.E. Brock. The functions cover various flow scenarios including Isentropic Flow, Prandtl-Meyer Expansion, Raleigh Flow, Fanno Flow, Plane Normal Shock, and Plane Oblique Shock. Users can achieve high accuracy, typically around 7 significant figures, and utilize the SOLVER add-in for iterative problem-solving. The attached workbook contains these functions, providing an efficient alternative to traditional flow tables.

PREREQUISITES
  • Familiarity with VBA programming in Excel
  • Understanding of compressible flow concepts
  • Knowledge of the Houghton and Brock flow tables
  • Experience using Excel's SOLVER add-in
NEXT STEPS
  • Explore advanced VBA techniques for optimizing Excel functions
  • Study the principles of compressible flow in greater detail
  • Learn about the implementation of inverse functions for oblique shocks
  • Investigate alternative methods for solving flow problems in Excel
USEFUL FOR

This discussion is beneficial for students and professionals in aerospace engineering, mechanical engineering, and anyone involved in computational fluid dynamics who seeks to enhance their understanding of compressible flow using Excel tools.

MechCaptain
Messages
2
Reaction score
0
G'day!

This is my first post on this forum and I hope you find it usefull!

Attached are complete set of Excel functions for

*Isentropic Flow
*Prandlt Meyer Expansion
*Raleigh Flow
*Fanno Flow
*Plane Normal Shock
*Plane Oblique Shock

They are contained in the attached workbook (zipped as it is bigger than 100kB).

For my compressible flow class I began writing some VBA functions to solve the implicit area ratio mach number formula for Isentropic compressible flow.
The project morphed into a complete VBA implementation of the equations presented in 'Tables for the Compressible Flow of Dry Air 3rd Ed' by E.L. Houghton and A.E. Brock.

The functions allow problems to be set up and solved in the same way a student would using a book of flow tables but with the accuracy produced by the analytical equations.

Iterative problems can easily be solved using the SOLVER add in.

Flow tables for gases with different gamma can be easily be produced.

The iterative functions are typically accurate to around 7 significant figures.

AndyPS, Moderators: This post may belong on some sort of 'resources' thread or a sticky if you think its worth it.
 

Attachments

Last edited:
Physics news on Phys.org
Found I did not implement a couple of the inverse functions for Oblique shock properly. This is fixed now
 

Attachments