The Project Manager Excel template uses the following terms. This list is also provided in the template itself. The list includes user input fields and calculated ones. The calculated ones are shown in green font below.
Click to know more about the features in the template
TASKS
- TASK ID Unique Task ID (Required)
- TASK NAME Task Name (Required)
- RESOURCE NAME Name of resource assigned (Required)
- HOURS REQUIRED Work to complete task in hours (Required
- TASK DESCRIPTION Description of Task (Optional)
- TASK PREFERRED START DATE Date before which the task should not start (Optional)
- TASK PREFERRED END DATE Date by when you prefer task to be completed (Optional)
- PREDECESSOR 1 ID Task ID for first predecessor task (Optional)
- PREDECESSOR 2 ID Task ID for second predecessor task (Optional)
- TASK PRIORITY Priority of the task (Optional)
- MAX DAILY ALLOCATION % Maximum Daily Allocation % for Task (Optional)
- MILESTONE Enter M if this task is a milestone (Optional)
- HOURS REQUIRED – CHANGE How has the work effort required changed after locking Baseline Plan? (Optional)
ACTUALS
- TASK ID Task ID of task where actual work was performed
- RESOURCE Resource that performed actual work on the task
- DATE Date when actual work was performed
- HOURS COMPLETED Hours of actual work performed
- COST CHANGE Any change in cost from initial cost per hour for the resource. Enter cumulative change.
- COST Cost for performing the task = (Cost per Hour * Hours Completed) + Cost Change
PROJECT REPORT
- STATUS DATE Date as of which actual work has been performed
- PROJECT STAGE Indicator of stage of project as of STATUS DATE. Baseline Planning, Project In Progress, Project Complete
BASELINE PLAN
- STATUS Status as per Baseline Plan. Will Not Complete, Will Complete
- BASELINE START Date when project is expected to begin as per Baseline Plan
- BASELINE FINISH Date when project is expected to finish as per Baseline Plan.
- HOURS REQUIRED Total Hours required to complete the project’s tasks as per Baseline Plan
- HOURS SCHEDULED Total Hours scheduled as per Baseline Plan.
- HOURS NOT SCHEDULED HOURS REQUIRED – HOURS SCHEDULED
- RESOURCE COST Sum of cost for all resources [(Cost per Hour * Hours Scheduled in Baseline Plan)]
- OTHER COST Enter any additional non-resource cost to be incurred.
- TOTAL COST RESOURCE COST + OTHER COST
- NUMBER OF TASKS Number of rows entered in the TASKS table
- TASKS THAT WON’T COMPLETE Number of tasks that have a status ‘Won’t Complete’ in Baseline Plan
- RESOURCE UTILIZATION (Hours Utilized in Baseline Plan/Hours Available as per Baseline Plan)
- RESOURCES UNDERUTILIZED Number of resources with less than 100% utilization rate in Baseline Plan
CURRENT PLAN
- STATUS Status as per Current Plan. Will Not Complete, Will Complete
- CURRENT PLAN START Date when project is expected to begin as per Current Plan
- CURRENT PLAN FINISH Date when project is expected to finish as per Current Plan.
- HOURS REQUIRED Total Hours required to complete the project’s tasks as per Current Plan
- HOURS SCHEDULED Total Hours scheduled as per Current Plan. = ACTUAL HOURS COMPLETED as of STATUS DATE + Remaining HOURS SCHEDULED
- HOURS NOT SCHEDULED HOURS REQUIRED – HOURS SCHEDULED
- RESOURCE COST Sum of cost for all resources: Actual Cost as of STATUS DATE + [(Cost per Hour * Remaining Hours Scheduled in Current Plan)]
- OTHER COST Enter any additional non-resource cost to be incurred in Current Plan.
- TOTAL COST RESOURCE COST + OTHER COST
- NUMBER OF TASKS Number of rows entered in the TASKS table
- TASKS THAT WON’T COMPLETE Number of tasks that have a status ‘Won’t Complete’ in Current Plan
- RESOURCE UTILIZATION (Hours Utilized in Current Plan/Hours Available as per Current Plan)
- RESOURCES UNDERUTILIZED Number of resources with less than 100% utilization rate in Current Plan
ACTUAL
- START DATE Actual Start Date of Project
- FINISH DATE Actual Finish Date of Project
- HOURS COMPLETED Actual number of Hours of work completed as of STATUS DATE
- HOURS REMAINING Number of hours of work remaining = HOURS SCHEDULED in Current Plan – HOURS COMPLETED
- PLANNED VALUE Cost associated with work that should have been performed as of STATUS DATE as per Baseline plan
- EARNED VALUE Cost associated with work that has actually been performed as of STATUS DATE. Uses the cost rates in Baseline Plan.
- ACTUAL COST Actual Cost incurred for the work that has actually been performed as of STATUS DATE
- REMAINING COST RESOURCE COST in Current Plan – ACTUAL COST
- COST PERFORMANCE INDEX CPI = EARNED VALUE/ACTUAL COST
- SCHEDULE PERFORMANCE INDEX SPI = EARNED VALUE/PLANNED VALUE
- COMPLETED TASKS Number of Tasks where Actual Work performed >= Hours Required
- REMAINING TASKS NUMBER OF TASKS – COMPLETED TASKS
- RESOURCE UTILIZATION (Hours Actually Utilized as of STATUS DATE/Hours Available as of STATUS DATE)
- RESOURCES UNDERUTILIZED Number of resources with less than 100% utilization rate as of STATUS DATE
TASK REPORT
BASELINE PLAN
- BASELINE BUDGET COST Resource Cost for the task as per Baseline plan
- BASELINE STATUS Status of the task as per Baseline Plan. Will Complete by Pref Date, Won’t Complete by Pref Date, Won’t Complete
CURRENT PLAN
- EARLIEST POSSIBLE START DATE Date by which the task can begin, considering constaints (Predecessors, Task Preferred Start Date)
- PLAN STATUS Status of the task as per Current Plan. Will Complete by Pref Date, Won’t Complete by Pref Date, Won’t Complete
- FINISH VARIANCE STATUS Comparison of Current Plan’s Finish Date (CPFD) vs Baseline Plan’s Finish Date (BPFD). If CPFD>BPFD, “Behind Schedule”, If CPFD<BPFD, “Ahead of Schedule”, If CPFD=BPFD, “On Schedule”.
ACTUAL
- ACTUAL STATUS Actual status of task. Not Started, In Progress, Complete
- % OF CURRENT PLAN COMPLETE % of Work Complete. = (Actual Hours Completed/Hours Scheduled in Current Plan)*100
- ACTUAL VS BASELINE VARIANCE STATUS % of Current Plan Complete as of STATUS DATE / % of Baseline Plan complete as of STATUS DATE; On Track, Late, Ahead
RESOURCE_AVAIL
Presents the number of hours a resource is available each day. This is before any work is scheduled for the resources. This captures the standard availability, any vacation/overtime and holidays. This does not represent the unutilized time. This does not factor in post-baseline vacation/overtime.
RESOURCE REPORT
BASELINE PLAN
- HOURS AVAILABLE Hours available by a resource as of the Baseline Plan Finish Date
- HOURS SCHEDULED Hours scheduled for a resource as per Baseline Plan
- UTILIZATION RATE (HOURS SCHEDULED/HOURS AVAILABLE)*100
- COST COST PER HOUR * HOURS SCHEDULED
CURRENT PLAN
- HOURS AVAILABLE Hours available by a resource as of the Current Plan Finish Date. Includes post-baseline vacation/overtime.
- HOURS SCHEDULED Hours scheduled for a resource as per Current Plan. Includes Actual Hours of work completed as of STATUS DATE.
- UTILIZATION RATE (HOURS SCHEDULED/HOURS AVAILABLE)*100
- COST ACTUAL COST as of STATUS DATE + (COST PER HOUR * HOURS REMAINING in Current Plan)
ACTUAL
- HOURS COMPLETED Hours of Actual Work Completed by a resource as of STATUS DATE
- HOURS REMAINING HOURS SCHEDULED in Current Plan – HOURS COMPLETED
- UTILIZATION RATE (HOURS COMPLETED/HOURS AVAILABLE as of STATUS DATE)*100
- COST ACTUAL COST as of STATUS DATE
If there are any questions, please leave them in the comments. I will respond as soon as I can. Thank you.