Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 6th 05, 09:36 PM
 
Posts: n/a
Default Multi - Level Question involving Data Mapping and Formulation

First of all, to get this out of the way, I am completely ignorant to
the power of excel. I am a basic user with an expert level task to
complete.

I am exporting a file out of MS Project and am capturing the Unique ID,
Task Name, Unique Pred, Unique Succ, Duration Columns (and so on and so
on). The purpose for exporting the uniq columns is because I have 3
integrated schedules with external logic between them. My goal is to
import these schedules into Primavera. Primavera will not grab the
external logic within these projects. I've found a way to do this but
it involves prep'ing the data in excel.

After I filter for tasks that have external links I get stuck. What I
need to do next is change the external pred/succ ID# from
c:\project\555 to G555. To make this more complicated, I need to create
a duplicate of the task to make sure that each task has only one pred
or only one succ.

Here is an example:
BEFO
Task: Please help Pred(s)C:\Project1\4, C:\Project2\7, 45
Succ (s) C:\Project1\8, 89


AFTER: (excel view)
Task: Please help Pred: G4
Task: Please help Pred: C7
Task: Please help Pred: I45
Task: Please help Succ: G8
Task: Please help Succ: I89

Should I do a global find and replace first? (to add the G's, C's, and
I's) Once that is done, is there a way I can automate duplicating the
task with a one to one relationship with a pred or succ?

Sorry for the long sob story, hope somebody out there can help me out.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Newbie to charts question - projecting values between data points 38N90W Excel Discussion (Misc queries) 3 January 6th 05 06:15 AM
Data Table Question SmokyMtnzz Charts and Charting in Excel 3 December 6th 04 06:48 PM
Data Validation list selection question Bob Wall Excel Worksheet Functions 2 December 4th 04 05:51 PM
Parsing Data w/ a Formula (another question) carl Excel Worksheet Functions 2 December 3rd 04 07:51 PM


All times are GMT +1. The time now is 08:03 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017