Social Impact Calculator
Version 2.0 [October 2020]
When it comes to looking at the holistic impact of an investment on the things we care about- quality of life, equity, the environment- traditional CBAs are woefully inadequate. The Social Impact Calculator is a visual tool that shows investment and return from both the government and public perspectives in a comprehensive way that aligns values and outcomes. The purpose is both to help decision-makers make smart long-term choices and to help communicate the reasoning behind such choices to residents.
Cityfi (2019). "Quantifying Social Costs and Benefits to Guide Individual Action". Medium. https://medium.com/cityfi/quantifying-social-costs-and-benefits-to-guide-individual-action-57966b97ea42
Why use it?
The Social Benefit Calculator:
- Makes the invisible visible - The focus on naming and broadly estimating all significant social costs and benefits keep the decision-making process rooted in reality and attentive to typically overlooked and difficult to measure factors
- Has a flexible, open-source framework that allows staff and community members to make adjustments over time to take new information into account, as well as apply the framework to different policies and investments
- Uses a long-term time horizon (30 years for infrastructure, 10 years for add-on investments) to help guide smart decisions
- Maximizes community engagement and informed discussion through a simple, visual interface
Who is it for?
How long does it take?
While the framework serves as a template, it takes time to fill in the specific impacts and estimated values that relate to your particular project. We recommend using round numbers for estimates in order to convey the large margin of error and communicate most simply to community members. We also recommend embracing subjective forecasts or adjustments to research from people with expertise within your organization. Logic and common sense are often more accurate than using "objective" proxy data. Still, you will need to gather those experts and other key stakeholders to decide on assumptions, talk through the range of impact values (we've used 0-30 to reflect 1 full return for each year of assumed lifespan), and finalize the numbers and visual. Plan for 3-6 months.
How many people is it for?
What materials do you need?
The Social Impact Calculator is built in Tableau and uses Google Sheets as its database. Note that Tableau licenses may be provided to non-profits at no cost.
What does the facilitator need to know or be able to do?
It takes courage to put up numbers that include subjectivity. However, it is necessary if we are to include the meaningful impacts that are difficult to measure, and expert subjectivity is often more trustworthy than statistics taken from objective research (e.g. willingness-to-pay surveys). The facilitator needs to be able to communicate that the visual is meant to be a basis for discussion and evolve over time.
Expertise in Tableau or other data visualization and software is also helpful to make the tool as user friendly in its final form as possible.
Cityfi, Miami-Dade County Department of Public Works
Cityfi. Lawson, Chelsea et al (2019). "Miami-Dade Social Return on Investment Methodology." https://docs.google.com/document/d/1TVAry4f8Trhjb55DylB5kWQsm7a5KcAoUVSNNQ4fI24/edit#heading=h.592rpinq93dg
Policy Application - "The Social Cost of Cheap Corn." https://medium.com/aint-nobody-got-time-for-that/the-social-cost-of-cheap-corn-8c37629a59b5
Investment Application 1 - "Scenario Comparison of Bus Express Rapid Transit in Miami-Dade County." https://public.tableau.com/views/Miami-DadeSocialReturnonInvestment-BRTScenarioComparison/Scenarios-fixedsize2?:language=en&:display_count=y&:origin=viz_share_link
Investment Application 2 - "Comparison of Mobility Hub Investments in Miami-Dade County." https://public.tableau.com/views/Mami-DadeSocialBenefitCalculator-Add-OnsCompared/Revision?:display_count=y&:origin=viz_share_link
Google Sheets Template: https://docs.google.com/spreadsheets/d/18_9n2gWDDtc7rKqlAhIvCutdFcdzy0LlTkWGgQn5exg/edit?usp=sharing