STACK.ESTIMATEWORKSHEET

Created by Velixo Team, Modified on Fri, 29 Aug at 8:34 AM by Velixo Team

Applies to

Introduction

The STACK.ESTIMATEWORKSHEET function returns quantified item costs for a given Estimate Worksheet.

=STACK.ESTIMATEWORKSHEET(ConnectionName, Estimate, Select, Takeoff, Plan, Item, 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.
Takeoff	Optional	A search expression for filtering takeoffs, uses Velixo filtering techniques. If not specified, returns all takeoffs.
Plan	Optional	A search expression for filtering plans, uses Velixo filtering techniques. If not specified, returns all plans.
Item	Optional	A search expression for filtering items, uses Velixo filtering techniques. If not specified, returns all items.
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.