Spreadsheet: 012d3175-ba77-4bc3-a2a1-c9de9df6f8a8
Sheet: Sheet1

SECURITY OFFICERS - POST HERA | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35 | Unnamed: 36 | Unnamed: 37 | Unnamed: 38 | Unnamed: 39 | Unnamed: 40 | Unnamed: 41 | Unnamed: 42 | Unnamed: 43 | Unnamed: 44 | Unnamed: 45 | Unnamed: 46 | Unnamed: 47 | Unnamed: 48 | Unnamed: 49 | Unnamed: 50 | Unnamed: 51 | Unnamed: 52
[NAME] |  |  |  |  |  |  |  |  | 2006-08-01 00:00:00 |  |  |  |  |  |  |  |  | 2007-02-01 00:00:00 |  |  |  |  |  |  |  |  | 2007-08-01 00:00:00 |  |  |  |  |  |  |  |  | 2008-05-01 00:00:00 |  |  |  |  |  |  |  |  | 2008-10-01 00:00:00
Security Officer |  |  |  | CLERICAL 5 - GRADE 8 |  |  |  |  | Security Officer |  |  |  | CLERICAL 5 - GRADE 8 |  |  |  |  | Security Officer |  |  |  | CLERICAL 5 - GRADE 8 |  |  |  |  | Security Officer |  |  |  | CLERICAL 5 - GRADE 8 |  |  |  |  | Security Officer |  |  |  | CLERICAL 5 - GRADE 8 |  |  |  |  | Security Officer |  |  |  | CLERICAL 5 - GRADE 8
Old Basic | Revised | 3.5 | Basic | 15% shift | Sub | O/T Rate | TOTAL |  | Old Basic | Revised | 3.5 | Basic | 15% shift | Sub | O/T Rate | TOTAL |  | Old Basic | Revised | 3.5 | Basic | 15% shift | Sub | O/T Rate | TOTAL |  | Old Basic | Revised | 3.5 | Basic | 15% shift | Sub | O/T Rate | TOTAL |  | Old Basic | Revised | 3.5 | Basic | 15% shift | Sub | O/T Rate | TOTAL |  | Old Basic | Revised | 3.5 | Basic | 15% shift | Sub | O/T Rate | TOTAL
Rate | Basic | additional | Rate | allowance | Total | 1.75 hrs | SALARY |  | Rate | Basic | additional | Rate | allowance | Total | 1.75 hrs | SALARY |  | Rate | Basic | additional | Rate | allowance | Total | 1.75 hrs | SALARY |  | Rate | Basic | additional | Rate | allowance | Total | 1.75 hrs | SALARY |  | Rate | Basic | additional | Rate | allowance | Total | 1.75 hrs | SALARY |  | Rate | Basic | additional | Rate | allowance | Total | 1.75 hrs | SALARY
36.5hrs | 36.5hrs | hours | 40 hrs |  |  |  | pa |  | 36.5hrs | 36.5hrs | hours | 40 hrs |  |  |  | pa |  | 36.5hrs | 36.5hrs | hours | 40 hrs |  |  |  | pa |  | 36.5hrs | 36.5hrs | hours | 40 hrs |  |  |  | pa |  | 36.5hrs | 36.5hrs | hours | 40 hrs |  |  |  | pa |  | 36.5hrs | 36.5hrs | hours | 40 hrs |  |  |  | pa
£ | £ | £ | £ | £ | £ | £ | £ |  | £ | £ | £ | £ | £ | £ | £ | £ |  | £ | £ | £ | £ | £ | £ | £ | £ |  | £ | £ | £ | £ | £ | £ | £ | £ |  | £ | £ | £ | £ | £ | £ | £ | £ |  | £ | £ | £ | £ | £ | £ | £ | £
19093 | 24161 | 2316.808219178082 | 26477.80821917808 | 3971.671232876712 | 30449.47945205479 | 1158.404109589041 | 31607.88356164384 |  | 24161 | 24886 | 2386.328767123287 | 27272.32876712329 | 4090.849315068493 | 31363.17808219178 | 1193.164383561644 | 32556.34246575342 |  | 24886 | 25135 | 2410.205479452055 | 27545.20547945206 | 4131.780821917808 | 31676.98630136986 | 1205.102739726027 | 32882.08904109589 |  | 25135 | 25889 | 2482.506849315068 | 28371.50684931507 | 4255.72602739726 | 32627.23287671233 | 1241.253424657534 | 33868.48630136986 |  | 25889 | 26665 | 2556.917808219178 | 29221.91780821918 | 4383.287671232877 | 33605.20547945206 | 1278.458904109589 | 34883.66438356165 |  | 26665 | 27332 | 2620.876712328767 | 29952.87671232877 | 4492.931506849315 | 34445.80821917808 | 1310.438356164384 | 35756.24657534247
19622 | 24886 | 2386.328767123287 | 27272.32876712329 | 4090.849315068493 | 31363.17808219178 | 1193.164383561644 | 32556.34246575342 |  | 24886 | 25633 | 2457.958904109589 | 28090.95890410959 | 4213.643835616438 | 32304.60273972603 | 1228.979452054795 | 33533.58219178082 |  | 25633 | 25889 | 2482.506849315068 | 28371.50684931507 | 4255.72602739726 | 32627.23287671233 | 1241.253424657534 | 33868.48630136986 |  | 25889 | 26666 | 2557.013698630137 | 29223.01369863014 | 4383.45205479452 | 33606.46575342466 | 1278.506849315069 | 34884.97260273973 |  | 26666 | 27466 | 2633.72602739726 | 30099.72602739726 | 4514.958904109589 | 34614.68493150685 | 1316.86301369863 | 35931.54794520548 |  | 27466 | 28152 | 2699.506849315068 | 30851.50684931507 | 4627.72602739726 | 35479.23287671233 | 1349.753424657534 | 36828.98630136986
20202 | 25633 | 2457.958904109589 | 28090.95890410959 | 4213.643835616438 | 32304.60273972603 | 1228.979452054795 | 33533.58219178082 |  | 25633 | 26402 | 2531.698630136986 | 28933.69863013699 | 4340.054794520548 | 33273.75342465754 | 1265.849315068493 | 34539.60273972603 |  | 26402 | 26666 | 2557.013698630137 | 29223.01369863014 | 4383.45205479452 | 33606.46575342466 | 1278.506849315069 | 34884.97260273973 |  | 26666 | 27466 | 2633.72602739726 | 30099.72602739726 | 4514.958904109589 | 34614.68493150685 | 1316.86301369863 | 35931.54794520548 |  | 27466 | 28290 | 2712.739726027397 | 31002.7397260274 | 4650.410958904109 | 35653.1506849315 | 1356.369863013699 | 37009.52054794521 |  | 28290 | 28997 | 2780.534246575342 | 31777.53424657534 | 4766.630136986301 | 36544.16438356164 | 1390.267123287671 | 37934.43150684932
20833 | 26401 | 2531.602739726027 | 28932.60273972603 | 4339.890410958904 | 33272.49315068493 | 1265.801369863014 | 34538.29452054795 |  | 26401 | 27193 | 2607.54794520548 | 29800.54794520548 | 4470.082191780822 | 34270.6301369863 | 1303.77397260274 | 35574.40410958904 |  | 27193 | 27465 | 2633.630136986301 | 30098.6301369863 | 4514.794520547945 | 34613.42465753424 | 1316.815068493151 | 35930.23972602739 |  | 27465 | 28289 | 2712.643835616438 | 31001.64383561644 | 4650.246575342465 | 35651.8904109589 | 1356.321917808219 | 37008.21232876712 |  | 28289 | 29138 | 2794.054794520548 | 31932.05479452055 | 4789.808219178082 | 36721.86301369863 | 1397.027397260274 | 38118.89041095891 |  | 29138 | 29866 | 2863.86301369863 | 32729.86301369863 | 4909.479452054795 | 37639.34246575343 | 1431.931506849315 | 39071.27397260274
21415 | 27194 | 2607.643835616438 | 29801.64383561644 | 4470.246575342465 | 34271.8904109589 | 1303.821917808219 | 35575.71232876712 |  | 27194 | 28010 | 2685.890410958904 | 30695.89041095891 | 4604.383561643835 | 35300.27397260274 | 1342.945205479452 | 36643.2191780822 |  | 28010 | 28290 | 2712.739726027397 | 31002.7397260274 | 4650.410958904109 | 35653.1506849315 | 1356.369863013699 | 37009.52054794521 |  | 28290 | 29139 | 2794.150684931507 | 31933.15068493151 | 4789.972602739726 | 36723.12328767123 | 1397.075342465753 | 38120.19863013698 |  | 29139 | 30013 | 2877.958904109589 | 32890.95890410959 | 4933.643835616438 | 37824.60273972603 | 1438.979452054795 | 39263.58219178082 |  | 30013 | 30763 | 2949.876712328767 | 33712.87671232877 | 5056.931506849315 | 38769.80821917808 | 1474.938356164384 | 40244.74657534247
22053 | 28009 | 2685.794520547945 | 30694.79452054794 | 4604.219178082191 | 35299.01369863014 | 1342.897260273973 | 36641.91095890411 |  | 28009 | 28849 | 2766.342465753425 | 31615.34246575342 | 4742.301369863013 | 36357.64383561644 | 1383.171232876712 | 37740.81506849315 |  | 28849 | 29138 | 2794.054794520548 | 31932.05479452055 | 4789.808219178082 | 36721.86301369863 | 1397.027397260274 | 38118.89041095891 |  | 29138 | 30012 | 2877.86301369863 | 32889.86301369863 | 4933.479452054795 | 37823.34246575343 | 1438.931506849315 | 39262.27397260274 |  | 30012 | 30912 | 2964.164383561644 | 33876.16438356164 | 5081.424657534246 | 38957.58904109589 | 1482.082191780822 | 40439.67123287671 |  | 30912 | 31685 | 3038.287671232877 | 34723.28767123288 | 5208.493150684932 | 39931.78082191781 | 1519.143835616439 | 41450.92465753425
 | 28850 | 2766.438356164384 | 31616.43835616438 | 4742.465753424657 | 36358.90410958904 | 1383.219178082192 | 37742.12328767123 |  | 28850 | 29716 | 2849.479452054795 | 32565.47945205479 | 4884.821917808219 | 37450.30136986302 | 1424.739726027397 | 38875.04109589041 |  | 29716 | 30013 | 2877.958904109589 | 32890.95890410959 | 4933.643835616438 | 37824.60273972603 | 1438.979452054795 | 39263.58219178082 |  | 30013 | 30913 | 2964.260273972603 | 33877.2602739726 | 5081.58904109589 | 38958.84931506849 | 1482.130136986301 | 40440.97945205479 |  | 30913 | 31840 | 3053.150684931507 | 34893.1506849315 | 5233.972602739726 | 40127.12328767123 | 1526.575342465753 | 41653.69863013698 |  | 31840 | 32636 | 3129.479452054795 | 35765.47945205479 | 5364.821917808219 | 41130.30136986302 | 1564.739726027397 | 42695.04109589041
