You arrive at a new facility and have full admin rights with P6.2.1. You receive a data dump from an unknown database of about 25000 activities. You have Acitivity Description, Resource Name, Total Budget, Job step number of that particular job plan (1-xxx), Work Order number, Equipment type, Equipment Number, etc. There is a decent amount of 'scrubbing' to do within excel to get this data into shape in order to import into Primavera. Plus you need to create all dictionaries: Activity, Resource, Calendars, etc., Create Activity ID's,..etc., etc.
The budgets and resources are in this data dump, but every activity that has more than one resource only has one activity with the multiple resources listed in the same row and the TOTAL budget for that activity. (the duration is the same for all of the resources for that particular Activity)
Would anybody like to take a W.A.G. of how long it would take to import all of this into Primavera from this data dump?
Server is performing fairly well, so that isn't too big of a hurdle. And you have full admin rights as well.
So to recap.... You have a rough data dump of about 25000 activities that need to get imported into Primavera and I would like a W.A.G. of how long you would tell the PM it will take you just to get the activities into Primavera. I know there are a lot of variables that can dictate the timeline of getting this accomplished, but use your imagination on this one!
Feedback is greatly appreciated!
Shane