Differences

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

--- en:infra-convert:user:exceltemp [2021/05/06 15:39]
me
+++ en:infra-convert:user:exceltemp [2022/07/18 17:13]
me [Standard templates]
@@ Line 3: / Line 3: @@
 <WRAP noprint>
-> Benutzerhandbuch #@IC_HTML@# > Weiteres
+> User Manual #@IC_HTML@# > More
 </WRAP>
@@ Line 15: / Line 15: @@
 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&750 |}}
+{{ :en:infra-convert:user:interface:elias_excel_report.png?nolink&850 |}}
 \\
@@ 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 85: / Line 86: @@
 **Requirements**
-Microsoft Excel should be installed on the computer on which the export is performed in order to use all Excel functions.\\
+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 > „Excel test plan“ group
+ **See** Settings > Settings > Export > [[en:infra-convert:user:config:export#excel_test_plan_group|„Excel test plan“ group]]
 \\
@@ Line 122: / Line 123: @@
 ==== Structure ====
-**Das Importblatt**
+**The import sheet**
 <WRAP group>
@@ Line 147: / Line 148: @@
 **Define names**
-<WRAP group>
+#@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.
-<WRAP column half>
-#@IC_HTML@# writes the inspection characteristics line by line, i.e. one below the other. Another direction is not possible.
+Project and test plan attributes (available from program version 2.10.0) are written into one cell.
-Name the first cell in the column to be filled with values with an export variable from the [[en:infra-convert:user:exceltemp#exportvariables|subsequent]] table. Each name can be assigned only once.
+{{ :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]].
-> **Tip** Particularly suitable for displaying graphic symbols, such as the diameter sign, is the font **Segoe UI Symbol**.\\
+\\
-> {{ :en:infra-convert:user:interface:excel-schriftarten.png?nolink&300 |}}
+**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-pruefbericht_erstellen_neu.png?nolink&400 |}}
+{{ :en:infra-convert:user:interface:excel-schriftarten.png?nolink&400 |}}
+\\
 </WRAP>
@@ Line 171: / 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  ^  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  ^  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 217: / Line 269: @@
 * [**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.
+\\
+==== 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_2022_DE_EN.xltx**
+</WRAP>
+»DE« und »EN« indicate the languages German and English; the current template is bilingual. The following description refers to the current state.
+**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 (**Review** > **Changes** > **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 | Production process and product release¹ | Portrait format A4; sample size: 1 … 5 parts |
+^ PPF_10 | ::: | Landscape format A4; sample size: 1 … 10 parts; display of deviation |
+^ PPAP | Production Part Approval Process² | Portrait format A4; sample size: 1 … 5 parts |
+^ PPAP_10 | ::: | Landscape format A4; sample size: 1 … 10 parts; display of deviation |
+^ FAI | First article inspection³ | Portrait format A4; sample size: 1 … 5 parts |
+| 1 – VDA German Association of the Automotive Industry (Verband der Automobilindustrie): Volume 2 – Securing the Quality of Deliveries – Production process and product approval (PPA). 6<sup>th</sup> edition, April 2022\\ 2 – IATF 16949:2016-10, Quality management system requirements for automotive production and relevant service parts organisations (IATF International Automotive Task Force, AIAG Automotive Industry Action Group)\\ 3 – DIN ISO 9102:2016-12, Aerospace series – Quality systems – First article inspection requirements  |||
+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 (**Review** > **Changes** > **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>

ELIAS GmbHProduktdokumentationen

User Tools

Site Tools

Differences

Page Tools

ELIAS GmbH
Produktdokumentationen