none
Need a Macro that subtracts Finish variance from the Duration field

    Pertanyaan

  • Hello

    We are using MS Project 2013 on Windows 7.

    Every week we use the "Update Project Reschedule uncompleted work to start after" feature to move uncompleted work forward beyond the end of the current week.MS Project moves the work forward and it causes variances to occur.

    Every week we look through hundreds of small change request tasks and their support tasks, look at the variances and manually subtract the variance from the Duration field to bring the finish date back in line. We do this from the Gantt chart view. Later we look at allocations and re-adjust based on any over allocations.

    Can someone provide a Macro that when a number of tasks are selected it subtracts Finish variance from the duration field of the tasks selected changing the Duration field automatically?

    Thanks

    Sabtu, 10 November 2018 14.14

Jawaban

  • Hotmail1,

    Personally it sounds like you are tweaking the data to get the result you want but nonetheless, given that you have the option checked to "split in-progress tasks" and you have selected the tasks of interest, this macro should do what you want.

    Sub adjustDur()
    Dim t As Task
    For Each t In ActiveSelection.Tasks
        t.Duration = t.Duration - t.FinishVariance
    Next t
    End Sub

    John

    • Ditandai sebagai Jawaban oleh Hotmail1 Minggu, 11 November 2018 01.22
    Sabtu, 10 November 2018 20.16

Semua Balasan

  • Hotmail1,

    Personally it sounds like you are tweaking the data to get the result you want but nonetheless, given that you have the option checked to "split in-progress tasks" and you have selected the tasks of interest, this macro should do what you want.

    Sub adjustDur()
    Dim t As Task
    For Each t In ActiveSelection.Tasks
        t.Duration = t.Duration - t.FinishVariance
    Next t
    End Sub

    John

    • Ditandai sebagai Jawaban oleh Hotmail1 Minggu, 11 November 2018 01.22
    Sabtu, 10 November 2018 20.16
  • Thanks John

    These are 8 pure support tasks that span the start and end of each CSR

    Minggu, 11 November 2018 01.22
  • Hotmail1,

    You're welcome and thanks for the feedback.

    John

    Minggu, 11 November 2018 01.48