Spreadsheet: 168615d1342525917-which-is-the-best-formula-to-use-book4
Sheet: Synergy by role

 |  |  |  |  |  |  |  | Time of delivery |  |  |  |  |  |  |  |  | MD | Exec
Role | Grade | Family Code | Location | FTE | Business Unit | Category | £ [NAME] | Delivered | 2012-07-07 00:00:00 | 2012-07-07 00:00:00 | 2012-08-07 00:00:00 | 2012-09-07 00:00:00 | 2012-10-07 00:00:00 | 2012-11-07 00:00:00 | 2012-12-07 00:00:00 | Total | H | H | G | F | EU | EL | DU | DL | C | B | A
 |  |  |  |  |  |  |  |  | FTE | £ |  |  |  |  |  |  | 607685 | 349366 | 150043 | 107285 | 73906 |  | 47522 |  | 33529 | 30596 | 25455
 | DU | FID100 |  | 1 | Executive | Vacancy Release | No | 1
 | C | SPC000 |  | 1 | Executive | Vacancy Release | No | 1
 | DU | FID100 |  | 1 | Executive | Vacancy Release | No | 1
 | C | SPC000 |  | 1 | Executive | Vacancy Release | No | 1
 | C | SPC000 |  | 1 | Executive | Vacancy Release | No | 1
 | EU | FIE101 |  | 1 | Executive | Vacancy Release | No | 1
 | DU | FID100 |  | 1 | Executive | Vacancy Release | No | 1
 | DU | FID100 |  | 1 | Executive | Vacancy Release | No | 1
 | DU | FID100 |  | 1 | Executive | Vacancy Release | No | 1
 | C | SPC000 |  | 1 | Executive | Vacancy Release | No | 1
 | C | SPC000 |  | 1 | Executive | Vacancy Release | No | 1
 | F | FIF 000 |  | 1 | Investment | Contractor Release | No | 1
 | EU | FIE101 |  | 1 | Investment | Contractor Release | No | 1
 | EU | FIE101 |  | 1 | Investment | Contractor Release | No | 1
 | EU | FIE101 |  | 1 | Investment | Redeployment/Exit | No | 1
 | EU | FIE101 |  | 1 | Investment | Redeployment/Exit | No | 1
 | EU | FIE101 |  | 1 | Investment | Contractor Release | No | 1
 | EU | FIE101 |  | 1 | Investment | Contractor Release | No | 1 |  |  | TAKE B22 X E22 X V3
 | EU | FIE101 |  | 1 | Property/Sourcing | Contractor Release | Yes |  | 1 | 73906
 | DU | FIE101 |  | 1 | Property/Sourcing | Contractor Release | Yes
 | C | SPC000 |  | 1 | Property/Sourcing | Redeployment/Exit | Yes
 | C | SPC000 |  | 0.9 | Property/Sourcing | Redeployment/Exit | Yes
 | EU | FIE101 |  | 1 | Property/Sourcing | Redeployment/Exit | Yes
 | EU | FIE101 |  | 0.6 | Property/Sourcing | Redeployment/Exit | Yes
 | EU | FIE101 |  | 0.4 | Property/Sourcing | Redeployment/Exit | Yes |  | 0.4
 | EU | FIE101 |  | 0.6 | Property/Sourcing | Redeployment/Exit | Yes
 | C | SPC000 |  | 1 | Operations | Redeployment/Exit | Yes
 | C | SPC000 |  | 1 | Operations | Redeployment/Exit | Yes
 | F | FIF001 |  | 1 | Operations | Redeployment/Exit | Yes
 | DU | FID100 |  | 1 | Operations | Redeployment/Exit | Yes
 | G | FIG000 |  | 1 | Operations | Redeployment/Exit | Yes
 | F | FIF001 |  | 0.6 | Operations | Redeployment/Exit | Yes
 | F | FIF001 |  | 0.6 | Operations | Redeployment/Exit | Yes
 | EU | FIE101 |  | 1 | Operations | Redeployment/Exit | Yes
 | F | FIF001 |  | 1 | Operations | Redeployment/Exit | yes
 | EU | FIE101 |  | 1 | Operations | Redeployment/Exit | yes
 | EU | FIE101 |  | 1 | Operations | Redeployment/Exit | yes
 | G | FIG000 |  | -1 | Operations | Redeployment/Exit | yes
 | DU | FID100 |  | 1 | Operations | Contractor Exits | Yes |  | 1
 | DU | FID100 |  | 1 | Operations | Contractor Exits | Yes |  | 1
 | DU | FID100 |  | 1 | Operations | Contractor Exits | Yes
 | EU | FIE101 |  | 1 | Operations | Redeployment/Exit | Yes
 | EU | FIE101 |  | -1 | Operations | Redeployment/Exit | Yes
 | F | FIF001 |  | -1 | Operations | Redeployment/Exit | Yes
 | DU | FID100 |  | 1 | Operations | Redeployment/Exit | Yes
 | F | FIF001 |  | -1 | Operations | Redeployment/Exit | Yes
 | DU | FID100 |  | 1 | Operations | Redeployment/Exit | Yes
 | EU | FIE101 |  | -1 | Operations | Redeployment/Exit | Yes
 | EL | FIE200 |  | 1 | Operations | Redeployment/Exit | Yes
 | DU | FID100 |  | 1 | Operations | Redeployment/Exit | Yes
 | DU | FID100 |  | 1 | Operations | Redeployment/Exit | Yes
 | C | SPC000 |  | 1 | Operations | Redeployment/Exit | Yes
 | EU | FIE101 |  | 1 | Operations | Redeployment/Exit | Yes
 | DU | FID100 |  | 1 | Operations | Redeployment/Exit | Yes
Totals