This page is machine-translated from Danish.

Tool for quantity entry

Excel Lite

Excel Lite makes it quick to enter quantities and select building elements and constructions, which can then be transferred into LCAbyg.

What is Excel Lite?

The tool contains generic building elements and constructions from GenDK, LCAbyg's library. You can freely select elements and enter quantities directly in the Excel sheet. It's intended for the early design phases, where you work with generic data rather than product-specific information.

The sheet also works as a "circulation document" — it can be sent to stakeholders who don't use LCAbyg themselves, so they can enter quantities for specific constructions.

How to use it

Export

Use the export button on the front sheet to export the Excel Lite file correctly to CSV format.

Import into LCAbyg

Import the exported CSV file into LCAbyg 5 via FileCreate new project from CSV.

Macros must be enabled

To export to CSV, Excel macros must be enabled. If macros are turned off:

  1. Open the File tab
  2. Choose Options
  3. Go to Trust Center
  4. Click "Trust Center Settings"
  5. Go to the Macro Settings tab
  6. Select either "Disable VBA macros with notification" or "Enable all macros"

Resources

The tool is under continued development — feel free to send feedback tolcabyg@build.aau.dk.