STACK.TAKEOFFREPORT

Overview

The STACK.TAKEOFFREPORT function returns filtered Takeoff report records for takeoffs within a project.

Syntax

CODE

=STACK.TAKEOFFREPORT(
    ConnectionName,
    Project,
    Select,
    Takeoff,
    Plan,
    Tags,
    Labels,
    TableOutputCell
)

Arguments

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection, as specified in the Connection Manager
`Project`	Required	Project name. Use the STACK.EXPANDPROJECTRANGE function to retrieve the list of STACK projects.
`Select`	Optional	A comma-separated list of columns to be returned. Use column headers of the result table, for example, `TakeoffID` or `PlanName`. This argument supports aggregation functions.
`Takeoff`	Optional	A search expression for filtering Takeoff values, uses Velixo filtering techniques. Use the STACK.EXPANDTAKEOFFRANGE function to retrieve the list of Takeoffs.
`Plan`	Optional	A search expression for filtering Plan values, uses Velixo filtering techniques. Use the STACK.EXPANDPLANRANGE function to retrieve the list of Takeoffs.
`Tags`	Optional	A search expression for filtering Tag values, uses Velixo filtering techniques. Use the STACK.EXPANDTAGRANGE function to retrieve the list of Tags.
`Labels`	Optional	A search expression for filtering labels, uses Velixo filtering techniques. If not specified, returns all labels. Use the STACK.EXPANDLABELRANGE function to retrieve the list of Labels.
`TableOutputCell`	Optional	If the argument 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 argument is omitted, the result is returned as a spill range.

Example

CODE

=STACK.TAKEOFFREPORT(
  "Stack", 
  "Second Project",
  "TakeoffID, TakeoffName, TakeoffQuantity, TakeoffUnit, PlanName"
)

Description: Returns all takeoff report records in the Second Project project for the connection named Stack, displays columns: TakeoffID, TakeoffName, TakeoffQuantity, TakeoffUnit, PlanName.

Result: