Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Building a repetetive project file

Building a repetetive project file

Building a repetetive project file

I need to build a project schedule which includes enterprise level portions (no issues), and then a repetetive task list for each of 15 locations. Because the 15 locations are identical (for now), I'm trying to find a way to avoid buidling them individually.

I can easily copy and paste tasks and durations, but so far I can't figure out to get predecessors to be unique to each instance. If I export the generic version, when I import / append, all task link back to the original list, instead of to the new line items.

I tried buiding it in Excel and importing, but duration all came in as 1 day. I'm definetly spending too much time trying to avoid typing it all in, but I'm concerned if I manually build all these links, I risk errors.

Anyone know a robust method to do this?
Replies continue below

Recommended for you

RE: Building a repetetive project file

I have an answer. Very newbie question, I'm a bit embarrassed, but sometimes the easy things are the ones without a reference to look up.

In case anyone else has this issue, if you collaps the topline task, then copy paste, everything underneath it will paste in magically linked and ready to go!

RE: Building a repetetive project file

I believe what Sue said is what I've done as well, I've rolled up the top-level project summary and copied that which brought over the predd/succ links, then adjusted durations, task names, etc, accordingly for each individual project.

Another option if this is truly repetitive vs a one-time setup is to build a template which is what we use corporate wide, same look and feel for all our "official" projects which meet specified thresholds for time/cost. In other words you'd only want to do this on a big enough project (hence thresholds for determining which). Nice thing about templates is the holiday calendar can become a standard along with specific Gantt pane preferences. Our company does not use MS Project out of the box because of their lacking Gantt bars setup. We've built a template which works for our NASA preference thus saving tons of time on setting up individual projects.

RE: Building a repetetive project file

Actually I do not understand clearly what you want to achieve. Do you mean that you have 15 repetitive tasks, one for each location? It looks as if you have different resources. Do you mean per repetitive task(series)or for the individual tasks within the various overall repetitive tasks? What did you exactly do in Excel?
Perhaps it might be useful to upload an example [maybe both MS Project and Excel] with a precise explanation what you want to achieve. It could be wise also to explain your goal, independent from the track you have chosen now in order to meet it.

Why an easy solution if you can make it complicated?
Greetings from the Netherlands

RE: Building a repetetive project file

Lost interest? Or no need to react to people trying to help you?

Why an easy solution if you can make it complicated?
Greetings from the Netherlands

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close