en:infra-convert:user:exceltemp
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:infra-convert:user:exceltemp [2023/11/17 13:44] me [Export variables] |
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 | 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 | | ^ 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 | | ^ 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 | | ||
| Line 246: | Line 246: | ||
| ^ 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* | 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 | |
| + | ^ 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]] | | ^ 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-)]] | | ^ NominalUnit | Unit of measurement | 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 | | + | ^ 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 | | ^ 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 | | ^ 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 | | ||
| Line 265: | Line 267: | ||
| ^ ToleranceUnit | Unit of the tolerance limits | 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* | 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 | |
| + | ^ 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 | | ^ 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. | ||
| \\ | \\ | ||
en/infra-convert/user/exceltemp.1700225050.txt.gz · Last modified: 2023/11/17 13:44 by me
Page Tools
