Finding out Multiple scenarios and options based on set requirements and combinations of data set

[mnty89]

Example data below to explain a little further-

Basically what I need to do is figure out a macro or a formula column which will calculate out the possible outcomes based on the data set that will find the consolidated versions possible.

Maximum weight for this example is 20,000
Maximum volume will be 100
Maximum spaces would be 10

I need to use the data below to find out all of the possibilities based on these requirements that I could combine the "Loads" to make sure they fall under the maximum or meet it. I just added the remaining based on the original column, but if that's not needed that's fine as well.

Any ideas or has anyone done this in a similar way for another application?

I'm hoping for something I can apply to a real life scenario on a broader scale for something currently being done manually.


[TABLE="width: 756"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Load[/TD]
[TD]Weight[/TD]
[TD]Volume[/TD]
[TD]Spaces[/TD]
[TD]Remaining Weight (Max 20000)[/TD]
[TD]Remaining Volume (Max 100)[/TD]
[TD]Remaining Spaces (Max 10)[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]10000[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]10000[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]15000[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]11000[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]9000[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]9000[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]11000[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]3000[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]17000[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]19500[/TD]
[TD="align: right"]94[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD="align: right"]6000[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]14000[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD="align: right"]8000[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]12000[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]700[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]19300[/TD]
[TD="align: right"]92[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]900[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]19100[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]5[/TD]
[/TR]
</tbody>[/TABLE]