To Configure a Responsibility Matrix File
AssetWise CONNECT Edition ALIM allows one or more Excel files to be included, to generate a responsibility matrix. Since each import file may have different formatting, you must first map the information from the Excel import file, to instruct AssetWise CONNECT Edition which information to include and where it resides within the Excel import file, so that the responsibility matrix can be generated.
Below is an example of how the contents of an Excel
import file was mapped to the responsibility matrix:
Follow these steps to configure the responsibility matrix file in AssetWise CONNECT Edition ALIM.
- Open the Responsibility Matrix page for which you want to configure the responsibility matrix file.
- Select the Matrix file configuration tab.
- Accept or edit the Description.
-
In the
Configuration topic, enter the following
required information:
- Enter the File name of the previously uploaded Excel workbook that contains the data for the responsibility matrix
- In the Sheet name box, enter the name of the worksheet within the Excel import file, that contains the data for the responsibility matrix.
- In the Start row box, enter the starting row number of the data within the Excel import file, that you want to import.
- In the Start column box, enter the starting column of the data within the Excel import file, that you want to import.
- In the Levels topic, do the following:
The responsibility
matrix mapping process is complete. You may now
Process the matrix.