# Custom tool to map energy emissions from buildings and roads for 2020, 2030, 2040 and 2050 using utility energy consumption data!!! PLEASE HELP!!!!

Question asked by hussain.malik on Oct 18, 2020
Latest reply on Oct 21, 2020 by smehta-esristaff

Hello All,
I am working on a project where I have to map Green house gases emissions from all city buildings for the current year and for next 30 years with 10 years gap, i.e: emissions for 2020, 2030, 2040 and 2050. Now I have all the equations and scenarios that I am considering for the future state mapping. I am able to do all these calculation within ArcPro environment, however, I have hit the roadblock at this stage of my project where I want to create a custom tool (either on Model Builder or in python) to carry out these calculations.

• Building data from the city shows all building
• Average energy consumption (electricity and Natural gas) from each house is provided by utilities
• Based on these energy consumption (electricity and Natural gas) values we have to calculate future scenarios. Using following equation

Equations for Emission Calculations:

2020 Gas Emissions: Gas consumption * 0.0561 -- Natural Gas emission factor

2030 Gas Emissions: Gas consumption * (0.0561*0.95)

2040 Gas Emissions: Gas consumption * (0.0561*0.9)

2050 Gas Emissions: Gas consumption * (0.0561*0.8)

2020 Electricity Emissions: (Electricity consumption * 1000)*0.0005 --- Electric emission factor

2030 Electricity Emissions: (Electricity consumption * 1000)*0.00031

2040 Electricity Emissions: (Electricity consumption * 1000)*0.00017

2050 Electricity Emissions: (Electricity consumption * 1000)*0.00009

These calculations provide emissions in tonnesCO2e/year

Our calculations are based on an assumption that emissions will reduce from the transportation and buildings due to improvements in technology.

So, Idea is to create a tool where we have specific variables that would help reduce the emission in the future by some percentage, I have attached an excel table from where I can choose some of the variable for calculations.

I want to start simple at this point and built my model on a specific template where I could add as many variables as needed also If required, I can share test data privately as well.

I am still a beginner in Python and model builder so any help would be highly appreciated.