Applies to:

• Velixo NX

• STACK
  
  

Pre-requisites:

• Getting started with Velixo NX
  
  

Overview

The first step after you open Excel is to connect your spreadsheet to STACK Takeoff & Estimate. The add-in adds a new ribbon tab to Excel, titled Velixo NX:

Add a connection

Click the Connection Manager button on the Velixo NX ribbon to open the Connections menu in the side panel. Then click Add. 

Single sign-on

To set up a single sign-on connection for STACK using your credentials, select STACK from the Type drop-down menu and select the Sign in with STACK sign-in method. Enter a unique Name for the connection (you will use this name later as you build formulas).

Upon clicking Connect, you will be presented with a STACK login screen, where you can provide the user email and password for your STACK account.

Remember credentials: This box is checked by default to save your credentials for the connection. Note that login data is not saved within the spreadsheet. Rather, it is saved to your Velixo user profile, which is stored securely in your local Microsoft Office installation.

Once logged in, if you agree to add the listed permissions for Velixo, click Grant (required to enable the connection).

You can add multiple connections with separate credentials to a single workbook. This allows you to easily consolidate data coming from multiple sources.

Partner credentials

If you have STACK Partner credentials, choose the Sign in with partner credentials Sign-in method, provide your STACK Client ID and Client Secret, and click Connect.

Remember credentials: This box is checked by default to save your credentials for the connection. Note that login data is not saved within the spreadsheet. Rather, it is saved to your Velixo user profile, which is stored securely in your local Microsoft Office installation.

Your first report

List all available projects

Let's begin with something simple — listing all projects available for your account.

In the A1 cell, we will use the STACK.EXPANDPROJECTRANGE function. As you start typing, notice that the add-in provides you with information about the function and its parameters: 

The first parameter for the all Velixo functions is the name of the connection as it was defined in the Connection Manager - in this case, Stack.

The second parameter that is required by this function is Project. This parameter is optional, used for filtering (including using Velixo filtering techniques) the results of the query. Let’s skip it for now.

The complete formula should look like this: 

=STACK.EXPANDPROJECTRANGE("Stack") 

Press the Enter key.

Complete list of functions: There are many more STACK functions included in Velixo, and we invite you to explore them all when you complete this tutorial.

Item cost report for a project

Now, you can retrieve an itemized cost report for one of the retrieved projects using the STACK.ITEMCOSTREPORT function.

In another cell, add the STACK.ITEMCOSTREPORT function, enter the connection name Stack as the first parameter, and use the cell with the name of the project for which you would like to generate the report, for example, A2 (alternatively, you can type in the project name – "Second Project").

The complete formula should look like this: 

=STACK.ITEMCOSTREPORT("Stack",A2) 

Press the Enter key.

To retrieve the same data in the form of an Excel table, using the Table Mirroring feature, you can use the TableOutputCell argument to declare the origin cell for the table, for example, C2. This way, the formula should look as follows:

=STACK.ITEMCOSTREPORT("Stack",A2,C2) 

Press the Enter key to run the formula.