Differences

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

--- en:infra-convert:user:exceltemp [2022/04/06 15:25]
me [Structure]
+++ en:infra-convert:user:exceltemp [2023/11/17 13:54] (current)
me
@@ Line 3: / Line 3: @@
 <WRAP noprint>
-> Benutzerhandbuch #@IC_HTML@# > Weiteres
+> User Manual #@IC_HTML@# > More
 </WRAP>
@@ Line 26: / Line 26: @@
  • [[en:infra-convert:user:exceltemp#Fundamentals]]\\
  • [[en:infra-convert:user:exceltemp#Structure]]\\
- • [[en:infra-convert:user:exceltemp#Export variables]]
+ • [[en:infra-convert:user:exceltemp#Export variables]]\\
+ • [[en:infra-convert:user:exceltemp#Standard templates]]
 \\
@@ Line 147: / Line 148: @@
 **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 [[#Exportvariables|following]] Table. Each name can be assigned only once.
+#@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.
@@ Line 178: / Line 179: @@
 ==== Export variables ====
-The following variables are available, see also the table.
+**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 (A→Z)  ^  Description  ^  Reference  ^
+^ ProjectTitle | Project title | Funktionen > Projekt > Functions > Project > [[en:infra-convert:user:functions:newproject|Create new project]] |
+^ ProjectDescription | Project description | ::: |
+\\
+**Test plan data**
+Test plan data are set in the Edit test plan version dialog. The following export variables are available for each test plan export.
+\\   **See** Functions > Test plans > [[de:infra-convert:user:functions:qcpedit|Edit test plan]]
+> **Note** Available from program version 2.10.0.
+|< 100% 20% 40% 40% >|
+^  Name (A→Z)  ^  Description  ^  Reference  ^
+^ TestPlanTitle | Title of the test plan version | Functions > Test plans > [[de:infra-convert:user:functions:qcpedit|Edit test plan]] |
+^ TestPlanVersion | Test plan version number | ::: |
+^ TestPlanDescription | Description of the test plan version | ::: |
+^ 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 |}}
@@ Line 185: / Line 230: @@
 |< 100% 20% 40% 40% >|
-^  Name  ^  Description  ^  Reference  ^
+^  Name (A→Z)  ^  Description  ^  Reference  ^
-^ CharacteristicClassId | ID ("ELIAS-ID") der Merkmalklasse\\ \\ **Note** 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-)]]\\ \\ [[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: CollClass |
+^ 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\\ \\ **Note** Available as of program version 1.3.4.1 | 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 |
+^ 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\\ \\ **Note** Available as of program version 1.3.4.1 | [[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: CollD |
+^ 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)\\ \\ **Note** 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-)]]\\ \\ [[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\\ \\ **Note** Available from program version 2.2.7| 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)]] |
+^ 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 repetitions\\ \\ **Note** Available from program version 2.2.7 | User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] > [[en:infra-convert:user:interface:feature#properties|Properties]] > Count |
+^ 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\\ \\ **Note** Available as of program version 1.3.4.1 | [[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 |
+^ 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*\\ \\ **Note** Available as of program version 1.3.4.1 | More > More > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] |
+^ 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 |
+^ 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 |
-^ MinMax | Tag: Limit dimension in one direction (min., max.)\\ \\ **Note** Available from program version 2.2.7 | 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]] |
+^ 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-)]] |
-^ NominalUnit | Unit of measurement\\ \\ **Note** Available from program version 1.3.9.7 | 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]] |
-^ 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 |
+^ NominalUnit | Unit of measurement | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] |
-^ PositionX | X-coordinate of the stamp in pixel\\ \\ **Note** 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: ColPositionX |
+^ 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-)]] |
-^ PositionY | Y-coordinate of the stamp in pixel\\ \\ **Note** 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: ColPositionY |
+^ 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 |
-^ Radius | Size of the stamp, indicated as radius in pixel\\ \\ **Note** Available as of program version 1.3.4.1 | [[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 |
+^ 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 |
-^ Reference | Reference\\ \\ **Note** Available from program version 2.2.7 | User interface > Function windows > Characteristic properties > [[en:infra-convert:user:interface:feature#Properties|Properties]] |
+^ 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-)]] |
-^ SpecialCategoryGuid | Category GUID\\ \\ **Note** Available as of program version 1.3.9.4 | 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]] |
-^ TargetX | X-coordinate of the reference point (target point, origin point) of the stamp in pixel\\ \\ **Note** 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: ColDestinationPositionX |
+^ 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 |
 ^ 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 |
 ^ 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 |
 ^ 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 |
-^ ToleranceUnit | Unit of the tolerance limits\\ \\ **Note** Available from program version 1.3.9.7 | More > Terms > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] |
+^ ToleranceUnit | Unit of the tolerance limits | 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*\\ \\ **Note** Available as of program version 1.3.4.1 | More > More > [[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* | More > More > [[en:infra-convert:user:terms#measurement_sizes|Measurement (sizes-)]] |
-^ 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 |
+^ 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 |
-^ Value | Value\\ \\ **Note** Available as of program version 1.3.4.1 | 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 |
+^ 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>
-* [**Note** The restriction described in the following no longer applies from programme version 2.5.3. From this version onwards, numerical values are no longer exported as text but as numbers.] 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>

ELIAS GmbHProduktdokumentationen

User Tools

Site Tools

Differences

Page Tools

ELIAS GmbH
Produktdokumentationen