Here you will find Excel-based models used in this class.

These models are associated with various in-class exercises.

You must download the XLSX file to perform the calculations.

In each model, yellow cells are associated with your inputs. Other cells are associated with various model outputs.

• Solar radiation incident on a surface (any slope angle, azimuth, time of day, or day of year)
• Site water balance for any location in the Wasatch Mountains (monthly and annual)
• Leaf temperature (any combination of climate and leaf coupling factors)
• Photosynthetic rate of a C3 leaf (based on Farquhar models)
• Canopy light penetration and photosynthesis (any distribution of leaf area and photosynthetic capacity)​
• ​Mojave Desert shrub 40-year annual population and ecophysiology data sets (Encelia farinosa, Encelia frutescens, & Ambrosia salsola)