Resource View Summary Tasks Microsoft Project |
- Resource View Summary Tasks
- Where is email name in MS database schema?
- Two key concepts we need to make our schedule work! Can Project aand the operator do this.
- changing default time?
- So many questions...so little time...on scheduling and leveling
- Summary tasks from Project To excel
- Project statistics
- Exporting into Excel
- Allow Project to set Units
- Editable calculated custom field in project
- setting defaults
- Fill Colors for Project Fields
- Project Resource Dependencies
- Custom project report/analysis
- unchecked Project
| Posted: 25 Jun 2004 01:36 PM PDT Thanks John, I could probably do it in MS Access but I was wondering if MS Project could do it Thanks..... John wrote: |
| Where is email name in MS database schema? Posted: 25 Jun 2004 10:21 AM PDT Hi BMac, In Project 2000 it is the Email Address field. You will only have that field available if you are in a resource driven view however, such as the resource sheet. You will not see the field available in a task driven view (such as the Gantt chart or task sheet.) Hope this helps. Julie (from memory). group. project.server practices and Project VBA email name for a name for the field |
| Two key concepts we need to make our schedule work! Can Project aand the operator do this. Posted: 25 Jun 2004 08:22 AM PDT John, I apologize ahead of time. The answer seems obvious. Skip operations 1 through 4 and go straight to 5 because the weekend is here. Oh by the way, make sure the resource is readily available :-) John |
| Posted: 25 Jun 2004 08:15 AM PDT Are you certain that you're changing to correct calendar when you try manually? The calendar that is designated as the Project Calendar (Project Information screen) is the one that governs tasks that have no resources assigned while the calendar designated as the base calendar for the resources is the one that will govern, vie the resource calendar, for tasks that resources have been assigned to them. Did you highlight all the column headings to change the hours for all dys of the week or did you only update one day's working time? (That's incredibly easy to do if you're distracted, happens to me all the time LOL) -- Steve House [MVP] MS Project Trainer/Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "dion" <microsoft.com> wrote in message news:216c701c45ac7$3ad7f600$gbl... |
| So many questions...so little time...on scheduling and leveling Posted: 24 Jun 2004 03:41 PM PDT + First, thanks for taking the time to sort through the mess. I take your point about taking a class. Is there something online or a good book you could recommend to me? ---------------------------------------------------------------- Some basics: Project 2003 on XP. All tasks are Fixed Unit ASAP. All dependencies are either FS or FF. All Resources have start dates but NA for end dates. Scheduling based on Start Date. No assignments to summary Tasks. How can I specify a minimum assignment interval for a project? Say 1 hour? * What is an assignment interval? + I want it to not split a task into intervals of less than 1 hour. I'm looking for a way around the rounding problem mentioned below. Can I assign 2 people to one task without requiring them to work together every minute? I'd like to set a time window (say, a 5 day period) during which they're scheduled for 1 day each, but the specific times do not have to match. * Have you tried Project? What youask for is normal berhaviour, it's keeping them synchronous that is nearly impossible :-)) + Perhaps there's a setting that controls it? ALL my joint tasks are synchronous after leveling. I've resorted to creating one task/resource to get around it. One possibility is that I enter everything as Work not duration. Bad idea? What causes Project to allocate 100s of thousands of percent to a Resource when leveling? * I wouldn't know, because I have never seen leveling change assignment units. + The weather's actually fine over here in the twilight zone. It's a good thing because the birds ate my bread crumbs so I'm having trouble finding a way home. What causes Project to decide to schedule some tasks in 2049 when leveling? (Note basics above.) I've read about reasons that Project has for doing this, but I don't think they apply in my case. * Of course they will apply, a software always obeys to its own rules.Reasons are using availability dates for resources or assigning resources to summary tasks. + I checked for those situations. (I mention this at the top.) I do use availalability dates, but I use only start dates. The end dates are always NA. I can often get around this by playing with the order in which I level (and relevel) individual resources or by changing leveling options (ID order seems to avoid the problem the most often.) Is there a way to tell it to stop leveling if it can't fit everything in by a certain date? (My project is scheduled by start date.) What causes Project to set Work to 0 for some groups of tasks when leveling? * Again, I have never seen leveling change work. Are you sure there is not a VBA macro that runs before leveling ? I once did that for a customer. + Not unless Project itself runs such a macro. Is there any way to give Project a threshhold when leveling so that it would consider an x% overallocation close enough and keep going? * Yes, give the resource a max. units of 100+x% + Thanks. Why does Project leveling assign 7.98 hours to the first day of a 3 day task, when the task has only 1 resource assigned, and the resource has no other assignments on that day? * You could try FAQ 5. Default Workiing hours on http://www.mvps.org/project/faqs.htm Another possibility is that a predecessor ends a few minutes into the day Finally I have to admit that leveling doesn't always round decimals correctly. + Rounding and maybe more. I've now found cases when it allocates <15% of a workday...My workaround is to delete and readd the task. That seems to cure it. When I apply the "Critical" filter in Gantt, Project shows only tasks in the final three months of the project. Does this mean that no individual task is critical before that time? (That there are multiple paths that prevent an earlier finish date?) * No. It means what it shows, that no tasks are critical at all. You must have a constraint somewhere in the middle, in such a way that tasks inthe arly stages of the project do not influence end date at all. + Thanks. When you assign two resources to one task, both at 100%, why does Work sometimes show slightly (8.03 vs 7.97) different values on Tracking Gantt and Resource Usage? * I do not know. I should see the file. + I suspect rounding again. My fix is to delete and reenter the task. What does an assignment of 0h mean and why does leveling create them? * Again, I have never seen Leveling create assignments + Struggling a bit with terminology. I look on Resource Usage and I see cells with 0hrs there (followed and/or preceded by non-zero cells.) Is "split" the correct term? What does it mean to assign a resource to a summary task while leaving the detail tasks unassigned? * That it will work on that summary task for the whole duration of the summary task (independently of whether there are detail tasks at certain dates or not) + Thanks. When you enter a work # on a task with multiple resources, why does it divide the work # by the # of resources? And why does it not do so if you reenter the #? * I rarely answer Why questions, I cannot look into the head those who wrote the specs. Why are the IDs sometimes out of sequence in Tracking Gantt view? * BecauseYOU sorted the view. + This is a little different. I drag a task to a different spot in the outline, and it retains its old ID. The worst case is that I drag a task to another spot, then drag a second task to another spot, and the first dragee jumps back to its original place. Also, sometimes the predecessor field retains an obsolete ID # after you move the task to which it refers. The latter problem resolves itself with a little jiggling. New ones. + Project repeatedly (but not always) sets Work to 0 for certain tasks when leveling. Any pointers? + My leveling strategy goes like this: S1) Clear leveling for the project. S2) Go to Resource Usage. S3) Sort Resources by descending Work. S4) Level Resource 1. Skip All. S5) Level the busiest overallocated Resource other than the Resource you just leveled. Skip All. S6) Repeat S5 until overallocations go away. Leveling settings: Hour by Hour. Do not clear. Entire project. ID order. Ignore slack. Do not adjust individual assignments. No splits. If I vary from this routine, I usually get 2049 problems. One way that often corrects 2049 problems is to clear leveling on just those tasks that finish in 2049 and relevel. I appreciate your suggestions! |
| Summary tasks from Project To excel Posted: 24 Jun 2004 09:26 AM PDT A.Outlineparent.outlineparent.name HTH -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/index.htm 32-495-300 620 "Esperanza" <com> schreef in bericht news:google.com... news:<microsoft.com>... |
| Posted: 24 Jun 2004 09:24 AM PDT Hi Pops, I apologize. Terminology confusion on my part, I thought you were talking about Project|Project Information| Statistics, not File|Properties|Statistics. The only way I can discover what I think you are looking for is to do as Gerard Ducouret suggested in his post. Save the project file as a template file. [File|Save As| change the file type to template]. Then when you choose file|New and base the new file on the template, your file properties are "re-set." Sorry again for the misdirect. Hope this helps. Julie or modify open schedule. better |
| Posted: 24 Jun 2004 08:47 AM PDT Mark, In answer to your second question there is not an option per se for copying gantt chart graphic information. However there are several ways to get there. One way, although I've never tried it, is to save the gantt chart view as a web page. I'm not sure exactly what it does with the graphic, but you might want to read about it in the Project help file and give it a try. A second method that is often used is to capture the gantt chart view as an image using the 'copy picture' (little camera) icon. With this method you have to try different screen formats to get the image as you want it. Another method, if you have the full Adobe Acrobat version, is to save the file as a .pdf. You won't be able to manipulate it but the whole file is captured. Yet another method is to use a VBA macro to effectively replicate the graphic features of each task in the Gantt Chart. This method can be used in Excel, PowerPoint, or Word. It does give you control of the image, but requires some VBA expertise. Hope this helps. John |
| Posted: 24 Jun 2004 08:45 AM PDT Hi Jan, I was affraid of that. As far as Maximum Availability, that is the reason I was hoping Project would do this. We have a large base of Engineers that we are working with and the Program Manager wants to know if he needs to put in a request to have X number of them transfered off their current projects to fulfil the need or do we need to hire additional engineers, and how many. I think, as you questioned below, I am going to have to take it one task at a time and adjust how many are working on each task to manipulate the date. I can look at my Resource Sheet and see my "Peak" units. If I adjust my Max units to equal my peak units and then level, all it does is say that no-one is over allocated, it does not adjust my date. If I add more units than my peak and then level, it just says that we have people under utilized. I guess I will have to do it by hand. Thanks for your input. Shaun right, but I have some By the same factor? bericht of The the finish |
| Editable calculated custom field in project Posted: 24 Jun 2004 08:35 AM PDT No you can not, but if the value is a static value, you don't need to. Simply use a value list. select the column header right click select customize fields click on the value list button enter the value you want as default check the "Use a value from the list as the default..." box. Select the value Click the set default button check the "allow additional items to be entered into the field" button. click OK. Now if the value must be calculated you have to use two fields Use Text1 for the user to enter a non-default value. Use Text2 with a formula like this: iif([Text1]="",(put your formula here),[Text1]) That way if text1 is blank it uses and displays the result of your formula, and if text1 is not blank it uses and displays the value of text1. -Jack "Gabriele" <it> wrote in message news:google.com... |
| Posted: 24 Jun 2004 08:17 AM PDT Hi Julie, Funny version of Project you seem to have - I have always known that the setting of Date Format under Tools, Options, View spreads through the whole computer (even when you have multiple Global.mpt files) so the answer to your question is: to achieve that, do nothing. Project does it all for you. -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/index.htm 32-495-300 620 "JulieD" <net.au> schreef in bericht news:phx.gbl... it |
| Fill Colors for Project Fields Posted: 24 Jun 2004 07:59 AM PDT I don't know, but I have asked for it :) Why not send them a wish? Mike Glen Project MVP "Al Wallace" <microsoft.com> wrote in message news:com... I guess I was hoping for some backdoor/magical incantation ;) Do you know if MS plans to add this feature to make this product more consistent with the rest of the MS Office suite? Select seen at discussion they |
| Posted: 24 Jun 2004 07:46 AM PDT "Al Wallace" <microsoft.com> wrote in message news:<com>... was that if Fred was the only one working the tasks, I didn't want him to bounce back and forth between them. Leveling is not what I want to do. I want to find a way (if one exists) for Project to identify the resource dependencies so that I can try to apply other/different resources. Leveling doesn't do that. I want to compress my schedule, not extend it. But that is exactly what Project is showing you on the Resource Usage view. The resources in red are overallocated. Look through their assignments, and the timescale view on the right side of the screen will show you which tasks overlap and when. These are the tasks you should find another resource for, or you could manually level by adjusting the scheduled work in the timescale part. Sarah sarah_kiko@(removethis)cinfin.com |
| Custom project report/analysis Posted: 24 Jun 2004 07:13 AM PDT Hello, I downloaded the tool bar and didn't have any problems. Have you displayed the toolbar? tool of predefined in of |
| Posted: 24 Jun 2004 06:55 AM PDT Zimmermann -- Zimmermann -- If your PC crashes while you have a project open, it will remain in a checked out state until someone checks it in. If you are using Project Server 2002, your Project Server administrator is the only one who can check it in for you. If you are using Project Server 2003, you can check in your own project on the Project Center page or you can have your Project Server administrator check it in for you. Hope this helps. -- Dale A. Howard [MVP] Enterprise Project Trainer/Consultant Denver, Colorado http://www.msprojectexperts.com "We wrote the book on Project Server" "Zimmermann Christian" <hevs.ch> wrote in message news:cbgr0a$i56$ip-plus.net... |
| You are subscribed to email updates from TextNData Forums - Microsoft Project To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
