Open Data, Pandas, DataFrame and ChatGPT
24 February 2024
Process Automation and ETL
24 February 2024

CO2 estimation and calculation

Along with the topic of sustainability of building projects at the 6D stage, modern construction emphasizes the environmental sustainability of projects. One of the key aspects of which is the assessment and minimization of CO2 carbon emissions that occur at all stages of the building life cycle.

Estimating and calculating carbon emissions of construction projects is a process in which total carbon emissions are determined by multiplying the volume attribute of the entities or group of entity-elements used in the project by a suitable carbon emission factor for the category.

Incorporating carbon emissions into the evaluation of construction projects as a component of the broader Environmental, Social, and Governance (ESG) criteria introduces an additional layer to the comprehensive assessment of the project.

Environmental, Social and Governance (ESG) are a broad set of principles that can be used to assess the corporate governance, social and environmental impact of a business, both internally and externally.

ESG, initially developed in the early 2000s by financial funds to provide investors with insights into the broad environmental, social, and governance criteria, has evolved to become a key metric for evaluating both companies and projects.

 

To determine emissions by type or category of element we need to collect the CO2 emission factors resulting from the production of different building materials such as concrete, bricks, recycled steel and aluminum.

The following table uses data from the UK ICE 2015 and US EPA 2006 databases. For each material in this table, two emission attributes (in kilograms of CO2 per kilogram of product) and volume-to-weight conversion factors (in kilograms per cubic meter) are provided.

In order to calculate the total CO2 emissions of a project, it is necessary to define the attribute volume of each entity group. This can be done using the Quantity Take-Off (QTO) tools by obtaining attribute volumes in cubic meters, as detailed in the section "QTO Quantity Take-Off: Data Matching and Grouping". These volumes are then multiplied by the attribute “CO2 process emissions” factors for each material group.

Let's extract from the CAD (BIM) project automatically a table of volumes by element type by grouping all the data from the project, as we did in the previous chapters. Let's ask ChatGPT to do this.

 

❏ Text request to ChatGPT:

Please group the DataFrame table from CAD (BIM) of the project by the "Type Name" column parameter and show the number of items of each group and also summarize the "Volume" parameter for all items in the type. ⏎

➤ ChatGPT Answer:

To automate the process of calculating the total emissions for the entire project, we only need to set up automatic mapping in the same table or specify manually the correspondence between element types and material types from the emission factor table.

A ready-made table with coefficients and formulas, as well as ready-made code for getting volumes from CAD (BIM) formats and automating CO2 calculations, can be found on GitHub by searching for "CO2_calculating-the-embodied-carbon".

Thus, the use of QTO and CAD (BIM) data to estimate carbon emissions in construction allows to automatically calculate the corresponding carbon dioxide emissions for different project variants with different materials, automatically selecting only those variants that meet the client's CO2 emission requirements.

Estimation of CO2 emissions by multiplying coefficients by volumes of grouped project elements is a typical example of a task in the processes of a construction company.

Similarly, by defining element group volumes, we can perform calculations for material control and logistics, quality monitoring and management, energy modelling and analysis, and a host of other tasks.

 

If the number of such calculation processes in a company starts to grow, the question arises as to whether it is necessary to build automation or use a specialized complex data management system (or data tables) to manage the rule tables and the projects themselves.

Medium to large companies in the construction industry, outsource such automation to ERP system development companies. Such companies use a single comprehensive system, known as a construction ERP (enterprise resource planning) system, to manage many different information layers, including material and resource calculations.

Discover Ad-Free applications

with support for the latest CAD (BIM) formats

Don't miss the new solutions

 

 

Linux

macOS

Looking for the Linux or MAC version? Send us a quick message using the button below, and we’ll guide you through the process!


📥 Download OnePager

Welcome to DataDrivenConstruction—where data meets innovation in the construction industry. Our One-Pager offers a concise overview of how our data-driven solutions can transform your projects, enhance efficiency, and drive sustainable growth. 

🚀 Welcome to the future of data in construction!

You're taking your first step into the world of open data, working with normalized, structured data—the foundation of data analytics and modern automation tools.

By downloading, you agree to the DataDrivenConstruction terms of use 

Stay ahead with the latest updates on converters, tools, AI, LLM
and data analytics in construction — Subscribe now!

🚀 Welcome to the future of data in construction!

You're taking your first step into the world of open data, working with normalized, structured data—the foundation of data analytics and modern automation tools.

By downloading, you agree to the DataDrivenConstruction terms of use 

Stay ahead with the latest updates on converters, tools, AI, LLM
and data analytics in construction — Subscribe now!

🚀 Welcome to the future of data in construction!

You're taking your first step into the world of open data, working with normalized, structured data—the foundation of data analytics and modern automation tools.

By downloading, you agree to the DataDrivenConstruction terms of use 

Stay ahead with the latest updates on converters, tools, AI, LLM
and data analytics in construction — Subscribe now!

🚀 Welcome to the future of data in construction!

You're taking your first step into the world of open data, working with normalized, structured data—the foundation of data analytics and modern automation tools.

By downloading, you agree to the DataDrivenConstruction terms of use 

Stay ahead with the latest updates on converters, tools, AI, LLM
and data analytics in construction — Subscribe now!

🚀 Welcome to the future of data in construction!

You're taking your first step into the world of open data, working with normalized, structured data—the foundation of data analytics and modern automation tools.

By downloading, you agree to the DDC terms of use 

🚀 Welcome to the future of data in construction!

You're taking your first step into the world of open data, working with normalized, structured data—the foundation of data analytics and modern automation tools.

By downloading, you agree to the DataDrivenConstruction terms of use 

