Spreadsheet: 169374d1342797842-vlookup-from-a-list-uae-dubai-file-200712-for-forum
Sheet: Payroll Calculatios

 | AED | Job Title | Annual Sallary | Net Salaries for July 2012 | Housing Allowance | Back Pay | Car Allowance | Medical Reimbursement | LOS Award | Life Insurance | Annual Leave | Spot Award | PBP Bonus | Advance | Education Allowance | Maternity Benefit | [NAME] | [NAME] | Advanced Housing Payment | Special Rec Award |  |  |  |  |  |  | Advance Recovery | Housing Allowance | Loan | Other DED |  |  |  |  |  |  |  |  |  |  |  |  | Total funds to transfer in November 10 |  |  |  |  |  |  |  |  |  |  |  |  | Starting Line | BULKCSV | MIL Overseas Limited Dubai | MNY10EFD | LHKO | 20120720 | UAE - Dubai File 200712 for forum.xls | Prod
Todays date | 2012-07-20 00:00:00 | 20120720 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End Line | BULKCSVTRAILER |  | 139714737 |  |  |  |  |  | Second Start Line | RDF | FTX | SALARY TRANSFER
 |  |  |  |  |  | P | P | P | P | P | P | P | P | P | P | P | P | P | P | P |  |  |  |  |  |  | (DED) | (DED) | (DED) | (DED) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Break Line | RDF | FTX | SALARY TRANSFER
Date | 2012-07-26 00:00:00 |  | 2012-07-26 00:00:00
01 | Mohamed | Business Development Manager | 426000 | 35500 | 8583.33 |  |  | 8797 | 879 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8971 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62730.33 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201201 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | Mohamed |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 62730.33 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
02 | Bernardita | Bussiness Development Manager | 252000 | 21000 | 2887.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23887.5 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201202 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | Bernardita |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 23887.5 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
03 | [NAME] | Corridor Manager | 334950 | 27912.5 | 8583.33 | 789 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37284.83 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201203 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | [NAME] |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 37284.83 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
04 | [NAME] | Corridor Manager | 803138.19 | 66928.18 | 220500 |  | 3058.33 |  |  |  |  |  |  |  | 128750 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 419236.51 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201204 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | [NAME] |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 419236.51 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
05 | [NAME] | Director Marketing | 590625 | 49218.75 | 8583.33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57802.08 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201205 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | [NAME] |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 57802.08 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
06 | Maher | Field Opperations Executive | 777600 | 64800 | 11025 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75825 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201206 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | Maher |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 75825 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
07 | Ananth | Field Opperations Executive | 812211.75 | 67684.31 | 11025 | 467 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 79176.31 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201207 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | Ananth |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 79176.31 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
08 | Zainul | Field Opperations Executive | 182484.69 | 15207.06 | 2887.5 |  |  |  |  | 2354 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20448.56 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201208 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | Zainul |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 20448.56 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
09 | [NAME] | Marketing Executive | 991769.625 | 82647.47 | 11025 |  |  |  |  |  | 354 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 94026.47 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201209 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | [NAME] |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 94026.47 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
10 | Aly | Marketing manager | 433026.57 | 36085.55 | 8583.33 |  |  |  |  |  |  | 44 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44712.88 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201210 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | Aly |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 44712.88 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
11 | Mohammad | Office Manager/PA | 256125 | 21343.75 | 5260.83 |  |  |  |  |  |  |  | 34321 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60925.58 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201211 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | Mohammad |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 60925.58 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
12 | [NAME] | Paralegal | 255075 | 21256.25 | 5260.83 |  |  |  |  |  |  |  |  | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26562.08 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201212 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | [NAME] |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 26562.08 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
13 | Sherif | Regional Head of Finance | 174000 | 14500 | 2887.5 |  |  |  |  |  |  |  |  |  | 354 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17741.5 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201213 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | Sherif |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 17741.5 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
14 | [NAME] | Regional HR Director | 636525 | 53043.75 |  |  |  |  |  |  |  |  |  |  |  | 121 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53164.75 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201214 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | [NAME] |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 53164.75 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
15 | Emma | [NAME] Manager | 755250 | 62937.5 | 11025 |  |  |  |  |  |  |  |  |  |  |  | 5435 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 79397.5 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201215 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | Emma |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 79397.5 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
16 | Veronica | Sr Legal Counsel | 277906.875 | 23158.91 | 5010.42 |  |  |  |  |  |  |  |  |  |  |  |  | 241 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28410.33 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201216 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | Veronica |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 28410.33 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
17 | Toni | Sr Mgr - Regional Operations | 1650000 | 137500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 454 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 137954 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201217 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | Toni |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 137954 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
18 | Rawa | Sr. [NAME] | 210000 | 17500 | 5260.83 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 458 |  |  |  |  |  |  |  |  |  | 47 |  |  |  |  |  |  |  |  |  |  |  |  | 23265.83 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201218 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | Rawa |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 23265.83 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
19 | [NAME] | Sr. Regional Director | 174000 | 14500 | 17325 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -17325 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14500 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201219 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | [NAME] |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 14500 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
20 | [NAME] | VP Compliance EMEA & India | 412500 | 34375 | 5263.33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 457 |  |  |  |  |  |  |  |  |  |  |  |  |  | 40095.33 |  |  |  | TRN | SWIFT |  |  | 6008 | 48152011 |  | AED | PAY | C | C |  |  | DXBJUL201220 |  | MIL OVERSEAS LTD |  | 6 WEST WING A613 | DAFZA | DUBAI |  |  | AE | [NAME] |  |  |  | DUBAI |  |  | AE | 20120726 |  | AED | 40095.33 | OUR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REF
 | Total |  | 10405187.7 | 867098.9800000001 | 350977.0600000001 | 1256 | 3058.33 | 8797 | 879 | 2354 | 354 | 44 | 34321 | 45 | 129104 | 121 | 5435 | 241 | 454 | 458 |  |  |  |  |  |  | 8971 | -17325 | 457 | 47 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0 | 0 | 1397147.37
 | 1397147.37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0