Calculate values in a spreadsheet

You can calculate numerical values directly in your spreadsheet.

Procedure

  1. Open a spreadsheet.

    You can open models in different ways.

    Prerequisite

    The type of the model is allowed by the method filter in use. You select the method filter when you log in to the database.

    Procedure

    Using a new tab

    1. Start ARIS or open a new tab.

    2. In the Favorites or Recently used area, click the model you want to open.

    The model opens in the new tab.

    Using the Explorer tab

    1. Click ARIS > Explorer Explorer. The Explorer tab opens.

    2. In the navigation, click the group of the database in which the relevant models are saved. The details view provides you with a field for filtering and with the Models and Objects areas.

    3. In the Models area select the required models.

    4. Right-click in the selection and select Open.

    The selected models open in a separate tab.

    Using the model Explorer tree

    Prerequisite

    You have activated the tab of an open model.

    Procedure

    1. Click Navigation Navigation in the bar panel if the Navigation bar is not activated yet.

    2. In the Explorer tree, click the group in which the required model is stored.

      Click the Models check box if you want to show or hide models within the Explorer tree.

      Click the Objects check box if you want to show or hide objects within the Explorer tree.

      Use the pop-up menu to create groups and models, and cut, delete, or rename groups, models, and objects. You can also update content, open models, and create shortcuts for models and objects.

    3. Right-click the model.

    4. Click Open.

    The model opens.

    You have opened a model.

  2. Click the row where you want to add a value.

  3. Enter the relevant value.

  4. Select an empty cell and enter the relevant formula in the row, for example, =SUM(A1;B1).

  5. Press Enter.

The result of the calculation is displayed in the cell.

You can also calculate with attribute values of ARIS objects in this way.

Example

Calculate the sum of two cells containing the values 100 and 50.

Calculate values in a spreadsheet