Stay ahead with the latest updates on converters, tools, AI, LLM
and data analytics in construction — Subscribe now!

DataDrivenConstruction offers workshops tested and practiced on global leaders in the construction industry to help your team navigate and leverage the power of data and artificial intelligence in your company's decision making.

Reserve your spot now to rethink your
approach to decision making!

Please enable JavaScript in your browser to complete this form.

 

🚀 Welcome to the future of data in construction!

By downloading, you agree to the DataDrivenConstruction terms of use 

Stay ahead with the latest updates on converters, tools, AI, LLM
and data analytics in construction — Subscribe now!

Have a question or need more information? Reach out to us directly!
Schedule a time to discuss your needs with our team.
Tailored sessions to help your team grow — let's plan together!
Have you attended one of our workshops, read our book, or used our solutions? Share your thoughts with us!
Please enable JavaScript in your browser to complete this form.
Name
Data Maturity Diagnostics

🧰 Data-Driven Readiness Check

This short assessment will help you identify your company's data management pain points and offer solutions to improve project efficiency. It takes only 1–2 minutes to complete and you will receive personalized recommendations tailored to your needs.

🚀 Goals and Pain Points

What are your biggest obstacles today — and your goals for the next 6 months? We’ll use your answers to build a personalized roadmap.

Build your automation pipeline

 Understand and organize your data

Automate your key process

Define a digital strategy

Move from CAD (BIM) to databases and analytics

Combine BIM, ERP and Excel

Convince leadership to invest in data

📘  What to Read in Data-Driven Construction Guidebook

Chapters 1.2, 4.1–4.3 – Technologies, Data Conversion, Structuring, Modeling:

  • Centralized vs fragmented data

  • Principles of data structure

  • Roles of Excel, DWH, and databases

Chapters 5.2, 7.2 – QTO Automation, ETL with Python:

  • Data filtering and grouping

  • Automating QTO and quantity takeoff

  • Python scripts and ETL logic

Chapter 10.2 – Roadmap for Digital Transformation:

  • Strategic stages of digital change

  • Organizational setup

  • Prioritization and execution paths

Chapters 4.1, 8.1–8.2 – From CAD (BIM) to Storage & Analytics:

  • Translating Revit/IFC to structured tables

  • BIM as a database

  • Building analytical backends

Chapters 7.3, 10.2 – Building ETL Pipelines + Strategic Integration:

  • Combining Excel, BIM, ERP

  • Automating flows between tools

  • Connecting scattered data sources

Chapters 7.3, 7.4 – ETL Pipelines and Orchestration (Airflow, n8n):

  • Building pipelines

  • Scheduling jobs

  • Using tools like Airflow or n8n to control the flow 

Chapters 2.1, 10.1 – Fragmentation, ROI, Survival Strategy:

  • Hidden costs of bad data

  • Risk of inaction

  • ROI of data initiatives

  • Convincing stakeholders

Download the DDC Guidebook for Free

 

 

🎯 DDC Workshop That Solves Your Puzzle

Module 1 – Data Automation and Workflows in Construction:
  • Overview of data sources
  • Excel vs systems
  • Typical data flows in construction
  • Foundational data logic

Module 3 – Automated Data Processing Workflow:
  • Setting up ETL workflows
  • CAD/BIM extraction
  • Automation in Excel/PDF reporting

Module 8 – Converting Unstructured CAD into Structured Formats 
  • From IFC/Revit to tables
  • Geometric vs semantic data
  • Tools for parsing and transforming CAD models

Module 13 – Key Stages of Transformation 
  • Transformation roadmap
  • Change management
  • Roles and responsibilities
  • KPIs and success metrics

Module 8 – Integrating Diverse Data Systems and Formats
  • Excel, ERP, BIM integration
  • Data connection and file exchange
  • Structuring hybrid pipelines

Module 7 – Automating Data Quality Assurance Processes 
  • Rules and checks
  • Dashboards
  • Report validation
  • Automated exception handling

Module 10 – Challenges of Digitalization in the Industry 
  • How to justify investment in data
  • Stakeholder concerns
  • ROI examples
  • Failure risks

💬 Individual Consultation – What We'll Discuss

Audit of your data landscape 

We'll review how data is stored and shared in your company and identify key improvement areas.

Select a process for automation 

We'll pick one process in your company that can be automated and outline a step-by-step plan.

Strategic roadmap planning 

Together we’ll map your digital transformation priorities and build a realistic roadmap.

CAD (BIM) - IFC/Revit model review 

We'll review your Revit/IFC/DWG data and show how to convert it into clean, structured datasets.

Mapping integrations across tools 

We’ll identify your main data sources and define how they could be connected into one workflow.

Plan a pilot pipeline (PoC) 

We'll plan a pilot pipeline: where to start, what tools to use, and what benefits to expect.

ROI and stakeholder alignment 

📬 Get Your Personalized Report and Next Steps

You’ve just taken the first step toward clarity. But here’s the uncomfortable truth: 🚨 Most companies lose time and money every week because they don't know what their data is hiding. Missed deadlines, incorrect reports, disconnected teams — all symptoms of a silent data chaos that gets worse the longer it's ignored.

Please enter your contact details so we can send you your customized recommendations and next-step options tailored to your goals.

💡 What you’ll get next:

  • A tailored action plan based on your answers

  • A list of tools and strategies to fix what’s slowing you down

  • An invite to a free 1:1 session to discuss your case

  • And if you choose: a prototype (PoC) to show how your process could be automated — fast.

CO2 estimation and calculation
This website uses cookies to improve your experience. By using this website you agree to our Data Protection Policy.
Read more
×