In case anyone is interested,
I wasn't able to figure out a formula, but I did manage to write the code to have all the possible combinations listed out.
Check out the attached spreadsheet. The marbles in the bag are listed out and you hit ctrl+shift+A. This generates a list of all...
Mandlebra that article looks very interesting. I think there may be some similarities here. I just wish I knew more about math and computer programming. Aside from having a good understanding of logic, the only thing I know how to program is a CNC machine.
I believe I should probably...
Mandelbra thanks for taking an interest.
Since you're curious, I work for a company that manufactures bonded composite panels. These panels get bonded in a multi-opening press. We have several different part numbers of panels we bond. Different panels may be combined and ran in the same...
Sounds like my initial dream of having a neat little formula is going up in smoke. lol
For what I'm actually trying to accomplish I will need to write some VB code to have excel generate a list of all the possible combinations.
However, I was hoping to use this marble example to come up...
I've found out why the second half of the equation doesn't always work...
The attached spreadsheet has an example detailing 4 marbles drawn from a bag with 4 different colors.
The method employed thus far has been to count the combinations that cannot exist due to qty constraints for...
Thanks viraltux, you've been a huge help. There's no way I could have solved this one without some expertise. Hopefully I'll be able to fill in the blanks. :).
Viraltux,
Thanks for the reply. I sincerely appreciate your help with this. I've plugged your formula into excel and it seems to work well in most cases, but there are some instances where it does not.
I'll admit that I'm no mathematician and I may have made some mistakes translating your...
Hello everyone,
I'm new to the forum and have an engineering problem I've been trying to solve for my job. The actual problem is rather hard to describe but it can best be explained with the following analogous scenario.
Suppose I had a bag containing 3 red, 2 blue, and 1 green marbles...