2_Template_Dashboard_Portfolio-Status_EN.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	U	W	Y	AA	AB	AD	AE	AG	AH
1
2	PROJECT PORTFOLIO SUMMARY TEMPLATE

3	DEPARTMENT					PORTFOLIO FINANCIAL HEALTH
4	DEPARTMENT LEAD					€ 12.800.000	BUDGET
5	NUMBER OF PROJECTS		10			€ 8.812.000	ACTUAL
6	DATE OF LAST UPDATE					€ 3.988.000	BALANCE
7
8	PROJECT HEALTH LEVEL	PRIORITY	PROJECT ID	PROJECT NAME	STATUS	PROJECT SUMMARY	PROJECT MANAGER	BUDGET	ACTUAL	BUDGET LESS ACTUAL	EXPECTED DATE OF COMPLETION	NUMBER OF DAYS REMAINING	PERCENT OF PROJECT COMPLETE	ASSOCIATED RISKS	COST BENEFIT ANALYSIS OUTCOME	COMMENTARY	ATTACHMENTS / LINKS	PROJECT HEALTH LEVEL KEY	STATUS KEY	PRIORITY KEY	PROJECT HEALTH LEVEL CT	QTY	STATUS COUNT	QTY	PRIORITY KEY	QTY
9	1	LOW			OTHER			€ 800.000	€ 500.000	€ 300.000	09/30/22	(1181)	10%					1	REQUEST PLACED	LOW	1	2	REQUEST PLACED	0	LOW	4
10	2	MEDIUM			MONITOR			€ 800.000	€ 312.000	€ 488.000	05/05/25	(233)	30%					2	APPROVED	MEDIUM	2	2	APPROVED	2	MEDIUM	3
11	3	HIGH			COMPLETE			€ 800.000	€ 500.000	€ 300.000	09/30/26	280	50%					3	PLANNING PHASE	HIGH	3	1	PLANNING PHASE	1	HIGH	2
12	4	EXTREME			ON HOLD			€ 800.000	€ 500.000	€ 300.000	10/11/23	(805)	25%					4	ON HOLD	EXTREME	4	4	ON HOLD	1	EXTREME	1
13	5	LOW			PLANNING PHASE			€ 800.000	€ 500.000	€ 300.000	12/12/19	(2204)	11%					5	COMPLETE		5	1	COMPLETE	3
14	4	LOW			APPROVED			€ 800.000	€ 500.000	€ 300.000		(46015)	90%						MONITOR				MONITOR	2
15	4	LOW			APPROVED			€ 800.000	€ 500.000	€ 300.000		(46015)	60%						OTHER				OTHER	1
16	2	MEDIUM			MONITOR			€ 800.000	€ 500.000	€ 300.000		(46015)	30%
17	1	MEDIUM			COMPLETE			€ 800.000	€ 500.000	€ 300.000		(46015)	100%
18	4	HIGH			COMPLETE			€ 800.000	€ 500.000	€ 300.000		(46015)	0%
19								€ 800.000	€ 500.000	€ 300.000		(46015)	0%
20								€ 800.000	€ 500.000	€ 300.000		(46015)	0%
21								€ 800.000	€ 500.000	€ 300.000		(46015)	0%
22								€ 800.000	€ 500.000	€ 300.000		(46015)	0%
23								€ 800.000	€ 500.000	€ 300.000		(46015)	0%
24								€ 800.000	€ 500.000	€ 300.000		(46015)	0%
25								€ -	€ 500.000	€ (500.000)		(46015)	0%
26								€ -	€ 500.000	€ (500.000)		(46015)	0%
27
28
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101