Solved

Excel and Project resource Calendars

Posted on 2006-11-28
2
778 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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

Suggested Solutions

Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
A simple overview of the possibilities of using technology for project management.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

732 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