Cubit Estimating allows you to export estimating data in a specialised format to facilitate lifecycle assessments, enabling embodied carbon calculations and comprehensive environmental analyses for your projects. Follow these steps to prepare your estimate and export it for use in One Click LCA:
Preparing Your Estimate
1. Import the Group Codes
-
- Import the attached One Click LCA Group Codes into Cubit Estimating as a Rate Code. This file is structured based on the supported Classes specified by One Click LCA.
- You may recode the list as long as the code Descriptions remain unchanged.
- If the code Descriptions do not align with One Click LCA’s Classes during the import process, manually update them as needed. (Note: One Click LCA may periodically update their supported Classes.)
Download One Click LCA Group Codes here
2. Apply One Click LCA Group Codes
-
- Open a job in Cubit Estimating and apply the One Click LCA Group Codes to your Estimate View.
3. Create a Grouped View
-
- Use the applied One Click LCA Group Codes to create a Grouped View of your estimate.
- Note - If you create a Grouped Job instead of a Grouped View within a job:
-
-
-
- You'll need to manually remove the Group Code number appended to each Code Description to enable automatic matching during the import process into One Click LCA.
-
-
-
-
- Alternatively, you can manually map the Code Descriptions to their respective Classes during the import steps into One Click LCA.
-
Exporting Your Estimate
4. Select the Source View
-
- Navigate to the Data tab and select the One Click LCA Grouped View you created from the Source section.
5. Export to One Click LCA
-
- Click Export > One Click LCA and select either Export All for all Trades or Export Selected for selected Trades to generate the export file.
- The exported Excel file will include the following information:
- Class: The trade (group code) description.
- Material: The item description.
- Quantity: The aggregated quantity for the item.
- Unit: The unit for the item.
- Comment: A representation of your items’ heading structure. (Hierarchy is not allowed in One Click LCA Excel import, so this information is included in the Comment column for reference.)
Final Steps
6. Import the Exported File
-
- Upload the Excel file to One Click LCA to perform further analysis. For detailed instructions, refer to the guidance article provided by One Click LCA.
By following these steps, you’ll ensure that your estimate is structured and exported correctly for use in One Click LCA, enabling efficient and accurate environmental assessments.
Comments
Please sign in to leave a comment.