22776 | 30607 | 2934.917808219178 | 33541.91780821918 | 5031.287671232877 | 38573.20547945206 | 1467.458904109589 | 40040.66438356165 |  | 30607 | 31525 | 3022.945205479452 | 34547.94520547945 | 5182.191780821918 | 39730.13698630137 | 1511.472602739726 | 41241.60958904109 |  | 31525 | 31840 | 3053.150684931507 | 34893.1506849315 | 5233.972602739726 | 40127.12328767123 | 1526.575342465753 | 41653.69863013698 |  | 31840 | 32795 | 3144.72602739726 | 35939.72602739726 | 5390.958904109589 | 41330.68493150685 | 1572.36301369863 | 42903.04794520548 |  | 32795 | 33780 | 3239.178082191781 | 37019.17808219178 | 5552.876712328766 | 42572.05479452055 | 1619.58904109589 | 44191.64383561644 |  | 33780 | 34624 | 3320.109589041096 | 37944.10958904109 | 5691.616438356164 | 43635.72602739726 | 1660.054794520548 | 45295.7808219178
23499 | 30607 | 2934.917808219178 | 33541.91780821918 | 5031.287671232877 | 38573.20547945206 | 1467.458904109589 | 40040.66438356165 |  | 30607 | 31525 | 3022.945205479452 | 34547.94520547945 | 5182.191780821918 | 39730.13698630137 | 1511.472602739726 | 41241.60958904109 |  | 31525 | 31840 | 3053.150684931507 | 34893.1506849315 | 5233.972602739726 | 40127.12328767123 | 1526.575342465753 | 41653.69863013698 |  | 31840 | 32795 | 3144.72602739726 | 35939.72602739726 | 5390.958904109589 | 41330.68493150685 | 1572.36301369863 | 42903.04794520548 |  | 32795 | 33780 | 3239.178082191781 | 37019.17808219178 | 5552.876712328766 | 42572.05479452055 | 1619.58904109589 | 44191.64383561644 |  | 33780 | 34624 | 3320.109589041096 | 37944.10958904109 | 5691.616438356164 | 43635.72602739726 | 1660.054794520548 | 45295.7808219178
24099 | 30607 | 2934.917808219178 | 33541.91780821918 | 5031.287671232877 | 38573.20547945206 | 1467.458904109589 | 40040.66438356165 |  | 30607 | 31525 | 3022.945205479452 | 34547.94520547945 | 5182.191780821918 | 39730.13698630137 | 1511.472602739726 | 41241.60958904109 |  | 31525 | 31840 | 3053.150684931507 | 34893.1506849315 | 5233.972602739726 | 40127.12328767123 | 1526.575342465753 | 41653.69863013698 |  | 31840 | 32795 | 3144.72602739726 | 35939.72602739726 | 5390.958904109589 | 41330.68493150685 | 1572.36301369863 | 42903.04794520548 |  | 32795 | 33780 | 3239.178082191781 | 37019.17808219178 | 5552.876712328766 | 42572.05479452055 | 1619.58904109589 | 44191.64383561644 |  | 33780 | 34624 | 3320.109589041096 | 37944.10958904109 | 5691.616438356164 | 43635.72602739726 | 1660.054794520548 | 45295.7808219178
 | 31525 | 3022.945205479452 | 34547.94520547945 | 5182.191780821918 | 39730.13698630137 | 1511.472602739726 | 41241.60958904109 |  | 31525 | 32471 | 3113.657534246575 | 35584.65753424657 | 5337.698630136986 | 40922.35616438356 | 1556.828767123288 | 42479.18493150685 |  | 32471 | 32795 | 3144.72602739726 | 35939.72602739726 | 5390.958904109589 | 41330.68493150685 | 1572.36301369863 | 42903.04794520548 |  | 32795 | 33779 | 3239.082191780822 | 37018.08219178082 | 5552.712328767123 | 42570.79452054794 | 1619.541095890411 | 44190.33561643835 |  | 33779 | 34973 | 3353.575342465753 | 38326.57534246575 | 5748.986301369862 | 44075.56164383562 | 1676.787671232877 | 45752.3493150685 |  | 34973 | 35663 | 3419.739726027397 | 39082.7397260274 | 5862.41095890411 | 44945.15068493151 | 1709.869863013699 | 46655.02054794521
 | 32490 | 3115.479452054795 | 35605.47945205479 | 5340.821917808219 | 40946.30136986302 | 1557.739726027397 | 42504.04109589041 |  | 32490 | 33465 | 3208.972602739726 | 36673.97260273973 | 5501.095890410958 | 42175.06849315068 | 1604.486301369863 | 43779.55479452055 |  | 33465 | 33799 | 3241 | 37040 | 5556 | 42596 | 1620.5 | 44216.5 |  | 33799 | 34813 | 3338.232876712329 | 38151.23287671233 | 5722.684931506848 | 43873.91780821917 | 1669.116438356165 | 45543.03424657533 |  | 34813 | 35858 | 3438.438356164384 | 39296.43835616438 | 5894.465753424657 | 45190.90410958904 | 1719.219178082192 | 46910.12328767123 |  | 35858 | 36754 | 3524.356164383562 | 40278.35616438356 | 6041.753424657534 | 46320.10958904109 | 1762.178082191781 | 48082.28767123287
 | 33445 | 3207.054794520548 | 36652.05479452055 | 5497.808219178082 | 42149.86301369863 | 1603.527397260274 | 43753.39041095891 |  | 33445 | 34448 | 3303.232876712329 | 37751.23287671233 | 5662.684931506848 | 43413.91780821917 | 1651.616438356165 | 45065.53424657533 |  | 34448 | 34793 | 3336.315068493151 | 38129.31506849315 | 5719.397260273973 | 43848.71232876713 | 1668.157534246575 | 45516.8698630137 |  | 34793 | 35837 | 3436.424657534247 | 39273.42465753425 | 5891.013698630137 | 45164.43835616438 | 1718.212328767123 | 46882.6506849315 |  | 35837 | 36912 | 3539.506849315068 | 40451.50684931507 | 6067.72602739726 | 46519.23287671233 | 1769.753424657534 | 48288.98630136986 |  | 36912 | 37835 | 3628.013698630137 | 41463.01369863014 | 6219.45205479452 | 47682.46575342466 | 1814.006849315069 | 49496.47260273973
s\job evaluation JB-SM\new salary scales\Security Officers post HERA - current salary scales.xls
12.03.08