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

Type |  | Period |  |  |  |  |  |  |  |  |  |  |  |  | D-CB |  |  |  |  |  | D-BL |  |  |  |  |  | E-
 |  |  |  |  |  | Country | Total Proceeds [mUSD] | Number of Deals |  | Company | Transaction Type(s) | Total Proceeds [mUSD] | Percent of Total |  | Participants | hidden | Deals | Total Proceeds [mUSD] | Percent of Total |  | Participants | hidden | Deals | Total Proceeds [mUSD] | Percent of Total |  | Participants | hidden | Deals | Total Proceeds [mUSD] | Percent of Total
Number of Deals |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ABG | zzzzz |  |  |  |  | ABG | zzzzz |  |  |  |  | ABG | zzzzz
Total Raised [mUSD] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ABN AMRO | zzzzz |  |  |  |  | ABN AMRO | zzzzz |  |  |  |  | ABN AMRO | zzzzz
Average Size [mUSD] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Arctic | zzzzz |  |  |  |  | Arctic | zzzzz |  |  |  |  | Arctic | zzzzz
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bank of India | zzzzz |  |  |  |  | Bank of India | zzzzz |  |  |  |  | Bank of India | zzzzz
Industry | Number of Deals | Average Size [mUSD] | Total Proceeds [mUSD] | Percent of Proceeds |  |  |  |  |  |  |  |  |  |  | Barclays | zzzzz |  |  |  |  | Barclays | zzzzz |  |  |  |  | Barclays | zzzzz
Offshore |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BNDES | zzzzz |  |  |  |  | BNDES | zzzzz |  |  |  |  | BNDES | zzzzz
Shipping |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BNP | zzzzz |  |  |  |  | BNP | zzzzz |  |  |  |  | BNP | zzzzz
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Bank of America |  |  |  |  | [NAME] | Bank of America |  |  |  |  | [NAME] | Bank of America
Transaction Type | Number of Deals | Average Size [mUSD] | Total Proceeds [mUSD] | Percent of Proceeds |  |  |  |  |  |  |  |  |  |  | Carnegie | zzzzz |  |  |  |  | Carnegie | zzzzz |  |  |  |  | Carnegie | zzzzz
D-CB |  |  |  |  |  |  |  |  |  |  |  |  |  |  | China EXIM | zzzzz |  |  |  |  | China EXIM | zzzzz |  |  |  |  | China EXIM | zzzzz
D-Conv |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CIDI | zzzzz |  |  |  |  | CIDI | zzzzz |  |  |  |  | CIDI | zzzzz
D-BL |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Citi | zzzzz |  |  |  |  | Citi | zzzzz |  |  |  |  | Citi | zzzzz
D-DIP |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Commerzbank | zzzzz |  |  |  |  | Commerzbank | zzzzz |  |  |  |  | Commerzbank | zzzzz
E-IPO |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Credit Agricole | zzzzz |  |  |  |  | Credit Agricole | zzzzz |  |  |  |  | Credit Agricole | zzzzz
E-FO |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Credit Suisse | zzzzz |  |  |  |  | Credit Suisse | zzzzz |  |  |  |  | Credit Suisse | zzzzz
E-PP |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dalman Rose | zzzzz |  |  |  |  | Dalman Rose | zzzzz |  |  |  |  | Dalman Rose | zzzzz
E-Other |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Danske | zzzzz |  |  |  |  | Danske | zzzzz |  |  |  |  | Danske | zzzzz
M&A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DBS | zzzzz |  |  |  |  | DBS | zzzzz |  |  |  |  | DBS | zzzzz
L |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Deutsche | zzzzz |  |  |  |  | Deutsche | zzzzz |  |  |  |  | Deutsche | zzzzz
R |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DNB | zzzzz |  |  |  |  | DNB | zzzzz |  |  |  |  | DNB | zzzzz
SR |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DVB | zzzzz |  |  |  |  | DVB | zzzzz |  |  |  |  | DVB | zzzzz
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fearnley | zzzzz |  |  |  |  | Fearnley | zzzzz |  |  |  |  | Fearnley | zzzzz
Staus | Number of Deals | Average Size [mUSD] | Total Proceeds [mUSD] | Percent of Proceeds |  |  |  |  |  |  |  |  |  |  | GE Capital | zzzzz |  |  |  |  | GE Capital | zzzzz |  |  |  |  | GE Capital | zzzzz
Done |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Goldman Sachs | zzzzz |  |  |  |  | Goldman Sachs | zzzzz |  |  |  |  | Goldman Sachs | zzzzz
In Progress |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HSBC | zzzzz |  |  |  |  | HSBC | zzzzz |  |  |  |  | HSBC | zzzzz
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | India | zzzzz |  |  |  |  | India | zzzzz |  |  |  |  | India | zzzzz
Debt |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ING | zzzzz |  |  |  |  | ING | zzzzz |  |  |  |  | ING | zzzzz
Maturity | Number of Deals |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | JP |  |  |  |  | [NAME] | JP |  |  |  |  | [NAME] | JP
0<5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Japan | zzzzz |  |  |  |  | Japan | zzzzz |  |  |  |  | Japan | zzzzz
6<10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Korea | zzzzz |  |  |  |  | Korea | zzzzz |  |  |  |  | Korea | zzzzz
11< |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mitisubishi | zzzzz |  |  |  |  | Mitisubishi | zzzzz |  |  |  |  | Mitisubishi | zzzzz
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Morgan Stanley | zzzzz |  |  |  |  | Morgan Stanley | zzzzz |  |  |  |  | Morgan Stanley | zzzzz
Coupon | Percent |  |  |  |  |  |  |  |  |  |  |  |  |  | Nordea | zzzzz |  |  |  |  | Nordea | zzzzz |  |  |  |  | Nordea | zzzzz
Average |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pareto | zzzzz |  |  |  |  | Pareto | zzzzz |  |  |  |  | Pareto | zzzzz
Median |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Platou | zzzzz |  |  |  |  | Platou | zzzzz |  |  |  |  | Platou | zzzzz
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RBC | zzzzz |  |  |  |  | RBC | zzzzz |  |  |  |  | RBC | zzzzz
Yield | Percent |  |  |  |  |  |  |  |  |  |  |  |  |  | RBS | zzzzz |  |  |  |  | RBS | zzzzz |  |  |  |  | RBS | zzzzz
Average |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEB | zzzzz |  |  |  |  | SEB | zzzzz |  |  |  |  | SEB | zzzzz
Median |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Societe Generale | SocGen |  |  |  |  | Societe Generale | SocGen |  |  |  |  | Societe Generale | SocGen
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Standard Charter | zzzzz |  |  |  |  | Standard Charter | zzzzz |  |  |  |  | Standard Charter | zzzzz
Spread | Basis Points |  |  |  |  |  |  |  |  |  |  |  |  |  | Sundal | zzzzz |  |  |  |  | Sundal | zzzzz |  |  |  |  | Sundal | zzzzz
Average |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | zzzzz |  |  |  |  | [NAME] | zzzzz |  |  |  |  | [NAME] | zzzzz
Median |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UBS | zzzzz |  |  |  |  | UBS | zzzzz |  |  |  |  | UBS | zzzzz
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | US EXIM | zzzzz |  |  |  |  | US EXIM | zzzzz |  |  |  |  | US EXIM | zzzzz
Spread Basis | Number of Deals | Total Proceeds [mUSD] |  |  |  |  |  |  |  |  |  |  |  |  | Wells Fargo | zzzzz |  |  |  |  | Wells Fargo | zzzzz |  |  |  |  | Wells Fargo | zzzzz
NIBOR
LIBOR
US
Equity
Exchange | Number of Deals | Total Proceeds [mUSD]
ASX
KRX (Korea Stock Exchange)
NASDAQ
NYSE
SGX (Singapore)
SSE (Shanghai, China)
Primary Shares Issued | Number of Shares [m]
Average
Median
Greenshoe Shares | Number of Shares [m]
Average
Median
Secondary Shares | Number of Shares [m]
Average
Median