Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

How to Create a Frankenstein Schedule (as opposed to a Master Schedule)

6 replies [Last post]
Suleiman Ali
User offline. Last seen 1 year 2 weeks ago. Offline
Joined: 8 Jun 2016
Posts: 3
Groups: None

Hail denizens of this planet !

Sometimes the need arises for a schedule made up of selected activities from various other schedules (dynamically linked of course). But so far the only way workaround I could come up was by creating a master (inserting sub projects) and then using filters/flags etc and saving that view.

Is their a more direct way to do this : where MS Project lets you select which activities to insert from a subproject ?

Replies

Jonh Myils
User offline. Last seen 3 weeks 4 days ago. Offline
Joined: 23 Sep 2019
Posts: 2
Groups: None

https://light-it.net/blog/10-things-to-consider-before-creating-a-peer-t...)"}" style="font-size: 10pt; font-family: Arial;">I would create my own scheduler. That would be the best solution. But since I do not understand anything in programming and development, I will ask the professionals who made the trading platform for me to do this for me https://light-it.net/blog/10-things-to-consider-before-creating-a-peer-to-peer-marketplace/

James Milner
User offline. Last seen 42 weeks 3 days ago. Offline
Joined: 1 Nov 2018
Posts: 8
Groups: None

Thank you for this information, I'll keep it in mind. Would you like a more newbie friendly planning program? If so, try this: http://hygger.io Otherwise, contact an expert. But in general, I like to keep things simple for everyone. 

Tom Boyle
User offline. Last seen 1 hour 40 min ago. Offline
Joined: 28 Nov 2006
Posts: 261
Groups: None

Suleiman,

(Assuming you're working outside of Project Server or Project Online.)  Inter-project links in MSP rely on the file system, so they can be touchy.  They also get multiplied each time a file is saved off or copied.  For your P1/P2/P3 --> Px case, here are the options I see (none are ideal).

1. Manual copy-paste with dynamic (file system-based) updating. i.e. Create project Px and manually copy-paste the tasks you want from P1/P2/P3 into Px. Then either:

   a. (Logic Links) Insert all 4 projects into a temporary linked master shell, then use click and drag to create the logic links from P1/P2/P3 into Px.  You can delete the master after "saving changes" to the four sub-projects.  This will make the schedule data only (not the custom fields etc) dynamically linked.

   b. (OLE Links) Open all 4 files.  Then one cell at a time, Copy-Paste Special-PasteLink the specific task values from the P1/P2/P3 files to the corresponding task cells in Px.

2. Write a procedure (in VBA) to dynamically create or update Px using the flagged tasks from P1/P2/P3.  (You'd have to decide on a few things....) Rod Gill's book on VBA programming for MSP includes some good examples.  After generally unsatisfying though not terrible experiences with file system-based links, this is what I would do.

Good luck, tom

 

 

Mike Testro
User offline. Last seen 1 week 11 hours ago. Offline
Joined: 14 Dec 2005
Posts: 4395

Hi Suleiman

If you cant open the projects in one file then you can't cross link.

Unless MSP has a much superior way of linking between files.

Best regards

Mike Testro

Suleiman Ali
User offline. Last seen 1 year 2 weeks ago. Offline
Joined: 8 Jun 2016
Posts: 3
Groups: None

Hi Mike,

 

Thanks for your detailed answer. It is a great workflow.

I alreday have , for eg, three project files : p1, p2 and p3

 

I want to insert only SOME activities from them into a new schedule called px.

This needs to be dynamically linked so copy paste is not an option.

Mike Testro
User offline. Last seen 1 week 11 hours ago. Offline
Joined: 14 Dec 2005
Posts: 4395

Hi Suleiman - Welcome to planning planet.

I Asta PowerProject you can have any number of open projects in one file and link tasks between projects.

When planning a new project I have a library of pre planned sections which I just copy - paste intothe master programme.

Whenever I have a completely new section of work I copy the section back into the library for when it is needed again.

Obviously each new import is checked and adjusted for the exigencies of the new project.

Using this method I can usually complete a tender programme in under 8 hours.

I suppose tis is similar to your Franenstein concept.

Best regards

Mike Testro