Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Aerospace VBA Excel Functions for Compressible Flow. Houghton and Brock Tables

  1. Dec 25, 2012 #1
    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.

    Andy


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

    Attached Files:

    Last edited: Dec 25, 2012
  2. jcsd
  3. Dec 27, 2012 #2
    Found I did not implement a couple of the inverse functions for Oblique shock properly. This is fixed now
     

    Attached Files:

Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: VBA Excel Functions for Compressible Flow. Houghton and Brock Tables
  1. Compressible Fluid Flow (Replies: 10)

Loading...