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:
Instructions for Energy Tool (please send comments to Rose Zdybel (email@example.com)
Papers describing the Tool can be found here:
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.