Plant Ecology in a Changing World
  • Topics
    • Topic Overview
    • Biomes and Climates in a Changing World >
      • Adaptation, biodiversity, and environment
      • Climate constrains plant distributions
      • Biome and climate relationships
      • Deserts
      • Grassland, savanna, and shrub biomes
      • Forest biomes
      • Alpine and tundra biomes
    • Plant adaptation >
      • Plant microclimate 1
      • Plant microclimate 2
      • Leaf energy budgets
      • Water movement through the soil-plant continuum
      • Principles of photosynthesis
      • Photosynthesis responses to light and temperature
      • Environmental stresses limit resource capture and use
      • Nutrients in the environment
      • Adaptation to environmental stress
    • Resource Allocation Changes with Environment >
      • Architecture and canopy processes
      • Plant phenology and resource allocation enhance performance
      • Leaf economic spectrum
      • Life history and reproduction
      • Defense against herbivory
      • Plant competition
    • Plant Responses to a Changing World >
      • Global changes occurring today
      • Invasive species
      • Atmospheric CO2 impacts plant
      • C3/C4 photosynthesis and climate
      • Climate change and the global carbon cycle
      • Climate warming and its impacts
    • Engineering Plant Communities >
      • Remember Utah's past and envision our future
      • Restoration ecology
      • Managed ecosystems
      • Utah urban ecology
      • Urban ecological futures
  • Assignments
    • Assignment Overview
    • Discussion
    • Problem sets
    • Ecology & Global Changes
    • Plant ecology policy
    • Defense of policy
    • Exam #1
    • Exam #2
  • Campus
    • Campus Overview
    • Grasses
    • Green infrastructure >
      • GI Overview
      • Stormwater >
        • GI 1
        • GI 2
        • GI 3
        • GI 4
        • GI 10
      • Green roof
      • Pollinator >
        • Pollinator species
    • Trees of the Wasatch
    • Shrubs of the Wasatch
    • Invasives
  • Biomes
    • Biome Overview
    • Climate diagrams
    • Vegetation sight-seeing trip
    • Biome images
  • Models
  • Lab


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.

Picture
  • 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)
Jim Ehleringer, University of Utah