User Settings #Common Structure #Report Type operation

---

Description:

Report type operation involves no calculations compared to other types of operation. This operation stores all relevant information about report generations including areas to copy and to skip.

Report type operation consist only two set of settings from:

• Report Worksheet

Located inside Work in progress(WIP) template. Report worksheet is marked as the worksheet to be copied. Note that if any of the area on WIP template are set outside area to be copied, they will not be carried over to the Final report.

• Final Report Worksheet

The final destination worksheet is usually located inside final template workbook. Final destination worksheet requires respective areas to be copied. Most of the formatting are assumed to be present already. Any changes on the WIP are fully reflected on the Final worksheet.

The general operation steps are as follows:

1. Program assumes the both WIP and Final workbook template are in open state.
2. Reporting worksheet data are turned into values only, converting any formulas and reference.
3. The data is copied to Final template from WIP template.

(TODO) Link to Report Type object in the class notes list.

---

Example:

//JSON object for Report Type operation settings
"SummarySettings": {
      "ReportSettings": {
        "WorksheetName": "WF Summary Chart",
        "DateAddress": "N5",
        "ReadingAddress": "E1:BO118"
      },
      "FinalSettings": {
        "WorksheetName": "Summary Chart",
        "WritingAddress": "E1"
      }
    }

ReportSettings

This setting includes basic information for reporting operation.

WorksheetName

The worksheet name present in WIP template, this reference can not contain misspelling nor incorrect capitalization. This reference name has to be exact copy. (Future update may nullify this requirement)

DateAddress

This is the single cell reference that indicate the location of date on the respective reporting worksheet. This cell reflects the value that exist inside settings file. The date is stored as UTC format, but translated into Weekday-Month-Day-Year format in the worksheet. The reference can be a single cell or more. Both of these reference work as a single cell: "E1:E1", "E1".

ReadingAddress

The area in Excel address to be copied from. The area excel address can not contain any special symbol such as '$' or sheet reference '!', this must be a valid excel range reference. The reference can be a single cell or more. Both of these reference work as a single cell: "E1:E1", "E1".

FinalSettings:

The worksheet to be copied to in Final template.

WorksheetName

Name of the worksheet in Final template, this reference can not contain misspelling nor incorrect capitalization.

WritingAddress

The data copied from WIP template copied to, the copied dimension is 100% reflective of the data being copied.