Template Details #TheBayWip
- Template Overview
- Workflow Summary Chart
- Details Product
- Inactive UPC
- Inventory Value (Ttl inv)
- Not on site and Color Combined
* BAY_DailyWorkflow_template is the WIP template.
* MM.DD.YY_Daily Workflow Report_Bay is the Final template.
The work in progress or WIP template is the intermediate step to generate the clean output file.
The WIP template which gets filled by the automation first. This template is where the main data calculations are done and processed. The changes on this particular template will be fully reflected to the Final template. Settings can be tweaked to guide the calculations the automation uses.
The bay operations are split into four main operations include:
- Details-Product Operation (Data Source Operation)
- Inventory Value Evaluation Operation (Basic Operation)
- Inactive Upc Operation (Data Source Operation)
- Not-on-site Combined Operation (Data Source Operation)
These four operations are named respectively after the four input files. The following sections will be diving into each worksheet and their settings in detail.
The purpose of summary chart worksheet is relatively simple.
The summary chart includes a data table that consolidate all the relevant information regarding the bay workflow. The formulas embedded are calculated during the automation calculations. The data stored will be converted to values only upon finishing the calculations in the program. These conversions will also include the hidden ranges present. The calculations are only calculated Last after all other operations are completed.
To tweak the reporting area, and output locations, please follow the direction here for all report operations.
This is the main operation needed to generate the Summary Chart. More details can be found on the Dedicated Page.
Not on site is a data source type operation worksheet. This operation will follow general steps of any Data Source Operation.
The worksheet "UPC_Looker" is the data storage, after the data are loaded into the main operation worksheet "Inactive_UPC", calculation will take into account of the formula row which should be default to row 2.
"Inactive UPC" worksheet does not contain complex formulas rows, most of the operations are straight forward.
During the copy operation to the final template, only the reading address are copied. Please adjust the desired copy area if the formats are changed.
The values will not be converted to values only unless the WipWbValuesOnly setting is set to "true".
Inventory value is the basic type operation, therefore it does not require any data from inside the template. The data are read into the WIP template from the input file at the beginning of automation. The input file is then converted into a data table and joined together with data on the template via C# LINQ.
The format for this worksheet can not be changed inside the reading address, otherwise the data table will not be read correctly. The "Total" row with "SUM" as keyword indicate which column total $ amount is calculated when output file is generated. The row for SUM keyword is not adjustable, nor can the "Total" keyword be deleted.
The inventory value worksheet uses the category number to match the correct rows together. The names inside "Metrics" column will not be accounted in the output calculations.
Not on site is a data source type operation worksheet.
However, this worksheet is special in the sense that it's data source are located on its own worksheet without a separate worksheet to load its data. The formulas are embedded in the first row as default. The automated script will load input data into this worksheet, then do required calculations.
The values will not be converted to values only unless the WipWbValuesOnly setting is set to "true".