• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 849
  • Last Modified:

Excel and Project resource Calendars

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
NickVerreault
Asked:
NickVerreault
2 Solutions
 
harisrashidCommented:
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
 
winzigCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now