## **Identify problematic bands**

### **Calculated Columns**

You can turn on additional columns about your bands, the market, and your employees and easily sort and filter these columns to identify and analyze problematic bands. Here is a [link to that documentation](https://brainfi30.brainfish.ai/en-us/articles/calculated-columns-4DoLLZj6Tn).

### **Advanced and saved filters**

Use advanced and saved filters to identify problematic bands using filter criteria. You can save filters to easily reference problematic bands over time and share that saved filtered view with others to address those bands. Here is a [link to that documentation. ](https://brainfi30.brainfish.ai/en-us/articles/advanced-filters-s4SC1buzT0)

## **Edit your bands**

**\*These editing features are available for job bands and grade bands\***

Align band values to market data

Align the min/mid/max of your band to the composite benchmark or market data percentiles.

* **If you align the mid to the composite benchmark,** your band mid will update to your chosen composite benchmark, but your min and max will not change. Your band width will be held constant when making this edit.
* **If you align min, mid and/or max to a chosen percentile**, your bands will match to the median of all market data associated with the band at that percentile, regardless of source. Only the percentile options that are associated with the band set will be available in the drop down.
  * You will receive an error if the min > mid, mid > max or max < min or mid.

   ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001klZ&feoid=00NUn00000C06g9&refid=0EMTV00000EnHKb)

   

## **Midpoint Progression**

### **Create a smooth band progression**

After you’ve aligned your band(s) to the market, you may want to keep a smooth progression from one band mid to the next by updating the midpoint progression.

### **What is midpoint progression? Why is it important?**

* It’s the distance from one band mid to the next
* Helps you correct for variability in band midpoints (caused by variability in market data)
* Applies the same progression logic and band width to all bands in the family

### **How do you use midpoint progression?**


1. To create a smooth midpoint progression, you will need to select a single ladder, either by filtering down to one ladder or selecting bands in a single ladder. To adjust the midpoint progression of your bands, select the midpoint progression edit, the pay types and the % midpoint progression you want to use.
    ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001klZ&feoid=00NUn00000C06g9&refid=0EMTV00000EnFfO) 
2. You can choose to use an anchor level or not. If you don’t select an anchor level, the midpoint progression will create a progression from the midpoint of the lowest level in the the ladder (e.g. IC1) to highest level (e.g. IC5). We recommend anchoring your midpoint progression off of the band & market data that you feel most confident in or has the most number of market data points (e.g. SWE - IC3). Then, the midpoint progression of the levels above and below will be based on that anchor band’s midpoint.

   
   **\*if you are missing a level in your band structure (e.g. only have a IC1 and IC3) your midpoint progression will reflect the distance from the mid of IC1 to the mid of IC3, not the mid of IC1 to the mid of IC2\***

## Band width

**Update your band width to ensure even bands**

You can update the min/max of the band while keeping the midpoint constant, either by adding a:

* % above and below the mid
* $ amount from min to max
* Set band width to be Symmetric or Asymmetric

 ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001klZ&feoid=00NUn00000C06g9&refid=0EMTV00000EnHNp)

## **Adjust band values**

**Increase or decrease the bands by a specific % amount**

 ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001klZ&feoid=00NUn00000C06g9&refid=0EMTV00000EnHR3)

## **Snap to pay zone edit**

**Update your bands based on your pay zone differential set up in Pay Zone Manager**

* Select snap to pay zones in the edit tool bar
* Select your pay types and rounding, press preview changes
* The bands that are in pay zones with a differential relationship to another pay zone will update to reflect the differential value. For example:
  * US-1 Pay Zone contains SF and NY
  * US -2 Pay Zone contains Austin and Boston and is 90% of Pay zone 1
  * By selecting “Snap to pay zone value,” your US-2 will will update to be 90% of US-1
* Note:
  * Only bands in pay zones with differential relationships to other bands will be updated
  * If you change the pay zone differential values in Pay Zone Manager, the latest values will be used

## **Round bands**

**Round bands so they are even**


1. Round bands to the nearest 100, 500, etc.
2. By checking constant rounding, bands will be rounded to the selected value after every additional bulk edit.

 ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001klZ&feoid=00NUn00000C06g9&refid=0EMTV00000EnCJL)

 ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001klZ&feoid=00NUn00000C06g9&refid=0EMTV00000EnHXV)


:::info
Note: The bands will be rounded to the nearest selected amount, rather than rounding up or down. For example, if the value is $100,140 and you round to the nearest 100, the number would be updated to $100,100 not $100,200.

:::

Undo

**Undo your most recent edit**


1. Allows you to revert to the values that you had before your most recent edit, including bulk edits and manual edits

Redo

**Redo your undone edit**


1. Allows you to reapply an undone edit, in the same order you undid that edit
2. If you undo and then make a bulk edit, your redo will no longer apply

Delete

**Delete band(s)**


1. If you click delete, the selected bands will be deleted.
2. You can undo the deletion, by clicking “undo”


:::info
Note: For all edits, once they have been saved, you can not return to the previous version of the bands.

:::

## **Analyze & edit your grade bands**

### **Analyze your grade bands**

* From the Market Pricing tool, click a band to drill into that bands data.

   ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001klZ&feoid=00NUn00000C06g9&refid=0EMTV00000EnAas)

   ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001klZ&feoid=00NUn00000C06g9&refid=0EMTV00000EnAqc)
* The Sidepeek tab allows you to select the compensation type at the top of the tab. You will see:
  * Employees matching to the band
  * Employee distribution within the band
  * Average Compa Ratio
  * Average Range Penetration

     

     ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001klZ&feoid=00NUn00000C06g9&refid=0EMTV00000EnHaj)


* In the Band sidepeek benchmarks tab, view the benchmarks for each job, which is weighted by the number of employees in the job. At the bottom of the sidepeek, view the grade composite benchmark of all the market data in the grade.

   ![](https://support.pave.com/servlet/rtaImage?eid=ka0TV0000001klZ&feoid=00NUn00000C06g9&refid=0EMTV00000EnHfZ)
* You can update the job weighting by editing the default weighting.
* In Band Manager, use the calculated columns and advanced filters to identify problematic bands




Editing Bands

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

Band Sets

Employee Distribution in Bands

View changes

Upload/Download Bands

Unmatched Employees

Calculated Columns

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?

Editing Bands

Share

Share

Editing Bands

Share

Share