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

These models are associated with various 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)