
This work is licensed under a Creative
Commons Attribution-NonCommercial-ShareAlike2.5 License.
| Download: Project Hours Worksheet :Download
To use the worksheet (on the 2nd tab of the worksheet - 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 more than 100% of the time if your project months overlap!! Calculated hours is computed by: Total number of days between project start and finish / 7(wks) x 5(days) x 8(hrs) x Proj % [esitmated working hours for THIS project in a 40 hour week] 4. Set the desired AVERAGE % of time spent on each process group (on the actual worksheet Row 15, yellow cells - pre-filled with standard values) 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 process group (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. ![]() This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike2.5 License. |
|