Spreadsheet Fluid Dynamics

Abstract

plate are con ned to a very narrow zone near the wing root. This is probably due to the presence of a strong cross ow in the inboard direction, typical of forward-swept wings, that limits the spanwise propagationof the interferenceeffects.Therefore,one may conclude that, for these types of wings, the experimental data are affected by the interference with the splitter plate only in a limited zone close to the wing root. NomenclatureGr = Grashof number Nu = Nusselt number P = excess pressure Pr = Prandtl number p = static pressure Ra = Rayleigh number (DPr Gr ) Re = Reynolds number T = temperature t = time u, v = velocity components x, y = coordinates = vorticity à = stream function

Teaching Computational Fluid Dynamics Using Spreadsheets

“…Use of spreadsheets specifically for fluid flow is less common. Both Fraser and Thorpe [14] and Morishita et al [18] demonstrate the simulation of ideal flow using spreadsheets. Morishita et al also solve several other types of fluid flow problems, including boundary layer problems using Runge-Kutta, Panel methods, potential methods for transonic flow, Euler flow via the method of characteristics, and, impressively, full solution of the incompressible Navier-Stokes equations using FD techniques.…”

Cavity Mode Excitation by Vortex Shedding from a Cross-Beam

“…By similarly neglecting small 'end corrections' at compared to the contribution to sound generation by the section of the vortex above the mouth in it is also permissible to use a two-dimensional approximation for . This is very convenient, because in two dimensions Laplace's equation can be solved very easily for different positions of the cross-beam using a conventional 'spread sheet' programme on a personal computer [11,12].…”

“…The acoustic pressure given by equation 9is periodic with fundamental frequency . The pressure spectrum is therefore discrete, and can be expressed in terms of the Fourier transform of defined by (10) To do this we first write equation (9) in the form (11) and introduce the formula [13]…”