Calling all experts: Rebuilding a 1400 line IMS.... Suggestions

T

trpy2k

I am the recipient of an IMS containing nearly 1400 Summary and Detail Tasks.
The problems I have are that there looks like there is some form of
corruption in the file and I after 50+% completion, I have to insert new
"work" numbers. I have tried using various methods to easily remove the
corruption (saving as another file and opening that new file in Project) but
has been unsuccessful and breaks the schedule more.

The project has already been baselined, and we are over 50% complete the
project. Here in lies the main trouble. The IMS is currently resourced with
a single resource per detail Task (the Assignment owner) since Leveling the
IMS is not a priority. Also, the hammock tasks are usurping the Critical
Path. (my solution is to add a task that completes 2d prior to actual end of
project and hammock to that in order to view an accurate critical path)


My current thought process is to:
1. Copy tasks and WBS to Excel, and Paste back into the New Project File.
2. Set to Fixed Work (as these are the numbers that CAN NOT change)
3. Reset the Dependencies and Hammock tasks
4. Insert the Resources
5. Insert the Fixed Work Numbers
6. Insert the Duration (with the assumption that this SHOULD change the
resource usage %.
7. Re-baseline
8. Insert the Old Baseline Numbers
9. Insert the "Actual Start" then "Actual Finished" Dates
10. Insert the "Actual Work" then the "Remaining Work" #'s
11. Verify the % Work Complete to be accurate

Does this sound right to all of you?
 
R

Rod Gill

For file corruption see http://project.mvps.org/faqs.htm and FAAQ #43

Use method 2 for Project 2003 or earlier and method 3 for Project 2007.
--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com




trpy2k said:
I am the recipient of an IMS containing nearly 1400 Summary and Detail
Tasks.
The problems I have are that there looks like there is some form of
corruption in the file and I after 50+% completion, I have to insert new
"work" numbers. I have tried using various methods to easily remove the
corruption (saving as another file and opening that new file in Project)
but
has been unsuccessful and breaks the schedule more.

The project has already been baselined, and we are over 50% complete the
project. Here in lies the main trouble. The IMS is currently resourced
with
a single resource per detail Task (the Assignment owner) since Leveling
the
IMS is not a priority. Also, the hammock tasks are usurping the Critical
Path. (my solution is to add a task that completes 2d prior to actual end
of
project and hammock to that in order to view an accurate critical path)


My current thought process is to:
1. Copy tasks and WBS to Excel, and Paste back into the New Project File.
2. Set to Fixed Work (as these are the numbers that CAN NOT change)
3. Reset the Dependencies and Hammock tasks
4. Insert the Resources
5. Insert the Fixed Work Numbers
6. Insert the Duration (with the assumption that this SHOULD change the
resource usage %.
7. Re-baseline
8. Insert the Old Baseline Numbers
9. Insert the "Actual Start" then "Actual Finished" Dates
10. Insert the "Actual Work" then the "Remaining Work" #'s
11. Verify the % Work Complete to be accurate

Does this sound right to all of you?

__________ Information from ESET Smart Security, version of virus
signature database 4631 (20091123) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4631 (20091123) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
T

trpy2k

Rod,

Thank you for your response. I have read many of your responses across this
board and appreciate the tutorials that you sent me in the link. I actually
came across that site as a response to another post on this MB, and tried the
method. Alas, I am sad to say that it was unsuccessful. I think the problem
is somewhere between corruption and improper setup of the Project file (lack
of accurate work & resource information) that is the true culprit. However,
when putting it all back into the schedule, we see the start date move left
by 4 years, and the finish date move right by 13 years. Not ideal, and I
think the best way for me to fix this whole schedule is to get it right from
the start. I have never done that with a schedule of this size, and as the
only scheduler, I thought that I would ping the board to see if my logic was
correct and that I would not be causing myself additional work.

I will try to post back to let everyone know how it goes.

Thanks again,

Thomas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top