Related Resources: excel calculators

Advection of a Passive Scalar in One and Two Dimensions

NOTE:

• Refunds are not awarded after excel files have been downloaded - review your membership agreement for details.
• This excel spreadsheet may contain macros which will need to be enabled in your excel application, see web page: Enable macros in Downloaded excel files
• Units utilized within calculators are either SI or Imperial (some enable both SI and Imperial) and member (you) are responsible for conversions. Ensure that you verify units utilized in excel application meet your requirements before downloading.

Engineering Excel Spreadsheets

This workbook is intended for use as demonstrations in an introductory course in Computational Fluid Dynamics and Heat Transfer at the introductory graduate and advanced undergraduate level. It consists of two sheets. On the first one the user can select one of five separate differencing schemes for the transient, one-dimensional advection equation and input the Courant number. Numerical diffusion and dispersion are vividly illustrated as the initially-square wave is advected across the plot. Differencing schemes included are simple upwind, weighted upwind, Quick (third order), Flux-corrected Transport (FCT) and Total Variation Diminishing (TVD).

Download: Advection of a Passive Scalar in One and Two Dimensions