Abstract
In this paper, the virtues of spreadsheet computation are demonstrated by determining the well-known lift and drag characteristics of a symmetric double wedge airfoil in supersonic flow. The computations require the use of shock-expansion theory of gas dynamics. This determination is a standard problem in gas dynamics that, while simple in nature, involves considerable computation. Spreadsheet solvers greatly diminish this effort and allow students to focus more on the physics of the problem. Moreover, they enable students to explore the problem in more detail.
Get full access to this article
View all access options for this article.
References
1.
John
JEA
Keith
TG.
Gas dynamics . 3rd ed. Upper Saddle River, NJ: Pearson Prentice Hall, 2006 .
2.
Anderson
JD
Jr.
Modern compressible flow with historical perspectives . 3rd ed .
New York :
McGraw-Hill Book Company , 2002 .
3.
Hodge
BK
Koenig
K.
Compressible fluid dynamics with personal computers applications .
New Jersey :
Prentice Hall , 1995 .
4.
Oosthuizen
PH
Carscallen
WE.
Compressible fluid flow .
New York :
McGraw-Hill Book Company , 1997 .
5.
Zucker
RD
Biblarz
O.
Fundamentals of gas dynamics . 2nd ed .
New Jersey :
John Wiley & Sons, Inc ., 2002 .
6.
Shapiro
AH.
The dynamics and thermodynamics of compressible fluid flow .
Vol.1
New York :
Ronald Press , 1953 .
7.
Chapman
CJ.
High speed flow .
Cambridge, UK :
Cambridge University Press , 2000 .
8.
Liepmann
HW
Roshko
A.
Elements of gasdynamics .
New York :
John Wiley & Sons, Inc ., 1957 .
9.
Bureau of Ordnance.
Handbook of supersonic aerodynamics
. NAVORD Report 1488 (Volume 3). Washington: Author, 1957 .
10.Compressible Aerodynamics Calculator 3.0. www.dept.aoe.vt.edu/∼devenpor/aoe3114/calc.htmlAQ6 (accessed December 2018).
11.Compressible Flow Calculator, www.aerospaceweb.org/design/scripts/compress.shtml (accessed December 2018).