Differences

This shows you the differences between two versions of the page.

--- en:infra-convert:user:exceltemp [2019/06/14 16:07]
me
+++ en:infra-convert:user:exceltemp [2023/11/17 13:54] (current)
me
@@ Line 3: / Line 3: @@
 <WRAP noprint>
-> User manual #@IC_HTML@# > More
+> User Manual #@IC_HTML@# > More
 </WRAP>
@@ Line 11: / Line 11: @@
 ----
-#@IC_HTML@# allows you to export the contents of a test plan directly into a Microsoft Excel workbook. All you need is an excel template file (.XLT) formatted as described below and Microsoft Excel on the computer on which the export is performed. Using the template, #@IC_HTML@# creates an Excel file (.XLSX, more file formats coming soon) with the test plan parameters you specify.
+With #@IC_HTML@# you can export inspection plan contents directly to a Microsoft Excel workbook.
-{{ :en:infra-convert:user:interface:excel-export_workflow.png?direct&300 |}}
+You can use the supplied Excel test report templates directly or modify them as you wish. However, you can also create your own templates just as easily. In doing so, you can use Excel files that already exist in the company. This page describes how you can create and customize Excel templates.
+{{ :en:infra-convert:user:interface:elias_excel_report.png?nolink&850 |}}
 \\
+<WRAP noprint>
 <WRAP group>
