### 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=ASIAUPPN5IL3VWZM2N3M%2F20260415%2Fus-east-2%2Fs3%2Faws4_request&X-Amz-Date=20260415T042519Z&X-Amz-Expires=3000&X-Amz-Security-Token=IQoJb3JpZ2luX2VjENT%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLWVhc3QtMiJHMEUCIQCCqzPSSHXKPpTTu8VIWBy7mCmKcA1Wi%2BoTpYO0ysJhBAIgD%2FnxfIQ2iMWP1kwTsC27a2du2PT20ngYmRt7e%2BSlPKwq5gUInf%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARACGgwzMDgxMjU5NzUyODciDG2ZeHjXx6mVUmMU2yq6BUSDf%2BeZZMZLkAhwMRVFVLDd6GzVxu6F43mp8KnN4PjJ5kR4fRk42yoV9F7qdJPCJiJU%2F233amgMGrZ8ZJFQLpKt5%2FhPj7kC3NBMewiPEctqcGdus6u9AQEpXbB%2BajcnrrcRzepF4x8VAVyT%2B5ruZfcwbbHcCMD2azaEulsvfY3F7EXBYPdYMeXu2lG3lsjnkwwpob6cO3%2FA01ufU694P0%2BH6U2cFrJmlWLen%2FSVu%2F3oYtQ2moHdhM6pfGaW9JHUlzuX2jc96V6SMHQuOAL79MWCaqmWrQJj%2FZ%2BwyA1EHLqR2ym2RHsxcAyn%2BnkFzlcEb7X3YiSaUbha%2BlJadZXQmZZT2M3OLUynm3EE5lI%2FPjVVeLIUpX4YWr1MpDDNuSUIRQc3ccd5FNLMzQs93pOgvMcQc23fxXbLf79cCKZ2B%2FzqH4B6mj7DkdA3CgBMx1f3rR2IU8xXltQfrSrKrnIZu%2BvGM5alZX4qoI6%2FNqAlMetx2D9WX%2BmavdT0P4wV6TE%2FUTgCYGOvx8IGNBxyURujZZWJ2QGgic%2BQciwL%2F%2FyzStVX2X1kG0d0%2BNpjzXzR4pVJ%2BWvbv6XLJj%2BwzYCGBidFO5e5siCLCybONNC6qT%2BmY9uN%2BfZ2q4WbovG9d%2FKuiuah%2Bkl7K00pW%2FkBKvdV%2BRhTLoYwxkLZUPFMQ9QRNMjF542UOpVV2R4Q0PorDIvIHUzmwe5M7VU8rg5ExG4YezZdhCk4gu%2BBcKq9rexYekzABLTgKJqIRafdnI9OdWEfdrVWWdzBcw4BNcq%2FpFtNVsgSqvJKnMBergvwkfZb8gXPrqofJzDQQbAgcZ%2B6csN4BtTJLh2rnZftU6rGZyRTbtBJlTRwVdDjtBJNKXEVL%2B36aDC%2FwclwVjmb3N22xnFehs%2Bu7Pjc73g5Jrv7Nu6cJaCXyxeykFJbhZdd7QZ6MOOi%2FM4GOpABJLXQSWbytxXoL%2FvokC4SubFJ5fdVxpPWrjD%2BXH65hw%2B7QyZBBjXbtm7ImiCIQAHKRmifitaLeDQOKLa%2FR0mSa8kIyROAM%2FktWPGeBJJvdtCskiMBuSzKIM4q9IZceZRuvQErYgcaoNC3gtx4DuCs7fjsbSf1e2G3UFnMRx636pje55pwwwTRHi5kRx3clJA4&X-Amz-Signature=62b1f9c65a0374115a4a40d80e1f00d37fd9590338b7f633a3907aefb76e9507&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

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

Band Sets

Employee Distribution in Bands

Editing Bands

View changes

Upload/Download Bands

Unmatched Employees

Managing & Reordering Calculated Columns

How to duplicate band sets

Survey aging

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

Step 2: Benchmarking

Bands Set Audit Log

Manually Create New Band Sets

Job Architecture 101

Pay Zone Manager

Grades

Setting up Company Job Architecture

Company Job Architecture

Step 1: Build Foundation

Generate Bands from Market Data

Bulk & Manually Associate Market Data to Bands

Step 3: Update Ranges

Generate Bands for New Jobs in Your Job Architecture

Compare Bands

Relative Permissions

Advanced Filters

Ongoing Management & Analysis

Market Pricing

Market Data Connections Set up

Market Data Connections Overview

Integrations 101

Integrations

Adding Columns

Team View Overview

Team View Column Configuration

Team View Customizations

Re-ordering Columns

Deleting Columns

Team View Settings

Team View

Comp Planner Configurations Overview

Compensation Planner 101

Getting Started - Compensation Planner

Compensation Planner FAQs

Cycle Specific Permissions

Employee Eligibility

Step 1: Initial Cycle Setup

First-Class Columns

Using Handlebars Formula for Calculated Columns

Columns

Step 2: Column Configuration

OTE Planning Configuration Guide

What is OTE Planning?

Step 3: OTE Planning

Am I able to update or change approval chains during a cycle?

Updating Approval Chains

Compensation Cycle Data Upload

Step 4: Data Management

How can I configure market adjustment recommendations for employees?

How can I configure variable raise recommendations for employees?

Recommendation Logic

What are Recommendations?

Step 5: Recommendation Logic

Budgets

Budget Dashboard

Top Down Budgets: In-app Configurations

Step 6: Budget Confirmation

Planning Windows Setup Guide

Planning Windows Overview

Monthly & Hourly Pay

Employee Compensation History Popout

UI Toggles

Filtering & Sorting

Approval Statuses

Step 7: Planner Experience

Smart Flags

Compensation Outliers

Manager Compression Flag

Vesting Drop Flag

Step 8: Controls & Governance

Peers Overview

Cycle Outcomes

Value Rounding in Compensation Planning

In App Reward Letter Editor

Reward Letters

Peers Configuration Guide

Cycle Progress Dashboard Overview

Other Cycle Actions

 Compensation Planner

Logging In

Custom Role Creation Guide

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

Account Setup

Contact Us

How much does Pave Market Data access cost?

How does Pave Work?

Intro to Pave

Pave 101

Compensation Philosophy

Total Compensation

Compensation 101

The Stock Option Lifecycle

ISO Tax Implications

The Basics of Stock Options

The Confusing AMT (Alternative Minimum Tax)

ISO Strategies

An Overview of How Stock Options Work

Equity 101

Account Creation Troubleshooting and FAQs

How to Benchmark Executive Compensation

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?

What are Job Levels, Departments and Job Families? Why are they important?

Troubleshooting Rippling Zero Records Error

What Market Data Connections does Pave currently support?

FAQs

Getting Started

Option Driver Deprecation FAQs

Option Driver

Option Impact Deprecation FAQs

Option Impact

Option Impact & Option Driver

Executive Reporting Dashboard

Cycle Monitoring and Reporting

Building Market-Based Compensation Bands

Employee Groups

Cycle Configuration

How does Recommendation Logic work?

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

Calculated Columns

Share

Share

Calculated Columns

Share

Share