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.

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