-<WRAP column 40%>
+<WRAP column 41%>
+//**__Content__**//
-The supplied test report templates are installed by default in the location opposite.
+ • [[en:infra-convert:user:exceltemp#Fundamentals]]\\
+ • [[en:infra-convert:user:exceltemp#Structure]]\\
+ • [[en:infra-convert:user:exceltemp#Export variables]]\\
+ • [[en:infra-convert:user:exceltemp#Standard templates]]
+\\
+</WRAP>
+</WRAP>
 </WRAP>
-<WRAP column 55%>
+==== Fundamentals ====
+<WRAP group>
+<WRAP column half>
+If the export of an inspection plan (more precisely: an inspection plan version) to Excel is triggered in #@IC_HTML@#, the available Excel templates are suggested for selection. Based on the selected template, an Excel work file is then created, filled with the inspection characteristics and saved in the specified directory.\\
+ **See** Functions > Export > [[en:infra-convert:user:functions:cplanexport#arbeitsablaufpruefplanversion_exportieren|Export inspection plan]] > Schritt 2d.
+</WRAP>
+<WRAP column half>
+{{ :en:infra-convert:user:interface:excel-export_workflow.png?nolink&300 |}}
+</WRAP>
+</WRAP>
+**The file formats**
+<WRAP group>
+<WRAP column half>
+The Excel template file can have one of the following formats:
+</WRAP>
+<WRAP column 35%>
+  * {{ :en:infra-convert:user:interface:excelvorlage.png?nolink&0x50|}}XLTX (without macros, *.xltx)
+  * XLTM (with macros, *.xltm)
+</WRAP>
+</WRAP>
+<WRAP group>
+<WRAP column half>
+The following formats can be exported:
+</WRAP>
+<WRAP column 35%>
+  * {{ :en:infra-convert:user:interface:excel_arbeitsmappe.png?nolink&0x50|}}XLSX (without macros, *.xlsx)
+  * XLSM (with macros, *.xlsm)
+  * XLS (*.xls)
+</WRAP>
+</WRAP>
+\\
+**Requirements**
+Microsoft Excel should be installed on the computer on which the export is performed in order to use all Excel functions. If Microsoft Excel is not installed, this must be specified in the settings by removing the corresponding setting.\\
+ **See** Settings > Settings > Export > [[en:infra-convert:user:config:export#excel_test_plan_group|„Excel test plan“ group]]
+\\
+**The template directory**
+<WRAP group>
+<WRAP column 65%>
+The following directory is used to store the test report templates supplied with #@IC_HTML@# during installation.
+<WRAP group>
+<WRAP column 80%>
 <code>
@@ Line 32: / Line 108: @@
 </WRAP>
-Excel templates can be set up and formatted according to your wishes. You can customize the templates provided or create new templates. Place the templates in the folder named //ExcelReports// above. When exporting test plans, these templates are available, see Functions > Export > [[en:infra-convert:user:functions:cplanexport#arbeitsablauf|Export test plan]] > Step 2d.
+</WRAP>
+<WRAP column 30%>
-> **Important** Only one worksheet of #@IC_HTML@# can be filled. The position of the sheet in the workbook is irrelevant, but it must be active respectively visible when the template file is saved.
+{{ :en:infra-convert:user:interface:excel_vorlagenverzeichnis.png?nolink&0x100 |}}
-#@IC_HTML@# writes the inspection characteristics line by line, this means among themselves. Name the first cell in the column to be filled with a value with one of the variables from the table below. How to define names in Excel is described in Microsoft Office Help here: [[https://support.office.com/en-us/article/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64|Defining and Using Names in Formulas]].
+</WRAP>
+</WRAP>
-> **Important** Each name can only be assigned once.
+Excel template files located in the set template directory - by default this is the directory mentioned above - are suggested for selection during the export process. The template directory can be changed in the "Settings" menu.\\
+ **See** Settings > Settings > Export > [[en:infra-convert:user:config:export#excel_test_plan_group|„Excel test plan“ group]]\\
-{{ :en:infra-convert:user:interface:excel-pruefbericht_erstellen.png?direct&800 |}}
+\\
+==== Structure ====
+**The import sheet**
+<WRAP group>
+<WRAP column 65%>
+Exactly one worksheet in the workbook can be described during the export process. It does not matter where the sheet is located in the workbook, but it must be active when the template file is saved. In addition, the editing protection for this sheet or the editing protection for the workbook must not be activated.
+References allow you to use the cell contents on other sheets.
+> **Tip** If you open an Excel template file by double-clicking it from File Explorer, Excel automatically creates a workbook based on the template, for example an XLSX from an XLTX file. Open the template file from Excel, edit the template as such. This way you can save it directly without having to change the file format again.
+</WRAP>
+<WRAP column 30%>
+> **Important** The import sheet must be visible when saving. The sheet protection must not be activated.
+{{ :en:infra-convert:user:interface:excel_datenblatt_im_vordergrund.png?nolink&0x100 |}}
+</WRAP>
+</WRAP>
 \\
-Various variables are available to describe the inspection characteristics with their properties.
+**Define names**
+#@IC_HTML@# writes the test characteristic properties line by line, i.e. one below the other. Another direction is not possible. Name the first cell in the column which should be filled with values with an export variable from the [[#Export variables|following]] Table. Each name can be assigned only once.
+Project and test plan attributes (available from program version 2.10.0) are written into one cell.
+{{ :en:infra-convert:user:interface:excel-pruefbericht_erstellen_neu2.png?nolink&850 |}}
+How to define names in Excel is described in Microsoft's Office Help at this point: [[https://support.microsoft.com/en-us/office/define-and-use-names-in-formulas-4d0f13ac-53b7-422e-afd2-abd7ff379c64?ui=en-US&rs=en-US&ad=US|Defining and using names in formulas]].
+\\
+**Formatting**
+<WRAP group>
+<WRAP column half>
+Particularly suitable for displaying graphic symbols, such as the diameter sign, is the **Segoe UI Symbol** font.
+</WRAP>
+<WRAP column half>
+{{ :en:infra-convert:user:interface:excel-schriftarten.png?nolink&400 |}}
+\\
+</WRAP>
+</WRAP>
+\\
+==== Export variables ====
+**Project data**
+Project data apply to the entire project. They are set in the project edit dialog. The following export variables are available for each test plan export.
+\\   **See** Functions > Project > [[en:infra-convert:user:functions:newproject|Create new project]]
+> **Note** Available from program version 2.10.0.
 |< 100% 20% 40% 40% >|
-^  Name  ^  Description  ^  Reference  ^
+^  Name (A→Z)  ^  Description  ^  Reference  ^
-^ StampText | Stamp inscription | More > Terms > [[en:infra-convert:user:terms#stamp_stamps|Stamp/stamps]] |
+^ ProjectTitle | Project title | Funktionen > Projekt > Functions > Project > [[en:infra-convert:user:functions:newproject|Create new project]] |
-^ CharacteristicId | Unique GUID for the feature\\ (Available as of program version 1.3.4.1) |  |
+^ ProjectDescription | Project description | ::: |
-^ Requirement | Complete requirement, individually formattable for each feature class. | Administrator's Manual > Configuration and Import > Parameter file "CharacteristicClasses" > [[en:infra-convert:dev:characteristicclasses#Formatting the export variable "Requirement"|Formatting the export variable "Requirement"]] |
-^ Value | Value\\ (Available as of program version 1.3.4.1) | User interface > Function window > [[en:infra-convert:user:interface:feature|Characteristic properties]] |
+\\
-^ NominalValue | Value of the nominal value* | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] |
-^ UpperTolerance | Upper Tolerance* | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] |
+**Test plan data**
-^ LowerTolerance | Lower Tolerance* | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] |
-^ UpperLimit | Upper limit value/maximum value, calculated from the nominal value and lower tolerance / upper deviation limit when exporting*\\ (Available as of program version 1.3.4.1) |  |
+Test plan data are set in the Edit test plan version dialog. The following export variables are available for each test plan export.
-^ LowerLimit | Lower limit value/minimum value, calculated from the nominal value and upper tolerance / lower deviation limit when exporting*\\ (Available as of program version 1.3.4.1) |  |
+\\   **See** Functions > Test plans > [[de:infra-convert:user:functions:qcpedit|Edit test plan]]
-^ CharacteristicType | Characteristic type (variabele, attributive) | More > Terms > [[en:infra-convert:user:terms#en:infra-convert:user:terms#characteristic_test-_quality|Characteristic (test-, quality-)]] |
-^ CharacteristicTypeId | Characteristic type ID (1 = Variabele; 0 = Attributive)\\ (Available as of program version 1.3.4.1) | More > Terms > [[http://wiki.elias-gmbh.de/doku.php?id=en:infra-convert:user:terms#class_characteristic|Class (characteristic-)]] |
+> **Note** Available from program version 2.10.0.
-^ Class | Characteristic class | More > Terms > [[en:infra-convert:user:terms#en:infra-convert:user:terms#class_characteristic|Class (characteristic-)]] |
-^ CharacteristicClassId | ID ("ELIAS-ID") der Merkmalklasse\\ (Available as of program version 1.3.4.1) | More > Terms > [[http://wiki.elias-gmbh.de/doku.php?id=en:infra-convert:user:terms#class_characteristic|Class (characteristic-)]] |
+|< 100% 20% 40% 40% >|
-^ Fit | Tolerance class (specifiction of fits) | More > Terms > [[en:infra-convert:user:terms#tolerance_table|Tolerance table]] |
+^  Name (A→Z)  ^  Description  ^  Reference  ^
-^ Comment | Comment | User interface > Function window > [[en:infra-convert:user:interface:feature|Characteristic properties]] |
+^ TestPlanTitle | Title of the test plan version | Functions > Test plans > [[de:infra-convert:user:functions:qcpedit|Edit test plan]] |
-^ ToleranceTable | Tlolerance table | More > Terms > [[en:infra-convert:user:terms#Toleranztabelle|Toleranztabelle]] |
+^ TestPlanVersion | Test plan version number | ::: |
-^ ToleranceTableColumn | Tolerance class in Tolerance table (column) | More > Terms > [[en:infra-convert:user:terms#Toleranztabelle|Toleranztabelle]] |
+^ TestPlanDescription | Description of the test plan version | ::: |
-^ DrawingQuadrant | Field division | More > Terms > [[en:infra-convert:user:terms#drawing_sheet|Drawing sheet]] |
+^ Owner | Legal owner | ::: |
+^ PartNumber | Part number | ::: |
+^ RevisionPart | Revision index | ::: |
+^ Date | Date of issue | ::: |
+^ Title | Title | ::: |
+^ TitleSupplementary | Supplementary title | ::: |
+^ DrawingNumber | Drawing number | ::: |
+^ DrawingRevision | Revision status of drawing | ::: |
+^ Material | Material | ::: |
+^ Mass | Mass | ::: |
+^ Editor | Editor | ::: |
+^ TestPlanComment | Comment | ::: |
+^ … | All user-defined test plan data can be used as an export variable. The attribute key corresponds to the variable name. | Settings > Settings > Administration > [[https://wiki.elias-gmbh.de/doku.php?id=en:infra-convert:user:config:administration#additional_attributes_for_test_plan_versions_group|“Additional attributes for test plan versions” group]] |
+\\
+**Characteristics**
+The characteristic properties can be exported with the following variables.
+{{ :en:infra-convert:user:interface:excel-pruefbericht_erstellen_parameter_neu.png?nolink&900 |}}
+\\
+|< 100% 20% 40% 40% >|
+^  Name (A→Z)  ^  Description  ^  Reference  ^
+^ CharacteristicClassId | ID ("ELIAS-ID") der Merkmalklasse | More > Terms > [[http://wiki.elias-gmbh.de/doku.php?id=en:infra-convert:user:terms#class_characteristic|Class (characteristic-)]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColClass |
+^ CharacteristicGraphic | File name of the stamp graphic including the file ending | User interface > Function window > Features properties > [[en:infra-convert:user:interface:feature#properties|Properties]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColGraphicFile |
+^ CharacteristicId | Unique GUID for the feature | [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColID |
+^ CharacteristicType | Characteristic type (variable, attributive) | More > Terms > [[en:infra-convert:user:terms#en:infra-convert:user:terms#characteristic_test-_quality|Characteristic (test-, quality-)]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColAttributeType |
+^ CharacteristicTypeId | Characteristic type ID (1 = Variable; 0 = Attributive) | More > Terms > [[http://wiki.elias-gmbh.de/doku.php?id=en:infra-convert:user:terms#class_characteristic|Class (characteristic-)]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColAttributeType |
+^ Class | Characteristic class | More > Terms > [[en:infra-convert:user:terms#en:infra-convert:user:terms#class_characteristic|Class (characteristic-)]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColClass |
+^ ClassSymbol | Graphic symbol or label | More > Terms > [[en:infra-convert:user:terms#class_characteristic|Class (characteristic-)]] |
+^ Comment | Comment | User interface > Function window > [[en:infra-convert:user:interface:feature|Characteristic properties]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColComent |
+^ Conditions | Modifiers | User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] > Modifiers\\ Terms > More > [[en:infra-convert:user:terms#specification_operators_and_modifiers_iso_gps|Specification operators and modifiers (ISO GPS)]] |
+^ Count | Number of repetition | User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] > [[en:infra-convert:user:interface:feature#properties|Properties]] > Count |
+^ DrawingQuadrant | Field division | More > Terms > [[en:infra-convert:user:terms#drawing_sheet|Drawing sheet]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColDrawingQuadrant |
+^ DrawingSheet | File name of the drawing sheet including the file ending | [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColGraphicFile |
+^ Fit | Tolerance class (specifiction of fits) | More > Terms > [[en:infra-convert:user:terms#tolerance_table|Tolerance table]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColPassung |
+^ Label | Characteristic title, as displayed in #@IC_HTML@# | User interface > Function window > Characteristic properties > [[en:infra-convert:user:interface:feature#properties|Properties]] > Titel\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColLabel |
+^ LowerLimit | Lower limit value/minimum value, calculated from the nominal value and upper tolerance / lower deviation limit when exporting* | More > More > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] |
+^ LowerTolerance | Lower Tolerance | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColToleranceLow |
+^ LowerToleranceText | Lower tolerance as text to also obtain plus, degree, minute and second signs\\ \\ **Note** Available from program version 4.3.0 | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] |
+^ MinMax | Tag: Limit dimension in one direction (min., max.) | Settings > Settings > Merkmale > [[en:infra-convert:user:config:features#limit_values_in_one_direction_min_max_group|“Limit values in one direction (min., max.)” group]] |
+^ NominalUnit | Unit of measurement | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] |
+^ NominalText | Value of the nominal dimension as text to also receive plus, degree, minute and second signs\\ \\ **Note** Available from program version 4.3.0 | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] |
+^ NominalValue | Value of the nominal value | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColValue |
+^ PositionX | X-coordinate of the stamp in pixel | Functions > Characteristics > [[en:infra-convert:user:functions:balloonspos|Reposition and align stamp]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColPositionX |
+^ PositionY | Y-coordinate of the stamp in pixel | Functions > Characteristics > [[en:infra-convert:user:functions:balloonspos|Reposition and align stamp]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColPositionY |
+^ Radius | Size of the stamp, indicated as radius in pixel | [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColDiameterStamp |
+^ Reference | Reference | User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] |
+^ Requirement | Complete requirement, individually formattable for each feature class. | Administrator's Manual > Configuration and Import > Parameter file "CharacteristicClasses" > [[en:infra-convert:dev:characteristicclasses#Formatting the export variable "Requirement"|Formatting the export variable "Requirement"]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColLabel  |
 ^ SpecialCategory | Category | More > Terms > [[en:infra-convert:user:terms#category_characteristic|Category (characteristic-)]] |
-^ SpecialCategoryId | Category ID\\ (Available as of program version 1.3.4.1) | More > [[en:infra-convert:user:terms#Kategorie (Merkmal-)|Kategorie (Merkmal-)]] |
+^ SpecialCategoryGuid | Category GUID | More > [[en:infra-convert:user:terms#Kategorie (Merkmal-)|Kategorie (Merkmal-)]] |
+^ StampText | Stamp inscription | More > Terms > [[en:infra-convert:user:terms#stamp_stamps|Stamp/stamps]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColStampText |
 ^ Tags | Label/Tag | More > Terms > [[en:infra-convert:user:terms#label|Label]] |
-^ DrawingSheet | File name of the drawing sheet including the file ending\\ (Available as of program version 1.3.4.1) |  |
+^ TargetX | X-coordinate of the reference point (target point, origin point) of the stamp in pixel | Functions > Characteristics > [[en:infra-convert:user:functions:balloonspos|Reposition and align stamp]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColDestinationPositionX |
-^ PositionX | X-coordinate of the stamp in pixel\\ (Available as of program version 1.3.4.1) |
+^ TargetY | Y-coordinate of the reference point (target point, origin point) of the stamp in pixel\\ (Available as of program version 1.3.4.1) | Functions > Characteristics > [[en:infra-convert:user:functions:balloonspos|Reposition and align stamp]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColestinationPositionY |
-^ PositionY | Y-coordinate of the stamp in pixel\\ (Available as of program version 1.3.4.1) |
+^ ToleranceTable | Tlolerance table | More > Terms > [[en:infra-convert:user:terms#Toleranztabelle|Toleranztabelle]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColToleranceTable |
-^ TargetX | X-coordinate of the reference point (target point, origin point) of the stamp in pixel\\ (Available as of program version 1.3.4.1) |
+^ ToleranceTableColumn | Tolerance class in Tolerance table (column) | More > Terms > [[en:infra-convert:user:terms#Toleranztabelle|Toleranztabelle]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColToleranceTable |
-^ TargetY | Y-coordinate of the reference point (target point, origin point) of the stamp in pixel\\ (Available as of program version 1.3.4.1) |
+^ ToleranceUnit | Unit of the tolerance limits | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] |
-^ Radius | Size of the stamp, indicated as radius in pixel\\ (Available as of program version 1.3.4.1) |
+^ UpperLimit | Upper limit value/maximum value, calculated from the nominal value and lower tolerance / upper deviation limit when exporting* | More > More > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] |
-^ CharacteristicGraphic | File name of the stamp graphic including the file ending\\ (Available as of program version 1.3.4.1) |  |
+^ UpperTolerance | Upper Tolerance | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColToleranceHigh |
+^ UpperToleranceText | Upper tolerance as text to also obtain plus, degree, minute and second signs\\ \\ **Note** Available from program version 4.3.0 | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] |
+^ Value | Value | User interface > Function window > [[en:infra-convert:user:interface:feature|Characteristic properties]]\\ \\ [[en:infra-convert:add-in:customize#integrate_your_template_into_excel|Field name in Excel Report Add-In]] for #@IC_OLD_HTML@# with approximate equivalent: ColText |
+\\
+==== Standard templates ====
+The supplied ELIAS test report template is continuously updated and provided with new functions. Older versions of this development process are also installed, each marked with the year. The current version is
+<WRAP indent>
+**ELIAS_Report_2023.xltx**
+</WRAP>
-* Nominal and tolerance values are output as a text string to match the representation in the specification on the drawing. If you want to continue calculating with the numeric values, it may be useful to convert the strings into numbers. You can use the Excel [[https://support.office.com/en-gb/article/wert-funktion-257d0108-07dc-437d-ae1c-bc2d3953d8c2|VALUE]] function for this.
+Instructions for use and customization can be found in the file on the **Info** worksheet.
 <WRAP noprint>
@@ Line 88: / Line 292: @@
 <WRAP rightalign>
 **Go to previous page**\\
-Export drawing from the CAD system > Siemens PLM > [[en:infra-convert:user:cadexp:solid_edge_2019|Solid Edge 2019]]
+More > [[en:infra-convert:user:fonts|Dealing with missing fonts]]
 </WRAP>

ELIAS GmbHProduktdokumentationen

User Tools

Site Tools

Differences

Page Tools

ELIAS GmbH
Produktdokumentationen