Entering the 'Get Material Summaries' Formula Directly
The inserted Excel formula for the 'Get Material Summaries' command is shown below.
=SFMatSummaries(System, Database, Model, ModelAnalysis, StartingCase, EndingCase, Material, Attribute, SumOf, Cost Center, UOM, Outcode, Layer)
The following table lists the formula arguments.
Get Material Summary Formula Arguments
| Argument | Description |
|---|---|
| System (string) | Sigmafine Server name. |
| Database (string) | Database name. |
| Model (string) | Model name. |
| Model Analysis (string) | Model analysis name. |
| StartingCase (string) | Date/time of the starting case |
| EndingCase (string) | Date/time of the ending case. |
| Material (String) | This is a material name or a cell reference to a single material name. It must be found in the 'SF_Material' table. |
| Attribute (string) | Attribute name of the specified element. |
| Sum Of (string) | Selection of what the summary will include. Valid settings are: 'Opening Inventory', 'Closing Inventory', 'Receipts', or 'Shipments'. |
| Cost Center (string) | This is a cost center name. It must be found in the 'SF_Cost Center' table. |
| UOM (string) | This is a specified unit of measure that the value will have. The UOM must be one of the units listed in the attribute's unit-of-measure class. |
| Outcode (number) | Determines the row/column to include. For Outcode values, see "Output Code (Outcode) Table". |
| Layer (string) | (The name(s) of the layer(s) when 'Opening Inventory' or 'Closing Inventory' are selected for the 'Sum Of' setting. |