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!

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

Recent content by Planner18

  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
See more

Part and Inventory Search

Back
Top