Asigning multiple resources with delay Microsoft Project |
- Asigning multiple resources with delay
- Why and how does Project calculate duration in decimal amounts?
- How do I put a watermark (i.e. "DRAFT") on a MSProject printout?
- View Resource Assignments in PWA
- Fiscal Month Calendar
- Duration is not adding up
- Formulas and functions
- Early and Late S Curve.
- Fixed end date with flexible start date
- Materials scheduling
- Summary Rows
- lower the duration by adding resources
- Formula Question
- Assigning multiple resource list to tasks within Project
| Asigning multiple resources with delay Posted: 25 Aug 2005 03:18 AM PDT In MS Project use the Resource Schedule View. This view lets you define the dates when the resources start work on the tasks. In your scenario simply define the date (5th day) when Bob joins Dave in coding. Secondly you need to take into account the work involved. When Bob joins Dave how much work would have been completed. Then define how they will share the work, i.e., from 5th day onward how much work is allocated to Bob. If Dave has to do 60h and Bob 20h then you will get the schedule automatically calculated by MS project as 7.5 days. This considers that when Bob joined Dave, Dave had done 50% of the work and the remaining was shared 50% each. Kind regards, -- Haris http://www.manage-systems.com --------------------------------------------- "cz" wrote: |
| Why and how does Project calculate duration in decimal amounts? Posted: 24 Aug 2005 03:37 PM PDT Hi, Maybe you should also read http://www.mvps.org/project/faqs.htm Faq5: Default working hours That is the most common reason for decimal durations. HTH -- Jan De Messemaeker Microsoft Project Most Valuable Professional http://users.online.be/prom-ade/ +32-495-300 620 "groggydoggie" <microsoft.com> schreef in bericht news:com... fractional doesn't on |
| How do I put a watermark (i.e. "DRAFT") on a MSProject printout? Posted: 24 Aug 2005 03:15 PM PDT Mike, This will work when printing on normal paper (letter or legal), but I frequently have to present to an audience and larger paper is sometimes needed from a plotter. Since the paper source is a 36in wide roll, reprinting from the same paper is not doable. I guess I have an expectation that since Word has this feature, why not all MS products? Thanks for suggestion using Word, though. Mark "Mike Glen" wrote: |
| View Resource Assignments in PWA Posted: 24 Aug 2005 01:07 PM PDT jib -- Select the Timesheet view, then click the View Options tab and select the Show Schedule Work option. Hope this helps. -- Dale A. Howard [MVP] Enterprise Project Trainer/Consultant http://www.msprojectexperts.com http://www.projectserverexperts.com "We wrote the book on Project Server" "jlbreyer" <microsoft.com> wrote in message news:com... |
| Posted: 24 Aug 2005 11:52 AM PDT In article <com>, "SpaceCamel" <microsoft.com> wrote: SpaceCamel, As Mike indicated, Project can vary the fiscal year start but it cannot handle company financial calendars. Through the use of VBA however, that feature can be accommodated - I've done it a couple times myself. John Project MVP |
| Posted: 24 Aug 2005 07:19 AM PDT In article <com>, "NK" <microsoft.com> wrote: Nick, Mike explained how Duration of a Summary Line is calculated by Project. However, I note in your second post that you are talking about "time". Perhaps you are looking at the Work field and the Work field of a Summary Line WILL equal the sum of Work for all subtasks - unless Calculation (Tools/Options/Calculation tab) is set to manual. Duration time and Work time are two different entities in Project. Duration is the time (normally in days) during which a task will/needs to be accomplished. Conversely, Work time is the effort by one or more resources to actually perform the task. Depending on how resources are assigned, the two values (minutes, hours, days, etc.) may or may not be equal. If we still are not "getting it", please elaborate so we can give you the answer you need (although it may not be the answer you want or expect). For example, what "numbers" don't add up? Hope this helps. John Project MVP |
| Posted: 24 Aug 2005 06:26 AM PDT In article <com>, "Cynthis PMP" <microsoft.com> wrote: Cynthis, As I indicated, I am more comfortable with VBA than complex formulas (my head starts to spin). I have never used graphical indicators with VBA so this was a learning experience for me too. The macro is set up to use spare Task field Number1 to display the indicators (I chose a simple sphere). You didn't indicate what you wanted to do with Summary Lines. Since % Complete for Summary Lines is calculated by Project there is always some argument as to its validity. As written indicators for Summary Lines are not displayed. If you want indicators for Summary Lines, simply comment out (insert an apostrophe at the beginning of the line) the first line of code and remove the comment indicator from the second line of code. Herewith is the macro. If you need help in setting it up and running it, let me know. Note: When you copy and paste the code into the VB editor pay attention to line continuation indicators (i.e. space and underscore). Sub DurIndicators() CustomFieldProperties FieldID:=pjCustomTaskNumber1, attribute:=pjFieldAttributeNone, _ graphicalindicators:=True For Each t In ActiveProject.Tasks If Not t Is Nothing Then CurVal = t.PercentComplete / 100 shouldbe = Application.DateDifference(t.Start, ActiveProject.CurrentDate) ratio = shouldbe / t.Duration t.Number1 = 3 If ratio >= 0.5 And ratio < 0.75 And CurVal < ratio Then t.Number1 = 1 If ratio >= 0.75 And CurVal < ratio Then t.Number1 = 2 CustomFieldIndicatorAdd FieldID:=pjCustomTaskNumber1, test:=pjCompareEquals, _ Value:=1, indicatorID:=pjIndicatorSphereYellow CustomFieldIndicatorAdd FieldID:=pjCustomTaskNumber1, test:=pjCompareEquals, _ Value:=2, indicatorID:=pjIndicatorSphereRed CustomFieldIndicatorAdd FieldID:=pjCustomTaskNumber1, test:=pjCompareEquals, _ Value:=3, indicatorID:=pjIndicatorSphereGreen End If Next t End Sub Hope this helps. John Project MVP |
| Posted: 24 Aug 2005 03:58 AM PDT Thanks John, I wasn't going to write a piece of vba, as this only has to be performed when we re-baseline a schedule. I was using the timescaled analysis facilities. the only solution I came up with is to copy the schedule to a temporary file, copy the late dates over the early and perform a timescaled analysis to export the data to excel. But the company I work for has the option to upgrade to project professional 2003, from 2000. But I don't know what the advantages would be to advise them to do so. Stuart "John" wrote: |
| Fixed end date with flexible start date Posted: 24 Aug 2005 03:22 AM PDT Thanks for your reply, Jan. Regards, Barbara "Jan De Messemaeker" wrote: |
| Posted: 24 Aug 2005 02:49 AM PDT Helen wrote: Right now my travel schedule is pretty much limited to home/work here in Denver. Would love to tour a French boatyard! And to see Normandy (unless an invasion is in progress)! Love those places, as long as I don't have to live in them (lived in a boatyard in Ft Lauderdale for 2 weeks some years back). Hope all goes well with your project. |
| Posted: 23 Aug 2005 06:27 PM PDT Thanks, all! Problem solved: I had read the HELP item "the default link type is finish-to-start," to mean that subsequent tasks are linked by default. Thanks to Gil Sturgeon for clarifying this. "stephanie" wrote: |
| lower the duration by adding resources Posted: 23 Aug 2005 03:00 PM PDT Hi sfjeffr , Welcome to this Microsoft Project newsgroup :) You might like to have a look at my series on Microsoft Project in the TechTrax ezine, particularly #10 & 11, 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 article 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 wrote: |
| Posted: 23 Aug 2005 08:18 AM PDT Got it! Thank you, Jack. Now I am trying to figure out the next piece of what I am trying to do, but I am lost. How do I change the color of the text? Can you do that? Is there an example formula I can look at? To make my question clearer: Here is one formula that I got off this site that I am now using: IIf([% Complete]=100,"Complete",IIf((ProjDateDiff(datevalue([Finish]),Datevalue([Current Date]),[Project Calendar])/480)>4,"Late by 5 or More",IIf((ProjDateDiff(datevalue([Finish]),Datevalue([Current Date]),[Project Calendar])/480)>0,"Late by 1-4","Not Late"))) In cases where the value yields either "Late by 5 or More" and "Late by 1-4", how can I change those tasks to, say, red? Is that possible? Thanks! Marc "JackD" wrote: |
| Assigning multiple resource list to tasks within Project Posted: 23 Aug 2005 04:10 AM PDT Many thanks for your response Mike, I pretty much thought that would be case after fiddling with Project for the past few days, but glad to have the experts opinion to prove that I was not going mad :o) Dave "Mike Glen" wrote: |
| 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 | |
