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 128,367,248 false unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type 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 125,483,134 false unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type location multiplier mapping tab use the location multiplier mapping tab to map the multipliers you defined to the charthop locations included in your organization unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type 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 126,435,181 unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type unhandled content type p ackages basic basic | | standard standard | premium available as an add on roles owner | org editor