Skip to main content

Configuring the SF Add-In Settings

The SF Add-In Settings dialog box controls your settings and preferences for the SF Add-In. You can select a default System, database, Model and Model analysis from the drop-down lists. You can also select the output preference, number format, and time format. These are the same formats available through Excel.

On the SF menu, click Settings. The defaults set here are held between Excel sessions. All these settings are saved in the Windows user's profile. Windows users using the add-in under different log-ins have their own custom settings.

To configure SF Add-In settings:

  1. From the Excel ribbon menu, click on the SF tab.Figure 727: SF tab - Resources section

  2. In the Resource section, select Settings.

    The SF Add-In Settings window opens.Figure 728: SF Add-In Settings window

  3. Click the System down-arrow and select the Sigmafine Server to be used as the default.

  4. Click the Database down-arrow and select the database to be used as the default.

    This selection is dependent on the Sigmafine Server selection.

  5. Click the Model down-arrow and select the Model to be used as the default.

    This selection is dependent on the Database selection.

  6. Click the Model Analysis down-arrow and select the Model analysis to be used as the default.

    This selection is dependent on the Model selection.

  7. Select the Output Preference (output direction) for SF function results. Choices are to have the data listed in rows (Row) or in columns (Column).

  8. In the Number Format box, type the format that you want for the numeric values returned by the add-in functions.

    This number format must match an Excel-accepted format, for example 00.00, ##.##. It defaults to "General". Unrecognized formats return the unrecognized text.

  9. In the Time Format box, type the format that you want used for the date/time values returned by add-in functions.

    This time format must match an Excel-accepted format, for example, mm-dd-yy hh:mm:ss. It defaults to the Windows default format. Unrecognized formats return the unrecognized text.

  10. Click OK to save your settings and close the window.