TOOL:
Create a Weighting Formula /
11 subfactors
Create a Weighting Formula /
11 subfactors
This interactive page will work only if you have enabled JavaScript. Otherwise, you can print out the blank worksheet provided in the Space Toy Co. case study, and fill in the form manually.
The interactive worksheet below is made up of tables. By entering data in the cells of each table on this page, you will produce a weighting formula with subfactor and level calculations. You will be following the same steps, in the same order, as outlined in this example from the Space Toy Co. case study.
This page contains tables with the 4 factors required by the Act and 11 subfactors typically found in many job evaluation systems. Your own subfactors could be similar or different.
PLEASE READ BEFORE YOU BEGIN:
-
At Steps 1 and 2, you enter numbers in the cells: for example, 35 in the cell to the right of "Skill", or 15 in the cell to the right of "Knowledge".
-
At Step 3, you click a button corresponding to the number of levels you want for each subfactor: for example, if you want 5 levels for "Knowledge", you click in the cell on that row in column 5. Each step is explained as you move down the page.
-
The data you enter from Step 1 is automatically entered for you in the tables as you move down the page.
-
You can go back at any time to change the data you entered. The tables will automatically re-calculate to reflect your changes. Just reset the tables and begin again.
The total value of this formula is 100 % / 1000 points. You cannot enter percentages that add to more than this amount. To make sure you don't exceed 100%, check the " Remaining out of 100% / 1000 points " balance at the bottom of the table. Your final calculation is correct when this line shows 0 (zero). If this line shows a negative amount, you have gone over the 100% allotment.
-
Printing: You can't save your final results to your hard drive, but you can print your calculations by using the 'Print' icon on your browser menu bar.
-
Record-keeping: For your convenience, we've provided space at the end of this exercise if you wish to record the name of a person inputting the data, a project title, and the date you created your calculation.
-
Exiting this page: When you exit this page, the information you entered will be erased and the tables will be reset.
Record-keeping
* Optional: Enter a person's name, project name and/or date for record-keeping.
Name*:
Project*:
Date*:
Print your calculations by using the 'Print' icon on your browser menu bar.
More information
You can find more information about job evaluation systems by viewing these publications or web pages:
- see how the Space Toy Co. approached the job evaluation process;
- review some basics on designing a formula for a job evaluation system;
- examine the step-by-step process of creating a weighting formula by viewing this sample.
How do I get more help or information?
We are here to help. We can answer your questions by e-mail at pecinfo.pecinfo@ontario.ca or by phone at (416) 314-1896, or toll-free at 1-800-387-8813. You can also register for a free seminar.
All communications are confidential.
The Pay Equity Commission
This fact sheet is for information only, and is not intended to restrict Review Officers or the Pay Equity Hearings Tribunal in their determination of matters. Refer to the Pay Equity Act for exact interpretation.
