The full Excel spreadsheet contains multiple tables so that a single file could contain all of the process data for a PlantWise model. Each table provides data on a specific type of PlantWise model data.

Following are examples of all import table types and the data that may be contained in each table; required formatting and attributes are indicated in bold type. Similarly, the attribute column orders are not required; rather, the format used here follows the formatting of the process .rp* files.

Depending on how users generate the Excel file, it could be made up of one worksheet containing all of the class tables, multiple worksheets containing groups of tables, or as many worksheets as class tables.

Each class table is surrounded by the tags PW Data Starts and PW Data Ends. Any other data not contained within these tags will be ignored.

The first piece of information after the PW Data Starts tag is the data class type identifier followed by the class name in the next cell to the right. These two cells identify what sort of data is being imported.

There are four data class type identifiers:

1. PW Class: Used for nozzles, boundaries, pipelines, cables, named inline components, reducers, specification breaks, and component sequencing.
2. PW Equipment Class: Used for each type of equipment included in the model.
3. PW User Inline: Used for each type of user defined inline included in the model.
4. PW Data: Used of each data table being imported.

While these identifiers are not case sensitive, the spacing and punctuation are required.