Skip to main content

Step 7 of 7: Practice: Define Your Own Excel File for Project Integration

EL3.7: Create your custom Excel Project Integration

Written by Alexandra Göttert

Use the recommended workflow below to build your own Excel file for project integration after the training.

Prerequisites

  • You've built a drop-down list in Excel that exchanges guide rails via their RID numbers through the Excel Project Integration.

Steps

1.) Define a base project with the Shaft Wizard. Define a project with the most important main characteristics — for example, counterweight position and machine room position, or MRL.

2.) Create a new Excel template. Create a new Excel template via the Excel Reporting docking window.

3.) Save the Excel template file.

4.) Extend the template with further sheets. Add further sheets for a better overview of different input areas — for example, title block data.

5.) Link the necessary references. Link the DigiPara Liftdesigner references you need from the Data tree.

Result

You have your own Excel file for project integration, structured into clear input areas and linked to the project references you need.

Tutorial complete

This was the final step of the EL3 Excel Reports & Automation tutorial. You've created simplified Excel reports with project values, set up an Excel Project Integration, transferred values between Excel and DigiPara Liftdesigner, edited reports in Excel and connected external Excel files, exchanged components via a drop-down list, and defined your own Excel file for project integration.

Did this answer your question?