Heat Transfer Today

Educational Software for
Heat and Mass Transfer

Excel Workbooks

1976 U.S. Standard Atmosphere

UPDATED: 08/22/2022

This spreadsheet calculates the temperature, pressure and density corresponding to the 1976 U.S. Standard Atmosphere. The user can input any altitude and the three values are returned. Plots like that seen below for temperature are provided for pressure and density as well.    The VBA functions included can be copied and used elsewhere.

Temperature as a function of altitude. 1976 U.S. Standard Atmosphere.

 

This worksheet can be copied into other workbooks to facilitate altitude-dependent calculations.    A PowerPoint presentation explains the underlying physics.

© 2021 Heat Transfer Today – All Rights Reserved.