Calculating the hours of experience for the PMP application - Part 3
Author: Bogdan Gorka
PMP Hours Calculation Sheet
I have developed a model in MS Excel to calculate the hours needed for the PMP exam application.
To use the model you need the following input data:
1. A list of non overlapping projects from the last 3 years
2. Project exact start and end dates. If it was only one or two phases of a bigger project, the dates of your assignment started and stopped.
3. Percent of time engagement on each project (e.g. 50% of your total time available) This is a minimum amount of data to use my model.
DOWNLOAD THE WORKSHEET HERE
Now all you have to do is to follow my description step by step:
1. Delete example projects - cells: B10:E13
2. Input your data: Project Name, Start Date, End Date, Estimated % of work - on each project separately
3. Observe the cell C5 - TOTAL HRS if it is higher than 4500 hours of experience (or 7500 hours)
4. If you have more than 4 projects on your list, copy all formulas from column G to column AR
Where is the trick? The most important information is the dates of your assignment and the % of Full Time Equivalent where 100% is full time job. All the rest gets calculated based on two splits - numbers distribution mechanisms:
a) percentage split between process groups - 10%, 30%, 25%, 25%, 10%
b) percentage split between processes within each process groups.
The meaning of each column heading has been explained in the second worksheet - process descriptions.
Other options
Of course you can change the percentage splits to reflect your your effort hours on the project. Also, you can ignore the splits and enter the detailed hours manually. I hope you will enjoy using my PMP Experience Calculation model!
ArticleSource: http://www.articlesbase.com/project-management-articles/calculating-the-hours-of-experience-for-the-pmp-application-part-3-1495225.html
About the Author:
Bogdan Gorka is an experienced Project Manager and certified Project Management Professional (PMP). Bogdan share his experience about the PMP exam in his blog, www.PMExamGuide.Net
Calculating the hours of experience for the PMP application - Part 3
Author: Bogdan Gorka
PMP Hours Calculation Sheet
I have developed a model in MS Excel to calculate the hours needed for the PMP exam application.
To use the model you need the following input data:
1. A list of non overlapping projects from the last 3 years
2. Project exact start and end dates. If it was only one or two phases of a bigger project, the dates of your assignment started and stopped.
3. Percent of time engagement on each project (e.g. 50% of your total time available) This is a minimum amount of data to use my model.
DOWNLOAD THE WORKSHEET HERE
Now all you have to do is to follow my description step by step:
1. Delete example projects - cells: B10:E13
2. Input your data: Project Name, Start Date, End Date, Estimated % of work - on each project separately
3. Observe the cell C5 - TOTAL HRS if it is higher than 4500 hours of experience (or 7500 hours)
4. If you have more than 4 projects on your list, copy all formulas from column G to column AR
Where is the trick? The most important information is the dates of your assignment and the % of Full Time Equivalent where 100% is full time job. All the rest gets calculated based on two splits - numbers distribution mechanisms:
a) percentage split between process groups - 10%, 30%, 25%, 25%, 10%
b) percentage split between processes within each process groups.
The meaning of each column heading has been explained in the second worksheet - process descriptions.
Other options
Of course you can change the percentage splits to reflect your your effort hours on the project. Also, you can ignore the splits and enter the detailed hours manually. I hope you will enjoy using my PMP Experience Calculation model!
ArticleSource: http://www.articlesbase.com/project-management-articles/calculating-the-hours-of-experience-for-the-pmp-application-part-3-1495225.html
About the Author:
Bogdan Gorka is an experienced Project Manager and certified Project Management Professional (PMP). Bogdan share his experience about the PMP exam in his blog, www.PMExamGuide.Net