What database table is Resource Group information in? Posted: 21 Dec 2005 11:26 AM PST Hi, For some reason the Resource Group is saved as custom text in the MSP_Text_Fields table. Resource Group text has a Text_Field_Id of 205520899 -- Rod Gill Project MVP Visit www.msproject-systems.com for Project Companion Tools and more "Joe" <microsoft.com> wrote in message news:com... |
Export MS Project to Excel indentation Posted: 21 Dec 2005 09:56 AM PST Hi omp, See Jack Dahlgren's "Export hierarchy to Excel" macro at: http://masamiki.com/project/macros.htm Hope this helps. Let us know how you get along. Julie "omp" <microsoft.com> wrote in message news:com... |
Filter to show who entered actual hours Posted: 21 Dec 2005 07:53 AM PST Thanks John, I was afraid that was going to be the answer. I will look at running a query against the Timephased data. "John" wrote: |
How do I schedule resources? Posted: 20 Dec 2005 09:51 PM PST Hi Hai Vu, Welcome to this Microsoft Project newsgroup :) You might like to have a look at my series on Microsoft Project in the TechTrax ezine at this site: http://tinyurl.com/2xbhc or this: http://pubs.logicalexpressions.com/Pub0009/LPMFrame.asp?CMD=ArticleSearch&AUTH=23 (Perhaps you'd care to rate the articles before leaving the site, :) Thanks.) FAQs, companion products and other useful Project information can be seen at this web address: <http://www.mvps.org/project/> Hope this helps - please let us know how you get on :) Mike Glen MS Project MVP Hai Vu wrote: |
How to display Task without resource name Posted: 20 Dec 2005 04:44 PM PST Perhaps you mean how to get the name of each Task and the Resources assigned to each Task in a single field for each Task. Good idea. First solution is to use a formula in a spare Test field to concatenate the contents of the Name and Resource fields. Success with this will depend on whether the Data Type of the two fields can be interpreted/pd as text and concatenated. Yes, it works. TOOLS, CUSTOMISE, FIELDS, TEXT1 [Name] & " " & [Resource Names] "omp" <microsoft.com> wrote in message news:com... |
Does MS Project store other MS docs (Excel, PP, Visio, Word) Posted: 20 Dec 2005 11:42 AM PST Hyperlinks associated with tasks can open files or file folders for you. -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "PRT" <microsoft.com> wrote in message news:com... |
Collaborating not using project server Posted: 20 Dec 2005 05:32 AM PST Thanks I will check it out. "Rod Gill" wrote: |
Can't get my standard calendar standard for my location Posted: 20 Dec 2005 05:08 AM PST Hacking is what they do to break concrete, indeed. -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "Guy" <com> schreef in bericht news:googlegroups.com... |
Gantt Chart not printing completely Posted: 19 Dec 2005 01:21 PM PST Thanks a lot!!! .... I just didn't notice those dates... THANKS, Dale N "Jan De Messemaeker" wrote: |
How do I add indicators in the indicators field (ie completed)? Posted: 19 Dec 2005 11:16 AM PST Danielle wrote: Of course! And I've never hunted for my glasses for 10 min only to find them on top of my head! :) |
Multi-Part Question, probably 101-level Posted: 19 Dec 2005 09:21 AM PST Because when you update a task there is no benefit in having anything except what actually happened. If the task finishes early and you set actuals of saying that, Project shows it finishing early. That way succeeding tasks start earlier as well. -- Rod Gill Project MVP Visit www.msproject-systems.com for Project Companion Tools and more "IbanezJem" <microsoft.com> wrote in message news:com... |
Start-to-Finish Posted: 19 Dec 2005 08:50 AM PST Adding to Dave's comment ... remember that in addition to the SF link driving the timing of the successor there's also the constraint to finish the task as soon as possible after the project start. The start of the predecessor determines the earliest possible time the successor can finish and the ASAP constraint prevents it from finishing later unless something else such as a lag time gets into the picture. -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs "scott_hanebutt" <microsoft.com> wrote in message news:com... |
100% Complete not rolling up to Summary Tasks Posted: 19 Dec 2005 05:36 AM PST In article <com>, PJH <microsoft.com> wrote: PJH, Only part of the referenced post relates to resources on summary lines. Rod also talked about a potential problem with "normally assigned" resources whose Remaining Work is > 0. Did you check that out? If everything still looks ok, I'd be happy to take a look at your file if you don't mind e-mailing it to me. If it has sensitive data, I can send you a macro that will desensitize it or you can go to fellow MVP, Jack Dahlgren's website at: http://masamiki.com/project/macros.htm and use his macro called "scrub". If you do send it, make sure to zip it first. John Project MVP |
Filtering for split tasks Posted: 19 Dec 2005 04:28 AM PST In article <com>, MarkLNash <microsoft.com> wrote: Mark, You're welcome. John |
Project Mgt softwre Comparison Posted: 19 Dec 2005 03:15 AM PST Hi, I'm not going to compare to other packages but can answer about the requirements. MS Project (Std or Pro, only the price is different) can perfectly handle multiple projects scheduling and resourceing. Project Server is not necessary. Hope this helps, -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "davegb" <com> schreef in bericht news:googlegroups.com... (way packages. licenses). packages. these |
Text on Tracking Gantt Chart Posted: 18 Dec 2005 11:00 PM PST Thanks for the reply. But the problem shows up in print preview, so I am assuming it is an issue with Project2000. |
levelling II Posted: 18 Dec 2005 03:16 PM PST Hi, "Leveling was changing the duration of the tasks" Are you sure this was leveling and not a change in work or units? Leveling basicly shifts tasks as they are, doesn't change work, units nor duration (be it that when the task is split the time between start and finish changes) HTH -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "greg tatchell" <microsoft.com> schreef in bericht news:com... changing timeline ms to dates is bericht that 150mins change. |
How do I do a PERT analysis in Project 2002? Posted: 17 Dec 2005 01:09 PM PST Hi brujansen , Welcome to this Microsoft Project newsgroup :-) If your ysis toolbar is not there, you might like to see FAQ Item: 46. ysis Toolbar (Project 2000+) FAQs, companion products and other useful Project information can be seen at this web address: http://project.mvps.org/faqs.htm Hope this helps - please let us know how you get on :-) Mike Glen Project MVP wrote: |
Time granularity in Project Posted: 17 Dec 2005 02:52 AM PST Hi, The only thing you can do is what you wrote in your firsdt message, set the GUI to months. But when it displays mo or Mon in the data they will be converted from/to minutes anyway :-( HTH -- Jan De Messemaeker Microsoft Project MVP +32 495 300 620 http://users.online.be/prom-ade "major.tal" <com> wrote in message news:googlegroups.com... |
Locate hidden fields in MS Project Posted: 16 Dec 2005 05:59 PM PST In article <com>, "Mary" <microsoft.com> wrote: Mary, You're welcome. John |
Linking Task Durations Posted: 16 Dec 2005 12:44 PM PST In article <com>, "ko" <microsoft.com> wrote: ko, You're welcome. I don't generally recommend the use of Paste Links in Project because they are fragile and easily corrupted. However, creating a hammock task requires them and if they are used carefully and sparingly, there shouldn't be a problem. John |
Group by custom field shows field description Posted: 16 Dec 2005 12:32 PM PST In article <com>, "Dann" <microsoft.com> wrote: Dann, I'm glad I was able to help. That's why this newsgroup exists. John Project MVP |
MS PRoject formatting Posted: 16 Dec 2005 11:54 AM PST In article <43a7d8d0$wn.com.au>, "Trevor Rabey" <westnet.com.au> wrote: Trevor, I do agree that manually formatting individual tasks can be tedious, (although the method I described streamlines the process considerably), but I do NOT agree that it shouldn't be done. Is there some bad thing that will happen (e.g. file corruption, unexpected results, etc.) if users apply individual formatting? If so, please share with the rest of us. John |
Multiple resources with different allocations on a single task Posted: 16 Dec 2005 07:26 AM PST I forgot a few presteps to this. select all tasks and make them all effort driven, constraint type: as soon as possible, and task type: fixed work. Thanks for pointing out effort driven. "Devin" wrote: |
Change the default Project Calendar Posted: 16 Dec 2005 07:01 AM PST See embedded ... "scott_hanebutt" <microsoft.com> wrote in message news:com... I'm not sure that the 24 calendar would actually be best there. My 3 resources are Joe Day, Bill Swing, and Fred Grave. I have task X to do that will require 24 man-hours of work to complete. I have several options when I assign the resource to the task, depending on the needs of my project. I can assign one of those resources to it, I can assign 2 of them, or I can assign all three. The 24-hour calendar assumes you will always assign all three. With the Project calendar set to a normal generic workday for a single resource, when I enter the task it will show up with timing as if one resource was going to do it which is the normal level to take the work breakdown to. That 24 man-hours task will take 3 workdays and the only thing that changes with my choice of which resource to assign is the time it starts on the first workday. If I need it done sooner I can add one or both of the renmaining resources. If my Project Calendar is the normal day shift calendar, Joe's base calendar is the same, Bill's is an added swing shift base calendar and Fred's the night shift calendar, I get accurate scheduling regardless of the way I choose to assign the workers. Not sure about that example either but have to think on it a bit before commenting. -- Steve House [MVP] MS Project Trainer & Consultant Visit http://www.mvps.org/project/faqs.htm for the FAQs |