Sustainability Decision Tool

The Sustainability Decision Tool was designed by Ben Ewing and Rose Zdybel, while graduate students at UMass Amherst under the supervision of Professor Erin Baker.  The tool is designed to help people make decisions regarding energy usage, considering financial, environmental, and health-related concerns.

The tool is an excel spreadsheet and can be found here:

Decision tools – spreadsheet
Decision Tool spreadsheet May 11, 2010 release

Instructions for Energy Tool (please send comments to Rose Zdybel (

Papers describing the Tool can be found here:


Development of Green Building Decision Support Tool

A discussion of  a collaborative process for developing a decision tool to support decisions around investment in green energy technologies.  Our tool was developed specifically for the Hitchcock Center for the Environment, a local environmental education organization, and the development process began as an undergraduate student service learning project. Building on the student projects, we developed an Excel-based tool that allows users to select various combinations of technologies and instantly see the financial and environmental impacts of their choice.  Given our initial parameters and the preferences of the Hitchcock Center staff, the optimal configuration included installing a biomass heating system but avoiding investment in other green technologies, yielding an annualized preference-adjusted cost of $5,814.   Sensitivity analysis indicated that the overall cost is most sensitive to the discount rate, the marginal cost of damages due to carbon emissions, the amount of electricity used at the center, and the price of electricity.  We calculated the Expected Value of Perfect Information and found that the  most valuable information was  on the cost of maintaining a biomass heating system.

Leave a Reply

Your email address will not be published. Required fields are marked *