Pmp Project Hrs Worksheet

  • December 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Pmp Project Hrs Worksheet as PDF for free.

More details

  • Words: 2,968
  • Pages: 3
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

Related Documents

Pmp Project Hrs Worksheet
November 2019 6
Pmp
October 2019 27
Pmp
December 2019 24
Hrs Directory
May 2020 14