Embed Size (px)
Citation preview
Welcome to Project Status Dashboard Toolkit
Using this toolkit, you can make a dynamic, self-updating dashboard for your projects in no time.
Who can use this dashboard? You need to have basic excel knowledge to start using this dashboard. It is designed keeping you in mind. How to make changes to the dashboard? To make changes to the dashboard, you need to change values in the worksheets - Data, Project Plan Gantt Chart, Burndown Chart and Issue Trakcer. Once you make the changes in these worksheets, just revisit the "project status dashboard" worksheet to see it updated. How can I make changes to the dashboard charts? You can insert your own charts in to this dashboard very easily. First, insert a new worksheet and make a chart there with all the data and formatting. Once the chart is ready, just cut and paste it in the dashboard. Adjust the chart's size and position and you are good to go. For more help on using this kit, please visit http://chandoo.org/wp/project-management-templates/ http://chandoo.org/forums/
Project Status
Ongoing Activities: 3
Activity % done
0 0%
0 0%
0 0%
0 0%
0 0%
Top 5 Issues
Burndown Chart Project Timeline
Completed 0%
SCC Project Status Dashboard
Outstanding Issues
Click on the gantt chart to see it in detail
0
0
0
0
0
Project Plan
0
100
200
300
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Daily Completed Planned Actual
%
1
2
/
0
3
1
3
/
0
3
1
4
/
0
3
1
5
/
0
3
1
6
/
0
3
1
7
/
0
3
1
8
/
0
3
1
9
/
0
3
2
0
/
0
3
2
1
/
0
3
2
2
/
0
3
2
3
/
0
3
2
4
/
0
3
2
5
/
0
3
2
6
/
0
3
2
7
/
0
3
2
8
/
0
3
2
9
/
0
3
3
0
/
0
3
3
1
/
0
3
0
1
/
0
4
0
2
/
0
4
0
3
/
0
4
0
4
/
0
4
0
5
/
0
4
0
6
/
0
4
0
7
/
0
4
0
8
/
0
4
0
9
/
0
4
1
0
/
0
4
1
1
/
0
4
1
2
/
0
4
# List of Activties Pesponsble Start Dur Start Dur Done 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
1 1 WSS 2 1 2 1 100% ▓
2 Test 1 WSS 2 1 2 0 20% ▓
3 Test2 } WSS 3 1 3 0 100% ▓
456
78
91011
121314
1516
171819
2021
222324
2526
272829
303132
33343536
37
38
39404142
434445
4647484950
5152
535455
565758
5960
616263
6465
6667
68
6970
Planned Actual Show Gantt for Planned Show Status? ▓ What is current week? 12
Project Timeline
Project Status Dashboard
Outstanding Issues
Click on the gantt chart to see it in detail
0 0 0
%
1
2
/
0
3
1
3
/
0
3
1
4
/
0
3
1
5
/
0
3
1
6
/
0
3
1
7
/
0
3
1
8
/
0
3
1
9
/
0
3
2
0
/
0
3
2
1
/
0
3
2
2
/
0
3
2
3
/
0
3
2
4
/
0
3
2
5
/
0
3
2
6
/
0
3
2
7
/
0
3
2
8
/
0
3
2
9
/
0
3
3
0
/
0
3
3
1
/
0
3
0
1
/
0
4
0
2
/
0
4
0
3
/
0
4
0
4
/
0
4
0
5
/
0
4
0
6
/
0
4
0
7
/
0
4
0
8
/
0
4
0
9
/
0
4
1
0
/
0
4
1
1
/
0
4
1
2
/
0
4
# List of Activties Pesponsble Start Dur Start Dur Done 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
1 1 WSS 2 1 2 1 100% ▓
2 Test 1 WSS 2 1 2 0 20% ▓
3 Test2 } WSS 3 1 3 0 100% ▓
456
78
91011
121314
1516
171819
2021
222324
2526
272829
303132
33343536
37
38
39404142
434445
4647484950
5152
535455
565758
5960
616263
6465
6667
68
6970
Planned Actual Show Gantt for Planned Show Status? ▓ What is current week? 12
Overall Project Status Amber Date Milestone if any
Overall Project Progress 0%
Ongoing Activities 3
List of Activities
Activity Completion
Enter the Project Milestone Data HereEnter Project Status
Enter Activity Details
Top 5 Issues
Height Issue Dummy
0
0
0
00
0
0
0
0
0
0
0
Enter the Project Milestone Data Here
#1 123456789
1011121314
15161718192021222324
2526272829
303132
33343536
3738
39404142434445
4647484950515253545556
Project Plan - Gantt Chart Template
57585960
616263
64656667
68697071727374
7576777879808182
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
List of Activties
Test 1Test2 }
Project Plan - Gantt Chart Template
%
1
2
/
0
3
1
3
/
0
3
1
4
/
0
3
1
5
/
0
3
1
6
/
0
3
1
7
/
0
3
1
8
/
0
3
1
9
/
0
3
2
0
/
0
3
Pesponsble Start Dur Start Dur Done 1 2 3 4 5 6 7 8 9
WSS 2 1 2 1 100% ▓
WSS 2 1 2 0 20% ▓
WSS 3 1 3 0 100% ▓
Project Plan - Gantt Chart Template
Planned Actual Show Gantt for Planned
2
1
/
0
3
2
2
/
0
3
2
3
/
0
3
2
4
/
0
3
2
5
/
0
3
2
6
/
0
3
2
7
/
0
3
2
8
/
0
3
2
9
/
0
3
3
0
/
0
3
3
1
/
0
3
0
1
/
0
4
0
2
/
0
4
0
3
/
0
4
0
4
/
0
4
0
5
/
0
4
0
6
/
0
4
0
7
/
0
4
0
8
/
0
4
0
9
/
0
4
1
0
/
0
4
1
1
/
0
4
1
2
/
0
4
10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
Project Plan - Gantt Chart Template
Planned Show Status? ▓ What is current week? 12
Dia Base12-Mar
9/21/2014
33
Deliverable Burn Down
Day Planned Actual Planned Actual
0 250 250 #N/A
1 12 8 238 242 8
2 18 10 220 232 10
3 11 0 209 232 0
4 4 12 205 220 12
5 5 19 200 201 19
6 6 13 194 188 13
7 10 8 184 180 8
8 20 2 164 178 2
9 20 144 #N/A #N/A
10 18 2 126 176 2
11 6 120 #N/A #N/A
12 13 2 107 174 2
13 7 34 100 140 34
14 14 86 #N/A #N/A
15 12 74 #N/A #N/A
16 14 60 #N/A #N/A
17 12 48 #N/A #N/A
18 11 37 #N/A #N/A
19 19 18 #N/A #N/A
20 18 0 #N/A #N/A
30 45 -45
Burn down chart
Burned down Balance
Daily Completed
# Issue Priority Open Close
1 User name check fails Low Jul/12 Jul/15
2 Password field is not mandatory Medium Jul/12 Jul/13
3 Reset button doesn’t work High Jul/14 Jul/19
4 When window is maximized, the layout is compromised Low Jul/15 Jul/16
5 Password field takes more than 99 chars Medium Jul/15 Jul/18
6 User name allows SQL injection Medium Jul/15 Jul/20
7 Password allows SQL injection Low Jul/15 Jul/22
8 User name allows HTML Injection High Jul/16 Jul/20
9 Password allows HTML Injection Low Jul/16 Jul/17
10 Submit doesn’t work on enter Medium Jul/18 Jul/25
11 User name is not the default field on screen load High Jul/18 Jul/24
12 When hitting F5, the error message still remains Low Jul/18 Jul/25
13 Message is wrong Medium Jul/22 Jul/24
14 User name check fails Medium Jul/23 Jul/28
15 Password field is not mandatory Low Jul/23 Jul/27
16 Reset button doesn’t work High Jul/23 Jul/30
17 When window is maximized, the layout is compromised Medium Jul/23 Jul/25
18 Password field takes more than 99 chars High Jul/23 Jul/28
19 User name allows SQL injection Low Jul/24 Jul/31
20 Password allows SQL injection Medium Jul/24 Jul/30
21 User name allows HTML Injection Medium Jul/24 Jul/30
22 Password allows HTML Injection Low Jul/27 Aug/02
23 Submit doesn’t work on enter High Jul/28 Jul/29
24 User name is not the default field on screen load Low Jul/29 Aug/02
25 When hitting F5, the error message still remains Medium Jul/31 Aug/07
26 Message is wrong High Aug/01 Aug/04
27 User name check fails Low Aug/01 Aug/05
28 Password field is not mandatory Medium Aug/02 Aug/09
29 Reset button doesn’t work Medium Aug/04 Aug/05
30 When window is maximized, the layout is compromised Medium Aug/05 Aug/12
31 Password field takes more than 99 chars High Aug/05 Aug/07
32 User name allows SQL injection Low Aug/06 Aug/09
33 Password allows SQL injection Medium Aug/07 Aug/09
34 User name allows HTML Injection Medium Aug/07 Aug/08
35 Password allows HTML Injection Low Aug/10 Aug/16
36 Submit doesn’t work on enter High Aug/12 Aug/19
37 User name is not the default field on screen load Low Aug/14 Aug/17
38 When hitting F5, the error message still remains Medium Aug/15 Aug/21
39 Message is wrong High Aug/17 Aug/24
40 User name check fails Low Aug/18 Aug/25
41 Password field is not mandatory Medium Aug/21 Aug/25
42 Reset button doesn’t work Medium Aug/22 Aug/27
43 When window is maximized, the layout is compromised High Aug/22 Aug/25
44 Password field takes more than 99 chars Low Aug/22 Aug/28
45 User name allows SQL injection Medium Aug/22 Aug/24
Issue Tracker Template
Date
Comments
High 0
Medium 0
Low 0
Open Issue Summary
Types of Gantt Gantt Chart Symbols
Planned █
Actual ♪
↓
▓
