-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Error: Cannot group on Fields selected with '*'.
- Thread starter pedie
- Start date
xenou
MrExcel MVP
- Joined
- Mar 2, 2007
- Messages
- 16,836
- Office Version
- 2019
- Platform
- Windows
Each time you run the query it will use the current data in your database - so yes, it's like excel in that it will change automatically, but unlike Excel in that there is no "calculation" settings like manual or automatic, and you won't see the query changing -- you have to actually run the query again.
Upvote
0
Excel Facts
Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
xenou
MrExcel MVP
- Joined
- Mar 2, 2007
- Messages
- 16,836
- Office Version
- 2019
- Platform
- Windows
Online this seems useful (some simple, interactive queries you can start writing with immediate results):
http://www.w3schools.com/sql/default.asp
I don't know of many good sites, really - my advice is a class on databases 101. I also read a few books which is a good way to get structured material that's organized and explained. Some recommended titles are:
Database Design for Mere Mortals by Michael Hernandez
SQL Queries for Mere Mortals by Michael Hernandez
Learning SQL by Alan Beaulieu
Teach yourself SQL in 10 Minutes by Ben Forta
Learning to create databases is something you have to work at and invest some time in. It's not something you just pick up (unlike Excel, which you *can* get away with using even if you haven't been properly taught).
http://www.w3schools.com/sql/default.asp
I don't know of many good sites, really - my advice is a class on databases 101. I also read a few books which is a good way to get structured material that's organized and explained. Some recommended titles are:
Database Design for Mere Mortals by Michael Hernandez
SQL Queries for Mere Mortals by Michael Hernandez
Learning SQL by Alan Beaulieu
Teach yourself SQL in 10 Minutes by Ben Forta
Learning to create databases is something you have to work at and invest some time in. It's not something you just pick up (unlike Excel, which you *can* get away with using even if you haven't been properly taught).
Upvote
0
pedie
Well-known Member
- Joined
- Apr 28, 2010
- Messages
- 3,875
Xen, thank again for helping....and for the link and advice...
This lead to one more question....
How suppose my query calc. table is open, how can i refresh the query or re calculate with different critirias which is link to my form control?
I want to to recalc. to everytime i hit run button after selecting my critirias...
This lead to one more question....
How suppose my query calc. table is open, how can i refresh the query or re calculate with different critirias which is link to my form control?
I want to to recalc. to everytime i hit run button after selecting my critirias...
Upvote
0
Norie
Well-known Member
- Joined
- Apr 28, 2004
- Messages
- 76,377
- Office Version
- 365
- Platform
- Windows
Pedie
What overall result are you trying to get?
What are you going to do with all the sums for all the criteria?
Anything, or do you just want a single result from each query?
Could you post some sample data?
What overall result are you trying to get?
What are you going to do with all the sums for all the criteria?
Anything, or do you just want a single result from each query?
Could you post some sample data?
Upvote
0
pedie
Well-known Member
- Joined
- Apr 28, 2010
- Messages
- 3,875
Hi again Norie....
What i'm trying to calc. data looks like the one below: 'm home and hence no real data...
I want to have data ready drilled down for every REGIONAL MANAGER, and then MANAGER location/site wise for each quarter...
I want to be able to easily run report or queries and send accross emails etc...
Thanks again soo very much!
And also please tell me if there is a way to re-query or re-run my query which is already run a sec ago...
<TABLE style="WIDTH: 453pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=602><COLGROUP><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1536" width=42><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340" width=64><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1865" width=51><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1828" width=50><COL style="WIDTH: 36pt; mso-width-source: userset; mso-width-alt: 1755" width=48><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2267" width=62><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340" width=64><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2560" width=70><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #4f81bd; WIDTH: 32pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl63 height=19 width=42>
What i'm trying to calc. data looks like the one below: 'm home and hence no real data...
I want to have data ready drilled down for every REGIONAL MANAGER, and then MANAGER location/site wise for each quarter...
I want to be able to easily run report or queries and send accross emails etc...
Thanks again soo very much!
And also please tell me if there is a way to re-query or re-run my query which is already run a sec ago...
<TABLE style="WIDTH: 453pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=602><COLGROUP><COL style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1536" width=42><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340" width=64><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1865" width=51><COL style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1828" width=50><COL style="WIDTH: 36pt; mso-width-source: userset; mso-width-alt: 1755" width=48><COL style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 2267" width=62><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340" width=64><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2560" width=70><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><TBODY><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #4f81bd; WIDTH: 32pt; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl63 height=19 width=42>
RM_IDS
</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #4f81bd; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl63 width=64>REGION_
MANAGER
</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #4f81bd; WIDTH: 38pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl63 width=51>MANAGER
MNG_ID
</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #4f81bd; WIDTH: 38pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl63 width=50>MANAGER
</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #4f81bd; WIDTH: 36pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl63 width=48>SITE
</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #4f81bd; WIDTH: 47pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl63 width=62>YEAR1
</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #4f81bd; WIDTH: 48pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl63 width=64>QUART
</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #4f81bd; WIDTH: 53pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl63 width=70>INCOME
</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #4f81bd; WIDTH: 54pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl63 width=72>BUDGET
</TD><TD style="BORDER-BOTTOM: white 1.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #4f81bd; WIDTH: 59pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 width=79>EXPENSE
</TD></TR><TR style="HEIGHT: 14.25pt" height=19><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 14.25pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=19>ID1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>UK
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7542500
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>543265
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>552067
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>US
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7644278
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>525566
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>547116
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>IND
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7197651
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>560826
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>559619
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>JPN
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7524887
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>547406
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>544726
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID5
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG5
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>UK
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7172475
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>570674
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>546517
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID6
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG6
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>US
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7554891
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>528675
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>548707
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID7
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG7
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>IND
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7135117
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>568617
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>544937
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID8
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG8
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>JPN
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7437736
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>541360
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>552363
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID9
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG9
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>UK
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7174391
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>561519
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>551382
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID10
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG10
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>US
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7634406
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>545762
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>552655
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID11
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG11
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>IND
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7297397
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>533354
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>558965
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID12
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG12
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>JPN
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7466491
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>569603
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>558186
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>UK
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7542500
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>534041
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>545640
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>US
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7644278
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>553429
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>551705
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>IND
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7197651
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>533366
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>557924
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>JPN
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7524887
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>552055
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>554633
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID5
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG5
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>UK
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7172475
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>530177
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>554465
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID6
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG6
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>US
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7554891
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>537826
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>551287
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID7
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG7
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>IND
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7135117
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>526803
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>555743
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID8
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG8
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>JPN
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7437736
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>565150
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>544493
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID9
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG9
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>UK
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7174391
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>541750
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>554294
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID10
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG10
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>US
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7634406
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>569969
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>553476
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID11
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG11
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>IND
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7297397
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>554042
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>544177
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID12
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG12
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>JPN
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7466491
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>533248
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>552649
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>UK
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7542500
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>527091
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>549803
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>US
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7644278
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>553693
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>544647
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>IND
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7197651
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>571620
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>545638
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>JPN
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7524887
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>560992
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>554561
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID5
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG5
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>UK
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7172475
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>560463
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>558976
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID6
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG6
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>US
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7554891
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>560907
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>549432
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID7
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG7
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>IND
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7135117
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>549399
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>544595
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID8
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG8
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>JPN
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7437736
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>561091
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>555976
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID9
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG9
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>UK
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7174391
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>566673
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>547188
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID10
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG10
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>US
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7634406
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>566493
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>550400
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID11
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG11
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>IND
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7297397
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>540253
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>550307
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID12
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG12
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>JPN
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7466491
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>555362
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>556262
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>UK
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7542500
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>563181
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>557934
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>US
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7644278
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>533490
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>548779
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>IND
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7197651
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>527514
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>544264
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>JPN
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7524887
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>540009
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>557617
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID5
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG5
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>UK
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7172475
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>532153
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>550073
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID6
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG6
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>US
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7554891
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>528326
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>551659
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID7
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG7
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>IND
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7135117
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>536916
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>557209
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID8
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG8
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>JPN
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7437736
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>562831
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>547137
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID9
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG9
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG1
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>UK
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7174391
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>541853
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>557919
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67 height=18>ID10
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>R_MNG10
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNGID2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>MNG2
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>US
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>Q4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>7634406
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl67>539619
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl68>557334
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65 height=18>ID11
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>R_MNG11
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNGID3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>MNG3
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>IND
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>2011
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>Q4
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>7297397
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl65>526384
</TD><TD style="BORDER-BOTTOM: white 0.5pt solid; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #b8cce4; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl66>550581
</TD></TR><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 13.5pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl69 height=18>ID12
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl69>R_MNG12
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl69>MNGID4
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl69>MNG4
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl69>JPN
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl69>2011
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl69>Q4
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl69>7466491
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: white 0.5pt solid" class=xl69>563610
</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl70>558163
</TD></TR></TBODY></TABLE>
Upvote
0
Norie
Well-known Member
- Joined
- Apr 28, 2004
- Messages
- 76,377
- Office Version
- 365
- Platform
- Windows
How are you calculating the balance?
Here's the total expenses and budget for each regional manager.
It comes from this query:
SELECT AllExpDatas.REGION_MANAGER, Sum(AllExpDatas.EXPENSE) AS [Total Expenses], Sum(AllExpDatas.BUDGET) AS [Total Budget]
FROM AllExpDatas
GROUP BY AllExpDatas.REGION_MANAGER;
<TABLE border=1 cellSpacing=0 bgColor=#ffffff><CAPTION>qryExpenseAndBudgetByRegManager</CAPTION><THEAD><TR><TH bgColor=#c0c0c0 borderColor=#000000>REGION_MANAGER</TH><TH bgColor=#c0c0c0 borderColor=#000000>Total Expenses</TH><TH bgColor=#c0c0c0 borderColor=#000000>Total Budget</TH></TR></THEAD><TBODY><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG1</TD><TD borderColor=#d0d7e5 align=right>2205444</TD><TD borderColor=#d0d7e5 align=right>2167578</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG10</TD><TD borderColor=#d0d7e5 align=right>2213865</TD><TD borderColor=#d0d7e5 align=right>2221843</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG11</TD><TD borderColor=#d0d7e5 align=right>2204030</TD><TD borderColor=#d0d7e5 align=right>2154033</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG12</TD><TD borderColor=#d0d7e5 align=right>2225260</TD><TD borderColor=#d0d7e5 align=right>2221823</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG2</TD><TD borderColor=#d0d7e5 align=right>2192247</TD><TD borderColor=#d0d7e5 align=right>2166178</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG3</TD><TD borderColor=#d0d7e5 align=right>2207445</TD><TD borderColor=#d0d7e5 align=right>2193326</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG4</TD><TD borderColor=#d0d7e5 align=right>2211537</TD><TD borderColor=#d0d7e5 align=right>2200462</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG5</TD><TD borderColor=#d0d7e5 align=right>2210031</TD><TD borderColor=#d0d7e5 align=right>2193467</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG6</TD><TD borderColor=#d0d7e5 align=right>2201085</TD><TD borderColor=#d0d7e5 align=right>2155734</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG7</TD><TD borderColor=#d0d7e5 align=right>2202484</TD><TD borderColor=#d0d7e5 align=right>2181735</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG8</TD><TD borderColor=#d0d7e5 align=right>2199969</TD><TD borderColor=#d0d7e5 align=right>2230432</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG9</TD><TD borderColor=#d0d7e5 align=right>2210783</TD><TD borderColor=#d0d7e5 align=right>2211795</TD></TR></TBODY><TFOOT></TFOOT></TABLE>
With the correct formula balance could be added in.
Here's the total expenses and budget for each regional manager.
It comes from this query:
SELECT AllExpDatas.REGION_MANAGER, Sum(AllExpDatas.EXPENSE) AS [Total Expenses], Sum(AllExpDatas.BUDGET) AS [Total Budget]
FROM AllExpDatas
GROUP BY AllExpDatas.REGION_MANAGER;
<TABLE border=1 cellSpacing=0 bgColor=#ffffff><CAPTION>qryExpenseAndBudgetByRegManager</CAPTION><THEAD><TR><TH bgColor=#c0c0c0 borderColor=#000000>REGION_MANAGER</TH><TH bgColor=#c0c0c0 borderColor=#000000>Total Expenses</TH><TH bgColor=#c0c0c0 borderColor=#000000>Total Budget</TH></TR></THEAD><TBODY><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG1</TD><TD borderColor=#d0d7e5 align=right>2205444</TD><TD borderColor=#d0d7e5 align=right>2167578</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG10</TD><TD borderColor=#d0d7e5 align=right>2213865</TD><TD borderColor=#d0d7e5 align=right>2221843</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG11</TD><TD borderColor=#d0d7e5 align=right>2204030</TD><TD borderColor=#d0d7e5 align=right>2154033</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG12</TD><TD borderColor=#d0d7e5 align=right>2225260</TD><TD borderColor=#d0d7e5 align=right>2221823</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG2</TD><TD borderColor=#d0d7e5 align=right>2192247</TD><TD borderColor=#d0d7e5 align=right>2166178</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG3</TD><TD borderColor=#d0d7e5 align=right>2207445</TD><TD borderColor=#d0d7e5 align=right>2193326</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG4</TD><TD borderColor=#d0d7e5 align=right>2211537</TD><TD borderColor=#d0d7e5 align=right>2200462</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG5</TD><TD borderColor=#d0d7e5 align=right>2210031</TD><TD borderColor=#d0d7e5 align=right>2193467</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG6</TD><TD borderColor=#d0d7e5 align=right>2201085</TD><TD borderColor=#d0d7e5 align=right>2155734</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG7</TD><TD borderColor=#d0d7e5 align=right>2202484</TD><TD borderColor=#d0d7e5 align=right>2181735</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG8</TD><TD borderColor=#d0d7e5 align=right>2199969</TD><TD borderColor=#d0d7e5 align=right>2230432</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG9</TD><TD borderColor=#d0d7e5 align=right>2210783</TD><TD borderColor=#d0d7e5 align=right>2211795</TD></TR></TBODY><TFOOT></TFOOT></TABLE>
With the correct formula balance could be added in.
Upvote
0
pedie
Well-known Member
- Joined
- Apr 28, 2010
- Messages
- 3,875
Norie, thank you very much!
'm tying the Query you wrote in the mean time...
Balance will be Budget - Expense
I think this can be solved by Cross Tab queries...i tried and seem to work out....
Because i need it for each quarter, for each managers...
Thanks again
'm tying the Query you wrote in the mean time...
Balance will be Budget - Expense
I think this can be solved by Cross Tab queries...i tried and seem to work out....
Because i need it for each quarter, for each managers...
Thanks again
Upvote
0
Norie
Well-known Member
- Joined
- Apr 28, 2004
- Messages
- 76,377
- Office Version
- 365
- Platform
- Windows
Why would you need a cross tab?
Assuming you want the balance for each manager:
SELECT AllExpDatas.REGION_MANAGER, Sum(AllExpDatas.EXPENSE) AS [Total Expenses], Sum(AllExpDatas.BUDGET) AS [Total Budget], Sum([Budget]-[Expense]) AS Balance
FROM AllExpDatas
GROUP BY AllExpDatas.REGION_MANAGER;
<TABLE border=1 cellSpacing=0 bgColor=#ffffff><CAPTION>qryExpenseAndBudgetWithBalanceByRegManager</CAPTION><THEAD><TR><TH bgColor=#c0c0c0 borderColor=#000000>REGION_MANAGER</TH><TH bgColor=#c0c0c0 borderColor=#000000>Total Expenses</TH><TH bgColor=#c0c0c0 borderColor=#000000>Total Budget</TH><TH bgColor=#c0c0c0 borderColor=#000000>Balance</TH></TR></THEAD><TBODY><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG1</TD><TD borderColor=#d0d7e5 align=right>2205444</TD><TD borderColor=#d0d7e5 align=right>2167578</TD><TD borderColor=#d0d7e5 align=right>-37866</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG10</TD><TD borderColor=#d0d7e5 align=right>2213865</TD><TD borderColor=#d0d7e5 align=right>2221843</TD><TD borderColor=#d0d7e5 align=right>7978</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG11</TD><TD borderColor=#d0d7e5 align=right>2204030</TD><TD borderColor=#d0d7e5 align=right>2154033</TD><TD borderColor=#d0d7e5 align=right>-49997</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG12</TD><TD borderColor=#d0d7e5 align=right>2225260</TD><TD borderColor=#d0d7e5 align=right>2221823</TD><TD borderColor=#d0d7e5 align=right>-3437</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG2</TD><TD borderColor=#d0d7e5 align=right>2192247</TD><TD borderColor=#d0d7e5 align=right>2166178</TD><TD borderColor=#d0d7e5 align=right>-26069</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG3</TD><TD borderColor=#d0d7e5 align=right>2207445</TD><TD borderColor=#d0d7e5 align=right>2193326</TD><TD borderColor=#d0d7e5 align=right>-14119</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG4</TD><TD borderColor=#d0d7e5 align=right>2211537</TD><TD borderColor=#d0d7e5 align=right>2200462</TD><TD borderColor=#d0d7e5 align=right>-11075</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG5</TD><TD borderColor=#d0d7e5 align=right>2210031</TD><TD borderColor=#d0d7e5 align=right>2193467</TD><TD borderColor=#d0d7e5 align=right>-16564</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG6</TD><TD borderColor=#d0d7e5 align=right>2201085</TD><TD borderColor=#d0d7e5 align=right>2155734</TD><TD borderColor=#d0d7e5 align=right>-45351</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG7</TD><TD borderColor=#d0d7e5 align=right>2202484</TD><TD borderColor=#d0d7e5 align=right>2181735</TD><TD borderColor=#d0d7e5 align=right>-20749</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG8</TD><TD borderColor=#d0d7e5 align=right>2199969</TD><TD borderColor=#d0d7e5 align=right>2230432</TD><TD borderColor=#d0d7e5 align=right>30463</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG9</TD><TD borderColor=#d0d7e5 align=right>2210783</TD><TD borderColor=#d0d7e5 align=right>2211795</TD><TD borderColor=#d0d7e5 align=right>1012</TD></TR></TBODY><TFOOT></TFOOT></TABLE>
Assuming you want the balance for each manager:
SELECT AllExpDatas.REGION_MANAGER, Sum(AllExpDatas.EXPENSE) AS [Total Expenses], Sum(AllExpDatas.BUDGET) AS [Total Budget], Sum([Budget]-[Expense]) AS Balance
FROM AllExpDatas
GROUP BY AllExpDatas.REGION_MANAGER;
<TABLE border=1 cellSpacing=0 bgColor=#ffffff><CAPTION>qryExpenseAndBudgetWithBalanceByRegManager</CAPTION><THEAD><TR><TH bgColor=#c0c0c0 borderColor=#000000>REGION_MANAGER</TH><TH bgColor=#c0c0c0 borderColor=#000000>Total Expenses</TH><TH bgColor=#c0c0c0 borderColor=#000000>Total Budget</TH><TH bgColor=#c0c0c0 borderColor=#000000>Balance</TH></TR></THEAD><TBODY><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG1</TD><TD borderColor=#d0d7e5 align=right>2205444</TD><TD borderColor=#d0d7e5 align=right>2167578</TD><TD borderColor=#d0d7e5 align=right>-37866</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG10</TD><TD borderColor=#d0d7e5 align=right>2213865</TD><TD borderColor=#d0d7e5 align=right>2221843</TD><TD borderColor=#d0d7e5 align=right>7978</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG11</TD><TD borderColor=#d0d7e5 align=right>2204030</TD><TD borderColor=#d0d7e5 align=right>2154033</TD><TD borderColor=#d0d7e5 align=right>-49997</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG12</TD><TD borderColor=#d0d7e5 align=right>2225260</TD><TD borderColor=#d0d7e5 align=right>2221823</TD><TD borderColor=#d0d7e5 align=right>-3437</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG2</TD><TD borderColor=#d0d7e5 align=right>2192247</TD><TD borderColor=#d0d7e5 align=right>2166178</TD><TD borderColor=#d0d7e5 align=right>-26069</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG3</TD><TD borderColor=#d0d7e5 align=right>2207445</TD><TD borderColor=#d0d7e5 align=right>2193326</TD><TD borderColor=#d0d7e5 align=right>-14119</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG4</TD><TD borderColor=#d0d7e5 align=right>2211537</TD><TD borderColor=#d0d7e5 align=right>2200462</TD><TD borderColor=#d0d7e5 align=right>-11075</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG5</TD><TD borderColor=#d0d7e5 align=right>2210031</TD><TD borderColor=#d0d7e5 align=right>2193467</TD><TD borderColor=#d0d7e5 align=right>-16564</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG6</TD><TD borderColor=#d0d7e5 align=right>2201085</TD><TD borderColor=#d0d7e5 align=right>2155734</TD><TD borderColor=#d0d7e5 align=right>-45351</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG7</TD><TD borderColor=#d0d7e5 align=right>2202484</TD><TD borderColor=#d0d7e5 align=right>2181735</TD><TD borderColor=#d0d7e5 align=right>-20749</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG8</TD><TD borderColor=#d0d7e5 align=right>2199969</TD><TD borderColor=#d0d7e5 align=right>2230432</TD><TD borderColor=#d0d7e5 align=right>30463</TD></TR><TR vAlign=top><TD borderColor=#d0d7e5>R_MNG9</TD><TD borderColor=#d0d7e5 align=right>2210783</TD><TD borderColor=#d0d7e5 align=right>2211795</TD><TD borderColor=#d0d7e5 align=right>1012</TD></TR></TBODY><TFOOT></TFOOT></TABLE>
Upvote
0
Similar threads
