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.
This is the work in progress 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.
The output settings can be found here for detailed explanation.
Link to explanation about user settings here
Dedicated own page to this section.
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.
