Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:user_guide:first_process [2023/08/04 22:09] tiger [Know your process] |
en:user_guide:first_process [2023/08/04 22:21] (current) tiger [Know your process] |
||
|---|---|---|---|
| Line 13: | Line 13: | ||
| - Open the //master data// worksheet and go through the entries in it one by one. For each entry: | - Open the //master data// worksheet and go through the entries in it one by one. For each entry: | ||
| - Open the corresponding //source worksheet// | - Open the corresponding //source worksheet// | ||
| - | - Identify every separate cell or range on the //target template// that you can fill in a simple step. E.g. | + | - Identify every separate cell or range on the //target template// that you can fill in a simple step using the current //source worksheet//. E.g. |
| - set a cell or a range to a fix value (either constant or taken from the source worksheet or calculated using other fix values); | - set a cell or a range to a fix value (either constant or taken from the source worksheet or calculated using other fix values); | ||
| - find a cell with a certain value in a range to use the value or the location (row number or column letter) of the found cell later. | - find a cell with a certain value in a range to use the value or the location (row number or column letter) of the found cell later. | ||
| - note this step for each such cell or range | - note this step for each such cell or range | ||
| - | - Identify | + | - Identify a column or a row on the //target template// that you can fill cell-by-cell using the same formula with dynamic values. |
| - note the step for a single cell; | - note the step for a single cell; | ||
| - | - enclose it in a **row list** or **column list** construct that will perform the cell-by-cell navigation | + | - enclose it in a **row list** |
| - Close the //source worksheet// | - Close the //source worksheet// | ||
| - Get the next entry in //master data//. Repeat until all entries are processed. | - Get the next entry in //master data//. Repeat until all entries are processed. | ||
| Line 72: | Line 72: | ||
| ===== Edit/Remove process steps ===== | ===== Edit/Remove process steps ===== | ||
| - | You have your first process in the [[en: | + | You have your first process in the [[en: |
| + | - on the visual editor by clicking on the process step. The selected process step becomes the //current process step// and gets a red colour frame | ||
| + | - on the detail editor | ||
| - | You can insert a new process step before the current process step by selecting the new process step on the Process Toolbar and then clicking on the Before | + | You can insert a new process step before the current process step by selecting the new process step on the Process Toolbar and then clicking on the Insert |
| You can remove the current process step by clicking on the ' | You can remove the current process step by clicking on the ' | ||