Differences

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

--- en:user_guide:first_process [2021/01/21 16:25]
tiger [Try it out]
+++ en:user_guide:first_process [2023/08/04 22:21] (current)
tiger [Know your process]
@@ Line 6: / Line 6: @@
 ===== Know your process =====
-Djeeni is the tool to automate your process but only **after** it is designed and implemented. Even if you know your process by heart it is wise to take a pen and paper to write it down so you do not forget any steps. Let's take an example:
+Djeeni is the tool to automate your process but //only after// it is designed and implemented. Even if you know your process by heart it is wise to take a pen and paper to write it down so you do not forget any steps. Let's take an example:
-  * The process is to consolidate data from several //source worksheets// into a //target template//. Because the order of source files is important, another worksheet contains the list of files in the right order (call it: //master data//). The typical consolidation steps are:
+  * The process is to consolidate data from several //source worksheets// into a //target template//. Because the order of source files is important, another worksheet contains the list of files in the right order (call it: //master data//).
+  * The typical consolidation steps are:
     - Open the //target template// worksheet
     - Open the //master data// worksheet and go through the entries in it one by one. For each entry:
     - Open the corresponding //source worksheet//
-    - Perform some selection of source data
+    - 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.
-    - Perform some calculations on the source data
+      - set a cell or a range to a fix value (either constant or taken from the source worksheet or calculated using other fix values);
-    - Perform some copying of (calculated) data to the //target template//
+      - 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.
-    - Perform some calculations on the //target template//
+      - note this step for each such cell or range
+    - 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;
+      - enclose it in a **row list** (for a column) or **column list** (for a row) construct that will perform the cell-by-cell navigation
     - Close the //source worksheet//
     - Get the next entry in //master data//. Repeat until all entries are processed.
     - Close the //master data// worksheet
     - Save and close the //target template// worksheet
-  * This is just the skeleton of the process: selection, calculation and copying of source data must be further elaborated. You can easily reach 30-40-50 steps but do not be afraid. Always think about the Lego blocks - were you ever afraid of building something from 200 blocks? Building Djeeni processes is just as easy.
+  * This is the skeleton of the process. You can easily reach 30-40-50 steps but do not be afraid. Always think about the Lego blocks  - were you ever afraid of building something from 200 blocks? Building Djeeni processes is just as easy.
-  * Once you have your process on paper you are 75% ready. Good news!
+  * Once you have your process on paper, you are 75% ready. Good news!
 ===== Create your first process =====
@@ Line 31: / Line 35: @@
 ===== Let Djeeni know the process =====
-Open Djeeni (you might have to [[:en:user_guide:activate|activate]] it first). You can see a tall and thin popup - the [[en:user_interface:toolbar|Process Toolbar]]. This toolbar is used to build processes in Djeeni - block-by-block. Follow these instructions for adding a process step:
+Open Djeeni (you might have to [[:en:user_guide:activate|activate]] it first). You can see a popup window - the [[en:user_interface:toolbar|Process Toolbar]]. This toolbar is used to build processes in Djeeni - block-by-block. Follow these instructions for adding a process step:
   - Read the next step from your paper
   - Decide: is this step to deal with workbooks; worksheets; ranges; communication; or the structure of the process? Look at the example process steps in [[#Know your process]]:
-    * the first steps are about worksheets
+    * the first steps are about worksheets (opening them)
     * a list (structure) is started on the //master data// worksheet
     * we select, calculate, copy data from ranges/cells
@@ Line 68: / Line 72: @@
 ===== Edit/Remove process steps =====
-You have your first process in the [[en:user_interface:start|Process Editor]]. Select any process step by clicking on its name in column A. The selected process step becomes the //current process step// having a dark background and white text colour.
+You have your first process in the [[en:user_interface:start|Process Editor]]. Select any process step
+  - 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 by clicking on its name in column A. The selected process step becomes the //current process step// having a dark background and white text colour.
-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 button.
+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 button.
 You can remove the current process step by clicking on the 'Remove' button. Important: Avoid clicking on 'Clear' as it removes all steps (i.e., clears the editor)!

User Tools

Site Tools

Differences

Page Tools