Spreadsheet: 96448d1295859018-settings-changed-for-default-cell-format-want-to-change-it-back-to-general-excelforum_yongsonneedshelp
Sheet: PIVOT (EU+US)

Financings by year and financing type (EURm)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUM |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AVERAGE |  |  |  |  |  |  |  |  |  |  |  |  |  | COUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 |  |  | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
EU/US financing (HQ) | TRUE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Venture |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Venture |  |  |  |  |  |  |  |  |  |  |  |  |  | Venture
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IPO |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IPO |  |  |  |  |  |  |  |  |  |  |  |  |  | IPO
 | Column Labels |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Follow-on |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Follow-on |  |  |  |  |  |  |  |  |  |  |  |  |  | Follow-on
 | 2000 |  |  | 2001 |  |  | 2002 |  |  | 2004 |  |  | 2005 |  |  | 2006 |  |  | 2007 |  |  | 2008 |  |  | 2009 |  |  | 2010 |  |  |  |  |  |  |  |  |  |  |  |  | PIPE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PIPE |  |  |  |  |  |  |  |  |  |  |  |  |  | PIPE
Row Labels | Sum | Average | Count | Sum | Average | Count | Sum | Average | Count | Sum | Average | Count | Sum | Average | Count | Sum | Average | Count | Sum | Average | Count | Sum | Average | Count | Sum | Average | Count | Sum | Average | Count |  |  |  |  |  |  |  |  |  |  | Convertibles & Warrants (private) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Convertibles & Warrants (private) |  |  |  |  |  |  |  |  |  |  |  |  |  | Convertibles & Warrants (private)
public |  |  |  |  |  |  |  |  |  |  |  |  | 9.36423 | 9.36423 | 1 | 1.23024132 | 1.23024132 | 1 | 24.4 | 24.4 | 1 | 10.449932038 | 5.224966019 | 2 | 22.0110002 | 22.0110002 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Convertibles & Warrants (public) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Convertibles & Warrants (public) |  |  |  |  |  |  |  |  |  |  |  |  |  | Convertibles & Warrants (public)
Follow-on |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.249932038 | 3.249932038 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total (Equity) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total (Equity) |  |  |  |  |  |  |  |  |  |  |  |  |  | Total (Equity)
Grant |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.2 | 7.2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Debt (private) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Debt (private) |  |  |  |  |  |  |  |  |  |  |  |  |  | Debt (private)
IPO |  |  |  |  |  |  |  |  |  |  |  |  | 9.36423 | 9.36423 | 1 |  |  |  | 24.4 | 24.4 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Debt (public) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Debt (public) |  |  |  |  |  |  |  |  |  |  |  |  |  | Debt (public)
PIPE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.23024132 | 1.23024132 | 1 |  |  |  |  |  |  | 22.0110002 | 22.0110002 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total (Capital) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total (Capital) |  |  |  |  |  |  |  |  |  |  |  |  |  | Total (Capital)
private | 4 | 4 | 1 | 12 | 12 | 1 | 17.35 | 5.783333333333334 | 3 | 25.21 | 25.21 | 1 | 22.360524 | 5.590131 | 4 | 38.56805784 | 4.28533976 | 9 | 60.1588163 | 7.5198520375 | 8 | 52.7053787 | 5.856153188888889 | 9 | 36.6882405 | 4.5860300625 | 8 | 22.0604 | 5.5151 | 4
Debt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.5 | 6.5 | 1
Grant |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.35 | 0.35 | 1
Other |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.559532 | 7.559532 | 1
Venture | 4 | 4 | 1 | 12 | 12 | 1 | 17.35 | 5.783333333333334 | 3 | 25.21 | 25.21 | 1 | 22.360524 | 5.590131 | 4 | 38.56805784 | 4.28533976 | 9 | 60.1588163 | 7.5198520375 | 8 | 45.1458467 | 5.6432308375 | 8 | 30.1882405 | 4.312605785714286 | 7 | 21.7104 | 7.2368 | 3
Grand Total | 4 | 4 | 1 | 12 | 12 | 1 | 17.35 | 5.783333333333334 | 3 | 25.21 | 25.21 | 1 | 31.724754 | 6.344950799999999 | 5 | 39.79829916 | 3.979829916 | 10 | 84.55881629999999 | 9.395424033333333 | 9 | 63.155310738 | 5.741391885272727 | 11 | 58.6992407 | 6.522137855555555 | 9 | 22.0604 | 5.5151 | 4