Loading...
Quick Links
Sai Prasad

@sai-prasad

Active 4 months ago
B Sai Prasad, PMP®, PMI-SP®, MVP Project, Senior Manager - Learning & Development, has been with service provider Cognizant Technology Solutions India Pvt. Ltd since 2001 where he was named winner of the company's Global Trainer of the Year award. He has spent 13,000-plus hours in mentoring, coaching, training 9000-plus practitioners on project management topics ranging from project management concepts, project risk management, project scheduling, Microsoft Office Project® to software estimation techniques. He is a Champion of Project Management from PMI India and also Associate Champion Advisory Committee, PMI India. He is awarded the Champion of the Quarter (Q4 – 2012) and Delivery Excellence Award (2011-2012, 2012-2013) from PMI India. He's also the editor of the project management book, Forecast Scheduling with Project 2010. He is a Microsoft Certified Technology Specialist (MCTS) in Project 2010. He is the leader of the MPUG Chennai India Group to promote and help practitioners on how to effectively use Microsoft Office Project.

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 142 total)
  • Author
    Posts
  • #483314 Reply
    Sai Prasad
    Participant
    • Community Leader
    • Forum Pro

    Thanks @Ryan for sharing your solution.

    #478959 Reply
    Sai Prasad
    Participant
    • Community Leader
    • Forum Pro
    #474975 Reply
    Sai Prasad
    Participant
    • Community Leader
    • Forum Pro

    I suppose your question is on Project desktop client. On your first question on report on deadlines, create a filter with Deadline not equals NA (see this picture https://i.imgur.com/BwsFHwq.png for steps). I don’t get your later question on calendar view, please elaborate

    #474973 Reply
    Sai Prasad
    Participant
    • Community Leader
    • Forum Pro

    Locked flag is used for Project Online / Server to prevent team members from entering additional time on a completed task. Though there are alternatives available like macros, customizing filters and views, it will not prevent users from not editing the tasks.

    #464870 Reply
    Sai Prasad
    Participant
    • Community Leader
    • Forum Pro

    Hi Koen, This should work. After changing the system date and opening Project, check Current Date in Project > Project Information. Max Units knows today’s date from Current Date field.

    #455868 Reply
    Sai Prasad
    Participant
    • Community Leader
    • Forum Pro

    Max Units (in Resource Sheet) is the availability of that resource on today’s date. This value is calculated from the “Resource Availability” table in Resource Information dialog. It doesn’t consider if the resource is occupied with work or not.

    Resource Availability (in Resource Information) indicates the availability of the resource during a particular period. Say 23 Sep 2020 to 23 October 2020 the availability units is 100%. If today’s date is 22 September 2020, Max Units will be 0%. If today’s date is any date between 23 Sep 2020 to 23 October 2020, the Max Units will be 100%.

    #417294 Reply
    Sai Prasad
    Participant
    • Community Leader
    • Forum Pro

    Linking % complete field to a spreadsheet is not possible in Project. Alternatively, you need to use custom fields and macro to solve this requirement. First, in the custom fields (text1, text2, ..) have the file location of the spreadsheet and the cell range or address that has test results of each equipment. Second, write a macro to calculate the overall progress for each equipment by using the details of the custom fields and updates the % complete field.

    #416404 Reply
    Sai Prasad
    Participant
    • Community Leader
    • Forum Pro

    This is not possible. You can’t rename the labels Baseline, …, Baseline 10. Your latest baseline should be saved in Baseline, as values stored in this baseline set is used for variance calculation. Baseline 1, …, Baseline 10 is used to store the previous baselines. So, to take a backup/copy of your current baseline, in Set Baseline dialog choose Set Interim Plan with Copy from as Baseline and To as Baseline 1.

    #415303 Reply
    Sai Prasad
    Participant
    • Community Leader
    • Forum Pro

    The Agile feature is only made available in the subscription Project Online Desktop Client that comes with Project Online Professional or Premium subscription – not the 2016 or 2019 products.

    If you want to know more about this feature look at this article from Tim https://www.mpug.com/articles/newly-released-agile-capabilities-in-ms-project/

    #415299 Reply
    Sai Prasad
    Participant
    • Community Leader
    • Forum Pro

    Hi, By any chance is Resource Initials fields for the resource PM blank? If yes, please set PM as the initials

    #415288 Reply
    Sai Prasad
    Participant
    • Community Leader
    • Forum Pro

    Hi Carl, since you want the lowest of the four fields use this formula IIf(Number1=1,1,IIf(Number2=2,2,IIf(Number3=3,3,IIf(Number4=4,4))))

    Here is the screenshot – https://photos.app.goo.gl/3cNykRPUMZ2D1X9M6

    #415287 Reply
    Sai Prasad
    Participant
    • Community Leader
    • Forum Pro

    Hi Carl, It was nice speaking to you. It helped to have clarity on your requirement. Please use this formula for Number5 instead – IIf(Number4=4,4,IIf(Number3=3,3,IIf(Number2=2,2,IIf(Number1=1,1)))). Please note Number4 refers to the fourth field, and so on, and so change the field names accordingly. I tested this formula with different combination so that the highest value between Number1 to Number4 is selected in Number5 field – Here is a screenshot for that https://photos.app.goo.gl/AmTUP4uSvEjzgz6p8

    #415261 Reply
    Sai Prasad
    Participant
    • Community Leader
    • Forum Pro

    It is quite hard to predict why does this happen and that too only for one task with late start in 2017. Can you include a screenshot of the schedule with these columns – indicator, name, deadline, constraint type, constraint date?

    #415250 Reply
    Sai Prasad
    Participant
    • Community Leader
    • Forum Pro

    Tina – Templates should allow you to change dates and that’s its purpose. Can you elaborate what is the trouble in changing date?

    #415249 Reply
    Sai Prasad
    Participant
    • Community Leader
    • Forum Pro

    The cause of negative slack is the early start/finish is after late start/finish. Please check the following conditions
    1. Have you set a deadline to any task, and does that task miss the deadline?
    2. Have you set a MSO, MFO, SNLT, FNLT constraint on any task?

Viewing 15 posts - 1 through 15 (of 142 total)