Executive summary:

First the good news: The new EN 81-20 reporting is on its way into the next DigiPara Liftdesigner Version.

Second the bad news: It still might take some time.

A new Excel reporting functionality will become available together with DigiPara Liftdesigner 2018. These new features are used to implement a much more flexible and adaptable EN 81-20 calculation as today. Most important targets are:

  • Reports are usabale to the notifed body like TUEV
  • Reports and calculations are adapatable by our clients
  • Clients can add their own technical calculations

First results should be

  • Guide rail verification
  • Rope certification

and will be shown together with the new DigiPara Liftdesigner 2018 at Interlift 2017 in Augusburg. Visit us in Hall 7, Booth 7130.

Background:

DigiPara is strongly developing CAD model integrations into DigiPara Liftdesigner. You will be surprised about these new features, that will allow you to show up your Solidworks, Inventor or Creo model within your DigiPara design. As an integral part of this CAD implementation we also implemented a new Excel interface and the related reporting engine.

Excel, Excel, Excel:

Most of you guys out there are real fans of Microsoft Excel. A lot of Excel files at our clients automate their paperwork. Unfortunately, in most cases these Excel files are not connected to the DigiPara Liftdesigner project. As a result users have to type in the same values in DigiPara and into Excel.

One reason might be the lack of functionality, but I assume the main reason is because the Excel interface is a very hidden feature and most clients simply do not know that it exists.

 

 

 

If you want to understand this hidden feature (that is available since years), please click on the image below to download a pdf explanation from our team.

New Excel features coming in DigiPara Liftdesigner 2018

The new coming DigiPara LIftdesigner 2018 adds a lot of Excel functionality. In case your CAD model is driven by an Excel file, you can automatically populate the values of this Excel sheet so that your CAD files get updated when you change a value within DigiPara Liftdesigner.

For reporting you can create an Excel file and refer any value of your DigiPara Liftdesigner project in this Excel file.

The new mapping dialog: You can easily map DigiPara elevator project parameters to your Execl design sheet that drives your CAD model.

 

The new Excel reporting integration

In DigiPara Liftdesigner 2017 and earlier the report generation was a one-time operation. You selected the report and then it was generated. In DigiPara Liftdesigner 2018 the reporting will become part of the calculating loop. That means, when you change a value in DigiPara Liftdesigner the report gets automatically updated. Moreover you can showup the report within a DigiPara screen. Sample: You have implemented a distance check within your Excel sheet that shows up an error message in case a clearance is too small. When you change the related value in DigiPara the Excel file will imediately show up your error or warning.

Transfer Excel values back to DigiPara Liftdesigner

Another great enhancement is the option to transfer values back from Excel into DigiPara Liftdesigner 2018. These might be some simple values, but it will be also possible to automate component selection in your CAD model. In case your Excel file allows you to select a specific guide rail type, you can automatically select this guide rail in your elevator design.

 

Any Excel sheet can be shown up within the DigiPara Liftdesigner screen.
As a sample: a drop-down list can change components in your design.

What all of that mean for EN 81-20?

For the 2018 release it is planned to deliver Excel reports for some typical EN 81-20 calculations (e.g. rope certification and guide rail calculation.) Even we can not 100% promise that is at least the current plan. We will also consider requirements of the EN81-50 standard during these developments.

Customize all reports to your needs

All of this can be customized by yourself or your team. No programming, except some Excel conditions, is required to make great things.

You can create your own Excel files or modify the default EN 81 files that come with your DigiPara Liftdesigner installation. This will allow you to adapt the files in the way you will need for your notified body.

EN 81-20 Software Release Date

The estimated release date for the first version of the new EN 81-20 calculations is expected at 30.3.2018.

Are you already doing parts of your EN 81 calculations with Excel?

We are happy to hearing your opinions in that matter. We are actually looking for typical Excel files from our clients to understand the needs more precise and the way how you like the layout of these reports.

Do you want us to evaluate your Excel Files?

If you are interested, please send us your Excel files. We can evaluate them and tell you what you need to do to get them fully automated filled out. You can be assured that we will not share your files with anybody else.

 

 

 

 

Alex from my team coordinates adaptions of customer Excel files. Please send your Excel Files to her:

Alexandra.Komm@digipara.com