Data Import

The first step in Life Cycle Design modelling is to gather quantity data from various design documents, including 3D models, drawings, and cost plans. After that, you input all this data into eTool.

Jump to the following sections in this post:

Options to Import data into eTool

Bulk Import using CSV file

Options to Import data into eTool

There are three main methods to build your Life Cycle model, and you can use them on their own or in combination:

Import from Revit:

Using the eTool Revit plug-in to extract all element quantities and link them directly to your preferred eTool project. This method is advantageous as it captures quantities of elements rather than materials. The level of detail in the Revit model is not a concern, as long as the family type names are accurate.

Semi-Automatic Method:

Export quantities as needed from any BIM software to a CSV file, which can then be imported into eTool. This method allows for direct exports from BIM software like Revit or ArchiCAD and supports computational processes using visual programming languages like Dynamo in Revit or Grasshopper in Rhino.

Manual Method:

Manually input quantities from available documentation, including cost plans, BIM models, and drawings.

Please visit the Revit plugin article to learn more about Revit / BIM Integration.

Jump back to contents ↑

Video: Options to import Data into eTool

Jump back to contents ↑

Bulk Import using CSV file

I’d like to demonstrate how you can import data into eTool. Do you typically work with a cost plan, drawings, or a BIM model? We prefer working with cost plans because they facilitate data aggregation, aligning well with eTool templates. When provided with a BIM model, we usually export the schedule and work from there.

Cost plan example

1.Generate CSV File

I will now show you an example of a cost plan related to building. When working with a cost plan, we recommend adding additional columns for eTool input.

Include a column for eTool quantity, matching the quantity units in eTool templates. You may need to calculate the eTool quantity, adjusting for any discrepancies. For example, if the cost plan uses the m2 unit and the template uses volume (m3) for the foundation unit, additional information on the foundation’s dimensions may be required for accurate calculation. If information is not available, it is acceptable to make reasonable assumptions based on references from other projects or your experience, ensuring they are documented for tracking and updates. We recommend users to record assumptions in a dedicated column when conducting an LCA for their own sake. This will also assist the reviewer in case the design is submitted for certification, making the review process smoother. Exclude items in the cost plan that are irrelevant or minor that wouldn’t impact the LCA applying the cut-off criteria is also recommended.

Add another column for eTool templates, and proceed to select an appropriate template by following these steps:

  1. Visit eTool, click the “Add template” button in the design
  2. Search for relevant templates using keywords like “concrete.” If a term doesn’t yield results, try different words, as templates aim for global applicability.
  3. Select a template, ensure its suitability through the description
  4. Copy the title, and paste it in the spreadsheet. 

For deeper template details, add it to the design, click “Edit” to view information, sources, and references. Although most of the references used are based on Australian data, it is highly unlikely that construction methods for major and the most common building materials will vary significantly from country to country. Therefore, the references are mostly still relevant for the location of the project.

In the eTool template quantity column, you may choose to aggregate some items while repeating others. Decide whether to combine or keep them separate for reporting purposes. It’s important to note that the same material allocated to different categories, such as Substructure and Superstructure, should be kept separate to ensure accurate allocation of impacts.

After that, you can create a new sheet to refine the input, basically cleaning up to make sure there is no excess information. Then, export it as a CSV file. In the CSV file, you need to make sure that there are not blank boxes, and Quantity column is recognised as numbers before importing to eTool.

Note: Ensure quantity column is recognised as numbers in the spreadsheet before importing to eTool.

Jump back to contents ↑

2. Import into eTool

Set up your Project, make sure that the function is set up correctly. You can manually add the functions, but if you have let’s say 50 functions and you don’t want to add them manually, you can bulk import the functions as well.

Then, go to the Import tab to import templates and functions. For more details on import functions please refer to Functions: bulk import and reporting support post.

Follow the following steps to import your templates:

Step 1: Upload File

Step 2: Set up

  1. Choose the preferred matching process and let the software automatically apply templates or select matching items manually.
  2. Define functions or Asset ID in the Function tab. If the “Whole Building” option is selected, templates will be matched to functions based on the import file.
  3. Match imported column to eTool fields. Regarding Template Name column, Bulk import feature will automatically append the name that you select here in front of the original name of the template. That can be useful when you use the multiple templates that are the same but they are for different areas. For example, if you use the concrete 30Mpa, 1% of reinforcement for footings and retaining wall, you can define the name in a new template name column and the software will append them in the eTool template name column. That’s how you can identify the different parts of the design in eTool. For the last column, ‘Ignore’ the eTool Template name in this case but it would be handy to have the spreadsheet ready so you can check which eTool template to match.
  4. Click ‘Next’

Step 3: Match

eTool has a learning function that remembers previously selected templates for specific items, saving time during subsequent imports. For any unmatched templates, refer to the spreadsheet, copy the eTool template name, and select the appropriate one. Click “Next”

Step 4: Success

Click ‘Finish’ Your LCA model is now complete.

Jump back to contents ↑

Video: How to Bulk Import using a CSV File


Jump back to contents ↑

Related articles:

Data Collection & Entry

Materials Take-Off: Managing differences between design information and eToolLCD templates

Exporting schedules from Revit

Aggregating Data for Import 

Function: Bulk import and reporting



Leave A Comment?

You must be logged in to post a comment.