Spreadsheet: 198754d1354889451-if-and-vlookup-formula-formula-for-fte
Sheet: Finance

TSA No.
TSA
[NAME] | Role / Job Title | FTE Source | Business Unit Source | Resource Type | Detailed Activity | Variable | Grade | Day Rate (Contractors) | Working Days | Start Date | End Date | # FTE | FTE | Premises | Desktops | Total 2014
 |  |  |  | Permanant |  |  | [NAME] |  |  | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1 | IF E4 = PERMANENT, TAKE GRADE IN COLUMN H, LOOKUP VALUE IN TABLE B35 TO B42 AND MULTIPLY M4
 |  |  |  | Contractor |  |  | [NAME] | 350 | 222 | 2014-01-01 00:00:00 | 2014-12-31 00:00:00 | 1 | IF E5 = CONTRACTOR, TAKE I5 MULTIPLY BY J5, MULTIPLY BY M5
 |  |  |  | Permanant |  |  | [NAME] |  |  |  |  | 0.6
 |  |  |  | Permanant |  |  | [NAME] |  |  |  |  | 1
 |  |  |  | Permanant |  |  | [NAME] |  |  |  |  | 1
 |  |  |  | Permanant |  |  | [NAME] |  |  |  |  | 1
 |  |  |  | Permanant |  |  | [NAME] |  |  |  |  | 1
 |  |  |  | Permanant |  |  | [NAME] |  |  |  |  | 1
 |  |  |  | Permanant |  |  | [NAME] |  |  |  |  | 1
 |  |  |  | Permanant |  |  | [NAME] |  |  |  |  | 1
 |  |  |  | Permanant |  |  | [NAME] |  |  |  |  | 1
 |  |  |  | Permanant |  |  | [NAME] |  |  |  |  | 1
 |  |  |  | Permanant |  |  | [NAME] |  |  |  |  | 1
 |  |  |  | Permanant |  |  | [NAME] |  |  |  |  | 1
 |  |  |  | Permanant |  |  | [NAME] |  |  |  |  | 1
 |  |  |  | Permanant |  |  | Grade EL |  |  |  |  | 1
 |  |  |  | Permanant |  |  | [NAME] |  |  |  |  | 1
 |  |  |  | Permanant |  |  | [NAME] |  |  |  |  | 1
 |  |  |  | Permanant |  |  | [NAME]
 |  |  |  | Permanant |  |  | [NAME]
 |  |  |  | Permanant |  |  | [NAME]
 |  |  |  | Permanant |  |  | [NAME]
 |  |  |  | Permanant |  |  | [NAME]
 |  |  |  | Permanant |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 125971.2 | 74880 | 1733248.017280117
Monthly [NAME] by Grade | 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Property
Grade A | 26168.18080778356 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | £/mth/FTE |  | 2011 | 2012
[NAME] | 29911.21001320669
[NAME] | 39461.46704700917 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | London |  | 756.33 | 808
Grade D | 47071.92407487078 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | North West | Chester | 318.08 | 261
Grade E | 73603.26453609312 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | South West |  | 355.83 | 349.92
[NAME] | 122741.351109 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Edinburgh | Ettrick | 418.25 | 405.3
[NAME] | 179594.543844 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rosyth |  | 464.92 | 347.25
Grade H | 369988.85646 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dunfermline | Pitreavie
Grade SE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | West Yorkshire |  | 237.33 | 241.75