Skip to content
This repository was archived by the owner on Jun 13, 2025. It is now read-only.

Template Details #TheBayFinal

Shizhong Yu edited this page Dec 26, 2020 · 12 revisions

Work in progress(Final) template


Table of Contents


Template Overview

Final Template Overview

* BAY_DailyWorkflow_template is the WIP template.

* MM.DD.YY_Daily Workflow Report_Bay is the Final template.


Summary Chart

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.


Workflow Details

The final version of worksheet is relatively simple, the settings do not contain any caveat. Only "Worksheet Name" settings need to match exactly with the name inside Final Template for operation to be successful. When WIP template finishes all related calculations, a copy operation will be queued at the end of "Summary Chart" operation, which then copies the content of corresponding data into the Final template.

For more information, please refer to Workflow Details.


Additional Color Size Report

The final version of worksheet is relatively simple, the settings do not contain any caveat. Only "Worksheet Name" settings need to match exactly with the name inside Final Template for operation to be successful. When WIP template finishes all related calculations, a copy operation will be queued at the end of "Summary Chart" operation, which then copies the content of corresponding data into the Final template.

For more information, please refer to Additional Color Size Report.


Not On Site Combined

The final version of worksheet is relatively simple, the settings do not contain any caveat. Only "Worksheet Name" settings need to match exactly with the name inside Final Template for operation to be successful. When WIP template finishes all related calculations, a copy operation will be queued at the end of "Summary Chart" operation, which then copies the content of corresponding data into the Final template.

For more information, please refer to WIP Not On Site Combined.

Clone this wiki locally