Thursday, July 3, 2014

Project Planner (Advanced)

Plan your projects quickly with the new Project Planner (Advanced) template.

The template can help you to

  • Determine if and when projects will complete given each project's tasks, task duration, resource assignment to tasks, resource availability and priorities.
  • Determine if project will complete by due date
  • Prepare project, resource and task schedules at daily level
  • Understand resource utilization and identify opportunities for re-assignment to improve project completions.
  • Determine how many hours of work are still pending so that you can request more resources.
  • Estimate the cost of each project 
Project Planner Advanced Excel Template - Timeline View of Projects


Project Planner Advanced Excel Template - Plan Summary

REQUIREMENTS

Excel for Windows (2007 or 2010 or 2013)

FEATURES

  • Can plan up to 50 projects at a time and a total of 250 tasks
  • Up to 25 resources can be included in planning
  • Maximum planning period is 366 days
  • Planning is done at the granular unit of hours
  • Instantly create resource, task and project schedules
  • A project can have multiple tasks and hence multiple resources. However, each task is assigned to one and only one resource.
  • Resource can be assigned to multiple tasks on the same day.
  • Projects need to be prioritized and prioritization is followed when resources are assigned
  • Tasks within a project can also be prioritized
  • Each task can have up to two predecessors (dependencies). They can be within project or from other projects. A task can begin only the day after its predecessors have completed.
  • Project Start Dates can be restricted (optional)
  • Project due dates can be input (optional) to compute if projects complete on time
  • Choose your company holidays
  • Customize company weekends (non-working days) according to your needs
  • Each resource can have different work hours for each weekday
  • Each resource can have personal leave days
  • Each resource can have different cost per hour

BUY

You can purchase the template by using the 'Add to Cart' button below and then choose Checkout. You will be redirected by ejunkie.com to PayPal where you can use your credit card or PayPal account to purchase. You can download the file (5.4 MB) instantly after payment. An e-mail will also be sent to your e-mail address with a link that you can use to download later and the password to unlock the file. You will also receive all future upgrades of this product to your e-mail for free. If there are any questions about the purchase process, please e-mail me at indzara at gmail.com. If you are not satisfied with the product after purchase, please e-mail within 60 days and we will refund the entire amount.

US$15

Add to Cart
View Cart



HOW TO USE THE TEMPLATE

SETTINGS
Enter the list of resources, their work hours for each weekday and their costs.
Project Planner Advanced Excel Template - Resource Settings
You can choose days that are considered as weekends in your company. You can also enter company holidays. The template will not allocate any work on these days. 
Project Planner Advanced Excel Template (Customize working days)
You can enter any personal leave days for each resource. Work will not be allocated to the resource on leave days.
Project Planner Advanced Excel Template - Resource - Personal Leave
PROJECTS
Enter Planning Period Start and End Dates. Then, enter project details (Project ID, Name and Priority are required).

Project Planner Advanced Excel Template - Projects
  • If Project Priority is left blank, the project will not included in plan. If two projects are given equal priority value, the tasks are ordered based on task priority and then the order in which they appear in the TASKS table (explained below).
  • If Preferred Start Date is left blank, Planning Period Start Date will be used. If Preferred End Date is left blank, 'On Time calculation' will be set to blank.
  • Project Plan Status field will display error if there is any. If there are no errors, it will display 'Planned'.
  • Up to 50 projects can be entered.


TASKS
Enter Task details (Task ID, Task Name, Project Name, Resource Name and Hours Required).
Project Planner Advanced Excel Template - Task Details
'Task In Plan?' field will display error if there are any. If there are no errors, it will display 'Yes' if the task will be completed. It will display 'No' if the task cannot be completed.

Project Planner Advanced Excel Template - Tasks - Optional Settings 
In addition, the template provides further control. You can enter a Task Preferred Start Date that can be used if a task should not begin until a certain date.
Up to 2 predecessors can be assigned to a task. When a predecessor is assigned, the task can be started only the day after the predecessor has been completed. Similarly when 2 predecessors are assigned, the task can begin only the day after both predecessors are completed.
You can also provide task priority (priority of a task among other tasks in a project). If task priority is not provided, all such tasks in the project will be prioritized based on the order in which they are entered in the table.
Up to 250 tasks can be entered.

PLAN SUMMARY

This sheet provides summary statistics at project level and resource level. 

PROJECT SUMMARY

Project Planner Advanced Excel Template - Project Summary
  • In Plan?: If the project does not have a priority and/or tasks, then it will not be included in plan. 
  • "EARLIEST POSSIBLE START DATE = Earliest date when the project can begin, provided there are no resource limitations on the project. 
  • MAX(Project's Preferred Start Date, Planning Period Start Date, Task Preferred Start Date, Predecessor 1's Expected End Date + 1, Predecessor 2's Expected End Date + 1). 
  • IF error, then Planning Period Start Date + 366. For example, if the predecessor does not have an expected end date (meaning predecessor cannot complete), then this task cannot begin. So, it will show Planning Period Start Date + 366."
  • EXPECTED START DATE: Date when the project can actually begin, given resource limitations;
  • DELAY IN START: Days between Earliest Possible Start and Expected Start. If there is delay in a project, you can try reducing it by changing resource assignments.
  • PREFERRED END DATE: Date you would like the project to end by.
  • EXPECTED END DATE: Date when the project will end based on the assignments.
  • HOURS REQUIRED: Number of hours required for the project.
  • HOURS ALLOCATED: Number of hours allocated in the assignments.
  • HOURS PENDING: Difference between Hours Required and Hours Allocated.
  • COMPLETED?: If Hours Pending is 0, the Project will be completed. If not, it will not be completed.
  • ON TIME COMPLETION?: if the Expected End Date is on or before the Preferred End Date, then the project is 'On Time'. If not, it will be 'Not on Time'. If Preferred End Date is not set for the project, then it will be blank.
  • PROJECT SPAN (DAYS): Time between Expected Start Date and Expected End Date.
  • PROJECT COST: Total cost for all the tasks. For each task, it will be calculated as (Hours allocated * Cost per hour for resource assigned).
Project Planner Advanced Excel Template - Timeline view
RESOURCE SUMMARY


Project Planner Advanced Excel Template - Resource Summary
  • HOURS AVAILABLE: Number of Hours resource is available.
  • HOURS ALLOCATED: Number of hours allocated to tasks for a resource.
  • UTILIZATION RATE: Hours Allocated/Hours Available
  • DAYS AVAILABLE: Number of days where the resource is available.
  • DAYS ALLOCATED: Number of days the resource has been allocated work.
  • DAYS NOT ALLOCATED: Number of days the resource has not been allocated work.
  • NUMBER OF TASKS ASSIGNED: Number of tasks that a resource has been asssigned to.
  • COST: Cost for each resource. Hours Allocated * Cost per Hour
Project Planner Advanced Excel Template - Resource Utilization Rate

TASK SCHEDULES


You can view three types of task schedules. You can see tasks for one project, tasks for one resource or all tasks.

Schedule Types
Task Schedule - Project 


Task Schedule - Resource
You can also view the schedule visually. Work Allocated, Company Holidays, Company Weekends and Resource Not Available days are highlighted in different colours.
Project Planner Advanced Excel Template - Schedule
Task Schedule

RESOURCE VIEW 
In this sheet, you can view the hours available and hours allocated for every day for all the resources.







Please leave your questions and comments in the comments section below.  

Monday, June 16, 2014

Geographic Heat Map (India) - Updated with Telangana

A new state of Telangana has been created earlier this month. Our Geographic Heat Map (India) has been updated with the new state. Please visit the page to download the updated file. 
India Geographic Heat Map