STACK.ESTIMATEWORKSHEETOTHERCOSTS

Introduction

The STACK.ESTIMATEWORKSHEETOTHERCOSTS function returns Other Costs lines in a given Estimate Worksheet.

CODE

=STACK.ESTIMATEWORKSHEETOTHERCOSTS(ConnectionName, Estimate, Select, OtherCostType, TableOutputCell)

Parameter	Required/Optional	Description
`ConnectionName`	Required	The name of the connection, as specified in the Connection Manager
`Estimate`	Required	Estimate name. Use the STACK.EXPANDESTIMATERANGE function to retrieve the list of STACK estimates.
`Select`	Optional	A comma-separated list of case-insensitive field names to be included in the results as columns. Run this function with this argument omitted to see all available fields.
`OtherCostType`	Optional	An optional filter by cost types. Available values: `D` - Direct Costs, `I` - Indirect Costs, `C` - Contingencies, `O` - Overhead, `P` - Profit, `T` - Tax, and their combinations. For example: `DIT`
`TableOutputCell`	Optional	If the parameter is specified, the function output is represented as an Excel table, and the first column is populated at this address. See the Table Mirroring article for details. If the parameter is omitted, the result is returned as a spill range.