Complete your Bands spreadsheet
Packages: Basic | Standard* | Premium
* Available as an add-on
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. The spreadsheet automatically validates that your values are entered in the right format.
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 |
Target salary percentile | A goal percentile 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. | 70% |
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 Location Multiplier mapping tabs
The Multipliers and the Location Multiplier mapping tabs are available only when you store location information in ChartHop and select to apply location as a multiplier in the compensation bands questionnaire.
These tabs automatically pull in your existing ChartHop locations and allow you to define multipliers for each. You can use the same multiplier for similar locations. For example, locations such as San Francisco and New York may be included in the same multiplier.
Multipliers tab
Use the Multipliers tab to define any multipliers you need.
Column | What it means | Examples |
Multiplier 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 |
Location Multiplier Mapping tab
Use the Location Multiplier 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 available only when you choose 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. |
