Create a weighting formula

This interactive page will work only if you have enabled JavaScript. Otherwise, you can go to our blank worksheet, print it , 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 can review these steps you're about to follow by reading the example in the Space Toy Co. case study.

This page contains tables with the 4 factors required by the Act and 10 subfactors commonly found in job evaluation systems. Your own choice of 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.
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.
You can print your final calculations by using the 'Print' icon on your browser menu bar.

Step 1 - Factor Formula

Divide 100% between the factors of Skill, Effort, Responsibility and Working Conditions.

Click in each cell in the Percentages column to enter your choices (for example, 35 for Skill). Corresponding points will immediately show in the Points column (for example, 350 points for Skill). You now have 65% left to work with, as shown in the " Remaining out of 100% / 1000 points " cell at the bottom of this table. Make sure the balance remaining is 0 (zero) before you move on to Step #2.

Factor Formula (100% divided between 4 factors)

Factors	Percentages	Points
Skill	%
Effort	%
Responsibility	%
Working Conditions	%
Total Value for the System	%

( Remaining out of 100% / 1000 pts )

Step 2 - Subfactor Formula

Divide 100% between the 10 subfactors.

The percentages you've entered above now show in this table. Again, using the Percentages column, click in each cell on each subfactor line and enter a number. Corresponding points will immediately show in the Points column. Make sure your "Remaining out of 100% / 1000 points" balance is 0 (zero) before you move on to Step #3.

Subfactor Formula (100% divided between 10 subfactors)

Factors and Subfactors

Percentages

Points

Skill	%
Knowledge	%
Interpersonal skills/ Contacts	%
Problem-solving/ Judgement	%

( Remaining out of 100% / 1000 pts )

Effort	%
Mental Effort	%
Physical Effort	%

( Remaining out of 100% / 1000 pts )

Responsibility	%
Personnel, Policies and Practices	%
Information Resources	%
Financial Resources	%
Material Resources	%

( Remaining out of 100% / 1000 pts )

Working Conditions	%
Environment	%

( Remaining out of 100% / 1000 pts )

Total value for the system

Step 3 - Levels Formula

Determine the number of levels for each subfactor.

The percentages you've entered above now appear in the Weights and Points columns in the table below. As a final step to creating your formula, you will choose the number of levels you want for each subfactor by clicking in the cell corresponding to the chosen level. For example, if you want 5 levels for Knowledge, you click in the cell below Level 5 on that subfactor line. The correct number of points for that level shows immediately.

Levels Formula (percentages divided between the levels)

Skill (divided between three subfactors)
Subfactors	Weight	Points	Points for Levels
			1	2	3	4	5	6
Knowledge	%
Interpersonal Skills/ Contacts	%
Problem-Solving/ Judgement	%

Effort (divided between two subfactors)
Subfactors	Weight	Points	Points for Levels
			1	2	3	4	5	6
Mental Effort	%
Physical Effort	%

Responsibility (divided between four subfactors)
Subfactors	Weight	Points	Points for Levels
			1	2	3	4	5	6
Personnel/ Policies/ Practices	%
Information Resources	%
Financial Resources	%
Material Resources	%

Working Conditions (applied to one subfactor)
Subfactors	Weight	Points	Points for Levels
			1	2	3	4	5	6
Environment	%

You now have a weighting formula. The above worksheet does not provide the space to calculate the " + " or " - " factor, but you can refer to the previous page to review how this is done. You can print your final calculations by using the "Print" icon on your browser menu bar.

Last modified: April 7, 2008