Import from Excel file
Importing is a core process of One Click LCA. It is built on a patent-pending technology for transforming models to life-cycle impact assessments. This page concerns the use of the One Click LCA® in connection with Microsoft Excel.
Make sure you have the things listed below before starting:
- One Click LCA user account
- An existing project linked to the user account with a valid One Click LCA license
- An Excel file that contains information about building materials – material names and their quantities.
How to set up Excel import?
Where can I download it?
On the bottom of this page we have added four different excel templates which you can use for excel imports.
See the below table to see which excel form you should use.
Excel form name | Intended Project Use |
OCL_import_form_Building_Metric_v1_3.xlsx | Building Projects (EU/UK/RoW) |
OCL_import_form_Building_Imperial_v1_1.xlsx | Building Projects (US) |
OCL_import_form_Infrastructure_Metric_v1_3.xlsx | Infrastructure Projects (EU/UK/RoW) |
OCL_import_form_Ecoinvent_EPD_Metric_v1.xlsx | Product Projects (Ecoinvent EPD) |
OCL_import_form_Constructions_data_Metric_v1.xlsx | Construction uploads |
How do I install it?
You only need to have Excel installed.
How to use Excel Import?
Step 1: Adding correct data heading labels when not using excel template
If the model is taken directly from the Building Information model using One Click LCA import it is automatically in the correct form. If you use some other source for Excel you will probably need to add correct data heading labels, units, and classification for the data.
If you are using one of the excel templates then you simply fill in the excel with available the building materials quantity takeoff.
Step 1A: Check the Excel formatting requirements
Please find the data templates in the attachments (can be found at the bottom of the page). Below are provided explanations for different classes and guidance on how to fill in the data.
CLASS: The class defines to which question in the query we map, the values have to be one of the listed ones in exactly the same format. Please find the list of accepted CLASS values and information on which question each of them is mapped to.
CLASS | Building element | Sub-Element |
FOUNDATION | Foundations and substructure | Foundation, sub-surface, basement and retaining walls |
WALL | Vertical structures and facade | External walls and facade |
EXTERNAL WALL | Vertical structures and facade | External walls and facade |
INTERNAL WALL | Vertical structures and facade | Internal walls and non-bearing structures |
COLUMN | Vertical structures and facade | Columns and load-bearing vertical structures |
SLAB | Horizontal structures: beams, floors and roofs | Floor slabs, ceilings, roofing decks, beams and roof |
ROOF | Horizontal structures: beams, floors and roofs | Floor slabs, ceilings, roofing decks, beams and roof |
BEAM | Horizontal structures: beams, floors and roofs | Floor slabs, ceilings, roofing decks, beams and roof |
STAIRS | Other structures and materials | Other structures and materials |
OTHER | Other structures and materials | Other structures and materials |
DOOR | Other structures and materials | Windows and doors |
WINDOW | Other structures and materials | Windows and doors |
HORIZONTAL FINISH | Horizontal structures: beams, floors and roofs | Floor slabs, ceilings, roofing decks, beams and roof |
VERTICAL FINISH | Vertical structures and facade | Internal walls and non-bearing structures |
FINISH | Other structures and materials | Finishings and coverings |
COVERINGS | Other structures and materials | Finishings and coverings |
SYSTEM | Building technology | Building systems and installations |
BUILDINGTECH | Building technology | Building systems and installations |
FURNITURE | Building technology | Building systems and installations |
SITE | External areas and site elements | Materials and constructions for external areas |
IFCMATERIAL: The distinguishable material name that we use to map the material to the label in the tool. Mapping is based on CLASS & IFCMATERIAL combination. Many generic labels such as Concrete 40/50 are automatically mapped. For other materials choose a material label that you wish to use for that material. When you import it for the first time, you can teach it to the tool and it will be automatically recognized in the future.
QUANTITY: Number, use comma as decimal separator.
QTY_TYPE: Unit, accepted values are M3, KG, and M2. Please note that if you are using M2 you’ll also need to give THICKNESS in mm unit.
TRANSPORT_KM: Transport distance in km from manufacturer site to the building site (optional, can also be added later in the query).
Name: This field can contain any additional information you wish to take to the comment field in the tool. Please, note that if you combine several rows in the import process the comment is not shown in the query.
You can add any additional information you want to use to the excel template. This can be added by adding new columns. Please prioritize using existing unused columns (just change the column name) as there is a maximum amount of columns that can be present in the excel. In the additional settings during the import process, you will be able to change the grouping and combining based on any additionally exported columns. Any additionally provided information you will be able to see in the building material query as well by clicking the paper icon.
Step 2: Upload the filled-in Excel sheet.
When all the listed are available, you can simply open your project design where you wish to import the data and click 'Input data' and 'Import Excel or gbXML files'.
Watch our tutorial video of the tool basic functionalities and test the web interface so that you’ll know how it works before starting the import.
You can also download the Excel from your existing BIM or IFC model and then add additional rows for it or make corrections. For instance, if some of the material specifications in the model are not distinguishable enough such as Wall 1, you can split those into several rows to represent the actual building materials in it.
Attachments
Related Articles
Import from gbXML file
Importing is a core process of One Click LCA. It is built on a patent-pending technology for transforming models to life-cycle impact assessments. This page concerns the use of the One Click LCA® in connection with gbXML files. Make sure you have ...Import process in One Click LCA
Make sure you have the things listed below before starting: One Click LCA user account An existing project linked to the user account with a valid One Click LCA license that enables automated import (Starter plus or higher) Red through the guide and ...Model Checker, ensuring data quality
What does this feature do? One Click LCA automatically checks your inputs for plausibility and too generic definitions. The checking results will be shown on the mapping page. If you wish to see the exact rows that the warnings concern download the ...Solibri integration (BETA)
Importing is a core process of One Click LCA. It is built on a patent-pending technology for transforming models to life-cycle impact assessments. This page concerns the use of the One Click LCA® in connection with Solibri Model Checker. This is a ...IDA ICE integration (BETA)
Importing is a core process of One Click LCA. It is built on a patent-pending technology for transforming models to life-cycle impact assessments. This page concerns the use of the One Click LCA® in connection with IDA Indoor Climate and Energy ...