Spreadsheet: 67646d1268227002-complex-vlookup-forex
Sheet: 1 June 2009 - REGIONS

Currency | HKD in GBP | USD in GBP | USD in AED | USD in HKD | EUR in GBP | AED in GBP | AED in HKD | AED in EUR | AED in CNY | HKD in CNY | HKD in AED | HKD in EUR | CNY in GBP | SGD in GBP | SGD in AED | SGD in CNY | SGD in USD | SGD in EUR | SGD in HKD
Rate | 12.6986 | 1.63825 | 0.272259 | 0.12901 | 1.15207 | 6.01724 | 0.47385 | 5.22296 | 0.538045 | 1.13548 | 2.11037 | 11.0224 | 11.1835 | 2.35657 | 0.272259 | 0.146488 | 1.422 | 2.0455 | 0.12901
The rates above are the "active rates" used to calculate the rates of UK lawyers on other currency matters
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29
Rank | Status | STANDARD UK | STD Dirhams (AED) | STANDARDAsia Pacific HKD | STD Singapore Dollar (SGD) | UK Lawyer on EURO (UK*Xrate) | UK Lawyer on USD (UK*Xrate) | UK Lawyer on CNY (UK*Xrate) | UK Lawyer on AED Matter | UK Lawyer on HKD Matter | UK Lawyer on SGD Matter | AED Lawyer on UK Matter | AED Lawyer on HKD Matter | AED Lawyer on USD Matter | AED Lawyer on EUR Matter | AED Lawyer on CNY Matter | AED Lawyer on SGD Matter | HKD Lawyer on UK Matter | HKD Lawyer on AED Matter | [NAME] on CNY Matter | HKD Lawyer on USD Matter | [NAME] on EUR Matter | [NAME] on SGD Matter | SGD Lawyer on UK Matter | SGD Lawyer on AED Matter | SGD Lawyer on CNY Matter | SGD Lawyer on USD Matter | SGD Lawyer on EUR Matter | SGD Lawyer on HKD Matter |  |  |  |  |  |  |  |  |  | HK rate | USD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | in GBP's
Rate to be rounded to the nearest: |  |  |  |  | 10 | 5 | 10 | 10 | 10 | 100 | 10 | 5 | 100 | 10 | 5 | 10 | 10 | 5 | 10 | 10 | 10 | 5 | 10 | 5 | 10 | 10 | 10 | 5 | 100 |  |  |  |  |  |  |  |  |  |  | 1.9153
 |  | GBP | AED | HKD | SGD | EUR | USD | CNY | AED | HKD | SGD | GBP | HKD | USD | EUR | CNY | SGD | GBP | AED | CNY | USD | EUR | SGD | GBP | AED | CNY | USD | EUR | HKD
