Spreadsheet: 126299d1319624249-issue-with-setting-up-a-formula-with-more-than-one-condition-ge-report-august-2011-final-test
Sheet: Reporting Template

Outside Counsel Fees - 01 January - 31 August 2011 |  |  |  |  |  | 1 | Commercial Finance | 0
Business: | GE Commercial Finance
 |  |  | £ Amount
Country | Matter Name | Law Firm | Redundancies | Negotiated Terminations | Individual L&E Litgation | Works Council and/or Union Applications | Special Projects* | General Day to Day Advice
UK | Various | Simmons & Simmons |  | 0 | 0 | 0 | 0 | 0
Germany | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 255.9
Spain | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 20486.54
Italy | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
France | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
Holland | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
 |  | Sub totals | 0 | 0 | 0 | 0 | 0 | 20742.44
 |  | Business total (£) | 20742.44
* Special Projects including cross border work e.g. data privacy/working time
Business: | GE Consumer Finance
 |  |  | £ Amount
Country | Matter Name | Law Firm | Redundancies | Negotiated Terminations | Individual L&E Litgation | Works Council and/or Union Applications | Special Projects* | General Day to Day Advice
UK | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
Germany | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 6264.89
Spain | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
Italy | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
France | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
Holland | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
 |  | Sub totals | 0 | 0 | 0 | 0 | 0 | 6264.89
 |  | Business total (£) | 6264.89
* Special Projects including cross border work e.g. data privacy/working time
Business: | GE Corporate
 |  |  | £ Amount
Country | Matter Name | Law Firm | Redundancies | Negotiated Terminations | Individual L&E Litgation | Works Council and/or Union Applications | Special Projects* | General Day to Day Advice
UK | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
Germany | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 881.29 | 26761.45
Spain | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
Italy | Various | Simmons & Simmons | 0 | 14021.59 | 0 | 0 | 0 | 0
France | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
Holland | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
 |  | Sub totals | 0 | 14021.59 | 0 | 0 | 881.29 | 26761.45
 |  | Business total (£) | 41664.33
* Special Projects including cross border work e.g. data privacy/working time
Business: | GE Healthcare
 |  |  | £ Amount
Country | Matter Name | Law Firm | Redundancies | Negotiated Terminations | Individual L&E Litgation | Works Council and/or Union Applications | Special Projects* | General Day to Day Advice
UK | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
Germany | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
Spain | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
Italy | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
France | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
Holland | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
 |  | Sub totals | 0 | 0 | 0 | 0 | 0 | 0
 |  | Business total (£) | 0
* Special Projects including cross border work e.g. data privacy/working time
Business: | GE Industrial
 |  |  | £ Amount
Country | Matter Name | Law Firm | Redundancies | Negotiated Terminations | Individual L&E Litgation | Works Council and/or Union Applications | Special Projects* | General Day to Day Advice
UK | Various | Simmons & Simmons | 0 | 8861.4 | 0 | 0 | 0 | 12947.57
Germany | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 33744.92
Spain | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 20486.54
Italy | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
France | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 5356.75
Holland | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
 |  | Sub totals | 0 | 8861.4 | 0 | 0 | 0 | 72535.78
 |  | Business total (£) | 81397.18
* Special Projects including cross border work e.g. data privacy/working time
Business: | GE Infrastructure
 |  |  | £ Amount
Country | Matter Name | Law Firm | Redundancies | Negotiated Terminations | Individual L&E Litgation | Works Council and/or Union Applications | Special Projects* | General Day to Day Advice
UK | Various | Simmons & Simmons | 14068.52 | 21911.72 | 0 | 0 | 0 | 125
Germany | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
Spain | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
Italy | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
France | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
Holland | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
 |  | Sub totals | 14068.52 | 21911.72 | 0 | 0 | 0 | 125
 |  | Business total (£) | 36105.24000000001
* Special Projects including cross border work e.g. data privacy/working time
Business: | NBC Universal
 |  |  | £ Amount
Country | Matter Name | Law Firm | Redundancies | Negotiated Terminations | Individual L&E Litgation | Works Council and/or Union Applications | Special Projects* | General Day to Day Advice
UK | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
Germany | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 535.64
Spain | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 0
Italy | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 890.05
France | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 6936.349999999999
Holland | Various | Simmons & Simmons | 0 | 0 | 0 | 0 | 0 | 30169.59
 |  | Sub totals | 0 | 0 | 0 | 0 | 0 | 38531.63
 |  | Business total (£) | 38531.63
 |  | OVERALL TOTAL | 224705.71
* Special Projects including cross border work e.g. data privacy/working time