Help Sheets#

The available Help Sheets are the highlighted grey rows in the image below:

Let's go through each one:

Index#

A list of the default sheets in the document, its object type, a brief description and the execution order of each file tab. All these fields are just informative.

There is an ExecutionOrder column where you can specify which sheets to be loaded in sequence, so that you can ensure that the proper entity dependencies are kept. Rows marked with ExecutionOrder = 0 will not be loaded.

Config#

Defines the configuration options for revisions that will be created when the package is loaded into the Critical Manufacturing MES.

Formats#

Specific cell content format for specific tabs and columns.

Assumptions#

Quick tips and hints for easier data input to the proper sheets.

WorksheetNameMapping#

Due to limitations in the Excel format, the names of the objects in MES are sometimes longer than the allowed values for the tab names. To avoid this issue and maintain compatibility with multiple versions of Excel, this sheet serves as a shortening cheat-sheet for the tab names. The first column, with WorksheetName in the header, has the names of the tabs in the Excel files that correspond to each of the values in the second column, Value, representing the names of the system objects that are referenced. Define your tab name using the tag <LOOKUP> and append a short name for the object (e.g, <LOOKUP>MySmartTable). Then, in this tab, map it to the tab name you would define otherwise, so that MySmartTable becomes the shortened version of <ST>TheRealNameForMySmartTable.

Enums#

Values for enumerations that are used for cell validation throughout the template file.

Remaining Sheets#

The remaining sheets refer to the actual entities you can load into the system.