EXCEL Document 

Definition

Is made up of table sheets where data is listed and analyzed and a control sheet where control information is contained.

Use

The document must be structured in such a way that you can use the Microsoft Excel document as a tool.

You can enter and process data in more than one table sheet as well as carry out calculations with the data from the tables.

Structure

Templates and data sheets consist of

A table sheet in a template contains the graphics, texts, and formatting you require.

A table sheet in a data sheet contains also all the information about characteristics. This information is read from the SAP System and given as output according to the control information.

The control sheet contains the following information:

Column

Meaning

A

Class type

B

Class

C

Characteristic name

D

Address of the cell of the table sheet to which you want to export the characteristic value

E

Address of the cell of the table sheet to which you want to export the characteristic description

F

Address of the cell of the table sheet to which you want to export the unit of measure

H

Example of a characteristic value

I

Example of a unit of measure

The syntax for entering the cell address is entered as follows:

=Tablename!$Column$Row, for example =Pump!$E$8

This also ensures that changes to the table sheet are always maintained even if rows and columns are deleted.

Column H and I are filled in depending on the settings.

See also:

Processing a Template

Processing a Data Sheet