10min

Complete your Bands spreadsheet

After you've completed ChartHop's compensation band wizard, you download a custom spreadsheet to use to input your compensation data according to the parameters you defined.

This topic provides information about how to complete your spreadsheet. Remember that your spreadsheet may not include all of these columns and instead represents the answers you provided in ChartHop's questionnaire.

Each row in your spreadsheet represents a separate compensation band within your organization and can have unique values for that band including whether the band is for hourly or salaried employees, includes equity, and what job level uses the band.

Because ChartHop customizes your compensation bands according to your needs, the spreadsheet you download may not include all columns listed on this page.

After importing your initial compensation band data, you can reference the data in ChartHop through reports, forms, complex filters, and more using the Carrot Query Language or specific Built-in fields.

Structure and Base Pay tab

This tab is included in all spreadsheets although the columns vary according to your choices in the questionnaire.

Column

What it means

Example values

(Top level grouping) Name

The first column represents the top-level grouping you indicated and is named to match the name you chose in the questionnaire.

Example: Division

(Top level grouping) code

Optionally, you can include a code as an identifier for your structure level.

Example: TECH

(Second level grouping) Name

Represents the second-level grouping you indicated and is named to match the name you chose in the questionnaire.

Example: Information Technology

(Second level grouping) code

Optionally, you can include a code as an identifier for your structure level.

Example: IT

(Third level grouping) Name

Represents the third-level grouping you indicated and is named to match the name you chose in the questionnaire.

Example: Job Function

(Third level grouping) code

Optionally, you can include a code as an identifier for your structure level.

Example: FUNC

Pay time period (salary or hourly)

The pay time period for your exempt and/or your non-exempt employees' base pay. 

Salary 

Hourly

Hours per week / Weeks per year

Values used to calculate the annualized equivalents for hourly bands

40 / 52

Band Minimum

The monetary amount that defines the lower bound of the band’s base pay.

Salary example: $130,000 Hourly example: $50

Band maximum

The monetary amount that defines the upper bound of the band’s base pay.

Salary example: $70000 Hourly example: $35

Midpoint

The midpoint value in the band’s range. Will be calculated automatically if the base band’s minimum and maximum are specified. Is required if “percentage spread” is to be used.

Salary example:

$100,000 Hourly example: $42

Percentage spread

The percentage above and below the midpoint that defines the upper and lower bounds of the band. 

 

 

A value of 30% with a midpoint of 100,000 would create a pay range of $70,000-$130,000.

Target salary

A goal value for the band which may be different from the midpoint. Provides guidance to recruiting or finance teams for new hires.

For example, some teams may target the 70th percentile in their band range, rather than the midpoint.

Salary example: $90,000 Hourly example: $40

Job level

The name of the universal job level associated with this band. The name must exactly match job levels listed on the Comparable job levels tab OR the custom job levels you defined on the Job Levels tab.

 

Currency

The currency for the base pay of the given band. Indicate currency using the standard indicators.

Example:

USD

Equity target

The amount of equity for the given band. Leave blank if the band does not have an equity component. You can enter equity in three ways: flat money value, shares, or percentage of base.

100 shares

Variable target

The amount of variable pay for the given band. Leave blank if the band does not have an variable component. You can enter equity in two ways: flat money value or percentage of base.

Flat money value:

$10,000 Percentage of base: 15%

Variable currency

The currency for the variable bonus of the given band. Indicate currency using the standard indicators.

Example: USD

Multipliers and multipliers-location mappings tabs

The Multipliers tab is available only if you store location information in ChartHop and select this option in the questionnaire.

These automatically pull in your existing ChartHop locations and allows you to define multipliers for each. You can use the same multiplier for like locations. For example, San Francisco and New York may be included in the same multiplier.

Multpliers tab

Use the Multipliers tab to define any multipliers you need.

Column

What it means

Examples

Multipler name

The name of the multiplier you want to define. For example, New York and San Francisco may be included in a multiplier called "Max Cost".

Example values: Max Cost US West

Multiplier code

Optionally, you can include a code as an identifier for your multiplier.

Example values: MC USW

Differential value (%)

The amount of the adjustment for the multiplier. Express this as a percentage to multiply by. This column is required for all locations/rows. If there is no multiplier applied to a given location, enter the value as 100.

Example value: 125

Multipliers mapping tab

Use the Multipiers mapping tab to map the multipliers you defined to the ChartHop locations included in your organization.

Column

What it means

ChartHop Locations

The locations in this column are pulled from your ChartHop instance. Do not change these. If you don't want a multiplier for a particular city, you can leave that row blank.

Multiplier

Enter one of the multipliers (not the code) that you defined on the Multlipliers tab. If you don't want a multiplier for a particular city, you can leave that row blank.

Job levels tab

The Job levels tab is only available if you chose to customize your job level names.

When you customize your job level names, you can still map them to industry standard levels. For example, you can choose to have simpler names for your job levels, such as L1, L2, or L3, and map these custom names to an appropriate level within your selected industry standard.

To map custom names to an industry-standard level, fill out the Custom job level column and the Job level code columns (if using) in the Job levels tab, and then choose an industry-standard level to use.

If you didn't choose to map your bands to an industry standard, you just need to create your job level names on this tab. Each row should contain a job level name.

Column

What it means

Examples

Custom job level

The name of your custom job level.

L1

Job level code

Optionally, you can include a code as an identifier for your job level.

L1

(Industry standard level)

This column is either named Radford level or Option Impact level. This column is not included if you chose to create custom job level names without mapping to a standard.

Choose from the pre-populated list of level names.





Updated 29 Jun 2022
Did this page help?
Yes
No