User Tools

Site Tools


en:infra-convert:user:exceltemp

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
en:infra-convert:user:exceltemp [2022/06/01 17:12]
me
en:infra-convert:user:exceltemp [2023/11/17 13:54] (current)
me
Line 187: Line 187:
  
 |< 100% 20% 40% 40% >| |< 100% 20% 40% 40% >|
-^  Name  ^  Description ​ ^  Reference ​ ^+^  Name (A→Z) ​ ​^ ​ Description ​ ^  Reference ​ ^
 ^ ProjectTitle | Project title | Funktionen > Projekt > Functions > Project > [[en:​infra-convert:​user:​functions:​newproject|Create new project]] | ^ ProjectTitle | Project title | Funktionen > Projekt > Functions > Project > [[en:​infra-convert:​user:​functions:​newproject|Create new project]] |
 ^ ProjectDescription | Project description | ::: | ^ ProjectDescription | Project description | ::: |
Line 201: Line 201:
  
 |< 100% 20% 40% 40% >| |< 100% 20% 40% 40% >|
-^  Name  ^  Description ​ ^  Reference ​ ^+^  Name (A→Z) ​ ​^ ​ Description ​ ^  Reference ​ ^
 ^ TestPlanTitle | Title of the test plan version | Functions > Test plans > [[de:​infra-convert:​user:​functions:​qcpedit|Edit test plan]] | ^ TestPlanTitle | Title of the test plan version | Functions > Test plans > [[de:​infra-convert:​user:​functions:​qcpedit|Edit test plan]] |
 ^ TestPlanVersion | Test plan version number | ::: | ^ TestPlanVersion | Test plan version number | ::: |
Line 230: Line 230:
  
 |< 100% 20% 40% 40% >| |< 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 | ^ 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 | ^ 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-)]] | ^ 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 | ^ 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 | ^ 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 | ^ 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 | ^ 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.| 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 plusdegree, 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.| 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 ​ | ^ 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-)]] | ^ 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 | ^ 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]] | ^ 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 | ^ 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 | ^ 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 | ^ 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 |
-* [**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.+
  
 \\  \\ 
Line 277: Line 278:
  
 <WRAP indent> <WRAP indent>
-**ELIAS_Report_2022_DE_EN.xltx**+**ELIAS_Report_2023.xltx**
 </​WRAP>​ </​WRAP>​
  
-»DE« und »EN« indicate the languages German and English; the current template is bilingual. The following description refers to the current state. +Instructions ​for use and customization ​can be found in the file on the **Info** worksheet.
- +
-**Structure and functions** +
- +
-{{ :​en:​infra-convert:​user:​interface:​excel_report_standardvorlage_blaetter.png?​nolink&​700 |}} +
- +
-The workbook is designed so that all entries are made on the "​Input"​ sheet. General test report data are entered in the upper part, characteristic-related data in the lower part. The input fields relevant ​for the editor are highlighted in yellow. By protecting the sheet (**Check** > **Protect** > **Protect sheet** > optionally assign a password ​and keep the default selection > **OK**), all other fields ​can be locked against accidental editing. +
- +
-On the far right of the sheet, settings can be adjusted: +
- +
-|< 100% 20% 80% >| +
-^  Setting ​ ^  Description ​ ^ +
-^ Language | Switch the language of the display texts. The default selection is German. | +
-^ Release procedure | The general data required for the release procedure (PPF, PPAP, FAI) are marked with the ⌫ character according to the selection. | +
-^ Sample size | The number of parts to be measured can be selected. Excess columns are marked as not used on the input and subsequent sheets. | +
- +
-In the "​Verification"​ column, the results for each tested part are entered, ​in the case of a quantitative test the measured value, in the case of a qualitative test "​OK"​ or "​NOK"​. Measured values within the tolerance range or in-order results are highlighted in green, measured values within tolerance but close to the tolerance limit* are highlighted in orange, and measured values outside tolerance and out-of-order results are highlighted in red. The deviation of the mean value of all individual measured values from the center of the tolerance range is displayed with a bar if the upper and lower limits are clearly defined. +
- +
-**Note *​** Die Messwert-Warngrenze kann auf dem Blatt »Admin« in Spalte Y in Prozent angegeben werden.The measurement value warning limit can be specified ​on the "​Admin"​ sheet in column Y as a percentage. +
- +
-The following sheets represent the forms of various release procedures. They are suitable for printing or exporting as PDF. The inputs on the input sheet are distributed to these sheets. +
- +
-|< 100% 15% 35% 50% >| +
-^  Sheet name  ^  Based on  ^  Description ​ ^ +
-^ PPF | VDA: Volume 2, 6th edition, April 2020 | Portrait format A4; sample size: 1 ... 5 parts | +
-^ PPAP | IATF, AIAG: PPAP 4th edition | Portrait format A4; sample size: 1 ... 5 parts | +
-^ FAI | ISO 9102, December 2016 | Portrait format A4; sample size: 1 ... 5 parts | +
- +
-Forms that are not needed can be hidden (right click on the tab > **Hide**) or deleted. +
- +
-The Admin sheet essentially contains identifier-value assignments that are used by means of names in the workbook. The Admin sheet must not be hidden or deleted. +
- +
-**Edit the template** +
- +
-The templates can be freely used and edited in combination with #​@IC_HTML@#​. +
- +
-**Change display texts** – All display texts are defined on the "​Admin"​ sheet and are entered as names in the appropriate places. In this way the switching of the language is realized. Texts can thus be easily adapted on the "​Admin"​ sheet and change immediately at all points in the document. Other languages can also be implemented in this way. +
- +
-**Customize forms** – The printable pages can be customized after removing the sheet protection (**Check** > **Unprotect Sheet**). For example, an area for company logo and other individual information is kept free on the first sheet in each case. +
- +
-**Restore dynamic print range** – The print area for the form sheets is determined dynamically by calculation depending on the number of characteristics. This way, the print area is limited to the sheets actually filled with inspection data, even without having to use a VBA macro. If the link with the formula has been overwritten unintentionally,​ for example by navigating via **Page Layout** in **Page Setup**, the link can be reassigned as follows: +
- +
-  - Remove the sheet protection. +
-  - Open **Formulas** > **Name Manager**.. +
-  - Edit the "Print Area" name for the "​PPF",​ "​PPF_10",​ "​PPA",​ "​PPA_10"​ and "​FAI"​ area respectively. +
-  - Copy ='​PPF'​!DynDruckBereich (for the sheet "​PPF"​) in the "​Refers to" field. +
- +
-**Insert more sheets** – The Excel workbook can be extended as required.+
  
 <WRAP noprint> <WRAP noprint>
en/infra-convert/user/exceltemp.1654096342.txt.gz · Last modified: 2022/06/01 17:12 by me