Skip to main content
Skip table of contents

STACK.TAKEOFFQUANTITY

Introduction

The STACK.TAKEOFFQUANTITY function returns the number of units used in a all Takeoffs that match the filtering criteria within a given project.

Syntax

CODE
=STACK.TAKEOFFQUANTITY(ConnectionName, Project, Takeoff, UnitOfMeasure, Plan, Tags)

Parameters

Parameter

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.

Takeoff

Optional

A search expression for filtering Takeoff values, uses Velixo filtering techniques.
Use the STACK.EXPANDTAKEOFFRANGE function to retrieve the list of STACK takeoffs.

UnitOfMeasure

Optional

A search expression for filtering Unit values, uses Velixo filtering techniques.
Use the STACK.EXPANDUNITRANGE function to retrieve the list of STACK takeoffs.

Plan

Optional

A search expression for filtering Plan values, uses Velixo filtering techniques.
Use the STACK.EXPANDPLANRANGE function to retrieve the list of STACK takeoffs.

Tags

Optional

A search expression for filtering Tag values, uses Velixo filtering techniques.
Use the STACK.EXPANDTAGRANGE function to retrieve the list of STACK takeoffs.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.