Create a weighting formula

This interactive page will work only if you have enabled JavaScript. Otherwise, you can go to our non-interactive 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 will be following the same steps, in the same order, as outlined on the previous page.

PLEASE READ BEFORE YOU BEGIN:

1. 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".

2. 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.

3. The data you enter from Step 1 is automatically entered for you in the tables as you move down the page.

4. You can go back at any time to change the data you entered. The tables will automatically re-calculate to reflect your changes.

5. 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.

6. You can print your final calculations by using the 'Print' icon on your browser menu bar.