Working in a Spreadsheet
The Sigmafine Excel Add-In creates a ribbon menu in Excel named "SF" (as shown in Figure 679). As of version 4.6.x, a 'Find Adjustments' option was added to the toolbar that allows you to import a list of adjustments for selected cases. In addition, a 'Find Cases' option was also added that allows you to import a list of Cases for a selected time range.
The following table describes the use of each command found on the SF toolbar.
SF Toolbar "Find Data" Commands
| Command | Description |
|---|---|
| Database Model/Model Analysis/Case | Lets you select the Database, model, Model analysis and Case. |
| Cases | Lets you select Cases in a Model analysis. |
| Table Values | Lets you view and select values within a database table. |
| Elements | Lets you select elements in a model. |
| Transfers | Lets you select all the transfers in selected cases. |
| Adjustments | Lets you select all the adjustments in selected cases. |
SF Toolbar "Get Data" Commands
| Command | Description |
|---|---|
| Transfer Values | Lets you retrieve transfer attribute(s) value(s). |
| Attribute Values | Lets you retrieve Attribute values for an element. |
| Attribute Data Table Values | Lets you retrieve values for Attributes that are of Data Table type. |
| Connections | Lets you retrieve the adjacent elements in the model. |
| Element Properties | Lets you retrieve the properties of a specified element. |
| Table Data | Lets you retrieve database table columns based on a key table field. |
SF Toolbar "Get Summary" Commands
| Command | Description |
|---|---|
| Attribute Summary Values | Lets you retrieve aggregated results for an element. |
| Material Summary | Lets you retrieve the aggregated value for open inventory, closing inventory, receipts and shipments, based on the material selected. This option appears only if Sigmafine has been installed. |
SF Toolbar "Tools" Commands
| Command | Description |
|---|---|
| Refresh Database | Causes any changes made in other applications to be made available to the Excel Add-In. |
| Convert AF to SF Formulas | Lets you convert the Sigmafine 4.4.5 formulas so that they are compatible with Sigmafine 4.7 version. |
| Run Analysis | Lets you run a predefined analysis rule on a model. |
SF Toolbar "Resources" Commands
| Command | Description |
|---|---|
| Settings | Lets you choose the default settings for the Sigmafine Excel Add-In. |
| About | Displays the add-in's version information. |
| Help | Accesses the Help information. |