Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

previousPrevious article   Next articlenext back to categoryMS Project articles

article How To Create A Resource Calendar In Project 2007

As you build your skills in using Project 2007 you'll have created project plans using tasks and resources. Project uses the same project calendar for tasks and resources, but did you know you can create separate calendars for each resource? This article describes how to do this in clear easy to follow steps.
As you build your skills in using Project 2007 you'll have created project plans using tasks and resources. Project uses the same project calendar for tasks and resources, but did you know you can create separate calendars for each resource? This article describes how to do this in clear easy to follow steps.

Launch Microsoft Project and the Gantt Chart view opens. Here you can add task names and durations and then create relationships between tasks to create your project schedule. The next step is to add project resources using the Resource Sheet. Here you enter the resource name and other details such as maximum number of units and cost. You'll see that the last column tells you that the resource calendar is based on STANDARD. We can however amend the calendar for each resource.

The resource we want to create the calendar for must be in the Resource Sheet. Once this is done you click the TOOLS menu bar at the top of the screen and choose CHANGE WORKING TIME. In this panel you can create new calendars, amend existing calendars, and you can also edit the Standard Project calendar.

If you've added one or more resources to the Resource Sheet, Project automatically creates a calendar for each resource, based on the STANDARD calendar. To see these, click the pop down to the right of "For Calendar" and you'll see each new resource listed. Select the one you want and the details appear lower in the panel. If you select any date in the miniature calendar you'll see, on the right, a summary of the working hours for that date. You can also see that some days are clear, and others are greyed. The clear ones are working days and the grey ones are non-working days.

Under the miniature calendar in the Change Working Time panel are two tabs, Exceptions and Work Week. The Exceptions tab is used to add details such as holidays or other planned absences. The Work Week tab is used to amend the daily working hours pattern. We'll now look at how each panel is used.

Suppose you want to add a week's holiday detail for the resource. To do this select the Exceptions tab and under "Name" type an appropriate label such as HOLS. Then choose the start date and end date in the boxes to the right, on the same line. Then click once on the next row down to ensure the data is entered. The calendar miniature will now show these dates as greyed out, indicating non-working days.

Next suppose you also want to change the default working hours for this resource, for example to only be available 1pm to 5pm each day rather than the Project default of 8am to 5pm (with an unpaid lunch hour). To do this choose the Work Weeks tab and select the Default row. Then click the DETAILS button just to the right in the panel. In the "Details for Default" panel you can set the specific working days and working hours required.

To do this, in the left side of the panel select all the days Monday to Friday. You can use the Shift or CTRL key with the mouse to select multiple days. Then choose the option "Set day(s) to these specific working hours" option. We'll set the FROM as 13:00 and the TO as 17:00 and please note you need a colon between the hours and minutes. Now click down one row to ensure the data is added and click OK to return to the Change Working Time panel, then click OK to complete.

Now if we assign that resource to one or more tasks in the project plan, the tasks will only be carried out when the resource is available. So with our resource only available in the afternoons for four hours, task durations will increase to accommodate this. So if a task originally had a duration set to one day or eight hours, and we assign our new resource which is only available four hours per day, then the task duration will change to two days, even though the actual work is still only eight hours.

Hopefully this short article has given you a brief insight into the many details behind the scenes in Microsoft Project 2007. If you're interested in finding out more you might like to consider attending a training course. There are lots available and the best ones give you lots of practical exercises with top class guidance. That way you can really boost your skills in using Project.

Author is a freelance copywriter. For more information on ms project training in london, please visit http://www.microsofttraining.net


Original article appears here:
http://www.microsofttraining.net/article-1879-how-create-resource-calendar-in-project-2007.html


Back to article list

Distribution notes

PUBLICATION GUIDELINES

  • You have permission to publish this article for free providing the "About the Author" box is included in its entirety.
  • Do not post/reprint this article in any site or publication that contains hate, violence, porn, warez, or supports illegal activity.
  • Do not use this article in violation of the US CAN-SPAM Act. If sent by email, this article must be delivered to opt-in subscribers only.
  • If you publish this article in a format that supports linking, please ensure that all URLs and email addresses are active links, without the rel='nofollow' tag.
  • Software Training London Ltd. owns this article. Please respect the author's copyright and above publication guidelines.
  • If you do not agree to these terms, please do not use this article.


Microsoft Office courses London
Course rating
4.7 stars - based on 829 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom