This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
en:user_guide:tips [2021/04/26 22:47] tiger [Process structure] |
en:user_guide:tips [2022/04/19 18:49] (current) tiger [Process structure] |
||
---|---|---|---|
Line 10: | Line 10: | ||
- Define all known source worksheets of the process using **[[en: | - Define all known source worksheets of the process using **[[en: | ||
- Define all known target worksheets of the process using **[[en: | - Define all known target worksheets of the process using **[[en: | ||
- | - Define all supplementary (' | + | - Define all supplementary (' |
- | - Optionally | + | - Optionally |
- | - Keep the process steps for creating and filling a target worksheet together as a block. | + | - Keep the process steps for creating and filling a specific |
- Start a new block for a new target. | - Start a new block for a new target. | ||
- Put a **[[en: | - Put a **[[en: | ||
- At the end of every block release the source and target worksheets that are not needed further in the process using **[[en: | - At the end of every block release the source and target worksheets that are not needed further in the process using **[[en: | ||
- Within a block focus on the target structure with the question: how this cell / range gets its value?. Identify ranges that can get a value in one step instead of dealing with every cell separately. | - Within a block focus on the target structure with the question: how this cell / range gets its value?. Identify ranges that can get a value in one step instead of dealing with every cell separately. | ||
- | - Pay attention to templates: most of them are row oriented (similar data below each other) but there are many exception of colum oriented templates (similar data next to each other). You can easily transpose row orinted | + | - Pay attention to templates: most of them are row oriented (similar data below each other) but there are many exception of colum oriented templates (similar data next to each other). You can easily transpose row-oriented |
If calculations look too complex for a direct source-target process then consider building a two-phase process: in the first phase create intermediary/ | If calculations look too complex for a direct source-target process then consider building a two-phase process: in the first phase create intermediary/ |