In addition to creating process elements, it is also possible to create new process elements in a .xls file or, after exporting process elements, to adapt them in the Excel spreadsheet and then import them back into a project.
The structure of such a table is as follows:
The names of the columns can be entered in the table. Please refer to the following screenshot for the exact names of the respective columns.
The names of the columns can be entered in the table. Please refer to the following screenshot for the exact names of the respective columns.
A process element can consist of several time elements. For each time element that belongs to a process element, a new line must be created in the Excel table and all data must be entered in the respective columns.
| Column/Nr. | Name | Description |
| A/1 | Process element code | Each process element must be identified with a unique code. This code can appear in column A as often as time elements are assigned to this process element. |
| B/2 | Process element name | Name of the process element |
| C/3 | Time element code | Each process element can be assigned a name for the code here. When importing into the software, this name can also be found in the process element management. |
| D/4 | Time element name | So that the user can also store an activity behind the code of the time element, there is the column time element name. Activities such as walking, checking, or labeling can be entered here. |
| E/5 | Single duration | The duration of a time element must be entered as time in seconds. The individual time value for the respective element is defined. |
| F/6 | Frequeny | If a time element is used several times in succession, because the worker, for example, instead of 1m, as it is stored in the time element, walks 5m, the user can enter a 5 for this concrete example at frequency. Time elements that are executed only once in the entire process element are assigned the value 1 for the frequency. |
| G/7 | Duration | The duration describes the time required for the time element or the repeated execution of an identical time element if the frequency exceeds 1. A single execution of a time module within a process element causes the times in column E and column G to coincide. |
Note: The first line in the Excel Spreadsheet has to be in german like in the picture above. You can also see this in our example data.
The worksheet of the import file must have one of the following two names for successful import:
- IPO.Prozessbausteine
- IPO.ProcessElements
Tips:
- Creating process elements in an Excel file contains error potentials. For this reason, we recommend that users create process elements directly in the software.
- Please make sure that the process elements always have the same names and codes so that there is no redundancy.
- The same applies to the time elements. Time elements, even if they are assigned to several different process elements, always need the same code if the name is the same and you want to use them for the same purposes. There must also be no redundancies in the area of times.
- During import of process elements in ipolog 4 Material Flow, time elements are automatically created it time element management if they are new.
Comments
0 comments
Please sign in to leave a comment.