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:demoes:if_param_calculation [2022/10/23 22:56]
tiger [Phase 4] 		en:demoes:if_param_calculation [2022/10/23 23:21] (current)
tiger [Adjusting step parameters]
Line 25: Line 25:
 ** Report**: The output report that totals the orders by account, day, and grand total. The report structure is very flexible using several parameters that are discussed just below (DjeeniParameters). ** Report**: The output report that totals the orders by account, day, and grand total. The report structure is very flexible using several parameters that are discussed just below (DjeeniParameters).
  
-** DjeeniParameters**: This worksheet contains the parameters that make the process flexible. +** DjeeniParameters**: This worksheet contains the parameters that make the process flexible. Parameters with a yellow background are used by the process itself. The remaining parameters can be set freely. 
-  * The report covers a certain period. Parameters from B2-B7 specify the start and end date of the period (inclusive). When we work with Excel data the best practice is to let dates be specified as separate year, month, and day values to avoid misunderstanding (by users and by MS Excel itself).+  * The report covers a certain period. Parameters from B2-B7 specify the start and end date of the period (inclusive). When we work with Excel data the best practice is to let dates be specified as separate year, month, and day values to avoid misunderstanding (by users and by MS Excel itself). Month values are 1 ... 12 denoting January ... December respectively.
   * Parameter B10 specifies the starting column of the report. By default, it is B leaving column A for labels. The process does not touch columns before the given first column.   * Parameter B10 specifies the starting column of the report. By default, it is B leaving column A for labels. The process does not touch columns before the given first column.
   * Parameter B11 is a (by an MS Excel formula calculated) numeric value of the column letter in B10.   * Parameter B11 is a (by an MS Excel formula calculated) numeric value of the column letter in B10.
   * Parameters B8-B9 and B12 are used by the process to calculate or store different values.   * Parameters B8-B9 and B12 are used by the process to calculate or store different values.
  
-Download a workbook containing all three worksheets from https://djeeni.com/djeeni/demoprocess/decide_parameter_calculate . Save this workbook to any folder of your choice on your computer.+Download a workbook containing all three worksheets from https://djeeni.com/djeeni/demoprocess/decide_parameter_calculate . Save this workbook to any folder of your choice on your computer and make it editable (otheriwse the output report cannot be created).
  
 ==== Adjusting step parameters ==== ==== Adjusting step parameters ====
  
-You must manually adjust the **Workbook** parameter of all three [[en:process_steps:worksheet:wsheet_use|Wsheet Use]] process steps at the beginning of the process to match the location where you have saved the file you just downloaded ⇒ Open the process in Djeeni and double click on each WSheet Use step to open the parameter popup window, where you can change the file path.+You must manually adjust the **Workbook** parameter of all three [[en:process_steps:worksheet:wsheet_use|Wsheet Use]] process steps at the beginning of the Djeeni process to match the location where you have saved the file you just downloaded ⇒ Open the process in Djeeni and double click on each WSheet Use step to open the parameter popup window, where you can change the file path.
  
 ===== The automated process ===== ===== The automated process =====

Page Tools

en/demoes/if_param_calculation.1666558560.txt.gz · Last modified: 2022/10/23 22:56