Copy resource working times to new resource pool.

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Project
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Resources confusion I allways have trouble with this and am hoping someone can help me. if i have resource A and i schedule them to work 6 hrs a day on a project that lasts 1 weeks. On the LAST day of the project my resource only needs to work 4 hours i.e. my total work estimate was 20 hours. Does anyone know how i can make it so that on the last day of the project, they are working only 4 hrs. i.e. from resource usage 1 2 3 4 5 resource A 6 6 6 6 6 i want it to be 1 2 3 4 5 resource A 6 6 6 6 4 I don't want it to be 1 2 3 4 5 resource A 5.2 5.2 5.2 5.2 5.2 thnaks Tag: Copy resource working times to new resource pool. Tag: 98501
  - 2
    - Change Tracking Hi, I'm in the process of creating a new plan and am wanting feedback from some of my team. Was wondering if there's a tool somewhere that would allow me to see the changes they have made and then either accept or decline them. Kind of like what's available in Word. Failing that, if anyone can offer any suggestions on how I tell what changes have been made, that would be great. Thanks, M Tag: Copy resource working times to new resource pool. Tag: 98500
  - 3
    - how to make a macro run other macros Hello, I'm using Project 2003 and have stored four macros in my global.mpt. Ea macro saves off some data into a .csv file. Ea macro runs successfully when invoked by itself. After creating the four macros, I then used the GUI (as I had done with the earlier macros) to create another macro that would run the four macros in succession. It appeared as if I was successful (nothing squacked at me in the GUI) while recording this macro. But, when I tried running the macro, nothing happened. Or, more to the point, I clicked Run in the Macros dialog and the focus within the macro list jumped to the top of the macros list and the app temporarily became unresponsive. I had to click Cancel three or four times to dismiss the dialog. When I looked at the VBA, this is what I had: Sub Pubs_All() ' Macro Pubs_All ' Macro Recorded Wed 2/15/06 by Me. Macro Macro Macro Macro End Sub Which certainly looked suspect. . . Having done something similar in Excel that I know works, I went over there and had a look at that macro's code: Sub Pubs_All() ' ' Pubs_All Macro ' Macro recorded 2/15/2006 by Me ' ' Application.Run "PERSONAL.XLS!Pubs_one" Application.Run "PERSONAL.XLS!Pubs_two" Application.Run "PERSONAL.XLS!Pubs_three" Application.Run "PERSONAL.XLS!Pubs_four" End Sub So, I thought I'd be clever and copy that code into the Project VBA editor, modifying it slightly like so: Sub Pubs_Test() ' ' Pubs_Test Macro ' Macro copied from Excel 2/15/2006 by Me ' ' Application.Run "GLOBAL.MPT!Pubs_one" Application.Run "GLOBAL.MPT!Pubs_two" Application.Run "GLOBAL.MPT!Pubs_three" Application.Run "GLOBAL.MPT!Pubs_four" End Sub Clicking Run in the Macros dialog now closes the dialog (no weird unresponsiveness), but no .csv files are getting produced. Anyone have any ideas? Thanks in advance. Tag: Copy resource working times to new resource pool. Tag: 98491
  - 4
    - How do I view Project tasks in format similar to Outlook Calendar I am trying to use Microsoft Project 2003. I have set up my tasks, but don't really like the limited calendar views in Project. I'd rather have views similar to those in Outlook Calendar, where I could look at my tasks one week at a time, with information on what to do each hour. It appears, from looking at the Gantt chart, that Project has actually scheduled my tasks on an hourly basis, but the format is hard to view. Is there a way to either export my Project tasks to Outlook, or get it to a format similar to that in Outlook? PS I realize I could list the tasks in Outlook, but would rather be able to track progress and update schedules accordingly. Thank you. Tag: Copy resource working times to new resource pool. Tag: 98490
  - 5
    - Un-install Trial version of Project Have had MS Project Trial version installed ... now expired. Now trying to install new MS Project software and a note comes up to uninstall trial version. Have removed program via 'add/remove programes' in windows control box, rebooted as asked to, have check 'add/remove' and it does not show any more, but when I try to install my new software it still comes up as 'trial version present, remove and start again' ... can any body help? -- NCBB ------------------------------------------------------------------------ NCBB's Profile: http://forums.techarena.in/member.php?userid=13772 View this thread: http://forums.techarena.in/showthread.php?t=461432 Free Computer Help - http://forums.techarena.in Tag: Copy resource working times to new resource pool. Tag: 98481
  - 6
    - Import This may be simple I'm new. How do I import a document (word, pdf, e-mail) tied to an event? Tag: Copy resource working times to new resource pool. Tag: 98480
  - 7
    - No task to finish on the weekend? Hello, How do I set Sat and Sun as working time, but not allow any task to be due/finish on a Sat or Sun? So the task can take place over the weekend, but it must finish on a Monday. Thanks Tag: Copy resource working times to new resource pool. Tag: 98475
  - 8
    - Linking two tasks not in the same project Can I link two tasks that are not in the same project w/ having Project Server? I am using Project 2000. Tag: Copy resource working times to new resource pool. Tag: 98471
  - 9
    - Linking tasks not in the same project Can I link two tasks that are not in the same project w/ having Project Server? I am using Project 2000. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=be98868a-9e6b-4aa4-aa08-282a0174d585&dg=microsoft.public.project Tag: Copy resource working times to new resource pool. Tag: 98468
  - 10
    - VBA Macro for MSPP 2003 I am wondering if it is possible to write a VBA Macro that will copy an MSExcel Worksheet into MSPP2003. the Excel worksheet consists of a combined estimate sheet from four different departments with in our company. The four different departments are totalized so only one column of estimated hurs will have to be read/copied, however, (this is the real crux of the problem), when osting to our standard MSPP template the hours must be distributed by perctentage of total hours and probably up to a maximum of 7 different resource types for each task. I plan on using some generic resource place holders, once the plan is prepared I will assign resources from our Enterprise Resource Database. Will this be possible to using VBA? I appreciate any help or suggestions. Thank you, Mike B Tag: Copy resource working times to new resource pool. Tag: 98467
  - 11
    - Re: Outlook Add-In I found the solution to this issue. You have incorrect Internet Explorer security settings. To resolve this issue, follow these steps: 1. Start Internet Explorer, and then click Internet Options on the Tools menu. 2. Click the Security tab, and then click Trusted sites. 3. Click Custom Level 4. Click the Automatic logon with current username and password button. 5. Click OK. Mervin Williams "Mervin Williams" <mwilliams@innovasolutions.net> wrote in message news:... >I am running Microsoft Office Project 2003 and have setup a location on our >Sharepoint Services service to host Project Web Access. I have just >installed the Microsoft Outlook Add-In for Project Web Access. All works >fine, except when I click either the 'Import New Assignments' or 'Update >Project Web Access' options, I receive the error message - "Login Failed." > > Has anyone successfully resolved this issue? > > Mervin Williams > Tag: Copy resource working times to new resource pool. Tag: 98461
  - 12
    - Simple Report / View How do I create a report that shows total resource usage in hours per resource per a specific project (the one that I opened). I'd like to see the total monthly Work planned for each resource for a specific project and the Actual Work reported on this timesheet. At the moment the view/report shows me ALL the tasks a resources is assigned to for ALL the projects running. Tag: Copy resource working times to new resource pool. Tag: 98456
  - 13
    - Resource usage report I would like to get resource usage report with task allocation information, with only one row per resource and with task names in cells (instead of work in cells). Default is work in cells, with every resource having additional rows for every task appointed, which makes report too long. Can this be done? Perhapse with export to Excel or with some add-in tool? thanks, Blaz Tag: Copy resource working times to new resource pool. Tag: 98441
  - 14
    - Neck bars for non-work days? Is there a way to neck the duration bars to show non-work days? I have 2 crews working the same task. They are working 4-on 4-off schedules. I want to show the days they work and don't work and how they interact with each other. Tag: Copy resource working times to new resource pool. Tag: 98438
  - 15
    - Hiding task bar for nonworking time on an individual basis I know how to make the taskbar hide behind nonworking time (Format - Timescale - Non-working time - Draw in front of task bars), but I can't specify this on a resource-by-resource basis. So I have a contractor who only comes in 2 days a week, but her task bar spans a full 5-day work week, making it look like she's in all week. I can explain to my clients why that is, but it still causes confusion. Is there a way I can hide/obscure/nuke the taskbar for nonworking days for each resource's schedule? Thanks. Tag: Copy resource working times to new resource pool. Tag: 98436
  - 16
    - Neck Bars for Non-Work days? Is there a way to neck the bars to show non-work days? I am using 2 different crews that are working 4 days on and 4 days off. I need to show how they will be interacting with each other. Tag: Copy resource working times to new resource pool. Tag: 98434
  - 17
    - Project ASAP/ALAP dates at the same time. I want to be able to see the ASAP dates and ALAP dates at the same time without needing to make two passes. If ASAP date and ALAP dates are different this means not crtical path task that can be performed anytime within the difference window. For example if I want to schedule a constrained resource it nice to be able to see the date range that will allow me to succesfully finish the task and allow the scheduler of that equipment the maximum flexiablity. Currently Project does allow you to create this date range but to do so I must go and change all the constraint type and set the Project inforamtion to the correct finish date and re-calculate. However it is possible to see both at the same time without making two passes. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=67fefa90-c4be-4e51-93dd-d26b045a07cb&dg=microsoft.public.project Tag: Copy resource working times to new resource pool. Tag: 98430
  - 18
    - Printing Issue I will say before I ask this question that I might be going about this incorrectly. The company I work for handles multiple projects at the same time, I am sure most companies are like this. For the most part, all of the jobs run through multiple departments, and the majority of the projects use the same departments with only one or two exceptions. What I am trying to do is to create seperate projects for each department and then combine them. From what little training that I have had, this should work, but this is not my issue. My issue is that when I go to print out the different Gantt Charts for the different department, they print to different sizes. I went through the Print window and did not find anything that I thought would fix this issue. Has anyone had this issue before? Any help would be greatly appreciated. Thanks!!!! -- Cris Ward Critical Path Manager cris@raydeo.com Tag: Copy resource working times to new resource pool. Tag: 98429
  - 19
    - Assignment Units on the Resource Usage view I have a question about the Assignment Units column in the Resource Usage view in Project Pro 2003. It seems that this field behaves as a resource (future) allocation percentage until Actual Work is posted against a task, then it behaves as a high-water mark resource (current) utilization percentage. It seems that this field will go up but not down, and cannot always be modified once Actual Work is entered. I have the need to be able to either: 1) reset this column to reflected adjusted allocation percentages, or 2) use this figure to predict future resource allocations for each task. Any suggestions would be appreciated. Tag: Copy resource working times to new resource pool. Tag: 98428
  - 20
    - importing documents into project It's been a long time since I have used project. How do I take a word document or e-mail and tie it to an event in project Tag: Copy resource working times to new resource pool. Tag: 98422
  - 21
    - Scheduling a class I've two classes to schedule for a group of people. I must have lost my undertstanding of fixed duration, effort driven, etc. I set the first class to must start on the class start date and fixed duration to the 1 day for the class. Then I add the resources who will be out 8h per day for it. When I add the 2nd and 3rd attendee it changes my duration to 2 days. If I change the duration back to 1 day it removes the 8 hours from the first two resources. How do I schedule classes like this? Tag: Copy resource working times to new resource pool. Tag: 98408
  - 22
    - How do I customise the BAR descriptive legend at the bottom of a Tag: Copy resource working times to new resource pool. Tag: 98406
  - 23
    - Formula Question Hey, So I go to Custom Fields (Tools-Custom-Fields) then I choose Task as field and Number as type. My formula is [Predecessors] > [ID] Here is the question, if the Predecessors field has more than one Predecessor listed for a tasks, is there something I need to alter so the formula will look at each Predecessor within that one tasks seperate? Also if I have created a lag or lead on a task do I need to modify the formula to accomidate for that? Any thoughts? Cole Tag: Copy resource working times to new resource pool. Tag: 98401
  - 24
    - Can I use multiple resource pools? I want to reflect and roll up the group organisation structure in my company. I'd like group managers to hold resource pool info for their teams individually, and then allow projects to resource from them. Is this possible? I seem to only be able to find descriptions of a single central resource pool..... Ta John Tag: Copy resource working times to new resource pool. Tag: 98394
  - 25
    - Project 2002 vs. 2003, and Standard vs. Professional The Microsoft website has detailed information comparing Project 98 and 2000 to 2003, but no references I can find comparing 2002 to 2003. Is there a list of changes available somewhere? Also, can someone using 2002 open a file saved in the 2003 format without having to save the file in a different format? Finally, is the ONLY difference between the 2003 Standard and Professional versions that Professional works with Project Server and Web Access, or are there other features that differentiate the two. I have several users that have 2002 Professional installed who are reluctant to upgrade to 2003 Standard (we don't use Server), and I want to be sure I'm not misguiding them by suggesting that they do the upgrade. File incompatibility or a loss of features from 2002 Professional to 2003 Standard will not go over well. Thanks, DanG Tag: Copy resource working times to new resource pool. Tag: 98391
- Next
  - 1
    - How do I extend the calendars for dates before 1/1/84? I wish to undertke some historical analysis - and require the calendars to cope with dates from 1962 through to 2006. The current configuration of the MSProject calendars limits dates to between 1984 and 2049. Is there a way of extending the calandar range? Tag: Copy resource working times to new resource pool. Tag: 98386
  - 2
    - Append Date to filename in macro Hello! I am trying to use a macro to export to excel using a export map. I want to add todays date to the file name, so it doesnt overwrite existing files, is this possible? Or, perhaps a pop-up to ask me the file name? when project discovers a file of the same name, it says "overwrite?" if you click cancel the macro fails, with no option to enter an altenative filename. Please help! Christina Tag: Copy resource working times to new resource pool. Tag: 98385
  - 3
    - arabic language My name is Ellen I would like to ask you how can i write in arabic language (right-to-left written)? I mentionate that i have windows xp proffessional I would appreciate your prompt reply Best regards, Ellen Tag: Copy resource working times to new resource pool. Tag: 98382
  - 4
    - Changing Project Server email notification content Hello, How can I remove the text "Below are the latest schedule changes. Contact your project manager if there are any problems with the changes." that the users receive in the alerts / notifications? I couldn't find this text in the MSP_WEB_CONVERSIONS and / or MSP_CONVERSIONS table. Thank you and, Best regards Tag: Copy resource working times to new resource pool. Tag: 98380
  - 5
    - Physical %complete not getting updated in summary level according. why isnt Physical %complete filed value is not getting updated in summary level according to the subtasks' value.is there any way to get it updated in the summary level Tag: Copy resource working times to new resource pool. Tag: 98377
  - 6
    - Travel Planning My Company is about to commence a large project, and we will need to move people all around the world, to several diferent destinations, and manage and schedule meetings and everone's availability. This can be a very confusing and complex task. I cannot find any software that specifically addresses this issue, but thought that as it was basically resource management, perhap someone had written an application to do this in Project.... Can anyone help ? Tag: Copy resource working times to new resource pool. Tag: 98374
  - 7
    - Progress line doesn't highlight ahead activities [by right outde. Progress line does not make a right-ward dent to show an activity is ahead. It only show a left-ward dent to show an activity is behind schedule. How do I fix this? Tag: Copy resource working times to new resource pool. Tag: 98373
  - 8
    - Changing Predecessor not updating start date I've had this problem before. If I change a predecessor for a task, the start date does not get updated with the predecessor's finish date. I am using MS Project 2003 Profession SP2. Any help is appreciated. Thanks Tag: Copy resource working times to new resource pool. Tag: 98366
  - 9
    - Task duration as a percentage of a predecessor Hi, I have projects where certain tasks must be performed after an initial task is completed. I am trying to create a template that can estimate the total time it will take to complete the multiple tasks. For example, Task B must follow Task A and typically takes 30% of the time taken to complete Task A. Is it possible to set up a task so that it can derive its duration as a percentage of the duration of its predecessor (or of another linked task)? Task A -> Task B - if the Task A duration is set to 10 hours, Task B would automatically calculate to an expected duration of 3 hours. Thanks, Richard Tag: Copy resource working times to new resource pool. Tag: 98365
  - 10
    - Task Usage view at a Summary Task Level Hi, I have a project with several levels of detail, on the top level I have three summary tasks ST1 to ST3, these have summary tasks below them etc. At the lowest level are the actual tasks with resources assigned to them and then work allocated. What I would like to see for each summary task (ST) is what resources are working how many hours. Without alll the detail of what tasks they are doing i.e. ST1 John 3 Jessica 5 Adam 8 ST2 John 10 Adam 2 Eva 4 ST3 Jessica 5 Eva 4 Tom 2 It is essentially the Task Usage view at a Summary Task Level. Any ideas on how to obtain such information? Cheers Tag: Copy resource working times to new resource pool. Tag: 98361
  - 11
    - Interim Plan Finish Variance I've read through a lot of strings and tried the suggestions (custom field, etc), but have had no success getting a finish variance from current to interim plan. Also tried using Baseline1, but the formula 'Finish-Baseline1 Finish' does not calculate the deltas. Only the Baseline Finish variance is accurate. I need an easy way to see variances from one update to another. Please help! Tag: Copy resource working times to new resource pool. Tag: 98358
  - 12
    - Gantt chart date range Hi, Would anyone know how to only show tasks in the Gantt chart for specific date range, for ex. from 2/1/06 and on. Thanks! Tag: Copy resource working times to new resource pool. Tag: 98357
  - 13
    - Filters not displaying requested information? Filter continues to show all information. Selected information appears in blue. Why isn't it hiding the information? Tag: Copy resource working times to new resource pool. Tag: 98347
  - 14
    - Modifying Project 2003 to access a Resource Pool on a Web Server I need to know if it is possbible to get MS Project 2003 to be able to link to a Resource Pool file that is housed on a Web server. I am using MS Sharepoint hosted on a web server by my company. Both the resource pool file and the multiple project files will be on the SharePoint server. I need the ability to open the project files for editing in MS Project 2003 with them refernecing the resource pool file located on sharepoint. Right now is says that Project cannot support web server resource pooling. Is there any way to do this? Thanks for your help Doug Tag: Copy resource working times to new resource pool. Tag: 98345
  - 15
    - Can I set up a summary for CRITICAL TASKS only in Project 2003? I am trying to have a summary sheet for critical tasks only, is that possible? Tag: Copy resource working times to new resource pool. Tag: 98344
  - 16
    - Modify Default Calendar with VBA! Please, help-me! Hello, I need some help. Is there any way to modify the default calendar of the project professional with VBA? I can modify the base calendar of resources but i can't change the base calendar of project? Example to modify a calendar of resources: Sub sUsaCalendarioEngenharia() Dim r As Object For Each r In ActiveProject.Resources If Not r Is Nothing Then r.BaseCalendar = "CalendÃ¡rio Engenharia" '*** the name of calendar End If Next r End Sub I thanks for any help! Luiz Carlos Processor - Porto Alegre Tag: Copy resource working times to new resource pool. Tag: 98343
  - 17
    - Assign a resource for only part of a task. I want to assign Jose to a task that will take four days to complete but I only want to assign Jose to two of the days. I don't want to assign him part time to the entire task where he would be on it for all four days at 50% usage, but rather for two days at 100% and two days not assigned to that task. Tag: Copy resource working times to new resource pool. Tag: 98338
  - 18
    - Installing fonts iI am unable to install fonts-message comes up-unable to install in Dos mode Tag: Copy resource working times to new resource pool. Tag: 98335
  - 19
    - Covert local userdefined fields to Enteprise ones Hello Experts, i have some local userdefined fields that i like to make enterprise userdefined fields. i am an administrator and have access to all of the enterprise fields. i can probably copy and paste from one to another. but am sure there is a slick way of doing it using a macro or something like that help is always appreciated Tag: Copy resource working times to new resource pool. Tag: 98334
  - 20
    - Team Foundation Server /Project Integration Issues - Hey Dale/Gary Hopefully Dale or Gary can answer this. I am evaluating Visrual Studio Team Services/Team Foundation Server from a Project Management stand point, and I have several questions. 1. It looks like tasks are imported to a blank .mpp file each time! This prevents setting a base line. 2. It looks like resources are "local" to each project.... how do we manage resource contention? 3. If we do indeed import tasks "work items" to a blank project each time, how do we identify slipping tasks? So far I am NOT impressed with the "project Management" perspective of VSTS/TFS... in fact I am quite "underwhelmed". Am I missing something? Tag: Copy resource working times to new resource pool. Tag: 98333
  - 21
    - Two shifts I am working with a project schedule requiring two (10 hr) shifts per day. How can I set the Gantt chart to show a separate area for each shift?? Tag: Copy resource working times to new resource pool. Tag: 98331
  - 22
    - Not show task on gantt calendar Is there a way to make a task and all its subtasks NOT show up on the Gant chart calendar timeline? I dont want to delete it permanently, just not show it and also not have the summary show it. The obvious work around is delete it and save as a new file... Tag: Copy resource working times to new resource pool. Tag: 98327
  - 23
    - Any MUI available for Project Professional 2002? Hi, on the Microsoft website I ony found MUIs for the Server version. I'm installing the Prfoessional one, and could not find any MUI for it... thanks k Tag: Copy resource working times to new resource pool. Tag: 98322
  - 24
    - PWA - Active X Components Need a quick clarification regarding PWA and how the Active X components installs initially. The basic question is this: When a new user goes to PWA for the 1st time and is prompted to download the Active X components, is it because PWA has detected a new MACHINE / LOCATION that does not have the components (OR) is it because PWA has detected a new USER that does not have the components in their profile??? We are trying to determine the best way to manually force the Active X components to install for Team Member users that do not have an individual desktop. Instead, they are using a setup that is just a hookup to a Citrix / Terminal Server box. THANKS IN ADVANCE for the Clarification!!! Brandon@KM Tag: Copy resource working times to new resource pool. Tag: 98321
  - 25
    - Project cannot resolve overallocation Hi, I am getting the error message when I level: 'Project cannot resolve overallocation' for resource x on date. However, when I look at the resource usage view, resource X is not red and when I look at the date he is not over resourced on that date Anyone know why I am getting the overallocaton message when the resource is not overallocated? Thanks for any help! Tag: Copy resource working times to new resource pool. Tag: 98319

I am in the process of dividing one giant project plan into a few seperate
ones and would like to implement a resource pool. I would like to keep my
resources existing calendars (vacation, working time, etc.). How can this be
done? Is it possible to export/copy ALL resource information?

Top

Re: Copy resource working times to new resource pool. by JulieS

JulieS
Wed Feb 15 16:38:41 CST 2006

Hi Bobby,

See the following link to Article written by Mike Glen - Project MVP. It
steps you through consolidating resources into a pool.
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=443

I hope this helps. Let us know how you get along.

Julie
"Bobby" <Bobby@discussions.microsoft.com> wrote in message
news:CA5BE7D8-33D0-4746-8A5D-B0752A03FFDA@microsoft.com...
>I am in the process of dividing one giant project plan into a few seperate
> ones and would like to implement a resource pool. I would like to keep my
> resources existing calendars (vacation, working time, etc.). How can this
> be
> done? Is it possible to export/copy ALL resource information?

Top