### How to access these columns

You can turn on these columns in settings to be visible in table view. You will only be able to view calculated columns for which you have pay types configured on the band set, the right permissions to view those columns. Some columns will not populate if you don’t have market data associated with your bands \(see more on Market Pricing [here](/doc/a50d8223-95c1-46c4-8a65-360869c361b1)\).

[https://www.loom.com/embed/f8cc56842047440e896f9eb408ba745b](https://www.loom.com/embed/f8cc56842047440e896f9eb408ba745b)

### What are the columns available to you?

These following columns will only be visible in Column Settings for the specific pay types you have present in your band. Some columns will only be available if you have market data associated with your bands.

**The key info you will see on default in table view and chart view is:**

-   The band visual with your benchmark composite and employee placement
-   The number of benchmarks associated with the band

### Data about the market \(only available with market data\)

-   **Number of benchmarks associated with the band \(visible on default\)**
    -   How many benchmarks were used to create the composite benchmark
-   **Delta from benchmark**
    -   The distance from the band mid to the benchmark

### Data about your bands

-   **Band width**
    -   The % above and below the band mid
-   **Midpoint progression**
    -   The distance from one level’s mid to the next level’s mid
    -   Note: The lowest level in the ladder will not be 0 and will not be shown in the column, given we calculate it as a direct relationship between one level and the next. If you are missing a level in your band structure \(e.g. only have a L1 and L3\) your midpoint progression will reflect the distance from the mid of L1 to the mid of L3, not the mid of L1 to the mid of L2.

### Data about your employees \(for base, total, or variable,if part of your band set\):

-   **Average Compa Ratio**
    -   The average of the compa ratio, which we calculate as pay value / band mid or pay value / \(\(max + min\) / 2\), of the matching employees
-   **Average Range Penetration**
    -   The average of the range penetration, \(payValue - bandMin\) / \(bandMax - bandMin\), of the matching employees
-   **Number of Employees Matching Band**
    -   The number of employees whose HRIS values match the HRIS values of the band
-   **Number of Employees Below Band**
    -   The number of employees on the band whose pay is below the pay type minimum
-   **Number of Employees In Band**
    -   The number of employees on the band whose pay is above the pay type minimum and below the pay type maximum
-   **Number of Employees Above Band**
    -   The number of employees on the band whose pay is above the pay type maximum
-   **Number of Employees Out of Band**
    -   The number of employees on the band whose pay is below the pay type minimum or above the pay type maximum
-   **Total Cost of Band**
    -   The sum of the pay values for each of the matching employees
-   **Cost to Bring Employees Below Band to the Band Minimum**
    -   The cost to increase the pay value up to the band minimum for each of the employees below the band

# How to use these columns

-   You can sort your bands by these columns in Table View to identify problematic bands, such as sorting by delta from benchmark or employees out of band.
    
-   As you make bulk edits to your bands, you’ll see these columns update and be able to view the changes to these columns by clicking “View Changes.”
    
-   **Note**: If you do not initially see these calculated columns populate, click “refresh matches” in the upper right hand corner of the page.
    

![Screenshot 2024-08-23 at 10.49.23 AM.png](https://brainfish-storage-prod.s3-accelerate.amazonaws.com/uploads/634ebdf6-3c6d-407f-94a2-ac567d4f99e3/d8a21731-b6c5-4a96-9e4e-a36e87127501/imported?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=ASIAUPPN5IL3QV7AFKTY%2F20260505%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260505T200018Z&X-Amz-Expires=3000&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEMH%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLWVhc3QtMiJHMEUCIQDhifEUNZxTn4Mi1YS2zoR%2BTstGOgeuxm5YQP5cxxHCpQIgDguFGdik5S%2BqcMfb4HZcu4F5oJ8mmGdhjjanWfQJDdAq5QUIiv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARACGgwzMDgxMjU5NzUyODciDBE5UGRKrbQF%2Bltgkiq5BSToC%2F8e3XY%2BXTPxEDpdTUE1HcF786nR2OqNfrLclktLR%2Fn%2FPdvECLTdJli5fq4vsT4LgqAnxULjSOUV8CePpNCivYB4ERe5S7WjDPGNJsIatO%2F4ubfSdrfzfvV4gBuYp6C0D8qXMrETOuRlFnNXN5y4N5YZzqxXpns1audJ3xco5VU09XKLBVtTfRB9SdXIy7VJDb80E%2BLqsZZ6kP4Q9g%2FkFKp0tQgZsXy8ldeTso52SQkEnflix7%2BrL8kwSCdmZQoGTq7LsLINEdNRet7tkT4CxDCMMTan1PYE%2FG66X5qupVlc%2BEDpOHIW%2FljW8JMOrqjaQKfGOUuvQjIaD9MrwZiz34m8WjNkt8U9UmYazEZTIPyDEUXRK2D2tEYF7U2HR3WbdlmqIvDeitSQDs%2FRgLP47YC%2Bvuf8BaJDo8To5KfUMGJzOZmgfpTKHmqTojtIdv7%2BauDi5w5jJtuyEOoMGtjESqrgrsr9vFkc0SL18Wxjk81ZhZU%2B0Z18%2B%2FUhMiJnaPme7r5D2dsNw%2BJS%2FdY%2FUUhWFfq87KlR4RMG4rMbBbylIvs4knCmdgNIUv2DUmxOptE4dfP6IRIktQ1Y6O8V2W0ZToEncbmrdEpxbHfnNr6KBg%2FcPvU4snBeiJB9PDwRISseJDd500zg%2Bs9%2Ftmcsar5yu9J54%2FV9VAV3x3D6qbhACNiBHq5o4Ide%2BhPlJ2WtfvSXzpjePpvyP8%2BUSyjwxr85lb%2BSJvckdAaD85rPoh1sJta3gnKKlY%2FjZml3C8ZNoVkQG9BJWOq9Gcst4%2BYBlflRz4xHojHAHeisIc59ZWkNkLm46rKEQ2DnosiSeuQEf%2BTvoHb7u5Adog3jNKD8ICGUo16VJS7gs8L7Gmpk2qU0g5eVOpCAyADV%2FJSvjm20Y741hrhY9RMl5m54rVB0i1o%2FcrzKMuWcpNAw7rbozwY6kAHC3EuPgeKx0h44zaXi71YMqr1FK5E6RCKLmAcF%2FKMLAcjqGxHH%2FFokx9SC07bWlmvt6rhfC2JPeZ9PdaaDkEkZJIbC%2B%2FdEvG%2ByjIuS2jDZzKsNuVZ9pCIEhlhPlXk0VJgHPHB2pB2YaXH3uFBdSbmkPyRVOu%2FMLZipJZg5blTVgXFWtskYR%2Fc0za2M43Pm7yY%3D&X-Amz-Signature=89dc1aad25660eca397853d4c8fadc5a75c3cadc2c1ccfc4688373b3d3e9bda6&X-Amz-SignedHeaders=host&response-content-disposition=attachment)

**For more on managing and reordering columns, see [here](https://support.pave.com/hc/en-us/articles/17330039975447).**

\

Calculated Columns

Grades

Setting up Company Job Architecture

Company Job Architecture

Job Architecture 101

Pay Zone Manager

Step 1: Build Foundation

Generate Bands from Market Data

Editing Bands

Bands Set Audit Log

Bulk & Manually Associate Market Data to Bands

Employee Distribution in Bands

How to duplicate band sets

Managing & Reordering Calculated Columns

Unmatched Employees

View changes

Pay Types: Calculated TDC, Annual Equity, and Refresh Equity

Manually Create New Band Sets

Band Sets

Upload/Download Bands

Step 3: Update Ranges

Advanced Filters

Compare Bands

Generate Bands for New Jobs in Your Job Architecture

Relative Permissions

Ongoing Management & Analysis

Edit and apply benchmarks

Set weights and logic

Map data sources to jobs

Supported survey providers

Manage Pave data sources

Manage survey data sources

Benchmarks overview

Survey aging

Step 2: Benchmarking

Market Pricing

Market Data Connections Overview

Market Data Connections Set up

Integrations 101

Integrations

Team View Overview

Team View Column Configuration

Team View Customizations

Re-ordering Columns

Deleting Columns

Adding Columns

Team View Settings

Team View

Configurations overview

Cycle access permissions

Overview

Employee eligibility

Approval chains

Planning windows

Budgets

Recommendation logic

Adding non-integration data to your cycle

Reward letters

Cycle Setup

Columns

OTE planning

Writing formulas with Handlebars

Hourly and monthly pay

Columns and Formulas

Using the planner worksheet

Using the employee detail view

Cycle Progress dashboard

Budgets dashboard

Cycle Outcomes dashboard

Worksheet Experience

Overview of smart features in compensation planning

Peer Comparison

Smart Flags

Priority Sort

Compensation Outliers

Manager Compression Flag

Vesting Drop Flag

Flags and Insights

Compensation Planning

How much does Pave Market Data access cost?

How does Pave Work?

Intro to Pave

Contact Us

Pave 101

Total Compensation

Compensation 101

ISO Tax Implications

The Basics of Stock Options

The Confusing AMT (Alternative Minimum Tax)

ISO Strategies

An Overview of How Stock Options Work

The Stock Option Lifecycle

Equity 101

Login Troubleshooting and FAQ

How does company size affect which department, job family and job level I should choose?

How does Pave determine a role level and role family?

Troubleshooting Rippling Zero Records Error

What Market Data Connections does Pave currently support?

Account Creation Troubleshooting and FAQs

How to Benchmark Executive Compensation

FAQs

Creating an Account

How to add a colleague to Pave’s Market Data Platform

Market Data Role Management

Why does it matter to get levels and role families right?

SSO Configuration Guide

Logging In

Custom Role Creation Guide

Account Setup

Getting Started

Notifications

Multirole Permissions

Standard Pave Permissions

Role Management

Impersonation as a Pave Admin

Auto-manager Assignment

Admin Notification Dashboard

General

How do I know if I’m impersonating someone else?

Can I act on another’s behalf while impersonating them?

Who is able to impersonate?

Who can I impersonate?

How do I impersonate a user?

What is Impersonation?

How can I view Pave as another role?

How do I add multiple users to a role at once?

How can I change the permission settings for a role?

How can I create a new role?

Can a user have more than one role at a time?

Am I able to change another user’s permissions or login credentials while impersonating?

Can I impersonate another user in one page while having other Pave tabs open?

Permissions & Settings FAQs

Account & Permissions

How to Search for a Benchmark

Pave Data and Methodology Guide

Market Data 101

Job Families

Calculated Benchmarks

Compensation Types

Data Collection and Aggregation

Percentiles

Filters

Consistency Labels

Pave's Data

Calculated Benchmarks FAQ

Location and Global Data FAQs

Equity Practices FAQs

Consistency Labels FAQ

Market Data FAQs

Job Levels

Global Location Insights

Advanced Equity

Market Data Pro

Market Data

Understanding Equity in Total Rewards

Display Original Grant Value

Compensation Simulator Configurations

Compensation Simulator Overview

Learning Hub Configuration

Learning Hub Overview

Reward Letters

Accessing your Total Rewards portal

Total Rewards 101

Visual Offer Letters with Workday

Visual Offer Letters with Greenhouse

Visual Offer Letters with Lever

Visual Offer Letter as a Candidate

Previewing Visual Offer Letters

Visual Offer Letters with Ashby

Creating and sending Visual Offer Letters in Pave

Visual Offer Letter 101

Why is my equity different in the equity tab on the left hand side compared to the equity valuation on the graphs?

Why can't I view my own Total Rewards portal?

Total Rewards and Visual Offer Letter FAQ

How can I complete our Greenhouse connection if "API credential management" is not in my Greenhouse menu?

Calculated Columns

Share

Share

Calculated Columns

Share

Share