User Settings #Common Structure #Data Source Type operation

---

Description:

Data source type operation requires additional data source compared the basic type operation. The operation involves an additional worksheet to store imported data and do calculations during output file generation.

Data type operation refers to a collection of 3 subset of operations, the requirements are:

• Data source worksheet

Located inside Work in progress(WIP) template. Data source worksheet is responsible to store the data imported from the input files.

• Main operation worksheet

Located inside Work in progress(WIP) template. Main operation worksheet is the main calculation section that houses all the custom formula logic and calculation steps to ensure workflow output.

• Final destination worksheet

The final destination worksheet is usually located inside final template workbook. Final destination worksheet settings guide the formatted output.

Data type operations builds on top of Basic Type Operation. The WipSettings are expanded with two additional fields to account for the additional customizable formula operations.

The general operation steps are as follows:

1. Load input files data onto the data source worksheet.
2. Input data is used for calculations on the main operation worksheet.
3. Formulas in formula row are used to process the customized calculations.
4. Output results is put on halt while waiting for copy operation into the final template.

(TODO) Link to Data source Type operation object in the class notes list.

---

Example:

//JSON object example for Data Source Type operation settings
"InactiveUpcSettings": {
      "WipSettings": {
        "FormulaRow": 3,
        "ReferenceRow": 4,
        "WorksheetName": "Inactive_UPC",
        "HeaderRow": 7,
        "WritingRow": 8,
        "ReadingAddress": "A:AS"
      },
      "FinalSettings": {
        "WorksheetName": "Additional Color Sizes Report",
        "WritingAddress": "A4"
      },
      "DataSourceSettings": {
        "HeaderRow": 1,
        "WritingRow": 1,
        "WorksheetName": "UPC_Looker"
      }

WipSettings:

This setting give basic set of information for the program's operation. It includes the following:

FormulaRow

This is the row that is designated for storing all the customized excel formula, the user could use to embed custom logic correspond to their own respective columns below the formula.

ReferenceRow

This is the row that is designated for referencing all the data source based on the main operation sheet's column name to extract data and calculate based on the logic supplied. Note that program print blank results if there are mismatching column names.

Section below is the same as Basic Type Operation :

Worksheetname:

Name of the worksheet in WIP template.

HeaderRow

This row is used as the search row to find all the column headers to operate column wise operations. If any header is missing or mismatches from the header names pre-defined in the code, the program will crush.

WritingRow

This row is used as guideline for program to write its output after calculations. The end result of calculations are often 2-dimentional data tables that needs to be written to specific row. The column will be automatically matched based on the HeaderRow values read.

ReadingAddress

The reading address is generic term for area being read into the operation calculations, it varies based on the calculations. For specific information on individual calculation, please refer to the banner specific documentations.