STACK.EXPANDTAKEOFFRANGE
Introduction
The STACK.EXPANDTAKEOFFRANGE function returns sorted names of takeoffs within a given project matching the search criterion.
Syntax
CODE
=STACK.EXPANDTAKEOFFRANGE(ConnectionName, Project, Takeoff)Parameters
Parameter | Required/Optional | Description |
|---|---|---|
| Required | The name of the connection, as specified in the Connection Manager |
| Required | Project name. |
| Optional | A search expression for filtering takeoffs, uses Velixo filtering techniques. If not specified, returns all takeoffs. |
Example
=STACK.EXPANDTAKEOFFRANGE("Stack", "Second Project")
Description: Returns all takeoffs in the Second Project project for the connection named Stack.