---
pdfexport: true
alias: master-data-helper-sheets-tutorial
description: "This documentation outlines configuration sheets for data loading and mapping within a manufacturing system"
---

# Help Sheets

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

![Screenshot showing a diagram of data management processes.](../../../../images/masterdata_02.png)

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.

!!! info
	  For an easier, faster and more comfortable way of switching between the tabs, a shortcut can be used by right-clicking on the left/right arrows used to select the tabs and activating the tab you wish to see.

![Screenshot showing a tab navigation interface with remaining sheets.](../../../../images/masterdata_52.png)