## meaningful part numbers

## meaningful part numbers

(OP)

Howdy all,

So here is the question: I have A LOT of variations of parts to make using the configurations design table in solidworks. For those not familiar, columns list feature dimensions and rows are each unique configuration of a part... this allows for easy creation of multiple sizes of a single part. kind of like making an entire wrench set with 1 part model, where all you have to do is make a list on a table of every nominal hex size, and it automatically generates a part model for every size wrench in the list.

So my part has 4 basic dimensions... called t, Ø, s, r. What I was asked to do is make part numbers for the different size parts that are meaningful based upon the dimensions.

in example, I have a part that is made from the dimensions t=.090 Ø=.250 s=.500 and r=.750. My boss would like the part number to be 0092505007500 or something of similar... if I could figure out how to get excel to take the 4 dimension values of .090,.250,.5,.75 and dump it out into a singe cell and show 0092505007500 I would be a happy camper.

If it would be easier to have a legend equal to certain numbers to simplify the part numbers kind of like a car VIN so it would be a 4 digit part number... the sequence would be "tØsr" and each value would be given a letter (or dash number for those familiar with an hardware)... and end up with a number like "a7d9" which would accurately describe an individual part.

Hopefully that makes sense, if not, maybe that's why I'm having a hard time figuring it out because I don't even know how to ask! lol.

Thanks ahead of time.

Roark

So here is the question: I have A LOT of variations of parts to make using the configurations design table in solidworks. For those not familiar, columns list feature dimensions and rows are each unique configuration of a part... this allows for easy creation of multiple sizes of a single part. kind of like making an entire wrench set with 1 part model, where all you have to do is make a list on a table of every nominal hex size, and it automatically generates a part model for every size wrench in the list.

So my part has 4 basic dimensions... called t, Ø, s, r. What I was asked to do is make part numbers for the different size parts that are meaningful based upon the dimensions.

in example, I have a part that is made from the dimensions t=.090 Ø=.250 s=.500 and r=.750. My boss would like the part number to be 0092505007500 or something of similar... if I could figure out how to get excel to take the 4 dimension values of .090,.250,.5,.75 and dump it out into a singe cell and show 0092505007500 I would be a happy camper.

If it would be easier to have a legend equal to certain numbers to simplify the part numbers kind of like a car VIN so it would be a 4 digit part number... the sequence would be "tØsr" and each value would be given a letter (or dash number for those familiar with an hardware)... and end up with a number like "a7d9" which would accurately describe an individual part.

Hopefully that makes sense, if not, maybe that's why I'm having a hard time figuring it out because I don't even know how to ask! lol.

Thanks ahead of time.

Roark

## RE: meaningful part numbers

=A1 &B1 &C1 &D1

If you want to add a hyphen:

=A1 &"-" &B1 &C1 &D1

That is the simplest non-macro way of doing this. In my opinion. Unless i misunderstood your intent

## RE: meaningful part numbers

## RE: meaningful part numbers

Right on! The thing I'm fighting now is that with .090 and .1875 being a dimensions I'm using I wanted to pull out the decimal point... so I multiplied each cell by 1000. only problem now is that I have a 16 digit code. I need to figure out the dash number thing.

MintJulep... yup. I just made 140 permutations of the same part, with 3 variable dimensions based on an equation driven excel sheet. see picture.

Check out the left hand column which names the configuration.

## RE: meaningful part numbers

First column is the dimension value. Second column is an arbitrary identified.

VLOOKUP() becomes your friend.

You can also use the tables to feed drop-downs in cells for each dimension to make a part number builder.

## RE: meaningful part numbers

=Vlookup(A1, tlist,2) & Vlookup(B1, philist,2) & Vlookup(C1, slist,2) & Vlookup(D1, rlist,2)

Doug Jenkins

Interactive Design Services

http://newtonexcelbach.wordpress.com/

## RE: meaningful part numbers

http://newtonexcelbach.wordpress.com/2010/03/01/st...

Doug Jenkins

Interactive Design Services

http://newtonexcelbach.wordpress.com/

## RE: meaningful part numbers

## RE: meaningful part numbers

Beat me by 3 minutes!

Doug Jenkins

Interactive Design Services

http://newtonexcelbach.wordpress.com/

## RE: meaningful part numbers

not sure what the exact result you require, but something on the lines of:

=TEXT(VALUE(A1*1000&B1*1000&C1*1000&D1*1000),"000000000000")

is this of any use?

----------------------------------

Hope this helps.

----------------------------------

been away for quite a while

but am now back

## RE: meaningful part numbers

Sorry above formula not accurate

try

=TEXT((A1*1000),"000")&TEXT((B1*1000),"000")&TEXT((C1*1000),"000")&TEXT((D1*1000),"000")

----------------------------------

Hope this helps.

----------------------------------

been away for quite a while

but am now back

## RE: meaningful part numbers

I believe you can do this in AutoCAD by making a dynamic block with all of your variables. Make a table for it in ACAD and this should do it (?)

Back to spreadsheets.