Skip to Content

 Back to Index

Calculation

Calculation tool is a powerful integrated spreadsheet calculation tool, replacing manual Excel calculations. Calculation tool enables calculations based on project information, and can be used for example to calculate bill of materials, and estimate costs and emissions.

PurposeFunctionalityTips

Functionality

  • New - Create a new calculation. Projects can have multiple calculations. 
    • Name - Name of the calculation
    • Level - Calculation is based on File (Model) or Object level attributes
  • Save - Save current calculation.
  • Export - Export current calculation in Excel format. 
  • Calculation selector - Select an existing calculation from saved calculations
  • Load - Loads a saved calculation
  • Delete - Deleted currently selected calculation

Calculation editor

  • Data - Select content for the first column and query object for each row
    • Folder - Create rows based on Data tree folders
    • Attribute - Create rows based on attribute values
  • Column - Select content for the second or more columns
    • Summary - Calculates summary of selected attribute values for all objects in each row
    • Quantity - Calculates number of objects for all objects in each row
  • Cell rules
    • Cells in spreadsheet can contain all kinds of formulas. Almost all same formulas are supported as in Excel. 
  • Menus and Toolbar
    • Menu and Toolbar contains Excel style tools to format Calculation spreadsheet

Tips

  • Create quick bill of materials calculation by selecting Data: Attribute "Material" + Column: Attribute "Volume". Then add own columns "Unit cost" and "Total cost". Enter material unit costs into "Unit cost" column. Add calculation formula "=B4*C4" and copy that to all rows; this will calculate total material costs. You can enhance this in same way to calculate material CO2 emissions with "Unit CO2" and "Total CO2" columns.