Spreadsheet: 707351d1607194249-indirect-using-two-workbooks-sample-2-data
Sheet: First State China

 | Fund name |  | Date |  | Sheet name
 | First State China |  | 2020-09-01 00:00:00
 | Shares Held | % | First brought | 1 yr return | Sector |  |  | Size | Fund % |  |  | Sectors |  |  |  | Region |  |  |  | Working Space for download from [NAME]
1 |  |  |  |  |  |  | 1 | Giant | 40.16 |  | 1 | Basic Materials | 0 |  | 1 | North America | 1.47
2 |  |  |  |  |  |  | 2 | Large | 31.93 |  | 2 | Consumer Cyclical | 15.55 |  | 2 | United Kingdom | 0 |  |  | Table below used to populate main page
3 |  |  |  |  |  |  | 3 | Mid | 18.74 |  | 3 | Financial Services | 11.83 |  | 3 | Europe Developed | 0
4 |  |  |  |  |  |  | 4 | Small | 4.94 |  | 4 | Real Estate | 4.03 |  | 4 | Europe Emerging | 0 |  |  | Shares held | % | 1st Brought |  |  |  | 1yr return |  |  |  | Sector
5 |  |  |  |  |  |  | 5 | Micro | 0 |  | 5 | Communication Services | 6.26 |  | 5 | Africa/Middle East | 0 |  |  | Shanghai Liangxin Electrical Co Ltd Class A | 6.59 | 2017-09-30 00:00:00 |  |  |  | 221.98 |  |  |  | Industrials
6 |  |  |  |  |  |  |  |  |  |  | 6 | Energy | 0 |  | 6 | Japan | 0 |  |  | China Mengniu Dairy Co Ltd | 5.91 | 2017-03-31 00:00:00 |  |  |  | 29.8 |  |  |  | Consumer Defensive
7 |  |  |  |  |  |  |  |  |  |  | 7 | Industrials | 28.74 |  | 7 | Australasia | 0 |  |  | Meituan | 4.67 | 2020-03-31 00:00:00 |  |  |  | 178.04 |  |  |  | Consumer Cyclical
8 |  |  |  |  |  |  |  |  |  |  | 8 | Technology | 14.77 |  | 8 | Asia Developed | 5.24 |  |  | Tencent Holdings Ltd | 4.59 | 2017-03-31 00:00:00 |  |  |  | 74.78 |  |  |  | Communication Services
9 |  |  |  |  |  |  |  |  |  |  | 9 | Consumer Defensive | 8.8 |  | 9 | Asia Emerging | 93.29 |  |  | Bank Of Ningbo Co Ltd | 4.41 | 2017-03-31 00:00:00 |  |  |  | 35.54 |  |  |  | Financial Services
10 |  |  |  |  |  |  |  |  |  |  | 10 | Healthcare | 10.03 |  | 10 | Latin America | 0 |  |  | Midea Group Co Ltd Class A | 4.26 | 2018-07-31 00:00:00 |  |  |  | 47.81 |  |  |  | Technology
11 |  |  |  |  |  |  |  |  |  |  | 11 | Utilities | 0 |  |  |  |  |  |  | China Merchants Bank Co Ltd Class H | 4.08 | 2018-04-30 00:00:00 |  |  |  | 17.45 |  |  |  | Financial Services
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Country |  |  |  | 51job Inc ADR | 3.99 | 2018-03-31 00:00:00 |  |  |  | -7.36 |  |  |  | Industrials
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zhejiang Weixing New Building Materials Co Ltd | 3.9 | 2020-01-31 00:00:00 |  |  |  | -0.18 |  |  |  | Industrials
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | China | 93.28 |  |  | China Resources Land Ltd | 3.86 | 2019-03-31 00:00:00 |  |  |  | 0.26 |  |  |  | Real Estate
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Hong Kong | 2.94
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Taiwan | 2.3
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | United States | 1.47
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 | Total |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 | Screen print here