Project Hours Worsheet for PMI PMP application
by George Brisbin
This worksheet was developed by George Brisbin to assist in completing the PMI PMP application. The original of this worksheet is located at: http://www.brisbin.name/worksheet/ I have no affiliation with the PMP certifcation process and specifically state that this worksheet has NOT been endorsed by PMI. The worsheet is provided on a user beware basis. The worksheet is crowded and a bit small - I was trading off screen space, print format and the fact there are 30 (!!) different tasks The titles used for the tasks are abbreviations of the PMP application task descriptions - you should look at the full description to ensure you understand the task The cells that YOU need to fill in are highlighted in yellow. The Hrs Worksheet is password protected: "PMP" to preserve the formulas
To use the worksheet (on the next tab - sample below): 1. Fill in the project short name (Column F) 2. Fill in the start and end dates (Column's A & B) 3. Estimate the percent of time spent on THIS project over the time period (Column C) Be careful not to work 180% of the time if your project months overlap!! Calculated hours is computed by: Total number of days between project start and finish / 7 x 5 * 8 * proj % [esitmated working hours for THIS project in a 40 hour week] 4. Set the desired AVERAGE % of time spent on each category of task (on actual worksheet Row 15, yellow cells) 5. Now comes the bulk of the data entry - for each project for each task fill in the number of hours you worked: To assist with the filling in the hours by task, underneath each type (initiating, planning, etc) is an average number of hours for the tasks in that category (e.g. There are 5 tasks in the Initiating group, so the average per task = Calculated hours for that project x the average % of time spent on Initiating / 5 tasks) The sample values are highlighted in green below
6. There are a couple of checks and balances in the far right hand columns. If you enter more hours than are calculated in Column D the Total Hrs (Column AV) turns pink. The Total Hrs for all projects turns green when the sum is greater than the required hrs (AV15). This has been prefilled as 4,500 for PMP, Degree qualified applicants.
01-Apr-05 30-Jun-05 01-Nov-04 28-Feb-05 01-Jul-04 31-Mar-05 01-Apr-04 30-Jun-05 01-Feb-01 30-Sep-01 01-Dec-00 28-Feb-01 01-Jun-00 30-Nov-00 01-Jun-99 31-Jul-00 01-Oct-98 31-May-00
70% 65% 45% 25% 50% 90% 80% 10% 65%
360 442 702 650 689 458 832 243 2258 0 6634
XXX 1 XXX 2 XXX 3 XXX 4 XXX 5 XXX 6 XXX 7 XXX 8 XXX 9 XXX 10 TOTAL Hrs
XXX 1 XXX 2 XXX 3
132
th
ev
e
| 4 8 16 8 16 6 20 10 48
Total
D
ef in D
| 8 4 16 4 8 6 15 7 64
e al sc ys el op is op pr e Id o en je tif ct y ch hi ar gh te le r ve lr is ks ,e tc
ol eh
y ke
tif y
ct
1 2 3 4 5 6 7 8 9 10
Project Short Name
en
#
Id
du
Estimated % Wk on Calculated Proj wk Hrs
on
Proj End
C
Proj Start
Pr
oj
st
ec
ak
tS
el
ec
de
tin
rs
g
&
m
an
et
ho
ds
Initiating
| 16 8 18 8 16 12 16 4 48
136 146 Initiating
| 4 16 12 8 12 8 22 4 32 118
| 4 2 8 16 13 10 12 4 20 89
%
36 38 70 44 65 42 85 29 212 0 621
#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 10%
Average hours per item Total hrs for phase 7 36 9 44 14 70
This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike2.5 License. To view a copy of this license, visit http://creativecommons.org/licenses/by-nc-sa/2.5/ or send a letter to Creative Commons, 543 Howard Street, 5th Floor, San Francisco, California, 94105, USA. http://creativecommons.org/licenses/by-nc-sa/2.5/
01-Jan-09 12-Jan-09 19-Jan-09 02-Feb-09 09-Feb-09 16-Feb-09 23-Feb-09 02-Mar-09 09-Mar-09 16-Mar-09
Proj End 10-Jan-09 17-Jan-09 24-Jan-09 07-Feb-09 14-Feb-09 21-Feb-09 28-Feb-09 07-Mar-09 14-Mar-09 19-Mar-09
Estimated Calcul % Wk on ated Proj wk Hrs 20% 20% 30% 30% 30% 20% 20% 30% 30% 30%
#
10 1 6 2 9 3 9 4 9 5 6 6 6 7 9 8 9 9 5 10 75
Executing
Controlling
Closing
Project Short Name Part1 Part2 Part3 - Sec4,5,6 Part3 - Sec7,8,9 Part3 - Sec10,11 Part1 Part2 Part3 - Sec4,5,6 Part3 - Sec7,8,9 Part3 - Sec10,11 TOTAL Hrs
Part1 Part2 Part3 - Sec4,5,6 Part3 - Sec7,8,9 Part3 - Sec10,11 Part1 Part2 Part3 - Sec4,5,6 Part3 - Sec7,8,9 Part3 - Sec10,11
| 4
| 3
4
| 5
3 5 Initiating
| 5
Total
| 3
5
3
%
20 100% 0 ### 0 ### 0 ### 0 ### 0 ### 0 ### 0 ### 0 ### 0 ### 20 100% 10%
|
|
0
Average hours per item Total hrs for phase 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1
|
0
|
0 0 Planning
|
Total
|
0
0
0 0 0 0 0 0 0 0 0 0 0
Avg Total 1 3 0 2 0 3 0 3 0 3 0 2 0 2 0 3 0 3 0 2
%
0% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0% 30%
|
|
0
|
0
|
0
|
0 0 Executing
|
|
0
Total
|
0
0
0 0 0 0 0 0 0 0 0 0 0
Avg Total 0 3 0 1 0 2 0 2 0 2 0 1 0 1 0 2 0 2 0 1
%
0% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0% 25%
|
|
0
|
Total
|
0 0 Controlling
0
0 0 0 0 0 0 0 0 0 0 0
Avg Total 1 3 0 1 1 2 1 2 1 2 0 1 0 1 1 2 1 2 0 1
%
0% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0% 25%
|
|
0
|
0
|
0 0 Closing
|
|
0
Total
|
0
0
0 0 0 0 0 0 0 0 0 0 0
Avg Total 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 1
TOTAL HRS
Proj Start
Planning
C on du ct Id en Pro je tif ct y ke Se y le st ct ak in eh g D m o ef l et d i er ho D ne s ds ev th & el e s a na Id op c en p op lys tif ro e is y hi ject gh c le har ve te lr r is ks Id ,e en tc tif y ke y pr D oj ef ec in tt C e ri ea O rbe sk m taate s m D in W tra br ef st t e s, in aBkS g ro e i & eho es le & s re ld m co er an rd 's D ev pr pro age el oj je m op ec c t d t p ent C ha pl et lan an ai ng ls ap e w pr M ith ov an st al ag ak em eh en ol de tP rs la M n Exana ec ge C ute res o Im mm tas ouc pr u ks e ov nic de all e at finoc a te e am w ed tio i i n Im peth s n p pl t r em fo ak roje rm eh ct en an ol p t aQ O ce de lan pup bt : l rs arlo ai itvy ea & n eMd di tea pr ng m mc oj haan ec ,t ra nag tr in es esm in ou g, p e enr rc et M t es Cpl c iti h aan ga IA n W te ge pr pr M oj oc gm ec ur tr nt em is Pl en ks an tp Ve la rif n M y& ea m su a re na pr ge oj c ec ha En t p ng su er es fo t re rm o de M an sco l iv on ce pe e ra ito ,t bl rr im e is e co ks & nf co or st m pe to rp qu la al IFdor n ity enm st itaf li a y,ze nd dofi ar cnua ds ml a ARr O encc bect e t , cp lehaivn t oamn asef ei&na mce alrne unfo l pctai icr p raoinl, at ro j rpler leje esgoaj ssct C oeulc& on Mrea rct rae es te s esdc le ur & m o ar e d & ridn ne cu is prsp d st trib o vroi je om u dec erte f pt ecl saina rofos tis l p mure fa r o an ct je ce io c n tr fe at ep ed enor ba dt ck of pr oj ec t
Initiating
%
0% Part1 #DIV/0! Part2 #DIV/0! Part3 - Sec4,5,6 #DIV/0! Part3 - Sec7,8,9 #DIV/0! Part3 - Sec10,11 #DIV/0! Part1 #DIV/0! Part2 #DIV/0! Part3 - Sec4,5,6 #DIV/0! Part3 - Sec7,8,9 #DIV/0! Part3 - Sec10,11 0% TOTAL Hrs 10% Rqd Hrs
Part1 Part2 Part3 - Sec4,5,6 Part3 - Sec7,8,9 Part3 - Sec10,11 Part1 Part2 Part3 - Sec4,5,6 Part3 - Sec7,8,9 Part3 - Sec10,11
Calculat ed Hrs 20 0 0 0 0 0 0 0 0 0 20 4,500
10 6 9 9 9 6 6 9 9 5 75
Initiating
360 1 442 2 702 3 650 4 689 5 458 6 832 7 243 8 2258 9 0 10 6634
XXX 1 XXX 2 XXX 3 XXX 4 XXX 5 XXX 6 XXX 7 XXX 8 XXX 9 XXX 10 TOTAL Hrs
XXX 1 XXX 2 XXX 3 XXX 4 XXX 5 XXX 6 XXX 7 XXX 8 XXX 9 XXX 10
This work is licensed under the Creative Commons AttributionNonCommercial-ShareAlike2.5 License. To view a copy of this license, visit http://creativecommons.org/licenses/by-nc-sa/2.5/ or send a letter to Creative Commons, 543 Howard Street, 5th Floor, San Francisco, California, 94105, USA.
http://creativecommons.org/licenses/by-nc-sa/2.5/
y
nt if
Project Short Name
Controlling
Closing
st a
TOTAL HRS
#
Executing
ke y
ec tS
70% 65% 45% 25% 50% 90% 80% 10% 65%
du ct P
ro j
01-Apr-05 30-Jun-05 01-Nov-04 28-Feb-05 01-Jul-04 31-Mar-05 01-Apr-04 30-Jun-05 01-Feb-01 30-Sep-01 01-Dec-00 28-Feb-01 01-Jun-00 30-Nov-00 01-Jun-99 31-Jul-00 01-Oct-98 31-May-00
Estimated Calcul % Wk on ated Proj wk Hrs
Id e
Proj End
C on
Proj Start
Planning
el ec tin ke g ho D m ef l et de i ho rs D ne ds ev th & el e s a na Id op c en p op lys tif ro e is y hi ject gh c le har ve te lr r is ks Id ,e en tc tif y ke y pr D oj ef ec in tt C e ri ea O rbe sk m taate s m t D in W ra br ef st s, in aBkS teg ro e ie e s & ho le & s re ld m co e a r r ' D d s p na ev pr ro g oj je em el ec c op t d t p ent C pl ha et lan a ai ng ls ap n e w pr M i t h ova an s ag ta l ke em ho en ld tP er l s a M n Exana ec ge C ute res o Im mm taskouc pr u s ea d ov ni e cat efinlloc a te e am w ed tio i i n Im peth s n p pl rfo ta roj em ke ec r en m h an ol t pl t aQ O ce de an pup bt arlo : l rs ai i ea & tvy n e di tea M pr dm ng m oj c haan ec ,t ra nag tr in es esm in ou g, p e enr rc et M t Cp es c iti lhaa ga IA n ng W te e pr pr M oj oc gm ec ur tr nt em is Pl en ks an tp Ve la rif n M y& ea m su a re na pr g e oj c ec ha En t p ng su er es fo t re rm o de M an sco liv on ce pe er ito ab ,t rr im le is e co ks & nf co or st m pe to rp qu FI o la a lit derm n y ni a s tfyliz ta nd , de ar ofcin ds uaml aec ARr O nct e ebclthai , cpota eavne mnc sefi&n me aalrne unfo l pctai icr p roainl, atro j rpler leje esgoaj ssct C e oulc& on Mrea t rc rae es te s e dcm le ur & s o ar e d & ridn ne cu is prsp d st trib o vroi je om u dec erte pt ecl safina rfoos tis l p mure fa ro an ct je ce io c n tr fe at ep ed o en r ba t d ck of pr oj ec t
Password = PMP : Enter your own data in the yellow cells
| 8 4 16 4 8 6 15 7 64
| 4 8 16 8 16 6 20 10 48
| 16 8 18 8 16 12 16 4 48
| 4 16 12 8 12 8 22 4 32
| 4 2 8 16 13 10 12 4 20
132
136 146 118 89 Initiating
Total
36 38 70 44 65 42 85 29 212 0 621
%
| 4 12 27 8 30 20 40 8 104
| 50 60 50 10 47 32 45 18 88
| | | 8 4 24 10 24 16 35 40 45 12 14 10 35 25 40 24 16 24 50 45 50 16 9 10 112 112 112
| 8 4 15 40 30 16 24 12 96
Total
%
| 8 4 30 16 25 16 24 2 72
| 32 80 20 120 30 36 40 16 80
| 16 10 30 24 35 6 24 12 64
| 4 2 25 16 12 4 16 8 40
| 6 10 16 4 17 8 8 2 40
| 4 4 12 32 15 16 16 8 48
| 7 4 24 8 12 4 24 4 56
| 8 2 16 24 14 18 24 4 64
Total
%
| | | | 25 30 16 20 27 35 10 35 40 45 35 50 30 30 25 30 32 48 45 30 35 32 24 24 68 56 48 48 24 16 8 10 160 168 160 140
10% 98 28% 85 24% 9% 126 29% 116 27% 10% 212 30% 173 25% 7% 94 15% 244 39% 10% 207 32% 160 25% 9% 132 29% 108 24% 10% 254 31% 176 21% 12% 73 30% 56 23% 10% 624 29% 464 22% ### 0 #DIV/0! 0 #DIV/0! 10% 253 400 302 289 331 245 1820 28% 197 454 221 127 111 155 143 174 1582 25% 441 460 371 387 10% Planning 30% Executing 25% Controlling
Average hours per item Total hrs for phase 7.2 36 ### 44.2 ### 70.2 13 65 ### 68.86 ### 45.77 ### 83.2 ### 24.34 ### ### 0 0
Avg 18 22.1 35.1 32.5 ### ### 41.6 ### ### 0
Total 108 132.6 210.6 195 ### ### 249.6 73.03 ### 0
Avg ### ### ### ### ### 14.3 26 7.61 ### 0
Total 90 110.5 175.5 162.5 ### ### 208 60.86 ### 0
Avg 22.5 ### ### ### ### ### 52 ### ### 0
Total
%
| | | 4 4 5 8 5 6 12 8 8 24 32 16 10 8 8 12 5 7 16 8 8 8 4 0 48 40 24
| 12 18 16 24 9 5 16 0 32
| 4 2 8 2 7 6 16 4 24
| 8 5 8 8 10 16 8 4 20
| 4 2 16 16 8 8 12 4 16
Total
%
91 26% 41 12% XXX 1 107 25% 46 11% XXX 2 170 24% 76 11% XXX 3 115 19% 122 20% XXX 4 155 24% 60 9% XXX 5 115 25% 59 13% XXX 6 220 27% 84 10% XXX 7 58 24% 24 10% XXX 8 628 29% 204 10% XXX 9 0 #DIV/0! 0 #DIV/0! ### 26% 142 114 82 132 73 87 86 716 11% TOTAL Hrs 25% Closing 10% Rqd Hrs Total 90 ### ### ### ### ### 208 ### ### 0
Avg ### ### ### ### ### ### ### ### ### 0
Total 36 44.2 70.2 65 ### ### 83.2 ### ### 0
XXX 1 XXX 2 XXX 3 XXX 4 XXX 5 XXX 6 XXX 7 XXX 8 XXX 9
Calculat ed Hrs 351 433 701 619 647 456 819 240 2132 0 6,398 4,500
360 442 702 650 689 458 832 243 2258 0 6634