Programming Questions? Ask a Programmer for Answers ASAP
can you explain the real world application it is being used for. that would help me understand the problem a bit better and i can let you know if i can do it and how
so you would want a box that had larger dimensions in each category than the item itself but as small as possible or within a certain number of inches in any direction ?
probably the second one
than you could make some sort of a query that ran each possible box size against each part and flag how many parts it would be acceptable for. then look at the top boxes on the list. you would still probably want to look over them manually so as to get yourself a good spread otherwise if you have 8000 items that are smaller than a foot and 200 that are larger your top 8 are all going to be under a foot so its not a great solution.
do you have a list of actual dimensions for each of your products because if you are just going on any possible dimensions its also not very useful. the shipping companies already have done that calculation and you can just buy one of everything they sell.
do you know what you are shipping ? i doubt that you have a million products so you can simplify it that way how many do you have and do you have a list of them with the dimensions in separate easy to read fields. ie just the number one in each or 3 fields for L H W
if you have a list with those 3 fields and a field showing how many you shipped over any particular period that you think is representitive of your business and a list of available standard box sizes i can try to put something together for you but i dont think excel will do it easily and i would probably want about 100 dollars to do it.
ok i didnt realize that you could make the boxes any size you want. that makes it a little different but i think you are making it too difficult on yourself. maybe just create groups of anything within 4 inches of each other in every dimension and see what groups you wind up with.