Export from Construction Data Program

Construction Data Excel Transfer

There are two cases for which file is written. If a file with the name of the target file already exists, it will be overwritten. If the target file does not yet exist, the source file is used and copied.

In this case, "ErgebnisListe" is used as the name of the target file. This list does not yet exist and will therefore be created from the source list.

Project information, measured quantities and material lists can be transferred.

Using the browse button behind the respective settings, we can change the settings. Thereby we determine which information is transferred and into which cell or range it should be written.

• Browse button for "Project information"

• Button "New"

• Browse button at Variable -> select project number

Via the cell reference we control the target cell or target range.

• Browse button cell reference

• Named range -> project number

The range "Project number" has already been defined in the Excel file and can be selected here. The export thus reads these ranges from the source file. Because the range is selected rather than a fixed cell, the range can be moved in Excel without the reference in the Excel export needing to be changed.

• Create project variable with named range

In this case the data type is "Text". This can be decisive if a value is to be further processed in formulas in Excel.

• Check the box at BDP position

Measured quantities

• Create measured quantity for coverage area

In the browser for the measured quantity, the button "New" on the right can be used to select from which variant the information will be transferred. If this is not used, all variants are transferred.

Measured quantities can be aggregated/divided using 3 different variants.

• Building element: Create a separate row for each building element.

• Measured quantity sum: A row is created for each variant. Values contained for the building elements are already summed.

• Total sum: The sum of all selected variants is formed

The cell reference is again chosen here via the named start and end range.

In addition, it is determined which information of the measured quantity is transferred. This populates the cells below and to the right of it.

• "New" and create building element type as well as building element number and measured-quantity value

The order determines the sequence of the columns to the right.

• Create additional measured quantities for formwork area, as well as the lengths of eaves, ridge lines, verge edges, hip lines and valley lines using the same procedure

Material lists

For material lists the entire material list is transferred. The column setting that can be configured for material lists in the construction data program is used. It is therefore advisable to always create material lists with the same identifier. For example H01 for the timber list.

• Select material list BDP

• Setting "Excel Export"

• Confirm setting

The Excel list is created with the "Ok" button.