Skip to main contentSkip to footer content

Ted Dibble
Teaching Resources


Collection of Spreadsheets for Atmospheric Chemisty Calculations

  1. Rate Constants for Termolecular Reactions - This Excel spreadsheet is designed to take input from the Jet Propulsion Laboratory Data Evaluation (see link below) and compute effective second order rate constants for pressure-dependent reactions. The spreadsheet has notes which explain how to use the data from the JPL Data Evaluation.(JPL Data Evaluation #15)  - See pages 2.1 - 2.3 (pp. 134-136 of the full pdf file) of this document for instructions, and pages 2.4 - 2.7 for input parameters.
  2. Calculating Solar Zenith Angle - Excel file fof calculating angle of the sun's rays from the vertical, called the Solar Zenith Angle (SZA), and explained here. Requires input of date, Greenich Mean Time, latitude, and longitude. Latitude and Longitude can be determined via these links for world cities and for US cities or zip codes.
  3. Calculating Photolysis Rates - Excel file for ground-level calculations at various solar zenith angles. Data for other altitudes may be found in Chemistry of the Upper and Lower Atmosphere by Barbara J. Finlayson-Pitts and James N. Pitts, Jr. Input data may be obtained from that text or Section 4 (pp 162-272 of the pdf file) of the JPL Data Evaluation.
  4. Spectra of Photochemically Active Compounds - Graphs of spectra and tables of absorption cross-sections for selected compounds (Excel format). 

Ozone Data

  • Column ozone data NASA -   Follow the development of the ozone holes by calling up the images of the South Pole from late August through October, or the North Pole from January through March.
  • Air Quality Conditions  - EPA color-coded maps showing records and predictions of air quality (ozone and particles) from across the United States.

Databases for Kinetics and Photochemistry

Climate Change