How to Create your Compensation Cycle in Pequity!

 

Bringing in Data & Managing Columns

Bring data into the cycle using the Add Employees function, which pulls directly from the People page.

• Run Add Employees again anytime to update columns or sync new hires.

• Choose whether to bring in all employees or only a subset, and deselect columns that don’t belong in the cycle.

• Sync updates from the People page as needed, and remove terminated employees if they no longer apply.

For data that doesn’t live on the People page (like performance ratings), upload it through the Import experience. The system can automatically match columns by employee ID, even if the names differ slightly.

Editing Columns & Display Options

Adjust the layout to fit planning needs:

• Reorder, regroup, or ungroup columns to make navigation easier.

• Stack related fields to save space

• Apply colors to guide planners or align with branding.

Common setup patterns include:

• Merit eligibility rules (e.g., based on hire date).

• Performance ratings as dropdowns, editable by planners or restricted to admins.

• Formulas for salary increases or bonus payouts tied to ratings and targets.

Imports & Naming Conventions

When importing data:

• Map sheet column names to existing cycle columns to avoid duplicates.

• Create new columns if needed, stack them with existing ones, or hide helper fields used only for calculations.

Formulas & Flexibility

Capture proration and multipliers directly in the tool:

• Calculate tenure-based prorations.

• Apply company-wide pool adjustments.

• Use hidden helper columns for clean planner views.

Tooltips & Guidance

Add tooltips to any column to give context or instructions. This reduces questions and keeps everyone aligned.

Layouts & Roles

Control what different audiences see:

• Create layouts (views) tailored to each role.

• Assign layouts so, for example, HR partners can view performance information without compensation details.

• Toggle access to comments or sensitive notes where appropriate.

Waves & Planning Groups

Structure planning phases with waves:

• Waves define when planning happens, while planning groups define who is included.

• Use multiple waves if employees need input from more than one level of leadership.

• Group waves in the workbook to organize divisions or planning depths more clearly.

Ranges & Total Compensation

Decide how ranges and benchmarks are displayed:

• Show low/mid/high or a single benchmark target.

• Use Radford codes or internal structures.

• Calculate total comp in the tool or upload precomputed values.

• Import and stack historical comp data for context.

Commonly Used Formulas

1. STRING(value)

   • Converts a value to a string.

   • Example: STRING(@co_employee_id)

2. CONTAINS(string, substring)

   • Checks if a string contains another substring.

   • Example: CONTAINS(@job_family, "Engineer")

3. RANGELOOKUP(co_dept, co_role, co_geo, co_level, attribute)

   • Looks up compensation range data based on role attributes.

   • Example: RANGELOOKUP(@job_family_group, @job_family, @geo, @level, "co_salary_low"

Logical Functions

• ISBLANK(): Check for missing values

• AND(): Combine multiple conditions

• OR(): Check if any condition is true

• NOT(): Negate a condition

• IF(): Create conditional logic

• IFS(): Check multiple conditions

Mathematical Functions

• MOD(): Calculate remainders

• ROUND(): Round to nearest value

• MROUND(): Round to a multiple

• MROUNDUP(): Round up to a multiple

• MROUNDDOWN(): Round down to a multiple

• AVERAGE(): Calculate averages

Text Functions

• LOWER(): Convert text to lowercase

• UPPER(): Convert text to uppercase

Date Functions

• NETWORKDAYS(): Calculate working days between two dates

• TODAY(): Return the current date

• DAY(): Extract the day from a date

• MONTH(): Extract the month from a date

• YEAR(): Extract the year from a date

• DATE(): Create a date value

Error Handling

• IFERROR(): Gracefully handle errors

Comparison Operators

• > : Greater than

• < : Less than

• >= : Greater than or equal

• <= : Less than or equal

• = : Equal to

• <> : Not equal to

Arithmetic Operators

• + : Addition

• - : Subtraction

• ***** : Multiplication

• / : Division

Important Notes

• All formulas must start with an equals sign (=).

• Use @ to reference fields.

• Functions mirror the behavior of spreadsheet formulas.

• Designed for compensation-specific calculations.