project progress tracking (ppt) for egee jurgen de jonghe, it-ais-pm [email protected]
TRANSCRIPT
![Page 2: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/2.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
Projects supported, Timeline
LHC 3.3 BCHF expenditure12 years
ATLAS Detector 500 MCHF CORE Cost,150 institutes in 35 countries
CERN wide strategic planning
1999
2002
2004
2005
2003
CNGS 75 MCHF expenditureCERN & Gran Sasso
EGEE 50 MCHF,70 partners 800 project members
Our mission: “Optimise the project’s chances of success with minimum overhead”
![Page 3: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/3.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
LHC Tool
![Page 4: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/4.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
EVM Analysis Tools
![Page 5: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/5.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
Every project is unique
• EGEE:– Partners outside CERN – Mix of Research & Operation/Service Activities– Initial lifespan very short – EU Framework
• Scope of PPT/EGEE:– WBS, Activities– Tasks from the Execution Plan– EU Deliverables & Milestones
– Partners– Project Members, Timesheets
– Cost Information
![Page 6: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/6.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
Project Member Database
![Page 7: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/7.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
Timesheets
![Page 8: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/8.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
Timesheets
• Data Entry– Excel– Web Form– XML
• Workflow
![Page 9: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/9.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
Timesheet Dashboard
![Page 10: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/10.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
Validated Timesheets: Delay
0
50
100
150
200
250
300
350
400
450
500
2004-09 2004-10 2004-11 2004-12 2005-01
-1
0
3
6
9
12
Drop Page Fields Here
Sum of TIMESHEETS
PERIOD
DELAY
7000 timesheets entered so far …
![Page 11: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/11.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
Online Help
Access Rights, Workflow, Business Rules
![Page 12: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/12.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
Ad Hoc reports for Project Office
![Page 13: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/13.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
Tracking, History Log
![Page 14: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/14.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
Scope
• WBS, Activities• Tasks from the Execution Plan• EU Deliverables & Milestones
• Partners• Project Members, Timesheets
• Cost Information
![Page 15: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/15.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
Scope Cont’d
• Workflow:– Internal Reporting
•Technical•Financial on quarterly basis
– Periodic EU Reviews
• Analysis Tools– EVM ?
•Monitor Progress against Plan•Monitor Costs (€),Funded and Unfunded FTE
– Pro-Active Alerts
![Page 16: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/16.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
Progress Reporting: Excel & Web
![Page 17: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/17.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
All Modifications tracked …
![Page 18: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/18.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
Concepts
![Page 19: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/19.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
PPT for EGEE: EVM
• Planned Value: One or many partners work on a Task for a planned amount of Person-Months.
• Actual Cost: Timesheets indicate hours worked for a task.
• Earned Value: Requires “Progress Reporting”, ie indicate completion level for task.
![Page 20: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/20.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
Project Management tools
• We build web based PM tools since 1999• Current projects supported:
– ATLAS (500 MCHF, 150 partners)– LHC (3BCHF, EVM, 11000 workunits)– CNGS (75MCHF, EVM)– All AB internal projects (EVM + Staff Planning)
Optimise Project’s chances of success:
- minimise surprises
- minimum overhead
![Page 21: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/21.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
• Resources from AIS• Nb of users, different status• show how easy it is to fill in a TS• the validation process• the management of task• downloads and uses of database: • email lists, • effort tables, • follow up at the level of supervisors, institutes, project… • use as project database• statistics• possibilities of EVM•
![Page 22: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/22.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
Summary
• Project Management tools @ CERN• Scope for EGEE
– Members Database– Timesheet– Co-develop Reports for Project Office
• Timesheet Usage Summary• Resources used…
![Page 23: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/23.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
Agenda
• How to create a TimeSheet– Using web form– Using Excel upload– Lifecycle– Tutorial
• Zooming out– PPT in general– Data issues?
![Page 24: Project Progress Tracking (PPT) for EGEE Jurgen De Jonghe, IT-AIS-PM jurgen.de.jonghe@cern.ch](https://reader036.vdocuments.us/reader036/viewer/2022062717/56649e5d5503460f94b559a5/html5/thumbnails/24.jpg)
EGEE, EU Review (Feb 2005) Jurgen De Jonghe, IT-AIS
Members Database
• Official Project Member Database• Access Restrictions for Individual supervisors,
Partner supervisors, Activity supervisors and Project Office
• Type of Members: