Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Newbie to charts question - projecting values between data points | Excel Discussion (Misc queries) | |||
Data Table Question | Charts and Charting in Excel | |||
Data Validation list selection question | Excel Worksheet Functions | |||
Parsing Data w/ a Formula (another question) | Excel Worksheet Functions |