Solved

Excel and Project resource Calendars

Posted on 2006-11-28
2
737 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS Project Professional 2010 5 388
Project Management advice 2 221
In Project Server 2013 where are the work exceptions stored? 1 158
Time Tracking Software for Projects 2 30
At the office, we’ve started to get serious about organizing what we’re doing. I mean, it was getting to the point where every time I received a phone call, it began with “I know you’re really busy, but…” My boss was taking tasks away from me left a…
A simple overview of the possibilities of using technology for project management.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

772 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