NX7.5 Extursions for Assembly line

[SDETERS]

We have a need to model up an assembly line. We use aluminum extrustions that come in 20ft lengths. Now We can have any lengths in our models say from .5 inch to 20 feet long. We are using teamcenter. We do not want to use deformable parts due to the fact we want to call this out on the B.O.M. with the appropriate length. I do not want to have many parts of the same length with different part numbers. What would be the best way to handle this in NX and teamcenter?

 

[TheeCircle]

Here is the photo of the spread sheet.

 

[TheeCircle]

Here is a photo of the files required.

 

[SDETERS]

Thanks I will give this a try. Thanks for all of the feedback. It has been really really helpfull.