Part Number Configurator

Sounds like you'll have to make your own. Then it'll be just how you want it.

Here are some:

1. Part Number Generator | Flow-Rite The Millennium Plus part number generator allows you to create a kit part number by answering a few questions about the type of battery you have.www.flow-rite.com/.../millennium-plus/part-number-generator

1. Part Number Generator - Windows - Whirlpool Forums Hi there, I work for Electronic Manufacturing company and looking to find some software that automatically Generatates new part numbers if we put in a certain cforums.whirlpool.net.au/archive/1325575

1. DMC-41x3 Part Number Generator - Galil: We Move The World Click here to REGISTER. Register for full access to Galil's on-line tutorials, product manuals, downloads, and more.www.galilmc.com/products/dmc-41x3-part-number.php

1. Onan Parts Onan Generator Parts and Breakdowns ... - You may order online by typing in the part number in the search box below.generator-parts.com/onan

1. PDMWE Number Generator - Part Deaux

1. DMC-40x0 Part Number Generator - Galil: We Move The World

If

1000000000 means industrial

12000000 means material x

530000 means vendor y

2091 means whatever

then you can add them up to get the automated part number onto a spread sheet

I recommend instead a Drawings system and have all the specs on the drawings.

All available sources of supply may also be entered on the drawings.

Because you need an ideal mental memory in the system.

http://en.wikipedia.org/wiki/Part_number

Quote :

A business using a part will often use a different part number than the various manufacturers of that part do.

For example, when referring to a "Hardware, screw, machine, 4-40, 3/4" long, panhead, Phillips":

• Manufacturer A uses part number "4-40-3/4"-pan-phil",
• Manufacturer B uses part number "100-440-0.750-3434-A".
• Manufacturer C uses part number "TSR-1002".

The business using such a screw may buy screws from any of those manufacturer, because each supplier manufactures the parts to the same specification. To identify such screws, the user doesn't want to use any of those manufacturer's part numbers, because

• it would imply that one manufacturer is acceptable and the other ones aren't, and,
• it wishes to use a consistent format for the part numbers of all of the parts it uses.

Therefore, the user devises its own part numbering system. In such a system, the user may use the part number "HSC0424PP" for that screw

Unquote:

Are you looking to BUILD part numbers, or DISECT them?

If the latter,

Use Substring to extract a section of the part#

assume the full part number is a 1 digit integer stored in cell d2

let d3 = TEXT(d2,"0000000000")

assume the part# in text form is stored in cell d3

Let cell d4 = MID ( Text , Start_num , Num_chars )

Let cell d4 = MID ( d3 , 1 , 2 ) extracts 1st & 2nd characters

Let cell d5 = MID ( d3 , 3 , 2 ) extracts 3rd & 4th characters

Let cell d6 = MID ( d3 , 5 , 4 ) extracts 5th through 8th characters

continue as necessary, but for each segment of the full part number, do a lookup to retrieve the text, from sections of tables stored elsewhere, and place them in .. let's say cells f4, f5, & f6 for the above.