Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Planner18

    Checking My Sanity

    Thanks Julie. I finally understand. Appreciate your time explaining this. Cheers Planner18
  2. Planner18

    Checking My Sanity

    Hi Julie, Thank you for your reply Just to be clear, if I wanted to set a resource working on a task at a 50% of their time at 85% availability, the only way is showing this, is to set the resource at 42%? As always thank you for your help and sorry to be a pain :) Regards Planner18
  3. Planner18

    Checking My Sanity

    Hi Julie, Are you saying, even if I set the max units at 85% then, they still have to assign each resource on each task at 85% availability. Then over allocated will only be shown if they assign a resource on a task over 85%? I am bit confused because when a new resource is assigned to a task...
  4. Planner18

    Checking My Sanity

    Hi The company planning standard states the resources in schedules must be set at 85% availability. The group has a resource pool which all the schedules are linked to. If the resources in the resource pool are set to 85% availability then the resources assigned to the tasks within the linked...
  5. Planner18

    Baseline Variance problem

    Julie, I used the formula in another text field and set the 'Calculation for task and group summary rows" to 'None' and the same problem occurred when new tasks were added. Then switched to 'use formula' and the output against summary tasks disappeared. Therefore, the formula gives me what I...
  6. Planner18

    Baseline Variance problem

    Julie, Many thanks once again. I did try that but it didn't seem to work. Maybe I mistyped it somehow. I will try again. It is strange I would have expected the same outcome setting "Calculation for task and group summary rows" to None. I'll will try your suggestion of using another text field...
  7. Planner18

    Baseline Variance problem

    Hi Julie, I'm using the following formula: IIf(IsDate([Finish])=No,"No Finish",IIf([Baseline Finish]=ProjDateValue("NA"),"No Baseline Finish",int([Finish]-[Baseline Finish]))) I tried introducing [Summary] = "Yes", " " in to this formula but keep getting errors. Can you show me please the...
  8. Planner18

    Baseline Variance problem

    Hi Julie, Having another problem with the formula. When I insert additional activities and task after baselining, the summary rows show an entry, even though I have set the 'calculation for task and group summary' and 'calculation for assignment rows' set to none, and I would like all summary...
  9. Planner18

    Baseline Variance problem

    Excellent idea as always Julie. Many thanks :)
  10. Planner18

    Baseline Variance problem

    Hi Julie, The reason is because PM's don't always have baseline dates in their table and when they include tasks following an agreed change they forget to baseline those tasks. All that finish variance shows is 0 days and does not give an indication that tasks have not been baselined which is...
  11. Planner18

    Baseline Variance problem

    Thanks John for your response. From previous posts, Julie is excellent at coming up with a solution to solve these little puzzles rather than going through the VB script route. However, if this is not possible and I try the approach you have suggested. Cheers And thanks Skip for additional...
  12. Planner18

    Baseline Variance problem

    Hello, I have been trying to use a formula from a previous post to measure the number of days between finish and baseline finish. The formula I have been trying to use is: IIf(IsDate([Finish])=No,"No Finish",IIf([Baseline Finish]=ProjDateValue("NA"),"No Baseline Finish",int([Finish]-[Baseline...
  13. Planner18

    A Formula Request

    Thank you for your response. It is much appreciated.
  14. Planner18

    A Formula Request

    Hi All, I'm looking for a formula that will change graphical indicators before 'todays date' with the following outcome. 10 days or more before todays date = green 10 to 6 days before todays date = amber 5 days or less before todays date = red 100% complete = blue. I hope I have explained...
  15. Planner18

    Critical Path workload Forecasts

    Hi Julie, That works. Perfect! Thank you for your help Regards Planner
  16. Planner18

    Critical Path workload Forecasts

    Hi Julie, Thank you for your reply. This code is almost there. Under the resource usage view, the summary totals against each resource includes non-critical task estimates as well as critical task estimates. Is there any way to have the totals only reflect critical task estimates for each...
  17. Planner18

    Critical Path workload Forecasts

    How can I show a monthly / weekly workload forecast for each resource but for critical path tasks only in project 2010? Any advise appreciated.
  18. Planner18

    Weekend working

    Thanks for your reply. Not really unfortunately. I understand about individual resource calendars. My question is about the best approach in order to achieve the requirements mentioned in my original post. There are a number of options. I could make certain weekends, in either the individual...
  19. Planner18

    Weekend working

    I am looking for some advice on how to manage weekend working in Project 2010. We have several projects connected to a centralise resource pool containing over 80 resources. Most of the resources are shared across the various projects. One project is late and wishes to show a few resources...

Part and Inventory Search

Back
Top