Alternative View to a Schedule - Need Help!
in [Project]
|
From: BillV on 8 May 2008 13:38 All, Is there a way to write a macro to take the identified Milestones listed below a summary task in a schedule, Create Columns labeled/titled with those same Milestones and fill in the corrosponding Finish Dates? This particular schedule has underneath each Summary Task the same Milestones/subtasks, basically everything is duplicated. My bosses boss has requested this kind of view. I know many will say just create an Excel Spreadsheet but, we want to do this view in Project and it seems it would be faster if a macro where created. If anyone out there thinks they can help and need to see the Schedule, I will be happy to send it to them.
From: Jack Dahlgren on 8 May 2008 13:59 It is possible using only custom fields (no macros) if you are willing to use up a number of your text fields and flag fields. How many milestones do you expect? -Jack Dahlgren "BillV" <BillV(a)discussions.microsoft.com> wrote in message news:1B17A977-E3AB-45F0-A514-2AFC1DAAEEA1(a)microsoft.com... > All, > > Is there a way to write a macro to take the identified Milestones listed > below a summary task in a schedule, Create Columns labeled/titled with > those > same Milestones and fill in the corrosponding Finish Dates? This > particular > schedule has underneath each Summary Task the same Milestones/subtasks, > basically everything is duplicated. > > My bosses boss has requested this kind of view. I know many will say just > create an Excel Spreadsheet but, we want to do this view in Project and it > seems it would be faster if a macro where created. > > If anyone out there thinks they can help and need to see the Schedule, I > will be happy to send it to them.
From: BillV on 8 May 2008 16:24 21 Milestones are being tracked. I'm working on the custom fields approach right now but, it would be nice to know if a macro can make this request possible. I'm sure I'll have to do fulfill this request on more than one schedule. "Jack Dahlgren" wrote: > It is possible using only custom fields (no macros) if you are willing to > use up a number of your text fields and flag fields. > How many milestones do you expect? > > -Jack Dahlgren > > > "BillV" <BillV(a)discussions.microsoft.com> wrote in message > news:1B17A977-E3AB-45F0-A514-2AFC1DAAEEA1(a)microsoft.com... > > All, > > > > Is there a way to write a macro to take the identified Milestones listed > > below a summary task in a schedule, Create Columns labeled/titled with > > those > > same Milestones and fill in the corrosponding Finish Dates? This > > particular > > schedule has underneath each Summary Task the same Milestones/subtasks, > > basically everything is duplicated. > > > > My bosses boss has requested this kind of view. I know many will say just > > create an Excel Spreadsheet but, we want to do this view in Project and it > > seems it would be faster if a macro where created. > > > > If anyone out there thinks they can help and need to see the Schedule, I > > will be happy to send it to them. > > >
From: Jack Dahlgren on 8 May 2008 18:52 Bill, To display the values in columns you need to use a field. Therefore if you have twenty one milestones you are going to burn up 21 text fields or date fields. If you are using a text field for example, use a formula which determines if the task is the specified milestone (use an iif() statement for example) and if it is, then display the date, otherwise display nothing. Then for the summary task just roll up the maximum value from the subtasks. Using a macro would allow you do to something similar, but with a bit more flexibility, but at the cost of having to run the macro whenever you want the data to refresh. I'd start with the custom field approach first. -Jack Dahlgren "BillV" <BillV(a)discussions.microsoft.com> wrote in message news:2EB81F0D-1E29-4741-836E-7DC8E047D4AA(a)microsoft.com... > 21 Milestones are being tracked. I'm working on the custom fields > approach > right now but, it would be nice to know if a macro can make this request > possible. I'm sure I'll have to do fulfill this request on more than one > schedule. > > "Jack Dahlgren" wrote: > >> It is possible using only custom fields (no macros) if you are willing to >> use up a number of your text fields and flag fields. >> How many milestones do you expect? >> >> -Jack Dahlgren >> >> >> "BillV" <BillV(a)discussions.microsoft.com> wrote in message >> news:1B17A977-E3AB-45F0-A514-2AFC1DAAEEA1(a)microsoft.com... >> > All, >> > >> > Is there a way to write a macro to take the identified Milestones >> > listed >> > below a summary task in a schedule, Create Columns labeled/titled with >> > those >> > same Milestones and fill in the corrosponding Finish Dates? This >> > particular >> > schedule has underneath each Summary Task the same Milestones/subtasks, >> > basically everything is duplicated. >> > >> > My bosses boss has requested this kind of view. I know many will say >> > just >> > create an Excel Spreadsheet but, we want to do this view in Project and >> > it >> > seems it would be faster if a macro where created. >> > >> > If anyone out there thinks they can help and need to see the Schedule, >> > I >> > will be happy to send it to them. >> >> >>
|
Pages: 1 Prev: Visual Earned Value Over Time Report Next: Replacing Resource Assignments |