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 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 tier the first column represents the top level tier you indicated and is named to match the field you chose in the questionnaire example department second level tier represents the second level tier you indicated and is named to match the field you chose in the questionnaire example information technology third level tier represents the third level tier you indicated and is named to match the field you chose in the questionnaire example job function 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 https //www ifcmarkets com/en/about forex/currencies and abbreviations 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 https //www ifcmarkets com/en/about forex/currencies and abbreviations 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 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 that you defined on the multipliers 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 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 (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 p ackages basic basic | | standard standard | premium available as an add on roles owner | org editor