11 | Senior Partner | 200 | 1000 | 3000 | 470 | 230 | 330 | 2240 | 1200 | 2500 | 470 | 165 | 2100 | 270 | 190 | 1860 | 270 | 235 | 1420 | 2640 | 390 | 270 | 390 | 200 | 1730 | 3210 | 330 | 230 | 3600 |  |  |  |  |  |  |  |  |  | 308 | #N/A
13 | Partner | 180 | 900 | 2500 | 420 | 205 | 290 | 2010 | 1080 | 2300 | 420 | 150 | 1900 | 250 | 170 | 1670 | 250 | 195 | 1180 | 2200 | 320 | 225 | 320 | 180 | 1540 | 2870 | 300 | 205 | 3300 |  |  |  |  |  |  |  |  |  | 308 | #N/A
21 | Senior Partner | 200 | 1000 | 3000 | 470 | 230 | 330 | 2240 | 1200 | 2500 | 470 | 165 | 2100 | 270 | 190 | 1860 | 270 | 235 | 1420 | 2640 | 390 | 270 | 390 | 200 | 1730 | 3210 | 330 | 230 | 3600 |  |  |  |  |  |  |  |  |  | 308 | #N/A
23 | Partner | 180 | 900 | 2500 | 420 | 205 | 290 | 2010 | 1080 | 2300 | 420 | 150 | 1900 | 250 | 170 | 1670 | 250 | 195 | 1180 | 2200 | 320 | 225 | 320 | 180 | 1540 | 2870 | 300 | 205 | 3300 |  |  |  |  |  |  |  |  |  | 308 | #N/A
25 | Consultant | 0 | 750 | 3000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 125 | 1600 | 200 | 145 | 1390 | 200 | 235 | 1420 | 2640 | 390 | 270 | 390 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | 235 | #N/A
26 | Consultant (non-Lawyer) | 0 | 750 | 3000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 125 | 1600 | 200 | 145 | 1390 | 200 | 235 | 1420 | 2640 | 390 | 270 | 390 | 0 | 0 | 0 | 0 | 0 | 0
28 | Legal Director (Senior) | 200 | 1000 | 3000 | 470 | 230 | 330 | 2240 | 1200 | 2500 | 470 | 165 | 2100 | 270 | 190 | 1860 | 270 | 235 | 1420 | 2640 | 390 | 270 | 390 | 200 | 1730 | 3210 | 330 | 230 | 3600
29 | Legal Director | 170 | 900 | 2500 | 400 | 195 | 280 | 1900 | 1020 | 2200 | 400 | 150 | 1900 | 250 | 170 | 1670 | 250 | 195 | 1180 | 2200 | 320 | 225 | 320 | 170 | 1470 | 2730 | 280 | 195 | 3100
32 | Senior Associate | 150 | 800 | 2200 | 350 | 175 | 250 | 1680 | 900 | 1900 | 350 | 135 | 1700 | 220 | 155 | 1490 | 220 | 175 | 1040 | 1940 | 280 | 200 | 280 | 150 | 1290 | 2390 | 250 | 170 | 2700 |  |  |  |  |  |  |  |  |  | 235 | #N/A
33 | Associate | 130 | 750 | 2000 | 310 | 150 | 210 | 1450 | 780 | 1700 | 310 | 125 | 1600 | 200 | 145 | 1390 | 200 | 155 | 950 | 1760 | 260 | 180 | 260 | 130 | 1140 | 2120 | 220 | 150 | 2400 |  |  |  |  |  |  |  |  |  | 183 (H) 132 (S) | #N/A
41 | Senior [NAME] | 110 | 500 | 1500 | 260 | 125 | 180 | 1230 | 660 | 1400 | 260 | 85 | 1100 | 140 | 95 | 930 | 140 | 120 | 710 | 1320 | 190 | 135 | 190 | 110 | 950 | 1770 | 180 | 125 | 2000 |  |  |  |  |  |  |  |  |  | 183 | #N/A
56 | Senior [NAME] | 110 | 500 | 1500 | 260 | 125 | 180 | 1230 | 660 | 1400 | 260 | 85 | 1100 | 140 | 95 | 930 | 140 | 120 | 710 | 1320 | 190 | 135 | 190 | 110 | 950 | 1770 | 180 | 125 | 2000 |  |  |  |  |  |  |  |  |  | 183 | #N/A
61 | Senior [NAME] | 100 | 500 | 1500 | 240 | 115 | 160 | 1120 | 600 | 1300 | 240 | 85 | 1100 | 140 | 95 | 930 | 140 | 120 | 710 | 1320 | 190 | 135 | 190 | 100 | 880 | 1640 | 170 | 115 | 1900 |  |  |  |  |  |  |  |  |  | 183 | #N/A
66 | Junior Lawyer | 90 | 450 | 1200 | 210 | 105 | 150 | 1010 | 540 | 1100 | 210 | 75 | 900 | 120 | 85 | 840 | 120 | 95 | 570 | 1060 | 150 | 110 | 150 | 90 | 770 | 1430 | 150 | 105 | 1600 |  |  |  |  |  |  |  |  |  | 147 (H) 88 (S) | #N/A
71 | Junior Lawyer | 80 | 450 | 1200 | 190 | 90 | 130 | 890 | 480 | 1000 | 190 | 75 | 900 | 120 | 85 | 840 | 120 | 95 | 570 | 1060 | 150 | 110 | 150 | 80 | 700 | 1300 | 130 | 95 | 1500 |  |  |  |  |  |  |  |  |  | 147 | #N/A
80 | Trainee | 70 | 400 | 800 | 160 | 80 | 110 | 780 | 420 | 900 | 160 | 65 | 800 | 110 | 75 | 740 | 110 | 65 | 380 | 700 | 100 | 75 | 100 | 70 | 590 | 1090 | 110 | 80 | 1200 |  |  |  |  |  |  |  |  |  |  | #N/A
82 | Trainee | 65 | 375 | 800 | 150 | 75 | 110 | 730 | 390 | 800 | 150 | 60 | 800 | 100 | 70 | 700 | 100 | 65 | 380 | 700 | 100 | 75 | 100 | 65 | 550 | 1020 | 110 | 75 | 1200 |  |  |  |  |  |  |  |  |  |  | #N/A
84 | Trainee | 60 | 350 | 600 | 140 | 70 | 100 | 670 | 360 | 800 | 140 | 60 | 700 | 100 | 65 | 650 | 100 | 45 | 280 | 530 | 80 | 55 | 80 | 60 | 510 | 960 | 100 | 70 | 1100 |  |  |  |  |  |  |  |  |  |  | #N/A
86 | Trainee | 55 | 325 | 600 | 130 | 65 | 90 | 620 | 330 | 700 | 130 | 55 | 700 | 90 | 60 | 600 | 90 | 45 | 280 | 530 | 80 | 55 | 80 | 55 | 480 | 890 | 90 | 65 | 1000 |  |  |  |  |  |  |  |  |  |  | #N/A
90 | Paralegal 1 | 50 | 300 |  | 120 | 60 | 80 | 560 | 300 | 600 | 120 | 50 | 600 | 80 | 55 | 560 | 80 | 0 | 0 | 0 | 0 | 0 | 0 | 50 | 440 | 820 | 80 | 60 | 900 |  |  |  |  |  |  |  |  |  |  | #N/A
91 | [NAME] | 45 | 275 |  | 110 | 50 | 70 | 500 | 270 | 600 | 110 | 45 | 600 | 70 | 55 | 510 | 70 | 0 | 0 | 0 | 0 | 0 | 0 | 45 | 400 | 750 | 80 | 55 | 900 |  |  |  |  |  |  |  |  |  |  | #N/A
92 | Paralegal 3 | 40 | 250 | 450 | 90 | 45 | 70 | 450 | 240 | 500 | 90 | 40 | 500 | 70 | 50 | 460 | 70 | 35 | 210 | 400 | 60 | 40 | 60 | 40 | 330 | 610 | 60 | 45 | 700 |  |  |  |  |  |  |  |  |  |  | #N/A
93 | [NAME] | 35 | 225 | 450 | 80 | 40 | 60 | 390 | 210 | 400 | 80 | 35 | 500 | 60 | 45 | 420 | 60 | 35 | 210 | 400 | 60 | 40 | 60 | 35 | 290 | 550 | 60 | 40 | 600 |  |  |  |  |  |  |  |  |  |  | #N/A
94 | [NAME] | 30 | 200 | 450 | 70 | 35 | 50 | 340 | 180 | 400 | 70 | 35 | 400 | 50 | 40 | 370 | 50 | 35 | 210 | 400 | 60 | 40 | 60 | 30 | 260 | 480 | 50 | 35 | 500 |  |  |  |  |  |  |  |  |  |  | #N/A
95 | [NAME] 6 | 25 | 175 | 450 | 60 | 30 | 40 | 280 | 150 | 300 | 60 | 30 | 400 | 50 | 35 | 330 | 50 | 35 | 210 | 400 | 60 | 40 | 60 | 25 | 220 | 410 | 40 | 30 | 500 |  |  |  |  |  |  |  |  |  |  | #N/A
96 | [NAME] | 20 | 150 | 450 | 50 | 25 | 30 | 220 | 120 | 300 | 50 | 25 | 300 | 40 | 30 | 280 | 40 | 35 | 210 | 400 | 60 | 40 | 60 | 20 | 180 | 340 | 40 | 25 | 400 |  |  |  |  |  |  |  |  |  |  | #N/A
97 | [NAME] 8 | 15 | 125 | 450 | 40 | 15 | 20 | 170 | 90 | 200 | 40 | 20 | 300 | 30 | 25 | 230 | 30 | 35 | 210 | 400 | 60 | 40 | 60 | 15 | 150 | 270 | 30 | 20 | 300 |  |  |  |  |  |  |  |  |  |  | #N/A
98 | Paralegal 9 | 10 | 100 | 450 | 20 | 10 | 20 | 110 | 60 | 100 | 20 | 15 | 200 | 30 | 20 | 190 | 30 | 35 | 210 | 400 | 60 | 40 | 60 | 10 | 70 | 140 | 10 | 10 | 200
101 | Legal Executive - Fellow |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | #N/A
102 | Legal Executive - Fellow |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
103 | Legal Executive - Fellow |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
104 | Legal Executive - Member |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
105 | Legal Executive - Member |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
106 | Legal Executive - Member |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
107 | Legal Executive - Trainee |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
110 | Barrister | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | #N/A
115 | [NAME] | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
116 | Accountant | 100 |  |  | 240 | 115 | 160 | 1120 | 600 | 1300 | 240 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 880 | 1640 | 170 | 115 | 1900 |  |  |  |  |  |  |  |  |  |  | #N/A
120 | Law Costs Consultant | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | #N/A
121 | Costs Draughtsman | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  | #N/A
125 | Pensions Trustee Manager | 100 |  |  | 240 | 115 | 160 | 1120 | 600 | 1300 | 240 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 880 | 1640 | 170 | 115 | 1900
126 | Senior Legal Executive Consultant | 200 |  |  | 470 | 230 | 330 | 2240 | 1200 | 2500 | 470 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 200 | 1730 | 3210 | 330 | 230 | 3600
127 | Licenced Conveyancer | 120 |  |  | 280 | 140 | 200 | 1340 | 720 | 1500 | 280 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 120 | 1030 | 1910 | 200 | 135 | 2200
128 | Trade Mark Attorney | 100 |  |  | 240 | 115 | 160 | 1120 | 600 | 1300 | 240 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100 | 880 | 1640 | 170 | 115 | 1900
130 | Public Sector Pensions Head | 120 |  |  | 280 | 140 | 200 | 1340 | 720 | 1500 | 280 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 120 | 1030 | 1910 | 200 | 135 | 2200
131 | Pensions Executive | 110 |  |  | 260 | 125 | 180 | 1230 | 660 | 1400 | 260 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 110 | 950 | 1770 | 180 | 125 | 2000