Excel Tool

Notes and operation

Excel Tool

for calculation, configuration, quotation and ordering

 Current version: 2023.1 and 2023.2 (as of December 2023)

Partner companies receive the Excel Tool (.xlsm file) and, on request, the current price list as a PDF and in printed form. 

Please contact:

Dirk Hentschel
dirk.hentschel@eret-tortechnik.de or
Tel.: +49 (0)7176 4549 396

 

Enable macros!

To use all functions, you must confirm that you wish to ‘enable macros’ each time you open the file.

Important: Follow the sequence!

Please configure first, then view the calculation, enter the discount and markup, and then view the quotation (texts).

  1. Order/configuration = assemble the door specification
  2. View calculation, enter a discount if applicable, enter a markup
  3. Generate quotation or text

You can ONLY enter data on the Order/Configuration sheet. NOT in the costing sheet. (Except in blue or yellow fields)

NEW: Reset

To start a ‘new’ configuration, you can delete all the data entered. You therefore start completely from scratch, with no remnants of a previous configuration left in the file.

Note: You may want to save the existing configuration first using "Save as ...".

 

Selection fields / free-text fields

You can enter the required information as free text in fields highlighted in YELLOW. In fields highlighted in BLUE, please select the relevant value (do not enter anything yourself!!)

Configure the door there (Step1)

The selection fields allow the form to adapt to your entries and the available configuration options. You can only select compatible options. This prevents ordering/configuration errors. 

Calculation

AFTER you have completed the configuration, you can enter your dealer discount and desired markup in the costing sheet. 

 

NEW: Quotation

With one CLICK on the ERET logo, you receive the text matching your configuration, including prices and discount

Alongside the quotation text, you will also find various notes on points to consider for individual items.

Order

ONLY the Order sheet/configuration, please send if required
as PDF to email:   bestellung@2024.eret-tortechnik.de

Below are a few brief instructions on how to create a PDF under:
- Windows
-Mac OS

The costing sheet is intended solely for your information and as a working aid.

 

Order -> Generate PDF (Windows)

ONLY the Order sheet/configuration, please send if required
as PDF to email:   bestellung@2024.eret-tortechnik.de

1. Click ‘File’

 

2. Click ‘Export

3. Click ‘Create PDF/XPS Document’

 

4. Enter the desired file name under which you want to save the technical clarification/order.

5. Click ‘Publish’ to save the file (PDF). 

6. Drag this PDF into an email and send it to: bestellung@2024.eret-tortechnik.de 

 

Order -> Generate PDF (Mac OS)

ONLY the Order sheet/configuration, please send if required
as PDF to email:   bestellung@2024.eret-tortechnik.de

1. Click ‘Print’

 

2. Click on "PDF"

 

3. Click ‘Save as PDF’

 

4. Enter the file name under which you wish to save the PDF

5. Click Save.

The file is now saved in the folder shown below the file name.
Usually this is the Desktop

Then drag this PDF into a new email and send it to: bestellung@2024.eret-tortechnik.de