Overview of Modeling in Workforce Compensation Plan Worksheets

Let managers and administrators explore scenarios and align their budgets and compensation allocations with organizational pay practices using worksheet models in their workforce compensation plans.

First, you enable the create, update, and apply worksheet actions when you configure worksheet display. Then you set general options and enable model sharing, usage, and allocation methods when you configure modeling. Each method determines the values that managers and administrators can enter in their models, and how the model calculates and applies the results.

For example, you specify whether only administrators or both managers and administrators can access models. You also specify whether managers can create their own models, manage models in the integrated workbook, and how they can share models. For both managers and administrators, you enable model usages that determine how they can apply model results. You can let them apply the results as actual compensation, budget, and target amounts, or a combination of these options.

Numeric Properties

The general properties of numeric columns in models vary depending on where managers and administrators view the model information. For example, model numeric columns on the Model Summary page have properties from the summary table view of the corresponding budget or task worksheet. This includes the Overall Compensation Amount summary component columns. Model numeric columns in the detail table have properties from the detail table of the corresponding budget or task worksheet.