Spreadsheet: 170564d1343315950-vlookup-that-returns-multiple-values-from-a-prior-column-form
Sheet: Chart Data

Type | All | Period
 |  |  |  |  |  | Country | Total Proceeds [mUSD] | dummy | Number of Deals |  | Company | Total Proceeds [mUSD] | dummy | Percent of Total |  | Participants | Deals Involved | dummy | Total Proceeds [mUSD] | dummy | Percent of Total |  | Participants | Deals Involved | dummy | Total Proceeds [mUSD] | dummy | Percent of Total |  | Participants | Deals Involved | dummy | Total Proceeds [mUSD] | dummy | Percent of Total
Number of Deals |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Total Raised [mUSD] |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
[NAME] [mUSD] |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Industry | Number of Deals | Industry | Total Proceeds [mUSD] |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Transaction Type | Number of Deals | Transaction Type | Total Proceeds [mUSD] |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Staus | Number of Deals | Staus | Total Proceeds [mUSD] |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Done |  | Done |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
In Progress |  | In Progress |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Debt |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Maturity | Number of Deals |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Coupon | Percent |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Average |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Median |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Yeild | Percent |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Average |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Median |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Spread | Basis Points |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Average |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Median |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Spread Basis | Number of Deals | Total Proceeds [mUSD] |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Equity |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Exchange | Number of Deals | dummy | Total Proceeds [mUSD] |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
ASX |  | 0 |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
KRX (Korea Stock Exchange) |  | 0 |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
NASDAQ |  | 0 |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
NYSE |  | 0 |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
SGX (Singapore) |  | 0 |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
SSE (Shanghai, China) |  | 0 |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Primary Shares Issued | Number of Shares [m] |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Average |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Median |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Greenshoe Shares | Number of Shares [m] |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Average |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Median |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Secondary Shares | Number of Shares [m] |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Average |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
Median |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0 |  |  |  |  | 0 |  | 0