[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 726
  • Last Modified:

Combinations/Permutations

Greetings Everyone.  I have attached a workbook that I created to breakout unique Part Numbers Based on Size Options and Color Codes.  It seems pretty clunky so I know there has to be a better way to code this than what I have done.  Can someone provide some feedback for learning here?  Thanks!
Permutations1.7.3.xls
0
Christopher Wright
Asked:
Christopher Wright
  • 3
  • 2
  • 2
  • +1
3 Solutions
 
d-glitchCommented:
You need all the data (and so do we).

What are the possible colors and sizes?
Do you need a serial number as well?  Or do all the red, size 10 shirts have the same Part No.
0
 
d-glitchCommented:
How many base part numbers are there?

Do you want the part number to make sense:   SHRT-10-RED  vs  314-10-02
0
 
Martin LissOlder than dirtCommented:
The recursive function shown in post #9 here looks interesting.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Christopher WrightDirector, Service DeliveryAuthor Commented:
Hi d-glitch.  The base part numbers are dynamic.  They vary depending on the manufacturer we are dealing with.  The same applies to the Size Options and Color Codes.  Maybe I should have went with a free text for all columns.  Would that have been a better approach?

Also, I should not have placed the word permutation in the title since I am really going after combinations.  None of the values change, I am simply looking for a concatenated list that has all three columns combined in every possible combination.
0
 
Martin LissOlder than dirtCommented:
Did you try to adapt that recursive function to your code?
0
 
Christopher WrightDirector, Service DeliveryAuthor Commented:
I am still tinkering with it a bit.
0
 
RobOwner (Aidellio)Commented:
The easiest way to achieve this would to use a database.  Have tables for each of the elements eg product code, colour, size etc

Then by doing a simple SELECT query would bring in all combinations

SELECT PartNo, Size, Color FROM tblParts, tblSizes, tblColors
0
 
Christopher WrightDirector, Service DeliveryAuthor Commented:
Great help from everyone.  I took a little from each and ultimately finished with a database.  Thanks for all of your help Gents!
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now