This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
en:user_guide:tips [2020/06/17 12:17] tiger [Process structure] |
en:user_guide:tips [2020/06/17 12:23] tiger [Process structure] |
||
---|---|---|---|
Line 17: | Line 17: | ||
- At the end of every block release the source and target worksheets that are not needed further in the process using **WSheet Release**. | - At the end of every block release the source and target worksheets that are not needed further in the process using **WSheet Release**. | ||
- 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 ranges to column oriented ranges in DJeeni instead of filling the target range celss one by one but you have to recognise this option by understanding the template structures of the worksheets. | ||
- | 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/ |
===== Use Templates ===== | ===== Use Templates ===== | ||