Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-06-2016, 06:42 PM
seanpears99 seanpears99 is offline Master project - subprojects and key milestones Windows 7 64bit Master project - subprojects and key milestones Office 2007
Novice
Master project - subprojects and key milestones
 
Join Date: Oct 2011
Posts: 11
seanpears99 is on a distinguished road
Default Master project - subprojects and key milestones

Hi all
Just started a new gig as an analyst whereby I am automating project reporting through VBA, Project and Excel. After 3 days the Master Scheduler quit and I have had to take on that role until someone else is found.
I have done the role before but there is nothing worse than picking up someone elses work so I just wanted to clarify a couple of things.
We are using 2016 Pro, and around 50 projects which were created by the master scheduler. Lowest level first, There is a key milestone section in each of the (to be subprojects) linked to relevant tasks. (1st duplication of effort scenario as any completion or percentage updates have to be carried up to the linked milestones (no hammocking).


Subsequently, each of these projects has been inserted into a master project, with each of the sub project key milestones, linked to another section within the master schedule (2nd duplication of effort) as any updates to the subprojects is not carried up to the master section which was created manually.
In terms of removing this triplication of manual updates, I would normally, tag each key milestone in each sub project as Level 1, 2, or 3), insert them into the Master and leave it at that and use a filter to gain a similar representation.
Isnt this the way to normally set up a master project and hence every update is driven from the lower level schedules?
Cheers
S
Reply With Quote
  #2  
Old 12-14-2016, 02:14 PM
JulieS JulieS is offline Master project - subprojects and key milestones Windows 7 64bit Master project - subprojects and key milestones Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

In a quick read it does appear that the former scheduler was approaching it in a fairly convoluted fashion. Insert the subprojects, and apply filters to show what you need.

If would also suggest only updating the subprojects and let those updates roll up to the master. The best option is to create a unlinked master for reporting. This can be automated using VBA to make the consolidation faster.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Master project - subprojects and key milestones Moving folder of master and subprojects issues wampa Project 1 07-15-2016 05:19 PM
Master project - subprojects and key milestones Master and Sub Project Management OTPM Project 12 06-15-2016 01:54 AM
Export Milestones from excel to Project 2010 Manoj Project 1 12-31-2015 02:45 PM
Milestones Filter to show Milestones within 2 months pmgreen Project 7 08-14-2014 09:39 AM
Master Project Weekly Summary Issue east3rd Project 3 06-03-2014 02:40 PM


All times are GMT -7. The time now is 02:38 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft