STACK.TAKEOFFREPORT

Overview

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

CODE

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

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
Takeoff
Plan
Tag
`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.

CODE

=STACK.TAKEOFFREPORT(
    "Stack", 
    "Second Project"
)

Description: Returns all takeoff report records in the Second Project project for the connection named Stack.

Result: