Djeeni Documentation

User Tools

Site Tools

Trace:

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
en:user_guide:tips [2020/06/17 11:19]
tiger [Process structure] 		en:user_guide:tips [2022/04/19 18:49] (current)
tiger [Process structure]
Line 8: Line 8:
  
 Djeeni looks at your process as a transformation of data from one or more sources to one or more targets. To achieve maximum readability and maintainability we suggest to follow the following sequence of process steps: Djeeni looks at your process as a transformation of data from one or more sources to one or more targets. To achieve maximum readability and maintainability we suggest to follow the following sequence of process steps:
-  - Define all known source worksheets using **WSheet Use** +  - Define all known source worksheets of the process using **[[en:process_steps:worksheet:wsheet_use|WSheet Use]]** 
-  - Define all known target worksheets using **WSheet Use** +  - Define all known target worksheets of the process using **[[en:process_steps:worksheet:wsheet_use|WSheet Use]]** 
-  - +  - Define all supplementary ('master data' ) worksheets of the process using **[[en:process_steps:worksheet:wsheet_use|WSheet Use]]** 
 +  - Optionally use temporary ('parameter') worksheets to store the result of some intermediary calculations using **[[en:process_steps:worksheet:wsheet_use|WSheet Use]]** 
 +  - Keep the process steps for creating and filling a specific target worksheet together as a block.  
 +  - Start a new block for a new target. 
 +  - Put a **[[en:process_steps:communication:comment|Comment]]** step before every block describing what is created in the block 
 +  - At the end of every block release the source and target worksheets that are not needed further in the process using **[[en:process_steps:worksheet:wsheet_release|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. 
 +  - 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 ranges to column-oriented ranges in DJeeni instead of filling the target range cells one by one but you have to recognize 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/storage targets that contain the results of some calculations; or enrich the input. Then the second phase uses these intermediary targets as source worksheets (next to the original ones) to create the final targets.
 ===== Use Templates ===== ===== Use Templates =====
  
Line 27: Line 36:
 MS Excel comes with regional settings and that includes different formatting of dates and numbers. Exchanging workbooks between organisations, systems and users leads to frequent problems with dates not understood by MS Excel as dates but literal text values making impossible to use these values in any process.  Most of the time you can not do anything about it as the worksheet is not created by you. But if you can, try the below steps: MS Excel comes with regional settings and that includes different formatting of dates and numbers. Exchanging workbooks between organisations, systems and users leads to frequent problems with dates not understood by MS Excel as dates but literal text values making impossible to use these values in any process.  Most of the time you can not do anything about it as the worksheet is not created by you. But if you can, try the below steps:
   * Intermediary worksheets should (and sometimes final worksheets may) contain a date in three separate columns: year, month, date. Consider using dates in this structure. You can easily create real dates from these values (if needed) using the MS Excel function Date().   * Intermediary worksheets should (and sometimes final worksheets may) contain a date in three separate columns: year, month, date. Consider using dates in this structure. You can easily create real dates from these values (if needed) using the MS Excel function Date().
-  *  Avoid using month names in source and intermediary worksheets. Keep month names only for target worksheets.+  *  Avoid using month names in source and intermediary worksheets. Instead use month numbers (January => 1, ..., December => 12). Keep month names only for target worksheets.
   * If dates are entered manually by a small group of people, educate them to note that (incorrectly entered) dates as text values are left aligned within the cell while proper date values are right aligned. Correct these values during manual entry.   * If dates are entered manually by a small group of people, educate them to note that (incorrectly entered) dates as text values are left aligned within the cell while proper date values are right aligned. Correct these values during manual entry.
  

Page Tools

en/user_guide/tips.1592385556.txt.gz · Last modified: 2020/06/17 11:19