CO2 Footprints

The bot traces the carbon footprint of people in day-to-day life.

Comment

Inspiration

Suggestion by the slack bot based on the CO2 emission behaviour. And, To create a leaderboard in an organization which displays top people who are responsible for less CO2 emission. This project is to make people in an organization know about the CO2 emission behind every action for a regular period of time.

What it does

This helps to find the CO2 emission caused by people in day-to-day life.

How we built it

We basically created a bot in slack. This collects information from users such as the number of people in the family, commuting distance to the office, means of transportation and other food and lifestyle habits. The data collected from slack is stored in a database and updated to the Tableau worksheet dynamically. An informative dashboard is created using Tableau to represent leaderboards and high CO2 emissions based on different categories. The people who top the leaderboard are people who are responsible for less CO2 emission. Based on the data, organizations can decide to reward employees to motivate them towards less CO2 emission. Created a quick tip cmd "/quicktips" which gives info about CO2 emissions in Slack bot.

Challenges we ran into

Creating reports in salesforce. Creating Einstein bots and collecting data from them. Since this is the first time we are using the salesforce tools, it took a long time to go through the documentation and make our hands dirty in it. Integrating DB from slack with Tableau.

Accomplishments that we're proud of

We could utilize existing APIs and create good bots in slack. We came up with an informative dashboard.

What we learned

A lot about salesforce tools and slack bots. How to calculate our CO2 Footprints and what factors affect the most.

What's next for CO2 Footprints

Implement as a plugin wherever it is possible.

Some references:

https://shrinkthatfootprint.com/calculate-your-carbon-footprint/ https://justenergy.com/blog/how-to-calculate-your-carbon-footprint/ https://www.climatiq.io/ http://protea.earth/

Code Readme

bot.py contains code for the slack bot carbon_footprint.py calculates and stores data locally which is used in tableau dump.py uses carbon_footprint.py to generate data dump for tableau

The conclusion and actions are predicted by the comparison calculated Co2 footprint with the population's average Co2 footprint. The population average Co2 footprint has been taken from various platforms with an assumption of being true although we did find a platform https://www.climatiq.io/ which can be used to calculate accurate Co2 emission

Built With

Share this project:

Updates