This workbook calculates the Workforce Measurement Value (Head Count or FTE) of your workforce for each job category, and compares it across various groups such as organization, job, grade, and geography.

Business Questions

How does the total number of employees for different groupings in my organization, broken down, for example, by job category, change over time?

Workbook Parameters

All worksheets in this workbook have the following mandatory parameters:

• Start Date

• End Date

• Organization Hierarchy

• Top Organization

• Rollup Organizations - Yes/No

• Workforce Measurement Type

Use the following parameters to further restrict the values in the workbook:

• Geography Area

• Geography Country

• Geography Region

• Geography Location

• Job Category

• Job

• Grade

• Position

Worksheets

This workbook has the following worksheets, each representing a grouping within your organization:

• By Organization

• By Geography Area

• By Job

• By Grade

• By Position

The worksheets display one row for each grouping. For example, the by Position worksheet displays one row for each position within each job category, and the Grade worksheet displays one row for each grade within each job category.

Headings and Calculations

The matrix reports contain the following columns:

• A grouping column

  The heading depends on the selected worksheet, for example, in the by Grade worksheet, this column is named "Grade".

• Job Category

  The job categories that exist for each worksheet grouping.

• Start

  The workforce total as at the start date entered in the worksheet parameters.

• End

  The workforce total as at the end date entered in the worksheet parameters.

• Change

  The numeric change in the workforce total over the selected time period.

• Change Percent

  The percentage change in the workforce total over the selected time period.

The numeric change in the workforce total is calculated as the difference between the Workforce Measurement Value on the Start Date and the Workforce Measurement Value on the End Date.

The percentage change in the workforce total is calculated as the numeric change in the workforce total divided by the Workforce Measurement Value on the Start Date.

As an example, if the difference between the Workforce Measurement Value on the start date and end date is 10, and the start date workforce Measurement Value is 120, the percentage change in the workforce total is 120/10, making a percentage change of 12%.