Solved

Excel and Project resource Calendars

Posted on 2006-11-28
2
754 Views
Last Modified: 2013-11-15
Howdy experts,

So here's my question. I have a resource list in Excel, with 40 people on it.  This spreadsheet also doubles at a calendar of availability for the month. (each column corresponds to a day of the month) and the contents of each cell represents his/her availability (a letter in each cell corresponding to a legend).

I have imported the names of the resources, however, I cannot seem to find a way to convert the excel calendar into each individuals availability calendar in Project.  Is there an automated way to do this or would i have to use a Macro or programming in VBA?  

Hopefully there is a way to do this without VBA code.  Any suggestions out there?

Cheers

-Nick
0
Comment
Question by:NickVerreault
2 Comments
 
LVL 10

Accepted Solution

by:
harisrashid earned 400 total points
ID: 18039315
hi Nick,

There is no way to do it other than to write VBA code.

For each resource you enter, Project creates individual resource calendars based on the settings in the Standard calendar. You can modify those calendars on the Working Time tab of the Resource Information dialog box. You can also create and assign resource calendars for individual resources or resource groups to indicate specific working hours; for example, you can assign a resource to the swing shift or night shift. You can edit resources' calendars to indicate nonworking time, such as vacations and leaves of absence.

Regards,

Haris


0
 
LVL 10

Assisted Solution

by:winzig
winzig earned 100 total points
ID: 18041499
Hi Nick,

There is'n  other way haw to edit resource calendar, but there iannother aproach can track non working time in administrative projects.
http://office.microsoft.com/en-us/project/HA011038751033.aspx

+ you can use PDS to enter information about non working time.



0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: x-men
Where used to see Gantt charts for illustrating project timelines, but what if I wanted to visualize passed timed events? Here's how.
Online collaboration is quickly becoming embedded in the workplace, and its benefits are tangible. See what the current landscape looks like and what the future holds for collaboration tools and the future of work.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question