+ Reply to Thread
Results 1 to 6 of 6

Creating Automotive parts kits.

  1. #1
    Registered User
    Join Date
    06-29-2018
    Location
    Chicago
    MS-Off Ver
    Office 2007
    Posts
    3

    Creating Automotive parts kits.

    Hi All and thank you for any help in advance,

    I'm trying to group different parts much like a Pivot table but need to return the text values in my spread sheet. My spread sheet has the vehicle fitment information for the individual components and the components themselves. So for a particular vehicle I mat have 2 brake pad sets lets call them (1BP) and (2BP) and 2 variations of the rotor and lets call them (1BR) and (2BR). I need to group the parts and have each grouping in its own row. Some vehicles may have 3 different rotors and 3 different pads so it has to be a little flexible

    Thanks for any help you can offer.

    Willie
    Attached Files Attached Files
    Last edited by wtwos; 06-29-2018 at 04:49 PM.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,067

    Re: Creating Automotive parts kits.

    I think you are going to have to explain to us how you got 1BP, 2BP, C type Clip etc. from the data.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Registered User
    Join Date
    06-29-2018
    Location
    Chicago
    MS-Off Ver
    Office 2007
    Posts
    3

    Re: Creating Automotive parts kits.

    The part number of the brake pad is dependent on what caliper was used during the assembly process so we identify them by using the clip style. the rotor is ether 330 or 350mm depending on the assembly so the possible kits would be
    1BP & 1BR, (C type clip pads & 350mm rotors)
    1BP & 2BR, (C type clip pads & 330mm rotors)
    2BP & 1BR, (D type clip pads & 350mm rotors)
    2BP & 2BR, (D type clip pads & 330mm rotors)

    is there a way to accomplish this from a spreadsheet? The part numbers are just an example not real partnumbers.

  4. #4
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,067

    Re: Creating Automotive parts kits.

    I'm looking at the actual data sheet. I see nothing about clip style nor do I see 1BP or 2BP. I have no idea how you are pulling rows. Once I get a row, I can parse out the 330 or 350 mm.

  5. #5
    Registered User
    Join Date
    06-29-2018
    Location
    Chicago
    MS-Off Ver
    Office 2007
    Posts
    3

    Re: Creating Automotive parts kits.

    Quote Originally Posted by dflak View Post
    I'm looking at the actual data sheet. I see nothing about clip style nor do I see 1BP or 2BP. I have no idea how you are pulling rows. Once I get a row, I can parse out the 330 or 350 mm.
    The sample would be much easier to work with. i can apply the formula to the actual data. The complete data sheet is over 800K rows.

    I need a way to insert lines and create all possible combinations from the data in the partterminology column. I created a pivot table in sheet2 you can check the actual values there. the sample was just an example of how it needed to be done.

  6. #6
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,067

    Re: Creating Automotive parts kits.

    Is this what you want (see Sheet 2). Sheet 3 is a grossly simplified version. Are you sure you need all those things concatenated in column BC? Being a non-mechanical type myself, I don't see how engine or fuel system or transmission should affect what kind of brakes a vehicle has.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating a Parts list
    By Thomas Morris in forum Excel General
    Replies: 2
    Last Post: 03-19-2018, 01:01 PM
  2. Replies: 3
    Last Post: 08-23-2017, 07:29 PM
  3. Remove Kit components when Kits are created
    By BowtieAccountant in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2014, 02:02 PM
  4. Replies: 1
    Last Post: 12-16-2013, 02:30 PM
  5. Replies: 3
    Last Post: 10-23-2012, 06:17 AM
  6. creating a parts list
    By artj in forum Excel General
    Replies: 3
    Last Post: 07-29-2012, 06:42 PM
  7. Creating a used parts list?
    By danjstock in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-17-2008, 10:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1