12.11 0 provides a new way of exporting data to Excel. The new exporter allows you to export data to separate Excel sheets and upload a multi sheet Excel and use it as a template. This opens the possibility to create more complex reports like COBie and Seps.
...
- Go to Reports and exports->Excel project exports and select "Create excel export" in the lower right side of the window
- (For administration users) Select Home->Settings→ Project and Database Administration->Configure excel export
...
All exports created in the Configure excel exports will also be available under 'Project Excel project exports" in Reports and exports.
If an excel export has a template file and one or more of the columns in the template file has a formula, no data is written into those columns
The data in A2 and B2 is summarized into C2 as the formula specifies