Clean Air-Cool Planet Climate Action Toolkit


Calculation of Emissions from Raw Data

Once you've collected your data, the Calculator makes emissions calculations relatively easy. Once the data is entered into the appropriate cells of the spreadsheet, and a few other parameters are specified (such as the regional electricity pool from which the institution purchases), the calculations are made. (All formulas, conversion factors, emission factors, etc. are already built-in. The formulas and factors can be altered - they can all be viewed and examined by anyone who is reasonably proficient with MS Excel - but they should ordinarily not be.)

The beauty of this tool is that one does not have to get into the fairly complex math and science involved in estimating greenhouse gas emissions from the various activities of a college/university that cause them - simply enter the data required in the proper units on the two ‘Inputs' worksheets, and the Calculator will do the rest!

Sample Input Table, from which total emissions are tabulated by the Calculator:

MODULE Input            
WORKSHEET Data            
UNIVERSITY        
Transportation
Fiscal Year   University Fleet Air Travel
    Gasoline Fleet Diesel Fleet Natural Gas Fleet Electric Fleet Other Fleet Faculty / Staff Business Student Programs
                 
    Gallons Gallons MMBtu kWh MMBtu Miles Miles
1990                
1991                
1992                
1993                
1994                
1995                
1996                
1997                
1998                
1999                
2000                
2001                
2002                
2003                
2004                
2005                
2006                
2007                
2008                
2009                
2010                
2011                
2012                
2013                
2014                
2015                
2016                
2017                
2018                
2019                
2020